monetary_contributions

FPPC Form 460, Schedule A

Data source: A_Contributions

24 rows where employer = 2229 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: filer_id, filer_name, report_date, report_start_date, report_end_date, election_date, transaction_id, last_name, first_name, city, zipcode, occupation, transaction_date, transaction_amt, year_to_date, report_date (date), report_start_date (date), report_end_date (date), election_date (date), transaction_date (date)

Link rowid filer_id filer_name report_date ▲ report_start_date report_end_date election_date transaction_id entity_type last_name first_name prefix city state zipcode employer occupation self_employed transaction_type transaction_date transaction_amt year_to_date transaction_description committee_id memo_reference_number
78051 78051 1446236 269 De La Fuente for Mayor 2022 349 2022-10-13 2022-07-01 2022-09-24 2022-11-08 hAqzeWT64V2u IND Lowe Michael   Pleasant Hill CA 94523 AB&I Foundry 2229 Executive/General Manager n   2022-09-10 900 900      
87881 87881 1446236 269 De La Fuente for Mayor 2022 349 2022-09-28 2022-07-01 2022-09-24 2022-11-08 hAqzeWT64V2u IND Lowe Michael   Pleasant Hill CA 94523 AB&I Foundry 2229 Executive/General Manager n   2022-09-10 900 900      
70173 70173 1441869 263 Johnson Oakland Mayor 2022 340 2022-07-17 2021-01-01 2021-12-31 2022-11-08 IDT58 IND Cook Kristen   Oakland CA 94621 AB&I Foundry 2229 Community Relations n I 2021-11-29 900 900      
70506 70506 1442079 265 Treva Reid for Oakland Mayor 2022 342 2022-07-14 2021-01-01 2021-12-31 2022-11-08 INC130 IND Lowe Michael   Pleasant Hill CA 94523-4654 AB&I Foundry 2229 Manager n   2021-12-10 900 900      
72992 72992 1442079 265 Treva Reid for Oakland Mayor 2022 342 2022-01-31 2021-01-01 2021-12-31 2022-11-08 INC130 IND Lowe Michael   Pleasant Hill CA 94523-4654 AB&I Foundry 2229 Manager n   2021-12-10 900 900      
73195 73195 1441869 263 Johnson Oakland Mayor 2022 340 2022-01-28 2021-01-01 2021-12-31 2022-11-08 IDT58 IND Cook Kristen   Oakland CA 94621 AB&I Foundry 2229 Community Relations n I 2021-11-29 900 900      
9279 9279 1367270 80 Kaplan for Oakland Mayor 2014 78 2015-01-27 2014-07-01 2014-09-30 2014-11-04 VN8ZNCZZZW3 IND Perez Monica   Concord CA 94521-4513 AB&I Foundry 2229 Engineer n   2014-09-20 100 400      
9570 9570 1367270 80 Kaplan for Oakland Mayor 2014 78 2014-10-23 2014-07-01 2014-09-30 2014-11-04 VN8ZNCZZZW3 IND Perez Monica   Concord CA 94521-4513 AB&I Foundry 2229 Engineer n   2014-09-20 100 400      
15887 15887 1367270 80 Kaplan for Oakland Mayor 2014 78 2014-10-06 2014-07-01 2014-09-30 2014-11-04 VN8ZNCZZZW3 IND Perez Monica   Concord CA 94521-4513 AB&I Foundry 2229 Engineer n   2014-09-20 100 400      
6839 6839 1357609 40 Parker for Oakland Mayor 2014 34 2014-09-16 2014-01-01 2014-06-30 2014-11-04 INC1506 IND Tavares Nancy   Castro Valley CA 94552 AB&I Foundry 2229 Human Resources n   2014-06-29 500 500      
6855 6855 1357609 40 Parker for Oakland Mayor 2014 34 2014-09-16 2014-01-01 2014-06-30 2014-11-04 INC1507 IND Robinson Dave   Castro Valley CA 94552 AB&I Foundry 2229 Engineering Manager n   2014-06-29 500 500      
6861 6861 1357609 40 Parker for Oakland Mayor 2014 34 2014-09-16 2014-01-01 2014-06-30 2014-11-04 INC1508 IND Winter Kurt   Lafayette CA 94549 AB&I Foundry 2229 President n   2014-06-29 500 500      
6894 6894 1357609 40 Parker for Oakland Mayor 2014 34 2014-09-16 2014-01-01 2014-06-30 2014-11-04 INC1509 IND Wixson Kip   Castro Valley CA 94552 AB&I Foundry 2229 Vice President of Marketing n   2014-06-29 500 500      
6901 6901 1357609 40 Parker for Oakland Mayor 2014 34 2014-09-16 2014-01-01 2014-06-30 2014-11-04 INC1493 IND Gutierrez Zeydi   Castro Valley CA 94546 AB&I Foundry 2229 Iron Fitter n   2014-06-29 500 500      
7275 7275 1367270 80 Kaplan for Oakland Mayor 2014 78 2014-08-01 2014-01-01 2014-06-30   VN8ZNCSB443 IND Perez Monica   Concord CA 94521-4513 AB&I Foundry 2229 Engineer n   2014-06-30 300 300      
7287 7287 1367270 80 Kaplan for Oakland Mayor 2014 78 2014-08-01 2014-01-01 2014-06-30   VN8ZNCSB485 IND Wixson Kip   Castro Valley CA 94552-2636 AB&I Foundry 2229 Vice President n   2014-06-30 700 700      
18196 18196 1367270 80 Kaplan for Oakland Mayor 2014 78 2014-07-31 2014-01-01 2014-06-30   VN8ZNCSB443 IND Perez Monica   Concord CA 94521-4513 AB&I Foundry 2229 Engineer n   2014-06-30 300 300      
18208 18208 1367270 80 Kaplan for Oakland Mayor 2014 78 2014-07-31 2014-01-01 2014-06-30   VN8ZNCSB485 IND Wixson Kip   Castro Valley CA 94552-2636 AB&I Foundry 2229 Vice President n   2014-06-30 700 700      
19004 19004 1357609 40 Parker for Oakland Mayor 2014 34 2014-07-31 2014-01-01 2014-06-30 2014-11-04 INC1493 IND Gutierrez Zeydi   Castro Valley CA 94546 AB&I Foundry 2229 Iron Fitter n   2014-06-29 500 500      
19025 19025 1357609 40 Parker for Oakland Mayor 2014 34 2014-07-31 2014-01-01 2014-06-30 2014-11-04 INC1507 IND Robinson Dave   Castro Valley CA 94552 AB&I Foundry 2229 Engineering Manager n   2014-06-29 500 500      
19043 19043 1357609 40 Parker for Oakland Mayor 2014 34 2014-07-31 2014-01-01 2014-06-30 2014-11-04 INC1509 IND Wixson Kip   Castro Valley CA 94552 AB&I Foundry 2229 Vice President of Marketing n   2014-06-29 500 500      
19045 19045 1357609 40 Parker for Oakland Mayor 2014 34 2014-07-31 2014-01-01 2014-06-30 2014-11-04 INC1506 IND Tavares Nancy   Castro Valley CA 94552 AB&I Foundry 2229 Human Resources n   2014-06-29 500 500      
19088 19088 1357609 40 Parker for Oakland Mayor 2014 34 2014-07-31 2014-01-01 2014-06-30 2014-11-04 INC1508 IND Winter Kurt   Lafayette CA 94549 AB&I Foundry 2229 President n   2014-06-29 500 500      
20857 20857 1354678 38 Re-Elect Mayor Quan 2014 32 2014-07-29 2014-01-01 2014-06-30 2014-11-04 I89tj6dr47gA IND Wixson Kip   Castro Valley CA 94552 AB&I Foundry 2229 VP of Marketing n   2014-01-31 700 700      

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "monetary_contributions" (
"filer_id" INTEGER,
  "filer_name" INTEGER,
  "report_date" TEXT,
  "report_start_date" TEXT,
  "report_end_date" TEXT,
  "election_date" TEXT,
  "transaction_id" TEXT,
  "entity_type" TEXT,
  "last_name" TEXT,
  "first_name" TEXT,
  "prefix" INTEGER,
  "city" TEXT,
  "state" TEXT,
  "zipcode" TEXT,
  "employer" INTEGER,
  "occupation" TEXT,
  "self_employed" TEXT,
  "transaction_type" INTEGER,
  "transaction_date" TEXT,
  "transaction_amt" INTEGER,
  "year_to_date" INTEGER,
  "transaction_description" INTEGER,
  "committee_id" TEXT,
  "memo_reference_number" INTEGER
,
FOREIGN KEY ("filer_id") REFERENCES [filer_ids](id),
    FOREIGN KEY ("filer_name") REFERENCES [filer_names](id),
    FOREIGN KEY ("committee_id") REFERENCES [committee_ids](id),
    FOREIGN KEY ("employer") REFERENCES [businesses](id));
CREATE INDEX ["monetary_contributions_filer_id"] ON [monetary_contributions]("filer_id");
CREATE INDEX ["monetary_contributions_filer_name"] ON [monetary_contributions]("filer_name");
CREATE INDEX ["monetary_contributions_committee_id"] ON [monetary_contributions]("committee_id");
CREATE INDEX ["monetary_contributions_employer"] ON [monetary_contributions]("employer");