senate_cand_exp
23 rows where city = "Aurora" and expenditure_type = "Telephone"
This data as json, CSV (advanced)
Suggested facets: expenditure_amount
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
5252 | 5252 | Senate District 29 | Fields, Rhonda | Democratic | 246.09 | 2/5/19 0:00 | Sprint | Aurora | CO | 80011 | Telephone | |
5258 | 5258 | Senate District 29 | Fields, Rhonda | Democratic | 609.7 | 3/1/19 0:00 | Sprint | Aurora | CO | 80011 | Telephone | |
5265 | 5265 | Senate District 29 | Fields, Rhonda | Democratic | 276.29 | 4/10/19 0:00 | Sprint | Aurora | CO | 80011 | Telephone | |
5272 | 5272 | Senate District 29 | Fields, Rhonda | Democratic | 276.13 | 5/13/19 0:00 | Sprint | Aurora | CO | 80011 | Telephone | |
5277 | 5277 | Senate District 29 | Fields, Rhonda | Democratic | 276.38 | 6/11/19 0:00 | Sprint | Aurora | CO | 80011 | Telephone | |
5285 | 5285 | Senate District 29 | Fields, Rhonda | Democratic | 276.13 | 7/16/19 0:00 | Sprint | Aurora | CO | 80011 | Telephone | |
5289 | 5289 | Senate District 29 | Fields, Rhonda | Democratic | 142.56 | 8/12/19 0:00 | Sprint | Aurora | CO | 80011 | Telephone | |
5296 | 5296 | Senate District 29 | Fields, Rhonda | Democratic | 318.2 | 9/10/19 0:00 | Sprint | Aurora | CO | 80011 | Telephone | |
5305 | 5305 | Senate District 29 | Fields, Rhonda | Democratic | 579.02 | 11/5/18 0:00 | Sprint | Aurora | CO | 80011 | Telephone | |
5310 | 5310 | Senate District 29 | Fields, Rhonda | Democratic | 275.77 | 12/11/18 0:00 | Sprint | Aurora | CO | 80011 | Telephone | |
5367 | 5367 | Senate District 29 | Fields, Rhonda | Democratic | 480.1 | 10/16/19 0:00 | Sprint | Aurora | CO | 80011 | Telephone | |
5377 | 5377 | Senate District 29 | Fields, Rhonda | Democratic | 210.16 | 11/7/19 0:00 | Sprint | Aurora | CO | 80011 | Telephone | |
5378 | 5378 | Senate District 29 | Fields, Rhonda | Democratic | 167.65 | 11/10/20 0:00 | Sprint | Aurora | CO | 80011 | Telephone | |
5388 | 5388 | Senate District 29 | Fields, Rhonda | Democratic | 223.4 | 12/4/19 0:00 | Sprint | Aurora | CO | 80011 | Telephone | |
5406 | 5406 | Senate District 29 | Fields, Rhonda | Democratic | 254.81 | 2/7/17 0:00 | Sprint | Aurora | CO | 80011 | Telephone | |
5439 | 5439 | Senate District 29 | Fields, Rhonda | Democratic | 254.94 | 7/11/17 0:00 | Sprint | Aurora | CO | 80011 | Telephone | |
5442 | 5442 | Senate District 29 | Fields, Rhonda | Democratic | 275.24 | 7/25/17 0:00 | Sprint | Aurora | CO | 80011 | Telephone | |
5456 | 5456 | Senate District 29 | Fields, Rhonda | Democratic | 32.33 | 12/5/16 0:00 | Sprint | Aurora | CO | 80011 | Telephone | |
5457 | 5457 | Senate District 29 | Fields, Rhonda | Democratic | 228.93 | 12/6/16 0:00 | Sprint | Aurora | CO | 80011 | Telephone | |
5478 | 5478 | Senate District 29 | Fields, Rhonda | Democratic | 267.92 | 1/10/18 0:00 | Sprint | Aurora | CO | 80011 | Telephone | |
5503 | 5503 | Senate District 29 | Fields, Rhonda | Democratic | 271.51 | 4/16/18 0:00 | Sprint | Aurora | CO | 80011 | Telephone | |
5507 | 5507 | Senate District 29 | Fields, Rhonda | Democratic | 291.19 | 5/11/18 0:00 | Sprint | Aurora | CO | 80011 | Telephone | |
5515 | 5515 | Senate District 29 | Fields, Rhonda | Democratic | 275.9 | 7/3/18 0:00 | Sprint | Aurora | CO | 80011 | Telephone |
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 );