filer_id | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1106260 | 2045681 | 2082222 | 2115427 | 2160652 | 2204119 | 2411281 | 2469537 | 2553463 | 2277730 | 2510426 | 2341178 | ||||||||||||
effect_dt | 1999-01-23 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 | 2023-01-01 00:00:00 | 2013-01-01 00:00:00 | 2021-01-01 00:00:00 | 2015-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 | 2019 | 2023 | 2013 | 2021 | 2015 |
filer_id | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 1999 | 2001 | 2003 | 2005 | 2007 | 2009 | 2011 | 2013 | 2017 | 2015 | 2019 | 2021 | ||||||||||||
ethics_date | 1999-06-18 00:00:00 | 2001-01-25 00:00:00 | 2003-06-13 00:00:00 | 2004-11-17 00:00:00 | 2007-02-08 00:00:00 | 2009-01-16 00:00:00 | 2011-02-24 00:00:00 | 2013-01-24 00:00:00 | 2017-01-12 00:00:00 | 2015-06-16 00:00:00 | 2019-01-10 00:00:00 | 2021-01-28 00:00:00 |
filer_id | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 512386 | 518638 | 515509 | 624580 | 625975 | 606107 | 649510 | 682071 | 656368 | 707429 | 686067 | 717843 | 721165 | 746694 | 748905 | 726707 | 707429 | 768394 | 789361 | 777336 | 793670 | 816205 | 814988 | 842337 | 837149 | 860238 | 853923 | 905579 | 889427 | 884842 | 906267 | 918259 | 933519 | 932016 | 946789 | 953224 | 939091 | 965858 | 972566 | 989169 | 982701 | 1011631 | 1025830 | 1015580 | 1035213 | 1069670 | 1055563 | 1062995 | 1083573 | 1101020 | 1084395 | 1112258 | 1127825 | 1143478 | 1164379 | 1189729 | 1217306 | 1225184 | 1260552 | 1242824 | 1225184 | 1285583 | 1242824 | 1268533 | 1235902 | 1297813 | 1973206 | 1972006 | 1778554 | 1796167 | 1947016 | 1898283 | 1328011 | 1303896 | 1342207 | 1386127 | 1386234 | 1373913 | 1410668 | 1410668 | 1418497 | 1430147 | 1448171 | 1457166 | 1480438 | 1503786 | 1529568 | 1543189 | 1551123 | 1567637 | 1579227 | 1602354 | 1588881 | 1628594 | 1619598 | 1652120 | 1677932 | 1813287 | 1917205 | 1922472 | 1719656 | 1706023 | 1862295 | 1734004 | 1844196 | 1756610 | 1756643 | 1971597 | 2003631 | 1990479 | 2263461 | 2341281 | 2427661 | 2331703 | 2034001 | 2053280 | 2084414 | 2116218 | 2120308 | 2114280 | 2148982 | 2132506 | 2167755 | 2229140 | 2410831 | 2506320 | 2410831 | 2538780 | 2301630 | 2541867 | 2591025 | 2331693 | 2465300 | 2200416 | 2403338 | 2403337 | 2186065 | 2352926 | 2476556 | 2573221 | 2696297 | 2591917 | 2632523 | 2614803 | 2570553 | 2730368 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 157 | 159 | 158 | 161 | 161 | 160 | 162 | 163 | 162 | None | 163 | 164 | None | 165 | 165 | 164 | None | 166 | 167 | None | None | None | 168 | None | 169 | None | 170 | 172 | None | 171 | None | None | None | 173 | 174 | None | None | 175 | None | None | 176 | 177 | 178 | None | None | 180 | 179 | None | None | 181 | None | 182 | 183 | 184 | 185 | 186 | 187 | 188 | 189 | None | 190 | 190 | None | None | 188 | 191 | 222 | 221 | 214 | 215 | None | 219 | 193 | 192 | 194 | 196 | 196 | 195 | None | None | 197 | 198 | 199 | 200 | 201 | 202 | 203 | 204 | None | 204 | None | 206 | 205 | 208 | 207 | 209 | 210 | 216 | 220 | 220 | 212 | 211 | 218 | 212 | 217 | None | 213 | None | 53 | 223 | 234 | None | 240 | 237 | 225 | 226 | 227 | 228 | None | 228 | 229 | None | 230 | 233 | 243 | 239 | 239 | 244 | 235 | 244 | 246 | 236 | 241 | 232 | 238 | 237 | 231 | None | 242 | 245 | 250 | None | 248 | 247 | None | 250 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F604 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F615 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 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 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1999-04-29 00:00:00 | 1999-11-01 00:00:00 | 1999-08-02 00:00:00 | 2000-05-01 00:00:00 | 2000-05-01 00:00:00 | 2000-01-31 00:00:00 | 2000-08-07 00:00:00 | 2000-10-31 00:00:00 | 2000-07-31 00:00:00 | 2001-01-04 00:00:00 | 2000-10-31 00:00:00 | 2001-01-30 00:00:00 | 2001-01-31 00:00:00 | 2001-04-30 00:00:00 | 2001-04-30 00:00:00 | 2001-01-31 00:00:00 | 2001-01-25 00:00:00 | 2001-07-19 00:00:00 | 2001-10-25 00:00:00 | 2001-07-23 00:00:00 | 2001-10-29 00:00:00 | 2002-01-30 00:00:00 | 2002-02-01 00:00:00 | 2002-04-30 00:00:00 | 2002-04-24 00:00:00 | 2002-07-30 00:00:00 | 2002-07-30 00:00:00 | 2003-01-23 00:00:00 | 2002-10-31 00:00:00 | 2002-10-31 00:00:00 | 2003-01-07 00:00:00 | 2003-01-28 00:00:00 | 2003-04-30 00:00:00 | 2003-04-30 00:00:00 | 2003-07-30 00:00:00 | 2003-07-31 00:00:00 | 2003-06-13 00:00:00 | 2003-10-21 00:00:00 | 2003-10-23 00:00:00 | 2004-01-20 00:00:00 | 2004-01-15 00:00:00 | 2004-04-27 00:00:00 | 2004-07-26 00:00:00 | 2004-04-30 00:00:00 | 2004-08-02 00:00:00 | 2005-01-03 00:00:00 | 2004-10-27 00:00:00 | 2004-10-29 00:00:00 | 2005-01-12 00:00:00 | 2005-04-19 00:00:00 | 2004-12-30 00:00:00 | 2005-07-16 00:00:00 | 2005-10-12 00:00:00 | 2006-01-24 00:00:00 | 2006-04-25 00:00:00 | 2006-07-29 00:00:00 | 2006-10-31 00:00:00 | 2006-12-29 00:00:00 | 2007-04-27 00:00:00 | 2006-12-29 00:00:00 | 2007-05-21 00:00:00 | 2007-07-31 00:00:00 | 2007-06-21 00:00:00 | 2007-05-23 00:00:00 | 2007-01-30 00:00:00 | 2007-10-31 00:00:00 | 2015-07-07 00:00:00 | 2015-06-24 00:00:00 | 2013-07-26 00:00:00 | 2013-10-22 00:00:00 | 2014-12-29 00:00:00 | 2014-10-15 00:00:00 | 2008-04-29 00:00:00 | 2008-01-16 00:00:00 | 2008-07-08 00:00:00 | 2008-12-29 00:00:00 | 2008-12-29 00:00:00 | 2008-10-28 00:00:00 | 2008-12-31 00:00:00 | 2009-01-16 00:00:00 | 2009-04-23 00:00:00 | 2009-07-11 00:00:00 | 2009-10-18 00:00:00 | 2010-01-10 00:00:00 | 2010-04-17 00:00:00 | 2010-07-27 00:00:00 | 2010-10-19 00:00:00 | 2010-11-06 00:00:00 | 2010-12-07 00:00:00 | 2011-01-27 00:00:00 | 2011-02-24 00:00:00 | 2011-07-22 00:00:00 | 2011-04-27 00:00:00 | 2012-01-15 00:00:00 | 2011-10-25 00:00:00 | 2012-04-15 00:00:00 | 2012-07-30 00:00:00 | 2014-01-26 00:00:00 | 2014-12-06 00:00:00 | 2015-01-01 00:00:00 | 2012-12-24 00:00:00 | 2012-10-28 00:00:00 | 2014-07-11 00:00:00 | 2013-01-28 00:00:00 | 2014-04-29 00:00:00 | 2013-01-31 00:00:00 | 2013-04-15 00:00:00 | 2015-06-16 00:00:00 | 2016-01-13 00:00:00 | 2015-10-05 00:00:00 | 2018-07-10 00:00:00 | 2019-01-07 00:00:00 | 2020-01-01 00:00:00 | 2019-01-02 00:00:00 | 2016-04-28 00:00:00 | 2016-07-03 00:00:00 | 2016-10-03 00:00:00 | 2017-01-01 00:00:00 | 2017-01-12 00:00:00 | 2016-12-28 00:00:00 | 2017-04-02 00:00:00 | 2016-12-29 00:00:00 | 2017-07-16 00:00:00 | 2018-04-07 00:00:00 | 2020-12-01 00:00:00 | 2020-09-26 00:00:00 | 2019-09-30 00:00:00 | 2020-12-29 00:00:00 | 2018-10-04 00:00:00 | 2021-01-01 00:00:00 | 2021-07-06 00:00:00 | 2019-01-02 00:00:00 | 2020-04-09 00:00:00 | 2018-01-06 00:00:00 | 2019-08-06 00:00:00 | 2019-08-06 00:00:00 | 2017-10-02 00:00:00 | 2019-01-22 00:00:00 | 2020-07-03 00:00:00 | 2021-04-09 00:00:00 | 2022-07-03 00:00:00 | 2021-04-13 00:00:00 | 2022-01-02 00:00:00 | 2021-10-08 00:00:00 | 2020-12-31 00:00:00 | 2022-10-08 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10006 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10002 | 10001 | 10006 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10006 | 10001 | 10001 | 10005 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10005 | 10001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 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 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 2001 | 1999 | 1999 | 2001 | 2001 | 2001 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2005 | 2007 | 2015 | 2015 | 2013 | 2013 | 2015 | 2013 | 2007 | 2007 | 2007 | 2007 | 2009 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2011 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2015 | 2013 | 2013 | 2011 | 2013 | 2011 | 2013 | 2013 | 2013 | 2015 | 2015 | 2015 | 2017 | 2019 | 2019 | 2019 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2019 | 2021 | 2017 | 2019 | 2021 | 2017 | 2019 | 2017 | 2019 | 2019 | 2017 | 2019 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | GGILMORE | * | * | MKIENG | TTHAM | NJACKSON | MKIENG | * | NJACKSON | * | GPEREZ | MKIENG | BSMITH | * | * | GPEREZ | YBONILLA | YBONILLA | * | YBONILLA | * | YBONILLA | * | COMPLETED | YBONILLA | * | GPEREZ | YBONILLA | YBONILLA | COMPLETED | COMPLETED | YBONILLA | BSMITH | COMPLETED | YBONILLA | EMCENTEE | COMPLETED | COMPLETED | COMPLETED | LTHIBAUL | LTHIBAUL | COMPLETED | COMPLETED | YRODRIGU | YRODRIGU | YRODRIGU | CFLAGG | YRODRIGU | YRODRIGU | LTHIBAUL | YRODRIGU | YRODRIGU | YRODRIGU | * | YRODRIGU | CFLAGG | * | LTHIBAUL | CFLAGG | PBANFORD | YRODRIGU | LTHIBAUL | AGLADNEY | RGEREMIA | ASAETERN | ASAETERN | AGLADNEY | AGLADNEY | LTHIBAUL | LTHIBAUL | LTHIBAUL | JINGRAM | YRODRIGU | MGUERRA | SARRIAGA | SARRIAGA | YRODRIGU | YRODRIGU | YRODRIGU | YRODRIGU | MGUERRA | ASAETERN | ASAETERN | YRODRIGU | YRODRIGU | ASAETERN | SMCCONNAN | ASAETERN | JINGRAM | ASAETERN | ASAETERN | ASAETERN | AGLADNEY | ASAETERN | YRODRIGU | AGLADNEY | PBANFORD | ASAETERN | ASAETERN | ASAETERN | ASAETERN | PBANFORD | ASAETERN | PBANFORD | AGLADNEY | AGLADNEY | AGLADNEY | YRODRIGU | VUKSTINA | YRODRIGU | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | PBANFORD | YRODRIGU | AGLADNEY | YRODRIGU | SMCCONNAN | AGLADNEY | GTAYLOR | MKIRKHAM | GTAYLOR | CVANLIEW | JFRONEFIELD | GTAYLOR | CHATRIDGE | JFRONEFIELD | SUSHAKOV | AGLADNEY | KBANH | KBANH | SMCCONNAN | VUKSTINA | VUKSTINA | JMAVES | CAFILER | AROJAS | MKIRKHAM | CHATRIDGE | CVANLIEW | CAFILER | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11002 | 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 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 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 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1999-01-01 00:00:00 | 1999-07-01 00:00:00 | 1999-04-01 00:00:00 | 2000-01-01 00:00:00 | 2000-01-01 00:00:00 | 1999-10-01 00:00:00 | 2000-04-01 00:00:00 | 2000-07-01 00:00:00 | 2000-04-01 00:00:00 | 1900-01-01 00:00:00 | 2000-07-01 00:00:00 | 2000-10-01 00:00:00 | 1900-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2000-10-01 00:00:00 | 1900-01-01 00:00:00 | 2001-04-01 00:00:00 | 2001-07-01 00:00:00 | 2001-04-01 00:00:00 | 2001-07-01 00:00:00 | 2001-10-01 00:00:00 | 2001-10-01 00:00:00 | 2002-01-01 00:00:00 | 2002-01-01 00:00:00 | 2002-04-01 00:00:00 | 2002-04-01 00:00:00 | 2002-10-01 00:00:00 | 2002-07-01 00:00:00 | 2002-07-01 00:00:00 | 1900-01-01 00:00:00 | 2002-10-01 00:00:00 | 2003-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-04-01 00:00:00 | 2003-04-01 00:00:00 | None | 2003-07-01 00:00:00 | 2003-07-01 00:00:00 | 2003-10-01 00:00:00 | 2003-10-01 00:00:00 | 2004-01-01 00:00:00 | 2004-04-01 00:00:00 | 2004-01-01 00:00:00 | 2004-04-01 00:00:00 | 2004-10-01 00:00:00 | 2004-07-01 00:00:00 | 2004-07-01 00:00:00 | 2004-10-01 00:00:00 | 2005-01-01 00:00:00 | 1900-01-01 00:00:00 | 2005-04-01 00:00:00 | 2005-07-01 00:00:00 | 2005-10-01 00:00:00 | 2006-01-01 00:00:00 | 2006-04-01 00:00:00 | 2006-07-01 00:00:00 | 2006-12-29 00:00:00 | 2007-01-01 00:00:00 | 1900-01-01 00:00:00 | 2007-05-21 00:00:00 | 2007-04-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2006-10-01 00:00:00 | 2007-07-01 00:00:00 | 2015-04-01 00:00:00 | 2015-01-01 00:00:00 | 2013-04-01 00:00:00 | 2013-07-01 00:00:00 | 1900-01-01 00:00:00 | 2014-07-01 00:00:00 | 2008-01-01 00:00:00 | 2007-10-01 00:00:00 | 2008-04-01 00:00:00 | 2008-10-01 00:00:00 | 2008-12-29 00:00:00 | 2008-07-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-04-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-11-06 00:00:00 | 1900-01-01 00:00:00 | 2010-10-01 00:00:00 | 1900-01-01 00:00:00 | 2011-04-01 00:00:00 | 2011-01-01 00:00:00 | 2011-10-01 00:00:00 | 2011-07-01 00:00:00 | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 2013-10-01 00:00:00 | 2014-12-06 00:00:00 | 2014-10-01 00:00:00 | 2012-12-24 00:00:00 | 2012-07-01 00:00:00 | 2014-04-01 00:00:00 | 2012-10-01 00:00:00 | 2014-01-01 00:00:00 | 1900-01-01 00:00:00 | 2013-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-10-01 00:00:00 | 2015-07-01 00:00:00 | 2018-04-01 00:00:00 | 1900-01-01 00:00:00 | 2019-10-01 00:00:00 | 2019-01-02 00:00:00 | 2016-01-01 00:00:00 | 2016-04-01 00:00:00 | 2016-07-01 00:00:00 | 2016-10-01 00:00:00 | None | 2016-12-28 00:00:00 | 2017-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-04-01 00:00:00 | 2018-01-01 00:00:00 | 2020-07-01 00:00:00 | 2020-07-01 00:00:00 | 2019-07-01 00:00:00 | 2020-12-29 00:00:00 | 2018-07-01 00:00:00 | 2020-10-01 00:00:00 | 2021-04-01 00:00:00 | 2018-10-01 00:00:00 | 2020-01-01 00:00:00 | 2017-10-01 00:00:00 | 2019-04-01 00:00:00 | 2019-01-01 00:00:00 | 2017-07-01 00:00:00 | 1900-01-01 00:00:00 | 2020-04-01 00:00:00 | 2021-01-01 00:00:00 | 2022-04-01 00:00:00 | 1900-01-01 00:00:00 | 2021-10-01 00:00:00 | 2021-07-01 00:00:00 | 1900-01-01 00:00:00 | 2022-06-30 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1999-03-31 00:00:00 | 1999-09-30 00:00:00 | 1999-06-30 00:00:00 | 2000-03-31 00:00:00 | 2000-03-31 00:00:00 | 1999-12-31 00:00:00 | 2000-06-30 00:00:00 | 2000-09-30 00:00:00 | 2000-06-30 00:00:00 | 1900-01-01 00:00:00 | 2000-09-30 00:00:00 | 2000-12-31 00:00:00 | 1900-01-01 00:00:00 | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 | 2000-12-31 00:00:00 | 1900-01-01 00:00:00 | 2001-06-30 00:00:00 | 2001-09-30 00:00:00 | 2001-06-30 00:00:00 | 2001-09-30 00:00:00 | 2001-12-31 00:00:00 | 2001-12-31 00:00:00 | 2002-03-31 00:00:00 | 2002-03-31 00:00:00 | 2002-06-30 00:00:00 | 2002-06-30 00:00:00 | 2002-12-31 00:00:00 | 2002-09-30 00:00:00 | 2002-09-30 00:00:00 | 1900-01-01 00:00:00 | 2002-12-31 00:00:00 | 2003-03-31 00:00:00 | 2003-03-31 00:00:00 | 2003-06-30 00:00:00 | 2003-06-30 00:00:00 | None | 2003-09-30 00:00:00 | 2003-09-30 00:00:00 | 2003-12-31 00:00:00 | 2003-12-31 00:00:00 | 2004-03-31 00:00:00 | 2004-06-30 00:00:00 | 2004-03-31 00:00:00 | 2004-06-30 00:00:00 | 2004-12-31 00:00:00 | 2004-09-30 00:00:00 | 2004-09-30 00:00:00 | 2004-12-31 00:00:00 | 2005-03-31 00:00:00 | 1900-01-01 00:00:00 | 2005-06-30 00:00:00 | 2005-09-30 00:00:00 | 2005-12-31 00:00:00 | 2006-03-31 00:00:00 | 2006-06-30 00:00:00 | 2006-09-30 00:00:00 | 2006-12-29 00:00:00 | 2007-03-31 00:00:00 | 1900-01-01 00:00:00 | 2007-05-21 00:00:00 | 2007-06-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2006-12-31 00:00:00 | 2007-09-30 00:00:00 | 2015-06-30 00:00:00 | 2015-03-31 00:00:00 | 2013-06-30 00:00:00 | 2013-09-30 00:00:00 | 1900-01-01 00:00:00 | 2014-09-30 00:00:00 | 2008-03-31 00:00:00 | 2007-12-31 00:00:00 | 2008-06-30 00:00:00 | 2008-12-31 00:00:00 | 2008-12-29 00:00:00 | 2008-09-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2009-03-31 00:00:00 | 2009-06-30 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-11-06 00:00:00 | 1900-01-01 00:00:00 | 2010-12-31 00:00:00 | 1900-01-01 00:00:00 | 2011-06-30 00:00:00 | 2011-03-31 00:00:00 | 2011-12-31 00:00:00 | 2011-09-30 00:00:00 | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 2013-12-31 00:00:00 | 2014-12-06 00:00:00 | 2014-12-31 00:00:00 | 2012-12-24 00:00:00 | 2012-09-30 00:00:00 | 2014-06-30 00:00:00 | 2012-12-31 00:00:00 | 2014-03-31 00:00:00 | 1900-01-01 00:00:00 | 2013-03-31 00:00:00 | 1900-01-01 00:00:00 | 1015-12-31 00:00:00 | 2015-09-30 00:00:00 | 2018-06-30 00:00:00 | 1900-01-01 00:00:00 | 2019-12-31 00:00:00 | 2019-01-02 00:00:00 | 2016-03-31 00:00:00 | 2016-06-30 00:00:00 | 2016-09-30 00:00:00 | 2016-12-31 00:00:00 | None | 2016-12-28 00:00:00 | 2017-03-31 00:00:00 | 1900-01-01 00:00:00 | 2017-06-30 00:00:00 | 2018-03-31 00:00:00 | 2020-09-30 00:00:00 | 2019-09-30 00:00:00 | 2019-09-30 00:00:00 | 2020-12-29 00:00:00 | 2018-09-30 00:00:00 | 2020-12-31 00:00:00 | 2021-06-30 00:00:00 | 2018-12-31 00:00:00 | 2020-03-31 00:00:00 | 2017-12-31 00:00:00 | 2019-06-30 00:00:00 | 2019-03-31 00:00:00 | 2017-09-30 00:00:00 | 1900-01-01 00:00:00 | 2020-06-30 00:00:00 | 2021-03-31 00:00:00 | 2022-06-30 00:00:00 | 1900-01-01 00:00:00 | 2021-12-31 00:00:00 | 2021-09-30 00:00:00 | 1900-01-01 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 22001 | None | None | None | None | None | 22001 | 22001 | None | None | 22001 | None | None | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | None | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22006 | 22001 | None | 22006 | 22001 | None | None | 22001 | 22001 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | None | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | None | 22006 | 22006 | None | 22006 |
filer_id | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |||||||||||||
active | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | N | |||||||||||||
race | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
session_id | 2001 | 1999 | 2003 | 2005 | 2011 | 2007 | 2009 | 2013 | 2015 | 2021 | 2019 | 2017 | 2023 | |||||||||||||
category | 0 | 0 | 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 | |||||||||||||
sub_category | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
effect_dt | 2001-01-01 00:00:00 | 1999-01-23 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2011-01-01 00:00:00 | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2013-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 | |||||||||||||
election_type | 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 | |||||||||||||
nyq_dt | None | None | None | 2000-01-01 00:00:00 | None | 2000-01-01 00:00:00 | None | None | None | None | None | None | None | |||||||||||||
party_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
county_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
district_cd | None | None | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1149547 | |
---|---|---|
xref_id | L25769 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | L25769 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
naml | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | MEHTA | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namf | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | RAVI | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 9164493917 | 9164493917 | 9164493917 | 9164852509 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164493917 | 9164493917 | 9164493917 | 9164852509 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164493917 | 9164493917 | 9164493917 | 9164852509 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164493917 | 9164493917 | 9164493917 | 9164852509 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164493917 | 9164493917 | 9164493917 | 9164852509 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164493917 | 9164493917 | 9164493917 | 9164852509 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164493917 | 9164493917 | 9164493917 | 9164852509 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164493917 | 9164493917 | 9164493917 | 9164852509 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164493917 | 9164493917 | 9164493917 | 9164852509 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164493917 | 9164493917 | 9164493917 | 9164852509 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164493917 | 9164493917 | 9164493917 | 9164852509 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164493917 | 9164493917 | 9164493917 | 9164852509 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | 9164861955 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | 9164498249 | 9164498249 | 9164498249 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164498249 | 9164498249 | 9164498249 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164498249 | 9164498249 | 9164498249 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164498249 | 9164498249 | 9164498249 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164498249 | 9164498249 | 9164498249 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164498249 | 9164498249 | 9164498249 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164498249 | 9164498249 | 9164498249 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164498249 | 9164498249 | 9164498249 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164498249 | 9164498249 | 9164498249 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164498249 | 9164498249 | 9164498249 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164498249 | 9164498249 | 9164498249 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164498249 | 9164498249 | 9164498249 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | 9164852509 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | None | [email protected] | RMEHTA@CAPITOL-ADVOCATE | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | [email protected] | RMEHTA@CAPITOL-ADVOCATE | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | [email protected] | RMEHTA@CAPITOL-ADVOCATE | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | [email protected] | RMEHTA@CAPITOL-ADVOCATE | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | [email protected] | RMEHTA@CAPITOL-ADVOCATE | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | [email protected] | RMEHTA@CAPITOL-ADVOCATE | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | [email protected] | RMEHTA@CAPITOL-ADVOCATE | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | [email protected] | RMEHTA@CAPITOL-ADVOCATE | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | [email protected] | RMEHTA@CAPITOL-ADVOCATE | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | [email protected] | RMEHTA@CAPITOL-ADVOCATE | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | [email protected] | RMEHTA@CAPITOL-ADVOCATE | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | [email protected] | RMEHTA@CAPITOL-ADVOCATE | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] |
filer_id | 1149547 |
---|
filer_id | 1149547 | 1149547 | 1149547 | |||
---|---|---|---|---|---|---|
change_no | 1 | 2 | 3 | |||
session_id | 2001 | 2001 | 2013 | |||
log_dt | 2001-06-04 00:00:00 | 2001-01-04 00:00:00 | 2013-01-31 00:00:00 | |||
filer_type | 4 | 4 | 4 | |||
correction_flg | None | Y | Y | |||
action | DELETED | ADDED | ADDED | |||
attribute_changed | FIRM | FIRM | FIRM | |||
ethics_dt | None | None | None | |||
interests | None | None | None | |||
filer_full_name | RAVI MEHTA | MEHTA, RAVI | MEHTA, RAVI | |||
filer_city | None | SACRAMENTO | None | |||
filer_st | None | CA | None | |||
filer_zip | None | 95814 | None | |||
filer_phone | None | 9164493917 | None | |||
entity_type | 3 | 3 | 3 | |||
entity_name | ARTER & HADDEN | ARTER & HADDEN | CAPITOL ADVOCATES | |||
entity_city | None | None | None | |||
entity_st | None | None | None | |||
entity_zip | None | None | None | |||
entity_phone | None | None | None | |||
entity_id | 1147744 | None | 0 | |||
responsible_officer | None | None | None | |||
effect_dt | None | 2001-01-01 00:00:00 | 2013-01-01 00:00:00 |
filer_id | 1149547 | 1149547 | ||
---|---|---|---|---|
filing_period_start_dt | 2000-01-01 00:00:00 | 2000-01-01 00:00:00 | ||
filing_period_end_dt | 2000-03-31 00:00:00 | 2000-03-31 00:00:00 | ||
contribution_dt | None | None | ||
recipient_name | HERTZBERG FRIENDS OF BOB | GOLDBERG FOR ASSEMBLY JACKIE | ||
recipient_id | 1069827 | 1076202 | ||
amount | 250 | 500 |
filer_id | 1149547 | 1149547 | ||
---|---|---|---|---|
filing_period_start_dt | 2000-01-01 00:00:00 | 2000-01-01 00:00:00 | ||
filing_period_end_dt | 2000-03-31 00:00:00 | 2000-03-31 00:00:00 | ||
contribution_dt | None | None | ||
recipient_name | HERTZBERG FRIENDS OF BOB | GOLDBERG FOR ASSEMBLY JACKIE | ||
recipient_id | 1069827 | 1076202 | ||
amount | 250 | 500 |
filer_id | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | 1149547 | |||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 649510_0.cal | 624580_0.cal | 682071_0.cal | 717843_0.cal | 746694_0.cal | 768394_0.cal | 789361_0.cal | 69380.cal | 69385.cal | 814988_0.cal | 837149_0.cal | 853923_0.cal | 884842_0.cal | 905579_0.cal | 932016_0.cal | 358397.cal | 946789_0.cal | 965858_0.cal | 982701_0.cal | 1101020_0.cal | 1127825_0.cal | 1112258_0.cal | 1143478_0.cal | 1164379_0.cal | 1189729_0.cal | 1328011_0.cal | 1342207_0.cal | 1235902_0.cal | 21963.cal | 1217306_0.cal | 1225184_0.cal | 1225184_1.cal | 1260552_0.cal | 1297813_0.cal | 1303896_0.cal | 1285583_0.cal | 62766.cal | 1386127_0.cal | 1386234_0.cal | 1373913_0.cal | 1543189_0.cal | 1719656_0.cal | 2114280_0.cal | 1917205_0.cal | 2331703_0.cal | 195207.cal | 194989.cal | 2538780_0.cal | 195039.cal | |||||||||||||||||||||||||||||||||||||||||||||||||
received_date | 2000-08-07 00:00:00 | 2000-05-01 00:00:00 | 2000-10-31 00:00:00 | 2001-01-30 00:00:00 | 2001-04-30 00:00:00 | 2001-07-19 00:00:00 | 2001-10-25 00:00:00 | 2001-10-31 00:00:00 | 2001-10-31 00:00:00 | 2002-02-01 00:00:00 | 2002-04-24 00:00:00 | 2002-07-30 00:00:00 | 2002-10-31 00:00:00 | 2003-01-23 00:00:00 | 2003-04-30 00:00:00 | 2003-04-30 00:00:00 | 2003-07-30 00:00:00 | 2003-10-21 00:00:00 | 2004-01-15 00:00:00 | 2005-04-19 00:00:00 | 2005-10-12 00:00:00 | 2005-07-16 00:00:00 | 2006-01-24 00:00:00 | 2006-04-25 00:00:00 | 2006-07-29 00:00:00 | 2008-04-29 00:00:00 | 2008-07-08 00:00:00 | 2007-01-30 00:00:00 | 2007-01-30 00:00:00 | 2006-10-31 00:00:00 | 2006-12-29 00:00:00 | 2007-05-21 00:00:00 | 2007-04-27 00:00:00 | 2007-10-31 00:00:00 | 2008-01-16 00:00:00 | 2007-07-31 00:00:00 | 2007-10-09 00:00:00 | 2008-12-29 00:00:00 | 2008-12-29 00:00:00 | 2008-10-28 00:00:00 | 2010-11-06 00:00:00 | 2012-12-24 00:00:00 | 2016-12-28 00:00:00 | 2014-12-06 00:00:00 | 2019-01-02 00:00:00 | 2021-04-09 00:00:00 | 2021-04-09 00:00:00 | 2020-12-29 00:00:00 | 2021-04-09 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||
filing_directory | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /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/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 | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/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/cal | /cafiler/disclose/ca99/temp | |||||||||||||||||||||||||||||||||||||||||||||||||
filing_id | 649510 | 624580 | 682071 | 717843 | 746694 | 768394 | 789361 | None | None | 814988 | 837149 | 853923 | 884842 | 905579 | 932016 | None | 946789 | 965858 | 982701 | 1101020 | 1127825 | 1112258 | 1143478 | 1164379 | 1189729 | 1328011 | 1342207 | 1235902 | None | 1217306 | 1225184 | 1225184 | 1260552 | 1297813 | 1303896 | 1285583 | None | 1386127 | 1386234 | 1373913 | 1543189 | 1719656 | 2114280 | 1917205 | 2331703 | None | None | 2538780 | None | |||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F615 | F615 | F615 | F615 | F615 | F615 | F615 | None | None | F615 | F615 | F615 | F615 | F615 | F615 | None | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | None | F615 | F604 | F604 | F615 | F615 | F615 | F615 | None | F615 | F604 | F615 | F604 | F604 | F604 | F604 | F604 | None | None | F604 | None | |||||||||||||||||||||||||||||||||||||||||||||||||
receive_comment | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | 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 passed validation, but failed DB constraints | 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 | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing passed validation, but failed DB constraints |