filer_id | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1107063 | 1107199 | 2044186 | 2079187 | 2113650 | 2133009 | 2162308 | 2203161 | 2415582 | 2470030 | 2518840 | 2278879 | 2547263 | 2343481 | ||||||||||||||
effect_dt | 1997-01-01 00:00:00 | 1994-12-05 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2008-01-01 00:00:00 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2021-01-01 00:00:00 | 2013-01-01 00:00:00 | 2023-01-01 00:00:00 | 2015-01-01 00:00:00 | ||||||||||||||
add_type | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | 7051 | ||||||||||||||
session_id | 1997 | 1995 | 2003 | 2005 | 2007 | 2007 | 2009 | 2011 | 2017 | 2019 | 2021 | 2013 | 2023 | 2015 |
filer_id | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 478220 | 469238 | 474765 | 473786 | 467269 | 498320 | 479387 | 487374 | 483922 | 483751 | 541135 | 491270 | 472639 | 494744 | 483922 | 468264 | 494953 | 540842 | 464111 | 491087 | 624680 | 618356 | 672427 | 661891 | 714873 | 709264 | 696244 | 754074 | 736115 | 744124 | 795292 | 769399 | 780658 | 788159 | 811155 | 837805 | 824249 | 840892 | 861537 | 851908 | 908470 | 881734 | 902261 | 883677 | 906515 | 933794 | 943436 | 929942 | 966073 | 954311 | 967508 | 943436 | 980563 | 1010805 | 985594 | 1012677 | 995276 | 1024894 | 1026282 | 1020736 | 1075686 | 1068442 | 1055840 | 1061746 | 1093224 | 1010805 | 1082249 | 1010805 | 1103250 | 1113864 | 1103250 | 1127156 | 1132298 | 1143232 | 1163728 | 1132298 | 1187208 | 1187208 | 1229816 | 1212226 | 1222340 | 1259700 | 1248285 | 1280178 | 1305723 | 1293320 | 1776672 | 1963463 | 1976034 | 1864522 | 1811346 | 1794298 | 1939195 | 1902067 | 1327159 | 1344829 | 1327159 | 1393218 | 1374994 | 1374994 | 1374994 | 1387400 | 1419348 | 1406044 | 1393218 | 1419348 | 1432391 | 1412833 | 1450129 | 1432391 | 1419348 | 1419348 | 1419348 | 1462986 | 1481722 | 1502451 | 1534429 | 1563509 | 1563201 | 1555558 | 1591499 | 1602285 | 1591499 | 1632351 | 1620901 | 1654120 | 1673553 | 1654120 | 1931317 | 1920204 | 1701763 | 1731999 | 1722165 | 1738213 | 1840281 | 1761924 | 1992047 | 2190137 | 2436743 | 2364348 | 2392688 | 2214342 | 2190137 | 2329798 | 2004373 | 2035873 | 2059491 | 2097651 | 2097651 | 2120329 | 2115186 | 2169349 | 2136239 | 2157259 | 2157259 | 2377964 | 2242223 | 2272926 | 2550104 | 2115186 | 2204235 | 2318231 | 2339171 | 2415068 | 2377964 | 2468119 | 2586353 | 2599042 | 2525285 | 2482487 | 2676008 | 2621263 | 2547647 | 2639394 | 2706168 | 2580051 | 2747465 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 151 | 142 | 143 | 158 | 149 | 156 | 159 | 153 | 145 | 152 | 146 | 147 | 150 | 155 | 145 | 157 | 148 | 144 | 141 | 154 | 161 | 160 | 163 | 162 | 164 | None | 163 | 165 | 164 | 165 | None | 166 | None | 167 | 168 | 169 | None | None | None | 170 | None | 171 | None | None | 172 | None | 174 | 173 | 175 | None | None | 174 | None | 177 | 176 | None | None | 178 | None | None | 180 | 180 | 179 | None | None | 177 | None | 177 | 181 | 182 | 181 | None | 183 | 184 | 185 | 183 | 186 | 186 | 188 | 187 | 188 | 189 | None | 190 | 192 | 191 | 214 | 221 | 222 | 218 | 216 | 215 | None | 219 | 193 | 194 | 193 | 196 | 195 | 195 | 195 | 196 | 197 | None | 196 | 197 | 198 | None | 199 | 198 | 197 | 197 | 197 | 200 | 201 | 202 | 203 | 204 | None | 204 | 205 | 206 | 205 | 208 | 207 | 209 | 210 | 209 | 220 | 220 | 211 | 212 | 212 | None | 217 | 213 | 223 | 231 | 240 | None | 238 | None | 231 | 236 | 224 | 225 | 226 | 227 | 227 | 228 | 228 | 230 | None | 229 | 229 | 237 | 233 | 234 | 244 | 233 | 232 | 235 | 236 | 239 | 237 | 241 | None | 246 | 243 | 242 | 249 | 247 | 244 | 248 | 250 | 245 | 251 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F690 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F625 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F690 | F635 | F635 | F635 | F635 | F635 | F635 | F690 | F635 | F602 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F690 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F603 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | 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 | 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 | 2 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 2 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 2 | 3 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1997-10-31 00:00:00 | 1995-07-31 00:00:00 | 1995-10-31 00:00:00 | 1999-07-30 00:00:00 | 1997-04-30 00:00:00 | 1999-01-26 00:00:00 | 1999-10-27 00:00:00 | 1998-04-29 00:00:00 | 1996-04-30 00:00:00 | 1998-01-30 00:00:00 | 1996-07-31 00:00:00 | 1996-10-31 00:00:00 | 1997-07-30 00:00:00 | 1998-11-02 00:00:00 | 1996-07-31 00:00:00 | 1999-04-29 00:00:00 | 1997-01-28 00:00:00 | 1996-01-31 00:00:00 | 1995-04-28 00:00:00 | 1998-07-31 00:00:00 | 2000-04-20 00:00:00 | 2000-01-26 00:00:00 | 2000-10-19 00:00:00 | 2000-07-28 00:00:00 | 2001-01-26 00:00:00 | 2000-12-22 00:00:00 | 2000-10-19 00:00:00 | 2001-04-27 00:00:00 | 2001-01-26 00:00:00 | 2001-04-26 00:00:00 | 2001-10-24 00:00:00 | 2001-07-24 00:00:00 | 2001-07-31 00:00:00 | 2001-10-22 00:00:00 | 2002-01-28 00:00:00 | 2002-04-26 00:00:00 | 2002-01-30 00:00:00 | 2002-04-29 00:00:00 | 2002-07-29 00:00:00 | 2002-07-25 00:00:00 | 2003-01-27 00:00:00 | 2002-10-29 00:00:00 | 2002-12-27 00:00:00 | 2002-10-29 00:00:00 | 2003-01-27 00:00:00 | 2003-04-29 00:00:00 | 2003-07-22 00:00:00 | 2003-04-29 00:00:00 | 2003-10-22 00:00:00 | 2003-07-23 00:00:00 | 2003-10-24 00:00:00 | 2003-11-07 00:00:00 | 2003-11-07 00:00:00 | 2004-04-23 00:00:00 | 2004-01-23 00:00:00 | 2004-04-26 00:00:00 | 2004-01-26 00:00:00 | 2004-07-22 00:00:00 | 2004-07-26 00:00:00 | 2004-06-07 00:00:00 | 2005-01-26 00:00:00 | 2004-12-29 00:00:00 | 2004-10-28 00:00:00 | 2004-10-28 00:00:00 | 2004-12-29 00:00:00 | 2005-02-14 00:00:00 | 2005-01-26 00:00:00 | 2005-02-10 00:00:00 | 2005-08-26 00:00:00 | 2005-07-25 00:00:00 | 2005-04-27 00:00:00 | 2005-02-17 00:00:00 | 2005-10-28 00:00:00 | 2006-01-23 00:00:00 | 2006-04-21 00:00:00 | 2006-04-12 00:00:00 | 2006-07-25 00:00:00 | 2006-09-19 00:00:00 | 2007-01-22 00:00:00 | 2006-10-26 00:00:00 | 2006-11-22 00:00:00 | 2007-04-26 00:00:00 | 2007-01-02 00:00:00 | 2007-07-25 00:00:00 | 2008-01-24 00:00:00 | 2007-10-17 00:00:00 | 2013-07-19 00:00:00 | 2015-04-28 00:00:00 | 2015-07-22 00:00:00 | 2014-07-21 00:00:00 | 2014-01-20 00:00:00 | 2013-10-15 00:00:00 | 2014-12-23 00:00:00 | 2014-10-22 00:00:00 | 2008-04-25 00:00:00 | 2008-07-22 00:00:00 | 2008-05-27 00:00:00 | 2009-01-28 00:00:00 | 2008-10-29 00:00:00 | 2009-01-26 00:00:00 | 2009-01-26 00:00:00 | 2009-01-05 00:00:00 | 2009-04-28 00:00:00 | 2009-01-06 00:00:00 | 2009-04-08 00:00:00 | 2009-05-06 00:00:00 | 2009-07-22 00:00:00 | 2009-01-06 00:00:00 | 2009-10-27 00:00:00 | 2009-10-23 00:00:00 | 2009-08-10 00:00:00 | 2009-10-23 00:00:00 | 2010-03-23 00:00:00 | 2010-01-29 00:00:00 | 2010-04-23 00:00:00 | 2010-07-22 00:00:00 | 2010-10-25 00:00:00 | 2011-01-21 00:00:00 | 2010-12-30 00:00:00 | 2010-12-30 00:00:00 | 2011-05-02 00:00:00 | 2011-07-22 00:00:00 | 2011-05-18 00:00:00 | 2012-01-26 00:00:00 | 2011-10-28 00:00:00 | 2012-04-24 00:00:00 | 2012-07-23 00:00:00 | 2012-10-19 00:00:00 | 2015-01-28 00:00:00 | 2014-12-23 00:00:00 | 2012-10-23 00:00:00 | 2013-01-25 00:00:00 | 2013-01-02 00:00:00 | 2013-01-02 00:00:00 | 2014-04-22 00:00:00 | 2013-04-25 00:00:00 | 2015-10-15 00:00:00 | 2018-01-15 00:00:00 | 2020-01-28 00:00:00 | 2018-12-28 00:00:00 | 2019-07-24 00:00:00 | 2018-02-09 00:00:00 | 2017-10-25 00:00:00 | 2018-12-27 00:00:00 | 2016-01-18 00:00:00 | 2016-04-29 00:00:00 | 2016-07-27 00:00:00 | 2016-10-27 00:00:00 | 2017-01-18 00:00:00 | 2017-01-18 00:00:00 | 2016-12-29 00:00:00 | 2017-07-21 00:00:00 | 2016-12-29 00:00:00 | 2017-05-11 00:00:00 | 2017-05-01 00:00:00 | 2020-02-12 00:00:00 | 2018-04-30 00:00:00 | 2018-07-30 00:00:00 | 2021-01-29 00:00:00 | 2018-02-08 00:00:00 | 2018-01-23 00:00:00 | 2018-10-31 00:00:00 | 2019-01-24 00:00:00 | 2019-10-24 00:00:00 | 2019-04-26 00:00:00 | 2020-04-28 00:00:00 | 2021-01-28 00:00:00 | 2021-07-29 00:00:00 | 2020-10-28 00:00:00 | 2020-07-29 00:00:00 | 2022-05-02 00:00:00 | 2021-10-28 00:00:00 | 2021-01-26 00:00:00 | 2022-01-27 00:00:00 | 2022-08-01 00:00:00 | 2021-04-30 00:00:00 | 2022-10-31 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 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10005 | 10002 | 10006 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10006 | 10001 | 10001 | 10001 | 10005 | 10005 | 10002 | 10005 | 10002 | 10002 | 10001 | 10001 | 10006 | 10001 | 10001 | 10001 | 10002 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10002 | 10002 | 10001 | 10001 | 10005 | 10002 | 10002 | 10001 | 10005 | 10001 | 10002 | 10002 | 10002 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10002 | 10001 | 10005 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10005 | 10002 | 10001 | 10002 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 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 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 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 | 11001 | 11001 | 11003 | 11001 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1997 | 1995 | 1995 | 1999 | 1997 | 1997 | 1999 | 1997 | 1995 | 1997 | 1995 | 1995 | 1997 | 1997 | 1995 | 1999 | 1995 | 1995 | 1995 | 1997 | 1999 | 1999 | 1999 | 1999 | 1999 | 2001 | 1999 | 2001 | 1999 | 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 | 2003 | 2005 | 2003 | 2005 | 2003 | 2005 | 2005 | 2005 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2013 | 2015 | 2015 | 2013 | 2013 | 2013 | 2015 | 2013 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2009 | 2009 | 2009 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2015 | 2011 | 2011 | 2013 | 2013 | 2013 | 2013 | 2015 | 2017 | 2019 | 2019 | 2019 | 2017 | 2017 | 2019 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2017 | 2017 | 2019 | 2017 | 2017 | 2017 | 2017 | 2019 | 2019 | 2019 | 2021 | 2021 | 2019 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | TTHAM | * | * | LTHIBAUL | * | SARRIAGA | LTHIBAUL | YBONILLA | LTHIBAUL | * | LTHIBAUL | * | LTHIBAUL | * | * | * | LTHIBAUL | LTHIBAUL | LTHIBAUL | * | LTHIBAUL | * | PBANFORD | LTHIBAUL | COMPLETED | LTHIBAUL | COMPLETED | COMPLETED | COMPLETED | LTHIBAUL | LTHIBAUL | COMPLETED | YBONILLA | COMPLETED | COMPLETED | LTHIBAUL | LTHIBAUL | COMPLETED | LTHIBAUL | EMCENTEE | COMPLETED | GPEREZ | COMPLETED | LTHIBAUL | SARRIAGA | COMPLETED | LTHIBAUL | COMPLETED | LTHIBAUL | LTHIBAUL | LTHIBAUL | GGILMORE | LTHIBAUL | LTHIBAUL | LTHIBAUL | * | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | GPEREZ | LTHIBAUL | SARRIAGA | LTHIBAUL | LTHIBAUL | LTHIBAUL | AGLADNEY | MPACHECO | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | GKURIMOT | ASAETERN | LTHIBAUL | YRODRIGU | LTHIBAUL | JINGRAM | JINGRAM | JINGRAM | JINGRAM | GPEREZ | MGUERRA | SARRIAGA | JINGRAM | MGUERRA | MGUERRA | YRODRIGU | MGUERRA | MGUERRA | MGUERRA | MGUERRA | JINGRAM | WBROWN | ASAETERN | ASAETERN | ASAETERN | AGLADNEY | GPEREZ | YRODRIGU | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | ASAETERN | GPEREZ | AGLADNEY | ASAETERN | PBANFORD | PBANFORD | AGLADNEY | AGLADNEY | MPACHECO | AGLADNEY | GTAYLOR | GPEREZ | SUSHAKOV | GPEREZ | AGLADNEY | GPEREZ | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | GPEREZ | AGLADNEY | SARRIAGA | AGLADNEY | AGLADNEY | GTAYLOR | AGLADNEY | AGLADNEY | GTAYLOR | GPEREZ | AGLADNEY | AGLADNEY | AGLADNEY | VUKSTINA | VUKSTINA | GTAYLOR | MMERCHANT | MKIRKHAM | GTAYLOR | GTAYLOR | CAFILER | CHATRIDGE | MMERCHANT | RATTIYEH | 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 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11002 | 11002 | 11002 | 11003 | 11003 | 11003 | 11003 | 11002 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 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 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 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 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 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 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1997-07-01 00:00:00 | 1995-04-01 00:00:00 | 1995-07-01 00:00:00 | 1999-04-01 00:00:00 | 1997-01-01 00:00:00 | 1998-10-01 00:00:00 | 1999-07-01 00:00:00 | 1998-01-01 00:00:00 | 1996-01-01 00:00:00 | 1997-10-01 00:00:00 | 1996-04-01 00:00:00 | 1996-07-01 00:00:00 | 1997-04-01 00:00:00 | 1998-07-01 00:00:00 | 1996-01-01 00:00:00 | 1999-01-01 00:00:00 | 1996-10-01 00:00:00 | 1995-10-01 00:00:00 | 1995-01-01 00:00:00 | 1998-04-01 00:00:00 | 2000-01-01 00:00:00 | 1999-10-01 00:00:00 | 2000-07-01 00:00:00 | 2000-04-01 00:00:00 | 2000-10-01 00:00:00 | 1900-01-01 00:00:00 | 2000-07-01 00:00:00 | 2001-01-01 00:00:00 | 2000-10-01 00:00:00 | 2001-01-01 00:00:00 | 2001-07-01 00:00:00 | 2001-04-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-04-01 00:00:00 | 2002-10-01 00:00:00 | 2002-07-01 00:00:00 | 1900-01-01 00:00:00 | 2002-07-01 00:00:00 | 2002-10-01 00:00:00 | 2003-01-01 00:00:00 | 2003-04-01 00:00:00 | 2003-01-01 00:00:00 | 2003-07-01 00:00:00 | 2003-04-01 00:00:00 | 2003-07-01 00:00:00 | 2003-04-01 00:00:00 | 2003-04-01 00:00:00 | 2004-01-01 00:00:00 | 2003-10-01 00:00:00 | 2004-01-01 00:00:00 | 2003-10-01 00:00:00 | 2004-04-01 00:00:00 | 2004-04-01 00:00:00 | 2004-01-01 00:00:00 | 2004-10-01 00:00:00 | 2004-12-28 00:00:00 | 2004-07-01 00:00:00 | 2004-07-01 00:00:00 | 1900-01-01 00:00:00 | 2004-01-01 00:00:00 | 2004-10-01 00:00:00 | 2004-01-01 00:00:00 | 2005-01-01 00:00:00 | 2005-04-01 00:00:00 | 2005-01-01 00:00:00 | 2004-01-01 00:00:00 | 2005-07-01 00:00:00 | 2005-10-01 00:00:00 | 2006-01-01 00:00:00 | 2005-07-01 00:00:00 | 2006-04-01 00:00:00 | 2006-04-01 00:00:00 | 2006-10-01 00:00:00 | 2006-07-01 00:00:00 | 2006-11-22 00:00:00 | 2007-01-01 00:00:00 | 1900-01-01 00:00:00 | 2007-04-01 00:00:00 | 2007-10-01 00:00:00 | 2007-07-01 00:00:00 | 2013-04-01 00:00:00 | 2015-01-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-07-01 00:00:00 | 2008-01-01 00:00:00 | 2008-04-01 00:00:00 | 2008-01-01 00:00:00 | 2008-10-01 00:00:00 | 2008-07-01 00:00:00 | 2008-07-01 00:00:00 | 2008-07-01 00:00:00 | 2008-12-03 00:00:00 | 2009-01-01 00:00:00 | 1900-01-01 00:00:00 | 2008-10-01 00:00:00 | 2009-01-01 00:00:00 | 2009-04-01 00:00:00 | 1900-01-01 00:00:00 | 2009-07-01 00:00:00 | 2009-04-01 00:00:00 | 2009-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-01-01 00:00:00 | 2009-10-01 00:00:00 | 2010-01-01 00:00:00 | 2010-04-01 00:00:00 | 2010-07-01 00:00:00 | 2010-10-01 00:00:00 | None | 2010-11-12 00:00:00 | 2011-01-01 00:00:00 | 2011-04-01 00:00:00 | 2011-01-01 00:00:00 | 2011-10-01 00:00:00 | 2011-07-01 00:00:00 | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 2012-01-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-11 00:00:00 | 2012-07-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-08 00:00:00 | 1900-01-01 00:00:00 | 2014-01-01 00:00:00 | 2013-01-01 00:00:00 | 2015-07-01 00:00:00 | 2017-07-01 00:00:00 | 2019-10-01 00:00:00 | 1900-01-01 00:00:00 | 2019-04-01 00:00:00 | 1900-01-01 00:00:00 | 2017-07-01 00:00:00 | 2018-11-26 00:00:00 | 2015-10-01 00:00:00 | 2016-01-01 00:00:00 | 2016-04-01 00:00:00 | 2016-07-01 00:00:00 | 2016-07-01 00:00:00 | 2016-10-01 00:00:00 | 2016-11-28 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 | 2019-01-01 00:00:00 | 2018-01-01 00:00:00 | 2018-04-01 00:00:00 | 2020-10-01 00:00:00 | 2018-02-01 00:00:00 | 2017-10-01 00:00:00 | 2018-07-01 00:00:00 | 2018-10-01 00:00:00 | 2019-07-01 00:00:00 | 2019-01-01 00:00:00 | 2020-01-01 00:00:00 | 1900-01-01 00:00:00 | 2021-04-01 00:00:00 | 2020-07-01 00:00:00 | 2020-04-01 00:00:00 | 2022-01-01 00:00:00 | 2021-07-01 00:00:00 | 2020-12-01 00:00:00 | 2021-10-01 00:00:00 | 2022-04-01 00:00:00 | 2021-01-01 00:00:00 | 2022-07-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1997-09-30 00:00:00 | 1995-06-30 00:00:00 | 1995-09-30 00:00:00 | 1999-06-30 00:00:00 | 1997-03-31 00:00:00 | 1998-12-31 00:00:00 | 1999-09-30 00:00:00 | 1998-03-31 00:00:00 | 1996-03-31 00:00:00 | 1997-12-31 00:00:00 | 1996-06-30 00:00:00 | 1996-09-30 00:00:00 | 1997-06-30 00:00:00 | 1998-09-30 00:00:00 | 1996-03-31 00:00:00 | 1999-03-31 00:00:00 | 1996-12-31 00:00:00 | 1995-12-31 00:00:00 | 1995-03-31 00:00:00 | 1998-06-30 00:00:00 | 2000-03-31 00:00:00 | 1999-12-31 00:00:00 | 2000-09-30 00:00:00 | 2000-06-30 00:00:00 | 2000-12-31 00:00:00 | 1900-01-01 00:00:00 | 2000-09-30 00:00:00 | 2001-03-31 00:00:00 | 2000-12-31 00:00:00 | 2001-03-31 00:00:00 | 2001-09-30 00:00:00 | 2001-06-30 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-06-30 00:00:00 | 2002-12-31 00:00:00 | 2002-09-30 00:00:00 | 1900-01-01 00:00:00 | 2002-09-30 00:00:00 | 2002-12-31 00:00:00 | 2003-03-31 00:00:00 | 2003-06-30 00:00:00 | 2003-03-31 00:00:00 | 2003-09-30 00:00:00 | 2003-06-30 00:00:00 | 2003-09-30 00:00:00 | 2003-06-30 00:00:00 | 2003-06-30 00:00:00 | 2004-03-31 00:00:00 | 2003-12-31 00:00:00 | 2004-03-31 00:00:00 | 2003-12-31 00:00:00 | 2004-06-30 00:00:00 | 2004-06-30 00:00:00 | 2004-03-31 00:00:00 | 2004-12-31 00:00:00 | 2004-12-28 00:00:00 | 2004-09-30 00:00:00 | 2004-09-30 00:00:00 | 1900-01-01 00:00:00 | 2004-03-31 00:00:00 | 2004-12-31 00:00:00 | 2004-03-31 00:00:00 | 2005-03-31 00:00:00 | 2005-06-30 00:00:00 | 2005-03-31 00:00:00 | 2004-03-31 00:00:00 | 2005-09-30 00:00:00 | 2005-12-31 00:00:00 | 2006-03-31 00:00:00 | 2005-09-30 00:00:00 | 2006-06-30 00:00:00 | 2006-06-30 00:00:00 | 2006-12-31 00:00:00 | 2006-09-30 00:00:00 | 2006-11-22 00:00:00 | 2007-03-31 00:00:00 | 1900-01-01 00:00:00 | 2007-06-30 00:00:00 | 2007-12-31 00:00:00 | 2007-09-30 00:00:00 | 2013-06-30 00:00:00 | 2015-03-31 00:00:00 | 2015-06-30 00:00:00 | 2014-06-30 00:00:00 | 2013-12-31 00:00:00 | 2013-09-30 00:00:00 | 1900-01-01 00:00:00 | 2014-09-30 00:00:00 | 2008-03-31 00:00:00 | 2008-06-30 00:00:00 | 2008-03-31 00:00:00 | 2008-12-31 00:00:00 | 2008-09-30 00:00:00 | 2008-09-30 00:00:00 | 2008-09-30 00:00:00 | 2008-12-03 00:00:00 | 2009-03-31 00:00:00 | 1900-01-01 00:00:00 | 2008-12-31 00:00:00 | 2009-03-31 00:00:00 | 2009-06-30 00:00:00 | 1900-01-01 00:00:00 | 2009-09-30 00:00:00 | 2009-06-30 00:00:00 | 2009-03-31 00:00:00 | 2009-03-31 00:00:00 | 2009-03-31 00:00:00 | 2009-12-31 00:00:00 | 2010-03-31 00:00:00 | 2010-06-30 00:00:00 | 2010-09-30 00:00:00 | 2010-12-31 00:00:00 | None | 2010-11-12 00:00:00 | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 2011-03-31 00:00:00 | 2011-12-31 00:00:00 | 2011-09-30 00:00:00 | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 2012-03-31 00:00:00 | 2014-12-31 00:00:00 | 2014-11-11 00:00:00 | 2012-09-30 00:00:00 | 2012-12-31 00:00:00 | 2012-11-08 00:00:00 | 1900-01-01 00:00:00 | 2014-03-31 00:00:00 | 2013-03-31 00:00:00 | 2015-09-30 00:00:00 | 2017-09-30 00:00:00 | 2019-12-31 00:00:00 | 1900-01-01 00:00:00 | 2019-06-30 00:00:00 | 1900-01-01 00:00:00 | 2017-09-30 00:00:00 | 2018-11-26 00:00:00 | 2015-12-31 00:00:00 | 2016-03-31 00:00:00 | 2016-06-30 00:00:00 | 2016-09-30 00:00:00 | 2016-09-30 00:00:00 | 2016-12-31 00:00:00 | 2016-11-28 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 | 2019-03-31 00:00:00 | 2018-03-31 00:00:00 | 2018-06-30 00:00:00 | 2020-12-31 00:00:00 | 2018-02-01 00:00:00 | 2017-12-31 00:00:00 | 2018-09-30 00:00:00 | 2018-12-31 00:00:00 | 2019-09-30 00:00:00 | 2019-03-31 00:00:00 | 2020-03-31 00:00:00 | 1900-01-01 00:00:00 | 2021-06-30 00:00:00 | 2020-09-30 00:00:00 | 2020-06-30 00:00:00 | 2022-03-31 00:00:00 | 2021-09-30 00:00:00 | 2020-12-01 00:00:00 | 2021-12-31 00:00:00 | 2022-06-30 00:00:00 | 2021-03-31 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 | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_type | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 22001 | None | 22001 | 22001 | 22001 | None | None | 22001 | None | 22001 | 22001 | None | None | 22001 | None | None | 22001 | 22001 | 22001 | None | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22006 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 | 22001 |
filer_id | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 1997 | 1995 | 1999 | 2003 | 2001 | 2009 | 2005 | 2007 | 2013 | 2011 | 2017 | 2015 | 2019 | 2023 | 2021 | |||||||||||||||
interest_cd | 40301 | 40301 | 40301 | 40301 | 40301 | 40301 | 40301 | 40301 | 40301 | 40301 | 40301 | 40301 | 40301 | 40301 | 40301 | |||||||||||||||
effect_date | 1997-01-01 00:00:00 | 1994-12-05 00:00:00 | 1999-01-01 00:00:00 | 2003-01-01 00:00:00 | 2001-01-01 00:00:00 | 2009-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2013-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 | 2023-01-01 00:00:00 | 2021-01-01 00:00:00 |
filer_id | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 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 | 1995 | 1997 | 1999 | 2001 | 2003 | 2005 | 2007 | 2013 | 2009 | 2011 | 2015 | 2019 | 2017 | 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 | 1994-12-05 00:00:00 | 1997-01-01 00:00:00 | 1999-01-01 00:00:00 | 2001-01-01 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2013-01-01 00:00:00 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2015-01-01 00:00:00 | 2019-01-01 00:00:00 | 2017-01-01 00:00:00 | 2021-01-01 00:00:00 | 2023-01-01 00:00:00 | |||||||||||||||
sub_category_type | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
election_type | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
sub_category_a | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
nyq_dt | None | None | None | None | None | 2000-07-01 00:00:00 | 2000-07-01 00:00:00 | None | 2000-07-01 00:00:00 | 2000-07-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 | 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 | 1142871 | |
---|---|---|
xref_id | C00149 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | C00149 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 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 | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
effect_dt | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 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 | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | None | None | 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 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
nams | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
adr1 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
adr2 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
city | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
st | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | CA | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
zip4 | 95825 | 95816 | 95825 | 95825 | 95825 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95825 | 95816 | 95825 | 95825 | 95825 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95825 | 95816 | 95825 | 95825 | 95825 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95825 | 95816 | 95825 | 95825 | 95825 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95825 | 95816 | 95825 | 95825 | 95825 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95825 | 95816 | 95825 | 95825 | 95825 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95825 | 95816 | 95825 | 95825 | 95825 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95825 | 95816 | 95825 | 95825 | 95825 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95825 | 95816 | 95825 | 95825 | 95825 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95825 | 95816 | 95825 | 95825 | 95825 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95825 | 95816 | 95825 | 95825 | 95825 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95825 | 95816 | 95825 | 95825 | 95825 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95825 | 95816 | 95825 | 95825 | 95825 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 9169245370 | 9164482676 | 9169245370 | 9169245370 | 9169245370 | 9169245370 | 9163798995 | 9169245370 | 9169245370 | 9169245370 | 9163798995 | 9163798995 | 9163798995 | 9163798995 | 9169245370 | 9164482676 | 9169245370 | 9169245370 | 9169245370 | 9169245370 | 9163798995 | 9169245370 | 9169245370 | 9169245370 | 9163798995 | 9163798995 | 9163798995 | 9163798995 | 9169245370 | 9164482676 | 9169245370 | 9169245370 | 9169245370 | 9169245370 | 9163798995 | 9169245370 | 9169245370 | 9169245370 | 9163798995 | 9163798995 | 9163798995 | 9163798995 | 9169245370 | 9164482676 | 9169245370 | 9169245370 | 9169245370 | 9169245370 | 9163798995 | 9169245370 | 9169245370 | 9169245370 | 9163798995 | 9163798995 | 9163798995 | 9163798995 | 9169245370 | 9164482676 | 9169245370 | 9169245370 | 9169245370 | 9169245370 | 9163798995 | 9169245370 | 9169245370 | 9169245370 | 9163798995 | 9163798995 | 9163798995 | 9163798995 | 9169245370 | 9164482676 | 9169245370 | 9169245370 | 9169245370 | 9169245370 | 9163798995 | 9169245370 | 9169245370 | 9169245370 | 9163798995 | 9163798995 | 9163798995 | 9163798995 | 9169245370 | 9164482676 | 9169245370 | 9169245370 | 9169245370 | 9169245370 | 9163798995 | 9169245370 | 9169245370 | 9169245370 | 9163798995 | 9163798995 | 9163798995 | 9163798995 | 9169245370 | 9164482676 | 9169245370 | 9169245370 | 9169245370 | 9169245370 | 9163798995 | 9169245370 | 9169245370 | 9169245370 | 9163798995 | 9163798995 | 9163798995 | 9163798995 | 9169245370 | 9164482676 | 9169245370 | 9169245370 | 9169245370 | 9169245370 | 9163798995 | 9169245370 | 9169245370 | 9169245370 | 9163798995 | 9163798995 | 9163798995 | 9163798995 | 9169245370 | 9164482676 | 9169245370 | 9169245370 | 9169245370 | 9169245370 | 9163798995 | 9169245370 | 9169245370 | 9169245370 | 9163798995 | 9163798995 | 9163798995 | 9163798995 | 9169245370 | 9164482676 | 9169245370 | 9169245370 | 9169245370 | 9169245370 | 9163798995 | 9169245370 | 9169245370 | 9169245370 | 9163798995 | 9163798995 | 9163798995 | 9163798995 | 9169245370 | 9164482676 | 9169245370 | 9169245370 | 9169245370 | 9169245370 | 9163798995 | 9169245370 | 9169245370 | 9169245370 | 9163798995 | 9163798995 | 9163798995 | 9163798995 | 9169245370 | 9164482676 | 9169245370 | 9169245370 | 9169245370 | 9169245370 | 9163798995 | 9169245370 | 9169245370 | 9169245370 | 9163798995 | 9163798995 | 9163798995 | 9163798995 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | 9169245374 | None | 9163798999 | 9169245374 | None | 9163798999 | 9169245374 | None | 9163798999 | 9169245374 | None | 9163798999 | 9169245374 | None | 9163798999 | 9169245374 | None | 9163798999 | 9169245374 | None | 9163798999 | 9169245374 | None | 9163798999 | 9169245374 | None | 9163798999 | 9169245374 | None | 9163798999 | 9169245374 | None | 9163798999 | 9169245374 | None | 9163798999 | 9169245374 | None | 9163798999 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None | None | None | None | None | None | None | [email protected] | None | None | None | None | None | None | None |
filer_id | 1142871 |
---|
filer_id | 1142871 | 1142871 | 1142871 | |||
---|---|---|---|---|---|---|
change_no | 1 | 2 | 3 | |||
session_id | 1999 | 1999 | 2021 | |||
log_dt | 2000-10-18 00:00:00 | 2000-10-18 00:00:00 | 2021-01-28 00:00:00 | |||
filer_type | 1 | 1 | 1 | |||
correction_flg | None | None | None | |||
action | SET ACTIVE | SET ACTIVE | CHANGED | |||
attribute_changed | CLIENT | CLIENT | RESPONSIBLE OFFICER | |||
ethics_dt | None | None | None | |||
interests | None | None | None | |||
filer_full_name | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | CALIFORNIA ASSOCIATION OF WINEGRAPE GROWERS | |||
filer_city | Kingsburg | SOUTH PASADENA | None | |||
filer_st | CA | CA | None | |||
filer_zip | 936319232 | 91030 | None | |||
filer_phone | 2098972362 | 6264413107 | None | |||
entity_type | 3 | 3 | 20 | |||
entity_name | GUALCO GROUP, THE | GUALCO GROUP, THE | PRESIDENT JOHN AGUIRRE | |||
entity_city | None | None | None | |||
entity_st | None | None | None | |||
entity_zip | None | None | None | |||
entity_phone | None | None | None | |||
entity_id | 1147392 | 1147392 | 1335700 | |||
responsible_officer | None | None | None | |||
effect_dt | None | None | 2021-01-01 00:00:00 |
filer_id | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | 1142871 | |||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 672427_0.cal | 714873_0.cal | 744124_0.cal | 769399_0.cal | 788159_0.cal | 811155_0.cal | 837805_0.cal | 851908_0.cal | 881734_0.cal | 906515_0.cal | 929942_0.cal | 943436_0.cal | 966073_0.cal | 943436_1.cal | 69309.cal | 69259.cal | 377465.cal | 450722.cal | 465207.cal | 465669.cal | 265368.cal | 465081.cal | 300069.cal | 300110.cal | 300149.cal | 406114.cal | 405961.cal | 270543.cal | 271214.cal | |||||||||||||||||||||||||||||
received_date | 2000-10-19 00:00:00 | 2001-01-26 00:00:00 | 2001-04-26 00:00:00 | 2001-07-24 00:00:00 | 2001-10-22 00:00:00 | 2002-01-28 00:00:00 | 2002-04-26 00:00:00 | 2002-07-25 00:00:00 | 2002-10-29 00:00:00 | 2003-01-27 00:00:00 | 2003-04-29 00:00:00 | 2003-07-22 00:00:00 | 2003-10-22 00:00:00 | 2003-11-07 00:00:00 | 2005-04-27 00:00:00 | 2005-04-27 00:00:00 | 2009-01-26 00:00:00 | 2015-07-22 00:00:00 | 2016-10-27 00:00:00 | 2016-10-27 00:00:00 | 2017-01-18 00:00:00 | 2016-10-27 00:00:00 | 2014-10-22 00:00:00 | 2014-10-22 00:00:00 | 2014-10-22 00:00:00 | 2018-02-08 00:00:00 | 2018-02-08 00:00:00 | 2022-05-02 00:00:00 | 2022-05-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/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/temp | /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/temp | /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/temp | |||||||||||||||||||||||||||||
filing_id | 672427 | 714873 | 744124 | 769399 | 788159 | 811155 | 837805 | 851908 | 881734 | 906515 | 929942 | 943436 | 966073 | 943436 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||
form_id | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||||||||||||||||
receive_comment | Filing accepted, but 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, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing did not pass validation | Filing did not pass validation | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing did not pass validation | Filing did not pass validation | Filing passed validation, but failed DB constraints | Filing did not pass validation | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints |