senate_cand_cont
4 rows where district = "Senate District 35" and occupation = "Retail Sales"
This data as json, CSV (advanced)
Suggested facets: candidate, affiliation, contribution_amount, city, zip, employer
Link | rowid ▼ | district | candidate | affiliation | contribution_amount | contribution_date | contributor | city | state | zip | employer | occupation | contributor_type | contribution_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14770 | 14770 | Senate District 35 | Lopez, Carlos | Democratic | 200.0 | 10/12/20 0:00 | Michelle Miles | Trinidad | CO | 81082 | Self Employed | Retail Sales | Individual | Monetary (Itemized) | Campaign Donation |
14795 | 14795 | Senate District 35 | Lopez, Carlos | Democratic | 400.0 | 11/22/19 0:00 | Katrina Barandiaran | Trinidad | CO | 81082 | Noah'S Ark Thrift Store | Retail Sales | Individual | Monetary (Itemized) | Donation |
14804 | 14804 | Senate District 35 | Simpson, Cleave | Republican | 400.0 | 3/10/20 0:00 | Mary Owens | Alamosa | CO | 81101 | Right Carpet And Interiors | Retail Sales | Individual | Monetary (Itemized) | |
14807 | 14807 | Senate District 35 | Simpson, Cleave | Republican | 101.0 | 3/14/20 0:00 | Darrell Yarbrough | Alamosa | CO | 81101 | Right Carpet And Interiors | Retail Sales | Individual | Monetary (Itemized) |
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 );