on_behalf_of_expenditures

FPPC Form 460, Schedule G

Data source: G_Expenditure

32 rows where filer_name = 259 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, expenditure_description, report_date (date), report_start_date (date), report_end_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
4330 4330 1395968 148 Libby Schaaf for Mayor 2018 Officeholder Committee 259 CTL 2022-07-11 2021-07-01 2021-12-31   EDT2 OTH Postable.com       New York NY 10013 2021-12-16 2805.42 2805.42 LIT     Schaaf Libby     MAY City of Oakland, CA              
4331 4331 1395968 148 Libby Schaaf for Mayor 2018 Officeholder Committee 259 CTL 2022-07-11 2021-07-01 2021-12-31   PDT68 OTH Duende LLC       Oakland CA 94612 2021-12-02 662 3212.69 MTG 12/17/22: Office Holiday Party deposit, Candidate in attendance   Schaaf Libby     MAY City of Oakland, CA              
4332 4332 1395968 148 Libby Schaaf for Mayor 2018 Officeholder Committee 259 CTL 2022-07-11 2021-07-01 2021-12-31   EDT3 OTH Duende LLC       Oakland CA 94612 2021-12-17 1860.69 3212.69 MTG 12/17/21: Office Holiday Party, Candidate in attendance   Schaaf Libby     MAY City of Oakland, CA              
4333 4333 1395968 148 Libby Schaaf for Mayor 2018 Officeholder Committee 259 CTL 2022-07-11 2021-07-01 2021-12-31   PDT70 OTH Duende LLC       Oakland CA 94612 2021-12-17 690 3212.69 MTG 12/17/21: Office Holiday Party, Candidate in attendance   Schaaf Libby     MAY City of Oakland, CA              
4334 4334 1395968 148 Libby Schaaf for Mayor 2018 Officeholder Committee 259 CTL 2022-07-11 2021-07-01 2021-12-31   PDT58 OTH Google       Mountain View CA 94043 2021-09-13 240 660 WEB     Schaaf Libby     MAY City of Oakland, CA              
4335 4335 1395968 148 Libby Schaaf for Mayor 2018 Officeholder Committee 259 CTL 2022-07-11 2021-07-01 2021-12-31   PDT59 OTH Google       Mountain View CA 94043 2021-10-01 180 660 WEB     Schaaf Libby     MAY City of Oakland, CA              
4336 4336 1395968 148 Libby Schaaf for Mayor 2018 Officeholder Committee 259 CTL 2022-07-11 2021-07-01 2021-12-31   NON876 OTH United States Postal Service       Washington DC 20260 2021-12-16 584.8 58 POS     Schaaf Libby     MAY City of Oakland, CA              
4337 4337 1395968 148 Libby Schaaf for Mayor 2018 Officeholder Committee 259 CTL 2022-01-31 2021-07-01 2021-12-31   EDT2 OTH Postable.com       New York NY 10013 2021-12-16 2805.42 2805.42 LIT     Schaaf Libby     MAY City of Oakland, CA              
4338 4338 1395968 148 Libby Schaaf for Mayor 2018 Officeholder Committee 259 CTL 2022-01-31 2021-07-01 2021-12-31   PDT68 OTH Duende LLC       Oakland CA 94612 2021-12-02 662 2522.69 MTG 12/17/22: Office Holiday Party deposit, Candidate in attendance   Schaaf Libby     MAY City of Oakland, CA              
4339 4339 1395968 148 Libby Schaaf for Mayor 2018 Officeholder Committee 259 CTL 2022-01-31 2021-07-01 2021-12-31   EDT3 OTH Duende LLC       Oakland CA 94612 2021-12-17 1860.69 2522.69 MTG 12/17/21: Office Holiday Party, Candidate in attendance   Schaaf Libby     MAY City of Oakland, CA              
4340 4340 1395968 148 Libby Schaaf for Mayor 2018 Officeholder Committee 259 CTL 2022-01-31 2021-07-01 2021-12-31   PDT58 OTH Google       Mountain View CA 94043 2021-09-13 240 660 WEB     Schaaf Libby     MAY City of Oakland, CA              
4341 4341 1395968 148 Libby Schaaf for Mayor 2018 Officeholder Committee 259 CTL 2022-01-31 2021-07-01 2021-12-31   PDT59 OTH Google       Mountain View CA 94043 2021-10-01 180 660 WEB     Schaaf Libby     MAY City of Oakland, CA              
4342 4342 1395968 148 Libby Schaaf for Mayor 2018 Officeholder Committee 259 CTL 2022-01-31 2021-07-01 2021-12-31   NON876 OTH United States Postal Service       Washington DC 20260 2021-12-16 584.8 58 POS     Schaaf Libby     MAY City of Oakland, CA              
3826 3826 1395968 148 Libby Schaaf for Mayor 2018 Officeholder Committee 259 CTL 2021-07-08 2020-07-01 2020-12-31   PDT52 OTH Postable.com       New York NY 10013 2020-12-21 2242.98 2242.98   Holiday Cards   Schaaf Libby     MAY City of Oakland, CA              
3827 3827 1395968 148 Libby Schaaf for Mayor 2018 Officeholder Committee 259 CTL 2021-07-08 2020-07-01 2020-12-31   PDT49 OTH DoorDash       San Francisco CA 94105 2020-12-15 500 1000   $50 Gift Cards for Peter Radu, Kyra Mungia, Messiah Maydun, Caleb Smith, Shereda Nosakhare, Lauren Blanchard, Justin Berton, Sun Kwong Sze, Elinor Buchen, and David Silver   Schaaf Libby     MAY City of Oakland, CA              
3828 3828 1395968 148 Libby Schaaf for Mayor 2018 Officeholder Committee 259 CTL 2021-07-08 2020-07-01 2020-12-31   PDT50 OTH DoorDash       San Francisco CA 94105 2020-12-15 500 1000   $50 Gift Cards for Warren Logan, Kelley Kahn, Darin Ranelletti, Yvonna Cazares, Jasmine Pournavab, Audrey Momoh, Tim Fisher, Patrice Berry, Rafaella Cohen, & Jordon Micken   Schaaf Libby     MAY City of Oakland, CA              
3829 3829 1395968 148 Libby Schaaf for Mayor 2018 Officeholder Committee 259 CTL 2021-07-08 2020-07-01 2020-12-31   NON656 OTH United States Postal Service       Washington DC 20260 2020-12-21 513.1 0 POS     Schaaf Libby     MAY City of Oakland, CA              
3940 3940 1395968 148 Libby Schaaf for Mayor 2018 Officeholder Committee 259 CTL 2021-01-21 2020-07-01 2020-12-31   PDT52 OTH Postable.com       New York NY 10013 2020-12-21 2242.98 2242.98   Holiday Cards   Schaaf Libby     MAY City of Oakland, CA              
3941 3941 1395968 148 Libby Schaaf for Mayor 2018 Officeholder Committee 259 CTL 2021-01-21 2020-07-01 2020-12-31   PDT49 OTH DoorDash       San Francisco CA 94105 2020-12-15 500 1000   $50 Gift Cards for Peter Radu, Kyra Mungia, Messiah Maydun, Caleb Smith, Shereda Nosakhare, Lauren Blanchard, Justin Berton, Sun Kwong Sze, Elinor Buchen, and David Silver   Schaaf Libby     MAY City of Oakland, CA              
3942 3942 1395968 148 Libby Schaaf for Mayor 2018 Officeholder Committee 259 CTL 2021-01-21 2020-07-01 2020-12-31   PDT50 OTH DoorDash       San Francisco CA 94105 2020-12-15 500 1000   $50 Gift Cards for Warren Logan, Kelley Kahn, Darin Ranelletti, Yvonna Cazares, Jasmine Pournavab, Audrey Momoh, Tim Fisher, Patrice Berry, Rafaella Cohen, & Jordon Micken   Schaaf Libby     MAY City of Oakland, CA              
3943 3943 1395968 148 Libby Schaaf for Mayor 2018 Officeholder Committee 259 CTL 2021-01-21 2020-07-01 2020-12-31   NON656 OTH United States Postal Service       Washington DC 20260 2020-12-21 513.1 0 POS     Schaaf Libby     MAY City of Oakland, CA              
3510 3510 1395968 148 Libby Schaaf for Mayor 2018 Officeholder Committee 259 CTL 2020-01-29 2019-07-01 2019-12-31   PDT42 OTH El Huarache Azteca Restaurant       Oakland CA 94601 2019-12-16 637.83 637.83 MTG 12/16/19: Staff holiday party, Officeholder in attendance   Schaaf Libby     MAY City of Oakland, CA              
3526 3526 1395968 148 Libby Schaaf for Mayor 2018 Officeholder Committee 259 CTL 2019-07-25 2019-01-01 2019-06-30   PDT12 OTH FedEx       Dallax TX 75240 2019-01-10 24.58 728.89 MTG 01/12/19: Signage for Inauguration Event, Candidate in attendance   Schaaf Libby     MAY City of Oakland, CA              
3527 3527 1395968 148 Libby Schaaf for Mayor 2018 Officeholder Committee 259 CTL 2019-07-25 2019-01-01 2019-06-30   PDT8 OTH FedEx       Dallax TX 75240 2019-01-11 61.79 728.89 MTG 01/12/19: Signage for Inauguration Event, Candidate in attendance   Schaaf Libby     MAY City of Oakland, CA              
3528 3528 1395968 148 Libby Schaaf for Mayor 2018 Officeholder Committee 259 CTL 2019-07-25 2019-01-01 2019-06-30   PDT9 OTH FedEx       Dallax TX 75240 2019-01-11 8.19 728.89 MTG 01/12/19: Signage for Inauguration Event, Candidate in attendance   Schaaf Libby     MAY City of Oakland, CA              
3529 3529 1395968 148 Libby Schaaf for Mayor 2018 Officeholder Committee 259 CTL 2019-07-25 2019-01-01 2019-06-30   PDT10 OTH FedEx       Dallax TX 75240 2019-01-11 24.58 728.89 MTG 01/12/19: Signage for Inauguration Event, Candidate in attendance   Schaaf Libby     MAY City of Oakland, CA              
3530 3530 1395968 148 Libby Schaaf for Mayor 2018 Officeholder Committee 259 CTL 2019-07-25 2019-01-01 2019-06-30   PDT11 OTH FedEx       Dallax TX 75240 2019-01-11 470.32 728.89 MTG 01/12/19: Signage for Inauguration Event, Candidate in attendance   Schaaf Libby     MAY City of Oakland, CA              
3531 3531 1395968 148 Libby Schaaf for Mayor 2018 Officeholder Committee 259 CTL 2019-07-25 2019-01-01 2019-06-30   PDT13 OTH FedEx       Dallax TX 75240 2019-01-11 92.69 728.89 MTG 01/12/19: Signage for Inauguration Event, Candidate in attendance   Schaaf Libby     MAY City of Oakland, CA              
3532 3532 1395968 148 Libby Schaaf for Mayor 2018 Officeholder Committee 259 CTL 2019-07-25 2019-01-01 2019-06-30   PDT14 OTH FedEx       Dallax TX 75240 2019-01-12 46.74 728.89 MTG 01/12/19: Signage for Inauguration Event, Candidate in attendance   Schaaf Libby     MAY City of Oakland, CA              
3533 3533 1395968 148 Libby Schaaf for Mayor 2018 Officeholder Committee 259 CTL 2019-07-25 2019-01-01 2019-06-30   PDT17 OTH Honey Bucket Portable Restrooms       Pittsburg CA 94565 2019-01-02 899.71 899.71 MTG 01/12/19: Portable toilets for Inauguration Event, Candidate in attendance   Schaaf Libby     MAY City of Oakland, CA              
3534 3534 1395968 148 Libby Schaaf for Mayor 2018 Officeholder Committee 259 CTL 2019-07-25 2019-01-01 2019-06-30   PDT19 OTH Insurevents       Culver City CA 90230 2019-01-08 644 644 MTG 01/12/19: Event Insurance for Inauguration Event, Candidate in attendance   Schaaf Libby     MAY City of Oakland, CA              
3535 3535 1395968 148 Libby Schaaf for Mayor 2018 Officeholder Committee 259 CTL 2019-07-25 2019-01-01 2019-06-30   PDT18 OTH International Alliance of Theatrical Stage Employees       Oakland CA 94621 2019-01-12 655 655 MTG 01/12/19: Stagehand for Inauguration Event, Candidate in attendance   Schaaf Libby     MAY City of Oakland, CA              

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