senate_cand_exp
9 rows where candidate = "Lopez, Carlos" and expenditure_type = "Miscellaneous"
This data as json, CSV (advanced)
Suggested facets: expenditure_date, recipient, city, zip, explanation
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
6341 | 6341 | Senate District 35 | Lopez, Carlos | Democratic | 105.0 | 3/12/20 0:00 | Alamosa Valley Courier | Alamosa | CO | 81101 | Miscellaneous | Newspaper Subscription |
6366 | 6366 | Senate District 35 | Lopez, Carlos | Democratic | 30.15 | 7/26/20 0:00 | Dollar Tree | Trinidad | CO | 81082 | Miscellaneous | Supplies For Campaign Manager |
6367 | 6367 | Senate District 35 | Lopez, Carlos | Democratic | 59.14 | 7/26/20 0:00 | Wal-Mart | Trinidad | CO | 81082 | Miscellaneous | Supplies For Campaign Manager |
6388 | 6388 | Senate District 35 | Lopez, Carlos | Democratic | 66.21 | 9/3/20 0:00 | Bldrs Supply & Home Center | Trinidad | CO | 81082 | Miscellaneous | Signage Supplies |
6389 | 6389 | Senate District 35 | Lopez, Carlos | Democratic | 26.84 | 9/3/20 0:00 | Big R | Trinidad | CO | 81082 | Miscellaneous | Fencing Posts |
6401 | 6401 | Senate District 35 | Lopez, Carlos | Democratic | 28.85 | 9/13/20 0:00 | Wal-Mart | Trinidad | CO | 81082 | Miscellaneous | Flags |
6414 | 6414 | Senate District 35 | Lopez, Carlos | Democratic | 85.82 | 9/22/20 0:00 | Water Education Colorado | Denver | CO | 80218 | Miscellaneous | Literature |
6416 | 6416 | Senate District 35 | Lopez, Carlos | Democratic | 30.64 | 9/25/20 0:00 | Bldrs Supply & Home Center | Trinidad | CO | 81082 | Miscellaneous | Panneling |
6454 | 6454 | Senate District 35 | Lopez, Carlos | Democratic | 91.93 | 10/10/20 0:00 | Bldrs Supply & Home Center | Trinidad | CO | 81082 | Miscellaneous | Yard Sign Materials |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "senate_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 );