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-04Global14620.07222181819663.40356382411279.558553265611.40211754837461.74280114394405.83572420063225.42453902634270.0011806532531.79802188931031031032635.10058249733441.87746894782072.380373849824.314744975961086.8710835258661.77321991136888.96888.96888.96999999999999999999999999112.21466742442300000000112.21462820414500000000112.21462820414500000000714.97384213348600000000714.97118587813600000000714.9711858781360000000022437.022033817200000000005137.3750000000300000000020522.8765545756000000000015002.5033277176000000000028121.67453477400000000000
2020-02-05Global18741.17053845525867.30682778114117.3352847943076.8702628884100.73622173322412.08415818713307.19473264254393.53665922362591.64662656121111111112622.94253725633476.41600967062068.9270747681827.615244507141072.5558616547669.8419828248999.96999.96999.96999999999999999999999999118.70405651792400000000118.70402079815600000000118.70402079815600000000833.67789865138400000000833.67520667629200000000833.6752066762920000000024255.620886290700000000004853.3749999999800000000018979.8210465700000000000014052.1384118938000000000025971.59477837070000000000
2020-02-06Global19368.11751224426503.34524617414640.9854878913208.77885991834217.93744283212500.95192085073475.73290571784550.03630400012740.3866842621101101102597.76042511343404.67653018342059.6051596104814.756616586691061.3322155275656.254330611591109.961109.961109.96999999999999999999999999127.28291717604500000000127.28288448013300000000127.28288448013300000000960.96081582745700000000960.95809115642500000000960.9580911564250000000026105.530130447700000000004060.3749999999800000000017580.9795157715000000000013108.4936775939000000000024024.32200940790000000000
2020-02-07Global19590.46716403726423.06538408814772.5813173456283.9379519547918.63305598285030.89027079664022.33735047845087.66685435273219.46172821161301301302048.22932574812765.52554878811517.784110095794.621380002671037.3300105125640.933925617371239.961239.961239.96999999999999999999999999123.92384937946600000000123.92381930763800000000123.923819307638000000001084.884665206900000000001084.881910464060000000001084.8819104640600000000027984.884287956000000000004622.3750000000400000000016366.4192463887000000000012335.0945228044000000000021507.29023440010000000000
2020-02-08Global19906.72724480526855.03198278915090.8878285316396.29750830068046.51506101095134.27926573664092.6458096655151.62773920753295.93270334681321321321968.42306096992718.12237341841440.3022722943781.245344938751006.9132620473629.555167960831371.961371.961371.96999999999999999999999999126.28692897022700000000126.28690118502500000000126.286901185025000000001211.171594177140000000001211.168811649090000000001211.16881164909000000000-17.3834362890517000000029876.317653500200000000003532.3749999999900000000015360.8820543925000000000011771.9879745814000000000019907.10823483300000000000
2020-02-09Global19986.76950795626844.28855921815143.6352394386373.87849631017974.22539716495176.19720725254089.57862229195151.44491060643331.92321071111501501501877.43622246232683.52193153191372.1343057713775.21669890329999.08653511945624.509010816551521.961521.961521.96999999999999999999999999129.01836555097700000000129.01833976566100000000129.018339765661000000001340.189959728110000000001340.187151414750000000001340.18715141475000000000-16.6250917628961000000031776.638714168500000000004051.1249999999900000000014581.6600799181000000000011258.2645802062000000000018504.99932750450000000000
2020-02-10Global20067.58218809727269.01238966715244.183047516407.80020317218150.04743904735179.83783361514129.88881278325241.48995704193347.86668117231661661661783.52082566672512.60032961461302.3569949575619.06171583849846.61344328611467.470007442521687.961687.961687.96999999999999999999999999132.95649488569300000000132.95647085504200000000132.956470855042000000001473.146454613810000000001473.143622269790000000001473.14362226979000000000-14.8495765283802000000033684.544512262800000000003380.1250000000500000000014441.3516609192000000000011443.4661844284000000000017885.28928470160000000000
2020-02-11Global20706.84842121528292.71560109715827.1762236814953.02432510316244.04164450374040.74572357354145.93960370865258.58473098243342.01864725051541541541678.5785016552326.98183895881229.9833722804598.23476207333838.93260315737447.279784666031841.961841.961841.96999999999999999999999999137.82084805899400000000137.82082557201600000000137.820825572016000000001610.967302672800000000001610.964447841810000000001610.96444784181000000000-14.3122145697445000000035606.943607200500000000002650.6249999999600000000014369.3449718604000000000011629.1716127007000000000017424.83182855020000000000
2020-02-12Global20403.10442087827509.13809184815572.2654807824805.64075725576086.47412509063921.05002935284075.13616217945216.29620200773285.80350678542221570.36423339192154.43679297551145.1367318339573.33630436413812.4108470784426.87289217651843.961843.961843.96999999999999999999999999143.01024476867500000000143.01022364279300000000143.010223642793000000001753.977547441500000000001753.974671484600000000001753.97467148460000000000-14.0987250435608000000037557.60107602790000000000182.6250000000150000000014646.5958065637000000000012181.6753057272000000000017290.37318806900000000000
2020-02-13Global19943.82651833326968.93916331315207.1726108824635.56875557495904.91508135883759.10892053283991.78421423155140.77791163913211.01331468241581581581460.16827742532039.9275506531058.3876499681545.38325865976756.29576427161406.036305589842001.962001.962001.96999999999999999999999999148.04650704290500000000148.04648711935600000000148.046487119356000000001902.024054484380000000001902.021158603960000000001902.02115860396000000000-13.7952088956773000000039555.497961315500000000001787.1250000000200000000015383.5132057875000000000013322.7731107827000000000017794.82752545430000000000
2020-02-14Global19527.90673203426352.29794102614847.0606694224442.14809390085705.92642809233605.02897330653894.92471549675041.03525726883128.09965338242112112111350.70523895161880.400850229977.20827048139512.9194566366698.88588583762381.872137869662212.962212.962212.96999999999999999999999999152.48829061417100000000152.48827175420700000000152.488271754207000000002054.512345098580000000002054.509430358160000000002054.50943035816000000000-12.9876818646405000000041747.318083731900000000003298.1250000000200000000016612.8311395262000000000014620.7998314215000000000018938.03007225160000000000
2020-02-15Global19026.11853851225705.25294776714376.2212315534233.10762937635462.01301751783419.99710514243778.38573502254915.43230970883025.13372550041981981981263.24652404731733.8754750716922.38210184711479.18668703876660.057409586354.762843816882410.962410.962410.96999999999999999999999999155.86182523596100000000155.86180731769900000000155.861807317699000000002210.374170334520000000002210.371237675860000000002210.37123767586000000000-12.8965268571866000000044042.615811836000000000001988.4583333332800000000018245.7792663891000000000016176.8446953000000000000020646.63811842080000000000
2020-02-16Global18361.2749216424822.92052599713779.6647414524005.88130267685164.21947118713233.13590242373637.30797710174756.30434161572901.68493275691421421421168.28075934471596.9774008043858.85739473501445.5501230133609.73482721027330.467863086452552.962552.962552.96999999999999999999999999157.68486610843400000000157.68484902426000000000157.684849024260000000002368.059036442970000000002368.056086700120000000002368.05608670012000000000-12.1538769439848000000046484.334976317900000000002056.4583333333900000000020410.6128377276000000000018289.6446849753000000000023139.16462343310000000000
2020-02-17Global17618.78623521623909.9707939113110.5491500383753.85203655424834.03230445473013.31008004063477.31192099884511.49543005022764.00132783311351351351080.87713898011477.5704807833805.95740947767412.09727150156567.09201136628306.493688664822687.962687.962687.96999999999999999999999999157.31213173638100000000157.31211539075400000000157.312115390754000000002525.371168179330000000002525.368202090870000000002525.36820209087000000000-12.0193563350974000000049127.134480304600000000001892.5333333332800000000023372.2554722472000000000020960.7614405769000000000026608.62429207280000000000
2020-02-18Global16820.14073891122957.40391404812396.1199341213483.97012925124488.66391101712776.32818842243301.88629844944281.86565556012601.19838092661901901901005.59301562111319.8867567924758.07732402363384.98172056494522.94523547537287.858523115842877.962877.962877.96999999999999999999999999154.67039008128000000000154.67037438898200000000154.670374388982000000002680.041558260610000000002680.038576479860000000002680.03857647986000000000-11.1460488181913000000052033.536768367100000000001769.1999999999700000000026888.8669836686000000000024098.6301255829000000000030759.78677381890000000000
2020-02-19Global15971.5760425821997.22955634111611.7584714233181.59990850184125.70280810432513.94590463833110.79758621854078.8718056172437.3959600952155155155943.375470926041223.6065210977718.64383548588355.19804988411480.48554287135266.31936951173032.963032.963032.96999999999999999999999999150.01370389833900000000150.01368878304000000000150.013688783040000000002830.055262158910000000002830.052265262900000000002830.05226526290000000000-10.4902117576800000000055758.50233398090000000000404.2000000000840000000031323.6030908862000000000027999.0447435149000000000035969.56334658400000000000
2020-02-20Global15077.5751345220973.95973515910858.7981923112844.03637476243733.36096023512224.59210902392905.96139484413841.75918116312249.8959955306165165165894.831437661921138.7225978473685.21142205345328.66508605162433.79097488166250.254221241273197.963197.963197.96999999999999999999999999143.72204691316100000000143.72203230636800000000143.722032306368000000002973.777309072130000000002973.774297569260000000002973.77429756926000000000-10.3182493455198000000059430.42327852190000000000539.1999999999680000000036632.9321150582000000000032517.8073940094000000000041971.35221075890000000000
2020-02-21Global14328.45988394119965.7587648110243.1353934542501.9590698253287.18143547971928.58586881442681.18533126653545.32920170312045.0658326932333945.220997892661189.8135901088746.16910712352306.28370200364397.8578221846233.624325261313200.963200.963200.96999999999999999999999999136.04518068281000000000136.04516652302800000000136.045166523028000000003109.822489754900000000003109.819464092290000000003109.81946409229000000000-9.7053452719966900000063441.92109781320000000000580.2000000000260000000042901.0769118629000000000037961.4249795111000000000049281.73027434620000000000
2020-02-22Global13797.13766598819253.5318240219859.93302023892203.69012582672895.89558470671673.37433781292521.69773099783307.62755182751910.8546961827286286286951.340332907551148.9113690607778.45529474162362.55353284933450.27929242501274.694608086613486.963486.963486.96999999999999999999999999127.37875519052900000000127.37874142256200000000127.378741422562000000003237.201244945410000000003237.198205514850000000003237.19820551485000000000-7.2902445763680500000067798.657183205700000000001728.3333333332800000000050602.9896170946000000000044701.2470987347000000000057752.72744693130000000000
2020-02-23Global13102.77614149718571.7747305729300.85553351722034.48482159992635.0804591131555.03173979682441.9159446273161.67268179681876.5852730188888984.051622655931159.8627071543820.97449601756366.3752549053451.70462811247275.1140925493494.963494.963494.96999999999999999999999999122.39038869134700000000122.39037526566100000000122.390375265661000000003359.591633636830000000003359.588580780520000000003359.58858078052000000000-7.1121834830957200000072450.49775839830000000000223.3333333332990000000060120.0186357110000000000052699.2473559739000000000068600.39056506020000000000
2020-02-24Global12439.78774088417591.2105244898810.20603872191925.49180171692464.00425850261500.14667917312427.70586787543084.60141052211891.69807728592172172171082.12323284391241.0288966824944.80560230348364.23539462811447.16978631544293.278058699293711.963711.963711.96999999999999999999999999111.78693416741300000000111.78692103956600000000111.786921039566000000003471.378567804150000000003471.375501820080000000003471.37550182008000000000-6.8759437604917600000081910.60067461340000000000488.3333333333870000000070998.5971579672000000000061053.8341897458000000000080967.10018829660000000000
2020-02-25Global11809.88109444116878.1731310778321.69969245131684.51241731392176.77314555331287.78360174892347.19868124082982.64593597131827.51318819421061061061185.17290346391346.36262330041046.1680160348355.67054779736433.16282344238292.91453974093817.963817.963817.96999999999999999999999999103.28787765886000000000103.28786478909000000000103.287864789090000000003574.666445463120000000003574.663366609170000000003574.66336660917000000000-6.7231586823911700000087538.09316508110000000000841.0000000000290000000083822.3380576160000000000070496.3602928043000000000095849.01514104190000000000
2020-02-26Global11227.51250467516109.9375489477887.56592293041618.89304790542068.58046413991247.02860489622274.53115584682854.41318053191773.34444005858484841377.845802851550.85233887161224.6266978301377.26379281085459.53289103368316.763050377953901.963901.963901.9699999999999999999999999995.3026905732410000000095.3026779261320000000095.302677926132000000003669.969136036370000000003669.966044535300000000003669.96604453530000000000-6.5801346993041200000093300.49620340310000000000910.9999999998980000000098995.7814286946000000000081689.97117990750000000000113477.04709768500000000000
2020-02-27Global11520.33644529616294.4092841288305.65936155021776.99886151352234.90608157381408.78349213362443.41677250813003.45312712281978.47661375245353531660.51726530261862.11378680861467.0941219594707.63717110723827.18145603102600.136437852823954.963954.963954.9699999999999999999999999988.1222887908669000000088.1222763350759000000088.122276335075900000003758.091424827210000000003758.088320870380000000003758.08832087038000000000-6.3768994846675900000099389.358562099600000000001365.99999999999000000000116777.2183614610000000000094394.08617754240000000000133696.79303411800000000000
2020-02-28Global11756.87816324516420.9007595728659.5603931071811.71810551812271.67771107481452.38627212012235.28621426592687.62631940221826.24263492297474742105.96085476842377.99775270481848.5865154134822.97991130542966.94866028944670.367662300824028.964028.964028.9699999999999999999999999996.0739121061076000000096.0738998141331000000096.073899814133100000003854.165336933220000000003854.162220684510000000003854.16222068451000000000-6.01129319935302000000106600.493796355000000000001409.00000000001000000000137406.06426844600000000000109165.28247116400000000000158186.24317925600000000000
Last refresh time: 2021-04-11 09:00:00
Refresh frequency: Daily
Source: IHME

What's Next?

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