senate_exp
8 rows where city = "Chicago" and state = "IL"
This data as json, CSV (advanced)
Suggested facets: District, candidate_name, Party, recipient, zip, expenditure_type
Link | rowid ▼ | District | candidate_name | Party | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
339 | 339 | Senate District 03 | Nick Hinrichsen | Democratic | 3881.59 | 11/16/22 | The Sexton Group | Chicago | IL | 60654 | Advertising | |
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 | |
3692 | 3692 | Senate District 24 | Kyle Mullica | Democratic | 6987.5 | 11/18/22 | The Sexton Group | Chicago | IL | 60654 | Consultant & Professional Services | |
3989 | 3989 | Senate District 27 | Tom Sullivan | Democratic | 5010.0 | 11/28/22 | The Sexton Group | Chicago | IL | 60654 | Office Equipment & Supplies | Goto Paid Phones |
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 );