house_cand_cont
9 rows where contribution_type = "Non-Aggregated Receipts"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8922 | 8922 | House District 20 | Fossinger, Megan | Democratic | 1.72 | 4/1/20 0:00 | Non-Aggregated Receipts | ||||||||
8932 | 8932 | House District 20 | Fossinger, Megan | Democratic | 0.07 | 4/30/20 0:00 | Non-Aggregated Receipts | ||||||||
8946 | 8946 | House District 20 | Fossinger, Megan | Democratic | 0.11 | 5/31/20 0:00 | Non-Aggregated Receipts | Interest | |||||||
8973 | 8973 | House District 20 | Fossinger, Megan | Democratic | 0.13 | 6/30/20 0:00 | Non-Aggregated Receipts | Interest | |||||||
9001 | 9001 | House District 20 | Fossinger, Megan | Democratic | 3.72 | 7/31/20 0:00 | Non-Aggregated Receipts | Interest | |||||||
9039 | 9039 | House District 20 | Fossinger, Megan | Democratic | 4.28 | 8/31/20 0:00 | Non-Aggregated Receipts | Interest | |||||||
9059 | 9059 | House District 20 | Fossinger, Megan | Democratic | 4.39 | 9/30/20 0:00 | Non-Aggregated Receipts | Interest | |||||||
9082 | 9082 | House District 20 | Fossinger, Megan | Democratic | 4.54 | 10/30/20 0:00 | Non-Aggregated Receipts | Interest | |||||||
9085 | 9085 | House District 20 | Fossinger, Megan | Democratic | 0.34 | 11/30/20 0:00 | Non-Aggregated Receipts | Interest |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "house_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 );