filer_id | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 2011546 | 990084 | 2046661 | 2081410 | 2116650 | 2160830 | 2204264 | 2411598 | 2470897 | 2273176 | 2509184 | 2339794 | 2550485 | |||||||||||||
effect_dt | 2001-01-01 00:00:00 | 1999-12-13 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2013-01-01 00:00:00 | 2021-01-01 00:00:00 | 2015-01-01 00:00:00 | 2023-01-01 00:00:00 | |||||||||||||
add_type | 7051 | 7050 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | |||||||||||||
session_id | 2001 | 1999 | 2003 | 2005 | 2007 | 2009 | 2011 | 2017 | 2019 | 2013 | 2021 | 2015 | 2023 |
filer_id | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 1999 | 2001 | 2003 | 2007 | 2009 | 2005 | 2011 | 2015 | 2013 | 2017 | 2019 | 2021 | ||||||||||||
ethics_date | 2000-02-17 00:00:00 | 2000-02-17 00:00:00 | 2002-11-13 00:00:00 | 2006-11-16 00:00:00 | 2009-01-16 00:00:00 | 2004-11-17 00:00:00 | 2011-01-13 00:00:00 | 2014-11-13 00:00:00 | 2012-11-08 00:00:00 | 2016-11-17 00:00:00 | 2018-11-15 00:00:00 | 2020-11-17 00:00:00 |
filer_id | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 658746 | 1414074 | 1414074 | 623907 | 624282 | 625297 | 657845 | 711361 | 715112 | 698868 | 745763 | 777106 | 786629 | 784978 | 815406 | 800699 | 814513 | 837146 | 850776 | 847811 | 842035 | 890617 | 858917 | 882478 | 909856 | 919227 | 931784 | 913965 | 953448 | 942383 | 962280 | 939156 | 989334 | 971933 | 986325 | 1009404 | 1008357 | 1025613 | 1031417 | 1047679 | 1075391 | 1062564 | 1094960 | 1101276 | 1086373 | 1130004 | 1111780 | 1165298 | 1143214 | 1188353 | 1209396 | 1248459 | 1249524 | 1254489 | 1280268 | 1261335 | 1308922 | 1293705 | 1778591 | 1978051 | 1869203 | 1797916 | 1958576 | 1944856 | 1931954 | 1898334 | 1328261 | 1348747 | 1367927 | 1394030 | 1399742 | 1420885 | 1462040 | 1436199 | 1451122 | 1479841 | 1504045 | 1536311 | 1559109 | 1559109 | 1589194 | 1568400 | 1604088 | 1618908 | 1632745 | 1656779 | 1674510 | 1814622 | 1919993 | 1719424 | 1706108 | 1742836 | 1737359 | 1843682 | 1764336 | 1996629 | 2343469 | 2331035 | 2394500 | 2342761 | 2415398 | 2240003 | 2009600 | 2032307 | 2058070 | 2100323 | 2125705 | 2123905 | 2114248 | 2155083 | 2174834 | 2276652 | 2482240 | 2466146 | 2317148 | 2433336 | 2537841 | 2375326 | 2545683 | 2513096 | 2557582 | 2192694 | 2207643 | 2698564 | 2634102 | 2666839 | 2618945 | 2574756 | 2596735 | 2739955 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | None | None | None | None | None | 161 | 162 | None | 164 | 163 | 165 | None | None | None | None | None | 168 | 169 | 170 | None | None | None | None | 171 | 172 | None | 173 | None | None | 174 | 175 | None | None | None | 176 | None | 177 | 178 | None | 179 | 180 | None | None | 181 | None | 183 | 182 | 185 | 184 | 186 | 187 | 188 | None | 189 | 190 | 189 | 192 | 191 | 214 | 222 | 218 | 215 | 221 | None | 220 | 219 | 193 | 194 | 195 | 196 | None | 197 | 200 | 198 | 199 | 201 | 202 | 203 | None | None | 205 | 204 | 206 | 207 | 208 | 209 | 210 | 216 | 220 | 212 | 211 | None | 212 | 217 | 213 | 223 | 236 | 236 | 238 | None | 239 | 233 | 224 | 225 | 226 | 227 | None | 228 | 228 | 229 | 230 | 234 | 242 | 241 | 235 | 240 | 244 | 237 | 244 | 243 | None | 231 | 232 | 250 | 248 | 249 | 247 | 245 | 246 | 251 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F615 | F604 | F604 | F604 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F604 | F606 | F615 | F615 | F615 | F615 | F615 | F690 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F606 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 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 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 2000-08-14 00:00:00 | 2008-12-23 00:00:00 | 2009-01-16 00:00:00 | 2000-02-17 00:00:00 | 2000-12-16 00:00:00 | 2000-05-01 00:00:00 | 2000-07-31 00:00:00 | 2000-11-30 00:00:00 | 2001-01-25 00:00:00 | 2000-10-31 00:00:00 | 2001-04-27 00:00:00 | 2001-07-31 00:00:00 | 2001-10-02 00:00:00 | 2001-10-02 00:00:00 | 2002-01-31 00:00:00 | 2001-12-10 00:00:00 | 2002-01-31 00:00:00 | 2002-04-24 00:00:00 | 2002-07-22 00:00:00 | 2002-04-30 00:00:00 | 2002-04-30 00:00:00 | 2002-10-31 00:00:00 | 2002-07-31 00:00:00 | 2002-10-29 00:00:00 | 2003-01-30 00:00:00 | 2003-01-31 00:00:00 | 2003-04-30 00:00:00 | 2003-01-03 00:00:00 | 2003-07-30 00:00:00 | 2003-07-17 00:00:00 | 2003-10-07 00:00:00 | 2003-04-30 00:00:00 | 2004-01-28 00:00:00 | 2003-10-10 00:00:00 | 2004-01-26 00:00:00 | 2004-04-15 00:00:00 | 2004-04-05 00:00:00 | 2004-07-26 00:00:00 | 2004-07-29 00:00:00 | 2004-10-14 00:00:00 | 2005-01-25 00:00:00 | 2004-10-22 00:00:00 | 2005-01-04 00:00:00 | 2005-04-19 00:00:00 | 2005-01-31 00:00:00 | 2005-10-25 00:00:00 | 2005-07-13 00:00:00 | 2006-04-26 00:00:00 | 2006-01-23 00:00:00 | 2006-07-27 00:00:00 | 2006-10-20 00:00:00 | 2007-02-26 00:00:00 | 2006-12-01 00:00:00 | 2007-03-23 00:00:00 | 2007-07-25 00:00:00 | 2007-04-30 00:00:00 | 2008-01-30 00:00:00 | 2007-10-19 00:00:00 | 2013-07-26 00:00:00 | 2015-07-27 00:00:00 | 2014-07-30 00:00:00 | 2013-10-28 00:00:00 | 2015-04-16 00:00:00 | 2014-12-18 00:00:00 | 2015-01-28 00:00:00 | 2014-10-15 00:00:00 | 2008-04-29 00:00:00 | 2008-07-30 00:00:00 | 2008-10-21 00:00:00 | 2009-01-29 00:00:00 | 2008-12-23 00:00:00 | 2009-04-30 00:00:00 | 2010-01-28 00:00:00 | 2009-07-30 00:00:00 | 2009-10-29 00:00:00 | 2010-04-14 00:00:00 | 2010-07-28 00:00:00 | 2010-10-27 00:00:00 | 2010-12-28 00:00:00 | 2011-01-27 00:00:00 | 2011-04-28 00:00:00 | 2011-01-28 00:00:00 | 2011-07-27 00:00:00 | 2011-10-24 00:00:00 | 2012-01-27 00:00:00 | 2012-04-30 00:00:00 | 2012-07-25 00:00:00 | 2014-01-28 00:00:00 | 2014-12-22 00:00:00 | 2012-12-21 00:00:00 | 2012-10-28 00:00:00 | 2012-12-14 00:00:00 | 2013-01-30 00:00:00 | 2014-04-29 00:00:00 | 2013-04-30 00:00:00 | 2015-10-30 00:00:00 | 2019-01-29 00:00:00 | 2018-12-29 00:00:00 | 2019-07-28 00:00:00 | 2018-12-27 00:00:00 | 2019-10-24 00:00:00 | 2018-04-27 00:00:00 | 2016-01-28 00:00:00 | 2016-04-25 00:00:00 | 2016-07-25 00:00:00 | 2016-10-29 00:00:00 | 2016-12-21 00:00:00 | 2017-01-25 00:00:00 | 2016-12-27 00:00:00 | 2017-04-27 00:00:00 | 2017-07-30 00:00:00 | 2018-07-31 00:00:00 | 2020-07-28 00:00:00 | 2020-04-17 00:00:00 | 2018-10-30 00:00:00 | 2020-01-22 00:00:00 | 2020-12-21 00:00:00 | 2019-04-21 00:00:00 | 2021-01-21 00:00:00 | 2020-10-11 00:00:00 | 2020-12-16 00:00:00 | 2017-10-30 00:00:00 | 2018-01-29 00:00:00 | 2022-07-18 00:00:00 | 2022-01-12 00:00:00 | 2022-04-15 00:00:00 | 2021-10-25 00:00:00 | 2021-04-16 00:00:00 | 2021-07-26 00:00:00 | 2022-10-24 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10005 | 10001 | 10006 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10001 | 10001 | 10001 | 10006 | 10005 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10006 | 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 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 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 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1999 | 2009 | 2009 | 1999 | 1999 | 1999 | 1999 | 2001 | 1999 | 1999 | 2001 | 2001 | 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 | 2003 | 2003 | 2003 | 2005 | 2005 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2013 | 2015 | 2013 | 2013 | 2015 | 2015 | 2013 | 2013 | 2007 | 2007 | 2007 | 2007 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2011 | 2011 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2015 | 2013 | 2011 | 2013 | 2011 | 2013 | 2013 | 2015 | 2017 | 2019 | 2019 | 2019 | 2019 | 2017 | 2015 | 2015 | 2015 | 2015 | 2017 | 2015 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2017 | 2019 | 2021 | 2019 | 2019 | 2019 | 2021 | 2017 | 2017 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | DHORRELL | DMCCASTL | JINGRAM | DHULSE | DHULSE | GGILMORE | TTHAM | GKURIMOT | MHOANG | MKIENG | SARRIAGA | YBONILLA | SARRIAGA | CFLAGG | YBONILLA | GGILMORE | * | * | * | LTHIBAUL | YBONILLA | YBONILLA | YBONILLA | * | COMPLETED | YBONILLA | COMPLETED | BSMITH | YBONILLA | COMPLETED | COMPLETED | YBONILLA | LTHIBAUL | YBONILLA | COMPLETED | LTHIBAUL | COMPLETED | COMPLETED | LTHIBAUL | COMPLETED | COMPLETED | YRODRIGU | PBANFORD | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | LTHIBAUL | YRODRIGU | YRODRIGU | YRODRIGU | SARRIAGA | * | LTHIBAUL | YRODRIGU | LTHIBAUL | LTHIBAUL | ASAETERN | JINGRAM | AGLADNEY | ASAETERN | JINGRAM | ASAETERN | AGLADNEY | ASAETERN | LTHIBAUL | LTHIBAUL | JINGRAM | JINGRAM | YRODRIGU | JINGRAM | JINGRAM | JINGRAM | JINGRAM | JINGRAM | ASAETERN | ASAETERN | PBANFORD | PBANFORD | JINGRAM | ASAETERN | ASAETERN | ASAETERN | ASAETERN | ASAETERN | AGLADNEY | ASAETERN | ASAETERN | SARRIAGA | ASAETERN | SARRIAGA | ASAETERN | ASAETERN | ASAETERN | JINGRAM | JFRONEFIELD | YRODRIGU | VUKSTINA | YRODRIGU | VUKSTINA | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | DWALKER | AGLADNEY | CAFILER | SMCCONNAN | SMCCONNAN | AGLADNEY | VUKSTINA | VUKSTINA | JFRONEFIELD | VUKSTINA | MMERCHANT | JFRONEFIELD | JRAMOS | MKIRKHAM | MMERCHANT | AGLADNEY | AGLADNEY | CAFILER | RATTIYEH | CAFILER | MKIRKHAM | GTAYLOR | CHATRIDGE | CAFILER | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11002 | 11003 | 11002 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 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 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1999-10-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1999-01-01 00:00:00 | None | 2000-01-01 00:00:00 | 2000-04-01 00:00:00 | 1900-01-01 00:00:00 | 2000-10-01 00:00:00 | 2000-07-01 00:00:00 | 2001-01-01 00:00:00 | 2001-04-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2001-10-01 00:00:00 | 2001-07-01 00:00:00 | 2001-10-01 00:00:00 | 2002-01-01 00:00:00 | 2002-04-01 00:00:00 | 2001-04-01 00:00:00 | 2002-01-01 00:00:00 | 2002-07-01 00:00:00 | 2002-04-01 00:00:00 | 2002-07-01 00:00:00 | 2002-10-01 00:00:00 | 2002-10-01 00:00:00 | 2003-01-01 00:00:00 | 1900-01-01 00:00:00 | 2003-04-01 00:00:00 | 2003-04-01 00:00:00 | 2003-07-01 00:00:00 | 2003-01-01 00:00:00 | 2003-10-01 00:00:00 | 2003-07-01 00:00:00 | 2003-10-01 00:00:00 | 2004-01-01 00:00:00 | 2004-01-01 00:00:00 | 2004-04-01 00:00:00 | 2004-04-01 00:00:00 | 2004-07-01 00:00:00 | 2004-10-01 00:00:00 | 2004-07-01 00:00:00 | 1900-01-01 00:00:00 | 2005-01-01 00:00:00 | 2004-10-01 00:00:00 | 2005-07-01 00:00:00 | 2005-04-01 00:00:00 | 2006-01-01 00:00:00 | 2005-10-01 00:00:00 | 2006-04-01 00:00:00 | 2006-07-01 00:00:00 | 2006-10-01 00:00:00 | 1900-01-01 00:00:00 | 2007-03-23 00:00:00 | 2007-04-01 00:00:00 | 2007-01-01 00:00:00 | 2007-10-01 00:00:00 | 2007-07-01 00:00:00 | 2013-04-01 00:00:00 | 2015-04-01 00:00:00 | 2014-04-01 00:00:00 | 2013-07-01 00:00:00 | 2015-01-01 00:00:00 | 1900-01-01 00:00:00 | 2014-10-01 00:00:00 | 2014-07-01 00:00:00 | 2008-01-01 00:00:00 | 2008-04-01 00:00:00 | 2008-07-01 00:00:00 | 2008-10-01 00:00:00 | 1900-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-10-01 00:00:00 | 2009-04-01 00:00:00 | 2009-07-01 00:00:00 | 2010-01-01 00:00:00 | 2010-04-01 00:00:00 | 2010-07-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2011-01-01 00:00:00 | 2010-10-01 00:00:00 | 2011-04-01 00:00:00 | 2011-07-01 00:00:00 | 2011-10-01 00:00:00 | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 2013-10-01 00:00:00 | 2014-12-22 00:00:00 | 2012-12-21 00:00:00 | 2012-07-01 00:00:00 | 1900-01-01 00:00:00 | 2012-10-01 00:00:00 | 2014-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-07-01 00:00:00 | 2018-10-01 00:00:00 | 2018-12-29 00:00:00 | 2019-04-01 00:00:00 | 1900-01-01 00:00:00 | 2019-07-01 00:00:00 | 2018-01-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 | 1900-01-01 00:00:00 | 2016-10-01 00:00:00 | 2016-12-27 00:00:00 | 2017-01-01 00:00:00 | 2017-04-01 00:00:00 | 2018-04-01 00:00:00 | 2020-04-01 00:00:00 | 2020-01-01 00:00:00 | 2018-07-01 00:00:00 | 2019-10-01 00:00:00 | 2020-12-21 00:00:00 | 2019-01-01 00:00:00 | 2020-10-01 00:00:00 | 2020-07-01 00:00:00 | 1900-01-01 00:00:00 | 2017-07-01 00:00:00 | 2017-10-01 00:00:00 | 2022-04-01 00:00:00 | 2021-10-01 00:00:00 | 2022-01-01 00:00:00 | 2021-07-01 00:00:00 | 2021-01-01 00:00:00 | 2021-04-01 00:00:00 | 2022-07-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1999-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2000-12-31 00:00:00 | None | 2000-03-31 00:00:00 | 2000-06-30 00:00:00 | 1900-01-01 00:00:00 | 2000-12-31 00:00:00 | 2000-09-30 00:00:00 | 2001-03-31 00:00:00 | 2001-06-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2001-12-31 00:00:00 | 2001-09-30 00:00:00 | 2001-12-31 00:00:00 | 2002-03-31 00:00:00 | 2002-06-30 00:00:00 | 2001-06-30 00:00:00 | 2002-03-31 00:00:00 | 2002-09-30 00:00:00 | 2002-06-30 00:00:00 | 2002-09-30 00:00:00 | 2002-12-31 00:00:00 | 2002-12-31 00:00:00 | 2003-03-31 00:00:00 | 1900-01-01 00:00:00 | 2003-06-30 00:00:00 | 2003-06-30 00:00:00 | 2003-09-30 00:00:00 | 2003-03-31 00:00:00 | 2003-12-31 00:00:00 | 2003-09-30 00:00:00 | 2003-12-31 00:00:00 | 2004-03-31 00:00:00 | 2004-03-31 00:00:00 | 2004-06-30 00:00:00 | 2004-06-30 00:00:00 | 2004-09-30 00:00:00 | 2004-12-31 00:00:00 | 2004-09-30 00:00:00 | 1900-01-01 00:00:00 | 2005-03-31 00:00:00 | 2004-12-31 00:00:00 | 2005-09-30 00:00:00 | 2005-06-30 00:00:00 | 2006-03-31 00:00:00 | 2005-12-31 00:00:00 | 2006-06-30 00:00:00 | 2006-09-30 00:00:00 | 2006-12-31 00:00:00 | 1900-01-01 00:00:00 | 2007-03-23 00:00:00 | 2007-06-30 00:00:00 | 2007-03-31 00:00:00 | 2007-12-31 00:00:00 | 2007-09-30 00:00:00 | 2013-06-30 00:00:00 | 2015-06-30 00:00:00 | 2014-06-30 00:00:00 | 2013-09-30 00:00:00 | 2015-03-31 00:00:00 | 1900-01-01 00:00:00 | 2014-12-31 00:00:00 | 2014-09-30 00:00:00 | 2008-03-31 00:00:00 | 2008-06-30 00:00:00 | 2008-09-30 00:00:00 | 2008-12-31 00:00:00 | 1900-01-01 00:00:00 | 2009-03-31 00:00:00 | 2009-12-31 00:00:00 | 2009-06-30 00:00:00 | 2009-09-30 00:00:00 | 2010-03-31 00:00:00 | 2010-06-30 00:00:00 | 2010-09-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2011-03-31 00:00:00 | 2010-12-31 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00 | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 2013-12-31 00:00:00 | 2014-12-22 00:00:00 | 2012-12-21 00:00:00 | 2012-09-30 00:00:00 | 1900-01-01 00:00:00 | 2012-12-31 00:00:00 | 2014-03-31 00:00:00 | 2013-03-31 00:00:00 | 2015-09-30 00:00:00 | 2018-12-31 00:00:00 | 2018-12-29 00:00:00 | 2019-06-30 00:00:00 | 1900-01-01 00:00:00 | 2019-09-30 00:00:00 | 2018-03-31 00:00:00 | 2015-12-31 00:00:00 | 2016-03-31 00:00:00 | 2016-06-30 00:00:00 | 2016-09-30 00:00:00 | 1900-01-01 00:00:00 | 2016-12-31 00:00:00 | 2016-12-27 00:00:00 | 2017-03-31 00:00:00 | 2017-06-30 00:00:00 | 2018-06-30 00:00:00 | 2020-06-30 00:00:00 | 2020-03-31 00:00:00 | 2018-09-30 00:00:00 | 2019-12-31 00:00:00 | 2020-12-21 00:00:00 | 2019-03-31 00:00:00 | 2020-12-31 00:00:00 | 2020-09-30 00:00:00 | 1900-01-01 00:00:00 | 2017-09-30 00:00:00 | 2017-12-31 00:00:00 | 2022-06-30 00:00:00 | 2021-12-31 00:00:00 | 2022-03-31 00:00:00 | 2021-09-30 00:00:00 | 2021-03-31 00:00:00 | 2021-06-30 00:00:00 | 2022-09-30 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 22001 | None | 22006 | None | None | 22006 | 22006 | None | None | None | 22006 | None | 22006 | 22006 | None | 22006 | 22006 | None | None | 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 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 |
filer_id | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | ||||||||||||||
active | Y | Y | Y | Y | Y | Y | Y | T | Y | Y | Y | Y | Y | N | ||||||||||||||
race | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
session_id | 1999 | 2001 | 2003 | 2005 | 2007 | 2011 | 2013 | 2007 | 2009 | 2015 | 2021 | 2019 | 2017 | 2023 | ||||||||||||||
category | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
category_type | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
sub_category | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
effect_dt | 1999-12-13 00:00:00 | 2001-01-01 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2011-01-01 00:00:00 | 2013-01-01 00:00:00 | 2008-12-31 00:00:00 | 2009-01-01 00:00:00 | 2015-01-01 00:00:00 | 2021-01-01 00:00:00 | 2019-01-01 00:00:00 | 2017-01-01 00:00:00 | 2023-01-01 00:00:00 | ||||||||||||||
sub_category_type | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
election_type | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
sub_category_a | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
nyq_dt | None | None | None | 2001-10-01 00:00:00 | 2001-10-01 00:00:00 | None | None | None | None | None | None | None | None | None | ||||||||||||||
party_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
county_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
district_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1223770 | |
---|---|---|
xref_id | L25904 | |
effect_dt | 2000-05-26 00:00:00 | |
migration_source | CLAIMS |
xref_filer_id | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | L25904 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
effect_dt | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
naml | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | RASMUSSON | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namf | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC | ERIC | ERIC | ERIC | ERIC | ERIC | ERIC | ERIC | ERIC | ERIC | ERIC | ERIC | ERIC | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ERIC D. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
adr1 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
adr2 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
city | ROSEVILLE | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | ROSEVILLE | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | ROSEVILLE | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | ROSEVILLE | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | ROSEVILLE | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | ROSEVILLE | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | ROSEVILLE | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | ROSEVILLE | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | ROSEVILLE | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | ROSEVILLE | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | ROSEVILLE | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | ROSEVILLE | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
zip4 | 95747 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95747 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95747 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95747 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95747 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95747 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95747 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95747 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95747 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95747 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95747 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95747 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | 95816 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 9167837164 | 9164477419 | 9164477419 | 9164477419 | 9164477419 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9167837164 | 9164477419 | 9164477419 | 9164477419 | 9164477419 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9167837164 | 9164477419 | 9164477419 | 9164477419 | 9164477419 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9167837164 | 9164477419 | 9164477419 | 9164477419 | 9164477419 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9167837164 | 9164477419 | 9164477419 | 9164477419 | 9164477419 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9167837164 | 9164477419 | 9164477419 | 9164477419 | 9164477419 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9167837164 | 9164477419 | 9164477419 | 9164477419 | 9164477419 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9167837164 | 9164477419 | 9164477419 | 9164477419 | 9164477419 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9167837164 | 9164477419 | 9164477419 | 9164477419 | 9164477419 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9167837164 | 9164477419 | 9164477419 | 9164477419 | 9164477419 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9167837164 | 9164477419 | 9164477419 | 9164477419 | 9164477419 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9167837164 | 9164477419 | 9164477419 | 9164477419 | 9164477419 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | 9164470283 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | None | 9164471274 | 9164471274 | 9164471274 | 9164471274 | 9164471274 | 9164471274 | 9164471274 | None | 9164471274 | 9164471274 | 9164471274 | 9164471274 | 9164471274 | 9164471274 | 9164471274 | None | 9164471274 | 9164471274 | 9164471274 | 9164471274 | 9164471274 | 9164471274 | 9164471274 | None | 9164471274 | 9164471274 | 9164471274 | 9164471274 | 9164471274 | 9164471274 | 9164471274 | None | 9164471274 | 9164471274 | 9164471274 | 9164471274 | 9164471274 | 9164471274 | 9164471274 | None | 9164471274 | 9164471274 | 9164471274 | 9164471274 | 9164471274 | 9164471274 | 9164471274 | None | 9164471274 | 9164471274 | 9164471274 | 9164471274 | 9164471274 | 9164471274 | 9164471274 | None | 9164471274 | 9164471274 | 9164471274 | 9164471274 | 9164471274 | 9164471274 | 9164471274 | None | 9164471274 | 9164471274 | 9164471274 | 9164471274 | 9164471274 | 9164471274 | 9164471274 | None | 9164471274 | 9164471274 | 9164471274 | 9164471274 | 9164471274 | 9164471274 | 9164471274 | None | 9164471274 | 9164471274 | 9164471274 | 9164471274 | 9164471274 | 9164471274 | 9164471274 | None | 9164471274 | 9164471274 | 9164471274 | 9164471274 | 9164471274 | 9164471274 | 9164471274 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
[email protected] | [email protected] | None | None | None | ericrpaco.org | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | ericrpaco.org | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | ericrpaco.org | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | ericrpaco.org | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | ericrpaco.org | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | ericrpaco.org | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | ericrpaco.org | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | ericrpaco.org | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | ericrpaco.org | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | ericrpaco.org | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | ericrpaco.org | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | ericrpaco.org | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] |
filer_id | 1223770 |
---|
filer_id | 1223770 | 1223770 | 1223770 | |||
---|---|---|---|---|---|---|
change_no | 1 | 0 | 2 | |||
session_id | 2001 | 2001 | 2007 | |||
log_dt | 2001-10-02 00:00:00 | 2001-10-02 00:00:00 | 2008-12-23 00:00:00 | |||
filer_type | 4 | 4 | 4 | |||
correction_flg | Y | Y | None | |||
action | DELETED | ADDED | DELETED | |||
attribute_changed | LOBBYIST | LOBBYIST | FIRM | |||
ethics_dt | None | None | None | |||
interests | None | None | None | |||
filer_full_name | RASMUSSON, ERIC D. | RASMUSSON, ERIC. D. | ERIC D. RASMUSSON | |||
filer_city | None | None | None | |||
filer_st | None | None | None | |||
filer_zip | None | None | None | |||
filer_phone | None | None | None | |||
entity_type | 4 | 4 | 3 | |||
entity_name | RASMUSSON PUBLIC AFFAIRS | HOLLOWAY RASMUSSON & MOLODANOF | HOLLOWAY RASMUSSON & MOLODANOF | |||
entity_city | None | None | None | |||
entity_st | None | None | None | |||
entity_zip | None | None | None | |||
entity_phone | None | None | None | |||
entity_id | 1223617 | 1239025 | 1239025 | |||
responsible_officer | None | None | None | |||
effect_dt | 2001-10-01 00:00:00 | 2001-10-01 00:00:00 | 2008-12-31 00:00:00 |
filer_id | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | 1223770 | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 814513_0.cal | 837146_0.cal | 850776_0.cal | 882478_0.cal | 909856_0.cal | 931784_0.cal | 942383_0.cal | 962280_0.cal | 1254489_0.cal | 1719424_0.cal | 2114248_0.cal | 1919993_0.cal | 2331035_0.cal | 2537841_0.cal | ||||||||||||||
received_date | 2002-01-31 00:00:00 | 2002-04-24 00:00:00 | 2002-07-22 00:00:00 | 2002-10-29 00:00:00 | 2003-01-30 00:00:00 | 2003-04-30 00:00:00 | 2003-07-17 00:00:00 | 2003-10-07 00:00:00 | 2007-03-23 00:00:00 | 2012-12-21 00:00:00 | 2016-12-27 00:00:00 | 2014-12-22 00:00:00 | 2018-12-29 00:00:00 | 2020-12-21 00:00:00 | ||||||||||||||
filing_directory | /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 | ||||||||||||||
filing_id | 814513 | 837146 | 850776 | 882478 | 909856 | 931784 | 942383 | 962280 | 1254489 | 1719424 | 2114248 | 1919993 | 2331035 | 2537841 | ||||||||||||||
form_id | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F604 | F604 | F604 | F604 | ||||||||||||||
receive_comment | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted |