Summary
Table Creation
CREATE TABLE IF NOT EXISTS `entity_acos` (
`entity_id` int(10) NOT NULL DEFAULT '0',
`local_id` varchar(10) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`aka` varchar(255) DEFAULT NULL,
`entity_type` varchar(255) DEFAULT NULL,
`classification` varchar(255) DEFAULT NULL,
`date_start` date DEFAULT NULL,
`counties_served` varchar(255) DEFAULT NULL,
`address` varchar(255) DEFAULT NULL,
`city` varchar(255) DEFAULT NULL,
`state` varchar(2) 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,
`phonenumber` varchar(46) DEFAULT NULL,
`geo_lat` float DEFAULT NULL,
`geo_long` float DEFAULT NULL,
`website` varchar(255) DEFAULT NULL,
`contact_ipro` varchar(255) DEFAULT NULL,
`contact_cmwf` varchar(255) DEFAULT NULL,
`summary_detail` varchar(255) DEFAULT NULL,
`estimated_members` varchar(255) DEFAULT NULL,
`estimated_physicians` varchar(255) DEFAULT NULL,
`physician_details` varchar(255) DEFAULT NULL,
`closed_date` date DEFAULT NULL,
`created` datetime DEFAULT NULL,
`modified` datetime DEFAULT NULL,
PRIMARY KEY (`entity_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Fields
| field | type | attributes | notes | example |
|---|---|---|---|---|
| entity_id | int(10) | UNSIGNED NOT NULL AUTO_INCREMENT | Provided by Pellucid, same as entities table | 1219198502 |
| local_id | varchar(10) | DEFAULT NULL | Assigned by data provider, ex: state | 0012 |
| name | varchar(255) | DEFAULT NULL | Ted's ACO | |
| aka | varchar(255) | DEFAULT NULL | Ted Jr's ACO | |
| entity_type | varchar(255) | DEFAULT NULL | Medicare Shared Savings | |
| classification | varchar(255) | DEFAULT NULL | Details on the Operating status of the entity | Partnership of Hospitals |
| date_start | date | YYYY-MM-DD | 2014-08-04 | |
| counties_served | varchar(255) | DEFAULT NULL | List of counties that are part of the ACO | Nassau |
| address | varchar(255) | DEFAULT NULL | Physical Location | 123 Fake St |
| city | varchar(255) | DEFAULT NULL | Lake Success | |
| state | varchar(2) | DEFAULT NULL | Two-letter state abbreviation | NY |
| state_fips | varchar(10) | DEFAULT NULL | 09 | |
| zipcode | varchar(5) | DEFAULT NULL | 11042 | |
| county_name | varchar(30) | DEFAULT NULL | Nassau | |
| county_fips | varchar(10) | DEFAULT NULL | 056 | |
| phone_number | varchar(46) | DEFAULT NULL | 5165550123 | |
| geo_lat | float | DEFAULT NULL | latitude location | -45.00032 |
| geo_long | float | DEFAULT NULL | longitude location | 101.12345 |
| website | varchar(255) | DEFAULT NULL | url | www.site.com |
| contact_ipro | varchar(255) | DEFAULT NULL | contact through IPRO | jim@ipro.us |
| contact_cmwf | varchar(255) | DEFAULT NULL | contact through Common Wealth Funds | jim@fake.org |
| summary_detail | varchar(255) | DEFAULT NULL | a description of who runs the ACO and what locations it serves | CEO James Bond is the contact |
| estimated_members | varchar(255) | DEFAULT NULL | approximate number of members | 600 |
| estimated_physicians | varchar(255) | DEFAULT NULL | approximate number of physicians | 6 |
| physician_details | varchar(255) | DEFAULT NULL | indicates the number of primary care physicians and specialists | PCPs = 12; Specialists = 4 |
| closed_date | date | DEFAULT NULL | 2011-01-12 | |
| created | datetime | when the row was created | 2000-01-01 11:11:11 | |
| modified | datetime | when the row was most recently changed | 2014-08-01 01:12:12 |