Dataset: New Cases Of COVID-19 In World Countries

About this Dataset

New Cases Of COVID-19 In World Countries

Has the curve flattened?

Countries around the world are working to “flatten the curve” of the coronavirus pandemic. Flattening the curve involves reducing the number of new COVID-19 cases from one day to the next. This helps prevent healthcare systems from becoming overwhelmed. When a country has fewer new COVID-19 cases emerging today than it did on a previous day, that’s a sign that the country is flattening the curve.

On a trend line of total cases, a flattened curve looks how it sounds: flat. On the charts on this page, which show new cases per day, a flattened curve will show a downward trend in the number of daily new cases.

This analysis uses a 5-day moving average to visualize the number of new COVID-19 cases and calculate the rate of change. This is calculated for each day by averaging the values of that day, the two days before, and the two next days. This approach helps prevent major events (such as a change in reporting methods) from skewing the data. The interactive charts below show the daily number of new cases for the 10 most affected countries, based on the reported number of deaths by COVID-19.

This datas were last updated on Saturday, April 25, 2020 at 11:51 PM EDT.

Tables

Covid19 Jhon Hopkins

@kaggle.mathchi_new_cases_of_covid19_in_world_countries.covid19_jhon_hopkins

612.97 KB
16659 rows
28 columns


CREATE TABLE covid19_jhon_hopkins (
  "country_or_region" VARCHAR,
  "province_or_state" VARCHAR,
  "state_and_country" VARCHAR,
  "date" TIMESTAMP,
  "daily_new_cases" BIGINT,
  "running_total_cases" BIGINT,
  "running_total_cases_prev_day" BIGINT,
  "daily_new_deaths" BIGINT,
  "running_total_deaths" BIGINT,
  "running_total_deaths_prev_day" BIGINT,
  "data_source" VARCHAR,
  "lat" DOUBLE,
  "long" DOUBLE,
  "first_case_state_rank" DOUBLE,
  "first_case_country_rank" DOUBLE,
  "hundred_case_state_rank" DOUBLE,
  "hundred_case_country_rank" DOUBLE,
  "country_code_2" VARCHAR,
  "country_code_3" VARCHAR,
  "country_population_2018" DOUBLE,
  "country_median_age" DOUBLE,
  "country_running_agg" BIGINT,
  "location" VARCHAR,
  "country_or_region_day_number" BIGINT,
  "province_or_state_day_number" BIGINT,
  "state_and_country_day_number" BIGINT,
  "country_code_2_day_number" BIGINT,
  "country_code_3_day_number" BIGINT
);