Home

Filer ID: 1297707

Table: cvr_campaign_disclosure

filing_id		1338601		1308267		1282104		1335534		1369615		1335534		1351377		1397558		1362695		1487700		1491809		1435654		1462509		1492011		1491984		1493553		1491974		1492001		1492006		1492019		1493000		1493010		1493035		1493038		1492999		1504566		1504760		1504743		1504753		1566649		1531082		1521932		1603812		1636303		1661929		1664004		1664004		1677397		1703569		1699516		1693962		1740849		1831893		1821053		1812305		1777198		1846941		1847487		1848513		1881940		1879893		1865644		1859025		1859025		1851588		1849851		1853685		1891153		1882563		1887645		1891681		1892361		1930974		1910067		1904573		1897279		1908837		1897279		1898782		1901476		1901871		1991049		2032829		2011657		1980780		2046876		2047567		2086860		2047567		2046876		2064735		2091105		2173114		2131153		2098425		2154087		2098425		2131153		2098425		2091105		2104058		2102526		2099402		2209185		2258254		2250551		2255300		2249180		2249180		2257364		2247185		2253222		2236975		2257364		2245607		2245607		2236975		2253222		2304709		2313014		2301247		2302856		2276236		2296904		2276236		2257364		2316290		2345973		2455243		2458917		2440927		2489239		2521467		2554683		2532488		2620753		2645669		2671955		2608817		2616031		2664734		2668075		2666146		2664734		2608091		2664734		2599886		2605231		2686060		2723579		2702161		2723844		2727526		2717546		2723579		2742043
amend_id		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		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		1		1		0		0		0		1		2		0		1		0		0		1		0		0		0		0		0		0		0		0		1		1		0		0		0		0		0		1		1		1		0		0		0		0		1		0		0		2		0		0		0		0		0		0		0		0		0		0		0		0		0		0		2		0		0		1		0		0		0		0		0		1		0		0		0		0		0		0
rec_type		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR
form_type		F497		F460		F460		F460		F460		F460		F460		F460		F460		F496		F460		F460		F460		F465		F465		F496		F465		F465		F465		F465		F496		F496		F496		F496		F496		F460		F465		F465		F465		F460		F460		F460		F460		F460		F497		F460		F460		F460		F460		F497		F460		F460		F460		F497		F460		F460		F497		F497		F497		F497		F497		F460		F497		F497		F497		F497		F460		F497		F497		F497		F497		F460		F460		F497		F460		F497		F497		F497		F497		F497		F497		F497		F497		F460		F460		F460		F497		F497		F497		F460		F460		F497		F460		F460		F460		F497		F460		F460		F460		F497		F497		F497		F497		F460		F497		F497		F497		F497		F497		F497		F497		F460		F460		F497		F497		F497		F460		F460		F497		F460		F497		F497		F460		F460		F460		F497		F497		F460		F460		F497		F460		F460		F460		F460		F497		F460		F460		F460		F460		F497		F497		F497		F497		F497		F497		F497		F460		F497		F460		F497		F460		F460		F497		F497		F497		F460
filer_id		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707
entity_cd		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP
filer_naml		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee sponsored by Service Employees International Unions		Service Employees International Union Local 521 Independent Expenditure Committee sponsored by Service Employees International Unions		Service Employees International Union Local 521 Independent Expenditure Committee sponsored by Service Employees International Unions		Service Employees International Union Local 521 Independent Expenditure Committee sponsored by Service Employees International Unions		Service Employees International Union Local 521 Independent Expenditure Committee sponsored by Service Employees International Unions		Service Employees International Union Local 521 Independent Expenditure Committee sponsored by Service Employees International Unions		Service Employees International Union Local 521 Independent Expenditure Committee sponsored by Service Employees International Unions		Service Employees International Union Local 521 Independent Expenditure Committee sponsored by Service Employees International Unions		Service Employees International Union Local 521 Independent Expenditure Committee sponsored by Service Employees International Unions		Service Employees International Union Local 521 Independent Expenditure Committee sponsored by Service Employees International Unions		Service Employees International Union Local 521 Independent Expenditure Committee sponsored by Service Employees International Unions		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee sponsored by Service Employees International Unions		Service Employees International Union Local 521 Independent Expenditure Committee sponsored by Service Employees International Unions		Service Employees International Union Local 521 Independent Expenditure Committee sponsored by Service Employees International Unions		Service Employees International Union Local 521 Independent Expenditure Committee sponsored by Service Employees International Unions		Service Employees International Union Local 521 Independent Expenditure Committee sponsored by Service Employees International Unions		Service Employees International Union Local 521 Independent Expenditure Committee sponsored by Service Employees International Unions		Service Employees International Union Local 521 Independent Expenditure Committee sponsored by Service Employees International Unions		Service Employees International Union Local 521 Independent Expenditure Committee sponsored by Service Employees International Unions
filer_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
filer_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
filer_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
report_num		000		000		000		000		000		001		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		001		000		000		000		000		000		000		000		000		000		000		000		000		000		000		000		001		000		000		000		000		000		000		000		000		000		000		000		000		001		000		000		000		000		000		000		000		000		000		000		000		000		001		001		000		000		000		001		002		000		001		000		000		001		000		000		000		000		000		000		000		000		001		001		000		000		000		000		000		001		001		001		000		000		000		000		001		000		000		002		000		000		000		000		000		000		000		000		000		000		000		000		000		000		002		000		000		001		000		000		000		000		000		001		000		000		000		000		000		000
rpt_date		2008-05-29 00:00:00		2008-01-29 00:00:00		2007-07-27 00:00:00		2008-05-21 00:00:00		2008-10-23 00:00:00		2008-07-31 00:00:00		2008-07-31 00:00:00		2009-02-02 00:00:00		2008-10-06 00:00:00		2010-05-13 00:00:00		2010-05-27 00:00:00		2009-07-29 00:00:00		2010-01-28 00:00:00		2010-05-27 00:00:00		2010-05-27 00:00:00		2010-06-01 00:00:00		2010-05-27 00:00:00		2010-05-27 00:00:00		2010-05-27 00:00:00		2010-05-27 00:00:00		2010-05-28 00:00:00		2010-05-28 00:00:00		2010-05-28 00:00:00		2010-05-28 00:00:00		2010-05-28 00:00:00		2010-07-28 00:00:00		2010-07-28 00:00:00		2010-07-28 00:00:00		2010-07-28 00:00:00		2011-01-25 00:00:00		2010-10-21 00:00:00		2010-10-04 00:00:00		2011-07-26 00:00:00		2012-01-31 00:00:00		2012-05-21 00:00:00		2012-05-24 00:00:00		2012-07-02 00:00:00		2012-07-30 00:00:00		2012-10-25 00:00:00		2012-10-17 00:00:00		2012-10-04 00:00:00		2013-01-30 00:00:00		2014-03-24 00:00:00		2014-02-07 00:00:00		2014-01-22 00:00:00		2013-07-18 00:00:00		2014-05-02 00:00:00		2014-05-06 00:00:00		2014-05-08 00:00:00		2014-09-02 00:00:00		2014-08-22 00:00:00		2014-07-23 00:00:00		2014-06-09 00:00:00		2014-06-06 00:00:00		2014-05-19 00:00:00		2014-05-14 00:00:00		2014-05-22 00:00:00		2014-10-02 00:00:00		2014-09-04 00:00:00		2014-09-23 00:00:00		2014-10-03 00:00:00		2014-10-04 00:00:00		2015-01-23 00:00:00		2014-10-30 00:00:00		2014-10-23 00:00:00		2014-10-14 00:00:00		2014-10-29 00:00:00		2014-10-13 00:00:00		2014-10-15 00:00:00		2014-10-21 00:00:00		2014-10-21 00:00:00		2015-10-06 00:00:00		2016-04-26 00:00:00		2016-01-29 00:00:00		2015-07-30 00:00:00		2016-05-26 00:00:00		2016-05-27 00:00:00		2016-10-10 00:00:00		2016-06-23 00:00:00		2016-08-01 00:00:00		2016-08-01 00:00:00		2016-10-18 00:00:00		2017-07-27 00:00:00		2017-07-28 00:00:00		2017-07-28 00:00:00		2017-04-26 00:00:00		2017-01-31 00:00:00		2017-01-31 00:00:00		2016-10-27 00:00:00		2016-11-02 00:00:00		2016-11-02 00:00:00		2016-10-31 00:00:00		2016-10-28 00:00:00		2018-01-30 00:00:00		2018-05-31 00:00:00		2018-05-18 00:00:00		2018-05-25 00:00:00		2018-05-14 00:00:00		2018-05-31 00:00:00		2018-05-31 00:00:00		2018-05-08 00:00:00		2018-05-23 00:00:00		2018-04-25 00:00:00		2018-05-30 00:00:00		2018-05-03 00:00:00		2018-05-31 00:00:00		2018-06-27 00:00:00		2018-06-27 00:00:00		2018-10-10 00:00:00		2018-10-25 00:00:00		2018-10-03 00:00:00		2018-10-05 00:00:00		2018-09-28 00:00:00		2018-09-27 00:00:00		2018-07-31 00:00:00		2018-09-21 00:00:00		2018-10-30 00:00:00		2019-01-30 00:00:00		2020-02-20 00:00:00		2020-02-26 00:00:00		2020-01-29 00:00:00		2020-08-07 00:00:00		2020-10-22 00:00:00		2021-02-01 00:00:00		2020-11-03 00:00:00		2021-10-26 00:00:00		2022-01-31 00:00:00		2022-04-26 00:00:00		2021-08-25 00:00:00		2021-10-14 00:00:00		2022-04-20 00:00:00		2022-04-20 00:00:00		2022-04-14 00:00:00		2022-04-14 00:00:00		2021-08-23 00:00:00		2022-04-11 00:00:00		2021-07-21 00:00:00		2021-08-06 00:00:00		2022-05-25 00:00:00		2022-10-03 00:00:00		2022-07-25 00:00:00		2022-09-23 00:00:00		2022-10-03 00:00:00		2022-09-06 00:00:00		2022-09-26 00:00:00		2022-10-26 00:00:00
stmt_type		None		SA		SA		PE		PE		PE		SA		SA		PE		None		PE		SA		SA		None		None		None		None		None		None		None		None		None		None		None		None		SA		None		None		None		SA		PE		PE		SA		SA		None		PE		PE		SA		PE		None		PE		SA		PE		None		SA		SA		None		None		None		None		None		SA		None		None		None		None		PE		None		None		None		None		PE		SA		None		PE		None		None		None		None		None		None		None		None		SA		SA		PE		None		None		None		PE		SA		None		SA		SA		PE		None		PE		SA		PE		None		None		None		None		SA		None		None		None		None		None		None		None		PE		PE		None		None		None		PE		PE		None		PE		None		None		SA		PE		SA		None		None		SA		PE		None		SA		SA		PE		SA		None		SY		SA		PE		PE		None		None		None		None		None		None		None		SA		None		PE		None		SA		PE		None		None		None		PE
late_rptno		429		None		None		None		None		None		None		None		None		2594		None		None		None		7743		1345		2847		8765		8743		3658		3695		2832		2826		2836		2837		2831		None		3479		9631		4187		None		None		None		None		None		5847		None		None		None		None		7028		None		None		None		9638		None		None		10568		10613		10692		11968		11842		None		11571		11571		11013		10864		None		12701		12013		12371		12766		None		None		14039		None		13124		13995		13124		13228		13529		13572		15102		16331		None		None		None		17218		19354		17218		None		None		19956		None		None		None		22001		None		None		None		19956		21137		20886		20755		None		25536		24987		25332		24803		24803		25481		24591		None		None		25481		24462		24462		None		None		27610		None		27294		27392		None		None		None		25481		28752		None		None		31912		None		None		None		None		35261		None		None		None		None		36226		36950		37081		36997		36950		35983		36950		None		35889		None		39039		None		None		39218		38618		39039		None
from_date		None		2007-07-01 00:00:00		2007-01-01 00:00:00		2008-01-01 00:00:00		2008-10-01 00:00:00		2008-01-01 00:00:00		2008-05-18 00:00:00		2008-10-19 00:00:00		2008-07-01 00:00:00		None		2010-01-01 00:00:00		2009-01-01 00:00:00		2009-07-01 00:00:00		2010-01-01 00:00:00		2010-01-01 00:00:00		None		2010-01-01 00:00:00		2010-01-01 00:00:00		2010-01-01 00:00:00		2010-01-01 00:00:00		None		None		None		None		None		2010-05-23 00:00:00		2010-01-01 00:00:00		2010-05-23 00:00:00		2010-01-01 00:00:00		2010-10-17 00:00:00		2010-10-01 00:00:00		2010-07-01 00:00:00		2011-01-01 00:00:00		2011-07-01 00:00:00		None		2012-01-01 00:00:00		2012-01-01 00:00:00		2012-05-20 00:00:00		2012-10-01 00:00:00		None		2012-07-01 00:00:00		2012-10-21 00:00:00		2014-01-01 00:00:00		None		2013-07-01 00:00:00		2013-01-01 00:00:00		None		None		None		None		None		2014-05-18 00:00:00		None		None		None		None		2014-03-18 00:00:00		None		None		None		None		2014-07-01 00:00:00		2014-10-19 00:00:00		None		2014-10-01 00:00:00		None		None		None		None		None		None		None		None		2015-07-01 00:00:00		2015-01-01 00:00:00		2016-01-01 00:00:00		None		None		None		2016-01-01 00:00:00		2016-05-22 00:00:00		None		2017-01-01 00:00:00		2016-10-23 00:00:00		2016-07-01 00:00:00		None		2016-07-01 00:00:00		2016-10-23 00:00:00		2016-07-01 00:00:00		None		None		None		None		2017-07-01 00:00:00		None		None		None		None		None		None		None		2018-04-22 00:00:00		2018-01-01 00:00:00		None		None		None		2018-01-01 00:00:00		2018-04-22 00:00:00		None		2018-09-23 00:00:00		None		None		2018-05-20 00:00:00		2018-07-01 00:00:00		2018-05-20 00:00:00		None		None		2018-10-21 00:00:00		2020-01-19 00:00:00		None		2019-07-01 00:00:00		2020-02-16 00:00:00		2020-07-01 00:00:00		2020-10-18 00:00:00		None		2021-08-23 00:00:00		2021-10-01 00:00:00		2022-01-01 00:00:00		2021-07-01 00:00:00		None		None		None		None		None		None		None		2021-01-01 00:00:00		None		2022-04-24 00:00:00		None		2022-05-22 00:00:00		2022-07-01 00:00:00		None		None		None		2022-09-22 00:00:00
thru_date		None		2007-12-31 00:00:00		2007-06-30 00:00:00		2008-05-17 00:00:00		2008-10-18 00:00:00		2008-05-17 00:00:00		2008-06-30 00:00:00		2008-12-31 00:00:00		2008-09-30 00:00:00		None		2010-05-22 00:00:00		2009-06-30 00:00:00		2009-12-31 00:00:00		2010-05-22 00:00:00		2010-05-22 00:00:00		None		2010-05-22 00:00:00		2010-05-22 00:00:00		2010-05-22 00:00:00		2010-05-22 00:00:00		None		None		None		None		None		2010-06-30 00:00:00		2010-06-30 00:00:00		2010-06-30 00:00:00		2010-06-30 00:00:00		2010-12-31 00:00:00		2010-10-16 00:00:00		2010-09-30 00:00:00		2011-06-30 00:00:00		2011-12-31 00:00:00		None		2012-05-19 00:00:00		2012-05-19 00:00:00		2012-06-30 00:00:00		2012-10-20 00:00:00		None		2012-09-30 00:00:00		2012-12-31 00:00:00		2014-03-17 00:00:00		None		2013-12-31 00:00:00		2013-06-30 00:00:00		None		None		None		None		None		2014-06-30 00:00:00		None		None		None		None		2014-05-17 00:00:00		None		None		None		None		2014-09-30 00:00:00		2014-12-31 00:00:00		None		2014-10-18 00:00:00		None		None		None		None		None		None		None		None		2015-12-31 00:00:00		2015-06-30 00:00:00		2016-05-21 00:00:00		None		None		None		2016-05-21 00:00:00		2016-06-30 00:00:00		None		2017-06-30 00:00:00		2016-12-31 00:00:00		2016-10-22 00:00:00		None		2016-10-22 00:00:00		2016-12-31 00:00:00		2016-10-22 00:00:00		None		None		None		None		2017-12-31 00:00:00		None		None		None		None		None		None		None		2018-05-19 00:00:00		2018-04-21 00:00:00		None		None		None		2018-04-21 00:00:00		2018-05-19 00:00:00		None		2018-10-20 00:00:00		None		None		2018-06-30 00:00:00		2018-09-22 00:00:00		2018-06-30 00:00:00		None		None		2018-12-31 00:00:00		2020-02-15 00:00:00		None		2019-12-31 00:00:00		2020-06-30 00:00:00		2020-10-17 00:00:00		2020-12-31 00:00:00		None		2021-09-30 00:00:00		2021-12-31 00:00:00		2022-04-23 00:00:00		2021-08-22 00:00:00		None		None		None		None		None		None		None		2021-06-30 00:00:00		None		2022-05-21 00:00:00		None		2022-06-30 00:00:00		2022-09-21 00:00:00		None		None		None		2022-10-22 00:00:00
elect_date		None		None		None		2008-06-03 00:00:00		2008-11-04 00:00:00		2008-06-03 00:00:00		None		None		2008-11-04 00:00:00		None		2010-06-08 00:00:00		None		None		2010-06-08 00:00:00		2010-06-08 00:00:00		None		2010-06-08 00:00:00		2010-06-08 00:00:00		2010-06-08 00:00:00		2010-06-08 00:00:00		None		None		None		None		None		None		2010-06-08 00:00:00		2010-06-08 00:00:00		2010-06-08 00:00:00		None		2010-11-02 00:00:00		2010-11-02 00:00:00		None		None		None		2012-06-05 00:00:00		2012-06-05 00:00:00		None		2012-11-06 00:00:00		None		2012-11-06 00:00:00		None		2014-06-03 00:00:00		None		None		None		None		None		None		None		None		None		None		None		None		None		2014-06-03 00:00:00		None		None		None		None		2014-11-04 00:00:00		None		None		2014-11-04 00:00:00		None		None		None		None		None		None		None		None		None		None		2016-06-07 00:00:00		None		None		None		2016-06-07 00:00:00		None		None		None		None		2016-11-08 00:00:00		None		2016-11-08 00:00:00		None		2016-11-08 00:00:00		None		None		None		None		None		None		None		None		None		None		None		None		2018-06-05 00:00:00		2018-06-05 00:00:00		None		None		None		2018-06-05 00:00:00		2018-06-05 00:00:00		None		2018-11-06 00:00:00		None		None		None		2018-11-06 00:00:00		None		None		None		None		2020-03-03 00:00:00		None		None		None		2020-11-03 00:00:00		None		None		None		None		2022-06-07 00:00:00		2021-09-27 00:00:00		None		2021-09-27 00:00:00		2021-09-27 00:00:00		2021-09-27 00:00:00		2021-09-27 00:00:00		None		2021-09-27 00:00:00		None		None		2022-06-07 00:00:00		2022-09-26 00:00:00		None		2022-09-26 00:00:00		2022-09-26 00:00:00		2022-11-08 00:00:00		2022-09-26 00:00:00		2022-11-08 00:00:00
filer_city		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose
filer_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
filer_zip4		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131
filer_phon		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300
filer_fax		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		None		None		(408) 954-0631		None		None		None		None		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		None		None		None		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631
file_email		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		compliance@olsonremcho.com		compliance@olsonremcho.com		compliance@olsonremcho.com		compliance@olsonremcho.com		compliance@olsonremcho.com		compliance@olsonremcho.com		compliance@olsonremcho.com		compliance@olsonremcho.com		compliance@olsonremcho.com		compliance@olsonremcho.com		compliance@olsonremcho.com		compliance@olsonremcho.com		compliance@olsonremcho.com		compliance@olsonremcho.com		compliance@olsonremcho.com		compliance@olsonremcho.com		compliance@olsonremcho.com		compliance@olsonremcho.com		compliance@olsonremcho.com		compliance@olsonremcho.com		compliance@olsonremcho.com		compliance@olsonremcho.com		compliance@olsonremcho.com		compliance@olsonremcho.com		compliance@olsonremcho.com		compliance@olsonremcho.com		compliance@olsonremcho.com		compliance@olsonremcho.com
mail_city		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento
mail_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
mail_zip4		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814
tres_naml		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		None		None		None		None		Mendez		None		Mendez		Mendez		Mendez		None		Mendez		Mendez		None		None		None		Mendez
tres_namf		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko		None		None		None		None		Riko		None		Riko		Riko		Riko		None		Riko		Riko		None		None		None		Riko
tres_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
tres_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
tres_city		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		None		None		None		None		San Jose		None		San Jose		San Jose		San Jose		None		San Jose		San Jose		None		None		None		San Jose
tres_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		None		None		None		None		CA		None		CA		CA		CA		None		CA		CA		None		None		None		CA
tres_zip4		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		None		None		None		None		95131		None		95131		95131		95131		None		95131		95131		None		None		None		95131
tres_phon		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		None		None		None		None		(408) 678-3300		None		(408) 678-3300		(408) 678-3300		(408) 678-3300		None		(408) 678-3300		(408) 678-3300		None		None		None		(408) 678-3300
tres_fax		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_email		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cmtte_type		None		G		G		G		G		G		G		G		G		None		G		G		G		G		G		None		G		G		G		G		None		None		None		None		None		G		G		G		G		G		G		G		G		G		None		G		G		G		G		None		G		G		G		None		G		G		None		None		None		None		None		G		None		None		None		None		G		None		None		None		None		G		G		None		G		None		None		None		None		None		None		None		None		G		G		G		None		None		None		G		G		None		G		G		G		None		G		G		G		None		None		None		None		G		None		None		None		None		None		None		None		G		G		None		None		None		G		G		None		G		None		None		G		G		G		None		None		G		G		None		G		G		G		G		None		G		G		G		G		None		None		None		None		None		None		None		G		None		G		None		G		G		None		None		None		G
control_yn		None		Y		Y		Y		Y		Y		Y		Y		Y		None		Y		Y		Y		N		N		None		N		N		N		N		None		None		None		None		None		Y		N		N		N		Y		Y		Y		Y		Y		None		Y		Y		Y		Y		None		Y		Y		Y		None		Y		Y		None		None		None		None		None		Y		None		None		None		None		Y		None		None		None		None		Y		Y		None		Y		None		None		None		None		None		None		None		None		Y		Y		Y		None		None		None		Y		Y		None		Y		Y		Y		None		Y		Y		Y		None		None		None		None		Y		None		None		None		None		None		None		None		Y		Y		None		None		None		Y		Y		None		Y		None		None		Y		Y		Y		None		None		Y		Y		None		Y		Y		Y		Y		None		Y		Y		Y		Y		None		None		None		None		None		None		None		Y		None		Y		None		Y		Y		None		None		None		Y
sponsor_yn		None		N		N		N		N		N		N		N		N		None		N		N		N		Y		Y		None		Y		Y		Y		Y		None		None		None		None		None		N		Y		Y		Y		N		N		N		N		N		None		N		N		N		N		None		N		N		N		None		N		N		None		None		None		None		None		N		None		None		None		None		N		None		None		None		None		N		N		None		N		None		None		None		None		None		None		None		None		N		N		N		None		None		None		N		N		None		N		N		N		None		N		N		N		None		None		None		None		N		None		None		None		None		None		None		None		N		N		None		None		None		N		N		None		N		None		None		N		N		N		None		None		N		N		None		N		N		N		N		None		N		N		N		N		None		None		None		None		None		None		None		N		None		N		None		N		N		None		None		None		N
primfrm_yn		None		N		N		N		N		N		N		N		N		None		N		N		N		N		N		None		N		N		N		N		None		None		None		None		None		N		N		N		N		N		N		N		N		N		None		N		N		N		N		None		N		N		N		None		N		N		None		None		None		None		None		N		None		None		None		None		N		None		None		None		None		N		N		None		N		None		None		None		None		None		None		None		None		N		N		N		None		None		None		N		N		None		N		N		N		None		N		N		N		None		None		None		None		N		None		None		None		None		None		None		None		N		N		None		None		None		N		N		None		N		None		None		N		N		N		None		None		N		N		None		N		N		N		N		None		N		N		N		N		None		None		None		None		None		None		None		N		None		N		None		N		N		None		None		None		N
brdbase_yn		None		None		None		None		None		None		None		None		None		None		None		None		None		N		N		None		N		N		N		N		None		None		None		None		None		None		N		N		N		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
amendexp_1		None		None		None		None		None		Update Summary Page, Schedule D and Schedule F		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Update Summary page, Schedule D, Schedule F and Schedule G		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Update late contribution		None		None		None		None		None		None		None		None		None		None		None		None		Update late contribution		None		None		None		None		None		None		None		None		None		None		None		None		Update contributions made.		Update summary page, schedules D, F and G		None		None		None		Update Summary Page and Schedule F		Update Summary Page and Schedule F		None		Update summary page, Schedule F.		None		None		Update contributions made.		None		None		None		None		None		None		None		None		Update contributions made.		Update contributions made.		None		None		None		None		None		Update contributions made.		Update Summary Page, Schedule D and Schedule F.		Update Summary Page, Schedule D and Schedule F.		None		None		None		None		Update Summary Page, Schedule D, Schedule F and Schedule G.		None		None		Update contributions made.		None		None		None		None		None		None		None		None		None		None		None		None		None		None		Amend to remove contribution		None		None		Amend to remove contribution		None		None		None		None		None		Amend to update contributions made.		None		None		None		None		None		None
amendexp_2		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
amendexp_3		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
rpt_att_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cmtte_id		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
reportname		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
rptfromdt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
rptthrudt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
emplbus_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bus_name		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bus_city		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bus_st		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bus_zip4		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bus_inter		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
busact_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
busactvity		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
assoc_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
assoc_int		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
other_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
other_int		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_naml		None		None		None		None		None		None		None		None		None		Janet Barnes		None		None		None		Janet Barnes		Robert Rivas		Robert Rivas		Steven Worthley		Reb Monaco		Bernita Jenkins		Mike Ennis		Janet Barnes		Rich Gordon		Bernita Jenkins		Reb Monaco		Luis Alejo		None		Rich Gordon		Janet Barnes		Luis Alejo		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_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
cand_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
cand_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
cand_city		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_st		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_zip4		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_phon		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_fax		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_email		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_name		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_num		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_juris		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
office_cd		None		None		None		None		None		None		None		None		None		ASM		None		None		None		ASM		CSU		CSU		CSU		CSU		CSU		CSU		ASM		ASM		CSU		CSU		ASM		None		ASM		ASM		ASM		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
offic_dscr		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
juris_cd		None		None		None		None		None		None		None		None		None		ASM		None		None		None		ASM		OTH		OTH		OTH		OTH		OTH		OTH		ASM		ASM		OTH		OTH		ASM		None		ASM		ASM		ASM		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
juris_dscr		None		None		None		None		None		None		None		None		None		None		None		None		None		None		San Benito County		San Benito County		Tulare County		San Benito County		Kern County		Tulare County		None		None		Kern County		San Benito County		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
dist_no		None		None		None		None		None		None		None		None		None		28		None		None		None		28		3		3		4		4		2		5		28		21		2		4		28		None		21		28		28		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
off_s_h_cd		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
sup_opp_cd		None		None		None		None		None		None		None		None		None		O		None		None		None		O		S		S		O		S		S		O		O		S		S		S		S		None		S		O		S		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
employer		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
occupation		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
selfemp_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bal_id		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
cand_id		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: cvr_so

filing_id		1331343		1331343		1331343		1331343		1331343		1331343		1331343		1331343		1331343		1331343		1331343		1331343		1331343		1331343		1331343		1331343		1331343		1331343
amend_id		2		0		1		4		3		5		6		7		9		8		10		11		12		13		14		15		16		17
rec_type		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR		CVR
form_type		F410		F410		F410		F410		F410		F410		F410		F410		F410		F410		F410		F410		F410		F410		F410		F410		F410		F410
filer_id		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707
entity_cd		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP		RCP
filer_naml		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee		Service Employees International Union Local 521 Independent Expenditure Committee sponsored by Service Employees International Unions
filer_namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filer_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filer_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
report_num		002		000		001		004		003		005		006		007		009		008		010		011		012		013		014		015		016		017
rpt_date		2008-07-24 00:00:00		2008-05-07 00:00:00		2008-05-07 00:00:00		2008-10-07 00:00:00		2008-09-24 00:00:00		2009-01-12 00:00:00		2010-04-20 00:00:00		2012-10-18 00:00:00		2013-04-15 00:00:00		2013-01-30 00:00:00		2013-12-11 00:00:00		2016-08-01 00:00:00		2018-01-30 00:00:00		2018-03-28 00:00:00		2019-01-24 00:00:00		2019-07-25 00:00:00		2020-01-30 00:00:00		2021-08-25 00:00:00
qual_cb		None		None		None		None		None		None		None		None		X		X		X		X		X		X		X		X		X		X
qualfy_dt		2007-09-30 00:00:00		2007-09-30 00:00:00		2007-09-30 00:00:00		2007-09-30 00:00:00		2007-09-30 00:00:00		2007-09-30 00:00:00		2007-09-30 00:00:00		2007-09-30 00:00:00		2007-09-30 00:00:00		2007-09-30 00:00:00		2007-09-30 00:00:00		2007-09-30 00:00:00		2007-09-30 00:00:00		2007-09-30 00:00:00		2007-09-30 00:00:00		2007-09-30 00:00:00		2007-09-30 00:00:00		2007-09-30 00:00:00
term_date		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
city		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose
st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
zip4		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131
phone		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300
county_res		Santa Clara		Santa Clara		Santa Clara		Santa Clara		Santa Clara		Santa Clara		Santa Clara		Santa Clara		Santa Clara		Santa Clara		Santa Clara		Santa Clara		Santa Clara		Santa Clara		Santa Clara		Santa Clara		Santa Clara		Santa Clara
county_act		None		None		None		None		None		None		None		None		State		State		State		State		State		State		Santa Clara County		Santa Clara County		Statewide		Statewide
mail_city		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento
mail_st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
mail_zip4		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814
cmte_fax		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631		(408) 954-0631
cmte_email		None		None		None		None		None		None		None		None		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		info@olsonhagel.com		compliance@olsonremcho.com		compliance@olsonremcho.com
tres_naml		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Sermersheim		Mendez		Sermersheim		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez		Mendez
tres_namf		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Kristina M.		Riko		Kristina M.		Riko		Riko		Riko		Riko		Riko		Riko		Riko		Riko
tres_namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
tres_city		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose		San Jose
tres_st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
tres_zip4		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131		95131
tres_phon		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 954-8715		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300		(408) 678-3300
actvty_lvl		ST		ST		ST		ST		ST		ST		ST		ST		ST		ST		ST		ST		ST		ST		CO		CO		ST		ST
com82013yn		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
com82013nm		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
com82013id		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
control_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bank_nam		None		None		None		None		None		None		None		None		Wells Fargo Bank		Wells Fargo Bank		Wells Fargo Bank		Wells Fargo Bank		Wells Fargo Bank		Wells Fargo Bank		Wells Fargo Bank		Wells Fargo Bank		Wells Fargo Bank		Wells Fargo Bank
bank_adr1		None		None		None		None		None		None		None		None		400 Capitol Mall		400 Capitol Mall		400 Capitol Mall		400 Capitol Mall		400 Capitol Mall		400 Capitol Mall		400 Capitol Mall		400 Capitol Mall		400 Capitol Mall		400 Capitol Mall
bank_adr2		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
bank_city		None		None		None		None		None		None		None		None		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento		Sacramento
bank_st		None		None		None		None		None		None		None		None		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
bank_zip4		None		None		None		None		None		None		None		None		95814		95814		95814		95814		95814		95814		95814		95814		95814		95814
bank_phon		None		None		None		None		None		None		None		None		(916)440-4205		(916)440-4205		(916)440-4205		(916)440-4205		(916)440-4205		(916)440-4205		(916)440-4205		(916)440-4205		(916)440-4205		(916)440-4205
acct_opendt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
surplusdsp		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
primfc_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
genpurp_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		X		X		X		X
gpc_descr		To conduct independent expenditures in state and local elections and to make contributions to local candidates.		To conduct independent expenditures in state and local elections.		To conduct independent expenditures in state and local elections.		To conduct independent expenditures in state and local elections and to make contributions to local candidates.		To conduct independent expenditures in state and local elections and to make contributions to local candidates.		To conduct independent expenditures in state and local elections and to make contributions to local candidates.		To conduct independent expenditures in state and local elections and to make contributions to local candidates.		To conduct independent expenditures in state and local elections and to make contributions to local candidates.		To conduct independent expenditures in state and local elections and to make contributions to local candidates.		To conduct independent expenditures in state and local elections and to make contributions to local candidates.		To conduct independent expenditures in state and local elections and make other permissible expenditures		To conduct independent expenditures in state and local elections and make other permissible expenditures		To conduct independent expenditures in state and local elections and make other permissible expenditures		To conduct independent expenditures in state and local elections and make other permissible expenditures		To conduct independent expenditures in state and local elections and make other permissible expenditures		To conduct independent expenditures in state and local elections and make other permissible expenditures		To conduct independent expenditures in state and local elections and make other permissible expenditures		To conduct independent expenditures in state and local elections and make other permissible expenditures
sponsor_cb		None		None		None		None		None		None		None		None		None		None		None		X		X		X		X		X		X		X
brdbase_cb		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
smcont_qualdt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: filer_address

filer_id		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707
adrid		2122850		2122852		2141321		2152617		2152618		2153977		2493593		2493592		2248865		2287607		2287606		2452137		2452136
effect_dt		2007-05-01 00:00:00		2007-05-01 00:00:00		2007-09-30 00:00:00		2007-09-30 00:00:00		2007-09-30 00:00:00		2008-09-24 00:00:00		2020-01-30 00:00:00		2020-01-30 00:00:00		2012-10-18 00:00:00		2013-01-31 00:00:00		2013-01-31 00:00:00		2018-03-27 00:00:00		2018-03-27 00:00:00
add_type		7051		7082		7082		7051		7082		7051		7051		7082		7051		7082		7051		7082		7051
session_id		2007		2007		2007		2007		2007		2007		2019		2019		2011		2013		2013		2017		2017

Table: filer_filings

filer_id		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707
filing_id		1282276		1262810		1308267		1282104		1765287		1777198		1784499		1975324		1847487		1859025		1865644		1854542		1853685		1859025		1867388		1331343		1807463		1943198		1908837		1891681		1910067		1901871		1897279		1893920		1897279		1904573		1898782		1262810		1331343		1331343		1335036		1338901		1335534		1309486		1338601		1335534		1351377		1331343		1331343		1369615		1352325		1335036		1367434		1362695		1370866		1262810		1331343		1362966		1331343		1403438		1397558		1398208		1367434		1435654		1440434		1466203		1462509		1483083		1331343		1493553		1492011		1487700		1504743		1491984		1504753		1491809		1492001		1492006		1492019		1491974		1492999		1493000		1493010		1493035		1493038		1510190		1510191		1510193		1526800		1504760		1504566		1494561		1495193		1509026		1532377		1531082		1566649		1570335		1521932		1603812		1604189		1636303		1638617		1664004		1666740		1666740		1677397		1661929		1664004		1813654		1821053		1831893		1812305		1681660		1694488		1693962		1699516		1331343		1930974		1915675		1901476		1713515		1703569		1705254		1891153		1892361		1881940		1882563		1879893		1887645		1740849		1331343		1846941		1848513		1849851		1851588		1833766		1743669		1757026		1331343		1991049		1980780		1986655		2249180		2304709		2247185		2253222		2212719		2257364		2302856		2245607		2316290		2296904		2277827		1331343		2276236		2253222		2532488		2250551		1331343		1331343		2521467		2258254		2236975		2313014		2249180		2257364		2450490		2011657		2018991		2032829		2066667		2046876		2064735		2046876		2047567		2047567		2052258		2077726		1331343		2086860		2091105		2098425		2052258		2102526		2091105		2104058		2099402		2108615		2154087		2131153		2145477		2098425		2131153		2173114		2098425		2108615		2345973		2174322		2301102		2253369		2277827		2217395		2458917		2440927		2494617		2359533		2145477		2108615		2319640		2253369		2237381		2237381		2590846		2227879		2255300		2209185		2236975		2396341		2276236		2301247		2245607		2455243		1331343		2353086		2257364		1331343		2445952		2620753		2609179		2608935		2599886		2645669		2650979		2686060		2664734		2668075		2608091		2489239		2676741		2626086		2664734		1331343		2608817		2723579		2554683		2723844		2616031		2671955		2609804		2605231		2702161		2666146		2626523		2688061		2620064		2717546		2664734		2615782		2615783		2615788		2742043		2732082		2723579		2732997		2727526
period_id		None		None		191		189		None		213		None		None		218		218		218		None		217		218		None		216		None		None		220		220		220		220		220		None		220		220		220		None		194		194		None		None		193		None		194		193		194		195		196		196		None		None		None		195		None		None		195		None		197		None		196		None		None		197		None		None		199		None		202		202		201		202		202		201		201		201		201		201		201		201		202		202		202		202		202		None		None		None		None		201		202		None		None		None		None		204		204		None		203		205		None		207		None		209		None		None		210		210		209		None		217		217		215		None		None		211		212		212		220		None		220		None		212		None		220		219		219		219		219		219		212		213		218		218		218		218		None		None		None		214		224		221		None		234		236		234		234		None		234		236		234		236		235		None		233		234		234		244		234		233		237		243		234		233		235		234		234		None		223		None		226		None		225		226		225		226		226		None		None		227		228		228		227		None		228		228		228		228		None		230		228		None		227		228		229		227		None		236		None		None		None		None		None		241		239		None		None		None		None		None		None		None		None		None		None		234		231		233		None		234		236		234		241		239		None		235		241		None		247		None		None		245		248		None		250		250		250		247		241		None		None		250		247		247		251		244		251		248		249		None		247		250		250		None		None		None		251		250		None		None		None		251		None		252		None		252
form_id		F460		F410		F460		F460		F410		F460		F460		F666		F497		F497		F460		F460		F460		F497		F460		F410		F410		F460		F497		F497		F497		F497		F497		F460		F497		F460		F497		F410		F410		F410		F460		F497		F460		F460		F497		F460		F460		F410		F410		F460		F460		F460		F410		F460		F460		F410		F410		F460		F410		F410		F460		F460		F410		F460		F460		F460		F460		F410		F410		F496		F465		F496		F465		F465		F465		F460		F465		F465		F465		F465		F496		F496		F496		F496		F496		F465		F465		F465		F460		F465		F460		F460		F465		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F460		F460		F497		F460		F460		F460		F460		F460		F497		F410		F460		F460		F497		F410		F460		F460		F497		F460		F497		F497		F497		F497		F460		F410		F497		F497		F497		F497		F460		F460		F410		F410		F497		F460		F460		F497		F497		F497		F460		F410		F497		F497		F497		F497		F460		F460		F410		F460		F460		F497		F497		F410		F410		F460		F497		F460		F460		F497		F497		F410		F460		F460		F497		F410		F460		F460		F460		F497		F497		F460		F460		F410		F497		F497		F460		F460		F497		F497		F497		F497		F460		F497		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F410		F497		F460		F460		F410		F460		F497		F497		F460		F410		F410		F497		F410		F460		F460		F460		F410		F460		F460		F460		F460		F497		F497		F497		F460		F460		F460		F497		F410		F460		F497		F460		F460		F497		F460		F410		F497		F460		F497		F460		F460		F460		F497		F497		F460		F460		F460		F460		F460		F497		F460		F497
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		10		0		0		0		0		0		0		1		0		0		0		0		1		0		1		0		0		0		0		0		1		0		2		4		0		0		1		0		0		0		2		3		0		5		0		0		0		1		0		0		0		0		0		6		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		0		0		0		0		0		0		0		0		7		0		0		0		0		0		0		0		0		0		0		0		0		0		8		0		0		0		0		0		0		0		9		0		0		0		0		0		0		0		0		0		0		0		0		0		0		13		0		1		0		0		12		14		0		0		0		0		1		1		0		0		0		0		0		1		0		0		0		1		0		0		11		0		0		0		1		0		1		0		0		0		0		0		0		1		1		0		2		1		0		0		0		1		1		0		0		0		0		0		1		2		0		0		1		0		0		0		0		0		1		0		1		0		1		0		15		0		2		16		0		0		0		0		0		0		0		0		2		0		0		0		0		0		0		17		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		1		0		0
filing_date		2007-07-27 00:00:00		2007-05-01 00:00:00		2008-01-29 00:00:00		2007-07-27 00:00:00		2013-04-15 00:00:00		2013-07-22 00:00:00		2013-07-22 00:00:00		2015-06-30 00:00:00		2014-05-06 00:00:00		2014-06-06 00:00:00		2014-07-23 00:00:00		2014-05-22 00:00:00		2014-05-22 00:00:00		2014-06-09 00:00:00		2014-07-23 00:00:00		2013-12-11 00:00:00		2013-12-11 00:00:00		2015-01-27 00:00:00		2014-10-29 00:00:00		2014-10-03 00:00:00		2014-10-30 00:00:00		2014-10-21 00:00:00		2014-10-14 00:00:00		2014-10-06 00:00:00		2014-10-13 00:00:00		2014-10-23 00:00:00		2014-10-15 00:00:00		2008-05-07 00:00:00		2008-05-07 00:00:00		2008-05-07 00:00:00		2008-05-22 00:00:00		2008-05-29 00:00:00		2008-05-22 00:00:00		2008-01-29 00:00:00		2008-05-29 00:00:00		2008-07-31 00:00:00		2008-07-31 00:00:00		2008-07-24 00:00:00		2008-10-07 00:00:00		2008-10-23 00:00:00		2008-07-31 00:00:00		2008-07-31 00:00:00		2008-09-24 00:00:00		2008-10-06 00:00:00		2008-10-23 00:00:00		2008-07-24 00:00:00		2008-09-24 00:00:00		2008-10-06 00:00:00		2009-01-12 00:00:00		2009-01-12 00:00:00		2009-02-02 00:00:00		2009-02-02 00:00:00		2008-10-07 00:00:00		2009-07-29 00:00:00		2009-07-29 00:00:00		2010-01-28 00:00:00		2010-01-28 00:00:00		2010-04-21 00:00:00		2010-04-20 00:00:00		2010-06-01 00:00:00		2010-05-27 00:00:00		2010-05-13 00:00:00		2010-07-28 00:00:00		2010-05-27 00:00:00		2010-07-28 00:00:00		2010-05-27 00:00:00		2010-05-27 00:00:00		2010-05-27 00:00:00		2010-05-27 00:00:00		2010-05-27 00:00:00		2010-05-28 00:00:00		2010-05-28 00:00:00		2010-05-28 00:00:00		2010-05-28 00:00:00		2010-05-28 00:00:00		2010-07-28 00:00:00		2010-07-28 00:00:00		2010-07-28 00:00:00		2010-10-04 00:00:00		2010-07-28 00:00:00		2010-07-28 00:00:00		2010-05-27 00:00:00		2010-05-28 00:00:00		2010-07-28 00:00:00		2010-10-21 00:00:00		2010-10-21 00:00:00		2011-01-26 00:00:00		2011-01-26 00:00:00		2010-10-04 00:00:00		2011-07-26 00:00:00		2011-07-26 00:00:00		2012-01-31 00:00:00		2012-01-31 00:00:00		2012-05-24 00:00:00		2012-05-24 00:00:00		2012-07-02 00:00:00		2012-07-30 00:00:00		2012-05-21 00:00:00		2012-07-02 00:00:00		2014-01-23 00:00:00		2014-02-07 00:00:00		2014-03-24 00:00:00		2014-01-23 00:00:00		2012-07-30 00:00:00		2012-10-04 00:00:00		2012-10-04 00:00:00		2012-10-17 00:00:00		2012-10-18 00:00:00		2015-01-27 00:00:00		2014-10-23 00:00:00		2014-10-21 00:00:00		2012-10-18 00:00:00		2012-10-25 00:00:00		2012-10-25 00:00:00		2014-10-02 00:00:00		2014-10-06 00:00:00		2014-09-02 00:00:00		2014-09-04 00:00:00		2014-08-22 00:00:00		2014-09-23 00:00:00		2013-01-31 00:00:00		2013-01-31 00:00:00		2014-05-02 00:00:00		2014-05-08 00:00:00		2014-05-14 00:00:00		2014-05-19 00:00:00		2014-03-24 00:00:00		2013-01-31 00:00:00		2013-01-31 00:00:00		2013-04-15 00:00:00		2015-10-07 00:00:00		2015-07-30 00:00:00		2015-07-30 00:00:00		2018-05-14 00:00:00		2018-10-10 00:00:00		2018-05-08 00:00:00		2018-05-24 00:00:00		2018-01-30 00:00:00		2018-05-30 00:00:00		2018-10-05 00:00:00		2018-05-03 00:00:00		2018-10-29 00:00:00		2018-09-27 00:00:00		2018-07-31 00:00:00		2018-03-28 00:00:00		2018-07-31 00:00:00		2018-06-27 00:00:00		2020-11-03 00:00:00		2018-05-18 00:00:00		2018-01-30 00:00:00		2019-01-24 00:00:00		2020-10-22 00:00:00		2018-05-31 00:00:00		2018-04-26 00:00:00		2018-10-25 00:00:00		2018-05-31 00:00:00		2018-05-31 00:00:00		2020-01-30 00:00:00		2016-02-01 00:00:00		2016-01-29 00:00:00		2016-04-26 00:00:00		2016-08-01 00:00:00		2016-08-01 00:00:00		2016-08-01 00:00:00		2016-05-26 00:00:00		2016-05-27 00:00:00		2016-06-24 00:00:00		2016-05-26 00:00:00		2016-08-01 00:00:00		2016-08-01 00:00:00		2016-10-10 00:00:00		2016-10-18 00:00:00		2016-10-27 00:00:00		2016-08-02 00:00:00		2016-10-31 00:00:00		2016-11-02 00:00:00		2016-11-02 00:00:00		2016-10-28 00:00:00		2016-10-27 00:00:00		2017-04-26 00:00:00		2017-01-31 00:00:00		2017-01-31 00:00:00		2017-02-01 00:00:00		2017-07-28 00:00:00		2017-07-27 00:00:00		2017-07-28 00:00:00		2017-02-01 00:00:00		2019-01-30 00:00:00		2017-07-27 00:00:00		2018-09-27 00:00:00		2018-06-27 00:00:00		2018-09-28 00:00:00		2018-01-30 00:00:00		2020-02-26 00:00:00		2020-01-30 00:00:00		2020-08-07 00:00:00		2019-01-31 00:00:00		2017-07-28 00:00:00		2017-07-28 00:00:00		2018-10-25 00:00:00		2018-05-24 00:00:00		2018-06-27 00:00:00		2018-04-26 00:00:00		2021-02-01 00:00:00		2018-03-27 00:00:00		2018-05-25 00:00:00		2018-01-30 00:00:00		2018-06-27 00:00:00		2019-07-26 00:00:00		2018-10-01 00:00:00		2018-10-03 00:00:00		2018-05-31 00:00:00		2020-02-20 00:00:00		2019-07-26 00:00:00		2019-01-23 00:00:00		2018-09-21 00:00:00		2020-01-30 00:00:00		2020-01-30 00:00:00		2021-10-27 00:00:00		2021-08-25 00:00:00		2021-08-25 00:00:00		2021-07-29 00:00:00		2022-01-31 00:00:00		2022-01-26 00:00:00		2022-05-25 00:00:00		2022-04-20 00:00:00		2022-04-20 00:00:00		2021-08-23 00:00:00		2020-08-07 00:00:00		2022-04-28 00:00:00		2021-09-02 00:00:00		2022-04-11 00:00:00		2021-08-25 00:00:00		2021-08-25 00:00:00		2022-09-26 00:00:00		2021-02-01 00:00:00		2022-09-26 00:00:00		2021-10-14 00:00:00		2022-04-27 00:00:00		2021-08-31 00:00:00		2021-08-06 00:00:00		2022-07-27 00:00:00		2022-04-14 00:00:00		2021-10-28 00:00:00		2022-05-26 00:00:00		2021-08-02 00:00:00		2022-09-06 00:00:00		2022-04-14 00:00:00		2020-10-22 00:00:00		2021-10-08 00:00:00		2021-10-08 00:00:00		2022-10-26 00:00:00		2022-09-27 00:00:00		2022-10-03 00:00:00		2022-07-28 00:00:00		2022-10-03 00:00:00
stmnt_type		10005		10001		10001		10001		10002		10001		10005		10005		10001		10001		10001		10005		10001		10002		10005		10002		10006		10005		10001		10001		10001		10001		10002		10005		10001		10001		10001		10006		10001		10002		10005		10005		10001		10005		10001		10002		10001		10002		10002		10001		10005		10006		10002		10001		10005		10006		10002		10005		10002		10006		10001		10005		10006		10001		10005		10005		10001		10006		10002		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10005		10005		10005		10001		10001		10005		10005		10005		10005		10001		10001		10005		10001		10001		10005		10001		10005		10001		10005		10006		10001		10001		10002		10005		10001		10001		10001		10005		10005		10001		10001		10002		10001		10005		10001		10006		10001		10005		10001		10001		10001		10001		10001		10001		10001		10002		10001		10001		10001		10001		10005		10005		10002		10002		10001		10001		10005		10001		10001		10001		10001		10006		10001		10001		10001		10001		10001		10005		10002		10001		10002		10001		10001		10002		10002		10001		10001		10001		10001		10002		10002		10006		10001		10005		10001		10006		10002		10001		10001		10001		10002		10005		10005		10002		10001		10001		10001		10006		10001		10002		10001		10001		10005		10001		10001		10005		10002		10002		10001		10002		10006		10001		10005		10005		10002		10002		10005		10001		10001		10005		10005		10006		10006		10005		10005		10002		10005		10005		10006		10001		10001		10002		10006		10002		10001		10002		10001		10002		10006		10002		10002		10005		10001		10005		10006		10001		10001		10005		10001		10002		10001		10001		10001		10005		10006		10001		10002		10001		10001		10001		10001		10001		10001		10006		10001		10001		10001		10005		10005		10005		10001		10002		10005		10005		10005		10001		10005		10002		10005		10001
stmnt_status		11001		11001		11003		11003		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11003		11001		11001		11003		11001		11003		11003		11003		11001		11003		11001		11001		11003		11001		11003		11001		11003		11001		11003		11003		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11003		11003		11003		11001		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		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		11003		11003		11001		11001		11001		11001		11003		11003		11003		11001		11001		11001		11001		11003		11001		11003		11001		11001		11001		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11003		11003		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11003		11003		11001		11001		11003		11001		11001		11001		11003		11001		11003		11001		11003		11003		11003		11003		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11001		11001		11003		11003		11003		11001		11003		11001		11003		11003		11001		11001		11003		11003		11003		11001		11003		11001		11003		11003		11001		11001		11001		11003		11003		11003		11003		11003
session_id		2007		2007		2007		2007		2013		2013		2013		2011		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2013		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2009		2009		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		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2011		2011		2011		2011		2011		2011		2011		2011		2013		2013		2013		2013		2011		2011		2011		2011		2011		2013		2013		2013		2011		2011		2011		2013		2013		2013		2013		2013		2013		2011		2013		2013		2013		2013		2013		2013		2011		2013		2013		2015		2015		2015		2017		2017		2017		2017		2017		2017		2017		2017		2017		2017		2017		2017		2017		2017		2019		2017		2017		2019		2019		2017		2017		2017		2017		2017		2019		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2015		2017		2015		2015		2015		2015		2017		2015		2015		2017		2017		2017		2017		2017		2017		2019		2019		2019		2017		2015		2015		2017		2017		2017		2017		2019		2017		2017		2017		2017		2019		2017		2017		2017		2019		2019		2019		2017		2019		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2019		2021		2021		2021		2021		2021		2021		2019		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2021		2019		2021		2021		2021		2021		2021		2021		2021
user_id		GPEREZ		NWALKER		*		*		JINGRAM		CPON		CPON		SBROWN		WBROWN		WBROWN		MDIGRAZIA		MDIGRAZIA		MDIGRAZIA		WBROWN		MPACHECO		TRAMON		TRAMON		SMCCONNAN		WBROWN		WBROWN		WBROWN		WBROWN		WBROWN		MDIGRAZIA		WBROWN		SARRIAGA		WBROWN		EMCENTEE		*		*		TMILLER		LHOANG		*		SARRIAGA		DMCCASTL		*		CPON		*		*		*		CPON		GGILMORE		GKURIMOT		CPON		RGEREMIA		EMCENTEE		*		CPON		*		RGEREMIA		*		NLANDERS		RGEREMIA		MMORENO		MMORENO		MMORENO		MMORENO		RGEREMIA		*		DHORRELL		CPON		PBANFORD		*		*		*		MMORENO		*		*		*		*		DHORRELL		DHORRELL		DHORRELL		DHORRELL		DHORRELL		SARRIAGA		SARRIAGA		SARRIAGA		CPON		*		MMORENO		MMORENO		CPON		MMORENO		MPACHECO		*		SMCCONNAN		SMCCONNAN		CPON		CPON		CPON		MDIGRAZIA		MDIGRAZIA		MDIGRAZIA		MDIGRAZIA		PBANFORD		CPON		PBANFORD		CAFILER		CPON		WBROWN		MDIGRAZIA		CPON		CPON		MPACHECO		CAFILER		WBROWN		TRAMON		SMCCONNAN		SARRIAGA		WBROWN		TRAMON		MDIGRAZIA		MDIGRAZIA		WBROWN		MDIGRAZIA		WBROWN		WBROWN		WBROWN		WBROWN		CPON		JINGRAM		WBROWN		WBROWN		WBROWN		WBROWN		MDIGRAZIA		CPON		JINGRAM		JINGRAM		WBROWN		SMCCONNAN		SMCCONNAN		CAFILER		CAFILER		RGEREMIA		HSTOVALL		RSAGARIO		RGEREMIA		CAFILER		CAFILER		CAFILER		RPOOJA		LBARTHOL		TRAMON		LBARTHOL		CAFILER		RGEREMIA		CAFILER		RSAGARIO		TRAMON		IMEDINA		CAFILER		CSAGABAEN		CSAGABAEN		CAFILER		RGEREMIA		RGEREMIA		MDIGRAZIA		MDIGRAZIA		RGEREMIA		TRAMON		CAFILER		GPEREZ		SMCCONNAN		RGEREMIA		PDEO		SMCCONNAN		GPEREZ		TRAMON		RGEREMIA		GKURIMOT		CAFILER		MPACHECO		GKURIMOT		GKURIMOT		GKURIMOT		GKURIMOT		CPON		GKURIMOT		SARRIAGA		SARRIAGA		CAFILER		CAFILER		RPOOJA		CAFILER		SMCCONNAN		CSAGABAEN		RPOOJA		RPOOJA		LBARTHOL		HSTOVALL		CSAGABAEN		RGEREMIA		IMEDINA		IMEDINA		CSAGABAEN		SMCCONNAN		SMCCONNAN		CSAGABAEN		HSTOVALL		LBARTHOL		CSAGABAEN		JRAMOS		TRAMON		CAFILER		CSAGABAEN		CAFILER		TRAMON		CAFILER		CAFILER		CAFILER		CAFILER		TRAMON		TRAMON		CAFILER		CAFILER		IMEDINA		KRUSSELL		KRUSSELL		IMEDINA		DCODY		KRUSSELL		KRUSSELL		CAFILER		CAFILER		CAFILER		CAFILER		IMEDINA		KRUSSELL		KRUSSELL		CAFILER		CAFILER		KRUSSELL		CAFILER		JRAMOS		CAFILER		CAFILER		KRUSSELL		IMEDINA		CAFILER		CAFILER		CAFILER		KRUSSELL		JMAVES		DCODY		CAFILER		CAFILER		IMEDINA		IMEDINA		IMEDINA		CAFILER		RGEREMIA		CAFILER		JMAVES		CAFILER
special_audit		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		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		11003		11003		11003		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11003		11003		11001		11001		11003		11003		11003		11003		11001		11003		11003		11003		11001		11003		11001		11001		11003		11003		11003		11001		11003		11003		11003		11003		11003		11001		11001		11001		11001		11003		11003		11001		11003		11001		11003		11003		11003		11001		11003		11003		11003		11003		11001		11001		11001		11001		11001		11003		11003		11003		11001		11003		11001		11001		11003		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11003		11003		11001		11003		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11003		11003		11001		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11003		11003		11003		11001		11001		11001		11001		11003		11003		11001		11001		11003		11003		11001		11001		11001		11001		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
rpt_start		2007-01-01 00:00:00		None		2007-07-01 00:00:00		2007-01-01 00:00:00		None		2013-01-01 00:00:00		2013-01-01 00:00:00		2011-01-01 00:00:00		2014-05-06 00:00:00		2014-06-06 00:00:00		2014-05-18 00:00:00		2014-03-18 00:00:00		2014-03-18 00:00:00		2014-06-09 00:00:00		2014-05-18 00:00:00		2013-12-11 00:00:00		None		2014-10-19 00:00:00		2014-10-29 00:00:00		2014-10-03 00:00:00		2014-10-30 00:00:00		2014-10-21 00:00:00		2014-10-14 00:00:00		2014-07-01 00:00:00		2014-10-13 00:00:00		2014-10-01 00:00:00		2014-10-15 00:00:00		None		2008-05-07 00:00:00		2008-05-07 00:00:00		2008-01-01 00:00:00		None		2008-01-01 00:00:00		2007-07-01 00:00:00		2008-05-29 00:00:00		2008-01-01 00:00:00		2008-05-18 00:00:00		2008-07-24 00:00:00		2008-10-07 00:00:00		2008-10-01 00:00:00		2008-05-18 00:00:00		2008-01-01 00:00:00		None		2008-07-01 00:00:00		2008-10-01 00:00:00		None		2008-09-24 00:00:00		2008-07-01 00:00:00		2009-01-12 00:00:00		None		2008-10-19 00:00:00		2008-10-19 00:00:00		None		2009-01-01 00:00:00		2009-01-01 00:00:00		2009-07-01 00:00:00		2009-07-01 00:00:00		None		2010-04-20 00:00:00		2010-06-01 00:00:00		2010-01-01 00:00:00		2010-05-13 00:00:00		2010-05-23 00:00:00		2010-01-01 00:00:00		2010-01-01 00:00:00		2010-01-01 00:00:00		2010-01-01 00:00:00		2010-01-01 00:00:00		2010-01-01 00:00:00		2010-01-01 00:00:00		2010-05-28 00:00:00		2010-05-28 00:00:00		2010-05-28 00:00:00		2010-05-28 00:00:00		2010-05-28 00:00:00		2010-05-23 00:00:00		2010-01-01 00:00:00		2010-01-01 00:00:00		2010-07-01 00:00:00		2010-01-01 00:00:00		2010-05-23 00:00:00		2010-01-01 00:00:00		2010-01-01 00:00:00		2010-05-23 00:00:00		2010-10-01 00:00:00		2010-10-01 00:00:00		2010-10-17 00:00:00		2010-10-17 00:00:00		2010-07-01 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2011-07-01 00:00:00		2011-07-01 00:00:00		2012-01-01 00:00:00		2012-01-01 00:00:00		2012-01-01 00:00:00		2012-05-20 00:00:00		2012-05-21 00:00:00		2012-01-01 00:00:00		2013-07-01 00:00:00		2014-02-07 00:00:00		2014-01-01 00:00:00		2013-07-01 00:00:00		2012-05-20 00:00:00		2012-07-01 00:00:00		2012-07-01 00:00:00		2012-10-17 00:00:00		2012-10-18 00:00:00		2014-10-19 00:00:00		2014-10-01 00:00:00		2014-10-21 00:00:00		None		2012-10-01 00:00:00		2012-10-01 00:00:00		2014-10-02 00:00:00		2014-07-01 00:00:00		2014-09-02 00:00:00		2014-09-04 00:00:00		2014-08-22 00:00:00		2014-09-23 00:00:00		2012-10-21 00:00:00		2013-01-30 00:00:00		2014-05-02 00:00:00		2014-05-08 00:00:00		2014-05-14 00:00:00		2014-05-19 00:00:00		2014-01-01 00:00:00		2012-10-21 00:00:00		None		2013-04-15 00:00:00		2015-10-06 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00		2018-05-14 00:00:00		2018-10-10 00:00:00		2018-05-08 00:00:00		2018-04-22 00:00:00		None		2018-05-30 00:00:00		2018-10-05 00:00:00		2018-05-03 00:00:00		2018-10-30 00:00:00		2018-07-01 00:00:00		2018-05-20 00:00:00		2018-03-28 00:00:00		2018-05-20 00:00:00		2018-04-22 00:00:00		2020-11-03 00:00:00		2018-05-18 00:00:00		2018-01-30 00:00:00		2019-01-24 00:00:00		2020-07-01 00:00:00		2018-05-31 00:00:00		2018-01-01 00:00:00		2018-09-23 00:00:00		2018-05-31 00:00:00		2018-05-31 00:00:00		None		2015-07-01 00:00:00		2015-07-01 00:00:00		2016-04-26 00:00:00		None		2016-01-01 00:00:00		2016-05-22 00:00:00		2016-01-01 00:00:00		2016-05-27 00:00:00		2016-06-23 00:00:00		2016-01-01 00:00:00		2016-05-22 00:00:00		2016-08-01 00:00:00		2016-10-10 00:00:00		2016-10-18 00:00:00		2016-07-01 00:00:00		2016-01-01 00:00:00		2016-10-31 00:00:00		2016-11-02 00:00:00		2016-11-02 00:00:00		2016-10-28 00:00:00		2016-09-25 00:00:00		2017-04-26 00:00:00		2016-10-23 00:00:00		2016-10-23 00:00:00		2016-07-01 00:00:00		2016-10-23 00:00:00		2017-01-01 00:00:00		2016-07-01 00:00:00		2016-07-01 00:00:00		2018-10-21 00:00:00		2017-01-01 00:00:00		2018-07-01 00:00:00		2018-04-22 00:00:00		2018-05-20 00:00:00		2017-07-01 00:00:00		2020-02-26 00:00:00		2019-07-01 00:00:00		2020-02-16 00:00:00		2018-10-21 00:00:00		2016-10-23 00:00:00		2016-07-01 00:00:00		2018-09-23 00:00:00		2018-04-22 00:00:00		2018-01-01 00:00:00		2018-01-01 00:00:00		2020-10-18 00:00:00		None		2018-05-25 00:00:00		2017-07-01 00:00:00		2018-01-01 00:00:00		None		2018-05-20 00:00:00		2018-10-03 00:00:00		2018-05-31 00:00:00		2020-01-19 00:00:00		2019-07-25 00:00:00		None		2018-09-21 00:00:00		2020-01-30 00:00:00		2019-07-01 00:00:00		2021-08-23 00:00:00		2021-07-01 00:00:00		None		2021-01-01 00:00:00		2021-10-01 00:00:00		2021-10-01 00:00:00		2022-04-24 00:00:00		2022-04-20 00:00:00		2022-04-20 00:00:00		2021-08-23 00:00:00		2020-02-16 00:00:00		2022-01-01 00:00:00		2021-07-01 00:00:00		2022-04-11 00:00:00		2021-08-25 00:00:00		2021-07-01 00:00:00		2022-09-26 00:00:00		2020-10-18 00:00:00		2022-07-01 00:00:00		2021-10-14 00:00:00		2022-01-01 00:00:00		None		2021-08-06 00:00:00		2022-05-22 00:00:00		2022-04-14 00:00:00		2021-08-23 00:00:00		2022-04-24 00:00:00		2021-01-01 00:00:00		2022-09-06 00:00:00		2022-04-14 00:00:00		2020-07-01 00:00:00		2020-07-01 00:00:00		2020-10-18 00:00:00		2022-09-22 00:00:00		2022-07-01 00:00:00		2022-10-03 00:00:00		2022-05-22 00:00:00		2022-10-03 00:00:00
rpt_end		2007-06-30 00:00:00		None		2007-12-31 00:00:00		2007-06-30 00:00:00		None		2013-06-30 00:00:00		2013-06-30 00:00:00		2012-12-31 00:00:00		2014-05-06 00:00:00		2014-06-06 00:00:00		2014-06-30 00:00:00		2014-05-17 00:00:00		2014-05-17 00:00:00		2014-06-09 00:00:00		2014-06-30 00:00:00		2013-12-11 00:00:00		None		2014-12-31 00:00:00		2014-10-29 00:00:00		2014-10-03 00:00:00		2014-10-30 00:00:00		2014-10-21 00:00:00		2014-10-14 00:00:00		2014-09-30 00:00:00		2014-10-13 00:00:00		2014-10-18 00:00:00		2014-10-15 00:00:00		None		2008-05-07 00:00:00		2008-05-07 00:00:00		2008-05-17 00:00:00		None		2008-05-17 00:00:00		2007-12-31 00:00:00		2008-05-29 00:00:00		2008-05-17 00:00:00		2008-06-30 00:00:00		2008-07-24 00:00:00		2008-10-07 00:00:00		2008-10-18 00:00:00		2008-06-30 00:00:00		2008-05-17 00:00:00		None		2008-09-30 00:00:00		2008-10-18 00:00:00		None		2008-09-24 00:00:00		2008-09-30 00:00:00		2009-01-12 00:00:00		None		2008-12-31 00:00:00		2008-12-31 00:00:00		None		2009-06-30 00:00:00		2009-06-30 00:00:00		2009-12-31 00:00:00		2009-12-31 00:00:00		None		2010-04-20 00:00:00		2010-06-01 00:00:00		2010-05-22 00:00:00		2010-05-13 00:00:00		2010-06-30 00:00:00		2010-05-22 00:00:00		2010-06-30 00:00:00		2010-05-22 00:00:00		2010-05-22 00:00:00		2010-05-22 00:00:00		2010-05-22 00:00:00		2010-05-22 00:00:00		2010-05-28 00:00:00		2010-05-28 00:00:00		2010-05-28 00:00:00		2010-05-28 00:00:00		2010-05-28 00:00:00		2010-06-30 00:00:00		2010-06-30 00:00:00		2010-06-30 00:00:00		2010-09-30 00:00:00		2010-06-30 00:00:00		2010-06-30 00:00:00		2010-05-22 00:00:00		2010-05-22 00:00:00		2010-06-30 00:00:00		2010-10-16 00:00:00		2010-10-16 00:00:00		2010-12-31 00:00:00		2010-12-31 00:00:00		2010-09-30 00:00:00		2011-06-30 00:00:00		2011-06-30 00:00:00		2011-12-31 00:00:00		2011-12-31 00:00:00		2012-05-19 00:00:00		2012-05-19 00:00:00		2012-05-19 00:00:00		2012-06-30 00:00:00		2012-05-21 00:00:00		2012-05-19 00:00:00		2013-12-31 00:00:00		2014-02-07 00:00:00		2014-03-17 00:00:00		2013-12-31 00:00:00		2012-06-30 00:00:00		2012-09-30 00:00:00		2012-09-30 00:00:00		2012-10-17 00:00:00		2012-10-18 00:00:00		2014-12-31 00:00:00		2014-10-18 00:00:00		2014-10-21 00:00:00		None		2012-10-20 00:00:00		2012-10-20 00:00:00		2014-10-02 00:00:00		2014-09-30 00:00:00		2014-09-02 00:00:00		2014-09-04 00:00:00		2014-08-22 00:00:00		2014-09-23 00:00:00		2012-12-31 00:00:00		2013-01-30 00:00:00		2014-05-02 00:00:00		2014-05-08 00:00:00		2014-05-14 00:00:00		2014-05-19 00:00:00		2014-03-17 00:00:00		2012-12-31 00:00:00		None		2013-04-15 00:00:00		2015-10-06 00:00:00		2015-06-30 00:00:00		2015-06-30 00:00:00		2018-05-14 00:00:00		2018-10-10 00:00:00		2018-05-08 00:00:00		2018-05-19 00:00:00		None		2018-05-30 00:00:00		2018-10-05 00:00:00		2018-05-03 00:00:00		2018-10-30 00:00:00		2018-09-22 00:00:00		2018-06-30 00:00:00		2018-03-28 00:00:00		2018-06-30 00:00:00		2018-05-19 00:00:00		2020-11-03 00:00:00		2018-05-18 00:00:00		2018-01-30 00:00:00		2019-01-24 00:00:00		2020-10-17 00:00:00		2018-05-31 00:00:00		2018-04-21 00:00:00		2018-10-20 00:00:00		2018-05-31 00:00:00		2018-05-31 00:00:00		None		2015-12-31 00:00:00		2015-12-31 00:00:00		2016-04-26 00:00:00		None		2016-05-21 00:00:00		2016-06-30 00:00:00		2016-05-21 00:00:00		2016-05-27 00:00:00		2016-06-23 00:00:00		2016-05-21 00:00:00		2016-06-30 00:00:00		2016-08-01 00:00:00		2016-10-10 00:00:00		2016-10-18 00:00:00		2016-10-22 00:00:00		2016-05-21 00:00:00		2016-10-31 00:00:00		2016-11-02 00:00:00		2016-11-02 00:00:00		2016-10-28 00:00:00		2016-10-22 00:00:00		2017-04-26 00:00:00		2016-12-31 00:00:00		2016-12-31 00:00:00		2016-10-22 00:00:00		2016-12-31 00:00:00		2017-06-30 00:00:00		2016-10-22 00:00:00		2016-10-22 00:00:00		2018-12-31 00:00:00		2017-06-30 00:00:00		2018-09-22 00:00:00		2018-05-19 00:00:00		2018-06-30 00:00:00		2017-12-31 00:00:00		2020-02-26 00:00:00		2019-12-31 00:00:00		2020-06-30 00:00:00		2018-12-31 00:00:00		2016-12-31 00:00:00		2016-10-22 00:00:00		2018-10-20 00:00:00		2018-05-19 00:00:00		2018-04-21 00:00:00		2018-04-21 00:00:00		2020-12-31 00:00:00		None		2018-05-25 00:00:00		2017-12-31 00:00:00		2018-04-21 00:00:00		None		2018-06-30 00:00:00		2018-10-03 00:00:00		2018-05-31 00:00:00		2020-02-15 00:00:00		2019-07-25 00:00:00		None		2018-09-21 00:00:00		2020-01-30 00:00:00		2019-12-31 00:00:00		2021-09-30 00:00:00		2021-08-22 00:00:00		None		2021-06-30 00:00:00		2021-12-31 00:00:00		2021-12-31 00:00:00		2022-05-21 00:00:00		2022-04-20 00:00:00		2022-04-20 00:00:00		2021-08-23 00:00:00		2020-06-30 00:00:00		2022-04-23 00:00:00		2021-08-22 00:00:00		2022-04-11 00:00:00		2021-08-25 00:00:00		2021-08-22 00:00:00		2022-09-26 00:00:00		2020-12-31 00:00:00		2022-09-21 00:00:00		2021-10-14 00:00:00		2022-04-23 00:00:00		None		2021-08-06 00:00:00		2022-06-30 00:00:00		2022-04-14 00:00:00		2021-09-30 00:00:00		2022-05-21 00:00:00		2021-06-30 00:00:00		2022-09-06 00:00:00		2022-04-14 00:00:00		2020-10-17 00:00:00		2020-10-17 00:00:00		2020-12-31 00:00:00		2022-10-22 00:00:00		2022-09-21 00:00:00		2022-10-03 00:00:00		2022-06-30 00:00:00		2022-10-03 00:00:00
rpt_date		None		None		2008-01-29 00:00:00		2007-07-27 00:00:00		None		2013-07-18 00:00:00		None		None		2014-05-06 00:00:00		2014-06-06 00:00:00		2014-07-23 00:00:00		None		2014-05-22 00:00:00		2014-06-09 00:00:00		None		None		None		None		2014-10-29 00:00:00		2014-10-03 00:00:00		2014-10-30 00:00:00		2014-10-21 00:00:00		2014-10-14 00:00:00		None		2014-10-13 00:00:00		2014-10-23 00:00:00		2014-10-15 00:00:00		None		None		None		None		None		2008-05-21 00:00:00		None		2008-05-29 00:00:00		2008-07-31 00:00:00		2008-07-31 00:00:00		None		None		2008-10-23 00:00:00		None		None		None		2008-10-06 00:00:00		None		None		None		None		None		None		2009-02-02 00:00:00		None		None		2009-07-29 00:00:00		None		None		2010-01-28 00:00:00		None		None		2010-06-01 00:00:00		2010-05-27 00:00:00		2010-05-13 00:00:00		2010-07-28 00:00:00		2010-05-27 00:00:00		2010-07-28 00:00:00		2010-05-27 00:00:00		2010-05-27 00:00:00		2010-05-27 00:00:00		2010-05-27 00:00:00		2010-05-27 00:00:00		2010-05-28 00:00:00		2010-05-28 00:00:00		2010-05-28 00:00:00		2010-05-28 00:00:00		2010-05-28 00:00:00		None		None		None		None		2010-07-28 00:00:00		2010-07-28 00:00:00		None		None		None		None		2010-10-21 00:00:00		2011-01-25 00:00:00		None		2010-10-04 00:00:00		2011-07-26 00:00:00		None		2012-01-31 00:00:00		None		2012-05-24 00:00:00		None		None		2012-07-30 00:00:00		2012-05-21 00:00:00		2012-07-02 00:00:00		None		2014-02-07 00:00:00		2014-03-24 00:00:00		2014-01-22 00:00:00		None		None		2012-10-04 00:00:00		2012-10-17 00:00:00		None		2015-01-23 00:00:00		None		2014-10-21 00:00:00		None		2012-10-25 00:00:00		None		2014-10-02 00:00:00		2014-10-04 00:00:00		2014-09-02 00:00:00		2014-09-04 00:00:00		2014-08-22 00:00:00		2014-09-23 00:00:00		2013-01-30 00:00:00		None		2014-05-02 00:00:00		2014-05-08 00:00:00		2014-05-14 00:00:00		2014-05-19 00:00:00		None		None		None		None		2015-10-06 00:00:00		2015-07-30 00:00:00		None		2018-05-14 00:00:00		2018-10-10 00:00:00		2018-05-08 00:00:00		2018-05-23 00:00:00		None		2018-05-30 00:00:00		2018-10-05 00:00:00		2018-05-03 00:00:00		2018-10-30 00:00:00		2018-09-27 00:00:00		None		None		2018-07-31 00:00:00		2018-06-27 00:00:00		2020-11-03 00:00:00		2018-05-18 00:00:00		None		None		2020-10-22 00:00:00		2018-05-31 00:00:00		2018-04-25 00:00:00		2018-10-25 00:00:00		2018-05-31 00:00:00		2018-05-31 00:00:00		None		2016-01-29 00:00:00		None		2016-04-26 00:00:00		None		2016-08-01 00:00:00		2016-08-01 00:00:00		2016-05-26 00:00:00		2016-05-27 00:00:00		2016-06-23 00:00:00		None		None		None		2016-10-10 00:00:00		2016-10-18 00:00:00		2016-10-27 00:00:00		None		2016-10-31 00:00:00		2016-11-02 00:00:00		2016-11-02 00:00:00		2016-10-28 00:00:00		None		2017-04-26 00:00:00		2017-01-31 00:00:00		None		2017-01-31 00:00:00		2017-07-28 00:00:00		2017-07-27 00:00:00		2017-07-28 00:00:00		None		2019-01-30 00:00:00		None		None		None		None		None		2020-02-26 00:00:00		2020-01-29 00:00:00		None		None		None		None		None		None		None		None		None		None		2018-05-25 00:00:00		2018-01-30 00:00:00		2018-06-27 00:00:00		None		2018-09-28 00:00:00		2018-10-03 00:00:00		2018-05-31 00:00:00		2020-02-20 00:00:00		None		None		2018-09-21 00:00:00		None		None		2021-10-26 00:00:00		None		None		2021-07-21 00:00:00		2022-01-31 00:00:00		None		2022-05-25 00:00:00		2022-04-20 00:00:00		2022-04-20 00:00:00		2021-08-23 00:00:00		2020-08-07 00:00:00		None		None		2022-04-11 00:00:00		None		2021-08-25 00:00:00		2022-09-26 00:00:00		2021-02-01 00:00:00		2022-09-23 00:00:00		2021-10-14 00:00:00		2022-04-26 00:00:00		None		2021-08-06 00:00:00		2022-07-25 00:00:00		2022-04-14 00:00:00		None		None		None		2022-09-06 00:00:00		2022-04-14 00:00:00		None		None		None		2022-10-26 00:00:00		None		2022-10-03 00:00:00		None		2022-10-03 00:00:00
filing_type		None		None		22001		22001		None		22001		None		None		22001		22001		22001		None		22001		22001		None		22001		None		None		22001		22001		22001		22001		22001		None		22001		22001		22001		None		22001		22001		None		None		22001		None		22001		22001		22001		22001		22001		22001		None		None		None		22001		None		None		22001		None		22001		None		22001		None		None		22001		None		None		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		None		None		None		22001		22001		None		None		None		None		22001		22001		None		22001		22001		None		22001		None		22001		None		None		22001		22001		22001		None		22001		22001		22001		None		None		22001		22001		22001		22001		None		22001		None		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		None		None		22001		22001		22001		None		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		None		22001		None		22001		22001		22001		22001		22001		None		None		22001		22001		22001		22001		None		22001		22001		22001		22001		None		22001		22001		None		22001		22001		22001		22001		None		22001		None		None		None		None		None		22001		22001		None		None		None		None		None		None		None		None		None		None		22001		22001		22001		None		22001		22001		22001		22001		22001		None		22001		22001		None		22001		None		None		22001		22001		None		22001		22001		22001		22001		22001		None		None		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		None		None		None		22001		22001		None		None		None		22001		None		22001		None		22001

Table: filer_to_filer_type

filer_id		1297707		1297707		1297707		1297707
filer_type		16		16		16		16
active		Y		Y		Y		Y
race		0		0		0		0
session_id		2007		2007		2019		2019
category		0		0		0		0
category_type		40502		40502		40502		40503
sub_category		40103		40103		40103		40103
effect_dt		2007-05-01 00:00:00		2008-05-07 00:00:00		2020-01-30 00:00:00		2019-01-23 00:00:00
sub_category_type		0		0		0		0
election_type		0		0		0		0
sub_category_a		S		S		S		S
nyq_dt		None		2007-09-30 00:00:00		2007-09-30 00:00:00		2007-09-30 00:00:00
party_cd		0		0		0		0
county_cd		18048		18048		18048		18048
district_cd		0		0		0		0

Table: filer_xref

filer_id		1297707
xref_id		1297707
effect_dt		2007-05-01 00:00:00
migration_source		CLAIMS

Table: filername

xref_filer_id		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707
filer_id		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707
filer_type		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE
status		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE
effect_dt		2020-01-30 00:00:00		2020-01-30 00:00:00		2020-01-30 00:00:00		2020-01-30 00:00:00		2020-01-30 00:00:00		2020-01-30 00:00:00		2020-01-30 00:00:00		2020-01-30 00:00:00		2020-01-30 00:00:00		2020-01-30 00:00:00		2020-01-30 00:00:00		2020-01-30 00:00:00		2020-01-30 00:00:00		2020-01-30 00:00:00		2020-01-30 00:00:00		2020-01-30 00:00:00		2020-01-30 00:00:00		2020-01-30 00:00:00		2020-01-30 00:00:00		2020-01-30 00:00:00		2020-01-30 00:00:00		2020-01-30 00:00:00		2020-01-30 00:00:00		2020-01-30 00:00:00		2020-01-30 00:00:00		2020-01-30 00:00:00		2020-01-30 00:00:00		2020-01-30 00:00:00		2020-01-30 00:00:00		2020-01-30 00:00:00		2020-01-30 00:00:00		2020-01-30 00:00:00		2020-01-30 00:00:00		2020-01-30 00:00:00		2020-01-30 00:00:00		2020-01-30 00:00:00		2020-01-30 00:00:00		2020-01-30 00:00:00		2020-01-30 00:00:00
naml		SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 521 INDEPENDENT EXPENDITURE COMMITTEE SPONSORED BY SERVICE EMPLOYEES INTERNATIONAL UNIONS		SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 521 INDEPENDENT EXPENDITURE COMMITTEE SPONSORED BY SERVICE EMPLOYEES INTERNATIONAL UNIONS		SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 521 INDEPENDENT EXPENDITURE COMMITTEE SPONSORED BY SERVICE EMPLOYEES INTERNATIONAL UNIONS		SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 521 INDEPENDENT EXPENDITURE COMMITTEE SPONSORED BY SERVICE EMPLOYEES INTERNATIONAL UNIONS		SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 521 INDEPENDENT EXPENDITURE COMMITTEE SPONSORED BY SERVICE EMPLOYEES INTERNATIONAL UNIONS		SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 521 INDEPENDENT EXPENDITURE COMMITTEE SPONSORED BY SERVICE EMPLOYEES INTERNATIONAL UNIONS		SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 521 INDEPENDENT EXPENDITURE COMMITTEE SPONSORED BY SERVICE EMPLOYEES INTERNATIONAL UNIONS		SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 521 INDEPENDENT EXPENDITURE COMMITTEE SPONSORED BY SERVICE EMPLOYEES INTERNATIONAL UNIONS		SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 521 INDEPENDENT EXPENDITURE COMMITTEE SPONSORED BY SERVICE EMPLOYEES INTERNATIONAL UNIONS		SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 521 INDEPENDENT EXPENDITURE COMMITTEE SPONSORED BY SERVICE EMPLOYEES INTERNATIONAL UNIONS		SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 521 INDEPENDENT EXPENDITURE COMMITTEE SPONSORED BY SERVICE EMPLOYEES INTERNATIONAL UNIONS		SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 521 INDEPENDENT EXPENDITURE COMMITTEE SPONSORED BY SERVICE EMPLOYEES INTERNATIONAL UNIONS		SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 521 INDEPENDENT EXPENDITURE COMMITTEE SPONSORED BY SERVICE EMPLOYEES INTERNATIONAL UNIONS		SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 521 INDEPENDENT EXPENDITURE COMMITTEE		SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 521 INDEPENDENT EXPENDITURE COMMITTEE		SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 521 INDEPENDENT EXPENDITURE COMMITTEE		SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 521 INDEPENDENT EXPENDITURE COMMITTEE		SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 521 INDEPENDENT EXPENDITURE COMMITTEE		SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 521 INDEPENDENT EXPENDITURE COMMITTEE		SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 521 INDEPENDENT EXPENDITURE COMMITTEE		SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 521 INDEPENDENT EXPENDITURE COMMITTEE		SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 521 INDEPENDENT EXPENDITURE COMMITTEE		SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 521 INDEPENDENT EXPENDITURE COMMITTEE		SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 521 INDEPENDENT EXPENDITURE COMMITTEE		SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 521 INDEPENDENT EXPENDITURE COMMITTEE		SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 521 INDEPENDENT EXPENDITURE COMMITTEE		SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 521 INDEPENDENT EXPENDITURE COMMITTEE		SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 521 INDEPENDENT EXPENDITURE COMMITTEE		SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 521 INDEPENDENT EXPENDITURE COMMITTEE		SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 521 INDEPENDENT EXPENDITURE COMMITTEE		SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 521 INDEPENDENT EXPENDITURE COMMITTEE		SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 521 INDEPENDENT EXPENDITURE COMMITTEE		SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 521 INDEPENDENT EXPENDITURE COMMITTEE		SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 521 INDEPENDENT EXPENDITURE COMMITTEE		SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 521 INDEPENDENT EXPENDITURE COMMITTEE		SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 521 INDEPENDENT EXPENDITURE COMMITTEE		SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 521 INDEPENDENT EXPENDITURE COMMITTEE		SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 521 INDEPENDENT EXPENDITURE COMMITTEE		SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 521 INDEPENDENT EXPENDITURE COMMITTEE
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
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
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
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
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
city		SAN JOSE		SACRAMENTO		SACRAMENTO		San Jose		Sacramento		San Jose		San Jose		SAN JOSE		SACRAMENTO		SAN JOSE		SACRAMENTO		SACRAMENTO		SAN JOSE		SAN JOSE		SACRAMENTO		SACRAMENTO		San Jose		Sacramento		San Jose		San Jose		SAN JOSE		SACRAMENTO		SAN JOSE		SACRAMENTO		SACRAMENTO		SAN JOSE		SAN JOSE		SACRAMENTO		SACRAMENTO		San Jose		Sacramento		San Jose		San Jose		SAN JOSE		SACRAMENTO		SAN JOSE		SACRAMENTO		SACRAMENTO		SAN JOSE
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
zip4		95131		95814		95814		95131		95814		95131		95131		95131		95814		95131		95814		95814		95131		95131		95814		95814		95131		95814		95131		95131		95131		95814		95131		95814		95814		95131		95131		95814		95814		95131		95814		95131		95131		95131		95814		95131		95814		95814		95131
phon		4089548715		None				(408) 954-8715		(408) 954-8715		4089548715		4086783300		4086783300				4086783300		4086783300		4086783300		4086783300		4089548715		None				(408) 954-8715		(408) 954-8715		4089548715		4086783300		4086783300				4086783300		4086783300		4086783300		4086783300		4089548715		None				(408) 954-8715		(408) 954-8715		4089548715		4086783300		4086783300				4086783300		4086783300		4086783300		4086783300
fax		4089540631		None				(408) 954-0631		(408) 954-0631		4089540631		4089540631		4089540631				4089540631		4089540631		4089540631		4089540631		4089540631		None				(408) 954-0631		(408) 954-0631		4089540631		4089540631		4089540631				4089540631		4089540631		4089540631		4089540631		4089540631		None				(408) 954-0631		(408) 954-0631		4089540631		4089540631		4089540631				4089540631		4089540631		4089540631		4089540631
email		None		None		None		None		None		None		None		info@olsonhagel.com		None		info@olsonhagel.com		info@olsonhagel.com		compliance@olsonremcho.com		compliance@olsonremcho.com		None		None		None		None		None		None		None		info@olsonhagel.com		None		info@olsonhagel.com		info@olsonhagel.com		compliance@olsonremcho.com		compliance@olsonremcho.com		None		None		None		None		None		None		None		info@olsonhagel.com		None		info@olsonhagel.com		info@olsonhagel.com		compliance@olsonremcho.com		compliance@olsonremcho.com

Table: filers

filer_id		1297707

Table: received_filings

filer_id		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707		1297707
filing_file_name		1331343_0.cal		264622.cal		1331343_1.cal		1331343_2.cal		140108.cal		140328.cal		1331343_3.cal		1331343_4.cal		1661929_0.cal		1848513_0.cal		1849851_0.cal		1847487_0.cal		11039.cal		1851588_0.cal		1846941_0.cal		1699516_0.cal		1821053_0.cal		1859025_1.cal		1859025_0.cal		1991049_0.cal		2154087_0.cal		2047567_0.cal		2091105_1.cal		2104058_0.cal		2102526_0.cal		2086860_0.cal		1881940_0.cal		1882563_0.cal		1879893_0.cal		1887645_0.cal		1891681_0.cal		80044.cal		1897279_1.cal		1891153_0.cal		2091105_0.cal		1901871_0.cal		1898782_0.cal		1910067_0.cal		1908837_0.cal		1901476_0.cal		2032829_0.cal		2047567_1.cal		2249180_0.cal		2304709_0.cal		2247185_0.cal		2257364_0.cal		2302856_0.cal		2245607_0.cal		2316290_0.cal		225696.cal		2250551_0.cal		2258254_0.cal		344686.cal		2249180_1.cal		2257364_1.cal		80715.cal		120275.cal		2255300_0.cal		2458917_0.cal		2301247_0.cal		2245607_1.cal		2257364_2.cal		2664734_2.cal		2668075_0.cal		2532488_0.cal		420992.cal		421066.cal		2616031_0.cal		2664734_1.cal		2723579_1.cal		349387.cal		2664734_0.cal		2717546_0.cal		2723579_0.cal		2727526_0.cal		2666146_0.cal		2605231_0.cal
received_date		2008-05-07 00:00:00		2008-05-07 00:00:00		2008-05-07 00:00:00		2008-07-24 00:00:00		2010-05-27 00:00:00		2010-05-27 00:00:00		2008-09-24 00:00:00		2008-10-07 00:00:00		2012-05-21 00:00:00		2014-05-08 00:00:00		2014-05-14 00:00:00		2014-05-06 00:00:00		2014-05-06 00:00:00		2014-05-19 00:00:00		2014-05-02 00:00:00		2012-10-17 00:00:00		2014-02-07 00:00:00		2014-06-09 00:00:00		2014-06-06 00:00:00		2015-10-07 00:00:00		2017-04-26 00:00:00		2016-05-27 00:00:00		2016-11-02 00:00:00		2016-11-02 00:00:00		2016-10-31 00:00:00		2016-10-10 00:00:00		2014-09-02 00:00:00		2014-09-04 00:00:00		2014-08-22 00:00:00		2014-09-23 00:00:00		2014-10-03 00:00:00		2014-10-14 00:00:00		2014-10-14 00:00:00		2014-10-02 00:00:00		2016-10-18 00:00:00		2014-10-21 00:00:00		2014-10-15 00:00:00		2014-10-30 00:00:00		2014-10-29 00:00:00		2014-10-21 00:00:00		2016-04-26 00:00:00		2016-06-24 00:00:00		2018-05-14 00:00:00		2018-10-10 00:00:00		2018-05-08 00:00:00		2018-05-30 00:00:00		2018-10-05 00:00:00		2018-05-03 00:00:00		2018-10-29 00:00:00		2018-03-28 00:00:00		2018-05-18 00:00:00		2018-05-31 00:00:00		2019-01-24 00:00:00		2018-05-31 00:00:00		2018-05-31 00:00:00		2020-08-07 00:00:00		2020-02-20 00:00:00		2018-05-25 00:00:00		2020-02-26 00:00:00		2018-10-03 00:00:00		2018-05-31 00:00:00		2018-09-21 00:00:00		2022-04-20 00:00:00		2022-04-20 00:00:00		2020-11-03 00:00:00		2021-10-14 00:00:00		2021-10-14 00:00:00		2021-10-14 00:00:00		2022-04-14 00:00:00		2022-10-03 00:00:00		2022-01-25 00:00:00		2022-04-11 00:00:00		2022-09-06 00:00:00		2022-09-26 00:00:00		2022-10-03 00:00:00		2022-04-14 00:00:00		2021-08-06 00:00:00
filing_directory		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/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/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/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/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/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/temp		/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
filing_id		1331343		None		1331343		1331343		None		None		1331343		1331343		1661929		1848513		1849851		1847487		None		1851588		1846941		1699516		1821053		1859025		1859025		1991049		2154087		2047567		2091105		2104058		2102526		2086860		1881940		1882563		1879893		1887645		1891681		None		1897279		1891153		2091105		1901871		1898782		1910067		1908837		1901476		2032829		2047567		2249180		2304709		2247185		2257364		2302856		2245607		2316290		None		2250551		2258254		None		2249180		2257364		None		None		2255300		2458917		2301247		2245607		2257364		2664734		2668075		2532488		None		None		2616031		2664734		2723579		None		2664734		2717546		2723579		2727526		2666146		2605231
form_id		F410		None		F410		F410		None		None		F410		F410		F497		F497		F497		F497		None		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		None		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		F497		None		F497		F497		None		F497		F497		None		None		F497		F497		F497		F497		F497		F497		F497		F497		None		None		F497		F497		F497		None		F497		F497		F497		F497		F497		F497
receive_comment		Filing accepted		Filing passed validation, but failed DB constraints		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 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 passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing did not pass validation		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 accepted		Filing accepted		Filing accepted		Filing did not pass validation		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted