OpenCalAccess

Filer ID: 1147198

Table: filer_acronyms
acronym		CAPP
filer_id		1147198

Table: filer_address
filer_id	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198
adrid	1110323	2011646	2041888	1112226	1109523	2085583	2115510	2166911	2207928	2415924	2550210	2279304	2506154	2343142	2472506
effect_dt	1999-01-01 00:00:00	2001-01-01 00:00:00	2003-01-01 00:00:00	1997-04-01 00:00:00	1995-01-01 00:00:00	2005-01-01 00:00:00	2007-01-01 00:00:00	2009-01-01 00:00:00	2011-01-01 00:00:00	2017-01-01 00:00:00	2023-01-01 00:00:00	2013-01-01 00:00:00	2021-01-01 00:00:00	2015-01-01 00:00:00	2019-01-01 00:00:00
add_type	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051
session_id	1999	2001	2003	1997	1995	2005	2007	2009	2011	2017	2023	2013	2021	2015	2019

Table: filer_filings
filer_id	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198
filing_id	1082902	499128	500831	499983	499983	624491	615794	632667	682106	645414	663844	693784	703551	717593	707958	757806	737475	744747	788207	772954	796023	781374	821427	813834	837381	841311	861921	907161	898053	882119	856067	908720	883571	932956	922093	911099	930236	923059	923065	501601	503873	499916	500764	502172	503313	502746	921821	499544	501810	503524	498694	501236	502957	500396	502957	502381	946323	971263	989483	956075	969077	994326	1015918	992865	1012195	1029346	1030885	1057765	1082902	1105817	1095332	1060925	1097140	1090253	1118826	1080870	1103761	1132757	1165891	1147613	1225518	1190853	1216296	1234396	1244744	1283096	1261073	1307051	1293953	1261073	1283096	1776897	1962191	1974696	1864629	1811276	1789970	1795749	1935419	1946750	1905877	1326011	1344342	1372232	1386220	1413795	1394884	1420466	1432312	1449243	1458131	1484138	1484138	1503391	1533396	1533396	1564009	1564754	1553844	1589958	1602574	1587662	1618654	1633049	1654625	1673748	1920559	1719421	1706046	1737127	1842189	1729509	1758944	1993925	2527516	2377461	2208576	2010082	2035505	2060429	2100700	2126702	2112815	2154796	2133988	2172763	2329215	2483673	2271920	2416191	2191835	2395114	2318521	2345060	2238489	2354520	2539086	2438752	2467445	2597892	2671882	2577006	2549010	2578146	2621113	2702287	2637722	2742213
period_id	182	157	159	158	158	161	160	161	163	162	162	163	None	164	None	165	164	165	167	166	None	None	None	168	169	None	None	None	None	171	170	172	None	None	None	None	173	None	None	152	156	150	151	153	155	154	None	142	145	148	141	144	147	143	147	146	174	None	176	None	175	None	None	None	177	178	None	179	181	None	None	None	None	None	182	180	181	183	185	184	188	186	187	188	None	190	189	192	191	189	190	214	221	222	218	216	None	215	220	None	219	193	194	195	196	None	196	197	198	199	200	201	201	202	203	203	204	None	204	None	206	205	207	208	209	210	220	212	211	None	217	212	213	223	243	237	232	224	225	226	227	228	228	229	None	230	236	242	234	239	231	238	235	236	233	None	244	240	241	246	249	245	244	None	247	250	248	251
form_id	F602	F635	F635	F635	F690	F635	F635	F635	F635	F635	F635	F635	F602	F635	F603	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F602	F603	F635	F635	F635	F635	F635	F602	F635	F635	F605	F605	F635	F635	F635	F635	F635	F635	F635	F602	F635	F635	F635	F635	F635	F635	F635	F690	F635	F635	F635	F635	F635	F635	F635	F635	F605	F635	F635	F635	F635	F602	F605	F602	F635	F602	F635	F635	F635	F635	F635	F635	F635	F602	F635	F635	F635	F602	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F602	F635	F635	F602	F635	F635	F635	F635	F602	F602	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F602	F602	F605	F635	F635	F635	F635	F635	F635	F602	F602	F635	F602	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F602	F635	F602	F635	F602	F635	F635	F635	F635	F635	F635	F635	F635	F602	F602	F635	F635	F635	F635	F635	F635	F602	F635	F635	F635	F635
filing_sequence	1	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
filing_date	2005-04-29 00:00:00	1999-04-30 00:00:00	1999-11-01 00:00:00	1999-08-02 00:00:00	1999-11-15 00:00:00	2000-05-01 00:00:00	2000-01-31 00:00:00	2000-04-28 00:00:00	2000-10-31 00:00:00	2000-08-01 00:00:00	2000-07-31 00:00:00	2000-10-31 00:00:00	2000-12-28 00:00:00	2001-01-30 00:00:00	2000-12-22 00:00:00	2001-04-30 00:00:00	2001-01-31 00:00:00	2001-04-27 00:00:00	2001-10-22 00:00:00	2001-07-31 00:00:00	2001-10-25 00:00:00	2001-07-31 00:00:00	2002-01-31 00:00:00	2002-01-31 00:00:00	2002-04-25 00:00:00	2002-04-29 00:00:00	2002-07-31 00:00:00	2003-01-07 00:00:00	2002-12-20 00:00:00	2002-10-29 00:00:00	2002-07-31 00:00:00	2003-01-29 00:00:00	2002-10-29 00:00:00	2003-04-30 00:00:00	2003-02-19 00:00:00	2003-01-30 00:00:00	2003-04-29 00:00:00	2003-02-14 00:00:00	2003-02-14 00:00:00	1998-01-30 00:00:00	1999-02-02 00:00:00	1997-07-31 00:00:00	1997-10-31 00:00:00	1998-04-29 00:00:00	1998-10-30 00:00:00	1998-07-31 00:00:00	2003-02-13 00:00:00	1995-07-28 00:00:00	1996-04-29 00:00:00	1997-01-31 00:00:00	1995-04-28 00:00:00	1996-01-31 00:00:00	1996-10-30 00:00:00	1995-10-27 00:00:00	1997-07-25 00:00:00	1996-07-31 00:00:00	2003-07-30 00:00:00	2003-10-30 00:00:00	2004-01-30 00:00:00	2003-07-30 00:00:00	2003-10-30 00:00:00	2004-01-30 00:00:00	2004-04-29 00:00:00	2004-02-06 00:00:00	2004-04-28 00:00:00	2004-07-30 00:00:00	2004-07-30 00:00:00	2004-10-29 00:00:00	2005-02-02 00:00:00	2005-05-02 00:00:00	2005-01-14 00:00:00	2004-11-01 00:00:00	2005-03-14 00:00:00	2005-01-31 00:00:00	2005-08-01 00:00:00	2005-01-31 00:00:00	2005-04-28 00:00:00	2005-10-28 00:00:00	2006-04-27 00:00:00	2006-01-31 00:00:00	2006-12-29 00:00:00	2006-07-31 00:00:00	2006-10-31 00:00:00	2007-01-29 00:00:00	2006-12-22 00:00:00	2007-07-30 00:00:00	2007-04-27 00:00:00	2008-01-28 00:00:00	2007-10-22 00:00:00	2007-09-22 00:00:00	2007-09-22 00:00:00	2013-07-21 00:00:00	2015-04-26 00:00:00	2015-07-16 00:00:00	2014-07-21 00:00:00	2014-01-19 00:00:00	2013-07-29 00:00:00	2013-10-20 00:00:00	2015-01-31 00:00:00	2014-12-23 00:00:00	2014-10-26 00:00:00	2008-04-22 00:00:00	2008-07-20 00:00:00	2008-10-26 00:00:00	2008-12-29 00:00:00	2008-12-30 00:00:00	2009-01-29 00:00:00	2009-04-29 00:00:00	2009-07-21 00:00:00	2009-10-22 00:00:00	2010-01-17 00:00:00	2010-05-03 00:00:00	2010-04-29 00:00:00	2010-07-26 00:00:00	2010-10-24 00:00:00	2010-10-24 00:00:00	2011-01-22 00:00:00	2010-12-28 00:00:00	2010-12-23 00:00:00	2006-12-14 00:00:00	2011-07-23 00:00:00	2011-04-21 00:00:00	2011-10-21 00:00:00	2012-01-27 00:00:00	2012-04-25 00:00:00	2012-07-23 00:00:00	2014-12-23 00:00:00	2012-12-21 00:00:00	2012-10-28 00:00:00	2012-12-21 00:00:00	2014-04-28 00:00:00	2013-01-21 00:00:00	2013-04-17 00:00:00	2015-10-25 00:00:00	2020-10-30 00:00:00	2019-04-25 00:00:00	2018-01-30 00:00:00	2016-01-29 00:00:00	2016-04-29 00:00:00	2016-07-28 00:00:00	2016-10-31 00:00:00	2017-01-30 00:00:00	2016-12-21 00:00:00	2017-04-27 00:00:00	2016-12-20 00:00:00	2017-07-27 00:00:00	2018-12-21 00:00:00	2020-07-30 00:00:00	2018-07-30 00:00:00	2019-10-28 00:00:00	2017-10-30 00:00:00	2019-07-29 00:00:00	2018-10-31 00:00:00	2019-01-30 00:00:00	2018-04-27 00:00:00	2018-12-21 00:00:00	2020-12-29 00:00:00	2020-01-29 00:00:00	2020-04-24 00:00:00	2021-07-28 00:00:00	2022-04-27 00:00:00	2021-04-26 00:00:00	2021-01-28 00:00:00	2020-12-29 00:00:00	2021-10-28 00:00:00	2022-07-27 00:00:00	2022-01-25 00:00:00	2022-10-27 00:00:00
stmnt_type	10002	10001	10001	10001	10001	10001	10005	10005	10001	10001	10005	10005	10005	10001	10005	10005	10005	10001	10001	10001	10005	10005	10005	10001	10001	10005	10005	10005	10005	10001	10001	10001	10005	10005	10005	10005	10001	10005	10005	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001	10005	10001	10005	10005	10005	10001	10001	10005	10001	10001	10005	10005	10005	10005	10005	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10002	10002	10001	10001	10001	10001	10001	10005	10001	10001	10005	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10001	10002	10001	10001	10002	10001	10001	10005	10001	10005	10001	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001
stmnt_status	11003	11001	11001	11001	11001	11003	11001	11001	11003	11003	11001	11001	11001	11003	11001	11001	11001	11003	11003	11003	11003	11001	11001	11003	11003	11001	11001	11003	11001	11003	11003	11003	11001	11001	11003	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11003	11001	11003	11001	11001	11001	11003	11003	11003	11003	11003	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	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
session_id	2005	1999	1999	1999	1999	1999	1999	1999	1999	1999	1999	1999	2001	1999	2001	2001	1999	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2003	2003	2001	2001	2001	2001	2003	2003	2001	2003	2003	2003	1997	1997	1997	1997	1997	1997	1997	2003	1995	1995	1995	1995	1995	1995	1995	1995	1995	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2005	2005	2005	2003	2005	2003	2005	2003	2005	2005	2005	2005	2007	2005	2005	2005	2007	2007	2007	2007	2007	2007	2007	2013	2015	2015	2013	2013	2013	2013	2013	2015	2013	2007	2007	2007	2009	2009	2007	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2011	2011	2007	2011	2011	2011	2011	2011	2011	2015	2013	2011	2013	2013	2011	2013	2015	2019	2019	2017	2015	2015	2015	2015	2015	2017	2017	2017	2017	2019	2019	2017	2019	2017	2019	2017	2017	2017	2019	2021	2019	2019	2021	2021	2021	2019	2021	2021	2021	2021	2021
user_id	*	*	*	*	*	*	*	TTHAM	*	*	LTHIBAUL	YBONILLA	CFLAGG	*	CFLAGG	LTHIBAUL	YBONILLA	*	*	*	KLARRY	PROBERTS	LTHIBAUL	*	*	LTHIBAUL	LTHIBAUL	CFLAGG	GPEREZ	*	*	COMPLETED	LTHIBAUL	LTHIBAUL	CFLAGG	LTHIBAUL	COMPLETED	GPEREZ	GPEREZ	BSMITH	BSMITH	BSMITH	BSMITH	BSMITH	BSMITH	BSMITH	BSMITH	BSMITH	BSMITH	BSMITH	BSMITH	BSMITH	BSMITH	BSMITH	BSMITH	BSMITH	COMPLETED	LTHIBAUL	COMPLETED	LTHIBAUL	COMPLETED	LTHIBAUL	LTHIBAUL	GPEREZ	COMPLETED	COMPLETED	EMCENTEE	COMPLETED	COMPLETED	CFLAGG	CFLAGG	LTHIBAUL	GPEREZ	LTHIBAUL	LTHIBAUL	COMPLETED	LTHIBAUL	LTHIBAUL	LTHIBAUL	LTHIBAUL	*	LTHIBAUL	LTHIBAUL	LTHIBAUL	CFLAGG	LTHIBAUL	LTHIBAUL	LTHIBAUL	LTHIBAUL	LTHIBAUL	LTHIBAUL	AGLADNEY	MPACHECO	AGLADNEY	AGLADNEY	ASAETERN	YRODRIGU	AGLADNEY	MPACHECO	SARRIAGA	ASAETERN	LTHIBAUL	LTHIBAUL	JGRISSUM	*	DMCCASTL	JGRISSUM	JGRISSUM	JGRISSUM	MGUERRA	JINGRAM	ASAETERN	ASAETERN	ASAETERN	ASAETERN	ASAETERN	AGLADNEY	DMCCASTL	YRODRIGU	JINGRAM	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	SARRIAGA	GKURIMOT	AGLADNEY	GKURIMOT	AGLADNEY	ASAETERN	ASAETERN	AGLADNEY	MKIRKHAM	VUKSTINA	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	CAFILER	AGLADNEY	GPEREZ	AGLADNEY	PBANFORD	MKIRKHAM	AGLADNEY	VUKSTINA	AGLADNEY	VUKSTINA	AGLADNEY	AGLADNEY	AGLADNEY	PBANFORD	MKIRKHAM	VUKSTINA	VUKSTINA	GTAYLOR	CAFILER	MKIRKHAM	GTAYLOR	MKIRKHAM	CHATRIDGE	CAFILER	MKIRKHAM	CAFILER
special_audit	11003	11001	11001	11001	11001	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11002	11003	11003	11002	11002	11003	11003	11003	11003	11003	11002	11003	11003	11003	11003	11003	11003	11001	11001	11001	11001	11001	11001	11001	11003	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	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003
fine_audit	11003	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	11001	11001	11001	11001	11001	11001	11001	11003	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	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11003	11003	11003	11003	11001	11003	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11003	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	11001	11003	11001	11001	11001	11003	11001	11001	11003	11001	11003	11001	11003
rpt_start	2005-04-27 00:00:00	1999-01-01 00:00:00	1999-07-01 00:00:00	1999-04-01 00:00:00	1999-04-01 00:00:00	2000-01-01 00:00:00	1999-10-01 00:00:00	2000-01-01 00:00:00	2000-07-01 00:00:00	2000-04-01 00:00:00	2000-04-01 00:00:00	2000-07-01 00:00:00	1900-01-01 00:00:00	2000-10-01 00:00:00	1900-01-01 00:00:00	2001-01-01 00:00:00	2000-10-01 00:00:00	2001-01-01 00:00:00	2001-07-01 00:00:00	2001-04-01 00:00:00	2001-07-01 00:00:00	2001-04-01 00:00:00	2001-10-01 00:00:00	2001-10-01 00:00:00	2002-01-01 00:00:00	2002-01-01 00:00:00	2002-04-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2002-07-01 00:00:00	2002-04-01 00:00:00	2002-10-01 00:00:00	2002-07-01 00:00:00	2003-01-01 00:00:00	1900-01-01 00:00:00	2002-10-01 00:00:00	2003-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1997-10-01 00:00:00	1998-10-01 00:00:00	1997-04-01 00:00:00	1997-07-01 00:00:00	1998-01-01 00:00:00	1998-07-01 00:00:00	1998-04-01 00:00:00	1900-01-01 00:00:00	1995-04-01 00:00:00	1996-01-01 00:00:00	1996-10-01 00:00:00	1995-01-01 00:00:00	1995-10-01 00:00:00	1996-07-01 00:00:00	1995-07-01 00:00:00	1996-07-01 00:00:00	1996-04-01 00:00:00	2003-04-01 00:00:00	2003-07-01 00:00:00	2003-10-01 00:00:00	2003-04-01 00:00:00	2003-07-01 00:00:00	2003-10-01 00:00:00	2004-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	2004-07-01 00:00:00	2005-01-07 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2004-07-01 00:00:00	1900-01-01 00:00:00	2004-10-01 00:00:00	2005-04-01 00:00:00	2004-10-01 00:00:00	2005-01-01 00:00:00	2005-07-01 00:00:00	2006-01-01 00:00:00	2005-10-01 00:00:00	2006-12-29 00:00:00	2006-04-01 00:00:00	2006-07-01 00:00:00	2006-10-01 00:00:00	1900-01-01 00:00:00	2007-04-01 00:00:00	2007-01-01 00:00:00	2007-10-01 00:00:00	2007-07-01 00:00:00	2007-01-01 00:00:00	2007-04-01 00:00:00	2013-04-01 00:00:00	2015-01-01 00:00:00	2015-04-01 00:00:00	2014-04-01 00:00:00	2013-10-01 00:00:00	1900-01-01 00:00:00	2013-07-01 00:00:00	2014-10-01 00:00:00	1900-01-01 00:00:00	2014-07-01 00:00:00	2008-01-01 00:00:00	2008-04-01 00:00:00	2008-07-01 00:00:00	2008-12-29 00:00:00	1900-01-01 00:00:00	2008-10-01 00:00:00	2009-01-01 00:00:00	2009-04-01 00:00:00	2009-07-01 00:00:00	2009-10-01 00:00:00	2010-01-01 00:00:00	2010-01-01 00:00:00	2010-04-01 00:00:00	2010-07-01 00:00:00	2010-07-01 00:00:00	2010-10-01 00:00:00	1900-01-01 00:00:00	2010-12-23 00:00:00	1900-01-01 00:00:00	2011-04-01 00:00:00	2011-01-01 00:00:00	2011-07-01 00:00:00	2011-10-01 00:00:00	2012-01-01 00:00:00	2012-04-01 00:00:00	2014-12-23 00:00:00	2012-12-21 00:00:00	2012-07-01 00:00:00	1900-01-01 00:00:00	2014-01-01 00:00:00	2012-10-01 00:00:00	2013-01-01 00:00:00	2015-07-01 00:00:00	2020-07-01 00:00:00	2019-01-01 00:00:00	2017-10-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-12-21 00:00:00	2017-01-01 00:00:00	1900-01-01 00:00:00	2017-04-01 00:00:00	2018-12-21 00:00:00	2020-04-01 00:00:00	2018-04-01 00:00:00	2019-07-01 00:00:00	2017-07-01 00:00:00	2019-04-01 00:00:00	2018-07-01 00:00:00	2018-10-01 00:00:00	2018-01-01 00:00:00	1900-01-01 00:00:00	2020-12-29 00:00:00	2019-10-01 00:00:00	2020-01-01 00:00:00	2021-04-01 00:00:00	2022-01-01 00:00:00	2021-01-01 00:00:00	2020-10-01 00:00:00	1900-01-01 00:00:00	2021-07-01 00:00:00	2022-04-01 00:00:00	2021-10-01 00:00:00	2022-07-01 00:00:00
rpt_end	2005-04-27 00:00:00	1999-03-31 00:00:00	1999-09-30 00:00:00	1999-06-30 00:00:00	1999-06-30 00:00:00	2000-03-31 00:00:00	1999-12-31 00:00:00	2000-03-31 00:00:00	2000-09-30 00:00:00	2000-06-30 00:00:00	2000-06-30 00:00:00	2000-09-30 00:00:00	1900-01-01 00:00:00	2000-12-31 00:00:00	1900-01-01 00:00:00	2001-03-31 00:00:00	2000-12-31 00:00:00	2001-03-31 00:00:00	2001-09-30 00:00:00	2001-06-30 00:00:00	2001-09-30 00:00:00	2001-06-30 00:00:00	2001-12-31 00:00:00	2001-12-31 00:00:00	2002-03-31 00:00:00	2002-03-31 00:00:00	2002-06-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2002-09-30 00:00:00	2002-06-30 00:00:00	2002-12-31 00:00:00	2002-09-30 00:00:00	2003-03-31 00:00:00	1900-01-01 00:00:00	2002-12-31 00:00:00	2003-03-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1997-12-31 00:00:00	1998-12-31 00:00:00	1997-06-30 00:00:00	1997-09-30 00:00:00	1998-03-31 00:00:00	1998-09-30 00:00:00	1998-06-30 00:00:00	1900-01-01 00:00:00	1995-06-30 00:00:00	1996-03-31 00:00:00	1996-12-31 00:00:00	1995-03-31 00:00:00	1995-12-31 00:00:00	1996-09-30 00:00:00	1995-09-30 00:00:00	1996-09-30 00:00:00	1996-06-30 00:00:00	2003-06-30 00:00:00	2003-09-30 00:00:00	2003-12-31 00:00:00	2003-06-30 00:00:00	2003-09-30 00:00:00	2003-12-31 00:00:00	2004-03-31 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	2004-09-30 00:00:00	2005-01-07 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2004-09-30 00:00:00	1900-01-01 00:00:00	2004-12-31 00:00:00	2005-06-30 00:00:00	2004-12-31 00:00:00	2005-03-31 00:00:00	2005-09-30 00:00:00	2006-03-31 00:00:00	2005-12-31 00:00:00	2006-12-29 00:00:00	2006-06-30 00:00:00	2006-09-30 00:00:00	2006-12-31 00:00:00	1900-01-01 00:00:00	2007-06-30 00:00:00	2007-03-31 00:00:00	2007-12-31 00:00:00	2007-09-30 00:00:00	2007-03-31 00:00:00	2007-06-30 00:00:00	2013-06-30 00:00:00	2015-03-31 00:00:00	2015-06-30 00:00:00	2014-06-30 00:00:00	2013-12-31 00:00:00	1900-01-01 00:00:00	2013-09-30 00:00:00	2014-12-31 00:00:00	1900-01-01 00:00:00	2014-09-30 00:00:00	2008-03-31 00:00:00	2008-06-30 00:00:00	2008-09-30 00:00:00	2008-12-29 00:00:00	1900-01-01 00:00:00	2008-12-31 00:00:00	2009-03-31 00:00:00	2009-06-30 00:00:00	2009-09-30 00:00:00	2009-12-31 00:00:00	2010-03-31 00:00:00	2010-03-31 00:00:00	2010-06-30 00:00:00	2010-09-30 00:00:00	2010-09-30 00:00:00	2010-12-31 00:00:00	1900-01-01 00:00:00	2010-12-23 00:00:00	1900-01-01 00:00:00	2011-06-30 00:00:00	2011-03-31 00:00:00	2011-09-30 00:00:00	2011-12-31 00:00:00	2012-03-31 00:00:00	2012-06-30 00:00:00	2014-12-23 00:00:00	2012-12-21 00:00:00	2012-09-30 00:00:00	1900-01-01 00:00:00	2014-03-31 00:00:00	2012-12-31 00:00:00	2013-03-31 00:00:00	2015-09-30 00:00:00	2020-09-30 00:00:00	2019-03-31 00:00:00	2017-12-31 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-12-21 00:00:00	2017-03-31 00:00:00	1900-01-01 00:00:00	2017-06-30 00:00:00	2018-12-21 00:00:00	2020-06-30 00:00:00	2018-06-30 00:00:00	2019-09-30 00:00:00	2017-09-30 00:00:00	2019-06-30 00:00:00	2018-09-30 00:00:00	2018-12-31 00:00:00	2018-03-31 00:00:00	1900-01-01 00:00:00	2020-12-29 00:00:00	2019-12-31 00:00:00	2020-03-31 00:00:00	2021-06-30 00:00:00	2022-03-31 00:00:00	2021-03-31 00:00:00	2020-12-31 00:00:00	1900-01-01 00:00:00	2021-09-30 00:00:00	2022-06-30 00:00:00	2021-12-31 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
filing_type	22001	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	22001	None	None	None	None	22001	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	22001	None	22001	None	22001	None	None	None	22001	22001	None	22001	22001	None	None	None	None	None	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	None	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	None	22001	22001	None	22001	22001	22001	22001	22001	None	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	None	22001	None	22001	22001	22001	22001	22001	22001	22001	22001	22001	None	22001	22001	22001	22001	22006	22006	22006	22006	22006	22006	22006	22006	22001	22006	None	22006	22001	22006	22006	22006	22006	22006	22006	22006	22006	None	22001	22006	22006	22006	22006	22006	22006	None	22006	22006	22006	22006

Table: filer_interests
filer_id	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198
session_id	1995	1999	2001	2003	1997	2009	2005	2007	2011	2013	2021	2019	2017	2015	2023
interest_cd	40306	40306	40306	40306	40306	40306	40306	40306	40306	40306	40306	40306	40306	40306	40306
effect_date	1995-01-01 00:00:00	1999-01-01 00:00:00	2001-01-01 00:00:00	2003-01-01 00:00:00	1997-04-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	2021-01-01 00:00:00	2019-01-01 00:00:00	2017-01-01 00:00:00	2015-01-01 00:00:00	2023-01-01 00:00:00

Table: filer_to_filer_type
filer_id	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198
filer_type	2	2	2	2	2	2	1	1	1	1	1	1	1	1	1	1
active	Y	Y	Y	N	N	Y	Y	Y	Y	T	Y	Y	Y	Y	Y	N
race	0	0	None	0	0	None	None	None	None	None	None	None	None	None	None	None
session_id	1999	2001	2003	1997	1995	2005	2007	2013	2011	2007	2009	2019	2015	2021	2017	2023
category	0	0	None	0	0	None	None	None	None	None	None	None	None	None	None	None
category_type	0	0	None	0	0	None	None	None	None	None	None	None	None	None	None	None
sub_category	0	0	None	0	0	None	None	None	None	None	None	None	None	None	None	None
effect_dt	1999-01-01 00:00:00	2001-01-01 00:00:00	2003-01-01 00:00:00	1997-04-01 00:00:00	1995-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	2008-11-30 00:00:00	2009-01-01 00:00:00	2019-01-01 00:00:00	2015-01-01 00:00:00	2021-01-01 00:00:00	2017-01-01 00:00:00	2023-01-01 00:00:00
sub_category_type	0	0	None	0	0	None	None	None	None	None	None	None	None	None	None	None
election_type	0	0	None	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	None
nyq_dt	None	None	None	None	None	2000-01-01 00:00:00	2000-01-01 00:00:00	None	None	2000-01-01 00:00:00	2000-01-01 00:00:00	None	None	None	None	None
party_cd	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
county_cd	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
district_cd	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None

Table: filer_xref
filer_id		1147198
xref_id		E24750
effect_dt		1999-12-08 00:00:00
migration_source		MASTER

Table: filername
xref_filer_id	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750	E24750
filer_id	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198
filer_type	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT	CLIENT
status	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE
effect_dt	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	2023-01-01 00:00:00	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	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION (CAPP)	CALIFORNIANS ALLIED FOR PATIENT PROTECTION (CAPP)	CALIFORNIANS ALLIED FOR PATIENT PROTECTION (CAPP)	CALIFORNIANS ALLIED FOR PATIENT PROTECTION (CAPP)	CALIFORNIANS ALLIED FOR PATIENT PROTECTION (CAPP)	CALIFORNIANS ALLIED FOR PATIENT PROTECTION (CAPP)	CALIFORNIANS ALLIED FOR PATIENT PROTECTION (CAPP)	CALIFORNIANS ALLIED FOR PATIENT PROTECTION (CAPP)	CALIFORNIANS ALLIED FOR PATIENT PROTECTION (CAPP)	CALIFORNIANS ALLIED FOR PATIENT PROTECTION (CAPP)	CALIFORNIANS ALLIED FOR PATIENT PROTECTION (CAPP)	CALIFORNIANS ALLIED FOR PATIENT PROTECTION (CAPP)	CALIFORNIANS ALLIED FOR PATIENT PROTECTION (CAPP)	CALIFORNIANS ALLIED FOR PATIENT PROTECTION (CAPP)	CALIFORNIANS ALLIED FOR PATIENT PROTECTION (CAPP)	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION
namf	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
namt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
nams	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
adr1	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
adr2	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
city	Sacramento	SACRAMENTO	Sacramento	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	Sacramento	SACRAMENTO	Sacramento	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	Sacramento	SACRAMENTO	Sacramento	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	Sacramento	SACRAMENTO	Sacramento	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	Sacramento	SACRAMENTO	Sacramento	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	Sacramento	SACRAMENTO	Sacramento	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	Sacramento	SACRAMENTO	Sacramento	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	Sacramento	SACRAMENTO	Sacramento	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	Sacramento	SACRAMENTO	Sacramento	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	Sacramento	SACRAMENTO	Sacramento	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	Sacramento	SACRAMENTO	Sacramento	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	Sacramento	SACRAMENTO	Sacramento	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	Sacramento	SACRAMENTO	Sacramento	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	Sacramento	SACRAMENTO	Sacramento	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	Sacramento	SACRAMENTO	Sacramento	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO
st	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA	CA
zip4	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	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	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992	9164487992
fax	None	None	None	9164480234	9164480234	9164480234	9164480234									None	None	None	9164480234	9164480234	9164480234	9164480234									None	None	None	9164480234	9164480234	9164480234	9164480234									None	None	None	9164480234	9164480234	9164480234	9164480234									None	None	None	9164480234	9164480234	9164480234	9164480234									None	None	None	9164480234	9164480234	9164480234	9164480234									None	None	None	9164480234	9164480234	9164480234	9164480234									None	None	None	9164480234	9164480234	9164480234	9164480234									None	None	None	9164480234	9164480234	9164480234	9164480234									None	None	None	9164480234	9164480234	9164480234	9164480234									None	None	None	9164480234	9164480234	9164480234	9164480234									None	None	None	9164480234	9164480234	9164480234	9164480234									None	None	None	9164480234	9164480234	9164480234	9164480234									None	None	None	9164480234	9164480234	9164480234	9164480234									None	None	None	9164480234	9164480234	9164480234	9164480234
email	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None

Table: filers
filer_id		1147198

Table: lobbying_chg_log
filer_id	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198
change_no	2	1	3	4	5	6	7	10	8	9	11	12	0
session_id	1999	1999	1999	1999	1999	1999	2003	2005	2003	2003	2007	2013	2013
log_dt	2000-08-08 00:00:00	2000-08-08 00:00:00	2000-11-09 00:00:00	2000-11-13 00:00:00	2000-11-13 00:00:00	2000-12-05 00:00:00	2003-12-17 00:00:00	2005-01-14 00:00:00	2004-02-06 00:00:00	2004-02-24 00:00:00	2009-01-20 00:00:00	2013-10-30 00:00:00	2013-07-29 00:00:00
filer_type	2	2	2	2	2	2	2	2	2	2	1	1	1
correction_flg	None	None	None	None	None	None	Y	None	None	None	None	None	Y
action	SET INACTIVE	SET INACTIVE	SET INACTIVE	SET ACTIVE	SET ACTIVE	SET ACTIVE	DELETED	SET ACTIVE	DELETED	DELETED	DELETED	DELETED	ADDED
attribute_changed	None	None	CLIENT	CLIENT	CLIENT	CLIENT	None	FIRM	LOBBYIST	FIRM	FIRM	FIRM	FIRM
ethics_dt	None	None	None	None	None	None	None	None	None	None	None	None	None
interests	None	None	None	None	None	None	None	None	None	None	None	None	None
filer_full_name	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION (CAPP)	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION (CAPP)	CALIFORNIANS ALLIED FOR PATIENT PROTECTION (CAPP)	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION	CALIFORNIANS ALLIED FOR PATIENT PROTECTION
filer_city	None	None	JEAN	BOSTON	SACRAMENTO	Grand Terrace	None	None	None	None	None	None	None
filer_st	None	None	NV	MA	CA	CA	None	None	None	None	None	None	None
filer_zip	None	None	89019	021163739	95864	92323	None	None	None	None	None	None	None
filer_phone	None	None	7023821212	6172666004	9164816300	9097838400	None	None	None	None	None	None	None
entity_type	3	3	3	3	3	3	3	3	4	3	3	3	3
entity_name	NIELSEN, MERKSAMER, PARRINELLO, MUELLER & NAYLOR LLP	NIELSEN, MERKSAMER, PARRINELLO, MUELLER & NAYLOR LLP	NIELSEN, MERKSAMER, PARRINELLO, MUELLER & NAYLOR LLP	ROBINSON & ASSOCIATES, INC., RICHARD	ROBINSON & ASSOCIATES, INC., RICHARD	NIELSEN, MERKSAMER, PARRINELLO, MUELLER & NAYLOR LLP	LEHMAN ENGLISH KELLY & O'KEEFE LLC	HIESTAND, APC, FRED J.	DANIELLE J. WALTERS	SLOAT HIGGINS JENSEN & ASSOCIATES	CARPENTER HAWKINS SIEVERS LLC	DI MARE VAN VLECK & BROWN, LLC	DI MARE VAN VLECK & BROWN, LLC
entity_city	None	None	None	None	None	None	None	None	None	None	None	None	None
entity_st	None	None	None	None	None	None	None	None	None	None	None	None	None
entity_zip	None	None	None	None	None	None	None	None	None	None	None	None	None
entity_phone	None	None	None	None	None	None	None	None	None	None	None	None	None
entity_id	1147313	1147313	1147313	1147420	1147420	1147313	1243836	1147247	1149614	1147635	1275439	1276403	1276403
responsible_officer	None	None	None	None	None	None	None	None	None	None	None	None	None
effect_dt	None	None	None	None	None	None	2003-12-30 00:00:00	2005-01-01 00:00:00	2004-02-01 00:00:00	2004-01-01 00:00:00	2008-11-30 00:00:00	2013-10-31 00:00:00	2013-08-01 00:00:00

Table: lobbyist_contributions1
filer_id	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198
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
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
contribution_dt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
recipient_name	FRIENDS OF KEITH OLBERG	DICK DICKERSON FOR STATE ASSEMBLY	FRIENDS OF ELAINE ALQUIST	HISPANIC REPUBLICAN CAUCUS	SENATE REPUBLICAN LEADERSHIP FUND (ROSS JOHNSON)	ED CHAVEZ FOR ASSEMBLY	CITIZENS FOR BOB MARGETT	MACHADO FOR SENATE 2000	WALLY KNOX FOR SENATE	STRICKLAND FOR ASSEMBLY	MACHADO FOR SENATE 2000	STRICKLAND FOR ASSEMBLY	COSTA FOR SENATE COMMITTEE	FRIENDS OF KERRY MAZZONI	WES CHESBRO FOR SENATE	DEMOCRATIC WOMEN'S LEADERSHIP FUND (DEDE ALPERT)	FRIENDS OF DENNIS CARDOZA
recipient_id	1071754	1071717	1053563	1076104	1072954	1075999	1075685	1075516	1075679	1069359	1075516	1069359	1072145	1061398	1071796	1073587	1069846
amount	1000	750	1000	1000	5000	228	1000	2500	788	2500	367	190	1000	500	1000	100	500

Table: lobbyist_contributions2
filer_id	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198
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
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
contribution_dt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
recipient_name	FRIENDS OF KEITH OLBERG	DICK DICKERSON FOR STATE ASSEMBLY	FRIENDS OF ELAINE ALQUIST	HISPANIC REPUBLICAN CAUCUS	SENATE REPUBLICAN LEADERSHIP FUND (ROSS JOHNSON)	ED CHAVEZ FOR ASSEMBLY	CITIZENS FOR BOB MARGETT	MACHADO FOR SENATE 2000	WALLY KNOX FOR SENATE	STRICKLAND FOR ASSEMBLY	MACHADO FOR SENATE 2000	STRICKLAND FOR ASSEMBLY	COSTA FOR SENATE COMMITTEE	FRIENDS OF KERRY MAZZONI	WES CHESBRO FOR SENATE	DEMOCRATIC WOMEN'S LEADERSHIP FUND (DEDE ALPERT)	FRIENDS OF DENNIS CARDOZA
recipient_id	1071754	1071717	1053563	1076104	1072954	1075999	1075685	1075516	1075679	1069359	1075516	1069359	1072145	1061398	1071796	1073587	1069846
amount	1000	750	1000	1000	5000	228	1000	2500	788	2500	367	190	1000	500	1000	100	500

Table: received_filings
filer_id	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198	1147198
filing_file_name	624491_0.cal	682106_0.cal	645414_0.cal	744747_0.cal	717593_0.cal	788207_0.cal	772954_0.cal	813834_0.cal	837381_0.cal	856067_0.cal	882119_0.cal	908720_0.cal	930236_0.cal	946323_0.cal	969077_0.cal	989483_0.cal	1012195_0.cal	1057765_0.cal	1080870_0.cal	107172.cal	107441.cal	107443.cal	107289.cal	1503391_0.cal	1394884_0.cal	133103.cal	1484138_1.cal	1484138_0.cal	1458131_0.cal	1449243_0.cal	1283096_0.cal	1261073_0.cal	1420466_0.cal	1261073_1.cal	1283096_1.cal	254371.cal	1293953_0.cal	1673748_0.cal	153017.cal	1729509_0.cal	1706046_0.cal	1587662_0.cal	1564009_0.cal	421850.cal	1618654_0.cal	1602574_0.cal	1776897_0.cal	1758944_0.cal	1654625_0.cal	1633049_0.cal	1993925_0.cal	1962191_0.cal	1974696_0.cal
received_date	2000-05-01 00:00:00	2000-10-31 00:00:00	2000-08-01 00:00:00	2001-04-27 00:00:00	2001-01-30 00:00:00	2001-10-22 00:00:00	2001-07-31 00:00:00	2002-01-31 00:00:00	2002-04-25 00:00:00	2002-07-31 00:00:00	2002-10-29 00:00:00	2003-01-29 00:00:00	2003-04-29 00:00:00	2003-07-30 00:00:00	2003-10-30 00:00:00	2004-01-30 00:00:00	2004-04-28 00:00:00	2004-10-29 00:00:00	2005-01-31 00:00:00	2005-04-28 00:00:00	2005-04-28 00:00:00	2005-04-28 00:00:00	2005-04-28 00:00:00	2010-07-26 00:00:00	2009-01-29 00:00:00	2008-07-20 00:00:00	2010-05-03 00:00:00	2010-04-29 00:00:00	2010-01-17 00:00:00	2009-10-22 00:00:00	2007-07-30 00:00:00	2007-04-27 00:00:00	2009-04-29 00:00:00	2007-09-22 00:00:00	2007-09-22 00:00:00	2007-10-22 00:00:00	2007-10-22 00:00:00	2012-07-23 00:00:00	2014-04-28 00:00:00	2013-01-21 00:00:00	2012-10-28 00:00:00	2011-04-21 00:00:00	2011-01-22 00:00:00	2014-01-19 00:00:00	2011-10-21 00:00:00	2011-07-23 00:00:00	2013-07-21 00:00:00	2013-04-17 00:00:00	2012-04-25 00:00:00	2012-01-27 00:00:00	2015-10-25 00:00:00	2015-04-26 00:00:00	2015-07-16 00:00:00
filing_directory	/usr/users/cafiler/disclose/ca99/cal	/usr/users/cafiler/disclose/ca99/cal	/usr/users/cafiler/disclose/ca99/cal	/usr/users/cafiler/disclose/ca99/cal	/usr/users/cafiler/disclose/ca99/cal	/usr/users/cafiler/disclose/ca99/cal	/usr/users/cafiler/disclose/ca99/cal	/usr/users/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/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/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/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal
filing_id	624491	682106	645414	744747	717593	788207	772954	813834	837381	856067	882119	908720	930236	946323	969077	989483	1012195	1057765	1080870	None	None	None	None	1503391	1394884	None	1484138	1484138	1458131	1449243	1283096	1261073	1420466	1261073	1283096	None	1293953	1673748	None	1729509	1706046	1587662	1564009	None	1618654	1602574	1776897	1758944	1654625	1633049	1993925	1962191	1974696
form_id	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	F635	None	None	None	None	F635	F635	None	F635	F635	F635	F635	F635	F635	F635	F635	F635	None	F635	F635	None	F635	F635	F635	F635	None	F635	F635	F635	F635	F635	F635	F635	F635	F635
receive_comment	Filing accepted, but but with warnings	Filing accepted, but with warnings	Filing accepted, but but with warnings	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing did not pass validation	Filing did not pass validation	Filing did not pass validation	Filing did not pass validation	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 passed validation, but failed DB constraints	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