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

96 rows where hospital_type = "Childrens"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, centraloutlyingcounty, fy_end_date, icu_beds, coronary_beds, burn_beds, oth_spec_beds, subprovider_ipf_beds, skilled_nursing_beds, nursing_fac_beds, oth_longterm_beds, filed_date (date), fy_end_date (date)

hospital_type ✖

  • Childrens · 96 ✖
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
55 55 CHILDREN'S HOSPITAL & RESEARCH CENTER OAKLAND 747 52ND STREET OAKLAND CA 94609 ALAMEDA (510) 428-3000 Childrens Voluntary non-profit - Private TRUE 37.8373260 -122.2677410 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-n7ad_497y.9ize 53301 661145 2019-12-02 2019-06-30 123 23       44 190               190
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
74 74 CHILDREN'S HOSPITAL NMC 111 MICHIGAN AVE, NW WASHINGTON DC 20010 THE DISTRICT (202) 476-5000 Childrens Voluntary non-profit - Private TRUE 38.9262730 -77.0138780 0   1 11 11001 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central District of Columbia https://data.medicare.gov/resource/xubh-q36u/row-9kra.5epj-ue89 93300 661151 2019-11-27 2019-06-30 184 73         323               323
143 143 CONNECTICUT CHILDRENS MEDICAL CENTER 282 WASHINGTON STREET HARTFORD CT 6106 HARTFORD (860) 545-9000 Childrens Voluntary non-profit - Private TRUE 41.7534820 -72.6828120 0   3 9 9003 25540 Hartford-West Hartford, CT Central Hartford County https://data.medicare.gov/resource/xubh-q36u/row-ew6z.c4u9~qxnc 73300 645529 2019-03-25 2018-09-30 97           187               187
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
156 156 KAPIOLANI MEDICAL CENTER FOR WOMEN & CHILDREN 1319 PUNAHOU STREET HONOLULU HI 96826 HONOLULU (808) 983-6000 Childrens Voluntary non-profit - Private TRUE 21.3003960 -157.8342460 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-2vss_bgb6-b6d4 123300 659778 2019-11-26 2019-06-30 156 3         253               253
158 158 SHRINERS HOSPITAL FOR CHILDREN 1310 PUNAHOU STREET HONOLULU HI 96826 HONOLULU (808) 941-4466 Childrens Voluntary non-profit - Private FALSE 21.3002330 -157.8343650 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-jcn3.53aq~rski 123301 644976 2018-05-31 2017-12-31                              
234 234 CHILDREN'S HOME OF PITTSBURGH 5324 PENN AVENUE PITTSBURGH PA 15224 ALLEGHENY (412) 441-4884 Childrens Voluntary non-profit - Private FALSE 40.4646370 -79.9376420 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-7vky_uvyh~58pt 393304 659723 2019-10-01 2019-06-30                              
236 236 UPMC CHILDREN'S HOSPITAL OF PITTSBURGH ONE CHILDREN'S HOSPITAL DRIVE PITTSBURGH PA 15224 ALLEGHENY (412) 692-5325 Childrens Voluntary non-profit - Other TRUE 40.4664773 -79.9522935 1 GEOMETRIC_CENTER 3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-ifxe~erpm.ccc7 393302 659888 2019-11-21 2019-06-30 212 36 12       315               315
300 300 WEISMAN CHILDRENS REHABILITATION HOSPITAL 92 BRICK ROAD, 3RD FLOOR MARLTON NJ 8053 BURLINGTON (856) 489-4520 Childrens Proprietary TRUE 39.8805880 -74.9192090 0   5 34 34005 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Burlington County https://data.medicare.gov/resource/xubh-q36u/row-9nkd_6jvc_38s2 313302 651476 2018-04-12 2017-12-31 18           18               18
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
560 560 HACIENDA CHILDREN'S HOSPITAL, INC. 610 WEST JEROME AVENUE MESA AZ 85210 MARICOPA (602) 243-4231 Childrens Proprietary FALSE 33.3811280 -111.8448920 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-r4wv.uiyn_d6cn 33303 654954 2018-11-26 2018-07-31                              
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                              
739 739 SHRINERS HOSPITALS FOR CHILDREN 3100 SAMFORD AVENUE SHREVEPORT LA 71103 CADDO (318) 222-5704 Childrens Voluntary non-profit - Private FALSE 32.4812950 -93.7566370 0   17 22 22017 43340   Central Caddo Parish https://data.medicare.gov/resource/xubh-q36u/row-yvmb~28rx-rdcg 193301 647125 2018-05-31 2017-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
1005 1005 BOSTON CHILDREN'S HOSPITAL 300 LONGWOOD AVENUE BOSTON MA 2115 SUFFOLK (617) 735-6000 Childrens Voluntary non-profit - Private TRUE 42.3376290 -71.1047830 0   25 25 25025 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Suffolk County https://data.medicare.gov/resource/xubh-q36u/row-bji5_xhyi~vah6 223302 645267 2019-03-13 2018-09-30 294 121         415               415
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                              
1014 1014 FRANCISCAN CHILDREN'S HOSPITAL & REHAB CENTER 30 WARREN STREET BRIGHTON MA 2135 SUFFOLK (617) 254-3800 Childrens Voluntary non-profit - Private FALSE 42.3497560 -71.1444470 0   25 25 25025 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Suffolk County https://data.medicare.gov/resource/xubh-q36u/row-eupv.vp85.xfse 223300 645912 2019-03-06 2018-09-30 112           112               112
1097 1097 J D MCCARTY CENTER FOR CHILDREN 2002 EAST ROBINSON NORMAN OK 73071 CLEVELAND (405) 307-2800 Childrens Government - State FALSE 35.2327430 -97.4100160 0   27 40 40027 36420 Oklahoma City-Shawnee, OK Central Cleveland County https://data.medicare.gov/resource/xubh-q36u/row-whuu_e32b-w4sk 373300 655813 2019-10-07 2019-06-30                              
1188 1188 CHILDREN'S HOSPITAL OF SAN ANTONIO 333 N SANTA ROSA ST SAN ANTONIO TX 78207 BEXAR (210) 704-3342 Childrens Voluntary non-profit - Private TRUE 29.4277960 -98.4978750 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-v67j_ia2t_8xbm 453315 660057 2019-11-26 2019-06-30 108 26       60 194               194
1221 1221 LARABIDA CHILDRENS HOSPITAL I E 65TH ST AT LAKE MICHIGAN CHICAGO IL 60649 COOK (773) 363-6700 Childrens Voluntary non-profit - Private FALSE 41.7768110 -87.6015927 1 GEOMETRIC_CENTER 31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-cnjg.zfnx-s5dn 143301 659950 2019-11-25 2019-06-30 49           49               49
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                              
1226 1226 ANN & ROBERT H LURIE CHILDRENS HOSPITAL OF CHICAGO 225 E CHICAGO AVE, BOX 140 CHICAGO IL 60611 COOK (312) 227-4000 Childrens Voluntary non-profit - Private TRUE 41.8967460 -87.6219060 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-apzm~334d~hd6g 143300 642330 2019-02-01 2018-08-31 168 40 44     60 312               312
1361 1361 SEATTLE CHILDREN'S HOSPITAL 4800 SAND POINT WAY NE, PO BOX C-5371 SEATTLE WA 98105 KING (206) 987-2000 Childrens Voluntary non-profit - Private TRUE 47.6645040 -122.2831690 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-7um6_3ase-art7 503300 646369 2019-04-05 2018-09-30 270 91         361               361
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
1441 1441 SHRINERS HOSPITALS FOR CHILDREN - SALT LAKE CITY 1275 EAST FAIRFAX ROAD SALT LAKE CITY UT 84103 SALT LAKE (801) 536-3500 Childrens Voluntary non-profit - Private FALSE 40.7767640 -111.8511170 0   35 49 49035 41620 Salt Lake City-Provo-Orem, UT Central Salt Lake County https://data.medicare.gov/resource/xubh-q36u/row-z268_bq8t.wgx8 463302 651875 2018-05-31 2017-12-31                              
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
1461 1461 MEMORIAL CARE MILLER CHILDREN'S & WOMEN'S HOSP LB 2801 ATLANTIC AVENUE LONG BEACH CA 90806 LOS ANGELES (562) 933-8001 Childrens Voluntary non-profit - Other FALSE 33.8071070 -118.1850980 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-khay_hirb.gvkk 53309 662488 2019-11-27 2019-06-30 232 30       95 357               357
1490 1490 CHILDREN'S HOSP OF LOS ANGELES 4650 SUNSET BLVD, MS 108 LOS ANGELES CA 90027 LOS ANGELES (323) 669-2164 Childrens Voluntary non-profit - Private TRUE 34.0981450 -118.2908780 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-unns_mtk9.tbkh 53302 660920 2019-12-04 2019-06-30 273 48         379               379
1501 1501 SHRINERS HOSPITALS FOR CHILDREN 3160 GENEVA STREET LOS ANGELES CA 90020 LOS ANGELES (213) 388-3151 Childrens Voluntary non-profit - Private FALSE 34.0677080 -118.2863870 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-zkfj-xhi2.ce89 53310 655536 2018-05-31 2017-12-31                              
1583 1583 VALLEY CHILDREN'S HOSPITAL 9300 VALLEY CHILDRENS PLACE MADERA CA 93636 MADERA (559) 353-5116 Childrens Voluntary non-profit - Private TRUE 36.8845020 -119.8002660 0   39 6 6039 31460 Fresno-Madera, CA Central Madera County https://data.medicare.gov/resource/xubh-q36u/row-6fit-8c83.ta6j 53300 645710 2019-03-27 2018-09-30 200 42       116 358               358
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
1921 1921 SHRINERS HOSPITAL FOR CHILDREN-PORTLAND 3101 SW SAM JACKSON PARK ROAD PORTLAND OR 97239 MULTNOMAH (971) 544-3312 Childrens Voluntary non-profit - Private FALSE 45.5001050 -122.6846030 0   51 41 41051 38900 Portland-Vancouver-Salem, OR-WA Central Multnomah County https://data.medicare.gov/resource/xubh-q36u/row-3x85_ztpc_gwzg 383300 645441 2018-05-31 2017-12-31                              
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
1979 1979 MARY BRIDGE CHILDREN'S HOSPITAL 317 MARTIN LUTHER KING JR W BOX 5299 TACOMA WA 98415 PIERCE (253) 403-1400 Childrens Voluntary non-profit - Other TRUE 47.2587434 -122.4527167 1 ROOFTOP 53 53 53053 42660 Seattle-Tacoma, WA Central Pierce County https://data.medicare.gov/resource/xubh-q36u/row-8c85~gidq~gevc 503301 645385 2018-06-05 2017-12-31                              
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                              
2113 2113 CHILDREN'S HOSPITAL AT MISSION 27700 MEDICAL CENTER RD, 5TH FLOOR MISSION VIEJO CA 92691 ORANGE (949) 365-2408 Childrens Voluntary non-profit - Private TRUE 33.5610153 -117.6653937 1 ROOFTOP 59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-ux4n.c7cr-d5uw 53306 659086 2018-11-30 2018-06-30                              
2118 2118 HEALTHBRIDGE CHILDREN'S HOSPITAL - ORANGE 393 S TUSTIN STREET ORANGE CA 92866 ORANGE (714) 289-2400 Childrens Proprietary FALSE 33.7827720 -117.8357450 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-6j3t.dm9a.bqh8                                      
2119 2119 CHILDREN'S HOSPITAL OF ORANGE COUNTY 1201 W LA VETA AVE ORANGE CA 92868 ORANGE (714) 997-3000 Childrens Voluntary non-profit - Other FALSE 33.7803300 -117.8649600 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-tabq.iupn-ad4g 53304 661466 2019-12-02 2019-06-30 176 24         334               334
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                              
2220 2220 CINCINNATI CHILDREN'S HOSPITAL MEDICAL CENTER 3333 BURNET AVENUE CINCINNATI OH 45229 HAMILTON (513) 636-3333 Childrens Voluntary non-profit - Private TRUE 39.1409470 -84.5003920 0   61 39 39061 17140 Cincinnati-Wilmington-Maysville, OH-KY-IN Central Hamilton County https://data.medicare.gov/resource/xubh-q36u/row-jr9m~pzfs_k2mx 363300 661623 2019-12-02 2019-06-30 489 35 25       615               615
2274 2274 SHRINERS HOSPITAL FOR CHILDREN 911 WEST 5TH AVENUE SPOKANE WA 99204 SPOKANE (509) 623-0422 Childrens Voluntary non-profit - Private FALSE 47.6513980 -117.4259570 0   63 53 53063 44060 Spokane-Spokane Valley-Coeur d'Alene, WA-ID Central Spokane County https://data.medicare.gov/resource/xubh-q36u/row-mctz_2czz-inqw 503302 645453 2018-05-31 2017-12-31                              
2333 2333 SHRINERS HOSPITALS FOR CHILDREN NORTHERN CALIF 2425 STOCKTON BOULEVARD SACRAMENTO CA 95817 SACRAMENTO (916) 453-2000 Childrens Voluntary non-profit - Private FALSE 38.5529930 -121.4562690 0   67 6 6067 40900 Sacramento-Roseville, CA Central Sacramento County https://data.medicare.gov/resource/xubh-q36u/row-pctf.xrmj_v2ef 53311 655537 2018-05-31 2017-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
2512 2512 RADY CHILDREN'S HOSPITAL - SAN DIEGO 3020 CHILDRENS WAY SAN DIEGO CA 92123 SAN DIEGO (858) 576-1700 Childrens Voluntary non-profit - Other FALSE 32.7982600 -117.1508210 0   73 6 6073 41740   Central San Diego County https://data.medicare.gov/resource/xubh-q36u/row-g946~ee4n.abkv 53303 660172 2019-12-02 2019-06-30 193 54       24 401         24 19   444
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
2779 2779 LUCILE SALTER PACKARD CHILDREN'S HSP AT STANFORD 725 WELCH ROAD PALO ALTO CA 94304 SANTA CLARA (650) 497-8000 Childrens Voluntary non-profit - Private FALSE 37.4373820 -122.1750610 0   85 6 6085 41940 San Jose-San Francisco-Oakland, CA Central Santa Clara County https://data.medicare.gov/resource/xubh-q36u/row-kerk.q8n2_pjvp 53305 644220 2019-02-28 2018-08-31 178         44 302               302
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
2952 2952 CHILDREN'S MERCY HOSPITAL KANSAS 5808 W 110TH STREET OVERLAND PARK KS 66211 JOHNSON (913) 234-3000 Childrens Voluntary non-profit - Private FALSE 38.9293260 -94.6535400 0   91 20 20091 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Johnson County https://data.medicare.gov/resource/xubh-q36u/row-knub_mq22.2ryr 173300 660553 2019-11-27 2019-06-30 50           50               50
3019 3019 EAST TENNESSEE CHILDRENS HOSPITAL 2018 CLINCH AVE SW KNOXVILLE TN 37916 KNOX (865) 541-8000 Childrens Voluntary non-profit - Private TRUE 35.9565290 -83.9379200 0   93 47 47093 28940 Knoxville-Morristown-Sevierville, TN Central Knox County https://data.medicare.gov/resource/xubh-q36u/row-ni29-9izu-5p54 443303 660315 2019-11-27 2019-06-30                              
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
3048 3048 CHILDRENS MERCY HOSPITAL 2401 GILLHAM ROAD KANSAS CITY MO 64108 JACKSON (816) 234-3000 Childrens Voluntary non-profit - Private TRUE 39.0827500 -94.5786110 0   95 29 29095 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-gifb-kr87.ze3i 263302 660636 2019-11-26 2019-06-30 186 41       87 314               314
3073 3073 USA HEALTH CHILDREN'S & WOMEN'S HOSPITAL 1700 CENTER STREET MOBILE AL 36604 MOBILE (251) 415-1000 Childrens Government - State TRUE 30.6960820 -88.0768830 0   97 1 1097 33660 Mobile-Daphne-Fairhope, AL Central Mobile County https://data.medicare.gov/resource/xubh-q36u/row-6w9n_e52x~7jkv 13301 652287 2019-07-17 2018-09-30 132           250               250
3180 3180 LIFESCAPE 2501 W 26TH ST SIOUX FALLS SD 57105 MINNEHAHA (605) 444-9500 Childrens Voluntary non-profit - Private FALSE 43.5294580 -96.7562080 0   99 46 46099 43620   Central Minnehaha County https://data.medicare.gov/resource/xubh-q36u/row-iuzk-vbys_y5he 433300 654864 2018-11-19 2018-06-30                              
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
3224 3224 CHILDREN'S HOSPITAL OF PHILADELPHIA 34TH ST & CIVIC CENTER BLVD PHILADELPHIA PA 19104 PHILADELPHIA (215) 590-3745 Childrens Voluntary non-profit - Private TRUE 39.9486690 -75.1929060 0   101 42 42101 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Philadelphia County https://data.medicare.gov/resource/xubh-q36u/row-p6rn~t7a3.ngvz 393303 661971 2019-11-27 2019-06-30 369 88 98       555               555
3238 3238 SHRINERS HOSPITALS FOR CHILDREN - PHILADELPHIA 3551 N BROAD STREET PHILADELPHIA PA 19104 PHILADELPHIA (215) 430-4000 Childrens Voluntary non-profit - Other FALSE 40.0069680 -75.1516990 0   101 42 42101 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Philadelphia County https://data.medicare.gov/resource/xubh-q36u/row-iwpu.igc9.39y9 393309 629311 2018-05-30 2017-12-31                              
3254 3254 JOHNS HOPKINS ALL CHILDREN'S HOSPITAL 501 SIXTH AVENUE SOUTH SAINT PETERSBURG FL 33701 PINELLAS (813) 898-7451 Childrens Voluntary non-profit - Other TRUE 27.7642490 -82.6410120 0   103 12 12103 45300   Central Pinellas County https://data.medicare.gov/resource/xubh-q36u/row-rxaq~253f.593c 103300 661485 2019-12-03 2019-06-30 112 28 22     97 259               259
3480 3480 DAYTON CHILDREN'S HOSPITAL ONE CHILDRENS PLAZA DAYTON OH 45404 MONTGOMERY (937) 641-3450 Childrens Voluntary non-profit - Private TRUE 39.7742909 -84.1676062 1 ROOFTOP 113 39 39113 19380 Dayton-Springfield-Sidney, OH Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-m72e~a4zq_2h8h 363306 655032 2018-12-04 2018-06-30 109 34       34 177               177
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
3508 3508 TEXAS SCOTTISH RITE HOSPITAL FOR CHILDREN 2222 WELBORN STREET DALLAS TX 75219 DALLAS (214) 559-5000 Childrens Voluntary non-profit - Private FALSE 32.8032510 -96.8133570 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-ks6w_wivi.sen3 453314 645801 2019-02-26 2018-09-30                              
3583 3583 ARKANSAS CHILDREN'S HOSPITAL 1 CHILDREN'S WAY, SLOT 301 LITTLE ROCK AR 72202 PULASKI (501) 364-1100 Childrens Voluntary non-profit - Private TRUE 34.7428220 -92.2920060 0   119 5 5119 30780 Little Rock-North Little Rock, AR Central Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-p66z~xhi7.pxk4 43300 660352 2019-12-03 2019-06-30 153 26 30 10   104 336               336
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
3761 3761 CUMBERLAND HOSPITAL LLC 9407 CUMBERLAND ROAD NEW KENT VA 23124 NEW KENT (804) 966-2242 Childrens Proprietary FALSE 37.5455310 -76.9792200 0   127 51 51127 40060   Outlying New Kent County https://data.medicare.gov/resource/xubh-q36u/row-2t5p~njzu.inug                                      
3766 3766 UNIVERSITY PEDIATRIC HOSPITAL PUERTO RICO MEDICAL CENTER IN RIO PIEDRAS SAN JUAN PR 935 SAN JUAN (787) 777-3232 Childrens Government - State TRUE 18.3958646 -66.0736306 1 GEOMETRIC_CENTER 127 72 72127 41980 San Juan-Carolina, PR Central San Juan Municipio https://data.medicare.gov/resource/xubh-q36u/row-aat9~yvnm_fjvd 403301 640173 2018-11-30 2018-06-30                              
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
3935 3935 EL PASO CHILDREN'S HOSPITAL 4845 ALAMEDA AVENUE EL PASO TX 79905 EL PASO (915) 521-7148 Childrens Voluntary non-profit - Private TRUE 31.7706550 -106.4342000 0   141 48 48141 21340 El Paso-Las Cruces, TX-NM Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-ncax.wugj~a6h5 453313 646113 2019-03-01 2018-09-30 76 24       22 122               122
3940 3940 ARKANSAS CHILDREN'S NORTHWEST, INC 2601 GENE GEORGE BOULEVARD SPRINGDALE AR 72762 WASHINGTON (479) 725-6800 Childrens Voluntary non-profit - Private TRUE 36.1633250 -94.1926020 0   143 5 5143 22220   Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-ancy_ajta_8yhj 43301 660747 2019-12-03 2019-06-30 24           24               24
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
4106 4106 ST JUDE CHILDRENS RESEARCH HOSPITAL 262 DANNY THOMAS PLACE MEMPHIS TN 38105 SHELBY (901) 495-3300 Childrens Voluntary non-profit - Private FALSE 35.1545600 -90.0425300 0   157 47 47157 32820 Memphis-Forrest City, TN-MS-AR Central Shelby County https://data.medicare.gov/resource/xubh-q36u/row-8bmc~acqt~mywf 443302 662074 2019-12-02 2019-06-30                              
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
4214 4214 SHRINERS HOSPITALS FOR CHILDREN 815 MARKET STREET GALVESTON TX 77550 GALVESTON (409) 770-6600 Childrens Voluntary non-profit - Private FALSE 29.3097470 -94.7771870 0   167 48 48167 26420 Houston-The Woodlands, TX Central Galveston County https://data.medicare.gov/resource/xubh-q36u/row-ftsq~mmvm_77ft                                      
4351 4351 RANKEN JORDAN PEDIATRIC BRIDGE HOSPITAL 11365 DORSETT ROAD MARYLAND HEIGHTS MO 63043 ST. LOUIS (314) 872-6400 Childrens Voluntary non-profit - Private FALSE 38.7095000 -90.4158930 0   189 29 29189 41180 St. Louis-St. Charles-Farmington, MO-IL Central St. Louis County https://data.medicare.gov/resource/xubh-q36u/row-dvji.ztfu-vequ 263303 660637 2019-11-27 2019-06-30 60           60               60
4432 4432 SHRINERS HOSPITALS FOR CHILDREN 6977 MAIN STREET HOUSTON TX 77030 HARRIS (713) 797-1616 Childrens Voluntary non-profit - Other FALSE 29.7047380 -95.4061740 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-zk7z~jazy_wtka 453312 651360 2018-07-12 2017-12-31                              
4434 4434 TEXAS CHILDRENS HOSP 6621 FANNIN STREET HOUSTON TX 77030 HARRIS (832) 824-1000 Childrens Voluntary non-profit - Private TRUE 29.7087620 -95.4015320 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-b3be_2yvs~n2mh 453304 654392 2019-09-16 2018-09-30 495           795               795
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
4561 4561 COVENANT CHILDRENS HOSPITAL 4015 22ND PLACE LUBBOCK TX 79410 LUBBOCK (806) 725-7975 Childrens Voluntary non-profit - Private TRUE 33.5741410 -101.9004260 0   303 48 48303 31180 Lubbock-Levelland, TX Central Lubbock County https://data.medicare.gov/resource/xubh-q36u/row-a699~c7jg~uc7g 453306 660895 2019-12-03 2019-06-30 138 20       46 204               204
4598 4598 DRISCOLL CHILDRENS HOSPITAL 3533 S ALAMEDA BOX 6530 CORPUS CHRISTI TX 78411 NUECES (361) 739-4846 Childrens Voluntary non-profit - Private TRUE 27.7488804 -97.3863616 1 ROOFTOP 355 48 48355 18580 Corpus Christi-Kingsville-Alice, TX Central Nueces County https://data.medicare.gov/resource/xubh-q36u/row-q6ns-86wd.av5n 453301 650786 2019-06-25 2018-08-31 101 20       41 162               162
4633 4633 COOK CHILDRENS MEDICAL CENTER 801 SEVENTH AVENUE FORT WORTH TX 76104 TARRANT (682) 885-4000 Childrens Voluntary non-profit - Private TRUE 32.7364880 -97.3419750 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-78ag.2jb3-taix 453300 645193 2019-03-05 2018-09-30 255           392               392
4666 4666 DELL CHILDREN'S MEDICAL CENTER OF CENTRAL TEXAS 4900 MUELLER BLVD AUSTIN TX 78723 TRAVIS (512) 324-0000 Childrens Voluntary non-profit - Private TRUE 30.3025490 -97.7049570 0   453 48 48453 12420   Central Travis County https://data.medicare.gov/resource/xubh-q36u/row-2zt9_yffw~gyhs 453310 661423 2019-11-25 2019-06-30 127         76 203               203
4721 4721 MOUNT WASHINGTON PEDIATRIC HOSPITAL 1708 WEST ROGERS AVENUE BALTIMORE MD 21209 BALTIMORE CITY (410) 578-5050 Childrens Voluntary non-profit - Private FALSE 39.3620290 -76.6535510 0   510 24 24510 12580 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Baltimore city https://data.medicare.gov/resource/xubh-q36u/row-j9gg.asb8~b9dn 213300 659973 2019-12-02 2019-06-30 102           102               102
4722 4722 KENNEDY KRIEGER INSTITUTE 707 NORTH BROADWAY BALTIMORE MD 21205 BALTIMORE CITY (443) 923-9301 Childrens Voluntary non-profit - Private TRUE 39.2987350 -76.5941530 0   510 24 24510 12580 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Baltimore city https://data.medicare.gov/resource/xubh-q36u/row-gfwe~6biu.28ps 213301 659974 2019-12-02 2019-06-30 50           50               50
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                              
4750 4750 CHILDRENS HOSPITAL OF THE KINGS DAUGHTERS INC 601 CHILDREN'S LANE NORFOLK VA 23507 NORFOLK CITY (757) 668-9647 Childrens Voluntary non-profit - Private TRUE 36.8617600 -76.3013700 0   710 51 51710 47260 Virginia Beach-Norfolk, VA-NC Central Norfolk city https://data.medicare.gov/resource/xubh-q36u/row-grcw_fsac-hks2 493301 658920 2019-11-18 2019-06-30 50         14 185               185
4759 4759 CHILDREN'S HOSP OF RICHMOND OF THE VCU HEALTH SYS 2924 BROOK ROAD RICHMOND VA 23220 RICHMOND CITY (804) 321-7474 Childrens Voluntary non-profit - Private FALSE 37.5702610 -77.4492070 0   760 51 51760 40060   Central Richmond city https://data.medicare.gov/resource/xubh-q36u/row-3rgk-iaha-6s92 493302 660060 2019-11-26 2019-06-30                              

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