filer_id | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1086343 | 1086344 | 2154949 | 2226186 | 2464907 | 2464906 | 2365136 | 2365137 | 2384679 | 2384678 | ||||||||||
effect_dt | 1998-05-01 00:00:00 | 1998-05-01 00:00:00 | 2008-10-09 00:00:00 | 2012-02-02 00:00:00 | 2018-08-31 00:00:00 | 2018-08-31 00:00:00 | 2015-07-24 00:00:00 | 2015-07-24 00:00:00 | 2016-01-21 00:00:00 | 2016-01-21 00:00:00 | ||||||||||
add_type | 7051 | 7051 | 7082 | 7051 | 7082 | 7051 | 7051 | 7082 | 7082 | 7051 | ||||||||||
session_id | 1997 | 1997 | 2007 | 2011 | 2017 | 2017 | 2015 | 2015 | 2015 | 2015 |
filer_id | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 411122 | 411123 | 411125 | 411126 | 411127 | 411128 | 411129 | 411130 | 411132 | 411124 | 411131 | 580851 | 595988 | 586316 | 643311 | 676469 | 698625 | 691723 | 691727 | 740219 | 724610 | 783555 | 806399 | 857254 | 870103 | 872659 | 917016 | 883017 | 951661 | 857254 | 917016 | 991523 | 1014837 | 1036658 | 1096852 | 1121521 | 1096852 | 1152855 | 1198056 | 1254236 | 1290349 | 1291368 | 1774510 | 1976022 | 1865568 | 1779993 | 1777768 | 1938755 | 1950565 | 1326659 | 1366172 | 1326659 | 1366088 | 1363117 | 1363203 | 1363092 | 1380579 | 1406326 | 1363203 | 1425858 | 1453613 | 1453614 | 1453615 | 1469213 | 1506688 | 1506656 | 1506682 | 1513789 | 1513791 | 1513793 | 1573648 | 1573650 | 1573651 | 1584998 | 1584999 | 1585000 | 1634627 | 1639351 | 1639432 | 1642455 | 1363203 | 1646451 | 1649303 | 1639432 | 1636881 | 1645497 | 1673542 | 1677685 | 1821413 | 1814263 | 1704838 | 1863527 | 1736598 | 1729465 | 1979301 | 1977807 | 2265072 | 2328448 | 2392673 | 2330429 | 2330443 | 2330447 | 2498605 | 2261514 | 1363203 | 2328455 | 2261513 | 2347127 | 2004863 | 1363203 | 2006872 | 2009140 | 2066334 | 2056152 | 2128889 | 2159512 | 2328461 | 2362060 | 2451768 | 2290674 | 2290269 | 2290271 | 2290273 | 2441714 | 2401257 | 2477115 | 2548791 | 2615195 | 2643054 | 2592634 | 2566164 | 1363203 | 2592634 | 2615195 | 2655079 | 2699139 | 2548791 | 2655079 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 154 | 153 | 155 | 155 | 156 | 156 | 157 | 159 | 160 | 154 | 159 | None | None | None | None | None | None | None | None | None | None | None | None | None | 157 | None | None | None | None | None | None | None | 165 | None | None | None | None | None | None | None | 189 | None | None | 221 | None | None | 213 | 219 | None | 191 | None | 191 | None | 195 | 196 | 193 | None | 196 | 197 | None | 197 | 198 | 199 | 200 | 202 | 201 | 201 | None | None | None | 203 | 204 | 204 | None | None | None | 205 | None | None | None | 209 | None | None | None | 207 | 209 | 209 | None | None | 215 | None | 217 | None | 211 | None | None | 233 | 229 | 237 | None | None | None | None | 231 | 234 | 231 | 229 | 235 | 223 | 225 | None | None | None | 225 | 227 | None | 233 | None | None | None | None | None | None | 239 | None | 241 | 243 | None | 247 | 245 | None | 248 | 245 | None | None | 249 | 243 | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F410 | F420 | F405 | F420 | F420 | F420 | F420 | F405 | F405 | F420 | F420 | F460 | F460 | F460 | F460 | F410 | F410 | F460 | F460 | F496 | F460 | F460 | F460 | F460 | F666 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F666 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F410 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F410 | F460 | F410 | F460 | F410 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F460 | F450 | F460 | F450 | F410 | F410 | F460 | F410 | F450 | F460 | F460 | F460 | F460 | F460 | F460 | F888 | F460 | F460 | F460 | F460 | F410 | F425 | F460 | F460 | F460 | F460 | F460 | F450 | F450 | F410 | F460 | F450 | F460 | F460 | F410 | F460 | F410 | F450 | F450 | F450 | F450 | F460 | F460 | F460 | F410 | F450 | F425 | F450 | F460 | F460 | F450 | F460 | F450 | F460 | F450 | F460 | F410 | F450 | F450 | F460 | F450 | F460 | F460 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 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 | 2 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 1 | 1 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1998-05-01 00:00:00 | 1998-05-26 00:00:00 | 1998-08-01 00:00:00 | 1998-10-05 00:00:00 | 1998-10-24 00:00:00 | 1999-02-01 00:00:00 | 1999-08-02 00:00:00 | 1999-08-02 00:00:00 | 1999-10-26 00:00:00 | 1998-07-31 00:00:00 | 1999-10-15 00:00:00 | 2000-01-10 00:00:00 | 2000-02-28 00:00:00 | 2000-01-27 00:00:00 | 2000-07-26 00:00:00 | 2000-10-10 00:00:00 | 2000-11-16 00:00:00 | 2000-11-17 00:00:00 | 2000-11-10 00:00:00 | 2000-11-16 00:00:00 | 2001-01-31 00:00:00 | 2001-07-31 00:00:00 | 2002-01-10 00:00:00 | 2002-07-31 00:00:00 | 2002-10-01 00:00:00 | 2002-10-07 00:00:00 | 2003-01-31 00:00:00 | 2002-10-24 00:00:00 | 2003-07-31 00:00:00 | 2003-09-10 00:00:00 | 2003-09-10 00:00:00 | 2004-01-29 00:00:00 | 2004-04-23 00:00:00 | 2004-08-02 00:00:00 | 2005-03-08 00:00:00 | 2005-08-03 00:00:00 | 2005-04-08 00:00:00 | 2006-01-31 00:00:00 | 2006-07-31 00:00:00 | 2007-01-31 00:00:00 | 2007-08-29 00:00:00 | 2007-08-29 00:00:00 | 2013-07-03 00:00:00 | 2015-07-22 00:00:00 | 2014-07-18 00:00:00 | 2013-07-26 00:00:00 | 2013-07-24 00:00:00 | 2015-02-06 00:00:00 | 2015-02-12 00:00:00 | 2008-04-24 00:00:00 | 2008-10-07 00:00:00 | 2008-07-30 00:00:00 | 2008-10-07 00:00:00 | 2008-10-06 00:00:00 | 2008-10-06 00:00:00 | 2008-10-06 00:00:00 | 2008-10-09 00:00:00 | 2009-03-11 00:00:00 | 2009-03-11 00:00:00 | 2009-03-11 00:00:00 | 2009-11-04 00:00:00 | 2009-11-04 00:00:00 | 2009-11-04 00:00:00 | 2010-02-11 00:00:00 | 2010-07-30 00:00:00 | 2010-07-30 00:00:00 | 2010-07-30 00:00:00 | 2010-08-02 00:00:00 | 2010-08-02 00:00:00 | 2010-08-02 00:00:00 | 2011-02-03 00:00:00 | 2011-02-03 00:00:00 | 2011-02-03 00:00:00 | 2011-04-01 00:00:00 | 2011-04-01 00:00:00 | 2011-04-01 00:00:00 | 2012-01-30 00:00:00 | 2012-01-31 00:00:00 | 2012-01-31 00:00:00 | 2012-02-02 00:00:00 | 2012-03-16 00:00:00 | 2012-03-20 00:00:00 | 2012-03-20 00:00:00 | 2012-01-31 00:00:00 | 2012-01-31 00:00:00 | 2012-03-16 00:00:00 | 2012-07-23 00:00:00 | 2012-07-24 00:00:00 | 2014-01-29 00:00:00 | 2014-01-28 00:00:00 | 2012-04-19 00:00:00 | 2014-07-16 00:00:00 | 2013-01-23 00:00:00 | 2013-01-21 00:00:00 | 2015-07-24 00:00:00 | 2015-07-24 00:00:00 | 2018-07-17 00:00:00 | 2018-12-18 00:00:00 | 2019-07-24 00:00:00 | 2018-12-19 00:00:00 | 2018-12-19 00:00:00 | 2018-12-19 00:00:00 | 2020-07-30 00:00:00 | 2018-06-25 00:00:00 | 2018-06-25 00:00:00 | 2018-12-18 00:00:00 | 2018-06-25 00:00:00 | 2019-01-31 00:00:00 | 2016-01-19 00:00:00 | 2016-01-19 00:00:00 | 2016-01-21 00:00:00 | 2016-01-21 00:00:00 | 2016-07-21 00:00:00 | 2016-07-19 00:00:00 | 2017-01-31 00:00:00 | 2017-01-31 00:00:00 | 2018-12-18 00:00:00 | 2019-01-31 00:00:00 | 2020-01-30 00:00:00 | 2018-08-31 00:00:00 | 2018-08-29 00:00:00 | 2018-08-29 00:00:00 | 2018-08-29 00:00:00 | 2020-01-31 00:00:00 | 2019-07-29 00:00:00 | 2020-07-07 00:00:00 | 2021-01-28 00:00:00 | 2021-07-15 00:00:00 | 2022-01-31 00:00:00 | 2021-07-13 00:00:00 | 2021-02-01 00:00:00 | 2021-11-16 00:00:00 | 2021-11-02 00:00:00 | 2021-11-08 00:00:00 | 2022-01-31 00:00:00 | 2022-07-19 00:00:00 | 2022-01-06 00:00:00 | 2022-01-10 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10005 | 10002 | 10002 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10006 | 10006 | 10005 | 10005 | 10005 | 10005 | 10005 | 10006 | 10005 | 10005 | 10005 | 10001 | 10005 | 10006 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10002 | 10005 | 10001 | 10001 | 10001 | 10002 | 10001 | 10002 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10005 | 10005 | 10006 | 10002 | 10005 | 10006 | 10006 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10006 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10005 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10002 | 10005 | 10006 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10005 | 10006 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10005 | 10002 | 10002 | 10006 | 10005 | 10001 | 10002 | 10006 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11002 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11002 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1997 | 1997 | 1997 | 1997 | 1997 | 1997 | 1999 | 1999 | 1999 | 1997 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 2001 | 2001 | 2001 | 1999 | 2001 | 2001 | 2001 | 2003 | 2001 | 2001 | 2003 | 2001 | 2003 | 2003 | 2005 | 2003 | 2005 | 2005 | 2005 | 2007 | 2007 | 2013 | 2015 | 2013 | 2013 | 2013 | 2013 | 2013 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2009 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2013 | 2011 | 2013 | 2011 | 2011 | 2015 | 2015 | 2017 | 2017 | 2019 | 2017 | 2017 | 2017 | 2019 | 2017 | 2017 | 2017 | 2017 | 2017 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2019 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2019 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2019 | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | * | * | * | * | * | * | * | * | GPEREZ | CFLAGG | JLEHMAN | TTHAM | TTHAM | DHORRELL | DHORRELL | GGILMORE | TWALLS | GPEREZ | GPEREZ | DBARRICK | PROBERTS | DBARRICK | DBARRICK | DBARRICK | GGILMORE | KLARRY | KLARRY | EMCENTEE | PROBERTS | GKURIMOT | DHORRELL | GKURIMOT | JWHITE | EMCENTEE | SARRIAGA | DHORRELL | DHORRELL | DHORRELL | TRAMON | MDIGRAZIA | MPACHECO | MDIGRAZIA | MDIGRAZIA | MDIGRAZIA | RGEREMIA | NWALKER | DHORRELL | * | NWALKER | * | * | DHORRELL | GKURIMOT | MMORENO | * | MMORENO | * | * | * | * | SMCCONNAN | CPON | CPON | CPON | CPON | SMCCONNAN | MMORENO | CPON | MMORENO | MMORENO | CPON | MMORENO | SMCCONNAN | MDIGRAZIA | SMCCONNAN | TRAMON | CAFILER | MDIGRAZIA | TRAMON | MPACHECO | MDIGRAZIA | MDIGRAZIA | CPON | CPON | MPACHECO | CAFILER | NLANDERS | CAFILER | MPACHECO | MDIGRAZIA | MDIGRAZIA | TRAMON | HSTOVALL | JFRONEFIELD | HCOURSEY | JFRONEFIELD | AROJAS | AROJAS | IMEDINA | CPON | TRAMON | KBANH | CPON | SBROWN | SARRIAGA | TRAMON | MPACHECO | TRAMON | CPON | CPON | CPON | AXIONG | KBANH | SBROWN | VUKSTINA | TRAMON | CPON | HSTOVALL | CPON | CAFILER | HCOURSEY | IMEDINA | DCODY | IMEDINA | CAFILER | IMEDINA | DCODY | CAFILER | CAFILER | JMAVES | JMAVES | CAFILER | CAFILER | JMAVES | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | None | 1998-03-17 00:00:00 | None | 1998-07-01 00:00:00 | 1998-10-01 00:00:00 | 1998-10-18 00:00:00 | 1999-01-01 00:00:00 | None | None | 1998-05-17 00:00:00 | 1999-07-01 00:00:00 | 1999-10-01 00:00:00 | 2000-01-23 00:00:00 | 2000-01-01 00:00:00 | 2000-02-20 00:00:00 | None | None | 2000-07-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-16 00:00:00 | 2000-10-22 00:00:00 | 2001-01-01 00:00:00 | 2001-07-01 00:00:00 | 2002-01-01 00:00:00 | 1999-01-01 00:00:00 | 2002-07-01 00:00:00 | 2002-10-20 00:00:00 | 2002-10-01 00:00:00 | 2003-01-01 00:00:00 | 2002-01-01 00:00:00 | 2002-10-20 00:00:00 | 2003-07-01 00:00:00 | 2001-01-01 00:00:00 | 2004-01-01 00:00:00 | 2004-07-01 00:00:00 | 2005-01-01 00:00:00 | 2004-07-01 00:00:00 | 2005-07-01 00:00:00 | 2006-01-01 00:00:00 | 2006-07-01 00:00:00 | 2007-01-01 00:00:00 | 2007-01-01 00:00:00 | None | 2015-01-01 00:00:00 | 2014-01-01 00:00:00 | 2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 2014-07-01 00:00:00 | 2014-07-01 00:00:00 | 2007-07-01 00:00:00 | 2008-01-30 00:00:00 | 2007-07-01 00:00:00 | 2008-07-01 00:00:00 | 2008-07-01 00:00:00 | 2008-10-06 00:00:00 | 2008-01-30 00:00:00 | None | 2008-10-01 00:00:00 | 2009-03-11 00:00:00 | 2008-10-01 00:00:00 | 2009-01-01 00:00:00 | 2009-04-01 00:00:00 | 2009-07-01 00:00:00 | 2009-10-01 00:00:00 | 2010-05-23 00:00:00 | 2010-01-01 00:00:00 | 2010-03-18 00:00:00 | 2010-01-01 00:00:00 | 2010-03-18 00:00:00 | 2010-05-23 00:00:00 | 2010-07-01 00:00:00 | 2010-10-01 00:00:00 | 2010-10-17 00:00:00 | 2010-10-17 00:00:00 | 2010-10-01 00:00:00 | 2010-07-01 00:00:00 | 2011-01-01 00:00:00 | 2011-07-01 00:00:00 | 2011-01-01 00:00:00 | None | 2012-03-16 00:00:00 | 2012-01-01 00:00:00 | None | 2011-01-01 00:00:00 | 2011-07-01 00:00:00 | 2012-01-01 00:00:00 | 2012-03-18 00:00:00 | 2012-03-18 00:00:00 | 2013-07-01 00:00:00 | 2013-07-01 00:00:00 | None | 2014-01-01 00:00:00 | 2012-07-01 00:00:00 | 2012-07-01 00:00:00 | 2015-01-01 00:00:00 | None | 2018-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2017-01-01 00:00:00 | 2018-01-01 00:00:00 | 2017-07-01 00:00:00 | 2020-01-01 00:00:00 | 2017-07-01 00:00:00 | 2018-06-25 00:00:00 | 2017-07-01 00:00:00 | 2017-01-01 00:00:00 | 2018-07-01 00:00:00 | 2015-07-01 00:00:00 | 2016-01-19 00:00:00 | 2015-07-01 00:00:00 | None | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-07-01 00:00:00 | 2016-07-01 00:00:00 | 2018-01-01 00:00:00 | 2018-07-01 00:00:00 | 2019-07-01 00:00:00 | None | 2017-07-01 00:00:00 | 2018-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-07-01 00:00:00 | 2019-01-01 00:00:00 | 2020-01-01 00:00:00 | 2020-07-01 00:00:00 | 2021-01-01 00:00:00 | 2021-07-01 00:00:00 | 2021-01-01 00:00:00 | 2020-07-01 00:00:00 | 2021-11-16 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-07-01 00:00:00 | 2022-01-01 00:00:00 | 2020-07-01 00:00:00 | 2021-07-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | None | 1998-05-16 00:00:00 | None | 1998-09-30 00:00:00 | 1998-10-17 00:00:00 | 1998-12-31 00:00:00 | 1999-06-30 00:00:00 | None | None | 1998-06-30 00:00:00 | 1999-09-30 00:00:00 | 1999-12-31 00:00:00 | 2000-02-19 00:00:00 | 2000-01-22 00:00:00 | 2000-06-30 00:00:00 | None | None | 2000-09-30 00:00:00 | 2000-10-21 00:00:00 | 2000-11-16 00:00:00 | 2000-12-31 00:00:00 | 2001-06-30 00:00:00 | 2001-12-31 00:00:00 | 2002-06-30 00:00:00 | 2000-12-31 00:00:00 | 2002-09-30 00:00:00 | 2002-12-31 00:00:00 | 2002-10-19 00:00:00 | 2003-06-30 00:00:00 | 2002-06-30 00:00:00 | 2002-12-31 00:00:00 | 2003-12-31 00:00:00 | 2002-12-31 00:00:00 | 2004-06-30 00:00:00 | 2004-12-31 00:00:00 | 2005-06-30 00:00:00 | 2004-12-31 00:00:00 | 2005-12-31 00:00:00 | 2006-06-30 00:00:00 | 2006-12-31 00:00:00 | 2007-06-30 00:00:00 | 2007-06-30 00:00:00 | None | 2015-06-30 00:00:00 | 2014-06-30 00:00:00 | 2013-06-30 00:00:00 | 2013-06-30 00:00:00 | 2014-12-31 00:00:00 | 2014-12-31 00:00:00 | 2007-12-31 00:00:00 | 2008-06-30 00:00:00 | 2007-12-31 00:00:00 | 2008-09-30 00:00:00 | 2008-09-30 00:00:00 | 2008-10-06 00:00:00 | 2008-06-30 00:00:00 | None | 2008-12-31 00:00:00 | 2009-03-11 00:00:00 | 2008-12-31 00:00:00 | 2009-03-31 00:00:00 | 2009-06-30 00:00:00 | 2009-09-30 00:00:00 | 2009-12-31 00:00:00 | 2010-06-30 00:00:00 | 2010-03-17 00:00:00 | 2010-05-22 00:00:00 | 2010-03-17 00:00:00 | 2010-05-22 00:00:00 | 2010-06-30 00:00:00 | 2010-09-30 00:00:00 | 2010-10-16 00:00:00 | 2010-12-31 00:00:00 | 2010-12-31 00:00:00 | 2010-10-16 00:00:00 | 2010-09-30 00:00:00 | 2011-06-30 00:00:00 | 2011-12-31 00:00:00 | 2011-06-30 00:00:00 | None | 2012-03-16 00:00:00 | 2012-03-17 00:00:00 | None | 2011-06-30 00:00:00 | 2011-12-31 00:00:00 | 2012-03-17 00:00:00 | 2012-06-30 00:00:00 | 2012-06-30 00:00:00 | 2013-12-31 00:00:00 | 2013-12-31 00:00:00 | None | 2014-06-30 00:00:00 | 2012-12-31 00:00:00 | 2012-12-31 00:00:00 | 2015-06-30 00:00:00 | None | 2018-06-30 00:00:00 | 2017-06-30 00:00:00 | 2019-06-30 00:00:00 | 2017-06-30 00:00:00 | 2018-06-30 00:00:00 | 2017-12-31 00:00:00 | 2020-06-30 00:00:00 | 2017-12-31 00:00:00 | 2018-06-25 00:00:00 | 2017-12-31 00:00:00 | 2017-06-30 00:00:00 | 2018-12-31 00:00:00 | 2015-12-31 00:00:00 | 2016-01-19 00:00:00 | 2015-12-31 00:00:00 | None | 2016-06-30 00:00:00 | 2016-06-30 00:00:00 | 2016-12-31 00:00:00 | 2016-12-31 00:00:00 | 2018-06-30 00:00:00 | 2018-12-31 00:00:00 | 2019-12-31 00:00:00 | None | 2017-12-31 00:00:00 | 2018-06-30 00:00:00 | 2017-06-30 00:00:00 | 2019-12-31 00:00:00 | 2019-06-30 00:00:00 | 2020-06-30 00:00:00 | 2020-12-31 00:00:00 | 2021-06-30 00:00:00 | 2021-12-31 00:00:00 | 2021-06-30 00:00:00 | 2020-12-31 00:00:00 | 2021-11-16 00:00:00 | 2021-06-30 00:00:00 | 2021-06-30 00:00:00 | 2021-12-31 00:00:00 | 2022-06-30 00:00:00 | 2020-12-31 00:00:00 | 2021-12-31 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 2007-08-29 00:00:00 | None | None | 2015-07-22 00:00:00 | None | None | 2013-07-24 00:00:00 | 2015-02-06 00:00:00 | None | 2008-04-24 00:00:00 | None | 2008-07-30 00:00:00 | None | 2008-10-06 00:00:00 | None | 2008-10-06 00:00:00 | None | 2009-03-11 00:00:00 | None | None | 2009-11-04 00:00:00 | 2009-11-04 00:00:00 | 2009-11-04 00:00:00 | 2010-02-11 00:00:00 | 2010-07-30 00:00:00 | 2010-07-30 00:00:00 | 2010-07-30 00:00:00 | None | None | None | 2011-02-03 00:00:00 | 2011-02-03 00:00:00 | 2011-02-03 00:00:00 | None | None | None | 2012-01-30 00:00:00 | None | None | None | None | None | None | None | 2012-01-31 00:00:00 | 2012-03-16 00:00:00 | 2012-07-23 00:00:00 | None | None | 2014-01-28 00:00:00 | None | 2014-07-16 00:00:00 | None | 2013-01-21 00:00:00 | None | None | 2018-07-17 00:00:00 | 2018-12-18 00:00:00 | 2019-07-24 00:00:00 | None | None | None | None | 2018-06-25 00:00:00 | None | 2018-12-18 00:00:00 | 2018-06-25 00:00:00 | 2019-01-31 00:00:00 | 2016-01-19 00:00:00 | None | None | None | None | 2016-07-19 00:00:00 | 2017-01-31 00:00:00 | None | 2018-12-18 00:00:00 | None | None | None | None | None | None | 2020-01-31 00:00:00 | None | 2020-07-07 00:00:00 | 2021-01-28 00:00:00 | None | 2022-01-31 00:00:00 | 2021-07-13 00:00:00 | None | None | 2021-11-02 00:00:00 | None | None | 2022-07-19 00:00:00 | 2022-01-06 00:00:00 | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_type | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 22006 | None | None | 22006 | None | None | 22006 | 22006 | None | 22006 | None | 22006 | None | 22006 | 22006 | 22006 | None | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | None | None | 22006 | 22006 | 22006 | None | None | None | 22006 | None | None | None | 22006 | None | None | None | 22006 | 22006 | 22006 | None | None | 22006 | None | 22006 | None | 22006 | None | None | 22006 | 22006 | 22006 | None | None | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | None | None | 22006 | 22006 | None | 22006 | None | None | None | None | None | None | 22006 | None | 22006 | 22006 | None | 22006 | 22006 | None | 22006 | 22006 | None | None | 22006 | 22006 | None |
filer_id | 1073309 | 1073309 | 1073309 | |||
---|---|---|---|---|---|---|
filer_type | 16 | 16 | 16 | |||
active | Y | Y | Y | |||
race | 0 | 0 | 0 | |||
session_id | 1997 | 2015 | 2017 | |||
category | 0 | 0 | 0 | |||
category_type | 40502 | 40502 | 40502 | |||
sub_category | 40103 | 40103 | 40103 | |||
effect_dt | 1998-05-01 00:00:00 | 2015-07-24 00:00:00 | 2018-08-31 00:00:00 | |||
sub_category_type | 0 | 0 | 0 | |||
election_type | 0 | 0 | 0 | |||
sub_category_a | S | S | S | |||
nyq_dt | 1998-04-25 00:00:00 | 1998-04-25 00:00:00 | 1998-04-25 00:00:00 | |||
party_cd | None | None | None | |||
county_cd | 18004 | 18037 | 18053 | |||
district_cd | None | None | None |
filer_id | 1073309 | |
---|---|---|
xref_id | 981243 | |
effect_dt | 1999-12-07 00:00:00 | |
migration_source | IDENTFIX |
xref_filer_id | 981243 | 981243 | 981243 | 981243 | 981243 | 981243 | 981243 | 981243 | 981243 | 981243 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | ||||||||||
filer_type | 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 | ||||||||||
effect_dt | 2018-08-31 00:00:00 | 2018-08-31 00:00:00 | 2018-08-31 00:00:00 | 2018-08-31 00:00:00 | 2018-08-31 00:00:00 | 2018-08-31 00:00:00 | 2018-08-31 00:00:00 | 2018-08-31 00:00:00 | 2018-08-31 00:00:00 | 2018-08-31 00:00:00 | ||||||||||
naml | AMERICAN SUBCONTRACTORS ASSOCIATION OF CALIFORNIA POLITICAL ACTION COMMITTEE (ASAC PAC) | AMERICAN SUBCONTRACTORS ASSOCIATION OF CALIFORNIA POLITICAL ACTION COMMITTEE (ASAC PAC) | AMERICAN SUBCONTRACTORS ASSOCIATION OF CALIFORNIA POLITICAL ACTION COMMITTEE (ASAC PAC) | AMERICAN SUBCONTRACTORS ASSOCIATION OF CALIFORNIA POLITICAL ACTION COMMITTEE (ASAC PAC) | AMERICAN SUBCONTRACTORS ASSOCIATION OF CALIFORNIA POLITICAL ACTION COMMITTEE (ASAC PAC) | AMERICAN SUBCONTRACTORS ASSOCIATION OF CALIFORNIA POLITICAL ACTION COMMITTEE (ASAC PAC) | AMERICAN SUBCONTRACTORS ASSOCIATION OF CALIFORNIA POLITICAL ACTION COMMITTEE (ASAC PAC) | AMERICAN SUBCONTRACTORS ASSOCIATION OF CALIFORNIA POLITICAL ACTION COMMITTEE (ASAC PAC) | AMERICAN SUBCONTRACTORS ASSOCIATION OF CALIFORNIA POLITICAL ACTION COMMITTEE (ASAC PAC) | AMERICAN SUBCONTRACTORS ASSOCIATION OF CALIFORNIA POLITICAL ACTION COMMITTEE (ASAC PAC) | ||||||||||
namf | None | None | None | None | None | None | None | None | None | None | ||||||||||
namt | None | None | None | None | None | None | None | None | None | None | ||||||||||
nams | None | None | None | None | None | None | None | None | None | None | ||||||||||
adr1 | None | None | None | None | None | None | None | None | None | None | ||||||||||
adr2 | None | None | None | None | None | None | None | None | None | None | ||||||||||
city | DANVILLE | SACRAMENTO | SACRAMENTO | ZAMORA | AUBURN | SACRAMENTO | AUBURN | SAN RAFAEL | SANTA ROSA | SANTA ROSA | ||||||||||
st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | ||||||||||
zip4 | 945260000 | 958292867 | 958292867 | 95698 | 95602 | 958292867 | 95602 | 94901 | 95407 | 95407 | ||||||||||
phon | 9257430575 | 8883102722 | 8883102722 | 8883102722 | 8883102722 | 6288884329 | 6288884329 | 6288884329 | ||||||||||||
fax | None | None | None | 5306622865 | 5306622865 | |||||||||||||||
None | None | None | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | None |
filer_id | 1073309 |
---|
filer_id | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | 1073309 | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 2128889_0.cal | 2056152_0.cal | 1363203_3.cal | 2265072_0.cal | 2261514_0.cal | 2261513_0.cal | ||||||
received_date | 2017-01-31 00:00:00 | 2016-07-19 00:00:00 | 2016-01-19 00:00:00 | 2018-07-17 00:00:00 | 2018-06-25 00:00:00 | 2018-06-25 00:00:00 | ||||||
filing_directory | /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 | 2128889 | 2056152 | 1363203 | 2265072 | 2261514 | 2261513 | ||||||
form_id | F450 | F450 | F410 | F425 | F450 | F450 | ||||||
receive_comment | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted |