contribution_reports_24_hours

FPPC Form 497

Data source: 497

36 rows where filer_name = 56 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: report_date, entity_type, entity_last_name, entity_first_name, entity_city, entity_state, entity_zipcode, contribution_date, amount, committee_id, candidate_last_name, candidate_first_name, office_jurisdiction, district_number, report_date (date), contribution_date (date)

Link rowid filer_id filer_name committee_type report_date ▲ report_start_date report_end_date election_date transaction_id entity_type entity_last_name entity_first_name entity_prefix entity_suffix entity_city entity_state entity_zipcode contributor_employer contributor_occupation contributor_self_employed contribution_date amount committee_id candidate_last_name candidate_first_name candidate_prefix candidate_suffix office_sought office_jurisdiction district_number incumbent ballot_measure_name ballot_measure_number ballot_measure_jurisdiction memo_reference_number
1190 1190 1345259 62 OAKLAND EDUCATION ASSOCIATION POLITICAL ACTION COMMITTEE 56   2020-02-20       8A1NwyUbVayU COM Teachers, Parents, and Friends of Angela Normand 2020       Los Alamitos CA 90720       2020-02-20 00:00:00 350 1423098 837 Normand Angela     BED Alameda County 2          
883 883 1345259 62 OAKLAND EDUCATION ASSOCIATION POLITICAL ACTION COMMITTEE 56   2020-02-15       V1IhLmUOSSd9 COM Teachers, Parents, and Friends of Angela Normand 2020       Los Alamitos CA 90720       2020-02-06 00:00:00 9657 1423098 837 Normand Angela     BED Alameda County 2          
1196 1196 1345259 62 OAKLAND EDUCATION ASSOCIATION POLITICAL ACTION COMMITTEE 56   2020-02-07       NizZPybCBwd7 COM Teachers, Parents, and Friends of Angela Normand 2020       Los Alamitos CA 90720       2020-02-07 00:00:00 5671.69 1423098 837 Normand Angela     BED Alameda County 2          
1208 1208 1345259 62 OAKLAND EDUCATION ASSOCIATION POLITICAL ACTION COMMITTEE 56   2020-02-07       vAgY347H2I1K OTH OAKLAND EDUCATION ASSOCIATION       OAKLAND CA 94606       2020-02-07 00:00:00 1576.25                          
1209 1209 1345259 62 OAKLAND EDUCATION ASSOCIATION POLITICAL ACTION COMMITTEE 56   2020-02-07       2Ks2oUeKKBPe COM Castro Valley Teachers Association Political Action Committee       San Leandro CA 94587       2020-02-06 00:00:00 500 1348896 767                        
1210 1210 1345259 62 OAKLAND EDUCATION ASSOCIATION POLITICAL ACTION COMMITTEE 56   2020-02-07       kwWpyHkpwSjH COM East Side Teacher Political Action Committee       San Jose CA 95127       2020-02-07 00:00:00 5000 1345259 275                        
1211 1211 1345259 62 OAKLAND EDUCATION ASSOCIATION POLITICAL ACTION COMMITTEE 56   2020-02-07       kdVM1snzBJhH COM Hayward Education Association Political Action Committee       Hayward CA 94544       2020-02-07 00:00:00 2500 991247 768                        
1212 1212 1345259 62 OAKLAND EDUCATION ASSOCIATION POLITICAL ACTION COMMITTEE 56   2020-02-07       ITa511cYU8v9 COM New Haven Teachers Association Committee for School Improvement       Union City CA 94587       2020-02-07 00:00:00 5000 1229406 769                        
882 882 1345259 62 OAKLAND EDUCATION ASSOCIATION POLITICAL ACTION COMMITTEE 56   2020-02-06       Z755dLhtnvA8 COM Teachers, Parents, and Friends of Angela Normand 2020       Los Alamitos CA 90720       2020-01-22 00:00:00 0 1423098 837 Normand Angela     BED Alameda County 2          
1213 1213 1345259 62 OAKLAND EDUCATION ASSOCIATION POLITICAL ACTION COMMITTEE 56   2020-02-06       V1IhLmUOSSd9 COM Teachers, Parents, and Friends of Angela Normand 2020       Los Alamitos CA 90720       2020-02-06 00:00:00 15657.31 1423098 837 Normand Angela     BED Alameda County 2          
879 879 1345259 62 OAKLAND EDUCATION ASSOCIATION POLITICAL ACTION COMMITTEE 56   2020-01-16       Znytn58NzNTK COM Teachers, Parents, and Friends of Angela Normand 2020       Los Alamitos CA 90720       2019-12-06 00:00:00 4321 1423098 837 Normand Angela     BED Alameda County 2          
1215 1215 1345259 62 OAKLAND EDUCATION ASSOCIATION POLITICAL ACTION COMMITTEE 56   2020-01-15       Z755dLhtnvA8 COM Teachers, Parents, and Friends of Angela Normand 2020       Los Alamitos CA 90720       2020-01-22 00:00:00 350 1423098 837 Normand Angela     BED Alameda County 2          
871 871 1345259 62 OAKLAND EDUCATION ASSOCIATION POLITICAL ACTION COMMITTEE 56   2019-12-16       Znytn58NzNTK COM Teachers, Parents, and Friends of Angela Normand 2020       Los Alamitos CA 90720       2019-12-06 00:00:00 4500 1.4231e+06 686 Normand Angela     BED Alameda County 2.0          
597 597 1345259 62 OAKLAND EDUCATION ASSOCIATION POLITICAL ACTION COMMITTEE 56   2018-10-29       uegwsnzkGfCy COM CTA/ABC PAC       Burlingame CA 94011-0921       2018-10-29 00:00:00 23900 741941 233                        
636 636 1345259 62 OAKLAND EDUCATION ASSOCIATION POLITICAL ACTION COMMITTEE 56   2018-10-22       ZoSuJMwvpQJ9 COM Doutherd for School Board 2018       Oakland CA 94619       2018-10-22 00:00:00 1000 1404085 620 Doutherd Clarissa     BED Oakland Unified School District 4.0          
724 724 1345259 62 OAKLAND EDUCATION ASSOCIATION POLITICAL ACTION COMMITTEE 56   2018-10-05       PpT5UNcUD1Oe COM California Federation of Teachers COPE       Sacramento CA 95814       2018-10-04 00:00:00 4629.44 741857 351                        
633 633 1345259 62 OAKLAND EDUCATION ASSOCIATION POLITICAL ACTION COMMITTEE 56   2018-09-29       43mnVGj4qdsQ COM CTA/ABC PAC       Burlingame CA 94011-0921       2018-09-29 00:00:00 3200 741941 233                        
275 275 1345259 62 OAKLAND EDUCATION ASSOCIATION POLITICAL ACTION COMMITTEE 56   2016-11-04       n9m5jeFW3xX6 COM Chris Jackson for Oakland School Board       Sacramento CA 95815       2016-11-02 00:00:00 4264 1384926 450 Jackson Chris     BED   7.0          
276 276 1345259 62 OAKLAND EDUCATION ASSOCIATION POLITICAL ACTION COMMITTEE 56   2016-11-04       jvNTQalbEubX COM Kharyshi Wiginton for School       Oakland CA 94607       2016-11-02 00:00:00 4264 1386929 451 Wiginton Kharyshi     BED   3.0          
277 277 1345259 62 OAKLAND EDUCATION ASSOCIATION POLITICAL ACTION COMMITTEE 56   2016-11-04       OdirI6TjMCHP IND Lang Benjamin     Oakland CA 94610       2016-11-02 00:00:00 4264                          
278 278 1345259 62 OAKLAND EDUCATION ASSOCIATION POLITICAL ACTION COMMITTEE 56   2016-11-04       Zthb8BdA2gEt COM Mike Hutchinson for School Board 2016       Oakland CA 94602       2016-11-02 00:00:00 4264 1388188 452 Hutchinson Mike     BED   5.0          
279 279 1345259 62 OAKLAND EDUCATION ASSOCIATION POLITICAL ACTION COMMITTEE 56   2016-11-04       D4rhgHlCnhPl COM Roseann Torres for Oakland School Board 2016       Oakland CA 94612       2016-11-02 00:00:00 4264 1379121 453 Torres Roseann     BED   5.0          
280 280 1345259 62 OAKLAND EDUCATION ASSOCIATION POLITICAL ACTION COMMITTEE 56   2016-11-04       qigoJReIZwPW OTH TERRIS/BARNES/WALTERS       SAN FRANCISCO CA 94104       2016-11-02 00:00:00 21318.33                          
365 365 1345259 62 OAKLAND EDUCATION ASSOCIATION POLITICAL ACTION COMMITTEE 56   2016-10-15       hhVn3R1mhuHh COM Macleay for School Board       Oakland CA 94609       2016-10-15 00:00:00 1000 1384267 459 Macleay Donald     BED   1.0          
427 427 1345259 62 OAKLAND EDUCATION ASSOCIATION POLITICAL ACTION COMMITTEE 56   2016-10-06       qzeH2i4QcKIu OTH CTA       Burlingame ca 94011-0921       2016-09-26 00:00:00 1089                          
428 428 1345259 62 OAKLAND EDUCATION ASSOCIATION POLITICAL ACTION COMMITTEE 56   2016-10-06       Vw9b286bcGn8 OTH CTA       Burlingame ca 94011-0921       2016-10-02 00:00:00 10357.74                          
470 470 1345259 62 OAKLAND EDUCATION ASSOCIATION POLITICAL ACTION COMMITTEE 56   2016-09-23       MFYI8MchfTfg COM CTA/ABC PAC       Burlingame CA 94011-0921       2016-09-23 00:00:00 12000 741941 233                        
471 471 1345259 62 OAKLAND EDUCATION ASSOCIATION POLITICAL ACTION COMMITTEE 56   2016-09-23       ARUfsmprAOP7 COM CTA/ABC PAC       Burlingame CA 94011-0921       2016-09-23 00:00:00 13000 741941 233                        
32 32 1345259 62 OAKLAND EDUCATION ASSOCIATION POLITICAL ACTION COMMITTEE 56   2014-10-28       9Vgiq8eiXqJz IND Debro Karl     Oakland CA 94619       2014-10-28 00:00:00 7426                          
33 33 1345259 62 OAKLAND EDUCATION ASSOCIATION POLITICAL ACTION COMMITTEE 56   2014-10-28       njtMxAKXJhZy IND GONZALES SHANTHI     OAKLAND CA 94621       2014-10-28 00:00:00 4678                          
54 54 1345259 62 OAKLAND EDUCATION ASSOCIATION POLITICAL ACTION COMMITTEE 56   2014-10-22       E4nHLjJd2AOU COM CTA/ABC PAC       Burlingame CA 94011-0921       2014-10-22 00:00:00 7500 741941 233                        
56 56 1345259 62 OAKLAND EDUCATION ASSOCIATION POLITICAL ACTION COMMITTEE 56   2014-10-21       23bbPAiZusFw IND Debro Karl     Oakland CA 94619       2014-10-21 00:00:00 6395.5                          
57 57 1345259 62 OAKLAND EDUCATION ASSOCIATION POLITICAL ACTION COMMITTEE 56   2014-10-21       Tqx88nELTWeM IND GONZALES SHANTHI     OAKLAND CA 94621       2014-10-21 00:00:00 4162                          
58 58 1345259 62 OAKLAND EDUCATION ASSOCIATION POLITICAL ACTION COMMITTEE 56   2014-10-21       HLfe1eU2GHiT IND Senn Nina     Oakland CA 94611       2014-10-21 00:00:00 6395.5                          
2 2 1345259 62 OAKLAND EDUCATION ASSOCIATION POLITICAL ACTION COMMITTEE 56   2014-09-24       z9b7gmRvpLe5 COM CTA/ABC PAC       Burlingame CA 94011-0921       2014-09-22 00:00:00 6000 741941 233                        
174 174 1345259 62 OAKLAND EDUCATION ASSOCIATION POLITICAL ACTION COMMITTEE 56   2014-09-23       z9b7gmRvpLe5 COM CTA/ABC PAC       Burlingame CA 94011-0921       2014-09-23 00:00:00 6000 741941 233                        

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "contribution_reports_24_hours" (
"filer_id" INTEGER,
  "filer_name" INTEGER,
  "committee_type" TEXT,
  "report_date" TEXT,
  "report_start_date" TEXT,
  "report_end_date" TEXT,
  "election_date" TEXT,
  "transaction_id" TEXT,
  "entity_type" TEXT,
  "entity_last_name" TEXT,
  "entity_first_name" TEXT,
  "entity_prefix" TEXT,
  "entity_suffix" TEXT,
  "entity_city" TEXT,
  "entity_state" TEXT,
  "entity_zipcode" TEXT,
  "contributor_employer" INTEGER,
  "contributor_occupation" TEXT,
  "contributor_self_employed" TEXT,
  "contribution_date" TEXT,
  "amount" NUMERIC,
  "committee_id" INTEGER,
  "candidate_last_name" TEXT,
  "candidate_first_name" TEXT,
  "candidate_prefix" TEXT,
  "candidate_suffix" TEXT,
  "office_sought" TEXT,
  "office_jurisdiction" TEXT,
  "district_number" TEXT,
  "incumbent" TEXT,
  "ballot_measure_name" TEXT,
  "ballot_measure_number" TEXT,
  "ballot_measure_jurisdiction" TEXT,
  "memo_reference_number" TEXT
,
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 ("contributor_employer") REFERENCES [businesses](id));
CREATE INDEX ["contribution_reports_24_hours_filer_id"] ON [contribution_reports_24_hours]("filer_id");
CREATE INDEX ["contribution_reports_24_hours_filer_name"] ON [contribution_reports_24_hours]("filer_name");
CREATE INDEX ["contribution_reports_24_hours_committee_id"] ON [contribution_reports_24_hours]("committee_id");
CREATE INDEX ["contribution_reports_24_hours_contributor_employer"] ON [contribution_reports_24_hours]("contributor_employer");