Home

Filer ID: 1394684

Table: cvr_campaign_disclosure
filing_id   2177629   2177680   2141150   2193775   2186299   2196774   2197795   2237012   2237436   2211039   2252527   2237436   2296049   2310041   2272657   2310675   2296049   2369757   2347124   2378829   2416844   2393613   2367751   2416880   2473107   2466328   2466061   2480410   2440714   2503500   2519159   2552734   2575701   2645834   2610176   2674505   2604639   2620585   2586998   2597203   2702944   2747611
amend_id   0   0   0   0   0   0   0   0   0   0   0   1   1   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0
rec_type   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR   CVR
form_type   F460   F497   F497   F497   F497   F460   F497   F460   F460   F460   F460   F460   F460   F497   F460   F460   F460   F497   F460   F460   F497   F460   F497   F460   F497   F460   F497   F460   F460   F460   F460   F460   F460   F460   F460   F460   F460   F460   F497   F460   F460   F460
filer_id   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684
entity_cd   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP   RCP
filer_naml   COX; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN   COX; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN   COX; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN   COX; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN   COX; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN   COX; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN   COX TO CREATE NEIGHBORHOOD DISTRICTS; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN   COX TO CREATE NEIGHBORHOOD DISTRICTS; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN   COX TO CREATE NEIGHBORHOOD DISTRICTS; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN   COX TO CREATE NEIGHBORHOOD DISTRICTS; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN   COX TO CREATE NEIGHBORHOOD DISTRICTS; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN   COX TO CREATE NEIGHBORHOOD DISTRICTS; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN   COX TO CREATE NEIGHBORHOOD DISTRICTS; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN   COX TO CREATE NEIGHBORHOOD DISTRICTS; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN   COX TO CREATE NEIGHBORHOOD DISTRICTS; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN   COX TO CREATE NEIGHBORHOOD DISTRICTS; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN   COX TO CREATE NEIGHBORHOOD DISTRICTS; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN   COX TO CREATE NEIGHBORHOOD DISTRICTS; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN   COX TO CREATE NEIGHBORHOOD DISTRICTS; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN   COX TO CREATE NEIGHBORHOOD DISTRICTS; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN   COX TO CREATE NEIGHBORHOOD DISTRICTS; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN   COX TO CREATE NEIGHBORHOOD DISTRICTS; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN   COX TO CREATE NEIGHBORHOOD DISTRICTS; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN   COX TO CREATE NEIGHBORHOOD DISTRICTS; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN   COX TO CREATE NEIGHBORHOOD DISTRICTS; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN   COX TO CREATE NEIGHBORHOOD DISTRICTS; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN   COX TO CREATE NEIGHBORHOOD DISTRICTS; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN   COX TO CREATE NEIGHBORHOOD DISTRICTS; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN   COX TO CREATE NEIGHBORHOOD DISTRICTS; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN   COX TO CREATE NEIGHBORHOOD DISTRICTS; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN   COX TO CREATE NEIGHBORHOOD DISTRICTS; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN   COX TO CREATE NEIGHBORHOOD DISTRICTS; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN   COX TO CREATE NEIGHBORHOOD DISTRICTS; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN   COX TO CREATE NEIGHBORHOOD DISTRICTS; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN   COX TO CREATE NEIGHBORHOOD DISTRICTS; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN   COX TO CREATE NEIGHBORHOOD DISTRICTS; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN   COX TO CREATE NEIGHBORHOOD DISTRICTS; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN   COX TO CREATE NEIGHBORHOOD DISTRICTS; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN   COX TO CREATE NEIGHBORHOOD DISTRICTS; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN   COX TO CREATE NEIGHBORHOOD DISTRICTS; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN   COX TO CREATE NEIGHBORHOOD DISTRICTS; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN   COX TO CREATE NEIGHBORHOOD DISTRICTS; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN
filer_namf   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
filer_namt   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
filer_nams   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
report_num   000   000   000   000   000   000   000   000   000   000   000   001   001   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000   000
rpt_date   2017-08-01 00:00:00   2017-08-01 00:00:00   2017-02-23 00:00:00   2017-10-31 00:00:00   2017-10-03 00:00:00   2017-11-21 00:00:00   2017-12-06 00:00:00   2018-04-26 00:00:00   2018-04-26 00:00:00   2018-01-31 00:00:00   2018-05-23 00:00:00   2018-04-27 00:00:00   2018-09-26 00:00:00   2018-10-22 00:00:00   2018-07-30 00:00:00   2018-10-23 00:00:00   2018-09-26 00:00:00   2019-04-02 00:00:00   2019-01-31 00:00:00   2019-04-29 00:00:00   2019-10-29 00:00:00   2019-07-26 00:00:00   2019-03-18 00:00:00   2019-10-29 00:00:00   2020-05-18 00:00:00   2020-04-20 00:00:00   2020-04-17 00:00:00   2020-07-23 00:00:00   2020-01-30 00:00:00   2020-09-22 00:00:00   2020-10-20 00:00:00   2021-02-01 00:00:00   2021-04-21 00:00:00   2022-01-31 00:00:00   2021-09-02 00:00:00   2022-04-29 00:00:00   2021-08-04 00:00:00   2021-10-27 00:00:00   2021-06-07 00:00:00   2021-07-27 00:00:00   2022-07-28 00:00:00   2022-10-31 00:00:00
stmt_type   SA   None   None   None   None   QT   None   QT   PE   QT   PE   PE   PE   None   SA   PE   PE   None   SA   QT   None   QT   None   QT   None   QT   None   SA   QT   PE   PE   SA   QT   QT   PE   QT   PE   QT   None   QT   QT   QT
late_rptno   None   2   1   4   3   None   5   None   None   None   None   None   None   6   None   None   None   8   None   None   9   None   7   None   11   None   10   None   None   None   None   None   None   None   None   None   None   None   12   None   None   None
from_date   2017-01-01 00:00:00   None   None   None   None   2017-07-01 00:00:00   None   2018-01-01 00:00:00   2018-01-01 00:00:00   2017-10-01 00:00:00   2018-04-22 00:00:00   2018-01-01 00:00:00   2018-07-01 00:00:00   None   2018-05-20 00:00:00   2018-09-23 00:00:00   2018-07-01 00:00:00   None   2018-10-21 00:00:00   2019-01-01 00:00:00   None   2019-04-01 00:00:00   None   2019-07-01 00:00:00   None   2020-01-01 00:00:00   None   2020-02-16 00:00:00   2019-10-01 00:00:00   2020-07-01 00:00:00   2020-09-20 00:00:00   2020-10-18 00:00:00   2021-01-01 00:00:00   2021-10-01 00:00:00   2021-08-01 00:00:00   2022-01-01 00:00:00   2021-07-01 00:00:00   2021-08-29 00:00:00   None   2021-04-01 00:00:00   2022-04-01 00:00:00   2022-07-01 00:00:00
thru_date   2017-06-30 00:00:00   None   None   None   None   2017-09-30 00:00:00   None   2018-03-31 00:00:00   2018-04-21 00:00:00   2017-12-31 00:00:00   2018-05-19 00:00:00   2018-04-21 00:00:00   2018-09-22 00:00:00   None   2018-06-30 00:00:00   2018-10-20 00:00:00   2018-09-22 00:00:00   None   2018-12-31 00:00:00   2019-03-31 00:00:00   None   2019-06-30 00:00:00   None   2019-09-30 00:00:00   None   2020-03-31 00:00:00   None   2020-06-30 00:00:00   2019-12-31 00:00:00   2020-09-19 00:00:00   2020-10-17 00:00:00   2020-12-31 00:00:00   2021-03-31 00:00:00   2021-12-31 00:00:00   2021-08-28 00:00:00   2022-03-31 00:00:00   2021-07-31 00:00:00   2021-09-30 00:00:00   None   2021-06-30 00:00:00   2022-06-30 00:00:00   2022-09-30 00:00:00
elect_date   None   None   None   None   None   None   None   None   None   None   2018-06-05 00:00:00   2018-06-05 00:00:00   2018-11-06 00:00:00   None   2018-06-05 00:00:00   2018-11-06 00:00:00   2018-11-06 00:00:00   None   None   None   None   None   None   None   None   None   None   None   None   2020-11-03 00:00:00   2020-11-03 00:00:00   2020-11-03 00:00:00   None   None   2021-09-14 00:00:00   None   2021-09-14 00:00:00   None   None   None   None   None
filer_city   SAN DIEGO   SAN DIEGO   SAN DIEGO   SAN DIEGO   SAN DIEGO   SAN DIEGO   SAN DIEGO   SAN DIEGO   SAN DIEGO   SAN DIEGO   SAN DIEGO   SAN DIEGO   SAN DIEGO   SAN DIEGO   SAN DIEGO   SAN DIEGO   SAN DIEGO   SAN DIEGO   SAN DIEGO   SAN DIEGO   SAN DIEGO   SAN DIEGO   SAN DIEGO   SAN DIEGO   SAN DIEGO   SAN DIEGO   SAN DIEGO   SAN DIEGO   SAN DIEGO   SAN DIEGO   SAN DIEGO   SAN DIEGO   SAN DIEGO   SAN DIEGO   SAN DIEGO   SAN DIEGO   SAN DIEGO   SAN DIEGO   SAN DIEGO   SAN DIEGO   SAN DIEGO   SAN DIEGO
filer_st   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA
filer_zip4   92130   92130   92130   92130   92130   92130   92130   92130   92130   92130   92130   92130   92130   92130   92130   92130   92130   92130   92130   92130   92130   92130   92130   92130   92130   92130   92130   92130   92130   92130   92130   92130   92130   92130   92130   92130   92130   92130   92130   92130   92130   92130
filer_phon   8588328134   8588328134   8588328134   8588328134   8588328134   8588328134   8588328134   8588328134   8588328134   8588328134   8588328134   8588328134   8588328134   8588328134   8588328134   8588328134   8588328134   8588328134   8588328134   8588328134   8588328134   8588328134   8588328134   8588328134   8588328134   8588328134   8588328134   8588328134   8588328134   8588328134   8588328134   8588328134   8588328134   8588328134   8588328134   8588328134   8588328134   8588328134   8588328134   8588328134   8588328134   8588328134
filer_fax   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
file_email   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]
mail_city   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
mail_st   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
mail_zip4   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
tres_naml   RYAN   None   None   None   None   RYAN   None   RYAN   RYAN   RYAN   RYAN   RYAN   RYAN   None   RYAN   RYAN   RYAN   None   RYAN   RYAN   None   RYAN   None   RYAN   None   RYAN   None   RYAN   RYAN   RYAN   RYAN   RYAN   RYAN   RYAN   RYAN   RYAN   RYAN   RYAN   None   RYAN   RYAN   RYAN
tres_namf   MCLAYN   None   None   None   None   MCLAYN   None   MCLAYN   MCLAYN   MCLAYN   MCLAYN   MCLAYN   MCLAYN   None   MCLAYN   MCLAYN   MCLAYN   None   MCLAYN   MCLAYN   None   MCLAYN   None   MCLAYN   None   MCLAYN   None   MCLAYN   MCLAYN   MCLAYN   MCLAYN   MCLAYN   MCLAYN   MCLAYN   MCLAYN   MCLAY   MCLAYN   MCLAYN   None   MCLAYN   MCLAYN   MCLAYN
tres_namt   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
tres_nams   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
tres_city   SAN MARCOS   None   None   None   None   SAN MARCOS   None   SAN MARCOS   SAN MARCOS   SAN MARCOS   SAN MARCOS   SAN MARCOS   SAN MARCOS   None   SAN MARCOS   SAN MARCOS   SAN MARCOS   None   SAN MARCOS   SAN MARCOS   None   SAN MARCOS   None   SAN MARCOS   None   SAN DIEGO   None   SAN DIEGO   SAN MARCOS   SAN DIEGO   SAN MARCOS   SAN MARCOS   SAN MARCOS   SAN MARCOS   SAN MARCOS   SAN MARCOS   SAN MARCOS   SAN MARCOS   None   SAN MARCOS   SAN MARCOS   SAN MARCOS
tres_st   CA   None   None   None   None   CA   None   CA   CA   CA   CA   CA   CA   None   CA   CA   CA   None   CA   CA   None   CA   None   CA   None   CA   None   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   CA   None   CA   CA   CA
tres_zip4   92078   None   None   None   None   92078   None   92078   92078   92078   92078   92078   92078   None   92078   92078   92078   None   92078   92078   None   92078   None   92078   None   92078   None   92078   92078   92078   92078   92078   92078   92078   92078   92078   92078   92078   None   92078   92078   92078
tres_phon   6029895819   None   None   None   None   6029895819   None   6029895819   6029895819   6029895819   6029895819   6029895819   6029895819   None   6029895819   6029895819   6029895819   None   6029895819   6029895819   None   6029895819   None   6029895819   None   6029895819   None   6029895819   6029895819   6029895819   6029895819   6029895819   6029895819   6029895819   6029895819   6029895819   6029895819   6029895819   None   6029895819   6029895819   6029895819
tres_fax   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
tres_email   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
cmtte_type   G   None   None   None   None   B   None   B   B   B   B   B   B   None   B   B   B   None   B   B   None   B   None   B   None   B   None   B   B   B   B   B   B   B   B   B   B   B   None   B   B   B
control_yn   N   None   None   None   None   N   None   N   N   N   N   N   N   None   N   N   N   None   N   N   None   N   None   N   None   N   None   N   N   N   N   N   N   N   N   N   N   N   None   N   N   N
sponsor_yn   N   None   None   None   None   Y   None   Y   N   Y   Y   N   Y   None   Y   Y   Y   None   Y   Y   None   Y   None   Y   None   Y   None   Y   Y   Y   Y   Y   Y   Y   Y   Y   Y   Y   None   Y   Y   Y
primfrm_yn   N   None   None   None   None   N   None   N   N   N   N   N   N   None   N   N   N   None   N   N   None   N   None   N   None   N   None   N   N   N   N   N   N   N   N   N   N   N   None   N   N   N
brdbase_yn   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
amendexp_1   None   None   None   None   None   None   None   None   None   None   None   TO INCLUDE DATE OF ELECTION   To include information on Schedule B   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
amendexp_2   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
amendexp_3   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
rpt_att_cb   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
cmtte_id   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
reportname   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
rptfromdt   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
rptthrudt   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
emplbus_cb   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
bus_name   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
bus_city   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
bus_st   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
bus_zip4   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
bus_inter   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
busact_cb   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
busactvity   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
assoc_cb   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
assoc_int   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
other_cb   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
other_int   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
cand_naml   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
cand_namf   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
cand_namt   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
cand_nams   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
cand_city   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
cand_st   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
cand_zip4   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
cand_phon   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
cand_fax   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
cand_email   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
bal_name   None   None   None   None   None   THE NEIGHBORHOOD LEGISLAT. REFORM ACT 13-0028   None   THE NEIGHBORHOOD LEGISLAT. REFORM ACT 13-0028   THE NEIGHBORHOOD LEGISLAT. REFORM ACT 13-0028   THE NEIGHBORHOOD LEGISLAT. REFORM ACT 13-0028   THE NEIGHBORHOOD LEGISLAT. REFORM ACT 13-0028   THE NEIGHBORHOOD LEGISLAT. REFORM ACT 13-0028   THE NEIGHBORHOOD LEGISLAT. REFORM ACT 13-0028   None   THE NEIGHBORHOOD LEGISLAT. REFORM ACT 13-0028   THE NEIGHBORHOOD LEGISLAT. REFORM ACT 13-0028   THE NEIGHBORHOOD LEGISLAT. REFORM ACT 13-0028   None   THE NEIGHBORHOOD LEGISLAT. REFORM ACT 13-0028   THE NEIGHBORHOOD LEGISLAT. REFORM ACT 13-0028   None   THE NEIGHBORHOOD LEGISLAT. REFORM ACT 13-0028   None   THE NEIGHBORHOOD LEGISLAT. REFORM ACT 13-0028   None   THE NEIGHBORHOOD LEGISLAT. REFORM ACT 13-0028   None   THE NEIGHBORHOOD LEGISLAT. REFORM ACT 13-0028   THE NEIGHBORHOOD LEGISLAT. REFORM ACT 13-0028   THE NEIGHBORHOOD LEGISLAT. REFORM ACT 13-0028   THE NEIGHBORHOOD LEGISLAT. REFORM ACT 13-0028   THE NEIGHBORHOOD LEGISLAT. REFORM ACT 13-0028   THE NEIGHBORHOOD LEGISLAT. REFORM ACT 13-0028   THE NEIGHBORHOOD LEGISLAT. REFORM ACT 13-0028   THE NEIGHBORHOOD LEGISLAT. REFORM ACT 13-0028   THE NEIGHBORHOOD LEGISLAT. REFORM ACT 13-0028   THE NEIGHBORHOOD LEGISLAT. REFORM ACT 13-0028   THE NEIGHBORHOOD LEGISLAT. REFORM ACT 13-0028   None   THE NEIGHBORHOOD LEGISLAT. REFORM ACT 13-0028   THE NEIGHBORHOOD LEGISLAT. REFORM ACT 13-0028   THE NEIGHBORHOOD LEGISLAT. REFORM ACT 13-0028
bal_num   None   None   None   None   None   N/A   None   N/A   N/A   N/A   N/A   N/A   N/A   None   N/A   N/A   N/A   None   N/A   N/A   None   N/A   None   N/A   None   N/A   None   N/A   N/A   N/A   N/A   N/A   N/A   N/A   N/A   N/A   N/A   N/A   None   N/A   N/A   N/A
bal_juris   None   None   None   None   None   Statewide   None   Statewide   Statewide   Statewide   Statewide   Statewide   Statewide   None   Statewide   Statewide   Statewide   None   Statewide   Statewide   None   Statewide   None   Statewide   None   Statewide   None   Statewide   Statewide   Statewide   Statewide   Statewide   Statewide   Statewide   Statewide   Statewide   Statewide   Statewide   None   Statewide   Statewide   Statewide
office_cd   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
offic_dscr   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
juris_cd   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
juris_dscr   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
dist_no   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
off_s_h_cd   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
sup_opp_cd   None   None   None   None   None   S   None   S   S   S   S   S   S   None   S   S   S   None   S   S   None   S   None   S   None   S   None   S   S   S   S   S   S   S   S   S   S   S   None   S   S   S
employer   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
occupation   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
selfemp_cb   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
bal_id   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
cand_id   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None   None
Table: filer_address
filer_id   1394684
adrid   2427925
effect_dt   2017-02-23 00:00:00
add_type   7051
session_id   2017
Table: filer_filings
filer_id   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684
filing_id   2282221   2243903   2421613   2255775   2186299   2196891   2467717   2193775   2237436   2378829   2310675   2405540   2195983   2197795   2310041   2519159   2141150   2140647   2177629   2177680   2180089   2211039   2416880   2367751   2296049   2237012   2362307   2216084   2466328   2196774   2494381   2300167   2300167   2393613   2252527   2448327   2369757   2296049   2272657   2480410   2347124   2416844   2473107   2237436   2382443   2324085   2324088   2552734   2440714   2514232   2466061   2503500   2575701   2604639   2531223   2561106   2626115   2696396   2630053   2702944   2627657   2577447   2597203   2617150   2645834   2610176   2620585   2586998   2625845   2674505   2649334   2747611   2736678
period_id   None   None   None   None   232   None   None   232   233   237   235   None   None   232   236   243   229   None   229   231   None   232   239   237   235   233   None   None   241   231   None   None   None   238   234   None   238   235   234   241   236   240   242   233   None   None   None   244   240   None   242   243   245   247   None   None   None   None   None   250   None   None   246   None   248   247   247   246   None   249   None   251   None
form_id   F460   F460   F460   F460   F497   F460   F460   F497   F460   F460   F460   F460   F410   F497   F497   F460   F497   F410   F460   F497   F460   F460   F460   F497   F460   F460   F460   F460   F460   F460   F460   F460   F460   F460   F460   F460   F497   F460   F460   F460   F460   F497   F497   F460   F460   E530   F460   F460   F460   F460   F497   F460   F460   F460   F460   F460   F460   F460   F666   F460   F460   F460   F460   F460   F460   F460   F460   F497   F460   F460   F460   F460   F460
filing_sequence   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   1   0   0   0   0   1   0   0   0   0   0   1   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0
filing_date   2018-07-31 00:00:00   2018-04-26 00:00:00   2019-10-30 00:00:00   2018-05-24 00:00:00   2017-10-03 00:00:00   2017-11-21 00:00:00   2020-04-21 00:00:00   2017-10-31 00:00:00   2018-04-26 00:00:00   2019-04-29 00:00:00   2018-10-23 00:00:00   2019-07-31 00:00:00   2017-11-08 00:00:00   2017-12-06 00:00:00   2018-10-22 00:00:00   2020-10-20 00:00:00   2017-02-23 00:00:00   2017-02-23 00:00:00   2017-08-01 00:00:00   2017-08-01 00:00:00   2017-08-01 00:00:00   2018-01-31 00:00:00   2019-10-29 00:00:00   2019-03-18 00:00:00   2018-09-26 00:00:00   2018-04-26 00:00:00   2019-01-31 00:00:00   2018-01-31 00:00:00   2020-04-20 00:00:00   2017-11-21 00:00:00   2020-07-31 00:00:00   2018-09-27 00:00:00   2018-09-27 00:00:00   2019-07-26 00:00:00   2018-05-23 00:00:00   2020-01-31 00:00:00   2019-04-02 00:00:00   2018-09-26 00:00:00   2018-07-30 00:00:00   2020-07-23 00:00:00   2019-01-31 00:00:00   2019-10-29 00:00:00   2020-05-18 00:00:00   2018-04-27 00:00:00   2019-04-30 00:00:00   2018-10-24 00:00:00   2018-10-24 00:00:00   2021-02-01 00:00:00   2020-01-30 00:00:00   2020-09-23 00:00:00   2020-04-17 00:00:00   2020-09-22 00:00:00   2021-04-21 00:00:00   2021-08-04 00:00:00   2020-10-23 00:00:00   2021-02-01 00:00:00   2021-09-02 00:00:00   2022-05-03 00:00:00   2021-11-30 00:00:00   2022-07-28 00:00:00   2021-10-27 00:00:00   2021-04-22 00:00:00   2021-07-27 00:00:00   2021-07-30 00:00:00   2022-01-31 00:00:00   2021-09-02 00:00:00   2021-10-27 00:00:00   2021-06-07 00:00:00   2021-08-06 00:00:00   2022-04-29 00:00:00   2022-02-07 00:00:00   2022-10-31 00:00:00   2022-08-02 00:00:00
stmnt_type   10005   10005   10005   10005   10001   10005   10005   10001   10001   10001   10001   10005   10006   10001   10001   10001   10001   10005   10001   10001   10005   10001   10001   10001   10001   10001   10005   10005   10001   10001   10005   10005   10002   10001   10001   10005   10001   10002   10001   10001   10001   10001   10001   10002   10005   10005   10005   10001   10001   10005   10001   10001   10001   10001   10005   10005   10005   10005   10005   10001   10005   10005   10001   10005   10001   10001   10001   10001   10005   10001   10005   10001   10005
stmnt_status   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11003   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11003   11003   11001   11001   11001   11001   11001   11003   11001   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11003   11001   11001   11001   11001   11003   11001   11001   11003   11001   11001   11003   11003   11003
session_id   2017   2017   2019   2017   2017   2017   2019   2017   2017   2019   2017   2019   2017   2017   2017   2019   2017   2017   2017   2017   2017   2017   2019   2019   2017   2017   2017   2017   2019   2017   2019   2017   2017   2019   2017   2019   2019   2017   2017   2019   2017   2019   2019   2017   2019   2017   2017   2019   2019   2019   2019   2019   2021   2021   2019   2021   2021   2021   2017   2021   2021   2021   2021   2021   2021   2021   2021   2021   2021   2021   2021   2021   2021
user_id   HSTOVALL   HSTOVALL   HCOURSEY   RPOOJA   PBANFORD   CSAGABAEN   LFEDOROV   RGEREMIA   HSTOVALL   YMORA   LBARTHOL   CSAGABAEN   TRAMON   PBANFORD   CAFILER   KRUSSELL   RGEREMIA   CPON   LBARTHOL   PBANFORD   LBARTHOL   BSINGH   HCOURSEY   RGEREMIA   BSINGH   CAFILER   YMORA   BSINGH   LFEDOROV   CSAGABAEN   SARRIAGA   BSINGH   MXIONG   CSAGABAEN   RPOOJA   VUKSTINA   CAFILER   CAFILER   HSTOVALL   SARRIAGA   YMORA   RGEREMIA   RGEREMIA   CAFILER   YMORA   HSTOVALL   LBARTHOL   SUSHAKOV   VUKSTINA   IMEDINA   RGEREMIA   IMEDINA   IMEDINA   KRUSSELL   KRUSSELL   SUSHAKOV   KRUSSELL   SARRIAGA   AROBERTS   CAFILER   IMEDINA   IMEDINA   DCODY   DCODY   LPHEAV   KRUSSELL   IMEDINA   CAFILER   KRUSSELL   SARRIAGA   LPHEAV   CAFILER   HCOURSEY
special_audit   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003
fine_audit   11003   11003   11003   11003   11001   11001   11003   11001   11003   11003   11003   11003   11003   11001   11003   11003   11001   11003   11001   11001   11001   11003   11003   11001   11003   11003   11003   11003   11003   11001   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11001   11001   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11001   11003   11003   11001   11003   11003   11003   11001   11003   11001   11003   11003   11001   11001   11003   11003
rpt_start   2018-05-20 00:00:00   2018-01-01 00:00:00   2019-07-01 00:00:00   2018-04-22 00:00:00   2017-10-03 00:00:00   2017-07-01 00:00:00   2020-01-01 00:00:00   2017-10-31 00:00:00   2018-01-01 00:00:00   2019-01-01 00:00:00   2018-09-23 00:00:00   2019-04-01 00:00:00   None   2017-12-06 00:00:00   2018-10-22 00:00:00   2020-09-20 00:00:00   2017-02-23 00:00:00   None   2017-01-01 00:00:00   2017-08-01 00:00:00   2017-01-01 00:00:00   2017-10-01 00:00:00   2019-07-01 00:00:00   2019-03-18 00:00:00   2018-07-01 00:00:00   2018-01-01 00:00:00   2018-10-21 00:00:00   2017-10-01 00:00:00   2020-01-01 00:00:00   2017-07-01 00:00:00   2020-02-16 00:00:00   2018-07-01 00:00:00   2018-07-01 00:00:00   2019-04-01 00:00:00   2018-04-22 00:00:00   2019-10-01 00:00:00   2019-04-02 00:00:00   2018-07-01 00:00:00   2018-05-20 00:00:00   2020-02-16 00:00:00   2018-10-21 00:00:00   2019-10-29 00:00:00   2020-05-18 00:00:00   2018-01-01 00:00:00   2019-01-01 00:00:00   2018-09-23 00:00:00   2018-09-23 00:00:00   2020-10-18 00:00:00   2019-10-01 00:00:00   2020-07-01 00:00:00   2020-04-17 00:00:00   2020-07-01 00:00:00   2021-01-01 00:00:00   2021-07-01 00:00:00   2020-09-20 00:00:00   2020-10-18 00:00:00   2021-08-01 00:00:00   2022-01-01 00:00:00   2017-01-01 00:00:00   2022-04-01 00:00:00   2021-08-29 00:00:00   2021-01-01 00:00:00   2021-04-01 00:00:00   2021-04-01 00:00:00   2021-10-01 00:00:00   2021-08-01 00:00:00   2021-08-29 00:00:00   2021-06-07 00:00:00   2021-07-01 00:00:00   2022-01-01 00:00:00   2021-10-01 00:00:00   2022-07-01 00:00:00   2022-04-01 00:00:00
rpt_end   2018-06-30 00:00:00   2018-04-21 00:00:00   2019-09-30 00:00:00   2018-05-19 00:00:00   2017-10-03 00:00:00   2017-09-30 00:00:00   2020-03-31 00:00:00   2017-10-31 00:00:00   2018-04-21 00:00:00   2019-03-31 00:00:00   2018-10-20 00:00:00   2019-06-30 00:00:00   None   2017-12-06 00:00:00   2018-10-22 00:00:00   2020-10-17 00:00:00   2017-02-23 00:00:00   None   2017-06-30 00:00:00   2017-08-01 00:00:00   2017-06-30 00:00:00   2017-12-31 00:00:00   2019-09-30 00:00:00   2019-03-18 00:00:00   2018-09-22 00:00:00   2018-03-31 00:00:00   2018-12-31 00:00:00   2017-12-31 00:00:00   2020-03-31 00:00:00   2017-09-30 00:00:00   2020-06-30 00:00:00   2018-09-22 00:00:00   2018-09-22 00:00:00   2019-06-30 00:00:00   2018-05-19 00:00:00   2019-12-31 00:00:00   2019-04-02 00:00:00   2018-09-22 00:00:00   2018-06-30 00:00:00   2020-06-30 00:00:00   2018-12-31 00:00:00   2019-10-29 00:00:00   2020-05-18 00:00:00   2018-04-21 00:00:00   2019-03-31 00:00:00   2018-10-20 00:00:00   2018-10-20 00:00:00   2020-12-31 00:00:00   2019-12-31 00:00:00   2020-09-19 00:00:00   2020-04-17 00:00:00   2020-09-19 00:00:00   2021-03-31 00:00:00   2021-07-31 00:00:00   2020-10-17 00:00:00   2020-12-31 00:00:00   2021-08-28 00:00:00   2022-03-31 00:00:00   2018-12-31 00:00:00   2022-06-30 00:00:00   2021-09-30 00:00:00   2021-03-31 00:00:00   2021-06-30 00:00:00   2021-06-30 00:00:00   2021-12-31 00:00:00   2021-08-28 00:00:00   2021-09-30 00:00:00   2021-06-07 00:00:00   2021-07-31 00:00:00   2022-03-31 00:00:00   2021-12-31 00:00:00   2022-09-30 00:00:00   2022-06-30 00:00:00
rpt_date   None   None   None   None   2017-10-03 00:00:00   None   None   2017-10-31 00:00:00   2018-04-26 00:00:00   2019-04-29 00:00:00   2018-10-23 00:00:00   None   None   2017-12-06 00:00:00   2018-10-22 00:00:00   2020-10-20 00:00:00   2017-02-23 00:00:00   None   2017-08-01 00:00:00   2017-08-01 00:00:00   None   2018-01-31 00:00:00   2019-10-29 00:00:00   2019-03-18 00:00:00   2018-09-26 00:00:00   2018-04-26 00:00:00   None   None   2020-04-20 00:00:00   2017-11-21 00:00:00   None   None   None   2019-07-26 00:00:00   2018-05-23 00:00:00   None   2019-04-02 00:00:00   2018-09-26 00:00:00   2018-07-30 00:00:00   2020-07-23 00:00:00   2019-01-31 00:00:00   2019-10-29 00:00:00   2020-05-18 00:00:00   2018-04-27 00:00:00   None   None   None   2021-02-01 00:00:00   2020-01-30 00:00:00   None   2020-04-17 00:00:00   2020-09-22 00:00:00   2021-04-21 00:00:00   2021-08-04 00:00:00   None   None   None   None   None   2022-07-28 00:00:00   None   None   2021-07-27 00:00:00   None   2022-01-31 00:00:00   2021-09-02 00:00:00   2021-10-27 00:00:00   2021-06-07 00:00:00   None   2022-04-29 00:00:00   None   2022-10-31 00:00:00   None
filing_type   None   None   None   None   22006   None   None   22006   22006   22006   22006   None   None   22006   22006   22006   22006   None   22006   22006   None   22006   22006   22006   22006   22006   None   None   22006   22006   None   None   None   22006   22006   None   22006   22006   22006   22006   22006   22006   22006   22006   None   None   None   22006   22006   None   22006   22006   22006   22006   None   None   None   None   None   22006   None   None   22006   None   22006   22006   22006   22006   None   22006   None   22006   None
Table: filer_to_filer_type
filer_id   1394684   1394684
filer_type   16   16
active   Y   Y
race   0   0
session_id   2017   2017
category   40002   40002
category_type   40502   40502
sub_category   40105   40101
effect_dt   2017-02-23 00:00:00   2017-11-08 00:00:00
sub_category_type   0   0
election_type   0   0
sub_category_a   None   None
nyq_dt   2017-02-07 00:00:00   2017-02-07 00:00:00
party_cd   16002   16002
county_cd   18042   18042
district_cd   0   0
Table: filer_xref
filer_id   1394684
xref_id   1394684
effect_dt   2017-02-22 00:00:00
migration_source   CLAIMS
Table: filername
xref_filer_id   1394684   1394684
filer_id   1394684   1394684
filer_type   RECIPIENT COMMITTEE   RECIPIENT COMMITTEE
status   ACTIVE   ACTIVE
effect_dt   2017-11-08 00:00:00   2017-11-08 00:00:00
naml   COX; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN   COX TO CREATE NEIGHBORHOOD DISTRICTS; NEIGHBORHOOD LEGISLATURE, A BALLOT MEASURE COMMITTEE CONTROLLED BY JOHN
namf   None   None
namt   None   None
nams   None   None
adr1   None   None
adr2   None   None
city   SAN DIEGO   SAN DIEGO
st   CA   CA
zip4   92130   92130
phon   8588328134   8588328134
fax   None   None
email   [email protected]   [email protected]
Table: filers
filer_id   1394684
Table: received_filings
filer_id   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684   1394684
filing_file_name   2141150_0.cal   2177680_0.cal   2186299_0.cal   2193775_0.cal   2197795_0.cal   2466061_0.cal   2310041_0.cal   2416844_0.cal   2367751_0.cal   2369757_0.cal   2473107_0.cal   2586998_0.cal
received_date   2017-02-23 00:00:00   2017-08-01 00:00:00   2017-10-03 00:00:00   2017-10-31 00:00:00   2017-12-06 00:00:00   2020-04-17 00:00:00   2018-10-22 00:00:00   2019-10-29 00:00:00   2019-03-18 00:00:00   2019-04-02 00:00:00   2020-05-18 00:00:00   2021-06-07 00:00:00
filing_directory   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal
filing_id   2141150   2177680   2186299   2193775   2197795   2466061   2310041   2416844   2367751   2369757   2473107   2586998
form_id   F497   F497   F497   F497   F497   F497   F497   F497   F497   F497   F497   F497
receive_comment   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted