state_cont
8 rows where city = "Hermitage"
This data as json, CSV (advanced)
Link | rowid ▼ | District | candidate_name | Party | contribution_amount | contribution_date | contributor | city | state | zip | employer | occupation | contributor_type | contribution_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18467 | 18467 | Secretary of State | Jena Griswold | Democratic | 5.0 | 1/14/22 | Larry Tremayne | Hermitage | PA | 16148 | Individual | Monetary (Itemized) | |||
20545 | 20545 | Secretary of State | Jena Griswold | Democratic | 5.0 | 2/14/22 | Larry Tremayne | Hermitage | PA | 16148 | Individual | Monetary (Itemized) | |||
22583 | 22583 | Secretary of State | Jena Griswold | Democratic | 5.0 | 2/25/22 | Larry Tremayne | Hermitage | PA | 16148 | Individual | Monetary (Itemized) | |||
23587 | 23587 | Secretary of State | Jena Griswold | Democratic | 5.0 | 3/8/22 | Larry Tremayne | Hermitage | PA | 16148 | Individual | Monetary (Itemized) | |||
24622 | 24622 | Secretary of State | Jena Griswold | Democratic | 5.0 | 3/18/22 | Larry Tremayne | Hermitage | PA | 16148 | Individual | Monetary (Itemized) | |||
24901 | 24901 | Secretary of State | Jena Griswold | Democratic | 5.0 | 3/23/22 | Larry Tremayne | Hermitage | PA | 16148 | Individual | Monetary (Itemized) | |||
26865 | 26865 | Secretary of State | Jena Griswold | Democratic | 5.0 | 4/14/22 | Larry Tremayne | Hermitage | PA | 16148 | Individual | Monetary (Itemized) | |||
27117 | 27117 | Secretary of State | Jena Griswold | Democratic | 5.0 | 4/18/22 | Larry Tremayne | Hermitage | PA | 16148 | 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 );