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.000000000000000000001.247530458224430000000.222822595826987000000.000000000000000000001.57927420264411000000
2020-02-05Abruzzo0000000000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000001.658503693497480000000.521008583124799000000.000000000000000000002.11077652378493000000
2020-02-06Abruzzo0000000000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000002.239830670111100000000.892641744487947000000.000000000000000000002.76363008285403000000
2020-02-07Abruzzo0000000000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000003.064121855689410000001.375779680801900000000.000000000000000000003.55479709120008000000
2020-02-08Abruzzo0000000000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000006.579415096772980000004.215393302921380000001.999261530618280000000.698128442067664000004.45237990483608000000
2020-02-09Abruzzo0000000000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000006.391242552451420000005.766848891733970000002.596308406730910000000.930342420657079000005.76170183559133000000
2020-02-10Abruzzo0000000000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000006.182161947649680000007.755286625183050000003.356147087540680000001.239008220193370000007.27623452304771000000
2020-02-11Abruzzo0000000000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000005.9498501645366400000010.177510987255500000004.318993445650960000001.615010987050930000009.20249592007149000000
2020-02-12Abruzzo0000000000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000005.6917259610777000000013.024888542509700000005.534336578426960000002.1129680512973800000011.66431006421830000000
2020-02-13Abruzzo0000000000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000005.4049212905677700000016.331933444138100000007.063216926794990000002.7689547033106100000014.57774228690540000000
2020-02-14Abruzzo0000000000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000005.0862494344456200000020.190826580908500000008.981097518767810000003.6098769139723200000018.13608722478250000000
2020-02-15Abruzzo0000000000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000004.7321665506961000000024.7080631199439000000011.381398569759700000004.6740736204906600000022.55557985880480000000
2020-02-16Abruzzo0000000000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000004.3387499930878800000029.9216827727604000000014.379590742695100000005.9810440659957500000028.05310198044490000000
2020-02-17Abruzzo0000000000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000003.8678919222422200000035.7194454898936000000018.117928035637900000007.6831437160278700000034.83203821314290000000
2020-02-18Abruzzo0000000000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000003.3716442399869000000041.7994756129381000000022.770651904838700000009.8857169230584900000043.32376762945980000000
2020-02-19Abruzzo0.0254055004659810.0254055004659810.0254055004659810.0142800320740610.0142800320740610.0142800320740610.0142800320740610.0142800320740610.0142800320740610000.0254055004659810.0254055004659810.0254055004659810.0142800320740610.0142800320740610.0142800320740610000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000002.8951180822770800000047.7022140902730000000028.5490922359196000000012.5607834187427000000053.85839614461570000000
2020-02-20Abruzzo0.0588042675861780.0588042675861780.0588042675861780.0330529535659690.0330529535659690.0330529535659690.0330529535659690.0330529535659690.0330529535659690000.0333987671201970.0333987671201970.0333987671201970.0187729214919080.0187729214919080.0187729214919080000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000002.4439310886600300000052.9154004863395000000035.7062983277283000000016.2104906996922000000066.39791447148300000000
2020-02-21Abruzzo0.102499115762620.102499115762620.102499115762620.057613140217920.057613140217920.057613140217920.057613140217920.057613140217920.057613140217920000.0436948481764370.0436948481764370.0436948481764370.0245601866519520.0245601866519520.0245601866519520000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000001.9723285959151600000057.0208800157754000000044.5409019327411000000020.7214381013617000000081.90620882667810000000
2020-02-22Abruzzo0.159391261412190.159391261412190.159391261412190.0898500519523010.0898500519523010.0898500519523010.0896258177056420.0896258177056420.0896258177056420000.0568921456495760.0568921456495760.0568921456495760.0322369117343810.0322369117343810.0322369117343810000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000001.4191700602217000000059.8250844466158000000055.3981391729996000000026.39613341462050000000100.49316790599800000000
2020-02-23Abruzzo0.233117722675750.233117722675750.233117722675750.131630671738840.131630671738840.131630671738840.131111653006650.131111653006650.131111653006650000.0737264612635580.0737264612635580.0737264612635580.0417806197865370.0417806197865370.0417806197865370000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.000000000000000000000.7513536737312590000061.4154056629137000000068.6657842308817000000033.43667561639460000000122.10015495216500000000
2020-02-24Abruzzo0.328216508572260.328216508572260.328216508572260.185529195106540.185529195106540.185529195106540.184624516529670.184624516529670.184624516529670000.0950987858965110.0950987858965110.0950987858965110.0538985233676990.0538985233676990.0538985233676990000000000.014280032074060800000.014280032074060800000.014280032074060800000.014280032074060800000.014280032074060800000.014280032074060800000.0068483185999497200062.119231073111600000000.0000000000000000000084.7652542218714000000041.50002731424360000000147.55566494136700000000
2020-02-25Abruzzo0.436051712726340.436051712726340.436051712726340.240467610470120.240467610470120.240467610470120.239060789948130.239060789948130.239060789948130000.122115236228140.122115236228140.122115236228140.069218447437640.069218447437640.069218447437640000000000.018772921491908000000.018772921491908000000.018772921491908000000.033052953565968800000.033052953565968800000.03305295356596880000-0.6909936030359280000062.395951642764800000000.00000000000000000000104.1353878594950000000051.92234613753150000000175.75382765355200000000
2020-02-26Abruzzo0.562551894792530.562551894792530.562551894792530.310209273046090.310209273046090.310209273046090.308151727397770.308151727397770.308151727397770000.156139840126950.156139840126950.156139840126950.088514584067880.088514584067880.088514584067880000000000.024560186651951600000.024560186651951600000.024560186651951600000.057613140217920400000.057613140217920400000.05761314021792040000-1.2234567042456000000062.718251060390300000000.00000000000000000000127.2066561971950000000065.26831800200600000000208.67314854707400000000
2020-02-27Abruzzo0.722566295366250.722566295366250.722566295366250.398393824652740.398393824652740.398393824652740.395496917282650.395496917282650.395496917282650000.198860296909110.198860296909110.198860296909110.112744738258610.112744738258610.112744738258610000000000.031978179911312800000.031978179911312800000.031978179911312800000.089591320129233200000.089591320129233200000.08959132012923320000-1.5449782642398300000063.485551092516200000001.00000000000000000000154.3666284662330000000081.54011169667650000000251.05017713660200000000
2020-02-28Abruzzo0.924270434579590.924270434579590.924270434579590.509513600762070.509513600762070.509513600762070.505538878843990.505538878843990.505538878843990000.252371988520660.252371988520660.252371988520660.143097956020630.143097956020630.143097956020630000000000.041440483841692800000.041440483841692800000.041440483841692800000.131031803970926000000.131031803970926000000.13103180397092600000-1.7028015984993300000064.980976116885800000000.00000000000000000000185.91408884392500000000101.06843823390800000000298.54197516073400000000
Last refresh time: 2020-08-02 09:00:00
Refresh frequency: Daily
Source: IHME

What's Next?

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