Home

Filer ID: 1014070

Table: filer_address

filer_id		1014070		1014070		1014070		1014070		1014070		1014070
adrid		1013665		2431501		2437652		2297018		2303742		2322725
effect_dt		1997-02-18 00:00:00		2017-04-24 00:00:00		2017-07-26 00:00:00		2013-08-02 00:00:00		2014-01-27 00:00:00		2014-07-24 00:00:00
add_type		7051		7051		7051		7051		7051		7051
session_id		1997		2017		2017		2013		2013		2013

Table: filer_filings

filer_id		1014070		1014070		1014070		1014070		1014070		1014070		1014070		1014070		1014070		1014070		1014070		1014070		1014070		1014070		1014070		1014070
filing_id		77215		1788970		1866104		1793805		1928128		1829254		1815776		1929804		1874223		2190390		2182797		2152486		2171815		2155211		2194798		2183919
period_id		145		None		217		216		219		None		215		None		None		231		None		229		230		None		None		231
form_id		F461		F461		F461		F497		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F461		F497
filing_sequence		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0		0
filing_date		1997-01-31 00:00:00		2013-08-02 00:00:00		2014-07-24 00:00:00		2013-10-11 00:00:00		2015-01-22 00:00:00		2014-01-31 00:00:00		2014-01-30 00:00:00		2015-01-23 00:00:00		2014-07-28 00:00:00		2017-10-25 00:00:00		2017-07-27 00:00:00		2017-04-24 00:00:00		2017-07-26 00:00:00		2017-04-26 00:00:00		2017-10-27 00:00:00		2017-09-12 00:00:00
stmnt_type		10001		10005		10001		10001		10001		10005		10001		10005		10005		10001		10005		10001		10001		10005		10005		10001
stmnt_status		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001
session_id		1995		2013		2013		2013		2013		2013		2013		2013		2013		2017		2017		2017		2017		2015		2017		2017
user_id		*		RGEREMIA		JINGRAM		WBROWN		JINGRAM		JINGRAM		JINGRAM		JINGRAM		JINGRAM		LPALMER		LPALMER		JINGRAM		LPALMER		JINGRAM		LPALMER		GKURIMOT
special_audit		11001		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003		11003
fine_audit		11001		11001		11001		11003		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001		11001
rpt_start		1996-01-01 00:00:00		2013-01-01 00:00:00		2014-01-01 00:00:00		2013-10-11 00:00:00		2014-07-01 00:00:00		2013-07-01 00:00:00		2013-07-01 00:00:00		2014-07-01 00:00:00		2014-01-01 00:00:00		2017-07-01 00:00:00		2017-04-01 00:00:00		2017-01-01 00:00:00		2017-04-01 00:00:00		2017-01-01 00:00:00		2017-07-01 00:00:00		2017-09-12 00:00:00
rpt_end		1996-12-31 00:00:00		2013-06-30 00:00:00		2014-06-30 00:00:00		2013-10-11 00:00:00		2014-12-31 00:00:00		2013-12-31 00:00:00		2013-12-31 00:00:00		2014-12-31 00:00:00		2014-06-30 00:00:00		2017-09-30 00:00:00		2017-06-30 00:00:00		2017-03-31 00:00:00		2017-06-30 00:00:00		2017-03-31 00:00:00		2017-09-30 00:00:00		2017-09-12 00:00:00
rpt_date		None		None		2014-07-24 00:00:00		2013-10-11 00:00:00		2015-01-22 00:00:00		None		2014-01-30 00:00:00		None		None		2017-10-25 00:00:00		None		2017-04-24 00:00:00		2017-07-26 00:00:00		None		None		2017-09-12 00:00:00
filing_type		None		None		22006		22006		22006		None		22006		None		None		22006		None		22006		22006		None		None		22006

Table: filer_to_filer_type

filer_id		1014070
filer_type		10
active		Y
race		0
session_id		1997
category		0
category_type		40502
sub_category		0
effect_dt		1997-02-18 00:00:00
sub_category_type		0
election_type		0
sub_category_a		None
nyq_dt		None
party_cd		None
county_cd		18019
district_cd		None

Table: filer_xref

filer_id		1014070
xref_id		497112
effect_dt		1999-12-07 00:00:00
migration_source		IDENTFIX

Table: filername

xref_filer_id		497112		497112		497112		497112		497112		497112		497112		497112		497112		497112		497112		497112
filer_id		1014070		1014070		1014070		1014070		1014070		1014070		1014070		1014070		1014070		1014070		1014070		1014070
filer_type		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE		MAJOR DONOR/INDEPENDENT EXPENDITURE COMMITTEE
status		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE		ACTIVE
effect_dt		1997-02-18 00:00:00		1997-02-18 00:00:00		1997-02-18 00:00:00		1997-02-18 00:00:00		1997-02-18 00:00:00		1997-02-18 00:00:00		1997-02-18 00:00:00		1997-02-18 00:00:00		1997-02-18 00:00:00		1997-02-18 00:00:00		1997-02-18 00:00:00		1997-02-18 00:00:00
naml		MAGELLAN HEALTH SERVICES, INC.		MAGELLAN HEALTH SERVICES, INC.		MAGELLAN HEALTH SERVICES, INC.		MAGELLAN HEALTH SERVICES, INC.		MAGELLAN HEALTH SERVICES, INC.		MAGELLAN HEALTH SERVICES, INC.		MAGELLAN HEALTH, INC.		MAGELLAN HEALTH, INC.		MAGELLAN HEALTH, INC.		MAGELLAN HEALTH, INC.		MAGELLAN HEALTH, INC.		MAGELLAN HEALTH, INC.
namf		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
nams		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
adr2		None		None		None		None		None		None		None		None		None		None		None		None
city		ATLANTA		COLUMBIA		COLUMBIA		COLUMBIA		COLUMBIA		COLUMBIA		ATLANTA		COLUMBIA		COLUMBIA		COLUMBIA		COLUMBIA		COLUMBIA
st		GA		MD		MD		MD		MD		MD		GA		MD		MD		MD		MD		MD
zip4		303260000		21046		21046		21046		21046		21046		303260000		21046		21046		21046		21046		21046
phon		8003429660		4109534701		4109534701		4109534701		4109534701		4109534701		8003429660		4109534701		4109534701		4109534701		4109534701		4109534701
fax		None		None		None		None		None		None		None		None		None		None		None		None
email		None		None		None		None		None		None		None		None		None		None		None		None

Table: filers

filer_id		1014070