summaries

Summary, FPPC Form 460, Summary Page

Data source: Summary

45 rows where filer_id = 65 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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
6787 6787 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 650 650
6788 6788 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 0 0
6789 6789 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 650 650
6790 6790 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 0 0
6791 6791 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 650 650
6792 6792 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 688.54 688.54
6793 6793 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 0 0
6794 6794 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 688.54 688.54
6795 6795 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 0 0
6796 6796 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 0 0
6797 6797 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 688.54 688.54
6798 6798 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 38.54 0
6799 6799 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 650 0
6800 6800 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 0 0
6801 6801 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 688.54 0
6802 6802 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 0 0
6803 6803 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 0 0
6804 6804 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 0 0
6805 6805 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 0 0
6806 6806 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 650 0
6807 6807 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 0 0
6808 6808 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 650 0
6809 6809 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 0 0
6810 6810 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 0 0
6811 6811 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 0 0
6812 6812 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 0 0
6813 6813 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 0 0
6814 6814 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 0 0
6815 6815 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 0 0
6816 6816 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 0 0
6817 6817 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 0 0
6818 6818 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 688.54 0
6819 6819 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 0 0
6820 6820 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 0 0
6821 6821 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 688.54 0
6822 6822 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 0 0
6823 6823 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 0 0
6824 6824 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 0 0
6825 6825 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 0 0
6826 6826 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 0 0
6827 6827 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 0 0
6828 6828 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 0 0
6829 6829 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 0 0
6830 6830 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 0 0
6831 6831 1346362 65 Amy Lemley for City Council 2012 61 CTL 2013-07-10 2013-01-01 2013-06-05 2012-11-06 SMRY 0 0

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