summaries

Summary, FPPC Form 460, Summary Page

Data source: Summary

225 rows where filer_id = 142 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: report_date, report_start_date, report_end_date, election_date, 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
38353 38353 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY 8100.17 8100.17
38354 38354 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY -8100.17 6899.83
38355 38355 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY 0 15000
38356 38356 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
38357 38357 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY 0 15000
38358 38358 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY 9399.83 9399.83
38359 38359 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
38360 38360 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY 9399.83 9399.83
38361 38361 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
38362 38362 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
38363 38363 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY 9399.83 9399.83
38364 38364 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY 9399.83 0
38365 38365 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
38366 38366 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
38367 38367 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY 9399.83 0
38368 38368 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
38369 38369 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
38370 38370 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
38371 38371 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY 6899.83 0
38372 38372 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY 8100.17 0
38373 38373 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
38374 38374 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY 8100.17 0
38375 38375 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
38376 38376 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY 8100.17 0
38377 38377 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY -8100.17 0
38378 38378 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
38379 38379 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
38380 38380 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
38381 38381 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
38382 38382 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
38383 38383 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
38384 38384 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY 9399.83 0
38385 38385 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
38386 38386 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
38387 38387 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY 9399.83 0
38388 38388 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
38389 38389 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
38390 38390 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
38391 38391 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
38392 38392 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
38393 38393 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
38394 38394 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
38395 38395 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
38396 38396 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
38397 38397 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2018-01-29 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
42796 42796 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY 8100.17 8100.17
42797 42797 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY -8100.17 6899.83
42798 42798 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY 0 15000
42799 42799 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
42800 42800 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY 0 15000
42801 42801 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY 9399.83 9399.83
42802 42802 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
42803 42803 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY 9399.83 9399.83
42804 42804 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
42805 42805 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
42806 42806 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY 9399.83 9399.83
42807 42807 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY 9399.83 0
42808 42808 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
42809 42809 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
42810 42810 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY 9399.83 0
42811 42811 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
42812 42812 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
42813 42813 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
42814 42814 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY 6899.83 0
42815 42815 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY 8100.17 0
42816 42816 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
42817 42817 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY 8100.17 0
42818 42818 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
42819 42819 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY 8100.17 0
42820 42820 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY -8100.17 0
42821 42821 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
42822 42822 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
42823 42823 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
42824 42824 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
42825 42825 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
42826 42826 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
42827 42827 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY 9399.83 0
42828 42828 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
42829 42829 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
42830 42830 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY 9399.83 0
42831 42831 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
42832 42832 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
42833 42833 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
42834 42834 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
42835 42835 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
42836 42836 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
42837 42837 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
42838 42838 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
42839 42839 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
42840 42840 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-07-31 2017-01-01 2017-06-30 2016-11-08 SMRY 0 0
31205 31205 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-01-18 2016-10-23 2016-12-31 2017-11-08 SMRY 6700.41 54842.41
31206 31206 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-01-18 2016-10-23 2016-12-31 2017-11-08 SMRY 5000 15000
31207 31207 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-01-18 2016-10-23 2016-12-31 2017-11-08 SMRY 11700.41 69842.41
31208 31208 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-01-18 2016-10-23 2016-12-31 2017-11-08 SMRY 0 0
31209 31209 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-01-18 2016-10-23 2016-12-31 2017-11-08 SMRY 11700.41 69842.41
31210 31210 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-01-18 2016-10-23 2016-12-31 2017-11-08 SMRY 23578.33 60442.58
31211 31211 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-01-18 2016-10-23 2016-12-31 2017-11-08 SMRY 0 0
31212 31212 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-01-18 2016-10-23 2016-12-31 2017-11-08 SMRY 23578.33 60442.58
31213 31213 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-01-18 2016-10-23 2016-12-31 2017-11-08 SMRY 0 0
31214 31214 1387192 142 Viola Gonzales for City Council 2016 164 CTL 2017-01-18 2016-10-23 2016-12-31 2017-11-08 SMRY 0 0

Next page

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