filer_id | 1009365 | 1009365 | 1009365 | 1009365 | ||||
---|---|---|---|---|---|---|---|---|
adrid | 1008635 | 2090812 | 2218370 | 2423601 | ||||
effect_dt | 2001-10-10 00:00:00 | 2008-01-31 00:00:00 | 2011-07-28 00:00:00 | 2017-01-31 00:00:00 | ||||
add_type | 7051 | 7051 | 7051 | 7051 | ||||
session_id | 2001 | 2007 | 2011 | 2015 |
filer_id | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 202670 | 59016 | 59017 | 59018 | 59019 | 669222 | 690916 | 713434 | 683495 | 747581 | 748264 | 769936 | 785459 | 785459 | 802980 | 809909 | 809911 | 769936 | 829386 | 887289 | 908633 | 881050 | 916981 | 1099807 | 1080638 | 1118355 | 1116633 | 1111459 | 1111458 | 1146734 | 1178538 | 1787721 | 1981251 | 1870496 | 1855526 | 1856907 | 1783368 | 1935528 | 1899150 | 1897980 | 1310888 | 1312927 | 1349566 | 1345437 | 1395755 | 1401468 | 1538862 | 1544065 | 1576941 | 1568289 | 1609932 | 1632569 | 1605804 | 1634420 | 1831253 | 1826645 | 1818137 | 1932871 | 1877437 | 1734300 | 1734414 | 1828037 | 1846850 | 1846852 | 1851234 | 1839786 | 1839953 | 1837087 | 1984052 | 2289755 | 2291167 | 2182817 | 2463640 | 2435506 | 2391306 | 2253059 | 2005874 | 2017105 | 2067287 | 2058753 | 2076278 | 2080151 | 2085924 | 2090896 | 2092437 | 2086631 | 2105869 | 2105876 | 2128081 | 2136499 | 2172934 | 2273006 | 2273006 | 2339838 | 2294995 | 2336375 | 2487137 | 2392525 | 2316784 | 2205392 | 2227037 | 2253059 | 2293884 | 2303842 | 2285564 | 2289755 | 2339838 | 2533328 | 2336375 | 2552134 | 2566968 | 2703330 | 2656205 | 2639206 | 2599738 | 2607814 | 2712293 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 141 | 89 | 137 | 141 | 145 | None | None | 163 | 164 | None | None | 165 | 167 | 167 | 168 | None | None | 165 | None | None | 169 | 172 | None | None | 177 | None | 181 | None | None | 183 | None | None | 221 | 217 | 218 | 218 | 213 | 219 | 220 | 220 | 189 | None | None | 193 | 195 | None | 204 | None | None | 201 | None | 207 | 205 | None | 217 | 217 | 215 | None | None | None | 209 | None | 218 | 218 | 218 | 218 | 218 | 218 | None | None | 235 | None | None | 239 | 237 | 234 | 223 | None | None | 225 | 227 | 227 | 228 | 228 | 228 | 228 | 228 | 228 | 227 | None | 229 | 233 | 233 | None | 235 | 235 | 241 | None | 236 | 231 | None | 234 | 235 | 236 | 235 | None | None | None | 235 | 243 | None | 249 | None | 247 | 245 | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F465 | F461 | F461 | F461 | F461 | F461 | F497 | F461 | F497 | F461 | F461 | F461 | F461 | F461 | F461 | F405 | F405 | F461 | F461 | F497 | F461 | F497 | F461 | F461 | F461 | F461 | F461 | F405 | F405 | F461 | F461 | F461 | F461 | F461 | F497 | F497 | F461 | F461 | F497 | F497 | F461 | F461 | F461 | F461 | F461 | F461 | F497 | F497 | F461 | F461 | F461 | F461 | F461 | F461 | F497 | F497 | F461 | F461 | F461 | F461 | F461 | F461 | F497 | F497 | F497 | F497 | F497 | F497 | F461 | F461 | F497 | F461 | F461 | F461 | F461 | F497 | F461 | F461 | F461 | F461 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F461 | F461 | F461 | F461 | F461 | F461 | F497 | F461 | F461 | F461 | F497 | F461 | F461 | F497 | F497 | F497 | F497 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 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 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1996-01-29 00:00:00 | 1982-06-02 00:00:00 | 1995-02-08 00:00:00 | 1996-01-29 00:00:00 | 1997-01-29 00:00:00 | 2000-07-27 00:00:00 | 2000-11-01 00:00:00 | 2001-01-23 00:00:00 | 2000-11-01 00:00:00 | 2001-01-30 00:00:00 | 2001-03-23 00:00:00 | 2001-07-25 00:00:00 | 2001-10-09 00:00:00 | 2002-01-02 00:00:00 | 2002-01-02 00:00:00 | 2002-01-09 00:00:00 | 2001-10-10 00:00:00 | 2002-01-02 00:00:00 | 2002-01-09 00:00:00 | 2002-10-28 00:00:00 | 2003-01-29 00:00:00 | 2002-10-28 00:00:00 | 2003-01-31 00:00:00 | 2005-01-31 00:00:00 | 2005-01-31 00:00:00 | 2005-07-29 00:00:00 | 2005-07-28 00:00:00 | 2002-01-09 00:00:00 | 2002-01-09 00:00:00 | 2006-01-30 00:00:00 | 2006-01-31 00:00:00 | 2013-07-31 00:00:00 | 2015-07-30 00:00:00 | 2014-07-30 00:00:00 | 2014-05-28 00:00:00 | 2014-05-30 00:00:00 | 2013-07-31 00:00:00 | 2015-01-31 00:00:00 | 2014-10-16 00:00:00 | 2014-10-14 00:00:00 | 2008-01-31 00:00:00 | 2008-01-31 00:00:00 | 2008-07-30 00:00:00 | 2008-07-23 00:00:00 | 2009-01-30 00:00:00 | 2009-01-30 00:00:00 | 2010-10-29 00:00:00 | 2010-10-29 00:00:00 | 2011-01-27 00:00:00 | 2011-01-27 00:00:00 | 2011-07-28 00:00:00 | 2012-01-26 00:00:00 | 2011-07-28 00:00:00 | 2012-01-27 00:00:00 | 2014-03-21 00:00:00 | 2014-03-07 00:00:00 | 2014-01-31 00:00:00 | 2015-01-27 00:00:00 | 2014-07-31 00:00:00 | 2013-01-24 00:00:00 | 2013-01-29 00:00:00 | 2014-01-31 00:00:00 | 2014-05-02 00:00:00 | 2014-05-02 00:00:00 | 2014-05-17 00:00:00 | 2014-04-21 00:00:00 | 2014-04-21 00:00:00 | 2014-04-08 00:00:00 | 2015-07-31 00:00:00 | 2018-07-30 00:00:00 | 2018-09-12 00:00:00 | 2017-07-27 00:00:00 | 2020-01-24 00:00:00 | 2020-01-24 00:00:00 | 2019-07-19 00:00:00 | 2018-06-07 00:00:00 | 2016-01-24 00:00:00 | 2016-01-27 00:00:00 | 2016-07-28 00:00:00 | 2016-07-26 00:00:00 | 2016-09-13 00:00:00 | 2016-09-22 00:00:00 | 2016-10-06 00:00:00 | 2016-10-18 00:00:00 | 2016-10-20 00:00:00 | 2016-10-07 00:00:00 | 2016-11-07 00:00:00 | 2016-11-07 00:00:00 | 2017-01-30 00:00:00 | 2017-01-31 00:00:00 | 2017-07-27 00:00:00 | 2018-08-17 00:00:00 | 2018-07-30 00:00:00 | 2019-01-18 00:00:00 | 2018-09-24 00:00:00 | 2020-07-31 00:00:00 | 2020-07-31 00:00:00 | 2019-07-19 00:00:00 | 2018-10-30 00:00:00 | 2018-01-25 00:00:00 | 2018-01-25 00:00:00 | 2018-05-24 00:00:00 | 2018-09-20 00:00:00 | 2018-10-09 00:00:00 | 2018-08-22 00:00:00 | 2018-08-17 00:00:00 | 2020-07-30 00:00:00 | 2020-07-30 00:00:00 | 2019-01-18 00:00:00 | 2021-01-31 00:00:00 | 2021-01-29 00:00:00 | 2022-07-28 00:00:00 | 2022-01-28 00:00:00 | 2022-01-27 00:00:00 | 2021-07-29 00:00:00 | 2021-07-30 00:00:00 | 2922-07-29 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10002 | 10001 | 10005 | 10005 | 10002 | 10005 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10002 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10002 | 10001 | 10005 | 10001 | 10002 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10006 | 10006 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10005 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1995 | 1981 | 1993 | 1995 | 1995 | 1999 | 1999 | 1999 | 1999 | 1999 | 1997 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2003 | 2005 | 2005 | 2001 | 2001 | 2005 | 2005 | 2013 | 2015 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2007 | 2007 | 2007 | 2007 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2011 | 2011 | 2011 | 2013 | 2013 | 2013 | 2013 | 2013 | 2011 | 2011 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2015 | 2017 | 2017 | 2017 | 2019 | 2019 | 2019 | 2017 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2019 | 2017 | 2017 | 2019 | 2019 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2017 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | * | EMCENTEE | GKURIMOT | * | * | EMCENTEE | DHORRELL | * | * | * | * | LTHIBAUL | DHORRELL | * | LTHIBAUL | KLARRY | COMPLETED | * | LTHIBAUL | DHORRELL | COMPLETED | DHORRELL | * | DHORRELL | DHORRELL | DHORRELL | DHORRELL | JINGRAM | JINGRAM | JINGRAM | WBROWN | WBROWN | JINGRAM | JINGRAM | WBROWN | WBROWN | SMCCABE | SMCCABE | SMCCABE | SMCCABE | JINGRAM | JINGRAM | CREYNOLDS | MPACHECO | JINGRAM | JINGRAM | JINGRAM | JINGRAM | JINGRAM | JINGRAM | WBROWN | WBROWN | JINGRAM | JINGRAM | JINGRAM | JINGRAM | JINGRAM | JINGRAM | WBROWN | WBROWN | WBROWN | WBROWN | WBROWN | WBROWN | JINGRAM | GTAYLOR | CAFILER | LPALMER | GTAYLOR | GTAYLOR | GTAYLOR | CAFILER | JINGRAM | JINGRAM | JINGRAM | JINGRAM | PDEO | PDEO | PDEO | PDEO | PDEO | PDEO | RGEREMIA | PDEO | JINGRAM | JINGRAM | LPALMER | GTAYLOR | GTAYLOR | GTAYLOR | CAFILER | GTAYLOR | GTAYLOR | GTAYLOR | CAFILER | DMCCASTL | DMCCASTL | CAFILER | CAFILER | CAFILER | CAFILER | AROJAS | GTAYLOR | GTAYLOR | GTAYLOR | GTAYLOR | GTAYLOR | GTAYLOR | GTAYLOR | GTAYLOR | GTAYLOR | GTAYLOR | GTAYLOR | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 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 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1995-01-01 00:00:00 | 1982-01-01 00:00:00 | 1994-01-01 00:00:00 | 1995-01-01 00:00:00 | 1996-01-01 00:00:00 | 2000-01-01 00:00:00 | 2000-11-01 00:00:00 | 2000-07-01 00:00:00 | 2000-11-01 00:00:00 | 2000-07-01 00:00:00 | 1998-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-07-01 00:00:00 | 2001-07-01 00:00:00 | 2001-10-01 00:00:00 | 2001-01-01 00:00:00 | 2001-07-01 00:00:00 | 2001-01-01 00:00:00 | 2001-10-01 00:00:00 | None | 2002-01-01 00:00:00 | 2002-10-28 00:00:00 | 2002-01-01 00:00:00 | 2004-01-01 00:00:00 | 2004-01-01 00:00:00 | 2005-01-01 00:00:00 | 2005-01-01 00:00:00 | 2001-07-01 00:00:00 | 2001-01-01 00:00:00 | 2005-07-01 00:00:00 | 2005-07-01 00:00:00 | 2013-01-01 00:00:00 | 2015-01-01 00:00:00 | 2014-01-01 00:00:00 | 2014-05-28 00:00:00 | 2014-05-30 00:00:00 | 2013-01-01 00:00:00 | 2014-07-01 00:00:00 | 2014-10-16 00:00:00 | 2014-10-14 00:00:00 | 2007-01-01 00:00:00 | 2007-01-01 00:00:00 | 2008-01-01 00:00:00 | 2008-01-01 00:00:00 | 2008-07-01 00:00:00 | 2008-07-01 00:00:00 | 2010-10-29 00:00:00 | None | 2010-01-01 00:00:00 | 2010-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-07-01 00:00:00 | 2011-01-01 00:00:00 | 2011-07-01 00:00:00 | 2014-03-21 00:00:00 | 2014-03-07 00:00:00 | 2013-07-01 00:00:00 | 2014-07-01 00:00:00 | 2014-01-01 00:00:00 | 2012-01-01 00:00:00 | 2012-01-01 00:00:00 | 2013-07-01 00:00:00 | 2014-05-02 00:00:00 | 2014-05-02 00:00:00 | 2014-05-17 00:00:00 | 2014-04-21 00:00:00 | 2014-04-21 00:00:00 | 2014-04-08 00:00:00 | 2015-01-01 00:00:00 | 2018-01-01 00:00:00 | 2018-09-12 00:00:00 | 2017-01-01 00:00:00 | 2019-07-01 00:00:00 | 2019-07-01 00:00:00 | 2019-01-01 00:00:00 | 2018-06-07 00:00:00 | 2015-07-01 00:00:00 | 2015-07-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-09-13 00:00:00 | 2016-09-22 00:00:00 | 2016-10-06 00:00:00 | 2016-10-18 00:00:00 | 2016-10-20 00:00:00 | 2016-10-07 00:00:00 | 2016-11-07 00:00:00 | 2016-11-07 00:00:00 | 2016-07-01 00:00:00 | 2016-07-01 00:00:00 | 2017-01-01 00:00:00 | 2018-01-01 00:00:00 | 2018-01-01 00:00:00 | 2018-07-01 00:00:00 | 2018-09-24 00:00:00 | 2018-07-01 00:00:00 | 2020-01-01 00:00:00 | 2019-01-01 00:00:00 | 2018-10-30 00:00:00 | 2017-07-01 00:00:00 | 2017-07-01 00:00:00 | 2018-05-24 00:00:00 | 2018-09-20 00:00:00 | 2018-10-09 00:00:00 | 2018-08-22 00:00:00 | 2018-01-01 00:00:00 | 2018-07-01 00:00:00 | 2020-01-01 00:00:00 | 2018-07-01 00:00:00 | 2020-07-01 00:00:00 | 2020-07-01 00:00:00 | 2022-01-01 00:00:00 | 2021-07-01 00:00:00 | 2021-07-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2022-01-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1995-12-31 00:00:00 | 1982-06-30 00:00:00 | 1994-12-31 00:00:00 | 1995-12-31 00:00:00 | 1996-12-31 00:00:00 | 2000-06-30 00:00:00 | 2000-11-01 00:00:00 | 2000-12-31 00:00:00 | 2000-11-01 00:00:00 | 2000-12-31 00:00:00 | 1998-12-31 00:00:00 | 2001-06-30 00:00:00 | 2001-09-30 00:00:00 | 2001-09-30 00:00:00 | 2001-12-31 00:00:00 | 2001-06-30 00:00:00 | 2001-09-30 00:00:00 | 2001-06-30 00:00:00 | 2001-12-31 00:00:00 | None | 2002-12-31 00:00:00 | 2002-10-28 00:00:00 | 2002-12-31 00:00:00 | 2004-12-31 00:00:00 | 2004-12-31 00:00:00 | 2005-06-30 00:00:00 | 2005-06-30 00:00:00 | 2001-09-30 00:00:00 | 2001-06-30 00:00:00 | 2005-12-31 00:00:00 | 2005-12-31 00:00:00 | 2013-06-30 00:00:00 | 2015-06-30 00:00:00 | 2014-06-30 00:00:00 | 2014-05-28 00:00:00 | 2014-05-30 00:00:00 | 2013-06-30 00:00:00 | 2014-12-31 00:00:00 | 2014-10-16 00:00:00 | 2014-10-14 00:00:00 | 2007-12-31 00:00:00 | 2007-12-31 00:00:00 | 2008-06-30 00:00:00 | 2008-06-30 00:00:00 | 2008-12-31 00:00:00 | 2008-12-31 00:00:00 | 2010-10-29 00:00:00 | None | 2010-12-31 00:00:00 | 2010-12-31 00:00:00 | 2011-06-30 00:00:00 | 2011-12-31 00:00:00 | 2011-06-30 00:00:00 | 2011-12-31 00:00:00 | 2014-03-21 00:00:00 | 2014-03-07 00:00:00 | 2013-12-31 00:00:00 | 2014-12-31 00:00:00 | 2014-06-30 00:00:00 | 2012-12-31 00:00:00 | 2012-12-31 00:00:00 | 2013-12-31 00:00:00 | 2014-05-02 00:00:00 | 2014-05-02 00:00:00 | 2014-05-17 00:00:00 | 2014-04-21 00:00:00 | 2014-04-21 00:00:00 | 2014-04-08 00:00:00 | 2015-06-30 00:00:00 | 2018-06-30 00:00:00 | 2018-09-12 00:00:00 | 2017-06-30 00:00:00 | 2019-12-31 00:00:00 | 2019-12-31 00:00:00 | 2019-06-30 00:00:00 | 2018-06-07 00:00:00 | 2015-12-31 00:00:00 | 2015-12-31 00:00:00 | 2016-06-30 00:00:00 | 2016-06-30 00:00:00 | 2016-09-13 00:00:00 | 2016-09-22 00:00:00 | 2016-10-06 00:00:00 | 2016-10-18 00:00:00 | 2016-10-20 00:00:00 | 2016-10-07 00:00:00 | 2016-11-07 00:00:00 | 2016-11-07 00:00:00 | 2016-12-31 00:00:00 | 2016-12-31 00:00:00 | 2017-06-30 00:00:00 | 2018-06-30 00:00:00 | 2018-06-30 00:00:00 | 2018-12-31 00:00:00 | 2018-09-24 00:00:00 | 2018-12-31 00:00:00 | 2020-06-30 00:00:00 | 2019-06-30 00:00:00 | 2018-10-30 00:00:00 | 2017-12-31 00:00:00 | 2017-12-31 00:00:00 | 2018-05-24 00:00:00 | 2018-09-20 00:00:00 | 2018-10-09 00:00:00 | 2018-08-22 00:00:00 | 2018-06-30 00:00:00 | 2018-12-31 00:00:00 | 2020-06-30 00:00:00 | 2018-12-31 00:00:00 | 2020-12-31 00:00:00 | 2020-12-31 00:00:00 | 2022-06-30 00:00:00 | 2021-12-31 00:00:00 | 2021-12-31 00:00:00 | 2021-06-30 00:00:00 | 2021-06-30 00:00:00 | 2022-06-30 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | None | None | None | None | None | None | None | 2001-01-22 00:00:00 | 2000-11-01 00:00:00 | None | None | 2001-07-23 00:00:00 | 2001-10-04 00:00:00 | 2001-12-28 00:00:00 | 2001-12-28 00:00:00 | None | None | 2001-12-28 00:00:00 | None | None | 2003-01-21 00:00:00 | 2002-10-28 00:00:00 | None | None | 2005-01-18 00:00:00 | None | 2005-07-21 00:00:00 | None | None | 2006-01-24 00:00:00 | None | None | 2015-07-07 00:00:00 | 2014-07-21 00:00:00 | 2014-05-28 00:00:00 | 2014-05-30 00:00:00 | 2013-07-23 00:00:00 | 2015-01-12 00:00:00 | 2014-10-16 00:00:00 | 2014-10-14 00:00:00 | 2008-01-16 00:00:00 | None | None | 2008-07-16 00:00:00 | 2009-01-16 00:00:00 | None | 2010-10-29 00:00:00 | None | None | 2011-01-18 00:00:00 | None | 2012-01-23 00:00:00 | 2011-07-12 00:00:00 | None | 2014-03-21 00:00:00 | 2014-03-07 00:00:00 | 2014-01-23 00:00:00 | None | None | None | 2013-01-18 00:00:00 | None | 2014-05-02 00:00:00 | 2014-05-02 00:00:00 | 2014-05-17 00:00:00 | 2014-04-21 00:00:00 | 2014-04-21 00:00:00 | 2014-04-08 00:00:00 | None | None | 2018-09-12 00:00:00 | None | None | 2020-01-02 00:00:00 | 2019-07-08 00:00:00 | 2018-06-07 00:00:00 | 2016-01-12 00:00:00 | None | None | 2016-07-15 00:00:00 | 2016-09-13 00:00:00 | 2016-09-22 00:00:00 | 2016-10-06 00:00:00 | 2016-10-18 00:00:00 | 2016-10-20 00:00:00 | 2016-10-07 00:00:00 | 2016-11-07 00:00:00 | 2016-11-07 00:00:00 | 2017-01-13 00:00:00 | None | 2017-07-21 00:00:00 | 2018-08-14 00:00:00 | 2018-07-26 00:00:00 | None | 2018-09-24 00:00:00 | 2020-07-13 00:00:00 | 2020-07-21 00:00:00 | None | 2018-10-30 00:00:00 | 2018-01-21 00:00:00 | None | 2018-05-24 00:00:00 | 2018-09-20 00:00:00 | 2018-10-09 00:00:00 | 2018-08-22 00:00:00 | None | None | None | 2019-01-08 00:00:00 | 2021-01-13 00:00:00 | None | 2022-07-09 00:00:00 | None | 2022-01-12 00:00:00 | 2021-07-13 00:00:00 | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_type | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 22001 | None | None | None | 22001 | None | 22001 | None | None | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | None | 22001 | None | None | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | None | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | None | None | None | 22001 | 22001 | None | 22001 | None | 22001 | 22001 | None | None |
filer_id | 1009365 | |
---|---|---|
filer_type | 10 | |
active | Y | |
race | 0 | |
session_id | 1981 | |
category | 0 | |
category_type | 40502 | |
sub_category | 0 | |
effect_dt | 1990-12-01 00:00:00 | |
sub_category_type | 0 | |
election_type | 0 | |
sub_category_a | None | |
nyq_dt | None | |
party_cd | None | |
county_cd | 18042 | |
district_cd | None |
filer_id | 1009365 | |
---|---|---|
xref_id | 482268 | |
effect_dt | 1999-12-07 00:00:00 | |
migration_source | IDENTFIX |
xref_filer_id | 482268 | 482268 | 482268 | 482268 | 482268 | 482268 | 482268 | 482268 | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | ||||||||
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 | ||||||||
status | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ||||||||
effect_dt | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | ||||||||
naml | CALIFORNIA-AMERICAN WATER COMPANY | CALIFORNIA-AMERICAN WATER COMPANY | CALIFORNIA-AMERICAN WATER COMPANY | CALIFORNIA-AMERICAN WATER COMPANY | CALIFORNIA AMERICAN WATER, A WHOLLY-OWNED SUBSIDIARY OF AMERICAN WATER WORKS CO. | CALIFORNIA AMERICAN WATER, A WHOLLY-OWNED SUBSIDIARY OF AMERICAN WATER WORKS CO. | CALIFORNIA AMERICAN WATER, A WHOLLY-OWNED SUBSIDIARY OF AMERICAN WATER WORKS CO. | CALIFORNIA AMERICAN WATER, A WHOLLY-OWNED SUBSIDIARY OF AMERICAN WATER WORKS CO. | ||||||||
namf | None | None | None | None | None | None | None | None | ||||||||
namt | None | None | None | None | None | None | None | None | ||||||||
nams | None | None | None | None | None | None | None | None | ||||||||
adr1 | None | None | None | None | None | None | None | None | ||||||||
adr2 | None | None | None | None | None | None | None | None | ||||||||
city | CHULA VISTA | CHULA VISTA | CORONADO | SAN DIEGO | CHULA VISTA | CHULA VISTA | CORONADO | SAN DIEGO | ||||||||
st | CA | CA | CA | CA | CA | CA | CA | CA | ||||||||
zip4 | 919140000 | 919100000 | 921180000 | 92101 | 919140000 | 919100000 | 921180000 | 92101 | ||||||||
phon | 6196562400 | 6194097700 | 6194357402 | 6194464763 | 6196562400 | 6194097700 | 6194357402 | 6194464763 | ||||||||
fax | None | None | None | None | None | None | None | None | ||||||||
None | None | None | None | None | None | None | None |
filer_id | 1009365 |
---|
filer_id | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | 1009365 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 683495_0.cal | 713434_0.cal | 769936_0.cal | 785459_0.cal | 185101.cal | 769936_1.cal | 785459_1.cal | 187541.cal | 187493.cal | 802980_0.cal | 881050_0.cal | 908633_0.cal | 1080638_0.cal | 1395755_0.cal | 1345437_0.cal | 1310888_0.cal | 1846850_0.cal | 1846852_0.cal | 1851234_0.cal | 494618.cal | 494653.cal | 1839786_0.cal | 1831253_0.cal | 1837087_0.cal | 1783368_0.cal | 1538862_0.cal | 1568289_0.cal | 1839953_0.cal | 1826645_0.cal | 1818137_0.cal | 1605804_0.cal | 66064.cal | 1632569_0.cal | 1856907_0.cal | 1870496_0.cal | 1855526_0.cal | 1981251_0.cal | 2058753_0.cal | 2005874_0.cal | 2085924_0.cal | 2080151_0.cal | 2086631_0.cal | 1897980_0.cal | 2090896_0.cal | 2092437_0.cal | 2105869_0.cal | 2105876_0.cal | 1899150_0.cal | 2076278_0.cal | 1935528_0.cal | 2291167_0.cal | 2253059_1.cal | 2294995_0.cal | 2316784_0.cal | 2253059_0.cal | 2293884_0.cal | 2303842_0.cal | 2285564_0.cal | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
received_date | 2000-11-01 00:00:00 | 2001-01-23 00:00:00 | 2001-07-25 00:00:00 | 2001-10-09 00:00:00 | 2002-01-02 00:00:00 | 2002-01-02 00:00:00 | 2002-01-02 00:00:00 | 2002-01-02 00:00:00 | 2002-01-02 00:00:00 | 2002-01-02 00:00:00 | 2002-10-28 00:00:00 | 2003-01-29 00:00:00 | 2005-01-31 00:00:00 | 2009-01-30 00:00:00 | 2008-07-23 00:00:00 | 2008-01-31 00:00:00 | 2014-05-02 00:00:00 | 2014-05-02 00:00:00 | 2014-05-17 00:00:00 | 2013-01-29 00:00:00 | 2013-01-29 00:00:00 | 2014-04-21 00:00:00 | 2014-03-21 00:00:00 | 2014-04-08 00:00:00 | 2013-07-31 00:00:00 | 2010-10-29 00:00:00 | 2011-01-27 00:00:00 | 2014-04-21 00:00:00 | 2014-03-07 00:00:00 | 2014-01-31 00:00:00 | 2011-07-28 00:00:00 | 2012-01-30 00:00:00 | 2012-01-26 00:00:00 | 2014-05-30 00:00:00 | 2014-07-30 00:00:00 | 2014-05-28 00:00:00 | 2015-07-30 00:00:00 | 2016-07-26 00:00:00 | 2016-01-24 00:00:00 | 2016-10-06 00:00:00 | 2016-09-22 00:00:00 | 2016-10-07 00:00:00 | 2014-10-14 00:00:00 | 2016-10-18 00:00:00 | 2016-10-20 00:00:00 | 2016-11-07 00:00:00 | 2016-11-07 00:00:00 | 2014-10-16 00:00:00 | 2016-09-13 00:00:00 | 2015-01-31 00:00:00 | 2018-09-12 00:00:00 | 2018-06-07 00:00:00 | 2018-09-24 00:00:00 | 2018-10-30 00:00:00 | 2018-05-24 00:00:00 | 2018-09-20 00:00:00 | 2018-10-09 00:00:00 | 2018-08-22 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_directory | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/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 | /cafiler/disclose/ca99/cal | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_id | 683495 | 713434 | 769936 | 785459 | None | 769936 | 785459 | None | None | 802980 | 881050 | 908633 | 1080638 | 1395755 | 1345437 | 1310888 | 1846850 | 1846852 | 1851234 | None | None | 1839786 | 1831253 | 1837087 | 1783368 | 1538862 | 1568289 | 1839953 | 1826645 | 1818137 | 1605804 | None | 1632569 | 1856907 | 1870496 | 1855526 | 1981251 | 2058753 | 2005874 | 2085924 | 2080151 | 2086631 | 1897980 | 2090896 | 2092437 | 2105869 | 2105876 | 1899150 | 2076278 | 1935528 | 2291167 | 2253059 | 2294995 | 2316784 | 2253059 | 2293884 | 2303842 | 2285564 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F497 | F461 | F461 | F461 | None | F461 | F461 | None | None | F461 | F497 | F461 | F461 | F461 | F461 | F461 | F497 | F497 | F497 | None | None | F497 | F497 | F497 | F461 | F497 | F461 | F497 | F497 | F461 | F461 | None | F461 | F497 | F461 | F497 | F461 | F461 | F461 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F461 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
receive_comment | Filing accepted | Filing accepted, but with warnings | Filing accepted | Filing accepted | Filing did not pass validation | Filing accepted | Filing accepted | Filing did not pass validation | Filing did not pass validation | Filing accepted | Filing accepted | Filing accepted, but with warnings | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted |