OpenCalAccess

Filer ID: 1147430

Table: filer_address
filer_id	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430
adrid	1110659	1109083	2011861	2045895	2079565	2114270	2159491	2204842	2505862	2412576	2465857	2550262	2279183	2339721
effect_dt	1994-12-19 00:00:00	1999-01-01 00:00:00	2001-01-01 00:00:00	2003-01-01 00:00:00	2005-01-01 00:00:00	2007-01-01 00:00:00	2009-01-01 00:00:00	2011-01-01 00:00:00	2021-01-01 00:00:00	2017-01-01 00:00:00	2019-01-01 00:00:00	2023-01-01 00:00:00	2013-01-01 00:00:00	2015-01-01 00:00:00
add_type	7050	7050	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051
session_id	1995	1999	2001	2003	2005	2007	2009	2011	2021	2017	2019	2023	2013	2015

Table: filer_filings
filer_id	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430
filing_id	509408	504421	505132	505832	506138	506843	507144	504822	507413	507814	506415	508486	508751	509152	504148	508083	510043	505132	505412	506138	506415	508486	508751	507814	504822	505412	542038	504148	509152	507814	627710	611203	629118	648733	682511	653886	717893	709444	687967	706051	740661	752344	752361	746265	742921	725578	748362	772960	776706	786897	793029	815394	812576	807761	807055	836707	841970	890650	858921	881039	854947	916089	907549	928675	919082	933522	945869	963967	951712	961292	971908	963967	1011837	986294	971908	971908	990805	1008433	1032791	1015091	1028726	1020349	1011837	1041993	1041270	1063274	1069692	1075986	1078726	1083561	1069692	1101168	1108946	1108948	1057523	1101454	1100663	1062216	1115625	1107874	1069692	1069692	1069692	1109631	1129858	1149002	1164868	1188477	1209301	1224500	1224500	1259633	1246397	1236255	1269127	1282807	1224500	1224500	1262690	1262692	1294661	1276893	1779586	1980328	1965534	1871721	1800221	1721379	1806326	1935092	1941590	1953521	1911387	1304493	1309652	1327848	1224500	1341271	1327848	1345742	1376609	1387915	1387915	1394379	1407647	1407724	1387915	1420167	1425967	1433522	1433522	1447517	1462551	1484526	1502765	1501750	1387915	1537772	1540465	1387915	1555110	1559198	1555110	1597521	1571846	1588550	1605386	1635301	1622914	1656363	1679561	1823878	1721379	1814712	1921708	1919000	1707930	1743386	1721379	1738499	1845502	1844943	1721379	1721379	1850115	1850522	1841118	1738499	1765163	1996740	2198174	2319683	2443362	2394576	2377631	2569285	2381885	2209342	2418716	2242562	2008241	2037169	2058799	2099920	2113293	2128014	2124125	2109922	2155039	2133094	2172596	2349791	2275346	2487212	2553988	2590012	2191271	2469901	2371655	2113293	2621631	2531270	2671685	2602672	2581026	2702833	2640583	2745175
period_id	155	149	142	158	143	159	144	157	152	145	151	146	154	147	141	153	156	142	150	143	151	146	154	145	157	150	148	141	147	145	None	160	161	None	163	162	164	None	163	None	None	None	None	165	None	164	165	166	None	167	167	None	168	None	None	169	None	None	None	171	170	None	172	173	None	None	174	175	None	None	None	175	177	176	None	None	None	None	None	None	178	None	177	None	None	None	181	None	180	None	182	181	None	None	179	None	None	None	182	None	182	182	182	None	183	184	185	186	187	188	0	189	None	188	None	190	190	191	None	None	191	None	214	222	221	218	215	216	None	220	None	None	219	None	192	193	194	None	193	194	195	196	197	196	None	None	197	197	None	198	198	199	200	201	None	202	203	203	None	204	204	None	206	None	204	205	206	208	207	209	210	None	217	216	220	220	211	None	212	212	217	None	218	218	None	None	218	212	213	223	None	235	240	238	237	245	237	232	239	233	224	225	226	227	228	228	None	228	229	None	230	236	234	242	244	None	231	241	None	232	247	243	249	246	245	250	248	251
form_id	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F690	F690	F690	F690	F690	F690	F690	F690	F625	F625	F690	F690	F690	F605	F625	F625	F602	F625	F625	F625	F601	F625	F602	F605	F602	F602	F625	F605	F625	F625	F625	F625	F625	F625	F625	F625	F605	F605	F625	F625	F625	F625	F625	F625	F601	F625	F625	F625	F625	F625	F625	F625	F605	F625	F625	F625	F625	F625	F625	F625	F605	F625	F625	F625	F602	F625	F605	F605	F625	F601	F601	F625	F625	F601	F625	F601	F605	F625	F605	F605	F605	F625	F605	F601	F601	F601	F601	F625	F625	F625	F625	F625	F601	F601	F625	F601	F625	F605	F625	F601	F601	F605	F605	F625	F605	F625	F625	F625	F625	F625	F601	F605	F625	F601	F602	F625	F605	F625	F625	F601	F605	F625	F625	F625	F601	F601	F625	F601	F605	F601	F625	F605	F625	F625	F625	F625	F625	F605	F625	F601	F625	F605	F601	F601	F601	F601	F605	F625	F625	F625	F625	F625	F625	F625	F605	F601	F625	F601	F602	F625	F601	F601	F625	F625	F605	F601	F601	F605	F602	F602	F625	F625	F625	F605	F625	F625	F625	F601	F601	F625	F625	F625	F625	F625	F625	F625	F625	F601	F625	F602	F602	F625	F601	F625	F625	F625	F625	F625	F601	F625	F625	F601	F601	F625	F625	F625	F625	F625	F625	F625	F625
filing_sequence	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	1	1	1	1	1	1	0	0	1	1	2	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	1	2	0	0	0	0	0	0	1	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	2	3	4	0	0	0	0	0	0	0	1	0	0	0	0	0	2	3	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	4	0	1	0	0	0	1	0	0	0	2	0	0	1	0	0	0	0	0	0	3	0	0	4	0	0	1	0	0	0	0	0	0	0	0	0	2	0	0	0	0	0	0	0	0	0	4	3	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	1	0	0	0	0	0	0	0	0
filing_date	1998-10-26 00:00:00	1997-04-30 00:00:00	1995-07-31 00:00:00	1999-07-28 00:00:00	1995-10-31 00:00:00	1999-10-27 00:00:00	1996-01-31 00:00:00	1999-04-26 00:00:00	1998-01-30 00:00:00	1996-04-30 00:00:00	1997-10-31 00:00:00	1996-07-23 00:00:00	1998-07-17 00:00:00	1996-10-30 00:00:00	1995-04-28 00:00:00	1998-04-21 00:00:00	1999-01-27 00:00:00	1996-01-05 00:00:00	1997-10-31 00:00:00	1996-01-05 00:00:00	1998-01-23 00:00:00	1996-12-23 00:00:00	1998-10-26 00:00:00	1996-07-23 00:00:00	1999-06-21 00:00:00	1997-07-30 00:00:00	1997-01-31 00:00:00	1996-01-05 00:00:00	1996-12-23 00:00:00	1996-12-23 00:00:00	2000-05-17 00:00:00	2000-01-27 00:00:00	2000-04-26 00:00:00	2000-07-27 00:00:00	2000-10-31 00:00:00	2000-07-27 00:00:00	2001-01-30 00:00:00	2001-01-02 00:00:00	2000-10-31 00:00:00	2001-01-02 00:00:00	2001-04-03 00:00:00	2001-04-09 00:00:00	2001-04-03 00:00:00	2001-04-30 00:00:00	2001-04-09 00:00:00	2001-01-31 00:00:00	2001-04-30 00:00:00	2001-07-31 00:00:00	2001-07-31 00:00:00	2001-10-12 00:00:00	2001-10-30 00:00:00	2002-01-31 00:00:00	2002-01-30 00:00:00	2002-01-16 00:00:00	2002-01-11 00:00:00	2002-04-23 00:00:00	2002-04-30 00:00:00	2002-10-28 00:00:00	2002-07-31 00:00:00	2002-10-28 00:00:00	2002-07-30 00:00:00	2002-12-31 00:00:00	2003-01-28 00:00:00	2003-04-24 00:00:00	2003-01-30 00:00:00	2003-05-01 00:00:00	2003-07-29 00:00:00	2003-10-14 00:00:00	2003-07-31 00:00:00	2003-10-02 00:00:00	2003-10-30 00:00:00	2003-10-30 00:00:00	2004-04-27 00:00:00	2004-01-26 00:00:00	2003-10-30 00:00:00	2003-10-30 00:00:00	2004-01-29 00:00:00	2004-04-05 00:00:00	2004-07-30 00:00:00	2004-04-30 00:00:00	2004-07-29 00:00:00	2004-06-14 00:00:00	2004-05-11 00:00:00	2004-09-17 00:00:00	2004-09-10 00:00:00	2004-11-01 00:00:00	2005-01-04 00:00:00	2004-12-30 00:00:00	2005-01-28 00:00:00	2005-01-31 00:00:00	2005-04-19 00:00:00	2005-04-19 00:00:00	2005-05-27 00:00:00	2005-05-27 00:00:00	2004-10-29 00:00:00	2005-04-20 00:00:00	2005-04-15 00:00:00	2004-11-12 00:00:00	2005-07-27 00:00:00	2005-05-17 00:00:00	2005-05-16 00:00:00	2005-05-27 00:00:00	2005-06-08 00:00:00	2005-06-08 00:00:00	2005-10-24 00:00:00	2006-01-31 00:00:00	2006-04-25 00:00:00	2006-07-27 00:00:00	2006-10-20 00:00:00	2006-12-26 00:00:00	2007-04-25 00:00:00	2007-04-25 00:00:00	2006-12-26 00:00:00	2007-01-30 00:00:00	2007-05-23 00:00:00	2007-07-30 00:00:00	2007-05-22 00:00:00	2007-07-06 00:00:00	2007-04-27 00:00:00	2007-04-27 00:00:00	2007-10-24 00:00:00	2007-07-06 00:00:00	2013-07-29 00:00:00	2015-07-30 00:00:00	2015-04-30 00:00:00	2014-07-31 00:00:00	2013-10-31 00:00:00	2013-11-25 00:00:00	2013-11-26 00:00:00	2015-01-30 00:00:00	2014-12-30 00:00:00	2014-12-18 00:00:00	2014-10-31 00:00:00	2008-01-18 00:00:00	2008-01-30 00:00:00	2008-04-28 00:00:00	2008-06-17 00:00:00	2008-06-17 00:00:00	2008-07-24 00:00:00	2008-07-24 00:00:00	2008-10-30 00:00:00	2009-01-08 00:00:00	2009-01-30 00:00:00	2009-01-29 00:00:00	2009-01-08 00:00:00	2009-01-30 00:00:00	2009-03-24 00:00:00	2009-04-29 00:00:00	2009-03-24 00:00:00	2009-08-12 00:00:00	2009-07-24 00:00:00	2009-10-12 00:00:00	2010-01-28 00:00:00	2010-04-29 00:00:00	2010-07-22 00:00:00	2010-07-21 00:00:00	2010-07-21 00:00:00	2010-10-28 00:00:00	2010-10-28 00:00:00	2010-10-28 00:00:00	2010-12-29 00:00:00	2010-12-30 00:00:00	2011-06-03 00:00:00	2011-06-08 00:00:00	2011-01-31 00:00:00	2011-04-26 00:00:00	2011-07-28 00:00:00	2012-01-30 00:00:00	2011-10-31 00:00:00	2012-04-27 00:00:00	2012-07-31 00:00:00	2014-01-30 00:00:00	2014-01-30 00:00:00	2014-01-28 00:00:00	2014-12-30 00:00:00	2014-12-18 00:00:00	2012-10-30 00:00:00	2012-12-28 00:00:00	2012-12-28 00:00:00	2013-01-31 00:00:00	2014-04-30 00:00:00	2014-04-25 00:00:00	2014-05-01 00:00:00	2014-05-01 00:00:00	2014-05-05 00:00:00	2014-04-24 00:00:00	2014-04-24 00:00:00	2013-02-21 00:00:00	2013-04-30 00:00:00	2015-10-30 00:00:00	2017-12-11 00:00:00	2018-10-31 00:00:00	2020-01-31 00:00:00	2019-07-29 00:00:00	2019-04-25 00:00:00	2021-03-24 00:00:00	2019-04-30 00:00:00	2018-01-30 00:00:00	2019-10-30 00:00:00	2018-04-30 00:00:00	2016-01-27 00:00:00	2016-05-01 00:00:00	2016-07-26 00:00:00	2016-10-28 00:00:00	2016-12-22 00:00:00	2017-01-30 00:00:00	2016-12-08 00:00:00	2016-12-08 00:00:00	2017-04-27 00:00:00	2016-12-22 00:00:00	2017-07-27 00:00:00	2019-01-31 00:00:00	2018-07-31 00:00:00	2020-07-31 00:00:00	2021-02-01 00:00:00	2021-03-24 00:00:00	2017-10-27 00:00:00	2020-04-29 00:00:00	2019-02-19 00:00:00	2017-12-11 00:00:00	2021-10-28 00:00:00	2020-11-02 00:00:00	2022-04-27 00:00:00	2021-08-02 00:00:00	2021-04-30 00:00:00	2022-07-28 00:00:00	2022-01-28 00:00:00	2022-10-28 00:00:00
stmnt_type	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10005	10005	10005	10005	10001	10005	10001	10005	10005	10005	10005	10005	10005	10001	10005	10005	10005	10001	10005	10001	10005	10005	10001	10005	10005	10001	10005	10005	10005	10001	10001	10005	10001	10001	10005	10005	10001	10001	10005	10005	10005	10002	10001	10001	10006	10006	10005	10005	10005	10005	10001	10005	10002	10005	10005	10005	10001	10005	10001	10005	10002	10001	10005	10005	10001	10005	10005	10005	10001	10005	10002	10002	10002	10006	10001	10001	10001	10001	10001	10001	10002	10001	10005	10001	10005	10001	10002	10002	10005	10005	10001	10005	10001	10001	10001	10001	10001	10002	10006	10001	10005	10005	10001	10005	10001	10001	10002	10005	10002	10001	10001	10001	10002	10001	10005	10005	10002	10001	10006	10002	10001	10001	10001	10001	10006	10001	10002	10001	10006	10002	10001	10005	10002	10006	10001	10001	10001	10001	10001	10001	10001	10006	10002	10001	10001	10001	10001	10005	10001	10001	10001	10006	10002	10002	10005	10005	10001	10002	10001	10001	10005	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10005	10001	10001	10001	10001	10001	10005	10001	10001	10005	10002	10001	10001	10001	10001	10001	10001	10001	10001
stmnt_status	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11003	11001	11001	11003	11001	11001	11001	11003	11001	11001	11001	11003	11001	11003	11001	11001	11003	11001	11001	11003	11001	11001	11001	11003	11003	11003	11003	11003	11001	11001	11003	11003	11001	11001	11001	11003	11003	11003	11001	11001	11001	11001	11001	11001	11003	11001	11003	11001	11001	11001	11003	11001	11003	11001	11003	11001	11001	11001	11003	11001	11001	11001	11001	11001	11003	11003	11003	11001	11001	11001	11001	11001	11001	11003	11003	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	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11003	11003	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11003
session_id	1997	1997	1995	1999	1995	1999	1995	1999	1997	1995	1997	1995	1997	1995	1995	1997	1997	1995	1997	1995	1997	1995	1997	1995	1999	1997	1995	1995	1995	1995	1999	1999	1999	1999	1999	1999	1999	2001	1999	2001	2001	2001	2001	2001	2001	1999	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2003	2001	2003	2001	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2005	2005	2003	2003	2005	2005	2005	2005	2003	2005	2005	2003	2005	2005	2005	2005	2005	2005	2005	2005	2005	2005	2005	2007	2007	2007	2007	2005	2007	2007	2007	2007	2007	2007	2007	2007	2013	2015	2015	2013	2013	2013	2013	2013	2015	2015	2013	2007	2007	2007	2007	2007	2007	2007	2007	2009	2009	2007	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2011	2011	2011	2011	2009	2011	2011	2011	2011	2011	2011	2013	2013	2013	2015	2015	2011	2013	2013	2011	2013	2013	2013	2013	2013	2013	2013	2011	2013	2015	2017	2017	2019	2019	2019	2021	2019	2017	2019	2017	2015	2015	2015	2015	2017	2015	2017	2017	2017	2017	2017	2017	2017	2019	2019	2021	2017	2019	2019	2017	2021	2019	2021	2021	2021	2021	2021	2021
user_id	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	CFLAGG	TTHAM	GGILMORE	SARRIAGA	*	TTHAM	*	GGILMORE	MKIENG	TTHAM	CFLAGG	SARRIAGA	SARRIAGA	*	GPEREZ	MKIENG	CFLAGG	*	CFLAGG	*	YBONILLA	YBONILLA	*	CFLAGG	GPEREZ	*	YBONILLA	YBONILLA	YBONILLA	*	*	GKURIMOT	COMPLETED	COMPLETED	YBONILLA	YBONILLA	COMPLETED	COMPLETED	YBONILLA	GPEREZ	YBONILLA	COMPLETED	COMPLETED	COMPLETED	YBONILLA	YBONILLA	LTHIBAUL	GPEREZ	LTHIBAUL	LTHIBAUL	COMPLETED	SARRIAGA	COMPLETED	CFLAGG	CFLAGG	YRODRIGU	COMPLETED	PBANFORD	COMPLETED	YRODRIGU	*	YRODRIGU	CFLAGG	CFLAGG	COMPLETED	GPEREZ	CFLAGG	SARRIAGA	YRODRIGU	SARRIAGA	*	*	*	SARRIAGA	YRODRIGU	LTHIBAUL	LTHIBAUL	LTHIBAUL	LTHIBAUL	*	*	YRODRIGU	GPEREZ	YRODRIGU	SARRIAGA	YRODRIGU	*	*	GPEREZ	GPEREZ	YRODRIGU	JINGRAM	ASAETERN	AGLADNEY	AGLADNEY	ASAETERN	ASAETERN	YRODRIGU	YRODRIGU	AGLADNEY	SARRIAGA	GKURIMOT	ASAETERN	GPEREZ	YRODRIGU	LTHIBAUL	YRODRIGU	YRODRIGU	YRODRIGU	LTHIBAUL	MGUERRA	YRODRIGU	YRODRIGU	MGUERRA	SARRIAGA	SARRIAGA	YRODRIGU	MGUERRA	YRODRIGU	MGUERRA	MGUERRA	MGUERRA	MGUERRA	MGUERRA	YRODRIGU	MGUERRA	YRODRIGU	ASAETERN	YRODRIGU	YRODRIGU	YRODRIGU	DMCCASTL	YRODRIGU	YRODRIGU	ASAETERN	ASAETERN	ASAETERN	ASAETERN	ASAETERN	ASAETERN	JINGRAM	PBANFORD	PBANFORD	ASAETERN	SARRIAGA	CAFILER	ASAETERN	GKURIMOT	GKURIMOT	ASAETERN	ASAETERN	SMCCONNAN	CAFILER	CAFILER	SMCCONNAN	SARRIAGA	SARRIAGA	ASAETERN	ASAETERN	AGLADNEY	GPEREZ	AGLADNEY	AGLADNEY	AGLADNEY	CAFILER	SARRIAGA	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	GPEREZ	AGLADNEY	DWALKER	GPEREZ	AGLADNEY	GPEREZ	AGLADNEY	AGLADNEY	AGLADNEY	MKIRKHAM	CHARTRIDGE	SARRIAGA	AGLADNEY	MKIRKHAM	PBANFORD	GPEREZ	CHATRIDGE	MKIRKHAM	RATTIYEH	MKIRKHAM	CHATRIDGE	CAFILER	CHATRIDGE	CAFILER
special_audit	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11002	11003	11003	11003	11003	11002	11002	11002	11003	11003	11003	11003	11003	11002	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003
fine_audit	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	11003	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	11001	11003	11003	11003	11001	11003	11003	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	11003	11001	11001	11001	11001	11001	11003	11003	11003	11003	11003	11003	11001	11001	11001	11003	11001	11001	11001	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11003	11003	11001	11003	11001	11001	11001	11001	11001	11003	11001	11001	11001	11003	11001	11001	11001	11001	11001	11003	11001	11003
rpt_start	1998-07-01 00:00:00	1997-01-01 00:00:00	1995-04-01 00:00:00	1999-04-01 00:00:00	1995-07-01 00:00:00	1999-07-01 00:00:00	1995-10-01 00:00:00	1999-01-01 00:00:00	1997-10-01 00:00:00	1996-01-01 00:00:00	1997-07-01 00:00:00	1996-04-01 00:00:00	1998-04-01 00:00:00	1996-07-01 00:00:00	1995-01-01 00:00:00	1998-01-01 00:00:00	1998-10-01 00:00:00	1995-04-01 00:00:00	1997-04-01 00:00:00	1995-07-01 00:00:00	1997-07-01 00:00:00	1996-04-01 00:00:00	1998-04-01 00:00:00	1996-01-01 00:00:00	1999-01-01 00:00:00	1997-04-01 00:00:00	1996-10-01 00:00:00	1995-01-01 00:00:00	1996-07-01 00:00:00	1996-01-01 00:00:00	None	1999-10-01 00:00:00	2000-01-01 00:00:00	None	2000-07-01 00:00:00	2000-04-01 00:00:00	2000-10-01 00:00:00	1900-01-01 00:00:00	2000-07-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2001-01-01 00:00:00	1900-01-01 00:00:00	2000-10-01 00:00:00	2001-01-01 00:00:00	2001-04-01 00:00:00	2001-04-01 00:00:00	2001-07-01 00:00:00	2001-07-01 00:00:00	2001-10-01 00:00:00	2001-10-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2002-01-01 00:00:00	2002-01-01 00:00:00	2002-07-01 00:00:00	2002-04-01 00:00:00	2002-07-01 00:00:00	2002-04-01 00:00:00	1900-01-01 00:00:00	2002-10-01 00:00:00	2003-01-01 00:00:00	2002-10-01 00:00:00	2003-01-01 00:00:00	2003-04-01 00:00:00	2003-07-01 00:00:00	2003-04-01 00:00:00	1900-01-01 00:00:00	2003-07-01 00:00:00	2003-07-01 00:00:00	2004-01-01 00:00:00	2003-10-01 00:00:00	2003-07-01 00:00:00	2003-07-01 00:00:00	2003-10-01 00:00:00	1900-01-01 00:00:00	2004-04-01 00:00:00	2004-01-01 00:00:00	2004-04-01 00:00:00	1900-01-01 00:00:00	2004-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2004-07-01 00:00:00	2005-01-02 00:00:00	1900-01-01 00:00:00	2004-10-01 00:00:00	2004-10-01 00:00:00	2005-04-14 00:00:00	2005-01-01 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	1900-01-01 00:00:00	1900-01-01 00:00:00	2005-04-01 00:00:00	1900-01-01 00:00:00	2005-04-15 00:00:00	2005-05-16 00:00:00	2005-05-27 00:00:00	1900-01-01 00:00:00	2005-07-01 00:00:00	2005-10-01 00:00:00	2006-01-01 00:00:00	2006-04-01 00:00:00	2006-07-01 00:00:00	2006-12-20 00:00:00	0007-04-13 00:00:00	2007-01-01 00:00:00	1900-01-01 00:00:00	2006-10-01 00:00:00	1900-01-01 00:00:00	2007-04-01 00:00:00	2007-05-03 00:00:00	2007-07-03 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2007-07-01 00:00:00	1900-01-01 00:00:00	2013-04-01 00:00:00	2015-04-01 00:00:00	2015-01-01 00:00:00	2014-04-01 00:00:00	2013-07-01 00:00:00	2013-11-06 00:00:00	1900-01-01 00:00:00	2014-10-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2014-07-01 00:00:00	1900-01-01 00:00:00	2007-10-01 00:00:00	2008-01-01 00:00:00	2008-06-16 00:00:00	1900-01-01 00:00:00	2008-01-01 00:00:00	2008-04-01 00:00:00	2008-07-01 00:00:00	2008-11-29 00:00:00	2009-01-30 00:00:00	2008-10-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2009-03-20 00:00:00	2009-01-01 00:00:00	1900-01-01 00:00:00	2009-04-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	1900-01-01 00:00:00	2010-04-01 00:00:00	2010-07-20 00:00:00	2010-07-01 00:00:00	1900-01-01 00:00:00	2010-10-26 00:00:00	2010-12-14 00:00:00	1900-01-01 00:00:00	2011-05-27 00:00:00	1900-01-01 00:00:00	2010-10-01 00:00:00	2011-01-01 00:00:00	2011-04-01 00:00:00	2011-10-01 00:00:00	2011-07-01 00:00:00	2012-01-01 00:00:00	2012-04-01 00:00:00	1900-01-01 00:00:00	2014-01-23 00:00:00	2013-10-01 00:00:00	2014-11-18 00:00:00	2014-12-16 00:00:00	2012-07-01 00:00:00	1900-01-01 00:00:00	2012-11-26 00:00:00	2012-10-01 00:00:00	2014-01-01 00:00:00	1900-01-01 00:00:00	2014-04-30 00:00:00	2014-04-22 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2014-04-22 00:00:00	2012-10-01 00:00:00	2013-01-01 00:00:00	2015-07-01 00:00:00	1900-01-01 00:00:00	2018-07-01 00:00:00	2019-10-01 00:00:00	2019-04-01 00:00:00	2019-01-25 00:00:00	2021-03-03 00:00:00	2019-01-01 00:00:00	2017-10-01 00:00:00	2019-07-01 00:00:00	2018-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-12-21 00:00:00	2016-10-01 00:00:00	1900-01-01 00:00:00	2016-12-01 00:00:00	2017-01-01 00:00:00	1900-01-01 00:00:00	2017-04-01 00:00:00	2018-10-01 00:00:00	2018-04-01 00:00:00	2020-04-01 00:00:00	2020-10-01 00:00:00	1900-01-01 00:00:00	2017-07-01 00:00:00	2020-01-01 00:00:00	1900-01-01 00:00:00	2017-12-06 00:00:00	2021-07-01 00:00:00	2020-07-01 00:00:00	2022-01-01 00:00:00	2021-04-01 00:00:00	2021-01-01 00:00:00	2022-04-01 00:00:00	2021-10-01 00:00:00	2022-07-01 00:00:00
rpt_end	1998-09-30 00:00:00	1997-03-31 00:00:00	1995-06-30 00:00:00	1999-06-30 00:00:00	1995-09-30 00:00:00	1999-09-30 00:00:00	1995-12-31 00:00:00	1999-03-31 00:00:00	1997-12-31 00:00:00	1996-03-31 00:00:00	1997-09-30 00:00:00	1996-06-30 00:00:00	1998-06-30 00:00:00	1996-09-30 00:00:00	1995-03-31 00:00:00	1998-03-31 00:00:00	1998-12-31 00:00:00	1995-06-30 00:00:00	1997-06-30 00:00:00	1995-09-30 00:00:00	1997-09-30 00:00:00	1996-06-30 00:00:00	1998-06-30 00:00:00	1996-03-31 00:00:00	1999-03-31 00:00:00	1997-06-30 00:00:00	1996-12-31 00:00:00	1995-03-31 00:00:00	1996-09-30 00:00:00	1996-03-31 00:00:00	None	1999-12-31 00:00:00	2000-03-31 00:00:00	None	2000-09-30 00:00:00	2000-06-30 00:00:00	2000-12-31 00:00:00	1900-01-01 00:00:00	2000-09-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2001-03-31 00:00:00	1900-01-01 00:00:00	2000-12-31 00:00:00	2001-03-31 00:00:00	2001-06-30 00:00:00	2001-06-30 00:00:00	2001-09-30 00:00:00	2001-09-30 00:00:00	2001-12-31 00:00:00	2001-12-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2002-03-31 00:00:00	2002-03-31 00:00:00	2002-09-30 00:00:00	2002-06-30 00:00:00	2002-09-30 00:00:00	2002-06-30 00:00:00	1900-01-01 00:00:00	2002-12-31 00:00:00	2003-03-31 00:00:00	2002-12-31 00:00:00	2003-03-31 00:00:00	2003-06-30 00:00:00	2003-09-30 00:00:00	2003-06-30 00:00:00	1900-01-01 00:00:00	2003-09-30 00:00:00	2003-09-30 00:00:00	2004-03-31 00:00:00	2003-12-31 00:00:00	2003-09-30 00:00:00	2003-09-30 00:00:00	2003-12-31 00:00:00	1900-01-01 00:00:00	2004-06-30 00:00:00	2004-03-31 00:00:00	2004-06-30 00:00:00	1900-01-01 00:00:00	2004-03-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2004-09-30 00:00:00	2005-01-02 00:00:00	1900-01-01 00:00:00	2004-12-31 00:00:00	2004-12-31 00:00:00	2005-04-14 00:00:00	2005-03-31 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	1900-01-01 00:00:00	1900-01-01 00:00:00	2005-06-30 00:00:00	1900-01-01 00:00:00	2005-04-15 00:00:00	2005-05-16 00:00:00	2005-05-27 00:00:00	1900-01-01 00:00:00	2005-09-30 00:00:00	2005-12-31 00:00:00	2006-03-31 00:00:00	2006-06-30 00:00:00	2006-09-30 00:00:00	2006-12-20 00:00:00	0007-04-13 00:00:00	2007-03-31 00:00:00	1900-01-01 00:00:00	2006-12-31 00:00:00	1900-01-01 00:00:00	2007-06-30 00:00:00	2007-05-03 00:00:00	2007-07-03 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2007-09-30 00:00:00	1900-01-01 00:00:00	2013-06-30 00:00:00	2015-06-30 00:00:00	2015-03-31 00:00:00	2014-06-30 00:00:00	2013-09-30 00:00:00	2013-11-06 00:00:00	1900-01-01 00:00:00	2014-12-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2014-09-30 00:00:00	1900-01-01 00:00:00	2007-12-31 00:00:00	2008-03-31 00:00:00	2008-06-16 00:00:00	1900-01-01 00:00:00	2008-03-31 00:00:00	2008-06-30 00:00:00	2008-09-30 00:00:00	2008-11-29 00:00:00	2009-01-30 00:00:00	2008-12-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2009-03-20 00:00:00	2009-03-31 00:00:00	1900-01-01 00:00:00	2009-06-30 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	1900-01-01 00:00:00	2010-06-30 00:00:00	2010-07-20 00:00:00	2010-09-30 00:00:00	1900-01-01 00:00:00	2010-10-26 00:00:00	2010-12-14 00:00:00	1900-01-01 00:00:00	2011-05-27 00:00:00	1900-01-01 00:00:00	2010-12-31 00:00:00	2011-03-31 00:00:00	2011-06-30 00:00:00	2011-12-31 00:00:00	2011-09-30 00:00:00	2012-03-31 00:00:00	2012-06-30 00:00:00	1900-01-01 00:00:00	2014-01-23 00:00:00	2013-12-31 00:00:00	2014-11-18 00:00:00	2014-12-16 00:00:00	2012-09-30 00:00:00	1900-01-01 00:00:00	2012-11-26 00:00:00	2012-12-31 00:00:00	2014-03-31 00:00:00	1900-01-01 00:00:00	2014-04-30 00:00:00	2014-04-22 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2014-04-22 00:00:00	2012-12-31 00:00:00	2013-03-31 00:00:00	2015-09-30 00:00:00	1900-01-01 00:00:00	2018-09-30 00:00:00	2019-12-31 00:00:00	2019-06-30 00:00:00	2019-01-25 00:00:00	2021-03-03 00:00:00	2019-03-31 00:00:00	2017-12-31 00:00:00	2019-09-30 00:00:00	2018-03-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-21 00:00:00	2016-12-31 00:00:00	1900-01-01 00:00:00	2016-12-01 00:00:00	2017-03-31 00:00:00	1900-01-01 00:00:00	2017-06-30 00:00:00	2018-12-31 00:00:00	2018-06-30 00:00:00	2020-06-30 00:00:00	2020-12-31 00:00:00	1900-01-01 00:00:00	2017-09-30 00:00:00	2020-03-31 00:00:00	1900-01-01 00:00:00	2017-12-06 00:00:00	2021-09-30 00:00:00	2020-09-30 00:00:00	2022-03-31 00:00:00	2021-06-30 00:00:00	2021-03-31 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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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	22001	None	None	22001	22001	None	None	None	22001	22001	22001	None	None	None	None	None	None	22001	None	22001	None	None	None	22001	None	22001	None	22001	22001	None	None	22001	None	None	None	22001	None	22001	22001	22001	None	22001	22001	22001	22001	22001	22001	22001	22001	None	22001	None	22001	22001	22001	None	None	22001	None	22001	22001	22001	22001	22001	22001	None	22001	None	None	22001	None	22001	22001	22001	None	22001	22001	22001	22001	22001	22001	None	None	22001	22001	None	22001	22001	22001	22001	22001	None	22001	22001	22001	None	22001	22001	None	22001	None	22001	22001	22001	22001	22001	22001	22001	None	22001	22001	22001	22001	22001	None	22001	22001	22001	None	22001	22001	None	None	22001	22001	22001	22001	None	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	22001	None	22001	22001	None	22001	22001	22001	22001	22001	None	22001	22001	None	22001	22001	22001	22001	22001	22001	22001	22001	22001

Table: filer_to_filer_type
filer_id	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430
filer_type	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3
active	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	N
race	0	0	0	0	None	None	None	None	None	None	None	None	None	None	None
session_id	1995	1999	1997	2001	2003	2005	2007	2011	2013	2009	2021	2015	2017	2019	2023
category	0	0	0	0	None	None	None	None	None	None	None	None	None	None	None
category_type	0	0	0	0	None	None	None	None	None	None	None	None	None	None	None
sub_category	0	0	0	0	None	None	None	None	None	None	None	None	None	None	None
effect_dt	1994-12-19 00:00:00	1999-01-01 00:00:00	1997-01-01 00:00:00	2001-01-01 00:00:00	2003-01-01 00:00:00	2005-01-01 00:00:00	2007-01-01 00:00:00	2011-01-01 00:00:00	2013-01-01 00:00:00	2009-01-01 00:00:00	2021-01-01 00:00:00	2015-01-01 00:00:00	2017-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-07-01 00:00:00	2000-07-01 00:00:00	None	None	None	None	None	None	None	None
party_cd	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
county_cd	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
district_cd	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None

Table: filer_xref
filer_id		1147430
xref_id		F23923
effect_dt		1999-12-08 00:00:00
migration_source		MASTER

Table: filername
xref_filer_id	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923	F23923
filer_id	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430
filer_type	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM
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
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
naml	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES
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
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
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
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
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
city	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	CARMICHAEL	CARMICHAEL	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	CARMICHAEL	CARMICHAEL	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	CARMICHAEL	CARMICHAEL	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	CARMICHAEL	CARMICHAEL	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	CARMICHAEL	CARMICHAEL	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	CARMICHAEL	CARMICHAEL	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	CARMICHAEL	CARMICHAEL	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	CARMICHAEL	CARMICHAEL	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	CARMICHAEL	CARMICHAEL	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	CARMICHAEL	CARMICHAEL	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	CARMICHAEL	CARMICHAEL	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	CARMICHAEL	CARMICHAEL
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
zip4	958146518	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95608	95608	958146518	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95608	95608	958146518	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95608	95608	958146518	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95608	95608	958146518	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95608	95608	958146518	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95608	95608	958146518	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95608	95608	958146518	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95608	95608	958146518	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95608	95608	958146518	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95608	95608	958146518	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95608	95608	958146518	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95814	95608	95608
phon	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9169524172	9169524172	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9169524172	9169524172	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9169524172	9169524172	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9169524172	9169524172	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9169524172	9169524172	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9169524172	9169524172	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9169524172	9169524172	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9169524172	9169524172	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9169524172	9169524172	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9169524172	9169524172	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9169524172	9169524172	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9164471191	9169524172	9169524172
fax	None	None	9164470339	9164470339	9164470339	9164470339	9164470339	9164470339	9164470339	9164470339					None	None	9164470339	9164470339	9164470339	9164470339	9164470339	9164470339	9164470339	9164470339					None	None	9164470339	9164470339	9164470339	9164470339	9164470339	9164470339	9164470339	9164470339					None	None	9164470339	9164470339	9164470339	9164470339	9164470339	9164470339	9164470339	9164470339					None	None	9164470339	9164470339	9164470339	9164470339	9164470339	9164470339	9164470339	9164470339					None	None	9164470339	9164470339	9164470339	9164470339	9164470339	9164470339	9164470339	9164470339					None	None	9164470339	9164470339	9164470339	9164470339	9164470339	9164470339	9164470339	9164470339					None	None	9164470339	9164470339	9164470339	9164470339	9164470339	9164470339	9164470339	9164470339					None	None	9164470339	9164470339	9164470339	9164470339	9164470339	9164470339	9164470339	9164470339					None	None	9164470339	9164470339	9164470339	9164470339	9164470339	9164470339	9164470339	9164470339					None	None	9164470339	9164470339	9164470339	9164470339	9164470339	9164470339	9164470339	9164470339					None	None	9164470339	9164470339	9164470339	9164470339	9164470339	9164470339	9164470339	9164470339
email	None	None	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	None	None	[email protected]	[email protected]	None	None	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	None	None	[email protected]	[email protected]	None	None	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	None	None	[email protected]	[email protected]	None	None	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	None	None	[email protected]	[email protected]	None	None	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	None	None	[email protected]	[email protected]	None	None	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	None	None	[email protected]	[email protected]	None	None	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	None	None	[email protected]	[email protected]	None	None	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	None	None	[email protected]	[email protected]	None	None	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	None	None	[email protected]	[email protected]	None	None	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	None	None	[email protected]	[email protected]	None	None	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	None	None	[email protected]	[email protected]	None	None	[email protected]	[email protected]	[email protected]	None	[email protected]	[email protected]	[email protected]	[email protected]	None	None	[email protected]	[email protected]

Table: filers
filer_id		1147430

Table: lobbying_chg_log
filer_id	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430
change_no	2	1	3	5	6	9	0	7	11	13	12	14	10	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30
session_id	1999	1999	2001	1999	1999	2001	2001	2001	2003	2003	2003	2003	2003	2005	2005	2007	2007	2007	2007	2013	2013	2017	2019	2019	2019	2019	2019	2019	2019
log_dt	2000-07-20 00:00:00	2000-07-12 00:00:00	2001-04-03 00:00:00	2001-04-12 00:00:00	2001-07-03 00:00:00	2002-01-16 00:00:00	2002-01-11 00:00:00	2001-04-09 00:00:00	2003-10-02 00:00:00	2004-09-14 00:00:00	2004-09-10 00:00:00	2004-09-17 00:00:00	2004-04-05 00:00:00	2005-04-15 00:00:00	2005-05-27 00:00:00	2007-04-27 00:00:00	2007-07-06 00:00:00	2008-01-18 00:00:00	2008-06-17 00:00:00	2014-04-25 00:00:00	2014-05-05 00:00:00	2017-12-11 00:00:00	2019-02-19 00:00:00	2019-02-19 00:00:00	2019-02-19 00:00:00	2019-02-19 00:00:00	2019-02-19 00:00:00	2019-02-19 00:00:00	2019-02-19 00:00:00
filer_type	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3
correction_flg	None	None	Y	None	None	Y	Y	Y	Y	None	None	None	None	Y	None	Y	Y	Y	Y	None	None	Y	None	None	None	None	None	None	None
action	CHANGED	DELETED	ADDED	CHANGED	CHANGED	DELETED	NEW	ADDED	NEW	DELETED	DELETED	DELETED	SET ACTIVE	NEW	DELETED	ADDED	DELETED	DELETED	ADDED	DELETED	DELETED	ADDED	SET ACTIVE	SET ACTIVE	SET ACTIVE	SET ACTIVE	SET ACTIVE	SET ACTIVE	SET ACTIVE
attribute_changed	ADDRESS AND PHONE	CLIENT	EMPLOYER	ADDRESS	None	EMPLOYER	LOBBYIST	EMPLOYER	None	FIRM	CLIENT	CLIENT	CLIENT	None	CLIENT	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	LOBBYIST	CLIENT	EMPLOYER	None	LOBBYIST	LOBBYIST	LOBBYIST	CLIENT		CLIENT
ethics_dt	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
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
filer_full_name	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES	MATTOS & ASSOCIATES
filer_city	None	None	None	None	None	None	None	SACRAMENTO	SACRAMENTO	None	None	None	None	None	None	None	None	None	None	None	None	SACRAMENTO	None	None	None	None	None	None	None
filer_st	None	None	None	None	None	None	None	CA	CA	None	None	None	None	None	None	None	None	None	None	None	None	CA	None	None	None	None	None	None	None
filer_zip	None	None	None	None	None	None	None	958146518	95814	None	None	None	None	None	None	None	None	None	None	None	None	95814	None	None	None	None	None	None	None
filer_phone	None	None	None	None	None	None	None	9164471191	9164471191	None	None	None	None	None	None	None	None	None	None	None	None	9164471191	None	None	None	None	None	None	None
entity_type	1	1	2	1	1	2	4	2	2	3	1	1	1	2	1	2	2	2	2	4	1	2	20	4	4	4	1	3	1
entity_name	CALIFORNIA ASSOCIATION OF LICENSED REPOSSESSORS	CALIFORNIA PREMIUM FINANCE ASSOCIATION	ASSOCIATION OF CALIFORNIA CARTRIDGE REMANUFACTURERS	ASSOCIATION OF CALIFORNIA CARTRIDGE REMANUFACTURERS	COALITION OF CALIFORNIA HOME INSPECTORS	INTERNATIONAL WINDOW FILM ASSOCIATION	DENISE M. DUNCAN	INTERNATIONAL WINDOW FILM ASSOCIATION	VERICOM TECHNOLOGIES	DCK ADVOCATES, INC.	VERICOM TECHNOLOGIES	INTERNATIONAL IMAGING TECHNOLOGY COUNCIL	SURFACE TECHNOLOGY ASSOCIATION	TROVER SOLUTIONS, INC.	TROVER SOLUTIONS, INC.	BONNIE J. ADDARIO LUNG CANCER FOUNDATION; THE	SURFACE TECHNOLOGY ASSOCIATION (STA)	LUMBER ASSOCIATION OF CALIFORNIA & NEVADA (LACN)	INSTITUTE OF MEDICAL EDUCATION	DENISE M. DUNCAN	EVERGREEN HOLDINGS, INC.	TREX COMPANY, INC.	PRESIDENT DEBORAH MATTOS	MATTOS, DEBORAH	DEBORAH MATTOS	DEBORAH MATTOS	SOUTHERN CALIFORNIA UNIVERSITY OF HEALTH SCIENCES (SCUHS)	None	SOUTHERN CALIFORNIA UNIVERSITY OF HEALTH SCIENCES (SCUHS)
entity_city	FRESNO	None	None	IRVINE	SAN DIEGO	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	CA	None	None	CA	CA	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
entity_zip	93722	None	None	926122621	921164039	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	9164465165	None	None	9492258233	6194913031	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	1143173	1146225	1146245	1146245	1144630	1234507	1241846	None	None	1147713	1259159	1252516	1145678	1276326	1276326	1297701	1145678	1145208	1306118	1241846	1145920	None	1158506	1148107	1148107	1148107	1223595	0	1223595
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
effect_dt	None	None	2001-04-02 00:00:00	None	None	2001-12-31 00:00:00	2002-01-07 00:00:00	2001-04-06 00:00:00	2003-10-01 00:00:00	2004-09-30 00:00:00	2004-06-29 00:00:00	2004-06-29 00:00:00	2004-04-01 00:00:00	2005-04-15 00:00:00	2005-05-27 00:00:00	2007-04-23 00:00:00	2007-06-30 00:00:00	2007-12-31 00:00:00	2008-06-10 00:00:00	2014-04-22 00:00:00	2014-03-31 00:00:00	2017-12-06 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00	2019-01-01 00:00:00

Table: received_filings
filer_id	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430	1147430
filing_file_name	15212.cal	15673.cal	15798.cal	14803.cal	14834.cal	15152.cal	682511_0.cal	32350.cal	32477.cal	32209.cal	32326.cal	32260.cal	32375.cal	32554.cal	32528.cal	746265_0.cal	717893_0.cal	772737_0.cal	786897_0.cal	772960_0.cal	812576_0.cal	836707_0.cal	854947_0.cal	881039_0.cal	907549_0.cal	928675_0.cal	945869_0.cal	963967_0.cal	986294_0.cal	963967_1.cal	1011837_0.cal	1011837_1.cal	1028726_0.cal	1057523_0.cal	1078726_0.cal	397929.cal	1101168_0.cal	397882.cal	58138.cal	1115625_0.cal	1129858_0.cal	1149002_0.cal	1164868_0.cal	1188477_0.cal	1209301_0.cal	1327848_0.cal	1501750_0.cal	1394379_0.cal	1327848_1.cal	1345742_0.cal	1484526_0.cal	1433522_1.cal	1447517_0.cal	1462551_0.cal	196617.cal	222392.cal	222351.cal	1236255_0.cal	240475.cal	1259633_0.cal	1282807_0.cal	1420167_0.cal	1433522_0.cal	1294661_0.cal	1376609_0.cal	1309652_0.cal	1845502_0.cal	1738499_0.cal	1738499_1.cal	1679561_0.cal	1537772_0.cal	1588550_0.cal	1571846_0.cal	1814712_0.cal	1605386_0.cal	1800221_0.cal	1779586_0.cal	1765163_0.cal	1656363_0.cal	1622914_0.cal	1635301_0.cal	1707930_0.cal	1871721_0.cal	1965534_0.cal	1980328_0.cal	2155039_0.cal	2128014_0.cal	499869.cal	2058799_0.cal	1996740_0.cal	2008241_0.cal	499829.cal	2099920_0.cal	1911387_0.cal	2037169_0.cal	1935092_0.cal	2172596_0.cal	2319683_0.cal	2209342_0.cal	382774.cal	2242562_0.cal	2349791_0.cal	2394576_0.cal	2418716_0.cal	2275346_0.cal	2487212_0.cal	2381885_0.cal	2443362_0.cal	2191271_0.cal	2469901_0.cal	116217.cal	302083.cal	2671685_0.cal	2745175_0.cal	2581026_0.cal	2702833_0.cal	2640583_0.cal	2602672_0.cal	2621631_0.cal	2553988_0.cal	2531270_0.cal
received_date	2000-10-30 00:00:00	2000-10-30 00:00:00	2000-10-30 00:00:00	2000-10-30 00:00:00	2000-10-30 00:00:00	2000-10-30 00:00:00	2000-10-31 00:00:00	2001-01-29 00:00:00	2001-01-29 00:00:00	2001-01-29 00:00:00	2001-01-29 00:00:00	2001-01-29 00:00:00	2001-01-29 00:00:00	2001-01-29 00:00:00	2001-01-29 00:00:00	2001-04-30 00:00:00	2001-01-30 00:00:00	2001-07-31 00:00:00	2001-10-12 00:00:00	2001-07-31 00:00:00	2002-01-30 00:00:00	2002-04-23 00:00:00	2002-07-30 00:00:00	2002-10-28 00:00:00	2003-01-28 00:00:00	2003-04-24 00:00:00	2003-07-29 00:00:00	2003-10-14 00:00:00	2004-01-26 00:00:00	2003-10-30 00:00:00	2004-04-27 00:00:00	2004-05-11 00:00:00	2004-07-29 00:00:00	2004-10-29 00:00:00	2005-01-28 00:00:00	2005-04-19 00:00:00	2005-04-19 00:00:00	2005-04-19 00:00:00	2005-05-16 00:00:00	2005-07-27 00:00:00	2005-10-24 00:00:00	2006-01-31 00:00:00	2006-04-25 00:00:00	2006-07-27 00:00:00	2006-10-20 00:00:00	2008-04-28 00:00:00	2010-07-21 00:00:00	2009-01-29 00:00:00	2008-07-24 00:00:00	2008-07-24 00:00:00	2010-04-29 00:00:00	2009-08-12 00:00:00	2009-10-12 00:00:00	2010-01-28 00:00:00	2009-10-08 00:00:00	2007-01-16 00:00:00	2007-01-16 00:00:00	2007-01-30 00:00:00	2007-01-17 00:00:00	2007-04-25 00:00:00	2007-07-30 00:00:00	2009-04-29 00:00:00	2009-07-24 00:00:00	2007-10-24 00:00:00	2008-10-30 00:00:00	2008-01-30 00:00:00	2014-04-30 00:00:00	2013-01-31 00:00:00	2013-02-21 00:00:00	2012-07-31 00:00:00	2010-10-28 00:00:00	2011-04-26 00:00:00	2011-01-31 00:00:00	2014-01-28 00:00:00	2011-07-28 00:00:00	2013-10-31 00:00:00	2013-07-29 00:00:00	2013-04-30 00:00:00	2012-04-27 00:00:00	2011-10-31 00:00:00	2012-01-30 00:00:00	2012-10-30 00:00:00	2014-07-31 00:00:00	2015-04-30 00:00:00	2015-07-30 00:00:00	2017-04-27 00:00:00	2017-01-30 00:00:00	2017-04-13 00:00:00	2016-07-26 00:00:00	2015-10-30 00:00:00	2016-01-27 00:00:00	2017-04-13 00:00:00	2016-10-28 00:00:00	2014-10-31 00:00:00	2016-05-01 00:00:00	2015-01-30 00:00:00	2017-07-27 00:00:00	2018-10-31 00:00:00	2018-01-30 00:00:00	2019-04-25 00:00:00	2018-04-30 00:00:00	2019-01-31 00:00:00	2019-07-29 00:00:00	2019-10-30 00:00:00	2018-07-31 00:00:00	2020-07-31 00:00:00	2019-04-30 00:00:00	2020-01-31 00:00:00	2017-10-27 00:00:00	2020-04-29 00:00:00	2017-12-11 00:00:00	2022-05-02 00:00:00	2022-04-27 00:00:00	2022-10-28 00:00:00	2021-04-30 00:00:00	2022-07-28 00:00:00	2022-01-28 00:00:00	2021-08-02 00:00:00	2021-10-28 00:00:00	2021-02-01 00:00:00	2020-11-02 00:00:00
filing_directory	/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/temp	/usr/users/cafiler/disclose/ca99/temp	/usr/users/cafiler/disclose/ca99/temp	/usr/users/cafiler/disclose/ca99/cal	/usr/users/cafiler/disclose/ca99/cal	/usr/users/cafiler/disclose/ca99/cal	/usr/users/cafiler/disclose/ca99/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/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/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/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/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	/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/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/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
filing_id	None	None	None	None	None	None	682511	None	None	None	None	None	None	None	None	746265	717893	772737	786897	772960	812576	836707	854947	881039	907549	928675	945869	963967	986294	963967	1011837	1011837	1028726	1057523	1078726	None	1101168	None	None	1115625	1129858	1149002	1164868	1188477	1209301	1327848	1501750	1394379	1327848	1345742	1484526	1433522	1447517	1462551	None	None	None	1236255	None	1259633	1282807	1420167	1433522	1294661	1376609	1309652	1845502	1738499	1738499	1679561	1537772	1588550	1571846	1814712	1605386	1800221	1779586	1765163	1656363	1622914	1635301	1707930	1871721	1965534	1980328	2155039	2128014	None	2058799	1996740	2008241	None	2099920	1911387	2037169	1935092	2172596	2319683	2209342	None	2242562	2349791	2394576	2418716	2275346	2487212	2381885	2443362	2191271	2469901	None	None	2671685	2745175	2581026	2702833	2640583	2602672	2621631	2553988	2531270
form_id	None	None	None	None	None	None	F625	None	None	None	None	None	None	None	None	F625	F625	F615	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	None	F625	None	None	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	None	None	None	F625	None	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	None	F625	F625	F625	None	F625	F625	F625	F625	F625	F625	F625	None	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	None	None	F625	F625	F625	F625	F625	F625	F625	F625	F625
receive_comment	Filing did not pass validation	Filing did not pass validation	Filing did not pass validation	Filing did not pass validation	Filing did not pass validation	Filing did not pass validation	Filing accepted, but with warnings	Filing did not pass validation	Filing did not pass validation	Filing did not pass validation	Filing did not pass validation	Filing did not pass validation	Filing did not pass validation	Filing did not pass validation	Filing did not pass validation	Filing accepted, but with warnings	Filing accepted, but with warnings	Filing accepted	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 accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing did not pass validation	Filing accepted	Filing did not pass validation	Filing did not pass validation	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 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	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 did not pass validation	Filing accepted	Filing accepted	Filing accepted	Filing did not pass validation	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 accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted