Home

Filer ID: 1147167

Table: filer_address

filer_id		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167
adrid		1113499		2011837		2042027		2041867		2081176		2081178		2113511		2159842		2202071		2203359		2203360		2413797		2413798		2508131		2508132		2467479		2278336		2278337		2340426		2340427
effect_dt		1998-10-23 00:00:00		2001-01-01 00:00:00		2003-01-01 00:00:00		2003-01-01 00:00:00		2005-01-01 00:00:00		2005-01-01 00:00:00		2007-01-01 00:00:00		2009-01-01 00:00:00		2010-10-11 00:00:00		2011-01-01 00:00:00		2011-01-01 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2019-01-01 00:00:00		2013-01-29 00:00:00		2013-01-29 00:00:00		2015-01-01 00:00:00		2015-01-01 00:00:00
add_type		7051		7051		7082		7051		7082		7051		7051		7051		7051		7051		7082		7051		7082		7051		7082		7051		7051		7082		7051		7082
session_id		1997		2001		2003		2003		2005		2005		2007		2009		2009		2011		2011		2017		2017		2021		2021		2019		2013		2013		2015		2015

Table: filer_filings

filer_id		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167
filing_id		705942		756896		758268		746984		773873		778181		813005		819355		798456		839421		830968		844253		813005		832342		839421		860920		847701		855519		897736		881769		894109		913993		933232		931921		910605		936175		948110		950386		937337		969291		988678		975110		1012505		1006330		1002658		1034699		1017469		1030130		988678		1055626		1071039		1094829		1064592		1081408		1081408		1127442		1103705		1117180		1089900		1130868		1148997		1166738		1151813		1191632		1208744		1225004		1242850		1228363		1229313		1256261		1280999		1261762		1235541		1301948		1261762		1292330		1295072		1761257		1840733		1863508		1840733		1799066		1777137		1810951		1960477		1908150		1316139		1310000		1329918		1310000		1316619		1315289		1345840		1392766		1405273		1375480		1419717		1435633		1451844		1461097		1488127		1488127		1503694		1530825		1503694		1527192		1551335		1557827		1563258		1563258		1587400		1602781		1587400		1619852		1634027		1654951		1634027		1677976		1654951		1927091		1928728		1918244		1706666		1863508		1722398		1735768		1840733		1735768		1761257		1762515		1977752		2004058		2317309		2528297		2188949		2203998		2436154		2340680		2395402		2203998		1994702		2033192		2057026		2121473		2121473		2148267		2151565		2121473		2148267		2166045		2336059		2380157		2183012		2340680		2269217		2483594		2236088		2418091		2395402		2317309		2395402		2528297		2436154		2468203		2418091		2468203		2700529		2598064		2584822		2670114		2640822		2549588		2549588		2483594		2580737		2622335		2747352
period_id		None		165		None		165		166		None		168		None		167		169		None		None		168		None		169		None		None		170		None		171		None		None		None		173		172		None		174		174		None		175		176		None		177		None		None		None		None		178		176		179		None		None		None		180		180		None		181		182		None		183		184		185		None		186		187		188		None		None		None		None		190		189		188		None		189		None		191		213		217		218		217		215		214		216		221		219		193		192		193		192		None		None		194		196		None		195		197		198		199		200		201		201		202		203		202		None		204		None		204		204		205		206		205		207		208		209		208		210		209		None		220		220		211		218		213		212		217		212		213		None		222		224		235		243		231		232		240		236		238		232		223		225		226		228		228		227		229		228		227		None		None		237		230		236		234		242		233		239		238		235		238		243		240		241		239		241		250		246		None		249		248		244		244		242		245		247		251
form_id		F603		F635		F605		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F603		F635		F635		F635		F602		F635		F635		F635		F635		F635		F605		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F603		F635		F635		F635		F635		F635		F635		F635		F602		F635		F635		F635		F605		F635		F635		F602		F602		F605		F603		F605		F635		F635		F635		F666		F635		F605		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F603		F635		F635		F635		F603		F605		F635		F635		F603		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F605		F603		F603		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F603		F635		F603		F635		F635		F603		F635		F635		F635		F635		F603		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F603		F603		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F603		F635		F635		F635		F635		F635		F635		F635		F635
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		1		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		1		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		1		0		0		1		2		1		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		1		0		0		0		0		1		0		0		1		0		0		0		1		0		1		0		0		0		0		0		0		0		1		1		0		0		0		0		1		0		0		0		0		0		2		1		0		0		0		0		1		0		0		2		1		0		0		0		0		1		0		0		0		0		1		0		0		1		1		1		1		0		0		0		0		0		0		0		1		1		0		0		0
filing_date		2000-12-21 00:00:00		2001-04-30 00:00:00		2001-05-22 00:00:00		2001-05-01 00:00:00		2001-08-03 00:00:00		2001-08-03 00:00:00		2002-01-30 00:00:00		2002-01-31 00:00:00		2001-11-20 00:00:00		2002-04-30 00:00:00		2001-10-31 00:00:00		2002-04-30 00:00:00		2002-02-27 00:00:00		2002-02-28 00:00:00		2002-06-19 00:00:00		2002-07-31 00:00:00		2002-06-12 00:00:00		2002-07-31 00:00:00		2002-12-18 00:00:00		2002-10-29 00:00:00		2002-10-31 00:00:00		2003-01-30 00:00:00		2003-04-29 00:00:00		2003-04-30 00:00:00		2003-01-30 00:00:00		2003-04-30 00:00:00		2003-07-31 00:00:00		2003-07-31 00:00:00		2003-05-14 00:00:00		2003-10-30 00:00:00		2004-01-29 00:00:00		2003-10-31 00:00:00		2004-04-29 00:00:00		2004-02-11 00:00:00		2004-01-30 00:00:00		2004-07-30 00:00:00		2004-04-29 00:00:00		2004-07-30 00:00:00		2004-02-11 00:00:00		2004-10-27 00:00:00		2004-12-23 00:00:00		2005-01-31 00:00:00		2004-10-29 00:00:00		2005-01-31 00:00:00		2005-02-08 00:00:00		2005-02-08 00:00:00		2005-04-28 00:00:00		2005-07-29 00:00:00		2004-12-29 00:00:00		2005-10-26 00:00:00		2006-01-31 00:00:00		2006-04-28 00:00:00		2006-02-07 00:00:00		2006-07-31 00:00:00		2006-10-18 00:00:00		2006-12-28 00:00:00		2006-12-29 00:00:00		2006-12-26 00:00:00		2006-12-26 00:00:00		2007-03-26 00:00:00		2007-07-26 00:00:00		2007-04-30 00:00:00		2007-01-30 00:00:00		2007-12-31 00:00:00		2007-09-20 00:00:00		2007-10-03 00:00:00		2007-10-25 00:00:00		2013-08-29 00:00:00		2014-07-23 00:00:00		2014-07-23 00:00:00		2014-04-23 00:00:00		2013-10-30 00:00:00		2013-07-22 00:00:00		2014-01-17 00:00:00		2015-04-22 00:00:00		2014-10-29 00:00:00		2008-02-21 00:00:00		2008-03-27 00:00:00		2008-04-30 00:00:00		2008-01-30 00:00:00		2008-02-20 00:00:00		2008-02-13 00:00:00		2008-07-24 00:00:00		2009-01-27 00:00:00		2008-12-22 00:00:00		2008-10-29 00:00:00		2009-04-28 00:00:00		2009-07-29 00:00:00		2009-10-30 00:00:00		2010-01-27 00:00:00		2010-05-17 00:00:00		2010-06-17 00:00:00		2010-07-27 00:00:00		2010-10-21 00:00:00		2010-10-18 00:00:00		2010-10-15 00:00:00		2010-12-17 00:00:00		2010-12-29 00:00:00		2011-01-21 00:00:00		2011-04-05 00:00:00		2011-04-21 00:00:00		2011-07-25 00:00:00		2011-07-06 00:00:00		2011-10-26 00:00:00		2012-01-30 00:00:00		2012-04-26 00:00:00		2012-03-14 00:00:00		2012-07-30 00:00:00		2012-05-30 00:00:00		2014-12-19 00:00:00		2015-01-23 00:00:00		2014-12-15 00:00:00		2012-10-29 00:00:00		2014-07-16 00:00:00		2013-01-03 00:00:00		2013-01-30 00:00:00		2014-04-24 00:00:00		2013-04-04 00:00:00		2013-04-24 00:00:00		2013-01-29 00:00:00		2015-07-27 00:00:00		2016-01-15 00:00:00		2018-11-16 00:00:00		2020-10-30 00:00:00		2017-10-19 00:00:00		2018-01-22 00:00:00		2020-01-27 00:00:00		2019-01-25 00:00:00		2020-07-22 00:00:00		2018-03-13 00:00:00		2015-10-27 00:00:00		2016-04-27 00:00:00		2016-07-21 00:00:00		2017-01-20 00:00:00		2017-01-23 00:00:00		2017-03-27 00:00:00		2017-04-18 00:00:00		2017-04-10 00:00:00		2017-04-10 00:00:00		2017-07-06 00:00:00		2018-12-17 00:00:00		2019-04-30 00:00:00		2017-09-05 00:00:00		2019-04-10 00:00:00		2018-07-25 00:00:00		2020-07-30 00:00:00		2018-04-25 00:00:00		2019-10-30 00:00:00		2019-09-10 00:00:00		2018-10-30 00:00:00		2019-07-29 00:00:00		2022-02-24 00:00:00		2020-07-22 00:00:00		2020-07-22 00:00:00		2020-07-22 00:00:00		2020-04-28 00:00:00		2022-07-25 00:00:00		2021-07-28 00:00:00		2021-01-19 00:00:00		2022-04-25 00:00:00		2022-01-28 00:00:00		2021-01-28 00:00:00		2022-02-24 00:00:00		2022-02-24 00:00:00		2021-04-30 00:00:00		2021-10-29 00:00:00		2022-10-31 00:00:00
stmnt_type		10005		10005		10005		10001		10001		10005		10001		10005		10001		10001		10005		10005		10002		10006		10002		10005		10006		10001		10005		10001		10005		10005		10005		10001		10001		10005		10001		10005		10005		10001		10001		10005		10001		10006		10005		10005		10005		10001		10002		10001		10005		10005		10005		10001		10002		10006		10001		10001		10005		10001		10001		10001		10005		10001		10001		10001		10005		10005		10005		10005		10001		10001		10001		10005		10002		10005		10001		10002		10002		10002		10001		10001		10001		10001		10001		10001		10001		10002		10001		10001		10005		10005		10001		10001		10005		10001		10001		10001		10001		10001		10001		10002		10001		10001		10002		10006		10001		10005		10001		10002		10001		10001		10002		10001		10001		10001		10002		10001		10002		10005		10001		10001		10001		10001		10001		10001		10002		10002		10001		10005		10001		10001		10002		10001		10001		10001		10001		10001		10002		10002		10001		10001		10001		10001		10002		10001		10001		10002		10002		10005		10005		10001		10001		10002		10001		10001		10001		10001		10002		10001		10001		10002		10002		10002		10002		10001		10001		10001		10005		10001		10001		10001		10002		10002		10001		10001		10001
stmnt_status		11001		11001		11001		11003		11003		11001		11003		11001		11003		11003		11001		11001		11003		11003		11003		11001		11001		11003		11001		11003		11001		11001		11001		11003		11003		11001		11003		11003		11001		11003		11003		11001		11003		11003		11001		11001		11001		11003		11003		11003		11003		11001		11001		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11003		11003		11001		11003		11003		11001		11003		11003		11003		11003		11003
session_id		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		2001		2001		2001		2003		2003		2001		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2005		2003		2003		2003		2003		2003		2005		2005		2005		2005		2005		2005		2005		2005		2005		2007		2007		2005		2007		2007		2007		2007		2005		2005		2007		2007		2007		2013		2013		2013		2013		2013		2013		2013		2015		2013		2008		2007		2007		2007		2007		2007		2007		2007		2009		2007		2009		2009		2009		2009		2009		2009		2009		2009		2009		2009		2011		2011		2009		2009		2011		2011		2011		2011		2011		2011		2011		2011		2011		2015		2013		2015		2011		2013		2013		2011		2013		2011		2013		2013		2015		2015		2017		2019		2017		2017		2019		2017		2019		2017		2015		2015		2015		2015		2015		2015		2017		2015		2015		2017		2019		2019		2017		2017		2017		2019		2017		2019		2019		2017		2019		2019		2019		2019		2019		2019		2021		2021		2021		2021		2021		2019		2019		2019		2021		2021		2021
user_id		CFLAGG		LTHIBAUL		GPEREZ		*		DHORRELL		LTHIBAUL		*		LTHIBAUL		DHORRELL		*		LTHIBAUL		LTHIBAUL		*		DPASTRAN		*		LTHIBAUL		LTHIBAUL		*		PBANFORD		*		LTHIBAUL		LTHIBAUL		SARRIAGA		COMPLETED		COMPLETED		LTHIBAUL		COMPLETED		CFLAGG		CFLAGG		COMPLETED		COMPLETED		LTHIBAUL		COMPLETED		EMCENTEE		LTHIBAUL		LTHIBAUL		LTHIBAUL		COMPLETED		COMPLETED		COMPLETED		LTHIBAUL		LTHIBAUL		LTHIBAUL		COMPLETED		COMPLETED		GGILMORE		LTHIBAUL		LTHIBAUL		SARRIAGA		LTHIBAUL		LTHIBAUL		LTHIBAUL		GPEREZ		LTHIBAUL		LTHIBAUL		*		GPEREZ		SARRIAGA		PBANFORD		GPEREZ		LTHIBAUL		LTHIBAUL		LTHIBAUL		NLANDERS		LTHIBAUL		SARRIAGA		YRODRIGU		AGLADNEY		ASAETERN		ASAETERN		AGLADNEY		ASAETERN		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		*		LTHIBAUL		LTHIBAUL		LTHIBAUL		CFLAGG		GPEREZ		LTHIBAUL		AGLADNEY		CFLAGG		ASAETERN		MGUERRA		MGUERRA		MGUERRA		MGUERRA		ASAETERN		ASAETERN		ASAETERN		ASAETERN		ASAETERN		YRODRIGU		*		CFLAGG		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		ASAETERN		ASAETERN		AGLADNEY		AGLADNEY		AGLADNEY		GPEREZ		MPACHECO		CAFILER		AGLADNEY		ASAETERN		YRODRIGU		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		YRODRIGU		AGLADNEY		AGLADNEY		AGLADNEY		MKIRKHAM		AGLADNEY		AGLADNEY		GTAYLOR		AGLADNEY		GTAYLOR		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		KBANH		AGLADNEY		AGLADNEY		AGLADNEY		GPEREZ		DMCCASTL		VUKSTINA		AGLADNEY		AGLADNEY		AGLADNEY		MKIRKHAM		AGLADNEY		AGLADNEY		GTAYLOR		AGLADNEY		GTAYLOR		CAFILER		GTAYLOR		GTAYLOR		GTAYLOR		GTAYLOR		CAFILER		CAFILER		MMERCHANT		CAFILER		CAFILER		GTAYLOR		CAFILER		CAFILER		CAFILER		CAFILER		CAFILER
special_audit		11003		11003		11003		11003		11003		11003		11003		11002		11003		11003		11003		11002		11003		11003		11003		11002		11003		11003		11003		11003		11002		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
fine_audit		11003		11003		11003		11003		11001		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		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		11001		11001		11001		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003
rpt_start		1900-01-01 00:00:00		2001-01-01 00:00:00		1900-01-01 00:00:00		2001-01-01 00:00:00		2001-04-01 00:00:00		2001-04-01 00:00:00		2001-10-01 00:00:00		2001-10-01 00:00:00		2001-07-01 00:00:00		2002-01-01 00:00:00		2001-07-01 00:00:00		2002-01-01 00:00:00		2001-10-01 00:00:00		2001-10-01 00:00:00		2002-01-01 00:00:00		2002-04-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		1900-01-01 00:00:00		2003-01-01 00:00:00		2002-10-01 00:00:00		2003-01-01 00:00:00		2003-04-01 00:00:00		2003-04-01 00:00:00		1900-01-01 00:00:00		2003-07-01 00:00:00		2003-10-01 00:00:00		2003-07-01 00:00:00		2004-01-01 00:00:00		2003-10-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		2003-10-01 00:00:00		2004-07-01 00:00:00		1900-01-01 00:00:00		2004-10-01 00:00:00		2004-07-01 00:00:00		2004-10-01 00:00:00		2004-10-01 00:00:00		2004-10-01 00:00:00		2005-01-01 00:00:00		2005-04-01 00:00:00		1900-01-01 00:00:00		2005-07-01 00:00:00		2005-10-01 00:00:00		2006-01-01 00:00:00		1900-01-01 00:00:00		2006-04-01 00:00:00		2006-07-01 00:00:00		2006-12-28 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2007-04-01 00:00:00		2007-01-01 00:00:00		2006-10-01 00:00:00		2005-01-01 00:00:00		2007-01-01 00:00:00		1900-01-01 00:00:00		2007-07-01 00:00:00		2013-01-01 00:00:00		2014-01-01 00:00:00		2014-04-01 00:00:00		2014-01-01 00:00:00		2013-07-01 00:00:00		2013-04-01 00:00:00		2013-10-01 00:00:00		2015-01-01 00:00:00		2014-07-01 00:00:00		2008-02-21 00:00:00		2007-10-01 00:00:00		2008-01-01 00:00:00		2007-10-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2008-04-01 00:00:00		2008-10-01 00:00:00		1900-01-01 00:00:00		2008-07-01 00:00:00		2009-01-01 00:00:00		2009-04-01 00:00:00		2009-07-01 00:00:00		2009-10-01 00:00:00		2010-01-01 00:00:00		2010-01-01 00:00:00		2010-04-01 00:00:00		2010-07-01 00:00:00		2010-04-01 00:00:00		1900-01-01 00:00:00		2010-12-17 00:00:00		1900-01-01 00:00:00		2010-10-01 00:00:00		2010-10-01 00:00:00		2011-01-01 00:00:00		2011-04-01 00:00:00		2011-01-01 00:00:00		2011-07-01 00:00:00		2011-10-01 00:00:00		2012-01-01 00:00:00		2011-10-01 00:00:00		2012-04-01 00:00:00		2012-01-01 00:00:00		1900-01-01 00:00:00		2014-10-01 00:00:00		2014-12-15 00:00:00		2012-07-01 00:00:00		2014-04-01 00:00:00		2013-01-03 00:00:00		2012-10-01 00:00:00		2014-01-01 00:00:00		2012-10-01 00:00:00		2013-01-01 00:00:00		1900-01-01 00:00:00		2015-04-01 00:00:00		2015-10-01 00:00:00		2018-07-01 00:00:00		2020-07-01 00:00:00		2017-07-01 00:00:00		2017-10-01 00:00:00		2019-10-01 00:00:00		2018-10-01 00:00:00		2019-04-01 00:00:00		2017-10-01 00:00:00		2015-07-01 00:00:00		2016-01-01 00:00:00		2016-04-01 00:00:00		2016-10-01 00:00:00		2016-10-01 00:00:00		2016-07-01 00:00:00		2017-01-01 00:00:00		2016-10-01 00:00:00		2016-07-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2019-01-01 00:00:00		2017-04-01 00:00:00		2018-10-01 00:00:00		2018-04-01 00:00:00		2020-04-01 00:00:00		2018-01-01 00:00:00		2019-07-01 00:00:00		2019-04-01 00:00:00		2018-07-01 00:00:00		2019-04-01 00:00:00		2020-07-01 00:00:00		2019-10-01 00:00:00		2020-01-31 00:00:00		2019-07-01 00:00:00		2020-01-31 00:00:00		2022-04-01 00:00:00		2021-04-01 00:00:00		1900-01-01 00:00:00		2022-01-01 00:00:00		2021-10-01 00:00:00		2020-10-01 00:00:00		2020-10-01 00:00:00		2020-04-01 00:00:00		2021-01-01 00:00:00		2021-07-01 00:00:00		2022-07-01 00:00:00
rpt_end		1900-01-01 00:00:00		2001-03-31 00:00:00		1900-01-01 00:00:00		2001-03-31 00:00:00		2001-06-30 00:00:00		2001-06-30 00:00:00		2001-12-31 00:00:00		2001-12-31 00:00:00		2001-09-30 00:00:00		2002-03-31 00:00:00		2001-09-30 00:00:00		2002-03-31 00:00:00		2001-12-31 00:00:00		2001-03-31 00:00:00		2002-03-31 00:00:00		2002-06-30 00:00:00		2002-03-01 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		1900-01-01 00:00:00		2003-03-31 00:00:00		2002-12-31 00:00:00		2003-03-31 00:00:00		2003-06-30 00:00:00		2003-06-30 00:00:00		1900-01-01 00:00:00		2003-09-30 00:00:00		2003-12-31 00:00:00		2003-09-30 00:00:00		2004-03-31 00:00:00		2003-12-31 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		2003-12-31 00:00:00		2004-09-30 00:00:00		1900-01-01 00:00:00		2004-12-31 00:00:00		2004-09-30 00:00:00		2004-12-31 00:00:00		2004-12-31 00:00:00		2004-12-31 00:00:00		2005-03-31 00:00:00		2005-06-30 00:00:00		1900-01-01 00:00:00		2005-09-30 00:00:00		2005-12-31 00:00:00		2006-03-31 00:00:00		1900-01-01 00:00:00		2006-06-30 00:00:00		2006-09-30 00:00:00		2006-12-28 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2007-06-30 00:00:00		2007-03-31 00:00:00		2006-12-31 00:00:00		2006-12-31 00:00:00		2007-03-31 00:00:00		1900-01-01 00:00:00		2007-09-30 00:00:00		2013-03-31 00:00:00		2014-03-31 00:00:00		2014-06-30 00:00:00		2014-03-31 00:00:00		2013-09-30 00:00:00		2013-06-30 00:00:00		2013-12-31 00:00:00		2015-03-31 00:00:00		2014-09-30 00:00:00		2008-02-21 00:00:00		2007-12-31 00:00:00		2008-03-31 00:00:00		2008-12-31 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2008-06-30 00:00:00		2008-12-31 00:00:00		1900-01-01 00:00:00		2008-09-30 00:00:00		2009-03-31 00:00:00		2009-06-30 00:00:00		2009-09-30 00:00:00		2009-12-31 00:00:00		2010-03-31 00:00:00		2010-03-31 00:00:00		2010-06-30 00:00:00		2010-09-30 00:00:00		2010-06-30 00:00:00		1900-01-01 00:00:00		2010-12-17 00:00:00		1900-01-01 00:00:00		2010-12-31 00:00:00		2010-12-31 00:00:00		2011-03-31 00:00:00		2011-06-30 00:00:00		2011-03-31 00:00:00		3011-09-30 00:00:00		2011-12-31 00:00:00		2012-03-31 00:00:00		2011-12-31 00:00:00		2012-06-30 00:00:00		2012-03-31 00:00:00		1900-01-01 00:00:00		2014-12-31 00:00:00		2014-12-15 00:00:00		2012-09-30 00:00:00		2014-06-30 00:00:00		2013-01-03 00:00:00		2012-12-31 00:00:00		2014-03-31 00:00:00		2012-12-31 00:00:00		2013-03-31 00:00:00		1900-01-01 00:00:00		2015-06-30 00:00:00		2015-12-31 00:00:00		2018-09-30 00:00:00		2020-09-30 00:00:00		2017-09-30 00:00:00		2017-12-31 00:00:00		2019-12-31 00:00:00		2018-12-31 00:00:00		2019-06-30 00:00:00		2017-12-31 00:00:00		2015-09-30 00:00:00		2016-03-31 00:00:00		2016-06-30 00:00:00		2016-12-31 00:00:00		2016-12-31 00:00:00		2016-09-30 00:00:00		2017-03-31 00:00:00		2016-12-31 00:00:00		2016-09-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2019-03-31 00:00:00		2017-06-30 00:00:00		2018-12-31 00:00:00		2018-06-30 00:00:00		2020-06-30 00:00:00		2018-03-31 00:00:00		2019-09-30 00:00:00		2019-06-30 00:00:00		2018-09-30 00:00:00		2019-06-30 00:00:00		2020-09-30 00:00:00		2019-12-31 00:00:00		2020-03-31 00:00:00		2019-09-30 00:00:00		2020-03-31 00:00:00		2022-06-30 00:00:00		2021-06-30 00:00:00		1900-01-01 00:00:00		2022-03-31 00:00:00		2021-12-31 00:00:00		2020-12-31 00:00:00		2020-12-31 00:00:00		2020-06-30 00:00:00		2021-03-31 00:00:00		2021-09-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		None		None		None		None		None		None		None		None		None		None		None		None		None		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		22001		22001		None		22001		None		None		22001		22001		None		22001		None		None		None		None		22001		22001		22001		None		None		None		22001		22001		None		22001		22001		None		22001		22001		22001		None		22001		22001		22006		None		None		None		None		22001		22001		22001		None		22001		None		22001		22006		22006		22006		22006		22006		22006		22006		22006		22006		22001		22001		22001		22001		None		None		22001		22001		None		22001		22001		22001		22001		22001		22006		22006		22006		22006		22006		None		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22006		22006		22006		22006		22006		22006

Table: filer_interests

filer_id		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167
session_id		1997		2003		2005		2001		2009		2007		2013		2011		2017		2019		2015		2021
interest_cd		40312		40312		40312		40312		40312		40312		40312		40312		40312		40312		40312		40312
effect_date		1998-10-23 00:00:00		2003-01-01 00:00:00		2005-01-01 00:00:00		2001-01-01 00:00:00		2009-01-01 00:00:00		2007-01-01 00:00:00		2013-01-29 00:00:00		2011-01-01 00:00:00		2017-01-01 00:00:00		2019-01-01 00:00:00		2015-01-01 00:00:00		2021-01-01 00:00:00

Table: filer_to_filer_type

filer_id		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167
filer_type		2		2		2		2		2		2		2		1		2		2		2		2		2		2
active		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		Y		S		Y
race		0		0		None		None		None		None		None		None		None		None		None		None		None		None
session_id		1997		2001		2003		2005		2007		2011		2013		2007		2007		2009		2019		2015		2021		2017
category		0		0		None		None		None		None		None		None		None		None		None		None		None		None
category_type		0		0		None		None		None		None		None		None		None		None		None		None		None		None
sub_category		0		0		None		None		None		None		None		None		None		None		None		None		None		None
effect_dt		1998-10-23 00:00:00		2001-01-01 00:00:00		2003-01-01 00:00:00		2005-01-01 00:00:00		2007-01-01 00:00:00		2011-01-01 00:00:00		2013-01-29 00:00:00		2007-09-26 00:00:00		2008-02-20 00:00:00		2009-01-01 00:00:00		2019-01-01 00:00:00		2015-01-01 00:00:00		2021-01-01 00:00:00		2017-01-01 00:00:00
sub_category_type		0		0		None		None		None		None		None		None		None		None		None		None		None		None
election_type		0		0		None		None		None		None		None		None		None		None		None		None		None		None
sub_category_a		None		None		None		None		None		None		None		None		None		None		None		None		None		None
nyq_dt		None		None		None		2001-01-01 00:00:00		2001-01-01 00:00:00		None		None		2001-01-01 00:00:00		2001-01-01 00:00:00		None		None		None		None		None
party_cd		None		0		None		None		None		None		None		None		None		None		None		None		None		None
county_cd		None		0		None		None		None		None		None		None		None		None		None		None		None		None
district_cd		None		0		None		None		None		None		None		None		None		None		None		None		None		None

Table: filer_xref

filer_id		1147167
xref_id		E24715
effect_dt		1999-12-08 00:00:00
migration_source		MASTER

Table: filername

xref_filer_id		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715		E24715
filer_id		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167
filer_type		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER		EMPLOYER
status		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S		S
effect_dt		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00
naml		TRUST FOR PUBLIC LAND		TRUST FOR PUBLIC LAND		TRUST FOR PUBLIC LAND		TRUST FOR PUBLIC LAND		TRUST FOR PUBLIC LAND		TRUST FOR PUBLIC LAND		TRUST FOR PUBLIC LAND		TRUST FOR PUBLIC LAND		TRUST FOR PUBLIC LAND		TRUST FOR PUBLIC LAND		TRUST FOR PUBLIC LAND		TRUST FOR PUBLIC LAND		TRUST FOR PUBLIC LAND		TRUST FOR PUBLIC LAND		TRUST FOR PUBLIC LAND		TRUST FOR PUBLIC LAND		TRUST FOR PUBLIC LAND		TRUST FOR PUBLIC LAND		TRUST FOR PUBLIC LAND		TRUST FOR PUBLIC LAND		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE
namf		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None
namt		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		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
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
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
city		Sacramento		SAN FRANCISCO		SAN FRANCISCO		SACRAMENTO		SACRAMENTO		SAN FRANCISCO		SACRAMENTO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		DENVER		SAN FRANCISCO		DENVER		SAN FRANCISCO		DENVER		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		Sacramento		SAN FRANCISCO		SAN FRANCISCO		SACRAMENTO		SACRAMENTO		SAN FRANCISCO		SACRAMENTO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		DENVER		SAN FRANCISCO		DENVER		SAN FRANCISCO		DENVER		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		Sacramento		SAN FRANCISCO		SAN FRANCISCO		SACRAMENTO		SACRAMENTO		SAN FRANCISCO		SACRAMENTO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		DENVER		SAN FRANCISCO		DENVER		SAN FRANCISCO		DENVER		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		Sacramento		SAN FRANCISCO		SAN FRANCISCO		SACRAMENTO		SACRAMENTO		SAN FRANCISCO		SACRAMENTO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		DENVER		SAN FRANCISCO		DENVER		SAN FRANCISCO		DENVER		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		Sacramento		SAN FRANCISCO		SAN FRANCISCO		SACRAMENTO		SACRAMENTO		SAN FRANCISCO		SACRAMENTO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		DENVER		SAN FRANCISCO		DENVER		SAN FRANCISCO		DENVER		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		Sacramento		SAN FRANCISCO		SAN FRANCISCO		SACRAMENTO		SACRAMENTO		SAN FRANCISCO		SACRAMENTO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		DENVER		SAN FRANCISCO		DENVER		SAN FRANCISCO		DENVER		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		Sacramento		SAN FRANCISCO		SAN FRANCISCO		SACRAMENTO		SACRAMENTO		SAN FRANCISCO		SACRAMENTO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		DENVER		SAN FRANCISCO		DENVER		SAN FRANCISCO		DENVER		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		Sacramento		SAN FRANCISCO		SAN FRANCISCO		SACRAMENTO		SACRAMENTO		SAN FRANCISCO		SACRAMENTO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		DENVER		SAN FRANCISCO		DENVER		SAN FRANCISCO		DENVER		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		Sacramento		SAN FRANCISCO		SAN FRANCISCO		SACRAMENTO		SACRAMENTO		SAN FRANCISCO		SACRAMENTO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		DENVER		SAN FRANCISCO		DENVER		SAN FRANCISCO		DENVER		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		Sacramento		SAN FRANCISCO		SAN FRANCISCO		SACRAMENTO		SACRAMENTO		SAN FRANCISCO		SACRAMENTO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		DENVER		SAN FRANCISCO		DENVER		SAN FRANCISCO		DENVER		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		Sacramento		SAN FRANCISCO		SAN FRANCISCO		SACRAMENTO		SACRAMENTO		SAN FRANCISCO		SACRAMENTO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		DENVER		SAN FRANCISCO		DENVER		SAN FRANCISCO		DENVER		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		Sacramento		SAN FRANCISCO		SAN FRANCISCO		SACRAMENTO		SACRAMENTO		SAN FRANCISCO		SACRAMENTO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		DENVER		SAN FRANCISCO		DENVER		SAN FRANCISCO		DENVER		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO		SAN FRANCISCO
st		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CO		CA		CO		CA		CO		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CO		CA		CO		CA		CO		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CO		CA		CO		CA		CO		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CO		CA		CO		CA		CO		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CO		CA		CO		CA		CO		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CO		CA		CO		CA		CO		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CO		CA		CO		CA		CO		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CO		CA		CO		CA		CO		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CO		CA		CO		CA		CO		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CO		CA		CO		CA		CO		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CO		CA		CO		CA		CO		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CA		CO		CA		CO		CA		CO		CA		CA		CA		CA		CA
zip4		95814		94105		94105		95814		95814		94105		95814		95105		94104		94104		80203		94104		80203		94104		80203		94014		94104		94014		94014		94104		95814		94105		94105		95814		95814		94105		95814		95105		94104		94104		80203		94104		80203		94104		80203		94014		94104		94014		94014		94104		95814		94105		94105		95814		95814		94105		95814		95105		94104		94104		80203		94104		80203		94104		80203		94014		94104		94014		94014		94104		95814		94105		94105		95814		95814		94105		95814		95105		94104		94104		80203		94104		80203		94104		80203		94014		94104		94014		94014		94104		95814		94105		94105		95814		95814		94105		95814		95105		94104		94104		80203		94104		80203		94104		80203		94014		94104		94014		94014		94104		95814		94105		94105		95814		95814		94105		95814		95105		94104		94104		80203		94104		80203		94104		80203		94014		94104		94014		94014		94104		95814		94105		94105		95814		95814		94105		95814		95105		94104		94104		80203		94104		80203		94104		80203		94014		94104		94014		94014		94104		95814		94105		94105		95814		95814		94105		95814		95105		94104		94104		80203		94104		80203		94104		80203		94014		94104		94014		94014		94104		95814		94105		94105		95814		95814		94105		95814		95105		94104		94104		80203		94104		80203		94104		80203		94014		94104		94014		94014		94104		95814		94105		94105		95814		95814		94105		95814		95105		94104		94104		80203		94104		80203		94104		80203		94014		94104		94014		94014		94104		95814		94105		94105		95814		95814		94105		95814		95105		94104		94104		80203		94104		80203		94104		80203		94014		94104		94014		94014		94104		95814		94105		94105		95814		95814		94105		95814		95105		94104		94104		80203		94104		80203		94104		80203		94014		94104		94014		94014		94104
phon		9165571673		9165571673				9165571673				9165571673		9165571673		4154954014		3038672335		3038672335				3038672335				3038672335				4154954014				4154954014		4154954014				9165571673		9165571673				9165571673				9165571673		9165571673		4154954014		3038672335		3038672335				3038672335				3038672335				4154954014				4154954014		4154954014				9165571673		9165571673				9165571673				9165571673		9165571673		4154954014		3038672335		3038672335				3038672335				3038672335				4154954014				4154954014		4154954014				9165571673		9165571673				9165571673				9165571673		9165571673		4154954014		3038672335		3038672335				3038672335				3038672335				4154954014				4154954014		4154954014				9165571673		9165571673				9165571673				9165571673		9165571673		4154954014		3038672335		3038672335				3038672335				3038672335				4154954014				4154954014		4154954014				9165571673		9165571673				9165571673				9165571673		9165571673		4154954014		3038672335		3038672335				3038672335				3038672335				4154954014				4154954014		4154954014				9165571673		9165571673				9165571673				9165571673		9165571673		4154954014		3038672335		3038672335				3038672335				3038672335				4154954014				4154954014		4154954014				9165571673		9165571673				9165571673				9165571673		9165571673		4154954014		3038672335		3038672335				3038672335				3038672335				4154954014				4154954014		4154954014				9165571673		9165571673				9165571673				9165571673		9165571673		4154954014		3038672335		3038672335				3038672335				3038672335				4154954014				4154954014		4154954014				9165571673		9165571673				9165571673				9165571673		9165571673		4154954014		3038672335		3038672335				3038672335				3038672335				4154954014				4154954014		4154954014				9165571673		9165571673				9165571673				9165571673		9165571673		4154954014		3038672335		3038672335				3038672335				3038672335				4154954014				4154954014		4154954014				9165571673		9165571673				9165571673				9165571673		9165571673		4154954014		3038672335		3038672335				3038672335				3038672335				4154954014				4154954014		4154954014
fax		None		None				9165571675				9165571675		9165571675		4154950541		3038371131		3038371131				3038371131				3038371131														None		None				9165571675				9165571675		9165571675		4154950541		3038371131		3038371131				3038371131				3038371131														None		None				9165571675				9165571675		9165571675		4154950541		3038371131		3038371131				3038371131				3038371131														None		None				9165571675				9165571675		9165571675		4154950541		3038371131		3038371131				3038371131				3038371131														None		None				9165571675				9165571675		9165571675		4154950541		3038371131		3038371131				3038371131				3038371131														None		None				9165571675				9165571675		9165571675		4154950541		3038371131		3038371131				3038371131				3038371131														None		None				9165571675				9165571675		9165571675		4154950541		3038371131		3038371131				3038371131				3038371131														None		None				9165571675				9165571675		9165571675		4154950541		3038371131		3038371131				3038371131				3038371131														None		None				9165571675				9165571675		9165571675		4154950541		3038371131		3038371131				3038371131				3038371131														None		None				9165571675				9165571675		9165571675		4154950541		3038371131		3038371131				3038371131				3038371131														None		None				9165571675				9165571675		9165571675		4154950541		3038371131		3038371131				3038371131				3038371131														None		None				9165571675				9165571675		9165571675		4154950541		3038371131		3038371131				3038371131				3038371131
email		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		None		[email protected]		None		[email protected]		None		None		None		[email protected]		[email protected]		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		None		[email protected]		None		[email protected]		None		None		None		[email protected]		[email protected]		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		None		[email protected]		None		[email protected]		None		None		None		[email protected]		[email protected]		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		None		[email protected]		None		[email protected]		None		None		None		[email protected]		[email protected]		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		None		[email protected]		None		[email protected]		None		None		None		[email protected]		[email protected]		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		None		[email protected]		None		[email protected]		None		None		None		[email protected]		[email protected]		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		None		[email protected]		None		[email protected]		None		None		None		[email protected]		[email protected]		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		None		[email protected]		None		[email protected]		None		None		None		[email protected]		[email protected]		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		None		[email protected]		None		[email protected]		None		None		None		[email protected]		[email protected]		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		None		[email protected]		None		[email protected]		None		None		None		[email protected]		[email protected]		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		None		[email protected]		None		[email protected]		None		None		None		[email protected]		[email protected]		None		None		None		None		None		None		None		[email protected]		[email protected]		[email protected]		[email protected]		None		[email protected]		None		[email protected]		None		None		None		[email protected]		[email protected]		None

Table: filers

filer_id		1147167

Table: lobbying_chg_log

filer_id		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167
change_no		1		2		0		4		3		5		6		7		8		9
session_id		2001		2003		2005		2007		2007		2007		2007		2013		2017		2017
log_dt		2001-05-22 00:00:00		2003-05-14 00:00:00		2006-02-07 00:00:00		2007-03-26 00:00:00		2007-03-26 00:00:00		2007-10-03 00:00:00		2008-02-20 00:00:00		2013-01-14 00:00:00		2017-07-06 00:00:00		2017-07-06 00:00:00
filer_type		2		2		2		2		2		1		2		2		2		2
correction_flg		Y		Y		None		Y		Y		Y		Y		Y		None		None
action		ADDED		TERMINATED		ADDED		ADDED		DELETED		DELETED		ADDED		ADDED		SET ACTIVE		SET ACTIVE
attribute_changed		LOBBYIST		None		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST		LOBBYIST				LOBBYIST
ethics_dt		None		None		None		None		None		None		None		None		None		None
interests		None		None		None		None		None		None		None		None		None		None
filer_full_name		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND, THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE		TRUST FOR PUBLIC LAND; THE
filer_city		None		Sacramento		None		Sacramento		None		Sacramento		Sacramento		SAN FRANCISCO		None		None
filer_st		None		CA		None		CA		None		CA		CA		CA		None		None
filer_zip		None		95814		None		95814		None		95814		95814		94105		None		None
filer_phone		None		9165571673		None		9165571673		None		9165571673		9165571673		9165571673		None		None
entity_type		4		4		4		4		4		4		4		4		2		4
entity_name		TERESA VILLEGAS		VILLEGAS, TERESA		MILLS, CHUCK		HALL, DENNIS		MILLS, CHUCK		HALL, DENNIS		MASTRODONATO, RICHARD		MASTRODONATO, RICHARD A.		None		MASTRODONATO, RICHARD A.
entity_city		None		None		None		None		None		None		None		None		None		None
entity_st		None		None		None		None		None		None		None		None		None		None
entity_zip		None		None		None		None		None		None		None		None		None		None
entity_phone		None		None		None		None		None		None		None		None		None		None
entity_id		1235254		None		1283028		None		1283028		None		None		None		0		1303972
responsible_officer		None		None		None		None		None		None		None		None		None		None
effect_dt		2001-05-01 00:00:00		2003-04-30 00:00:00		2006-02-01 00:00:00		2007-03-01 00:00:00		2007-03-05 00:00:00		2007-09-26 00:00:00		2008-02-20 00:00:00		2013-01-29 00:00:00		2017-01-01 00:00:00		2017-01-01 00:00:00

Table: received_filings

filer_id		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167		1147167
filing_file_name		746984_0.cal		773873_0.cal		798456_0.cal		813005_0.cal		813005_1.cal		839421_0.cal		839421_1.cal		855519_0.cal		881769_0.cal		910605_0.cal		931921_0.cal		948110_0.cal		969291_0.cal		988678_0.cal		988678_1.cal		1030130_0.cal		1012505_0.cal		1055626_0.cal		1081408_0.cal		1081408_1.cal		1103705_0.cal		1117165_0.cal		1117180_0.cal		1130868_0.cal		1148997_0.cal		1166738_0.cal		1191632_0.cal		1208744_0.cal		414262.cal		1461097_0.cal		1451844_0.cal		1235541_0.cal		1261762_0.cal		1280999_0.cal		1435633_0.cal		1419717_0.cal		1261762_1.cal		359611.cal		359673.cal		359708.cal		504246.cal		465573.cal
received_date		2001-05-01 00:00:00		2001-08-03 00:00:00		2001-11-20 00:00:00		2002-01-30 00:00:00		2002-02-27 00:00:00		2002-04-30 00:00:00		2002-06-19 00:00:00		2002-07-31 00:00:00		2002-10-29 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		2004-01-29 00:00:00		2004-02-11 00:00:00		2004-07-30 00:00:00		2004-04-29 00:00:00		2004-10-27 00:00:00		2005-01-31 00:00:00		2005-02-08 00:00:00		2005-04-28 00:00:00		2005-07-29 00:00:00		2005-07-29 00:00:00		2005-10-26 00:00:00		2006-01-31 00:00:00		2006-04-28 00:00:00		2006-07-31 00:00:00		2006-10-18 00:00:00		2009-01-27 00:00:00		2010-01-27 00:00:00		2009-10-30 00:00:00		2007-01-30 00:00:00		2007-04-30 00:00:00		2007-07-26 00:00:00		2009-07-29 00:00:00		2009-04-28 00:00:00		2007-09-20 00:00:00		2013-01-03 00:00:00		2013-01-03 00:00:00		2013-01-03 00:00:00		2019-04-30 00:00:00		2019-04-29 00:00:00
filing_directory		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/usr/users/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp
filing_id		746984		773873		798456		813005		813005		839421		839421		855519		881769		910605		931921		948110		969291		988678		988678		1030130		1012505		1055626		1081408		1081408		1103705		1117165		1117180		1130868		1148997		1166738		1191632		1208744		None		1461097		1451844		1235541		1261762		1280999		1435633		1419717		1261762		None		None		None		None		None
form_id		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F635		F615		F635		F635		F635		F635		F635		F635		None		F635		F635		F635		F635		F635		F635		F635		F635		None		None		None		None		None
receive_comment		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 passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation		Filing did not pass validation