hospital_data
Data source: Big Local News · About: big-local-datasette
5 rows where "filed_date" is on date 2019-06-28 and hospital_ownership = "Proprietary"
This data as json, copyable, CSV (advanced)
Suggested facets: hospital_type, emergency_services, fy_end_date, coronary_beds, subprovider_ipf_beds, subprovider_irf_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
109 | 109 | LOVELACE WESTSIDE HOSPITAL | 10501 GOLF COURSE ROAD NW | ALBUQUERQUE | NM | 87114 | BERNALILLO | (505) 727-2001 | Acute Care Hospitals | Proprietary | TRUE | 35.2075080 | -106.6759740 | 0 | 1 | 35 | 35001 | 10740 | Albuquerque-Santa Fe-Las Vegas, NM | Central | Bernalillo County | https://data.medicare.gov/resource/xubh-q36u/row-t6an-qbnd.nby8 | 320074 | 651222 | 2019-06-28 | 2019-01-31 | 62 | 8 | 70 | 70 | ||||||||||||
494 | 494 | WESTSIDE REGIONAL MEDICAL CENTER | 8201 W BROWARD BLVD | PLANTATION | FL | 33324 | BROWARD | (954) 473-6600 | Acute Care Hospitals | Proprietary | FALSE | 26.1208820 | -80.2584290 | 0 | 11 | 12 | 12011 | 33100 | Miami-Fort Lauderdale-Port St. Lucie, FL | Central | Broward County | https://data.medicare.gov/resource/xubh-q36u/row-nnuu-rs8x~9yxs | 100228 | 651509 | 2019-06-28 | 2019-01-31 | 192 | 32 | 224 | 224 | ||||||||||||
2777 | 2777 | GOOD SAMARITAN HOSPITAL | 2425 SAMARITAN DRIVE | SAN JOSE | CA | 95124 | SANTA CLARA | (408) 559-2011 | Acute Care Hospitals | Proprietary | TRUE | 37.2511040 | -121.9465630 | 0 | 85 | 6 | 6085 | 41940 | San Jose-San Francisco-Oakland, CA | Central | Santa Clara County | https://data.medicare.gov/resource/xubh-q36u/row-22ue_gc2m_q5ju | 50380 | 651600 | 2019-06-28 | 2019-01-31 | 223 | 24 | 17 | 309 | 18 | 15 | 342 | |||||||||
4382 | 4382 | I-70 COMMUNITY HOSPITAL | 105 HOSPITAL DRIVE, BUILDING B | SWEET SPRINGS | MO | 65351 | SALINE | (660) 335-4700 | Critical Access Hospitals | Proprietary | TRUE | 38.9782840 | -93.4176350 | 0 | 195 | 29 | 29195 | 32180 | Central | Saline County | https://data.medicare.gov/resource/xubh-q36u/row-4t2s.h4cc.n3vd | 261334 | 651708 | 2019-06-28 | 2018-09-30 | 15 | 15 | 15 | ||||||||||||||
4635 | 4635 | MEDICAL CITY FORT WORTH | 900 EIGHTH AVENUE | FORT WORTH | TX | 76104 | TARRANT | (817) 336-2100 | Acute Care Hospitals | Proprietary | TRUE | 32.7354810 | -97.3437040 | 0 | 439 | 48 | 48439 | 19100 | Dallas-Fort Worth, TX-OK | Central | Tarrant County | https://data.medicare.gov/resource/xubh-q36u/row-ur6k~km8p~s2zk | 450672 | 651726 | 2019-06-28 | 2019-01-31 | 156 | 44 | 200 | 18 | 218 |
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 );