| filing_id | 1450589 | 1504201 | 1483075 | 1461696 | 1569197 | 1539061 | 1621039 | 1604108 | 1588927 | 1589537 | 1631598 | 1677416 | 1709191 | 1654919 | 1734666 | 1800803 | 1782275 | 1764956 | 1817617 | 1868183 | 1843171 | 1911311 | 1979921 | 1966044 | 1934107 | 1996701 | 2061934 | 2060388 | 2036289 | 2012167 | 2102400 | 2172618 | 2154845 | 2124306 | 2190077 | 2268876 | 2234502 | 2201908 | 2377908 | 2334489 | 2318216 | 2382032 | ||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| amend_id | 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 | ||||||||||||||||||||||||||||||||||||||||||
| rec_type | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | ||||||||||||||||||||||||||||||||||||||||||
| form_type | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | ||||||||||||||||||||||||||||||||||||||||||
| sender_id | E24676 | E24676 | E24676 | E24676 | E24676 | E24676 | E21961 | E21961 | E24676 | E21961 | E21961 | E21961 | E21961 | E21961 | E21961 | E21961 | E21961 | E21961 | E21961 | E21961 | E21961 | E21961 | E21961 | E21961 | E21961 | E21961 | 1232273 | E21961 | E21961 | E21961 | 1232273 | 1232273 | 1232273 | 1232273 | 1232273 | 1232273 | 1232273 | 1232273 | 1232273 | 1232273 | 1232273 | 1232273 | ||||||||||||||||||||||||||||||||||||||||||
| filer_id | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | ||||||||||||||||||||||||||||||||||||||||||
| entity_cd | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | ||||||||||||||||||||||||||||||||||||||||||
| filer_naml | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | ||||||||||||||||||||||||||||||||||||||||||
| filer_namf | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | ||||||||||||||||||||||||||||||||||||||||||
| filer_namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||
| filer_nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||
| report_num | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 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 | ||||||||||||||||||||||||||||||||||||||||||
| rpt_date | 2009-10-23 00:00:00 | 2010-07-27 00:00:00 | 2010-04-20 00:00:00 | 2010-01-24 00:00:00 | 2011-01-26 00:00:00 | 2010-10-27 00:00:00 | 2011-10-18 00:00:00 | 2011-07-21 00:00:00 | 2011-04-01 00:00:00 | 2011-04-26 00:00:00 | 2012-01-19 00:00:00 | 2012-07-24 00:00:00 | 2012-10-30 00:00:00 | 2012-04-23 00:00:00 | 2013-01-28 00:00:00 | 2013-10-24 00:00:00 | 2013-07-26 00:00:00 | 2013-04-26 00:00:00 | 2014-01-31 00:00:00 | 2014-07-23 00:00:00 | 2014-04-25 00:00:00 | 2014-10-28 00:00:00 | 2015-07-24 00:00:00 | 2015-04-30 00:00:00 | 2015-01-28 00:00:00 | 2015-10-29 00:00:00 | 2016-07-31 00:00:00 | 2016-07-25 00:00:00 | 2016-04-29 00:00:00 | 2016-02-01 00:00:00 | 2016-10-31 00:00:00 | 2017-07-31 00:00:00 | 2017-04-30 00:00:00 | 2017-01-31 00:00:00 | 2017-10-23 00:00:00 | 2018-07-19 00:00:00 | 2018-04-10 00:00:00 | 2018-01-11 00:00:00 | 2019-04-17 00:00:00 | 2019-01-11 00:00:00 | 2018-10-10 00:00:00 | 2019-04-25 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||
| from_date | 2009-07-20 00:00:00 | 2010-04-01 00:00:00 | 2010-01-01 00:00:00 | 2009-10-01 00:00:00 | 2010-10-01 00:00:00 | 2010-07-01 00:00:00 | 2011-07-01 00:00:00 | 2011-04-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-07 00:00:00 | 2011-10-01 00:00:00 | 2012-04-01 00:00:00 | 2012-07-01 00:00:00 | 2012-01-01 00:00:00 | 2012-10-01 00:00:00 | 2013-07-01 00:00:00 | 2013-04-01 00:00:00 | 2013-01-01 00:00:00 | 2013-10-01 00:00:00 | 2014-04-01 00:00:00 | 2014-01-01 00:00:00 | 2014-07-01 00:00:00 | 2015-04-01 00:00:00 | 2015-01-01 00:00:00 | 2014-10-01 00:00:00 | 2015-07-01 00:00:00 | 2016-06-06 00:00:00 | 2016-04-01 00:00:00 | 2016-01-01 00:00:00 | 2015-10-01 00:00:00 | 2016-07-01 00:00:00 | 2017-04-01 00:00:00 | 2017-01-01 00:00:00 | 2016-10-01 00:00:00 | 2017-07-01 00:00:00 | 2018-04-01 00:00:00 | 2018-01-01 00:00:00 | 2017-10-01 00:00:00 | 2019-01-01 00:00:00 | 2018-10-01 00:00:00 | 2018-07-01 00:00:00 | 2019-04-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||
| thru_date | 2009-09-30 00:00:00 | 2010-06-30 00:00:00 | 2010-03-31 00:00:00 | 2009-12-31 00:00:00 | 2010-12-31 00:00:00 | 2010-09-30 00:00:00 | 2011-09-30 00:00:00 | 2011-06-30 00:00:00 | 2011-01-28 00:00:00 | 2011-03-31 00:00:00 | 2011-12-31 00:00:00 | 2012-06-30 00:00:00 | 2012-09-30 00:00:00 | 2012-03-31 00:00:00 | 2012-12-31 00:00:00 | 2013-09-30 00:00:00 | 2013-06-30 00:00:00 | 2013-03-31 00:00:00 | 2013-12-31 00:00:00 | 2014-06-30 00:00:00 | 2014-03-31 00:00:00 | 2014-09-30 00:00:00 | 2015-06-30 00:00:00 | 2015-03-31 00:00:00 | 2014-12-31 00:00:00 | 2015-09-30 00:00:00 | 2016-06-30 00:00:00 | 2016-06-05 00:00:00 | 2016-03-31 00:00:00 | 2015-12-31 00:00:00 | 2016-09-30 00:00:00 | 2017-06-30 00:00:00 | 2017-03-31 00:00:00 | 2016-12-31 00:00:00 | 2017-09-30 00:00:00 | 2018-06-30 00:00:00 | 2018-03-31 00:00:00 | 2017-12-31 00:00:00 | 2019-03-31 00:00:00 | 2018-12-31 00:00:00 | 2018-09-30 00:00:00 | 2019-04-05 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||
| cum_beg_dt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||
| firm_id | E24676 | E24676 | E24676 | E24676 | E24676 | E24676 | E21961 | E21961 | E24676 | E21961 | E21961 | E21961 | E21961 | E21961 | E21961 | E21961 | E21961 | E21961 | E21961 | E21961 | E21961 | E21961 | E21961 | E21961 | E21961 | E21961 | 1232273 | E21961 | E21961 | E21961 | 1232273 | 1232273 | 1232273 | 1232273 | 1232273 | 1232273 | 1232273 | 1232273 | 1232273 | 1232273 | 1232273 | 1232273 | ||||||||||||||||||||||||||||||||||||||||||
| firm_name | BLUE SHIELD OF CALIFORNIA | BLUE SHIELD OF CALIFORNIA | BLUE SHIELD OF CALIFORNIA | BLUE SHIELD OF CALIFORNIA | BLUE SHIELD OF CALIFORNIA | BLUE SHIELD OF CALIFORNIA | PERSONAL INSURANCE FEDERATION OF CALIFORNIA | PERSONAL INSURANCE FEDERATION OF CALIFORNIA | BLUE SHIELD OF CALIFORNIA | PERSONAL INSURANCE FEDERATION OF CALIFORNIA | PERSONAL INSURANCE FEDERATION OF CALIFORNIA | PERSONAL INSURANCE FEDERATION OF CALIFORNIA | PERSONAL INSURANCE FEDERATION OF CALIFORNIA | PERSONAL INSURANCE FEDERATION OF CALIFORNIA | PERSONAL INSURANCE FEDERATION OF CALIFORNIA | PERSONAL INSURANCE FEDERATION OF CALIFORNIA | PERSONAL INSURANCE FEDERATION OF CALIFORNIA | PERSONAL INSURANCE FEDERATION OF CALIFORNIA | PERSONAL INSURANCE FEDERATION OF CALIFORNIA | PERSONAL INSURANCE FEDERATION OF CALIFORNIA | PERSONAL INSURANCE FEDERATION OF CALIFORNIA | PERSONAL INSURANCE FEDERATION OF CALIFORNIA | PERSONAL INSURANCE FEDERATION OF CALIFORNIA | PERSONAL INSURANCE FEDERATION OF CALIFORNIA | PERSONAL INSURANCE FEDERATION OF CALIFORNIA | PERSONAL INSURANCE FEDERATION OF CALIFORNIA | CHUBB-NORTH AMERICA | PERSONAL INSURANCE FEDERATION OF CALIFORNIA | PERSONAL INSURANCE FEDERATION OF CALIFORNIA | PERSONAL INSURANCE FEDERATION OF CALIFORNIA | CHUBB-NORTH AMERICA | CHUBB-NORTH AMERICA | CHUBB-NORTH AMERICA | CHUBB-NORTH AMERICA | CHUBB-NORTH AMERICA | CHUBB-NORTH AMERICA | CHUBB-NORTH AMERICA | CHUBB-NORTH AMERICA | CHUBB-NORTH AMERICA | CHUBB-NORTH AMERICA | CHUBB-NORTH AMERICA | CHUBB-NORTH AMERICA | ||||||||||||||||||||||||||||||||||||||||||
| firm_city | 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 | PHILADELPHIA | SACRAMENTO | SACRAMENTO | SACRAMENTO | PHILADELPHIA | PHILADELPHIA | PHILADELPHIA | PHILADELPHIA | PHILADELPHIA | PHILADELPHIA | PHILADELPHIA | PHILADELPHIA | LOS ANGELES | LOS ANGELES | SACRAMENTO | LOS ANGELES | ||||||||||||||||||||||||||||||||||||||||||
| firm_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 | PA | CA | CA | CA | PA | PA | PA | PA | PA | PA | PA | PA | CA | CA | CA | CA | ||||||||||||||||||||||||||||||||||||||||||
| firm_zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 19106 | 95814 | 95814 | 95814 | 19106 | 19106 | 19106 | 19106 | 19106 | 19106 | 19106 | 19106 | 90012 | 90012 | 95819 | 90012 | ||||||||||||||||||||||||||||||||||||||||||
| firm_phon | 916 552-2961 | 916 552-2961 | 916 552-2961 | 916 552-2961 | 916 552-2961 | 916 552-2961 | (916) 442-6646 | (916) 442-6646 | 916 552-2961 | (916) 442-6646 | (916) 442-6646 | (916) 442-6646 | (916) 442-6646 | (916) 442-6646 | (916) 442-6646 | (916) 442-6646 | (916) 442-6646 | (916) 442-6646 | (916) 442-6646 | (916) 442-6646 | (916) 442-6646 | (916) 442-6646 | (916) 442-6646 | (916) 442-6646 | (916) 442-6646 | (916) 442-6646 | None | (916) 442-6646 | (916) 442-6646 | (916) 442-6646 | None | None | None | None | None | None | None | None | 213 833-5204 | 213 833-5204 | 916 224-2789 | 213 833-5204 | ||||||||||||||||||||||||||||||||||||||||||
| mail_city | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||
| mail_st | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||
| mail_zip4 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||
| mail_phon | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||
| sig_date | 2009-10-23 00:00:00 | 2010-07-27 00:00:00 | 2010-04-20 00:00:00 | 2010-01-24 00:00:00 | 2011-01-26 00:00:00 | 2010-10-27 00:00:00 | 2011-10-18 00:00:00 | 2011-07-21 00:00:00 | 2011-04-01 00:00:00 | 2011-04-26 00:00:00 | 2012-01-19 00:00:00 | 2012-07-24 00:00:00 | 2012-10-30 00:00:00 | 2012-04-23 00:00:00 | 2013-01-28 00:00:00 | 2013-10-24 00:00:00 | 2013-07-26 00:00:00 | 2013-04-26 00:00:00 | 2014-01-31 00:00:00 | 2014-07-23 00:00:00 | 2014-04-25 00:00:00 | 2014-10-28 00:00:00 | 2015-07-24 00:00:00 | 2015-04-30 00:00:00 | 2015-01-28 00:00:00 | 2015-10-29 00:00:00 | 2016-07-28 00:00:00 | 2016-07-25 00:00:00 | 2016-04-29 00:00:00 | 2016-02-01 00:00:00 | 2016-10-27 00:00:00 | 2017-07-26 00:00:00 | 2017-04-22 00:00:00 | 2017-01-24 00:00:00 | 2017-10-23 00:00:00 | 2018-07-19 00:00:00 | 2018-04-10 00:00:00 | 2018-01-11 00:00:00 | 2019-04-17 00:00:00 | 2019-01-11 00:00:00 | 2018-10-10 00:00:00 | 2019-04-25 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||
| sig_loc | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | LOS ANGELES, CA | LOS ANGELES, CA | SACRAMENTO, CA | LOS ANGELES, CA | ||||||||||||||||||||||||||||||||||||||||||
| sig_naml | PLATIN (427600 SLC) | PLATIN (427600 SLC) | PLATIN (427600 SLC) | PLATIN (427600 SLC) | PLATIN (427600 SLC) | PLATIN (427600 SLC) | PLATIN 428200SB | PLATIN 428200SB | PLATIN (427600 SLC) | PLATIN 428200SB | PLATIN 428200SB | PLATIN 428200SB | PLATIN 428200SB | PLATIN 428200SB | PLATIN 428200SB | PLATIN 428200SB | PLATIN 428200SB | PLATIN 428200SB | PLATIN 428200SB | PLATIN 428200SB | PLATIN 428200SB | PLATIN 428200SB | PLATIN 428200SB | PLATIN 428200SB | PLATIN 428200SB | PLATIN 428200SB | MORALES | PLATIN 428200SB | PLATIN 428200SB | PLATIN 428200SB | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | ||||||||||||||||||||||||||||||||||||||||||
| sig_namf | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO PLATIN | MANOLO | MANOLO | MANOLO | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | ||||||||||||||||||||||||||||||||||||||||||
| sig_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 | ||||||||||||||||||||||||||||||||||||||||||
| sig_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 | ||||||||||||||||||||||||||||||||||||||||||
| prn_naml | PLATIN (427600 SLC) | PLATIN (427600 SLC) | PLATIN (427600 SLC) | PLATIN (427600 SLC) | PLATIN (427600 SLC) | PLATIN (427600 SLC) | PLATIN 428200SB | PLATIN 428200SB | PLATIN (427600 SLC) | PLATIN 428200SB | PLATIN 428200SB | PLATIN 428200SB | PLATIN 428200SB | PLATIN 428200SB | PLATIN 428200SB | PLATIN 428200SB | PLATIN 428200SB | PLATIN 428200SB | PLATIN 428200SB | PLATIN 428200SB | PLATIN 428200SB | PLATIN 428200SB | PLATIN 428200SB | PLATIN 428200SB | PLATIN 428200SB | PLATIN 428200SB | MORALES | PLATIN 428200SB | PLATIN 428200SB | PLATIN 428200SB | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | ||||||||||||||||||||||||||||||||||||||||||
| prn_namf | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO PLATIN | MANOLO | MANOLO | MANOLO | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | ||||||||||||||||||||||||||||||||||||||||||
| prn_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 | ||||||||||||||||||||||||||||||||||||||||||
| prn_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 | ||||||||||||||||||||||||||||||||||||||||||
| sig_title | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||
| nopart1_cb | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | ||||||||||||||||||||||||||||||||||||||||||
| nopart2_cb | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | ||||||||||||||||||||||||||||||||||||||||||
| part1_1_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 | ||||||||||||||||||||||||||||||||||||||||||
| part1_2_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 | ||||||||||||||||||||||||||||||||||||||||||
| ctrib_n_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 | ||||||||||||||||||||||||||||||||||||||||||
| ctrib_y_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 | ||||||||||||||||||||||||||||||||||||||||||
| lby_actvty | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||
| lobby_n_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 | ||||||||||||||||||||||||||||||||||||||||||
| lobby_y_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 | ||||||||||||||||||||||||||||||||||||||||||
| major_naml | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||
| major_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 | ||||||||||||||||||||||||||||||||||||||||||
| major_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 | ||||||||||||||||||||||||||||||||||||||||||
| major_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 | ||||||||||||||||||||||||||||||||||||||||||
| rcpcmte_nm | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||
| rcpcmte_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 |
| filing_id | 1442752 | 1558602 | 1578152 | 1578152 | 1718835 | 1718835 | 1918275 | 1918275 | 1918275 | 2051574 | 2119306 | 2119306 | 2327681 | 2371496 | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| amend_id | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 2 | 0 | 0 | 1 | 0 | 0 | ||||||||||||||
| rec_type | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | ||||||||||||||
| form_type | F604 | F604 | F604 | F604 | F604 | F604 | F604 | F604 | F604 | F604 | F604 | F604 | F604 | F606 | ||||||||||||||
| sender_id | E24676 | E24676 | E21961 | E21961 | E21961 | E21961 | E21961 | E21961 | E21961 | 1232273 | 1232273 | 1232273 | 1232273 | 1320384 | ||||||||||||||
| filer_id | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | ||||||||||||||
| entity_cd | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | ||||||||||||||
| filer_naml | PLATIN | PLATIN P | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | ||||||||||||||
| filer_namf | MANOLO | MANOLO | MANOLO P. | MANOLO P. | MANOLO P. | MANOLO P. | MANOLO P. | MANOLO P. | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | ||||||||||||||
| filer_namt | 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 | ||||||||||||||
| report_num | 000 | 000 | 000 | 001 | 000 | 001 | 000 | 001 | 002 | 000 | 000 | 001 | 000 | 000 | ||||||||||||||
| rpt_date | 2009-08-04 00:00:00 | 2010-12-06 00:00:00 | 2011-02-22 00:00:00 | 2011-04-21 00:00:00 | 2012-12-18 00:00:00 | 2013-01-28 00:00:00 | 2014-12-15 00:00:00 | 2015-01-22 00:00:00 | 2015-08-26 00:00:00 | 2016-06-07 00:00:00 | 2016-12-20 00:00:00 | 2017-04-22 00:00:00 | 2018-11-08 00:00:00 | 2019-04-04 00:00:00 | ||||||||||||||
| ls_beg_yr | 2009 | 2011 | 2011 | 2011 | 2013 | 2013 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2019 | 2019 | ||||||||||||||
| ls_end_yr | 2010 | 2012 | 2012 | 2012 | 2014 | 2014 | 2016 | 2016 | 2016 | 2016 | 2018 | 2018 | 2020 | 2020 | ||||||||||||||
| qual_date | 2009-07-20 00:00:00 | 2011-01-01 00:00:00 | None | None | None | None | None | None | None | 2016-06-06 00:00:00 | None | None | None | None | ||||||||||||||
| eff_date | None | None | None | None | None | None | None | None | None | None | None | None | None | 2019-03-31 00:00:00 | ||||||||||||||
| bus_city | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | LOS ANGELES | SACRAMENTO | ||||||||||||||
| bus_st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | ||||||||||||||
| bus_zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95819 | 95819 | 95819 | 90012 | 95819 | ||||||||||||||
| bus_phon | 916 552-2961 | 916 552-2961 | 916 442-6646 | 916 442-6646 | 916 442-6646 | 916 442-6646 | 916 442-6646 | 916 442-6646 | 916 442-6646 | (916) 224-2789 | (916) 224-2789 | (916) 224-2789 | (916) 224-2789 | 916 224-2789 | ||||||||||||||
| bus_fax | 916 552-2925 | 916 552-2925 | None | None | None | None | 916 446-9548 | 916 446-9548 | 916 446-9548 | None | None | None | None | None | ||||||||||||||
| bus_email | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
| mail_city | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
| mail_st | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
| mail_zip4 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
| mail_phon | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
| sig_date | 2009-08-04 00:00:00 | 2010-12-06 00:00:00 | 2011-02-17 00:00:00 | 2011-04-21 00:00:00 | 2012-12-18 00:00:00 | 2013-01-28 00:00:00 | 2014-12-15 00:00:00 | 2015-01-22 00:00:00 | 2015-08-26 00:00:00 | 2016-06-07 00:00:00 | 2016-12-20 00:00:00 | 2017-04-22 00:00:00 | 2018-11-08 00:00:00 | 2019-04-04 00:00:00 | ||||||||||||||
| sig_loc | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | SACRAMENTO, CA | ||||||||||||||
| sig_naml | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | MORALES | MORALES | MORALES | MORALES | MORALES | ||||||||||||||
| sig_namf | MANOLO | MANOLO | MANOLO P. | MANOLO P. | MANOLO P. | MANOLO P. | MANOLO P. | MANOLO P. | MANOLO P. | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO | ||||||||||||||
| sig_namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
| sig_nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
| prn_naml | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | MORALES | MORALES | MORALES | MORALES | MORALES | ||||||||||||||
| prn_namf | MANOLO | MANOLO | MANOLO P. | MANOLO P. | MANOLO P. | MANOLO P. | MANOLO P. | MANOLO P. | MANOLO P. | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO | ||||||||||||||
| prn_namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
| prn_nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
| sig_title | SENIOR GOVERNMENT AFFAIRS (4276 slc) | SENIOR GOVERNMENT AFFAIRS (4276 slc) | Lobbyist 428200 | Lobbyist 428200 | Lobbyist 428200 | Lobbyist 428200 | Lobbyist 428200 | Lobbyist 428200 | Lobbyist 428200 | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | ||||||||||||||
| stmt_firm | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
| ind_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
| bus_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
| trade_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
| oth_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
| a_b_name | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
| a_b_city | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
| a_b_st | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
| a_b_zip4 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
| descrip_1 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
| descrip_2 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
| c_less50 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
| c_more50 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
| ind_class | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
| ind_descr | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
| bus_class | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
| bus_descr | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
| auth_name | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
| auth_city | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
| auth_st | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
| auth_zip4 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
| lobby_int | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
| influen_yn | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
| firm_name | Blue Shield of California | Blue Shield of California | PERSONAL INSURANCE FEDERATION OF CALIFORNIA | PERSONAL INSURANCE FEDERATION OF CALIFORNIA | PERSONAL INSURANCE FEDERATION OF CALIFORNIA | PERSONAL INSURANCE FEDERATION OF CALIFORNIA | PERSONAL INSURANCE FEDERATION OF CALIFORNIA | PERSONAL INSURANCE FEDERATION OF CALIFORNIA | PERSONAL INSURANCE FEDERATION OF CALIFORNIA | CHUBB-NORTH AMERICA | CHUBB-NORTH AMERICA | CHUBB-NORTH AMERICA | CHUBB-NORTH AMERICA | CHUBB-NORTH AMERICA | ||||||||||||||
| newcert_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
| rencert_cb | None | X | X | None | X | None | X | None | None | None | X | None | X | None | ||||||||||||||
| complet_dt | 2009-08-11 00:00:00 | None | None | 2011-04-21 00:00:00 | None | 2013-01-24 00:00:00 | None | 2015-01-22 00:00:00 | 2015-01-22 00:00:00 | 2015-01-22 00:00:00 | None | 2017-04-20 00:00:00 | None | None | ||||||||||||||
| lby_reg_cb | X | X | X | X | X | X | X | X | X | X | X | X | X | None | ||||||||||||||
| lby_604_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
| st_leg_yn | Y | Y | N | N | N | N | N | N | N | Y | Y | Y | Y | None | ||||||||||||||
| st_agency | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
| lobby_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
| l_firm_cb | None | None | None | None | None | None | None | None | None | None | None | None | None | None |
| filer_id | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| adrid | 2171883 | 2203131 | 2212477 | 2411340 | 2401039 | 2466129 | 2255456 | 2337698 | ||||||||
| effect_dt | 2009-07-20 00:00:00 | 2011-01-01 00:00:00 | 2011-02-07 00:00:00 | 2017-01-01 00:00:00 | 2016-06-06 00:00:00 | 2019-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-01-01 00:00:00 | ||||||||
| add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | ||||||||
| session_id | 2009 | 2011 | 2011 | 2017 | 2015 | 2019 | 2013 | 2015 |
| filer_id | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | |||||
|---|---|---|---|---|---|---|---|---|---|---|
| session_id | 2009 | 2011 | 2013 | 2015 | 2017 | |||||
| ethics_date | 2009-08-11 00:00:00 | 2011-04-21 00:00:00 | 2013-01-24 00:00:00 | 2015-01-22 00:00:00 | 2017-06-22 00:00:00 |
| filer_id | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filing_id | 1782275 | 1979921 | 1800803 | 1918275 | 1911311 | 1442715 | 1442717 | 1442752 | 1450589 | 1461696 | 1483075 | 1504201 | 1539061 | 1559712 | 1558602 | 1579824 | 1578152 | 1578152 | 1593341 | 1569197 | 1589537 | 1604108 | 1621039 | 1594387 | 1588927 | 1631598 | 1654919 | 1677416 | 1817617 | 1934107 | 1934325 | 1918275 | 1921279 | 1718835 | 1709191 | 1868183 | 1724207 | 1734666 | 1718835 | 1843171 | 1759205 | 1764956 | 1989378 | 1996701 | 1966044 | 1918275 | 2377908 | 2327681 | 2268876 | 2012167 | 2036289 | 2061934 | 2052634 | 2060388 | 2051574 | 2102400 | 2119306 | 2121719 | 2124306 | 2119306 | 2154845 | 2160764 | 2164139 | 2172618 | 2234502 | 2190077 | 2371496 | 2382032 | 2334489 | 2406945 | 2318216 | 2338580 | 2201908 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| period_id | 214 | 222 | 215 | 221 | 219 | None | None | 199 | 199 | 200 | 201 | 202 | 203 | None | 204 | None | 205 | 206 | None | 204 | 205 | 206 | 207 | None | 205 | 208 | 209 | 210 | 216 | 220 | None | 220 | None | 212 | 211 | 218 | None | 212 | 213 | 217 | None | 213 | None | 223 | 221 | 223 | 237 | 236 | 234 | 224 | 225 | 226 | None | 226 | 226 | 227 | 228 | None | 228 | 230 | 229 | None | None | 230 | 233 | 231 | 238 | 238 | 236 | None | 235 | None | 232 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| form_id | F615 | F615 | F615 | F604 | F615 | F604 | F999 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F604 | F604 | F604 | F605 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F604 | F604 | F615 | F615 | F604 | F615 | F604 | F615 | F604 | F615 | F604 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F604 | F604 | F615 | F604 | F615 | F604 | F604 | F615 | F615 | F615 | F606 | F615 | F615 | F606 | F615 | F604 | F615 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filing_sequence | 0 | 0 | 0 | 1 | 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 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filing_date | 2013-07-31 00:00:00 | 2015-07-30 00:00:00 | 2013-10-31 00:00:00 | 2015-02-19 00:00:00 | 2014-10-31 00:00:00 | 2009-08-14 00:00:00 | 2009-08-14 00:00:00 | 2009-08-17 00:00:00 | 2009-10-28 00:00:00 | 2010-01-27 00:00:00 | 2010-04-27 00:00:00 | 2010-07-28 00:00:00 | 2010-10-29 00:00:00 | 2011-01-11 00:00:00 | 2011-01-11 00:00:00 | 2011-02-22 00:00:00 | 2011-02-22 00:00:00 | 2011-06-20 00:00:00 | 2011-04-21 00:00:00 | 2011-01-28 00:00:00 | 2011-04-28 00:00:00 | 2011-07-27 00:00:00 | 2011-10-28 00:00:00 | 2011-04-21 00:00:00 | 2011-04-27 00:00:00 | 2012-01-25 00:00:00 | 2012-04-26 00:00:00 | 2012-07-30 00:00:00 | 2014-01-31 00:00:00 | 2015-01-30 00:00:00 | 2015-01-22 00:00:00 | 2014-12-15 00:00:00 | 2014-12-15 00:00:00 | 2012-12-20 00:00:00 | 2012-10-31 00:00:00 | 2014-07-29 00:00:00 | 2012-12-27 00:00:00 | 2013-01-29 00:00:00 | 2013-01-30 00:00:00 | 2014-04-29 00:00:00 | 2013-01-31 00:00:00 | 2013-04-30 00:00:00 | 2015-09-02 00:00:00 | 2015-10-30 00:00:00 | 2015-04-30 00:00:00 | 2015-08-31 00:00:00 | 2019-04-26 00:00:00 | 2018-12-10 00:00:00 | 2018-07-25 00:00:00 | 2016-02-01 00:00:00 | 2016-04-29 00:00:00 | 2016-07-29 00:00:00 | 2016-06-15 00:00:00 | 2016-07-28 00:00:00 | 2016-06-15 00:00:00 | 2016-10-31 00:00:00 | 2017-01-12 00:00:00 | 2017-01-13 00:00:00 | 2017-01-26 00:00:00 | 2017-04-27 00:00:00 | 2017-04-27 00:00:00 | 2017-04-27 00:00:00 | 2017-06-22 00:00:00 | 2017-07-27 00:00:00 | 2018-04-24 00:00:00 | 2017-10-24 00:00:00 | 2019-04-09 00:00:00 | 2019-04-30 00:00:00 | 2019-01-15 00:00:00 | 2019-04-09 00:00:00 | 2018-10-31 00:00:00 | 2018-12-11 00:00:00 | 2018-01-15 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| stmnt_type | 10001 | 10001 | 10001 | 10002 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10002 | 10002 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10006 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10001 | 10002 | 10001 | 10006 | 10001 | 10006 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10002 | 10001 | 10006 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| session_id | 2013 | 2015 | 2013 | 2015 | 2013 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2013 | 2015 | 2015 | 2015 | 2013 | 2011 | 2013 | 2013 | 2011 | 2013 | 2013 | 2013 | 2013 | 2015 | 2015 | 2015 | 2015 | 2019 | 2019 | 2017 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2017 | 2019 | 2017 | 2019 | 2017 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| user_id | AGLADNEY | JINGRAM | AGLADNEY | YRODRIGU | AGLADNEY | YRODRIGU | YRODRIGU | YRODRIGU | MGUERRA | WBROWN | JINGRAM | ASAETERN | AGLADNEY | CPON | YRODRIGU | CFLAGG | YRODRIGU | YRODRIGU | MPACHECO | AGLADNEY | JINGRAM | ASAETERN | ASAETERN | CFLAGG | JINGRAM | ASAETERN | ASAETERN | AGLADNEY | ASAETERN | AGLADNEY | ASAETERN | YRODRIGU | GKURIMOT | GKURIMOT | ASAETERN | AGLADNEY | GKURIMOT | ASAETERN | SARRIAGA | AGLADNEY | SARRIAGA | ASAETERN | YRODRIGU | JINGRAM | JINGRAM | YRODRIGU | SUSHAKOV | PBANFORD | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | YRODRIGU | AGLADNEY | YRODRIGU | AGLADNEY | YRODRIGU | YRODRIGU | AGLADNEY | YRODRIGU | SMCCONNAN | YRODRIGU | PBANFORD | SMCCONNAN | AGLADNEY | SMCCONNAN | GPEREZ | SUSHAKOV | AGLADNEY | GPEREZ | JFRONEFIELD | PBANFORD | AGLADNEY | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| special_audit | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| fine_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| rpt_start | 2013-04-01 00:00:00 | 2015-04-01 00:00:00 | 2013-07-01 00:00:00 | 2015-01-22 00:00:00 | 2014-07-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2009-08-04 00:00:00 | 2009-07-20 00:00:00 | 2009-10-01 00:00:00 | 2010-01-01 00:00:00 | 2010-04-01 00:00:00 | 2010-07-01 00:00:00 | 1900-01-01 00:00:00 | 2010-12-06 00:00:00 | 1900-01-01 00:00:00 | 2011-02-22 00:00:00 | 2011-04-21 00:00:00 | 1900-01-01 00:00:00 | 2010-10-01 00:00:00 | 2011-02-07 00:00:00 | 2011-04-01 00:00:00 | 2011-07-01 00:00:00 | 1900-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-10-01 00:00:00 | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 2013-10-01 00:00:00 | 2014-10-01 00:00:00 | None | 2014-12-15 00:00:00 | 1900-01-01 00:00:00 | 2012-12-18 00:00:00 | 2012-07-01 00:00:00 | 2014-04-01 00:00:00 | 1900-01-01 00:00:00 | 2012-10-01 00:00:00 | 2013-01-28 00:00:00 | 2014-01-01 00:00:00 | 1900-01-01 00:00:00 | 2013-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-07-01 00:00:00 | 2015-01-01 00:00:00 | 2015-08-26 00:00:00 | 2019-01-01 00:00:00 | 2018-11-08 00:00:00 | 2018-04-01 00:00:00 | 2015-10-01 00:00:00 | 2016-01-01 00:00:00 | 2016-06-06 00:00:00 | 1900-01-01 00:00:00 | 2016-04-01 00:00:00 | 2016-06-07 00:00:00 | 2016-07-01 00:00:00 | 2016-12-20 00:00:00 | 1900-01-01 00:00:00 | 2016-10-01 00:00:00 | 2017-04-22 00:00:00 | 2017-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-04-01 00:00:00 | 2018-01-01 00:00:00 | 2017-07-01 00:00:00 | 2019-04-04 00:00:00 | 2019-04-01 00:00:00 | 2018-10-01 00:00:00 | 1900-01-01 00:00:00 | 2018-07-01 00:00:00 | 1900-01-01 00:00:00 | 2017-10-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| rpt_end | 2013-06-30 00:00:00 | 2015-06-30 00:00:00 | 2013-09-30 00:00:00 | 2015-01-22 00:00:00 | 2014-09-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2009-08-04 00:00:00 | 2009-09-30 00:00:00 | 2009-12-31 00:00:00 | 2010-03-31 00:00:00 | 2010-06-30 00:00:00 | 2010-09-30 00:00:00 | 1900-01-01 00:00:00 | 2010-12-06 00:00:00 | 1900-01-01 00:00:00 | 2011-02-22 00:00:00 | 2011-04-21 00:00:00 | 1900-01-01 00:00:00 | 2010-12-31 00:00:00 | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 1900-01-01 00:00:00 | 2011-01-28 00:00:00 | 2011-12-31 00:00:00 | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 2013-12-31 00:00:00 | 2014-12-31 00:00:00 | None | 2014-12-15 00:00:00 | 1900-01-01 00:00:00 | 2012-12-18 00:00:00 | 2012-09-30 00:00:00 | 2014-06-30 00:00:00 | 1900-01-01 00:00:00 | 2012-12-31 00:00:00 | 2013-01-28 00:00:00 | 2014-03-31 00:00:00 | 1900-01-01 00:00:00 | 2013-03-31 00:00:00 | 1900-01-01 00:00:00 | 2015-09-30 00:00:00 | 2015-03-31 00:00:00 | 2015-08-26 00:00:00 | 2019-03-31 00:00:00 | 2018-11-08 00:00:00 | 2018-06-30 00:00:00 | 2015-12-31 00:00:00 | 2016-03-31 00:00:00 | 2016-06-30 00:00:00 | 1900-01-01 00:00:00 | 2016-06-05 00:00:00 | 2016-06-07 00:00:00 | 2016-09-30 00:00:00 | 2016-12-20 00:00:00 | 1900-01-01 00:00:00 | 2016-12-31 00:00:00 | 2017-04-22 00:00:00 | 2017-03-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-06-30 00:00:00 | 2018-03-31 00:00:00 | 2017-09-30 00:00:00 | 2019-04-04 00:00:00 | 2019-04-05 00:00:00 | 2018-12-31 00:00:00 | 1900-01-01 00:00:00 | 2018-09-30 00:00:00 | 1900-01-01 00:00:00 | 2017-12-31 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| rpt_date | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filing_type | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | None | 22001 |
| filer_id | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filer_type | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |||||||||
| active | Y | Y | Y | T | Y | Y | T | Y | Y | |||||||||
| race | None | None | None | None | 0 | None | None | None | None | |||||||||
| session_id | 2011 | 2013 | 2011 | 2011 | 2009 | 2015 | 2019 | 2019 | 2017 | |||||||||
| category | None | None | None | None | 0 | None | None | None | None | |||||||||
| category_type | None | None | None | None | 0 | None | None | None | None | |||||||||
| sub_category | None | None | None | None | 0 | None | None | None | None | |||||||||
| effect_dt | 2011-02-07 00:00:00 | 2013-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-28 00:00:00 | 2009-07-20 00:00:00 | 2015-01-01 00:00:00 | 2019-04-05 00:00:00 | 2019-01-01 00:00:00 | 2017-01-01 00:00:00 | |||||||||
| sub_category_type | None | None | None | None | 0 | None | None | None | None | |||||||||
| election_type | None | None | None | None | 0 | None | None | None | None | |||||||||
| sub_category_a | None | None | None | None | None | None | None | None | None | |||||||||
| nyq_dt | None | None | None | None | None | None | None | None | None | |||||||||
| party_cd | None | None | None | None | 0 | None | None | None | None | |||||||||
| county_cd | None | None | None | None | 0 | None | None | None | None | |||||||||
| district_cd | None | None | None | None | 0 | None | None | None | None |
| filer_id | 1320384 | |
|---|---|---|
| xref_id | 1320384 | |
| effect_dt | 2009-08-14 00:00:00 | |
| migration_source | CLAIMS |
| xref_filer_id | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filer_id | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| filer_type | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| status | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| effect_dt | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| naml | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | MORALES | PLATIN MORALES | PLATIN MORALES | PLATIN MORALES | PLATIN MORALES | PLATIN MORALES | PLATIN MORALES | PLATIN MORALES | PLATIN MORALES | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | PLATIN | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| namf | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO PLATIN | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO P. | MANOLO P. | MANOLO P. | MANOLO P. | MANOLO P. | MANOLO P. | MANOLO P. | MANOLO P. | MANOLO P. | MANOLO P. | MANOLO P. | MANOLO P. | MANOLO P. | MANOLO P. | MANOLO P. | MANOLO P. | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | MANOLO | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| adr1 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| adr2 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| city | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | LOS ANGELES | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | LOS ANGELES | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | LOS ANGELES | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | LOS ANGELES | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | LOS ANGELES | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | LOS ANGELES | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | LOS ANGELES | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | LOS ANGELES | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95819 | 95819 | 90012 | 95814 | 95814 | 95814 | 95814 | 95814 | 95819 | 95819 | 90012 | 95814 | 95814 | 95814 | 95814 | 95814 | 95819 | 95819 | 90012 | 95814 | 95814 | 95814 | 95814 | 95814 | 95819 | 95819 | 90012 | 95814 | 95814 | 95814 | 95814 | 95814 | 95819 | 95819 | 90012 | 95814 | 95814 | 95814 | 95814 | 95814 | 95819 | 95819 | 90012 | 95814 | 95814 | 95814 | 95814 | 95814 | 95819 | 95819 | 90012 | 95814 | 95814 | 95814 | 95814 | 95814 | 95819 | 95819 | 90012 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| phon | 9165522961 | 9165522961 | 9164426646 | 9164426646 | 9164426646 | 9162242789 | 9162242789 | 9162242789 | 9165522961 | 9165522961 | 9164426646 | 9164426646 | 9164426646 | 9162242789 | 9162242789 | 9162242789 | 9165522961 | 9165522961 | 9164426646 | 9164426646 | 9164426646 | 9162242789 | 9162242789 | 9162242789 | 9165522961 | 9165522961 | 9164426646 | 9164426646 | 9164426646 | 9162242789 | 9162242789 | 9162242789 | 9165522961 | 9165522961 | 9164426646 | 9164426646 | 9164426646 | 9162242789 | 9162242789 | 9162242789 | 9165522961 | 9165522961 | 9164426646 | 9164426646 | 9164426646 | 9162242789 | 9162242789 | 9162242789 | 9165522961 | 9165522961 | 9164426646 | 9164426646 | 9164426646 | 9162242789 | 9162242789 | 9162242789 | 9165522961 | 9165522961 | 9164426646 | 9164426646 | 9164426646 | 9162242789 | 9162242789 | 9162242789 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| fax | 9165522925 | 9165522925 | 9164469548 | 9164469548 | 9165522925 | 9165522925 | 9164469548 | 9164469548 | 9165522925 | 9165522925 | 9164469548 | 9164469548 | 9165522925 | 9165522925 | 9164469548 | 9164469548 | 9165522925 | 9165522925 | 9164469548 | 9164469548 | 9165522925 | 9165522925 | 9164469548 | 9164469548 | 9165522925 | 9165522925 | 9164469548 | 9164469548 | 9165522925 | 9165522925 | 9164469548 | 9164469548 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| None | None | None | None | [email protected] | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | [email protected] | None | None | None |
| filer_id | 1320384 |
|---|
| filer_id | 1320384 | 1320384 | 1320384 | 1320384 | ||||
|---|---|---|---|---|---|---|---|---|
| change_no | 0 | 1 | 2 | 3 | ||||
| session_id | 2009 | 2015 | 2019 | 2019 | ||||
| log_dt | 2009-08-14 00:00:00 | 2015-09-02 00:00:00 | 2019-04-09 00:00:00 | 2019-04-09 00:00:00 | ||||
| filer_type | 4 | 4 | 4 | 4 | ||||
| correction_flg | Y | Y | None | None | ||||
| action | ADDED | CHANGED | DELETED | TERMINATED | ||||
| attribute_changed | EMPLOYER | NAME FROM | EMPLOYER | |||||
| ethics_dt | None | None | None | None | ||||
| interests | None | None | None | None | ||||
| filer_full_name | PLATIN, MANOLO | PLATIN MORALES, MANOLO | MANOLO PLATIN MORALES | MORALES, MANOLO PLATIN | ||||
| filer_city | None | None | None | None | ||||
| filer_st | None | None | None | None | ||||
| filer_zip | None | None | None | None | ||||
| filer_phone | None | None | None | None | ||||
| entity_type | 2 | 4 | 2 | 4 | ||||
| entity_name | BLUE SHIELD OF CALIFORNIA | PLATIN, MANOLO | CHUBB-NORTH AMERICA | None | ||||
| entity_city | None | None | None | None | ||||
| entity_st | None | None | None | None | ||||
| entity_zip | None | None | None | None | ||||
| entity_phone | None | None | None | None | ||||
| entity_id | 1147130 | 0 | 1232273 | 0 | ||||
| responsible_officer | None | None | None | None | ||||
| effect_dt | 2009-07-20 00:00:00 | 2015-08-04 00:00:00 | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 |
| filer_id | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | 1320384 | ||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filing_file_name | 1504201_0.cal | 1461696_0.cal | 1450589_0.cal | 1442752_0.cal | 1483075_0.cal | 1843171_0.cal | 1734666_0.cal | 1718835_1.cal | 1677416_0.cal | 1782275_0.cal | 1800803_0.cal | 1539061_0.cal | 1588927_0.cal | 1569197_0.cal | 1578152_0.cal | 1558602_0.cal | 1817617_0.cal | 1631598_0.cal | 1621039_0.cal | 1578152_1.cal | 1604108_0.cal | 1589537_0.cal | 1764956_0.cal | 1709191_0.cal | 1718835_0.cal | 1654919_0.cal | 1868183_0.cal | 1918275_2.cal | 1966044_0.cal | 2119306_1.cal | 2060388_0.cal | 2051574_0.cal | 1996701_0.cal | 2012167_0.cal | 2119306_0.cal | 1918275_1.cal | 1918275_0.cal | 1911311_0.cal | 2036289_0.cal | 1934107_0.cal | 1979921_0.cal | 2371496_0.cal | 2327681_0.cal | 2382032_0.cal | 96786.cal | 2377908_0.cal | 2318216_0.cal | 2334489_0.cal | ||||||||||||||||||||||||||||||||||||||||||||||||
| received_date | 2010-07-28 00:00:00 | 2010-01-27 00:00:00 | 2009-10-28 00:00:00 | 2009-08-17 00:00:00 | 2010-04-27 00:00:00 | 2014-04-29 00:00:00 | 2013-01-29 00:00:00 | 2013-01-30 00:00:00 | 2012-07-30 00:00:00 | 2013-07-31 00:00:00 | 2013-10-31 00:00:00 | 2010-10-29 00:00:00 | 2011-04-27 00:00:00 | 2011-01-28 00:00:00 | 2011-02-22 00:00:00 | 2011-01-11 00:00:00 | 2014-01-31 00:00:00 | 2012-01-25 00:00:00 | 2011-10-28 00:00:00 | 2011-06-20 00:00:00 | 2011-07-27 00:00:00 | 2011-04-28 00:00:00 | 2013-04-30 00:00:00 | 2012-10-31 00:00:00 | 2012-12-20 00:00:00 | 2012-04-26 00:00:00 | 2014-07-29 00:00:00 | 2015-08-31 00:00:00 | 2015-04-30 00:00:00 | 2017-04-27 00:00:00 | 2016-07-28 00:00:00 | 2016-06-15 00:00:00 | 2015-10-30 00:00:00 | 2016-02-01 00:00:00 | 2017-01-12 00:00:00 | 2015-02-19 00:00:00 | 2014-12-15 00:00:00 | 2014-10-31 00:00:00 | 2016-04-29 00:00:00 | 2015-01-30 00:00:00 | 2015-07-30 00:00:00 | 2019-04-09 00:00:00 | 2018-12-10 00:00:00 | 2019-04-30 00:00:00 | 2019-04-09 00:00:00 | 2019-04-26 00:00:00 | 2018-10-31 00:00:00 | 2019-01-15 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||
| filing_directory | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /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 | ||||||||||||||||||||||||||||||||||||||||||||||||
| filing_id | 1504201 | 1461696 | 1450589 | 1442752 | 1483075 | 1843171 | 1734666 | 1718835 | 1677416 | 1782275 | 1800803 | 1539061 | 1588927 | 1569197 | 1578152 | 1558602 | 1817617 | 1631598 | 1621039 | 1578152 | 1604108 | 1589537 | 1764956 | 1709191 | 1718835 | 1654919 | 1868183 | 1918275 | 1966044 | 2119306 | 2060388 | 2051574 | 1996701 | 2012167 | 2119306 | 1918275 | 1918275 | 1911311 | 2036289 | 1934107 | 1979921 | 2371496 | 2327681 | 2382032 | None | 2377908 | 2318216 | 2334489 | ||||||||||||||||||||||||||||||||||||||||||||||||
| form_id | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F615 | F604 | F615 | F604 | F615 | F615 | F604 | F604 | F604 | F615 | F615 | F615 | F615 | F606 | F604 | F615 | None | F615 | F615 | F615 | ||||||||||||||||||||||||||||||||||||||||||||||||
| receive_comment | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | 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 |