filer_id | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1111374 | 2045229 | 2085939 | 2113452 | 2159830 | 2203356 | 2418616 | 2471467 | 2547081 | 2281396 | 2508231 | 2342176 | ||||||||||||
effect_dt | 1999-01-01 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 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2023-01-01 00:00:00 | 2013-01-01 00:00:00 | 2021-01-01 00:00:00 | 2015-01-01 00:00:00 | ||||||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | ||||||||||||
session_id | 1999 | 2003 | 2005 | 2007 | 2009 | 2011 | 2017 | 2019 | 2023 | 2013 | 2021 | 2015 |
filer_id | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 489654 | 485966 | 493366 | 496979 | 485966 | 479546 | 473940 | 468403 | 617736 | 631564 | 664115 | 681870 | 694264 | 710190 | 710190 | 704853 | 756872 | 732661 | 736472 | 744088 | 778994 | 769326 | 787636 | 797062 | 808543 | 824034 | 840014 | 863536 | 844136 | 890445 | 854162 | 879254 | 904913 | 908396 | 920699 | 930801 | 936066 | 947087 | 956598 | 980664 | 973792 | 976208 | 968826 | 987968 | 999613 | 1033976 | 1017549 | 1014403 | 1026461 | 1038370 | 1036360 | 1038370 | 1053386 | 1077197 | 1096601 | 1073697 | 1066706 | 1057457 | 1068101 | 1079096 | 1093368 | 1026461 | 1057457 | 1079096 | 1077767 | 1026461 | 1084965 | 1080019 | 1117346 | 1104785 | 1132745 | 1166073 | 1175492 | 1148921 | 1192416 | 1181594 | 1223898 | 1223470 | 1225044 | 1192416 | 1247906 | 1244195 | 1229293 | 1237042 | 1285692 | 1297994 | 1262120 | 1289292 | 1781383 | 1766114 | 1872226 | 1933679 | 1941132 | 1941665 | 1911731 | 1309195 | 1324243 | 1309195 | 1324953 | 1348796 | 1328109 | 1387034 | 1391290 | 1387334 | 1386552 | 1409150 | 1409173 | 1378832 | 1396048 | 1415460 | 1415462 | 1415477 | 1422093 | 1438105 | 1431031 | 1404368 | 1452384 | 1428147 | 1462695 | 1462695 | 1452384 | 1452384 | 1484789 | 1506321 | 1539151 | 1561863 | 1553570 | 1560812 | 1567025 | 1555378 | 1556212 | 1569484 | 1590813 | 1593465 | 1614370 | 1598065 | 1607177 | 1621477 | 1636836 | 1656352 | 1673473 | 1679858 | 1801116 | 1816875 | 1921905 | 1918784 | 1710106 | 1716920 | 1718634 | 1740082 | 1718112 | 1730824 | 1725861 | 1845993 | 1997444 | 1982388 | 1966203 | 2355854 | 2332183 | 2395943 | 2417432 | 2550612 | 2375263 | 2363613 | 2342616 | 2274344 | 2033726 | 2011003 | 2062077 | 2099038 | 2114577 | 2155715 | 2133243 | 2132803 | 2130819 | 2174380 | 2542047 | 2329925 | 2422325 | 2218480 | 2467227 | 2345043 | 2541166 | 2439180 | 2200513 | 2209891 | 2540993 | 2556632 | 2237854 | 2339497 | 2194315 | 2317181 | 2596164 | 2640713 | 2600112 | 2578577 | 2527200 | 2578577 | 2480817 | 2704578 | 2600112 | 2570741 | 2480817 | 2570389 | 2675184 | 2621340 | 2621340 | 2745903 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 154 | 153 | 155 | 156 | 153 | 159 | 158 | 157 | 120 | 161 | 162 | 163 | 163 | 164 | 164 | None | 165 | 164 | 164 | 165 | None | 166 | 167 | None | 168 | None | 169 | None | None | None | 170 | 171 | None | 172 | None | 173 | None | 174 | None | None | None | None | 175 | 176 | None | None | None | 177 | 178 | 179 | None | 179 | 179 | None | None | 181 | None | 179 | 180 | 180 | None | 178 | 179 | 180 | 180 | 178 | None | None | 182 | 181 | 183 | 185 | None | 184 | 186 | None | 188 | 188 | 188 | 187 | None | None | None | 188 | 190 | 191 | 189 | None | 214 | 213 | 218 | 220 | None | None | 219 | 192 | 194 | 192 | None | 194 | 193 | 196 | None | 197 | 196 | None | None | 195 | 196 | None | None | None | 197 | 198 | None | 196 | 199 | 198 | 200 | 200 | 199 | 199 | 201 | 202 | 203 | None | 204 | None | None | 204 | 204 | 204 | 205 | None | None | None | 206 | 207 | 208 | 209 | None | 210 | 215 | 216 | 220 | 220 | 211 | 212 | 212 | 212 | 212 | None | None | 217 | 223 | 222 | 221 | 236 | 237 | 238 | 239 | 244 | 237 | None | None | 234 | 225 | 224 | 226 | 227 | 228 | 229 | None | None | 228 | 230 | 245 | 236 | None | 233 | 241 | 236 | 244 | 240 | None | 232 | 244 | None | 233 | None | 231 | 235 | None | 248 | 246 | 245 | 243 | 245 | 242 | 250 | 246 | None | 242 | None | 249 | 247 | 247 | 251 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F635 | F635 | F635 | F635 | F690 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F690 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F602 | F606 | F602 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F606 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F605 | F635 | F635 | F603 | F603 | F602 | F602 | F635 | F602 | F602 | F603 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F603 | F603 | F602 | F602 | F602 | F602 | F635 | F635 | F602 | F602 | F602 | F635 | F635 | F602 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F603 | F602 | F602 | F602 | F602 | F635 | F635 | F602 | F603 | F603 | F635 | F635 | F635 | F635 | F605 | F635 | F635 | F635 | F602 | F603 | F635 | F602 | F603 | F635 | F602 | F602 | F602 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F602 | F635 | F635 | F602 | F602 | F602 | F602 | F635 | F635 | F602 | F635 | F602 | F635 | F602 | F602 | F635 | F602 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 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 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1998-07-29 00:00:00 | 1998-04-30 00:00:00 | 1998-10-29 00:00:00 | 1999-02-01 00:00:00 | 1998-06-18 00:00:00 | 1999-11-01 00:00:00 | 1999-07-29 00:00:00 | 1999-04-30 00:00:00 | 2000-01-31 00:00:00 | 2000-05-01 00:00:00 | 2000-07-31 00:00:00 | 2000-10-31 00:00:00 | 2000-10-31 00:00:00 | 2001-01-16 00:00:00 | 2001-01-23 00:00:00 | 2000-12-28 00:00:00 | 2001-04-30 00:00:00 | 2001-01-29 00:00:00 | 2001-01-22 00:00:00 | 2001-04-26 00:00:00 | 2001-07-26 00:00:00 | 2001-07-24 00:00:00 | 2001-10-17 00:00:00 | 2001-10-22 00:00:00 | 2002-01-22 00:00:00 | 2002-01-25 00:00:00 | 2002-04-30 00:00:00 | 2002-07-30 00:00:00 | 2002-04-30 00:00:00 | 2002-10-29 00:00:00 | 2002-07-30 00:00:00 | 2002-10-25 00:00:00 | 2002-12-31 00:00:00 | 2003-01-29 00:00:00 | 2003-01-29 00:00:00 | 2003-04-30 00:00:00 | 2003-04-30 00:00:00 | 2003-07-31 00:00:00 | 2003-07-30 00:00:00 | 2004-01-12 00:00:00 | 2003-12-01 00:00:00 | 2003-10-31 00:00:00 | 2003-10-30 00:00:00 | 2004-01-29 00:00:00 | 2004-01-29 00:00:00 | 2004-07-29 00:00:00 | 2004-04-30 00:00:00 | 2004-04-30 00:00:00 | 2004-07-27 00:00:00 | 2004-08-20 00:00:00 | 2004-08-02 00:00:00 | 2004-08-20 00:00:00 | 2004-10-25 00:00:00 | 2004-12-30 00:00:00 | 2005-02-02 00:00:00 | 2005-01-20 00:00:00 | 2004-10-29 00:00:00 | 2004-10-29 00:00:00 | 2004-12-28 00:00:00 | 2005-01-29 00:00:00 | 2005-01-31 00:00:00 | 2005-03-31 00:00:00 | 2005-03-31 00:00:00 | 2005-03-31 00:00:00 | 2005-01-27 00:00:00 | 2005-04-05 00:00:00 | 2004-12-31 00:00:00 | 2005-01-03 00:00:00 | 2005-07-29 00:00:00 | 2005-04-29 00:00:00 | 2005-10-28 00:00:00 | 2006-04-28 00:00:00 | 2006-05-25 00:00:00 | 2006-01-31 00:00:00 | 2006-07-31 00:00:00 | 2006-06-26 00:00:00 | 2006-12-19 00:00:00 | 2006-12-14 00:00:00 | 2006-12-28 00:00:00 | 2006-10-31 00:00:00 | 2007-01-04 00:00:00 | 2007-01-05 00:00:00 | 2006-12-22 00:00:00 | 2007-01-31 00:00:00 | 2007-07-31 00:00:00 | 2007-10-31 00:00:00 | 2007-04-30 00:00:00 | 2007-08-13 00:00:00 | 2013-07-30 00:00:00 | 2013-04-30 00:00:00 | 2014-07-31 00:00:00 | 2015-01-30 00:00:00 | 2014-12-30 00:00:00 | 2014-12-30 00:00:00 | 2014-10-31 00:00:00 | 2008-04-17 00:00:00 | 2008-04-11 00:00:00 | 2008-01-30 00:00:00 | 2008-04-15 00:00:00 | 2008-07-30 00:00:00 | 2008-04-29 00:00:00 | 2008-12-31 00:00:00 | 2008-12-26 00:00:00 | 2009-01-03 00:00:00 | 2008-12-30 00:00:00 | 2009-02-17 00:00:00 | 2008-12-30 00:00:00 | 2008-10-31 00:00:00 | 2009-01-30 00:00:00 | 2009-03-02 00:00:00 | 2009-03-16 00:00:00 | 2009-01-05 00:00:00 | 2009-04-30 00:00:00 | 2009-07-31 00:00:00 | 2009-06-25 00:00:00 | 2009-02-27 00:00:00 | 2009-10-30 00:00:00 | 2009-06-29 00:00:00 | 2010-01-29 00:00:00 | 2010-03-11 00:00:00 | 2010-03-11 00:00:00 | 2010-03-11 00:00:00 | 2010-04-30 00:00:00 | 2010-07-30 00:00:00 | 2010-10-29 00:00:00 | 2011-01-04 00:00:00 | 2010-12-22 00:00:00 | 2010-12-30 00:00:00 | 2010-12-31 00:00:00 | 2010-12-29 00:00:00 | 2010-12-30 00:00:00 | 2011-01-28 00:00:00 | 2011-04-29 00:00:00 | 2011-04-01 00:00:00 | 2011-08-26 00:00:00 | 2011-06-06 00:00:00 | 2011-07-29 00:00:00 | 2011-10-28 00:00:00 | 2012-01-31 00:00:00 | 2012-04-27 00:00:00 | 2012-06-18 00:00:00 | 2012-07-31 00:00:00 | 2013-10-31 00:00:00 | 2014-01-30 00:00:00 | 2014-12-30 00:00:00 | 2014-12-17 00:00:00 | 2012-10-31 00:00:00 | 2012-12-12 00:00:00 | 2012-12-19 00:00:00 | 2013-01-31 00:00:00 | 2012-12-18 00:00:00 | 2012-12-28 00:00:00 | 2012-12-18 00:00:00 | 2014-04-30 00:00:00 | 2015-10-30 00:00:00 | 2015-07-31 00:00:00 | 2015-04-30 00:00:00 | 2019-02-07 00:00:00 | 2019-01-04 00:00:00 | 2019-07-30 00:00:00 | 2019-10-30 00:00:00 | 2021-01-29 00:00:00 | 2019-04-19 00:00:00 | 2018-12-27 00:00:00 | 2019-01-07 00:00:00 | 2018-07-31 00:00:00 | 2016-04-27 00:00:00 | 2016-01-29 00:00:00 | 2016-07-29 00:00:00 | 2016-10-28 00:00:00 | 2016-12-28 00:00:00 | 2017-04-28 00:00:00 | 2016-12-27 00:00:00 | 2016-12-28 00:00:00 | 2017-01-31 00:00:00 | 2017-07-29 00:00:00 | 2021-01-04 00:00:00 | 2018-12-27 00:00:00 | 2019-11-18 00:00:00 | 2018-02-23 00:00:00 | 2020-04-24 00:00:00 | 2019-01-30 00:00:00 | 2020-12-30 00:00:00 | 2020-01-30 00:00:00 | 2018-01-02 00:00:00 | 2018-01-31 00:00:00 | 2020-12-30 00:00:00 | 2020-12-31 00:00:00 | 2018-04-26 00:00:00 | 2018-12-21 00:00:00 | 2017-10-31 00:00:00 | 2018-10-30 00:00:00 | 2021-02-05 00:00:00 | 2022-01-28 00:00:00 | 2021-07-30 00:00:00 | 2021-04-29 00:00:00 | 2020-10-30 00:00:00 | 2022-04-14 00:00:00 | 2020-07-24 00:00:00 | 2022-07-29 00:00:00 | 2022-06-22 00:00:00 | 2020-12-28 00:00:00 | 2020-12-08 00:00:00 | 2020-12-31 00:00:00 | 2022-04-29 00:00:00 | 2021-12-14 00:00:00 | 2021-10-28 00:00:00 | 2022-10-28 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10002 | 10005 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10005 | 10005 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10001 | 10005 | 10002 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10002 | 10002 | 10002 | 10001 | 10002 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10002 | 10005 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10002 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10006 | 10005 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10002 | 10002 | 10002 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10006 | 10006 | 10005 | 10001 | 10001 | 10001 | 10001 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10002 | 10005 | 10002 | 10005 | 10001 | 10002 | 10001 | 10001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 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 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1997 | 1997 | 1997 | 1997 | 1997 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 2001 | 2001 | 1999 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2001 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2005 | 2005 | 2003 | 2003 | 2005 | 2003 | 2003 | 2003 | 2003 | 2003 | 2004 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2007 | 2007 | 2005 | 2007 | 2007 | 2007 | 2005 | 2007 | 2007 | 2007 | 2007 | 2013 | 2013 | 2013 | 2013 | 2015 | 2015 | 2013 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2009 | 2009 | 2008 | 2009 | 2009 | 2009 | 2007 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2013 | 2015 | 2015 | 2011 | 2013 | 2013 | 2011 | 2013 | 2013 | 2013 | 2013 | 2015 | 2015 | 2015 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2017 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2017 | 2015 | 2017 | 2021 | 2019 | 2019 | 2017 | 2019 | 2017 | 2021 | 2019 | 2017 | 2017 | 2021 | 2021 | 2017 | 2019 | 2017 | 2017 | 2021 | 2021 | 2021 | 2021 | 2019 | 2021 | 2019 | 2021 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | * | * | * | * | * | TTHAM | YBONILLA | * | YBONILLA | * | * | GGILMORE | JBRANNAN | YBONILLA | YBONILLA | * | LTHIBAUL | * | * | LTHIBAUL | * | LTHIBAUL | * | LTHIBAUL | LTHIBAUL | LTHIBAUL | * | * | PBANFORD | COMPLETED | LTHIBAUL | COMPLETED | LTHIBAUL | COMPLETED | LTHIBAUL | GPEREZ | GPEREZ | LTHIBAUL | COMPLETED | COMPLETED | LTHIBAUL | SARRIAGA | LTHIBAUL | COMPLETED | COMPLETED | COMPLETED | LTHIBAUL | COMPLETED | COMPLETED | CFLAGG | CFLAGG | COMPLETED | DHORRELL | COMPLETED | COMPLETED | COMPLETED | KVOONG1 | COMPLETED | COMPLETED | COMPLETED | COMPLETED | COMPLETED | LLEONG | SARRIAGA | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | GPEREZ | LTHIBAUL | LTHIBAUL | CFLAGG | * | * | * | LTHIBAUL | GPEREZ | SARRIAGA | PBANFORD | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | SARRIAGA | AGLADNEY | AGLADNEY | ASAETERN | MPACHECO | PBANFORD | GPEREZ | AGLADNEY | LTHIBAUL | * | LTHIBAUL | YRODRIGU | LTHIBAUL | LTHIBAUL | YRODRIGU | CFLAGG | * | YRODRIGU | PBANFORD | PBANFORD | JINGRAM | JINGRAM | MGUERRA | PBANFORD | JINGRAM | MGUERRA | MGUERRA | PBANFORD | YRODRIGU | MGUERRA | YRODRIGU | MGUERRA | JINGRAM | JINGRAM | JINGRAM | ASAETERN | ASAETERN | AGLADNEY | PBANFORD | YRODRIGU | PBANFORD | SARRIAGA | YRODRIGU | YRODRIGU | ASAETERN | AGLADNEY | YRODRIGU | YRODRIGU | YRODRIGU | AGLADNEY | ASAETERN | ASAETERN | ASAETERN | CFLAGG | AGLADNEY | ASAETERN | ASAETERN | PBANFORD | CAFILER | AGLADNEY | PBANFORD | CAFILER | AGLADNEY | PBANFORD | PBANFORD | PBANFORD | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | YRODRIGU | YRODRIGU | VUKSTINA | VUKSTINA | CREYNOLDS2 | VUKSTINA | GPEREZ | YRODRIGU | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | YRODRIGU | AGLADNEY | SARRIAGA | SARRIAGA | AGLADNEY | AGLADNEY | JMENDOZA | GPEREZ | GPEREZ | CAFILER | VUKSTINA | AGLADNEY | MMERCHANT | VUKSTINA | YRODRIGU | AGLADNEY | MMERCHANT | MMERCHANT | AGLADNEY | YRODRIGU | AGLADNEY | AGLADNEY | JMENDOZA | RATTIYEH | CHATRIDGE | CHATRIDGE | GTAYLOR | CAFILER | MKIRKHAM | CAFILER | CAFILER | AROJAS | GTAYLOR | MMERCHANT | CAFILER | CHATRIDGE | CHATRIDGE | CAFILER | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 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 | 11002 | 11003 | 11002 | 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 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 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 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 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 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1998-04-01 00:00:00 | 1998-01-01 00:00:00 | 1998-07-01 00:00:00 | 1998-10-01 00:00:00 | 1998-01-01 00:00:00 | 1999-07-01 00:00:00 | 1999-04-01 00:00:00 | 1999-01-01 00:00:00 | 1999-10-01 00:00:00 | 2000-01-01 00:00:00 | 2000-04-01 00:00:00 | 2000-07-01 00:00:00 | 2000-07-01 00:00:00 | 2000-10-01 00:00:00 | 2000-10-01 00:00:00 | 1900-01-01 00:00:00 | 2001-01-01 00:00:00 | 2000-01-01 00:00:00 | 2000-10-01 00:00:00 | 2001-01-01 00:00:00 | 2001-04-01 00:00:00 | 2001-04-01 00:00:00 | 2001-07-01 00:00:00 | 2001-07-01 00:00:00 | 2001-10-01 00:00:00 | 2001-10-01 00:00:00 | 2002-01-01 00:00:00 | 2002-04-01 00:00:00 | 2002-01-01 00:00:00 | 2002-07-01 00:00:00 | 2002-04-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 | 2003-01-01 00:00:00 | 2003-04-01 00:00:00 | 2003-04-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2003-07-01 00:00:00 | 2003-07-01 00:00:00 | 2003-10-01 00:00:00 | 2003-10-01 00:00:00 | 1900-01-01 00:00:00 | 2004-01-01 00:00:00 | 2004-01-01 00:00:00 | 2004-04-01 00:00:00 | 2004-08-20 00:00:00 | 2004-04-01 00:00:00 | 2004-08-13 00:00:00 | 2004-07-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2005-01-12 00:00:00 | 2004-07-01 00:00:00 | 2004-07-01 00:00:00 | 2004-12-20 00:00:00 | 2004-10-01 00:00:00 | 2004-10-01 00:00:00 | 2004-04-01 00:00:00 | 2004-07-01 00:00:00 | 2004-10-01 00:00:00 | 2004-12-27 00:00:00 | 2004-04-01 00:00:00 | 1900-01-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 | 2006-01-01 00:00:00 | 1900-01-01 00:00:00 | 2005-10-01 00:00:00 | 2006-04-01 00:00:00 | 1900-01-01 00:00:00 | 2006-12-19 00:00:00 | 2006-12-14 00:00:00 | 2006-12-15 00:00:00 | 2006-07-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2006-10-01 00:00:00 | 2007-04-01 00:00:00 | 2007-07-01 00:00:00 | 2007-01-01 00:00:00 | 1900-01-01 00:00:00 | 2013-04-01 00:00:00 | 2013-01-01 00:00:00 | 2014-04-01 00:00:00 | 2014-10-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2014-07-01 00:00:00 | 2007-10-01 00:00:00 | 2008-04-03 00:00:00 | 2007-10-01 00:00:00 | 1900-01-01 00:00:00 | 2008-04-01 00:00:00 | 2008-01-01 00:00:00 | 2008-12-12 00:00:00 | 1900-01-01 00:00:00 | 2009-01-03 00:00:00 | 2008-12-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2008-07-01 00:00:00 | 2008-10-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-04-01 00:00:00 | 1900-01-01 00:00:00 | 2008-12-19 00:00:00 | 2009-07-01 00:00:00 | 2009-06-29 00:00:00 | 2009-10-01 00:00:00 | 2009-10-01 00:00:00 | 2009-07-01 00:00:00 | 2009-07-01 00:00:00 | 2010-01-01 00:00:00 | 2010-04-01 00:00:00 | 2010-07-01 00:00:00 | 1900-01-01 00:00:00 | 2010-12-15 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2010-12-29 00:00:00 | 2010-12-30 00:00:00 | 2010-10-01 00:00:00 | 2011-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2011-04-01 00:00:00 | 2011-07-01 00:00:00 | 2011-10-01 00:00:00 | 2012-01-01 00:00:00 | 1900-01-01 00:00:00 | 2012-04-01 00:00:00 | 2013-07-01 00:00:00 | 2013-10-01 00:00:00 | 2014-12-30 00:00:00 | 2014-12-15 00:00:00 | 2012-07-01 00:00:00 | 2012-12-12 00:00:00 | 2012-12-07 00:00:00 | 2012-10-01 00:00:00 | 2012-12-18 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2014-01-01 00:00:00 | 2015-07-01 00:00:00 | 2015-04-01 00:00:00 | 2015-01-01 00:00:00 | 2018-12-30 00:00:00 | 2019-01-04 00:00:00 | 2019-04-01 00:00:00 | 2019-07-01 00:00:00 | 2020-10-01 00:00:00 | 2019-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-04-01 00:00:00 | 2016-01-01 00:00:00 | 2015-10-01 00:00:00 | 2016-04-01 00:00:00 | 2016-07-01 00:00:00 | 2016-12-28 00:00:00 | 2017-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2016-10-01 00:00:00 | 2017-04-01 00:00:00 | 2021-01-04 00:00:00 | 2018-12-27 00:00:00 | 1900-01-01 00:00:00 | 2018-02-23 00:00:00 | 2020-01-01 00:00:00 | 2018-10-01 00:00:00 | 2020-12-31 00:00:00 | 2019-10-01 00:00:00 | 1900-01-01 00:00:00 | 2017-10-01 00:00:00 | 2020-12-30 00:00:00 | 1900-01-01 00:00:00 | 2018-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-07-01 00:00:00 | 2018-07-01 00:00:00 | 1900-01-01 00:00:00 | 2021-10-01 00:00:00 | 2021-04-01 00:00:00 | 2021-01-01 00:00:00 | 2020-07-01 00:00:00 | 2021-01-01 00:00:00 | 2020-04-01 00:00:00 | 2022-04-01 00:00:00 | 2021-04-01 00:00:00 | 1900-01-01 00:00:00 | 2020-04-01 00:00:00 | 1900-01-01 00:00:00 | 2022-01-01 00:00:00 | 2021-07-01 00:00:00 | 2021-07-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1998-06-30 00:00:00 | 1998-03-31 00:00:00 | 1998-09-30 00:00:00 | 1998-12-31 00:00:00 | 1998-03-31 00:00:00 | 1999-09-30 00:00:00 | 1999-06-30 00:00:00 | 1999-03-31 00:00:00 | 1999-12-31 00:00:00 | 2000-03-31 00:00:00 | 2000-06-30 00:00:00 | 2000-09-30 00:00:00 | 2000-09-30 00:00:00 | 2000-12-31 00:00:00 | 2000-12-31 00:00:00 | 1900-01-01 00:00:00 | 2001-03-31 00:00:00 | 2000-12-31 00:00:00 | 2000-12-31 00:00:00 | 2001-03-31 00:00:00 | 2001-06-30 00:00:00 | 2001-06-30 00:00:00 | 2001-09-30 00:00:00 | 2001-09-30 00:00:00 | 2001-12-31 00:00:00 | 2001-12-31 00:00:00 | 2002-03-31 00:00:00 | 2002-06-30 00:00:00 | 2002-03-31 00:00:00 | 2002-09-30 00:00:00 | 2002-06-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 | 2003-03-31 00:00:00 | 2003-06-30 00:00:00 | 2003-06-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2003-09-30 00:00:00 | 2003-09-30 00:00:00 | 2003-12-31 00:00:00 | 2003-12-31 00:00:00 | 1900-01-01 00:00:00 | 2004-03-31 00:00:00 | 2004-03-31 00:00:00 | 2004-06-30 00:00:00 | 2004-08-20 00:00:00 | 2004-06-30 00:00:00 | 2004-08-13 00:00:00 | 2004-09-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2005-01-12 00:00:00 | 2004-09-30 00:00:00 | 2004-09-30 00:00:00 | 2004-12-20 00:00:00 | 2004-12-31 00:00:00 | 2004-12-31 00:00:00 | 2004-06-30 00:00:00 | 2004-09-30 00:00:00 | 2004-12-31 00:00:00 | 2004-12-27 00:00:00 | 2004-06-30 00:00:00 | 1900-01-01 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 | 2006-03-31 00:00:00 | 1900-01-01 00:00:00 | 2005-12-31 00:00:00 | 2006-06-30 00:00:00 | 1900-01-01 00:00:00 | 2006-12-19 00:00:00 | 2006-12-14 00:00:00 | 2006-12-15 00:00:00 | 2006-09-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2006-12-31 00:00:00 | 2007-06-30 00:00:00 | 2007-09-30 00:00:00 | 2007-03-31 00:00:00 | 1900-01-01 00:00:00 | 2013-06-30 00:00:00 | 2013-03-31 00:00:00 | 2014-06-30 00:00:00 | 2014-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2014-09-30 00:00:00 | 2007-12-31 00:00:00 | 2008-04-03 00:00:00 | 2007-12-31 00:00:00 | 1900-01-01 00:00:00 | 2008-06-30 00:00:00 | 2008-03-31 00:00:00 | 2008-12-12 00:00:00 | 1900-01-01 00:00:00 | 2009-01-03 00:00:00 | 2008-12-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2008-09-30 00:00:00 | 2008-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2009-03-31 00:00:00 | 2009-06-30 00:00:00 | 1900-01-01 00:00:00 | 2008-12-19 00:00:00 | 2009-09-30 00:00:00 | 2009-06-29 00:00:00 | 2009-12-31 00:00:00 | 2009-12-31 00:00:00 | 2009-09-30 00:00:00 | 2009-09-30 00:00:00 | 2010-03-31 00:00:00 | 2010-06-30 00:00:00 | 2010-09-30 00:00:00 | 1900-01-01 00:00:00 | 2010-12-15 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2010-12-29 00:00:00 | 2010-12-30 00:00:00 | 2010-12-31 00:00:00 | 2011-03-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00 | 2012-03-31 00:00:00 | 1900-01-01 00:00:00 | 2012-06-30 00:00:00 | 2013-09-30 00:00:00 | 2013-12-31 00:00:00 | 2014-12-30 00:00:00 | 2014-12-15 00:00:00 | 2012-09-30 00:00:00 | 2012-12-12 00:00:00 | 2012-12-07 00:00:00 | 2012-12-31 00:00:00 | 2012-12-18 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2014-03-31 00:00:00 | 2015-09-30 00:00:00 | 2015-06-30 00:00:00 | 2015-03-31 00:00:00 | 2018-12-30 00:00:00 | 2019-01-04 00:00:00 | 2019-06-30 00:00:00 | 2019-09-30 00:00:00 | 2020-12-31 00:00:00 | 2019-03-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-06-30 00:00:00 | 2016-03-31 00:00:00 | 2015-12-31 00:00:00 | 2016-06-30 00:00:00 | 2016-09-30 00:00:00 | 2016-12-28 00:00:00 | 2017-03-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2016-12-31 00:00:00 | 2017-06-30 00:00:00 | 2021-01-04 00:00:00 | 2018-12-27 00:00:00 | 1900-01-01 00:00:00 | 2018-02-23 00:00:00 | 2020-03-31 00:00:00 | 2018-12-31 00:00:00 | 2020-12-31 00:00:00 | 2019-12-31 00:00:00 | 1900-01-01 00:00:00 | 2017-12-31 00:00:00 | 2020-12-30 00:00:00 | 1900-01-01 00:00:00 | 2018-03-31 00:00:00 | 1900-01-01 00:00:00 | 2017-09-30 00:00:00 | 2018-09-30 00:00:00 | 1900-01-01 00:00:00 | 2021-12-31 00:00:00 | 2021-06-30 00:00:00 | 2021-04-30 00:00:00 | 2020-09-30 00:00:00 | 2021-03-31 00:00:00 | 2020-06-30 00:00:00 | 2022-06-30 00:00:00 | 2021-06-30 00:00:00 | 1900-01-01 00:00:00 | 2020-06-30 00:00:00 | 1900-01-01 00:00:00 | 2022-03-31 00:00:00 | 2021-09-30 00:00:00 | 2021-09-30 00:00:00 | 2022-09-30 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 22001 | None | 22001 | None | 22001 | None | None | None | None | 22001 | 22001 | None | None | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | None | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | 22006 | 22006 | 22001 | 22001 | None | None | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | None | 22001 | 22001 | None | None | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | None | None | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22006 | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22006 | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22006 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | None | 22001 | 22001 | 22001 | 22001 |
filer_id | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 2001 | 2003 | 1999 | 1997 | 2009 | 2013 | 2007 | 2005 | 2011 | 2015 | 2019 | 2017 | 2021 | 2023 | ||||||||||||||
interest_cd | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | ||||||||||||||
effect_date | 2001-01-01 00:00:00 | 2003-01-01 00:00:00 | 1999-01-01 00:00:00 | 1998-01-23 00:00:00 | 2009-01-01 00:00:00 | 2013-01-01 00:00:00 | 2007-01-01 00:00:00 | 2005-01-01 00:00:00 | 2011-01-01 00:00:00 | 2015-01-01 00:00:00 | 2019-01-01 00:00:00 | 2017-01-01 00:00:00 | 2021-01-01 00:00:00 | 2023-01-01 00:00:00 |
filer_id | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 1 | 2 | 1 | 2 | 1 | 1 | 1 | 1 | 1 | ||||||||||||||||
active | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | N | ||||||||||||||||
race | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||
session_id | 1997 | 1999 | 2001 | 2003 | 2005 | 2005 | 2007 | 2013 | 2009 | 2011 | 2011 | 2017 | 2015 | 2019 | 2021 | 2023 | ||||||||||||||||
category | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||
category_type | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||
sub_category | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||
effect_dt | 1998-01-23 00:00:00 | 1999-01-01 00:00:00 | 2001-01-01 00:00:00 | 2003-01-01 00:00:00 | 2005-01-05 00:00:00 | 2006-05-15 00:00:00 | 2007-01-01 00:00:00 | 2013-01-01 00:00:00 | 2009-01-01 00:00:00 | 2012-06-01 00:00:00 | 2011-01-01 00:00:00 | 2017-01-01 00:00:00 | 2015-01-01 00:00:00 | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | 2023-01-01 00:00:00 | ||||||||||||||||
sub_category_type | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||
election_type | 0 | 0 | 0 | None | None | 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 | 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 | None | ||||||||||||||||
party_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||
county_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||
district_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1145756 | |
---|---|---|
xref_id | C27272 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | C27272 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
naml | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT | SOUTH COAST AIR QUALITY MANAGEMENT | SOUTH COAST AIR QUALITY MANAGEMENT | SOUTH COAST AIR QUALITY MANAGEMENT | SOUTH COAST AIR QUALITY MANAGEMENT | SOUTH COAST AIR QUALITY MANAGEMENT | SOUTH COAST AIR QUALITY MANAGEMENT | SOUTH COAST AIR QUALITY MANAGEMENT | SOUTH COAST AIR QUALITY MANAGEMENT | SOUTH COAST AIR QUALITY MANAGEMENT | SOUTH COAST AIR QUALITY MANAGEMENT | SOUTH COAST AIR QUALITY MANAGEMENT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
city | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | DIAMOND BAR | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
zip4 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | 91765 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 9093962100 | 9093962100 | 9093963242 | 9093963242 | 9093962100 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962100 | 9093962100 | 9093963242 | 9093963242 | 9093962100 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962100 | 9093962100 | 9093963242 | 9093963242 | 9093962100 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962100 | 9093962100 | 9093963242 | 9093963242 | 9093962100 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962100 | 9093962100 | 9093963242 | 9093963242 | 9093962100 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962100 | 9093962100 | 9093963242 | 9093963242 | 9093962100 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962100 | 9093962100 | 9093963242 | 9093963242 | 9093962100 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962100 | 9093962100 | 9093963242 | 9093963242 | 9093962100 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962100 | 9093962100 | 9093963242 | 9093963242 | 9093962100 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962100 | 9093962100 | 9093963242 | 9093963242 | 9093962100 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962100 | 9093962100 | 9093963242 | 9093963242 | 9093962100 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962100 | 9093962100 | 9093963242 | 9093963242 | 9093962100 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | 9093962530 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | 9093963340 | 9093963794 | 9093963925 | 9093963925 | 9093963925 | 9093963925 | 9093963925 | 9093963925 | 9093963340 | 9093963794 | 9093963925 | 9093963925 | 9093963925 | 9093963925 | 9093963925 | 9093963925 | 9093963340 | 9093963794 | 9093963925 | 9093963925 | 9093963925 | 9093963925 | 9093963925 | 9093963925 | 9093963340 | 9093963794 | 9093963925 | 9093963925 | 9093963925 | 9093963925 | 9093963925 | 9093963925 | 9093963340 | 9093963794 | 9093963925 | 9093963925 | 9093963925 | 9093963925 | 9093963925 | 9093963925 | 9093963340 | 9093963794 | 9093963925 | 9093963925 | 9093963925 | 9093963925 | 9093963925 | 9093963925 | 9093963340 | 9093963794 | 9093963925 | 9093963925 | 9093963925 | 9093963925 | 9093963925 | 9093963925 | 9093963340 | 9093963794 | 9093963925 | 9093963925 | 9093963925 | 9093963925 | 9093963925 | 9093963925 | 9093963340 | 9093963794 | 9093963925 | 9093963925 | 9093963925 | 9093963925 | 9093963925 | 9093963925 | 9093963340 | 9093963794 | 9093963925 | 9093963925 | 9093963925 | 9093963925 | 9093963925 | 9093963925 | 9093963340 | 9093963794 | 9093963925 | 9093963925 | 9093963925 | 9093963925 | 9093963925 | 9093963925 | 9093963340 | 9093963794 | 9093963925 | 9093963925 | 9093963925 | 9093963925 | 9093963925 | 9093963925 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 1145756 |
---|
filer_id | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
change_no | 1 | 0 | 2 | 5 | 4 | 3 | 8 | 6 | 9 | 10 | 11 | 12 | 13 | 14 | ||||||||||||||
session_id | 2003 | 2003 | 2003 | 2007 | 2007 | 2005 | 2007 | 2007 | 2011 | 2011 | 2011 | 2017 | 2019 | 2021 | ||||||||||||||
log_dt | 2004-01-12 00:00:00 | 2003-12-01 00:00:00 | 2004-10-06 00:00:00 | 2007-08-13 00:00:00 | 2007-01-04 00:00:00 | 2006-09-26 00:00:00 | 2008-04-15 00:00:00 | 2008-04-15 00:00:00 | 2012-04-17 00:00:00 | 2012-06-18 00:00:00 | 2012-06-18 00:00:00 | 2018-01-02 00:00:00 | 2020-08-12 00:00:00 | 2020-12-31 00:00:00 | ||||||||||||||
filer_type | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | ||||||||||||||
correction_flg | Y | Y | None | Y | Y | None | Y | Y | None | None | None | Y | None | None | ||||||||||||||
action | ADDED | ADDED | DELETED | ADDED | ADDED | DELETED | ADDED | DELETED | DELETED | DELETED | SET ACTIVE | ADDED | DELETED | CHANGED | ||||||||||||||
attribute_changed | None | None | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | FIRM | LOBBYIST | FIRM | FIRM | RESPONSIBLE OFFICER | |||||||||||||||
ethics_dt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
interests | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
filer_full_name | SOUTH COAST AIR QUALITY MANAGEMENT | SOUTH COAST AIR QUALITY MANAGEMENT | SOUTH COAST AIR QUALITY MANAGEMENT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | SOUTH COAST AIR QUALITY MANAGEMENT DISTRICT | ||||||||||||||
filer_city | DIAMOND BAR | None | None | DIAMOND BAR | DIAMOND BAR | None | None | None | None | None | None | DIAMOND BAR | None | None | ||||||||||||||
filer_st | CA | None | None | CA | CA | None | None | None | None | None | None | CA | None | None | ||||||||||||||
filer_zip | 91765 | None | None | 91765 | 91765 | None | None | None | None | None | None | 91765 | None | None | ||||||||||||||
filer_phone | 9093962100 | None | None | 9093962100 | 9093962100 | None | None | None | None | None | None | 9093962100 | None | None | ||||||||||||||
entity_type | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 2 | 3 | 3 | 20 | ||||||||||||||
entity_name | RPG AND ASSOCIATES | SLOAN, A PROFESSIONAL CORPORATION, SHELDON H. | SLOAN, A PROFESSIONAL CORPORATION, SHELDON H. | GONSALVES & SON; JOE A. | RGP AND ASSOCIATES | LIND & ASSOCIATES, ALLAN | TRES ES INC. | RGP AND ASSOCIATES | SLOAT HIGGINS JENSEN AND ASSOCIATES | OSCAR ABARCA | None | QUINTANA CRUZ COMPANY; THE | CAMPBELL STRATEGY & ADVOCACY | ACTING EXECUTIVE OFFICER BARBARA BAIRD | ||||||||||||||
entity_city | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
entity_st | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
entity_zip | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
entity_phone | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
entity_id | None | 1147506 | 1147506 | None | None | 1147479 | 1305577 | 1261811 | 1147635 | 1287375 | 0 | None | 1382722 | 1436025 | ||||||||||||||
responsible_officer | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
effect_dt | 2004-01-01 00:00:00 | 2003-11-18 00:00:00 | 2004-09-30 00:00:00 | 2007-08-13 00:00:00 | 2007-01-01 00:00:00 | 2006-06-30 00:00:00 | 2008-01-01 00:00:00 | 2007-12-31 00:00:00 | 2011-12-31 00:00:00 | 2012-06-01 00:00:00 | 2012-06-01 00:00:00 | 2018-01-02 00:00:00 | 2020-08-01 00:00:00 | 2021-01-01 00:00:00 |
filer_id | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | 1145756 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 710190_0.cal | 681870_0.cal | 710190_1.cal | 202445.cal | 744088_0.cal | 201328.cal | 201323.cal | 769326_0.cal | 787636_0.cal | 808543_0.cal | 840014_0.cal | 854162_0.cal | 879254_0.cal | 908396_0.cal | 930801_0.cal | 947087_0.cal | 968826_0.cal | 987968_0.cal | 1014403_0.cal | 1026461_0.cal | 154686.cal | 1038370_1.cal | 1053386_0.cal | 284317.cal | 284676.cal | 284654.cal | 1068101_0.cal | 1026461_2.cal | 1026461_1.cal | 361492.cal | 362296.cal | 1309195_1.cal | 1328109_0.cal | 1396048_0.cal | 1348796_0.cal | 1484789_0.cal | 1462695_0.cal | 1225044_0.cal | 1438105_0.cal | 1422093_0.cal | 1297994_0.cal | 1378832_0.cal | 316198.cal | 316550.cal | 307956.cal | 177326.cal | 177296.cal | 177436.cal | 177493.cal | 1309195_0.cal | 1539151_0.cal | 1569484_0.cal | ||||||||||||||||||||||||||||||||||||||||||||||||||||
received_date | 2001-01-16 00:00:00 | 2000-10-31 00:00:00 | 2001-01-23 00:00:00 | 2001-04-26 00:00:00 | 2001-04-26 00:00:00 | 2001-04-25 00:00:00 | 2001-04-25 00:00:00 | 2001-07-24 00:00:00 | 2001-10-17 00:00:00 | 2002-01-22 00:00:00 | 2002-04-30 00:00:00 | 2002-07-30 00:00:00 | 2002-10-25 00:00:00 | 2003-01-29 00:00:00 | 2003-04-30 00:00:00 | 2003-07-31 00:00:00 | 2003-10-30 00:00:00 | 2004-01-29 00:00:00 | 2004-04-30 00:00:00 | 2004-07-27 00:00:00 | 2004-08-19 00:00:00 | 2004-08-20 00:00:00 | 2004-10-25 00:00:00 | 2005-01-28 00:00:00 | 2005-01-28 00:00:00 | 2005-01-28 00:00:00 | 2004-12-28 00:00:00 | 2005-04-05 00:00:00 | 2005-03-31 00:00:00 | 2006-07-31 00:00:00 | 2006-07-31 00:00:00 | 2008-04-17 00:00:00 | 2008-04-29 00:00:00 | 2009-01-30 00:00:00 | 2008-07-30 00:00:00 | 2010-04-30 00:00:00 | 2010-01-29 00:00:00 | 2006-12-28 00:00:00 | 2009-07-31 00:00:00 | 2009-04-30 00:00:00 | 2007-10-31 00:00:00 | 2008-10-31 00:00:00 | 2008-12-31 00:00:00 | 2008-12-31 00:00:00 | 2008-12-31 00:00:00 | 2008-12-24 00:00:00 | 2008-12-24 00:00:00 | 2008-12-24 00:00:00 | 2008-12-24 00:00:00 | 2008-01-30 00:00:00 | 2010-10-29 00:00:00 | 2011-01-28 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_directory | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/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/cal | /usr/users/cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /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/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/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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_id | 710190 | 681870 | 710190 | None | 744088 | None | None | 769326 | 787636 | 808543 | 840014 | 854162 | 879254 | 908396 | 930801 | 947087 | 968826 | 987968 | 1014403 | 1026461 | None | 1038370 | 1053386 | None | None | None | 1068101 | 1026461 | 1026461 | None | None | 1309195 | 1328109 | 1396048 | 1348796 | 1484789 | 1462695 | 1225044 | 1438105 | 1422093 | 1297994 | 1378832 | None | None | None | None | None | None | None | 1309195 | 1539151 | 1569484 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F635 | F635 | F635 | None | F635 | None | None | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | None | F602 | F635 | None | None | None | F602 | F635 | F635 | None | None | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | None | None | None | None | None | None | None | F635 | F635 | F635 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
receive_comment | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing did not pass validation | Filing accepted, but with warnings | Filing did not pass validation | Filing did not pass validation | Filing accepted, but with warnings | Filing accepted, but with warnings | 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 did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing accepted | Filing accepted | Filing accepted | Filing did not pass validation | Filing did not pass validation | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing accepted | Filing accepted | Filing accepted |