senate_cand_exp
16 rows where district = "Senate District 29" and expenditure_type = "Advertising"
This data as json, CSV (advanced)
Suggested facets: expenditure_amount, expenditure_date, recipient, city, state, zip
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
5280 | 5280 | Senate District 29 | Fields, Rhonda | Democratic | 126.0 | 6/24/19 0:00 | The I-70 Scout | Strasburg | CO | 80136 | Advertising | |
5286 | 5286 | Senate District 29 | Fields, Rhonda | Democratic | 125.0 | 7/16/19 0:00 | Constant Contact | Loveland | CO | 80538 | Advertising | |
5291 | 5291 | Senate District 29 | Fields, Rhonda | Democratic | 125.0 | 8/16/19 0:00 | Constant Contact | Waltham | MA | 2451 | Advertising | |
5295 | 5295 | Senate District 29 | Fields, Rhonda | Democratic | 2000.0 | 9/4/19 0:00 | Rhonda Fields | Aurora | CO | 80011 | Advertising | Reimbursement For Mad Dog Mail Printing |
5297 | 5297 | Senate District 29 | Fields, Rhonda | Democratic | 95.0 | 9/16/19 0:00 | Constant Contact | Waltham | MA | 2451 | Advertising | |
5318 | 5318 | Senate District 29 | Fields, Rhonda | Democratic | 100.0 | 5/25/20 0:00 | Turn It Blue Llc | Boulder | CO | 80302 | Advertising | |
5327 | 5327 | Senate District 29 | Fields, Rhonda | Democratic | 189.0 | 7/9/20 0:00 | The I-70 Scout | Strasburg | CO | 80136 | Advertising | |
5349 | 5349 | Senate District 29 | Fields, Rhonda | Democratic | -2000.0 | 9/4/19 0:00 | Rhonda Fields | Aurora | CO | 80011 | Advertising | Offset Due To Deletion Of Filed Item - Reimbursement For Mad Dog Mail Printing |
5350 | 5350 | Senate District 29 | Fields, Rhonda | Democratic | 2000.0 | 9/4/19 0:00 | Mad Dog Mail | Fernandina Beach | FL | 32034 | Advertising | |
5355 | 5355 | Senate District 29 | Fields, Rhonda | Democratic | 300.0 | 9/17/20 0:00 | Body Of Christ News | Aurora | CO | 80011 | Advertising | |
5370 | 5370 | Senate District 29 | Fields, Rhonda | Democratic | 350.0 | 10/16/20 0:00 | The I-70 Scout | Strasburg | CO | 80136 | Advertising | |
5430 | 5430 | Senate District 29 | Fields, Rhonda | Democratic | 24.0 | 5/1/17 0:00 | Menlo Park | CA | 94025 | Advertising | ||
5473 | 5473 | Senate District 29 | Fields, Rhonda | Democratic | 20.0 | 12/20/16 0:00 | Advertising | Event Expense | ||||
5474 | 5474 | Senate District 29 | Fields, Rhonda | Democratic | 18.0 | 1/2/18 0:00 | Menlo Park | CA | 94025 | Advertising | ||
5491 | 5491 | Senate District 29 | Fields, Rhonda | Democratic | 77.6 | 2/20/18 0:00 | The I-70 Scout | Strasburg | CO | 80136 | Advertising | |
5538 | 5538 | Senate District 29 | Fields, Rhonda | Democratic | 38.8 | 12/11/17 0:00 | The I-70 Scout | Strasburg | CO | 80136 | Advertising |
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 );