entity_nursing_homes

Summary

This table contains information on nursing homes.  Originally, it was designed to house data specific to Nursing Homes in NY for the NYSprofiles project, but use of the Quarterly CMS Nursing Home Compare data set has introduced data for Medicare and Medicaid Nursing Homes nationwide.  This table uses a unique entity_id, housed in the entities table.  This entity_id is also linked to the entity_nursing_home_attributes and entity_nursing_home_overrides tables.

Table Creation

CREATE TABLE IF NOT EXISTS `entity_nursing_homes` ( 
`entity_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, 
`mpn_id` varchar(15) DEFAULT NULL, 
`certification` varchar(64) DEFAULT NULL, 
`name` varchar(255) DEFAULT NULL, 
`aka` varchar(255) DEFAULT NULL, 
`address` varchar(255) DEFAULT NULL, 
`city` varchar(255) DEFAULT NULL, 
`state` enum ('AK','AL','AR','AZ','CA','CO','CT','DC','DE','FL','GA','GU','HI','IA','ID','IL', 
'IN','KS','KY','LA','MA','MD','ME','MI','MN','MO','MP','MS','MT','NC','ND','NE','NH','NJ','NM', 
'NV','NY','OH','OK','OR','PA','PR','RI','SC','SD','TN','TX','US','UT','VA','VI','VT','WA','WI','WV','WY') DEFAULT NULL, 
`state_fips` varchar(10) DEFAULT NULL, 
`zipcode` varchar(5) DEFAULT NULL, 
`county_name` varchar(30) DEFAULT NULL, 
`county_fips` varchar(10) DEFAULT NULL, 
`phone_number` varchar(46) DEFAULT NULL, 
`operator_name` varchar(255) DEFAULT NULL, 
`operator_address` varchar(255) DEFAULT NULL, 
`operator_city` varchar(64) DEFAULT NULL, 
`operator_state` varchar(2) DEFAULT NULL, 
`operator_zip` varchar(5) DEFAULT NULL, 
`ownership` varchar(64) DEFAULT NULL, 
`aa_mf` tinyint(1) DEFAULT '0', 
`aa_cc` tinyint(1) DEFAULT '0', 
`aa_sf` tinyint(1) DEFAULT '0', 
`aa_ih` tinyint(1) DEFAULT '0', 
`geo_lat` float DEFAULT NULL, 
`geo_long` float DEFAULT NULL, 
`opened_date` date DEFAULT NULL, 
`closed_date` date DEFAULT NULL, 
`created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', 
`modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP, 
PRIMARY KEY (`entity_id`) 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=150935 ;

Fields

`entity_id` the unique id that serves to identify an entity internally. It links to the entities table 
`mpn_id` medicare provider number, provided federally 
`local_id` identifier that is used locally, generally by the state 
`name` name recognized by the AHA 
`aka` additional alias that is generally or locally accepted. In this table, it is usually the Federal name 
`address` 
`city` 
`state` 
`state_fips` nationally recognized ID number associated with the state. 
`zipcode` 
`county_name` 
`county_fips` nationally recognized ID number associated with individual counties for each state. 
`phone_number`
`operator_name`, 
`operator_address`, 
`operator_city`, 
`operator_state`, 
`operator_zip`, 
`ownership`, 
`aa_mf` is multi-facility? 1=yes 0=no. Determines whether or not an entity has multiple facilities associated with it 
`aa_cc`, 
`aa_sf', 
`aa_ih`, 
`geo_lat` latitude location of the facility 
`geo_long` longitude location of the facility 
`opened_date` the date the entity was opened in YYYY-MM-DD format 
`closed_date` the date the entity was closed in YYYY-MM-DD format 
`created` the date the row was created in YYYY-MM-DD HH:MM:SS format 
`modified` the date the row was last changed in YYYY-MM-DD HH:MM:SS format

Field Information

PRIMARY KEY (`entity_id`)

Notes