Lookup table

library(legiscanrr)

names(lookup_table)
#> [1] "stateID"          "billStatusDict"   "billProgressDict"
#> [4] "billTypeDict"     "billTextTypeDict" "billSponsorDict" 
#> [7] "mimeTypeDict"

States ID

head(lookup_table$stateID)
#> # A tibble: 6 x 3
#>   state_id state state_name
#>      <int> <chr> <chr>     
#> 1        1 AL    Alabama   
#> 2        2 AK    Alaska    
#> 3        3 AZ    Arizona   
#> 4        4 AR    Arkansas  
#> 5        5 CA    California
#> 6        6 CO    Colorado

tail(lookup_table$stateID)
#> # A tibble: 6 x 3
#>   state_id state state_name     
#>      <int> <chr> <chr>          
#> 1       47 WA    Washington     
#> 2       48 WV    West Virginia  
#> 3       49 WI    Wisconsin      
#> 4       50 WY    Wyoming        
#> 5       51 DC    Washington D.C.
#> 6       52 US    US Congress

Bill status ID

knitr::kable(lookup_table$billStatusDict)

status_id	status_desc
0	NA
1	Introduced
2	Engrossed
3	Enrolled
4	Passed
5	Vetoed
6	Failed

Bill progress ID

knitr::kable(lookup_table$billProgressDict)

event_id	event_desc
1	Introduced
2	Engrossed
3	Enrolled
4	Passed
5	Vetoed
6	Failed
7	Override
8	Chaptered
9	Refer
10	Report Pass
11	Report DNP
12	Draft

Bill type ID

knitr::kable(lookup_table$billTypeDict)

bill_type_id	bill_type	bill_type_name
1	B	Bill
2	R	Resolution
3	CR	Concurrent Resolution
4	JR	Joint Resolution
5	JRCA	Joint Resolution Constitutional Amendment
6	EO	Executive Order
7	CA	Constitutional Amendment
8	M	Memorial
9	CL	Claim
10	C	Commendation
11	CSR	Committee Study Request
12	JM	Joint Memorial
13	P	Proclamation
14	SR	Study Request
15	A	Address
16	CM	Concurrent Memorial
17	I	Initiative
18	PET	Petition
19	SB	Study Bill
20	IP	Initiative Petition
21	RB	Repeal Bill
22	RM	Remonstration
23	CB	Committee Bill

Bill text type ID

knitr::kable(lookup_table$billTextTypeDict)

bill_text_type_id	bill_text_type_desc
1	Introduced
2	Committee Substitute
3	Amended
4	Engrossed
5	Enrolled
6	Chaptered
7	Fiscal Note
8	Analysis
9	Draft
10	Conference Substitute
11	Prefiled
12	Veto Message
13	Veto Response
14	Substitute

Sponsor type ID

knitr::kable(lookup_table$billSponsorDict)

sponsor_type_id	sponsor_type
0	Sponsor (Generic / Unspecified)
1	Primary Sponsor
2	Co-Sponsor
3	Joint Sponsor