on_behalf_of_expenditures

FPPC Form 460, Schedule G

Data source: G_Expenditure

19 rows where filer_id = 263 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), 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
5612 5612 1441869 263 Johnson Oakland Mayor 2022 340 CTL 2022-07-21 2022-01-01 2022-06-30 2022-11-08 NON305 OTH Oakland Marriott City Center       Oakland CA 94607 2022-01-14 1314.3 0 TRS 01/14-01/23/22: Consultant hotel stay for meetings with Candidate, Candidate in attendance   Johnson Derreck B.     MAY City of Oakland, CA              
5613 5613 1441869 263 Johnson Oakland Mayor 2022 340 CTL 2022-07-21 2022-01-01 2022-06-30 2022-11-08 PDT49 OTH Instrumental       Brooklyn NY 11215 2022-01-02 175 2500 WEB     Johnson Derreck B.     MAY City of Oakland, CA              
5614 5614 1441869 263 Johnson Oakland Mayor 2022 340 CTL 2022-07-21 2022-01-01 2022-06-30 2022-11-08 PDT36 OTH Booking.com       Norwalk CT 06854 2022-01-14 1314.3 1314.3 TRS 01/14-01/23/22: Consultant hotel stay for meetings with Candidate, Candidate in attendance   Johnson Derreck B.     MAY City of Oakland, CA              
4259 4259 1441869 263 Johnson Oakland Mayor 2022 340 CTL 2022-07-17 2021-01-01 2021-12-31 2022-11-08 NON93 OTH The Mayflower Hotel, Autograph Collection       Washington DC 20036 2021-09-15 870.19 0 TRC 09/17-09/20/21: Candidate hotel for meetings in Washington DC, Candidate in attendance   Johnson Derreck B.     MAY City of Oakland, CA              
4260 4260 1441869 263 Johnson Oakland Mayor 2022 340 CTL 2022-07-17 2021-01-01 2021-12-31 2022-11-08 PDT23 OTH Eighty Squared, LLC       Washington DC 20016 2021-11-17 500 750   Graphic Design services   Johnson Derreck B.     MAY City of Oakland, CA              
4261 4261 1441869 263 Johnson Oakland Mayor 2022 340 CTL 2022-07-17 2021-01-01 2021-12-31 2022-11-08 PDT1 OTH Eighty Squared, LLC       Washington DC 20016 2021-12-03 250 750   Design Services   Johnson Derreck B.     MAY City of Oakland, CA              
4262 4262 1441869 263 Johnson Oakland Mayor 2022 340 CTL 2022-07-17 2021-01-01 2021-12-31 2022-11-08 PDT4 OTH Atlas       Oakland CA 94612 2021-10-26 500 500 MTG 11/13/21: Venue for Campaign Kick-off event, Candidate in attendance   Johnson Derreck B.     MAY City of Oakland, CA              
4263 4263 1441869 263 Johnson Oakland Mayor 2022 340 CTL 2022-07-17 2021-01-01 2021-12-31 2022-11-08 PDT18 OTH Gussie's Southern Table       Oakland CA 94612 2021-11-13 1485.36 1485.36 MTG 11/13/21: Food for Kick-off event, Candidate in attendance   Johnson Derreck B.     MAY City of Oakland, CA              
4264 4264 1441869 263 Johnson Oakland Mayor 2022 340 CTL 2022-07-17 2021-01-01 2021-12-31 2022-11-08 PDT2 OTH Hotels.com       Reno NV 89501 2021-09-15 870.19 870.19 TRC 09/17-09/20/21: Candidate hotel for meetings with Mosaic in Washington DC, Candidate in attendance   Johnson Derreck B.     MAY City of Oakland, CA              
4265 4265 1441869 263 Johnson Oakland Mayor 2022 340 CTL 2022-07-17 2021-01-01 2021-12-31 2022-11-08 PDT9 OTH Pro Copy & Printing       Oakland CA 94612 2021-11-12 297.67 772.06 CMP     Johnson Derreck B.     MAY City of Oakland, CA              
4266 4266 1441869 263 Johnson Oakland Mayor 2022 340 CTL 2022-07-17 2021-01-01 2021-12-31 2022-11-08 PDT3 OTH United Airlines       Chicago IL 60606 2021-09-18 702.6 702.6 TRC 09/17-09/20/21: Candidate return flight for meetings with Mosaic in Washington DC, Candidate in attendance   Johnson Derreck B.     MAY City of Oakland, CA              
4364 4364 1441869 263 Johnson Oakland Mayor 2022 340 CTL 2022-01-28 2021-01-01 2021-12-31 2022-11-08 NON93 OTH The Mayflower Hotel, Autograph Collection       Washington DC 20036 2021-09-15 870.19 0 TRC 09/17-09/20/21: Candidate hotel for meetings in Washington DC, Candidate in attendance   Johnson Derreck B.     MAY City of Oakland, CA              
4365 4365 1441869 263 Johnson Oakland Mayor 2022 340 CTL 2022-01-28 2021-01-01 2021-12-31 2022-11-08 PDT23 OTH Eighty Squared, LLC       Washington DC 20016 2021-11-17 500 750   Graphic Design services   Johnson Derreck B.     MAY City of Oakland, CA              
4366 4366 1441869 263 Johnson Oakland Mayor 2022 340 CTL 2022-01-28 2021-01-01 2021-12-31 2022-11-08 PDT1 OTH Eighty Squared, LLC       Washington DC 20016 2021-12-03 250 750   Design Services   Johnson Derreck B.     MAY City of Oakland, CA              
4367 4367 1441869 263 Johnson Oakland Mayor 2022 340 CTL 2022-01-28 2021-01-01 2021-12-31 2022-11-08 PDT4 OTH Atlas       Oakland CA 94612 2021-10-26 500 500 MTG 11/13/21: Venue for Campaign Kick-off event, Candidate in attendance   Johnson Derreck B.     MAY City of Oakland, CA              
4368 4368 1441869 263 Johnson Oakland Mayor 2022 340 CTL 2022-01-28 2021-01-01 2021-12-31 2022-11-08 PDT18 OTH Gussie's Catering       Oakland CA 94612 2021-11-13 1485.36 1485.36 MTG 11/13/21: Food for Kick-off event, Candidate in attendance   Johnson Derreck B.     MAY City of Oakland, CA              
4369 4369 1441869 263 Johnson Oakland Mayor 2022 340 CTL 2022-01-28 2021-01-01 2021-12-31 2022-11-08 PDT2 OTH Hotels.com       Reno NV 89501 2021-09-15 870.19 870.19 TRC 09/17-09/20/21: Candidate hotel for meetings with Mosaic in Washington DC, Candidate in attendance   Johnson Derreck B.     MAY City of Oakland, CA              
4370 4370 1441869 263 Johnson Oakland Mayor 2022 340 CTL 2022-01-28 2021-01-01 2021-12-31 2022-11-08 PDT9 OTH Pro Copy & Printing       Oakland CA 94612 2021-11-12 297.67 772.06 CMP     Johnson Derreck B.     MAY City of Oakland, CA              
4371 4371 1441869 263 Johnson Oakland Mayor 2022 340 CTL 2022-01-28 2021-01-01 2021-12-31 2022-11-08 PDT3 OTH United Airlines       Chicago IL 60606 2021-09-18 702.6 702.6 TRC 09/17-09/20/21: Candidate return flight for meetings with Mosaic in Washington DC, Candidate in attendance   Johnson Derreck B.     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");