OpenCalAccess

Filer ID: 1146828

Table: filer_address
filer_id	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828
adrid	1109396	1108276	2040856	2080775	2113230	2159761	2203289	2554184	2413485	2277862	2466551	2338827	2505182
effect_dt	1995-01-01 00:00:00	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	2023-01-01 00:00:00	2017-01-01 00:00:00	2013-01-01 00:00:00	2019-01-01 00:00:00	2015-01-01 00:00:00	2021-01-01 00:00:00
add_type	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051
session_id	1995	2001	2003	2005	2007	2009	2011	2023	2017	2013	2019	2015	2021

Table: filer_filings
filer_id	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828
filing_id	498728	498956	499224	500433	500652	501274	501486	499807	502416	500084	502061	502636	500084	541762	499807	500433	503561	502416	503209	503561	541762	500932	501844	541762	502416	503772	499578	501844	633835	620489	662828	650659	684540	712789	703563	717866	758408	734206	745458	778757	769643	745458	788147	773830	801272	797043	807040	814675	821920	834680	834682	843182	840401	864528	843342	853687	893713	907058	895723	884114	921649	931294	912154	966231	947754	936600	950673	986496	975151	1013312	1017088	1027264	1027857	1028836	1033972	997038	1021957	1078177	1056979	1067630	1078921	1094828	1086618	1064042	1105714	1109445	1112886	1116266	1145644	1134617	1105970	1166532	1171214	1191957	1223787	1226478	1216493	1249339	1256853	1285372	1262920	1235745	1293816	1763192	1964972	1975751	1872377	1846000	1780051	1724257	1800883	1807682	1958955	1926145	1945099	1918221	1909906	1309070	1326339	1326339	1309070	1309070	1342906	1223787	1326339	1285372	1223787	1293816	1334142	1326339	1223787	1348175	1223787	1345291	1373169	1381940	1386134	1392157	1404899	1392157	1407538	1419434	1450195	1461968	1434309	1483038	1506509	1461968	1537871	1550838	1555011	1550303	1571507	1601515	1579987	1597360	1550303	1550303	1619868	1590614	1635657	1656073	1661360	1763192	1820966	1818223	1680074	1930993	1930993	1918221	1917669	1706600	1550303	1707359	1721335	1732634	1707359	1724257	1736899	1656073	1724257	1847931	1818223	1724257	1752689	1724257	1763192	1765218	1994196	1918221	1918221	1918221	1918221	1996358	1918221	2411744	2349197	2331327	2208827	2340151	2331327	2331327	2380710	2526391	2331327	2001404	2006857	1991378	1996358	2010562	2031192	2060465	1918221	2078476	2102164	2121443	2128748	2148171	2155760	2139111	2115348	2115348	2172070	2387235	2387237	2239812	2331327	2396951	2331327	2271919	2258586	2331327	2418963	2331327	2409095	2461805	2526391	2395599	2395600	2318572	2535121	2550496	2443226	2115348	2579268	2115348	2526367	2194065	2331327	2213193	2373499	2373501	2466378	2396951	2437654	2439616	2331327	2469021	2239812	2482952	2538344	2418963	2418963	2605390	2469021	2331327	2538344	2612816	2579268	2612729	2674969	2635699	2635700	2583643	2538344	2538344	2599590	2643254	2621229	2707322	2538344	2538344	2538344	2707322	2753783	2748351
period_id	141	149	157	143	151	144	152	150	146	158	153	154	158	147	150	143	148	146	155	148	147	159	145	147	146	156	142	145	None	160	162	161	163	163	None	164	165	164	165	None	166	165	167	161	None	None	None	168	None	None	None	169	None	None	None	170	None	172	None	171	None	173	None	175	174	None	174	176	None	177	None	178	None	178	None	None	None	180	179	None	180	None	None	None	181	None	None	182	184	183	None	185	None	186	188	None	187	None	None	190	189	188	191	213	221	222	218	217	214	216	215	None	None	None	None	221	219	192	193	193	192	192	None	195	193	190	195	191	None	193	194	194	196	None	195	196	196	196	None	196	None	197	199	200	198	201	202	200	203	None	None	205	204	206	None	None	206	204	207	205	208	209	None	213	None	220	210	220	220	220	220	None	212	211	None	None	211	213	212	209	218	None	216	213	None	214	213	None	None	224	224	225	224	223	224	None	236	238	232	None	239	241	237	243	239	None	None	None	223	224	225	226	227	None	227	None	228	None	229	None	228	229	230	None	None	233	237	238	244	234	None	241	239	238	None	None	243	None	None	235	None	244	240	234	245	233	None	231	237	None	None	None	None	238	None	None	236	241	233	242	245	239	239	None	241	244	244	None	245	None	249	None	None	None	246	249	246	248	247	250	246	249	252	250	None	251
form_id	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F690	F635	F690	F690	F690	F690	F635	F635	F690	F635	F690	F690	F690	F635	F635	F635	F635	F635	F635	F635	F635	F635	F603	F635	F635	F635	F635	F635	F635	F635	F635	F690	F605	F635	F602	F635	F635	F605	F602	F635	F605	F635	F635	F635	F635	F635	F603	F635	F602	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F605	F635	F602	F635	F605	F635	F635	F603	F603	F635	F602	F635	F635	F605	F605	F635	F635	F635	F605	F635	F605	F635	F603	F603	F635	F602	F605	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F603	F635	F605	F605	F603	F602	F603	F635	F635	F635	F635	F635	F635	F605	F603	F635	F635	F603	F635	F605	F635	F603	F635	F603	F605	F635	F603	F602	F635	F603	F635	F602	F635	F635	F635	F635	F635	F635	F635	F635	F603	F602	F603	F635	F635	F605	F605	F603	F603	F635	F635	F635	F635	F602	F635	F888	F635	F635	F635	F635	F603	F602	F605	F603	F635	F603	F602	F635	F603	F635	F635	F603	F605	F635	F603	F605	F603	F635	F605	F605	F603	F603	F603	F603	F635	F603	F605	F635	F603	F635	F603	F603	F603	F635	F635	F603	F605	F605	F605	F635	F635	F635	F635	F603	F605	F635	F603	F635	F605	F635	F602	F603	F603	F635	F605	F605	F635	F603	F635	F603	F635	F605	F603	F635	F603	F605	F605	F635	F602	F602	F635	F605	F635	F635	F603	F635	F603	F605	F635	F603	F605	F605	F605	F605	F635	F605	F605	F603	F635	F635	F635	F603	F635	F635	F605	F635	F603	F603	F605	F635	F605	F635	F605	F605	F603	F603	F603	F635	F635	F635	F635	F603	F603	F603	F635	F605	F635
filing_sequence	0	0	0	0	0	0	0	0	0	0	0	0	1	0	1	1	1	1	0	0	2	0	1	1	2	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	3	0	0	0	0	0	1	0	1	2	0	2	0	0	3	3	1	2	1	0	1	1	0	4	0	0	0	0	0	0	1	0	0	0	0	0	0	0	1	0	0	0	1	0	0	0	0	2	0	0	0	0	0	0	2	0	0	0	0	1	0	0	0	3	0	0	0	1	0	0	1	4	0	1	1	0	2	0	0	0	4	5	6	3	0	2	0	0	4	0	0	6	8	0	0	5	0	0	0	1	0	0	0	7	0	0	0	0	0	0	0	0	1	0	0	0	0	2	0	10	0	0	7	1	3	0	0	1	0	0	0	0	0	0	3	0	2	0	0	1	0	0	0	0	1	0	0	0	0	1	0	1	0	2	0	1	9	0	0	1	0	0	0	0	0	3	5	0	0	0	0	2	4	6	1	0	0
filing_date	1995-04-28 00:00:00	1997-04-30 00:00:00	1999-04-30 00:00:00	1995-10-31 00:00:00	1997-10-31 00:00:00	1996-01-31 00:00:00	1998-02-02 00:00:00	1997-07-30 00:00:00	1996-07-30 00:00:00	1999-08-02 00:00:00	1998-04-30 00:00:00	1998-07-31 00:00:00	1999-10-29 00:00:00	1996-10-31 00:00:00	1997-08-13 00:00:00	1996-05-15 00:00:00	1997-10-08 00:00:00	1997-05-09 00:00:00	1998-10-31 00:00:00	1997-01-31 00:00:00	1997-10-08 00:00:00	1999-11-01 00:00:00	1997-10-08 00:00:00	1996-12-11 00:00:00	1997-10-08 00:00:00	1999-01-29 00:00:00	1995-07-31 00:00:00	1996-05-10 00:00:00	2000-05-02 00:00:00	2000-02-03 00:00:00	2000-07-28 00:00:00	2000-08-09 00:00:00	2000-11-02 00:00:00	2001-01-08 00:00:00	2000-12-28 00:00:00	2001-01-30 00:00:00	2001-04-30 00:00:00	2001-01-31 00:00:00	2001-04-30 00:00:00	2001-07-25 00:00:00	2001-07-24 00:00:00	2001-08-02 00:00:00	2001-10-19 00:00:00	2001-01-08 00:00:00	2001-12-17 00:00:00	2001-10-22 00:00:00	2002-01-14 00:00:00	2002-01-31 00:00:00	2002-01-28 00:00:00	2002-04-10 00:00:00	2002-04-10 00:00:00	2002-05-15 00:00:00	2002-04-30 00:00:00	2002-07-30 00:00:00	2002-04-30 00:00:00	2002-07-29 00:00:00	2002-10-31 00:00:00	2003-01-27 00:00:00	2002-12-02 00:00:00	2002-10-30 00:00:00	2003-02-10 00:00:00	2003-04-30 00:00:00	2003-01-28 00:00:00	2003-10-23 00:00:00	2003-07-31 00:00:00	2003-04-30 00:00:00	2003-07-31 00:00:00	2004-01-26 00:00:00	2003-10-23 00:00:00	2004-04-29 00:00:00	2004-04-30 00:00:00	2004-07-28 00:00:00	2004-07-28 00:00:00	2004-07-28 00:00:00	2004-07-28 00:00:00	2004-01-27 00:00:00	2004-07-06 00:00:00	2005-01-28 00:00:00	2004-10-29 00:00:00	2004-12-22 00:00:00	2005-01-28 00:00:00	2005-01-31 00:00:00	2004-12-29 00:00:00	2004-10-29 00:00:00	2005-05-02 00:00:00	2005-06-07 00:00:00	2005-07-19 00:00:00	2005-07-28 00:00:00	2006-01-27 00:00:00	2005-11-01 00:00:00	2005-05-02 00:00:00	2006-04-28 00:00:00	2006-05-17 00:00:00	2006-07-31 00:00:00	2006-12-18 00:00:00	2006-12-26 00:00:00	2006-10-31 00:00:00	2006-12-29 00:00:00	2007-04-13 00:00:00	2007-07-31 00:00:00	2007-05-01 00:00:00	2007-01-30 00:00:00	2007-10-22 00:00:00	2013-08-16 00:00:00	2015-04-30 00:00:00	2015-07-21 00:00:00	2014-07-31 00:00:00	2014-04-30 00:00:00	2013-07-29 00:00:00	2013-12-12 00:00:00	2013-10-31 00:00:00	2013-12-13 00:00:00	2015-04-14 00:00:00	2014-12-22 00:00:00	2014-12-29 00:00:00	2015-03-06 00:00:00	2014-10-30 00:00:00	2008-04-22 00:00:00	2008-05-02 00:00:00	2008-04-23 00:00:00	2008-04-30 00:00:00	2008-01-30 00:00:00	2008-07-10 00:00:00	2008-07-17 00:00:00	2008-07-23 00:00:00	2008-04-30 00:00:00	2008-07-17 00:00:00	2008-04-30 00:00:00	2008-05-20 00:00:00	2008-04-30 00:00:00	2008-05-23 00:00:00	2008-07-29 00:00:00	2008-10-10 00:00:00	2008-07-21 00:00:00	2008-10-28 00:00:00	2008-11-20 00:00:00	2008-12-29 00:00:00	2009-01-26 00:00:00	2008-11-25 00:00:00	2009-02-13 00:00:00	2008-12-18 00:00:00	2009-04-28 00:00:00	2009-10-27 00:00:00	2010-01-28 00:00:00	2009-07-28 00:00:00	2010-04-27 00:00:00	2010-07-30 00:00:00	2010-07-27 00:00:00	2010-10-28 00:00:00	2010-12-14 00:00:00	2010-12-23 00:00:00	2011-01-26 00:00:00	2011-01-31 00:00:00	2011-07-20 00:00:00	2011-02-01 00:00:00	2011-06-09 00:00:00	2011-06-06 00:00:00	2010-12-13 00:00:00	2011-10-26 00:00:00	2011-04-29 00:00:00	2012-01-31 00:00:00	2012-04-27 00:00:00	2012-05-01 00:00:00	2014-01-28 00:00:00	2013-04-11 00:00:00	2014-01-31 00:00:00	2012-07-31 00:00:00	2015-01-27 00:00:00	2015-01-27 00:00:00	2014-12-15 00:00:00	2014-12-09 00:00:00	2012-10-26 00:00:00	2012-10-22 00:00:00	2012-10-30 00:00:00	2012-12-26 00:00:00	2012-12-28 00:00:00	2013-01-24 00:00:00	2013-01-11 00:00:00	2013-01-30 00:00:00	2013-01-24 00:00:00	2014-04-30 00:00:00	2014-05-02 00:00:00	2014-03-28 00:00:00	2013-02-06 00:00:00	2013-02-06 00:00:00	2013-04-09 00:00:00	2013-04-29 00:00:00	2013-04-11 00:00:00	2015-10-23 00:00:00	2015-10-23 00:00:00	2015-11-20 00:00:00	2016-01-04 00:00:00	2015-10-08 00:00:00	2015-10-29 00:00:00	2015-10-07 00:00:00	2019-10-04 00:00:00	2019-01-31 00:00:00	2019-05-29 00:00:00	2018-01-30 00:00:00	2019-01-07 00:00:00	2019-09-30 00:00:00	2020-03-04 00:00:00	2019-04-30 00:00:00	2020-10-29 00:00:00	2019-08-14 00:00:00	2015-11-24 00:00:00	2016-01-05 00:00:00	2015-10-08 00:00:00	2016-01-27 00:00:00	2016-01-29 00:00:00	2016-04-22 00:00:00	2016-07-28 00:00:00	2016-09-13 00:00:00	2016-09-15 00:00:00	2016-10-31 00:00:00	2016-12-22 00:00:00	2017-01-31 00:00:00	2017-03-14 00:00:00	2017-04-28 00:00:00	2017-01-03 00:00:00	2016-12-29 00:00:00	2017-03-09 00:00:00	2017-07-26 00:00:00	2019-05-28 00:00:00	2019-05-29 00:00:00	2018-04-27 00:00:00	2019-03-04 00:00:00	2019-07-30 00:00:00	2020-10-26 00:00:00	2018-07-30 00:00:00	2018-05-31 00:00:00	2020-03-04 00:00:00	2020-01-30 00:00:00	2019-05-24 00:00:00	2019-08-14 00:00:00	2020-03-05 00:00:00	2021-01-29 00:00:00	2019-05-06 00:00:00	2019-05-29 00:00:00	2018-10-31 00:00:00	2020-11-06 00:00:00	2021-01-29 00:00:00	2020-01-31 00:00:00	2018-05-30 00:00:00	2021-04-29 00:00:00	2018-02-02 00:00:00	2020-10-19 00:00:00	2017-10-31 00:00:00	2019-02-27 00:00:00	2018-02-02 00:00:00	2019-03-05 00:00:00	2019-03-05 00:00:00	2020-04-13 00:00:00	2019-12-17 00:00:00	2020-01-28 00:00:00	2020-01-29 00:00:00	2018-12-31 00:00:00	2020-04-29 00:00:00	2018-05-25 00:00:00	2020-07-29 00:00:00	2021-02-26 00:00:00	2019-10-31 00:00:00	2020-01-31 00:00:00	2021-03-11 00:00:00	2020-07-28 00:00:00	2020-10-09 00:00:00	2020-12-24 00:00:00	2021-06-11 00:00:00	2021-07-29 00:00:00	2021-07-09 00:00:00	2022-04-29 00:00:00	2022-01-11 00:00:00	2022-01-11 00:00:00	2021-01-11 00:00:00	2021-06-28 00:00:00	2022-01-06 00:00:00	2021-07-29 00:00:00	2022-01-31 00:00:00	2021-10-28 00:00:00	2022-08-01 00:00:00	2021-06-03 00:00:00	2022-01-06 00:00:00	2022-10-25 00:00:00	2022-10-27 00:00:00	2022-10-27 00:00:00	2022-10-31 00:00:00
stmnt_type	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10005	10005	10005	10001	10001	10005	10005	10001	10005	10005	10001	10005	10001	10002	10001	10005	10005	10005	10005	10001	10005	10005	10005	10001	10005	10005	10005	10001	10005	10001	10005	10001	10005	10001	10005	10001	10001	10005	10005	10001	10005	10001	10005	10001	10005	10005	10005	10005	10005	10001	10001	10005	10001	10005	10005	10005	10001	10005	10005	10001	10001	10001	10005	10001	10005	10001	10001	10005	10001	10005	10005	10001	10001	10001	10001	10002	10001	10001	10001	10001	10001	10002	10001	10006	10006	10005	10005	10002	10001	10002	10002	10001	10002	10001	10005	10002	10002	10002	10002	10002	10005	10002	10002	10001	10002	10005	10001	10001	10001	10001	10005	10002	10005	10001	10001	10001	10001	10001	10001	10002	10001	10005	10005	10002	10001	10001	10005	10006	10002	10001	10001	10001	10001	10001	10005	10002	10005	10001	10001	10001	10002	10001	10001	10006	10002	10001	10005	10005	10002	10001	10001	10002	10002	10006	10002	10002	10006	10002	10001	10005	10006	10002	10002	10002	10002	10001	10002	10005	10001	10002	10001	10005	10002	10002	10001	10001	10002	10006	10006	10006	10002	10001	10001	10001	10002	10006	10001	10005	10001	10005	10001	10005	10001	10002	10001	10005	10005	10001	10002	10001	10002	10001	10006	10002	10002	10002	10005	10005	10002	10005	10005	10001	10002	10001	10001	10002	10001	10002	10002	10001	10002	10005	10005	10005	10005	10002	10005	10005	10001	10001	10002	10001	10002	10001	10002	10002	10002	10002	10001	10002	10002	10002	10001	10002	10002	10005	10002	10002	10001	10001	10001	10001	10002	10002	10002	10002	10005	10001
stmnt_status	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	11001	11001	11003	11001	11001	11003	11001	11003	11003	11003	11001	11001	11001	11001	11003	11001	11001	11001	11003	11001	11001	11001	11003	11001	11003	11001	11003	11001	11003	11001	11003	11003	11001	11001	11003	11001	11003	11001	11003	11001	11001	11001	11001	11001	11003	11003	11003	11003	11003	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	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11003	11001	11001	11001	11003	11001	11003	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	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11003	11001	11001	11001	11003	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11003	11001	11003
session_id	1995	1997	1999	1995	1997	1995	1997	1997	1995	1999	1997	1997	1999	1995	1997	1995	1995	1995	1997	1995	1995	1999	1995	1995	1995	1997	1995	1995	1999	1999	1999	1999	1999	1999	2001	1999	2001	1999	2001	2001	2001	2001	2001	1999	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2003	2003	2001	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2005	2003	2005	2003	2005	2005	2005	2005	2005	2005	2005	2005	2005	2005	2007	2007	2005	2007	2007	2007	2007	2005	2007	2013	2015	2015	2013	2013	2013	2013	2013	2013	2015	2015	2015	2015	2013	2007	2007	2007	2007	2007	2007	2007	2007	2007	2007	2007	2007	2007	2007	2007	2007	2007	2007	2009	2009	2007	2009	2007	2009	2009	2009	2009	2009	2009	2009	2009	2009	2011	2009	2011	2009	2011	2011	2011	2011	2011	2011	2011	2011	2011	2011	2013	2011	2013	2011	2013	2013	2015	2015	2011	2011	2011	2013	2013	2011	2013	2011	2011	2013	2013	2013	2013	2013	2013	2013	2013	2015	2015	2015	2015	2015	2015	2015	2019	2017	2019	2017	2019	2019	2019	2019	2019	2019	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2017	2015	2017	2017	2017	2017	2017	2017	2019	2019	2017	2019	2019	2019	2017	2017	2019	2019	2019	2019	2019	2019	2019	2019	2017	2019	2019	2019	2017	2021	2017	2019	2017	2019	2017	2019	2019	2019	2019	2019	2019	2019	2019	2017	2019	2021	2019	2019	2021	2019	2019	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021
user_id	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	DHORRELL	*	YBONILLA	*	*	LTHIBAUL	GKURIMOT	*	JBRANNAN	LTHIBAUL	*	LTHIBAUL	*	*	*	YBONILLA	GPEREZ	LTHIBAUL	CFLAGG	*	LTHIBAUL	CFLAGG	CFLAGG	DHORRELL	CFLAGG	LTHIBAUL	LTHIBAUL	*	LTHIBAUL	COMPLETED	PBANFORD	*	GPEREZ	COMPLETED	LTHIBAUL	COMPLETED	COMPLETED	LTHIBAUL	LTHIBAUL	COMPLETED	LTHIBAUL	COMPLETED	LTHIBAUL	COMPLETED	SARRIAGA	LTHIBAUL	SARRIAGA	LTHIBAUL	SARRIAGA	COMPLETED	COMPLETED	CFLAGG	COMPLETED	JWHITE	SARRIAGA	LTHIBAUL	LTHIBAUL	SARRIAGA	SARRIAGA	LTHIBAUL	LTHIBAUL	LTHIBAUL	CFLAGG	LTHIBAUL	SARRIAGA	LTHIBAUL	*	SARRIAGA	LTHIBAUL	SARRIAGA	CFLAGG	LTHIBAUL	LTHIBAUL	LTHIBAUL	LTHIBAUL	ASAETERN	AGLADNEY	AGLADNEY	AGLADNEY	ASAETERN	ASAETERN	YRODRIGU	ASAETERN	SMCCONNAN	YRODRIGU	GPEREZ	PBANFORD	YRODRIGU	ASAETERN	LTHIBAUL	LTHIBAUL	LTHIBAUL	LTHIBAUL	LTHIBAUL	LTHIBAUL	*	LTHIBAUL	LTHIBAUL	*	LTHIBAUL	CFLAGG	LTHIBAUL	*	LTHIBAUL	*	CFLAGG	ASAETERN	YRODRIGU	YRODRIGU	ASAETERN	YRODRIGU	ASAETERN	YRODRIGU	MGUERRA	MGUERRA	MGUERRA	MGUERRA	ASAETERN	ASAETERN	ASAETERN	ASAETERN	GKURIMOT	DMCCASTL	YRODRIGU	AGLADNEY	AGLADNEY	GKURIMOT	YRODRIGU	YRODRIGU	YRODRIGU	ASAETERN	AGLADNEY	ASAETERN	AGLADNEY	YRODRIGU	AGLADNEY	ASAETERN	AGLADNEY	ASAETERN	ASAETERN	ASAETERN	YRODRIGU	PBANFORD	YRODRIGU	YRODRIGU	AGLADNEY	GKURIMOT	PBANFORD	AGLADNEY	GKURIMOT	ASAETERN	AGLADNEY	YRODRIGU	YRODRIGU	AGLADNEY	YRODRIGU	YRODRIGU	YRODRIGU	ASAETERN	SARRIAGA	YRODRIGU	YRODRIGU	YRODRIGU	YRODRIGU	YRODRIGU	AGLADNEY	YRODRIGU	GPEREZ	AGLADNEY	GPEREZ	AGLADNEY	GPEREZ	GPEREZ	GPEREZ	GTAYLOR	GTAYLOR	GPEREZ	YRODRIGU	YRODRIGU	YRODRIGU	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	YRODRIGU	YRODRIGU	AGLADNEY	GPEREZ	AGLADNEY	GPEREZ	AGLADNEY	SARRIAGA	YRODRIGU	GPEREZ	AGLADNEY	GPEREZ	GPEREZ	AGLADNEY	GPEREZ	GTAYLOR	MMERCHANT	AGLADNEY	YRODRIGU	GPEREZ	AGLADNEY	GPEREZ	GPEREZ	GPEREZ	GTAYLOR	GPEREZ	SARRIAGA	AGLADNEY	CVANLIEW	CHARTRIDGE	VUKSTINA	YRODRIGU	CAFILER	GPEREZ	MMERCHANT	AGLADNEY	GPEREZ	GPEREZ	GPEREZ	GPEREZ	GPEREZ	CAFILER	GPEREZ	GPEREZ	GPEREZ	VUKSTINA	AGLADNEY	MKIRKHAM	CAFILER	VUKSTINA	AGLADNEY	JMENDOZA	CAFILER	MMERCHANT	JMENDOZA	JMENDOZA	CAFILER	MMERCHANT	CAFILER	MMERCHANT	MMERCHANT	JMENDOZA	MMERCHANT	MMERCHANT	MKIRKHAM	MKIRKHAM	CHATRIDGE	CAFILER	MMERCHANT	MMERCHANT	SARRIAGA	CAFILER	SARRIAGA	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	11001	11001	11001	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11002	11003	11003	11003	11003	11002	11002	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	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	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	11001	11001	11001	11003	11003	11003	11001	11003	11003	11003	11003	11003	11003	11003	11003	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	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11003	11001	11001	11001	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11003	11001	11003	11001	11003	11003	11003	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11003	11001	11003	11001	11003	11001	11003	11003	11001	11003	11001	11003	11001	11003	11003	11001	11003	11003	11003	11001	11003	11003	11001	11003	11003	11001	11003	11003	11003	11003	11001	11003	11003	11003	11003	11003	11003	11003	11003	11003	11001	11001	11001	11003	11001	11001	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11001	11001	11001	11003	11003	11003	11003	11003	11003	11003
rpt_start	1995-01-01 00:00:00	1997-01-01 00:00:00	1999-01-01 00:00:00	1995-07-01 00:00:00	1997-07-01 00:00:00	1995-10-01 00:00:00	1997-10-01 00:00:00	1997-04-01 00:00:00	1996-04-01 00:00:00	1999-04-01 00:00:00	1998-01-01 00:00:00	1998-04-01 00:00:00	1999-04-01 00:00:00	1996-07-01 00:00:00	1997-04-01 00:00:00	1995-07-01 00:00:00	1996-10-01 00:00:00	1996-04-01 00:00:00	1998-07-01 00:00:00	1996-10-01 00:00:00	1996-07-01 00:00:00	1999-07-01 00:00:00	1996-01-01 00:00:00	1996-07-01 00:00:00	1996-04-01 00:00:00	1998-10-01 00:00:00	1995-04-01 00:00:00	1996-01-01 00:00:00	2000-01-01 00:00:00	1999-10-01 00:00:00	2000-04-01 00:00:00	2000-01-01 00:00:00	2000-07-01 00:00:00	2000-07-01 00:00:00	1900-01-01 00:00:00	2000-10-01 00:00:00	2001-01-01 00:00:00	2000-10-01 00:00:00	2001-01-01 00:00:00	2001-04-01 00:00:00	2001-04-01 00:00:00	2001-01-01 00:00:00	2001-07-01 00:00:00	2000-01-01 00:00:00	1900-01-01 00:00:00	2001-07-01 00:00:00	1900-01-01 00:00:00	2001-10-01 00:00:00	2001-10-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2002-01-01 00:00:00	1900-01-01 00:00:00	2002-04-01 00:00:00	2002-01-01 00:00:00	2002-04-01 00:00:00	2002-07-01 00:00:00	2002-10-01 00:00:00	1900-01-01 00:00:00	2002-07-01 00:00:00	1900-01-01 00:00:00	2003-01-01 00:00:00	2002-10-01 00:00:00	2003-07-01 00:00:00	2003-04-01 00:00:00	2003-01-01 00:00:00	2003-04-01 00:00:00	2003-10-01 00:00:00	2003-07-01 00:00:00	2004-01-01 00:00:00	2004-01-01 00:00:00	2004-04-01 00:00:00	1900-01-01 00:00:00	2004-04-01 00:00:00	1900-01-01 00:00:00	2003-10-01 00:00:00	1900-01-01 00:00:00	2004-10-01 00:00:00	2004-07-01 00:00:00	1900-01-01 00:00:00	2004-12-22 00:00:00	2004-10-01 00:00:00	1900-01-01 00:00:00	2004-07-01 00:00:00	2005-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2005-04-01 00:00:00	2005-10-01 00:00:00	2005-07-01 00:00:00	1900-01-01 00:00:00	2006-01-01 00:00:00	1900-01-01 00:00:00	2006-04-01 00:00:00	2006-12-18 00:00:00	1900-01-01 00:00:00	2006-07-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2007-04-01 00:00:00	2007-01-01 00:00:00	2006-10-01 00:00:00	2007-07-01 00:00:00	2013-01-01 00:00:00	2015-01-01 00:00:00	2015-04-01 00:00:00	2014-04-01 00:00:00	2014-01-01 00:00:00	2013-04-01 00:00:00	2013-12-12 00:00:00	2013-07-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2015-03-06 00:00:00	2014-07-01 00:00:00	2007-10-01 00:00:00	2008-01-01 00:00:00	2008-01-01 00:00:00	2007-10-01 00:00:00	2007-10-01 00:00:00	1900-01-01 00:00:00	2008-07-17 00:00:00	2008-01-01 00:00:00	2007-04-01 00:00:00	2008-07-17 00:00:00	2007-07-01 00:00:00	1900-01-01 00:00:00	2008-01-01 00:00:00	2008-05-23 00:00:00	2008-04-01 00:00:00	2008-10-10 00:00:00	1900-01-01 00:00:00	2008-07-01 00:00:00	2008-11-20 00:00:00	2008-12-27 00:00:00	2008-10-01 00:00:00	1900-01-01 00:00:00	2008-10-01 00:00:00	1900-01-01 00:00:00	2009-01-01 00:00:00	2009-07-01 00:00:00	2009-10-01 00:00:00	2009-04-01 00:00:00	2010-01-01 00:00:00	2010-04-01 00:00:00	2009-10-01 00:00:00	2010-07-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2011-01-26 00:00:00	2010-10-01 00:00:00	2011-04-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2011-06-06 00:00:00	2010-12-13 00:00:00	2011-07-01 00:00:00	2011-01-01 00:00:00	2011-10-01 00:00:00	2012-01-01 00:00:00	1900-01-01 00:00:00	2013-01-01 00:00:00	2012-10-01 00:00:00	2014-10-01 00:00:00	2012-04-01 00:00:00	2014-10-01 00:00:00	2014-10-01 00:00:00	2014-12-15 00:00:00	2014-12-09 00:00:00	1900-01-01 00:00:00	2012-10-22 00:00:00	2012-07-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2012-07-01 00:00:00	2013-01-11 00:00:00	2012-10-01 00:00:00	2012-01-01 00:00:00	2014-04-30 00:00:00	1900-01-01 00:00:00	2013-10-01 00:00:00	2013-02-06 00:00:00	1900-01-01 00:00:00	2013-04-09 00:00:00	2013-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2015-10-23 00:00:00	2015-11-20 00:00:00	2016-01-04 00:00:00	2015-10-08 00:00:00	2015-07-01 00:00:00	2015-10-07 00:00:00	1900-01-01 00:00:00	2018-10-01 00:00:00	2019-05-29 00:00:00	2017-10-01 00:00:00	1900-01-01 00:00:00	2019-09-30 00:00:00	2020-03-04 00:00:00	2019-01-01 00:00:00	2020-07-01 00:00:00	2019-08-14 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2015-07-01 00:00:00	2015-10-01 00:00:00	2016-01-01 00:00:00	2016-04-01 00:00:00	2016-09-13 00:00:00	1900-01-01 00:00:00	2016-07-01 00:00:00	1900-01-01 00:00:00	2016-10-01 00:00:00	1900-01-01 00:00:00	2017-01-01 00:00:00	1900-01-01 00:00:00	2016-12-29 00:00:00	2017-03-09 00:00:00	2017-04-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2018-01-01 00:00:00	2019-03-04 00:00:00	2019-04-01 00:00:00	2020-10-26 00:00:00	2018-04-01 00:00:00	1900-01-01 00:00:00	2020-03-04 00:00:00	2019-07-01 00:00:00	2019-05-24 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2020-07-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2018-07-01 00:00:00	1900-01-01 00:00:00	2020-10-01 00:00:00	2019-10-01 00:00:00	2018-05-30 00:00:00	2021-01-01 00:00:00	2018-02-02 00:00:00	1900-01-01 00:00:00	2017-07-01 00:00:00	2019-02-27 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2019-04-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2018-12-31 00:00:00	2020-01-01 00:00:00	2018-01-01 00:00:00	2020-04-01 00:00:00	2021-02-26 00:00:00	2019-07-01 00:00:00	2019-07-01 00:00:00	1900-01-01 00:00:00	2020-01-01 00:00:00	2020-10-09 00:00:00	2020-12-24 00:00:00	1900-01-01 00:00:00	2021-01-01 00:00:00	1900-01-01 00:00:00	2022-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2021-06-28 00:00:00	2022-01-06 00:00:00	2021-04-01 00:00:00	2021-10-01 00:00:00	2021-07-01 00:00:00	2022-04-01 00:00:00	2021-06-03 00:00:00	2022-01-06 00:00:00	2022-10-25 00:00:00	2022-04-01 00:00:00	1900-01-01 00:00:00	2022-07-01 00:00:00
rpt_end	1995-03-31 00:00:00	1997-03-31 00:00:00	1999-03-31 00:00:00	1995-09-30 00:00:00	1997-09-30 00:00:00	1995-12-31 00:00:00	1997-12-31 00:00:00	1997-06-30 00:00:00	1996-06-30 00:00:00	1999-06-30 00:00:00	1998-03-31 00:00:00	1998-06-30 00:00:00	1999-06-30 00:00:00	1996-09-30 00:00:00	1997-06-30 00:00:00	1995-09-30 00:00:00	1996-12-31 00:00:00	1996-06-30 00:00:00	1998-09-30 00:00:00	1996-12-31 00:00:00	1996-09-30 00:00:00	1999-09-30 00:00:00	1996-03-31 00:00:00	1996-09-30 00:00:00	1996-06-30 00:00:00	1998-12-31 00:00:00	1995-06-30 00:00:00	1996-03-31 00:00:00	2000-03-31 00:00:00	1999-12-31 00:00:00	2000-06-30 00:00:00	2000-03-31 00:00:00	2000-09-30 00:00:00	2000-09-30 00:00:00	1900-01-01 00:00:00	2000-12-31 00:00:00	2001-03-31 00:00:00	2000-12-31 00:00:00	2001-03-31 00:00:00	2001-06-30 00:00:00	2001-06-30 00:00:00	2001-03-31 00:00:00	2001-09-30 00:00:00	2000-03-31 00:00:00	1900-01-01 00:00:00	2001-09-30 00:00:00	1900-01-01 00:00:00	2001-12-31 00:00:00	2001-12-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2002-03-31 00:00:00	1900-01-01 00:00:00	2002-06-30 00:00:00	2002-03-31 00:00:00	2002-06-30 00:00:00	2002-09-30 00:00:00	2002-12-31 00:00:00	1900-01-01 00:00:00	2002-09-30 00:00:00	1900-01-01 00:00:00	2003-03-31 00:00:00	2002-12-31 00:00:00	2003-09-30 00:00:00	2003-06-30 00:00:00	2003-03-31 00:00:00	2003-06-30 00:00:00	2003-12-31 00:00:00	2003-09-30 00:00:00	2004-03-31 00:00:00	2004-03-31 00:00:00	2004-06-30 00:00:00	1900-01-01 00:00:00	2004-06-30 00:00:00	1900-01-01 00:00:00	2003-12-31 00:00:00	1900-01-01 00:00:00	2004-12-31 00:00:00	2004-09-30 00:00:00	1900-01-01 00:00:00	2004-12-22 00:00:00	2004-12-31 00:00:00	1900-01-01 00:00:00	2004-09-30 00:00:00	2005-03-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2005-06-30 00:00:00	2005-12-31 00:00:00	2005-09-30 00:00:00	1900-01-01 00:00:00	2006-03-31 00:00:00	1900-01-01 00:00:00	2006-06-30 00:00:00	2006-12-18 00:00:00	1900-01-01 00:00:00	2006-09-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2007-06-30 00:00:00	2007-03-31 00:00:00	2006-12-31 00:00:00	2007-09-30 00:00:00	2013-03-31 00:00:00	2015-03-31 00:00:00	2015-06-30 00:00:00	2014-06-30 00:00:00	2014-03-31 00:00:00	2013-06-30 00:00:00	2013-12-12 00:00:00	2013-09-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2015-03-06 00:00:00	2014-09-30 00:00:00	2007-12-31 00:00:00	2008-03-31 00:00:00	2008-03-31 00:00:00	2007-12-31 00:00:00	2007-12-31 00:00:00	1900-01-01 00:00:00	2008-07-17 00:00:00	2008-03-31 00:00:00	2007-06-30 00:00:00	2008-07-17 00:00:00	2007-09-30 00:00:00	1900-01-01 00:00:00	2008-03-31 00:00:00	2008-05-23 00:00:00	2008-06-30 00:00:00	2008-10-10 00:00:00	1900-01-01 00:00:00	2008-09-30 00:00:00	2008-11-20 00:00:00	2008-12-27 00:00:00	2008-12-31 00:00:00	1900-01-01 00:00:00	2008-12-31 00:00:00	1900-01-01 00:00:00	2009-03-31 00:00:00	2009-09-30 00:00:00	2009-12-31 00:00:00	2009-06-30 00:00:00	2010-03-31 00:00:00	2010-06-30 00:00:00	2009-12-31 00:00:00	2010-09-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2011-01-26 00:00:00	2010-12-31 00:00:00	2011-06-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2011-06-06 00:00:00	2010-12-13 00:00:00	2011-09-30 00:00:00	2011-03-31 00:00:00	2011-12-31 00:00:00	2012-03-31 00:00:00	1900-01-01 00:00:00	2013-03-31 00:00:00	2012-12-31 00:00:00	2014-12-31 00:00:00	2012-06-30 00:00:00	2014-12-31 00:00:00	2014-12-31 00:00:00	2014-12-15 00:00:00	2014-12-09 00:00:00	1900-01-01 00:00:00	2012-10-22 00:00:00	2012-09-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2012-09-30 00:00:00	2013-01-11 00:00:00	2012-12-31 00:00:00	2012-03-31 00:00:00	2014-04-30 00:00:00	1900-01-01 00:00:00	2013-12-31 00:00:00	2013-02-06 00:00:00	1900-01-01 00:00:00	2013-04-09 00:00:00	2013-03-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2015-10-23 00:00:00	2015-11-20 00:00:00	2016-01-04 00:00:00	2015-10-08 00:00:00	2015-09-30 00:00:00	2015-10-07 00:00:00	1900-01-01 00:00:00	2018-12-31 00:00:00	2019-05-29 00:00:00	2017-12-31 00:00:00	1900-01-01 00:00:00	2019-09-30 00:00:00	2020-03-04 00:00:00	2019-03-31 00:00:00	2020-09-30 00:00:00	2019-08-14 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2015-09-30 00:00:00	2015-12-31 00:00:00	2016-03-31 00:00:00	2016-06-30 00:00:00	2016-09-13 00:00:00	1900-01-01 00:00:00	2016-09-30 00:00:00	1900-01-01 00:00:00	2016-12-31 00:00:00	1900-01-01 00:00:00	2017-03-31 00:00:00	1900-01-01 00:00:00	2016-12-29 00:00:00	2017-03-09 00:00:00	2017-06-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2018-03-31 00:00:00	2019-03-04 00:00:00	2019-06-30 00:00:00	2020-10-26 00:00:00	2018-06-30 00:00:00	1900-01-01 00:00:00	2020-03-04 00:00:00	2019-09-30 00:00:00	2019-05-24 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2020-09-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2018-09-30 00:00:00	1900-01-01 00:00:00	2020-12-31 00:00:00	2019-12-31 00:00:00	2018-05-30 00:00:00	2022-12-31 00:00:00	2018-02-02 00:00:00	1900-01-01 00:00:00	2017-09-30 00:00:00	2019-02-27 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2019-06-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2018-12-31 00:00:00	2020-03-31 00:00:00	2018-03-31 00:00:00	2020-06-30 00:00:00	2021-02-26 00:00:00	2019-09-30 00:00:00	2019-09-30 00:00:00	1900-01-01 00:00:00	2020-03-31 00:00:00	2020-10-09 00:00:00	2020-12-24 00:00:00	1900-01-01 00:00:00	2021-03-31 00:00:00	1900-01-01 00:00:00	2022-03-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2021-06-28 00:00:00	2022-01-06 00:00:00	2021-06-30 00:00:00	2021-12-31 00:00:00	2021-09-30 00:00:00	2022-06-30 00:00:00	2021-06-03 00:00:00	2022-01-06 00:00:00	2022-10-25 00:00:00	2022-06-30 00:00:00	1900-01-01 00:00:00	2022-09-30 00:00:00
rpt_date	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	None	22001	None	None	None	22006	None	22006	22006	None	None	22006	None	22006	None	22006	None	None	None	None	None	22006	22006	None	22001	None	None	None	22006	None	None	22006	22006	22006	None	22006	None	22006	22006	None	22006	None	None	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	None	None	None	None	22006	22006	22006	22006	22006	22006	22006	None	22006	22006	22006	22006	22006	None	22006	22006	22006	22006	None	22006	22006	22001	22006	None	22006	None	22006	22006	22006	22006	22006	22006	22006	22006	None	None	22006	22006	22006	None	None	22006	22006	22006	22006	22006	22006	None	22006	None	22006	22006	22006	22006	22006	22006	None	22006	22006	None	None	22006	22006	22006	22006	22006	None	22006	22006	None	22006	22006	None	None	22006	22006	22006	22006	22006	22006	None	22006	22006	22006	None	22006	22006	22006	22006	22006	None	None	None	22006	22006	22006	22006	22006	None	22006	None	22006	None	22006	None	22006	22006	22006	None	None	22006	22006	22006	22006	22006	None	22006	22006	22006	None	None	22006	None	None	22006	None	22006	22006	22006	22006	22006	None	22006	22006	None	None	None	None	22006	None	None	22006	22006	22006	22006	22006	22006	22006	None	22006	22006	22006	None	22006	None	22006	None	None	None	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	None	22006

Table: filer_interests
filer_id	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828
session_id	2005	2001	2003	1999	1997	1995	2009	2007	2013	2011	2017	2021	2015	2019	2023
interest_cd	40305	40305	40305	40305	40305	40305	40305	40305	40305	40305	40305	40305	40305	40305	40305
effect_date	2005-01-01 00:00:00	2001-01-01 00:00:00	2003-01-01 00:00:00	1999-01-01 00:00:00	1997-01-01 00:00:00	1995-01-01 00:00:00	2009-01-01 00:00:00	2007-01-01 00:00:00	2013-01-01 00:00:00	2011-01-01 00:00:00	2017-01-01 00:00:00	2021-01-01 00:00:00	2015-01-01 00:00:00	2019-01-01 00:00:00	2023-01-01 00:00:00

Table: filer_to_filer_type
filer_id	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828
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	1995	1997	1999	2001	2003	2005	2007	2011	2013	2009	2015	2017	2019	2021	2023
category	0	0	0	0	None	None	None	None	None	None	None	None	None	None	None
category_type	0	0	0	0	None	None	None	None	None	None	None	None	None	None	None
sub_category	0	0	0	0	None	None	None	None	None	None	None	None	None	None	None
effect_dt	1995-01-01 00:00:00	1997-01-01 00:00:00	1999-01-01 00:00:00	2001-01-01 00:00:00	2003-01-01 00:00:00	2005-01-01 00:00:00	2007-01-01 00:00:00	2011-01-01 00:00:00	2013-01-01 00:00:00	2009-01-01 00:00:00	2015-01-01 00:00:00	2017-01-01 00:00:00	2019-01-01 00:00:00	2021-01-01 00:00:00	2023-01-01 00:00:00
sub_category_type	0	0	0	0	None	None	None	None	None	None	None	None	None	None	None
election_type	0	0	0	0	None	None	None	None	None	None	None	None	None	None	None
sub_category_a	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
nyq_dt	None	None	None	None	None	2000-01-01 00:00:00	2000-01-01 00:00:00	None	None	None	None	None	None	None	None
party_cd	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
county_cd	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
district_cd	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None

Table: filer_xref
filer_id		1146828
xref_id		E00559
effect_dt		1999-12-08 00:00:00
migration_source		MASTER

Table: filername
xref_filer_id	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559	E00559
filer_id	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828
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
status	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE
effect_dt	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00
naml	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES
namf	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
adr1	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
adr2	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
city	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	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
zip4	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814
phon	9166588200	9164445790	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9164445790	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9164445790	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9164445790	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9164445790	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9164445790	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9164445790	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9164445790	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9164445790	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9164445790	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9164445790	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9164445790	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200	9166588200
fax	9166588240	None	9166588240	9166588240	9166588240	9166588240	9166588240							9166588240	None	9166588240	9166588240	9166588240	9166588240	9166588240							9166588240	None	9166588240	9166588240	9166588240	9166588240	9166588240							9166588240	None	9166588240	9166588240	9166588240	9166588240	9166588240							9166588240	None	9166588240	9166588240	9166588240	9166588240	9166588240							9166588240	None	9166588240	9166588240	9166588240	9166588240	9166588240							9166588240	None	9166588240	9166588240	9166588240	9166588240	9166588240							9166588240	None	9166588240	9166588240	9166588240	9166588240	9166588240							9166588240	None	9166588240	9166588240	9166588240	9166588240	9166588240							9166588240	None	9166588240	9166588240	9166588240	9166588240	9166588240							9166588240	None	9166588240	9166588240	9166588240	9166588240	9166588240							9166588240	None	9166588240	9166588240	9166588240	9166588240	9166588240
email	None	None	None	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	None	None	None	None	None	None	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	None	None	None	None	None	None	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	None	None	None	None	None	None	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	None	None	None	None	None	None	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	None	None	None	None	None	None	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	None	None	None	None	None	None	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	None	None	None	None	None	None	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	None	None	None	None	None	None	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	None	None	None	None	None	None	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	None	None	None	None	None	None	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	None	None	None	None	None	None	[email protected]	[email protected]	None	None	None	[email protected]	[email protected]	None	None	None

Table: filers
filer_id		1146828

Table: lobbying_chg_log
filer_id	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828
change_no	9	1	0	10	11	12	14	13	17	16	15	18	19	20	21	22	24	25	23	26	29	28	31	30	27
session_id	2001	2001	2001	2003	2005	2005	2007	2007	2007	2007	2007	2011	2011	2011	2013	2015	2015	2017	2015	2017	2019	2019	2019	2019	2019
log_dt	2002-01-14 00:00:00	2001-12-17 00:00:00	2002-04-30 00:00:00	2003-03-03 00:00:00	2005-07-19 00:00:00	2006-05-17 00:00:00	2007-04-13 00:00:00	2007-04-13 00:00:00	2008-07-21 00:00:00	2008-07-10 00:00:00	2008-05-20 00:00:00	2011-06-09 00:00:00	2012-10-26 00:00:00	2013-04-12 00:00:00	2013-04-11 00:00:00	2015-04-14 00:00:00	2015-10-23 00:00:00	2017-03-14 00:00:00	2015-10-08 00:00:00	2018-02-02 00:00:00	2019-10-04 00:00:00	2019-05-28 00:00:00	2020-04-13 00:00:00	2020-01-28 00:00:00	2019-03-05 00:00:00
filer_type	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2
correction_flg	Y	Y	Y	Y	None	None	Y	Y	Y	Y	Y	Y	None	None	Y	Y	Y	Y	Y	Y	None	None	None	None	None
action	ADDED	DELETED	NEW	ADDED	DELETED	DELETED	ADDED NEW	TERMINATED	DELETED	ADDED	DELETED	ADDED	DELETED	DELETED	ADDED	DELETED	ADDED	TERMINATED	ADDED	DELETED	DELETED	DELETED	DELETED	DELETED	DELETED
attribute_changed	FIRM	LOBBYIST	LOBBYIST	None	LOBBYIST	LOBBYIST	None	None	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	FIRM	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	FIRM	LOBBYIST
ethics_dt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
interests	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
filer_full_name	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES	LEAGUE OF CALIFORNIA CITIES
filer_city	None	None	None	SACRAMENTO	None	None	SACRAMENTO	None	SACRAMENTO	SACRAMENTO	None	SACRAMENTO	None	None	SACRAMENTO	None	SACRAMENTO	None	SACRAMENTO	None	None	None	None	None	None
filer_st	None	None	None	CA	None	None	CA	None	CA	CA	None	CA	None	None	CA	None	CA	None	CA	None	None	None	None	None	None
filer_zip	None	None	None	95814	None	None	95814	None	95814	95814	None	95814	None	None	95814	None	95814	None	95814	None	None	None	None	None	None
filer_phone	None	None	None	9166588200	None	None	9164445790	None	9164445790	9164445790	None	9164445790	None	None	9166588200	None	9166588200	None	9166588200	None	None	None	None	None	None
entity_type	3	4	4	3	4	4	4	4	4	4	4	4	4	3	4	4	4	4	4	4	4	4	4	3	4
entity_name	EMANUELS & ASSOCIATES, KENNETH	JONES, DAVID A.	JEAN FLOURNOY KORINKE	JEA & ASSOCIATES	AMY O'GORMAN	JEAN F. KORINKE	ROSS, KYRA EMANUELS	HUNTER, YVONNE L.	THOMAS, P. ANTHONY	WHITING, JENNIFER L.	LAWSON STARK, LIISA A.	KOLPITCKE, KIRSTEN	DOROTHY HOLZEM	EMANUELS JONES AND ASSOCIATES	RHINE, JASON H.	KOLPITCKE, KIRSTIN	BERDUGO, RONALD	WHITING, JENNIFER	HARRIS, KENDRA N.	CROMARTIE, TIMOTHY	DANIEL CARRIGG	DANE HUTCHINGS	RONALD BERDUGO	RENNE PUBLIC LAW GROUP, LLP, DBA RENNE PUBLIC POLICY GROUP	ERIN EVANS-FUDEM
entity_city	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
entity_st	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
entity_zip	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
entity_phone	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
entity_id	1147358	1148317	1244205	None	1273085	1244205	None	1148153	None	None	1276613	None	1334113	1147358	None	1339024	None	1308325	None	1354532	1149387	1357409	1380744	1418731	1342574
responsible_officer	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
effect_dt	2002-01-08 00:00:00	2001-12-21 00:00:00	2002-04-22 00:00:00	2003-02-01 00:00:00	2005-01-01 00:00:00	2006-03-31 00:00:00	2007-04-13 00:00:00	2007-04-01 00:00:00	2008-07-11 00:00:00	2008-07-08 00:00:00	2008-05-15 00:00:00	2011-06-01 00:00:00	2012-10-11 00:00:00	2012-09-30 00:00:00	2013-04-01 00:00:00	2015-03-06 00:00:00	2015-10-12 00:00:00	2017-03-09 00:00:00	2015-09-28 00:00:00	2018-02-01 00:00:00	2019-09-30 00:00:00	2019-05-17 00:00:00	2020-03-25 00:00:00	2019-12-31 00:00:00	2019-02-28 00:00:00

Table: received_filings
filer_id	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828	1146828
filing_file_name	650659_0.cal	684540_0.cal	717866_0.cal	745458_0.cal	769643_0.cal	745458_1.cal	788147_0.cal	814675_0.cal	843182_0.cal	853687_0.cal	884114_0.cal	907058_0.cal	931294_0.cal	947754_0.cal	966231_0.cal	74341.cal	278939.cal	278961.cal	279015.cal	279059.cal	279083.cal	279233.cal
received_date	2000-08-09 00:00:00	2000-11-02 00:00:00	2001-01-30 00:00:00	2001-04-30 00:00:00	2001-07-24 00:00:00	2001-08-02 00:00:00	2001-10-19 00:00:00	2002-01-31 00:00:00	2002-05-15 00:00:00	2002-07-29 00:00:00	2002-10-30 00:00:00	2003-01-27 00:00:00	2003-04-30 00:00:00	2003-07-31 00:00:00	2003-10-23 00:00:00	2005-01-20 00:00:00	2015-10-07 00:00:00	2015-10-07 00:00:00	2015-10-07 00:00:00	2015-10-07 00:00:00	2015-10-07 00:00:00	2015-10-07 00:00:00
filing_directory	/usr/users/cafiler/disclose/ca99/cal	/usr/users/cafiler/disclose/ca99/cal	/usr/users/cafiler/disclose/ca99/cal	/usr/users/cafiler/disclose/ca99/cal	/usr/users/cafiler/disclose/ca99/cal	/usr/users/cafiler/disclose/ca99/cal	/usr/users/cafiler/disclose/ca99/cal	/usr/users/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp
filing_id	650659	684540	717866	745458	769643	745458	788147	814675	843182	853687	884114	907058	931294	947754	966231	None	None	None	None	None	None	None
form_id	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	None	None	None	None	None	None	None
receive_comment	Filing accepted, but but with warnings	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted, but with warnings	Filing accepted	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing did not pass validation	Filing did not pass validation	Filing did not pass validation	Filing did not pass validation	Filing did not pass validation	Filing did not pass validation	Filing did not pass validation