summaries

Summary, FPPC Form 460, Summary Page

Data source: Summary

45 rows where filer_id = 12 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
903 903 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY 13690 13690
904 904 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY 19000 19000
905 905 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY 32690 32690
906 906 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY 0 0
907 907 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY 32690 32690
908 908 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY 49949.9 49949.9
909 909 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY 0 0
910 910 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY 49949.9 49949.9
911 911 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY 0 0
912 912 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY 0 0
913 913 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY 49949.9 49949.9
914 914 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY 0 0
915 915 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY 32690 0
916 916 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY 0 0
917 917 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY 49949.9 0
918 918 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY -17259.9 0
919 919 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY 0 0
920 920 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY 0 0
921 921 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY 19000 0
922 922 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY 12847 0
923 923 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY 843 0
924 924 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY 13690 0
925 925 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY 19000 0
926 926 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY 0 0
927 927 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY 19000 0
928 928 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY 0 0
929 929 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY 0 0
930 930 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY 0 0
931 931 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY 0 0
932 932 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY 0 0
933 933 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY 0 0
934 934 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY 49740.9 0
935 935 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY 209 0
936 936 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY 0 0
937 937 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY 49949.9 0
938 938 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY 0 0
939 939 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY 0 0
940 940 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY 0 0
941 941 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY 0 0
942 942 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY 0 0
943 943 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY 0 0
944 944 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY 0 0
945 945 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY 0 0
946 946 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 2012-11-06 SMRY 0 0
947 947 1341977 12 Friends of Dewitt for Oakland City Council 2012 12 CTL 2013-01-31 2012-07-01 2012-12-31 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");