state_cont

10 rows where city = "Los Altos Hills"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: District, candidate_name, Party, contribution_amount, contribution_date, contributor, employer, occupation, contribution_type

Link rowid ▼ District candidate_name Party contribution_amount contribution_date contributor city state zip employer occupation contributor_type contribution_type explanation
7747 7747 Secretary of State Pam Anderson Republican 20.0 9/11/22 Sidney Oldberg Los Altos Hills CA 94022     Individual Monetary (Itemized)  
22077 22077 Secretary of State Jena Griswold Democratic 500.0 2/20/22 Frances Codispoti Los Altos Hills CA 94022 Self Other Individual Monetary (Itemized)  
22339 22339 Secretary of State Jena Griswold Democratic 83.34 2/23/22 Judy Aptekar Los Altos Hills CA 94022     Individual Monetary (Itemized)  
23009 23009 Secretary of State Jena Griswold Democratic 500.0 3/1/22 Frances Codispoti Los Altos Hills CA 94022 Self Other Individual Monetary (Itemized)  
23529 23529 Secretary of State Jena Griswold Democratic 100.0 3/8/22 Kevin Edwards Los Altos Hills CA 94022 Connected Social Media Other Individual Monetary (Itemized)  
27619 27619 Secretary of State Jena Griswold Democratic -500.0 4/24/22 Frances Codispoti Los Altos Hills CA 94022 Self Other Individual Returned Contributions Contribution Refund
27620 27620 Secretary of State Jena Griswold Democratic -500.0 4/24/22 Frances Codispoti Los Altos Hills CA 94022 Self Other Individual Returned Contributions Contribution Refund
62055 62055 Secretary of State Jena Griswold Democratic 33.34 10/16/22 Freda Hofland Los Altos Hills CA 94022     Individual Monetary (Itemized)  
80487 80487 Governor Heidi Ganahl Republican 22.0 9/11/22 Sidney Oldberg Los Altos Hills CA 94022 Retired Retired Individual Monetary (Itemized)  
82762 82762 Governor Heidi Ganahl Republican 10.0 10/11/22 Terry Oldberg Los Altos Hills CA 94022 Retired Retired 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
);