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-04Abruzzo0000000000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.00000000000000000000
2020-02-05Abruzzo0000000000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.137407121983272000000.000000000000000000001.16489246514119000000
2020-02-06Abruzzo0000000000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.303520406314559000000.000000000000000000001.51400528533910000000
2020-02-07Abruzzo0000000000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.509872641743085000000.000000000000000000001.75753306862675000000
2020-02-08Abruzzo0000000000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000005.989536834848360000000.000000000000000000000.764891650999002000000.000000000000000000002.03447697851777000000
2020-02-09Abruzzo0000000000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000005.830512939079690000000.000000000000000000001.096868771044360000000.214741179752527000002.41024016643823000000
2020-02-10Abruzzo0000000000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000005.653819721558950000000.000000000000000000001.383961699853450000000.297416934077780000002.96270758145104000000
2020-02-11Abruzzo0000000000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000005.457493924313680000000.000000000000000000001.757234418130720000000.408255439549974000003.70180580385261000000
2020-02-12Abruzzo0000000000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000005.239354149596710000000.000000000000000000002.244574497109350000000.549613439161394000004.63153543381283000000
2020-02-13Abruzzo0000000000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000004.996976622133420000000.000000000000000000002.883423215472180000000.717589591460490000005.92177037009647000000
2020-02-14Abruzzo0000000000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000004.727668258285310000000.000000000000000000003.724203289833080000000.958293359184920000007.55347294432163000000
2020-02-15Abruzzo0000000000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000004.428403702578950000000.000000000000000000004.835028998247970000001.269245483840480000009.76246274592818000000
2020-02-16Abruzzo0000000000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000004.096160740308720000000.000000000000000000006.308185841163910000001.6704946884832500000012.84948096197640000000
2020-02-17Abruzzo0000000000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000003.692350524871640000000.000000000000000000008.268913626505730000002.2822553343500400000016.65991080034950000000
2020-02-18Abruzzo0000000000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000003.247323851015750000000.0000000000000000000010.886939341527000000003.2207932753864100000021.72253935664680000000
2020-02-19Abruzzo0000000000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000002.790931814857990000000.0000000000000000000014.391103660459900000004.4449592661470200000028.78122184965520000000
2020-02-20Abruzzo0.00667394292042330.00667394292042330.00667394292042330.000333697146021160.000333697146021160.000333697146021160.000145530257813430.000145530257813430.000145530257813430000.0133478858408470.0133478858408470.0133478858408470.00812830530777590.00812830530777590.00812830530777590000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000002.337526200418630000000.0000000000000000000019.087224197932700000006.1385286142349800000037.69607890372520000000
2020-02-21Abruzzo0.0149522959795090.0149522959795090.0149522959795090.000747614798975450.000747614798975450.000747614798975450.00032604586445320.00032604586445320.00032604586445320000.0165567061181710.0165567061181710.0165567061181710.0100823429136460.0100823429136460.0100823429136460000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000001.879795563843440000000.0000000000000000000025.378481950747600000008.4944213485221500000049.38057644308950000000
2020-02-22Abruzzo0.0252928091228360.0252928091228360.0252928091228360.00126464045614180.00126464045614180.00126464045614180.000550481071896180.000550481071896180.000550481071896180000.0206810262866540.0206810262866540.0206810262866540.0125938817383080.0125938817383080.0125938817383080000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000001.403043800006110000000.0000000000000000000033.7865764359033000000012.0128594936083000000065.14436504745190000000
2020-02-23Abruzzo0.0382951345388480.0382951345388480.0382951345388480.00191475672694240.00191475672694240.00191475672694240.000832591642633360.000832591642633360.000832591642633360000.0260046508320240.0260046508320240.0260046508320240.0166708797522570.0166708797522570.0166708797522570000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.902186804581152000000.0000000000000000000044.9710838291614000000016.7788416271187000000085.68575610250850000000
2020-02-24Abruzzo0.0547476302649110.0547476302649110.0547476302649110.00273738151324550.00273738151324550.00273738151324550.00194703613685520.00194703613685520.00194703613685520000.0329049914521270.0329049914521270.0329049914521270.0210736643823580.0210736643823580.0210736643823580000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.397753470320996000004.974427405971540000000.0000000000000000000059.7431641224085000000023.65992777095280000000112.73891823949500000000
2020-02-25Abruzzo0.0756903525276840.0756903525276840.0756903525276840.00378451762638420.00378451762638420.00378451762638420.00268927641437950.00268927641437950.00268927641437950000.0418854445255450.0418854445255450.0418854445255450.0268004304557650.0268004304557650.0268004304557650000000000.008128305307775900000.008128305307775900000.008128305307775900000.008128305307775900000.008128305307775900000.00812830530777590000-0.061361669428393400005.900995826691190000000.0000000000000000000079.0667624586865000000031.87709085415800000000145.27079236711800000000
2020-02-26Abruzzo0.0984359134589470.0984359134589470.0984359134589470.00492179567294740.00492179567294740.00492179567294740.00349460197544810.00349460197544810.00349460197544810000.0536194271703030.0536194271703030.0536194271703030.0342790175915680.0342790175915680.0342790175915680000000000.010082342913646100000.010082342913646100000.010082342913646100000.018210648221422000000.018210648221422000000.01821064822142200000-0.440444309332612000006.726068847133440000000.00000000000000000000104.0378890242500000000043.68138418682850000000186.45228352560500000000
2020-02-27Abruzzo0.127899957434940.127899957434940.127899957434940.00639499787174670.00639499787174670.00639499787174670.00452013015466780.00452013015466780.00452013015466780000.0690104308656210.0690104308656210.0690104308656210.0440832277833980.0440832277833980.0440832277833980000000000.012593881738308100000.012593881738308100000.012593881738308100000.030804529959730100000.030804529959730100000.03080452995973010000-0.751532919649151000007.544073743301470000000.00000000000000000000135.8314292340970000000059.59626078643900000000239.73720859231900000000
2020-02-28Abruzzo0.166240089087940.166240089087940.166240089087940.00831200445439710.00831200445439710.00831200445439710.00585959790446150.00585959790446150.00585959790446150000.0892741450443220.0892741450443220.0892741450443220.0569848609898660.0569848609898660.0569848609898660000000000.015835746866965500000.015835746866965500000.015835746866965500000.046640276826695600000.046640276826695600000.04664027682669560000-1.063029014571620000008.534003584316540000000.00000000000000000000175.6036187492010000000081.20513192222980000000306.91578803484500000000
Last refresh time: 2021-01-19 10:39:19
Refresh frequency: Daily
Source: IHME

What's Next?

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