filer_id | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1103679 | 2043656 | 2079262 | 2114503 | 2159941 | 2203475 | 2409937 | 2519929 | 2470748 | 2277934 | 2339625 | |||||||||||
effect_dt | 1999-01-01 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2017-01-01 00:00:00 | 2021-01-01 00:00:00 | 2019-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-01-01 00:00:00 | |||||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | |||||||||||
session_id | 1999 | 2003 | 2005 | 2007 | 2009 | 2011 | 2017 | 2021 | 2019 | 2013 | 2015 |
filer_id | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 1999 | 1997 | 2001 | 2003 | 2007 | 2005 | 2009 | 2011 | 2011 | 2013 | 2015 | 2019 | 2017 | 2021 | ||||||||||||||
ethics_date | 1999-01-08 00:00:00 | 1999-01-08 00:00:00 | 2001-04-20 00:00:00 | 2003-04-24 00:00:00 | 2007-04-19 00:00:00 | 2005-01-12 00:00:00 | 2008-09-12 00:00:00 | 2012-07-10 00:00:00 | 2010-07-09 00:00:00 | 2012-07-10 00:00:00 | 2014-07-09 00:00:00 | 2019-01-10 00:00:00 | 2016-09-09 00:00:00 | 2020-12-03 00:00:00 |
filer_id | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 518277 | 515151 | 529569 | 523442 | 516304 | 519437 | 521364 | 525537 | 513151 | 527598 | 624489 | 626421 | 611971 | 645084 | 682276 | 656208 | 709018 | 713615 | 715098 | 688846 | 745397 | 709018 | 747102 | 789545 | 777434 | 772026 | 793122 | 809627 | 815525 | 837778 | 856480 | 841609 | 881517 | 854198 | 907288 | 906065 | 883484 | 918269 | 931474 | 933123 | 929636 | 953525 | 946267 | 969505 | 971506 | 987992 | 1029483 | 1015220 | 1035300 | 1013718 | 993674 | 1058766 | 1063197 | 1082896 | 1100366 | 1081979 | 1119498 | 1103828 | 1086219 | 1144948 | 1132998 | 1166991 | 1190187 | 1217241 | 1225882 | 1240233 | 1240233 | 1235344 | 1284302 | 1261507 | 1305630 | 1779189 | 1978348 | 1962170 | 1943856 | 1843220 | 1798182 | 1901263 | 1327728 | 1298164 | 1347633 | 1372969 | 1386747 | 1396419 | 1409187 | 1419163 | 1452553 | 1436046 | 1485473 | 1462960 | 1506931 | 1539845 | 1562067 | 1554151 | 1554151 | 1569994 | 1602586 | 1589745 | 1633627 | 1621660 | 1656622 | 1676522 | 1813267 | 1670865 | 1929401 | 1922493 | 1703213 | 1867300 | 1745385 | 1730217 | 1716888 | 1762980 | 1995079 | 2203096 | 2390593 | 2429744 | 2466912 | 2188380 | 2414790 | 2482728 | 2267334 | 2011391 | 2031782 | 2055433 | 2100320 | 2128264 | 2120261 | 2139932 | 2171944 | 2156681 | 2339806 | 2351672 | 2536531 | 2375085 | 2579734 | 2316785 | 2240423 | 2325995 | 2522517 | 2548748 | 2624843 | 2706656 | 2675808 | 2589398 | 2599684 | 2643867 | 2746007 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 151 | 150 | 156 | 153 | 158 | 159 | 152 | 154 | 157 | 155 | 161 | 161 | 160 | 162 | 163 | 162 | None | 164 | 164 | 163 | 165 | None | 165 | 167 | None | 166 | 167 | 168 | None | 169 | None | None | 171 | 170 | 172 | None | None | None | None | None | 173 | None | 174 | 175 | None | 176 | 178 | None | None | 177 | None | 179 | None | None | None | 180 | 182 | 181 | None | 184 | 183 | 185 | 186 | 187 | 189 | None | None | 188 | 190 | 189 | 192 | 214 | 222 | 221 | None | 217 | 215 | 219 | 193 | 191 | 194 | 195 | 196 | 196 | None | 197 | 199 | 198 | 201 | 200 | 202 | 203 | None | 204 | 204 | 204 | 206 | 205 | 208 | 207 | 209 | 210 | 216 | None | 220 | 221 | 211 | 218 | None | 212 | 212 | 213 | 223 | 232 | 238 | 240 | 241 | 231 | 239 | 242 | 234 | 224 | 225 | 226 | 227 | 228 | 229 | None | 230 | 229 | 236 | None | 244 | 237 | 245 | 235 | 233 | 236 | 243 | 244 | 247 | 250 | 249 | None | 246 | 248 | 251 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F615 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 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 | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1997-10-30 00:00:00 | 1997-07-31 00:00:00 | 1999-01-28 00:00:00 | 1998-04-30 00:00:00 | 1999-08-02 00:00:00 | 1999-10-27 00:00:00 | 1998-02-02 00:00:00 | 1998-07-31 00:00:00 | 1999-04-29 00:00:00 | 1998-10-30 00:00:00 | 2000-05-01 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 | 2000-07-31 00:00:00 | 2001-01-03 00:00:00 | 2001-01-23 00:00:00 | 2001-01-24 00:00:00 | 2000-10-31 00:00:00 | 2001-04-30 00:00:00 | 2001-04-20 00:00:00 | 2001-04-30 00:00:00 | 2001-10-26 00:00:00 | 2001-07-31 00:00:00 | 2001-07-30 00:00:00 | 2001-10-26 00:00:00 | 2002-01-24 00:00:00 | 2002-01-24 00:00:00 | 2002-04-26 00:00:00 | 2002-07-30 00:00:00 | 2002-04-29 00:00:00 | 2002-10-29 00:00:00 | 2002-07-30 00:00:00 | 2003-01-28 00:00:00 | 2003-01-02 00:00:00 | 2002-10-29 00:00:00 | 2003-01-31 00:00:00 | 2003-04-24 00:00:00 | 2003-04-30 00:00:00 | 2003-04-28 00:00:00 | 2003-07-31 00:00:00 | 2003-07-30 00:00:00 | 2003-10-31 00:00:00 | 2003-10-31 00:00:00 | 2004-01-29 00:00:00 | 2004-07-30 00:00:00 | 2004-04-29 00:00:00 | 2004-08-02 00:00:00 | 2004-04-30 00:00:00 | 2004-02-02 00:00:00 | 2004-11-01 00:00:00 | 2004-11-01 00:00:00 | 2004-12-31 00:00:00 | 2005-04-14 00:00:00 | 2005-02-01 00:00:00 | 2005-08-01 00:00:00 | 2005-04-28 00:00:00 | 2005-01-31 00:00:00 | 2006-01-26 00:00:00 | 2005-10-30 00:00:00 | 2006-04-28 00:00:00 | 2006-07-30 00:00:00 | 2006-10-31 00:00:00 | 2007-01-02 00:00:00 | 2007-04-19 00:00:00 | 2007-01-02 00:00:00 | 2007-01-30 00:00:00 | 2007-07-31 00:00:00 | 2007-04-30 00:00:00 | 2008-01-24 00:00:00 | 2013-07-28 00:00:00 | 2015-07-28 00:00:00 | 2015-04-26 00:00:00 | 2015-01-02 00:00:00 | 2014-04-29 00:00:00 | 2013-10-28 00:00:00 | 2014-10-21 00:00:00 | 2008-04-28 00:00:00 | 2007-11-01 00:00:00 | 2008-07-29 00:00:00 | 2008-10-27 00:00:00 | 2008-12-30 00:00:00 | 2009-01-31 00:00:00 | 2008-12-31 00:00:00 | 2009-04-27 00:00:00 | 2009-11-01 00:00:00 | 2009-07-29 00:00:00 | 2010-04-30 00:00:00 | 2010-01-29 00:00:00 | 2010-07-31 00:00:00 | 2010-10-31 00:00:00 | 2010-12-30 00:00:00 | 2010-12-27 00:00:00 | 2010-12-27 00:00:00 | 2011-01-30 00:00:00 | 2011-07-23 00:00:00 | 2011-04-28 00:00:00 | 2012-01-29 00:00:00 | 2011-10-30 00:00:00 | 2012-04-29 00:00:00 | 2012-07-29 00:00:00 | 2014-01-26 00:00:00 | 2012-07-10 00:00:00 | 2015-01-25 00:00:00 | 2015-01-02 00:00:00 | 2012-10-25 00:00:00 | 2014-07-28 00:00:00 | 2012-12-31 00:00:00 | 2013-01-23 00:00:00 | 2012-12-12 00:00:00 | 2013-04-28 00:00:00 | 2015-10-27 00:00:00 | 2018-01-19 00:00:00 | 2019-07-17 00:00:00 | 2020-01-10 00:00:00 | 2020-04-22 00:00:00 | 2017-10-18 00:00:00 | 2019-10-23 00:00:00 | 2020-07-29 00:00:00 | 2018-07-22 00:00:00 | 2016-01-31 00:00:00 | 2016-04-24 00:00:00 | 2016-07-15 00:00:00 | 2016-10-29 00:00:00 | 2017-01-30 00:00:00 | 2017-01-17 00:00:00 | 2017-01-19 00:00:00 | 2017-07-26 00:00:00 | 2017-04-29 00:00:00 | 2019-01-24 00:00:00 | 2019-01-11 00:00:00 | 2020-12-10 00:00:00 | 2019-04-19 00:00:00 | 2021-04-29 00:00:00 | 2018-10-30 00:00:00 | 2018-04-29 00:00:00 | 2018-11-19 00:00:00 | 2020-10-24 00:00:00 | 2021-01-28 00:00:00 | 2021-11-01 00:00:00 | 2022-08-01 00:00:00 | 2022-05-01 00:00:00 | 2021-02-19 00:00:00 | 2021-07-29 00:00:00 | 2022-01-31 00:00:00 | 2022-10-28 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10006 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10006 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10006 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 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 | 11001 | 11001 | 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 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1997 | 1997 | 1997 | 1997 | 1999 | 1999 | 1997 | 1997 | 1999 | 1997 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 2001 | 1999 | 1999 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2001 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2005 | 2003 | 2005 | 2005 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2007 | 2007 | 2005 | 2007 | 2007 | 2007 | 2013 | 2015 | 2015 | 2015 | 2013 | 2013 | 2013 | 2007 | 2007 | 2007 | 2007 | 2009 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2011 | 2011 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2011 | 2013 | 2015 | 2011 | 2013 | 2013 | 2011 | 2013 | 2013 | 2015 | 2017 | 2019 | 2019 | 2019 | 2017 | 2019 | 2019 | 2017 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2021 | 2019 | 2021 | 2017 | 2017 | 2019 | 2019 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | * | * | * | * | * | * | * | TTHAM | * | * | * | TTHAM | CFLAGG | * | SARRIAGA | CFLAGG | * | BSMITH | CFLAGG | * | CFLAGG | * | YBONILLA | * | YBONILLA | * | YBONILLA | YBONILLA | * | * | COMPLETED | SARRIAGA | YBONILLA | YBONILLA | CFLAGG | YBONILLA | COMPLETED | KVANG | COMPLETED | COMPLETED | YBONILLA | COMPLETED | COMPLETED | LTHIBAUL | LTHIBAUL | COMPLETED | LTHIBAUL | COMPLETED | YRODRIGUEZ | GPEREZ | CFLAGG | COMPLETED | YRODRIGU | YRODRIGU | YRODRIGU | LTHIBAUL | YRODRIGU | LTHIBAUL | LTHIBAUL | YRODRIGU | * | CFLAGG | GPEREZ | YRODRIGU | YRODRIGU | YRODRIGU | LTHIBAUL | ASAETERN | SJENSEN | SJENSEN | GKURIMOT | ASAETERN | ASAETERN | ASAETERN | LTHIBAUL | LTHIBAUL | LTHIBAUL | JINGRAM | * | JINGRAM | DMCCASTL | YRODRIGU | YRODRIGU | YRODRIGU | JINGRAM | WBROWN | ASAETERN | ASAETERN | PBANFORD | PBANFORD | PBANFORD | ASAETERN | ASAETERN | JINGRAM | ASAETERN | ASAETERN | ASAETERN | AGLADNEY | ASAETERN | MPACHECO | AGLADNEY | CAFILER | ASAETERN | ASAETERN | YRODRIGU | ASAETERN | YRODRIGU | ASAETERN | JINGRAM | AGLADNEY | VUKSTINA | GTAYLOR | VUKSTINA | AGLADNEY | VUKSTINA | CVANLIEW | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | JINGRAM | AGLADNEY | PBANFORD | PBANFORD | SMCCONNAN | JINGRAM | JFRONEFIELD | PBANFORD | SARRIAGA | VUKSTINA | MKIRKHAM | JFRONEFIELD | AGLADNEY | PBANFORD | MKIRKHAM | JRAMOS | MKIRKHAM | CAFILER | CAFILER | SARRIAGA | GTAYLOR | RATTIYEH | CAFILER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11002 | 11003 | 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 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 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 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 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 | 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 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1997-07-01 00:00:00 | 1997-04-01 00:00:00 | 1998-10-01 00:00:00 | 1998-01-01 00:00:00 | 1999-04-01 00:00:00 | 1999-07-01 00:00:00 | 1997-10-01 00:00:00 | 1998-04-01 00:00:00 | 1999-01-01 00:00:00 | 1998-07-01 00:00:00 | 2000-01-01 00:00:00 | 2000-01-01 00:00:00 | 1999-10-01 00:00:00 | 2000-04-01 00:00:00 | 2000-07-01 00:00:00 | 2000-04-01 00:00:00 | 1900-01-01 00:00:00 | 2000-10-01 00:00:00 | 2000-10-01 00:00:00 | 2000-07-01 00:00:00 | 2001-01-01 00:00:00 | 1900-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-07-01 00:00:00 | 2001-04-01 00:00:00 | 2001-04-01 00:00:00 | 2001-07-01 00:00:00 | 2001-10-01 00:00:00 | 2001-10-01 00:00:00 | 2002-01-01 00:00:00 | 2002-04-01 00:00:00 | 2002-01-01 00:00:00 | 2002-07-01 00:00:00 | 2002-04-01 00:00:00 | 2002-10-01 00:00:00 | 1900-01-01 00:00:00 | 2002-07-01 00:00:00 | 2002-10-01 00:00:00 | 1900-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-04-01 00:00:00 | 2003-04-01 00:00:00 | 2003-07-01 00:00:00 | 2003-07-01 00:00:00 | 2003-10-01 00:00:00 | 2004-04-01 00:00:00 | 2004-01-01 00:00:00 | 2004-04-01 00:00:00 | 2004-01-01 00:00:00 | 2003-10-01 00:00:00 | 2004-07-01 00:00:00 | 2004-07-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2004-10-01 00:00:00 | 2005-04-01 00:00:00 | 2005-01-01 00:00:00 | 2004-10-01 00:00:00 | 2005-10-01 00:00:00 | 2005-07-01 00:00:00 | 2006-01-01 00:00:00 | 2006-04-01 00:00:00 | 2006-07-01 00:00:00 | 2007-01-02 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2006-10-01 00:00:00 | 2007-04-01 00:00:00 | 2007-01-01 00:00:00 | 2007-10-01 00:00:00 | 2013-04-01 00:00:00 | 2015-04-01 00:00:00 | 2015-01-01 00:00:00 | 1900-01-01 00:00:00 | 2014-01-01 00:00:00 | 2013-07-01 00:00:00 | 2014-07-01 00:00:00 | 2008-01-01 00:00:00 | 2007-07-01 00:00:00 | 2008-04-01 00:00:00 | 2008-07-01 00:00:00 | 2008-12-30 00:00:00 | 2008-10-01 00:00:00 | 1900-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-07-01 00:00:00 | 2009-04-01 00:00:00 | 2010-01-01 00:00:00 | 2009-10-01 00:00:00 | 2010-04-01 00:00:00 | 2010-07-01 00:00:00 | 1900-01-01 00:00:00 | 2010-12-27 00:00:00 | 2010-12-27 00:00:00 | 2010-10-01 00:00:00 | 2011-04-01 00:00:00 | 2011-01-01 00:00:00 | 2011-10-01 00:00:00 | 2011-07-01 00:00:00 | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 2013-10-01 00:00:00 | 1900-01-01 00:00:00 | 2014-10-01 00:00:00 | 2015-01-02 00:00:00 | 2012-07-01 00:00:00 | 2014-04-01 00:00:00 | 1900-01-01 00:00:00 | 2012-10-01 00:00:00 | 2012-12-12 00:00:00 | 2013-01-01 00:00:00 | 2015-07-01 00:00:00 | 2017-10-01 00:00:00 | 2019-04-01 00:00:00 | 2019-10-01 00:00:00 | 2020-01-01 00:00:00 | 2017-07-01 00:00:00 | 2019-07-01 00:00:00 | 2020-04-01 00:00:00 | 2018-04-01 00:00:00 | 2015-10-01 00:00:00 | 2016-01-01 00:00:00 | 2016-04-01 00:00:00 | 2016-07-01 00:00:00 | 2016-10-01 00:00:00 | 2017-01-17 00:00:00 | 1900-01-01 00:00:00 | 2017-04-01 00:00:00 | 2017-01-01 00:00:00 | 2018-10-01 00:00:00 | 1900-01-01 00:00:00 | 2020-12-10 00:00:00 | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | 2018-07-01 00:00:00 | 2018-01-01 00:00:00 | 2018-11-19 00:00:00 | 2020-07-01 00:00:00 | 2020-10-01 00:00:00 | 2021-07-01 00:00:00 | 2022-04-01 00:00:00 | 2022-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-04-01 00:00:00 | 2021-10-01 00:00:00 | 2022-07-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1997-09-30 00:00:00 | 1997-06-30 00:00:00 | 1998-12-31 00:00:00 | 1998-03-31 00:00:00 | 1999-06-30 00:00:00 | 1999-09-30 00:00:00 | 1997-12-31 00:00:00 | 1998-06-30 00:00:00 | 1999-03-31 00:00:00 | 1998-09-30 00:00:00 | 2000-03-31 00:00:00 | 2000-03-31 00:00:00 | 1999-12-31 00:00:00 | 2000-06-30 00:00:00 | 2000-09-30 00:00:00 | 2000-06-30 00:00:00 | 1900-01-01 00:00:00 | 2000-12-31 00:00:00 | 2000-12-31 00:00:00 | 2000-09-30 00:00:00 | 2001-03-31 00:00:00 | 1900-01-01 00:00:00 | 2001-03-31 00:00:00 | 2001-09-30 00:00:00 | 2001-06-30 00:00:00 | 2001-06-30 00:00:00 | 2001-09-30 00:00:00 | 2001-12-31 00:00:00 | 2001-12-31 00:00:00 | 2002-03-31 00:00:00 | 2002-06-30 00:00:00 | 2002-03-31 00:00:00 | 2002-09-30 00:00:00 | 2002-06-30 00:00:00 | 2002-12-31 00:00:00 | 1900-01-01 00:00:00 | 2002-09-30 00:00:00 | 2002-12-31 00:00:00 | 1900-01-01 00:00:00 | 2003-03-31 00:00:00 | 2003-03-31 00:00:00 | 2003-06-30 00:00:00 | 2003-06-30 00:00:00 | 2003-09-30 00:00:00 | 2003-09-30 00:00:00 | 2003-12-31 00:00:00 | 2004-06-30 00:00:00 | 2004-03-31 00:00:00 | 2004-06-30 00:00:00 | 2004-03-31 00:00:00 | 2003-12-31 00:00:00 | 2004-09-30 00:00:00 | 2004-09-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2004-12-31 00:00:00 | 2005-06-30 00:00:00 | 2005-03-31 00:00:00 | 2004-12-31 00:00:00 | 2005-12-31 00:00:00 | 2005-09-30 00:00:00 | 2006-03-31 00:00:00 | 2006-06-30 00:00:00 | 2006-09-30 00:00:00 | 2007-01-02 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2006-12-31 00:00:00 | 2007-06-30 00:00:00 | 2007-03-31 00:00:00 | 2007-12-31 00:00:00 | 2013-06-30 00:00:00 | 2015-06-30 00:00:00 | 2015-03-31 00:00:00 | 1900-01-01 00:00:00 | 2014-03-31 00:00:00 | 2013-09-30 00:00:00 | 2014-09-30 00:00:00 | 2008-03-31 00:00:00 | 2007-09-30 00:00:00 | 2008-06-30 00:00:00 | 2008-09-30 00:00:00 | 2008-12-30 00:00:00 | 2008-12-31 00:00:00 | 1900-01-01 00:00:00 | 2009-03-31 00:00:00 | 2009-09-30 00:00:00 | 2009-06-30 00:00:00 | 2010-03-31 00:00:00 | 2009-12-31 00:00:00 | 2010-06-30 00:00:00 | 2010-09-30 00:00:00 | 1900-01-01 00:00:00 | 2010-12-27 00:00:00 | 2010-12-27 00:00:00 | 2010-12-31 00:00:00 | 2011-06-30 00:00:00 | 2011-03-31 00:00:00 | 2011-12-31 00:00:00 | 2011-09-30 00:00:00 | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 2013-12-31 00:00:00 | 1900-01-01 00:00:00 | 2014-12-31 00:00:00 | 2015-01-02 00:00:00 | 2012-09-30 00:00:00 | 2014-06-30 00:00:00 | 1900-01-01 00:00:00 | 2012-12-31 00:00:00 | 2012-12-12 00:00:00 | 2013-03-31 00:00:00 | 2015-09-30 00:00:00 | 2017-12-31 00:00:00 | 2019-06-30 00:00:00 | 2019-12-31 00:00:00 | 2020-03-31 00:00:00 | 2017-09-30 00:00:00 | 2019-09-30 00:00:00 | 2020-06-30 00:00:00 | 2018-06-30 00:00:00 | 2015-12-31 00:00:00 | 2016-03-31 00:00:00 | 2016-06-30 00:00:00 | 2016-09-30 00:00:00 | 2016-12-31 00:00:00 | 2017-01-17 00:00:00 | 1900-01-01 00:00:00 | 2017-06-30 00:00:00 | 2017-03-31 00:00:00 | 2018-12-31 00:00:00 | 1900-01-01 00:00:00 | 2020-12-10 00:00:00 | 2019-03-31 00:00:00 | 2021-03-31 00:00:00 | 2018-09-30 00:00:00 | 2018-03-31 00:00:00 | 2018-11-19 00:00:00 | 2020-09-30 00:00:00 | 2020-12-31 00:00:00 | 2021-09-30 00:00:00 | 2022-06-30 00:00:00 | 2022-03-31 00:00:00 | 1900-01-01 00:00:00 | 2021-06-30 00:00:00 | 2021-12-31 00:00:00 | 2022-09-30 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 22001 | None | None | None | None | None | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | None | None | 22001 | None | 22001 | None | None | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22001 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 |
filer_id | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |||||||||||||
active | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | |||||||||||||
race | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | |||||||||||||
session_id | 2001 | 1997 | 1999 | 2003 | 2005 | 2007 | 2011 | 2009 | 2013 | 2021 | 2015 | 2019 | 2017 | |||||||||||||
category | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | |||||||||||||
category_type | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | |||||||||||||
sub_category | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | |||||||||||||
effect_dt | 2001-01-01 00:00:00 | 1997-05-15 00:00:00 | 1999-01-01 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2011-01-01 00:00:00 | 2009-01-01 00:00:00 | 2013-01-01 00:00:00 | 2021-01-01 00:00:00 | 2015-01-01 00:00:00 | 2019-01-01 00:00:00 | 2017-01-01 00:00:00 | |||||||||||||
sub_category_type | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | |||||||||||||
election_type | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | |||||||||||||
sub_category_a | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
nyq_dt | None | None | None | None | 2000-01-01 00:00:00 | 2000-01-01 00:00:00 | None | None | None | None | None | None | None | |||||||||||||
party_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
county_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
district_cd | None | None | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1149251 | |
---|---|---|
xref_id | L25457 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | L25457 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ACTIVE | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
effect_dt | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
naml | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | BERNACCHI | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namf | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE | EDDIE | EDDIE | EDDIE | EDDIE | EDDIE | EDDIE | EDDIE | EDDIE | EDDIE | EDDIE | EDDIE | EDDIE | EDDIE | EDDIE | EDDIE | EDDIE | EDDIE | EDDIE | EDDIE | EDDIE | EDDIE | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | EDDIE V. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
city | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | 9164443770 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | 9164426437 | 9164426437 | 9164426437 | 9164426437 | 9164426437 | 9164426437 | 9164426437 | 9164426437 | 9164426437 | 9164426437 | 9164426437 | 9164426437 | 9164426437 | 9164426437 | 9164426437 | 9164426437 | 9164426437 | 9164426437 | 9164426437 | 9164426437 | 9164426437 | 9164426437 | 9164426437 | 9164426437 | 9164426437 | 9164426437 | 9164426437 | 9164426437 | 9164426437 | 9164426437 | 9164426437 | 9164426437 | 9164426437 | 9164426437 | 9164426437 | 9164426437 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] |
filer_id | 1149251 |
---|
filer_id | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | 1149251 | ||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 624489_0.cal | 645084_0.cal | 17182.cal | 682276_0.cal | 713615_0.cal | 745397_0.cal | 772026_0.cal | 789545_0.cal | 809627_0.cal | 837778_0.cal | 854198_0.cal | 881517_0.cal | 907288_0.cal | 929636_0.cal | 946267_0.cal | 969505_0.cal | 987992_0.cal | 1013718_0.cal | 1029483_0.cal | 1058766_0.cal | 1081979_0.cal | 1103828_0.cal | 1119498_0.cal | 1132998_0.cal | 1144948_0.cal | 1166991_0.cal | 1190187_0.cal | 1554151_0.cal | 1554151_1.cal | 1217241_0.cal | 1235344_0.cal | 1225882_0.cal | 1261507_0.cal | 1298164_0.cal | 1284302_0.cal | 1386747_0.cal | 1305630_0.cal | 1716888_0.cal | 2120261_0.cal | 1922493_0.cal | 2325995_0.cal | 2536531_0.cal | ||||||||||||||||||||||||||||||||||||||||||
received_date | 2000-05-01 00:00:00 | 2000-07-31 00:00:00 | 2000-07-31 00:00:00 | 2000-10-31 00:00:00 | 2001-01-23 00:00:00 | 2001-04-30 00:00:00 | 2001-07-30 00:00:00 | 2001-10-26 00:00:00 | 2002-01-24 00:00:00 | 2002-04-26 00:00:00 | 2002-07-30 00:00:00 | 2002-10-29 00:00:00 | 2003-01-28 00:00:00 | 2003-04-28 00:00:00 | 2003-07-30 00:00:00 | 2003-10-31 00:00:00 | 2004-01-29 00:00:00 | 2004-04-30 00:00:00 | 2004-07-30 00:00:00 | 2004-11-01 00:00:00 | 2005-02-01 00:00:00 | 2005-04-28 00:00:00 | 2005-08-01 00:00:00 | 2005-10-30 00:00:00 | 2006-01-26 00:00:00 | 2006-04-28 00:00:00 | 2006-07-30 00:00:00 | 2010-12-27 00:00:00 | 2010-12-27 00:00:00 | 2006-10-31 00:00:00 | 2007-01-30 00:00:00 | 2007-01-02 00:00:00 | 2007-04-30 00:00:00 | 2007-11-01 00:00:00 | 2007-07-31 00:00:00 | 2008-12-30 00:00:00 | 2008-01-24 00:00:00 | 2012-12-12 00:00:00 | 2017-01-17 00:00:00 | 2015-01-02 00:00:00 | 2018-11-19 00:00:00 | 2020-12-10 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||
filing_directory | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /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 | 624489 | 645084 | None | 682276 | 713615 | 745397 | 772026 | 789545 | 809627 | 837778 | 854198 | 881517 | 907288 | 929636 | 946267 | 969505 | 987992 | 1013718 | 1029483 | 1058766 | 1081979 | 1103828 | 1119498 | 1132998 | 1144948 | 1166991 | 1190187 | 1554151 | 1554151 | 1217241 | 1235344 | 1225882 | 1261507 | 1298164 | 1284302 | 1386747 | 1305630 | 1716888 | 2120261 | 1922493 | 2325995 | 2536531 | ||||||||||||||||||||||||||||||||||||||||||
form_id | F615 | F615 | None | 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 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F604 | F604 | F604 | F604 | F604 | ||||||||||||||||||||||||||||||||||||||||||
receive_comment | Filing accepted | Filing accepted | Filing pass validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing 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 |