summaries

Summary, FPPC Form 460, Summary Page

Data source: Summary

225 rows where filer_name = 18 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, year_to_date, report_date (date), report_start_date (date), report_end_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
12367 12367 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 730 730
12368 12368 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 0 0
12369 12369 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 730 730
12370 12370 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 0 0
12371 12371 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 730 730
12372 12372 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 766.59 1147.59
12373 12373 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 0 0
12374 12374 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 766.59 1147.59
12375 12375 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 0 0
12376 12376 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 0 0
12377 12377 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 766.59 1147.59
12378 12378 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 36.59 0
12379 12379 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 730 0
12380 12380 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 0 0
12381 12381 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 766.59 0
12382 12382 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 0 0
12383 12383 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 0 0
12384 12384 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 0 0
12385 12385 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 0 0
12386 12386 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 700 0
12387 12387 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 30 0
12388 12388 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 730 0
12389 12389 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 0 0
12390 12390 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 0 0
12391 12391 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 0 0
12392 12392 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 0 0
12393 12393 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 0 0
12394 12394 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 0 0
12395 12395 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 100 0
12396 12396 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 0 0
12397 12397 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 100 0
12398 12398 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 421 0
12399 12399 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 345.59 0
12400 12400 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 0 0
12401 12401 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 766.59 0
12402 12402 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 0 0
12403 12403 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 0 0
12404 12404 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 0 0
12405 12405 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 0 0
12406 12406 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 0 0
12407 12407 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 0 0
12408 12408 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 0 0
12409 12409 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 0 0
12410 12410 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 0 0
12411 12411 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2015-01-28 2014-07-01 2014-12-31   SMRY 0 0
19085 19085 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 0 0
19086 19086 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 0 0
19087 19087 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 0 0
19088 19088 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 0 0
19089 19089 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 0 0
19090 19090 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 381 381
19091 19091 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 0 0
19092 19092 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 381 381
19093 19093 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 0 0
19094 19094 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 0 0
19095 19095 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 381 381
19096 19096 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 417.59 0
19097 19097 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 0 0
19098 19098 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 0 0
19099 19099 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 381 0
19100 19100 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 36.59 0
19101 19101 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 0 0
19102 19102 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 0 0
19103 19103 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 0 0
19104 19104 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 0 0
19105 19105 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 0 0
19106 19106 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 0 0
19107 19107 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 0 0
19108 19108 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 0 0
19109 19109 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 0 0
19110 19110 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 0 0
19111 19111 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 0 0
19112 19112 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 0 0
19113 19113 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 0 0
19114 19114 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 0 0
19115 19115 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 0 0
19116 19116 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 100 0
19117 19117 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 281 0
19118 19118 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 0 0
19119 19119 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 381 0
19120 19120 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 0 0
19121 19121 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 0 0
19122 19122 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 0 0
19123 19123 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 0 0
19124 19124 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 0 0
19125 19125 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 0 0
19126 19126 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 0 0
19127 19127 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 0 0
19128 19128 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 0 0
19129 19129 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-07-16 2014-01-01 2014-06-30   SMRY 0 0
4201 4201 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-01-31 2013-07-01 2013-12-31   SMRY 500 2000
4202 4202 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-01-31 2013-07-01 2013-12-31   SMRY 0 0
4203 4203 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-01-31 2013-07-01 2013-12-31   SMRY 500 2000
4204 4204 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-01-31 2013-07-01 2013-12-31   SMRY 0 0
4205 4205 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-01-31 2013-07-01 2013-12-31   SMRY 500 2000
4206 4206 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-01-31 2013-07-01 2013-12-31   SMRY 1095.67 1977.67
4207 4207 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-01-31 2013-07-01 2013-12-31   SMRY 0 0
4208 4208 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-01-31 2013-07-01 2013-12-31   SMRY 1095.67 1977.67
4209 4209 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-01-31 2013-07-01 2013-12-31   SMRY 0 0
4210 4210 1284364 18 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 18 CTL 2014-01-31 2013-07-01 2013-12-31   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");