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

42 rows where "filed_date" is on date 2019-06-06

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, county_name, hospital_type, hospital_ownership, emergency_services, countyfips, statefips, statecountyfips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, fy_end_date, icu_beds, coronary_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_beds, fy_end_date (date)

filed_date (date) ✖

  • 2019-06-06 · 42 ✖
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
50 50 KAISER FOUNDATION HOSPITAL - SAN LEANDRO 2500 MERCED STREET SAN LEANDRO CA 94577 ALAMEDA (510) 454-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.7065240 -122.1694470 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-tv6k~4ts3.26zc 50777 652239 2019-06-06 2018-12-31 166 20         206               206
53 53 KAISER FOUNDATION HOSPITAL - OAKLAND/RICHMOND 275 WEST MACARTHUR BOULEVARD OAKLAND CA 94611 ALAMEDA (510) 752-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.8238570 -122.2575890 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-s8y7~merd_qtct 50075 649024 2019-06-06 2018-12-31 291 50         365               365
54 54 KAISER FOUNDATION HOSPITAL - FREMONT 39400 PASEO PADRE PKWY FREMONT CA 94538 ALAMEDA (510) 784-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.5509130 -121.9757690 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-niun-nmuu_4jxw 50512 652223 2019-06-06 2018-12-31 96 10         106               106
157 157 KAISER FOUNDATION HOSPITAL 3288 MOANALUA RD HONOLULU HI 96819 HONOLULU (808) 432-0000 Acute Care Hospitals Voluntary non-profit - Private TRUE 21.3622920 -157.9001390 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-58ey-5yy7~4xmg 120011 652244 2019-06-06 2018-12-31 252 25         295               295
313 313 KAISER SUNNYSIDE MEDICAL CENTER 10180 SE SUNNYSIDE ROAD CLACKAMAS OR 97015 CLACKAMAS (503) 652-2880 Acute Care Hospitals Voluntary non-profit - Other TRUE 45.4334620 -122.5585250 0   5 41 41005 38900 Portland-Vancouver-Salem, OR-WA Central Clackamas County https://data.medicare.gov/resource/xubh-q36u/row-akhw.kvgz.wg78 380091 649818 2019-06-06 2018-12-31 242 40         302               302
586 586 KAISER FOUNDATION HOSPITAL - ANTIOCH 4501 SAND CREEK ROAD ANTIOCH CA 94531 CONTRA COSTA (925) 813-6500 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.9494690 -121.7748240 0   13 6 6013 41860 San Jose-San Francisco-Oakland, CA Outlying Contra Costa County https://data.medicare.gov/resource/xubh-q36u/row-dste.2hkn~zyrx 50760 652236 2019-06-06 2018-12-31 122 16         138               138
589 589 KAISER FOUNDATION HOSPITAL - WALNUT CREEK 1425 S MAIN STREET WALNUT CREEK CA 94596 CONTRA COSTA (925) 295-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.8915120 -122.0579430 0   13 6 6013 41860 San Jose-San Francisco-Oakland, CA Outlying Contra Costa County https://data.medicare.gov/resource/xubh-q36u/row-h639-6cb5.z9if 50072 649022 2019-06-06 2018-12-31 184 24         233               233
777 777 FORT HAMILTON HUGHES MEMORIAL HOSPITAL 630 EATON AVENUE HAMILTON OH 45013 BUTLER (513) 867-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.4151530 -84.5738220 0   17 39 39017 17140 Cincinnati-Wilmington-Maysville, OH-KY-IN Central Butler County https://data.medicare.gov/resource/xubh-q36u/row-hcbz.ytwa-mjfi 360132 650890 2019-06-06 2018-12-31 122 16         138 20             158
811 811 KAISER FOUNDATION HOSPITAL - FRESNO 7300 NORTH FRESNO ST FRESNO CA 93720 FRESNO (559) 448-4500 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.8427800 -119.7834360 0   19 6 6019 23420 Fresno-Madera, CA Central Fresno County https://data.medicare.gov/resource/xubh-q36u/row-ee6y~fgin_ze9b 50710 652232 2019-06-06 2018-12-31 145 12         169               169
1290 1290 GALLUP INDIAN MEDICAL CENTER 516 E NIZHONI BLVD GALLUP NM 87301 MCKINLEY (505) 722-1000 Acute Care Hospitals Government - Federal TRUE 35.5084440 -108.7302260 0   31 35 35031 23700   Central McKinley County https://data.medicare.gov/resource/xubh-q36u/row-6j78~q67u-hap6 320061 650186 2019-06-06 2018-09-30 74           74               74
1365 1365 KAISER PERMANENTE CENTRAL HOSPITAL 201 - 16TH AVENUE EAST SEATTLE WA 98112 KING (206) 326-3000 Acute Care Hospitals Voluntary non-profit - Other TRUE 47.6197310 -122.3114130 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-phdi-fixy.kk47 500052 649979 2019-06-06 2018-12-31 24           24               24
1497 1497 KAISER FOUNDATION HOSPITAL - BALDWIN PARK 1011 BALDWIN PARK BLVD BALDWIN PARK CA 91706 LOS ANGELES (626) 851-1011 Acute Care Hospitals Voluntary non-profit - Other FALSE 34.0646420 -117.9846460 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-wnj3~h69x-df8h 50723 652233 2019-06-06 2018-12-31 225 12         257               257
1500 1500 KAISER FOUNDATION HOSPITAL - WOODLAND HILLS 5601 DE SOTO AVENUE WOODLAND HILLS CA 91367 LOS ANGELES (818) 719-3800 Acute Care Hospitals Voluntary non-profit - Private FALSE 34.1718520 -118.5881830 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-ezxu_zdi4_3tgf 50677 652228 2019-06-06 2018-12-31 218 22         252               252
1504 1504 KAISER FOUNDATION HOSPITAL - LOS ANGELES 4867 SUNSET BLVD LOS ANGELES CA 90027 LOS ANGELES (323) 783-4011 Acute Care Hospitals Voluntary non-profit - Other FALSE 34.0981410 -118.2948250 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-jegr-tvwi-erqu 50138 649027 2019-06-06 2018-12-31 299 96 32       460 68             528
1511 1511 KAISER FOUNDATION HOSPITAL - WEST LA 6041 CADILLAC AVE LOS ANGELES CA 90034 LOS ANGELES (213) 857-2201 Acute Care Hospitals Voluntary non-profit - Private FALSE 34.0379900 -118.3762470 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-di5k.pxvz-gest 50561 652225 2019-06-06 2018-12-31 222 31         265               265
1528 1528 KAISER FOUNDATION HOSPITAL - PANORAMA CITY 13652 CANTARA ST PANORAMA CITY CA 91402 LOS ANGELES (818) 375-3333 Acute Care Hospitals Voluntary non-profit - Private FALSE 34.2198470 -118.4302990 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-mmjd~pjz4~s8rx 50137 649026 2019-06-06 2018-12-31 170 24         218               218
1529 1529 KAISER FOUNDATION HOSPITAL - DOWNEY 9333 IMPERIAL HIGHWAY DOWNEY CA 90242 LOS ANGELES (562) 461-6007 Acute Care Hospitals Voluntary non-profit - Other FALSE 33.9171010 -118.1289980 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-sg5x~3x2a.esq9 50139 652218 2019-06-06 2018-12-31 265 38         352               352
1531 1531 KAISER FOUNDATION HOSPITAL - SOUTH BAY 25825 SOUTH VERMONT AVENUE HARBOR CITY CA 90710 LOS ANGELES (310) 325-5111 Acute Care Hospitals Voluntary non-profit - Other FALSE 33.7886230 -118.2943660 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-schm-gstk~qa9r 50411 649028 2019-06-06 2018-12-31 227 20         257               257
1596 1596 ST FRANCIS MEMORIAL HOSPITAL 430 NORTH MONITOR ST WEST POINT NE 68788 CUMING (402) 372-2404 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.8429450 -96.7067630 0   39 31 31039         https://data.medicare.gov/resource/xubh-q36u/row-s2fi_ph9g_sbza 281322 650849 2019-06-06 2018-12-31 25           25               25
1634 1634 KAISER FOUNDATION HOSPITAL 99 MONTECILLO RD SAN RAFAEL CA 94903 MARIN (415) 444-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.0043350 -122.5538810 0   41 6 6041 41860 San Jose-San Francisco-Oakland, CA Central Marin County https://data.medicare.gov/resource/xubh-q36u/row-f2iv-6m47_zrmy 50510 649166 2019-06-06 2018-12-31 104 12         116               116
2083 2083 GREENE MEMORIAL HOSPITAL 1141 NORTH MONROE DRIVE XENIA OH 45385 GREENE (937) 352-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.7002880 -83.9287810 0   57 39 39057 19380 Dayton-Springfield-Sidney, OH Central Greene County https://data.medicare.gov/resource/xubh-q36u/row-j4yw-37x2~3jzu 360026 650885 2019-06-06 2018-12-31 41 8         49               49
2112 2112 KAISER FOUNDATION HOSPITAL - ORANGE COUNTY - ANAHE 3440 E LA PALMA AVE ANAHEIM CA 92806 ORANGE (714) 279-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.8544410 -117.8441100 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-s64m_nvmk-fqx3 50609 652227 2019-06-06 2018-12-31 398 60         484               484
2178 2178 KAISER FOUNDATION HOSPITAL - ROSEVILLE 1600 EUREKA ROAD ROSEVILLE CA 95661 PLACER (916) 784-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.7466980 -121.2471660 0   61 6 6061 40900 Sacramento-Roseville, CA Central Placer County https://data.medicare.gov/resource/xubh-q36u/row-egy3~g4id-36a5 50772 652238 2019-06-06 2018-12-31 262 30         340               340
2289 2289 KAISER FOUNDATION HOSPITAL-MORENO VALLEY 27300 IRIS AVENUE MORENO VALLEY CA 92555 RIVERSIDE (951) 251-6000 Acute Care Hospitals Voluntary non-profit - Other TRUE 33.8956970 -117.1871210 0   65 6 6065 40140 Los Angeles-Long Beach, CA Central Riverside County https://data.medicare.gov/resource/xubh-q36u/row-faca_qhzk-6j5h 50765 652237 2019-06-06 2018-12-31 84 10         94               94
2291 2291 KAISER FOUNDATION HOSPITAL, RIVERSIDE 10800 MAGNOLIA AVENUE RIVERSIDE CA 92505 RIVERSIDE (951) 353-2000 Acute Care Hospitals Voluntary non-profit - Other TRUE 33.9065050 -117.4707100 0   65 6 6065 40140 Los Angeles-Long Beach, CA Central Riverside County https://data.medicare.gov/resource/xubh-q36u/row-mhiq~8f2q.z8jj 50686 652229 2019-06-06 2018-12-31 185 22         226               226
2334 2334 KAISER FOUNDATION HOSP SO SACRAMENTO 6600 BRUCEVILLE ROAD SACRAMENTO CA 95823 SACRAMENTO (916) 688-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.4716470 -121.4238020 0   67 6 6067 40900 Sacramento-Roseville, CA Central Sacramento County https://data.medicare.gov/resource/xubh-q36u/row-esrt-dhxa.gvqe 50674 649867 2019-06-06 2018-12-31 179 30         209               209
2337 2337 KAISER FOUNDATION HOSPITAL - SACRAMENTO 2025 MORSE AVENUE SACRAMENTO CA 95825 SACRAMENTO (916) 973-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.6021620 -121.3922380 0   67 6 6067 40900 Sacramento-Roseville, CA Central Sacramento County https://data.medicare.gov/resource/xubh-q36u/row-4ihh-tck9.gw8q 50425 651176 2019-06-06 2018-12-31 253 34         287               287
2374 2374 KAISER FOUNDATION HOSPITAL - WESTSIDE 2875 NW STUCKI AVE HILLSBORO OR 97124 WASHINGTON (971) 310-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.5397130 -122.8756670 0   67 41 41067 38900 Portland-Vancouver-Salem, OR-WA Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-7pvy~zd9e_3y9d 380103 652265 2019-06-06 2018-12-31 102 20         122               122
2492 2492 CARILION GILES COMMUNITY HOSPITAL 159 HARTLEY WAY PEARISBURG VA 24134 GILES (540) 921-6000 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.3326970 -80.7107470 0   71 51 51071 13980   Outlying Giles County https://data.medicare.gov/resource/xubh-q36u/row-8vvr~xuju.78yz 491302 650917 2019-06-06 2018-09-30 25           25               25
2514 2514 KAISER FOUNDATION HOSPITAL - ZION 4647 ZION AVE SAN DIEGO CA 92120 SAN DIEGO (619) 528-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.7929730 -117.0958590 0   73 6 6073 41740   Central San Diego County https://data.medicare.gov/resource/xubh-q36u/row-fszp-7db9.eh86 50515 650804 2019-06-06 2018-12-31 475 32         536               536
2563 2563 KAISER FOUNDATION HOSPITAL - SAN FRANCISCO 2425 GEARY BLVD SAN FRANCISCO CA 94115 SAN FRANCISCO (415) 833-2646 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.7827780 -122.4432220 0   75 6 6075 41860 San Jose-San Francisco-Oakland, CA Central San Francisco County https://data.medicare.gov/resource/xubh-q36u/row-b2km~cfvy-msuz 50076 649025 2019-06-06 2018-12-31 185 32         239               239
2596 2596 KAISER FOUNDATION HOSPITAL MANTECA 1777 WEST YOSEMITE AVE MANTECA CA 95337 SAN JOAQUIN (209) 825-3700 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.7973710 -121.2461830 0   77 6 6077 44700 San Jose-San Francisco-Oakland, CA Central San Joaquin County https://data.medicare.gov/resource/xubh-q36u/row-bijj-mjic.y79k 50748 652235 2019-06-06 2018-12-31 163 26         213       38       251
2681 2681 KAISER FOUNDATION HOSPITAL - REDWOOD CITY 1100 VETERANS BOULEVARD REDWOOD CITY CA 94063 SAN MATEO (650) 299-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.4896930 -122.2246820 0   81 6 6081 41860 San Jose-San Francisco-Oakland, CA Central San Mateo County https://data.medicare.gov/resource/xubh-q36u/row-6avk.237w~4hyr 50541 652224 2019-06-06 2018-12-31 125 20         149               149
2682 2682 KAISER FOUNDATION HOSPITAL - SOUTH SAN FRANCISCO 1200 EL CAMINO REAL SOUTH SAN FRANCISCO CA 94080 SAN MATEO (650) 742-3200 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.6583760 -122.4392050 0   81 6 6081 41860 San Jose-San Francisco-Oakland, CA Central San Mateo County https://data.medicare.gov/resource/xubh-q36u/row-xnit-qvqd-47qm 50070 649020 2019-06-06 2018-12-31 105 15         120               120
2782 2782 KAISER FOUNDATION HOSPITAL-SANTA CLARA 700 LAWRENCE EXPRESSWAY SANTA CLARA CA 95051 SANTA CLARA (408) 236-6400 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.3354560 -121.9957670 0   85 6 6085 41940 San Jose-San Francisco-Oakland, CA Central Santa Clara County https://data.medicare.gov/resource/xubh-q36u/row-zbup-cmjk.by57 50071 649021 2019-06-06 2018-12-31 263 38         327               327
2784 2784 KAISER FOUNDATION HOSPITAL-SAN JOSE 250 HOSPITAL PARKWAY SAN JOSE CA 95119 SANTA CLARA (408) 972-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.2393270 -121.8020840 0   85 6 6085 41940 San Jose-San Francisco-Oakland, CA Central Santa Clara County https://data.medicare.gov/resource/xubh-q36u/row-djnw-z73y_t623 50604 652226 2019-06-06 2018-12-31 211 24         235               235
2917 2917 GOUVERNEUR HOSPITAL 77 WEST BARNEY STREET GOUVERNEUR NY 13642 ST. LAWRENCE (315) 287-1000 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.3382750 -75.4743710 0   89 36 36089 36300   Central St. Lawrence County https://data.medicare.gov/resource/xubh-q36u/row-c8ap~qijb~kszy 331315 651040 2019-06-06 2018-12-31 25           25               25
3023 3023 KAISER FOUNDATION HOSPITAL AND REHAB CENTER 975 SERENO DR VALLEJO CA 94589 SOLANO (707) 651-1000 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.1284370 -122.2475860 0   95 6 6095 46700 San Jose-San Francisco-Oakland, CA Central Solano County https://data.medicare.gov/resource/xubh-q36u/row-vsvw~srje_679k 50073 649023 2019-06-06 2018-12-31 160 40         200   48           248
3026 3026 KAISER FOUNDATION HOSPITAL - VACAVILLE 1 QUALITY DRIVE VACAVILLE CA 95688 SOLANO (707) 624-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.3900730 -121.9367760 0   95 6 6095 46700 San Jose-San Francisco-Oakland, CA Central Solano County https://data.medicare.gov/resource/xubh-q36u/row-iv5d~mht4.m24m 50767 649704 2019-06-06 2018-12-31 124 16         140               140
3083 3083 KAISER FOUNDATION HOSPITAL-SANTA ROSA 401 BICENTENNIAL WAY SANTA ROSA CA 95403 SONOMA (707) 571-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.4702170 -122.7243160 0   97 6 6097 42220 San Jose-San Francisco-Oakland, CA Central Sonoma County https://data.medicare.gov/resource/xubh-q36u/row-r3a7-uzvm_nnth 50690 652231 2019-06-06 2018-12-31 142 20         173               173
3484 3484 GRANDVIEW HOSPITAL & MEDICAL CENTER 405 GRAND AVENUE DAYTON OH 45405 MONTGOMERY (937) 723-3200 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.7689850 -84.2029980 0   113 39 39113 19380 Dayton-Springfield-Sidney, OH Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-6x7a_k7qq~hewg 360133 650891 2019-06-06 2018-12-31 252 35         287 17             304
4058 4058 SCHOOLCRAFT MEMORIAL HOSPITAL 7870W US HIGHWAY 2 MANISTIQUE MI 49854 SCHOOLCRAFT (906) 341-3200 Critical Access Hospitals Government - Local TRUE 45.9449630 -86.2757160 0   153 26 26153         https://data.medicare.gov/resource/xubh-q36u/row-i54k_s479.sfn4 231303 650833 2019-06-06 2018-12-31 12           12               12

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