Nursing_Homes

Data source: Medicare / Nursing Home Compare: Provider Info

This database can be queried live, on the web, using Structured Query Language (SQL) supported by SQLite. For more on that syntax, see here or look at some example queries.

Example Queries

Custom SQL query

Facility_info

address, lat, lng, geocode_flag, geocode_accuracy, federal_provider_number, provider_name, provider_address, provider_city...

15,450 rows

Infection_info

provnum, provname, address, city_raw, state, zip, survey_date_output, surveytype, defpref...

20,449 rows

Owners

provnum, provname, address, city_raw, state, zip, role_desc, owner_type, owner_name...

165,964 rows

ZIP_codes

ZIP_CODE, PO_NAME, STATE, ZCTA, zip_join_type, ZCTA5, CBSA, MPOP, ZPOP...

44,832 rows

... and 24 hidden tables

Download SQLite DB: Nursing_Homes.db 63.4 MB

Powered by Datasette · Query took 53.78ms · Data source: Medicare / Nursing Home Compare: Provider Info