Home

Filer ID: 1407824

Table: cvr_campaign_disclosure

filing_id		2295944		2287805		2297186		2294325		2310809		2309677		2309678		2309680		2311628		2312938		2310788		2304181		2307060		2309673		2309681		2308850		2292117		2294029		2292117		2307057		2298333		2314592		2312515		2293170		2300041		2301981		2301982		2304188		2306312		2306313		2292117		2292118		2311612		2308854		2308856		2309678		2297186		2308844		2324285		2324286		2324287		2317440		2321929		2321160		2321172		2324276		2324271		2324272		2321157		2324276		2317437		2321157		2317437		2324287		2324286		2324285		2322033		2324276		2317513		2317488		2321172		2322015		2321157		2322013		2310809		2324272		2317440		2321929		2391297		2317488		2321949		2321950		2312938		2347873		2317513		2324271		2493642		2437088		2479766		2511976		2505286		2520463		2515488		2515702		2512770		2520463		2525610		2508870		2545300		2512770		2536688		2505286		2511976		2637853		2597688		2672220		2688362		2688363		2690373		2691132		2679915		2679917		2684708		2701332		2686118		2688829		2683952		2684352		2689838		2744255
amend_id		0		0		1		0		0		0		1		0		0		0		0		0		0		0		0		0		1		0		2		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		2		0		0		1		1		1		2		0		1		1		1		0		0		0		1		0		0		0		0		1		1		1		1		0		0		0		0		1		0		1		1		0		0		0		0		0		0		0		0		1		1		0		0		0		0		0		1		1		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		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		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		F497		F497		F460		F496		F496		F496		F496		F496		F497		F460		F497		F497		F496		F497		F496		F497		F497		F496		F497		F497		F497		F497		F497		F497		F497		F496		F496		F496		F496		F496		F497		F496		F496		F496		F496		F496		F460		F497		F496		F496		F496		F496		F496		F497		F496		F497		F496		F496		F497		F497		F497		F497		F497		F496		F496		F496		F496		F497		F496		F497		F496		F497		F497		F496		F496		F496		F496		F496		F460		F497		F496		F496		F460		F460		F496		F496		F496		F460		F460		F496		F460		F460		F496		F497		F497		F460		F496		F496		F460		F497		F497		F460		F496		F460		F460		F460		F496		F496		F496		F496		F496		F496		F496		F460		F460		F496		F496		F496		F496		F460
filer_id		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824
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		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		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		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government		Business Leaders for Ethical Government
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		001		000		000		000		001		000		000		000		000		000		000		000		000		000		001		000		002		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		001		002		000		000		001		001		001		002		000		001		001		001		000		000		000		001		000		000		000		000		001		001		001		001		000		000		000		000		001		000		001		001		000		000		000		000		000		000		000		000		001		001		000		000		000		000		000		001		001		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000
rpt_date		2018-09-26 00:00:00		2018-08-30 00:00:00		2018-10-02 00:00:00		2018-09-21 00:00:00		2018-10-23 00:00:00		2018-10-21 00:00:00		2018-10-21 00:00:00		2018-10-21 00:00:00		2018-10-24 00:00:00		2018-10-25 00:00:00		2018-10-23 00:00:00		2018-10-09 00:00:00		2018-10-16 00:00:00		2018-10-21 00:00:00		2018-10-21 00:00:00		2018-10-18 00:00:00		2018-09-19 00:00:00		2018-09-20 00:00:00		2018-10-02 00:00:00		2018-10-16 00:00:00		2018-09-28 00:00:00		2018-10-26 00:00:00		2018-10-25 00:00:00		2018-09-18 00:00:00		2018-10-02 00:00:00		2018-10-04 00:00:00		2018-10-04 00:00:00		2018-10-09 00:00:00		2018-10-12 00:00:00		2018-10-12 00:00:00		2018-09-14 00:00:00		2018-09-14 00:00:00		2018-10-24 00:00:00		2018-10-18 00:00:00		2018-10-18 00:00:00		2018-10-21 00:00:00		2018-09-27 00:00:00		2018-10-18 00:00:00		2018-11-05 00:00:00		2018-11-05 00:00:00		2018-11-05 00:00:00		2018-10-30 00:00:00		2018-11-01 00:00:00		2018-10-31 00:00:00		2018-12-06 00:00:00		2019-01-09 00:00:00		2018-11-05 00:00:00		2018-11-05 00:00:00		2018-12-05 00:00:00		2018-12-05 00:00:00		2018-12-05 00:00:00		2019-01-09 00:00:00		2018-10-30 00:00:00		2018-12-06 00:00:00		2018-12-06 00:00:00		2018-12-06 00:00:00		2018-11-01 00:00:00		2018-11-05 00:00:00		2018-10-30 00:00:00		2019-01-09 00:00:00		2018-10-31 00:00:00		2018-11-01 00:00:00		2018-10-31 00:00:00		2018-11-01 00:00:00		2019-01-09 00:00:00		2019-01-09 00:00:00		2018-12-06 00:00:00		2018-12-06 00:00:00		2019-07-17 00:00:00		2018-10-30 00:00:00		2018-11-01 00:00:00		2018-11-01 00:00:00		2019-01-04 00:00:00		2019-01-30 00:00:00		2018-12-06 00:00:00		2018-12-06 00:00:00		2020-08-21 00:00:00		2020-01-28 00:00:00		2020-07-21 00:00:00		2020-10-08 00:00:00		2020-09-23 00:00:00		2020-10-22 00:00:00		2020-10-14 00:00:00		2020-10-14 00:00:00		2020-12-08 00:00:00		2020-12-11 00:00:00		2020-10-28 00:00:00		2020-10-02 00:00:00		2021-01-19 00:00:00		2020-10-09 00:00:00		2020-12-11 00:00:00		2020-12-11 00:00:00		2020-10-09 00:00:00		2022-01-25 00:00:00		2021-07-10 00:00:00		2022-04-25 00:00:00		2022-05-29 00:00:00		2022-05-29 00:00:00		2022-06-02 00:00:00		2022-06-03 00:00:00		2022-05-06 00:00:00		2022-05-06 00:00:00		2022-05-20 00:00:00		2022-07-26 00:00:00		2022-05-25 00:00:00		2022-05-31 00:00:00		2022-05-18 00:00:00		2022-05-19 00:00:00		2022-06-01 00:00:00		2022-10-27 00:00:00
stmt_type		None		None		PE		None		None		None		None		None		None		PE		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		PE		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		SA		None		None		None		PE		SA		None		None		None		SA		SA		None		PE		PE		None		None		None		PE		None		None		SA		None		None		PE		None		SA		SA		PE		None		None		None		None		None		None		None		SA		PE		None		None		None		None		PE
late_rptno		092618		083018-MS		None		092118		102318-GF		102018-BH		102018-GF		102018-RF		102418		None		102318		100918		101618-BH		102118		102018-LN		101818-1		091418		092018-SC		091418		101618		092818		102618		102518		091818		100218		100418-RF		100418-YW		100918-GF		101218-BH		101218-PL		091418		091418-RF		102418-SC		101818-BH		101818-GF		102018-GF		None		101818		110518-P		110518-O		110518-N		103018-GF		110118-RF		103118-JB		103118-LN		110518		110518-YW		110518-RF		103118		110518		103018		103118		103018		110518-N		110518-O		110518-P		110118-TS		110518		103018-BH		103018-MS		103118-LN		110118		103118		110118-SC		102318-GF		110518-RF		103018-GF		110118-RF		None		103018-MS		110118-DC		110118-PC		None		None		103018-BH		110518-YW		08212020-K		None		None		100820-SH		None		None		101320-JH		10142020		10092020		None		102820-GF		100220-GF		None		10092020		09182020		None		100820-SH		None		None		None		052922-CH		052922-JA		060222-JA		060322-CH		050622-EC		050622-NR		052022-LC		None		None		053122-JV		051822-LC		051922-JA		060122-CH		None
from_date		None		None		2018-07-01 00:00:00		None		None		None		None		None		None		2018-09-23 00:00:00		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2018-01-01 00:00:00		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2019-01-01 00:00:00		None		None		None		2018-09-23 00:00:00		2018-10-21 00:00:00		None		None		None		2019-07-01 00:00:00		2020-01-01 00:00:00		None		2020-07-01 00:00:00		2020-09-20 00:00:00		None		None		None		2020-09-20 00:00:00		None		None		2020-10-18 00:00:00		None		None		2020-07-01 00:00:00		None		2021-07-01 00:00:00		2021-01-01 00:00:00		2022-01-01 00:00:00		None		None		None		None		None		None		None		2022-05-22 00:00:00		2022-04-24 00:00:00		None		None		None		None		2022-07-01 00:00:00
thru_date		None		None		2018-09-22 00:00:00		None		None		None		None		None		None		2018-10-20 00:00:00		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2018-09-22 00:00:00		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2019-06-30 00:00:00		None		None		None		2018-10-20 00:00:00		2018-12-31 00:00:00		None		None		None		2019-12-31 00:00:00		2020-06-30 00:00:00		None		2020-09-19 00:00:00		2020-10-17 00:00:00		None		None		None		2020-10-17 00:00:00		None		None		2020-12-31 00:00:00		None		None		2020-09-19 00:00:00		None		2021-12-31 00:00:00		2021-06-30 00:00:00		2022-04-23 00:00:00		None		None		None		None		None		None		None		2022-06-30 00:00:00		2022-05-21 00:00:00		None		None		None		None		2022-10-22 00:00:00
elect_date		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2022-06-07 00:00:00		None		None		None		None		None		None		None		None		2022-06-07 00:00:00		None		None		None		None		2022-11-08 00:00:00
filer_city		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas
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		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		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		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024
filer_phon		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		619-708-9744		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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]		[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]		[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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley		Haley
tres_namf		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.		Nancy R.
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas		Encinitas
tres_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		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		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
tres_zip4		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024		92024
tres_phon		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		619-708-9744		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		760-632-3600		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744		619-708-9744
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		G		None		None		None		None		None		None		G		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		G		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		G		None		None		None		G		G		None		None		None		G		G		None		G		G		None		None		None		G		None		None		G		None		None		G		None		G		G		G		None		None		None		None		None		None		None		G		G		None		None		None		None		G
control_yn		None		None		N		None		None		None		None		None		None		N		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		N		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		N		None		None		None		N		N		None		None		None		N		N		None		N		N		None		None		None		N		None		None		N		None		None		N		None		N		N		N		None		None		None		None		None		None		None		N		N		None		None		None		None		N
sponsor_yn		None		None		N		None		None		None		None		None		None		N		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		N		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		N		None		None		None		N		N		None		None		None		N		N		None		N		N		None		None		None		N		None		None		N		None		None		N		None		N		N		N		None		None		None		None		None		None		None		N		N		None		None		None		None		N
primfrm_yn		None		None		N		None		None		None		None		None		None		N		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		N		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		N		None		None		None		N		N		None		None		None		N		N		None		N		N		None		None		None		N		None		None		N		None		None		N		None		N		N		N		None		None		None		None		None		None		None		N		N		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		Amendment to include accrued expenses (OPR Communications) & correct in-kind amounts (Orozco & Weis)		None		None		None		Amendment to correct Sch. A dates.		None		None		None		None		None		None		None		None		None		Amendment to remove Lucio for City Council 2018 - Reported in Error		None		Amendment to correct in-kind amounts.		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Amendment to correct total.		Amendment to correct in-kind totals - Friends of David Happe for City Council 2018 & Brosowske for C		None		None		Amendment to correct in-kind total - Patrick 'Cork' Irwin for City Council 2018.		Amendment to correct in-kind totals - Friends of David Happe for City Council 2018 & Brosowske for C		Amendment to correct in-kind total - Steinorth for City Council 2018.		Amendment to correct in-kind total - Patrick 'Cork' Irwin for City Council 2018.		None		Amendment to correct total.		Amendment to correct total.		Amendment to correct total.		None		None		None		Amendment to correct total.		None		None		None		None		Amendment to correct mailer total.		Amendment to correct voter file total.		Amendment to correct total.		Amendment to correct total.		None		None		None		None		Amendment to include accrued expenses received after deadline. The La Jolla Group - $13,500 & 716.80		None		Amendment to correct total.		Amendment to correct total.		None		None		None		None		None		None		None		None		Correct in-kind total.		Sch. F: 3AM Communications - $2,939.23; Mark & Associates - $3,500 & Sch. D: Correct in-kind contrib		None		None		None		None		None		Sch. F: Mark & Associates - $3,500 & Sch. D: Sign placement for in-kind contribution made.		Independent expenditure reported in error.		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		None		None		ity Council 2018.		None		None		None		ity Council 2018.		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		.		None		None		None		None		None		None		None		None		None		None		None		None		ution total.		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		Sam Crowe		Gino Fillipi		Bill Holland		Gino Fillipi		Ricky Felix		None		None		None		None		Bill Holland		None		Larry Nava		None		None		Sam Crowe		None		None		None		None		None		None		None		Ricky Felix		Yvette Walker		Gino Fillipi		Bill Holland		Paul Leon		None		Ricky Felix		Sam Crowe		Bill Holland		Gino Fillipi		Gino Fillipi		None		None		None		None		None		Gino Fillipi		Ricky Felix		None		Larry Nava		None		Yvette Walker		Ricky Felix		None		None		None		None		None		None		None		None		Tim Shaw		None		Bill Holland		None		Larry Nava		None		None		Sam Crowe		Gino Fillipi		Ricky Felix		Gino Fillipi		Ricky Felix		None		None		Doug Chaffee		Paulette Marshall Chaffee		None		None		Bill Holland		Yvette Walker		None		None		None		Steven D. Hofbauer		None		None		Jon Hamilton		None		None		None		Gino Fillipi		Gino Fillipi		None		None		None		None		Steven D. Hofbauer		None		None		None		Curt Hagman		Jesse Armendarez		Jesse Armendarez		Curt Hagman		Eric Coker		Nadia Renner		Luis Cetina		None		None		John Valdivia		Luis Cetina		Jesse Armendarez		Curt Hagman		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Authorization to Transfer Electric Utility Revenue to General Fund & Utility Fee Rate Increase Restriction		Retail Marijuana Business Tax		Cultivation, Manufacturing, & Testing Marijuana Business Tax		None		None		None		None		None		None		None		None		None		None		None		None		Cultivation, Manufacturing, & Testing Marijuana Business Tax		Retail Marijuana Business Tax		Authorization to Transfer Electric Utility Revenue to General Fund & Utility Fee Rate Increase Restriction		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		The San Bernardino County Supervisor Compensation Reduction & Term Limits Initiative		None		None		None		None		None		None		None		None		None		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_num		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		P		O		N		None		None		None		None		None		None		None		None		None		None		None		None		N		O		P		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		K		None		None		None		None		None		None		None		None		None		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_juris		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		City of Banning		City of Banning		City of Banning		None		None		None		None		None		None		None		None		None		None		None		None		City of Banning		City of Banning		City of Banning		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		County of San Bernardino		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
office_cd		None		None		None		MAY		CCM		CCM		CCM		CCM		None		None		None		None		CCM		None		CCM		None		None		MAY		None		None		None		None		None		None		None		CCM		CCM		CCM		CCM		MAY		None		CCM		MAY		CCM		CCM		CCM		None		None		None		None		None		CCM		CCM		None		CCM		None		CCM		CCM		None		None		None		None		None		None		None		None		CSU		None		CCM		None		CCM		None		None		MAY		CCM		CCM		CCM		CCM		None		None		CSU		CCM		None		None		CCM		CCM		None		None		None		MAY		None		None		CCM		None		None		None		CCM		CCM		None		None		None		None		MAY		None		None		None		CSU		CSU		CSU		CSU		CSU		CSU		CSU		None		None		MAY		CSU		CSU		CSU		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		OTH		OTH		OTH		OTH		OTH		None		None		None		None		OTH		None		OTH		None		None		OTH		None		None		None		None		None		None		None		OTH		OTH		OTH		OTH		OTH		None		OTH		OTH		OTH		OTH		OTH		None		None		None		None		None		OTH		OTH		None		OTH		None		OTH		OTH		None		None		None		None		None		None		None		None		CTY		None		OTH		None		OTH		None		None		OTH		OTH		OTH		OTH		OTH		None		None		OTH		OTH		None		None		OTH		OTH		None		None		None		CIT		None		None		OTH		None		None		None		OTH		OTH		None		None		None		None		CIT		None		None		None		OTH		OTH		OTH		OTH		OTH		OTH		OTH		None		None		OTH		OTH		OTH		OTH		None
juris_dscr		None		None		None		City of Ontario		City of Upland		City of Hesperia		City of Upland		City of Upland		None		None		None		None		City of Hesperia		None		City of Hesperia		None		None		City of Ontario		None		None		None		None		None		None		None		City of Upland		City of Upland		City of Upland		City of Hesperia		City of Ontario		None		City of Upland		City of Ontario		City of Hesperia		City of Upland		City of Upland		None		None		None		None		None		City of Upland		City of Upland		None		City of Hesperia		None		City of Upland		City of Upland		None		None		None		None		None		None		None		None		County of Orange County		None		City of Hesperia		None		City of Hesperia		None		None		City of Ontario		City of Upland		City of Upland		City of Upland		City of Upland		None		None		County of Orange County		City of Fullerton		None		None		City of Hesperia		City of Upland		None		None		None		City of Palmdale		None		None		City of Rancho Cucamonga		None		None		None		City of Upland		City of Upland		None		None		None		None		City of Palmdale		None		None		None		County of San Bernardino		County of San Bernardino		County of San Bernardino		County of San Bernardino		County of San Bernardino		County of San Bernardino		County of San Bernardino		None		None		City of San Bernardino		County of San Bernardino		County of San Bernardino		County of San Bernardino		None
dist_no		None		None		None		None		3		2		3		3		None		None		None		None		2		None		2		None		None		None		None		None		None		None		None		None		None		3		2		3		2		None		None		3		None		2		3		3		None		None		None		None		None		3		3		None		2		None		2		3		None		None		None		None		None		None		None		None		4		None		2		None		2		None		None		None		3		3		3		3		None		None		4		5		None		None		2		2		None		None		None		None		None		None		1		None		None		None		3		3		None		None		None		None		None		None		None		None		4		2		2		4		2		2		2		None		None		None		2		2		4		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		O		O		O		O		S		None		None		None		None		O		None		S		None		None		O		None		None		None		None		None		None		None		S		S		O		O		S		None		S		O		O		O		O		None		None		S		S		S		O		S		None		S		None		S		S		None		None		None		None		None		S		S		S		S		None		O		None		S		None		None		O		O		S		O		S		None		None		O		O		None		None		O		S		O		None		None		S		None		None		O		None		None		None		O		O		None		None		None		None		S		None		None		None		S		S		S		S		O		O		O		None		None		O		O		S		S		None
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		1407824		1407824
adrid		2455698		2481328
effect_dt		2018-07-20 00:00:00		2019-06-07 00:00:00
add_type		7051		7051
session_id		2017		2019

Table: filer_filings

filer_id		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824		1407824
filing_id		2295944		2325721		2287805		2321160		2324271		2324272		2309680		2317437		2520463		2267700		2528716		2307060		2321172		2322015		2325721		2307057		2324272		2311612		2297186		2525610		2300041		2386676		2301981		2301982		2391297		2304188		2308844		2309678		2294325		2321157		2324276		2309681		2310788		2324276		2314592		2324287		2324286		2324285		2395410		2309673		2321157		2292117		2322013		2317440		2321949		2321950		2511976		2505286		2306312		2306313		2308854		2308856		2309678		2317488		2292117		2292118		2361891		2515488		2515702		2310809		2311628		2317440		2321929		2509538		2317437		2322033		2302135		2308850		2310809		2562317		2312938		2280741		2312515		2324276		2536688		2505286		2309677		2324285		2324286		2324287		2297186		2321172		2304181		2321157		2512770		2302135		2317488		2446793		2317513		2292117		2294029		2437088		2512770		2520463		2321929		2312938		2347873		2293170		2488503		2493642		2298333		2317513		2324271		2545300		2604589		2647266		2679915		2679917		2479766		2508870		2676487		2511976		2688829		2597688		2528716		2509538		2637853		2686118		2689838		2672220		2688362		2688363		2684708		2690373		2691132		2716293		2683952		2684352		2687801		2701332		2744255
period_id		235		None		235		236		236		236		236		236		243		None		None		236		236		236		None		236		237		236		233		244		236		None		236		236		237		236		236		236		235		236		236		236		236		236		236		236		236		236		None		236		236		236		236		236		236		236		244		243		236		236		236		236		236		236		235		235		None		244		244		236		236		236		236		None		236		236		None		236		237		None		235		None		236		237		244		243		236		236		236		236		235		236		236		237		244		None		237		None		236		235		235		239		244		243		236		235		236		235		None		243		235		236		236		244		None		None		250		250		241		244		None		244		250		245		None		None		247		250		250		249		250		250		250		250		250		None		250		250		None		250		251
form_id		F497		F460		F497		F497		F496		F496		F496		F497		F460		F410		F460		F496		F496		F497		F460		F497		F496		F496		F460		F496		F497		F410		F496		F496		F460		F496		F497		F496		F496		F497		F497		F496		F497		F497		F497		F496		F496		F496		F460		F497		F497		F497		F496		F496		F496		F496		F496		F460		F496		F496		F496		F496		F496		F497		F497		F496		F460		F496		F497		F496		F497		F496		F496		F460		F497		F496		F460		F497		F496		F460		F460		F410		F497		F497		F497		F460		F496		F496		F496		F496		F460		F496		F497		F497		F497		F460		F497		F460		F496		F497		F496		F460		F497		F460		F496		F460		F460		F497		F460		F496		F497		F496		F496		F460		F460		F460		F496		F496		F460		F496		F460		F496		F496		F460		F460		F460		F460		F460		F496		F460		F496		F496		F496		F496		F496		F410		F496		F496		F460		F460		F460
filing_sequence		0		1		0		0		0		0		0		1		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		1		0		1		1		0		0		0		0		1		1		1		0		0		0		2		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		1		0		1		0		0		2		0		1		0		0		0		0		1		1		0		2		0		0		1		0		0		1		0		0		1		1		1		0		0		0		0		0		0		1		1		0		0		0		0		0		0		0		0		1		0		0		1		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
filing_date		2018-09-26 00:00:00		2019-01-08 00:00:00		2018-08-30 00:00:00		2018-10-31 00:00:00		2018-11-05 00:00:00		2018-11-05 00:00:00		2018-10-21 00:00:00		2018-12-05 00:00:00		2020-10-22 00:00:00		2018-07-20 00:00:00		2020-10-22 00:00:00		2018-10-16 00:00:00		2018-10-31 00:00:00		2018-11-01 00:00:00		2018-10-25 00:00:00		2018-10-16 00:00:00		2019-01-09 00:00:00		2018-10-24 00:00:00		2018-09-27 00:00:00		2020-10-28 00:00:00		2018-10-02 00:00:00		2019-06-07 00:00:00		2018-10-04 00:00:00		2018-10-04 00:00:00		2019-07-19 00:00:00		2018-10-09 00:00:00		2018-10-18 00:00:00		2018-10-21 00:00:00		2018-09-21 00:00:00		2018-12-05 00:00:00		2018-12-05 00:00:00		2018-10-21 00:00:00		2018-10-23 00:00:00		2018-11-05 00:00:00		2018-10-26 00:00:00		2018-12-06 00:00:00		2018-12-06 00:00:00		2018-12-06 00:00:00		2019-07-22 00:00:00		2018-10-21 00:00:00		2018-10-31 00:00:00		2018-10-02 00:00:00		2018-11-01 00:00:00		2018-12-06 00:00:00		2018-11-01 00:00:00		2018-11-01 00:00:00		2020-10-08 00:00:00		2020-09-24 00:00:00		2018-10-12 00:00:00		2018-10-12 00:00:00		2018-10-18 00:00:00		2018-10-18 00:00:00		2018-10-21 00:00:00		2018-10-30 00:00:00		2018-09-14 00:00:00		2018-09-14 00:00:00		2019-01-31 00:00:00		2020-10-14 00:00:00		2020-10-14 00:00:00		2018-10-23 00:00:00		2018-10-24 00:00:00		2018-10-30 00:00:00		2018-11-01 00:00:00		2020-09-24 00:00:00		2018-10-30 00:00:00		2018-11-01 00:00:00		2018-10-05 00:00:00		2018-10-18 00:00:00		2019-01-09 00:00:00		2021-01-22 00:00:00		2019-01-04 00:00:00		2018-08-01 00:00:00		2018-10-25 00:00:00		2019-01-09 00:00:00		2020-12-11 00:00:00		2020-12-11 00:00:00		2018-10-21 00:00:00		2018-11-05 00:00:00		2018-11-05 00:00:00		2018-11-05 00:00:00		2018-10-02 00:00:00		2018-12-06 00:00:00		2018-10-09 00:00:00		2019-01-09 00:00:00		2020-10-09 00:00:00		2018-09-27 00:00:00		2019-01-09 00:00:00		2020-01-30 00:00:00		2018-10-30 00:00:00		2018-09-19 00:00:00		2018-09-20 00:00:00		2020-01-28 00:00:00		2020-12-11 00:00:00		2020-12-11 00:00:00		2018-12-06 00:00:00		2018-10-25 00:00:00		2019-01-31 00:00:00		2018-09-18 00:00:00		2020-07-24 00:00:00		2020-08-21 00:00:00		2018-09-28 00:00:00		2018-12-06 00:00:00		2018-12-06 00:00:00		2021-01-20 00:00:00		2021-07-28 00:00:00		2022-01-26 00:00:00		2022-05-06 00:00:00		2022-05-06 00:00:00		2020-07-21 00:00:00		2020-10-02 00:00:00		2022-04-28 00:00:00		2020-10-09 00:00:00		2022-05-31 00:00:00		2021-07-27 00:00:00		2020-12-15 00:00:00		2020-12-15 00:00:00		2022-01-25 00:00:00		2022-05-25 00:00:00		2022-06-01 00:00:00		2022-04-27 00:00:00		2022-05-29 00:00:00		2022-05-29 00:00:00		2022-05-20 00:00:00		2022-06-02 00:00:00		2022-06-03 00:00:00		2022-08-26 00:00:00		2022-05-18 00:00:00		2022-05-19 00:00:00		2022-05-25 00:00:00		2022-07-26 00:00:00		2022-10-27 00:00:00
stmnt_type		10001		10006		10001		10001		10001		10001		10001		10002		10001		10005		10005		10001		10001		10001		10005		10001		10002		10001		10001		10001		10001		10006		10001		10001		10001		10001		10001		10002		10001		10002		10002		10001		10001		10001		10001		10002		10002		10002		10005		10001		10001		10002		10001		10002		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10005		10001		10001		10006		10001		10002		10005		10002		10006		10001		10002		10001		10002		10001		10001		10001		10001		10002		10002		10001		10002		10001		10005		10002		10005		10001		10002		10001		10001		10002		10002		10002		10001		10001		10001		10005		10001		10001		10002		10002		10001		10005		10005		10001		10001		10001		10001		10005		10002		10001		10001		10006		10006		10001		10001		10001		10001		10001		10001		10001		10001		10001		10006		10001		10001		10005		10001		10001
stmnt_status		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11003		11003		11003		11001		11003		11003		11003		11001		11003		11003		11001		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11001		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11001		11001		11003		11003		11003		11003		11003		11001		11003		11001		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		11003		11003		11003		11001		11003		11003		11003		11001		11001		11003		11001		11003		11003		11003		11003		11001		11001		11001		11003		11003		11001		11003		11001		11003		11003		11001		11003		11003		11001		11001		11003		11001		11003		11003		11003		11003		11003		11001		11003		11003		11001		11003		11003
session_id		2017		2017		2017		2017		2017		2017		2017		2017		2019		2017		2019		2017		2017		2017		2017		2017		2019		2017		2017		2019		2017		2019		2017		2017		2019		2017		2017		2017		2017		2017		2017		2017		2017		2017		2017		2017		2017		2017		2019		2017		2017		2017		2017		2017		2017		2017		2019		2019		2017		2017		2017		2017		2017		2017		2017		2017		2017		2019		2019		2017		2017		2017		2017		2019		2017		2017		2017		2017		2019		2021		2017		2017		2017		2019		2019		2019		2017		2017		2017		2017		2017		2017		2017		2019		2019		2017		2019		2019		2017		2017		2017		2019		2019		2019		2017		2017		2017		2017		2019		2019		2017		2017		2017		2019		2021		2021		2021		2021		2019		2019		2021		2019		2021		2021		2019		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021
user_id		CAFILER		JFONSECA		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		IMEDINA		CPON		IMEDINA		CAFILER		CAFILER		CAFILER		CSAGABAEN		CAFILER		CAFILER		CAFILER		LBARTHOL		CAFILER		CAFILER		JFRONEFIELD		CAFILER		CAFILER		HCOURSEY		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		HCOURSEY		CAFILER		CAFILER		CAFILER		RGEREMIA		CAFILER		CAFILER		CAFILER		CAFILER		IMEDINA		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		LPHEAV		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		RGEREMIA		IMEDINA		CAFILER		CAFILER		AROJAS		CAFILER		CAFILER		SUSHAKOV		CAFILER		TRAMON		CAFILER		CAFILER		RGEREMIA		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		LBARTHOL		CAFILER		VUKSTINA		CAFILER		CAFILER		CAFILER		VUKSTINA		CAFILER		CAFILER		CAFILER		CSAGABAEN		LPHEAV		CAFILER		IMEDINA		CAFILER		CAFILER		CAFILER		CAFILER		SUSHAKOV		BCOLON		KRUSSELL		CAFILER		CAFILER		IMEDINA		CAFILER		KRUSSELL		CAFILER		CAFILER		BCOLON		JRAMOS		JRAMOS		KRUSSELL		KRUSSELL		CAFILER		KRUSSELL		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		IMEDINA		CAFILER		CAFILER		KRUSSELL		CAFILER		CAFILER
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		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		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		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		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
rpt_start		2018-09-26 00:00:00		2018-09-23 00:00:00		2018-08-30 00:00:00		2018-10-31 00:00:00		2018-11-05 00:00:00		2018-11-05 00:00:00		2018-10-21 00:00:00		2018-12-05 00:00:00		2020-09-20 00:00:00		None		2020-09-20 00:00:00		2018-10-16 00:00:00		2018-10-31 00:00:00		2018-11-01 00:00:00		2018-09-23 00:00:00		2018-10-16 00:00:00		2019-01-09 00:00:00		2018-10-24 00:00:00		2018-01-01 00:00:00		2020-10-28 00:00:00		2018-10-02 00:00:00		None		2018-10-04 00:00:00		2018-10-04 00:00:00		2019-01-01 00:00:00		2018-10-09 00:00:00		2018-10-18 00:00:00		2018-10-21 00:00:00		2018-09-21 00:00:00		2018-12-05 00:00:00		2018-12-05 00:00:00		2018-10-21 00:00:00		2018-10-23 00:00:00		2018-11-05 00:00:00		2018-10-26 00:00:00		2018-12-06 00:00:00		2018-12-06 00:00:00		2018-12-06 00:00:00		2019-01-01 00:00:00		2018-10-21 00:00:00		2018-10-31 00:00:00		2018-10-02 00:00:00		2018-11-01 00:00:00		2018-12-06 00:00:00		2018-11-01 00:00:00		2018-11-01 00:00:00		2020-10-08 00:00:00		2020-07-01 00:00:00		2018-10-12 00:00:00		2018-10-12 00:00:00		2018-10-18 00:00:00		2018-10-18 00:00:00		2018-10-21 00:00:00		2018-10-30 00:00:00		2018-09-14 00:00:00		2018-09-14 00:00:00		2018-10-21 00:00:00		2020-10-14 00:00:00		2020-10-14 00:00:00		2018-10-23 00:00:00		2018-10-24 00:00:00		2018-10-30 00:00:00		2018-11-01 00:00:00		2020-07-01 00:00:00		2018-10-30 00:00:00		2018-11-01 00:00:00		2018-07-01 00:00:00		2018-10-18 00:00:00		2019-01-09 00:00:00		2020-10-18 00:00:00		2018-09-23 00:00:00		None		2018-10-25 00:00:00		2019-01-09 00:00:00		2020-12-11 00:00:00		2020-07-01 00:00:00		2018-10-21 00:00:00		2018-11-05 00:00:00		2018-11-05 00:00:00		2018-11-05 00:00:00		2018-07-01 00:00:00		2018-12-06 00:00:00		2018-10-09 00:00:00		2019-01-09 00:00:00		2020-10-09 00:00:00		2018-01-01 00:00:00		2019-01-09 00:00:00		2019-07-01 00:00:00		2018-10-30 00:00:00		2018-09-19 00:00:00		2018-09-20 00:00:00		2019-07-01 00:00:00		2020-12-08 00:00:00		2020-09-20 00:00:00		2018-12-06 00:00:00		2018-09-23 00:00:00		2018-10-21 00:00:00		2018-09-18 00:00:00		2020-01-01 00:00:00		2020-08-21 00:00:00		2018-09-28 00:00:00		2018-12-06 00:00:00		2018-12-06 00:00:00		2020-10-18 00:00:00		2021-01-01 00:00:00		2021-07-01 00:00:00		2022-05-06 00:00:00		2022-05-06 00:00:00		2020-01-01 00:00:00		2020-10-02 00:00:00		2022-01-01 00:00:00		2020-10-09 00:00:00		2022-05-31 00:00:00		2021-01-01 00:00:00		2020-09-20 00:00:00		2020-07-01 00:00:00		2021-07-01 00:00:00		2022-04-24 00:00:00		2022-06-01 00:00:00		2022-01-01 00:00:00		2022-05-29 00:00:00		2022-05-29 00:00:00		2022-05-20 00:00:00		2022-06-02 00:00:00		2022-06-03 00:00:00		None		2022-05-18 00:00:00		2022-05-19 00:00:00		2022-04-24 00:00:00		2022-05-22 00:00:00		2022-07-01 00:00:00
rpt_end		2018-09-26 00:00:00		2018-10-20 00:00:00		2018-08-30 00:00:00		2018-10-31 00:00:00		2018-11-05 00:00:00		2018-11-05 00:00:00		2018-10-21 00:00:00		2018-12-05 00:00:00		2020-10-17 00:00:00		None		2020-10-17 00:00:00		2018-10-16 00:00:00		2018-10-31 00:00:00		2018-11-01 00:00:00		2018-10-20 00:00:00		2018-10-16 00:00:00		2019-01-09 00:00:00		2018-10-24 00:00:00		2018-09-22 00:00:00		2020-10-28 00:00:00		2018-10-02 00:00:00		None		2018-10-04 00:00:00		2018-10-04 00:00:00		2019-06-30 00:00:00		2018-10-09 00:00:00		2018-10-18 00:00:00		2018-10-21 00:00:00		2018-09-21 00:00:00		2018-12-05 00:00:00		2018-12-05 00:00:00		2018-10-21 00:00:00		2018-10-23 00:00:00		2018-11-05 00:00:00		2018-10-26 00:00:00		2018-12-06 00:00:00		2018-12-06 00:00:00		2018-12-06 00:00:00		2019-06-30 00:00:00		2018-10-21 00:00:00		2018-10-31 00:00:00		2018-10-02 00:00:00		2018-11-01 00:00:00		2018-12-06 00:00:00		2018-11-01 00:00:00		2018-11-01 00:00:00		2020-10-08 00:00:00		2020-09-19 00:00:00		2018-10-12 00:00:00		2018-10-12 00:00:00		2018-10-18 00:00:00		2018-10-18 00:00:00		2018-10-21 00:00:00		2018-10-30 00:00:00		2018-09-14 00:00:00		2018-09-14 00:00:00		2018-12-31 00:00:00		2020-10-14 00:00:00		2020-10-14 00:00:00		2018-10-23 00:00:00		2018-10-24 00:00:00		2018-10-30 00:00:00		2018-11-01 00:00:00		2020-09-19 00:00:00		2018-10-30 00:00:00		2018-11-01 00:00:00		2018-09-22 00:00:00		2018-10-18 00:00:00		2019-01-09 00:00:00		2020-12-31 00:00:00		2018-10-20 00:00:00		None		2018-10-25 00:00:00		2019-01-09 00:00:00		2020-12-11 00:00:00		2020-09-19 00:00:00		2018-10-21 00:00:00		2018-11-05 00:00:00		2018-11-05 00:00:00		2018-11-05 00:00:00		2018-09-22 00:00:00		2018-12-06 00:00:00		2018-10-09 00:00:00		2019-01-09 00:00:00		2020-10-09 00:00:00		2018-09-22 00:00:00		2019-01-09 00:00:00		2019-12-31 00:00:00		2018-10-30 00:00:00		2018-09-19 00:00:00		2018-09-20 00:00:00		2019-12-31 00:00:00		2020-12-08 00:00:00		2020-10-17 00:00:00		2018-12-06 00:00:00		2018-10-20 00:00:00		2018-12-31 00:00:00		2018-09-18 00:00:00		2020-06-30 00:00:00		2020-08-21 00:00:00		2018-09-28 00:00:00		2018-12-06 00:00:00		2018-12-06 00:00:00		2020-12-31 00:00:00		2021-06-30 00:00:00		2021-12-31 00:00:00		2022-05-06 00:00:00		2022-05-06 00:00:00		2020-06-30 00:00:00		2020-10-02 00:00:00		2022-04-23 00:00:00		2020-10-09 00:00:00		2022-05-31 00:00:00		2021-06-30 00:00:00		2020-10-17 00:00:00		2020-09-19 00:00:00		2021-12-31 00:00:00		2022-05-21 00:00:00		2022-06-01 00:00:00		2022-04-23 00:00:00		2022-05-29 00:00:00		2022-05-29 00:00:00		2022-05-20 00:00:00		2022-06-02 00:00:00		2022-06-03 00:00:00		None		2022-05-18 00:00:00		2022-05-19 00:00:00		2022-05-21 00:00:00		2022-06-30 00:00:00		2022-10-22 00:00:00
rpt_date		2018-09-26 00:00:00		None		2018-08-30 00:00:00		2018-10-31 00:00:00		2018-11-05 00:00:00		2018-11-05 00:00:00		2018-10-21 00:00:00		2018-12-05 00:00:00		2020-10-22 00:00:00		None		None		2018-10-16 00:00:00		2018-10-31 00:00:00		2018-11-01 00:00:00		None		2018-10-16 00:00:00		2019-01-09 00:00:00		2018-10-24 00:00:00		2018-09-27 00:00:00		2020-10-28 00:00:00		2018-10-02 00:00:00		None		2018-10-04 00:00:00		2018-10-04 00:00:00		2019-07-17 00:00:00		2018-10-09 00:00:00		2018-10-18 00:00:00		2018-10-21 00:00:00		2018-09-21 00:00:00		2018-12-05 00:00:00		2018-12-05 00:00:00		2018-10-21 00:00:00		2018-10-23 00:00:00		2018-11-05 00:00:00		2018-10-26 00:00:00		2018-12-06 00:00:00		2018-12-06 00:00:00		2018-12-06 00:00:00		None		2018-10-21 00:00:00		2018-10-31 00:00:00		2018-10-02 00:00:00		2018-11-01 00:00:00		2018-12-06 00:00:00		2018-11-01 00:00:00		2018-11-01 00:00:00		2020-10-08 00:00:00		2020-09-23 00:00:00		2018-10-12 00:00:00		2018-10-12 00:00:00		2018-10-18 00:00:00		2018-10-18 00:00:00		2018-10-21 00:00:00		2018-10-30 00:00:00		2018-09-14 00:00:00		2018-09-14 00:00:00		None		2020-10-14 00:00:00		2020-10-14 00:00:00		2018-10-23 00:00:00		2018-10-24 00:00:00		2018-10-30 00:00:00		2018-11-01 00:00:00		None		2018-10-30 00:00:00		2018-11-01 00:00:00		None		2018-10-18 00:00:00		2019-01-09 00:00:00		None		2019-01-04 00:00:00		None		2018-10-25 00:00:00		2019-01-09 00:00:00		2020-12-11 00:00:00		2020-12-11 00:00:00		2018-10-21 00:00:00		2018-11-05 00:00:00		2018-11-05 00:00:00		2018-11-05 00:00:00		2018-10-02 00:00:00		2018-12-06 00:00:00		2018-10-09 00:00:00		2019-01-09 00:00:00		2020-10-09 00:00:00		None		2019-01-09 00:00:00		None		2018-10-30 00:00:00		2018-09-19 00:00:00		2018-09-20 00:00:00		2020-01-28 00:00:00		2020-12-08 00:00:00		2020-12-11 00:00:00		2018-12-06 00:00:00		2018-10-25 00:00:00		2019-01-30 00:00:00		2018-09-18 00:00:00		None		2020-08-21 00:00:00		2018-09-28 00:00:00		2018-12-06 00:00:00		2018-12-06 00:00:00		2021-01-19 00:00:00		None		None		2022-05-06 00:00:00		2022-05-06 00:00:00		2020-07-21 00:00:00		2020-10-02 00:00:00		None		2020-10-09 00:00:00		2022-05-31 00:00:00		2021-07-10 00:00:00		None		None		2022-01-25 00:00:00		2022-05-25 00:00:00		2022-06-01 00:00:00		2022-04-25 00:00:00		2022-05-29 00:00:00		2022-05-29 00:00:00		2022-05-20 00:00:00		2022-06-02 00:00:00		2022-06-03 00:00:00		None		2022-05-18 00:00:00		2022-05-19 00:00:00		None		2022-07-26 00:00:00		2022-10-27 00:00:00
filing_type		22001		None		22001		22001		22001		22001		22001		22001		22001		None		None		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		None		22001		22001		None		22001		22001		None		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		None		None		22001		22001		22001		22001		None		22001		22001		22001		None		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		None		22001		22001

Table: filer_to_filer_type

filer_id		1407824		1407824		1407824
filer_type		16		16		16
active		Y		Y		Y
race		0		0		0
session_id		2017		2017		2021
category		0		0		0
category_type		40502		40502		40503
sub_category		40103		40103		40103
effect_dt		2018-08-01 00:00:00		2018-07-20 00:00:00		2022-08-26 00:00:00
sub_category_type		0		0		0
election_type		0		0		0
sub_category_a		None		None		None
nyq_dt		2018-07-31 00:00:00		None		2018-07-31 00:00:00
party_cd		0		0		0
county_cd		18026		18026		18026
district_cd		0		0		0

Table: filer_xref

filer_id		1407824
xref_id		1407824
effect_dt		2018-07-23 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1407824		1407824
filer_id		1407824		1407824
filer_type		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE
status		ACTIVE		ACTIVE
effect_dt		2022-08-26 00:00:00		2022-08-26 00:00:00
naml		BUSINESS LEADERS FOR ETHICAL GOVERNMENT		BUSINESS LEADERS FOR ETHICAL GOVERNMENT
namf		None		None
namt		None		None
nams		None		None
adr1		None		None
adr2		None		None
city		ENCINITAS		ENCINITAS
st		CA		CA
zip4		92024		92024
phon		7606323600		6197089744
fax		None		None
email		[email protected]		[email protected]

Table: filers

filer_id		1407824

Table: received_filings

filer_id		1407824		1407824
filing_file_name		279116.cal		2293170_0.cal
received_date		2018-10-02 00:00:00		2018-09-18 00:00:00
filing_directory		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal
filing_id		None		2293170
form_id		None		F497
receive_comment		Filing passed validation, but failed DB constraints		Filing accepted