house_cont

4 rows where employer = "Nr Parentco Llc"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: District, candidate_name, Party, contribution_date, state, contributor_type, contribution_type

Link rowid ▼ District candidate_name Party contribution_amount contribution_date contributor city state zip employer occupation contributor_type contribution_type explanation
1816 1816 House District 05 Alex Valdez Democratic 64.0 7/20/21 Joshua Ginsberg Dorado PR 646 Nr Parentco Llc   Individual Monetary (Itemized)  
1817 1817 House District 05 Alex Valdez Democratic 56.0 7/20/21 Rhett Jordan Golden CO 80401 Nr Parentco Llc   Individual Monetary (Itemized)  
1818 1818 House District 05 Alex Valdez Democratic 280.0 7/20/21 Peter Knobel Vail CO 81657 Nr Parentco Llc Agriculture Individual Monetary (Itemized)  
32746 32746 House District 54 Matt Soper Republican 100.0 11/7/22 Jon Boord Denver CO 80227 Nr Parentco Llc General Business Individual (Member of LLC: NR PARENTCO, LLC) Monetary (Itemized) - LLC Contribution (Total Amount: 100.00)  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "house_cont" (
"District" TEXT,
  "candidate_name" TEXT,
  "Party" 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
);