senate_cand_exp
10 rows where city = "Lafayette" and district = "Senate District 17"
This data as json, CSV (advanced)
Suggested facets: expenditure_date, recipient, expenditure_type
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1263 | 1263 | Senate District 17 | Lewis, Sonya Jaquez | Democratic | 300.0 | 4/5/20 0:00 | Gianna Sullivan | Lafayette | CO | 80026 | Consultant & Professional Services | |
1264 | 1264 | Senate District 17 | Lewis, Sonya Jaquez | Democratic | 22.0 | 6/4/20 0:00 | Post Office | Lafayette | CO | 80026 | Contributions | |
1265 | 1265 | Senate District 17 | Lewis, Sonya Jaquez | Democratic | 17.5 | 9/4/20 0:00 | Post Office | Lafayette | CO | 80026 | Office Equipment & Supplies | |
1270 | 1270 | Senate District 17 | Lewis, Sonya Jaquez | Democratic | 106.0 | 10/5/19 0:00 | Usps | Lafayette | CO | 80026 | Office Equipment & Supplies | |
1272 | 1272 | Senate District 17 | Lewis, Sonya Jaquez | Democratic | 82.0 | 10/10/19 0:00 | Emma Piller | Lafayette | CO | 80026 | Consultant & Professional Services | |
1273 | 1273 | Senate District 17 | Lewis, Sonya Jaquez | Democratic | 450.0 | 10/10/19 0:00 | Emma Piller | Lafayette | CO | 80026 | Consultant & Professional Services | |
1277 | 1277 | Senate District 17 | Lewis, Sonya Jaquez | Democratic | 146.25 | 11/7/19 0:00 | Denice Walker | Lafayette | CO | 80026 | Consultant & Professional Services | |
1278 | 1278 | Senate District 17 | Lewis, Sonya Jaquez | Democratic | 35.0 | 11/7/19 0:00 | Usps | Lafayette | CO | 80026 | Office Equipment & Supplies | |
1281 | 1281 | Senate District 17 | Lewis, Sonya Jaquez | Democratic | 28.5 | 11/18/19 0:00 | Usps | Lafayette | CO | 80026 | Office Equipment & Supplies | |
1284 | 1284 | Senate District 17 | Lewis, Sonya Jaquez | Democratic | 48.27 | 12/12/19 0:00 | Tandoori Kitchen | Lafayette | CO | 80026 | Food, Beverages and Meals |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "senate_cand_exp" ( "district" TEXT, "candidate" TEXT, "affiliation" TEXT, "expenditure_amount" REAL, "expenditure_date" TEXT, "recipient" TEXT, "city" TEXT, "state" TEXT, "zip" TEXT, "expenditure_type" TEXT, "explanation" TEXT );