home / election_finance

summaries

Summary, FPPC Form 460, Summary Page

Data source: Summary

225 rows where filer_name = 205 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, 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
62536 62536 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY 0 0
62537 62537 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY -2000 36600
62538 62538 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY -2000 36600
62539 62539 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY 0 0
62540 62540 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY -2000 36600
62541 62541 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY 383.23 383.23
62542 62542 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY 0 0
62543 62543 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY 383.23 383.23
62544 62544 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY 0 0
62545 62545 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY 0 0
62546 62546 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY 383.23 383.23
62547 62547 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY 2333.23 0
62548 62548 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY -2000 0
62549 62549 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY 50 0
62550 62550 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY 383.23 0
62551 62551 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY 0 0
62552 62552 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY 0 0
62553 62553 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY 0 0
62554 62554 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY 36600 0
62555 62555 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY 0 0
62556 62556 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY 0 0
62557 62557 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY 0 0
62558 62558 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY 0 0
62559 62559 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY 2000 0
62560 62560 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY -2000 0
62561 62561 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY 0 0
62562 62562 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY 0 0
62563 62563 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY 0 0
62564 62564 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY 0 0
62565 62565 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY 0 0
62566 62566 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY 0 0
62567 62567 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY 383.23 0
62568 62568 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY 0 0
62569 62569 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY 0 0
62570 62570 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY 383.23 0
62571 62571 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY 0 0
62572 62572 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY 0 0
62573 62573 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY 0 0
62574 62574 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY 0 0
62575 62575 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY 0 0
62576 62576 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY 0 0
62577 62577 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY 50 0
62578 62578 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY 0 0
62579 62579 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY 0 0
62580 62580 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-07-30 2019-01-01 2019-06-30 2018-11-06 SMRY 50 0
50093 50093 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 4100 17999
50094 50094 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 0 38600
50095 50095 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 4100 56599
50096 50096 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 0 1742.65
50097 50097 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 4100 58341.65
50098 50098 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 19259.55 54265.77
50099 50099 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
50100 50100 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 19259.55 54265.77
50101 50101 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
50102 50102 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 0 1742.65
50103 50103 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 19259.55 56008.42
50104 50104 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 17492.78 0
50105 50105 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 4100 0
50106 50106 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
50107 50107 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 19259.55 0
50108 50108 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 2333.23 0
50109 50109 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
50110 50110 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
50111 50111 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 38600 0
50112 50112 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 3300 0
50113 50113 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 800 0
50114 50114 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 4100 0
50115 50115 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
50116 50116 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
50117 50117 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
50118 50118 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
50119 50119 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
50120 50120 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
50121 50121 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
50122 50122 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
50123 50123 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
50124 50124 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 19259.55 0
50125 50125 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
50126 50126 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
50127 50127 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 19259.55 0
50128 50128 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
50129 50129 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
50130 50130 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
50131 50131 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
50132 50132 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
50133 50133 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
50134 50134 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
50135 50135 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
50136 50136 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
50137 50137 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2019-01-17 2018-10-21 2018-12-31 2018-11-06 SMRY 0 0
51412 51412 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2018-10-24 2018-09-23 2018-10-20 2018-11-06 SMRY 2000 14699
51413 51413 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2018-10-24 2018-09-23 2018-10-20 2018-11-06 SMRY 0 38600
51414 51414 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2018-10-24 2018-09-23 2018-10-20 2018-11-06 SMRY 2000 53299
51415 51415 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2018-10-24 2018-09-23 2018-10-20 2018-11-06 SMRY 0 1742.65
51416 51416 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2018-10-24 2018-09-23 2018-10-20 2018-11-06 SMRY 2000 55041.65
51417 51417 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2018-10-24 2018-09-23 2018-10-20 2018-11-06 SMRY 15691.13 35038.52
51418 51418 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2018-10-24 2018-09-23 2018-10-20 2018-11-06 SMRY 0 0
51419 51419 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2018-10-24 2018-09-23 2018-10-20 2018-11-06 SMRY 15691.13 35038.52
51420 51420 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2018-10-24 2018-09-23 2018-10-20 2018-11-06 SMRY -1300 0
51421 51421 1406398 163 JOSEPH SIMMONS FOR OAKLAND CITY COUNCIL (DISTRICT 4) 2018 205 CTL 2018-10-24 2018-09-23 2018-10-20 2018-11-06 SMRY 0 1742.65

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");
Powered by Datasette · Queries took 13.824ms · Data source: Summary