USA Facts organized a Hackathon to collect data on environmental legislation. I contributed by collecting and cleaning data on state environmental legislation. The final dataset is saved here: all_state_leg_cleaned.csv
. It contains the following variables:
leg_id
: legislation id (states can be identified using the state acronym)leg_title
: title of legislationleg_author
: main author and additional authorsleg_status
: status of legislationleg_summary
: summary of legislationleg_topics
: topics of legislationhistory
: steps taken by legislation (one row per step) --- they are ordered using thehistory_seq
variablehistory_seq
: step numbers for thehistory
variableyear
The R code used to clean the raw files is called clean_up_script
.