filer_id | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1101559 | 2043615 | 2079220 | 2114131 | 2159897 | 2203410 | 2409826 | 2548827 | 2469377 | 2279104 | 2338802 | 2506677 | ||||||||||||
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 | 2023-01-01 00:00:00 | 2019-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-01-01 00:00:00 | 2021-01-01 00:00:00 | ||||||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | ||||||||||||
session_id | 1999 | 2003 | 2005 | 2007 | 2009 | 2011 | 2017 | 2023 | 2019 | 2013 | 2015 | 2021 |
filer_id | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 1997 | 1999 | 2001 | 1995 | 2003 | 2005 | 2009 | 2007 | 2011 | 2013 | 2015 | 2017 | 2019 | 2021 | ||||||||||||||
ethics_date | 1998-03-27 00:00:00 | 1998-03-27 00:00:00 | 2000-11-14 00:00:00 | 1994-03-09 00:00:00 | 2002-11-13 00:00:00 | 2004-11-17 00:00:00 | 2008-11-12 00:00:00 | 2006-11-16 00:00:00 | 2010-07-09 00:00:00 | 2013-02-28 00:00:00 | 2014-11-13 00:00:00 | 2016-09-09 00:00:00 | 2018-11-15 00:00:00 | 2020-11-17 00:00:00 |
filer_id | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 515192 | 510434 | 512070 | 512884 | 513532 | 521409 | 521881 | 516041 | 516679 | 523508 | 523978 | 518321 | 519788 | 525611 | 526097 | 528126 | 523978 | 521881 | 519177 | 529631 | 527660 | 624278 | 625783 | 606095 | 643230 | 678514 | 654566 | 714321 | 712193 | 715911 | 686662 | 747160 | 745425 | 791661 | 776641 | 771533 | 780802 | 815640 | 793506 | 813469 | 842349 | 839192 | 855844 | 852461 | 890726 | 880739 | 916456 | 901312 | 929114 | 908751 | 933931 | 947058 | 951999 | 969387 | 972535 | 989890 | 1012410 | 990819 | 1026038 | 1023644 | 1015335 | 1052773 | 1074322 | 1062641 | 1062878 | 1082978 | 1081008 | 1102169 | 1113641 | 1145901 | 1133734 | 1167161 | 1186292 | 1213492 | 1235162 | 1236367 | 1280580 | 1261954 | 1261954 | 1307298 | 1295908 | 1778753 | 1963382 | 1974076 | 1872323 | 1797901 | 1945265 | 1906358 | 1345897 | 1329514 | 1392616 | 1384418 | 1419617 | 1378801 | 1435081 | 1408064 | 1450304 | 1462783 | 1480860 | 1502409 | 1534314 | 1551172 | 1552615 | 1565730 | 1602600 | 1622174 | 1588168 | 1634314 | 1657993 | 1657993 | 1676896 | 1931078 | 1918483 | 1701138 | 1729493 | 1716816 | 1725003 | 1842350 | 1838759 | 1751295 | 1764124 | 1991970 | 2465018 | 2241835 | 2536251 | 2572290 | 2379060 | 2272744 | 2338396 | 2479373 | 2337682 | 2005416 | 2032080 | 2057798 | 2096480 | 2114366 | 2122946 | 2132703 | 2170327 | 2157812 | 2310222 | 2518048 | 2192711 | 2391829 | 2337682 | 2558865 | 2432884 | 2327126 | 2202546 | 2414005 | 2704707 | 2598018 | 2635373 | 2677097 | 2545914 | 2616678 | 2738150 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 150 | 141 | 149 | 157 | 142 | 152 | 145 | 158 | 143 | 153 | 146 | 151 | 144 | 154 | 147 | 148 | 146 | 145 | 159 | 156 | 155 | 161 | 161 | 160 | 162 | 163 | 162 | 164 | None | 164 | 163 | 165 | 165 | 167 | None | 166 | None | None | None | 168 | None | 169 | None | 170 | None | 171 | None | None | 173 | 172 | None | 174 | None | 175 | None | 176 | 177 | None | None | 178 | None | 179 | 180 | 180 | None | None | None | 181 | 182 | 184 | 183 | 185 | 186 | 187 | 188 | None | 190 | 189 | 189 | 192 | 191 | 214 | 221 | 222 | 218 | 215 | None | 219 | 194 | 193 | 196 | 196 | 197 | 195 | 198 | None | 199 | 200 | 201 | 202 | 203 | 204 | None | 204 | 206 | 207 | 205 | 208 | 209 | 209 | 210 | 220 | 220 | 211 | 212 | 212 | None | 217 | 216 | None | 213 | 223 | 241 | 233 | 244 | 245 | 237 | 234 | None | 242 | 236 | 224 | 225 | 226 | 227 | 228 | 228 | None | 230 | 229 | 235 | 243 | 231 | 238 | 236 | None | 240 | 236 | 232 | 239 | 250 | 246 | 248 | 249 | 244 | 247 | 251 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F690 | F690 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 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 | 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 | 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 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1997-07-25 00:00:00 | 1995-04-28 00:00:00 | 1997-04-29 00:00:00 | 1999-04-29 00:00:00 | 1995-07-28 00:00:00 | 1998-01-20 00:00:00 | 1996-04-29 00:00:00 | 1999-07-22 00:00:00 | 1995-10-31 00:00:00 | 1998-04-28 00:00:00 | 1996-07-30 00:00:00 | 1997-10-17 00:00:00 | 1996-01-30 00:00:00 | 1998-07-23 00:00:00 | 1996-10-28 00:00:00 | 1997-01-30 00:00:00 | 1996-10-26 00:00:00 | 1996-07-30 00:00:00 | 1999-11-01 00:00:00 | 1999-01-28 00:00:00 | 1998-10-29 00:00:00 | 2000-05-01 00:00:00 | 2000-05-01 00:00:00 | 2000-01-31 00:00:00 | 2000-07-27 00:00:00 | 2000-10-27 00:00:00 | 2000-07-27 00:00:00 | 2001-01-25 00:00:00 | 2001-01-02 00:00:00 | 2001-01-26 00:00:00 | 2000-10-31 00:00:00 | 2001-04-30 00:00:00 | 2001-04-30 00:00:00 | 2001-10-31 00:00:00 | 2001-07-31 00:00:00 | 2001-07-30 00:00:00 | 2001-07-31 00:00:00 | 2002-01-31 00:00:00 | 2001-10-31 00:00:00 | 2002-01-31 00:00:00 | 2002-04-30 00:00:00 | 2002-04-30 00:00:00 | 2002-07-26 00:00:00 | 2002-07-26 00:00:00 | 2002-10-29 00:00:00 | 2002-10-27 00:00:00 | 2003-01-30 00:00:00 | 2002-12-30 00:00:00 | 2003-04-26 00:00:00 | 2003-01-29 00:00:00 | 2003-04-29 00:00:00 | 2003-07-30 00:00:00 | 2003-07-31 00:00:00 | 2003-10-30 00:00:00 | 2003-10-29 00:00:00 | 2004-01-31 00:00:00 | 2004-04-29 00:00:00 | 2004-01-29 00:00:00 | 2004-07-21 00:00:00 | 2004-07-19 00:00:00 | 2004-04-30 00:00:00 | 2004-10-24 00:00:00 | 2005-01-22 00:00:00 | 2004-11-24 00:00:00 | 2004-10-28 00:00:00 | 2004-12-21 00:00:00 | 2005-01-26 00:00:00 | 2005-04-23 00:00:00 | 2005-07-23 00:00:00 | 2006-01-28 00:00:00 | 2005-10-31 00:00:00 | 2006-04-29 00:00:00 | 2006-07-22 00:00:00 | 2006-10-27 00:00:00 | 2007-01-30 00:00:00 | 2006-12-19 00:00:00 | 2007-07-25 00:00:00 | 2007-04-30 00:00:00 | 2007-04-30 00:00:00 | 2008-01-28 00:00:00 | 2007-10-29 00:00:00 | 2013-07-26 00:00:00 | 2015-04-28 00:00:00 | 2015-07-13 00:00:00 | 2014-07-31 00:00:00 | 2013-10-28 00:00:00 | 2014-12-30 00:00:00 | 2014-10-27 00:00:00 | 2008-07-24 00:00:00 | 2008-04-30 00:00:00 | 2009-01-27 00:00:00 | 2008-12-18 00:00:00 | 2009-04-28 00:00:00 | 2008-10-31 00:00:00 | 2009-07-28 00:00:00 | 2008-12-18 00:00:00 | 2009-10-27 00:00:00 | 2010-01-29 00:00:00 | 2010-04-20 00:00:00 | 2010-07-22 00:00:00 | 2010-10-25 00:00:00 | 2010-12-16 00:00:00 | 2010-12-20 00:00:00 | 2011-01-25 00:00:00 | 2011-07-24 00:00:00 | 2011-10-31 00:00:00 | 2011-04-25 00:00:00 | 2012-01-30 00:00:00 | 2012-04-30 00:00:00 | 2012-04-30 00:00:00 | 2012-07-30 00:00:00 | 2015-01-27 00:00:00 | 2014-12-16 00:00:00 | 2012-10-22 00:00:00 | 2013-01-21 00:00:00 | 2012-12-11 00:00:00 | 2012-12-17 00:00:00 | 2014-04-28 00:00:00 | 2014-04-16 00:00:00 | 2013-02-28 00:00:00 | 2013-04-29 00:00:00 | 2015-10-14 00:00:00 | 2020-04-06 00:00:00 | 2018-04-30 00:00:00 | 2020-12-07 00:00:00 | 2021-04-06 00:00:00 | 2019-04-29 00:00:00 | 2018-07-30 00:00:00 | 2018-12-21 00:00:00 | 2020-07-20 00:00:00 | 2019-01-22 00:00:00 | 2016-01-21 00:00:00 | 2016-04-25 00:00:00 | 2016-07-25 00:00:00 | 2016-10-26 00:00:00 | 2016-12-28 00:00:00 | 2017-01-24 00:00:00 | 2016-12-28 00:00:00 | 2017-07-24 00:00:00 | 2017-05-01 00:00:00 | 2018-10-22 00:00:00 | 2020-10-19 00:00:00 | 2017-10-30 00:00:00 | 2019-07-22 00:00:00 | 2019-01-22 00:00:00 | 2020-12-15 00:00:00 | 2020-01-21 00:00:00 | 2018-12-03 00:00:00 | 2018-01-17 00:00:00 | 2019-10-21 00:00:00 | 2022-07-29 00:00:00 | 2021-07-28 00:00:00 | 2022-01-19 00:00:00 | 2022-05-02 00:00:00 | 2021-01-22 00:00:00 | 2021-10-19 00:00:00 | 2022-10-20 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10005 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 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 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1997 | 1995 | 1997 | 1999 | 1995 | 1997 | 1995 | 1999 | 1995 | 1997 | 1995 | 1997 | 1995 | 1997 | 1995 | 1995 | 1995 | 1995 | 1999 | 1997 | 1997 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 2001 | 1999 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2003 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2003 | 2005 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2013 | 2015 | 2015 | 2013 | 2013 | 2015 | 2013 | 2007 | 2007 | 2007 | 2009 | 2009 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2011 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2015 | 2011 | 2011 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2015 | 2019 | 2017 | 2021 | 2021 | 2019 | 2017 | 2019 | 2019 | 2017 | 2015 | 2015 | 2015 | 2015 | 2017 | 2015 | 2017 | 2017 | 2017 | 2017 | 2019 | 2017 | 2019 | 2017 | 2021 | 2019 | 2019 | 2017 | 2019 | 2021 | 2021 | 2021 | 2021 | 2019 | 2021 | 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | CFLAGG | TTHAM | * | * | * | TTHAM | * | NJACKSON | GPEREZ | GPEREZ | GPEREZ | * | * | GPEREZ | * | LTHIBAUL | YBONILLA | YBONILLA | * | YBONILLA | * | YBONILLA | * | YBONILLA | * | YBONILLA | GPEREZ | COMPLETED | COMPLETED | YBONILLA | COMPLETED | KVANG | COMPLETED | YBONILLA | COMPLETED | COMPLETED | EMCENTEE | EMCENTEE | COMPLETED | KLARRY | COMPLETED | COMPLETED | COMPLETED | YRODRIGU | CFLAGG | YRODRIGU | YRODRIGU | YRODRIGU | LTHIBAUL | YRODRIGU | YRODRIGU | YRODRIGU | JMARTIN | YRODRIGU | CFLAGG | LTHIBAUL | YRODRIGU | YRODRIGU | LTHIBAUL | LTHIBAUL | ASAETERN | AGLADNEY | JINGRAM | ASAETERN | ASAETERN | YRODRIGU | ASAETERN | LTHIBAUL | LTHIBAUL | YRODRIGU | * | YRODRIGU | YRODRIGU | YRODRIGU | PBANFORD | YRODRIGU | YRODRIGU | JINGRAM | ASAETERN | ASAETERN | * | PBANFORD | ASAETERN | ASAETERN | ASAETERN | JINGRAM | ASAETERN | ASAETERN | ASAETERN | AGLADNEY | AGLADNEY | YRODRIGU | ASAETERN | ASAETERN | SARRIAGA | SARRIAGA | ASAETERN | RGEREMIA | SMCCONNAN | ASAETERN | JINGRAM | GTAYLOR | AGLADNEY | MMERCHANT | MLUONG | VUKSTINA | AGLADNEY | DMCCASTL | VUKSTINA | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | JINGRAM | YRODRIGU | AGLADNEY | YRODRIGU | SMCCONNAN | JINGRAM | AGLADNEY | GTAYLOR | AGLADNEY | VUKSTINA | AGLADNEY | MMERCHANT | GTAYLOR | CAFILER | AGLADNEY | VUKSTINA | CAFILER | GTAYLOR | RATTIYEH | MKIRKHAM | GTAYLOR | CHATRIDGE | CAFILER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11002 | 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 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1997-04-01 00:00:00 | 1995-01-01 00:00:00 | 1997-01-01 00:00:00 | 1999-01-01 00:00:00 | 1995-04-01 00:00:00 | 1997-10-01 00:00:00 | 1996-01-01 00:00:00 | 1999-04-01 00:00:00 | 1995-07-01 00:00:00 | 1998-01-01 00:00:00 | 1996-04-01 00:00:00 | 1997-07-01 00:00:00 | 1995-10-01 00:00:00 | 1998-04-01 00:00:00 | 1996-07-01 00:00:00 | 1996-10-01 00:00:00 | 1996-04-01 00:00:00 | 1996-01-01 00:00:00 | 1999-07-01 00:00:00 | 1998-10-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 | 2000-10-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-01-01 00:00:00 | 2001-07-01 00:00:00 | 2001-04-01 00:00:00 | 2001-04-01 00:00:00 | 2001-04-01 00:00:00 | 2001-10-01 00:00:00 | 2001-07-01 00:00:00 | 2001-10-01 00:00:00 | 2002-01-01 00:00:00 | 2002-01-01 00:00:00 | 2002-04-01 00:00:00 | 2002-04-01 00:00:00 | 2002-07-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 | 2002-10-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-01-01 00:00:00 | 2003-10-01 00:00:00 | 2004-04-01 00:00:00 | 2004-04-01 00:00:00 | 2004-01-01 00:00:00 | 2004-07-01 00:00:00 | 2004-10-01 00:00:00 | 2004-11-24 00:00:00 | 2004-07-01 00:00:00 | 1900-01-01 00:00:00 | 2004-10-01 00:00:00 | 2005-01-01 00:00:00 | 2005-04-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 | 2006-10-01 00:00:00 | 1900-01-01 00:00:00 | 2007-04-01 00:00:00 | 2007-01-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-01-01 00:00:00 | 2015-04-01 00:00:00 | 2014-04-01 00:00:00 | 2013-07-01 00:00:00 | 1900-01-01 00:00:00 | 2014-07-01 00:00:00 | 2008-04-01 00:00:00 | 2008-01-01 00:00:00 | 2008-10-01 00:00:00 | 2008-12-18 00:00:00 | 2009-01-01 00:00:00 | 2008-07-01 00:00:00 | 2009-04-01 00:00:00 | 1900-01-01 00:00:00 | 2009-07-01 00:00:00 | 2009-10-01 00:00:00 | 2010-01-01 00:00:00 | 2010-04-01 00:00:00 | 2010-07-01 00:00:00 | 2010-12-16 00:00:00 | 1900-01-01 00:00:00 | 2010-10-01 00:00:00 | 2011-04-01 00:00:00 | 2011-07-01 00:00:00 | 2011-01-01 00:00:00 | 2011-10-01 00:00:00 | 2012-01-01 00:00:00 | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 2014-10-01 00:00:00 | 2014-12-16 00:00:00 | 2012-07-01 00:00:00 | 2012-10-01 00:00:00 | 2012-12-11 00:00:00 | 1900-01-01 00:00:00 | 2014-01-01 00:00:00 | 2013-10-01 00:00:00 | 1900-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-07-01 00:00:00 | 2020-01-01 00:00:00 | 2018-01-01 00:00:00 | 2020-12-07 00:00:00 | 2021-01-01 00:00:00 | 2019-01-01 00:00:00 | 2018-04-01 00:00:00 | 1900-01-01 00:00:00 | 2020-04-01 00:00:00 | 2018-10-01 00:00:00 | 2015-10-01 00:00:00 | 2016-01-01 00:00:00 | 2016-04-01 00:00:00 | 2016-07-01 00:00:00 | 2016-12-28 00:00:00 | 2016-10-01 00:00:00 | 1900-01-01 00:00:00 | 2017-04-01 00:00:00 | 2017-01-01 00:00:00 | 2018-07-01 00:00:00 | 2020-07-01 00:00:00 | 2017-07-01 00:00:00 | 2019-04-01 00:00:00 | 2018-10-01 00:00:00 | 1900-01-01 00:00:00 | 2019-10-01 00:00:00 | 2018-12-03 00:00:00 | 2017-10-01 00:00:00 | 2019-07-01 00:00:00 | 2022-04-01 00:00:00 | 2021-04-01 00:00:00 | 2021-10-01 00:00:00 | 2022-01-01 00:00:00 | 2020-10-01 00:00:00 | 2021-07-01 00:00:00 | 2022-07-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1997-06-30 00:00:00 | 1995-03-31 00:00:00 | 1997-03-31 00:00:00 | 1999-03-31 00:00:00 | 1995-06-30 00:00:00 | 1997-12-31 00:00:00 | 1996-03-31 00:00:00 | 1999-06-30 00:00:00 | 1995-09-30 00:00:00 | 1998-03-31 00:00:00 | 1996-06-30 00:00:00 | 1997-09-30 00:00:00 | 1995-12-31 00:00:00 | 1998-06-30 00:00:00 | 1996-09-30 00:00:00 | 1996-12-31 00:00:00 | 1996-06-30 00:00:00 | 1996-03-31 00:00:00 | 1999-09-30 00:00:00 | 1998-12-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 | 2000-12-31 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-03-31 00:00:00 | 2001-09-30 00:00:00 | 2001-06-30 00:00:00 | 2001-06-30 00:00:00 | 2001-06-30 00:00:00 | 2001-12-31 00:00:00 | 2001-09-30 00:00:00 | 2001-12-31 00:00:00 | 2002-03-31 00:00:00 | 2002-03-31 00:00:00 | 2002-06-30 00:00:00 | 2002-06-30 00:00:00 | 2002-09-30 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 | 2002-12-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-03-31 00:00:00 | 2003-12-31 00:00:00 | 2004-06-30 00:00:00 | 2004-06-30 00:00:00 | 2004-03-31 00:00:00 | 2004-09-30 00:00:00 | 2004-12-31 00:00:00 | 2004-11-24 00:00:00 | 2004-09-30 00:00:00 | 1900-01-01 00:00:00 | 2004-12-31 00:00:00 | 2005-03-31 00:00:00 | 2005-06-30 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 | 2006-12-31 00:00:00 | 1900-01-01 00:00:00 | 2007-06-30 00:00:00 | 2007-03-31 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-03-31 00:00:00 | 2015-06-30 00:00:00 | 2014-06-30 00:00:00 | 2013-09-30 00:00:00 | 1900-01-01 00:00:00 | 2014-09-30 00:00:00 | 2008-06-30 00:00:00 | 2008-03-31 00:00:00 | 2008-12-31 00:00:00 | 2008-12-18 00:00:00 | 2009-03-31 00:00:00 | 2008-09-30 00:00:00 | 2009-06-30 00:00:00 | 1900-01-01 00:00:00 | 2009-09-30 00:00:00 | 2009-12-31 00:00:00 | 2010-03-31 00:00:00 | 2010-06-30 00:00:00 | 2010-09-30 00:00:00 | 2010-12-16 00:00:00 | 1900-01-01 00:00:00 | 2010-12-31 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 2011-03-31 00:00:00 | 2011-12-31 00:00:00 | 2012-03-31 00:00:00 | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 2014-12-31 00:00:00 | 2014-12-16 00:00:00 | 2012-09-30 00:00:00 | 2012-12-31 00:00:00 | 2012-12-11 00:00:00 | 1900-01-01 00:00:00 | 2014-03-31 00:00:00 | 2013-12-31 00:00:00 | 1900-01-01 00:00:00 | 2013-03-31 00:00:00 | 2015-09-30 00:00:00 | 2020-03-31 00:00:00 | 2018-03-31 00:00:00 | 2020-12-07 00:00:00 | 2021-03-31 00:00:00 | 2019-03-31 00:00:00 | 2018-06-30 00:00:00 | 1900-01-01 00:00:00 | 2020-06-30 00:00:00 | 2018-12-31 00:00:00 | 2015-12-31 00:00:00 | 2016-03-31 00:00:00 | 2016-06-30 00:00:00 | 2016-09-30 00:00:00 | 2016-12-28 00:00:00 | 2016-12-31 00:00:00 | 1900-01-01 00:00:00 | 2017-06-30 00:00:00 | 2017-03-31 00:00:00 | 2018-09-30 00:00:00 | 2020-09-30 00:00:00 | 2017-09-30 00:00:00 | 2019-06-30 00:00:00 | 2018-12-31 00:00:00 | 1900-01-01 00:00:00 | 2019-12-31 00:00:00 | 2018-12-03 00:00:00 | 2017-12-31 00:00:00 | 2019-09-30 00:00:00 | 2022-06-30 00:00:00 | 2021-06-30 00:00:00 | 2021-12-31 00:00:00 | 2022-03-31 00:00:00 | 2020-12-31 00:00:00 | 2021-09-30 00:00:00 | 2022-09-30 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_type | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 22001 | 22001 | None | 22001 | None | 22001 | None | 22001 | 22006 | None | None | 22006 | None | 22006 | 22006 | 22001 | None | None | None | 22006 | 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 | 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 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 |
filer_id | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 4 | 4 | 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 | Y | N | |||||||||||||||
race | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
session_id | 1997 | 1999 | 1995 | 2001 | 2003 | 2005 | 2007 | 2011 | 2013 | 2009 | 2015 | 2021 | 2019 | 2017 | 2023 | |||||||||||||||
category | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
category_type | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
sub_category | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
effect_dt | 1997-01-01 00:00:00 | 1999-01-01 00:00:00 | 1995-01-01 00:00:00 | 2001-01-01 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2011-01-01 00:00:00 | 2013-01-01 00:00:00 | 2009-01-01 00:00:00 | 2015-01-01 00:00:00 | 2021-01-01 00:00:00 | 2019-01-01 00:00:00 | 2017-01-01 00:00:00 | 2023-01-01 00:00:00 | |||||||||||||||
sub_category_type | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
election_type | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
sub_category_a | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
nyq_dt | None | None | None | None | None | 2000-01-01 00:00:00 | 2000-01-01 00:00:00 | None | None | None | None | None | None | None | None | |||||||||||||||
party_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
county_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
district_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1147792 | |
---|---|---|
xref_id | L00015 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | L00015 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ARNOLD | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namf | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | MICHAEL J. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
adr1 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
adr2 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
city | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
zip4 | 95814 | 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 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | 9164462646 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | None | None | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | None | None | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | None | None | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | None | None | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | None | None | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | None | None | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | None | None | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | None | None | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | None | None | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | None | None | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | None | None | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | None | None | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | None | None | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | 9164466095 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None |
filer_id | 1147792 |
---|
filer_id | 1147792 | |
---|---|---|
change_no | 1 | |
session_id | 2001 | |
log_dt | 2001-05-01 00:00:00 | |
filer_type | 4 | |
correction_flg | None | |
action | SET ACTIVE | |
attribute_changed | CLIENT | |
ethics_dt | None | |
interests | None | |
filer_full_name | MICHAEL J. ARNOLD | |
filer_city | SAN DIEGO | |
filer_st | CA | |
filer_zip | 92121 | |
filer_phone | 8584502887 | |
entity_type | 3 | |
entity_name | ARNOLD & ASSOCIATES | |
entity_city | None | |
entity_st | None | |
entity_zip | None | |
entity_phone | None | |
entity_id | 1147311 | |
responsible_officer | None | |
effect_dt | None |
filer_id | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | 1147792 | |||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 11917.cal | 13230.cal | 14100.cal | 14183.cal | 624278_0.cal | 643230_0.cal | 678514_0.cal | 714321_0.cal | 745425_0.cal | 771533_0.cal | 791661_0.cal | 813469_0.cal | 839192_0.cal | 852461_0.cal | 880739_0.cal | 908751_0.cal | 929114_0.cal | 947058_0.cal | 969387_0.cal | 1062641_0.cal | 448986.cal | 449078.cal | 448913.cal | 448955.cal | 1384418_0.cal | 1551172_0.cal | 1716816_0.cal | 2114366_0.cal | 1918483_0.cal | 2327126_0.cal | 2536251_0.cal | |||||||||||||||||||||||||||||||
received_date | 2000-05-01 00:00:00 | 2000-05-01 00:00:00 | 2000-05-01 00:00:00 | 2000-05-01 00:00:00 | 2000-05-01 00:00:00 | 2000-07-27 00:00:00 | 2000-10-27 00:00:00 | 2001-01-25 00:00:00 | 2001-04-30 00:00:00 | 2001-07-30 00:00:00 | 2001-10-31 00:00:00 | 2002-01-31 00:00:00 | 2002-04-30 00:00:00 | 2002-07-26 00:00:00 | 2002-10-27 00:00:00 | 2003-01-29 00:00:00 | 2003-04-26 00:00:00 | 2003-07-30 00:00:00 | 2003-10-30 00:00:00 | 2004-11-24 00:00:00 | 2004-12-21 00:00:00 | 2004-12-21 00:00:00 | 2004-12-21 00:00:00 | 2004-12-21 00:00:00 | 2008-12-18 00:00:00 | 2010-12-16 00:00:00 | 2012-12-11 00:00:00 | 2016-12-28 00:00:00 | 2014-12-16 00:00:00 | 2018-12-03 00:00:00 | 2020-12-07 00:00:00 | |||||||||||||||||||||||||||||||
filing_directory | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /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 | /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/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /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 | None | None | None | None | 624278 | 643230 | 678514 | 714321 | 745425 | 771533 | 791661 | 813469 | 839192 | 852461 | 880739 | 908751 | 929114 | 947058 | 969387 | 1062641 | None | None | None | None | 1384418 | 1551172 | 1716816 | 2114366 | 1918483 | 2327126 | 2536251 | |||||||||||||||||||||||||||||||
form_id | None | None | None | None | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | None | None | None | None | F604 | F604 | F604 | F604 | F604 | F604 | F604 | |||||||||||||||||||||||||||||||
receive_comment | Filing did not pass validation | Filing pass validation, but failed DB constraints | Filing pass validation, but failed DB constraints | Filing pass validation, but failed DB constraints | Filing accepted, but but with warnings | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted, but with warnings | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted, but with warnings | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted |