senate_exp
5 rows where expenditure_type = "Travel & Lodging" and state = "IL"
This data as json, CSV (advanced)
Suggested facets: District, candidate_name, Party, recipient, zip
Link | rowid ▼ | District | candidate_name | Party | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
916 | 916 | Senate District 04 | Mark Baisley | Republican | 11.5 | 11/9/22 | Parkwhiz | Chicago | IL | 60661 | Travel & Lodging | Parking |
1429 | 1429 | Senate District 08 | Matt Solomon | Republican | 26.35 | 7/26/22 | Parking.Com | Chicago | IL | 60601 | Travel & Lodging | |
4889 | 4889 | Senate District 34 | Julie C. Gonzales | Democratic | 35.0 | 12/6/22 | United Airlines | Chicago | IL | 60606 | Travel & Lodging | Checked Bag For Trip To State Innovation Exchange Conference |
4955 | 4955 | Senate District 34 | Julie C. Gonzales | Democratic | 561.18 | 6/17/19 | The Blackstone Hotel | Chicago | IL | 60605 | Travel & Lodging | Hotel During Women In Government Conference |
4994 | 4994 | Senate District 34 | Julie C. Gonzales | Democratic | 379.6 | 8/28/19 | United Airlines | Chicago | IL | 60606 | Travel & Lodging | Plane Tickets From Denver To New York City For Six/National Institute Of Reproductive Health Conference |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "senate_exp" ( "District" TEXT, "candidate_name" TEXT, "Party" TEXT, "expenditure_amount" REAL, "expenditure_date" TEXT, "recipient" TEXT, "city" TEXT, "state" TEXT, "zip" TEXT, "expenditure_type" TEXT, "explanation" TEXT );