filer_id | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1106212 | 2047174 | 2080018 | 2061581 | 2113020 | 2160292 | 2203804 | 2410672 | 2263997 | 2465841 | 2339188 | |||||||||||
effect_dt | 1999-01-04 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2004-01-01 00:00:00 | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2017-01-01 00:00:00 | 2013-01-01 00:00:00 | 2019-01-01 00:00:00 | 2015-01-01 00:00:00 | |||||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | |||||||||||
session_id | 1999 | 2003 | 2005 | 2003 | 2007 | 2009 | 2011 | 2017 | 2013 | 2019 | 2015 |
filer_id | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 1999 | 2001 | 2003 | 2007 | 2007 | 2009 | 2005 | 2011 | 2015 | 2013 | 2017 | 2019 | ||||||||||||
ethics_date | 1999-04-16 00:00:00 | 2001-01-18 00:00:00 | 2003-04-24 00:00:00 | 2007-01-18 00:00:00 | 2006-11-10 00:00:00 | 2008-11-12 00:00:00 | 2005-01-12 00:00:00 | 2011-02-24 00:00:00 | 2014-11-13 00:00:00 | 2013-02-28 00:00:00 | 2017-01-12 00:00:00 | 2019-02-07 00:00:00 |
filer_id | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 515490 | 518619 | 512367 | 624275 | 626363 | 611752 | 636066 | 659311 | 677873 | 646933 | 718912 | 706802 | 688569 | 730742 | 746173 | 748509 | 726144 | 790733 | 776578 | 793378 | 772541 | 814000 | 840226 | 816455 | 858072 | 841743 | 898021 | 857094 | 886535 | 885706 | 909761 | 896233 | 920102 | 930228 | 931629 | 911694 | 932289 | 946450 | 950895 | 971682 | 970177 | 980546 | 987796 | 990782 | 1010795 | 1012554 | 1027190 | 1030560 | 1053888 | 1072715 | 1070075 | 1061482 | 1093222 | 1091915 | 1070075 | 1078030 | 1117850 | 1103983 | 1131392 | 1165872 | 1147227 | 1188205 | 1212613 | 1257274 | 1228595 | 1232559 | 1247369 | 1247369 | 1281272 | 1257274 | 1261366 | 1247369 | 1295186 | 1764255 | 1981067 | 1964545 | 1870588 | 1778631 | 1718020 | 1328654 | 1310783 | 1346159 | 1374723 | 1406766 | 1404195 | 1398273 | 1421723 | 1438165 | 1464082 | 1451953 | 1482954 | 1507367 | 1536373 | 1554387 | 1570995 | 1552565 | 1552565 | 1590238 | 1607917 | 1579044 | 1636519 | 1621758 | 1657683 | 1674983 | 1801181 | 1819396 | 1910407 | 1933136 | 1924759 | 1918065 | 1718020 | 1709479 | 1739676 | 1720269 | 1844637 | 1751353 | 1997390 | 2330212 | 2345998 | 2335769 | 2418861 | 2379741 | 2431489 | 2012738 | 2038036 | 2063686 | 2101513 | 2120302 | 2120201 | 2115592 | 2115592 | 2130997 | 2175430 | 2157016 | 2210629 | 2275941 | 2330212 | 2320532 | 2363141 | 2192516 | 2430425 | 2240948 | 2396395 | 2439696 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 158 | 159 | 157 | 161 | 161 | 160 | None | None | 163 | 162 | 164 | None | 163 | None | 165 | 165 | 164 | 167 | None | None | 166 | 168 | 169 | None | None | None | 172 | 170 | None | 171 | 172 | None | None | None | 173 | None | None | 174 | None | None | 175 | None | 176 | None | 177 | None | 178 | None | 179 | None | 180 | None | None | None | 181 | 180 | 182 | 181 | 183 | 185 | 184 | 186 | 187 | None | None | 188 | 189 | 189 | 190 | None | 189 | 190 | 191 | 213 | 222 | 221 | 218 | 214 | 213 | 193 | 192 | 194 | 195 | None | 196 | 196 | 197 | 198 | 200 | 199 | 201 | 202 | 203 | None | 204 | 204 | 206 | 205 | 206 | None | 208 | 207 | 209 | 210 | 215 | 216 | 219 | 220 | None | 220 | 212 | 211 | 212 | None | 217 | None | 223 | 237 | 236 | None | 239 | 237 | 241 | 224 | 225 | 226 | 227 | None | None | 228 | 230 | 228 | 230 | 229 | 232 | 234 | 236 | 235 | None | 231 | None | 233 | 238 | 240 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F615 | F615 | F615 | F615 | F615 | F615 | F999 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F604 | F604 | F615 | F604 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F604 | F604 | F615 | F615 | F604 | F615 | F604 | F615 | F604 | F615 | F604 | F615 | F615 | F606 | F615 | F615 | F615 | F615 | F604 | F604 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F604 | F615 | F606 | 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 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1999-08-02 00:00:00 | 1999-11-01 00:00:00 | 1999-04-30 00:00:00 | 2000-05-01 00:00:00 | 2000-05-01 00:00:00 | 2000-01-31 00:00:00 | 2000-04-25 00:00:00 | 2000-08-02 00:00:00 | 2000-10-26 00:00:00 | 2000-08-03 00:00:00 | 2001-01-31 00:00:00 | 2000-12-27 00:00:00 | 2000-10-27 00:00:00 | 2001-02-14 00:00:00 | 2001-04-30 00:00:00 | 2001-04-30 00:00:00 | 2001-01-31 00:00:00 | 2001-10-30 00:00:00 | 2001-07-31 00:00:00 | 2001-10-31 00:00:00 | 2001-07-31 00:00:00 | 2002-01-31 00:00:00 | 2002-04-30 00:00:00 | 2002-01-31 00:00:00 | 2002-07-31 00:00:00 | 2002-04-30 00:00:00 | 2002-12-27 00:00:00 | 2002-07-31 00:00:00 | 2002-10-31 00:00:00 | 2002-10-31 00:00:00 | 2003-01-30 00:00:00 | 2002-10-28 00:00:00 | 2002-12-27 00:00:00 | 2003-04-24 00:00:00 | 2003-04-30 00:00:00 | 2003-01-30 00:00:00 | 2003-04-30 00:00:00 | 2003-07-30 00:00:00 | 2003-07-30 00:00:00 | 2003-10-31 00:00:00 | 2003-10-31 00:00:00 | 2004-01-08 00:00:00 | 2004-01-28 00:00:00 | 2004-01-29 00:00:00 | 2004-04-23 00:00:00 | 2004-04-26 00:00:00 | 2004-07-28 00:00:00 | 2004-07-28 00:00:00 | 2004-10-26 00:00:00 | 2005-01-05 00:00:00 | 2005-01-05 00:00:00 | 2004-10-27 00:00:00 | 2005-02-18 00:00:00 | 2005-01-28 00:00:00 | 2005-02-18 00:00:00 | 2005-01-28 00:00:00 | 2005-07-31 00:00:00 | 2005-04-29 00:00:00 | 2005-10-27 00:00:00 | 2006-04-27 00:00:00 | 2006-01-30 00:00:00 | 2006-07-27 00:00:00 | 2006-10-26 00:00:00 | 2007-03-09 00:00:00 | 2006-12-20 00:00:00 | 2007-01-26 00:00:00 | 2007-02-22 00:00:00 | 2007-04-11 00:00:00 | 2007-07-26 00:00:00 | 2007-05-30 00:00:00 | 2007-04-30 00:00:00 | 2007-06-07 00:00:00 | 2007-10-26 00:00:00 | 2013-04-29 00:00:00 | 2015-07-30 00:00:00 | 2015-04-29 00:00:00 | 2014-07-30 00:00:00 | 2013-07-26 00:00:00 | 2013-10-25 00:00:00 | 2008-04-29 00:00:00 | 2008-01-31 00:00:00 | 2008-07-25 00:00:00 | 2008-10-29 00:00:00 | 2008-12-30 00:00:00 | 2009-02-27 00:00:00 | 2009-02-02 00:00:00 | 2009-04-30 00:00:00 | 2009-07-31 00:00:00 | 2010-01-31 00:00:00 | 2009-10-30 00:00:00 | 2010-04-27 00:00:00 | 2010-08-02 00:00:00 | 2010-10-27 00:00:00 | 2010-12-22 00:00:00 | 2011-01-31 00:00:00 | 2010-12-21 00:00:00 | 2011-06-01 00:00:00 | 2011-04-29 00:00:00 | 2011-08-01 00:00:00 | 2011-02-24 00:00:00 | 2012-01-31 00:00:00 | 2011-10-30 00:00:00 | 2012-04-30 00:00:00 | 2012-07-26 00:00:00 | 2013-10-31 00:00:00 | 2014-01-31 00:00:00 | 2014-10-30 00:00:00 | 2015-01-29 00:00:00 | 2014-12-23 00:00:00 | 2014-12-12 00:00:00 | 2012-12-18 00:00:00 | 2012-10-31 00:00:00 | 2013-01-31 00:00:00 | 2012-12-20 00:00:00 | 2014-04-30 00:00:00 | 2013-02-28 00:00:00 | 2015-10-30 00:00:00 | 2019-03-18 00:00:00 | 2019-01-30 00:00:00 | 2018-12-28 00:00:00 | 2019-10-31 00:00:00 | 2019-04-30 00:00:00 | 2020-01-17 00:00:00 | 2016-02-01 00:00:00 | 2016-05-02 00:00:00 | 2016-08-01 00:00:00 | 2016-10-31 00:00:00 | 2017-01-12 00:00:00 | 2016-12-30 00:00:00 | 2016-12-30 00:00:00 | 2017-04-25 00:00:00 | 2017-01-31 00:00:00 | 2017-07-31 00:00:00 | 2017-05-01 00:00:00 | 2018-01-31 00:00:00 | 2018-07-31 00:00:00 | 2018-12-28 00:00:00 | 2018-10-31 00:00:00 | 2019-02-14 00:00:00 | 2017-10-30 00:00:00 | 2020-01-10 00:00:00 | 2018-04-30 00:00:00 | 2019-07-30 00:00:00 | 2020-01-30 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10005 | 10001 | 10001 | 10001 | 10005 | 10005 | 10006 | 10001 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10006 | 10005 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10002 | 10001 | 10006 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10002 | 10001 | 10001 | 10006 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10006 | 10001 | 10002 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10006 | 10005 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10006 | 10001 | 10003 | 10001 | 10001 | 10001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 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 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 2001 | 1999 | 2001 | 2001 | 2001 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 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 | 2005 | 2003 | 2005 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2007 | 2005 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2013 | 2015 | 2015 | 2013 | 2013 | 2013 | 2007 | 2007 | 2007 | 2007 | 2009 | 2009 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2013 | 2013 | 2013 | 2015 | 2015 | 2013 | 2011 | 2011 | 2013 | 2013 | 2013 | 2015 | 2019 | 2017 | 2019 | 2019 | 2019 | 2019 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2017 | 2015 | 2017 | 2017 | 2017 | 2017 | 2019 | 2017 | 2019 | 2017 | 2019 | 2017 | 2019 | 2019 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | TTHAM | * | TTHAM | DHORRELL | * | * | * | YBONILLA | SARRIAGA | GPEREZ | * | CFLAGG | MHOANG | * | CFLAGG | YBONILLA | * | * | * | YBONILLA | YBONILLA | YBONILLA | * | * | YBONILLA | * | COMPLETED | DBARRICK | GPEREZ | CFLAGG | COMPLETED | YBONILLA | YBONILLA | COMPLETED | YBONILLA | YBONILLA | COMPLETED | SARRIAGA | COMPLETED | EMCENTEE | COMPLETED | LTHIBAUL | COMPLETED | LTHIBAUL | COMPLETED | CFLAGG | COMPLETED | LTHIBAUL | LTHIBAUL | LTHIBAUL | COMPLETED | COMPLETED | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | CFLAGG | SARRIAGA | LTHIBAUL | * | * | LTHIBAUL | CFLAGG | LTHIBAUL | * | LTHIBAUL | AGLADNEY | JINGRAM | MPACHECO | AGLADNEY | AGLADNEY | CAFILER | LTHIBAUL | LTHIBAUL | LTHIBAUL | JINGRAM | JVAZQUEZ | * | JINGRAM | MGUERRA | MGUERRA | WBROWN | MGUERRA | JINGRAM | ASAETERN | AGLADNEY | PBANFORD | ASAETERN | PBANFORD | * | JINGRAM | ASAETERN | YRODRIGU | ASAETERN | ASAETERN | ASAETERN | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | GKURIMOT | CAFILER | SARRIAGA | ASAETERN | ASAETERN | SARRIAGA | AGLADNEY | SMCCONNAN | JINGRAM | PBANFORD | JFRONEFIELD | GPEREZ | VUKSTINA | VUKSTINA | CAFILER | AGLADNEY | AGLADNEY | AGLADNEY | JINGRAM | PBANFORD | PBANFORD | PBANFORD | GPEREZ | AGLADNEY | SMCCONNAN | JINGRAM | AGLADNEY | JFRONEFIELD | GPEREZ | JFRONEFIELD | PBANFORD | SMCCONNAN | AROJAS | AGLADNEY | VUKSTINA | CAFILER | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11002 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 11001 | 11001 | 11001 | 11003 | 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 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1999-04-01 00:00:00 | 1999-07-01 00:00:00 | 1999-01-01 00:00:00 | 2000-01-01 00:00:00 | 2000-01-01 00:00:00 | 1999-10-01 00:00:00 | None | 2000-04-01 00:00:00 | 2000-07-01 00:00:00 | 2000-04-01 00:00:00 | 2000-10-01 00:00:00 | 1900-01-01 00:00:00 | 2000-07-01 00:00:00 | 1900-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2000-10-01 00:00:00 | 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 | 2002-01-01 00:00:00 | 2001-10-01 00:00:00 | 2002-04-01 00:00:00 | 2002-01-01 00:00:00 | 2002-12-27 00:00:00 | 2002-04-01 00:00:00 | 2002-07-01 00:00:00 | 2002-07-01 00:00:00 | 2002-10-01 00:00:00 | 2002-07-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2003-01-01 00:00:00 | 2002-10-01 00:00:00 | 2003-01-01 00:00:00 | 2003-04-01 00:00:00 | 2003-04-01 00:00:00 | 2003-07-01 00:00:00 | 2003-07-01 00:00:00 | 1900-01-01 00:00:00 | 2003-10-01 00:00:00 | 2003-10-01 00:00:00 | 2004-01-01 00:00:00 | 2004-01-01 00:00:00 | 2004-04-01 00:00:00 | 2004-04-01 00:00:00 | 2004-07-01 00:00:00 | 1900-01-01 00:00:00 | 2004-12-27 00:00:00 | 2004-07-01 00:00:00 | 1900-01-01 00:00:00 | 2004-10-01 00:00:00 | 2005-02-18 00:00:00 | 2004-10-01 00:00:00 | 2005-04-01 00:00:00 | 2005-01-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-07-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2006-10-01 00:00:00 | 2007-02-22 00:00:00 | 2007-02-22 00:00:00 | 2007-04-01 00:00:00 | 1900-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-05-29 00:00:00 | 2007-07-01 00:00:00 | 2013-01-01 00:00:00 | 2015-04-01 00:00:00 | 2015-01-01 00:00:00 | 2014-04-01 00:00:00 | 2013-04-01 00:00:00 | 2013-02-28 00:00:00 | 2008-01-01 00:00:00 | 2007-10-01 00:00:00 | 2008-04-01 00:00:00 | 2008-07-01 00:00:00 | 1900-01-01 00:00:00 | 2008-12-20 00:00:00 | 2008-10-01 00:00:00 | 2009-01-01 00:00:00 | 2009-04-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 | 2010-07-01 00:00:00 | 1900-01-01 00:00:00 | 2010-10-01 00:00:00 | 2010-12-31 00:00:00 | 2011-06-01 00:00:00 | 2011-01-01 00:00:00 | 2011-04-01 00:00:00 | 1900-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-07-01 00:00:00 | 2013-10-01 00:00:00 | 2014-07-01 00:00:00 | 2014-10-01 00:00:00 | 1900-01-01 00:00:00 | 2014-12-12 00:00:00 | 2012-12-31 00:00:00 | 2012-07-01 00:00:00 | 2012-10-01 00:00:00 | 1900-01-01 00:00:00 | 2014-01-01 00:00:00 | 1900-01-01 00:00:00 | 2015-07-01 00:00:00 | 2019-03-18 00:00:00 | 2018-10-01 00:00:00 | 1900-01-01 00:00:00 | 2019-07-01 00:00:00 | 2019-01-01 00:00:00 | 2020-01-17 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 | None | 1900-01-01 00:00:00 | 2016-12-30 00:00:00 | 2017-04-25 00:00:00 | 2016-10-01 00:00:00 | 2017-04-01 00:00:00 | 2017-01-01 00:00:00 | 2017-10-01 00:00:00 | 2018-04-01 00:00:00 | 2018-12-28 00:00:00 | 2018-07-01 00:00:00 | 1900-01-01 00:00:00 | 2017-07-01 00:00:00 | 1900-01-01 00:00:00 | 2018-01-01 00:00:00 | 2019-04-01 00:00:00 | 2019-10-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1999-06-30 00:00:00 | 1999-09-30 00:00:00 | 1999-03-31 00:00:00 | 2000-03-31 00:00:00 | 2000-03-31 00:00:00 | 1999-12-31 00:00:00 | None | 2000-06-30 00:00:00 | 2000-09-30 00:00:00 | 2000-06-30 00:00:00 | 2000-12-31 00:00:00 | 1900-01-01 00:00:00 | 2000-09-30 00:00:00 | 1900-01-01 00:00:00 | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 | 2000-12-31 00:00:00 | 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 | 2002-03-31 00:00:00 | 2001-12-31 00:00:00 | 2002-06-30 00:00:00 | 2002-03-31 00:00:00 | 2002-12-27 00:00:00 | 2002-06-30 00:00:00 | 2002-09-30 00:00:00 | 2002-09-30 00:00:00 | 2002-12-31 00:00:00 | 2002-09-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2003-03-31 00:00:00 | 2002-12-31 00:00:00 | 2003-03-31 00:00:00 | 2003-06-30 00:00:00 | 2003-06-30 00:00:00 | 2003-09-30 00:00:00 | 2003-09-30 00:00:00 | 1900-01-01 00:00:00 | 2003-12-12 00:00:00 | 2003-12-31 00:00:00 | 2004-03-31 00:00:00 | 2004-03-31 00:00:00 | 2004-06-30 00:00:00 | 2004-06-30 00:00:00 | 2004-09-30 00:00:00 | 1900-01-01 00:00:00 | 2004-12-27 00:00:00 | 2004-09-30 00:00:00 | 1900-01-01 00:00:00 | 2004-12-31 00:00:00 | 2005-02-18 00:00:00 | 2004-12-31 00:00:00 | 2005-06-30 00:00:00 | 2005-03-31 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-09-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2006-12-31 00:00:00 | 2007-02-22 00:00:00 | 2007-02-22 00:00:00 | 2007-06-30 00:00:00 | 1900-01-01 00:00:00 | 2007-03-31 00:00:00 | 2007-05-29 00:00:00 | 2007-09-30 00:00:00 | 2013-03-31 00:00:00 | 2015-06-30 00:00:00 | 2015-03-31 00:00:00 | 2014-06-30 00:00:00 | 2013-06-30 00:00:00 | 2013-02-28 00:00:00 | 2008-03-31 00:00:00 | 2007-12-31 00:00:00 | 2008-06-30 00:00:00 | 2008-09-30 00:00:00 | 1900-01-01 00:00:00 | 2008-12-20 00:00:00 | 2008-12-31 00:00:00 | 2009-03-31 00:00:00 | 2009-06-30 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 | 2010-09-30 00:00:00 | 1900-01-01 00:00:00 | 2010-12-31 00:00:00 | 2010-12-31 00:00:00 | 2011-06-01 00:00:00 | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 1900-01-01 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-09-30 00:00:00 | 2013-12-31 00:00:00 | 2014-09-30 00:00:00 | 2014-12-31 00:00:00 | 1900-01-01 00:00:00 | 2014-12-12 00:00:00 | 2012-12-31 00:00:00 | 2012-09-30 00:00:00 | 2012-12-31 00:00:00 | 1900-01-01 00:00:00 | 2014-03-31 00:00:00 | 1900-01-01 00:00:00 | 2015-09-30 00:00:00 | 2019-03-18 00:00:00 | 2018-12-31 00:00:00 | 1900-01-01 00:00:00 | 2019-09-30 00:00:00 | 2019-03-31 00:00:00 | 2020-01-17 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 | None | 1900-01-01 00:00:00 | 2016-12-30 00:00:00 | 2017-04-25 00:00:00 | 2016-12-31 00:00:00 | 2017-06-30 00:00:00 | 2017-03-31 00:00:00 | 2017-12-31 00:00:00 | 2018-06-30 00:00:00 | 2018-12-28 00:00:00 | 2018-09-30 00:00:00 | 1900-01-01 00:00:00 | 2017-09-30 00:00:00 | 1900-01-01 00:00:00 | 2018-03-31 00:00:00 | 2019-06-30 00:00:00 | 2019-12-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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 22001 | None | None | None | 22001 | None | None | 22001 | None | None | 22001 | None | 22001 | None | 22001 | None | 22001 | None | 22001 | None | 22001 | None | None | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22006 | 22006 | 22006 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22001 | 22001 | 22001 | None | 22006 | None | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | None | 22006 | 22006 | 22006 |
filer_id | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | ||||||||||||
active | Y | Y | Y | Y | Y | Y | Y | Y | Y | T | Y | Y | ||||||||||||
race | 0 | 0 | None | None | None | None | None | None | None | None | None | None | ||||||||||||
session_id | 2001 | 1999 | 2003 | 2005 | 2007 | 2011 | 2013 | 2009 | 2015 | 2019 | 2017 | 2019 | ||||||||||||
category | 0 | 0 | None | None | None | None | None | None | None | None | None | None | ||||||||||||
category_type | 0 | 0 | None | None | None | None | None | None | None | None | None | None | ||||||||||||
sub_category | 0 | 0 | None | None | None | None | None | None | None | None | None | None | ||||||||||||
effect_dt | 2001-01-01 00:00:00 | 1999-01-04 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2011-01-01 00:00:00 | 2013-01-01 00:00:00 | 2009-01-01 00:00:00 | 2015-01-01 00:00:00 | 2019-12-30 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | ||||||||||||
sub_category_type | 0 | 0 | None | None | None | None | None | None | None | None | None | None | ||||||||||||
election_type | 0 | 0 | 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 | ||||||||||||
nyq_dt | None | None | None | 2000-01-01 00:00:00 | 2000-01-01 00:00:00 | None | None | None | None | None | None | None | ||||||||||||
party_cd | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||
county_cd | 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 |
filer_id | 1149521 | |
---|---|---|
xref_id | L25741 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | L25741 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
status | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | TERMINATED | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
effect_dt | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | 2019-12-30 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
naml | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | GRELLMANN | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namf | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR | DIETMAR A. | DIETMAR A. | DIETMAR A. | DIETMAR A. | DIETMAR A. | DIETMAR A. | DIETMAR A. | DIETMAR A. | DIETMAR A. | DIETMAR A. | DIETMAR A. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 9164475053 | 9164475053 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164475053 | 9164475053 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164475053 | 9164475053 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164475053 | 9164475053 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164475053 | 9164475053 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164475053 | 9164475053 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164475053 | 9164475053 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164475053 | 9164475053 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164475053 | 9164475053 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164475053 | 9164475053 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | 9164437401 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | 9164477516 | 9164477516 | 9165527596 | 9164477516 | 9164477516 | 9165527596 | 9164477516 | 9164477516 | 9165527596 | 9164477516 | 9164477516 | 9165527596 | 9164477516 | 9164477516 | 9165527596 | 9164477516 | 9164477516 | 9165527596 | 9164477516 | 9164477516 | 9165527596 | 9164477516 | 9164477516 | 9165527596 | 9164477516 | 9164477516 | 9165527596 | 9164477516 | 9164477516 | 9165527596 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
[email protected] | [email protected] | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] |
filer_id | 1149521 |
---|
filer_id | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | |||||
---|---|---|---|---|---|---|---|---|---|---|
change_no | 1 | 2 | 3 | 0 | 4 | |||||
session_id | 1999 | 2001 | 1999 | 2003 | 2003 | |||||
log_dt | 2000-11-09 00:00:00 | 2001-04-05 00:00:00 | 2001-06-04 00:00:00 | 2004-01-08 00:00:00 | 2003-12-12 00:00:00 | |||||
filer_type | 4 | 4 | 4 | 4 | 4 | |||||
correction_flg | None | None | None | Y | Y | |||||
action | SET ACTIVE | IN SUSPENSE | CHANGED | ADDED | DELETED | |||||
attribute_changed | CLIENT | FIRM | None | None | None | |||||
ethics_dt | None | None | None | None | None | |||||
interests | None | None | None | None | None | |||||
filer_full_name | DIETMAR A. GRELLMANN | DIETMAR A. GRELLMANN | DIETMAR A. GRELLMANN | GRELLMANN, DIETMAR A. | GRELLMANN, DIETMAR A. | |||||
filer_city | ALEXANDRIA | SACRAMENTO | SACRAMENTO | None | None | |||||
filer_st | VA | CA | CA | None | None | |||||
filer_zip | 223141917 | 95814 | 95814 | None | None | |||||
filer_phone | 7036838371 | 9164424584 | 9164475053 | None | None | |||||
entity_type | 3 | 3 | 4 | 2 | 3 | |||||
entity_name | NORWOOD & PEDROTTI | NORWOOD & PEDROTTI | None | CALIFORNIA HEALTHCARE ASSOCIATION, ET AL | NORWOOD & ASSOCIATES | |||||
entity_city | None | None | None | None | None | |||||
entity_st | None | None | None | None | None | |||||
entity_zip | None | None | None | None | None | |||||
entity_phone | None | None | None | None | None | |||||
entity_id | 1147391 | 1147391 | 0 | 1146793 | 1147391 | |||||
responsible_officer | None | None | None | None | None | |||||
effect_dt | None | None | None | 2004-01-01 00:00:00 | 2003-12-12 00:00:00 |
filer_id | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | 1149521 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 624275_0.cal | 69.cal | 353.cal | 646933_0.cal | 677873_0.cal | 718912_0.cal | 30471.cal | 30515.cal | 8136.cal | 8776.cal | 746173_0.cal | 772541_0.cal | 790733_0.cal | 814000_0.cal | 840226_0.cal | 857094_0.cal | 898021_0.cal | 885706_0.cal | 909761_0.cal | 931629_0.cal | 946450_0.cal | 970177_0.cal | 987796_0.cal | 1010795_0.cal | 1027190_0.cal | 1053888_0.cal | 1078030_0.cal | 1103983_0.cal | 1117850_0.cal | 1131392_0.cal | 1147227_0.cal | 1165872_0.cal | 134922.cal | 1188205_0.cal | 1212613_0.cal | 1507367_0.cal | 1398273_0.cal | 1346159_0.cal | 1451953_0.cal | 1232559_0.cal | 1247369_0.cal | 1464082_0.cal | 1482954_0.cal | 1295186_0.cal | 1281272_0.cal | 1247369_1.cal | 1247369_2.cal | 1261366_0.cal | 1421723_0.cal | 1438165_0.cal | 1310783_0.cal | 1374723_0.cal | 1404195_0.cal | 1328654_0.cal | 1739676_0.cal | 1552565_0.cal | 1536373_0.cal | 1570995_0.cal | 1607917_0.cal | 1552565_1.cal | 1590238_0.cal | 1778631_0.cal | 1718020_1.cal | 1764255_0.cal | 1636519_0.cal | 1621758_0.cal | 1718020_0.cal | 1709479_0.cal | 1674983_0.cal | 1657683_0.cal | 2115592_1.cal | 2115592_0.cal | 1918065_0.cal | 2330212_1.cal | 2431489_0.cal | 2330212_0.cal | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
received_date | 2000-05-01 00:00:00 | 2000-08-02 00:00:00 | 2000-08-02 00:00:00 | 2000-08-03 00:00:00 | 2000-10-26 00:00:00 | 2001-01-31 00:00:00 | 2001-01-29 00:00:00 | 2001-01-29 00:00:00 | 2001-01-31 00:00:00 | 2001-01-31 00:00:00 | 2001-04-30 00:00:00 | 2001-07-31 00:00:00 | 2001-10-30 00:00:00 | 2002-01-31 00:00:00 | 2002-04-30 00:00:00 | 2002-07-31 00:00:00 | 2002-12-27 00:00:00 | 2002-10-31 00:00:00 | 2003-01-30 00:00:00 | 2003-04-30 00:00:00 | 2003-07-30 00:00:00 | 2003-10-31 00:00:00 | 2004-01-28 00:00:00 | 2004-04-23 00:00:00 | 2004-07-28 00:00:00 | 2004-10-26 00:00:00 | 2005-01-28 00:00:00 | 2005-04-29 00:00:00 | 2005-07-31 00:00:00 | 2005-10-27 00:00:00 | 2006-01-30 00:00:00 | 2006-04-27 00:00:00 | 2006-04-27 00:00:00 | 2006-07-27 00:00:00 | 2006-10-26 00:00:00 | 2010-08-02 00:00:00 | 2009-02-02 00:00:00 | 2008-07-25 00:00:00 | 2009-10-30 00:00:00 | 2007-01-26 00:00:00 | 2007-02-22 00:00:00 | 2010-01-31 00:00:00 | 2010-04-27 00:00:00 | 2007-10-26 00:00:00 | 2007-07-26 00:00:00 | 2007-04-11 00:00:00 | 2007-06-07 00:00:00 | 2007-04-30 00:00:00 | 2009-04-30 00:00:00 | 2009-07-31 00:00:00 | 2008-01-31 00:00:00 | 2008-10-29 00:00:00 | 2009-02-27 00:00:00 | 2008-04-29 00:00:00 | 2013-01-31 00:00:00 | 2010-12-21 00:00:00 | 2010-10-27 00:00:00 | 2011-01-31 00:00:00 | 2011-08-01 00:00:00 | 2011-06-01 00:00:00 | 2011-04-29 00:00:00 | 2013-07-26 00:00:00 | 2013-10-25 00:00:00 | 2013-04-29 00:00:00 | 2012-01-31 00:00:00 | 2011-10-30 00:00:00 | 2012-12-18 00:00:00 | 2012-10-31 00:00:00 | 2012-07-26 00:00:00 | 2012-04-30 00:00:00 | 2017-04-25 00:00:00 | 2016-12-30 00:00:00 | 2014-12-12 00:00:00 | 2019-03-18 00:00:00 | 2020-01-17 00:00:00 | 2018-12-28 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_directory | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_id | 624275 | None | None | 646933 | 677873 | 718912 | None | None | None | None | 746173 | 772541 | 790733 | 814000 | 840226 | 857094 | 898021 | 885706 | 909761 | 931629 | 946450 | 970177 | 987796 | 1010795 | 1027190 | 1053888 | 1078030 | 1103983 | 1117850 | 1131392 | 1147227 | 1165872 | None | 1188205 | 1212613 | 1507367 | 1398273 | 1346159 | 1451953 | 1232559 | 1247369 | 1464082 | 1482954 | 1295186 | 1281272 | 1247369 | 1247369 | 1261366 | 1421723 | 1438165 | 1310783 | 1374723 | 1404195 | 1328654 | 1739676 | 1552565 | 1536373 | 1570995 | 1607917 | 1552565 | 1590238 | 1778631 | 1718020 | 1764255 | 1636519 | 1621758 | 1718020 | 1709479 | 1674983 | 1657683 | 2115592 | 2115592 | 1918065 | 2330212 | 2431489 | 2330212 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F615 | None | None | F615 | F615 | F615 | None | None | None | None | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F615 | None | F615 | F615 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F615 | F604 | F604 | F615 | F615 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F615 | F615 | F615 | F604 | F604 | F604 | F604 | F606 | F604 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
receive_comment | Filing accepted | Filing pass validation, but failed DB constraints | Filing pass validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted, but with warnings | 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 |