OpenCalAccess

Filer ID: 1146938

Table: filer_address
filer_id	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938
adrid	1108390	2011144	2041896	2079910	2112901	2159087	2203166	2505729	2412950	2545058	2465724	2256918	2338545
effect_dt	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	2009-01-01 00:00:00	2011-01-01 00:00:00	2021-01-01 00:00:00	2017-01-01 00:00:00	2023-01-01 00:00:00	2019-01-01 00:00:00	2013-01-01 00:00:00	2015-01-01 00:00:00
add_type	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051
session_id	1999	2001	2003	2005	2007	2009	2011	2021	2017	2023	2019	2013	2015

Table: filer_filings
filer_id	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938
filing_id	500374	500580	500869	501215	501419	499520	502937	503502	503716	541593	499726	502359	500580	541593	503502	501788	502572	503502	501419	501788	498671	499726	502359	501997	499167	500020	503150	637126	624620	633203	615465	681584	662824	644396	719118	729099	696346	711650	703967	644396	742829	746026	754392	782236	769319	797566	791538	812196	815932	838854	821881	845894	719118	875853	769319	843812	862007	855183	892309	898024	879288	914119	910659	954889	938310	943254	926528	924870	928614	934220	855183	937593	971233	983196	988326	968907	943254	983196	1011676	999266	999347	1008466	1014696	1027523	1030411	1046625	1048023	1019262	1019263	1061384	1096583	1067852	1027523	1066436	1075244	1075449	1069237	1100864	1088505	1114656	1131094	1163027	1143409	1184821	1228190	1229348	1223694	1184821	1223694	1258740	1215165	1246717	1275596	1223694	1235675	1184821	1274415	1303153	1293918	1281522	1299003	1275681	1789072	1965027	1979961	1870666	1802134	1799620	1805897	1804835	1782555	1717908	1961547	1940074	1935028	1941502	1223694	1311213	1328584	1311213	1348347	1338348	1366943	1223694	1384942	1384943	1389195	1393844	1404230	1406175	1396982	1407932	1376591	1421421	1384942	1435258	1408935	1408756	1384942	1453958	1456372	1456110	1451646	1436303	1484882	1436303	1465336	1436303	1465336	1465336	1464600	1384942	1505845	1505845	1548156	1538293	1548156	1550600	1556818	1555040	1548156	1560642	1548156	1554258	1555878	1556491	1558647	1559800	1505845	1552711	1580263	1580334	1580424	1571500	1606369	1589800	1636388	1548156	1622292	1589800	1606369	1641687	1657990	1679647	1717908	1817107	1934162	1917007	1911337	1920526	1920185	1717908	1719713	1708599	1657990	1679647	1737166	1743274	1743384	1728746	1720882	1722294	1722847	1734963	1845583	1763985	1817107	1717908	1753791	1729588	1763985	1996686	2241748	2381353	2107747	2477394	2274713	2330803	2363992	2202343	2484174	2343401	2399887	2418806	2210418	2263105	2319239	2014600	1917007	2021828	2009648	2037893	2061272	2101985	2129148	2107747	2118590	2111496	2117742	2133108	2148837	2154856	2107747	2107747	2154890	2134459	2135958	2107747	2158872	2175405	2163769	2158868	2158870	2129148	2107747	2274713	2179306	2234665	2218404	2541199	2541295	2538638	2334956	2345909	2535838	2550836	2356729	2472136	2330803	2566871	2330803	2210418	2194313	2107747	2367654	2107747	2330842	2442452	2330803	2470605	2279803	2524818	2527648	2644637	2544470	2644637	2565654	2601068	2572348	2673293	2621953	2580127	2547417	2668102	2703410	2584042	2601068	2629807	2538638	2621953	2568268	2538638	2748009
period_id	143	151	159	144	152	142	147	148	156	149	150	146	151	149	148	145	154	148	152	145	141	150	146	153	157	158	155	None	161	161	160	163	162	162	164	164	163	162	None	162	None	165	165	None	166	None	167	168	None	169	None	None	164	None	166	169	None	170	None	None	171	None	172	None	None	174	None	None	173	None	170	None	None	176	None	175	174	176	177	None	None	None	None	178	None	None	179	None	None	None	None	180	178	None	None	180	None	181	None	182	183	185	184	186	None	None	189	186	188	189	187	None	190	190	188	186	None	None	191	190	None	None	None	221	222	218	216	215	None	None	214	215	None	None	220	None	192	192	193	192	194	194	None	196	196	196	196	196	196	None	197	None	195	197	199	None	None	None	200	None	None	200	199	198	201	198	200	198	200	200	None	201	202	202	204	203	205	None	None	None	204	None	205	204	204	204	None	None	202	204	None	None	None	204	206	205	208	209	207	205	206	None	209	210	216	216	221	220	219	220	None	212	None	211	209	210	212	None	None	None	212	212	212	None	217	213	216	213	None	213	213	223	233	237	235	None	234	236	237	None	242	None	238	239	232	None	235	None	225	None	224	225	226	227	228	228	229	None	228	None	None	229	230	230	230	None	None	229	None	230	None	None	None	228	231	234	None	None	233	244	244	244	None	236	244	244	None	None	244	None	242	232	231	234	236	235	236	240	242	241	None	None	243	248	245	248	None	246	None	249	247	245	None	None	250	None	246	None	250	247	None	248	251
form_id	F635	F635	F635	F635	F635	F635	F635	F635	F635	F690	F690	F690	F690	F635	F690	F635	F635	F690	F690	F690	F635	F635	F635	F635	F635	F635	F635	F999	F635	F635	F635	F635	F635	F635	F635	F635	F635	F690	F603	F635	F605	F635	F635	F635	F635	F635	F635	F635	F605	F635	F635	F690	F635	F690	F635	F635	F635	F635	F635	F603	F635	F635	F635	F635	F605	F635	F690	F605	F635	F635	F635	F605	F635	F635	F635	F635	F635	F635	F635	F605	F605	F606	F635	F635	F635	F605	F635	F690	F690	F635	F605	F603	F635	F605	F603	F635	F690	F635	F635	F635	F635	F635	F635	F635	F603	F605	F603	F635	F603	F635	F635	F602	F602	F603	F635	F635	F605	F602	F635	F635	F605	F602	F605	F635	F635	F635	F602	F635	F602	F605	F635	F603	F602	F602	F635	F602	F603	F635	F635	F635	F635	F602	F605	F603	F603	F603	F602	F635	F602	F603	F602	F602	F635	F635	F603	F605	F602	F602	F603	F605	F602	F602	F635	F635	F635	F635	F635	F635	F635	F635	F605	F603	F635	F635	F603	F635	F603	F603	F602	F605	F603	F602	F603	F602	F602	F602	F602	F602	F635	F602	F602	F605	F605	F635	F635	F635	F635	F603	F635	F635	F635	F605	F635	F635	F603	F635	F602	F603	F635	F602	F603	F603	F603	F635	F635	F635	F635	F602	F602	F602	F602	F602	F602	F602	F635	F635	F635	F603	F605	F602	F635	F635	F635	F635	F603	F605	F635	F603	F602	F602	F635	F602	F635	F635	F635	F605	F635	F605	F603	F602	F635	F635	F635	F635	F635	F603	F602	F603	F602	F602	F605	F635	F603	F603	F602	F602	F602	F603	F602	F635	F602	F605	F605	F635	F603	F635	F605	F605	F602	F602	F602	F603	F603	F635	F602	F635	F602	F605	F603	F602	F603	F635	F635	F603	F602	F603	F602	F635	F603	F635	F605	F605	F635	F635	F602	F635	F603	F635	F602	F635	F635	F635	F602	F605	F635	F602	F635	F605	F603	F635	F602	F603	F635
filing_sequence	0	0	0	0	0	0	0	0	0	1	1	1	1	0	1	0	0	2	1	1	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	1	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	1	1	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	1	1	0	0	0	0	0	2	0	2	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	0	0	0	0	3	0	0	1	0	0	0	4	0	0	0	0	0	0	0	0	0	0	1	0	0	0	2	0	0	0	0	0	0	1	0	2	1	2	0	3	0	1	0	0	3	0	0	0	1	0	2	0	0	0	0	0	2	0	0	0	0	0	0	0	0	4	0	1	1	0	0	0	3	0	0	0	0	0	0	0	0	0	1	1	0	0	0	0	0	0	0	0	0	1	1	1	0	0	0	0	0	0	6	0	1	0	0	0	0	0	0	0	1	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	2	3	0	0	0	1	0	0	0	0	0	1	4	0	0	0	0	0	0	0	0	0	0	0	0	0	3	0	2	0	0	5	0	7	0	0	1	0	0	0	0	1	0	0	0	1	0	0	0	0	0	0	0	0	0	0	2	1	0	1	0
filing_date	1995-10-31 00:00:00	1997-10-31 00:00:00	1999-10-29 00:00:00	1996-01-31 00:00:00	1998-01-29 00:00:00	1995-07-31 00:00:00	1996-10-31 00:00:00	1997-01-31 00:00:00	1999-02-01 00:00:00	1998-07-08 00:00:00	1998-07-08 00:00:00	1997-01-13 00:00:00	1998-07-08 00:00:00	1997-04-30 00:00:00	1997-10-31 00:00:00	1996-04-30 00:00:00	1998-07-31 00:00:00	1997-10-31 00:00:00	1998-07-08 00:00:00	1996-10-21 00:00:00	1995-05-01 00:00:00	1997-07-31 00:00:00	1996-07-31 00:00:00	1998-04-30 00:00:00	1999-04-30 00:00:00	1999-07-30 00:00:00	1998-11-02 00:00:00	2000-05-01 00:00:00	2000-05-02 00:00:00	2000-05-01 00:00:00	2000-01-31 00:00:00	2000-10-31 00:00:00	2000-07-31 00:00:00	2000-07-31 00:00:00	2001-01-31 00:00:00	2001-01-31 00:00:00	2000-10-31 00:00:00	2000-12-28 00:00:00	2000-12-28 00:00:00	2000-12-21 00:00:00	2001-02-26 00:00:00	2001-04-30 00:00:00	2001-04-30 00:00:00	2001-07-31 00:00:00	2001-07-24 00:00:00	2001-10-31 00:00:00	2001-10-31 00:00:00	2002-01-29 00:00:00	2002-01-24 00:00:00	2002-04-29 00:00:00	2002-01-30 00:00:00	2002-05-14 00:00:00	2002-09-19 00:00:00	2002-09-19 00:00:00	2002-05-10 00:00:00	2002-04-30 00:00:00	2002-07-31 00:00:00	2002-07-30 00:00:00	2002-10-28 00:00:00	2002-12-20 00:00:00	2002-10-25 00:00:00	2003-01-31 00:00:00	2003-01-30 00:00:00	2003-07-23 00:00:00	2003-06-04 00:00:00	2003-07-21 00:00:00	2003-03-12 00:00:00	2003-03-12 00:00:00	2003-04-24 00:00:00	2003-04-25 00:00:00	2003-03-06 00:00:00	2003-05-22 00:00:00	2003-10-30 00:00:00	2004-01-19 00:00:00	2004-01-21 00:00:00	2003-10-30 00:00:00	2004-04-27 00:00:00	2004-04-27 00:00:00	2004-04-27 00:00:00	2004-02-19 00:00:00	2004-02-19 00:00:00	2004-02-19 00:00:00	2004-04-28 00:00:00	2004-07-28 00:00:00	2004-07-29 00:00:00	2004-10-08 00:00:00	2004-10-15 00:00:00	2004-04-28 00:00:00	2004-04-28 00:00:00	2004-10-18 00:00:00	2005-01-13 00:00:00	2004-12-27 00:00:00	2004-09-22 00:00:00	2004-12-10 00:00:00	2004-12-29 00:00:00	2005-01-25 00:00:00	2004-09-24 00:00:00	2005-04-18 00:00:00	2005-01-26 00:00:00	2005-07-26 00:00:00	2005-10-26 00:00:00	2006-04-19 00:00:00	2006-01-23 00:00:00	2006-07-18 00:00:00	2006-12-18 00:00:00	2007-01-17 00:00:00	2007-01-17 00:00:00	2006-10-30 00:00:00	2006-12-18 00:00:00	2007-04-24 00:00:00	2006-10-30 00:00:00	2006-11-28 00:00:00	2007-06-29 00:00:00	2007-06-13 00:00:00	2007-01-30 00:00:00	2007-01-30 00:00:00	2007-06-15 00:00:00	2008-01-10 00:00:00	2007-10-22 00:00:00	2007-07-27 00:00:00	2007-11-08 00:00:00	2007-06-29 00:00:00	2013-07-16 00:00:00	2015-04-30 00:00:00	2015-07-30 00:00:00	2014-07-30 00:00:00	2013-11-04 00:00:00	2013-10-30 00:00:00	2013-11-01 00:00:00	2013-11-05 00:00:00	2013-07-31 00:00:00	2013-07-16 00:00:00	2015-01-26 00:00:00	2014-12-31 00:00:00	2015-01-30 00:00:00	2014-12-30 00:00:00	2007-11-07 00:00:00	2008-01-31 00:00:00	2008-04-29 00:00:00	2008-02-11 00:00:00	2008-07-29 00:00:00	2008-05-29 00:00:00	2008-10-16 00:00:00	2008-10-15 00:00:00	2008-12-22 00:00:00	2008-12-22 00:00:00	2009-01-13 00:00:00	2009-01-29 00:00:00	2009-02-27 00:00:00	2008-12-23 00:00:00	2009-02-01 00:00:00	2009-01-30 00:00:00	2008-10-30 00:00:00	2009-04-30 00:00:00	2009-07-28 00:00:00	2009-07-28 00:00:00	2009-01-13 00:00:00	2009-01-15 00:00:00	2009-11-04 00:00:00	2009-11-05 00:00:00	2009-12-29 00:00:00	2009-12-23 00:00:00	2009-10-29 00:00:00	2009-07-30 00:00:00	2010-04-30 00:00:00	2010-02-01 00:00:00	2010-02-01 00:00:00	2010-02-16 00:00:00	2010-04-06 00:00:00	2010-04-06 00:00:00	2010-01-26 00:00:00	2010-01-25 00:00:00	2010-07-29 00:00:00	2010-08-10 00:00:00	2010-12-06 00:00:00	2010-10-28 00:00:00	2011-02-09 00:00:00	2010-12-07 00:00:00	2010-12-22 00:00:00	2010-12-23 00:00:00	2010-12-23 00:00:00	2010-12-28 00:00:00	2011-02-04 00:00:00	2010-12-28 00:00:00	2010-12-30 00:00:00	2011-01-03 00:00:00	2010-12-30 00:00:00	2010-12-28 00:00:00	2011-03-09 00:00:00	2010-12-21 00:00:00	2011-01-28 00:00:00	2011-02-10 00:00:00	2011-02-08 00:00:00	2011-01-31 00:00:00	2011-07-29 00:00:00	2011-04-28 00:00:00	2012-01-31 00:00:00	2012-01-31 00:00:00	2011-10-31 00:00:00	2011-08-10 00:00:00	2011-08-10 00:00:00	2012-01-31 00:00:00	2012-04-30 00:00:00	2012-07-31 00:00:00	2013-11-05 00:00:00	2014-01-30 00:00:00	2015-01-30 00:00:00	2014-12-04 00:00:00	2014-10-31 00:00:00	2014-12-23 00:00:00	2014-12-04 00:00:00	2012-12-18 00:00:00	2012-12-18 00:00:00	2012-10-31 00:00:00	2012-10-31 00:00:00	2012-10-31 00:00:00	2013-01-30 00:00:00	2012-12-26 00:00:00	2012-12-27 00:00:00	2013-01-03 00:00:00	2012-12-27 00:00:00	2013-01-02 00:00:00	2013-01-04 00:00:00	2013-01-02 00:00:00	2014-04-30 00:00:00	2014-04-26 00:00:00	2014-04-26 00:00:00	2013-03-08 00:00:00	2013-03-07 00:00:00	2013-01-22 00:00:00	2013-04-29 00:00:00	2015-10-30 00:00:00	2018-04-30 00:00:00	2019-04-30 00:00:00	2018-07-06 00:00:00	2020-06-29 00:00:00	2018-08-27 00:00:00	2018-12-28 00:00:00	2019-03-01 00:00:00	2018-01-12 00:00:00	2020-07-30 00:00:00	2018-12-21 00:00:00	2019-07-31 00:00:00	2019-10-31 00:00:00	2018-02-22 00:00:00	2018-07-06 00:00:00	2018-10-31 00:00:00	2016-01-21 00:00:00	2016-01-21 00:00:00	2016-02-03 00:00:00	2016-01-28 00:00:00	2016-05-02 00:00:00	2016-07-29 00:00:00	2016-10-31 00:00:00	2017-01-31 00:00:00	2016-11-17 00:00:00	2017-01-11 00:00:00	2016-11-17 00:00:00	2017-01-06 00:00:00	2016-12-27 00:00:00	2017-02-28 00:00:00	2017-04-27 00:00:00	2017-04-27 00:00:00	2017-04-27 00:00:00	2017-04-27 00:00:00	2017-01-06 00:00:00	2016-12-27 00:00:00	2017-02-27 00:00:00	2017-04-27 00:00:00	2017-07-31 00:00:00	2017-06-12 00:00:00	2017-04-27 00:00:00	2017-04-27 00:00:00	2017-02-22 00:00:00	2017-08-07 00:00:00	2018-07-31 00:00:00	2017-08-07 00:00:00	2018-04-23 00:00:00	2018-02-23 00:00:00	2020-12-30 00:00:00	2020-12-31 00:00:00	2020-12-28 00:00:00	2018-12-21 00:00:00	2019-01-30 00:00:00	2020-11-25 00:00:00	2021-01-29 00:00:00	2018-12-27 00:00:00	2020-04-27 00:00:00	2020-10-19 00:00:00	2020-12-31 00:00:00	2020-06-25 00:00:00	2018-01-31 00:00:00	2017-10-31 00:00:00	2018-04-23 00:00:00	2019-03-18 00:00:00	2018-08-02 00:00:00	2018-12-28 00:00:00	2020-01-31 00:00:00	2020-04-23 00:00:00	2020-04-30 00:00:00	2018-08-02 00:00:00	2020-10-19 00:00:00	2020-10-30 00:00:00	2022-04-21 00:00:00	2021-01-14 00:00:00	2022-01-31 00:00:00	2020-12-30 00:00:00	2021-10-25 00:00:00	2020-12-30 00:00:00	2022-04-28 00:00:00	2021-10-29 00:00:00	2021-04-30 00:00:00	2020-11-30 00:00:00	2022-04-07 00:00:00	2022-07-28 00:00:00	2021-01-04 00:00:00	2021-07-30 00:00:00	2021-11-15 00:00:00	2022-04-07 00:00:00	2021-11-16 00:00:00	2020-12-30 00:00:00	2021-11-12 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	10005	10001	10005	10005	10001	10005	10001	10001	10005	10005	10005	10005	10002	10005	10001	10005	10005	10001	10005	10001	10001	10005	10001	10005	10006	10002	10006	10002	10005	10005	10001	10005	10005	10001	10005	10001	10005	10005	10001	10005	10005	10001	10005	10002	10005	10005	10001	10005	10001	10002	10002	10001	10005	10005	10005	10005	10001	10005	10005	10001	10006	10006	10005	10005	10001	10002	10005	10005	10001	10006	10001	10005	10001	10001	10001	10001	10001	10005	10005	10002	10002	10001	10001	10001	10005	10001	10002	10001	10002	10005	10005	10001	10001	10005	10005	10006	10001	10001	10001	10001	10001	10005	10005	10001	10002	10005	10005	10001	10005	10002	10001	10001	10002	10001	10001	10005	10002	10001	10001	10001	10001	10001	10005	10001	10005	10001	10001	10002	10006	10005	10005	10002	10006	10005	10001	10001	10001	10001	10002	10001	10002	10002	10002	10006	10002	10001	10002	10001	10001	10002	10005	10005	10006	10002	10005	10002	10001	10001	10001	10005	10005	10002	10001	10005	10006	10006	10001	10001	10001	10001	10002	10001	10002	10002	10006	10001	10001	10002	10001	10001	10001	10001	10001	10005	10001	10005	10001	10002	10002	10001	10005	10005	10005	10001	10001	10001	10005	10001	10002	10002	10002	10006	10001	10001	10001	10001	10001	10002	10005	10002	10001	10001	10005	10001	10001	10001	10001	10002	10005	10001	10006	10002	10005	10001	10001	10001	10001	10001	10001	10001	10005	10001	10005	10005	10001	10002	10002	10001	10005	10005	10002	10005	10001	10005	10005	10005	10002	10002	10001	10005	10005	10001	10001	10001	10001	10005	10001	10001	10001	10005	10005	10002	10005	10002	10001	10001	10002	10001	10002	10001	10001	10002	10001	10005	10005	10001	10002	10001	10001	10001	10002	10005	10001	10001	10001	10005	10002	10001	10005	10001	10002	10002	10002	10005	10002	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	11003	11001	11001	11003	11001	11003	11003	11001	11001	11001	11001	11003	11001	11003	11001	11001	11003	11001	11003	11003	11001	11003	11001	11001	11003	11001	11003	11001	11001	11003	11001	11001	11003	11001	11003	11001	11001	11003	11001	11001	11003	11001	11003	11001	11003	11003	11003	11003	11003	11003	11003	11001	11001	11001	11001	11003	11001	11001	11003	11003	11003	11003	11003	11003	11003	11001	11001	11003	11003	11001	11003	11001	11001	11001	11001	11001	11003	11001	11003	11001	11003	11001	11001	11001	11003	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	11003	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	11001	11001	11001	11001	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	11001	11001	11001	11001	11001	11001	11001	11001	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	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	11003	11001	11001	11001	11001	11001	11001	11003	11003
session_id	1995	1997	1999	1995	1997	1995	1995	1995	1997	1997	1997	1995	1997	1997	1995	1995	1997	1995	1997	1995	1995	1997	1995	1997	1999	1999	1997	1999	1999	1999	1999	1999	1999	1999	1999	1999	1999	1999	2001	1999	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	1999	2001	2001	2001	2001	2001	2001	2003	2001	2001	2001	2003	2003	2003	2001	2003	2003	2003	2001	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2005	2005	2003	2003	2005	2003	2005	2005	2003	2005	2005	2005	2005	2005	2007	2007	2007	2005	2007	2007	2005	2007	2007	2007	2005	2005	2007	2007	2007	2007	2007	2007	2013	2015	2015	2013	2013	2013	2013	2013	2013	2013	2015	2015	2013	2015	2007	2007	2007	2007	2007	2007	2007	2007	2009	2009	2009	2007	2009	2009	2009	2009	2007	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2011	2009	2011	2011	2011	2011	2011	2011	2011	2011	2011	2011	2011	2011	2009	2011	2011	2011	2011	2009	2011	2011	2011	2011	2011	2011	2011	2011	2011	2011	2013	2013	2015	2015	2013	2015	2015	2013	2013	2011	2011	2011	2011	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2013	2015	2017	2019	2017	2019	2017	2019	2019	2017	2019	2019	2019	2019	2017	2017	2017	2015	2015	2015	2015	2015	2015	2015	2015	2017	2017	2017	2017	2017	2017	2017	2017	2017	2017	2017	2017	2017	2017	2017	2017	2017	2017	2015	2017	2017	2017	2017	2017	2021	2021	2021	2019	2017	2021	2019	2019	2019	2019	2021	2019	2017	2017	2017	2019	2017	2019	2019	2019	2019	2017	2019	2019	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021	2021
user_id	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	GPEREZ	*	TTHAM	*	*	CFLAGG	*	*	YBONILLA	CFLAGG	CFLAGG	YBONILLA	*	GPEREZ	*	YBONILLA	LTHIBAUL	*	LTHIBAUL	*	*	SARRIAGA	*	LTHIBAUL	LTHIBAUL	*	LTHIBAUL	*	LTHIBAUL	LTHIBAUL	*	LTHIBAUL	GPEREZ	*	LTHIBAUL	COMPLETED	LTHIBAUL	CFLAGG	COMPLETED	LTHIBAUL	CFLAGG	COMPLETED	LTHIBAUL	COMPLETED	SARRIAGA	KLARRY	COMPLETED	EMCENTEE	COMPLETED	COMPLETED	COMPLETED	COMPLETED	SARRIAGA	SARRIAGA	SARRIAGA	LTHIBAUL	COMPLETED	LTHIBAUL	GPEREZ	COMPLETED	EMCENTEE	EMCENTEE	EMCENTEE	CFLAGG	COMPLETED	COMPLETED	CFLAGG	SARRIAGA	COMPLETED	EMCENTEE	LTHIBAUL	KLARRY	LTHIBAUL	LTHIBAUL	LTHIBAUL	LTHIBAUL	LTHIBAUL	SARRIAGA	SARRIAGA	*	LTHIBAUL	*	LTHIBAUL	LTHIBAUL	GPEREZ	*	*	LTHIBAUL	LTHIBAUL	SARRIAGA	SARRIAGA	LTHIBAUL	LTHIBAUL	GPEREZ	GPEREZ	YRODRIGU	MPACHECO	AGLADNEY	AGLADNEY	YRODRIGU	AGLADNEY	YRODRIGU	GPEREZ	AGLADNEY	YRODRIGU	GPEREZ	GPEREZ	AGLADNEY	GPEREZ	*	LTHIBAUL	LTHIBAUL	LTHIBAUL	LTHIBAUL	*	YRODRIGU	*	YRODRIGU	YRODRIGU	YRODRIGU	JINGRAM	YRODRIGU	SARRIAGA	YRODRIGU	MGUERRA	JINGRAM	MGUERRA	YRODRIGU	YRODRIGU	YRODRIGU	YRODRIGU	YRODRIGU	YRODRIGU	YRODRIGU	YRODRIGU	MGUERRA	MGUERRA	ASAETERN	WBROWN	WBROWN	JINGRAM	JINGRAM	JINGRAM	YRODRIGU	YRODRIGU	ASAETERN	ASAETERN	YRODRIGU	ASAETERN	YRODRIGU	PBANFORD	PBANFORD	YRODRIGU	PBANFORD	YRODRIGU	YRODRIGU	YRODRIGU	YRODRIGU	PBANFORD	GPEREZ	PBANFORD	AGLADNEY	PBANFORD	YRODRIGU	YRODRIGU	YRODRIGU	AGLADNEY	AGLADNEY	AGLADNEY	ASAETERN	YRODRIGU	ASAETERN	AGLADNEY	AGLADNEY	YRODRIGU	AGLADNEY	AGLADNEY	YRODRIGU	AGLADNEY	YRODRIGU	PBANFORD	AGLADNEY	YRODRIGU	PBANFORD	PBANFORD	PBANFORD	ASAETERN	AGLADNEY	AGLADNEY	ASAETERN	PBANFORD	PBANFORD	PBANFORD	PBANFORD	SARRIAGA	PBANFORD	SARRIAGA	AGLADNEY	ASAETERN	AGLADNEY	PBANFORD	PBANFORD	PBANFORD	ASAETERN	AGLADNEY	AGLADNEY	VUKSTINA	GPEREZ	GPEREZ	AGLADNEY	PBANFORD	CAFILER	GPEREZ	MKIRKHAM	YRODRIGU	VUKSTINA	VUKSTINA	AGLADNEY	GPEREZ	AGLADNEY	YRODRIGU	YRODRIGU	YRODRIGU	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	YRODRIGU	PBANFORD	GPEREZ	PBANFORD	SARRIAGA	SARRIAGA	AGLADNEY	GPEREZ	GPEREZ	GPEREZ	PBANFORD	GPEREZ	SARRIAGA	GPEREZ	AGLADNEY	YRODRIGU	GPEREZ	GPEREZ	AGLADNEY	GPEREZ	AGLADNEY	GPEREZ	GPEREZ	GPEREZ	SARRIAGA	CVANLIEW	CVANLIEW	PBANFORD	AGLADNEY	MMERCHANT	MKIRKHAM	PBANFORD	GPEREZ	CAFILER	SARRIAGA	GPEREZ	AGLADNEY	AGLADNEY	GPEREZ	CAFILER	GPEREZ	YRODRIGU	VUKSTINA	GPEREZ	VUKSTINA	GPEREZ	CVANLIEW	MKIRKHAM	GTAYLOR	AROJAS	GTAYLOR	CVANLIEW	CHATRIDGE	MMERCHANT	CAFILER	GTAYLOR	CHATRIDGE	MMERCHANT	JMENDOZA	CAFILER	AROJAS	CHATRIDGE	JMENDOZA	JMENDOZA	GTAYLOR	CVANLIEW	CAFILER	CAFILER
special_audit	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	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	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003
fine_audit	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	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	11003	11001	11001	11003	11003	11001	11003	11003	11003	11003	11003	11003	11003	11001	11003	11001	11001	11001	11001	11001	11003	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	11003	11001	11001	11001	11001	11003	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	11003	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	11001	11001	11003	11003	11001	11003	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11003	11003	11001	11003	11003	11003	11001	11003	11003	11003	11001	11001	11003	11003	11001	11003	11001	11003	11003	11003	11003	11003	11003	11001	11001	11003	11001	11001	11003	11003	11003	11003	11001	11001	11003	11003	11003	11003	11001	11003	11001	11003	11003	11001	11001	11003	11001	11003	11001	11003	11003	11001	11001	11003	11003	11003	11003	11001	11003	11003	11001	11003	11003	11003
rpt_start	1995-07-01 00:00:00	1997-07-01 00:00:00	1999-07-01 00:00:00	1995-10-01 00:00:00	1997-10-01 00:00:00	1995-04-01 00:00:00	1996-07-01 00:00:00	1996-10-01 00:00:00	1998-10-01 00:00:00	1997-01-01 00:00:00	1997-04-01 00:00:00	1996-04-01 00:00:00	1997-07-01 00:00:00	1997-01-01 00:00:00	1996-10-01 00:00:00	1996-01-01 00:00:00	1998-04-01 00:00:00	1996-10-01 00:00:00	1997-10-01 00:00:00	1996-01-01 00:00:00	1995-01-01 00:00:00	1997-04-01 00:00:00	1996-04-01 00:00:00	1998-01-01 00:00:00	1999-01-01 00:00:00	1999-04-01 00:00:00	1998-07-01 00:00:00	None	2000-01-01 00:00:00	2000-01-01 00:00:00	1999-10-01 00:00:00	2000-07-01 00:00:00	2000-04-01 00:00:00	2000-04-01 00:00:00	2000-10-01 00:00:00	2000-10-01 00:00:00	2000-07-01 00:00:00	2000-04-01 00:00:00	1900-01-01 00:00:00	2000-04-01 00:00:00	1900-01-01 00:00:00	2001-01-01 00:00:00	2001-01-01 00:00:00	2001-04-01 00:00:00	2001-04-01 00:00:00	2001-07-01 00:00:00	2001-07-01 00:00:00	2001-10-01 00:00:00	1900-01-01 00:00:00	2002-01-01 00:00:00	2001-10-01 00:00:00	2001-04-01 00:00:00	2000-10-01 00:00:00	2000-10-01 00:00:00	2001-04-01 00:00:00	2002-01-01 00:00:00	2002-04-01 00:00:00	2002-04-01 00:00:00	2002-07-01 00:00:00	1900-01-01 00:00:00	2002-07-01 00:00:00	2002-10-01 00:00:00	2002-10-01 00:00:00	2003-04-01 00:00:00	1900-01-01 00:00:00	2003-04-01 00:00:00	2002-04-01 00:00:00	1900-01-01 00:00:00	2003-01-01 00:00:00	2003-01-01 00:00:00	2002-04-01 00:00:00	1900-01-01 00:00:00	2003-07-01 00:00:00	2003-10-01 00:00:00	2003-10-01 00:00:00	2003-07-01 00:00:00	2003-04-01 00:00:00	2003-10-01 00:00:00	2004-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2004-01-01 00:00:00	2004-04-01 00:00:00	2004-04-01 00:00:00	1900-01-01 00:00:00	2004-07-01 00:00:00	2003-10-01 00:00:00	2003-04-01 00:00:00	2004-07-01 00:00:00	1900-01-01 00:00:00	2004-12-25 00:00:00	2004-04-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2004-10-01 00:00:00	2004-04-01 00:00:00	2005-01-01 00:00:00	2004-10-01 00:00:00	2005-04-01 00:00:00	2005-07-01 00:00:00	2006-01-01 00:00:00	2005-10-01 00:00:00	2006-04-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2007-01-15 00:00:00	2006-04-01 00:00:00	2006-12-07 00:00:00	2007-01-01 00:00:00	2006-07-01 00:00:00	1900-01-01 00:00:00	2007-06-25 00:00:00	2007-06-11 00:00:00	2006-10-01 00:00:00	2006-04-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2007-07-01 00:00:00	2007-04-01 00:00:00	1900-01-01 00:00:00	1900-01-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	2013-11-04 00:00:00	2013-07-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2013-04-01 00:00:00	2013-07-15 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	2007-10-24 00:00:00	2007-10-01 00:00:00	2008-01-01 00:00:00	2007-10-01 00:00:00	2008-04-01 00:00:00	2008-05-29 00:00:00	1900-01-01 00:00:00	2008-10-01 00:00:00	2008-12-07 00:00:00	2008-12-07 00:00:00	2008-12-08 00:00:00	2008-10-01 00:00:00	2008-12-31 00:00:00	1900-01-01 00:00:00	2009-02-01 00:00:00	1900-01-01 00:00:00	2008-07-01 00:00:00	2009-01-01 00:00:00	2009-07-28 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2009-10-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2009-12-22 00:00:00	2009-07-01 00:00:00	2009-04-01 00:00:00	2010-01-01 00:00:00	2009-04-01 00:00:00	2009-10-01 00:00:00	2009-04-01 00:00:00	2009-10-01 00:00:00	2009-10-01 00:00:00	1900-01-01 00:00:00	2010-01-04 00:00:00	2010-04-01 00:00:00	2010-04-01 00:00:00	2010-11-10 00:00:00	2010-07-01 00:00:00	2011-02-09 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2010-12-21 00:00:00	1900-01-01 00:00:00	2011-01-31 00:00:00	2010-12-21 00:00:00	2010-12-30 00:00:00	2010-12-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2010-04-01 00:00:00	2010-11-15 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2010-10-01 00:00:00	2011-04-01 00:00:00	2011-01-01 00:00:00	2011-10-01 00:00:00	2012-01-30 00:00:00	2011-07-01 00:00:00	2011-01-01 00:00:00	2011-04-01 00:00:00	1900-01-01 00:00:00	2012-01-01 00:00:00	2012-04-01 00:00:00	2013-10-29 00:00:00	2013-10-01 00:00:00	2015-01-30 00:00:00	2014-11-13 00:00:00	2014-07-01 00:00:00	2014-12-30 00:00:00	1900-01-01 00:00:00	2012-11-15 00:00:00	1900-01-01 00:00:00	2012-07-01 00:00:00	2012-01-01 00:00:00	2012-04-01 00:00:00	2012-10-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2012-12-30 00:00:00	2012-11-12 00:00:00	2012-12-31 00:00:00	1900-01-01 00:00:00	2014-01-01 00:00:00	2013-01-01 00:00:00	2013-10-01 00:00:00	2013-03-05 00:00:00	1900-01-01 00:00:00	2013-01-22 00:00:00	2013-01-01 00:00:00	2015-07-01 00:00:00	2018-01-01 00:00:00	2019-01-01 00:00:00	2018-07-06 00:00:00	1900-01-01 00:00:00	2018-04-01 00:00:00	2018-12-28 00:00:00	2019-03-01 00:00:00	1900-01-01 00:00:00	2020-04-01 00:00:00	1900-01-01 00:00:00	2019-04-01 00:00:00	2019-07-01 00:00:00	2017-10-01 00:00:00	1900-01-01 00:00:00	2018-07-01 00:00:00	1900-01-01 00:00:00	2016-01-15 00:00:00	1900-01-01 00:00:00	2015-10-01 00:00:00	2016-01-01 00:00:00	2016-04-01 00:00:00	2016-07-01 00:00:00	2016-10-01 00:00:00	2016-11-10 00:00:00	2017-01-11 00:00:00	1900-01-01 00:00:00	2016-12-15 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2017-01-01 00:00:00	2017-04-27 00:00:00	2017-04-27 00:00:00	2017-04-27 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2017-02-21 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	1900-01-01 00:00:00	2016-10-01 00:00:00	2017-08-07 00:00:00	2018-04-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2018-01-02 00:00:00	2020-12-31 00:00:00	2020-12-31 00:00:00	2020-12-28 00:00:00	1900-01-01 00:00:00	2018-10-01 00:00:00	2020-11-25 00:00:00	2020-10-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2020-10-19 00:00:00	1900-01-01 00:00:00	2020-06-25 00:00:00	2017-10-01 00:00:00	2017-07-01 00:00:00	2018-04-23 00:00:00	2018-12-30 00:00:00	2018-08-02 00:00:00	2018-12-28 00:00:00	2019-10-01 00:00:00	2020-04-23 00:00:00	2020-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2020-07-01 00:00:00	2021-10-01 00:00:00	2021-01-14 00:00:00	2021-10-01 00:00:00	1900-01-01 00:00:00	2021-04-01 00:00:00	1900-01-01 00:00:00	2022-01-01 00:00:00	2021-07-01 00:00:00	2021-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2022-04-01 00:00:00	1900-01-01 00:00:00	2021-04-01 00:00:00	1900-01-01 00:00:00	2022-04-07 00:00:00	2021-07-01 00:00:00	1900-01-01 00:00:00	2021-11-12 00:00:00	2022-07-01 00:00:00
rpt_end	1995-09-30 00:00:00	1997-09-30 00:00:00	1999-09-30 00:00:00	1995-12-31 00:00:00	1997-12-31 00:00:00	1995-06-30 00:00:00	1996-09-30 00:00:00	1996-12-31 00:00:00	1998-12-31 00:00:00	1997-03-31 00:00:00	1997-06-30 00:00:00	1996-06-30 00:00:00	1997-09-30 00:00:00	1997-03-31 00:00:00	1996-12-31 00:00:00	1996-03-31 00:00:00	1998-06-30 00:00:00	1996-12-31 00:00:00	1997-12-31 00:00:00	1996-03-31 00:00:00	1995-03-31 00:00:00	1997-06-30 00:00:00	1996-06-30 00:00:00	1998-03-31 00:00:00	1999-03-31 00:00:00	1999-06-30 00:00:00	1998-09-30 00:00:00	None	2000-03-31 00:00:00	2000-03-31 00:00:00	1999-12-31 00:00:00	2000-09-30 00:00:00	2000-06-30 00:00:00	2000-06-30 00:00:00	2000-12-31 00:00:00	2000-12-31 00:00:00	2000-09-30 00:00:00	2000-06-30 00:00:00	1900-01-01 00:00:00	2000-06-30 00:00:00	1900-01-01 00:00:00	2001-03-31 00:00:00	2001-03-31 00:00:00	2001-06-30 00:00:00	2001-06-30 00:00:00	2001-09-30 00:00:00	2001-09-30 00:00:00	2001-12-31 00:00:00	1900-01-01 00:00:00	2002-03-31 00:00:00	2001-12-31 00:00:00	2001-06-30 00:00:00	2000-12-31 00:00:00	2000-12-31 00:00:00	2001-06-30 00:00:00	2002-03-31 00:00:00	2002-06-30 00:00:00	2002-06-30 00:00:00	2002-09-30 00:00:00	1900-01-01 00:00:00	2002-09-30 00:00:00	2002-12-31 00:00:00	2002-12-31 00:00:00	2003-06-30 00:00:00	1900-01-01 00:00:00	2003-06-30 00:00:00	2002-06-30 00:00:00	1900-01-01 00:00:00	2003-03-31 00:00:00	2003-03-31 00:00:00	2002-06-30 00:00:00	1900-01-01 00:00:00	2003-09-30 00:00:00	2003-12-31 00:00:00	2003-12-31 00:00:00	2003-09-30 00:00:00	2003-06-30 00:00:00	2003-12-31 00:00:00	2004-03-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2004-03-31 00:00:00	2004-06-30 00:00:00	2004-06-30 00:00:00	1900-01-01 00:00:00	2004-09-30 00:00:00	2003-12-31 00:00:00	2003-06-30 00:00:00	2004-09-30 00:00:00	1900-01-01 00:00:00	2004-12-25 00:00:00	2004-06-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2004-12-31 00:00:00	2004-06-30 00:00:00	2005-03-31 00:00:00	2004-12-31 00:00:00	2005-06-30 00:00:00	2005-09-30 00:00:00	2006-03-31 00:00:00	2005-12-31 00:00:00	2006-06-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2007-01-15 00:00:00	2006-06-30 00:00:00	2006-12-07 00:00:00	2007-03-31 00:00:00	2006-09-30 00:00:00	1900-01-01 00:00:00	2007-06-25 00:00:00	2007-06-11 00:00:00	2006-12-31 00:00:00	2006-06-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2007-09-30 00:00:00	2007-06-30 00:00:00	1900-01-01 00:00:00	1900-01-01 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	2013-11-04 00:00:00	2013-09-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2013-06-30 00:00:00	2013-07-15 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	2007-10-24 00:00:00	2007-12-31 00:00:00	2008-03-31 00:00:00	2007-12-31 00:00:00	2008-06-30 00:00:00	2008-05-29 00:00:00	1900-01-01 00:00:00	2008-10-01 00:00:00	2008-12-07 00:00:00	2008-12-07 00:00:00	2008-12-08 00:00:00	2008-12-31 00:00:00	2008-12-31 00:00:00	1900-01-01 00:00:00	2009-02-01 00:00:00	1900-01-01 00:00:00	2008-09-30 00:00:00	2009-03-31 00:00:00	2009-07-28 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2009-10-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2009-12-22 00:00:00	2009-09-30 00:00:00	2009-06-30 00:00:00	2010-03-31 00:00:00	2009-06-30 00:00:00	2009-12-31 00:00:00	2009-06-30 00:00:00	2009-12-31 00:00:00	2009-12-31 00:00:00	1900-01-01 00:00:00	2010-01-04 00:00:00	2010-06-30 00:00:00	2010-06-30 00:00:00	2010-11-10 00:00:00	2010-09-30 00:00:00	2011-02-09 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2010-12-21 00:00:00	1900-01-01 00:00:00	2011-01-31 00:00:00	2010-12-21 00:00:00	2010-12-30 00:00:00	2010-12-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2010-06-30 00:00:00	2010-11-15 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2010-12-31 00:00:00	2011-06-30 00:00:00	2011-03-31 00:00:00	2011-12-31 00:00:00	2012-01-30 00:00:00	2011-09-30 00:00:00	2011-03-31 00:00:00	2011-06-30 00:00:00	1900-01-01 00:00:00	2012-03-31 00:00:00	2012-06-30 00:00:00	2013-10-29 00:00:00	2013-12-31 00:00:00	2015-01-30 00:00:00	2014-11-13 00:00:00	2014-09-30 00:00:00	2014-12-30 00:00:00	1900-01-01 00:00:00	2012-11-15 00:00:00	1900-01-01 00:00:00	2012-09-30 00:00:00	2012-03-31 00:00:00	2012-06-30 00:00:00	2012-12-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2012-12-30 00:00:00	2012-11-12 00:00:00	2012-12-31 00:00:00	1900-01-01 00:00:00	2014-03-31 00:00:00	2013-03-31 00:00:00	2013-12-31 00:00:00	2013-03-05 00:00:00	1900-01-01 00:00:00	2013-01-22 00:00:00	2013-03-31 00:00:00	2015-09-30 00:00:00	2018-03-31 00:00:00	2019-03-31 00:00:00	2018-07-06 00:00:00	1900-01-01 00:00:00	2018-06-30 00:00:00	2018-12-28 00:00:00	2019-03-01 00:00:00	1900-01-01 00:00:00	2020-06-30 00:00:00	1900-01-01 00:00:00	2019-06-30 00:00:00	2019-09-30 00:00:00	2017-12-31 00:00:00	1900-01-01 00:00:00	2018-09-30 00:00:00	1900-01-01 00:00:00	2016-01-15 00:00:00	1900-01-01 00:00:00	2015-12-31 00:00:00	2016-03-31 00:00:00	2016-06-30 00:00:00	2016-09-30 00:00:00	2016-12-31 00:00:00	2016-11-10 00:00:00	2017-01-11 00:00:00	1900-01-01 00:00:00	2016-12-15 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2017-03-31 00:00:00	2017-04-27 00:00:00	2017-04-27 00:00:00	2017-04-27 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2017-02-21 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	1900-01-01 00:00:00	2016-12-31 00:00:00	2017-08-07 00:00:00	2018-06-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2018-01-02 00:00:00	2020-12-31 00:00:00	2020-12-31 00:00:00	2020-12-28 00:00:00	1900-01-01 00:00:00	2018-12-31 00:00:00	2020-11-25 00:00:00	2020-12-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2020-10-19 00:00:00	1900-01-01 00:00:00	2020-06-25 00:00:00	2017-12-31 00:00:00	2017-09-30 00:00:00	2018-04-23 00:00:00	2018-12-30 00:00:00	2018-08-02 00:00:00	2018-12-28 00:00:00	2019-12-31 00:00:00	2020-04-23 00:00:00	2020-03-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2020-09-30 00:00:00	2021-12-31 00:00:00	2021-01-14 00:00:00	2021-12-31 00:00:00	1900-01-01 00:00:00	2021-06-30 00:00:00	1900-01-01 00:00:00	2022-03-31 00:00:00	2021-09-30 00:00:00	2021-03-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2022-06-30 00:00:00	1900-01-01 00:00:00	2021-06-30 00:00:00	1900-01-01 00:00:00	2022-04-07 00:00:00	2021-09-30 00:00:00	1900-01-01 00:00:00	2021-11-12 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	None	None	None	None	None	None	None	None	None	None	None	None	None	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	22001	None	None	22001	None	None	22001	None	22001	None	None	22001	None	22001	22001	22001	22001	None	None	None	None	22001	None	None	22001	None	None	None	None	22001	22001	None	None	22001	None	22001	None	22001	22001	22001	22001	22001	None	None	22001	22001	22001	22001	22001	None	22001	22001	22001	22001	None	None	22001	22001	None	None	None	22001	22001	22001	22006	22001	None	None	22001	22001	None	None	22001	None	22001	22001	22001	22001	22001	22001	None	22001	22001	22001	22001	22001	22001	None	22006	None	22001	22001	22001	None	None	None	22001	None	None	22001	22001	22001	22001	22001	22001	22001	22006	22006	None	22001	22001	22001	22001	22001	22001	None	None	None	22001	None	22001	22001	22001	22001	None	None	22001	22001	None	None	None	22001	22001	22001	22001	22001	22001	22001	22001	None	22001	22001	22001	22001	22006	22001	22001	22001	None	22001	None	22001	22001	22001	22001	None	None	None	22001	22001	22001	None	22001	22001	22001	22001	None	22006	22001	22001	22006	22006	22006	None	22006	22006	22006	None	22006	None	22006	22006	22006	None	22006	None	22001	None	22001	22001	22001	22001	22001	22001	22006	None	22001	None	None	22006	22006	22006	22006	None	None	22001	None	22006	None	None	None	22001	22006	22006	None	None	22001	22001	22006	22006	None	22006	22006	22006	None	None	22006	None	22006	22006	22006	22006	22001	22006	22006	22006	22006	22006	None	None	22006	22006	22006	22006	None	22006	None	22006	22006	22006	None	None	22006	None	22006	None	22006	22006	None	22006	22006

Table: filer_interests
filer_id	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938
session_id	1999	1995	1997	2001	2003	2009	2005	2007	2011	2013	2015	2019	2017	2021	2023
interest_cd	40315	40315	40315	40317	40315	40315	40315	40315	40315	40315	40312	40312	40312	40312	40312
effect_date	1999-01-01 00:00:00	1994-12-05 00:00:00	1997-01-01 00:00:00	2001-01-01 00:00:00	2003-01-01 00:00:00	2009-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	2015-01-01 00:00:00	2019-01-01 00:00:00	2017-01-01 00:00:00	2021-01-01 00:00:00	2023-01-01 00:00:00

Table: filer_to_filer_type
filer_id	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938
filer_type	2	2	2	2	2	2	2	2	2	2	2	2	2	2	2
active	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	N
race	0	0	0	0	None	None	None	None	None	None	None	None	None	None	None
session_id	1997	1999	1995	2001	2003	2005	2007	2013	2011	2009	2015	2017	2021	2019	2023
category	0	0	0	0	None	None	None	None	None	None	None	None	None	None	None
category_type	0	0	0	0	None	None	None	None	None	None	None	None	None	None	None
sub_category	0	0	0	0	None	None	None	None	None	None	None	None	None	None	None
effect_dt	1997-01-01 00:00:00	1999-01-01 00:00:00	1994-12-05 00:00:00	2001-01-01 00:00:00	2003-01-01 00:00:00	2005-01-01 00:00:00	2007-01-01 00:00:00	2013-01-01 00:00:00	2011-01-01 00:00:00	2009-01-01 00:00:00	2015-01-01 00:00:00	2017-01-01 00:00:00	2021-01-01 00:00:00	2019-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		1146938
xref_id		E22985
effect_dt		1999-12-08 00:00:00
migration_source		MASTER

Table: filername
xref_filer_id	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985	E22985
filer_id	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938
filer_type	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER
status	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE
effect_dt	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00
naml	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION
namf	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
adr1	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
adr2	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
city	Sacramento	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	Sacramento	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	Sacramento	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	Sacramento	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	Sacramento	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	Sacramento	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	Sacramento	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	Sacramento	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	Sacramento	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	Sacramento	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	Sacramento	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	Sacramento	SACRAMENTO	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
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
phon	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933	9164437933
fax	None	None	9164431960		9164431960		9164431960	9164431960	9164431960	9164431960	9164431960	9164431960	9164431960	None	None	9164431960		9164431960		9164431960	9164431960	9164431960	9164431960	9164431960	9164431960	9164431960	None	None	9164431960		9164431960		9164431960	9164431960	9164431960	9164431960	9164431960	9164431960	9164431960	None	None	9164431960		9164431960		9164431960	9164431960	9164431960	9164431960	9164431960	9164431960	9164431960	None	None	9164431960		9164431960		9164431960	9164431960	9164431960	9164431960	9164431960	9164431960	9164431960	None	None	9164431960		9164431960		9164431960	9164431960	9164431960	9164431960	9164431960	9164431960	9164431960	None	None	9164431960		9164431960		9164431960	9164431960	9164431960	9164431960	9164431960	9164431960	9164431960	None	None	9164431960		9164431960		9164431960	9164431960	9164431960	9164431960	9164431960	9164431960	9164431960	None	None	9164431960		9164431960		9164431960	9164431960	9164431960	9164431960	9164431960	9164431960	9164431960	None	None	9164431960		9164431960		9164431960	9164431960	9164431960	9164431960	9164431960	9164431960	9164431960	None	None	9164431960		9164431960		9164431960	9164431960	9164431960	9164431960	9164431960	9164431960	9164431960	None	None	9164431960		9164431960		9164431960	9164431960	9164431960	9164431960	9164431960	9164431960	9164431960	None	None	9164431960		9164431960		9164431960	9164431960	9164431960	9164431960	9164431960	9164431960	9164431960
email	None	None	None	None	None	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	None	None	None	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	None	None	None	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	None	None	None	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	None	None	None	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	None	None	None	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	None	None	None	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	None	None	None	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	None	None	None	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	None	None	None	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	None	None	None	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	None	None	None	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]	None	None	None	None	None	None	None	None	[email protected]	[email protected]	[email protected]	[email protected]	[email protected]

Table: filers
filer_id		1146938

Table: lobbying_chg_log
filer_id	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938
change_no	1	2	4	0	3	8	7	6	5	10	19	11	9	14	12	17	18	16	13	15	20	21	23	22	26	24	29	27	25	30	28	33	32	31	34
session_id	1999	2001	2001	2001	1999	2003	2003	2003	2003	2007	2009	2007	2007	2007	2007	2009	2009	2009	2007	2009	2011	2013	2013	2013	2015	2015	2017	2017	2015	2017	2017	2017	2017	2017	2019
log_dt	2000-05-01 00:00:00	2001-04-09 00:00:00	2002-01-24 00:00:00	2002-01-24 00:00:00	2001-02-26 00:00:00	2004-10-08 00:00:00	2004-02-19 00:00:00	2003-05-22 00:00:00	2003-03-12 00:00:00	2007-06-29 00:00:00	2010-01-26 00:00:00	2007-06-15 00:00:00	2007-11-08 00:00:00	2008-10-16 00:00:00	2007-11-08 00:00:00	2010-01-12 00:00:00	2010-01-26 00:00:00	2009-12-29 00:00:00	2008-01-10 00:00:00	2009-07-28 00:00:00	2011-10-06 00:00:00	2013-03-07 00:00:00	2013-11-19 00:00:00	2013-07-15 00:00:00	2016-02-03 00:00:00	2015-01-26 00:00:00	2017-06-12 00:00:00	2017-04-27 00:00:00	2016-02-03 00:00:00	2017-10-24 00:00:00	2017-04-27 00:00:00	2018-08-02 00:00:00	2018-07-06 00:00:00	2018-01-12 00:00:00	2020-04-27 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	2	2	2	2	2	2	2	2	2	2
correction_flg	Y	Y	Y	Y	Y	None	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	None	None	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	None
action	ADDED	ADDED	DELETED	ADDED	DELETED	DELETED	ADDED	NEW	TERMINATED	ADDED	ADDED	TERMINATED	DELETED	ADDED	ADDED	DELETED	DELETED	ADDED	ADDED	DELETED	DELETED	TERMINATED	DELETED	DELETED	ADDED	ADDED	ADDED	DELETED	DELETED	DELETED	ADDED	DELETED	DELETED	ADDED	DELETED
attribute_changed	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	None	None	None	FIRM	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	LOBBYIST	FIRM	LOBBYIST	FIRM	FIRM	LOBBYIST	FIRM	LOBBYIST	FIRM	FIRM	FIRM	FIRM	FIRM	LOBBYIST	FIRM	FIRM	FIRM	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	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
filer_full_name	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION	CALIFORNIA BUILDING INDUSTRY ASSOCIATION
filer_city	None	None	None	None	Sacramento	None	None	Sacramento	Sacramento	Sacramento	Sacramento	Sacramento	None	Sacramento	Sacramento	None	None	Sacramento	Sacramento	None	None	None	None	None	Sacramento	Sacramento	Sacramento	None	Sacramento	None	Sacramento	None	None	Sacramento	None
filer_st	None	None	None	None	CA	None	None	CA	CA	CA	CA	CA	None	CA	CA	None	None	CA	CA	None	None	None	None	None	CA	CA	CA	None	CA	None	CA	None	None	CA	None
filer_zip	None	None	None	None	95814	None	None	95814	95814	95814	95814	95814	None	95814	95814	None	None	95814	95814	None	None	None	None	None	95814	95814	95814	None	95814	None	95814	None	None	95814	None
filer_phone	None	None	None	None	9164437933	None	None	9164437933	9164437933	9164437933	9164437933	9164437933	None	9164437933	9164437933	None	None	9164437933	9164437933	None	None	None	None	None	9164437933	9164437933	9164437933	None	9164437933	None	9164437933	None	None	9164437933	None
entity_type	4	4	4	4	4	4	4	4	4	3	4	4	4	4	4	3	4	3	3	4	3	4	3	3	3	3	3	4	3	3	3	4	4	3	4
entity_name	NICK J. CAMMAROTA	KIMBERLEY LANEI DELLINGER	CLIFF MORIYAMA	BRIAN E. WHITE	JUAN ACOSTA	BRIAN E. WHITE	DELLINGER, KIMBERLEY L.	HOUDESHELDT, BRUCE	DELLINGER, KIMBERLY L.	GILSON GOVERNMENT STRATEGIES	BRYANT, JASON	SUAREZ, EMMA T.	DELLINGER, KIMBERLEY	BARNETT, ALLISON	CRUZ, STEVEN D.	MONTGOMERY CONSULTING LLC	COYLE, TIMOTHY L.	POLITICAL SOLUTIONS INC.	MONTGOMERY CONSULTING LLC	CRUZ, STEVEN	KP PUBLIC AFFAIRS	BRYANT, JASON	POLITICAL SOLUTIONS, LLC	STRATEGIC ADVOCATION, INC.	SACRAMENTO ADVOCATES INC.	MORIYAMA CONSULTING; CLIFF	CAPITOL ADVOCACY, LLC	LYON, RICHARD	GILSON GOVERNMENT STRATEGIES	CAPITOL ADVOCACY, LLC	LYON CONSULTING, RJ	STINSON, ALYSSA	GUERRERO, ERIN M.	QUINTANA CRUZ COMPANY; THE	ANDREW KOSYDAR
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	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	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	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	None	None	None	None	None	None	None	None	None	None
entity_id	1224120	1223090	1148479	1148975	None	1148975	1223090	None	None	None	None	None	1223090	None	None	1303301	1149091	None	None	1149527	1147235	1324133	1261533	1315530	None	None	None	1148326	None	1147785	None	1382386	1382385	None	1414582
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
effect_dt	None	2001-01-15 00:00:00	2001-12-31 00:00:00	2002-01-02 00:00:00	2000-12-15 00:00:00	2004-09-08 00:00:00	2004-02-01 00:00:00	2003-04-21 00:00:00	2003-02-10 00:00:00	2007-07-01 00:00:00	2010-01-01 00:00:00	2007-05-31 00:00:00	2007-10-20 00:00:00	2008-10-01 00:00:00	2007-10-24 00:00:00	2010-01-01 00:00:00	2009-12-31 00:00:00	2010-01-01 00:00:00	2008-01-01 00:00:00	2009-06-20 00:00:00	2011-10-19 00:00:00	2013-02-25 00:00:00	2013-11-30 00:00:00	2013-07-15 00:00:00	2016-01-01 00:00:00	2015-01-01 00:00:00	2017-05-31 00:00:00	2017-04-30 00:00:00	2016-01-01 00:00:00	2017-10-15 00:00:00	2017-05-01 00:00:00	2018-07-23 00:00:00	2018-07-06 00:00:00	2018-01-01 00:00:00	2020-03-31 00:00:00

Table: lobbyist_contributions1
filer_id	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938
filing_period_start_dt	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-10-01 00:00:00
filing_period_end_dt	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-12-31 00:00:00
contribution_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
recipient_name	DAMIAN JONES FOR ASSEMBLY	HISPANIC REPUBLICAN ASSOCIATION OF SAN DIEGO	FRIENDS OF JIM BRULTE	SENATE DEMOCRATIC LEADERSHIP FUND	ELLEN CORBETT FOR ASSEMBLY	ED CHAVEZ FOR ASSEMBLY	FRIENDS OF SENATOR RICHARD ALARCON	DEMOCRATIC BUSINESS PAC	RIGHEIMER ASSEMBLY 2000	TONY WEST FOR STATE ASSEMBLY	JUDY MIKELS FOR SENATE	COMMITTEE TO RE ELECT JACK SCOTT	JOHN LONGVILLE FOR ASSEMBLY	THE CA FRIENDS LATINO PAC	COMMITTEE TO RE ELECT JAMES L. COX FOR STATE ASSEMBLY	FRIENDS OF DENISE MORENO DUCHENY	GEORGE NAKANO FOR ASSEMBLY	ASSEMBLY VICTORY FUND	PORTILLO FOR ASSEMBLY	CORTEZ FOR ASSEMBLY	FRIENDS OF JENNY OROPEZA 2000	STEVE BLANTON FOR ASSEMBLY	REBECCA COHN FOR ASSEMBLY	ED VINCENT FOR ASSEMBLY	COSTA FOR SENATE COMIITTEE	MIKE MACHADO FOR ASSEMBLY	FRIENDS OF KERRY MAZZONI	SENATOR PATRICK JOHNSTON MAJORITY FUND	ROD WRIGHT FOR ASSEMBLY	MIKE MACHADO FOR ASSEMBLY	BAUGH FOR ASSEMBLY	FRIENDS OF TIM LESLIE	FRIENDS OF DENNIS CARDOZA	DIAZ FOR ASSEMBLY	JAN LEJA FOR ASSEMBLY	CALIFORNIA FRIENDS LATINO PAC
recipient_id	1221243	1221410	1069427	1064947	1072279	1075999	1071999	1072621	1075811	1221343	1075994	1069612	1054549	1073234	1070865	1058503	1071962	1060096	1075919	1076171	1075882	1077109	1076212	1065367	1072145	1069405	1061398	1053281	1050512	1069405	1072136	1047493	1069846	1220119	1076338	1073185
amount	1500	500	5000	5000	500	1000	1000	500	2000	3000	2500	3000	1000	2500	5000	1000	500	2500	1000	3000	3000	2500	2500	3000	500	2000	500	1000	500	1000	2500	150	1000	3000	3000	3000

Table: lobbyist_contributions2
filer_id	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938
filing_period_start_dt	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-01-01 00:00:00	2000-10-01 00:00:00
filing_period_end_dt	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-03-31 00:00:00	2000-12-31 00:00:00
contribution_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
recipient_name	DAMIAN JONES FOR ASSEMBLY	HISPANIC REPUBLICAN ASSOCIATION OF SAN DIEGO	FRIENDS OF JIM BRULTE	SENATE DEMOCRATIC LEADERSHIP FUND	ELLEN CORBETT FOR ASSEMBLY	ED CHAVEZ FOR ASSEMBLY	FRIENDS OF SENATOR RICHARD ALARCON	DEMOCRATIC BUSINESS PAC	RIGHEIMER ASSEMBLY 2000	TONY WEST FOR STATE ASSEMBLY	JUDY MIKELS FOR SENATE	COMMITTEE TO RE ELECT JACK SCOTT	JOHN LONGVILLE FOR ASSEMBLY	THE CA FRIENDS LATINO PAC	COMMITTEE TO RE ELECT JAMES L. COX FOR STATE ASSEMBLY	FRIENDS OF DENISE MORENO DUCHENY	GEORGE NAKANO FOR ASSEMBLY	ASSEMBLY VICTORY FUND	PORTILLO FOR ASSEMBLY	CORTEZ FOR ASSEMBLY	FRIENDS OF JENNY OROPEZA 2000	STEVE BLANTON FOR ASSEMBLY	REBECCA COHN FOR ASSEMBLY	ED VINCENT FOR ASSEMBLY	COSTA FOR SENATE COMIITTEE	MIKE MACHADO FOR ASSEMBLY	FRIENDS OF KERRY MAZZONI	SENATOR PATRICK JOHNSTON MAJORITY FUND	ROD WRIGHT FOR ASSEMBLY	MIKE MACHADO FOR ASSEMBLY	BAUGH FOR ASSEMBLY	FRIENDS OF TIM LESLIE	FRIENDS OF DENNIS CARDOZA	DIAZ FOR ASSEMBLY	JAN LEJA FOR ASSEMBLY	CALIFORNIA FRIENDS LATINO PAC
recipient_id	1221243	1221410	1069427	1064947	1072279	1075999	1071999	1072621	1075811	1221343	1075994	1069612	1054549	1073234	1070865	1058503	1071962	1060096	1075919	1076171	1075882	1077109	1076212	1065367	1072145	1069405	1061398	1053281	1050512	1069405	1072136	1047493	1069846	1220119	1076338	1073185
amount	1500	500	5000	5000	500	1000	1000	500	2000	3000	2500	3000	1000	2500	5000	1000	500	2500	1000	3000	3000	2500	2500	3000	500	2000	500	1000	500	1000	2500	150	1000	3000	3000	3000

Table: received_filings
filer_id	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938	1146938
filing_file_name	4349.cal	624620_0.cal	28471.cal	644396_0.cal	681584_0.cal	27942.cal	31644.cal	31946.cal	31721.cal	32061.cal	32016.cal	25760.cal	25784.cal	644396_1.cal	16689.cal	16713.cal	16754.cal	20887.cal	20921.cal	719118_0.cal	247030.cal	746026_0.cal	769319_0.cal	125690.cal	125885.cal	791538_0.cal	223799.cal	224225.cal	223492.cal	223743.cal	224184.cal	225327.cal	499519.cal	430833.cal	432999.cal	434431.cal	443631.cal	444546.cal	446080.cal	500387.cal	812196_0.cal	838854_0.cal	769319_1.cal	855183_0.cal	719118_1.cal	879288_0.cal	910659_0.cal	928614_0.cal	855183_1.cal	943254_0.cal	968907_0.cal	983196_0.cal	1011676_0.cal	983196_1.cal	55138.cal	1075449_0.cal	1100864_0.cal	1143409_0.cal	1131094_0.cal	1163027_0.cal	1184821_0.cal	1328584_0.cal	1393844_0.cal	1451646_0.cal	203490.cal	1215165_0.cal	1184821_1.cal	1235675_0.cal	1184821_2.cal	240567.cal	1465336_0.cal	455703.cal	178303.cal	1421421_0.cal	1293918_0.cal	1376591_0.cal	1311213_1.cal	1311213_0.cal	1737166_0.cal	1679647_0.cal	1782555_0.cal	1799620_0.cal	1556491_0.cal	1817107_0.cal	1589800_1.cal	1589800_0.cal	1763985_0.cal	1636388_0.cal	1622292_0.cal	1657990_1.cal	1679647_1.cal	1722847_0.cal	1708599_0.cal	1657990_0.cal	1870666_0.cal	2129148_0.cal	1996686_0.cal	2009648_0.cal	2101985_0.cal	1911337_0.cal	2061272_0.cal	2037893_0.cal	1935028_0.cal	1979961_0.cal	447195.cal	1965027_0.cal
received_date	2000-07-31 00:00:00	2000-05-02 00:00:00	2000-05-02 00:00:00	2000-07-31 00:00:00	2000-10-31 00:00:00	2000-10-31 00:00:00	2000-10-31 00:00:00	2000-10-31 00:00:00	2000-10-31 00:00:00	2000-10-31 00:00:00	2000-10-31 00:00:00	2000-12-21 00:00:00	2000-12-21 00:00:00	2000-12-21 00:00:00	2000-12-08 00:00:00	2000-12-08 00:00:00	2000-12-08 00:00:00	2000-12-11 00:00:00	2000-12-11 00:00:00	2001-01-31 00:00:00	2001-04-30 00:00:00	2001-04-30 00:00:00	2001-07-24 00:00:00	2001-07-24 00:00:00	2001-07-24 00:00:00	2001-10-31 00:00:00	2002-01-24 00:00:00	2002-01-24 00:00:00	2002-01-24 00:00:00	2002-01-24 00:00:00	2002-01-24 00:00:00	2002-01-24 00:00:00	2002-01-29 00:00:00	2002-01-28 00:00:00	2002-01-28 00:00:00	2002-01-28 00:00:00	2002-01-28 00:00:00	2002-01-28 00:00:00	2002-01-28 00:00:00	2002-01-29 00:00:00	2002-01-29 00:00:00	2002-04-29 00:00:00	2002-05-10 00:00:00	2002-07-30 00:00:00	2002-09-19 00:00:00	2002-10-25 00:00:00	2003-01-30 00:00:00	2003-04-24 00:00:00	2003-03-06 00:00:00	2003-07-21 00:00:00	2003-10-30 00:00:00	2004-01-19 00:00:00	2004-04-27 00:00:00	2004-04-27 00:00:00	2004-12-27 00:00:00	2005-01-25 00:00:00	2005-04-18 00:00:00	2006-01-23 00:00:00	2005-10-26 00:00:00	2006-04-19 00:00:00	2006-07-18 00:00:00	2008-04-29 00:00:00	2009-01-29 00:00:00	2009-10-29 00:00:00	2006-10-30 00:00:00	2006-10-30 00:00:00	2006-10-30 00:00:00	2007-01-30 00:00:00	2007-01-30 00:00:00	2007-01-17 00:00:00	2010-02-01 00:00:00	2007-06-13 00:00:00	2009-04-30 00:00:00	2009-04-30 00:00:00	2007-10-22 00:00:00	2008-10-30 00:00:00	2008-02-11 00:00:00	2008-01-31 00:00:00	2013-01-30 00:00:00	2012-07-31 00:00:00	2013-07-31 00:00:00	2013-10-30 00:00:00	2011-01-03 00:00:00	2014-01-30 00:00:00	2011-08-10 00:00:00	2011-04-28 00:00:00	2013-04-29 00:00:00	2012-01-31 00:00:00	2011-10-31 00:00:00	2012-10-31 00:00:00	2012-10-31 00:00:00	2013-01-04 00:00:00	2012-10-31 00:00:00	2012-04-30 00:00:00	2014-07-30 00:00:00	2017-01-31 00:00:00	2015-10-30 00:00:00	2016-01-28 00:00:00	2016-10-31 00:00:00	2014-10-31 00:00:00	2016-07-29 00:00:00	2016-05-02 00:00:00	2015-01-30 00:00:00	2015-07-30 00:00:00	2015-04-30 00:00:00	2015-04-30 00:00:00
filing_directory	/usr/users/cafiler/disclose/ca99/temp	/usr/users/cafiler/disclose/ca99/cal	/usr/users/cafiler/disclose/ca99/temp	/usr/users/cafiler/disclose/ca99/cal	/usr/users/cafiler/disclose/ca99/cal	/usr/users/cafiler/disclose/ca99/temp	/usr/users/cafiler/disclose/ca99/temp	/usr/users/cafiler/disclose/ca99/temp	/usr/users/cafiler/disclose/ca99/temp	/usr/users/cafiler/disclose/ca99/temp	/usr/users/cafiler/disclose/ca99/temp	/usr/users/cafiler/disclose/ca99/temp	/usr/users/cafiler/disclose/ca99/temp	/usr/users/cafiler/disclose/ca99/cal	/usr/users/cafiler/disclose/ca99/temp	/usr/users/cafiler/disclose/ca99/temp	/usr/users/cafiler/disclose/ca99/temp	/usr/users/cafiler/disclose/ca99/temp	/usr/users/cafiler/disclose/ca99/temp	/usr/users/cafiler/disclose/ca99/cal	/usr/users/cafiler/disclose/ca99/temp	/usr/users/cafiler/disclose/ca99/cal	/usr/users/cafiler/disclose/ca99/cal	/usr/users/cafiler/disclose/ca99/temp	/usr/users/cafiler/disclose/ca99/temp	/usr/users/cafiler/disclose/ca99/cal	/usr/users/cafiler/disclose/ca99/temp	/usr/users/cafiler/disclose/ca99/temp	/usr/users/cafiler/disclose/ca99/temp	/usr/users/cafiler/disclose/ca99/temp	/usr/users/cafiler/disclose/ca99/temp	/usr/users/cafiler/disclose/ca99/temp	/usr/users/cafiler/disclose/ca99/temp	/usr/users/cafiler/disclose/ca99/temp	/usr/users/cafiler/disclose/ca99/temp	/usr/users/cafiler/disclose/ca99/temp	/usr/users/cafiler/disclose/ca99/temp	/usr/users/cafiler/disclose/ca99/temp	/usr/users/cafiler/disclose/ca99/temp	/usr/users/cafiler/disclose/ca99/temp	/usr/users/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/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/cal	/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/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	/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	/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/cal
filing_id	None	624620	None	644396	681584	None	None	None	None	None	None	None	None	644396	None	None	None	None	None	719118	None	746026	769319	None	None	791538	None	None	None	None	None	None	None	None	None	None	None	None	None	None	812196	838854	769319	855183	719118	879288	910659	928614	855183	943254	968907	983196	1011676	983196	None	1075449	1100864	1143409	1131094	1163027	1184821	1328584	1393844	1451646	None	1215165	1184821	1235675	1184821	None	1465336	None	None	1421421	1293918	1376591	1311213	1311213	1737166	1679647	1782555	1799620	1556491	1817107	1589800	1589800	1763985	1636388	1622292	1657990	1679647	1722847	1708599	1657990	1870666	2129148	1996686	2009648	2101985	1911337	2061272	2037893	1935028	1979961	None	1965027
form_id	None	F635	None	F635	F635	None	None	None	None	None	None	None	None	F635	None	None	None	None	None	F635	None	F635	F635	None	None	F635	None	None	None	None	None	None	None	None	None	None	None	None	None	None	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	None	F635	F635	F635	F635	F635	F635	F635	F635	F635	None	F635	F635	F635	F635	None	F635	None	None	F635	F635	F635	F635	F635	F635	F635	F635	F635	F602	F635	F635	F635	F635	F635	F635	F635	F635	F602	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	None	F635
receive_comment	Filing pass validation, but failed DB constraints	Filing accepted, but but with warnings	Filing did not pass validation	Filing accepted	Filing accepted	Filing pass validation, but failed DB constraints	Filing pass validation, but failed DB constraints	Filing pass validation, but failed DB constraints	Filing pass validation, but failed DB constraints	Filing pass validation, but failed DB constraints	Filing pass validation, but failed DB constraints	Filing did not pass validation	Filing did not pass validation	Filing accepted	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 accepted	Filing did not pass validation	Filing accepted	Filing accepted, but with warnings	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing accepted	Filing passed validation, but failed DB constraints	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 passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing accepted	Filing accepted	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing accepted	Filing accepted	Filing accepted	Filing accepted	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 passed validation, but failed DB constraints	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing did not pass validation	Filing accepted	Filing did not pass validation	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	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	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing passed validation, but failed DB constraints	Filing accepted