senate_cand_cont
2 rows where city = "Johnstown" and contribution_type = "Non-Monetary (Itemized)" sorted by occupation
This data as json, CSV (advanced)
Link | rowid | district | candidate | affiliation | contribution_amount | contribution_date | contributor | city | state | zip | employer | occupation ▼ | contributor_type | contribution_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8163 | 8163 | Senate District 23 | Boccella, Sally | Democratic | 52.0 | 10/24/19 0:00 | Sally Boccella | Johnstown | CO | 80534 | Teacher/Education | Individual | Non-Monetary (Itemized) | Rental Of Post Office Box Johnstown Co 80534 | |
8195 | 8195 | Senate District 23 | Boccella, Sally | Democratic | 38.0 | 12/26/19 0:00 | Sally Boccella | Johnstown | CO | 80534 | Weld County School District Re J Johnstown& Millikin | Teacher/Education | Individual | Non-Monetary (Itemized) | Ionos Website Set Up 701 Lee Rd Chesterbrook Pa 19087 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "senate_cand_cont" ( "district" TEXT, "candidate" TEXT, "affiliation" 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 );