filer_id | 1011153 | 1011153 | ||
---|---|---|---|---|
adrid | 1010480 | 2199318 | ||
effect_dt | 2008-01-31 00:00:00 | 2010-08-02 00:00:00 | ||
add_type | 7051 | 7051 | ||
session_id | 2007 | 2009 |
filer_id | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 68928 | 68929 | 68930 | 68931 | 68933 | 68934 | 68935 | 68936 | 204085 | 204086 | 204087 | 204088 | 68932 | 585283 | 598472 | 600152 | 601634 | 666100 | 645121 | 772441 | 792529 | 814123 | 825221 | 834792 | 826332 | 828648 | 829333 | 858468 | 857083 | 825221 | 915267 | 912526 | 954404 | 947994 | 1007149 | 990915 | 1049851 | 1049226 | 1051662 | 1058216 | 1094778 | 1079840 | 1116991 | 1118738 | 1147561 | 1210263 | 1192298 | 1202509 | 1210263 | 1220526 | 1253533 | 1269057 | 1269121 | 1270977 | 1236338 | 1288411 | 1938506 | 1937362 | 1572482 | 1575882 | 1898623 | 1896410 | 1899993 | 1896508 | 1312964 | 1336534 | 1339209 | 1351641 | 1352811 | 1337634 | 1339504 | 1401658 | 1398462 | 1438673 | 1464680 | 1465469 | 1442500 | 1508369 | 1513999 | 1528804 | 1529710 | 1534418 | 1543704 | 1544465 | 1532844 | 1575882 | 1572482 | 1912175 | 1742347 | 2367763 | 2255289 | 2395638 | 2248197 | 2314588 | 2289796 | 2244948 | 2025066 | 2058689 | 2049031 | 2056318 | 2086678 | 2078530 | 2073554 | 2102616 | 2097468 | 2096083 | 2095302 | 2088569 | 2096083 | 2103704 | 2125507 | 2144569 | 2221282 | 2524532 | 2404597 | 2347635 | 2224911 | 2205119 | 2269272 | 2442387 | 2548398 | 2476624 | 2272447 | 2607898 | 2648238 | 2567040 | 2643513 | 2607898 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 113 | 121 | 133 | 138 | 140 | 139 | 145 | 149 | 109 | 135 | 140 | 153 | 137 | None | 161 | 161 | None | None | 161 | 165 | None | 167 | 169 | None | 169 | None | None | None | 169 | 171 | None | 171 | None | 173 | None | 175 | 180 | 180 | None | None | None | 177 | 181 | None | 183 | 188 | 185 | None | 188 | 188 | None | None | None | None | 187 | None | None | 217 | 203 | None | 220 | 220 | 220 | 220 | None | 194 | 194 | 193 | None | None | None | None | 195 | 197 | None | 199 | None | 201 | None | 204 | 204 | None | None | None | 204 | None | 203 | 220 | None | None | 234 | 237 | 234 | 236 | 235 | 234 | 225 | None | 226 | 225 | 228 | 227 | 227 | 228 | 228 | 228 | 228 | 228 | 228 | 228 | 227 | None | None | 244 | None | 235 | 233 | 229 | 233 | 239 | 241 | None | None | None | None | None | 247 | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F461 | F461 | F461 | F497 | F497 | F461 | F461 | F461 | F461 | F461 | F497 | F461 | F461 | F461 | F497 | F497 | F497 | F461 | F461 | F461 | F461 | F461 | F497 | F497 | F497 | F461 | F497 | F461 | F461 | F497 | F461 | F461 | F461 | F461 | F461 | F461 | F497 | F497 | F497 | F497 | F461 | F461 | F461 | F461 | F461 | F497 | F461 | F461 | F497 | F497 | F461 | F497 | F497 | F497 | F461 | F461 | F461 | F461 | F461 | F461 | F497 | F497 | F497 | F497 | F461 | F497 | F497 | F461 | F461 | F497 | F497 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F461 | F497 | F497 | F497 | F497 | F497 | F497 | F461 | F461 | F497 | F461 | F461 | F497 | F461 | F497 | F497 | F497 | F497 | F497 | F461 | F497 | F461 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F461 | F461 | F461 | F497 | F461 | F461 | F497 | 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 | 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 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 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 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1988-12-20 00:00:00 | 1991-01-31 00:00:00 | 1993-08-02 00:00:00 | 1994-05-25 00:00:00 | 1994-11-02 00:00:00 | 1995-01-31 00:00:00 | 1997-01-31 00:00:00 | 1997-07-31 00:00:00 | 1988-02-01 00:00:00 | 1994-01-28 00:00:00 | 1994-11-05 00:00:00 | 1998-07-29 00:00:00 | 1994-08-01 00:00:00 | 2000-01-31 00:00:00 | 2000-03-01 00:00:00 | 2000-03-02 00:00:00 | 2000-03-01 00:00:00 | 2000-07-31 00:00:00 | 2000-07-31 00:00:00 | 2001-07-31 00:00:00 | 2001-07-31 00:00:00 | 2002-01-31 00:00:00 | 2002-02-23 00:00:00 | 2002-02-26 00:00:00 | 2002-02-26 00:00:00 | 2002-01-31 00:00:00 | 2002-02-23 00:00:00 | 2002-07-31 00:00:00 | 2002-07-31 00:00:00 | 2002-07-29 00:00:00 | 2003-01-31 00:00:00 | 2003-01-31 00:00:00 | 2003-07-31 00:00:00 | 2003-07-31 00:00:00 | 2004-01-02 00:00:00 | 2004-02-02 00:00:00 | 2004-10-20 00:00:00 | 2004-10-19 00:00:00 | 2004-10-19 00:00:00 | 2004-10-20 00:00:00 | 2005-01-28 00:00:00 | 2005-01-31 00:00:00 | 2005-07-29 00:00:00 | 2005-07-28 00:00:00 | 2006-01-31 00:00:00 | 2006-10-23 00:00:00 | 2006-07-31 00:00:00 | 2006-07-31 00:00:00 | 2006-11-03 00:00:00 | 2006-11-06 00:00:00 | 2007-01-30 00:00:00 | 2006-10-23 00:00:00 | 2006-11-03 00:00:00 | 2006-11-06 00:00:00 | 2007-01-30 00:00:00 | 2007-07-31 00:00:00 | 2015-02-02 00:00:00 | 2015-02-02 00:00:00 | 2015-03-05 00:00:00 | 2015-03-05 00:00:00 | 2014-10-15 00:00:00 | 2014-10-10 00:00:00 | 2014-10-17 00:00:00 | 2014-10-10 00:00:00 | 2008-01-31 00:00:00 | 2008-05-23 00:00:00 | 2008-05-30 00:00:00 | 2008-07-31 00:00:00 | 2008-07-31 00:00:00 | 2008-05-23 00:00:00 | 2008-05-30 00:00:00 | 2009-02-02 00:00:00 | 2009-02-02 00:00:00 | 2009-07-31 00:00:00 | 2010-01-29 00:00:00 | 2010-02-01 00:00:00 | 2009-07-31 00:00:00 | 2010-08-02 00:00:00 | 2010-08-02 00:00:00 | 2010-10-18 00:00:00 | 2010-10-19 00:00:00 | 2010-10-19 00:00:00 | 2010-10-18 00:00:00 | 2010-10-22 00:00:00 | 2010-10-22 00:00:00 | 2011-01-31 00:00:00 | 2011-01-31 00:00:00 | 2014-10-31 00:00:00 | 2013-01-31 00:00:00 | 2019-01-31 00:00:00 | 2018-05-25 00:00:00 | 2019-07-29 00:00:00 | 2018-05-10 00:00:00 | 2018-10-26 00:00:00 | 2018-09-07 00:00:00 | 2018-05-02 00:00:00 | 2016-03-30 00:00:00 | 2016-07-19 00:00:00 | 2016-06-02 00:00:00 | 2016-07-19 00:00:00 | 2016-10-07 00:00:00 | 2016-09-16 00:00:00 | 2016-09-02 00:00:00 | 2016-10-31 00:00:00 | 2016-10-27 00:00:00 | 2016-11-03 00:00:00 | 2016-10-25 00:00:00 | 2016-10-13 00:00:00 | 2016-10-26 00:00:00 | 2016-11-02 00:00:00 | 2017-01-27 00:00:00 | 2017-01-27 00:00:00 | 2018-01-24 00:00:00 | 2020-10-27 00:00:00 | 2019-07-29 00:00:00 | 2019-01-31 00:00:00 | 2018-03-23 00:00:00 | 2018-01-24 00:00:00 | 2018-07-25 00:00:00 | 2020-01-31 00:00:00 | 2021-01-27 00:00:00 | 2020-01-31 00:00:00 | 2018-07-25 00:00:00 | 2021-11-19 00:00:00 | 2022-01-31 00:00:00 | 2021-01-28 00:00:00 | 2022-01-31 00:00:00 | 2021-08-02 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10005 | 10005 | 10001 | 10002 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10002 | 10001 | 10005 | 10005 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10002 | 10006 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10006 | 10005 | 10005 | 10001 | 10005 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1987 | 1989 | 1993 | 1993 | 1993 | 1993 | 1995 | 1997 | 1987 | 1993 | 1993 | 1997 | 1993 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2013 | 2013 | 2009 | 2011 | 2013 | 2013 | 2013 | 2013 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2009 | 2013 | 2011 | 2019 | 2017 | 2019 | 2017 | 2017 | 2017 | 2017 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2019 | 2019 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2019 | 2017 | 2021 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | * | * | * | * | * | * | * | * | * | BSMITH | * | * | * | EMCENTEE | * | * | DBARRICK | * | * | BINTHAVO | * | LTHIBAUL | KLARRY | LTHIBAUL | * | * | LTHIBAUL | COMPLETED | GGILMORE | COMPLETED | DHORRELL | COMPLETED | GKURIMOT | PBANFORD | GPEREZ | LLEONG | DHORRELL | COMPLETED | * | DHORRELL | * | DHORRELL | SMCCABE | JMARTIN | DHORRELL | DHORRELL | JMARTIN | DHORRELL | CFLAGG | RGEREMIA | SMCCABE | JMARTIN | JINGRAM | JINGRAM | JINGRAM | JINGRAM | CAFILER | CAFILER | CAFILER | CAFILER | SMCCABE | PBANFORD | DHORRELL | MGUERRA | MGUERRA | LHOANG | DHORRELL | JINGRAM | JINGRAM | JINGRAM | JINGRAM | JINGRAM | JINGRAM | JINGRAM | JINGRAM | PBANFORD | PBANFORD | MPACHECO | MPACHECO | MPACHECO | CREYNOLDS | JINGRAM | JINGRAM | CAFILER | JINGRAM | GTAYLOR | GTAYLOR | GTAYLOR | GTAYLOR | CAFILER | CAFILER | RGEREMIA | KBANH | JINGRAM | KBANH | JINGRAM | GKURIMOT | GKURIMOT | GKURIMOT | GKURIMOT | GKURIMOT | GKURIMOT | GKURIMOT | GKURIMOT | GKURIMOT | GKURIMOT | JINGRAM | JINGRAM | DMCCASTL | CAFILER | GTAYLOR | GTAYLOR | GTAYLOR | DMCCASTL | GTAYLOR | GTAYLOR | GTAYLOR | GTAYLOR | GTAYLOR | GTAYLOR | GTAYLOR | GTAYLOR | GTAYLOR | GTAYLOR | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11001 | 11001 | 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 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 11001 | 11001 | 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 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 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 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1988-01-01 00:00:00 | 1990-01-01 00:00:00 | 1993-01-01 00:00:00 | None | None | 1994-07-01 00:00:00 | 1996-01-01 00:00:00 | 1997-01-01 00:00:00 | 1987-01-01 00:00:00 | 1993-07-01 00:00:00 | None | 1998-01-01 00:00:00 | 1994-01-01 00:00:00 | 1999-01-01 00:00:00 | 2000-02-29 00:00:00 | 2000-02-29 00:00:00 | None | 2000-01-01 00:00:00 | 2000-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-07-01 00:00:00 | 2002-02-23 00:00:00 | None | 2002-02-26 00:00:00 | 2001-07-01 00:00:00 | None | 2002-01-01 00:00:00 | 2002-01-01 00:00:00 | 2002-07-29 00:00:00 | 2002-07-01 00:00:00 | 2002-07-01 00:00:00 | 2003-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-07-01 00:00:00 | 2003-07-01 00:00:00 | 2004-10-20 00:00:00 | 2004-10-19 00:00:00 | None | None | 2004-01-01 00:00:00 | 2004-01-01 00:00:00 | 2005-01-01 00:00:00 | 2005-01-01 00:00:00 | 2005-07-01 00:00:00 | 2006-10-23 00:00:00 | 2006-01-01 00:00:00 | 2006-01-01 00:00:00 | 2006-11-03 00:00:00 | 2006-11-06 00:00:00 | 2006-07-01 00:00:00 | None | None | None | 2006-07-01 00:00:00 | 2007-01-01 00:00:00 | 2014-01-01 00:00:00 | 2014-01-01 00:00:00 | 2010-07-01 00:00:00 | 2010-07-01 00:00:00 | 2014-10-15 00:00:00 | 2014-10-10 00:00:00 | 2014-10-17 00:00:00 | 2014-10-10 00:00:00 | 2007-07-01 00:00:00 | 2008-05-23 00:00:00 | 2008-05-30 00:00:00 | 2008-01-01 00:00:00 | 2008-01-01 00:00:00 | None | None | 2008-07-01 00:00:00 | 2008-07-01 00:00:00 | 2009-01-01 00:00:00 | 2009-07-01 00:00:00 | 2009-07-01 00:00:00 | 2009-01-01 00:00:00 | 2010-01-01 00:00:00 | 2010-01-01 00:00:00 | 2010-10-18 00:00:00 | 2010-10-19 00:00:00 | None | None | None | 2010-10-22 00:00:00 | 2010-07-01 00:00:00 | 2010-07-01 00:00:00 | 2014-10-31 00:00:00 | 2012-01-01 00:00:00 | 2018-07-01 00:00:00 | 2018-05-25 00:00:00 | 2019-01-01 00:00:00 | 2018-05-10 00:00:00 | 2018-10-26 00:00:00 | 2018-09-07 00:00:00 | 2018-05-02 00:00:00 | 2016-03-30 00:00:00 | 2016-01-01 00:00:00 | 2016-06-02 00:00:00 | 2016-01-01 00:00:00 | 2016-10-07 00:00:00 | 2016-09-16 00:00:00 | 2016-09-02 00:00:00 | 2016-10-31 00:00:00 | 2016-10-27 00:00:00 | 2016-11-03 00:00:00 | 2016-10-25 00:00:00 | 2016-10-13 00:00:00 | 2016-10-26 00:00:00 | 2016-11-02 00:00:00 | 2016-07-01 00:00:00 | 2016-07-01 00:00:00 | 2017-01-01 00:00:00 | 2020-10-27 00:00:00 | 2019-01-01 00:00:00 | 2018-07-01 00:00:00 | 2018-03-23 00:00:00 | 2017-01-01 00:00:00 | 2018-01-01 00:00:00 | 2019-07-01 00:00:00 | 2020-01-01 00:00:00 | 2019-07-01 00:00:00 | 2018-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-07-01 00:00:00 | 2020-01-01 00:00:00 | 2021-07-01 00:00:00 | 2021-01-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1988-12-31 00:00:00 | 1990-12-31 00:00:00 | 1993-06-30 00:00:00 | None | None | 1994-12-31 00:00:00 | 1996-12-31 00:00:00 | 1997-06-30 00:00:00 | 1987-12-31 00:00:00 | 1993-12-31 00:00:00 | None | 1998-06-30 00:00:00 | 1994-06-30 00:00:00 | 1999-12-31 00:00:00 | 2000-02-29 00:00:00 | 2000-02-29 00:00:00 | None | 2000-06-30 00:00:00 | 2000-06-30 00:00:00 | 2001-06-30 00:00:00 | 2001-06-30 00:00:00 | 2001-12-31 00:00:00 | 2002-02-23 00:00:00 | None | 2002-02-26 00:00:00 | 2001-12-31 00:00:00 | None | 2002-06-30 00:00:00 | 2002-06-30 00:00:00 | 2002-07-29 00:00:00 | 2002-12-31 00:00:00 | 2002-12-31 00:00:00 | 2003-06-30 00:00:00 | 2003-06-30 00:00:00 | 2003-12-31 00:00:00 | 2003-12-31 00:00:00 | 2004-10-20 00:00:00 | 2004-10-19 00:00:00 | None | None | 2004-12-31 00:00:00 | 2004-12-31 00:00:00 | 2005-06-30 00:00:00 | 2005-06-30 00:00:00 | 2005-12-31 00:00:00 | 2006-10-23 00:00:00 | 2006-06-30 00:00:00 | 2006-06-30 00:00:00 | 2006-11-03 00:00:00 | 2006-11-06 00:00:00 | 2006-12-31 00:00:00 | None | None | None | 2006-12-31 00:00:00 | 2007-06-30 00:00:00 | 2014-12-31 00:00:00 | 2014-12-31 00:00:00 | 2010-12-31 00:00:00 | 2010-12-31 00:00:00 | 2014-10-15 00:00:00 | 2014-10-10 00:00:00 | 2014-10-17 00:00:00 | 2014-10-10 00:00:00 | 2007-12-31 00:00:00 | 2008-05-23 00:00:00 | 2008-05-30 00:00:00 | 2008-06-30 00:00:00 | 2008-06-30 00:00:00 | None | None | 2008-12-31 00:00:00 | 2008-12-31 00:00:00 | 2009-06-30 00:00:00 | 2009-12-31 00:00:00 | 2009-12-31 00:00:00 | 2009-06-30 00:00:00 | 2010-06-30 00:00:00 | 2010-06-30 00:00:00 | 2010-10-18 00:00:00 | 2010-10-19 00:00:00 | None | None | None | 2010-10-22 00:00:00 | 2010-12-31 00:00:00 | 2010-12-31 00:00:00 | 2014-10-31 00:00:00 | 2012-12-31 00:00:00 | 2018-12-31 00:00:00 | 2018-05-25 00:00:00 | 2019-06-30 00:00:00 | 2018-05-10 00:00:00 | 2018-10-26 00:00:00 | 2018-09-07 00:00:00 | 2018-05-02 00:00:00 | 2016-03-30 00:00:00 | 2016-06-30 00:00:00 | 2016-06-02 00:00:00 | 2016-06-30 00:00:00 | 2016-10-07 00:00:00 | 2016-09-16 00:00:00 | 2016-09-02 00:00:00 | 2016-10-31 00:00:00 | 2016-10-27 00:00:00 | 2016-11-03 00:00:00 | 2016-10-25 00:00:00 | 2016-10-13 00:00:00 | 2016-10-26 00:00:00 | 2016-11-02 00:00:00 | 2016-12-31 00:00:00 | 2016-12-31 00:00:00 | 2017-12-31 00:00:00 | 2020-10-27 00:00:00 | 2019-06-30 00:00:00 | 2018-12-31 00:00:00 | 2018-03-23 00:00:00 | 2017-12-31 00:00:00 | 2018-06-30 00:00:00 | 2019-12-31 00:00:00 | 2020-12-31 00:00:00 | 2019-12-31 00:00:00 | 2018-06-30 00:00:00 | 2021-06-30 00:00:00 | 2021-12-31 00:00:00 | 2020-12-31 00:00:00 | 2021-12-31 00:00:00 | 2021-06-30 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 2000-02-29 00:00:00 | 2000-02-29 00:00:00 | None | None | 2000-07-31 00:00:00 | 2001-07-31 00:00:00 | None | 2002-01-31 00:00:00 | 2002-02-23 00:00:00 | None | 2002-02-26 00:00:00 | None | None | None | 2002-07-31 00:00:00 | 2002-07-29 00:00:00 | None | 2003-01-31 00:00:00 | None | 2003-07-31 00:00:00 | None | 2004-02-02 00:00:00 | 2004-10-20 00:00:00 | 2004-10-19 00:00:00 | None | None | None | 2005-01-31 00:00:00 | 2005-07-29 00:00:00 | None | 2006-01-31 00:00:00 | 2006-10-23 00:00:00 | 2006-07-31 00:00:00 | None | 2006-11-03 00:00:00 | 2006-11-06 00:00:00 | None | None | None | None | 2006-12-31 00:00:00 | None | None | 2015-02-02 00:00:00 | 2015-03-05 00:00:00 | None | 2014-10-15 00:00:00 | 2014-10-10 00:00:00 | 2014-10-17 00:00:00 | 2014-10-10 00:00:00 | None | 2008-05-23 00:00:00 | 2008-05-30 00:00:00 | 2008-07-31 00:00:00 | None | None | None | None | 2009-02-02 00:00:00 | 2009-07-31 00:00:00 | None | 2010-02-01 00:00:00 | None | 2010-08-02 00:00:00 | None | 2010-10-18 00:00:00 | 2010-10-19 00:00:00 | None | None | None | 2010-10-22 00:00:00 | None | 2011-01-31 00:00:00 | 2014-10-31 00:00:00 | None | None | 2018-05-25 00:00:00 | 2019-07-29 00:00:00 | 2018-05-10 00:00:00 | 2018-10-26 00:00:00 | 2018-09-07 00:00:00 | 2018-05-02 00:00:00 | 2016-03-30 00:00:00 | None | 2016-06-02 00:00:00 | 2016-07-19 00:00:00 | 2016-10-07 00:00:00 | 2016-09-16 00:00:00 | 2016-09-02 00:00:00 | 2016-10-31 00:00:00 | 2016-10-27 00:00:00 | 2016-11-03 00:00:00 | 2016-10-25 00:00:00 | 2016-10-13 00:00:00 | 2016-10-26 00:00:00 | 2016-11-02 00:00:00 | 2017-01-26 00:00:00 | None | None | 2020-10-27 00:00:00 | None | 2019-01-30 00:00:00 | 2018-03-23 00:00:00 | 2018-01-24 00:00:00 | 2018-07-25 00:00:00 | 2020-01-11 00:00:00 | 2021-01-17 00:00:00 | None | None | None | None | None | 2022-01-22 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 | 22001 | None | 22001 | None | 22001 | 22001 | 22001 | None | None | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | None | None | None | 22001 | None | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | None | None | None | 22001 | 22001 | None | 22001 | None | 22001 | None | 22001 | 22001 | None | None | None | 22001 | None | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | None | None | None | 22001 | None |
filer_id | 1011153 | |
---|---|---|
filer_type | 10 | |
active | Y | |
race | 0 | |
session_id | 2007 | |
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 | 18043 | |
district_cd | None |
filer_id | 1011153 | |
---|---|---|
xref_id | 488046 | |
effect_dt | 1999-12-07 00:00:00 | |
migration_source | IDENTFIX |
xref_filer_id | 488046 | 488046 | ||
---|---|---|---|---|
filer_id | 1011153 | 1011153 | ||
filer_type | MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE | MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE | ||
status | ACTIVE | ACTIVE | ||
effect_dt | 1990-12-01 00:00:00 | 1990-12-01 00:00:00 | ||
naml | NATURE CONSERVANCY, THE | NATURE CONSERVANCY ACTION FUND, THE | ||
namf | None | None | ||
namt | None | None | ||
nams | None | None | ||
adr1 | None | None | ||
adr2 | None | None | ||
city | SAN FRANCISCO | SAN FRANCISCO | ||
st | CA | CA | ||
zip4 | 94105 | 94105 | ||
phon | 4157770487 | 4157770487 | ||
fax | None | None | ||
None | None |
filer_id | 1011153 |
---|
filer_id | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | 1011153 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 598472_0.cal | 645121_0.cal | 772441_0.cal | 814123_0.cal | 825221_0.cal | 826332_0.cal | 50567.cal | 825221_1.cal | 857083_0.cal | 912526_0.cal | 947994_0.cal | 990915_0.cal | 1049226_0.cal | 1049851_0.cal | 1079840_0.cal | 1116991_0.cal | 1147561_0.cal | 1210263_0.cal | 1336534_0.cal | 1398462_0.cal | 1339209_0.cal | 1351641_0.cal | 1508369_0.cal | 1210263_1.cal | 1220526_0.cal | 1236338_0.cal | 1465469_0.cal | 1438673_0.cal | 1528804_0.cal | 1529710_0.cal | 1532844_0.cal | 1572482_0.cal | 2049031_0.cal | 282693.cal | 2096083_1.cal | 2102616_0.cal | 2103704_0.cal | 2078530_0.cal | 2097468_0.cal | 2086678_0.cal | 2088569_0.cal | 2025066_0.cal | 58383.cal | 1898623_0.cal | 1896410_0.cal | 1896508_0.cal | 2095302_0.cal | 2096083_0.cal | 1899993_0.cal | 2073554_0.cal | 1912175_0.cal | 2255289_0.cal | 2314588_0.cal | 2244948_0.cal | 2289796_0.cal | 2248197_0.cal | 2224911_0.cal | 2524532_0.cal | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
received_date | 2000-03-01 00:00:00 | 2000-07-31 00:00:00 | 2001-07-31 00:00:00 | 2002-01-31 00:00:00 | 2002-02-23 00:00:00 | 2002-02-26 00:00:00 | 2002-03-01 00:00:00 | 2002-07-29 00:00:00 | 2002-07-31 00:00:00 | 2003-01-31 00:00:00 | 2003-07-31 00:00:00 | 2004-02-02 00:00:00 | 2004-10-19 00:00:00 | 2004-10-20 00:00:00 | 2005-01-31 00:00:00 | 2005-07-29 00:00:00 | 2006-01-31 00:00:00 | 2006-10-23 00:00:00 | 2008-05-23 00:00:00 | 2009-02-02 00:00:00 | 2008-05-30 00:00:00 | 2008-07-31 00:00:00 | 2010-08-02 00:00:00 | 2006-11-03 00:00:00 | 2006-11-06 00:00:00 | 2007-01-30 00:00:00 | 2010-02-01 00:00:00 | 2009-07-31 00:00:00 | 2010-10-18 00:00:00 | 2010-10-19 00:00:00 | 2010-10-22 00:00:00 | 2011-01-31 00:00:00 | 2016-06-02 00:00:00 | 2016-06-02 00:00:00 | 2016-11-03 00:00:00 | 2016-10-31 00:00:00 | 2016-11-02 00:00:00 | 2016-09-16 00:00:00 | 2016-10-27 00:00:00 | 2016-10-07 00:00:00 | 2016-10-13 00:00:00 | 2016-03-30 00:00:00 | 2016-03-30 00:00:00 | 2014-10-15 00:00:00 | 2014-10-10 00:00:00 | 2014-10-10 00:00:00 | 2016-10-25 00:00:00 | 2016-10-26 00:00:00 | 2014-10-17 00:00:00 | 2016-09-02 00:00:00 | 2014-10-31 00:00:00 | 2018-05-25 00:00:00 | 2018-10-26 00:00:00 | 2018-05-02 00:00:00 | 2018-09-07 00:00:00 | 2018-05-10 00:00:00 | 2018-03-23 00:00:00 | 2020-10-27 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/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/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 | /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/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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_id | 598472 | 645121 | 772441 | 814123 | 825221 | 826332 | None | 825221 | 857083 | 912526 | 947994 | 990915 | 1049226 | 1049851 | 1079840 | 1116991 | 1147561 | 1210263 | 1336534 | 1398462 | 1339209 | 1351641 | 1508369 | 1210263 | 1220526 | 1236338 | 1465469 | 1438673 | 1528804 | 1529710 | 1532844 | 1572482 | 2049031 | None | 2096083 | 2102616 | 2103704 | 2078530 | 2097468 | 2086678 | 2088569 | 2025066 | None | 1898623 | 1896410 | 1896508 | 2095302 | 2096083 | 1899993 | 2073554 | 1912175 | 2255289 | 2314588 | 2244948 | 2289796 | 2248197 | 2224911 | 2524532 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F497 | F461 | F461 | F461 | F497 | F497 | None | F497 | F461 | F461 | F461 | F461 | F497 | F497 | F461 | F461 | F461 | F497 | F497 | F461 | F497 | F461 | F461 | F497 | F497 | F461 | F461 | F461 | F497 | F497 | F497 | F461 | F497 | None | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | None | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | F497 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
receive_comment | 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 | Filing did not pass validation | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing did not pass validation | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted |