OpenCalAccess

Filer ID: 1147358

Table: filer_address
filer_id	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358
adrid	1108972	2047204	2079124	2115710	2159361	2204731	2545492	2412401	2278108	2510619	2345800	2467534
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	2023-01-01 00:00:00	2017-01-01 00:00:00	2013-01-01 00:00:00	2021-01-01 00:00:00	2015-01-01 00:00:00	2019-01-01 00:00:00
add_type	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051
session_id	1999	2003	2005	2007	2009	2011	2023	2017	2013	2021	2015	2019

Table: filer_filings
filer_id	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358
filing_id	509498	510127	506503	506816	507080	505496	507497	507753	508173	504082	505066	508426	509091	541833	508426	504499	504499	509743	505807	506074	508839	505496	505066	504499	507753	622959	636896	626119	610592	614837	628809	622959	650463	645274	658216	675165	711117	719937	720528	689361	721064	707781	730801	730803	730805	725546	748781	745106	789020	770797	793333	776529	801264	816248	812334	807030	838459	836721	816943	859424	847866	848046	855110	890514	918521	895473	882980	909167	918196	942896	933551	920988	923133	928566	967968	972787	953508	950598	953738	1005595	1005778	983989	984287	1026817	1041444	1012949	1031405	1015271	1056253	1067438	1063091	1091514	1099665	1099666	1083819	1084755	1101835	1119461	1122745	1122747	1133447	1144382	1106940	1106124	1153906	1141598	1165559	1181266	1187198	1204250	1180893	1211452	1237940	1226233	1222409	1235915	1256027	1237940	1278838	1271810	1261630	1297950	1306630	1285486	1301717	1776687	1769229	1965360	1975752	1864721	1859364	1799918	1807837	1792311	1792334	1935305	1950019	1328927	1316914	1347977	1226233	1386178	1392331	1375498	1421336	1396605	1386178	1432946	1386178	1437536	1430670	1430671	1462841	1470509	1484958	1450070	1386178	1500281	1500283	1502403	1502406	1502870	1538614	1555624	1567519	1550399	1550399	1583450	1583454	1586659	1602279	1598587	1599167	1599169	1599171	1617239	1637414	1623048	1642213	1637414	1657408	1654306	1665376	1677273	1661363	1690324	1910415	1917713	1717046	1717046	1717046	1709268	1742887	1740642	1724678	1848668	1846388	1819059	1764600	1754964	1983354	1996164	2419837	2390554	2317916	2390554	2289730	2333428	2438496	2016020	2016022	2013580	2013580	2029052	2032484	2029052	2055726	2029052	2096319	2118883	2113480	2153174	2149166	2139175	2172167	2179409	2158136	2328528	2210676	2345227	2191102	2566690	2548291	2360890	2468408	2328528	2269114	2232177	2458407	2523333	2481890	2593456	2540500	2675650	2705930	2540500	2623175	2578360	2644338	2662614	2738855
period_id	155	156	151	159	144	150	152	145	153	141	142	146	147	157	146	149	149	148	158	143	154	150	142	149	145	161	None	161	160	None	161	161	161	162	162	163	None	164	None	163	None	None	None	None	None	164	165	165	167	166	None	None	None	None	168	None	None	169	None	None	None	None	170	None	None	None	171	172	None	174	None	None	None	173	175	None	None	None	None	None	None	None	176	178	None	177	None	None	179	None	None	None	None	None	180	None	181	182	None	None	183	184	None	None	None	None	185	None	186	None	None	187	188	188	None	None	None	188	None	None	189	191	192	190	None	214	None	221	222	218	None	215	None	None	None	220	None	193	None	194	195	196	None	195	197	196	199	198	199	None	None	None	200	None	201	199	201	None	None	None	None	202	203	None	204	204	204	None	None	205	206	None	None	None	None	None	207	207	None	208	209	None	None	210	None	None	219	220	212	212	212	211	None	212	None	None	217	216	213	None	None	223	239	238	235	238	None	None	240	None	None	224	224	53	None	53	226	225	227	228	228	229	None	None	230	None	None	238	232	236	232	None	244	None	241	236	234	233	None	243	242	246	245	249	250	244	247	245	248	None	251
form_id	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F690	F625	F625	F625	F690	F690	F690	F625	F625	F625	F625	F690	F625	F625	F690	F625	F999	F690	F625	F690	F625	F625	F690	F625	F625	F625	F602	F625	F605	F625	F605	F601	F605	F605	F605	F625	F625	F625	F625	F625	F625	F625	F605	F625	F625	F605	F625	F625	F605	F625	F690	F605	F625	F625	F601	F605	F625	F625	F625	F625	F625	F605	F605	F625	F625	F625	F625	F605	F605	F625	F605	F690	F625	F625	F605	F625	F625	F625	F625	F605	F625	F601	F605	F605	F625	F625	F625	F625	F605	F605	F625	F625	F605	F605	F605	F605	F625	F605	F625	F605	F605	F625	F625	F601	F605	F601	F605	F625	F605	F605	F625	F625	F625	F625	F605	F625	F605	F625	F625	F625	F605	F625	F605	F605	F605	F625	F601	F625	F605	F625	F601	F601	F601	F625	F625	F625	F601	F625	F601	F605	F605	F605	F625	F605	F625	F625	F601	F606	F606	F605	F605	F625	F625	F601	F625	F601	F601	F605	F605	F625	F625	F605	F605	F605	F605	F605	F625	F625	F605	F625	F625	F605	F605	F625	F605	F605	F625	F601	F601	F601	F601	F625	F605	F625	F601	F605	F625	F625	F625	F605	F605	F625	F625	F625	F625	F625	F605	F605	F625	F605	F605	F625	F625	F625	F605	F625	F625	F625	F625	F625	F601	F625	F605	F601	F625	F605	F605	F601	F625	F625	F625	F601	F625	F601	F625	F601	F625	F625	F605	F625	F625	F625	F601	F625	F625	F601	F625	F625	F625	F605	F625
filing_sequence	0	0	0	0	0	0	0	0	0	0	1	0	0	0	1	2	1	0	0	0	0	1	0	0	1	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	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	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	1	0	0	0	0	0	2	0	1	0	0	0	0	0	0	0	3	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	1	0	2	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	1	0	0	0	1	0	2	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0
filing_date	1998-10-27 00:00:00	1999-01-29 00:00:00	1997-10-28 00:00:00	1999-10-26 00:00:00	1996-01-30 00:00:00	1997-07-29 00:00:00	1998-02-02 00:00:00	1996-04-30 00:00:00	1998-04-29 00:00:00	1995-05-01 00:00:00	1995-10-17 00:00:00	1996-07-31 00:00:00	1996-10-31 00:00:00	1999-04-30 00:00:00	1996-10-25 00:00:00	1997-12-01 00:00:00	1997-07-29 00:00:00	1997-01-27 00:00:00	1999-07-20 00:00:00	1995-10-31 00:00:00	1998-07-15 00:00:00	1998-01-23 00:00:00	1995-07-28 00:00:00	1997-04-28 00:00:00	1996-10-25 00:00:00	2000-04-22 00:00:00	2000-04-20 00:00:00	2000-04-27 00:00:00	2000-01-31 00:00:00	1999-12-24 00:00:00	2000-04-27 00:00:00	2000-04-27 00:00:00	2000-04-27 00:00:00	2000-08-01 00:00:00	2000-07-31 00:00:00	2000-10-24 00:00:00	2001-01-16 00:00:00	2001-02-01 00:00:00	2001-01-16 00:00:00	2000-10-25 00:00:00	2001-01-12 00:00:00	2001-01-02 00:00:00	2001-02-15 00:00:00	2001-02-15 00:00:00	2001-02-13 00:00:00	2001-01-31 00:00:00	2001-04-30 00:00:00	2001-04-27 00:00:00	2001-10-24 00:00:00	2001-07-27 00:00:00	2001-10-31 00:00:00	2001-07-31 00:00:00	2001-12-17 00:00:00	2002-01-30 00:00:00	2002-01-29 00:00:00	2002-01-14 00:00:00	2002-04-25 00:00:00	2002-04-23 00:00:00	2002-01-31 00:00:00	2002-07-31 00:00:00	2002-05-31 00:00:00	2002-06-27 00:00:00	2002-07-30 00:00:00	2002-10-31 00:00:00	2002-12-31 00:00:00	2002-12-10 00:00:00	2002-10-30 00:00:00	2003-01-29 00:00:00	2003-01-29 00:00:00	2003-07-20 00:00:00	2003-04-29 00:00:00	2003-02-11 00:00:00	2003-02-21 00:00:00	2003-04-23 00:00:00	2003-10-27 00:00:00	2003-10-29 00:00:00	2003-07-31 00:00:00	2003-08-11 00:00:00	2003-08-20 00:00:00	2004-01-29 00:00:00	2004-03-09 00:00:00	2003-10-08 00:00:00	2004-01-21 00:00:00	2004-07-27 00:00:00	2004-09-14 00:00:00	2004-04-29 00:00:00	2004-07-29 00:00:00	2004-04-29 00:00:00	2004-10-28 00:00:00	2004-12-17 00:00:00	2004-10-29 00:00:00	2004-12-30 00:00:00	2005-04-08 00:00:00	2005-04-08 00:00:00	2005-02-03 00:00:00	2005-01-27 00:00:00	2005-04-21 00:00:00	2005-08-01 00:00:00	2005-08-15 00:00:00	2005-08-15 00:00:00	2005-10-31 00:00:00	2006-01-25 00:00:00	2005-05-05 00:00:00	2005-04-29 00:00:00	2006-02-28 00:00:00	2006-01-11 00:00:00	2006-04-27 00:00:00	2006-06-22 00:00:00	2006-07-25 00:00:00	2006-10-03 00:00:00	2006-06-16 00:00:00	2006-10-25 00:00:00	2007-01-31 00:00:00	2007-01-03 00:00:00	2006-11-14 00:00:00	2006-12-22 00:00:00	2007-03-22 00:00:00	2007-05-17 00:00:00	2007-07-20 00:00:00	2007-06-04 00:00:00	2007-04-30 00:00:00	2007-10-31 00:00:00	2008-01-25 00:00:00	2007-07-31 00:00:00	2007-12-24 00:00:00	2013-07-19 00:00:00	2013-04-12 00:00:00	2015-04-30 00:00:00	2015-07-21 00:00:00	2014-07-21 00:00:00	2014-06-03 00:00:00	2013-10-30 00:00:00	2013-12-19 00:00:00	2013-09-25 00:00:00	2013-09-25 00:00:00	2015-01-31 00:00:00	2015-01-07 00:00:00	2008-04-30 00:00:00	2008-03-03 00:00:00	2008-07-29 00:00:00	2008-10-10 00:00:00	2008-12-29 00:00:00	2008-12-29 00:00:00	2008-10-29 00:00:00	2009-04-30 00:00:00	2009-01-31 00:00:00	2009-07-13 00:00:00	2009-07-23 00:00:00	2009-07-13 00:00:00	2008-12-29 00:00:00	2009-07-14 00:00:00	2009-07-14 00:00:00	2010-01-29 00:00:00	2010-02-17 00:00:00	2010-04-30 00:00:00	2009-10-27 00:00:00	2010-02-11 00:00:00	2010-07-13 00:00:00	2010-07-13 00:00:00	2010-07-21 00:00:00	2010-07-21 00:00:00	2010-07-24 00:00:00	2010-10-29 00:00:00	2010-12-23 00:00:00	2011-01-27 00:00:00	2010-12-14 00:00:00	2010-12-22 00:00:00	2011-01-05 00:00:00	2011-01-11 00:00:00	2011-04-18 00:00:00	2011-07-22 00:00:00	2011-06-20 00:00:00	2011-07-07 00:00:00	2011-07-07 00:00:00	2011-07-07 00:00:00	2011-10-10 00:00:00	2012-01-31 00:00:00	2011-10-31 00:00:00	2012-01-05 00:00:00	2012-02-22 00:00:00	2012-04-30 00:00:00	2012-04-05 00:00:00	2012-05-16 00:00:00	2012-07-30 00:00:00	2012-05-01 00:00:00	2012-09-18 00:00:00	2014-10-30 00:00:00	2014-12-09 00:00:00	2012-12-17 00:00:00	2012-12-13 00:00:00	2012-12-17 00:00:00	2012-10-31 00:00:00	2013-01-17 00:00:00	2013-01-31 00:00:00	2012-12-26 00:00:00	2014-04-10 00:00:00	2014-04-30 00:00:00	2014-01-31 00:00:00	2013-04-30 00:00:00	2012-12-26 00:00:00	2015-07-22 00:00:00	2015-10-29 00:00:00	2019-10-31 00:00:00	2019-10-31 00:00:00	2018-10-30 00:00:00	2019-07-16 00:00:00	2018-09-04 00:00:00	2019-01-09 00:00:00	2020-01-29 00:00:00	2016-02-05 00:00:00	2016-02-05 00:00:00	2016-02-03 00:00:00	2016-02-02 00:00:00	2016-04-16 00:00:00	2016-04-20 00:00:00	2016-07-16 00:00:00	2016-07-16 00:00:00	2016-08-26 00:00:00	2016-10-26 00:00:00	2017-01-11 00:00:00	2016-12-22 00:00:00	2017-04-25 00:00:00	2017-03-24 00:00:00	2016-12-22 00:00:00	2017-07-26 00:00:00	2017-08-08 00:00:00	2017-04-28 00:00:00	2019-04-16 00:00:00	2018-01-31 00:00:00	2019-01-30 00:00:00	2017-10-27 00:00:00	2020-12-30 00:00:00	2021-01-27 00:00:00	2018-12-18 00:00:00	2020-04-28 00:00:00	2018-12-18 00:00:00	2018-07-25 00:00:00	2018-04-17 00:00:00	2020-02-24 00:00:00	2020-10-26 00:00:00	2020-07-28 00:00:00	2021-07-15 00:00:00	2021-03-25 00:00:00	2022-05-01 00:00:00	2022-07-31 00:00:00	2020-12-30 00:00:00	2021-10-30 00:00:00	2021-04-28 00:00:00	2022-01-31 00:00:00	2022-03-25 00:00:00	2022-10-21 00:00:00
stmnt_type	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10005	10005	10005	10005	10005	10002	10005	10001	10005	10001	10005	10001	10005	10005	10005	10005	10005	10005	10005	10005	10005	10001	10001	10001	10005	10005	10005	10005	10001	10005	10005	10001	10005	10005	10002	10005	10001	10005	10005	10005	10001	10001	10005	10001	10005	10005	10005	10001	10001	10005	10005	10005	10005	10005	10005	10006	10001	10001	10005	10001	10005	10005	10001	10005	10005	10005	10005	10005	10001	10005	10001	10001	10005	10005	10001	10001	10005	10005	10005	10005	10001	10005	10001	10005	10005	10001	10001	10001	10005	10005	10005	10002	10005	10005	10001	10001	10001	10001	10005	10001	10006	10001	10001	10001	10005	10001	10006	10006	10006	10001	10005	10001	10005	10001	10002	10001	10005	10001	10001	10001	10002	10001	10002	10005	10005	10005	10001	10006	10001	10001	10002	10003	10003	10006	10006	10001	10001	10005	10001	10001	10002	10006	10006	10001	10001	10005	10006	10006	10006	10006	10001	10001	10006	10002	10001	10006	10006	10001	10006	10006	10001	10001	10002	10001	10002	10001	10005	10001	10005	10005	10001	10001	10001	10006	10006	10001	10001	10002	10001	10001	10006	10005	10001	10005	10005	10002	10001	10001	10005	10002	10001	10002	10001	10001	10001	10001	10005	10005	10001	10005	10005	10002	10001	10001	10001	10005	10001	10005	10001	10001	10001	10001	10005	10001	10001	10001	10002	10001	10001	10001	10001	10001	10001	10005	10001
stmnt_status	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	11003	11001	11001	11001	11001	11003	11001	11001	11003	11001	11001	11001	11001	11003	11001	11001	11001	11003	11003	11001	11003	11001	11001	11001	11003	11003	11001	11001	11001	11001	11001	11001	11001	11003	11003	11001	11003	11001	11001	11003	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	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	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	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	11003	11003	11003	11001	11003	11001	11003	11001	11003
session_id	1997	1997	1997	1999	1995	1997	1997	1995	1997	1995	1995	1995	1995	1999	1995	1997	1997	1995	1999	1995	1997	1997	1995	1997	1995	1999	1999	1999	1999	1999	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	2001	2001	2003	2001	2001	2001	2001	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2001	2003	2003	2003	2003	2003	2003	2003	2003	2003	2005	2005	2005	2003	2003	2005	2005	2005	2005	2005	2005	2005	2005	2005	2005	2005	2005	2005	2005	2005	2005	2005	2007	2005	2007	2007	2005	2007	2007	2007	2007	2007	2007	2007	2013	2011	2015	2015	2013	2013	2013	2013	2013	2013	2013	2015	2007	2007	2007	2007	2009	2009	2007	2009	2007	2009	2009	2009	2007	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2011	2009	2011	2011	2011	2007	2011	2011	2011	2011	2011	2011	2011	2011	2011	2011	2011	2011	2011	2011	2011	2011	2011	2013	2015	2013	2013	2013	2011	2013	2011	2013	2013	2013	2013	2013	2011	2015	2015	2019	2019	2017	2019	2017	2017	2019	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2015	2017	2017	2015	2017	2017	2017	2017	2019	2017	2017	2019	2021	2019	2019	2019	2019	2017	2017	2019	2019	2019	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021
user_id	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	CFLAGG	TTHAM	TTHAM	*	GPEREZ	TTHAM	CFLAGG	JLEHMAN	GKURIMOT	TTHAM	*	SARRIAGA	*	TTHAM	GPEREZ	TTHAM	TTHAM	SARRIAGA	SARRIAGA	SARRIAGA	SARRIAGA	GPEREZ	*	*	*	YBONILLA	YBONILLA	GPEREZ	YBONILLA	*	CFLAGG	YBONILLA	*	GPEREZ	YBONILLA	YBONILLA	GPEREZ	*	YBONILLA	SARRIAGA	GPEREZ	*	COMPLETED	YBONILLA	COMPLETED	YBONILLA	GPEREZ	GPEREZ	COMPLETED	COMPLETED	YBONILLA	YBONILLA	SARRIAGA	GPEREZ	YBONILLA	CFLAGG	YBONILLA	COMPLETED	COMPLETED	CFLAGG	COMPLETED	LTHIBAUL	LTHIBAUL	COMPLETED	GPEREZ	YRODRIGU	SARRIAGA	SARRIAGA	SARRIAGA	DHORRELL	YRODRIGU	YRODRIGU	YRODRIGU	CFLAGG	CFLAGG	YRODRIGU	LTHIBAUL	CFLAGG	SARRIAGA	SARRIAGA	CFLAGG	YRODRIGU	SARRIAGA	YRODRIGU	SARRIAGA	GPEREZ	YRODRIGU	YRODRIGU	*	SARRIAGA	SARRIAGA	SARRIAGA	YRODRIGU	GPEREZ	GPEREZ	YRODRIGU	LTHIBAUL	LTHIBAUL	LTHIBAUL	SARRIAGA	ASAETERN	YRODRIGU	AGLADNEY	AGLADNEY	ASAETERN	GPEREZ	ASAETERN	ASAETERN	YRODRIGU	YRODRIGU	AGLADNEY	PBANFORD	LTHIBAUL	CFLAGG	MGUERRA	YRODRIGU	YRODRIGU	CFLAGG	MGUERRA	MGUERRA	MGUERRA	YRODRIGU	MGUERRA	YRODRIGU	YRODRIGU	CFLAGG	CFLAGG	MGUERRA	YRODRIGU	MGUERRA	MGUERRA	YRODRIGU	YRODRIGU	YRODRIGU	YRODRIGU	YRODRIGU	ASAETERN	ASAETERN	SARRIAGA	ASAETERN	YRODRIGU	YRODRIGU	YRODRIGU	YRODRIGU	ASAETERN	ASAETERN	GPEREZ	YRODRIGU	YRODRIGU	YRODRIGU	YRODRIGU	ASAETERN	ASAETERN	YRODRIGU	ASAETERN	ASAETERN	YRODRIGU	YRODRIGU	AGLADNEY	YRODRIGU	YRODRIGU	ASAETERN	PBANFORD	YRODRIGU	GKURIMOT	YRODRIGU	ASAETERN	ASAETERN	ASAETERN	GKURIMOT	SARRIAGA	ASAETERN	ASAETERN	ASAETERN	YRODRIGU	YRODRIGU	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	YRODRIGU	GPEREZ	AGLADNEY	GPEREZ	GPEREZ	AGLADNEY	AGLADNEY	AGLADNEY	GPEREZ	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	SARRIAGA	AGLADNEY	SARRIAGA	SARRIAGA	AGLADNEY	GPEREZ	SARRIAGA	GPEREZ	AGLADNEY	AGLADNEY	AGLADNEY	MMERCHANT	MKIRKHAM	GPEREZ	MKIRKHAM	GPEREZ	AGLADNEY	AGLADNEY	GPEREZ	MKIRKHAM	MKIRKHAM	CHATRIDGE	CAFILER	CAFILER	CAFILER	MMERCHANT	CAFILER	MKIRKHAM	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	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11002	11003	11003	11002	11003	11003	11002	11003	11003	11003	11002	11003	11003	11003	11003	11002	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	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	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	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	11003	11003	11003	11003	11003	11003	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	11003	11001	11003	11001	11001	11001	11001	11003	11003	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	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	11003	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	11001	11003	11003	11001	11001	11001	11003	11001	11001	11001	11001	11001	11003	11001	11003	11003	11001	11003	11003	11003	11001	11001	11001	11003	11001	11003	11001	11003	11001	11001	11003	11001	11001	11001	11003	11003	11003	11003	11003	11001	11003	11003	11003
rpt_start	1998-07-01 00:00:00	1998-10-01 00:00:00	1997-07-01 00:00:00	1999-07-01 00:00:00	1995-10-01 00:00:00	1997-04-01 00:00:00	1997-10-01 00:00:00	1996-01-01 00:00:00	1998-01-01 00:00:00	1995-01-01 00:00:00	1995-04-01 00:00:00	1996-04-01 00:00:00	1996-07-01 00:00:00	1999-01-01 00:00:00	1996-04-01 00:00:00	1997-01-01 00:00:00	1997-01-01 00:00:00	1996-10-01 00:00:00	1999-04-01 00:00:00	1995-07-01 00:00:00	1998-04-01 00:00:00	1997-04-01 00:00:00	1995-04-01 00:00:00	1997-01-01 00:00:00	1996-01-01 00:00:00	2000-01-01 00:00:00	None	2000-01-01 00:00:00	1999-10-01 00:00:00	1999-04-04 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-04-01 00:00:00	2000-04-01 00:00:00	2000-07-01 00:00:00	1900-01-01 00:00:00	2000-10-01 00:00:00	1900-01-01 00:00:00	2000-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	1900-01-01 00:00:00	2000-10-01 00:00:00	2001-01-01 00:00:00	2001-01-01 00:00:00	2001-07-01 00:00:00	2001-04-01 00:00:00	2001-07-01 00:00:00	2001-04-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	2002-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	1900-01-01 00:00:00	2002-04-01 00:00:00	2002-07-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2002-07-01 00:00:00	2002-10-01 00:00:00	2002-10-01 00:00:00	2003-04-01 00:00:00	2003-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2003-01-01 00:00:00	2003-07-01 00:00:00	2003-07-01 00:00:00	2003-04-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2003-10-01 00:00:00	1900-01-01 00:00:00	2002-07-01 00:00:00	2003-10-01 00:00:00	2004-04-01 00:00:00	1900-01-01 00:00:00	2004-01-01 00:00:00	2004-04-01 00:00:00	2004-01-01 00:00:00	2004-07-01 00:00:00	1900-01-01 00:00:00	2004-07-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2004-10-01 00:00:00	2004-10-01 00:00:00	2005-01-01 00:00:00	2005-04-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2005-07-01 00:00:00	2005-10-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	2006-01-01 00:00:00	1900-01-01 00:00:00	2006-04-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2006-07-01 00:00:00	2006-10-01 00:00:00	2006-12-22 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2006-10-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2007-01-01 00:00:00	2007-07-01 00:00:00	2007-10-01 00:00:00	2007-04-01 00:00:00	1900-01-01 00:00:00	2013-04-01 00:00:00	1900-01-01 00:00:00	2015-01-01 00:00:00	2015-04-01 00:00:00	2014-04-01 00:00:00	1900-01-01 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	2014-10-01 00:00:00	1900-01-01 00:00:00	2008-01-01 00:00:00	1900-01-01 00:00:00	2008-04-01 00:00:00	2008-09-16 00:00:00	2008-12-29 00:00:00	1900-01-01 00:00:00	2008-07-01 00:00:00	2009-01-01 00:00:00	2008-10-01 00:00:00	2009-07-13 00:00:00	2009-04-01 00:00:00	2009-07-13 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2009-10-01 00:00:00	1900-01-01 00:00:00	2010-01-01 00:00:00	2009-07-01 00:00:00	2010-02-11 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	2010-04-01 00:00:00	2010-07-01 00:00:00	1900-01-01 00:00:00	2010-10-01 00:00:00	2010-12-14 00:00:00	2010-12-22 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2011-01-01 00:00:00	2011-04-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	1900-01-01 00:00:00	2011-09-30 00:00:00	2011-07-01 00:00:00	1900-01-01 00:00:00	2012-10-01 00:00:00	2012-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2012-04-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2014-07-01 00:00:00	2014-12-09 00:00:00	2012-12-17 00:00:00	2012-12-13 00:00:00	2012-12-17 00:00:00	2012-07-01 00:00:00	1900-01-01 00:00:00	2012-10-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2014-01-01 00:00:00	2013-10-01 00:00:00	2013-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2015-07-01 00:00:00	2019-07-01 00:00:00	2019-04-01 00:00:00	2018-07-01 00:00:00	2019-04-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2019-10-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2015-10-01 00:00:00	2015-10-01 00:00:00	2016-01-01 00:00:00	1900-01-01 00:00:00	2016-01-01 00:00:00	2016-04-01 00:00:00	2016-01-01 00:00:00	2016-07-01 00:00:00	2016-10-01 00:00:00	2016-12-22 00:00:00	2017-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2017-04-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2019-04-16 00:00:00	2017-10-01 00:00:00	2018-10-01 00:00:00	2019-07-01 00:00:00	1900-01-01 00:00:00	2020-10-01 00:00:00	1900-01-01 00:00:00	2020-01-01 00:00:00	2018-12-18 00:00:00	2018-04-01 00:00:00	2018-01-01 00:00:00	1900-01-01 00:00:00	2020-07-01 00:00:00	2020-04-01 00:00:00	2021-04-01 00:00:00	2021-03-25 00:00:00	2022-01-01 00:00:00	2022-04-01 00:00:00	2020-12-30 00:00:00	2021-07-01 00:00:00	2021-01-01 00:00:00	2021-10-01 00:00:00	1900-01-01 00:00:00	2022-07-01 00:00:00
rpt_end	1998-09-30 00:00:00	1998-12-31 00:00:00	1997-09-30 00:00:00	1999-09-30 00:00:00	1995-12-31 00:00:00	1997-06-30 00:00:00	1997-12-31 00:00:00	1996-03-31 00:00:00	1998-03-31 00:00:00	1995-03-31 00:00:00	1995-06-30 00:00:00	1996-06-30 00:00:00	1996-09-30 00:00:00	1999-03-31 00:00:00	1996-06-30 00:00:00	1997-03-31 00:00:00	1997-03-31 00:00:00	1996-12-31 00:00:00	1999-06-30 00:00:00	1995-09-30 00:00:00	1998-06-30 00:00:00	1997-06-30 00:00:00	1995-06-30 00:00:00	1997-03-31 00:00:00	1996-03-31 00:00:00	2000-03-31 00:00:00	None	2000-03-31 00:00:00	1999-12-31 00:00:00	1999-06-30 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-06-30 00:00:00	2000-06-30 00:00:00	2000-09-30 00:00:00	1900-01-01 00:00:00	2000-12-31 00:00:00	1900-01-01 00:00:00	2000-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	1900-01-01 00:00:00	2000-12-31 00:00:00	2001-03-31 00:00:00	2001-03-31 00:00:00	2001-09-30 00:00:00	2001-06-30 00:00:00	2001-09-30 00:00:00	2001-06-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	2002-03-31 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	1900-01-01 00:00:00	2002-06-30 00:00:00	2002-09-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2002-09-30 00:00:00	2002-12-31 00:00:00	2002-12-31 00:00:00	2003-06-30 00:00:00	2003-03-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2003-03-31 00:00:00	2003-09-30 00:00:00	2003-09-30 00:00:00	2003-06-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2003-12-31 00:00:00	1900-01-01 00:00:00	2002-09-30 00:00:00	2003-12-31 00:00:00	2004-06-30 00:00:00	1900-01-01 00:00:00	2004-03-31 00:00:00	2004-06-30 00:00:00	2004-03-31 00:00:00	2004-09-30 00:00:00	1900-01-01 00:00:00	2004-09-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2004-12-31 00:00:00	2004-12-31 00:00:00	2005-03-31 00:00:00	2005-06-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2005-09-30 00:00:00	2005-12-31 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	2006-03-31 00:00:00	1900-01-01 00:00:00	2006-06-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2006-09-30 00:00:00	2006-12-31 00:00:00	2006-12-22 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2006-12-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2007-03-31 00:00:00	2007-09-30 00:00:00	2007-12-31 00:00:00	2007-06-30 00:00:00	1900-01-01 00:00:00	2013-06-30 00:00:00	1900-01-01 00:00:00	2015-03-31 00:00:00	2015-06-30 00:00:00	2014-06-30 00:00:00	1900-01-01 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	2014-12-31 00:00:00	1900-01-01 00:00:00	2008-03-31 00:00:00	1900-01-01 00:00:00	2008-06-30 00:00:00	2008-09-16 00:00:00	2008-12-29 00:00:00	1900-01-01 00:00:00	2008-09-30 00:00:00	2009-03-31 00:00:00	2008-12-31 00:00:00	2009-07-13 00:00:00	2009-06-30 00:00:00	2009-07-13 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2009-12-31 00:00:00	1900-01-01 00:00:00	2010-03-31 00:00:00	2009-09-30 00:00:00	2010-02-11 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	2010-06-30 00:00:00	2010-09-30 00:00:00	1900-01-01 00:00:00	2010-12-31 00:00:00	2010-12-14 00:00:00	2010-12-22 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2011-03-30 00:00:00	2011-06-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	1900-01-01 00:00:00	2011-12-31 00:00:00	2011-09-30 00:00:00	1900-01-01 00:00:00	2011-12-31 00:00:00	2012-03-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2012-06-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2014-09-30 00:00:00	2014-12-09 00:00:00	2012-12-17 00:00:00	2012-12-13 00:00:00	2012-12-17 00:00:00	2012-09-30 00:00:00	1900-01-01 00:00:00	2012-12-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2014-03-31 00:00:00	2013-12-31 00:00:00	2013-03-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2015-09-30 00:00:00	2019-09-30 00:00:00	2019-06-30 00:00:00	2018-09-30 00:00:00	2019-06-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2019-12-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2015-12-31 00:00:00	2015-12-31 00:00:00	1931-03-30 00:00:00	1900-01-01 00:00:00	1931-03-30 00:00:00	2016-06-30 00:00:00	2016-03-31 00:00:00	2016-09-30 00:00:00	2016-12-31 00:00:00	2016-12-22 00:00:00	2017-03-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2017-06-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2019-04-16 00:00:00	2017-12-31 00:00:00	2018-12-31 00:00:00	2017-09-30 00:00:00	1900-01-01 00:00:00	2020-12-31 00:00:00	1900-01-01 00:00:00	2020-03-31 00:00:00	2018-12-18 00:00:00	2018-06-30 00:00:00	2018-03-31 00:00:00	1900-01-01 00:00:00	2020-09-30 00:00:00	2020-06-30 00:00:00	2021-06-30 00:00:00	2021-03-25 00:00:00	2022-03-31 00:00:00	2022-06-30 00:00:00	2020-12-30 00:00:00	2021-09-30 00:00:00	2021-03-31 00:00:00	2021-12-31 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
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	None	None	None	None	None	None	None	None	None	None	22001	None	22001	None	None	None	22001	22001	None	None	None	None	None	None	None	22001	22001	None	22001	None	None	22001	None	None	None	None	None	22001	None	22001	22001	None	None	22001	22001	None	None	None	None	22006	None	22006	None	None	22006	22001	22001	None	None	None	22006	None	None	22001	22001	22001	22001	None	22006	None	22006	22006	22006	None	22006	None	None	None	22006	None	22001	None	22001	22001	22001	None	22001	22006	22001	22006	22006	22006	None	None	None	22006	None	22006	22006	22006	None	None	None	None	22006	22006	None	22006	22006	22006	None	None	22006	22006	None	None	None	None	None	22006	22006	None	22006	22006	None	None	22006	None	None	22006	22006	22006	22006	22006	22006	None	22006	None	None	22006	22006	22006	None	None	22006	22006	22006	22006	22006	None	None	22006	None	None	22006	22006	22006	None	22006	22006	22006	22006	22006	22006	22006	None	None	22006	None	None	22006	22006	22006	22006	None	22006	None	22006	22006	22006	22006	None	22006	22006	22006	22006	22006	22006	22006	22006	22006	22006	None	22006

Table: filer_to_filer_type
filer_id	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358
filer_type	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3
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	1999	1997	2001	2003	2005	2007	2011	2013	2009	2019	2015	2021	2017	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	1999-01-01 00:00:00	1997-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	2019-01-01 00:00:00	2015-01-01 00:00:00	2021-01-01 00:00:00	2017-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		1147358
xref_id		F20023
effect_dt		1999-12-08 00:00:00
migration_source		MASTER

Table: filername
xref_filer_id	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023	F20023
filer_id	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358
filer_type	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM
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
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
naml	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES & ASSOCIATES	EMANUELS JONES & ASSOCIATES	EMANUELS JONES & ASSOCIATES	EMANUELS JONES & ASSOCIATES	EMANUELS JONES & ASSOCIATES	EMANUELS JONES & ASSOCIATES	EMANUELS JONES & ASSOCIATES	EMANUELS JONES & ASSOCIATES	EMANUELS JONES & ASSOCIATES	EMANUELS JONES & ASSOCIATES	EMANUELS JONES & ASSOCIATES	EMANUELS JONES & ASSOCIATES	EMANUELS JONES & ASSOCIATES	EMANUELS JONES & ASSOCIATES	EMANUELS JONES & ASSOCIATES	EMANUELS JONES & ASSOCIATES	EMANUELS JONES & ASSOCIATES	EMANUELS JONES & ASSOCIATES	EMANUELS JONES & ASSOCIATES	EMANUELS JONES & ASSOCIATES	EMANUELS JONES & ASSOCIATES	EMANUELS JONES & ASSOCIATES	EMANUELS JONES & ASSOCIATES	EMANUELS JONES & ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS & ASSOCIATES, KENNETH	EMANUELS & ASSOCIATES, KENNETH	EMANUELS & ASSOCIATES, KENNETH	EMANUELS & ASSOCIATES, KENNETH	EMANUELS & ASSOCIATES, KENNETH	EMANUELS & ASSOCIATES, KENNETH	EMANUELS & ASSOCIATES, KENNETH	EMANUELS & ASSOCIATES, KENNETH	EMANUELS & ASSOCIATES, KENNETH	EMANUELS & ASSOCIATES, KENNETH	EMANUELS & ASSOCIATES, KENNETH	EMANUELS & ASSOCIATES, KENNETH	EMANUELS & ASSOCIATES, KENNETH	EMANUELS & ASSOCIATES, KENNETH	EMANUELS & ASSOCIATES, KENNETH	EMANUELS & ASSOCIATES, KENNETH	EMANUELS & ASSOCIATES, KENNETH	EMANUELS & ASSOCIATES, KENNETH	EMANUELS & ASSOCIATES, KENNETH	EMANUELS & ASSOCIATES, KENNETH	EMANUELS & ASSOCIATES, KENNETH	EMANUELS & ASSOCIATES, KENNETH	EMANUELS & ASSOCIATES, KENNETH	EMANUELS & ASSOCIATES, KENNETH	EMANUELS AND ASSOCIATES, KENNETH	EMANUELS AND ASSOCIATES, KENNETH	EMANUELS AND ASSOCIATES, KENNETH	EMANUELS AND ASSOCIATES, KENNETH	EMANUELS AND ASSOCIATES, KENNETH	EMANUELS AND ASSOCIATES, KENNETH	EMANUELS AND ASSOCIATES, KENNETH	EMANUELS AND ASSOCIATES, KENNETH	EMANUELS AND ASSOCIATES, KENNETH	EMANUELS AND ASSOCIATES, KENNETH	EMANUELS AND ASSOCIATES, KENNETH	EMANUELS AND ASSOCIATES, KENNETH	EMANUELS AND ASSOCIATES, KENNETH	EMANUELS AND ASSOCIATES, KENNETH	EMANUELS AND ASSOCIATES, KENNETH	EMANUELS AND ASSOCIATES, KENNETH	EMANUELS AND ASSOCIATES, KENNETH	EMANUELS AND ASSOCIATES, KENNETH	EMANUELS AND ASSOCIATES, KENNETH	EMANUELS AND ASSOCIATES, KENNETH	EMANUELS AND ASSOCIATES, KENNETH	EMANUELS AND ASSOCIATES, KENNETH	EMANUELS AND ASSOCIATES, KENNETH	EMANUELS AND ASSOCIATES, KENNETH
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
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
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
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
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
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
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
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	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	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789	9164446789
fax	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303	9164440303
email	[email protected]	None	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]

Table: filers
filer_id		1147358

Table: lobbying_chg_log
filer_id	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358
change_no	3	1	2	4	7	8	0	9	10	11	12	13	16	21	14	15	23	19	20	22	17	18	24	25	27	26	29	28	34	30	31	33	32	37	35	36	38	40	41	42	39	43	44	45	47	48	46	50	49	51	52	53	54	55	56	58	57	59
session_id	1999	1999	1999	2001	2001	2001	2001	2001	2001	2001	2003	2003	2003	2005	2003	2003	2005	2005	2005	2005	2005	2005	2005	2007	2007	2007	2007	2007	2009	2009	2009	2007	2007	2007	2009	2009	2011	2011	2011	2011	2011	2011	2011	2011	2013	2013	2013	2015	2013	2015	2015	2015	2017	2017	2017	2019	2017	2021
log_dt	2000-11-09 00:00:00	2000-05-15 00:00:00	2000-10-06 00:00:00	2001-02-13 00:00:00	2001-02-15 00:00:00	2001-02-15 00:00:00	2001-12-17 00:00:00	2002-01-14 00:00:00	2002-01-31 00:00:00	2002-06-27 00:00:00	2003-02-21 00:00:00	2003-08-11 00:00:00	2004-09-14 00:00:00	2005-04-08 00:00:00	2004-03-09 00:00:00	2003-08-20 00:00:00	2006-06-16 00:00:00	2005-08-15 00:00:00	2005-08-15 00:00:00	2006-01-11 00:00:00	2005-04-08 00:00:00	2005-04-29 00:00:00	2006-10-03 00:00:00	2007-03-22 00:00:00	2007-07-20 00:00:00	2007-06-04 00:00:00	2008-03-03 00:00:00	2007-12-24 00:00:00	2010-02-17 00:00:00	2009-07-14 00:00:00	2009-07-14 00:00:00	2008-12-29 00:00:00	2008-12-29 00:00:00	2011-01-11 00:00:00	2010-07-21 00:00:00	2010-07-21 00:00:00	2011-06-20 00:00:00	2012-02-29 00:00:00	2012-04-05 00:00:00	2012-05-16 00:00:00	2012-01-05 00:00:00	2012-09-18 00:00:00	2012-12-26 00:00:00	2013-04-12 00:00:00	2013-09-25 00:00:00	2013-09-25 00:00:00	2013-01-17 00:00:00	2015-07-22 00:00:00	2014-06-03 00:00:00	2016-02-05 00:00:00	2016-02-05 00:00:00	2016-04-20 00:00:00	2017-04-28 00:00:00	2017-08-22 00:00:00	2018-09-04 00:00:00	2020-02-24 00:00:00	2019-01-09 00:00:00	2020-12-30 00:00:00
filer_type	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3
correction_flg	None	Y	None	Y	Y	Y	Y	Y	Y	Y	Y	Y	None	Y	None	Y	None	None	None	None	Y	None	None	Y	Y	Y	Y	Y	Y	Y	Y	None	None	None	Y	Y	Y	Y	None	None	Y	None	None	None	None	None	None	Y	None	Y	Y	Y	Y	Y	Y	None	None	None
action	SET ACTIVE	ADDED	CHANGED	NEW	NEW	ADDED	ADDED	ADDED	DELETED	DELETED	ADDED	DELETED	DELETED	NEW	DELETED	NEW	DELETED	DELETED	DELETED	DELETED	DELETED	ADDED	DELETED	DELETED	ADDED	ADDED	ADDED	DELETED	ADDED	ADDED	ADDED	IN SUSPENSE	ADDED	DELETED	DELETED	DELETED	ADDED	ADDED	ADDED	DELETED	ADDED	DELETED	DELETED	DELETED	SET ACTIVE	SET ACTIVE	ADDED	DELETED	ADDED	DELETED	ADDED	ADDED	ADDED	ADDED	ADDED	ADDED	DELETED	ADDED
attribute_changed	BASE RECORD	CLIENT	ADDRESS AND PHONE	EMPLOYER	EMPLOYER	EMPLOYER	LOBBYIST	EMPLOYER	EMPLOYER	EMPLOYER	None	None	LOBBYIST	None	CLIENT	None	CLIENT	CLIENT	CLIENT	CLIENT	None	CLIENT	CLIENT	EMPLOYER	EMPLOYER	CLIENT	LOBBYIST	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	CLIENT	CLIENT	CLIENT	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	CLIENT	CLIENT	EMPLOYER	CLIENT	LOBBYIST	EMPLOYER	CLIENT	CLIENT	CLIENT	EMPLOYER	CLIENT	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	CLIENT	CLIENT	CLIENT
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	None	None	None	None	None	None	None	None	None	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	None	None	None	None	None	None	None	None	None	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	EMANUELS AND ASSOCIATES, KENNETH	EMANUELS AND ASSOCIATES, KENNETH	EMANUELS AND ASSOCIATES, KENNETH	EMANUELS & ASSOCIATES, KENNETH	EMANUELS & ASSOCIATES, KENNETH	EMANUELS & ASSOCIATES, KENNETH	EMANUELS & ASSOCIATES, KENNETH	EMANUELS & ASSOCIATES, KENNETH	EMANUELS & ASSOCIATES, KENNETH	EMANUELS & ASSOCIATES, KENNETH	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES & ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES & ASSOCIATES	EMANUELS JONES & ASSOCIATES	EMANUELS JONES & ASSOCIATES	EMANUELS JONES & ASSOCIATES	EMANUELS JONES & ASSOCIATES	EMANUELS JONES & ASSOCIATES	EMANUELS JONES & ASSOCIATES	EMANUELS JONES & ASSOCIATES	EMANUELS JONES & ASSOCIATES	EMANUELS JONES & ASSOCIATES	EMANUELS JONES & ASSOCIATES	EMANUELS JONES & ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES	EMANUELS JONES AND ASSOCIATES
filer_city	None	None	None	None	SACRAMENTO	SACRAMENTO	None	None	None	None	SACRAMENTO	None	None	SACRAMENTO	None	SACRAMENTO	None	None	None	None	None	None	None	None	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	None	None	None	None	None	None	None	None	SACRAMENTO	None	None	None	None	None	None	None	None	None	None	SACRAMENTO	None	None	SACRAMENTO	SACRAMENTO	SACRAMENTO	None	SACRAMENTO	None	None	None
filer_st	None	None	None	None	CA	CA	None	None	None	None	CA	None	None	CA	None	CA	None	None	None	None	None	None	None	None	CA	CA	CA	CA	None	None	None	None	None	None	None	None	CA	None	None	None	None	None	None	None	None	None	None	CA	None	None	CA	CA	CA	None	CA	None	None	None
filer_zip	None	None	None	None	95814	95814	None	None	None	None	95814	None	None	95814	None	95814	None	None	None	None	None	None	None	None	95814	95814	95814	95814	None	None	None	None	None	None	None	None	95814	None	None	None	None	None	None	None	None	None	None	95814	None	None	95814	95814	95814	None	95814	None	None	None
filer_phone	None	None	None	None	9164446789	9164446789	None	None	None	None	9164446789	None	None	9164446789	None	9164446789	None	None	None	None	None	None	None	None	9164446789	9164446789	9164446789	9164446789	None	None	None	None	None	None	None	None	9164446789	None	None	None	None	None	None	None	None	None	None	9164446789	None	None	9164446789	9164446789	9164446789	None	9164446789	None	None	None
entity_type	1	1	1	2	2	2	4	2	2	2	2	2	4	2	1	2	1	1	1	1	2	1	1	2	2	3	4	2	2	2	2	1	1	1	2	2	2	2	1	1	2	1	4	2	1	1	1	2	1	2	2	2	2	2	2	1	1	1
entity_name	WESTMINSTER, CITY OF	WESTMINSTER, CITY OF	NEWPORT BEACH, CITY OF	MURRIETA, CITY OF	CITY OF BREA	CITY OF PASADENA	DAVID A. JONES	LEAGUE OF CALIFORNIA CITIES	CITY OF TUSTIN	CITY OF PALO ALTO	LA HABRA, CITY OF	BREA, CITY OF	KENNETH J. EMANUELS	SANTA CLARA, CITY OF	WESTMINSTER, CITY OF	TRUCKEE, TOWN OF	CALIFORNIA COALITION ON ALCOHOL POLICY REFORM	RANCHO MIRAGE/REDEVELOPMENT AGENCY, CITY OF	SANTA CLARA, CITY OF	PUBLIC EMPLOYMENT SERVICE AUTHORITY	MILPITAS, CITY OF	PUBLIC EMPLOYMENT SERVICE AUTHORITY	GLENDALE, CITY OF	ORANGE COUNTY DIVISION, LEAGUE OF CALIFORNIA CITIES	SAN MARCOS; CITY OF	ARNOLD & ASSOCIATES	BOWER, HUGH O.	WALNUT CREEK; CITY OF	CALIFORNIA MUNICIPAL BUSINESS TAX ASSOCIATION	MAMMOTH LAKES; TOWN OF	MONO; COUNTY OF	AGOURA HILLS; CITY OF	AGOURA HILLS; CITY OF	NOVATO; CITY OF	INDIAN WELLS; CITY OF	NEWPORT BEACH; CITY OF	PACIFIC COMPANIES; THE	WHEATLAND; CITY OF	AMADOR; COUNTY OF	PACIFIC COMPANIES; THE	STOCKTON; CITY OF	LANCASTER REDEVELOPMENT AGENCY	HUBERT O. BOWER	LEAGUE OF CALIFORNIA CITIES	GLENDALE; CITY OF	PLAYA SENIOR AFFORDABLE HOUSING, LP	L.A. GAY & LESBIAN CENTER	LAKE FOREST; CITY OF	CAPITOL AREA DEVELOPMENT AUTHORITY	AMADOR; COUNTY OF	CARLSBAD; CITY OF	BURBANK HOUSING	CALIFORNIA MANUFACTURING TECHNOLOGY CONSULTING	LOS BANOS, CITY OF	SOUTH PASADENA; CITY OF	CORONADO; CITY OF	SACRAMENTO; CITY OF	SOLANA BEACH; CITY OF
entity_city	None	None	NEWPORT BEACH	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	CA	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	926588915	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	9496443000	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	1146419	1146419	1142907	1233619	None	None	1148317	1146828	1143352	1144627	None	1233620	1147844	None	1146419	None	1283729	1143473	1276122	1276725	1253255	1276725	1143740	1144404	None	None	None	None	1146263	1279331	1262917	1314211	1314211	1144718	1143255	1142907	None	1344255	1251453	1339606	1244132	1143791	1304507	1146828	1143740	1360972	1325864	None	1242013	1251453	None	None	None	1398044	None	1143790	1143240	1419732
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	None	None	None	None	None	None	None	None	None	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	None	None	None	2001-02-01 00:00:00	2001-02-01 00:00:00	2001-02-01 00:00:00	2002-01-01 00:00:00	2002-01-08 00:00:00	2002-01-01 00:00:00	2002-07-01 00:00:00	2003-02-03 00:00:00	2003-08-01 00:00:00	2004-08-27 00:00:00	2005-04-01 00:00:00	2004-02-28 00:00:00	2003-09-01 00:00:00	2006-06-01 00:00:00	2005-08-01 00:00:00	2005-08-01 00:00:00	2005-12-31 00:00:00	2005-04-01 00:00:00	2005-04-15 00:00:00	2006-06-30 00:00:00	2007-03-15 00:00:00	2007-07-11 00:00:00	2007-06-01 00:00:00	2008-02-19 00:00:00	2007-12-31 00:00:00	2010-02-01 00:00:00	2009-05-07 00:00:00	2009-05-07 00:00:00	2008-12-19 00:00:00	2008-12-19 00:00:00	2008-09-10 00:00:00	2010-06-30 00:00:00	2010-06-30 00:00:00	2011-06-17 00:00:00	2012-02-29 00:00:00	2012-03-27 00:00:00	2011-10-01 00:00:00	2012-01-01 00:00:00	2012-07-01 00:00:00	2012-11-30 00:00:00	2012-09-30 00:00:00	2013-09-11 00:00:00	2013-09-17 00:00:00	2013-01-17 00:00:00	2015-06-30 00:00:00	2014-05-29 00:00:00	2015-12-31 00:00:00	2015-12-01 00:00:00	2016-04-15 00:00:00	2017-03-16 00:00:00	2017-08-01 00:00:00	2018-08-25 00:00:00	2020-03-01 00:00:00	2018-12-01 00:00:00	2021-01-01 00:00:00

Table: lobbyist_contributions1
filer_id		1147358
filing_period_start_dt		2000-10-01 00:00:00
filing_period_end_dt		2000-12-31 00:00:00
contribution_dt		None
recipient_name		CORREA FOR ASSEMBLY
recipient_id		1065754
amount		100

Table: lobbyist_contributions2
filer_id		1147358
filing_period_start_dt		2000-10-01 00:00:00
filing_period_end_dt		2000-12-31 00:00:00
contribution_dt		None
recipient_name		CORREA FOR ASSEMBLY
recipient_id		1065754
amount		100

Table: received_filings
filer_id	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358	1147358
filing_file_name	675165_0.cal	26293.cal	645274_0.cal	622959_0.cal	622959_1.cal	745106_0.cal	719937_0.cal	770797_0.cal	271198.cal	789020_0.cal	812334_0.cal	836721_0.cal	855110_0.cal	882980_0.cal	428305.cal	909167_0.cal	928566_0.cal	942896_0.cal	967968_0.cal	112269.cal	33223.cal	293918.cal	487810.cal	491299.cal	439406.cal	62675.cal	1226233_1.cal	20706.cal	94934.cal	1386178_3.cal	1386178_2.cal	1386178_1.cal	1386178_0.cal	1550399_0.cal	1550399_1.cal	1717046_0.cal	1717046_1.cal	1717046_2.cal	2113480_0.cal	1917713_0.cal	2328528_1.cal	2328528_0.cal
received_date	2000-10-24 00:00:00	2000-08-01 00:00:00	2000-08-01 00:00:00	2000-04-22 00:00:00	2000-04-27 00:00:00	2001-04-27 00:00:00	2001-02-01 00:00:00	2001-07-27 00:00:00	2001-07-31 00:00:00	2001-10-24 00:00:00	2002-01-29 00:00:00	2002-04-23 00:00:00	2002-07-30 00:00:00	2002-10-30 00:00:00	2003-01-29 00:00:00	2003-01-29 00:00:00	2003-04-23 00:00:00	2003-07-20 00:00:00	2003-10-27 00:00:00	2004-01-21 00:00:00	2005-02-03 00:00:00	2005-01-28 00:00:00	2005-04-23 00:00:00	2009-05-13 00:00:00	2009-05-13 00:00:00	2008-10-10 00:00:00	2008-10-10 00:00:00	2007-01-03 00:00:00	2007-01-31 00:00:00	2010-02-11 00:00:00	2009-07-13 00:00:00	2009-07-13 00:00:00	2008-12-29 00:00:00	2010-12-14 00:00:00	2010-12-22 00:00:00	2012-12-13 00:00:00	2012-12-17 00:00:00	2012-12-17 00:00:00	2016-12-22 00:00:00	2014-12-09 00:00:00	2019-04-16 00:00:00	2018-12-18 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/cal	/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	/usr/users/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal
filing_id	675165	None	645274	622959	622959	745106	719937	770797	None	789020	812334	836721	855110	882980	None	909167	928566	942896	967968	None	None	None	None	None	None	None	1226233	None	None	1386178	1386178	1386178	1386178	1550399	1550399	1717046	1717046	1717046	2113480	1917713	2328528	2328528
form_id	F625	None	F625	F625	F625	F625	F625	F625	None	F625	F625	F625	F625	F625	None	F625	F625	F625	F625	None	None	None	None	None	None	None	F601	None	None	F601	F601	F601	F601	F601	F601	F601	F601	F601	F601	F601	F601	F601
receive_comment	Filing accepted	Filing pass validation, but failed DB constraints	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted, but with warnings	Filing accepted	Filing passed validation, but failed DB constraints	Filing accepted	Filing accepted	Filing accepted	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing did not pass validation	Filing accepted	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing did not pass validation	Filing passed validation, but failed DB constraints	Filing did not pass validation	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing accepted	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted