Home

Filer ID: 1145565

Table: filer_address

filer_id		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565
adrid		1110841		2012490		1112151		2040839		1132404		2061913		2077978		2086126		2114113		2104093		2176367		2162708		2205467		2415494		2471082		2509569		2279557		2344593		2550960
effect_dt		1999-01-01 00:00:00		2001-01-01 00:00:00		1997-05-01 00:00:00		2003-01-01 00:00:00		1999-12-30 00:00:00		2004-01-01 00:00:00		2005-01-01 00:00:00		2005-03-01 00:00:00		2007-01-01 00:00:00		2006-06-01 00:00:00		2009-12-17 00:00:00		2009-01-01 00:00:00		2011-01-01 00:00:00		2017-01-01 00:00:00		2019-01-01 00:00:00		2021-01-01 00:00:00		2014-03-10 00:00:00		2015-01-01 00:00:00		2023-01-01 00:00:00
add_type		7051		7051		7051		7051		7050		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051		7051
session_id		1999		2001		1997		2003		1999		2003		2005		2005		2007		2005		2009		2009		2011		2017		2019		2021		2013		2015		2023

Table: filer_filings

filer_id		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565
filing_id		469080		480197		490084		482872		486417		471829		474610		493777		497389		477355		618781		631378		663764		701649		692469		753104		739176		770248		780437		796189		820552		840824		864334		895548		894098		883268		914032		947142		930783		935410		910862		949124		967881		989908		974820		969019		982756		997690		1032938		1013815		1030285		1018431		1058627		1076907		1065685		1097092		1094143		1078390		1114131		1104869		1132211		1146001		1166944		1180811		1190301		1207768		1228936		1221708		1259192		1278766		1278766		1245850		1305162		1293941		1975827		1864279		1949506		1959776		1901030		1326572		1326572		1344635		1368437		1383940		1391107		1413693		1430175		1460318		1448885		1418716		1481351		1503647		1536116		1551323		1551357		1568266		1589750		1630441		1621388		1607322		1655133		1675325		1831311		1929408		1705963		1735327		1839610		1993539		2336535		2269690		2391471		2480941		2375277		2432112		2006394		2029095		2056306		2099854		2124889		2152419		2136004		2169877		2344561		2234296		2466265		2544778		2518209		2309511		2203663		2414435		2188711		2666720		2634732		2574284		2616039		2568095		2544778		2593191		2698937		2734167
period_id		157		159		154		152		153		150		158		155		156		151		160		None		162		None		163		165		164		165		None		None		None		None		None		None		None		171		None		174		173		None		172		174		None		176		None		175		None		None		None		177		178		None		179		None		None		None		None		180		182		181		183		184		185		None		186		187		188		188		189		190		190		None		192		191		222		218		None		221		219		193		193		194		195		196		196		None		198		200		199		197		201		202		203		None		204		204		205		208		207		206		209		210		None		220		211		212		217		223		236		234		238		242		237		240		224		225		226		227		228		229		None		230		None		233		241		244		243		235		232		239		231		249		248		245		247		None		244		246		250		251
form_id		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F605		F635		F635		F635		F605		F635		F635		F635		F635		F635		F635		F602		F635		F605		F635		F635		F635		F635		F635		F635		F635		F605		F635		F635		F635		F602		F635		F635		F635		F602		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F602		F635		F602		F635		F635		F635		F635		F635		F635		F635		F602		F602		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F602		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F635
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0
filing_date		1999-04-29 00:00:00		1999-10-25 00:00:00		1998-07-17 00:00:00		1998-01-29 00:00:00		1998-04-30 00:00:00		1997-07-31 00:00:00		1999-07-20 00:00:00		1998-10-16 00:00:00		1999-01-15 00:00:00		1997-10-24 00:00:00		2000-01-25 00:00:00		2000-04-13 00:00:00		2000-07-28 00:00:00		2000-12-01 00:00:00		2000-10-18 00:00:00		2001-04-27 00:00:00		2001-01-29 00:00:00		2001-04-27 00:00:00		2001-07-27 00:00:00		2001-10-30 00:00:00		2002-01-30 00:00:00		2002-04-29 00:00:00		2002-07-30 00:00:00		2002-11-22 00:00:00		2002-10-30 00:00:00		2002-10-30 00:00:00		2003-01-30 00:00:00		2003-07-31 00:00:00		2003-04-30 00:00:00		2003-04-30 00:00:00		2003-01-30 00:00:00		2003-07-31 00:00:00		1999-12-30 00:00:00		2004-01-31 00:00:00		2003-10-30 00:00:00		2003-10-30 00:00:00		2004-01-15 00:00:00		2004-01-30 00:00:00		2004-07-30 00:00:00		2004-04-30 00:00:00		2004-07-30 00:00:00		2004-04-30 00:00:00		2004-10-31 00:00:00		2004-12-10 00:00:00		2004-10-29 00:00:00		2005-03-17 00:00:00		2005-01-27 00:00:00		2005-01-28 00:00:00		2005-07-26 00:00:00		2005-04-30 00:00:00		2005-10-28 00:00:00		2006-01-29 00:00:00		2006-04-28 00:00:00		2006-06-15 00:00:00		2006-07-31 00:00:00		2006-10-13 00:00:00		2007-01-18 00:00:00		2006-11-16 00:00:00		2007-04-24 00:00:00		2007-07-31 00:00:00		2007-07-21 00:00:00		2006-12-15 00:00:00		2008-01-22 00:00:00		2007-10-22 00:00:00		2015-07-21 00:00:00		2014-07-18 00:00:00		2014-12-26 00:00:00		2015-04-20 00:00:00		2014-10-20 00:00:00		2008-04-23 00:00:00		2008-04-30 00:00:00		2008-07-22 00:00:00		2008-10-22 00:00:00		2008-12-16 00:00:00		2009-01-22 00:00:00		2008-12-04 00:00:00		2009-07-12 00:00:00		2010-01-25 00:00:00		2009-10-21 00:00:00		2009-04-24 00:00:00		2010-04-22 00:00:00		2010-07-27 00:00:00		2010-10-26 00:00:00		2010-12-14 00:00:00		2010-12-17 00:00:00		2011-01-27 00:00:00		2011-04-28 00:00:00		2012-01-22 00:00:00		2011-10-28 00:00:00		2011-07-30 00:00:00		2012-04-26 00:00:00		2012-07-26 00:00:00		2014-03-20 00:00:00		2015-01-25 00:00:00		2012-10-27 00:00:00		2013-01-29 00:00:00		2014-04-18 00:00:00		2015-10-22 00:00:00		2019-01-21 00:00:00		2018-07-25 00:00:00		2019-07-20 00:00:00		2020-07-25 00:00:00		2019-04-19 00:00:00		2020-01-18 00:00:00		2016-01-25 00:00:00		2016-04-17 00:00:00		2016-07-19 00:00:00		2016-10-28 00:00:00		2017-01-26 00:00:00		2017-04-23 00:00:00		2016-12-19 00:00:00		2017-07-22 00:00:00		2018-12-24 00:00:00		2018-04-23 00:00:00		2020-04-19 00:00:00		2021-01-17 00:00:00		2020-10-19 00:00:00		2018-10-20 00:00:00		2018-01-21 00:00:00		2019-10-22 00:00:00		2017-10-18 00:00:00		2022-04-15 00:00:00		2022-01-16 00:00:00		2021-04-14 00:00:00		2021-10-14 00:00:00		2020-12-18 00:00:00		2021-12-03 00:00:00		2021-07-14 00:00:00		2022-07-18 00:00:00		2022-10-14 00:00:00
stmnt_type		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10005		10005		10005		10005		10005		10005		10001		10005		10005		10005		10005		10005		10005		10005		10001		10005		10001		10001		10005		10001		10005		10005		10001		10005		10001		10005		10005		10005		10001		10001		10005		10001		10005		10005		10005		10005		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10002		10001		10005		10001		10001		10001		10001		10005		10001		10001		10001		10002		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10002		10001		10001		10001
stmnt_status		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11003		11001		11003		11003		11003		11003		11001		11003		11003		11001		11003		11001		11001		11001		11003		11003		11001		11003		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11003		11001		11003		11003
session_id		1999		1999		1997		1997		1997		1997		1999		1997		1997		1997		1999		1999		1999		2001		1999		2001		1999		2001		2001		2001		2001		2001		2001		2003		2001		2001		2001		2003		2003		2003		2001		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2005		2003		2005		2003		2003		2005		2005		2005		2005		2005		2005		2005		2005		2005		2007		2007		2007		2007		2007		2007		2007		2015		2013		2015		2015		2013		2007		2007		2007		2007		2009		2007		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2009		2011		2011		2011		2011		2011		2011		2013		2013		2011		2011		2013		2015		2017		2017		2019		2019		2019		2019		2015		2015		2015		2015		2015		2017		2017		2017		2019		2017		2019		2019		2019		2017		2017		2019		2017		2021		2021		2021		2021		2021		2019		2021		2021		2021
user_id		*		*		*		*		*		*		*		*		*		*		*		GGILMORE		YBONILLA		GPEREZ		YBONILLA		YBONILLA		GPEREZ		MKIENG		GPEREZ		GGILMORE		LTHIBAUL		LTHIBAUL		LTHIBAUL		PBANFORD		LTHIBAUL		*		LTHIBAUL		COMPLETED		COMPLETED		KVOONG1		COMPLETED		LTHIBAUL		CFLAGG		COMPLETED		LTHIBAUL		COMPLETED		GPEREZ		LTHIBAUL		LTHIBAUL		COMPLETED		COMPLETED		LTHIBAUL		COMPLETED		SARRIAGA		LTHIBAUL		GPEREZ		LTHIBAUL		COMPLETED		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		GPEREZ		LTHIBAUL		LTHIBAUL		LTHIBAUL		*		LTHIBAUL		LTHIBAUL		LTHIBAUL		PBANFORD		LTHIBAUL		LTHIBAUL		MPACHECO		AGLADNEY		PBANFORD		MPACHECO		AGLADNEY		LTHIBAUL		LTHIBAUL		YRODRIGU		JGRISSUM		*		JGRISSUM		CPON		JGRISSUM		JINGRAM		MGUERRA		JGRISSUM		ASAETERN		ASAETERN		ASAETERN		GKURIMOT		*		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		PBANFORD		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		MPACHECO		AGLADNEY		AGLADNEY		SUSHAKOV		MMERCHANT		VUKSTINA		VUKSTINA		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		DMCCASTL		AGLADNEY		SARRIAGA		AGLADNEY		VUKSTINA		GTAYLOR		CHARTRIDGE		AGLADNEY		AGLADNEY		VUKSTINA		AGLADNEY		CAFILER		GTAYLOR		CHATRIDGE		CHATRIDGE		AROJAS		CAFILER		GTAYLOR		CAFILER		CAFILER
special_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11002		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
fine_audit		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		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		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11003		11001		11001		11001		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11003		11003		11001		11003		11003
rpt_start		1999-01-01 00:00:00		1999-07-01 00:00:00		1998-04-01 00:00:00		1997-10-01 00:00:00		1998-01-01 00:00:00		1997-04-01 00:00:00		1999-04-01 00:00:00		1998-07-01 00:00:00		1998-10-01 00:00:00		1997-07-01 00:00:00		1999-10-01 00:00:00		2000-01-01 00:00:00		2000-04-01 00:00:00		1900-01-01 00:00:00		2000-07-01 00:00:00		2001-01-01 00:00:00		2000-10-01 00:00:00		None		2001-04-01 00:00:00		2001-07-01 00:00:00		2001-10-01 00:00:00		2002-01-01 00:00:00		2002-04-01 00:00:00		1900-01-01 00:00:00		2002-07-01 00:00:00		2002-07-01 00:00:00		2002-10-01 00:00:00		2003-04-01 00:00:00		2003-01-01 00:00:00		2003-01-01 00:00:00		2002-10-01 00:00:00		2003-04-01 00:00:00		1900-01-01 00:00:00		2003-10-01 00:00:00		2003-07-01 00:00:00		2003-07-01 00:00:00		1900-01-01 00:00:00		2003-10-01 00:00:00		2004-04-01 00:00:00		2004-01-01 00:00:00		2004-04-01 00:00:00		2004-01-01 00:00:00		2004-07-01 00:00:00		1900-01-01 00:00:00		2004-07-01 00:00:00		1900-01-01 00:00:00		2004-10-01 00:00:00		2004-10-01 00:00:00		2005-04-01 00:00:00		2005-01-01 00:00:00		2005-07-01 00:00:00		2005-10-01 00:00:00		2006-01-01 00:00:00		1900-01-01 00:00:00		2006-04-01 00:00:00		2006-07-01 00:00:00		2006-10-01 00:00:00		2006-11-16 00:00:00		2007-01-01 00:00:00		2007-04-01 00:00:00		2007-04-01 00:00:00		1900-01-01 00:00:00		2007-10-01 00:00:00		2007-07-01 00:00:00		2015-04-01 00:00:00		2014-04-01 00:00:00		1900-01-01 00:00:00		2015-01-01 00:00:00		2014-07-01 00:00:00		2008-01-01 00:00:00		2008-01-01 00:00:00		2008-04-01 00:00:00		2008-07-01 00:00:00		2008-12-16 00:00:00		2008-10-01 00:00:00		1900-01-01 00:00:00		2009-04-01 00:00:00		2009-10-01 00:00:00		2009-07-01 00:00:00		2009-01-01 00:00:00		2010-01-01 00:00:00		2010-04-01 00:00:00		2010-07-01 00:00:00		1900-01-01 00:00:00		2010-12-17 00:00:00		2010-10-01 00:00:00		2011-01-01 00:00:00		2011-10-01 00:00:00		2011-07-01 00:00:00		2011-04-01 00:00:00		2012-01-01 00:00:00		2012-04-01 00:00:00		1900-01-01 00:00:00		2014-10-01 00:00:00		2012-07-01 00:00:00		2012-10-01 00:00:00		2014-01-01 00:00:00		2015-07-01 00:00:00		2018-10-01 00:00:00		2018-04-01 00:00:00		2019-04-01 00:00:00		2020-04-01 00:00:00		2019-01-01 00:00:00		2019-10-01 00:00:00		2015-10-01 00:00:00		2016-01-01 00:00:00		2016-04-01 00:00:00		2016-07-01 00:00:00		2016-10-01 00:00:00		2017-01-01 00:00:00		1900-01-01 00:00:00		2017-04-01 00:00:00		1900-01-01 00:00:00		2018-01-01 00:00:00		2020-01-01 00:00:00		2020-10-01 00:00:00		2020-07-01 00:00:00		2018-07-01 00:00:00		2017-10-01 00:00:00		2019-07-01 00:00:00		2017-07-01 00:00:00		2022-01-01 00:00:00		2021-10-01 00:00:00		2021-01-01 00:00:00		2021-07-01 00:00:00		1900-01-01 00:00:00		2020-10-01 00:00:00		2021-04-01 00:00:00		2022-04-01 00:00:00		2022-07-01 00:00:00
rpt_end		1999-03-31 00:00:00		1999-09-30 00:00:00		1998-06-30 00:00:00		1997-12-31 00:00:00		1998-03-31 00:00:00		1997-06-30 00:00:00		1999-06-30 00:00:00		1998-09-30 00:00:00		1998-12-31 00:00:00		1997-09-30 00:00:00		1999-12-31 00:00:00		2000-03-31 00:00:00		2000-06-30 00:00:00		1900-01-01 00:00:00		2000-09-30 00:00:00		2001-03-31 00:00:00		2000-12-31 00:00:00		None		2001-06-30 00:00:00		2001-09-30 00:00:00		2001-12-31 00:00:00		2002-03-31 00:00:00		2002-06-30 00:00:00		1900-01-01 00:00:00		2002-09-30 00:00:00		2002-09-30 00:00:00		2002-12-31 00:00:00		2003-06-30 00:00:00		2003-03-31 00:00:00		2003-03-31 00:00:00		2002-12-31 00:00:00		2003-06-30 00:00:00		1900-01-01 00:00:00		2003-12-31 00:00:00		2003-09-30 00:00:00		2003-09-30 00:00:00		1900-01-01 00:00:00		2003-12-31 00:00:00		2004-06-30 00:00:00		2004-03-31 00:00:00		2004-06-30 00:00:00		2004-03-31 00:00:00		2004-09-30 00:00:00		1900-01-01 00:00:00		2004-09-30 00:00:00		1900-01-01 00:00:00		2004-12-31 00:00:00		2004-12-31 00:00:00		2005-06-30 00:00:00		2005-03-31 00:00:00		2005-09-30 00:00:00		2005-12-31 00:00:00		2006-03-31 00:00:00		1900-01-01 00:00:00		2006-06-30 00:00:00		2006-09-30 00:00:00		2006-12-31 00:00:00		2006-11-16 00:00:00		2007-03-31 00:00:00		2007-06-30 00:00:00		2007-06-30 00:00:00		1900-01-01 00:00:00		2007-12-31 00:00:00		2007-09-30 00:00:00		2015-06-30 00:00:00		2014-06-30 00:00:00		1900-01-01 00:00:00		2015-03-31 00:00:00		2014-09-30 00:00:00		2008-03-31 00:00:00		2008-03-31 00:00:00		2008-06-30 00:00:00		2008-09-30 00:00:00		2008-12-16 00:00:00		2008-12-31 00:00:00		1900-01-01 00:00:00		2009-06-30 00:00:00		2009-12-31 00:00:00		2009-09-30 00:00:00		2009-03-31 00:00:00		2010-03-31 00:00:00		2010-06-30 00:00:00		2010-09-30 00:00:00		1900-01-01 00:00:00		2010-12-17 00:00:00		2010-12-31 00:00:00		2011-03-31 00:00:00		2011-12-31 00:00:00		2011-09-30 00:00:00		2011-06-30 00:00:00		2012-03-31 00:00:00		2012-06-30 00:00:00		1900-01-01 00:00:00		2014-12-31 00:00:00		2012-09-30 00:00:00		2012-12-31 00:00:00		2014-03-31 00:00:00		2015-09-30 00:00:00		2018-12-31 00:00:00		2018-06-30 00:00:00		2019-06-30 00:00:00		2020-06-30 00:00:00		2019-03-31 00:00:00		2019-12-31 00:00:00		2015-12-31 00:00:00		2016-03-31 00:00:00		2016-06-30 00:00:00		2016-09-30 00:00:00		2016-12-31 00:00:00		2017-03-31 00:00:00		1900-01-01 00:00:00		2017-06-30 00:00:00		1900-01-01 00:00:00		2018-03-31 00:00:00		2020-03-31 00:00:00		2020-12-31 00:00:00		2020-09-30 00:00:00		2018-09-30 00:00:00		2017-12-31 00:00:00		2019-09-30 00:00:00		2017-09-30 00:00:00		2022-03-31 00:00:00		2021-12-31 00:00:00		2021-03-31 00:00:00		2021-09-30 00:00:00		1900-01-01 00:00:00		2020-12-31 00:00:00		2021-06-30 00:00:00		2022-06-30 00:00:00		2022-09-30 00:00:00
rpt_date		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
filing_type		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		22006		22006		None		22001		None		None		22006		None		22006		None		None		None		22006		22006		None		22006		None		None		None		None		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22001		22001		None		22001		22001		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		None		22001		22006		22006		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		None		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		22001

Table: filer_interests

filer_id		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565
session_id		2001		2003		1997		1999		2011		2013		2005		2007		2009		2021		2017		2019		2015		2023
interest_cd		40303		40303		40303		40303		40312		40312		40303		40303		40303		40312		40312		40312		40312		40312
effect_date		2001-01-01 00:00:00		2003-01-01 00:00:00		1997-05-01 00:00:00		1999-01-01 00:00:00		2011-01-01 00:00:00		2013-01-01 00:00:00		2005-01-01 00:00:00		2007-01-01 00:00:00		2009-01-01 00:00:00		2021-01-01 00:00:00		2017-01-01 00:00:00		2019-01-01 00:00:00		2015-01-01 00:00:00		2023-01-01 00:00:00

Table: filer_to_filer_type

filer_id		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565
filer_type		1		1		1		1		1		1		1		1		1		1		1		1		1		1		1
active		Y		Y		Y		Y		Y		Y		Y		T		Y		Y		Y		Y		Y		Y		N
race		0		0		0		None		None		None		None		0		None		None		None		None		None		None		None
session_id		1999		1997		2001		2003		2005		2007		2011		2011		2013		2009		2015		2021		2019		2017		2023
category		0		0		0		None		None		None		None		0		None		None		None		None		None		None		None
category_type		0		0		0		None		None		None		None		0		None		None		None		None		None		None		None
sub_category		0		0		0		None		None		None		None		0		None		None		None		None		None		None		None
effect_dt		1999-01-01 00:00:00		1997-05-01 00:00:00		2001-01-01 00:00:00		2003-01-01 00:00:00		2005-01-01 00:00:00		2007-01-01 00:00:00		2011-01-01 00:00:00		2012-11-30 00:00:00		2014-03-10 00:00:00		2009-01-01 00:00:00		2015-01-01 00:00:00		2021-01-01 00:00:00		2019-01-01 00:00:00		2017-01-01 00:00:00		2023-01-01 00:00:00
sub_category_type		0		0		0		None		None		None		None		0		None		None		None		None		None		None		None
election_type		0		0		0		None		None		None		None		0		None		None		None		None		None		None		None
sub_category_a		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
nyq_dt		None		None		None		None		2002-07-01 00:00:00		2002-07-01 00:00:00		None		None		None		None		None		None		None		None		None
party_cd		None		None		None		None		None		None		None		0		None		None		None		None		None		None		None
county_cd		None		None		None		None		None		None		None		0		None		None		None		None		None		None		None
district_cd		None		None		None		None		None		None		None		0		None		None		None		None		None		None		None

Table: filer_xref

filer_id		1145565
xref_id		C27070
effect_dt		1999-12-08 00:00:00
migration_source		MASTER

Table: filername

xref_filer_id		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070		C27070
filer_id		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565
filer_type		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT		CLIENT
status		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE		INACTIVE
effect_dt		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00		2023-01-01 00:00:00
naml		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES
namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None																																																																														None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None																																																																														None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
nams		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
adr1		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
adr2		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
city		SACRAMENTO		SAN DIEGO		SACRAMENTO		SAN DIEGO		SAN DIEGO		BURBANK		BURBANK		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN DIEGO		SACRAMENTO		SAN DIEGO		SAN DIEGO		BURBANK		BURBANK		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN DIEGO		SACRAMENTO		SAN DIEGO		SAN DIEGO		BURBANK		BURBANK		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN DIEGO		SACRAMENTO		SAN DIEGO		SAN DIEGO		BURBANK		BURBANK		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN DIEGO		SACRAMENTO		SAN DIEGO		SAN DIEGO		BURBANK		BURBANK		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN DIEGO		SACRAMENTO		SAN DIEGO		SAN DIEGO		BURBANK		BURBANK		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN DIEGO		SACRAMENTO		SAN DIEGO		SAN DIEGO		BURBANK		BURBANK		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN DIEGO		SACRAMENTO		SAN DIEGO		SAN DIEGO		BURBANK		BURBANK		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN DIEGO		SACRAMENTO		SAN DIEGO		SAN DIEGO		BURBANK		BURBANK		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN DIEGO		SACRAMENTO		SAN DIEGO		SAN DIEGO		BURBANK		BURBANK		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN DIEGO		SACRAMENTO		SAN DIEGO		SAN DIEGO		BURBANK		BURBANK		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN DIEGO		SACRAMENTO		SAN DIEGO		SAN DIEGO		BURBANK		BURBANK		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN DIEGO		SACRAMENTO		SAN DIEGO		SAN DIEGO		BURBANK		BURBANK		SACRAMENTO		SACRAMENTO		SACRAMENTO		SACRAMENTO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SACRAMENTO		SACRAMENTO		SACRAMENTO
st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA
zip4		95825		92101		95825		92101		92101		91505		91505		95825		958601902		958601902		958601902		94103		94103		94103		94103		94103		95814		95814		95814		95825		92101		95825		92101		92101		91505		91505		95825		958601902		958601902		958601902		94103		94103		94103		94103		94103		95814		95814		95814		95825		92101		95825		92101		92101		91505		91505		95825		958601902		958601902		958601902		94103		94103		94103		94103		94103		95814		95814		95814		95825		92101		95825		92101		92101		91505		91505		95825		958601902		958601902		958601902		94103		94103		94103		94103		94103		95814		95814		95814		95825		92101		95825		92101		92101		91505		91505		95825		958601902		958601902		958601902		94103		94103		94103		94103		94103		95814		95814		95814		95825		92101		95825		92101		92101		91505		91505		95825		958601902		958601902		958601902		94103		94103		94103		94103		94103		95814		95814		95814		95825		92101		95825		92101		92101		91505		91505		95825		958601902		958601902		958601902		94103		94103		94103		94103		94103		95814		95814		95814		95825		92101		95825		92101		92101		91505		91505		95825		958601902		958601902		958601902		94103		94103		94103		94103		94103		95814		95814		95814		95825		92101		95825		92101		92101		91505		91505		95825		958601902		958601902		958601902		94103		94103		94103		94103		94103		95814		95814		95814		95825		92101		95825		92101		92101		91505		91505		95825		958601902		958601902		958601902		94103		94103		94103		94103		94103		95814		95814		95814		95825		92101		95825		92101		92101		91505		91505		95825		958601902		958601902		958601902		94103		94103		94103		94103		94103		95814		95814		95814		95825		92101		95825		92101		92101		91505		91505		95825		958601902		958601902		958601902		94103		94103		94103		94103		94103		95814		95814		95814		95825		92101		95825		92101		92101		91505		91505		95825		958601902		958601902		958601902		94103		94103		94103		94103		94103		95814		95814		95814
phon		2139727297		6192380700		2139727297		6192380700		6192398678		8184861680		8184861680		9169730807		9169730807		9169730807		9169730807		9169730807		4154301140		4154301140		4154301140		4154301140		4154301140		4154301140		4154301140		2139727297		6192380700		2139727297		6192380700		6192398678		8184861680		8184861680		9169730807		9169730807		9169730807		9169730807		9169730807		4154301140		4154301140		4154301140		4154301140		4154301140		4154301140		4154301140		2139727297		6192380700		2139727297		6192380700		6192398678		8184861680		8184861680		9169730807		9169730807		9169730807		9169730807		9169730807		4154301140		4154301140		4154301140		4154301140		4154301140		4154301140		4154301140		2139727297		6192380700		2139727297		6192380700		6192398678		8184861680		8184861680		9169730807		9169730807		9169730807		9169730807		9169730807		4154301140		4154301140		4154301140		4154301140		4154301140		4154301140		4154301140		2139727297		6192380700		2139727297		6192380700		6192398678		8184861680		8184861680		9169730807		9169730807		9169730807		9169730807		9169730807		4154301140		4154301140		4154301140		4154301140		4154301140		4154301140		4154301140		2139727297		6192380700		2139727297		6192380700		6192398678		8184861680		8184861680		9169730807		9169730807		9169730807		9169730807		9169730807		4154301140		4154301140		4154301140		4154301140		4154301140		4154301140		4154301140		2139727297		6192380700		2139727297		6192380700		6192398678		8184861680		8184861680		9169730807		9169730807		9169730807		9169730807		9169730807		4154301140		4154301140		4154301140		4154301140		4154301140		4154301140		4154301140		2139727297		6192380700		2139727297		6192380700		6192398678		8184861680		8184861680		9169730807		9169730807		9169730807		9169730807		9169730807		4154301140		4154301140		4154301140		4154301140		4154301140		4154301140		4154301140		2139727297		6192380700		2139727297		6192380700		6192398678		8184861680		8184861680		9169730807		9169730807		9169730807		9169730807		9169730807		4154301140		4154301140		4154301140		4154301140		4154301140		4154301140		4154301140		2139727297		6192380700		2139727297		6192380700		6192398678		8184861680		8184861680		9169730807		9169730807		9169730807		9169730807		9169730807		4154301140		4154301140		4154301140		4154301140		4154301140		4154301140		4154301140		2139727297		6192380700		2139727297		6192380700		6192398678		8184861680		8184861680		9169730807		9169730807		9169730807		9169730807		9169730807		4154301140		4154301140		4154301140		4154301140		4154301140		4154301140		4154301140		2139727297		6192380700		2139727297		6192380700		6192398678		8184861680		8184861680		9169730807		9169730807		9169730807		9169730807		9169730807		4154301140		4154301140		4154301140		4154301140		4154301140		4154301140		4154301140		2139727297		6192380700		2139727297		6192380700		6192398678		8184861680		8184861680		9169730807		9169730807		9169730807		9169730807		9169730807		4154301140		4154301140		4154301140		4154301140		4154301140		4154301140		4154301140
fax		None		None		None		None		6192380710										9169791116		9169791116		9169791116		4154301145														None		None		None		None		6192380710										9169791116		9169791116		9169791116		4154301145														None		None		None		None		6192380710										9169791116		9169791116		9169791116		4154301145														None		None		None		None		6192380710										9169791116		9169791116		9169791116		4154301145														None		None		None		None		6192380710										9169791116		9169791116		9169791116		4154301145														None		None		None		None		6192380710										9169791116		9169791116		9169791116		4154301145														None		None		None		None		6192380710										9169791116		9169791116		9169791116		4154301145														None		None		None		None		6192380710										9169791116		9169791116		9169791116		4154301145														None		None		None		None		6192380710										9169791116		9169791116		9169791116		4154301145														None		None		None		None		6192380710										9169791116		9169791116		9169791116		4154301145														None		None		None		None		6192380710										9169791116		9169791116		9169791116		4154301145														None		None		None		None		6192380710										9169791116		9169791116		9169791116		4154301145														None		None		None		None		6192380710										9169791116		9169791116		9169791116		4154301145
email		None		None		None		None		[email protected]		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None		None		None		None		None		[email protected]		None		None		None		None		None		[email protected]		[email protected]		[email protected]		None		None		None		None		None		None

Table: filers

filer_id		1145565

Table: lobbying_chg_log

filer_id		1145565		1145565		1145565
change_no		1		2		0
session_id		1999		2013		2013
log_dt		2000-11-21 00:00:00		2012-11-19 00:00:00		2014-03-20 00:00:00
filer_type		1		1		1
correction_flg		None		None		Y
action		SET ACTIVE		SET INACTIVE		ADDED
attribute_changed		CLIENT		FIRM		FIRM
ethics_dt		None		None		None
interests		None		None		None
filer_full_name		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES		CALIFORNIA ARTS ADVOCATES
filer_city		SAN FRANCISCO		None		None
filer_st		CA		None		None
filer_zip		94109		None		None
filer_phone		4156744730		None		None
entity_type		3		3		3
entity_name		LYNCH & ASSOCIATES		LYNCH & ASSOCIATES		SHAW/YODER/ANTWIH, INC.
entity_city		None		None		None
entity_st		None		None		None
entity_zip		None		None		None
entity_phone		None		None		None
entity_id		1147302		1147302		1147267
responsible_officer		None		None		None
effect_dt		None		2012-11-30 00:00:00		2014-03-10 00:00:00

Table: received_filings

filer_id		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565		1145565
filing_file_name		883268_0.cal		910862_0.cal		930783_0.cal		947142_0.cal		969019_0.cal		1864279_0.cal		1839610_0.cal		2124889_0.cal		2152419_0.cal		2056306_0.cal		2006394_0.cal		1993539_0.cal		2099854_0.cal		2029095_0.cal		1901030_0.cal		1959776_0.cal		1929408_0.cal		1975827_0.cal		2169877_0.cal		2336535_0.cal		2269690_0.cal		2414435_0.cal		2480941_0.cal		2391471_0.cal		2234296_0.cal		2309511_0.cal		2375277_0.cal		2203663_0.cal		2466265_0.cal		2188711_0.cal		2432112_0.cal		2574284_0.cal		2544778_0.cal		2734167_0.cal		2634732_0.cal		2544778_1.cal		2698937_0.cal		2518209_0.cal		2593191_0.cal		2666720_0.cal		2616039_0.cal
received_date		2002-10-30 00:00:00		2003-01-30 00:00:00		2003-04-30 00:00:00		2003-07-31 00:00:00		2003-10-30 00:00:00		2014-07-18 00:00:00		2014-04-18 00:00:00		2017-01-26 00:00:00		2017-04-23 00:00:00		2016-07-19 00:00:00		2016-01-25 00:00:00		2015-10-22 00:00:00		2016-10-28 00:00:00		2016-04-17 00:00:00		2014-10-20 00:00:00		2015-04-20 00:00:00		2015-01-25 00:00:00		2015-07-21 00:00:00		2017-07-22 00:00:00		2019-01-21 00:00:00		2018-07-25 00:00:00		2019-10-22 00:00:00		2020-07-25 00:00:00		2019-07-20 00:00:00		2018-04-23 00:00:00		2018-10-20 00:00:00		2019-04-19 00:00:00		2018-01-21 00:00:00		2020-04-19 00:00:00		2017-10-18 00:00:00		2020-01-18 00:00:00		2021-04-14 00:00:00		2021-01-17 00:00:00		2022-10-14 00:00:00		2022-01-16 00:00:00		2021-12-03 00:00:00		2022-07-18 00:00:00		2020-10-19 00:00:00		2021-07-14 00:00:00		2022-04-15 00:00:00		2021-10-14 00:00:00
filing_directory		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal
filing_id		883268		910862		930783		947142		969019		1864279		1839610		2124889		2152419		2056306		2006394		1993539		2099854		2029095		1901030		1959776		1929408		1975827		2169877		2336535		2269690		2414435		2480941		2391471		2234296		2309511		2375277		2203663		2466265		2188711		2432112		2574284		2544778		2734167		2634732		2544778		2698937		2518209		2593191		2666720		2616039
form_id		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635
receive_comment		Filing accepted		Filing accepted		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted