Home

Filer ID: 1415175

Table: cvr_campaign_disclosure

filing_id		2398112		2380326		2376384		2377135		2486679		2443526		2548121		2561443		2552941		2557344		2558152		2542474		2524144		2569744		2564606		2544517		2552941		2568442		2553353		2573009		2617330		2583392		2632240		2602411		2669398		2588098		2589994		2670418		2612320		2612895		2630768		2671057		2613395		2662858		2627636		2628465		2632634		2660929		2583976		2661466		2589134		2612665		2666360		2590651		2613937		2673895		2655470		2673782		2658258		2631893		2630955		2631533		2664186		2659879		2634808		2632673		2585711		2588731		2590200		2590703		2631532		2589660		2606404		2633315		2663340		2630605		2631563		2589973		2645032		2585046		2589768		2590101		2594508		2644375		2637403		2666092		2631022		2667253		2631259		2672239		2659070		2725806		2730961		2687487		2707927		2725973		2678930		2689557		2692756		2692381		2682821		2685672		2728510		2698770		2730704		2684534		2682552		2718351		2688835		2711482		2687487		2691086		2722875		2729077		2679309		2716911		2687917		2681524		2729468		2713237		2687487		2729972		2729976		2683076		2730227		2685204		2724024		2685259		2681528		2679720		2719267		2719006		2683475		2692359		2692360		2730234		2696726		2725445		2690405		2727111		2685203		2679812		2679900		2677345		2683810		2689530		2681155		2681156		2683810		2707927		2709512		2684261		2739947		2731695		2740370		2744129		2738288		2745177		2751835		2753169		2739569		2750550		2731049		2735383		2752687		2732859		2750159		2751845		2729077
amend_id		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		2		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1
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		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		F460		F497		F497		F497		F460		F460		F497		F497		F460		F497		F497		F497		F497		F497		F497		F497		F460		F497		F497		F497		F497		F497		F497		F460		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F460		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F460		F497		F497		F497		F497		F497		F497		F497		F497		F497		F460		F460		F460		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F460		F497		F497		F497		F497		F497		F497		F497		F497		F497		F460		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F460		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F460		F497		F497		F497		F497		F497		F460		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497
filer_id		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175
entity_cd		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		None		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		None		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		None		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL		CTL
filer_naml		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
report_num		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		001		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		002		001		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		001		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		001		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		001
rpt_date		2019-07-30 00:00:00		2019-04-30 00:00:00		2019-04-23 00:00:00		2019-04-25 00:00:00		2020-07-31 00:00:00		2020-01-29 00:00:00		2021-01-27 00:00:00		2021-03-01 00:00:00		2021-01-30 00:00:00		2021-02-11 00:00:00		2021-02-17 00:00:00		2021-01-05 00:00:00		2020-10-26 00:00:00		2021-03-25 00:00:00		2021-03-10 00:00:00		2021-01-15 00:00:00		2021-02-25 00:00:00		2021-03-22 00:00:00		2021-02-01 00:00:00		2021-04-08 00:00:00		2021-10-20 00:00:00		2021-05-10 00:00:00		2021-12-29 00:00:00		2021-07-29 00:00:00		2022-04-22 00:00:00		2021-06-14 00:00:00		2021-06-29 00:00:00		2022-04-25 00:00:00		2021-09-21 00:00:00		2021-09-27 00:00:00		2021-12-13 00:00:00		2022-04-26 00:00:00		2021-09-30 00:00:00		2022-04-04 00:00:00		2021-11-09 00:00:00		2021-11-15 00:00:00		2022-01-03 00:00:00		2022-03-28 00:00:00		2021-05-13 00:00:00		2022-03-29 00:00:00		2021-06-22 00:00:00		2021-09-23 00:00:00		2022-04-14 00:00:00		2021-07-02 00:00:00		2021-10-05 00:00:00		2022-04-28 00:00:00		2022-03-07 00:00:00		2022-04-28 00:00:00		2022-03-17 00:00:00		2021-12-27 00:00:00		2021-12-14 00:00:00		2021-12-21 00:00:00		2022-04-07 00:00:00		2022-03-23 00:00:00		2022-01-17 00:00:00		2022-01-04 00:00:00		2021-05-26 00:00:00		2021-06-18 00:00:00		2021-06-30 00:00:00		2021-07-02 00:00:00		2021-12-21 00:00:00		2021-06-24 00:00:00		2021-08-12 00:00:00		2022-01-07 00:00:00		2022-04-05 00:00:00		2021-12-10 00:00:00		2021-12-21 00:00:00		2021-06-29 00:00:00		2022-01-31 00:00:00		2021-05-21 00:00:00		2021-06-25 00:00:00		2021-06-30 00:00:00		2021-07-20 00:00:00		2022-01-31 00:00:00		2022-01-25 00:00:00		2022-04-13 00:00:00		2021-12-15 00:00:00		2022-04-18 00:00:00		2021-12-17 00:00:00		2022-04-27 00:00:00		2022-03-21 00:00:00		2022-09-29 00:00:00		2022-10-11 00:00:00		2022-09-29 00:00:00		2022-09-29 00:00:00		2022-09-29 00:00:00		2022-05-03 00:00:00		2022-06-01 00:00:00		2022-06-08 00:00:00		2022-06-07 00:00:00		2022-05-16 00:00:00		2022-05-24 00:00:00		2022-10-04 00:00:00		2022-07-18 00:00:00		2022-10-10 00:00:00		2022-05-20 00:00:00		2022-05-13 00:00:00		2022-09-08 00:00:00		2022-05-31 00:00:00		2022-08-16 00:00:00		2022-05-26 00:00:00		2022-06-03 00:00:00		2022-09-23 00:00:00		2022-10-05 00:00:00		2022-05-04 00:00:00		2022-09-02 00:00:00		2022-05-27 00:00:00		2022-05-11 00:00:00		2022-10-06 00:00:00		2022-08-22 00:00:00		2022-06-03 00:00:00		2022-10-07 00:00:00		2022-10-07 00:00:00		2022-05-16 00:00:00		2022-10-07 00:00:00		2022-05-22 00:00:00		2022-09-27 00:00:00		2022-05-23 00:00:00		2022-05-11 00:00:00		2022-05-05 00:00:00		2022-09-12 00:00:00		2022-09-12 00:00:00		2022-05-17 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-10-07 00:00:00		2022-07-06 00:00:00		2022-09-29 00:00:00		2022-06-02 00:00:00		2022-09-30 00:00:00		2022-05-23 00:00:00		2022-05-06 00:00:00		2022-05-06 00:00:00		2022-05-02 00:00:00		2022-05-25 00:00:00		2022-06-01 00:00:00		2022-05-10 00:00:00		2022-05-10 00:00:00		2022-05-18 00:00:00		2022-08-01 00:00:00		2022-08-05 00:00:00		2022-05-19 00:00:00		2022-10-24 00:00:00		2022-10-12 00:00:00		2022-10-25 00:00:00		2022-10-27 00:00:00		2022-10-21 00:00:00		2022-10-28 00:00:00		2022-11-03 00:00:00		2022-11-07 00:00:00		2022-10-24 00:00:00		2022-11-01 00:00:00		2022-10-11 00:00:00		2022-10-18 00:00:00		2022-11-05 00:00:00		2022-10-13 00:00:00		2022-11-01 00:00:00		2022-11-03 00:00:00		2022-10-25 00:00:00
stmt_type		SA		None		None		None		SA		SA		None		None		SA		None		None		None		None		None		None		None		SA		None		None		None		None		None		None		SA		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		SA		None		None		None		None		None		None		None		None		None		PE		SA		PE		None		None		None		None		None		None		None		None		None		None		None		None		None		None		PE		None		None		None		None		None		None		None		None		None		PE		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		SA		None		None		None		None		None		PE		None		None		None		None		None		None		None		None		None		None		None		None		None
late_rptno		None		29728		29699		29712		None		None		01272021-1		03012021-1		None		02112021-1		02172021-1		35358		34858		03252021-1		03102021-1		01152021-1		None		03222021-1		02012021-1		04082021-1		10202021-1		05102021-1		12292021-1		None		04222022-1		06142021-1		06292021-2		04252022-1		09212021-1		09272021-1		12132021-1		04262022-1		09302021-1		04042022-1		11092021-1		11152021-1		01032022-1		03282022-1		05132021-1		03292022-1		06222021-1		09232021-1		04142022-1		07022021-1		10052021-1		None		03072022-1		04282022-1		03172022-1		12272021-1		12142021-1		12212021-1		04072022-1		03232022-1		01172022-1		01042022-1		05262021-1		06182021-1		06302021-2		07022021-2		12202021-1		06242021-1		08122021-1		01072022-1		04052022-1		12102021-1		12212021-2		06292021-1		01312022-1		05212021-1		06252021-1		06302021-1		07202021-1		None		01252022-1		04132022-1		12152021-1		04182022-1		12172021-1		04272022-1		03212022-1		09292022-2		10112022-1		None		None		None		05032022-1		06012022-2		06082022-1		06072022-2		05162022-1		05242022-1		10042022-1		07182022-1		10102022-1		05202022-1		05132022-1		09082022-1		05312022-1		08162022-1		None		06032022-2		09232022-1		10052022-1		05042022-1		09022022-1		05272022-1		05112022-1		10062022-1		08222022-1		None		10072022-1		10072022-2		05162022-2		10072022-4		05222022-1		09272022-1		05232022-2		05112022-2		05052022-1		09122022-2		09122022-1		05172022-1		None		06072022-1		10072022-3		07062022-1		09292022-1		06022022-1		09302022-1		05232022-1		05062022-1		05062022-2		05022022-1		05182022-1		06012022-1		05102022-1		05102022-2		05182022-1		None		08052022-1		05192022-1		10242022-2		10122022-1		10252022-1		None		10212022-1		10282022-1		11032022-1		11072022-1		10242022-1		11012022-2		10112022-2		10182022-1		11052022-1		10132022-1		11012022-1		11032022-2		10052022-1
from_date		2019-01-01 00:00:00		None		None		None		2020-01-01 00:00:00		2019-07-01 00:00:00		None		None		2020-07-01 00:00:00		None		None		None		None		None		None		None		2020-07-01 00:00:00		None		None		None		None		None		None		2021-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		2022-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		2021-07-01 00:00:00		None		None		None		None		None		None		None		None		None		2022-04-24 00:00:00		2022-05-22 00:00:00		2022-07-01 00:00:00		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2022-04-24 00:00:00		None		None		None		None		None		None		None		None		None		2022-04-24 00:00:00		None		None		None		None		None		None		None		None		None		None		None		None		2022-01-01 00:00:00		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2022-05-22 00:00:00		None		None		None		None		None		2022-09-25 00:00:00		None		None		None		None		None		None		None		None		None		None		None		None		None
thru_date		2019-06-30 00:00:00		None		None		None		2020-06-30 00:00:00		2019-12-31 00:00:00		None		None		2020-12-31 00:00:00		None		None		None		None		None		None		None		2020-12-31 00:00:00		None		None		None		None		None		None		2021-06-30 00:00:00		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2022-04-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		None		2021-12-31 00:00:00		None		None		None		None		None		None		None		None		None		2022-05-21 00:00:00		2022-06-30 00:00:00		2022-09-24 00:00:00		None		None		None		None		None		None		None		None		None		None		None		None		None		None		2022-05-21 00:00:00		None		None		None		None		None		None		None		None		None		2022-05-21 00:00:00		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		None		None		None		None		None		None		None		2022-06-30 00:00:00		None		None		None		None		None		2022-10-22 00:00:00		None		None		None		None		None		None		None		None		None		None		None		None		None
elect_date		None		None		None		None		None		None		None		None		2022-06-07 00:00:00		None		None		None		None		None		None		None		2022-06-07 00:00:00		None		None		None		None		None		None		None		2022-06-07 00:00:00		None		None		2022-06-07 00:00:00		None		None		None		2022-06-07 00:00:00		None		2022-06-07 00:00:00		None		None		None		None		None		None		None		None		2022-06-07 00:00:00		None		None		2022-06-07 00:00:00		None		2022-06-07 00:00:00		None		None		None		None		2022-06-07 00:00:00		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		None		None		2022-06-07 00:00:00		None		2022-06-07 00:00:00		None		2022-06-07 00:00:00		None		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		None		2022-11-08 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-11-08 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-11-08 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		None		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-06-07 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-06-07 00:00:00		2022-11-08 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-11-08 00:00:00		2022-06-07 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00		2022-11-08 00:00:00
filer_city		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Long Beach		Sacramento		Sacramento		Long Beach		Sacramento		Sacramento		Long Beach		Long Beach		Sacramento		Sacramento		Long Beach		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento
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		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		90802		90807		90807		90807		90802		90802		95841		95841		90802		95841		95841		90802		90802		95841		95841		90802		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841
filer_phon		(916) 442-2952		(916) 442-2952		(916) 442-2952		(916) 442-2952		(916) 442-2952		(916) 442-2952		916-348-9100		916-348-9100		(916) 442-2952		916-348-9100		916-348-9100		(916) 442-2952		(916) 442-2952		916-348-9100		916-348-9100		(916) 442-2952		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100
filer_fax		(916) 442-1280		(916) 442-1280		(916) 442-1280		(916) 442-1280		(916) 442-1280		(916) 442-1280		916-348-9111		916-348-9111		(916) 442-1280		916-348-9111		916-348-9111		(916) 442-1280		(916) 442-1280		916-348-9111		916-348-9111		(916) 442-1280		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111		916-348-9111
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]		[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		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		None		None		Sacramento		None		None		Sacramento		Sacramento		None		None		Sacramento		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		CA		CA		CA		CA		CA		CA		None		None		CA		None		None		CA		CA		None		None		CA		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		95814		95814		95814		95814		95814		95814		None		None		95814		None		None		95814		95814		None		None		95814		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		Lara		Lara		Lara		Lara		Lewis		Lewis		Lewis		Lewis		Lewis		Lewis		Lewis		Lewis		Lewis		Lewis		Lewis		Lewis		Lewis		Lewis		Lewis		Lewis		Lewis		Lewis		Lewis		Lewis		None		Lewis		Lewis		None		Lewis		Lewis		Lewis		None		Lewis		None		Lewis		Lewis		Lewis		Lewis		Lewis		Lewis		Lewis		Lewis		None		Lewis		Lewis		Lewis		Lewis		None		Lewis		Lewis		Lewis		Lewis		None		Lewis		Lewis		Lewis		Lewis		Lewis		Lewis		Lewis		Lewis		Lewis		Lewis		Lewis		None		Lewis		Lewis		Lewis		Lewis		Lewis		Lewis		Lewis		Lewis		Lewis		Lewis		None		Lewis		None		Lewis		None		Lewis		None		None		Lewis		Lewis		Lewis		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Lewis		None		None		None		None		None		None		None		None		None		Lewis		None		None		None		None		None		None		None		None		None		None		None		None		Lewis		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Lewis		None		None		None		None		None		Lewis		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_namf		Ricardo		Ricardo		Ricardo		Ricardo		Denise		Denise		Denise		Denise		Denise		Denise		Denise		Denise		Denise		Denise		Denise		Denise		Denise		Denise		Denise		Denise		Denise		Denise		Denise		Denise		None		Denise		Denise		None		Denise		Denise		Denise		None		Denise		None		Denise		Denise		Denise		Denise		Denise		Denise		Denise		Denise		None		Denise		Denise		Denise		Denise		None		Denise		Denise		Denise		Denise		None		Denise		Denise		Denise		Denise		Denise		Denise		Denise		Denise		Denise		Denise		Denise		None		Denise		Denise		Denise		Denise		Denise		Denise		Denise		Denise		Denise		Denise		None		Denise		None		Denise		None		Denise		None		None		Denise		Denise		Denise		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Denise		None		None		None		None		None		None		None		None		None		Denise		None		None		None		None		None		None		None		None		None		None		None		None		Denise		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Denise		None		None		None		None		None		Denise		None		None		None		None		None		None		None		None		None		None		None		None		None
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		Long Beach		Long Beach		Long Beach		Long Beach		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		None		Sacramento		Sacramento		None		Sacramento		Sacramento		Sacramento		None		Sacramento		None		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		None		Sacramento		Sacramento		Sacramento		Sacramento		None		Sacramento		Sacramento		Sacramento		Sacramento		None		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		None		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		None		Sacramento		None		Sacramento		None		Sacramento		None		None		Sacramento		Sacramento		Sacramento		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Sacramento		None		None		None		None		None		None		None		None		None		Sacramento		None		None		None		None		None		None		None		None		None		None		None		None		Sacramento		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Sacramento		None		None		None		None		None		Sacramento		None		None		None		None		None		None		None		None		None		None		None		None		None
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		None		CA		CA		None		CA		CA		CA		None		CA		None		CA		CA		CA		CA		CA		CA		CA		CA		None		CA		CA		CA		CA		None		CA		CA		CA		CA		None		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		None		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		None		CA		None		CA		None		CA		None		None		CA		CA		CA		None		None		None		None		None		None		None		None		None		None		None		None		None		None		CA		None		None		None		None		None		None		None		None		None		CA		None		None		None		None		None		None		None		None		None		None		None		None		CA		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		CA		None		None		None		None		None		CA		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_zip4		90802		90807		90807		90807		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		None		95841		95841		None		95841		95841		95841		None		95841		None		95841		95841		95841		95841		95841		95841		95841		95841		None		95841		95841		95841		95841		None		95841		95841		95841		95841		None		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		None		95841		95841		95841		95841		95841		95841		95841		95841		95841		95841		None		95841		None		95841		None		95841		None		None		95841		95841		95841		None		None		None		None		None		None		None		None		None		None		None		None		None		None		95841		None		None		None		None		None		None		None		None		None		95841		None		None		None		None		None		None		None		None		None		None		None		None		95841		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		95841		None		None		None		None		None		95841		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_phon		(916) 442-2952		(916) 442-2952		(916) 442-2952		(916) 442-2952		(916) 348-9100		(916) 348-9100		916-348-9100		916-348-9100		(916) 348-9100		916-348-9100		916-348-9100		(916) 348-9100		(916) 348-9100		916-348-9100		916-348-9100		(916) 348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		None		916-348-9100		916-348-9100		None		916-348-9100		916-348-9100		916-348-9100		None		916-348-9100		None		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		None		916-348-9100		916-348-9100		916-348-9100		916-348-9100		None		916-348-9100		916-348-9100		916-348-9100		916-348-9100		None		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		None		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		916-348-9100		None		916-348-9100		None		916-348-9100		None		916-348-9100		None		None		916-348-9100		916-348-9100		916-348-9100		None		None		None		None		None		None		None		None		None		None		None		None		None		None		916-348-9100		None		None		None		None		None		None		None		None		None		916-348-9100		None		None		None		None		None		None		None		None		None		None		None		None		916-348-9100		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		916-348-9100		None		None		None		None		None		916-348-9100		None		None		None		None		None		None		None		None		None		None		None		None		None
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		C		None		None		None		C		C		None		None		C		None		None		None		None		None		None		None		C		None		None		None		None		None		None		C		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		C		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		C		None		None		None		None		None		None		None		None		None		C		C		C		None		None		None		None		None		None		None		None		None		None		None		None		None		None		C		None		None		None		None		None		None		None		None		None		C		None		None		None		None		None		None		None		None		None		None		None		None		C		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		C		None		None		None		None		None		C		None		None		None		None		None		None		None		None		None		None		None		None		None
control_yn		N		None		None		None		N		N		None		None		N		None		None		None		None		None		None		None		N		None		None		None		None		None		None		Y		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Y		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Y		None		None		None		None		None		None		None		None		None		Y		Y		Y		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Y		None		None		None		None		None		None		None		None		None		Y		None		None		None		None		None		None		None		None		None		None		None		None		Y		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Y		None		None		None		None		None		Y		None		None		None		None		None		None		None		None		None		None		None		None		None
sponsor_yn		N		None		None		None		N		N		None		None		N		None		None		None		None		None		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		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		N		None		None		None		None		None		None		None		None		None		N		N		N		None		None		None		None		None		None		None		None		None		None		None		None		None		None		N		None		None		None		None		None		None		None		None		None		N		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		N		None		None		None		None		None		N		None		None		None		None		None		None		None		None		None		None		None		None		None
primfrm_yn		N		None		None		None		N		N		None		None		N		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		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
brdbase_yn		N		None		None		None		N		N		None		None		N		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		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
amendexp_1		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Amend to Update Schedule F and Summary Page		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Amend to Update Schedule F, G and Summary Page		Amend to Update Schedule F and Summary Page		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Amend Schedule F and G, update summary page totals		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Amend to remove returned contribution		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Amend to Update Name and Add FPPC ID# for United Parcel Service Contribution
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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		Lara		None		None		None		Lara		Lara		None		None		Lara		None		None		None		None		None		None		None		Lara		None		None		None		None		None		None		Lara		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Lara		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Lara		None		None		None		None		None		None		None		None		None		Lara		Lara		Lara		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Lara		None		None		None		None		None		None		None		None		None		Lara		None		None		None		None		None		None		None		None		None		None		None		None		Lara		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Lara		None		None		None		None		None		Lara		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_namf		Ricardo		None		None		None		Ricardo		Ricardo		None		None		Ricardo		None		None		None		None		None		None		None		Ricardo		None		None		None		None		None		None		Ricardo		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Ricardo		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Ricardo		None		None		None		None		None		None		None		None		None		Ricardo		Ricardo		Ricardo		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Ricardo		None		None		None		None		None		None		None		None		None		Ricardo		None		None		None		None		None		None		None		None		None		None		None		None		Ricardo		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Ricardo		None		None		None		None		None		Ricardo		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		Long Beach		None		None		None		Long Beach		Long Beach		None		None		Long Beach		None		None		None		None		None		None		None		Long Beach		None		None		None		None		None		None		Long Beach		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Long Beach		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Long Beach		None		None		None		None		None		None		None		None		None		Long Beach		Long Beach		Long Beach		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Long Beach		None		None		None		None		None		None		None		None		None		Long Beach		None		None		None		None		None		None		None		None		None		None		None		None		Long Beach		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Long Beach		None		None		None		None		None		Long Beach		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_st		CA		None		None		None		CA		CA		None		None		CA		None		None		None		None		None		None		None		CA		None		None		None		None		None		None		CA		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		CA		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		CA		None		None		None		None		None		None		None		None		None		CA		CA		CA		None		None		None		None		None		None		None		None		None		None		None		None		None		None		CA		None		None		None		None		None		None		None		None		None		CA		None		None		None		None		None		None		None		None		None		None		None		None		CA		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		CA		None		None		None		None		None		CA		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_zip4		90802		None		None		None		90802		90802		None		None		90802		None		None		None		None		None		None		None		90802		None		None		None		None		None		None		90802		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		90802		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		90802		None		None		None		None		None		None		None		None		None		90802		90802		90802		None		None		None		None		None		None		None		None		None		None		None		None		None		None		90802		None		None		None		None		None		None		None		None		None		90802		None		None		None		None		None		None		None		None		None		None		None		None		90802		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		90802		None		None		None		None		None		90802		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_phon		(916) 442-2952		None		None		None		(916) 442-2952		(916) 442-2952		None		None		(916) 442-2952		None		None		None		None		None		None		None		(916) 442-2952		None		None		None		None		None		None		(916) 442-2952		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		(916) 442-2952		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		(916) 442-2952		None		None		None		None		None		None		None		None		None		(916) 442-2952		(916) 442-2952		(916) 442-2952		None		None		None		None		None		None		None		None		None		None		None		None		None		None		(916) 442-2952		None		None		None		None		None		None		None		None		None		(916) 442-2952		None		None		None		None		None		None		None		None		None		None		None		None		(916) 442-2952		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		(916) 442-2952		None		None		None		None		None		(916) 442-2952		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_fax		(916) 442-1280		None		None		None		(916) 442-1280		(916) 442-1280		None		None		(916) 442-1280		None		None		None		None		None		None		None		(916) 442-1280		None		None		None		None		None		None		(916) 442-1280		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		(916) 442-1280		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		(916) 442-1280		None		None		None		None		None		None		None		None		None		(916) 442-1280		(916) 442-1280		(916) 442-1280		None		None		None		None		None		None		None		None		None		None		None		None		None		None		(916) 442-1280		None		None		None		None		None		None		None		None		None		(916) 442-1280		None		None		None		None		None		None		None		None		None		None		None		None		(916) 442-1280		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		(916) 442-1280		None		None		None		None		None		(916) 442-1280		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_email		[email protected]		None		None		None		[email protected]		[email protected]		None		None		[email protected]		None		None		None		None		None		None		None		[email protected]		None		None		None		None		None		None		[email protected]		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		None		[email protected]		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		INS		None		None		None		INS		INS		None		None		INS		None		None		None		None		None		None		None		INS		None		None		None		None		None		None		INS		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		INS		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		INS		None		None		None		None		None		None		None		None		None		INS		INS		INS		None		None		None		None		None		None		None		None		None		None		None		None		None		None		INS		None		None		None		None		None		None		None		None		None		INS		None		None		None		None		None		None		None		None		None		None		None		None		INS		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		INS		None		None		None		None		None		INS		None		None		None		None		None		None		None		None		None		None		None		None		None
offic_dscr		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
juris_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		STW		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		STW		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		STW		None		None		None		None		None		None		None		None		None		STW		STW		STW		None		None		None		None		None		None		None		None		None		None		None		None		None		None		STW		None		None		None		None		None		None		None		None		None		STW		None		None		None		None		None		None		None		None		None		None		None		None		STW		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		STW		None		None		None		None		None		STW		None		None		None		None		None		None		None		None		None		None		None		None		None
juris_dscr		Statewide		None		None		None		Statewide		Statewide		None		None		Statewide		None		None		None		None		None		None		None		Statewide		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
dist_no		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
off_s_h_cd		H		None		None		None		H		H		None		None		H		None		None		None		None		None		None		None		H		None		None		None		None		None		None		H		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		H		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		H		None		None		None		None		None		None		None		None		None		H		H		H		None		None		None		None		None		None		None		None		None		None		None		None		None		None		H		None		None		None		None		None		None		None		None		None		H		None		None		None		None		None		None		None		None		None		None		None		None		H		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		H		None		None		None		None		None		H		None		None		None		None		None		None		None		None		None		None		None		None		None
sup_opp_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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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: cvr_so

filing_id		2335015		2335015		2335015		2335015		2335015
amend_id		0		2		1		4		3
rec_type		CVR		CVR		CVR		CVR		CVR
form_type		F410		F410		F410		F410		F410
filer_id		1415175		1415175		1415175		1415175		1415175
entity_cd		RCP		RCP		RCP		RCP		RCP
filer_naml		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022		Ricardo Lara for Insurance Commissioner 2022
filer_namf		None		None		None		None		None
filer_namt		None		None		None		None		None
filer_nams		None		None		None		None		None
report_num		000		002		001		004		003
rpt_date		2019-01-17 00:00:00		2019-09-10 00:00:00		2019-05-17 00:00:00		2021-01-21 00:00:00		2021-01-07 00:00:00
qual_cb		X		X		X		X		X
qualfy_dt		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00		2019-01-01 00:00:00
term_date		None		None		None		None		None
city		Long Beach		Long Beach		Long Beach		Sacramento		Long Beach
st		CA		CA		CA		CA		CA
zip4		90807		90802		90802		95841		90802
phone		(916) 442-2952		(916) 442-2952		(916) 442-2952		916-348-9100		(916) 442-2952
county_res		Los Angeles		Los Angeles		Los Angeles		Sacramento		Los Angeles
county_act		Statewide		Statewide		Statewide		Statewide		Statewide
mail_city		Sacramento		Sacramento		Sacramento		None		Sacramento
mail_st		CA		CA		CA		None		CA
mail_zip4		95814		95814		95814		None		95814
cmte_fax		(916) 442-1280		(916) 442-1280		(916) 442-1280		916-348-9111		(916) 442-1280
cmte_email		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]
tres_naml		Lara		Lewis		Lara		Lewis		Lewis
tres_namf		Ricardo		Denise		Ricardo		Denise		Denise
tres_namt		None		None		None		None		None
tres_nams		None		None		None		None		None
tres_city		Long Beach		Sacramento		Long Beach		Sacramento		Sacramento
tres_st		CA		CA		CA		CA		CA
tres_zip4		90807		95841		90802		95841		95841
tres_phon		(916) 442-2952		(916) 348-9100		(916) 442-2952		916-348-9100		(916) 348-9100
actvty_lvl		None		None		None		None		None
com82013yn		None		None		None		None		None
com82013nm		None		None		None		None		None
com82013id		None		None		None		None		None
control_cb		X		X		X		X		X
bank_nam		Wells Fargo Bank		Wells Fargo Bank		Wells Fargo Bank		First Foundation Bank		Wells Fargo Bank
bank_adr1		400 Capitol Mall		400 Capitol Mall		400 Capitol Mall		2233 Douglas Boulevard, Suite 300		400 Capitol Mall
bank_adr2		None		None		None		None		None
bank_city		Sacramento		Sacramento		Sacramento		Roseville		Sacramento
bank_st		CA		CA		CA		CA		CA
bank_zip4		95814		95814		95814		95661		95814
bank_phon		(916) 440-4205		(916) 440-4205		(916) 440-4205		916-724-2424		(916) 440-4205
acct_opendt		None		None		None		None		None
surplusdsp		None		None		None		None		None
primfc_cb		None		None		None		None		None
genpurp_cb		None		None		None		None		None
gpc_descr		None		None		None		None		None
sponsor_cb		None		None		None		None		None
brdbase_cb		None		None		None		None		None
smcont_qualdt		None		None		None		None		None

Table: filer_address

filer_id		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175
adrid		2473520		2473521		2480592		2480591		2514303		2514304		2514306		2514307
effect_dt		2019-01-16 00:00:00		2019-01-16 00:00:00		2019-05-17 00:00:00		2019-05-17 00:00:00		2021-01-04 00:00:00		2021-01-04 00:00:00		2021-01-28 00:00:00		2021-01-28 00:00:00
add_type		7051		7082		7082		7051		7051		7082		7051		7082
session_id		2019		2019		2019		2019		2021		2021		2021		2021

Table: filer_filings

filer_id		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175
filing_id		2398112		2486679		2401004		2384735		2568442		2557206		2335015		2551550		2376384		2377135		2409864		2497692		2380326		2524144		2335015		2445595		2558152		2561443		2335015		2585711		2445595		2590703		2573009		2606404		2590651		2590101		2548121		2335015		2334932		2335015		2443526		2602411		2673895		2688835		2557344		2552941		2613395		2630768		2673782		2583392		2682821		2669398		2685672		2679309		2692756		2666360		2589134		2588098		2612665		2633738		2683076		2687917		2687487		2695080		2630955		2631533		2671057		2658258		2632673		2672239		2544517		2589994		2690405		2608056		2659879		2681528		2663340		2685204		2685259		2696726		2685203		2689530		2666092		2667253		2585046		2612320		2612895		2684261		2631022		2670418		2677345		2659070		2681155		2681156		2594508		2679812		2679900		2683810		2632240		2569744		2589768		2590200		2684534		2687487		2617330		2662858		2713237		2627636		2628465		2689539		2689557		2678930		2718351		2682552		2724024		2725445		2655470		2681524		2692381		2564606		2589973		2716911		2553353		2583976		2542474		2588731		2660929		2661466		2631893		2632634		2691086		2613937		2692359		2692360		2653189		2719267		2630605		2631563		2679720		2698770		2683475		2664186		2631532		2634808		2633315		2719006		2722875		2695080		2707927		2552941		2589660		2709512		2711482		2644375		2645032		2683810		2637403		2631259		2730961		2751835		2752687		2729972		2735383		2729976		2730227		2732859		2751845		2750550		2727111		2750159		2740370		2730234		2753169		2739569		2754458		2731049		2729077		2739947		2725806		2687487		2707927		2725973		2744129		2729077		2729468		2730704		2731695		2738288		2745177		2728510		2738961
period_id		237		241		None		None		245		None		237		None		238		238		None		None		238		244		245		None		245		245		239		246		None		247		246		247		247		246		245		245		None		238		239		245		249		250		245		243		247		248		250		246		250		250		250		250		250		250		246		246		247		None		250		250		250		None		248		248		250		249		249		250		245		246		250		None		249		250		250		250		250		251		250		250		250		250		246		247		247		250		248		250		250		249		250		250		247		250		250		250		248		245		246		246		250		250		248		250		251		248		248		None		250		250		251		250		251		251		249		250		250		245		246		251		245		246		245		246		249		249		248		249		250		248		249		250		None		251		248		248		250		251		250		250		248		249		249		251		251		None		250		243		246		251		251		247		249		250		249		248		252		252		252		252		252		252		252		252		252		252		251		252		252		252		252		252		None		252		252		252		251		250		250		251		251		252		252		252		252		252		252		252		None
form_id		F460		F460		F460		F410		F497		F410		F410		F410		F497		F497		F410		F460		F497		F497		F410		F460		F497		F497		F410		F497		F460		F497		F497		F497		F497		F497		F497		F410		F410		F410		F460		F460		F460		F497		F497		F460		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F460		F497		F497		F460		F460		F497		F497		F497		F497		F497		F497		F497		F497		F497		F460		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F460		F497		F497		F497		F497		F497		F460		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F460		F497		F460		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F460		F460		F460		F497		F497		F497		F460		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F460		F497		F497		F497		F497		F460		F460		F460		F460		F497		F497		F497		F497		F497		F497		F497		F460
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		0		0		3		0		0		0		2		0		1		0		0		0		0		0		0		4		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		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		2		1		0		0		0		0		0		0		0		0		0		0
filing_date		2019-07-31 00:00:00		2020-07-31 00:00:00		2019-07-31 00:00:00		2019-05-17 00:00:00		2021-03-22 00:00:00		2021-01-28 00:00:00		2019-01-17 00:00:00		2021-01-04 00:00:00		2019-04-23 00:00:00		2019-04-25 00:00:00		2019-09-10 00:00:00		2020-07-31 00:00:00		2019-04-30 00:00:00		2020-10-27 00:00:00		2021-01-07 00:00:00		2020-01-31 00:00:00		2021-02-17 00:00:00		2021-03-01 00:00:00		2019-09-10 00:00:00		2021-05-27 00:00:00		2021-03-26 00:00:00		2021-07-02 00:00:00		2021-04-08 00:00:00		2021-08-12 00:00:00		2021-07-02 00:00:00		2021-06-30 00:00:00		2021-01-27 00:00:00		2021-01-27 00:00:00		2019-01-16 00:00:00		2019-05-17 00:00:00		2020-01-31 00:00:00		2021-08-02 00:00:00		2022-04-28 00:00:00		2022-05-31 00:00:00		2021-02-11 00:00:00		2021-02-01 00:00:00		2021-09-30 00:00:00		2021-12-13 00:00:00		2022-04-28 00:00:00		2021-05-10 00:00:00		2022-05-16 00:00:00		2022-04-22 00:00:00		2022-05-24 00:00:00		2022-05-04 00:00:00		2022-06-08 00:00:00		2022-04-14 00:00:00		2021-06-22 00:00:00		2021-06-14 00:00:00		2021-09-23 00:00:00		2021-02-01 00:00:00		2022-05-16 00:00:00		2022-05-27 00:00:00		2022-06-06 00:00:00		2022-06-07 00:00:00		2021-12-14 00:00:00		2021-12-21 00:00:00		2022-04-26 00:00:00		2022-03-17 00:00:00		2022-01-04 00:00:00		2022-04-27 00:00:00		2021-01-15 00:00:00		2021-06-29 00:00:00		2022-06-02 00:00:00		2021-08-02 00:00:00		2022-03-23 00:00:00		2022-05-11 00:00:00		2022-04-05 00:00:00		2022-05-23 00:00:00		2022-05-23 00:00:00		2022-07-06 00:00:00		2022-05-23 00:00:00		2022-06-01 00:00:00		2022-04-13 00:00:00		2022-04-18 00:00:00		2021-05-21 00:00:00		2021-09-21 00:00:00		2021-09-27 00:00:00		2022-05-19 00:00:00		2021-12-15 00:00:00		2022-04-25 00:00:00		2022-05-02 00:00:00		2022-03-21 00:00:00		2022-05-10 00:00:00		2022-05-10 00:00:00		2021-07-20 00:00:00		2022-05-06 00:00:00		2022-05-06 00:00:00		2022-05-18 00:00:00		2021-12-29 00:00:00		2021-03-25 00:00:00		2021-06-25 00:00:00		2021-06-30 00:00:00		2022-05-20 00:00:00		2022-05-26 00:00:00		2021-10-20 00:00:00		2022-04-04 00:00:00		2022-08-22 00:00:00		2021-11-09 00:00:00		2021-11-15 00:00:00		2022-04-28 00:00:00		2022-06-01 00:00:00		2022-05-03 00:00:00		2022-09-08 00:00:00		2022-05-13 00:00:00		2022-09-27 00:00:00		2022-09-29 00:00:00		2022-03-07 00:00:00		2022-05-11 00:00:00		2022-06-07 00:00:00		2021-03-10 00:00:00		2021-06-29 00:00:00		2022-09-02 00:00:00		2021-02-01 00:00:00		2021-05-13 00:00:00		2021-01-05 00:00:00		2021-06-18 00:00:00		2022-03-28 00:00:00		2022-03-29 00:00:00		2021-12-27 00:00:00		2022-01-03 00:00:00		2022-06-03 00:00:00		2021-10-05 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2022-01-31 00:00:00		2022-09-12 00:00:00		2021-12-10 00:00:00		2021-12-21 00:00:00		2022-05-05 00:00:00		2022-07-18 00:00:00		2022-05-17 00:00:00		2022-04-07 00:00:00		2021-12-21 00:00:00		2022-01-17 00:00:00		2022-01-07 00:00:00		2022-09-12 00:00:00		2022-09-23 00:00:00		2022-05-27 00:00:00		2022-08-01 00:00:00		2021-03-24 00:00:00		2021-06-24 00:00:00		2022-08-05 00:00:00		2022-08-16 00:00:00		2022-01-31 00:00:00		2022-01-31 00:00:00		2022-05-25 00:00:00		2022-01-25 00:00:00		2021-12-17 00:00:00		2022-10-11 00:00:00		2022-11-03 00:00:00		2022-11-05 00:00:00		2022-10-07 00:00:00		2022-10-18 00:00:00		2022-10-07 00:00:00		2022-10-07 00:00:00		2022-10-13 00:00:00		2022-11-03 00:00:00		2022-11-01 00:00:00		2022-09-30 00:00:00		2022-11-01 00:00:00		2022-10-25 00:00:00		2022-10-07 00:00:00		2022-11-07 00:00:00		2022-10-24 00:00:00		2022-09-30 00:00:00		2022-10-11 00:00:00		2022-10-25 00:00:00		2022-10-24 00:00:00		2022-09-29 00:00:00		2022-09-29 00:00:00		2022-09-29 00:00:00		2022-09-29 00:00:00		2022-10-27 00:00:00		2022-10-05 00:00:00		2022-10-06 00:00:00		2022-10-10 00:00:00		2022-10-12 00:00:00		2022-10-21 00:00:00		2022-10-28 00:00:00		2022-10-04 00:00:00		2022-08-02 00:00:00
stmnt_type		10001		10001		10005		10006		10001		10006		10001		10006		10001		10001		10006		10005		10001		10001		10002		10005		10001		10001		10002		10001		10006		10001		10001		10001		10001		10001		10001		10002		10005		10002		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10002		10006		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10002		10001		10001		10001		10001		10001		10002		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10002		10001		10001		10002		10002		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005
stmnt_status		11001		11001		11001		11001		11003		11001		11003		11001		11001		11003		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11003		11001		11003		11003		11001		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11001		11001		11003		11003		11003		11003		11001		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11003		11003		11001		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		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
session_id		2019		2019		2019		2019		2021		2021		2019		2021		2019		2019		2019		2019		2019		2019		2021		2019		2021		2021		2019		2021		2019		2021		2021		2021		2021		2021		2021		2021		2019		2019		2019		2021		2021		2021		2021		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021
user_id		CSAGABAEN		CPON		CSAGABAEN		TRAMON		CAFILER		IMEDINA		CAFILER		IMEDINA		RGEREMIA		CAFILER		TRAMON		CPON		RGEREMIA		CAFILER		CAFILER		SARRIAGA		RGEREMIA		RGEREMIA		TRAMON		RGEREMIA		JRAMOS		RGEREMIA		CAFILER		CAFILER		RGEREMIA		CAFILER		CAFILER		CAFILER		JFRONEFIELD		TRAMON		SARRIAGA		KRUSSELL		KRUSSELL		RGEREMIA		RGEREMIA		DCODY		RGEREMIA		CAFILER		CAFILER		RGEREMIA		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		RGEREMIA		CAFILER		DCODY		CAFILER		CAFILER		CAFILER		JMAVES		CAFILER		CAFILER		CAFILER		CAFILER		RGEREMIA		CAFILER		CAFILER		CAFILER		CAFILER		KRUSSELL		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		RGEREMIA		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		RGEREMIA		CAFILER		CAFILER		CAFILER		RGEREMIA		RGEREMIA		CAFILER		CAFILER		CAFILER		CAFILER		RGEREMIA		CAFILER		CAFILER		CAFILER		CAFILER		KRUSSELL		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		RGEREMIA		RGEREMIA		RGEREMIA		RGEREMIA		CAFILER		CAFILER		RGEREMIA		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		JMENDOZA		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		RGEREMIA		CAFILER		RGEREMIA		CAFILER		CAFILER		JMAVES		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		JMENDOZA		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		RBURMEISTER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER		RGEREMIA
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		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		11001		11003		11003		11003		11001		11003		11003		11003		11001		11001		11003		11001		11003		11001		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11003		11001		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11001		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		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11001		11001		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		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
rpt_start		2019-01-01 00:00:00		2020-01-01 00:00:00		2019-01-01 00:00:00		None		2021-03-22 00:00:00		None		2019-01-17 00:00:00		None		2019-04-23 00:00:00		2019-04-25 00:00:00		None		2020-01-01 00:00:00		2019-04-30 00:00:00		2020-10-26 00:00:00		2021-01-07 00:00:00		2019-07-01 00:00:00		2021-02-17 00:00:00		2021-03-01 00:00:00		2019-09-10 00:00:00		2021-05-26 00:00:00		2019-07-01 00:00:00		2021-07-02 00:00:00		2021-04-08 00:00:00		2021-08-12 00:00:00		2021-07-02 00:00:00		2021-06-30 00:00:00		2021-01-27 00:00:00		2021-01-21 00:00:00		None		2019-05-17 00:00:00		2019-07-01 00:00:00		2021-01-01 00:00:00		2022-01-01 00:00:00		2022-05-31 00:00:00		2021-02-11 00:00:00		2020-07-01 00:00:00		2021-09-30 00:00:00		2021-12-13 00:00:00		2022-04-28 00:00:00		2021-05-10 00:00:00		2022-05-16 00:00:00		2022-04-22 00:00:00		2022-05-24 00:00:00		2022-05-04 00:00:00		2022-06-08 00:00:00		2022-04-14 00:00:00		2021-06-22 00:00:00		2021-06-14 00:00:00		2021-09-23 00:00:00		2020-07-01 00:00:00		2022-05-16 00:00:00		2022-05-27 00:00:00		2022-04-24 00:00:00		2022-04-24 00:00:00		2021-12-14 00:00:00		2021-12-21 00:00:00		2022-04-26 00:00:00		2022-03-17 00:00:00		2022-01-04 00:00:00		2022-04-27 00:00:00		2021-01-15 00:00:00		2021-06-29 00:00:00		2022-06-02 00:00:00		2021-01-01 00:00:00		2022-03-23 00:00:00		2022-05-11 00:00:00		2022-04-05 00:00:00		2022-05-22 00:00:00		2022-05-23 00:00:00		2022-07-06 00:00:00		2022-05-23 00:00:00		2022-06-01 00:00:00		2022-04-13 00:00:00		2022-04-18 00:00:00		2021-05-21 00:00:00		2021-09-21 00:00:00		2021-09-27 00:00:00		2022-05-19 00:00:00		2021-12-15 00:00:00		2022-04-25 00:00:00		2022-05-02 00:00:00		2022-03-21 00:00:00		2022-05-10 00:00:00		2022-05-10 00:00:00		2021-07-20 00:00:00		2022-05-06 00:00:00		2022-05-06 00:00:00		2022-05-18 00:00:00		2021-12-29 00:00:00		2021-03-25 00:00:00		2021-06-25 00:00:00		2021-06-30 00:00:00		2022-05-20 00:00:00		2022-04-24 00:00:00		2021-10-20 00:00:00		2022-04-04 00:00:00		2022-08-22 00:00:00		2021-11-09 00:00:00		2021-11-15 00:00:00		2022-01-01 00:00:00		2022-06-01 00:00:00		2022-05-03 00:00:00		2022-09-08 00:00:00		2022-05-13 00:00:00		2022-09-27 00:00:00		2022-09-29 00:00:00		2022-03-07 00:00:00		2022-05-11 00:00:00		2022-06-07 00:00:00		2021-03-10 00:00:00		2021-06-29 00:00:00		2022-09-02 00:00:00		2021-02-01 00:00:00		2021-05-13 00:00:00		2021-01-05 00:00:00		2021-06-18 00:00:00		2022-03-28 00:00:00		2022-03-29 00:00:00		2021-12-27 00:00:00		2022-01-03 00:00:00		2022-06-03 00:00:00		2021-10-05 00:00:00		2022-01-01 00:00:00		2022-06-07 00:00:00		2021-07-01 00:00:00		2022-09-12 00:00:00		2021-12-10 00:00:00		2021-12-21 00:00:00		2022-05-05 00:00:00		2022-07-18 00:00:00		2022-05-17 00:00:00		2022-04-07 00:00:00		2021-12-21 00:00:00		2022-01-17 00:00:00		2022-01-07 00:00:00		2022-09-12 00:00:00		2022-09-23 00:00:00		2022-04-24 00:00:00		2022-05-22 00:00:00		2020-07-01 00:00:00		2021-06-24 00:00:00		2022-08-05 00:00:00		2022-08-16 00:00:00		2021-07-01 00:00:00		2022-01-31 00:00:00		2022-05-25 00:00:00		2022-01-25 00:00:00		2021-12-17 00:00:00		2022-10-11 00:00:00		2022-11-03 00:00:00		2022-11-05 00:00:00		2022-10-07 00:00:00		2022-10-18 00:00:00		2022-10-07 00:00:00		2022-10-07 00:00:00		2022-10-13 00:00:00		2022-11-03 00:00:00		2022-11-01 00:00:00		2022-09-30 00:00:00		2022-11-01 00:00:00		2022-10-25 00:00:00		2022-10-07 00:00:00		2022-11-07 00:00:00		2022-10-24 00:00:00		2022-07-01 00:00:00		2022-10-11 00:00:00		2022-10-25 00:00:00		2022-10-24 00:00:00		2022-09-29 00:00:00		2022-04-24 00:00:00		2022-05-22 00:00:00		2022-07-01 00:00:00		2022-09-25 00:00:00		2022-10-05 00:00:00		2022-10-06 00:00:00		2022-10-10 00:00:00		2022-10-12 00:00:00		2022-10-21 00:00:00		2022-10-28 00:00:00		2022-10-04 00:00:00		2022-05-22 00:00:00
rpt_end		2019-06-30 00:00:00		2020-06-30 00:00:00		2019-06-30 00:00:00		None		2021-03-22 00:00:00		None		2019-01-17 00:00:00		None		2019-04-23 00:00:00		2019-04-25 00:00:00		None		2020-06-30 00:00:00		2019-04-30 00:00:00		2020-10-26 00:00:00		2021-01-07 00:00:00		2019-12-31 00:00:00		2021-02-17 00:00:00		2021-03-01 00:00:00		2019-09-10 00:00:00		2021-05-26 00:00:00		2019-12-31 00:00:00		2021-07-02 00:00:00		2021-04-08 00:00:00		2021-08-12 00:00:00		2021-07-02 00:00:00		2021-06-30 00:00:00		2021-01-27 00:00:00		2021-01-21 00:00:00		None		2019-05-17 00:00:00		2019-12-31 00:00:00		2021-06-30 00:00:00		2022-04-23 00:00:00		2022-05-31 00:00:00		2021-02-11 00:00:00		2020-12-31 00:00:00		2021-09-30 00:00:00		2021-12-13 00:00:00		2022-04-28 00:00:00		2021-05-10 00:00:00		2022-05-16 00:00:00		2022-04-22 00:00:00		2022-05-24 00:00:00		2022-05-04 00:00:00		2022-06-08 00:00:00		2022-04-14 00:00:00		2021-06-22 00:00:00		2021-06-14 00:00:00		2021-09-23 00:00:00		2020-12-31 00:00:00		2022-05-16 00:00:00		2022-05-27 00:00:00		2022-05-21 00:00:00		2022-05-21 00:00:00		2021-12-14 00:00:00		2021-12-21 00:00:00		2022-04-26 00:00:00		2022-03-17 00:00:00		2022-01-04 00:00:00		2022-04-27 00:00:00		2021-01-15 00:00:00		2021-06-29 00:00:00		2022-06-02 00:00:00		2021-06-30 00:00:00		2022-03-23 00:00:00		2022-05-11 00:00:00		2022-04-05 00:00:00		2022-05-22 00:00:00		2022-05-23 00:00:00		2022-07-06 00:00:00		2022-05-23 00:00:00		2022-06-01 00:00:00		2022-04-13 00:00:00		2022-04-18 00:00:00		2021-05-21 00:00:00		2021-09-21 00:00:00		2021-09-27 00:00:00		2022-05-19 00:00:00		2021-12-15 00:00:00		2022-04-25 00:00:00		2022-05-02 00:00:00		2022-03-21 00:00:00		2022-05-10 00:00:00		2022-05-10 00:00:00		2021-07-20 00:00:00		2022-05-06 00:00:00		2022-05-06 00:00:00		2022-05-18 00:00:00		2021-12-29 00:00:00		2021-03-25 00:00:00		2021-06-25 00:00:00		2021-06-30 00:00:00		2022-05-20 00:00:00		2022-05-21 00:00:00		2021-10-20 00:00:00		2022-04-04 00:00:00		2022-08-22 00:00:00		2021-11-09 00:00:00		2021-11-15 00:00:00		2022-04-23 00:00:00		2022-06-01 00:00:00		2022-05-03 00:00:00		2022-09-08 00:00:00		2022-05-13 00:00:00		2022-09-27 00:00:00		2022-09-29 00:00:00		2022-03-07 00:00:00		2022-05-11 00:00:00		2022-06-07 00:00:00		2021-03-10 00:00:00		2021-06-29 00:00:00		2022-09-02 00:00:00		2021-02-01 00:00:00		2021-05-13 00:00:00		2021-01-05 00:00:00		2021-06-18 00:00:00		2022-03-28 00:00:00		2022-03-29 00:00:00		2021-12-27 00:00:00		2022-01-03 00:00:00		2022-06-03 00:00:00		2021-10-05 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		2021-12-31 00:00:00		2022-09-12 00:00:00		2021-12-10 00:00:00		2021-12-21 00:00:00		2022-05-05 00:00:00		2022-07-18 00:00:00		2022-05-17 00:00:00		2022-04-07 00:00:00		2021-12-21 00:00:00		2022-01-17 00:00:00		2022-01-07 00:00:00		2022-09-12 00:00:00		2022-09-23 00:00:00		2022-05-21 00:00:00		2022-06-30 00:00:00		2020-12-31 00:00:00		2021-06-24 00:00:00		2022-08-05 00:00:00		2022-08-16 00:00:00		2021-12-31 00:00:00		2022-01-31 00:00:00		2022-05-25 00:00:00		2022-01-25 00:00:00		2021-12-17 00:00:00		2022-10-11 00:00:00		2022-11-03 00:00:00		2022-11-05 00:00:00		2022-10-07 00:00:00		2022-10-18 00:00:00		2022-10-07 00:00:00		2022-10-07 00:00:00		2022-10-13 00:00:00		2022-11-03 00:00:00		2022-11-01 00:00:00		2022-09-30 00:00:00		2022-11-01 00:00:00		2022-10-25 00:00:00		2022-10-07 00:00:00		2022-11-07 00:00:00		2022-10-24 00:00:00		2022-09-24 00:00:00		2022-10-11 00:00:00		2022-10-25 00:00:00		2022-10-24 00:00:00		2022-09-29 00:00:00		2022-05-21 00:00:00		2022-06-30 00:00:00		2022-09-24 00:00:00		2022-10-22 00:00:00		2022-10-05 00:00:00		2022-10-06 00:00:00		2022-10-10 00:00:00		2022-10-12 00:00:00		2022-10-21 00:00:00		2022-10-28 00:00:00		2022-10-04 00:00:00		2022-06-30 00:00:00
rpt_date		2019-07-30 00:00:00		2020-07-31 00:00:00		None		None		2021-03-22 00:00:00		None		None		None		2019-04-23 00:00:00		2019-04-25 00:00:00		None		None		2019-04-30 00:00:00		2020-10-26 00:00:00		None		None		2021-02-17 00:00:00		2021-03-01 00:00:00		None		2021-05-26 00:00:00		None		2021-07-02 00:00:00		2021-04-08 00:00:00		2021-08-12 00:00:00		2021-07-02 00:00:00		2021-06-30 00:00:00		2021-01-27 00:00:00		None		None		None		2020-01-29 00:00:00		2021-07-29 00:00:00		2022-04-28 00:00:00		2022-05-31 00:00:00		2021-02-11 00:00:00		2021-01-30 00:00:00		2021-09-30 00:00:00		2021-12-13 00:00:00		2022-04-28 00:00:00		2021-05-10 00:00:00		2022-05-16 00:00:00		2022-04-22 00:00:00		2022-05-24 00:00:00		2022-05-04 00:00:00		2022-06-08 00:00:00		2022-04-14 00:00:00		2021-06-22 00:00:00		2021-06-14 00:00:00		2021-09-23 00:00:00		None		2022-05-16 00:00:00		2022-05-27 00:00:00		2022-06-03 00:00:00		None		2021-12-14 00:00:00		2021-12-21 00:00:00		2022-04-26 00:00:00		2022-03-17 00:00:00		2022-01-04 00:00:00		2022-04-27 00:00:00		2021-01-15 00:00:00		2021-06-29 00:00:00		2022-06-02 00:00:00		None		2022-03-23 00:00:00		2022-05-11 00:00:00		2022-04-05 00:00:00		2022-05-22 00:00:00		2022-05-23 00:00:00		2022-07-06 00:00:00		2022-05-23 00:00:00		2022-06-01 00:00:00		2022-04-13 00:00:00		2022-04-18 00:00:00		2021-05-21 00:00:00		2021-09-21 00:00:00		2021-09-27 00:00:00		2022-05-19 00:00:00		2021-12-15 00:00:00		2022-04-25 00:00:00		2022-05-02 00:00:00		2022-03-21 00:00:00		2022-05-10 00:00:00		2022-05-10 00:00:00		2021-07-20 00:00:00		2022-05-06 00:00:00		2022-05-06 00:00:00		2022-05-18 00:00:00		2021-12-29 00:00:00		2021-03-25 00:00:00		2021-06-25 00:00:00		2021-06-30 00:00:00		2022-05-20 00:00:00		2022-05-26 00:00:00		2021-10-20 00:00:00		2022-04-04 00:00:00		2022-08-22 00:00:00		2021-11-09 00:00:00		2021-11-15 00:00:00		None		2022-06-01 00:00:00		2022-05-03 00:00:00		2022-09-08 00:00:00		2022-05-13 00:00:00		2022-09-27 00:00:00		2022-09-29 00:00:00		2022-03-07 00:00:00		2022-05-11 00:00:00		2022-06-07 00:00:00		2021-03-10 00:00:00		2021-06-29 00:00:00		2022-09-02 00:00:00		2021-02-01 00:00:00		2021-05-13 00:00:00		2021-01-05 00:00:00		2021-06-18 00:00:00		2022-03-28 00:00:00		2022-03-29 00:00:00		2021-12-27 00:00:00		2022-01-03 00:00:00		2022-06-03 00:00:00		2021-10-05 00:00:00		2022-06-07 00:00:00		2022-06-07 00:00:00		None		2022-09-12 00:00:00		2021-12-10 00:00:00		2021-12-21 00:00:00		2022-05-05 00:00:00		2022-07-18 00:00:00		2022-05-17 00:00:00		2022-04-07 00:00:00		2021-12-21 00:00:00		2022-01-17 00:00:00		2022-01-07 00:00:00		2022-09-12 00:00:00		2022-09-23 00:00:00		None		2022-08-01 00:00:00		2021-02-25 00:00:00		2021-06-24 00:00:00		2022-08-05 00:00:00		2022-08-16 00:00:00		2022-01-31 00:00:00		2022-01-31 00:00:00		2022-05-25 00:00:00		2022-01-25 00:00:00		2021-12-17 00:00:00		2022-10-11 00:00:00		2022-11-03 00:00:00		2022-11-05 00:00:00		2022-10-07 00:00:00		2022-10-18 00:00:00		2022-10-07 00:00:00		2022-10-07 00:00:00		2022-10-13 00:00:00		2022-11-03 00:00:00		2022-11-01 00:00:00		2022-09-30 00:00:00		2022-11-01 00:00:00		2022-10-25 00:00:00		2022-10-07 00:00:00		2022-11-07 00:00:00		2022-10-24 00:00:00		None		2022-10-11 00:00:00		2022-10-25 00:00:00		2022-10-24 00:00:00		2022-09-29 00:00:00		2022-09-29 00:00:00		2022-09-29 00:00:00		2022-09-29 00:00:00		2022-10-27 00:00:00		2022-10-05 00:00:00		2022-10-06 00:00:00		2022-10-10 00:00:00		2022-10-12 00:00:00		2022-10-21 00:00:00		2022-10-28 00:00:00		2022-10-04 00:00:00		None
filing_type		22001		22001		None		None		22001		None		22001		None		22001		22001		None		None		22001		22001		22001		None		22001		22001		22001		22001		None		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		22001		22001		22001		None		22001		22001		22001		None		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		22001		22001		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		22001		22001		22001		22001		22001		22001		22001		None		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		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		None

Table: filer_to_filer_type

filer_id		1415175
filer_type		16
active		Y
race		0
session_id		2019
category		40002
category_type		40502
sub_category		0
effect_dt		2019-01-16 00:00:00
sub_category_type		0
election_type		0
sub_category_a		None
nyq_dt		2019-01-01 00:00:00
party_cd		16001
county_cd		18026
district_cd		0

Table: filer_xref

filer_id		1415175
xref_id		1415175
effect_dt		2019-01-16 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175
filer_id		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175
filer_type		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE
status		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE
effect_dt		2019-01-16 00:00:00		2019-01-16 00:00:00		2019-01-16 00:00:00		2019-01-16 00:00:00		2019-01-16 00:00:00		2019-01-16 00:00:00		2019-01-16 00:00:00		2019-01-16 00:00:00
naml		LARA FOR INSURANCE COMMISSIONER 2022; RICARDO		LARA FOR INSURANCE COMMISSIONER 2022; RICARDO		LARA FOR INSURANCE COMMISSIONER 2022; RICARDO		LARA FOR INSURANCE COMMISSIONER 2022; RICARDO		LARA FOR INSURANCE COMMISSIONER 2022; RICARDO		LARA FOR INSURANCE COMMISSIONER 2022; RICARDO		LARA FOR INSURANCE COMMISSIONER 2022; RICARDO		LARA FOR INSURANCE COMMISSIONER 2022; RICARDO
namf		None		None		None		None		None		None		None		None
namt		None		None		None		None		None		None		None		None
nams		None		None		None		None		None		None		None		None
adr1		None		None		None		None		None		None		None		None
adr2		None		None		None		None		None		None		None		None
city		LONG BEACH		SACRAMENTO		LONG BEACH		SACRAMENTO		LONG BEACH		SACRAMENTO		SACRAMENTO		SACRAMENTO
st		CA		CA		CA		CA		CA		CA		CA		CA
zip4		90807		95814		90802		95814		90802		95814		95841		95814
phon		9164422952		None		9164422952		9164422952		9164422952		9164422952		9163489100		9163489100
fax		9164421280		None		9164421280		9164421280		9164421280		9164421280		9163489111		9163489111
email		[email protected]		None		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]		[email protected]

Table: filers

filer_id		1415175

Table: received_filings

filer_id		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175		1415175
filing_file_name		2376384_0.cal		2377135_0.cal		2380326_0.cal		2588098_0.cal		2688835_0.cal		2589994_0.cal		2669398_0.cal		2692381_0.cal		2613395_0.cal		2568442_0.cal		2671057_0.cal		510962.cal		2750159_0.cal		2687917_0.cal		2738288_0.cal		2663340_0.cal		2719267_0.cal		2672239_0.cal		2590200_0.cal		2557344_0.cal		2590703_0.cal		2685204_0.cal		2696726_0.cal		2731695_0.cal		2724024_0.cal		2659879_0.cal		2589768_0.cal		2670418_0.cal		2553353_0.cal		2753169_0.cal		2585046_0.cal		2679812_0.cal		2679900_0.cal		2740370_0.cal		2751845_0.cal		2684261_0.cal		2569744_0.cal		2730961_0.cal		2678930_0.cal		2627636_0.cal		2628465_0.cal		2682552_0.cal		2632240_0.cal		2548121_0.cal		2698770_0.cal		2711482_0.cal		2745177_0.cal		2729972_0.cal		2729976_0.cal		2612665_0.cal		2613937_0.cal		2631893_0.cal		2730227_0.cal		2632634_0.cal		2732859_0.cal		2583976_0.cal		71578.cal		2589134_0.cal		2590651_0.cal		2606404_0.cal		163903.cal		2631532_0.cal		2633315_0.cal		73435.cal		2589660_0.cal		2524144_0.cal		2735383_0.cal		2709512_0.cal		2590101_0.cal		2683810_1.cal		2727111_0.cal		2729077_1.cal		2544517_0.cal		2564606_0.cal		2682821_0.cal		2685672_0.cal		2692756_0.cal		2561443_0.cal		2612320_0.cal		2612895_0.cal		2630768_0.cal		2673782_0.cal		2573009_0.cal		2722875_0.cal		2679309_0.cal		2630955_0.cal		2750550_0.cal		2631533_0.cal		94881.cal		2683076_0.cal		2658258_0.cal		2558152_0.cal		2632673_0.cal		2719006_0.cal		2725445_0.cal		163909.cal		2752687_0.cal		2681528_0.cal		2685259_0.cal		2690405_0.cal		2631022_0.cal		2659070_0.cal		106775.cal		2689530_0.cal		2681155_0.cal		2681156_0.cal		2683810_0.cal		2667253_0.cal		237529.cal		2685203_0.cal		2666092_0.cal		2677345_0.cal		2751835_0.cal		2718351_0.cal		2583392_0.cal		2662858_0.cal		511026.cal		2725806_0.cal		2729077_0.cal		2729468_0.cal		2730234_0.cal		2617330_0.cal		2684534_0.cal		2689557_0.cal		2713237_0.cal		2716911_0.cal		2660929_0.cal		232405.cal		232279.cal		2661466_0.cal		2655470_0.cal		2681524_0.cal		2739569_0.cal		2691086_0.cal		2679720_0.cal		2630605_0.cal		2631563_0.cal		2634808_0.cal		2683475_0.cal		2692360_0.cal		2585711_0.cal		2542474_0.cal		510815.cal		2728510_0.cal		2664186_0.cal		2588731_0.cal		2730704_0.cal		2731049_0.cal		2594508_0.cal		2631259_0.cal		2589973_0.cal		2645032_0.cal
received_date		2019-04-23 00:00:00		2019-04-25 00:00:00		2019-04-30 00:00:00		2021-06-14 00:00:00		2022-05-31 00:00:00		2021-06-29 00:00:00		2022-04-22 00:00:00		2022-06-07 00:00:00		2021-09-30 00:00:00		2021-03-22 00:00:00		2022-04-26 00:00:00		2022-04-05 00:00:00		2022-11-01 00:00:00		2022-05-27 00:00:00		2022-10-21 00:00:00		2022-04-05 00:00:00		2022-09-12 00:00:00		2022-04-27 00:00:00		2021-06-30 00:00:00		2021-02-11 00:00:00		2021-07-02 00:00:00		2022-05-23 00:00:00		2022-07-06 00:00:00		2022-10-12 00:00:00		2022-09-27 00:00:00		2022-03-23 00:00:00		2021-06-25 00:00:00		2022-04-25 00:00:00		2021-02-01 00:00:00		2022-11-07 00:00:00		2021-05-21 00:00:00		2022-05-06 00:00:00		2022-05-06 00:00:00		2022-10-25 00:00:00		2022-11-03 00:00:00		2022-05-19 00:00:00		2021-03-25 00:00:00		2022-10-11 00:00:00		2022-05-03 00:00:00		2021-11-09 00:00:00		2021-11-15 00:00:00		2022-05-13 00:00:00		2021-12-29 00:00:00		2021-01-27 00:00:00		2022-07-18 00:00:00		2022-08-16 00:00:00		2022-10-28 00:00:00		2022-10-07 00:00:00		2022-10-07 00:00:00		2021-09-23 00:00:00		2021-10-05 00:00:00		2021-12-27 00:00:00		2022-10-07 00:00:00		2022-01-03 00:00:00		2022-10-13 00:00:00		2021-05-13 00:00:00		2022-06-01 00:00:00		2021-06-22 00:00:00		2021-07-02 00:00:00		2021-08-12 00:00:00		2022-04-14 00:00:00		2021-12-21 00:00:00		2022-01-07 00:00:00		2022-06-01 00:00:00		2021-06-24 00:00:00		2020-10-27 00:00:00		2022-10-18 00:00:00		2022-08-05 00:00:00		2021-06-30 00:00:00		2022-05-25 00:00:00		2022-09-30 00:00:00		2022-10-25 00:00:00		2021-01-15 00:00:00		2021-03-10 00:00:00		2022-05-16 00:00:00		2022-05-24 00:00:00		2022-06-08 00:00:00		2021-03-01 00:00:00		2021-09-21 00:00:00		2021-09-27 00:00:00		2021-12-13 00:00:00		2022-04-28 00:00:00		2021-04-08 00:00:00		2022-09-23 00:00:00		2022-05-04 00:00:00		2021-12-14 00:00:00		2022-11-01 00:00:00		2021-12-21 00:00:00		2022-05-16 00:00:00		2022-05-16 00:00:00		2022-03-17 00:00:00		2021-02-17 00:00:00		2022-01-04 00:00:00		2022-09-12 00:00:00		2022-09-29 00:00:00		2022-04-14 00:00:00		2022-11-05 00:00:00		2022-05-11 00:00:00		2022-05-23 00:00:00		2022-06-02 00:00:00		2021-12-15 00:00:00		2022-03-21 00:00:00		2022-03-21 00:00:00		2022-06-01 00:00:00		2022-05-10 00:00:00		2022-05-10 00:00:00		2022-05-18 00:00:00		2022-04-18 00:00:00		2022-04-18 00:00:00		2022-05-23 00:00:00		2022-04-13 00:00:00		2022-05-02 00:00:00		2022-11-03 00:00:00		2022-09-08 00:00:00		2021-05-10 00:00:00		2022-04-04 00:00:00		2022-04-05 00:00:00		2022-09-29 00:00:00		2022-10-05 00:00:00		2022-10-06 00:00:00		2022-10-07 00:00:00		2021-10-20 00:00:00		2022-05-20 00:00:00		2022-06-01 00:00:00		2022-08-22 00:00:00		2022-09-02 00:00:00		2022-03-28 00:00:00		2022-03-28 00:00:00		2022-03-28 00:00:00		2022-03-29 00:00:00		2022-03-07 00:00:00		2022-05-11 00:00:00		2022-10-24 00:00:00		2022-06-03 00:00:00		2022-05-05 00:00:00		2021-12-10 00:00:00		2021-12-21 00:00:00		2022-01-17 00:00:00		2022-05-17 00:00:00		2022-06-07 00:00:00		2021-05-27 00:00:00		2021-01-05 00:00:00		2022-04-05 00:00:00		2022-10-04 00:00:00		2022-04-07 00:00:00		2021-06-18 00:00:00		2022-10-10 00:00:00		2022-10-11 00:00:00		2021-07-20 00:00:00		2021-12-17 00:00:00		2021-06-29 00:00:00		2022-01-31 00:00:00
filing_directory		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal
filing_id		2376384		2377135		2380326		2588098		2688835		2589994		2669398		2692381		2613395		2568442		2671057		None		2750159		2687917		2738288		2663340		2719267		2672239		2590200		2557344		2590703		2685204		2696726		2731695		2724024		2659879		2589768		2670418		2553353		2753169		2585046		2679812		2679900		2740370		2751845		2684261		2569744		2730961		2678930		2627636		2628465		2682552		2632240		2548121		2698770		2711482		2745177		2729972		2729976		2612665		2613937		2631893		2730227		2632634		2732859		2583976		None		2589134		2590651		2606404		None		2631532		2633315		None		2589660		2524144		2735383		2709512		2590101		2683810		2727111		2729077		2544517		2564606		2682821		2685672		2692756		2561443		2612320		2612895		2630768		2673782		2573009		2722875		2679309		2630955		2750550		2631533		None		2683076		2658258		2558152		2632673		2719006		2725445		None		2752687		2681528		2685259		2690405		2631022		2659070		None		2689530		2681155		2681156		2683810		2667253		None		2685203		2666092		2677345		2751835		2718351		2583392		2662858		None		2725806		2729077		2729468		2730234		2617330		2684534		2689557		2713237		2716911		2660929		None		None		2661466		2655470		2681524		2739569		2691086		2679720		2630605		2631563		2634808		2683475		2692360		2585711		2542474		None		2728510		2664186		2588731		2730704		2731049		2594508		2631259		2589973		2645032
form_id		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		None		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		None		F497		F497		F497		None		F497		F497		None		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		None		F497		F497		F497		F497		F497		F497		None		F497		F497		F497		F497		F497		F497		None		F497		F497		F497		F497		F497		None		F497		F497		F497		F497		F497		F497		F497		None		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		None		None		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		None		F497		F497		F497		F497		F497		F497		F497		F497		F497
receive_comment		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted