Entity_dialysis_facilities

The entity_dialysis_facilities table contains information on the entities that are considered dialysis facilities. It contains details on the facility and its operating specifications. The entity_id field links to the entities table, having the same id existing in both tables and acting as a key.

Dialiysis Facilities are linked to the treatment of End Stage Renal Disease patients and the table is used to help track useful measures associated with this type of facility.

Table Creation

CREATE TABLE IF NOT EXISTS `entity_dialysis_facilities` (
`entity_id` int(10) NOT NULL,
`mpn_id` varchar(7) DEFAULT NULL,
`local_id` varchar(20) DEFAULT NULL,
`network_id` varchar(2) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`aka` varchar(255) DEFAULT NULL,
`address` varchar(255) DEFAULT NULL,
`city` varchar(64) DEFAULT NULL,
`state` varchar(2) DEFAULT NULL,
`state_fips` varchar(2) DEFAULT NULL,
`zipcode` varchar(10) DEFAULT NULL,
`county_name` varchar(64) DEFAULT NULL,
`county_fips` varchar(3) DEFAULT NULL,
`phone_number` varchar(20) DEFAULT NULL,
`ownership` varchar(64) DEFAULT NULL,
`chain` tinyint(1) DEFAULT NULL,
`chain_name` varchar(255) DEFAULT NULL,
`certified_date` date DEFAULT NULL,
`closed_date` date DEFAULT NULL,
`created` datetime DEFAULT NULL,
`modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Field Information

`entity_id` the identifying entity number. Same as entity_id in the entities table, and serves as a link 
`mpn_id` is the identifying number derived from Medicare and CMS data
`local_id`identifying code number assigned by the state or reporting entity
`network_id` code to identify the network in the network directory lookup
`name` formal business name as used by the primary reporting entity
`aka` secondary name given by another source (generally state)
`address` facility location
`city` 
`state` the two-letter state abbreviation ('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').
`state_fips` 2 digit fips code used for state identification
`zipcode` 
`county_name` 
`county_fips` 3 digit fips code used for county identification
`phone_number` 
`ownership` the nature of how the entity operates.  Not for Profit or For Profit
`chain` binary field that records if the facility is part of a chain. 0 = No, 1 = Yes
`chain_name` name given to the chain of facilities
`certified_date` when the facility was originally certified to operate
`closed_date` if and when the facility was closed
`created` timestamp of when this entry was created in the database
`modified` timestamp of the last time this row was modified

Fields