Hospital Atlas Data

Includes information about hospitals such as provider details, location, teaching status, and bed counts. This data is essential for understanding the distribution and capacity of healthcare facilities within local networks.

Data license: Please contact the data provider for more information. · Data source: U.S. Census, Dartmouth Atlas of Health Care, NCQA, AIDOS Lab.

20 rows where pcity = "HAMMOND"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: provider, new_prov, status14, shortname, pstate, pzip, hsa, hsaname, hrr, hrrname, fcounty, fcntyname, posbeds, sysname, ahabeds, hosptype, excl_flag, icu_flag, year, status15, status16, pname, status17, latitude, longitude

Link rowid ▼ provider new_prov status14 shortname pcity pstate pzip hsa hsaname hrr hrrname fcounty fcntyname posbeds sysname ahabeds category teachstatus hosptype nci_center excl_flag icu_flag year status15 status16 pname status17 latitude longitude
1390 1390 150004   9.OK? Franciscan St. Margaret -Hammond HAMMOND IN 46320 15035 IN- HAMMOND 186 IN- MUNSTER 18089 Lake County, IN 139 Franciscan Alliance 500.0     4.Other acute care hosp   9.OK?   2014.0         41.6173959 -87.5220108
1514 1514 152012   1.NonAcute Kindred Hospital Northwest Indiana HAMMOND IN 46320 15035 IN- HAMMOND 186 IN- MUNSTER 18089 Lake County, IN 70 Kindred Healthcare 70.0     5.Longterm/non-acute   1.NonAcute noICUdays 2014.0         41.6173959 -87.5220108
1900 1900 190015   9.OK? North Oaks Medical Center HAMMOND LA 70403 19033 LA- HAMMOND 210 LA- BATON ROUGE 22105 Tangipahoa Parish, LA 312 North Oaks Health System 278.0     4.Other acute care hosp   9.OK?   2014.0         30.5043583 -90.4611995
1980 1980 190303   9.OK? Cypress Pointe Surgical Hospital HAMMOND LA 70403 19033 LA- HAMMOND 210 LA- BATON ROUGE 22105 Tangipahoa Parish, LA 30         4.Other acute care hosp   9.OK? noICUdays 2014.0         30.5043583 -90.4611995
2038 2038 192036   1.NonAcute Post Acute Specialty Hosp -Hammond HAMMOND LA 70403 19033 LA- HAMMOND 210 LA- BATON ROUGE 22105 Tangipahoa Parish, LA 40 Post Acute Medical, LLC 40.0     5.Longterm/non-acute   1.NonAcute noICUdays 2014.0         30.5043583 -90.4611995
6559 6559 150004     Franciscan St. Margaret -Hammond HAMMOND IN 46320 15035 IN- HAMMOND 186 IN- MUNSTER 18089 Lake County, IN 139 Franciscan Alliance 406.0     4.Other acute care hosp   9.OK?   2016.0 9.OK?       41.6173959 -87.5220108
6682 6682 152012     Kindred Hospital Northwest Indiana HAMMOND IN 46320 15035 IN- HAMMOND 186 IN- MUNSTER 18089 Lake County, IN 70 Kindred Healthcare 70.0     5.Longterm/non-acute   1.NonAcute noICUdays 2016.0 1.NonAcute       41.6173959 -87.5220108
7063 7063 190015     North Oaks Medical Center HAMMOND LA 70403 19033 LA- HAMMOND 210 LA- BATON ROUGE 22105 Tangipahoa Parish, LA 312 North Oaks Health System 248.0     4.Other acute care hosp   9.OK?   2016.0 9.OK?       30.5043583 -90.4611995
7142 7142 190303     Cypress Pointe Surgical Hospital HAMMOND LA 70403 19033 LA- HAMMOND 210 LA- BATON ROUGE 22105 Tangipahoa Parish, LA 30         4.Other acute care hosp   9.OK? noICUdays 2016.0 9.OK?       30.5043583 -90.4611995
7197 7197 192036     Post Acute Specialty Hosp -Hammond HAMMOND LA 70403 19033 LA- HAMMOND 210 LA- BATON ROUGE 22105 Tangipahoa Parish, LA 40 Post Acute Medical, LLC 40.0     5.Longterm/non-acute   1.NonAcute   2016.0 1.NonAcute       30.5043583 -90.4611995
11686 11686 150004 150004   Franciscan St. Margaret -Hammond HAMMOND IN 46320 15035 IN- HAMMOND 186 IN- MUNSTER 18089 IN-Lake County 139 Franciscan Health 406.0     4.Other acute care hosp   9.OK?       9.OK? FRANCISCAN HEALTH HAMMOND   41.6173959 -87.5220108
11806 11806 152012 152012   Kindred Hospital Northwest Indiana HAMMOND IN 46320 15035 IN- HAMMOND 186 IN- MUNSTER 18089 IN-Lake County 70 Kindred Healthcare 70.0     5.Longterm/non-acute   1.NonAcute noICUdays     1.NonAcute KINDRED HOSPITAL NORTHWEST INDIANA   41.6173959 -87.5220108
12186 12186 190015 190015   North Oaks Medical Center HAMMOND LA 70403 19033 LA- HAMMOND 210 LA- BATON ROUGE 22105 LA-Tangipahoa Parish 312 North Oaks Health System 231.0     4.Other acute care hosp   9.OK?       9.OK? NORTH OAKS MEDICAL CENTER, L L C   30.5043583 -90.4611995
12264 12264 190303 190303   Cypress Pointe Surgical Hospital HAMMOND LA 70403 19033 LA- HAMMOND 210 LA- BATON ROUGE 22105 LA-Tangipahoa Parish 30         4.Other acute care hosp   9.OK? noICUdays     9.OK? CYPRESS POINTE SURGICAL HOSPITAL   30.5043583 -90.4611995
12318 12318 192036 192036   Post Acute Specialty Hosp -Hammond HAMMOND LA 70403 19033 LA- HAMMOND 210 LA- BATON ROUGE 22105 LA-Tangipahoa Parish 40 Post Acute Medical, LLC 40.0     5.Longterm/non-acute   1.NonAcute       1.NonAcute POST ACUTE SPECIALTY HOSPITAL OF HAMMOND   30.5043583 -90.4611995
16794 16794 150004 150004   Franciscan St. Margaret -Hammond HAMMOND IN 46320 15035 IN- HAMMOND 186 IN- MUNSTER 18089 IN-Lake County 139 Franciscan Health 406.0     4.Other acute care hosp   9.OK?   2017.0     FRANCISCAN HEALTH HAMMOND 9.OK? 41.6173959 -87.5220108
16914 16914 152012 152012   Kindred Hospital Northwest Indiana HAMMOND IN 46320 15035 IN- HAMMOND 186 IN- MUNSTER 18089 IN-Lake County 70 Kindred Healthcare 70.0     5.Longterm/non-acute   1.NonAcute   2017.0     KINDRED HOSPITAL NORTHWEST INDIANA 1.NonAcute 41.6173959 -87.5220108
17290 17290 190015 190015   North Oaks Medical Center HAMMOND LA 70403 19033 LA- HAMMOND 210 LA- BATON ROUGE 22105 LA-Tangipahoa Parish 330 North Oaks Health System 231.0     4.Other acute care hosp   9.OK?   2017.0     NORTH OAKS MEDICAL CENTER, L L C 9.OK? 30.5043583 -90.4611995
17368 17368 190303 190303   Cypress Pointe Surgical Hospital HAMMOND LA 70403 19033 LA- HAMMOND 210 LA- BATON ROUGE 22105 LA-Tangipahoa Parish 30   24.0     4.Other acute care hosp   9.OK? noICUdays 2017.0     CYPRESS POINTE SURGICAL HOSPITAL 9.OK? 30.5043583 -90.4611995
17421 17421 192036 192036   Post Acute Specialty Hosp -Hammond HAMMOND LA 70403 19033 LA- HAMMOND 210 LA- BATON ROUGE 22105 LA-Tangipahoa Parish 40 Post Acute Medical, LLC 40.0     5.Longterm/non-acute   1.NonAcute   2017.0     P A M SPECIALTY HOSPITAL OF HAMMOND 1.NonAcute 30.5043583 -90.4611995

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "hospital_atlas_data" (
   [provider] INTEGER,
   [new_prov] TEXT,
   [status14] TEXT,
   [shortname] TEXT,
   [pcity] TEXT,
   [pstate] TEXT,
   [pzip] INTEGER,
   [hsa] INTEGER,
   [hsaname] TEXT,
   [hrr] INTEGER,
   [hrrname] TEXT,
   [fcounty] INTEGER,
   [fcntyname] TEXT,
   [posbeds] INTEGER,
   [sysname] TEXT,
   [ahabeds] FLOAT,
   [category] TEXT,
   [teachstatus] TEXT,
   [hosptype] TEXT,
   [nci_center] TEXT,
   [excl_flag] TEXT,
   [icu_flag] TEXT,
   [year] FLOAT,
   [status15] TEXT,
   [status16] TEXT,
   [pname] TEXT,
   [status17] TEXT,
   [latitude] FLOAT,
   [longitude] FLOAT
);