summaries

Summary, FPPC Form 460, Summary Page

Data source: Summary

36 rows where filer_id = 7 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
2918 2918 1344614 7 Moving Oakland Forward 7 BMC 2012-07-15 2012-04-01 2012-06-30   SMRY 0 1109
2919 2919 1344614 7 Moving Oakland Forward 7 BMC 2012-07-15 2012-04-01 2012-06-30   SMRY -500 0
2920 2920 1344614 7 Moving Oakland Forward 7 BMC 2012-07-15 2012-04-01 2012-06-30   SMRY -500 1109
2921 2921 1344614 7 Moving Oakland Forward 7 BMC 2012-07-15 2012-04-01 2012-06-30   SMRY 601.49 601.49
2922 2922 1344614 7 Moving Oakland Forward 7 BMC 2012-07-15 2012-04-01 2012-06-30   SMRY 101.49 1710.49
2923 2923 1344614 7 Moving Oakland Forward 7 BMC 2012-07-15 2012-04-01 2012-06-30   SMRY 322.84 1115.02
2924 2924 1344614 7 Moving Oakland Forward 7 BMC 2012-07-15 2012-04-01 2012-06-30   SMRY 0 0
2925 2925 1344614 7 Moving Oakland Forward 7 BMC 2012-07-15 2012-04-01 2012-06-30   SMRY 322.84 1115.02
2926 2926 1344614 7 Moving Oakland Forward 7 BMC 2012-07-15 2012-04-01 2012-06-30   SMRY 0 0
2927 2927 1344614 7 Moving Oakland Forward 7 BMC 2012-07-15 2012-04-01 2012-06-30   SMRY 601.49 601.49
2928 2928 1344614 7 Moving Oakland Forward 7 BMC 2012-07-15 2012-04-01 2012-06-30   SMRY 924.33 1716.51
2929 2929 1344614 7 Moving Oakland Forward 7 BMC 2012-07-15 2012-04-01 2012-06-30   SMRY 816.83 0
2930 2930 1344614 7 Moving Oakland Forward 7 BMC 2012-07-15 2012-04-01 2012-06-30   SMRY -500 0
2931 2931 1344614 7 Moving Oakland Forward 7 BMC 2012-07-15 2012-04-01 2012-06-30   SMRY 6.01 0
2932 2932 1344614 7 Moving Oakland Forward 7 BMC 2012-07-15 2012-04-01 2012-06-30   SMRY 322.84 0
2933 2933 1344614 7 Moving Oakland Forward 7 BMC 2012-07-15 2012-04-01 2012-06-30   SMRY 0 0
2934 2934 1344614 7 Moving Oakland Forward 7 BMC 2012-07-15 2012-04-01 2012-06-30   SMRY 0 0
2935 2935 1344614 7 Moving Oakland Forward 7 BMC 2012-07-15 2012-04-01 2012-06-30   SMRY 0 0
2936 2936 1344614 7 Moving Oakland Forward 7 BMC 2012-07-15 2012-04-01 2012-06-30   SMRY 0 0
2937 2937 1344614 7 Moving Oakland Forward 7 BMC 2012-07-15 2012-04-01 2012-06-30   SMRY 500 0
2938 2938 1344614 7 Moving Oakland Forward 7 BMC 2012-07-15 2012-04-01 2012-06-30   SMRY 101.49 0
2939 2939 1344614 7 Moving Oakland Forward 7 BMC 2012-07-15 2012-04-01 2012-06-30   SMRY 601.49 0
2940 2940 1344614 7 Moving Oakland Forward 7 BMC 2012-07-15 2012-04-01 2012-06-30   SMRY 0 0
2941 2941 1344614 7 Moving Oakland Forward 7 BMC 2012-07-15 2012-04-01 2012-06-30   SMRY 6.01 0
2942 2942 1344614 7 Moving Oakland Forward 7 BMC 2012-07-15 2012-04-01 2012-06-30   SMRY 0 0
2943 2943 1344614 7 Moving Oakland Forward 7 BMC 2012-07-15 2012-04-01 2012-06-30   SMRY 6.01 0
2944 2944 1344614 7 Moving Oakland Forward 7 BMC 2012-07-15 2012-04-01 2012-06-30   SMRY 310.84 0
2945 2945 1344614 7 Moving Oakland Forward 7 BMC 2012-07-15 2012-04-01 2012-06-30   SMRY 12 0
2946 2946 1344614 7 Moving Oakland Forward 7 BMC 2012-07-15 2012-04-01 2012-06-30   SMRY 0 0
2947 2947 1344614 7 Moving Oakland Forward 7 BMC 2012-07-15 2012-04-01 2012-06-30   SMRY 322.84 0
2948 2948 1344614 7 Moving Oakland Forward 7 BMC 2012-07-15 2012-04-01 2012-06-30   SMRY 0 0
2949 2949 1344614 7 Moving Oakland Forward 7 BMC 2012-07-15 2012-04-01 2012-06-30   SMRY 500 0
2950 2950 1344614 7 Moving Oakland Forward 7 BMC 2012-07-15 2012-04-01 2012-06-30   SMRY -500 0
2951 2951 1344614 7 Moving Oakland Forward 7 BMC 2012-07-15 2012-04-01 2012-06-30   SMRY 0 0
2952 2952 1344614 7 Moving Oakland Forward 7 BMC 2012-07-15 2012-04-01 2012-06-30   SMRY 0 0
2953 2953 1344614 7 Moving Oakland Forward 7 BMC 2012-07-15 2012-04-01 2012-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");