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

38 rows where "filed_date" is on date 2019-12-02 and hospital_ownership = "Government - Hospital District or Authority"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, hospital_type, emergency_services, geocode_flag, geocode_accuracy, countyfips, statefips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, acute_beds, icu_beds, coronary_beds, surg_icu_beds, oth_spec_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_beds, oth_longterm_beds, filed_date (date), fy_end_date (date)

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
139 139 NORTHERN COCHISE COMMUNITY HOSPITAL, INC. 901 WEST REX ALLEN DRIVE WILLCOX AZ 85643 COCHISE (520) 384-3541 Critical Access Hospitals Government - Hospital District or Authority TRUE 32.2642680 -109.8376130 0   3 4 4003 43420   Central Cochise County https://data.medicare.gov/resource/xubh-q36u/row-ydad~45b6.8t7t 31302 660487 2019-12-02 2019-06-30 24           24       24       48
174 174 ALLEN PARISH HOSPITAL 108 6TH AVENUE KINDER LA 70648 ALLEN (337) 738-2527 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.4914530 -92.8556480 0   3 22 22003         https://data.medicare.gov/resource/xubh-q36u/row-572u~e5cv~bbuy 190133 659958 2019-12-02 2019-06-30 25           25 24             49
529 529 BAY AREA HOSPITAL 1775 THOMPSON ROAD COOS BAY OR 97420 COOS (541) 269-8124 Acute Care Hospitals Government - Hospital District or Authority TRUE 43.3858540 -124.2324630 0   11 41 41011 18300   Central Coos County https://data.medicare.gov/resource/xubh-q36u/row-nb96_ahiz~7tng 380090 662069 2019-12-02 2019-06-30 118 12         130               130
530 530 COQUILLE VALLEY HOSPITAL DISTRICT 940 EAST 5TH STREET COQUILLE OR 97423 COOS (541) 396-3101 Critical Access Hospitals Government - Hospital District or Authority TRUE 43.1789820 -124.1791430 0   11 41 41011 18300   Central Coos County https://data.medicare.gov/resource/xubh-q36u/row-qh6s~rn9z.ntit 381312 660287 2019-12-02 2019-06-30 17           17               17
995 995 PIONEERS MEMORIAL HEALTHCARE DISTRICT 207 WEST LEGION ROAD BRAWLEY CA 92227 IMPERIAL (760) 351-3333 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.9599470 -115.5527230 0   25 6 6025 20940   Central Imperial County https://data.medicare.gov/resource/xubh-q36u/row-9jqy.yukk~78kt 50342 662026 2019-12-02 2019-06-30 99 8         107               107
1061 1061 NORTHERN INYO HOSPITAL 150 PIONEER LANE BISHOP CA 93514 INYO (760) 873-5811 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.3621080 -118.4073620 0   27 6 6027         https://data.medicare.gov/resource/xubh-q36u/row-mi4n-bdvc~nrpd 51324 661291 2019-12-02 2019-06-30 21 4         25               25
1062 1062 SOUTHERN INYO HOSPITAL 501 EAST LOCUST STREET LONE PINE CA 93545 INYO (760) 876-5501 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.6083740 -118.0581590 0   27 6 6027         https://data.medicare.gov/resource/xubh-q36u/row-wcp4_jkw5.du53 51302 659919 2019-12-02 2019-06-30 4           4       33       37
1099 1099 NORMAN REGIONAL 901 N PORTER NORMAN OK 73070 CLEVELAND (405) 307-1050 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.2302570 -97.4411170 0   27 40 40027 36420 Oklahoma City-Shawnee, OK Central Cleveland County https://data.medicare.gov/resource/xubh-q36u/row-z4m8-r75w.my3r 370008 660139 2019-12-02 2019-06-30 254 52 25       331 20 30           381
1127 1127 KERN MEDICAL CENTER 1700 MOUNT VERNON AVENUE BAKERSFIELD CA 93306 KERN (661) 326-2000 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.3809640 -118.9675460 0   29 6 6029 12540   Central Kern County https://data.medicare.gov/resource/xubh-q36u/row-jv3w_f89d_ies4 50315 662025 2019-12-02 2019-06-30 182 12       28 222               222
1283 1283 INCLINE VILLAGE HEALTH CENTER 880 ALDER STREET INCLINE VILLAGE NV 89451 WASHOE (775) 833-4100 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.2509450 -119.9538610 0   31 32 32031 39900 Reno-Carson City-Fernley, NV Central Washoe County https://data.medicare.gov/resource/xubh-q36u/row-xavt.4jau_b7jd 291301 660260 2019-12-02 2019-06-30 4           4               4
1297 1297 COMANCHE COUNTY MEMORIAL HOSPITAL 3401 WEST GORE BLVD LAWTON OK 73505 COMANCHE (580) 355-8620 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.6089690 -98.4344970 0   31 40 40031 30020   Central Comanche County https://data.medicare.gov/resource/xubh-q36u/row-wn8v~6wq8.gvxz 370056 660281 2019-12-02 2019-06-30 128 20 39       187 12 30           229
1520 1520 ANTELOPE VALLEY HOSPITAL 1600 W AVE J LANCASTER CA 93534 LOS ANGELES (661) 949-5000 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.6893710 -118.1584760 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-jtig~5whv~hgpp 50056 660914 2019-12-02 2019-06-30 345 21         393               393
1569 1569 METRO NASHVILLE GENERAL HOSPITAL 1818 ALBION STREET NASHVILLE TN 37208 DAVIDSON (615) 341-4490 Acute Care Hospitals Government - Hospital District or Authority TRUE 36.1661350 -86.8063270 0   37 47 47037 34980 Nashville-Davidson--Murfreesboro, TN Central Davidson County https://data.medicare.gov/resource/xubh-q36u/row-a69p-t6hu-kymt 440111 661105 2019-12-02 2019-06-30 82 22         114               114
1682 1682 JOHN C FREMONT HEALTHCARE DISTRICT 5189 HOSPITAL ROAD MARIPOSA CA 95338 MARIPOSA (209) 966-3631 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.5005310 -119.9769480 0   43 6 6043         https://data.medicare.gov/resource/xubh-q36u/row-fty8~tgqe.f5tj 51304 661465 2019-12-02 2019-06-30 18           18       16   1   35
1725 1725 MENDOCINO COAST DISTRICT HOSPITAL 700 RIVER DR FORT BRAGG CA 95437 MENDOCINO (707) 961-1234 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.4326130 -123.8007970 0   45 6 6045 46380   Central Mendocino County https://data.medicare.gov/resource/xubh-q36u/row-rw6t.w3x2~jyq9 51325 661292 2019-12-02 2019-06-30 21 4         25               25
1794 1794 GOTHENBURG MEMORIAL HOSPITAL 910 20TH ST GOTHENBURG NE 69138 DAWSON (308) 537-3661 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.9381320 -100.1533520 0   47 31 31047 30420   Central Dawson County https://data.medicare.gov/resource/xubh-q36u/row-dgzd-a44k.k83g 281313 661037 2019-12-02 2019-06-30 12           12               12
1872 1872 LECOM HEALTH CORRY MEMORIAL HOSPITAL 965 SHAMROCK LANE CORRY PA 16407 ERIE (814) 664-4641 Critical Access Hospitals Government - Hospital District or Authority TRUE 41.9353790 -79.6128910 0   49 42 42049 21500 Erie-Meadville, PA Central Erie County https://data.medicare.gov/resource/xubh-q36u/row-pwex-5ih7_humz 391308 660305 2019-12-02 2019-06-30 20           20               20
2085 2085 HARMON MEMORIAL HOSPITAL 400 EAST CHESTNUT STREET HOLLIS OK 73550 HARMON (580) 688-3363 Critical Access Hospitals Government - Hospital District or Authority TRUE 34.6915370 -99.9143660 0   57 40 40057         https://data.medicare.gov/resource/xubh-q36u/row-uie3-brwx.iwxd 371338 661083 2019-12-02 2019-06-30 22           22               22
2287 2287 SAN GORGONIO MEMORIAL HOSPITAL 600 NORTH HIGHLAND SPRINGS AVENUE BANNING CA 92220 RIVERSIDE (951) 845-1121 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.9316874 -116.9461472 1 ROOFTOP 65 6 6065 40140 Los Angeles-Long Beach, CA Central Riverside County https://data.medicare.gov/resource/xubh-q36u/row-v72w~xz4e~mtkk 50054 660165 2019-12-02 2019-06-30 55 6         61               61
2312 2312 ROUNDUP MEMORIAL HEALTHCARE 1202 3RD ST W ROUNDUP MT 59072 MUSSELSHELL (406) 323-2301 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.4533500 -108.5463330 0   65 30 30065         https://data.medicare.gov/resource/xubh-q36u/row-4hiv-3ibs~jee7 271346 661357 2019-12-02 2019-06-30 25           25               25
2386 2386 HAZEL HAWKINS MEMORIAL HOSPITAL 911 SUNSET DRIVE HOLLISTER CA 95023 SAN BENITO (831) 637-5711 Acute Care Hospitals Government - Hospital District or Authority FALSE 36.8351220 -121.3866200 0   69 6 6069 41940 San Jose-San Francisco-Oakland, CA Outlying San Benito County https://data.medicare.gov/resource/xubh-q36u/row-z5mt_ehjz~v7xh 50296 661288 2019-12-02 2019-06-30 41 8         49       119       168
2506 2506 PALOMAR HEALTH DOWNTOWN CAMPUS 555 EAST VALLEY PARKWAY ESCONDIDO CA 92025 SAN DIEGO (760) 739-3000 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.1259370 -117.0761860 0   73 6 6073 41740   Central San Diego County https://data.medicare.gov/resource/xubh-q36u/row-75ug~bcqe_4ycp 50115 660353 2019-12-02 2019-06-30 238 48         286 25 18           329
2518 2518 POMERADO HOSPITAL 15615 POMERADO ROAD POWAY CA 92064 SAN DIEGO (858) 485-6511 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.9968020 -117.0578520 0   73 6 6073 41740   Central San Diego County https://data.medicare.gov/resource/xubh-q36u/row-4898.b6y5.nvpq 50636 660919 2019-12-02 2019-06-30 79 12       4 95 12     129       236
2519 2519 TRI-CITY MEDICAL CENTER 4002 VISTA WAY OCEANSIDE CA 92056 SAN DIEGO (760) 724-8411 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.1837830 -117.2909180 0   73 6 6073 41740   Central San Diego County https://data.medicare.gov/resource/xubh-q36u/row-hngp~yjnr~dx2a 50128 662018 2019-12-02 2019-06-30 242 28       20 290 5 10           305
2652 2652 PRAIRIE COMMUNITY HOSPITAL 312 S ADAMS TERRY MT 59349 PRAIRIE (406) 635-5511 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.7915060 -105.3159970 0   79 30 30079         https://data.medicare.gov/resource/xubh-q36u/row-cwxm-q75h-madz 271309 660253 2019-12-02 2019-06-30 22           22               22
2667 2667 HENRY COUNTY MEDICAL CENTER 301 TYSON AV PARIS TN 38242 HENRY (731) 642-1220 Acute Care Hospitals Government - Hospital District or Authority TRUE 36.2968020 -88.3112710 0   79 47 47079 37540   Central Henry County https://data.medicare.gov/resource/xubh-q36u/row-ru8t~pc2a_mnkm 440132 661107 2019-12-02 2019-06-30 55   9       64 22             86
2732 2732 ATHENS LIMESTONE HOSPITAL 700 WEST MARKET STREET ATHENS AL 35611 LIMESTONE (256) 233-9292 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.8034990 -86.9778030 0   83 1 1083 26620 Huntsville-Decatur-Albertville, AL Outlying Limestone County https://data.medicare.gov/resource/xubh-q36u/row-nzdh.hdic_txkm 10079 660159 2019-12-02 2019-06-30 56 10         66               66
2738 2738 LOMPOC VALLEY MEDICAL CENTER 1515 E OCEAN AVENUE LOMPOC CA 93436 SANTA BARBARA (805) 737-3300 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.6406390 -120.4398990 0   83 6 6083 42200   Central Santa Barbara County https://data.medicare.gov/resource/xubh-q36u/row-9waa-2p9w-xqwe 50110 660915 2019-12-02 2019-06-30 54 6         60       110       170
2879 2879 HUNTSVILLE HOSPITAL 101 SIVLEY RD HUNTSVILLE AL 35801 MADISON (256) 265-1000 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.7212260 -86.5815470 0   89 1 1089 26620 Huntsville-Decatur-Albertville, AL Central Madison County https://data.medicare.gov/resource/xubh-q36u/row-srfb_s9fq-erqf 10039 660063 2019-12-02 2019-06-30 713 42 20   25   877 35             912
2888 2888 EMORY HILLANDALE HOSPITAL 2801 DEKALB MEDICAL PARKWAY LITHONIA GA 30058 DE KALB (404) 501-8040 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.7054880 -84.1469270 0   89 13 13089 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central DeKalb County https://data.medicare.gov/resource/xubh-q36u/row-mkqk.2abm~442s 110226 660924 2019-12-02 2019-06-30 82 8         90               90
3078 3078 SONOMA VALLEY HOSPITAL 347 ANDRIEUX ST SONOMA CA 95476 SONOMA (707) 935-5000 Acute Care Hospitals Government - Hospital District or Authority TRUE 38.2885640 -122.4658500 0   97 6 6097 42220 San Jose-San Francisco-Oakland, CA Central Sonoma County https://data.medicare.gov/resource/xubh-q36u/row-qdpm~37ez~79pv 50090 662015 2019-12-02 2019-06-30 42 6         48       27       75
3126 3126 MUENSTER MEMORIAL HOSPITAL 605 N MAPLE STREET MUENSTER TX 76252 COOKE (940) 759-2271 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.6538650 -97.3798350 0   97 48 48097 23620 Dallas-Fort Worth, TX-OK Central Cooke County https://data.medicare.gov/resource/xubh-q36u/row-tkmv_gjc7.fa5r 451335 660475 2019-12-02 2019-06-30 18           18               18
3137 3137 OAK VALLEY HOSPITAL DISTRICT 350 S OAK AVE OAKDALE CA 95361 STANISLAUS (209) 847-3011 Acute Care Hospitals Government - Hospital District or Authority TRUE 37.7580980 -120.8603630 0   99 6 6099 33700 Modesto-Merced, CA Central Stanislaus County https://data.medicare.gov/resource/xubh-q36u/row-ehek_q3if-kskp 50067 660166 2019-12-02 2019-06-30 30 5         35       115       150
3844 3844 EASTLAND MEMORIAL HOSPITAL 304 S DAUGHERTY EASTLAND TX 76448 EASTLAND (254) 629-2601 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.4004390 -98.8216360 0   133 48 48133         https://data.medicare.gov/resource/xubh-q36u/row-uts8~dkzz-h488 450411 660325 2019-12-02 2019-06-30 36           36               36
3859 3859 PERKINS COUNTY HEALTH SERVICES 900 LINCOLN AVE GRANT NE 69140 PERKINS (308) 352-7200 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.8482680 -101.7271820 0   135 31 31135         https://data.medicare.gov/resource/xubh-q36u/row-g4pp~ymgi-thrv 281356 661045 2019-12-02 2019-06-30 20           20           50   70
3943 3943 HIGGINS GENERAL HOSPITAL 200 ALLEN MEMORIAL DRIVE BREMEN GA 30110 HARALSON (770) 812-2000 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.7163430 -85.1446230 0   143 13 13143 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Outlying Haralson County https://data.medicare.gov/resource/xubh-q36u/row-rd44_uqxz.t5yc 111320 660206 2019-12-02 2019-06-30 15           15               15
4256 4256 PENDER COMMUNITY HOSPITAL P O BOX 100, 100 HOSPITAL DRIVE PENDER NE 68047 THURSTON (402) 385-3083 Critical Access Hospitals Government - Hospital District or Authority TRUE 42.1055877 -96.7110334 1 ROOFTOP 173 31 31173         https://data.medicare.gov/resource/xubh-q36u/row-iane_yp36_h5j2 281349 661213 2019-12-02 2019-06-30 21           21               21
4564 4564 WAYNE MEMORIAL HOSPITAL 865 SOUTH FIRST STREET JESUP GA 31545 WAYNE (912) 530-3302 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.6029520 -81.8990940 0   305 13 13305 27700   Central Wayne County https://data.medicare.gov/resource/xubh-q36u/row-de2e.7sgx-hidy 110124 660369 2019-12-02 2019-06-30 76 12         88               88

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