Home

Filer ID: 1013172

Table: filer_address
filer_id   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172
adrid   1012727   2038551   2158164   2177233   2169954   2224292   2405381   2395953   2282361   2296121   2303356   2322786   2534998
effect_dt   1995-01-25 00:00:00   2002-10-17 00:00:00   2009-01-08 00:00:00   2010-01-19 00:00:00   2009-07-02 00:00:00   2012-01-03 00:00:00   2016-08-01 00:00:00   2016-05-10 00:00:00   2013-01-29 00:00:00   2013-07-25 00:00:00   2014-01-28 00:00:00   2014-07-25 00:00:00   2022-04-14 00:00:00
add_type   7051   7051   7051   7051   7051   7051   7051   7051   7051   7051   7051   7051   7051
session_id   1995   2001   2009   2009   2009   2011   2015   2015   2013   2013   2013   2013   2021
Table: filer_filings
filer_id   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172
filing_id   75447   75448   75449   75450   722399   718800   784401   829254   859498   855522   910641   924394   954857   962232   959384   994418   1113147   1137430   1152618   1210585   1220807   1227869   1212311   1213306   1220414   1249011   1271909   1278589   1277200   1270295   1267370   1270956   1267190   1303454   1303454   1294693   1301423   1301426   1301497   1301499   1779842   1866414   1788591   1953672   1303576   1298356   1343068   1343027   1380817   1389829   1390686   1376925   1374354   1404090   1404076   1377127   1404090   1375289   1404464   1404658   1404659   1404716   1403226   1379965   1428861   1423803   1428861   1431135   1431135   1423185   1458422   1460422   1458422   1470647   1470647   1511495   1506499   1537905   1546270   1572016   1578064   1604775   1610158   1617459   1617462   1617463   1617464   1628414   1628957   1628957   1628414   1825497   1825497   1814307   1866414   1713251   1734731   1814307   1746133   2478692   2516324   2272248   2322381   2521078   2287473   2369457   2562467   2406262   2252793   2396430   2324507   2062039   2073998   2128985   2129055   2125562   2147474   2320145   2531179   2309109   2345949   2289304   2518122   2253668   2335954   2458352   2504087   2548453   2311069   2286535   2483021   2440705   2690554   2700999   2562467   2700369   2570968   2548453   2639658   2666157   2728852   2748209   2743049
period_id   140   141   143   153   None   161   None   None   None   169   171   None   None   None   None   None   None   None   None   188   188   187   188   188   188   None   None   None   189   None   None   None   None   191   191   None   None   None   None   None   213   217   None   None   None   None   193   None   None   195   None   196   196   197   None   None   197   196   197   None   None   None   197   None   197   None   197   None   None   198   199   None   199   None   None   None   201   204   None   203   None   205   None   None   None   None   None   207   None   None   207   None   None   215   217   212   209   215   None   243   244   233   236   244   None   None   None   None   234   237   236   225   None   227   229   229   None   236   244   236   235   235   244   234   237   None   None   243   236   235   241   239   250   None   None   249   245   243   245   None   252   252   252
form_id   F497   F461   F461   F461   F461   F461   F461   F461   F461   F461   F461   F461   F461   F461   F497   F461   F461   F497   F461   F497   F497   F461   F497   F497   F497   F461   F497   F461   F461   F497   F497   F497   F497   F461   F461   F497   F497   F497   F497   F497   F461   F461   F461   F461   F461   F497   F461   F461   F497   F461   F461   F497   F497   F497   F497   F497   F497   F497   F497   F497   F497   F497   F497   F497   F461   F497   F461   F461   F461   F497   F461   F888   F461   F461   F461   F461   F461   F497   F497   F461   F461   F461   F461   F497   F497   F497   F497   F461   F461   F461   F461   F461   F461   F461   F461   F497   F461   F461   F461   F497   F497   F461   F497   F497   F461   F461   F461   F461   F497   F461   F497   F461   F461   F461   F497   F497   F461   F497   F497   F497   F461   F497   F497   F497   F497   F461   F461   F461   F497   F497   F461   F461   F497   F461   F461   F461   F497   F461   F461   F461   F497   F497   F497
filing_sequence   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   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   1   0   0   0   0   0   0   0   0   0   1   0   1   0   0   0   1   0   1   0   0   0   0   0   0   0   0   0   0   0   0   0   0   1   1   0   1   0   1   0   0   1   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   0   1   0   0   1   0   0   0   0   0
filing_date   1994-10-31 00:00:00   1995-07-31 00:00:00   1996-01-31 00:00:00   1999-02-01 00:00:00   2001-01-31 00:00:00   2001-01-31 00:00:00   2001-08-02 00:00:00   2002-01-31 00:00:00   2002-08-01 00:00:00   2002-07-31 00:00:00   2003-01-30 00:00:00   2003-01-31 00:00:00   2003-07-30 00:00:00   2003-10-06 00:00:00   2003-09-23 00:00:00   2004-02-02 00:00:00   2005-07-08 00:00:00   2005-10-28 00:00:00   2006-01-19 00:00:00   2006-10-24 00:00:00   2006-11-07 00:00:00   2007-01-12 00:00:00   2006-10-26 00:00:00   2006-10-27 00:00:00   2006-11-06 00:00:00   2007-01-16 00:00:00   2006-11-07 00:00:00   2007-07-13 00:00:00   2007-07-12 00:00:00   2006-10-26 00:00:00   2006-11-08 00:00:00   2006-11-06 00:00:00   2006-10-27 00:00:00   2008-01-14 00:00:00   2008-01-14 00:00:00   2006-10-25 00:00:00   2006-10-28 00:00:00   2006-11-27 00:00:00   2006-10-27 00:00:00   2006-11-07 00:00:00   2013-07-29 00:00:00   2014-07-25 00:00:00   2013-07-29 00:00:00   2015-02-02 00:00:00   2008-01-14 00:00:00   2006-10-24 00:00:00   2008-07-14 00:00:00   2008-07-11 00:00:00   2008-10-30 00:00:00   2009-01-16 00:00:00   2009-01-20 00:00:00   2008-10-30 00:00:00   2008-10-28 00:00:00   2009-02-26 00:00:00   2009-02-20 00:00:00   2008-10-29 00:00:00   2009-02-26 00:00:00   2008-10-29 00:00:00   2009-03-02 00:00:00   2009-02-27 00:00:00   2009-02-27 00:00:00   2009-03-04 00:00:00   2009-02-19 00:00:00   2008-10-29 00:00:00   2009-07-06 00:00:00   2009-05-11 00:00:00   2009-07-28 00:00:00   2009-07-09 00:00:00   2009-07-30 00:00:00   2009-05-07 00:00:00   2010-01-19 00:00:00   2010-01-26 00:00:00   2010-02-15 00:00:00   2010-01-21 00:00:00   2010-02-17 00:00:00   2010-08-02 00:00:00   2010-07-30 00:00:00   2010-10-28 00:00:00   2010-10-28 00:00:00   2011-01-31 00:00:00   2011-01-31 00:00:00   2011-07-27 00:00:00   2011-07-28 00:00:00   2008-10-31 00:00:00   2008-10-24 00:00:00   2008-10-23 00:00:00   2008-10-22 00:00:00   2012-01-13 00:00:00   2012-01-17 00:00:00   2012-02-01 00:00:00   2012-01-30 00:00:00   2014-01-28 00:00:00   2014-03-03 00:00:00   2014-01-28 00:00:00   2015-01-27 00:00:00   2012-11-07 00:00:00   2013-01-29 00:00:00   2014-02-26 00:00:00   2013-01-30 00:00:00   2020-07-15 00:00:00   2020-10-15 00:00:00   2018-07-30 00:00:00   2018-11-02 00:00:00   2020-10-22 00:00:00   2018-07-31 00:00:00   2019-01-31 00:00:00   2021-01-27 00:00:00   2019-07-31 00:00:00   2018-05-23 00:00:00   2019-07-30 00:00:00   2018-11-06 00:00:00   2016-07-29 00:00:00   2016-08-01 00:00:00   2017-01-31 00:00:00   2017-01-31 00:00:00   2017-01-27 00:00:00   2017-01-31 00:00:00   2018-10-31 00:00:00   2020-11-02 00:00:00   2018-10-19 00:00:00   2019-01-30 00:00:00   2018-09-06 00:00:00   2020-10-19 00:00:00   2018-05-24 00:00:00   2019-01-18 00:00:00   2020-01-29 00:00:00   2020-07-29 00:00:00   2021-01-27 00:00:00   2018-10-23 00:00:00   2018-08-27 00:00:00   2020-07-29 00:00:00   2020-01-30 00:00:00   2022-06-03 00:00:00   2022-07-25 00:00:00   2021-04-09 00:00:00   2022-07-24 00:00:00   2021-03-31 00:00:00   2021-04-07 00:00:00   2022-01-27 00:00:00   2022-01-31 00:00:00   2022-10-05 00:00:00   2022-10-31 00:00:00   2022-10-27 00:00:00
stmnt_type   10001   10001   10001   10001   10005   10001   10005   10005   10005   10001   10001   10005   10005   10005   10005   10005   10005   10005   10005   10001   10001   10001   10001   10001   10001   10005   10005   10005   10001   10005   10005   10005   10005   10002   10001   10005   10005   10005   10005   10005   10001   10001   10005   10002   10005   10005   10001   10001   10005   10001   10005   10001   10001   10001   10005   10005   10002   10001   10001   10005   10002   10005   10001   10005   10001   10005   10002   10005   10006   10001   10001   10005   10002   10005   10006   10005   10001   10001   10005   10001   10005   10001   10005   10005   10005   10005   10005   10001   10005   10006   10002   10005   10006   10001   10002   10001   10001   10002   10005   10001   10001   10001   10001   10001   10005   10005   10005   10005   10001   10001   10001   10001   10005   10001   10001   10001   10005   10001   10001   10001   10001   10001   10001   10001   10001   10005   10005   10001   10001   10001   10001   10001   10001   10005   10006   10001   10001   10002   10001   10005   10001   10001   10001
stmnt_status   11001   11001   11001   11001   11003   11001   11001   11001   11001   11003   11003   11001   11003   11003   11001   11003   11003   11001   11003   11001   11001   11003   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11001   11001   11003   11003   11001   11001   11001   11003   11003   11003   11001   11003   11001   11001   11003   11001   11003   11001   11001   11003   11003   11001   11003   11001   11001   11001   11003   11001   11001   11001   11001   11003   11003   11003   11003   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11001   11001   11001   11003   11003   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11001   11001   11001   11003   11003   11003   11001   11003   11003   11001   11001   11001   11001   11001   11003   11003   11001   11001   11003   11001   11001   11001   11001   11001   11001   11001   11003   11003   11003
session_id   1993   1995   1995   1997   1999   1999   2001   2001   2001   2001   2001   2001   2003   2003   2003   2003   2005   2005   2005   2005   2005   2005   2005   2005   2005   2005   2005   2007   2007   2005   2005   2005   2005   2007   2007   2005   2005   2005   2005   2005   2013   2013   2013   2013   2007   2005   2007   2007   2007   2007   2009   2007   2007   2009   2009   2007   2009   2007   2009   2009   2009   2009   2009   2007   2009   2009   2009   2009   2009   2009   2009   2009   2009   2009   2009   2009   2009   2009   2009   2009   2009   2011   2011   2007   2007   2007   2007   2011   2011   2011   2011   2013   2013   2013   2013   2011   2011   2013   2011   2019   2019   2017   2017   2019   2017   2019   2021   2019   2017   2019   2017   2015   2015   2015   2017   2017   2015   2017   2019   2017   2017   2017   2019   2017   2019   2019   2019   2019   2017   2017   2019   2019   2021   2021   2021   2021   2021   2019   2021   2021   2021   2021   2021
user_id   *   *   *   *   DHORRELL   KVOONG1   DBARRICK   YBONILLA   LTHIBAUL   *   COMPLETED   LTHIBAUL   GGILMORE   DHORRELL   GPEREZ   DHORRELL   DHORRELL   DHORRELL   DHORRELL   DHORRELL   DHORRELL   *   DJOHNSON   DHORRELL   DJOHNSON   JMARTIN   RGEREMIA   JMARTIN   *   RGEREMIA   DHORRELL   RGEREMIA   RGEREMIA   SMCCABE   SMCCABE   RGEREMIA   DHORRELL   DHORRELL   DHORRELL   DHORRELL   JINGRAM   CREYNOLDS   JINGRAM   JINGRAM   SMCCABE   LHOANG   SMCCABE   SMCCABE   RGEREMIA   MGUERRA   MGUERRA   DHORRELL   PBANFORD   DHORRELL   JVAZQUEZ   EMCENTEE   DHORRELL   DMCCASTL   DHORRELL   JVAZQUEZ   JVAZQUEZ   JVAZQUEZ   DHORRELL   RGEREMIA   JINGRAM   GKURIMOT   *   JINGRAM   JINGRAM   GKURIMOT   JINGRAM   JINGRAM   *   JINGRAM   JINGRAM   JINGRAM   JINGRAM   PBANFORD   MPACHECO   JINGRAM   JINGRAM   JINGRAM   JINGRAM   JINGRAM   JINGRAM   JINGRAM   JINGRAM   JINGRAM   JINGRAM   JINGRAM   JINGRAM   JINGRAM   JINGRAM   JINGRAM   CREYNOLDS   CAFILER   RGEREMIA   JINGRAM   RGEREMIA   RGEREMIA   RGEREMIA   GTAYLOR   CAFILER   CAFILER   GTAYLOR   GTAYLOR   GTAYLOR   GTAYLOR   GTAYLOR   GTAYLOR   CAFILER   JINGRAM   JINGRAM   JINGRAM   RGEREMIA   RGEREMIA   JINGRAM   CAFILER   CAFILER   CAFILER   GTAYLOR   CAFILER   CAFILER   RGEREMIA   RGEREMIA   GTAYLOR   GTAYLOR   GTAYLOR   CAFILER   CAFILER   GTAYLOR   GTAYLOR   CAFILER   GTAYLOR   GTAYLOR   GTAYLOR   RGEREMIA   GTAYLOR   GTAYLOR   GTAYLOR   CAFILER   CAFILER   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   11001   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
fine_audit   11001   11001   11001   11001   11001   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11003   11001   11003   11001   11001   11003   11001   11001   11001   11001   11001   11003   11003   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11001   11001   11003   11001   11001   11001   11001   11003   11001   11001   11001   11001   11001   11003   11003   11001   11001   11001   11003   11003   11003   11001   11003   11001   11001   11003   11001   11003   11001   11001   11003   11003   11001   11003   11001   11001   11001   11003   11001   11001   11001   11001   11003   11003   11003   11003   11001   11001   11001   11001   11001   11001   11001   11001   11003   11001   11001   11001   11001   11003   11003   11003   11003   11003   11003   11001   11003   11003   11003   11003   11001   11001   11001   11001   11001   11001   11003   11003   11003   11003   11003   11003   11001   11001   11001   11001   11001   11003   11003   11001   11001   11003   11001   11001   11001   11001   11001   11001   11001   11003   11003   11003
rpt_start   None   1995-01-01 00:00:00   1995-07-01 00:00:00   1998-01-01 00:00:00   2000-01-01 00:00:00   2000-01-01 00:00:00   2000-01-01 00:00:00   2001-01-01 00:00:00   2002-01-01 00:00:00   2002-01-01 00:00:00   2002-07-01 00:00:00   2002-07-01 00:00:00   2003-01-01 00:00:00   2003-07-01 00:00:00   None   2003-10-10 00:00:00   2005-01-01 00:00:00   None   2005-07-01 00:00:00   2006-10-24 00:00:00   2006-11-07 00:00:00   2006-07-01 00:00:00   2006-10-26 00:00:00   2006-10-27 00:00:00   2006-11-06 00:00:00   2006-07-01 00:00:00   None   2007-01-01 00:00:00   2007-01-01 00:00:00   None   None   None   None   2007-07-01 00:00:00   2007-07-01 00:00:00   None   None   None   None   None   2013-01-01 00:00:00   2014-01-01 00:00:00   2013-01-01 00:00:00   2014-01-01 00:00:00   2007-07-01 00:00:00   None   2008-01-01 00:00:00   2008-01-01 00:00:00   None   2008-07-01 00:00:00   2008-07-01 00:00:00   2008-10-30 00:00:00   2008-10-28 00:00:00   2009-02-26 00:00:00   None   None   2009-02-26 00:00:00   2008-10-29 00:00:00   2009-03-02 00:00:00   None   None   None   2009-02-19 00:00:00   None   2009-01-01 00:00:00   None   2009-01-01 00:00:00   2009-01-01 00:00:00   2009-01-01 00:00:00   2009-05-07 00:00:00   2009-07-01 00:00:00   None   2009-07-01 00:00:00   2009-07-01 00:00:00   2009-07-01 00:00:00   2010-01-01 00:00:00   2010-01-01 00:00:00   2010-10-28 00:00:00   2010-10-28 00:00:00   2010-07-01 00:00:00   2010-07-01 00:00:00   2011-01-01 00:00:00   2011-01-01 00:00:00   None   None   None   None   2011-07-01 00:00:00   2011-07-01 00:00:00   2011-07-01 00:00:00   2011-07-01 00:00:00   2013-07-01 00:00:00   2013-07-01 00:00:00   2013-07-01 00:00:00   2014-01-01 00:00:00   2012-11-07 00:00:00   2012-01-01 00:00:00   2013-07-01 00:00:00   2012-01-01 00:00:00   2020-07-15 00:00:00   2020-10-15 00:00:00   2018-01-01 00:00:00   2018-11-02 00:00:00   2020-10-22 00:00:00   2018-01-01 00:00:00   2018-07-01 00:00:00   2020-07-01 00:00:00   2019-01-01 00:00:00   2018-05-23 00:00:00   2019-01-01 00:00:00   2018-11-06 00:00:00   2016-01-01 00:00:00   2016-01-01 00:00:00   2016-07-01 00:00:00   2017-01-31 00:00:00   2017-01-27 00:00:00   2016-07-01 00:00:00   2018-10-31 00:00:00   2020-11-02 00:00:00   2018-10-19 00:00:00   2018-07-01 00:00:00   2018-09-06 00:00:00   2020-10-19 00:00:00   2018-05-24 00:00:00   2019-01-18 00:00:00   2019-07-01 00:00:00   2020-01-01 00:00:00   2020-07-01 00:00:00   2018-10-23 00:00:00   2018-08-27 00:00:00   2020-01-01 00:00:00   2019-07-01 00:00:00   2022-06-03 00:00:00   2022-01-01 00:00:00   2020-07-01 00:00:00   2022-01-01 00:00:00   2021-03-31 00:00:00   2020-07-01 00:00:00   2021-01-01 00:00:00   2021-01-01 00:00:00   2022-10-05 00:00:00   2022-10-31 00:00:00   2022-10-27 00:00:00
rpt_end   None   1995-06-30 00:00:00   1995-12-31 00:00:00   1998-12-31 00:00:00   2000-12-31 00:00:00   2000-12-31 00:00:00   2000-06-30 00:00:00   2001-12-31 00:00:00   2002-06-30 00:00:00   2002-06-30 00:00:00   2002-12-31 00:00:00   2002-12-31 00:00:00   2003-06-30 00:00:00   2003-10-10 00:00:00   None   2003-12-31 00:00:00   2005-06-30 00:00:00   None   2005-12-31 00:00:00   2006-10-24 00:00:00   2006-11-07 00:00:00   2006-12-31 00:00:00   2006-10-26 00:00:00   2006-10-27 00:00:00   2006-11-06 00:00:00   2006-12-31 00:00:00   None   2007-06-30 00:00:00   2007-06-30 00:00:00   None   None   None   None   2007-12-31 00:00:00   2007-12-31 00:00:00   None   None   None   None   None   2013-06-30 00:00:00   2014-06-30 00:00:00   2013-06-30 00:00:00   2014-12-31 00:00:00   2007-12-31 00:00:00   None   2008-06-30 00:00:00   2008-06-30 00:00:00   None   2008-12-31 00:00:00   2008-12-31 00:00:00   2008-10-30 00:00:00   2008-10-28 00:00:00   2009-02-26 00:00:00   None   None   2009-02-26 00:00:00   2008-10-29 00:00:00   2009-03-02 00:00:00   None   None   None   2009-02-19 00:00:00   None   2009-06-30 00:00:00   None   2009-06-30 00:00:00   2009-06-30 00:00:00   2009-06-30 00:00:00   2009-05-07 00:00:00   2009-12-31 00:00:00   None   2009-12-31 00:00:00   2009-12-31 00:00:00   2009-12-31 00:00:00   2010-06-30 00:00:00   2010-06-30 00:00:00   2010-10-28 00:00:00   2010-10-29 00:00:00   2010-12-31 00:00:00   2010-12-31 00:00:00   2011-06-30 00:00:00   2011-06-30 00:00:00   None   None   None   None   2011-12-31 00:00:00   2011-12-31 00:00:00   2011-12-31 00:00:00   2011-12-31 00:00:00   2013-12-31 00:00:00   2013-12-31 00:00:00   2013-12-31 00:00:00   2014-12-31 00:00:00   2012-11-07 00:00:00   2012-12-31 00:00:00   2013-12-31 00:00:00   2012-12-31 00:00:00   2020-07-15 00:00:00   2020-10-15 00:00:00   2018-06-30 00:00:00   2018-11-02 00:00:00   2020-10-22 00:00:00   2018-06-30 00:00:00   2018-12-31 00:00:00   2020-12-31 00:00:00   2019-06-30 00:00:00   2018-05-23 00:00:00   2019-06-30 00:00:00   2018-11-06 00:00:00   2016-06-30 00:00:00   2016-06-30 00:00:00   2016-12-31 00:00:00   2017-01-31 00:00:00   2017-01-27 00:00:00   2016-12-31 00:00:00   2018-10-31 00:00:00   2020-11-02 00:00:00   2018-10-19 00:00:00   2018-12-31 00:00:00   2018-09-06 00:00:00   2020-10-19 00:00:00   2018-05-24 00:00:00   2019-01-18 00:00:00   2019-12-31 00:00:00   2020-06-30 00:00:00   2020-12-31 00:00:00   2018-10-23 00:00:00   2018-08-27 00:00:00   2020-06-30 00:00:00   2019-12-31 00:00:00   2022-06-03 00:00:00   2022-06-30 00:00:00   2020-12-31 00:00:00   2022-06-30 00:00:00   2021-03-31 00:00:00   2020-12-31 00:00:00   2021-12-31 00:00:00   2021-12-31 00:00:00   2022-10-05 00:00:00   2022-10-31 00:00:00   2022-10-27 00:00:00
rpt_date   None   None   None   None   None   2001-01-30 00:00:00   None   None   None   2002-07-30 00:00:00   2003-01-27 00:00:00   None   None   None   None   None   None   None   None   2006-10-24 00:00:00   2006-11-07 00:00:00   2007-01-12 00:00:00   2006-10-26 00:00:00   2006-10-27 00:00:00   2006-11-06 00:00:00   None   None   None   2007-07-12 00:00:00   None   None   None   None   2008-01-14 00:00:00   2008-01-14 00:00:00   None   None   None   None   None   2013-07-29 00:00:00   2014-07-25 00:00:00   None   None   None   None   2008-07-14 00:00:00   None   None   2009-01-16 00:00:00   None   2008-10-30 00:00:00   2008-10-28 00:00:00   2009-02-26 00:00:00   None   None   2009-02-26 00:00:00   2008-10-29 00:00:00   2009-03-02 00:00:00   None   None   None   2009-02-19 00:00:00   None   2009-07-06 00:00:00   None   2009-07-28 00:00:00   None   None   2009-05-07 00:00:00   2010-01-19 00:00:00   None   2010-02-15 00:00:00   None   None   None   2010-07-30 00:00:00   2010-10-28 00:00:00   None   2011-01-31 00:00:00   None   2011-07-27 00:00:00   None   None   None   None   None   2012-01-13 00:00:00   None   None   2012-01-30 00:00:00   None   None   2014-01-28 00:00:00   2015-01-27 00:00:00   2012-11-07 00:00:00   2013-01-29 00:00:00   2014-02-26 00:00:00   None   2020-07-15 00:00:00   2020-10-15 00:00:00   2018-07-30 00:00:00   2018-11-02 00:00:00   2020-10-22 00:00:00   None   None   None   None   2018-05-23 00:00:00   2019-07-30 00:00:00   2018-11-06 00:00:00   2016-07-29 00:00:00   None   2017-01-31 00:00:00   2017-01-31 00:00:00   2017-01-27 00:00:00   None   2018-10-31 00:00:00   2020-11-02 00:00:00   2018-10-19 00:00:00   2019-01-30 00:00:00   2018-09-06 00:00:00   2020-10-19 00:00:00   2018-05-24 00:00:00   2019-01-18 00:00:00   None   None   2021-01-27 00:00:00   2018-10-23 00:00:00   2018-08-27 00:00:00   2020-07-29 00:00:00   2020-01-30 00:00:00   2022-06-03 00:00:00   None   None   2022-07-24 00:00:00   2021-03-31 00:00:00   2021-04-07 00:00:00   2022-01-27 00:00:00   None   2022-10-05 00:00:00   2022-10-31 00:00:00   2022-10-27 00:00:00
filing_type   None   None   None   None   None   None   None   None   None   None   22001   None   None   None   None   None   None   None   None   22006   22006   22006   22006   22006   22006   None   None   None   22006   None   None   None   None   22006   22006   None   None   None   None   None   22006   22006   None   None   None   None   22006   None   None   22006   None   22006   22006   22006   None   None   22006   22006   22006   None   None   None   22006   None   22006   None   22006   None   None   22006   22006   None   22006   None   None   None   22006   22006   None   22006   None   22006   None   None   None   None   None   22006   None   None   22006   None   None   22006   22006   22006   22006   22006   None   22001   22001   22001   22001   22001   None   None   None   None   22001   22001   22001   22001   None   22001   22001   22001   None   22001   22001   22001   22001   22001   22001   22001   22001   None   None   22001   22001   22001   22001   22001   22001   None   None   22001   22001   22001   22001   None   22001   22001   22001
Table: filer_to_filer_type
filer_id   1013172
filer_type   10
active   Y
race   0
session_id   1995
category   0
category_type   40502
sub_category   0
effect_dt   1995-01-25 00:00:00
sub_category_type   0
election_type   0
sub_category_a   None
nyq_dt   None
party_cd   None
county_cd   18026
district_cd   None
Table: filer_xref
filer_id   1013172
xref_id   495034
effect_dt   1999-12-07 00:00:00
migration_source   IDENTFIX
Table: filername
xref_filer_id   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034   495034
filer_id   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172
filer_type   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE   MAJOR DONOR/INDEPENDENT EXPENDITURE 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   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   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   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00   1995-01-25 00:00:00
naml   AECOM   AECOM   AECOM   AECOM   AECOM   AECOM   AECOM   AECOM   AECOM   AECOM   AECOM   AECOM   AECOM   AECOM AND ITS SUBSIDIARIES   AECOM AND ITS SUBSIDIARIES   AECOM AND ITS SUBSIDIARIES   AECOM AND ITS SUBSIDIARIES   AECOM AND ITS SUBSIDIARIES   AECOM AND ITS SUBSIDIARIES   AECOM AND ITS SUBSIDIARIES   AECOM AND ITS SUBSIDIARIES   AECOM AND ITS SUBSIDIARIES   AECOM AND ITS SUBSIDIARIES   AECOM AND ITS SUBSIDIARIES   AECOM AND ITS SUBSIDIARIES   AECOM AND ITS SUBSIDIARIES   AECOM   AECOM   AECOM   AECOM   AECOM   AECOM   AECOM   AECOM   AECOM   AECOM   AECOM   AECOM   AECOM   AECOM TECHNOLOGY CORPORATION AND ITS SUBSIDIARY COMPANIES   AECOM TECHNOLOGY CORPORATION AND ITS SUBSIDIARY COMPANIES   AECOM TECHNOLOGY CORPORATION AND ITS SUBSIDIARY COMPANIES   AECOM TECHNOLOGY CORPORATION AND ITS SUBSIDIARY COMPANIES   AECOM TECHNOLOGY CORPORATION AND ITS SUBSIDIARY COMPANIES   AECOM TECHNOLOGY CORPORATION AND ITS SUBSIDIARY COMPANIES   AECOM TECHNOLOGY CORPORATION AND ITS SUBSIDIARY COMPANIES   AECOM TECHNOLOGY CORPORATION AND ITS SUBSIDIARY COMPANIES   AECOM TECHNOLOGY CORPORATION AND ITS SUBSIDIARY COMPANIES   AECOM TECHNOLOGY CORPORATION AND ITS SUBSIDIARY COMPANIES   AECOM TECHNOLOGY CORPORATION AND ITS SUBSIDIARY COMPANIES   AECOM TECHNOLOGY CORPORATION AND ITS SUBSIDIARY COMPANIES   AECOM TECHNOLOGY CORPORATION AND ITS SUBSIDIARY COMPANIES   AECOM TECHNOLOGY CORP. AND ITS SUBSIDIARY COMPANIES ATG BOYLE, DMJM HARRIS, DMJM H&N AND EARTH TECH   AECOM TECHNOLOGY CORP. AND ITS SUBSIDIARY COMPANIES ATG BOYLE, DMJM HARRIS, DMJM H&N AND EARTH TECH   AECOM TECHNOLOGY CORP. AND ITS SUBSIDIARY COMPANIES ATG BOYLE, DMJM HARRIS, DMJM H&N AND EARTH TECH   AECOM TECHNOLOGY CORP. AND ITS SUBSIDIARY COMPANIES ATG BOYLE, DMJM HARRIS, DMJM H&N AND EARTH TECH   AECOM TECHNOLOGY CORP. AND ITS SUBSIDIARY COMPANIES ATG BOYLE, DMJM HARRIS, DMJM H&N AND EARTH TECH   AECOM TECHNOLOGY CORP. AND ITS SUBSIDIARY COMPANIES ATG BOYLE, DMJM HARRIS, DMJM H&N AND EARTH TECH   AECOM TECHNOLOGY CORP. AND ITS SUBSIDIARY COMPANIES ATG BOYLE, DMJM HARRIS, DMJM H&N AND EARTH TECH   AECOM TECHNOLOGY CORP. AND ITS SUBSIDIARY COMPANIES ATG BOYLE, DMJM HARRIS, DMJM H&N AND EARTH TECH   AECOM TECHNOLOGY CORP. AND ITS SUBSIDIARY COMPANIES ATG BOYLE, DMJM HARRIS, DMJM H&N AND EARTH TECH   AECOM TECHNOLOGY CORP. AND ITS SUBSIDIARY COMPANIES ATG BOYLE, DMJM HARRIS, DMJM H&N AND EARTH TECH   AECOM TECHNOLOGY CORP. AND ITS SUBSIDIARY COMPANIES ATG BOYLE, DMJM HARRIS, DMJM H&N AND EARTH TECH   AECOM TECHNOLOGY CORP. AND ITS SUBSIDIARY COMPANIES ATG BOYLE, DMJM HARRIS, DMJM H&N AND EARTH TECH   AECOM TECHNOLOGY CORP. AND ITS SUBSIDIARY COMPANIES ATG BOYLE, DMJM HARRIS, DMJM H&N AND EARTH TECH   RESOURCE SCIENCES CORPORATION (RSC), THE   RESOURCE SCIENCES CORPORATION (RSC), THE   RESOURCE SCIENCES CORPORATION (RSC), THE   RESOURCE SCIENCES CORPORATION (RSC), THE   RESOURCE SCIENCES CORPORATION (RSC), THE   RESOURCE SCIENCES CORPORATION (RSC), THE   RESOURCE SCIENCES CORPORATION (RSC), THE   RESOURCE SCIENCES CORPORATION (RSC), THE   RESOURCE SCIENCES CORPORATION (RSC), THE   RESOURCE SCIENCES CORPORATION (RSC), THE   RESOURCE SCIENCES CORPORATION (RSC), THE   RESOURCE SCIENCES CORPORATION (RSC), THE   RESOURCE SCIENCES CORPORATION (RSC), THE   AECOM TECHNOLOGY CORPORATION (ATC) (FILER) THE RESOURCE SCIENCES CORPORATION (RSC) (AFFILIATE)   AECOM TECHNOLOGY CORPORATION (ATC) (FILER) THE RESOURCE SCIENCES CORPORATION (RSC) (AFFILIATE)   AECOM TECHNOLOGY CORPORATION (ATC) (FILER) THE RESOURCE SCIENCES CORPORATION (RSC) (AFFILIATE)   AECOM TECHNOLOGY CORPORATION (ATC) (FILER) THE RESOURCE SCIENCES CORPORATION (RSC) (AFFILIATE)   AECOM TECHNOLOGY CORPORATION (ATC) (FILER) THE RESOURCE SCIENCES CORPORATION (RSC) (AFFILIATE)   AECOM TECHNOLOGY CORPORATION (ATC) (FILER) THE RESOURCE SCIENCES CORPORATION (RSC) (AFFILIATE)   AECOM TECHNOLOGY CORPORATION (ATC) (FILER) THE RESOURCE SCIENCES CORPORATION (RSC) (AFFILIATE)   AECOM TECHNOLOGY CORPORATION (ATC) (FILER) THE RESOURCE SCIENCES CORPORATION (RSC) (AFFILIATE)   AECOM TECHNOLOGY CORPORATION (ATC) (FILER) THE RESOURCE SCIENCES CORPORATION (RSC) (AFFILIATE)   AECOM TECHNOLOGY CORPORATION (ATC) (FILER) THE RESOURCE SCIENCES CORPORATION (RSC) (AFFILIATE)   AECOM TECHNOLOGY CORPORATION (ATC) (FILER) THE RESOURCE SCIENCES CORPORATION (RSC) (AFFILIATE)   AECOM TECHNOLOGY CORPORATION (ATC) (FILER) THE RESOURCE SCIENCES CORPORATION (RSC) (AFFILIATE)   AECOM TECHNOLOGY CORPORATION (ATC) (FILER) THE RESOURCE SCIENCES CORPORATION (RSC) (AFFILIATE)
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
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
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
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
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
city   LOS ANGELES   LOS ANGELES   LOS ANGELES   ORANGE   ORANGE   ORANGE   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   ORANGE   ORANGE   ORANGE   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   ORANGE   ORANGE   ORANGE   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   ORANGE   ORANGE   ORANGE   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   ORANGE   ORANGE   ORANGE   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   ORANGE   ORANGE   ORANGE   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   LOS ANGELES   ORANGE   ORANGE   ORANGE   LONG BEACH   LONG BEACH   LONG BEACH   LONG BEACH   LOS ANGELES   LOS ANGELES   LOS ANGELES
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
zip4   900101599   900712300   90071 230   92868   92868   92868   90810   90810   90810   90810   90067   90067   90071   900101599   900712300   90071 230   92868   92868   92868   90810   90810   90810   90810   90067   90067   90071   900101599   900712300   90071 230   92868   92868   92868   90810   90810   90810   90810   90067   90067   90071   900101599   900712300   90071 230   92868   92868   92868   90810   90810   90810   90810   90067   90067   90071   900101599   900712300   90071 230   92868   92868   92868   90810   90810   90810   90810   90067   90067   90071   900101599   900712300   90071 230   92868   92868   92868   90810   90810   90810   90810   90067   90067   90071   900101599   900712300   90071 230   92868   92868   92868   90810   90810   90810   90810   90067   90067   90071
phon   2133813612   7145672404   7145672404   7145672404   7145672404   7145672404   5622134139   5622134139   5622134159   5622134159      2135938100   2135938100   2133813612   7145672404   7145672404   7145672404   7145672404   7145672404   5622134139   5622134139   5622134159   5622134159      2135938100   2135938100   2133813612   7145672404   7145672404   7145672404   7145672404   7145672404   5622134139   5622134139   5622134159   5622134159      2135938100   2135938100   2133813612   7145672404   7145672404   7145672404   7145672404   7145672404   5622134139   5622134139   5622134159   5622134159      2135938100   2135938100   2133813612   7145672404   7145672404   7145672404   7145672404   7145672404   5622134139   5622134139   5622134159   5622134159      2135938100   2135938100   2133813612   7145672404   7145672404   7145672404   7145672404   7145672404   5622134139   5622134139   5622134159   5622134159      2135938100   2135938100   2133813612   7145672404   7145672404   7145672404   7145672404   7145672404   5622134139   5622134139   5622134159   5622134159      2135938100   2135938100
fax   None   7147562770   7147562770   7147562770   7147562770   7147562770   5624202915   5624202915   5624202915   5624202915            None   7147562770   7147562770   7147562770   7147562770   7147562770   5624202915   5624202915   5624202915   5624202915            None   7147562770   7147562770   7147562770   7147562770   7147562770   5624202915   5624202915   5624202915   5624202915            None   7147562770   7147562770   7147562770   7147562770   7147562770   5624202915   5624202915   5624202915   5624202915            None   7147562770   7147562770   7147562770   7147562770   7147562770   5624202915   5624202915   5624202915   5624202915            None   7147562770   7147562770   7147562770   7147562770   7147562770   5624202915   5624202915   5624202915   5624202915            None   7147562770   7147562770   7147562770   7147562770   7147562770   5624202915   5624202915   5624202915   5624202915         
email   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None   None   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   [email protected]   None   None   None
Table: filers
filer_id   1013172
Table: received_filings
filer_id   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172   1013172
filing_file_name   718800_0.cal   855522_0.cal   215566.cal   215618.cal   222550.cal   230548.cal   410103.cal   410203.cal   410227.cal   410296.cal   910641_0.cal   2125562_0.cal   2129055_0.cal   2322381_0.cal   2252793_0.cal   2320145_0.cal   2309109_0.cal   2478692_0.cal   2253668_0.cal   2289304_0.cal   2335954_0.cal   2311069_0.cal   2286535_0.cal   2516324_0.cal   2690554_0.cal   2521078_0.cal   2728852_0.cal   2531179_0.cal   2570968_0.cal   2518122_0.cal   2748209_0.cal   2743049_0.cal
received_date   2001-01-31 00:00:00   2002-07-31 00:00:00   2002-07-30 00:00:00   2002-07-30 00:00:00   2002-07-30 00:00:00   2002-07-30 00:00:00   2003-01-28 00:00:00   2003-01-28 00:00:00   2003-01-28 00:00:00   2003-01-28 00:00:00   2003-01-30 00:00:00   2017-01-27 00:00:00   2017-01-31 00:00:00   2018-11-02 00:00:00   2018-05-23 00:00:00   2018-10-31 00:00:00   2018-10-19 00:00:00   2020-07-15 00:00:00   2018-05-24 00:00:00   2018-09-06 00:00:00   2019-01-18 00:00:00   2018-10-23 00:00:00   2018-08-27 00:00:00   2020-10-15 00:00:00   2022-06-03 00:00:00   2020-10-22 00:00:00   2022-10-05 00:00:00   2020-11-02 00:00:00   2021-03-31 00:00:00   2020-10-19 00:00:00   2022-10-31 00:00:00   2022-10-27 00:00:00
filing_directory   /usr/users/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/temp   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal   /cafiler/disclose/ca99/cal
filing_id   718800   855522   None   None   None   None   None   None   None   None   910641   2125562   2129055   2322381   2252793   2320145   2309109   2478692   2253668   2289304   2335954   2311069   2286535   2516324   2690554   2521078   2728852   2531179   2570968   2518122   2748209   2743049
form_id   F461   F461   None   None   None   None   None   None   None   None   F461   F497   F497   F497   F497   F497   F497   F497   F497   F497   F497   F497   F497   F497   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 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, 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 accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted   Filing accepted