super_pacs_cont

5 rows where occupation = "Environmental Services"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: contribution_amount, contributor, city, zip, employer

Link rowid ▼ committee committee_type contribution_amount contribution_date contributor city state zip employer occupation contributor_type contribution_type explanation
41 41 TAKE BACK COLORADO Independent Expenditure Committee 10.0 1/8/21 Sonny Lobato Commerce City CO 80022 Self Environmental Services Individual Monetary (Itemized)  
370 370 TAKE BACK COLORADO Independent Expenditure Committee 10.0 2/8/21 Sonny Lobato Commerce City CO 80022 Self Environmental Services Individual Monetary (Itemized)  
536 536 TAKE BACK COLORADO Independent Expenditure Committee 10.0 3/8/21 Sonny Lobato Commerce City CO 80022 Self Environmental Services Individual Monetary (Itemized)  
1774 1774 TAKE BACK COLORADO Independent Expenditure Committee 20.0 12/2/20 Joseph Dekleva Monument CO 80132 Kira Facilities Services Environmental Services Individual Monetary (Itemized)  
1802 1802 TAKE BACK COLORADO Independent Expenditure Committee 10.0 12/8/20 Sonny Lobato Commerce City CO 80022 Self Environmental Services Individual Monetary (Itemized)  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "super_pacs_cont" (
"committee" TEXT,
  "committee_type" TEXT,
  "contribution_amount" REAL,
  "contribution_date" TEXT,
  "contributor" TEXT,
  "city" TEXT,
  "state" TEXT,
  "zip" TEXT,
  "employer" TEXT,
  "occupation" TEXT,
  "contributor_type" TEXT,
  "contribution_type" TEXT,
  "explanation" TEXT
);