outside_spend_school_board
2 rows where District = "Denver" and candidate = "ESSERMAN, SCOTT"
This data as json, CSV (advanced)
Link | rowid ▼ | Committee | Payee | Spent | ExpenditureDate | Delivered date | type | candidate | position | District |
---|---|---|---|---|---|---|---|---|---|---|
47 | 47 | FORWARD PROGRESS, | EFFCT, | 9000 | 10/27/21 | 10/27/2021-11/2/21 | Internet | ESSERMAN, SCOTT | opposing | Denver |
51 | 51 | FORWARD PROGRESS, | RIO STRATEGIES, | 3000 | 11/1/21 | 11/1/2021-11/2/2021 | Internet | ESSERMAN, SCOTT | opposing | Denver |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "outside_spend_school_board" ( "Committee" TEXT, "Payee" TEXT, "Spent" TEXT, "ExpenditureDate" TEXT, "Delivered date" TEXT, "type" TEXT, "candidate" TEXT, "position" TEXT, "District" TEXT );