da_cand_exp
7 rows where city = "Glendale" and expenditure_type = "Office Equipment & Supplies"
This data as json, CSV (advanced)
Suggested facets: district, candidate, affiliation, recipient, state, zip
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
898 | 898 | DA 2 Denver | Mccann, Beth | Democratic | 12.95 | 12/19/16 0:00 | Staples | Glendale | CO | 80246 | Office Equipment & Supplies | |
1562 | 1562 | DA 17 Adams | Mccormack, Timothy | Republican | 204.18 | 5/13/19 0:00 | 4Over Printer | Glendale | CA | 91202 | Office Equipment & Supplies | Printing |
1567 | 1567 | DA 17 Adams | Mccormack, Timothy | Republican | 54.61 | 6/7/19 0:00 | 4Over Printer | Glendale | CA | 91202 | Office Equipment & Supplies | |
1570 | 1570 | DA 17 Adams | Mccormack, Timothy | Republican | 118.72 | 6/17/19 0:00 | 4Over Printer | Glendale | CA | 91202 | Office Equipment & Supplies | |
1578 | 1578 | DA 17 Adams | Mccormack, Timothy | Republican | 23.75 | 7/5/19 0:00 | 4Over Printer | Glendale | CA | 91202 | Office Equipment & Supplies | Printing |
1579 | 1579 | DA 17 Adams | Mccormack, Timothy | Republican | 76.9 | 7/9/19 0:00 | 4Over Printer | Glendale | CA | 91202 | Office Equipment & Supplies | |
1684 | 1684 | DA 17 Adams | Mccormack, Timothy | Republican | 106.32 | 11/19/19 0:00 | 4Over Printer | Glendale | CA | 91202 | Office Equipment & Supplies | Printing |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "da_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 );