acronym | AAM | |
---|---|---|
filer_id | 1147180 |
filer_id | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1112527 | 2011679 | 2041293 | 2059109 | 2079815 | 2116955 | 2162402 | 2205111 | 2415137 | 2470745 | 2508474 | 2269776 | 2338042 | 2497396 | 2549771 | |||||||||||||||
effect_dt | 1999-01-01 00:00:00 | 2001-01-22 00:00:00 | 2003-01-01 00:00:00 | 2003-10-27 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-01-01 00:00:00 | 2020-08-08 00:00:00 | 2023-01-01 00:00:00 | |||||||||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | |||||||||||||||
session_id | 1999 | 2001 | 2003 | 2003 | 2005 | 2007 | 2009 | 2011 | 2017 | 2019 | 2021 | 2013 | 2015 | 2019 | 2023 |
filer_id | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 499965 | 499114 | 500813 | 615710 | 616426 | 632677 | 628861 | 681416 | 665833 | 718633 | 708297 | 696052 | 704553 | 704570 | 706400 | 746410 | 753324 | 734285 | 795279 | 790325 | 772025 | 778516 | 814370 | 814382 | 838414 | 704553 | 821861 | 853798 | 861577 | 865433 | 842587 | 704553 | 853798 | 875643 | 892544 | 906823 | 898218 | 884959 | 896593 | 896608 | 897122 | 927263 | 928835 | 896608 | 934388 | 947934 | 941404 | 969464 | 971190 | 896608 | 970272 | 955288 | 1027307 | 990463 | 1016043 | 1014158 | 993404 | 1030386 | 1062027 | 1068233 | 1076676 | 1059281 | 1079702 | 1061163 | 1088348 | 1116248 | 1104745 | 1144728 | 1130842 | 1166606 | 1130842 | 1189487 | 1224182 | 1214895 | 1233293 | 1234511 | 1260878 | 1260878 | 1283947 | 1764999 | 1782107 | 1965928 | 1950281 | 1978074 | 1799251 | 1936218 | 1945093 | 1951748 | 1909438 | 1296522 | 1329135 | 1309545 | 1330533 | 1326356 | 1347752 | 1372427 | 1384292 | 1386736 | 1409774 | 1395856 | 1416859 | 1434018 | 1419272 | 1463446 | 1450963 | 1483766 | 1503338 | 1540680 | 1551414 | 1551639 | 1556250 | 1564202 | 1568499 | 1590708 | 1605516 | 1620495 | 1636315 | 1655495 | 1829027 | 1829953 | 1815358 | 1674771 | 1918840 | 1923793 | 1922491 | 1718373 | 1708652 | 1872369 | 1636315 | 1674771 | 1655495 | 1708652 | 1742218 | 1721846 | 1725504 | 1738479 | 1734852 | 1725513 | 1738142 | 1842784 | 1764999 | 1997082 | 2330391 | 2241383 | 2341375 | 2393164 | 2578302 | 2528170 | 2334758 | 2486334 | 2342806 | 2349149 | 2011940 | 2026197 | 2037366 | 2063155 | 2102052 | 2124294 | 2117227 | 2117127 | 2136909 | 2139956 | 2131023 | 2142520 | 2158194 | 2176394 | 2158194 | 2157954 | 2380172 | 2158194 | 2536505 | 2275188 | 2317397 | 2441943 | 2471191 | 2540675 | 2583373 | 2193337 | 2211085 | 2541615 | 2418965 | 2673603 | 2703098 | 2550792 | 2621326 | 2599588 | 2589415 | 2571588 | 2641261 | 2747563 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 158 | 157 | 159 | 160 | 160 | None | None | 163 | None | 164 | None | 163 | 165 | 165 | None | 165 | 165 | 164 | None | 167 | 166 | None | 168 | None | 169 | 169 | None | 170 | None | None | None | 171 | 170 | None | None | 172 | None | 171 | None | 172 | 172 | None | 173 | 175 | None | 174 | None | 175 | None | 176 | None | None | 178 | 176 | None | 177 | None | None | None | 180 | 180 | 179 | None | None | None | 182 | 181 | 184 | 183 | 185 | 183 | 186 | 188 | 187 | None | 188 | 189 | 189 | 190 | 213 | 214 | 221 | None | 222 | 215 | 220 | None | None | 219 | 191 | 193 | 192 | None | None | 194 | 195 | 196 | 196 | None | 196 | None | 198 | 197 | 200 | 199 | 201 | 202 | 203 | 204 | None | 204 | None | 204 | 205 | 206 | 207 | 208 | 209 | 217 | None | 216 | 210 | 212 | 220 | 221 | 212 | 211 | 218 | 208 | 210 | 209 | 211 | None | 212 | 213 | None | None | 213 | 212 | 217 | 213 | 223 | 236 | 233 | None | 238 | 245 | 243 | 236 | 242 | None | 236 | 224 | None | 225 | 226 | 227 | None | 228 | 229 | None | None | 228 | 229 | 229 | 230 | 229 | None | 237 | 229 | 244 | 234 | 235 | 240 | 241 | 244 | None | 231 | 232 | 244 | 239 | 249 | 250 | 244 | 247 | 246 | None | None | 248 | 251 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F603 | F602 | F603 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F605 | F635 | F603 | F635 | F635 | F635 | F605 | F635 | F603 | F635 | F690 | F635 | F635 | F602 | F635 | F603 | F603 | F602 | F635 | F635 | F603 | F635 | F635 | F605 | F635 | F635 | F603 | F605 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F602 | F602 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F602 | F602 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F602 | F602 | F602 | F602 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F602 | F635 | F635 | F635 | F602 | F602 | F602 | F602 | F602 | F635 | F602 | F635 | F635 | F635 | F602 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 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 | 1 | 0 | 0 | 0 | 2 | 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 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 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 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1999-07-15 00:00:00 | 1999-04-07 00:00:00 | 1999-10-25 00:00:00 | 2000-01-31 00:00:00 | 2000-01-27 00:00:00 | 2000-05-01 00:00:00 | 2000-05-01 00:00:00 | 2000-10-31 00:00:00 | 2000-08-08 00:00:00 | 2001-01-31 00:00:00 | 2001-01-02 00:00:00 | 2000-10-30 00:00:00 | 2001-01-02 00:00:00 | 2001-01-02 00:00:00 | 2001-01-02 00:00:00 | 2001-04-30 00:00:00 | 2001-04-30 00:00:00 | 2001-01-30 00:00:00 | 2001-10-24 00:00:00 | 2001-10-29 00:00:00 | 2001-07-30 00:00:00 | 2001-07-30 00:00:00 | 2002-01-31 00:00:00 | 2002-01-31 00:00:00 | 2002-04-29 00:00:00 | 2002-03-01 00:00:00 | 2002-01-31 00:00:00 | 2002-07-31 00:00:00 | 2002-07-29 00:00:00 | 2002-08-27 00:00:00 | 2002-04-29 00:00:00 | 2002-08-29 00:00:00 | 2002-07-30 00:00:00 | 2002-07-31 00:00:00 | 2002-10-30 00:00:00 | 2003-01-27 00:00:00 | 2002-12-20 00:00:00 | 2002-10-31 00:00:00 | 2002-12-16 00:00:00 | 2002-12-18 00:00:00 | 2002-12-20 00:00:00 | 2003-01-27 00:00:00 | 2003-04-24 00:00:00 | 2003-07-20 00:00:00 | 2003-04-23 00:00:00 | 2003-07-31 00:00:00 | 2003-07-11 00:00:00 | 2003-10-31 00:00:00 | 2003-10-30 00:00:00 | 2003-11-03 00:00:00 | 2003-10-30 00:00:00 | 2003-07-31 00:00:00 | 2004-07-28 00:00:00 | 2004-02-02 00:00:00 | 2004-04-30 00:00:00 | 2004-04-30 00:00:00 | 2004-02-02 00:00:00 | 2004-07-28 00:00:00 | 2004-11-15 00:00:00 | 2004-12-29 00:00:00 | 2005-01-27 00:00:00 | 2004-11-01 00:00:00 | 2005-01-26 00:00:00 | 2004-11-01 00:00:00 | 2004-12-28 00:00:00 | 2005-07-28 00:00:00 | 2005-04-29 00:00:00 | 2006-01-26 00:00:00 | 2005-10-26 00:00:00 | 2006-04-28 00:00:00 | 2006-01-31 00:00:00 | 2006-07-28 00:00:00 | 2006-12-21 00:00:00 | 2006-10-30 00:00:00 | 2006-12-20 00:00:00 | 2007-01-29 00:00:00 | 2007-04-27 00:00:00 | 2007-07-31 00:00:00 | 2007-07-31 00:00:00 | 2013-07-11 00:00:00 | 2013-07-31 00:00:00 | 2015-04-30 00:00:00 | 2015-01-02 00:00:00 | 2015-07-27 00:00:00 | 2013-10-30 00:00:00 | 2015-02-02 00:00:00 | 2014-12-30 00:00:00 | 2014-12-17 00:00:00 | 2014-10-30 00:00:00 | 2007-10-30 00:00:00 | 2008-04-30 00:00:00 | 2008-01-30 00:00:00 | 2008-04-28 00:00:00 | 2008-04-01 00:00:00 | 2008-07-29 00:00:00 | 2008-10-27 00:00:00 | 2008-12-18 00:00:00 | 2008-12-30 00:00:00 | 2008-12-31 00:00:00 | 2009-01-30 00:00:00 | 2008-12-17 00:00:00 | 2009-07-27 00:00:00 | 2009-04-28 00:00:00 | 2010-01-29 00:00:00 | 2009-10-28 00:00:00 | 2010-04-28 00:00:00 | 2010-07-26 00:00:00 | 2010-11-01 00:00:00 | 2010-12-17 00:00:00 | 2010-12-16 00:00:00 | 2010-12-31 00:00:00 | 2010-12-30 00:00:00 | 2011-01-28 00:00:00 | 2011-04-29 00:00:00 | 2011-07-28 00:00:00 | 2011-10-27 00:00:00 | 2012-01-31 00:00:00 | 2012-04-27 00:00:00 | 2014-03-14 00:00:00 | 2014-03-17 00:00:00 | 2014-01-29 00:00:00 | 2012-07-26 00:00:00 | 2014-12-18 00:00:00 | 2015-01-08 00:00:00 | 2015-01-02 00:00:00 | 2012-12-19 00:00:00 | 2012-10-31 00:00:00 | 2014-07-31 00:00:00 | 2013-01-31 00:00:00 | 2013-01-31 00:00:00 | 2013-01-31 00:00:00 | 2013-01-31 00:00:00 | 2012-12-18 00:00:00 | 2012-12-31 00:00:00 | 2013-01-14 00:00:00 | 2013-01-15 00:00:00 | 2012-12-31 00:00:00 | 2013-01-14 00:00:00 | 2013-01-31 00:00:00 | 2014-04-28 00:00:00 | 2013-04-30 00:00:00 | 2015-10-30 00:00:00 | 2018-12-28 00:00:00 | 2018-04-30 00:00:00 | 2019-01-11 00:00:00 | 2019-07-25 00:00:00 | 2021-04-28 00:00:00 | 2020-10-30 00:00:00 | 2019-01-16 00:00:00 | 2020-07-31 00:00:00 | 2018-12-28 00:00:00 | 2019-01-31 00:00:00 | 2016-02-01 00:00:00 | 2016-03-18 00:00:00 | 2016-05-02 00:00:00 | 2016-08-01 00:00:00 | 2016-10-31 00:00:00 | 2016-12-21 00:00:00 | 2017-01-04 00:00:00 | 2017-01-04 00:00:00 | 2016-12-30 00:00:00 | 2017-01-19 00:00:00 | 2017-01-31 00:00:00 | 2017-03-01 00:00:00 | 2017-05-01 00:00:00 | 2017-07-31 00:00:00 | 2017-07-31 00:00:00 | 2017-03-06 00:00:00 | 2019-04-30 00:00:00 | 2018-03-06 00:00:00 | 2020-12-09 00:00:00 | 2018-07-31 00:00:00 | 2018-10-30 00:00:00 | 2020-01-31 00:00:00 | 2020-04-30 00:00:00 | 2020-12-30 00:00:00 | 2021-01-04 00:00:00 | 2017-10-31 00:00:00 | 2018-01-31 00:00:00 | 2020-12-31 00:00:00 | 2019-10-31 00:00:00 | 2022-04-28 00:00:00 | 2022-07-28 00:00:00 | 2021-01-29 00:00:00 | 2021-10-28 00:00:00 | 2021-07-29 00:00:00 | 2021-02-19 00:00:00 | 2020-12-30 00:00:00 | 2022-01-28 00:00:00 | 2022-10-31 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10005 | 10005 | 10006 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10002 | 10005 | 10002 | 10005 | 10005 | 10005 | 10002 | 10001 | 10006 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10002 | 10005 | 10001 | 10005 | 10001 | 10005 | 10002 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10002 | 10001 | 10002 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10002 | 10002 | 10002 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10002 | 10005 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 2001 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2001 | 2003 | 2003 | 2003 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2003 | 2003 | 2005 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2005 | 2007 | 2005 | 2007 | 2007 | 2007 | 2013 | 2013 | 2015 | 2015 | 2015 | 2013 | 2013 | 2015 | 2015 | 2013 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2009 | 2009 | 2009 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2011 | 2011 | 2011 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2013 | 2013 | 2011 | 2015 | 2015 | 2015 | 2013 | 2011 | 2013 | 2011 | 2011 | 2011 | 2011 | 2013 | 2013 | 2011 | 2011 | 2013 | 2013 | 2011 | 2013 | 2013 | 2015 | 2019 | 2017 | 2019 | 2019 | 2021 | 2019 | 2019 | 2019 | 2019 | 2017 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2017 | 2021 | 2017 | 2017 | 2019 | 2019 | 2021 | 2021 | 2017 | 2017 | 2021 | 2019 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | * | YBONILLA | TTHAM | * | DHORRELL | * | CFLAGG | YBONILLA | YRODRIGU | YRODRIGU | GGILMORE | * | DBARRICK | YBONILLA | LTHIBAUL | * | * | GPEREZ | * | GPEREZ | * | YRODRIGU | LTHIBAUL | * | LTHIBAUL | GPEREZ | LTHIBAUL | YRODRIGU | * | LTHIBAUL | LTHIBAUL | COMPLETED | PBANFORD | * | GPEREZ | YRODRIGU | YRODRIGU | LTHIBAUL | COMPLETED | YRODRIGU | LTHIBAUL | COMPLETED | CFLAGG | COMPLETED | LTHIBAUL | YRODRIGU | CFLAGG | LTHIBAUL | COMPLETED | COMPLETED | LTHIBAUL | COMPLETED | LTHIBAUL | LTHIBAUL | CFLAGG | YRODRIGU | COMPLETED | COMPLETED | LTHIBAUL | LTHIBAUL | CFLAGG | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | YRODRIGU | LTHIBAUL | GPEREZ | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | AGLADNEY | AGLADNEY | AGLADNEY | GPEREZ | MPACHECO | AGLADNEY | MPACHECO | ASAETERN | SARRIAGA | AGLADNEY | LTHIBAUL | LTHIBAUL | LTHIBAUL | YRODRIGU | YRODRIGU | YRODRIGU | MGUERRA | YRODRIGU | YRODRIGU | SARRIAGA | JGRISSUM | PBANFORD | JGRISSUM | JGRISSUM | MGUERRA | MGUERRA | ASAETERN | ASAETERN | ASAETERN | YRODRIGU | DMCCASTL | YRODRIGU | DMCCASTL | AGLADNEY | ASAETERN | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | YRODRIGU | YRODRIGU | AGLADNEY | AGLADNEY | SARRIAGA | ASAETERN | YRODRIGU | PBANFORD | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | PBANFORD | YRODRIGU | YRODRIGU | GKURIMOT | GPEREZ | YRODRIGU | ASAETERN | ASAETERN | AGLADNEY | MPACHECO | YRODRIGU | AGLADNEY | PBANFORD | SUSHAKOV | CHATRIDGE | MKIRKHAM | PBANFORD | MKIRKHAM | YRODRIGU | AGLADNEY | AGLADNEY | YRODRIGU | JINGRAM | AGLADNEY | AGLADNEY | PBANFORD | GPEREZ | PBANFORD | GPEREZ | PBANFORD | AGLADNEY | GPEREZ | AGLADNEY | AGLADNEY | AGLADNEY | GPEREZ | SUSHAKOV | CAFILER | SARRIAGA | AGLADNEY | AGLADNEY | VUKSTINA | VUKSTINA | CVANLIEW | MMERCHANT | AGLADNEY | AGLADNEY | MMERCHANT | VUKSTINA | CAFILER | CAFILER | GTAYLOR | GTAYLOR | CHATRIDGE | SARRIAGA | CVANLIEW | CHATRIDGE | CAFILER | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11002 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11002 | 11003 | 11002 | 11003 | 11002 | 11003 | 11003 | 11003 | 11002 | 11003 | 11003 | 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 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 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 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 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 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1999-04-01 00:00:00 | 1999-01-01 00:00:00 | 1999-07-01 00:00:00 | 1999-10-01 00:00:00 | 1999-10-01 00:00:00 | 2000-01-01 00:00:00 | 2000-01-01 00:00:00 | 2000-07-01 00:00:00 | 2000-04-01 00:00:00 | 2000-10-01 00:00:00 | 1900-01-01 00:00:00 | 2000-07-01 00:00:00 | 2001-01-02 00:00:00 | 2001-01-02 00:00:00 | 1900-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2000-10-01 00:00:00 | 2001-07-01 00:00:00 | 2001-07-01 00:00:00 | 2001-04-01 00:00:00 | 2001-04-01 00:00:00 | 2001-10-01 00:00:00 | 1900-01-01 00:00:00 | 2002-01-01 00:00:00 | 2002-03-01 00:00:00 | 2001-10-01 00:00:00 | 2002-04-01 00:00:00 | 2002-04-01 00:00:00 | 1900-01-01 00:00:00 | 2002-01-01 00:00:00 | 2002-08-29 00:00:00 | 2002-04-01 00:00:00 | 2002-04-01 00:00:00 | 2002-07-01 00:00:00 | 2002-10-01 00:00:00 | 1900-01-01 00:00:00 | 2002-07-01 00:00:00 | 1900-01-01 00:00:00 | 2002-12-18 00:00:00 | 2002-12-20 00:00:00 | 2002-10-01 00:00:00 | 2003-01-01 00:00:00 | 2003-07-20 00:00:00 | 2003-01-01 00:00:00 | 2003-04-01 00:00:00 | 1900-01-01 00:00:00 | 2003-07-01 00:00:00 | 2003-07-01 00:00:00 | 2003-11-03 00:00:00 | 1900-01-01 00:00:00 | 2003-04-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 | 2003-10-01 00:00:00 | 2004-04-01 00:00:00 | 1900-01-01 00:00:00 | 2004-12-29 00:00:00 | 2004-10-01 00:00:00 | 2004-07-01 00:00:00 | 2004-10-01 00:00:00 | 2004-07-01 00:00:00 | 1900-01-01 00:00:00 | 2005-04-01 00:00:00 | 2005-01-01 00:00:00 | 2005-10-01 00:00:00 | 2005-07-01 00:00:00 | 2006-01-01 00:00:00 | 2005-07-01 00:00:00 | 2006-04-01 00:00:00 | 2006-12-20 00:00:00 | 2006-07-01 00:00:00 | 1900-01-01 00:00:00 | 2006-10-01 00:00:00 | 2007-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-04-01 00:00:00 | 2013-01-01 00:00:00 | 2013-04-01 00:00:00 | 2015-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-04-01 00:00:00 | 2013-07-01 00:00:00 | 2014-10-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2014-07-01 00:00:00 | 2007-07-01 00:00:00 | 2008-01-01 00:00:00 | 2007-10-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2008-04-01 00:00:00 | 2008-07-01 00:00:00 | 2008-12-18 00:00:00 | 2008-12-30 00:00:00 | 1900-01-01 00:00:00 | 2008-10-01 00:00:00 | 1900-01-01 00:00:00 | 2009-04-01 00:00:00 | 2009-01-01 00:00:00 | 2009-10-01 00:00:00 | 2009-07-01 00:00:00 | 2010-01-01 00:00:00 | 2010-04-01 00:00:00 | 2010-07-01 00:00:00 | 2010-12-15 00:00:00 | 1900-01-01 00:00:00 | 2010-12-31 00:00:00 | 1900-01-01 00:00:00 | 2010-10-01 00:00:00 | 2011-01-01 00:00:00 | 2011-04-01 00:00:00 | 2011-07-01 00:00:00 | 2011-10-01 00:00:00 | 2012-01-01 00:00:00 | 2014-03-14 00:00:00 | 1900-01-01 00:00:00 | 2013-10-01 00:00:00 | 2012-04-01 00:00:00 | 2012-12-15 00:00:00 | 2014-12-30 00:00:00 | 2015-01-02 00:00:00 | 2012-12-15 00:00:00 | 2012-07-01 00:00:00 | 2014-04-01 00:00:00 | 2011-10-01 00:00:00 | 2012-04-01 00:00:00 | 2012-01-01 00:00:00 | 2012-07-01 00:00:00 | 1900-01-01 00:00:00 | 2012-12-31 00:00:00 | 2013-01-14 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2013-01-14 00:00:00 | 2012-10-01 00:00:00 | 2014-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-07-01 00:00:00 | 2018-12-30 00:00:00 | 2018-01-01 00:00:00 | 1900-01-01 00:00:00 | 2019-04-01 00:00:00 | 2021-01-01 00:00:00 | 2020-07-01 00:00:00 | 2018-12-31 00:00:00 | 2020-04-01 00:00:00 | 1900-01-01 00:00:00 | 2018-10-01 00:00:00 | 2015-10-01 00:00:00 | 1900-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-04-01 00:00:00 | 2016-07-01 00:00:00 | 1900-01-01 00:00:00 | 2016-12-31 00:00:00 | 2017-01-04 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2016-10-01 00:00:00 | 2017-03-01 00:00:00 | 2017-01-01 00:00:00 | 2017-04-01 00:00:00 | 2017-01-01 00:00:00 | 1900-01-01 00:00:00 | 2019-01-01 00:00:00 | 2017-01-01 00:00:00 | 2020-12-09 00:00:00 | 2018-04-01 00:00:00 | 2018-07-01 00:00:00 | 2019-10-01 00:00:00 | 2020-01-01 00:00:00 | 2020-12-31 00:00:00 | 1900-01-01 00:00:00 | 2017-07-01 00:00:00 | 2017-10-01 00:00:00 | 2020-12-31 00:00:00 | 2019-07-01 00:00:00 | 2022-01-01 00:00:00 | 2022-04-01 00:00:00 | 2020-10-01 00:00:00 | 2021-07-01 00:00:00 | 2021-04-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-10-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1999-06-30 00:00:00 | 1999-03-31 00:00:00 | 1999-09-30 00:00:00 | 1999-12-31 00:00:00 | 1999-12-31 00:00:00 | 2000-03-31 00:00:00 | 2000-03-31 00:00:00 | 2000-09-30 00:00:00 | 2000-06-30 00:00:00 | 2000-12-31 00:00:00 | 1900-01-01 00:00:00 | 2000-09-30 00:00:00 | 2001-01-02 00:00:00 | 2001-01-02 00:00:00 | 1900-01-01 00:00:00 | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 | 2000-12-31 00:00:00 | 2001-09-30 00:00:00 | 2001-09-30 00:00:00 | 2001-06-30 00:00:00 | 2001-06-30 00:00:00 | 2001-12-31 00:00:00 | 1900-01-01 00:00:00 | 2002-03-31 00:00:00 | 2002-03-01 00:00:00 | 2001-12-31 00:00:00 | 2002-06-30 00:00:00 | 2002-06-30 00:00:00 | 1900-01-01 00:00:00 | 2002-03-31 00:00:00 | 2002-08-29 00:00:00 | 2002-06-30 00:00:00 | 2002-06-30 00:00:00 | 2002-09-30 00:00:00 | 2002-12-31 00:00:00 | 1900-01-01 00:00:00 | 2002-09-30 00:00:00 | 1900-01-01 00:00:00 | 2002-12-18 00:00:00 | 2002-12-20 00:00:00 | 2002-12-31 00:00:00 | 2003-03-31 00:00:00 | 2003-07-20 00:00:00 | 2003-03-31 00:00:00 | 2003-06-30 00:00:00 | 1900-01-01 00:00:00 | 2003-09-30 00:00:00 | 2003-09-30 00:00:00 | 2003-11-03 00:00:00 | 1900-01-01 00:00:00 | 2003-06-30 00:00:00 | 2004-06-30 00:00:00 | 2003-12-31 00:00:00 | 2004-03-31 00:00:00 | 2004-03-31 00:00:00 | 2003-12-31 00:00:00 | 2004-06-30 00:00:00 | 1900-01-01 00:00:00 | 2004-12-29 00:00:00 | 2004-12-31 00:00:00 | 2004-09-30 00:00:00 | 2004-12-31 00:00:00 | 2004-09-30 00:00:00 | 1900-01-01 00:00:00 | 2005-06-30 00:00:00 | 2005-03-31 00:00:00 | 2005-12-31 00:00:00 | 2005-09-30 00:00:00 | 2006-03-31 00:00:00 | 2005-09-30 00:00:00 | 2006-06-30 00:00:00 | 2006-12-20 00:00:00 | 2006-09-30 00:00:00 | 1900-01-01 00:00:00 | 2006-12-31 00:00:00 | 2007-03-31 00:00:00 | 2007-03-31 00:00:00 | 2007-06-30 00:00:00 | 2013-03-31 00:00:00 | 2013-06-30 00:00:00 | 2015-03-31 00:00:00 | 1900-01-01 00:00:00 | 2015-06-30 00:00:00 | 2013-09-30 00:00:00 | 2014-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2014-09-30 00:00:00 | 2007-09-30 00:00:00 | 2008-03-31 00:00:00 | 2007-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2008-06-30 00:00:00 | 2008-09-30 00:00:00 | 2008-12-18 00:00:00 | 2008-12-30 00:00:00 | 1900-01-01 00:00:00 | 2008-12-31 00:00:00 | 1900-01-01 00:00:00 | 2009-06-30 00:00:00 | 2009-03-31 00:00:00 | 2009-12-31 00:00:00 | 2009-09-30 00:00:00 | 2010-03-31 00:00:00 | 2010-06-30 00:00:00 | 2010-09-30 00:00:00 | 2010-12-15 00:00:00 | 1900-01-01 00:00:00 | 2010-12-31 00:00:00 | 1900-01-01 00:00:00 | 2010-12-31 00:00:00 | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00 | 2012-03-31 00:00:00 | 2014-03-14 00:00:00 | 1900-01-01 00:00:00 | 2013-12-31 00:00:00 | 2012-06-30 00:00:00 | 2012-12-15 00:00:00 | 2014-12-30 00:00:00 | 2015-01-02 00:00:00 | 2012-12-15 00:00:00 | 2012-09-30 00:00:00 | 2014-06-30 00:00:00 | 2011-12-31 00:00:00 | 2012-06-30 00:00:00 | 2012-03-31 00:00:00 | 2012-09-30 00:00:00 | 1900-01-01 00:00:00 | 2012-12-31 00:00:00 | 2013-01-14 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2013-01-14 00:00:00 | 2012-12-31 00:00:00 | 2014-03-31 00:00:00 | 2013-03-31 00:00:00 | 2015-09-30 00:00:00 | 2018-12-30 00:00:00 | 2018-03-31 00:00:00 | 1900-01-01 00:00:00 | 2019-06-30 00:00:00 | 2021-03-31 00:00:00 | 2020-09-30 00:00:00 | 2018-12-31 00:00:00 | 2020-06-30 00:00:00 | 1900-01-01 00:00:00 | 2018-12-31 00:00:00 | 2015-12-31 00:00:00 | 1900-01-01 00:00:00 | 2016-03-31 00:00:00 | 2016-06-30 00:00:00 | 2016-09-30 00:00:00 | 1900-01-01 00:00:00 | 2016-12-31 00:00:00 | 2017-01-04 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2016-12-31 00:00:00 | 2017-03-01 00:00:00 | 2017-03-31 00:00:00 | 2017-06-30 00:00:00 | 2017-03-31 00:00:00 | 1900-01-01 00:00:00 | 2019-03-31 00:00:00 | 2017-03-31 00:00:00 | 2020-12-09 00:00:00 | 2018-06-30 00:00:00 | 2018-09-30 00:00:00 | 2019-12-31 00:00:00 | 2020-03-31 00:00:00 | 2020-12-31 00:00:00 | 1900-01-01 00:00:00 | 2017-09-30 00:00:00 | 2017-12-31 00:00:00 | 2020-12-31 00:00:00 | 2019-09-30 00:00:00 | 2022-03-31 00:00:00 | 2022-06-30 00:00:00 | 2020-12-31 00:00:00 | 2021-09-30 00:00:00 | 2021-06-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-12-31 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 | None | None | None | 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 | 22001 | None | None | None | None | None | None | 22001 | 22001 | None | 22001 | None | 22001 | None | 22001 | None | None | 22001 | 22001 | None | 22001 | None | None | None | 22001 | 22001 | 22001 | None | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22006 | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22006 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22006 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22006 | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | None | 22001 | 22006 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22006 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | 22001 |
filer_id | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 1999 | 2001 | 2003 | 2011 | 2009 | 2005 | 2007 | 2013 | 2017 | 2015 | 2019 | 2021 | 2023 | |||||||||||||
interest_cd | 40310 | 40310 | 40310 | 40310 | 40310 | 40310 | 40310 | 40310 | 40310 | 40310 | 40310 | 40310 | 40310 | |||||||||||||
effect_date | 1999-01-01 00:00:00 | 2001-01-01 00:00:00 | 2003-01-01 00:00:00 | 2011-01-01 00:00:00 | 2009-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2013-01-01 00:00:00 | 2017-01-01 00:00:00 | 2015-01-01 00:00:00 | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | 2023-01-01 00:00:00 |
filer_id | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||||||||||||
active | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | N | |||||||||||||
race | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
session_id | 1999 | 2001 | 2003 | 2005 | 2007 | 2011 | 2013 | 2009 | 2021 | 2015 | 2019 | 2017 | 2023 | |||||||||||||
category | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
category_type | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
sub_category | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
effect_dt | 1999-01-01 00:00:00 | 2001-01-01 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-01-01 00:00:00 | 2009-01-01 00:00:00 | 2021-01-01 00:00:00 | 2015-01-01 00:00:00 | 2019-01-01 00:00:00 | 2017-01-01 00:00:00 | 2023-01-01 00:00:00 | |||||||||||||
sub_category_type | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
election_type | 0 | 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 | None | |||||||||||||
nyq_dt | None | None | None | 2000-07-01 00:00:00 | 2000-07-01 00:00:00 | None | None | None | None | None | None | None | None | |||||||||||||
party_cd | 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 | |||||||||||||
district_cd | None | None | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1147180 | |
---|---|---|
xref_id | E24730 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | E24730 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
naml | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS, INC. | ALLIANCE OF AUTOMOBILE MANUFACTURERS, INC. | ALLIANCE OF AUTOMOBILE MANUFACTURERS, INC. | ALLIANCE OF AUTOMOBILE MANUFACTURERS, INC. | ALLIANCE OF AUTOMOBILE MANUFACTURERS, INC. | ALLIANCE OF AUTOMOBILE MANUFACTURERS, INC. | ALLIANCE OF AUTOMOBILE MANUFACTURERS, INC. | ALLIANCE OF AUTOMOBILE MANUFACTURERS, INC. | ALLIANCE OF AUTOMOBILE MANUFACTURERS, INC. | ALLIANCE OF AUTOMOBILE MANUFACTURERS, INC. | ALLIANCE OF AUTOMOBILE MANUFACTURERS, INC. | ALLIANCE OF AUTOMOBILE MANUFACTURERS, INC. | ALLIANCE OF AUTOMOBILE MANUFACTURERS, INC. | ALLIANCE OF AUTOMOBILE MANUFACTURERS, INC. | ALLIANCE OF AUTOMOBILE MANUFACTURERS, INC. | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS (AAM) | ALLIANCE OF AUTOMOBILE MANUFACTURERS (AAM) | ALLIANCE OF AUTOMOBILE MANUFACTURERS (AAM) | ALLIANCE OF AUTOMOBILE MANUFACTURERS (AAM) | ALLIANCE OF AUTOMOBILE MANUFACTURERS (AAM) | ALLIANCE OF AUTOMOBILE MANUFACTURERS (AAM) | ALLIANCE OF AUTOMOBILE MANUFACTURERS (AAM) | ALLIANCE OF AUTOMOBILE MANUFACTURERS (AAM) | ALLIANCE OF AUTOMOBILE MANUFACTURERS (AAM) | ALLIANCE OF AUTOMOBILE MANUFACTURERS (AAM) | ALLIANCE OF AUTOMOBILE MANUFACTURERS (AAM) | ALLIANCE OF AUTOMOBILE MANUFACTURERS (AAM) | ALLIANCE OF AUTOMOBILE MANUFACTURERS (AAM) | ALLIANCE OF AUTOMOBILE MANUFACTURERS (AAM) | ALLIANCE OF AUTOMOBILE MANUFACTURERS (AAM) | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ALLIANCE FOR AUTOMOTIVE INNOVATION | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
city | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | SACRAMENTO | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | SACRAMENTO | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | SACRAMENTO | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | SACRAMENTO | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | SACRAMENTO | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | SACRAMENTO | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | SACRAMENTO | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | SACRAMENTO | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | SACRAMENTO | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | SACRAMENTO | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | SACRAMENTO | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | SACRAMENTO | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | SACRAMENTO | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | SACRAMENTO | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | WASHINGTON | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
st | DC | DC | DC | DC | CA | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | CA | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | CA | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | CA | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | CA | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | CA | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | CA | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | CA | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | CA | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | CA | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | CA | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | CA | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | CA | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | CA | DC | DC | DC | DC | DC | DC | DC | DC | DC | DC | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
zip4 | 20005 | 20005 | 20005 | 20005 | 95814 | 20005 | 20005 | 20005 | 20005 | 20001 | 20001 | 20001 | 20001 | 20001 | 20001 | 20005 | 20005 | 20005 | 20005 | 95814 | 20005 | 20005 | 20005 | 20005 | 20001 | 20001 | 20001 | 20001 | 20001 | 20001 | 20005 | 20005 | 20005 | 20005 | 95814 | 20005 | 20005 | 20005 | 20005 | 20001 | 20001 | 20001 | 20001 | 20001 | 20001 | 20005 | 20005 | 20005 | 20005 | 95814 | 20005 | 20005 | 20005 | 20005 | 20001 | 20001 | 20001 | 20001 | 20001 | 20001 | 20005 | 20005 | 20005 | 20005 | 95814 | 20005 | 20005 | 20005 | 20005 | 20001 | 20001 | 20001 | 20001 | 20001 | 20001 | 20005 | 20005 | 20005 | 20005 | 95814 | 20005 | 20005 | 20005 | 20005 | 20001 | 20001 | 20001 | 20001 | 20001 | 20001 | 20005 | 20005 | 20005 | 20005 | 95814 | 20005 | 20005 | 20005 | 20005 | 20001 | 20001 | 20001 | 20001 | 20001 | 20001 | 20005 | 20005 | 20005 | 20005 | 95814 | 20005 | 20005 | 20005 | 20005 | 20001 | 20001 | 20001 | 20001 | 20001 | 20001 | 20005 | 20005 | 20005 | 20005 | 95814 | 20005 | 20005 | 20005 | 20005 | 20001 | 20001 | 20001 | 20001 | 20001 | 20001 | 20005 | 20005 | 20005 | 20005 | 95814 | 20005 | 20005 | 20005 | 20005 | 20001 | 20001 | 20001 | 20001 | 20001 | 20001 | 20005 | 20005 | 20005 | 20005 | 95814 | 20005 | 20005 | 20005 | 20005 | 20001 | 20001 | 20001 | 20001 | 20001 | 20001 | 20005 | 20005 | 20005 | 20005 | 95814 | 20005 | 20005 | 20005 | 20005 | 20001 | 20001 | 20001 | 20001 | 20001 | 20001 | 20005 | 20005 | 20005 | 20005 | 95814 | 20005 | 20005 | 20005 | 20005 | 20001 | 20001 | 20001 | 20001 | 20001 | 20001 | 20005 | 20005 | 20005 | 20005 | 95814 | 20005 | 20005 | 20005 | 20005 | 20001 | 20001 | 20001 | 20001 | 20001 | 20001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 2029625377 | 2023265500 | 2023265500 | 2023265500 | 9164477315 | 2023265548 | 2023265548 | 2023265548 | 2023265548 | 2023265500 | 2029625377 | 2023265548 | 2023265548 | 2023265548 | 2023265548 | 2029625377 | 2023265500 | 2023265500 | 2023265500 | 9164477315 | 2023265548 | 2023265548 | 2023265548 | 2023265548 | 2023265500 | 2029625377 | 2023265548 | 2023265548 | 2023265548 | 2023265548 | 2029625377 | 2023265500 | 2023265500 | 2023265500 | 9164477315 | 2023265548 | 2023265548 | 2023265548 | 2023265548 | 2023265500 | 2029625377 | 2023265548 | 2023265548 | 2023265548 | 2023265548 | 2029625377 | 2023265500 | 2023265500 | 2023265500 | 9164477315 | 2023265548 | 2023265548 | 2023265548 | 2023265548 | 2023265500 | 2029625377 | 2023265548 | 2023265548 | 2023265548 | 2023265548 | 2029625377 | 2023265500 | 2023265500 | 2023265500 | 9164477315 | 2023265548 | 2023265548 | 2023265548 | 2023265548 | 2023265500 | 2029625377 | 2023265548 | 2023265548 | 2023265548 | 2023265548 | 2029625377 | 2023265500 | 2023265500 | 2023265500 | 9164477315 | 2023265548 | 2023265548 | 2023265548 | 2023265548 | 2023265500 | 2029625377 | 2023265548 | 2023265548 | 2023265548 | 2023265548 | 2029625377 | 2023265500 | 2023265500 | 2023265500 | 9164477315 | 2023265548 | 2023265548 | 2023265548 | 2023265548 | 2023265500 | 2029625377 | 2023265548 | 2023265548 | 2023265548 | 2023265548 | 2029625377 | 2023265500 | 2023265500 | 2023265500 | 9164477315 | 2023265548 | 2023265548 | 2023265548 | 2023265548 | 2023265500 | 2029625377 | 2023265548 | 2023265548 | 2023265548 | 2023265548 | 2029625377 | 2023265500 | 2023265500 | 2023265500 | 9164477315 | 2023265548 | 2023265548 | 2023265548 | 2023265548 | 2023265500 | 2029625377 | 2023265548 | 2023265548 | 2023265548 | 2023265548 | 2029625377 | 2023265500 | 2023265500 | 2023265500 | 9164477315 | 2023265548 | 2023265548 | 2023265548 | 2023265548 | 2023265500 | 2029625377 | 2023265548 | 2023265548 | 2023265548 | 2023265548 | 2029625377 | 2023265500 | 2023265500 | 2023265500 | 9164477315 | 2023265548 | 2023265548 | 2023265548 | 2023265548 | 2023265500 | 2029625377 | 2023265548 | 2023265548 | 2023265548 | 2023265548 | 2029625377 | 2023265500 | 2023265500 | 2023265500 | 9164477315 | 2023265548 | 2023265548 | 2023265548 | 2023265548 | 2023265500 | 2029625377 | 2023265548 | 2023265548 | 2023265548 | 2023265548 | 2029625377 | 2023265500 | 2023265500 | 2023265500 | 9164477315 | 2023265548 | 2023265548 | 2023265548 | 2023265548 | 2023265500 | 2029625377 | 2023265548 | 2023265548 | 2023265548 | 2023265548 | 2029625377 | 2023265500 | 2023265500 | 2023265500 | 9164477315 | 2023265548 | 2023265548 | 2023265548 | 2023265548 | 2023265500 | 2029625377 | 2023265548 | 2023265548 | 2023265548 | 2023265548 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | None | 2023265567 | 2023265567 | 2023265567 | 9164477349 | None | 2023265567 | 2023265567 | 2023265567 | 9164477349 | None | 2023265567 | 2023265567 | 2023265567 | 9164477349 | None | 2023265567 | 2023265567 | 2023265567 | 9164477349 | None | 2023265567 | 2023265567 | 2023265567 | 9164477349 | None | 2023265567 | 2023265567 | 2023265567 | 9164477349 | None | 2023265567 | 2023265567 | 2023265567 | 9164477349 | None | 2023265567 | 2023265567 | 2023265567 | 9164477349 | None | 2023265567 | 2023265567 | 2023265567 | 9164477349 | None | 2023265567 | 2023265567 | 2023265567 | 9164477349 | None | 2023265567 | 2023265567 | 2023265567 | 9164477349 | None | 2023265567 | 2023265567 | 2023265567 | 9164477349 | None | 2023265567 | 2023265567 | 2023265567 | 9164477349 | None | 2023265567 | 2023265567 | 2023265567 | 9164477349 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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_id | 1147180 |
---|
filer_id | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
change_no | 8 | 9 | 10 | 11 | 12 | 0 | 13 | 14 | 15 | 16 | 17 | |||||||||||
session_id | 1999 | 1999 | 2001 | 2001 | 2001 | 2001 | 2007 | 2015 | 2015 | 2017 | 2017 | |||||||||||
log_dt | 2000-08-18 00:00:00 | 2000-10-23 00:00:00 | 2002-02-01 00:00:00 | 2002-02-01 00:00:00 | 2002-08-27 00:00:00 | 2002-08-27 00:00:00 | 2008-02-13 00:00:00 | 2016-01-29 00:00:00 | 2016-03-18 00:00:00 | 2017-03-06 00:00:00 | 2018-03-22 00:00:00 | |||||||||||
filer_type | 2 | 2 | 2 | 2 | 1 | 2 | 1 | 1 | 1 | 1 | 2 | |||||||||||
correction_flg | None | None | Y | None | None | Y | Y | Y | Y | Y | Y | |||||||||||
action | ADDED | SET ACTIVE | TERMINATED | SET ACTIVE | SET ACTIVE | ADDED | ADDED | DELETED | ADDED | ADDED | DELETED | |||||||||||
attribute_changed | FIRM | CLIENT | LOBBYIST | LOBBYIST | FIRM | FIRM | FIRM | FIRM | FIRM | |||||||||||||
ethics_dt | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
interests | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
filer_full_name | ALLIANCE OF AUTOMOBILE MANUFACTURERS (AAM) | ALLIANCE OF AUTOMOBILE MANUFACTURERS (AAM) | ALLIANCE OF AUTOMOBILE MANUFACTURERS, INC. | ALLIANCE OF AUTOMOBILE MANUFACTURERS, INC. | ALLIANCE OF AUTOMOBILE MANUFACTURERS, INC. | ALLIANCE OF AUTOMOBILE MANUFACTURERS, INC. | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS | ALLIANCE OF AUTOMOBILE MANUFACTURERS (AAM) | ALLIANCE OF AUTOMOBILE MANUFACTURERS (AAM) | |||||||||||
filer_city | None | WOODLAND HILLS | None | None | None | None | None | WASHINGTON | WASHINGTON | WASHINGTON | None | |||||||||||
filer_st | None | CA | None | None | None | None | None | DC | DC | DC | None | |||||||||||
filer_zip | None | 91367 | None | None | None | None | None | 20005 | 20005 | 20005 | None | |||||||||||
filer_phone | None | 8187043594 | None | None | None | None | None | 2023265500 | 2023265500 | 2023265500 | None | |||||||||||
entity_type | 3 | 3 | 4 | 2 | 1 | 4 | 3 | 3 | 3 | 3 | 3 | |||||||||||
entity_name | HYDE, MILLER, OWEN & TROST | HYDE, MILLER, OWEN & TROST | STEVEN P. DOUGLAS | None | None | STEVEN P. DOUGLAS | C H C ASSOCIATES | CHC ASSOCIATES | POLITICO GROUP | ARNOLD & PORTER KAYE SCHOLER LLP | ARNOLD & PORTER KAYE SCHOLER LLP | |||||||||||
entity_city | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
entity_st | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
entity_zip | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
entity_phone | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
entity_id | 1147696 | 1147696 | 1148954 | 0 | 0 | 1148954 | 1304000 | None | None | None | 1388612 | |||||||||||
responsible_officer | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
effect_dt | None | None | 2001-09-30 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2002-07-01 00:00:00 | 2008-02-01 00:00:00 | 2015-12-31 00:00:00 | 2016-02-24 00:00:00 | 2017-02-21 00:00:00 | 2018-03-19 00:00:00 |
filer_id | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | 1147180 | |||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 681416_0.cal | 704553_0.cal | 704570_0.cal | 718633_0.cal | 746410_0.cal | 772025_0.cal | 790325_0.cal | 814370_0.cal | 704553_1.cal | 838414_0.cal | 853798_0.cal | 853798_1.cal | 704553_2.cal | 896608_0.cal | 884959_0.cal | 906823_0.cal | 897122_0.cal | 896608_1.cal | 928835_0.cal | 947934_0.cal | 896608_2.cal | 471125.cal | 471127.cal | 969464_0.cal | 109341.cal | |||||||||||||||||||||||||
received_date | 2000-10-31 00:00:00 | 2001-01-02 00:00:00 | 2001-01-02 00:00:00 | 2001-01-31 00:00:00 | 2001-04-30 00:00:00 | 2001-07-30 00:00:00 | 2001-10-29 00:00:00 | 2002-01-31 00:00:00 | 2002-03-01 00:00:00 | 2002-04-29 00:00:00 | 2002-07-30 00:00:00 | 2002-07-31 00:00:00 | 2002-08-29 00:00:00 | 2002-12-18 00:00:00 | 2002-10-31 00:00:00 | 2003-01-27 00:00:00 | 2002-12-20 00:00:00 | 2003-07-20 00:00:00 | 2003-04-24 00:00:00 | 2003-07-31 00:00:00 | 2003-11-03 00:00:00 | 2003-10-31 00:00:00 | 2003-10-31 00:00:00 | 2003-10-31 00:00:00 | 2022-07-28 00:00:00 | |||||||||||||||||||||||||
filing_directory | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /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/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | |||||||||||||||||||||||||
filing_id | 681416 | 704553 | 704570 | 718633 | 746410 | 772025 | 790325 | 814370 | 704553 | 838414 | 853798 | 853798 | 704553 | 896608 | 884959 | 906823 | 897122 | 896608 | 928835 | 947934 | 896608 | None | None | 969464 | None | |||||||||||||||||||||||||
form_id | F635 | F603 | F602 | F635 | F635 | F635 | F635 | F635 | F603 | F635 | F635 | F635 | F603 | F603 | F635 | F635 | F602 | F603 | F635 | F635 | F603 | None | None | F635 | None | |||||||||||||||||||||||||
receive_comment | Filing accepted | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted | Filing accepted | Filing accepted | Filing accepted | 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, 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 passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted, but with warnings | Filing passed validation, but failed DB constraints |