state_exp
8 rows where expenditure_type = "Travel & Lodging" and state = "DC"
This data as json, CSV (advanced)
Suggested facets: District, candidate_name, recipient, zip
Link | rowid ▼ | District | candidate_name | Party | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1737 | 1737 | Secretary of State | Jena Griswold | Democratic | 302.94 | 3/14/22 | Hilton Capital | Washington | DC | 20036 | Travel & Lodging | |
1936 | 1936 | Secretary of State | Jena Griswold | Democratic | 485.2 | 5/9/22 | Omni Shoreham Hotel | Washington | DC | 20008 | Travel & Lodging | |
2043 | 2043 | Secretary of State | Jena Griswold | Democratic | 344.0 | 6/9/22 | Amtrak | Washington | DC | 20001 | Travel & Lodging | |
2068 | 2068 | Secretary of State | Jena Griswold | Democratic | 461.4 | 6/13/22 | Jw Marriott Washington | Washington | DC | 20004 | Travel & Lodging | |
2499 | 2499 | Secretary of State | Jena Griswold | Democratic | 85.0 | 10/6/21 | Amtrak | Washington | DC | 20001 | Travel & Lodging | Transportation |
2568 | 2568 | Secretary of State | Jena Griswold | Democratic | 6962.0 | 10/19/22 | Dnc Travel Offset Account | Washington | DC | 20003 | Travel & Lodging | Travel Expenses |
5604 | 5604 | Governor | Jared Polis | Democratic | 594.5 | 4/15/22 | Julia Harrington | Washington | DC | 20002 | Travel & Lodging | Mileage Reimbursement |
6972 | 6972 | Governor | Jared Polis | Democratic | 554.27 | 12/19/18 | Autograph Hotel | Washington | DC | 20036 | Travel & Lodging | Travel - Lodging |
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 );