hospital_data

Table actions
Data provided via a collaboration between The Accountability Project and Big Local News. This project provides and joins datasets pertinent to the COVID-19 pandemic: hospital location and number of beds by type, county-level population estimates by age (which can be linked to hospital data) and nursing home location and capacity. See README for additional information.

Data source: Big Local News · About: big-local-datasette

36 rows where "filed_date" is on date 2019-05-29 and hospital_ownership = "Proprietary"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, county_name, emergency_services, geocode_flag, geocode_accuracy, countyfips, statefips, statecountyfips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, fy_end_date, acute_beds, icu_beds, coronary_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_beds, nursing_fac_beds, oth_longterm_beds, filed_date (date), fy_end_date (date)

Link rowid ▼ hospital_name address city state zip_code county_name phone_number hospital_type hospital_ownership emergency_services lat lng geocode_flag geocode_accuracy countyfips statefips statecountyfips cbsacode csatitle centraloutlyingcounty countyequivalent hosp_lookup_url PRVDR_NUM RPT_REC_NUM filed_date fy_end_date acute_beds icu_beds coronary_beds burn_beds surg_icu_beds oth_spec_beds subtotal_acute_beds subprovider_ipf_beds subprovider_irf_beds subprovider_oth_beds skilled_nursing_beds nursing_fac_beds oth_longterm_beds hospice_beds all_beds
75 75 GEORGE WASHINGTON UNIV HOSPITAL 900 23RD ST NW WASHINGTON DC 20037 THE DISTRICT (202) 716-4605 Acute Care Hospitals Proprietary TRUE 38.9011690 -77.0501190 0   1 11 11001 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central District of Columbia https://data.medicare.gov/resource/xubh-q36u/row-y2et_6xjz~rfau 90001 649550 2019-05-29 2018-12-31 255 56         329 20 16           365
189 189 VALLEY HOSPITAL MEDICAL CENTER 620 SHADOW LANE LAS VEGAS NV 89106 CLARK (702) 388-4000 Acute Care Hospitals Proprietary TRUE 36.1639140 -115.1654630 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-h9xh~nrzf.p42d 290021 649464 2019-05-29 2018-12-31 229 20 25       274   16           290
193 193 DESERT SPRINGS HOSPITAL 2075 EAST FLAMINGO ROAD LAS VEGAS NV 89119 CLARK (702) 369-7600 Acute Care Hospitals Proprietary TRUE 36.1145610 -115.1255480 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-h6f4_d5w8_jhfe 290022 649621 2019-05-29 2018-12-31 215 34         249 32 12           293
201 201 HENDERSON HOSPITAL 1050 WEST GALLERIA DRIVE HENDERSON NV 89011 CLARK (318) 290-4395 Acute Care Hospitals Proprietary TRUE 36.0728432 -115.0304734 1 ROOFTOP 3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-duqr_nix9.a8cp 290057 648718 2019-05-29 2018-12-31 120 16         140               140
207 207 SPRING VALLEY HOSPITAL MEDICAL CENTER 5400 SOUTH RAINBOW BLVD LAS VEGAS NV 89118 CLARK (702) 853-3000 Acute Care Hospitals Proprietary TRUE 36.0897140 -115.2428820 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-e224~h6nw_3cd4 290046 649465 2019-05-29 2018-12-31 279 28         337   22           359
208 208 SUMMERLIN HOSPITAL MEDICAL CENTER 657 TOWN CENTER DRIVE LAS VEGAS NV 89144 CLARK (702) 233-7500 Acute Care Hospitals Proprietary TRUE 36.1796380 -115.3157760 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-bs37~asjj.ux8i 290041 649924 2019-05-29 2018-12-31 248 59         370   31           401
242 242 AIKEN REGIONAL MEDICAL CENTER 302 UNIVERSITY PARKWAY AIKEN SC 29801 AIKEN (803) 641-5900 Acute Care Hospitals Proprietary TRUE 33.5698900 -81.7650710 0   3 45 45003 12260   Central Aiken County https://data.medicare.gov/resource/xubh-q36u/row-2jsk_ph6i-gvkj 420082 648759 2019-05-29 2018-12-31 169 35         204 48 14           266
445 445 HOLY FAMILY HOSPITAL 70 EAST STREET METHUEN MA 1844 ESSEX (978) 687-0156 Acute Care Hospitals Proprietary TRUE 42.7258290 -71.1696180 0   9 25 25009 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Essex County https://data.medicare.gov/resource/xubh-q36u/row-ur5a-crja_mqpg 220080 649443 2019-05-29 2018-12-31 301 29         330 17             347
507 507 NORTHERN LIGHT INLAND HOSPITAL 200 KENNEDY MEMORIAL DRIVE WATERVILLE ME 4901 KENNEBEC (207) 861-3000 Acute Care Hospitals Proprietary TRUE 44.5426900 -69.6614050 0   11 23 23011 12300   Central Kennebec County https://data.medicare.gov/resource/xubh-q36u/row-w24b~y2sj-qzhk 200041 650154 2019-05-29 2018-09-30 33           33               33
755 755 NASHOBA VALLEY MEDICAL CENTER 200 GROTON ROAD AYER MA 1432 MIDDLESEX (978) 784-9000 Acute Care Hospitals Proprietary TRUE 42.5764120 -71.5730530 0   17 25 25017 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Middlesex County https://data.medicare.gov/resource/xubh-q36u/row-b3a4~z9ss.qyzg 220098 648835 2019-05-29 2018-12-31 51 6         57 20             77
904 904 NORWOOD HOSPITAL 800 WASHINGTON STREET NORWOOD MA 2062 NORFOLK (781) 769-4000 Acute Care Hospitals Proprietary TRUE 42.1894620 -71.2026400 0   21 25 25021 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Norfolk County https://data.medicare.gov/resource/xubh-q36u/row-fntk_6dnq-g39j 220126 649445 2019-05-29 2018-12-31 139 10         149 61             210
937 937 HOSPITAL HERMANOS MELENDEZ INC CARRETERA #2 KM 11 7 BAYAMON PR 960 BAYAMON (787) 620-8181 Acute Care Hospitals Proprietary TRUE 18.3967595 -66.1625647 1 ROOFTOP 21 72 72021 41980 San Juan-Carolina, PR Central Bayamón Municipio https://data.medicare.gov/resource/xubh-q36u/row-qeay~e2ib.ig5b 400032 649346 2019-05-29 2018-12-31 232 21         253               253
955 955 GOOD SAMARITAN MEDICAL CENTER 235 NORTH PEARL STREET BROCKTON MA 2301 PLYMOUTH (508) 427-3000 Acute Care Hospitals Proprietary TRUE 42.0970700 -71.0656450 0   23 25 25023 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Plymouth County https://data.medicare.gov/resource/xubh-q36u/row-u3jj_w4a9~6ncj 220111 649444 2019-05-29 2018-12-31 231 18         249 16             265
1019 1019 BRONSON BATTLE CREEK HOSPITAL 300 NORTH AVENUE BATTLE CREEK MI 49017 CALHOUN (269) 966-8000 Acute Care Hospitals Proprietary TRUE 42.3306180 -85.1804040 0   25 26 26025 12980 Kalamazoo-Battle Creek-Portage, MI Central Calhoun County https://data.medicare.gov/resource/xubh-q36u/row-he35.kjhz.63u8 230075 649448 2019-05-29 2018-12-31 139 20         159 39             198
1282 1282 NORTHERN NEVADA MEDICAL CENTER 2375 E PRATER WAY SPARKS NV 89434 WASHOE (775) 331-7000 Acute Care Hospitals Proprietary TRUE 39.5424880 -119.6979740 0   31 32 32031 39900 Reno-Carson City-Fernley, NV Central Washoe County https://data.medicare.gov/resource/xubh-q36u/row-tcqv_769x-rt8h 290032 648549 2019-05-29 2018-12-31 60 12         72 28 8           108
1505 1505 PALMDALE REGIONAL MEDICAL CENTER 38600 MEDICAL CENTER DRIVE PALMDALE CA 93552 LOS ANGELES (661) 382-5000 Acute Care Hospitals Proprietary TRUE 34.5856880 -118.1436400 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-fjgq-t4a6-wyvs 50204 649397 2019-05-29 2018-12-31 139 18         157   27           184
1813 1813 ST MARY'S REGIONAL MEDICAL CENTER 305 SOUTH 5TH STREET ENID OK 73701 GARFIELD (580) 233-6100 Acute Care Hospitals Proprietary TRUE 36.3941540 -97.8717770 0   47 40 40047 21420   Central Garfield County https://data.medicare.gov/resource/xubh-q36u/row-nnbv_xunj-qjzg 370026 648974 2019-05-29 2018-12-31 131 11         142   22           164
2010 2010 LAFAYETTE SURGICAL SPECIALTY HOSPITAL 1101 KALISTE SALOOM RD LAFAYETTE LA 70508 LAFAYETTE (337) 769-4100 Acute Care Hospitals Proprietary FALSE 30.1758660 -92.0280200 0   55 22 22055 29180 Lafayette-Opelousas-Morgan City, LA Central Lafayette Parish https://data.medicare.gov/resource/xubh-q36u/row-c5ey.7tgp-2iyz 190259 648929 2019-05-29 2018-12-31 20           20               20
2281 2281 SOUTHWEST HEALTHCARE SYSTEM 25500 MEDICAL CENTER DRIVE MURRIETA CA 92562 RIVERSIDE (951) 696-6000 Acute Care Hospitals Proprietary TRUE 33.5578320 -117.1843460 0   65 6 6065 40140 Los Angeles-Long Beach, CA Central Riverside County https://data.medicare.gov/resource/xubh-q36u/row-y8ub_kf28_uwet 50701 649541 2019-05-29 2018-12-31 215 25         240               240
2283 2283 TEMECULA VALLEY HOSPITAL 31700 TEMECULA PKWY TEMECULA CA 92592 RIVERSIDE (951) 331-2200 Acute Care Hospitals Proprietary TRUE 33.4792900 -117.1057440 0   65 6 6065 40140 Los Angeles-Long Beach, CA Central Riverside County https://data.medicare.gov/resource/xubh-q36u/row-cips.xumr_s2gn 50775 648523 2019-05-29 2018-12-31 120 20         140               140
2292 2292 CORONA REGIONAL MEDICAL CENTER 800 SOUTH MAIN STREET CORONA CA 92882 RIVERSIDE (951) 737-4343 Acute Care Hospitals Proprietary TRUE 33.8733270 -117.5667680 0   65 6 6065 40140 Los Angeles-Long Beach, CA Central Riverside County https://data.medicare.gov/resource/xubh-q36u/row-rvrd-spyz~rv7g 50329 648887 2019-05-29 2018-12-31 138 22         160 38     40       238
2453 2453 TURNING POINT HOSPITAL 3015 VETERANS PARKWAY MOULTRIE GA 31788 COLQUITT (229) 985-4815 Acute Care Hospitals Proprietary FALSE 31.1292470 -83.7735500 0   71 13 13071 34220   Central Colquitt County https://data.medicare.gov/resource/xubh-q36u/row-c7wf~kq6n~bukb 110209 649195 2019-05-29 2018-12-31 33           33 26             59
2576 2576 ALLIANCE HEALTH CENTER 5000 HIGHWAY 39 NORTH MERIDIAN MS 39301 LAUDERDALE (601) 483-6211 Acute Care Hospitals Proprietary FALSE 32.4099880 -88.6788110 0   75 28 28075 32940   Central Lauderdale County https://data.medicare.gov/resource/xubh-q36u/row-u23i_wk6s_4s84 250151 649279 2019-05-29 2018-12-31 83           83 71         60   214
2690 2690 LAKEWOOD RANCH MEDICAL CENTER 8330 LAKEWOOD RANCH BLVD BRADENTON FL 34202 MANATEE (941) 782-2100 Acute Care Hospitals Proprietary TRUE 27.3926710 -82.4347250 0   81 12 12081 35840 North Port-Sarasota, FL Central Manatee County https://data.medicare.gov/resource/xubh-q36u/row-gnvx_3fzb~jrfs 100299 648673 2019-05-29 2018-12-31 100 20         120               120
3075 3075 SPRINGHILL MEMORIAL HOSPITAL 3719 DAUPHIN STREET MOBILE AL 36608 MOBILE (251) 344-9630 Acute Care Hospitals Proprietary TRUE 30.6859460 -88.1317190 0   97 1 1097 33660 Mobile-Daphne-Fairhope, AL Central Mobile County https://data.medicare.gov/resource/xubh-q36u/row-qtdz-mr4h-ggd9 10144 648881 2019-05-29 2018-12-31 178 20         198   11           209
3142 3142 WELLINGTON REGIONAL MEDICAL CENTER LLC 10101 FOREST HILL BLVD WELLINGTON FL 33414 PALM BEACH (561) 798-8500 Acute Care Hospitals Proprietary TRUE 26.6508060 -80.2048580 0   99 12 12099 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Palm Beach County https://data.medicare.gov/resource/xubh-q36u/row-kjz3_xmww~fca7 100275 649424 2019-05-29 2018-12-31 192 16         233               233
3308 3308 MONROE HOSPITAL 4011 S MONROE MEDICAL PARK BLVD BLOOMINGTON IN 47403 MONROE (812) 825-1111 Acute Care Hospitals Proprietary TRUE 39.1212020 -86.5733230 0   105 18 18105 14020 Bloomington-Bedford, IN Central Monroe County https://data.medicare.gov/resource/xubh-q36u/row-vnkg~enat-23r9 150183 649094 2019-05-29 2018-12-31 24 8         32               32
3524 3524 ENGLEWOOD COMMUNITY HOSPITAL 700 MEDICAL BLVD ENGLEWOOD FL 34223 SARASOTA (941) 475-6571 Acute Care Hospitals Proprietary TRUE 26.9490090 -82.3279510 0   115 12 12115 35840 North Port-Sarasota, FL Central Sarasota County https://data.medicare.gov/resource/xubh-q36u/row-tmdw-rkat~dwzw 100267 648802 2019-05-29 2018-12-31 92 8         100               100
3670 3670 LAKE MARTIN COMMUNITY HOSPITAL 201 MARIARDEN ROAD DADEVILLE AL 36853 TALLAPOOSA (256) 825-7821 Acute Care Hospitals Proprietary TRUE 32.8187000 -85.7417580 0   123 1 1123         https://data.medicare.gov/resource/xubh-q36u/row-7irr_xm4w_yyg3 10052 649861 2019-05-29 2018-12-31 46           46               46
3963 3963 TULSA SPINE & SPECIALTY HOSPITAL 6901 SOUTH OLYMPIA AVENUE TULSA OK 74132 TULSA (918) 388-5701 Acute Care Hospitals Proprietary TRUE 36.0637600 -96.0045420 0   143 40 40143 46140 Tulsa-Muskogee-Bartlesville, OK Central Tulsa County https://data.medicare.gov/resource/xubh-q36u/row-jp22~5e9q.iy5s 370216 650605 2019-05-29 2018-12-31 38           38               38
4068 4068 CRYSTAL CLINIC ORTHOPAEDIC CENTER 444 NORTH MAIN STREET AKRON OH 44310 SUMMIT (330) 670-4118 Acute Care Hospitals Proprietary FALSE 41.0970700 -81.5121550 0   153 39 39153 10420 Cleveland-Akron-Canton, OH Central Summit County https://data.medicare.gov/resource/xubh-q36u/row-3zqn-by7u.cdf4 360351 648746 2019-05-29 2018-12-31 59           59               59
4073 4073 HOSPITAL METROPOLITANO DR TITO MATTEI ROAD 128 KM 1.0 YAUCO PR 698 YAUCO (787) 856-1000 Acute Care Hospitals Proprietary TRUE 18.0295606 -66.8571953 1 GEOMETRIC_CENTER 153 72 72153 38660 Ponce-Coamo-Santa Isabel, PR Outlying Yauco Municipio https://data.medicare.gov/resource/xubh-q36u/row-dj5v~4uja-xjvr 400110 650773 2019-05-29 2018-12-31 73 11         84 28             112
4125 4125 WINSTON MEDICAL CENTER & SWINGBED 17550 EAST MAIN STREET LOUISVILLE MS 39339 WINSTON (662) 779-5124 Acute Care Hospitals Proprietary TRUE 33.1242910 -89.0366710 0   159 28 28159         https://data.medicare.gov/resource/xubh-q36u/row-rwwj.hj8g_k82s 250027 649619 2019-05-29 2018-12-31 14           14 10     120       144
4595 4595 SOUTH TEXAS SURGICAL HOSPITAL 6130 PARKWAY DRIVE CORPUS CHRISTI TX 78414 NUECES (361) 993-2000 Acute Care Hospitals Proprietary TRUE 27.6869280 -97.3754370 0   355 48 48355 18580 Corpus Christi-Kingsville-Alice, TX Central Nueces County https://data.medicare.gov/resource/xubh-q36u/row-cbxw_6hav~c9r6 670061 651496 2019-05-29 2018-12-31 33           33               33
4695 4695 KELL WEST REGIONAL HOSPITAL 5402 KELL WEST BOULEVARD WICHITA FALLS TX 76310 WICHITA (940) 692-5888 Acute Care Hospitals Proprietary FALSE 33.8723800 -98.5784190 0   485 48 48485 48660   Central Wichita County https://data.medicare.gov/resource/xubh-q36u/row-gbr7-pkb3-8m59 450827 649502 2019-05-29 2018-12-31 41           41               41
4737 4737 SOUTHAMPTON MEMORIAL HOSPITAL 100 FAIRVIEW DRIVE - PO BOX 817 FRANKLIN VA 23851 FRANKLIN CITY (757) 569-6100 Acute Care Hospitals Proprietary TRUE 36.6911710 -76.9349420 0   620 51 51620         https://data.medicare.gov/resource/xubh-q36u/row-f6hb_is78~t7qx 490092 649152 2019-05-29 2018-12-31 67 8         75       13 116     204

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [hospital_data] (
   [hospital_name] TEXT,
   [address] TEXT,
   [city] TEXT,
   [state] TEXT,
   [zip_code] INTEGER,
   [county_name] TEXT,
   [phone_number] TEXT,
   [hospital_type] TEXT,
   [hospital_ownership] TEXT,
   [emergency_services] TEXT,
   [lat] TEXT,
   [lng] TEXT,
   [geocode_flag] INTEGER,
   [geocode_accuracy] TEXT,
   [countyfips] INTEGER,
   [statefips] INTEGER,
   [statecountyfips] INTEGER,
   [cbsacode] TEXT,
   [csatitle] TEXT,
   [centraloutlyingcounty] TEXT,
   [countyequivalent] TEXT,
   [hosp_lookup_url] TEXT,
   [PRVDR_NUM] INTEGER,
   [RPT_REC_NUM] INTEGER,
   [filed_date] TEXT,
   [fy_end_date] TEXT,
   [acute_beds] INTEGER,
   [icu_beds] TEXT,
   [coronary_beds] TEXT,
   [burn_beds] TEXT,
   [surg_icu_beds] TEXT,
   [oth_spec_beds] TEXT,
   [subtotal_acute_beds] INTEGER,
   [subprovider_ipf_beds] TEXT,
   [subprovider_irf_beds] TEXT,
   [subprovider_oth_beds] TEXT,
   [skilled_nursing_beds] TEXT,
   [nursing_fac_beds] TEXT,
   [oth_longterm_beds] TEXT,
   [hospice_beds] TEXT,
   [all_beds] INTEGER
);