Baselight
Sign In

COVID-19 Data From John Hopkins University

Updated daily at 6am UTC in both raw and convenient form

@kaggle.antgoldbloom_covid19_data_from_john_hopkins_university

Loading...
Loading...

About this Dataset

COVID-19 Data From John Hopkins University

This is a daily updating version of COVID-19 Data Repository by the Center for Systems Science and Engineering (CSSE) at Johns Hopkins University (JHU). The data updates every day at 6am UTC, which updates just after the raw JHU data typically updates.

I'm making it available in both a raw form (files with the prefix RAW) and convenient form (files prefixed with CONVENIENT).

The data covers:

  • confirmed cases and deaths on a country level
  • confirmed cases and deaths by US county
  • some metadata that's available in the raw JHU data

The RAW version is exactly as it's distributed in the original dataset.

The CONVENIENT version is aiming to be easier to analyze. The data is organized by column rather than by row. The metadata is stripped out into a separate file. And it converted to daily change rather than cumulative totals.

If you find any issues in the data, then you can share them in this discussion thread. I will attempt to address the most upvoted issues.

If you have any requests for changing or enriching this data, please add them on this discussion thread. Again, I will attempt to address the most upvoted requests.

I have a notebook that updates just after each data dump updates, giving a brief overview of the latest data. It's also a useful reference if you want to see how to read the CONVENIENT data into a pandas DataFrame.

Tables

Convenient Global Confirmed Cases

@kaggle.antgoldbloom_covid19_data_from_john_hopkins_university.convenient_global_confirmed_cases
  • 909.41 kB
  • 1,143 rows
  • 290 columns
Loading... 
CREATE TABLE convenient_global_confirmed_cases (
  "country_region" VARCHAR,
  "afghanistan" DOUBLE,
  "albania" DOUBLE,
  "algeria" DOUBLE,
  "andorra" DOUBLE,
  "angola" DOUBLE,
  "antarctica" DOUBLE,
  "antigua_and_barbuda" DOUBLE,
  "argentina" DOUBLE,
  "armenia" DOUBLE,
  "australia" VARCHAR,
  "australia_1" VARCHAR,
  "australia_2" VARCHAR,
  "australia_3" VARCHAR,
  "australia_4" VARCHAR,
  "australia_5" VARCHAR,
  "australia_6" VARCHAR,
  "australia_7" VARCHAR,
  "austria" DOUBLE,
  "azerbaijan" DOUBLE,
  "bahamas" DOUBLE,
  "bahrain" DOUBLE,
  "bangladesh" DOUBLE,
  "barbados" DOUBLE,
  "belarus" DOUBLE,
  "belgium" DOUBLE,
  "belize" DOUBLE,
  "benin" DOUBLE,
  "bhutan" DOUBLE,
  "bolivia" DOUBLE,
  "bosnia_and_herzegovina" DOUBLE,
  "botswana" DOUBLE,
  "brazil" DOUBLE,
  "brunei" DOUBLE,
  "bulgaria" DOUBLE,
  "burkina_faso" DOUBLE,
  "burma" DOUBLE,
  "burundi" DOUBLE,
  "cabo_verde" DOUBLE,
  "cambodia" DOUBLE,
  "cameroon" DOUBLE,
  "canada" VARCHAR,
  "canada_1" VARCHAR,
  "canada_2" VARCHAR,
  "canada_3" VARCHAR,
  "canada_4" VARCHAR,
  "canada_5" VARCHAR,
  "canada_6" VARCHAR,
  "canada_7" VARCHAR,
  "canada_8" VARCHAR,
  "canada_9" VARCHAR,
  "canada_10" VARCHAR,
  "canada_11" VARCHAR,
  "canada_12" VARCHAR,
  "canada_13" VARCHAR,
  "canada_14" VARCHAR,
  "canada_15" VARCHAR,
  "central_african_republic" DOUBLE,
  "chad" DOUBLE,
  "chile" DOUBLE,
  "china" VARCHAR,
  "china_1" VARCHAR,
  "china_2" VARCHAR,
  "china_3" VARCHAR,
  "china_4" VARCHAR,
  "china_5" VARCHAR,
  "china_6" VARCHAR,
  "china_7" VARCHAR,
  "china_8" VARCHAR,
  "china_9" VARCHAR,
  "china_10" VARCHAR,
  "china_11" VARCHAR,
  "china_12" VARCHAR,
  "china_13" VARCHAR,
  "china_14" VARCHAR,
  "china_15" VARCHAR,
  "china_16" VARCHAR,
  "china_17" VARCHAR,
  "china_18" VARCHAR,
  "china_19" VARCHAR,
  "china_20" VARCHAR,
  "china_21" VARCHAR,
  "china_22" VARCHAR,
  "china_23" VARCHAR,
  "china_24" VARCHAR,
  "china_25" VARCHAR,
  "china_26" VARCHAR,
  "china_27" VARCHAR,
  "china_28" VARCHAR,
  "china_29" VARCHAR,
  "china_30" VARCHAR,
  "china_31" VARCHAR,
  "china_32" VARCHAR,
  "china_33" VARCHAR,
  "colombia" DOUBLE,
  "comoros" DOUBLE,
  "congo_brazzaville" DOUBLE  -- Congo (Brazzaville),
  "congo_kinshasa" DOUBLE  -- Congo (Kinshasa),
  "costa_rica" DOUBLE,
  "cote_d_ivoire" DOUBLE  -- Cote D\u0027Ivoire
);

Convenient Global Deaths

@kaggle.antgoldbloom_covid19_data_from_john_hopkins_university.convenient_global_deaths
  • 401.02 kB
  • 1,143 rows
  • 290 columns
Loading... 
CREATE TABLE convenient_global_deaths (
  "country_region" VARCHAR,
  "afghanistan" DOUBLE,
  "albania" DOUBLE,
  "algeria" DOUBLE,
  "andorra" DOUBLE,
  "angola" DOUBLE,
  "antarctica" DOUBLE,
  "antigua_and_barbuda" DOUBLE,
  "argentina" DOUBLE,
  "armenia" DOUBLE,
  "australia" VARCHAR,
  "australia_1" VARCHAR,
  "australia_2" VARCHAR,
  "australia_3" VARCHAR,
  "australia_4" VARCHAR,
  "australia_5" VARCHAR,
  "australia_6" VARCHAR,
  "australia_7" VARCHAR,
  "austria" DOUBLE,
  "azerbaijan" DOUBLE,
  "bahamas" DOUBLE,
  "bahrain" DOUBLE,
  "bangladesh" DOUBLE,
  "barbados" DOUBLE,
  "belarus" DOUBLE,
  "belgium" DOUBLE,
  "belize" DOUBLE,
  "benin" DOUBLE,
  "bhutan" DOUBLE,
  "bolivia" DOUBLE,
  "bosnia_and_herzegovina" DOUBLE,
  "botswana" DOUBLE,
  "brazil" DOUBLE,
  "brunei" DOUBLE,
  "bulgaria" DOUBLE,
  "burkina_faso" DOUBLE,
  "burma" DOUBLE,
  "burundi" DOUBLE,
  "cabo_verde" DOUBLE,
  "cambodia" DOUBLE,
  "cameroon" DOUBLE,
  "canada" VARCHAR,
  "canada_1" VARCHAR,
  "canada_2" VARCHAR,
  "canada_3" VARCHAR,
  "canada_4" VARCHAR,
  "canada_5" VARCHAR,
  "canada_6" VARCHAR,
  "canada_7" VARCHAR,
  "canada_8" VARCHAR,
  "canada_9" VARCHAR,
  "canada_10" VARCHAR,
  "canada_11" VARCHAR,
  "canada_12" VARCHAR,
  "canada_13" VARCHAR,
  "canada_14" VARCHAR,
  "canada_15" VARCHAR,
  "central_african_republic" DOUBLE,
  "chad" DOUBLE,
  "chile" DOUBLE,
  "china" VARCHAR,
  "china_1" VARCHAR,
  "china_2" VARCHAR,
  "china_3" VARCHAR,
  "china_4" VARCHAR,
  "china_5" VARCHAR,
  "china_6" VARCHAR,
  "china_7" VARCHAR,
  "china_8" VARCHAR,
  "china_9" VARCHAR,
  "china_10" VARCHAR,
  "china_11" VARCHAR,
  "china_12" VARCHAR,
  "china_13" VARCHAR,
  "china_14" VARCHAR,
  "china_15" VARCHAR,
  "china_16" VARCHAR,
  "china_17" VARCHAR,
  "china_18" VARCHAR,
  "china_19" VARCHAR,
  "china_20" VARCHAR,
  "china_21" VARCHAR,
  "china_22" VARCHAR,
  "china_23" VARCHAR,
  "china_24" VARCHAR,
  "china_25" VARCHAR,
  "china_26" VARCHAR,
  "china_27" VARCHAR,
  "china_28" VARCHAR,
  "china_29" VARCHAR,
  "china_30" VARCHAR,
  "china_31" VARCHAR,
  "china_32" VARCHAR,
  "china_33" VARCHAR,
  "colombia" DOUBLE,
  "comoros" DOUBLE,
  "congo_brazzaville" DOUBLE  -- Congo (Brazzaville),
  "congo_kinshasa" DOUBLE  -- Congo (Kinshasa),
  "costa_rica" DOUBLE,
  "cote_d_ivoire" DOUBLE  -- Cote D\u0027Ivoire
);

Convenient Global Metadata

@kaggle.antgoldbloom_covid19_data_from_john_hopkins_university.convenient_global_metadata
  • 12.08 kB
  • 289 rows
  • 4 columns
Loading... 
CREATE TABLE convenient_global_metadata (
  "country_region" VARCHAR,
  "province_state" VARCHAR,
  "lat" DOUBLE,
  "long" DOUBLE
);

Convenient Us Confirmed Cases

@kaggle.antgoldbloom_covid19_data_from_john_hopkins_university.convenient_us_confirmed_cases
  • 7.38 MB
  • 1,143 rows
  • 3,343 columns
Loading... 
CREATE TABLE convenient_us_confirmed_cases (
  "province_state" VARCHAR,
  "alabama" VARCHAR,
  "alabama_1" VARCHAR,
  "alabama_2" VARCHAR,
  "alabama_3" VARCHAR,
  "alabama_4" VARCHAR,
  "alabama_5" VARCHAR,
  "alabama_6" VARCHAR,
  "alabama_7" VARCHAR,
  "alabama_8" VARCHAR,
  "alabama_9" VARCHAR,
  "alabama_10" VARCHAR,
  "alabama_11" VARCHAR,
  "alabama_12" VARCHAR,
  "alabama_13" VARCHAR,
  "alabama_14" VARCHAR,
  "alabama_15" VARCHAR,
  "alabama_16" VARCHAR,
  "alabama_17" VARCHAR,
  "alabama_18" VARCHAR,
  "alabama_19" VARCHAR,
  "alabama_20" VARCHAR,
  "alabama_21" VARCHAR,
  "alabama_22" VARCHAR,
  "alabama_23" VARCHAR,
  "alabama_24" VARCHAR,
  "alabama_25" VARCHAR,
  "alabama_26" VARCHAR,
  "alabama_27" VARCHAR,
  "alabama_28" VARCHAR,
  "alabama_29" VARCHAR,
  "alabama_30" VARCHAR,
  "alabama_31" VARCHAR,
  "alabama_32" VARCHAR,
  "alabama_33" VARCHAR,
  "alabama_34" VARCHAR,
  "alabama_35" VARCHAR,
  "alabama_36" VARCHAR,
  "alabama_37" VARCHAR,
  "alabama_38" VARCHAR,
  "alabama_39" VARCHAR,
  "alabama_40" VARCHAR,
  "alabama_41" VARCHAR,
  "alabama_42" VARCHAR,
  "alabama_43" VARCHAR,
  "alabama_44" VARCHAR,
  "alabama_45" VARCHAR,
  "alabama_46" VARCHAR,
  "alabama_47" VARCHAR,
  "alabama_48" VARCHAR,
  "alabama_49" VARCHAR,
  "alabama_50" VARCHAR,
  "alabama_51" VARCHAR,
  "alabama_52" VARCHAR,
  "alabama_53" VARCHAR,
  "alabama_54" VARCHAR,
  "alabama_55" VARCHAR,
  "alabama_56" VARCHAR,
  "alabama_57" VARCHAR,
  "alabama_58" VARCHAR,
  "alabama_59" VARCHAR,
  "alabama_60" VARCHAR,
  "alabama_61" VARCHAR,
  "alabama_62" VARCHAR,
  "alabama_63" VARCHAR,
  "alabama_64" VARCHAR,
  "alabama_65" VARCHAR,
  "alabama_66" VARCHAR,
  "alabama_67" VARCHAR,
  "alabama_68" VARCHAR,
  "alaska" VARCHAR,
  "alaska_1" VARCHAR,
  "alaska_2" VARCHAR,
  "alaska_3" VARCHAR,
  "alaska_4" VARCHAR,
  "alaska_5" VARCHAR,
  "alaska_6" VARCHAR,
  "alaska_7" VARCHAR,
  "alaska_8" VARCHAR,
  "alaska_9" VARCHAR,
  "alaska_10" VARCHAR,
  "alaska_11" VARCHAR,
  "alaska_12" VARCHAR,
  "alaska_13" VARCHAR,
  "alaska_14" VARCHAR,
  "alaska_15" VARCHAR,
  "alaska_16" VARCHAR,
  "alaska_17" VARCHAR,
  "alaska_18" VARCHAR,
  "alaska_19" VARCHAR,
  "alaska_20" VARCHAR,
  "alaska_21" VARCHAR,
  "alaska_22" VARCHAR,
  "alaska_23" VARCHAR,
  "alaska_24" VARCHAR,
  "alaska_25" VARCHAR,
  "alaska_26" VARCHAR,
  "alaska_27" VARCHAR,
  "alaska_28" VARCHAR,
  "alaska_29" VARCHAR
);

Convenient Us Deaths

@kaggle.antgoldbloom_covid19_data_from_john_hopkins_university.convenient_us_deaths
  • 3.83 MB
  • 1,143 rows
  • 3,343 columns
Loading... 
CREATE TABLE convenient_us_deaths (
  "province_state" VARCHAR,
  "alabama" VARCHAR,
  "alabama_1" VARCHAR,
  "alabama_2" VARCHAR,
  "alabama_3" VARCHAR,
  "alabama_4" VARCHAR,
  "alabama_5" VARCHAR,
  "alabama_6" VARCHAR,
  "alabama_7" VARCHAR,
  "alabama_8" VARCHAR,
  "alabama_9" VARCHAR,
  "alabama_10" VARCHAR,
  "alabama_11" VARCHAR,
  "alabama_12" VARCHAR,
  "alabama_13" VARCHAR,
  "alabama_14" VARCHAR,
  "alabama_15" VARCHAR,
  "alabama_16" VARCHAR,
  "alabama_17" VARCHAR,
  "alabama_18" VARCHAR,
  "alabama_19" VARCHAR,
  "alabama_20" VARCHAR,
  "alabama_21" VARCHAR,
  "alabama_22" VARCHAR,
  "alabama_23" VARCHAR,
  "alabama_24" VARCHAR,
  "alabama_25" VARCHAR,
  "alabama_26" VARCHAR,
  "alabama_27" VARCHAR,
  "alabama_28" VARCHAR,
  "alabama_29" VARCHAR,
  "alabama_30" VARCHAR,
  "alabama_31" VARCHAR,
  "alabama_32" VARCHAR,
  "alabama_33" VARCHAR,
  "alabama_34" VARCHAR,
  "alabama_35" VARCHAR,
  "alabama_36" VARCHAR,
  "alabama_37" VARCHAR,
  "alabama_38" VARCHAR,
  "alabama_39" VARCHAR,
  "alabama_40" VARCHAR,
  "alabama_41" VARCHAR,
  "alabama_42" VARCHAR,
  "alabama_43" VARCHAR,
  "alabama_44" VARCHAR,
  "alabama_45" VARCHAR,
  "alabama_46" VARCHAR,
  "alabama_47" VARCHAR,
  "alabama_48" VARCHAR,
  "alabama_49" VARCHAR,
  "alabama_50" VARCHAR,
  "alabama_51" VARCHAR,
  "alabama_52" VARCHAR,
  "alabama_53" VARCHAR,
  "alabama_54" VARCHAR,
  "alabama_55" VARCHAR,
  "alabama_56" VARCHAR,
  "alabama_57" VARCHAR,
  "alabama_58" VARCHAR,
  "alabama_59" VARCHAR,
  "alabama_60" VARCHAR,
  "alabama_61" VARCHAR,
  "alabama_62" VARCHAR,
  "alabama_63" VARCHAR,
  "alabama_64" VARCHAR,
  "alabama_65" VARCHAR,
  "alabama_66" VARCHAR,
  "alabama_67" VARCHAR,
  "alabama_68" VARCHAR,
  "alaska" VARCHAR,
  "alaska_1" VARCHAR,
  "alaska_2" VARCHAR,
  "alaska_3" VARCHAR,
  "alaska_4" VARCHAR,
  "alaska_5" VARCHAR,
  "alaska_6" VARCHAR,
  "alaska_7" VARCHAR,
  "alaska_8" VARCHAR,
  "alaska_9" VARCHAR,
  "alaska_10" VARCHAR,
  "alaska_11" VARCHAR,
  "alaska_12" VARCHAR,
  "alaska_13" VARCHAR,
  "alaska_14" VARCHAR,
  "alaska_15" VARCHAR,
  "alaska_16" VARCHAR,
  "alaska_17" VARCHAR,
  "alaska_18" VARCHAR,
  "alaska_19" VARCHAR,
  "alaska_20" VARCHAR,
  "alaska_21" VARCHAR,
  "alaska_22" VARCHAR,
  "alaska_23" VARCHAR,
  "alaska_24" VARCHAR,
  "alaska_25" VARCHAR,
  "alaska_26" VARCHAR,
  "alaska_27" VARCHAR,
  "alaska_28" VARCHAR,
  "alaska_29" VARCHAR
);

Convenient Us Metadata

@kaggle.antgoldbloom_covid19_data_from_john_hopkins_university.convenient_us_metadata
  • 107.29 kB
  • 3,342 rows
  • 5 columns
Loading... 
CREATE TABLE convenient_us_metadata (
  "province_state" VARCHAR,
  "admin2" VARCHAR,
  "population" BIGINT,
  "lat" DOUBLE,
  "long" DOUBLE
);

Raw Global Confirmed Cases

@kaggle.antgoldbloom_covid19_data_from_john_hopkins_university.raw_global_confirmed_cases
  • 2.61 MB
  • 289 rows
  • 1,147 columns
Loading... 
CREATE TABLE raw_global_confirmed_cases (
  "country_region" VARCHAR,
  "province_state" VARCHAR,
  "lat" DOUBLE,
  "long" DOUBLE,
  "n_1_22_20" BIGINT  -- 1/22/20,
  "n_1_23_20" BIGINT  -- 1/23/20,
  "n_1_24_20" BIGINT  -- 1/24/20,
  "n_1_25_20" BIGINT  -- 1/25/20,
  "n_1_26_20" BIGINT  -- 1/26/20,
  "n_1_27_20" BIGINT  -- 1/27/20,
  "n_1_28_20" BIGINT  -- 1/28/20,
  "n_1_29_20" BIGINT  -- 1/29/20,
  "n_1_30_20" BIGINT  -- 1/30/20,
  "n_1_31_20" BIGINT  -- 1/31/20,
  "n_2_1_20" BIGINT  -- 2/1/20,
  "n_2_2_20" BIGINT  -- 2/2/20,
  "n_2_3_20" BIGINT  -- 2/3/20,
  "n_2_4_20" BIGINT  -- 2/4/20,
  "n_2_5_20" BIGINT  -- 2/5/20,
  "n_2_6_20" BIGINT  -- 2/6/20,
  "n_2_7_20" BIGINT  -- 2/7/20,
  "n_2_8_20" BIGINT  -- 2/8/20,
  "n_2_9_20" BIGINT  -- 2/9/20,
  "n_2_10_20" BIGINT  -- 2/10/20,
  "n_2_11_20" BIGINT  -- 2/11/20,
  "n_2_12_20" BIGINT  -- 2/12/20,
  "n_2_13_20" BIGINT  -- 2/13/20,
  "n_2_14_20" BIGINT  -- 2/14/20,
  "n_2_15_20" BIGINT  -- 2/15/20,
  "n_2_16_20" BIGINT  -- 2/16/20,
  "n_2_17_20" BIGINT  -- 2/17/20,
  "n_2_18_20" BIGINT  -- 2/18/20,
  "n_2_19_20" BIGINT  -- 2/19/20,
  "n_2_20_20" BIGINT  -- 2/20/20,
  "n_2_21_20" BIGINT  -- 2/21/20,
  "n_2_22_20" BIGINT  -- 2/22/20,
  "n_2_23_20" BIGINT  -- 2/23/20,
  "n_2_24_20" BIGINT  -- 2/24/20,
  "n_2_25_20" BIGINT  -- 2/25/20,
  "n_2_26_20" BIGINT  -- 2/26/20,
  "n_2_27_20" BIGINT  -- 2/27/20,
  "n_2_28_20" BIGINT  -- 2/28/20,
  "n_2_29_20" BIGINT  -- 2/29/20,
  "n_3_1_20" BIGINT  -- 3/1/20,
  "n_3_2_20" BIGINT  -- 3/2/20,
  "n_3_3_20" BIGINT  -- 3/3/20,
  "n_3_4_20" BIGINT  -- 3/4/20,
  "n_3_5_20" BIGINT  -- 3/5/20,
  "n_3_6_20" BIGINT  -- 3/6/20,
  "n_3_7_20" BIGINT  -- 3/7/20,
  "n_3_8_20" BIGINT  -- 3/8/20,
  "n_3_9_20" BIGINT  -- 3/9/20,
  "n_3_10_20" BIGINT  -- 3/10/20,
  "n_3_11_20" BIGINT  -- 3/11/20,
  "n_3_12_20" BIGINT  -- 3/12/20,
  "n_3_13_20" BIGINT  -- 3/13/20,
  "n_3_14_20" BIGINT  -- 3/14/20,
  "n_3_15_20" BIGINT  -- 3/15/20,
  "n_3_16_20" BIGINT  -- 3/16/20,
  "n_3_17_20" BIGINT  -- 3/17/20,
  "n_3_18_20" BIGINT  -- 3/18/20,
  "n_3_19_20" BIGINT  -- 3/19/20,
  "n_3_20_20" BIGINT  -- 3/20/20,
  "n_3_21_20" BIGINT  -- 3/21/20,
  "n_3_22_20" BIGINT  -- 3/22/20,
  "n_3_23_20" BIGINT  -- 3/23/20,
  "n_3_24_20" BIGINT  -- 3/24/20,
  "n_3_25_20" BIGINT  -- 3/25/20,
  "n_3_26_20" BIGINT  -- 3/26/20,
  "n_3_27_20" BIGINT  -- 3/27/20,
  "n_3_28_20" BIGINT  -- 3/28/20,
  "n_3_29_20" BIGINT  -- 3/29/20,
  "n_3_30_20" BIGINT  -- 3/30/20,
  "n_3_31_20" BIGINT  -- 3/31/20,
  "n_4_1_20" BIGINT  -- 4/1/20,
  "n_4_2_20" BIGINT  -- 4/2/20,
  "n_4_3_20" BIGINT  -- 4/3/20,
  "n_4_4_20" BIGINT  -- 4/4/20,
  "n_4_5_20" BIGINT  -- 4/5/20,
  "n_4_6_20" BIGINT  -- 4/6/20,
  "n_4_7_20" BIGINT  -- 4/7/20,
  "n_4_8_20" BIGINT  -- 4/8/20,
  "n_4_9_20" BIGINT  -- 4/9/20,
  "n_4_10_20" BIGINT  -- 4/10/20,
  "n_4_11_20" BIGINT  -- 4/11/20,
  "n_4_12_20" BIGINT  -- 4/12/20,
  "n_4_13_20" BIGINT  -- 4/13/20,
  "n_4_14_20" BIGINT  -- 4/14/20,
  "n_4_15_20" BIGINT  -- 4/15/20,
  "n_4_16_20" BIGINT  -- 4/16/20,
  "n_4_17_20" BIGINT  -- 4/17/20,
  "n_4_18_20" BIGINT  -- 4/18/20,
  "n_4_19_20" BIGINT  -- 4/19/20,
  "n_4_20_20" BIGINT  -- 4/20/20,
  "n_4_21_20" BIGINT  -- 4/21/20,
  "n_4_22_20" BIGINT  -- 4/22/20,
  "n_4_23_20" BIGINT  -- 4/23/20,
  "n_4_24_20" BIGINT  -- 4/24/20,
  "n_4_25_20" BIGINT  -- 4/25/20,
  "n_4_26_20" BIGINT  -- 4/26/20
);

Raw Global Deaths

@kaggle.antgoldbloom_covid19_data_from_john_hopkins_university.raw_global_deaths
  • 2.08 MB
  • 289 rows
  • 1,147 columns
Loading... 
CREATE TABLE raw_global_deaths (
  "country_region" VARCHAR,
  "province_state" VARCHAR,
  "lat" DOUBLE,
  "long" DOUBLE,
  "n_1_22_20" BIGINT  -- 1/22/20,
  "n_1_23_20" BIGINT  -- 1/23/20,
  "n_1_24_20" BIGINT  -- 1/24/20,
  "n_1_25_20" BIGINT  -- 1/25/20,
  "n_1_26_20" BIGINT  -- 1/26/20,
  "n_1_27_20" BIGINT  -- 1/27/20,
  "n_1_28_20" BIGINT  -- 1/28/20,
  "n_1_29_20" BIGINT  -- 1/29/20,
  "n_1_30_20" BIGINT  -- 1/30/20,
  "n_1_31_20" BIGINT  -- 1/31/20,
  "n_2_1_20" BIGINT  -- 2/1/20,
  "n_2_2_20" BIGINT  -- 2/2/20,
  "n_2_3_20" BIGINT  -- 2/3/20,
  "n_2_4_20" BIGINT  -- 2/4/20,
  "n_2_5_20" BIGINT  -- 2/5/20,
  "n_2_6_20" BIGINT  -- 2/6/20,
  "n_2_7_20" BIGINT  -- 2/7/20,
  "n_2_8_20" BIGINT  -- 2/8/20,
  "n_2_9_20" BIGINT  -- 2/9/20,
  "n_2_10_20" BIGINT  -- 2/10/20,
  "n_2_11_20" BIGINT  -- 2/11/20,
  "n_2_12_20" BIGINT  -- 2/12/20,
  "n_2_13_20" BIGINT  -- 2/13/20,
  "n_2_14_20" BIGINT  -- 2/14/20,
  "n_2_15_20" BIGINT  -- 2/15/20,
  "n_2_16_20" BIGINT  -- 2/16/20,
  "n_2_17_20" BIGINT  -- 2/17/20,
  "n_2_18_20" BIGINT  -- 2/18/20,
  "n_2_19_20" BIGINT  -- 2/19/20,
  "n_2_20_20" BIGINT  -- 2/20/20,
  "n_2_21_20" BIGINT  -- 2/21/20,
  "n_2_22_20" BIGINT  -- 2/22/20,
  "n_2_23_20" BIGINT  -- 2/23/20,
  "n_2_24_20" BIGINT  -- 2/24/20,
  "n_2_25_20" BIGINT  -- 2/25/20,
  "n_2_26_20" BIGINT  -- 2/26/20,
  "n_2_27_20" BIGINT  -- 2/27/20,
  "n_2_28_20" BIGINT  -- 2/28/20,
  "n_2_29_20" BIGINT  -- 2/29/20,
  "n_3_1_20" BIGINT  -- 3/1/20,
  "n_3_2_20" BIGINT  -- 3/2/20,
  "n_3_3_20" BIGINT  -- 3/3/20,
  "n_3_4_20" BIGINT  -- 3/4/20,
  "n_3_5_20" BIGINT  -- 3/5/20,
  "n_3_6_20" BIGINT  -- 3/6/20,
  "n_3_7_20" BIGINT  -- 3/7/20,
  "n_3_8_20" BIGINT  -- 3/8/20,
  "n_3_9_20" BIGINT  -- 3/9/20,
  "n_3_10_20" BIGINT  -- 3/10/20,
  "n_3_11_20" BIGINT  -- 3/11/20,
  "n_3_12_20" BIGINT  -- 3/12/20,
  "n_3_13_20" BIGINT  -- 3/13/20,
  "n_3_14_20" BIGINT  -- 3/14/20,
  "n_3_15_20" BIGINT  -- 3/15/20,
  "n_3_16_20" BIGINT  -- 3/16/20,
  "n_3_17_20" BIGINT  -- 3/17/20,
  "n_3_18_20" BIGINT  -- 3/18/20,
  "n_3_19_20" BIGINT  -- 3/19/20,
  "n_3_20_20" BIGINT  -- 3/20/20,
  "n_3_21_20" BIGINT  -- 3/21/20,
  "n_3_22_20" BIGINT  -- 3/22/20,
  "n_3_23_20" BIGINT  -- 3/23/20,
  "n_3_24_20" BIGINT  -- 3/24/20,
  "n_3_25_20" BIGINT  -- 3/25/20,
  "n_3_26_20" BIGINT  -- 3/26/20,
  "n_3_27_20" BIGINT  -- 3/27/20,
  "n_3_28_20" BIGINT  -- 3/28/20,
  "n_3_29_20" BIGINT  -- 3/29/20,
  "n_3_30_20" BIGINT  -- 3/30/20,
  "n_3_31_20" BIGINT  -- 3/31/20,
  "n_4_1_20" BIGINT  -- 4/1/20,
  "n_4_2_20" BIGINT  -- 4/2/20,
  "n_4_3_20" BIGINT  -- 4/3/20,
  "n_4_4_20" BIGINT  -- 4/4/20,
  "n_4_5_20" BIGINT  -- 4/5/20,
  "n_4_6_20" BIGINT  -- 4/6/20,
  "n_4_7_20" BIGINT  -- 4/7/20,
  "n_4_8_20" BIGINT  -- 4/8/20,
  "n_4_9_20" BIGINT  -- 4/9/20,
  "n_4_10_20" BIGINT  -- 4/10/20,
  "n_4_11_20" BIGINT  -- 4/11/20,
  "n_4_12_20" BIGINT  -- 4/12/20,
  "n_4_13_20" BIGINT  -- 4/13/20,
  "n_4_14_20" BIGINT  -- 4/14/20,
  "n_4_15_20" BIGINT  -- 4/15/20,
  "n_4_16_20" BIGINT  -- 4/16/20,
  "n_4_17_20" BIGINT  -- 4/17/20,
  "n_4_18_20" BIGINT  -- 4/18/20,
  "n_4_19_20" BIGINT  -- 4/19/20,
  "n_4_20_20" BIGINT  -- 4/20/20,
  "n_4_21_20" BIGINT  -- 4/21/20,
  "n_4_22_20" BIGINT  -- 4/22/20,
  "n_4_23_20" BIGINT  -- 4/23/20,
  "n_4_24_20" BIGINT  -- 4/24/20,
  "n_4_25_20" BIGINT  -- 4/25/20,
  "n_4_26_20" BIGINT  -- 4/26/20
);

Raw Us Confirmed Cases

@kaggle.antgoldbloom_covid19_data_from_john_hopkins_university.raw_us_confirmed_cases
  • 17.64 MB
  • 3,342 rows
  • 1,154 columns
Loading... 
CREATE TABLE raw_us_confirmed_cases (
  "province_state" VARCHAR,
  "admin2" VARCHAR,
  "uid" BIGINT,
  "iso2" VARCHAR,
  "iso3" VARCHAR,
  "code3" BIGINT,
  "fips" DOUBLE,
  "country_region" VARCHAR,
  "lat" DOUBLE,
  "long" DOUBLE,
  "combined_key" VARCHAR,
  "n_1_22_20" BIGINT  -- 1/22/20,
  "n_1_23_20" BIGINT  -- 1/23/20,
  "n_1_24_20" BIGINT  -- 1/24/20,
  "n_1_25_20" BIGINT  -- 1/25/20,
  "n_1_26_20" BIGINT  -- 1/26/20,
  "n_1_27_20" BIGINT  -- 1/27/20,
  "n_1_28_20" BIGINT  -- 1/28/20,
  "n_1_29_20" BIGINT  -- 1/29/20,
  "n_1_30_20" BIGINT  -- 1/30/20,
  "n_1_31_20" BIGINT  -- 1/31/20,
  "n_2_1_20" BIGINT  -- 2/1/20,
  "n_2_2_20" BIGINT  -- 2/2/20,
  "n_2_3_20" BIGINT  -- 2/3/20,
  "n_2_4_20" BIGINT  -- 2/4/20,
  "n_2_5_20" BIGINT  -- 2/5/20,
  "n_2_6_20" BIGINT  -- 2/6/20,
  "n_2_7_20" BIGINT  -- 2/7/20,
  "n_2_8_20" BIGINT  -- 2/8/20,
  "n_2_9_20" BIGINT  -- 2/9/20,
  "n_2_10_20" BIGINT  -- 2/10/20,
  "n_2_11_20" BIGINT  -- 2/11/20,
  "n_2_12_20" BIGINT  -- 2/12/20,
  "n_2_13_20" BIGINT  -- 2/13/20,
  "n_2_14_20" BIGINT  -- 2/14/20,
  "n_2_15_20" BIGINT  -- 2/15/20,
  "n_2_16_20" BIGINT  -- 2/16/20,
  "n_2_17_20" BIGINT  -- 2/17/20,
  "n_2_18_20" BIGINT  -- 2/18/20,
  "n_2_19_20" BIGINT  -- 2/19/20,
  "n_2_20_20" BIGINT  -- 2/20/20,
  "n_2_21_20" BIGINT  -- 2/21/20,
  "n_2_22_20" BIGINT  -- 2/22/20,
  "n_2_23_20" BIGINT  -- 2/23/20,
  "n_2_24_20" BIGINT  -- 2/24/20,
  "n_2_25_20" BIGINT  -- 2/25/20,
  "n_2_26_20" BIGINT  -- 2/26/20,
  "n_2_27_20" BIGINT  -- 2/27/20,
  "n_2_28_20" BIGINT  -- 2/28/20,
  "n_2_29_20" BIGINT  -- 2/29/20,
  "n_3_1_20" BIGINT  -- 3/1/20,
  "n_3_2_20" BIGINT  -- 3/2/20,
  "n_3_3_20" BIGINT  -- 3/3/20,
  "n_3_4_20" BIGINT  -- 3/4/20,
  "n_3_5_20" BIGINT  -- 3/5/20,
  "n_3_6_20" BIGINT  -- 3/6/20,
  "n_3_7_20" BIGINT  -- 3/7/20,
  "n_3_8_20" BIGINT  -- 3/8/20,
  "n_3_9_20" BIGINT  -- 3/9/20,
  "n_3_10_20" BIGINT  -- 3/10/20,
  "n_3_11_20" BIGINT  -- 3/11/20,
  "n_3_12_20" BIGINT  -- 3/12/20,
  "n_3_13_20" BIGINT  -- 3/13/20,
  "n_3_14_20" BIGINT  -- 3/14/20,
  "n_3_15_20" BIGINT  -- 3/15/20,
  "n_3_16_20" BIGINT  -- 3/16/20,
  "n_3_17_20" BIGINT  -- 3/17/20,
  "n_3_18_20" BIGINT  -- 3/18/20,
  "n_3_19_20" BIGINT  -- 3/19/20,
  "n_3_20_20" BIGINT  -- 3/20/20,
  "n_3_21_20" BIGINT  -- 3/21/20,
  "n_3_22_20" BIGINT  -- 3/22/20,
  "n_3_23_20" BIGINT  -- 3/23/20,
  "n_3_24_20" BIGINT  -- 3/24/20,
  "n_3_25_20" BIGINT  -- 3/25/20,
  "n_3_26_20" BIGINT  -- 3/26/20,
  "n_3_27_20" BIGINT  -- 3/27/20,
  "n_3_28_20" BIGINT  -- 3/28/20,
  "n_3_29_20" BIGINT  -- 3/29/20,
  "n_3_30_20" BIGINT  -- 3/30/20,
  "n_3_31_20" BIGINT  -- 3/31/20,
  "n_4_1_20" BIGINT  -- 4/1/20,
  "n_4_2_20" BIGINT  -- 4/2/20,
  "n_4_3_20" BIGINT  -- 4/3/20,
  "n_4_4_20" BIGINT  -- 4/4/20,
  "n_4_5_20" BIGINT  -- 4/5/20,
  "n_4_6_20" BIGINT  -- 4/6/20,
  "n_4_7_20" BIGINT  -- 4/7/20,
  "n_4_8_20" BIGINT  -- 4/8/20,
  "n_4_9_20" BIGINT  -- 4/9/20,
  "n_4_10_20" BIGINT  -- 4/10/20,
  "n_4_11_20" BIGINT  -- 4/11/20,
  "n_4_12_20" BIGINT  -- 4/12/20,
  "n_4_13_20" BIGINT  -- 4/13/20,
  "n_4_14_20" BIGINT  -- 4/14/20,
  "n_4_15_20" BIGINT  -- 4/15/20,
  "n_4_16_20" BIGINT  -- 4/16/20,
  "n_4_17_20" BIGINT  -- 4/17/20,
  "n_4_18_20" BIGINT  -- 4/18/20,
  "n_4_19_20" BIGINT  -- 4/19/20
);

Raw Us Deaths

@kaggle.antgoldbloom_covid19_data_from_john_hopkins_university.raw_us_deaths
  • 7.66 MB
  • 3,342 rows
  • 1,155 columns
Loading... 
CREATE TABLE raw_us_deaths (
  "province_state" VARCHAR,
  "admin2" VARCHAR,
  "uid" BIGINT,
  "iso2" VARCHAR,
  "iso3" VARCHAR,
  "code3" BIGINT,
  "fips" DOUBLE,
  "country_region" VARCHAR,
  "lat" DOUBLE,
  "long" DOUBLE,
  "combined_key" VARCHAR,
  "population" BIGINT,
  "n_1_22_20" BIGINT  -- 1/22/20,
  "n_1_23_20" BIGINT  -- 1/23/20,
  "n_1_24_20" BIGINT  -- 1/24/20,
  "n_1_25_20" BIGINT  -- 1/25/20,
  "n_1_26_20" BIGINT  -- 1/26/20,
  "n_1_27_20" BIGINT  -- 1/27/20,
  "n_1_28_20" BIGINT  -- 1/28/20,
  "n_1_29_20" BIGINT  -- 1/29/20,
  "n_1_30_20" BIGINT  -- 1/30/20,
  "n_1_31_20" BIGINT  -- 1/31/20,
  "n_2_1_20" BIGINT  -- 2/1/20,
  "n_2_2_20" BIGINT  -- 2/2/20,
  "n_2_3_20" BIGINT  -- 2/3/20,
  "n_2_4_20" BIGINT  -- 2/4/20,
  "n_2_5_20" BIGINT  -- 2/5/20,
  "n_2_6_20" BIGINT  -- 2/6/20,
  "n_2_7_20" BIGINT  -- 2/7/20,
  "n_2_8_20" BIGINT  -- 2/8/20,
  "n_2_9_20" BIGINT  -- 2/9/20,
  "n_2_10_20" BIGINT  -- 2/10/20,
  "n_2_11_20" BIGINT  -- 2/11/20,
  "n_2_12_20" BIGINT  -- 2/12/20,
  "n_2_13_20" BIGINT  -- 2/13/20,
  "n_2_14_20" BIGINT  -- 2/14/20,
  "n_2_15_20" BIGINT  -- 2/15/20,
  "n_2_16_20" BIGINT  -- 2/16/20,
  "n_2_17_20" BIGINT  -- 2/17/20,
  "n_2_18_20" BIGINT  -- 2/18/20,
  "n_2_19_20" BIGINT  -- 2/19/20,
  "n_2_20_20" BIGINT  -- 2/20/20,
  "n_2_21_20" BIGINT  -- 2/21/20,
  "n_2_22_20" BIGINT  -- 2/22/20,
  "n_2_23_20" BIGINT  -- 2/23/20,
  "n_2_24_20" BIGINT  -- 2/24/20,
  "n_2_25_20" BIGINT  -- 2/25/20,
  "n_2_26_20" BIGINT  -- 2/26/20,
  "n_2_27_20" BIGINT  -- 2/27/20,
  "n_2_28_20" BIGINT  -- 2/28/20,
  "n_2_29_20" BIGINT  -- 2/29/20,
  "n_3_1_20" BIGINT  -- 3/1/20,
  "n_3_2_20" BIGINT  -- 3/2/20,
  "n_3_3_20" BIGINT  -- 3/3/20,
  "n_3_4_20" BIGINT  -- 3/4/20,
  "n_3_5_20" BIGINT  -- 3/5/20,
  "n_3_6_20" BIGINT  -- 3/6/20,
  "n_3_7_20" BIGINT  -- 3/7/20,
  "n_3_8_20" BIGINT  -- 3/8/20,
  "n_3_9_20" BIGINT  -- 3/9/20,
  "n_3_10_20" BIGINT  -- 3/10/20,
  "n_3_11_20" BIGINT  -- 3/11/20,
  "n_3_12_20" BIGINT  -- 3/12/20,
  "n_3_13_20" BIGINT  -- 3/13/20,
  "n_3_14_20" BIGINT  -- 3/14/20,
  "n_3_15_20" BIGINT  -- 3/15/20,
  "n_3_16_20" BIGINT  -- 3/16/20,
  "n_3_17_20" BIGINT  -- 3/17/20,
  "n_3_18_20" BIGINT  -- 3/18/20,
  "n_3_19_20" BIGINT  -- 3/19/20,
  "n_3_20_20" BIGINT  -- 3/20/20,
  "n_3_21_20" BIGINT  -- 3/21/20,
  "n_3_22_20" BIGINT  -- 3/22/20,
  "n_3_23_20" BIGINT  -- 3/23/20,
  "n_3_24_20" BIGINT  -- 3/24/20,
  "n_3_25_20" BIGINT  -- 3/25/20,
  "n_3_26_20" BIGINT  -- 3/26/20,
  "n_3_27_20" BIGINT  -- 3/27/20,
  "n_3_28_20" BIGINT  -- 3/28/20,
  "n_3_29_20" BIGINT  -- 3/29/20,
  "n_3_30_20" BIGINT  -- 3/30/20,
  "n_3_31_20" BIGINT  -- 3/31/20,
  "n_4_1_20" BIGINT  -- 4/1/20,
  "n_4_2_20" BIGINT  -- 4/2/20,
  "n_4_3_20" BIGINT  -- 4/3/20,
  "n_4_4_20" BIGINT  -- 4/4/20,
  "n_4_5_20" BIGINT  -- 4/5/20,
  "n_4_6_20" BIGINT  -- 4/6/20,
  "n_4_7_20" BIGINT  -- 4/7/20,
  "n_4_8_20" BIGINT  -- 4/8/20,
  "n_4_9_20" BIGINT  -- 4/9/20,
  "n_4_10_20" BIGINT  -- 4/10/20,
  "n_4_11_20" BIGINT  -- 4/11/20,
  "n_4_12_20" BIGINT  -- 4/12/20,
  "n_4_13_20" BIGINT  -- 4/13/20,
  "n_4_14_20" BIGINT  -- 4/14/20,
  "n_4_15_20" BIGINT  -- 4/15/20,
  "n_4_16_20" BIGINT  -- 4/16/20,
  "n_4_17_20" BIGINT  -- 4/17/20,
  "n_4_18_20" BIGINT  -- 4/18/20
);

Share link

Anyone who has the link will be able to view this.