state_cont
13 rows where city = "Carlsbad"
This data as json, CSV (advanced)
Suggested facets: District, candidate_name, contribution_amount, contributor, zip, employer, occupation
Link | rowid ▼ | District | candidate_name | Party | contribution_amount | contribution_date | contributor | city | state | zip | employer | occupation | contributor_type | contribution_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18564 | 18564 | Secretary of State | Jena Griswold | Democratic | 6.0 | 1/16/22 | Marguerite Jaster | Carlsbad | CA | 92009 | Individual | Monetary (Itemized) | |||
18799 | 18799 | Secretary of State | Jena Griswold | Democratic | 10.0 | 1/20/22 | Marguerite Jaster | Carlsbad | CA | 92009 | Individual | Monetary (Itemized) | |||
20447 | 20447 | Secretary of State | Jena Griswold | Democratic | 7.0 | 2/14/22 | Marguerite Jaster | Carlsbad | CA | 92009 | Individual | Monetary (Itemized) | |||
26106 | 26106 | Secretary of State | Jena Griswold | Democratic | 7.0 | 4/6/22 | Marguerite Jaster | Carlsbad | CA | 92009 | Individual | Monetary (Itemized) | |||
36098 | 36098 | Secretary of State | Jena Griswold | Democratic | 25.0 | 6/27/22 | Amanda Wynn | Carlsbad | CA | 92009 | Individual | Monetary (Itemized) | |||
46513 | 46513 | Secretary of State | Jena Griswold | Democratic | 100.0 | 8/28/22 | Robert Kapell | Carlsbad | CA | 92011 | Not Employed | Not Currently Employed | Individual | Monetary (Itemized) | |
47871 | 47871 | Secretary of State | Jena Griswold | Democratic | 100.0 | 9/2/22 | Robert Kapell | Carlsbad | CA | 92011 | Not Employed | Not Currently Employed | Individual | Monetary (Itemized) | |
49817 | 49817 | Secretary of State | Jena Griswold | Democratic | 100.0 | 9/12/22 | Robert Kapell | Carlsbad | CA | 92011 | Not Employed | Not Currently Employed | Individual | Monetary (Itemized) | |
56437 | 56437 | Secretary of State | Jena Griswold | Democratic | 50.0 | 10/4/22 | Carolyn Erwin | Carlsbad | CA | 92009 | Individual | Monetary (Itemized) | |||
103819 | 103819 | Governor | Jared Polis | Democratic | 50.0 | 8/22/22 | Sonja Becker | Carlsbad | CA | 92010 | Individual | Monetary (Itemized) | |||
106931 | 106931 | Governor | Jared Polis | Democratic | 25.0 | 10/10/22 | Sonja Becker | Carlsbad | CA | 92010 | Individual | Monetary (Itemized) | |||
119909 | 119909 | Attorney General | Phil Weiser | Democratic | 625.0 | 6/3/21 | Mark Bolton | Carlsbad | CA | 92008 | Jazz Pharmaceuticals | Attorney/Legal | Individual | Monetary (Itemized) | |
140431 | 140431 | Attorney General | Phil Weiser | Democratic | 500.0 | 10/28/21 | George Mansho | Carlsbad | CA | 92009 | Assured Wireless | Science/Technology | Individual | Monetary (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 );