on_behalf_of_expenditures

FPPC Form 460, Schedule G

Data source: G_Expenditure

33 rows where filer_id = 95 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: filer_name, 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, expenditure_description, 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
6643 6643 1366759 95 Treva Reid for Oakland City Council 2020 Officeholder Committee 291 CTL 2024-07-25 2024-01-01 2024-06-30   EDT22 OTH British Airways       New York NY 10036 2024-05-02 769 769 TRC 03/03/24-03/11/24: Airfare to Amsterdam to present a proclamation to the US Ambassador to the Netherlands. Candidate in attendance.   Reid Treva     CCM City of Oakland, CA 7.0            
3944 3944 1366759 95 Treva Reid for Oakland City Council 2020 Officeholder Committee 291 CTL 2021-01-25 2020-10-18 2020-12-31   PDT21 OTH California Department of Tax and Fee Administration (CDTFA)       Sacramento CA 95814 2020-10-26 360.27 2969.46 LIT Sales Tax   Reid Treva     CCM City of Oakland, CA 7.0            
3945 3945 1366759 95 Treva Reid for Oakland City Council 2020 Officeholder Committee 291 CTL 2021-01-25 2020-10-18 2020-12-31   PDT22 OTH United States Postal Service       Washington DC 20260 2020-10-26 2278.6 19823.1 POS     Reid Treva     CCM City of Oakland, CA 7.0            
3946 3946 1366759 95 Treva Reid for Oakland City Council 2020 Officeholder Committee 291 CTL 2021-01-25 2020-10-18 2020-12-31   PDT23 OTH ThruText       Oakland CA 94612 2020-11-05 1905.2 1905.2   Texting campaign   Reid Treva     CCM City of Oakland, CA 7.0            
3947 3947 1366759 95 Treva Reid for Oakland City Council 2020 Officeholder Committee 291 CTL 2021-01-25 2020-10-18 2020-12-31   EDT13 OTH Amazon       Seattle WA 98109 2020-11-11 34.95 713.35 CMP Supplies for Election Night Event, Candidate in attendance   Reid Treva     CCM City of Oakland, CA 7.0            
3948 3948 1366759 95 Treva Reid for Oakland City Council 2020 Officeholder Committee 291 CTL 2021-01-25 2020-10-18 2020-12-31   EDT15 OTH Department of the Treasury       Atlanta GA 30348 2020-10-30 133.88 1521.24 SAL     Reid Treva     CCM City of Oakland, CA 7.0            
3949 3949 1366759 95 Treva Reid for Oakland City Council 2020 Officeholder Committee 291 CTL 2021-01-25 2020-10-18 2020-12-31   EDT16 OTH Department of the Treasury       Atlanta GA 30348 2020-11-12 133.88 1521.24 SAL     Reid Treva     CCM City of Oakland, CA 7.0            
3950 3950 1366759 95 Treva Reid for Oakland City Council 2020 Officeholder Committee 291 CTL 2021-01-25 2020-10-18 2020-12-31   EDT18 OTH Conceited Animal       San Leandro CA 94578 2020-10-24 1190.79 1530.79 CMP     Reid Treva     CCM City of Oakland, CA 7.0            
3690 3690 1366759 95 Treva Reid for Oakland City Council 2020 Officeholder Committee 291 CTL 2021-01-15 2020-09-20 2020-10-17   PDT7 OTH California Department of Tax and Fee Administration (CDTFA)       Sacramento CA 95814 2020-09-28 499.73 2609.19 LIT Sales Tax   Reid Treva     CCM City of Oakland, CA 7.0            
3691 3691 1366759 95 Treva Reid for Oakland City Council 2020 Officeholder Committee 291 CTL 2021-01-15 2020-09-20 2020-10-17   PDT11 OTH California Department of Tax and Fee Administration (CDTFA)       Sacramento CA 95814 2020-10-01 426.55 2609.19 CMP Sales Tax   Reid Treva     CCM City of Oakland, CA 7.0            
3692 3692 1366759 95 Treva Reid for Oakland City Council 2020 Officeholder Committee 291 CTL 2021-01-15 2020-09-20 2020-10-17   EDT9 OTH California Department of Tax and Fee Administration (CDTFA)       Sacramento CA 95814 2020-10-13 682.52 2609.19 CMP Sales Tax   Reid Treva     CCM City of Oakland, CA 7.0            
3693 3693 1366759 95 Treva Reid for Oakland City Council 2020 Officeholder Committee 291 CTL 2021-01-15 2020-09-20 2020-10-17   PDT20 OTH California Department of Tax and Fee Administration (CDTFA)       Sacramento CA 95814 2020-10-17 247.27 2609.19 LIT Sales Tax   Reid Treva     CCM City of Oakland, CA 7.0            
3694 3694 1366759 95 Treva Reid for Oakland City Council 2020 Officeholder Committee 291 CTL 2021-01-15 2020-09-20 2020-10-17   PDT8 OTH United States Postal Service       Washington DC 20260 2020-09-28 3109.88 17544.5 POS     Reid Treva     CCM City of Oakland, CA 7.0            
3695 3695 1366759 95 Treva Reid for Oakland City Council 2020 Officeholder Committee 291 CTL 2021-01-15 2020-09-20 2020-10-17   PDT10 OTH United States Postal Service       Washington DC 20260 2020-10-01 2566.22 17544.5 POS     Reid Treva     CCM City of Oakland, CA 7.0            
3696 3696 1366759 95 Treva Reid for Oakland City Council 2020 Officeholder Committee 291 CTL 2021-01-15 2020-09-20 2020-10-17   EDT10 OTH United States Postal Service       Washington DC 20260 2020-10-13 10926.12 17544.5 POS     Reid Treva     CCM City of Oakland, CA 7.0            
3697 3697 1366759 95 Treva Reid for Oakland City Council 2020 Officeholder Committee 291 CTL 2021-01-15 2020-09-20 2020-10-17   PDT19 OTH United States Postal Service       Washington DC 20260 2020-10-17 942.28 17544.5 POS     Reid Treva     CCM City of Oakland, CA 7.0            
3698 3698 1366759 95 Treva Reid for Oakland City Council 2020 Officeholder Committee 291 CTL 2021-01-15 2020-09-20 2020-10-17   EDT8 OTH Department of the Treasury       Atlanta GA 30348 2020-09-30 133.88 1253.48 SAL     Reid Treva     CCM City of Oakland, CA 7.0            
3699 3699 1366759 95 Treva Reid for Oakland City Council 2020 Officeholder Committee 291 CTL 2021-01-15 2020-09-20 2020-10-17   EDT11 OTH Department of the Treasury       Atlanta GA 30348 2020-10-15 133.88 1253.48 SAL     Reid Treva     CCM City of Oakland, CA 7.0            
4072 4072 1366759 95 Treva Reid for Oakland City Council 2020 160 CTL 2020-10-21 2020-09-20 2020-10-17 2020-11-03 PDT7 OTH California Department of Tax and Fee Administration (CDTFA)       Sacramento CA 95814 2020-09-28 499.73 2361.92 LIT Sales Tax   Reid Treva     CCM City of Oakland, CA 7.0            
4073 4073 1366759 95 Treva Reid for Oakland City Council 2020 160 CTL 2020-10-21 2020-09-20 2020-10-17 2020-11-03 PDT11 OTH California Department of Tax and Fee Administration (CDTFA)       Sacramento CA 95814 2020-10-01 426.55 2361.92 CMP Sales Tax   Reid Treva     CCM City of Oakland, CA 7.0            
4074 4074 1366759 95 Treva Reid for Oakland City Council 2020 160 CTL 2020-10-21 2020-09-20 2020-10-17 2020-11-03 EDT9 OTH California Department of Tax and Fee Administration (CDTFA)       Sacramento CA 95814 2020-10-13 682.52 2361.92 CMP Sales Tax   Reid Treva     CCM City of Oakland, CA 7.0            
4075 4075 1366759 95 Treva Reid for Oakland City Council 2020 160 CTL 2020-10-21 2020-09-20 2020-10-17 2020-11-03 PDT8 OTH United States Postal Service       Washington DC 20260 2020-09-28 3109.88 16602.22 POS     Reid Treva     CCM City of Oakland, CA 7.0            
4076 4076 1366759 95 Treva Reid for Oakland City Council 2020 160 CTL 2020-10-21 2020-09-20 2020-10-17 2020-11-03 PDT10 OTH United States Postal Service       Washington DC 20260 2020-10-01 2566.22 16602.22 POS     Reid Treva     CCM City of Oakland, CA 7.0            
4077 4077 1366759 95 Treva Reid for Oakland City Council 2020 160 CTL 2020-10-21 2020-09-20 2020-10-17 2020-11-03 EDT10 OTH United States Postal Service       Washington DC 20260 2020-10-13 10926.12 16602.22 POS     Reid Treva     CCM City of Oakland, CA 7.0            
4078 4078 1366759 95 Treva Reid for Oakland City Council 2020 160 CTL 2020-10-21 2020-09-20 2020-10-17 2020-11-03 EDT8 OTH Department of the Treasury       Atlanta GA 30348 2020-09-30 133.88 1253.48 SAL     Reid Treva     CCM City of Oakland, CA 7.0            
4079 4079 1366759 95 Treva Reid for Oakland City Council 2020 160 CTL 2020-10-21 2020-09-20 2020-10-17 2020-11-03 EDT11 OTH Department of the Treasury       Atlanta GA 30348 2020-10-15 133.88 1253.48 SAL     Reid Treva     CCM City of Oakland, CA 7.0            
3589 3589 1366759 95 Treva Reid for Oakland City Council 2020 160 CTL 2020-10-18 2020-07-01 2020-09-19 2020-11-03 EDT7 OTH California Department of Tax and Fee Administration (CDTFA)       Sacramento CA 95814 2020-07-16 438.18 753.12 CMP Sales Tax   Reid Treva     CCM City of Oakland, CA 7.0            
3590 3590 1366759 95 Treva Reid for Oakland City Council 2020 160 CTL 2020-10-18 2020-07-01 2020-09-19 2020-11-03 PDT9 OTH California Department of Tax and Fee Administration (CDTFA)       Sacramento CA 95814 2020-09-12 42.5 753.12 CMP Sales Tax   Reid Treva     CCM City of Oakland, CA 7.0            
3591 3591 1366759 95 Treva Reid for Oakland City Council 2020 160 CTL 2020-10-18 2020-07-01 2020-09-19 2020-11-03 PDT12 OTH California Department of Tax and Fee Administration (CDTFA)       Sacramento CA 95814 2020-09-18 272.44 753.12 CMP Sales Tax   Reid Treva     CCM City of Oakland, CA 7.0            
3592 3592 1366759 95 Treva Reid for Oakland City Council 2020 160 CTL 2020-10-18 2020-07-01 2020-09-19 2020-11-03 EDT5 OTH Department of the Treasury       Atlanta GA 30348 2020-08-31 770.54 985.72 SAL     Reid Treva     CCM City of Oakland, CA 7.0            
3593 3593 1366759 95 Treva Reid for Oakland City Council 2020 160 CTL 2020-10-18 2020-07-01 2020-09-19 2020-11-03 EDT6 OTH Department of the Treasury       Atlanta GA 30348 2020-09-15 215.18 985.72 SAL     Reid Treva     CCM City of Oakland, CA 7.0            
4182 4182 1366759 95 Treva Reid for Oakland City Council 2020 160 CTL 2020-09-22 2020-07-01 2020-09-19 2020-11-03 EDT5 OTH Department of the Treasury       Atlanta GA 30348 2020-08-31 770.54 985.72 SAL     Reid Treva     CCM City of Oakland, CA 7.0            
4183 4183 1366759 95 Treva Reid for Oakland City Council 2020 160 CTL 2020-09-22 2020-07-01 2020-09-19 2020-11-03 EDT6 OTH Department of the Treasury       Atlanta GA 30348 2020-09-15 215.18 985.72 SAL     Reid Treva     CCM City of Oakland, CA 7.0            

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