monetary_contributions

FPPC Form 460, Schedule A

Data source: A_Contributions

27 rows where employer = 858 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, memo_reference_number, 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
97813 97813 1462429 313 Ryan Richardson for Oakland City Attorney 2024 425 2024-12-20 2024-09-22 2024-10-19 2024-11-05 INC541 IND Bloom Wendy   Berkeley CA 94703 Children's Hospital Oakland 858 Registered Nurse n   2024-10-07 150 150     INC541
97910 97910 1462429 313 Ryan Richardson for Oakland City Attorney 2024 425 2024-12-12 2024-09-22 2024-10-19 2024-11-05 INC541 IND Bloom Wendy   Berkeley CA 94703 Children's Hospital Oakland 858 Registered Nurse n   2024-10-07 150 150     INC541
100944 100944 1462429 313 Ryan Richardson for Oakland City Attorney 2024 425 2024-10-24 2024-09-22 2024-10-19 2024-11-05 INC541 IND Bloom Wendy   Berkeley CA 94703 Children's Hospital Oakland 858 Registered Nurse n   2024-10-07 150 150     INC541
61049 61049 1421001 204 Bob Jackson for Oakland City Council 2020 260 2021-02-08 2020-01-01 2020-12-31 2020-11-03 mOwGeecEfpYI IND Jennings Karen   Oakland CA 94611 Children's Hospital Oakland 858 Director n   2020-07-28 800 800      
64191 64191 1421001 204 Bob Jackson for Oakland City Council 2020 260 2020-09-27 2020-07-01 2020-09-19 2020-11-03 mOwGeecEfpYI IND Jennings Karen   Oakland CA 94611 Children's Hospital Oakland 858 Director n   2020-07-28 800 800      
68271 68271 1425443 241 Oakland Not For Sale 313 2020-07-30 2020-01-01 2020-06-30 2020-11-03 RZFAtbcsXuYs IND DeLuca Darrow   Oakland CA 94609 Children's Hospital Oakland 858 Doctor n   2020-02-16 100 100      
44943 44943 1407729 158 PAMELA PRICE FOR MAYOR 2018 199 2019-01-24 2018-10-21 2018-12-31 2018-11-06 IDT231 IND Dolphin Gabrielle   Alameda CA 94501 Children's Hospital Oakland 858 Medical Practice Management n I 2018-10-30 100 500      
46257 46257 1407729 158 PAMELA PRICE FOR MAYOR 2018 199 2018-10-24 2018-09-23 2018-10-20 2018-11-06 IDT154 IND Dolphin Gabrielle   Alameda CA 94501 Children's Hospital Oakland 858 Medical Practice Management n I 2018-09-30 100 400      
47637 47637 1407729 158 PAMELA PRICE FOR MAYOR 2018 199 2018-09-27 2018-01-01 2018-09-22 2018-11-06 IDT33 IND Dolphin Gabrielle   Alameda CA 94501 Children's Hospital Oakland 858 Medical Practice Management n I 2018-08-24 200 300      
47647 47647 1407729 158 PAMELA PRICE FOR MAYOR 2018 199 2018-09-27 2018-01-01 2018-09-22 2018-11-06 IDT71 IND Dolphin Gabrielle   Alameda CA 94501 Children's Hospital Oakland 858 Medical Practice Management n I 2018-08-30 100 300      
49064 49064 1403124 159 Natasha Middleton for Oakland City Council 2018 201 2018-07-30 2018-01-01 2018-06-30 2018-11-06 INC273 IND Bloom Wendy   Berkeley CA 94703 Children's Hospital Oakland 858 Registered Nurse n   2018-06-16 100 100     INC273
29757 29757 1382408 127 Re-Elect Dan Kalb Oakland City Council 2016 147 2018-07-27 2016-07-01 2016-09-24 2016-11-08 aecnFfKzddgW IND Williams Judith   Berkeley CA 94709 Children's Hospital Oakland 858 Registered Nurse n   2016-09-21 500 500      
29854 29854 1382408 127 Re-Elect Dan Kalb Oakland City Council 2016 147 2016-10-23 2016-07-01 2016-09-24 2016-11-08 aecnFfKzddgW IND Williams Judith   Berkeley CA 94709 Children's Hospital Oakland 858 Registered Nurse n   2016-09-21 500 500      
33058 33058 1382408 127 Re-Elect Dan Kalb Oakland City Council 2016 147 2016-09-29 2016-07-01 2016-09-24 2016-11-08 aecnFfKzddgW IND Williams Judith   Berkeley CA 94709 Children's Hospital Oakland 858 Registered Nurse n   2016-09-21 500 500      
7528 7528 1365610 77 Annie Campbell Washington 2014 Officeholder Committee 74 2016-02-01 2014-07-01 2014-09-30   INC324 IND Berkenkotter Eren   Oakland CA 94610 Children's Hospital Oakland 858 Clinical Psychologist n   2014-09-29 700 700      
7569 7569 1365610 77 Annie Campbell Washington 2014 Officeholder Committee 74 2016-02-01 2014-07-01 2014-09-30   INC344 IND Lubin Bertram   Berkeley CA 94705 Children's Hospital Oakland 858 CEO n   2014-09-22 100 200      
6710 6710 1365610 77 Annie Campbell Washington 2014 Officeholder Committee 74 2016-01-29 2014-01-01 2014-06-30   INC164 IND Lubin Bertram   Berkeley CA 94705 Children's Hospital Oakland 858 CEO n   2014-06-26 100 100      
11166 11166 1365766 82 Shereda Nosakhare for City Council 2014 80 2015-03-03 2014-07-01 2014-12-31   Kfg47RmlBodK IND Ross Javay   Berkeley CA 94702 Children's Hospital Oakland 858 physician n   2014-09-30 100 275      
12893 12893 1365766 82 Shereda Nosakhare for City Council 2014 80 2015-02-02 2014-07-01 2014-12-31 2014-11-04 Kfg47RmlBodK IND Ross Javay   Berkeley CA 94702 Children's Hospital Oakland 858 physician n   2014-09-30 100 275      
7303 7303 1368416 74 nina senn for oakland school board 2014 70 2015-01-30 2014-07-01 2014-09-30 2014-11-04 1j4HjItBKTNi IND Lou Mimi   Oakland CA 94611 Children's Hospital Oakland 858 psychologist n   2014-08-26 100 100      
7670 7670 1365610 77 Annie Campbell Washington for Oakland City Council 2014 88 2015-01-05 2014-07-01 2014-09-30 2014-11-04 Z81JbbDvJ2n1 IND Berkenkotter Erin   Oakland CA 94610 Children's Hospital Oakland 858 Clinical Psychologist n   2014-09-29 700 700      
15507 15507 1365766 82 Shereda Nosakhare for City Council 2014 80 2014-10-09 2014-07-01 2014-09-30 2014-11-04 Kfg47RmlBodK IND Ross Javay   Berkeley CA 94702 Children's Hospital Oakland 858 physician n   2014-09-30 100 275      
7764 7764 1365610 77 Annie Campbell Washington for Oakland City Council 2014 88 2014-10-07 2014-07-01 2014-09-30 2014-10-07 Z81JbbDvJ2n1 IND Berkenkotter Erin   Oakland CA 94610 Children's Hospital Oakland 858 Clinical Psychologist n   2014-09-29 700 700      
17755 17755 1365610 77 Annie Campbell Washington for Oakland City Council 2014 88 2014-10-06 2014-07-01 2014-09-30 2014-11-04 Z81JbbDvJ2n1 IND Berkenkotter Erin   Oakland CA 94610 Children's Hospital Oakland 858 Clinical Psychologist n   2014-09-29 700 700      
18038 18038 1368416 74 nina senn for oakland school board 2014 70 2014-10-02 2014-07-01 2014-09-30 2014-11-04 1j4HjItBKTNi IND Lou Mimi   Oakland CA 94611 Children's Hospital Oakland 858 psychologist n   2014-08-26 100 100      
19687 19687 1365766 82 Shereda Nosakhare for City Council 2014 80 2014-07-31 2014-01-01 2014-06-30 2014-11-04 B6uonwHsOJco IND Ross Javay   Berkeley CA 94702 Children's Hospital Oakland 858 physician n   2014-06-17 175 175      
2913 2913 1357609 38 Parker for Oakland Mayor 2014 33 2014-01-31 2013-07-01 2013-12-31 2014-11-04 INC680 IND Corkhill Susan   Oakland CA 94609 Children's Hospital Oakland 858 Clinical Scientist n   2013-10-23 106.49 106.49      

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");