hospital_data
Data source: Big Local News · About: big-local-datasette
10 rows where "filed_date" is on date 2019-08-01 and hospital_ownership = "Proprietary"
This data as json, copyable, CSV (advanced)
Suggested facets: state, hospital_type, statefips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, fy_end_date, acute_beds, icu_beds, coronary_beds, surg_icu_beds, oth_spec_beds, subtotal_acute_beds, subprovider_ipf_beds, subprovider_irf_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||
206 | 206 | SUNRISE HOSPITAL AND MEDICAL CENTER | 3186 S MARYLAND PKWY | LAS VEGAS | NV | 89109 | CLARK | (702) 731-8000 | Acute Care Hospitals | Proprietary | TRUE | 36.1345860 | -115.1368830 | 0 | 3 | 32 | 32003 | 29820 | Las Vegas-Henderson, NV-AZ | Central | Clark County | https://data.medicare.gov/resource/xubh-q36u/row-9gwr_6ph4-9w5i | 290003 | 652435 | 2019-08-01 | 2019-01-31 | 376 | 64 | 20 | 72 | 554 | 42 | 596 | |||||||||
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 | |||||||||||
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 | |||||||||||||
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 | |||||||||||
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 | |||||||||||
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 | ||||||||||||||||
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 | |||||||||||||
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 |
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 );