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

46 rows where "filed_date" is on date 2019-05-23

✎ 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, oth_longterm_beds, fy_end_date (date)

filed_date (date) ✖

  • 2019-05-23 · 46 ✖
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
214 214 VALLEY HOSPITAL 223 N VAN DIEN AVENUE RIDGEWOOD NJ 7450 BERGEN (201) 447-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.9832040 -74.1017610 0   3 34 34003 35620 New York-Newark, NY-NJ-CT-PA Central Bergen County https://data.medicare.gov/resource/xubh-q36u/row-dcmv-g3rd.mciv 310012 648551 2019-05-23 2018-12-31 327 14 22       363               363
297 297 VIRTUA MEMORIAL HOSPITAL OF BURLINGTON COUNTY 175 MADISON AVE MOUNT HOLLY NJ 8060 BURLINGTON (609) 267-0700 Acute Care Hospitals Voluntary non-profit - Private FALSE 39.9856980 -74.7958320 0   5 34 34005 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Burlington County https://data.medicare.gov/resource/xubh-q36u/row-w3rd~k8u3.pry2 310057 648553 2019-05-23 2018-12-31 279 38         317 22             339
360 360 SANFORD BEMIDJI MEDICAL CENTER 1300 ANNE ST NW BEMIDJI MN 56601 BELTRAMI (218) 751-5430 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.5050090 -94.8981250 0   7 27 27007 13420   Central Beltrami County https://data.medicare.gov/resource/xubh-q36u/row-uwkp_7ty3-835f 240100 649770 2019-05-23 2018-12-31 84 10         94 12 12   78       196
371 371 VIRTUA WEST JERSEY HOSPITALS VOORHEES 100 BOWMAN DRIVE VOORHEES NJ 8043 CAMDEN (856) 247-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.8423270 -74.9278920 0   7 34 34007 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Camden County https://data.medicare.gov/resource/xubh-q36u/row-gtsh-gq9y.2jxt 310022 648552 2019-05-23 2018-12-31 463 48       30 587               587
651 651 SANFORD ABERDEEN MEDICAL CENTER 2905 3RD AVE SE ABERDEEN SD 57402 BROWN (605) 626-4200 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.4621400 -98.4472370 0   13 46 46013 10100   Central Brown County https://data.medicare.gov/resource/xubh-q36u/row-y434_ii38-mfbk 430097 648656 2019-05-23 2018-12-31 48           48               48
659 659 DAYTON GENERAL HOSPITAL 1012 SOUTH 3RD STREET DAYTON WA 99328 COLUMBIA (509) 382-2531 Critical Access Hospitals Government - Hospital District or Authority FALSE 46.3125640 -117.9688720 0   13 53 53013 47460   Outlying Columbia County https://data.medicare.gov/resource/xubh-q36u/row-28j5-9jsv-a9rd 501302 648506 2019-05-23 2018-12-31 25           25         23     48
690 690 NEW ULM MEDICAL CENTER 1324 FIFTH NORTH STREET NEW ULM MN 56073 BROWN (507) 217-5000 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.3125040 -94.4751740 0   15 27 27015 35580 Mankato-New Ulm-North Mankato, MN Central Brown County https://data.medicare.gov/resource/xubh-q36u/row-ebnr~hsq4-36pd 241378 649788 2019-05-23 2018-12-31 24           24 10             34
973 973 CAROLINAS HEALTHCARE SYSTEM-BLUE RIDGE 2201 S STERLING ST MORGANTON NC 28655 BURKE (828) 580-5000 Acute Care Hospitals Proprietary TRUE 35.7237930 -81.6582230 0   23 37 37023 25860 Hickory-Lenoir, NC Central Burke County https://data.medicare.gov/resource/xubh-q36u/row-ic6d~9x8y.54pm 340075 648962 2019-05-23 2018-12-31 136 16       4 156               156
1098 1098 GRADY MEMORIAL HOSPITAL 2220 IOWA STREET CHICKASHA OK 73018 GRADY (405) 224-2300 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.2245090 -97.4739230 0   27 40 40027 36420 Oklahoma City-Shawnee, OK Central Cleveland County https://data.medicare.gov/resource/xubh-q36u/row-iy73_c264_932j 370054 648755 2019-05-23 2018-12-31 40 9         49               49
1103 1103 SANFORD VERMILLION HOSPITAL 20 SOUTH PLUM STREET VERMILLION SD 57069 CLAY (605) 677-3500 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.7786350 -96.9199180 0   27 46 46027 46820 Sioux City-Vermillion, IA-SD-NE Central Clay County https://data.medicare.gov/resource/xubh-q36u/row-8788-rfn9-569i 431336 648484 2019-05-23 2018-12-31 25           25               25
1412 1412 SOUTHWEST GENERAL HEALTH CENTER 18697 BAGLEY ROAD MIDDLEBURG HEIGHTS OH 44130 CUYAHOGA (440) 816-6701 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.3720800 -81.8329100 0   35 39 39035 17460 Cleveland-Akron-Canton, OH Central Cuyahoga County https://data.medicare.gov/resource/xubh-q36u/row-d2bh.mbph_iq6y 360155 648457 2019-05-23 2018-12-31 157 40         197 36 15       10   258
1434 1434 RIVERTON HOSPITAL 3741 WEST 12600 SOUTH RIVERTON UT 84065 SALT LAKE (801) 285-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.5222380 -111.9797250 0   35 49 49035 41620 Salt Lake City-Provo-Orem, UT Central Salt Lake County https://data.medicare.gov/resource/xubh-q36u/row-mw84.scg3-mf8v 460058 652114 2019-05-23 2018-12-31 74 4         87               87
1484 1484 MISSION COMMUNITY HOSPITAL 14850 ROSCOE BLVD PANORAMA CITY CA 91402 LOS ANGELES (818) 904-3100 Acute Care Hospitals Voluntary non-profit - Private FALSE 34.2214940 -118.4568020 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-xe34_tjmv-ebqq 50704 648597 2019-05-23 2018-12-31 135 10         145               145
1522 1522 PROVIDENCE SAINT JOSEPH MEDICAL CTR 501 SOUTH BUENA VISTA STREET BURBANK CA 91505 LOS ANGELES (818) 843-5111 Acute Care Hospitals Voluntary non-profit - Church TRUE 34.1576430 -118.3278410 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-rj34_8dmg~eewb 50235 648593 2019-05-23 2018-12-31 319 38       20 377   15           392
1545 1545 REGINA HOSPITAL 1175 NININGER ROAD HASTINGS MN 55033 DAKOTA (651) 480-4100 Acute Care Hospitals Voluntary non-profit - Church TRUE 44.7471310 -92.8713990 0   37 27 27037 33460 Minneapolis-St. Paul, MN-WI Central Dakota County https://data.medicare.gov/resource/xubh-q36u/row-iqs2~mgnv-cytq 240059 649763 2019-05-23 2018-12-31 29           29 14             43
1548 1548 CASS REGIONAL MEDICAL CENTER 2800 E ROCK HAVEN ROAD HARRISONVILLE MO 64701 CASS (816) 380-5888 Critical Access Hospitals Government - Local TRUE 38.6633450 -94.3753210 0   37 29 29037 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Cass County https://data.medicare.gov/resource/xubh-q36u/row-c2vq_b9fy-5cik 261324 648286 2019-05-23 2018-12-31 21 4         25 10             35
1676 1676 PROVIDENCE CENTRALIA HOSPITAL 914 S SCHEUBER ROAD CENTRALIA WA 98531 LEWIS (360) 736-2803 Acute Care Hospitals Voluntary non-profit - Other TRUE 46.7123500 -122.9869890 0   41 53 53041 16500 Seattle-Tacoma, WA Central Lewis County https://data.medicare.gov/resource/xubh-q36u/row-rpu9~qgn5_cp2i 500019 652169 2019-05-23 2018-12-31 110 6         116               116
1677 1677 ARBOR HEALTH MORTON HOSPITAL 521 ADAMS STREET MORTON WA 98356 LEWIS (360) 496-5112 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.5559530 -122.2798780 0   41 53 53041 16500 Seattle-Tacoma, WA Central Lewis County https://data.medicare.gov/resource/xubh-q36u/row-rfdw-ekhk~ca8x 501319 648508 2019-05-23 2018-12-31 25           25               25
1726 1726 GRAND RIVER MEDICAL CENTER 501 AIRPORT RD RIFLE CO 81650 GARFIELD (970) 625-1510 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.5225870 -107.7720100 0   45 8 8045 24060 Edwards-Glenwood Springs, CO Central Garfield County https://data.medicare.gov/resource/xubh-q36u/row-gvuq~c8qg.v3zk 61317 649076 2019-05-23 2018-12-31 12           12       49       61
1822 1822 THREE RIVERS HOSPITAL 507 HOSPITAL WAY BREWSTER WA 98812 OKANOGAN (509) 689-2517 Critical Access Hospitals Government - Hospital District or Authority TRUE 48.1068240 -119.7826860 0   47 53 53047         https://data.medicare.gov/resource/xubh-q36u/row-5na6-v5bw~u665 501324 648509 2019-05-23 2018-12-31 25           25               25
1955 1955 ABBOTT NORTHWESTERN HOSPITAL 800 EAST 28TH STREET MINNEAPOLIS MN 55407 HENNEPIN (612) 863-4457 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.9519540 -93.2622480 0   53 27 27053 33460 Minneapolis-St. Paul, MN-WI Central Hennepin County https://data.medicare.gov/resource/xubh-q36u/row-hjfu-wxhn.rudj 240057 649761 2019-05-23 2018-12-31 537 30         599   39   48       686
1956 1956 PARK NICOLLET METHODIST HOSPITAL 6500 EXCELSIOR BLVD SAINT LOUIS PARK MN 55426 HENNEPIN (952) 993-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.9270540 -93.3623910 0   53 27 27053 33460 Minneapolis-St. Paul, MN-WI Central Hennepin County https://data.medicare.gov/resource/xubh-q36u/row-vshk-nqdg.9jmb 240053 649450 2019-05-23 2018-12-31 339 22         361           4   365
2095 2095 POTOMAC VALLEY HOSPITAL 100 PIN OAK LANE KEYSER WV 26726 MINERAL (304) 597-3500 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.4089080 -79.0034680 0   57 54 54057 19060   Outlying Mineral County https://data.medicare.gov/resource/xubh-q36u/row-8et5~dq6x.ejht 511315 649004 2019-05-23 2018-12-31 21 4         25               25
2143 2143 CAMBRIDGE MEDICAL CENTER 701 SOUTH DELLWOOD AVENUE CAMBRIDGE MN 55008 ISANTI (763) 689-7700 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.5665700 -93.2293190 0   59 27 27059 33460 Minneapolis-St. Paul, MN-WI Outlying Isanti County https://data.medicare.gov/resource/xubh-q36u/row-m3ik.nhi8~efrk 240020 649616 2019-05-23 2018-12-31 70           70               70
2256 2256 COMMUNITY MEDICAL CENTER 2827 FORT MISSOULA RD MISSOULA MT 59804 MISSOULA (406) 728-4100 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.8420620 -114.0559190 0   63 30 30063 33540   Central Missoula County https://data.medicare.gov/resource/xubh-q36u/row-ymvp.arip.4g35 270023 648711 2019-05-23 2018-12-31 109 8         141   10           151
2276 2276 PROVIDENCE HOLY FAMILY HOSPITAL 5633 NORTH LIDGERWOOD SPOKANE WA 99208 SPOKANE (509) 482-2450 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.7097510 -117.4059040 0   63 53 53063 44060 Spokane-Spokane Valley-Coeur d'Alene, WA-ID Central Spokane County https://data.medicare.gov/resource/xubh-q36u/row-f3tf.yzjd.sw7e 500077 648661 2019-05-23 2018-12-31 170 14         184               184
2328 2328 PROVIDENCE ST JOSEPH HOSPITAL 500 EAST WEBSTER CHEWELAH WA 99109 STEVENS (509) 935-8211 Critical Access Hospitals Voluntary non-profit - Church TRUE 48.2782130 -117.7108460 0   65 53 53065 44060 Spokane-Spokane Valley-Coeur d'Alene, WA-ID Outlying Stevens County https://data.medicare.gov/resource/xubh-q36u/row-qxaa-u42f_ceuj 501309 648507 2019-05-23 2018-12-31 23           23       40       63
2721 2721 PRAGUE COMMUNITY HOSPITAL 1322 KLABZUBA AVENUE PRAGUE OK 74864 LINCOLN (405) 567-4922 Critical Access Hospitals Voluntary non-profit - Other TRUE 35.4903120 -96.6845450 0   81 40 40081 36420 Oklahoma City-Shawnee, OK Outlying Lincoln County https://data.medicare.gov/resource/xubh-q36u/row-mfpk~mdqe_9hyf 371301 648472 2019-05-23 2018-09-30 25           25               25
2768 2768 SANFORD CANTON-INWOOD MEDICAL CENTER - CAH 440 NORTH HIAWATHA DRIVE CANTON SD 57013 LINCOLN (605) 764-1400 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.3049440 -96.5572490 0   83 46 46083 43620   Central Lincoln County https://data.medicare.gov/resource/xubh-q36u/row-drz2_z7zb-tas3 431333 648483 2019-05-23 2018-12-31 11           11               11
2867 2867 THREE GABLES SURGERY CENTER 5897 COUNTY ROAD 107 PROCTORVILLE OH 45669 LAWRENCE (740) 886-9911 Acute Care Hospitals Proprietary FALSE 38.4407480 -82.3932980 0   87 39 39087 26580 Charleston-Huntington-Ashland, WV-OH-KY Central Lawrence County https://data.medicare.gov/resource/xubh-q36u/row-9r4y.f6ba-vqwk 360261 648744 2019-05-23 2018-12-31 8           8               8
2905 2905 JEWELL COUNTY HOSPITAL 100 CRESTVUE AVE MANKATO KS 66956 JEWELL (785) 378-3137 Critical Access Hospitals Government - Local TRUE 39.7870540 -98.2012980 0   89 20 20089         https://data.medicare.gov/resource/xubh-q36u/row-gu6a_d9d9-pvcm 171309 648112 2019-05-23 2018-12-31 24           24               24
3017 3017 FORT SANDERS REGIONAL MEDICAL CENTER 1901 W CLINCH AVE KNOXVILLE TN 37916 KNOX (865) 541-1101 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.9568100 -83.9371340 0   93 47 47093 28940 Knoxville-Morristown-Sevierville, TN Central Knox County https://data.medicare.gov/resource/xubh-q36u/row-8e2p.abje.exrt 440125 648210 2019-05-23 2018-12-31 235 45         280   48   24       352
3316 3316 SANFORD WORTHINGTON MEDICAL CENTER 1018 SIXTH AVENUE PO BOX 997 WORTHINGTON MN 56187 NOBLES (507) 372-3110 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.6218580 -95.5991790 0   105 27 27105 49380   Central Nobles County https://data.medicare.gov/resource/xubh-q36u/row-vkcf_xfj8_fn99 240022 649449 2019-05-23 2018-12-31 48           48               48
3408 3408 RIVER FALLS AREA HOSPITAL 1629 E DIVISION ST RIVER FALLS WI 54022 PIERCE (715) 307-6000 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.8628590 -92.6028290 0   109 55 55109 33460 Minneapolis-St. Paul, MN-WI Outlying St. Croix County https://data.medicare.gov/resource/xubh-q36u/row-fvdb.8p3x~reu2 521349 649855 2019-05-23 2018-12-31 25           25               25
3632 3632 GRADY MEMORIAL HOSPITAL 80 JESSE HILL, JR DRIVE SE ATLANTA GA 30303 FULTON (404) 616-4252 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.7521560 -84.3826090 0   121 13 13121 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Fulton County https://data.medicare.gov/resource/xubh-q36u/row-i4i8_dfz7~tvds 110079 648180 2019-05-23 2018-12-31 416 140     53   659 24     291       974
3684 3684 UNITED HOSPITAL 333 NORTH SMITH AVENUE SAINT PAUL MN 55102 RAMSEY (651) 241-8810 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.9418500 -93.1083020 0   123 27 27123 33460 Minneapolis-St. Paul, MN-WI Central Ramsey County https://data.medicare.gov/resource/xubh-q36u/row-r32t.y29n-y4h6 240038 649617 2019-05-23 2018-12-31 301 21         336 13 16           365
3748 3748 MORRIS COUNTY HOSPITAL 600 N WASHINGTON ST COUNCIL GROVE KS 66846 MORRIS (620) 767-6811 Critical Access Hospitals Government - Local FALSE 38.6651150 -96.5001290 0   127 20 20127         https://data.medicare.gov/resource/xubh-q36u/row-gbrg_pxf6-b37g 171379 648385 2019-05-23 2018-12-31 25           25               25
3811 3811 NORTHFIELD HOSPITAL 2000 NORTH AVENUE NORTHFIELD MN 55057 RICE (507) 646-1001 Acute Care Hospitals Government - Local TRUE 44.4713860 -93.1911590 0   131 27 27131 22060 Minneapolis-St. Paul, MN-WI Central Rice County https://data.medicare.gov/resource/xubh-q36u/row-jbxu.wpwn~7zmq 240014 649615 2019-05-23 2018-12-31 33   4       37       40       77
3812 3812 DISTRICT ONE HOSPITAL 200 STATE AVENUE FARIBAULT MN 55021 RICE (507) 334-6451 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.2887150 -93.2560220 0   131 27 27131 22060 Minneapolis-St. Paul, MN-WI Central Rice County https://data.medicare.gov/resource/xubh-q36u/row-9m29.uvsf.97a3 240071 649767 2019-05-23 2018-12-31 32           32               32
3831 3831 SANFORD LUVERNE MEDICAL CENTER 1600 N KNISS AVENUE P O BOX 1019 LUVERNE MN 56156 ROCK (507) 283-2321 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.6716050 -96.2125230 0   133 27 27133         https://data.medicare.gov/resource/xubh-q36u/row-pa3e~vxpi-773p 241371 649787 2019-05-23 2018-12-31 25           25               25
3894 3894 ST FRANCIS REGIONAL MEDICAL CENTER 1455 ST FRANCIS AVENUE SHAKOPEE MN 55379 SCOTT (952) 403-3000 Acute Care Hospitals Voluntary non-profit - Church TRUE 44.7700750 -93.5035690 0   139 27 27139 33460 Minneapolis-St. Paul, MN-WI Central Scott County https://data.medicare.gov/resource/xubh-q36u/row-trjd.w3di-4nw8 240104 649771 2019-05-23 2018-12-31 89           89               89
3916 3916 SANFORD SHELDON MEDICAL CENTER 118 NORTH 7TH AVENUE SHELDON IA 51201 OBRIEN (712) 324-5041 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.1863870 -95.8472680 0   141 19 19141         https://data.medicare.gov/resource/xubh-q36u/row-dbh5_z7mp.tsgp 161381 648616 2019-05-23 2018-12-31 25           25           70   95
4001 4001 OWATONNA HOSPITAL 2250 26TH STREET NORTHWEST OWATONNA MN 55060 STEELE (507) 977-2000 Acute Care Hospitals Voluntary non-profit - Other TRUE 44.1097980 -93.2363010 0   147 27 27147 36940   Central Steele County https://data.medicare.gov/resource/xubh-q36u/row-qzw7~f493_6c7h 240069 649765 2019-05-23 2018-12-31 29           29 10             39
4173 4173 GARDEN CITY HOSPITAL 6245 INKSTER RD GARDEN CITY MI 48135 WAYNE (734) 421-3300 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.3323560 -83.3117710 0   163 26 26163 19820 Detroit-Warren-Ann Arbor, MI Central Wayne County https://data.medicare.gov/resource/xubh-q36u/row-5mn9~i8wr~ejcr 230244 648274 2019-05-23 2018-12-31 117 13         130   18           148
4229 4229 MAT-SU REGIONAL MEDICAL CENTER 2500 SOUTH WOODWORTH LOOP PALMER AK 99645 MATANUSKA-SUSITNA (907) 861-6000 Acute Care Hospitals Voluntary non-profit - Other TRUE 61.5612170 -149.2587180 0   170 2 2170 11260   Outlying Matanuska-Susitna Borough https://data.medicare.gov/resource/xubh-q36u/row-ehb8-yifz_k9ea 20006 648225 2019-05-23 2018-12-31 60 14         74               74
4234 4234 BUFFALO HOSPITAL 303 CATLIN ST BUFFALO MN 55313 WRIGHT (763) 682-1212 Acute Care Hospitals Voluntary non-profit - Other FALSE 45.1932000 -93.8705300 0   171 27 27171 33460 Minneapolis-St. Paul, MN-WI Central Wright County https://data.medicare.gov/resource/xubh-q36u/row-q8xg_3hph~s44a 240076 649768 2019-05-23 2018-12-31 44           44               44

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