Home

Filer ID: 1070473

Table: filer_address

filer_id		1070473		1070473		1070473		1070473		1070473
adrid		1081761		1081762		2074699		2478972		2480507
effect_dt		1997-05-14 00:00:00		1997-05-14 00:00:00		1997-05-05 00:00:00		2019-02-21 00:00:00		2019-05-13 00:00:00
add_type		7051		7051		7082		7051		7051
session_id		1997		1997		1997		2019		2019

Table: filer_filings

filer_id		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473
filing_id		680196		401684		401685		401686		401687		401689		401690		401691		401692		401693		401694		401696		401697		401698		401699		444308		401688		401695		592089		590961		591950		582552		649272		649283		649288		649307		649309		644213		644228		644229		644230		644232		644389		669563		669565		677740		647363		672242		716880		716887		716897		716905		716906		716908		716832		716843		722057		716170		721905		721909		721911		721913		721915		721917		721921		721923		786313		770827		773932		785784		785784		805865		805297		793222		823002		825535		823002		825535		857803		856699		823002		825535		871719		877937		872228		883736		915677		912701		877937		883736		945244		963271		963511		951882		962205		964847		983089		979369		999300		1028787		996954		1030591		1046380		1043655		1044863		1054007		1043655		1075828		1076497		1043655		1102561		1111946		1114883		1144130		1142916		1187228		1185660		1231269		1237162		1283586		1281391		1231269		1304060		1283277		1291597		1304633		1318907		1292795		1319830		1333256		1333257		1333875		1348619		1336131		1338432		1348241		1334596		1358684		1358685		1358687		1358688		1363448		1364809		1369914		1373186		1379483		1379485		1379486		1379455		1369914		1373186		1400712		1441107		1397984		1437825		1462343		1478786		1467633		2320450		2324505		2520815		2387983		2521316		2324505		2509790		2311892		2320450		2320450		2506471		2365599		2508079		2311875		2510542		2384023		2311875		2311890		2511491		1043655		2311885		2311904		2311887		2509790
period_id		None		150		149		151		153		153		153		154		154		155		153		156		153		157		157		149		153		155		None		None		161		None		None		None		None		None		None		161		161		161		161		161		161		163		161		164		None		None		161		161		161		161		161		161		161		161		None		164		None		None		None		None		None		None		None		None		None		165		None		167		167		None		168		168		169		None		169		None		None		169		169		None		171		172		None		None		None		172		172		None		173		175		None		None		176		None		None		176		None		177		177		None		None		179		179		None		179		180		None		182		None		181		None		None		183		None		185		187		None		None		None		187		None		189		191		191		193		None		None		194		193		None		None		194		194		194		None		195		195		195		195		195		None		196		None		None		None		None		None		196		None		None		None		196		197		199		None		None		236		237		243		None		244		236		244		235		237		236		243		None		244		236		244		None		236		236		244		244		236		236		236		244
form_id		F460		F410		F420		F420		F420		F405		F405		F420		F465		F420		F465		F420		F465		F420		F405		F405		F465		F405		F460		F999		F460		F420		F465		F465		F465		F465		F465		F465		F465		F465		F465		F465		F460		F460		F465		F460		F460		F460		F465		F465		F465		F465		F465		F465		F465		F465		F460		F460		F465		F465		F465		F465		F465		F465		F465		F465		F460		F460		F460		F460		F460		F460		F460		F497		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F460		F497		F460		F460		F460		F460		F460		F460		F460		F460		F410		F460		F410		F410		F460		F460		F410		F410		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F460		F497		F460		F497		F497		F460		F460		F496		F496		F496		F496		F460		F460		F460		F460		F465		F465		F465		F465		F460		F460		F460		F460		F460		F460		F460		F410		F460		F496		F496		F460		F410		F497		F496		F497		F496		F496		F496		F497		F410		F497		F496		F497		F410		F496		F496		F497		F410		F496		F496		F496		F497
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		1		1		0		0		0		2		2		0		0		0		1		0		0		1		0		0		0		0		0		0		0		0		0		0		0		0		0		0		1		0		0		0		0		0		2		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		0		0		0		0		0		1		1		0		0		0		0		0		0		0		0		1		0		0		0		0		1		0		2		1		0		0		0		1		0		0		0		0		0		3		0		0		0		0
filing_date		2000-10-27 00:00:00		1997-05-14 00:00:00		1997-07-31 00:00:00		1998-02-02 00:00:00		1998-05-21 00:00:00		1998-06-02 00:00:00		1998-07-31 00:00:00		1998-07-31 00:00:00		1998-07-31 00:00:00		1998-10-23 00:00:00		1998-10-23 00:00:00		1999-02-01 00:00:00		1999-02-01 00:00:00		1999-07-27 00:00:00		1999-09-23 00:00:00		1997-11-25 00:00:00		1998-05-22 00:00:00		1999-01-22 00:00:00		2000-02-24 00:00:00		2000-01-25 00:00:00		2000-02-24 00:00:00		2000-01-10 00:00:00		2000-07-31 00:00:00		2000-07-31 00:00:00		2000-07-31 00:00:00		2000-07-31 00:00:00		2000-07-31 00:00:00		2000-07-30 00:00:00		2000-07-30 00:00:00		2000-07-30 00:00:00		2000-07-30 00:00:00		2000-07-30 00:00:00		2000-07-31 00:00:00		2000-10-05 00:00:00		2000-10-05 00:00:00		2000-10-26 00:00:00		2000-07-31 00:00:00		2000-10-05 00:00:00		2001-01-30 00:00:00		2001-01-30 00:00:00		2001-01-30 00:00:00		2001-01-30 00:00:00		2001-01-30 00:00:00		2001-01-30 00:00:00		2001-01-30 00:00:00		2001-01-30 00:00:00		2001-01-29 00:00:00		2001-01-29 00:00:00		2001-01-29 00:00:00		2001-01-29 00:00:00		2001-01-29 00:00:00		2001-01-29 00:00:00		2001-01-29 00:00:00		2001-01-29 00:00:00		2001-01-29 00:00:00		2001-01-29 00:00:00		2001-10-10 00:00:00		2001-07-27 00:00:00		2001-07-27 00:00:00		2001-10-10 00:00:00		2002-01-29 00:00:00		2002-01-10 00:00:00		2002-01-10 00:00:00		2001-11-02 00:00:00		2002-02-21 00:00:00		2002-03-02 00:00:00		2002-03-02 00:00:00		2002-02-21 00:00:00		2002-07-31 00:00:00		2002-07-31 00:00:00		2002-07-12 00:00:00		2002-07-12 00:00:00		2002-10-07 00:00:00		2002-10-24 00:00:00		2002-10-07 00:00:00		2002-12-16 00:00:00		2003-01-31 00:00:00		2003-01-31 00:00:00		2002-12-16 00:00:00		2002-10-24 00:00:00		2003-07-28 00:00:00		2003-10-10 00:00:00		2003-10-06 00:00:00		2003-07-28 00:00:00		2003-10-06 00:00:00		2003-10-10 00:00:00		2004-01-09 00:00:00		2004-01-09 00:00:00		2004-02-19 00:00:00		2004-07-29 00:00:00		2004-02-19 00:00:00		2004-07-29 00:00:00		2004-10-05 00:00:00		2004-09-30 00:00:00		2004-10-05 00:00:00		2004-09-30 00:00:00		2004-09-30 00:00:00		2005-01-26 00:00:00		2005-01-26 00:00:00		2005-04-12 00:00:00		2005-04-12 00:00:00		2005-07-14 00:00:00		2005-07-19 00:00:00		2006-01-23 00:00:00		2006-01-20 00:00:00		2006-07-24 00:00:00		2006-07-20 00:00:00		2007-01-24 00:00:00		2007-01-26 00:00:00		2007-07-30 00:00:00		2007-07-19 00:00:00		2007-07-17 00:00:00		2008-01-16 00:00:00		2007-07-30 00:00:00		2007-09-25 00:00:00		2008-01-18 00:00:00		2008-03-19 00:00:00		2007-09-27 00:00:00		2008-03-20 00:00:00		2008-05-19 00:00:00		2008-05-19 00:00:00		2008-05-19 00:00:00		2008-07-29 00:00:00		2008-05-23 00:00:00		2008-05-29 00:00:00		2008-07-29 00:00:00		2008-05-21 00:00:00		2008-09-05 00:00:00		2008-09-05 00:00:00		2008-09-05 00:00:00		2008-09-05 00:00:00		2008-10-06 00:00:00		2008-10-06 00:00:00		2008-10-23 00:00:00		2008-10-23 00:00:00		2008-10-23 00:00:00		2008-10-23 00:00:00		2008-10-23 00:00:00		2008-10-23 00:00:00		2009-02-02 00:00:00		2009-02-03 00:00:00		2009-02-02 00:00:00		2009-07-31 00:00:00		2009-02-02 00:00:00		2009-07-31 00:00:00		2010-01-28 00:00:00		2010-04-05 00:00:00		2010-02-01 00:00:00		2018-10-31 00:00:00		2019-01-31 00:00:00		2020-10-22 00:00:00		2019-06-24 00:00:00		2020-10-22 00:00:00		2018-11-06 00:00:00		2020-10-05 00:00:00		2018-10-24 00:00:00		2019-01-31 00:00:00		2018-11-01 00:00:00		2020-09-28 00:00:00		2019-02-21 00:00:00		2020-10-01 00:00:00		2018-11-06 00:00:00		2020-10-06 00:00:00		2019-05-13 00:00:00		2018-10-24 00:00:00		2018-10-24 00:00:00		2020-10-07 00:00:00		2020-12-29 00:00:00		2018-10-24 00:00:00		2018-10-24 00:00:00		2018-10-24 00:00:00		2020-10-05 00:00:00
stmnt_type		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10005		10001		10005		10005		10005		10005		10005		10005		10001		10001		10001		10001		10001		10001		10001		10001		10001		10005		10005		10001		10001		10001		10001		10001		10001		10001		10001		10005		10001		10005		10005		10005		10005		10005		10005		10005		10005		10005		10001		10005		10001		10002		10005		10001		10001		10001		10006		10002		10005		10005		10001		10002		10006		10001		10001		10005		10006		10005		10001		10002		10005		10001		10001		10005		10005		10001		10005		10005		10001		10005		10001		10001		10005		10005		10002		10001		10002		10001		10001		10005		10002		10006		10001		10005		10005		10001		10005		10001		10001		10005		10005		10006		10002		10005		10001		10001		10001		10001		10005		10005		10001		10001		10005		10005		10001		10001		10001		10005		10001		10001		10001		10001		10001		10005		10001		10005		10005		10005		10005		10005		10002		10006		10005		10005		10001		10001		10001		10006		10005		10001		10002		10001		10006		10001		10001		10002		10001		10002		10002		10001		10006		10001		10002		10001		10006		10001		10001		10001		10002		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		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11001		11003		11003		11001		11003		11003		11003		11001		11003		11001		11001		11003		11003		11001		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11001		11003		11003		11001		11003		11001		11003		11001		11001		11003		11001		11003		11003		11001		11001		11003		11003		11001		11003		11003		11003		11003		11001		11001		11001		11003		11001		11002		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11001		11003		11003		11003		11001		11003		11003		11003		11001		11003		11003		11003		11001		11001		11001		11003		11003		11001		11001		11001		11003
session_id		1999		1997		1997		1997		1997		1997		1997		1997		1997		1997		1997		1997		1997		1999		1999		1997		1997		1997		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		1999		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2001		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2003		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2005		2007		2005		2005		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2007		2009		2009		2007		2009		2009		2009		2009		2017		2019		2019		2019		2019		2017		2019		2017		2019		2017		2019		2019		2019		2017		2019		2019		2017		2017		2019		2019		2017		2017		2017		2019
user_id		SARRIAGA		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		*		SARRIAGA		*		JLEHMAN		JLEHMAN		JLEHMAN		JLEHMAN		JLEHMAN		*		*		*		*		*		*		*		*		*		JLEHMAN		GPEREZ		*		*		*		*		*		*		*		*		GPEREZ		*		TWALLS		TWALLS		TWALLS		TWALLS		TWALLS		TWALLS		TWALLS		TWALLS		CFLAGG		*		SARRIAGA		*		*		SARRIAGA		*		*		*		SARRIAGA		*		SARRIAGA		CFLAGG		*		*		RALLMOND		*		*		DBARRICK		DBARRICK		GPEREZ		COMPLETED		*		DBARRICK		COMPLETED		COMPLETED		GPEREZ		KVOONG1		COMPLETED		KVOONG1		KLARRY		COMPLETED		KLARRY		COMPLETED		COMPLETED		TTHAM		CFLAGG		COMPLETED		COMPLETED		TTHAM		COMPLETED		COMPLETED		SARRIAGA		COMPLETED		TTHAM		*		SARRIAGA		CFLAGG		*		CFLAGG		*		*		GPEREZ		SARRIAGA		LHOANG		*		SARRIAGA		*		*		*		*		GPEREZ		SARRIAGA		PBANFORD		*		LHOANG		CPON		DHORRELL		DHORRELL		CPON		TMILLER		*		*		*		*		*		RGEREMIA		*		RGEREMIA		MGUERRA		RGEREMIA		RGEREMIA		RGEREMIA		*		JVAZQUEZ		MMORENO		MMORENO		MMORENO		MMORENO		CPON		RGEREMIA		CPON		CAFILER		CAFILER		CAFILER		TRAMON		CAFILER		CAFILER		CAFILER		RGEREMIA		CAFILER		CAFILER		CAFILER		TRAMON		CAFILER		CAFILER		CAFILER		TRAMON		RGEREMIA		RGEREMIA		CAFILER		CAFILER		RGEREMIA		RGEREMIA		RGEREMIA		CAFILER
special_audit		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		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
fine_audit		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11003		11001		11001		11001		11001		11001		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11001		11001		11001		11003		11001		11003		11003		11003		11003		11003		11003		11003		11001		11003		11003		11003		11003		11003		11003		11003		11003		11001		11001		11003		11003		11001		11001		11001		11003
rpt_start		2000-10-01 00:00:00		None		1997-01-01 00:00:00		1997-07-01 00:00:00		1998-01-01 00:00:00		1998-01-01 00:00:00		1998-01-01 00:00:00		1998-05-17 00:00:00		1998-05-17 00:00:00		1998-07-01 00:00:00		1998-01-01 00:00:00		1998-10-18 00:00:00		1998-01-01 00:00:00		1999-01-01 00:00:00		1999-01-01 00:00:00		1997-01-01 00:00:00		1998-01-01 00:00:00		1998-07-01 00:00:00		2000-01-01 00:00:00		None		2000-01-01 00:00:00		1999-07-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-02-20 00:00:00		2000-07-01 00:00:00		2000-01-01 00:00:00		2000-10-01 00:00:00		2000-02-20 00:00:00		2000-07-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-10-22 00:00:00		2000-10-22 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2000-01-01 00:00:00		2001-07-01 00:00:00		2001-01-01 00:00:00		2001-01-01 00:00:00		2001-07-01 00:00:00		2001-07-01 00:00:00		2001-10-01 00:00:00		2001-10-01 00:00:00		2001-11-02 00:00:00		2002-01-01 00:00:00		2002-01-01 00:00:00		2002-01-01 00:00:00		2002-01-01 00:00:00		2002-02-17 00:00:00		2002-02-17 00:00:00		2002-01-01 00:00:00		2002-01-01 00:00:00		2002-07-01 00:00:00		2002-10-01 00:00:00		2002-07-01 00:00:00		2002-10-01 00:00:00		2002-10-20 00:00:00		2002-10-20 00:00:00		2002-10-01 00:00:00		2002-10-01 00:00:00		2003-01-01 00:00:00		2003-07-01 00:00:00		None		2003-01-01 00:00:00		2003-10-06 00:00:00		2003-07-01 00:00:00		2003-10-01 00:00:00		2003-10-01 00:00:00		2004-01-01 00:00:00		2004-02-15 00:00:00		2004-01-01 00:00:00		2004-02-15 00:00:00		2004-07-01 00:00:00		2004-09-30 00:00:00		2004-07-01 00:00:00		None		2004-09-30 00:00:00		2004-10-01 00:00:00		2004-10-01 00:00:00		2005-04-07 00:00:00		None		2005-01-01 00:00:00		2005-01-01 00:00:00		2005-07-01 00:00:00		2005-07-01 00:00:00		2006-01-01 00:00:00		2006-01-01 00:00:00		2006-07-01 00:00:00		2006-07-01 00:00:00		2007-01-01 00:00:00		2006-07-01 00:00:00		2006-07-01 00:00:00		2007-09-23 00:00:00		2007-01-01 00:00:00		2007-07-01 00:00:00		2007-09-23 00:00:00		2008-01-01 00:00:00		2007-07-01 00:00:00		2008-01-01 00:00:00		2008-05-19 00:00:00		2008-03-18 00:00:00		None		2008-05-18 00:00:00		2008-05-23 00:00:00		2008-05-29 00:00:00		2008-05-18 00:00:00		2008-03-18 00:00:00		2008-09-05 00:00:00		2008-09-05 00:00:00		2008-09-05 00:00:00		2008-09-05 00:00:00		2008-07-01 00:00:00		2008-07-01 00:00:00		2008-10-01 00:00:00		2008-10-01 00:00:00		2008-01-01 00:00:00		2008-01-01 00:00:00		2008-01-01 00:00:00		2008-01-01 00:00:00		2008-10-01 00:00:00		2008-10-01 00:00:00		2008-10-19 00:00:00		2009-01-01 00:00:00		2008-10-19 00:00:00		2009-01-01 00:00:00		2009-07-01 00:00:00		None		2009-07-01 00:00:00		2018-10-31 00:00:00		2019-01-31 00:00:00		2020-09-20 00:00:00		None		2020-10-22 00:00:00		2018-11-06 00:00:00		2020-10-05 00:00:00		2018-09-28 00:00:00		2019-01-31 00:00:00		2018-11-01 00:00:00		2020-09-28 00:00:00		None		2020-10-01 00:00:00		2018-11-06 00:00:00		2020-10-06 00:00:00		None		2018-10-24 00:00:00		2018-10-10 00:00:00		2020-10-07 00:00:00		2020-12-29 00:00:00		2018-10-17 00:00:00		2018-10-22 00:00:00		2018-10-11 00:00:00		2020-10-05 00:00:00
rpt_end		2000-10-21 00:00:00		None		1997-06-30 00:00:00		1997-12-31 00:00:00		1998-05-16 00:00:00		1998-05-16 00:00:00		1998-05-16 00:00:00		1998-06-30 00:00:00		1998-06-30 00:00:00		1998-10-17 00:00:00		1998-10-17 00:00:00		1998-12-31 00:00:00		1998-12-31 00:00:00		1999-06-30 00:00:00		1999-06-30 00:00:00		1997-06-30 00:00:00		1998-05-16 00:00:00		1998-10-17 00:00:00		2000-02-19 00:00:00		None		2000-02-19 00:00:00		1999-12-31 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-06-30 00:00:00		2000-09-30 00:00:00		2000-09-30 00:00:00		2000-10-21 00:00:00		2000-06-30 00:00:00		2000-09-30 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2000-12-31 00:00:00		2001-09-30 00:00:00		2001-06-30 00:00:00		2001-06-30 00:00:00		2001-09-30 00:00:00		2001-09-30 00:00:00		2001-12-31 00:00:00		2001-12-31 00:00:00		2001-11-02 00:00:00		2002-02-16 00:00:00		2002-02-16 00:00:00		2002-02-16 00:00:00		2002-02-16 00:00:00		2002-06-30 00:00:00		2002-06-30 00:00:00		2002-02-16 00:00:00		2002-02-16 00:00:00		2002-09-30 00:00:00		2002-10-19 00:00:00		2002-09-30 00:00:00		2002-10-19 00:00:00		2002-12-31 00:00:00		2002-12-31 00:00:00		2002-10-19 00:00:00		2002-10-19 00:00:00		2003-06-30 00:00:00		2003-09-30 00:00:00		None		2003-06-30 00:00:00		2003-10-06 00:00:00		2003-09-30 00:00:00		2003-12-31 00:00:00		2003-12-31 00:00:00		2004-02-14 00:00:00		2004-06-30 00:00:00		2004-02-14 00:00:00		2004-06-30 00:00:00		2004-09-30 00:00:00		2004-09-30 00:00:00		2004-09-30 00:00:00		None		2004-09-30 00:00:00		2004-12-31 00:00:00		2004-12-31 00:00:00		2005-04-07 00:00:00		None		2005-06-30 00:00:00		2005-06-30 00:00:00		2005-12-31 00:00:00		2005-12-31 00:00:00		2006-06-30 00:00:00		2006-06-30 00:00:00		2006-12-31 00:00:00		2006-12-31 00:00:00		2007-06-30 00:00:00		2006-12-31 00:00:00		2006-12-31 00:00:00		2007-12-31 00:00:00		2007-06-30 00:00:00		2007-09-22 00:00:00		2007-12-31 00:00:00		2008-03-17 00:00:00		2007-09-22 00:00:00		2008-03-17 00:00:00		2008-05-19 00:00:00		2008-05-17 00:00:00		None		2008-06-30 00:00:00		2008-05-23 00:00:00		2008-05-29 00:00:00		2008-06-30 00:00:00		2008-05-17 00:00:00		2008-09-05 00:00:00		2008-09-05 00:00:00		2008-09-05 00:00:00		2008-09-05 00:00:00		2008-09-30 00:00:00		2008-09-30 00:00:00		2008-10-18 00:00:00		2008-10-18 00:00:00		2008-10-18 00:00:00		2008-10-18 00:00:00		2008-10-18 00:00:00		2008-10-18 00:00:00		2008-10-18 00:00:00		2008-10-18 00:00:00		2008-12-31 00:00:00		2009-06-30 00:00:00		2008-12-31 00:00:00		2009-06-30 00:00:00		2009-12-31 00:00:00		None		2009-12-31 00:00:00		2018-10-31 00:00:00		2019-01-31 00:00:00		2020-10-17 00:00:00		None		2020-10-22 00:00:00		2018-11-06 00:00:00		2020-10-05 00:00:00		2018-09-28 00:00:00		2019-01-31 00:00:00		2018-11-01 00:00:00		2020-09-28 00:00:00		None		2020-10-01 00:00:00		2018-11-06 00:00:00		2020-10-06 00:00:00		None		2018-10-24 00:00:00		2018-10-10 00:00:00		2020-10-07 00:00:00		2020-12-29 00:00:00		2018-10-17 00:00:00		2018-10-22 00:00:00		2018-10-11 00:00:00		2020-10-05 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		2000-02-24 00:00:00		None		None		None		None		None		None		2000-07-30 00:00:00		2000-07-30 00:00:00		2000-07-30 00:00:00		2000-07-30 00:00:00		2000-07-30 00:00:00		2000-07-31 00:00:00		2000-10-05 00:00:00		2000-10-05 00:00:00		2000-10-26 00:00:00		None		None		2001-01-30 00:00:00		2001-01-30 00:00:00		2001-01-30 00:00:00		2001-01-30 00:00:00		2001-01-30 00:00:00		2001-01-30 00:00:00		2001-01-30 00:00:00		2001-01-30 00:00:00		None		2001-01-29 00:00:00		None		None		None		None		None		None		None		None		None		2001-07-27 00:00:00		None		2001-10-10 00:00:00		2002-01-29 00:00:00		None		2002-01-10 00:00:00		2001-11-02 00:00:00		2002-02-21 00:00:00		None		2002-03-02 00:00:00		None		None		2002-07-31 00:00:00		2002-07-12 00:00:00		None		2002-10-07 00:00:00		2002-10-24 00:00:00		None		None		None		2003-01-31 00:00:00		2002-12-16 00:00:00		None		2003-07-28 00:00:00		2003-10-10 00:00:00		None		None		2003-10-06 00:00:00		None		None		2004-01-09 00:00:00		None		2004-07-29 00:00:00		2004-02-19 00:00:00		None		None		None		2004-10-05 00:00:00		None		None		2005-01-26 00:00:00		None		None		None		2005-07-13 00:00:00		None		None		2006-01-19 00:00:00		None		2006-07-17 00:00:00		2007-01-22 00:00:00		None		None		None		2007-07-17 00:00:00		None		2007-07-25 00:00:00		2007-09-25 00:00:00		2008-01-11 00:00:00		2008-03-18 00:00:00		None		None		2008-05-19 00:00:00		2008-05-19 00:00:00		None		None		2008-05-23 00:00:00		2008-05-29 00:00:00		2008-07-24 00:00:00		None		2008-09-05 00:00:00		2008-09-05 00:00:00		2008-09-05 00:00:00		2008-09-05 00:00:00		2008-10-06 00:00:00		None		2008-10-23 00:00:00		None		None		None		None		None		2009-02-01 00:00:00		None		None		None		2009-02-01 00:00:00		2009-07-28 00:00:00		2010-01-28 00:00:00		None		None		2018-10-31 00:00:00		2019-01-31 00:00:00		2020-10-20 00:00:00		None		2020-10-22 00:00:00		2018-11-06 00:00:00		2020-10-05 00:00:00		2018-09-28 00:00:00		2019-01-31 00:00:00		2018-11-01 00:00:00		2020-09-28 00:00:00		None		2020-10-01 00:00:00		2018-11-06 00:00:00		2020-10-06 00:00:00		None		2018-10-24 00:00:00		2018-10-10 00:00:00		2020-10-07 00:00:00		None		2018-10-17 00:00:00		2018-10-22 00:00:00		2018-10-11 00:00:00		2020-10-05 00:00:00
filing_type		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		None		22001		None		None		22001		22001		None		None		22001		None		None		22001		None		22001		22001		None		None		22001		22001		None		22001		22001		None		22001		None		22001		None		None		22001		None		22001		22001		None		None		None		22001		None		22001		22001		22001		22001		None		None		22001		22001		None		None		22001		22001		22001		None		22001		22001		22001		22001		22001		None		22001		None		None		None		None		None		22001		None		None		None		22001		22001		22001		None		None		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		None		22001		22001		22001		None		22001		22001		22001		22001		22001		22001		22001		22001

Table: filer_to_filer_type

filer_id		1070473		1070473
filer_type		16		16
active		Y		Y
race		0		0
session_id		1997		2009
category		0		0
category_type		40502		40505
sub_category		40103		40103
effect_dt		1997-05-14 00:00:00		2010-04-05 00:00:00
sub_category_type		0		0
election_type		0		0
sub_category_a		S		S
nyq_dt		1997-05-05 00:00:00		1997-05-05 00:00:00
party_cd		None		None
county_cd		18043		18043
district_cd		None		None

Table: filer_xref

filer_id		1070473
xref_id		970630
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		970630		970630		970630		970630		970630
filer_id		1070473		1070473		1070473		1070473		1070473
filer_type		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE		RECIPIENT COMMITTEE
status		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE
effect_dt		2010-04-05 00:00:00		2010-04-05 00:00:00		2010-04-05 00:00:00		2010-04-05 00:00:00		2010-04-05 00:00:00
naml		SAN FRANCISCO LABOR & NEIGHBOR MEMBER EDUCATION/POLITICAL ISSUES COMMITTEE, SPONSORED BY THE SAN FRANCISCO LABOR COUNCIL		SAN FRANCISCO LABOR & NEIGHBOR MEMBER EDUCATION/POLITICAL ISSUES COMMITTEE, SPONSORED BY THE SAN FRANCISCO LABOR COUNCIL		SAN FRANCISCO LABOR & NEIGHBOR MEMBER EDUCATION/POLITICAL ISSUES COMMITTEE, SPONSORED BY THE SAN FRANCISCO LABOR COUNCIL		SAN FRANCISCO LABOR & NEIGHBOR MEMBER EDUCATION/POLITICAL ISSUES COMMITTEE, SPONSORED BY THE SAN FRANCISCO LABOR COUNCIL		SAN FRANCISCO LABOR & NEIGHBOR MEMBER EDUCATION/POLITICAL ISSUES COMMITTEE, SPONSORED BY THE SAN FRANCISCO LABOR COUNCIL
namf		None		None		None		None		None
namt		None		None		None		None		None
nams		None		None		None		None		None
adr1		None		None		None		None		None
adr2		None		None		None		None		None
city		SAN FRANCISCO		SAN FRANCISCO		Sacramento		SAN FRANCISCO		SAN FRANCISCO
st		CA		CA		CA		CA		CA
zip4		941090000		941090000		95814		941090000		94109
phon		4154404809		4154408508		(415) 440-4809		4154404809		4154404809
fax		None		None		None		None		None
email		None		None		None		None		[email protected]

Table: filers

filer_id		1070473

Table: received_filings

filer_id		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473		1070473
filing_file_name		591950_0.cal		644213_0.cal		644228_0.cal		644229_0.cal		644230_0.cal		644232_0.cal		669563_0.cal		669565_0.cal		644389_0.cal		716170_0.cal		677740_0.cal		716832_0.cal		716843_0.cal		716880_0.cal		716887_0.cal		716897_0.cal		716905_0.cal		716906_0.cal		716908_0.cal		770827_0.cal		785784_0.cal		793222_0.cal		805297_0.cal		785784_1.cal		823002_0.cal		823002_1.cal		823002_2.cal		856699_0.cal		871719_0.cal		877937_0.cal		877937_1.cal		912701_0.cal		945244_0.cal		963271_0.cal		962205_0.cal		979369_0.cal		1043655_1.cal		1043655_0.cal		244093.cal		1043655_2.cal		1336131_0.cal		1338432_0.cal		494693.cal		242204.cal		242480.cal		242727.cal		243030.cal		244260.cal		244603.cal		2509790_1.cal		2521316_0.cal		419769.cal		419843.cal		2506471_0.cal		2508079_0.cal		1043655_3.cal		2510542_0.cal		2511491_0.cal		419587.cal		2509790_0.cal
received_date		2000-02-24 00:00:00		2000-07-30 00:00:00		2000-07-30 00:00:00		2000-07-30 00:00:00		2000-07-30 00:00:00		2000-07-30 00:00:00		2000-10-05 00:00:00		2000-10-05 00:00:00		2000-07-31 00:00:00		2001-01-29 00:00:00		2000-10-26 00:00:00		2001-01-30 00:00:00		2001-01-30 00:00:00		2001-01-30 00:00:00		2001-01-30 00:00:00		2001-01-30 00:00:00		2001-01-30 00:00:00		2001-01-30 00:00:00		2001-01-30 00:00:00		2001-07-27 00:00:00		2001-10-10 00:00:00		2001-11-02 00:00:00		2002-01-10 00:00:00		2002-01-29 00:00:00		2002-02-21 00:00:00		2002-03-02 00:00:00		2002-07-12 00:00:00		2002-07-31 00:00:00		2002-10-07 00:00:00		2002-10-24 00:00:00		2002-12-16 00:00:00		2003-01-31 00:00:00		2003-07-28 00:00:00		2003-10-10 00:00:00		2003-10-06 00:00:00		2004-01-09 00:00:00		2004-09-30 00:00:00		2004-09-30 00:00:00		2005-04-12 00:00:00		2005-04-12 00:00:00		2008-05-23 00:00:00		2008-05-29 00:00:00		2007-07-17 00:00:00		2019-01-31 00:00:00		2019-01-31 00:00:00		2019-01-31 00:00:00		2019-01-31 00:00:00		2019-01-31 00:00:00		2019-01-31 00:00:00		2020-10-05 00:00:00		2020-10-22 00:00:00		2020-12-29 00:00:00		2020-12-29 00:00:00		2020-09-28 00:00:00		2020-10-01 00:00:00		2020-12-29 00:00:00		2020-10-06 00:00:00		2020-10-07 00:00:00		2020-12-29 00:00:00		2020-10-05 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		/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		/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		/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		/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		/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/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/cal		/cafiler/disclose/ca99/temp		/cafiler/disclose/ca99/cal
filing_id		591950		644213		644228		644229		644230		644232		669563		669565		644389		716170		677740		716832		716843		716880		716887		716897		716905		716906		716908		770827		785784		793222		805297		785784		823002		823002		823002		856699		871719		877937		877937		912701		945244		963271		962205		979369		1043655		1043655		None		1043655		1336131		1338432		None		None		None		None		None		None		None		2509790		2521316		None		None		2506471		2508079		1043655		2510542		2511491		None		2509790
form_id		F460		F465		F465		F465		F465		F465		F460		F465		F460		F460		F460		F465		F465		F465		F465		F465		F465		F465		F465		F460		F460		F497		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F460		F497		F460		F410		F410		None		F410		F497		F497		None		None		None		None		None		None		None		F497		F497		None		None		F497		F497		F410		F497		F497		None		F497
receive_comment		Filing accepted		Filing accepted, but but with warnings		Filing accepted, but but with warnings		Filing accepted, but but with warnings		Filing accepted, but but with warnings		Filing accepted, but but with warnings		Filing accepted, but but with warnings		Filing accepted, but but with warnings		Filing accepted, but but with warnings		Filing accepted, but with warnings		Filing accepted, but but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted, but with warnings		Filing accepted		Filing accepted, but with warnings		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing passed validation, but failed DB constraints		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing accepted		Filing passed validation, but failed DB constraints		Filing accepted