ie_reports_24_hours

FPPC Form 496

Data source: 496

13 rows where filer_id = 75 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: report_date, transaction_id, amount, expenditure_date, expenditure_description, memo_reference_number, candidate_last_name, office_jurisdiction, 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
1611 1611 892160 75 International Association of Firefighter Local 55 Political Action, Sponsored by: Int'l Assoc. of Firefighter Local 55 73 RCP 2024-10-18       EDT130 43000 2024-10-17 Billboards EDT:S496:130       S Ryan Richardson         Oakland  
409 409 892160 75 International Association of Firefighter Local 55 Political Action, Sponsored by: Int'l Assoc. of Firefighter Local 55 73 RCP 2018-11-02       PDT120 7985.8 2018-10-29 Mailer - ESTIMATE PDT:S496:120       S Abel Guillen         Oakland, CA 2.0
410 410 892160 75 International Association of Firefighter Local 55 Political Action, Sponsored by: Int'l Assoc. of Firefighter Local 55 73 RCP 2018-11-02       PDT126 250 2018-10-29 Social Media Ads PDT:S496:126       S Abel Guillen         Oakland, CA 2.0
411 411 892160 75 International Association of Firefighter Local 55 Political Action, Sponsored by: Int'l Assoc. of Firefighter Local 55 73 RCP 2018-11-02       PDT123 8034.33 2018-10-31 Mailer PDT:S496:123       S Abel Guillen         Oakland, CA 2.0
412 412 892160 75 International Association of Firefighter Local 55 Political Action, Sponsored by: Int'l Assoc. of Firefighter Local 55 73 RCP 2018-11-02       PDT124 8034.33 2018-11-01 Mailer PDT:S496:124       S Abel Guillen         Oakland, CA 2.0
413 413 892160 75 International Association of Firefighter Local 55 Political Action, Sponsored by: Int'l Assoc. of Firefighter Local 55 73 RCP 2018-11-02       PDT127 250 2018-11-01 Social Media Ads PDT:S496:127       S Abel Guillen         Oakland, CA 2.0
429 429 892160 75 International Association of Firefighter Local 55 Political Action, Sponsored by: Int'l Assoc. of Firefighter Local 55 73 RCP 2018-11-02       PDT125 8034.33 2018-11-02 Mailer PDT:S496:125       S Abel Guillen         Oakland, CA 2.0
432 432 892160 75 International Association of Firefighter Local 55 Political Action, Sponsored by: Int'l Assoc. of Firefighter Local 55 73 RCP 2018-11-01       PDT123 8034.33 2018-10-31 Mailer PDT:S496:123       S Abel Guillen         Oakland, CA 2.0
433 433 892160 75 International Association of Firefighter Local 55 Political Action, Sponsored by: Int'l Assoc. of Firefighter Local 55 73 RCP 2018-11-01       PDT124 8034.33 2018-11-01 Mailer PDT:S496:124       S Abel Guillen         Oakland, CA 2.0
442 442 892160 75 International Association of Firefighter Local 55 Political Action, Sponsored by: Int'l Assoc. of Firefighter Local 55 73 RCP 2018-10-30       PDT120 7985.8 2018-10-29 Mailer - ESTIMATE PDT:S496:120       S Abel Guillen         Oakland, CA 2.0
472 472 892160 75 International Association of Firefighter Local 55 Political Action, Sponsored by: Int'l Assoc. of Firefighter Local 55 73 RCP 2018-10-24       EDT111 7985.8 2018-10-23 Mailer EDT:S496:111       S Abel Guillen         Oakland, CA 2.0
517 517 892160 75 International Association of Firefighter Local 55 Political Action, Sponsored by: Int'l Assoc. of Firefighter Local 55 73 RCP 2018-10-15       PDT102 6949.23 2018-10-09 Mailer PDT:S496:102       S Abel Guillen         Oakland, CA 2.0
518 518 892160 75 International Association of Firefighter Local 55 Political Action, Sponsored by: Int'l Assoc. of Firefighter Local 55 73 RCP 2018-10-15       PDT103 8116.51 2018-10-09 Mailer PDT:S496:103       S Sheng Thao         Oakland, CA 4.0

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