filer_id | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1102162 | 2042452 | 2081803 | 2113871 | 2130073 | 2160877 | 2204311 | 2504930 | 2411688 | 2470354 | 2278739 | 2450204 | 2341969 | 2548334 | ||||||||||||||
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 | 2007-10-26 00:00:00 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2021-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2013-01-01 00:00:00 | 2018-03-23 00:00:00 | 2015-01-01 00:00:00 | 2023-01-01 00:00:00 | ||||||||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | ||||||||||||||
session_id | 1999 | 2003 | 2005 | 2007 | 2007 | 2009 | 2011 | 2021 | 2017 | 2019 | 2013 | 2017 | 2015 | 2023 |
filer_id | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 1997 | 1999 | 2001 | 1995 | 2005 | 2003 | 2007 | 2009 | 2011 | 2013 | 2015 | 2017 | 2021 | 2019 | ||||||||||||||
ethics_date | 1998-11-19 00:00:00 | 1998-11-19 00:00:00 | 2000-11-14 00:00:00 | 1994-03-09 00:00:00 | 2005-01-12 00:00:00 | 2003-04-24 00:00:00 | 2007-02-08 00:00:00 | 2009-02-19 00:00:00 | 2011-04-21 00:00:00 | 2013-05-16 00:00:00 | 2015-01-22 00:00:00 | 2017-04-20 00:00:00 | 2020-12-11 00:00:00 | 2019-05-23 00:00:00 |
filer_id | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 520245 | 510909 | 519338 | 524418 | 513048 | 514003 | 516204 | 521121 | 522326 | 542120 | 526532 | 527385 | 523208 | 528548 | 529364 | 514918 | 525308 | 517143 | 518037 | 626482 | 611278 | 638558 | 659341 | 646232 | 684095 | 719328 | 711726 | 683008 | 746548 | 749952 | 727066 | 791680 | 770816 | 793310 | 776431 | 816285 | 813558 | 837413 | 858132 | 842259 | 856015 | 879364 | 899384 | 883470 | 909473 | 929977 | 931566 | 929324 | 911766 | 945235 | 966830 | 951230 | 972216 | 988182 | 1011726 | 985781 | 1032967 | 1013192 | 1029295 | 1063235 | 1059005 | 1069779 | 1083574 | 1105244 | 1093776 | 1084384 | 1078125 | 1069779 | 1119107 | 1132669 | 1166466 | 1148855 | 1189301 | 1225247 | 1215727 | 1240569 | 1260054 | 1225247 | 1240569 | 1236393 | 1282998 | 1294322 | 1768661 | 1782390 | 1922063 | 1965469 | 1979118 | 1872446 | 1800314 | 1935108 | 1949085 | 1911516 | 1311768 | 1329139 | 1350783 | 1377293 | 1392918 | 1386451 | 1415511 | 1421408 | 1436572 | 1414397 | 1464210 | 1451285 | 1484444 | 1507807 | 1560593 | 1571111 | 1554251 | 1538330 | 1593393 | 1607821 | 1590644 | 1637148 | 1620461 | 1657260 | 1678939 | 1817124 | 1931365 | 1922063 | 1720606 | 1742957 | 1707976 | 1734146 | 1845826 | 1765137 | 1996612 | 2211677 | 2386059 | 2443158 | 2354518 | 2350005 | 2397218 | 2243075 | 2320193 | 2009382 | 2037816 | 2059471 | 2102140 | 2127848 | 2113698 | 2139850 | 2154947 | 2113698 | 2175846 | 2157201 | 2157280 | 2487639 | 2530867 | 2419323 | 2578400 | 2191727 | 2381704 | 2276624 | 2621663 | 2641078 | 2469837 | 2600411 | 2552356 | 2671746 | 2580435 | 2703954 | 2739556 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 144 | 141 | 159 | 146 | 157 | 142 | 158 | 152 | 145 | 149 | 147 | 155 | 153 | 148 | 156 | 150 | 154 | 143 | 151 | 161 | 160 | 161 | None | 162 | 163 | 164 | None | 163 | 165 | 165 | 164 | 167 | 166 | None | None | None | 168 | 169 | None | None | 170 | 171 | None | None | 172 | None | None | 173 | None | 174 | 175 | None | None | None | 177 | 176 | None | None | 178 | None | 179 | 180 | None | 181 | None | None | 180 | 181 | 182 | 183 | 185 | 184 | 186 | 188 | 187 | None | 189 | 189 | None | 188 | 190 | 191 | None | 214 | 221 | 221 | 222 | 218 | 215 | 220 | None | 219 | 192 | 193 | 194 | 195 | 196 | 196 | None | 197 | 198 | None | 200 | 199 | 201 | 202 | None | 204 | 204 | 203 | None | 206 | 205 | 208 | 207 | 209 | 210 | 216 | None | 220 | 212 | None | 211 | 212 | 217 | 213 | 223 | 232 | None | 240 | None | 236 | 238 | 233 | 235 | 224 | 225 | 226 | 227 | 228 | 228 | None | 229 | 230 | 230 | None | None | 242 | 243 | 239 | None | 231 | 237 | 234 | 247 | 248 | 241 | 246 | 244 | 249 | 245 | 250 | 251 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F604 | F604 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F604 | F615 | F604 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 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 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1996-01-31 00:00:00 | 1995-05-01 00:00:00 | 1999-11-01 00:00:00 | 1996-07-31 00:00:00 | 1999-04-30 00:00:00 | 1995-07-31 00:00:00 | 1999-08-02 00:00:00 | 1998-01-30 00:00:00 | 1996-04-30 00:00:00 | 1997-04-30 00:00:00 | 1996-10-31 00:00:00 | 1998-11-02 00:00:00 | 1998-04-30 00:00:00 | 1997-01-31 00:00:00 | 1999-02-01 00:00:00 | 1997-07-31 00:00:00 | 1998-07-31 00:00:00 | 1995-10-31 00:00:00 | 1997-10-31 00:00:00 | 2000-05-01 00:00:00 | 2000-01-31 00:00:00 | 2000-07-10 00:00:00 | 2000-08-02 00:00:00 | 2000-08-01 00:00:00 | 2000-11-01 00:00:00 | 2001-01-31 00:00:00 | 2000-12-29 00:00:00 | 2000-10-31 00:00:00 | 2001-04-30 00:00:00 | 2001-04-30 00:00:00 | 2001-01-31 00:00:00 | 2001-10-31 00:00:00 | 2001-07-27 00:00:00 | 2001-10-31 00:00:00 | 2001-07-31 00:00:00 | 2002-01-31 00:00:00 | 2002-01-31 00:00:00 | 2002-04-25 00:00:00 | 2002-07-31 00:00:00 | 2002-04-29 00:00:00 | 2002-07-31 00:00:00 | 2002-10-25 00:00:00 | 2002-12-26 00:00:00 | 2002-10-28 00:00:00 | 2003-01-30 00:00:00 | 2003-04-28 00:00:00 | 2003-04-24 00:00:00 | 2003-04-28 00:00:00 | 2003-01-30 00:00:00 | 2003-07-28 00:00:00 | 2003-10-24 00:00:00 | 2003-07-29 00:00:00 | 2003-10-24 00:00:00 | 2004-01-26 00:00:00 | 2004-04-27 00:00:00 | 2004-01-23 00:00:00 | 2004-07-30 00:00:00 | 2004-04-28 00:00:00 | 2004-07-30 00:00:00 | 2004-11-01 00:00:00 | 2004-11-01 00:00:00 | 2005-01-04 00:00:00 | 2005-01-04 00:00:00 | 2005-05-02 00:00:00 | 2005-01-27 00:00:00 | 2005-01-28 00:00:00 | 2005-01-28 00:00:00 | 2005-02-16 00:00:00 | 2005-08-01 00:00:00 | 2005-10-28 00:00:00 | 2006-04-28 00:00:00 | 2006-01-31 00:00:00 | 2006-07-28 00:00:00 | 2006-12-29 00:00:00 | 2006-10-30 00:00:00 | 2007-02-13 00:00:00 | 2007-04-26 00:00:00 | 2007-02-15 00:00:00 | 2006-12-29 00:00:00 | 2007-01-30 00:00:00 | 2007-07-30 00:00:00 | 2007-10-23 00:00:00 | 2013-05-16 00:00:00 | 2013-07-31 00:00:00 | 2015-03-19 00:00:00 | 2015-04-30 00:00:00 | 2015-07-29 00:00:00 | 2014-07-31 00:00:00 | 2013-10-31 00:00:00 | 2015-01-30 00:00:00 | 2014-12-30 00:00:00 | 2014-10-31 00:00:00 | 2008-01-31 00:00:00 | 2008-04-30 00:00:00 | 2008-07-31 00:00:00 | 2008-10-30 00:00:00 | 2009-01-27 00:00:00 | 2008-12-30 00:00:00 | 2009-02-19 00:00:00 | 2009-04-30 00:00:00 | 2009-07-30 00:00:00 | 2008-12-30 00:00:00 | 2010-01-31 00:00:00 | 2009-10-29 00:00:00 | 2010-04-29 00:00:00 | 2010-08-02 00:00:00 | 2010-12-28 00:00:00 | 2011-01-31 00:00:00 | 2010-12-28 00:00:00 | 2010-10-28 00:00:00 | 2011-04-21 00:00:00 | 2011-08-01 00:00:00 | 2011-04-29 00:00:00 | 2012-01-31 00:00:00 | 2011-10-27 00:00:00 | 2012-04-30 00:00:00 | 2012-07-31 00:00:00 | 2014-01-30 00:00:00 | 2015-01-22 00:00:00 | 2014-12-30 00:00:00 | 2012-12-27 00:00:00 | 2012-12-27 00:00:00 | 2012-10-30 00:00:00 | 2013-01-28 00:00:00 | 2014-04-30 00:00:00 | 2013-04-30 00:00:00 | 2015-10-30 00:00:00 | 2018-01-31 00:00:00 | 2019-06-05 00:00:00 | 2020-01-31 00:00:00 | 2018-12-28 00:00:00 | 2019-01-31 00:00:00 | 2019-07-30 00:00:00 | 2018-04-30 00:00:00 | 2018-10-31 00:00:00 | 2016-01-28 00:00:00 | 2016-05-02 00:00:00 | 2016-07-27 00:00:00 | 2016-10-31 00:00:00 | 2017-01-30 00:00:00 | 2016-12-22 00:00:00 | 2016-12-27 00:00:00 | 2017-04-27 00:00:00 | 2017-04-27 00:00:00 | 2017-07-31 00:00:00 | 2017-04-28 00:00:00 | 2017-04-20 00:00:00 | 2020-07-31 00:00:00 | 2020-11-02 00:00:00 | 2019-10-31 00:00:00 | 2021-01-11 00:00:00 | 2017-10-30 00:00:00 | 2019-04-30 00:00:00 | 2018-07-31 00:00:00 | 2021-10-28 00:00:00 | 2022-01-28 00:00:00 | 2020-04-29 00:00:00 | 2021-07-30 00:00:00 | 2021-01-31 00:00:00 | 2022-04-27 00:00:00 | 2021-04-30 00:00:00 | 2022-07-29 00:00:00 | 2022-10-24 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10006 | 10005 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10006 | 10001 | 10002 | 10005 | 10001 | 10001 | 10001 | 10006 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10006 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10006 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10002 | 10001 | 10006 | 10006 | 10001 | 10001 | 10001 | 10005 | 10001 | 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 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1995 | 1995 | 1999 | 1995 | 1999 | 1995 | 1999 | 1997 | 1995 | 1997 | 1995 | 1997 | 1997 | 1995 | 1997 | 1997 | 1997 | 1995 | 1997 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 2001 | 1999 | 2001 | 2001 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2001 | 2001 | 2003 | 2003 | 2003 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2005 | 2005 | 2005 | 2003 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2005 | 2007 | 2007 | 2007 | 2007 | 2005 | 2007 | 2007 | 2013 | 2013 | 2015 | 2015 | 2015 | 2013 | 2013 | 2013 | 2015 | 2013 | 2007 | 2007 | 2007 | 2007 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2009 | 2011 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2015 | 2015 | 2013 | 2013 | 2011 | 2011 | 2013 | 2013 | 2015 | 2017 | 2019 | 2019 | 2019 | 2017 | 2019 | 2017 | 2017 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2019 | 2021 | 2017 | 2019 | 2017 | 2021 | 2021 | 2019 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | TTHAM | * | * | DHORRELL | * | SARRIAGA | * | CFLAGG | * | * | TWALLS | GPEREZ | * | * | YBONILLA | YBONILLA | YBONILLA | * | * | YBONILLA | YBONILLA | * | * | BSMITH | YBONILLA | COMPLETED | YBONILLA | CFLAGG | COMPLETED | YBONILLA | COMPLETED | COMPLETED | YBONILLA | YBONILLA | LTHIBAUL | COMPLETED | COMPLETED | LTHIBAUL | LTHIBAUL | COMPLETED | YRODRIGU | COMPLETED | COMPLETED | SARRIAGA | YRODRIGU | LTHIBAUL | YRODRIGU | COMPLETED | COMPLETED | YRODRIGU | YRODRIGU | YRODRIGU | LTHIBAUL | YRODRIGU | * | YRODRIGU | CFLAGG | YRODRIGU | * | CFLAGG | YRODRIGU | YRODRIGU | YRODRIGU | PBANFORD | ASAETERN | CAFILER | JINGRAM | JINGRAM | ASAETERN | ASAETERN | AGLADNEY | PBANFORD | ASAETERN | YRODRIGU | YRODRIGU | LTHIBAUL | JINGRAM | JINGRAM | * | YRODRIGU | JINGRAM | JINGRAM | YRODRIGU | JINGRAM | JINGRAM | JINGRAM | ASAETERN | YRODRIGU | ASAETERN | YRODRIGU | ASAETERN | CFLAGG | ASAETERN | JINGRAM | ASAETERN | ASAETERN | ASAETERN | AGLADNEY | ASAETERN | ASAETERN | PBANFORD | SARRIAGA | SARRIAGA | ASAETERN | ASAETERN | ASAETERN | ASAETERN | JINGRAM | AGLADNEY | SARRIAGA | VUKSTINA | SARRIAGA | JFRONEFIELD | VUKSTINA | AGLADNEY | JFRONEFIELD | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | CAFILER | SARRIAGA | SMCCONNAN | PBANFORD | SMCCONNAN | SARRIAGA | PBANFORD | CVANLIEW | GTAYLOR | VUKSTINA | CVANLIEW | AGLADNEY | VUKSTINA | JFRONEFIELD | GTAYLOR | RATTIYEH | VUKSTINA | GTAYLOR | GTAYLOR | CAFILER | GTAYLOR | CAFILER | CAFILER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 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 | 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 | 11003 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 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 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1995-10-01 00:00:00 | 1995-01-01 00:00:00 | 1999-07-01 00:00:00 | 1996-04-01 00:00:00 | 1999-01-01 00:00:00 | 1995-04-01 00:00:00 | 1999-04-01 00:00:00 | 1997-10-01 00:00:00 | 1996-01-01 00:00:00 | 1997-01-01 00:00:00 | 1996-07-01 00:00:00 | 1998-07-01 00:00:00 | 1998-01-01 00:00:00 | 1996-10-01 00:00:00 | 1998-10-01 00:00:00 | 1997-04-01 00:00:00 | 1998-04-01 00:00:00 | 1995-07-01 00:00:00 | 1997-07-01 00:00:00 | 2000-01-01 00:00:00 | 1999-10-01 00:00:00 | 2000-01-01 00:00:00 | 2000-04-01 00:00:00 | 2000-04-01 00:00:00 | 2000-07-01 00:00:00 | 2000-10-01 00:00:00 | 1900-01-01 00:00:00 | 2000-07-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2000-10-01 00:00:00 | 2001-07-01 00:00:00 | 2001-04-01 00:00:00 | 2001-07-01 00:00:00 | 2001-04-01 00:00:00 | 2001-10-01 00:00:00 | 2001-10-01 00:00:00 | 2002-01-01 00:00:00 | 2002-04-01 00:00:00 | 2002-01-01 00:00:00 | 2002-04-01 00:00:00 | 2002-07-01 00:00:00 | 1900-01-01 00:00:00 | 2002-07-01 00:00:00 | 2002-10-01 00:00:00 | 2003-01-01 00:00:00 | 1900-01-01 00:00:00 | 2003-01-01 00:00:00 | 2002-10-01 00:00:00 | 2003-04-01 00:00:00 | 2003-07-01 00:00:00 | 2003-04-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-01-01 00:00:00 | 2004-04-01 00:00:00 | 2004-07-01 00:00:00 | 2004-07-01 00:00:00 | 2004-12-30 00:00:00 | 1900-01-01 00:00:00 | 2005-01-01 00:00:00 | 1900-01-01 00:00:00 | 2004-10-01 00:00:00 | 2004-10-01 00:00:00 | 2005-01-19 00:00:00 | 2005-04-01 00:00:00 | 2005-07-01 00:00:00 | 2006-01-01 00:00:00 | 2005-10-01 00:00:00 | 2006-04-01 00:00:00 | 2006-12-06 00:00:00 | 2006-07-01 00:00:00 | 1900-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-02-13 00:00:00 | 1900-01-01 00:00:00 | 2006-10-01 00:00:00 | 2007-04-01 00:00:00 | 2007-07-01 00:00:00 | 1900-01-01 00:00:00 | 2013-04-01 00:00:00 | 2015-03-19 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 | 2014-10-01 00:00:00 | 1900-01-01 00:00:00 | 2014-07-01 00:00:00 | 2007-10-01 00:00:00 | 2008-01-01 00:00:00 | 2008-04-01 00:00:00 | 2008-07-01 00:00:00 | 2008-10-01 00:00:00 | 2008-12-29 00:00:00 | 1900-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-04-01 00:00:00 | 1900-01-01 00:00:00 | 2009-10-01 00:00:00 | 2009-07-01 00:00:00 | 2010-01-01 00:00:00 | 2010-04-01 00:00:00 | 1900-01-01 00:00:00 | 2010-10-01 00:00:00 | 2010-12-05 00:00:00 | 2010-07-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 | 1900-01-01 00:00:00 | 2014-12-15 00:00:00 | 2012-12-17 00:00:00 | 1900-01-01 00:00:00 | 2012-07-01 00:00:00 | 2012-10-01 00:00:00 | 2014-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-07-01 00:00:00 | 2017-10-01 00:00:00 | 1900-01-01 00:00:00 | 2019-10-01 00:00:00 | 1900-01-01 00:00:00 | 2018-10-01 00:00:00 | 2019-04-01 00:00:00 | 2018-01-01 00:00:00 | 2018-07-01 00:00:00 | 2015-10-01 00:00:00 | 2016-01-01 00:00:00 | 2016-04-01 00:00:00 | 2016-07-01 00:00:00 | 2016-10-01 00:00:00 | 2016-12-13 00:00:00 | 1900-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-04-20 00:00:00 | 2017-04-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-04-01 00:00:00 | 2020-07-01 00:00:00 | 2019-07-01 00:00:00 | 1900-01-01 00:00:00 | 2017-07-01 00:00:00 | 2019-01-01 00:00:00 | 2018-04-01 00:00:00 | 2021-07-01 00:00:00 | 2021-10-01 00:00:00 | 2020-01-01 00:00:00 | 2021-04-01 00:00:00 | 2020-10-01 00:00:00 | 2022-01-01 00:00:00 | 2021-01-01 00:00:00 | 2022-04-01 00:00:00 | 2022-07-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1995-12-31 00:00:00 | 1995-03-31 00:00:00 | 1999-09-30 00:00:00 | 1996-06-30 00:00:00 | 1999-03-31 00:00:00 | 1995-06-30 00:00:00 | 1999-06-30 00:00:00 | 1997-12-31 00:00:00 | 1996-03-31 00:00:00 | 1997-03-31 00:00:00 | 1996-09-30 00:00:00 | 1998-09-30 00:00:00 | 1998-03-31 00:00:00 | 1996-12-31 00:00:00 | 1998-12-31 00:00:00 | 1997-06-30 00:00:00 | 1998-06-30 00:00:00 | 1995-09-30 00:00:00 | 1997-09-30 00:00:00 | 2000-03-31 00:00:00 | 1999-12-31 00:00:00 | 2000-03-31 00:00:00 | 2000-06-30 00:00:00 | 2000-06-30 00:00:00 | 2000-09-30 00:00:00 | 2000-12-31 00:00:00 | 1900-01-01 00:00:00 | 2000-09-30 00:00:00 | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 | 2000-12-31 00:00:00 | 2001-09-30 00:00:00 | 2001-06-30 00:00:00 | 2001-09-30 00:00:00 | 2001-06-30 00:00:00 | 2001-12-31 00:00:00 | 2001-12-31 00:00:00 | 2002-03-31 00:00:00 | 2002-06-30 00:00:00 | 2002-03-31 00:00:00 | 2002-06-30 00:00:00 | 2002-09-30 00:00:00 | 1900-01-01 00:00:00 | 2002-09-30 00:00:00 | 2002-12-31 00:00:00 | 2003-03-31 00:00:00 | 1900-01-01 00:00:00 | 2003-03-31 00:00:00 | 2002-12-31 00:00:00 | 2003-06-30 00:00:00 | 2003-09-30 00:00:00 | 2003-06-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-03-31 00:00:00 | 2004-06-30 00:00:00 | 2004-09-30 00:00:00 | 2004-09-30 00:00:00 | 2004-12-30 00:00:00 | 1900-01-01 00:00:00 | 2005-03-31 00:00:00 | 1900-01-01 00:00:00 | 2004-12-31 00:00:00 | 2004-12-31 00:00:00 | 2005-01-19 00:00:00 | 2005-06-30 00:00:00 | 2005-09-30 00:00:00 | 2006-03-31 00:00:00 | 2005-12-31 00:00:00 | 2006-06-30 00:00:00 | 2006-12-06 00:00:00 | 2006-09-30 00:00:00 | 1900-01-01 00:00:00 | 2007-03-31 00:00:00 | 2007-02-13 00:00:00 | 1900-01-01 00:00:00 | 2006-12-31 00:00:00 | 2007-06-30 00:00:00 | 2007-09-30 00:00:00 | 1900-01-01 00:00:00 | 2013-06-30 00:00:00 | 2015-03-19 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 | 2014-12-31 00:00:00 | 1900-01-01 00:00:00 | 2014-09-30 00:00:00 | 2007-12-31 00:00:00 | 2008-03-31 00:00:00 | 2008-06-30 00:00:00 | 2008-09-30 00:00:00 | 2008-12-31 00:00:00 | 2008-12-29 00:00:00 | 1900-01-01 00:00:00 | 2009-03-31 00:00:00 | 2009-06-30 00:00:00 | 1900-01-01 00:00:00 | 2009-12-31 00:00:00 | 2009-09-30 00:00:00 | 2010-03-31 00:00:00 | 2010-06-30 00:00:00 | 1900-01-01 00:00:00 | 2010-12-31 00:00:00 | 2010-12-05 00:00:00 | 2010-09-30 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 | 1900-01-01 00:00:00 | 2014-12-15 00:00:00 | 2012-12-17 00:00:00 | 1900-01-01 00:00:00 | 2012-09-30 00:00:00 | 2012-12-31 00:00:00 | 2014-03-31 00:00:00 | 2013-03-31 00:00:00 | 2015-09-30 00:00:00 | 2017-12-31 00:00:00 | 1900-01-01 00:00:00 | 2019-12-31 00:00:00 | 1900-01-01 00:00:00 | 2018-12-31 00:00:00 | 2019-06-30 00:00:00 | 2018-03-31 00:00:00 | 2018-09-30 00:00:00 | 2015-12-31 00:00:00 | 2016-03-31 00:00:00 | 2016-06-30 00:00:00 | 2016-09-30 00:00:00 | 2016-12-31 00:00:00 | 2016-12-13 00:00:00 | 1900-01-01 00:00:00 | 2017-03-31 00:00:00 | 2017-04-20 00:00:00 | 2017-06-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2020-06-30 00:00:00 | 2020-09-30 00:00:00 | 2019-09-30 00:00:00 | 1900-01-01 00:00:00 | 2017-09-30 00:00:00 | 2019-03-31 00:00:00 | 2018-06-30 00:00:00 | 2021-09-30 00:00:00 | 2021-12-31 00:00:00 | 2020-03-31 00:00:00 | 2021-06-30 00:00:00 | 2020-12-31 00:00:00 | 2022-03-31 00:00:00 | 2021-03-31 00:00:00 | 2022-06-30 00:00:00 | 2022-09-30 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 22001 | None | None | 22001 | None | 22001 | 22001 | None | None | None | 22001 | 22001 | None | None | 22001 | None | 22001 | 22001 | None | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22006 | 22006 | 22001 | 22006 | 22001 | 22006 | 22001 | 22006 | 22006 |
filer_id | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | 2001 | 1999 | 1997 | 1995 | 2003 | 2005 | 2007 | 2011 | 2013 | 2009 | 2021 | 2015 | 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 | 2001-01-01 00:00:00 | 1999-01-01 00:00:00 | 1997-01-01 00:00:00 | 1995-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 | 2021-01-01 00:00:00 | 2015-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 | 1148307 | |
---|---|---|
xref_id | L22691 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | L22691 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | 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 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 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 | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ROSS | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namf | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN M. | JONATHAN | JONATHAN | JONATHAN | JONATHAN | JONATHAN | JONATHAN | JONATHAN | JONATHAN | JONATHAN | JONATHAN | JONATHAN | JONATHAN | JONATHAN | JONATHAN | JONATHAN | JONATHAN | JONATHAN | JONATHAN | JONATHAN | JONATHAN | JONATHAN | JONATHAN | JONATHAN | JONATHAN | JONATHAN | JONATHAN | JONATHAN | JONATHAN | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | 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 | 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 | 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 | 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 | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
zip4 | 95814 | 95818 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95818 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95818 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95818 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95818 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95818 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95818 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95818 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95818 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95818 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95818 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95818 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | 9164482162 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | 9164484923 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
[email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | [email protected] | j | j | j | j | j | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | [email protected] | j | j | j | j | j | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | [email protected] | j | j | j | j | j | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | [email protected] | j | j | j | j | j | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | [email protected] | j | j | j | j | j | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | [email protected] | j | j | j | j | j | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | [email protected] | j | j | j | j | j | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | [email protected] | j | j | j | j | j | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | [email protected] | j | j | j | j | j | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | [email protected] | j | j | j | j | j | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | [email protected] | j | j | j | j | j | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | [email protected] | j | j | j | j | j |
filer_id | 1148307 |
---|
filer_id | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
change_no | 1 | 2 | 10 | 11 | 5 | 3 | 8 | 4 | 9 | 6 | 7 | |||||||||||
session_id | 1999 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | |||||||||||
log_dt | 2000-11-28 00:00:00 | 2000-11-28 00:00:00 | 2001-04-12 00:00:00 | 2001-04-12 00:00:00 | 2001-04-12 00:00:00 | 2001-04-12 00:00:00 | 2001-04-12 00:00:00 | 2001-04-12 00:00:00 | 2001-04-12 00:00:00 | 2001-04-12 00:00:00 | 2001-04-12 00:00:00 | |||||||||||
filer_type | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |||||||||||
correction_flg | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
action | SET ACTIVE | SET ACTIVE | IN SUSPENSE | IN SUSPENSE | IN SUSPENSE | IN SUSPENSE | IN SUSPENSE | IN SUSPENSE | IN SUSPENSE | IN SUSPENSE | IN SUSPENSE | |||||||||||
attribute_changed | CLIENT | CLIENT | EMPLOYER | EMPLOYER | EMPLOYER | LOBBYIST | EMPLOYER | CLIENT | CLIENT | CLIENT | CLIENT | |||||||||||
ethics_dt | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
interests | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
filer_full_name | JONATHAN M. ROSS | JONATHAN M. ROSS | JONATHAN M. ROSS | JONATHAN M. ROSS | JONATHAN M. ROSS | JONATHAN M. ROSS | JONATHAN M. ROSS | JONATHAN M. ROSS | JONATHAN M. ROSS | JONATHAN M. ROSS | JONATHAN M. ROSS | |||||||||||
filer_city | Trona | Los Angeles | SACRAMENTO | SACRAMENTO | Sacramento | None | SACRAMENTO | Sacramento | SACRAMENTO | CYPRESS | Roseville | |||||||||||
filer_st | CA | CA | CA | CA | CA | None | CA | CA | CA | CA | CA | |||||||||||
filer_zip | 93592 | 90007 | 95814 | 95814 | 95814 | None | 95814 | 95814 | 95814 | 90630 | 95661 | |||||||||||
filer_phone | 7603722042 | 2137633346 | 9164475793 | 9164475793 | 9164467100 | None | 9164446670 | 9164482162 | 9164467100 | 7142263582 | 9167743381 | |||||||||||
entity_type | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | |||||||||||
entity_name | KAHL/POWNALL ADVOCATES | KAHL/POWNALL ADVOCATES | KAHL/POWNALL ADVOCATES | KAHL/POWNALL ADVOCATES | KAHL/POWNALL ADVOCATES | KAHL/POWNALL ADVOCATES | KAHL/POWNALL ADVOCATES | KAHL/POWNALL ADVOCATES | KAHL/POWNALL ADVOCATES | KAHL/POWNALL ADVOCATES | KAHL/POWNALL ADVOCATES | |||||||||||
entity_city | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
entity_st | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
entity_zip | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
entity_phone | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
entity_id | 1147235 | 1147235 | 1147235 | 1147235 | 1147235 | 1147235 | 1147235 | 1147235 | 1147235 | 1147235 | 1147235 | |||||||||||
responsible_officer | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
effect_dt | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | 1148307 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 638558_0.cal | 646232_0.cal | 683008_0.cal | 719328_0.cal | 746548_0.cal | 770816_0.cal | 791680_0.cal | 813558_0.cal | 837413_0.cal | 856015_0.cal | 879364_0.cal | 909473_0.cal | 929324_0.cal | 945235_0.cal | 966830_0.cal | 985781_0.cal | 1011726_0.cal | 1029295_0.cal | 1059005_0.cal | 1069779_1.cal | 1078125_0.cal | 1105244_0.cal | 1119107_0.cal | 1132669_0.cal | 1148855_0.cal | 1166466_0.cal | 1189301_0.cal | 1329139_0.cal | 1554251_0.cal | 1507807_0.cal | 1392918_0.cal | 1421408_0.cal | 1350783_0.cal | 1484444_0.cal | 1451285_0.cal | 1236393_0.cal | 1215727_0.cal | 1386451_0.cal | 1225247_0.cal | 1225247_1.cal | 1464210_0.cal | 1260054_0.cal | 63837.cal | 1282998_0.cal | 1436572_0.cal | 1294322_0.cal | 1377293_0.cal | 1311768_0.cal | 1845826_0.cal | 1734146_0.cal | 1678939_0.cal | 1782390_0.cal | 1538330_0.cal | 1571111_0.cal | 1817124_0.cal | 1607821_0.cal | 1590644_0.cal | 1800314_0.cal | 1765137_0.cal | 1637148_0.cal | 1620461_0.cal | 1707976_0.cal | 1720606_0.cal | 1657260_0.cal | 1872446_0.cal | 1965469_0.cal | 1979118_0.cal | 2113698_1.cal | 2154947_0.cal | 2127848_0.cal | 2059471_0.cal | 1996612_0.cal | 2009382_0.cal | 2113698_0.cal | 2102140_0.cal | 1922063_0.cal | 1911516_0.cal | 2037816_0.cal | 1935108_0.cal | 1922063_1.cal | 2175846_0.cal | 2211677_0.cal | 2350005_0.cal | 2381704_0.cal | 2320193_0.cal | 2243075_0.cal | 2419323_0.cal | 2397218_0.cal | 2443158_0.cal | 2469837_0.cal | 2487639_0.cal | 2191727_0.cal | 2276624_0.cal | 2530867_0.cal | 2552356_0.cal | 328001.cal | 2580435_0.cal | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
received_date | 2000-07-10 00:00:00 | 2000-08-01 00:00:00 | 2000-10-31 00:00:00 | 2001-01-31 00:00:00 | 2001-04-30 00:00:00 | 2001-07-27 00:00:00 | 2001-10-31 00:00:00 | 2002-01-31 00:00:00 | 2002-04-25 00:00:00 | 2002-07-31 00:00:00 | 2002-10-25 00:00:00 | 2003-01-30 00:00:00 | 2003-04-28 00:00:00 | 2003-07-28 00:00:00 | 2003-10-24 00:00:00 | 2004-01-23 00:00:00 | 2004-04-27 00:00:00 | 2004-07-30 00:00:00 | 2004-11-01 00:00:00 | 2005-02-16 00:00:00 | 2005-01-28 00:00:00 | 2005-05-02 00:00:00 | 2005-08-01 00:00:00 | 2005-10-28 00:00:00 | 2006-01-31 00:00:00 | 2006-04-28 00:00:00 | 2006-07-28 00:00:00 | 2008-04-30 00:00:00 | 2010-12-28 00:00:00 | 2010-08-02 00:00:00 | 2009-01-27 00:00:00 | 2009-04-30 00:00:00 | 2008-07-31 00:00:00 | 2010-04-29 00:00:00 | 2009-10-29 00:00:00 | 2007-01-30 00:00:00 | 2006-10-30 00:00:00 | 2008-12-30 00:00:00 | 2006-12-29 00:00:00 | 2007-02-15 00:00:00 | 2010-01-31 00:00:00 | 2007-04-26 00:00:00 | 2007-04-26 00:00:00 | 2007-07-30 00:00:00 | 2009-07-30 00:00:00 | 2007-10-23 00:00:00 | 2008-10-30 00:00:00 | 2008-01-31 00:00:00 | 2014-04-30 00:00:00 | 2013-01-28 00:00:00 | 2012-07-31 00:00:00 | 2013-07-31 00:00:00 | 2010-10-28 00:00:00 | 2011-01-31 00:00:00 | 2014-01-30 00:00:00 | 2011-08-01 00:00:00 | 2011-04-29 00:00:00 | 2013-10-31 00:00:00 | 2013-04-30 00:00:00 | 2012-01-31 00:00:00 | 2011-10-27 00:00:00 | 2012-10-30 00:00:00 | 2012-12-27 00:00:00 | 2012-04-30 00:00:00 | 2014-07-31 00:00:00 | 2015-04-30 00:00:00 | 2015-07-29 00:00:00 | 2017-04-27 00:00:00 | 2017-04-27 00:00:00 | 2017-01-30 00:00:00 | 2016-07-27 00:00:00 | 2015-10-30 00:00:00 | 2016-01-28 00:00:00 | 2016-12-22 00:00:00 | 2016-10-31 00:00:00 | 2014-12-30 00:00:00 | 2014-10-31 00:00:00 | 2016-05-02 00:00:00 | 2015-01-30 00:00:00 | 2015-03-19 00:00:00 | 2017-07-31 00:00:00 | 2018-01-31 00:00:00 | 2019-01-31 00:00:00 | 2019-04-30 00:00:00 | 2018-10-31 00:00:00 | 2018-04-30 00:00:00 | 2019-10-31 00:00:00 | 2019-07-30 00:00:00 | 2020-01-31 00:00:00 | 2020-04-29 00:00:00 | 2020-07-31 00:00:00 | 2017-10-30 00:00:00 | 2018-07-31 00:00:00 | 2020-11-02 00:00:00 | 2021-01-31 00:00:00 | 2021-01-31 00:00:00 | 2021-04-30 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/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /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/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_id | 638558 | 646232 | 683008 | 719328 | 746548 | 770816 | 791680 | 813558 | 837413 | 856015 | 879364 | 909473 | 929324 | 945235 | 966830 | 985781 | 1011726 | 1029295 | 1059005 | 1069779 | 1078125 | 1105244 | 1119107 | 1132669 | 1148855 | 1166466 | 1189301 | 1329139 | 1554251 | 1507807 | 1392918 | 1421408 | 1350783 | 1484444 | 1451285 | 1236393 | 1215727 | 1386451 | 1225247 | 1225247 | 1464210 | 1260054 | None | 1282998 | 1436572 | 1294322 | 1377293 | 1311768 | 1845826 | 1734146 | 1678939 | 1782390 | 1538330 | 1571111 | 1817124 | 1607821 | 1590644 | 1800314 | 1765137 | 1637148 | 1620461 | 1707976 | 1720606 | 1657260 | 1872446 | 1965469 | 1979118 | 2113698 | 2154947 | 2127848 | 2059471 | 1996612 | 2009382 | 2113698 | 2102140 | 1922063 | 1911516 | 2037816 | 1935108 | 1922063 | 2175846 | 2211677 | 2350005 | 2381704 | 2320193 | 2243075 | 2419323 | 2397218 | 2443158 | 2469837 | 2487639 | 2191727 | 2276624 | 2530867 | 2552356 | None | 2580435 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F604 | F615 | F615 | None | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | None | F615 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
receive_comment | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted |