school_board_cont
3 rows where contribution_date = "9/27/21 0:00" and jurisdiction = "PITKIN"
This data as json, CSV (advanced)
Link | rowid ▼ | jurisdiction | Office | District | candidate | contribution_amount | contribution_date | contributor | city | state | zip | employer | occupation | contributor_type | contribution_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12187 | 12187 | PITKIN | SCHOOL BOARD DIRECTOR | ASPEN 1 | STACEY WEISS | 50 | 9/27/21 0:00 | Molly Ireland | Aspen | CO | 81611 | Individual | Monetary (Itemized) | |||
12188 | 12188 | PITKIN | SCHOOL BOARD DIRECTOR | ASPEN 1 | STACEY WEISS | 30 | 9/27/21 0:00 | Marnie White | Carbondale | CO | 81623 | Individual | Monetary (Itemized) | |||
12189 | 12189 | PITKIN | SCHOOL BOARD DIRECTOR | ASPEN 1 | STACEY WEISS | 250 | 9/27/21 0:00 | Blanca O'Leary | Aspen | CO | 81611 | Self Employed | Attorney/Legal | Individual | Monetary (Itemized) |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "school_board_cont" ( "jurisdiction" TEXT, "Office" TEXT, "District" TEXT, "candidate" TEXT, "contribution_amount" INTEGER, "contribution_date" TEXT, "contributor" TEXT, "city" TEXT, "state" TEXT, "zip" INTEGER, "employer" TEXT, "occupation" TEXT, "contributor_type" TEXT, "contribution_type" TEXT, "explanation" TEXT );