OpenCalAccess

Filer ID: 1147477

Table: filer_address
filer_id	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477
adrid	1108857	2032582	2042169	2079045	2114420	2130374	2159270	2204624	2412291	2549199	2469428	2279127	2339432	2506949
effect_dt	1999-01-01 00:00:00	2002-06-07 00:00:00	2003-01-01 00:00:00	2005-01-01 00:00:00	2007-01-01 00:00:00	2007-11-08 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	2019-01-01 00:00:00	2013-01-01 00:00:00	2015-01-01 00:00:00	2021-01-01 00:00:00
add_type	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051	7051
session_id	1999	2001	2003	2005	2007	2007	2009	2011	2017	2023	2019	2013	2015	2021

Table: filer_filings
filer_id	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477
filing_id	1103684	509921	505615	505252	507944	506012	507016	506621	507692	504019	509282	505002	507016	509031	509921	508366	508617	507692	504262	504607	506263	508366	504262	508617	509282	509031	507265	508366	509685	629058	620174	641264	658411	714976	688474	721559	734655	782282	852034	856434	847654	849374	847820	847916	851304	851315	869738	851743	852034	890653	877336	881007	909752	897726	908589	898172	907311	927160	927169	927171	931359	945888	932359	923718	923719	945161	951270	972524	989451	968837	1011541	987764	987767	1010778	1010782	1012206	1023088	1031435	1027971	1070777	1078134	1039862	1055928	1062889	1055933	1102965	1078244	1091200	1102965	1112942	1085005	1112911	1128548	1141843	1162724	1183135	1207887	1224484	1223278	1228138	1239921	1256899	1276223	1303694	1292438	1292438	1223278	1207887	1183135	1298928	1775135	1961953	1918419	1970798	1862868	1809677	1717547	1790748	1792901	1918419	1959202	1946280	1223278	1317864	1310124	1323593	1342899	1342249	1365853	1387598	1417958	1385882	1429778	1410061	1410082	1410092	1429445	1429447	1385882	1385882	1385882	1385882	1426979	1455343	1447458	1417958	1456983	1477154	1478997	1499899	1491540	1385882	1481205	1385882	1385882	1525536	1524109	1551818	1557556	1569747	1585712	1608267	1599888	1625254	1631124	1608267	1649801	1617630	1670158	1650659	1830234	1698456	1670158	1686886	1717547	1899769	1924976	1918419	1717547	1551818	1385882	1729528	1732559	1840144	1761051	1991739	1974662	1991739	2002853	1998567	2332197	2263939	2339175	2187108	2428107	2243413	2201890	2231417	1918419	2020640	1918419	2029974	2055070	2094920	2089431	1918419	2121675	2124549	2109306	2151499	2172252	2373268	2167757	2512503	2467264	2328891	2565378	2542769	2303164	2391459	2412446	2477767	2109306	2201890	2591363	2613930	2646217	2697382	2477767	2591363	2613930	2662999	2573454	2573454	2542769	2633951	2638425	2734402	2736165	2752158	2752160	2734402
period_id	182	156	158	150	153	143	144	159	145	141	155	142	144	147	156	146	154	145	149	157	151	146	149	154	155	147	152	146	148	161	160	162	160	164	163	None	149	None	170	None	None	None	None	None	None	None	None	None	170	None	None	171	None	172	None	None	172	None	None	None	173	None	None	None	None	174	None	None	None	175	None	176	176	177	177	None	None	None	178	None	180	None	179	None	179	181	180	None	181	182	None	181	183	184	185	185	185	189	188	188	None	189	190	192	190	191	192	187	186	None	214	None	222	None	218	216	215	None	215	222	221	None	192	None	193	193	None	194	195	196	197	196	198	None	None	None	None	None	199	199	199	199	None	None	199	197	200	None	201	202	None	202	None	202	204	203	None	204	None	204	205	None	206	None	208	None	None	207	210	209	None	211	210	None	217	219	220	220	212	211	211	212	None	217	213	223	222	223	224	None	236	234	None	231	240	None	232	233	224	None	225	225	226	None	227	228	228	None	228	229	230	237	230	243	241	236	None	244	235	238	239	242	234	232	246	247	None	250	242	246	247	249	245	245	244	248	None	251	252	None	None	251
form_id	F602	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F625	F690	F690	F690	F690	F625	F690	F625	F625	F625	F625	F690	F690	F690	F625	F625	F690	F625	F625	F635	F625	F690	F625	F625	F605	F666	F690	F625	F625	F601	F605	F601	F605	F888	F605	F605	F602	F625	F625	F690	F625	F625	F601	F602	F601	F625	F690	F690	F690	F625	F605	F625	F605	F605	F625	F625	F625	F625	F625	F605	F615	F625	F625	F615	F625	F690	F625	F625	F601	F615	F605	F615	F625	F625	F625	F625	F602	F625	F625	F625	F625	F625	F625	F625	F625	F625	F602	F601	F625	F601	F625	F625	F625	F625	F625	F601	F625	F625	F605	F625	F605	F601	F605	F625	F625	F601	F605	F625	F601	F625	F601	F601	F606	F606	F625	F605	F625	F625	F625	F625	F601	F625	F601	F605	F605	F605	F605	F601	F601	F601	F601	F605	F605	F625	F625	F625	F605	F625	F625	F605	F601	F605	F601	F601	F625	F605	F601	F601	F625	F625	F605	F625	F605	F625	F605	F605	F625	F625	F625	F605	F625	F625	F605	F601	F625	F625	F601	F601	F601	F601	F625	F601	F625	F625	F625	F625	F625	F625	F605	F625	F625	F601	F625	F625	F605	F625	F625	F601	F605	F601	F625	F625	F605	F625	F601	F625	F601	F601	F625	F690	F625	F625	F625	F625	F601	F601	F625	F625	F625	F625	F625	F601	F625	F625	F625	F605	F625	F625	F625	F625	F625	F625	F625	F625	F625	F605	F625	F606	F605	F606	F625
filing_sequence	0	0	0	0	0	0	0	0	0	0	0	0	1	1	1	1	0	1	0	0	0	0	1	1	1	0	0	2	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	2	1	1	0	0	0	2	0	0	0	1	0	0	1	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	2	3	4	0	0	0	1	0	0	0	0	0	5	0	6	7	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	2	0	0	0	0	1	8	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	1	0	3	0	4	0	0	0	0	5	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	1	0	0	1	1	0	0	0	1	1	0	0	0	0	0	0	1
filing_date	2005-04-28 00:00:00	1999-01-06 00:00:00	1999-07-07 00:00:00	1997-07-02 00:00:00	1998-04-21 00:00:00	1995-10-18 00:00:00	1996-01-16 00:00:00	1999-10-25 00:00:00	1996-04-01 00:00:00	1995-04-24 00:00:00	1998-10-15 00:00:00	1995-07-18 00:00:00	1996-06-18 00:00:00	1996-11-01 00:00:00	1999-07-07 00:00:00	1996-07-26 00:00:00	1998-07-14 00:00:00	1996-07-26 00:00:00	1997-04-09 00:00:00	1999-04-22 00:00:00	1997-10-09 00:00:00	1996-07-16 00:00:00	1997-12-16 00:00:00	1998-09-22 00:00:00	1999-01-06 00:00:00	1996-10-17 00:00:00	1998-01-08 00:00:00	1996-11-01 00:00:00	1997-01-22 00:00:00	2000-04-24 00:00:00	2000-01-12 00:00:00	2000-07-14 00:00:00	2000-09-01 00:00:00	2001-01-16 00:00:00	2000-10-16 00:00:00	2000-12-29 00:00:00	2000-05-31 00:00:00	2001-09-19 00:00:00	2002-08-02 00:00:00	2002-07-30 00:00:00	2002-06-19 00:00:00	2002-07-11 00:00:00	2002-06-13 00:00:00	2002-06-26 00:00:00	2002-07-19 00:00:00	2002-07-19 00:00:00	2002-09-26 00:00:00	2002-06-19 00:00:00	2002-07-26 00:00:00	2002-10-28 00:00:00	2002-08-06 00:00:00	2002-10-28 00:00:00	2003-01-28 00:00:00	2002-12-24 00:00:00	2003-01-07 00:00:00	2002-12-24 00:00:00	2003-01-28 00:00:00	2003-01-28 00:00:00	2003-01-29 00:00:00	2003-01-29 00:00:00	2003-04-30 00:00:00	2003-07-29 00:00:00	2003-04-30 00:00:00	2003-01-07 00:00:00	2003-01-10 00:00:00	2003-07-28 00:00:00	2003-07-28 00:00:00	2003-10-29 00:00:00	2004-01-28 00:00:00	2003-10-30 00:00:00	2004-04-23 00:00:00	2004-01-28 00:00:00	2004-01-28 00:00:00	2004-04-23 00:00:00	2004-04-23 00:00:00	2004-04-23 00:00:00	2004-06-22 00:00:00	2004-07-29 00:00:00	2004-07-29 00:00:00	2004-12-27 00:00:00	2005-01-28 00:00:00	2004-08-31 00:00:00	2004-10-28 00:00:00	2004-10-28 00:00:00	2004-10-28 00:00:00	2005-04-26 00:00:00	2005-01-28 00:00:00	2004-12-27 00:00:00	2005-07-20 00:00:00	2005-07-20 00:00:00	2005-01-28 00:00:00	2005-07-20 00:00:00	2005-10-18 00:00:00	2006-01-12 00:00:00	2006-04-18 00:00:00	2006-07-07 00:00:00	2006-10-13 00:00:00	2006-12-22 00:00:00	2006-12-11 00:00:00	2007-01-16 00:00:00	2006-12-14 00:00:00	2007-04-16 00:00:00	2007-07-05 00:00:00	2008-01-15 00:00:00	2007-10-10 00:00:00	2007-10-10 00:00:00	2007-11-19 00:00:00	2007-08-10 00:00:00	2007-08-13 00:00:00	2007-11-08 00:00:00	2013-07-12 00:00:00	2015-04-07 00:00:00	2015-05-19 00:00:00	2015-05-21 00:00:00	2014-07-14 00:00:00	2014-01-13 00:00:00	2013-09-09 00:00:00	2013-09-10 00:00:00	2013-10-07 00:00:00	2015-04-18 00:00:00	2015-04-19 00:00:00	2014-12-17 00:00:00	2007-11-18 00:00:00	2008-03-10 00:00:00	2008-01-30 00:00:00	2008-04-08 00:00:00	2008-07-10 00:00:00	2008-07-08 00:00:00	2008-10-14 00:00:00	2009-01-06 00:00:00	2009-04-21 00:00:00	2008-12-29 00:00:00	2009-07-08 00:00:00	2008-12-29 00:00:00	2009-02-17 00:00:00	2009-02-17 00:00:00	2009-07-07 00:00:00	2009-07-07 00:00:00	2009-07-14 00:00:00	2009-07-14 00:00:00	2009-07-14 00:00:00	2009-07-14 00:00:00	2009-03-18 00:00:00	2009-12-01 00:00:00	2009-10-12 00:00:00	2009-04-24 00:00:00	2010-01-07 00:00:00	2010-04-01 00:00:00	2010-04-10 00:00:00	2010-07-10 00:00:00	2010-05-20 00:00:00	2010-04-15 00:00:00	2010-04-21 00:00:00	2010-05-18 00:00:00	2010-10-13 00:00:00	2010-10-13 00:00:00	2010-10-07 00:00:00	2010-12-17 00:00:00	2010-12-30 00:00:00	2011-01-29 00:00:00	2011-04-11 00:00:00	2011-07-27 00:00:00	2011-07-12 00:00:00	2011-11-03 00:00:00	2012-01-24 00:00:00	2011-08-08 00:00:00	2012-03-08 00:00:00	2011-10-15 00:00:00	2012-07-06 00:00:00	2012-04-05 00:00:00	2014-03-12 00:00:00	2012-10-15 00:00:00	2012-10-15 00:00:00	2012-08-02 00:00:00	2014-03-06 00:00:00	2014-10-17 00:00:00	2015-01-13 00:00:00	2014-12-15 00:00:00	2012-12-17 00:00:00	2012-08-27 00:00:00	2012-08-27 00:00:00	2013-01-22 00:00:00	2012-12-28 00:00:00	2014-04-22 00:00:00	2013-04-24 00:00:00	2015-10-13 00:00:00	2015-07-16 00:00:00	2015-10-15 00:00:00	2016-01-08 00:00:00	2015-10-28 00:00:00	2019-01-05 00:00:00	2018-07-11 00:00:00	2018-12-20 00:00:00	2017-10-10 00:00:00	2020-01-04 00:00:00	2018-04-30 00:00:00	2018-04-16 00:00:00	2018-04-16 00:00:00	2015-10-27 00:00:00	2016-03-04 00:00:00	2016-03-04 00:00:00	2016-04-20 00:00:00	2016-07-14 00:00:00	2016-10-21 00:00:00	2016-10-15 00:00:00	2016-10-15 00:00:00	2017-01-20 00:00:00	2016-12-15 00:00:00	2016-12-01 00:00:00	2017-04-18 00:00:00	2017-07-19 00:00:00	2019-04-16 00:00:00	2017-07-16 00:00:00	2020-10-09 00:00:00	2020-04-24 00:00:00	2018-12-19 00:00:00	2020-12-28 00:00:00	2021-01-07 00:00:00	2018-10-06 00:00:00	2019-07-20 00:00:00	2019-10-09 00:00:00	2020-07-11 00:00:00	2018-04-30 00:00:00	2018-01-15 00:00:00	2021-07-07 00:00:00	2021-10-16 00:00:00	2022-01-06 00:00:00	2022-07-11 00:00:00	2021-08-04 00:00:00	2022-03-29 00:00:00	2021-10-05 00:00:00	2022-04-05 00:00:00	2021-04-12 00:00:00	2022-03-06 00:00:00	2021-12-28 00:00:00	2022-01-11 00:00:00	2022-01-06 00:00:00	2022-10-16 00:00:00	2022-10-19 00:00:00	2022-10-24 00:00:00	2022-10-24 00:00:00	2022-10-19 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	10005	10005	10005	10005	10005	10005	10005	10005	10005	10002	10005	10005	10005	10005	10005	10005	10005	10005	10005	10001	10005	10006	10001	10005	10001	10005	10005	10001	10006	10006	10006	10001	10005	10005	10005	10005	10001	10005	10005	10005	10001	10005	10001	10001	10001	10001	10005	10006	10005	10001	10005	10001	10005	10001	10005	10001	10001	10001	10005	10002	10001	10005	10001	10001	10001	10001	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10002	10002	10002	10002	10005	10001	10006	10002	10006	10001	10001	10002	10006	10001	10002	10001	10005	10002	10005	10001	10001	10005	10001	10001	10001	10001	10001	10001	10005	10005	10005	10005	10005	10002	10002	10002	10002	10006	10006	10001	10002	10001	10006	10001	10001	10006	10002	10006	10002	10002	10001	10006	10001	10005	10001	10001	10006	10001	10006	10001	10006	10006	10001	10001	10001	10006	10001	10002	10006	10002	10001	10001	10001	10001	10002	10002	10001	10005	10001	10001	10001	10001	10002	10001	10006	10001	10001	10001	10001	10001	10005	10002	10001	10002	10005	10002	10001	10001	10005	10001	10002	10001	10001	10001	10001	10006	10001	10001	10001	10001	10001	10005	10001	10001	10001	10001	10001	10002	10001	10001	10002	10005	10001	10002	10002	10001	10001	10001	10002	10002	10001	10005	10001	10001	10002	10003	10002
stmnt_status	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	11003	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11003	11001	11003	11001	11001	11003	11001	11001	11001	11003	11001	11001	11001	11001	11003	11001	11001	11003	11003	11001	11003	11003	11003	11003	11001	11003	11003	11003	11001	11003	11001	11003	11001	11003	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11002	11003	11003	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	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	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	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	11001	11001	11003	11003	11003	11001	11001	11001	11003	11003	11001	11001	11003	11001	11001	11001	11003
session_id	2005	1997	1999	1997	1997	1995	1995	1999	1995	1995	1997	1995	1995	1995	1997	1995	1997	1995	1997	1999	1997	1995	1997	1997	1997	1995	1997	1995	1995	1999	1999	1999	1999	1999	1999	2001	1997	1999	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2001	2003	2003	2003	2001	2001	2001	2001	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2003	2005	2003	2003	2003	2003	2003	2005	2003	2005	2005	2005	2003	2005	2005	2005	2005	2005	2005	2007	2007	2005	2007	2007	2007	2007	2007	2007	2007	2005	2005	2007	2013	2015	2015	2015	2013	2013	2013	2013	2013	2015	2015	2015	2007	2007	2007	2007	2007	2007	2007	2007	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2009	2011	2011	2009	2011	2011	2011	2011	2011	2011	2011	2011	2011	2011	2013	2011	2011	2011	2013	2013	2013	2015	2013	2011	2009	2011	2013	2013	2013	2015	2015	2015	2015	2015	2017	2017	2019	2017	2019	2017	2017	2017	2015	2015	2015	2015	2015	2015	2015	2015	2015	2017	2017	2017	2017	2019	2017	2019	2019	2019	2021	2019	2017	2019	2019	2019	2017	2017	2021	2021	2021	2021	2019	2021	2021	2021	2021	2021	2019	2021	2021	2021	2021	2021	2021	2021
user_id	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	GGILMORE	TTHAM	JLEHMAN	MHOANG	MKIENG	MKIENG	GPEREZ	MKIENG	LTHIBAUL	*	YBONILLA	SARRIAGA	SARRIAGA	SARRIAGA	GPEREZ	SARRIAGA	SARRIAGA	CFLAGG	SARRIAGA	*	YBONILLA	YBONILLA	*	YBONILLA	*	PBANFORD	GPEREZ	COMPLETED	YBONILLA	YBONILLA	YBONILLA	COMPLETED	GPEREZ	YBONILLA	PBANFORD	PBANFORD	COMPLETED	YBONILLA	YBONILLA	EMCENTEE	COMPLETED	CFLAGG	COMPLETED	COMPLETED	COMPLETED	COMPLETED	LTHIBAUL	EMCENTEE	EMCENTEE	COMPLETED	CFLAGG	COMPLETED	GPEREZ	COMPLETED	YRODRIGU	COMPLETED	YRODRIGU	COMPLETED	SARRIAGA	YRODRIGU	YRODRIGU	YRODRIGU	YRODRIGU	YRODRIGU	LTHIBAUL	YRODRIGU	YRODRIGU	JMARTIN	*	*	YRODRIGU	CFLAGG	YRODRIGU	LTHIBAUL	LTHIBAUL	LTHIBAUL	LTHIBAUL	*	LTHIBAUL	YRODRIGU	GPEREZ	ASAETERN	YRODRIGU	YRODRIGU	YRODRIGU	ASAETERN	ASAETERN	YRODRIGU	SMCCONNAN	ASAETERN	YRODRIGU	AGLADNEY	SARRIAGA	*	YRODRIGU	YRODRIGU	LTHIBAUL	LTHIBAUL	MGUERRA	MGUERRA	MGUERRA	YRODRIGU	YRODRIGU	YRODRIGU	SARRIAGA	SARRIAGA	SARRIAGA	CFLAGG	CFLAGG	YRODRIGU	YRODRIGU	YRODRIGU	YRODRIGU	PBANFORD	YRODRIGU	YRODRIGU	YRODRIGU	YRODRIGU	YRODRIGU	MGUERRA	ASAETERN	YRODRIGU	YRODRIGU	YRODRIGU	YRODRIGU	YRODRIGU	ASAETERN	YRODRIGU	YRODRIGU	YRODRIGU	ASAETERN	ASAETERN	YRODRIGU	ASAETERN	YRODRIGU	ASAETERN	YRODRIGU	ASAETERN	ASAETERN	JINGRAM	ASAETERN	PBANFORD	ASAETERN	AGLADNEY	YRODRIGU	PBANFORD	ASAETERN	AGLADNEY	SARRIAGA	SMCCONNAN	YRODRIGU	YRODRIGU	ASAETERN	SMCCONNAN	ASAETERN	ASAETERN	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	YRODRIGU	AGLADNEY	AGLADNEY	DMCCASTL	AGLADNEY	AGLADNEY	GPEREZ	AGLADNEY	AGLADNEY	YRODRIGU	GPEREZ	CAFILER	AGLADNEY	AGLADNEY	GPEREZ	AGLADNEY	CAFILER	AGLADNEY	PBANFORD	PBANFORD	AGLADNEY	AGLADNEY	AGLADNEY	AGLADNEY	MKIRKHAM	MKIRKHAM	CAFILER	MMERCHANT	MKIRKHAM	AGLADNEY	AGLADNEY	GTAYLOR	MKIRKHAM	GPEREZ	AGLADNEY	CHATRIDGE	CHATRIDGE	SARRIAGA	CAFILER	CAFILER	CAFILER	CHATRIDGE	CHATRIDGE	CHATRIDGE	CAFILER	CAFILER	CHATRIDGE	SARRIAGA	CAFILER	MMERCHANT	MMERCHANT	MMERCHANT	CAFILER
special_audit	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	11003	11003	11003	11003	11003	11003	11003	11003	11002	11003	11003	11003	11003	11003	11003	11003	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	11003	11003	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	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	11001	11001	11001	11001	11001	11001	11001	11003	11001	11001	11001	11003	11003	11003	11001	11003	11003	11001	11001	11001	11001	11001	11001	11003	11003	11003	11003	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11001	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	11003	11003	11001	11001	11003	11001	11003	11001	11001	11001	11001	11001	11001	11001	11001	11001	11003	11003	11001	11001	11001	11001	11001	11003	11001	11001	11001	11003	11003	11003	11003	11001	11001	11001	11003	11003	11001	11003	11003	11003	11003	11003	11003
rpt_start	2005-04-28 00:00:00	1998-10-01 00:00:00	1999-04-01 00:00:00	1997-04-01 00:00:00	1998-01-01 00:00:00	1995-07-01 00:00:00	1995-10-01 00:00:00	1999-07-01 00:00:00	1996-01-01 00:00:00	1995-01-01 00:00:00	1998-07-01 00:00:00	1995-04-01 00:00:00	1995-10-01 00:00:00	1996-07-01 00:00:00	1998-10-01 00:00:00	1996-04-01 00:00:00	1998-04-01 00:00:00	1996-01-01 00:00:00	1997-01-01 00:00:00	1999-01-01 00:00:00	1997-07-01 00:00:00	1996-04-01 00:00:00	1997-01-01 00:00:00	1998-04-01 00:00:00	1998-07-01 00:00:00	1996-07-01 00:00:00	1997-10-01 00:00:00	1996-04-01 00:00:00	1996-10-01 00:00:00	2000-01-01 00:00:00	1999-10-01 00:00:00	2000-04-01 00:00:00	1999-10-01 00:00:00	2000-10-01 00:00:00	2000-07-01 00:00:00	1900-01-01 00:00:00	1997-01-01 00:00:00	2000-01-01 00:00:00	2002-04-01 00:00:00	2002-04-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2002-04-01 00:00:00	2002-07-01 00:00:00	2002-04-01 00:00:00	2002-07-01 00:00:00	2002-10-01 00:00:00	2002-12-23 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2002-10-01 00:00:00	2002-07-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	2003-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2003-04-01 00:00:00	2003-04-01 00:00:00	2003-07-01 00:00:00	2003-10-01 00:00:00	2003-07-01 00:00:00	1900-01-01 00:00:00	2003-10-01 00:00:00	2003-10-01 00:00:00	2004-01-01 00:00:00	2004-01-01 00:00:00	2004-01-01 00:00:00	2003-07-01 00:00:00	2004-04-01 00:00:00	2004-04-01 00:00:00	1900-01-01 00:00:00	2004-10-01 00:00:00	1900-01-01 00:00:00	2004-07-01 00:00:00	2004-07-01 00:00:00	2004-07-01 00:00:00	2005-01-01 00:00:00	2004-10-01 00:00:00	1900-01-01 00:00:00	2005-01-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	2005-10-01 00:00:00	2006-01-01 00:00:00	2006-01-01 00:00:00	2006-01-01 00:00:00	2007-01-01 00:00:00	2006-12-11 00:00:00	2006-10-01 00:00:00	1900-01-01 00:00:00	2007-01-01 00:00:00	2007-04-01 00:00:00	2007-10-01 00:00:00	2007-06-01 00:00:00	2007-07-01 00:00:00	2007-11-19 00:00:00	2006-07-01 00:00:00	2006-04-01 00:00:00	1900-01-01 00:00:00	2013-04-01 00:00:00	1900-01-01 00:00:00	2015-05-19 00:00:00	1900-01-01 00:00:00	2014-04-01 00:00:00	2013-10-01 00:00:00	2013-09-09 00:00:00	1900-01-01 00:00:00	2013-07-01 00:00:00	2015-04-18 00:00:00	2015-01-01 00:00:00	1900-01-01 00:00:00	2007-11-18 00:00:00	1900-01-01 00:00:00	2008-01-30 00:00:00	2008-01-01 00:00:00	1900-01-01 00:00:00	2008-04-01 00:00:00	2008-07-01 00:00:00	2008-10-01 00:00:00	2009-01-01 00:00:00	2008-12-29 00:00:00	2009-04-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2009-07-14 00:00:00	2009-07-14 00:00:00	2009-07-14 00:00:00	2009-07-14 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2009-07-01 00:00:00	2009-01-01 00:00:00	2009-10-01 00:00:00	1900-01-01 00:00:00	2010-01-01 00:00:00	2010-04-01 00:00:00	1900-01-01 00:00:00	2010-04-15 00:00:00	1900-01-01 00:00:00	2010-05-18 00:00:00	2010-10-13 00:00:00	2010-07-01 00:00:00	1900-01-01 00:00:00	2010-12-17 00:00:00	1900-01-01 00:00:00	2010-10-01 00:00:00	2011-01-01 00:00:00	1900-01-01 00:00:00	2011-04-01 00:00:00	1900-01-01 00:00:00	2011-10-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2011-07-01 00:00:00	2012-04-01 00:00:00	2012-01-01 00:00:00	1900-01-01 00:00:00	2012-07-01 00:00:00	2012-04-01 00:00:00	1900-01-01 00:00:00	2014-03-06 00:00:00	2014-07-01 00:00:00	2014-10-01 00:00:00	2014-12-15 00:00:00	2012-12-17 00:00:00	2012-08-27 00:00:00	2012-08-27 00:00:00	2012-10-01 00:00:00	1900-01-01 00:00:00	2014-01-01 00:00:00	2013-01-01 00:00:00	2015-07-01 00:00:00	2015-04-01 00:00:00	2015-07-01 00:00:00	2015-10-01 00:00:00	1900-01-01 00:00:00	2018-10-01 00:00:00	2018-04-01 00:00:00	1900-01-01 00:00:00	2017-07-01 00:00:00	2019-10-01 00:00:00	1900-01-01 00:00:00	2017-10-01 00:00:00	2018-01-01 00:00:00	2015-10-27 00:00:00	1900-01-01 00:00:00	2016-03-04 00:00:00	2016-01-01 00:00:00	2016-04-01 00:00:00	1900-01-01 00:00:00	2016-07-01 00:00:00	2016-10-15 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	2017-04-01 00:00:00	2019-01-01 00:00:00	2017-04-01 00:00:00	2020-07-01 00:00:00	2020-01-01 00:00:00	2018-12-19 00:00:00	1900-01-01 00:00:00	2020-10-01 00:00:00	2018-07-01 00:00:00	2019-04-01 00:00:00	2019-07-01 00:00:00	2020-04-01 00:00:00	2018-04-30 00:00:00	2017-10-01 00:00:00	2021-04-01 00:00:00	2021-07-01 00:00:00	1900-01-01 00:00:00	2022-04-01 00:00:00	2020-04-01 00:00:00	2021-04-01 00:00:00	2021-07-01 00:00:00	2022-01-01 00:00:00	2021-01-01 00:00:00	2021-01-01 00:00:00	2020-10-01 00:00:00	2021-10-01 00:00:00	1900-01-01 00:00:00	2022-07-01 00:00:00	2022-10-19 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2022-07-01 00:00:00
rpt_end	2005-04-28 00:00:00	1998-12-31 00:00:00	1999-06-30 00:00:00	1997-06-30 00:00:00	1998-03-31 00:00:00	1995-09-30 00:00:00	1995-12-31 00:00:00	1999-09-30 00:00:00	1996-03-31 00:00:00	1995-03-31 00:00:00	1998-09-30 00:00:00	1995-06-30 00:00:00	1995-12-31 00:00:00	1996-09-30 00:00:00	1998-12-31 00:00:00	1996-06-30 00:00:00	1998-06-30 00:00:00	1996-03-31 00:00:00	1997-03-31 00:00:00	1999-03-31 00:00:00	1997-09-30 00:00:00	1996-06-30 00:00:00	1997-03-31 00:00:00	1998-06-30 00:00:00	1998-09-30 00:00:00	1996-09-30 00:00:00	1997-12-31 00:00:00	1996-06-30 00:00:00	1996-12-31 00:00:00	2000-03-31 00:00:00	1999-12-31 00:00:00	2000-06-30 00:00:00	1999-12-31 00:00:00	2000-12-31 00:00:00	2000-09-30 00:00:00	1900-01-01 00:00:00	1998-12-31 00:00:00	2010-03-31 00:00:00	2002-06-30 00:00:00	2002-06-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2002-06-30 00:00:00	2002-09-30 00:00:00	2002-06-30 00:00:00	2002-09-30 00:00:00	2002-12-31 00:00:00	2002-12-23 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2002-12-31 00:00:00	2002-09-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	2003-03-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2003-06-30 00:00:00	2003-06-30 00:00:00	2003-09-30 00:00:00	2003-12-31 00:00:00	2003-09-30 00:00:00	1900-01-01 00:00:00	2003-12-31 00:00:00	2003-12-31 00:00:00	2004-03-31 00:00:00	2004-03-31 00:00:00	2004-03-31 00:00:00	2003-09-30 00:00:00	2004-06-30 00:00:00	2004-06-30 00:00:00	1900-01-01 00:00:00	2004-12-31 00:00:00	1900-01-01 00:00:00	2004-09-30 00:00:00	2004-09-30 00:00:00	2004-09-30 00:00:00	2005-03-31 00:00:00	2004-12-31 00:00:00	1900-01-01 00:00:00	2005-03-31 00:00:00	2005-06-30 00:00:00	2004-12-31 00:00:00	2005-06-30 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	2007-01-01 00:00:00	2006-12-11 00:00:00	2006-12-31 00:00:00	1900-01-01 00:00:00	2007-03-31 00:00:00	2007-06-30 00:00:00	2007-12-31 00:00:00	2007-09-30 00:00:00	2007-09-30 00:00:00	2007-11-19 00:00:00	2006-09-30 00:00:00	2006-06-30 00:00:00	1900-01-01 00:00:00	2013-06-30 00:00:00	1900-01-01 00:00:00	2015-05-19 00:00:00	1900-01-01 00:00:00	2014-06-30 00:00:00	2013-12-31 00:00:00	2013-09-09 00:00:00	1900-01-01 00:00:00	2013-09-30 00:00:00	2015-04-18 00:00:00	2015-03-31 00:00:00	1900-01-01 00:00:00	2007-11-18 00:00:00	1900-01-01 00:00:00	2008-01-30 00:00:00	2008-03-31 00:00:00	1900-01-01 00:00:00	2008-06-30 00:00:00	2008-09-30 00:00:00	2008-12-31 00:00:00	2009-03-31 00:00:00	2008-12-29 00:00:00	2009-06-30 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2009-07-14 00:00:00	2009-07-14 00:00:00	2009-07-14 00:00:00	2009-07-14 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2009-09-30 00:00:00	2009-03-31 00:00:00	2009-12-31 00:00:00	1900-01-01 00:00:00	2010-03-31 00:00:00	2010-06-30 00:00:00	1900-01-01 00:00:00	2010-04-15 00:00:00	1900-01-01 00:00:00	2010-05-18 00:00:00	2010-10-13 00:00:00	2010-09-30 00:00:00	1900-01-01 00:00:00	2010-12-17 00:00:00	1900-01-01 00:00:00	2010-12-31 00:00:00	2011-03-31 00:00:00	1900-01-01 00:00:00	2011-06-30 00:00:00	1900-01-01 00:00:00	2011-12-31 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2011-09-30 00:00:00	2012-06-30 00:00:00	2012-03-31 00:00:00	1900-01-01 00:00:00	2012-09-30 00:00:00	2012-06-30 00:00:00	1900-01-01 00:00:00	2014-03-06 00:00:00	2014-09-30 00:00:00	2014-12-31 00:00:00	2014-12-15 00:00:00	2012-12-17 00:00:00	2012-08-27 00:00:00	2012-08-27 00:00:00	2012-12-31 00:00:00	1900-01-01 00:00:00	2014-03-31 00:00:00	2013-03-31 00:00:00	2015-08-31 00:00:00	2015-06-30 00:00:00	2015-09-30 00:00:00	2015-12-31 00:00:00	1900-01-01 00:00:00	2018-12-31 00:00:00	2018-06-30 00:00:00	1900-01-01 00:00:00	2017-09-30 00:00:00	2019-12-31 00:00:00	1900-01-01 00:00:00	2017-12-31 00:00:00	2018-03-31 00:00:00	2015-10-27 00:00:00	1900-01-01 00:00:00	2016-03-04 00:00:00	2016-03-31 00:00:00	2016-06-30 00:00:00	1900-01-01 00:00:00	2016-09-30 00:00:00	2016-10-15 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	2017-06-30 00:00:00	2019-03-31 00:00:00	2017-06-30 00:00:00	2020-09-30 00:00:00	2020-03-31 00:00:00	2018-12-19 00:00:00	1900-01-01 00:00:00	2020-12-31 00:00:00	2018-09-30 00:00:00	2019-06-30 00:00:00	2019-09-30 00:00:00	2020-06-30 00:00:00	2018-04-30 00:00:00	2017-12-31 00:00:00	2021-06-30 00:00:00	2021-09-30 00:00:00	1900-01-01 00:00:00	2022-06-30 00:00:00	2020-06-30 00:00:00	2021-06-30 00:00:00	2021-09-30 00:00:00	2022-03-31 00:00:00	2022-12-30 00:00:00	2021-03-31 00:00:00	2020-12-31 00:00:00	2021-12-31 00:00:00	1900-01-01 00:00:00	2022-09-30 00:00:00	2022-10-19 00:00:00	1900-01-01 00:00:00	1900-01-01 00:00:00	2022-09-30 00:00:00
rpt_date	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
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	None	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	22001	None	None	None	None	22001	None	None	None	22001	None	22001	22001	22001	22001	None	None	None	22001	None	22001	None	22001	None	22001	22001	22001	None	22001	22006	None	22001	22006	22006	22006	22006	22006	22001	22006	22006	None	22006	22006	22006	22006	22006	22006	22006	22006	None	22006	None	22006	None	22006	22006	22006	None	22006	22006	22006	None	22006	None	22001	22006	None	22006	22006	22006	22006	22006	22006	None	None	None	None	None	22006	22006	22006	22006	None	None	22006	22006	22006	None	22006	22006	None	22006	None	22006	22006	22006	None	22006	None	22006	22006	None	22006	None	22006	None	None	22006	22006	22006	None	22006	22006	None	22006	22006	22006	22006	22006	22006	22006	22006	None	22006	22006	22006	22006	22006	22006	None	22006	22006	None	22006	22006	None	22006	22006	22006	None	22006	22006	22006	None	22006	22006	22006	None	22006	22006	None	22006	22006	22006	22006	22006	None	22006	22006	22006	22006	22006	22006	22006	22006	22006	None	22006	22006	22006	22006	22006	22006	22006	22006	22006	None	22006	22006	None	None	22006

Table: filer_to_filer_type
filer_id	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477
filer_type	3	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	T	N
race	0	0	0	0	None	None	None	None	None	None	None	None	None	None	0	None
session_id	1999	1997	1995	2001	2003	2005	2007	2011	2013	2009	2015	2021	2019	2017	2021	2023
category	0	0	0	0	None	None	None	None	None	None	None	None	None	None	0	None
category_type	0	0	0	0	None	None	None	None	None	None	None	None	None	None	0	None
sub_category	0	0	0	0	None	None	None	None	None	None	None	None	None	None	0	None
effect_dt	1999-01-01 00:00:00	1997-01-01 00:00:00	1995-01-01 00:00:00	2002-06-07 00:00:00	2003-01-01 00:00:00	2005-01-01 00:00:00	2007-01-01 00:00:00	2011-01-01 00:00:00	2013-01-01 00:00:00	2009-01-01 00:00:00	2015-01-01 00:00:00	2021-01-01 00:00:00	2019-01-01 00:00:00	2017-01-01 00:00:00	2022-10-31 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	0	None
election_type	0	0	0	0	None	None	None	None	None	None	None	None	None	None	0	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	2002-04-01 00:00:00	2002-04-01 00:00:00	None	None	None	None	None	None	None	None	None
party_cd	None	None	None	None	None	None	None	None	None	None	None	None	None	None	0	None
county_cd	None	None	None	None	None	None	None	None	None	None	None	None	None	None	0	None
district_cd	None	None	None	None	None	None	None	None	None	None	None	None	None	None	0	None

Table: filer_xref
filer_id		1147477
xref_id		F24573
effect_dt		1999-12-08 00:00:00
migration_source		MASTER

Table: filername
xref_filer_id	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573	F24573
filer_id	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477
filer_type	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM	FIRM
status	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	INACTIVE	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
naml	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE AND ASSOCIATES	BOURNE AND ASSOCIATES	BOURNE AND ASSOCIATES	BOURNE AND ASSOCIATES	BOURNE AND ASSOCIATES	BOURNE AND ASSOCIATES	BOURNE AND ASSOCIATES	BOURNE AND ASSOCIATES	BOURNE AND ASSOCIATES	BOURNE AND ASSOCIATES	BOURNE AND ASSOCIATES	BOURNE AND ASSOCIATES	BOURNE AND ASSOCIATES	BOURNE AND ASSOCIATES	BOURNE, LYDIA C.	BOURNE, LYDIA C.	BOURNE, LYDIA C.	BOURNE, LYDIA C.	BOURNE, LYDIA C.	BOURNE, LYDIA C.	BOURNE, LYDIA C.	BOURNE, LYDIA C.	BOURNE, LYDIA C.	BOURNE, LYDIA C.	BOURNE, LYDIA C.	BOURNE, LYDIA C.	BOURNE, LYDIA C.	BOURNE, LYDIA C.	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & 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	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	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
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
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
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
city	EL MACERO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	SACRAMENTO	SACRAMENTO	SACRAMENTO	SACRAMENTO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO	EL MACERO
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
zip4	95618	95814	95814	95814	95814	95618	95618	95618	95618	95618	95618	95618	95618	95618	95618	95814	95814	95814	95814	95618	95618	95618	95618	95618	95618	95618	95618	95618	95618	95814	95814	95814	95814	95618	95618	95618	95618	95618	95618	95618	95618	95618	95618	95814	95814	95814	95814	95618	95618	95618	95618	95618	95618	95618	95618	95618	95618	95814	95814	95814	95814	95618	95618	95618	95618	95618	95618	95618	95618	95618	95618	95814	95814	95814	95814	95618	95618	95618	95618	95618	95618	95618	95618	95618	95618	95814	95814	95814	95814	95618	95618	95618	95618	95618	95618	95618	95618	95618	95618	95814	95814	95814	95814	95618	95618	95618	95618	95618	95618	95618	95618	95618	95618	95814	95814	95814	95814	95618	95618	95618	95618	95618	95618	95618	95618	95618	95618	95814	95814	95814	95814	95618	95618	95618	95618	95618	95618	95618	95618	95618	95618	95814	95814	95814	95814	95618	95618	95618	95618	95618	95618	95618	95618	95618	95618	95814	95814	95814	95814	95618	95618	95618	95618	95618	95618	95618	95618	95618	95618	95814	95814	95814	95814	95618	95618	95618	95618	95618	95618	95618	95618	95618	95618	95814	95814	95814	95814	95618	95618	95618	95618	95618	95618	95618	95618	95618	95618	95814	95814	95814	95814	95618	95618	95618	95618	95618	95618	95618	95618	95618
phon	5307584158	9164477821	9164477821	9164477821	9164477821	9168010312	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	9164477821	9164477821	9164477821	9164477821	9168010312	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	9164477821	9164477821	9164477821	9164477821	9168010312	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	9164477821	9164477821	9164477821	9164477821	9168010312	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	9164477821	9164477821	9164477821	9164477821	9168010312	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	9164477821	9164477821	9164477821	9164477821	9168010312	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	9164477821	9164477821	9164477821	9164477821	9168010312	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	9164477821	9164477821	9164477821	9164477821	9168010312	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	9164477821	9164477821	9164477821	9164477821	9168010312	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	9164477821	9164477821	9164477821	9164477821	9168010312	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	9164477821	9164477821	9164477821	9164477821	9168010312	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	9164477821	9164477821	9164477821	9164477821	9168010312	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	9164477821	9164477821	9164477821	9164477821	9168010312	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	9164477821	9164477821	9164477821	9164477821	9168010312	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	9164477821	9164477821	9164477821	9164477821	9168010312	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158	5307584158
fax	None	9164474394									5307584158	5307584158			None	9164474394									5307584158	5307584158			None	9164474394									5307584158	5307584158			None	9164474394									5307584158	5307584158			None	9164474394									5307584158	5307584158			None	9164474394									5307584158	5307584158			None	9164474394									5307584158	5307584158			None	9164474394									5307584158	5307584158			None	9164474394									5307584158	5307584158			None	9164474394									5307584158	5307584158			None	9164474394									5307584158	5307584158			None	9164474394									5307584158	5307584158			None	9164474394									5307584158	5307584158			None	9164474394									5307584158	5307584158			None	9164474394									5307584158	5307584158
email	None	None	None	lbourne@saclobby.com	lbourne@saclobby.com	lbourne@saclobby.com	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	None	None	None	lbourne@saclobby.com	lbourne@saclobby.com	lbourne@saclobby.com	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	None	None	None	lbourne@saclobby.com	lbourne@saclobby.com	lbourne@saclobby.com	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	None	None	None	lbourne@saclobby.com	lbourne@saclobby.com	lbourne@saclobby.com	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	None	None	None	lbourne@saclobby.com	lbourne@saclobby.com	lbourne@saclobby.com	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	None	None	None	lbourne@saclobby.com	lbourne@saclobby.com	lbourne@saclobby.com	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	None	None	None	lbourne@saclobby.com	lbourne@saclobby.com	lbourne@saclobby.com	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	None	None	None	lbourne@saclobby.com	lbourne@saclobby.com	lbourne@saclobby.com	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	None	None	None	lbourne@saclobby.com	lbourne@saclobby.com	lbourne@saclobby.com	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	None	None	None	lbourne@saclobby.com	lbourne@saclobby.com	lbourne@saclobby.com	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	None	None	None	lbourne@saclobby.com	lbourne@saclobby.com	lbourne@saclobby.com	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	None	None	None	lbourne@saclobby.com	lbourne@saclobby.com	lbourne@saclobby.com	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	None	None	None	lbourne@saclobby.com	lbourne@saclobby.com	lbourne@saclobby.com	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	None	None	None	lbourne@saclobby.com	lbourne@saclobby.com	lbourne@saclobby.com	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	None	None	None	lbourne@saclobby.com	lbourne@saclobby.com	lbourne@saclobby.com	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net	lydiabourne@sbcglobal.net

Table: filers
filer_id		1147477

Table: lobbying_chg_log
filer_id	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477
change_no	1	8	10	9	11	12	0	13	14	16	15	21	17	20	18	19	24	22	23	26	27	25	28	29	30	31
session_id	1999	2001	2001	2001	2001	2001	2001	2003	2003	2007	2007	2009	2007	2009	2009	2009	2009	2009	2009	2011	2011	2011	2011	2013	2015	2015
log_dt	2000-12-29 00:00:00	2002-06-13 00:00:00	2002-06-19 00:00:00	2002-06-19 00:00:00	2002-06-19 00:00:00	2002-09-26 00:00:00	2002-07-11 00:00:00	2003-07-29 00:00:00	2004-08-31 00:00:00	2007-11-08 00:00:00	2007-11-08 00:00:00	2010-04-01 00:00:00	2008-07-10 00:00:00	2009-12-01 00:00:00	2009-07-07 00:00:00	2009-07-07 00:00:00	2010-10-07 00:00:00	2010-04-21 00:00:00	2010-05-20 00:00:00	2011-11-03 00:00:00	2012-03-08 00:00:00	2011-08-08 00:00:00	2012-08-02 00:00:00	2014-03-12 00:00:00	2015-04-07 00:00:00	2015-05-21 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
correction_flg	Y	Y	Y	Y	Y	Y	Y	Y	None	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	None	None	Y	None	Y	Y	Y
action	DELETED	ADDED	ADDED	ADDED	ADDED	ADDED	ADDED	DELETED	DELETED	ADDED	DELETED	DELETED	DELETED	ADDED	DELETED	DELETED	DELETED	DELETED	ADDED	DELETED	ADDED	ADDED	ADDED	ADDED	ADDED	DELETED
attribute_changed	EMPLOYER	EMPLOYER	CLIENT/FIRM	EMPLOYER	CLIENT/FIRM	CLIENT/FIRM	CLIENT/FIRM	None	CLIENT	EMPLOYER	CLIENT	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	EMPLOYER	CLIENT	EMPLOYER	CLIENT	EMPLOYER	EMPLOYER	EMPLOYER
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
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
filer_full_name	BOURNE & ASSOCIATES	BOURNE AND ASSOCIATES	BOURNE AND ASSOCIATES	BOURNE AND ASSOCIATES	BOURNE AND ASSOCIATES	BOURNE AND ASSOCIATES	BOURNE AND ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES	BOURNE & ASSOCIATES
filer_city	EL MACERO	EL MACERO	None	None	None	EL MACERO	None	None	None	None	None	None	EL MACERO	EL MACERO	None	None	None	None	None	None	None	None	None	None	None	None
filer_st	CA	CA	None	None	None	CA	None	None	None	None	None	None	CA	CA	None	None	None	None	None	None	None	None	None	None	None	None
filer_zip	95618	95618	None	None	None	95618	None	None	None	None	None	None	95618	95618	None	None	None	None	None	None	None	None	None	None	None	None
filer_phone	5307584158	5307584158	None	None	None	5307584158	None	None	None	None	None	None	5307584158	5307584158	None	None	None	None	None	None	None	None	None	None	None	None
entity_type	2	2	3	2	3	None	3	3	1	2	3	2	2	2	2	2	2	2	2	2	1	2	1	2	2	2
entity_name	CALIFORNIA SCHOOL NURSES ORGANIZATION	BLOOD CENTERS OF CALIFORNIA	HUNTER, TRICIA	CALIFORNIA PHYSICAL THERAPY ASSOCIATION	COOPER, GARY S.	THE FLANNERY GROUP	FLANNERY GROUP, THE	GOVERNMENT RELATIONS GROUP	CALIFORNIA PHYSICAL THERAPY ASSOCIATION	CHILDREN'S HEALTH INITIATIVE NAPA COUNTY	GOVERNMENT RELATIONS GROUP, INC.	CALIFORNIA NURSES ASSOCIATION	CHILDREN'S HEALTH INITIATIVE NAPA COUNTY	CALIFORNIA NURSES ASSOCIATION	CALIFORNIA NURSES ASSOCIATION	CHILDREN'S NETWORK SOLANO COUNTY	AMERICAN ASSOCIATION OF TISSUE BANKS	AMERICAN ASSOCIATION OF TISSUE BANKS	AMERICAN ASSOCIATION OF TISSUE BANKS	CALIFORNIA NURSES ASSOCIATION	CALIFORNIA BLACK HEALTH NETWORK	CALIFORNIA NURSES ASSOCIATION	AMERICAN ACADEMY OF PEDIATRICS, CALIFORNIA DISTRICT	CALIFORNIA SCHOOL NURSES ORGANIZATION	CALIFORNIA BLACK HEALTH NETWORK	CALIFORNIA BLACK HEALTH NETWORK
entity_city	None	None	SACRAMENTO	SACRAMENTO	SACRAMENTO	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
entity_st	None	None	CA	CA	CA	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
entity_zip	None	None	95814	95833	95814	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
entity_phone	None	None	9164477821	9169292782	9164424344	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None
entity_id	None	None	1245581	1142835	1147387	None	1147462	1252005	1142835	1302313	1245581	1146800	None	None	1146800	1315654	1315651	1315651	1315651	1146800	1345947	1146800	1146259	1144031	1345947	1345947
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
effect_dt	2000-12-31 00:00:00	2002-06-07 00:00:00	2002-06-07 00:00:00	2002-06-07 00:00:00	2002-06-07 00:00:00	2002-09-20 00:00:00	2002-06-26 00:00:00	2003-07-30 00:00:00	2004-08-31 00:00:00	2007-11-08 00:00:00	2007-11-08 00:00:00	2010-04-01 00:00:00	2008-07-01 00:00:00	2009-12-01 00:00:00	2009-07-01 00:00:00	2009-07-01 00:00:00	2010-10-01 00:00:00	2010-04-15 00:00:00	2010-05-10 00:00:00	2011-10-31 00:00:00	2012-03-06 00:00:00	2011-07-18 00:00:00	2012-08-02 00:00:00	2014-03-05 00:00:00	2015-04-01 00:00:00	2015-05-15 00:00:00

Table: received_filings
filer_id	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477	1147477
filing_file_name	852034_0.cal	852034_1.cal	881004_0.cal	881007_0.cal	897726_0.cal	907311_0.cal	907327_0.cal	199708.cal	199748.cal	199802.cal	931170_0.cal	931359_0.cal	945161_0.cal	945167_0.cal	213026.cal	968836_0.cal	968837_0.cal	987764_0.cal	987767_0.cal	1010778_0.cal	1010782_0.cal	7785.cal	7833.cal	7887.cal	518591.cal	518622.cal	518623.cal	518694.cal	176990.cal	177099.cal	177131.cal	177209.cal	187646.cal	187667.cal	1027971_0.cal	165266.cal	164351.cal	185352.cal	1055933_0.cal	1055928_0.cal	1078134_0.cal	1078244_0.cal	1102965_0.cal	1102966_0.cal	1112911_0.cal	1102965_1.cal	1112740_0.cal	342299.cal	342137.cal	341754.cal	342281.cal	1385882_6.cal	1385882_5.cal	1223278_0.cal	1385882_1.cal	1385882_2.cal	1385882_3.cal	1385882_4.cal	1223278_2.cal	1223278_1.cal	1385882_0.cal	1385882_7.cal	1551818_1.cal	1385882_8.cal	1717547_1.cal	1717547_2.cal	1551818_0.cal	1717547_0.cal	390382.cal	283070.cal	283296.cal	325392.cal	283200.cal	291003.cal	1918419_2.cal	1918419_3.cal	2109306_0.cal	1918419_4.cal	1918419_5.cal	1918419_0.cal	146193.cal	165069.cal	1918419_1.cal	504742.cal	504779.cal	504881.cal	504996.cal	505277.cal	162769.cal	2328891_0.cal	2109306_1.cal
received_date	2002-07-26 00:00:00	2002-08-02 00:00:00	2002-10-28 00:00:00	2002-10-28 00:00:00	2002-12-24 00:00:00	2003-01-28 00:00:00	2003-01-28 00:00:00	2002-12-03 00:00:00	2002-12-03 00:00:00	2002-12-03 00:00:00	2003-04-30 00:00:00	2003-04-30 00:00:00	2003-07-28 00:00:00	2003-07-28 00:00:00	2003-07-28 00:00:00	2003-10-30 00:00:00	2003-10-30 00:00:00	2004-01-28 00:00:00	2004-01-28 00:00:00	2004-04-23 00:00:00	2004-04-23 00:00:00	2004-02-05 00:00:00	2004-02-05 00:00:00	2004-02-05 00:00:00	2004-02-04 00:00:00	2004-02-04 00:00:00	2004-02-04 00:00:00	2004-02-04 00:00:00	2004-07-28 00:00:00	2004-07-28 00:00:00	2004-07-28 00:00:00	2004-07-28 00:00:00	2004-07-29 00:00:00	2004-07-29 00:00:00	2004-07-29 00:00:00	2004-07-28 00:00:00	2004-07-28 00:00:00	2004-07-29 00:00:00	2004-10-28 00:00:00	2004-10-28 00:00:00	2005-01-28 00:00:00	2005-01-28 00:00:00	2005-04-26 00:00:00	2005-04-26 00:00:00	2005-07-20 00:00:00	2005-07-20 00:00:00	2005-07-19 00:00:00	2005-07-20 00:00:00	2005-07-20 00:00:00	2005-07-20 00:00:00	2005-07-20 00:00:00	2010-05-18 00:00:00	2010-04-15 00:00:00	2006-12-11 00:00:00	2009-07-14 00:00:00	2009-07-14 00:00:00	2009-07-14 00:00:00	2009-07-14 00:00:00	2007-11-19 00:00:00	2007-11-18 00:00:00	2008-12-29 00:00:00	2010-10-13 00:00:00	2012-08-27 00:00:00	2012-08-27 00:00:00	2013-09-09 00:00:00	2014-03-06 00:00:00	2010-12-17 00:00:00	2012-12-17 00:00:00	2012-03-27 00:00:00	2012-03-22 00:00:00	2012-03-22 00:00:00	2012-03-23 00:00:00	2012-03-22 00:00:00	2012-03-22 00:00:00	2015-05-19 00:00:00	2015-10-27 00:00:00	2016-12-01 00:00:00	2016-03-04 00:00:00	2016-10-15 00:00:00	2014-12-15 00:00:00	2015-04-16 00:00:00	2015-04-17 00:00:00	2015-04-18 00:00:00	2015-04-05 00:00:00	2015-04-05 00:00:00	2015-04-05 00:00:00	2015-04-05 00:00:00	2015-04-05 00:00:00	2015-04-17 00:00:00	2018-12-19 00:00:00	2018-04-30 00:00:00
filing_directory	/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/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/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/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/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/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/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/temp	/cafiler/disclose/ca99/cal	/cafiler/disclose/ca99/cal
filing_id	852034	852034	881004	881007	897726	907311	907327	None	None	None	931170	931359	945161	945167	None	968836	968837	987764	987767	1010778	1010782	None	None	None	None	None	None	None	None	None	None	None	None	None	1027971	None	None	None	1055933	1055928	1078134	1078244	1102965	1102966	1112911	1102965	1112740	None	None	None	None	1385882	1385882	1223278	1385882	1385882	1385882	1385882	1223278	1223278	1385882	1385882	1551818	1385882	1717547	1717547	1551818	1717547	None	None	None	None	None	None	1918419	1918419	2109306	1918419	1918419	1918419	None	None	1918419	None	None	None	None	None	None	2328891	2109306
form_id	F625	F625	F615	F625	F601	F625	F615	None	None	None	F615	F625	F625	F615	None	F615	F625	F615	F625	F625	F615	None	None	None	None	None	None	None	None	None	None	None	None	None	F625	None	None	None	F625	F615	F615	F625	F625	F615	F625	F625	F615	None	None	None	None	F601	F601	F601	F601	F601	F601	F601	F601	F601	F601	F601	F601	F601	F601	F601	F601	F601	None	None	None	None	None	None	F601	F601	F601	F601	F601	F601	None	None	F601	None	None	None	None	None	None	F601	F601
receive_comment	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 passed validation, but failed DB constraints	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing did not pass validation	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 passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing passed validation, but failed DB constraints	Filing 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	Filing did not pass validation	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 did not pass validation	Filing did not pass validation	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 accepted	Filing accepted	Filing did not pass validation	Filing did not pass validation	Filing did not pass validation	Filing did not pass validation	Filing did not pass validation	Filing did not pass validation	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing accepted	Filing did not pass validation	Filing did not pass validation	Filing accepted	Filing did not pass validation	Filing did not pass validation	Filing did not pass validation	Filing did not pass validation	Filing did not pass validation	Filing did not pass validation	Filing accepted	Filing accepted