filer_id | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1090999 | 1091000 | 2041416 | 2110654 | 2157920 | 2477771 | 2477770 | 2322378 | ||||||||
effect_dt | 1999-06-10 00:00:00 | 1999-06-10 00:00:00 | 2002-12-03 00:00:00 | 2006-08-03 00:00:00 | 2006-08-01 00:00:00 | 2019-02-01 00:00:00 | 2019-02-01 00:00:00 | 2014-07-10 00:00:00 | ||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7082 | 7082 | 7051 | 7051 | ||||||||
session_id | 1999 | 1999 | 2001 | 2005 | 2005 | 2019 | 2019 | 2013 |
filer_id | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 416837 | 416838 | 416839 | 416840 | 581665 | 647888 | 723403 | 763275 | 763277 | 761668 | 761670 | 761668 | 761670 | 784281 | 773517 | 784149 | 806923 | 859028 | 895407 | 915979 | 913218 | 947056 | 953566 | 806923 | 859028 | 915979 | 784149 | 761670 | 761668 | 952171 | 979306 | 982067 | 1026597 | 1024506 | 1080763 | 1077594 | 1095661 | 1095661 | 1116827 | 1144969 | 1117992 | 1116827 | 1144331 | 1117992 | 1190234 | 1192800 | 1205624 | 1192800 | 1210901 | 1203780 | 1231053 | 1190234 | 895407 | 1237887 | 1234133 | 1286020 | 1274648 | 1274650 | 1274678 | 1274679 | 1264052 | 1308233 | 1282915 | 1264630 | 895407 | 1684164 | 1936741 | 1895010 | 1893782 | 1318301 | 1319253 | 1319866 | 1319253 | 1334077 | 1319866 | 1309965 | 1350346 | 1348176 | 1335427 | 1364471 | 1362425 | 1389105 | 1392034 | 1399295 | 1403234 | 1403526 | 1417029 | 1417031 | 1396267 | 1389105 | 1423548 | 1423209 | 1423595 | 1423209 | 1435974 | 1456210 | 1440058 | 1440061 | 1435974 | 1465430 | 1468733 | 1454445 | 1483244 | 1481604 | 1487430 | 1389105 | 1487251 | 1491865 | 1494376 | 1508322 | 1510220 | 1494376 | 1522631 | 1526787 | 1491865 | 1572555 | 1491865 | 1508322 | 1574045 | 1581197 | 1581200 | 1581244 | 1494376 | 1510220 | 1579338 | 1580215 | 1580216 | 1580217 | 1579338 | 1580920 | 1580921 | 1580922 | 1593942 | 1389105 | 1389105 | 1599964 | 1684164 | 1862442 | 1755284 | 1757958 | 2012390 | 2034893 | 2042416 | 2031468 | 2021742 | 2049991 | 2042416 | 2048286 | 2048288 | 2049116 | 2043882 | 2049990 | 2034893 | 2047180 | 2012390 | 2062529 | 2085597 | 2104529 | 2104530 | 2357341 | 2496159 | 2690902 | 2692298 | 2712954 | 2719737 | 2723322 | 2724532 | 2636841 | 2686074 | 2686074 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 157 | 158 | 158 | 158 | None | None | None | None | None | None | None | None | None | None | 166 | None | None | None | None | None | 172 | 173 | None | None | None | None | None | None | None | None | 175 | None | None | 177 | 179 | None | 181 | 181 | None | None | 181 | None | 183 | 181 | 185 | None | None | None | 188 | 187 | None | 185 | None | None | 188 | None | None | None | None | None | 190 | 191 | 189 | 190 | None | None | 220 | None | 219 | 193 | 193 | None | 193 | 193 | None | None | None | 194 | None | None | 195 | 197 | None | None | 197 | None | 197 | 197 | 196 | 198 | None | 197 | None | 197 | 198 | 200 | None | None | 198 | 199 | 201 | None | None | 202 | 202 | 202 | 202 | 201 | None | 202 | None | None | 203 | None | 201 | 204 | 201 | 202 | None | 205 | 205 | 205 | None | None | 205 | 205 | 205 | 205 | 205 | 205 | 205 | 205 | None | 207 | 206 | None | None | None | None | 214 | 223 | 225 | 226 | 226 | None | 226 | 226 | 226 | 226 | 226 | None | 226 | 225 | 226 | 223 | 226 | 228 | 228 | 228 | None | None | 250 | 250 | 251 | 251 | 251 | 251 | None | 250 | 252 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F420 | F410 | F497 | F420 | F420 | F460 | F460 | F497 | F497 | F460 | F460 | F460 | F460 | F465 | F460 | F460 | F460 | F460 | F410 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F497 | F497 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F497 | F460 | F497 | F460 | F410 | F460 | F460 | F460 | F497 | F497 | F497 | F497 | F497 | F460 | F460 | F497 | F410 | F465 | F460 | F460 | F460 | F497 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F410 | F410 | F460 | F460 | F495 | F497 | F497 | F460 | F410 | F410 | F460 | F460 | F460 | F460 | F497 | F460 | F460 | F460 | F460 | F497 | F410 | F410 | F497 | F497 | F410 | F497 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F496 | F496 | F496 | F460 | F460 | F496 | F496 | F496 | F496 | F496 | F465 | F465 | F465 | F410 | F410 | F410 | F410 | F465 | F410 | F410 | F497 | F460 | F460 | F496 | F497 | F460 | F496 | F496 | F496 | F496 | F497 | F460 | F496 | F460 | F460 | F460 | F460 | F497 | F496 | F496 | F410 | F410 | F497 | F497 | F497 | F497 | F497 | F497 | F410 | F497 | F497 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 4 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1999-06-07 00:00:00 | 1999-06-08 00:00:00 | 1999-06-04 00:00:00 | 1999-08-02 00:00:00 | 2000-01-10 00:00:00 | 2000-07-29 00:00:00 | 2001-01-31 00:00:00 | 2001-06-07 00:00:00 | 2001-06-07 00:00:00 | 2001-05-23 00:00:00 | 2001-05-23 00:00:00 | 2001-06-12 00:00:00 | 2001-06-12 00:00:00 | 2001-07-31 00:00:00 | 2001-07-31 00:00:00 | 2001-07-31 00:00:00 | 2002-01-10 00:00:00 | 2002-07-30 00:00:00 | 2002-12-03 00:00:00 | 2003-01-31 00:00:00 | 2003-01-31 00:00:00 | 2003-07-30 00:00:00 | 2003-08-04 00:00:00 | 2003-08-04 00:00:00 | 2003-08-04 00:00:00 | 2003-08-04 00:00:00 | 2003-08-04 00:00:00 | 2003-08-04 00:00:00 | 2003-08-04 00:00:00 | 2003-07-31 00:00:00 | 2004-01-09 00:00:00 | 2004-01-12 00:00:00 | 2004-07-26 00:00:00 | 2004-07-21 00:00:00 | 2005-01-31 00:00:00 | 2005-01-18 00:00:00 | 2005-03-08 00:00:00 | 2005-03-09 00:00:00 | 2005-07-28 00:00:00 | 2006-01-25 00:00:00 | 2005-07-31 00:00:00 | 2005-10-11 00:00:00 | 2006-01-25 00:00:00 | 2005-09-28 00:00:00 | 2006-07-30 00:00:00 | 2006-08-03 00:00:00 | 2006-10-05 00:00:00 | 2006-07-26 00:00:00 | 2006-10-24 00:00:00 | 2006-10-04 00:00:00 | 2006-10-24 00:00:00 | 2006-08-01 00:00:00 | 2006-08-03 00:00:00 | 2007-01-30 00:00:00 | 2007-01-29 00:00:00 | 2007-07-31 00:00:00 | 2007-05-04 00:00:00 | 2007-05-04 00:00:00 | 2007-05-08 00:00:00 | 2007-05-08 00:00:00 | 2007-05-04 00:00:00 | 2008-01-29 00:00:00 | 2007-07-30 00:00:00 | 2007-05-08 00:00:00 | 2007-11-07 00:00:00 | 2014-07-10 00:00:00 | 2015-02-02 00:00:00 | 2014-10-06 00:00:00 | 2014-10-06 00:00:00 | 2008-03-14 00:00:00 | 2008-03-20 00:00:00 | 2008-03-21 00:00:00 | 2008-05-21 00:00:00 | 2008-05-21 00:00:00 | 2008-05-22 00:00:00 | 2008-01-30 00:00:00 | 2008-07-30 00:00:00 | 2008-07-29 00:00:00 | 2008-05-22 00:00:00 | 2008-10-06 00:00:00 | 2008-10-05 00:00:00 | 2009-01-12 00:00:00 | 2009-01-14 00:00:00 | 2009-02-02 00:00:00 | 2009-02-19 00:00:00 | 2009-02-20 00:00:00 | 2009-04-10 00:00:00 | 2009-04-10 00:00:00 | 2009-01-30 00:00:00 | 2009-04-16 00:00:00 | 2009-04-17 00:00:00 | 2009-05-07 00:00:00 | 2009-05-07 00:00:00 | 2009-07-29 00:00:00 | 2009-07-29 00:00:00 | 2009-12-28 00:00:00 | 2009-07-30 00:00:00 | 2009-07-30 00:00:00 | 2010-02-01 00:00:00 | 2010-02-01 00:00:00 | 2010-02-09 00:00:00 | 2009-11-09 00:00:00 | 2010-04-23 00:00:00 | 2010-04-22 00:00:00 | 2010-05-12 00:00:00 | 2010-05-10 00:00:00 | 2010-05-11 00:00:00 | 2010-05-27 00:00:00 | 2010-05-27 00:00:00 | 2010-08-02 00:00:00 | 2010-08-02 00:00:00 | 2010-08-26 00:00:00 | 2010-10-05 00:00:00 | 2010-10-05 00:00:00 | 2010-08-26 00:00:00 | 2011-01-31 00:00:00 | 2011-01-31 00:00:00 | 2011-01-31 00:00:00 | 2011-01-31 00:00:00 | 2011-03-04 00:00:00 | 2011-03-04 00:00:00 | 2011-03-06 00:00:00 | 2011-02-01 00:00:00 | 2011-02-01 00:00:00 | 2011-02-25 00:00:00 | 2011-03-01 00:00:00 | 2011-03-01 00:00:00 | 2011-03-01 00:00:00 | 2011-03-01 00:00:00 | 2011-03-03 00:00:00 | 2011-03-03 00:00:00 | 2011-03-03 00:00:00 | 2011-04-12 00:00:00 | 2011-07-11 00:00:00 | 2011-04-28 00:00:00 | 2011-07-12 00:00:00 | 2012-07-31 00:00:00 | 2014-07-10 00:00:00 | 2013-01-23 00:00:00 | 2013-04-16 00:00:00 | 2016-02-01 00:00:00 | 2016-04-28 00:00:00 | 2016-05-12 00:00:00 | 2016-04-22 00:00:00 | 2016-02-01 00:00:00 | 2016-06-06 00:00:00 | 2016-05-31 00:00:00 | 2016-05-31 00:00:00 | 2016-05-31 00:00:00 | 2016-06-02 00:00:00 | 2016-04-28 00:00:00 | 2016-06-06 00:00:00 | 2016-05-26 00:00:00 | 2016-05-26 00:00:00 | 2016-05-26 00:00:00 | 2016-07-29 00:00:00 | 2016-10-05 00:00:00 | 2016-11-03 00:00:00 | 2016-11-03 00:00:00 | 2019-02-01 00:00:00 | 2020-08-03 00:00:00 | 2022-06-03 00:00:00 | 2022-06-07 00:00:00 | 2022-08-19 00:00:00 | 2022-09-13 00:00:00 | 2022-09-24 00:00:00 | 2022-09-27 00:00:00 | 2022-01-21 00:00:00 | 2022-05-25 00:00:00 | 2022-11-03 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10006 | 10006 | 10005 | 10001 | 10005 | 10005 | 10005 | 10002 | 10005 | 10001 | 10001 | 10006 | 10006 | 10006 | 10006 | 10006 | 10006 | 10006 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10002 | 10005 | 10005 | 10001 | 10006 | 10001 | 10002 | 10001 | 10006 | 10005 | 10005 | 10001 | 10001 | 10005 | 10002 | 10006 | 10005 | 10001 | 10005 | 10005 | 10005 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10006 | 10006 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10002 | 10001 | 10006 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10006 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10002 | 10006 | 10001 | 10005 | 10002 | 10001 | 10001 | 10005 | 10005 | 10002 | 10001 | 10001 | 10006 | 10006 | 10001 | 10001 | 10002 | 10001 | 10001 | 10005 | 10001 | 10005 | 10006 | 10001 | 10005 | 10002 | 10001 | 10002 | 10002 | 10005 | 10001 | 10001 | 10001 | 10006 | 10006 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10006 | 10002 | 10002 | 10006 | 10005 | 10006 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10002 | 10001 | 10001 | 10001 | 10005 | 10001 | 10002 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10006 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10006 | 10001 | 10002 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2003 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2001 | 2005 | 2005 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2001 | 2011 | 2013 | 2013 | 2013 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2011 | 2011 | 2009 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2013 | 2013 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2019 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | * | JLEHMAN | TWALLS | GKURIMOT | GKURIMOT | GPEREZ | GPEREZ | GPEREZ | GPEREZ | CFLAGG | * | LTHIBAUL | MHOANG | DBARRICK | TTHAM | DBARRICK | COMPLETED | COMPLETED | GGILMORE | GGILMORE | GGILMORE | GGILMORE | GGILMORE | MHOANG | GGILMORE | GGILMORE | COMPLETED | KVANG | EMCENTEE | COMPLETED | COMPLETED | KVOONG1 | COMPLETED | COMPLETED | SARRIAGA | SARRIAGA | * | KVANG | * | * | * | NLANDERS | GPEREZ | KVANG | GKURIMOT | * | LHOANG | * | EMCENTEE | CFLAGG | * | GPEREZ | RSAGARIO | RSAGARIO | RSAGARIO | RSAGARIO | RSAGARIO | * | * | RSAGARIO | EMCENTEE | MPACHECO | CAFILER | JINGRAM | CAFILER | DHORRELL | * | SARRIAGA | * | * | LHOANG | SARRIAGA | RGEREMIA | * | SARRIAGA | RGEREMIA | * | * | RGEREMIA | JVAZQUEZ | * | JVAZQUEZ | DHORRELL | DHORRELL | * | * | CPON | MMORENO | MMORENO | MMORENO | MMORENO | DHORRELL | MMORENO | MMORENO | * | * | DHORRELL | RGEREMIA | RGEREMIA | DHORRELL | PBANFORD | * | PBANFORD | MMORENO | MMORENO | MMORENO | MMORENO | MPACHECO | CPON | CPON | MMORENO | SMCCONNAN | * | * | SMCCONNAN | CREYNOLDS | CREYNOLDS | CREYNOLDS | MPACHECO | MPACHECO | CREYNOLDS | CREYNOLDS | CREYNOLDS | CREYNOLDS | CREYNOLDS | * | * | * | TRAMON | TRAMON | TRAMON | TRAMON | MPACHECO | TRAMON | TRAMON | WBROWN | CAFILER | CAFILER | KBANH | KBANH | MPACHECO | RGEREMIA | RGEREMIA | KBANH | KBANH | KBANH | SJENSEN | RGEREMIA | CAFILER | SJENSEN | CAFILER | CAFILER | PDEO | PDEO | PDEO | JFRONEFIELD | LPHEAV | CAFILER | CAFILER | CAFILER | CAFILER | CAFILER | CAFILER | IMEDINA | RGEREMIA | CAFILER | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 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 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 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 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1999-01-01 00:00:00 | None | None | 1999-06-03 00:00:00 | 1999-07-01 00:00:00 | 2000-01-01 00:00:00 | 2000-07-01 00:00:00 | 2001-06-07 00:00:00 | 2001-06-07 00:00:00 | 2001-01-01 00:00:00 | 2001-04-11 00:00:00 | 2001-01-01 00:00:00 | 2001-04-12 00:00:00 | 2001-05-08 00:00:00 | 2001-05-08 00:00:00 | 2001-05-08 00:00:00 | 2001-07-01 00:00:00 | 2002-01-01 00:00:00 | None | 2002-10-01 00:00:00 | 2002-10-01 00:00:00 | 2003-01-01 00:00:00 | 2002-07-01 00:00:00 | 2001-07-01 00:00:00 | 2002-01-01 00:00:00 | 2002-10-01 00:00:00 | 2001-05-08 00:00:00 | 2001-04-12 00:00:00 | 2001-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-07-01 00:00:00 | 2003-07-01 00:00:00 | 2004-01-01 00:00:00 | 2004-01-01 00:00:00 | 2004-07-01 00:00:00 | 2004-07-01 00:00:00 | 2005-03-01 00:00:00 | 2005-03-01 00:00:00 | 2005-01-01 00:00:00 | 2005-07-01 00:00:00 | 2005-01-01 00:00:00 | 2005-01-01 00:00:00 | 2005-07-01 00:00:00 | 2005-01-01 00:00:00 | 2006-01-01 00:00:00 | 2006-01-01 00:00:00 | 2006-07-01 00:00:00 | 2006-01-01 00:00:00 | 2006-10-24 00:00:00 | 2006-07-01 00:00:00 | None | 2006-01-01 00:00:00 | None | 2006-10-01 00:00:00 | 2006-10-01 00:00:00 | 2007-01-01 00:00:00 | None | None | None | None | 2007-05-04 00:00:00 | 2007-07-01 00:00:00 | 2007-01-01 00:00:00 | 2007-05-08 00:00:00 | None | 2012-01-01 00:00:00 | 2014-10-19 00:00:00 | 2014-07-01 00:00:00 | 2014-07-01 00:00:00 | 2008-03-14 00:00:00 | 2008-01-01 00:00:00 | 2008-01-01 00:00:00 | 2008-01-01 00:00:00 | 2008-03-18 00:00:00 | 2008-01-01 00:00:00 | 2007-07-01 00:00:00 | 2008-05-18 00:00:00 | 2008-05-18 00:00:00 | 2008-03-18 00:00:00 | 2008-07-01 00:00:00 | 2008-07-01 00:00:00 | 2009-01-12 00:00:00 | None | 2008-10-19 00:00:00 | 2009-01-01 00:00:00 | None | 2009-01-29 00:00:00 | 2009-01-29 00:00:00 | 2008-10-01 00:00:00 | 2009-04-16 00:00:00 | None | 2009-02-15 00:00:00 | 2009-02-15 00:00:00 | 2009-02-15 00:00:00 | 2009-05-03 00:00:00 | 2009-12-28 00:00:00 | 2009-05-03 00:00:00 | 2009-02-15 00:00:00 | 2009-05-03 00:00:00 | 2009-07-01 00:00:00 | 2010-02-09 00:00:00 | None | None | 2010-04-22 00:00:00 | 2010-05-12 00:00:00 | 2010-05-10 00:00:00 | 2010-05-11 00:00:00 | 2010-03-18 00:00:00 | 2010-03-18 00:00:00 | 2010-05-23 00:00:00 | 2010-05-23 00:00:00 | 2010-03-18 00:00:00 | 2010-07-01 00:00:00 | 2010-07-01 00:00:00 | 2010-03-18 00:00:00 | 2010-10-01 00:00:00 | 2010-03-18 00:00:00 | 2010-05-23 00:00:00 | 2010-10-01 00:00:00 | 2011-03-04 00:00:00 | 2011-03-04 00:00:00 | 2011-03-05 00:00:00 | 2010-03-18 00:00:00 | 2010-05-23 00:00:00 | 2011-02-25 00:00:00 | 2011-03-01 00:00:00 | 2011-03-01 00:00:00 | 2011-03-01 00:00:00 | 2011-03-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | None | 2011-07-11 00:00:00 | 2011-04-28 00:00:00 | None | 2012-01-01 00:00:00 | None | None | 2013-04-16 00:00:00 | 2015-07-01 00:00:00 | 2016-01-01 00:00:00 | 2016-05-12 00:00:00 | 2016-04-22 00:00:00 | 2015-07-01 00:00:00 | 2016-06-06 00:00:00 | 2016-05-31 00:00:00 | 2016-05-31 00:00:00 | 2016-05-31 00:00:00 | 2016-06-02 00:00:00 | 2016-01-01 00:00:00 | 2016-06-06 00:00:00 | 2016-01-01 00:00:00 | 2016-04-24 00:00:00 | 2015-07-01 00:00:00 | 2016-05-22 00:00:00 | 2016-10-05 00:00:00 | 2016-11-03 00:00:00 | 2016-11-03 00:00:00 | None | None | 2022-06-03 00:00:00 | 2022-06-07 00:00:00 | 2022-08-19 00:00:00 | 2022-09-13 00:00:00 | 2022-09-23 00:00:00 | 2022-09-27 00:00:00 | None | 2022-05-25 00:00:00 | 2022-11-03 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1999-06-02 00:00:00 | None | None | 1999-06-30 00:00:00 | 1999-12-31 00:00:00 | 2000-06-30 00:00:00 | 2000-12-31 00:00:00 | 2001-06-07 00:00:00 | 2001-06-07 00:00:00 | 2001-04-11 00:00:00 | 2001-05-07 00:00:00 | 2001-04-11 00:00:00 | 2001-05-07 00:00:00 | 2001-06-30 00:00:00 | 2001-06-30 00:00:00 | 2001-06-30 00:00:00 | 2001-12-31 00:00:00 | 2002-06-30 00:00:00 | None | 2002-12-31 00:00:00 | 2002-12-31 00:00:00 | 2003-06-30 00:00:00 | 2002-09-30 00:00:00 | 2001-12-31 00:00:00 | 2002-06-30 00:00:00 | 2002-12-31 00:00:00 | 2001-06-30 00:00:00 | 2001-05-07 00:00:00 | 2001-04-11 00:00:00 | 2003-06-30 00:00:00 | 2003-12-31 00:00:00 | 2003-12-31 00:00:00 | 2004-06-30 00:00:00 | 2004-06-30 00:00:00 | 2004-12-31 00:00:00 | 2004-12-31 00:00:00 | 2005-03-01 00:00:00 | 2005-03-01 00:00:00 | 2005-06-30 00:00:00 | 2005-12-31 00:00:00 | 2005-06-30 00:00:00 | 2005-06-30 00:00:00 | 2005-12-31 00:00:00 | 2005-06-30 00:00:00 | 2006-06-30 00:00:00 | 2006-06-30 00:00:00 | 2006-09-30 00:00:00 | 2006-06-30 00:00:00 | 2006-10-24 00:00:00 | 2006-09-30 00:00:00 | None | 2006-06-30 00:00:00 | None | 2006-12-31 00:00:00 | 2006-12-31 00:00:00 | 2007-06-30 00:00:00 | None | None | None | None | 2007-05-04 00:00:00 | 2007-12-31 00:00:00 | 2007-06-30 00:00:00 | 2007-05-08 00:00:00 | None | 2012-06-30 00:00:00 | 2014-12-31 00:00:00 | 2014-09-30 00:00:00 | 2014-09-30 00:00:00 | 2008-03-14 00:00:00 | 2008-03-17 00:00:00 | 2008-03-17 00:00:00 | 2008-03-17 00:00:00 | 2008-05-17 00:00:00 | 2008-03-17 00:00:00 | 2007-12-31 00:00:00 | 2008-06-30 00:00:00 | 2008-06-30 00:00:00 | 2008-05-17 00:00:00 | 2008-09-30 00:00:00 | 2008-09-30 00:00:00 | 2009-01-12 00:00:00 | None | 2008-12-31 00:00:00 | 2009-02-14 00:00:00 | None | 2009-01-29 00:00:00 | 2009-01-29 00:00:00 | 2008-12-31 00:00:00 | 2009-04-16 00:00:00 | None | 2009-05-02 00:00:00 | 2009-05-02 00:00:00 | 2009-05-02 00:00:00 | 2009-06-30 00:00:00 | 2009-12-28 00:00:00 | 2009-06-30 00:00:00 | 2009-05-02 00:00:00 | 2009-06-30 00:00:00 | 2009-12-31 00:00:00 | 2010-02-09 00:00:00 | None | None | 2010-04-22 00:00:00 | 2010-05-12 00:00:00 | 2010-05-10 00:00:00 | 2010-05-11 00:00:00 | 2010-05-22 00:00:00 | 2010-05-22 00:00:00 | 2010-06-30 00:00:00 | 2010-06-30 00:00:00 | 2010-05-22 00:00:00 | 2010-09-30 00:00:00 | 2010-09-30 00:00:00 | 2010-05-22 00:00:00 | 2010-12-31 00:00:00 | 2010-05-22 00:00:00 | 2010-06-30 00:00:00 | 2010-12-31 00:00:00 | 2011-03-04 00:00:00 | 2011-03-04 00:00:00 | 2011-03-05 00:00:00 | 2010-05-22 00:00:00 | 2010-06-30 00:00:00 | 2011-02-25 00:00:00 | 2011-03-01 00:00:00 | 2011-03-01 00:00:00 | 2011-03-01 00:00:00 | 2011-03-01 00:00:00 | 2011-03-02 00:00:00 | 2011-03-02 00:00:00 | 2011-03-02 00:00:00 | None | 2011-07-11 00:00:00 | 2011-04-28 00:00:00 | None | 2012-06-30 00:00:00 | None | None | 2013-04-16 00:00:00 | 2015-12-31 00:00:00 | 2016-04-23 00:00:00 | 2016-05-12 00:00:00 | 2016-04-22 00:00:00 | 2015-12-31 00:00:00 | 2016-06-06 00:00:00 | 2016-05-31 00:00:00 | 2016-05-31 00:00:00 | 2016-05-31 00:00:00 | 2016-06-02 00:00:00 | 2016-04-23 00:00:00 | 2016-06-06 00:00:00 | 2016-04-23 00:00:00 | 2016-05-21 00:00:00 | 2015-12-31 00:00:00 | 2016-06-30 00:00:00 | 2016-10-05 00:00:00 | 2016-11-03 00:00:00 | 2016-11-03 00:00:00 | None | None | 2022-06-03 00:00:00 | 2022-06-07 00:00:00 | 2022-08-19 00:00:00 | 2022-09-13 00:00:00 | 2022-09-23 00:00:00 | 2022-09-27 00:00:00 | None | 2022-05-25 00:00:00 | 2022-11-03 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 2001-07-31 00:00:00 | None | None | None | None | None | 2003-01-31 00:00:00 | 2003-07-28 00:00:00 | None | None | None | None | None | None | None | None | 2004-01-07 00:00:00 | None | None | 2004-07-20 00:00:00 | 2005-01-12 00:00:00 | None | 2005-03-01 00:00:00 | 2005-03-01 00:00:00 | None | None | 2005-07-25 00:00:00 | None | 2006-01-18 00:00:00 | 2005-09-28 00:00:00 | 2006-07-25 00:00:00 | None | None | None | 2006-10-24 00:00:00 | 2006-08-01 00:00:00 | None | 2006-08-01 00:00:00 | None | None | 2006-10-24 00:00:00 | None | None | None | None | None | 2007-05-04 00:00:00 | 2008-01-22 00:00:00 | 2007-05-08 00:00:00 | 2007-05-08 00:00:00 | None | None | 2015-01-19 00:00:00 | None | 2014-10-06 00:00:00 | 2008-03-14 00:00:00 | 2008-03-14 00:00:00 | None | 2008-03-14 00:00:00 | 2008-03-14 00:00:00 | None | None | None | 2008-03-14 00:00:00 | None | None | 2008-03-14 00:00:00 | None | None | None | 2009-01-29 00:00:00 | None | 2009-01-29 00:00:00 | 2009-01-29 00:00:00 | 2009-01-29 00:00:00 | None | None | 2009-05-07 00:00:00 | None | 2009-05-07 00:00:00 | 2009-05-07 00:00:00 | 2009-12-28 00:00:00 | None | None | 2010-01-21 00:00:00 | 2009-12-28 00:00:00 | 2010-02-09 00:00:00 | None | None | 2010-04-22 00:00:00 | 2010-05-12 00:00:00 | None | 2010-05-11 00:00:00 | 2010-05-26 00:00:00 | None | 2010-05-26 00:00:00 | None | None | 2010-07-28 00:00:00 | None | 2010-05-26 00:00:00 | 2010-07-28 00:00:00 | 2010-07-28 00:00:00 | 2010-07-28 00:00:00 | None | 2011-03-04 00:00:00 | 2011-03-04 00:00:00 | 2011-03-05 00:00:00 | None | None | 2011-02-25 00:00:00 | 2011-03-01 00:00:00 | 2011-03-01 00:00:00 | 2011-03-01 00:00:00 | 2011-03-01 00:00:00 | 2011-03-01 00:00:00 | 2011-03-01 00:00:00 | 2011-03-01 00:00:00 | None | None | None | None | None | None | None | 2013-04-16 00:00:00 | 2016-02-01 00:00:00 | 2016-04-28 00:00:00 | 2016-05-12 00:00:00 | 2016-04-22 00:00:00 | None | 2016-06-06 00:00:00 | 2016-05-31 00:00:00 | 2016-05-31 00:00:00 | 2016-05-31 00:00:00 | 2016-06-02 00:00:00 | None | 2016-06-06 00:00:00 | 2016-05-26 00:00:00 | 2016-05-26 00:00:00 | 2016-05-26 00:00:00 | 2016-07-29 00:00:00 | 2016-10-05 00:00:00 | 2016-11-03 00:00:00 | 2016-11-03 00:00:00 | None | None | 2022-06-03 00:00:00 | 2022-06-07 00:00:00 | 2022-08-19 00:00:00 | 2022-09-13 00:00:00 | 2022-09-23 00:00:00 | 2022-09-27 00:00:00 | None | 2022-05-25 00:00:00 | 2022-11-03 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_type | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 22001 | 22001 | None | None | None | None | None | None | None | None | 22001 | None | None | 22001 | 22001 | None | 22001 | 22001 | None | None | 22001 | None | 22001 | 22001 | 22001 | None | None | None | 22001 | 22001 | None | 22001 | None | None | 22001 | None | None | None | None | None | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | None | None | 22001 | None | None | 22001 | 22001 | None | None | 22001 | None | 22001 | 22001 | 22001 | 22006 | None | 22001 | None | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22006 | 22001 | 22001 | None | 22001 | None | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22006 | 22006 | None | None | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 |
filer_id | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 16 | 16 | 16 | 16 | 16 | 16 | ||||||
active | Y | Y | Y | Y | Y | Y | ||||||
race | 0 | 0 | 0 | 0 | 0 | 0 | ||||||
session_id | 1999 | 2005 | 2009 | 2011 | 2009 | 2013 | ||||||
category | 0 | 0 | 0 | 0 | 0 | 0 | ||||||
category_type | 40502 | 40502 | 40503 | 40505 | 40502 | 40503 | ||||||
sub_category | 40103 | 40103 | 40103 | 40103 | 40103 | 40103 | ||||||
effect_dt | 1999-06-10 00:00:00 | 2006-08-03 00:00:00 | 2009-11-10 00:00:00 | 2011-04-12 00:00:00 | 2010-04-23 00:00:00 | 2014-07-10 00:00:00 | ||||||
sub_category_type | 0 | 0 | 0 | 0 | 0 | 0 | ||||||
election_type | 0 | 0 | 0 | 0 | 0 | 0 | ||||||
sub_category_a | None | S | S | S | S | S | ||||||
nyq_dt | 1999-05-19 00:00:00 | 1999-05-19 00:00:00 | 1999-05-19 00:00:00 | 1999-05-19 00:00:00 | 1999-05-19 00:00:00 | 1999-05-19 00:00:00 | ||||||
party_cd | None | None | None | None | None | None | ||||||
county_cd | 18026 | 18026 | 18026 | 18026 | 18026 | 18026 | ||||||
district_cd | None | None | None | None | None | None |
filer_id | 1076264 | |
---|---|---|
xref_id | 990680 | |
effect_dt | 1999-12-07 00:00:00 | |
migration_source | IDENTFIX |
xref_filer_id | 990680 | 990680 | 990680 | 990680 | 990680 | 990680 | 990680 | 990680 | 990680 | 990680 | 990680 | 990680 | 990680 | 990680 | 990680 | 990680 | 990680 | 990680 | 990680 | 990680 | 990680 | 990680 | 990680 | 990680 | 990680 | 990680 | 990680 | 990680 | 990680 | 990680 | 990680 | 990680 | ||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | ||||||||||||||||||||||||||||||||
filer_type | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | RECIPIENT COMMITTEE | ||||||||||||||||||||||||||||||||
status | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ||||||||||||||||||||||||||||||||
effect_dt | 2014-07-10 00:00:00 | 2014-07-10 00:00:00 | 2014-07-10 00:00:00 | 2014-07-10 00:00:00 | 2014-07-10 00:00:00 | 2014-07-10 00:00:00 | 2014-07-10 00:00:00 | 2014-07-10 00:00:00 | 2014-07-10 00:00:00 | 2014-07-10 00:00:00 | 2014-07-10 00:00:00 | 2014-07-10 00:00:00 | 2014-07-10 00:00:00 | 2014-07-10 00:00:00 | 2014-07-10 00:00:00 | 2014-07-10 00:00:00 | 2014-07-10 00:00:00 | 2014-07-10 00:00:00 | 2014-07-10 00:00:00 | 2014-07-10 00:00:00 | 2014-07-10 00:00:00 | 2014-07-10 00:00:00 | 2014-07-10 00:00:00 | 2014-07-10 00:00:00 | 2014-07-10 00:00:00 | 2014-07-10 00:00:00 | 2014-07-10 00:00:00 | 2014-07-10 00:00:00 | 2014-07-10 00:00:00 | 2014-07-10 00:00:00 | 2014-07-10 00:00:00 | 2014-07-10 00:00:00 | ||||||||||||||||||||||||||||||||
naml | LA JOBS PAC: SPONSORED BY LOS ANGELES AREA CHAMBER OF COMMERCE | LA JOBS PAC: SPONSORED BY LOS ANGELES AREA CHAMBER OF COMMERCE | LA JOBS PAC: SPONSORED BY LOS ANGELES AREA CHAMBER OF COMMERCE | LA JOBS PAC: SPONSORED BY LOS ANGELES AREA CHAMBER OF COMMERCE | LA JOBS PAC: SPONSORED BY LOS ANGELES AREA CHAMBER OF COMMERCE | LA JOBS PAC: SPONSORED BY LOS ANGELES AREA CHAMBER OF COMMERCE | LA JOBS PAC: SPONSORED BY LOS ANGELES AREA CHAMBER OF COMMERCE | LA JOBS PAC: SPONSORED BY LOS ANGELES AREA CHAMBER OF COMMERCE | LOS ANGELES BUSINESS PAC: SPONSORED BY LOS ANGELES AREA CHAMBER OF COMMERCE | LOS ANGELES BUSINESS PAC: SPONSORED BY LOS ANGELES AREA CHAMBER OF COMMERCE | LOS ANGELES BUSINESS PAC: SPONSORED BY LOS ANGELES AREA CHAMBER OF COMMERCE | LOS ANGELES BUSINESS PAC: SPONSORED BY LOS ANGELES AREA CHAMBER OF COMMERCE | LOS ANGELES BUSINESS PAC: SPONSORED BY LOS ANGELES AREA CHAMBER OF COMMERCE | LOS ANGELES BUSINESS PAC: SPONSORED BY LOS ANGELES AREA CHAMBER OF COMMERCE | LOS ANGELES BUSINESS PAC: SPONSORED BY LOS ANGELES AREA CHAMBER OF COMMERCE | LOS ANGELES BUSINESS PAC: SPONSORED BY LOS ANGELES AREA CHAMBER OF COMMERCE | LOS ANGELES BUSINESS PAC | LOS ANGELES BUSINESS PAC | LOS ANGELES BUSINESS PAC | LOS ANGELES BUSINESS PAC | LOS ANGELES BUSINESS PAC | LOS ANGELES BUSINESS PAC | LOS ANGELES BUSINESS PAC | LOS ANGELES BUSINESS PAC | LOS ANGELES AREA CHAMBER OF COMMERCE PAC | LOS ANGELES AREA CHAMBER OF COMMERCE PAC | LOS ANGELES AREA CHAMBER OF COMMERCE PAC | LOS ANGELES AREA CHAMBER OF COMMERCE PAC | LOS ANGELES AREA CHAMBER OF COMMERCE PAC | LOS ANGELES AREA CHAMBER OF COMMERCE PAC | LOS ANGELES AREA CHAMBER OF COMMERCE PAC | LOS ANGELES AREA CHAMBER OF COMMERCE PAC | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
city | BURBANK | LOS ANGELES | BURBANK | LOS ANGELES | None | LOS ANGELES | LOS ANGELES | LOS ANGELES | BURBANK | LOS ANGELES | BURBANK | LOS ANGELES | None | LOS ANGELES | LOS ANGELES | LOS ANGELES | BURBANK | LOS ANGELES | BURBANK | LOS ANGELES | None | LOS ANGELES | LOS ANGELES | LOS ANGELES | BURBANK | LOS ANGELES | BURBANK | LOS ANGELES | None | LOS ANGELES | LOS ANGELES | LOS ANGELES | ||||||||||||||||||||||||||||||||
st | CA | CA | CA | CA | None | CA | CA | CA | CA | CA | CA | CA | None | CA | CA | CA | CA | CA | CA | CA | None | CA | CA | CA | CA | CA | CA | CA | None | CA | CA | CA | ||||||||||||||||||||||||||||||||
zip4 | 915040000 | 900170000 | 91502 | 90017 | None | 90017 | 90017 | 90017 | 915040000 | 900170000 | 91502 | 90017 | None | 90017 | 90017 | 90017 | 915040000 | 900170000 | 91502 | 90017 | None | 90017 | 90017 | 90017 | 915040000 | 900170000 | 91502 | 90017 | None | 90017 | 90017 | 90017 | ||||||||||||||||||||||||||||||||
phon | 8185040323 | 8185040323 | 8182600669 | 2135807521 | 2135807521 | 2135807521 | 2135807521 | 8185040323 | 8185040323 | 8182600669 | 2135807521 | 2135807521 | 2135807521 | 2135807521 | 8185040323 | 8185040323 | 8182600669 | 2135807521 | 2135807521 | 2135807521 | 2135807521 | 8185040323 | 8185040323 | 8182600669 | 2135807521 | 2135807521 | 2135807521 | 2135807521 | ||||||||||||||||||||||||||||||||||||
fax | None | None | None | 2135807586 | 2135807586 | 2134526575 | 2134526575 | None | None | None | 2135807586 | 2135807586 | 2134526575 | 2134526575 | None | None | None | 2135807586 | 2135807586 | 2134526575 | 2134526575 | None | None | None | 2135807586 | 2135807586 | 2134526575 | 2134526575 | ||||||||||||||||||||||||||||||||||||
None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | [email protected] | [email protected] | None |
filer_id | 1076264 |
---|
filer_id | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | 1076264 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 773517_0.cal | 913218_0.cal | 261430.cal | 947056_0.cal | 979306_0.cal | 1095661_1.cal | 1210901_0.cal | 96780.cal | 524217.cal | 97235.cal | 347593.cal | 1417029_0.cal | 501579.cal | 1417031_0.cal | 1487251_0.cal | 312940.cal | 313182.cal | 313592.cal | 314260.cal | 314459.cal | 314413.cal | 334596.cal | 1487430_0.cal | 312778.cal | 1456210_0.cal | 489261.cal | 390825.cal | 390947.cal | 1481604_0.cal | 389172.cal | 389668.cal | 1264052_0.cal | 1264630_0.cal | 75501.cal | 75556.cal | 491593.cal | 1581244_0.cal | 237649.cal | 237841.cal | 238136.cal | 238471.cal | 1579338_0.cal | 1580215_0.cal | 423393.cal | 1580216_0.cal | 1580217_0.cal | 1579338_1.cal | 1581197_0.cal | 466545.cal | 1581200_0.cal | 2049116_0.cal | 2085597_0.cal | 412218.cal | 411326.cal | 2031468_0.cal | 277836.cal | 278144.cal | 278152.cal | 2723322_0.cal | 2690902_0.cal | 2692298_0.cal | 2686074_0.cal | 2724532_0.cal | 2712954_0.cal | 2719737_0.cal | 2686074_1.cal | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
received_date | 2001-07-31 00:00:00 | 2003-01-31 00:00:00 | 2003-07-30 00:00:00 | 2003-07-30 00:00:00 | 2004-01-09 00:00:00 | 2005-03-09 00:00:00 | 2006-10-24 00:00:00 | 2006-10-04 00:00:00 | 2008-05-21 00:00:00 | 2010-08-26 00:00:00 | 2009-07-29 00:00:00 | 2009-04-10 00:00:00 | 2009-04-10 00:00:00 | 2009-04-10 00:00:00 | 2010-05-11 00:00:00 | 2010-05-11 00:00:00 | 2010-05-11 00:00:00 | 2010-05-11 00:00:00 | 2010-05-11 00:00:00 | 2010-05-11 00:00:00 | 2010-05-11 00:00:00 | 2010-05-12 00:00:00 | 2010-05-12 00:00:00 | 2010-05-11 00:00:00 | 2009-12-28 00:00:00 | 2007-01-29 00:00:00 | 2010-02-01 00:00:00 | 2010-02-01 00:00:00 | 2010-04-22 00:00:00 | 2010-02-01 00:00:00 | 2010-02-01 00:00:00 | 2007-05-04 00:00:00 | 2007-05-08 00:00:00 | 2008-03-14 00:00:00 | 2008-03-14 00:00:00 | 2011-03-06 00:00:00 | 2011-03-06 00:00:00 | 2011-01-31 00:00:00 | 2011-01-31 00:00:00 | 2011-01-31 00:00:00 | 2011-01-31 00:00:00 | 2011-02-25 00:00:00 | 2011-03-01 00:00:00 | 2011-03-01 00:00:00 | 2011-03-01 00:00:00 | 2011-03-01 00:00:00 | 2011-03-01 00:00:00 | 2011-03-04 00:00:00 | 2011-03-04 00:00:00 | 2011-03-04 00:00:00 | 2016-06-02 00:00:00 | 2016-10-05 00:00:00 | 2014-10-06 00:00:00 | 2014-10-06 00:00:00 | 2016-04-22 00:00:00 | 2015-02-02 00:00:00 | 2015-02-02 00:00:00 | 2015-02-02 00:00:00 | 2022-09-24 00:00:00 | 2022-06-03 00:00:00 | 2022-06-07 00:00:00 | 2022-05-25 00:00:00 | 2022-09-27 00:00:00 | 2022-08-19 00:00:00 | 2022-09-13 00:00:00 | 2022-11-03 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_directory | /usr/users/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/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /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/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /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/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /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/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/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_id | 773517 | 913218 | None | 947056 | 979306 | 1095661 | 1210901 | None | None | None | None | 1417029 | None | 1417031 | 1487251 | None | None | None | None | None | None | None | 1487430 | None | 1456210 | None | None | None | 1481604 | None | None | 1264052 | 1264630 | None | None | None | 1581244 | None | None | None | None | 1579338 | 1580215 | None | 1580216 | 1580217 | 1579338 | 1581197 | None | 1581200 | 2049116 | 2085597 | None | None | 2031468 | None | None | None | 2723322 | 2690902 | 2692298 | 2686074 | 2724532 | 2712954 | 2719737 | 2686074 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F460 | F460 | None | F460 | F460 | F497 | F497 | None | None | None | None | F497 | None | F497 | F497 | None | None | None | None | None | None | None | F497 | None | F497 | None | None | None | F497 | None | None | F497 | F497 | None | None | None | F496 | None | None | None | None | F496 | F496 | None | F496 | F496 | F496 | F496 | None | F496 | F497 | F497 | None | None | F497 | None | None | None | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
receive_comment | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing did not pass validation | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted | Filing accepted | Filing did not pass validation | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing 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 did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing accepted | Filing did not pass validation | Filing accepted | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing accepted | Filing did not pass validation | Filing did not pass validation | Filing accepted | Filing accepted | Filing did not pass validation | Filing did not pass validation | Filing passed validation, but failed DB constraints | Filing accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing did not pass validation | Filing did not pass validation | Filing accepted | Filing did not pass validation | Filing passed validation, but failed DB constraints | Filing did not pass validation | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted |