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

51 rows where "filed_date" is on date 2019-11-22

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, hospital_type, hospital_ownership, emergency_services, statefips, cbsacode, csatitle, centraloutlyingcounty, fy_end_date, icu_beds, coronary_beds, surg_icu_beds, oth_spec_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_beds, nursing_fac_beds, fy_end_date (date)

filed_date (date) ✖

  • 2019-11-22 · 51 ✖
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
237 237 UPMC ST MARGARET 815 FREEPORT ROAD PITTSBURGH PA 15215 ALLEGHENY (412) 784-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.4874720 -79.8960380 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-iz5k~fx5f.72zy 390102 660441 2019-11-22 2019-06-30 208 14         222   28           250
381 381 BEAVER COUNTY MEMORIAL HOSPITAL 212 EAST 8TH STREET BEAVER OK 73932 BEAVER (580) 625-4551 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.8101950 -100.5164240 0   7 40 40007         https://data.medicare.gov/resource/xubh-q36u/row-97xz.ezcx-saem 371322 659862 2019-11-22 2019-06-30 24           24               24
402 402 ST VINCENTS BLOUNT 150 GILBREATH DRIVE ONEONTA AL 35121 BLOUNT (205) 274-3000 Critical Access Hospitals Voluntary non-profit - Private FALSE 33.9325370 -86.4930590 0   9 1 1009 13820 Birmingham-Hoover-Talladega, AL Outlying Blount County https://data.medicare.gov/resource/xubh-q36u/row-nhvc-v4py.tnm6 11305 659402 2019-11-22 2019-06-30 19 6         25               25
725 725 CHICOT MEMORIAL MEDICAL CENTER 2729 SOUTH HIGHWAY 65 & 82 LAKE VILLAGE AR 71653 CHICOT (870) 265-5351 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.3056420 -91.2903530 0   17 5 5017         https://data.medicare.gov/resource/xubh-q36u/row-n4n3~4tmq_i4ky 41328 660163 2019-11-22 2019-03-31 25           25               25
760 760 TRACE REGIONAL HOSP AND SWING BED 1002 EAST MADISON STREET HOUSTON MS 38851 CHICKASAW (662) 456-3700 Acute Care Hospitals Proprietary FALSE 33.8947900 -88.9850850 0   17 28 28017         https://data.medicare.gov/resource/xubh-q36u/row-kmgr_friv-daby 250017 659509 2019-11-22 2019-06-30 39           39 15     66       120
786 786 GRAND VIEW HOSPITAL 700 LAWN AVENUE SELLERSVILLE PA 18960 BUCKS (215) 453-4615 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.3625670 -75.3241690 0   17 42 42017 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Bucks County https://data.medicare.gov/resource/xubh-q36u/row-8e5m_vbcg_jbzn 390057 659719 2019-11-22 2019-06-30 142 14         162   14           176
855 855 MERCY MEDICAL CENTER 2700 NW STEWART PARKWAY ROSEBURG OR 97471 DOUGLAS (541) 673-0611 Acute Care Hospitals Government - Hospital District or Authority TRUE 43.2368240 -123.3716040 0   19 41 41019 40700   Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-kmh5-zbwa-3mz2 380027 659601 2019-11-22 2019-06-30 108 32         140               140
863 863 SYCAMORE SHOALS HOSPITAL 1501 WEST ELK AVENUE ELIZABETHTON TN 37643 CARTER (423) 542-1300 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.3439410 -82.2496230 0   19 47 47019 27740 Johnson City-Kingsport-Bristol, TN-VA Central Carter County https://data.medicare.gov/resource/xubh-q36u/row-sski_7z8j~5bzg 440018 660039 2019-11-22 2019-06-30 101 8         109 12             121
877 877 ST VINCENT'S CHILTON 2030 LAY DAM ROAD CLANTON AL 35045 CHILTON (205) 258-4400 Acute Care Hospitals Voluntary non-profit - Church TRUE 32.8765850 -86.6235110 0   21 1 1021 13820 Birmingham-Hoover-Talladega, AL Outlying Chilton County https://data.medicare.gov/resource/xubh-q36u/row-7qdj~999i.xcfe 10173 659401 2019-11-22 2019-06-30 20 6         26               26
987 987 SOUTH LINCOLN MEDICAL CENTER - CAH 711 ONYX STREET KEMMERER WY 83101 LINCOLN (307) 877-4401 Critical Access Hospitals Government - Hospital District or Authority TRUE 41.7895800 -110.5406070 0   23 56 56023         https://data.medicare.gov/resource/xubh-q36u/row-fvca.ncci~gnkk 531315 661692 2019-11-22 2019-06-30 13           13         24     37
1119 1119 BEAVER DAM COMMUNITY HOSPITAL 707 S UNIVERSITY AVE BEAVER DAM WI 53916 DODGE (920) 887-7181 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.4484770 -88.8281970 0   27 55 55027 13180 Milwaukee-Racine-Waukesha, WI Central Dodge County https://data.medicare.gov/resource/xubh-q36u/row-y2kp~hptd-k6ec 520076 659553 2019-11-22 2019-06-30 119 6         125       115       240
1177 1177 METHODIST HOSPITAL 7700 FLOYD CURL DR SAN ANTONIO TX 78229 BEXAR (210) 575-4000 Acute Care Hospitals Proprietary TRUE 29.5068400 -98.5729760 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-xgb9_6gfp~4v63 450388 659736 2019-11-22 2019-06-30 1223 207       110 1560 10 67           1637
1235 1235 LORETTO HOSPITAL 645 SOUTH CENTRAL AVE CHICAGO IL 60644 COOK (773) 626-4300 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.8720420 -87.7644430 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-g4dy-29n9_g2wy 140083 659947 2019-11-22 2019-06-30 110 12         122               122
1430 1430 CUMBERLAND MEDICAL CENTER 421 S MAIN ST CROSSVILLE TN 38555 CUMBERLAND (931) 484-9511 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.9427130 -85.0230070 0   35 47 47035 18900   Central Cumberland County https://data.medicare.gov/resource/xubh-q36u/row-8st6_g3vp.a2j7 440009 659449 2019-11-22 2019-06-30 61 12         73               73
1632 1632 DELTA MEMORIAL HOSPITAL 811 HIGHWAY 65 SOUTH DUMAS AR 71639 DESHA (870) 382-4303 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.8732940 -91.4815000 0   41 5 5041         https://data.medicare.gov/resource/xubh-q36u/row-65hi_7cx4-4bx3 41326 659558 2019-11-22 2019-06-30 25           25               25
1659 1659 GRADY MEMORIAL HOSPITAL 561 WEST CENTRAL AVENUE DELAWARE OH 43015 DELAWARE (740) 368-5145 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.3060090 -83.0887260 0   41 39 39041 18140 Columbus-Marion-Zanesville, OH Central Delaware County https://data.medicare.gov/resource/xubh-q36u/row-5s7k.v9f3~w2pv 360210 661609 2019-11-22 2019-06-30 58 6         64               64
1865 1865 DUBLIN METHODIST HOSPITAL 7500 HOSPITAL AVENUE DUBLIN OH 43016 FRANKLIN (614) 544-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.1004050 -83.1630550 0   49 39 39049 18140 Columbus-Marion-Zanesville, OH Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-778y~b337.x73k 360348 659843 2019-11-22 2019-06-30 102           102               102
1923 1923 OHSU HOSPITAL AND CLINICS 3181 SW SAM JACKSON PARK ROAD PORTLAND OR 97239 MULTNOMAH (503) 494-6245 Acute Care Hospitals Voluntary non-profit - Other TRUE 45.4992010 -122.6879740 0   51 41 41051 38900 Portland-Vancouver-Salem, OR-WA Central Multnomah County https://data.medicare.gov/resource/xubh-q36u/row-yk4c-r5a6.3wkx 380009 660008 2019-11-22 2019-06-30 417 79         562               562
2061 2061 ST VINCENT HEART CENTER OF INDIANA LLC 10580 N MERIDIAN ST INDIANAPOLIS IN 46290 HAMILTON (317) 583-5000 Acute Care Hospitals Proprietary TRUE 39.9383110 -86.1587220 0   57 18 18057 26900 Indianapolis-Carmel-Muncie, IN Central Hamilton County https://data.medicare.gov/resource/xubh-q36u/row-w7fb_red4.4uti 150153 659784 2019-11-22 2019-06-30 107           107               107
2134 2134 PIEDMONT ATHENS REGIONAL MEDICAL CENTER 1199 PRINCE AVENUE ATHENS GA 30606 CLARKE (706) 475-7000 Acute Care Hospitals Voluntary non-profit - Other TRUE 33.9623770 -83.3977330 0   59 13 13059 12020 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Clarke County https://data.medicare.gov/resource/xubh-q36u/row-599w-riw6~r6rq 110074 659937 2019-11-22 2019-06-30 301 24 12     20 357               357
2166 2166 GREENEVILLE COMMUNITY HOSPITAL 1420 TUSCULUM BOULEVARD GREENEVILLE TN 37745 GREENE (423) 639-3151 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.1753930 -82.7908930 0   59 47 47059 24620   Central Greene County https://data.medicare.gov/resource/xubh-q36u/row-mxnu-nrwk~z6fa 440050 660041 2019-11-22 2019-06-30 42 7         49 14 11   23       97
2196 2196 MINERAL COMMUNITY HOSPITAL 1208 6TH AVE E SUPERIOR MT 59872 MINERAL (406) 822-4841 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.1847260 -114.8765790 0   61 30 30061         https://data.medicare.gov/resource/xubh-q36u/row-j5f4.vdmh-uusx 271331 660639 2019-11-22 2019-06-30 24           24               24
2211 2211 MOUNTRAIL COUNTY MEDICAL CENTER INC 615 6TH ST SE STANLEY ND 58784 MOUNTRAIL (701) 628-2424 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.3125040 -102.3808690 0   61 38 38061         https://data.medicare.gov/resource/xubh-q36u/row-b8p8-yzkh-reuy 351301 659831 2019-11-22 2019-06-30 11           11               11
2213 2213 BETHESDA NORTH 10500 MONTGOMERY ROAD CINCINNATI OH 45242 HAMILTON (513) 865-1241 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.2519680 -84.3439860 0   61 39 39061 17140 Cincinnati-Wilmington-Maysville, OH-KY-IN Central Hamilton County https://data.medicare.gov/resource/xubh-q36u/row-a8wv_rfph_hrmf 360179 659842 2019-11-22 2019-06-30 327 38         365               365
2216 2216 TRIHEALTH EVENDALE HOSPITAL 3155 GLENDALE MILFORD ROAD CINCINNATI OH 45241 HAMILTON (513) 454-2222 Acute Care Hospitals Voluntary non-profit - Private FALSE 39.2539140 -84.4198340 0   61 39 39061 17140 Cincinnati-Wilmington-Maysville, OH-KY-IN Central Hamilton County https://data.medicare.gov/resource/xubh-q36u/row-wki7.4fi8-6y23 360362 659845 2019-11-22 2019-06-30 29           29               29
2217 2217 GOOD SAMARITAN HOSPITAL 375 DIXMYTH AVENUE CINCINNATI OH 45220 HAMILTON (513) 862-2646 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.1406120 -84.5222700 0   61 39 39061 17140 Cincinnati-Wilmington-Maysville, OH-KY-IN Central Hamilton County https://data.medicare.gov/resource/xubh-q36u/row-6uz9-sgfb_psja 360134 659840 2019-11-22 2019-06-30 266 29     10   365 27             392
2500 2500 ST VINCENT'S BIRMINGHAM 810 ST VINCENT'S DRIVE BIRMINGHAM AL 35205 JEFFERSON (205) 939-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.5080150 -86.7887550 0   73 1 1073 13820 Birmingham-Hoover-Talladega, AL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-6naf-9cek~29rm 10056 659398 2019-11-22 2019-06-30 275 83 12     30 400               400
2502 2502 ST VINCENT'S EAST 50 MEDICAL PARK EAST DRIVE BIRMINGHAM AL 35235 JEFFERSON (205) 838-3122 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.5953510 -86.6651820 0   73 1 1073 13820 Birmingham-Hoover-Talladega, AL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-tfdr.ige8~3px7 10011 659397 2019-11-22 2019-06-30 209 30 56   14   309 20 20           349
2805 2805 UPMC HORIZON 110 NORTH MAIN STREET GREENVILLE PA 16125 MERCER (724) 588-2100 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.4111260 -80.3722010 0   85 42 42085 49660 Youngstown-Warren, OH-PA Central Mercer County https://data.medicare.gov/resource/xubh-q36u/row-gpkb.zkc2~exgp 390178 659875 2019-11-22 2019-06-30 116 6         122               122
2979 2979 JOHNSON COUNTY COMMUNITY HOSPITAL 1901 S SHADY ST MOUNTAIN CITY TN 37683 JOHNSON (423) 727-1110 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.4537830 -81.7987220 0   91 47 47091         https://data.medicare.gov/resource/xubh-q36u/row-48iq_hv6w-z7xq 441304 660044 2019-11-22 2019-06-30 2           2               2
3049 3049 RESEARCH MEDICAL CENTER 2316 E MEYER BLVD KANSAS CITY MO 64132 JACKSON (816) 276-4000 Acute Care Hospitals Proprietary TRUE 39.0071690 -94.5587310 0   95 29 29095 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-4hig.ydmh~ba6w 260027 660238 2019-11-22 2018-12-31 283 28         330 82 30           442
3372 3372 LEONARD J CHABERT MEDICAL CENTER 1978 INDUSTRIAL BLVD HOUMA LA 70363 TERREBONNE (985) 873-2200 Acute Care Hospitals Voluntary non-profit - Other TRUE 29.5713180 -90.6876250 0   109 22 22109 26380   Central Terrebonne Parish https://data.medicare.gov/resource/xubh-q36u/row-muz6_tkv3.tehw 190183 660384 2019-11-22 2019-06-30 58 8         66 24             90
3462 3462 PIEDMONT FAYETTE HOSPITAL 1255 HIGHWAY 54 WEST FAYETTEVILLE GA 30214 FAYETTE (770) 719-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.4505930 -84.5105260 0   113 13 13113 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Fayette County https://data.medicare.gov/resource/xubh-q36u/row-gfr6_jzg4.vm89 110215 659234 2019-11-22 2019-06-30 204 66       20 290               290
3495 3495 BAYLOR SCOTT AND WHITE HEART AND VASCULAR HOSPITAL 621 NORTH HALL STREET DALLAS TX 75226 DALLAS (214) 820-0670 Acute Care Hospitals Proprietary TRUE 32.7882880 -96.7806630 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-gher.dgrm-kty6 450851 659614 2019-11-22 2019-06-30 53           53               53
3517 3517 ST VINCENT'S ST CLAIR 7063 VETERANS PARKWAY PELL CITY AL 35125 ST. CLAIR (205) 338-3301 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.6055680 -86.3023800 0   115 1 1115 13820 Birmingham-Hoover-Talladega, AL Outlying St. Clair County https://data.medicare.gov/resource/xubh-q36u/row-env7.dc7s_bwtg 10130 659400 2019-11-22 2019-06-30 34 6         40               40
3679 3679 SPECTRUM HEALTH GERBER MEMORIAL 212 S SULLIVAN ST FREMONT MI 49412 NEWAYGO (231) 924-3300 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.4643830 -85.9507630 0   123 26 26123         https://data.medicare.gov/resource/xubh-q36u/row-hx3e~pnt6_cpqb 231338 659581 2019-11-22 2019-06-30 16 9         25               25
3838 3838 OSS ORTHOPAEDIC HOSPITAL 1861 POWDER MILL RD YORK PA 17402 YORK (717) 718-2000 Acute Care Hospitals Proprietary FALSE 39.9166900 -76.6968130 0   133 42 42133 49620 Harrisburg-York-Lebanon, PA Central York County https://data.medicare.gov/resource/xubh-q36u/row-9itg-k673_kn2f 390325 659884 2019-11-22 2019-06-30 30           30               30
3891 3891 SPECTRUM HEALTH ZEELAND COMMUNITY HOSPITAL 8333 FELCH ST ZEELAND MI 49464 OTTAWA (616) 772-4644 Acute Care Hospitals Voluntary non-profit - Private FALSE 42.8195390 -85.9881290 0   139 26 26139 24340 Grand Rapids-Wyoming-Muskegon, MI Outlying Ottawa County https://data.medicare.gov/resource/xubh-q36u/row-q68w-vf6c.adcb 230003 659580 2019-11-22 2019-06-30 48 7         55               55
3995 3995 KIRBY MEDICAL CENTER 1000 MEDICAL CENTER DRIVE MONTICELLO IL 61856 PIATT (217) 762-2115 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.0601630 -88.5637700 0   147 17 17147 16580   Outlying Piatt County https://data.medicare.gov/resource/xubh-q36u/row-cyx9_rxkq~v7gg 141301 659780 2019-11-22 2019-06-30 16           16               16
4055 4055 BROADLAWNS MEDICAL CENTER 1801 HICKMAN ROAD DES MOINES IA 50314 POLK (515) 282-2200 Acute Care Hospitals Government - Local TRUE 41.6150970 -93.6411550 0   153 19 19153 19780 Des Moines-Ames-West Des Moines, IA Central Polk County https://data.medicare.gov/resource/xubh-q36u/row-dzd6.727y_ubfk 160101 659567 2019-11-22 2019-06-30 111 6         117               117
4317 4317 REX HOSPITAL 4420 LAKE BOONE TRAIL RALEIGH NC 27607 WAKE (919) 784-3100 Acute Care Hospitals Government - State TRUE 35.8154580 -78.7050320 0   183 37 37183 39580 Raleigh-Durham-Chapel Hill, NC Central Wake County https://data.medicare.gov/resource/xubh-q36u/row-63xd~rcxd~ynej 340114 659712 2019-11-22 2019-06-30 346 51 42       439       120       559
4389 4389 IOWA SPECIALTY HOSPITAL - BELMOND 403 FIRST STREET SE BELMOND IA 50421 WRIGHT (641) 444-3223 Critical Access Hospitals Government - Local TRUE 42.8449880 -93.6128550 0   197 19 19197         https://data.medicare.gov/resource/xubh-q36u/row-8b8k.b5cg~72n2 161301 659568 2019-11-22 2019-06-30 22           22               22
4409 4409 MEMORIAL HERMANN MEMORIAL CITY MEDICAL CENTER 921 GESSNER HOUSTON TX 77024 HARRIS (713) 242-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 29.7810230 -95.5444220 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-5cxu-jdn6.jcsk 450610 659540 2019-11-22 2019-06-30 360 60       24 444               444
4453 4453 RUSSELL COUNTY HOSPITAL 153 DOWELL ROAD RUSSELL SPRINGS KY 42642 RUSSELL (270) 866-4141 Critical Access Hospitals Government - Local TRUE 37.0577070 -85.0668840 0   207 21 21207         https://data.medicare.gov/resource/xubh-q36u/row-sgx3_zv6f.tpnh 181330 660570 2019-11-22 2019-06-30 23 2         25               25
4461 4461 MORGAN MEDICAL CENTER 1740 LIONS CLUB ROAD MADISON GA 30650 MORGAN (706) 342-1667 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.5675450 -83.4720040 0   211 13 13211 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Outlying Morgan County https://data.medicare.gov/resource/xubh-q36u/row-55f2~6g7b_y7ku 111304 659236 2019-11-22 2019-06-30 25           25               25
4479 4479 PIEDMONT NEWTON HOSPITAL 5126 HOSPITAL DRIVE NE COVINGTON GA 30014 NEWTON (770) 786-7053 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.6026730 -83.8480820 0   217 13 13217 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Newton County https://data.medicare.gov/resource/xubh-q36u/row-esav.9mwz.esp9 110018 659488 2019-11-22 2019-06-30 78 10       6 94               94
4494 4494 PIEDMONT MOUNTAINSIDE HOSPITAL INC 1266 HIGHWAY 515 SOUTH JASPER GA 30143 PICKENS (706) 301-5269 Acute Care Hospitals Voluntary non-profit - Other TRUE 34.4474660 -84.4465610 0   227 13 13227 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Outlying Pickens County https://data.medicare.gov/resource/xubh-q36u/row-3378.2eh9-tse8 110225 659235 2019-11-22 2019-06-30 46 6         52               52
4518 4518 PIEDMONT ROCKDALE HOSPITAL 1412 MILSTEAD AVENUE, NE CONYERS GA 30012 ROCKDALE (770) 918-3000 Acute Care Hospitals Proprietary FALSE 33.6822390 -84.0019410 0   247 13 13247 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Rockdale County https://data.medicare.gov/resource/xubh-q36u/row-x66k.dxnr.f5df 110091 659231 2019-11-22 2019-06-30 105 16         141               141
4555 4555 PIEDMONT WALTON HOSPITAL, INC 2151 W SPRING STREET MONROE GA 30655 WALTON (770) 267-8461 Acute Care Hospitals Proprietary TRUE 33.7986350 -83.7463160 0   297 13 13297 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Walton County https://data.medicare.gov/resource/xubh-q36u/row-ncms_jxz6_rqcg 110046 659772 2019-11-22 2019-06-30 69 7         76               76
4581 4581 NOCONA GENERAL HOSPITAL 100 PARK ROAD NOCONA TX 76255 MONTAGUE (940) 825-3235 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.7775590 -97.7315640 0   337 48 48337         https://data.medicare.gov/resource/xubh-q36u/row-f6j5-6zwa-5e54 450641 659541 2019-11-22 2019-06-30 18           18               18
4668 4668 NORTH AUSTIN MEDICAL CENTER 12221 MOPAC EXPRESSWAY NORTH AUSTIN TX 78758 TRAVIS (512) 901-1000 Acute Care Hospitals Proprietary TRUE 30.4121440 -97.7081130 0   453 48 48453 12420   Central Travis County https://data.medicare.gov/resource/xubh-q36u/row-2sap-qyma-ketx 450809 659544 2019-11-22 2019-06-30 290 24       57 377   16           393

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