acronym | CALPIRG | |
---|---|---|
filer_id | 1147123 |
filer_id | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1110133 | 1110454 | 2045989 | 2079983 | 2113834 | 2159135 | 2203214 | 2413026 | 2470985 | 2545601 | 2509459 | 2296240 | 2348961 | |||||||||||||
effect_dt | 1999-01-01 00:00:00 | 1997-02-21 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2011-05-18 00:00:00 | 2017-01-01 00:00:00 | 2019-01-01 00:00:00 | 2023-01-01 00:00:00 | 2021-01-01 00:00:00 | 2013-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 | |||||||||||||
session_id | 1999 | 1997 | 2003 | 2005 | 2007 | 2009 | 2011 | 2017 | 2019 | 2023 | 2021 | 2013 | 2015 |
filer_id | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 499328 | 498807 | 500515 | 499660 | 501033 | 501936 | 503658 | 499660 | 501936 | 502513 | 501356 | 500187 | 502513 | 503093 | 500515 | 615890 | 632665 | 623749 | 665958 | 729208 | 708539 | 697290 | 753284 | 781805 | 769120 | 821196 | 802949 | 806113 | 798017 | 798019 | 798038 | 798017 | 798058 | 834779 | 845972 | 861024 | 868936 | 850034 | 860405 | 844347 | 893230 | 908257 | 918945 | 926153 | 907432 | 907452 | 919555 | 834779 | 850034 | 942715 | 927314 | 925861 | 925862 | 926455 | 921777 | 954321 | 978326 | 969583 | 969583 | 977793 | 1001336 | 1007624 | 1010837 | 1008552 | 1029355 | 1036393 | 1071781 | 1055931 | 1065668 | 1095173 | 1081701 | 1100322 | 1118497 | 1120696 | 1131400 | 1140846 | 1167909 | 1184637 | 1214789 | 1230964 | 1230966 | 1229899 | 1258335 | 1233831 | 1284607 | 1284637 | 1297542 | 1297542 | 1784189 | 1783362 | 1982456 | 1965338 | 1846178 | 1846178 | 1867766 | 1765910 | 1799687 | 1799687 | 1902556 | 1329221 | 1311495 | 1311551 | 1315744 | 1351536 | 1329221 | 1425677 | 1429441 | 1407967 | 1453994 | 1429441 | 1453994 | 1469740 | 1407967 | 1476663 | 1469575 | 1499118 | 1546092 | 1571676 | 1598067 | 1616634 | 1596616 | 1616634 | 1634147 | 1611400 | 1622211 | 1650579 | 1650579 | 1679513 | 1818674 | 1687144 | 1913890 | 1903543 | 1922463 | 1924404 | 1710434 | 1818674 | 1766744 | 1765910 | 1760441 | 1998249 | 2319554 | 2242492 | 2211194 | 2416755 | 2343511 | 2528154 | 2346677 | 2271370 | 2007452 | 2007452 | 1998249 | 1982456 | 2038453 | 2065232 | 2105179 | 2129365 | 2105179 | 2134063 | 2175602 | 2158259 | 2468456 | 2382100 | 2487210 | 2192316 | 2397395 | 2538736 | 2433692 | 2549976 | 2668375 | 2631616 | 2596127 | 2699941 | 2577229 | 2638085 | 2623276 | 2632455 | 2744710 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 157 | 149 | 151 | 150 | 159 | 153 | 156 | 150 | 153 | 154 | 152 | 158 | 154 | 155 | 151 | 160 | None | None | None | 164 | None | 163 | 165 | None | 165 | None | None | 168 | 165 | 166 | None | 165 | 167 | 169 | None | None | None | 169 | None | None | 172 | None | None | 173 | 171 | 172 | None | 169 | 169 | 174 | None | None | None | None | None | None | None | 175 | 175 | 176 | None | None | None | 177 | 178 | None | None | 179 | None | None | 180 | 181 | 173 | 182 | 183 | 184 | 185 | 186 | 187 | 173 | 178 | None | 189 | 188 | 191 | 190 | 189 | 191 | None | 214 | 222 | 221 | 217 | 217 | 218 | 213 | 215 | 215 | 219 | 193 | None | 192 | None | 194 | 193 | None | 197 | 196 | 199 | 198 | 199 | 197 | 196 | 201 | 200 | 202 | 203 | 204 | 205 | 207 | None | 207 | 208 | 206 | None | 209 | 209 | 210 | 220 | None | None | 220 | 220 | None | 211 | 216 | None | 213 | None | 223 | 235 | 233 | 232 | 239 | None | 243 | 236 | 234 | 224 | 224 | 223 | 222 | 225 | 226 | 227 | 228 | 227 | None | 230 | 229 | 241 | 237 | 242 | 231 | 238 | 244 | 240 | 244 | 249 | 248 | 246 | 250 | 245 | 248 | 247 | None | 251 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F690 | F690 | F690 | F635 | F635 | F635 | F635 | F690 | F635 | F635 | F690 | F635 | F635 | F603 | F635 | F635 | F635 | F635 | F635 | F605 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F690 | F635 | F605 | F635 | F605 | F635 | F603 | F603 | F605 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F690 | F690 | F605 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F690 | F635 | F635 | F635 | F635 | F603 | F635 | F635 | F635 | F635 | F635 | F666 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F615 | F603 | F635 | F635 | F603 | F635 | F635 | F635 | F603 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F605 | F635 | F605 | F635 | F635 | F603 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F603 | F635 | F635 | F635 | F666 | F635 | F635 | F635 | F635 | F605 | F605 | F635 | F603 | F603 | F635 | F635 | F605 | F635 | F888 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 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 | 1 | 1 | 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 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1999-04-29 00:00:00 | 1997-05-14 00:00:00 | 1997-10-30 00:00:00 | 1997-07-31 00:00:00 | 1999-11-01 00:00:00 | 1998-04-30 00:00:00 | 1999-01-28 00:00:00 | 1998-10-29 00:00:00 | 1998-10-29 00:00:00 | 1998-10-29 00:00:00 | 1998-02-02 00:00:00 | 1999-07-27 00:00:00 | 1998-08-04 00:00:00 | 1998-10-29 00:00:00 | 1998-10-29 00:00:00 | 2000-01-28 00:00:00 | 2000-05-01 00:00:00 | 2000-02-23 00:00:00 | 2000-08-09 00:00:00 | 2001-02-02 00:00:00 | 2001-01-05 00:00:00 | 2000-11-02 00:00:00 | 2001-04-30 00:00:00 | 2001-08-02 00:00:00 | 2001-04-30 00:00:00 | 2002-01-15 00:00:00 | 2001-12-26 00:00:00 | 2002-01-11 00:00:00 | 2001-11-16 00:00:00 | 2001-11-16 00:00:00 | 2001-11-05 00:00:00 | 2001-11-16 00:00:00 | 2001-11-16 00:00:00 | 2002-04-12 00:00:00 | 2002-04-25 00:00:00 | 2002-07-31 00:00:00 | 2002-08-06 00:00:00 | 2002-07-17 00:00:00 | 2002-07-29 00:00:00 | 2002-04-22 00:00:00 | 2002-11-19 00:00:00 | 2003-01-27 00:00:00 | 2003-01-30 00:00:00 | 2003-04-01 00:00:00 | 2003-01-28 00:00:00 | 2003-01-28 00:00:00 | 2003-01-30 00:00:00 | 2003-01-28 00:00:00 | 2003-01-28 00:00:00 | 2003-07-18 00:00:00 | 2003-04-04 00:00:00 | 2003-02-06 00:00:00 | 2003-02-06 00:00:00 | 2003-04-03 00:00:00 | 2003-02-05 00:00:00 | 2003-07-24 00:00:00 | 2003-10-31 00:00:00 | 2003-10-31 00:00:00 | 2003-12-31 00:00:00 | 2003-12-31 00:00:00 | 2004-01-21 00:00:00 | 2004-01-21 00:00:00 | 2004-04-15 00:00:00 | 2004-04-06 00:00:00 | 2004-07-30 00:00:00 | 2004-08-02 00:00:00 | 2004-11-29 00:00:00 | 2004-10-28 00:00:00 | 2004-10-29 00:00:00 | 2005-02-02 00:00:00 | 2005-01-31 00:00:00 | 2005-04-14 00:00:00 | 2005-07-29 00:00:00 | 2005-08-03 00:00:00 | 2005-10-27 00:00:00 | 2006-01-06 00:00:00 | 2006-05-01 00:00:00 | 2006-07-17 00:00:00 | 2006-10-30 00:00:00 | 2003-04-04 00:00:00 | 2004-08-02 00:00:00 | 2006-12-04 00:00:00 | 2007-04-20 00:00:00 | 2007-01-29 00:00:00 | 2007-07-31 00:00:00 | 2007-07-31 00:00:00 | 2007-10-31 00:00:00 | 2008-01-08 00:00:00 | 2013-07-31 00:00:00 | 2013-07-31 00:00:00 | 2015-07-31 00:00:00 | 2015-04-30 00:00:00 | 2014-04-30 00:00:00 | 2014-06-24 00:00:00 | 2014-07-28 00:00:00 | 2013-09-09 00:00:00 | 2013-10-30 00:00:00 | 2014-01-07 00:00:00 | 2014-10-22 00:00:00 | 2008-04-30 00:00:00 | 2008-01-31 00:00:00 | 2008-01-31 00:00:00 | 2008-02-14 00:00:00 | 2008-07-31 00:00:00 | 2008-04-30 00:00:00 | 2009-05-11 00:00:00 | 2009-07-07 00:00:00 | 2009-03-18 00:00:00 | 2009-11-06 00:00:00 | 2010-02-16 00:00:00 | 2010-02-16 00:00:00 | 2010-02-17 00:00:00 | 2010-02-16 00:00:00 | 2010-03-30 00:00:00 | 2010-02-16 00:00:00 | 2010-07-02 00:00:00 | 2010-11-22 00:00:00 | 2011-01-31 00:00:00 | 2011-06-24 00:00:00 | 2011-10-06 00:00:00 | 2011-05-18 00:00:00 | 2012-01-30 00:00:00 | 2012-01-30 00:00:00 | 2011-08-05 00:00:00 | 2011-10-31 00:00:00 | 2012-04-04 00:00:00 | 2012-05-03 00:00:00 | 2012-07-31 00:00:00 | 2014-01-31 00:00:00 | 2012-08-20 00:00:00 | 2014-10-23 00:00:00 | 2014-10-23 00:00:00 | 2014-12-31 00:00:00 | 2015-01-02 00:00:00 | 2012-10-31 00:00:00 | 2014-06-26 00:00:00 | 2012-12-04 00:00:00 | 2013-04-30 00:00:00 | 2010-12-31 00:00:00 | 2015-11-02 00:00:00 | 2018-10-31 00:00:00 | 2018-04-30 00:00:00 | 2018-01-31 00:00:00 | 2019-10-29 00:00:00 | 2018-12-31 00:00:00 | 2020-10-30 00:00:00 | 2019-01-31 00:00:00 | 2018-07-28 00:00:00 | 2016-01-26 00:00:00 | 2016-01-28 00:00:00 | 2016-01-28 00:00:00 | 2016-01-28 00:00:00 | 2016-05-02 00:00:00 | 2016-08-02 00:00:00 | 2016-11-04 00:00:00 | 2017-01-31 00:00:00 | 2016-11-22 00:00:00 | 2016-12-27 00:00:00 | 2017-07-31 00:00:00 | 2017-05-01 00:00:00 | 2020-04-28 00:00:00 | 2019-04-30 00:00:00 | 2020-07-31 00:00:00 | 2017-10-30 00:00:00 | 2019-07-31 00:00:00 | 2020-12-28 00:00:00 | 2020-01-23 00:00:00 | 2021-01-29 00:00:00 | 2022-04-20 00:00:00 | 2021-12-21 00:00:00 | 2021-07-23 00:00:00 | 2022-07-22 00:00:00 | 2021-04-27 00:00:00 | 2022-01-26 00:00:00 | 2021-10-30 00:00:00 | 2021-12-23 00:00:00 | 2022-10-27 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10005 | 10002 | 10001 | 10001 | 10006 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10001 | 10005 | 10002 | 10002 | 10001 | 10005 | 10006 | 10006 | 10005 | 10005 | 10005 | 10005 | 10001 | 10002 | 10001 | 10005 | 10006 | 10005 | 10001 | 10001 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10005 | 10001 | 10001 | 10001 | 10001 | 10002 | 10001 | 10002 | 10001 | 10002 | 10001 | 10002 | 10005 | 10001 | 10005 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10002 | 10002 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10002 | 10001 | 10001 | 10005 | 10001 | 10002 | 10001 | 10001 | 10006 | 10006 | 10001 | 10001 | 10005 | 10001 | 10002 | 10006 | 10001 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10002 | 10002 | 10002 | 10001 | 10001 | 10001 | 10001 | 10002 | 10005 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 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 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1999 | 1997 | 1997 | 1997 | 1999 | 1997 | 1997 | 1997 | 1997 | 1997 | 1997 | 1999 | 1997 | 1997 | 1997 | 1999 | 1999 | 1999 | 1999 | 1999 | 2001 | 1999 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2003 | 2003 | 2003 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2001 | 2001 | 2001 | 2003 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2003 | 2003 | 2003 | 2003 | 2005 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2005 | 2003 | 2003 | 2007 | 2007 | 2005 | 2007 | 2007 | 2007 | 2007 | 2013 | 2013 | 2015 | 2015 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2013 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2009 | 2009 | 2007 | 2009 | 2009 | 2009 | 2009 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2009 | 2011 | 2011 | 2011 | 2013 | 2011 | 2013 | 2013 | 2015 | 2015 | 2011 | 2013 | 2013 | 2013 | 2009 | 2015 | 2017 | 2017 | 2017 | 2019 | 2019 | 2019 | 2017 | 2017 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2019 | 2019 | 2019 | 2017 | 2019 | 2021 | 2019 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | KCHAN | TTHAM | YBONILLA | YBONILLA | GGILMORE | YBONILLA | YBONILLA | JBRANNAN | MKIENG | LTHIBAUL | CFLAGG | * | * | DHORRELL | LTHIBAUL | * | DHORRELL | * | LTHIBAUL | LTHIBAUL | CFLAGG | * | SARRIAGA | LTHIBAUL | BSMITH | GPEREZ | GPEREZ | COMPLETED | DHORRELL | DHORRELL | LTHIBAUL | COMPLETED | COMPLETED | COMPLETED | DBARRICK | LTHIBAUL | LTHIBAUL | PBANFORD | LTHIBAUL | LTHIBAUL | GGILMORE | COMPLETED | COMPLETED | COMPLETED | LTHIBAUL | EMCENTEE | LTHIBAUL | COMPLETED | COMPLETED | LTHIBAUL | SARRIAGA | COMPLETED | LTHIBAUL | LTHIBAUL | COMPLETED | LTHIBAUL | PROBERTS | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | DHORRELL | DHORRELL | PBANFORD | LTHIBAUL | LTHIBAUL | * | LTHIBAUL | LTHIBAUL | LTHIBAUL | YRODRIGU | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | ASAETERN | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | CAFILER | LTHIBAUL | GPEREZ | LTHIBAUL | GPEREZ | LTHIBAUL | LTHIBAUL | YRODRIGU | MGUERRA | JINGRAM | MGUERRA | MGUERRA | MGUERRA | NWALKER | JINGRAM | JINGRAM | NWALKER | ASAETERN | TBOWMAN | AGLADNEY | TBOWMAN | ASAETERN | ASAETERN | AGLADNEY | ASAETERN | TBOWMAN | NLANDERS | AGLADNEY | AGLADNEY | ASAETERN | AGLADNEY | YRODRIGU | SMCCONNAN | MPACHECO | CAFILER | GKURIMOT | ASAETERN | ASAETERN | YRODRIGU | ASAETERN | NLANDERS | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | VUKSTINA | YRODRIGU | GTAYLOR | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | RGEREMIA | DWALKER | AGLADNEY | AGLADNEY | PBANFORD | AGLADNEY | AGLADNEY | VUKSTINA | VUKSTINA | GTAYLOR | AGLADNEY | VUKSTINA | CAFILER | VUKSTINA | CHARTRIDGE | CAFILER | CVANLIEW | GTAYLOR | CAFILER | CHATRIDGE | CAFILER | GTAYLOR | CVANLIEW | CAFILER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 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 | 11002 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11002 | 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 | 11003 | 11003 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1999-01-01 00:00:00 | 1997-01-01 00:00:00 | 1997-07-01 00:00:00 | 1997-04-01 00:00:00 | 1999-07-01 00:00:00 | 1998-01-01 00:00:00 | 1998-10-01 00:00:00 | 1997-04-01 00:00:00 | 1998-01-01 00:00:00 | 1998-04-01 00:00:00 | 1997-10-01 00:00:00 | 1999-04-01 00:00:00 | 1998-04-01 00:00:00 | 1998-07-01 00:00:00 | 1997-07-01 00:00:00 | 1999-10-01 00:00:00 | 2000-01-01 00:00:00 | 1999-07-01 00:00:00 | 2000-05-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 | 2001-04-01 00:00:00 | None | 2001-10-01 00:00:00 | 1900-01-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-01-01 00:00:00 | 2001-07-01 00:00:00 | 2002-01-01 00:00:00 | 2000-01-01 00:00:00 | 2002-03-01 00:00:00 | 1900-01-01 00:00:00 | 2002-03-01 00:00:00 | 1900-01-01 00:00:00 | 2002-01-01 00:00:00 | 2002-11-19 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2003-01-01 00:00:00 | 2002-07-01 00:00:00 | 2002-10-01 00:00:00 | 2002-10-01 00:00:00 | 2002-01-01 00:00:00 | 2002-03-01 00:00:00 | 2003-04-01 00:00:00 | 2003-01-01 00:00:00 | 2002-01-01 00:00:00 | 2002-04-01 00:00:00 | 1900-01-01 00:00:00 | 2002-07-01 00:00:00 | 2003-04-01 00:00:00 | 2003-07-01 00:00:00 | 2003-07-01 00:00:00 | 2003-07-01 00:00:00 | 2003-10-01 00:00:00 | 2003-10-01 00:00:00 | 2003-07-01 00:00:00 | 2004-01-01 00:00:00 | 2004-01-01 00:00:00 | 2004-04-01 00:00:00 | 2004-04-01 00:00:00 | 1900-01-01 00:00:00 | 2004-07-01 00:00:00 | 2004-07-01 00:00:00 | 2004-10-01 00:00:00 | 2004-10-01 00:00:00 | 2005-01-01 00:00:00 | 2003-01-01 00:00:00 | 2005-04-01 00:00:00 | 2005-07-01 00:00:00 | 2005-10-01 00:00:00 | 2006-01-01 00:00:00 | 2006-04-01 00:00:00 | 2006-07-01 00:00:00 | 2003-01-01 00:00:00 | 2004-04-01 00:00:00 | 1900-01-01 00:00:00 | 2007-01-01 00:00:00 | 2006-10-01 00:00:00 | 2007-07-31 00:00:00 | 2007-04-01 00:00:00 | 2007-01-01 00:00:00 | 2007-07-01 00:00:00 | 1900-01-01 00:00:00 | 2013-04-01 00:00:00 | 2015-04-01 00:00:00 | 2015-01-01 00:00:00 | 2014-01-01 00:00:00 | 2014-01-01 00:00:00 | 2014-04-01 00:00:00 | 2013-01-01 00:00:00 | 2013-07-01 00:00:00 | 2013-07-01 00:00:00 | 2014-07-01 00:00:00 | 2008-01-01 00:00:00 | 1900-01-01 00:00:00 | 2007-10-01 00:00:00 | 1900-01-01 00:00:00 | 2008-04-01 00:00:00 | 2008-01-01 00:00:00 | 1900-01-01 00:00:00 | 2009-03-31 00:00:00 | 2008-10-01 00:00:00 | 2009-07-01 00:00:00 | 2009-04-01 00:00:00 | 2009-07-01 00:00:00 | 2009-01-01 00:00:00 | 2008-10-01 00:00:00 | 2010-01-01 00:00:00 | 2009-10-01 00:00:00 | 2010-04-01 00:00:00 | 2010-07-01 00:00:00 | 2010-10-01 00:00:00 | 2011-01-01 00:00:00 | 2011-07-01 00:00:00 | 1900-01-01 00:00:00 | 2011-07-01 00:00:00 | 2011-10-01 00:00:00 | 2011-04-01 00:00:00 | 2009-01-01 00:00:00 | 2012-01-01 00:00:00 | 2012-01-01 00:00:00 | 2012-04-01 00:00:00 | 2014-10-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2014-10-01 00:00:00 | 2014-12-31 00:00:00 | 1900-01-01 00:00:00 | 2012-07-01 00:00:00 | 2013-10-01 00:00:00 | 1900-01-01 00:00:00 | 2013-01-01 00:00:00 | None | 2015-07-01 00:00:00 | 2018-07-01 00:00:00 | 2018-01-01 00:00:00 | 2017-10-01 00:00:00 | 2019-07-01 00:00:00 | 1900-01-01 00:00:00 | 2020-07-01 00:00:00 | 2018-10-01 00:00:00 | 2018-04-01 00:00:00 | 2015-10-01 00:00:00 | 2015-10-01 00:00:00 | 2015-07-01 00:00:00 | 2015-04-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-07-01 00:00:00 | 1900-01-01 00:00:00 | 2017-04-01 00:00:00 | 2017-01-01 00:00:00 | 2020-01-01 00:00:00 | 2019-01-01 00:00:00 | 2020-04-01 00:00:00 | 2017-07-01 00:00:00 | 2019-04-01 00:00:00 | 2020-12-28 00:00:00 | 2019-10-01 00:00:00 | 2020-10-31 00:00:00 | 2022-01-01 00:00:00 | 2021-12-21 00:00:00 | 2021-04-01 00:00:00 | 2022-04-01 00:00:00 | 2021-01-01 00:00:00 | 2021-10-01 00:00:00 | 2021-07-01 00:00:00 | 1900-01-01 00:00:00 | 2022-07-01 00:00:00 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1999-03-31 00:00:00 | 1997-03-31 00:00:00 | 1997-09-30 00:00:00 | 1997-06-30 00:00:00 | 1999-09-30 00:00:00 | 1998-03-31 00:00:00 | 1998-12-31 00:00:00 | 1997-06-30 00:00:00 | 1998-03-31 00:00:00 | 1998-06-30 00:00:00 | 1997-12-31 00:00:00 | 1999-06-30 00:00:00 | 1998-06-30 00:00:00 | 1998-09-30 00:00:00 | 1997-09-30 00:00:00 | 1999-12-31 00:00:00 | 2000-03-31 00:00:00 | 1999-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 | 2001-06-30 00:00:00 | None | 2001-12-31 00:00:00 | 1900-01-01 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-03-31 00:00:00 | 2001-09-30 00:00:00 | 2002-03-31 00:00:00 | 2000-03-31 00:00:00 | 2002-06-30 00:00:00 | 1900-01-01 00:00:00 | 2002-06-30 00:00:00 | 1900-01-01 00:00:00 | 2002-03-31 00:00:00 | 2002-11-19 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2003-03-31 00:00:00 | 2002-09-30 00:00:00 | 2002-12-31 00:00:00 | 2002-12-31 00:00:00 | 2002-03-31 00:00:00 | 2002-06-30 00:00:00 | 2003-06-30 00:00:00 | 2003-03-31 00:00:00 | 2002-03-31 00:00:00 | 2002-06-30 00:00:00 | 1900-01-01 00:00:00 | 2002-09-30 00:00:00 | 2003-06-30 00:00:00 | 2003-09-30 00:00:00 | 2003-09-30 00:00:00 | 2003-09-30 00:00:00 | 2003-12-31 00:00:00 | 2003-12-31 00:00:00 | 2003-09-30 00:00:00 | 2004-03-31 00:00:00 | 2004-03-31 00:00:00 | 2004-06-30 00:00:00 | 2004-06-30 00:00:00 | 1900-01-01 00:00:00 | 2004-09-30 00:00:00 | 2004-09-30 00:00:00 | 2004-12-31 00:00:00 | 2004-12-31 00:00:00 | 2005-03-31 00:00:00 | 2004-12-31 00:00:00 | 2005-06-30 00:00:00 | 2005-09-30 00:00:00 | 2005-12-31 00:00:00 | 2006-03-31 00:00:00 | 2006-06-30 00:00:00 | 2006-09-30 00:00:00 | 2003-03-31 00:00:00 | 2004-06-30 00:00:00 | 1900-01-01 00:00:00 | 2007-03-31 00:00:00 | 2006-12-31 00:00:00 | 2007-07-31 00:00:00 | 2007-06-30 00:00:00 | 2007-09-30 00:00:00 | 2007-09-30 00:00:00 | 1900-01-01 00:00:00 | 2013-06-30 00:00:00 | 2015-06-30 00:00:00 | 2015-03-31 00:00:00 | 2014-04-30 00:00:00 | 2014-03-31 00:00:00 | 2014-06-30 00:00:00 | 2013-03-31 00:00:00 | 2013-09-30 00:00:00 | 2013-09-30 00:00:00 | 2014-09-30 00:00:00 | 2008-03-31 00:00:00 | 1900-01-01 00:00:00 | 2007-12-31 00:00:00 | 1900-01-01 00:00:00 | 2008-06-30 00:00:00 | 2008-03-31 00:00:00 | 1900-01-01 00:00:00 | 2009-07-01 00:00:00 | 2008-12-31 00:00:00 | 2009-10-01 00:00:00 | 2009-06-30 00:00:00 | 2009-09-30 00:00:00 | 2009-03-31 00:00:00 | 2008-12-31 00:00:00 | 2010-04-01 00:00:00 | 2009-12-31 00:00:00 | 2010-06-30 00:00:00 | 2010-09-30 00:00:00 | 2010-12-31 00:00:00 | 2011-03-31 00:00:00 | 2011-09-30 00:00:00 | 1900-01-01 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00 | 2011-06-30 00:00:00 | 2010-12-31 00:00:00 | 2012-03-31 00:00:00 | 2012-03-31 00:00:00 | 2012-06-30 00:00:00 | 2014-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2014-10-23 00:00:00 | 2014-12-31 00:00:00 | 1900-01-01 00:00:00 | 2012-09-30 00:00:00 | 2013-12-31 00:00:00 | 1900-01-01 00:00:00 | 2013-03-31 00:00:00 | None | 2015-09-30 00:00:00 | 2018-09-30 00:00:00 | 2018-03-31 00:00:00 | 2017-12-31 00:00:00 | 2019-09-30 00:00:00 | 1900-01-01 00:00:00 | 2020-09-30 00:00:00 | 2018-12-31 00:00:00 | 2018-06-30 00:00:00 | 2015-12-31 00:00:00 | 2015-12-31 00:00:00 | 2015-09-30 00:00:00 | 2015-06-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-09-30 00:00:00 | 1900-01-01 00:00:00 | 2017-06-30 00:00:00 | 2017-03-31 00:00:00 | 2020-03-31 00:00:00 | 2019-03-31 00:00:00 | 2020-06-30 00:00:00 | 2017-09-30 00:00:00 | 2019-06-30 00:00:00 | 2020-12-28 00:00:00 | 2019-12-31 00:00:00 | 2020-12-01 00:00:00 | 2022-03-31 00:00:00 | 2021-12-21 00:00:00 | 2021-06-30 00:00:00 | 2022-06-30 00:00:00 | 2021-03-31 00:00:00 | 2021-12-31 00:00:00 | 2021-09-30 00:00:00 | 1900-01-01 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 | 22001 | 22001 | 22001 | None | 22001 | 22001 | 22006 | None | None | None | None | None | None | None | 22006 | 22006 | 22006 | None | None | None | 22006 | 22006 | None | None | 22006 | None | None | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | None | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | None | None | 22006 | 22006 | None | 22006 | 22006 | None | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 |
filer_id | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 2001 | 2005 | 2003 | 1999 | 1997 | 2009 | 2011 | 2007 | 2017 | 2021 | 2013 | 2019 | 2015 | 2023 | ||||||||||||||
interest_cd | 40312 | 40314 | 40314 | 40314 | 40312 | 40312 | 40312 | 40314 | 40312 | 40312 | 40314 | 40312 | 40312 | 40312 | ||||||||||||||
effect_date | 2001-01-01 00:00:00 | 2005-01-01 00:00:00 | 2003-01-01 00:00:00 | 1999-01-01 00:00:00 | 1997-02-21 00:00:00 | 2009-01-01 00:00:00 | 2011-05-18 00:00:00 | 2007-01-01 00:00:00 | 2017-01-01 00:00:00 | 2021-01-01 00:00:00 | 2013-01-01 00:00:00 | 2019-01-01 00:00:00 | 2015-01-01 00:00:00 | 2023-01-01 00:00:00 |
filer_id | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | ||||||||||||||||
active | Y | Y | Y | Y | Y | Y | Y | Y | Y | T | T | Y | Y | Y | Y | N | ||||||||||||||||
race | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||
session_id | 1997 | 1999 | 2001 | 2003 | 2005 | 2007 | 2011 | 2013 | 2009 | 2011 | 2013 | 2015 | 2021 | 2019 | 2017 | 2023 | ||||||||||||||||
category | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||
category_type | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||
sub_category | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||
effect_dt | 1997-02-21 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 | 2011-05-18 00:00:00 | 2013-01-01 00:00:00 | 2009-01-01 00:00:00 | 2012-08-16 00:00:00 | 2014-10-22 00:00:00 | 2015-01-01 00:00:00 | 2021-01-01 00:00:00 | 2019-01-01 00:00:00 | 2017-01-01 00:00:00 | 2023-01-01 00:00:00 | ||||||||||||||||
sub_category_type | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||
election_type | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||
sub_category_a | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||
nyq_dt | None | None | None | None | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | None | None | 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 | None | ||||||||||||||||
county_cd | None | 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 | None |
filer_id | 1147123 | |
---|---|---|
xref_id | E24669 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | E24669 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
naml | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALPIRG | CALPIRG | CALPIRG | CALPIRG | CALPIRG | CALPIRG | CALPIRG | CALPIRG | CALPIRG | CALPIRG | CALPIRG | CALPIRG | CALPIRG | CALPIRG, CALIFORNIA PUBLIC INTEREST RESEARCH GROUP | CALPIRG, CALIFORNIA PUBLIC INTEREST RESEARCH GROUP | CALPIRG, CALIFORNIA PUBLIC INTEREST RESEARCH GROUP | CALPIRG, CALIFORNIA PUBLIC INTEREST RESEARCH GROUP | CALPIRG, CALIFORNIA PUBLIC INTEREST RESEARCH GROUP | CALPIRG, CALIFORNIA PUBLIC INTEREST RESEARCH GROUP | CALPIRG, CALIFORNIA PUBLIC INTEREST RESEARCH GROUP | CALPIRG, CALIFORNIA PUBLIC INTEREST RESEARCH GROUP | CALPIRG, CALIFORNIA PUBLIC INTEREST RESEARCH GROUP | CALPIRG, CALIFORNIA PUBLIC INTEREST RESEARCH GROUP | CALPIRG, CALIFORNIA PUBLIC INTEREST RESEARCH GROUP | CALPIRG, CALIFORNIA PUBLIC INTEREST RESEARCH GROUP | CALPIRG, CALIFORNIA PUBLIC INTEREST RESEARCH GROUP | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP, INC. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
city | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | OAKLAND | OAKLAND | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | OAKLAND | OAKLAND | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | OAKLAND | OAKLAND | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | OAKLAND | OAKLAND | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | OAKLAND | OAKLAND | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | OAKLAND | OAKLAND | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | OAKLAND | OAKLAND | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | OAKLAND | OAKLAND | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | OAKLAND | OAKLAND | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | OAKLAND | OAKLAND | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | OAKLAND | OAKLAND | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | OAKLAND | OAKLAND | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | SACRAMENTO | OAKLAND | OAKLAND | 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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
zip4 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95819 | 94607 | 94607 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95819 | 94607 | 94607 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95819 | 94607 | 94607 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95819 | 94607 | 94607 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95819 | 94607 | 94607 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95819 | 94607 | 94607 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95819 | 94607 | 94607 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95819 | 94607 | 94607 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95819 | 94607 | 94607 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95819 | 94607 | 94607 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95819 | 94607 | 94607 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95819 | 94607 | 94607 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95819 | 94607 | 94607 | 95814 | 95814 | 95814 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 5108446803 | 5108446800 | 5108446805 | 5108446805 | 5108446805 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 5108446803 | 5108446800 | 5108446805 | 5108446805 | 5108446805 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 5108446803 | 5108446800 | 5108446805 | 5108446805 | 5108446805 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 5108446803 | 5108446800 | 5108446805 | 5108446805 | 5108446805 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 5108446803 | 5108446800 | 5108446805 | 5108446805 | 5108446805 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 5108446803 | 5108446800 | 5108446805 | 5108446805 | 5108446805 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 5108446803 | 5108446800 | 5108446805 | 5108446805 | 5108446805 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 5108446803 | 5108446800 | 5108446805 | 5108446805 | 5108446805 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 5108446803 | 5108446800 | 5108446805 | 5108446805 | 5108446805 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 5108446803 | 5108446800 | 5108446805 | 5108446805 | 5108446805 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 5108446803 | 5108446800 | 5108446805 | 5108446805 | 5108446805 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 5108446803 | 5108446800 | 5108446805 | 5108446805 | 5108446805 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 9164484516 | 5108446803 | 5108446800 | 5108446805 | 5108446805 | 5108446805 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | 9164484560 | None | 9164484560 | 9164484560 | 9164484560 | 9164484560 | None | 9164484560 | 9164484560 | 9164484560 | 9164484560 | None | 9164484560 | 9164484560 | 9164484560 | 9164484560 | None | 9164484560 | 9164484560 | 9164484560 | 9164484560 | None | 9164484560 | 9164484560 | 9164484560 | 9164484560 | None | 9164484560 | 9164484560 | 9164484560 | 9164484560 | None | 9164484560 | 9164484560 | 9164484560 | 9164484560 | None | 9164484560 | 9164484560 | 9164484560 | 9164484560 | None | 9164484560 | 9164484560 | 9164484560 | 9164484560 | None | 9164484560 | 9164484560 | 9164484560 | 9164484560 | None | 9164484560 | 9164484560 | 9164484560 | 9164484560 | None | 9164484560 | 9164484560 | 9164484560 | 9164484560 | None | 9164484560 | 9164484560 | 9164484560 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
[email protected] | None | [email protected] | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | None | [email protected] | None | None | None | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected] |
filer_id | 1147123 |
---|
filer_id | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
change_no | 1 | 0 | 3 | 2 | 4 | 5 | 6 | 7 | 9 | 10 | 11 | 12 | 13 | |||||||||||||
session_id | 1999 | 2001 | 2001 | 2001 | 2003 | 2007 | 2007 | 2007 | 2009 | 2011 | 2011 | 2013 | 2013 | |||||||||||||
log_dt | 2001-07-20 00:00:00 | 2001-12-26 00:00:00 | 2002-08-06 00:00:00 | 2002-07-29 00:00:00 | 2003-04-03 00:00:00 | 2007-02-05 00:00:00 | 2008-02-14 00:00:00 | 2008-01-31 00:00:00 | 2009-05-11 00:00:00 | 2012-08-20 00:00:00 | 2012-08-20 00:00:00 | 2013-07-31 00:00:00 | 2014-10-23 00:00:00 | |||||||||||||
filer_type | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | |||||||||||||
correction_flg | Y | Y | Y | Y | Y | Y | Y | Y | Y | None | None | None | None | |||||||||||||
action | DELETED | NEW | NEW | TERMINATED | DELETED | ADDED | TERMINATED | ADDED | ADDED | DELETED | TERMINATED | SET ACTIVE | DELETED | |||||||||||||
attribute_changed | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | LOBBYIST | |||||||||||||||
ethics_dt | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
interests | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
filer_full_name | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALIFORNIA PUBLIC INTEREST RESEARCH GROUP (CALPIRG) | CALPIRG | CALPIRG | CALPIRG (CALIFORNIA PUBLIC INTEREST RESEARCH GROUP) | CALPIRG, CALIFORNIA PUBLIC INTEREST RESEARCH GROUP | |||||||||||||
filer_city | None | None | SACRAMENTO | None | None | SACRAMENTO | None | SACRAMENTO | None | None | None | None | None | |||||||||||||
filer_st | None | None | CA | None | None | CA | None | CA | None | None | None | None | None | |||||||||||||
filer_zip | None | None | 95814 | None | None | 95814 | None | 95814 | None | None | None | None | None | |||||||||||||
filer_phone | None | None | 9164484516 | None | None | 9164484516 | None | 9164484516 | None | None | None | None | None | |||||||||||||
entity_type | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 2 | 2 | 4 | |||||||||||||
entity_name | JON GOLINGER | GERALD S. FLANAGAN | STEVEN BLACKLEDGE | FLANAGAN, GERALD S. | JACOBSON, DANIEL L. | BLACKLEDGE, STEVE | BLACKLEDGE, STEVE | MORILLAS, PEDRO | MORILLAS, PEDRO T. | PEDRO T. MORILLAS | None | None | GARO J. MANJIKIAN | |||||||||||||
entity_city | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
entity_st | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
entity_zip | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
entity_phone | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
entity_id | 1149233 | 1241557 | None | 1241557 | 1149654 | None | 1248539 | None | 1303744 | 1303744 | 0 | 0 | 1357432 | |||||||||||||
responsible_officer | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||
effect_dt | 1999-12-15 00:00:00 | 2001-12-01 00:00:00 | 2002-07-01 00:00:00 | 2002-05-31 00:00:00 | 2003-01-27 00:00:00 | 2007-01-01 00:00:00 | 2008-01-31 00:00:00 | 2007-09-01 00:00:00 | 2009-01-01 00:00:00 | 2012-08-16 00:00:00 | 2012-08-16 00:00:00 | 2013-01-01 00:00:00 | 2014-10-22 00:00:00 |
filer_id | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | 1147123 | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 798017_0.cal | 798019_0.cal | 16441.cal | 16712.cal | 17146.cal | 798017_1.cal | 798058_0.cal | 806113_0.cal | 834779_0.cal | 850034_0.cal | 893230_0.cal | 417692.cal | 417698.cal | 834779_1.cal | 850034_1.cal | 907432_0.cal | 907452_0.cal | 926153_0.cal | 942715_0.cal | 969583_1.cal | 977793_0.cal | 969583_0.cal | ||||||||||||||||||||||
received_date | 2001-11-16 00:00:00 | 2001-11-16 00:00:00 | 2001-11-16 00:00:00 | 2001-11-16 00:00:00 | 2001-11-16 00:00:00 | 2001-11-16 00:00:00 | 2001-11-16 00:00:00 | 2002-01-11 00:00:00 | 2002-04-12 00:00:00 | 2002-07-17 00:00:00 | 2002-11-19 00:00:00 | 2003-01-28 00:00:00 | 2003-01-28 00:00:00 | 2003-01-28 00:00:00 | 2003-01-28 00:00:00 | 2003-01-28 00:00:00 | 2003-01-28 00:00:00 | 2003-04-01 00:00:00 | 2003-07-18 00:00:00 | 2003-12-31 00:00:00 | 2003-12-31 00:00:00 | 2003-10-31 00:00:00 | ||||||||||||||||||||||
filing_directory | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/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/temp | /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 | ||||||||||||||||||||||
filing_id | 798017 | 798019 | None | None | None | 798017 | 798058 | 806113 | 834779 | 850034 | 893230 | None | None | 834779 | 850034 | 907432 | 907452 | 926153 | 942715 | 969583 | 977793 | 969583 | ||||||||||||||||||||||
form_id | F635 | F635 | None | None | None | F635 | F635 | F635 | F635 | F635 | F603 | None | None | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | ||||||||||||||||||||||
receive_comment | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted | Filing accepted | Filing accepted | Filing accepted, but with warnings | Filing passed validation, but failed DB constraints | Filing passed validation, but failed DB constraints | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings |