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.
...
| field | type | attributes | notes | example |
| entity_dialysis_facilities.entity_id | int(10) | UNSIGNED NOT NULL AUTO_INCREMENT | Provided by Pellucid, same as FOREIGN KEY: links to entities table | 210314 |
| entity_dialysis_facilities.mpn_id | varchar(7) | DEFAULT NULL | Provided by CMS Data | 100009 |
| entity_dialysis_facilities.local_id | Varchar(20) | DEFAULT NULL | Provided by state or secondary reporting entity | 1234 |
| entity_dialysis_facilities.network_id | Varchar(2) | DEFAULT NULL | Links to Network Directory | 18 |
| entity_dialysis_facilities.name | Varchar(255) | DEFAULT NULL | Defined by CMS | AGUADILLA DIALYSIS CENTER |
| entity_dialysis_facilities.aka | Varchar(255) | DEFAULT NULL | Defined by secondary reporting entity | FMC AGUADILLA DIALYSIS CENTER |
| entity_dialysis_facilities.address | Varchar(255) | DEFAULT NULL | Physical Location | 132 Real Drive |
| entity_dialysis_facilities.city | Varchar(64) | DEFAULT NULL | Forest Hills | |
| entity_dialysis_facilities.state | Varchar(2) | DEFAULT NULL | 2 character abbreviation for state | NY |
| entity_dialysis_facilities.state_fips | Varchar(2) | DEFAULT NULL | Nationally defined | 36 |
| entity_dialysis_facilities.zipcode | Varchar(10) | DEFAULT NULL | 11375 | |
| entity_dialysis_facilities.county_name | Varchar(64) | DEFAULT NULL | Cook | |
| entity_dialysis_facilities.county_fips | Varchar(3) | DEFAULT NULL | Nationally defined | 125 |
| entity_dialysis_facilities.phone_number | Varchar(20) | DEFAULT NULL | 5161234567890 | |
| entity_dialysis_facilities.ownership | Varchar(64) | DEFAULT NULL | Owner/operator type | For Profit |
| entity_dialysis_facilities.chain | Tinyint(1) | DEFAULT NULL | 0=N 1=Y | 1 |
| entity_dialysis_facilities.chain_name | Varchar(255) | DEFAULT NULL | Name given to the chain | Super Dialysis Centers of America |
| entity_dialysis_facilities.certified_date | date | DEFAULT NULL | Date of certification | 2001-01-01 |
| entity_dialysis_facilities.closed_date | date | DEFAULT NULL | Date of closure | 2013-12-31 |
| entity_dialysis_facilities.created | datetime | DEFAULT NULL | Time of row creation | 2015-02-01 12:23:34 |
| entity_dialysis_facilities.modified | timestamp | NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP | Time of most recent modification | 2015-02-01 12:23:34 |
...