super_pacs_cont

9 rows where committee contains "one main street"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: contribution_amount, contribution_date, city, state, zip, contributor_type

Link rowid ▼ committee committee_type contribution_amount contribution_date contributor city state zip employer occupation contributor_type contribution_type explanation
2844 2844 ONE MAIN STREET COLORADO IEC Independent Expenditure Committee 15000.0 3/15/22 Journeymen Plumbers Gasfitters Local Union 3 Operating Account Aurora CO 80011     Labor Union Monetary (Itemized)  
2864 2864 ONE MAIN STREET COLORADO IEC Independent Expenditure Committee 5000.0 3/18/22 West Metro Firefighters I.A.F.F. Local 1309 Lakewood CO 80226     Labor Union Monetary (Itemized)  
2911 2911 ONE MAIN STREET COLORADO IEC Independent Expenditure Committee 10000.0 3/31/22 Northwest Regional Organizing Coalition Las Vegas NV 89146     Labor Union Monetary (Itemized)  
3021 3021 ONE MAIN STREET COLORADO IEC Independent Expenditure Committee 25000.0 4/8/22 Rocky Mountain Pipe Trades District Council #5 Denver CO 80216     Labor Union Monetary (Itemized)  
3022 3022 ONE MAIN STREET COLORADO IEC Independent Expenditure Committee 15000.0 4/8/22 Laborers International Union Of North America Local #720 Denver CO 80204     Labor Union Monetary (Itemized)  
3449 3449 ONE MAIN STREET COLORADO IEC Independent Expenditure Committee 25000.0 5/26/22 Apartment Association Of Metro Denver Greenwood Village CO 80111     Business Monetary (Itemized)  
3450 3450 ONE MAIN STREET COLORADO IEC Independent Expenditure Committee 5000.0 5/26/22 Aurora Fire Fighters Protective Association Denver CO 80212     Labor Union Monetary (Itemized)  
3461 3461 ONE MAIN STREET COLORADO IEC Independent Expenditure Committee 15000.0 5/27/22 Denver Fire Fighters Local 858 Denver CO 80212     Labor Union Monetary (Itemized) 7
3472 3472 ONE MAIN STREET COLORADO IEC Independent Expenditure Committee 60000.0 5/31/22 One Main Street Colorado Aurora CO 80013     Corporation 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
);