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

67 rows where hospital_ownership = "Government - State"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, hospital_type, emergency_services, geocode_flag, geocode_accuracy, statefips, centraloutlyingcounty, fy_end_date, coronary_beds, burn_beds, surg_icu_beds, oth_spec_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_beds, nursing_fac_beds, oth_longterm_beds, filed_date (date), fy_end_date (date)

hospital_ownership ✖

  • Government - State · 67 ✖
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
80 80 HILO MEDICAL CENTER 1190 WAIANUENUE AVENUE HILO HI 96720 HAWAII (808) 932-3000 Acute Care Hospitals Government - State TRUE 19.7174670 -155.1135130 0   1 15 15001 25900   Central Hawaii County https://data.medicare.gov/resource/xubh-q36u/row-szpt~f525_222j 120005 657722 2018-12-03 2018-06-30 146 11         157       119       276
81 81 HALE HO'OLA HAMAKUA 45-547 PLUMERIA STREET HONOKAA HI 96727 HAWAII (808) 932-4100 Critical Access Hospitals Government - State TRUE 20.0762710 -155.4705950 0   1 15 15001 25900   Central Hawaii County https://data.medicare.gov/resource/xubh-q36u/row-z9jm-2idi-sq3z 121307 640366 2018-12-03 2018-06-30 11           11       66       77
82 82 KONA COMMUNITY HOSPITAL 79-1019 HAUKAPILA STREET KEALAKEKUA HI 96750 HAWAII (808) 322-9311 Acute Care Hospitals Government - State TRUE 19.5192370 -155.9177190 0   1 15 15001 25900   Central Hawaii County https://data.medicare.gov/resource/xubh-q36u/row-j5zq.9y53_j6as 120019 662187 2019-12-02 2019-06-30 74 9         83 11             94
83 83 KOHALA HOSPITAL 54-383 HOSPITAL ROAD KAPAAU HI 96755 HAWAII (808) 889-6211 Critical Access Hospitals Government - State TRUE 20.2317370 -155.7972530 0   1 15 15001 25900   Central Hawaii County https://data.medicare.gov/resource/xubh-q36u/row-zwx4_qya8~b57e 121302 662519 2019-11-29 2019-06-30 6           6       22       28
84 84 KAU HOSPITAL 1 KAMANI STREET PAHALA HI 96777 HAWAII (808) 928-8331 Critical Access Hospitals Government - State TRUE 19.2005710 -155.4720970 0   1 15 15001 25900   Central Hawaii County https://data.medicare.gov/resource/xubh-q36u/row-jcnf-fhnk_q5i3 121301 662188 2019-12-02 2019-06-30 6           6               6
89 89 ALLEN COUNTY REGIONAL HOSPITAL 3066 NORTH KENTUCKY STREET IOLA KS 66749 ALLEN (620) 365-1021 Critical Access Hospitals Government - State TRUE 37.9503420 -95.3906740 0   1 20 20001         https://data.medicare.gov/resource/xubh-q36u/row-gt8h_8a7x~t4kr 171373 648832 2019-05-29 2018-12-31 25           25               25
107 107 LOVELACE WOMEN'S HOSPITAL 4701 MONTGOMERY BOULEVARD NE ALBUQUERQUE NM 87109 BERNALILLO (505) 727-7805 Acute Care Hospitals Government - State TRUE 35.1310050 -106.5910370 0   1 35 35001 10740 Albuquerque-Santa Fe-Las Vegas, NM Central Bernalillo County https://data.medicare.gov/resource/xubh-q36u/row-fycu~sc7u.8im7 320017 655223 2019-10-17 2019-04-30 112 8       42 162               162
124 124 BEAVER VALLEY HOSPITAL 1109 NORTH 100 WEST BEAVER UT 84713 BEAVER (435) 438-7100 Critical Access Hospitals Government - State TRUE 38.2892580 -112.6432040 0   1 49 49001         https://data.medicare.gov/resource/xubh-q36u/row-x2bw~6dhq.mh7x 461335 659078 2019-11-20 2019-06-30 25           25               25
350 350 KAUAI VETERANS MEMORIAL HOSPITAL 4643 WAIMEA CANYON DRIVE WAIMEA HI 96796 KAUAI (808) 338-9431 Critical Access Hospitals Government - State TRUE 21.9600790 -159.6700550 0   7 15 15007 28180   Central Kauai County https://data.medicare.gov/resource/xubh-q36u/row-ddrn-xkz9.2xji 121300 655051 2019-09-20 2018-06-30 23 2         25       20       45
351 351 SAMUEL MAHELONA MEMORIAL HOSPITAL 4800 KAWAIHAU ROAD KAPAA HI 96746 KAUAI (808) 822-4961 Critical Access Hospitals Government - State TRUE 22.0876190 -159.3142040 0   7 15 15007 28180   Central Kauai County https://data.medicare.gov/resource/xubh-q36u/row-ysve.ycbm-b3qy 121306 640504 2018-11-30 2018-06-30 5           5 9     66       80
373 373 MINERS' COLFAX MEDICAL CENTER 203 HOSPITAL DRIVE RATON NM 87740 COLFAX (575) 445-3661 Critical Access Hospitals Government - State TRUE 36.8635480 -104.4431840 0   7 35 35007         https://data.medicare.gov/resource/xubh-q36u/row-52rb_2gq5.zmq9 321307 659824 2019-11-21 2019-06-30 21 4         25         37     62
425 425 MAUI MEMORIAL MEDICAL CENTER 221 MAHALANI STREET WAILUKU HI 96793 MAUI (808) 442-5101 Acute Care Hospitals Government - State FALSE 20.8844550 -156.4880870 0   9 15 15009 27980   Central Maui County https://data.medicare.gov/resource/xubh-q36u/row-66fd~zrmp.8s5u 120002 649892 2019-06-03 2018-12-31 199 20         219               219
426 426 LANAI COMMUNITY HOSPITAL 628 7TH STREET LANAI CITY HI 96763 MAUI (808) 565-8450 Critical Access Hospitals Government - State TRUE 20.8267350 -156.9180020 0   9 15 15009 27980   Central Maui County https://data.medicare.gov/resource/xubh-q36u/row-keiy_dtd7_smny 121305 648608 2019-06-03 2018-12-31 4           4       10       14
427 427 KULA HOSPITAL 100 KEOKEA PLACE KULA HI 96790 MAUI (808) 878-1221 Critical Access Hospitals Government - State TRUE 20.7019940 -156.3570990 0   9 15 15009 27980   Central Maui County https://data.medicare.gov/resource/xubh-q36u/row-8svz_bunk-n2za 121308 648609 2019-06-03 2018-12-31 9           9       105       123
479 479 GOV JUAN F LUIS HOSPITAL & MEDICAL CTR #4007 EST DIAMOND RUBY, CHRISTIANSTED ST CROIX VI 820 SAINT CROIX ISLAND (340) 778-6311 Acute Care Hospitals Government - State TRUE 17.7336768 -64.7515758 1 ROOFTOP 10 78 78010         https://data.medicare.gov/resource/xubh-q36u/row-bs2s~9p8n_k2e3 480002 644383 2019-02-28 2018-09-30 66 11         77               77
632 632 UNIVERSITY HOSPITAL 150 BERGEN ST NEWARK NJ 7101 ESSEX (973) 972-5658 Acute Care Hospitals Government - State TRUE 40.7409500 -74.1921300 0   13 34 34013 35620 New York-Newark, NY-NJ-CT-PA Central Essex County https://data.medicare.gov/resource/xubh-q36u/row-b5qq_ap3x-6s92 310119 661058 2019-12-02 2019-06-30 266 41 6       355               355
839 839 UNIVERSITY OF MISSOURI HEALTH CARE ONE HOSPITAL DRIVE COLUMBIA MO 65212 BOONE (573) 882-4141 Acute Care Hospitals Government - State TRUE 38.9386955 -92.3275514 1 ROOFTOP 19 29 29019 17860 Columbia-Moberly-Mexico, MO Central Boone County https://data.medicare.gov/resource/xubh-q36u/row-63ac~57ef~2j52 260141 660405 2019-11-26 2019-06-30 372 82       58 530 61             591
858 858 MUSC MEDICAL CENTER 169 ASHLEY AVE CHARLESTON SC 29425 CHARLESTON (843) 792-2300 Acute Care Hospitals Government - State TRUE 32.7854000 -79.9465590 0   19 45 45019 16700   Central Charleston County https://data.medicare.gov/resource/xubh-q36u/row-yb9w~4mxa-yhfk 420004 662071 2019-08-30 2018-06-30 502 114       66 682 98             780
939 939 HOSPITAL UNIVERSITARIO DR RUIZ ARNAU LAUREL AVE SANTA JUANITA #100 BAYAMON PR 956 BAYAMON (787) 787-5151 Acute Care Hospitals Government - State TRUE 18.3672680 -66.1538110 1 ROOFTOP 21 72 72021 41980 San Juan-Carolina, PR Central Bayamón Municipio https://data.medicare.gov/resource/xubh-q36u/row-ea8w~5nt3-7vuk 400105 661647 2019-12-05 2019-06-30 102           102               102
1097 1097 J D MCCARTY CENTER FOR CHILDREN 2002 EAST ROBINSON NORMAN OK 73071 CLEVELAND (405) 307-2800 Childrens Government - State FALSE 35.2327430 -97.4100160 0   27 40 40027 36420 Oklahoma City-Shawnee, OK Central Cleveland County https://data.medicare.gov/resource/xubh-q36u/row-whuu_e32b-w4sk 373300 655813 2019-10-07 2019-06-30                              
1181 1181 TEXAS CENTER FOR INFECTIOUS DISEASE 2303 SE MILITARY DR P O BOX 23340 SAN ANTONIO TX 78223 BEXAR (210) 534-8857 Acute Care Hospitals Government - State FALSE 29.3519300 -98.4583770 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-suha~2mc2-p7yc                                      
1204 1204 DENVER HEALTH MEDICAL CENTER 777 BANNOCK ST DENVER CO 80204 DENVER (303) 602-4930 Acute Care Hospitals Government - State TRUE 39.7282300 -104.9900660 0   31 8 8031 19740 Denver-Aurora, CO Central Denver County https://data.medicare.gov/resource/xubh-q36u/row-6si7.z49y~jb56 60011 650437 2019-05-31 2018-12-31 298 32     23 25 378 64 11           453
1206 1206 PRESBYTERIAN ST LUKES MEDICAL CENTER 1719 E 19TH AVE DENVER CO 80218 DENVER (303) 839-6000 Acute Care Hospitals Government - State TRUE 39.7460890 -104.9671750 0   31 8 8031 19740 Denver-Aurora, CO Central Denver County https://data.medicare.gov/resource/xubh-q36u/row-deb8~67qk~e2fi 60014 655884 2019-07-30 2018-08-31 224 71         337               337
1218 1218 UNIVERSITY OF ILLINOIS HOSPITAL 1740 WEST TAYLOR ST SUITE 1400 CHICAGO IL 60612 COOK (312) 996-3900 Acute Care Hospitals Government - State TRUE 41.8692240 -87.6705290 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-npx2_ggxf-iku6 140150 662044 2019-12-05 2019-06-30 303 42 19       434 50             484
1357 1357 UNIVERSITY OF WASHINGTON MEDICAL CTR 1959 NE PACIFIC ST BOX 356151 SEATTLE WA 98195 KING (206) 598-3300 Acute Care Hospitals Government - State TRUE 47.6505060 -122.3074820 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-gezf_iitw.mxe8 500008 661427 2018-11-29 2018-06-30 209 81       50 408 16 18           442
1436 1436 UNIVERSITY OF UTAH HOSPITALS AND CLINICS 50 NORTH MEDICAL DRIVE SALT LAKE CITY UT 84132 SALT LAKE (801) 581-2121 Acute Care Hospitals Government - State TRUE 40.7720190 -111.8370220 0   35 49 49035 41620 Salt Lake City-Provo-Orem, UT Central Salt Lake County https://data.medicare.gov/resource/xubh-q36u/row-w86s~b4kw~syc4 460009 662619 2019-11-26 2019-06-30 343 38 42 15 12 25 523 24 38           585
1506 1506 RONALD REAGAN U C L A MEDICAL CENTER 757 WESTWOOD PLAZA LOS ANGELES CA 90095 LOS ANGELES (310) 825-6301 Acute Care Hospitals Government - State TRUE 34.0639390 -118.4454110 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-2g9a~xstc-im3x 50262 660917 2019-11-26 2019-06-30 291 120 12     22 445               445
1584 1584 FLORIDA STATE HOSPITAL UNIT 31 MED 100 N MAIN ST CHATTAHOOCHEE FL 32324 GADSDEN (850) 663-7536 Acute Care Hospitals Government - State FALSE 30.7068990 -84.8425840 0   39 12 12039 45220 Tallahassee-Bainbridge, FL-GA Outlying Gadsden County https://data.medicare.gov/resource/xubh-q36u/row-kyk8-9a3q-5siu 100298 660194 2019-12-02 2019-06-30 24           24 34         1172   1230
1657 1657 ROOSEVELT GENERAL HOSPITAL 42121 US HIGHWAY 70 PORTALES NM 88130 ROOSEVELT (575) 359-1800 Acute Care Hospitals Government - State TRUE 34.1656650 -103.3681990 0   41 35 35041 38780 Clovis-Portales, NM Central Roosevelt County https://data.medicare.gov/resource/xubh-q36u/row-kycr_dkfp.ev9b 320084 659709 2019-11-26 2019-06-30 20           20               20
1699 1699 UNIVERSITY OF MISSISSIPPI MEDICAL CENTER- GRENADA 960 AVENT DRIVE GRENADA MS 38901 GRENADA (662) 227-7000 Acute Care Hospitals Government - State TRUE 33.7633070 -89.8175320 0   43 28 28043 24980   Central Grenada County https://data.medicare.gov/resource/xubh-q36u/row-p3dc_vfsq.nigj 250168 659814 2019-11-27 2019-06-30 44   5       49               49
1804 1804 UNIVERSITY HOSPITAL OF BROOKLYN ( DOWNSTATE ) 445 LENOX ROAD BROOKLYN NY 11203 KINGS (718) 270-1000 Acute Care Hospitals Government - State TRUE 40.6544570 -73.9451600 0   47 36 36047 35620 New York-Newark, NY-NJ-CT-PA Central Kings County https://data.medicare.gov/resource/xubh-q36u/row-j3yr.94x8.z8x2 330350 651036 2019-06-03 2018-12-31 245 19 7     29 305   18           323
1824 1824 WELCH COMMUNITY HOSPITAL 454 MCDOWELL STREET WELCH WV 24801 MC DOWELL (304) 436-8461 Acute Care Hospitals Government - State TRUE 37.4388220 -81.5892950 0   47 54 54047         https://data.medicare.gov/resource/xubh-q36u/row-y7rn~73h2.fggs 510086 661439 2019-12-02 2019-06-30 42 7         49         59     108
1847 1847 UNIVERSITY OF MISSISSIPPI MED CENTER 2500 N STATE ST JACKSON MS 39216 HINDS (601) 984-4100 Acute Care Hospitals Government - State TRUE 32.3287830 -90.1755800 0   49 28 28049 27140 Jackson-Vicksburg-Brookhaven, MS Central Hinds County https://data.medicare.gov/resource/xubh-q36u/row-ckry~yqs7_czxf 250001 661025 2019-11-27 2019-06-30 486 20 20   20 30 698               698
1866 1866 OHIO STATE UNIVERSITY HOSPITALS 410 WEST 10TH AVENUE COLUMBUS OH 43210 FRANKLIN (614) 293-9700 Acute Care Hospitals Government - State TRUE 39.9948840 -83.0176860 0   49 39 39049 18140 Columbus-Marion-Zanesville, OH Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-fagn.mmer_2f8n 360085 660671 2019-11-25 2019-06-30 885 97         982 91 60           1133
1881 1881 OCEAN BEACH HOSPITAL 174 FIRST AVENUE NORTH ILWACO WA 98624 PACIFIC (360) 642-3181 Critical Access Hospitals Government - State TRUE 46.3116960 -124.0433520 0   49 53 53049         https://data.medicare.gov/resource/xubh-q36u/row-6yj2-723x_f5cn 501314 649845 2019-06-03 2018-12-31 25           25               25
1887 1887 ELMORE COMMUNITY HOSPITAL 500 HOSPITAL DRIVE WETUMPKA AL 36092 ELMORE (334) 567-4311 Acute Care Hospitals Government - State TRUE 32.5519570 -86.1856430 0   51 1 1051 33860   Central Elmore County https://data.medicare.gov/resource/xubh-q36u/row-yfvr~ksbv.udvy 10097 651259 2019-05-29 2018-12-31 33           33               33
1909 1909 HOLMES COUNTY HOSPITAL AND CLINICS 239 BOWLING GREEN ROAD LEXINGTON MS 39095 HOLMES (662) 834-1321 Critical Access Hospitals Government - State TRUE 33.1110770 -90.0297410 0   51 28 28051         https://data.medicare.gov/resource/xubh-q36u/row-bbwk_bsmz-qfyj 251319 660403 2019-11-27 2019-06-30 25           25               25
1978 1978 HIRAM W DAVIS MEDICAL CENTER P O BOX 4030 PETERSBURG VA 23803 PETERSBURG CITY (804) 524-7344 Acute Care Hospitals Government - State FALSE 37.2098658 -77.4509355 1 ROOFTOP 53 51 51053 40060   Central Dinwiddie County https://data.medicare.gov/resource/xubh-q36u/row-xvn2.38q5-2xg5 490104 661117 2019-11-27 2019-06-30 4           4       50 30 277   361
2354 2354 UNIVERSITY OF KENTUCKY HOSPITAL 800 ROSE STREET LEXINGTON KY 40536 FAYETTE (859) 257-2278 Acute Care Hospitals Government - State TRUE 38.0324480 -84.5073810 0   67 21 21067 30460 Lexington-Fayette--Richmond--Frankfort, KY Central Fayette County https://data.medicare.gov/resource/xubh-q36u/row-2d2d_vq4g_m7vt 180067 655316 2019-10-15 2019-06-30 677 146       78 901 31             932
2364 2364 UNIVERSITY HOSPITAL S U N Y HEALTH SCIENCE CENTER 750 EAST ADAMS STREET SYRACUSE NY 13210 ONONDAGA (315) 473-4240 Acute Care Hospitals Government - State TRUE 43.0426770 -76.1393230 0   67 36 36067 45060 Syracuse-Auburn, NY Central Onondaga County https://data.medicare.gov/resource/xubh-q36u/row-kv4k~pugk.273s 330241 650320 2019-05-31 2018-12-31 547 65 8 6     641 24 50   20       735
2375 2375 MUSC HEALTH MARION MEDICAL CENTER 2829 E HWY 76 MULLINS SC 29574 MARION (843) 431-2000 Acute Care Hospitals Government - State TRUE 34.1892320 -79.3219450 0   67 45 45067         https://data.medicare.gov/resource/xubh-q36u/row-nueg_7h5n~iagx 420055 660703 2019-11-25 2019-06-30 84 10         94               94
2497 2497 UNIVERSITY OF ALABAMA HOSPITAL 619 SOUTH 19TH STREET BIRMINGHAM AL 35233 JEFFERSON (205) 934-4011 Acute Care Hospitals Government - State TRUE 33.5061290 -86.8019220 0   73 1 1073 13820 Birmingham-Hoover-Talladega, AL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-x229.ejr6_kvzz 10033 645809 2019-03-01 2018-09-30 772 37     48   1063 93 49           1205
3029 3029 HEALTH CENTRAL 10000 W COLONIAL DR OCOEE FL 34761 ORANGE (407) 296-1820 Acute Care Hospitals Government - State TRUE 28.5516660 -81.5257870 0   95 12 12095 36740 Orlando-Deltona-Daytona Beach, FL Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-racv.i9b2-icw5 100030 654876 2019-09-12 2018-09-30 197 14         211               211
3063 3063 UNIVERSITY OF TOLEDO MEDICAL CENTER 3000 ARLINGTON AVENUE TOLEDO OH 43699 LUCAS (419) 383-4848 Acute Care Hospitals Government - State TRUE 41.6212150 -83.6153820 0   95 39 39095 45780 Toledo-Port Clinton, OH Central Lucas County https://data.medicare.gov/resource/xubh-q36u/row-482x-hf8d_2k7s 360048 661589 2019-12-03 2019-06-30 184       10 18 212 34             246
3073 3073 USA HEALTH CHILDREN'S & WOMEN'S HOSPITAL 1700 CENTER STREET MOBILE AL 36604 MOBILE (251) 415-1000 Childrens Government - State TRUE 30.6960820 -88.0768830 0   97 1 1097 33660 Mobile-Daphne-Fairhope, AL Central Mobile County https://data.medicare.gov/resource/xubh-q36u/row-6w9n_e52x~7jkv 13301 652287 2019-07-17 2018-09-30 132           250               250
3074 3074 UNIVERSITY OF SOUTH ALABAMA MEDICAL CENTER 2451 FILLINGIM STREET MOBILE AL 36617 MOBILE (251) 471-7110 Acute Care Hospitals Government - State TRUE 30.7081210 -88.0994410 0   97 1 1097 33660 Mobile-Daphne-Fairhope, AL Central Mobile County https://data.medicare.gov/resource/xubh-q36u/row-cmzx-i3i2.bp42 10087 645038 2019-02-28 2018-09-30 117 9   7 16   149               149
3080 3080 SONOMA DEVELOPMENTAL CENTER 15000 ARNOLD DRIVE / P O BOX 1493 ELDRIDGE CA 95431 SONOMA (707) 938-6000 Acute Care Hospitals Government - State FALSE 38.3490270 -122.5169100 0   97 6 6097 42220 San Jose-San Francisco-Oakland, CA Central Sonoma County https://data.medicare.gov/resource/xubh-q36u/row-j6wx.73xx-wqrm 50547 638175 2018-11-27 2018-06-30 13           13           963   976
3263 3263 UNIVERSITY OF IOWA HOSPITAL & CLINICS 200 HAWKINS DRIVE IOWA CITY IA 52242 JOHNSON (319) 356-1616 Acute Care Hospitals Government - State TRUE 41.6612030 -91.5507590 0   103 19 19103 26980 Cedar Rapids-Iowa City, IA Central Johnson County https://data.medicare.gov/resource/xubh-q36u/row-cxgc_xna4~4mhi 160058 660215 2019-11-25 2019-06-30 497   24 17 36 88 716 73             789
3277 3277 STONY BROOK UNIVERSITY HOSPITAL HEALTH SCIENCES CENTER SUNY STONY BROOK NY 11794 SUFFOLK (631) 444-4000 Acute Care Hospitals Government - State TRUE 40.9097910 -73.1161755 1 ROOFTOP 103 36 36103 35620 New York-Newark, NY-NJ-CT-PA Central Suffolk County https://data.medicare.gov/resource/xubh-q36u/row-v82y.wvkf-fyvq 330393 650754 2019-05-31 2018-12-31 525 70   6   46 657 38             695
3313 3313 LALLIE KEMP MEDICAL CENTER 52579 HIGHWAY 51 SOUTH INDEPENDENCE LA 70443 TANGIPAHOA (985) 878-9421 Critical Access Hospitals Government - State TRUE 30.6221940 -90.4969990 0   105 22 22105 25220 New Orleans-Metairie-Hammond, LA-MS Central Tangipahoa Parish https://data.medicare.gov/resource/xubh-q36u/row-iyxe~6sc2-ecgv 191321 662534 2019-12-02 2019-06-30 20 4         24               24
3338 3338 PORTERVILLE DEVELOPMENTAL CENTER 26501 AVENUE 140 PORTERVILLE CA 93257 TULARE (559) 782-2222 Acute Care Hospitals Government - State FALSE 36.0439080 -118.9804830 0   107 6 6107 47300 Visalia-Porterville-Hanford, CA Central Tulare County https://data.medicare.gov/resource/xubh-q36u/row-8jhm_m9d6-frtp 50546 638174 2018-11-27 2018-06-30 44           44           1182   1226
3455 3455 JACK HUGHSTON MEMORIAL HOSPITAL 4401 RIVER CHASE DRIVE PHENIX CITY AL 36867 RUSSELL (334) 732-3000 Acute Care Hospitals Government - State TRUE 32.5090450 -85.0056960 0   113 1 1113 17980 Columbus-Auburn-Opelika, GA-AL Central Russell County https://data.medicare.gov/resource/xubh-q36u/row-6v2c.qrez~vn8e 10168 651160 2019-05-31 2018-12-31 39 8         47               47
3492 3492 UT SOUTHWESTERN UNIVERSITY HOSPITAL-ZALE LIPSHY 5151 HARRY HINES BLVD DALLAS TX 75390 DALLAS (214) 879-3758 Acute Care Hospitals Government - State FALSE 32.8106928 -96.8368900 1 ROOFTOP 113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-x8yt-bzir~q2t5 450766 656547 2019-08-22 2018-08-31 74 20         94 18 36           148
3501 3501 UT SOUTHWESTERN UNIVERSITY HOSPITAL 6201 HARRY HINES BLVD DALLAS TX 75390 DALLAS (214) 633-5555 Acute Care Hospitals Government - State TRUE 32.8193657 -96.8488409 1 ROOFTOP 113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-8x4y~icku-nwfq 450044 662594 2019-08-22 2018-08-31 357 72         459               459
3577 3577 UAMS MEDICAL CENTER 4301 WEST MARKHAM STREET MAIL SLOT 612 LITTLE ROCK AR 72205 PULASKI (501) 686-5000 Acute Care Hospitals Government - State TRUE 34.7515830 -92.3209980 0   119 5 5119 30780 Little Rock-North Little Rock, AR Central Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-s6x4~kv5r_9fry 40016 660912 2019-12-03 2019-06-30 389 28 24     64 505               505
3645 3645 WHITFIELD MEDICAL SURGICAL HOSPITAL 3550 HWY 468 W, BLDG 60 WHITFIELD MS 39193 RANKIN (601) 351-8023 Acute Care Hospitals Government - State FALSE 32.2418381 -90.0709905 1 ROOFTOP 121 28 28121 27140 Jackson-Vicksburg-Brookhaven, MS Central Rankin County https://data.medicare.gov/resource/xubh-q36u/row-h6gx_kf5u~ce53 250134 660110 2019-12-02 2019-06-30 32           32               32
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                              
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
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
3860 3860 UNIVERSITY OF NORTH CAROLINA HOSPITAL 101 MANNING DRIVE CHAPEL HILL NC 27514 ORANGE (919) 966-4141 Acute Care Hospitals Government - State TRUE 35.9035510 -79.0518940 0   135 37 37135 20500 Raleigh-Durham-Chapel Hill, NC Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-pha8_ahwj~xmph 340061 660649 2019-11-27 2019-06-30 676   13       803 104 30       6   943
3959 3959 OKLAHOMA STATE UNIVERSITY MEDICAL CENTER 744 WEST 9TH STREET TULSA OK 74127 TULSA (918) 599-1000 Acute Care Hospitals Government - State TRUE 36.1468360 -96.0001190 0   143 40 40143 46140 Tulsa-Muskogee-Bartlesville, OK Central Tulsa County https://data.medicare.gov/resource/xubh-q36u/row-zrhv~9hmr~mtje 370078 660429 2019-11-29 2019-06-30 138 33         171               171
4215 4215 UNIVERSITY OF TEXAS MEDICAL BRANCH 301 UNIVERSITY BOULEVARD GALVESTON TX 77555 GALVESTON (409) 772-1011 Acute Care Hospitals Government - State TRUE 29.3114430 -94.7762610 0   167 48 48167 26420 Houston-The Woodlands, TX Central Galveston County https://data.medicare.gov/resource/xubh-q36u/row-yg6a~8grc.bxeb 450018 658590 2019-02-01 2018-08-31 399     6 20 16 561               561
4317 4317 REX HOSPITAL 4420 LAKE BOONE TRAIL RALEIGH NC 27607 WAKE (919) 784-3100 Acute Care Hospitals Government - State TRUE 35.8154580 -78.7050320 0   183 37 37183 39580 Raleigh-Durham-Chapel Hill, NC Central Wake County https://data.medicare.gov/resource/xubh-q36u/row-63xd~rcxd~ynej 340114 659712 2019-11-22 2019-06-30 346 51 42       439       120       559
4626 4626 UNIVERSITY OF TEXAS HEALTH SCIENCE CENTER AT TYLER 11937 US HIGHWAY 271 TYLER TX 75708 SMITH (903) 877-7777 Acute Care Hospitals Government - State TRUE 32.4236900 -95.2092910 0   423 48 48423 46340 Tyler-Jacksonville, TX Central Smith County https://data.medicare.gov/resource/xubh-q36u/row-t9fk_pkzk_23zc 450690 662612 2019-02-01 2018-08-31 90 14         104 26             130
4658 4658 TEXAS HEALTH HARRIS METHODIST HOSPITAL SOUTHLAKE 1545 E SOUTHLAKE BLVD SOUTHLAKE TX 76092 TARRANT (817) 748-8700 Acute Care Hospitals Government - State TRUE 32.9409700 -97.1275780 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-4qpu.5fxr~n8vb 450888 651593 2019-06-21 2018-12-31 17           17               17
4733 4733 UNIVERSITY OF VIRGINIA MEDICAL CENTER 1215 LEE STREET CHARLOTTESVILLE VA 22908 CHARLOTTESVILLE CITY (800) 251-3627 Acute Care Hospitals Government - State TRUE 38.0318290 -78.4984550 0   540 51 51540 16820   Central Charlottesville city https://data.medicare.gov/resource/xubh-q36u/row-br7u-jiza~znwz 490009 660720 2019-11-27 2019-06-30 437 14 9     57 585 27             612

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