filing_id | 855970 | 884038 | 912510 | 931993 | 931993 | 931993 | 948039 | 969546 | 989032 | 1011634 | 1032735 | 1059676 | 1081915 | 1168197 | 1134359 | 1105864 | 1105878 | 1148953 | 1105864 | 1262572 | 1192225 | 1239135 | 1217012 | 1285635 | 1329892 | 1312050 | 1347638 | 1298056 | 1450599 | 1377440 | 1435362 | 1398531 | 1418471 | 1526843 | 1501734 | 1479489 | 1465294 | 1618495 | 1600194 | 1585798 | 1572213 | 1632415 | 1672348 | 1699698 | 1651438 | 1734435 | 1795364 | 1777557 | 1757634 | 1810423 | 1908829 | 1863698 | 1838930 | 1991481 | 1975912 | 1934374 | 1959069 | 2035531 | 2056262 | 2008150 | 2100628 | 2167481 | 2151179 | 2130464 | 2190722 | 2267392 | 2211471 | 2306524 | 2239977 | 2378037 | 2334126 | 2391289 | 2414110 | 2437104 | 2466234 | 2531641 | 2552335 | 2487970 | 2615394 | 2636793 | 2577962 | 2593953 | 2668201 | 2738618 | 2700129 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 0 | 0 | 0 | 2 | 1 | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | F615 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sender_id | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E01076 | E22327 | E01076 | E22327 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_id | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | LBY | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_naml | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | Orozco | OROZCO | Orozco | OROZCO | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_namf | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_namt | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | Mr. | None | Mr. | None | Mr. | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
report_num | 000 | 000 | 000 | 000 | 002 | 001 | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | 2002-07-31 00:00:00 | 2002-10-30 00:00:00 | 2003-01-31 00:00:00 | 2003-04-30 00:00:00 | 2003-08-29 00:00:00 | 2003-08-15 00:00:00 | 2003-07-31 00:00:00 | 2003-10-31 00:00:00 | 2004-01-30 00:00:00 | 2004-04-27 00:00:00 | 2004-08-02 00:00:00 | 2004-11-01 00:00:00 | 2005-01-31 00:00:00 | 2006-05-01 00:00:00 | 2005-10-31 00:00:00 | 2005-05-03 00:00:00 | 2005-05-03 00:00:00 | 2006-01-31 00:00:00 | 2006-12-08 00:00:00 | 2007-04-30 00:00:00 | 2006-07-31 00:00:00 | 2007-01-31 00:00:00 | 2006-10-31 00:00:00 | 2007-07-31 00:00:00 | 2008-04-30 00:00:00 | 2008-01-31 00:00:00 | 2008-07-29 00:00:00 | 2007-10-31 00:00:00 | 2009-10-23 00:00:00 | 2008-10-30 00:00:00 | 2009-07-16 00:00:00 | 2009-02-02 00:00:00 | 2009-04-15 00:00:00 | 2010-11-01 00:00:00 | 2010-07-30 00:00:00 | 2010-04-09 00:00:00 | 2010-01-14 00:00:00 | 2011-10-30 00:00:00 | 2011-07-31 00:00:00 | 2011-05-02 00:00:00 | 2011-01-31 00:00:00 | 2012-01-31 00:00:00 | 2012-07-31 00:00:00 | 2012-10-31 00:00:00 | 2012-04-30 00:00:00 | 2013-01-31 00:00:00 | 2013-09-30 00:00:00 | 2013-07-31 00:00:00 | 2013-04-30 00:00:00 | 2014-01-31 00:00:00 | 2014-10-31 00:00:00 | 2014-07-31 00:00:00 | 2014-04-30 00:00:00 | 2015-10-31 00:00:00 | 2015-07-31 00:00:00 | 2015-01-31 00:00:00 | 2015-03-31 00:00:00 | 2016-04-30 00:00:00 | 2016-06-30 00:00:00 | 2016-01-31 00:00:00 | 2016-09-30 00:00:00 | 2017-07-10 00:00:00 | 2017-04-10 00:00:00 | 2017-01-31 00:00:00 | 2017-10-10 00:00:00 | 2018-07-10 00:00:00 | 2018-01-10 00:00:00 | 2018-10-10 00:00:00 | 2018-04-10 00:00:00 | 2019-04-10 00:00:00 | 2019-01-10 00:00:00 | 2019-07-10 00:00:00 | 2019-10-10 00:00:00 | 2020-01-10 00:00:00 | 2020-04-10 00:00:00 | 2020-10-10 00:00:00 | 2021-01-10 00:00:00 | 2020-07-10 00:00:00 | 2021-10-12 00:00:00 | 2022-01-12 00:00:00 | 2021-04-10 00:00:00 | 2021-07-12 00:00:00 | 2022-04-12 00:00:00 | 2022-10-20 00:00:00 | 2022-07-20 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
from_date | 2002-04-01 00:00:00 | 2002-07-01 00:00:00 | 2002-10-01 00:00:00 | 2003-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-04-01 00:00:00 | 2003-07-01 00:00:00 | 2003-10-01 00:00:00 | 2004-01-01 00:00:00 | 2004-04-01 00:00:00 | 2004-07-01 00:00:00 | 2004-10-01 00:00:00 | 2006-01-01 00:00:00 | 2005-07-01 00:00:00 | 2005-04-01 00:00:00 | 2005-01-01 00:00:00 | 2005-10-01 00:00:00 | 2005-04-01 00:00:00 | 2007-01-01 00:00:00 | 2006-04-01 00:00:00 | 2006-10-01 00:00:00 | 2006-07-01 00:00:00 | 2007-04-01 00:00:00 | 2008-01-01 00:00:00 | 2007-10-01 00:00:00 | 2008-04-01 00:00:00 | 2007-07-01 00:00:00 | 2009-07-01 00:00:00 | 2008-07-01 00:00:00 | 2009-04-01 00:00:00 | 2008-10-01 00:00:00 | 2009-01-01 00:00:00 | 2010-07-01 00:00:00 | 2010-04-01 00:00:00 | 2010-01-01 00:00:00 | 2009-10-01 00:00:00 | 2011-07-01 00:00:00 | 2011-04-01 00:00:00 | 2011-01-01 00:00:00 | 2010-10-01 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-07-01 00:00:00 | 2014-04-01 00:00:00 | 2014-01-01 00:00:00 | 2015-07-01 00:00:00 | 2015-04-01 00:00:00 | 2014-10-01 00:00:00 | 2015-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-04-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 | 2017-10-01 00:00:00 | 2018-07-01 00:00:00 | 2018-01-01 00:00:00 | 2019-01-01 00:00:00 | 2018-10-01 00:00:00 | 2019-04-01 00:00:00 | 2019-07-01 00:00:00 | 2019-10-01 00:00:00 | 2020-01-01 00:00:00 | 2020-07-01 00:00:00 | 2020-10-01 00:00:00 | 2020-04-01 00:00:00 | 2021-07-01 00:00:00 | 2021-10-01 00:00:00 | 2021-01-01 00:00:00 | 2021-04-01 00:00:00 | 2022-01-01 00:00:00 | 2022-07-01 00:00:00 | 2022-04-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
thru_date | 2002-06-30 00:00:00 | 2002-09-30 00:00:00 | 2002-12-31 00:00:00 | 2003-03-31 00:00:00 | 2003-03-31 00:00:00 | 2003-03-31 00:00:00 | 2003-06-30 00:00:00 | 2003-09-30 00:00:00 | 2003-12-31 00:00:00 | 2004-03-31 00:00:00 | 2004-06-30 00:00:00 | 2004-09-30 00:00:00 | 2004-12-31 00:00:00 | 2006-03-31 00:00:00 | 2005-09-30 00:00:00 | 2005-06-30 00:00:00 | 2005-03-31 00:00:00 | 2005-12-31 00:00:00 | 2005-06-30 00:00:00 | 2007-03-31 00:00:00 | 2006-06-30 00:00:00 | 2006-12-31 00:00:00 | 2006-09-30 00:00:00 | 2007-06-30 00:00:00 | 2008-03-31 00:00:00 | 2007-12-31 00:00:00 | 2008-06-30 00:00:00 | 2007-09-30 00:00:00 | 2009-09-30 00:00:00 | 2008-09-30 00:00:00 | 2009-06-30 00:00:00 | 2008-12-31 00:00:00 | 2009-03-31 00:00:00 | 2010-09-30 00:00:00 | 2010-06-30 00:00:00 | 2010-03-31 00:00:00 | 2009-12-31 00:00:00 | 2011-09-30 00:00:00 | 2011-06-30 00:00:00 | 2011-03-31 00:00:00 | 2010-12-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-09-30 00:00:00 | 2014-06-30 00:00:00 | 2014-03-31 00:00:00 | 2015-09-30 00:00:00 | 2015-06-30 00:00:00 | 2014-12-31 00:00:00 | 2015-03-31 00:00:00 | 2016-03-31 00:00:00 | 2016-06-30 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 | 2017-12-31 00:00:00 | 2018-09-30 00:00:00 | 2018-03-31 00:00:00 | 2019-03-31 00:00:00 | 2018-12-31 00:00:00 | 2019-06-30 00:00:00 | 2019-09-30 00:00:00 | 2019-12-31 00:00:00 | 2020-03-31 00:00:00 | 2020-09-30 00:00:00 | 2020-12-31 00:00:00 | 2020-06-30 00:00:00 | 2021-09-30 00:00:00 | 2021-12-31 00:00:00 | 2021-03-31 00:00:00 | 2021-06-30 00:00:00 | 2022-03-31 00:00:00 | 2022-09-30 00:00:00 | 2022-06-30 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
cum_beg_dt | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2005-01-01 00:00:00 | 2005-01-01 00:00:00 | 2005-01-01 00:00:00 | 2005-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2005-01-01 00:00:00 | 2005-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-01-01 00:00:00 | None | 2007-01-01 00:00:00 | None | 2007-01-01 00:00:00 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_id | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E22327 | E01076 | E22327 | E01076 | E22327 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_name | SEMPRA ENERGY AND ITS SUBSIDIARIES: San Diego Gas & Electric, Southern California Gas Co. | SEMPRA ENERGY AND ITS SUBSIDIARIES: San Diego Gas & Electric, Southern California Gas Co. | SEMPRA ENERGY AND ITS SUBSIDIARIES: San Diego Gas & Electric, Southern California Gas Co. | SEMPRA ENERGY AND ITS AFFILIATES: San Diego Gas & Electric, Southern California Gas Co., and Sempra Energy Global Enterprises | SEMPRA ENERGY AND ITS AFFILIATES: San Diego Gas & Electric, Southern California Gas Co., and Sempra Energy Global Enterprises | SEMPRA ENERGY AND ITS AFFILIATES: San Diego Gas & Electric, Southern California Gas Co., and Sempra Energy Global Enterprises | SEMPRA ENERGY AND ITS AFFILIATES: San Diego Gas & Electric, Southern California Gas Co., and Sempra Energy Global Enterprises | SEMPRA ENERGY AND ITS AFFILIATES: San Diego Gas & Electric, Southern California Gas Co., and Sempra Energy Global Enterprises | SEMPRA ENERGY AND ITS AFFILIATES: San Diego Gas & Electric, Southern California Gas Co., and Sempra Energy Global Enterprises | SEMPRA ENERGY AND ITS AFFILIATES: San Diego Gas & Electric, Southern California Gas Co., and Sempra Energy Global Enterprises | SEMPRA ENERGY AND ITS AFFILIATES: San Diego Gas & Electric, Southern California Gas Co., and Sempra Energy Global Enterprises | SEMPRA ENERGY AND ITS AFFILIATES: San Diego Gas & Electric, Southern California Gas Co., and Sempra Energy Global Enterprises | SEMPRA ENERGY AND ITS AFFILIATES: San Diego Gas & Electric, Southern California Gas Co., and Sempra Energy Global Enterprises | SEMPRA ENERGY AND ITS AFFILIATES: San Diego Gas & Electric, Southern California Gas Co., and Sempra Energy Global Enterprises | SEMPRA ENERGY AND ITS AFFILIATES: San Diego Gas & Electric, Southern California Gas Co., and Sempra Energy Global Enterprises | SEMPRA ENERGY AND ITS AFFILIATES: San Diego Gas & Electric, Southern California Gas Co., and Sempra Energy Global Enterprises | SEMPRA ENERGY AND ITS AFFILIATES: San Diego Gas & Electric, Southern California Gas Co., and Sempra Energy Global Enterprises | SEMPRA ENERGY AND ITS AFFILIATES: San Diego Gas & Electric, Southern California Gas Co., and Sempra Energy Global Enterprises | SEMPRA ENERGY AND ITS AFFILIATES: San Diego Gas & Electric, Southern California Gas Co., and Sempra Energy Global Enterprises | SEMPRA ENERGY AND ITS AFFILIATES: San Diego Gas & Electric, Southern California Gas Co., and Sempra Energy Global Enterprises | SEMPRA ENERGY AND ITS AFFILIATES: San Diego Gas & Electric, Southern California Gas Co., and Sempra Energy Global Enterprises | SEMPRA ENERGY AND ITS AFFILIATES: San Diego Gas & Electric, Southern California Gas Co., and Sempra Energy Global Enterprises | SEMPRA ENERGY AND ITS AFFILIATES: San Diego Gas & Electric, Southern California Gas Co., and Sempra Energy Global Enterprises | SEMPRA ENERGY AND ITS AFFILIATES: San Diego Gas & Electric, Southern California Gas Co., and Sempra Energy Global Enterprises | SEMPRA ENERGY AND ITS AFFILIATES: San Diego Gas & Electric, Southern California Gas Co., and Sempra Energy Global Enterprises | SEMPRA ENERGY AND ITS AFFILIATES: San Diego Gas & Electric, Southern California Gas Co., and Sempra Energy Global Enterprises | SEMPRA ENERGY AND ITS AFFILIATES: San Diego Gas & Electric, Southern California Gas Co., and Sempra Energy Global Enterprises | SEMPRA ENERGY AND ITS AFFILIATES: San Diego Gas & Electric, Southern California Gas Co., and Sempra Energy Global Enterprises | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | SEMPRA ENERGY AND ITS AFFILIATES: San Diego Gas & Electric, Southern California Gas Co., and Sempra Energy Global Enterprises | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | SEMPRA ENERGY AND ITS AFFILIATES: San Diego Gas & Electric, Southern California Gas Co., and Sempra Energy Global Enterprises | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | 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 | 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 | 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 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
firm_phon | 916-492-4244 | 916-492-4244 | 916-492-4244 | 916-492-4244 | 916-492-4244 | 916-492-4244 | 916-492-4244 | 916-492-4244 | 916-492-4244 | 916-492-4244 | 916-492-4244 | 916-492-4244 | 916-492-4244 | 916-492-4244 | 916-492-4244 | 916-492-4244 | 916-492-4244 | 916-492-4244 | 916-492-4244 | 916-492-4244 | 916-492-4244 | 916-492-4244 | 916-492-4244 | 916-492-4244 | 916-492-4244 | 916-492-4244 | 916-492-4244 | 916-492-4244 | 916 446-7732 | 916-492-4244 | 916 446-7732 | 916-492-4244 | 916-446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | 916 446-7732 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | Oakland | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 94612 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 510-628-8043 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 2002-07-31 00:00:00 | 2002-10-30 00:00:00 | 2003-01-31 00:00:00 | 2003-04-30 00:00:00 | 2003-08-29 00:00:00 | 2003-08-29 00:00:00 | 2003-07-31 00:00:00 | 2003-10-31 00:00:00 | 2004-01-30 00:00:00 | 2004-04-27 00:00:00 | 2004-07-27 00:00:00 | 2004-09-29 00:00:00 | 2005-01-31 00:00:00 | 2006-05-01 00:00:00 | 2005-10-31 00:00:00 | 2005-05-02 00:00:00 | 2005-05-02 00:00:00 | 2006-01-31 00:00:00 | 2006-12-07 00:00:00 | 2007-04-30 00:00:00 | 2006-07-31 00:00:00 | 2007-01-31 00:00:00 | 2006-10-31 00:00:00 | 2007-07-31 00:00:00 | 2008-04-30 00:00:00 | 2007-01-31 00:00:00 | 2008-07-31 00:00:00 | 2007-10-29 00:00:00 | 2009-10-22 00:00:00 | 2008-10-30 00:00:00 | 2009-07-16 00:00:00 | 2009-01-31 00:00:00 | 2009-04-15 00:00:00 | 2010-10-08 00:00:00 | 2010-07-13 00:00:00 | 2010-04-08 00:00:00 | 2010-01-14 00:00:00 | 2011-10-06 00:00:00 | 2011-07-01 00:00:00 | 2011-04-06 00:00:00 | 2010-12-31 00:00:00 | 2012-01-04 00:00:00 | 2012-07-12 00:00:00 | 2012-10-03 00:00:00 | 2012-04-03 00:00:00 | 2013-01-10 00:00:00 | 2013-10-10 00:00:00 | 2013-07-10 00:00:00 | 2013-04-10 00:00:00 | 2014-01-09 00:00:00 | 2014-10-08 00:00:00 | 2014-07-10 00:00:00 | 2014-04-10 00:00:00 | 2015-10-07 00:00:00 | 2015-07-15 00:00:00 | 2015-01-08 00:00:00 | 2015-04-10 00:00:00 | 2016-04-07 00:00:00 | 2016-07-07 00:00:00 | 2016-01-07 00:00:00 | 2016-10-07 00:00:00 | 2017-07-06 00:00:00 | 2017-04-06 00:00:00 | 2017-01-05 00:00:00 | 2017-10-06 00:00:00 | 2018-07-05 00:00:00 | 2018-01-08 00:00:00 | 2018-10-09 00:00:00 | 2018-04-02 00:00:00 | 2019-04-08 00:00:00 | 2019-01-09 00:00:00 | 2019-07-03 00:00:00 | 2019-10-01 00:00:00 | 2020-01-08 00:00:00 | 2020-04-01 00:00:00 | 2020-10-01 00:00:00 | 2021-01-06 00:00:00 | 2020-07-01 00:00:00 | 2021-10-04 00:00:00 | 2022-01-04 00:00:00 | 2021-04-01 00:00:00 | 2021-07-01 00:00:00 | 2022-04-04 00:00:00 | 2022-09-30 00:00:00 | 2022-07-01 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 | 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 | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | Sacramento, CA | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_naml | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
sig_namf | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | Mr. | None | None | Mr. | None | Mr. | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
prn_namf | None | None | None | None | None | None | None | None | None | None | None | None | None | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | Mr. | None | None | Mr. | None | Mr. | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | Lobbyist | Lobbyist | Lobbyist | Lobbyist | Lobbyist | Lobbyist | Lobbyist | Lobbyist | Lobbyist | Lobbyist | Lobbyist | Lobbyist | Lobbyist | Lobbyist | Lobbyist | None | Lobbyist | None | Lobbyist | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | X | None | None | None | None | None | None | None | None | X | None | None | None | None | None | None | None | None | X | X | X | None | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | None | X | None | None | 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 | 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 | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 1226071 | 1406521 | 1406521 | 1561045 | 1561045 | 1753330 | 1921004 | 2147471 | 2329071 | 2542931 | 2542931 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
amend_id | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | |||||||||||
rec_type | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | CVR | |||||||||||
form_type | F604 | F604 | F604 | F604 | F604 | F604 | F604 | F604 | F604 | F604 | F604 | |||||||||||
sender_id | E22327 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | E01076 | |||||||||||
filer_id | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | |||||||||||
entity_cd | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | LBY | |||||||||||
filer_naml | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | |||||||||||
filer_namf | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | Raul | |||||||||||
filer_namt | Mr. | None | None | None | None | None | None | None | None | None | None | |||||||||||
filer_nams | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
report_num | 000 | 000 | 001 | 000 | 001 | 000 | 000 | 000 | 000 | 000 | 001 | |||||||||||
rpt_date | 2006-12-29 00:00:00 | 2008-01-30 00:00:00 | 2009-07-16 00:00:00 | 2011-01-31 00:00:00 | 2012-07-12 00:00:00 | 2013-03-14 00:00:00 | 2014-12-31 00:00:00 | 2016-12-31 00:00:00 | 2018-12-19 00:00:00 | 2020-12-18 00:00:00 | 2021-02-16 00:00:00 | |||||||||||
ls_beg_yr | 2007 | 2009 | 2009 | 2011 | 2011 | 2013 | 2015 | 2017 | 2019 | 2021 | 2021 | |||||||||||
ls_end_yr | 2008 | 2010 | 2010 | 2012 | 2012 | 2014 | 2016 | 2018 | 2020 | 2022 | 2022 | |||||||||||
qual_date | None | 2008-01-12 00:00:00 | None | None | None | None | None | None | None | None | None | |||||||||||
eff_date | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
bus_city | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | Sacramento | |||||||||||
bus_st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | |||||||||||
bus_zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | |||||||||||
bus_phon | 916-492-4244 | 916 446-7732 | 916 446 0150 | 916 446 7732 | 916 446 0150 | 916 446 0150 | 916 446 7732 | 916 446 7732 | 916 446 7732 | 916 446 7732 | 916 446 7732 | |||||||||||
bus_fax | 916-443-2994 | 916 446-1605 | 916 446 1605 | 916 446 1605 | 916 446 1605 | 916 446 1605 | 916 446 1605 | 916 446 1605 | 916 446 1605 | 916 446 1605 | 916 446 1605 | |||||||||||
bus_email | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | |||||||||||
mail_city | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
mail_st | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
mail_zip4 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
mail_phon | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
sig_date | 2006-12-28 00:00:00 | 2008-01-30 00:00:00 | 2009-07-16 00:00:00 | 2011-01-05 00:00:00 | 2012-07-12 00:00:00 | 2013-03-14 00:00:00 | 2014-12-18 00:00:00 | 2016-12-28 00:00:00 | 2018-12-19 00:00:00 | 2020-12-18 00:00:00 | 2021-02-16 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 | |||||||||||
sig_naml | Orozco | Orozco | None | OROZCO | None | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | |||||||||||
sig_namf | Raul | Raul | None | RAUL | None | Raul | Raul | Raul | Raul | Raul | Raul | |||||||||||
sig_namt | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
sig_nams | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
prn_naml | Orozco | Orozco | None | OROZCO | None | Orozco | Orozco | Orozco | Orozco | Orozco | Orozco | |||||||||||
prn_namf | Raul | Raul | None | RAUL | None | Raul | Raul | Raul | Raul | Raul | Raul | |||||||||||
prn_namt | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
prn_nams | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
sig_title | Lobbyist | Lobbyist | DIRECTOR GOVERNMENTAL AFFAIRS | DIRECTOR GOVERNMENTAL AFFAIRS | VICE PRESIDENT GOVERNMENT AFFAIRS | VICE PRESIDENT GOVERNMENT AFFAIRS | VICE PRESIDENT GOVERNMENT AFFAIRS | VICE PRESIDENT GOVERNMENT AFFAIRS | VICE PRESIDENT GOVERNMENT AFFAIRS | VICE PRESIDENT GOVERNMENT AFFAIRS | VICE PRESIDENT GOVERNMENT AFFAIRS | |||||||||||
stmt_firm | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
ind_cb | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
bus_cb | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
trade_cb | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
oth_cb | 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 | |||||||||||
a_b_city | 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 | |||||||||||
a_b_zip4 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
descrip_1 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
descrip_2 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
c_less50 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
c_more50 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
ind_class | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
ind_descr | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
bus_class | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
bus_descr | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
auth_name | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
auth_city | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
auth_st | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
auth_zip4 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
lobby_int | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
influen_yn | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
firm_name | Sempra Energy and its Subsidiaries | CA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | |||||||||||
newcert_cb | None | X | None | None | None | None | None | None | None | None | None | |||||||||||
rencert_cb | X | None | None | None | None | None | None | X | None | X | None | |||||||||||
complet_dt | None | None | 2008-09-12 00:00:00 | 2010-07-09 00:00:00 | 2012-07-10 00:00:00 | 2012-07-10 00:00:00 | 2014-07-09 00:00:00 | None | 2018-09-14 00:00:00 | None | 2021-02-12 00:00:00 | |||||||||||
lby_reg_cb | X | X | X | X | X | X | X | X | X | X | X | |||||||||||
lby_604_cb | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
st_leg_yn | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | |||||||||||
st_agency | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
lobby_cb | 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 |
filer_id | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 2032924 | 2043604 | 2081267 | 2116328 | 2160754 | 2190726 | 2204209 | 2411481 | 2545069 | 2507271 | 2259276 | 2465734 | 2338615 | |||||||||||||
effect_dt | 2002-06-03 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2009-01-12 00:00:00 | 2010-07-15 00:00:00 | 2011-01-01 00:00:00 | 2017-01-01 00:00:00 | 2023-01-01 00:00:00 | 2021-01-01 00:00:00 | 2013-03-19 00:00:00 | 2019-01-01 00:00:00 | 2015-01-01 00:00:00 | |||||||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | |||||||||||||
session_id | 2001 | 2003 | 2005 | 2007 | 2009 | 2009 | 2011 | 2017 | 2023 | 2021 | 2013 | 2019 | 2015 |
filer_id | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 2001 | 2003 | 2007 | 2009 | 2005 | 2011 | 2009 | 2011 | 2013 | 2015 | 2017 | 2019 | 2021 | |||||||||||||
ethics_date | 2002-08-02 00:00:00 | 2002-08-02 00:00:00 | 2007-03-15 00:00:00 | 2008-09-12 00:00:00 | 2004-11-17 00:00:00 | 2010-07-09 00:00:00 | 2010-07-09 00:00:00 | 2012-07-10 00:00:00 | 2012-07-10 00:00:00 | 2014-07-09 00:00:00 | 2017-01-12 00:00:00 | 2018-09-14 00:00:00 | 2021-02-12 00:00:00 |
filer_id | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 859783 | 855970 | 864917 | 848894 | 848896 | 893106 | 936401 | 901308 | 884038 | 912510 | 931993 | 921542 | 931993 | 948039 | 973723 | 969546 | 955899 | 989032 | 931993 | 1011634 | 1032735 | 1001453 | 1018809 | 1059676 | 1036055 | 1066081 | 1071826 | 1081915 | 1105878 | 1134359 | 1105864 | 1109421 | 1168197 | 1148953 | 1192225 | 1105864 | 1217012 | 1226071 | 1239135 | 1232789 | 1256565 | 1285635 | 1262572 | 1975912 | 1863698 | 1810423 | 1777557 | 1795364 | 1959069 | 1921004 | 1908829 | 1329892 | 1312050 | 1298056 | 1347638 | 1377440 | 1406243 | 1398531 | 1406521 | 1418471 | 1431712 | 1435362 | 1406521 | 1450599 | 1465294 | 1479489 | 1501055 | 1501734 | 1526843 | 1563844 | 1572213 | 1585798 | 1561045 | 1632415 | 1600194 | 1618495 | 1651438 | 1672348 | 1561045 | 1673822 | 1670971 | 1699698 | 1934374 | 1924422 | 1734435 | 1838930 | 1753816 | 1757634 | 1753330 | 1991481 | 2267392 | 2239977 | 2466234 | 2335045 | 2391289 | 2211471 | 2008150 | 2035531 | 2056262 | 2100628 | 2120295 | 2116779 | 2151179 | 2130464 | 2147471 | 2167481 | 2531641 | 2190722 | 2414110 | 2329071 | 2487970 | 2334126 | 2306524 | 2542931 | 2378037 | 2437104 | 2592030 | 2552335 | 2615394 | 2593953 | 2577962 | 2636793 | 2700129 | 2668201 | 2583265 | 2542931 | 2735981 | 2738618 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | None | 170 | None | None | None | None | None | None | 171 | 172 | 173 | None | 173 | 174 | None | 175 | None | 176 | 173 | 177 | 178 | None | None | 179 | None | None | None | 180 | 181 | 183 | 182 | None | 185 | 184 | 186 | 182 | 187 | 188 | 188 | None | None | 190 | 189 | 222 | 218 | 216 | 214 | 215 | 221 | 220 | 219 | 193 | 192 | 191 | 194 | 195 | None | 196 | 193 | 197 | None | 198 | 199 | 199 | 200 | 201 | None | 202 | 203 | None | 204 | 205 | 205 | 208 | 206 | 207 | 209 | 210 | 211 | None | None | 211 | 220 | None | 212 | 217 | None | 213 | 213 | 223 | 234 | 233 | 241 | None | 238 | 232 | 224 | 225 | 226 | 227 | None | None | 229 | 228 | 228 | 230 | 243 | 231 | 239 | 236 | 242 | 236 | 235 | 244 | 237 | 240 | None | 244 | 247 | 246 | 245 | 248 | 250 | 249 | None | 245 | None | 251 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F604 | F615 | F615 | F604 | F999 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F604 | F615 | F615 | F604 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F606 | F615 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 2 | 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 | 1 | 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 | 1 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 2002-08-02 00:00:00 | 2002-07-31 00:00:00 | 2002-07-31 00:00:00 | 2002-07-08 00:00:00 | 2002-07-10 00:00:00 | 2002-10-30 00:00:00 | 2003-05-01 00:00:00 | 2003-01-03 00:00:00 | 2002-10-30 00:00:00 | 2003-01-31 00:00:00 | 2003-04-30 00:00:00 | 2003-01-31 00:00:00 | 2003-08-15 00:00:00 | 2003-07-31 00:00:00 | 2003-10-31 00:00:00 | 2003-10-31 00:00:00 | 2003-07-31 00:00:00 | 2004-01-30 00:00:00 | 2003-09-22 00:00:00 | 2004-04-27 00:00:00 | 2004-08-02 00:00:00 | 2004-01-30 00:00:00 | 2004-04-30 00:00:00 | 2004-11-01 00:00:00 | 2004-08-02 00:00:00 | 2004-11-01 00:00:00 | 2005-01-03 00:00:00 | 2005-02-01 00:00:00 | 2005-05-03 00:00:00 | 2005-10-31 00:00:00 | 2005-05-03 00:00:00 | 2005-06-06 00:00:00 | 2006-05-01 00:00:00 | 2006-01-31 00:00:00 | 2006-07-31 00:00:00 | 2006-12-15 00:00:00 | 2006-10-31 00:00:00 | 2007-01-03 00:00:00 | 2007-01-31 00:00:00 | 2007-01-02 00:00:00 | 2007-03-23 00:00:00 | 2007-07-31 00:00:00 | 2007-04-30 00:00:00 | 2015-07-22 00:00:00 | 2014-07-17 00:00:00 | 2014-01-16 00:00:00 | 2013-07-23 00:00:00 | 2013-10-17 00:00:00 | 2015-04-17 00:00:00 | 2014-12-29 00:00:00 | 2014-10-29 00:00:00 | 2008-04-30 00:00:00 | 2008-01-31 00:00:00 | 2007-10-31 00:00:00 | 2008-07-29 00:00:00 | 2008-10-30 00:00:00 | 2009-02-20 00:00:00 | 2009-02-02 00:00:00 | 2009-03-11 00:00:00 | 2009-04-23 00:00:00 | 2009-07-17 00:00:00 | 2009-07-29 00:00:00 | 2009-07-29 00:00:00 | 2009-10-28 00:00:00 | 2010-02-01 00:00:00 | 2010-04-13 00:00:00 | 2010-07-15 00:00:00 | 2010-07-21 00:00:00 | 2010-10-15 00:00:00 | 2011-01-18 00:00:00 | 2011-01-31 00:00:00 | 2011-04-12 00:00:00 | 2011-01-18 00:00:00 | 2012-01-26 00:00:00 | 2011-07-13 00:00:00 | 2011-10-20 00:00:00 | 2012-04-10 00:00:00 | 2012-07-18 00:00:00 | 2012-07-18 00:00:00 | 2012-07-20 00:00:00 | 2012-07-10 00:00:00 | 2012-10-18 00:00:00 | 2015-01-30 00:00:00 | 2014-12-30 00:00:00 | 2013-01-29 00:00:00 | 2014-04-16 00:00:00 | 2013-03-19 00:00:00 | 2013-04-16 00:00:00 | 2013-03-18 00:00:00 | 2015-10-12 00:00:00 | 2018-07-23 00:00:00 | 2018-04-27 00:00:00 | 2020-04-17 00:00:00 | 2018-12-24 00:00:00 | 2019-07-19 00:00:00 | 2018-01-31 00:00:00 | 2016-01-27 00:00:00 | 2016-04-29 00:00:00 | 2016-07-19 00:00:00 | 2016-10-30 00:00:00 | 2017-01-12 00:00:00 | 2016-12-29 00:00:00 | 2017-04-13 00:00:00 | 2017-01-31 00:00:00 | 2017-03-21 00:00:00 | 2017-07-14 00:00:00 | 2020-11-02 00:00:00 | 2017-10-26 00:00:00 | 2019-10-21 00:00:00 | 2018-12-20 00:00:00 | 2020-07-31 00:00:00 | 2019-01-14 00:00:00 | 2018-10-15 00:00:00 | 2021-01-08 00:00:00 | 2019-04-27 00:00:00 | 2020-01-28 00:00:00 | 2021-03-05 00:00:00 | 2021-01-31 00:00:00 | 2021-10-12 00:00:00 | 2021-07-16 00:00:00 | 2021-04-28 00:00:00 | 2022-01-24 00:00:00 | 2022-07-22 00:00:00 | 2022-04-20 00:00:00 | 2021-01-11 00:00:00 | 2021-03-03 00:00:00 | 2022-10-13 00:00:00 | 2022-10-21 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10002 | 10001 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10001 | 10001 | 10001 | 10005 | 10002 | 10001 | 10005 | 10001 | 10005 | 10001 | 10002 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10006 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10005 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10006 | 10001 | 10002 | 10001 | 10001 | 10001 | 10006 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10006 | 10006 | 10001 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10006 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10002 | 10003 | 10001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 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 | 11003 | 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 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2003 | 2001 | 2001 | 2003 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2005 | 2007 | 2007 | 2007 | 2007 | 2015 | 2013 | 2013 | 2013 | 2013 | 2015 | 2015 | 2013 | 2007 | 2007 | 2007 | 2007 | 2007 | 2009 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2015 | 2011 | 2013 | 2013 | 2013 | 2013 | 2015 | 2017 | 2017 | 2019 | 2019 | 2019 | 2017 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2015 | 2017 | 2017 | 2019 | 2017 | 2019 | 2019 | 2019 | 2017 | 2017 | 2021 | 2019 | 2019 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | SARRIAGA | * | GGILMORE | SARRIAGA | SARRIAGA | LTHIBAUL | LTHIBAUL | PBANFORD | * | COMPLETED | COMPLETED | DBARRICK | COMPLETED | COMPLETED | LTHIBAUL | COMPLETED | LTHIBAUL | COMPLETED | COMPLETED | COMPLETED | COMPLETED | LTHIBAUL | BINTHAVO | COMPLETED | LTHIBAUL | LTHIBAUL | LTHIBAUL | COMPLETED | LTHIBAUL | LTHIBAUL | LTHIBAUL | SARRIAGA | LTHIBAUL | LTHIBAUL | LTHIBAUL | * | LTHIBAUL | * | LTHIBAUL | GKURIMOT | GPEREZ | LTHIBAUL | LTHIBAUL | JINGRAM | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | MPACHECO | CAFILER | AGLADNEY | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | JINGRAM | SARRIAGA | JINGRAM | * | MGUERRA | YRODRIGU | MGUERRA | YRODRIGU | MGUERRA | WBROWN | JINGRAM | YRODRIGU | MGUERRA | AGLADNEY | YRODRIGU | AGLADNEY | JINGRAM | YRODRIGU | ASAETERN | ASAETERN | ASAETERN | ASAETERN | AGLADNEY | YRODRIGU | YRODRIGU | MPACHECO | ASAETERN | AGLADNEY | GKURIMOT | ASAETERN | AGLADNEY | PBANFORD | ASAETERN | PBANFORD | JINGRAM | AGLADNEY | AGLADNEY | VUKSTINA | PBANFORD | VUKSTINA | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | PBANFORD | PBANFORD | AGLADNEY | AGLADNEY | CAFILER | SMCCONNAN | MKIRKHAM | SMCCONNAN | VUKSTINA | PBANFORD | MMERCHANT | AGLADNEY | JFRONEFIELD | JMENDOZA | SUSHAKOV | VUKSTINA | CVANLIEW | CHARTRIDGE | GTAYLOR | CHATRIDGE | CHARTRIDGE | RATTIYEH | CAFILER | CAFILER | JMENDOZA | CVANLIEW | NKRESTOFF | CAFILER | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11003 | 11003 | 11002 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 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 | 11003 | 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 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1900-01-01 00:00:00 | 2002-04-01 00:00:00 | 2002-04-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2002-07-01 00:00:00 | 2003-01-01 00:00:00 | 1900-01-01 00:00:00 | 2002-07-01 00:00:00 | 2002-10-01 00:00:00 | 2003-01-01 00:00:00 | 2002-10-01 00:00:00 | 2003-01-01 00:00:00 | 2003-04-01 00:00:00 | 2003-07-01 00:00:00 | 2003-07-01 00:00:00 | 2003-04-01 00:00:00 | 2003-10-01 00:00:00 | 2003-01-01 00:00:00 | 2004-01-01 00:00:00 | 2004-04-01 00:00:00 | 2003-10-01 00:00:00 | 2004-01-01 00:00:00 | 2004-07-01 00:00:00 | 2004-04-01 00:00:00 | 2004-07-01 00:00:00 | 1900-01-01 00:00:00 | 2004-10-01 00:00:00 | 2005-01-01 00:00:00 | 2005-07-01 00:00:00 | 2005-04-01 00:00:00 | 1900-01-01 00:00:00 | 2006-01-01 00:00:00 | 2005-10-01 00:00:00 | 2006-04-01 00:00:00 | 2005-04-01 00:00:00 | 2006-07-01 00:00:00 | 2006-12-29 00:00:00 | 2006-10-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2007-04-01 00:00:00 | 2007-01-01 00:00:00 | 2015-04-01 00:00:00 | 2014-04-01 00:00:00 | 2013-10-01 00:00:00 | 2013-04-01 00:00:00 | 2013-07-01 00:00:00 | 2015-01-01 00:00:00 | 2014-12-31 00:00:00 | 2014-07-01 00:00:00 | 2008-01-01 00:00:00 | 2007-10-01 00:00:00 | 2007-07-01 00:00:00 | 2008-04-01 00:00:00 | 2008-07-01 00:00:00 | 1900-01-01 00:00:00 | 2008-10-01 00:00:00 | 2008-01-30 00:00:00 | 2009-01-01 00:00:00 | 1900-01-01 00:00:00 | 2009-04-01 00:00:00 | 2009-07-16 00:00:00 | 2009-07-01 00:00:00 | 2009-10-01 00:00:00 | 2010-01-01 00:00:00 | 1900-01-01 00:00:00 | 2010-04-01 00:00:00 | 2010-07-01 00:00:00 | 1900-01-01 00:00:00 | 2010-10-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-31 00:00:00 | 2011-10-01 00:00:00 | 2011-04-01 00:00:00 | 2011-07-01 00:00:00 | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 2012-07-12 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2012-07-01 00:00:00 | 2014-10-01 00:00:00 | 1900-01-01 00:00:00 | 2012-10-01 00:00:00 | 2014-01-01 00:00:00 | 1900-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-03-14 00:00:00 | 2015-07-01 00:00:00 | 2018-04-01 00:00:00 | 2018-01-01 00:00:00 | 2020-01-01 00:00:00 | 1900-01-01 00:00:00 | 2019-04-01 00:00:00 | 2017-10-01 00:00:00 | 2015-10-01 00:00:00 | 2016-01-01 00:00:00 | 2016-04-01 00:00:00 | 2016-07-01 00:00:00 | None | 1900-01-01 00:00:00 | 2017-01-01 00:00:00 | 2016-10-01 00:00:00 | 2016-12-31 00:00:00 | 2017-04-01 00:00:00 | 2020-07-01 00:00:00 | 2017-07-01 00:00:00 | 2019-07-01 00:00:00 | 2018-12-19 00:00:00 | 2020-04-01 00:00:00 | 2018-10-01 00:00:00 | 2018-07-01 00:00:00 | 2020-12-18 00:00:00 | 2019-01-01 00:00:00 | 2019-10-01 00:00:00 | 1900-01-01 00:00:00 | 2020-10-01 00:00:00 | 2021-07-01 00:00:00 | 2021-04-01 00:00:00 | 2021-01-01 00:00:00 | 2021-10-01 00:00:00 | 2022-04-01 00:00:00 | 2022-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-02-16 00:00:00 | 1900-01-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1900-01-01 00:00:00 | 2002-06-30 00:00:00 | 2002-06-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2002-09-30 00:00:00 | 2003-03-31 00:00:00 | 1900-01-01 00:00:00 | 2002-09-30 00:00:00 | 2002-12-31 00:00:00 | 2003-03-31 00:00:00 | 2002-12-31 00:00:00 | 2003-03-31 00:00:00 | 2003-06-30 00:00:00 | 2003-09-30 00:00:00 | 2003-09-30 00:00:00 | 2003-06-30 00:00:00 | 2003-12-31 00:00:00 | 2003-03-31 00:00:00 | 2004-03-31 00:00:00 | 2004-06-30 00:00:00 | 2003-12-31 00:00:00 | 2004-03-31 00:00:00 | 2004-09-30 00:00:00 | 2004-06-30 00:00:00 | 2004-09-30 00:00:00 | 1900-01-01 00:00:00 | 2004-12-31 00:00:00 | 2005-03-31 00:00:00 | 2005-09-30 00:00:00 | 2005-06-30 00:00:00 | 1900-01-01 00:00:00 | 2006-03-31 00:00:00 | 2005-12-31 00:00:00 | 2006-06-30 00:00:00 | 2005-06-30 00:00:00 | 2006-09-30 00:00:00 | 2006-12-29 00:00:00 | 2006-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2007-06-30 00:00:00 | 2007-03-31 00:00:00 | 2015-06-30 00:00:00 | 2014-06-30 00:00:00 | 2013-12-31 00:00:00 | 2013-06-30 00:00:00 | 2013-09-30 00:00:00 | 2015-03-31 00:00:00 | 2014-12-31 00:00:00 | 2014-09-30 00:00:00 | 2008-03-31 00:00:00 | 2007-12-31 00:00:00 | 2007-09-30 00:00:00 | 2008-06-30 00:00:00 | 2008-09-30 00:00:00 | 1900-01-01 00:00:00 | 2008-12-31 00:00:00 | 2008-01-30 00:00:00 | 2009-03-31 00:00:00 | 1900-01-01 00:00:00 | 2009-06-30 00:00:00 | 2009-07-16 00:00:00 | 2009-09-30 00:00:00 | 2009-12-31 00:00:00 | 2010-03-31 00:00:00 | 1900-01-01 00:00:00 | 2010-06-30 00:00:00 | 2010-09-30 00:00:00 | 1900-01-01 00:00:00 | 2010-12-31 00:00:00 | 2011-03-31 00:00:00 | 2011-01-31 00:00:00 | 2011-12-31 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 2012-07-12 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2012-09-30 00:00:00 | 2014-12-31 00:00:00 | 1900-01-01 00:00:00 | 2012-12-31 00:00:00 | 2014-03-31 00:00:00 | 1900-01-01 00:00:00 | 2013-03-31 00:00:00 | 2013-03-14 00:00:00 | 2015-09-30 00:00:00 | 2018-06-30 00:00:00 | 2018-03-31 00:00:00 | 2020-03-31 00:00:00 | 1900-01-01 00:00:00 | 2019-06-30 00:00:00 | 2017-12-31 00:00:00 | 2015-12-31 00:00:00 | 2016-03-31 00:00:00 | 2016-06-30 00:00:00 | 2016-09-30 00:00:00 | None | 1900-01-01 00:00:00 | 2017-03-31 00:00:00 | 2016-12-31 00:00:00 | 2016-12-31 00:00:00 | 2017-06-30 00:00:00 | 2020-09-30 00:00:00 | 2017-09-30 00:00:00 | 2019-09-30 00:00:00 | 2018-12-19 00:00:00 | 2020-06-30 00:00:00 | 2018-12-31 00:00:00 | 2018-09-30 00:00:00 | 2020-12-18 00:00:00 | 2019-03-31 00:00:00 | 2019-12-31 00:00:00 | 1900-01-01 00:00:00 | 2020-12-31 00:00:00 | 2021-09-30 00:00:00 | 2021-06-30 00:00:00 | 2021-03-31 00:00:00 | 2021-12-31 00:00:00 | 2022-06-30 00:00:00 | 2022-03-31 00:00:00 | 1900-01-01 00:00:00 | 2021-02-16 00:00:00 | 1900-01-01 00:00:00 | 2022-09-30 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | None | None | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | 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 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | None | 22001 |
filer_id | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | ||||||||||||
active | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | N | ||||||||||||
race | 0 | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
session_id | 2001 | 2003 | 2005 | 2007 | 2011 | 2013 | 2009 | 2021 | 2015 | 2017 | 2019 | 2023 | ||||||||||||
category | 0 | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
category_type | 0 | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
sub_category | 0 | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
effect_dt | 2002-06-03 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2011-01-01 00:00:00 | 2013-03-19 00:00:00 | 2009-01-12 00:00:00 | 2021-01-01 00:00:00 | 2015-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2023-01-01 00:00:00 | ||||||||||||
sub_category_type | 0 | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
election_type | 0 | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
sub_category_a | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
nyq_dt | None | None | 2002-04-01 00:00:00 | 2002-04-01 00:00:00 | None | None | None | None | None | None | None | None | ||||||||||||
party_cd | 0 | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
county_cd | 0 | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
district_cd | 0 | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1245397 | |
---|---|---|
xref_id | 1245397 | |
effect_dt | 2002-07-10 00:00:00 | |
migration_source | CLAIMS |
xref_filer_id | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | 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 | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
effect_dt | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
naml | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | OROZCO | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namf | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL B. | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | RAUL | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 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 | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | 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 | 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 | 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 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 9164924244 | 9164924244 | 9164924244 | 9164924244 | 9164467732 | 9164460150 | 9164467732 | 9164460150 | 9164467732 | 9164467732 | 9164467732 | 9164467732 | 9164467732 | 9164924244 | 9164924244 | 9164924244 | 9164924244 | 9164467732 | 9164460150 | 9164467732 | 9164460150 | 9164467732 | 9164467732 | 9164467732 | 9164467732 | 9164467732 | 9164924244 | 9164924244 | 9164924244 | 9164924244 | 9164467732 | 9164460150 | 9164467732 | 9164460150 | 9164467732 | 9164467732 | 9164467732 | 9164467732 | 9164467732 | 9164924244 | 9164924244 | 9164924244 | 9164924244 | 9164467732 | 9164460150 | 9164467732 | 9164460150 | 9164467732 | 9164467732 | 9164467732 | 9164467732 | 9164467732 | 9164924244 | 9164924244 | 9164924244 | 9164924244 | 9164467732 | 9164460150 | 9164467732 | 9164460150 | 9164467732 | 9164467732 | 9164467732 | 9164467732 | 9164467732 | 9164924244 | 9164924244 | 9164924244 | 9164924244 | 9164467732 | 9164460150 | 9164467732 | 9164460150 | 9164467732 | 9164467732 | 9164467732 | 9164467732 | 9164467732 | 9164924244 | 9164924244 | 9164924244 | 9164924244 | 9164467732 | 9164460150 | 9164467732 | 9164460150 | 9164467732 | 9164467732 | 9164467732 | 9164467732 | 9164467732 | 9164924244 | 9164924244 | 9164924244 | 9164924244 | 9164467732 | 9164460150 | 9164467732 | 9164460150 | 9164467732 | 9164467732 | 9164467732 | 9164467732 | 9164467732 | 9164924244 | 9164924244 | 9164924244 | 9164924244 | 9164467732 | 9164460150 | 9164467732 | 9164460150 | 9164467732 | 9164467732 | 9164467732 | 9164467732 | 9164467732 | 9164924244 | 9164924244 | 9164924244 | 9164924244 | 9164467732 | 9164460150 | 9164467732 | 9164460150 | 9164467732 | 9164467732 | 9164467732 | 9164467732 | 9164467732 | 9164924244 | 9164924244 | 9164924244 | 9164924244 | 9164467732 | 9164460150 | 9164467732 | 9164460150 | 9164467732 | 9164467732 | 9164467732 | 9164467732 | 9164467732 | 9164924244 | 9164924244 | 9164924244 | 9164924244 | 9164467732 | 9164460150 | 9164467732 | 9164460150 | 9164467732 | 9164467732 | 9164467732 | 9164467732 | 9164467732 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | 9164432994 | 9164432994 | 9164432994 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164432994 | 9164432994 | 9164432994 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164432994 | 9164432994 | 9164432994 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164432994 | 9164432994 | 9164432994 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164432994 | 9164432994 | 9164432994 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164432994 | 9164432994 | 9164432994 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164432994 | 9164432994 | 9164432994 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164432994 | 9164432994 | 9164432994 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164432994 | 9164432994 | 9164432994 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164432994 | 9164432994 | 9164432994 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164432994 | 9164432994 | 9164432994 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164432994 | 9164432994 | 9164432994 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | 9164461605 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
[email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] |
filer_id | 1245397 |
---|
filer_id | 1245397 | 1245397 | 1245397 | |||
---|---|---|---|---|---|---|
change_no | 2 | 0 | 3 | |||
session_id | 2001 | 2001 | 2013 | |||
log_dt | 2002-07-08 00:00:00 | 2002-07-08 00:00:00 | 2013-03-19 00:00:00 | |||
filer_type | 4 | 4 | 4 | |||
correction_flg | Y | Y | Y | |||
action | NEW | ADDED | ADDED | |||
attribute_changed | LOBBYIST | EMPLOYER | EMPLOYER | |||
ethics_dt | None | None | None | |||
interests | None | None | None | |||
filer_full_name | OROZCO, RAUL B. | OROZCO, RAUL B. | OROZCO, RAUL | |||
filer_city | SACRAMENTO | None | None | |||
filer_st | CA | None | None | |||
filer_zip | 95814 | None | None | |||
filer_phone | 9164924244 | None | None | |||
entity_type | 4 | 2 | 2 | |||
entity_name | None | SEMPRA ENERGY AND ITS AFFILIATES: SAN DIEGO GAS & ELECTRIC, SOUTHERN CALIFORNIA GAS COMPANY | CALIFORNIA CABLE & TELECOMMUNICATIONS ASSOCIATION | |||
entity_city | None | None | None | |||
entity_st | None | None | None | |||
entity_zip | None | None | None | |||
entity_phone | None | None | None | |||
entity_id | 0 | 1146926 | 1146867 | |||
responsible_officer | None | None | None | |||
effect_dt | 2002-06-03 00:00:00 | 2002-06-03 00:00:00 | 2013-03-19 00:00:00 |
filer_id | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | 1245397 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 855970_0.cal | 884038_0.cal | 912510_0.cal | 931993_0.cal | 948039_0.cal | 931993_1.cal | 931993_2.cal | 969546_0.cal | 989032_0.cal | 1011634_0.cal | 1032735_0.cal | 1059676_0.cal | 1105864_0.cal | 1105878_0.cal | 260186.cal | 1134359_0.cal | 1148953_0.cal | 403953.cal | 1168197_0.cal | 1192225_0.cal | 1329892_0.cal | 1501734_0.cal | 1406521_0.cal | 1398531_0.cal | 1347638_0.cal | 1450599_0.cal | 1217012_0.cal | 1105864_1.cal | 1226071_0.cal | 1239135_0.cal | 1479489_0.cal | 1465294_0.cal | 1262572_0.cal | 1435362_0.cal | 1298056_0.cal | 1285635_0.cal | 1377440_0.cal | 1418471_0.cal | 1312050_0.cal | 1526843_0.cal | 1672348_0.cal | 187547.cal | 1753330_0.cal | 1734435_0.cal | 1757634_0.cal | 1838930_0.cal | 1795364_0.cal | 1585798_0.cal | 1699698_0.cal | 1572213_0.cal | 370102.cal | 1561045_0.cal | 1810423_0.cal | 1618495_0.cal | 1600194_0.cal | 1777557_0.cal | 1632415_0.cal | 1651438_0.cal | 1863698_0.cal | 54076.cal | 2130464_0.cal | 2147471_0.cal | 2056262_0.cal | 2008150_0.cal | 2151179_0.cal | 2100628_0.cal | 1908829_0.cal | 1921004_0.cal | 2035531_0.cal | 1975912_0.cal | 1934374_0.cal | 1959069_0.cal | 1991481_0.cal | 2167481_0.cal | 2267392_0.cal | 2378037_0.cal | 2239977_0.cal | 2466234_0.cal | 2437104_0.cal | 2211471_0.cal | 2190722_0.cal | 2329071_0.cal | 2334126_0.cal | 2487970_0.cal | 2306524_0.cal | 2391289_0.cal | 2414110_0.cal | 2552335_0.cal | 2542931_1.cal | 2531641_0.cal | 2636793_0.cal | 2668201_0.cal | 2738618_0.cal | 2577962_0.cal | 2593953_0.cal | 2542931_0.cal | 2615394_0.cal | 2700129_0.cal | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
received_date | 2002-07-31 00:00:00 | 2002-10-30 00:00:00 | 2003-01-31 00:00:00 | 2003-04-30 00:00:00 | 2003-07-31 00:00:00 | 2003-08-15 00:00:00 | 2003-09-22 00:00:00 | 2003-10-31 00:00:00 | 2004-01-30 00:00:00 | 2004-04-27 00:00:00 | 2004-08-02 00:00:00 | 2004-11-01 00:00:00 | 2005-05-03 00:00:00 | 2005-05-03 00:00:00 | 2005-08-01 00:00:00 | 2005-10-31 00:00:00 | 2006-01-31 00:00:00 | 2006-05-01 00:00:00 | 2006-05-01 00:00:00 | 2006-07-31 00:00:00 | 2008-04-30 00:00:00 | 2010-07-21 00:00:00 | 2009-03-11 00:00:00 | 2009-02-02 00:00:00 | 2008-07-29 00:00:00 | 2009-10-28 00:00:00 | 2006-10-31 00:00:00 | 2006-12-15 00:00:00 | 2007-01-03 00:00:00 | 2007-01-31 00:00:00 | 2010-04-13 00:00:00 | 2010-02-01 00:00:00 | 2007-04-30 00:00:00 | 2009-07-29 00:00:00 | 2007-10-31 00:00:00 | 2007-07-31 00:00:00 | 2008-10-30 00:00:00 | 2009-04-23 00:00:00 | 2008-01-31 00:00:00 | 2010-10-15 00:00:00 | 2012-07-18 00:00:00 | 2012-07-18 00:00:00 | 2013-03-18 00:00:00 | 2013-01-29 00:00:00 | 2013-04-16 00:00:00 | 2014-04-16 00:00:00 | 2013-10-17 00:00:00 | 2011-04-12 00:00:00 | 2012-10-18 00:00:00 | 2011-01-31 00:00:00 | 2011-01-18 00:00:00 | 2011-01-18 00:00:00 | 2014-01-16 00:00:00 | 2011-10-20 00:00:00 | 2011-07-13 00:00:00 | 2013-07-23 00:00:00 | 2012-01-26 00:00:00 | 2012-04-10 00:00:00 | 2014-07-17 00:00:00 | 2017-03-21 00:00:00 | 2017-01-31 00:00:00 | 2017-03-21 00:00:00 | 2016-07-19 00:00:00 | 2016-01-27 00:00:00 | 2017-04-13 00:00:00 | 2016-10-30 00:00:00 | 2014-10-29 00:00:00 | 2014-12-29 00:00:00 | 2016-04-29 00:00:00 | 2015-07-22 00:00:00 | 2015-01-30 00:00:00 | 2015-04-17 00:00:00 | 2015-10-12 00:00:00 | 2017-07-14 00:00:00 | 2018-07-23 00:00:00 | 2019-04-27 00:00:00 | 2018-04-27 00:00:00 | 2020-04-17 00:00:00 | 2020-01-28 00:00:00 | 2018-01-31 00:00:00 | 2017-10-26 00:00:00 | 2018-12-20 00:00:00 | 2019-01-14 00:00:00 | 2020-07-31 00:00:00 | 2018-10-15 00:00:00 | 2019-07-19 00:00:00 | 2019-10-21 00:00:00 | 2021-01-31 00:00:00 | 2021-03-03 00:00:00 | 2020-11-02 00:00:00 | 2022-01-24 00:00:00 | 2022-04-20 00:00:00 | 2022-10-21 00:00:00 | 2021-04-28 00:00:00 | 2021-07-16 00:00:00 | 2021-01-08 00:00:00 | 2021-10-12 00:00:00 | 2022-07-22 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/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/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/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/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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_id | 855970 | 884038 | 912510 | 931993 | 948039 | 931993 | 931993 | 969546 | 989032 | 1011634 | 1032735 | 1059676 | 1105864 | 1105878 | None | 1134359 | 1148953 | None | 1168197 | 1192225 | 1329892 | 1501734 | 1406521 | 1398531 | 1347638 | 1450599 | 1217012 | 1105864 | 1226071 | 1239135 | 1479489 | 1465294 | 1262572 | 1435362 | 1298056 | 1285635 | 1377440 | 1418471 | 1312050 | 1526843 | 1672348 | None | 1753330 | 1734435 | 1757634 | 1838930 | 1795364 | 1585798 | 1699698 | 1572213 | None | 1561045 | 1810423 | 1618495 | 1600194 | 1777557 | 1632415 | 1651438 | 1863698 | None | 2130464 | 2147471 | 2056262 | 2008150 | 2151179 | 2100628 | 1908829 | 1921004 | 2035531 | 1975912 | 1934374 | 1959069 | 1991481 | 2167481 | 2267392 | 2378037 | 2239977 | 2466234 | 2437104 | 2211471 | 2190722 | 2329071 | 2334126 | 2487970 | 2306524 | 2391289 | 2414110 | 2552335 | 2542931 | 2531641 | 2636793 | 2668201 | 2738618 | 2577962 | 2593953 | 2542931 | 2615394 | 2700129 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | None | F615 | F615 | None | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | None | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | None | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | None | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | 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 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 passed validation, but failed DB constraints | 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 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 |