trad_pacs_exp
7 rows where expenditure_type = "Rent & Utilities" and explanation = "In Kind - Videoconferencing"
This data as json, CSV (advanced)
Link | rowid ▼ | committee | committee_type | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|
4866 | 4866 | United Colorado Committee | Political Party Committee | 16.17 | 5/4/20 0:00 | Zoom Video Communications, Inc. | San Jose | CA | 95113 | Rent & Utilities | In Kind - Videoconferencing |
5220 | 5220 | United Colorado Committee | Political Party Committee | 16.17 | 6/4/20 0:00 | Zoom Video Communications, Inc. | San Jose | CA | 95113 | Rent & Utilities | In Kind - Videoconferencing |
5773 | 5773 | United Colorado Committee | Political Party Committee | 16.17 | 7/4/20 0:00 | Zoom Video Communications, Inc. | San Jose | CA | 95113 | Rent & Utilities | In Kind - Videoconferencing |
6924 | 6924 | United Colorado Committee | Political Party Committee | 16.17 | 8/4/20 0:00 | Zoom Video Communications, Inc. | San Jose | CA | 95113 | Rent & Utilities | In Kind - Videoconferencing |
9121 | 9121 | United Colorado Committee | Political Party Committee | 16.17 | 9/4/20 0:00 | Zoom Video Communications, Inc. | San Jose | CA | 95113 | Rent & Utilities | In Kind - Videoconferencing |
11556 | 11556 | United Colorado Committee | Political Party Committee | 16.17 | 10/4/20 0:00 | Zoom Video Communications, Inc. | San Jose | CA | 95113 | Rent & Utilities | In Kind - Videoconferencing |
13862 | 13862 | United Colorado Committee | Political Party Committee | 16.17 | 11/4/20 0:00 | Zoom Video Communications, Inc. | San Jose | CA | 95113 | Rent & Utilities | In Kind - Videoconferencing |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "trad_pacs_exp" ( "committee" TEXT, "committee_type" TEXT, "expenditure_amount" REAL, "expenditure_date" TEXT, "recipient" TEXT, "city" TEXT, "state" TEXT, "zip" TEXT, "expenditure_type" TEXT, "explanation" TEXT );