state_exp
5 rows where District = "Attorney General" and expenditure_type = "Travel & Lodging"
This data as json, CSV (advanced)
Suggested facets: candidate_name, Party, expenditure_date, recipient, city, state, zip
Link | rowid ▼ | District | candidate_name | Party | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
9417 | 9417 | Attorney General | Phil Weiser | Democratic | 313.96 | 3/6/22 | Southwest Airlines | Dallas | TX | 75235 | Travel & Lodging | Employee Travel Den-Lga May 2022 |
9534 | 9534 | Attorney General | Phil Weiser | Democratic | 629.34 | 9/13/22 | Holiday Inn Express | Grand Junction | CO | 81505 | Travel & Lodging | Staff Lodging |
9969 | 9969 | Attorney General | John Kellner | Republican | 405.93 | 5/7/22 | Maybell Group | Auroraa | CO | 80046 | Travel & Lodging | Event |
9970 | 9970 | Attorney General | John Kellner | Republican | 150.8 | 5/7/22 | Maybell Group | Auroraa | CO | 80046 | Travel & Lodging | Vehicle Mileage |
9972 | 9972 | Attorney General | John Kellner | Republican | 171.99 | 5/17/22 | Best Western | Monte Vista | CO | 81144 | 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 );