filer_id | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1108476 | 2043213 | 2078626 | 2163440 | 2115521 | 2208280 | 2545495 | 2416324 | 2278283 | 2510623 | 2350775 | 2472085 | ||||||||||||
effect_dt | 1999-01-01 00:00:00 | 2003-01-01 00:00:00 | 2005-03-16 00:00:00 | 2009-01-01 00:00:00 | 2007-01-01 00:00:00 | 2011-01-01 00:00:00 | 2023-01-01 00:00:00 | 2017-01-01 00:00:00 | 2013-01-01 00:00:00 | 2021-01-01 00:00:00 | 2015-01-01 00:00:00 | 2019-01-01 00:00:00 | ||||||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | ||||||||||||
session_id | 1999 | 2003 | 2005 | 2009 | 2007 | 2011 | 2023 | 2017 | 2013 | 2021 | 2015 | 2019 |
filer_id | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 475708 | 465012 | 471350 | 470197 | 481275 | 476906 | 488428 | 489734 | 479927 | 486046 | 465012 | 540929 | 488428 | 474330 | 484816 | 468792 | 466095 | 488428 | 497059 | 470197 | 484816 | 493444 | 492126 | 495786 | 628146 | 615154 | 642637 | 729231 | 690000 | 724685 | 755578 | 763951 | 781410 | 768798 | 795489 | 811134 | 799720 | 799722 | 799723 | 819501 | 835870 | 863899 | 841093 | 876367 | 889979 | 854792 | 910900 | 910900 | 900290 | 926632 | 926633 | 931134 | 936087 | 967828 | 946887 | 956581 | 966087 | 975962 | 978612 | 1024684 | 1009622 | 997474 | 1008261 | 1021945 | 1044408 | 1071109 | 1064162 | 1098496 | 1093995 | 1098909 | 1111366 | 1127290 | 1140899 | 1182750 | 1161069 | 1203750 | 1226406 | 1251544 | 1255443 | 1243386 | 1303434 | 1276244 | 1292516 | 1774332 | 1980717 | 1863689 | 1809900 | 1793352 | 1944201 | 1954930 | 1895681 | 1303434 | 1323611 | 1342591 | 1363572 | 1383019 | 1391108 | 1391108 | 1408531 | 1417204 | 1447388 | 1457780 | 1429096 | 1479475 | 1479475 | 1500182 | 1523486 | 1552441 | 1557145 | 1559169 | 1585368 | 1585368 | 1599047 | 1627967 | 1617389 | 1670226 | 1651956 | 1697519 | 1918189 | 1920001 | 1716913 | 1723882 | 1725232 | 1836620 | 1755367 | 1992657 | 2005020 | 1968572 | 2202451 | 2393106 | 2187856 | 2036038 | 2062492 | 2100211 | 2125362 | 2125362 | 2155672 | 2139141 | 2116908 | 2162356 | 2168721 | 2333686 | 2266043 | 2440597 | 2523119 | 2336751 | 2477783 | 2566694 | 2324856 | 2232980 | 2339785 | 2414184 | 2202451 | 2393106 | 2459532 | 2373261 | 2468392 | 2643918 | 2578237 | 2620831 | 2670013 | 2547457 | 2702394 | 2593410 | 2738299 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 143 | 141 | 150 | 142 | 144 | 151 | 146 | 154 | 159 | 153 | 141 | 152 | 146 | 158 | 145 | 157 | 149 | 146 | 156 | 142 | 145 | 155 | 147 | 148 | 161 | 160 | 162 | 164 | 163 | None | 165 | 165 | None | 165 | None | 168 | 165 | 166 | 167 | None | 169 | None | None | 171 | None | 170 | 172 | 172 | None | None | None | 173 | None | None | 174 | None | 175 | None | 176 | None | None | None | 177 | 178 | 179 | 180 | None | None | None | 181 | 182 | 183 | 184 | 186 | 185 | 187 | 188 | 189 | 189 | None | 192 | 190 | 191 | 214 | 222 | 218 | 216 | 215 | None | 220 | 219 | 192 | 193 | 194 | 195 | 196 | 196 | 196 | None | 197 | 199 | 200 | 198 | 201 | 201 | 202 | 203 | 204 | None | 204 | 205 | 205 | 206 | 208 | 207 | 210 | 209 | 211 | None | 220 | 212 | None | 212 | 217 | 213 | 223 | 224 | 221 | 232 | 238 | 231 | 225 | 226 | 227 | 228 | 228 | 229 | None | 229 | None | 230 | 237 | 234 | 240 | 243 | 236 | 242 | None | 235 | 233 | None | 239 | 232 | 238 | None | 237 | 241 | 248 | 245 | 247 | 249 | 244 | 250 | 246 | 251 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F690 | F635 | F690 | F635 | F635 | F635 | F635 | F690 | F635 | F690 | F690 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F690 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F690 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F602 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 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 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1995-10-30 00:00:00 | 1995-04-24 00:00:00 | 1997-07-18 00:00:00 | 1995-07-31 00:00:00 | 1996-01-31 00:00:00 | 1997-10-28 00:00:00 | 1996-07-08 00:00:00 | 1998-07-13 00:00:00 | 1999-10-14 00:00:00 | 1998-04-21 00:00:00 | 1995-11-02 00:00:00 | 1998-01-28 00:00:00 | 1996-12-20 00:00:00 | 1999-07-14 00:00:00 | 1996-07-08 00:00:00 | 1999-04-22 00:00:00 | 1997-04-15 00:00:00 | 1996-10-10 00:00:00 | 1999-01-28 00:00:00 | 1996-02-26 00:00:00 | 1996-10-10 00:00:00 | 1998-10-05 00:00:00 | 1996-10-10 00:00:00 | 1997-01-10 00:00:00 | 2000-04-24 00:00:00 | 2000-01-13 00:00:00 | 2000-07-07 00:00:00 | 2001-01-31 00:00:00 | 2000-10-24 00:00:00 | 2000-12-29 00:00:00 | 2001-04-17 00:00:00 | 2001-05-01 00:00:00 | 2001-07-31 00:00:00 | 2001-04-17 00:00:00 | 2001-10-29 00:00:00 | 2002-01-28 00:00:00 | 2001-12-05 00:00:00 | 2001-12-05 00:00:00 | 2001-12-05 00:00:00 | 2002-01-31 00:00:00 | 2002-04-18 00:00:00 | 2002-07-30 00:00:00 | 2002-04-25 00:00:00 | 2002-10-22 00:00:00 | 2002-10-25 00:00:00 | 2002-07-30 00:00:00 | 2003-01-30 00:00:00 | 2003-01-30 00:00:00 | 2002-12-30 00:00:00 | 2003-01-31 00:00:00 | 2003-02-04 00:00:00 | 2003-04-30 00:00:00 | 2003-04-30 00:00:00 | 2003-07-16 00:00:00 | 2003-07-30 00:00:00 | 2003-07-31 00:00:00 | 2003-10-22 00:00:00 | 2003-10-28 00:00:00 | 2004-01-07 00:00:00 | 2004-07-19 00:00:00 | 2004-04-08 00:00:00 | 2004-01-12 00:00:00 | 2004-04-02 00:00:00 | 2004-07-09 00:00:00 | 2004-10-04 00:00:00 | 2005-01-11 00:00:00 | 2004-10-08 00:00:00 | 2005-03-25 00:00:00 | 2005-01-20 00:00:00 | 2005-04-04 00:00:00 | 2005-07-11 00:00:00 | 2005-10-05 00:00:00 | 2006-01-06 00:00:00 | 2006-07-06 00:00:00 | 2006-04-06 00:00:00 | 2006-10-04 00:00:00 | 2007-01-03 00:00:00 | 2007-03-09 00:00:00 | 2007-04-06 00:00:00 | 2006-10-31 00:00:00 | 2008-01-14 00:00:00 | 2007-07-05 00:00:00 | 2007-10-11 00:00:00 | 2013-07-09 00:00:00 | 2015-07-30 00:00:00 | 2014-07-17 00:00:00 | 2014-01-14 00:00:00 | 2013-10-10 00:00:00 | 2014-12-30 00:00:00 | 2015-03-26 00:00:00 | 2014-10-09 00:00:00 | 2008-03-05 00:00:00 | 2008-04-08 00:00:00 | 2008-07-10 00:00:00 | 2008-10-07 00:00:00 | 2008-12-08 00:00:00 | 2009-01-22 00:00:00 | 2009-01-22 00:00:00 | 2008-12-31 00:00:00 | 2009-04-14 00:00:00 | 2009-10-09 00:00:00 | 2010-01-13 00:00:00 | 2009-07-07 00:00:00 | 2010-04-29 00:00:00 | 2010-04-13 00:00:00 | 2010-07-13 00:00:00 | 2010-10-06 00:00:00 | 2010-12-21 00:00:00 | 2010-12-22 00:00:00 | 2011-01-12 00:00:00 | 2011-06-16 00:00:00 | 2011-04-07 00:00:00 | 2011-07-07 00:00:00 | 2012-01-11 00:00:00 | 2011-10-13 00:00:00 | 2012-07-09 00:00:00 | 2012-04-13 00:00:00 | 2012-10-11 00:00:00 | 2014-11-25 00:00:00 | 2014-12-22 00:00:00 | 2012-12-12 00:00:00 | 2012-12-14 00:00:00 | 2013-01-14 00:00:00 | 2014-04-08 00:00:00 | 2013-04-09 00:00:00 | 2015-10-20 00:00:00 | 2016-01-20 00:00:00 | 2015-05-15 00:00:00 | 2018-04-19 00:00:00 | 2019-07-25 00:00:00 | 2017-10-16 00:00:00 | 2016-04-29 00:00:00 | 2016-07-29 00:00:00 | 2016-10-29 00:00:00 | 2017-01-27 00:00:00 | 2017-04-27 00:00:00 | 2017-04-28 00:00:00 | 2016-12-29 00:00:00 | 2017-01-03 00:00:00 | 2017-06-02 00:00:00 | 2017-07-19 00:00:00 | 2019-01-10 00:00:00 | 2018-07-18 00:00:00 | 2020-01-30 00:00:00 | 2020-10-26 00:00:00 | 2019-01-22 00:00:00 | 2020-07-12 00:00:00 | 2020-12-30 00:00:00 | 2018-11-07 00:00:00 | 2018-04-19 00:00:00 | 2018-12-21 00:00:00 | 2019-10-22 00:00:00 | 2018-01-17 00:00:00 | 2019-07-26 00:00:00 | 2020-02-27 00:00:00 | 2019-04-16 00:00:00 | 2020-04-28 00:00:00 | 2022-01-31 00:00:00 | 2021-04-28 00:00:00 | 2021-10-27 00:00:00 | 2022-04-25 00:00:00 | 2021-01-26 00:00:00 | 2022-07-27 00:00:00 | 2021-07-15 00:00:00 | 2022-10-21 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 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10006 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10002 | 10005 | 10005 | 10006 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10005 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1995 | 1995 | 1997 | 1995 | 1995 | 1997 | 1995 | 1997 | 1999 | 1997 | 1995 | 1997 | 1995 | 1999 | 1995 | 1999 | 1997 | 1995 | 1997 | 1995 | 1995 | 1997 | 1995 | 1995 | 1999 | 1999 | 1999 | 1999 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2001 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2013 | 2015 | 2013 | 2013 | 2013 | 2015 | 2013 | 2013 | 2007 | 2007 | 2007 | 2007 | 2009 | 2007 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2011 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2015 | 2013 | 2013 | 2011 | 2013 | 2013 | 2015 | 2015 | 2015 | 2017 | 2019 | 2017 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2017 | 2019 | 2019 | 2017 | 2019 | 2021 | 2017 | 2017 | 2019 | 2019 | 2017 | 2019 | 2019 | 2019 | 2019 | 2021 | 2021 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | TTHAM | CFLAGG | DHULSE | YBONILLA | YBONILLA | PBANFORD | LTHIBAUL | YBONILLA | LTHIBAUL | MHOANG | LTHIBAUL | * | GGILMORE | GGILMORE | GGILMORE | DHORRELL | * | GGILMORE | LTHIBAUL | * | LTHIBAUL | * | COMPLETED | COMPLETED | PBANFORD | LTHIBAUL | LTHIBAUL | COMPLETED | LTHIBAUL | KLARRY | COMPLETED | LTHIBAUL | COMPLETED | LTHIBAUL | COMPLETED | YBONILLA | LTHIBAUL | LTHIBAUL | COMPLETED | COMPLETED | COMPLETED | COMPLETED | LTHIBAUL | SARRIAGA | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | GPEREZ | LTHIBAUL | CFLAGG | LTHIBAUL | LTHIBAUL | LTHIBAUL | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | PBANFORD | RGEREMIA | AGLADNEY | LTHIBAUL | LTHIBAUL | LTHIBAUL | JINGRAM | GPEREZ | JINGRAM | JINGRAM | SARRIAGA | MGUERRA | MGUERRA | JINGRAM | MGUERRA | ASAETERN | ASAETERN | ASAETERN | ASAETERN | YRODRIGU | YRODRIGU | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | ASAETERN | AGLADNEY | AGLADNEY | YRODRIGU | PBANFORD | YRODRIGU | GPEREZ | ASAETERN | AGLADNEY | ASAETERN | AGLADNEY | AGLADNEY | RGEREMIA | AGLADNEY | SUSHAKOV | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | SARRIAGA | SARRIAGA | GPEREZ | AGLADNEY | YRODRIGU | AGLADNEY | GTAYLOR | GTAYLOR | AGLADNEY | VUKSTINA | MMERCHANT | KBANH | AGLADNEY | YRODRIGU | VUKSTINA | AGLADNEY | SUSHAKOV | GPEREZ | VUKSTINA | VUKSTINA | RATTIYEH | GTAYLOR | GTAYLOR | CAFILER | GTAYLOR | CAFILER | GTAYLOR | CAFILER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11002 | 11003 | 11002 | 11002 | 11003 | 11002 | 11003 | 11003 | 11003 | 11003 | 11002 | 11002 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 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 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1995-07-01 00:00:00 | 1995-01-01 00:00:00 | 1997-04-01 00:00:00 | 1995-04-01 00:00:00 | 1995-10-01 00:00:00 | 1997-07-01 00:00:00 | 1996-04-01 00:00:00 | 1998-04-01 00:00:00 | 1999-07-01 00:00:00 | 1998-01-01 00:00:00 | 1995-01-01 00:00:00 | 1997-10-01 00:00:00 | 1996-04-01 00:00:00 | 1999-04-01 00:00:00 | 1996-01-01 00:00:00 | 1999-01-01 00:00:00 | 1997-01-01 00:00:00 | 1996-04-01 00:00:00 | 1998-10-01 00:00:00 | 1995-04-01 00:00:00 | 1996-01-01 00:00:00 | 1998-07-01 00:00:00 | 1996-07-01 00:00:00 | 1996-10-01 00:00:00 | 2000-01-01 00:00:00 | 1999-10-01 00:00:00 | 2000-04-01 00:00:00 | 2000-10-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 | 2001-04-01 00:00:00 | None | 2001-07-01 00:00:00 | 2001-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 | 2002-04-01 00:00:00 | 2002-01-01 00:00:00 | 2002-07-01 00:00:00 | 2002-07-01 00:00:00 | 2002-04-01 00:00:00 | 2002-10-01 00:00:00 | 2002-10-01 00:00:00 | 1900-01-01 00:00:00 | 2002-10-01 00:00:00 | 2002-10-01 00:00:00 | 2003-01-01 00:00:00 | 2003-01-01 00:00:00 | 2002-10-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 | 2003-10-01 00:00:00 | 2004-04-01 00:00:00 | 2004-01-01 00:00:00 | 2003-10-01 00:00:00 | 2004-01-01 00:00:00 | 2004-04-01 00:00:00 | 2004-07-01 00:00:00 | 2004-10-01 00:00:00 | 2004-07-01 00:00:00 | 1900-01-01 00:00:00 | 2004-10-01 00:00:00 | 2005-01-01 00:00:00 | 2005-04-01 00:00:00 | 2005-07-01 00:00:00 | 2005-10-01 00:00:00 | 2006-04-01 00:00:00 | 2006-01-01 00:00:00 | 2006-07-01 00:00:00 | 2006-10-01 00:00:00 | 2007-03-09 00:00:00 | 2007-01-01 00:00:00 | 1900-01-01 00:00:00 | 2007-10-01 00:00:00 | 2007-04-01 00:00:00 | 2007-07-01 00:00:00 | 2013-04-01 00:00:00 | 2015-04-01 00:00:00 | 2014-04-01 00:00:00 | 2013-10-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 | 2007-10-01 00:00:00 | 2008-01-01 00:00:00 | 2008-04-01 00:00:00 | 2008-07-01 00:00:00 | 2008-12-08 00:00:00 | 2008-10-01 00:00:00 | 2008-10-01 00:00:00 | 1900-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-07-01 00:00:00 | 2009-10-01 00:00:00 | 2009-04-01 00:00:00 | 2010-01-01 00:00:00 | 2010-01-01 00:00:00 | 2010-04-01 00:00:00 | 2010-07-01 00:00:00 | 2010-12-21 00:00:00 | 1900-01-01 00:00:00 | 2010-10-01 00:00:00 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00 | 2011-04-01 00:00:00 | 2011-10-01 00:00:00 | 2011-07-01 00:00:00 | 2012-04-01 00:00:00 | 2012-01-01 00:00:00 | 2012-07-01 00:00:00 | 1900-01-01 00:00:00 | 2014-12-22 00:00:00 | 2012-12-12 00:00:00 | 1900-01-01 00:00:00 | 2012-10-31 00:00:00 | 2014-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-07-01 00:00:00 | 2015-10-01 00:00:00 | 2015-01-01 00:00:00 | 2017-10-01 00:00:00 | 2019-04-01 00:00:00 | 2017-07-01 00:00:00 | 2016-01-01 00:00:00 | 2016-04-01 00:00:00 | 2016-07-01 00:00:00 | 2016-10-01 00:00:00 | 2016-10-01 00:00:00 | 2017-01-01 00:00:00 | 1900-01-01 00:00:00 | 2017-01-03 00:00:00 | 1900-01-01 00:00:00 | 2017-04-01 00:00:00 | 2019-01-10 00:00:00 | 2018-04-01 00:00:00 | 2019-10-01 00:00:00 | 2020-07-01 00:00:00 | 2018-10-01 00:00:00 | 2020-04-01 00:00:00 | 1900-01-01 00:00:00 | 2018-07-01 00:00:00 | 2018-01-01 00:00:00 | 1900-01-01 00:00:00 | 2019-07-01 00:00:00 | 2017-10-01 00:00:00 | 2019-04-01 00:00:00 | 1900-01-01 00:00:00 | 2019-01-01 00:00:00 | 2020-01-01 00:00:00 | 2021-10-01 00:00:00 | 2021-01-01 00:00:00 | 2021-07-01 00:00:00 | 2022-01-01 00:00:00 | 2020-10-01 00:00:00 | 2022-04-01 00:00:00 | 2021-04-01 00:00:00 | 2022-07-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1995-09-30 00:00:00 | 1995-03-31 00:00:00 | 1997-06-30 00:00:00 | 1995-06-30 00:00:00 | 1995-12-31 00:00:00 | 1997-09-30 00:00:00 | 1996-06-30 00:00:00 | 1998-06-30 00:00:00 | 1999-09-30 00:00:00 | 1998-03-31 00:00:00 | 1995-03-31 00:00:00 | 1997-12-31 00:00:00 | 1996-06-30 00:00:00 | 1999-06-30 00:00:00 | 1996-03-31 00:00:00 | 1999-03-31 00:00:00 | 1997-03-31 00:00:00 | 1996-06-30 00:00:00 | 1998-12-31 00:00:00 | 1995-06-30 00:00:00 | 1996-03-31 00:00:00 | 1998-09-30 00:00:00 | 1996-09-30 00:00:00 | 1996-12-31 00:00:00 | 2000-03-31 00:00:00 | 1999-12-31 00:00:00 | 2000-06-30 00:00:00 | 2000-12-31 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 | 2001-06-30 00:00:00 | None | 2001-09-30 00:00:00 | 2001-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 | 2002-06-30 00:00:00 | 2002-03-31 00:00:00 | 2002-09-30 00:00:00 | 2002-09-30 00:00:00 | 2002-06-30 00:00:00 | 2002-12-31 00:00:00 | 2002-12-31 00:00:00 | 1900-01-01 00:00:00 | 2002-12-31 00:00:00 | 2002-12-31 00:00:00 | 2003-03-31 00:00:00 | 2003-03-31 00:00:00 | 2002-12-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 | 2003-12-31 00:00:00 | 2004-06-30 00:00:00 | 2004-03-31 00:00:00 | 2003-12-31 00:00:00 | 2004-03-31 00:00:00 | 2004-06-30 00:00:00 | 2004-09-30 00:00:00 | 2004-12-31 00:00:00 | 2004-09-30 00:00:00 | 1900-01-01 00:00:00 | 2004-12-31 00:00:00 | 2005-03-31 00:00:00 | 2005-06-30 00:00:00 | 2005-09-30 00:00:00 | 2005-12-31 00:00:00 | 2006-06-30 00:00:00 | 2006-03-31 00:00:00 | 2006-09-30 00:00:00 | 2006-12-31 00:00:00 | 2007-03-09 00:00:00 | 2007-03-31 00:00:00 | 1900-01-01 00:00:00 | 2007-12-31 00:00:00 | 2007-06-30 00:00:00 | 2007-09-30 00:00:00 | 2013-06-30 00:00:00 | 2015-06-30 00:00:00 | 2014-06-30 00:00:00 | 2013-12-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 | 2007-12-31 00:00:00 | 2008-03-31 00:00:00 | 2008-06-30 00:00:00 | 2008-09-30 00:00:00 | 2008-12-08 00:00:00 | 2008-12-31 00:00:00 | 2008-12-31 00:00:00 | 1900-01-01 00:00:00 | 2009-03-31 00:00:00 | 2009-09-30 00:00:00 | 2009-12-31 00:00:00 | 2009-06-30 00:00:00 | 2010-03-31 00:00:00 | 2010-03-31 00:00:00 | 2010-06-30 00:00:00 | 2010-09-30 00:00:00 | 2010-12-21 00:00:00 | 1900-01-01 00:00:00 | 2010-12-31 00:00:00 | 2011-03-31 00:00:00 | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 2011-12-31 00:00:00 | 2011-09-30 00:00:00 | 2012-06-30 00:00:00 | 2012-03-31 00:00:00 | 2012-09-30 00:00:00 | 1900-01-01 00:00:00 | 2014-12-22 00:00:00 | 2012-12-12 00:00:00 | 1900-01-01 00:00:00 | 2012-12-31 00:00:00 | 2014-03-31 00:00:00 | 2013-03-31 00:00:00 | 2015-09-30 00:00:00 | 2015-12-31 00:00:00 | 2015-03-31 00:00:00 | 2017-12-31 00:00:00 | 2019-06-30 00:00:00 | 2017-09-30 00:00:00 | 2016-03-31 00:00:00 | 2016-06-30 00:00:00 | 2016-09-30 00:00:00 | 2016-12-31 00:00:00 | 2016-12-31 00:00:00 | 2017-03-31 00:00:00 | 1900-01-01 00:00:00 | 2017-01-03 00:00:00 | 1900-01-01 00:00:00 | 2017-06-30 00:00:00 | 2019-01-10 00:00:00 | 2018-06-30 00:00:00 | 2019-12-31 00:00:00 | 2020-09-30 00:00:00 | 2018-12-31 00:00:00 | 2020-06-30 00:00:00 | 1900-01-01 00:00:00 | 2018-09-30 00:00:00 | 2018-03-31 00:00:00 | 1900-01-01 00:00:00 | 2019-09-30 00:00:00 | 2017-12-31 00:00:00 | 2019-06-30 00:00:00 | 1900-01-01 00:00:00 | 2019-03-31 00:00:00 | 2020-03-31 00:00:00 | 2021-12-31 00:00:00 | 2021-03-31 00:00:00 | 2021-09-30 00:00:00 | 2022-03-31 00:00:00 | 2020-12-31 00:00:00 | 2022-06-30 00:00:00 | 2021-06-30 00:00:00 | 2022-09-30 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 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 | 22001 | 22001 | None | None | None | 22001 | None | None | 22001 | None | 22001 | None | 22001 | None | None | None | 22006 | 22006 | 22006 | 22006 | None | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22001 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22001 | 22001 | 22001 | 22006 | 22006 | 22006 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | None | 22006 | 22001 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | None | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 |
filer_id | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 2001 | 1999 | 1995 | 1997 | 2003 | 2009 | 2013 | 2005 | 2007 | 2011 | 2017 | 2015 | 2019 | 2021 | 2023 | |||||||||||||||
interest_cd | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | 40305 | |||||||||||||||
effect_date | 2001-01-01 00:00:00 | 1999-01-01 00:00:00 | 1994-12-05 00:00:00 | 1997-01-01 00:00:00 | 2003-01-01 00:00:00 | 2009-01-01 00:00:00 | 2013-01-01 00:00:00 | 2005-03-16 00:00:00 | 2007-01-01 00:00:00 | 2011-01-01 00:00:00 | 2017-01-01 00:00:00 | 2015-01-01 00:00:00 | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | 2023-01-01 00:00:00 |
filer_id | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||||||||||||||
active | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | N | |||||||||||||||
race | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
session_id | 1997 | 1995 | 1999 | 2001 | 2003 | 2005 | 2007 | 2011 | 2013 | 2009 | 2017 | 2019 | 2015 | 2021 | 2023 | |||||||||||||||
category | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
category_type | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
sub_category | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
effect_dt | 1997-01-01 00:00:00 | 1994-12-05 00:00:00 | 1999-01-01 00:00:00 | 2001-01-01 00:00:00 | 2003-01-01 00:00:00 | 2005-03-16 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 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2015-01-01 00:00:00 | 2021-01-01 00:00:00 | 2023-01-01 00:00:00 | |||||||||||||||
sub_category_type | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
election_type | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
sub_category_a | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
nyq_dt | None | None | None | None | None | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | None | None | None | None | None | None | None | None | |||||||||||||||
party_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
county_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
district_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1143790 | |
---|---|---|
xref_id | C24613 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | C24613 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_type | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | CLIENT | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
status | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
effect_dt | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
naml | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO, CITY OF | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namf | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
namt | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
adr1 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
adr2 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
city | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | CORONADO | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
zip4 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | 92118 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227300 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227300 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227300 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227300 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227300 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227300 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227300 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227300 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227300 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227300 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227300 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227300 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227335 | 6195227300 | 6195227335 | 6195227335 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | 6195227846 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
[email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None | [email protected] | [email protected] | None | None | None | None | None | None | None | None | None | None |
filer_id | 1143790 |
---|
filer_id | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
change_no | 1 | 0 | 2 | 3 | 4 | 5 | ||||||
session_id | 2001 | 2005 | 2013 | 2017 | 2017 | 2019 | ||||||
log_dt | 2001-03-26 00:00:00 | 2005-03-25 00:00:00 | 2014-10-27 00:00:00 | 2017-06-01 00:00:00 | 2017-06-02 00:00:00 | 2019-12-16 00:00:00 | ||||||
filer_type | 1 | 1 | 1 | 1 | 1 | 1 | ||||||
correction_flg | None | Y | None | None | Y | None | ||||||
action | IN SUSPENSE | ADDED | DELETED | DELETED | ADDED | DELETED | ||||||
attribute_changed | CLIENT | None | FIRM | FIRM | FIRM | FIRM | ||||||
ethics_dt | None | None | None | None | None | None | ||||||
interests | None | None | None | None | None | None | ||||||
filer_full_name | CORONADO, CITY OF | CORONADO, CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | CORONADO; CITY OF | ||||||
filer_city | DANA POINT | None | None | None | CORONADO | None | ||||||
filer_st | CA | None | None | None | CA | None | ||||||
filer_zip | 92829 | None | None | None | 92118 | None | ||||||
filer_phone | 9494888800 | None | None | None | 6195227335 | None | ||||||
entity_type | 3 | 3 | 3 | 3 | 3 | 3 | ||||||
entity_name | WOOLLEY GROUP, THE | CARPI & CLAY INC. | CARPI & CLAY, INC. | JGC GOVERNMENT RELATIONS, INC. | CAPITOL ADVOCACY, LLC | CAPITOL ADVOCACY, LLC | ||||||
entity_city | None | None | None | None | None | None | ||||||
entity_st | None | None | None | None | None | None | ||||||
entity_zip | None | None | None | None | None | None | ||||||
entity_phone | None | None | None | None | None | None | ||||||
entity_id | 1147445 | 1147222 | 1147222 | 1369200 | None | 1147785 | ||||||
responsible_officer | None | None | None | None | None | None | ||||||
effect_dt | None | 2005-03-16 00:00:00 | 2014-10-01 00:00:00 | 2017-05-31 00:00:00 | 2017-06-01 00:00:00 | 2019-12-04 00:00:00 |
filer_id | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | 1143790 | |||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 799720_0.cal | 799722_0.cal | 799723_0.cal | 811134_0.cal | 134193.cal | 134888.cal | 134947.cal | 835870_0.cal | 222791.cal | 223088.cal | 223183.cal | 223250.cal | 226192.cal | 226142.cal | 854792_0.cal | 229537.cal | 876367_0.cal | 910900_0.cal | 910900_1.cal | 931134_0.cal | 946887_0.cal | 966087_0.cal | 978612_0.cal | 1968572_0.cal | 1980717_0.cal | 2005020_0.cal | 1992657_0.cal | |||||||||||||||||||||||||||
received_date | 2001-12-05 00:00:00 | 2001-12-05 00:00:00 | 2001-12-05 00:00:00 | 2002-01-28 00:00:00 | 2002-04-18 00:00:00 | 2002-04-18 00:00:00 | 2002-04-18 00:00:00 | 2002-04-18 00:00:00 | 2002-07-30 00:00:00 | 2002-07-30 00:00:00 | 2002-07-30 00:00:00 | 2002-07-30 00:00:00 | 2002-07-30 00:00:00 | 2002-07-30 00:00:00 | 2002-07-30 00:00:00 | 2002-07-30 00:00:00 | 2002-10-22 00:00:00 | 2003-01-30 00:00:00 | 2003-01-30 00:00:00 | 2003-04-30 00:00:00 | 2003-07-30 00:00:00 | 2003-10-22 00:00:00 | 2004-01-07 00:00:00 | 2015-05-15 00:00:00 | 2015-07-30 00:00:00 | 2016-01-20 00:00:00 | 2015-10-20 00:00:00 | |||||||||||||||||||||||||||
filing_directory | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /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 | |||||||||||||||||||||||||||
filing_id | 799720 | 799722 | 799723 | 811134 | None | None | None | 835870 | None | None | None | None | None | None | 854792 | None | 876367 | 910900 | 910900 | 931134 | 946887 | 966087 | 978612 | 1968572 | 1980717 | 2005020 | 1992657 | |||||||||||||||||||||||||||
form_id | F635 | F635 | F635 | F635 | None | None | None | F635 | None | None | None | None | None | None | F635 | None | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | |||||||||||||||||||||||||||
receive_comment | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing accepted | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing did not pass validation | Filing accepted | Filing passed validation, but failed DB constraints | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, 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 |