super_pacs_cont

22 rows where occupation = "Agriculture"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: committee, committee_type, contribution_amount, contributor, city, zip, employer, contributor_type, contribution_type

Link rowid ▼ committee committee_type contribution_amount contribution_date contributor city state zip employer occupation contributor_type contribution_type explanation
50 50 TAKE BACK COLORADO Independent Expenditure Committee 10.0 1/10/21 Fritz Sturges Lamar CO 81052 Self Agriculture Individual Monetary (Itemized)  
378 378 TAKE BACK COLORADO Independent Expenditure Committee 10.0 2/10/21 Fritz Sturges Lamar CO 81052 Self Agriculture Individual Monetary (Itemized)  
542 542 TAKE BACK COLORADO Independent Expenditure Committee 10.0 3/10/21 Fritz Sturges Lamar CO 81052 Self Agriculture Individual Monetary (Itemized)  
676 676 WELD STRONG Independent Expenditure Committee 500.0 3/30/21 Angela Ritchey La Salle CO 80645 Self Agriculture Individual (Member of LLC: SPEAR Z CATTLE COMPANY LLC) Monetary (Itemized) - LLC Contribution (Total Amount: 500.00)  
700 700 TAKE BACK COLORADO Independent Expenditure Committee 10.0 4/10/21 Fritz Sturges Lamar CO 81052 Self Agriculture Individual Monetary (Itemized)  
787 787 TAKE BACK COLORADO Independent Expenditure Committee 25.0 4/23/21 Mark Smith Elbert CO 80106 Cff Llc Agriculture Individual Monetary (Itemized)  
829 829 TAKE BACK COLORADO Independent Expenditure Committee 100.0 5/4/21 William Hottel Keenesburg CO 80643 Wagner Power Systems Agriculture Individual Monetary (Itemized)  
848 848 TAKE BACK COLORADO Independent Expenditure Committee 10.0 5/10/21 Fritz Sturges Lamar CO 81052 Self Agriculture Individual Monetary (Itemized)  
937 937 SENATE MAJORITY FUND 527 Political Organization 150.0 5/23/21 William Jerke La Salle CO 80645 Self 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)  
982 982 TAKE BACK COLORADO Independent Expenditure Committee 10.0 6/10/21 Fritz Sturges Lamar CO 81052 Self 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)  
1128 1128 TAKE BACK COLORADO Independent Expenditure Committee 10.0 7/9/21 Candy Owen Longmont CO 80504 Self Agriculture Individual Monetary (Itemized)  
1130 1130 TAKE BACK COLORADO Independent Expenditure Committee 10.0 7/10/21 Fritz Sturges Lamar CO 81052 Self 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)  
1277 1277 TAKE BACK COLORADO Independent Expenditure Committee 10.0 8/9/21 Candy Owen Longmont CO 80504 Self Agriculture Individual Monetary (Itemized)  
1279 1279 TAKE BACK COLORADO Independent Expenditure Committee 10.0 8/10/21 Fritz Sturges Lamar CO 81052 Self 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)  
1438 1438 TAKE BACK COLORADO Independent Expenditure Committee 10.0 9/9/21 Candy Owen Longmont CO 80504 Self Agriculture Individual Monetary (Itemized)  
1453 1453 TAKE BACK COLORADO Independent Expenditure Committee 10.0 9/10/21 Fritz Sturges Lamar CO 81052 Self 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)  
1811 1811 TAKE BACK COLORADO Independent Expenditure Committee 10.0 12/10/20 Fritz Sturges Lamar CO 81052 Self 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
);