Home

Filer ID: 1146676

Table: filer_address

filer_id		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676
adrid		1111301		2124090		2124094		2124091		2220784		2437316		2416785		2279315		2279316		2506165		2506166		2343149		2467504		2385839
effect_dt		1999-08-30 00:00:00		2006-01-25 00:00:00		2007-01-01 00:00:00		2006-01-25 00:00:00		2011-08-01 00:00:00		2017-07-07 00:00:00		2017-01-01 00:00:00		2013-01-01 00:00:00		2013-01-01 00:00:00		2021-01-01 00:00:00		2021-01-01 00:00:00		2015-01-01 00:00:00		2019-01-01 00:00:00		2016-01-26 00:00:00
add_type		7051		7051		7051		7082		7051		7051		7051		7051		7082		7051		7082		7051		7051		7051
session_id		1999		2005		2007		2005		2011		2017		2017		2013		2013		2021		2021		2015		2019		2015

Table: filer_filings

filer_id		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676
filing_id		479218		615506		636043		650088		630217		1149672		1167694		1190622		1215154		1236822		1284246		1268901		1268949		1268960		1261635		1790017		1776765		1981043		1964165		1844381		1793263		1793263		1776765		1946763		1911137		1615126		1636327		1657710		1620524		1673989		1813862		1934236		1920582		1719430		1704947		1871281		1737620		1738178		1763417		1981043		1997129		2329213		2526779		2440875		2341930		2017955		2010575		2035818		2061145		2093014		2112827		2122114		2152757		2134061		2170445		2167918		2236219		2266989		2395447		2418222		2551126		2308242		2308242		2471624		2377983		2354605		2193104		2483891		2205715
period_id		159		160		None		162		161		185		185		186		187		188		190		None		None		None		189		None		214		222		221		217		215		215		214		None		219		None		208		209		207		210		216		220		220		212		211		218		212		None		213		222		223		236		243		240		236		None		224		225		226		227		228		228		229		None		230		None		233		234		238		239		244		235		235		241		237		None		231		242		232
form_id		F635		F635		F999		F635		F635		F602		F635		F635		F635		F635		F635		F602		F602		F602		F635		F605		F635		F635		F635		F635		F635		F635		F635		F602		F635		F602		F635		F635		F635		F635		F635		F635		F602		F602		F635		F635		F635		F602		F635		F635		F635		F602		F635		F635		F635		F605		F635		F635		F635		F635		F602		F635		F635		F602		F635		F605		F635		F635		F635		F635		F635		F635		F635		F635		F635		F602		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		1		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		0
filing_date		1999-11-01 00:00:00		2000-01-31 00:00:00		2000-04-24 00:00:00		2000-07-28 00:00:00		2000-05-01 00:00:00		2006-02-01 00:00:00		2006-05-01 00:00:00		2006-07-31 00:00:00		2006-10-30 00:00:00		2007-01-31 00:00:00		2007-07-31 00:00:00		2006-02-01 00:00:00		2006-02-15 00:00:00		2007-01-02 00:00:00		2007-04-30 00:00:00		2013-07-26 00:00:00		2013-07-19 00:00:00		2015-07-30 00:00:00		2015-04-29 00:00:00		2014-04-30 00:00:00		2013-10-10 00:00:00		2013-10-09 00:00:00		2013-10-07 00:00:00		2014-12-23 00:00:00		2014-10-31 00:00:00		2011-08-16 00:00:00		2012-01-31 00:00:00		2012-04-30 00:00:00		2011-10-27 00:00:00		2012-07-24 00:00:00		2014-01-27 00:00:00		2015-01-30 00:00:00		2014-12-23 00:00:00		2012-12-21 00:00:00		2012-10-26 00:00:00		2014-07-31 00:00:00		2013-01-30 00:00:00		2012-12-21 00:00:00		2013-04-29 00:00:00		2015-10-20 00:00:00		2015-10-30 00:00:00		2018-12-21 00:00:00		2020-10-29 00:00:00		2020-01-30 00:00:00		2019-01-28 00:00:00		2016-02-09 00:00:00		2016-01-29 00:00:00		2016-04-29 00:00:00		2016-07-29 00:00:00		2016-10-21 00:00:00		2016-12-21 00:00:00		2017-01-23 00:00:00		2017-04-24 00:00:00		2016-12-20 00:00:00		2017-07-24 00:00:00		2017-07-13 00:00:00		2018-04-25 00:00:00		2018-07-20 00:00:00		2019-07-29 00:00:00		2019-10-30 00:00:00		2021-01-29 00:00:00		2018-10-18 00:00:00		2019-01-24 00:00:00		2020-04-30 00:00:00		2019-04-26 00:00:00		2018-12-21 00:00:00		2017-10-31 00:00:00		2020-07-30 00:00:00		2018-01-25 00:00:00
stmnt_type		10001		10005		10005		10005		10005		10001		10001		10001		10001		10001		10001		10005		10005		10005		10001		10006		10001		10001		10001		10001		10002		10001		10002		10005		10001		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10002		10001		10001		10001		10001		10001		10005		10001		10001		10001		10001		10001		10001		10001		10005		10001		10005		10001		10001		10001		10001		10001		10001		10002		10001		10001		10001		10001		10001		10001
stmnt_status		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		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
session_id		1999		1999		1999		1999		1999		2005		2005		2005		2005		2005		2007		2005		2005		2007		2007		2013		2013		2015		2015		2013		2013		2013		2013		2015		2013		2011		2011		2011		2011		2011		2013		2013		2015		2013		2011		2013		2011		2013		2013		2015		2015		2019		2019		2019		2017		2015		2015		2015		2015		2015		2017		2015		2017		2017		2017		2017		2017		2017		2019		2019		2019		2017		2017		2019		2019		2019		2017		2019		2017
user_id		*		*		TTHAM		YBONILLA		KCHAN		YRODRIGU		LTHIBAUL		LTHIBAUL		LTHIBAUL		LTHIBAUL		YRODRIGU		SARRIAGA		GPEREZ		SARRIAGA		LTHIBAUL		PBANFORD		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		SARRIAGA		ASAETERN		YRODRIGU		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		ASAETERN		MPACHECO		SARRIAGA		GKURIMOT		AGLADNEY		AGLADNEY		AGLADNEY		GKURIMOT		ASAETERN		AGLADNEY		AGLADNEY		PBANFORD		GTAYLOR		GTAYLOR		AGLADNEY		GPEREZ		AGLADNEY		AGLADNEY		AGLADNEY		AGLADNEY		GPEREZ		AGLADNEY		AGLADNEY		GPEREZ		AGLADNEY		GPEREZ		AGLADNEY		AGLADNEY		VUKSTINA		VUKSTINA		JMAVES		AGLADNEY		AGLADNEY		GTAYLOR		VUKSTINA		PBANFORD		AGLADNEY		GTAYLOR		AGLADNEY
special_audit		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
fine_audit		11001		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11001		11003		11001		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		11003		11001		11001		11003		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001
rpt_start		1999-07-01 00:00:00		1999-10-01 00:00:00		None		2000-04-01 00:00:00		2000-01-01 00:00:00		2006-02-01 00:00:00		2006-01-01 00:00:00		2006-04-01 00:00:00		2006-07-01 00:00:00		2006-10-01 00:00:00		2007-04-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2007-01-01 00:00:00		1900-01-01 00:00:00		2013-04-01 00:00:00		2015-04-01 00:00:00		2015-01-01 00:00:00		2014-01-01 00:00:00		2013-07-01 00:00:00		2013-07-01 00:00:00		2013-04-01 00:00:00		1900-01-01 00:00:00		2014-07-01 00:00:00		1900-01-01 00:00:00		2011-10-01 00:00:00		2012-01-01 00:00:00		2011-07-01 00:00:00		2012-04-01 00:00:00		2013-10-01 00:00:00		2014-10-01 00:00:00		2014-12-23 00:00:00		2012-12-21 00:00:00		2012-07-01 00:00:00		2014-04-01 00:00:00		2012-10-01 00:00:00		1900-01-01 00:00:00		2013-01-01 00:00:00		2015-04-01 00:00:00		2015-07-01 00:00:00		2018-12-21 00:00:00		2020-07-01 00:00:00		2019-10-01 00:00:00		2018-10-01 00:00:00		1900-01-01 00:00:00		2015-10-01 00:00:00		2016-01-01 00:00:00		2016-04-01 00:00:00		2016-07-01 00:00:00		2016-12-21 00:00:00		2016-10-01 00:00:00		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		2018-04-01 00:00:00		2019-04-01 00:00:00		2019-07-01 00:00:00		2020-10-01 00:00:00		2018-07-01 00:00:00		2018-07-01 00:00:00		2020-01-01 00:00:00		2019-01-01 00:00:00		1900-01-01 00:00:00		2017-07-01 00:00:00		2020-04-01 00:00:00		2017-10-01 00:00:00
rpt_end		1999-09-30 00:00:00		1999-12-31 00:00:00		None		2000-06-30 00:00:00		2000-03-31 00:00:00		2006-02-01 00:00:00		2006-03-31 00:00:00		2006-06-30 00:00:00		2006-09-30 00:00:00		2006-12-31 00:00:00		2007-06-30 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		1900-01-01 00:00:00		2007-03-31 00:00:00		1900-01-01 00:00:00		2013-06-30 00:00:00		2015-06-30 00:00:00		2015-03-31 00:00:00		2014-03-31 00:00:00		2013-09-30 00:00:00		2013-09-30 00:00:00		2013-06-30 00:00:00		1900-01-01 00:00:00		2014-09-30 00:00:00		1900-01-01 00:00:00		2011-12-31 00:00:00		2012-03-31 00:00:00		2011-09-30 00:00:00		2012-06-30 00:00:00		2013-12-31 00:00:00		2014-12-31 00:00:00		2014-12-23 00:00:00		2012-12-21 00:00:00		2012-09-30 00:00:00		2014-06-30 00:00:00		2012-12-31 00:00:00		1900-01-01 00:00:00		2013-03-31 00:00:00		2015-06-30 00:00:00		2015-09-30 00:00:00		2018-12-21 00:00:00		2020-09-30 00:00:00		2019-12-31 00:00:00		2018-12-31 00:00:00		1900-01-01 00:00:00		2015-12-31 00:00:00		2016-03-31 00:00:00		2016-06-30 00:00:00		2016-09-30 00:00:00		2016-12-21 00:00:00		2016-12-31 00:00:00		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		2018-06-30 00:00:00		2019-06-30 00:00:00		2019-09-30 00:00:00		2020-12-31 00:00:00		2018-09-30 00:00:00		2018-09-30 00:00:00		2020-03-31 00:00:00		2019-03-31 00:00:00		1900-01-01 00:00:00		2017-09-30 00:00:00		2020-06-30 00:00:00		2017-12-31 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
filing_type		None		None		None		None		None		22001		22001		22001		22001		22001		22001		None		None		None		22001		None		22006		22006		22006		22006		22006		22006		22006		None		22006		None		22006		22006		22006		22006		22006		22006		22001		22001		22006		22006		22006		None		22006		22006		22006		22001		22006		22006		22006		None		22006		22006		22006		22006		22001		22006		22006		None		22006		None		22006		22006		22006		22006		22006		22006		22006		22006		22006		None		22006		22006		22006

Table: filer_interests

filer_id		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676
session_id		1999		2017		2011		2007		2005		2013		2019		2021		2015
interest_cd		40304		40304		40304		40304		40304		40304		40304		40304		40304
effect_date		1999-08-30 00:00:00		2017-01-01 00:00:00		2011-08-01 00:00:00		2007-01-01 00:00:00		2006-01-25 00:00:00		2013-01-01 00:00:00		2019-01-01 00:00:00		2021-01-01 00:00:00		2015-01-01 00:00:00

Table: filer_to_filer_type

filer_id		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676
filer_type		1		1		1		1		1		1		1		1		1		1
active		T		Y		Y		Y		T		Y		Y		Y		Y		N
race		0		None		0		0		0		0		None		None		None		None
session_id		1999		2013		2005		2007		2007		2011		2017		2019		2015		2021
category		0		None		0		0		0		0		None		None		None		None
category_type		0		None		0		0		0		0		None		None		None		None
sub_category		0		None		0		0		0		0		None		None		None		None
effect_dt		1999-08-30 00:00:00		2013-01-01 00:00:00		2006-01-25 00:00:00		2007-01-01 00:00:00		2007-04-17 00:00:00		2011-08-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
sub_category_type		0		None		0		0		0		0		None		None		None		None
election_type		0		None		0		0		0		0		None		None		None		None
sub_category_a		None		None		None		None		None		None		None		None		None		None
nyq_dt		2006-02-01 00:00:00		None		2006-02-01 00:00:00		2006-02-01 00:00:00		2006-02-01 00:00:00		2006-02-01 00:00:00		None		None		None		None
party_cd		None		None		None		None		None		None		None		None		None		None
county_cd		None		None		None		None		None		None		None		None		None		None
district_cd		None		None		None		None		None		None		None		None		None		None

Table: filer_xref

filer_id		1146676
xref_id		C28236
effect_dt		1999-12-08 00:00:00
migration_source		MASTER

Table: filername

xref_filer_id		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236		C28236
filer_id		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676		1146676
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
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
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
naml		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEOVERA HOLDINGS, INC.		GEO VERA HOLDINGS, INC.		GEO VERA HOLDINGS, INC.		GEO VERA HOLDINGS, INC.		GEO VERA HOLDINGS, INC.		GEO VERA HOLDINGS, INC.		GEO VERA HOLDINGS, INC.		GEO VERA HOLDINGS, INC.		GEO VERA HOLDINGS, INC.		GEO VERA HOLDINGS, INC.		GEO VERA HOLDINGS, INC.		GEO VERA HOLDINGS, INC.		GEO VERA HOLDINGS, INC.		GEO VERA HOLDINGS, INC.		GEO VERA HOLDINGS, INC.		GEO VERA HOLDINGS, INC.		GEO VERA HOLDINGS, INC.		GEO VERA HOLDINGS, INC.		GEO VERA HOLDINGS, INC.		GEO VERA HOLDINGS, INC.		GEO VERA HOLDINGS, INC.		GEO VERA HOLDINGS, INC.		GEO VERA HOLDINGS, INC.		GEO VERA HOLDINGS, INC.		GEO VERA HOLDINGS, INC.		GEO VERA HOLDINGS, INC.		GEO VERA HOLDINGS, INC.		GEO VERA HOLDINGS, INC.		GEO VERA HOLDINGS, INC.		GEO VERA HOLDINGS INC.		GEO VERA HOLDINGS INC.		GEO VERA HOLDINGS INC.		GEO VERA HOLDINGS INC.		GEO VERA HOLDINGS INC.		GEO VERA HOLDINGS INC.		GEO VERA HOLDINGS INC.		GEO VERA HOLDINGS INC.		GEO VERA HOLDINGS INC.		GEO VERA HOLDINGS INC.		GEO VERA HOLDINGS INC.		GEO VERA HOLDINGS INC.		GEO VERA HOLDINGS INC.		GEO VERA HOLDINGS INC.		GEO VERA		GEO VERA		GEO VERA		GEO VERA		GEO VERA		GEO VERA		GEO VERA		GEO VERA		GEO VERA		GEO VERA		GEO VERA		GEO VERA		GEO VERA		GEO VERA
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
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
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
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
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
city		CONCORD		FAIRFIELD		ST. PAUL		FAIRFIELD		FAIRFIELD		FAIRFIELD		ST. PAUL		FAIRFIELD		FAIRFIELD		FAIRFIELD		FAIRFIELD		FAIRFIELD		FAIRFIELD		ST. PAUL		CONCORD		FAIRFIELD		ST. PAUL		FAIRFIELD		FAIRFIELD		FAIRFIELD		ST. PAUL		FAIRFIELD		FAIRFIELD		FAIRFIELD		FAIRFIELD		FAIRFIELD		FAIRFIELD		ST. PAUL		CONCORD		FAIRFIELD		ST. PAUL		FAIRFIELD		FAIRFIELD		FAIRFIELD		ST. PAUL		FAIRFIELD		FAIRFIELD		FAIRFIELD		FAIRFIELD		FAIRFIELD		FAIRFIELD		ST. PAUL		CONCORD		FAIRFIELD		ST. PAUL		FAIRFIELD		FAIRFIELD		FAIRFIELD		ST. PAUL		FAIRFIELD		FAIRFIELD		FAIRFIELD		FAIRFIELD		FAIRFIELD		FAIRFIELD		ST. PAUL		CONCORD		FAIRFIELD		ST. PAUL		FAIRFIELD		FAIRFIELD		FAIRFIELD		ST. PAUL		FAIRFIELD		FAIRFIELD		FAIRFIELD		FAIRFIELD		FAIRFIELD		FAIRFIELD		ST. PAUL		CONCORD		FAIRFIELD		ST. PAUL		FAIRFIELD		FAIRFIELD		FAIRFIELD		ST. PAUL		FAIRFIELD		FAIRFIELD		FAIRFIELD		FAIRFIELD		FAIRFIELD		FAIRFIELD		ST. PAUL		CONCORD		FAIRFIELD		ST. PAUL		FAIRFIELD		FAIRFIELD		FAIRFIELD		ST. PAUL		FAIRFIELD		FAIRFIELD		FAIRFIELD		FAIRFIELD		FAIRFIELD		FAIRFIELD		ST. PAUL		CONCORD		FAIRFIELD		ST. PAUL		FAIRFIELD		FAIRFIELD		FAIRFIELD		ST. PAUL		FAIRFIELD		FAIRFIELD		FAIRFIELD		FAIRFIELD		FAIRFIELD		FAIRFIELD		ST. PAUL		CONCORD		FAIRFIELD		ST. PAUL		FAIRFIELD		FAIRFIELD		FAIRFIELD		ST. PAUL		FAIRFIELD		FAIRFIELD		FAIRFIELD		FAIRFIELD		FAIRFIELD		FAIRFIELD		ST. PAUL
st		CA		CA		MN		CA		CA		CA		MN		CA		CA		CA		CA		CA		CA		MN		CA		CA		MN		CA		CA		CA		MN		CA		CA		CA		CA		CA		CA		MN		CA		CA		MN		CA		CA		CA		MN		CA		CA		CA		CA		CA		CA		MN		CA		CA		MN		CA		CA		CA		MN		CA		CA		CA		CA		CA		CA		MN		CA		CA		MN		CA		CA		CA		MN		CA		CA		CA		CA		CA		CA		MN		CA		CA		MN		CA		CA		CA		MN		CA		CA		CA		CA		CA		CA		MN		CA		CA		MN		CA		CA		CA		MN		CA		CA		CA		CA		CA		CA		MN		CA		CA		MN		CA		CA		CA		MN		CA		CA		CA		CA		CA		CA		MN		CA		CA		MN		CA		CA		CA		MN		CA		CA		CA		CA		CA		CA		MN
zip4		945202560		94534		55102		94534		94534		94534		55102		94534		94534		94534		94534		94534		94534		55102		945202560		94534		55102		94534		94534		94534		55102		94534		94534		94534		94534		94534		94534		55102		945202560		94534		55102		94534		94534		94534		55102		94534		94534		94534		94534		94534		94534		55102		945202560		94534		55102		94534		94534		94534		55102		94534		94534		94534		94534		94534		94534		55102		945202560		94534		55102		94534		94534		94534		55102		94534		94534		94534		94534		94534		94534		55102		945202560		94534		55102		94534		94534		94534		55102		94534		94534		94534		94534		94534		94534		55102		945202560		94534		55102		94534		94534		94534		55102		94534		94534		94534		94534		94534		94534		55102		945202560		94534		55102		94534		94534		94534		55102		94534		94534		94534		94534		94534		94534		55102		945202560		94534		55102		94534		94534		94534		55102		94534		94534		94534		94534		94534		94534		55102
phon		9256777101		6512942309				7078633754		7078633604		7078633604				7078633604		7078633681		7078633804		7078633681		7078633681		7078633681				9256777101		6512942309				7078633754		7078633604		7078633604				7078633604		7078633681		7078633804		7078633681		7078633681		7078633681				9256777101		6512942309				7078633754		7078633604		7078633604				7078633604		7078633681		7078633804		7078633681		7078633681		7078633681				9256777101		6512942309				7078633754		7078633604		7078633604				7078633604		7078633681		7078633804		7078633681		7078633681		7078633681				9256777101		6512942309				7078633754		7078633604		7078633604				7078633604		7078633681		7078633804		7078633681		7078633681		7078633681				9256777101		6512942309				7078633754		7078633604		7078633604				7078633604		7078633681		7078633804		7078633681		7078633681		7078633681				9256777101		6512942309				7078633754		7078633604		7078633604				7078633604		7078633681		7078633804		7078633681		7078633681		7078633681				9256777101		6512942309				7078633754		7078633604		7078633604				7078633604		7078633681		7078633804		7078633681		7078633681		7078633681				9256777101		6512942309				7078633754		7078633604		7078633604				7078633604		7078633681		7078633804		7078633681		7078633681		7078633681
fax		None		None		None		7077364021						None														None		None		None		None		7077364021						None														None		None		None		None		7077364021						None														None		None		None		None		7077364021						None														None		None		None		None		7077364021						None														None		None		None		None		7077364021						None														None		None		None		None		7077364021						None														None		None		None		None		7077364021						None														None		None		None		None		7077364021						None														None
email		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None

Table: filers

filer_id		1146676

Table: lobbying_chg_log

filer_id		1146676		1146676
change_no		1		0
session_id		2005		2011
log_dt		2006-02-01 00:00:00		2011-08-16 00:00:00
filer_type		1		1
correction_flg		None		Y
action		CHANGED		ADDED
attribute_changed		ADDRESS AND PHONE		FIRM
ethics_dt		None		None
interests		None		None
filer_full_name		GEO VERA		GEO VERA HOLDINGS, INC.
filer_city		FAIRFIELD		None
filer_st		CA		None
filer_zip		94534		None
filer_phone		6512942309		None
entity_type		1		3
entity_name		None		MC HUGH & ASSOCIATES
entity_city		None		None
entity_st		None		None
entity_zip		None		None
entity_phone		None		None
entity_id		0		1231516
responsible_officer		None		None
effect_dt		2006-01-25 00:00:00		2011-08-01 00:00:00

Table: received_filings

filer_id		1146676		1146676		1146676		1146676		1146676		1146676		1146676
filing_file_name		1215154_0.cal		1261635_0.cal		1284246_0.cal		1719430_0.cal		2112827_0.cal		1920582_0.cal		2329213_0.cal
received_date		2006-10-30 00:00:00		2007-04-30 00:00:00		2007-07-31 00:00:00		2012-12-21 00:00:00		2016-12-21 00:00:00		2014-12-23 00:00:00		2018-12-21 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
filing_id		1215154		1261635		1284246		1719430		2112827		1920582		2329213
form_id		F635		F635		F635		F602		F602		F602		F602
receive_comment		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted