filer_id | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1109074 | 2041846 | 2081453 | 2115094 | 2164340 | 2212513 | 2418841 | 2470624 | 2508563 | 2275396 | 2338428 | 2549838 | ||||||||||||
effect_dt | 1999-05-18 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-02-24 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | 2013-01-01 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 | ||||||||||||
session_id | 1999 | 2003 | 2005 | 2007 | 2009 | 2011 | 2017 | 2019 | 2021 | 2013 | 2015 | 2023 |
filer_id | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 473249 | 473249 | 478796 | 614773 | 631840 | 619539 | 660317 | 676309 | 691507 | 705283 | 716792 | 744584 | 724754 | 737846 | 771276 | 752963 | 797723 | 790790 | 779284 | 811697 | 837737 | 844241 | 839292 | 820269 | 863033 | 846470 | 864884 | 864885 | 855016 | 893393 | 920468 | 881905 | 905975 | 938806 | 930606 | 910127 | 912032 | 947961 | 955322 | 999197 | 969990 | 973521 | 1029969 | 990432 | 1033816 | 1014356 | 1018698 | 1058912 | 1096070 | 1092251 | 1095162 | 1082108 | 1065033 | 1082130 | 1082173 | 1103266 | 1134814 | 1118077 | 1109619 | 1146082 | 1134230 | 1166179 | 1189889 | 1217043 | 1225948 | 1232914 | 1238283 | 1262194 | 1285471 | 1776361 | 1967184 | 1862603 | 1805513 | 1805513 | 1805513 | 1951943 | 1901202 | 1315281 | 1309443 | 1298095 | 1330055 | 1316859 | 1351629 | 1386169 | 1377451 | 1387478 | 1409959 | 1416265 | 1417490 | 1417490 | 1433117 | 1397899 | 1448644 | 1579924 | 1580212 | 1586296 | 1598329 | 1600325 | 1617526 | 1600325 | 1628102 | 1652324 | 1598329 | 1672908 | 1652324 | 1825977 | 1825977 | 1924602 | 1918915 | 1713548 | 1718673 | 1742722 | 1728196 | 1838131 | 1713548 | 1756140 | 2000903 | 1985879 | 2310918 | 2341423 | 2465642 | 2203047 | 2480272 | 2465642 | 2335057 | 2334829 | 2231899 | 2013428 | 2013428 | 2029193 | 2055942 | 2092298 | 2121980 | 2117278 | 2151526 | 2137714 | 2171201 | 2265090 | 2541621 | 2187965 | 2480272 | 2375034 | 2433795 | 2465642 | 2576526 | 2415251 | 2545426 | 2392520 | 2433795 | 2601896 | 2584003 | 2667455 | 2636454 | 2524637 | 2621427 | 2701213 | 2739916 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 158 | 158 | 159 | 160 | None | 160 | 162 | 163 | 163 | None | 164 | 165 | None | 164 | 166 | 165 | None | 167 | None | 168 | None | None | 169 | None | None | None | None | None | 170 | None | None | 171 | None | None | 173 | 172 | None | 174 | None | None | 175 | None | 178 | 176 | None | 177 | None | 179 | None | None | None | 180 | None | 181 | 181 | 181 | None | 182 | None | 184 | 183 | 185 | 186 | 187 | 189 | None | 188 | 189 | 190 | 214 | 221 | 218 | 214 | 214 | 215 | None | 219 | 193 | 192 | 191 | 193 | None | 194 | 196 | 195 | 196 | None | None | 197 | 197 | 198 | 196 | 199 | None | 205 | None | 205 | 206 | 207 | 206 | 208 | 209 | 205 | 210 | 209 | 216 | 216 | 220 | 220 | 211 | 212 | None | 212 | 217 | 211 | 213 | 223 | 222 | 235 | None | 241 | 232 | 242 | 241 | 236 | 236 | 233 | 224 | 224 | 225 | 226 | 227 | 228 | 228 | 229 | None | 230 | 234 | 244 | 231 | 242 | 237 | 240 | 241 | 245 | 239 | 244 | 238 | 240 | 246 | None | 249 | 248 | 243 | 247 | 250 | 251 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F635 | F690 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F690 | F602 | F602 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F602 | F602 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F602 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1999-07-27 00:00:00 | 1999-10-29 00:00:00 | 1999-10-29 00:00:00 | 2000-01-25 00:00:00 | 2000-05-01 00:00:00 | 2000-01-28 00:00:00 | 2000-07-31 00:00:00 | 2000-10-25 00:00:00 | 2000-10-31 00:00:00 | 2000-12-28 00:00:00 | 2001-01-30 00:00:00 | 2001-04-27 00:00:00 | 2000-12-28 00:00:00 | 2001-01-31 00:00:00 | 2001-07-28 00:00:00 | 2001-04-27 00:00:00 | 2001-10-30 00:00:00 | 2001-10-30 00:00:00 | 2001-07-31 00:00:00 | 2002-01-29 00:00:00 | 2002-02-06 00:00:00 | 2002-04-30 00:00:00 | 2002-04-30 00:00:00 | 2002-01-30 00:00:00 | 2002-07-31 00:00:00 | 2002-04-08 00:00:00 | 2002-08-20 00:00:00 | 2002-08-22 00:00:00 | 2002-07-30 00:00:00 | 2002-10-30 00:00:00 | 2003-01-30 00:00:00 | 2002-10-29 00:00:00 | 2002-12-30 00:00:00 | 2003-04-29 00:00:00 | 2003-04-29 00:00:00 | 2003-01-30 00:00:00 | 2002-12-20 00:00:00 | 2003-07-31 00:00:00 | 2003-07-31 00:00:00 | 2004-02-02 00:00:00 | 2003-10-31 00:00:00 | 2003-10-31 00:00:00 | 2004-07-30 00:00:00 | 2004-02-02 00:00:00 | 2004-07-30 00:00:00 | 2004-04-30 00:00:00 | 2004-04-30 00:00:00 | 2004-11-01 00:00:00 | 2005-01-31 00:00:00 | 2004-12-31 00:00:00 | 2005-02-02 00:00:00 | 2005-02-01 00:00:00 | 2004-11-01 00:00:00 | 2005-02-01 00:00:00 | 2005-02-01 00:00:00 | 2005-04-27 00:00:00 | 2005-10-31 00:00:00 | 2005-07-31 00:00:00 | 2005-06-09 00:00:00 | 2006-01-30 00:00:00 | 2005-10-31 00:00:00 | 2006-04-28 00:00:00 | 2006-07-29 00:00:00 | 2006-10-31 00:00:00 | 2007-01-02 00:00:00 | 2007-01-02 00:00:00 | 2007-01-31 00:00:00 | 2007-04-30 00:00:00 | 2007-07-31 00:00:00 | 2013-07-18 00:00:00 | 2015-05-06 00:00:00 | 2014-07-14 00:00:00 | 2013-11-22 00:00:00 | 2013-12-02 00:00:00 | 2013-12-02 00:00:00 | 2014-12-17 00:00:00 | 2014-10-21 00:00:00 | 2008-02-13 00:00:00 | 2008-01-30 00:00:00 | 2007-10-31 00:00:00 | 2008-04-30 00:00:00 | 2008-02-27 00:00:00 | 2008-07-31 00:00:00 | 2008-12-29 00:00:00 | 2008-10-30 00:00:00 | 2009-01-05 00:00:00 | 2009-01-21 00:00:00 | 2008-12-30 00:00:00 | 2009-04-15 00:00:00 | 2009-05-20 00:00:00 | 2009-07-23 00:00:00 | 2009-02-02 00:00:00 | 2009-10-21 00:00:00 | 2011-02-24 00:00:00 | 2011-03-01 00:00:00 | 2011-02-25 00:00:00 | 2011-06-28 00:00:00 | 2011-10-14 00:00:00 | 2011-10-14 00:00:00 | 2011-07-14 00:00:00 | 2012-01-12 00:00:00 | 2012-04-16 00:00:00 | 2011-08-11 00:00:00 | 2012-07-19 00:00:00 | 2012-06-15 00:00:00 | 2014-03-04 00:00:00 | 2014-03-14 00:00:00 | 2015-01-12 00:00:00 | 2014-12-18 00:00:00 | 2012-11-08 00:00:00 | 2012-12-19 00:00:00 | 2012-12-18 00:00:00 | 2013-01-17 00:00:00 | 2014-04-14 00:00:00 | 2013-03-01 00:00:00 | 2013-04-11 00:00:00 | 2015-12-09 00:00:00 | 2015-08-14 00:00:00 | 2018-10-23 00:00:00 | 2019-01-11 00:00:00 | 2020-04-14 00:00:00 | 2018-01-19 00:00:00 | 2020-07-23 00:00:00 | 2020-07-30 00:00:00 | 2019-01-17 00:00:00 | 2019-01-16 00:00:00 | 2018-04-17 00:00:00 | 2016-02-02 00:00:00 | 2016-03-11 00:00:00 | 2016-04-18 00:00:00 | 2016-07-18 00:00:00 | 2016-10-20 00:00:00 | 2017-01-23 00:00:00 | 2017-01-04 00:00:00 | 2017-04-18 00:00:00 | 2016-12-30 00:00:00 | 2017-07-25 00:00:00 | 2018-07-17 00:00:00 | 2020-12-31 00:00:00 | 2017-10-16 00:00:00 | 2020-08-10 00:00:00 | 2019-04-19 00:00:00 | 2020-07-30 00:00:00 | 2020-07-30 00:00:00 | 2021-04-23 00:00:00 | 2019-10-24 00:00:00 | 2021-01-21 00:00:00 | 2019-07-24 00:00:00 | 2020-01-23 00:00:00 | 2021-08-01 00:00:00 | 2021-01-04 00:00:00 | 2022-04-19 00:00:00 | 2022-01-23 00:00:00 | 2020-10-28 00:00:00 | 2021-10-28 00:00:00 | 2022-07-26 00:00:00 | 2022-10-24 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10006 | 10005 | 10001 | 10005 | 10005 | 10006 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10006 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10002 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10002 | 10001 | 10001 | 10001 | 10005 | 10001 | 10006 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10002 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10002 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 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 | 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 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 2001 | 1999 | 2001 | 2001 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2003 | 2003 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2005 | 2003 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2007 | 2005 | 2007 | 2007 | 2013 | 2015 | 2013 | 2013 | 2013 | 2013 | 2015 | 2013 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2009 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2007 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2013 | 2013 | 2015 | 2011 | 2013 | 2013 | 2011 | 2013 | 2011 | 2013 | 2015 | 2015 | 2017 | 2019 | 2019 | 2017 | 2019 | 2019 | 2017 | 2019 | 2017 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2021 | 2017 | 2019 | 2019 | 2019 | 2019 | 2021 | 2019 | 2019 | 2019 | 2019 | 2021 | 2021 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | KCHAN | * | YBONILLA | * | YBONILLA | GKURIMOT | * | * | GGILMORE | YBONILLA | * | JBRANNAN | LTHIBAUL | * | LTHIBAUL | * | LTHIBAUL | LTHIBAUL | * | LTHIBAUL | LTHIBAUL | LTHIBAUL | SARRIAGA | SARRIAGA | * | LTHIBAUL | LTHIBAUL | * | SARRIAGA | DWALKER | COMPLETED | COMPLETED | BSMITH | COMPLETED | MHOANG | LTHIBAUL | COMPLETED | LTHIBAUL | COMPLETED | COMPLETED | LTHIBAUL | COMPLETED | LTHIBAUL | COMPLETED | LTHIBAUL | CFLAGG | CFLAGG | COMPLETED | EMCENTEE | COMPLETED | COMPLETED | LTHIBAUL | SARRIAGA | LTHIBAUL | SARRIAGA | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | * | PBANFORD | LTHIBAUL | LTHIBAUL | YRODRIGU | AGLADNEY | RGEREMIA | AGLADNEY | RGEREMIA | RGEREMIA | RGEREMIA | SARRIAGA | AGLADNEY | * | LTHIBAUL | YRODRIGU | RGEREMIA | YRODRIGU | LTHIBAUL | YRODRIGU | ASAETERN | YRODRIGU | SARRIAGA | PBANFORD | WBROWN | WBROWN | WBROWN | ASAETERN | WBROWN | CFLAGG | YRODRIGU | YRODRIGU | AGLADNEY | ASAETERN | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | ASAETERN | RGEREMIA | AGLADNEY | MPACHECO | SARRIAGA | AGLADNEY | PBANFORD | PBANFORD | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | PBANFORD | GTAYLOR | AGLADNEY | GTAYLOR | GTAYLOR | AGLADNEY | PBANFORD | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | CAFILER | AGLADNEY | GPEREZ | DMCCASTL | AGLADNEY | MMERCHANT | AGLADNEY | GTAYLOR | GTAYLOR | GTAYLOR | GTAYLOR | CHATRIDGE | AGLADNEY | GTAYLOR | GTAYLOR | GTAYLOR | CHATRIDGE | MMERCHANT | CAFILER | CHATRIDGE | GTAYLOR | MKIRKHAM | CAFILER | 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 | 11002 | 11003 | 11003 | 11003 | 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 | 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 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 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 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1999-04-01 00:00:00 | 1999-04-01 00:00:00 | 1999-07-01 00:00:00 | 1999-10-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-07-01 00:00:00 | 1900-01-01 00:00:00 | 2000-10-01 00:00:00 | 2001-01-01 00:00:00 | 1900-01-01 00:00:00 | 2000-10-01 00:00:00 | 2001-04-01 00:00:00 | 2001-01-01 00:00:00 | 2001-07-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-01-01 00:00:00 | 2001-10-01 00:00:00 | 2002-04-01 00:00:00 | 2001-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2002-04-01 00:00:00 | 2002-07-01 00:00:00 | 2002-10-01 00:00:00 | 2002-07-01 00:00:00 | 1900-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-01-01 00:00:00 | 2002-10-01 00:00:00 | 1900-01-01 00:00:00 | 2003-04-01 00:00:00 | 2003-04-01 00:00:00 | 2003-10-01 00:00:00 | 2003-07-01 00:00:00 | 2003-07-01 00:00:00 | 2004-04-01 00:00:00 | 2003-10-01 00:00:00 | 2004-04-01 00:00:00 | 2004-01-01 00:00:00 | 2004-01-01 00:00:00 | 2004-07-01 00:00:00 | 2004-10-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2004-10-01 00:00:00 | 2004-07-01 00:00:00 | 2005-01-31 00:00:00 | 2005-01-31 00:00:00 | 2005-01-01 00:00:00 | 1900-01-01 00:00:00 | 2005-04-01 00:00:00 | 1900-01-01 00:00:00 | 2005-10-01 00:00:00 | 2005-07-01 00:00:00 | 2006-01-01 00:00:00 | 2006-04-01 00:00:00 | 2006-07-01 00:00:00 | 2007-01-02 00:00:00 | 1900-01-01 00:00:00 | 2006-10-01 00:00:00 | 2007-01-01 00:00:00 | 2007-04-01 00:00:00 | 2013-04-01 00:00:00 | 2015-01-01 00:00:00 | 2014-04-01 00:00:00 | 2013-06-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 1900-01-01 00:00:00 | 2014-07-01 00:00:00 | 2008-02-13 00:00:00 | 2007-10-01 00:00:00 | 2007-07-01 00:00:00 | 2008-01-01 00:00:00 | 1900-01-01 00:00:00 | 2008-04-01 00:00:00 | 2008-12-29 00:00:00 | 2008-07-01 00:00:00 | 2008-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-04-01 00:00:00 | 2008-10-01 00:00:00 | 2009-07-01 00:00:00 | 1900-01-01 00:00:00 | 2011-02-24 00:00:00 | 1900-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-04-01 00:00:00 | 2011-07-01 00:00:00 | 2011-04-01 00:00:00 | 2011-10-01 00:00:00 | 2012-01-01 00:00:00 | 2011-01-01 00:00:00 | 2012-04-01 00:00:00 | 2012-01-01 00:00:00 | 2013-10-01 00:00:00 | 2013-10-01 00:00:00 | 2014-10-01 00:00:00 | 2014-12-15 00:00:00 | 2012-07-01 00:00:00 | 2012-12-15 00:00:00 | 1900-01-01 00:00:00 | 2012-10-01 00:00:00 | 2014-01-01 00:00:00 | 2012-07-01 00:00:00 | 2013-01-01 00:00:00 | 2015-07-01 00:00:00 | 2015-04-01 00:00:00 | 2018-07-01 00:00:00 | 1900-01-01 00:00:00 | 2020-01-01 00:00:00 | 2017-10-01 00:00:00 | 2020-04-01 00:00:00 | 2020-01-01 00:00:00 | 2018-10-01 00:00:00 | 2018-12-31 00:00:00 | 2018-01-01 00:00:00 | 2015-10-01 00:00:00 | 2015-10-01 00:00:00 | 2016-01-01 00:00:00 | 2016-04-01 00:00:00 | 2016-07-01 00:00:00 | 2016-10-01 00:00:00 | 2016-12-31 00:00:00 | 2017-01-27 00:00:00 | 1900-01-01 00:00:00 | 2017-04-01 00:00:00 | 2018-04-01 00:00:00 | 2020-12-31 00:00:00 | 2017-07-01 00:00:00 | 2020-04-01 00:00:00 | 2019-01-01 00:00:00 | 2019-10-01 00:00:00 | 2020-01-01 00:00:00 | 2021-01-01 00:00:00 | 2019-07-01 00:00:00 | 2020-10-01 00:00:00 | 2019-04-01 00:00:00 | 2019-10-01 00:00:00 | 2021-04-01 00:00:00 | 1900-01-01 00:00:00 | 2022-01-01 00:00:00 | 2021-10-01 00:00:00 | 2020-07-01 00:00:00 | 2021-07-01 00:00:00 | 2022-04-01 00:00:00 | 2022-07-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1999-06-30 00:00:00 | 1999-06-30 00:00:00 | 1999-09-30 00:00:00 | 1999-12-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-09-30 00:00:00 | 1900-01-01 00:00:00 | 2000-12-31 00:00:00 | 2001-03-31 00:00:00 | 1900-01-01 00:00:00 | 2000-12-31 00:00:00 | 2001-06-30 00:00:00 | 2001-03-31 00:00:00 | 2001-09-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-03-31 00:00:00 | 2001-12-31 00:00:00 | 2002-06-30 00:00:00 | 2001-03-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2002-06-30 00:00:00 | 2002-09-30 00:00:00 | 2002-12-31 00:00:00 | 2002-09-30 00:00:00 | 1900-01-01 00:00:00 | 2003-03-31 00:00:00 | 2003-03-31 00:00:00 | 2002-12-31 00:00:00 | 1900-01-01 00:00:00 | 2003-06-30 00:00:00 | 2003-06-30 00:00:00 | 2003-12-31 00:00:00 | 2003-09-30 00:00:00 | 2003-09-30 00:00:00 | 2004-06-30 00:00:00 | 2003-12-31 00:00:00 | 2004-06-30 00:00:00 | 2004-03-31 00:00:00 | 2004-04-30 00:00:00 | 2004-09-30 00:00:00 | 2004-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2004-12-31 00:00:00 | 2004-09-30 00:00:00 | 2005-01-31 00:00:00 | 2005-01-31 00:00:00 | 2005-03-31 00:00:00 | 1900-01-01 00:00:00 | 2005-06-30 00:00:00 | 1900-01-01 00:00:00 | 2005-12-31 00:00:00 | 2005-09-30 00:00:00 | 2006-03-31 00:00:00 | 2006-06-30 00:00:00 | 2006-09-30 00:00:00 | 2007-01-02 00:00:00 | 1900-01-01 00:00:00 | 2006-12-31 00:00:00 | 2007-03-31 00:00:00 | 2007-06-30 00:00:00 | 2013-06-30 00:00:00 | 2015-03-31 00:00:00 | 2014-06-30 00:00:00 | 2013-08-31 00:00:00 | 2013-08-31 00:00:00 | 2013-09-30 00:00:00 | 1900-01-01 00:00:00 | 2014-09-30 00:00:00 | 2008-02-13 00:00:00 | 2007-12-31 00:00:00 | 2007-09-30 00:00:00 | 2008-03-31 00:00:00 | 1900-01-01 00:00:00 | 2008-06-30 00:00:00 | 2008-12-29 00:00:00 | 2008-09-30 00:00:00 | 2008-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2009-03-31 00:00:00 | 2009-03-31 00:00:00 | 2009-06-30 00:00:00 | 2008-12-31 00:00:00 | 2009-09-30 00:00:00 | 1900-01-01 00:00:00 | 2011-02-24 00:00:00 | 1900-01-01 00:00:00 | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 2011-06-30 00:00:00 | 2011-12-31 00:00:00 | 2012-03-31 00:00:00 | 2011-03-31 00:00:00 | 2012-06-30 00:00:00 | 2012-03-31 00:00:00 | 2013-12-31 00:00:00 | 2013-12-31 00:00:00 | 2014-12-31 00:00:00 | 2014-12-15 00:00:00 | 2012-09-30 00:00:00 | 2012-12-15 00:00:00 | 1900-01-01 00:00:00 | 2012-12-31 00:00:00 | 2014-03-31 00:00:00 | 2012-09-30 00:00:00 | 2013-03-31 00:00:00 | 2015-09-30 00:00:00 | 2015-06-30 00:00:00 | 2018-09-30 00:00:00 | 1900-01-01 00:00:00 | 2020-03-31 00:00:00 | 2017-12-31 00:00:00 | 2020-06-30 00:00:00 | 2020-03-31 00:00:00 | 2018-12-31 00:00:00 | 2018-12-31 00:00:00 | 2018-03-31 00:00:00 | 2015-12-31 00:00:00 | 2015-12-31 00:00:00 | 2016-03-31 00:00:00 | 2016-06-30 00:00:00 | 2016-09-30 00:00:00 | 2016-12-31 00:00:00 | 2016-12-31 00:00:00 | 2017-03-20 00:00:00 | 1900-01-01 00:00:00 | 2017-06-30 00:00:00 | 2018-06-30 00:00:00 | 2020-12-31 00:00:00 | 2017-09-30 00:00:00 | 2020-06-30 00:00:00 | 2019-03-31 00:00:00 | 2019-12-31 00:00:00 | 2020-03-31 00:00:00 | 2021-03-31 00:00:00 | 2019-09-30 00:00:00 | 2020-12-31 00:00:00 | 2019-06-30 00:00:00 | 2019-12-31 00:00:00 | 2021-06-30 00:00:00 | 1900-01-01 00:00:00 | 2022-03-30 00:00:00 | 2021-12-31 00:00:00 | 2020-09-30 00:00:00 | 2021-09-30 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_type | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 22001 | 22001 | None | 22001 | None | None | 22001 | None | 22001 | 22001 | None | 22001 | None | 22001 | None | None | None | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22001 | 22006 | 22001 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22001 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22001 | 22006 | None | 22006 | 22006 | 22001 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 |
filer_id | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 2001 | 2003 | 1999 | 2013 | 2005 | 2011 | 2007 | 2009 | 2015 | 2019 | 2017 | 2021 | 2023 | |||||||||||||
interest_cd | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | |||||||||||||
effect_date | 2001-01-01 00:00:00 | 2003-01-01 00:00:00 | 1999-05-18 00:00:00 | 2013-01-01 00:00:00 | 2005-01-01 00:00:00 | 2011-02-24 00:00:00 | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2015-01-01 00:00:00 | 2019-01-01 00:00:00 | 2017-01-01 00:00:00 | 2021-01-01 00:00:00 | 2023-01-01 00:00:00 |
filer_id | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||||||||||||||
active | Y | Y | Y | Y | Y | Y | Y | T | Y | Y | Y | Y | Y | N | ||||||||||||||
race | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
session_id | 1999 | 2001 | 2003 | 2005 | 2011 | 2013 | 2007 | 2009 | 2009 | 2017 | 2021 | 2015 | 2019 | 2023 | ||||||||||||||
category | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
category_type | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
sub_category | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
effect_dt | 1999-05-18 00:00:00 | 2001-01-01 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2011-02-24 00:00:00 | 2013-01-01 00:00:00 | 2007-01-01 00:00:00 | 2009-12-31 00:00:00 | 2009-01-01 00:00:00 | 2017-01-01 00:00:00 | 2021-01-01 00:00:00 | 2015-01-01 00:00:00 | 2019-01-01 00:00:00 | 2023-01-01 00:00:00 | ||||||||||||||
sub_category_type | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
election_type | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
sub_category_a | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
nyq_dt | None | None | None | 2000-07-01 00:00:00 | None | None | 2000-07-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 | None | ||||||||||||||
county_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
district_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1146540 | |
---|---|---|
xref_id | C28097 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | C28097 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_type | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | YOLO, COUNTY OF | YOLO, COUNTY OF | YOLO, COUNTY OF | YOLO, COUNTY OF | YOLO, COUNTY OF | YOLO, COUNTY OF | YOLO, COUNTY OF | YOLO, COUNTY OF | YOLO, COUNTY OF | YOLO, COUNTY OF | YOLO, COUNTY OF | YOLO, COUNTY OF | YOLO, COUNTY OF | YOLO, COUNTY OF | YOLO, COUNTY OF | YOLO, COUNTY OF | YOLO, COUNTY OF | YOLO, COUNTY OF | YOLO, COUNTY OF | YOLO, COUNTY OF | YOLO, COUNTY OF | YOLO, COUNTY OF | YOLO, COUNTY OF | YOLO, COUNTY OF | YOLO, COUNTY OF | YOLO, COUNTY OF | YOLO, COUNTY OF | YOLO, COUNTY OF | YOLO, COUNTY OF | YOLO, COUNTY OF | YOLO, COUNTY OF | YOLO, COUNTY OF | YOLO, COUNTY OF | YOLO, COUNTY OF | YOLO, COUNTY OF | YOLO, COUNTY OF | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namf | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | WOODLAND | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | 95695 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 5306668150 | 5306668150 | 5306668150 | 5306668150 | 5306668150 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668150 | 5306668150 | 5306668150 | 5306668150 | 5306668150 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668150 | 5306668150 | 5306668150 | 5306668150 | 5306668150 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668150 | 5306668150 | 5306668150 | 5306668150 | 5306668150 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668150 | 5306668150 | 5306668150 | 5306668150 | 5306668150 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668150 | 5306668150 | 5306668150 | 5306668150 | 5306668150 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668150 | 5306668150 | 5306668150 | 5306668150 | 5306668150 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668150 | 5306668150 | 5306668150 | 5306668150 | 5306668150 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668150 | 5306668150 | 5306668150 | 5306668150 | 5306668150 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668150 | 5306668150 | 5306668150 | 5306668150 | 5306668150 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668150 | 5306668150 | 5306668150 | 5306668150 | 5306668150 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668150 | 5306668150 | 5306668150 | 5306668150 | 5306668150 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | 5306668152 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | None | None | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | None | None | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | None | None | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | None | None | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | None | None | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | None | None | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | None | None | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | None | None | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | None | None | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | None | None | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | None | None | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | None | None | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | 5306684029 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None |
filer_id | 1146540 |
---|
filer_id | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
change_no | 1 | 2 | 3 | 4 | 5 | 0 | 7 | 6 | ||||||||
session_id | 1999 | 1999 | 2001 | 2001 | 2001 | 2001 | 2009 | 2009 | ||||||||
log_dt | 2000-06-29 00:00:00 | 2000-11-08 00:00:00 | 2001-03-19 00:00:00 | 2001-03-21 00:00:00 | 2001-04-09 00:00:00 | 2002-08-20 00:00:00 | 2010-01-27 00:00:00 | 2009-09-22 00:00:00 | ||||||||
filer_type | 1 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | ||||||||
correction_flg | None | None | None | None | None | Y | Y | Y | ||||||||
action | CHANGED | CHANGED | IN SUSPENSE | IN SUSPENSE | IN SUSPENSE | ADDED | DELETED | DELETED | ||||||||
attribute_changed | NAME | NAME | CLIENT | CLIENT | CLIENT | FIRM | FIRM | FIRM | ||||||||
ethics_dt | None | None | None | None | None | None | None | None | ||||||||
interests | None | None | None | None | None | None | None | None | ||||||||
filer_full_name | YOLO, COUNTY OF | YOLO, COUNTY OF | YOLO, COUNTY OF | YOLO, COUNTY OF | YOLO, COUNTY OF | YOLO, COUNTY OF | YOLO; COUNTY OF | YOLO; COUNTY OF | ||||||||
filer_city | None | None | None | Wasco | None | None | None | None | ||||||||
filer_st | None | None | None | CA | None | None | None | None | ||||||||
filer_zip | None | None | None | 93280 | None | None | None | None | ||||||||
filer_phone | None | None | None | 8057583003 | None | None | None | None | ||||||||
entity_type | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | ||||||||
entity_name | None | SHAW/YODER, INC. | SHAW/YODER, INC. | SHAW/YODER, INC. | SHAW/YODER, INC. | NIELSEN, MERKSAMER, PARRINELLO, MUELLER & NAYLOR LLP | CONSERVATION STRATEGY GROUP LLC | SHAW/YODER/ANTWIH, INC. | ||||||||
entity_city | None | None | None | None | None | None | None | None | ||||||||
entity_st | None | None | None | None | None | None | None | None | ||||||||
entity_zip | None | None | None | None | None | None | None | None | ||||||||
entity_phone | None | None | None | None | None | None | None | None | ||||||||
entity_id | 1147267 | 1147267 | 1147267 | 1147267 | 1147267 | 1147313 | 1147461 | 1147267 | ||||||||
responsible_officer | None | None | None | None | None | None | None | None | ||||||||
effect_dt | None | None | None | None | None | 2002-08-20 00:00:00 | 2009-12-31 00:00:00 | 2009-09-15 00:00:00 |
filer_id | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | 1146540 | |||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 676309_0.cal | 716792_0.cal | 744584_0.cal | 771276_0.cal | 790790_0.cal | 811697_0.cal | 839292_0.cal | 855016_0.cal | 881905_0.cal | 910127_0.cal | 930606_0.cal | 331892.cal | 947961_0.cal | 969990_0.cal | 990432_0.cal | 1014356_0.cal | 1029969_0.cal | 1058912_0.cal | 1082108_0.cal | 1103266_0.cal | 1118077_0.cal | 1134230_0.cal | 1146082_0.cal | 1166179_0.cal | 1189889_0.cal | 1330055_0.cal | 1417490_0.cal | 1397899_0.cal | 1351629_0.cal | 1448644_0.cal | 1217043_0.cal | 1238283_0.cal | 1262194_0.cal | 1417490_1.cal | 1433117_0.cal | 1298095_0.cal | 1285471_0.cal | 1377451_0.cal | 1309443_0.cal | |||||||||||||||||||||||||||||||||||||||
received_date | 2000-10-25 00:00:00 | 2001-01-30 00:00:00 | 2001-04-27 00:00:00 | 2001-07-28 00:00:00 | 2001-10-30 00:00:00 | 2002-01-29 00:00:00 | 2002-04-30 00:00:00 | 2002-07-30 00:00:00 | 2002-10-29 00:00:00 | 2003-01-30 00:00:00 | 2003-04-29 00:00:00 | 2003-04-29 00:00:00 | 2003-07-31 00:00:00 | 2003-10-31 00:00:00 | 2004-02-02 00:00:00 | 2004-04-30 00:00:00 | 2004-07-30 00:00:00 | 2004-11-01 00:00:00 | 2005-02-01 00:00:00 | 2005-04-27 00:00:00 | 2005-07-31 00:00:00 | 2005-10-31 00:00:00 | 2006-01-30 00:00:00 | 2006-04-28 00:00:00 | 2006-07-29 00:00:00 | 2008-04-30 00:00:00 | 2009-04-15 00:00:00 | 2009-02-02 00:00:00 | 2008-07-31 00:00:00 | 2009-10-21 00:00:00 | 2006-10-31 00:00:00 | 2007-01-31 00:00:00 | 2007-04-30 00:00:00 | 2009-05-20 00:00:00 | 2009-07-23 00:00:00 | 2007-10-31 00:00:00 | 2007-07-31 00:00:00 | 2008-10-30 00:00:00 | 2008-01-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 | /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 | |||||||||||||||||||||||||||||||||||||||
filing_id | 676309 | 716792 | 744584 | 771276 | 790790 | 811697 | 839292 | 855016 | 881905 | 910127 | 930606 | None | 947961 | 969990 | 990432 | 1014356 | 1029969 | 1058912 | 1082108 | 1103266 | 1118077 | 1134230 | 1146082 | 1166179 | 1189889 | 1330055 | 1417490 | 1397899 | 1351629 | 1448644 | 1217043 | 1238283 | 1262194 | 1417490 | 1433117 | 1298095 | 1285471 | 1377451 | 1309443 | |||||||||||||||||||||||||||||||||||||||
form_id | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | None | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | |||||||||||||||||||||||||||||||||||||||
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 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 |