senate_cont
8 rows where District = "Senate District 03" and occupation = "Media/Public Relations"
This data as json, CSV (advanced)
Suggested facets: candidate_name, Party, contribution_amount, contribution_date, contributor, city, zip, employer
Link | rowid ▼ | District | candidate_name | Party | contribution_amount | contribution_date | contributor | city | state | zip | employer | occupation | contributor_type | contribution_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
156 | 156 | Senate District 03 | Nick Hinrichsen | Democratic | 150.0 | 1/20/22 | Tiffany Pettigrew | Pueblo | CO | 81005 | Colorado State University | Media/Public Relations | Individual | Monetary (Itemized) | |
196 | 196 | Senate District 03 | Nick Hinrichsen | Democratic | 400.0 | 3/1/22 | Ning Mosberger | Boulder | CO | 80305 | Imagesbyning | Media/Public Relations | Individual | Monetary (Itemized) | |
234 | 234 | Senate District 03 | Nick Hinrichsen | Democratic | 100.0 | 3/31/22 | Tiffany Pettigrew | Pueblo | CO | 81005 | Colorado State University | Media/Public Relations | Individual | Monetary (Itemized) | |
313 | 313 | Senate District 03 | Nick Hinrichsen | Democratic | 41.67 | 6/24/22 | Joan Harvey | Boulder | CO | 80302 | Self | Media/Public Relations | Individual | Monetary (Itemized) | |
314 | 314 | Senate District 03 | Nick Hinrichsen | Democratic | 1.0 | 6/24/22 | Joan Harvey | Boulder | CO | 80302 | Self | Media/Public Relations | Individual | Monetary (Itemized) | |
316 | 316 | Senate District 03 | Nick Hinrichsen | Democratic | 1.0 | 6/24/22 | Joan Harvey | Boulder | CO | 80302 | Self | Media/Public Relations | Individual | Monetary (Itemized) | |
402 | 402 | Senate District 03 | Nick Hinrichsen | Democratic | 142.85 | 8/29/22 | Joan Harvey | Boulder | CO | 80302 | Self | Media/Public Relations | Individual | Monetary (Itemized) | |
1421 | 1421 | Senate District 03 | Stephen A. Varela | Republican | 400.0 | 10/20/22 | Polly Lawrence | Littleton | CO | 80125 | Michael Best Strategies | Media/Public Relations | Individual | Monetary (Itemized) | Anedot Accounting Fee |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "senate_cont" ( "District" TEXT, "candidate_name" TEXT, "Party" TEXT, "contribution_amount" REAL, "contribution_date" TEXT, "contributor" TEXT, "city" TEXT, "state" TEXT, "zip" TEXT, "employer" TEXT, "occupation" TEXT, "contributor_type" TEXT, "contribution_type" TEXT, "explanation" TEXT );