hospital_data
Data source: Big Local News · About: big-local-datasette
25 rows where "filed_date" is on date 2019-11-26 and hospital_ownership = "Proprietary"
This data as json, copyable, CSV (advanced)
Suggested facets: city, 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, burn_beds, oth_spec_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
155 | 155 | PALI MOMI MEDICAL CENTER | 98-1079 MOANALUA ROAD | AIEA | HI | 96701 | HONOLULU | (808) 486-6000 | Acute Care Hospitals | Proprietary | TRUE | 21.3839880 | -157.9376750 | 0 | 3 | 15 | 15003 | 46520 | Central | Honolulu County | https://data.medicare.gov/resource/xubh-q36u/row-gvhj-d3a6.ypz3 | 120026 | 659776 | 2019-11-26 | 2019-06-30 | 110 | 8 | 118 | 118 | |||||||||||||
162 | 162 | STRAUB CLINIC AND HOSPITAL | 888 SO KING STREET | HONOLULU | HI | 96813 | HONOLULU | (808) 522-4000 | Acute Care Hospitals | Proprietary | TRUE | 21.3022680 | -157.8509210 | 0 | 3 | 15 | 15003 | 46520 | Central | Honolulu County | https://data.medicare.gov/resource/xubh-q36u/row-j69k-r5cq-9v28 | 120022 | 659775 | 2019-11-26 | 2019-06-30 | 140 | 16 | 3 | 159 | 159 | ||||||||||||
431 | 431 | UNIVERSITY OF KS HLTH SYSTEM GREAT BEND CAMPUS | 514 CLEVELAND STREET | GREAT BEND | KS | 67530 | BARTON | (620) 792-8833 | Acute Care Hospitals | Proprietary | TRUE | 38.3562000 | -98.7916190 | 0 | 9 | 20 | 20009 | 24460 | Central | Barton County | https://data.medicare.gov/resource/xubh-q36u/row-ezt6_4fjw-kpxn | 170191 | 660092 | 2019-11-26 | 2019-06-30 | 29 | 4 | 33 | 33 | |||||||||||||
654 | 654 | METHODIST HOSPITAL SOUTH | 1905 HWY 97 EAST | JOURDANTON | TX | 78026 | ATASCOSA | (830) 769-3515 | Acute Care Hospitals | Proprietary | TRUE | 28.9331124 | -98.5260352 | 1 | ROOFTOP | 13 | 48 | 48013 | 41700 | Outlying | Atascosa County | https://data.medicare.gov/resource/xubh-q36u/row-5vk8_ecmw.2bzr | 450165 | 660714 | 2019-11-26 | 2019-06-30 | 61 | 6 | 67 | 67 | ||||||||||||
665 | 665 | UCHEALTH BROOMFIELD HOSPITAL | 11820 DESTINATION DRIVE | BROOMFIELD | CO | 80021 | JEFFERSON | (303) 460-6000 | Acute Care Hospitals | Proprietary | TRUE | 39.9105000 | -105.0932070 | 0 | 14 | 8 | 8014 | 19740 | Denver-Aurora, CO | Central | Broomfield County | https://data.medicare.gov/resource/xubh-q36u/row-dvb6-rzzd_er2t | 60129 | 661295 | 2019-11-26 | 2019-06-30 | 22 | 22 | 22 | |||||||||||||
887 | 887 | COLISEUM NORTHSIDE HOSPITAL | 400 CHARTER BOULEVARD | MACON | GA | 31210 | BIBB | (478) 757-8200 | Acute Care Hospitals | Proprietary | TRUE | 32.8698610 | -83.6943610 | 0 | 21 | 13 | 13021 | 31420 | Macon-Warner Robins, GA | Central | Bibb County | https://data.medicare.gov/resource/xubh-q36u/row-qnzt.yc4b~gnii | 110201 | 660371 | 2019-11-26 | 2019-06-30 | 75 | 10 | 85 | 85 | ||||||||||||
1179 | 1179 | BAPTIST MEDICAL CENTER | 111 DALLAS STREET | SAN ANTONIO | TX | 78205 | BEXAR | (210) 297-8256 | Acute Care Hospitals | Proprietary | TRUE | 29.4328770 | -98.4927730 | 0 | 29 | 48 | 48029 | 41700 | Central | Bexar County | https://data.medicare.gov/resource/xubh-q36u/row-9jbx_v3az~nwzz | 450058 | 660466 | 2019-11-26 | 2019-06-30 | 1166 | 151 | 1457 | 38 | 72 | 1567 | |||||||||||
1309 | 1309 | HOSPITAL UPR, DR FEDERICO TRILLA | CARR 3 KM 8 3 AVE 65TH INFANTERIA BOX 6021 | CAROLINA | PR | 984 | CAROLINA | (787) 757-1800 | Acute Care Hospitals | Proprietary | FALSE | 18.3808638 | -65.9632825 | 1 | RANGE_INTERPOLATED | 31 | 72 | 72031 | 41980 | San Juan-Carolina, PR | Central | Carolina Municipio | https://data.medicare.gov/resource/xubh-q36u/row-xbn3-25u3~b8g7 | 400112 | 660876 | 2019-11-26 | 2019-06-30 | 210 | 8 | 233 | 233 | |||||||||||
1523 | 1523 | CEDAR-SINAI MARINA DEL REY HOSPITAL | 4650 LINCOLN BLVD | MARINA DEL REY | CA | 90291 | LOS ANGELES | (310) 823-8911 | Acute Care Hospitals | Proprietary | FALSE | 33.9817320 | -118.4401540 | 0 | 37 | 6 | 6037 | 31080 | Los Angeles-Long Beach, CA | Central | Los Angeles County | https://data.medicare.gov/resource/xubh-q36u/row-izeb-yvf9_zc9q | 50740 | 660492 | 2019-11-26 | 2019-06-30 | 91 | 12 | 103 | 103 | ||||||||||||
1561 | 1561 | BERWICK HOSPITAL CENTER | 701 EAST 16TH STREET | BERWICK | PA | 18603 | COLUMBIA | (570) 759-5020 | Acute Care Hospitals | Proprietary | TRUE | 41.0701590 | -76.2308040 | 0 | 37 | 42 | 42037 | 14100 | Bloomsburg-Berwick-Sunbury, PA | Central | Columbia County | https://data.medicare.gov/resource/xubh-q36u/row-cn25-dn3w-iqqf | 390072 | 660695 | 2019-11-26 | 2019-06-30 | 77 | 10 | 87 | 14 | 240 | 341 | ||||||||||
1785 | 1785 | GARDEN PARK MEDICAL CENTER | 15200 COMMUNITY ROAD | GULFPORT | MS | 39503 | HARRISON | (228) 575-7000 | Acute Care Hospitals | Proprietary | TRUE | 30.4420100 | -89.0927660 | 0 | 47 | 28 | 28047 | 25060 | Central | Harrison County | https://data.medicare.gov/resource/xubh-q36u/row-mqi3~42hr_6pv9 | 250123 | 660823 | 2019-11-26 | 2018-12-31 | 87 | 13 | 100 | 21 | 121 | ||||||||||||
1857 | 1857 | MOUNT CARMEL NEW ALBANY SURGICAL HOSPITAL | 7333 SMITH'S MILL ROAD | NEW ALBANY | OH | 43054 | FRANKLIN | (614) 775-6600 | Acute Care Hospitals | Proprietary | FALSE | 40.0863030 | -82.7887930 | 0 | 49 | 39 | 39049 | 18140 | Columbus-Marion-Zanesville, OH | Central | Franklin County | https://data.medicare.gov/resource/xubh-q36u/row-ywvf~p2gq~kk8u | 360266 | 660674 | 2019-11-26 | 2019-06-30 | 60 | 60 | 60 | |||||||||||||
2128 | 2128 | MEMORIALCARE ORANGE COAST MEDICAL CENTER | 9920 TALBERT AVENUE | FOUNTAIN VALLEY | CA | 92708 | ORANGE | (714) 378-7406 | Acute Care Hospitals | Proprietary | TRUE | 33.7016590 | -117.9561070 | 0 | 59 | 6 | 6059 | 31080 | Los Angeles-Long Beach, CA | Central | Orange County | https://data.medicare.gov/resource/xubh-q36u/row-pc9c.ve2t.j5x8 | 50678 | 662101 | 2019-11-26 | 2019-06-30 | 185 | 21 | 12 | 218 | 218 | |||||||||||
2131 | 2131 | ORTHOCOLORADO HOSPITAL AT ST ANTHONY MED CAMPUS | 11650 WEST 2ND PLACE | LAKEWOOD | CO | 80228 | JEFFERSON | (720) 321-5000 | Acute Care Hospitals | Proprietary | TRUE | 39.7179520 | -105.1284410 | 0 | 59 | 8 | 8059 | 19740 | Denver-Aurora, CO | Central | Jefferson County | https://data.medicare.gov/resource/xubh-q36u/row-b3pw~3vk6_q65v | 60124 | 659765 | 2019-11-26 | 2019-06-30 | 48 | 48 | 48 | |||||||||||||
2351 | 2351 | BOB WILSON MEMORIAL GRANT COUNTY HOSPITAL | 415 N MAIN STREET | ULYSSES | KS | 67880 | GRANT | (620) 356-1266 | Acute Care Hospitals | Proprietary | TRUE | 37.5839920 | -101.3580130 | 0 | 67 | 20 | 20067 | https://data.medicare.gov/resource/xubh-q36u/row-8mti_jcxr_myzi | 170110 | 660091 | 2019-11-26 | 2019-06-30 | 26 | 26 | 26 | |||||||||||||||||
2413 | 2413 | MOSES TAYLOR HOSPITAL | 700 QUINCY AVENUE | SCRANTON | PA | 18510 | LACKAWANNA | (570) 340-2100 | Acute Care Hospitals | Proprietary | TRUE | 41.4106750 | -75.6508140 | 0 | 69 | 42 | 42069 | 42540 | Central | Lackawanna County | https://data.medicare.gov/resource/xubh-q36u/row-tst5_pes9_4qs5 | 390119 | 660859 | 2019-11-26 | 2019-06-30 | 135 | 11 | 161 | 22 | 183 | ||||||||||||
2414 | 2414 | REGIONAL HOSPITAL OF SCRANTON | 746 JEFFERSON AVENUE | SCRANTON | PA | 18501 | LACKAWANNA | (570) 348-7100 | Acute Care Hospitals | Proprietary | TRUE | 41.4128270 | -75.6540710 | 0 | 69 | 42 | 42069 | 42540 | Central | Lackawanna County | https://data.medicare.gov/resource/xubh-q36u/row-mbuk.tbtv~6dq9 | 390237 | 661099 | 2019-11-26 | 2019-06-30 | 130 | 24 | 154 | 154 | |||||||||||||
3389 | 3389 | ALLIANCEHEALTH MIDWEST | 2825 PARKLAWN DRIVE | MIDWEST CITY | OK | 73110 | OKLAHOMA | (405) 610-8585 | Acute Care Hospitals | Proprietary | TRUE | 35.4665270 | -97.3929250 | 0 | 109 | 40 | 40109 | 36420 | Oklahoma City-Shawnee, OK | Central | Oklahoma County | https://data.medicare.gov/resource/xubh-q36u/row-sxg9_cifn-7qv9 | 370094 | 660692 | 2019-11-26 | 2019-06-30 | 212 | 24 | 236 | 19 | 255 | |||||||||||
3819 | 3819 | TYLER MEMORIAL HOSPITAL | 5950 STATE ROUTE 6 WEST | TUNKHANNOCK | PA | 18657 | WYOMING | (570) 836-2161 | Acute Care Hospitals | Proprietary | TRUE | 41.5766510 | -75.9698250 | 0 | 131 | 42 | 42131 | 42540 | Outlying | Wyoming County | https://data.medicare.gov/resource/xubh-q36u/row-h68k-9niq.fgct | 390192 | 659877 | 2019-11-26 | 2019-06-30 | 38 | 6 | 44 | 44 | |||||||||||||
3886 | 3886 | MEDICAL CENTER OF SOUTH ARKANSAS | 700 WEST GROVE STREET | EL DORADO | AR | 71730 | UNION | (870) 863-2000 | Acute Care Hospitals | Proprietary | TRUE | 33.2183780 | -92.6710300 | 0 | 139 | 5 | 5139 | 20980 | Central | Union County | https://data.medicare.gov/resource/xubh-q36u/row-rite-ah8v_bzij | 40088 | 659753 | 2019-11-26 | 2019-06-30 | 95 | 16 | 111 | 20 | 131 | ||||||||||||
3957 | 3957 | HILLCREST MEDICAL CENTER | 1120 SOUTH UTICA AVENUE | TULSA | OK | 74104 | TULSA | (918) 579-1000 | Acute Care Hospitals | Proprietary | TRUE | 36.1471640 | -95.9671410 | 0 | 143 | 40 | 40143 | 46140 | Tulsa-Muskogee-Bartlesville, OK | Central | Tulsa County | https://data.medicare.gov/resource/xubh-q36u/row-u9va-2kpb~97hh | 370001 | 660845 | 2019-11-26 | 2019-06-30 | 319 | 30 | 44 | 13 | 42 | 448 | 32 | 480 | ||||||||
4020 | 4020 | MERIT HEALTH RIVER REGION | 2100 HWY 61 N | VICKSBURG | MS | 39183 | WARREN | (601) 883-5000 | Acute Care Hospitals | Proprietary | TRUE | 32.3748020 | -90.8274970 | 0 | 149 | 28 | 28149 | 46980 | Jackson-Vicksburg-Brookhaven, MS | Central | Warren County | https://data.medicare.gov/resource/xubh-q36u/row-ad3b-7igw_vnnn | 250031 | 660109 | 2019-11-26 | 2019-06-30 | 279 | 22 | 301 | 20 | 321 | |||||||||||
4078 | 4078 | HUTCHINSON REGIONAL MEDICAL CENTER INC | 1701 E 23RD AVENUE | HUTCHINSON | KS | 67502 | RENO | (620) 665-2001 | Acute Care Hospitals | Proprietary | TRUE | 38.0794850 | -97.8922750 | 0 | 155 | 20 | 20155 | 26740 | Central | Reno County | https://data.medicare.gov/resource/xubh-q36u/row-pvdz.9ewv~qj4w | 170020 | 660089 | 2019-11-26 | 2019-06-30 | 109 | 18 | 127 | 14 | 11 | 152 | |||||||||||
4490 | 4490 | CHRISTUS MOTHER FRANCES HOSPITAL SULPHUR SPRINGS | 115 AIRPORT RD | SULPHUR SPRINGS | TX | 75482 | HOPKINS | (903) 885-7671 | Acute Care Hospitals | Proprietary | TRUE | 33.1562200 | -95.5996480 | 0 | 223 | 48 | 48223 | 44860 | Dallas-Fort Worth, TX-OK | Central | Hopkins County | https://data.medicare.gov/resource/xubh-q36u/row-k5xf.mj66.grqz | 450236 | 660051 | 2019-11-26 | 2019-06-30 | 42 | 14 | 56 | 6 | 62 | |||||||||||
4540 | 4540 | PARIS REGIONAL MEDICAL CENTER | 820 CLARKSVILLE ST | PARIS | TX | 75460 | LAMAR | (903) 785-4521 | Acute Care Hospitals | Proprietary | TRUE | 33.6603900 | -95.5474780 | 0 | 277 | 48 | 48277 | 37580 | Central | Lamar County | https://data.medicare.gov/resource/xubh-q36u/row-n8ke~e8ak.enhb | 450196 | 660886 | 2019-11-26 | 2019-06-30 | 210 | 20 | 230 | 23 | 253 |
Advanced export
JSON shape: default, array, newline-delimited
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 );