state_cont

8 rows where zip = 85259

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: District, candidate_name, contribution_amount, contribution_date, contributor

Link rowid ▼ District candidate_name Party contribution_amount contribution_date contributor city state zip employer occupation contributor_type contribution_type explanation
10297 10297 Secretary of State Jena Griswold Democratic 25.0 9/30/20 Beth Waldinger Scottsdale AZ 85259     Individual Monetary (Itemized)  
30122 30122 Secretary of State Jena Griswold Democratic 25.0 5/18/22 Beth Waldinger Scottsdale AZ 85259     Individual Monetary (Itemized)  
47608 47608 Secretary of State Jena Griswold Democratic 25.0 8/31/22 Beth Waldinger Scottsdale AZ 85259     Individual Monetary (Itemized)  
55077 55077 Secretary of State Jena Griswold Democratic 25.0 9/30/22 Beth Waldinger Scottsdale AZ 85259     Individual Monetary (Itemized)  
71048 71048 Secretary of State Jena Griswold Democratic 25.0 11/3/22 Beth Waldinger Scottsdale AZ 85259     Individual Monetary (Itemized)  
98609 98609 Governor Jared Polis Democratic 25.0 5/18/22 Beth Waldinger Scottsdale AZ 85259     Individual Monetary (Itemized)  
101284 101284 Governor Jared Polis Democratic 25.0 6/30/22 Beth Waldinger Scottsdale AZ 85259     Individual Monetary (Itemized)  
144511 144511 Attorney General Phil Weiser Democratic 200.0 11/16/21 Gary Marchant Scottsdale AZ 85259 Arizona State University Teacher/Education Individual Monetary (Itemized)  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "state_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
);