on_behalf_of_expenditures

FPPC Form 460, Schedule G

Data source: G_Expenditure

26 rows where filer_id = 265 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: report_date, report_start_date, report_end_date, transaction_id, payee_last_name, payee_city, payee_state, payee_zipcode, expenditure_date, expenditure_amt, year_to_date, expenditure_type, report_date (date), report_start_date (date), report_end_date (date), election_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 entity_type payee_last_name payee_first_name payee_prefix payee_suffix payee_city payee_state payee_zipcode expenditure_date expenditure_amt year_to_date expenditure_type expenditure_description 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 support_or_oppose memo_reference_number
4589 4589 1442079 265 Treva Reid for Oakland Mayor 2022 342 CTL 2023-05-01 2022-07-01 2022-09-24 2022-11-08 PDT2 OTH California Department of Tax and Fee Administration (CDTFA)       Sacramento CA 95814 2022-09-12 664.17 664.17 CMP     Reid Treva     MAY City of Oakland              
4915 4915 1442079 265 Treva Reid for Oakland Mayor 2022 342 CTL 2023-05-01 2022-09-25 2022-10-22 2022-11-08 EDT2 OTH California Department of Tax and Fee Administration (CDTFA)       Sacramento CA 95814 2022-10-13 863.88 1528.05 LIT     Reid Treva     MAY City of Oakland              
4916 4916 1442079 265 Treva Reid for Oakland Mayor 2022 342 CTL 2023-05-01 2022-09-25 2022-10-22 2022-11-08 EDT3 OTH United States Postal Service       Washington DC 20260 2022-10-13 11088.58 11088.58 POS     Reid Treva     MAY City of Oakland              
5108 5108 1442079 265 Treva Reid for Oakland Mayor 2022 342 CTL 2023-05-01 2022-10-23 2022-12-31 2022-11-08 EDT5 OTH California Department of Tax and Fee Administration (CDTFA)       Sacramento CA 95814 2022-10-30 100.29 1964.65 CMP     Reid Treva     MAY City of Oakland              
5109 5109 1442079 265 Treva Reid for Oakland Mayor 2022 342 CTL 2023-05-01 2022-10-23 2022-12-31 2022-11-08 EDT4 OTH California Department of Tax and Fee Administration (CDTFA)       Sacramento CA 95814 2022-11-10 336.31 1964.65 CMP     Reid Treva     MAY City of Oakland              
5110 5110 1442079 265 Treva Reid for Oakland Mayor 2022 342 CTL 2023-05-01 2022-10-23 2022-12-31 2022-11-08 PDT7 OTH GetThru       Oakland CA 94612 2022-11-08 4072.92 9019.42   Texting Campaign   Reid Treva     MAY City of Oakland              
5111 5111 1442079 265 Treva Reid for Oakland Mayor 2022 342 CTL 2023-05-01 2022-10-23 2022-12-31 2022-11-08 PDT8 OTH GetThru       Oakland CA 94612 2022-11-08 1286.8 9019.42   Texting Campaign   Reid Treva     MAY City of Oakland              
5112 5112 1442079 265 Treva Reid for Oakland Mayor 2022 342 CTL 2023-05-01 2022-10-23 2022-12-31 2022-11-08 PDT5 OTH Political Data Inc. (PDI)       Long Beach CA 90806 2022-11-08 819.91 13568.48 WEB     Reid Treva     MAY City of Oakland              
5113 5113 1442079 265 Treva Reid for Oakland Mayor 2022 342 CTL 2023-05-01 2022-10-23 2022-12-31 2022-11-08 PDT6 OTH Political Data Inc. (PDI)       Long Beach CA 90806 2022-11-08 929.84 13568.48 WEB     Reid Treva     MAY City of Oakland              
5114 5114 1442079 265 Treva Reid for Oakland Mayor 2022 342 CTL 2023-05-01 2022-10-23 2022-12-31 2022-11-08 PDT3 OTH Robodial.org       Arlington VA 22203 2022-11-08 440.66 1065.29 PHO     Reid Treva     MAY City of Oakland              
5115 5115 1442079 265 Treva Reid for Oakland Mayor 2022 342 CTL 2023-05-01 2022-10-23 2022-12-31 2022-11-08 PDT4 OTH Robodial.org       Arlington VA 22203 2022-11-08 624.63 1065.29 PHO     Reid Treva     MAY City of Oakland              
4590 4590 1442079 265 Treva Reid for Oakland Mayor 2022 342 CTL 2023-01-23 2022-07-01 2022-09-24 2022-11-08 PDT2 OTH California Department of Tax and Fee Administration (CDTFA)       Sacramento CA 95814 2022-09-12 664.17 664.17 CMP     Reid Treva     MAY City of Oakland              
4917 4917 1442079 265 Treva Reid for Oakland Mayor 2022 342 CTL 2023-01-23 2022-09-25 2022-10-22 2022-11-08 EDT2 OTH California Department of Tax and Fee Administration (CDTFA)       Sacramento CA 95814 2022-10-13 863.88 1528.05 LIT     Reid Treva     MAY City of Oakland              
4918 4918 1442079 265 Treva Reid for Oakland Mayor 2022 342 CTL 2023-01-23 2022-09-25 2022-10-22 2022-11-08 EDT3 OTH United States Postal Service       Washington DC 20260 2022-10-13 11088.58 11088.58 POS     Reid Treva     MAY City of Oakland              
5129 5129 1442079 265 Treva Reid for Oakland Mayor 2022 342 CTL 2023-01-23 2022-10-23 2022-12-31 2022-11-08 EDT5 OTH California Department of Tax and Fee Administration (CDTFA)       Sacramento CA 95814 2022-10-30 100.29 1964.65 CMP     Reid Treva     MAY City of Oakland              
5130 5130 1442079 265 Treva Reid for Oakland Mayor 2022 342 CTL 2023-01-23 2022-10-23 2022-12-31 2022-11-08 EDT4 OTH California Department of Tax and Fee Administration (CDTFA)       Sacramento CA 95814 2022-11-10 336.31 1964.65 CMP     Reid Treva     MAY City of Oakland              
5131 5131 1442079 265 Treva Reid for Oakland Mayor 2022 342 CTL 2023-01-23 2022-10-23 2022-12-31 2022-11-08 PDT7 OTH GetThru       Oakland CA 94612 2022-11-08 4072.92 9019.42   Texting Campaign   Reid Treva     MAY City of Oakland              
5132 5132 1442079 265 Treva Reid for Oakland Mayor 2022 342 CTL 2023-01-23 2022-10-23 2022-12-31 2022-11-08 PDT8 OTH GetThru       Oakland CA 94612 2022-11-08 1286.8 9019.42   Texting Campaign   Reid Treva     MAY City of Oakland              
5133 5133 1442079 265 Treva Reid for Oakland Mayor 2022 342 CTL 2023-01-23 2022-10-23 2022-12-31 2022-11-08 PDT5 OTH Political Data Inc. (PDI)       Long Beach CA 90806 2022-11-08 819.91 13568.48 WEB     Reid Treva     MAY City of Oakland              
5134 5134 1442079 265 Treva Reid for Oakland Mayor 2022 342 CTL 2023-01-23 2022-10-23 2022-12-31 2022-11-08 PDT6 OTH Political Data Inc. (PDI)       Long Beach CA 90806 2022-11-08 929.84 13568.48 WEB     Reid Treva     MAY City of Oakland              
5135 5135 1442079 265 Treva Reid for Oakland Mayor 2022 342 CTL 2023-01-23 2022-10-23 2022-12-31 2022-11-08 PDT3 OTH Robodial.org       Arlington VA 22203 2022-11-08 440.66 1065.29 PHO     Reid Treva     MAY City of Oakland              
5136 5136 1442079 265 Treva Reid for Oakland Mayor 2022 342 CTL 2023-01-23 2022-10-23 2022-12-31 2022-11-08 PDT4 OTH Robodial.org       Arlington VA 22203 2022-11-08 624.63 1065.29 PHO     Reid Treva     MAY City of Oakland              
4591 4591 1442079 265 Treva Reid for Oakland Mayor 2022 342 CTL 2022-11-05 2022-07-01 2022-09-24 2022-11-08 PDT2 OTH California Department of Tax and Fee Administration (CDTFA)       Sacramento CA 95814 2022-09-12 664.17 664.17 CMP     Reid Treva     MAY City of Oakland              
5357 5357 1442079 265 Treva Reid for Oakland Mayor 2022 342 CTL 2022-10-25 2022-09-25 2022-10-22 2022-11-08 EDT2 OTH California Department of Tax and Fee Administration (CDTFA)       Sacramento CA 95814 2022-10-13 863.88 1528.05 LIT     Reid Treva     MAY City of Oakland              
5358 5358 1442079 265 Treva Reid for Oakland Mayor 2022 342 CTL 2022-10-25 2022-09-25 2022-10-22 2022-11-08 EDT3 OTH United States Postal Service       Washington DC 20260 2022-10-13 11088.58 11088.58 POS     Reid Treva     MAY City of Oakland              
5534 5534 1442079 265 Treva Reid for Oakland Mayor 2022 342 CTL 2022-09-29 2022-07-01 2022-09-24 2022-11-08 PDT2 OTH California Department of Tax and Fee Administration (CDTFA)       Sacramento CA 95814 2022-09-12 664.17 664.17 CMP     Reid Treva     MAY City of Oakland              

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "on_behalf_of_expenditures" (
"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,
  "payee_last_name" TEXT,
  "payee_first_name" TEXT,
  "payee_prefix" TEXT,
  "payee_suffix" TEXT,
  "payee_city" TEXT,
  "payee_state" TEXT,
  "payee_zipcode" TEXT,
  "expenditure_date" TEXT,
  "expenditure_amt" NUMERIC,
  "year_to_date" NUMERIC,
  "expenditure_type" TEXT,
  "expenditure_description" TEXT,
  "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,
  "support_or_oppose" 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));
CREATE INDEX ["on_behalf_of_expenditures_filer_id"] ON [on_behalf_of_expenditures]("filer_id");
CREATE INDEX ["on_behalf_of_expenditures_filer_name"] ON [on_behalf_of_expenditures]("filer_name");
CREATE INDEX ["on_behalf_of_expenditures_committee_id"] ON [on_behalf_of_expenditures]("committee_id");