About this Data

This dataset contains information about 7596 hospitals in the US, including latitude, longitude, staff, beds, ownership, among others.
All records were extracted from the U.S. Department of Homeland Security.

How to Use this Data

Explore size, ownership, and geographical distribution of hospitals.

Your notebook can be featured here!
More Datasets.

Acknowledgments

License

Public Domain

Splash icon

Icon made by Freepik, available on Flaticon.

Splash banner

Wallpaper by mrsirapholm, available on FreePik.

Tables

Us Hospital Locations

@kaggle.andrewmvd_us_hospital_locations.us_hospital_locations

1.05 MB
7596 rows
34 columns


CREATE TABLE us_hospital_locations (
  "x" DOUBLE,
  "y" DOUBLE,
  "fid" BIGINT,
  "id" BIGINT,
  "name" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" BIGINT,
  "zip4" VARCHAR,
  "telephone" VARCHAR,
  "type" VARCHAR,
  "status" VARCHAR,
  "population" BIGINT,
  "county" VARCHAR,
  "countyfips" VARCHAR,
  "country" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "naics_code" BIGINT,
  "naics_desc" VARCHAR,
  "source" VARCHAR,
  "sourcedate" TIMESTAMP,
  "val_method" VARCHAR,
  "val_date" TIMESTAMP,
  "website" VARCHAR,
  "state_id" VARCHAR,
  "alt_name" VARCHAR,
  "st_fips" BIGINT,
  "owner" VARCHAR,
  "ttl_staff" BIGINT,
  "beds" BIGINT,
  "trauma" VARCHAR,
  "helipad" VARCHAR
);