filer_id | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1107752 | 2021705 | 2044934 | 2080720 | 2116599 | 2162959 | 2207528 | 2415736 | 2469999 | 2509653 | 2277959 | 2343365 | 2551059 | |||||||||||||
effect_dt | 1999-01-01 00:00:00 | 2001-09-05 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-01-01 00:00:00 | 2023-01-01 00:00:00 | |||||||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | |||||||||||||
session_id | 1999 | 2001 | 2003 | 2005 | 2007 | 2009 | 2011 | 2017 | 2019 | 2021 | 2013 | 2015 | 2023 |
filer_id | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 477588 | 475275 | 469752 | 472041 | 479776 | 483104 | 484412 | 464617 | 497571 | 490284 | 491744 | 493965 | 486628 | 464617 | 484412 | 468637 | 474177 | 480848 | 480848 | 488031 | 495414 | 466716 | 628339 | 614242 | 663808 | 682091 | 694538 | 704450 | 715799 | 738250 | 753380 | 744573 | 790740 | 771826 | 777872 | 777873 | 796249 | 812510 | 837789 | 833194 | 820577 | 863356 | 842841 | 853731 | 891724 | 880991 | 903717 | 906445 | 929992 | 943998 | 909017 | 932573 | 966932 | 955551 | 976282 | 984726 | 1012288 | 1027153 | 1010695 | 1029693 | 1050386 | 997203 | 1074453 | 1066007 | 1074791 | 1105308 | 1074453 | 1091416 | 1116480 | 1133791 | 1141791 | 1127404 | 1167619 | 1149720 | 1187104 | 1210779 | 1231632 | 1279244 | 1258694 | 1247361 | 1306646 | 1295116 | 1778377 | 1965184 | 1942154 | 1799449 | 1936543 | 1922235 | 1907410 | 1328561 | 1349366 | 1367926 | 1387053 | 1391010 | 1433990 | 1415061 | 1419425 | 1449291 | 1482805 | 1460588 | 1503683 | 1536001 | 1552333 | 1562778 | 1563122 | 1588395 | 1571587 | 1620094 | 1603363 | 1631759 | 1654725 | 1677140 | 1814315 | 1717100 | 1703544 | 1871460 | 1728690 | 1734595 | 1843799 | 1765593 | 1998316 | 1942154 | 1983114 | 1998316 | 1983114 | 2433204 | 2554344 | 2437729 | 2207744 | 2239301 | 2007382 | 2007382 | 2033161 | 2064429 | 2097380 | 2115796 | 2129715 | 2134597 | 2152172 | 2169104 | 2417078 | 2379019 | 2529673 | 2470758 | 2363947 | 2396899 | 2347238 | 2318549 | 2482311 | 2267164 | 2329561 | 2190858 | 2432687 | 2586684 | 2581782 | 2708339 | 2677108 | 2545924 | 2645243 | 2603189 | 2618478 | 2749267 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 151 | 143 | 142 | 150 | 159 | 152 | 145 | 141 | 156 | 154 | 147 | 155 | 153 | 141 | 145 | 157 | 158 | 144 | 144 | 146 | 148 | 149 | 161 | 160 | 162 | 163 | 163 | None | 164 | 164 | 165 | 165 | 167 | 166 | None | None | None | 168 | 169 | None | None | None | None | 170 | None | 171 | None | 172 | 173 | 174 | None | None | 175 | None | None | 176 | None | 178 | 177 | None | 179 | None | 180 | None | None | 181 | 180 | None | 182 | 183 | None | None | 185 | 184 | 186 | 187 | 188 | 190 | 189 | None | 192 | 191 | 214 | 221 | None | 215 | 220 | 220 | 219 | 193 | 194 | 195 | 196 | 196 | 198 | None | 197 | 199 | 201 | 200 | 202 | 203 | 204 | None | None | 205 | 204 | 207 | 206 | 208 | 209 | 210 | 216 | 212 | 211 | 218 | None | 212 | 217 | 213 | 223 | None | 222 | 223 | 222 | None | 244 | 240 | 232 | 233 | 224 | 224 | 225 | 226 | 227 | 228 | 228 | None | 229 | 230 | 239 | 237 | 243 | 241 | None | 238 | 236 | 235 | 242 | 234 | 236 | 231 | 240 | None | 245 | 250 | 249 | 244 | 248 | 246 | 247 | 251 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F690 | F690 | F635 | F635 | F690 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F690 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F602 | F690 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F605 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F602 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 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 | 1 | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1997-10-30 00:00:00 | 1995-10-31 00:00:00 | 1995-07-31 00:00:00 | 1997-07-28 00:00:00 | 1999-11-01 00:00:00 | 1998-01-29 00:00:00 | 1996-04-29 00:00:00 | 1995-04-26 00:00:00 | 1999-02-01 00:00:00 | 1998-07-29 00:00:00 | 1996-10-31 00:00:00 | 1998-10-23 00:00:00 | 1998-04-29 00:00:00 | 1996-02-01 00:00:00 | 1996-10-31 00:00:00 | 1999-04-29 00:00:00 | 1999-08-02 00:00:00 | 1996-10-31 00:00:00 | 1996-01-29 00:00:00 | 1996-07-31 00:00:00 | 1997-01-31 00:00:00 | 1997-04-29 00:00:00 | 2000-05-01 00:00:00 | 2000-01-28 00:00:00 | 2000-07-31 00:00:00 | 2000-10-31 00:00:00 | 2000-10-31 00:00:00 | 2000-12-28 00:00:00 | 2001-01-29 00:00:00 | 2001-01-25 00:00:00 | 2001-04-27 00:00:00 | 2001-04-27 00:00:00 | 2001-10-30 00:00:00 | 2001-07-30 00:00:00 | 2001-07-30 00:00:00 | 2001-07-30 00:00:00 | 2001-10-30 00:00:00 | 2002-01-30 00:00:00 | 2002-04-26 00:00:00 | 2002-01-10 00:00:00 | 2002-01-30 00:00:00 | 2002-07-31 00:00:00 | 2002-04-26 00:00:00 | 2002-07-30 00:00:00 | 2002-10-28 00:00:00 | 2002-10-28 00:00:00 | 2002-12-30 00:00:00 | 2003-01-27 00:00:00 | 2003-04-29 00:00:00 | 2003-07-24 00:00:00 | 2003-01-27 00:00:00 | 2003-04-29 00:00:00 | 2003-10-24 00:00:00 | 2003-07-24 00:00:00 | 2003-10-28 00:00:00 | 2004-01-22 00:00:00 | 2004-04-23 00:00:00 | 2004-07-28 00:00:00 | 2004-04-23 00:00:00 | 2004-07-29 00:00:00 | 2004-10-21 00:00:00 | 2004-01-26 00:00:00 | 2005-01-24 00:00:00 | 2004-10-21 00:00:00 | 2004-12-30 00:00:00 | 2005-05-02 00:00:00 | 2005-02-18 00:00:00 | 2005-01-24 00:00:00 | 2005-07-28 00:00:00 | 2005-10-31 00:00:00 | 2005-12-13 00:00:00 | 2005-02-18 00:00:00 | 2006-05-01 00:00:00 | 2006-02-01 00:00:00 | 2006-07-25 00:00:00 | 2006-10-24 00:00:00 | 2007-01-25 00:00:00 | 2007-07-23 00:00:00 | 2007-04-23 00:00:00 | 2007-01-02 00:00:00 | 2008-01-25 00:00:00 | 2007-10-25 00:00:00 | 2013-07-25 00:00:00 | 2015-04-30 00:00:00 | 2014-12-31 00:00:00 | 2013-10-30 00:00:00 | 2015-02-02 00:00:00 | 2014-12-31 00:00:00 | 2014-10-28 00:00:00 | 2008-04-29 00:00:00 | 2008-07-30 00:00:00 | 2008-10-21 00:00:00 | 2008-12-31 00:00:00 | 2009-01-22 00:00:00 | 2009-07-27 00:00:00 | 2008-12-31 00:00:00 | 2009-04-28 00:00:00 | 2009-10-23 00:00:00 | 2010-04-27 00:00:00 | 2010-01-26 00:00:00 | 2010-07-27 00:00:00 | 2010-10-26 00:00:00 | 2010-12-21 00:00:00 | 2011-01-12 00:00:00 | 2010-12-31 00:00:00 | 2011-04-26 00:00:00 | 2011-01-31 00:00:00 | 2011-10-27 00:00:00 | 2011-07-26 00:00:00 | 2012-01-25 00:00:00 | 2012-04-25 00:00:00 | 2012-07-30 00:00:00 | 2014-01-28 00:00:00 | 2012-12-13 00:00:00 | 2012-10-25 00:00:00 | 2014-07-31 00:00:00 | 2013-01-02 00:00:00 | 2013-01-29 00:00:00 | 2014-04-29 00:00:00 | 2013-04-30 00:00:00 | 2015-11-02 00:00:00 | 2015-04-27 00:00:00 | 2016-01-07 00:00:00 | 2016-01-07 00:00:00 | 2015-07-31 00:00:00 | 2020-01-21 00:00:00 | 2021-02-01 00:00:00 | 2020-01-29 00:00:00 | 2018-01-29 00:00:00 | 2018-04-27 00:00:00 | 2016-03-09 00:00:00 | 2016-01-26 00:00:00 | 2016-04-27 00:00:00 | 2016-08-01 00:00:00 | 2016-10-27 00:00:00 | 2016-12-30 00:00:00 | 2017-01-31 00:00:00 | 2016-12-30 00:00:00 | 2017-04-20 00:00:00 | 2017-07-20 00:00:00 | 2019-10-29 00:00:00 | 2019-04-29 00:00:00 | 2020-11-01 00:00:00 | 2020-04-30 00:00:00 | 2018-12-26 00:00:00 | 2019-07-30 00:00:00 | 2019-01-31 00:00:00 | 2018-10-31 00:00:00 | 2020-07-28 00:00:00 | 2018-07-20 00:00:00 | 2018-12-26 00:00:00 | 2017-10-26 00:00:00 | 2020-01-21 00:00:00 | 2021-01-22 00:00:00 | 2021-04-30 00:00:00 | 2022-08-01 00:00:00 | 2022-05-02 00:00:00 | 2021-01-22 00:00:00 | 2022-01-31 00:00:00 | 2021-08-02 00:00:00 | 2021-10-23 00:00:00 | 2022-10-31 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10006 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10005 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10002 | 10005 | 10001 | 10001 | 10005 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10006 | 10002 | 10002 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 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 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 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 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1997 | 1995 | 1995 | 1997 | 1999 | 1997 | 1995 | 1995 | 1997 | 1997 | 1995 | 1997 | 1997 | 1995 | 1995 | 1999 | 1999 | 1995 | 1995 | 1995 | 1995 | 1997 | 1999 | 1999 | 1999 | 1999 | 1999 | 2001 | 1999 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2001 | 2003 | 2003 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2005 | 2003 | 2003 | 2005 | 2005 | 2005 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2007 | 2007 | 2007 | 2007 | 2013 | 2015 | 2015 | 2013 | 2013 | 2015 | 2013 | 2007 | 2007 | 2007 | 2009 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2011 | 2011 | 2011 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2013 | 2011 | 2013 | 2013 | 2011 | 2013 | 2013 | 2015 | 2015 | 2015 | 2015 | 2015 | 2019 | 2019 | 2019 | 2017 | 2017 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2015 | 2017 | 2017 | 2017 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2017 | 2017 | 2019 | 2017 | 2019 | 2017 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | TTHAM | * | YBONILLA | * | YBONILLA | GGILMORE | * | GPEREZ | DPASTRAN | * | * | * | YBONILLA | LTHIBAUL | LTHIBAUL | * | * | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | * | LTHIBAUL | * | PBANFORD | COMPLETED | COMPLETED | COMPLETED | LTHIBAUL | LTHIBAUL | COMPLETED | LTHIBAUL | LTHIBAUL | COMPLETED | LTHIBAUL | COMPLETED | COMPLETED | LTHIBAUL | COMPLETED | LTHIBAUL | COMPLETED | LTHIBAUL | SARRIAGA | LTHIBAUL | COMPLETED | LTHIBAUL | LTHIBAUL | LTHIBAUL | SARRIAGA | GGILMORE | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | SARRIAGA | LTHIBAUL | LTHIBAUL | AGLADNEY | AGLADNEY | PBANFORD | AGLADNEY | AGLADNEY | PBANFORD | AGLADNEY | LTHIBAUL | YRODRIGU | JGRISSUM | YRODRIGU | JGRISSUM | JGRISSUM | PBANFORD | JGRISSUM | MGUERRA | ASAETERN | JINGRAM | ASAETERN | ASAETERN | YRODRIGU | GKURIMOT | YRODRIGU | AGLADNEY | AGLADNEY | ASAETERN | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | PBANFORD | AGLADNEY | AGLADNEY | PBANFORD | ASAETERN | AGLADNEY | AGLADNEY | MPACHECO | YRODRIGU | AGLADNEY | AGLADNEY | AGLADNEY | GPEREZ | GTAYLOR | GTAYLOR | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | GPEREZ | AGLADNEY | SARRIAGA | AGLADNEY | AGLADNEY | VUKSTINA | SUSHAKOV | GTAYLOR | VUKSTINA | GPEREZ | SUSHAKOV | AGLADNEY | AGLADNEY | GTAYLOR | AGLADNEY | GPEREZ | AGLADNEY | GPEREZ | MKIRKHAM | GTAYLOR | CAFILER | CAFILER | MKIRKHAM | RATTIYEH | CHATRIDGE | GTAYLOR | CAFILER | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 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 | 11002 | 11002 | 11002 | 11003 | 11002 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 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 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 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 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1997-07-01 00:00:00 | 1995-07-01 00:00:00 | 1995-04-01 00:00:00 | 1997-04-01 00:00:00 | 1999-07-01 00:00:00 | 1997-10-01 00:00:00 | 1996-01-01 00:00:00 | 1995-01-01 00:00:00 | 1998-10-01 00:00:00 | 1998-04-01 00:00:00 | 1996-07-01 00:00:00 | 1998-07-01 00:00:00 | 1998-01-01 00:00:00 | 1995-01-01 00:00:00 | 1996-01-01 00:00:00 | 1999-01-01 00:00:00 | 1999-04-01 00:00:00 | 1995-10-01 00:00:00 | 1995-10-01 00:00:00 | 1996-04-01 00:00:00 | 1996-10-01 00:00:00 | 1997-01-01 00:00:00 | 2000-01-01 00:00:00 | 1999-10-01 00:00:00 | 2000-04-01 00:00:00 | 2000-07-01 00:00:00 | 2000-07-01 00:00:00 | 1900-01-01 00:00:00 | 2000-10-01 00:00:00 | 2000-10-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-07-01 00:00:00 | 2001-04-01 00:00:00 | 2001-04-01 00:00:00 | 2001-04-01 00:00:00 | 2001-07-01 00:00:00 | 2001-10-01 00:00:00 | 2002-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-10-01 00:00:00 | 2002-04-01 00:00:00 | 2002-01-01 00:00:00 | 2002-04-01 00:00:00 | 2002-07-01 00:00:00 | 2002-07-01 00:00:00 | 1900-01-01 00:00:00 | 2002-10-01 00:00:00 | 2003-01-01 00:00:00 | 2003-04-01 00:00:00 | 2002-10-01 00:00:00 | 2003-01-01 00:00:00 | 2003-07-01 00:00:00 | 2003-04-01 00:00:00 | 2003-07-01 00:00:00 | 2003-10-01 00:00:00 | 2004-01-01 00:00:00 | 2004-04-01 00:00:00 | 2004-01-01 00:00:00 | 2004-04-01 00:00:00 | 2004-07-01 00:00:00 | 2003-10-01 00:00:00 | 2004-10-01 00:00:00 | 2004-07-01 00:00:00 | 1900-01-01 00:00:00 | 2005-01-01 00:00:00 | 2004-10-01 00:00:00 | 2004-10-01 00:00:00 | 2005-04-01 00:00:00 | 2005-07-01 00:00:00 | 1900-01-01 00:00:00 | 2004-10-01 00:00:00 | 2006-01-01 00:00:00 | 2005-10-01 00:00:00 | 2006-04-01 00:00:00 | 2006-07-01 00:00:00 | 2006-10-01 00:00:00 | 2007-04-01 00:00:00 | 2007-01-01 00:00:00 | 1900-01-01 00:00:00 | 2007-10-01 00:00:00 | 2007-07-01 00:00:00 | 2013-04-01 00:00:00 | 2015-01-01 00:00:00 | 1900-01-01 00:00:00 | 2013-07-01 00:00:00 | 2014-10-01 00:00:00 | 2014-12-31 00:00:00 | 2014-07-01 00:00:00 | 2008-01-01 00:00:00 | 2008-04-01 00:00:00 | 2008-07-01 00:00:00 | 2008-12-31 00:00:00 | 2008-10-01 00:00:00 | 2009-04-01 00:00:00 | 1900-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-07-01 00:00:00 | 2010-01-01 00:00:00 | 2009-10-01 00:00:00 | 2010-04-01 00:00:00 | 2010-07-01 00:00:00 | 2010-12-21 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2011-01-01 00:00:00 | 2010-10-01 00:00:00 | 2011-07-01 00:00:00 | 2011-04-01 00:00:00 | 2011-10-01 00:00:00 | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 2013-10-01 00:00:00 | 2012-12-13 00:00:00 | 2012-07-01 00:00:00 | 2014-04-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-07-01 00:00:00 | 1900-01-01 00:00:00 | 2015-04-01 00:00:00 | 2015-07-01 00:00:00 | 2015-04-01 00:00:00 | 1900-01-01 00:00:00 | 2020-10-01 00:00:00 | 2019-10-01 00:00:00 | 2017-10-01 00:00:00 | 2018-01-01 00:00:00 | 2015-10-01 00:00:00 | 2015-10-01 00:00:00 | 2016-01-01 00:00:00 | 2016-04-01 00:00:00 | 2016-07-01 00:00:00 | 2016-12-30 00:00:00 | 2016-10-01 00:00:00 | 1900-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-04-01 00:00:00 | 2019-07-01 00:00:00 | 2019-01-01 00:00:00 | 2020-07-01 00:00:00 | 2020-01-01 00:00:00 | 1900-01-01 00:00:00 | 2019-04-01 00:00:00 | 2018-10-01 00:00:00 | 2018-07-01 00:00:00 | 2020-04-01 00:00:00 | 2018-04-01 00:00:00 | 2018-12-26 00:00:00 | 2017-07-01 00:00:00 | 2019-12-02 00:00:00 | 1900-01-01 00:00:00 | 2021-01-01 00:00:00 | 2022-04-01 00:00:00 | 2022-01-01 00:00:00 | 2020-12-31 00:00:00 | 2021-10-01 00:00:00 | 2021-04-01 00:00:00 | 2021-07-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1997-09-30 00:00:00 | 1995-09-30 00:00:00 | 1995-06-30 00:00:00 | 1997-06-30 00:00:00 | 1999-09-30 00:00:00 | 1997-12-31 00:00:00 | 1996-03-31 00:00:00 | 1995-03-31 00:00:00 | 1998-12-31 00:00:00 | 1998-06-30 00:00:00 | 1996-09-30 00:00:00 | 1998-09-30 00:00:00 | 1998-03-31 00:00:00 | 1995-03-31 00:00:00 | 1996-03-31 00:00:00 | 1999-03-31 00:00:00 | 1999-06-30 00:00:00 | 1995-12-31 00:00:00 | 1995-12-31 00:00:00 | 1996-06-30 00:00:00 | 1996-12-31 00:00:00 | 1997-03-31 00:00:00 | 2000-03-31 00:00:00 | 1999-12-31 00:00:00 | 2000-06-30 00:00:00 | 2000-09-30 00:00:00 | 2000-09-30 00:00:00 | 1900-01-01 00:00:00 | 2000-12-31 00:00:00 | 2000-12-31 00:00:00 | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 | 2001-09-30 00:00:00 | 2001-06-30 00:00:00 | 2001-06-30 00:00:00 | 2001-06-30 00:00:00 | 2001-09-30 00:00:00 | 2001-12-31 00:00:00 | 2002-03-31 00:00:00 | 2001-03-31 00:00:00 | 2001-12-31 00:00:00 | 2002-06-30 00:00:00 | 2002-03-31 00:00:00 | 2002-06-30 00:00:00 | 2002-09-30 00:00:00 | 2002-09-30 00:00:00 | 1900-01-01 00:00:00 | 2002-12-31 00:00:00 | 2003-03-31 00:00:00 | 2003-06-30 00:00:00 | 2002-12-31 00:00:00 | 2003-03-31 00:00:00 | 2003-09-30 00:00:00 | 2003-06-30 00:00:00 | 2003-09-30 00:00:00 | 2003-12-31 00:00:00 | 2004-03-31 00:00:00 | 2004-06-30 00:00:00 | 2004-03-31 00:00:00 | 2004-06-30 00:00:00 | 2004-09-30 00:00:00 | 2003-12-31 00:00:00 | 2004-12-31 00:00:00 | 2004-09-30 00:00:00 | 1900-01-01 00:00:00 | 2005-03-31 00:00:00 | 2004-12-31 00:00:00 | 2004-12-31 00:00:00 | 2005-06-30 00:00:00 | 2005-09-30 00:00:00 | 1900-01-01 00:00:00 | 2004-12-31 00:00:00 | 2006-03-31 00:00:00 | 2005-12-31 00:00:00 | 2006-06-30 00:00:00 | 2006-09-30 00:00:00 | 2006-12-31 00:00:00 | 2007-06-30 00:00:00 | 2007-03-31 00:00:00 | 1900-01-01 00:00:00 | 2007-12-31 00:00:00 | 2007-09-30 00:00:00 | 2013-06-30 00:00:00 | 2015-03-31 00:00:00 | 1900-01-01 00:00:00 | 2013-09-30 00:00:00 | 2014-12-31 00:00:00 | 2014-12-31 00:00:00 | 2014-09-30 00:00:00 | 2008-03-31 00:00:00 | 2008-06-30 00:00:00 | 2008-09-30 00:00:00 | 2008-12-31 00:00:00 | 2008-12-31 00:00:00 | 2009-06-30 00:00:00 | 1900-01-01 00:00:00 | 2009-03-31 00:00:00 | 2009-09-30 00:00:00 | 2010-03-31 00:00:00 | 2009-12-31 00:00:00 | 2010-06-30 00:00:00 | 2010-09-30 00:00:00 | 2010-12-21 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2011-03-31 00:00:00 | 2010-12-31 00:00:00 | 2011-09-30 00:00:00 | 2011-06-30 00:00:00 | 2011-12-31 00:00:00 | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 2013-12-31 00:00:00 | 2012-12-13 00:00:00 | 2012-09-30 00:00:00 | 2014-06-30 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-09-30 00:00:00 | 1900-01-01 00:00:00 | 2015-06-30 00:00:00 | 2015-09-30 00:00:00 | 2015-06-30 00:00:00 | 1900-01-01 00:00:00 | 2020-12-31 00:00:00 | 2019-12-31 00:00:00 | 2017-12-31 00:00:00 | 2018-03-31 00:00:00 | 2015-12-31 00:00:00 | 2015-12-31 00:00:00 | 2016-03-31 00:00:00 | 2016-06-30 00:00:00 | 2016-09-30 00:00:00 | 2016-12-30 00:00:00 | 2016-12-31 00:00:00 | 1900-01-01 00:00:00 | 2017-03-31 00:00:00 | 2017-06-30 00:00:00 | 2019-09-30 00:00:00 | 2019-03-31 00:00:00 | 2020-09-30 00:00:00 | 2020-03-31 00:00:00 | 1900-01-01 00:00:00 | 2019-06-30 00:00:00 | 2018-12-31 00:00:00 | 2018-09-30 00:00:00 | 2020-06-30 00:00:00 | 2018-06-30 00:00:00 | 2018-12-26 00:00:00 | 2017-09-30 00:00:00 | 2019-12-02 00:00:00 | 1900-01-01 00:00:00 | 2021-03-31 00:00:00 | 2022-06-30 00:00:00 | 2022-03-31 00:00:00 | 2020-12-31 00:00:00 | 2021-12-31 00:00:00 | 2021-06-30 00:00:00 | 2021-09-30 00:00:00 | 2022-09-30 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 22001 | 22001 | None | None | 22001 | None | None | 22001 | None | 22001 | 22001 | None | 22001 | None | 22001 | None | None | 22001 | 22001 | None | 22001 | 22001 | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | None | 22001 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22001 | 22001 | None | 22006 | 22006 | 22006 | 22001 | 22006 | 22006 | 22006 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 |
filer_id | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 2003 | 2001 | 1999 | 1997 | 1995 | 2005 | 2013 | 2009 | 2007 | 2011 | 2017 | 2019 | 2015 | 2021 | 2023 | |||||||||||||||
interest_cd | 40315 | 40315 | 40315 | 40315 | 40315 | 40315 | 40315 | 40315 | 40315 | 40315 | 40315 | 40315 | 40315 | 40312 | 40312 | |||||||||||||||
effect_date | 2003-01-01 00:00:00 | 2001-01-01 00:00:00 | 1999-01-01 00:00:00 | 1997-01-01 00:00:00 | 1995-01-01 00:00:00 | 2005-01-01 00:00:00 | 2013-01-01 00:00:00 | 2009-01-01 00:00:00 | 2007-01-01 00:00:00 | 2011-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-01 00:00:00 | 2023-01-01 00:00:00 |
filer_id | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||||||||||||||
active | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | N | |||||||||||||||
race | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
session_id | 1995 | 1999 | 1997 | 2001 | 2003 | 2005 | 2007 | 2011 | 2013 | 2009 | 2015 | 2021 | 2019 | 2017 | 2023 | |||||||||||||||
category | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
category_type | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
sub_category | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
effect_dt | 1995-01-01 00:00:00 | 1999-01-01 00:00:00 | 1997-01-01 00:00:00 | 2001-01-01 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2011-01-01 00:00:00 | 2013-01-01 00:00:00 | 2009-01-01 00:00:00 | 2015-01-01 00:00:00 | 2021-01-01 00:00:00 | 2019-01-01 00:00:00 | 2017-01-01 00:00:00 | 2023-01-01 00:00:00 | |||||||||||||||
sub_category_type | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
election_type | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
sub_category_a | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
nyq_dt | None | None | None | None | None | 2000-07-01 00:00:00 | 2000-07-01 00:00:00 | None | None | None | None | None | None | None | None | |||||||||||||||
party_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
county_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
district_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1143393 | |
---|---|---|
xref_id | C21512 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | C21512 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | 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 | 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 | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTOR'S ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 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 | 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 | 95814 | 958159988 | 958159988 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95814 | 958159988 | 958159988 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95814 | 958159988 | 958159988 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95814 | 958159988 | 958159988 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95814 | 958159988 | 958159988 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95814 | 958159988 | 958159988 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95814 | 958159988 | 958159988 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95814 | 958159988 | 958159988 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95814 | 958159988 | 958159988 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95814 | 958159988 | 958159988 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95814 | 958159988 | 958159988 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95814 | 958159988 | 958159988 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | 95815 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9168302780 | 9168302780 | 9168302780 | 9168302780 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9168302780 | 9168302780 | 9168302780 | 9168302780 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9168302780 | 9168302780 | 9168302780 | 9168302780 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9168302780 | 9168302780 | 9168302780 | 9168302780 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9168302780 | 9168302780 | 9168302780 | 9168302780 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9168302780 | 9168302780 | 9168302780 | 9168302780 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9168302780 | 9168302780 | 9168302780 | 9168302780 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9168302780 | 9168302780 | 9168302780 | 9168302780 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9168302780 | 9168302780 | 9168302780 | 9168302780 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9168302780 | 9168302780 | 9168302780 | 9168302780 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9168302780 | 9168302780 | 9168302780 | 9168302780 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9164482522 | 9168302780 | 9168302780 | 9168302780 | 9168302780 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 1143393 |
---|
filer_id | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
change_no | 1 | 2 | 3 | 0 | 4 | 5 | 6 | |||||||
session_id | 2001 | 2001 | 2001 | 2005 | 2005 | 2005 | 2019 | |||||||
log_dt | 2001-10-02 00:00:00 | 2001-10-02 00:00:00 | 2001-10-01 00:00:00 | 2006-01-12 00:00:00 | 2006-01-12 00:00:00 | 2006-02-16 00:00:00 | 2020-02-05 00:00:00 | |||||||
filer_type | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||||||
correction_flg | None | None | Y | None | None | None | None | |||||||
action | CHANGED | CHANGED | CHANGED | ADDED | IN SUSPENSE | SET ACTIVE | DELETED | |||||||
attribute_changed | ADDRESS AND PHONE | None | ADDRESS | FIRM | FIRM | FIRM | FIRM | |||||||
ethics_dt | None | None | None | None | None | None | None | |||||||
interests | None | None | None | None | None | None | None | |||||||
filer_full_name | FILER INFORMATION | FILER INFORMATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | CALIFORNIA LANDSCAPE CONTRACTORS ASSOCIATION | |||||||
filer_city | SACRAMENTO | SACRAMENTO | SACRAMENTO | None | None | None | None | |||||||
filer_st | CA | CA | CA | None | None | None | None | |||||||
filer_zip | 958159988 | 958159988 | 95814 | None | None | None | None | |||||||
filer_phone | 9164482522 | 9164482522 | 9164482522 | None | None | None | None | |||||||
entity_type | 1 | 1 | None | 3 | 3 | 3 | 3 | |||||||
entity_name | None | None | None | GREENBERG TRAURIG, LLP | GREENBERG TRAURIG, LLP | GREENBERG TRAURIG, LLP | GREENBERG TRAURIG, LLP | |||||||
entity_city | None | None | None | None | None | None | None | |||||||
entity_st | None | None | None | None | None | None | None | |||||||
entity_zip | None | None | None | None | None | None | None | |||||||
entity_phone | None | None | None | None | None | None | None | |||||||
entity_id | 0 | 0 | None | 1276988 | 1276988 | 1276988 | 1276988 | |||||||
responsible_officer | None | None | None | None | None | None | None | |||||||
effect_dt | 2001-10-02 00:00:00 | 2001-09-05 00:00:00 | 2001-09-05 00:00:00 | 2005-10-10 00:00:00 | 2005-10-10 00:00:00 | 2005-10-10 00:00:00 | 2019-12-31 00:00:00 |
filer_id | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | 1143393 | |||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 682091_0.cal | 715799_0.cal | 744573_0.cal | 771826_0.cal | 790740_0.cal | 812510_0.cal | 837789_0.cal | 853731_0.cal | 880991_0.cal | 906445_0.cal | 929992_0.cal | 943998_0.cal | 966932_0.cal | 984726_0.cal | 1010695_0.cal | 1027153_0.cal | 1050386_0.cal | 1074453_0.cal | 1105308_0.cal | 1074453_1.cal | 1116480_0.cal | 1133791_0.cal | 2482311_0.cal | 2470758_0.cal | 2708339_0.cal | 2529673_0.cal | 2603189_0.cal | 2677108_0.cal | 2749267_0.cal | 2645243_0.cal | 2554344_0.cal | 2581782_0.cal | 2618478_0.cal | |||||||||||||||||||||||||||||||||
received_date | 2000-10-31 00:00:00 | 2001-01-29 00:00:00 | 2001-04-27 00:00:00 | 2001-07-30 00:00:00 | 2001-10-30 00:00:00 | 2002-01-30 00:00:00 | 2002-04-26 00:00:00 | 2002-07-30 00:00:00 | 2002-10-28 00:00:00 | 2003-01-27 00:00:00 | 2003-04-29 00:00:00 | 2003-07-24 00:00:00 | 2003-10-24 00:00:00 | 2004-01-22 00:00:00 | 2004-04-23 00:00:00 | 2004-07-28 00:00:00 | 2004-10-21 00:00:00 | 2005-01-24 00:00:00 | 2005-05-02 00:00:00 | 2005-02-18 00:00:00 | 2005-07-28 00:00:00 | 2005-10-31 00:00:00 | 2020-07-28 00:00:00 | 2020-04-30 00:00:00 | 2022-08-01 00:00:00 | 2020-11-01 00:00:00 | 2021-08-02 00:00:00 | 2022-05-02 00:00:00 | 2022-10-31 00:00:00 | 2022-01-31 00:00:00 | 2021-02-01 00:00:00 | 2021-04-30 00:00:00 | 2021-10-23 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 | /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/cal | |||||||||||||||||||||||||||||||||
filing_id | 682091 | 715799 | 744573 | 771826 | 790740 | 812510 | 837789 | 853731 | 880991 | 906445 | 929992 | 943998 | 966932 | 984726 | 1010695 | 1027153 | 1050386 | 1074453 | 1105308 | 1074453 | 1116480 | 1133791 | 2482311 | 2470758 | 2708339 | 2529673 | 2603189 | 2677108 | 2749267 | 2645243 | 2554344 | 2581782 | 2618478 | |||||||||||||||||||||||||||||||||
form_id | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | |||||||||||||||||||||||||||||||||
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 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 |