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

325 rows where "filed_date" is on date 2019-06-03 sorted by lat

View and edit SQL

Suggested facets: hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, centraloutlyingcounty, coronary_beds, burn_beds, surg_icu_beds, oth_spec_beds, subprovider_oth_beds, nursing_fac_beds, oth_longterm_beds, fy_end_date (date)

filed_date (date)

  • 2019-06-03 · 325
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
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
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
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
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
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
4475 DOCTORS HOSPITAL AT RENAISSANCE 5501 SOUTH MCCOLL EDINBURG TX 78539 HIDALGO (956) 362-8677 Acute Care Hospitals Physician TRUE 26.2524240 -98.2041090 0   215 48 48215 32580 McAllen-Edinburg, TX Central Hidalgo County https://data.medicare.gov/resource/xubh-q36u/row-ie54-gr3x-shm2 450869 649837 2019-06-03 2018-12-31 287 58         394 87 38           519
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
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
2786 CLEVELAND CLINIC MARTIN NORTH HOSPITAL 200 SE HOSPITAL AVE STUART FL 34995 MARTIN (772) 287-5200 Acute Care Hospitals Voluntary non-profit - Private TRUE 27.1994410 -80.2430340 0   85 12 12085 38940 Miami-Fort Lauderdale-Port St. Lucie, FL Central Martin County https://data.medicare.gov/resource/xubh-q36u/row-bfv6_fpnd-ukab 100044 649407 2019-06-03 2018-12-31 447 57 8   9   521               521
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
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
4574 PALACIOS COMMUNITY MEDICAL CENTER 311 GREEN AVENUE PALACIOS TX 77465 MATAGORDA (361) 972-2511 Critical Access Hospitals Voluntary non-profit - Private TRUE 28.7174570 -96.2127670 0   321 48 48321 13060 Houston-The Woodlands, TX Central Matagorda County https://data.medicare.gov/resource/xubh-q36u/row-e88j_uxba~jujd 451332 650379 2019-06-03 2018-12-31 17           17               17
34 FRIO REGIONAL HOSPITAL 200 S IH 35 PEARSALL TX 78061 FRIO (830) 334-3617 Critical Access Hospitals Voluntary non-profit - Private TRUE 28.8970480 -99.1160130 0   163 48 48163         https://data.medicare.gov/resource/xubh-q36u/row-9gys.vgtu~2pyx 451391 650214 2019-06-03 2018-12-31 24           24               24
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
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
4420 HOUSTON METHODIST HOSPITAL 6565 FANNIN HOUSTON TX 77030 HARRIS (713) 790-2221 Acute Care Hospitals Voluntary non-profit - Private TRUE 29.7105670 -95.4001180 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-x9i9~yafj.4fsk 450358 649831 2019-06-03 2018-12-31 763 37         956 31 31   25       1043
4435 MEMORIAL HERMANN KATY HOSPITAL 23900 KATY FREEWAY KATY TX 77494 FORT BEND (281) 392-1111 Acute Care Hospitals Voluntary non-profit - Private TRUE 29.7859180 -95.7856570 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-zzwh.pxe4.wege 450847 649966 2019-06-03 2018-12-31 152 32       24 208               208
1906 WEST JEFFERSON MEDICAL CENTER 1101 MEDICAL CENTER BLVD MARRERO LA 70072 JEFFERSON (504) 347-5511 Acute Care Hospitals Voluntary non-profit - Private TRUE 29.8917490 -90.0958860 0   51 22 22051 35380 New Orleans-Metairie-Hammond, LA-MS Central Jefferson Parish https://data.medicare.gov/resource/xubh-q36u/row-v77t~qm7x-pynw 190039 650139 2019-06-03 2018-12-31 174 12 12       215 16 24           255
2464 CHILDRENS HOSPITAL 200 HENRY CLAY AVE NEW ORLEANS LA 70118 ORLEANS (504) 899-9511 Childrens Voluntary non-profit - Private TRUE 29.9173960 -90.1271310 0   71 22 22071 35380 New Orleans-Metairie-Hammond, LA-MS Central Orleans Parish https://data.medicare.gov/resource/xubh-q36u/row-kxvy_6z7u_5sih 193300 650822 2019-06-03 2018-12-31 123           187 34             221
4428 HOUSTON METHODIST WILLOWBROOK HOSPITAL 18220 TOMBALL PARKWAY HOUSTON TX 77070 HARRIS (281) 477-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 29.9640590 -95.5507890 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-zmvm.hxwj~8hgy 450844 649965 2019-06-03 2018-12-31 281 32         313               313
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
4583 HOUSTON METHODIST THE WOODLANDS HOSPITAL 17201 INTERSTATE 45 SOUTH THE WOODLANDS TX 77385 MONTGOMERY (936) 270-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.2046970 -95.4555100 0   339 48 48339 26420 Houston-The Woodlands, TX Outlying Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-uc2s-vyjm.8c3p 670122 649390 2019-06-03 2018-12-31 130 16         146               146
828 WEST CALCASIEU CAMERON HOSPITAL 701 EAST CYPRESS STREET SULPHUR LA 70663 CALCASIEU (337) 527-7034 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.2310740 -93.3692900 0   19 22 22019 29340   Central Calcasieu Parish https://data.medicare.gov/resource/xubh-q36u/row-swji~irkf_eud2 190013 650585 2019-06-03 2018-12-31 95 12         107               107
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
1591 SAVOY MEDICAL CENTER 801 POINCIANA AVENUE MAMOU LA 70554 EVANGELINE (337) 468-5261 Acute Care Hospitals Voluntary non-profit - Other TRUE 30.6410320 -92.4176050 0   39 22 22039         https://data.medicare.gov/resource/xubh-q36u/row-53wc.63uu-ebuh 190025 650138 2019-06-03 2018-12-31 118 10         128 38 10           176
3555 RIVERSIDE MEDICAL CENTER 1900 SOUTH MAIN ST FRANKLINTON LA 70438 WASHINGTON (985) 795-4431 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.8351320 -90.1519790 0   117 22 22117 14220 New Orleans-Metairie-Hammond, LA-MS Central Washington Parish https://data.medicare.gov/resource/xubh-q36u/row-biqu.ctdj-naqx 191313 649031 2019-06-03 2018-12-31 20 5         25               25
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
2395 COFFEE REGIONAL MEDICAL CENTER, INC 1101 OCILLA ROAD DOUGLAS GA 31533 COFFEE (912) 383-5620 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.5095890 -82.8634600 0   69 13 13069 20060   Central Coffee County https://data.medicare.gov/resource/xubh-q36u/row-d473_ue4x.74tq 110089 652866 2019-06-03 2018-12-31 76 10         86               86
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
3754 SIMPSON GENERAL HOSPITAL CAH 1842 SIMPSON HIGHWAY 149 MENDENHALL MS 39114 SIMPSON (601) 847-2221 Critical Access Hospitals Voluntary non-profit - Private TRUE 31.9680940 -89.8869960 0   127 28 28127 27140 Jackson-Vicksburg-Brookhaven, MS Outlying Simpson County https://data.medicare.gov/resource/xubh-q36u/row-garg.yvze~zuuk 251317 650844 2019-06-03 2018-12-31 25           25 10             35
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
960 H C WATKINS MEMORIAL HOSPITAL INC 605 SOUTH ARCHUSA AVENUE QUITMAN MS 39355 CLARKE (601) 776-6925 Critical Access Hospitals Voluntary non-profit - Other TRUE 32.0312590 -88.7279550 0   23 28 28023 32940   Outlying Clarke County https://data.medicare.gov/resource/xubh-q36u/row-7ipq~zmm9-gyn8 251316 650283 2019-06-03 2018-12-31 25           25               25
1895 MEMORIAL HEALTH UNIVERSITY MEDICAL CENTER 4700 WATERS AVENUE SAVANNAH GA 31404 CHATHAM (912) 350-3691 Acute Care Hospitals Voluntary non-profit - Other TRUE 32.0317850 -81.0918270 0   51 13 13051 42340 Savannah-Hinesville-Statesboro, GA Central Chatham County https://data.medicare.gov/resource/xubh-q36u/row-amaq_j44a_mqc4 110036 651266 2019-06-03 2018-12-31 381 20       10 525 10             535
940 CHOCTAW GENERAL HOSPITAL 401 VANITY FAIR LANE, PO BOX 618 BUTLER AL 36904 CHOCTAW (205) 459-9100 Critical Access Hospitals Voluntary non-profit - Private TRUE 32.0937419 -88.2095888 1 ROOFTOP 23 1 1023         https://data.medicare.gov/resource/xubh-q36u/row-cm2u-i8id~q257 11304 651161 2019-06-03 2018-12-31 25           25               25
808 BANNER-UNIVERSITY MEDICAL CENTER SOUTH CAMPUS 2800 EAST AJO WAY TUCSON AZ 85713 PIMA (520) 874-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.1778820 -110.9308910 0   19 4 4019 46060 Tucson-Nogales, AZ Central Pima County https://data.medicare.gov/resource/xubh-q36u/row-chg3-jijt~hfj8 30111 650941 2019-06-03 2018-12-31 120 12         132 18             150
806 BANNER - UNIVERSITY MEDICAL CENTER TUCSON CAMPUS 1625 NORTH CAMPBELL AVENUE TUCSON AZ 85724 PIMA (520) 874-4189 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.2423620 -110.9440920 0   19 4 4019 46060 Tucson-Nogales, AZ Central Pima County https://data.medicare.gov/resource/xubh-q36u/row-vwgy.bhrj~yxk9 30064 650939 2019-06-03 2018-12-31 329 90         479               479
4625 BAYLOR SCOTT & WHITE TEXAS SPINE & JOINT HOSPITAL 1814 ROSELAND BOULEVARD TYLER TX 75701 SMITH (903) 525-3300 Acute Care Hospitals Physician TRUE 32.3292480 -95.2994670 0   423 48 48423 46340 Tyler-Jacksonville, TX Central Smith County https://data.medicare.gov/resource/xubh-q36u/row-id2a~8wab-iya8 450864 649358 2019-06-03 2018-12-31 20           20               20
3686 SCOTT REGIONAL HOSPITAL CAH 317 HIGHWAY 13 SOUTH MORTON MS 39117 SCOTT (601) 732-6301 Critical Access Hospitals Voluntary non-profit - Private TRUE 32.3446250 -89.6712950 0   123 28 28123         https://data.medicare.gov/resource/xubh-q36u/row-irvg-pnep~z7t3 251323 649459 2019-06-03 2018-12-31 25           25               25
2577 RUSH FOUNDATION HOSPITAL 1314 19TH AVE MERIDIAN MS 39301 LAUDERDALE (601) 483-0011 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.3706640 -88.6977790 0   75 28 28075 32940   Central Lauderdale County https://data.medicare.gov/resource/xubh-q36u/row-hxem.ceph_8ujn 250069 650164 2019-06-03 2018-12-31 154 22         182               182
3574 HILL HOSPITAL OF SUMTER COUNTY 751 DERBY DRIVE YORK AL 36925 SUMTER (205) 392-5263 Acute Care Hospitals Voluntary non-profit - Other TRUE 32.4918250 -88.2960810 0   119 1 1119         https://data.medicare.gov/resource/xubh-q36u/row-hxjd.ga7s.xmvj 10138 651158 2019-06-03 2018-12-31 33           33               33
740 SPECIALISTS HOSPITAL SHREVEPORT 1500 LINE AVENUE SHREVEPORT LA 71101 CADDO (318) 213-3800 Acute Care Hospitals Physician FALSE 32.4969260 -93.7460460 0   17 22 22017 43340   Central Caddo Parish https://data.medicare.gov/resource/xubh-q36u/row-kr9t-dd8q-wfhi 190278 649901 2019-06-03 2018-12-31 15           15               15
4471 ST FRANCIS HOSPITAL 2122 MANCHESTER EXPRESSWAY COLUMBUS GA 31995 MUSCOGEE (706) 596-4020 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.5069270 -84.9613780 0   215 13 13215 17980 Columbus-Auburn-Opelika, GA-AL Central Muscogee County https://data.medicare.gov/resource/xubh-q36u/row-ym8p~a9n6~uy7b 110129 651198 2019-06-03 2018-12-31 284 28         312 13             325
2532 MONROE SURGICAL HOSPITAL 2408 BROADMOOR BLVD MONROE LA 71201 OUACHITA (318) 410-0002 Acute Care Hospitals Physician FALSE 32.5367710 -92.1022040 0   73 22 22073 33740 Monroe-Ruston-Bastrop, LA Central Ouachita Parish https://data.medicare.gov/resource/xubh-q36u/row-2viy_tht4-abuk 190245 650140 2019-06-03 2018-12-31 10           10               10
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
3208 LAIRD HOSPITAL INC 25117 HIGHWAY 15 UNION MS 39365 NESHOBA (601) 774-8214 Critical Access Hospitals Voluntary non-profit - Private TRUE 32.5592070 -89.1025610 0   101 28 28101         https://data.medicare.gov/resource/xubh-q36u/row-68dt.7k6k_jc9z 251322 649458 2019-06-03 2018-12-31 25           25               25
2404 JOHN C STENNIS MEMORIAL HOSPITAL 14365 HIGHWAY 16 WEST DE KALB MS 39328 KEMPER (769) 486-1000 Critical Access Hospitals Voluntary non-profit - Private TRUE 32.7768190 -88.6791220 0   69 28 28069 32940   Outlying Kemper County https://data.medicare.gov/resource/xubh-q36u/row-rjr3_kmd7~yci5 251335 650500 2019-06-03 2018-12-31 25           25               25
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
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
881 BANNER CASA GRANDE MEDICAL CENTER 1800 EAST FLORENCE BOULEVARD CASA GRANDE AZ 85122 PINAL (520) 381-6300 Acute Care Hospitals Voluntary non-profit - Other TRUE 32.8796080 -111.7092530 0   21 4 4021 38060   Central Pinal County https://data.medicare.gov/resource/xubh-q36u/row-iqqv.u75b-cmsi 30016 651166 2019-06-03 2018-12-31 119 22         141               141
3496 TEXAS HEALTH PRESBYTERIAN HOSPITAL DALLAS 8200 WALNUT HILL LANE DALLAS TX 75231 DALLAS (214) 345-6789 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.8831390 -96.7635740 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-bqmw-xz7n-5cyp 450462 650908 2019-06-03 2018-12-31 428 48         567 17 45           629
4394 WARM SPRINGS MEDICAL CENTER 5995 SPRING STREET WARM SPRINGS GA 31830 MERIWETHER (706) 655-9351 Critical Access Hospitals Voluntary non-profit - Other TRUE 32.8906520 -84.6829110 0   199 13 13199 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Outlying Meriwether County https://data.medicare.gov/resource/xubh-q36u/row-zkjq-ab6q-8vh9 111316 651203 2019-06-03 2018-12-31 25           25       79       104
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
571 BANNER GATEWAY MEDICAL CENTER 1900 NORTH HIGLEY ROAD GILBERT AZ 85234 MARICOPA (480) 543-2000 Acute Care Hospitals Voluntary non-profit - Other TRUE 33.3842250 -111.7196340 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-wvqy.pesc-7dbf 30122 649068 2019-06-03 2018-12-31 141 24         165               165
559 BANNER DESERT MEDICAL CENTER 1400 SOUTH DOBSON ROAD MESA AZ 85202 MARICOPA (480) 412-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.3909100 -111.8746240 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-m5b5-4dvf~smre 30065 649063 2019-06-03 2018-12-31 447 51 31       615               615
572 BANNER HEART HOSPITAL 6750 EAST BAYWOOD AVENUE MESA AZ 85206 MARICOPA (480) 854-5050 Acute Care Hospitals Voluntary non-profit - Private FALSE 33.4103780 -111.6852730 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-tx6q_94yb.s344 30105 651582 2019-06-03 2018-12-31 67   44       111               111
582 BANNER BAYWOOD MEDICAL CENTER 6644 EAST BAYWOOD AVENUE MESA AZ 85206 MARICOPA (480) 321-2000 Acute Care Hospitals Voluntary non-profit - Private FALSE 33.4104650 -111.6880450 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-xp3v_96ea.bqwa 30088 649064 2019-06-03 2018-12-31 292 26         318   22           340
553 BANNER - UNIVERSITY MEDICAL CENTER PHOENIX 1111 EAST MCDOWELL ROAD PHOENIX AZ 85006 MARICOPA (602) 239-2000 Acute Care Hospitals Voluntary non-profit - Other TRUE 33.4657240 -112.0581270 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-f67j.fyep_c3zs 30002 648882 2019-06-03 2018-12-31 455 46 28       622 22 68           712
583 BANNER ESTRELLA MEDICAL CENTER 9201 WEST THOMAS ROAD PHOENIX AZ 85037 MARICOPA (623) 327-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.4795580 -112.2579360 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-i5b8~ggf8_jyy9 30115 649067 2019-06-03 2018-12-31 273 24         317               317
2503 CHILDREN'S HOSPITAL OF ALABAMA 1600 SEVENTH AVENUE SOUTH BIRMINGHAM AL 35233 JEFFERSON (205) 939-9100 Childrens Voluntary non-profit - Private TRUE 33.5032220 -86.8053810 0   73 1 1073 13820 Birmingham-Hoover-Talladega, AL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-nh6w~rxvd~itst 13300 651162 2019-06-03 2018-12-31 193     6     341               341
576 CORE INSTITUTE SPECIALTY HOSPITAL, THE 6501 NORTH 19TH AVENUE PHOENIX AZ 85015 MARICOPA (602) 795-6020 Acute Care Hospitals Physician FALSE 33.5318370 -112.0996140 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-ymwb.kuwb~xe6j 30108 659179 2019-06-03 2018-12-31 32           32               32
552 BANNER THUNDERBIRD MEDICAL CENTER 5555 WEST THUNDERBIRD ROAD GLENDALE AZ 85306 MARICOPA (602) 865-4470 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.6107310 -112.1786980 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-fmq8_nzm3.7bhy 30089 649065 2019-06-03 2018-12-31 407 40 18       499 56             555
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
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
580 BANNER DEL E. WEBB MEDICAL CENTER 14502 WEST MEEKER BOULEVARD SUN CITY WEST AZ 85375 MARICOPA (623) 524-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.6583070 -112.3719390 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-7gp7~thfz~y68d 30093 650940 2019-06-03 2018-12-31 280 34         314 54 26           394
2282 MENIFEE GLOBAL MEDICAL CENTER 28400 MCCALL B0ULEVARD SUN CITY CA 92585 RIVERSIDE (951) 679-8888 Acute Care Hospitals Physician FALSE 33.7189772 -117.1681518 1 ROOFTOP 65 6 6065 40140 Los Angeles-Long Beach, CA Central Riverside County https://data.medicare.gov/resource/xubh-q36u/row-rqjx-c4v4.2ewv 50684 651179 2019-06-03 2018-12-31 74 10         84               84
2285 HEMET VALLEY MEDICAL CENTER 1117 EAST DEVONSHIRE HEMET CA 92543 RIVERSIDE (951) 652-2811 Acute Care Hospitals Physician TRUE 33.7512200 -116.9598590 0   65 6 6065 40140 Los Angeles-Long Beach, CA Central Riverside County https://data.medicare.gov/resource/xubh-q36u/row-nd99_qqgq_fexi 50390 650949 2019-06-03 2018-12-31 286 18         304       113       417
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
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 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
573 WICKENBURG COMMUNITY HOSPITAL 520 ROSE LANE WICKENBURG AZ 85390 MARICOPA (928) 684-5421 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.9780560 -112.7388250 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-mqi4.ug34.a4ib 31300 649069 2019-06-03 2018-12-31 19           19               19
1493 BEVERLY HOSPITAL 309 W BEVERLY BLVD MONTEBELLO CA 90640 LOS ANGELES (323) 726-1222 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.0160320 -118.1005260 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-5h7f-wtvj_bpxn 50350 650947 2019-06-03 2018-12-31 189 25       10 224               224
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
1515 POMONA VALLEY HOSPITAL MEDICAL CENTER 1798 N GAREY AVE POMONA CA 91767 LOS ANGELES (909) 865-9500 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.0776390 -117.7523290 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-qbck.67td_hi65 50231 650800 2019-06-03 2018-12-31 309 40 10       412               412
722 SUMMIT HEALTHCARE REGIONAL MEDICAL CENTER 2200 EAST SHOW LOW LAKE ROAD SHOW LOW AZ 85901 NAVAJO (928) 537-6399 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.2019670 -110.0183900 0   17 4 4017 43320   Central Navajo County https://data.medicare.gov/resource/xubh-q36u/row-2xk7_cqaa~gdmz 30062 651168 2019-06-03 2018-12-31 77 12         89               89
337 BANNER PAYSON MEDICAL CENTER 807 SOUTH PONDEROSA DRIVE PAYSON AZ 85541 GILA (928) 474-3222 Critical Access Hospitals Voluntary non-profit - Other FALSE 34.2313510 -111.3213610 0   7 4 4007 37740   Central Gila County https://data.medicare.gov/resource/xubh-q36u/row-2gy2.vxfy~pkyq 31318 649532 2019-06-03 2018-12-31 21 4         25               25
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
2441 VICTOR VALLEY GLOBAL MEDICAL CENTER 15248 11TH ST VICTORVILLE CA 92392 SAN BERNARDINO (760) 245-8691 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.5289700 -117.2925180 0   71 6 6071 40140 Los Angeles-Long Beach, CA Central San Bernardino County https://data.medicare.gov/resource/xubh-q36u/row-n839~npwh~jde4 50517 650955 2019-06-03 2018-12-31 89 10       2 101               101
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
3727 SSM HEALTH ST ANTHONY HOSPITAL - SHAWNEE 1102 W MACARTHUR SHAWNEE OK 74804 POTTAWATOMIE (405) 878-8110 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.3617680 -96.9375870 0   125 40 40125 43060 Oklahoma City-Shawnee, OK Central Pottawatomie County https://data.medicare.gov/resource/xubh-q36u/row-sem7_42f7.y5gq 370149 649337 2019-06-03 2018-12-31 63 14         77               77
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
3400 SSM HEALTH ST ANTHONY HOSPITAL - OKLAHOMA CITY 1000 NORTH LEE AVENUE OKLAHOMA CITY OK 73101 OKLAHOMA (405) 272-7000 Acute Care Hospitals Voluntary non-profit - Church TRUE 35.4777860 -97.5242910 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-muxg_8sv2-fqgg 370037 651421 2019-06-03 2018-12-31 309   48       390 53 18 139         600
1305 UNITY MEDICAL CENTER 481 INTERSTATE DRIVE MANCHESTER TN 37355 COFFEE (931) 728-6354 Acute Care Hospitals Physician TRUE 35.4979320 -86.0781410 0   31 47 47031 46100   Central Coffee County https://data.medicare.gov/resource/xubh-q36u/row-7ihq-cddj~pgik 440007 651231 2019-06-03 2018-12-31 49           49               49
1289 REHOBOTH MCKINLEY CHRISTIAN HEALTH CARE SERVICES 1901 RED ROCK DRIVE GALLUP NM 87301 MCKINLEY (505) 863-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.5075000 -108.7272480 0   31 35 35031 23700   Central McKinley County https://data.medicare.gov/resource/xubh-q36u/row-6hnr~wbbc-hgrg 320038 649809 2019-06-03 2018-12-31 23 5         28           1   29
3401 OKLAHOMA SPINE HOSPITAL 14101 PARKWAY COMMONS DRIVE OKLAHOMA CITY OK 73134 OKLAHOMA (405) 749-2700 Acute Care Hospitals Physician TRUE 35.6141370 -97.5821240 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-g6tz_y8sg_qryk 370206 648756 2019-06-03 2018-12-31 23           23               23
198 BOULDER CITY HOSPITAL 901 ADAMS BLVD BOULDER CITY NV 89005 CLARK (702) 293-4111 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.9683590 -114.8434860 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-m2cb.9j9h-qmdd 291309 651018 2019-06-03 2018-12-31 25           25 10     47       82
3942 WASHINGTON REGIONAL MEDICAL CENTER 3215 N NORTH HILLS BOULEVARD FAYETTEVILLE AR 72703 WASHINGTON (479) 463-5113 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.1109840 -94.1578620 0   143 5 5143 22220   Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-2bs7.twrk_htcb 40004 649161 2019-06-03 2018-12-31 226 40         320           12   332
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
4083 PEMISCOT COUNTY MEMORIAL HOSPITAL 946 EAST REED HAYTI MO 63851 PEMISCOT (573) 359-1372 Acute Care Hospitals Government - Local TRUE 36.2368550 -89.7399750 0   155 29 29155         https://data.medicare.gov/resource/xubh-q36u/row-r644.jfav_m4mz 260070 650166 2019-06-03 2018-12-31 42 7         49 52       66     167
882 PIGGOTT COMMUNITY HOSPITAL 216 EAST MAIN STREET PIGGOTT AR 72454 CLAY (870) 598-3881 Critical Access Hospitals Government - Local TRUE 36.3820190 -90.1884430 0   21 5 5021         https://data.medicare.gov/resource/xubh-q36u/row-73yu_ywme-uu8m 41330 649163 2019-06-03 2018-12-31 25           25               25
1034 CIMARRON MEMORIAL HOSPITAL 100 SOUTH ELLIS BOISE CITY OK 73933 CIMARRON (580) 544-2501 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.7290550 -102.5175370 0   25 40 40025         https://data.medicare.gov/resource/xubh-q36u/row-9zte.pc9m_addj 371307 650201 2019-06-03 2018-12-31 25           25               25
4749 SENTARA NORFOLK GENERAL HOSPITAL 600 GRESHAM DR NORFOLK VA 23507 NORFOLK CITY (757) 388-3000 Acute Care Hospitals Voluntary non-profit - Other TRUE 36.8597280 -76.3048200 0   710 51 51710 47260 Virginia Beach-Norfolk, VA-NC Central Norfolk city https://data.medicare.gov/resource/xubh-q36u/row-r5z9-wxad_tcc7 490007 650916 2019-06-03 2018-12-31 381 44 10 16   20 471 34 22           527
4764 SENTARA VIRGINIA BEACH GENERAL HOSPITAL 1060 FIRST COLONIAL ROAD VIRGINIA BEACH VA 23454 VIRGINIA BEACH CITY (757) 395-8000 Acute Care Hospitals Voluntary non-profit - Other TRUE 36.8641580 -76.0283420 0   810 51 51810 47260 Virginia Beach-Norfolk, VA-NC Central Virginia Beach city https://data.medicare.gov/resource/xubh-q36u/row-sn9p~qwkm_5xtk 490057 650618 2019-06-03 2018-12-31 190 22 12     3 227 24 8           259
257 PAGE HOSPITAL 501 NORTH NAVAJO DRIVE PAGE AZ 86040 COCONINO (928) 645-2424 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.9169600 -111.4631860 0   5 4 4005 22380   Central Coconino County https://data.medicare.gov/resource/xubh-q36u/row-pwtm.vez8_t2h2 31304 649070 2019-06-03 2018-12-31 25           25               25
2845 SUTTER MATERNITY & SURGERY CENTER OF SANTA CRUZ 2900 CHANTICLEER AVENUE SANTA CRUZ CA 95065 SANTA CRUZ (831) 477-2200 Acute Care Hospitals Voluntary non-profit - Private FALSE 36.9878650 -121.9781800 0   87 6 6087 42100 San Jose-San Francisco-Oakland, CA Central Santa Cruz County https://data.medicare.gov/resource/xubh-q36u/row-m3f9-8jic~mqpk 50714 650660 2019-06-03 2018-12-31 30           30               30
4364 SUMNER COUNTY HOSPITAL DISTRICT NO 1 601 SOUTH OSAGE STREET CALDWELL KS 67022 SUMNER (620) 845-6492 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.0262800 -97.6096160 0   191 20 20191 48620 Wichita-Arkansas City-Winfield, KS Outlying Sumner County https://data.medicare.gov/resource/xubh-q36u/row-9v8g_4uhf~am74 171329 649593 2019-06-03 2018-12-31 25           25               25
1042 KANE COUNTY HOSPITAL 355 NORTH MAIN STREET KANAB UT 84741 KANE (435) 644-5811 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.0543240 -112.5285900 0   25 49 49025         https://data.medicare.gov/resource/xubh-q36u/row-g8j5_itr8_6iiy 461309 649842 2019-06-03 2018-12-31 25           25               25
1774 MEMORIAL HOSPITAL LOS BANOS 520 WEST I ST LOS BANOS CA 93635 MERCED (209) 826-0591 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.0634310 -120.8594070 0   47 6 6047 32900 Modesto-Merced, CA Central Merced County https://data.medicare.gov/resource/xubh-q36u/row-gm4t~nj6b~a4u2 50528 650957 2019-06-03 2018-12-31 36 4         40               40
4347 STEVENS COUNTY HOSPITAL 1006 S JACKSON HUGOTON KS 67951 STEVENS (620) 544-8511 Critical Access Hospitals Government - Local TRUE 37.1708080 -101.3497550 0   189 20 20189         https://data.medicare.gov/resource/xubh-q36u/row-39kr.3u54-pmuw 171335 649737 2019-06-03 2018-12-31 17           17           83   100
3594 MEADE DISTRICT HOSPITAL 510 EAST CARTHAGE MEADE KS 67864 MEADE (620) 873-2141 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.2854900 -100.3342670 0   119 20 20119         https://data.medicare.gov/resource/xubh-q36u/row-9yc7~mw74.3m9f 171321 649590 2019-06-03 2018-12-31 20           20           45   65
30 SOUTHSIDE COMMUNITY HOSPITAL, INC 800 OAK STREET FARMVILLE VA 23901 PRINCE EDWARD (434) 392-8811 Acute Care Hospitals Voluntary non-profit - Other TRUE 37.3033170 -78.4030580 0   147 51 51147         https://data.medicare.gov/resource/xubh-q36u/row-5efz.zpme_8ei2 490090 650408 2019-06-03 2018-12-31 78 8         86               86

Next page

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