state_exp
19 rows where Party = "Republican" and state = "IL"
This data as json, CSV (advanced)
Suggested facets: District, candidate_name, expenditure_amount, expenditure_date, recipient, city, zip, expenditure_type, explanation
Link | rowid ▼ | District | candidate_name | Party | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
3208 | 3208 | Governor | Heidi Ganahl | Republican | 226.5 | 1/18/22 | United Airlines | Chicago | IL | 60601 | Other | 7610 ∑ Air/Bus/Train Travel |
3335 | 3335 | Governor | Heidi Ganahl | Republican | 457.2 | 2/25/22 | United Airlines | Chicago | IL | 60601 | Other | 7610 ∑ Air/Bus/Train Travel |
3336 | 3336 | Governor | Heidi Ganahl | Republican | 457.2 | 2/25/22 | United Airlines | Chicago | IL | 60601 | Other | 7610 ∑ Air/Bus/Train Travel |
3380 | 3380 | Governor | Heidi Ganahl | Republican | 519.2 | 3/7/22 | United Airlines | Chicago | IL | 60601 | Other | 7610 ∑ Air/Bus/Train Travel |
3420 | 3420 | Governor | Heidi Ganahl | Republican | 90.0 | 3/16/22 | United Airlines | Chicago | IL | 60601 | Other | 7610 ∑ Air/Bus/Train Travel |
3421 | 3421 | Governor | Heidi Ganahl | Republican | 90.0 | 3/16/22 | United Airlines | Chicago | IL | 60601 | Other | 7610 ∑ Air/Bus/Train Travel |
3483 | 3483 | Governor | Heidi Ganahl | Republican | 247.2 | 3/30/22 | United Airlines | Chicago | IL | 60601 | Other | 7610 ∑ Air/Bus/Train Travel |
3529 | 3529 | Governor | Heidi Ganahl | Republican | 8.0 | 4/7/22 | United Airlines | Chicago | IL | 60601 | Other | 7610 ∑ Air/Bus/Train Travel |
4125 | 4125 | Governor | Heidi Ganahl | Republican | 219.6 | 8/19/22 | United Airlines | Chicago | IL | 60601 | Other | 7610 ∑ Air/Bus/Train Travel |
4137 | 4137 | Governor | Heidi Ganahl | Republican | 448.2 | 8/22/22 | United Airlines | Chicago | IL | 60601 | Other | 7610 ∑ Air/Bus/Train Travel |
4138 | 4138 | Governor | Heidi Ganahl | Republican | 248.8 | 8/22/22 | United Airlines | Chicago | IL | 60601 | Other | 7610 ∑ Air/Bus/Train Travel |
4548 | 4548 | Governor | Heidi Ganahl | Republican | 858.4 | 10/12/22 | United Airlines | Chicago | IL | 60601 | Other | 7610 ∑ Air/Bus/Train Travel |
4567 | 4567 | Governor | Heidi Ganahl | Republican | 468.2 | 10/13/22 | United Airlines | Chicago | IL | 60601 | Other | 7610 ∑ Air/Bus/Train Travel |
4595 | 4595 | Governor | Heidi Ganahl | Republican | 988.4 | 10/17/22 | United Airlines | Chicago | IL | 60601 | Other | 7610 ∑ Air/Bus/Train Travel |
4614 | 4614 | Governor | Heidi Ganahl | Republican | 312.8 | 10/20/21 | United Airlines | Chicago | IL | 60601 | Other | 7610 ∑ Air/Bus/Train Travel |
4633 | 4633 | Governor | Heidi Ganahl | Republican | 108.8 | 10/22/21 | United Airlines | Chicago | IL | 60601 | Other | 7610 ∑ Air/Bus/Train Travel |
4665 | 4665 | Governor | Heidi Ganahl | Republican | 135.4 | 10/27/21 | United Airlines | Chicago | IL | 60601 | Other | 7610 ∑ Air/Bus/Train Travel |
4734 | 4734 | Governor | Heidi Ganahl | Republican | 2349.63 | 11/1/22 | Same Day Tees | Frankfort | IL | 60423 | Other | 6631 ∑ Apparel |
8533 | 8533 | BD. ED. DISTRICT 08 | Peggy Propst | Republican | 330.73 | 5/10/22 | Rush Order Tees | Frankfort | IL | 60423 | Fundraising Expenses | Shirts |
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 );