acronym | AIA | |
---|---|---|
filer_id | 1142834 |
filer_id | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1110104 | 2044249 | 2078240 | 2119327 | 2149467 | 2162452 | 2205155 | 2409749 | 2397556 | 2470900 | 2270976 | 2226668 | 2339692 | |||||||||||||
effect_dt | 1999-01-01 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2008-07-31 00:00:00 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2017-01-01 00:00:00 | 2016-05-05 00:00:00 | 2019-01-01 00:00:00 | 2013-01-01 00:00:00 | 2011-10-18 00:00:00 | 2015-01-01 00:00:00 | |||||||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | |||||||||||||
session_id | 1999 | 2003 | 2005 | 2007 | 2007 | 2009 | 2011 | 2017 | 2015 | 2019 | 2013 | 2011 | 2015 |
filer_id | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 474449 | 468913 | 477585 | 472038 | 476079 | 465307 | 466713 | 488797 | 497568 | 485180 | 480042 | 493963 | 496135 | 486625 | 470553 | 483101 | 492496 | 470553 | 490281 | 481638 | 624353 | 633578 | 629279 | 637128 | 627050 | 612974 | 659596 | 682375 | 661613 | 711518 | 711832 | 716555 | 689753 | 682375 | 717585 | 737852 | 744801 | 758132 | 791773 | 769623 | 717585 | 744801 | 775874 | 775875 | 778424 | 797488 | 812825 | 839446 | 822079 | 843494 | 861912 | 892075 | 910072 | 856085 | 906643 | 883790 | 906461 | 933004 | 944530 | 931149 | 967483 | 966104 | 953881 | 988392 | 983790 | 1008451 | 1033627 | 1014099 | 1031646 | 1015933 | 1069474 | 1083541 | 1058968 | 1070488 | 1078814 | 1102311 | 1061068 | 1031646 | 1090276 | 1091791 | 1113803 | 1102311 | 1129344 | 1145484 | 1127162 | 1166391 | 1189107 | 983790 | 983790 | 1216077 | 1224653 | 1234955 | 1247800 | 1281118 | 1260237 | 1261557 | 1295994 | 1782087 | 1978778 | 1968976 | 1968780 | 1968976 | 1969644 | 1871074 | 1798085 | 1944356 | 1936753 | 1910127 | 1329415 | 1350084 | 1311115 | 1384759 | 1414317 | 1375339 | 1421181 | 1398418 | 1436095 | 1450085 | 1482980 | 1462224 | 1505064 | 1553654 | 1565340 | 1568004 | 1536630 | 1589064 | 1622564 | 1604642 | 1634576 | 1655027 | 1817007 | 1678736 | 1918956 | 1719019 | 1708768 | 1733852 | 1736744 | 1843850 | 1843850 | 1764399 | 1993879 | 1968976 | 2221848 | 2250384 | 2270955 | 2242781 | 2010347 | 1993879 | 2007815 | 1993879 | 2010347 | 2046135 | 2036362 | 2036362 | 2064286 | 2108809 | 2125796 | 2102217 | 2107897 | 2109883 | 2148610 | 2102217 | 2125796 | 2177487 | 2136347 | 2158103 | 2158103 | 2242781 | 2374458 | 2321377 | 2194459 | 2279659 | 2275039 | 2259099 | 2354008 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 158 | 157 | 151 | 150 | 143 | 141 | 149 | 146 | 156 | 145 | 159 | 155 | 148 | 153 | 142 | 152 | 147 | 142 | 154 | 144 | 161 | None | None | None | None | 160 | 162 | 163 | 162 | 163 | None | None | 163 | 163 | 164 | 164 | 165 | 165 | 167 | 166 | 164 | 165 | None | None | None | None | 168 | 169 | None | None | None | None | None | 170 | 172 | 171 | None | None | 174 | 173 | None | 175 | None | None | 176 | None | None | 177 | 178 | None | 181 | None | 179 | 181 | 180 | 181 | None | 178 | None | None | 182 | 181 | 183 | 184 | None | 185 | 186 | 184 | 184 | 187 | 188 | 188 | None | 190 | None | 189 | 191 | 214 | 222 | 221 | 222 | 221 | None | 218 | 215 | None | 220 | 219 | 193 | 194 | 192 | 197 | None | 195 | 197 | 196 | 198 | 199 | 201 | 200 | 202 | 204 | None | 204 | 203 | 205 | 207 | 206 | 208 | 209 | 216 | 210 | 220 | 212 | 211 | None | 212 | 217 | 217 | 213 | 223 | 221 | 232 | None | 235 | 233 | 224 | 223 | None | 223 | 224 | None | 225 | 225 | 226 | None | 228 | 227 | 228 | None | None | 227 | 228 | 230 | None | 229 | 229 | 233 | None | 235 | 231 | 234 | None | None | 236 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F690 | F635 | F635 | F635 | F635 | F635 | F635 | F690 | F635 | F999 | F602 | F635 | F635 | F635 | F635 | F690 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F690 | F690 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F690 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F603 | F635 | F603 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F602 | F635 | F635 | F605 | F635 | F635 | F635 | F605 | F635 | F635 | F603 | F603 | F605 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F606 | F635 | F635 | F635 | F602 | F602 | F635 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 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 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 2 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1999-08-02 00:00:00 | 1999-04-30 00:00:00 | 1997-10-30 00:00:00 | 1997-07-29 00:00:00 | 1995-10-31 00:00:00 | 1995-05-01 00:00:00 | 1997-04-30 00:00:00 | 1996-07-30 00:00:00 | 1999-01-27 00:00:00 | 1996-04-29 00:00:00 | 1999-10-27 00:00:00 | 1998-10-30 00:00:00 | 1997-01-30 00:00:00 | 1998-04-30 00:00:00 | 1995-08-24 00:00:00 | 1998-02-02 00:00:00 | 1996-10-31 00:00:00 | 1995-07-28 00:00:00 | 1998-07-31 00:00:00 | 1996-01-30 00:00:00 | 2000-05-01 00:00:00 | 2000-04-11 00:00:00 | 2000-05-01 00:00:00 | 2000-05-02 00:00:00 | 2000-02-10 00:00:00 | 2000-01-28 00:00:00 | 2000-07-31 00:00:00 | 2000-10-31 00:00:00 | 2000-07-31 00:00:00 | 2000-11-14 00:00:00 | 2000-12-27 00:00:00 | 2001-01-25 00:00:00 | 2000-10-31 00:00:00 | 2000-11-09 00:00:00 | 2001-01-30 00:00:00 | 2001-01-31 00:00:00 | 2001-04-27 00:00:00 | 2001-04-30 00:00:00 | 2001-10-31 00:00:00 | 2001-07-24 00:00:00 | 2001-07-24 00:00:00 | 2001-07-24 00:00:00 | 2001-07-27 00:00:00 | 2001-07-27 00:00:00 | 2001-07-27 00:00:00 | 2001-10-31 00:00:00 | 2002-01-30 00:00:00 | 2002-04-30 00:00:00 | 2002-01-31 00:00:00 | 2002-04-30 00:00:00 | 2002-07-31 00:00:00 | 2002-10-31 00:00:00 | 2003-01-29 00:00:00 | 2002-07-31 00:00:00 | 2003-01-27 00:00:00 | 2002-10-30 00:00:00 | 2003-01-07 00:00:00 | 2003-04-30 00:00:00 | 2003-07-25 00:00:00 | 2003-04-30 00:00:00 | 2003-10-24 00:00:00 | 2003-10-22 00:00:00 | 2003-07-25 00:00:00 | 2004-01-21 00:00:00 | 2004-01-20 00:00:00 | 2004-04-05 00:00:00 | 2004-08-02 00:00:00 | 2004-04-30 00:00:00 | 2004-08-02 00:00:00 | 2004-04-30 00:00:00 | 2005-01-03 00:00:00 | 2005-01-13 00:00:00 | 2004-11-01 00:00:00 | 2005-01-07 00:00:00 | 2005-01-28 00:00:00 | 2005-04-25 00:00:00 | 2004-11-01 00:00:00 | 2005-02-11 00:00:00 | 2005-01-04 00:00:00 | 2005-01-31 00:00:00 | 2005-07-25 00:00:00 | 2005-09-06 00:00:00 | 2005-10-21 00:00:00 | 2006-01-27 00:00:00 | 2005-02-11 00:00:00 | 2006-04-28 00:00:00 | 2006-07-28 00:00:00 | 2006-08-07 00:00:00 | 2006-08-25 00:00:00 | 2006-10-31 00:00:00 | 2006-12-27 00:00:00 | 2007-01-30 00:00:00 | 2006-12-27 00:00:00 | 2007-07-26 00:00:00 | 2007-04-13 00:00:00 | 2007-04-30 00:00:00 | 2007-10-29 00:00:00 | 2013-07-31 00:00:00 | 2015-07-28 00:00:00 | 2015-07-30 00:00:00 | 2015-05-18 00:00:00 | 2015-05-19 00:00:00 | 2015-05-19 00:00:00 | 2014-07-31 00:00:00 | 2013-10-28 00:00:00 | 2014-12-18 00:00:00 | 2015-02-02 00:00:00 | 2014-10-30 00:00:00 | 2008-04-30 00:00:00 | 2008-07-31 00:00:00 | 2008-01-31 00:00:00 | 2008-12-22 00:00:00 | 2008-12-23 00:00:00 | 2008-10-29 00:00:00 | 2009-04-30 00:00:00 | 2009-02-02 00:00:00 | 2009-07-30 00:00:00 | 2009-10-27 00:00:00 | 2010-04-27 00:00:00 | 2010-01-28 00:00:00 | 2010-07-29 00:00:00 | 2010-12-23 00:00:00 | 2010-12-30 00:00:00 | 2011-01-27 00:00:00 | 2010-10-27 00:00:00 | 2011-04-27 00:00:00 | 2011-10-31 00:00:00 | 2011-07-27 00:00:00 | 2012-01-30 00:00:00 | 2012-04-26 00:00:00 | 2014-01-30 00:00:00 | 2012-07-31 00:00:00 | 2014-12-18 00:00:00 | 2012-12-20 00:00:00 | 2012-10-31 00:00:00 | 2012-12-27 00:00:00 | 2013-01-30 00:00:00 | 2014-04-29 00:00:00 | 2014-05-05 00:00:00 | 2013-04-30 00:00:00 | 2015-10-23 00:00:00 | 2015-05-19 00:00:00 | 2018-03-13 00:00:00 | 2018-05-14 00:00:00 | 2018-07-27 00:00:00 | 2018-10-12 00:00:00 | 2016-01-29 00:00:00 | 2015-10-23 00:00:00 | 2016-01-11 00:00:00 | 2016-01-29 00:00:00 | 2016-01-29 00:00:00 | 2016-05-12 00:00:00 | 2016-04-29 00:00:00 | 2016-07-06 00:00:00 | 2016-08-01 00:00:00 | 2016-11-23 00:00:00 | 2017-01-27 00:00:00 | 2016-10-31 00:00:00 | 2016-11-21 00:00:00 | 2016-11-23 00:00:00 | 2017-03-03 00:00:00 | 2017-02-01 00:00:00 | 2017-02-01 00:00:00 | 2017-07-31 00:00:00 | 2016-12-13 00:00:00 | 2017-05-01 00:00:00 | 2017-08-28 00:00:00 | 2018-04-30 00:00:00 | 2019-02-20 00:00:00 | 2018-11-01 00:00:00 | 2017-10-31 00:00:00 | 2018-08-02 00:00:00 | 2018-07-30 00:00:00 | 2018-06-01 00:00:00 | 2019-02-05 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10001 | 10005 | 10005 | 10005 | 10005 | 10005 | 10002 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10002 | 10002 | 10006 | 10006 | 10005 | 10005 | 10001 | 10001 | 10005 | 10005 | 10005 | 10005 | 10005 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10002 | 10005 | 10005 | 10001 | 10002 | 10001 | 10001 | 10006 | 10001 | 10001 | 10002 | 10002 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10002 | 10001 | 10002 | 10002 | 10001 | 10005 | 10001 | 10002 | 10001 | 10001 | 10005 | 10002 | 10002 | 10006 | 10001 | 10002 | 10001 | 10006 | 10001 | 10001 | 10001 | 10005 | 10005 | 10002 | 10002 | 10001 | 10005 | 10001 | 10002 | 10001 | 10003 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 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 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1999 | 1999 | 1997 | 1997 | 1995 | 1995 | 1997 | 1995 | 1997 | 1995 | 1999 | 1997 | 1995 | 1997 | 1995 | 1997 | 1995 | 1995 | 1997 | 1995 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 2001 | 2001 | 1999 | 1999 | 1999 | 1999 | 2001 | 2001 | 2001 | 2001 | 1999 | 2001 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2005 | 2003 | 2005 | 2003 | 2005 | 2003 | 2003 | 2005 | 2003 | 2005 | 2005 | 2005 | 2005 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2005 | 2007 | 2007 | 2007 | 2007 | 2007 | 2013 | 2015 | 2015 | 2015 | 2015 | 2015 | 2013 | 2013 | 2015 | 2013 | 2013 | 2007 | 2007 | 2007 | 2009 | 2009 | 2007 | 2009 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2011 | 2009 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2011 | 2015 | 2013 | 2011 | 2013 | 2011 | 2013 | 2013 | 2013 | 2015 | 2015 | 2017 | 2017 | 2017 | 2017 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2015 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | TTHAM | TTHAM | TTHAM | SARRIAGA | * | YBONILLA | * | YBONILLA | YBONILLA | GGILMORE | CFLAGG | YBONILLA | * | * | YBONILLA | * | YBONILLA | * | * | * | * | YBONILLA | YBONILLA | DBARRICK | LTHIBAUL | * | * | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | * | COMPLETED | * | SARRIAGA | KVOONG1 | COMPLETED | COMPLETED | LTHIBAUL | COMPLETED | LTHIBAUL | LTHIBAUL | COMPLETED | GPEREZ | EMCENTEE | COMPLETED | COMPLETED | LTHIBAUL | COMPLETED | SARRIAGA | COMPLETED | COMPLETED | COMPLETED | LTHIBAUL | LTHIBAUL | COMPLETED | SARRIAGA | LTHIBAUL | LTHIBAUL | * | LTHIBAUL | LTHIBAUL | GGILMORE | LTHIBAUL | LTHIBAUL | * | * | LTHIBAUL | * | LTHIBAUL | GPEREZ | LTHIBAUL | SARRIAGA | LTHIBAUL | LTHIBAUL | AGLADNEY | AGLADNEY | AGLADNEY | YRODRIGU | MPACHECO | YRODRIGU | AGLADNEY | AGLADNEY | GKURIMOT | MPACHECO | AGLADNEY | LTHIBAUL | YRODRIGU | LTHIBAUL | YRODRIGU | MGUERRA | JGRISSUM | JGRISSUM | JGRISSUM | JGRISSUM | MGUERRA | ASAETERN | JINGRAM | ASAETERN | PBANFORD | PBANFORD | AGLADNEY | ASAETERN | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | YRODRIGU | SARRIAGA | AGLADNEY | SARRIAGA | ASAETERN | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | MPACHECO | AGLADNEY | YRODRIGU | GPEREZ | AGLADNEY | AGLADNEY | AGLADNEY | GPEREZ | AGLADNEY | AGLADNEY | YRODRIGU | AGLADNEY | AGLADNEY | AGLADNEY | YRODRIGU | AGLADNEY | AGLADNEY | YRODRIGU | GPEREZ | SARRIAGA | AGLADNEY | AGLADNEY | AGLADNEY | SARRIAGA | AGLADNEY | AGLADNEY | AGLADNEY | YRODRIGU | AGLADNEY | AGLADNEY | KBANH | GPEREZ | GPEREZ | KBANH | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11002 | 11003 | 11003 | 11003 | 11002 | 11002 | 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 | 11003 | 11003 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 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 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1999-04-01 00:00:00 | 1999-01-01 00:00:00 | 1997-07-01 00:00:00 | 1997-04-01 00:00:00 | 1995-07-01 00:00:00 | 1995-01-01 00:00:00 | 1997-01-01 00:00:00 | 1996-04-01 00:00:00 | 1998-10-01 00:00:00 | 1996-01-01 00:00:00 | 1999-07-01 00:00:00 | 1998-07-01 00:00:00 | 1996-10-01 00:00:00 | 1998-01-01 00:00:00 | 1995-04-01 00:00:00 | 1997-10-01 00:00:00 | 1996-07-01 00:00:00 | 1995-04-01 00:00:00 | 1998-04-01 00:00:00 | 1995-10-01 00:00:00 | 2000-01-01 00:00:00 | 1998-04-01 00:00:00 | 2000-01-01 00:00:00 | None | None | 1999-10-01 00:00:00 | 2000-04-01 00:00:00 | 2000-07-01 00:00:00 | 2000-04-01 00:00:00 | 2000-07-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2000-07-01 00:00:00 | 2000-07-01 00:00:00 | 2000-10-01 00:00:00 | 2000-10-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-07-01 00:00:00 | 2001-04-01 00:00:00 | 2000-10-01 00:00:00 | 2001-01-01 00:00:00 | 2000-10-01 00:00:00 | 2001-01-01 00:00:00 | 2001-04-01 00:00:00 | 2001-07-01 00:00:00 | 2001-10-01 00:00:00 | 2002-01-01 00:00:00 | 2001-10-01 00:00:00 | 2002-01-01 00:00:00 | 2002-04-01 00:00:00 | 2002-07-01 00:00:00 | 2002-10-01 00:00:00 | 2002-04-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-04-01 00:00:00 | 2003-01-01 00:00:00 | 2003-07-01 00:00:00 | 2003-07-01 00:00:00 | 2003-04-01 00:00:00 | 2003-10-01 00:00:00 | 2003-10-01 00:00:00 | 1900-01-01 00:00:00 | 2004-04-01 00:00:00 | 2004-01-01 00:00:00 | 2004-04-01 00:00:00 | 2004-01-01 00:00:00 | 2005-01-03 00:00:00 | 1900-01-01 00:00:00 | 2004-07-01 00:00:00 | 2005-01-06 00:00:00 | 2004-10-01 00:00:00 | 2005-01-01 00:00:00 | 2004-07-01 00:00:00 | 2004-04-01 00:00:00 | 1900-01-01 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 | 2005-10-01 00:00:00 | 2004-04-01 00:00:00 | 2006-01-01 00:00:00 | 2006-04-01 00:00:00 | 2005-10-01 00:00:00 | 2005-10-01 00:00:00 | 2006-07-01 00:00:00 | 2006-12-26 00:00:00 | 2006-10-01 00:00:00 | 1900-01-01 00:00:00 | 2007-04-01 00:00:00 | 1900-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-07-01 00:00:00 | 2013-04-01 00:00:00 | 2015-04-01 00:00:00 | 2015-01-01 00:00:00 | 2015-05-18 00:00:00 | 2015-01-01 00:00:00 | 1900-01-01 00:00:00 | 2014-04-01 00:00:00 | 2013-07-01 00:00:00 | 1900-01-01 00:00:00 | 2014-10-01 00:00:00 | 2014-07-01 00:00:00 | 2008-01-01 00:00:00 | 2008-04-01 00:00:00 | 2007-10-01 00:00:00 | 2009-01-01 00:00:00 | 1900-01-01 00:00:00 | 2008-07-01 00:00:00 | 2009-01-01 00:00:00 | 2008-10-01 00:00:00 | 2009-04-01 00:00:00 | 2009-07-01 00:00:00 | 2010-01-01 00:00:00 | 2009-10-01 00:00:00 | 2010-04-01 00:00:00 | 2010-10-29 00:00:00 | 1900-01-01 00:00:00 | 2010-10-01 00:00:00 | 2010-07-01 00:00:00 | 2011-01-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 | 2013-10-01 00:00:00 | 2012-04-01 00:00:00 | 2014-10-27 00:00:00 | 2012-10-12 00:00:00 | 2012-07-01 00:00:00 | 1900-01-01 00:00:00 | 2012-10-01 00:00:00 | 2014-01-01 00:00:00 | 2014-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-07-01 00:00:00 | 2015-01-01 00:00:00 | 2017-10-01 00:00:00 | 1900-01-01 00:00:00 | 2018-07-24 00:00:00 | 2018-01-01 00:00:00 | 2015-10-01 00:00:00 | 2015-07-01 00:00:00 | 1900-01-01 00:00:00 | 2015-07-01 00:00:00 | 2015-10-01 00:00:00 | 1900-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | 2016-04-01 00:00:00 | 1900-01-01 00:00:00 | 2016-10-01 00:00:00 | 2016-07-01 00:00:00 | 2016-11-21 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2016-07-01 00:00:00 | 2016-10-01 00:00:00 | 2017-04-01 00:00:00 | 1900-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 | 2018-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-07-01 00:00:00 | 2017-07-01 00:00:00 | 2018-04-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-10-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1999-06-30 00:00:00 | 1999-03-31 00:00:00 | 1997-09-30 00:00:00 | 1997-06-30 00:00:00 | 1995-09-30 00:00:00 | 1995-03-31 00:00:00 | 1997-03-31 00:00:00 | 1996-06-30 00:00:00 | 1998-12-31 00:00:00 | 1996-03-31 00:00:00 | 1999-09-30 00:00:00 | 1998-09-30 00:00:00 | 1996-12-31 00:00:00 | 1998-03-31 00:00:00 | 1995-06-30 00:00:00 | 1997-12-31 00:00:00 | 1996-09-30 00:00:00 | 1995-06-30 00:00:00 | 1998-06-30 00:00:00 | 1995-12-31 00:00:00 | 2000-03-31 00:00:00 | 1998-06-30 00:00:00 | 2000-03-31 00:00:00 | None | None | 1999-12-31 00:00:00 | 2000-06-30 00:00:00 | 2000-09-30 00:00:00 | 2000-06-30 00:00:00 | 2000-09-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2000-09-30 00:00:00 | 2000-09-30 00:00:00 | 2000-12-31 00:00:00 | 2000-12-31 00:00:00 | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 | 2001-09-30 00:00:00 | 2001-06-30 00:00:00 | 2000-12-31 00:00:00 | 2001-03-31 00:00:00 | 2000-12-31 00:00:00 | 2001-03-31 00:00:00 | 2001-06-30 00:00:00 | 2001-09-30 00:00:00 | 2001-12-31 00:00:00 | 2002-03-31 00:00:00 | 2001-12-31 00:00:00 | 2002-03-31 00:00:00 | 2002-06-30 00:00:00 | 2002-09-30 00:00:00 | 2002-12-31 00:00:00 | 2002-06-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-06-30 00:00:00 | 2003-03-31 00:00:00 | 2003-09-30 00:00:00 | 2003-09-30 00:00:00 | 2003-06-30 00:00:00 | 2003-12-31 00:00:00 | 2003-12-31 00:00:00 | 1900-01-01 00:00:00 | 2004-06-30 00:00:00 | 2004-03-31 00:00:00 | 2004-06-30 00:00:00 | 2004-03-31 00:00:00 | 2005-01-03 00:00:00 | 1900-01-01 00:00:00 | 2004-09-30 00:00:00 | 2005-01-06 00:00:00 | 2004-12-31 00:00:00 | 2005-03-31 00:00:00 | 2004-09-30 00:00:00 | 2004-06-30 00:00:00 | 1900-01-01 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 | 2005-12-31 00:00:00 | 2004-06-30 00:00:00 | 2006-03-31 00:00:00 | 2006-06-30 00:00:00 | 2005-12-31 00:00:00 | 2005-12-31 00:00:00 | 2006-09-30 00:00:00 | 2006-12-26 00:00:00 | 2006-12-31 00:00:00 | 1900-01-01 00:00:00 | 2007-06-30 00:00:00 | 1900-01-01 00:00:00 | 2007-03-31 00:00:00 | 2007-09-30 00:00:00 | 2013-06-30 00:00:00 | 2015-06-30 00:00:00 | 2015-03-31 00:00:00 | 2015-05-18 00:00:00 | 2015-04-30 00:00:00 | 1900-01-01 00:00:00 | 2014-06-30 00:00:00 | 2013-09-30 00:00:00 | 1900-01-01 00:00:00 | 2014-12-31 00:00:00 | 2014-09-30 00:00:00 | 2008-03-31 00:00:00 | 2008-06-30 00:00:00 | 2007-12-31 00:00:00 | 2009-01-01 00:00:00 | 1900-01-01 00:00:00 | 2008-09-30 00:00:00 | 2009-03-31 00:00:00 | 2008-12-31 00:00:00 | 2009-06-30 00:00:00 | 2009-09-30 00:00:00 | 2010-03-31 00:00:00 | 2009-12-31 00:00:00 | 2010-06-30 00:00:00 | 2010-10-29 00:00:00 | 1900-01-01 00:00:00 | 2010-12-31 00:00:00 | 2010-09-30 00:00:00 | 2011-03-31 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 | 2013-12-31 00:00:00 | 2012-06-30 00:00:00 | 2014-10-27 00:00:00 | 2012-10-12 00:00:00 | 2012-09-30 00:00:00 | 1900-01-01 00:00:00 | 2012-12-31 00:00:00 | 2014-03-31 00:00:00 | 2014-03-31 00:00:00 | 2013-03-31 00:00:00 | 2015-09-30 00:00:00 | 2015-04-30 00:00:00 | 2017-12-31 00:00:00 | 1900-01-01 00:00:00 | 2018-07-24 00:00:00 | 2018-03-31 00:00:00 | 2015-12-31 00:00:00 | 2015-09-30 00:00:00 | 1900-01-01 00:00:00 | 2015-09-30 00:00:00 | 2015-12-31 00:00:00 | 1900-01-01 00:00:00 | 2016-03-31 00:00:00 | 2016-03-31 00:00:00 | 2016-06-30 00:00:00 | 1900-01-01 00:00:00 | 2016-12-31 00:00:00 | 2016-10-31 00:00:00 | 2016-11-21 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2016-09-30 00:00:00 | 2016-12-31 00:00:00 | 2017-06-30 00:00:00 | 1900-01-01 00:00:00 | 2017-03-31 00:00:00 | 2017-03-31 00:00:00 | 2018-03-31 00:00:00 | 1900-01-01 00:00:00 | 2018-09-30 00:00:00 | 2017-09-30 00:00:00 | 2018-06-30 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-12-31 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_type | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 22001 | None | None | None | 22001 | 22001 | None | 22001 | None | None | 22001 | None | None | 22001 | 22001 | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | None | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | None | 22001 | 22001 | 22001 | 22006 | 22006 | 22006 | 22006 | None | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22006 | 22006 | 22006 | None | 22001 | 22006 | 22006 | 22006 | None | 22006 | 22006 | None | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | None | None | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | None | None | 22006 |
filer_id | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 2001 | 2003 | 1999 | 1997 | 1995 | 2009 | 2005 | 2007 | 2011 | 2013 | 2017 | 2019 | 2015 | |||||||||||||
interest_cd | 40304 | 40304 | 40304 | 40304 | 40304 | 40304 | 40304 | 40304 | 40304 | 40304 | 40304 | 40304 | 40304 | |||||||||||||
effect_date | 2001-01-01 00:00:00 | 2003-01-01 00:00:00 | 1999-01-01 00:00:00 | 1997-01-01 00:00:00 | 1995-01-01 00:00:00 | 2009-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 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2015-01-01 00:00:00 |
filer_id | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | ||||||||||||||
active | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | N | Y | ||||||||||||||
race | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
session_id | 1997 | 1999 | 1995 | 2001 | 2003 | 2005 | 2011 | 2013 | 2007 | 2009 | 2015 | 2015 | 2019 | 2017 | ||||||||||||||
category | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
category_type | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
sub_category | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
effect_dt | 1997-01-01 00:00:00 | 1999-01-01 00:00:00 | 1995-01-01 00:00:00 | 2001-01-01 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2011-01-01 00:00:00 | 2013-01-01 00:00:00 | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2015-01-01 00:00:00 | 2015-05-18 00:00:00 | 2019-01-01 00:00:00 | 2017-01-01 00:00:00 | ||||||||||||||
sub_category_type | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
election_type | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
sub_category_a | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||
nyq_dt | None | None | None | None | None | 2000-01-01 00:00:00 | None | None | 2000-01-01 00:00:00 | 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 | 1142834 | |
---|---|---|
xref_id | C00026 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | C00026 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_type | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
effect_dt | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | 2019-01-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
naml | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
city | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 9164427617 | 9164427617 | 9164427616 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427616 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427616 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427616 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427616 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427616 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427616 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427616 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427616 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427616 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427616 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | 9164428178 | 9164413549 | 9164428178 | 9164413549 | 9164428178 | 9164413549 | 9164428178 | 9164413549 | 9164428178 | 9164413549 | 9164428178 | 9164413549 | 9164428178 | 9164413549 | 9164428178 | 9164413549 | 9164428178 | 9164413549 | 9164428178 | 9164413549 | 9164428178 | 9164413549 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] |
filer_id | 1142834 |
---|
filer_id | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
change_no | 1 | 4 | 3 | 5 | 2 | 7 | 0 | 9 | 8 | 10 | 12 | 11 | 13 | 14 | 15 | |||||||||||||||
session_id | 1999 | 1999 | 1999 | 1999 | 1999 | 2001 | 2003 | 2007 | 2007 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | |||||||||||||||
log_dt | 2000-10-20 00:00:00 | 2000-11-28 00:00:00 | 2000-11-28 00:00:00 | 2000-11-28 00:00:00 | 2000-11-28 00:00:00 | 2001-01-25 00:00:00 | 2004-04-05 00:00:00 | 2007-04-13 00:00:00 | 2007-04-27 00:00:00 | 2015-05-19 00:00:00 | 2015-12-16 00:00:00 | 2016-01-11 00:00:00 | 2017-03-03 00:00:00 | 2018-07-30 00:00:00 | 2018-06-01 00:00:00 | |||||||||||||||
filer_type | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | |||||||||||||||
correction_flg | None | None | None | None | None | Y | None | Y | Y | Y | Y | Y | Y | Y | Y | |||||||||||||||
action | SET ACTIVE | SET ACTIVE | SET ACTIVE | SET ACTIVE | SET ACTIVE | ADDED | ADDED | ADDED | DELETED | ADDED | DELETED | ADDED | ADDED | ADDED | ADDED | |||||||||||||||
attribute_changed | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | EMPLOYER | FIRM | FIRM | FIRM | LOBBYIST | FIRM | FIRM | LOBBYIST | FIRM | FIRM | |||||||||||||||
ethics_dt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
interests | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
filer_full_name | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | AMERICAN INSURANCE ASSOCIATION | |||||||||||||||
filer_city | Riverside | Trona | El Segundo | Los Angeles | PASADENA | None | None | SACRAMENTO | None | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | |||||||||||||||
filer_st | CA | CA | CA | CA | CA | None | None | CA | None | CA | CA | CA | CA | CA | CA | |||||||||||||||
filer_zip | 92508 | 93592 | 90245 | 90007 | 91105 | None | None | 95814 | None | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | |||||||||||||||
filer_phone | 9097801788 | 7603722042 | 3104148300 | 2137633346 | 6267950519 | None | None | 9164427617 | None | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | 9164427617 | |||||||||||||||
entity_type | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 3 | 3 | 4 | 3 | 3 | 4 | 3 | 3 | |||||||||||||||
entity_name | HEIM, NOACK, KELLY & SPAHNN | KAHL/POWNALL ADVOCATES | HEIM, NOACK, KELLY & SPAHNN | KAHL/POWNALL ADVOCATES | HEIM, NOACK, KELLY & SPAHNN | ADVOCACY GROUP, THE | NORWOOD & MATTOCH | GREENBERG TRAURIG, LLP | GREENBERG TRAURIG, LLP | SUCHIL, STEVEN | PUBLIC POLICY ADVOCATES, LLC | CAPITOL ADVOCACY, LLC | MERZ, JEREMY | HIESTAND, APC., FRED J. | READ & ASSOCIATES, LLC; AARON | |||||||||||||||
entity_city | None | None | None | None | None | SACRAMENTO | None | None | None | None | None | None | None | None | None | |||||||||||||||
entity_st | None | None | None | None | None | CA | None | None | None | None | None | None | None | None | None | |||||||||||||||
entity_zip | None | None | None | None | None | 95814 | None | None | None | None | None | None | None | None | None | |||||||||||||||
entity_phone | None | None | None | None | None | 9163254080 | None | None | None | None | None | None | None | None | None | |||||||||||||||
entity_id | 1147249 | 1147235 | 1147249 | 1147235 | 1147249 | 1147642 | 1264591 | None | 1276988 | None | None | None | None | None | None | |||||||||||||||
responsible_officer | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
effect_dt | None | None | None | None | None | 2001-01-01 00:00:00 | 2004-04-01 00:00:00 | 2007-02-20 00:00:00 | 2007-04-27 00:00:00 | 2015-05-18 00:00:00 | 2015-12-31 00:00:00 | 2016-01-11 00:00:00 | 2017-02-27 00:00:00 | 2018-07-23 00:00:00 | 2018-05-30 00:00:00 |
filer_id | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_period_start_dt | 2000-01-01 00:00:00 | 2000-01-01 00:00:00 | 2000-01-01 00:00:00 | 2000-01-01 00:00:00 | 2000-01-01 00:00:00 | 2000-01-01 00:00:00 | 2000-01-01 00:00:00 | 2000-01-01 00:00:00 | 2000-01-01 00:00:00 | 2000-01-01 00:00:00 | 2000-01-01 00:00:00 | |||||||||||
filing_period_end_dt | 2000-03-31 00:00:00 | 2000-03-31 00:00:00 | 2000-03-31 00:00:00 | 2000-03-31 00:00:00 | 2000-03-31 00:00:00 | 2000-03-31 00:00:00 | 2000-03-31 00:00:00 | 2000-03-31 00:00:00 | 2000-03-31 00:00:00 | 2000-03-31 00:00:00 | 2000-03-31 00:00:00 | |||||||||||
contribution_dt | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
recipient_name | DAMIAN JONES FOR ASSEMBLY | CORTEZ FOR ASSEMBLY | DAMIAN JONES FOR ASSEMBLY | NATION FOR ASSEMBLY 2000 | SIMON SALINAS FOR ASSEMBLY | VARGAS 2000 | TONY WEST FOR STATE ASSEMBLY | EDWARD VINCENT FOR STATE SENATE | JEROME HORTON FOR ASSEMBLY | TOM MCCLINTOCK FOR SENATE | FRIENDS OF DENNIS CARDOZA | |||||||||||
recipient_id | 1221243 | 1076171 | 1221243 | 1075712 | 1075989 | 1076572 | 1221343 | 1075828 | 1077710 | 1075436 | 1069846 | |||||||||||
amount | 1000 | 1500 | 1500 | 2500 | 500 | 500 | 1000 | 1000 | 1000 | 1000 | 5000 |
filer_id | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_period_start_dt | 2000-01-01 00:00:00 | 2000-01-01 00:00:00 | 2000-01-01 00:00:00 | 2000-01-01 00:00:00 | 2000-01-01 00:00:00 | 2000-01-01 00:00:00 | 2000-01-01 00:00:00 | 2000-01-01 00:00:00 | 2000-01-01 00:00:00 | 2000-01-01 00:00:00 | 2000-01-01 00:00:00 | |||||||||||
filing_period_end_dt | 2000-03-31 00:00:00 | 2000-03-31 00:00:00 | 2000-03-31 00:00:00 | 2000-03-31 00:00:00 | 2000-03-31 00:00:00 | 2000-03-31 00:00:00 | 2000-03-31 00:00:00 | 2000-03-31 00:00:00 | 2000-03-31 00:00:00 | 2000-03-31 00:00:00 | 2000-03-31 00:00:00 | |||||||||||
contribution_dt | None | None | None | None | None | None | None | None | None | None | None | |||||||||||
recipient_name | DAMIAN JONES FOR ASSEMBLY | CORTEZ FOR ASSEMBLY | DAMIAN JONES FOR ASSEMBLY | NATION FOR ASSEMBLY 2000 | SIMON SALINAS FOR ASSEMBLY | VARGAS 2000 | TONY WEST FOR STATE ASSEMBLY | EDWARD VINCENT FOR STATE SENATE | JEROME HORTON FOR ASSEMBLY | TOM MCCLINTOCK FOR SENATE | FRIENDS OF DENNIS CARDOZA | |||||||||||
recipient_id | 1221243 | 1076171 | 1221243 | 1075712 | 1075989 | 1076572 | 1221343 | 1075828 | 1077710 | 1075436 | 1069846 | |||||||||||
amount | 1000 | 1500 | 1500 | 2500 | 500 | 500 | 1000 | 1000 | 1000 | 1000 | 5000 |
filer_id | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | 1142834 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 624353_0.cal | 682375_1.cal | 682375_0.cal | 16084.cal | 744801_0.cal | 717585_0.cal | 199351.cal | 769623_0.cal | 717585_1.cal | 744801_1.cal | 791773_0.cal | 812825_0.cal | 839446_0.cal | 856085_0.cal | 883790_0.cal | 906643_0.cal | 931149_0.cal | 944530_0.cal | 966104_0.cal | 983790_0.cal | 1031646_0.cal | 1014099_0.cal | 1078814_0.cal | 1031646_1.cal | 1102311_0.cal | 1102311_1.cal | 1113803_0.cal | 1129344_0.cal | 1145484_0.cal | 1166391_0.cal | 983790_2.cal | 983790_1.cal | 1189107_0.cal | 65790.cal | 1329415_0.cal | 1505064_0.cal | 1398418_0.cal | 1350084_0.cal | 1462224_0.cal | 1450085_0.cal | 1216077_0.cal | 1234955_0.cal | 1482980_0.cal | 1261557_0.cal | 1281118_0.cal | 1436095_0.cal | 1421181_0.cal | 1295994_0.cal | 1375339_0.cal | 1311115_0.cal | 1843850_1.cal | 1843850_0.cal | 1736744_0.cal | 1678736_0.cal | 1782087_0.cal | 1798085_0.cal | 1536630_0.cal | 1589064_0.cal | 1568004_0.cal | 1817007_0.cal | 1604642_0.cal | 1764399_0.cal | 1622564_0.cal | 1634576_0.cal | 1708768_0.cal | 1655027_0.cal | 290805.cal | 1871074_0.cal | 1910127_0.cal | 1936753_0.cal | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
received_date | 2000-05-01 00:00:00 | 2000-11-09 00:00:00 | 2000-10-31 00:00:00 | 2001-01-30 00:00:00 | 2001-04-27 00:00:00 | 2001-01-30 00:00:00 | 2001-04-25 00:00:00 | 2001-07-24 00:00:00 | 2001-07-24 00:00:00 | 2001-07-24 00:00:00 | 2001-10-31 00:00:00 | 2002-01-30 00:00:00 | 2002-04-30 00:00:00 | 2002-07-31 00:00:00 | 2002-10-30 00:00:00 | 2003-01-27 00:00:00 | 2003-04-30 00:00:00 | 2003-07-25 00:00:00 | 2003-10-22 00:00:00 | 2004-01-20 00:00:00 | 2004-08-02 00:00:00 | 2004-04-30 00:00:00 | 2005-01-28 00:00:00 | 2005-02-11 00:00:00 | 2005-04-25 00:00:00 | 2005-09-06 00:00:00 | 2005-07-25 00:00:00 | 2005-10-21 00:00:00 | 2006-01-27 00:00:00 | 2006-04-28 00:00:00 | 2006-08-25 00:00:00 | 2006-08-07 00:00:00 | 2006-07-28 00:00:00 | 2006-08-07 00:00:00 | 2008-04-30 00:00:00 | 2010-07-29 00:00:00 | 2009-02-02 00:00:00 | 2008-07-31 00:00:00 | 2010-01-28 00:00:00 | 2009-10-27 00:00:00 | 2006-10-31 00:00:00 | 2007-01-30 00:00:00 | 2010-04-27 00:00:00 | 2007-04-30 00:00:00 | 2007-07-26 00:00:00 | 2009-07-30 00:00:00 | 2009-04-30 00:00:00 | 2007-10-29 00:00:00 | 2008-10-29 00:00:00 | 2008-01-31 00:00:00 | 2014-05-05 00:00:00 | 2014-04-29 00:00:00 | 2013-01-30 00:00:00 | 2012-07-31 00:00:00 | 2013-07-31 00:00:00 | 2013-10-28 00:00:00 | 2010-10-27 00:00:00 | 2011-04-27 00:00:00 | 2011-01-27 00:00:00 | 2014-01-30 00:00:00 | 2011-07-27 00:00:00 | 2013-04-30 00:00:00 | 2011-10-31 00:00:00 | 2012-01-30 00:00:00 | 2012-10-31 00:00:00 | 2012-04-26 00:00:00 | 2014-07-31 00:00:00 | 2014-07-31 00:00:00 | 2014-10-30 00:00:00 | 2015-02-02 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/temp | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_id | 624353 | 682375 | 682375 | None | 744801 | 717585 | None | 769623 | 717585 | 744801 | 791773 | 812825 | 839446 | 856085 | 883790 | 906643 | 931149 | 944530 | 966104 | 983790 | 1031646 | 1014099 | 1078814 | 1031646 | 1102311 | 1102311 | 1113803 | 1129344 | 1145484 | 1166391 | 983790 | 983790 | 1189107 | None | 1329415 | 1505064 | 1398418 | 1350084 | 1462224 | 1450085 | 1216077 | 1234955 | 1482980 | 1261557 | 1281118 | 1436095 | 1421181 | 1295994 | 1375339 | 1311115 | 1843850 | 1843850 | 1736744 | 1678736 | 1782087 | 1798085 | 1536630 | 1589064 | 1568004 | 1817007 | 1604642 | 1764399 | 1622564 | 1634576 | 1708768 | 1655027 | None | 1871074 | 1910127 | 1936753 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F635 | F635 | F635 | None | 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 | 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 | F635 | F635 | F635 | F635 | F635 | None | F635 | F635 | F635 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
receive_comment | Filing accepted, but but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing passed validation, but failed DB constraints | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing passed validation, but failed DB constraints | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing 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 passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted |