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

124 rows where "filed_date" is on date 2019-11-25 sorted by zip_code

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

filed_date (date) ✖

  • 2019-11-25 · 124 ✖
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
518 518 SOUTHERN NH MEDICAL CENTER 8 PROSPECT STREET NASHUA NH 3060 HILLSBOROUGH (603) 577-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.7560610 -71.4612290 0   11 33 33011 31700 Boston-Worcester-Providence, MA-RI-NH-CT Central Hillsborough County https://data.medicare.gov/resource/xubh-q36u/row-z29g.nws7.yp8q 300020 659990 2019-11-25 2019-06-30 131 11         142 18             160
2 2 HUGGINS HOSPITAL 240 SOUTH MAIN STREET WOLFEBORO NH 3894 CARROLL (603) 569-7500 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.5809440 -71.2015750 0   3 33 33003         https://data.medicare.gov/resource/xubh-q36u/row-u6j2-zv25.9ghd 301312 659991 2019-11-25 2018-09-30 21 4         25               25
506 506 MAINEGENERAL MEDICAL CENTER 35 MEDICAL CENTER PARKWAY AUGUSTA ME 4330 KENNEBEC (207) 626-1000 Acute Care Hospitals Voluntary non-profit - Other TRUE 44.3608530 -69.7857180 0   11 23 23011 12300   Central Kennebec County https://data.medicare.gov/resource/xubh-q36u/row-k6q5-wdks.vqnn 200039 659964 2019-11-25 2019-06-30 156 16         172   20           192
832 832 MILLINOCKET REGIONAL HOSPITAL 200 SOMERSET STREET MILLINOCKET ME 4462 PENOBSCOT (207) 723-5161 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.6527290 -68.7150760 0   19 23 23019 12620   Central Penobscot County https://data.medicare.gov/resource/xubh-q36u/row-j6pc.k4d7~avr8 201307 659965 2019-11-25 2019-06-30 25           25               25
215 215 HACKENSACK MERIDIAN HEALTH PASCACK VALLEY MEDICAL 250 OLD HOOK ROAD WESTWOOD NJ 7675 BERGEN (201) 383-1035 Acute Care Hospitals Proprietary TRUE 40.9836580 -74.0141950 0   3 34 34003 35620 New York-Newark, NY-NJ-CT-PA Central Bergen County https://data.medicare.gov/resource/xubh-q36u/row-kwcd-72qg_ygd9 310130 660416 2019-11-25 2019-06-30 64 9         78               78
1301 1301 CLARION HOSPITAL ONE HOSPITAL DRIVE CLARION PA 16214 CLARION (814) 226-9500 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.1927583 -79.3976930 1 ROOFTOP 31 42 42031         https://data.medicare.gov/resource/xubh-q36u/row-5n3x.3zm2.8hqq 390093 660440 2019-11-25 2019-06-30 50 7         57   8           65
2035 2035 CHAMBERSBURG HOSPITAL 112 NORTH SEVENTH STREET CHAMBERSBURG PA 17201 FRANKLIN (717) 267-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9349150 -77.6474510 0   55 42 42055 16540 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-iq68~7hvz.5n6c 390151 659608 2019-11-25 2019-06-30 211   24     7 242 26 17           285
2036 2036 WAYNESBORO HOSPITAL 501 EAST MAIN ST WAYNESBORO PA 17268 FRANKLIN (717) 765-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.7518060 -77.5705810 0   55 42 42055 16540 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-uwye.3yp9-qu7a 390138 659607 2019-11-25 2019-06-30 57           57               57
2660 2660 WILKES-BARRE GENERAL HOSPITAL 575 NORTH RIVER STREET WILKES-BARRE PA 18764 LUZERNE (570) 829-8111 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.2582610 -75.8681650 0   79 42 42079 42540   Central Luzerne County https://data.medicare.gov/resource/xubh-q36u/row-jy6y.9gqv-dbyu 390137 659527 2019-11-25 2019-06-30 228 30         258   19           277
902 902 FREDERICK HEALTH HOSPITAL 400 WEST SEVENTH ST FREDERICK MD 21701 FREDERICK (240) 566-3300 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.4237450 -77.4140700 0   21 24 24021 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Outlying Frederick County https://data.medicare.gov/resource/xubh-q36u/row-kk8k_tw4w-dcjn 210005 659799 2019-11-25 2019-06-30 248 18       15 281               281
686 686 UNION HOSPITAL OF CECIL COUNTY 106 BOW STREET ELKTON MD 21921 CECIL (410) 392-7009 Acute Care Hospitals Voluntary non-profit - Private FALSE 39.6080100 -75.8310280 0   15 24 24015 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Cecil County https://data.medicare.gov/resource/xubh-q36u/row-pkde-hn33.kiax 210032 660230 2019-11-25 2019-06-30 91 5         96               96
4756 4756 MEDICAL COLLEGE OF VIRGINIA HOSPITALS BOX 980510 1250 EAST MARSHALL STREET RICHMOND VA 23298 RICHMOND CITY (804) 828-0938 Acute Care Hospitals Government - Hospital District or Authority TRUE 37.5400695 -77.4299163 1 ROOFTOP 760 51 51760 40060   Central Richmond city https://data.medicare.gov/resource/xubh-q36u/row-p6wh~7aeu~ic6q 490032 659745 2019-11-25 2019-06-30 502 28 14 16 28   715 28 38           781
3571 3571 COMMUNITY MEMORIAL HOSPITAL 1755 NORTH MECKLENBURG AVENUE SOUTH HILL VA 23970 MECKLENBURG (434) 447-3151 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.7476560 -78.1041060 0   117 51 51117         https://data.medicare.gov/resource/xubh-q36u/row-k7c8~fbew_tsmb 490098 659747 2019-11-25 2019-06-30 56   10       66       140       206
4367 4367 JOHNSTON MEMORIAL HOSPITAL 16000 JOHNSTON MEMORIAL DRIVE ABINGDON VA 24211 WASHINGTON (276) 258-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.7206700 -81.9085600 0   191 51 51191 28700 Johnson City-Kingsport-Bristol, TN-VA Outlying Washington County https://data.medicare.gov/resource/xubh-q36u/row-ysbq~qbac~97nx 490053 660721 2019-11-25 2019-06-30 101 14         115               115
1678 1678 STONEWALL JACKSON MEMORIAL HOSPITAL 230 HOSPITAL PLAZA WESTON WV 26452 LEWIS (304) 269-8080 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.0482850 -80.4927430 0   41 54 54041         https://data.medicare.gov/resource/xubh-q36u/row-2afu_zh5p.j9t2 510038 660725 2019-11-25 2019-06-30 64 6         70               70
4366 4366 WAYNE MEMORIAL HOSPITAL 2700 WAYNE MEMORIAL DR GOLDSBORO NC 27534 WAYNE (919) 736-1110 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.4008310 -77.9533420 0   191 37 37191 24140   Central Wayne County https://data.medicare.gov/resource/xubh-q36u/row-4zsd_c7iy.v8vj 340010 659334 2019-11-25 2019-06-30 245 16         261               261
3216 3216 JOHNSTON HEALTH 509 BRIGHT LEAF BLVD SMITHFIELD NC 27577 JOHNSTON (919) 934-8171 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.5131610 -78.3336590 0   101 37 37101 39580 Raleigh-Durham-Chapel Hill, NC Central Johnston County https://data.medicare.gov/resource/xubh-q36u/row-m8in-cgbk_vjwx 340090 659711 2019-11-25 2019-06-30 155 24         179 20         18   217
3922 3922 PENDER MEMORIAL HOSPITAL 507 E FREMONT ST BURGAW NC 28425 PENDER (910) 300-4004 Critical Access Hospitals Government - Local TRUE 34.5512630 -77.9204230 0   141 37 37141 48900   Outlying Pender County https://data.medicare.gov/resource/xubh-q36u/row-7fvf-phgu_s8i7 341307 659598 2019-11-25 2018-09-30 25           25       43       68
2488 2488 NEWBERRY COUNTY MEMORIAL HOSPITAL 2669 KINARD ST PO BOX 497 NEWBERRY SC 29108 NEWBERRY (803) 405-7145 Acute Care Hospitals Voluntary non-profit - Other TRUE 34.2894330 -81.6049150 0   71 45 45071 35140 Columbia-Orangeburg-Newberry, SC Central Newberry County https://data.medicare.gov/resource/xubh-q36u/row-9ehy.xh96.39uz 420053 659725 2019-11-25 2019-06-30 41 7         48               48
2375 2375 MUSC HEALTH MARION MEDICAL CENTER 2829 E HWY 76 MULLINS SC 29574 MARION (843) 431-2000 Acute Care Hospitals Government - State TRUE 34.1892320 -79.3219450 0   67 45 45067         https://data.medicare.gov/resource/xubh-q36u/row-nueg_7h5n~iagx 420055 660703 2019-11-25 2019-06-30 84 10         94               94
3525 3525 REDMOND REGIONAL MEDICAL CENTER 501 REDMOND ROAD ROME GA 30165 FLOYD (706) 802-3012 Acute Care Hospitals Proprietary TRUE 34.2781910 -85.1941310 0   115 13 13115 40660 Rome-Summerville, GA Central Floyd County https://data.medicare.gov/resource/xubh-q36u/row-z5aw~bjka~vbtd 110168 659773 2019-11-25 2019-06-30 168 16 24       208   20           228
2600 2600 PIEDMONT NEWNAN HOSPITAL, INC 745 POPLAR ROAD NEWNAN GA 30265 COWETA (770) 400-2300 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.3593630 -84.7540620 0   77 13 13077 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Coweta County https://data.medicare.gov/resource/xubh-q36u/row-nhqn.yikd_3ahg 110229 659491 2019-11-25 2019-06-30 122 18       10 150               150
4029 4029 PIEDMONT HENRY HOSPITAL 1133 EAGLE'S LANDING PARKWAY STOCKBRIDGE GA 30281 HENRY (678) 604-1000 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.5089960 -84.2255610 0   151 13 13151 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Henry County https://data.medicare.gov/resource/xubh-q36u/row-vhdk-mf48~gr2g 110191 659490 2019-11-25 2019-06-30 196   40     16 252       89       341
3631 3631 PIEDMONT HOSPITAL 1968 PEACHTREE RD NW ATLANTA GA 30309 FULTON (404) 605-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.8088020 -84.3933690 0   121 13 13121 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Fulton County https://data.medicare.gov/resource/xubh-q36u/row-53ay_f9xi~a54p 110083 659489 2019-11-25 2019-06-30 407 56 20     29 512               512
2850 2850 FISHERMEN'S COMMUNITY HOSPITAL 3301 OVERSEAS HWY MARATHON FL 33050 MONROE (305) 743-5533 Critical Access Hospitals Voluntary non-profit - Private TRUE 24.7111300 -81.0947200 0   87 12 12087 28580   Central Monroe County https://data.medicare.gov/resource/xubh-q36u/row-3mjy.7a5u.ezdd 101312 659771 2019-11-25 2019-06-30 4 1         5               5
2392 2392 SOUTH LAKE HOSPITAL 1900 DON WICKHAM DR CLERMONT FL 34711 LAKE (352) 394-4071 Acute Care Hospitals Government - Hospital District or Authority FALSE 28.5511780 -81.7234150 0   69 12 12069 36740 Orlando-Deltona-Daytona Beach, FL Outlying Lake County https://data.medicare.gov/resource/xubh-q36u/row-z7xz~yu83_5nfj 100051 661477 2019-11-25 2018-09-30 124 16         140       30       170
2504 2504 GRANDVIEW MEDICAL CENTER 3690 GRANDVIEW PARKWAY BIRMINGHAM AL 35243 JEFFERSON (205) 971-1000 Acute Care Hospitals Proprietary TRUE 33.4343630 -86.7204830 0   73 1 1073 13820 Birmingham-Hoover-Talladega, AL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-pwut_di96_m4tu 10104 660349 2019-11-25 2019-06-30 289 72         373 12 17           402
3076 3076 PROVIDENCE HOSPITAL 6801 AIRPORT BOULEVARD MOBILE AL 36608 MOBILE (251) 633-1000 Acute Care Hospitals Voluntary non-profit - Church TRUE 30.6816900 -88.1983290 0   97 1 1097 33660 Mobile-Daphne-Fairhope, AL Central Mobile County https://data.medicare.gov/resource/xubh-q36u/row-e52k.abk5_gk2c 10090 659399 2019-11-25 2019-06-30 296 33 20       349               349
2727 2727 SAINT THOMAS HICKMAN HOSPITAL 135 EAST SWAN STREET CENTERVILLE TN 37033 HICKMAN (931) 729-4271 Critical Access Hospitals Voluntary non-profit - Private FALSE 35.7795390 -87.4602420 0   81 47 47081 34980 Nashville-Davidson--Murfreesboro, TN Outlying Hickman County https://data.medicare.gov/resource/xubh-q36u/row-3u9v~yfau~8vwh 441300 659460 2019-11-25 2019-06-30 25           25         40     65
4278 4278 SAINT THOMAS RIVER PARK HOSPITAL 1559 SPARTA STREET MC MINNVILLE TN 37110 WARREN (931) 815-4101 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.6986940 -85.7423390 0   177 47 47177 32660   Central Warren County https://data.medicare.gov/resource/xubh-q36u/row-qm5q~p4wm-m3k7 440151 659458 2019-11-25 2019-06-30 92 8         100 10 15           125
4027 4027 SAINT THOMAS RUTHERFORD HOSPITAL 1700 MEDICAL CENTER PARKWAY MURFREESBORO TN 37129 RUTHERFORD (615) 396-4100 Acute Care Hospitals Voluntary non-profit - Church TRUE 35.8586400 -86.4242410 0   149 47 47149 34980 Nashville-Davidson--Murfreesboro, TN Outlying Rutherford County https://data.medicare.gov/resource/xubh-q36u/row-nv4b-ikm9-tmer 440053 659454 2019-11-25 2019-06-30 202 68       17 287               287
1670 1670 SAINT THOMAS DEKALB HOSPITAL 520 W MAIN ST SMITHVILLE TN 37166 DE KALB (615) 215-5000 Acute Care Hospitals Voluntary non-profit - Church TRUE 35.9594030 -85.8298410 0   41 47 47041         https://data.medicare.gov/resource/xubh-q36u/row-vj84-zvtf.4wg9 440148 659457 2019-11-25 2019-06-30 48 4         52               52
4008 4008 NORTHCREST MEDICAL CENTER 100 NORTHCREST DRIVE SPRINGFIELD TN 37172 ROBERTSON (615) 384-2411 Acute Care Hospitals Voluntary non-profit - Other TRUE 36.4795180 -86.8888980 0   147 47 47147 34980 Nashville-Davidson--Murfreesboro, TN Outlying Robertson County https://data.medicare.gov/resource/xubh-q36u/row-xhnc.dc7v_7vxz 440065 660043 2019-11-25 2019-06-30 101 8         109               109
714 714 SAINT THOMAS STONES RIVER HOSPITAL 324 DOOLITTLE ROAD WOODBURY TN 37190 CANNON (615) 563-4001 Acute Care Hospitals Proprietary TRUE 35.8328650 -86.0729430 0   15 47 47015 34980 Nashville-Davidson--Murfreesboro, TN Outlying Cannon County https://data.medicare.gov/resource/xubh-q36u/row-cff9_8h9t.y7xa 440200 659459 2019-11-25 2019-06-30 30           30 22             52
1572 1572 SAINT THOMAS MIDTOWN HOSPITAL 2000 CHURCH ST NASHVILLE TN 37236 DAVIDSON (615) 284-5555 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.1534000 -86.8008350 0   37 47 47037 34980 Nashville-Davidson--Murfreesboro, TN Central Davidson County https://data.medicare.gov/resource/xubh-q36u/row-bacj-bxth_hwij 440133 659456 2019-11-25 2019-06-30 317 37       41 395   24           419
393 393 ERLANGER BLEDSOE HOSPITAL 71 WHEELERTOWN AVENUE PIKEVILLE TN 37367 BLEDSOE (423) 447-2112 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.6218300 -85.1883040 0   7 47 47007         https://data.medicare.gov/resource/xubh-q36u/row-86fw~zcvu.6xu7 441306 659536 2019-11-25 2019-06-30 25           25               25
466 466 BLOUNT MEMORIAL HOSPITAL 907 E LAMAR ALEXANDER PARKWAY MARYVILLE TN 37804 BLOUNT (865) 983-7211 Acute Care Hospitals Government - Local TRUE 35.7549750 -83.9586020 0   9 47 47009 28940 Knoxville-Morristown-Sevierville, TN Central Blount County https://data.medicare.gov/resource/xubh-q36u/row-q2u9.xgek.22ux 440011 659450 2019-11-25 2019-06-30 177 8 8       193 10     76       279
4330 4330 SAINT THOMAS HIGHLANDS HOSPITAL 401 SEWELL DR SPARTA TN 38583 WHITE (931) 738-9211 Acute Care Hospitals Proprietary TRUE 35.9481200 -85.4770740 0   185 47 47185         https://data.medicare.gov/resource/xubh-q36u/row-kw75.zwj7_gsiz 440192 660314 2019-11-25 2019-06-30 28 4         32 14             46
2355 2355 BAPTIST HEALTH LEXINGTON 1740 NICHOLASVILLE ROAD LEXINGTON KY 40503 FAYETTE (859) 260-6104 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.0188420 -84.5139480 0   67 21 21067 30460 Lexington-Fayette--Richmond--Frankfort, KY Central Fayette County https://data.medicare.gov/resource/xubh-q36u/row-w47h-k353~ymyx 180103 660563 2019-11-25 2018-08-31 339 52         391               391
1866 1866 OHIO STATE UNIVERSITY HOSPITALS 410 WEST 10TH AVENUE COLUMBUS OH 43210 FRANKLIN (614) 293-9700 Acute Care Hospitals Government - State TRUE 39.9948840 -83.0176860 0   49 39 39049 18140 Columbus-Marion-Zanesville, OH Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-fagn.mmer_2f8n 360085 660671 2019-11-25 2019-06-30 885 97         982 91 60           1133
4064 4064 AKRON GENERAL MEDICAL CENTER 1 AKRON GENERAL AVENUE AKRON OH 44307 SUMMIT (330) 344-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.0778590 -81.5327870 0   153 39 39153 10420 Cleveland-Akron-Canton, OH Central Summit County https://data.medicare.gov/resource/xubh-q36u/row-fwyk~yqdc~my3b 360027 660664 2019-11-25 2018-12-31 315 34 34       383 53             436
3102 3102 ORTHOINDY HOSPITAL 8400 NORTHWEST BLVD INDIANAPOLIS IN 46278 MARION (317) 956-1000 Acute Care Hospitals Physician FALSE 39.9067020 -86.2662580 0   97 18 18097 26900 Indianapolis-Carmel-Muncie, IN Central Marion County https://data.medicare.gov/resource/xubh-q36u/row-sa8x~jqdx_zkr2 150160 660543 2019-11-25 2018-12-31 38           38               38
2943 2943 FRANCISCAN HEALTH MICHIGAN CITY 3500 FRANCISCAN WAY MICHIGAN CITY IN 46360 LA PORTE (219) 879-8511 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.6595891 -86.8986778 1 ROOFTOP 91 18 18091 33140 Chicago-Naperville, IL-IN-WI Central LaPorte County https://data.medicare.gov/resource/xubh-q36u/row-3sxf-2kxc.xexc 150015 660075 2019-11-25 2018-12-31 135 14         149 18 16           183
4036 4036 DECKERVILLE COMMUNITY HOSPITAL 3559 PINE ST DECKERVILLE MI 48427 SANILAC (810) 376-2835 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.5281610 -82.7337730 0   151 26 26151         https://data.medicare.gov/resource/xubh-q36u/row-kq5w_x6ix-cx98 231311 660599 2019-11-25 2019-06-30 15           15               15
2073 2073 MIDMICHIGAN MEDICAL CENTER-GRATIOT 300 E WARWICK DR ALMA MI 48801 GRATIOT (989) 463-1101 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.3916800 -84.6622780 0   57 26 26057 10940 Mount Pleasant-Alma, MI Central Gratiot County https://data.medicare.gov/resource/xubh-q36u/row-7bpx_say8-8gij 230030 660577 2019-11-25 2019-06-30 49           49 30 18           97
688 688 SPECTRUM HEALTH PENNOCK 1009 W GREEN ST HASTINGS MI 49058 BARRY (269) 945-3451 Critical Access Hospitals Voluntary non-profit - Other TRUE 42.6442000 -85.3021000 0   15 26 26015 24340 Grand Rapids-Wyoming-Muskegon, MI Outlying Barry County https://data.medicare.gov/resource/xubh-q36u/row-7m4u.pz7d~8678 231339 660108 2019-11-25 2019-06-30 19 6         25               25
3346 3346 SPECTRUM HEALTH BIG RAPIDS HOSPITAL 605 OAK STREET BIG RAPIDS MI 49307 MECOSTA (231) 796-8691 Acute Care Hospitals Government - Local TRUE 43.6931260 -85.4757630 0   107 26 26107 13660 Grand Rapids-Wyoming-Muskegon, MI Central Mecosta County https://data.medicare.gov/resource/xubh-q36u/row-6wsn~km5g_qqzq 230093 660588 2019-11-25 2019-06-30 45 4         49               49
3315 3315 SPECTRUM HEALTH LUDINGTON HOSPITAL ONE N ATKINSON DRIVE LUDINGTON MI 49431 MASON (231) 843-2591 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.9582193 -86.4302207 1 ROOFTOP 105 26 26105 31220   Central Mason County https://data.medicare.gov/resource/xubh-q36u/row-4jbc-wihk_b6pr 230110 660590 2019-11-25 2019-06-30 39 6         45               45
3830 3830 SPECTRUM HEALTH REED CITY HOSPITAL 300 N PATTERSON, PO BOX 75 REED CITY MI 49677 OSCEOLA (231) 832-3271 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.8782450 -85.5211907 1 ROOFTOP 133 26 26133         https://data.medicare.gov/resource/xubh-q36u/row-hhgy~8j82.d9qv 231323 660106 2019-11-25 2019-06-30 21 4         25       50       75
359 359 MIDMICHIGAN MEDICAL CENTER - ALPENA 1501 W CHISHOLM ST ALPENA MI 49707 ALPENA (989) 356-7390 Acute Care Hospitals Proprietary TRUE 45.0768570 -83.4506720 0   7 26 26007 10980   Central Alpena County https://data.medicare.gov/resource/xubh-q36u/row-3cst~3hfe~ssf7 230036 660579 2019-11-25 2019-06-30 119 9         128   11           139
430 430 AUDUBON COUNTY MEMORIAL HOSPITAL 515 PACIFIC AVENUE AUDUBON IA 50025 AUDUBON (712) 563-2611 Critical Access Hospitals Government - Local TRUE 41.7154230 -94.9370440 0   9 19 19009         https://data.medicare.gov/resource/xubh-q36u/row-7tp4_zwyw_2d9j 161330 659788 2019-11-25 2019-06-30 25           25               25
4031 4031 POCAHONTAS COMMUNITY HOSPITAL 606 N W 7TH STREET POCAHONTAS IA 50574 POCAHONTAS (712) 335-3501 Critical Access Hospitals Government - Local TRUE 42.7408220 -94.6787780 0   151 19 19151         https://data.medicare.gov/resource/xubh-q36u/row-mhbi~vwku-j27n 161305 659787 2019-11-25 2019-06-30 25           25               25
4203 4203 ORANGE CITY AREA HEALTH SYSTEM 1000 LINCOLN CIRCLE SE ORANGE CITY IA 51041 SIOUX (712) 737-4984 Critical Access Hospitals Voluntary non-profit - Other TRUE 42.9948780 -96.0457340 0   167 19 19167         https://data.medicare.gov/resource/xubh-q36u/row-j9vg.b9hy-cjqt 161360 659790 2019-11-25 2019-06-30 25           25               25
4202 4202 SIOUX CENTER HEALTH 1101 9TH STREET SE SIOUX CENTER IA 51250 SIOUX (712) 722-1271 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.0696850 -96.1592870 0   167 19 19167         https://data.medicare.gov/resource/xubh-q36u/row-69h8.g24x.naq3 161346 659789 2019-11-25 2019-06-30 19           19       69   1   89
1643 1643 SPENCER MUNICIPAL HOSPITAL 1200 1ST AVENUE EAST SPENCER IA 51301 CLAY (712) 264-8300 Acute Care Hospitals Government - Local TRUE 43.1500090 -95.1438420 0   41 19 19041 43980   Central Clay County https://data.medicare.gov/resource/xubh-q36u/row-nipj.ewp3-j7u2 160112 660216 2019-11-25 2019-06-30 49           49 15             64
2002 2002 REGIONAL MEDICAL CENTER 709 W MAIN STREET MANCHESTER IA 52057 DELAWARE (563) 927-3232 Critical Access Hospitals Proprietary TRUE 42.4839030 -91.4666440 0   55 19 19055         https://data.medicare.gov/resource/xubh-q36u/row-znx9.yjf2.jpru 161343 660219 2019-11-25 2019-06-30 25           25           1   26
3263 3263 UNIVERSITY OF IOWA HOSPITAL & CLINICS 200 HAWKINS DRIVE IOWA CITY IA 52242 JOHNSON (319) 356-1616 Acute Care Hospitals Government - State TRUE 41.6612030 -91.5507590 0   103 19 19103 26980 Cedar Rapids-Iowa City, IA Central Johnson County https://data.medicare.gov/resource/xubh-q36u/row-cxgc_xna4~4mhi 160058 660215 2019-11-25 2019-06-30 497   24 17 36 88 716 73             789
471 471 ST MARYS HOSPITAL MEDICAL CTR 1726 SHAWANO AVE GREEN BAY WI 54303 BROWN (920) 498-4200 Acute Care Hospitals Voluntary non-profit - Other TRUE 44.5321840 -88.0665610 0   9 55 55009 24580 Green Bay-Shawano, WI Central Brown County https://data.medicare.gov/resource/xubh-q36u/row-kt4k-sbbe~w8n6 520097 660733 2019-11-25 2019-06-30 75 8         83               83
1307 1307 ESSENTIA HEALTH ST MARY'S HOSPITAL - SUPERIOR 3500 TOWER AVE SUPERIOR WI 54880 DOUGLAS (715) 817-7000 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.6981950 -92.1040480 0   31 55 55031 20260   Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-e5mc~9gdv_htnc 521329 660735 2019-11-25 2019-06-30 25           25               25
3561 3561 PIPESTONE COUNTY MEDICAL CENTER 916 4TH AVENUE SOUTHWEST PIPESTONE MN 56164 PIPESTONE (507) 825-5811 Critical Access Hospitals Government - Local TRUE 43.9910820 -96.3221070 0   117 27 27117         https://data.medicare.gov/resource/xubh-q36u/row-pzdb_wxvr-4ugg 241374 659508 2019-11-25 2019-06-30 18           18               18
3981 3981 ST CLOUD HOSPITAL 1406 6TH AVE NORTH SAINT CLOUD MN 56303 STEARNS (320) 255-5661 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.5753250 -94.1704500 0   145 27 27145 41060 Minneapolis-St. Paul, MN-WI Central Stearns County https://data.medicare.gov/resource/xubh-q36u/row-i2df-wytp-8ht6 240036 659976 2019-11-25 2019-06-30 385 42       30 457   20           477
1395 1395 ESSENTIA HEALTH ST JOSEPH'S MEDICAL CENTER 523 NORTH 3RD STREET BRAINERD MN 56401 CROW WING (218) 829-2861 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.3625090 -94.2051430 0   35 27 27035 14660   Central Crow Wing County https://data.medicare.gov/resource/xubh-q36u/row-qjsu~wksq.gb8w 240075 659977 2019-11-25 2019-06-30 117 10         127               127
2666 2666 MADISON REGIONAL HEALTH SYSTEM 323 SW 10TH ST MADISON SD 57042 LAKE (605) 256-6551 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.9930210 -97.1197520 0   79 46 46079         https://data.medicare.gov/resource/xubh-q36u/row-j5pm.hb44_44j6 431300 659611 2019-11-25 2019-06-30 22           22               22
464 464 ST MICHAEL'S HOSPITAL - CAH 410 W 16TH AVE TYNDALL SD 57066 BON HOMME (605) 589-2100 Critical Access Hospitals Government - Local TRUE 42.9912530 -97.8678960 0   9 46 46009         https://data.medicare.gov/resource/xubh-q36u/row-sqz9_y3kz.mu4d 431327 659612 2019-11-25 2019-06-30 25           25               25
2377 2377 AVERA ST BENEDICT HEALTH CENTER - CAH 401 WEST GLYNN DRIVE PARKSTON SD 57366 HUTCHINSON (605) 928-3311 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.3989450 -97.9900610 0   67 46 46067         https://data.medicare.gov/resource/xubh-q36u/row-w4r3_dmvi-zsg5 431330 660035 2019-11-25 2019-06-30 25           25         49     74
1602 1602 COOPERSTOWN MEDICAL CENTER 1200 ROBERTS AVE NE COOPERSTOWN ND 58425 GRIGGS (701) 797-2221 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.4456240 -98.1185500 0   39 38 38039         https://data.medicare.gov/resource/xubh-q36u/row-qi2g~gwic_kc3w 351306 660659 2019-11-25 2019-06-30 18           18               18
2081 2081 SAKAKAWEA MEDICAL CENTER - CAH 510 8TH AVENUE NE HAZEN ND 58545 MERCER (701) 748-2225 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.2982860 -101.6115600 0   57 38 38057         https://data.medicare.gov/resource/xubh-q36u/row-772i_c662.4xam 351310 660272 2019-11-25 2019-06-30 13           13               13
3218 3218 TRINITY HOSPITALS 407 3RD ST SE MINOT ND 58701 WARD (701) 857-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 48.2324790 -101.2884520 0   101 38 38101 33500   Central Ward County https://data.medicare.gov/resource/xubh-q36u/row-7zuw.yviv_94dm 350006 661068 2019-11-25 2019-06-30 117 19         152 26 20   230   2   430
3217 3217 KENMARE COMMUNITY HOSPITAL PO BOX 697 KENMARE ND 58746 WARD (701) 385-4296 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.6742881 -102.0844703 1 ROOFTOP 101 38 38101 33500   Central Ward County https://data.medicare.gov/resource/xubh-q36u/row-tfzi_r3ee-4azt 351305 660271 2019-11-25 2019-06-30 25           25               25
2797 2797 TRINITY HOSPITAL 315 KNAPP ST WOLF POINT MT 59201 ROOSEVELT (406) 653-6500 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.1008930 -105.6411380 0   85 30 30085         https://data.medicare.gov/resource/xubh-q36u/row-8zsu~ksjh-u24d 271341 659988 2019-11-25 2019-06-30 22           22       60       82
2796 2796 POPLAR COMMUNITY HOSPITAL 211 H ST E POPLAR MT 59255 ROOSEVELT (406) 768-6100 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.1149570 -105.1921240 0   85 30 30085         https://data.medicare.gov/resource/xubh-q36u/row-ivpb.zvpr-3zj8 271300 660638 2019-11-25 2019-06-30 20           20               20
2890 2890 RUSH COPLEY MEDICAL CENTER 2000 OGDEN AVENUE AURORA IL 60504 KANE (630) 978-6200 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.7277220 -88.2684150 0   89 17 17089 16980 Chicago-Naperville, IL-IN-WI Central Kane County https://data.medicare.gov/resource/xubh-q36u/row-39d4~37w6~ivsi 140029 659945 2019-11-25 2019-06-30 157 22         192   18           210
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
3852 3852 HILLSBORO AREA HOSPITAL 1200 E TREMONT STREET HILLSBORO IL 62049 MONTGOMERY (217) 532-6111 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.1536720 -89.4815080 0   135 17 17135         https://data.medicare.gov/resource/xubh-q36u/row-hr8s~ac96_26fy 141332 659949 2019-11-25 2019-06-30 25           25               25
1277 1277 SAINT FRANCIS MEDICAL CENTER 211 ST FRANCIS DR CAPE GIRARDEAU MO 63703 CAPE GIRARDEAU (573) 331-3000 Acute Care Hospitals Voluntary non-profit - Church TRUE 37.3034070 -89.5712971 1 ROOFTOP 31 29 29031 16020 Cape Girardeau-Sikeston, MO-IL Central Cape Girardeau County https://data.medicare.gov/resource/xubh-q36u/row-2cqn~hh59_aitm 260183 660119 2019-11-25 2019-06-30 216 31         283   24           307
1789 1789 LIBERTY HOSPITAL 2525 GLENN HENDREN DR LIBERTY MO 64069 CLAY (816) 781-7200 Acute Care Hospitals Government - Hospital District or Authority TRUE 39.2767570 -94.4243430 0   47 29 29047 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Clay County https://data.medicare.gov/resource/xubh-q36u/row-e8b7~a55p.dgyp 260177 660118 2019-11-25 2019-06-30 179 20         199               199
4057 4057 RAWLINS COUNTY HEALTH CENTER 707 GRANT ST ATWOOD KS 67730 RAWLINS (785) 626-3211 Critical Access Hospitals Voluntary non-profit - Other TRUE 39.8132640 -101.0385000 0   153 20 20153         https://data.medicare.gov/resource/xubh-q36u/row-aajh-f5t2_nat3 171307 659791 2019-11-25 2019-06-30 15           15               15
4042 4042 WARREN MEMORIAL HOSPITAL 905 SECOND ST FRIEND NE 68359 SALINE (402) 947-2541 Critical Access Hospitals Government - Local TRUE 40.6536930 -97.2820520 0   151 31 31151         https://data.medicare.gov/resource/xubh-q36u/row-d3pt.4wwp-4k26 281330 660257 2019-11-25 2019-09-30 19           19               19
3214 3214 AVERA CREIGHTON HOSPITAL P O BOX 186, 1503 MAIN ST CREIGHTON NE 68729 KNOX (402) 358-5700 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.4664016 -97.9072475 1 ROOFTOP 107 31 31107         https://data.medicare.gov/resource/xubh-q36u/row-7tv3_vise~cn54 281331 660258 2019-11-25 2019-06-30 23           23       47       70
2763 2763 MERCY HOSPITAL LOGAN COUNTY, INC 200 S ACADEMY RD GUTHRIE OK 73044 LOGAN (405) 282-6700 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.8775430 -97.4604910 0   83 40 40083 36420 Oklahoma City-Shawnee, OK Central Logan County https://data.medicare.gov/resource/xubh-q36u/row-gqau_gh2v.54h6 371317 659600 2019-11-25 2019-06-30 25           25               25
3392 3392 MERCY HOSPITAL OKLAHOMA CITY, INC 4300 WEST MEMORIAL ROAD OKLAHOMA CITY OK 73120 OKLAHOMA (405) 752-3754 Acute Care Hospitals Voluntary non-profit - Church TRUE 35.6090260 -97.5996250 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-bxb9~8ruy_a7b8 370013 659855 2019-11-25 2019-06-30 244 36       28 308               308
852 852 MERCY HOSPITAL ARDMORE, INC 1011 FOURTEENTH AVENUE, NORTHWEST ARDMORE OK 73401 CARTER (580) 223-5400 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.1884510 -97.1400180 0   19 40 40019 11620   Central Carter County https://data.medicare.gov/resource/xubh-q36u/row-vred.e6gv~ukx2 370047 659857 2019-11-25 2019-06-30 127 13         140 20 20           180
853 853 MERCY HOSPITAL HEALDTON, INC. 3462 HOSPITAL RD HEALDTON OK 73438 CARTER (580) 229-0701 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.2229910 -97.4921780 0   19 40 40019 11620   Central Carter County https://data.medicare.gov/resource/xubh-q36u/row-i6td_hvi7_qxjw 371310 659717 2019-11-25 2019-06-30 22           22               22
2411 2411 MERCY HOSPITAL TISHOMINGO 1000 SOUTH BYRD TISHOMINGO OK 73460 JOHNSTON (580) 371-2327 Critical Access Hospitals Voluntary non-profit - Church TRUE 34.2224450 -96.6752940 0   69 40 40069         https://data.medicare.gov/resource/xubh-q36u/row-d4ji~yfmc.9fmx 371304 659716 2019-11-25 2019-06-30 25           25               25
2582 2582 ELKVIEW GENERAL HOSPITAL 429 WEST ELM STREET HOBART OK 73651 KIOWA (580) 726-3324 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.0368290 -99.0983400 0   75 40 40075         https://data.medicare.gov/resource/xubh-q36u/row-gdd4_6kz4-h5ey 370153 659714 2019-11-25 2019-06-30 38           38               38
32 32 SHARE MEDICAL CENTER 800 SHARE DRIVE ALVA OK 73717 WOODS (580) 327-2800 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.7869690 -98.6700230 0   151 40 40151         https://data.medicare.gov/resource/xubh-q36u/row-gzmq-89k6~9n3d 371341 659863 2019-11-25 2019-06-30 25           25         80     105
2544 2544 MERCY HOSPITAL KINGFISHER, INC 1000 KINGFISHER HOSPITAL DRIVE KINGFISHER OK 73750 KINGFISHER (405) 375-3141 Critical Access Hospitals Voluntary non-profit - Church TRUE 35.8100746 -97.9449387 1 ROOFTOP 73 40 40073         https://data.medicare.gov/resource/xubh-q36u/row-h8q6~j6ue-y5ca 371313 660141 2019-11-25 2019-06-30 25           25               25
527 527 MERCY HOSPITAL WATONGA, INC 500 NORTH CLARENCE NASH BOULEVARD WATONGA OK 73772 BLAINE (580) 623-7211 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.8494550 -98.4192480 0   11 40 40011         https://data.medicare.gov/resource/xubh-q36u/row-sccp_42z7.7ame 371302 659715 2019-11-25 2019-06-30 25           25               25
3692 3692 MERCY HOSPITAL ADA 430 NORTH MONTE VISTA ADA OK 74820 PONTOTOC (580) 332-2323 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.7780680 -96.6348130 0   123 40 40123 10220   Central Pontotoc County https://data.medicare.gov/resource/xubh-q36u/row-itqt-xmxc.8n32 370020 659524 2019-11-25 2019-06-30 96 12         108 20 20           148
4678 4678 TYLER COUNTY HOSPITAL 1100 WEST BLUFF WOODVILLE TX 75979 TYLER (409) 283-8141 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.7752870 -94.4282200 0   457 48 48457         https://data.medicare.gov/resource/xubh-q36u/row-xfu9.wq3c~xr3i 450460 660053 2019-11-25 2019-06-30 25           25               25
4568 4568 PROVIDENCE HEALTH CENTER 6901 MEDICAL PARKWAY WACO TX 76712 MC LENNAN (254) 751-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 31.5132430 -97.1984310 0   309 48 48309 47380   Central McLennan County https://data.medicare.gov/resource/xubh-q36u/row-vgx2-viz4_yy8e 450042 659893 2019-11-25 2019-06-30 195 30         225 46             271
4419 4419 MEMORIAL HERMANN HOSPITAL SYSTEM 1635 NORTH LOOP WEST HOUSTON TX 77008 HARRIS (713) 448-6796 Acute Care Hospitals Voluntary non-profit - Private TRUE 29.8122660 -95.4308990 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-2kjx_z9h3~iiu7 450184 659537 2019-11-25 2019-06-30 1068 157       85 1310   78           1388
4436 4436 MEMORIAL HERMANN TEXAS MEDICAL CENTER 6411 FANNIN HOUSTON TX 77030 HARRIS (713) 704-3700 Acute Care Hospitals Voluntary non-profit - Private TRUE 29.7136840 -95.3976270 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-dk5e-jq9i-qp7s 450068 659613 2019-11-25 2019-06-30 658 38 18     118 994   12   8       1014
4417 4417 HCA HOUSTON HEALTHCARE TOMBALL 605 HOLDERRIETH TOMBALL TX 77375 HARRIS (281) 351-1623 Acute Care Hospitals Proprietary TRUE 30.0887030 -95.6239850 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-qwg3~p4ci.ubu8 450670 659543 2019-11-25 2019-06-30 167 20       7 194 21 26           241
1976 1976 SETON HIGHLAND LAKES HIGHWAY 281 SOUTH BURNET TX 78611 BURNET (512) 715-3000 Critical Access Hospitals Voluntary non-profit - Private TRUE 30.7113209 -98.2467221 1 GEOMETRIC_CENTER 53 48 48053         https://data.medicare.gov/resource/xubh-q36u/row-khw5~6jgp-v7pk 451365 659615 2019-11-25 2019-06-30 21 4         25               25
4279 4279 MEMORIAL HOSPITAL 1110 NORTH SARAH DEWITT DRIVE GONZALES TX 78629 GONZALES (830) 672-7581 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.5158950 -97.4288680 0   177 48 48177         https://data.medicare.gov/resource/xubh-q36u/row-7g7y.b4hd-s8g5 450235 659735 2019-11-25 2019-06-30 34           34               34
2040 2040 ASCENSION SETON EDGAR B DAVIS 130 HAYS STREET LULING TX 78648 CALDWELL (830) 875-7000 Critical Access Hospitals Voluntary non-profit - Private TRUE 29.6725300 -97.6542540 0   55 48 48055 12420   Outlying Caldwell County https://data.medicare.gov/resource/xubh-q36u/row-wn52-vdac_k6nj 451371 660154 2019-11-25 2019-06-30 23           23               23
4702 4702 SETON MEDICAL CENTER WILLIAMSON 201 SETON PARKWAY ROUND ROCK TX 78664 WILLIAMSON (512) 324-0000 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.5679440 -97.6527840 0   491 48 48491 12420   Central Williamson County https://data.medicare.gov/resource/xubh-q36u/row-rfq6_5szx.kb6y 670041 659749 2019-11-25 2019-06-30 93 26         119               119
4667 4667 DELL SETON MED CENTER AT THE UNIVERSITY OF TX 601 E 15TH STREET AUSTIN TX 78701 TRAVIS (512) 324-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.2750550 -97.7329770 0   453 48 48453 12420   Central Travis County https://data.medicare.gov/resource/xubh-q36u/row-8gyh.j6jb.jjky 450124 660050 2019-11-25 2019-06-30 166 60         226               226
4674 4674 ASCENSION SETON MEDICAL CENTER AUSTIN 1201 W 38TH ST AUSTIN TX 78705 TRAVIS (512) 324-1000 Acute Care Hospitals Physician TRUE 30.3061540 -97.7452180 0   453 48 48453 12420   Central Travis County https://data.medicare.gov/resource/xubh-q36u/row-qf7b-dsjj.a9dv 450056 659731 2019-11-25 2019-06-30 304 83       43 430               430

Next page

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