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

21 rows where "filed_date" is on date 2019-12-02 and hospital_ownership = "Proprietary"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, county_name, hospital_type, emergency_services, geocode_flag, geocode_accuracy, countyfips, statefips, statecountyfips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, acute_beds, icu_beds, coronary_beds, subtotal_acute_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_beds, all_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
348 348 SHANDS STARKE REGIONAL MEDICAL CENTER 922 E CALL ST STARKE FL 32091 BRADFORD (904) 368-2300 Critical Access Hospitals Proprietary TRUE 29.9419070 -82.1016500 0   7 12 12007         https://data.medicare.gov/resource/xubh-q36u/row-463i.u2z5-p3cq 101310 660199 2019-12-02 2019-06-30 25           25               25
744 744 RUMFORD HOSPITAL 420 FRANKLIN STREET RUMFORD ME 4276 OXFORD (207) 369-1000 Critical Access Hospitals Proprietary TRUE 44.5517210 -70.5571710 0   17 23 23017         https://data.medicare.gov/resource/xubh-q36u/row-923a_kexq.nxfx 201306 662536 2019-12-02 2019-06-30 25           25               25
926 926 CONEMAUGH MINERS MEDICAL CENTER 290 HAIDA AVENUE HASTINGS PA 16646 CAMBRIA (814) 247-3100 Acute Care Hospitals Proprietary TRUE 40.6589130 -78.7057990 0   21 42 42021 27780 Johnstown-Somerset, PA Central Cambria County https://data.medicare.gov/resource/xubh-q36u/row-atm6_mxu4.8ec2 390130 660860 2019-12-02 2019-06-30 25 5         30               30
944 944 MAD RIVER COMMUNITY HOSPITAL 3800 JANES RD ARCATA CA 95521 HUMBOLDT (707) 822-3621 Acute Care Hospitals Proprietary TRUE 40.9033090 -124.0908470 0   23 6 6023 21700   Central Humboldt County https://data.medicare.gov/resource/xubh-q36u/row-qduv~9itb_454t 50028 661454 2019-12-02 2019-06-30 41 8         49               49
1001 1001 REDINGTON FAIRVIEW GENERAL HOSPITAL 46 FAIRVIEW AVE PO BOX 468 SKOWHEGAN ME 4976 SOMERSET (207) 474-5121 Critical Access Hospitals Proprietary TRUE 44.7583360 -69.7134950 0   25 23 23025         https://data.medicare.gov/resource/xubh-q36u/row-g9mx~aw3n.5hnn 201314 661526 2019-12-02 2019-06-30 21 4         25               25
1517 1517 SAN GABRIEL VALLEY MEDICAL CENTER 438 W LAS TUNAS DRIVE SAN GABRIEL CA 91776 LOS ANGELES (626) 289-5454 Acute Care Hospitals Proprietary TRUE 34.1024610 -118.1055720 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-vsyy.e66v~akjm 50132 660490 2019-12-02 2019-06-30 156 19         187 42     44       273
1518 1518 ALHAMBRA HOSPITAL MEDICAL CENTER 100 S RAYMOND AVE ALHAMBRA CA 91801 LOS ANGELES (626) 570-1606 Acute Care Hospitals Proprietary FALSE 34.0901560 -118.1450170 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-75jx-8uav_n2er 50281 660918 2019-12-02 2019-06-30 88 13         101   17   26       144
1665 1665 CARLISLE REGIONAL MEDICAL CENTER 361 ALEXANDER SPRING ROAD CARLISLE PA 17015 CUMBERLAND (717) 249-1212 Acute Care Hospitals Proprietary TRUE 40.1847670 -77.2230070 0   41 42 42041 25420 Harrisburg-York-Lebanon, PA Central Cumberland County https://data.medicare.gov/resource/xubh-q36u/row-6ch7-p7nq-3tnd 390058 661966 2019-12-02 2019-06-30 56 10         66   14           80
1686 1686 ELMHURST MEMORIAL HOSPITAL 155 EAST BRUSH HILL ROAD ELMHURST IL 60126 DU PAGE (331) 221-0130 Acute Care Hospitals Proprietary TRUE 41.8616840 -87.9342950 0   43 17 17043 16980 Chicago-Naperville, IL-IN-WI Central DuPage County https://data.medicare.gov/resource/xubh-q36u/row-bbi9~mwsc~myn8 140200 661499 2019-12-02 2019-06-30 247 35         282               282
1772 1772 VAUGHAN REGIONAL MEDICAL CENTER PARKWAY CAMPUS 1015 MEDICAL CENTER PARKWAY SELMA AL 36701 DALLAS (334) 418-4100 Acute Care Hospitals Proprietary TRUE 32.4302480 -87.0551740 0   47 1 1047 42820   Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-yhen~7fx5~f9rk 10118 660350 2019-12-02 2019-06-30 86 23         109               109
2043 2043 BLUEFIELD REGIONAL MEDICAL CENTER 500 CHERRY ST BLUEFIELD WV 24701 MERCER (304) 327-1100 Acute Care Hospitals Proprietary TRUE 37.2575170 -81.2341290 0   55 54 54055 14140   Central Mercer County https://data.medicare.gov/resource/xubh-q36u/row-kbzt.t9ci.vaxk 510071 660728 2019-12-02 2019-06-30 40 17         57               57
2459 2459 HIGHLANDS REGIONAL MEDICAL CENTER 5000 KENTUCKY ROUTE 321 PRESTONSBURG KY 41653 FLOYD (606) 886-8511 Acute Care Hospitals Proprietary TRUE 37.7105400 -82.7702500 0   71 21 21071         https://data.medicare.gov/resource/xubh-q36u/row-iny2.6yju.g3qs 180005 662526 2019-12-02 2019-06-30 115 12         127 23             150
2486 2486 UPMC LITITZ 1500 HIGHLANDS DRIVE LITITZ PA 17543 LANCASTER (717) 625-5670 Acute Care Hospitals Proprietary TRUE 40.1342570 -76.3094140 0   71 42 42071 29540   Central Lancaster County https://data.medicare.gov/resource/xubh-q36u/row-i9xj_phxc~h3r8 390068 661396 2019-12-02 2019-06-30 45 6         55               55
2589 2589 NORTH ALABAMA MEDICAL CENTER 1701 VETERANS DRIVE FLORENCE AL 35630 LAUDERDALE (256) 768-8400 Acute Care Hospitals Proprietary TRUE 34.8027560 -87.6521910 0   77 1 1077 22520   Central Lauderdale County https://data.medicare.gov/resource/xubh-q36u/row-n9pr_q6au_cg3t 10006 660158 2019-12-02 2019-06-30 181 36 16       233               233
2973 2973 VALLEY FORGE MEDICAL CENTER AND HOSPITAL 1033 W GERMANTOWN PIKE NORRISTOWN PA 19401 MONTGOMERY (215) 539-8500 Acute Care Hospitals Proprietary FALSE 40.1564300 -75.3686840 0   91 42 42091 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-wedb-6d72.5wef 390272 661256 2019-12-02 2019-06-30 50           50               50
3096 3096 MIDWESTERN REGION MED CENTER 2520 ELISHA AVENUE ZION IL 60099 LAKE (847) 872-4561 Acute Care Hospitals Proprietary TRUE 42.4489700 -87.8268400 0   97 17 17097 16980 Chicago-Naperville, IL-IN-WI Central Lake County https://data.medicare.gov/resource/xubh-q36u/row-wjcc_h9y8~99z6 140100 661493 2019-12-02 2019-06-30 49 24         73               73
3628 3628 SHANDS LIVE OAK REGIONAL MEDICAL CENTER 1100 SW 11TH ST LIVE OAK FL 32060 SUWANNEE (904) 362-1413 Critical Access Hospitals Proprietary TRUE 30.2917367 -83.0028124 1 ROOFTOP 121 12 12121         https://data.medicare.gov/resource/xubh-q36u/row-keij_wts9-t8jc 101301 660198 2019-12-02 2019-06-30 25           25               25
3834 3834 PAWNEE COUNTY MEMORIAL HOSPITAL P O BOX 433, 600 I ST PAWNEE CITY NE 68420 PAWNEE (402) 852-2231 Critical Access Hospitals Proprietary TRUE 40.1098396 -96.1532422 1 ROOFTOP 133 31 31133         https://data.medicare.gov/resource/xubh-q36u/row-2ahw-y3eh_6phq 281302 661036 2019-12-02 2019-06-30 17           17               17
3961 3961 SOUTHWESTERN REGIONAL MEDICAL CENTER, INC 10109 EAST 79TH STREET TULSA OK 74133 TULSA (918) 286-5000 Acute Care Hospitals Proprietary TRUE 36.0463390 -95.8642110 0   143 40 40143 46140 Tulsa-Muskogee-Bartlesville, OK Central Tulsa County https://data.medicare.gov/resource/xubh-q36u/row-34zt~qq9g_7fzk 370190 661242 2019-12-02 2019-06-30 27 13         40               40
4349 4349 ST LUKE'S DES PERES HOSPITAL 2345 DOUGHERTY FERRY ROAD SAINT LOUIS MO 63122 ST. LOUIS (314) 966-9100 Acute Care Hospitals Proprietary TRUE 38.5810810 -90.4504080 0   189 29 29189 41180 St. Louis-St. Charles-Farmington, MO-IL Central St. Louis County https://data.medicare.gov/resource/xubh-q36u/row-5nye-gh7e~2ki5 260176 660117 2019-12-02 2019-06-30 78 10         88               88
4541 4541 MEADOWS REGIONAL MEDICAL CENTER ONE MEADOWS PARKWAY VIDALIA GA 30474 TOOMBS (912) 535-5828 Acute Care Hospitals Proprietary TRUE 32.2071314 -82.3777520 1 GEOMETRIC_CENTER 279 13 13279 47080   Central Toombs County https://data.medicare.gov/resource/xubh-q36u/row-ifps.um7x~mbjr 110128 659939 2019-12-02 2019-06-30 44 8         52               52

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