state_exp
9 rows where candidate_name = "Lang Sias" and explanation = "Consulting"
This data as json, CSV (advanced)
Suggested facets: expenditure_amount, expenditure_date, recipient, city, zip
Link | rowid ▼ | District | candidate_name | Party | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | State Treasurer | Lang Sias | Republican | 5000.0 | 1/6/22 | 76 Group | Frisco | CO | 80443 | Consultant & Professional Services | Consulting |
23 | 23 | State Treasurer | Lang Sias | Republican | 5000.0 | 2/9/22 | 76 Group | Frisco | CO | 80443 | Consultant & Professional Services | Consulting |
81 | 81 | State Treasurer | Lang Sias | Republican | 5000.0 | 4/25/22 | 76 Group | Frisco | CO | 80443 | Consultant & Professional Services | Consulting |
98 | 98 | State Treasurer | Lang Sias | Republican | 5000.0 | 5/9/22 | 76 Group | Frisco | CO | 80443 | Consultant & Professional Services | Consulting |
129 | 129 | State Treasurer | Lang Sias | Republican | 5128.2 | 7/12/22 | 76 Group | Frisco | CO | 80443 | Consultant & Professional Services | Consulting |
130 | 130 | State Treasurer | Lang Sias | Republican | 800.0 | 7/12/22 | Strategic Compliance Llc | Denver | CO | 80205 | Consultant & Professional Services | Consulting |
134 | 134 | State Treasurer | Lang Sias | Republican | 5000.0 | 7/22/22 | 76 Group | Frisco | CO | 80443 | Consultant & Professional Services | Consulting |
135 | 135 | State Treasurer | Lang Sias | Republican | 5056.99 | 7/22/22 | 76 Group | Frisco | CO | 80443 | Consultant & Professional Services | Consulting |
189 | 189 | State Treasurer | Lang Sias | Republican | 5242.34 | 8/17/22 | 76 Group | Frisco | CO | 80443 | Consultant & Professional Services | Consulting |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "state_exp" ( "District" TEXT, "candidate_name" TEXT, "Party" TEXT, "expenditure_amount" REAL, "expenditure_date" TEXT, "recipient" TEXT, "city" TEXT, "state" TEXT, "zip" TEXT, "expenditure_type" TEXT, "explanation" TEXT );