acronym | CalTrout | |
---|---|---|
filer_id | 1144395 |
filer_id | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1111887 | 1110313 | 2097618 | 2113075 | 2178999 | 2207906 | 2415901 | 2546383 | 2275945 | 2509116 | 2342758 | 2472492 | ||||||||||||
effect_dt | 1995-02-02 00:00:00 | 1999-01-01 00:00:00 | 2006-02-01 00:00:00 | 2007-01-01 00:00:00 | 2010-02-01 00:00:00 | 2011-01-01 00:00:00 | 2017-01-01 00:00:00 | 2023-01-01 00:00:00 | 2013-01-01 00:00:00 | 2021-04-01 00:00:00 | 2015-01-01 00:00:00 | 2019-01-01 00:00:00 | ||||||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | ||||||||||||
session_id | 1995 | 1999 | 2005 | 2007 | 2009 | 2011 | 2017 | 2023 | 2013 | 2021 | 2015 | 2019 |
filer_id | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 497228 | 488985 | 486220 | 492673 | 496307 | 485377 | 541231 | 477089 | 488985 | 493610 | 540832 | 468977 | 470774 | 471537 | 474511 | 476301 | 481852 | 465533 | 492673 | 466284 | 482638 | 629350 | 616197 | 659690 | 696378 | 741816 | 1149988 | 1166011 | 1166011 | 1184852 | 1215844 | 1229548 | 1236168 | 1261187 | 1277832 | 1292993 | 1297287 | 1781120 | 1981307 | 1870157 | 1800054 | 1936625 | 1948796 | 1948808 | 1909439 | 1310247 | 1330355 | 1349679 | 1392613 | 1375687 | 1469924 | 1484454 | 1468879 | 1506344 | 1545850 | 1538576 | 1570195 | 1561191 | 1636063 | 1591107 | 1622495 | 1606774 | 1657469 | 1675599 | 1816687 | 1931090 | 1921337 | 1919979 | 1714964 | 1707433 | 1727224 | 1738145 | 1845580 | 1764109 | 1966209 | 2243109 | 2394415 | 2554252 | 2315520 | 2379524 | 2277090 | 2344280 | 1997682 | 2010493 | 2035896 | 2060954 | 2060954 | 2101506 | 2115559 | 2130298 | 2141371 | 2157355 | 2417334 | 2177311 | 2394415 | 2205261 | 2468840 | 2530050 | 2428674 | 2315520 | 2361291 | 2537350 | 2330772 | 2379524 | 2344280 | 2438993 | 2192417 | 2428343 | 2603948 | 2581234 | 2678336 | 2486417 | 2557878 | 2625203 | 2589372 | 2584103 | 2645605 | 2678336 | 2593681 | 2653845 | 2647507 | 2605834 | 2707647 | 2645605 | 2589372 | 2749581 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 156 | 146 | 153 | 147 | 148 | 145 | 154 | 151 | 146 | 155 | 159 | 157 | 142 | 150 | 158 | 143 | 144 | 141 | 147 | 149 | 152 | None | 160 | 162 | 163 | 164 | None | 185 | 185 | 186 | 187 | None | 188 | 189 | 190 | None | 191 | 214 | 222 | 218 | 215 | 220 | None | None | 219 | 192 | 193 | 194 | 196 | 195 | None | 201 | 201 | 202 | 204 | 203 | 204 | None | 208 | 205 | 207 | 206 | 209 | 210 | 216 | 220 | 220 | 220 | 212 | 211 | None | 212 | 217 | 213 | 221 | 233 | 238 | 244 | 235 | 237 | 234 | 236 | 223 | 224 | 225 | 226 | 226 | 227 | 228 | 228 | None | 229 | 239 | 230 | 238 | 232 | 241 | 243 | None | 235 | None | 244 | 236 | 237 | 236 | 240 | 231 | 240 | 246 | 245 | 249 | 242 | None | 247 | 246 | 245 | 248 | 249 | None | None | 249 | None | 250 | 248 | 251 | 251 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F690 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F690 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F603 | F635 | F635 | F635 | F635 | F603 | F635 | F635 | F635 | F666 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F602 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F602 | F602 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F602 | F635 | F603 | F602 | F635 | F635 | F603 | F602 | F602 | F602 | F635 | F635 | F603 | F635 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 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 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1999-02-01 00:00:00 | 1996-07-31 00:00:00 | 1998-04-30 00:00:00 | 1996-10-31 00:00:00 | 1997-01-31 00:00:00 | 1996-04-30 00:00:00 | 1998-07-31 00:00:00 | 1997-10-31 00:00:00 | 1997-01-17 00:00:00 | 1998-11-02 00:00:00 | 1999-11-01 00:00:00 | 1999-04-30 00:00:00 | 1995-07-31 00:00:00 | 1997-07-31 00:00:00 | 1999-08-02 00:00:00 | 1995-10-31 00:00:00 | 1996-01-31 00:00:00 | 1995-05-01 00:00:00 | 1997-01-17 00:00:00 | 1997-04-30 00:00:00 | 1998-02-02 00:00:00 | 2000-05-01 00:00:00 | 2000-01-31 00:00:00 | 2000-07-31 00:00:00 | 2000-10-31 00:00:00 | 2001-02-06 00:00:00 | 2006-02-01 00:00:00 | 2006-04-27 00:00:00 | 2006-04-27 00:00:00 | 2006-07-18 00:00:00 | 2006-10-30 00:00:00 | 2006-12-26 00:00:00 | 2007-01-30 00:00:00 | 2007-04-29 00:00:00 | 2007-07-18 00:00:00 | 2007-08-31 00:00:00 | 2007-10-31 00:00:00 | 2013-07-30 00:00:00 | 2015-07-30 00:00:00 | 2014-07-30 00:00:00 | 2013-10-30 00:00:00 | 2015-02-02 00:00:00 | 2014-12-31 00:00:00 | 2014-12-22 00:00:00 | 2014-10-30 00:00:00 | 2008-01-30 00:00:00 | 2008-04-30 00:00:00 | 2008-07-30 00:00:00 | 2009-01-27 00:00:00 | 2008-10-29 00:00:00 | 2010-02-17 00:00:00 | 2010-04-29 00:00:00 | 2010-02-10 00:00:00 | 2010-07-30 00:00:00 | 2010-11-19 00:00:00 | 2010-10-29 00:00:00 | 2011-01-31 00:00:00 | 2010-12-22 00:00:00 | 2012-01-31 00:00:00 | 2011-04-30 00:00:00 | 2011-10-31 00:00:00 | 2011-07-29 00:00:00 | 2012-04-30 00:00:00 | 2012-07-27 00:00:00 | 2014-01-30 00:00:00 | 2015-01-27 00:00:00 | 2014-12-29 00:00:00 | 2014-12-22 00:00:00 | 2012-11-28 00:00:00 | 2012-10-30 00:00:00 | 2012-12-21 00:00:00 | 2013-01-31 00:00:00 | 2014-04-30 00:00:00 | 2013-04-29 00:00:00 | 2015-04-30 00:00:00 | 2018-04-30 00:00:00 | 2019-07-28 00:00:00 | 2021-02-01 00:00:00 | 2019-02-19 00:00:00 | 2019-04-29 00:00:00 | 2018-07-31 00:00:00 | 2019-01-29 00:00:00 | 2015-11-01 00:00:00 | 2016-01-29 00:00:00 | 2016-04-29 00:00:00 | 2016-07-29 00:00:00 | 2017-01-16 00:00:00 | 2016-10-31 00:00:00 | 2016-12-29 00:00:00 | 2017-01-31 00:00:00 | 2017-02-16 00:00:00 | 2017-05-01 00:00:00 | 2019-10-29 00:00:00 | 2017-07-31 00:00:00 | 2019-08-12 00:00:00 | 2018-01-25 00:00:00 | 2020-04-29 00:00:00 | 2020-11-02 00:00:00 | 2020-01-06 00:00:00 | 2018-10-29 00:00:00 | 2018-12-27 00:00:00 | 2020-12-17 00:00:00 | 2018-12-28 00:00:00 | 2019-08-12 00:00:00 | 2019-08-12 00:00:00 | 2020-01-29 00:00:00 | 2017-10-30 00:00:00 | 2020-01-06 00:00:00 | 2021-08-02 00:00:00 | 2021-04-30 00:00:00 | 2022-05-18 00:00:00 | 2020-07-31 00:00:00 | 2020-12-17 00:00:00 | 2021-11-01 00:00:00 | 2021-06-23 00:00:00 | 2021-05-14 00:00:00 | 2022-01-31 00:00:00 | 2022-05-02 00:00:00 | 2021-05-06 00:00:00 | 2022-02-14 00:00:00 | 2022-02-04 00:00:00 | 2021-03-26 00:00:00 | 2022-08-01 00:00:00 | 2022-11-10 00:00:00 | 2022-11-01 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 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10001 | 10002 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10002 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10002 | 10002 | 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 | 11003 | 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 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1997 | 1995 | 1997 | 1995 | 1995 | 1995 | 1997 | 1997 | 1995 | 1997 | 1999 | 1999 | 1995 | 1997 | 1999 | 1995 | 1995 | 1995 | 1995 | 1997 | 1997 | 1999 | 1999 | 1999 | 1999 | 1999 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2005 | 2007 | 2007 | 2005 | 2007 | 2013 | 2015 | 2013 | 2013 | 2013 | 2015 | 2013 | 2013 | 2007 | 2007 | 2007 | 2007 | 2007 | 2009 | 2009 | 2009 | 2009 | 2011 | 2009 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2013 | 2015 | 2013 | 2013 | 2011 | 2013 | 2011 | 2013 | 2013 | 2015 | 2017 | 2019 | 2019 | 2017 | 2019 | 2017 | 2017 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2015 | 2017 | 2017 | 2019 | 2017 | 2019 | 2017 | 2019 | 2019 | 2019 | 2017 | 2019 | 2021 | 2019 | 2019 | 2017 | 2019 | 2017 | 2019 | 2021 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2022 | 2021 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | TTHAM | * | YBONILLA | YBONILLA | YBONILLA | CFLAGG | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | GPEREZ | LTHIBAUL | LTHIBAUL | LTHIBAUL | NLANDERS | LTHIBAUL | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | MPACHECO | YRODRIGU | YRODRIGU | AGLADNEY | LTHIBAUL | LTHIBAUL | YRODRIGU | JINGRAM | JINGRAM | YRODRIGU | ASAETERN | YRODRIGU | ASAETERN | PBANFORD | ASAETERN | AGLADNEY | PBANFORD | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | ASAETERN | MPACHECO | YRODRIGU | YRODRIGU | YRODRIGU | AGLADNEY | GPEREZ | ASAETERN | AGLADNEY | ASAETERN | AGLADNEY | AGLADNEY | GTAYLOR | MKIRKHAM | AGLADNEY | GTAYLOR | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | SARRIAGA | AGLADNEY | SARRIAGA | AGLADNEY | VUKSTINA | AGLADNEY | GTAYLOR | AGLADNEY | GTAYLOR | MKIRKHAM | SARRIAGA | AGLADNEY | GPEREZ | MMERCHANT | GPEREZ | GTAYLOR | GTAYLOR | GTAYLOR | AGLADNEY | SARRIAGA | GTAYLOR | GTAYLOR | CAFILER | MKIRKHAM | MMERCHANT | GTAYLOR | CAFILER | CAFILER | CHATRIDGE | CAFILER | JMENDOZA | CVANLIEW | CVANLIEW | CVANLIEW | CAFILER | CAFILER | CAFILER | CAFILER | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 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 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 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 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1998-10-01 00:00:00 | 1996-04-01 00:00:00 | 1998-01-01 00:00:00 | 1996-07-01 00:00:00 | 1996-10-01 00:00:00 | 1996-01-01 00:00:00 | 1998-04-01 00:00:00 | 1997-07-01 00:00:00 | 1996-04-01 00:00:00 | 1998-07-01 00:00:00 | 1999-07-01 00:00:00 | 1999-01-01 00:00:00 | 1995-04-01 00:00:00 | 1997-04-01 00:00:00 | 1999-04-01 00:00:00 | 1995-07-01 00:00:00 | 1995-10-01 00:00:00 | 1995-01-01 00:00:00 | 1996-07-01 00:00:00 | 1997-01-01 00:00:00 | 1997-10-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-10-01 00:00:00 | 1900-01-01 00:00:00 | 2006-01-01 00:00:00 | 2006-01-01 00:00:00 | 2006-04-01 00:00:00 | 2006-07-01 00:00:00 | 1900-01-01 00:00:00 | 2006-10-01 00:00:00 | 2007-01-01 00:00:00 | 2007-04-01 00:00:00 | 2006-01-01 00:00:00 | 2007-07-01 00:00:00 | 2013-04-01 00:00:00 | 2015-04-01 00:00:00 | 2014-04-01 00:00:00 | 2013-07-01 00:00:00 | 2014-12-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2014-07-01 00:00:00 | 2007-10-01 00:00:00 | 2008-01-01 00:00:00 | 2008-04-01 00:00:00 | 2008-10-01 00:00:00 | 2008-07-01 00:00:00 | 1900-01-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-10 00:00:00 | 2010-04-01 00:00:00 | 2010-11-19 00:00:00 | 2010-07-01 00:00:00 | 2010-10-01 00:00:00 | 1900-01-01 00:00:00 | 2011-10-01 00:00:00 | 2011-01-01 00:00:00 | 2011-07-01 00:00:00 | 2011-04-01 00:00:00 | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 2013-10-01 00:00:00 | 2014-10-01 00:00:00 | 2014-12-29 00:00:00 | 2014-12-22 00:00:00 | 2012-11-28 00:00:00 | 2012-07-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-01-01 00:00:00 | 2018-01-01 00:00:00 | 2019-04-01 00:00:00 | 2020-10-01 00:00:00 | 2018-07-01 00:00:00 | 2019-01-01 00:00:00 | 2018-04-01 00:00:00 | 2018-10-01 00:00:00 | 2015-07-01 00:00:00 | 2015-10-01 00:00:00 | 2016-01-01 00:00:00 | 2016-04-01 00:00:00 | 2016-04-01 00:00:00 | 2016-07-01 00:00:00 | 2016-12-29 00:00:00 | 2016-10-01 00:00:00 | 1900-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-07-01 00:00:00 | 2017-04-01 00:00:00 | 2019-04-01 00:00:00 | 2017-10-01 00:00:00 | 2020-01-01 00:00:00 | 2020-07-01 00:00:00 | 1900-01-01 00:00:00 | 2018-07-01 00:00:00 | 1900-01-01 00:00:00 | 2020-11-16 00:00:00 | 2018-12-28 00:00:00 | 2019-01-01 00:00:00 | 2018-10-01 00:00:00 | 2019-10-01 00:00:00 | 2017-07-01 00:00:00 | 2019-12-31 00:00:00 | 2021-04-01 00:00:00 | 2021-01-01 00:00:00 | 2022-01-01 00:00:00 | 2020-04-01 00:00:00 | 1900-01-01 00:00:00 | 2021-07-01 00:00:00 | 2021-04-06 00:00:00 | 2021-02-17 00:00:00 | 2021-10-01 00:00:00 | 2022-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2022-01-19 00:00:00 | 1900-01-01 00:00:00 | 2022-04-01 00:00:00 | 2021-10-01 00:00:00 | 2022-08-04 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1998-12-31 00:00:00 | 1996-06-30 00:00:00 | 1998-03-31 00:00:00 | 1996-09-30 00:00:00 | 1996-12-31 00:00:00 | 1996-03-31 00:00:00 | 1998-06-30 00:00:00 | 1997-09-30 00:00:00 | 1996-06-30 00:00:00 | 1998-09-30 00:00:00 | 1999-09-30 00:00:00 | 1999-03-31 00:00:00 | 1995-06-30 00:00:00 | 1997-06-30 00:00:00 | 1999-06-30 00:00:00 | 1995-09-30 00:00:00 | 1995-12-31 00:00:00 | 1995-03-31 00:00:00 | 1996-09-30 00:00:00 | 1997-03-31 00:00:00 | 1997-12-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-12-31 00:00:00 | 1900-01-01 00:00:00 | 2006-03-31 00:00:00 | 2006-03-31 00:00:00 | 2006-06-30 00:00:00 | 2006-09-30 00:00:00 | 1900-01-01 00:00:00 | 2006-12-31 00:00:00 | 2007-03-31 00:00:00 | 2007-06-30 00:00:00 | 2006-12-31 00:00:00 | 2007-09-30 00:00:00 | 2013-06-30 00:00:00 | 2015-06-30 00:00:00 | 2014-06-30 00:00:00 | 2013-09-30 00:00:00 | 2014-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2014-09-30 00:00:00 | 2007-12-31 00:00:00 | 2008-03-31 00:00:00 | 2008-06-30 00:00:00 | 2008-12-31 00:00:00 | 2008-09-30 00:00:00 | 1900-01-01 00:00:00 | 2010-03-30 00:00:00 | 2010-02-10 00:00:00 | 2010-06-30 00:00:00 | 2010-11-19 00:00:00 | 2010-09-30 00:00:00 | 2010-12-31 00:00:00 | 1900-01-01 00:00:00 | 2011-12-31 00:00:00 | 2011-03-31 00:00:00 | 2011-09-30 00:00:00 | 2011-06-30 00:00:00 | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 2013-12-31 00:00:00 | 2014-12-31 00:00:00 | 2014-12-29 00:00:00 | 2014-12-22 00:00:00 | 2012-11-28 00:00:00 | 2012-09-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-03-31 00:00:00 | 2018-03-31 00:00:00 | 2019-06-30 00:00:00 | 2020-12-31 00:00:00 | 2018-09-30 00:00:00 | 2019-03-31 00:00:00 | 2018-06-30 00:00:00 | 2018-12-31 00:00:00 | 2015-09-30 00:00:00 | 2015-12-31 00:00:00 | 2016-03-31 00:00:00 | 2106-06-30 00:00:00 | 2016-06-30 00:00:00 | 2016-09-30 00:00:00 | 2016-12-29 00:00:00 | 2016-12-31 00:00:00 | 1900-01-01 00:00:00 | 2017-03-31 00:00:00 | 2019-09-30 00:00:00 | 2017-06-30 00:00:00 | 2019-06-30 00:00:00 | 2017-12-31 00:00:00 | 2020-03-31 00:00:00 | 2020-09-30 00:00:00 | 1900-01-01 00:00:00 | 2018-09-30 00:00:00 | 1900-01-01 00:00:00 | 2020-11-16 00:00:00 | 2018-12-28 00:00:00 | 2019-03-31 00:00:00 | 2018-12-31 00:00:00 | 2019-12-31 00:00:00 | 2017-09-30 00:00:00 | 2019-12-31 00:00:00 | 2021-06-30 00:00:00 | 2021-03-31 00:00:00 | 2022-03-31 00:00:00 | 2020-06-30 00:00:00 | 1900-01-01 00:00:00 | 2021-09-30 00:00:00 | 2021-04-06 00:00:00 | 2021-02-17 00:00:00 | 2021-12-31 00:00:00 | 2022-03-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2022-01-19 00:00:00 | 1900-01-01 00:00:00 | 2022-06-30 00:00:00 | 2021-12-31 00:00:00 | 2022-08-04 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | None | 22006 | 22001 | 22006 | 22001 | 22001 | 22006 | None | None | 22001 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22001 | 22001 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22001 | 22001 | 22006 | 22006 | 22006 | 22001 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22001 | 22001 | None | 22006 | None | 22001 | 22006 | 22006 | 22006 | 22006 | 22006 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | None | 22001 | 22001 | 22001 | 22001 |
filer_id | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 1999 | 1997 | 1995 | 2007 | 2013 | 2005 | 2009 | 2011 | 2019 | 2017 | 2015 | 2023 | 2021 | |||||||||||||
interest_cd | 40312 | 40312 | 40312 | 40312 | 40312 | 40312 | 40312 | 40312 | 40312 | 40312 | 40312 | 40312 | 40312 | |||||||||||||
effect_date | 1999-01-01 00:00:00 | 1997-01-01 00:00:00 | 1995-02-02 00:00:00 | 2007-01-01 00:00:00 | 2013-01-01 00:00:00 | 2006-02-01 00:00:00 | 2010-02-01 00:00:00 | 2011-01-01 00:00:00 | 2019-01-01 00:00:00 | 2017-01-01 00:00:00 | 2015-01-01 00:00:00 | 2023-01-01 00:00:00 | 2021-04-01 00:00:00 |
filer_id | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 1 | 1 | 1 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 2 | ||||||||||||||||
active | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | T | Y | N | ||||||||||||||||
race | 0 | 0 | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | 0 | None | None | ||||||||||||||||
session_id | 1995 | 1999 | 1997 | 2005 | 2007 | 2009 | 2013 | 2011 | 2019 | 2015 | 2017 | 2021 | 2021 | 2021 | 2021 | 2023 | ||||||||||||||||
category | 0 | 0 | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | 0 | None | None | ||||||||||||||||
category_type | 0 | 0 | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | 0 | None | None | ||||||||||||||||
sub_category | 0 | 0 | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | 0 | None | None | ||||||||||||||||
effect_dt | 1995-02-02 00:00:00 | 1999-01-01 00:00:00 | 1997-01-01 00:00:00 | 2006-02-01 00:00:00 | 2007-01-01 00:00:00 | 2010-02-01 00:00:00 | 2013-01-01 00:00:00 | 2011-01-01 00:00:00 | 2019-01-01 00:00:00 | 2015-01-01 00:00:00 | 2017-01-01 00:00:00 | 2021-04-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-12 00:00:00 | 2021-02-17 00:00:00 | 2023-01-01 00:00:00 | ||||||||||||||||
sub_category_type | 0 | 0 | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | 0 | None | None | ||||||||||||||||
election_type | 0 | 0 | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | 0 | None | None | ||||||||||||||||
sub_category_a | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||
nyq_dt | None | None | None | 2006-01-01 00:00:00 | 2006-01-01 00:00:00 | 2006-01-01 00:00:00 | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||
party_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | 0 | None | None | ||||||||||||||||
county_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | 0 | None | None | ||||||||||||||||
district_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | 0 | None | None |
filer_id | 1144395 | |
---|---|---|
xref_id | C25788 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | C25788 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_type | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT, INC. | CALIFORNIA TROUT, INC. | CALIFORNIA TROUT, INC. | CALIFORNIA TROUT, INC. | CALIFORNIA TROUT, INC. | CALIFORNIA TROUT, INC. | CALIFORNIA TROUT, INC. | CALIFORNIA TROUT, INC. | CALIFORNIA TROUT, INC. | CALIFORNIA TROUT, INC. | CALIFORNIA TROUT, INC. | CALIFORNIA TROUT, INC. | CALIFORNIA TROUT, INC. | CALIFORNIA TROUT, INC. | CALIFORNIA TROUT, INC. | CALIFORNIA TROUT, INC. | CALIFORNIA TROUT, INC. | CALIFORNIA TROUT, INC. | CALIFORNIA TROUT, INC. | CALIFORNIA TROUT, INC. | CALIFORNIA TROUT, INC. | CALIFORNIA TROUT, INC. | CALIFORNIA TROUT, INC. | CALIFORNIA TROUT, INC. | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | CALIFORNIA TROUT | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | SAN FRANCISCO | San Franciaso | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | San Franciaso | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | San Franciaso | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | San Franciaso | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | San Franciaso | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | San Franciaso | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | San Franciaso | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | San Franciaso | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | San Franciaso | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | San Franciaso | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | San Franciaso | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | San Franciaso | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | San Franciaso | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | SAN FRANCISCO | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 94102 | 94102 | 94102 | 94102 | 94102 | 94102 | 94104 | 94104 | 94104 | 94104 | 94104 | 94104 | 94102 | 94102 | 94102 | 94102 | 94102 | 94102 | 94104 | 94104 | 94104 | 94104 | 94104 | 94104 | 94102 | 94102 | 94102 | 94102 | 94102 | 94102 | 94104 | 94104 | 94104 | 94104 | 94104 | 94104 | 94102 | 94102 | 94102 | 94102 | 94102 | 94102 | 94104 | 94104 | 94104 | 94104 | 94104 | 94104 | 94102 | 94102 | 94102 | 94102 | 94102 | 94102 | 94104 | 94104 | 94104 | 94104 | 94104 | 94104 | 94102 | 94102 | 94102 | 94102 | 94102 | 94102 | 94104 | 94104 | 94104 | 94104 | 94104 | 94104 | 94102 | 94102 | 94102 | 94102 | 94102 | 94102 | 94104 | 94104 | 94104 | 94104 | 94104 | 94104 | 94102 | 94102 | 94102 | 94102 | 94102 | 94102 | 94104 | 94104 | 94104 | 94104 | 94104 | 94104 | 94102 | 94102 | 94102 | 94102 | 94102 | 94102 | 94104 | 94104 | 94104 | 94104 | 94104 | 94104 | 94102 | 94102 | 94102 | 94102 | 94102 | 94102 | 94104 | 94104 | 94104 | 94104 | 94104 | 94104 | 94102 | 94102 | 94102 | 94102 | 94102 | 94102 | 94104 | 94104 | 94104 | 94104 | 94104 | 94104 | 94102 | 94102 | 94102 | 94102 | 94102 | 94102 | 94104 | 94104 | 94104 | 94104 | 94104 | 94104 | 94102 | 94102 | 94102 | 94102 | 94102 | 94102 | 94104 | 94104 | 94104 | 94104 | 94104 | 94104 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | 4153928887 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | None | None | 4153928895 | None | None | 4153928895 | None | None | 4153928895 | None | None | 4153928895 | None | None | 4153928895 | None | None | 4153928895 | None | None | 4153928895 | None | None | 4153928895 | None | None | 4153928895 | None | None | 4153928895 | None | None | 4153928895 | None | None | 4153928895 | None | None | 4153928895 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] |
filer_id | 1144395 |
---|
filer_id | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | |||||
---|---|---|---|---|---|---|---|---|---|---|
change_no | 1 | 2 | 0 | 3 | 4 | |||||
session_id | 1999 | 2005 | 2005 | 2009 | 2019 | |||||
log_dt | 2000-11-21 00:00:00 | 2006-02-01 00:00:00 | 2006-02-01 00:00:00 | 2010-02-11 00:00:00 | 2020-01-31 00:00:00 | |||||
filer_type | 1 | 1 | 2 | 1 | 1 | |||||
correction_flg | None | None | None | Y | None | |||||
action | SET ACTIVE | SET ACTIVE | ADDED | ADDED | DELETED | |||||
attribute_changed | CLIENT | LOBBYIST | FIRM | FIRM | ||||||
ethics_dt | None | None | None | None | None | |||||
interests | None | None | None | None | None | |||||
filer_full_name | CALIFORNIA TROUT, INC. | CALIFORNIA TROUT, INC. | CALIFORNIA TROUT, INC. | CALIFORNIA TROUT | CALIFORNIA TROUT | |||||
filer_city | MODESTO | None | None | SAN FRANCISCO | None | |||||
filer_st | CA | None | None | CA | None | |||||
filer_zip | 95352 | None | None | 94102 | None | |||||
filer_phone | 2095746203 | None | None | 4153928887 | None | |||||
entity_type | 3 | 1 | 4 | 3 | 3 | |||||
entity_name | CARPENTER SNODGRASS & ASSOCIATES | None | JEFFREY P. SHELLITO | CONSERVATION STRATEGY GROUP LLC | ENVIRONMENTAL AND ENERGY CONSULTING | |||||
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 | 1147269 | 0 | 1282838 | None | 1371848 | |||||
responsible_officer | None | None | None | None | None | |||||
effect_dt | None | 2006-02-01 00:00:00 | 2006-02-01 00:00:00 | 2010-02-01 00:00:00 | 2020-01-17 00:00:00 |
filer_id | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | 1144395 | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 1845580_0.cal | 1781120_0.cal | 1816687_0.cal | 1800054_0.cal | 1764109_0.cal | 1870157_0.cal | 1931090_0.cal | 1909439_0.cal | 2486417_0.cal | 2468840_0.cal | 443976.cal | 2530050_0.cal | 2554252_0.cal | 438044.cal | 2647507_0.cal | 2581234_0.cal | ||||||||||||||||
received_date | 2014-04-30 00:00:00 | 2013-07-30 00:00:00 | 2014-01-30 00:00:00 | 2013-10-30 00:00:00 | 2013-04-29 00:00:00 | 2014-07-30 00:00:00 | 2015-01-27 00:00:00 | 2014-10-30 00:00:00 | 2020-07-31 00:00:00 | 2020-04-29 00:00:00 | 2022-11-03 00:00:00 | 2020-11-02 00:00:00 | 2021-02-01 00:00:00 | 2021-11-01 00:00:00 | 2022-02-04 00:00:00 | 2021-04-30 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/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | ||||||||||||||||
filing_id | 1845580 | 1781120 | 1816687 | 1800054 | 1764109 | 1870157 | 1931090 | 1909439 | 2486417 | 2468840 | None | 2530050 | 2554252 | None | 2647507 | 2581234 | ||||||||||||||||
form_id | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | None | F635 | F635 | None | F602 | F635 | ||||||||||||||||
receive_comment | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing did not pass validation | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted |