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-04Global18455.93724963513458.54269425125757.5803391194616.56651788133484.64957182836294.62710155445081.1795487641217.630703367311554.2440689191032347.47924764381789.86937381253127.0834250831738.14912721719570.36617834842976.89533058812955.96112.38632800458900000000112.37752316790600000000112.42918665950600000000716.59753503573600000000716.33577748537600000000717.72564151604500000000-19.545076994402200000000.000010220228468682105144.3750000000000000000025454.4111339189000000000017813.6788777237000000000036013.17518476220000000000
2020-02-05Global22039.32090404216646.42587893229833.4589273954795.70067248853665.18581418376520.71457672435165.66862955271308.996045275311668.9709855631112349.32262991251790.7462737993133.5821409351853.99153308749683.131510995411096.93772468281066.96118.78703691809900000000118.77929057167200000000118.82334155882100000000835.38457195383200000000835.11506805704800000000836.53304852290800000000-19.633097747290300000000.000010747815008886804872.3750000000000000000023774.2057176528000000000016583.5193945826000000000033201.62405792390000000000
2020-02-06Global22952.19826920717299.20789085931097.3183278395108.19618948493945.97648329666901.79709971585250.24588752531405.421781003711748.9921820791102339.3059725341803.75103148543091.1807985209851.63882020189687.295982970161076.87474659051176.96193.49308609628400000000193.48625912702100000000193.524388664601000000001028.877658050120000000001028.601327184070000000001030.04557133716000000000-19.745434410089000000000.000011439008847906304066.3750000000000000000022273.4405730793000000000015628.8808650782000000000030691.30524853630000000000
2020-02-07Global23367.6479265617645.40743118231607.4586502386413.16926666795123.16808941768376.16123146256082.39545927352245.260881885312530.0655290191311803.35409039571294.29941061712532.1476533665709.3085460502555.93212040401920.606569323281307.96124.28288701732800000000124.27685106733700000000124.309969280791000000001153.160545067450000000001152.878178251410000000001154.34703856297000000000-18.237270302415800000000.000011192431209871904632.3750000000000000000021000.5348485902000000000015133.2331087848000000000028278.65155712410000000000
2020-02-08Global23817.2954832318009.01425792132012.8976673526466.05582758595126.61727527598423.77781759876137.19469879862295.883479637212588.3821304291321745.03104750711259.0328585352431.0909714979640.354070892482.82311131594834.218339544031439.96126.68605636912500000000126.68069663631000000000126.709812945398000000001279.846601436560000000001279.558874887720000000001281.04763365371000000000-18.192370541665500000000.000011826678248782003539.3750000000000000000020053.9379840786000000000014734.9364145712000000000026340.76793044050000000000
2020-02-09Global24082.86508032918280.64808907832879.7892951286379.12472829125011.38551231468335.11021683946142.52890914892301.450430866212945.8850504941511675.52428918351209.56510845592338.6507343688634.2169832224475.59595536048831.39239123031590.96129.41121168098400000000129.40642784084800000000129.431904671311000000001409.257813117560000000001408.965302728560000000001410.47234610688000000000-17.404822575160700000000.000011952739281421704060.1250000000000000000019377.1018136988000000000014553.9728877890000000000024785.38152906730000000000
2020-02-10Global24295.68282606718385.92528645333048.5308920526445.04071596495029.85832577948436.4027871826170.30988959272277.161588678912902.4128629681661605.11328674841158.05653356392245.9842027953545.4928236127404.01689679445751.161976172011756.96133.30952033914800000000133.30522612903800000000133.327642635325000000001542.567333456690000000001542.270528857600000000001543.79683403763000000000-15.445861742321700000000.000011171412354710003388.1250000000000000000019841.9515291986000000000015620.3765937835000000000024820.26927948840000000000
2020-02-11Global24948.07649018718862.16497734532654.4777202846409.79438044984977.72447428638416.89393372146073.87984655962174.033934288112869.0642298761541521.42197872331092.39409042922154.2611018757531.34726007077393.76987615625727.868069669281910.96138.05906832714100000000138.05511832142400000000138.075312693747000000001680.626401783840000000001680.325647179030000000001681.87283046639000000000-14.864317508170100000000.000011313358017955002656.6250000000000000000020248.4736094823000000000016477.5896424707000000000024670.15324485820000000000
2020-02-12Global24636.81895427118470.041037532161.2448707336231.45794000254768.57378338058189.98407180365964.37585150572048.16478282612734.70850213431434.15681336741018.54884652482037.5391374472513.23309837078378.26984881562709.446723605481913.96143.12298414094700000000143.11923295124000000000143.137472164822000000001823.749385924770000000001823.444880130270000000001825.01235299952000000000-14.568382831652200000000.00001165306813796480195.6250000000000000000021190.1376185538000000000017857.8983207436000000000025170.06260818770000000000
2020-02-13Global24161.02992600918092.64140812231610.7157095156139.89136443394678.59672298578070.80691154825921.00688380241991.83569441812676.0263288291581343.5996005454943.037727711141867.286351197492.72886422781360.21722651301679.303447454762071.96148.05003656985200000000148.04628313622700000000148.062975188339000000001971.799422494660000000001971.491163266490000000001973.07894162237000000000-14.247618500897200000000.000011971638760829001787.1250000000000000000022852.8299828246000000000019848.0975432346000000000026540.89432684770000000000
2020-02-14Global23851.42043205317998.86837399531359.499832436033.27775117384533.46544695167955.75742402145862.47369345071920.201428834612624.2911066222111252.9539270394871.584624022191765.5245011296466.79832739009338.67211326042646.404812868322282.96152.40785742088500000000152.40392747069500000000152.419666491259000000002124.207279915500000000002123.895090737190000000002125.49688175567000000000-13.386437261840600000000.000012008170194379803300.1250000000000000000025241.0548991282000000000022411.7760369815000000000028924.03406682680000000000
2020-02-15Global23334.68345971517648.26215789930780.1707758235902.1847050094409.55581621317714.9486795485817.68912819941908.502446111412589.6183494271981181.6660556696829.108425595381670.8558442145439.4051985226318.35741400025604.280128799352480.96155.74287776801200000000155.73874148169700000000155.754211590123000000002279.950157683530000000002279.633832218890000000002281.25425507768000000000-13.281846706698300000000.000012582085015466901991.4583333333200000000028292.3804094498000000000025438.4531049137000000000031622.14734462610000000000
2020-02-16Global22574.93890088616992.46913662430044.4365416745749.01592538184326.11275897647528.33175887535757.46611299291842.343399446612530.7069993491411102.7122334561770.259658186281541.8086485811411.44569462307296.78359573845564.893101212872621.96157.54883378660600000000157.54441592757000000000157.602472825980000000002437.498991470170000000002437.178248146460000000002438.81068251270000000000-12.481297455041000000000.000012533202054495302056.4583333333400000000032172.2036278089000000000029108.9272847860000000000035854.20694660610000000000
2020-02-17Global21727.81650688216314.57757974729008.6315399775550.40728476854155.99279499687313.76388234285692.008247651772.118181369712461.0385970481351029.5797079388717.805811380311419.8946443138383.4132802538273.1770485796523.362453691452756.96157.19915066057800000000157.19375468243400000000157.263301112649000000002594.698142130700000000002594.372002828890000000002596.01808157429000000000-12.347321817234000000000.000013179195548710001893.5333333333300000000037220.9078435056000000000033646.9546387797000000000041434.34602520680000000000
2020-02-18Global20795.62142795715583.49631487828206.8254300645288.43648933933920.80275433647065.78340919875626.25305384121697.177723101512388.903006741190968.36244907746689.41799983851303.2054348712361.02197593329255.78926460388496.405267723142946.96154.61923684415200000000154.61258227589300000000154.684004509887000000002749.317378974880000000002748.984585104780000000002750.64388003793000000000-11.447420787611800000000.000013040552969165201769.2000000000000000000043116.0782850190000000000038935.3547641784000000000048259.42142001010000000000
2020-02-19Global19801.2972895614786.46295567426989.5730793315032.61461803433720.19437892056729.35928465435561.83345998281628.002590205412319.984426669155920.71046642404674.044568300461212.2146600645336.25160196614238.85751438748460.334858977573101.96150.04356270198600000000150.03566609056100000000150.108623658436000000002899.360941676880000000002899.020251195340000000002900.70445254309000000000-10.801559391969500000000.00001319439771794320409.2000000000120000000050756.4166808129000000000045619.7617318315000000000057043.61105541550000000000
2020-02-20Global18789.14044601714052.34925307825497.8678236914752.58666649193481.06628836766418.88684184963509.85579760662579.13981117614873.7908418864165886.14770388089666.711325315991138.2040607713314.03752133085223.76215056637421.497514133753266.96143.83611396590500000000143.82696668985000000000143.900622388458000000003043.197055642760000000003042.847217885190000000003044.54632610886000000000-10.572780684008400000000.00001403465194316020538.1999999999970000000059159.5706376415000000000053271.7898927367000000000066267.26823491580000000000
2020-02-21Global17810.24738919813254.90910549124015.6571473534482.75665053743277.91193057176165.54756649953352.7255646042424.15118299674659.83572630473959.52179549079757.047261790651202.2247257496295.84157805748215.36849772471389.187727891423269.96136.18851835150800000000136.17785805347700000000136.251875368463000000003179.385573994260000000003179.025075938670000000003180.73634310718000000000-9.943789597313330000000.00001425561869340120576.1999999999970000000068831.8030602159000000000061661.8686131386000000000076705.70075904390000000000
2020-02-22Global17092.51621878612783.53956255122856.0882552954232.90539319533105.45251131715742.07918637063182.52835152562287.66351509534450.3686246081286984.48515916552802.92769751081208.1935656702364.46112061321269.80007742393468.623276374483555.96127.51335469245000000000127.50112248892100000000127.573673081604000000003306.898928686740000000003306.526198427590000000003308.25064740636000000000-7.563151601570650000000.000011737981694023301726.3333333333300000000080465.0564827535000000000071807.2015133011000000000089674.04477780450000000000
2020-02-23Global16175.25308807612169.49458436721763.5879284294037.26942897562948.59593049575459.1699209893042.76942305482154.04523585094280.377712300191038.1687321246875.821694948231239.5746052409374.46277947364278.83103837613481.805574978953564.96122.49635348069700000000122.48341666605300000000122.554702747310000000003429.395282167390000000003429.009615093650000000003430.75079818835000000000-7.374890497405660000000.00001241316957060050223.3333333333430000000094242.3973409142000000000083689.08645596770000000000104517.56325353200000000000
2020-02-24Global15284.22317903511459.43360455320548.7413769653893.56996762192883.81728928565211.09447419512888.18437351342023.76637384194094.83955304652171160.61099489651017.14511627511334.985567868371.33823392735298.93101331649453.760120984363781.96111.85690982041500000000111.84304246820100000000111.912604190195000000003541.252191987790000000003540.852657561850000000003542.65179125462000000000-7.128616699579650000000.00001377456227481580489.33333333332800000000109282.0470789520000000000096330.90671018070000000000121172.15252476600000000000
2020-02-25Global14453.65780964810869.68429602619569.2319403533680.25569012042722.13224796174867.65325666732707.99216803261897.27505604343829.44273182621061292.21869859761147.17123894381465.4599431522361.17840223476301.51492212296432.886219362943887.96103.34253759115100000000103.32767819052000000000103.396187272316000000003644.594729578950000000003644.180335752370000000003646.02480681944000000000-6.887036735202500000000.00001453951331602860841.00000000000000000000126262.42706361700000000000111473.11745460500000000000139983.81510615500000000000
2020-02-26Global13680.65831456410342.66787975118378.0267502813484.00459709922600.26807790944617.58341347492623.49369712161781.89575071473720.997430954841519.90868931971362.48596395961709.7506680796392.10283787591335.96384695675467.779894487293971.9695.3654597564813000000095.3499937759435000000095.417147679293900000003739.960189335450000000003739.530329528310000000003741.39557433931000000000-6.726366423352500000000.00001531047912624030911.00000000000000000000145479.31887003000000000000127098.12700172200000000000160798.98365840800000000000
2020-02-27Global43146.35489258438798.7255256449695.0821043653374.49988225322542.56834359294377.26068369962716.39514807351867.82716533553782.6034414639531845.17657411921646.21026045642082.2511384289776.45266025724598.77400719772890.828205174584024.9688.1680123579824000000088.1526288194732000000088.218276540651100000003828.128201693430000000003827.682958347780000000003829.57986411788000000000-6.509899660548780000000.000016169239351288101364.00000000000000000000167070.73989048200000000000144397.97843110100000000000184056.98580024300000000000
2020-02-28Global52953.32069399147294.23087847660920.1856253533294.57304271892555.2204445184255.82637277532947.86075865022451.99808239973510.8782772346742333.83056866512051.12282178552649.8310086327916.18443408093681.349889825381063.69148651984098.9696.1323961628103000000096.1167545946627000000096.181134295085100000003924.260597856260000000003923.799712942450000000003925.73223556522000000000-6.140016178037730000000.000016950287833131801403.00000000000000000000191165.68657646300000000000163747.55320284100000000000210855.64775308300000000000
Last refresh time: 2021-10-17 09:01:19
Refresh frequency: Daily
Source: IHME

What's Next?

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