summaries

Summary, FPPC Form 460, Summary Page

Data source: Summary

48 rows where filer_id = 47 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
3756 3756 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 4925.49 4925.49
3757 3757 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 205 205
3758 3758 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 5130.49 5130.49
3759 3759 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 0 0
3760 3760 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 5130.49 5130.49
3761 3761 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 4418.83 4418.83
3762 3762 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 0 0
3763 3763 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 4418.83 4418.83
3764 3764 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 0 0
3765 3765 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 0 0
3766 3766 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 4418.83 4418.83
3767 3767 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 0  
3768 3768 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 5130.49  
3769 3769 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 0  
3770 3770 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 4418.83  
3771 3771 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 711.66  
3772 3772 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 0  
3773 3773 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 0  
3774 3774 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 205  
3775 3775 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY    
3776 3776 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY    
3777 3777 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 1374  
3778 3778 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 4225  
3779 3779 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 700.49  
3780 3780 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 4925.49  
3781 3781 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 205  
3782 3782 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 0  
3783 3783 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 205  
3784 3784 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 0  
3785 3785 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 0  
3786 3786 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 0  
3787 3787 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 0  
3788 3788 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 0  
3789 3789 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 0  
3790 3790 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 3888.6  
3791 3791 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 530.23  
3792 3792 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 0  
3793 3793 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 4418.83  
3794 3794 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 0  
3795 3795 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 0  
3796 3796 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 0  
3797 3797 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 0  
3798 3798 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 0  
3799 3799 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 0  
3800 3800 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 0  
3801 3801 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 0  
3802 3802 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 0  
3803 3803 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 CAO 2014-01-31 2013-07-01 2013-12-31   SMRY 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");