state_cont
8 rows where contribution_date = "12/14/19"
This data as json, CSV (advanced)
Suggested facets: District, candidate_name, contribution_amount, state, employer, occupation, contribution_type
Link | rowid ▼ | District | candidate_name | Party | contribution_amount | contribution_date | contributor | city | state | zip | employer | occupation | contributor_type | contribution_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10644 | 10644 | Secretary of State | Jena Griswold | Democratic | 200.0 | 12/14/19 | Sofia G Aguilar | Denver | CO | 80205 | Self | Other | Individual | Monetary (Itemized) | |
10645 | 10645 | Secretary of State | Jena Griswold | Democratic | 1250.0 | 12/14/19 | Audrey D Benedict | Ward | CO | 80481 | Self | Other | Individual | Monetary (Itemized) | |
10646 | 10646 | Secretary of State | Jena Griswold | Democratic | 10.0 | 12/14/19 | Pam H Howard | Loveland | CO | 80537 | Not Employed | Not Currently Employed | Individual | Monetary (Itemized) | |
86708 | 86708 | Governor | Jared Polis | Democratic | 100.0 | 12/14/19 | Greg Harfst | New York | NY | 10019 | Goldman Sachs | Financial/Investment | Individual | Monetary (Itemized) | |
86709 | 86709 | Governor | Jared Polis | Democratic | 5.0 | 12/14/19 | Monetary (Non-Itemized) | ||||||||
86710 | 86710 | Governor | Jared Polis | Democratic | 25.0 | 12/14/19 | Leanne Pratt | Aurora | CO | 80013 | Retired | Retired | Individual | Monetary (Itemized) | |
86711 | 86711 | Governor | Jared Polis | Democratic | 2.5 | 12/14/19 | Monetary (Non-Itemized) | ||||||||
86712 | 86712 | Governor | Jared Polis | Democratic | 10.0 | 12/14/19 | Monetary (Non-Itemized) |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "state_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 );