home / election_finance

summaries

Summary, FPPC Form 460, Summary Page

Data source: Summary

562 rows where filer_id = 170 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, report_date (date), report_start_date (date), report_end_date (date), election_date (date)

Link rowid filer_id filer_name committee_type report_date ▲ report_start_date report_end_date election_date record_type total_this_period year_to_date
107838 107838 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY 260.45 260.45
107839 107839 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY 0 0
107840 107840 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY 260.45 260.45
107841 107841 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY 0 0
107842 107842 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY 260.45 260.45
107843 107843 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY 429.35 429.35
107844 107844 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY 0 0
107845 107845 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY 429.35 429.35
107846 107846 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY -131.37 0
107847 107847 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY 0 0
107848 107848 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY 297.98 429.35
107849 107849 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY 168.9 0
107850 107850 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY 260.45 0
107851 107851 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY 0 0
107852 107852 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY 429.35 0
107853 107853 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY 0 0
107854 107854 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY 0 0
107855 107855 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY 0 0
107856 107856 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY 0 0
107857 107857 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY 260.45 0
107858 107858 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY 0 0
107859 107859 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY 260.45 0
107860 107860 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY 0 0
107861 107861 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY 0 0
107862 107862 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY 0 0
107863 107863 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY 0 0
107864 107864 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY 0 0
107865 107865 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY 0 0
107866 107866 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY 0 0
107867 107867 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY 0 0
107868 107868 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY 0 0
107869 107869 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY 429.35 0
107870 107870 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY 0 0
107871 107871 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY 0 0
107872 107872 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY 429.35 0
107873 107873 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY -131.37 0
107874 107874 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY 0 0
107875 107875 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY -131.37 0
107876 107876 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY 0 0
107877 107877 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY 0 0
107878 107878 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY 0 0
107879 107879 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY 0 0
107880 107880 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY 0 0
107881 107881 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY 0 0
107882 107882 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-07-26 2023-01-01 2023-06-30 2018-11-06 SMRY 0 0
92278 92278 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 0 200
92279 92279 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 0 0
92280 92280 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 0 200
92281 92281 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 0 0
92282 92282 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 0 200
92283 92283 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 225.84 875.84
92284 92284 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 0 0
92285 92285 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 225.84 875.84
92286 92286 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 0 131.37
92287 92287 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 0 0
92288 92288 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 225.84 1007.21
92289 92289 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 394.74 0
92290 92290 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 0 0
92291 92291 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 0 0
92292 92292 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 225.84 0
92293 92293 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 168.9 0
92294 92294 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 0 0
92295 92295 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 0 0
92296 92296 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 131.37 0
92297 92297 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 0 0
92298 92298 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 0 0
92299 92299 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 0 0
92300 92300 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 0 0
92301 92301 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 0 0
92302 92302 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 0 0
92303 92303 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 0 0
92304 92304 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 0 0
92305 92305 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 0 0
92306 92306 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 0 0
92307 92307 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 0 0
92308 92308 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 0 0
92309 92309 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 225.84 0
92310 92310 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 0 0
92311 92311 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 0 0
92312 92312 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 225.84 0
92313 92313 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 0 0
92314 92314 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 0 0
92315 92315 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 0 0
92316 92316 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 0 0
92317 92317 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 0 0
92318 92318 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 0 0
92319 92319 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 0 0
92320 92320 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 0 0
92321 92321 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 0 0
92322 92322 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2023-01-31 2022-07-01 2022-12-31 2018-11-06 SMRY 0 0
99642 99642 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2022-07-31 2022-01-01 2022-06-30 2018-11-06 SMRY 200 200
99643 99643 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2022-07-31 2022-01-01 2022-06-30 2018-11-06 SMRY 0 0
99644 99644 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2022-07-31 2022-01-01 2022-06-30 2018-11-06 SMRY 200 200
99645 99645 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2022-07-31 2022-01-01 2022-06-30 2018-11-06 SMRY 0 0
99646 99646 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2022-07-31 2022-01-01 2022-06-30 2018-11-06 SMRY 200 200
99647 99647 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2022-07-31 2022-01-01 2022-06-30 2018-11-06 SMRY 650 650
99648 99648 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2022-07-31 2022-01-01 2022-06-30 2018-11-06 SMRY 0 0
99649 99649 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2022-07-31 2022-01-01 2022-06-30 2018-11-06 SMRY 650 650
99650 99650 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2022-07-31 2022-01-01 2022-06-30 2018-11-06 SMRY -468.63 131.37
99651 99651 1408075 170 Courtney Ruby for Oakland City Auditor 2018 Officeholder 332 CTL 2022-07-31 2022-01-01 2022-06-30 2018-11-06 SMRY 0 0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "summaries" (
"filer_id" INTEGER,
  "filer_name" INTEGER,
  "committee_type" TEXT,
  "report_date" TEXT,
  "report_start_date" TEXT,
  "report_end_date" TEXT,
  "election_date" TEXT,
  "record_type" TEXT,
  "total_this_period" INTEGER,
  "year_to_date" INTEGER
,
FOREIGN KEY ("filer_id") REFERENCES [filer_ids](id),
    FOREIGN KEY ("filer_name") REFERENCES [filer_names](id));
CREATE INDEX ["summaries_filer_id"] ON [summaries]("filer_id");
CREATE INDEX ["summaries_filer_name"] ON [summaries]("filer_name");
Powered by Datasette · Queries took 75.005ms · Data source: Summary