hospital_data
Data source: Big Local News · About: big-local-datasette
32 rows where centraloutlyingcounty = "Central" and "filed_date" is on date 2019-11-22
This data as json, copyable, CSV (advanced)
Suggested facets: city, state, county_name, hospital_ownership, emergency_services, countyfips, statefips, statecountyfips, cbsacode, csatitle, countyequivalent, fy_end_date, icu_beds, coronary_beds, surg_icu_beds, oth_spec_beds, subtotal_acute_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 237 | 237 | UPMC ST MARGARET | 815 FREEPORT ROAD | PITTSBURGH | PA | 15215 | ALLEGHENY | (412) 784-4000 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 40.4874720 | -79.8960380 | 0 | 3 | 42 | 42003 | 38300 | Pittsburgh-New Castle-Weirton, PA-OH-WV | Central | Allegheny County | https://data.medicare.gov/resource/xubh-q36u/row-iz5k~fx5f.72zy | 390102 | 660441 | 2019-11-22 | 2019-06-30 | 208 | 14 | 222 | 28 | 250 | |||||||||||
| 786 | 786 | GRAND VIEW HOSPITAL | 700 LAWN AVENUE | SELLERSVILLE | PA | 18960 | BUCKS | (215) 453-4615 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 40.3625670 | -75.3241690 | 0 | 17 | 42 | 42017 | 37980 | Philadelphia-Reading-Camden, PA-NJ-DE-MD | Central | Bucks County | https://data.medicare.gov/resource/xubh-q36u/row-8e5m_vbcg_jbzn | 390057 | 659719 | 2019-11-22 | 2019-06-30 | 142 | 14 | 162 | 14 | 176 | |||||||||||
| 855 | 855 | MERCY MEDICAL CENTER | 2700 NW STEWART PARKWAY | ROSEBURG | OR | 97471 | DOUGLAS | (541) 673-0611 | Acute Care Hospitals | Government - Hospital District or Authority | TRUE | 43.2368240 | -123.3716040 | 0 | 19 | 41 | 41019 | 40700 | Central | Douglas County | https://data.medicare.gov/resource/xubh-q36u/row-kmh5-zbwa-3mz2 | 380027 | 659601 | 2019-11-22 | 2019-06-30 | 108 | 32 | 140 | 140 | |||||||||||||
| 863 | 863 | SYCAMORE SHOALS HOSPITAL | 1501 WEST ELK AVENUE | ELIZABETHTON | TN | 37643 | CARTER | (423) 542-1300 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 36.3439410 | -82.2496230 | 0 | 19 | 47 | 47019 | 27740 | Johnson City-Kingsport-Bristol, TN-VA | Central | Carter County | https://data.medicare.gov/resource/xubh-q36u/row-sski_7z8j~5bzg | 440018 | 660039 | 2019-11-22 | 2019-06-30 | 101 | 8 | 109 | 12 | 121 | |||||||||||
| 1119 | 1119 | BEAVER DAM COMMUNITY HOSPITAL | 707 S UNIVERSITY AVE | BEAVER DAM | WI | 53916 | DODGE | (920) 887-7181 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 43.4484770 | -88.8281970 | 0 | 27 | 55 | 55027 | 13180 | Milwaukee-Racine-Waukesha, WI | Central | Dodge County | https://data.medicare.gov/resource/xubh-q36u/row-y2kp~hptd-k6ec | 520076 | 659553 | 2019-11-22 | 2019-06-30 | 119 | 6 | 125 | 115 | 240 | |||||||||||
| 1177 | 1177 | METHODIST HOSPITAL | 7700 FLOYD CURL DR | SAN ANTONIO | TX | 78229 | BEXAR | (210) 575-4000 | Acute Care Hospitals | Proprietary | TRUE | 29.5068400 | -98.5729760 | 0 | 29 | 48 | 48029 | 41700 | Central | Bexar County | https://data.medicare.gov/resource/xubh-q36u/row-xgb9_6gfp~4v63 | 450388 | 659736 | 2019-11-22 | 2019-06-30 | 1223 | 207 | 110 | 1560 | 10 | 67 | 1637 | ||||||||||
| 1235 | 1235 | LORETTO HOSPITAL | 645 SOUTH CENTRAL AVE | CHICAGO | IL | 60644 | COOK | (773) 626-4300 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 41.8720420 | -87.7644430 | 0 | 31 | 17 | 17031 | 16980 | Chicago-Naperville, IL-IN-WI | Central | Cook County | https://data.medicare.gov/resource/xubh-q36u/row-g4dy-29n9_g2wy | 140083 | 659947 | 2019-11-22 | 2019-06-30 | 110 | 12 | 122 | 122 | ||||||||||||
| 1430 | 1430 | CUMBERLAND MEDICAL CENTER | 421 S MAIN ST | CROSSVILLE | TN | 38555 | CUMBERLAND | (931) 484-9511 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 35.9427130 | -85.0230070 | 0 | 35 | 47 | 47035 | 18900 | Central | Cumberland County | https://data.medicare.gov/resource/xubh-q36u/row-8st6_g3vp.a2j7 | 440009 | 659449 | 2019-11-22 | 2019-06-30 | 61 | 12 | 73 | 73 | |||||||||||||
| 1659 | 1659 | GRADY MEMORIAL HOSPITAL | 561 WEST CENTRAL AVENUE | DELAWARE | OH | 43015 | DELAWARE | (740) 368-5145 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 40.3060090 | -83.0887260 | 0 | 41 | 39 | 39041 | 18140 | Columbus-Marion-Zanesville, OH | Central | Delaware County | https://data.medicare.gov/resource/xubh-q36u/row-5s7k.v9f3~w2pv | 360210 | 661609 | 2019-11-22 | 2019-06-30 | 58 | 6 | 64 | 64 | ||||||||||||
| 1865 | 1865 | DUBLIN METHODIST HOSPITAL | 7500 HOSPITAL AVENUE | DUBLIN | OH | 43016 | FRANKLIN | (614) 544-8000 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 40.1004050 | -83.1630550 | 0 | 49 | 39 | 39049 | 18140 | Columbus-Marion-Zanesville, OH | Central | Franklin County | https://data.medicare.gov/resource/xubh-q36u/row-778y~b337.x73k | 360348 | 659843 | 2019-11-22 | 2019-06-30 | 102 | 102 | 102 | |||||||||||||
| 1923 | 1923 | OHSU HOSPITAL AND CLINICS | 3181 SW SAM JACKSON PARK ROAD | PORTLAND | OR | 97239 | MULTNOMAH | (503) 494-6245 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 45.4992010 | -122.6879740 | 0 | 51 | 41 | 41051 | 38900 | Portland-Vancouver-Salem, OR-WA | Central | Multnomah County | https://data.medicare.gov/resource/xubh-q36u/row-yk4c-r5a6.3wkx | 380009 | 660008 | 2019-11-22 | 2019-06-30 | 417 | 79 | 562 | 562 | ||||||||||||
| 2061 | 2061 | ST VINCENT HEART CENTER OF INDIANA LLC | 10580 N MERIDIAN ST | INDIANAPOLIS | IN | 46290 | HAMILTON | (317) 583-5000 | Acute Care Hospitals | Proprietary | TRUE | 39.9383110 | -86.1587220 | 0 | 57 | 18 | 18057 | 26900 | Indianapolis-Carmel-Muncie, IN | Central | Hamilton County | https://data.medicare.gov/resource/xubh-q36u/row-w7fb_red4.4uti | 150153 | 659784 | 2019-11-22 | 2019-06-30 | 107 | 107 | 107 | |||||||||||||
| 2134 | 2134 | PIEDMONT ATHENS REGIONAL MEDICAL CENTER | 1199 PRINCE AVENUE | ATHENS | GA | 30606 | CLARKE | (706) 475-7000 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 33.9623770 | -83.3977330 | 0 | 59 | 13 | 13059 | 12020 | Atlanta--Athens-Clarke County--Sandy Springs, GA | Central | Clarke County | https://data.medicare.gov/resource/xubh-q36u/row-599w-riw6~r6rq | 110074 | 659937 | 2019-11-22 | 2019-06-30 | 301 | 24 | 12 | 20 | 357 | 357 | ||||||||||
| 2166 | 2166 | GREENEVILLE COMMUNITY HOSPITAL | 1420 TUSCULUM BOULEVARD | GREENEVILLE | TN | 37745 | GREENE | (423) 639-3151 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 36.1753930 | -82.7908930 | 0 | 59 | 47 | 47059 | 24620 | Central | Greene County | https://data.medicare.gov/resource/xubh-q36u/row-mxnu-nrwk~z6fa | 440050 | 660041 | 2019-11-22 | 2019-06-30 | 42 | 7 | 49 | 14 | 11 | 23 | 97 | ||||||||||
| 2213 | 2213 | BETHESDA NORTH | 10500 MONTGOMERY ROAD | CINCINNATI | OH | 45242 | HAMILTON | (513) 865-1241 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 39.2519680 | -84.3439860 | 0 | 61 | 39 | 39061 | 17140 | Cincinnati-Wilmington-Maysville, OH-KY-IN | Central | Hamilton County | https://data.medicare.gov/resource/xubh-q36u/row-a8wv_rfph_hrmf | 360179 | 659842 | 2019-11-22 | 2019-06-30 | 327 | 38 | 365 | 365 | ||||||||||||
| 2216 | 2216 | TRIHEALTH EVENDALE HOSPITAL | 3155 GLENDALE MILFORD ROAD | CINCINNATI | OH | 45241 | HAMILTON | (513) 454-2222 | Acute Care Hospitals | Voluntary non-profit - Private | FALSE | 39.2539140 | -84.4198340 | 0 | 61 | 39 | 39061 | 17140 | Cincinnati-Wilmington-Maysville, OH-KY-IN | Central | Hamilton County | https://data.medicare.gov/resource/xubh-q36u/row-wki7.4fi8-6y23 | 360362 | 659845 | 2019-11-22 | 2019-06-30 | 29 | 29 | 29 | |||||||||||||
| 2217 | 2217 | GOOD SAMARITAN HOSPITAL | 375 DIXMYTH AVENUE | CINCINNATI | OH | 45220 | HAMILTON | (513) 862-2646 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 39.1406120 | -84.5222700 | 0 | 61 | 39 | 39061 | 17140 | Cincinnati-Wilmington-Maysville, OH-KY-IN | Central | Hamilton County | https://data.medicare.gov/resource/xubh-q36u/row-6uz9-sgfb_psja | 360134 | 659840 | 2019-11-22 | 2019-06-30 | 266 | 29 | 10 | 365 | 27 | 392 | ||||||||||
| 2500 | 2500 | ST VINCENT'S BIRMINGHAM | 810 ST VINCENT'S DRIVE | BIRMINGHAM | AL | 35205 | JEFFERSON | (205) 939-7000 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 33.5080150 | -86.7887550 | 0 | 73 | 1 | 1073 | 13820 | Birmingham-Hoover-Talladega, AL | Central | Jefferson County | https://data.medicare.gov/resource/xubh-q36u/row-6naf-9cek~29rm | 10056 | 659398 | 2019-11-22 | 2019-06-30 | 275 | 83 | 12 | 30 | 400 | 400 | ||||||||||
| 2502 | 2502 | ST VINCENT'S EAST | 50 MEDICAL PARK EAST DRIVE | BIRMINGHAM | AL | 35235 | JEFFERSON | (205) 838-3122 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 33.5953510 | -86.6651820 | 0 | 73 | 1 | 1073 | 13820 | Birmingham-Hoover-Talladega, AL | Central | Jefferson County | https://data.medicare.gov/resource/xubh-q36u/row-tfdr.ige8~3px7 | 10011 | 659397 | 2019-11-22 | 2019-06-30 | 209 | 30 | 56 | 14 | 309 | 20 | 20 | 349 | ||||||||
| 2805 | 2805 | UPMC HORIZON | 110 NORTH MAIN STREET | GREENVILLE | PA | 16125 | MERCER | (724) 588-2100 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 41.4111260 | -80.3722010 | 0 | 85 | 42 | 42085 | 49660 | Youngstown-Warren, OH-PA | Central | Mercer County | https://data.medicare.gov/resource/xubh-q36u/row-gpkb.zkc2~exgp | 390178 | 659875 | 2019-11-22 | 2019-06-30 | 116 | 6 | 122 | 122 | ||||||||||||
| 3049 | 3049 | RESEARCH MEDICAL CENTER | 2316 E MEYER BLVD | KANSAS CITY | MO | 64132 | JACKSON | (816) 276-4000 | Acute Care Hospitals | Proprietary | TRUE | 39.0071690 | -94.5587310 | 0 | 95 | 29 | 29095 | 28140 | Kansas City-Overland Park-Kansas City, MO-KS | Central | Jackson County | https://data.medicare.gov/resource/xubh-q36u/row-4hig.ydmh~ba6w | 260027 | 660238 | 2019-11-22 | 2018-12-31 | 283 | 28 | 330 | 82 | 30 | 442 | ||||||||||
| 3372 | 3372 | LEONARD J CHABERT MEDICAL CENTER | 1978 INDUSTRIAL BLVD | HOUMA | LA | 70363 | TERREBONNE | (985) 873-2200 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 29.5713180 | -90.6876250 | 0 | 109 | 22 | 22109 | 26380 | Central | Terrebonne Parish | https://data.medicare.gov/resource/xubh-q36u/row-muz6_tkv3.tehw | 190183 | 660384 | 2019-11-22 | 2019-06-30 | 58 | 8 | 66 | 24 | 90 | ||||||||||||
| 3462 | 3462 | PIEDMONT FAYETTE HOSPITAL | 1255 HIGHWAY 54 WEST | FAYETTEVILLE | GA | 30214 | FAYETTE | (770) 719-7000 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 33.4505930 | -84.5105260 | 0 | 113 | 13 | 13113 | 12060 | Atlanta--Athens-Clarke County--Sandy Springs, GA | Central | Fayette County | https://data.medicare.gov/resource/xubh-q36u/row-gfr6_jzg4.vm89 | 110215 | 659234 | 2019-11-22 | 2019-06-30 | 204 | 66 | 20 | 290 | 290 | |||||||||||
| 3495 | 3495 | BAYLOR SCOTT AND WHITE HEART AND VASCULAR HOSPITAL | 621 NORTH HALL STREET | DALLAS | TX | 75226 | DALLAS | (214) 820-0670 | Acute Care Hospitals | Proprietary | TRUE | 32.7882880 | -96.7806630 | 0 | 113 | 48 | 48113 | 19100 | Dallas-Fort Worth, TX-OK | Central | Dallas County | https://data.medicare.gov/resource/xubh-q36u/row-gher.dgrm-kty6 | 450851 | 659614 | 2019-11-22 | 2019-06-30 | 53 | 53 | 53 | |||||||||||||
| 3838 | 3838 | OSS ORTHOPAEDIC HOSPITAL | 1861 POWDER MILL RD | YORK | PA | 17402 | YORK | (717) 718-2000 | Acute Care Hospitals | Proprietary | FALSE | 39.9166900 | -76.6968130 | 0 | 133 | 42 | 42133 | 49620 | Harrisburg-York-Lebanon, PA | Central | York County | https://data.medicare.gov/resource/xubh-q36u/row-9itg-k673_kn2f | 390325 | 659884 | 2019-11-22 | 2019-06-30 | 30 | 30 | 30 | |||||||||||||
| 4055 | 4055 | BROADLAWNS MEDICAL CENTER | 1801 HICKMAN ROAD | DES MOINES | IA | 50314 | POLK | (515) 282-2200 | Acute Care Hospitals | Government - Local | TRUE | 41.6150970 | -93.6411550 | 0 | 153 | 19 | 19153 | 19780 | Des Moines-Ames-West Des Moines, IA | Central | Polk County | https://data.medicare.gov/resource/xubh-q36u/row-dzd6.727y_ubfk | 160101 | 659567 | 2019-11-22 | 2019-06-30 | 111 | 6 | 117 | 117 | ||||||||||||
| 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 | ||||||||||
| 4409 | 4409 | MEMORIAL HERMANN MEMORIAL CITY MEDICAL CENTER | 921 GESSNER | HOUSTON | TX | 77024 | HARRIS | (713) 242-3000 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 29.7810230 | -95.5444220 | 0 | 201 | 48 | 48201 | 26420 | Houston-The Woodlands, TX | Central | Harris County | https://data.medicare.gov/resource/xubh-q36u/row-5cxu-jdn6.jcsk | 450610 | 659540 | 2019-11-22 | 2019-06-30 | 360 | 60 | 24 | 444 | 444 | |||||||||||
| 4479 | 4479 | PIEDMONT NEWTON HOSPITAL | 5126 HOSPITAL DRIVE NE | COVINGTON | GA | 30014 | NEWTON | (770) 786-7053 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 33.6026730 | -83.8480820 | 0 | 217 | 13 | 13217 | 12060 | Atlanta--Athens-Clarke County--Sandy Springs, GA | Central | Newton County | https://data.medicare.gov/resource/xubh-q36u/row-esav.9mwz.esp9 | 110018 | 659488 | 2019-11-22 | 2019-06-30 | 78 | 10 | 6 | 94 | 94 | |||||||||||
| 4518 | 4518 | PIEDMONT ROCKDALE HOSPITAL | 1412 MILSTEAD AVENUE, NE | CONYERS | GA | 30012 | ROCKDALE | (770) 918-3000 | Acute Care Hospitals | Proprietary | FALSE | 33.6822390 | -84.0019410 | 0 | 247 | 13 | 13247 | 12060 | Atlanta--Athens-Clarke County--Sandy Springs, GA | Central | Rockdale County | https://data.medicare.gov/resource/xubh-q36u/row-x66k.dxnr.f5df | 110091 | 659231 | 2019-11-22 | 2019-06-30 | 105 | 16 | 141 | 141 | ||||||||||||
| 4555 | 4555 | PIEDMONT WALTON HOSPITAL, INC | 2151 W SPRING STREET | MONROE | GA | 30655 | WALTON | (770) 267-8461 | Acute Care Hospitals | Proprietary | TRUE | 33.7986350 | -83.7463160 | 0 | 297 | 13 | 13297 | 12060 | Atlanta--Athens-Clarke County--Sandy Springs, GA | Central | Walton County | https://data.medicare.gov/resource/xubh-q36u/row-ncms_jxz6_rqcg | 110046 | 659772 | 2019-11-22 | 2019-06-30 | 69 | 7 | 76 | 76 | ||||||||||||
| 4668 | 4668 | NORTH AUSTIN MEDICAL CENTER | 12221 MOPAC EXPRESSWAY NORTH | AUSTIN | TX | 78758 | TRAVIS | (512) 901-1000 | Acute Care Hospitals | Proprietary | TRUE | 30.4121440 | -97.7081130 | 0 | 453 | 48 | 48453 | 12420 | Central | Travis County | https://data.medicare.gov/resource/xubh-q36u/row-2sap-qyma-ketx | 450809 | 659544 | 2019-11-22 | 2019-06-30 | 290 | 24 | 57 | 377 | 16 | 393 |
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 );