ie_reports_24_hours

FPPC Form 496

Data source: 496

50 rows where filer_id = 253 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: filer_name, report_date, expenditure_date, expenditure_description, candidate_last_name, district_number, report_date (date), expenditure_date (date)

Link rowid filer_id filer_name committee_type report_date ▲ report_start_date report_end_date election_date transaction_id amount expenditure_date expenditure_description memo_reference_number ballot_measure_name ballot_measure_number ballot_measure_jurisdiction support_or_oppose candidate_last_name candidate_first_name candidate_prefix candidate_suffix office_sought office_jurisdiction district_number
1564 1564 1417455 253 Committee for California 377 RCP 2024-10-25       EDT106 8963.02 2024-10-25 Mailer (Estimated Costs) EDT:S496:106       S Patrice Berry       Oakland USD School Board City of Oakland 5
1668 1668 1417455 253 Committee for California 377 RCP 2024-10-08       EDT94 37301.26 2024-10-07 Mailer (Estimated Costs) EDT:S496:94       S Patrice Berry       Oakland USD School Board City of Oakland 5
632 632 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-11-03       PDT28 250 2020-11-02 Email Blast (Estimated Costs) PDT:S496:28       S Clifford Thompson       Oakland USD School Board City of Oakland 7
633 633 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-11-03       PDT32 148.01 2020-11-02 Robo Calls (Estimated Costs) PDT:S496:32       S Clifford Thompson       Oakland USD School Board City of Oakland 7
634 634 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-11-03       PDT26 250 2020-11-02 Email Blast (Estimated Costs) PDT:S496:26       S Leroy Gaines       Oakland USD School Board City of Oakland 5
635 635 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-11-03       PDT30 133.35 2020-11-02 Robo Calls (Estimated Costs) PDT:S496:30       S Leroy Gaines       Oakland USD School Board City of Oakland 5
636 636 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-11-03       PDT27 250 2020-11-02 Email Blast (Estimated Costs) PDT:S496:27       S Maiya Edgerly       Oakland USD School Board City of Oakland 3
637 637 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-11-03       PDT31 148.71 2020-11-02 Robo Calls (Estimated Costs) PDT:S496:31       S Maiya Edgerly       Oakland USD School Board City of Oakland 3
638 638 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-11-03       PDT29 250 2020-11-02 Email Blast (Estimated Costs) PDT:S496:29       S Austin Dannhaus       Oakland USD School Board City of Oakland 1
639 639 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-11-03       PDT33 151.2 2020-11-02 Robo Calls (Estimated Costs) PDT:S496:33       S Austin Dannhaus       Oakland USD School Board City of Oakland 1
651 651 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-10-29       EDT30 250 2020-10-22 Email Blast (Estimated Costs) EDT:S496:30       S Clifford Thompson       Oakland USD School Board City of Oakland 7
652 652 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-10-29       EDT27 2316.16 2020-10-28 Mailer (Estimated Costs) EDT:S496:27       S Clifford Thompson       Oakland USD School Board City of Oakland 7
653 653 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-10-29       EDT28 1500 2020-10-28 Research for Mailer/Robo Calls/Emails (Estimated Costs) EDT:S496:28       S Clifford Thompson       Oakland USD School Board City of Oakland 7
654 654 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-10-29       EDT29 128.41 2020-10-28 Robo Calls (Estimated Costs) EDT:S496:29       S Clifford Thompson       Oakland USD School Board City of Oakland 7
655 655 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-10-29       EDT31 250 2020-10-29 Email Blast (Estimated Costs) EDT:S496:31       S Clifford Thompson       Oakland USD School Board City of Oakland 7
656 656 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-10-29       EDT25 250 2020-10-22 Email Blast (Estimated Costs) EDT:S496:25       S Leroy Gaines       Oakland USD School Board City of Oakland 5
657 657 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-10-29       EDT22 2316.16 2020-10-28 Mailer (Estimated Costs) EDT:S496:22       S Leroy Gaines       Oakland USD School Board City of Oakland 5
658 658 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-10-29       EDT23 1500 2020-10-28 Research for Mailer/Robo Calls/Emails (Estimated Costs) EDT:S496:23       S Leroy Gaines       Oakland USD School Board City of Oakland 5
659 659 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-10-29       EDT24 117.11 2020-10-28 Robo Calls (Estimated Costs) EDT:S496:24       S Leroy Gaines       Oakland USD School Board City of Oakland 5
660 660 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-10-29       EDT26 250 2020-10-29 Email Blast (Estimated Costs) EDT:S496:26       S Leroy Gaines       Oakland USD School Board City of Oakland 5
661 661 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-10-29       EDT20 250 2020-10-22 Email Blast (Estimated Costs) EDT:S496:20       S Maiya Edgerly       Oakland USD School Board City of Oakland 3
662 662 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-10-29       EDT17 2316.15 2020-10-28 Mailer (Estimated Costs) EDT:S496:17       S Maiya Edgerly       Oakland USD School Board City of Oakland 3
663 663 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-10-29       EDT18 1500 2020-10-28 Research for Mailer/Robo Calls/Emails (Estimated Costs) EDT:S496:18       S Maiya Edgerly       Oakland USD School Board City of Oakland 3
664 664 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-10-29       EDT19 129.71 2020-10-28 Robo Calls (Estimated Costs) EDT:S496:19       S Maiya Edgerly       Oakland USD School Board City of Oakland 3
665 665 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-10-29       EDT21 250 2020-10-29 Email Blast (Estimated Costs) EDT:S496:21       S Maiya Edgerly       Oakland USD School Board City of Oakland 3
666 666 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-10-29       EDT15 250 2020-10-22 Email Blast (Estimated Costs) EDT:S496:15       S Austin Dannhaus       Oakland USD School Board City of Oakland 1
667 667 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-10-29       EDT12 2316.15 2020-10-28 Mailer (Estimated Costs) EDT:S496:12       S Austin Dannhaus       Oakland USD School Board City of Oakland 1
668 668 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-10-29       EDT13 1500 2020-10-28 Research for Mailer/Robo Calls/Emails (Estimated Costs) EDT:S496:13       S Austin Dannhaus       Oakland USD School Board City of Oakland 1
669 669 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-10-29       EDT14 143.88 2020-10-28 Robo Calls (Estimated Costs) EDT:S496:14       S Austin Dannhaus       Oakland USD School Board City of Oakland 1
670 670 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-10-29       EDT16 250 2020-10-29 Email Blast (Estimated Costs) EDT:S496:16       S Austin Dannhaus       Oakland USD School Board City of Oakland 1
696 696 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-10-22       PDT21 149.13 2020-10-21 Robo Calls (Estimated Costs) PDT:S496:21       S Clifford Thompson       Oakland USD School Board City of Oakland 7
697 697 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-10-22       PDT24 9194.46 2020-10-21 Mailer (Estimated Costs) PDT:S496:24       S Clifford Thompson       Oakland USD School Board City of Oakland 7
698 698 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-10-22       PDT18 185.85 2020-10-21 Robo Calls (Estimated Costs) PDT:S496:18       S Austin Dannhaus       Oakland USD School Board City of Oakland 1
699 699 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-10-22       PDT23 13522.85 2020-10-21 Mailer (Estimated Costs) PDT:S496:23       S Austin Dannhaus       Oakland USD School Board City of Oakland 1
700 700 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-10-22       PDT19 147.42 2020-10-21 Robo Calls (Estimated Costs) PDT:S496:19       S Maiya Edgerly       Oakland USD School Board City of Oakland 3
701 701 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-10-22       PDT22 14246.71 2020-10-21 Mailer (Estimated Costs) PDT:S496:22       S Maiya Edgerly       Oakland USD School Board City of Oakland 3
702 702 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-10-22       PDT20 132.89 2020-10-21 Robo Calls (Estimated Costs) PDT:S496:20       S Leroy Gaines       Oakland USD School Board City of Oakland 5
703 703 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-10-22       PDT25 8409.38 2020-10-21 Mailer (Estimated Costs) PDT:S496:25       S Leroy Gaines       Oakland USD School Board City of Oakland 5
756 756 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-10-17       PDT6 322.73 2020-10-08 Robos Calls (Estimated Costs) PDT:S496:6       S Austin Dannhaus       Oakland USD School Board City of Oakland 1
757 757 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-10-17       PDT11 3750 2020-10-16 Consulting for Mailer/Robo Calls (Estimated Costs) PDT:S496:11       S Austin Dannhaus       Oakland USD School Board City of Oakland 1
758 758 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-10-17       PDT15 14544.74 2020-10-16 Mailer (Estimated Costs) PDT:S496:15       S Austin Dannhaus       Oakland USD School Board City of Oakland 1
759 759 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-10-17       PDT5 228.93 2020-10-08 Robo Calls (Estimated Costs) PDT:S496:5       S Maiya Edgerly       Oakland USD School Board City of Oakland 3
760 760 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-10-17       PDT9 3750 2020-10-16 Consulting for Mailer/Robo Calls (Estimated Costs) PDT:S496:9       S Maiya Edgerly       Oakland USD School Board City of Oakland 3
761 761 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-10-17       PDT13 15119.39 2020-10-16 Mailer (Estimated Costs) PDT:S496:13       S Maiya Edgerly       Oakland USD School Board City of Oakland 3
762 762 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-10-17       PDT4 207.16 2020-10-08 Robo Calls (Estimated Costs) PDT:S496:4       S Leroy Gaines       Oakland USD School Board City of Oakland 5
763 763 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-10-17       PDT8 3750 2020-10-16 Consulting for Mailer/Robo Calls (Estimated Costs) PDT:S496:8       S Leroy Gaines       Oakland USD School Board City of Oakland 5
764 764 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-10-17       PDT12 7982.19 2020-10-16 Mailer (Estimated Costs) PDT:S496:12       S Leroy Gaines       Oakland USD School Board City of Oakland 5
765 765 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-10-17       PDT7 237.05 2020-10-08 Robo Calls (Estimated Costs) PDT:S496:7       S Clifford Thompson       Oakland USD School Board City of Oakland 7
766 766 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-10-17       PDT10 3750 2020-10-16 Consulting for Mailer/Robo Calls (Estimated Costs) PDT:S496:10       S Clifford Thompson       Oakland USD School Board City of Oakland 7
767 767 1417455 253 Committee for California, No on Prop 20 325 RCP 2020-10-17       PDT14 8501.3 2020-10-16 Mailer (Estimated Costs) PDT:S496:14       S Clifford Thompson       Oakland USD School Board City of Oakland 7

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "ie_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,
  "amount" NUMERIC,
  "expenditure_date" TEXT,
  "expenditure_description" TEXT,
  "memo_reference_number" TEXT,
  "ballot_measure_name" TEXT,
  "ballot_measure_number" TEXT,
  "ballot_measure_jurisdiction" TEXT,
  "support_or_oppose" TEXT,
  "candidate_last_name" TEXT,
  "candidate_first_name" TEXT,
  "candidate_prefix" TEXT,
  "candidate_suffix" TEXT,
  "office_sought" TEXT,
  "office_jurisdiction" TEXT,
  "district_number" TEXT
,
FOREIGN KEY ("filer_id") REFERENCES [filer_ids](id),
    FOREIGN KEY ("filer_name") REFERENCES [filer_names](id));
CREATE INDEX ["ie_reports_24_hours_filer_id"] ON [ie_reports_24_hours]("filer_id");
CREATE INDEX ["ie_reports_24_hours_filer_name"] ON [ie_reports_24_hours]("filer_name");