filer_id | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1102442 | 1101316 | 2041072 | 2079868 | 2410569 | 2469904 | 2546904 | 2297407 | 2510687 | 2341639 | ||||||||||
effect_dt | 1995-01-01 00:00:00 | 1999-01-01 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2017-01-19 00:00:00 | 2019-01-07 00:00:00 | 2023-01-01 00:00:00 | 2013-08-06 00:00:00 | 2021-01-07 00:00:00 | 2015-01-01 00:00:00 | ||||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | ||||||||||
session_id | 1995 | 1999 | 2003 | 2005 | 2017 | 2019 | 2023 | 2013 | 2021 | 2015 |
filer_id | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 1995 | 1997 | 1999 | 2001 | 2003 | 2005 | 2013 | 2015 | 2017 | 2019 | 2021 | |||||||||||
ethics_date | 1994-03-09 00:00:00 | 1999-01-08 00:00:00 | 1999-01-08 00:00:00 | 2000-11-14 00:00:00 | 2002-11-13 00:00:00 | 2004-11-17 00:00:00 | 2014-03-20 00:00:00 | 2014-03-20 00:00:00 | 2017-01-12 00:00:00 | 2019-05-23 00:00:00 | 2021-06-10 00:00:00 |
filer_id | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 515692 | 517575 | 510314 | 511327 | 522794 | 512543 | 518826 | 520675 | 519655 | 514432 | 525955 | 521740 | 524904 | 527992 | 523835 | 516538 | 527011 | 513394 | 513394 | 529001 | 615805 | 632929 | 662621 | 681192 | 707356 | 693744 | 717508 | 755745 | 745230 | 739814 | 789193 | 781558 | 770034 | 797955 | 812661 | 839162 | 821744 | 845588 | 861314 | 854123 | 906821 | 892438 | 905757 | 881856 | 896102 | 944943 | 929903 | 934381 | 967951 | 975842 | 956375 | 988563 | 1012250 | 1015916 | 984588 | 1028285 | 1030423 | 1072697 | 1075946 | 1057086 | 1068688 | 1061870 | 1105215 | 1079640 | 1116456 | 1133440 | 1147134 | 1166839 | 1177140 | 1190863 | 1789886 | 1976852 | 1965853 | 1969231 | 1942784 | 1942785 | 1902359 | 1801078 | 1818974 | 1818974 | 1801078 | 1873315 | 1846326 | 1831071 | 1993767 | 2390020 | 2203627 | 2378662 | 2418619 | 2334406 | 2037059 | 2009148 | 2057147 | 2097914 | 2121127 | 2121838 | 2138707 | 2156259 | 2166704 | 2267067 | 2318958 | 2551872 | 2351338 | 2385478 | 2243226 | 2485776 | 2520703 | 2439717 | 2195125 | 2384667 | 2467896 | 2595164 | 2591266 | 2641780 | 2641780 | 2673771 | 2624049 | 2587721 | 2703038 | 2574785 | 2586915 | 2736229 | 2641780 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 158 | 151 | 141 | 149 | 153 | 157 | 159 | 152 | 144 | 150 | 147 | 145 | 154 | 148 | 146 | 143 | 155 | 142 | 142 | 156 | 160 | 161 | 162 | 163 | None | 163 | 164 | 165 | 165 | 164 | 167 | None | 166 | None | 168 | 169 | None | None | None | 170 | None | None | 172 | 171 | None | 174 | 173 | None | 175 | None | None | None | 177 | None | 176 | 178 | None | None | 180 | 179 | 180 | None | 181 | None | 182 | 183 | 184 | 185 | None | 186 | None | 222 | 221 | None | 221 | 220 | 219 | 215 | 216 | 216 | 215 | 218 | 217 | None | 223 | 238 | 232 | 237 | 239 | 236 | 225 | 224 | 226 | 227 | None | 228 | None | 229 | 230 | 234 | 235 | 244 | None | None | 233 | 242 | 243 | 240 | 231 | 238 | 241 | 246 | None | 248 | 248 | 249 | 247 | 246 | 250 | 245 | None | 251 | 248 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F690 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F606 | F615 | F604 | F615 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 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 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1999-08-02 00:00:00 | 1997-10-24 00:00:00 | 1995-04-27 00:00:00 | 1997-04-29 00:00:00 | 1998-04-29 00:00:00 | 1999-04-29 00:00:00 | 1999-11-01 00:00:00 | 1998-01-28 00:00:00 | 1996-01-24 00:00:00 | 1997-07-30 00:00:00 | 1996-10-31 00:00:00 | 1996-04-24 00:00:00 | 1998-07-31 00:00:00 | 1997-01-31 00:00:00 | 1996-07-30 00:00:00 | 1995-10-25 00:00:00 | 1998-10-29 00:00:00 | 1995-07-28 00:00:00 | 1995-07-26 00:00:00 | 1999-02-01 00:00:00 | 2000-01-31 00:00:00 | 2000-04-27 00:00:00 | 2000-07-31 00:00:00 | 2000-10-30 00:00:00 | 2000-12-22 00:00:00 | 2000-10-31 00:00:00 | 2001-01-30 00:00:00 | 2001-04-30 00:00:00 | 2001-04-29 00:00:00 | 2001-01-31 00:00:00 | 2001-10-25 00:00:00 | 2001-07-31 00:00:00 | 2001-07-26 00:00:00 | 2001-10-25 00:00:00 | 2002-01-30 00:00:00 | 2002-04-30 00:00:00 | 2002-01-31 00:00:00 | 2002-04-30 00:00:00 | 2002-07-30 00:00:00 | 2002-07-30 00:00:00 | 2003-01-24 00:00:00 | 2002-10-30 00:00:00 | 2003-01-24 00:00:00 | 2002-10-29 00:00:00 | 2002-12-09 00:00:00 | 2003-07-28 00:00:00 | 2003-04-29 00:00:00 | 2003-04-29 00:00:00 | 2003-10-27 00:00:00 | 2003-10-29 00:00:00 | 2003-07-29 00:00:00 | 2004-01-22 00:00:00 | 2004-04-28 00:00:00 | 2004-04-29 00:00:00 | 2004-01-22 00:00:00 | 2004-07-29 00:00:00 | 2004-07-29 00:00:00 | 2004-12-29 00:00:00 | 2005-01-26 00:00:00 | 2004-10-29 00:00:00 | 2004-12-29 00:00:00 | 2004-10-29 00:00:00 | 2005-05-02 00:00:00 | 2005-01-27 00:00:00 | 2005-07-28 00:00:00 | 2005-10-31 00:00:00 | 2006-01-30 00:00:00 | 2006-04-28 00:00:00 | 2006-05-26 00:00:00 | 2006-07-31 00:00:00 | 2013-08-06 00:00:00 | 2015-07-24 00:00:00 | 2015-04-30 00:00:00 | 2015-02-19 00:00:00 | 2015-02-16 00:00:00 | 2015-02-16 00:00:00 | 2014-10-22 00:00:00 | 2013-10-31 00:00:00 | 2014-03-24 00:00:00 | 2014-01-31 00:00:00 | 2014-02-11 00:00:00 | 2014-07-31 00:00:00 | 2014-04-30 00:00:00 | 2014-03-20 00:00:00 | 2015-10-23 00:00:00 | 2019-07-14 00:00:00 | 2018-01-20 00:00:00 | 2019-04-29 00:00:00 | 2019-10-30 00:00:00 | 2019-01-15 00:00:00 | 2016-05-01 00:00:00 | 2016-01-28 00:00:00 | 2016-07-21 00:00:00 | 2016-10-27 00:00:00 | 2017-01-12 00:00:00 | 2017-01-21 00:00:00 | 2017-01-26 00:00:00 | 2017-04-28 00:00:00 | 2017-07-12 00:00:00 | 2018-07-20 00:00:00 | 2018-10-31 00:00:00 | 2021-01-30 00:00:00 | 2019-01-25 00:00:00 | 2019-05-30 00:00:00 | 2018-04-30 00:00:00 | 2020-07-31 00:00:00 | 2020-10-22 00:00:00 | 2020-01-30 00:00:00 | 2017-11-06 00:00:00 | 2019-05-27 00:00:00 | 2020-04-27 00:00:00 | 2021-07-21 00:00:00 | 2021-06-14 00:00:00 | 2022-01-29 00:00:00 | 2022-01-29 00:00:00 | 2022-04-28 00:00:00 | 2021-11-01 00:00:00 | 2021-06-11 00:00:00 | 2022-07-28 00:00:00 | 2021-04-18 00:00:00 | 2021-01-19 00:00:00 | 2022-10-19 00:00:00 | 2022-10-21 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 | 10005 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10002 | 10001 | 10001 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10006 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10002 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 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 | 11003 | 11001 | 11001 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1999 | 1997 | 1995 | 1997 | 1997 | 1999 | 1999 | 1997 | 1995 | 1997 | 1995 | 1995 | 1997 | 1995 | 1995 | 1995 | 1997 | 1995 | 1995 | 1997 | 1999 | 1999 | 1999 | 1999 | 2001 | 1999 | 1999 | 2001 | 2001 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2003 | 2003 | 2005 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2013 | 2015 | 2015 | 2015 | 2015 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2015 | 2019 | 2017 | 2019 | 2019 | 2017 | 2015 | 2015 | 2015 | 2015 | 2017 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2019 | 2017 | 2019 | 2019 | 2019 | 2017 | 2019 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | TTHAM | YBONILLA | * | GGILMORE | YBONILLA | * | YBONILLA | * | YBONILLA | * | LTHIBAUL | * | LTHIBAUL | * | * | LTHIBAUL | LTHIBAUL | LTHIBAUL | * | LTHIBAUL | LTHIBAUL | COMPLETED | * | GPEREZ | COMPLETED | COMPLETED | LTHIBAUL | COMPLETED | LTHIBAUL | LTHIBAUL | LTHIBAUL | COMPLETED | LTHIBAUL | COMPLETED | COMPLETED | LTHIBAUL | DMCCASTL | COMPLETED | COMPLETED | YRODRIGU | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | * | GPEREZ | * | PBANFORD | JINGRAM | JINGRAM | YRODRIGU | YRODRIGU | RGEREMIA | ASAETERN | AGLADNEY | ASAETERN | ASAETERN | AGLADNEY | AGLADNEY | ASAETERN | SMCCONNAN | JINGRAM | VUKSTINA | AGLADNEY | VUKSTINA | VUKSTINA | JFRONEFIELD | AGLADNEY | AGLADNEY | AGLADNEY | JINGRAM | PBANFORD | AGLADNEY | PBANFORD | KBANH | SMCCONNAN | AGLADNEY | JFRONEFIELD | GTAYLOR | GPEREZ | SUSHAKOV | AGLADNEY | MMERCHANT | GTAYLOR | GTAYLOR | AGLADNEY | SUSHAKOV | VUKSTINA | MKIRKHAM | MMERCHANT | GTAYLOR | GTAYLOR | CHATRIDGE | GTAYLOR | MMERCHANT | CAFILER | GTAYLOR | CVANLIEW | CAFILER | CAFILER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 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 | 11002 | 11002 | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 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 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 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 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1999-04-01 00:00:00 | 1997-07-01 00:00:00 | 1995-01-01 00:00:00 | 1997-01-01 00:00:00 | 1998-01-01 00:00:00 | 1999-01-01 00:00:00 | 1999-07-01 00:00:00 | 1997-10-01 00:00:00 | 1995-10-01 00:00:00 | 1997-04-01 00:00:00 | 1996-07-01 00:00:00 | 1996-01-01 00:00:00 | 1998-04-01 00:00:00 | 1996-10-01 00:00:00 | 1996-04-01 00:00:00 | 1995-07-01 00:00:00 | 1998-07-01 00:00:00 | 1995-04-01 00:00:00 | 1995-04-01 00:00:00 | 1998-10-01 00:00:00 | 1999-10-01 00:00:00 | 2000-01-01 00:00:00 | 2000-04-01 00:00:00 | 2000-07-01 00:00:00 | 1900-01-01 00:00:00 | 2000-07-01 00:00:00 | 2000-10-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2000-10-01 00:00:00 | 2001-07-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-10-01 00:00:00 | 2002-01-01 00:00:00 | 2002-04-01 00:00:00 | 2002-04-01 00:00:00 | 2002-10-01 00:00:00 | 2002-07-01 00:00:00 | 2002-10-01 00:00:00 | 2002-07-01 00:00:00 | 1900-01-01 00:00:00 | 2003-04-01 00:00:00 | 2003-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-07-01 00:00:00 | 2003-07-01 00:00:00 | 2003-04-01 00:00:00 | 2003-10-01 00:00:00 | 2004-01-01 00:00:00 | 2004-01-01 00:00:00 | 2003-10-01 00:00:00 | 2004-04-01 00:00:00 | 2004-04-01 00:00:00 | 1900-01-01 00:00:00 | 2004-10-01 00:00:00 | 2004-07-01 00:00:00 | 2004-12-20 00:00:00 | 2004-07-01 00:00:00 | 2005-01-01 00:00:00 | 2004-10-01 00:00:00 | 2005-04-01 00:00:00 | 2005-07-01 00:00:00 | 2005-10-01 00:00:00 | 2006-01-01 00:00:00 | 1900-01-01 00:00:00 | 2006-04-01 00:00:00 | 1900-01-01 00:00:00 | 2015-04-01 00:00:00 | 2015-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-02-16 00:00:00 | 2014-10-01 00:00:00 | 2014-07-01 00:00:00 | 2013-07-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-07-01 00:00:00 | 2014-04-01 00:00:00 | 2014-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-07-01 00:00:00 | 2019-04-01 00:00:00 | 2017-10-01 00:00:00 | 2019-01-01 00:00:00 | 2019-07-01 00:00:00 | 2018-10-01 00:00:00 | 2016-01-01 00:00:00 | 2015-10-01 00:00:00 | 2016-04-01 00:00:00 | 2016-07-01 00:00:00 | None | 2016-10-01 00:00:00 | 1900-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-04-01 00:00:00 | 2018-04-01 00:00:00 | 2018-07-01 00:00:00 | 2020-10-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-01-01 00:00:00 | 2020-04-01 00:00:00 | 2020-07-01 00:00:00 | 2019-10-01 00:00:00 | 2017-07-01 00:00:00 | 2019-05-27 00:00:00 | 2020-01-01 00:00:00 | 2021-04-01 00:00:00 | 1900-01-01 00:00:00 | 2021-10-01 00:00:00 | 2021-10-01 00:00:00 | 2022-01-01 00:00:00 | 2021-07-01 00:00:00 | 2021-06-11 00:00:00 | 2022-04-01 00:00:00 | 2021-01-01 00:00:00 | 1900-01-01 00:00:00 | 2022-07-01 00:00:00 | 2021-10-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1999-06-30 00:00:00 | 1997-09-30 00:00:00 | 1995-03-31 00:00:00 | 1997-03-31 00:00:00 | 1998-03-31 00:00:00 | 1999-03-31 00:00:00 | 1999-09-30 00:00:00 | 1997-12-31 00:00:00 | 1995-12-31 00:00:00 | 1997-06-30 00:00:00 | 1996-09-30 00:00:00 | 1996-03-31 00:00:00 | 1998-06-30 00:00:00 | 1996-12-31 00:00:00 | 1996-06-30 00:00:00 | 1995-09-30 00:00:00 | 1998-09-30 00:00:00 | 1995-06-30 00:00:00 | 1995-06-30 00:00:00 | 1998-12-31 00:00:00 | 1999-12-31 00:00:00 | 2000-03-31 00:00:00 | 2000-06-30 00:00:00 | 2000-09-30 00:00:00 | 1900-01-01 00:00:00 | 2000-09-30 00:00:00 | 2000-12-31 00:00:00 | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 | 2000-12-31 00:00:00 | 2001-09-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-12-31 00:00:00 | 2002-03-31 00:00:00 | 2002-06-30 00:00:00 | 2002-06-30 00:00:00 | 2002-12-31 00:00:00 | 2002-09-30 00:00:00 | 2002-12-31 00:00:00 | 2002-09-30 00:00:00 | 1900-01-01 00:00:00 | 2003-06-30 00:00:00 | 2003-03-31 00:00:00 | 2003-03-31 00:00:00 | 2003-09-30 00:00:00 | 2003-09-30 00:00:00 | 2003-06-30 00:00:00 | 2003-12-31 00:00:00 | 2004-03-31 00:00:00 | 2004-03-31 00:00:00 | 2003-12-31 00:00:00 | 2004-06-30 00:00:00 | 2004-06-30 00:00:00 | 1900-01-01 00:00:00 | 2004-12-31 00:00:00 | 2004-09-30 00:00:00 | 2004-12-20 00:00:00 | 2004-09-30 00:00:00 | 2005-03-31 00:00:00 | 2004-12-31 00:00:00 | 2005-06-30 00:00:00 | 2005-09-30 00:00:00 | 2005-12-31 00:00:00 | 2006-03-31 00:00:00 | 1900-01-01 00:00:00 | 2006-04-30 00:00:00 | 1900-01-01 00:00:00 | 2015-06-30 00:00:00 | 2015-03-31 00:00:00 | 1900-01-01 00:00:00 | 2015-02-16 00:00:00 | 2014-12-31 00:00:00 | 2014-09-30 00:00:00 | 2013-10-31 00:00:00 | 2013-12-31 00:00:00 | 2013-12-31 00:00:00 | 2013-09-30 00:00:00 | 2014-06-30 00:00:00 | 2014-03-31 00:00:00 | 1900-01-01 00:00:00 | 2015-09-30 00:00:00 | 2019-06-30 00:00:00 | 2017-12-31 00:00:00 | 2019-03-31 00:00:00 | 2019-09-30 00:00:00 | 2018-12-31 00:00:00 | 2016-03-31 00:00:00 | 2015-12-31 00:00:00 | 2016-06-30 00:00:00 | 2016-09-30 00:00:00 | None | 2016-12-31 00:00:00 | 1900-01-01 00:00:00 | 2017-03-31 00:00:00 | 2017-06-30 00:00:00 | 2018-06-30 00:00:00 | 2018-09-30 00:00:00 | 2020-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-03-31 00:00:00 | 2020-06-30 00:00:00 | 2020-09-30 00:00:00 | 2019-12-31 00:00:00 | 2017-09-30 00:00:00 | 2019-05-27 00:00:00 | 2020-03-31 00:00:00 | 2021-06-30 00:00:00 | 1900-01-01 00:00:00 | 2021-12-31 00:00:00 | 2021-12-31 00:00:00 | 2022-03-31 00:00:00 | 2021-09-30 00:00:00 | 2021-06-11 00:00:00 | 2022-06-30 00:00:00 | 2021-03-31 00:00:00 | 1900-01-01 00:00:00 | 2022-09-30 00:00:00 | 2021-12-31 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 22001 | None | None | 22001 | 22001 | None | 22001 | None | None | None | 22001 | None | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | None | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 |
filer_id | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |||||||||||||
active | Y | Y | Y | Y | Y | Y | T | Y | Y | Y | Y | Y | N | |||||||||||||
race | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | |||||||||||||
session_id | 2001 | 1995 | 1999 | 1997 | 2003 | 2005 | 2005 | 2013 | 2015 | 2021 | 2019 | 2017 | 2023 | |||||||||||||
category | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | |||||||||||||
category_type | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | |||||||||||||
sub_category | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | |||||||||||||
effect_dt | 2001-01-01 00:00:00 | 1995-01-01 00:00:00 | 1999-01-01 00:00:00 | 1997-01-01 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2006-04-30 00:00:00 | 2013-08-06 00:00:00 | 2015-01-01 00:00:00 | 2021-01-07 00:00:00 | 2019-01-07 00:00:00 | 2017-01-19 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 | |||||||||||||
election_type | 0 | 0 | 0 | 0 | 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 | |||||||||||||
nyq_dt | None | None | None | None | None | None | 2000-07-01 00:00:00 | 2000-07-01 00:00:00 | None | None | None | None | None | |||||||||||||
party_cd | 0 | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
county_cd | 0 | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
district_cd | 0 | None | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1148537 | |
---|---|---|
xref_id | L24610 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | L24610 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_type | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
naml | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | GAINES | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namf | WILLIAM R. | WILLIAM R. | WILLIAM R. | WILLIAM R. | WILLIAM R. | WILLIAM R. | WILLIAM R. | WILLIAM R. | WILLIAM R. | WILLIAM R. | WILLIAM R. | WILLIAM R. | WILLIAM R. | WILLIAM R. | WILLIAM R. | WILLIAM R. | WILLIAM R. | WILLIAM R. | WILLIAM R. | WILLIAM R. | WILLIAM R. | WILLIAM R. | WILLIAM R. | WILLIAM R. | WILLIAM R. | WILLIAM R. | WILLIAM R. | WILLIAM R. | WILLIAM R. | WILLIAM R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | BILL R. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
city | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SHINGLE SPRINGS | SHINGLE SPRINGS | SHINGLE SPRINGS | SHINGLE SPRINGS | SHINGLE SPRINGS | SHINGLE SPRINGS | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SHINGLE SPRINGS | SHINGLE SPRINGS | SHINGLE SPRINGS | SHINGLE SPRINGS | SHINGLE SPRINGS | SHINGLE SPRINGS | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SHINGLE SPRINGS | SHINGLE SPRINGS | SHINGLE SPRINGS | SHINGLE SPRINGS | SHINGLE SPRINGS | SHINGLE SPRINGS | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SHINGLE SPRINGS | SHINGLE SPRINGS | SHINGLE SPRINGS | SHINGLE SPRINGS | SHINGLE SPRINGS | SHINGLE SPRINGS | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SHINGLE SPRINGS | SHINGLE SPRINGS | SHINGLE SPRINGS | SHINGLE SPRINGS | SHINGLE SPRINGS | SHINGLE SPRINGS | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SHINGLE SPRINGS | SHINGLE SPRINGS | SHINGLE SPRINGS | SHINGLE SPRINGS | SHINGLE SPRINGS | SHINGLE SPRINGS | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SHINGLE SPRINGS | SHINGLE SPRINGS | SHINGLE SPRINGS | SHINGLE SPRINGS | SHINGLE SPRINGS | SHINGLE SPRINGS | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SHINGLE SPRINGS | SHINGLE SPRINGS | SHINGLE SPRINGS | SHINGLE SPRINGS | SHINGLE SPRINGS | SHINGLE SPRINGS | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SHINGLE SPRINGS | SHINGLE SPRINGS | SHINGLE SPRINGS | SHINGLE SPRINGS | SHINGLE SPRINGS | SHINGLE SPRINGS | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
zip4 | 95834 | 95834 | 95834 | 95834 | 95682 | 95682 | 95682 | 95682 | 95682 | 95682 | 95834 | 95834 | 95834 | 95834 | 95682 | 95682 | 95682 | 95682 | 95682 | 95682 | 95834 | 95834 | 95834 | 95834 | 95682 | 95682 | 95682 | 95682 | 95682 | 95682 | 95834 | 95834 | 95834 | 95834 | 95682 | 95682 | 95682 | 95682 | 95682 | 95682 | 95834 | 95834 | 95834 | 95834 | 95682 | 95682 | 95682 | 95682 | 95682 | 95682 | 95834 | 95834 | 95834 | 95834 | 95682 | 95682 | 95682 | 95682 | 95682 | 95682 | 95834 | 95834 | 95834 | 95834 | 95682 | 95682 | 95682 | 95682 | 95682 | 95682 | 95834 | 95834 | 95834 | 95834 | 95682 | 95682 | 95682 | 95682 | 95682 | 95682 | 95834 | 95834 | 95834 | 95834 | 95682 | 95682 | 95682 | 95682 | 95682 | 95682 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 9166481406 | 9166481408 | 9166481406 | 9166481406 | 9163379031 | 9163379031 | 9163379031 | 9163379031 | 9163379031 | 9163379031 | 9166481406 | 9166481408 | 9166481406 | 9166481406 | 9163379031 | 9163379031 | 9163379031 | 9163379031 | 9163379031 | 9163379031 | 9166481406 | 9166481408 | 9166481406 | 9166481406 | 9163379031 | 9163379031 | 9163379031 | 9163379031 | 9163379031 | 9163379031 | 9166481406 | 9166481408 | 9166481406 | 9166481406 | 9163379031 | 9163379031 | 9163379031 | 9163379031 | 9163379031 | 9163379031 | 9166481406 | 9166481408 | 9166481406 | 9166481406 | 9163379031 | 9163379031 | 9163379031 | 9163379031 | 9163379031 | 9163379031 | 9166481406 | 9166481408 | 9166481406 | 9166481406 | 9163379031 | 9163379031 | 9163379031 | 9163379031 | 9163379031 | 9163379031 | 9166481406 | 9166481408 | 9166481406 | 9166481406 | 9163379031 | 9163379031 | 9163379031 | 9163379031 | 9163379031 | 9163379031 | 9166481406 | 9166481408 | 9166481406 | 9166481406 | 9163379031 | 9163379031 | 9163379031 | 9163379031 | 9163379031 | 9163379031 | 9166481406 | 9166481408 | 9166481406 | 9166481406 | 9163379031 | 9163379031 | 9163379031 | 9163379031 | 9163379031 | 9163379031 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | 9166481665 | None | 9166481665 | 9166481665 | 9166481665 | None | 9166481665 | 9166481665 | 9166481665 | None | 9166481665 | 9166481665 | 9166481665 | None | 9166481665 | 9166481665 | 9166481665 | None | 9166481665 | 9166481665 | 9166481665 | None | 9166481665 | 9166481665 | 9166481665 | None | 9166481665 | 9166481665 | 9166481665 | None | 9166481665 | 9166481665 | 9166481665 | None | 9166481665 | 9166481665 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
[email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] |
filer_id | 1148537 |
---|
filer_id | 1148537 | 1148537 | ||
---|---|---|---|---|
change_no | 1 | 2 | ||
session_id | 2005 | 2013 | ||
log_dt | 2006-05-26 00:00:00 | 2013-08-06 00:00:00 | ||
filer_type | 4 | 4 | ||
correction_flg | None | Y | ||
action | DELETED | ADDED | ||
attribute_changed | EMPLOYER | FIRM | ||
ethics_dt | None | None | ||
interests | None | None | ||
filer_full_name | WILLIAM R. GAINES | GAINES, BILL R. | ||
filer_city | None | SACRAMENTO | ||
filer_st | None | CA | ||
filer_zip | None | 95834 | ||
filer_phone | None | 9166481406 | ||
entity_type | 2 | 3 | ||
entity_name | CALIFORNIA WATERFOWL ASSOCIATION | GAINES & ASSOCIATES | ||
entity_city | None | None | ||
entity_st | None | None | ||
entity_zip | None | None | ||
entity_phone | None | None | ||
entity_id | 1146990 | None | ||
responsible_officer | None | None | ||
effect_dt | 2006-04-30 00:00:00 | 2013-08-06 00:00:00 |
filer_id | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | 1148537 | |||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 681192_0.cal | 717508_0.cal | 745230_0.cal | 770034_0.cal | 789193_0.cal | 812661_0.cal | 839162_0.cal | 854123_0.cal | 881856_0.cal | 905757_0.cal | 929903_0.cal | 944943_0.cal | 967951_0.cal | 984588_0.cal | 1012250_0.cal | 1028285_0.cal | 1057086_0.cal | 1075946_0.cal | 1105215_0.cal | 1116456_0.cal | 1133440_0.cal | 1147134_0.cal | 1166839_0.cal | 1190863_0.cal | 1942784_0.cal | 2384667_0.cal | 2587721_0.cal | |||||||||||||||||||||||||||
received_date | 2000-10-30 00:00:00 | 2001-01-30 00:00:00 | 2001-04-29 00:00:00 | 2001-07-26 00:00:00 | 2001-10-25 00:00:00 | 2002-01-30 00:00:00 | 2002-04-30 00:00:00 | 2002-07-30 00:00:00 | 2002-10-29 00:00:00 | 2003-01-24 00:00:00 | 2003-04-29 00:00:00 | 2003-07-28 00:00:00 | 2003-10-27 00:00:00 | 2004-01-22 00:00:00 | 2004-04-28 00:00:00 | 2004-07-29 00:00:00 | 2004-10-29 00:00:00 | 2005-01-26 00:00:00 | 2005-05-02 00:00:00 | 2005-07-28 00:00:00 | 2005-10-31 00:00:00 | 2006-01-30 00:00:00 | 2006-04-28 00:00:00 | 2006-07-31 00:00:00 | 2015-02-16 00:00:00 | 2019-05-27 00:00:00 | 2021-06-11 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 | |||||||||||||||||||||||||||
filing_id | 681192 | 717508 | 745230 | 770034 | 789193 | 812661 | 839162 | 854123 | 881856 | 905757 | 929903 | 944943 | 967951 | 984588 | 1012250 | 1028285 | 1057086 | 1075946 | 1105215 | 1116456 | 1133440 | 1147134 | 1166839 | 1190863 | 1942784 | 2384667 | 2587721 | |||||||||||||||||||||||||||
form_id | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F604 | |||||||||||||||||||||||||||
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 |