filer_id | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1109679 | 2012866 | 2014161 | 2047520 | 2080803 | 2115723 | 2165197 | 2206373 | 2545500 | 2545501 | 2417352 | 2278144 | 2510628 | 2345847 | 2468661 | |||||||||||||||
effect_dt | 1995-01-01 00:00:00 | 2001-02-15 00:00:00 | 2001-02-15 00:00:00 | 2003-01-01 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 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2017-01-01 00:00:00 | 2013-01-01 00:00:00 | 2021-01-01 00:00:00 | 2015-01-01 00:00:00 | 2019-01-01 00:00:00 | |||||||||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7082 | 7051 | 7082 | 7051 | 7051 | 7051 | 7051 | 7051 | |||||||||||||||
session_id | 1995 | 2001 | 2001 | 2003 | 2005 | 2007 | 2009 | 2011 | 2023 | 2023 | 2017 | 2013 | 2021 | 2015 | 2019 |
filer_id | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 470297 | 475805 | 476945 | 488515 | 478922 | 481371 | 492212 | 541029 | 541077 | 470297 | 467872 | 471389 | 475805 | 541375 | 476945 | 466134 | 471389 | 497103 | 489772 | 465092 | 482498 | 473370 | 495867 | 465092 | 482498 | 628091 | 615127 | 642566 | 678494 | 716965 | 712426 | 696919 | 701170 | 729943 | 731113 | 754876 | 755739 | 738953 | 756251 | 745102 | 778874 | 770803 | 776901 | 790609 | 780586 | 777601 | 794904 | 812910 | 838410 | 819184 | 832472 | 832279 | 840992 | 851643 | 854598 | 893324 | 882414 | 918586 | 907044 | 914387 | 929044 | 943163 | 932620 | 945217 | 939742 | 954792 | 946047 | 968693 | 989750 | 975086 | 1007653 | 1006799 | 985950 | 1027677 | 1013509 | 1018570 | 1036432 | 1056232 | 1064965 | 1102145 | 1078938 | 1091916 | 1092010 | 1093371 | 1112245 | 1137327 | 1163418 | 1142479 | 1189875 | 1212067 | 1238095 | 1226242 | 1236190 | 1261434 | 1297948 | 1306632 | 1285492 | 1776464 | 1950183 | 1975314 | 1864341 | 1958695 | 1935238 | 1909881 | 1351542 | 1328941 | 1386191 | 1414625 | 1395626 | 1417795 | 1375505 | 1421397 | 1427422 | 1450510 | 1450510 | 1432903 | 1461275 | 1481788 | 1499903 | 1538466 | 1555731 | 1563303 | 1579939 | 1586640 | 1550328 | 1602320 | 1622468 | 1634306 | 1634306 | 1655825 | 1673887 | 1814289 | 1799311 | 1918093 | 1917821 | 1717558 | 1707176 | 1739278 | 1739278 | 1726506 | 1844919 | 1759432 | 1995589 | 2188942 | 2390481 | 2339957 | 2327203 | 2418156 | 2208850 | 2438287 | 2008600 | 2029041 | 2055719 | 2096207 | 2110638 | 2153117 | 2139190 | 2118348 | 2172153 | 2317729 | 2376307 | 2231780 | 2566719 | 2361093 | 2468272 | 2339957 | 2231780 | 2231780 | 2268963 | 2477786 | 2593412 | 2631966 | 2578255 | 2523188 | 2620893 | 2643977 | 2670024 | 2547485 | 2578255 | 2702404 | 2738310 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 142 | 143 | 151 | 146 | 159 | 144 | 147 | 145 | 153 | 142 | 157 | 150 | 143 | 155 | 151 | 149 | 150 | 156 | 154 | 141 | 152 | 158 | 148 | 141 | 152 | 161 | 160 | 162 | 163 | None | 163 | 163 | None | 164 | None | None | 165 | 164 | 165 | 165 | None | 166 | None | 167 | None | None | None | 168 | 169 | None | None | None | None | 170 | 170 | None | 171 | None | 172 | None | 173 | None | None | None | None | None | 174 | 175 | None | None | None | None | 176 | 178 | 177 | None | None | 179 | None | 181 | 180 | None | None | None | 182 | 183 | 185 | 184 | 186 | 187 | 188 | 188 | None | 189 | 191 | 192 | 190 | 214 | None | 222 | 218 | 221 | 220 | 219 | 194 | 193 | 196 | None | 196 | 198 | 195 | 197 | None | 199 | 199 | 198 | 200 | 201 | 202 | 203 | None | 204 | None | 205 | 204 | 206 | 207 | 207 | 208 | 209 | 210 | 216 | 215 | 220 | 220 | 212 | 211 | 212 | 212 | None | 217 | 213 | 223 | 231 | 238 | 235 | 236 | 239 | 232 | 240 | 224 | 225 | 226 | 227 | 228 | 229 | None | 228 | 230 | 235 | 237 | 233 | None | None | 241 | 236 | 233 | 233 | 234 | 242 | 246 | None | 245 | 243 | 247 | 248 | 249 | 244 | 245 | 250 | 251 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F690 | F635 | F690 | F690 | F635 | F690 | F635 | F635 | F635 | F635 | F635 | F690 | F635 | F635 | F690 | F635 | F635 | F635 | F635 | F635 | F602 | F690 | F635 | F602 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F615 | F635 | F690 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F690 | F690 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F602 | F635 | F602 | F690 | F635 | F635 | F635 | F690 | F635 | F690 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F603 | F635 | F635 | F603 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F602 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1995-07-31 00:00:00 | 1995-11-02 00:00:00 | 1997-10-30 00:00:00 | 1996-07-31 00:00:00 | 1999-11-01 00:00:00 | 1996-02-06 00:00:00 | 1996-10-31 00:00:00 | 1996-04-26 00:00:00 | 1998-04-29 00:00:00 | 1996-03-12 00:00:00 | 1999-04-29 00:00:00 | 1998-02-09 00:00:00 | 1995-12-29 00:00:00 | 1998-10-24 00:00:00 | 1998-03-23 00:00:00 | 1997-04-14 00:00:00 | 1997-07-31 00:00:00 | 1999-02-01 00:00:00 | 1998-07-30 00:00:00 | 1995-05-01 00:00:00 | 1998-01-30 00:00:00 | 1999-07-26 00:00:00 | 1997-01-31 00:00:00 | 1996-03-12 00:00:00 | 1998-01-23 00:00:00 | 2000-04-24 00:00:00 | 2000-01-14 00:00:00 | 2000-07-17 00:00:00 | 2000-10-27 00:00:00 | 2001-01-03 00:00:00 | 2000-12-08 00:00:00 | 2000-10-23 00:00:00 | 2000-12-21 00:00:00 | 2001-01-31 00:00:00 | 2001-02-15 00:00:00 | 2001-05-14 00:00:00 | 2001-04-25 00:00:00 | 2001-01-24 00:00:00 | 2001-04-30 00:00:00 | 2001-04-27 00:00:00 | 2001-07-31 00:00:00 | 2001-07-27 00:00:00 | 2001-08-21 00:00:00 | 2001-10-30 00:00:00 | 2001-07-23 00:00:00 | 2001-07-31 00:00:00 | 2001-10-29 00:00:00 | 2002-01-30 00:00:00 | 2002-04-29 00:00:00 | 2002-01-30 00:00:00 | 2001-12-18 00:00:00 | 2002-03-12 00:00:00 | 2002-04-29 00:00:00 | 2002-07-24 00:00:00 | 2002-07-25 00:00:00 | 2002-10-29 00:00:00 | 2002-10-29 00:00:00 | 2002-12-31 00:00:00 | 2003-01-27 00:00:00 | 2003-01-31 00:00:00 | 2003-04-25 00:00:00 | 2003-07-18 00:00:00 | 2003-04-29 00:00:00 | 2003-07-28 00:00:00 | 2003-06-24 00:00:00 | 2003-07-30 00:00:00 | 2003-07-29 00:00:00 | 2003-10-29 00:00:00 | 2003-12-17 00:00:00 | 2003-10-31 00:00:00 | 2004-02-03 00:00:00 | 2004-02-02 00:00:00 | 2004-01-23 00:00:00 | 2004-07-28 00:00:00 | 2004-04-29 00:00:00 | 2004-04-29 00:00:00 | 2004-08-02 00:00:00 | 2004-10-28 00:00:00 | 2004-10-30 00:00:00 | 2005-04-22 00:00:00 | 2005-01-28 00:00:00 | 2004-12-30 00:00:00 | 2004-12-30 00:00:00 | 2005-01-31 00:00:00 | 2005-07-16 00:00:00 | 2005-11-15 00:00:00 | 2006-04-20 00:00:00 | 2006-01-19 00:00:00 | 2006-07-29 00:00:00 | 2006-10-26 00:00:00 | 2007-01-31 00:00:00 | 2007-01-03 00:00:00 | 2006-12-22 00:00:00 | 2007-04-30 00:00:00 | 2007-10-31 00:00:00 | 2008-01-25 00:00:00 | 2007-07-31 00:00:00 | 2013-07-18 00:00:00 | 2015-01-07 00:00:00 | 2015-07-20 00:00:00 | 2014-07-20 00:00:00 | 2015-04-16 00:00:00 | 2015-01-31 00:00:00 | 2014-10-30 00:00:00 | 2008-07-31 00:00:00 | 2008-04-30 00:00:00 | 2008-12-29 00:00:00 | 2009-01-27 00:00:00 | 2009-01-30 00:00:00 | 2009-04-20 00:00:00 | 2008-10-29 00:00:00 | 2009-04-30 00:00:00 | 2009-04-22 00:00:00 | 2009-10-28 00:00:00 | 2010-01-22 00:00:00 | 2009-07-23 00:00:00 | 2010-01-27 00:00:00 | 2010-04-23 00:00:00 | 2010-07-10 00:00:00 | 2010-10-29 00:00:00 | 2010-12-23 00:00:00 | 2011-01-21 00:00:00 | 2011-01-05 00:00:00 | 2011-04-18 00:00:00 | 2010-12-13 00:00:00 | 2011-07-22 00:00:00 | 2011-10-31 00:00:00 | 2012-01-30 00:00:00 | 2012-03-28 00:00:00 | 2012-04-27 00:00:00 | 2012-07-24 00:00:00 | 2014-01-28 00:00:00 | 2013-10-30 00:00:00 | 2014-12-12 00:00:00 | 2014-12-10 00:00:00 | 2012-12-17 00:00:00 | 2012-10-30 00:00:00 | 2013-01-31 00:00:00 | 2013-01-31 00:00:00 | 2012-12-26 00:00:00 | 2014-04-30 00:00:00 | 2013-04-18 00:00:00 | 2015-10-28 00:00:00 | 2017-10-19 00:00:00 | 2019-07-16 00:00:00 | 2019-01-24 00:00:00 | 2018-12-04 00:00:00 | 2019-10-30 00:00:00 | 2018-01-30 00:00:00 | 2020-01-29 00:00:00 | 2016-01-28 00:00:00 | 2016-04-16 00:00:00 | 2016-07-16 00:00:00 | 2016-10-26 00:00:00 | 2016-12-13 00:00:00 | 2017-04-25 00:00:00 | 2016-12-22 00:00:00 | 2017-01-10 00:00:00 | 2017-07-26 00:00:00 | 2018-10-30 00:00:00 | 2019-04-23 00:00:00 | 2018-04-16 00:00:00 | 2020-12-30 00:00:00 | 2018-12-18 00:00:00 | 2020-04-28 00:00:00 | 2019-01-30 00:00:00 | 2018-08-21 00:00:00 | 2018-08-21 00:00:00 | 2018-07-25 00:00:00 | 2020-07-12 00:00:00 | 2021-07-15 00:00:00 | 2021-01-21 00:00:00 | 2021-08-04 00:00:00 | 2020-10-26 00:00:00 | 2021-10-27 00:00:00 | 2022-01-31 00:00:00 | 2022-04-25 00:00:00 | 2021-01-26 00:00:00 | 2021-04-28 00:00:00 | 2022-07-27 00:00:00 | 2022-10-21 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10006 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10005 | 10005 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10005 | 10005 | 10005 | 10001 | 10001 | 10006 | 10005 | 10006 | 10005 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10002 | 10002 | 10002 | 10001 | 10001 | 10001 | 10002 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1995 | 1995 | 1997 | 1995 | 1999 | 1995 | 1995 | 1995 | 1997 | 1995 | 1999 | 1997 | 1995 | 1997 | 1997 | 1997 | 1997 | 1997 | 1997 | 1995 | 1997 | 1999 | 1995 | 1995 | 1997 | 1999 | 1999 | 1999 | 1999 | 2001 | 1999 | 1999 | 1999 | 1999 | 2001 | 2001 | 2001 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2001 | 2001 | 2003 | 2003 | 2003 | 2003 | 2001 | 2003 | 2003 | 2003 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2003 | 2005 | 2005 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2013 | 2015 | 2015 | 2013 | 2015 | 2013 | 2013 | 2007 | 2007 | 2009 | 2009 | 2007 | 2009 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2013 | 2015 | 2015 | 2013 | 2011 | 2011 | 2011 | 2013 | 2013 | 2013 | 2015 | 2017 | 2019 | 2017 | 2019 | 2019 | 2017 | 2019 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2015 | 2017 | 2017 | 2019 | 2017 | 2021 | 2019 | 2019 | 2017 | 2017 | 2017 | 2017 | 2019 | 2021 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | TTHAM | * | TTHAM | * | CFLAGG | GPEREZ | GPEREZ | SARRIAGA | GPEREZ | SARRIAGA | SARRIAGA | JBRANNAN | GPEREZ | JBRANNAN | * | LTHIBAUL | * | LTHIBAUL | * | LTHIBAUL | LTHIBAUL | LTHIBAUL | * | * | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | * | LTHIBAUL | LTHIBAUL | * | SARRIAGA | COMPLETED | LTHIBAUL | COMPLETED | CFLAGG | LTHIBAUL | GPEREZ | LTHIBAUL | LTHIBAUL | COMPLETED | COMPLETED | YBONILLA | LTHIBAUL | EMCENTEE | LTHIBAUL | COMPLETED | COMPLETED | COMPLETED | LTHIBAUL | LTHIBAUL | COMPLETED | LTHIBAUL | LTHIBAUL | COMPLETED | DHULSE | SARRIAGA | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | * | RGEREMIA | LTHIBAUL | YRODRIGU | LTHIBAUL | YRODRIGU | AGLADNEY | PBANFORD | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | LTHIBAUL | LTHIBAUL | * | JINGRAM | JINGRAM | * | JINGRAM | MGUERRA | CFLAGG | MGUERRA | JINGRAM | MGUERRA | JINGRAM | ASAETERN | ASAETERN | ASAETERN | SARRIAGA | ASAETERN | GPEREZ | AGLADNEY | * | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | ASAETERN | ASAETERN | ASAETERN | PBANFORD | PBANFORD | GKURIMOT | ASAETERN | ASAETERN | ASAETERN | GKURIMOT | ASAETERN | AGLADNEY | AGLADNEY | AGLADNEY | VUKSTINA | AGLADNEY | GPEREZ | VUKSTINA | AGLADNEY | GTAYLOR | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | GPEREZ | AGLADNEY | SARRIAGA | AGLADNEY | AGLADNEY | AGLADNEY | VUKSTINA | AGLADNEY | MMERCHANT | GPEREZ | GTAYLOR | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | VUKSTINA | GTAYLOR | MMERCHANT | GTAYLOR | GTAYLOR | GTAYLOR | RATTIYEH | CAFILER | GTAYLOR | GTAYLOR | CAFILER | CAFILER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11002 | 11003 | 11003 | 11002 | 11003 | 11002 | 11002 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 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 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1995-04-01 00:00:00 | 1995-07-01 00:00:00 | 1997-07-01 00:00:00 | 1996-04-01 00:00:00 | 1999-07-01 00:00:00 | 1995-10-01 00:00:00 | 1996-07-01 00:00:00 | 1996-01-01 00:00:00 | 1998-01-01 00:00:00 | 1995-04-01 00:00:00 | 1999-01-01 00:00:00 | 1997-04-01 00:00:00 | 1995-07-01 00:00:00 | 1998-07-01 00:00:00 | 1997-07-01 00:00:00 | 1997-01-01 00:00:00 | 1997-04-01 00:00:00 | 1998-10-01 00:00:00 | 1998-04-01 00:00:00 | 1995-01-01 00:00:00 | 1997-10-01 00:00:00 | 1999-04-01 00:00:00 | 1996-10-01 00:00:00 | 1995-01-01 00:00:00 | 1997-10-01 00:00:00 | 2000-01-01 00:00:00 | 1999-10-01 00:00:00 | 2000-04-01 00:00:00 | 2000-07-01 00:00:00 | 1900-01-01 00:00:00 | 2000-07-01 00:00:00 | 2000-07-01 00:00:00 | 1900-01-01 00:00:00 | 2000-10-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2001-01-01 00:00:00 | 2000-10-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-04-01 00:00:00 | 2001-04-01 00:00:00 | 2001-04-01 00:00:00 | 2001-07-01 00:00:00 | 2001-04-01 00:00:00 | 2001-04-01 00:00:00 | 2001-07-01 00:00:00 | 2001-10-01 00:00:00 | 2002-01-01 00:00:00 | 2001-10-01 00:00:00 | 2001-07-01 00:00:00 | 2001-01-01 00:00:00 | 2002-01-01 00:00:00 | 2002-04-01 00:00:00 | 2002-04-01 00:00:00 | 2002-07-01 00:00:00 | 2002-07-01 00:00:00 | 1900-01-01 00:00:00 | 2002-10-01 00:00:00 | 2002-10-01 00:00:00 | 2003-01-01 00:00:00 | 1900-01-01 00:00:00 | 2003-01-01 00:00:00 | 1900-01-01 00:00:00 | 2002-01-01 00:00:00 | 2003-04-01 00:00:00 | 2003-04-01 00:00:00 | 2003-07-01 00:00:00 | 2002-10-01 00:00:00 | 2003-07-01 00:00:00 | 2003-10-01 00:00:00 | 2003-10-01 00:00:00 | 2003-10-01 00:00:00 | 2004-04-01 00:00:00 | 2004-01-01 00:00:00 | 2004-01-01 00:00:00 | 2004-04-01 00:00:00 | 2004-07-01 00:00:00 | 2004-07-01 00:00:00 | 2005-01-01 00:00:00 | 2004-10-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2004-10-01 00:00:00 | 2005-04-01 00:00:00 | 2005-07-01 00:00:00 | 2006-01-01 00:00:00 | 2005-10-01 00:00:00 | 2006-04-01 00:00:00 | 2006-07-01 00:00:00 | 2006-10-01 00:00:00 | 2006-12-22 00:00:00 | 1900-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-07-01 00:00:00 | 2007-10-01 00:00:00 | 2007-04-01 00:00:00 | 2013-04-01 00:00:00 | 1900-01-01 00:00:00 | 2015-04-01 00:00:00 | 2014-04-01 00:00:00 | 2015-01-01 00:00:00 | 2014-10-01 00:00:00 | 2014-07-01 00:00:00 | 2008-04-01 00:00:00 | 2008-01-01 00:00:00 | 2008-12-29 00:00:00 | 1900-01-01 00:00:00 | 2008-10-01 00:00:00 | 2009-04-20 00:00:00 | 2008-07-01 00:00:00 | 2009-01-01 00:00:00 | 1900-01-01 00:00:00 | 2009-07-01 00:00:00 | 2009-07-01 00:00:00 | 2009-04-01 00:00:00 | 2009-10-01 00:00:00 | 2010-01-01 00:00:00 | 2010-04-01 00:00:00 | 2010-07-01 00:00:00 | 1900-01-01 00:00:00 | 2010-10-01 00:00:00 | 1900-01-01 00:00:00 | 2011-01-01 00:00:00 | 2010-12-13 00:00:00 | 2011-04-01 00:00:00 | 2011-07-01 00:00:00 | 2011-09-30 00:00:00 | 2011-10-01 00:00:00 | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 2013-10-01 00:00:00 | 2013-07-01 00:00:00 | 2014-12-12 00:00:00 | 2014-12-10 00:00:00 | 2012-12-17 00:00:00 | 2012-07-01 00:00:00 | 2012-10-01 00:00:00 | 2012-10-01 00:00:00 | 1900-01-01 00:00:00 | 2014-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-07-01 00:00:00 | 2017-07-01 00:00:00 | 2019-04-01 00:00:00 | 2018-09-01 00:00:00 | 2018-12-04 00:00:00 | 2019-07-01 00:00:00 | 2017-10-01 00:00:00 | 2019-10-01 00:00:00 | 2015-10-01 00:00:00 | 2016-01-01 00:00:00 | 2016-04-01 00:00:00 | 2016-07-01 00:00:00 | 2016-12-13 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 | 2018-07-01 00:00:00 | 2019-01-01 00:00:00 | 2018-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-01-01 00:00:00 | 2018-10-01 00:00:00 | 2018-01-01 00:00:00 | 2018-01-01 00:00:00 | 2018-04-01 00:00:00 | 2020-04-01 00:00:00 | 2021-04-01 00:00:00 | 1900-01-01 00:00:00 | 2021-01-01 00:00:00 | 2020-07-01 00:00:00 | 2021-07-01 00:00:00 | 2021-10-01 00:00:00 | 2022-01-01 00:00:00 | 2020-10-01 00:00:00 | 2021-01-01 00:00:00 | 2022-04-01 00:00:00 | 2022-07-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1995-06-30 00:00:00 | 1995-09-30 00:00:00 | 1997-09-30 00:00:00 | 1996-06-30 00:00:00 | 1999-09-30 00:00:00 | 1995-12-31 00:00:00 | 1996-09-30 00:00:00 | 1996-03-31 00:00:00 | 1998-03-31 00:00:00 | 1995-06-30 00:00:00 | 1999-03-31 00:00:00 | 1997-06-30 00:00:00 | 1995-09-30 00:00:00 | 1998-09-30 00:00:00 | 1997-09-30 00:00:00 | 1997-03-31 00:00:00 | 1997-06-30 00:00:00 | 1998-12-31 00:00:00 | 1998-06-30 00:00:00 | 1995-03-31 00:00:00 | 1997-12-31 00:00:00 | 1999-06-30 00:00:00 | 1996-12-31 00:00:00 | 1995-03-31 00:00:00 | 1997-12-31 00:00:00 | 2000-03-31 00:00:00 | 1999-12-31 00:00:00 | 2000-06-30 00:00:00 | 2000-09-30 00:00:00 | 1900-01-01 00:00:00 | 2000-09-30 00:00:00 | 2000-09-30 00:00:00 | 1900-01-01 00:00:00 | 2000-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2001-03-31 00:00:00 | 2000-12-31 00:00:00 | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 | 2001-06-30 00:00:00 | 2001-06-30 00:00:00 | 2001-06-30 00:00:00 | 2001-09-30 00:00:00 | 2001-06-30 00:00:00 | 2001-06-30 00:00:00 | 2001-09-30 00:00:00 | 2001-12-31 00:00:00 | 2002-03-31 00:00:00 | 2001-12-31 00:00:00 | 2001-09-30 00:00:00 | 2001-03-31 00:00:00 | 2002-03-31 00:00:00 | 2002-06-30 00:00:00 | 2002-06-30 00:00:00 | 2002-09-30 00:00:00 | 2002-09-30 00:00:00 | 1900-01-01 00:00:00 | 2002-12-31 00:00:00 | 2002-12-31 00:00:00 | 2003-03-31 00:00:00 | 1900-01-01 00:00:00 | 2003-03-31 00:00:00 | 1900-01-01 00:00:00 | 2002-09-30 00:00:00 | 2003-06-30 00:00:00 | 2003-06-30 00:00:00 | 2003-09-30 00:00:00 | 2002-12-31 00:00:00 | 2003-09-30 00:00:00 | 2003-12-31 00:00:00 | 2003-12-31 00:00:00 | 2003-12-31 00:00:00 | 2004-06-30 00:00:00 | 2004-03-31 00:00:00 | 2004-03-31 00:00:00 | 2004-06-30 00:00:00 | 2004-09-30 00:00:00 | 2004-09-30 00:00:00 | 2005-03-31 00:00:00 | 2004-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2004-12-31 00:00:00 | 2005-06-30 00:00:00 | 2005-09-30 00:00:00 | 2006-03-31 00:00:00 | 2005-12-31 00:00:00 | 2006-06-30 00:00:00 | 2006-09-30 00:00:00 | 2006-12-31 00:00:00 | 2006-12-22 00:00:00 | 1900-01-01 00:00:00 | 2007-03-31 00:00:00 | 2007-09-30 00:00:00 | 2007-12-31 00:00:00 | 2007-06-30 00:00:00 | 2013-06-30 00:00:00 | 1900-01-01 00:00:00 | 2015-06-30 00:00:00 | 2014-06-30 00:00:00 | 2015-03-31 00:00:00 | 2014-12-31 00:00:00 | 2014-09-30 00:00:00 | 2008-06-30 00:00:00 | 2008-03-31 00:00:00 | 2008-12-29 00:00:00 | 1900-01-01 00:00:00 | 2008-12-31 00:00:00 | 2009-04-20 00:00:00 | 2008-09-30 00:00:00 | 2009-03-31 00:00:00 | 1900-01-01 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2009-06-30 00:00:00 | 2009-12-31 00:00:00 | 2010-03-31 00:00:00 | 2010-06-30 00:00:00 | 2010-09-30 00:00:00 | 1900-01-01 00:00:00 | 2010-12-31 00:00:00 | 1900-01-01 00:00:00 | 2011-03-30 00:00:00 | 2010-12-13 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00 | 2011-12-31 00:00:00 | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 2013-12-31 00:00:00 | 2013-09-30 00:00:00 | 2014-12-12 00:00:00 | 2014-12-10 00:00:00 | 2012-12-17 00:00:00 | 2012-09-30 00:00:00 | 2012-12-31 00:00:00 | 2012-12-31 00:00:00 | 1900-01-01 00:00:00 | 2014-03-31 00:00:00 | 2013-03-31 00:00:00 | 2015-09-30 00:00:00 | 2017-09-30 00:00:00 | 2019-06-30 00:00:00 | 2018-12-31 00:00:00 | 2018-12-04 00:00:00 | 2019-09-30 00:00:00 | 2017-12-31 00:00:00 | 2019-12-31 00:00:00 | 2015-12-31 00:00:00 | 2016-03-31 00:00:00 | 2016-06-30 00:00:00 | 2016-09-30 00:00:00 | 2016-12-13 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 | 2018-09-30 00:00:00 | 2019-03-31 00:00:00 | 2018-03-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-03-31 00:00:00 | 2018-12-31 00:00:00 | 2018-03-31 00:00:00 | 2018-03-31 00:00:00 | 2018-06-30 00:00:00 | 2020-06-30 00:00:00 | 2021-06-30 00:00:00 | 1900-01-01 00:00:00 | 2021-03-31 00:00:00 | 2020-09-30 00:00:00 | 2021-09-30 00:00:00 | 2021-12-31 00:00:00 | 2022-03-31 00:00:00 | 2020-12-31 00:00:00 | 2021-03-31 00:00:00 | 2022-06-30 00:00:00 | 2022-09-30 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_type | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 22001 | None | 22001 | None | None | None | None | None | 22001 | 22001 | None | None | None | None | 22001 | 22001 | 22001 | None | None | 22001 | None | 22001 | 22001 | None | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 |
filer_id | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 2003 | 2001 | 1997 | 1999 | 1995 | 2011 | 2007 | 2009 | 2013 | 2005 | 2017 | 2019 | 2015 | 2021 | 2023 | |||||||||||||||
interest_cd | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | |||||||||||||||
effect_date | 2003-01-01 00:00:00 | 2001-01-01 00:00:00 | 1997-01-01 00:00:00 | 1999-01-01 00:00:00 | 1995-01-01 00:00:00 | 2011-01-01 00:00:00 | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2013-01-01 00:00:00 | 2005-01-01 00:00:00 | 2017-01-01 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 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||||||||||||||
active | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | N | |||||||||||||||
race | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
session_id | 1997 | 1995 | 1999 | 2001 | 2003 | 2005 | 2007 | 2011 | 2013 | 2009 | 2017 | 2019 | 2015 | 2021 | 2023 | |||||||||||||||
category | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
category_type | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
sub_category | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
effect_dt | 1997-01-01 00:00:00 | 1995-01-01 00:00:00 | 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 | 2017-01-01 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 | |||||||||||||||
sub_category_type | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
election_type | 0 | 0 | 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 | None | None | |||||||||||||||
nyq_dt | None | None | 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 | None | None | |||||||||||||||
county_cd | 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 |
filer_id | 1143872 | |
---|---|---|
xref_id | C24782 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | C24782 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | PASADENA; CITY OF | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | PASADENA | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | 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 | 91109 | 91109 | 91109 | 91109 | 911097115 | 911097215 | 91109 | 91109 | 91109 | 91109 | 91109 | 91109 | 911014613 | 911014613 | 91109 | 91109 | 91109 | 91109 | 91109 | 911097115 | 911097215 | 91109 | 91109 | 91109 | 91109 | 91109 | 91109 | 911014613 | 911014613 | 91109 | 91109 | 91109 | 91109 | 91109 | 911097115 | 911097215 | 91109 | 91109 | 91109 | 91109 | 91109 | 91109 | 911014613 | 911014613 | 91109 | 91109 | 91109 | 91109 | 91109 | 911097115 | 911097215 | 91109 | 91109 | 91109 | 91109 | 91109 | 91109 | 911014613 | 911014613 | 91109 | 91109 | 91109 | 91109 | 91109 | 911097115 | 911097215 | 91109 | 91109 | 91109 | 91109 | 91109 | 91109 | 911014613 | 911014613 | 91109 | 91109 | 91109 | 91109 | 91109 | 911097115 | 911097215 | 91109 | 91109 | 91109 | 91109 | 91109 | 91109 | 911014613 | 911014613 | 91109 | 91109 | 91109 | 91109 | 91109 | 911097115 | 911097215 | 91109 | 91109 | 91109 | 91109 | 91109 | 91109 | 911014613 | 911014613 | 91109 | 91109 | 91109 | 91109 | 91109 | 911097115 | 911097215 | 91109 | 91109 | 91109 | 91109 | 91109 | 91109 | 911014613 | 911014613 | 91109 | 91109 | 91109 | 91109 | 91109 | 911097115 | 911097215 | 91109 | 91109 | 91109 | 91109 | 91109 | 91109 | 911014613 | 911014613 | 91109 | 91109 | 91109 | 91109 | 91109 | 911097115 | 911097215 | 91109 | 91109 | 91109 | 91109 | 91109 | 91109 | 911014613 | 911014613 | 91109 | 91109 | 91109 | 91109 | 91109 | 911097115 | 911097215 | 91109 | 91109 | 91109 | 91109 | 91109 | 91109 | 911014613 | 911014613 | 91109 | 91109 | 91109 | 91109 | 91109 | 911097115 | 911097215 | 91109 | 91109 | 91109 | 91109 | 91109 | 91109 | 911014613 | 911014613 | 91109 | 91109 | 91109 | 91109 | 91109 | 911097115 | 911097215 | 91109 | 91109 | 91109 | 91109 | 91109 | 91109 | 911014613 | 911014613 | 91109 | 91109 | 91109 | 91109 | 91109 | 911097115 | 911097215 | 91109 | 91109 | 91109 | 91109 | 91109 | 91109 | 911014613 | 911014613 | 91109 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 8184054311 | 6267446755 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444333 | 6267444333 | 6267444222 | 8184054311 | 6267446755 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444333 | 6267444333 | 6267444222 | 8184054311 | 6267446755 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444333 | 6267444333 | 6267444222 | 8184054311 | 6267446755 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444333 | 6267444333 | 6267444222 | 8184054311 | 6267446755 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444333 | 6267444333 | 6267444222 | 8184054311 | 6267446755 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444333 | 6267444333 | 6267444222 | 8184054311 | 6267446755 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444333 | 6267444333 | 6267444222 | 8184054311 | 6267446755 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444333 | 6267444333 | 6267444222 | 8184054311 | 6267446755 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444333 | 6267444333 | 6267444222 | 8184054311 | 6267446755 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444333 | 6267444333 | 6267444222 | 8184054311 | 6267446755 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444333 | 6267444333 | 6267444222 | 8184054311 | 6267446755 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444333 | 6267444333 | 6267444222 | 8184054311 | 6267446755 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444333 | 6267444333 | 6267444222 | 8184054311 | 6267446755 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444222 | 6267444333 | 6267444333 | 6267444222 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | None | None | 6267443921 | None | 6267443921 | 6267443921 | None | None | 6267443921 | None | 6267443921 | 6267443921 | None | None | 6267443921 | None | 6267443921 | 6267443921 | None | None | 6267443921 | None | 6267443921 | 6267443921 | None | None | 6267443921 | None | 6267443921 | 6267443921 | None | None | 6267443921 | None | 6267443921 | 6267443921 | None | None | 6267443921 | None | 6267443921 | 6267443921 | None | None | 6267443921 | None | 6267443921 | 6267443921 | None | None | 6267443921 | None | 6267443921 | 6267443921 | None | None | 6267443921 | None | 6267443921 | 6267443921 | None | None | 6267443921 | None | 6267443921 | 6267443921 | None | None | 6267443921 | None | 6267443921 | 6267443921 | None | None | 6267443921 | None | 6267443921 | 6267443921 | None | None | 6267443921 | None | 6267443921 | 6267443921 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 1143872 |
---|
filer_id | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
change_no | 1 | 2 | 3 | 4 | 0 | 5 | 6 | |||||||
session_id | 2001 | 2001 | 2001 | 1999 | 2001 | 2003 | 2021 | |||||||
log_dt | 2001-05-14 00:00:00 | 2001-02-15 00:00:00 | 2001-07-12 00:00:00 | 2000-12-21 00:00:00 | 2002-08-01 00:00:00 | 2003-07-28 00:00:00 | 2020-12-30 00:00:00 | |||||||
filer_type | 1 | 1 | 1 | 1 | 2 | 1 | 1 | |||||||
correction_flg | Y | Y | Y | Y | Y | Y | None | |||||||
action | ADDED | ADDED | DELETED | ADDED | ADDED | ADDED | CHANGED | |||||||
attribute_changed | EMPLOYER | EMPLOYER | CLIENT | EMPLOYER | FIRM | None | RESPONSIBLE OFFICER | |||||||
ethics_dt | None | None | None | None | None | None | None | |||||||
interests | None | None | None | None | None | None | None | |||||||
filer_full_name | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA, CITY OF | PASADENA; CITY OF | |||||||
filer_city | PASADENA | None | None | PASADENA | None | PASADENA | None | |||||||
filer_st | CA | None | None | CA | None | CA | None | |||||||
filer_zip | 91109 | None | None | 91109 | None | 91109 | None | |||||||
filer_phone | 6267444222 | None | None | 8184054311 | None | 8184054311 | None | |||||||
entity_type | 2 | 2 | 1 | 2 | 3 | 3 | 20 | |||||||
entity_name | THE GUALCO GROUP | KENNETH EMANUELS & ASSOCIATES | ENVIRO COMMUNICATIONS, INCORPORATED | ENVIRO COMMUNICATIONS, INCORPORATED | PLANNING COMPANY ASSOCIATES, INC. | PLANNING COMPANY ASSOCIATES, INC. | CITY CLERK MARK JOMSKY | |||||||
entity_city | None | SACRAMENTO | None | None | None | None | None | |||||||
entity_st | None | CA | None | None | None | None | None | |||||||
entity_zip | None | 95814 | None | None | None | None | None | |||||||
entity_phone | None | 9164446789 | None | None | None | None | None | |||||||
entity_id | 0 | 1147358 | 1147611 | None | 1147668 | None | 1436855 | |||||||
responsible_officer | None | None | None | None | None | None | None | |||||||
effect_dt | 2001-04-01 00:00:00 | 2001-02-01 00:00:00 | 2001-06-30 00:00:00 | 2000-12-15 00:00:00 | 2002-07-26 00:00:00 | 2003-07-14 00:00:00 | 2021-01-01 00:00:00 |
filer_id | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | 1143872 | |||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 678494_0.cal | 745102_0.cal | 770803_0.cal | 230856.cal | 230931.cal | 230894.cal | 790609_0.cal | 812910_0.cal | 838410_0.cal | 851643_0.cal | 882414_0.cal | 907044_0.cal | 929044_0.cal | 946047_0.cal | 968693_0.cal | 448402.cal | 985950_0.cal | 1027677_0.cal | 1013509_0.cal | 1056232_0.cal | 1078938_0.cal | 1102145_0.cal | 1112245_0.cal | 1142479_0.cal | 1137327_0.cal | 1163418_0.cal | 1189875_0.cal | 1212067_0.cal | 1328941_0.cal | 1395626_0.cal | 1351542_0.cal | 1238095_0.cal | 98709.cal | 1261434_0.cal | 1285492_0.cal | 1297948_0.cal | 49275.cal | 1375505_0.cal | 1306632_0.cal | |||||||||||||||||||||||||||||||||||||||
received_date | 2000-10-27 00:00:00 | 2001-04-27 00:00:00 | 2001-07-27 00:00:00 | 2001-07-30 00:00:00 | 2001-07-30 00:00:00 | 2001-07-30 00:00:00 | 2001-10-30 00:00:00 | 2002-01-30 00:00:00 | 2002-04-29 00:00:00 | 2002-07-24 00:00:00 | 2002-10-29 00:00:00 | 2003-01-27 00:00:00 | 2003-04-25 00:00:00 | 2003-07-29 00:00:00 | 2003-10-29 00:00:00 | 2003-10-30 00:00:00 | 2004-01-23 00:00:00 | 2004-07-28 00:00:00 | 2004-04-29 00:00:00 | 2004-10-28 00:00:00 | 2005-01-28 00:00:00 | 2005-04-22 00:00:00 | 2005-07-16 00:00:00 | 2006-01-19 00:00:00 | 2005-11-15 00:00:00 | 2006-04-20 00:00:00 | 2006-07-29 00:00:00 | 2006-10-26 00:00:00 | 2008-04-30 00:00:00 | 2009-01-30 00:00:00 | 2008-07-31 00:00:00 | 2007-01-31 00:00:00 | 2007-01-31 00:00:00 | 2007-04-30 00:00:00 | 2007-07-31 00:00:00 | 2007-10-31 00:00:00 | 2008-10-29 00:00:00 | 2008-10-29 00:00:00 | 2008-01-25 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/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /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/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | |||||||||||||||||||||||||||||||||||||||
filing_id | 678494 | 745102 | 770803 | None | None | None | 790609 | 812910 | 838410 | 851643 | 882414 | 907044 | 929044 | 946047 | 968693 | None | 985950 | 1027677 | 1013509 | 1056232 | 1078938 | 1102145 | 1112245 | 1142479 | 1137327 | 1163418 | 1189875 | 1212067 | 1328941 | 1395626 | 1351542 | 1238095 | None | 1261434 | 1285492 | 1297948 | None | 1375505 | 1306632 | |||||||||||||||||||||||||||||||||||||||
form_id | F635 | F635 | F635 | None | None | None | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | None | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | None | F635 | F635 | F635 | None | F635 | F635 | |||||||||||||||||||||||||||||||||||||||
receive_comment | Filing accepted, but but with warnings | Filing accepted | Filing accepted | Filing did not pass validation | 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 | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted |