Baselight

Covid-data

COVID-19 WORLD DATA collected from github.com

@kaggle.nonstochastic147_coviddata

Time Series Covid19 Deaths Us
@kaggle.nonstochastic147_coviddata.time_series_covid19_deaths_us

  • 249.62 KB
  • 3253 rows
  • 89 columns
uid

UID

iso2

Iso2

iso3

Iso3

code3

Code3

fips

FIPS

admin2

Admin2

province_state

Province State

country_region

Country Region

lat

Lat

long

Long

combined_key

Combined Key

population

Population

n_1_22_20

1/22/20

n_1_23_20

1/23/20

n_1_24_20

1/24/20

n_1_25_20

1/25/20

n_1_26_20

1/26/20

n_1_27_20

1/27/20

n_1_28_20

1/28/20

n_1_29_20

1/29/20

n_1_30_20

1/30/20

n_1_31_20

1/31/20

n_2_1_20

2/1/20

n_2_2_20

2/2/20

n_2_3_20

2/3/20

n_2_4_20

2/4/20

n_2_5_20

2/5/20

n_2_6_20

2/6/20

n_2_7_20

2/7/20

n_2_8_20

2/8/20

n_2_9_20

2/9/20

n_2_10_20

2/10/20

n_2_11_20

2/11/20

n_2_12_20

2/12/20

n_2_13_20

2/13/20

n_2_14_20

2/14/20

n_2_15_20

2/15/20

n_2_16_20

2/16/20

n_2_17_20

2/17/20

n_2_18_20

2/18/20

n_2_19_20

2/19/20

n_2_20_20

2/20/20

n_2_21_20

2/21/20

n_2_22_20

2/22/20

n_2_23_20

2/23/20

n_2_24_20

2/24/20

n_2_25_20

2/25/20

n_2_26_20

2/26/20

n_2_27_20

2/27/20

n_2_28_20

2/28/20

n_2_29_20

2/29/20

n_3_1_20

3/1/20

n_3_2_20

3/2/20

n_3_3_20

3/3/20

n_3_4_20

3/4/20

n_3_5_20

3/5/20

n_3_6_20

3/6/20

n_3_7_20

3/7/20

n_3_8_20

3/8/20

n_3_9_20

3/9/20

n_3_10_20

3/10/20

n_3_11_20

3/11/20

n_3_12_20

3/12/20

n_3_13_20

3/13/20

n_3_14_20

3/14/20

n_3_15_20

3/15/20

n_3_16_20

3/16/20

n_3_17_20

3/17/20

n_3_18_20

3/18/20

n_3_19_20

3/19/20

n_3_20_20

3/20/20

n_3_21_20

3/21/20

n_3_22_20

3/22/20

n_3_23_20

3/23/20

n_3_24_20

3/24/20

n_3_25_20

3/25/20

n_3_26_20

3/26/20

n_3_27_20

3/27/20

n_3_28_20

3/28/20

n_3_29_20

3/29/20

n_3_30_20

3/30/20

n_3_31_20

3/31/20

n_4_1_20

4/1/20

n_4_2_20

4/2/20

n_4_3_20

4/3/20

n_4_4_20

4/4/20

n_4_5_20

4/5/20

n_4_6_20

4/6/20

n_4_7_20

4/7/20

16ASASM1660nanAmerican SamoaUS-14.271-170.132American Samoa, US55641
316GUGUM31666nanGuamUS13.4443144.7937Guam, US16422911111111123344444
580MPMNP58069nanNorthern Mariana IslandsUS15.0979145.6739Northern Mariana Islands, US551441111111
630PRPRI63072nanPuerto RicoUS18.2208-66.5901Puerto Rico, US29334081122223336811121518202123
850VIVIR85078nanVirgin IslandsUS18.3358-64.8963Virgin Islands, US107268111
84001001USUSA8401001AutaugaAlabamaUS32.53952745-86.64408227Autauga, Alabama, US558691
84001003USUSA8401003BaldwinAlabamaUS30.72774991-87.72207058Baldwin, Alabama, US2232341111111111
84001005USUSA8401005BarbourAlabamaUS31.868263-85.3871286Barbour, Alabama, US24686
84001007USUSA8401007BibbAlabamaUS32.99642064-87.12511459999996Bibb, Alabama, US22394
84001009USUSA8401009BlountAlabamaUS33.98210918-86.56790593Blount, Alabama, US57826

CREATE TABLE time_series_covid19_deaths_us (
  "uid" BIGINT,
  "iso2" VARCHAR,
  "iso3" VARCHAR,
  "code3" BIGINT,
  "fips" DOUBLE,
  "admin2" VARCHAR,
  "province_state" VARCHAR,
  "country_region" VARCHAR,
  "lat" DOUBLE,
  "long" DOUBLE,
  "combined_key" VARCHAR,
  "population" BIGINT,
  "n_1_22_20" BIGINT,
  "n_1_23_20" BIGINT,
  "n_1_24_20" BIGINT,
  "n_1_25_20" BIGINT,
  "n_1_26_20" BIGINT,
  "n_1_27_20" BIGINT,
  "n_1_28_20" BIGINT,
  "n_1_29_20" BIGINT,
  "n_1_30_20" BIGINT,
  "n_1_31_20" BIGINT,
  "n_2_1_20" BIGINT,
  "n_2_2_20" BIGINT,
  "n_2_3_20" BIGINT,
  "n_2_4_20" BIGINT,
  "n_2_5_20" BIGINT,
  "n_2_6_20" BIGINT,
  "n_2_7_20" BIGINT,
  "n_2_8_20" BIGINT,
  "n_2_9_20" BIGINT,
  "n_2_10_20" BIGINT,
  "n_2_11_20" BIGINT,
  "n_2_12_20" BIGINT,
  "n_2_13_20" BIGINT,
  "n_2_14_20" BIGINT,
  "n_2_15_20" BIGINT,
  "n_2_16_20" BIGINT,
  "n_2_17_20" BIGINT,
  "n_2_18_20" BIGINT,
  "n_2_19_20" BIGINT,
  "n_2_20_20" BIGINT,
  "n_2_21_20" BIGINT,
  "n_2_22_20" BIGINT,
  "n_2_23_20" BIGINT,
  "n_2_24_20" BIGINT,
  "n_2_25_20" BIGINT,
  "n_2_26_20" BIGINT,
  "n_2_27_20" BIGINT,
  "n_2_28_20" BIGINT,
  "n_2_29_20" BIGINT,
  "n_3_1_20" BIGINT,
  "n_3_2_20" BIGINT,
  "n_3_3_20" BIGINT,
  "n_3_4_20" BIGINT,
  "n_3_5_20" BIGINT,
  "n_3_6_20" BIGINT,
  "n_3_7_20" BIGINT,
  "n_3_8_20" BIGINT,
  "n_3_9_20" BIGINT,
  "n_3_10_20" BIGINT,
  "n_3_11_20" BIGINT,
  "n_3_12_20" BIGINT,
  "n_3_13_20" BIGINT,
  "n_3_14_20" BIGINT,
  "n_3_15_20" BIGINT,
  "n_3_16_20" BIGINT,
  "n_3_17_20" BIGINT,
  "n_3_18_20" BIGINT,
  "n_3_19_20" BIGINT,
  "n_3_20_20" BIGINT,
  "n_3_21_20" BIGINT,
  "n_3_22_20" BIGINT,
  "n_3_23_20" BIGINT,
  "n_3_24_20" BIGINT,
  "n_3_25_20" BIGINT,
  "n_3_26_20" BIGINT,
  "n_3_27_20" BIGINT,
  "n_3_28_20" BIGINT,
  "n_3_29_20" BIGINT,
  "n_3_30_20" BIGINT,
  "n_3_31_20" BIGINT,
  "n_4_1_20" BIGINT,
  "n_4_2_20" BIGINT,
  "n_4_3_20" BIGINT,
  "n_4_4_20" BIGINT,
  "n_4_5_20" BIGINT,
  "n_4_6_20" BIGINT,
  "n_4_7_20" BIGINT
);

Share link

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