home / election_finance

summaries

Summary, FPPC Form 460, Summary Page

Data source: Summary

225 rows where filer_name = 47 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, total_this_period, year_to_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
13000 13000 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 100
13001 13001 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 0
13002 13002 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 100
13003 13003 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 0
13004 13004 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 100
13005 13005 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 100
13006 13006 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 0
13007 13007 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 100
13008 13008 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 0
13009 13009 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 0
13010 13010 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 100
13011 13011 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 0
13012 13012 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 0
13013 13013 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 0
13014 13014 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 0
13015 13015 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 0
13016 13016 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 0
13017 13017 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 0
13018 13018 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 0
13019 13019 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 0
13020 13020 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 0
13021 13021 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 0
13022 13022 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 0
13023 13023 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 0
13024 13024 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 0
13025 13025 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 0
13026 13026 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 0
13027 13027 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 0
13028 13028 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 0
13029 13029 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 0
13030 13030 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 0
13031 13031 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 0
13032 13032 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 0
13033 13033 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 0
13034 13034 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 0
13035 13035 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 0
13036 13036 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 0
13037 13037 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 0
13038 13038 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 0
13039 13039 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 0
13040 13040 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 0
13041 13041 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 0
13042 13042 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 0
13043 13043 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 0
13044 13044 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-12-29 2014-10-18 2014-12-30 2014-11-04 SMRY 0 0
13400 13400 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 100
13401 13401 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 0
13402 13402 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 100
13403 13403 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 0
13404 13404 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 100
13405 13405 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 100
13406 13406 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 0
13407 13407 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 100
13408 13408 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 0
13409 13409 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 0
13410 13410 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 100
13411 13411 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 0
13412 13412 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 0
13413 13413 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 0
13414 13414 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 0
13415 13415 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 0
13416 13416 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 0
13417 13417 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 0
13418 13418 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 0
13419 13419 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 0
13420 13420 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 0
13421 13421 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 0
13422 13422 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 0
13423 13423 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 0
13424 13424 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 0
13425 13425 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 0
13426 13426 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 0
13427 13427 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 0
13428 13428 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 0
13429 13429 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 0
13430 13430 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 0
13431 13431 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 0
13432 13432 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 0
13433 13433 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 0
13434 13434 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 0
13435 13435 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 0
13436 13436 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 0
13437 13437 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 0
13438 13438 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 0
13439 13439 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 0
13440 13440 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 0
13441 13441 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 0
13442 13442 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 0
13443 13443 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 0
13444 13444 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-28 2014-10-01 2014-10-18 2014-11-04 SMRY 0 0
15353 15353 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-06 2014-07-01 2014-09-30 2014-11-04 SMRY 100 100
15354 15354 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-06 2014-07-01 2014-09-30 2014-11-04 SMRY 0 0
15355 15355 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-06 2014-07-01 2014-09-30 2014-11-04 SMRY 100 100
15356 15356 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-06 2014-07-01 2014-09-30 2014-11-04 SMRY 0 0
15357 15357 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-06 2014-07-01 2014-09-30 2014-11-04 SMRY 100 100
15358 15358 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-06 2014-07-01 2014-09-30 2014-11-04 SMRY 0 100
15359 15359 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-06 2014-07-01 2014-09-30 2014-11-04 SMRY 0 0
15360 15360 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-06 2014-07-01 2014-09-30 2014-11-04 SMRY 0 100
15361 15361 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-06 2014-07-01 2014-09-30 2014-11-04 SMRY 0 0
15362 15362 Pending 20 Patrick McCullough Mayor 2014 47 CTL 2014-10-06 2014-07-01 2014-09-30 2014-11-04 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 19.396ms · Data source: Summary