summaries

Summary, FPPC Form 460, Summary Page

Data source: Summary

45 rows where filer_name = 60 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)

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
6695 6695 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 0 0
6696 6696 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 2500 2500
6697 6697 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 2500 2500
6698 6698 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 0 0
6699 6699 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 2500 2500
6700 6700 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 0 0
6701 6701 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 0 0
6702 6702 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 0 0
6703 6703 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 2500 2500
6704 6704 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 0 0
6705 6705 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 2500 2500
6706 6706 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 0 0
6707 6707 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 2500 0
6708 6708 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 0 0
6709 6709 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 0 0
6710 6710 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 2500 0
6711 6711 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 0 0
6712 6712 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 0 0
6713 6713 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 5000 0
6714 6714 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 0 0
6715 6715 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 0 0
6716 6716 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 0 0
6717 6717 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 2500 0
6718 6718 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 0 0
6719 6719 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 2500 0
6720 6720 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 0 0
6721 6721 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 0 0
6722 6722 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 0 0
6723 6723 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 0 0
6724 6724 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 0 0
6725 6725 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 0 0
6726 6726 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 0 0
6727 6727 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 0 0
6728 6728 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 0 0
6729 6729 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 0 0
6730 6730 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 2500 0
6731 6731 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 0 0
6732 6732 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 2500 0
6733 6733 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 0 0
6734 6734 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 0 0
6735 6735 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 0 0
6736 6736 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 0 0
6737 6737 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 0 0
6738 6738 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   SMRY 0 0
6739 6739 1236617 11 Friends of Desley Brooks 60 CTL 2013-07-26 2013-01-01 2013-06-30   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");