super_pacs_cont

10 rows where contributor = "Fritz Sturges" 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
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)  
700 700 TAKE BACK COLORADO Independent Expenditure Committee 10.0 4/10/21 Fritz Sturges Lamar CO 81052 Self 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)  
982 982 TAKE BACK COLORADO Independent Expenditure Committee 10.0 6/10/21 Fritz Sturges Lamar CO 81052 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)  
1279 1279 TAKE BACK COLORADO Independent Expenditure Committee 10.0 8/10/21 Fritz Sturges Lamar CO 81052 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)  
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
);