hospital_data
Data source: Big Local News · About: big-local-datasette
37 rows where "filed_date" is on date 2019-06-03 and hospital_ownership = "Voluntary non-profit - Other"
This data as json, copyable, CSV (advanced)
Suggested facets: state, hospital_type, emergency_services, geocode_flag, geocode_accuracy, countyfips, statefips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, icu_beds, coronary_beds, burn_beds, surg_icu_beds, oth_spec_beds, subtotal_acute_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_beds, oth_longterm_beds, filed_date (date), fy_end_date (date)
Link | rowid ▼ | hospital_name | address | city | state | zip_code | county_name | phone_number | hospital_type | hospital_ownership | emergency_services | lat | lng | geocode_flag | geocode_accuracy | countyfips | statefips | statecountyfips | cbsacode | csatitle | centraloutlyingcounty | countyequivalent | hosp_lookup_url | PRVDR_NUM | RPT_REC_NUM | filed_date | fy_end_date | acute_beds | icu_beds | coronary_beds | burn_beds | surg_icu_beds | oth_spec_beds | subtotal_acute_beds | subprovider_ipf_beds | subprovider_irf_beds | subprovider_oth_beds | skilled_nursing_beds | nursing_fac_beds | oth_longterm_beds | hospice_beds | all_beds |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30 | 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 | ||||||||||||||||
46 | 46 | EDEN MEDICAL CENTER | 20103 LAKE CHABOT ROAD | CASTRO VALLEY | CA | 94546 | ALAMEDA | (510) 537-1234 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 37.6982685 | -122.0903131 | 1 | ROOFTOP | 1 | 6 | 6001 | 41860 | San Jose-San Francisco-Oakland, CA | Central | Alameda County | https://data.medicare.gov/resource/xubh-q36u/row-qpf5_ajfv~drq5 | 50488 | 650953 | 2019-06-03 | 2018-12-31 | 106 | 24 | 130 | 130 | |||||||||||
310 | 310 | UNIVERSITY HOSPITALS SAMARITAN MEDICAL CENTER | 1025 CENTER ST | ASHLAND | OH | 44805 | ASHLAND | (419) 289-0491 | Acute Care Hospitals | Voluntary non-profit - Other | FALSE | 40.8587020 | -82.3104130 | 0 | 5 | 39 | 39005 | 11740 | Mansfield-Ashland-Bucyrus, OH | Central | Ashland County | https://data.medicare.gov/resource/xubh-q36u/row-suim.pydj-jawn | 360002 | 649303 | 2019-06-03 | 2018-12-31 | 33 | 6 | 39 | 39 | ||||||||||||
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 | ||||||||||||
337 | 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 | |||||||||||||
378 | 378 | UNIVERSITY HOSPITALS CONNEAUT MEDICAL CENTER | 158 WEST MAIN ROAD | CONNEAUT | OH | 44030 | ASHTABULA | (440) 593-1131 | Critical Access Hospitals | Voluntary non-profit - Other | TRUE | 41.9369200 | -80.5864590 | 0 | 7 | 39 | 39007 | 11780 | Cleveland-Akron-Canton, OH | Central | Ashtabula County | https://data.medicare.gov/resource/xubh-q36u/row-j92a_zjx7-y5bm | 361308 | 649653 | 2019-06-03 | 2018-12-31 | 20 | 5 | 25 | 25 | ||||||||||||
392 | 392 | BENNETT COUNTY HOSPITAL AND NURSING HOME - CAH | 102 MAJOR ALLEN POST OFFICE BOX 70D | MARTIN | SD | 57551 | BENNETT | (605) 685-6622 | Critical Access Hospitals | Voluntary non-profit - Other | TRUE | 43.1691630 | -101.7266636 | 1 | RANGE_INTERPOLATED | 7 | 46 | 46007 | https://data.medicare.gov/resource/xubh-q36u/row-q2mg~bq2u~fi2w | 431314 | 649823 | 2019-06-03 | 2018-12-31 | 14 | 14 | 48 | 62 | |||||||||||||||
553 | 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 | ||||||||||
571 | 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 | |||||||||||||
640 | 640 | EAST OHIO REGIONAL HOSPITAL | 90 NORTH FOURTH STREET | MARTINS FERRY | OH | 43935 | BELMONT | (740) 633-4205 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 40.0986440 | -80.7208890 | 0 | 13 | 39 | 39013 | 48540 | Central | Belmont County | https://data.medicare.gov/resource/xubh-q36u/row-h333-qu75_kcna | 360080 | 649318 | 2019-06-03 | 2018-12-31 | 74 | 10 | 84 | 50 | 134 | ||||||||||||
881 | 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 | |||||||||||||
960 | 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 | ||||||||||||||
1347 | 1347 | ADIRONDACK MEDICAL CENTER - SARANAC LAKE | 2233 STATE ROUTE 86, PO BOX 471 | SARANAC LAKE | NY | 12983 | FRANKLIN | (518) 891-4141 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 44.3445480 | -74.1445970 | 0 | 33 | 36 | 36033 | 31660 | Central | Franklin County | https://data.medicare.gov/resource/xubh-q36u/row-7ubk-sp7w.3hyq | 330079 | 651024 | 2019-06-03 | 2018-12-31 | 75 | 8 | 83 | 12 | 60 | 155 | |||||||||||
1591 | 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 | ||||||||||||||
1635 | 1635 | NOVATO COMMUNITY HOSPITAL | 180 ROWLAND WAY | NOVATO | CA | 94945 | MARIN | (415) 209-1300 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 38.0980770 | -122.5596600 | 0 | 41 | 6 | 6041 | 41860 | San Jose-San Francisco-Oakland, CA | Central | Marin County | https://data.medicare.gov/resource/xubh-q36u/row-cbru_uws8_9g6e | 50131 | 650646 | 2019-06-03 | 2018-12-31 | 39 | 8 | 47 | 47 | ||||||||||||
1741 | 1741 | HAYES GREEN BEACH MEMORIAL HOSPITAL | 321 E HARRIS STREET | CHARLOTTE | MI | 48813 | EATON | (517) 543-1050 | Critical Access Hospitals | Voluntary non-profit - Other | TRUE | 42.5649280 | -84.8318260 | 0 | 45 | 26 | 26045 | 29620 | Lansing-East Lansing-Owosso, MI | Central | Eaton County | https://data.medicare.gov/resource/xubh-q36u/row-ty8n~pfwz_x66j | 231327 | 649907 | 2019-06-03 | 2018-12-31 | 25 | 25 | 25 | |||||||||||||
1821 | 1821 | NOVANT HEALTH UVA HEALTH SYSTEM CULPEPER MED CENTE | 501 SUNSET LANE | CULPEPER | VA | 22701 | CULPEPER | (540) 829-4100 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 38.4548480 | -78.0113050 | 0 | 47 | 51 | 51047 | 47900 | Washington-Baltimore-Arlington, DC-MD-VA-WV-PA | Outlying | Culpeper County | https://data.medicare.gov/resource/xubh-q36u/row-mbvh-ne84~5vxg | 490019 | 650389 | 2019-06-03 | 2018-12-31 | 64 | 6 | 70 | 70 | ||||||||||||
1895 | 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 | ||||||||||
1964 | 1964 | COOPER COUNTY COMMUNITY HOSPITAL | 17651 B HWY | BOONVILLE | MO | 65233 | COOPER | (660) 882-4100 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 38.9435330 | -92.7420750 | 0 | 53 | 29 | 29053 | https://data.medicare.gov/resource/xubh-q36u/row-b8m2_fqek~vure | 260004 | 649916 | 2019-06-03 | 2018-12-31 | 46 | 46 | 19 | 65 | ||||||||||||||||
2027 | 2027 | MONROE COMMUNITY HOSPITAL | 435 EAST HENRIETTA ROAD | ROCHESTER | NY | 14620 | MONROE | (585) 760-6500 | Acute Care Hospitals | Voluntary non-profit - Other | FALSE | 43.1118560 | -77.6160780 | 0 | 55 | 36 | 36055 | 40380 | Rochester-Batavia-Seneca Falls, NY | Central | Monroe County | https://data.medicare.gov/resource/xubh-q36u/row-5bf3_hk4u~74wb | 330403 | 651037 | 2019-06-03 | 2018-12-31 | 5 | 5 | 566 | 571 | ||||||||||||
2308 | 2308 | EDWARD W SPARROW HOSPITAL | 1215 E MICHIGAN AVENUE | LANSING | MI | 48912 | INGHAM | (517) 364-1000 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 42.7336090 | -84.5348160 | 0 | 65 | 26 | 26065 | 29620 | Lansing-East Lansing-Owosso, MI | Central | Ingham County | https://data.medicare.gov/resource/xubh-q36u/row-9z74.56x8-gaaq | 230230 | 650161 | 2019-06-03 | 2018-12-31 | 297 | 99 | 104 | 33 | 533 | 59 | 40 | 632 | ||||||||
2387 | 2387 | BANNER FORT COLLINS MEDICAL CENTER | 4700 LADY MOON DRIVE | FORT COLLINS | CO | 80528 | LARIMER | (970) 821-4000 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 40.5211170 | -105.0108850 | 0 | 69 | 8 | 8069 | 22660 | Central | Larimer County | https://data.medicare.gov/resource/xubh-q36u/row-t2c3_t3mg_dfjd | 60126 | 652186 | 2019-06-03 | 2018-12-31 | 23 | 23 | 23 | ||||||||||||||
2474 | 2474 | ST LUKE'S CORNWALL HOSPITAL | 70 DUBOIS STREET | NEWBURGH | NY | 12550 | ORANGE | (845) 561-4400 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 41.5037440 | -74.0151760 | 0 | 71 | 36 | 36071 | 35620 | New York-Newark, NY-NJ-CT-PA | Outlying | Orange County | https://data.medicare.gov/resource/xubh-q36u/row-4y2a-p7ka_jmg6 | 330264 | 651032 | 2019-06-03 | 2018-12-31 | 165 | 18 | 10 | 193 | 193 | |||||||||||
2522 | 2522 | LINCOLN COMMUNITY HOSPITAL | 111 6TH ST | HUGO | CO | 80821 | LINCOLN | (719) 743-2421 | Critical Access Hospitals | Voluntary non-profit - Other | TRUE | 39.1376600 | -103.4731590 | 0 | 73 | 8 | 8073 | https://data.medicare.gov/resource/xubh-q36u/row-ur8w~xce7~5xe9 | 61306 | 651191 | 2019-06-03 | 2018-12-31 | 15 | 15 | 35 | 50 | ||||||||||||||||
2543 | 2543 | HOCKING VALLEY COMMUNITY HOSPITAL | 601 STATE ROUTE 664N | LOGAN | OH | 43138 | HOCKING | (740) 380-8227 | Critical Access Hospitals | Voluntary non-profit - Other | TRUE | 39.5475040 | -82.4285180 | 0 | 73 | 39 | 39073 | 18140 | Columbus-Marion-Zanesville, OH | Outlying | Hocking County | https://data.medicare.gov/resource/xubh-q36u/row-4idp_5ask.rtvw | 361330 | 649656 | 2019-06-03 | 2018-12-31 | 21 | 4 | 25 | 10 | 35 | |||||||||||
2565 | 2565 | CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP | 601 DUBOCE AVENUE | SAN FRANCISCO | CA | 94117 | SAN FRANCISCO | (415) 600-6000 | Acute Care Hospitals | Voluntary non-profit - Other | FALSE | 37.7691140 | -122.4346960 | 0 | 75 | 6 | 6075 | 41860 | San Jose-San Francisco-Oakland, CA | Central | San Francisco County | https://data.medicare.gov/resource/xubh-q36u/row-6wq8_65ym~23y8 | 50008 | 651170 | 2019-06-03 | 2018-12-31 | 129 | 8 | 137 | 48 | 38 | 223 | ||||||||||
2573 | 2573 | HENRY FORD ALLEGIANCE HEALTH | 205 N EAST AVE | JACKSON | MI | 49201 | JACKSON | (517) 788-4800 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 42.2503560 | -84.3936030 | 0 | 75 | 26 | 26075 | 27100 | Central | Jackson County | https://data.medicare.gov/resource/xubh-q36u/row-3qhp-255z.2v6t | 230092 | 650158 | 2019-06-03 | 2018-12-31 | 262 | 34 | 17 | 313 | 40 | 353 | |||||||||||
2863 | 2863 | NYACK HOSPITAL | 160 NORTH MIDLAND AVENUE | NYACK | NY | 10960 | ROCKLAND | (845) 348-2000 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 41.0952510 | -73.9252530 | 0 | 87 | 36 | 36087 | 35620 | New York-Newark, NY-NJ-CT-PA | Central | Rockland County | https://data.medicare.gov/resource/xubh-q36u/row-5nre.azih-h35v | 330104 | 650863 | 2019-06-03 | 2018-12-31 | 199 | 10 | 209 | 26 | 235 | |||||||||||
3079 | 3079 | SUTTER SANTA ROSA REGIONAL HOSPITAL | 30 MARK WEST SPRINGS ROAD | SANTA ROSA | CA | 95403 | SONOMA | (707) 576-4000 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 38.4963060 | -122.7507070 | 0 | 97 | 6 | 6097 | 42220 | San Jose-San Francisco-Oakland, CA | Central | Sonoma County | https://data.medicare.gov/resource/xubh-q36u/row-cm5t.k3eb~48rb | 50291 | 650648 | 2019-06-03 | 2018-12-31 | 60 | 12 | 12 | 84 | 84 | |||||||||||
3574 | 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 | |||||||||||||||||
4045 | 4045 | AULTMAN HOSPITAL | 2600 SIXTH STREET SW | CANTON | OH | 44710 | STARK | (330) 363-6352 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 40.7968520 | -81.4035750 | 0 | 151 | 39 | 39151 | 15940 | Cleveland-Akron-Canton, OH | Central | Stark County | https://data.medicare.gov/resource/xubh-q36u/row-skwz~ncuf-62nj | 360084 | 649319 | 2019-06-03 | 2018-12-31 | 333 | 20 | 26 | 18 | 422 | 30 | 60 | 512 | ||||||||
4047 | 4047 | ALLIANCE COMMUNITY HOSPITAL | 200 EAST STATE STREET | ALLIANCE | OH | 44601 | STARK | (330) 596-7018 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 40.9016790 | -81.1027360 | 0 | 151 | 39 | 39151 | 15940 | Cleveland-Akron-Canton, OH | Central | Stark County | https://data.medicare.gov/resource/xubh-q36u/row-9pb7.6hrh_xxpz | 360131 | 649642 | 2019-06-03 | 2018-12-31 | 43 | 12 | 55 | 12 | 78 | 145 | ||||||||||
4394 | 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 | ||||||||||||
4472 | 4472 | TEXAS COUNTY MEMORIAL HOSPITAL | 1333 SAM HOUSTON BOULEVARD | HOUSTON | MO | 65483 | TEXAS | (417) 967-3311 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 37.3157560 | -91.9595590 | 0 | 215 | 29 | 29215 | https://data.medicare.gov/resource/xubh-q36u/row-f27e-vv7h.kacf | 260024 | 649919 | 2019-06-03 | 2018-12-31 | 43 | 4 | 47 | 47 | ||||||||||||||||
4728 | 4728 | BARNES JEWISH HOSPITAL | ONE BARNES-JEWISH HOSPITAL PLAZA | SAINT LOUIS | MO | 63110 | ST. LOUIS CITY | (314) 747-3000 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 38.6352633 | -90.2650260 | 1 | ROOFTOP | 510 | 29 | 29510 | 41180 | St. Louis-St. Charles-Farmington, MO-IL | Central | St. Louis city | https://data.medicare.gov/resource/xubh-q36u/row-xqm2.gcb3.jvqi | 260032 | 650284 | 2019-06-03 | 2018-12-31 | 1106 | 65 | 15 | 36 | 1272 | 96 | 1368 | ||||||||
4749 | 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 | 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 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [hospital_data] ( [hospital_name] TEXT, [address] TEXT, [city] TEXT, [state] TEXT, [zip_code] INTEGER, [county_name] TEXT, [phone_number] TEXT, [hospital_type] TEXT, [hospital_ownership] TEXT, [emergency_services] TEXT, [lat] TEXT, [lng] TEXT, [geocode_flag] INTEGER, [geocode_accuracy] TEXT, [countyfips] INTEGER, [statefips] INTEGER, [statecountyfips] INTEGER, [cbsacode] TEXT, [csatitle] TEXT, [centraloutlyingcounty] TEXT, [countyequivalent] TEXT, [hosp_lookup_url] TEXT, [PRVDR_NUM] INTEGER, [RPT_REC_NUM] INTEGER, [filed_date] TEXT, [fy_end_date] TEXT, [acute_beds] INTEGER, [icu_beds] TEXT, [coronary_beds] TEXT, [burn_beds] TEXT, [surg_icu_beds] TEXT, [oth_spec_beds] TEXT, [subtotal_acute_beds] INTEGER, [subprovider_ipf_beds] TEXT, [subprovider_irf_beds] TEXT, [subprovider_oth_beds] TEXT, [skilled_nursing_beds] TEXT, [nursing_fac_beds] TEXT, [oth_longterm_beds] TEXT, [hospice_beds] TEXT, [all_beds] INTEGER );