JSON and RegEx
Budget: $30 – $250 USD
assignments that utilizes data from https://data.colorado.gov/Lobbyist/Bill-Information-and-Position-with-Income-of-Lobby/gxnn-wthy. The actual data will be downloaded in real time from https://data.colorado.gov/resource/gxnn-wthy.json.
You will be responsible for monitoring the lobbying activities for seven lobbyists in the data set (you will select your lobbyists in the first step of this assignment).
This Assignment
On this assignment you will use your knowledge of networked programs, JSON and RegEx to download a set of Lobbyist data and write that data to a file. The data you will be downloading will include the fields seen below (the fields in BOLD are found in every record - the remaining fields are only present if some cases):
lobbyistlastname, lobbyistfirstname, lobbyistaddress1, lobbyistaddress2, lobbyistcity, lobbyiststate, lobbyistzip, primarylobbyistid, annuallobbyistregistrationid, officialstatelobbyist, clientname, clientlastname, clientfirstname, clientmiddlename, clientsuffix, clientaddress1, clientaddress2, clientcity, clientstate, clientzip, billinformationandposition, reportmonth, fiscalyear, reportduedate, clientbusinessdescription, clienttypeofbusiness, clientstatus, clientstartdate, clientenddate, incomeamount, dateincomereceived
Below is a set of sample data for one lobbying activity from the online data:
lobbyistlastname "Biehle"
lobbyistfirstname "Ryan"
lobbyistaddress1 "2224 S. Fraser St."
lobbyistaddress2 "Unit 1"
lobbyistcity "Aurora"
lobbyiststate "CO"
lobbyistzip "80203"
primarylobbyistid "20135029531"
annuallobbyistregistrationid "20195023307"
officialstatelobbyist "N"
clientname "Colorado Academy of Family Physicians"
clientaddress1 "2224 S. Fraser St."
clientaddress2 "Unit 1"
clientcity "Aurora"
clientstate "CO"
clientzip "80014"
billinformationandposition "HB 1001 Supporting 01/23/2020 06/30/2020 Nicotine Product Regulation2, HB 1041 Supporting 01/23/2020 06/30/2020 Physician Assistants Financial Responsibility Requirements, HB 1065 Supporting 02/13/2020 06/30/2020 Harm Reduction Substance Use Disorders,..."
reportmonth "February"
fiscalyear "2020"
reportduedate "2020-03-16T00:00:00.000"
clientbusinessdescription "Professional Association"
clientstatus "Active"
clientstartdate "2016-01-01T00:00:00.000"
incomeamount "748.0"
dateincomereceived "2019-02-28T00:00:00.000"
You are tasked with getting data for one Colorado lobbyist and displaying all of the income received and the date it was received.
You also want to use your regular expression skills understand "something" about the bills the lobbyist are Supporting or Opposing.
You will download your Lobbyist Data from https://data.colorado.gov/resource/gxnn-wthy.json adding parameters to restrict download to a single primarylobbyistid
Write all your data to a local text file as valid JSON data.
20025002073 - Lobbyist to Collect Data For
You will be responsible for monitoring the lobbying activities for seven lobbyists in the data set (you will select your lobbyists in the first step of this assignment).
This Assignment
On this assignment you will use your knowledge of networked programs, JSON and RegEx to download a set of Lobbyist data and write that data to a file. The data you will be downloading will include the fields seen below (the fields in BOLD are found in every record - the remaining fields are only present if some cases):
lobbyistlastname, lobbyistfirstname, lobbyistaddress1, lobbyistaddress2, lobbyistcity, lobbyiststate, lobbyistzip, primarylobbyistid, annuallobbyistregistrationid, officialstatelobbyist, clientname, clientlastname, clientfirstname, clientmiddlename, clientsuffix, clientaddress1, clientaddress2, clientcity, clientstate, clientzip, billinformationandposition, reportmonth, fiscalyear, reportduedate, clientbusinessdescription, clienttypeofbusiness, clientstatus, clientstartdate, clientenddate, incomeamount, dateincomereceived
Below is a set of sample data for one lobbying activity from the online data:
lobbyistlastname "Biehle"
lobbyistfirstname "Ryan"
lobbyistaddress1 "2224 S. Fraser St."
lobbyistaddress2 "Unit 1"
lobbyistcity "Aurora"
lobbyiststate "CO"
lobbyistzip "80203"
primarylobbyistid "20135029531"
annuallobbyistregistrationid "20195023307"
officialstatelobbyist "N"
clientname "Colorado Academy of Family Physicians"
clientaddress1 "2224 S. Fraser St."
clientaddress2 "Unit 1"
clientcity "Aurora"
clientstate "CO"
clientzip "80014"
billinformationandposition "HB 1001 Supporting 01/23/2020 06/30/2020 Nicotine Product Regulation2, HB 1041 Supporting 01/23/2020 06/30/2020 Physician Assistants Financial Responsibility Requirements, HB 1065 Supporting 02/13/2020 06/30/2020 Harm Reduction Substance Use Disorders,..."
reportmonth "February"
fiscalyear "2020"
reportduedate "2020-03-16T00:00:00.000"
clientbusinessdescription "Professional Association"
clientstatus "Active"
clientstartdate "2016-01-01T00:00:00.000"
incomeamount "748.0"
dateincomereceived "2019-02-28T00:00:00.000"
You are tasked with getting data for one Colorado lobbyist and displaying all of the income received and the date it was received.
You also want to use your regular expression skills understand "something" about the bills the lobbyist are Supporting or Opposing.
You will download your Lobbyist Data from https://data.colorado.gov/resource/gxnn-wthy.json adding parameters to restrict download to a single primarylobbyistid
Write all your data to a local text file as valid JSON data.
20025002073 - Lobbyist to Collect Data For