Monkeypox Dataset
Monkey pox cases around the world.
@kaggle.deepcontractor_monkeypox_dataset_daily_updated
Monkey pox cases around the world.
@kaggle.deepcontractor_monkeypox_dataset_daily_updated
File 1 : Monkey_Pox_Cases_Worldwide
Description : This dataset contains a tally of confirmed and suspected cases in all the countries.
File 2 : Worldwide_Case_Detection_Timeline
Description : This dataset contains the timeline for confirmed cases w.r.t. date time, it also contains some other details on every case that is being reported.\
File 3 : Daily_Country_Wise_Conformed_Cases
Description : This dataset contains the daily number of confirmed cases for all the countries where the virus has entered. Thank you @sudalairajkumar for the suggestion.
CREATE TABLE daily_country_wise_confirmed_cases (
"country" VARCHAR,
"n_2022_01_31" BIGINT -- 2022-01-31,
"n_2022_02_17" BIGINT -- 2022-02-17,
"n_2022_02_28" BIGINT -- 2022-02-28,
"n_2022_03_04" BIGINT -- 2022-03-04,
"n_2022_03_31" BIGINT -- 2022-03-31,
"n_2022_04_10" BIGINT -- 2022-04-10,
"n_2022_04_12" BIGINT -- 2022-04-12,
"n_2022_04_30" BIGINT -- 2022-04-30,
"n_2022_05_06" BIGINT -- 2022-05-06,
"n_2022_05_08" BIGINT -- 2022-05-08,
"n_2022_05_12" BIGINT -- 2022-05-12,
"n_2022_05_13" BIGINT -- 2022-05-13,
"n_2022_05_15" BIGINT -- 2022-05-15,
"n_2022_05_17" BIGINT -- 2022-05-17,
"n_2022_05_18" BIGINT -- 2022-05-18,
"n_2022_05_19" BIGINT -- 2022-05-19,
"n_2022_05_20" BIGINT -- 2022-05-20,
"n_2022_05_21" BIGINT -- 2022-05-21,
"n_2022_05_23" BIGINT -- 2022-05-23,
"n_2022_05_24" BIGINT -- 2022-05-24,
"n_2022_05_25" BIGINT -- 2022-05-25,
"n_2022_05_26" BIGINT -- 2022-05-26,
"n_2022_05_27" BIGINT -- 2022-05-27,
"n_2022_05_28" BIGINT -- 2022-05-28,
"n_2022_05_29" BIGINT -- 2022-05-29,
"n_2022_05_30" BIGINT -- 2022-05-30,
"n_2022_05_31" BIGINT -- 2022-05-31,
"n_2022_06_01" BIGINT -- 2022-06-01,
"n_2022_06_02" BIGINT -- 2022-06-02,
"n_2022_06_03" BIGINT -- 2022-06-03,
"n_2022_06_04" BIGINT -- 2022-06-04,
"n_2022_06_05" BIGINT -- 2022-06-05,
"n_2022_06_06" BIGINT -- 2022-06-06,
"n_2022_06_07" BIGINT -- 2022-06-07,
"n_2022_06_08" BIGINT -- 2022-06-08,
"n_2022_06_09" BIGINT -- 2022-06-09,
"n_2022_06_10" BIGINT -- 2022-06-10,
"n_2022_06_11" BIGINT -- 2022-06-11,
"n_2022_06_12" BIGINT -- 2022-06-12,
"n_2022_06_13" BIGINT -- 2022-06-13,
"n_2022_06_14" BIGINT -- 2022-06-14,
"n_2022_06_15" BIGINT -- 2022-06-15,
"n_2022_06_16" BIGINT -- 2022-06-16,
"n_2022_06_17" BIGINT -- 2022-06-17,
"n_2022_06_18" BIGINT -- 2022-06-18,
"n_2022_06_19" BIGINT -- 2022-06-19,
"n_2022_06_20" BIGINT -- 2022-06-20,
"n_2022_06_21" BIGINT -- 2022-06-21,
"n_2022_06_22" BIGINT -- 2022-06-22,
"n_2022_06_23" BIGINT -- 2022-06-23,
"n_2022_06_24" BIGINT -- 2022-06-24,
"n_2022_06_25" BIGINT -- 2022-06-25,
"n_2022_06_26" BIGINT -- 2022-06-26,
"n_2022_06_27" BIGINT -- 2022-06-27,
"n_2022_06_28" BIGINT -- 2022-06-28,
"n_2022_06_29" BIGINT -- 2022-06-29,
"n_2022_06_30" BIGINT -- 2022-06-30,
"n_2022_07_01" BIGINT -- 2022-07-01,
"n_2022_07_02" BIGINT -- 2022-07-02,
"n_2022_07_03" BIGINT -- 2022-07-03,
"n_2022_07_04" BIGINT -- 2022-07-04,
"n_2022_07_05" BIGINT -- 2022-07-05,
"n_2022_07_06" BIGINT -- 2022-07-06,
"n_2022_07_07" BIGINT -- 2022-07-07,
"n_2022_07_08" BIGINT -- 2022-07-08,
"n_2022_07_09" BIGINT -- 2022-07-09,
"n_2022_07_10" BIGINT -- 2022-07-10,
"n_2022_07_11" BIGINT -- 2022-07-11,
"n_2022_07_12" BIGINT -- 2022-07-12,
"n_2022_07_13" BIGINT -- 2022-07-13,
"n_2022_07_14" BIGINT -- 2022-07-14,
"n_2022_07_15" BIGINT -- 2022-07-15,
"n_2022_07_16" BIGINT -- 2022-07-16,
"n_2022_07_17" BIGINT -- 2022-07-17,
"n_2022_07_18" BIGINT -- 2022-07-18,
"n_2022_07_19" BIGINT -- 2022-07-19,
"n_2022_07_20" BIGINT -- 2022-07-20,
"n_2022_07_21" BIGINT -- 2022-07-21,
"n_2022_07_22" BIGINT -- 2022-07-22,
"n_2022_07_23" BIGINT -- 2022-07-23,
"n_2022_07_24" BIGINT -- 2022-07-24,
"n_2022_07_25" BIGINT -- 2022-07-25,
"n_2022_07_26" BIGINT -- 2022-07-26,
"n_2022_07_27" BIGINT -- 2022-07-27,
"n_2022_07_28" BIGINT -- 2022-07-28,
"n_2022_07_29" BIGINT -- 2022-07-29,
"n_2022_07_30" BIGINT -- 2022-07-30,
"n_2022_07_31" BIGINT -- 2022-07-31,
"n_2022_08_01" BIGINT -- 2022-08-01,
"n_2022_08_02" BIGINT -- 2022-08-02,
"n_2022_08_03" BIGINT -- 2022-08-03,
"n_2022_08_04" BIGINT -- 2022-08-04,
"n_2022_08_05" BIGINT -- 2022-08-05,
"n_2022_08_06" BIGINT -- 2022-08-06,
"n_2022_08_07" BIGINT -- 2022-08-07,
"n_2022_08_08" BIGINT -- 2022-08-08,
"n_2022_08_09" BIGINT -- 2022-08-09,
"n_2022_08_10" BIGINT -- 2022-08-10,
"n_2022_08_11" BIGINT -- 2022-08-11
);CREATE TABLE monkey_pox_cases_worldwide (
"country" VARCHAR,
"confirmed_cases" DOUBLE,
"suspected_cases" DOUBLE,
"hospitalized" DOUBLE,
"travel_history_yes" DOUBLE,
"travel_history_no" DOUBLE
);CREATE TABLE worldwide_case_detection_timeline (
"date_confirmation" TIMESTAMP,
"country" VARCHAR,
"city" VARCHAR,
"age" VARCHAR,
"gender" VARCHAR,
"symptoms" VARCHAR,
"hospitalised_y_n_na" VARCHAR -- Hospitalised (Y/N/NA),
"isolated_y_n_na" VARCHAR -- Isolated (Y/N/NA),
"travel_history_y_n_na" VARCHAR -- Travel History (Y/N/NA)
);Anyone who has the link will be able to view this.