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

43 rows where "filed_date" is on date 2019-06-03 and hospital_ownership = "Proprietary"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, emergency_services, countyfips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, icu_beds, coronary_beds, surg_icu_beds, oth_spec_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_beds, filed_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
168 168 THE ORTHOPAEDIC HOSPITAL OF LUTHERAN HEALTH NETWOR 7952 W JEFFERSON BLVD FORT WAYNE IN 46804 ALLEN (260) 435-2999 Acute Care Hospitals Proprietary FALSE 41.0373520 -85.2459180 0   3 18 18003 23060 Fort Wayne-Huntington-Auburn, IN Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-65sn_hsdz_dbbf 150168 649728 2019-06-03 2018-12-31 39           39               39
221 221 INSTITUTE FOR ORTHOPAEDIC SURGERY 801 MEDICAL DRIVE, SUITE B LIMA OH 45804 ALLEN (419) 224-7586 Acute Care Hospitals Proprietary FALSE 40.6985860 -84.0864770 0   3 39 39003 30620 Lima-Van Wert-Celina, OH Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-kbua_iifb.k5nj 360263 649649 2019-06-03 2018-12-31 12           12               12
394 394 CASTLEVIEW HOSPITAL 300 NORTH HOSPITAL DRIVE PRICE UT 84501 CARBON (435) 637-4800 Acute Care Hospitals Proprietary TRUE 39.6054020 -110.8319110 0   7 49 49007 39220   Central Carbon County https://data.medicare.gov/resource/xubh-q36u/row-z6mk.zxuw_qeet 460011 651250 2019-06-03 2018-12-31 33 6         39               39
456 456 OLEAN GENERAL HOSPITAL 515 MAIN STREET OLEAN NY 14760 CATTARAUGUS (716) 373-2600 Acute Care Hospitals Proprietary TRUE 42.0894480 -78.4269770 0   9 36 36009 36460 Buffalo-Cheektowaga, NY Central Cattaraugus County https://data.medicare.gov/resource/xubh-q36u/row-hkii~eckc~6rgh 330103 650862 2019-06-03 2018-12-31 260           260 14     293       567
575 575 DIGNITY HEALTH - ARIZONA GENERAL HOSPITAL 7171 SOUTH 51ST AVENUE LAVEEN AZ 85339 MARICOPA (623) 584-5100 Acute Care Hospitals Proprietary FALSE 33.3806770 -112.1682330 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-6h9g-s46a~aiyi 30136 651169 2019-06-03 2018-12-31 16           16               16
607 607 BIENVILLE MEDICAL CENTER 1175 PINE STREET ARCADIA LA 71001 BIENVILLE (318) 263-4700 Critical Access Hospitals Proprietary TRUE 32.5530850 -92.9157770 0   13 22 22013         https://data.medicare.gov/resource/xubh-q36u/row-ui8b~9pic.2t2z 191320 650142 2019-06-03 2018-12-31 21           21               21
620 620 GREAT FALLS CLINIC HOSPITAL 3010 15TH AVENUE SOUTH GREAT FALLS MT 59405 CASCADE (406) 216-8000 Acute Care Hospitals Proprietary TRUE 47.4877370 -111.2545610 0   13 30 30013 24500   Central Cascade County https://data.medicare.gov/resource/xubh-q36u/row-zzvw_fvcf~g44t 270086 651217 2019-06-03 2018-12-31 20           20               20
662 662 SAGEWEST HEALTH CARE 2100 W SUNSET DR RIVERTON WY 82501 FREMONT (307) 856-4161 Acute Care Hospitals Proprietary TRUE 43.0336670 -108.4186540 0   13 56 56013 40180   Central Fremont County https://data.medicare.gov/resource/xubh-q36u/row-8cgp~ktku_un2q 530008 652129 2019-06-03 2018-12-31 121 12         133 13 8           154
679 679 BAYFRONT HEALTH PORT CHARLOTTE 2500 HARBOR BLVD PORT CHARLOTTE FL 33952 CHARLOTTE (941) 766-4122 Acute Care Hospitals Proprietary TRUE 26.9898400 -82.0966820 0   15 12 12015 39460 North Port-Sarasota, FL Central Charlotte County https://data.medicare.gov/resource/xubh-q36u/row-hxde-mw35~h46w 100077 649183 2019-06-03 2018-12-31 225 22         254               254
682 682 KANSAS MEDICAL CENTER LLC 1124 WEST 21ST STREET ANDOVER KS 67002 BUTLER (316) 300-4000 Acute Care Hospitals Proprietary TRUE 37.7232400 -97.1464800 0   15 20 20015 48620 Wichita-Arkansas City-Winfield, KS Outlying Butler County https://data.medicare.gov/resource/xubh-q36u/row-nnyh-wp4p~qnyp 170197 649587 2019-06-03 2018-12-31 45 10         55               55
785 785 ROTHMAN ORTHOPAEDIC SPECIALTY HOSPITAL LLC 3300 TILLMAN DRIVE BENSALEM PA 19020 BUCKS (215) 244-7400 Acute Care Hospitals Proprietary FALSE 40.1143500 -74.9620930 0   17 42 42017 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Bucks County https://data.medicare.gov/resource/xubh-q36u/row-w5gs-9pze-8zau 390322 649490 2019-06-03 2018-12-31 24           24               24
989 989 JACKSON MEDICAL CENTER 220 HOSPITAL DRIVE JACKSON AL 36545 CLARKE (251) 246-9021 Acute Care Hospitals Proprietary TRUE 31.5304820 -87.8931800 0   25 1 1025         https://data.medicare.gov/resource/xubh-q36u/row-p276~rdhi_nmej 10128 651157 2019-06-03 2018-12-31 35           35               35
1130 1130 BAKERSFIELD HEART HOSPITAL 3001 SILLECT AVENUE BAKERSFIELD CA 93308 KERN (661) 316-6000 Acute Care Hospitals Proprietary TRUE 35.3861060 -119.0408470 0   29 6 6029 12540   Central Kern County https://data.medicare.gov/resource/xubh-q36u/row-e89i~sm2j_vijv 50724 651182 2019-06-03 2018-12-31 47           47               47
1190 1190 FOUNDATION SURGICAL HOSPITAL OF SAN ANTONIO 9522 HUEBNER ROAD SAN ANTONIO TX 78240 BEXAR (210) 478-5400 Acute Care Hospitals Proprietary TRUE 29.5310350 -98.5925540 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-pvs4~yydr-y7qv 670054 649387 2019-06-03 2018-12-31 20           20               20
1377 1377 EVERGREEN MEDICAL CENTER 101 CRESTVIEW AVENUE EVERGREEN AL 36401 CONECUH (251) 578-2480 Acute Care Hospitals Proprietary TRUE 31.4312600 -86.9420500 0   35 1 1035         https://data.medicare.gov/resource/xubh-q36u/row-f8ut-az4v~dn63 10148 651159 2019-06-03 2018-12-31 44           44               44
1420 1420 UHHS RICHMOND HEIGHTS HOSPITAL 27100 CHARDON ROAD RICHMOND HEIGHTS OH 44143 CUYAHOGA (440) 585-6170 Acute Care Hospitals Proprietary TRUE 41.5810430 -81.4902720 0   35 39 39035 17460 Cleveland-Akron-Canton, OH Central Cuyahoga County https://data.medicare.gov/resource/xubh-q36u/row-rvfd.96ei_5i7w 360075 649315 2019-06-03 2018-12-31 84 17         101               101
1469 1469 PACIFICA HOSPITAL OF THE VALLEY 9449 SAN FERNANDO RD SUN VALLEY CA 91352 LOS ANGELES (818) 767-3310 Acute Care Hospitals Proprietary TRUE 34.2411340 -118.3956690 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-dhg6-n9an_6w25 50378 650948 2019-06-03 2018-12-31 126   7       133       98       231
1472 1472 COLLEGE MEDICAL CENTER 2776 PACIFIC AVENUE LONG BEACH CA 90806 LOS ANGELES (562) 595-1911 Acute Care Hospitals Proprietary TRUE 33.8072010 -118.1937210 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-sybg_fugk_i72x 50776 650806 2019-06-03 2018-12-31 213 8         221               221
1530 1530 OLYMPIA MEDICAL CENTER 5900 WEST OLYMPIC BOULEVARD LOS ANGELES CA 90036 LOS ANGELES (310) 657-5900 Acute Care Hospitals Proprietary FALSE 34.0575270 -118.3598570 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-h6xu_zz9e_g4g4 50742 649703 2019-06-03 2018-12-31 192   12       204               204
1863 1863 WOODS AT PARKSIDE,THE 349 OLDE RIDENOUR ROAD COLUMBUS OH 43230 FRANKLIN (614) 471-2552 Acute Care Hospitals Proprietary FALSE 40.0268200 -82.8811560 0   49 39 39049 18140 Columbus-Marion-Zanesville, OH Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-4avu~kmf5~3quj 360247 649648 2019-06-03 2018-12-31 12         38 50               50
1905 1905 OMEGA HOSPITAL, LLC 2525 SEVERN AVENUE METAIRIE LA 70002 JEFFERSON (504) 849-4900 Acute Care Hospitals Proprietary FALSE 29.9991620 -90.1595830 0   51 22 22051 35380 New Orleans-Metairie-Hammond, LA-MS Central Jefferson Parish https://data.medicare.gov/resource/xubh-q36u/row-fybn~uix6_hmgd 190302 649030 2019-06-03 2018-12-31 16           16               16
1910 1910 SSM HEALTH ST. MARY'S HOSPITAL - JEFFERSON CITY 2505 MISSION DRIVE JEFFERSON CITY MO 65109 COLE (573) 681-3000 Acute Care Hospitals Proprietary TRUE 38.5601420 -92.2202850 0   51 29 29051 27620   Central Cole County https://data.medicare.gov/resource/xubh-q36u/row-gt2e.ahrn_f7q9 260011 649917 2019-06-03 2018-12-31 154 13         167               167
1999 1999 NORTHWEST SPECIALTY HOSPITAL 1593 EAST POLSTON AVENUE POST FALLS ID 83854 KOOTENAI (208) 262-2466 Acute Care Hospitals Proprietary FALSE 47.7144100 -116.9244550 0   55 16 16055 17660 Spokane-Spokane Valley-Coeur d'Alene, WA-ID Central Kootenai County https://data.medicare.gov/resource/xubh-q36u/row-68rq_3jru~i59y 130066 649721 2019-06-03 2018-12-31 34           34               34
2039 2039 SOUTHERN TENNESSEE REGIONAL HEALTH SYSTEM PULASKI 1265 E COLLEGE ST PULASKI TN 38478 GILES (931) 363-7531 Acute Care Hospitals Proprietary TRUE 35.1912900 -87.0043220 0   55 47 47055         https://data.medicare.gov/resource/xubh-q36u/row-5e7x~i85y_dgtz 440020 651233 2019-06-03 2018-12-31 75 6         81 14             95
2123 2123 COLLEGE HOSPITAL COSTA MESA 301 VICTORIA STREET COSTA MESA CA 92627 ORANGE (949) 642-2734 Acute Care Hospitals Proprietary FALSE 33.6526050 -117.9119650 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-3tfg-v7t4-p88q 50543 651370 2019-06-03 2018-12-31 122           122               122
2950 2950 MINIMALLY INVASIVE SURGERY HOSPITAL 11217 LAKEVIEW AVENUE LENEXA KS 66219 JOHNSON (913) 322-7401 Acute Care Hospitals Proprietary FALSE 38.9243760 -94.7697050 0   91 20 20091 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Johnson County https://data.medicare.gov/resource/xubh-q36u/row-jnfx.rz75-i6pf 170199 649588 2019-06-03 2018-12-31 7       2   9               9
2986 2986 NORTHWEST MEDICAL CENTER 1530 U S HIGHWAY 43 WINFIELD AL 35594 FAYETTE (205) 487-7736 Acute Care Hospitals Proprietary TRUE 33.9293160 -87.8245070 0   93 1 1093         https://data.medicare.gov/resource/xubh-q36u/row-r4dk-tpsz_u57n 10086 651153 2019-06-03 2018-12-31 57 4         61 10             71
3044 3044 NORTH MISSISSIPPI MEDICAL CENTER-GILMORE AMORY 1105 EARL FRYE BLVD AMORY MS 38821 MONROE (662) 256-7111 Acute Care Hospitals Proprietary TRUE 33.9775510 -88.4776250 0   95 28 28095         https://data.medicare.gov/resource/xubh-q36u/row-mseb-a3c5-hfq8 250025 649915 2019-06-03 2018-12-31 80 9       6 95               95
3088 3088 ST CLOUD REGIONAL MEDICAL CENTER 2906 17TH STREET SAINT CLOUD FL 34769 OSCEOLA (407) 498-3432 Acute Care Hospitals Proprietary TRUE 28.2424140 -81.3026580 0   97 12 12097 36740 Orlando-Deltona-Daytona Beach, FL Outlying Osceola County https://data.medicare.gov/resource/xubh-q36u/row-we5j.muyn.k764 100302 649887 2019-06-03 2018-12-31 76 8         84               84
3204 3204 TECHE REGIONAL MEDICAL CENTER 1125 MARGUERITE STREET MORGAN CITY LA 70380 ST. MARY (985) 384-2200 Acute Care Hospitals Proprietary TRUE 29.7084710 -91.2001570 0   101 22 22101 34020 Lafayette-Opelousas-Morgan City, LA Central St. Mary Parish https://data.medicare.gov/resource/xubh-q36u/row-niny~u25y.qjmy 190014 650586 2019-06-03 2018-12-31 120 10         130 17 10           157
3222 3222 ST CHRISTOPHER'S HOSPITAL FOR CHILDREN 160 EAST ERIE AVE PHILADELPHIA PA 19134 PHILADELPHIA (215) 427-5000 Childrens Proprietary TRUE 40.0074930 -75.1255350 0   101 42 42101 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Philadelphia County https://data.medicare.gov/resource/xubh-q36u/row-z7p6.dkcr_rdax 393307 650206 2019-06-03 2018-12-31 115 44       29 188               188
3231 3231 HAHNEMANN UNIVERSITY HOSPITAL 230 NORTH BROAD STREET PHILADELPHIA PA 19102 PHILADELPHIA (215) 762-7000 Acute Care Hospitals Proprietary TRUE 39.9573340 -75.1625970 0   101 42 42101 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Philadelphia County https://data.medicare.gov/resource/xubh-q36u/row-vvi6-9wq6-jdxw 390290 649946 2019-06-03 2018-12-31 311 29 14   16 17 387 20             407
3303 3303 ADVENTHEALTH LAKE WALES 410 S 11TH ST LAKE WALES FL 33853 POLK (863) 676-1433 Acute Care Hospitals Proprietary TRUE 27.8965330 -81.5646660 0   105 12 12105 29460   Central Polk County https://data.medicare.gov/resource/xubh-q36u/row-qtf7.zzcz~qpg5 100099 649186 2019-06-03 2018-12-31 85 8         93 38             131
3522 3522 VENICE REGIONAL MEDICAL CENTER - BAYFRONT HEALTH 540 THE RIALTO VENICE FL 34285 SARASOTA (941) 485-7711 Acute Care Hospitals Proprietary TRUE 27.0896830 -82.4444450 0   115 12 12115 35840 North Port-Sarasota, FL Central Sarasota County https://data.medicare.gov/resource/xubh-q36u/row-7d9m~y97s_nqjv 100070 649182 2019-06-03 2018-12-31 197 32         229               229
3678 3678 WEST CARROLL MEMORIAL HOSPITAL 706 ROSS STREET OAK GROVE LA 71263 WEST CARROLL (318) 428-3237 Acute Care Hospitals Proprietary TRUE 32.8678130 -91.3831960 0   123 22 22123         https://data.medicare.gov/resource/xubh-q36u/row-nqc6-kae8-uxge 190081 649437 2019-06-03 2018-12-31 30           30               30
3786 3786 PATIENTS CHOICE MEDICAL CENTER 347 MAGNOLIA DRIVE RALEIGH MS 39153 SMITH (601) 782-9997 Acute Care Hospitals Proprietary FALSE 32.0009980 -89.5206670 0   129 28 28129         https://data.medicare.gov/resource/xubh-q36u/row-xqvg.aa4c-5mrs 250163 650165 2019-06-03 2018-12-31 19           19 10             29
3939 3939 NORTHWEST HEALTH PHYSICIANS SPECIALTY HOSPITAL 3873 NORTH PARKVIEW DRIVE FAYETTEVILLE AR 72703 WASHINGTON (479) 571-7002 Acute Care Hospitals Proprietary TRUE 36.1213300 -94.1337300 0   143 5 5143 22220   Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-dtfa_7iaz.thv8 40152 650236 2019-06-03 2018-12-31 20           20               20
3947 3947 SCOTT MEMORIAL HEALTH 1451 N GARDNER ST SCOTTSBURG IN 47170 SCOTT (812) 752-3456 Critical Access Hospitals Proprietary TRUE 38.7055250 -85.7852000 0   143 18 18143 31140 Louisville/Jefferson County--Elizabethtown--Madison, KY-IN Outlying Scott County https://data.medicare.gov/resource/xubh-q36u/row-w3qq-86eu-wbzv 151334 649730 2019-06-03 2018-12-31 21 4         25               25
4013 4013 STARKE HOSPITAL 102 E CULVER RD KNOX IN 46534 STARKE (574) 772-1102 Acute Care Hospitals Proprietary TRUE 41.2880640 -86.6219370 0   149 18 18149         https://data.medicare.gov/resource/xubh-q36u/row-4bwp-v7bt.62f6 150102 649569 2019-06-03 2018-12-31 14 1         15               15
4086 4086 TRUMBULL REGIONAL MEDICAL CENTER 1350 EAST MARKET STREET WARREN OH 44482 TRUMBULL (330) 841-9820 Acute Care Hospitals Proprietary TRUE 41.2364610 -80.7987650 0   155 39 39155 49660 Youngstown-Warren, OH-PA Central Trumbull County https://data.medicare.gov/resource/xubh-q36u/row-88k8_s9qs~hbxb 360055 649311 2019-06-03 2018-12-31 173 30         203 16             219
4182 4182 JENKINS COUNTY HOSPITAL 931 EAST WINTHROPE AVENUE MILLEN GA 30442 JENKINS (478) 982-4221 Critical Access Hospitals Proprietary TRUE 32.8036780 -81.9340740 0   165 13 13165         https://data.medicare.gov/resource/xubh-q36u/row-wabu-mgcf_ujg3 111311 651201 2019-06-03 2018-12-31 15           15               15
4303 4303 WILSON N JONES REGIONAL MEDICAL CENTER 500 N HIGHLAND AVENUE SHERMAN TX 75091 GRAYSON (903) 870-4611 Acute Care Hospitals Proprietary TRUE 33.6356360 -96.6228510 0   181 48 48181 43300 Dallas-Fort Worth, TX-OK Central Grayson County https://data.medicare.gov/resource/xubh-q36u/row-6xh6~585b.48af 450469 649833 2019-06-03 2018-12-31 204 10         214 12             226
4551 4551 CLEVELAND EMERGENCY HOSPITAL 1017 S TRAVIS AVE CLEVELAND TX 77327 LIBERTY (281) 592-5400 Acute Care Hospitals Proprietary TRUE 30.3294340 -95.0960570 0   291 48 48291 26420 Houston-The Woodlands, TX Outlying Liberty County https://data.medicare.gov/resource/xubh-q36u/row-3yf9_ucey-48hx 670115 650933 2019-06-03 2018-12-31 16           16               16

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
);