hospital_data
Data source: Big Local News · About: big-local-datasette
31 rows where "fy_end_date" is on date 2019-02-28 sorted by cbsacode
This data as json, copyable, CSV (advanced)
Suggested facets: city, state, zip_code, county_name, hospital_type, hospital_ownership, geocode_flag, geocode_accuracy, countyfips, statefips, statecountyfips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, filed_date, acute_beds, icu_beds, coronary_beds, oth_spec_beds, subtotal_acute_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_beds, all_beds, filed_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
325 | 325 | LEWISGALE HOSPITAL ALLEGHANY | ONE ARH LANE - PO BOX 7 | LOW MOOR | VA | 24457 | ALLEGHANY | (540) 862-6011 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 37.7917929 | -79.8809172 | 1 | ROOFTOP | 5 | 51 | 51005 | https://data.medicare.gov/resource/xubh-q36u/row-fp3a~xuin-uu4c | 490126 | 652979 | 2019-08-02 | 2019-02-28 | 85 | 10 | 95 | 15 | 110 | ||||||||||||||
996 | 996 | CLAY COUNTY HOSPITAL | 911 STACY BURK DRIVE | FLORA | IL | 62839 | CLAY | (618) 662-2131 | Critical Access Hospitals | Government - Local | TRUE | 38.6809170 | -88.4703370 | 0 | 25 | 17 | 17025 | https://data.medicare.gov/resource/xubh-q36u/row-waac_79mj~znty | 141351 | 653013 | 2019-08-02 | 2019-02-28 | 20 | 20 | 20 | |||||||||||||||||
2077 | 2077 | DUNDY COUNTY HOSPITAL | P O BOX 626, 1313 NORTH CHEYENNE ST | BENKELMAN | NE | 69021 | DUNDY | (308) 423-2204 | Critical Access Hospitals | Government - Local | TRUE | 40.0565540 | -101.5374470 | 1 | ROOFTOP | 57 | 31 | 31057 | https://data.medicare.gov/resource/xubh-q36u/row-pych_p5gr-xzj5 | 281340 | 652885 | 2019-08-05 | 2019-02-28 | 14 | 14 | 14 | ||||||||||||||||
3347 | 3347 | PANOLA MEDICAL CENTER | 303 MEDICAL CENTER DRIVE | BATESVILLE | MS | 38606 | PANOLA | (662) 563-5611 | Acute Care Hospitals | Proprietary | TRUE | 34.3063190 | -89.9164880 | 0 | 107 | 28 | 28107 | https://data.medicare.gov/resource/xubh-q36u/row-3tn8.ifxk_3zyp | 250128 | 652883 | 2019-08-05 | 2019-02-28 | 45 | 45 | 22 | 67 | ||||||||||||||||
3918 | 3918 | LOGAN MEMORIAL HOSPITAL | 1625 NASHVILLE STREET | RUSSELLVILLE | KY | 42276 | LOGAN | (270) 726-4011 | Acute Care Hospitals | Proprietary | TRUE | 36.8154370 | -86.8825930 | 0 | 141 | 21 | 21141 | https://data.medicare.gov/resource/xubh-q36u/row-kw6k-zetw_vziz | 180066 | 652353 | 2019-08-01 | 2019-02-28 | 69 | 6 | 75 | 75 | ||||||||||||||||
4217 | 4217 | SARAH D CULBERTSON MEMORIAL HOSPITAL | 238 SOUTH CONGRESS STREET | RUSHVILLE | IL | 62681 | SCHUYLER | (217) 322-4321 | Critical Access Hospitals | Government - Hospital District or Authority | TRUE | 40.1179440 | -90.5635870 | 0 | 169 | 17 | 17169 | https://data.medicare.gov/resource/xubh-q36u/row-bfu9.4ehe.ppey | 141333 | 652646 | 2019-07-26 | 2019-02-28 | 22 | 22 | 22 | |||||||||||||||||
4232 | 4232 | MONROE COUNTY MEDICAL CENTER | 529 CAPP HARLAN ROAD | TOMPKINSVILLE | KY | 42167 | MONROE | (270) 487-9231 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 36.6985060 | -85.6771200 | 0 | 171 | 21 | 21171 | https://data.medicare.gov/resource/xubh-q36u/row-ep5d-ygrp~vtff | 180105 | 652357 | 2019-07-31 | 2019-02-28 | 49 | 49 | 49 | |||||||||||||||||
4538 | 4538 | KNOX COUNTY HOSPITAL | 701 SOUTHEAST 5TH STREET | KNOX CITY | TX | 79529 | KNOX | (940) 657-3535 | Acute Care Hospitals | Government - Hospital District or Authority | TRUE | 33.4141070 | -99.8114510 | 0 | 275 | 48 | 48275 | https://data.medicare.gov/resource/xubh-q36u/row-7yyt-3mtc_a7wb | 450746 | 652728 | 2019-08-01 | 2019-02-28 | 28 | 28 | 28 | |||||||||||||||||
4711 | 4711 | HAMILTON HOSPITAL | 901 WEST HAMILTON | OLNEY | TX | 76374 | YOUNG | (940) 564-5521 | Critical Access Hospitals | Government - Hospital District or Authority | TRUE | 33.3696690 | -98.7646300 | 0 | 503 | 48 | 48503 | https://data.medicare.gov/resource/xubh-q36u/row-2jrh~g63r.wnym | 451354 | 652730 | 2019-07-31 | 2019-02-28 | 25 | 25 | 25 | |||||||||||||||||
4736 | 4736 | SOUTHERN VIRGINIA REGIONAL MEDICAL CENTER | 727 NORTH MAIN STREET | EMPORIA | VA | 23847 | EMPORIA CITY | (434) 348-4400 | Acute Care Hospitals | Proprietary | TRUE | 36.7015680 | -77.5359850 | 0 | 595 | 51 | 51595 | https://data.medicare.gov/resource/xubh-q36u/row-ggnv~rn79-ude3 | 490097 | 652769 | 2019-08-01 | 2019-02-28 | 63 | 7 | 70 | 10 | 80 | |||||||||||||||
108 | 108 | LOVELACE MEDICAL CENTER | 601 DR MARTIN LUTHER KING JR AVE NE | ALBUQUERQUE | NM | 87102 | BERNALILLO | (505) 727-8000 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 35.0856220 | -106.6397650 | 0 | 1 | 35 | 35001 | 10740 | Albuquerque-Santa Fe-Las Vegas, NM | Central | Bernalillo County | https://data.medicare.gov/resource/xubh-q36u/row-kci4.56nf~rfu7 | 320009 | 652759 | 2019-07-29 | 2019-02-28 | 245 | 48 | 293 | 293 | ||||||||||||
4703 | 4703 | ROUND ROCK MEDICAL CENTER | 2400 ROUND ROCK AVE | ROUND ROCK | TX | 78681 | WILLIAMSON | (512) 341-1000 | Acute Care Hospitals | Proprietary | TRUE | 30.5093360 | -97.7123610 | 0 | 491 | 48 | 48491 | 12420 | Central | Williamson County | https://data.medicare.gov/resource/xubh-q36u/row-jpx8_mm4d-nyqm | 450718 | 652275 | 2019-07-31 | 2019-02-28 | 127 | 18 | 12 | 157 | 12 | 169 | |||||||||||
696 | 696 | PORTSMOUTH REGIONAL HOSPITAL | 333 BORTHWICK AVE | PORTSMOUTH | NH | 3801 | ROCKINGHAM | (603) 436-5110 | Acute Care Hospitals | Proprietary | TRUE | 43.0640930 | -70.7877740 | 0 | 15 | 33 | 33015 | 14460 | Boston-Worcester-Providence, MA-RI-NH-CT | Central | Rockingham County | https://data.medicare.gov/resource/xubh-q36u/row-mstp-mc9d-7mre | 300029 | 652758 | 2019-08-01 | 2019-02-28 | 127 | 16 | 143 | 30 | 173 | |||||||||||
3843 | 3843 | LIVINGSTON REGIONAL HOSPITAL | 315 OAK ST BOX 550 | LIVINGSTON | TN | 38570 | OVERTON | (931) 823-5611 | Acute Care Hospitals | Proprietary | TRUE | 36.3846950 | -85.3280970 | 0 | 133 | 47 | 47133 | 18260 | Outlying | Overton County | https://data.medicare.gov/resource/xubh-q36u/row-yei3~9qc6~cfrt | 440187 | 652547 | 2019-08-01 | 2019-02-28 | 84 | 6 | 90 | 10 | 14 | 114 | |||||||||||
2068 | 2068 | WESTERN PLAINS MEDICAL COMPLEX | 3001 AVENUE A | DODGE CITY | KS | 67801 | FORD | (620) 225-8400 | Acute Care Hospitals | Proprietary | TRUE | 37.7854870 | -100.0149750 | 0 | 57 | 20 | 20057 | 19980 | Central | Ford County | https://data.medicare.gov/resource/xubh-q36u/row-w4ff.nykp.gqd4 | 170175 | 652748 | 2019-08-01 | 2019-02-28 | 50 | 10 | 60 | 60 | |||||||||||||
703 | 703 | ST JOSEPH'S HOSPITAL | 555 ST JOSEPH'S BLVD | ELMIRA | NY | 14901 | CHEMUNG | (607) 733-6541 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 42.0912140 | -76.7974720 | 0 | 15 | 36 | 36015 | 21300 | Elmira-Corning, NY | Central | Chemung County | https://data.medicare.gov/resource/xubh-q36u/row-kyx8_fy6q.m2sb | 330108 | 653056 | 2019-08-14 | 2019-02-28 | 20 | 20 | 25 | 20 | 111 | 176 | ||||||||||
77 | 77 | NORTH FLORIDA REGIONAL MEDICAL CENTER | 6500 NEWBERRY RD | GAINESVILLE | FL | 32605 | ALACHUA | (352) 333-4100 | Acute Care Hospitals | Proprietary | TRUE | 29.6596990 | -82.4115970 | 0 | 1 | 12 | 12001 | 23540 | Gainesville-Lake City, FL | Central | Alachua County | https://data.medicare.gov/resource/xubh-q36u/row-cu2v_edeq-29tz | 100204 | 652641 | 2019-08-01 | 2019-02-28 | 321 | 48 | 12 | 381 | 33 | 414 | ||||||||||
4407 | 4407 | HARRIS HEALTH SYSTEM | 2525 HOLLY HALL | HOUSTON | TX | 77054 | HARRIS | (713) 566-6417 | Acute Care Hospitals | Government - Hospital District or Authority | TRUE | 29.6854220 | -95.3870940 | 0 | 201 | 48 | 48201 | 26420 | Houston-The Woodlands, TX | Central | Harris County | https://data.medicare.gov/resource/xubh-q36u/row-727m.2zxf~gpiz | 450289 | 652272 | 2019-07-31 | 2019-02-28 | 479 | 30 | 8 | 16 | 615 | 20 | 25 | 24 | 684 | |||||||
4437 | 4437 | WOMANS HOSPITAL OF TEXAS,THE | 7600 FANNIN | HOUSTON | TX | 77054 | HARRIS | (713) 790-1234 | Acute Care Hospitals | Proprietary | TRUE | 29.6929770 | -95.4010900 | 0 | 201 | 48 | 48201 | 26420 | Houston-The Woodlands, TX | Central | Harris County | https://data.medicare.gov/resource/xubh-q36u/row-pvha_dpmv~q2t2 | 450674 | 652609 | 2019-07-31 | 2019-02-28 | 253 | 4 | 257 | 257 | ||||||||||||
653 | 653 | JELLICO MEDICAL CENTER, INC | 188 HOSPITAL LANE | JELLICO | TN | 37762 | CAMPBELL | (423) 784-7252 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 36.5736190 | -84.1272400 | 0 | 13 | 47 | 47013 | 28940 | Knoxville-Morristown-Sevierville, TN | Outlying | Campbell County | https://data.medicare.gov/resource/xubh-q36u/row-n2fu-p6zw_cd43 | 440180 | 654899 | 2019-09-24 | 2019-02-28 | 30 | 4 | 34 | 34 | ||||||||||||
4458 | 4458 | GEORGETOWN COMMUNITY HOSPITAL | 1140 LEXINGTON ROAD | GEORGETOWN | KY | 40324 | SCOTT | (502) 868-1100 | Acute Care Hospitals | Proprietary | TRUE | 38.1862230 | -84.5624450 | 0 | 209 | 21 | 21209 | 30460 | Lexington-Fayette--Richmond--Frankfort, KY | Outlying | Scott County | https://data.medicare.gov/resource/xubh-q36u/row-spxj.g7x2.6ev5 | 180101 | 652355 | 2019-08-01 | 2019-02-28 | 69 | 6 | 75 | 75 | ||||||||||||
4507 | 4507 | BLUEGRASS COMMUNITY HOSPITAL | 360 AMSDEN AVENUE | VERSAILLES | KY | 40383 | WOODFORD | (859) 873-3111 | Critical Access Hospitals | Proprietary | TRUE | 38.0553430 | -84.7234150 | 0 | 239 | 21 | 21239 | 30460 | Lexington-Fayette--Richmond--Frankfort, KY | Outlying | Woodford County | https://data.medicare.gov/resource/xubh-q36u/row-9aks-4jh9~zwp7 | 181308 | 652512 | 2019-08-01 | 2019-02-28 | 25 | 25 | 25 | |||||||||||||
2748 | 2748 | JACKSON PURCHASE MEDICAL CENTER | 1099 MEDICAL CENTER CIRCLE | MAYFIELD | KY | 42066 | GRAVES | (270) 251-4585 | Acute Care Hospitals | Government - Hospital District or Authority | TRUE | 36.7574110 | -88.6509810 | 0 | 83 | 21 | 21083 | 32460 | Paducah-Mayfield, KY-IL | Central | Graves County | https://data.medicare.gov/resource/xubh-q36u/row-scw3~i5jx_eivs | 180116 | 652359 | 2019-07-31 | 2019-02-28 | 87 | 8 | 95 | 12 | 107 | |||||||||||
2533 | 2533 | GLENWOOD REGIONAL MEDICAL CENTER | 503 MCMILLAN ROAD | WEST MONROE | LA | 71291 | OUACHITA | (318) 329-4600 | Acute Care Hospitals | Proprietary | TRUE | 32.5134620 | -92.1567610 | 0 | 73 | 22 | 22073 | 33740 | Monroe-Ruston-Bastrop, LA | Central | Ouachita Parish | https://data.medicare.gov/resource/xubh-q36u/row-p2i2~hyuu~bqfj | 190160 | 652655 | 2019-07-31 | 2019-02-28 | 164 | 44 | 6 | 214 | 40 | 16 | 14 | 284 | ||||||||
4753 | 4753 | SOUTHSIDE REGIONAL MEDICAL CENTER | 200 MEDICAL PARK BOULEVARD | PETERSBURG | VA | 23805 | PETERSBURG CITY | (804) 765-5000 | Acute Care Hospitals | Proprietary | TRUE | 37.1836540 | -77.3614660 | 0 | 730 | 51 | 51730 | 40060 | Central | Petersburg city | https://data.medicare.gov/resource/xubh-q36u/row-p9qg_3z5t_zrt3 | 490067 | 654869 | 2019-09-20 | 2019-02-28 | 272 | 28 | 300 | 300 | |||||||||||||
1178 | 1178 | METHODIST STONE OAK HOSPITAL | 1139 E SONTERRA BLVD, STE 535 | SAN ANTONIO | TX | 78258 | BEXAR | (210) 638-2100 | Acute Care Hospitals | Proprietary | TRUE | 29.6144940 | -98.4754590 | 0 | 29 | 48 | 48029 | 41700 | Central | Bexar County | https://data.medicare.gov/resource/xubh-q36u/row-32ag-t8fj-9ybq | 670055 | 652855 | 2019-07-31 | 2019-02-28 | 175 | 28 | 24 | 227 | 15 | 242 | |||||||||||
1945 | 1945 | OAK HILL HOSPITAL | 11375 CORTEZ BLVD | BROOKSVILLE | FL | 34613 | HERNANDO | (352) 596-6632 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 28.5333050 | -82.5344950 | 0 | 53 | 12 | 12053 | 45300 | Outlying | Hernando County | https://data.medicare.gov/resource/xubh-q36u/row-rykp.dde9-42ms | 100264 | 652644 | 2019-07-29 | 2019-02-28 | 256 | 24 | 280 | 280 | |||||||||||||
3199 | 3199 | REGIONAL MEDICAL CENTER BAYONET POINT | 14000 FIVAY RD | HUDSON | FL | 34667 | PASCO | (727) 819-2929 | Acute Care Hospitals | Proprietary | TRUE | 28.3607430 | -82.6901480 | 0 | 101 | 12 | 12101 | 45300 | Central | Pasco County | https://data.medicare.gov/resource/xubh-q36u/row-burc_j8eh.zcc8 | 100256 | 652643 | 2019-07-31 | 2019-02-28 | 230 | 20 | 40 | 290 | 290 | ||||||||||||
3251 | 3251 | LARGO MEDICAL CENTER | 201 14TH ST SW | LARGO | FL | 33770 | PINELLAS | (727) 588-5200 | Acute Care Hospitals | Proprietary | TRUE | 27.9149140 | -82.8026710 | 0 | 103 | 12 | 12103 | 45300 | Central | Pinellas County | https://data.medicare.gov/resource/xubh-q36u/row-p62b_5uvn.q827 | 100248 | 652642 | 2019-08-01 | 2019-02-28 | 220 | 22 | 262 | 71 | 30 | 363 | |||||||||||
2788 | 2788 | KOSCIUSKO COMMUNITY HOSPITAL | 2101 E DUBOIS DR | WARSAW | IN | 46580 | KOSCIUSKO | (574) 267-3200 | Acute Care Hospitals | Proprietary | TRUE | 41.2464300 | -85.8283200 | 0 | 85 | 18 | 18085 | 47700 | Central | Kosciusko County | https://data.medicare.gov/resource/xubh-q36u/row-ijct_r8b9~pygm | 150133 | 654577 | 2019-09-13 | 2019-02-28 | 58 | 14 | 72 | 72 | |||||||||||||
4383 | 4383 | WILSON MEDICAL CENTER | 1705 S TARBORO ST | WILSON | NC | 27893 | WILSON | (252) 399-8040 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 35.7205240 | -77.9440470 | 0 | 195 | 37 | 37195 | 48980 | Rocky Mount-Wilson-Roanoke Rapids, NC | Central | Wilson County | https://data.medicare.gov/resource/xubh-q36u/row-674m.zg3x~pbew | 340126 | 652665 | 2019-08-02 | 2019-02-28 | 256 | 14 | 270 | 24 | 294 |
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 );