super_pacs_cont

6 rows where city = "Elbert" and occupation = "Agriculture"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee committee_type contribution_amount contribution_date contributor city state zip employer occupation contributor_type contribution_type explanation
787 787 TAKE BACK COLORADO Independent Expenditure Committee 25.0 4/23/21 Mark Smith Elbert CO 80106 Cff Llc Agriculture Individual Monetary (Itemized)  
948 948 TAKE BACK COLORADO Independent Expenditure Committee 25.0 5/24/21 Mark Smith Elbert CO 80106 Cff Llc Agriculture Individual Monetary (Itemized)  
1077 1077 TAKE BACK COLORADO Independent Expenditure Committee 25.0 6/23/21 Mark Smith Elbert CO 80106 Cff Llc Agriculture Individual Monetary (Itemized)  
1227 1227 TAKE BACK COLORADO Independent Expenditure Committee 25.0 7/23/21 Mark Smith Elbert CO 80106 Cff Llc Agriculture Individual Monetary (Itemized)  
1385 1385 TAKE BACK COLORADO Independent Expenditure Committee 25.0 8/23/21 Mark Smith Elbert CO 80106 Cff Llc Agriculture Individual Monetary (Itemized)  
1601 1601 TAKE BACK COLORADO Independent Expenditure Committee 25.0 9/23/21 Mark Smith Elbert CO 80106 Cff Llc Agriculture 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
);