hospital_data
Data source: Big Local News · About: big-local-datasette
34 rows where "filed_date" is on date 2019-11-27 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, acute_beds, 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, all_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12 | 12 | CLARKE COUNTY HOSPITAL | 800 S FILLMORE ST | OSCEOLA | IA | 50213 | CLARKE | (641) 342-2184 | Critical Access Hospitals | Voluntary non-profit - Other | TRUE | 41.0257100 | -93.7675330 | 0 | 39 | 19 | 19039 | https://data.medicare.gov/resource/xubh-q36u/row-xtat~vhgt.9ane | 161348 | 660976 | 2019-11-27 | 2019-06-30 | 25 | 25 | 25 | |||||||||||||||||
72 | 72 | MEDSTAR WASHINGTON HOSPITAL CENTER | 110 IRVING ST NW | WASHINGTON | DC | 20010 | THE DISTRICT | (202) 877-7000 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 38.9291570 | -77.0122680 | 0 | 1 | 11 | 11001 | 47900 | Washington-Baltimore-Arlington, DC-MD-VA-WV-PA | Central | District of Columbia | https://data.medicare.gov/resource/xubh-q36u/row-he3p~gtzx-x7j5 | 90011 | 660787 | 2019-11-27 | 2019-06-30 | 569 | 37 | 16 | 55 | 701 | 46 | 747 | |||||||||
73 | 73 | SIBLEY MEMORIAL HOSPITAL | 5255 LOUGHBORO RD NW | WASHINGTON | DC | 20016 | THE DISTRICT | (202) 537-4680 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 38.9357470 | -77.1098890 | 0 | 1 | 11 | 11001 | 47900 | Washington-Baltimore-Arlington, DC-MD-VA-WV-PA | Central | District of Columbia | https://data.medicare.gov/resource/xubh-q36u/row-yqpq-7pu8-v5vj | 90005 | 660786 | 2019-11-27 | 2019-06-30 | 150 | 25 | 14 | 189 | 21 | 45 | 255 | |||||||||
227 | 227 | MAGEE WOMENS HOSPITAL OF UPMC HEALTH SYSTEM | 300 HALKET STREET | PITTSBURGH | PA | 15213 | ALLEGHENY | (412) 641-4010 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 40.4370770 | -79.9595460 | 0 | 3 | 42 | 42003 | 38300 | Pittsburgh-New Castle-Weirton, PA-OH-WV | Central | Allegheny County | https://data.medicare.gov/resource/xubh-q36u/row-tusn~f4sz~kzrq | 390114 | 660858 | 2019-11-27 | 2019-06-30 | 220 | 18 | 315 | 20 | 335 | |||||||||||
332 | 332 | CUMBERLAND MEMORIAL HOSPITAL | 1110 7TH AVENUE | CUMBERLAND | WI | 54829 | BARRON | (715) 822-7500 | Critical Access Hospitals | Voluntary non-profit - Other | TRUE | 45.5309390 | -92.0295920 | 0 | 5 | 55 | 55005 | https://data.medicare.gov/resource/xubh-q36u/row-r4fu_4cy5~ir4d | 521353 | 661689 | 2019-11-27 | 2019-06-30 | 25 | 25 | 25 | |||||||||||||||||
532 | 532 | READING HOSPITAL | 420 S 5TH AVENUE | WEST READING | PA | 19611 | BERKS | (610) 988-8000 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 40.3298630 | -75.9480590 | 0 | 11 | 42 | 42011 | 39740 | Philadelphia-Reading-Camden, PA-NJ-DE-MD | Central | Berks County | https://data.medicare.gov/resource/xubh-q36u/row-rf2n_5umm~j8bk | 390044 | 659867 | 2019-11-27 | 2019-06-30 | 491 | 20 | 21 | 30 | 562 | 50 | 62 | 50 | 724 | |||||||
818 | 818 | ORANGE PARK MEDICAL CENTER | 2001 KINGSLEY AVE | ORANGE PARK | FL | 32073 | CLAY | (904) 276-8500 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 30.1648070 | -81.7385980 | 0 | 19 | 12 | 12019 | 27260 | Jacksonville-St. Marys-Palatka, FL-GA | Central | Clay County | https://data.medicare.gov/resource/xubh-q36u/row-wsf2~ud7b_znaf | 100226 | 660500 | 2019-11-27 | 2019-06-30 | 229 | 28 | 273 | 24 | 20 | 317 | ||||||||||
824 | 824 | BUCHANAN COUNTY HEALTH CENTER | 1600 FIRST ST EAST | INDEPENDENCE | IA | 50644 | BUCHANAN | (319) 332-0999 | Critical Access Hospitals | Voluntary non-profit - Other | TRUE | 42.4687870 | -91.8750150 | 0 | 19 | 19 | 19019 | https://data.medicare.gov/resource/xubh-q36u/row-cq2e.inyq-2gxf | 161335 | 660969 | 2019-11-27 | 2019-06-30 | 25 | 25 | 39 | 64 | ||||||||||||||||
870 | 870 | ASCENSION OUR LADY OF VICTORY HOSPITAL | 1120 PINE ST | STANLEY | WI | 54768 | CHIPPEWA | (715) 644-5571 | Critical Access Hospitals | Voluntary non-profit - Other | TRUE | 44.9553110 | -90.9205640 | 0 | 19 | 55 | 55019 | https://data.medicare.gov/resource/xubh-q36u/row-xzzk-sbky-rj53 | 521311 | 661445 | 2019-11-27 | 2019-06-30 | 24 | 24 | 24 | |||||||||||||||||
1142 | 1142 | MUNSON HEALTHCARE CHARLEVOIX HOSPITAL | 14700 LAKESHORE DRIVE | CHARLEVOIX | MI | 49720 | CHARLEVOIX | (231) 547-4024 | Critical Access Hospitals | Voluntary non-profit - Other | TRUE | 45.3144980 | -85.2748510 | 1 | ROOFTOP | 29 | 26 | 26029 | https://data.medicare.gov/resource/xubh-q36u/row-cdsd.f9cx_c7j8 | 231322 | 660601 | 2019-11-27 | 2019-06-30 | 25 | 25 | 25 | ||||||||||||||||
1168 | 1168 | JENNERSVILLE HOSPITAL | 1015 WEST BALTIMORE PIKE | WEST GROVE | PA | 19390 | CHESTER | (610) 869-1000 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 39.8227440 | -75.8879180 | 0 | 29 | 42 | 42029 | 37980 | Philadelphia-Reading-Camden, PA-NJ-DE-MD | Central | Chester County | https://data.medicare.gov/resource/xubh-q36u/row-gfcj_eve8~h6ap | 390220 | 660700 | 2019-11-27 | 2019-06-30 | 43 | 10 | 53 | 53 | ||||||||||||
1393 | 1393 | MIDMICHIGAN MEDICAL CENTER-CLARE | 703 N MCEWAN ST | CLARE | MI | 48617 | CLARE | (989) 802-5000 | Acute Care Hospitals | Voluntary non-profit - Other | FALSE | 43.8207240 | -84.7683490 | 0 | 35 | 26 | 26035 | https://data.medicare.gov/resource/xubh-q36u/row-x95c-xq2z-tjc4 | 230180 | 661013 | 2019-11-27 | 2019-06-30 | 49 | 49 | 49 | |||||||||||||||||
1461 | 1461 | MEMORIAL CARE MILLER CHILDREN'S & WOMEN'S HOSP LB | 2801 ATLANTIC AVENUE | LONG BEACH | CA | 90806 | LOS ANGELES | (562) 933-8001 | Childrens | Voluntary non-profit - Other | FALSE | 33.8071070 | -118.1850980 | 0 | 37 | 6 | 6037 | 31080 | Los Angeles-Long Beach, CA | Central | Los Angeles County | https://data.medicare.gov/resource/xubh-q36u/row-khay_hirb.gvkk | 53309 | 662488 | 2019-11-27 | 2019-06-30 | 232 | 30 | 95 | 357 | 357 | |||||||||||
1509 | 1509 | LONG BEACH MEMORIAL MEDICAL CENTER | 2801 ATLANTIC AVE | LONG BEACH | CA | 90806 | LOS ANGELES | (562) 933-2000 | Acute Care Hospitals | Voluntary non-profit - Other | FALSE | 33.8071070 | -118.1850980 | 0 | 37 | 6 | 6037 | 31080 | Los Angeles-Long Beach, CA | Central | Los Angeles County | https://data.medicare.gov/resource/xubh-q36u/row-t622~cs4c.w4nt | 50485 | 662164 | 2019-11-27 | 2019-06-30 | 309 | 60 | 369 | 42 | 42 | 453 | ||||||||||
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 | ||||||
1894 | 1894 | CANDLER HOSPITAL | 5353 REYNOLDS STREET | SAVANNAH | GA | 31412 | CHATHAM | (912) 819-6000 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 32.0273610 | -81.1017310 | 0 | 51 | 13 | 13051 | 42340 | Savannah-Hinesville-Statesboro, GA | Central | Chatham County | https://data.medicare.gov/resource/xubh-q36u/row-cmu8.t2da.4a2c | 110024 | 659932 | 2019-11-27 | 2019-06-30 | 192 | 20 | 212 | 23 | 11 | 246 | ||||||||||
2012 | 2012 | MUNSON MEDICAL CENTER | 1105 SIXTH STREET | TRAVERSE CITY | MI | 49684 | GRAND TRAVERSE | (231) 935-5000 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 44.7616450 | -85.6415880 | 0 | 55 | 26 | 26055 | 45900 | Central | Grand Traverse County | https://data.medicare.gov/resource/xubh-q36u/row-ytzp_khah~df5e | 230097 | 660589 | 2019-11-27 | 2019-06-30 | 377 | 20 | 409 | 17 | 16 | 442 | |||||||||||
2147 | 2147 | UNION COUNTY GENERAL HOSPITAL | 300 WILSON STREET | CLAYTON | NM | 88415 | UNION | (575) 374-7001 | Critical Access Hospitals | Voluntary non-profit - Other | TRUE | 36.4551690 | -103.1932600 | 0 | 59 | 35 | 35059 | https://data.medicare.gov/resource/xubh-q36u/row-ai6a~bn84~9pvi | 321304 | 660831 | 2019-11-27 | 2019-06-30 | 25 | 25 | 25 | |||||||||||||||||
2350 | 2350 | FLOYD COUNTY MEDICAL CENTER | 800 11TH ST | CHARLES CITY | IA | 50616 | FLOYD | (641) 228-6830 | Critical Access Hospitals | Voluntary non-profit - Other | TRUE | 43.0526670 | -92.6825050 | 0 | 67 | 19 | 19067 | https://data.medicare.gov/resource/xubh-q36u/row-wh9h~5vd4_p9gh | 161347 | 660975 | 2019-11-27 | 2019-06-30 | 25 | 25 | 25 | |||||||||||||||||
2510 | 2510 | UC SAN DIEGO HEALTH HILLCREST - HILLCREST MED CTR | 200 WEST ARBOR DRIVE | SAN DIEGO | CA | 92103 | SAN DIEGO | (619) 543-6222 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 32.7537170 | -117.1659140 | 0 | 73 | 6 | 6073 | 41740 | Central | San Diego County | https://data.medicare.gov/resource/xubh-q36u/row-2d2j.kc8f_hnd2 | 50025 | 662154 | 2019-11-27 | 2019-06-30 | 513 | 46 | 8 | 50 | 52 | 669 | 32 | 701 | |||||||||
2558 | 2558 | UCSF MEDICAL CENTER | 505 PARNASSUS AVE, BOX 0296 | SAN FRANCISCO | CA | 94143 | SAN FRANCISCO | (415) 353-2733 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 37.7635530 | -122.4576540 | 0 | 75 | 6 | 6075 | 41860 | San Jose-San Francisco-Oakland, CA | Central | San Francisco County | https://data.medicare.gov/resource/xubh-q36u/row-cmdw-2w9d~vag6 | 50454 | 662027 | 2019-11-27 | 2019-06-30 | 579 | 106 | 26 | 16 | 785 | 785 | ||||||||||
2791 | 2791 | TWIN LAKES REGIONAL MEDICAL CENTER | 910 WALLACE AVENUE | LEITCHFIELD | KY | 42754 | GRAYSON | (270) 259-9400 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 37.4719470 | -86.2870380 | 0 | 85 | 21 | 21085 | https://data.medicare.gov/resource/xubh-q36u/row-me6k_7rgh~hwhf | 180070 | 660561 | 2019-11-27 | 2019-06-30 | 69 | 6 | 75 | 75 | ||||||||||||||||
2997 | 2997 | SAINT JOSEPH MERCY LIVINGSTON HOSPITAL | 620 BYRON RD | HOWELL | MI | 48843 | LIVINGSTON | (517) 545-6000 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 42.6153720 | -83.9393550 | 0 | 93 | 26 | 26093 | 19820 | Detroit-Warren-Ann Arbor, MI | Outlying | Livingston County | https://data.medicare.gov/resource/xubh-q36u/row-ij59~ym6m-2dbe | 230069 | 660584 | 2019-11-27 | 2019-06-30 | 35 | 8 | 43 | 43 | ||||||||||||
3041 | 3041 | HARLAN ARH HOSPITAL | 81 BALL PARK ROAD | HARLAN | KY | 40831 | HARLAN | (606) 573-8100 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 36.8101830 | -83.3131050 | 0 | 95 | 21 | 21095 | https://data.medicare.gov/resource/xubh-q36u/row-yegj_y2j5.e33p | 180050 | 660559 | 2019-11-27 | 2019-06-30 | 74 | 7 | 81 | 30 | 111 | |||||||||||||||
3081 | 3081 | PETALUMA VALLEY HOSPITAL | 400 N MCDOWELL BLVD | PETALUMA | CA | 94954 | SONOMA | (707) 778-1111 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 38.2531830 | -122.6328600 | 0 | 97 | 6 | 6097 | 42220 | San Jose-San Francisco-Oakland, CA | Central | Sonoma County | https://data.medicare.gov/resource/xubh-q36u/row-bfnf_4u5r~hdm4 | 50136 | 662019 | 2019-11-27 | 2019-06-30 | 71 | 9 | 80 | 80 | ||||||||||||
3206 | 3206 | MUNSON HEALTHCARE MANISTEE HOSPITAL | 1465 E PARKDALE AVE | MANISTEE | MI | 49660 | MANISTEE | (231) 398-1000 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 44.2723550 | -86.2734390 | 0 | 101 | 26 | 26101 | https://data.medicare.gov/resource/xubh-q36u/row-yvaj-xucr.6ih7 | 230303 | 660597 | 2019-11-27 | 2019-06-30 | 45 | 45 | 45 | |||||||||||||||||
3538 | 3538 | INTEGRIS MIAMI HOSPITAL | 200 SECOND AVENUE SOUTHWEST | MIAMI | OK | 74355 | OTTAWA | (918) 542-6611 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 36.8721540 | -94.8797720 | 0 | 115 | 40 | 40115 | 33060 | Joplin-Miami, MO-OK | Central | Ottawa County | https://data.medicare.gov/resource/xubh-q36u/row-juye_fwj7_x4b6 | 370004 | 660423 | 2019-11-27 | 2019-06-30 | 85 | 9 | 94 | 20 | 114 | |||||||||||
3622 | 3622 | EVANGELICAL COMMUNITY HOSPITAL | ONE HOSPITAL DRIVE | LEWISBURG | PA | 17837 | UNION | (570) 522-2200 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 40.9793187 | -76.8875496 | 1 | ROOFTOP | 119 | 42 | 42119 | 30260 | Bloomsburg-Berwick-Sunbury, PA | Central | Union County | https://data.medicare.gov/resource/xubh-q36u/row-mc97-igzf~6yka | 390013 | 660009 | 2019-11-27 | 2019-06-30 | 111 | 12 | 123 | 9 | 132 | ||||||||||
3802 | 3802 | SACRED HEART HOSPITAL ON THE EMERALD COAST | 7800 US HWY 98 W | MIRAMAR BEACH | FL | 32550 | WALTON | (850) 278-3600 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 30.3768190 | -86.3068230 | 0 | 131 | 12 | 12131 | 18880 | Central | Walton County | https://data.medicare.gov/resource/xubh-q36u/row-ucsd-9wwf_zg78 | 100292 | 660193 | 2019-11-27 | 2019-06-30 | 40 | 22 | 62 | 62 | |||||||||||||
3990 | 3990 | SOUTHERN OHIO MEDICAL CENTER | 1805 27TH STREET | PORTSMOUTH | OH | 45662 | SCIOTO | (740) 356-5000 | Acute Care Hospitals | Voluntary non-profit - Other | FALSE | 38.7539130 | -82.9778320 | 0 | 145 | 39 | 39145 | 39020 | Charleston-Huntington-Ashland, WV-OH-KY | Central | Scioto County | https://data.medicare.gov/resource/xubh-q36u/row-52pr_re6y~4mrz | 360008 | 660661 | 2019-11-27 | 2019-06-30 | 176 | 16 | 192 | 21 | 12 | 225 | ||||||||||
4184 | 4184 | HARRISBURG MEDICAL CENTER | 100 DOCTOR WARREN TUTTLE DR | HARRISBURG | IL | 62946 | SALINE | (618) 253-7671 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 37.7310271 | -88.5248600 | 1 | ROOFTOP | 165 | 17 | 17165 | https://data.medicare.gov/resource/xubh-q36u/row-8u5r_n3xt~tnqf | 140210 | 660516 | 2019-11-27 | 2019-06-30 | 40 | 40 | 30 | 70 | |||||||||||||||
4300 | 4300 | WAYNE MEDICAL CENTER | 103 J V MANGUBAT DR | WAYNESBORO | TN | 38485 | WAYNE | (931) 722-5411 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 35.3253550 | -87.7575330 | 0 | 181 | 47 | 47181 | https://data.medicare.gov/resource/xubh-q36u/row-283m~szqb.wyui | 440010 | 660038 | 2019-11-27 | 2019-06-30 | 30 | 30 | 30 | |||||||||||||||||
4489 | 4489 | WELLSTAR PAULDING HOSPITAL | 2518 JIMMY LEE SMITH PARKWAY | HIRAM | GA | 30141 | PAULDING | (470) 644-7000 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 33.9024290 | -84.7827270 | 0 | 223 | 13 | 13223 | 12060 | Atlanta--Athens-Clarke County--Sandy Springs, GA | Central | Paulding County | https://data.medicare.gov/resource/xubh-q36u/row-e36y~9j3e~pmmm | 110042 | 659934 | 2019-11-27 | 2019-06-30 | 104 | 8 | 112 | 182 | 294 | |||||||||||
4685 | 4685 | CITIZENS MEDICAL CENTER | 2701 HOSPITAL DRIVE | VICTORIA | TX | 77901 | VICTORIA | (361) 573-9181 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 28.8131570 | -96.9767590 | 0 | 469 | 48 | 48469 | 47020 | Victoria-Port Lavaca, TX | Central | Victoria County | https://data.medicare.gov/resource/xubh-q36u/row-qzne~ijre-g2v9 | 450023 | 659729 | 2019-11-27 | 2019-06-30 | 285 | 14 | 8 | 307 | 20 | 327 |
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 );