COVID-19 Hospital Needs in Spain, Germany and Italy

Hospital Needs cause of coronavirus pandemic and Death Projections at Germany, Italy and Spain

This dataset can be accessed in the following ways

SQL Query copied to clipboard

SELECT covid19_ihme_forecast_by_location.admis_lower AS admis_lower, covid19_ihme_forecast_by_location.admis_mean AS admis_mean, covid19_ihme_forecast_by_location.admis_upper AS admis_upper, covid19_ihme_forecast_by_location.allbed_lower AS allbed_lower, covid19_ihme_forecast_by_location.allbed_mean AS allbed_mean, covid19_ihme_forecast_by_location.allbed_upper AS allbed_upper, covid19_ihme_forecast_by_location.bedover_lower AS bedover_lower, covid19_ihme_forecast_by_location.bedover_mean AS bedover_mean, covid19_ihme_forecast_by_location.bedover_upper AS bedover_upper, covid19_ihme_forecast_by_location.confirmed_infections AS confirmed_infections, covid19_ihme_forecast_by_location.date AS date, covid19_ihme_forecast_by_location.deaths_lower AS deaths_lower, covid19_ihme_forecast_by_location.deaths_lower_smoothed AS deaths_lower_smoothed, covid19_ihme_forecast_by_location.deaths_mean AS deaths_mean, covid19_ihme_forecast_by_location.deaths_mean_smoothed AS deaths_mean_smoothed, covid19_ihme_forecast_by_location.deaths_upper AS deaths_upper, covid19_ihme_forecast_by_location.deaths_upper_smoothed AS deaths_upper_smoothed, covid19_ihme_forecast_by_location.est_infections_lower AS est_infections_lower, covid19_ihme_forecast_by_location.est_infections_mean AS est_infections_mean, covid19_ihme_forecast_by_location.est_infections_upper AS est_infections_upper, covid19_ihme_forecast_by_location.icubed_lower AS icubed_lower, covid19_ihme_forecast_by_location.icubed_mean AS icubed_mean, covid19_ihme_forecast_by_location.icubed_upper AS icubed_upper, covid19_ihme_forecast_by_location.icuover_lower AS icuover_lower, covid19_ihme_forecast_by_location.icuover_mean AS icuover_mean, covid19_ihme_forecast_by_location.icuover_upper AS icuover_upper, covid19_ihme_forecast_by_location.id AS id, covid19_ihme_forecast_by_location.invven_lower AS invven_lower, covid19_ihme_forecast_by_location.invven_mean AS invven_mean, covid19_ihme_forecast_by_location.invven_upper AS invven_upper, covid19_ihme_forecast_by_location.mobility_composite AS mobility_composite, covid19_ihme_forecast_by_location.mobility_data_type AS mobility_data_type, covid19_ihme_forecast_by_location.newicu_lower AS newicu_lower, covid19_ihme_forecast_by_location.newicu_mean AS newicu_mean, covid19_ihme_forecast_by_location.newicu_upper AS newicu_upper, covid19_ihme_forecast_by_location.region AS region, covid19_ihme_forecast_by_location.total_tests AS total_tests, covid19_ihme_forecast_by_location.total_tests_data_type AS total_tests_data_type, covid19_ihme_forecast_by_location.totdea_lower AS totdea_lower, covid19_ihme_forecast_by_location.totdea_lower_smoothed AS totdea_lower_smoothed, covid19_ihme_forecast_by_location.totdea_mean AS totdea_mean, covid19_ihme_forecast_by_location.totdea_mean_smoothed AS totdea_mean_smoothed, covid19_ihme_forecast_by_location.totdea_upper AS totdea_upper, covid19_ihme_forecast_by_location.totdea_upper_smoothed AS totdea_upper_smoothed FROM covid19_ihme_forecast_by_location

REST API copied to clipboard

https://dataport.open.denodo.com/server/covid_19_data/rws_covid19_cases_global_data_sets/views/covid19_ihme_forecast_by_location?%24count=25

Help with accessing the COVID-19 data in JDBC / REST / JSON / XML

Information about intensive care beds, and ventilator use needy and Death Projections at Germany, Italy and Spain and subnational level by Institute for Health Metrics and Evaluation.

iddateregionallbed_meanallbed_lowerallbed_uppericubed_meanicubed_lowericubed_upperinvven_meaninvven_lowerinvven_upperdeaths_meandeaths_lowerdeaths_upperadmis_meanadmis_loweradmis_uppernewicu_meannewicu_lowernewicu_uppertotdea_meantotdea_lowertotdea_upperbedover_meanbedover_lowerbedover_uppericuover_meanicuover_lowericuover_upperdeaths_mean_smootheddeaths_lower_smootheddeaths_upper_smoothedtotdea_mean_smoothedtotdea_lower_smoothedtotdea_upper_smoothedmobility_data_typemobility_compositetotal_tests_data_typetotal_testsconfirmed_infectionsest_infections_meanest_infections_lowerest_infections_upper
2020-02-047579.75982957667579.75982957667579.75982957661285.69232390371285.69232390371285.69232390371182.24998421941182.24998421941182.2499842194103103103579.69425350455579.69425350455579.69425350455221.46504272787221.46504272787221.465042727877937937937579.75982957667579.75982957667579.75982957661285.69232390371285.69232390371285.6923239037125.29139501025300000000125.29139501025300000000125.29139501025300000000719.88664819646800000000719.88664819646800000000719.88664819646800000000225.809636342077000000004966.0000000000000000000020978.9270253808000000000017592.7748797415000000000025100.38432658080000000000
2020-02-058238.18113186348238.18113186348238.18113186341379.78128554681379.78128554681379.78128554681261.74673018691261.74673018691261.7467301869111111111583.83502663202583.83502663202583.83502663202225.59332168206225.59332168206225.593321682069049049048238.18113186348238.18113186348238.18113186341379.78128554681379.78128554681379.7812855468136.37743079774600000000136.37743079774600000000136.37743079774600000000856.26407899421400000000856.26407899421400000000856.26407899421400000000246.372536855931000000004749.0000000000000000000020219.0452444161000000000017011.6756300853000000000024087.46123647990000000000
2020-02-068841.5652981328841.5652981328841.5652981321462.081775791462.081775791462.081775791329.50343576611329.50343576611329.5034357661110110110582.06243113428582.06243113428582.06243113428227.20505863009227.20505863009227.205058630091014101410148841.5652981328841.5652981328841.5652981321462.081775791462.081775791462.08177579145.59270803786500000000145.59270803786500000000145.592708037865000000001001.856787032080000000001001.856787032080000000001001.85678703208000000000267.169526915427000000003921.0000000000000000000019481.2378703231000000000016360.0046428517000000000023030.46713103310000000000
2020-02-079381.23321589029381.23321589029381.23321589021531.60199224081531.60199224081531.60199224081384.91423404311384.91423404311384.9142340431130130130575.42584508238575.42584508239575.42584508239226.61648874389226.61648874389226.616488743891144114411449381.23321589029381.23321589029381.23321589021531.60199224081531.60199224081531.6019922408152.77192582164200000000152.77192582164200000000152.771925821642000000001154.628712853720000000001154.628712853720000000001154.62871285372000000000288.459593726081000000004495.0000000000100000000018783.9427594787000000000015767.0990789490000000000022156.71779735940000000000
2020-02-089846.54110057929846.54110057929846.54110057921588.01260045751588.01260045751588.01260045751427.98678889971427.98678889971427.9867888997131131131565.01783435056565.01783435056565.01783435056224.20342096362224.20342096362224.203420963621275127512759846.54110057929846.54110057929846.54110057921588.01260045751588.01260045751588.0126004575157.83603262200700000000157.83603262200700000000157.836032622007000000001312.464745475730000000001312.464745475730000000001312.46474547573000000000-22.79658735529810000000309.599454223859000000003405.9999999999900000000018133.2412874468000000000015222.5498991402000000000021401.25879922530000000000
2020-02-0910233.63817728210233.63817728210233.6381772821631.37950003751631.37950003751631.37950003751459.12027429011459.12027429011459.1202742901148148148551.95782268646551.95782268646551.95782268646220.36823732408220.36823732408220.3682373240814231423142310233.63817728210233.63817728210233.6381772821631.37950003751631.37950003751631.3795000375160.84352771862300000000160.84352771862300000000160.843527718623000000001473.308273194350000000001473.308273194350000000001473.30827319435000000000-22.96169388098670000000330.747712935869000000003954.0000000000000000000017527.1645525438000000000014772.6952115417000000000020650.62532144090000000000
2020-02-1010535.96588142810535.96588142810535.9658814281661.88182767491661.88182767491661.88182767491478.84026310271478.84026310271478.8402631027164164164536.97771911407536.97771911407536.97771911407215.45542857704215.45542857704215.4554285770415871587158710535.96588142810535.96588142810535.9658814281661.88182767491661.88182767491661.8818276749161.96905235000900000000161.96905235000900000000161.969052350009000000001635.277325544360000000001635.277325544360000000001635.27732554436000000000-22.99435368808680000000351.893049072363000000003294.9999999999900000000017131.7252093632000000000014597.7479136664000000000019962.59510000370000000000
2020-02-1110751.84698028210751.84698028210751.8469802821680.37963409161680.37963409161680.37963409161488.18739276421488.18739276421488.1873927642152152152520.84609010869520.84609010869520.84609010869209.79409740443209.79409740443209.7940974044317391739173910751.84698028210751.84698028210751.8469802821680.37963409161680.37963409161680.3796340916161.45713374305800000000161.45713374305800000000161.457133743058000000001796.734459287420000000001796.734459287420000000001796.73445928742000000000-22.49622179637070000000373.144351656143000000002592.0000000000100000000016930.7107128673000000000014733.1356269994000000000019525.54033035910000000000
2020-02-1210886.52307383910886.52307383910886.5230738391687.36058938291687.36058938291687.36058938291487.89376033641487.89376033641487.8937603364222504.00415469309504.00415469309504.00415469309203.63704608438203.63704608438203.6370460843817411741174110886.52307383910886.52307383910886.5230738391687.36058938291687.36058938291687.3605893829159.60108640106900000000159.60108640106800000000159.601086401068000000001956.335545688490000000001956.335545688490000000001956.33554568849000000000-22.62602639259800000000394.65839065247300000000134.0000000000000000000016962.1534460263000000000014772.3580399045000000000019369.28401430330000000000
2020-02-1310943.69754903110943.69754903110943.6975490311683.4908061131683.4908061131683.4908061131478.76571678311478.76571678311478.7657167831155155155486.68711538955486.68711538955486.68711538955197.13021787609197.13021787609197.1302178760918961896189610943.69754903110943.69754903110943.6975490311683.4908061131683.4908061131683.490806113156.70553817419400000000156.70553817419400000000156.705538174194000000002113.041083862680000000002113.041083862680000000002113.04108386268000000000-22.47865006071210000000416.716855332578000000001728.0000000000000000000017279.6607720798000000000014983.0854955895000000000019660.25139333770000000000
2020-02-1410960.12003841410960.12003841410960.1200384141672.37983727381672.37983727381672.37983727381464.28632366491464.28632366491464.2863236649209209209481.91914766143481.91914766143481.91914766143192.5613586457192.5613586457192.561358645721052105210510960.12003841410960.12003841410960.1200384141672.37983727381672.37983727381672.3798372738153.07202036118800000000153.07202036118800000000153.072020361188000000002266.113104223870000000002266.113104223870000000002266.11310422387000000000-20.90027120561130000000440.873479123110000000003254.9999999999900000000017939.5589182226000000000015437.4900959138000000000020690.31155728270000000000
2020-02-1510912.82602979610912.82602979610912.8260297961652.94676212911652.94676212911652.94676212911443.29871180941443.29871180941443.2987118094196196196464.77108430153464.77108430153464.77108430153185.79146798352185.79146798352185.7914679835223002300230010912.82602979610912.82602979610912.8260297961652.94676212911652.94676212911652.9467621291148.92405414719900000000148.92405414719900000000148.924054147199000000002415.037158371070000000002415.037158371070000000002415.03715837107000000000-20.93565235495300000000466.143391202426000000001944.0000000000100000000018925.6917020856000000000015835.7748211118000000000022585.82278865460000000000
2020-02-1610809.20068250510809.20068250510809.2006825051626.15683187121626.15683187121626.15683187121416.63879229721416.63879229721416.6387922972141141141447.49516320955447.49516320955447.49516320955178.90805812375178.90805812375178.9080581237524412441244110809.20068250510809.20068250510809.2006825051626.15683187121626.15683187121626.1568318712144.46467286087000000000144.46467286087000000000144.464672860870000000002559.501831231940000000002559.501831231940000000002559.50183123194000000000-20.91223212355190000000492.870111445635000000002029.0000000000000000000020387.4830674093000000000016644.2922579342000000000025173.68002900580000000000
2020-02-1710656.72487036910656.72487036910656.7248703691594.69046965261594.69046965261594.69046965261386.36440323281386.36440323281386.3644032328132132132430.01533895419430.01533895419430.01533895419173.61982565157173.61982565157173.6198256515725742574257410656.72487036910656.72487036910656.7248703691594.69046965261594.69046965261594.6904696526139.81581690937300000000139.81581690937300000000139.815816909373000000002699.317648141310000000002699.317648141310000000002699.31764814131000000000-20.85343745064260000000521.299729845093000000001878.0000000000200000000022454.7881102989000000000017763.5135041902000000000028703.59531036620000000000
2020-02-1810466.24497065710466.24497065710466.2449706571557.99676537081557.99676537081557.99676537081352.12724469581352.12724469581352.1272446958187187187413.26376211521413.26376211521413.26376211521166.7463819596166.7463819596166.746381959627612761276110466.24497065710466.24497065710466.2449706571557.99676537081557.99676537081557.9967653708135.04208856781700000000135.04208856781700000000135.042088567817000000002834.359736709130000000002834.359736709130000000002834.35973670913000000000-20.75931943754720000000551.593011476290000000001754.0000000000000000000025216.6337667911000000000019137.1485902050000000000033057.05076349620000000000
2020-02-1910256.47253997910256.47253997910256.4725399791520.23075727111520.23075727111520.23075727111317.8617787861317.8617787861317.861778786157157157401.85096901026401.85096901026401.85096901026163.02400535511163.02400535511163.0240053551129182918291810256.47253997910256.47253997910256.4725399791520.23075727111520.23075727111520.2307572711132.34074945503600000000132.34074945503600000000132.340749455036000000002966.700486164160000000002966.700486164160000000002966.70048616416000000000-19.64930706761690000000588.75593170959200000000403.0000000000290000000028808.2379403891000000000021215.0523347300000000000038458.44813344050000000000
2020-02-2010021.78815361310021.78815361310021.7881536131478.66220885581478.66220885581478.66220885581280.62515101391280.62515101391280.6251510139165165165388.71293679701388.71293679701388.71293679701157.78760338262157.78760338262157.7876033826230833083308310021.78815361310021.78815361310021.7881536131478.66220885581478.66220885581478.6622088558127.52171532939000000000127.52171532939000000000127.521715329390000000003094.222201493550000000003094.222201493550000000003094.22220149355000000000-19.51709851047740000000623.24288585122100000000537.9999999999560000000033343.7471616074000000000023789.6447297857000000000045365.71759168400000000000
2020-02-219775.31654182129775.31654182129775.31654182121435.96598751341435.96598751341435.96598751341242.86540176461242.86540176461242.8654017646333374.38367680573374.38367680573374.38367680573152.32337677637152.32337677637152.323376776373086308630869775.31654182129775.31654182129775.31654182121435.96598751341435.96598751341435.9659875134122.64520274486800000000122.64520274486800000000122.645202744868000000003216.867404238420000000003216.867404238420000000003216.86740423842000000000-19.31574858223100000000659.58255546509900000000585.0000000000290000000038905.6009782817000000000027390.6881598941000000000053158.99252085660000000000
2020-02-229526.77021760929526.77021760929526.77021760921394.10945678511394.10945678511394.10945678511206.2874979821206.2874979821206.287497982286286286361.9714757632361.9714757632361.9714757632148.08488897946148.08488897946148.084888979463372337233729526.77021760929526.77021760929526.77021760921394.10945678511394.10945678511394.1094567851117.68760210294800000000117.68760210294800000000117.687602102948000000003334.555006341370000000003334.555006341370000000003334.55500634137000000000-19.14789904532670000000697.765056297401000000001731.0000000000000000000045614.7767317625000000000031744.2775462281000000000062256.10882127710000000000
2020-02-239284.78633666829284.78633666829284.78633666821354.3587827631354.3587827631354.3587827631172.02229367781172.02229367781172.0222936778999351.71054522599351.71054522599351.71054522599144.46830251068144.46830251068144.468302510683381338133819284.78633666829284.78633666829284.78633666821354.3587827631354.3587827631354.358782763112.78677786995000000000112.78677786995000000000112.786777869950000000003447.341784211320000000003447.341784211320000000003447.34178421132000000000-18.94203313526740000000737.86899659958300000000236.0000000000000000000053756.1997953642000000000037160.0263759613000000000073978.19070511250000000000
2020-02-249059.39112763259059.39112763259059.39112763251318.09161471851318.09161471851318.09161471851141.37261326731141.37261326731141.3726132673223223223344.60535522696344.60535522696344.60535522696141.84903436901141.84903436901141.849034369013604360436049059.39112763259059.39112763259059.39112763251318.09161471851318.09161471851318.0916147185111.04828460442300000000111.04828460442300000000111.048284604423000000003558.390068815740000000003558.390068815740000000003558.39006881574000000000-16.76831847002910000000828.90035420344400000000745.0000000000000000000063254.2847290780000000000043822.5754559092000000000086301.91830357770000000000
2020-02-258865.03646562618865.03646562618865.03646562611288.98060810011288.98060810011288.98060810011117.89474752941117.89474752941117.8947475294106106106355.76371821417355.76371821417355.76371821417145.75850716107145.75850716107145.758507161073710371037108865.03646562618865.03646562618865.03646562611288.98060810011288.98060810011288.9806081001107.81541919964700000000107.81541919964700000000107.815419199647000000003666.205488015390000000003666.205488015390000000003666.20548801539000000000-15.91679266649620000000877.21083735971300000000871.9999999999710000000074222.3966731068000000000051499.80215520720000000000100481.12607022100000000000
2020-02-268716.83041150068716.83041150068716.83041150061267.18051157131267.18051157131267.18051157131101.61980274041101.61980274041101.6198027404848484362.86989974262362.86989974262362.86989974262148.10345197907148.10345197907148.103451979073794379437948716.83041150068716.83041150068716.83041150061267.18051157131267.18051157131267.1805115713104.24729618422200000000104.24729618422200000000104.247296184222000000003770.452784199610000000003770.452784199610000000003770.45278419961000000000-15.09174866575360000000927.17570825315900000000933.0000000000000000000086895.6492590417000000000060717.86659805510000000000117018.27950888700000000000
2020-02-278628.04395351028628.04395351028628.04395351021256.09272584761256.09272584761256.09272584761095.83471718551095.83471718551095.8347171855525252376.63110563426376.63110563426376.63110563426153.38011965127153.38011965127153.380119651273846384638468628.04395351028628.04395351028628.04395351021256.09272584761256.09272584761256.0927258476101.55668143464900000000101.55668143464900000000101.556681434649000000003872.009465634260000000003872.009465634260000000003872.00946563426000000000-14.24220044935980000000979.262190537918000000001389.00000000001000000000101441.6448636330000000000072018.78880162590000000000135941.84152718900000000000
2020-02-288603.87884201758603.87884201758603.87884201751260.04776362291260.04776362291260.04776362291104.36542896231104.36542896231104.3654289623747474399.0934657817399.0934657817399.0934657817163.78147186401163.78147186401163.781471864013920392039208603.87884201758603.87884201758603.87884201751260.04776362291260.04776362291260.047763622999.4745177144678000000099.4745177144678000000099.474517714467800000003971.483983348730000000003971.483983348730000000003971.48398334873000000000-12.357447010410500000001041.920411340190000000001433.99999999997000000000117863.3493399850000000000084165.67000616790000000000157257.99017169800000000000
Last refresh time: 2020-10-25 09:00:00
Refresh frequency: Daily
Source: IHME

What's Next?

Gain real-time insights from your data and begin
your digital transformation today!