filer_id | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1111092 | 2078496 | 2116519 | 2163236 | 2208125 | 2505602 | 2416166 | 2277808 | 2339509 | 2549393 | 2472570 | |||||||||||
effect_dt | 1999-01-01 00:00:00 | 2005-02-15 00:00:00 | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2021-01-01 00:00:00 | 2017-02-06 00:00:00 | 2013-01-01 00:00:00 | 2015-01-01 00:00:00 | 2023-01-01 00:00:00 | 2019-01-01 00:00:00 | |||||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | |||||||||||
session_id | 1999 | 2005 | 2007 | 2009 | 2011 | 2021 | 2017 | 2013 | 2015 | 2023 | 2019 |
filer_id | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 480221 | 469109 | 472661 | 491114 | 474637 | 467291 | 478244 | 487399 | 494773 | 474637 | 487399 | 498350 | 498350 | 491114 | 483776 | 630621 | 613897 | 649025 | 642022 | 696626 | 694829 | 707347 | 705584 | 764011 | 742822 | 742822 | 754607 | 763808 | 737760 | 789979 | 770450 | 777960 | 811690 | 794575 | 838671 | 845979 | 811690 | 822186 | 856636 | 845012 | 892790 | 892738 | 885557 | 910657 | 920220 | 930815 | 936277 | 947358 | 988926 | 976082 | 968791 | 1000139 | 1028408 | 1017546 | 1053928 | 1013866 | 1066065 | 1040354 | 1035835 | 1093644 | 1079683 | 1097722 | 1116063 | 1103564 | 1134155 | 1146756 | 1154002 | 1154268 | 1166184 | 1166184 | 1190477 | 1224872 | 1216178 | 1247743 | 1237250 | 1261277 | 1283946 | 1782048 | 1964791 | 1975054 | 1953265 | 1844563 | 1870602 | 1799425 | 1943378 | 1296961 | 1296961 | 1312125 | 1312125 | 1351035 | 1327623 | 1385951 | 1375852 | 1412001 | 1395019 | 1421381 | 1438208 | 1451242 | 1483692 | 1463023 | 1480330 | 1481357 | 1502110 | 1483692 | 1538552 | 1502110 | 1570110 | 1556942 | 1552714 | 1570110 | 1589939 | 1606325 | 1633980 | 1622230 | 1655458 | 1817771 | 1679925 | 1911969 | 1932762 | 1923002 | 1707148 | 1739792 | 1722298 | 1735019 | 1765542 | 1996693 | 1996693 | 1964791 | 1982423 | 2380366 | 2439022 | 2331195 | 2471803 | 2398673 | 2429732 | 2357722 | 2417936 | 2010198 | 2036439 | 2060548 | 2099357 | 2113571 | 2143072 | 2133331 | 2155723 | 2141296 | 2130486 | 2173799 | 2193403 | 2241934 | 2316820 | 2328308 | 2209970 | 2272886 | 2550544 | 2537570 | 2430041 | 2351530 | 2380366 | 2476105 | 2526531 | 2345107 | 2478935 | 2478935 | 2478935 | 2580279 | 2473548 | 2621370 | 2674482 | 2621370 | 2559000 | 2644780 | 2600081 | 2705560 | 2644780 | 2674482 | 2750353 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 159 | 157 | 150 | 154 | 158 | 149 | 151 | 153 | 155 | 158 | 153 | 156 | 156 | 154 | 152 | 161 | 160 | None | 162 | 163 | 163 | 164 | None | 161 | 165 | 165 | 165 | 165 | 164 | 167 | 166 | None | 168 | None | 169 | None | 168 | None | 170 | None | None | None | 171 | 172 | None | 173 | None | 174 | 176 | None | 175 | None | 178 | None | 179 | 177 | None | None | None | None | 180 | None | 182 | 181 | 183 | 184 | 185 | None | 185 | 185 | 186 | 188 | 187 | None | 188 | 189 | 190 | 214 | 221 | None | 221 | 217 | 218 | 215 | None | 191 | 191 | 192 | 196 | 194 | 193 | 196 | 195 | None | 196 | 197 | 198 | 199 | 201 | 200 | 201 | None | 202 | 201 | 203 | 202 | 204 | None | 204 | 204 | 205 | 206 | 208 | 207 | 209 | 216 | 210 | 219 | 220 | 220 | 211 | 212 | 212 | None | 213 | 223 | 223 | 221 | 222 | 237 | 240 | 236 | 241 | 238 | 241 | None | 239 | 224 | 225 | 226 | 227 | 228 | None | 229 | 229 | None | 228 | 230 | 231 | 233 | 235 | 236 | 232 | 234 | 244 | 244 | None | None | 237 | None | 243 | 236 | 242 | 242 | 242 | 245 | 242 | 247 | 249 | 247 | None | 248 | 246 | 250 | 248 | 249 | 251 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F690 | F635 | F690 | F635 | F635 | F690 | F690 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F602 | F690 | F635 | F635 | F635 | F690 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F690 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F605 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F602 | F602 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 2 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1999-10-29 00:00:00 | 1999-04-28 00:00:00 | 1997-07-31 00:00:00 | 1998-07-31 00:00:00 | 1999-07-23 00:00:00 | 1997-04-28 00:00:00 | 1997-10-29 00:00:00 | 1998-07-31 00:00:00 | 1998-11-02 00:00:00 | 1999-08-02 00:00:00 | 1998-04-29 00:00:00 | 1999-02-01 00:00:00 | 1999-09-27 00:00:00 | 1998-10-07 00:00:00 | 1998-01-29 00:00:00 | 2000-04-27 00:00:00 | 2000-01-26 00:00:00 | 1999-02-22 00:00:00 | 2000-07-20 00:00:00 | 2000-10-20 00:00:00 | 2000-12-08 00:00:00 | 2001-01-09 00:00:00 | 2000-12-21 00:00:00 | 2001-06-06 00:00:00 | 2001-04-23 00:00:00 | 2001-04-23 00:00:00 | 2001-04-26 00:00:00 | 2001-04-26 00:00:00 | 2001-01-11 00:00:00 | 2001-10-29 00:00:00 | 2001-07-26 00:00:00 | 2001-07-31 00:00:00 | 2002-01-29 00:00:00 | 2001-10-31 00:00:00 | 2002-04-29 00:00:00 | 2002-04-29 00:00:00 | 2002-04-19 00:00:00 | 2002-01-30 00:00:00 | 2002-07-31 00:00:00 | 2002-04-30 00:00:00 | 2002-11-18 00:00:00 | 2002-11-12 00:00:00 | 2002-10-31 00:00:00 | 2003-01-30 00:00:00 | 2003-01-31 00:00:00 | 2003-04-30 00:00:00 | 2003-04-30 00:00:00 | 2003-07-31 00:00:00 | 2004-01-30 00:00:00 | 2003-10-31 00:00:00 | 2003-10-30 00:00:00 | 2004-02-02 00:00:00 | 2004-07-29 00:00:00 | 2004-04-30 00:00:00 | 2004-10-26 00:00:00 | 2004-04-30 00:00:00 | 2004-10-28 00:00:00 | 2004-08-20 00:00:00 | 2004-07-30 00:00:00 | 2005-01-31 00:00:00 | 2005-01-31 00:00:00 | 2005-02-15 00:00:00 | 2005-07-28 00:00:00 | 2005-04-28 00:00:00 | 2005-10-31 00:00:00 | 2006-01-30 00:00:00 | 2006-03-03 00:00:00 | 2006-03-02 00:00:00 | 2006-04-28 00:00:00 | 2006-05-10 00:00:00 | 2006-07-31 00:00:00 | 2006-12-27 00:00:00 | 2006-10-31 00:00:00 | 2006-12-29 00:00:00 | 2007-01-31 00:00:00 | 2007-04-30 00:00:00 | 2007-07-31 00:00:00 | 2013-07-31 00:00:00 | 2015-04-30 00:00:00 | 2015-02-18 00:00:00 | 2015-03-12 00:00:00 | 2014-04-30 00:00:00 | 2014-07-30 00:00:00 | 2013-10-30 00:00:00 | 2015-01-05 00:00:00 | 2007-10-31 00:00:00 | 2008-01-30 00:00:00 | 2008-02-19 00:00:00 | 2008-01-31 00:00:00 | 2008-07-31 00:00:00 | 2008-04-28 00:00:00 | 2008-12-29 00:00:00 | 2008-10-30 00:00:00 | 2008-12-29 00:00:00 | 2009-01-30 00:00:00 | 2009-04-30 00:00:00 | 2009-07-31 00:00:00 | 2009-10-29 00:00:00 | 2010-04-28 00:00:00 | 2010-01-29 00:00:00 | 2010-04-16 00:00:00 | 2010-04-16 00:00:00 | 2010-07-22 00:00:00 | 2010-10-29 00:00:00 | 2010-10-29 00:00:00 | 2010-10-29 00:00:00 | 2011-01-31 00:00:00 | 2010-12-22 00:00:00 | 2010-12-21 00:00:00 | 2011-03-04 00:00:00 | 2011-04-29 00:00:00 | 2011-07-29 00:00:00 | 2012-01-30 00:00:00 | 2011-10-31 00:00:00 | 2012-04-27 00:00:00 | 2014-01-31 00:00:00 | 2012-07-31 00:00:00 | 2014-10-31 00:00:00 | 2015-01-29 00:00:00 | 2015-01-05 00:00:00 | 2012-10-30 00:00:00 | 2013-01-31 00:00:00 | 2013-01-02 00:00:00 | 2013-01-02 00:00:00 | 2013-04-30 00:00:00 | 2015-10-30 00:00:00 | 2015-10-30 00:00:00 | 2015-07-31 00:00:00 | 2015-07-31 00:00:00 | 2019-04-30 00:00:00 | 2020-01-29 00:00:00 | 2018-12-31 00:00:00 | 2020-04-30 00:00:00 | 2019-07-31 00:00:00 | 2020-01-10 00:00:00 | 2018-12-17 00:00:00 | 2019-10-30 00:00:00 | 2016-01-29 00:00:00 | 2016-04-29 00:00:00 | 2016-07-28 00:00:00 | 2016-10-28 00:00:00 | 2016-12-22 00:00:00 | 2016-12-22 00:00:00 | 2017-02-06 00:00:00 | 2017-04-28 00:00:00 | 2017-02-06 00:00:00 | 2017-01-31 00:00:00 | 2017-07-28 00:00:00 | 2017-10-31 00:00:00 | 2018-04-30 00:00:00 | 2018-10-30 00:00:00 | 2018-12-17 00:00:00 | 2018-01-31 00:00:00 | 2018-07-30 00:00:00 | 2021-01-29 00:00:00 | 2020-12-18 00:00:00 | 2020-01-10 00:00:00 | 2018-12-31 00:00:00 | 2019-09-09 00:00:00 | 2020-06-18 00:00:00 | 2020-10-29 00:00:00 | 2019-01-30 00:00:00 | 2020-07-16 00:00:00 | 2020-07-31 00:00:00 | 2021-08-23 00:00:00 | 2021-04-30 00:00:00 | 2020-05-26 00:00:00 | 2021-10-28 00:00:00 | 2022-04-29 00:00:00 | 2022-07-31 00:00:00 | 2020-12-21 00:00:00 | 2022-01-31 00:00:00 | 2021-07-29 00:00:00 | 2022-07-31 00:00:00 | 2022-11-01 00:00:00 | 2022-11-01 00:00:00 | 2022-11-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10005 | 10005 | 10001 | 10001 | 10005 | 10005 | 10002 | 10001 | 10005 | 10006 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10002 | 10005 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10002 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10002 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10002 | 10001 | 10002 | 10001 | 10005 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10002 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10002 | 10005 | 10001 | 10001 | 10001 | 10002 | 10002 | 10001 | 10001 | 10001 | 10001 | 10002 | 10005 | 10001 | 10001 | 10001 | 10002 | 10002 | 10001 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 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 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 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 | 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 | 11003 | 11003 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1999 | 1999 | 1997 | 1997 | 1999 | 1997 | 1997 | 1997 | 1997 | 1999 | 1997 | 1997 | 1997 | 1997 | 1997 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 2001 | 1999 | 2001 | 2001 | 2001 | 2001 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2005 | 2007 | 2005 | 2007 | 2007 | 2013 | 2015 | 2015 | 2015 | 2013 | 2013 | 2013 | 2015 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2009 | 2007 | 2009 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2011 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2011 | 2013 | 2013 | 2015 | 2011 | 2011 | 2013 | 2013 | 2013 | 2015 | 2015 | 2015 | 2015 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2015 | 2017 | 2017 | 2017 | 2017 | 2019 | 2017 | 2017 | 2019 | 2021 | 2019 | 2019 | 2019 | 2019 | 2019 | 2017 | 2019 | 2019 | 2019 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | GGILMORE | CFLAGG | GPEREZ | TTHAM | YBONILLA | * | * | SARRIAGA | YBONILLA | * | * | YBONILLA | YBONILLA | YBONILLA | * | * | LTHIBAUL | * | LTHIBAUL | * | DPASTRAN | * | LTHIBAUL | * | LTHIBAUL | GPEREZ | SARRIAGA | * | COMPLETED | LTHIBAUL | COMPLETED | LTHIBAUL | COMPLETED | COMPLETED | LTHIBAUL | COMPLETED | LTHIBAUL | COMPLETED | LTHIBAUL | COMPLETED | COMPLETED | LTHIBAUL | SARRIAGA | LTHIBAUL | LTHIBAUL | COMPLETED | GPEREZ | LTHIBAUL | LTHIBAUL | LTHIBAUL | * | * | SARRIAGA | LTHIBAUL | LTHIBAUL | LTHIBAUL | * | LTHIBAUL | CFLAGG | LTHIBAUL | LTHIBAUL | LTHIBAUL | AGLADNEY | AGLADNEY | YRODRIGU | YRODRIGU | AGLADNEY | AGLADNEY | AGLADNEY | GKURIMOT | LTHIBAUL | YRODRIGU | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | * | JINGRAM | SARRIAGA | JINGRAM | MGUERRA | MGUERRA | MGUERRA | ASAETERN | JINGRAM | YRODRIGU | YRODRIGU | ASAETERN | ASAETERN | ASAETERN | ASAETERN | AGLADNEY | PBANFORD | PBANFORD | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | MPACHECO | YRODRIGU | AGLADNEY | ASAETERN | SARRIAGA | SARRIAGA | ASAETERN | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | SUSHAKOV | GTAYLOR | PBANFORD | MMERCHANT | GTAYLOR | GPEREZ | GPEREZ | VUKSTINA | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | YRODRIGU | GPEREZ | YRODRIGU | AGLADNEY | YRODRIGU | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | GPEREZ | AGLADNEY | AGLADNEY | GTAYLOR | MKIRKHAM | GPEREZ | PBANFORD | GTAYLOR | SARRIAGA | GTAYLOR | AGLADNEY | GTAYLOR | GTAYLOR | GTAYLOR | GTAYLOR | SARRIAGA | MKIRKHAM | CAFILER | GTAYLOR | MKIRKHAM | GTAYLOR | GTAYLOR | CAFILER | CAFILER | CAFILER | CAFILER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 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 | 11002 | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1999-07-01 00:00:00 | 1999-01-01 00:00:00 | 1997-04-01 00:00:00 | 1998-04-01 00:00:00 | 1999-04-01 00:00:00 | 1997-01-01 00:00:00 | 1997-07-01 00:00:00 | 1998-01-01 00:00:00 | 1998-07-01 00:00:00 | 1999-04-01 00:00:00 | 1998-01-01 00:00:00 | 1998-10-01 00:00:00 | 1998-10-01 00:00:00 | 1998-04-01 00:00:00 | 1997-10-01 00:00:00 | 2000-01-01 00:00:00 | 1999-10-01 00:00:00 | None | 2000-04-01 00:00:00 | 2000-07-01 00:00:00 | 2000-07-01 00:00:00 | 2000-10-01 00:00:00 | 1900-01-01 00:00:00 | 2000-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-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-04-01 00:00:00 | 2001-04-01 00:00:00 | 2001-10-01 00:00:00 | 2001-07-01 00:00:00 | 2002-01-01 00:00:00 | 2001-10-01 00:00:00 | 2001-10-01 00:00:00 | 2001-10-01 00:00:00 | 2002-04-01 00:00:00 | 2002-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2002-07-01 00:00:00 | 2002-10-01 00:00:00 | 2002-10-01 00:00:00 | 2003-01-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-07-01 00:00:00 | 2003-10-01 00:00:00 | 2004-04-01 00:00:00 | 2004-01-01 00:00:00 | 2004-07-01 00:00:00 | 2004-01-01 00:00:00 | 2004-07-01 00:00:00 | 1900-01-01 00:00:00 | 2004-04-01 00:00:00 | 2004-10-01 00:00:00 | 2004-10-01 00:00:00 | 1900-01-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 | 2006-03-03 00:00:00 | 1900-01-01 00:00:00 | 2006-01-01 00:00:00 | 2006-01-01 00:00:00 | 2006-04-01 00:00:00 | 2006-12-27 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-04-01 00:00:00 | 2013-04-01 00:00:00 | 2015-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-03-12 00:00:00 | 2014-01-01 00:00:00 | 2014-04-01 00:00:00 | 2013-07-01 00:00:00 | 1900-01-01 00:00:00 | 2007-07-01 00:00:00 | 2007-07-01 00:00:00 | 2007-10-01 00:00:00 | 2008-10-01 00:00:00 | 2008-04-01 00:00:00 | 2008-01-01 00:00:00 | 2008-12-29 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 | 2009-07-01 00:00:00 | 2010-01-01 00:00:00 | 2009-10-01 00:00:00 | 2010-03-05 00:00:00 | 1900-01-01 00:00:00 | 2010-04-01 00:00:00 | 2010-01-01 00:00:00 | 2010-07-01 00:00:00 | 2010-04-01 00:00:00 | 2010-10-01 00:00:00 | 1900-01-01 00:00:00 | 2010-11-15 00:00:00 | 2010-10-01 00:00:00 | 2011-01-01 00:00:00 | 2011-04-01 00:00:00 | 2011-10-01 00:00:00 | 2011-07-01 00:00:00 | 2012-01-01 00:00:00 | 2013-10-01 00:00:00 | 2012-04-01 00:00:00 | 2014-07-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-13 00:00:00 | 2012-07-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-12 00:00:00 | 1900-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-07-31 00:00:00 | 2015-07-01 00:00:00 | 2015-01-01 00:00:00 | 2015-04-01 00:00:00 | 2019-01-01 00:00:00 | 2019-10-01 00:00:00 | 2018-12-30 00:00:00 | 2020-01-01 00:00:00 | 2019-04-01 00:00:00 | 2020-01-10 00:00:00 | 1900-01-01 00:00:00 | 2019-07-01 00:00:00 | 2015-10-01 00:00:00 | 2016-01-01 00:00:00 | 2016-04-01 00:00:00 | 2016-07-01 00:00:00 | 2016-11-15 00:00:00 | 1900-01-01 00:00:00 | 2017-02-06 00:00:00 | 2017-01-01 00:00:00 | 1900-01-01 00:00:00 | 2016-10-01 00:00:00 | 2017-04-01 00:00:00 | 2017-07-01 00:00:00 | 2018-01-01 00:00:00 | 2018-07-01 00:00:00 | 2018-12-10 00:00:00 | 2017-10-01 00:00:00 | 2018-04-01 00:00:00 | 2020-10-01 00:00:00 | 2020-12-07 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2019-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-07-01 00:00:00 | 2018-10-01 00:00:00 | 2020-04-01 00:00:00 | 2020-04-01 00:00:00 | 2020-04-01 00:00:00 | 2021-01-01 00:00:00 | 2020-05-26 00:00:00 | 2021-07-01 00:00:00 | 2022-01-01 00:00:00 | 2021-07-01 00:00:00 | 1900-01-01 00:00:00 | 2021-10-01 00:00:00 | 2021-04-01 00:00:00 | 2022-04-01 00:00:00 | 2021-10-01 00:00:00 | 2022-01-01 00:00:00 | 2022-07-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1999-09-30 00:00:00 | 1999-03-31 00:00:00 | 1997-06-30 00:00:00 | 1998-06-30 00:00:00 | 1999-06-30 00:00:00 | 1997-03-31 00:00:00 | 1997-09-30 00:00:00 | 1998-03-31 00:00:00 | 1998-09-30 00:00:00 | 1999-06-30 00:00:00 | 1998-03-31 00:00:00 | 1998-12-31 00:00:00 | 1998-12-31 00:00:00 | 1998-06-30 00:00:00 | 1997-12-31 00:00:00 | 2000-03-31 00:00:00 | 1999-12-31 00:00:00 | None | 2000-06-30 00:00:00 | 2000-09-30 00:00:00 | 2000-09-30 00:00:00 | 2000-12-31 00:00:00 | 1900-01-01 00:00:00 | 2000-03-31 00:00:00 | 2001-03-31 00:00:00 | 2001-03-31 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-06-30 00:00:00 | 2001-06-30 00:00:00 | 2001-12-31 00:00:00 | 2001-09-30 00:00:00 | 2002-03-31 00:00:00 | 2001-12-31 00:00:00 | 2001-12-31 00:00:00 | 2001-12-31 00:00:00 | 2002-06-30 00:00:00 | 2002-03-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2002-09-30 00:00:00 | 2002-12-31 00:00:00 | 2002-12-31 00:00:00 | 2003-03-31 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-09-30 00:00:00 | 2003-12-31 00:00:00 | 2004-06-30 00:00:00 | 2004-03-31 00:00:00 | 2004-09-30 00:00:00 | 2004-03-31 00:00:00 | 2004-09-30 00:00:00 | 1900-01-01 00:00:00 | 2004-06-30 00:00:00 | 2004-12-31 00:00:00 | 2004-12-31 00:00:00 | 1900-01-01 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 | 2006-03-03 00:00:00 | 1900-01-01 00:00:00 | 2006-03-31 00:00:00 | 2006-03-31 00:00:00 | 2006-06-30 00:00:00 | 2006-12-27 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-06-30 00:00:00 | 2013-06-30 00:00:00 | 2015-03-31 00:00:00 | 1900-01-01 00:00:00 | 2015-03-12 00:00:00 | 2014-03-31 00:00:00 | 2014-06-30 00:00:00 | 2013-09-30 00:00:00 | 1900-01-01 00:00:00 | 2007-09-30 00:00:00 | 2007-09-30 00:00:00 | 2007-12-31 00:00:00 | 2008-12-31 00:00:00 | 2008-06-30 00:00:00 | 2008-03-31 00:00:00 | 2008-12-29 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 | 2009-09-30 00:00:00 | 2010-03-31 00:00:00 | 2009-12-31 00:00:00 | 2010-03-05 00:00:00 | 1900-01-01 00:00:00 | 2010-06-30 00:00:00 | 2010-03-31 00:00:00 | 2010-09-30 00:00:00 | 2010-06-30 00:00:00 | 2010-12-31 00:00:00 | 1900-01-01 00:00:00 | 2010-11-15 00:00:00 | 2010-12-31 00:00:00 | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 2011-12-31 00:00:00 | 2011-09-30 00:00:00 | 2012-03-31 00:00:00 | 2013-12-31 00:00:00 | 2012-06-30 00:00:00 | 2014-09-30 00:00:00 | 2014-12-31 00:00:00 | 2014-11-13 00:00:00 | 2012-09-30 00:00:00 | 2012-12-31 00:00:00 | 2012-11-12 00:00:00 | 1900-01-01 00:00:00 | 2013-03-31 00:00:00 | 2015-09-30 00:00:00 | 2015-09-30 00:00:00 | 2015-03-31 00:00:00 | 2015-06-30 00:00:00 | 2019-03-31 00:00:00 | 2019-12-31 00:00:00 | 2018-12-30 00:00:00 | 2020-03-31 00:00:00 | 2019-06-30 00:00:00 | 2020-01-10 00:00:00 | 1900-01-01 00:00:00 | 2019-09-30 00:00:00 | 2015-12-31 00:00:00 | 2016-03-31 00:00:00 | 2016-06-30 00:00:00 | 2016-09-30 00:00:00 | 2016-11-15 00:00:00 | 1900-01-01 00:00:00 | 2017-02-06 00:00:00 | 2017-03-31 00:00:00 | 1900-01-01 00:00:00 | 2016-12-31 00:00:00 | 2017-06-30 00:00:00 | 2017-09-30 00:00:00 | 2018-03-31 00:00:00 | 2018-09-30 00:00:00 | 2018-12-10 00:00:00 | 2017-12-31 00:00:00 | 2018-06-30 00:00:00 | 2020-12-31 00:00:00 | 2020-12-07 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2019-03-31 00:00:00 | 1900-01-01 00:00:00 | 2020-09-30 00:00:00 | 2018-12-31 00:00:00 | 2020-06-30 00:00:00 | 2020-06-30 00:00:00 | 2020-06-30 00:00:00 | 2021-03-31 00:00:00 | 2020-05-26 00:00:00 | 2021-09-30 00:00:00 | 2022-03-31 00:00:00 | 2021-09-30 00:00:00 | 1900-01-01 00:00:00 | 2021-12-31 00:00:00 | 2021-06-30 00:00:00 | 2022-06-30 00:00:00 | 2021-12-31 00:00:00 | 2022-03-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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 22001 | None | 22006 | None | 22006 | 22006 | None | 22006 | None | 22006 | None | 22006 | 22006 | None | None | None | None | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22001 | None | 22006 | 22006 | 22006 | 22001 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22001 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22001 | None | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22001 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22001 | 22006 | 22006 | 22001 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22001 | 22006 | 22006 | 22001 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22001 | None | 22001 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22001 | 22006 | 22006 | 22006 | 22001 | None | None | 22006 | None | 22006 | 22006 | 22001 | 22006 | 22006 | 22006 | 22001 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 |
filer_id | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 2001 | 2001 | 2003 | 1999 | 1997 | 2009 | 2013 | 2005 | 2007 | 2011 | 2017 | 2019 | 2015 | 2021 | 2023 | |||||||||||||||
interest_cd | 40312 | 40306 | 40306 | 40312 | 40312 | 40306 | 40306 | 40306 | 40306 | 40306 | 40312 | 40312 | 40306 | 40302 | 40302 | |||||||||||||||
effect_date | 2001-01-01 00:00:00 | 2002-10-21 00:00:00 | 2003-01-01 00:00:00 | 1999-01-01 00:00:00 | 1997-11-01 00:00:00 | 2009-01-01 00:00:00 | 2013-01-01 00:00:00 | 2005-02-15 00:00:00 | 2007-01-01 00:00:00 | 2011-01-01 00:00:00 | 2017-02-06 00:00:00 | 2019-01-01 00:00:00 | 2015-01-01 00:00:00 | 2021-01-01 00:00:00 | 2023-01-01 00:00:00 |
filer_id | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||||||||||||||||||
active | Y | Y | Y | Y | T | Y | Y | Y | T | Y | Y | Y | Y | Y | Y | Y | Y | N | ||||||||||||||||||
race | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | ||||||||||||||||||
session_id | 1997 | 1999 | 2001 | 2001 | 2001 | 2003 | 2005 | 2005 | 2005 | 2007 | 2013 | 2011 | 2009 | 2021 | 2019 | 2015 | 2017 | 2023 | ||||||||||||||||||
category | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | ||||||||||||||||||
category_type | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | ||||||||||||||||||
sub_category | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | ||||||||||||||||||
effect_dt | 1997-11-01 00:00:00 | 1999-01-01 00:00:00 | 2001-01-01 00:00:00 | 2002-10-21 00:00:00 | 2002-03-31 00:00:00 | 2003-01-01 00:00:00 | 2005-02-15 00:00:00 | 2006-03-02 00:00:00 | 2005-12-31 00:00:00 | 2007-01-01 00:00:00 | 2013-01-01 00:00:00 | 2011-01-01 00:00:00 | 2009-01-01 00:00:00 | 2021-01-01 00:00:00 | 2019-01-01 00:00:00 | 2015-01-01 00:00:00 | 2017-02-06 00:00:00 | 2023-01-01 00:00:00 | ||||||||||||||||||
sub_category_type | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | ||||||||||||||||||
election_type | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 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 | None | None | ||||||||||||||||||
nyq_dt | None | None | None | None | None | None | None | 2000-07-01 00:00:00 | None | 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 | None | None | None | None | None | ||||||||||||||||||
county_cd | None | None | 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 | None | None |
filer_id | 1145162 | |
---|---|---|
xref_id | C26602 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | C26602 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
naml | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
city | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | OAKLAND | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
zip4 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | 94612 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | 5107632444 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | 5107631974 | 5107631974 | 5107631974 | 5107631974 | 5107631974 | 5107631974 | 5107631974 | 5107631974 | 5107631974 | 5107631974 | 5107631974 | 5107631974 | 5107631974 | 5107631974 | 5107631974 | 5107631974 | 5107631974 | 5107631974 | 5107631974 | 5107631974 | 5107631974 | 5107631974 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 1145162 |
---|
filer_id | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
change_no | 1 | 4 | 0 | 6 | 5 | 7 | 8 | 9 | 11 | 10 | 12 | |||||||||||
session_id | 1999 | 2001 | 2001 | 2005 | 2003 | 2005 | 2009 | 2009 | 2015 | 2015 | 2019 | |||||||||||
log_dt | 2001-01-22 00:00:00 | 2002-04-23 00:00:00 | 2002-11-04 00:00:00 | 2005-02-15 00:00:00 | 2004-08-20 00:00:00 | 2006-01-31 00:00:00 | 2009-12-29 00:00:00 | 2010-04-16 00:00:00 | 2015-02-18 00:00:00 | 2015-07-24 00:00:00 | 2019-10-21 00:00:00 | |||||||||||
filer_type | 1 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||||||||||
correction_flg | None | Y | Y | Y | None | None | Y | Y | Y | Y | None | |||||||||||
action | SET ACTIVE | TERMINATED | ADDED | ADDED | SET ACTIVE | DELETED | DELETED | ADDED | ADDED | DELETED | DELETED | |||||||||||
attribute_changed | CLIENT | EMPLOYER | FIRM | None | FIRM | 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 | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | CHILDREN NOW | |||||||||||
filer_city | SACRAMENTO | OAKLAND | None | OAKLAND | None | None | None | OAKLAND | OAKLAND | None | None | |||||||||||
filer_st | CA | CA | None | CA | None | None | None | CA | CA | None | None | |||||||||||
filer_zip | 95814 | 94612 | None | 94612 | None | None | None | 94612 | 94612 | None | None | |||||||||||
filer_phone | 9164464300 | 5107631974 | None | 5107632444 | None | None | None | 5107632444 | 5107632444 | None | None | |||||||||||
entity_type | 3 | None | 3 | 3 | 1 | 3 | 3 | 3 | 3 | 3 | 3 | |||||||||||
entity_name | GOLDBERG & ASSOCIATES, LENNY | None | DOWDEN AND ASSOCIATES, HR | SACRAMENTO ADVOCATES, INC. | None | SACRAMENTO ADVOCATES, INC. | COWGER & ASSOCIATES | POLITICAL SOLUTIONS, LLC | CALIFORNIA STRATEGIES & ADVOCACY, LLC | CALIFORNIA STRATEGIES & ADVOCACY, LLC | POLITICAL SOLUTIONS, LLC | |||||||||||
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 | 1147343 | None | 1147771 | None | 0 | 1147285 | 1147380 | None | None | 1273600 | 1261533 | |||||||||||
responsible_officer | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
effect_dt | None | 2002-03-31 00:00:00 | 2002-10-31 00:00:00 | 2005-02-15 00:00:00 | 2003-01-01 00:00:00 | 2005-12-31 00:00:00 | 2009-12-31 00:00:00 | 2010-02-01 00:00:00 | 2015-01-20 00:00:00 | 2015-04-30 00:00:00 | 2019-10-31 00:00:00 |
filer_id | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | 1145162 | |||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 2532.cal | 694829_0.cal | 707347_0.cal | 742822_0.cal | 742822_1.cal | 179457.cal | 179519.cal | 770450_0.cal | 267290.cal | 267215.cal | 789979_0.cal | 479613.cal | 811690_0.cal | 147483.cal | 811690_1.cal | 144012.cal | 147290.cal | 147377.cal | 147468.cal | 838671_0.cal | 856636_0.cal | 910657_0.cal | 885557_0.cal | 930815_0.cal | 947358_0.cal | 968791_0.cal | 286304.cal | 286102.cal | 286187.cal | 286252.cal | 169221.cal | 169351.cal | 168832.cal | 1480330_0.cal | 1552714_0.cal | 1722298_0.cal | 2113571_0.cal | 1923002_0.cal | 2478935_0.cal | |||||||||||||||||||||||||||||||||||||||
received_date | 2000-11-22 00:00:00 | 2000-12-08 00:00:00 | 2001-01-09 00:00:00 | 2001-04-23 00:00:00 | 2001-04-23 00:00:00 | 2001-07-26 00:00:00 | 2001-07-26 00:00:00 | 2001-07-26 00:00:00 | 2001-07-31 00:00:00 | 2001-07-31 00:00:00 | 2001-10-29 00:00:00 | 2002-01-29 00:00:00 | 2002-01-29 00:00:00 | 2002-04-19 00:00:00 | 2002-04-19 00:00:00 | 2002-04-19 00:00:00 | 2002-04-19 00:00:00 | 2002-04-19 00:00:00 | 2002-04-19 00:00:00 | 2002-04-29 00:00:00 | 2002-07-31 00:00:00 | 2003-01-30 00:00:00 | 2002-10-31 00:00:00 | 2003-04-30 00:00:00 | 2003-07-31 00:00:00 | 2003-10-30 00:00:00 | 2005-05-02 00:00:00 | 2005-05-02 00:00:00 | 2005-05-02 00:00:00 | 2005-05-02 00:00:00 | 2006-04-28 00:00:00 | 2006-04-28 00:00:00 | 2006-04-28 00:00:00 | 2010-04-16 00:00:00 | 2010-12-21 00:00:00 | 2013-01-02 00:00:00 | 2016-12-22 00:00:00 | 2015-01-05 00:00:00 | 2020-07-16 00:00:00 | |||||||||||||||||||||||||||||||||||||||
filing_directory | /usr/users/cafiler/disclose/ca99/temp | /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/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | |||||||||||||||||||||||||||||||||||||||
filing_id | None | 694829 | 707347 | 742822 | 742822 | None | None | 770450 | None | None | 789979 | None | 811690 | None | 811690 | None | None | None | None | 838671 | 856636 | 910657 | 885557 | 930815 | 947358 | 968791 | None | None | None | None | None | None | None | 1480330 | 1552714 | 1722298 | 2113571 | 1923002 | 2478935 | |||||||||||||||||||||||||||||||||||||||
form_id | None | F635 | F635 | F635 | F635 | None | None | F635 | None | None | F635 | None | F635 | None | F635 | None | None | None | None | F635 | F635 | F635 | F635 | F635 | F635 | F635 | None | None | None | None | None | None | None | F602 | F602 | F602 | F602 | F602 | F635 | |||||||||||||||||||||||||||||||||||||||
receive_comment | Filing did not pass validation | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing did not pass validation | Filing accepted | Filing passed validation, but failed DB constraints | 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 | Filing accepted | Filing accepted | Filing accepted | Filing accepted | 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 passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted |