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

66 rows where geocode_accuracy = "GEOMETRIC_CENTER"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, hospital_type, hospital_ownership, emergency_services, statefips, cbsacode, csatitle, centraloutlyingcounty, fy_end_date, icu_beds, coronary_beds, burn_beds, surg_icu_beds, oth_spec_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_beds, oth_longterm_beds, filed_date (date), fy_end_date (date)

geocode_accuracy ✖

  • GEOMETRIC_CENTER · 66 ✖
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
38 38 FORT DEFIANCE INDIAN HOSPITAL PO BOX 649 FORT DEFIANCE AZ 86504 APACHE (928) 729-8000 Acute Care Hospitals Government - Federal TRUE 35.7593170 -109.0483992 1 GEOMETRIC_CENTER 1 4 4001         https://data.medicare.gov/resource/xubh-q36u/row-ss8d_atq6.7xb3 30071 651311 2019-07-02 2018-09-30 56           56               56
40 40 CHINLE COMPREHENSIVE HEALTH CARE FACILITY US HWY 191, HOSPITAL ROAD CHINLE AZ 86503 APACHE (928) 674-7001 Acute Care Hospitals Government - Federal TRUE 36.1575812 -109.6076963 1 GEOMETRIC_CENTER 1 4 4001         https://data.medicare.gov/resource/xubh-q36u/row-u7kj_iqgg.38d9 30084 649393 2019-06-12 2018-09-30 60           60               60
142 142 BRISTOL HOSPITAL BREWSTER RD BRISTOL CT 6010 HARTFORD (860) 585-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.6758208 -72.9314067 1 GEOMETRIC_CENTER 3 9 9003 25540 Hartford-West Hartford, CT Central Hartford County https://data.medicare.gov/resource/xubh-q36u/row-v2rh-5xe4~wrhu 70029 645749 2019-03-25 2018-09-30 92 14         106 15             121
236 236 UPMC CHILDREN'S HOSPITAL OF PITTSBURGH ONE CHILDREN'S HOSPITAL DRIVE PITTSBURGH PA 15224 ALLEGHENY (412) 692-5325 Childrens Voluntary non-profit - Other TRUE 40.4664773 -79.9522935 1 GEOMETRIC_CENTER 3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-ifxe~erpm.ccc7 393302 659888 2019-11-21 2019-06-30 212 36 12       315               315
334 334 HOSP COMUNITARIO BUEN SAMARITANO CARR.2 KM.1.4 AVE. SEVERIANO CUEVAS #18 AGUADILLA PR 603 AGUADILLA (787) 658-0000 Acute Care Hospitals Voluntary non-profit - Other TRUE 18.4257212 -67.1508997 1 GEOMETRIC_CENTER 5 72 72005 10380   Central Aguadilla Municipio https://data.medicare.gov/resource/xubh-q36u/row-8tsm_vegi.8z9v 400079 649495 2019-06-03 2018-12-31 116 8         124               124
362 362 RED LAKE HOSPITAL A PO BOX 497 REDLAKE MN 56671 BELTRAMI (218) 679-3912 Acute Care Hospitals Government - Federal FALSE 47.8763460 -95.0169401 1 GEOMETRIC_CENTER 7 27 27007 13420   Central Beltrami County https://data.medicare.gov/resource/xubh-q36u/row-jefe.tmy8.7dit 240206 649909 2019-06-18 2018-09-30 23           23               23
475 475 MENNONITE GENERAL HOSPITAL INC CALLE JOSE C VASQUEZ BO. CAONILLAS AIBONITO PR 705 AIBONITO (787) 535-1001 Acute Care Hospitals Voluntary non-profit - Private TRUE 18.1437170 -66.2628471 1 GEOMETRIC_CENTER 9 72 72009 41980 San Juan-Carolina, PR Central Aibonito Municipio https://data.medicare.gov/resource/xubh-q36u/row-bj3m-c3jd~qtix 400018 658954 2019-11-05 2019-03-31 144 6         150               150
477 477 GUAM MEMORIAL HOSPITAL AUTHORITY 85O GOV CARLOS G CAMACHO ROAD TAMUNING GU 96913 GUAM (671) 647-2552 Acute Care Hospitals Government - Local TRUE 13.5008229 144.7755910 1 GEOMETRIC_CENTER 10 66 66010         https://data.medicare.gov/resource/xubh-q36u/row-4hjs.vy3n_hawy 650001 644079 2019-02-28 2018-09-30 147 14         161       40       201
724 724 HOPI HEALTH CARE CENTER HIGHWAY 264, MILEPOST 388 POLACCA AZ 86042 NAVAJO (928) 737-6000 Critical Access Hospitals Tribal FALSE 35.8022226 -110.4260281 1 GEOMETRIC_CENTER 17 4 4017 43320   Central Navajo County https://data.medicare.gov/resource/xubh-q36u/row-6zw9_3xdm~7vqp 31305 646377 2019-03-28 2018-09-30 6           6               6
788 788 ST MARY MEDICAL CENTER LANGHORNE-NEWTOWN RD LANGHORNE PA 19047 BUCKS (215) 750-2003 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.1851512 -74.9214068 1 GEOMETRIC_CENTER 17 42 42017 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Bucks County https://data.medicare.gov/resource/xubh-q36u/row-hzv4-x5tc.gbxp 390258 662138 2019-12-02 2019-06-30 301 41       6 348               348
800 800 SELLS HOSPITAL HIGHWAY 86, AT TOPAWA ROAD SELLS AZ 85634 PIMA (520) 362-7003 Acute Care Hospitals Tribal TRUE 31.9183549 -111.8792747 1 GEOMETRIC_CENTER 19 4 4019 46060 Tucson-Nogales, AZ Central Pima County https://data.medicare.gov/resource/xubh-q36u/row-57e8_mqp9-5x9d 30074 651599 2019-07-10 2018-09-30 14           14               14
900 900 CHARLES A DEAN MEMORIAL HOSPITAL PO BOX 1129 GREENVILLE ME 4441 PISCATAQUIS (207) 695-5200 Critical Access Hospitals Voluntary non-profit - Private FALSE 45.4594923 -69.5906060 1 GEOMETRIC_CENTER 21 23 23021         https://data.medicare.gov/resource/xubh-q36u/row-e23p-cjiz~ui3t 201301 650155 2019-06-21 2018-09-30 25           25               25
983 983 CENTRAL VERMONT MEDICAL CENTER BOX 547 BARRE VT 5641 WASHINGTON (802) 371-4100 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.1969972 -72.5019392 1 GEOMETRIC_CENTER 23 50 50023 12740   Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-q5w8.7vxg_es2c 470001 643309 2019-02-22 2018-09-30 62 14         76               76
1056 1056 HOSPITAL MENONITA CAGUAS INC CARR 172 EXIT 21 URB TURABO GARDENS CAGUAS PR 725 CAGUAS (787) 744-3141 Acute Care Hospitals Voluntary non-profit - Private TRUE 18.2199893 -66.0490741 1 GEOMETRIC_CENTER 25 72 72025 41980 San Juan-Carolina, PR Central Caguas Municipio https://data.medicare.gov/resource/xubh-q36u/row-j2pr-gczt~4uze 400104 658956 2019-11-05 2019-03-31 207 18         225               225
1057 1057 HIMA SAN PABLO-CAGUAS AVE LUIS MUNOZ MARIN CAGUAS PR 725 CAGUAS (787) 653-3434 Acute Care Hospitals Proprietary TRUE 18.2270107 -66.0273180 1 GEOMETRIC_CENTER 25 72 72025 41980 San Juan-Carolina, PR Central Caguas Municipio https://data.medicare.gov/resource/xubh-q36u/row-7siz.yb89_3gij 400120 649347 2019-05-31 2018-12-31 394 46         440               440
1221 1221 LARABIDA CHILDRENS HOSPITAL I E 65TH ST AT LAKE MICHIGAN CHICAGO IL 60649 COOK (773) 363-6700 Childrens Voluntary non-profit - Private FALSE 41.7768110 -87.6015927 1 GEOMETRIC_CENTER 31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-cnjg.zfnx-s5dn 143301 659950 2019-11-25 2019-06-30 49           49               49
1291 1291 CROWNPOINT HEALTHCARE FACILITY JUNCTION OF HWY 371 CROWNPOINT NM 87313 MCKINLEY (505) 786-5291 Acute Care Hospitals Government - Federal TRUE 35.6987639 -108.1396562 1 GEOMETRIC_CENTER 31 35 35031 23700   Central McKinley County https://data.medicare.gov/resource/xubh-q36u/row-fk7d.f3eh~sfri 320062 647264 2019-05-08 2018-09-30 19           19               19
1292 1292 ZUNI COMPREHENSIVE COMMUNITY HEALTH CENTER ROUTE 301 NORTH B STREET ZUNI NM 87327 MCKINLEY (505) 782-4431 Acute Care Hospitals Government - Federal TRUE 35.0785445 -108.8119284 1 GEOMETRIC_CENTER 31 35 35031 23700   Central McKinley County https://data.medicare.gov/resource/xubh-q36u/row-bm92~a2re_rnct 320060 647300 2019-05-08 2018-09-30 27           27               27
1322 1322 COMANCHE COUNTY HOSPITAL 2ND & FRISCO STREET COLDWATER KS 67029 COMANCHE (620) 582-2144 Critical Access Hospitals Government - Local TRUE 37.2679460 -99.3321152 1 GEOMETRIC_CENTER 33 20 20033         https://data.medicare.gov/resource/xubh-q36u/row-uexi-7hwn_3fpb 171312 648915 2019-05-29 2018-12-31 12           12               12
1358 1358 OVERLAKE HOSPITAL MEDICAL CENTER 1035-116TH AVE NE BELLEVUE WA 98004 KING (425) 688-5000 Acute Care Hospitals Voluntary non-profit - Other TRUE 47.6208736 -122.1868731 1 GEOMETRIC_CENTER 33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-rzza-8dw4_494p 500051 658006 2019-01-09 2018-06-30 237 32         286 14             300
1640 1640 Evans ACH (FT Carson) Fort Carson MEDDAC 1650 Cochrane Circle Fort Carson Fort Carson CO 80913 EL PASO (719) 526-7000 Acute Care - Department of Defense Department of Defense TRUE 38.7164981 -104.7934123 1 GEOMETRIC_CENTER 41 8 8041 17820   Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-g44u.mbxs_jpjt                                      
1669 1669 PHS INDIAN HOSPITAL AT EAGLE BUTTE 24276 166TH AIRPORT ROAD EAGLE BUTTE SD 57625 DEWEY (605) 964-3005 Acute Care Hospitals Government - Federal TRUE 44.9935681 -101.2421234 1 GEOMETRIC_CENTER 41 46 46041         https://data.medicare.gov/resource/xubh-q36u/row-5fj3.qevg-rb9t 430083 650906 2019-06-24 2018-09-30 8           8               8
1745 1745 NORTHERN NAVAJO MEDICAL CENTER US HWY 491 NORTH SHIPROCK NM 87420 SAN JUAN (505) 368-6001 Acute Care Hospitals Government - Federal TRUE 36.8052353 -108.6914076 1 GEOMETRIC_CENTER 45 35 35045 22140   Central San Juan County https://data.medicare.gov/resource/xubh-q36u/row-92dv_6fd6_m5cs 320059 651387 2019-06-18 2018-09-30 60           60               60
1840 1840 HURLEY MEDICAL CENTER ONE HURLEY PLAZA FLINT MI 48503 GENESEE (810) 257-9000 Acute Care Hospitals Voluntary non-profit - Other TRUE 43.0212629 -83.7046814 1 GEOMETRIC_CENTER 49 26 26049 22420 Detroit-Warren-Ann Arbor, MI Central Genesee County https://data.medicare.gov/resource/xubh-q36u/row-kud9-8wsb.pvu8 230132 661010 2019-11-27 2019-06-30 256 46 13 11   44 370 35 13           418
1885 1885 YUKON KUSKOKWIM DELTA REG HOSPITAL PO BOX 287 BETHEL AK 99559 BETHEL (907) 543-6300 Acute Care Hospitals Tribal TRUE 60.7922222 -161.7558334 1 GEOMETRIC_CENTER 50 2 2050         https://data.medicare.gov/resource/xubh-q36u/row-7gdx-n37w_5vx9 20018 651309 2019-07-02 2018-09-30 34           34               34
1897 1897 FAYETTE COUNTY HOSPITAL 7TH AND TAYLOR VANDALIA IL 62471 FAYETTE (618) 283-1231 Critical Access Hospitals Voluntary non-profit - Other TRUE 38.9706410 -89.0988780 1 GEOMETRIC_CENTER 51 17 17051         https://data.medicare.gov/resource/xubh-q36u/row-3m36-npvv-f9tn 141346 648907 2019-05-30 2018-12-31 25 4         29       85       114
1976 1976 SETON HIGHLAND LAKES HIGHWAY 281 SOUTH BURNET TX 78611 BURNET (512) 715-3000 Critical Access Hospitals Voluntary non-profit - Private TRUE 30.7113209 -98.2467221 1 GEOMETRIC_CENTER 53 48 48053         https://data.medicare.gov/resource/xubh-q36u/row-khw5~6jgp-v7pk 451365 659615 2019-11-25 2019-06-30 21 4         25               25
2097 2097 HOSPITAL MENONITA GUAYAMA AVE. PEDRO ALBIZU CAMPOS URB. LA HACIENDA GUAYAMA PR 785 GUAYANILLA (787) 864-4300 Acute Care Hospitals Voluntary non-profit - Church TRUE 17.9739992 -66.1065029 1 GEOMETRIC_CENTER 57 72 72057 25020 San Juan-Carolina, PR Central Guayama Municipio https://data.medicare.gov/resource/xubh-q36u/row-by64~txfx~5j23 400048 653990 2019-09-03 2019-03-31 110 6         116               116
2140 2140 LASALLE GENERAL HOSPITAL 187 NINTH ST/HWY 84 WEST JENA LA 71342 LASALLE (318) 992-9200 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.6831927 -92.1337360 1 GEOMETRIC_CENTER 59 22 22059         https://data.medicare.gov/resource/xubh-q36u/row-dbin~f8yn~yhkn 190145 644279 2019-03-01 2018-09-30 30           30 16             46
2155 2155 MOUNT SINAI SOUTH NASSAU ONE HEALTHY WAY OCEANSIDE NY 11572 NASSAU (516) 632-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.6528352 -73.6305705 1 GEOMETRIC_CENTER 59 36 36059 35620 New York-Newark, NY-NJ-CT-PA Central Nassau County https://data.medicare.gov/resource/xubh-q36u/row-c4kg.jzxx-isay 330198 650310 2019-05-30 2018-12-31 323 10 12     6 351 36     20       407
2236 2236 WEST VIRGINIA UNIVERSITY HOSPITALS MEDICAL CENTER DRIVE MORGANTOWN WV 26506 MONONGALIA (304) 598-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.6521441 -79.9551166 1 GEOMETRIC_CENTER 61 54 54061 34060 Morgantown-Fairmont, WV Central Monongalia County https://data.medicare.gov/resource/xubh-q36u/row-umwj-i8uz~xpv6 510001 649689 2019-05-28 2018-12-31 473 65 28       605 47             652
2237 2237 PROFESSIONAL HOSPITAL GUAYNABO INC AVE LAS CUMBRES ST 199KM 1 2 ALT DE SANTA PR 969 GUAYNABO (787) 708-6560 Acute Care Hospitals Proprietary TRUE 18.3582970 -66.0726073 1 GEOMETRIC_CENTER 61 72 72061 41980 San Juan-Carolina, PR Central Guaynabo Municipio https://data.medicare.gov/resource/xubh-q36u/row-fwuh~bawf.93i3 400122 662581 2019-12-23 2019-06-30 49           49               49
2365 2365 NORTH CAROLINA BAPTIST HOSPITAL MEDICAL CENTER BOULEVARD WINSTON-SALEM NC 27157 FORSYTH (336) 716-2011 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.0896734 -80.2713468 1 GEOMETRIC_CENTER 67 37 37067 49180 Greensboro--Winston-Salem--High Point, NC Central Forsyth County https://data.medicare.gov/resource/xubh-q36u/row-r4e3-jftf~8jdf 340047 661763 2019-12-02 2019-06-30 565 110 22 16     797 34 39           870
2370 2370 JEFFERSON COUNTY HOSPITAL INTERSECTION HYWS 81 & 70 WAURIKA OK 73573 JEFFERSON (580) 228-2344 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.1572807 -97.9795416 1 GEOMETRIC_CENTER 67 40 40067         https://data.medicare.gov/resource/xubh-q36u/row-ph4g-iebq.bzzs 371311 662416 2019-12-02 2019-06-30 25           25               25
2397 2397 HARDIN COUNTY GENERAL HOSPITAL FERRELL ROAD ROSICLARE IL 62982 HARDIN (618) 285-6634 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.4103431 -88.3558252 1 GEOMETRIC_CENTER 69 17 17069         https://data.medicare.gov/resource/xubh-q36u/row-p9aq.m5aa.6pkb 141328 653315 2019-08-29 2019-03-31 25           25               25
2424 2424 KANAKANAK HOSPITAL P O BOX 130 DILLINGHAM AK 99576 DILLINGHAM (907) 842-5201 Critical Access Hospitals Voluntary non-profit - Private TRUE 59.0397222 -158.4575000 1 GEOMETRIC_CENTER 70 2 2070         https://data.medicare.gov/resource/xubh-q36u/row-j4d4-bz29~h79d 21309 646376 2019-03-28 2018-09-30 18           18               18
2584 2584 CHILDRESS REGIONAL MEDICAL CENTER HWY 83 NORTH CHILDRESS TX 79201 CHILDRESS (940) 937-6371 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.4304911 -100.2265235 1 GEOMETRIC_CENTER 75 48 48075         https://data.medicare.gov/resource/xubh-q36u/row-vkgv.sxvw_zc6g 450369 646306 2019-03-08 2018-09-30 39           39               39
2628 2628 AVERA DE SMET MEMORIAL HOSPITAL - CAH 306 PRAIRIE AVENUE SW POST OFFICE BOX 160 DE SMET SD 57231 KINGSBURY (605) 854-3329 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.3860427 -97.5611172 1 GEOMETRIC_CENTER 77 46 46077         https://data.medicare.gov/resource/xubh-q36u/row-q65a~ny3z~nsyr 431332 662255 2019-11-27 2019-06-30 6           6               6
2698 2698 SATANTA DISTRICT HOSPITAL CHEYENNE & APACHE SATANTA KS 67870 HASKELL (620) 649-2761 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.4374237 -100.9856235 1 GEOMETRIC_CENTER 81 20 20081         https://data.medicare.gov/resource/xubh-q36u/row-5zm3-qnsy-hby4 171324 648917 2019-05-28 2018-12-31 13           13           44   57
2731 2731 HOSPITAL GENERAL DE CASTANER CARR 135 KM 64 2 CASTANER PR 631 LARES (787) 829-5010 Acute Care Hospitals Voluntary non-profit - Private TRUE 18.1810502 -66.8331137 1 GEOMETRIC_CENTER 81 72 72081 10380   Central Lares Municipio https://data.medicare.gov/resource/xubh-q36u/row-vfcv~b9rk-xwf7 400010 647686 2019-03-05 2018-09-30                              
2960 2960 MERCY ST FRANCIS HOSPITAL 100 WEST HIGHWAY 60, PO BOX 82 MOUNTAIN VIEW MO 65548 HOWELL (417) 934-7000 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.0026442 -91.7032057 1 GEOMETRIC_CENTER 91 29 29091 48460   Central Howell County https://data.medicare.gov/resource/xubh-q36u/row-qxd9-2nsp_4gfe 261335 660407 2019-11-27 2019-06-30 25           25               25
2983 2983 DOCTORS' CENTER HOSPITAL, INC MARGINAL CARRETERA NO 2, KM 47 7 MANATI PR 674 MANATI (787) 853-3322 Acute Care Hospitals Proprietary TRUE 18.4344971 -66.4738542 1 GEOMETRIC_CENTER 91 72 72091 41980 San Juan-Carolina, PR Central Manatí Municipio https://data.medicare.gov/resource/xubh-q36u/row-gyis.f2r7_nau5 400118 650775 2019-05-31 2018-12-31 254 8         262               262
2984 2984 MANATI MEDICAL CENTER DR OTERO LOPEZ CALLE HERNANDEZ CARRION URB ATENAS MANATI PR 674 MANATI (787) 621-3700 Acute Care Hospitals Proprietary TRUE 18.4346023 -66.4823714 1 GEOMETRIC_CENTER 91 72 72091 41980 San Juan-Carolina, PR Central Manatí Municipio https://data.medicare.gov/resource/xubh-q36u/row-bgg8-aaue_zyh9 400114 649496 2019-05-28 2018-12-31 231 20         251               251
3129 3129 BELLA VISTA HOSPITAL CARR 349 KM 2 7 CERRO LAS MESAS MAYAGUEZ PR 681 MAYAGUEZ (787) 652-6045 Acute Care Hospitals Voluntary non-profit - Church TRUE 18.1868275 -67.1192192 1 GEOMETRIC_CENTER 97 72 72097 32420 Mayagüez-San Germán, PR Central Mayagüez Municipio https://data.medicare.gov/resource/xubh-q36u/row-3qj8-u7h6~eihq 400014 650360 2019-06-03 2018-12-31 149 9         158   25           183
3130 3130 MAYAGUEZ MEDICAL CENTER DR RAMON EMETERIO BETANCES CARR 2 BO SABALOS MAYAGUEZ PR 682 MAYAGUEZ (787) 652-9200 Acute Care Hospitals Proprietary TRUE 18.1764606 -67.1512480 1 GEOMETRIC_CENTER 97 72 72097 32420 Mayagüez-San Germán, PR Central Mayagüez Municipio https://data.medicare.gov/resource/xubh-q36u/row-gthf.kgy6-stvn 400103 648571 2019-05-28 2018-12-31 161 31         192               192
3131 3131 HOSPITAL PEREA 15 DR BASORA STREET MAYAGUEZ PR 681 MAYAGUEZ (787) 834-0101 Acute Care Hospitals Proprietary TRUE 18.2028218 -67.1398281 1 GEOMETRIC_CENTER 97 72 72097 32420 Mayagüez-San Germán, PR Central Mayagüez Municipio https://data.medicare.gov/resource/xubh-q36u/row-gmvm-vs4t~timp 400123 649348 2019-05-28 2018-12-31 106 4       8 118               118
3184 3184 SOUTHERN TENNESSEE REGIONAL HEALTH SYSTEM LAWRENCE HWY 43 S BOX 847 LAWRENCEBURG TN 38464 LAWRENCE (931) 762-6571 Acute Care Hospitals Voluntary non-profit - Other TRUE 35.1400446 -87.3699788 1 GEOMETRIC_CENTER 99 47 47099 29980 Nashville-Davidson--Murfreesboro, TN Central Lawrence County https://data.medicare.gov/resource/xubh-q36u/row-ghnd-6g8c~yazk 440175 647058 2019-04-29 2018-11-30 83 6         89   10           99
3230 3230 HOSPITAL OF UNIV OF PENNSYLVANIA 34TH & SPRUCE STS PHILADELPHIA PA 19104 PHILADELPHIA (215) 662-3227 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9504425 -75.1925902 1 GEOMETRIC_CENTER 101 42 42101 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Philadelphia County https://data.medicare.gov/resource/xubh-q36u/row-2v8t-hvbn_kbi7 390111 661968 2019-11-26 2019-06-30 587 32 12   78 2 748   58           806
3412 3412 COMMONWEALTH HEALTH CENTER 1 LOWER NAVY HILL ROAD (PO BOX 409CK) GARAPAN MP 96950 SAIPAN (670) 234-8950 Acute Care Hospitals Proprietary TRUE 15.2086299 145.7303467 1 GEOMETRIC_CENTER 110 69 69110         https://data.medicare.gov/resource/xubh-q36u/row-z8uz.de7b_sx86 660001 644688 2019-03-01 2018-09-30 70 4         74               74
3515 3515 HOSPITAL SAN CRISTOBAL CARR 506 KM 1 0 COTO LAUREL PR 780 PONCE (787) 848-2100 Acute Care Hospitals Voluntary non-profit - Private TRUE 18.0489279 -66.5531847 1 GEOMETRIC_CENTER 113 72 72113 38660 Ponce-Coamo-Santa Isabel, PR Central Ponce Municipio https://data.medicare.gov/resource/xubh-q36u/row-f3ni_a74v_j5mm 400113 643733 2019-02-28 2018-09-30 110 35         157               157
3590 3590 OSF SAINT ANTHONY'S HEALTH CENTER ST ANTHONY'S WAY ALTON IL 62002 MADISON (618) 465-2571 Acute Care Hospitals Voluntary non-profit - Church TRUE 38.9073839 -90.1718152 1 GEOMETRIC_CENTER 119 17 17119 41180 St. Louis-St. Charles-Farmington, MO-IL Central Madison County https://data.medicare.gov/resource/xubh-q36u/row-mu62-iiye-da97 140052 645329 2019-02-28 2018-09-30 68 10         78               78
3736 3736 HOSPITAL DE LA CONCEPCION ROAD NUMBER 2 KM 173.4 CAIN ALTO SAN GERMAN PR 683 SAN GERMAN (787) 892-1860 Acute Care Hospitals Voluntary non-profit - Church TRUE 18.0988246 -67.0382886 1 GEOMETRIC_CENTER 125 72 72125 41900 Mayagüez-San Germán, PR Central San Germán Municipio https://data.medicare.gov/resource/xubh-q36u/row-ud6p-v4z7-e8nu 400021 649494 2019-05-31 2018-12-31 143 12       12 167   19           186
3766 3766 UNIVERSITY PEDIATRIC HOSPITAL PUERTO RICO MEDICAL CENTER IN RIO PIEDRAS SAN JUAN PR 935 SAN JUAN (787) 777-3232 Childrens Government - State TRUE 18.3958646 -66.0736306 1 GEOMETRIC_CENTER 127 72 72127 41980 San Juan-Carolina, PR Central San Juan Municipio https://data.medicare.gov/resource/xubh-q36u/row-aat9~yvnm_fjvd 403301 640173 2018-11-30 2018-06-30                              
3768 3768 HIMA SAN PABLO CUPEY CARR 844 KM 5 CUPEY BAJO SAN JUAN PR 928 SAN JUAN (787) 761-8383 Acute Care Hospitals Proprietary TRUE 18.3551846 -66.0400062 1 GEOMETRIC_CENTER 127 72 72127 41980 San Juan-Carolina, PR Central San Juan Municipio https://data.medicare.gov/resource/xubh-q36u/row-dfqg_xf6v~mrae 400133 660027 2019-11-08 2018-12-31 42 9         51       19       70
3769 3769 DOCTOR CENTER HOSPITAL SAN FERNANDO DE LA CAROLINA EDIF JESUS T PINEIRO AVE FERNANDEZ JUNCOS BO PUEBL CAROLINA PR 979 SAN JUAN (787) 725-6038 Acute Care Hospitals Government - State TRUE 18.4215119 -66.0256637 1 GEOMETRIC_CENTER 127 72 72127 41980 San Juan-Carolina, PR Central San Juan Municipio https://data.medicare.gov/resource/xubh-q36u/row-ngg4_t8sn.3cyg 400132 650363 2019-05-31 2018-12-31 103 6         109               109
3770 3770 AUXILIO MUTUO HOSPITAL PONCE DE LEON AVENUE STOP 37 1/2 HATO REY PR 918 SAN JUAN (787) 758-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 18.4229638 -66.0571476 1 GEOMETRIC_CENTER 127 72 72127 41980 San Juan-Carolina, PR Central San Juan Municipio https://data.medicare.gov/resource/xubh-q36u/row-hh9m-t23y-dj6g 400016 645607 2019-03-01 2018-09-30 363 11 7   6   443   17           460
3772 3772 SAN JUAN MUNICIPAL HOSPITAL BARRIO MONACILLOS,CENTRO MEDICO RIO PIEDRAS PR 936 SAN JUAN (787) 756-8535 Acute Care Hospitals Voluntary non-profit - Other TRUE 18.3960081 -66.0738624 1 GEOMETRIC_CENTER 127 72 72127 41980 San Juan-Carolina, PR Central San Juan Municipio https://data.medicare.gov/resource/xubh-q36u/row-k4tw_xde7_xhx9 400015 661646 2019-11-29 2019-06-30 144 30         174               174
3773 3773 HOSPITAL UNIVERSITARIO DE ADULTO BARRIO MONACILLOS CENTROMEDICO RIO PIEDRAS PR 927 SAN JUAN (787) 754-0101 Acute Care Hospitals Government - State TRUE 18.3960081 -66.0738624 1 GEOMETRIC_CENTER 127 72 72127 41980 San Juan-Carolina, PR Central San Juan Municipio https://data.medicare.gov/resource/xubh-q36u/row-swte-w8pc_y4fj 400061 660309 2019-11-27 2019-06-30 200 15         215               215
3778 3778 CENTRO CARDIOVASCULAR AVENIDA AMERICO MIRANDA, ENTRADA PRINCIPAL CM RIO PIEDRAS PR 936 SAN JUAN (787) 754-8500 Acute Care Hospitals Government - State FALSE 18.3997905 -66.0681500 1 GEOMETRIC_CENTER 127 72 72127 41980 San Juan-Carolina, PR Central San Juan Municipio https://data.medicare.gov/resource/xubh-q36u/row-n57n_rm6c-sekq 400124 639357 2018-12-12 2018-06-30 114 50         164               164
3779 3779 HOSPITAL ONCOLOGICO DR ISAAC GONZALEZ MARTINEZ BO. MONACILLOS CARR 22 CENTRO MEDICO DE PUERTO RIC SAN JUAN PR 935 SAN JUAN (787) 763-4149 Acute Care Hospitals Voluntary non-profit - Private FALSE 18.3958646 -66.0736306 1 GEOMETRIC_CENTER 127 72 72127 41980 San Juan-Carolina, PR Central San Juan Municipio https://data.medicare.gov/resource/xubh-q36u/row-y9yb.2qds_r9bm 400012 661645 2019-12-05 2019-06-30 52 5         57               57
3807 3807 SABETHA COMMUNITY HOSPITAL 14TH & OREGON SABETHA KS 66534 NEMAHA (785) 284-2121 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.8997686 -95.8071090 1 GEOMETRIC_CENTER 131 20 20131         https://data.medicare.gov/resource/xubh-q36u/row-tatv-27qf.j7tk 171338 650576 2019-06-04 2018-12-31 17           17               17
3938 3938 HOSPITAL METROPOLITANO DE LA MONTANA CALLE ISAAC GONZALEZ ESQUINA LEDESMA BDA NUEVA PR 641 UTUADO (787) 933-1100 Acute Care Hospitals Proprietary TRUE 18.2675675 -66.7013424 1 GEOMETRIC_CENTER 141 72 72141 10380   Central Utuado Municipio https://data.medicare.gov/resource/xubh-q36u/row-8n9a.kpfm-bvb9 400130 650777 2019-05-28 2018-12-31 7           7 40             47
3994 3994 CENTRO MEDICO WILMA N VAZQUEZ CARR. 2 KM 39.5 ROAD NUMBER 2 BO ALGARROBO VEGA BAJA PR 693 VEGA BAJA (787) 858-1580 Acute Care Hospitals Proprietary TRUE 18.4433265 -66.4180747 1 GEOMETRIC_CENTER 145 72 72145 41980 San Juan-Carolina, PR Central Vega Baja Municipio https://data.medicare.gov/resource/xubh-q36u/row-7zfj_f2en-e6zu 400115 650774 2019-05-31 2018-12-31 124 6         130       20       150
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
4225 4225 LIFEBRITE COMMUNITY HOSPITAL OF STOKES 1570 NC 8 & 89 HWY NORTH DANBURY NC 27016 STOKES (336) 593-2831 Critical Access Hospitals Proprietary TRUE 36.4180006 -80.2309154 1 GEOMETRIC_CENTER 169 37 37169 49180 Greensboro--Winston-Salem--High Point, NC Central Stokes County https://data.medicare.gov/resource/xubh-q36u/row-dqr8~4bpg.trsv 341317 646477 2019-04-15 2018-09-30 25           25       40       65
4541 4541 MEADOWS REGIONAL MEDICAL CENTER ONE MEADOWS PARKWAY VIDALIA GA 30474 TOOMBS (912) 535-5828 Acute Care Hospitals Proprietary TRUE 32.2071314 -82.3777520 1 GEOMETRIC_CENTER 279 13 13279 47080   Central Toombs County https://data.medicare.gov/resource/xubh-q36u/row-ifps.um7x~mbjr 110128 659939 2019-12-02 2019-06-30 44 8         52               52

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