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

3,280 rows where hospital_type = "Acute Care Hospitals" sorted by lng

✎ 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, burn_beds, subprovider_oth_beds, nursing_fac_beds, filed_date (date), fy_end_date (date)

hospital_type ✖

  • Acute Care Hospitals · 3,280 ✖
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
2068 2068 WESTERN PLAINS MEDICAL COMPLEX 3001 AVENUE A DODGE CITY KS 67801 FORD (620) 225-8400 Acute Care Hospitals Proprietary TRUE 37.7854870 -100.0149750 0   57 20 20057 19980   Central Ford County https://data.medicare.gov/resource/xubh-q36u/row-w4ff.nykp.gqd4 170175 652748 2019-08-01 2019-02-28 50 10         60               60
4524 4524 HAMLIN MEMORIAL HOSPITAL 632 N W SECOND STREET HAMLIN TX 79520 JONES (325) 576-3646 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.8851680 -100.1346350 0   253 48 48253 10180   Outlying Jones County https://data.medicare.gov/resource/xubh-q36u/row-t33d_rkk5~cpm5 450243 657517 2019-03-15 2018-08-31 25           25               25
2584 2584 CHILDRESS REGIONAL MEDICAL CENTER HWY 83 NORTH CHILDRESS TX 79201 CHILDRESS (940) 937-6371 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.4304911 -100.2265235 1 GEOMETRIC_CENTER 75 48 48075         https://data.medicare.gov/resource/xubh-q36u/row-vkgv.sxvw_zc6g 450369 646306 2019-03-08 2018-09-30 39           39               39
2324 2324 AVERA ST MARY'S HOSPITAL 801 E SIOUX PIERRE SD 57501 HUGHES (605) 224-3100 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.3612680 -100.3422350 0   65 46 46065 38180   Central Hughes County https://data.medicare.gov/resource/xubh-q36u/row-y7ep-uymv.yumv 430015 660031 2019-11-26 2019-06-30 44 6         50       80       130
4464 4464 HEMPHILL COUNTY HOSPITAL 1020 S 4TH ST CANADIAN TX 79014 HEMPHILL (806) 323-6622 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.9037920 -100.3873990 0   211 48 48211         https://data.medicare.gov/resource/xubh-q36u/row-86yy_5s2m-up8r 450578 646584 2019-04-17 2018-09-30 15           15           2   17
4594 4594 ROLLING PLAINS MEMORIAL HOSPITAL 200 E ARIZONA SWEETWATER TX 79556 NOLAN (325) 235-1701 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.4538820 -100.3983140 0   353 48 48353 45020   Central Nolan County https://data.medicare.gov/resource/xubh-q36u/row-jbwn_aebk~78ee 450055 646765 2019-04-16 2018-09-30 34 5         39               39
4664 4664 SHANNON MEDICAL CENTER 120 EAST HARRIS AVENUE SAN ANGELO TX 76903 TOM GREEN (325) 653-6741 Acute Care Hospitals Voluntary non-profit - Private TRUE 31.4644850 -100.4350900 0   451 48 48451 41660   Central Tom Green County https://data.medicare.gov/resource/xubh-q36u/row-mf6f.gvju.vuav 450571 644369 2019-02-28 2018-09-30 292 17         313 14 14   28       369
4576 4576 FORT DUNCAN MEDICAL CENTER 3333 N FOSTER MALDONADO BLVD EAGLE PASS TX 78852 MAVERICK (830) 773-5321 Acute Care Hospitals Proprietary TRUE 28.7114180 -100.4541050 0   323 48 48323 20580   Central Maverick County https://data.medicare.gov/resource/xubh-q36u/row-zqqu-eqhh-2cw6 450092 648764 2019-05-28 2018-12-31 76 10         86   15           101
4665 4665 SAN ANGELO COMMUNITY MEDICAL CENTER 3501 KNICKERBOCKER ROAD SAN ANGELO TX 76904 TOM GREEN (325) 949-9511 Acute Care Hospitals Proprietary TRUE 31.4200760 -100.4701320 0   451 48 48451 41660   Central Tom Green County https://data.medicare.gov/resource/xubh-q36u/row-m9tt.p6fs.emne 450340 657988 2019-02-01 2018-08-31 113 12         131               131
2802 2802 STANDING ROCK INDIAN HEALTH SERVICE HOSPITAL 10 NORTH RIVER ROAD FORT YATES ND 58538 SIOUX (701) 854-3831 Acute Care Hospitals Government - Federal TRUE 46.0952325 -100.6281136 1 ROOFTOP 85 38 38085 13900   Outlying Sioux County https://data.medicare.gov/resource/xubh-q36u/row-a84q-rj3h~6yed 350064 651228 2019-06-18 2018-09-30 12           12               12
3441 3441 GREAT PLAINS HEALTH 601 WEST LEOTA ST NORTH PLATTE NE 69101 LINCOLN (308) 696-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.1207460 -100.7701990 0   111 31 31111 35820   Central Lincoln County https://data.medicare.gov/resource/xubh-q36u/row-py5q-kbgw~y9u7 280065 648853 2019-05-28 2018-12-31 78 19         97 19             116
705 705 CHI ST ALEXIUS HEALTH 900 E BROADWAY BISMARCK ND 58501 BURLEIGH (701) 530-7000 Acute Care Hospitals Voluntary non-profit - Church TRUE 46.8063690 -100.7770750 0   15 38 38015 13900   Central Burleigh County https://data.medicare.gov/resource/xubh-q36u/row-i4ue-xmjd.qmkx 350002 662065 2019-12-03 2019-06-30 142 39         181 25     19       225
706 706 SANFORD MEDICAL CENTER BISMARCK 300 N 7TH ST BISMARCK ND 58506 BURLEIGH (701) 323-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.8074570 -100.7815630 0   15 38 38015 13900   Central Burleigh County https://data.medicare.gov/resource/xubh-q36u/row-f5kb_rtms_6wyz 350015 645852 2019-03-29 2018-12-31 174 13 20       207 20             227
3655 3655 PHS INDIAN HOSPITAL AT ROSEBUD 400 SOLDIER CREEK ROAD ROSEBUD SD 57570 TODD (605) 747-2231 Acute Care Hospitals Government - Federal TRUE 43.2553350 -100.8421210 0   121 46 46121         https://data.medicare.gov/resource/xubh-q36u/row-5qds~56wu-8q7x 430084 650907 2019-06-22 2018-09-30 35           35               35
2003 2003 ST CATHERINE HOSPITAL 401 EAST SPRUCE GARDEN CITY KS 67846 FINNEY (620) 272-2222 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.9688710 -100.8686150 0   55 20 20055 23780   Central Finney County https://data.medicare.gov/resource/xubh-q36u/row-33tn.4j7w~te3s 170023 660221 2019-11-26 2019-06-30 75 8       7 90   10           100
4682 4682 VAL VERDE REGIONAL MEDICAL CENTER 801 BEDELL AVE DEL RIO TX 78840 VAL VERDE (830) 775-8566 Acute Care Hospitals Proprietary TRUE 29.3744250 -100.8930340 0   465 48 48465 19620   Central Val Verde County https://data.medicare.gov/resource/xubh-q36u/row-vvbk~jkwv.nw4c 450154 660322 2019-12-03 2019-06-30 40 7         47           1   48
4265 4265 SOUTHWEST MEDICAL CENTER 315 WEST 15TH STREET LIBERAL KS 67901 SEWARD (620) 629-6291 Acute Care Hospitals Government - Local TRUE 37.0542160 -100.9265690 0   175 20 20175 30580   Central Seward County https://data.medicare.gov/resource/xubh-q36u/row-vgq9-s5vq_zsjm 170068 649108 2019-05-30 2018-12-31 63 8         71       18       89
1669 1669 PHS INDIAN HOSPITAL AT EAGLE BUTTE 24276 166TH AIRPORT ROAD EAGLE BUTTE SD 57625 DEWEY (605) 964-3005 Acute Care Hospitals Government - Federal TRUE 44.9935681 -101.2421234 1 GEOMETRIC_CENTER 41 46 46041         https://data.medicare.gov/resource/xubh-q36u/row-5fj3.qevg-rb9t 430083 650906 2019-06-24 2018-09-30 8           8               8
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
2351 2351 BOB WILSON MEMORIAL GRANT COUNTY HOSPITAL 415 N MAIN STREET ULYSSES KS 67880 GRANT (620) 356-1266 Acute Care Hospitals Proprietary TRUE 37.5839920 -101.3580130 0   67 20 20067         https://data.medicare.gov/resource/xubh-q36u/row-8mti_jcxr_myzi 170110 660091 2019-11-26 2019-06-30 26           26               26
4502 4502 PAMPA REGIONAL MEDICAL CENTER 1 MEDICAL PLAZA PAMPA TX 79065 GRAY (806) 665-3721 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.6569910 -101.4079640 0   233 48 48233 14420 Amarillo-Borger, TX Central Hutchinson County https://data.medicare.gov/resource/xubh-q36u/row-vnbp-jjs8.azu9 450099 662430 2019-12-23 2018-12-31 89 8         97 13             110
4497 4497 SCENIC MOUNTAIN MEDICAL CENTER, A STEWARD FAMILY H 1601 W 11TH PLACE BIG SPRING TX 79720 HOWARD (432) 263-1211 Acute Care Hospitals Proprietary TRUE 32.2400150 -101.4924120 0   227 48 48227 13700   Central Howard County https://data.medicare.gov/resource/xubh-q36u/row-qsv2-q6dr_r7bx 450653 653861 2019-08-27 2018-12-31 67 8         75 17             92
4361 4361 COVENANT HOSPITAL PLAINVIEW 2601 DIMMITT RD PLAINVIEW TX 79072 HALE (806) 296-5531 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.2072140 -101.7316260 0   189 48 48189 38380   Central Hale County https://data.medicare.gov/resource/xubh-q36u/row-3bv3~8kd2-nnfr 450539 661663 2019-12-03 2019-06-30 44 5         49               49
4563 4563 GRACE MEDICAL CENTER 2412 50TH ST LUBBOCK TX 79412 LUBBOCK (806) 788-4100 Acute Care Hospitals Voluntary non-profit - Other TRUE 33.5487860 -101.8690980 0   303 48 48303 31180 Lubbock-Levelland, TX Central Lubbock County https://data.medicare.gov/resource/xubh-q36u/row-yk9u_mrt4.dz5d 450162 649351 2019-05-31 2018-12-31 85 7         92               92
4562 4562 UNIVERSITY MEDICAL CENTER 602 INDIANA AVENUE LUBBOCK TX 79415 LUBBOCK (806) 775-8200 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.5894290 -101.8879770 0   303 48 48303 31180 Lubbock-Levelland, TX Central Lubbock County https://data.medicare.gov/resource/xubh-q36u/row-rb7e~xppr~6ftx 450686 654605 2019-09-23 2018-12-31 293 104   14 20   476               476
4560 4560 COVENANT MEDICAL CENTER 3615 19TH STREET LUBBOCK TX 79410 LUBBOCK (806) 725-4431 Acute Care Hospitals Voluntary non-profit - Church TRUE 33.5778670 -101.8923570 0   303 48 48303 31180 Lubbock-Levelland, TX Central Lubbock County https://data.medicare.gov/resource/xubh-q36u/row-itui.bmgg_p92r 450040 660464 2019-12-03 2019-06-30 283 48 49       380               380
28 28 MORTON COUNTY HOSPITAL 445 N HILLTOP ELKHART KS 67950 MORTON (620) 697-2141 Acute Care Hospitals Government - Local TRUE 37.0019009 -101.9053025 1 ROOFTOP 129 20 20129         https://data.medicare.gov/resource/xubh-q36u/row-uv4u~7jpi~swm6 170166 651519 2019-07-09 2018-12-31 26           26               26
4608 4608 QUAIL CREEK SURGICAL HOSPITAL 6819 PLUM CREEK AMARILLO TX 79124 POTTER (806) 354-6100 Acute Care Hospitals Proprietary TRUE 35.2106750 -101.9135680 0   375 48 48375 11100 Amarillo-Borger, TX Central Potter County https://data.medicare.gov/resource/xubh-q36u/row-3fht_yhjz.yec5 450875 648767 2019-05-24 2018-12-31 32           32               32
4559 4559 LUBBOCK HEART HOSPITAL LP 4810 NORTH LOOP 289 LUBBOCK TX 79416 LUBBOCK (806) 687-7777 Acute Care Hospitals Proprietary TRUE 33.6025270 -101.9142870 0   303 48 48303 31180 Lubbock-Levelland, TX Central Lubbock County https://data.medicare.gov/resource/xubh-q36u/row-h2tr.sjsi-mbq3 450876 650210 2019-05-31 2018-12-31 58 15         73               73
4609 4609 BAPTIST ST ANTHONY'S HOSPITAL 1600 WALLACE BLVD AMARILLO TX 79106 POTTER (806) 212-2000 Acute Care Hospitals Proprietary TRUE 35.1951150 -101.9188500 0   375 48 48375 11100 Amarillo-Borger, TX Central Potter County https://data.medicare.gov/resource/xubh-q36u/row-4rbc-ngk8.tb7q 450231 651243 2019-06-24 2018-12-31 282   48       354   24           378
4607 4607 NORTHWEST TEXAS HOSPITAL 1501 S COULTER ST AMARILLO TX 79106 POTTER (806) 354-1110 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.1997650 -101.9218810 0   375 48 48375 11100 Amarillo-Borger, TX Central Potter County https://data.medicare.gov/resource/xubh-q36u/row-n4qk-n2ds.jvw9 450209 649499 2019-05-28 2018-12-31 240 51         347 87 10           444
4606 4606 DHHS USPHS INDIAN HEALTH SERVICES EXIT #102 OFF I-40 1/2 MILE SOUTH SAN FIDEL NM 87049 CIBOLA (505) 552-5300 Acute Care Hospitals Government - Federal TRUE 35.1838274 -101.9279458 1 ROOFTOP 375 48 48375 11100 Amarillo-Borger, TX Central Potter County https://data.medicare.gov/resource/xubh-q36u/row-j82y-frp9~f9kp 320070 647921 2019-05-08 2018-09-30 6           6               6
3542 3542 MEDICAL ARTS HOSPITAL 2200 N BRYAN AVE LAMESA TX 79331 DAWSON (806) 872-2183 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.7502790 -101.9664700 0   115 48 48115 29500   Central Dawson County https://data.medicare.gov/resource/xubh-q36u/row-epaw-jzbp_b5c6 450489 653519 2019-09-03 2019-03-31 22           22               22
4578 4578 MIDLAND MEMORIAL HOSPITAL 400 ROSALIND REDFERN GROVER PARKWAY MIDLAND TX 79701 MIDLAND (432) 685-1111 Acute Care Hospitals Government - Local TRUE 31.9974940 -102.0999760 0   329 48 48329 33260 Midland-Odessa, TX Central Midland County https://data.medicare.gov/resource/xubh-q36u/row-cs6x~ax5d_pb7f 450133 647760 2019-05-16 2018-09-30 180   48       228               228
4661 4661 BROWNFIELD REGIONAL MEDICAL CENTER 705 EAST FELT STREET BROWNFIELD TX 79316 TERRY (806) 637-3551 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.1871020 -102.2677500 0   445 48 48445         https://data.medicare.gov/resource/xubh-q36u/row-k4pi.wjbr~im2m 450399 646766 2019-04-09 2018-09-30 26           26               26
4542 4542 LAMB HEALTHCARE CENTER 1500 S SUNSET LITTLEFIELD TX 79339 LAMB (806) 385-6411 Acute Care Hospitals Government - Local TRUE 33.9116250 -102.3454390 0   279 48 48279         https://data.medicare.gov/resource/xubh-q36u/row-wpjt.5mwq_y5d4 450698 643967 2019-03-01 2018-09-30 42           42               42
3865 3865 ODESSA REGIONAL MEDICAL CENTER 520 E 6TH STREET ODESSA TX 79761 ECTOR (432) 582-8340 Acute Care Hospitals Proprietary TRUE 31.8514580 -102.3660270 0   135 48 48135 36220 Midland-Odessa, TX Central Ector County https://data.medicare.gov/resource/xubh-q36u/row-62b5_9y3z.qtwf 450661 643964 2019-02-28 2018-09-30 133 10       49 192   14           206
4483 4483 COVENANT HOSPITAL LEVELLAND 1900 COLLEGE AVE LEVELLAND TX 79336 HOCKLEY (806) 894-4963 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.5732730 -102.3677550 0   219 48 48219 30220 Lubbock-Levelland, TX Central Hockley County https://data.medicare.gov/resource/xubh-q36u/row-n4is.u6n3_9my2 450755 660473 2019-12-03 2019-06-30 48           48               48
3864 3864 MEDICAL CENTER HOSPITAL 500 W 4TH STREET ODESSA TX 79761 ECTOR (432) 640-4000 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.8443990 -102.3749100 0   135 48 48135 36220 Midland-Odessa, TX Central Ector County https://data.medicare.gov/resource/xubh-q36u/row-pyv9_u5xt_gndb 450132 654756 2019-10-03 2018-09-30 261 20 20     30 331   22           353
3570 3570 HEREFORD REGIONAL MEDICAL CENTER 801 EAST THIRD HEREFORD TX 79045 DEAF SMITH (806) 364-2141 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.8211620 -102.3902000 0   117 48 48117 25820   Central Deaf Smith County https://data.medicare.gov/resource/xubh-q36u/row-mm6e.hbdq-vz9a 450155 643952 2019-03-01 2018-09-30 30           30               30
244 244 PERMIAN REGIONAL MEDICAL CENTER ANDREWS COUNTY HO 720 HOSPITAL DRIVE ANDREWS TX 79714 ANDREWS (432) 523-2200 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.3374240 -102.5468660 0   3 48 48003 11380   Central Andrews County https://data.medicare.gov/resource/xubh-q36u/row-juik.55wn.c6fd 450144 643151 2019-02-12 2018-09-30 30           30               30
1030 1030 LEA REGIONAL MEDICAL CENTER 5419 N LOVINGTON HIGHWAY HOBBS NM 88240 LEA (575) 492-5000 Acute Care Hospitals Proprietary TRUE 32.7659880 -103.1860340 0   25 35 35025 26020   Central Lea County https://data.medicare.gov/resource/xubh-q36u/row-86mj-st3t_222u 320065 649297 2019-05-30 2018-12-31 53 8         61 15     16       92
2566 2566 STERLING REGIONAL MEDCENTER 615 FAIRHURST ST STERLING CO 80751 LOGAN (970) 522-0122 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.6136840 -103.2205240 0   75 8 8075 44540   Central Logan County https://data.medicare.gov/resource/xubh-q36u/row-9a6c-t2v5_2d88 60076 652859 2019-06-03 2018-12-31 21 4         25               25
3291 3291 BLACK HILLS SURGICAL HOSPITAL LLP 216 ANAMARIA DR RAPID CITY SD 57703 PENNINGTON (605) 721-4700 Acute Care Hospitals Proprietary FALSE 44.0460350 -103.2229120 0   103 46 46103 39660 Rapid City-Spearfish, SD Central Pennington County https://data.medicare.gov/resource/xubh-q36u/row-g4ad-2arx~xwzj 430091 650609 2019-05-28 2018-12-31 26           26               26
3289 3289 REGIONAL HEALTH RAPID CITY HOSPITAL 353 FAIRMONT BLVD POST OFFICE BOX 6000 RAPID CITY SD 57701 PENNINGTON (605) 755-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.0586100 -103.2249640 0   103 46 46103 39660 Rapid City-Spearfish, SD Central Pennington County https://data.medicare.gov/resource/xubh-q36u/row-2zks_fxav-k73q 430077 658789 2018-11-27 2018-06-30 305 38         371   16           387
3290 3290 SAME DAY SURGERY CENTER LLC 651 CATHEDRAL DRIVE RAPID CITY SD 57701 PENNINGTON (605) 755-9900 Acute Care Hospitals Proprietary FALSE 44.0591900 -103.2291020 0   103 46 46103 39660 Rapid City-Spearfish, SD Central Pennington County https://data.medicare.gov/resource/xubh-q36u/row-9hcp~bs9i-drqz 430093 658957 2019-11-18 2019-06-30 6           6               6
455 455 PLAINS REGIONAL MEDICAL CENTER 2100 N MARTIN LUTHER KING, JR, BLVD CLOVIS NM 88101 CURRY (575) 769-7155 Acute Care Hospitals Government - Federal TRUE 34.4204900 -103.2317630 0   9 35 35009 17580 Clovis-Portales, NM Central Curry County https://data.medicare.gov/resource/xubh-q36u/row-dvw2.36gg-bpn9 320022 650185 2019-05-30 2018-12-31 98 8         106               106
1657 1657 ROOSEVELT GENERAL HOSPITAL 42121 US HIGHWAY 70 PORTALES NM 88130 ROOSEVELT (575) 359-1800 Acute Care Hospitals Government - State TRUE 34.1656650 -103.3681990 0   41 35 35041 38780 Clovis-Portales, NM Central Roosevelt County https://data.medicare.gov/resource/xubh-q36u/row-kycr_dkfp.ev9b 320084 659709 2019-11-26 2019-06-30 20           20               20
4101 4101 REGIONAL WEST MEDICAL CENTER 4021 AVE B SCOTTSBLUFF NE 69361 SCOTT BLUFF (308) 635-3711 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.8850550 -103.6658370 0   157 31 31157 42420   Central Scotts Bluff County https://data.medicare.gov/resource/xubh-q36u/row-vnw7.ee73.38zh 280061 654627 2019-09-13 2018-12-31 100 22         122 18 18           158
2847 2847 COLORADO PLAINS MEDICAL CENTER 1000 LINCOLN ST FORT MORGAN CO 80701 MORGAN (970) 867-3391 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.2593440 -103.7962100 0   87 8 8087 22820   Central Morgan County https://data.medicare.gov/resource/xubh-q36u/row-nm37-j9mi~bfvp 60044 645885 2019-03-28 2018-10-31 30 6         36 14             50
2726 2726 REGIONAL HEALTH SPEARFISH HOSPITAL 1440 N MAIN ST SPEARFISH SD 57783 LAWRENCE (605) 644-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.4978870 -103.8611360 0   81 46 46081 43940 Rapid City-Spearfish, SD Central Lawrence County https://data.medicare.gov/resource/xubh-q36u/row-nmym.gm8b~ekfn 430048 660032 2019-11-26 2019-06-30 24 3         27               27
700 700 CARLSBAD MEDICAL CENTER 2430 WEST PIERCE STREET CARLSBAD NM 88220 EDDY (575) 887-4570 Acute Care Hospitals Proprietary FALSE 32.4418400 -104.2586420 0   15 35 35015 16100   Central Eddy County https://data.medicare.gov/resource/xubh-q36u/row-5km2_nhcx~29i4 320063 655571 2019-02-27 2018-08-31 84 12         96   10   15       121
701 701 ARTESIA GENERAL HOSPITAL 702 N 13TH STREET ARTESIA NM 88210 EDDY (575) 748-3333 Acute Care Hospitals Voluntary non-profit - Other TRUE 32.8486030 -104.4127520 0   15 35 35015 16100   Central Eddy County https://data.medicare.gov/resource/xubh-q36u/row-t6vu-yth8.bk8u 320030 659993 2019-11-26 2019-06-30 34           34 15             49
302 302 LOVELACE REGIONAL HOSPITAL - ROSWELL 117 EAST 19TH STREET ROSWELL NM 88201 CHAVES (575) 625-3345 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.4159760 -104.5217540 0   5 35 35005 40740   Central Chaves County https://data.medicare.gov/resource/xubh-q36u/row-y4jq.pkc3~jyui 320086 648014 2019-05-22 2018-12-31 23 4         27               27
301 301 EASTERN NEW MEXICO MEDICAL CENTER 405 W COUNTRY CLUB ROAD ROSWELL NM 88201 CHAVES (575) 624-8722 Acute Care Hospitals Proprietary TRUE 33.4233000 -104.5274050 0   5 35 35005 40740   Central Chaves County https://data.medicare.gov/resource/xubh-q36u/row-ddda_ex4p_75h9 320006 656469 2019-11-01 2019-05-31 142 20         162               162
3192 3192 PARKVIEW MEDICAL CENTER, INC 400 W 16TH ST PUEBLO CO 81003 PUEBLO (719) 584-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.2816780 -104.6121230 0   101 8 8101 39380 Pueblo-Cañon City, CO Central Pueblo County https://data.medicare.gov/resource/xubh-q36u/row-6kae.fdwt~txeq 60020 656879 2018-11-28 2018-06-30 233 12       11 276 35 15           326
3193 3193 CENTURA HEALTH-ST MARY CORWIN MEDICAL CENTER 1008 MINNEQUA AVE PUEBLO CO 81004 PUEBLO (719) 557-4000 Acute Care Hospitals Voluntary non-profit - Church TRUE 38.2332110 -104.6227890 0   101 8 8101 39380 Pueblo-Cañon City, CO Central Pueblo County https://data.medicare.gov/resource/xubh-q36u/row-assn-vs45.2w8w 60012 659638 2019-11-26 2019-06-30 36 6         42               42
847 847 GUADALUPE COUNTY HOSPITAL 117 CAMINO DE VIDA, SUITE 100 SANTA ROSA NM 88435 GUADALUPE (575) 472-3417 Acute Care Hospitals Government - Local TRUE 34.9295040 -104.6942240 0   19 35 35019         https://data.medicare.gov/resource/xubh-q36u/row-es4t_p7gk_ag72 320067 661934 2019-12-17 2019-06-30 10           10               10
3673 3673 NORTH COLORADO MEDICAL CENTER 1801 - 16TH ST GREELEY CO 80631 WELD (970) 810-4121 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.4138340 -104.7094290 0   123 8 8123 24540 Denver-Aurora, CO Central Weld County https://data.medicare.gov/resource/xubh-q36u/row-b7wk~gizs_ie2f 60001 649545 2019-06-03 2018-12-31 199 16   10     225               225
58 58 PLATTE VALLEY MEDICAL CENTER 1600 PRAIRIE CENTER PKWY BRIGHTON CO 80601 ADAMS (303) 498-1601 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9654410 -104.7709240 0   1 8 8001 19740 Denver-Aurora, CO Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-nf6e_r5cw.zmhy 60004 648669 2019-05-31 2018-12-31 65 8         89               89
1381 1381 PARKER ADVENTIST HOSPITAL 9395 CROWN CREST BLVD PARKER CO 80138 DOUGLAS (303) 269-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.5500580 -104.7734330 0   35 8 8035 19740 Denver-Aurora, CO Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-5jf2-ad3k~8xxe 60114 649876 2019-06-03 2018-12-31 137 16         165               165
1639 1639 UNIVERSITY COLO HEALTH MEMORIAL HOSPITAL CENTRAL 1400 E BOULDER ST COLORADO SPRINGS CO 80909 EL PASO (719) 365-5000 Acute Care Hospitals Government - Local TRUE 38.8388120 -104.7999510 0   41 8 8041 17820   Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-a2ae-uent-g89f 60022 659639 2019-11-26 2019-06-30 385 46         515   22           537
1637 1637 UCHEALTH GRANDVIEW HOSPITAL 5623 PULPIT PEAK VIEW COLORADO SPRINGS CO 80918 EL PASO (719) 272-3623 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.9102620 -104.8164360 0   41 8 8041 17820   Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-6gec-fw6v-ugx7 60130 660178 2019-11-27 2019-06-30 22           22               22
936 936 CHEYENNE REGIONAL MEDICAL CENTER 214 EAST 23RD STREET CHEYENNE WY 82001 LARAMIE (307) 633-7600 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.1397890 -104.8170360 0   21 56 56021 16940   Central Laramie County https://data.medicare.gov/resource/xubh-q36u/row-tzsy-p3vv~5be8 530014 659630 2019-11-20 2019-06-30 155 15         170 16 20   16       222
1638 1638 CENTURA HEALTH-PENROSE-ST FRANCIS HEALTH SERVICES 2222 NORTH NEVADA AVE COLORADO SPRINGS CO 80907 EL PASO (719) 776-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.8655680 -104.8201230 0   41 8 8041 17820   Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-gqx3~746f~9uqw 60031 659763 2019-11-26 2019-06-30 354 45         445   23           468
260 260 MEDICAL CENTER OF AURORA, THE 1501 S POTOMAC ST AURORA CO 80012 ARAPAHOE (303) 873-5511 Acute Care Hospitals Proprietary TRUE 39.6893460 -104.8311500 0   5 8 8005 19740 Denver-Aurora, CO Central Arapahoe County https://data.medicare.gov/resource/xubh-q36u/row-b8kj.p6xy-3gvh 60100 648892 2019-05-31 2018-12-31 250 45       14 309 20             329
60 60 UNIVERSITY OF COLORADO HOSPITAL AUTHORITY 12605 E 16TH AVE AURORA CO 80045 ADAMS (720) 848-0000 Acute Care Hospitals Government - Hospital District or Authority TRUE 39.7413640 -104.8412750 0   1 8 8001 19740 Denver-Aurora, CO Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-sx7w-4iik_kiyq 60024 659482 2019-11-25 2019-06-30 432 101   19 24 50 650   12           662
1380 1380 SKY RIDGE MEDICAL CENTER 10101 RIDGEGATE PARKWAY LONE TREE CO 80124 DOUGLAS (720) 225-1000 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.5293230 -104.8702690 0   35 8 8035 19740 Denver-Aurora, CO Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-qr62~ugzc.jjbq 60112 659642 2019-11-26 2019-06-30 214 30         272               272
1382 1382 CASTLE ROCK ADVENTIST HOSPITAL 2350 MEADOWS BLVD CASTLE ROCK CO 80109 DOUGLAS (720) 455-2500 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.4041120 -104.8861460 0   35 8 8035 19740 Denver-Aurora, CO Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-k43v-w5np~b8ck 60125 649877 2019-06-03 2018-12-31 41 8         53               53
1205 1205 ROSE MEDICAL CENTER 4567 E 9TH AVE DENVER CO 80220 DENVER (303) 320-2121 Acute Care Hospitals Proprietary TRUE 39.7310760 -104.9340110 0   31 8 8031 19740 Denver-Aurora, CO Central Denver County https://data.medicare.gov/resource/xubh-q36u/row-d89y.4k32_5asy 60032 649400 2019-05-24 2018-12-31 167 35       24 226               226
1202 1202 NATIONAL JEWISH HEALTH 1400 JACKSON ST DENVER CO 80206 DENVER (303) 388-4461 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.7400190 -104.9428920 0   31 8 8031 19740 Denver-Aurora, CO Central Denver County https://data.medicare.gov/resource/xubh-q36u/row-7hr7.gg8i-chk4 60107 659641 2019-11-25 2019-06-30 24           24               24
1206 1206 PRESBYTERIAN ST LUKES MEDICAL CENTER 1719 E 19TH AVE DENVER CO 80218 DENVER (303) 839-6000 Acute Care Hospitals Government - State TRUE 39.7460890 -104.9671750 0   31 8 8031 19740 Denver-Aurora, CO Central Denver County https://data.medicare.gov/resource/xubh-q36u/row-deb8~67qk~e2fi 60014 655884 2019-07-30 2018-08-31 224 71         337               337
1203 1203 SAINT JOSEPH HOSPITAL 1375 E 19TH AVE DENVER CO 80218 DENVER (303) 812-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.7457220 -104.9721350 0   31 8 8031 19740 Denver-Aurora, CO Central Denver County https://data.medicare.gov/resource/xubh-q36u/row-yaud.gj8n-p2rj 60028 646545 2019-04-11 2018-12-31 296 30         361               361
1201 1201 CENTURA HEALTH-PORTER ADVENTIST HOSPITAL 2525 S DOWNING ST DENVER CO 80210 DENVER (303) 778-1955 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.6706400 -104.9734820 0   31 8 8031 19740 Denver-Aurora, CO Central Denver County https://data.medicare.gov/resource/xubh-q36u/row-7qah~g3t4-w829 60064 649874 2019-06-03 2018-12-31 140 36         176 44 13           233
261 261 SWEDISH MEDICAL CENTER 501 E HAMPDEN AVE ENGLEWOOD CO 80113 ARAPAHOE (303) 788-5000 Acute Care Hospitals Proprietary TRUE 39.6531360 -104.9817100 0   5 8 8005 19740 Denver-Aurora, CO Central Arapahoe County https://data.medicare.gov/resource/xubh-q36u/row-3yvr.y5p2.2bay 60034 643574 2019-02-26 2018-09-30 281 58       17 356   16           372
61 61 NORTH SUBURBAN MEDICAL CENTER 9191 GRANT ST THORNTON CO 80229 ADAMS (303) 451-7800 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.8643800 -104.9847830 0   1 8 8001 19740 Denver-Aurora, CO Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-tvxk_43rk.h2qn 60065 649402 2019-05-31 2018-12-31 111 16         127               127
262 262 CENTURA HEALTH-LITTLETON ADVENTIST HOSPITAL 7700 S BROADWAY LITTLETON CO 80122 ARAPAHOE (303) 730-8900 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.5765540 -104.9884890 0   5 8 8005 19740 Denver-Aurora, CO Central Arapahoe County https://data.medicare.gov/resource/xubh-q36u/row-xab7~spdz_mmxf 60113 649074 2019-06-03 2018-12-31 121 24         159   17           176
1204 1204 DENVER HEALTH MEDICAL CENTER 777 BANNOCK ST DENVER CO 80204 DENVER (303) 602-4930 Acute Care Hospitals Government - State TRUE 39.7282300 -104.9900660 0   31 8 8031 19740 Denver-Aurora, CO Central Denver County https://data.medicare.gov/resource/xubh-q36u/row-6si7.z49y~jb56 60011 650437 2019-05-31 2018-12-31 298 32     23 25 378 64 11           453
57 57 ST ANTHONY NORTH HEALTH CAMPUS 14300 ORCHARD PKWY WESTMINSTER CO 80023 BROOMFIELD (720) 627-0000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9558100 -104.9936710 0   1 8 8001 19740 Denver-Aurora, CO Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-ids9.66gw~rrbq 60104 659640 2019-11-26 2019-06-30 72 20         92               92
2389 2389 MEDICAL CENTER OF THE ROCKIES 2500 ROCKY MOUNTAIN AVENUE LOVELAND CO 80538 LARIMER (970) 624-2500 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.4151940 -105.0014510 0   69 8 8069 22660   Central Larimer County https://data.medicare.gov/resource/xubh-q36u/row-zpsq-figy~e5ag 60119 659764 2019-11-26 2019-06-30 142 20 12       174               174
2387 2387 BANNER FORT COLLINS MEDICAL CENTER 4700 LADY MOON DRIVE FORT COLLINS CO 80528 LARIMER (970) 821-4000 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.5211170 -105.0108850 0   69 8 8069 22660   Central Larimer County https://data.medicare.gov/resource/xubh-q36u/row-t2c3_t3mg_dfjd 60126 652186 2019-06-03 2018-12-31 23           23               23
2390 2390 MCKEE MEDICAL CENTER 2000 BOISE AVE LOVELAND CO 80538 LARIMER (970) 669-4640 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.4136790 -105.0535990 0   69 8 8069 22660   Central Larimer County https://data.medicare.gov/resource/xubh-q36u/row-33js.ddiw.t8wg 60030 649547 2019-06-03 2018-12-31 104 11         115               115
2391 2391 POUDRE VALLEY HOSPITAL 1024 S LEMAY AVE FORT COLLINS CO 80524 LARIMER (970) 495-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.5737240 -105.0578600 0   69 8 8069 22660   Central Larimer County https://data.medicare.gov/resource/xubh-q36u/row-hg6n.psiu_j6i6 60010 660356 2019-11-26 2019-06-30 188 12       25 225 41 14           280
593 593 LONGS PEAK HOSPITAL 1750 EAST KEN PRATT BOULEVARD LONGMONT CO 80504 BOULDER (720) 718-3005 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.1621720 -105.0581160 1 ROOFTOP 13 8 8013 14500 Denver-Aurora, CO Central Boulder County https://data.medicare.gov/resource/xubh-q36u/row-i5b6~xwcd-bndp 60128 661294 2019-12-03 2019-06-30 44 6         50               50
595 595 GOOD SAMARITAN MEDICAL CENTER 200 EXEMPLA CIRCLE LAFAYETTE CO 80026 BOULDER (303) 689-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9697530 -105.0830650 0   13 8 8013 14500 Denver-Aurora, CO Central Boulder County https://data.medicare.gov/resource/xubh-q36u/row-rxs8-5fmc-dv4k 60116 650243 2019-06-03 2018-12-31 147 24         183               183
2130 2130 LUTHERAN MEDICAL CENTER 8300 W 38TH AVE WHEAT RIDGE CO 80033 JEFFERSON (303) 425-4500 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.7693280 -105.0892910 0   59 8 8059 19740 Denver-Aurora, CO Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-h45t-vvz5~5dzw 60009 649546 2019-05-31 2018-12-31 148 18         186 96         24   306
665 665 UCHEALTH BROOMFIELD HOSPITAL 11820 DESTINATION DRIVE BROOMFIELD CO 80021 JEFFERSON (303) 460-6000 Acute Care Hospitals Proprietary TRUE 39.9105000 -105.0932070 0   14 8 8014 19740 Denver-Aurora, CO Central Broomfield County https://data.medicare.gov/resource/xubh-q36u/row-dvb6-rzzd_er2t 60129 661295 2019-11-26 2019-06-30 22           22               22
591 591 LONGMONT UNITED HOSPITAL 1950 MOUNTAIN VIEW AVE LONGMONT CO 80501 BOULDER (303) 651-5111 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.1813240 -105.1263820 0   13 8 8013 14500 Denver-Aurora, CO Central Boulder County https://data.medicare.gov/resource/xubh-q36u/row-46cx.u9fm~wqwb 60003 649707 2019-06-03 2018-12-31 109 16         131               131
2129 2129 CENTURA HEALTH-ST ANTHONY HOSPITAL 11600 WEST 2ND PLC LAKEWOOD CO 80228 JEFFERSON (720) 321-0000 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.7179560 -105.1274940 0   59 8 8059 19740 Denver-Aurora, CO Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-hs5j-ymh4.6b3z 60015 659760 2019-11-26 2019-06-30 144 28     48   220   17           237
2131 2131 ORTHOCOLORADO HOSPITAL AT ST ANTHONY MED CAMPUS 11650 WEST 2ND PLACE LAKEWOOD CO 80228 JEFFERSON (720) 321-5000 Acute Care Hospitals Proprietary TRUE 39.7179520 -105.1284410 0   59 8 8059 19740 Denver-Aurora, CO Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-b3pw~3vk6_q65v 60124 659765 2019-11-26 2019-06-30 48           48               48
592 592 CENTURA HEALTH-AVISTA ADVENTIST HOSPITAL 100 HEALTH PARK DR LOUISVILLE CO 80027 BOULDER (303) 673-1280 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.9508470 -105.1491540 0   13 8 8013 14500 Denver-Aurora, CO Central Boulder County https://data.medicare.gov/resource/xubh-q36u/row-mqpm_6h4w_if8p 60103 649709 2019-06-03 2018-12-31 74 8         108               108
1797 1797 ALTA VISTA REGIONAL HOSPITAL 104 LEGION DRIVE LAS VEGAS NM 87701 SAN MIGUEL (505) 426-3930 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.6221500 -105.2098510 0   47 35 35047 29780 Albuquerque-Santa Fe-Las Vegas, NM Central San Miguel County https://data.medicare.gov/resource/xubh-q36u/row-eqjk~u8wz_58xt 320003 657378 2019-08-22 2018-08-31 38 8         46               46
594 594 FOOTHILLS HOSPITAL 4747 ARAPAHOE AVENUE BOULDER CO 80303 BOULDER (303) 415-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.0148080 -105.2363370 0   13 8 8013 14500 Denver-Aurora, CO Central Boulder County https://data.medicare.gov/resource/xubh-q36u/row-4kfx-dknr-8k6x 60027 652584 2019-07-23 2018-12-31 121 18         139 15 14           168
333 333 CAMPBELL COUNTY MEMORIAL HOSPITAL 501 SOUTH BURMA AVENUE GILLETTE WY 82716 CAMPBELL (307) 688-1551 Acute Care Hospitals Government - Hospital District or Authority TRUE 44.2898460 -105.5195570 0   5 56 56005 23940   Central Campbell County https://data.medicare.gov/resource/xubh-q36u/row-ppek.rg99~yqr6 530002 658628 2018-11-29 2018-06-30 52 14         66 6     160       232
132 132 IVINSON MEMORIAL HOSPITAL 255 N 30TH LARAMIE WY 82072 ALBANY (307) 755-4600 Acute Care Hospitals Government - Hospital District or Authority TRUE 41.3113900 -105.5575120 0   1 56 56001 29660   Central Albany County https://data.medicare.gov/resource/xubh-q36u/row-ptq5-c827_j29e 530025 660342 2019-12-03 2019-06-30 62 4         66 10     10       86
1401 1401 MESCALERO PHS INDIAN HOSPITAL P O BOX 210 MESCALERO NM 88340 OTERO (505) 464-4441 Acute Care Hospitals Government - Federal FALSE 33.1587939 -105.7723979 1 ROOFTOP 35 35 35035 10460   Central Otero County https://data.medicare.gov/resource/xubh-q36u/row-vqii_apfk.3xws 320058 650730 2019-06-22 2018-09-30 6           6               6
140 140 SAN LUIS VALLEY HEALTH 106 BLANCA AVE ALAMOSA CO 81101 ALAMOSA (719) 589-2511 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.4723600 -105.8837120 0   3 8 8003         https://data.medicare.gov/resource/xubh-q36u/row-bztx~k7ma~ri7p 60008 661701 2019-12-03 2019-06-30 43 6         49               49
1400 1400 GERALD CHAMPION REGIONAL MEDICAL CENTER 2669 NORTH SCENIC DRIVE ALAMOGORDO NM 88310 OTERO (575) 443-6100 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.9268620 -105.9339170 0   35 35 35035 10460   Central Otero County https://data.medicare.gov/resource/xubh-q36u/row-jeb6-3eqs_s323 320004 659992 2019-12-03 2019-06-30 40 10         50 36 12           98
1854 1854 CHRISTUS ST VINCENT REGIONAL MEDICAL CENTER 455 ST MICHAEL'S DRIVE SANTA FE NM 87505 SANTA FE (505) 913-5201 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.6577890 -105.9469460 0   49 35 35049 42140 Albuquerque-Santa Fe-Las Vegas, NM Central Santa Fe County https://data.medicare.gov/resource/xubh-q36u/row-ew8z~vnrx_nfua 320002 661060 2019-11-26 2019-06-30 167 18         185 9 20           214
1852 1852 SANTA FE PHS INDIAN HOSPITAL 1700 CERRILLOS ROAD SANTA FE NM 87501 SANTA FE (505) 988-9821 Acute Care Hospitals Government - Federal FALSE 35.6669500 -105.9696650 0   49 35 35049 42140 Albuquerque-Santa Fe-Las Vegas, NM Central Santa Fe County https://data.medicare.gov/resource/xubh-q36u/row-9cut.x6uq_hkie 320057 647086 2019-04-27 2018-09-30 4           4               4

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