Back to fileView metadata
Schema
Nursing Homes / Nursing Homes / v1.0.0
Schema from nursing-homes.parquet, gcp-portolan-published, v1.0.0.
The Nursing Home / Assisted Care feature class/shapefile contains facilities that house elderly adults. This feature class’s/shapefile's attribution contains physical and demographic information for facilities in the continental United States and some of its territories. The purpose of this feature class/shapefile is to provide accurate locations for high concentrations of elderly adults in the event of a disaster. The attribution within this feature class/shapefile was populated via open source methodologies of authoritative sources. During the update cycle for this version, 7170 records added
Columns
34 columns
Features
53,129
Geometry
Point
| Column | Type | Nullable | Nulls | Unique | Description | Examples / Values |
|---|---|---|---|---|---|---|
| geometry | geometry | No | 0 | — | — Range: —Length: — | Examples: — Values: — |
| OBJECTID | integer | No | 0 | — | — Range: 1 to 5000Length: — | Examples: 399, 3834, 4837, 4573, 637 Values: — |
| ID | string | No | 0 | — | — Range: —Length: 6 | Examples: 02519, 042443, 063345, 062874, 01467 Values: — |
| NAME | string | No | 0 | — | — Range: —Length: 87 | Examples: JACOBS PLACE, DESERT PALM ADULT CARE II, VINEYARD PLACE, PILGRIM PLACE HEALTH SERVICES CENTER, SYLACAUGA HEALTH AND REHAB SERVICES Values: — |
| ADDRESS | string | No | 0 | — | — Range: —Length: 50 | Examples: 2117 DOLLY VARDEN AVENUE, 7022 NORTH 10TH PLACE, 24325 WASHINGTON AVE, 721 HARRISON AVE, 1007 WEST FORT WILLIAMS STREET Values: — |
| CITY | string | No | 0 | — | — Range: —Length: 22 | Examples: ANCHORAGE, PHOENIX, MURRIETA, CLAREMONT, SYLACAUGA Values: — |
| STATE | string | No | 0 | — | — Range: —Length: 2 | Examples: AK, AZ, CA, CA, AL Values: AK, AL, AR, AZ, CA |
| ZIP | string | No | 0 | — | — Range: —Length: 5 | Examples: 99516, 85020, 92562, 91711, 35150 Values: — |
| ZIP4 | string | No | 0 | — | — Range: —Length: 13 | Examples: NOT AVAILABLE, NOT AVAILABLE, NOT AVAILABLE, 4539, NOT AVAILABLE Values: — |
| TELEPHONE | string | No | 0 | — | — Range: —Length: 14 | Examples: (907) 345-8654, (602) 943-4842, (951) 387-8410, (909) 399-5500, (256) 245-7402 Values: — |
| TYPE | string | No | 0 | — | — Range: —Length: 15 | Examples: ASSISTED LIVING, ASSISTED LIVING, ASSISTED LIVING, NURSING HOME, NURSING HOME Values: ASSISTED LIVING, NOT AVAILABLE, NURSING HOME |
| STATUS | string | No | 0 | — | — Range: —Length: 4 | Examples: OPEN, OPEN, OPEN, OPEN, OPEN Values: OPEN |
| POPULATION | integer | No | 0 | — | — Range: -999 to 876Length: — | Examples: 1, 10, 82, 62, 149 Values: — |
| COUNTY | string | No | 0 | — | — Range: —Length: 20 | Examples: ANCHORAGE, MARICOPA, RIVERSIDE, LOS ANGELES, TALLADEGA Values: — |
| COUNTYFIPS | string | No | 0 | — | — Range: —Length: 5 | Examples: 02020, 04013, 06065, 06037, 01121 Values: — |
| COUNTRY | string | No | 0 | — | — Range: —Length: 3 | Examples: USA, USA, USA, USA, USA Values: USA |
| LATITUDE | float | No | 0 | — | — Range: 30.29628144700007 to 71.30057095000006Length: — | Examples: 61.11205074000003, 33.539067561000024, 33.562442797000074, 34.09918524100004, 33.16660428800003 Values: — |
| LONGITUDE | float | No | 0 | — | — Range: -162.60111670399996 to -85.019378Length: — | Examples: -149.84230819599998, -112.06002891399999, -117.22450727599994, -117.72688550399994, -86.26747370299995 Values: — |
| NAICS_CODE | string | No | 0 | — | — Range: —Length: 6 | Examples: 623312, 623312, 623312, 623110, 623110 Values: 623110, 623312 |
| NAICS_DESC | string | No | 0 | — | — Range: —Length: 52 | Examples: ASSISTED LIVING FACILITIES FOR THE ELDERLY, ASSISTED LIVING FACILITIES FOR THE ELDERLY, ASSISTED LIVING FACILITIES FOR THE ELDERLY, NURSING CARE FACILITIES (SKILLED NURSING FACILITIES), NURSING CARE FACILITIES (SKILLED NURSING FACILITIES) Values: ASSISTED LIVING FACILITIES FOR THE ELDERLY, NURSING CARE FACILITIES (SKILLED NURSING FACILITIES) |
| SOURCE | string | No | 0 | — | — Range: —Length: 164 | Examples: http://dhss.alaska.gov/dhcs/#rl, https://azdhs.gov/licensing/ltc-facilities/index.php#consumers-databases, https://data.chhs.ca.gov/dataset/healthcare-facility-locations/resource/0a0476ba-442c-40ff-97dc-dc840fa7e907, https://data.chhs.ca.gov/dataset/healthcare-facility-locations/resource/0a0476ba-442c-40ff-97dc-dc840fa7e907, https://www.alabamapublichealth.gov/providerstandards/ Values: http://dhss.alaska.gov/dhcs/#rl, http://dhss.alaska.gov/dhcs/pages/default.aspx#hflc, https://azdhs.gov/licensing/ltc-facilities/index.php#consumers-databases, https://azdhs.gov/licensing/residential-facilities/index.php#consumers-databases, https://data.chhs.ca.gov/dataset/healthcare-facility-locations, https://data.chhs.ca.gov/dataset/healthcare-facility-locations/resource/0a0476ba-442c-40ff-97dc-dc840fa7e907, https://humanservices.arkansas.gov/divisions-shared-services/provider-services-quality-assurance/consumer-long-term-care-information/long-term-care-facility-search/, https://www.alabamapublichealth.gov/providerstandards/ |
| SOURCEDATE | string | No | 0 | — | — Range: —Length: 10 | Examples: 3/30/2021, 5/7/2020, 10/19/2020, 10/19/2020, 6/5/2021 Values: 10/19/2020, 3/30/2021, 5/7/2020, 6/5/2021, 6/7/2021, 8/30/2021 |
| VAL_METHOD | string | No | 0 | — | — Range: —Length: 13 | Examples: IMAGERY/OTHER, IMAGERY/OTHER, IMAGERY/OTHER, IMAGERY/OTHER, IMAGERY/OTHER Values: IMAGERY/OTHER, UNVERIFIED |
| VAL_DATE | string | No | 0 | — | — Range: —Length: 10 | Examples: 3/30/2021, 5/7/2020, 10/19/2020, 10/19/2020, 6/5/2021 Values: 10/19/2020, 10/27/2020, 3/30/2021, 5/1/2022, 5/2/2022, 5/7/2020, 6/11/2021, 6/5/2021, 6/7/2021, 6/8/2021, 6/9/2021 |
| WEBSITE | string | No | 0 | — | — Range: —Length: 151 | Examples: NOT AVAILABLE, NOT AVAILABLE, NOT AVAILABLE, NOT AVAILABLE, NOT AVAILABLE Values: — |
| TOT_RES | integer | No | 0 | — | — Range: -999 to 876Length: — | Examples: 1, 10, 82, 62, 149 Values: — |
| TOT_STAFF | integer | No | 0 | — | — Range: -999 to -999Length: — | Examples: -999, -999, -999, -999, -999 Values: — |
| BEDS | integer | No | 0 | — | — Range: -999 to 876Length: — | Examples: 1, 10, 82, 62, 149 Values: — |
| EXCESS_BED | integer | No | 0 | — | — Range: -999 to -999Length: — | Examples: -999, -999, -999, -999, -999 Values: — |
| OWNERSHIP | string | No | 0 | — | — Range: —Length: 61 | Examples: NOT AVAILABLE, NOT AVAILABLE, NOT AVAILABLE, NONPROFIT CORP, LIMITED LIABILITY COMPANY Values: — |
| MEDICAIDID | string | No | 0 | — | — Range: —Length: 13 | Examples: NOT AVAILABLE, NOT AVAILABLE, NOT AVAILABLE, NOT AVAILABLE, 47-5317 Values: — |
| MEDICAREID | string | No | 0 | — | — Range: —Length: 13 | Examples: NOT AVAILABLE, NOT AVAILABLE, NOT AVAILABLE, NOT AVAILABLE, 01-5160 Values: — |
| STATE_LIC | string | No | 0 | — | — Range: —Length: 13 | Examples: 101230, AL10926H, 331800073, 950000084, N6101 Values: — |
| SOURCETYPE | string | No | 0 | — | — Range: —Length: 69 | Examples: ASSISTED LIVING, ASSISTED LIVING, RESIDENTIAL CARE ELDERLY, SKILLED NURSING FACILITY, NURSING HOME Values: ASSISTED LIVING, ASSISTED LIVING FACILITY, ASSISTED LIVING FACILITY (SPECIALTY CARE), ASSISTED LIVING FACILITY LEVEL I, ASSISTED LIVING FACILITY LEVEL II, ASSISTED LIVING II, ASSISTED LIVING LEVEL II, LONG TERM CARE, NOT AVAILABLE, NURSING HOME, POST-ACUTE HEAD INJURY RETRAINING RESIDENTIAL FACILITY, RCFE-CONTINUING CARE RETIREMENT COMMUNITY, RESIDENTIAL CARE ELDERLY, RESIDENTIAL CARE FACILITY, SKILLED NURSING FACILITY, SKILLED NURSING FACILITY ONLY, SKILLED NURSING FACILITY WITH DUAL CERTIFIED BEDS (MEDICAID/MEDICARE), SKILLED NURSING FACILITY/NURSING FACILITY DISTINCT PARTITION, SKILLED NURSING FACILITY/NURSING FACILITY DUAL CERTIFIED |
Quality checks: Passed
Invalid geometry count: 0
Columns hash: ec5658dcec43dca46ffee8733b00dde3fe2eb956359d5e481f9c349e881f3362