hospital_data
Data source: Big Local News · About: big-local-datasette
9 rows where "filed_date" is on date 2019-05-31 and hospital_type = "Childrens"
This data as json, copyable, CSV (advanced)
Suggested facets: state, county_name, hospital_ownership, emergency_services, countyfips, statefips, statecountyfips, cbsacode, csatitle, countyequivalent, icu_beds, burn_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
539 | 539 | PHOENIX CHILDREN'S HOSPITAL | 1919 EAST THOMAS ROAD | PHOENIX | AZ | 85016 | MARICOPA | (602) 933-1000 | Childrens | Voluntary non-profit - Private | FALSE | 33.4802160 | -112.0411930 | 0 | 13 | 4 | 4013 | 38060 | Central | Maricopa County | https://data.medicare.gov/resource/xubh-q36u/row-feed_vt9a~9ie7 | 33302 | 650636 | 2019-05-31 | 2018-12-31 | 352 | 433 | 433 | ||||||||||||||
2016 | 2016 | CHILDREN'S HOSPITAL & MEDICAL CENTER | 8200 DODGE ST | OMAHA | NE | 68114 | DOUGLAS | (402) 955-5400 | Childrens | Voluntary non-profit - Private | TRUE | 41.2596810 | -96.0408680 | 0 | 55 | 31 | 31055 | 36540 | Omaha-Council Bluffs-Fremont, NE-IA | Central | Douglas County | https://data.medicare.gov/resource/xubh-q36u/row-kme5.spnq~gd4h | 283301 | 649293 | 2019-05-31 | 2018-12-31 | 81 | 59 | 140 | 140 | ||||||||||||
2821 | 2821 | OUR CHILDRENS HOUSE | 8 PRESTIGE CIRCLE 101 | ALLEN | TX | 75002 | COLLIN | (214) 828-4747 | Childrens | Voluntary non-profit - Church | FALSE | 33.0920180 | -96.6727380 | 0 | 85 | 48 | 48085 | 19100 | Dallas-Fort Worth, TX-OK | Central | Collin County | https://data.medicare.gov/resource/xubh-q36u/row-4cvs-dhym.psr7 | 453308 | 649972 | 2019-05-31 | 2018-12-31 | 39 | 39 | 39 | |||||||||||||
2822 | 2822 | CHILDRENS MEDICAL CENTER PLANO | 7601 PRESTON ROAD | PLANO | TX | 75024 | COLLIN | (214) 456-1792 | Childrens | Voluntary non-profit - Private | TRUE | 33.0798990 | -96.7982400 | 0 | 85 | 48 | 48085 | 19100 | Dallas-Fort Worth, TX-OK | Central | Collin County | https://data.medicare.gov/resource/xubh-q36u/row-fbv8.buwe-5fen | 453316 | 650215 | 2019-05-31 | 2018-12-31 | 60 | 72 | 72 | |||||||||||||
2832 | 2832 | NICKLAUS CHILDREN'S HOSPITAL | 3100 SW 62ND AVE | MIAMI | FL | 33155 | MIAMI-DADE | (305) 666-6511 | Childrens | Voluntary non-profit - Private | TRUE | 25.7425780 | -80.2951780 | 0 | 86 | 12 | 12086 | 33100 | Miami-Fort Lauderdale-Port St. Lucie, FL | Central | Miami-Dade County | https://data.medicare.gov/resource/xubh-q36u/row-kixy-5cng_9r6v | 103301 | 651585 | 2019-05-31 | 2018-12-31 | 180 | 309 | 309 | |||||||||||||
3609 | 3609 | BLYTHEDALE CHILDREN'S HOSPITAL | 95 BRADHURST AVENUE | VALHALLA | NY | 10595 | WESTCHESTER | (914) 592-7555 | Childrens | Voluntary non-profit - Private | FALSE | 41.0931410 | -73.8019980 | 0 | 119 | 36 | 36119 | 35620 | New York-Newark, NY-NJ-CT-PA | Central | Westchester County | https://data.medicare.gov/resource/xubh-q36u/row-62dd~iivi-vf6j | 333301 | 652661 | 2019-05-31 | 2018-12-31 | ||||||||||||||||
3908 | 3908 | CHILDRENS HOSPITAL OF WISCONSIN FOX VALLEY | 130 SECOND ST | NEENAH | WI | 54956 | WINNEBAGO | (920) 969-7900 | Childrens | Voluntary non-profit - Other | TRUE | 44.1891720 | -88.4539070 | 0 | 139 | 55 | 55139 | 36780 | Appleton-Oshkosh-Neenah, WI | Central | Winnebago County | https://data.medicare.gov/resource/xubh-q36u/row-qi6n~u89t_ynp5 | 523302 | 650555 | 2019-05-31 | 2018-12-31 | 20 | 22 | 42 | 42 | ||||||||||||
4066 | 4066 | AKRON CHILDREN'S HOSPITAL | 1 PERKINS SQUARE | AKRON | OH | 44308 | SUMMIT | (330) 543-1000 | Childrens | Voluntary non-profit - Private | FALSE | 41.0784210 | -81.5267890 | 0 | 153 | 39 | 39153 | 10420 | Cleveland-Akron-Canton, OH | Central | Summit County | https://data.medicare.gov/resource/xubh-q36u/row-g6bs.ki8j-vwqu | 363303 | 649334 | 2019-05-31 | 2018-12-31 | 303 | 23 | 12 | 402 | 402 | |||||||||||
4442 | 4442 | HEALTHBRIDGE CHILDRENS'S HOSPITAL OF HOUSTON | 2929 WOODLAND PARK DRIVE | HOUSTON | TX | 77082 | HARRIS | (281) 293-7774 | Childrens | Proprietary | FALSE | 29.7323170 | -95.5805930 | 0 | 201 | 48 | 48201 | 26420 | Houston-The Woodlands, TX | Central | Harris County | https://data.medicare.gov/resource/xubh-q36u/row-nwq8.dchf-ph6y | 453309 | 649148 | 2019-05-31 | 2018-12-31 | 40 | 40 | 40 |
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 );