filer_id | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | |||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1107977 | 1107889 | 1107466 | 2001649 | 2043107 | 2043108 | 2078935 | 2078936 | 2114666 | 2163596 | 2149204 | 2206105 | 2273396 | 2533889 | 2533890 | 2547756 | 2547757 | 2373526 | 2358673 | |||||||||||||||||||
effect_dt | 1997-01-01 00:00:00 | 1995-01-01 00:00:00 | 1999-01-01 00:00:00 | 1999-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-06 00:00:00 | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2008-07-29 00:00:00 | 2011-01-01 00:00:00 | 2013-01-01 00:00:00 | 2022-01-01 00:00:00 | 2022-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-01-01 00:00:00 | |||||||||||||||||||
add_type | 7051 | 7051 | 7051 | 7082 | 7051 | 7082 | 7051 | 7082 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7082 | 7051 | 7082 | 7050 | 7051 | |||||||||||||||||||
session_id | 1997 | 1995 | 1999 | 1999 | 2003 | 2003 | 2005 | 2005 | 2007 | 2009 | 2007 | 2011 | 2013 | 2021 | 2021 | 2023 | 2023 | 2015 | 2015 |
filer_id | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 475045 | 468543 | 464389 | 479685 | 472279 | 474083 | 466940 | 495205 | 477840 | 490538 | 494202 | 540404 | 477840 | 477840 | 480622 | 483365 | 490538 | 497805 | 486896 | 540404 | 484188 | 487811 | 491527 | 630585 | 619698 | 652980 | 694063 | 703680 | 757828 | 729597 | 764554 | 770202 | 797577 | 778080 | 771939 | 792776 | 814046 | 839229 | 819581 | 842890 | 860839 | 868822 | 869156 | 856792 | 856807 | 862776 | 862777 | 856817 | 856792 | 900071 | 884768 | 917515 | 894449 | 911151 | 930830 | 944789 | 934241 | 955585 | 990018 | 969327 | 955642 | 974839 | 1031309 | 993374 | 1014000 | 1018636 | 1061999 | 1035700 | 1079357 | 1059485 | 1085182 | 1088514 | 1117755 | 1104943 | 1132849 | 1147710 | 1132849 | 1167245 | 1189951 | 1215413 | 1224531 | 1234577 | 1257800 | 1241399 | 1280236 | 1306705 | 1293538 | 1779384 | 1751646 | 1961927 | 1939480 | 1977484 | 1866330 | 1800372 | 1959958 | 1928565 | 1942678 | 1940891 | 1951790 | 1866330 | 1902171 | 1327011 | 1353975 | 1347409 | 1347409 | 1378262 | 1413757 | 1398818 | 1422370 | 1438806 | 1444401 | 1453229 | 1464116 | 1484812 | 1508111 | 1536568 | 1551182 | 1561810 | 1565015 | 1564990 | 1562350 | 1536568 | 1552038 | 1564435 | 1602646 | 1622032 | 1588011 | 1622032 | 1633865 | 1602646 | 1588011 | 1674835 | 1655441 | 1817828 | 1917067 | 1918176 | 1917092 | 1923637 | 1717752 | 1674835 | 1702815 | 1745112 | 1718305 | 1744135 | 1734240 | 1728620 | 1841361 | 1763088 | 1752125 | 1728351 | 1756147 | 1763088 | 1970038 | 1939480 | 1989268 | 2005857 | 2673080 | 2695929 | 2695070 | 2703891 | 2660755 | 1994588 | 2747308 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 143 | 157 | 141 | 159 | 150 | 158 | 149 | 148 | 151 | 154 | 155 | 142 | 151 | 151 | 144 | 152 | 154 | 156 | 153 | 142 | 145 | 146 | 147 | 161 | 160 | 162 | 163 | None | 165 | 164 | None | 165 | None | None | 166 | 167 | 168 | 169 | None | None | None | None | None | 170 | 171 | None | None | 171 | 170 | None | 171 | None | None | 172 | 173 | 174 | None | None | 176 | 175 | None | None | 178 | None | 177 | None | None | None | 180 | 179 | None | None | 182 | 181 | 183 | 184 | 183 | 185 | 186 | 187 | 188 | 188 | 189 | None | 190 | 192 | 191 | 214 | None | None | 221 | 222 | 218 | 215 | 221 | 220 | None | None | None | 218 | 219 | 193 | None | 194 | 194 | 195 | None | 196 | 197 | 198 | None | 199 | 200 | 201 | 202 | 203 | 204 | None | 204 | None | 204 | 203 | 204 | None | 206 | 207 | 205 | 207 | 208 | 206 | 205 | 210 | 209 | 216 | 220 | 220 | 220 | 220 | 212 | 210 | 211 | None | 212 | None | 212 | None | 217 | 213 | 213 | 212 | None | 213 | None | 221 | None | 224 | 249 | None | 250 | 250 | None | 223 | 251 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F690 | F690 | F635 | F635 | F690 | F635 | F635 | F690 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F606 | F602 | F602 | F635 | F635 | F635 | F635 | F606 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F602 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F602 | F635 | F635 | F635 | F605 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F602 | F602 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F602 | F602 | F602 | F635 | F635 | F602 | F602 | F602 | F635 | F602 | F635 | F635 | F602 | F602 | F602 | F635 | F602 | F602 | F605 | F635 | F635 | F602 | F602 | F635 | F602 | F635 | F635 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 0 | 0 | 1 | 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 | 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 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1995-10-31 00:00:00 | 1999-04-30 00:00:00 | 1995-05-01 00:00:00 | 1999-11-01 00:00:00 | 1997-07-31 00:00:00 | 1999-08-02 00:00:00 | 1997-04-29 00:00:00 | 1997-01-31 00:00:00 | 1997-10-31 00:00:00 | 1998-07-31 00:00:00 | 1998-11-05 00:00:00 | 1995-07-31 00:00:00 | 1998-02-04 00:00:00 | 1998-02-02 00:00:00 | 1996-01-31 00:00:00 | 1998-02-02 00:00:00 | 1999-02-03 00:00:00 | 1999-02-01 00:00:00 | 1998-04-30 00:00:00 | 1995-11-03 00:00:00 | 1996-04-30 00:00:00 | 1996-07-31 00:00:00 | 1996-10-31 00:00:00 | 2000-05-01 00:00:00 | 2000-01-31 00:00:00 | 2000-07-31 00:00:00 | 2000-10-31 00:00:00 | 2000-12-28 00:00:00 | 2001-04-30 00:00:00 | 2001-01-31 00:00:00 | 2001-06-15 00:00:00 | 2001-05-04 00:00:00 | 2001-10-31 00:00:00 | 2001-07-31 00:00:00 | 2001-07-30 00:00:00 | 2001-10-31 00:00:00 | 2002-01-31 00:00:00 | 2002-04-30 00:00:00 | 2002-01-31 00:00:00 | 2002-04-30 00:00:00 | 2002-08-06 00:00:00 | 2002-09-20 00:00:00 | 2002-09-24 00:00:00 | 2002-07-31 00:00:00 | 2002-07-31 00:00:00 | 2002-07-31 00:00:00 | 2002-07-31 00:00:00 | 2002-07-31 00:00:00 | 2002-09-26 00:00:00 | 2002-12-31 00:00:00 | 2002-10-31 00:00:00 | 2002-01-31 00:00:00 | 2002-10-31 00:00:00 | 2003-01-30 00:00:00 | 2003-04-30 00:00:00 | 2003-07-26 00:00:00 | 2003-04-30 00:00:00 | 2003-07-31 00:00:00 | 2004-02-02 00:00:00 | 2003-10-30 00:00:00 | 2003-07-31 00:00:00 | 2003-10-31 00:00:00 | 2004-08-01 00:00:00 | 2004-02-02 00:00:00 | 2004-04-30 00:00:00 | 2004-04-30 00:00:00 | 2004-11-01 00:00:00 | 2004-08-02 00:00:00 | 2005-01-30 00:00:00 | 2004-11-01 00:00:00 | 2005-01-19 00:00:00 | 2005-01-31 00:00:00 | 2005-07-30 00:00:00 | 2005-05-01 00:00:00 | 2005-10-29 00:00:00 | 2006-01-31 00:00:00 | 2006-01-31 00:00:00 | 2006-04-30 00:00:00 | 2006-07-30 00:00:00 | 2006-10-30 00:00:00 | 2006-12-26 00:00:00 | 2007-01-29 00:00:00 | 2007-04-18 00:00:00 | 2006-12-29 00:00:00 | 2007-07-25 00:00:00 | 2008-01-26 00:00:00 | 2007-10-19 00:00:00 | 2013-07-29 00:00:00 | 2012-12-31 00:00:00 | 2015-01-20 00:00:00 | 2015-02-09 00:00:00 | 2015-07-27 00:00:00 | 2014-07-25 00:00:00 | 2013-10-31 00:00:00 | 2015-04-21 00:00:00 | 2015-01-23 00:00:00 | 2015-01-08 00:00:00 | 2014-12-12 00:00:00 | 2014-12-19 00:00:00 | 2014-10-22 00:00:00 | 2014-10-22 00:00:00 | 2008-04-25 00:00:00 | 2008-08-06 00:00:00 | 2008-07-29 00:00:00 | 2008-07-29 00:00:00 | 2008-10-31 00:00:00 | 2009-01-23 00:00:00 | 2009-02-02 00:00:00 | 2009-04-30 00:00:00 | 2009-07-31 00:00:00 | 2009-08-27 00:00:00 | 2009-11-02 00:00:00 | 2010-01-31 00:00:00 | 2010-04-30 00:00:00 | 2010-08-02 00:00:00 | 2010-10-27 00:00:00 | 2010-12-16 00:00:00 | 2010-12-31 00:00:00 | 2011-01-24 00:00:00 | 2011-01-20 00:00:00 | 2011-01-20 00:00:00 | 2011-01-03 00:00:00 | 2010-12-20 00:00:00 | 2010-12-29 00:00:00 | 2011-07-25 00:00:00 | 2011-10-31 00:00:00 | 2012-01-30 00:00:00 | 2012-01-30 00:00:00 | 2012-01-30 00:00:00 | 2012-01-30 00:00:00 | 2011-04-25 00:00:00 | 2012-07-26 00:00:00 | 2012-04-27 00:00:00 | 2014-01-31 00:00:00 | 2014-12-04 00:00:00 | 2014-12-12 00:00:00 | 2014-12-05 00:00:00 | 2015-01-07 00:00:00 | 2012-12-17 00:00:00 | 2012-10-26 00:00:00 | 2012-10-25 00:00:00 | 2012-12-24 00:00:00 | 2012-12-19 00:00:00 | 2013-01-17 00:00:00 | 2013-01-29 00:00:00 | 2012-12-17 00:00:00 | 2014-04-25 00:00:00 | 2013-05-01 00:00:00 | 2013-03-06 00:00:00 | 2013-01-17 00:00:00 | 2013-03-05 00:00:00 | 2013-04-29 00:00:00 | 2015-05-08 00:00:00 | 2015-05-07 00:00:00 | 2015-07-29 00:00:00 | 2016-01-24 00:00:00 | 2022-04-28 00:00:00 | 2022-06-20 00:00:00 | 2022-06-23 00:00:00 | 2022-07-29 00:00:00 | 2022-03-17 00:00:00 | 2015-10-27 00:00:00 | 2022-10-31 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10005 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10002 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10002 | 10001 | 10001 | 10005 | 10001 | 10002 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10002 | 10001 | 10005 | 10001 | 10001 | 10002 | 10002 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10002 | 10001 | 10001 | 10005 | 10001 | 10006 | 10002 | 10006 | 10001 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1995 | 1999 | 1995 | 1999 | 1997 | 1999 | 1997 | 1995 | 1997 | 1997 | 1997 | 1995 | 1997 | 1997 | 1995 | 1997 | 1997 | 1997 | 1997 | 1995 | 1995 | 1995 | 1995 | 1999 | 1999 | 1999 | 1999 | 2001 | 2001 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2001 | 2001 | 2001 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2005 | 2007 | 2007 | 2007 | 2007 | 2007 | 2013 | 2013 | 2015 | 2015 | 2015 | 2013 | 2013 | 2015 | 2013 | 2015 | 2015 | 2015 | 2013 | 2013 | 2007 | 2007 | 2007 | 2007 | 2007 | 2009 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2011 | 2009 | 2011 | 2011 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2015 | 2015 | 2015 | 2015 | 2013 | 2011 | 2011 | 2013 | 2013 | 2013 | 2011 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2015 | 2015 | 2015 | 2015 | 2021 | 2021 | 2021 | 2021 | 2021 | 2015 | 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | GGILMORE | * | JLEHMAN | YBONILLA | GKURIMOT | LTHIBAUL | YBONILLA | GPEREZ | MKIENG | LTHIBAUL | LTHIBAUL | * | * | * | * | LTHIBAUL | LTHIBAUL | GPEREZ | GPEREZ | CFLAGG | * | * | LTHIBAUL | LTHIBAUL | * | * | PBANFORD | * | LTHIBAUL | LTHIBAUL | COMPLETED | COMPLETED | COMPLETED | LTHIBAUL | MHOANG | COMPLETED | COMPLETED | LTHIBAUL | LTHIBAUL | COMPLETED | LTHIBAUL | COMPLETED | LTHIBAUL | LTHIBAUL | LTHIBAUL | COMPLETED | COMPLETED | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | * | LTHIBAUL | LTHIBAUL | PBANFORD | LTHIBAUL | LTHIBAUL | LTHIBAUL | AGLADNEY | SARRIAGA | YRODRIGU | PBANFORD | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | GKURIMOT | GKURIMOT | PBANFORD | ASAETERN | AGLADNEY | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | JINGRAM | PBANFORD | JINGRAM | MGUERRA | MGUERRA | YRODRIGU | MGUERRA | JINGRAM | ASAETERN | ASAETERN | ASAETERN | YRODRIGU | PBANFORD | AGLADNEY | CFLAGG | YRODRIGU | AGLADNEY | YRODRIGU | CFLAGG | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | PBANFORD | PBANFORD | PBANFORD | PBANFORD | SARRIAGA | AGLADNEY | AGLADNEY | PBANFORD | PBANFORD | PBANFORD | ASAETERN | SARRIAGA | AGLADNEY | ASAETERN | SARRIAGA | PBANFORD | SARRIAGA | ASAETERN | YRODRIGU | YRODRIGU | YRODRIGU | CAFILER | CAFILER | SARRIAGA | SARRIAGA | CAFILER | MMERCHANT | AGLADNEY | CAFILER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11002 | 11002 | 11003 | 11003 | 11003 | 11003 | 11003 | 11002 | 11002 | 11003 | 11003 | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 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 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1995-07-01 00:00:00 | 1999-01-01 00:00:00 | 1995-01-01 00:00:00 | 1999-07-01 00:00:00 | 1997-04-01 00:00:00 | 1999-04-01 00:00:00 | 1997-01-01 00:00:00 | 1996-10-01 00:00:00 | 1997-07-01 00:00:00 | 1998-04-01 00:00:00 | 1998-07-01 00:00:00 | 1995-04-01 00:00:00 | 1997-07-01 00:00:00 | 1997-07-01 00:00:00 | 1995-10-01 00:00:00 | 1997-10-01 00:00:00 | 1998-04-01 00:00:00 | 1998-10-01 00:00:00 | 1998-01-01 00:00:00 | 1995-04-01 00:00:00 | 1996-01-01 00:00:00 | 1996-04-01 00:00:00 | 1996-07-01 00:00:00 | 2000-01-01 00:00:00 | 1999-10-01 00:00:00 | 2000-04-01 00:00:00 | 2000-07-01 00:00:00 | 1900-01-01 00:00:00 | 2001-01-01 00:00:00 | 2000-10-01 00:00:00 | 1900-01-01 00:00:00 | None | 2001-07-01 00:00:00 | 2001-04-01 00:00:00 | 2001-04-01 00:00:00 | 2001-07-01 00:00:00 | 2001-10-01 00:00:00 | 2002-01-01 00:00:00 | 2001-10-01 00:00:00 | 2002-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2002-04-01 00:00:00 | 2002-07-01 00:00:00 | 2002-04-01 00:00:00 | 2002-07-01 00:00:00 | 2002-07-22 00:00:00 | 2002-04-01 00:00:00 | 1900-01-01 00:00:00 | 2002-08-01 00:00:00 | 2002-10-01 00:00:00 | 2002-08-01 00:00:00 | 2002-10-01 00:00:00 | 2003-01-01 00:00:00 | 2003-04-01 00:00:00 | 2003-01-01 00:00:00 | 2003-04-01 00:00:00 | 2003-10-01 00:00:00 | 2003-07-01 00:00:00 | 2003-04-01 00:00:00 | 2003-07-01 00:00:00 | 2004-04-01 00:00:00 | 2003-10-01 00:00:00 | 2004-01-01 00:00:00 | 2004-01-01 00:00:00 | 2004-07-01 00:00:00 | 2004-04-01 00:00:00 | 2004-10-01 00:00:00 | 2004-07-01 00:00:00 | 1900-01-01 00:00:00 | 2004-10-01 00:00:00 | 2005-04-01 00:00:00 | 2005-01-01 00:00:00 | 2005-07-01 00:00:00 | 2005-10-01 00:00:00 | 2005-07-01 00:00:00 | 2006-01-01 00:00:00 | 2006-04-01 00:00:00 | 2006-07-01 00:00:00 | 2006-12-26 00:00:00 | 2006-10-01 00:00:00 | 2007-01-01 00:00:00 | 1900-01-01 00:00:00 | 2007-04-01 00:00:00 | 2007-10-01 00:00:00 | 2007-07-01 00:00:00 | 2013-04-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-01-20 00:00:00 | 2015-04-01 00:00:00 | 2014-04-01 00:00:00 | 2013-07-01 00:00:00 | 2015-01-01 00:00:00 | 2014-10-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2014-04-01 00:00:00 | 2014-07-01 00:00:00 | 2008-01-01 00:00:00 | 1900-01-01 00:00:00 | 2008-04-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 | 2009-01-01 00:00:00 | 2009-04-01 00:00:00 | 1900-01-01 00:00:00 | 2009-07-01 00:00:00 | 2009-10-01 00:00:00 | 2010-01-01 00:00:00 | 2010-04-01 00:00:00 | 2010-07-01 00:00:00 | 2010-12-16 00:00:00 | 1900-01-01 00:00:00 | 2010-10-01 00:00:00 | 1900-01-01 00:00:00 | 2010-11-23 00:00:00 | 2010-07-01 00:00:00 | 2010-12-20 00:00:00 | 1900-01-01 00:00:00 | 2011-04-01 00:00:00 | 2011-07-01 00:00:00 | 2011-01-01 00:00:00 | 2011-07-01 00:00:00 | 2011-10-01 00:00:00 | 2011-04-01 00:00:00 | 2011-01-01 00:00:00 | 2012-04-01 00:00:00 | 2012-01-01 00:00:00 | 2013-10-01 00:00:00 | 2014-12-04 00:00:00 | 2014-12-12 00:00:00 | 2014-12-05 00:00:00 | 2014-11-13 00:00:00 | 2012-12-17 00:00:00 | 2012-04-01 00:00:00 | 2012-07-01 00:00:00 | 1900-01-01 00:00:00 | 2012-12-19 00:00:00 | 1900-01-01 00:00:00 | 2012-10-01 00:00:00 | 1900-01-01 00:00:00 | 2014-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-03-06 00:00:00 | 2012-12-31 00:00:00 | 1900-01-01 00:00:00 | 2013-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-01-20 00:00:00 | 1900-01-01 00:00:00 | 2015-10-01 00:00:00 | 2022-01-01 00:00:00 | 1900-01-01 00:00:00 | 2022-06-23 00:00:00 | 2022-04-01 00:00:00 | 1900-01-01 00:00:00 | 2015-07-01 00:00:00 | 2022-07-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1995-09-30 00:00:00 | 1999-03-31 00:00:00 | 1995-03-31 00:00:00 | 1999-09-30 00:00:00 | 1997-06-30 00:00:00 | 1999-06-30 00:00:00 | 1997-03-31 00:00:00 | 1996-12-31 00:00:00 | 1997-09-30 00:00:00 | 1998-06-30 00:00:00 | 1998-09-30 00:00:00 | 1995-06-30 00:00:00 | 1997-09-30 00:00:00 | 1997-09-30 00:00:00 | 1995-12-31 00:00:00 | 1997-12-31 00:00:00 | 1998-06-30 00:00:00 | 1998-12-31 00:00:00 | 1998-03-31 00:00:00 | 1995-06-30 00:00:00 | 1996-03-31 00:00:00 | 1996-06-30 00:00:00 | 1996-09-30 00:00:00 | 2000-03-31 00:00:00 | 1999-12-31 00:00:00 | 2000-06-30 00:00:00 | 2000-09-30 00:00:00 | 1900-01-01 00:00:00 | 2001-03-31 00:00:00 | 2000-12-31 00:00:00 | 1900-01-01 00:00:00 | None | 2001-09-30 00:00:00 | 2001-06-30 00:00:00 | 2001-06-30 00:00:00 | 2001-09-30 00:00:00 | 2001-12-31 00:00:00 | 2002-03-31 00:00:00 | 2001-12-31 00:00:00 | 2002-03-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2002-06-30 00:00:00 | 2002-07-31 00:00:00 | 2002-06-30 00:00:00 | 2002-07-31 00:00:00 | 2002-07-22 00:00:00 | 2002-06-30 00:00:00 | 1900-01-01 00:00:00 | 2002-09-30 00:00:00 | 2002-12-31 00:00:00 | 2002-09-30 00:00:00 | 2002-12-31 00:00:00 | 2003-03-31 00:00:00 | 2003-06-30 00:00:00 | 2003-03-31 00:00:00 | 2003-06-30 00:00:00 | 2003-12-31 00:00:00 | 2003-09-30 00:00:00 | 2003-06-30 00:00:00 | 2003-09-30 00:00:00 | 2004-06-30 00:00:00 | 2003-12-31 00:00:00 | 2004-03-31 00:00:00 | 2004-04-30 00:00:00 | 2004-09-30 00:00:00 | 2004-06-30 00:00:00 | 2004-12-31 00:00:00 | 2004-09-30 00:00:00 | 1900-01-01 00:00:00 | 2004-12-31 00:00:00 | 2005-06-30 00:00:00 | 2005-03-31 00:00:00 | 2005-09-30 00:00:00 | 2005-12-31 00:00:00 | 2005-09-30 00:00:00 | 2006-03-31 00:00:00 | 2006-06-30 00:00:00 | 2006-09-30 00:00:00 | 2006-12-26 00:00:00 | 2006-12-31 00:00:00 | 2007-03-31 00:00:00 | 1900-01-01 00:00:00 | 2007-06-30 00:00:00 | 2007-12-31 00:00:00 | 2007-09-30 00:00:00 | 2013-06-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-01-20 00:00:00 | 2015-06-30 00:00:00 | 2014-06-30 00:00:00 | 2013-09-30 00:00:00 | 2015-03-31 00:00:00 | 2014-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2014-06-30 00:00:00 | 2014-09-30 00:00:00 | 2008-03-31 00:00:00 | 1900-01-01 00:00:00 | 2008-06-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 | 2009-03-31 00:00:00 | 2009-06-30 00:00:00 | 1900-01-01 00:00:00 | 2009-09-30 00:00:00 | 2009-12-31 00:00:00 | 2010-03-31 00:00:00 | 2010-06-30 00:00:00 | 2010-09-30 00:00:00 | 2010-12-16 00:00:00 | 1900-01-01 00:00:00 | 2010-12-31 00:00:00 | 1900-01-01 00:00:00 | 2010-11-23 00:00:00 | 2010-09-30 00:00:00 | 2010-12-20 00:00:00 | 1900-01-01 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 2011-03-31 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00 | 2011-06-30 00:00:00 | 2011-03-31 00:00:00 | 2012-06-30 00:00:00 | 2012-03-31 00:00:00 | 2013-12-31 00:00:00 | 2014-12-04 00:00:00 | 2014-12-12 00:00:00 | 2014-12-05 00:00:00 | 2014-11-13 00:00:00 | 2012-12-17 00:00:00 | 2012-06-30 00:00:00 | 2012-09-30 00:00:00 | 1900-01-01 00:00:00 | 2012-12-19 00:00:00 | 1900-01-01 00:00:00 | 2012-12-31 00:00:00 | 1900-01-01 00:00:00 | 2014-03-31 00:00:00 | 2013-03-31 00:00:00 | 2013-03-06 00:00:00 | 2012-12-31 00:00:00 | 1900-01-01 00:00:00 | 2013-03-31 00:00:00 | 1900-01-01 00:00:00 | 2015-01-20 00:00:00 | 1900-01-01 00:00:00 | 2015-12-31 00:00:00 | 2022-03-31 00:00:00 | 1900-01-01 00:00:00 | 2022-06-23 00:00:00 | 2022-06-30 00:00:00 | 1900-01-01 00:00:00 | 2015-09-30 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 | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | None | None | 22001 | None | 22001 | None | None | None | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22006 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22006 | None | None | 22001 | 22006 | 22006 | 22006 | 22006 | 22006 | None | None | None | 22006 | 22006 | 22001 | None | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | None | 22001 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22001 | 22006 | 22001 | 22001 | 22006 | 22006 | None | 22006 | None | 22006 | None | 22006 | 22006 | 22001 | 22001 | None | 22006 | None | 22001 | None | 22006 | 22006 | None | 22006 | 22006 | None | 22006 | 22006 |
filer_id | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 2001 | 1999 | 1995 | 1997 | 2001 | 2003 | 2007 | 2011 | 2009 | 2005 | 2013 | 2015 | 2023 | 2021 | ||||||||||||||
interest_cd | 40312 | 40310 | 40310 | 40310 | 40312 | 40312 | 40312 | 40312 | 40312 | 40312 | 40312 | 40312 | 40303 | 40303 | ||||||||||||||
effect_date | 2001-01-01 00:00:00 | 1999-01-01 00:00:00 | 1995-01-01 00:00:00 | 1997-01-01 00:00:00 | 2002-08-30 00:00:00 | 2003-01-01 00:00:00 | 2007-01-01 00:00:00 | 2011-01-01 00:00:00 | 2009-01-01 00:00:00 | 2005-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-01-01 00:00:00 | 2023-01-01 00:00:00 | 2022-01-01 00:00:00 |
filer_id | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||||||||||||||||
active | Y | Y | Y | Y | Y | T | Y | Y | Y | Y | Y | Y | Y | T | N | Y | ||||||||||||||||
race | 0 | 0 | 0 | 0 | None | 0 | 0 | None | None | None | None | None | None | None | None | None | ||||||||||||||||
session_id | 1999 | 1995 | 1997 | 2001 | 2003 | 2001 | 2001 | 2005 | 2007 | 2011 | 2013 | 2009 | 2015 | 2015 | 2023 | 2021 | ||||||||||||||||
category | 0 | 0 | 0 | 0 | None | 0 | 0 | None | None | None | None | None | None | None | None | None | ||||||||||||||||
category_type | 0 | 0 | 0 | 0 | None | 0 | 0 | None | None | None | None | None | None | None | None | None | ||||||||||||||||
sub_category | 0 | 0 | 0 | 0 | None | 0 | 0 | None | None | None | None | None | None | None | None | None | ||||||||||||||||
effect_dt | 1999-01-01 00:00:00 | 1995-01-01 00:00:00 | 1997-01-01 00:00:00 | 2001-01-01 00:00:00 | 2003-01-01 00:00:00 | 2002-03-31 00:00:00 | 2002-06-26 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2011-01-01 00:00:00 | 2013-01-01 00:00:00 | 2009-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-12-31 00:00:00 | 2023-01-01 00:00:00 | 2022-01-01 00:00:00 | ||||||||||||||||
sub_category_type | 0 | 0 | 0 | 0 | None | 0 | 0 | None | None | None | None | None | None | None | None | None | ||||||||||||||||
election_type | 0 | 0 | 0 | 0 | None | 0 | 0 | None | None | None | None | None | None | None | None | None | ||||||||||||||||
sub_category_a | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||
nyq_dt | None | None | None | None | None | None | None | 2001-04-01 00:00:00 | 2001-04-01 00:00:00 | None | None | None | None | None | None | None | ||||||||||||||||
party_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||
county_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||
district_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1143158 | |
---|---|---|
xref_id | C01289 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | C01289 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_type | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | 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 | HUGHES ELECTRONICS CORPORATION | HUGHES ELECTRONICS CORPORATION | HUGHES ELECTRONICS CORPORATION | HUGHES ELECTRONICS CORPORATION | HUGHES ELECTRONICS CORPORATION | HUGHES ELECTRONICS CORPORATION | HUGHES ELECTRONICS CORPORATION | HUGHES ELECTRONICS CORPORATION | HUGHES ELECTRONICS CORPORATION | HUGHES ELECTRONICS CORPORATION | HUGHES ELECTRONICS CORPORATION | HUGHES ELECTRONICS CORPORATION | HUGHES ELECTRONICS CORPORATION | HUGHES ELECTRONICS CORPORATION | HUGHES ELECTRONICS CORPORATION | HUGHES ELECTRONICS CORPORATION | HUGHES ELECTRONICS CORPORATION | HUGHES ELECTRONICS CORPORATION | HUGHES ELECTRONICS CORPORATION | HUGHES ELECTRONICS CORPORATION | HUGHES ELECTRONICS CORPORATION | HUGHES ELECTRONICS CORPORATION | HUGHES ELECTRONICS CORPORATION | HUGHES ELECTRONICS CORPORATION | HUGHES ELECTRONICS CORPORATION | HUGHES ELECTRONICS CORPORATION | HUGHES ELECTRONICS CORPORATION | HUGHES ELECTRONICS CORPORATION | HUGHES ELECTRONICS CORPORATION | HUGHES ELECTRONICS CORPORATION | HUGHES ELECTRONICS CORPORATION | HUGHES ELECTRONICS CORPORATION | HUGHES ELECTRONICS CORPORATION | HUGHES ELECTRONICS CORPORATION | HUGHES ELECTRONICS CORPORATION | HUGHES ELECTRONICS CORPORATION | HUGHES ELECTRONICS CORPORATION | HUGHES ELECTRONICS CORPORATION | DIRECT TV GROUP, INC., THE | DIRECT TV GROUP, INC., THE | DIRECT TV GROUP, INC., THE | DIRECT TV GROUP, INC., THE | DIRECT TV GROUP, INC., THE | DIRECT TV GROUP, INC., THE | DIRECT TV GROUP, INC., THE | DIRECT TV GROUP, INC., THE | DIRECT TV GROUP, INC., THE | DIRECT TV GROUP, INC., THE | DIRECT TV GROUP, INC., THE | DIRECT TV GROUP, INC., THE | DIRECT TV GROUP, INC., THE | DIRECT TV GROUP, INC., THE | DIRECT TV GROUP, INC., THE | DIRECT TV GROUP, INC., THE | DIRECT TV GROUP, INC., THE | DIRECT TV GROUP, INC., THE | DIRECT TV GROUP, INC., THE | DIRECTV GROUP, INC., THE | DIRECTV GROUP, INC., THE | DIRECTV GROUP, INC., THE | DIRECTV GROUP, INC., THE | DIRECTV GROUP, INC., THE | DIRECTV GROUP, INC., THE | DIRECTV GROUP, INC., THE | DIRECTV GROUP, INC., THE | DIRECTV GROUP, INC., THE | DIRECTV GROUP, INC., THE | DIRECTV GROUP, INC., THE | DIRECTV GROUP, INC., THE | DIRECTV GROUP, INC., THE | DIRECTV GROUP, INC., THE | DIRECTV GROUP, INC., THE | DIRECTV GROUP, INC., THE | DIRECTV GROUP, INC., THE | DIRECTV GROUP, INC., THE | DIRECTV GROUP, INC., THE | DIRECTV GROUP, INC.; THE | DIRECTV GROUP, INC.; THE | DIRECTV GROUP, INC.; THE | DIRECTV GROUP, INC.; THE | DIRECTV GROUP, INC.; THE | DIRECTV GROUP, INC.; THE | DIRECTV GROUP, INC.; THE | DIRECTV GROUP, INC.; THE | DIRECTV GROUP, INC.; THE | DIRECTV GROUP, INC.; THE | DIRECTV GROUP, INC.; THE | DIRECTV GROUP, INC.; THE | DIRECTV GROUP, INC.; THE | DIRECTV GROUP, INC.; THE | DIRECTV GROUP, INC.; THE | DIRECTV GROUP, INC.; THE | DIRECTV GROUP, INC.; THE | DIRECTV GROUP, INC.; THE | DIRECTV GROUP, INC.; THE | DIRECTV GROUP, INC.; THE | DIRECTV GROUP, INC.; THE | DIRECTV GROUP, INC.; THE | DIRECTV GROUP, INC.; THE | DIRECTV GROUP, INC.; THE | DIRECTV GROUP, INC.; THE | DIRECTV GROUP, INC.; THE | DIRECTV GROUP, INC.; THE | DIRECTV GROUP, INC.; THE | DIRECTV GROUP, INC.; THE | DIRECTV GROUP, INC.; THE | DIRECTV GROUP, INC.; THE | DIRECTV GROUP, INC.; THE | DIRECTV GROUP, INC.; THE | DIRECTV GROUP, INC.; THE | DIRECTV GROUP, INC.; THE | DIRECTV GROUP, INC.; THE | DIRECTV GROUP, INC.; THE | DIRECTV GROUP, INC.; THE | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namf | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | EL SEGUNDO | Los Angeles | El Segundo | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | ALEXANDRIA | ALEXANDRIA | ALEXANDRIA | None | EL SUGUNDO | ARLINGTON | EL SUGUNDO | ARLINGTON | EL SEGUNDO | Los Angeles | El Segundo | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | ALEXANDRIA | ALEXANDRIA | ALEXANDRIA | None | EL SUGUNDO | ARLINGTON | EL SUGUNDO | ARLINGTON | EL SEGUNDO | Los Angeles | El Segundo | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | ALEXANDRIA | ALEXANDRIA | ALEXANDRIA | None | EL SUGUNDO | ARLINGTON | EL SUGUNDO | ARLINGTON | EL SEGUNDO | Los Angeles | El Segundo | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | ALEXANDRIA | ALEXANDRIA | ALEXANDRIA | None | EL SUGUNDO | ARLINGTON | EL SUGUNDO | ARLINGTON | EL SEGUNDO | Los Angeles | El Segundo | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | ALEXANDRIA | ALEXANDRIA | ALEXANDRIA | None | EL SUGUNDO | ARLINGTON | EL SUGUNDO | ARLINGTON | EL SEGUNDO | Los Angeles | El Segundo | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | ALEXANDRIA | ALEXANDRIA | ALEXANDRIA | None | EL SUGUNDO | ARLINGTON | EL SUGUNDO | ARLINGTON | EL SEGUNDO | Los Angeles | El Segundo | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | ALEXANDRIA | ALEXANDRIA | ALEXANDRIA | None | EL SUGUNDO | ARLINGTON | EL SUGUNDO | ARLINGTON | EL SEGUNDO | Los Angeles | El Segundo | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | ALEXANDRIA | ALEXANDRIA | ALEXANDRIA | None | EL SUGUNDO | ARLINGTON | EL SUGUNDO | ARLINGTON | EL SEGUNDO | Los Angeles | El Segundo | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | ALEXANDRIA | ALEXANDRIA | ALEXANDRIA | None | EL SUGUNDO | ARLINGTON | EL SUGUNDO | ARLINGTON | EL SEGUNDO | Los Angeles | El Segundo | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | ALEXANDRIA | ALEXANDRIA | ALEXANDRIA | None | EL SUGUNDO | ARLINGTON | EL SUGUNDO | ARLINGTON | EL SEGUNDO | Los Angeles | El Segundo | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | ALEXANDRIA | ALEXANDRIA | ALEXANDRIA | None | EL SUGUNDO | ARLINGTON | EL SUGUNDO | ARLINGTON | EL SEGUNDO | Los Angeles | El Segundo | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | EL SEGUNDO | ALEXANDRIA | ALEXANDRIA | ALEXANDRIA | None | EL SUGUNDO | ARLINGTON | EL SUGUNDO | ARLINGTON | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | VA | VA | VA | None | CA | VA | CA | VA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | VA | VA | VA | None | CA | VA | CA | VA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | VA | VA | VA | None | CA | VA | CA | VA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | VA | VA | VA | None | CA | VA | CA | VA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | VA | VA | VA | None | CA | VA | CA | VA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | VA | VA | VA | None | CA | VA | CA | VA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | VA | VA | VA | None | CA | VA | CA | VA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | VA | VA | VA | None | CA | VA | CA | VA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | VA | VA | VA | None | CA | VA | CA | VA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | VA | VA | VA | None | CA | VA | CA | VA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | VA | VA | VA | None | CA | VA | CA | VA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | VA | VA | VA | None | CA | VA | CA | VA | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
zip4 | 90245 | 900800028 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 22314 | 22314 | 22314 | 90245 | 22209 | 90245 | 22209 | 90245 | 900800028 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 22314 | 22314 | 22314 | 90245 | 22209 | 90245 | 22209 | 90245 | 900800028 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 22314 | 22314 | 22314 | 90245 | 22209 | 90245 | 22209 | 90245 | 900800028 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 22314 | 22314 | 22314 | 90245 | 22209 | 90245 | 22209 | 90245 | 900800028 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 22314 | 22314 | 22314 | 90245 | 22209 | 90245 | 22209 | 90245 | 900800028 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 22314 | 22314 | 22314 | 90245 | 22209 | 90245 | 22209 | 90245 | 900800028 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 22314 | 22314 | 22314 | 90245 | 22209 | 90245 | 22209 | 90245 | 900800028 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 22314 | 22314 | 22314 | 90245 | 22209 | 90245 | 22209 | 90245 | 900800028 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 22314 | 22314 | 22314 | 90245 | 22209 | 90245 | 22209 | 90245 | 900800028 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 22314 | 22314 | 22314 | 90245 | 22209 | 90245 | 22209 | 90245 | 900800028 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 22314 | 22314 | 22314 | 90245 | 22209 | 90245 | 22209 | 90245 | 900800028 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 90245 | 22314 | 22314 | 22314 | 90245 | 22209 | 90245 | 22209 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 3106629986 | 3105687825 | 3106629644 | None | 3106629986 | None | 3109640725 | None | 3109640725 | 3109640725 | 3109640725 | 7036841110 | 7036841110 | 7036841110 | 2028499002 | 2028499002 | 3106629986 | 3105687825 | 3106629644 | None | 3106629986 | None | 3109640725 | None | 3109640725 | 3109640725 | 3109640725 | 7036841110 | 7036841110 | 7036841110 | 2028499002 | 2028499002 | 3106629986 | 3105687825 | 3106629644 | None | 3106629986 | None | 3109640725 | None | 3109640725 | 3109640725 | 3109640725 | 7036841110 | 7036841110 | 7036841110 | 2028499002 | 2028499002 | 3106629986 | 3105687825 | 3106629644 | None | 3106629986 | None | 3109640725 | None | 3109640725 | 3109640725 | 3109640725 | 7036841110 | 7036841110 | 7036841110 | 2028499002 | 2028499002 | 3106629986 | 3105687825 | 3106629644 | None | 3106629986 | None | 3109640725 | None | 3109640725 | 3109640725 | 3109640725 | 7036841110 | 7036841110 | 7036841110 | 2028499002 | 2028499002 | 3106629986 | 3105687825 | 3106629644 | None | 3106629986 | None | 3109640725 | None | 3109640725 | 3109640725 | 3109640725 | 7036841110 | 7036841110 | 7036841110 | 2028499002 | 2028499002 | 3106629986 | 3105687825 | 3106629644 | None | 3106629986 | None | 3109640725 | None | 3109640725 | 3109640725 | 3109640725 | 7036841110 | 7036841110 | 7036841110 | 2028499002 | 2028499002 | 3106629986 | 3105687825 | 3106629644 | None | 3106629986 | None | 3109640725 | None | 3109640725 | 3109640725 | 3109640725 | 7036841110 | 7036841110 | 7036841110 | 2028499002 | 2028499002 | 3106629986 | 3105687825 | 3106629644 | None | 3106629986 | None | 3109640725 | None | 3109640725 | 3109640725 | 3109640725 | 7036841110 | 7036841110 | 7036841110 | 2028499002 | 2028499002 | 3106629986 | 3105687825 | 3106629644 | None | 3106629986 | None | 3109640725 | None | 3109640725 | 3109640725 | 3109640725 | 7036841110 | 7036841110 | 7036841110 | 2028499002 | 2028499002 | 3106629986 | 3105687825 | 3106629644 | None | 3106629986 | None | 3109640725 | None | 3109640725 | 3109640725 | 3109640725 | 7036841110 | 7036841110 | 7036841110 | 2028499002 | 2028499002 | 3106629986 | 3105687825 | 3106629644 | None | 3106629986 | None | 3109640725 | None | 3109640725 | 3109640725 | 3109640725 | 7036841110 | 7036841110 | 7036841110 | 2028499002 | 2028499002 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | [email protected] | None |
filer_id | 1143158 |
---|
filer_id | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
change_no | 0 | 12 | 6 | 8 | 9 | 13 | 7 | 14 | 16 | 15 | 17 | 20 | 21 | 23 | 22 | 24 | ||||||||||||||||
session_id | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2009 | 2013 | 2013 | 2015 | 2015 | 2015 | 2015 | 2015 | 2021 | ||||||||||||||||
log_dt | 2002-09-20 00:00:00 | 2002-09-20 00:00:00 | 2001-06-15 00:00:00 | 2002-04-16 00:00:00 | 2002-04-16 00:00:00 | 2002-09-24 00:00:00 | 2002-03-14 00:00:00 | 2009-08-27 00:00:00 | 2014-03-27 00:00:00 | 2013-03-05 00:00:00 | 2015-01-20 00:00:00 | 2015-09-30 00:00:00 | 2015-10-29 00:00:00 | 2016-02-25 00:00:00 | 2016-01-13 00:00:00 | 2022-03-17 00:00:00 | ||||||||||||||||
filer_type | 2 | 1 | 1 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||||||||||||||||
correction_flg | Y | None | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | None | ||||||||||||||||
action | ADDED | CHANGED | ADDED | DELETED | TERMINATED | ADDED | DELETED | ADDED | DELETED | ADDED | ADDED | DELETED | DELETED | DELETED | DELETED | CHANGED | ||||||||||||||||
attribute_changed | FIRM | RESPONSIBLE OFFICER | EMPLOYER | FIRM | EMPLOYER | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | RESPONSIBLE OFFICER | ||||||||||||||||
ethics_dt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||
interests | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||
filer_full_name | HUGHES ELECTRONICS CORPORATION | HUGHES ELECTRONICS CORPORATION | HUGHES ELECTRONICS CORPORATION | HUGHES ELECTRONICS CORPORATION | HUGHES ELECTRONICS CORPORATION | HUGHES ELECTRONICS CORPORATION | HUGHES ELECTRONICS | DIRECTV GROUP, INC.; THE | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV GROUP, INC. | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | DIRECTV, LLC | ||||||||||||||||
filer_city | None | None | El Segundo | None | None | El Segundo | None | El Segundo | None | Los Angeles | None | None | None | Los Angeles | Los Angeles | None | ||||||||||||||||
filer_st | None | None | CA | None | None | CA | None | CA | None | CA | None | None | None | CA | CA | None | ||||||||||||||||
filer_zip | None | None | 90245 | None | None | 90245 | None | 90245 | None | 900800028 | None | None | None | 900800028 | 900800028 | None | ||||||||||||||||
filer_phone | None | None | 3106629644 | None | None | 3106629644 | None | 3106629644 | None | 3105687825 | None | None | None | 3105687825 | 3105687825 | None | ||||||||||||||||
entity_type | 3 | 20 | 2 | 3 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 20 | ||||||||||||||||
entity_name | U.S. ADVOCACY | VICE PRESIDENT, CORPORATE COMMUNICATIONS GEORGE H. JAMISON | PILLSBURY WINTHROP LLP | STEFFES, FOLEY & LARDNER, INC. | HUGHES ELECTRONICS CORPORATION | SLOAT HIGGINS JENSEN & ASSOCIATES | PILLSBURY WINTHROP LLP | SLOAT HIGGINS JENSEN AND ASSOCIATES | U.S. ADVOCACY | PLATINUM ADVISORS, LLC | SLOAT HIGGINS JENSEN AND ASSOCIATES, LLC | SLOAT HIGGINS JENSEN AND ASSOCIATES, LLC | PLATINUM ADVISORS, LLC | PILLSBURY WINTHROP SHAW PITTMAN LLP | STRATEGIC GOVERNMENT AFFAIRS | ASSISTANT VICE PRESIDENT, STATE EXTERNAL AFFAIRS HAMLIN WADE | ||||||||||||||||
entity_city | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||
entity_st | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||
entity_zip | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||
entity_phone | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||
entity_id | 1147395 | 1248500 | None | 1147230 | 0 | None | 1147279 | None | 1147395 | None | 1147635 | 1147635 | 1147749 | None | None | 1446599 | ||||||||||||||||
responsible_officer | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||
effect_dt | 2002-08-30 00:00:00 | 2002-08-30 00:00:00 | 2001-05-30 00:00:00 | 2002-03-31 00:00:00 | 2002-03-31 00:00:00 | 2002-06-26 00:00:00 | 2002-02-28 00:00:00 | 2009-08-23 00:00:00 | 2013-12-31 00:00:00 | 2013-02-15 00:00:00 | 2015-01-01 00:00:00 | 2015-09-30 00:00:00 | 2015-09-30 00:00:00 | 2015-12-31 00:00:00 | 2015-12-31 00:00:00 | 2022-01-01 00:00:00 |
filer_id | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | 1143158 | |||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 771939_0.cal | 792776_0.cal | 96428.cal | 814046_0.cal | 839229_0.cal | 856792_1.cal | 856792_0.cal | 856807_0.cal | 856817_0.cal | 884768_0.cal | 911151_0.cal | 930830_0.cal | 944789_0.cal | 969327_0.cal | 990018_0.cal | 144098.cal | 224790.cal | 308835.cal | 455935.cal | |||||||||||||||||||
received_date | 2001-07-30 00:00:00 | 2001-10-31 00:00:00 | 2002-01-31 00:00:00 | 2002-01-31 00:00:00 | 2002-04-30 00:00:00 | 2002-09-26 00:00:00 | 2002-07-31 00:00:00 | 2002-07-31 00:00:00 | 2002-07-31 00:00:00 | 2002-10-31 00:00:00 | 2003-01-30 00:00:00 | 2003-04-30 00:00:00 | 2003-07-26 00:00:00 | 2003-10-30 00:00:00 | 2004-02-02 00:00:00 | 2004-04-30 00:00:00 | 2022-10-31 00:00:00 | 2022-05-02 00:00:00 | 2022-08-01 00:00:00 | |||||||||||||||||||
filing_directory | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/temp | /usr/users/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/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | |||||||||||||||||||
filing_id | 771939 | 792776 | None | 814046 | 839229 | 856792 | 856792 | 856807 | 856817 | 884768 | 911151 | 930830 | 944789 | 969327 | 990018 | None | None | None | None | |||||||||||||||||||
form_id | F635 | F635 | None | F635 | F635 | F635 | F635 | F635 | F606 | F635 | F635 | F635 | F635 | F635 | F635 | None | None | None | None | |||||||||||||||||||
receive_comment | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing did not pass validation | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing did not pass validation | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints |