state_exp
5 rows where expenditure_type = "Food, Beverages and Meals" and state = "IL"
This data as json, CSV (advanced)
Suggested facets: District, candidate_name, recipient
Link | rowid ▼ | District | candidate_name | Party | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1648 | 1648 | Secretary of State | Jena Griswold | Democratic | 26.41 | 2/16/22 | Grubhub | Chicago | IL | 60602 | Food, Beverages and Meals | |
1690 | 1690 | Secretary of State | Jena Griswold | Democratic | 24.0 | 2/25/22 | Grubhub | Chicago | IL | 60602 | Food, Beverages and Meals | |
6696 | 6696 | Governor | Jared Polis | Democratic | 32.99 | 1/7/19 | Grub Hub | Chicago | IL | 60602 | Food, Beverages and Meals | Meal |
6803 | 6803 | Governor | Jared Polis | Democratic | 24.09 | 5/6/19 | Grub Hub | Chicago | IL | 60602 | Food, Beverages and Meals | |
6805 | 6805 | Governor | Jared Polis | Democratic | 52.71 | 5/7/19 | Grub Hub | Chicago | IL | 60602 | Food, Beverages and Meals |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "state_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 );