filer_id | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adrid | 1108204 | 2044603 | 2079834 | 2112892 | 2159029 | 2203071 | 2409748 | 2481093 | 2544623 | 2465146 | 2280501 | 2505891 | 2337287 | |||||||||||||
effect_dt | 1999-01-01 00:00:00 | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2007-01-01 00:00:00 | 2009-01-01 00:00:00 | 2011-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-02-01 00:00:00 | 2023-01-01 00:00:00 | 2019-01-15 00:00:00 | 2013-01-01 00:00:00 | 2021-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 | 2003 | 2005 | 2007 | 2009 | 2011 | 2017 | 2019 | 2023 | 2019 | 2013 | 2021 | 2015 |
filer_id | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_id | 499028 | 499235 | 499382 | 500237 | 499881 | 500726 | 502705 | 503375 | 500095 | 501562 | 501658 | 503275 | 502805 | 503834 | 499235 | 499382 | 500237 | 502229 | 498530 | 502229 | 502805 | 502805 | 500942 | 502133 | 501658 | 498530 | 501079 | 619091 | 632685 | 623653 | 681722 | 661517 | 695449 | 719940 | 703071 | 706891 | 753644 | 732722 | 746977 | 746977 | 738469 | 772076 | 776128 | 791808 | 780985 | 795739 | 814375 | 821469 | 840230 | 844644 | 861163 | 840230 | 853721 | 875966 | 892863 | 903218 | 909640 | 927759 | 883068 | 904046 | 919907 | 945502 | 931147 | 909640 | 936177 | 955014 | 931147 | 989806 | 989807 | 988215 | 968833 | 973220 | 931147 | 988215 | 1010342 | 1002389 | 1032639 | 1018350 | 1013844 | 1032639 | 1053933 | 1074628 | 1036533 | 1013844 | 1072464 | 1069545 | 1039246 | 1053933 | 1070257 | 1065718 | 1078598 | 1091688 | 1132517 | 1104059 | 1078598 | 1128970 | 1127388 | 1118178 | 1168062 | 1148550 | 1148550 | 1168062 | 1225290 | 1191833 | 1191833 | 1215494 | 1238133 | 1229006 | 1241018 | 1285096 | 1238133 | 1295272 | 1262417 | 1262417 | 1285096 | 1295272 | 1262417 | 1778170 | 1981039 | 1965257 | 1816719 | 1799991 | 1778170 | 1799991 | 1934243 | 1927975 | 1940229 | 1919563 | 1907134 | 1311569 | 1311569 | 1327620 | 1327620 | 1347256 | 1378063 | 1347256 | 1386795 | 1405597 | 1396139 | 1420358 | 1436819 | 1410721 | 1452119 | 1465502 | 1484217 | 1465502 | 1452119 | 1508050 | 1484217 | 1484217 | 1555080 | 1555598 | 1563277 | 1508050 | 1541002 | 1571578 | 1571578 | 1591926 | 1608022 | 1636786 | 1636786 | 1620526 | 1656962 | 1676147 | 1656962 | 1636786 | 1763751 | 1816719 | 1934243 | 1919159 | 1719918 | 1707265 | 1866583 | 1739010 | 1743768 | 1721024 | 1739010 | 1840998 | 1739010 | 1763751 | 2418070 | 2330549 | 2210886 | 2336390 | 2243160 | 2418070 | 2381309 | 2210886 | 2584754 | 2576866 | 2336390 | 2177267 | 2522763 | 2381309 | 2336390 | 1994777 | 2010650 | 2033377 | 2010650 | 2062412 | 2097427 | 2117757 | 2114797 | 2120641 | 2097427 | 2131199 | 2143538 | 2158210 | 2177267 | 2117757 | 2159155 | 2158210 | 2411086 | 2131199 | 2381309 | 2313097 | 2418070 | 2272191 | 2387617 | 2396923 | 2381309 | 2484032 | 2396923 | 2436974 | 2345229 | 2469380 | 2545843 | 2341957 | 2543987 | 2484032 | 2243160 | 2363073 | 2345229 | 2193271 | 2436974 | 2469380 | 2598354 | 2640849 | 2622672 | 2436974 | 2622672 | 2702539 | 2545843 | 2538890 | 2571815 | 2671912 | 2576866 | 2598354 | 2748436 | 2640849 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
period_id | 149 | 157 | 142 | 143 | 150 | 151 | 154 | 148 | 158 | 152 | 145 | 155 | 147 | 156 | 157 | 142 | 143 | 146 | 141 | 146 | 147 | 147 | 159 | 153 | 145 | 141 | 144 | 160 | 161 | 160 | 163 | 162 | 163 | 164 | None | None | 165 | 164 | 165 | 165 | 164 | 166 | 149 | 167 | None | None | 168 | None | 169 | None | None | 169 | 170 | None | None | None | 172 | None | 171 | None | None | 174 | 173 | 172 | None | None | 173 | None | None | 176 | 175 | None | 173 | 176 | None | None | 178 | None | 177 | 178 | 179 | None | None | 177 | None | None | None | 179 | 181 | None | 180 | None | 183 | 181 | 180 | None | None | 182 | 185 | 184 | 184 | 185 | 188 | 186 | 186 | 187 | 188 | None | None | 190 | 188 | 191 | 189 | 189 | 190 | 191 | 189 | 214 | 222 | 221 | 216 | 215 | 214 | 215 | 220 | None | None | 220 | 219 | 192 | 192 | 193 | 193 | 194 | 195 | 194 | 196 | None | 196 | 197 | 198 | None | 199 | 200 | 201 | 200 | 199 | 202 | 201 | 201 | None | 204 | None | 202 | 203 | 204 | 204 | 205 | 206 | 208 | 208 | 207 | 209 | 210 | 209 | 208 | 213 | 216 | 220 | 220 | None | 211 | 218 | 212 | None | 212 | 212 | 217 | 212 | 213 | 239 | 236 | 232 | 237 | 233 | 239 | 237 | 232 | None | 245 | 238 | 230 | 243 | 237 | 239 | 223 | 224 | 225 | 224 | 226 | 227 | 229 | 228 | None | 227 | 228 | None | 229 | 230 | 230 | None | 229 | None | 228 | 237 | 235 | 239 | 234 | None | 238 | 237 | 242 | 238 | 240 | 236 | 241 | 244 | None | 245 | 242 | 233 | None | 236 | 231 | 240 | 241 | 246 | 248 | 247 | 240 | 247 | 250 | 244 | 244 | None | 249 | 245 | 246 | 251 | 248 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
form_id | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F690 | F690 | F690 | F690 | F690 | F635 | F690 | F690 | F635 | F635 | F690 | F635 | F635 | F635 | F635 | F690 | F635 | F635 | F635 | F635 | F602 | F603 | F635 | F690 | F635 | F635 | F635 | F635 | F666 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F690 | F635 | F603 | F635 | F690 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F690 | F690 | F635 | F635 | F635 | F635 | F635 | F690 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F603 | F690 | F690 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F690 | F690 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F603 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F603 | F602 | F603 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F603 | F635 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F603 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F603 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | F602 | F635 | F603 | F635 | F635 | F635 | F635 | F603 | F635 | F603 | F635 | F635 | F635 | F603 | F635 | F635 | F635 | F635 | F635 | F635 | F603 | F602 | F603 | F635 | F635 | F602 | F635 | F635 | F603 | F605 | F635 | F605 | F635 | F635 | F635 | F635 | F635 | F605 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F603 | F603 | F635 | F635 | F602 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F602 | F602 | F635 | F635 | F635 | F635 | F635 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_sequence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 2 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 2 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 1 | 1 | 0 | 2 | 2 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 3 | 0 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_date | 1997-04-30 00:00:00 | 1999-04-30 00:00:00 | 1995-07-28 00:00:00 | 1995-10-31 00:00:00 | 1997-07-31 00:00:00 | 1997-10-31 00:00:00 | 1998-07-30 00:00:00 | 1997-01-31 00:00:00 | 1999-08-02 00:00:00 | 1998-02-02 00:00:00 | 1996-04-30 00:00:00 | 1998-11-02 00:00:00 | 1996-10-31 00:00:00 | 1999-01-29 00:00:00 | 1999-08-02 00:00:00 | 1996-01-26 00:00:00 | 1996-04-30 00:00:00 | 1996-08-21 00:00:00 | 1995-10-31 00:00:00 | 1996-07-30 00:00:00 | 1997-01-31 00:00:00 | 1997-01-28 00:00:00 | 1999-11-01 00:00:00 | 1998-04-30 00:00:00 | 1996-08-21 00:00:00 | 1995-05-01 00:00:00 | 1996-01-26 00:00:00 | 2000-01-31 00:00:00 | 2000-05-01 00:00:00 | 2000-03-03 00:00:00 | 2000-10-31 00:00:00 | 2000-07-31 00:00:00 | 2000-10-31 00:00:00 | 2001-02-01 00:00:00 | 2000-12-21 00:00:00 | 2001-01-02 00:00:00 | 2001-04-30 00:00:00 | 2001-02-01 00:00:00 | 2001-05-24 00:00:00 | 2001-05-01 00:00:00 | 2001-01-31 00:00:00 | 2001-07-30 00:00:00 | 2000-11-30 00:00:00 | 2001-10-31 00:00:00 | 2001-07-30 00:00:00 | 2001-10-31 00:00:00 | 2002-01-31 00:00:00 | 2002-01-31 00:00:00 | 2002-04-30 00:00:00 | 2002-05-01 00:00:00 | 2002-07-30 00:00:00 | 2002-09-23 00:00:00 | 2002-07-30 00:00:00 | 2002-09-24 00:00:00 | 2002-10-31 00:00:00 | 2003-01-10 00:00:00 | 2003-01-30 00:00:00 | 2003-04-02 00:00:00 | 2002-10-30 00:00:00 | 2002-12-31 00:00:00 | 2003-01-31 00:00:00 | 2003-07-29 00:00:00 | 2003-04-30 00:00:00 | 2003-03-21 00:00:00 | 2003-04-30 00:00:00 | 2003-07-31 00:00:00 | 2003-08-01 00:00:00 | 2003-10-30 00:00:00 | 2003-10-31 00:00:00 | 2004-01-29 00:00:00 | 2003-10-30 00:00:00 | 2003-10-30 00:00:00 | 2003-10-30 00:00:00 | 2004-04-08 00:00:00 | 2004-04-09 00:00:00 | 2004-01-30 00:00:00 | 2004-08-02 00:00:00 | 2004-04-30 00:00:00 | 2004-08-02 00:00:00 | 2004-10-25 00:00:00 | 2004-10-26 00:00:00 | 2005-01-03 00:00:00 | 2004-08-02 00:00:00 | 2004-04-30 00:00:00 | 2004-12-27 00:00:00 | 2004-10-29 00:00:00 | 2004-08-04 00:00:00 | 2005-01-26 00:00:00 | 2005-01-05 00:00:00 | 2004-10-29 00:00:00 | 2005-01-28 00:00:00 | 2005-01-31 00:00:00 | 2005-10-28 00:00:00 | 2005-04-29 00:00:00 | 2005-04-28 00:00:00 | 2005-01-31 00:00:00 | 2005-05-02 00:00:00 | 2005-08-01 00:00:00 | 2006-05-01 00:00:00 | 2006-01-31 00:00:00 | 2006-04-26 00:00:00 | 2006-07-27 00:00:00 | 2006-12-29 00:00:00 | 2006-10-30 00:00:00 | 2006-07-31 00:00:00 | 2006-10-30 00:00:00 | 2007-01-31 00:00:00 | 2006-12-28 00:00:00 | 2006-12-29 00:00:00 | 2007-07-31 00:00:00 | 2007-05-30 00:00:00 | 2008-01-29 00:00:00 | 2007-08-06 00:00:00 | 2007-04-30 00:00:00 | 2007-10-25 00:00:00 | 2007-10-26 00:00:00 | 2007-07-10 00:00:00 | 2013-07-25 00:00:00 | 2015-07-30 00:00:00 | 2015-04-30 00:00:00 | 2014-04-21 00:00:00 | 2013-10-30 00:00:00 | 2013-11-05 00:00:00 | 2013-10-31 00:00:00 | 2015-04-24 00:00:00 | 2014-12-29 00:00:00 | 2014-12-30 00:00:00 | 2014-12-22 00:00:00 | 2014-10-28 00:00:00 | 2008-04-22 00:00:00 | 2008-01-31 00:00:00 | 2008-04-28 00:00:00 | 2008-07-28 00:00:00 | 2008-07-28 00:00:00 | 2008-10-31 00:00:00 | 2008-10-22 00:00:00 | 2008-12-31 00:00:00 | 2008-12-31 00:00:00 | 2009-01-30 00:00:00 | 2009-04-29 00:00:00 | 2009-07-30 00:00:00 | 2008-12-31 00:00:00 | 2010-02-01 00:00:00 | 2010-04-29 00:00:00 | 2010-04-29 00:00:00 | 2010-02-01 00:00:00 | 2009-10-30 00:00:00 | 2010-08-02 00:00:00 | 2010-08-02 00:00:00 | 2010-11-01 00:00:00 | 2010-12-23 00:00:00 | 2010-12-30 00:00:00 | 2010-12-30 00:00:00 | 2010-11-01 00:00:00 | 2010-11-01 00:00:00 | 2011-01-31 00:00:00 | 2011-04-27 00:00:00 | 2011-05-02 00:00:00 | 2011-08-01 00:00:00 | 2012-01-31 00:00:00 | 2012-04-27 00:00:00 | 2011-10-27 00:00:00 | 2012-07-27 00:00:00 | 2012-07-27 00:00:00 | 2012-04-30 00:00:00 | 2012-04-30 00:00:00 | 2013-11-05 00:00:00 | 2014-01-30 00:00:00 | 2015-01-30 00:00:00 | 2014-12-19 00:00:00 | 2012-12-21 00:00:00 | 2012-10-30 00:00:00 | 2014-07-25 00:00:00 | 2013-01-31 00:00:00 | 2012-12-28 00:00:00 | 2012-12-28 00:00:00 | 2013-01-31 00:00:00 | 2014-04-24 00:00:00 | 2013-04-23 00:00:00 | 2013-04-29 00:00:00 | 2020-01-27 00:00:00 | 2018-12-28 00:00:00 | 2018-01-31 00:00:00 | 2019-01-18 00:00:00 | 2018-07-26 00:00:00 | 2019-10-30 00:00:00 | 2019-07-25 00:00:00 | 2018-04-25 00:00:00 | 2021-01-21 00:00:00 | 2021-04-26 00:00:00 | 2019-04-30 00:00:00 | 2017-10-30 00:00:00 | 2020-10-26 00:00:00 | 2019-07-30 00:00:00 | 2019-08-13 00:00:00 | 2015-10-27 00:00:00 | 2016-01-29 00:00:00 | 2016-04-27 00:00:00 | 2016-04-26 00:00:00 | 2016-07-29 00:00:00 | 2016-10-27 00:00:00 | 2017-01-06 00:00:00 | 2016-12-29 00:00:00 | 2017-01-09 00:00:00 | 2016-12-14 00:00:00 | 2017-01-31 00:00:00 | 2016-12-29 00:00:00 | 2017-05-01 00:00:00 | 2017-07-31 00:00:00 | 2017-05-01 00:00:00 | 2017-04-18 00:00:00 | 2017-06-13 00:00:00 | 2019-08-14 00:00:00 | 2017-06-08 00:00:00 | 2019-04-30 00:00:00 | 2018-10-25 00:00:00 | 2020-01-24 00:00:00 | 2018-07-30 00:00:00 | 2019-04-30 00:00:00 | 2019-07-30 00:00:00 | 2020-01-24 00:00:00 | 2020-07-30 00:00:00 | 2020-01-27 00:00:00 | 2020-01-28 00:00:00 | 2019-01-30 00:00:00 | 2020-07-29 00:00:00 | 2021-05-28 00:00:00 | 2019-01-15 00:00:00 | 2021-01-13 00:00:00 | 2020-10-20 00:00:00 | 2018-04-30 00:00:00 | 2018-12-28 00:00:00 | 2019-04-30 00:00:00 | 2017-10-31 00:00:00 | 2020-04-29 00:00:00 | 2020-04-29 00:00:00 | 2021-07-28 00:00:00 | 2022-01-28 00:00:00 | 2021-10-29 00:00:00 | 2021-09-23 00:00:00 | 2022-01-27 00:00:00 | 2022-07-27 00:00:00 | 2021-01-22 00:00:00 | 2020-12-29 00:00:00 | 2020-12-30 00:00:00 | 2022-04-27 00:00:00 | 2021-10-28 00:00:00 | 2022-01-26 00:00:00 | 2022-10-31 00:00:00 | 2022-09-30 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_type | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10001 | 10005 | 10005 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10005 | 10005 | 10005 | 10002 | 10001 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10001 | 10005 | 10001 | 10005 | 10005 | 10002 | 10001 | 10006 | 10005 | 10005 | 10001 | 10006 | 10001 | 10005 | 10005 | 10001 | 10001 | 10002 | 10005 | 10005 | 10002 | 10006 | 10006 | 10001 | 10001 | 10005 | 10002 | 10002 | 10006 | 10005 | 10001 | 10005 | 10002 | 10002 | 10001 | 10005 | 10005 | 10001 | 10005 | 10006 | 10006 | 10002 | 10001 | 10005 | 10001 | 10005 | 10001 | 10001 | 10002 | 10005 | 10006 | 10001 | 10001 | 10001 | 10002 | 10002 | 10001 | 10002 | 10001 | 10001 | 10001 | 10005 | 10005 | 10001 | 10002 | 10002 | 10002 | 10001 | 10002 | 10001 | 10002 | 10001 | 10001 | 10001 | 10002 | 10001 | 10002 | 10002 | 10002 | 10005 | 10005 | 10001 | 10001 | 10002 | 10001 | 10001 | 10002 | 10001 | 10001 | 10002 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10002 | 10002 | 10001 | 10001 | 10001 | 10001 | 10002 | 10002 | 10005 | 10001 | 10005 | 10002 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10002 | 10001 | 10002 | 10001 | 10001 | 10002 | 10002 | 10001 | 10001 | 10001 | 10005 | 10001 | 10001 | 10001 | 10005 | 10001 | 10002 | 10001 | 10002 | 10001 | 10002 | 10001 | 10001 | 10001 | 10002 | 10001 | 10002 | 10002 | 10005 | 10001 | 10002 | 10002 | 10001 | 10002 | 10002 | 10001 | 10001 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10005 | 10002 | 10001 | 10005 | 10001 | 10001 | 10002 | 10006 | 10002 | 10005 | 10002 | 10001 | 10001 | 10002 | 10001 | 10006 | 10001 | 10002 | 10001 | 10002 | 10001 | 10001 | 10002 | 10002 | 10005 | 10001 | 10002 | 10001 | 10005 | 10002 | 10001 | 10002 | 10001 | 10001 | 10001 | 10001 | 10002 | 10002 | 10001 | 10001 | 10001 | 10005 | 10001 | 10002 | 10002 | 10001 | 10002 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
stmnt_status | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 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 | 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 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
session_id | 1997 | 1999 | 1995 | 1995 | 1997 | 1997 | 1997 | 1995 | 1999 | 1997 | 1995 | 1997 | 1995 | 1997 | 1999 | 1995 | 1995 | 1995 | 1995 | 1995 | 1995 | 1995 | 1999 | 1997 | 1995 | 1995 | 1995 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 1999 | 2001 | 2001 | 2001 | 1999 | 2001 | 2001 | 1999 | 2001 | 1997 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2001 | 2003 | 2001 | 2001 | 2001 | 2003 | 2001 | 2003 | 2003 | 2001 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2005 | 2003 | 2003 | 2005 | 2005 | 2003 | 2003 | 2005 | 2003 | 2003 | 2003 | 2005 | 2005 | 2003 | 2003 | 2003 | 2005 | 2005 | 2005 | 2005 | 2005 | 2007 | 2005 | 2005 | 2005 | 2005 | 2007 | 2007 | 2007 | 2005 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2013 | 2015 | 2015 | 2013 | 2013 | 2013 | 2013 | 2013 | 2015 | 2015 | 2015 | 2013 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2007 | 2009 | 2009 | 2007 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2011 | 2011 | 2011 | 2009 | 2009 | 2009 | 2009 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2013 | 2013 | 2013 | 2015 | 2013 | 2011 | 2013 | 2011 | 2013 | 2013 | 2011 | 2013 | 2011 | 2013 | 2019 | 2019 | 2017 | 2019 | 2017 | 2019 | 2019 | 2017 | 2021 | 2021 | 2019 | 2017 | 2019 | 2019 | 2019 | 2015 | 2015 | 2015 | 2015 | 2015 | 2015 | 2017 | 2017 | 2017 | 2015 | 2015 | 2017 | 2017 | 2017 | 2017 | 2017 | 2017 | 2019 | 2015 | 2019 | 2017 | 2019 | 2017 | 2019 | 2019 | 2019 | 2019 | 2019 | 2019 | 2017 | 2019 | 2019 | 2019 | 2021 | 2019 | 2017 | 2019 | 2017 | 2017 | 2019 | 2019 | 2021 | 2021 | 2021 | 2019 | 2021 | 2021 | 2019 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
user_id | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | TTHAM | TTHAM | * | YBONILLA | YBONILLA | * | NJACKSON | DHORRELL | YBONILLA | GPEREZ | * | * | GPEREZ | * | PROBERTS | DBARRICK | LTHIBAUL | LTHIBAUL | * | LTHIBAUL | * | LTHIBAUL | LTHIBAUL | * | * | LTHIBAUL | LTHIBAUL | GPEREZ | COMPLETED | LTHIBAUL | * | GPEREZ | LTHIBAUL | COMPLETED | COMPLETED | COMPLETED | LTHIBAUL | LTHIBAUL | COMPLETED | YBONILLA | YBONILLA | COMPLETED | COMPLETED | LTHIBAUL | COMPLETED | COMPLETED | EMCENTEE | LTHIBAUL | COMPLETED | LTHIBAUL | COMPLETED | COMPLETED | COMPLETED | CFLAGG | EMCENTEE | COMPLETED | SARRIAGA | EMCENTEE | EMCENTEE | COMPLETED | COMPLETED | LTHIBAUL | COMPLETED | LTHIBAUL | LTHIBAUL | LTHIBAUL | * | GGILMORE | GGILMORE | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | * | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | YRODRIGU | CFLAGG | LTHIBAUL | LTHIBAUL | YRODRIGU | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | LTHIBAUL | AGLADNEY | MPACHECO | MPACHECO | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | MPACHECO | SARRIAGA | GPEREZ | CAFILER | AGLADNEY | LTHIBAUL | LTHIBAUL | LTHIBAUL | YRODRIGU | LTHIBAUL | MGUERRA | LTHIBAUL | * | SARRIAGA | MGUERRA | MGUERRA | MGUERRA | SARRIAGA | WBROWN | ASAETERN | ASAETERN | WBROWN | MGUERRA | ASAETERN | ASAETERN | ASAETERN | YRODRIGU | YRODRIGU | YRODRIGU | ASAETERN | ASAETERN | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | ASAETERN | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | AGLADNEY | ASAETERN | MPACHECO | CAFILER | SARRIAGA | AGLADNEY | AGLADNEY | AGLADNEY | SARRIAGA | SARRIAGA | AGLADNEY | ASAETERN | AGLADNEY | AGLADNEY | AGLADNEY | YRODRIGU | AGLADNEY | GPEREZ | AGLADNEY | VUKSTINA | AGLADNEY | AGLADNEY | JMENDOZA | CHATRIDGE | YRODRIGU | AGLADNEY | GTAYLOR | AGLADNEY | SARRIAGA | AGLADNEY | AGLADNEY | JINGRAM | AGLADNEY | AGLADNEY | AGLADNEY | YRODRIGU | YRODRIGU | YRODRIGU | AGLADNEY | AGLADNEY | YRODRIGU | AGLADNEY | AGLADNEY | YRODRIGU | YRODRIGU | AGLADNEY | SARRIAGA | AGLADNEY | VUKSTINA | AGLADNEY | AGLADNEY | AGLADNEY | YRODRIGU | VUKSTINA | GTAYLOR | MKIRKHAM | GTAYLOR | VUKSTINA | AGLADNEY | GTAYLOR | GTAYLOR | GPEREZ | JMENDOZA | GTAYLOR | AGLADNEY | YRODRIGU | AGLADNEY | AGLADNEY | GTAYLOR | VUKSTINA | MKIRKHAM | CHATRIDGE | GTAYLOR | CAFILER | GTAYLOR | CAFILER | GTAYLOR | AROJAS | AROJAS | CAFILER | CHATRIDGE | MKIRKHAM | CAFILER | CAFILER | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
special_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11002 | 11003 | 11003 | 11003 | 11002 | 11003 | 11002 | 11002 | 11003 | 11003 | 11003 | 11002 | 11003 | 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 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fine_audit | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 11003 | 11003 | 11003 | 11001 | 11003 | 11003 | 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 | 11003 | 11003 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11003 | 11001 | 11001 | 11003 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11001 | 11003 | 11001 | 11003 | 11001 | 11003 | 11003 | 11003 | 11001 | 11001 | 11003 | 11003 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_start | 1997-01-01 00:00:00 | 1999-01-01 00:00:00 | 1995-04-01 00:00:00 | 1995-07-01 00:00:00 | 1997-04-01 00:00:00 | 1997-07-01 00:00:00 | 1998-04-01 00:00:00 | 1996-10-01 00:00:00 | 1999-04-01 00:00:00 | 1997-10-01 00:00:00 | 1996-01-01 00:00:00 | 1998-07-01 00:00:00 | 1996-07-01 00:00:00 | 1998-10-01 00:00:00 | 1999-01-01 00:00:00 | 1995-04-01 00:00:00 | 1995-07-01 00:00:00 | 1996-04-01 00:00:00 | 1995-01-01 00:00:00 | 1996-04-01 00:00:00 | 1996-07-01 00:00:00 | 1996-07-01 00:00:00 | 1999-07-01 00:00:00 | 1998-01-01 00:00:00 | 1996-01-01 00:00:00 | 1995-01-01 00:00:00 | 1995-10-01 00:00:00 | 1999-10-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-07-01 00:00:00 | 2000-10-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2001-01-01 00:00:00 | 2000-10-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2000-10-01 00:00:00 | 2001-04-01 00:00:00 | 1997-01-01 00:00:00 | 2001-07-01 00:00:00 | 2001-04-01 00:00:00 | 2001-07-01 00:00:00 | 2001-10-01 00:00:00 | 2001-10-01 00:00:00 | 2002-01-01 00:00:00 | 2002-01-01 00:00:00 | 2002-04-01 00:00:00 | 2002-01-01 00:00:00 | 2002-04-01 00:00:00 | 2002-01-01 00:00:00 | 2002-07-01 00:00:00 | 1900-01-01 00:00:00 | 2002-10-01 00:00:00 | 2002-10-01 00:00:00 | 2002-07-01 00:00:00 | 1900-01-01 00:00:00 | 2002-10-01 00:00:00 | 2003-04-01 00:00:00 | 2003-01-01 00:00:00 | 2002-10-01 00:00:00 | 2003-01-01 00:00:00 | 2003-04-01 00:00:00 | 2003-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-01-01 00:00:00 | 2003-10-01 00:00:00 | 2003-07-01 00:00:00 | 2003-07-01 00:00:00 | 2003-01-01 00:00:00 | 2003-10-01 00:00:00 | 2003-10-01 00:00:00 | 2003-10-01 00:00:00 | 2004-04-01 00:00:00 | 2004-01-01 00:00:00 | 2004-01-01 00:00:00 | 2004-04-01 00:00:00 | 2004-07-01 00:00:00 | 1900-01-01 00:00:00 | 2004-04-01 00:00:00 | 2004-01-01 00:00:00 | 1900-01-01 00:00:00 | 2004-04-01 00:00:00 | 2004-01-01 00:00:00 | 2004-07-01 00:00:00 | 2005-01-04 00:00:00 | 2004-07-01 00:00:00 | 2004-10-01 00:00:00 | 2004-10-01 00:00:00 | 2005-07-01 00:00:00 | 2005-01-01 00:00:00 | 2004-10-01 00:00:00 | 2004-07-01 00:00:00 | 2004-10-01 00:00:00 | 2005-04-01 00:00:00 | 2006-01-01 00:00:00 | 2005-10-01 00:00:00 | 2005-10-01 00:00:00 | 2006-01-01 00:00:00 | 2006-12-01 00:00:00 | 2006-04-01 00:00:00 | 2006-04-01 00:00:00 | 2006-07-01 00:00:00 | 2006-10-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2007-04-01 00:00:00 | 2006-10-01 00:00:00 | 2007-07-01 00:00:00 | 2007-01-01 00:00:00 | 2007-01-01 00:00:00 | 2007-04-01 00:00:00 | 2007-07-01 00:00:00 | 2007-01-01 00:00:00 | 2013-04-01 00:00:00 | 2015-04-01 00:00:00 | 2015-01-01 00:00:00 | 2013-10-01 00:00:00 | 2013-07-01 00:00:00 | 2013-04-01 00:00:00 | 2013-07-01 00:00:00 | 2014-10-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2014-12-22 00:00:00 | 2014-07-01 00:00:00 | 2007-10-01 00:00:00 | 2007-10-01 00:00:00 | 2008-01-01 00:00:00 | 2008-01-01 00:00:00 | 2008-04-01 00:00:00 | 2008-07-01 00:00:00 | 2008-04-01 00:00:00 | 2008-12-20 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-10-01 00:00:00 | 2010-01-01 00:00:00 | 2009-10-01 00:00:00 | 2009-07-01 00:00:00 | 2010-04-01 00:00:00 | 2010-01-01 00:00:00 | 2010-01-01 00:00:00 | 1900-01-01 00:00:00 | 2010-11-15 00:00:00 | 1900-01-01 00:00:00 | 2010-04-01 00:00:00 | 2010-07-01 00:00:00 | 2010-10-01 00:00:00 | 2010-10-01 00:00:00 | 2011-01-01 00:00:00 | 2011-04-01 00:00:00 | 2011-10-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 | 2011-10-01 00:00:00 | 2013-01-01 00:00:00 | 2013-10-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-17 00:00:00 | 1900-01-01 00:00:00 | 2012-07-01 00:00:00 | 2014-04-01 00:00:00 | 2012-10-01 00:00:00 | 1900-01-01 00:00:00 | 2012-11-13 00:00:00 | 2012-10-01 00:00:00 | 2014-01-01 00:00:00 | 2012-10-01 00:00:00 | 2013-01-01 00:00:00 | 2019-07-01 00:00:00 | 2018-11-27 00:00:00 | 2017-10-01 00:00:00 | 2019-01-18 00:00:00 | 2018-01-01 00:00:00 | 2019-07-01 00:00:00 | 2019-01-01 00:00:00 | 2017-10-01 00:00:00 | 1900-01-01 00:00:00 | 2021-01-01 00:00:00 | 2019-04-30 00:00:00 | 2017-04-01 00:00:00 | 2020-07-01 00:00:00 | 2019-01-01 00:00:00 | 2019-08-13 00:00:00 | 2015-07-01 00:00:00 | 2015-10-01 00:00:00 | 2016-01-01 00:00:00 | 2015-10-01 00:00:00 | 2016-04-01 00:00:00 | 2016-07-07 00:00:00 | 2017-01-06 00:00:00 | 2016-11-17 00:00:00 | 1900-01-01 00:00:00 | 2016-07-01 00:00:00 | 2016-10-01 00:00:00 | 1900-01-01 00:00:00 | 2017-01-01 00:00:00 | 2017-04-01 00:00:00 | 2017-05-01 00:00:00 | 1900-01-01 00:00:00 | 2017-01-01 00:00:00 | 1900-01-01 00:00:00 | 2016-10-01 00:00:00 | 2019-01-01 00:00:00 | 2018-07-01 00:00:00 | 2019-07-01 00:00:00 | 2018-04-01 00:00:00 | 1900-01-01 00:00:00 | 2019-04-01 00:00:00 | 2019-01-01 00:00:00 | 2020-04-01 00:00:00 | 2019-04-01 00:00:00 | 2019-10-01 00:00:00 | 2018-10-01 00:00:00 | 2020-01-01 00:00:00 | 2020-10-01 00:00:00 | 1900-01-01 00:00:00 | 2021-01-13 00:00:00 | 2020-04-01 00:00:00 | 2018-01-01 00:00:00 | 1900-01-01 00:00:00 | 2018-10-01 00:00:00 | 2017-07-01 00:00:00 | 2019-10-01 00:00:00 | 2020-01-01 00:00:00 | 2021-04-01 00:00:00 | 2021-10-31 00:00:00 | 2021-07-01 00:00:00 | 2019-10-01 00:00:00 | 2021-07-01 00:00:00 | 2022-04-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-21 00:00:00 | 1900-01-01 00:00:00 | 2022-01-01 00:00:00 | 2021-01-01 00:00:00 | 2021-04-01 00:00:00 | 2022-07-01 00:00:00 | 2021-10-31 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_end | 1997-03-31 00:00:00 | 1999-03-31 00:00:00 | 1995-06-30 00:00:00 | 1995-09-30 00:00:00 | 1997-06-30 00:00:00 | 1997-09-30 00:00:00 | 1998-06-30 00:00:00 | 1996-12-31 00:00:00 | 1999-06-30 00:00:00 | 1997-12-31 00:00:00 | 1996-03-31 00:00:00 | 1998-09-30 00:00:00 | 1996-09-30 00:00:00 | 1998-12-31 00:00:00 | 1999-03-31 00:00:00 | 1995-06-30 00:00:00 | 1995-09-30 00:00:00 | 1996-06-30 00:00:00 | 1995-03-31 00:00:00 | 1996-06-30 00:00:00 | 1996-09-30 00:00:00 | 1996-09-30 00:00:00 | 1999-09-30 00:00:00 | 1998-03-31 00:00:00 | 1996-03-31 00:00:00 | 1995-03-31 00:00:00 | 1995-12-31 00:00:00 | 1999-12-31 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-09-30 00:00:00 | 2000-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2001-03-31 00:00:00 | 2000-12-31 00:00:00 | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 | 2000-12-31 00:00:00 | 2001-06-30 00:00:00 | 1998-12-31 00:00:00 | 2001-09-30 00:00:00 | 2001-06-30 00:00:00 | 2001-09-30 00:00:00 | 2001-12-31 00:00:00 | 2001-12-31 00:00:00 | 2002-03-31 00:00:00 | 2002-03-31 00:00:00 | 2002-06-30 00:00:00 | 2002-03-31 00:00:00 | 2002-06-30 00:00:00 | 2002-03-31 00:00:00 | 2002-09-30 00:00:00 | 1900-01-01 00:00:00 | 2002-12-31 00:00:00 | 2002-12-31 00:00:00 | 2002-09-30 00:00:00 | 1900-01-01 00:00:00 | 2002-12-31 00:00:00 | 2003-06-30 00:00:00 | 2003-03-31 00:00:00 | 2002-12-31 00:00:00 | 2003-03-31 00:00:00 | 2003-06-30 00:00:00 | 2003-03-31 00:00:00 | 2003-03-31 00:00:00 | 2003-03-31 00:00:00 | 2003-12-31 00:00:00 | 2003-09-30 00:00:00 | 2003-09-30 00:00:00 | 2003-03-31 00:00:00 | 2003-12-31 00:00:00 | 2003-12-31 00:00:00 | 2003-12-31 00:00:00 | 2004-06-30 00:00:00 | 2004-03-31 00:00:00 | 2004-03-31 00:00:00 | 2004-06-30 00:00:00 | 2004-09-30 00:00:00 | 1900-01-01 00:00:00 | 2004-06-30 00:00:00 | 2004-03-31 00:00:00 | 1900-01-01 00:00:00 | 2004-06-30 00:00:00 | 2004-03-31 00:00:00 | 2004-09-30 00:00:00 | 2005-01-04 00:00:00 | 2004-09-30 00:00:00 | 2004-12-31 00:00:00 | 2004-12-31 00:00:00 | 2005-09-30 00:00:00 | 2005-03-31 00:00:00 | 2004-12-31 00:00:00 | 2004-09-30 00:00:00 | 2004-12-31 00:00:00 | 2005-06-30 00:00:00 | 2006-03-31 00:00:00 | 2005-12-31 00:00:00 | 2005-12-31 00:00:00 | 2006-03-31 00:00:00 | 2006-12-01 00:00:00 | 2006-06-30 00:00:00 | 2006-06-30 00:00:00 | 2006-09-30 00:00:00 | 2006-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2007-06-30 00:00:00 | 2006-12-31 00:00:00 | 2007-09-30 00:00:00 | 2007-03-31 00:00:00 | 2007-03-31 00:00:00 | 2007-06-30 00:00:00 | 2007-09-30 00:00:00 | 2007-03-31 00:00:00 | 2013-06-30 00:00:00 | 2015-06-30 00:00:00 | 2015-03-31 00:00:00 | 2013-12-31 00:00:00 | 2013-09-30 00:00:00 | 2013-06-30 00:00:00 | 2013-09-30 00:00:00 | 2014-12-31 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2014-12-22 00:00:00 | 2014-09-30 00:00:00 | 2007-12-31 00:00:00 | 2007-12-31 00:00:00 | 2008-03-31 00:00:00 | 2008-03-31 00:00:00 | 2008-06-30 00:00:00 | 2008-09-30 00:00:00 | 2008-06-30 00:00:00 | 2008-12-20 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-12-31 00:00:00 | 2010-03-31 00:00:00 | 2009-12-31 00:00:00 | 2009-09-30 00:00:00 | 2010-06-30 00:00:00 | 2010-03-31 00:00:00 | 2010-03-31 00:00:00 | 1900-01-01 00:00:00 | 2010-11-15 00:00:00 | 1900-01-01 00:00:00 | 2010-06-30 00:00:00 | 2010-09-30 00:00:00 | 2010-12-31 00:00:00 | 2010-12-31 00:00:00 | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 2011-12-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 | 2011-12-31 00:00:00 | 2013-03-31 00:00:00 | 2013-12-31 00:00:00 | 2014-12-31 00:00:00 | 2014-11-17 00:00:00 | 1900-01-01 00:00:00 | 2012-09-30 00:00:00 | 2014-06-30 00:00:00 | 2012-12-31 00:00:00 | 1900-01-01 00:00:00 | 2012-11-13 00:00:00 | 2012-12-31 00:00:00 | 2014-03-31 00:00:00 | 2012-12-31 00:00:00 | 2013-03-31 00:00:00 | 2019-09-30 00:00:00 | 2018-11-27 00:00:00 | 2017-12-31 00:00:00 | 2019-01-18 00:00:00 | 2018-03-31 00:00:00 | 2019-09-30 00:00:00 | 2019-03-31 00:00:00 | 2017-12-31 00:00:00 | 1900-01-01 00:00:00 | 2021-03-31 00:00:00 | 2019-04-30 00:00:00 | 2017-06-30 00:00:00 | 2020-09-30 00:00:00 | 2019-03-31 00:00:00 | 2019-08-13 00:00:00 | 2015-09-30 00:00:00 | 2015-12-31 00:00:00 | 2016-03-31 00:00:00 | 2015-12-31 00:00:00 | 2016-06-30 00:00:00 | 2016-09-30 00:00:00 | 2017-01-06 00:00:00 | 2016-11-17 00:00:00 | 1900-01-01 00:00:00 | 2016-09-30 00:00:00 | 2016-12-31 00:00:00 | 1900-01-01 00:00:00 | 2017-03-31 00:00:00 | 2017-06-30 00:00:00 | 2017-05-01 00:00:00 | 1900-01-01 00:00:00 | 2017-03-31 00:00:00 | 1900-01-01 00:00:00 | 2016-12-31 00:00:00 | 2019-03-31 00:00:00 | 2018-09-30 00:00:00 | 2019-09-30 00:00:00 | 2018-06-30 00:00:00 | 1900-01-01 00:00:00 | 2019-06-30 00:00:00 | 2019-03-31 00:00:00 | 2020-06-30 00:00:00 | 2019-06-30 00:00:00 | 2019-12-31 00:00:00 | 2018-12-31 00:00:00 | 2020-03-31 00:00:00 | 2020-12-31 00:00:00 | 1900-01-01 00:00:00 | 2021-01-13 00:00:00 | 2020-06-30 00:00:00 | 2018-03-31 00:00:00 | 1900-01-01 00:00:00 | 2018-12-31 00:00:00 | 2017-09-30 00:00:00 | 2019-12-31 00:00:00 | 2020-03-31 00:00:00 | 2021-06-30 00:00:00 | 2021-12-31 00:00:00 | 2021-09-30 00:00:00 | 2019-12-31 00:00:00 | 2021-09-30 00:00:00 | 2022-06-30 00:00:00 | 2020-12-31 00:00:00 | 2020-11-21 00:00:00 | 1900-01-01 00:00:00 | 2022-03-31 00:00:00 | 2021-03-31 00:00:00 | 2021-06-30 00:00:00 | 2022-09-30 00:00:00 | 2021-12-31 00:00:00 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
rpt_date | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filing_type | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 22001 | None | None | None | None | 22006 | 22006 | 22001 | None | None | 22006 | None | None | 22006 | 22006 | None | 22006 | 22006 | None | None | 22006 | None | 22006 | 22006 | 22006 | None | None | 22006 | None | None | None | 22006 | 22001 | None | 22006 | None | 22006 | 22006 | 22006 | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22001 | 22006 | 22006 | 22006 | 22006 | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22001 | None | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22001 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22001 | None | 22006 | 22006 | 22006 | None | 22001 | 22006 | 22006 | 22006 | 22006 | 22006 | 22001 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22001 | None | 22006 | 22006 | None | 22006 | 22006 | 22006 | None | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | None | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22006 | 22001 | None | 22006 | 22006 | 22006 | 22006 | 22006 |
filer_id | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
session_id | 2003 | 2005 | 2001 | 1999 | 1995 | 1997 | 2009 | 2007 | 2013 | 2011 | 2017 | 2015 | 2021 | 2019 | 2023 | |||||||||||||||
interest_cd | 40315 | 40315 | 40315 | 40315 | 40315 | 40315 | 40315 | 40315 | 40315 | 40315 | 40315 | 40315 | 40315 | 40315 | 40315 | |||||||||||||||
effect_date | 2003-01-01 00:00:00 | 2005-01-01 00:00:00 | 2001-01-01 00:00:00 | 1999-01-01 00:00:00 | 1995-01-01 00:00:00 | 1997-01-01 00:00:00 | 2009-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 | 2021-01-01 00:00:00 | 2019-01-15 00:00:00 | 2023-01-01 00:00:00 |
filer_id | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_type | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | |||||||||||||||
active | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | N | |||||||||||||||
race | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
session_id | 1997 | 1995 | 1999 | 2001 | 2003 | 2005 | 2007 | 2013 | 2011 | 2009 | 2021 | 2015 | 2017 | 2019 | 2023 | |||||||||||||||
category | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
category_type | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
sub_category | 0 | 0 | 0 | 0 | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
effect_dt | 1997-01-01 00:00:00 | 1995-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 | 2011-01-01 00:00:00 | 2009-01-01 00:00:00 | 2021-01-01 00:00:00 | 2015-01-01 00:00:00 | 2017-01-01 00:00:00 | 2019-01-15 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 | None | None | None | None | None | None | None | |||||||||||||||
party_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
county_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | |||||||||||||||
district_cd | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None |
filer_id | 1146765 | |
---|---|---|
xref_id | E00030 | |
effect_dt | 1999-12-08 00:00:00 | |
migration_source | MASTER |
xref_filer_id | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | E00030 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filer_id | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
filer_type | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | EMPLOYER | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
status | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | INACTIVE | 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 | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL, THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL; THE | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL | AMERICAN INSTITUTE OF ARCHITECTS CALIFORNIA | AMERICAN INSTITUTE OF ARCHITECTS CALIFORNIA | AMERICAN INSTITUTE OF ARCHITECTS CALIFORNIA | AMERICAN INSTITUTE OF ARCHITECTS CALIFORNIA | AMERICAN INSTITUTE OF ARCHITECTS CALIFORNIA | AMERICAN INSTITUTE OF ARCHITECTS CALIFORNIA | AMERICAN INSTITUTE OF ARCHITECTS CALIFORNIA | AMERICAN INSTITUTE OF ARCHITECTS CALIFORNIA | AMERICAN INSTITUTE OF ARCHITECTS CALIFORNIA | AMERICAN INSTITUTE OF ARCHITECTS CALIFORNIA | AMERICAN INSTITUTE OF ARCHITECTS CALIFORNIA | AMERICAN INSTITUTE OF ARCHITECTS CALIFORNIA | AMERICAN INSTITUTE OF ARCHITECTS CALIFORNIA | AMERICAN INSTITUTE OF ARCHITECTS CALIFORNIA | AMERICAN INSTITUTE OF ARCHITECTS CALIFORNIA | AMERICAN INSTITUTE OF ARCHITECTS CALIFORNIA | AMERICAN INSTITUTE OF ARCHITECTS CALIFORNIA | AMERICAN INSTITUTE OF ARCHITECTS CALIFORNIA | AMERICAN INSTITUTE OF ARCHITECTS CALIFORNIA | AMERICAN INSTITUTE OF ARCHITECTS CALIFORNIA | AMERICAN INSTITUTE OF ARCHITECTS CALIFORNIA | AMERICAN INSTITUTE OF ARCHITECTS CALIFORNIA | AMERICAN INSTITUTE OF ARCHITECTS CALIFORNIA | AMERICAN INSTITUTE OF ARCHITECTS CALIFORNIA | AMERICAN INSTITUTE OF ARCHITECTS CALIFORNIA | AMERICAN INSTITUTE OF ARCHITECTS CALIFORNIA | AMERICAN INSTITUTE OF ARCHITECTS CALIFORNIA | AMERICAN INSTITUTE OF ARCHITECTS CALIFORNIA | AMERICAN INSTITUTE OF ARCHITECTS CALIFORNIA | AMERICAN INSTITUTE OF ARCHITECTS CALIFORNIA | AMERICAN INSTITUTE OF ARCHITECTS CALIFORNIA | AMERICAN INSTITUTE OF ARCHITECTS CALIFORNIA | AMERICAN INSTITUTE OF ARCHITECTS CALIFORNIA | AMERICAN INSTITUTE OF ARCHITECTS CALIFORNIA | AMERICAN INSTITUTE OF ARCHITECTS CALIFORNIA | AMERICAN INSTITUTE OF ARCHITECTS CALIFORNIA | AMERICAN INSTITUTE OF ARCHITECTS CALIFORNIA | AMERICAN INSTITUTE OF ARCHITECTS CALIFORNIA | AMERICAN INSTITUTE OF ARCHITECTS CALIFORNIA | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95811 | 95811 | 95811 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95811 | 95811 | 95811 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95811 | 95811 | 95811 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95811 | 95811 | 95811 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95811 | 95811 | 95811 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95811 | 95811 | 95811 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95811 | 95811 | 95811 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95811 | 95811 | 95811 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95811 | 95811 | 95811 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95811 | 95811 | 95811 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95811 | 95811 | 95811 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95811 | 95811 | 95811 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95811 | 95811 | 95811 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95814 | 95811 | 95811 | 95811 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
phon | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | 9164489082 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
fax | None | None | None | 9164425346 | 9164425346 | 9164425346 | 9164425346 | None | None | None | 9164425346 | 9164425346 | 9164425346 | 9164425346 | None | None | None | 9164425346 | 9164425346 | 9164425346 | 9164425346 | None | None | None | 9164425346 | 9164425346 | 9164425346 | 9164425346 | None | None | None | 9164425346 | 9164425346 | 9164425346 | 9164425346 | None | None | None | 9164425346 | 9164425346 | 9164425346 | 9164425346 | None | None | None | 9164425346 | 9164425346 | 9164425346 | 9164425346 | None | None | None | 9164425346 | 9164425346 | 9164425346 | 9164425346 | None | None | None | 9164425346 | 9164425346 | 9164425346 | 9164425346 | None | None | None | 9164425346 | 9164425346 | 9164425346 | 9164425346 | None | None | None | 9164425346 | 9164425346 | 9164425346 | 9164425346 | None | None | None | 9164425346 | 9164425346 | 9164425346 | 9164425346 | None | None | None | 9164425346 | 9164425346 | 9164425346 | 9164425346 | None | None | None | 9164425346 | 9164425346 | 9164425346 | 9164425346 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
None | None | None | [email protected] | [email protected] | [email protected] | None | [email protected] | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | None | [email protected] | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | None | [email protected] | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | None | [email protected] | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | None | [email protected] | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | None | [email protected] | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | None | [email protected] | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | None | [email protected] | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | None | [email protected] | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | None | [email protected] | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | None | [email protected] | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | None | [email protected] | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | None | [email protected] | None | None | None | None | None | None | None | None | [email protected] | [email protected] | [email protected] | None | [email protected] | None | None | None | None | None |
filer_id | 1146765 |
---|
filer_id | 1146765 | 1146765 | ||
---|---|---|---|---|
change_no | 1 | 2 | ||
session_id | 2017 | 2019 | ||
log_dt | 2017-04-18 00:00:00 | 2019-04-30 00:00:00 | ||
filer_type | 2 | 2 | ||
correction_flg | Y | None | ||
action | TERMINATED | CHANGED | ||
attribute_changed | LOBBYIST | NAME | ||
ethics_dt | None | None | ||
interests | None | None | ||
filer_full_name | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL | AMERICAN INSTITUTE OF ARCHITECTS, CALIFORNIA COUNCIL | ||
filer_city | SACRAMENTO | None | ||
filer_st | CA | None | ||
filer_zip | 95814 | None | ||
filer_phone | 9164489082 | None | ||
entity_type | 4 | 2 | ||
entity_name | COOKNICK, KURT T. | AMERICAN INSTITUTE OF ARCHITECTS CALIFORNIA, | ||
entity_city | None | None | ||
entity_st | None | None | ||
entity_zip | None | None | ||
entity_phone | None | None | ||
entity_id | None | 0 | ||
responsible_officer | None | None | ||
effect_dt | 2017-02-17 00:00:00 | 2019-02-01 00:00:00 |
filer_id | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_period_start_dt | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | ||||||
filing_period_end_dt | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 | ||||||
contribution_dt | None | None | None | None | None | None | ||||||
recipient_name | PAT BATES FOR ASSEMBLY 2002 | LOU CORREA FOR THE STATE ASSEMBLY | FRIENDS. OF BARBARA MATTHEWS | J. NATION FOR ASSEMBLY 2000 | PATRICIA WIGGINS FOR ASSEMBLY | CITIZENS TO ELECT RUSS BOGH (SP. ELECTION APRIL 3) | ||||||
recipient_id | 1233359 | 1065492 | 1232571 | 1075712 | 1071557 | 1230666 | ||||||
amount | 750 | 1000 | 1000 | 750 | 1000 | 1000 |
filer_id | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_period_start_dt | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | ||||||
filing_period_end_dt | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 | ||||||
contribution_dt | None | None | None | None | None | None | ||||||
recipient_name | PAT BATES FOR ASSEMBLY 2002 | LOU CORREA FOR THE STATE ASSEMBLY | FRIENDS. OF BARBARA MATTHEWS | J. NATION FOR ASSEMBLY 2000 | PATRICIA WIGGINS FOR ASSEMBLY | CITIZENS TO ELECT RUSS BOGH (SP. ELECTION APRIL 3) | ||||||
recipient_id | 1233359 | 1065492 | 1232571 | 1075712 | 1071557 | 1230666 | ||||||
amount | 750 | 1000 | 1000 | 750 | 1000 | 1000 |
filer_id | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | 1146765 | ||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
filing_file_name | 681722_0.cal | 6427.cal | 719940_0.cal | 746977_0.cal | 249378.cal | 249722.cal | 772076_0.cal | 746977_1.cal | 791808_0.cal | 109340.cal | 814375_0.cal | 840230_0.cal | 853721_0.cal | 126659.cal | 126671.cal | 840230_1.cal | 440263.cal | 440337.cal | 883068_0.cal | 909640_0.cal | 909640_1.cal | 931147_0.cal | 945502_0.cal | 931147_1.cal | 968833_0.cal | 931147_2.cal | ||||||||||||||||||||||||||
received_date | 2000-10-31 00:00:00 | 2001-02-01 00:00:00 | 2001-02-01 00:00:00 | 2001-05-01 00:00:00 | 2001-07-30 00:00:00 | 2001-07-30 00:00:00 | 2001-07-30 00:00:00 | 2001-05-24 00:00:00 | 2001-10-31 00:00:00 | 2002-01-31 00:00:00 | 2002-01-31 00:00:00 | 2002-04-30 00:00:00 | 2002-07-30 00:00:00 | 2002-09-23 00:00:00 | 2002-09-23 00:00:00 | 2002-09-23 00:00:00 | 2002-10-30 00:00:00 | 2002-10-30 00:00:00 | 2002-10-30 00:00:00 | 2003-01-30 00:00:00 | 2003-03-21 00:00:00 | 2003-04-30 00:00:00 | 2003-07-29 00:00:00 | 2003-08-01 00:00:00 | 2003-10-30 00:00:00 | 2003-10-30 00:00:00 | ||||||||||||||||||||||||||
filing_directory | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/cal | /usr/users/cafiler/disclose/ca99/temp | /usr/users/cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/cal | /cafiler/disclose/ca99/temp | /cafiler/disclose/ca99/temp | /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 | ||||||||||||||||||||||||||
filing_id | 681722 | None | 719940 | 746977 | None | None | 772076 | 746977 | 791808 | None | 814375 | 840230 | 853721 | None | None | 840230 | None | None | 883068 | 909640 | 909640 | 931147 | 945502 | 931147 | 968833 | 931147 | ||||||||||||||||||||||||||
form_id | F635 | None | F635 | F635 | None | None | F635 | F635 | F635 | None | F635 | F635 | F635 | None | None | F635 | None | None | F635 | F635 | F635 | F635 | F635 | F635 | F635 | F635 | ||||||||||||||||||||||||||
receive_comment | Filing accepted | Filing did not pass validation | 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 accepted, but with warnings | Filing accepted, but with warnings | Filing accepted, but with warnings | Filing did not pass validation | Filing accepted, but with warnings | 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 accepted, but with warnings | 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, 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 |