filer_id | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1112856 | 2122056 | 2163369 | 2170446 | 2206490 | 2416954 | 2508861 | 2276726 | 2301102 | 2468771 | 2547785 | 2339059 | ||||||||||||
effect_dt | 1996-01-01 00:00:00 | 2007-04-01 00:00:00 | 2009-01-01 00:00:00 | 2009-06-30 00:00:00 | 2011-02-01 00:00:00 | 2017-01-01 00:00:00 | 2021-01-04 00:00:00 | 2013-01-01 00:00:00 | 2013-11-01 00:00:00 | 2019-01-01 00:00:00 | 2023-01-01 00:00:00 | 2015-01-01 00:00:00 | ||||||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | ||||||||||||
session_id | 1995 | 2007 | 2009 | 2009 | 2011 | 2017 | 2021 | 2013 | 2013 | 2019 | 2023 | 2015 |
filer_id | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 489172 | 492853 | 496473 | 485574 | 485574 | 489172 | 463875 | 1255630 | 1255979 | 1284813 | 1755820 | 1775194 | 1940614 | 1860899 | 1805549 | 1797581 | 1960180 | 1900451 | 1296586 | 1329947 | 1309638 | 1351747 | 1375991 | 1385441 | 1395542 | 1414761 | 1421485 | 1434709 | 1385441 | 1434709 | 1431555 | 1463276 | 1451417 | 1483360 | 1505022 | 1539016 | 1569183 | 1600461 | 1579792 | 1618982 | 1589933 | 1628612 | 1653062 | 1653062 | 1671947 | 1811947 | 1797581 | 1671947 | 1694906 | 1923539 | 1713788 | 1723558 | 1837212 | 1759919 | 1972921 | 2003505 | 1992327 | 2331281 | 2155418 | 2317213 | 2471123 | 2417170 | 2343815 | 2032017 | 2056533 | 2119838 | 2094029 | 2116153 | 2155418 | 2141372 | 2163546 | 2172792 | 2235342 | 2380807 | 2188449 | 2482802 | 2471123 | 2396604 | 2181440 | 2380807 | 2598327 | 2206971 | 2273025 | 2349295 | 2573252 | 2551089 | 2442663 | 2380807 | 2529332 | 2618496 | 2701103 | 2471123 | 2586448 | 2638181 | 2545315 | 2670359 | 2754082 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 146 | 147 | 148 | 145 | 145 | 146 | 145 | 190 | None | 190 | None | 214 | None | 218 | None | 215 | 221 | 219 | 191 | 193 | 192 | 194 | 195 | 196 | 196 | None | 197 | 198 | 199 | 198 | None | 200 | 199 | 201 | 202 | 203 | 204 | 206 | None | 207 | 205 | 208 | 209 | 209 | 210 | 216 | 215 | 210 | 211 | 220 | None | 212 | 217 | 213 | 222 | 224 | 223 | 236 | 229 | 235 | 241 | 239 | 236 | 225 | 226 | 228 | 227 | 228 | 229 | None | None | 230 | 233 | 237 | 231 | 242 | 241 | 238 | None | 237 | 246 | 232 | 234 | None | 245 | 244 | 240 | 237 | 243 | 247 | 250 | 241 | None | 248 | 245 | 249 | 252 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F635 | F635 | F635 | F635 | F690 | F690 | F606 | F602 | F602 | F635 | F602 | F635 | F602 | F635 | F605 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F605 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F605 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F605 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F602 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 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 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1996-07-31 00:00:00 | 1996-10-31 00:00:00 | 1997-01-31 00:00:00 | 1996-04-29 00:00:00 | 1997-01-31 00:00:00 | 1997-01-31 00:00:00 | 1997-01-01 00:00:00 | 2007-04-09 00:00:00 | 2007-03-30 00:00:00 | 2007-07-31 00:00:00 | 2013-01-29 00:00:00 | 2013-07-12 00:00:00 | 2014-12-26 00:00:00 | 2014-07-02 00:00:00 | 2013-11-04 00:00:00 | 2013-10-27 00:00:00 | 2015-04-21 00:00:00 | 2014-10-20 00:00:00 | 2007-10-30 00:00:00 | 2008-04-30 00:00:00 | 2008-01-30 00:00:00 | 2008-07-31 00:00:00 | 2008-10-30 00:00:00 | 2008-12-24 00:00:00 | 2009-01-30 00:00:00 | 2008-12-24 00:00:00 | 2009-04-30 00:00:00 | 2009-07-28 00:00:00 | 2009-07-16 00:00:00 | 2009-07-28 00:00:00 | 2009-07-17 00:00:00 | 2010-01-29 00:00:00 | 2009-10-29 00:00:00 | 2010-04-28 00:00:00 | 2010-07-29 00:00:00 | 2010-10-29 00:00:00 | 2011-01-28 00:00:00 | 2011-07-14 00:00:00 | 2011-02-11 00:00:00 | 2011-10-24 00:00:00 | 2011-04-29 00:00:00 | 2012-01-16 00:00:00 | 2012-04-19 00:00:00 | 2012-06-28 00:00:00 | 2012-07-17 00:00:00 | 2014-01-22 00:00:00 | 2014-01-23 00:00:00 | 2012-10-05 00:00:00 | 2012-10-05 00:00:00 | 2015-01-07 00:00:00 | 2012-10-25 00:00:00 | 2013-01-09 00:00:00 | 2014-04-08 00:00:00 | 2013-04-19 00:00:00 | 2015-07-05 00:00:00 | 2016-01-12 00:00:00 | 2015-10-18 00:00:00 | 2018-12-31 00:00:00 | 2017-09-25 00:00:00 | 2018-10-30 00:00:00 | 2020-08-19 00:00:00 | 2019-10-29 00:00:00 | 2019-01-29 00:00:00 | 2016-04-25 00:00:00 | 2016-07-20 00:00:00 | 2017-01-16 00:00:00 | 2016-10-24 00:00:00 | 2016-12-31 00:00:00 | 2017-04-28 00:00:00 | 2016-12-30 00:00:00 | 2017-06-16 00:00:00 | 2017-07-27 00:00:00 | 2018-04-24 00:00:00 | 2019-07-30 00:00:00 | 2017-10-18 00:00:00 | 2020-07-29 00:00:00 | 2020-07-29 00:00:00 | 2019-07-30 00:00:00 | 2017-08-21 00:00:00 | 2019-04-30 00:00:00 | 2021-07-28 00:00:00 | 2018-01-28 00:00:00 | 2018-07-30 00:00:00 | 2018-12-31 00:00:00 | 2021-04-09 00:00:00 | 2021-01-29 00:00:00 | 2020-01-31 00:00:00 | 2020-08-19 00:00:00 | 2020-10-31 00:00:00 | 2021-10-23 00:00:00 | 2022-07-26 00:00:00 | 2020-04-30 00:00:00 | 2021-01-25 00:00:00 | 2022-01-26 00:00:00 | 2021-01-20 00:00:00 | 2022-04-25 00:00:00 | 2022-11-09 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10002 | 10002 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10002 | 10002 | 10001 | 10001 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10002 | 10001 | 10001 | 10002 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 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 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 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 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1995 | 1995 | 1995 | 1995 | 1995 | 1995 | 1995 | 2007 | 2007 | 2007 | 2013 | 2013 | 2015 | 2013 | 2013 | 2013 | 2015 | 2013 | 2007 | 2007 | 2007 | 2007 | 2007 | 2009 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2013 | 2011 | 2011 | 2013 | 2011 | 2011 | 2013 | 2013 | 2015 | 2015 | 2015 | 2019 | 2017 | 2017 | 2019 | 2019 | 2017 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2017 | 2019 | 2019 | 2019 | 2017 | 2019 | 2021 | 2017 | 2017 | 2019 | 2021 | 2019 | 2019 | 2019 | 2019 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2023 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | * | * | * | * | SARRIAGA | LTHIBAUL | SARRIAGA | AGLADNEY | GKURIMOT | AGLADNEY | SMCCONNAN | ASAETERN | AGLADNEY | AGLADNEY | LTHIBAUL | SMCCABE | LTHIBAUL | LTHIBAUL | ASAETERN | * | ASAETERN | MMORENO | MGUERRA | MGUERRA | * | MGUERRA | YRODRIGU | MGUERRA | MGUERRA | ASAETERN | ASAETERN | ASAETERN | AGLADNEY | AGLADNEY | CFLAGG | ASAETERN | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | ASAETERN | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | YRODRIGU | AGLADNEY | ASAETERN | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | PBANFORD | AGLADNEY | AGLADNEY | GTAYLOR | VUKSTINA | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | GPEREZ | AGLADNEY | GPEREZ | GPEREZ | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | GTAYLOR | GTAYLOR | VUKSTINA | GPEREZ | GTAYLOR | GTAYLOR | AGLADNEY | AGLADNEY | PBANFORD | GTAYLOR | GTAYLOR | GTAYLOR | GTAYLOR | GTAYLOR | CHATRIDGE | CAFILER | GTAYLOR | MKIRKHAM | CHATRIDGE | MKIRKHAM | CAFILER | CAFILER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 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 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1996-04-01 00:00:00 | 1996-07-01 00:00:00 | 1996-10-01 00:00:00 | 1996-01-01 00:00:00 | 1996-01-01 00:00:00 | 1996-04-01 00:00:00 | 1996-01-01 00:00:00 | 2007-04-09 00:00:00 | 1900-01-01 00:00:00 | 2007-04-01 00:00:00 | 1900-01-01 00:00:00 | 2013-04-01 00:00:00 | 1900-01-01 00:00:00 | 2014-04-01 00:00:00 | 1900-01-01 00:00:00 | 2013-07-01 00:00:00 | 2015-01-01 00:00:00 | 2014-07-01 00:00:00 | 2007-07-01 00:00:00 | 2008-01-01 00:00:00 | 2007-10-01 00:00:00 | 2008-04-01 00:00:00 | 2008-07-01 00:00:00 | 2008-12-19 00:00:00 | 2008-10-01 00:00:00 | 1900-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-04-01 00:00:00 | 2009-07-08 00:00:00 | 2009-04-01 00:00:00 | 1900-01-01 00:00:00 | 2009-10-01 00:00:00 | 2009-07-01 00:00:00 | 2010-01-01 00:00:00 | 2010-04-01 00:00:00 | 2010-07-01 00:00:00 | 2010-10-01 00:00:00 | 2011-04-01 00:00:00 | 1900-01-01 00:00:00 | 2011-07-01 00:00:00 | 2011-01-01 00:00:00 | 2011-10-01 00:00:00 | 2012-01-01 00:00:00 | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 2013-10-01 00:00:00 | 2013-07-01 00:00:00 | 2012-04-01 00:00:00 | 2012-07-01 00:00:00 | 2014-10-01 00:00:00 | 1900-01-01 00:00:00 | 2012-10-01 00:00:00 | 2014-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-04-01 00:00:00 | 2015-10-01 00:00:00 | 2015-07-01 00:00:00 | 2018-12-31 00:00:00 | 2017-01-01 00:00:00 | 2018-07-01 00:00:00 | 2020-01-01 00:00:00 | 2019-07-01 00:00:00 | 2018-10-01 00:00:00 | 2016-01-01 00:00:00 | 2016-04-01 00:00:00 | 2016-10-01 00:00:00 | 2016-07-01 00:00:00 | 2016-12-31 00:00:00 | 2017-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-04-01 00:00:00 | 2018-01-01 00:00:00 | 2019-01-01 00:00:00 | 2017-07-01 00:00:00 | 2020-04-01 00:00:00 | 2020-01-01 00:00:00 | 2019-04-01 00:00:00 | 1900-01-01 00:00:00 | 2019-01-01 00:00:00 | 2021-04-01 00:00:00 | 2017-10-01 00:00:00 | 2018-04-01 00:00:00 | 1900-01-01 00:00:00 | 2021-01-01 00:00:00 | 2020-10-01 00:00:00 | 2019-10-01 00:00:00 | 2019-01-01 00:00:00 | 2020-07-01 00:00:00 | 2021-07-01 00:00:00 | 2022-04-01 00:00:00 | 2020-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-10-01 00:00:00 | 2021-01-20 00:00:00 | 2022-01-01 00:00:00 | 2022-11-09 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1996-06-30 00:00:00 | 1996-09-30 00:00:00 | 1996-12-31 00:00:00 | 1996-03-31 00:00:00 | 1996-03-31 00:00:00 | 1996-06-30 00:00:00 | 1996-03-31 00:00:00 | 2007-04-09 00:00:00 | 1900-01-01 00:00:00 | 2007-06-30 00:00:00 | 1900-01-01 00:00:00 | 2013-06-30 00:00:00 | 1900-01-01 00:00:00 | 2014-06-30 00:00:00 | 1900-01-01 00:00:00 | 2013-09-30 00:00:00 | 2015-03-31 00:00:00 | 2014-09-30 00:00:00 | 2007-09-30 00:00:00 | 2008-03-31 00:00:00 | 2007-12-31 00:00:00 | 2008-06-30 00:00:00 | 2008-09-30 00:00:00 | 2008-12-19 00:00:00 | 2008-12-31 00:00:00 | 1900-01-01 00:00:00 | 2009-03-31 00:00:00 | 2009-06-30 00:00:00 | 2009-07-08 00:00:00 | 2009-06-30 00:00:00 | 1900-01-01 00:00:00 | 2009-12-31 00:00:00 | 2009-09-30 00:00:00 | 2010-03-31 00:00:00 | 2010-06-30 00:00:00 | 2010-09-30 00:00:00 | 2010-12-31 00:00:00 | 2011-06-30 00:00:00 | 1900-01-01 00:00:00 | 2011-09-30 00:00:00 | 2011-03-31 00:00:00 | 2011-12-31 00:00:00 | 2012-03-31 00:00:00 | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 2013-12-31 00:00:00 | 2013-09-30 00:00:00 | 2012-06-30 00:00:00 | 2012-09-30 00:00:00 | 2014-12-31 00:00:00 | 1900-01-01 00:00:00 | 2012-12-31 00:00:00 | 2014-03-31 00:00:00 | 2013-03-31 00:00:00 | 2015-06-30 00:00:00 | 2015-12-31 00:00:00 | 2015-09-30 00:00:00 | 2018-12-31 00:00:00 | 2017-03-31 00:00:00 | 2018-09-30 00:00:00 | 2020-03-31 00:00:00 | 2019-09-30 00:00:00 | 2018-12-31 00:00:00 | 2016-03-31 00:00:00 | 2016-06-30 00:00:00 | 2016-12-31 00:00:00 | 2016-09-30 00:00:00 | 2016-12-31 00:00:00 | 2017-03-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-06-30 00:00:00 | 2018-03-31 00:00:00 | 2019-03-31 00:00:00 | 2017-09-30 00:00:00 | 2020-06-30 00:00:00 | 2020-03-31 00:00:00 | 2019-06-30 00:00:00 | 1900-01-01 00:00:00 | 2019-03-31 00:00:00 | 2021-06-30 00:00:00 | 2017-12-31 00:00:00 | 2018-06-30 00:00:00 | 1900-01-01 00:00:00 | 2021-03-31 00:00:00 | 2020-12-31 00:00:00 | 2019-12-31 00:00:00 | 2019-03-31 00:00:00 | 2020-09-30 00:00:00 | 2021-09-30 00:00:00 | 2022-06-30 00:00:00 | 2020-03-31 00:00:00 | 1900-01-01 00:00:00 | 2021-12-31 00:00:00 | 2021-01-20 00:00:00 | 2022-03-31 00:00:00 | 2022-11-09 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_type | None | None | None | None | None | None | None | 22001 | None | 22001 | None | 22006 | None | 22006 | None | 22006 | 22006 | 22006 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 |
filer_id | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 1995 | 2011 | 2009 | 2017 | 2013 | 2007 | 2019 | 2015 | 2023 | 2021 | ||||||||||
interest_cd | 40315 | 40315 | 40315 | 40315 | 40315 | 40315 | 40315 | 40315 | 40315 | 40315 | ||||||||||
effect_date | 1996-01-01 00:00:00 | 2011-01-01 00:00:00 | 2009-01-01 00:00:00 | 2017-01-01 00:00:00 | 2013-01-01 00:00:00 | 2007-04-01 00:00:00 | 2019-01-01 00:00:00 | 2015-01-01 00:00:00 | 2023-01-01 00:00:00 | 2021-01-04 00:00:00 |
filer_id | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||||||||||
active | T | T | Y | Y | Y | Y | Y | Y | Y | Y | N | |||||||||||
race | 0 | 0 | 0 | None | None | None | None | None | None | None | None | |||||||||||
session_id | 1995 | 1995 | 2007 | 2013 | 2011 | 2009 | 2017 | 2019 | 2015 | 2021 | 2023 | |||||||||||
category | 0 | 0 | 0 | None | None | None | None | None | None | None | None | |||||||||||
category_type | 0 | 0 | 0 | None | None | None | None | None | None | None | None | |||||||||||
sub_category | 0 | 0 | 0 | None | None | None | None | None | None | None | None | |||||||||||
effect_dt | 1996-01-01 00:00:00 | 1997-01-01 00:00:00 | 2007-04-01 00:00:00 | 2013-01-01 00:00:00 | 2011-02-01 00:00:00 | 2009-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2015-01-01 00:00:00 | 2021-01-04 00:00:00 | 2023-01-01 00:00:00 | |||||||||||
sub_category_type | 0 | 0 | 0 | None | None | None | None | None | None | None | None | |||||||||||
election_type | 0 | 0 | 0 | None | None | None | None | None | None | None | None | |||||||||||
sub_category_a | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
nyq_dt | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
party_cd | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
county_cd | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
district_cd | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1144788 | |
---|---|---|
xref_id | C26208 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | C26208 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_type | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
status | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
effect_dt | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
naml | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA (CAPHCC) | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA (CAPHCC) | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA (CAPHCC) | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA (CAPHCC) | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA (CAPHCC) | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA (CAPHCC) | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA (CAPHCC) | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA (CAPHCC) | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA (CAPHCC) | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA (CAPHCC) | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA (CAPHCC) | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA (CAPHCC) | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA (CAPHCC) | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA (CAPHCC) | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA (CAPHCC) | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA (CAPHCC) | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA (CAPHCC) | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA (CAPHCC) | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA (CAPHCC) | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA (CAPHCC) | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA (CAPHCC) | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA (CAPHCC) | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA (CAPHCC) | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA (CAPHCC) | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING HEATING COOLING CONTRACTORS OF CALIFORNIA | PLUMBING HEATING COOLING CONTRACTORS OF CALIFORNIA | PLUMBING HEATING COOLING CONTRACTORS OF CALIFORNIA | PLUMBING HEATING COOLING CONTRACTORS OF CALIFORNIA | PLUMBING HEATING COOLING CONTRACTORS OF CALIFORNIA | PLUMBING HEATING COOLING CONTRACTORS OF CALIFORNIA | PLUMBING HEATING COOLING CONTRACTORS OF CALIFORNIA | PLUMBING HEATING COOLING CONTRACTORS OF CALIFORNIA | PLUMBING HEATING COOLING CONTRACTORS OF CALIFORNIA | PLUMBING HEATING COOLING CONTRACTORS OF CALIFORNIA | PLUMBING HEATING COOLING CONTRACTORS OF CALIFORNIA | PLUMBING HEATING COOLING CONTRACTORS OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS OF CALIFORNIA | PLUMBING, HEATING, COOLING CONTRACTORS OF CALIFORNIA | PLUMBING, HEATING, COOLING CONTRACTORS OF CALIFORNIA | PLUMBING, HEATING, COOLING CONTRACTORS OF CALIFORNIA | PLUMBING, HEATING, COOLING CONTRACTORS OF CALIFORNIA | PLUMBING, HEATING, COOLING CONTRACTORS OF CALIFORNIA | PLUMBING, HEATING, COOLING CONTRACTORS OF CALIFORNIA | PLUMBING, HEATING, COOLING CONTRACTORS OF CALIFORNIA | PLUMBING, HEATING, COOLING CONTRACTORS OF CALIFORNIA | PLUMBING, HEATING, COOLING CONTRACTORS OF CALIFORNIA | PLUMBING, HEATING, COOLING CONTRACTORS OF CALIFORNIA | PLUMBING, HEATING, COOLING CONTRACTORS OF CALIFORNIA | PLUMBING, HEATING, COOLING CONTRACTORS OF CALIFORNIA | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namf | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
adr1 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
adr2 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
city | Sacramento | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | Sacramento | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | Sacramento | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | Sacramento | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | Sacramento | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | Sacramento | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | Sacramento | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | Sacramento | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | Sacramento | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | Sacramento | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
zip4 | 95816 | 95834 | 95834 | 95842 | 95842 | 95842 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95816 | 95834 | 95834 | 95842 | 95842 | 95842 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95816 | 95834 | 95834 | 95842 | 95842 | 95842 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95816 | 95834 | 95834 | 95842 | 95842 | 95842 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95816 | 95834 | 95834 | 95842 | 95842 | 95842 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95816 | 95834 | 95834 | 95842 | 95842 | 95842 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95816 | 95834 | 95834 | 95842 | 95842 | 95842 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95816 | 95834 | 95834 | 95842 | 95842 | 95842 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95816 | 95834 | 95834 | 95842 | 95842 | 95842 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95816 | 95834 | 95834 | 95842 | 95842 | 95842 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 9164467422 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9164467422 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9164467422 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9164467422 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9164467422 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9164467422 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9164467422 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9164467422 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9164467422 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9164467422 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | 9169257390 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | None | 9169257623 | 9169257623 | 9169257623 | None | 9169257623 | 9169257623 | 9169257623 | None | 9169257623 | 9169257623 | 9169257623 | None | 9169257623 | 9169257623 | 9169257623 | None | 9169257623 | 9169257623 | 9169257623 | None | 9169257623 | 9169257623 | 9169257623 | None | 9169257623 | 9169257623 | 9169257623 | None | 9169257623 | 9169257623 | 9169257623 | None | 9169257623 | 9169257623 | 9169257623 | None | 9169257623 | 9169257623 | 9169257623 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1144788 |
---|
filer_id | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | |||||
---|---|---|---|---|---|---|---|---|---|---|
change_no | 1 | 0 | 7 | 8 | 9 | |||||
session_id | 2007 | 2007 | 2007 | 2013 | 2021 | |||||
log_dt | 2007-03-30 00:00:00 | 2007-03-30 00:00:00 | 2007-03-30 00:00:00 | 2013-01-29 00:00:00 | 2021-01-25 00:00:00 | |||||
filer_type | 1 | 1 | 1 | 1 | 1 | |||||
correction_flg | None | Y | None | Y | None | |||||
action | TERMINATED | ADDED | CHANGED | ADDED | CHANGED | |||||
attribute_changed | FIRM | NAME | FIRM | RESPONSIBLE OFFICER | ||||||
ethics_dt | None | None | None | None | None | |||||
interests | None | None | None | None | None | |||||
filer_full_name | PLUMBING, HEATING, COOLING CONTRACTORS OF CALIFORNIA | PLUMBING, HEATING, COOLING CONTRACTORS OF CALIFORNIA | PLUMBING, HEATING, COOLING CONTRACTORS OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA | PLUMBING-HEATING-COOLING CONTRACTORS ASSOCIATION OF CALIFORNIA (CAPHCC) | |||||
filer_city | None | None | None | Sacramento | None | |||||
filer_st | None | None | None | CA | None | |||||
filer_zip | None | None | None | 95816 | None | |||||
filer_phone | None | None | None | 9164467422 | None | |||||
entity_type | 1 | 3 | 1 | 3 | 20 | |||||
entity_name | None | DOWDEN AND ASSOCIATES; HR | PLUMBING-HEATING-COOLING CONTRACTORS OF CALIFORNIA, | PACIFIC ADVOCACY GROUP | CHIEF EXECUTIVE OFFICER TRACY THRELFALL | |||||
entity_city | None | None | None | None | None | |||||
entity_st | None | None | None | None | None | |||||
entity_zip | None | None | None | None | None | |||||
entity_phone | None | None | None | None | None | |||||
entity_id | 0 | 1147771 | 0 | None | 1448638 | |||||
responsible_officer | None | None | None | None | None | |||||
effect_dt | 2007-04-01 00:00:00 | 2007-04-01 00:00:00 | 2007-04-01 00:00:00 | 2013-01-01 00:00:00 | 2022-05-10 00:00:00 |
filer_id | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | 1144788 | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 1329947_0.cal | 1505022_0.cal | 1395542_0.cal | 1351747_0.cal | 1483360_0.cal | 1451417_0.cal | 1284813_0.cal | 1421485_0.cal | 1434709_0.cal | 1434709_1.cal | 1385441_1.cal | 1296586_0.cal | 1385441_0.cal | 1375991_0.cal | 1309638_0.cal | 1463276_0.cal | 1539016_0.cal | 1569183_0.cal | 98311.cal | 98292.cal | ||||||||||||||||||||
received_date | 2008-04-30 00:00:00 | 2010-07-29 00:00:00 | 2009-01-30 00:00:00 | 2008-07-31 00:00:00 | 2010-04-28 00:00:00 | 2009-10-29 00:00:00 | 2007-07-31 00:00:00 | 2009-04-30 00:00:00 | 2009-07-28 00:00:00 | 2009-07-28 00:00:00 | 2009-07-16 00:00:00 | 2007-10-30 00:00:00 | 2008-12-24 00:00:00 | 2008-10-30 00:00:00 | 2008-01-30 00:00:00 | 2010-01-29 00:00:00 | 2010-10-29 00:00:00 | 2011-01-28 00:00:00 | 2011-01-28 00:00:00 | 2011-01-28 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 | /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/temp | ||||||||||||||||||||
filing_id | 1329947 | 1505022 | 1395542 | 1351747 | 1483360 | 1451417 | 1284813 | 1421485 | 1434709 | 1434709 | 1385441 | 1296586 | 1385441 | 1375991 | 1309638 | 1463276 | 1539016 | 1569183 | None | None | ||||||||||||||||||||
form_id | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | None | None | ||||||||||||||||||||
receive_comment | 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 passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints |