hospital_data

Table actions
Data provided via a collaboration between The Accountability Project and Big Local News. This project provides and joins datasets pertinent to the COVID-19 pandemic: hospital location and number of beds by type, county-level population estimates by age (which can be linked to hospital data) and nursing home location and capacity. See README for additional information.

Data source: Big Local News · About: big-local-datasette

36 rows where "fy_end_date" is on date 2018-12-31 and hospital_type = "Childrens"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, countyfips, statefips, cbsacode, csatitle, filed_date, acute_beds, icu_beds, coronary_beds, burn_beds, oth_spec_beds, subtotal_acute_beds, subprovider_ipf_beds, skilled_nursing_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
59 59 CHILDREN'S HOSPITAL COLORADO 13123 E 16TH AVE AURORA CO 80045 ADAMS (720) 777-1234 Childrens Voluntary non-profit - Private TRUE 39.7416350 -104.8350180 0   1 8 8001 19740 Denver-Aurora, CO Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-sqwg_95h7-bntj 63301 649405 2019-05-28 2018-12-31 276 36 40     82 434               434
151 151 ALFRED I DUPONT HOSPITAL FOR CHILDREN 1600 ROCKLAND RD PO BOX 269 WILMINGTON DE 19899 NEW CASTLE (302) 651-4000 Childrens Voluntary non-profit - Private TRUE 39.7823370 -75.5552390 0   3 10 10003 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central New Castle County https://data.medicare.gov/resource/xubh-q36u/row-b9cf-cftg-3kpg 83300 659028 2019-11-13 2018-12-31 114         24 208               208
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
612 612 SHRINERS' HOSPITAL FOR CHILDREN (THE) 516 CAREW STREET SPRINGFIELD MA 1104 HAMPDEN (413) 787-2000 Childrens Voluntary non-profit - Private FALSE 42.1205580 -72.5915680 0   13 25 25013 44140 Springfield-Greenfield Town, MA Central Hampden County https://data.medicare.gov/resource/xubh-q36u/row-xahc-ecbk~n8v6 223303 652750 2019-05-30 2018-12-31                              
966 966 CHILDREN'S SPECIALIZED HOSPITAL 200 SOMERSET STREET NEW BRUNSWICK NJ 8901 MIDDLESEX (732) 258-7050 Childrens Voluntary non-profit - Private FALSE 40.4952200 -74.4515090 0   23 34 34023 35620 New York-Newark, NY-NJ-CT-PA Central Middlesex County https://data.medicare.gov/resource/xubh-q36u/row-q3gw~cqak.nu9s 313300 649806 2019-05-28 2018-12-31 68           68       46       114
1011 1011 SHRINERS' HOSPITAL FOR CHILDREN - BOSTON, THE 51 BLOSSOM STREET BOSTON MA 2114 SUFFOLK (617) 722-3000 Childrens Proprietary FALSE 42.3630790 -71.0669040 0   25 25 25025 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Suffolk County https://data.medicare.gov/resource/xubh-q36u/row-pfzw.md7z-rufe 223304 652751 2019-05-30 2018-12-31                              
1223 1223 SHRINERS HOSPITAL FOR CHILDREN 2211 NORTH OAK PARK AVE CHICAGO IL 60707 COOK (773) 622-5400 Childrens Voluntary non-profit - Private FALSE 41.9167660 -87.7949900 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-4p3m.ksch.3kbj 143302 652647 2019-05-30 2018-12-31                              
1409 1409 CLEVELAND CLINIC CHILDREN'S HOSPITAL FOR REHAB 2801 MARTIN LUTHER KING, JR DRIVE CLEVELAND OH 44104 CUYAHOGA (216) 721-6400 Childrens Voluntary non-profit - Private FALSE 41.4827760 -81.6092520 0   35 39 39035 17460 Cleveland-Akron-Canton, OH Central Cuyahoga County https://data.medicare.gov/resource/xubh-q36u/row-hdmr_eyjs_ypqz 363304 651134 2019-05-29 2018-12-31                              
1411 1411 RAINBOW BABIES AND CHILDRENS HOSPITAL 11100 EUCLID AVENUE CLEVELAND OH 44106 CUYAHOGA (216) 844-1000 Childrens Voluntary non-profit - Other TRUE 41.5073090 -81.6072390 0   35 39 39035 17460 Cleveland-Akron-Canton, OH Central Cuyahoga County https://data.medicare.gov/resource/xubh-q36u/row-5crg_b6rj-artz 363302 654291 2019-09-10 2018-12-31 142         20 237               237
1443 1443 PRIMARY CHILDRENS HOSPITAL 100 NORTH MARIO CAPECCHI DRIVE SALT LAKE CITY UT 84113 SALT LAKE (801) 662-6212 Childrens Voluntary non-profit - Private TRUE 40.7713310 -111.8403440 0   35 49 49035 41620 Salt Lake City-Provo-Orem, UT Central Salt Lake County https://data.medicare.gov/resource/xubh-q36u/row-4q4q.rare_dmvy 463301 647979 2019-05-15 2018-12-31 167 44 50     28 289               289
1761 1761 SHRINERS HOSPITALS FOR CHILDREN 950 WEST FARIS ROAD GREENVILLE SC 29605 GREENVILLE (864) 271-3444 Childrens Voluntary non-profit - Private FALSE 34.8160620 -82.4129680 0   45 45 45045 24860 Greenville-Spartanburg-Anderson, SC Central Greenville County https://data.medicare.gov/resource/xubh-q36u/row-zu5m.xbpi~47ak 423300 652674 2019-05-30 2018-12-31                              
1860 1860 NATIONWIDE CHILDREN'S HOSPITAL 700 CHILDREN'S DRIVE COLUMBUS OH 43205 FRANKLIN (614) 722-2000 Childrens Voluntary non-profit - Private TRUE 39.9523670 -82.9791240 0   49 39 39049 18140 Columbus-Marion-Zanesville, OH Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-w2pp_yw5v_tka7 363305 649661 2019-06-03 2018-12-31 339 74       260 673               673
1957 1957 CHILDREN'S HOSPITALS & CLINICS OF MN 2525 CHICAGO AVENUE SOUTH MINNEAPOLIS MN 55404 HENNEPIN (612) 813-6112 Childrens Voluntary non-profit - Private TRUE 44.9562370 -93.2625880 0   53 27 27053 33460 Minneapolis-St. Paul, MN-WI Central Hennepin County https://data.medicare.gov/resource/xubh-q36u/row-zsi6-wyrh~wxd5 243302 662539 2019-12-06 2018-12-31 151 42 25     196 414               414
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
2019 2019 BOYS TOWN NATIONAL RESEARCH HOSPITAL 555 NORTH 30TH ST OMAHA NE 68131 DOUGLAS (531) 355-6510 Childrens Voluntary non-profit - Private FALSE 41.2645120 -95.9565140 0   55 31 31055 36540 Omaha-Council Bluffs-Fremont, NE-IA Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-i7r7~v26j~9e2t 283300 650175 2019-06-03 2018-12-31 61           61               61
2054 2054 SHRINERS HOSPITALS FOR CHILDREN-TAMPA 12502 USF PINE DR TAMPA FL 33612 HILLSBOROUGH (813) 972-2250 Childrens Voluntary non-profit - Other FALSE 28.0603710 -82.4229680 0   57 12 12057 45300   Central Hillsborough County https://data.medicare.gov/resource/xubh-q36u/row-u3s8~6bbc_882j 103303 659465 2019-05-30 2018-12-31                              
2214 2214 SHRINERS HOSPITALS FOR CHILDREN - CINCINNATI 3229 BURNETT AVENUE CINCINNATI OH 45229 HAMILTON (513) 872-6000 Childrens Voluntary non-profit - Private FALSE 39.1376950 -84.5007550 0   61 39 39061 17140 Cincinnati-Wilmington-Maysville, OH-KY-IN Central Hamilton County https://data.medicare.gov/resource/xubh-q36u/row-qcvj~zayq~x396 363308 650516 2019-05-29 2018-12-31                              
2464 2464 CHILDRENS HOSPITAL 200 HENRY CLAY AVE NEW ORLEANS LA 70118 ORLEANS (504) 899-9511 Childrens Voluntary non-profit - Private TRUE 29.9173960 -90.1271310 0   71 22 22071 35380 New Orleans-Metairie-Hammond, LA-MS Central Orleans Parish https://data.medicare.gov/resource/xubh-q36u/row-kxvy_6z7u_5sih 193300 650822 2019-06-03 2018-12-31 123           187 34             221
2503 2503 CHILDREN'S HOSPITAL OF ALABAMA 1600 SEVENTH AVENUE SOUTH BIRMINGHAM AL 35233 JEFFERSON (205) 939-9100 Childrens Voluntary non-profit - Private TRUE 33.5032220 -86.8053810 0   73 1 1073 13820 Birmingham-Hoover-Talladega, AL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-nh6w~rxvd~itst 13300 651162 2019-06-03 2018-12-31 193     6     341               341
2674 2674 CHILDRENS HOSPITAL OF WISCONSIN 9000 W WISCONSIN AVE MILWAUKEE WI 53226 MILWAUKEE (414) 266-2000 Childrens Voluntary non-profit - Other TRUE 43.0384460 -88.0247370 0   79 55 55079 33340 Milwaukee-Racine-Waukesha, WI Central Milwaukee County https://data.medicare.gov/resource/xubh-q36u/row-g38x_cn4g~q4h7 523300 650554 2019-06-25 2018-12-31 132 142       24 298               298
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
2887 2887 CHILDREN'S HEALTHCARE OF ATLANTA AT EGLESTON 1405 CLIFTON ROAD, NE ATLANTA GA 30322 DE KALB (404) 785-6101 Childrens Voluntary non-profit - Private TRUE 33.7939800 -84.3210070 0   89 13 13089 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central DeKalb County https://data.medicare.gov/resource/xubh-q36u/row-9pe3-c8dk-3wk4 113300 649890 2019-05-28 2018-12-31 177 118         295               295
3030 3030 NEMOURS CHILDREN'S HOSPITAL 13535 NEMOURS PKWY ORLANDO FL 32827 ORANGE (407) 567-4000 Childrens Voluntary non-profit - Private TRUE 28.3749080 -81.2766940 0   95 12 12095 36740 Orlando-Deltona-Daytona Beach, FL Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-7q2m-thri-ffzb 103304 648095 2019-05-22 2018-12-31 49 28       18 100               100
3222 3222 ST CHRISTOPHER'S HOSPITAL FOR CHILDREN 160 EAST ERIE AVE PHILADELPHIA PA 19134 PHILADELPHIA (215) 427-5000 Childrens Proprietary TRUE 40.0074930 -75.1255350 0   101 42 42101 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Philadelphia County https://data.medicare.gov/resource/xubh-q36u/row-z7p6.dkcr_rdax 393307 650206 2019-06-03 2018-12-31 115 44       29 188               188
3498 3498 CHILDRENS MEDICAL CTR OF DALLAS 1935 MEDICAL DISTRICT DRIVE DALLAS TX 75235 DALLAS (214) 456-7000 Childrens Voluntary non-profit - Private TRUE 32.8083590 -96.8368370 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-yvxv~v5b3.xbk2 453302 647592 2019-05-10 2018-12-31 261           398               398
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                              
3634 3634 CHILDREN'S HEALTHCARE OF ATLANTA AT SCOTTISH RITE 1001 JOHNSON FERRY ROAD ATLANTA GA 30342 FULTON (404) 785-5252 Childrens Voluntary non-profit - Other TRUE 33.9079000 -84.3544260 0   121 13 13121 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Fulton County https://data.medicare.gov/resource/xubh-q36u/row-9wgb.g8f7-d9n3 113301 649891 2019-05-28 2018-12-31 217 102         319               319
3680 3680 GILLETTE CHILDRENS SPECIALTY HOSPITAL 200 UNIVERSITY AVENUE EAST SAINT PAUL MN 55106 RAMSEY (651) 578-5611 Childrens Government - Hospital District or Authority FALSE 44.9565470 -93.0956600 0   123 27 27123 33460 Minneapolis-St. Paul, MN-WI Central Ramsey County https://data.medicare.gov/resource/xubh-q36u/row-asad.d5pr_r5a5 243300 649913 2019-05-30 2018-12-31 50 10         60               60
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
4162 4162 CHILDREN'S HOSPITAL OF MICHIGAN 3901 BEAUBIEN STREET DETROIT MI 48201 WAYNE (313) 745-5437 Childrens Proprietary TRUE 42.3518160 -83.0537500 0   163 26 26163 19820 Detroit-Warren-Ann Arbor, MI Central Wayne County https://data.medicare.gov/resource/xubh-q36u/row-z5kc-2ncc~crci 233300 649116 2019-05-30 2018-12-31 122 48   19   39 228               228
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
4726 4726 ST LOUIS CHILDRENS HOSPITAL ONE CHILDRENS PLACE SAINT LOUIS MO 63110 ST. LOUIS CITY (314) 454-6000 Childrens Voluntary non-profit - Other TRUE 38.6374922 -90.2652998 1 ROOFTOP 510 29 29510 41180 St. Louis-St. Charles-Farmington, MO-IL Central St. Louis city https://data.medicare.gov/resource/xubh-q36u/row-d9w4-w6pt_bban 263301 652310 2019-07-12 2018-12-31 211 40       125 376               376
4729 4729 SHRINERS HOSPITALS FOR CHILDREN 4400 CLAYTON AVE SAINT LOUIS MO 63110 ST. LOUIS CITY (314) 432-3600 Childrens Voluntary non-profit - Private FALSE 38.6329890 -90.2578210 0   510 29 29510 41180 St. Louis-St. Charles-Farmington, MO-IL Central St. Louis city https://data.medicare.gov/resource/xubh-q36u/row-wpna.jm3m.trsh 263304 649794 2019-05-30 2018-12-31                              

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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
);