house_cand_exp
6 rows where expenditure_type = "Office Equipment & Supplies" and state = "PA"
This data as json, CSV (advanced)
Suggested facets: district, candidate, expenditure_amount, recipient, city, zip, explanation
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2640 | 2640 | House District 11 | Mccormick, Karen | Democratic | 1140.0 | 1/6/20 0:00 | Ngp Van Inc. | Pittsburgh | PA | 15251-9264 | Office Equipment & Supplies | Ngp Software Expense |
2659 | 2659 | House District 11 | Mccormick, Karen | Democratic | 1140.0 | 4/6/20 0:00 | Ngp Van Inc. | Pittsburgh | PA | 15251-9264 | Office Equipment & Supplies | Ngp Software Expense |
2676 | 2676 | House District 11 | Mccormick, Karen | Democratic | 1140.0 | 7/22/20 0:00 | Ngp Van Inc. | Pittsburgh | PA | 15251-9264 | Office Equipment & Supplies | Ngp Van Services For 3 Months |
2706 | 2706 | House District 11 | Mccormick, Karen | Democratic | 1140.0 | 10/13/20 0:00 | Ngp Van Inc. | Pittsburgh | PA | 15251-9264 | Office Equipment & Supplies | Software |
5444 | 5444 | House District 24 | Duran, Monica | Democratic | 1462.98 | 11/28/20 0:00 | Qvc | Lancaster | PA | 17601 | Office Equipment & Supplies | Computer |
14826 | 14826 | House District 63 | Schneider, Geneiveve | Democratic | 11.44 | 2/10/20 0:00 | National Name Badge | Tarentum | PA | 15084 | Office Equipment & Supplies | Name Tag |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "house_cand_exp" ( "district" TEXT, "candidate" TEXT, "affiliation" TEXT, "expenditure_amount" REAL, "expenditure_date" TEXT, "recipient" TEXT, "city" TEXT, "state" TEXT, "zip" TEXT, "expenditure_type" TEXT, "explanation" TEXT );