Overview

This notebook will show you how to create and query a table or DataFrame that you uploaded to DBFS. DBFS is a Databricks File System that allows you to store data for querying inside of Databricks. This notebook assumes that you have a file already inside of DBFS that you would like to read from.

This notebook is written in Python so the default cell type is Python. However, you can use different languages by using the %LANGUAGE syntax. Python, Scala, SQL, and R are all supported.


In [2]:
# File location and type
file_location = "/FileStore/tables/covid_19_spread-6c970.csv"
file_type = "csv"

# CSV options
infer_schema = "true"
first_row_is_header = "true"
delimiter = ","

# The applied options are for CSV files. For other file types, these will be ignored.
df = spark.read.format(file_type) \
  .option("inferSchema", infer_schema) \
  .option("header", first_row_is_header) \
  .option("sep", delimiter) \
  .load(file_location)

display(df)


countrydatesince_1st_confirmed_n_dayssince_100th_confirmed_n_dayssince_1st_recovered_n_dayssince_100th_recovered_n_dayssince_1st_deaths_n_dayssince_10th_deaths_n_daysconfirmed_n_lag_7drecovered_n_lag_7ddeaths_n_lag_7dactive_n_lag_7dconfirmed_n_lag_8drecovered_n_lag_8ddeaths_n_lag_8dactive_n_lag_8dconfirmed_n_lag_9drecovered_n_lag_9ddeaths_n_lag_9dactive_n_lag_9dconfirmed_n_lag_10drecovered_n_lag_10ddeaths_n_lag_10dactive_n_lag_10dlabel
Afghanistan2020-02-0100000000000000000000000
Albania2020-02-0100000000000000000000000
Algeria2020-02-0100000000000000000000000
Andorra2020-02-0100000000000000000000000
Argentina2020-02-0100000000000000000000000
Armenia2020-02-0100000000000000000000000
Australia2020-02-01602000000000000000000012
Austria2020-02-0100000000000000000000000
Azerbaijan2020-02-0100000000000000000000000
Bangladesh2020-02-0100000000000000000000000
Belarus2020-02-0100000000000000000000000
Belgium2020-02-0100000000000000000000000
Bosnia and Herzegovina2020-02-0100000000000000000000000
Brazil2020-02-0100000000000000000000000
Bulgaria2020-02-0100000000000000000000000
Burkina Faso2020-02-0100000000000000000000000
Cameroon2020-02-0100000000000000000000000
Canada2020-02-0160000000000000000000004
Chile2020-02-0100000000000000000000000
China2020-02-011010104101014063942132592036268586433018595548281750311891
Colombia2020-02-0100000000000000000000000
Cote d'Ivoire2020-02-0100000000000000000000000
Croatia2020-02-0100000000000000000000000
Cuba2020-02-0100000000000000000000000
Czechia2020-02-0100000000000000000000000
Denmark2020-02-0100000000000000000000000
Diamond Princess2020-02-0100000000000000000000000
Dominican Republic2020-02-0100000000000000000000000
Ecuador2020-02-0100000000000000000000000
Egypt2020-02-0100000000000000000000000
Estonia2020-02-0100000000000000000000000
Finland2020-02-0130000000000000000000001
France2020-02-0180000030032002000000006
Germany2020-02-0150000000000000000000008
Greece2020-02-0100000000000000000000000
Hungary2020-02-0100000000000000000000000
Iceland2020-02-0100000000000000000000000
India2020-02-0120000000000000000000001
Indonesia2020-02-0100000000000000000000000
Iran2020-02-0100000000000000000000000
Iraq2020-02-0100000000000000000000000
Ireland2020-02-0100000000000000000000000
Israel2020-02-0100000000000000000000000
Italy2020-02-0110000000000000000000002
Japan2020-02-011006000200220022002200220
Kazakhstan2020-02-0100000000000000000000000
Korea South2020-02-0110000002002200210011001
Kuwait2020-02-0100000000000000000000000
Latvia2020-02-0100000000000000000000000
Lebanon2020-02-0100000000000000000000000
Lithuania2020-02-0100000000000000000000000
Luxembourg2020-02-0100000000000000000000000
Malaysia2020-02-0170000030030000000000008
Mexico2020-02-0100000000000000000000000
Moldova2020-02-0100000000000000000000000
Morocco2020-02-0100000000000000000000000
Netherlands2020-02-0100000000000000000000000
New Zealand2020-02-0100000000000000000000000
Niger2020-02-0100000000000000000000000
Nigeria2020-02-0100000000000000000000000
North Macedonia2020-02-0100000000000000000000000
Pakistan2020-02-0100000000000000000000000
Panama2020-02-0100000000000000000000000
Peru2020-02-0100000000000000000000000
Philippines2020-02-0120000000000000000000001
Poland2020-02-0100000000000000000000000
Portugal2020-02-0100000000000000000000000
Qatar2020-02-0100000000000000000000000
Romania2020-02-0100000000000000000000000
Russia2020-02-0110000000000000000000002
Saudi Arabia2020-02-0100000000000000000000000
Serbia2020-02-0100000000000000000000000
Singapore2020-02-01900000300330031001000016
Slovakia2020-02-0100000000000000000000000
Slovenia2020-02-0100000000000000000000000
South Africa2020-02-0100000000000000000000000
Spain2020-02-0100000000000000000000001
Sweden2020-02-0110000000000000000000001
Switzerland2020-02-0100000000000000000000000
Thailand2020-02-011006000700750053003200219
Tunisia2020-02-0100000000000000000000000
Turkey2020-02-0100000000000000000000000
Ukraine2020-02-0100000000000000000000000
United Arab Emirates2020-02-0130000000000000000000004
United Kingdom2020-02-0110000000000000000000002
Uruguay2020-02-0100000000000000000000000
US2020-02-01100000020022002100110018
Venezuela2020-02-0100000000000000000000000
Afghanistan2020-02-0200000000000000000000000
Albania2020-02-0200000000000000000000000
Algeria2020-02-0200000000000000000000000
Andorra2020-02-0200000000000000000000000
Argentina2020-02-0200000000000000000000000
Armenia2020-02-0200000000000000000000000
Australia2020-02-02703000400400000000000012
Austria2020-02-0200000000000000000000000
Azerbaijan2020-02-0200000000000000000000000
Bangladesh2020-02-0200000000000000000000000
Belarus2020-02-0200000000000000000000000
Belgium2020-02-0200000000000000000000000
Bosnia and Herzegovina2020-02-0200000000000000000000000
Brazil2020-02-0200000000000000000000000
Bulgaria2020-02-0200000000000000000000000
Burkina Faso2020-02-0200000000000000000000000
Cameroon2020-02-0200000000000000000000000
Canada2020-02-0270000010010000000000004
Chile2020-02-0200000000000000000000000
China2020-02-02111111511112075495619701406394213259203626858643301859516630
Colombia2020-02-0200000000000000000000000
Cote d'Ivoire2020-02-0200000000000000000000000
Croatia2020-02-0200000000000000000000000
Cuba2020-02-0200000000000000000000000
Czechia2020-02-0200000000000000000000000
Denmark2020-02-0200000000000000000000000
Diamond Princess2020-02-0200000000000000000000000
Dominican Republic2020-02-0200000000000000000000000
Ecuador2020-02-0200000000000000000000000
Egypt2020-02-0200000000000000000000000
Estonia2020-02-0200000000000000000000000
Finland2020-02-0240000000000000000000001
France2020-02-0290000030033003200200006
Germany2020-02-02600000000000000000000010
Greece2020-02-0200000000000000000000000
Hungary2020-02-0200000000000000000000000
Iceland2020-02-0200000000000000000000000
India2020-02-0230000000000000000000002
Indonesia2020-02-0200000000000000000000000
Iran2020-02-0200000000000000000000000
Iraq2020-02-0200000000000000000000000
Ireland2020-02-0200000000000000000000000
Israel2020-02-0200000000000000000000000
Italy2020-02-0220000000000000000000002
Japan2020-02-021107000410320022002200220
Kazakhstan2020-02-0200000000000000000000000
Korea South2020-02-0211000003003200220021001
Kuwait2020-02-0200000000000000000000000
Latvia2020-02-0200000000000000000000000
Lebanon2020-02-0200000000000000000000000
Lithuania2020-02-0200000000000000000000000
Luxembourg2020-02-0200000000000000000000000
Malaysia2020-02-0280000040043003000000008
Mexico2020-02-0200000000000000000000000
Moldova2020-02-0200000000000000000000000
Morocco2020-02-0200000000000000000000000
Netherlands2020-02-0200000000000000000000000
New Zealand2020-02-0200000000000000000000000
Niger2020-02-0200000000000000000000000
Nigeria2020-02-0200000000000000000000000
North Macedonia2020-02-0200000000000000000000000
Pakistan2020-02-0200000000000000000000000
Panama2020-02-0200000000000000000000000
Peru2020-02-0200000000000000000000000
Philippines2020-02-0230000000000000000000002
Poland2020-02-0200000000000000000000000
Portugal2020-02-0200000000000000000000000
Qatar2020-02-0200000000000000000000000
Romania2020-02-0200000000000000000000000
Russia2020-02-0220000000000000000000002
Saudi Arabia2020-02-0200000000000000000000000
Serbia2020-02-0200000000000000000000000
Singapore2020-02-021000000400430033003100118
Slovakia2020-02-0200000000000000000000000
Slovenia2020-02-0200000000000000000000000
South Africa2020-02-0200000000000000000000000
Spain2020-02-0210000000000000000000001
Sweden2020-02-0220000000000000000000001
Switzerland2020-02-0200000000000000000000000
Thailand2020-02-021107000820670075005300319
Tunisia2020-02-0200000000000000000000000
Turkey2020-02-0200000000000000000000000
Ukraine2020-02-0200000000000000000000000
United Arab Emirates2020-02-0240000000000000000000005
United Kingdom2020-02-0220000000000000000000002
Uruguay2020-02-0200000000000000000000000
US2020-02-02110000050052002200210018
Venezuela2020-02-0200000000000000000000000
Afghanistan2020-02-0300000000000000000000000
Albania2020-02-0300000000000000000000000
Algeria2020-02-0300000000000000000000000
Andorra2020-02-0300000000000000000000000
Argentina2020-02-0300000000000000000000000
Armenia2020-02-0300000000000000000000000
Australia2020-02-03804000500540040000000012
Austria2020-02-0300000000000000000000000
Azerbaijan2020-02-0300000000000000000000000
Bangladesh2020-02-0300000000000000000000000
Belarus2020-02-0300000000000000000000000
Belgium2020-02-0300000000000000000000000
Bosnia and Herzegovina2020-02-0300000000000000000000000
Brazil2020-02-0300000000000000000000000
Bulgaria2020-02-0300000000000000000000000
Burkina Faso2020-02-0300000000000000000000000
Cameroon2020-02-0300000000000000000000000
Canada2020-02-0380000010011001000000004
Chile2020-02-0300000000000000000000000
China2020-02-0312121261212287758822737207549561970140639421325920362685819716
Colombia2020-02-0300000000000000000000000
Cote d'Ivoire2020-02-0300000000000000000000000
Croatia2020-02-0300000000000000000000000
Cuba2020-02-0300000000000000000000000
Czechia2020-02-0300000000000000000000000
Denmark2020-02-0300000000000000000000000
Diamond Princess2020-02-0300000000000000000000000
Dominican Republic2020-02-0300000000000000000000000
Ecuador2020-02-0300000000000000000000000
Egypt2020-02-0300000000000000000000000
Estonia2020-02-0300000000000000000000000
Finland2020-02-0350000000000000000000001
France2020-02-03100000030033003300320026
Germany2020-02-03700000100100000000000012
Greece2020-02-0300000000000000000000000
Hungary2020-02-0300000000000000000000000
Iceland2020-02-0300000000000000000000000
India2020-02-0340000000000000000000003
Indonesia2020-02-0300000000000000000000000
Iran2020-02-0300000000000000000000000
Iraq2020-02-0300000000000000000000000
Ireland2020-02-0300000000000000000000000
Israel2020-02-0300000000000000000000000
Italy2020-02-0330000000000000000000002
Japan2020-02-031208000410341032002200220
Kazakhstan2020-02-0300000000000000000000000
Korea South2020-02-0312000004004300320022002
Kuwait2020-02-0300000000000000000000000
Latvia2020-02-0300000000000000000000000
Lebanon2020-02-0300000000000000000000000
Lithuania2020-02-0300000000000000000000000
Luxembourg2020-02-0300000000000000000000000
Malaysia2020-02-0390000040044004300300008
Mexico2020-02-0300000000000000000000000
Moldova2020-02-0300000000000000000000000
Morocco2020-02-0300000000000000000000000
Netherlands2020-02-0300000000000000000000000
New Zealand2020-02-0300000000000000000000000
Niger2020-02-0300000000000000000000000
Nigeria2020-02-0300000000000000000000000
North Macedonia2020-02-0300000000000000000000000
Pakistan2020-02-0300000000000000000000000
Panama2020-02-0300000000000000000000000
Peru2020-02-0300000000000000000000000
Philippines2020-02-0340001000000000000000002
Poland2020-02-0300000000000000000000000
Portugal2020-02-0300000000000000000000000
Qatar2020-02-0300000000000000000000000
Romania2020-02-0300000000000000000000000
Russia2020-02-0330000000000000000000002
Saudi Arabia2020-02-0300000000000000000000000
Serbia2020-02-0300000000000000000000000
Singapore2020-02-031100000500540043003300318
Slovakia2020-02-0300000000000000000000000
Slovenia2020-02-0300000000000000000000000
South Africa2020-02-0300000000000000000000000
Spain2020-02-0320000000000000000000001
Sweden2020-02-0330000000000000000000001
Switzerland2020-02-0300000000000000000000000
Thailand2020-02-031208000820682067007500519
Tunisia2020-02-0300000000000000000000000
Turkey2020-02-0300000000000000000000000
Ukraine2020-02-0300000000000000000000000
United Arab Emirates2020-02-0350000000000000000000005
United Kingdom2020-02-0330000000000000000000002
Uruguay2020-02-0300000000000000000000000
US2020-02-031200000500550052002200211
Venezuela2020-02-0300000000000000000000000
Afghanistan2020-02-0400000000000000000000000
Albania2020-02-0400000000000000000000000
Algeria2020-02-0400000000000000000000000
Andorra2020-02-0400000000000000000000000
Argentina2020-02-0400000000000000000000000
Armenia2020-02-0400000000000000000000000
Australia2020-02-04905000500550054004000013
Austria2020-02-0400000000000000000000000
Azerbaijan2020-02-0400000000000000000000000
Bangladesh2020-02-0400000000000000000000000
Belarus2020-02-0400000000000000000000000
Belgium2020-02-0400000000000000000000001
Bosnia and Herzegovina2020-02-0400000000000000000000000
Brazil2020-02-0400000000000000000000000
Bulgaria2020-02-0400000000000000000000000
Burkina Faso2020-02-0400000000000000000000000
Cameroon2020-02-0400000000000000000000000
Canada2020-02-0490000020021001100100004
Chile2020-02-0400000000000000000000000
China2020-02-04131313713135509101131527728775882273720754956197014063942132523707
Colombia2020-02-0400000000000000000000000
Cote d'Ivoire2020-02-0400000000000000000000000
Croatia2020-02-0400000000000000000000000
Cuba2020-02-0400000000000000000000000
Czechia2020-02-0400000000000000000000000
Denmark2020-02-0400000000000000000000000
Diamond Princess2020-02-0400000000000000000000000
Dominican Republic2020-02-0400000000000000000000000
Ecuador2020-02-0400000000000000000000000
Egypt2020-02-0400000000000000000000000
Estonia2020-02-0400000000000000000000000
Finland2020-02-0460000000000000000000001
France2020-02-04110000040043003300330036
Germany2020-02-04800000400410010000000012
Greece2020-02-0400000000000000000000000
Hungary2020-02-0400000000000000000000000
Iceland2020-02-0400000000000000000000000
India2020-02-0450000000000000000000003
Indonesia2020-02-0400000000000000000000000
Iran2020-02-0400000000000000000000000
Iraq2020-02-0400000000000000000000000
Ireland2020-02-0400000000000000000000000
Israel2020-02-0400000000000000000000000
Italy2020-02-0440000000000000000000002
Japan2020-02-041309000710641034103200222
Kazakhstan2020-02-0400000000000000000000000
Korea South2020-02-0413000004004400430032002
Kuwait2020-02-0400000000000000000000000
Latvia2020-02-0400000000000000000000000
Lebanon2020-02-0400000000000000000000000
Lithuania2020-02-0400000000000000000000000
Luxembourg2020-02-0400000000000000000000000
Malaysia2020-02-041000000400440044004300310
Mexico2020-02-0400000000000000000000000
Moldova2020-02-0400000000000000000000000
Morocco2020-02-0400000000000000000000000
Netherlands2020-02-0400000000000000000000000
New Zealand2020-02-0400000000000000000000000
Niger2020-02-0400000000000000000000000
Nigeria2020-02-0400000000000000000000000
North Macedonia2020-02-0400000000000000000000000
Pakistan2020-02-0400000000000000000000000
Panama2020-02-0400000000000000000000000
Peru2020-02-0400000000000000000000000
Philippines2020-02-0450002000000000000000002
Poland2020-02-0400000000000000000000000
Portugal2020-02-0400000000000000000000000
Qatar2020-02-0400000000000000000000000
Romania2020-02-0400000000000000000000000
Russia2020-02-0440000000000000000000002
Saudi Arabia2020-02-0400000000000000000000000
Serbia2020-02-0400000000000000000000000
Singapore2020-02-041200000700750054004300324
Slovakia2020-02-0400000000000000000000000
Slovenia2020-02-0400000000000000000000000
South Africa2020-02-0400000000000000000000000
Spain2020-02-0430000000000000000000001
Sweden2020-02-0440000000000000000000001
Switzerland2020-02-0400000000000000000000000
Thailand2020-02-0413090001450982068206700725
Tunisia2020-02-0400000000000000000000000
Turkey2020-02-0400000000000000000000000
Ukraine2020-02-0400000000000000000000000
United Arab Emirates2020-02-0460000000000000000000005
United Kingdom2020-02-0440000000000000000000002
Uruguay2020-02-0400000000000000000000000
US2020-02-041300000500550055005200211
Venezuela2020-02-0400000000000000000000000
Afghanistan2020-02-0500000000000000000000000
Albania2020-02-0500000000000000000000000
Algeria2020-02-0500000000000000000000000
Andorra2020-02-0500000000000000000000000
Argentina2020-02-0500000000000000000000000
Armenia2020-02-0500000000000000000000000
Australia2020-02-051006000600650055005400413
Austria2020-02-0500000000000000000000000
Azerbaijan2020-02-0500000000000000000000000
Bangladesh2020-02-0500000000000000000000000
Belarus2020-02-0500000000000000000000000
Belgium2020-02-0510000000000000000000001
Bosnia and Herzegovina2020-02-0500000000000000000000000
Brazil2020-02-0500000000000000000000000
Bulgaria2020-02-0500000000000000000000000
Burkina Faso2020-02-0500000000000000000000000
Cameroon2020-02-0500000000000000000000000
Canada2020-02-05100000020022002100110015
Chile2020-02-0500000000000000000000000
China2020-02-0514141481414608712013358345509101131527728775882273720754956197027440
Colombia2020-02-0500000000000000000000000
Cote d'Ivoire2020-02-0500000000000000000000000
Croatia2020-02-0500000000000000000000000
Cuba2020-02-0500000000000000000000000
Czechia2020-02-0500000000000000000000000
Denmark2020-02-0500000000000000000000000
Diamond Princess2020-02-0500000000000000000000000
Dominican Republic2020-02-0500000000000000000000000
Ecuador2020-02-0500000000000000000000000
Egypt2020-02-0500000000000000000000000
Estonia2020-02-0500000000000000000000000
Finland2020-02-0570000010010000000000001
France2020-02-05120000050054004300330036
Germany2020-02-05900000400440041001000012
Greece2020-02-0500000000000000000000000
Hungary2020-02-0500000000000000000000000
Iceland2020-02-0500000000000000000000000
India2020-02-0560000000000000000000003
Indonesia2020-02-0500000000000000000000000
Iran2020-02-0500000000000000000000000
Iraq2020-02-0500000000000000000000000
Ireland2020-02-0500000000000000000000000
Israel2020-02-0500000000000000000000000
Italy2020-02-0550000000000000000000002
Japan2020-02-0514010000710671064103410322
Kazakhstan2020-02-0500000000000000000000000
Korea South2020-02-0514000004004400440043003
Kuwait2020-02-0500000000000000000000000
Latvia2020-02-0500000000000000000000000
Lebanon2020-02-0500000000000000000000000
Lithuania2020-02-0500000000000000000000000
Luxembourg2020-02-0500000000000000000000000
Malaysia2020-02-051100000700740044004400412
Mexico2020-02-0500000000000000000000000
Moldova2020-02-0500000000000000000000000
Morocco2020-02-0500000000000000000000000
Netherlands2020-02-0500000000000000000000000
New Zealand2020-02-0500000000000000000000000
Niger2020-02-0500000000000000000000000
Nigeria2020-02-0500000000000000000000000
North Macedonia2020-02-0500000000000000000000000
Pakistan2020-02-0500000000000000000000000
Panama2020-02-0500000000000000000000000
Peru2020-02-0500000000000000000000000
Philippines2020-02-0560003000000000000000002
Poland2020-02-0500000000000000000000000
Portugal2020-02-0500000000000000000000000
Qatar2020-02-0500000000000000000000000
Romania2020-02-0500000000000000000000000
Russia2020-02-0550000000000000000000002
Saudi Arabia2020-02-0500000000000000000000000
Serbia2020-02-0500000000000000000000000
Singapore2020-02-051300000700770075005400428
Slovakia2020-02-0500000000000000000000000
Slovenia2020-02-0500000000000000000000000
South Africa2020-02-0500000000000000000000000
Spain2020-02-0540000000000000000000001
Sweden2020-02-0550000000000000000000001
Switzerland2020-02-0500000000000000000000000
Thailand2020-02-051401000014509145098206820625
Tunisia2020-02-0500000000000000000000000
Turkey2020-02-0500000000000000000000000
Ukraine2020-02-0500000000000000000000000
United Arab Emirates2020-02-0570000040040000000000005
United Kingdom2020-02-0550000000000000000000002
Uruguay2020-02-0500000000000000000000000
US2020-02-051400000500550055005500511
Venezuela2020-02-0500000000000000000000000
Afghanistan2020-02-0600000000000000000000000
Albania2020-02-0600000000000000000000000
Algeria2020-02-0600000000000000000000000
Andorra2020-02-0600000000000000000000000
Argentina2020-02-0600000000000000000000000
Armenia2020-02-0600000000000000000000000
Australia2020-02-061107000920760065005500514
Austria2020-02-0600000000000000000000000
Azerbaijan2020-02-0600000000000000000000000
Bangladesh2020-02-0600000000000000000000000
Belarus2020-02-0600000000000000000000000
Belgium2020-02-0620000000000000000000001
Bosnia and Herzegovina2020-02-0600000000000000000000000
Brazil2020-02-0600000000000000000000000
Bulgaria2020-02-0600000000000000000000000
Burkina Faso2020-02-0600000000000000000000000
Cameroon2020-02-0600000000000000000000000
Canada2020-02-06110000020022002200210015
Chile2020-02-0600000000000000000000000
China2020-02-061515159151581411351717835608712013358345509101131527728775882273730587
Colombia2020-02-0600000000000000000000000
Cote d'Ivoire2020-02-0600000000000000000000000
Croatia2020-02-0600000000000000000000000
Cuba2020-02-0600000000000000000000000
Czechia2020-02-0600000000000000000000000
Denmark2020-02-0600000000000000000000000
Diamond Princess2020-02-0600000000000000000000000
Dominican Republic2020-02-0600000000000000000000000
Ecuador2020-02-0600000000000000000000000
Egypt2020-02-0600000000000000000000000
Estonia2020-02-0600000000000000000000000
Finland2020-02-0680000010011001000000001
France2020-02-06130000050055005400430036
Germany2020-02-061000000400440044004100112
Greece2020-02-0600000000000000000000000
Hungary2020-02-0600000000000000000000000
Iceland2020-02-0600000000000000000000000
India2020-02-0670000010010000000000003
Indonesia2020-02-0600000000000000000000000
Iran2020-02-0600000000000000000000000
Iraq2020-02-0600000000000000000000000
Ireland2020-02-0600000000000000000000000
Israel2020-02-0600000000000000000000000
Italy2020-02-0660000000000000000000002
Japan2020-02-061501100011101071067106410322
Kazakhstan2020-02-0600000000000000000000000
Korea South2020-02-0615000004004400440044004
Kuwait2020-02-0600000000000000000000000
Latvia2020-02-0600000000000000000000000
Lebanon2020-02-0600000000000000000000000
Lithuania2020-02-0600000000000000000000000
Luxembourg2020-02-0600000000000000000000000
Malaysia2020-02-061200000800870074004400412
Mexico2020-02-0600000000000000000000000
Moldova2020-02-0600000000000000000000000
Morocco2020-02-0600000000000000000000000
Netherlands2020-02-0600000000000000000000000
New Zealand2020-02-0600000000000000000000000
Niger2020-02-0600000000000000000000000
Nigeria2020-02-0600000000000000000000000
North Macedonia2020-02-0600000000000000000000000
Pakistan2020-02-0600000000000000000000000
Panama2020-02-0600000000000000000000000
Peru2020-02-0600000000000000000000000
Philippines2020-02-0670004010010000000000002
Poland2020-02-0600000000000000000000000
Portugal2020-02-0600000000000000000000000
Qatar2020-02-0600000000000000000000000
Romania2020-02-0600000000000000000000000
Russia2020-02-0660000000000000000000002
Saudi Arabia2020-02-0600000000000000000000000
Serbia2020-02-0600000000000000000000000
Singapore2020-02-06140000010001070077007500528
Slovakia2020-02-0600000000000000000000000
Slovenia2020-02-0600000000000000000000000
South Africa2020-02-0600000000000000000000000
Spain2020-02-0650000000000000000000001
Sweden2020-02-0660000000000000000000001
Switzerland2020-02-0600000000000000000000000
Thailand2020-02-0615011000145091450914509820625
Tunisia2020-02-0600000000000000000000000
Turkey2020-02-0600000000000000000000000
Ukraine2020-02-0600000000000000000000000
United Arab Emirates2020-02-0680000040044004000000005
United Kingdom2020-02-0660000000000000000000002
Uruguay2020-02-0600000000000000000000000
US2020-02-061500000500550055005500511
Venezuela2020-02-0600000000000000000000000
Afghanistan2020-02-0700000000000000000000000
Albania2020-02-0700000000000000000000000
Algeria2020-02-0700000000000000000000000
Andorra2020-02-0700000000000000000000000
Argentina2020-02-0700000000000000000000000
Armenia2020-02-0700000000000000000000000
Australia2020-02-071208000920792076006500515
Austria2020-02-0700000000000000000000000
Azerbaijan2020-02-0700000000000000000000000
Bangladesh2020-02-0700000000000000000000000
Belarus2020-02-0700000000000000000000000
Belgium2020-02-0730000000000000000000001
Bosnia and Herzegovina2020-02-0700000000000000000000000
Brazil2020-02-0700000000000000000000000
Bulgaria2020-02-0700000000000000000000000
Burkina Faso2020-02-0700000000000000000000000
Cameroon2020-02-0700000000000000000000000
Canada2020-02-07120000040042002200220027
Chile2020-02-0700000000000000000000000
China2020-02-071616161016169802214213937581411351717835608712013358345509101131527734110
Colombia2020-02-0700000000000000000000000
Cote d'Ivoire2020-02-0700000000000000000000000
Croatia2020-02-0700000000000000000000000
Cuba2020-02-0700000000000000000000000
Czechia2020-02-0700000000000000000000000
Denmark2020-02-0700000000000000000000000
Diamond Princess2020-02-07000000000000000000000061
Dominican Republic2020-02-0700000000000000000000000
Ecuador2020-02-0700000000000000000000000
Egypt2020-02-0700000000000000000000000
Estonia2020-02-0700000000000000000000000
Finland2020-02-0790000010011001100100001
France2020-02-07140000050055005500540046
Germany2020-02-071100000500540044004400413
Greece2020-02-0700000000000000000000000
Hungary2020-02-0700000000000000000000000
Iceland2020-02-0700000000000000000000000
India2020-02-0780000010011001000000003
Indonesia2020-02-0700000000000000000000000
Iran2020-02-0700000000000000000000000
Iraq2020-02-0700000000000000000000000
Ireland2020-02-0700000000000000000000000
Israel2020-02-0700000000000000000000000
Italy2020-02-0770000020020000000000003
Japan2020-02-07160120001510141110107106710625
Kazakhstan2020-02-0700000000000000000000000
Korea South2020-02-071600000110011400440044004
Kuwait2020-02-0700000000000000000000000
Latvia2020-02-0700000000000000000000000
Lebanon2020-02-0700000000000000000000000
Lithuania2020-02-0700000000000000000000000
Luxembourg2020-02-0700000000000000000000000
Malaysia2020-02-071300000800880087007400412
Mexico2020-02-0700000000000000000000000
Moldova2020-02-0700000000000000000000000
Morocco2020-02-0700000000000000000000000
Netherlands2020-02-0700000000000000000000000
New Zealand2020-02-0700000000000000000000000
Niger2020-02-0700000000000000000000000
Nigeria2020-02-0700000000000000000000000
North Macedonia2020-02-0700000000000000000000000
Pakistan2020-02-0700000000000000000000000
Panama2020-02-0700000000000000000000000
Peru2020-02-0700000000000000000000000
Philippines2020-02-0780005010011001000000003
Poland2020-02-0700000000000000000000000
Portugal2020-02-0700000000000000000000000
Qatar2020-02-0700000000000000000000000
Romania2020-02-0700000000000000000000000
Russia2020-02-0770000020020000000000002
Saudi Arabia2020-02-0700000000000000000000000
Serbia2020-02-0700000000000000000000000
Singapore2020-02-0715000001300131000107007700730
Slovakia2020-02-0700000000000000000000000
Slovenia2020-02-0700000000000000000000000
South Africa2020-02-0700000000000000000000000
Spain2020-02-0760000000000000000000001
Sweden2020-02-0770000010010000000000001
Switzerland2020-02-0700000000000000000000000
Thailand2020-02-071601200019501414509145091450925
Tunisia2020-02-0700000000000000000000000
Turkey2020-02-0700000000000000000000000
Ukraine2020-02-0700000000000000000000000
United Arab Emirates2020-02-0790000040044004400400005
United Kingdom2020-02-0770000020020000000000003
Uruguay2020-02-0700000000000000000000000
US2020-02-071600000700750055005500511
Venezuela2020-02-0700000000000000000000000
Afghanistan2020-02-0800000000000000000000000
Albania2020-02-0800000000000000000000000
Algeria2020-02-0800000000000000000000000
Andorra2020-02-0800000000000000000000000
Argentina2020-02-0800000000000000000000000
Armenia2020-02-0800000000000000000000000
Australia2020-02-08130900012201092079207600615
Austria2020-02-0800000000000000000000000
Azerbaijan2020-02-0800000000000000000000000
Bangladesh2020-02-0800000000000000000000000
Belarus2020-02-0800000000000000000000000
Belgium2020-02-0840000000000000000000001
Bosnia and Herzegovina2020-02-0800000000000000000000000
Brazil2020-02-0800000000000000000000000
Bulgaria2020-02-0800000000000000000000000
Burkina Faso2020-02-0800000000000000000000000
Cameroon2020-02-0800000000000000000000000
Canada2020-02-08130000040044004200220027
Chile2020-02-0800000000000000000000000
China2020-02-08171717111717118912752591135798022142139375814113517178356087120133583436814
Colombia2020-02-0800000000000000000000000
Cote d'Ivoire2020-02-0800000000000000000000000
Croatia2020-02-0800000000000000000000000
Cuba2020-02-0800000000000000000000000
Czechia2020-02-0800000000000000000000000
Denmark2020-02-0800000000000000000000000
Diamond Princess2020-02-08100000000000000000000061
Dominican Republic2020-02-0800000000000000000000000
Ecuador2020-02-0800000000000000000000000
Egypt2020-02-0800000000000000000000000
Estonia2020-02-0800000000000000000000000
Finland2020-02-08100000010011001100110011
France2020-02-081500000600650055005500511
Germany2020-02-081200000800850054004400413
Greece2020-02-0800000000000000000000000
Hungary2020-02-0800000000000000000000000
Iceland2020-02-0800000000000000000000000
India2020-02-0890000010011001100100003
Indonesia2020-02-0800000000000000000000000
Iran2020-02-0800000000000000000000000
Iraq2020-02-0800000000000000000000000
Ireland2020-02-0800000000000000000000000
Israel2020-02-0800000000000000000000000
Italy2020-02-0880000020022002000000003
Japan2020-02-0817013000201019151014111010710625
Kazakhstan2020-02-0800000000000000000000000
Korea South2020-02-08170100012001211001140044004
Kuwait2020-02-0800000000000000000000000
Latvia2020-02-0800000000000000000000000
Lebanon2020-02-0800000000000000000000000
Lithuania2020-02-0800000000000000000000000
Luxembourg2020-02-0800000000000000000000000
Malaysia2020-02-081401000800880088008700716
Mexico2020-02-0800000000000000000000000
Moldova2020-02-0800000000000000000000000
Morocco2020-02-0800000000000000000000000
Netherlands2020-02-0800000000000000000000000
New Zealand2020-02-0800000000000000000000000
Niger2020-02-0800000000000000000000000
Nigeria2020-02-0800000000000000000000000
North Macedonia2020-02-0800000000000000000000000
Pakistan2020-02-0800000000000000000000000
Panama2020-02-0800000000000000000000000
Peru2020-02-0800000000000000000000000
Philippines2020-02-0890006010011001100100003
Poland2020-02-0800000000000000000000000
Portugal2020-02-0800000000000000000000000
Qatar2020-02-0800000000000000000000000
Romania2020-02-0800000000000000000000000
Russia2020-02-0880000020022002000000002
Saudi Arabia2020-02-0800000000000000000000000
Serbia2020-02-0800000000000000000000000
Singapore2020-02-081600000160016130013100010700733
Slovakia2020-02-0800000000000000000000000
Slovenia2020-02-0800000000000000000000000
South Africa2020-02-0800000000000000000000000
Spain2020-02-0870000010010000000000001
Sweden2020-02-0880000010011001000000001
Switzerland2020-02-0800000000000000000000000
Thailand2020-02-0817013000195014195014145091450932
Tunisia2020-02-0800000000000000000000000
Turkey2020-02-0800000000000000000000000
Ukraine2020-02-0800000000000000000000000
United Arab Emirates2020-02-08100000040044004400440047
United Kingdom2020-02-0880000020022002000000003
Uruguay2020-02-0800000000000000000000000
US2020-02-081700000800870075005500511
Venezuela2020-02-0800000000000000000000000
Afghanistan2020-02-0900000000000000000000000
Albania2020-02-0900000000000000000000000
Algeria2020-02-0900000000000000000000000
Andorra2020-02-0900000000000000000000000
Argentina2020-02-0900000000000000000000000
Armenia2020-02-0900000000000000000000000
Australia2020-02-09140100001220101220109207920715
Austria2020-02-0900000000000000000000000
Azerbaijan2020-02-0900000000000000000000000
Bangladesh2020-02-0900000000000000000000000
Belarus2020-02-0900000000000000000000000
Belgium2020-02-0950000000000000000000001
Bosnia and Herzegovina2020-02-0900000000000000000000000
Brazil2020-02-0900000000000000000000000
Bulgaria2020-02-0900000000000000000000000
Burkina Faso2020-02-0900000000000000000000000
Cameroon2020-02-0900000000000000000000000
Canada2020-02-09140000040044004400420027
Chile2020-02-0900000000000000000000000
China2020-02-0918181812181816630463361158061189127525911357980221421393758141135171783539829
Colombia2020-02-0900000000000000000000000
Cote d'Ivoire2020-02-0900000000000000000000000
Croatia2020-02-0900000000000000000000000
Cuba2020-02-0900000000000000000000000
Czechia2020-02-0900000000000000000000000
Denmark2020-02-0900000000000000000000000
Diamond Princess2020-02-09200000000000000000000064
Dominican Republic2020-02-0900000000000000000000000
Ecuador2020-02-0900000000000000000000000
Egypt2020-02-0900000000000000000000000
Estonia2020-02-0900000000000000000000000
Finland2020-02-09110000010011001100110011
France2020-02-091600000600660065005500511
Germany2020-02-09130000010001080085005400414
Greece2020-02-0900000000000000000000000
Hungary2020-02-0900000000000000000000000
Iceland2020-02-0900000000000000000000000
India2020-02-09100000020021001100110013
Indonesia2020-02-0900000000000000000000000
Iran2020-02-0900000000000000000000000
Iraq2020-02-0900000000000000000000000
Ireland2020-02-0900000000000000000000000
Israel2020-02-0900000000000000000000000
Italy2020-02-0990000020022002200200003
Japan2020-02-091801400020101920101915101411101026
Kazakhstan2020-02-0900000000000000000000000
Korea South2020-02-0918020001500151200121100114004
Kuwait2020-02-0900000000000000000000000
Latvia2020-02-0900000000000000000000000
Lebanon2020-02-0900000000000000000000000
Lithuania2020-02-0900000000000000000000000
Luxembourg2020-02-0900000000000000000000000
Malaysia2020-02-091502000800880088008800816
Mexico2020-02-0900000000000000000000000
Moldova2020-02-0900000000000000000000000
Morocco2020-02-0900000000000000000000000
Netherlands2020-02-0900000000000000000000000
New Zealand2020-02-0900000000000000000000000
Niger2020-02-0900000000000000000000000
Nigeria2020-02-0900000000000000000000000
North Macedonia2020-02-0900000000000000000000000
Pakistan2020-02-0900000000000000000000000
Panama2020-02-0900000000000000000000000
Peru2020-02-0900000000000000000000000
Philippines2020-02-09100007020111001100110013
Poland2020-02-0900000000000000000000000
Portugal2020-02-0900000000000000000000000
Qatar2020-02-0900000000000000000000000
Romania2020-02-0900000000000000000000000
Russia2020-02-0990000020022002200200002
Saudi Arabia2020-02-0900000000000000000000000
Serbia2020-02-0900000000000000000000000
Singapore2020-02-09170100018001816001613001310001040
Slovakia2020-02-0900000000000000000000000
Slovenia2020-02-0900000000000000000000000
South Africa2020-02-0900000000000000000000000
Spain2020-02-0980000010011001000000002
Sweden2020-02-0990000010011001100100001
Switzerland2020-02-0900000000000000000000000
Thailand2020-02-09180140001950141950141950141450932
Tunisia2020-02-0900000000000000000000000
Turkey2020-02-0900000000000000000000000
Ukraine2020-02-0900000000000000000000000
United Arab Emirates2020-02-09110000050054004400440047
United Kingdom2020-02-0990000020022002200200003
Uruguay2020-02-0900000000000000000000000
US2020-02-091800000800880087007500511
Venezuela2020-02-0900000000000000000000000
Afghanistan2020-02-1000000000000000000000000
Albania2020-02-1000000000000000000000000
Algeria2020-02-1000000000000000000000000
Andorra2020-02-1000000000000000000000000
Argentina2020-02-1000000000000000000000000
Armenia2020-02-1000000000000000000000000
Australia2020-02-1015011000122010122010122010920715
Austria2020-02-1000000000000000000000000
Azerbaijan2020-02-1000000000000000000000000
Bangladesh2020-02-1000000000000000000000000
Belarus2020-02-1000000000000000000000000
Belgium2020-02-1060000000000000000000001
Bosnia and Herzegovina2020-02-1000000000000000000000000
Brazil2020-02-1000000000000000000000000
Bulgaria2020-02-1000000000000000000000000
Burkina Faso2020-02-1000000000000000000000000
Cameroon2020-02-1000000000000000000000000
Canada2020-02-10150000040044004400440047
Chile2020-02-1000000000000000000000000
China2020-02-101919191319191971661442518677166304633611580611891275259113579802214213937542354
Colombia2020-02-1000000000000000000000000
Cote d'Ivoire2020-02-1000000000000000000000000
Croatia2020-02-1000000000000000000000000
Cuba2020-02-1000000000000000000000000
Czechia2020-02-1000000000000000000000000
Denmark2020-02-1000000000000000000000000
Diamond Princess2020-02-103000000000000000000000135
Dominican Republic2020-02-1000000000000000000000000
Ecuador2020-02-1000000000000000000000000
Egypt2020-02-1000000000000000000000000
Estonia2020-02-1000000000000000000000000
Finland2020-02-10120000010011001100110011
France2020-02-101700000600660066006500511
Germany2020-02-1014000001200121000108008500514
Greece2020-02-1000000000000000000000000
Hungary2020-02-1000000000000000000000000
Iceland2020-02-1000000000000000000000000
India2020-02-10110000030032002100110013
Indonesia2020-02-1000000000000000000000000
Iran2020-02-1000000000000000000000000
Iraq2020-02-1000000000000000000000000
Ireland2020-02-1000000000000000000000000
Israel2020-02-1000000000000000000000000
Italy2020-02-10100000020022002200220023
Japan2020-02-101901500020101920101920101915101426
Kazakhstan2020-02-1000000000000000000000000
Korea South2020-02-101903000150015150015120012110011
Kuwait2020-02-1000000000000000000000000
Latvia2020-02-1000000000000000000000000
Lebanon2020-02-1000000000000000000000000
Lithuania2020-02-1000000000000000000000000
Luxembourg2020-02-1000000000000000000000000
Malaysia2020-02-101603000800880088008800818
Mexico2020-02-1000000000000000000000000
Moldova2020-02-1000000000000000000000000
Morocco2020-02-1000000000000000000000000
Netherlands2020-02-1000000000000000000000000
New Zealand2020-02-1000000000000000000000000
Niger2020-02-1000000000000000000000000
Nigeria2020-02-1000000000000000000000000
North Macedonia2020-02-1000000000000000000000000
Pakistan2020-02-1000000000000000000000000
Panama2020-02-1000000000000000000000000
Peru2020-02-1000000000000000000000000
Philippines2020-02-10110008020112011100110013
Poland2020-02-1000000000000000000000000
Portugal2020-02-1000000000000000000000000
Qatar2020-02-1000000000000000000000000
Romania2020-02-1000000000000000000000000
Russia2020-02-10100000020022002200220022
Saudi Arabia2020-02-1000000000000000000000000
Serbia2020-02-1000000000000000000000000
Singapore2020-02-10180200018001818001816001613001345
Slovakia2020-02-1000000000000000000000000
Slovenia2020-02-1000000000000000000000000
South Africa2020-02-1000000000000000000000000
Spain2020-02-1090000010011001100100002
Sweden2020-02-10100000010011001100110011
Switzerland2020-02-1000000000000000000000000
Thailand2020-02-101901500019501419501419501419501432
Tunisia2020-02-1000000000000000000000000
Turkey2020-02-1000000000000000000000000
Ukraine2020-02-1000000000000000000000000
United Arab Emirates2020-02-10120000050055005400440048
United Kingdom2020-02-10100000020022002200220028
Uruguay2020-02-1000000000000000000000000
US2020-02-10190100011001180088008700711
Venezuela2020-02-1000000000000000000000000
Afghanistan2020-02-1100000000000000000000000
Albania2020-02-1100000000000000000000000
Algeria2020-02-1100000000000000000000000
Andorra2020-02-1100000000000000000000000
Argentina2020-02-1100000000000000000000000
Armenia2020-02-1100000000000000000000000
Australia2020-02-111601200013201112201012201012201015
Austria2020-02-1100000000000000000000000
Azerbaijan2020-02-1100000000000000000000000
Bangladesh2020-02-1100000000000000000000000
Belarus2020-02-1100000000000000000000000
Belgium2020-02-1170000010010000000000001
Bosnia and Herzegovina2020-02-1100000000000000000000000
Brazil2020-02-1100000000000000000000000
Bulgaria2020-02-1100000000000000000000000
Burkina Faso2020-02-1100000000000000000000000
Cameroon2020-02-1100000000000000000000000
Canada2020-02-11160000040044004400440047
Chile2020-02-1100000000000000000000000
China2020-02-11202020142020237078434912237319716614425186771663046336115806118912752591135744386
Colombia2020-02-1100000000000000000000000
Cote d'Ivoire2020-02-1100000000000000000000000
Croatia2020-02-1100000000000000000000000
Cuba2020-02-1100000000000000000000000
Czechia2020-02-1100000000000000000000000
Denmark2020-02-1100000000000000000000000
Diamond Princess2020-02-114100000000000000000000135
Dominican Republic2020-02-1100000000000000000000000
Ecuador2020-02-1100000000000000000000000
Egypt2020-02-1100000000000000000000000
Estonia2020-02-1100000000000000000000000
Finland2020-02-11130000010011001100110011
France2020-02-111800000600660066006600611
Germany2020-02-111500000120012120012100010800816
Greece2020-02-1100000000000000000000000
Hungary2020-02-1100000000000000000000000
Iceland2020-02-1100000000000000000000000
India2020-02-11120000030033003200210013
Indonesia2020-02-1100000000000000000000000
Iran2020-02-1100000000000000000000000
Iraq2020-02-1100000000000000000000000
Ireland2020-02-1100000000000000000000000
Israel2020-02-1100000000000000000000000
Italy2020-02-11110000020022002200220023
Japan2020-02-112001600022102120101920101920101926
Kazakhstan2020-02-1100000000000000000000000
Korea South2020-02-112004000160016150015150015120012
Kuwait2020-02-1100000000000000000000000
Latvia2020-02-1100000000000000000000000
Lebanon2020-02-1100000000000000000000000
Lithuania2020-02-1100000000000000000000000
Luxembourg2020-02-1100000000000000000000000
Malaysia2020-02-11170400010001080088008800818
Mexico2020-02-1100000000000000000000000
Moldova2020-02-1100000000000000000000000
Morocco2020-02-1100000000000000000000000
Netherlands2020-02-1100000000000000000000000
New Zealand2020-02-1100000000000000000000000
Niger2020-02-1100000000000000000000000
Nigeria2020-02-1100000000000000000000000
North Macedonia2020-02-1100000000000000000000000
Pakistan2020-02-1100000000000000000000000
Panama2020-02-1100000000000000000000000
Peru2020-02-1100000000000000000000000
Philippines2020-02-11120009020112011201110013
Poland2020-02-1100000000000000000000000
Portugal2020-02-1100000000000000000000000
Qatar2020-02-1100000000000000000000000
Romania2020-02-1100000000000000000000000
Russia2020-02-11110000020022002200220022
Saudi Arabia2020-02-1100000000000000000000000
Serbia2020-02-1100000000000000000000000
Singapore2020-02-11190300024002418001818001816001647
Slovakia2020-02-1100000000000000000000000
Slovenia2020-02-1100000000000000000000000
South Africa2020-02-1100000000000000000000000
Spain2020-02-11100000010011001100110012
Sweden2020-02-11110000010011001100110011
Switzerland2020-02-1100000000000000000000000
Thailand2020-02-112001600025502019501419501419501433
Tunisia2020-02-1100000000000000000000000
Turkey2020-02-1100000000000000000000000
Ukraine2020-02-1100000000000000000000000
United Arab Emirates2020-02-11130000050055005500540048
United Kingdom2020-02-11110000020022002200220028
Uruguay2020-02-1100000000000000000000000
US2020-02-1120020001100111100118008800812
Venezuela2020-02-1100000000000000000000000
Afghanistan2020-02-1200000000000000000000000
Albania2020-02-1200000000000000000000000
Algeria2020-02-1200000000000000000000000
Andorra2020-02-1200000000000000000000000
Argentina2020-02-1200000000000000000000000
Armenia2020-02-1200000000000000000000000
Australia2020-02-121701300013201113201112201012201015
Austria2020-02-1200000000000000000000000
Azerbaijan2020-02-1200000000000000000000000
Bangladesh2020-02-1200000000000000000000000
Belarus2020-02-1200000000000000000000000
Belgium2020-02-1280000010011001000000001
Bosnia and Herzegovina2020-02-1200000000000000000000000
Brazil2020-02-1200000000000000000000000
Bulgaria2020-02-1200000000000000000000000
Burkina Faso2020-02-1200000000000000000000000
Cameroon2020-02-1200000000000000000000000
Canada2020-02-12170000050054004400440047
Chile2020-02-1200000000000000000000000
China2020-02-122121211521212744011155632576223707843491223731971661442518677166304633611580644759
Colombia2020-02-1200000000000000000000000
Cote d'Ivoire2020-02-1200000000000000000000000
Croatia2020-02-1200000000000000000000000
Cuba2020-02-1200000000000000000000000
Czechia2020-02-1200000000000000000000000
Denmark2020-02-1200000000000000000000000
Diamond Princess2020-02-125200000000000000000000175
Dominican Republic2020-02-1200000000000000000000000
Ecuador2020-02-1200000000000000000000000
Egypt2020-02-1200000000000000000000000
Estonia2020-02-1200000000000000000000000
Finland2020-02-12140000010011001100110011

In [3]:
# Create a view or table

temp_table_name = "covid_19_spread"

df.createOrReplaceTempView(temp_table_name)



In [4]:
%sql
select * from `covid_19_spread`


countrydatesince_1st_confirmed_n_dayssince_100th_confirmed_n_dayssince_1st_recovered_n_dayssince_100th_recovered_n_dayssince_1st_deaths_n_dayssince_10th_deaths_n_daysconfirmed_n_lag_7drecovered_n_lag_7ddeaths_n_lag_7dactive_n_lag_7dconfirmed_n_lag_8drecovered_n_lag_8ddeaths_n_lag_8dactive_n_lag_8dconfirmed_n_lag_9drecovered_n_lag_9ddeaths_n_lag_9dactive_n_lag_9dconfirmed_n_lag_10drecovered_n_lag_10ddeaths_n_lag_10dactive_n_lag_10dlabel
Afghanistan2020-02-0100000000000000000000000
Albania2020-02-0100000000000000000000000
Algeria2020-02-0100000000000000000000000
Andorra2020-02-0100000000000000000000000
Argentina2020-02-0100000000000000000000000
Armenia2020-02-0100000000000000000000000
Australia2020-02-01602000000000000000000012
Austria2020-02-0100000000000000000000000
Azerbaijan2020-02-0100000000000000000000000
Bangladesh2020-02-0100000000000000000000000
Belarus2020-02-0100000000000000000000000
Belgium2020-02-0100000000000000000000000
Bosnia and Herzegovina2020-02-0100000000000000000000000
Brazil2020-02-0100000000000000000000000
Bulgaria2020-02-0100000000000000000000000
Burkina Faso2020-02-0100000000000000000000000
Cameroon2020-02-0100000000000000000000000
Canada2020-02-0160000000000000000000004
Chile2020-02-0100000000000000000000000
China2020-02-011010104101014063942132592036268586433018595548281750311891
Colombia2020-02-0100000000000000000000000
Cote d'Ivoire2020-02-0100000000000000000000000
Croatia2020-02-0100000000000000000000000
Cuba2020-02-0100000000000000000000000
Czechia2020-02-0100000000000000000000000
Denmark2020-02-0100000000000000000000000
Diamond Princess2020-02-0100000000000000000000000
Dominican Republic2020-02-0100000000000000000000000
Ecuador2020-02-0100000000000000000000000
Egypt2020-02-0100000000000000000000000
Estonia2020-02-0100000000000000000000000
Finland2020-02-0130000000000000000000001
France2020-02-0180000030032002000000006
Germany2020-02-0150000000000000000000008
Greece2020-02-0100000000000000000000000
Hungary2020-02-0100000000000000000000000
Iceland2020-02-0100000000000000000000000
India2020-02-0120000000000000000000001
Indonesia2020-02-0100000000000000000000000
Iran2020-02-0100000000000000000000000
Iraq2020-02-0100000000000000000000000
Ireland2020-02-0100000000000000000000000
Israel2020-02-0100000000000000000000000
Italy2020-02-0110000000000000000000002
Japan2020-02-011006000200220022002200220
Kazakhstan2020-02-0100000000000000000000000
Korea South2020-02-0110000002002200210011001
Kuwait2020-02-0100000000000000000000000
Latvia2020-02-0100000000000000000000000
Lebanon2020-02-0100000000000000000000000
Lithuania2020-02-0100000000000000000000000
Luxembourg2020-02-0100000000000000000000000
Malaysia2020-02-0170000030030000000000008
Mexico2020-02-0100000000000000000000000
Moldova2020-02-0100000000000000000000000
Morocco2020-02-0100000000000000000000000
Netherlands2020-02-0100000000000000000000000
New Zealand2020-02-0100000000000000000000000
Niger2020-02-0100000000000000000000000
Nigeria2020-02-0100000000000000000000000
North Macedonia2020-02-0100000000000000000000000
Pakistan2020-02-0100000000000000000000000
Panama2020-02-0100000000000000000000000
Peru2020-02-0100000000000000000000000
Philippines2020-02-0120000000000000000000001
Poland2020-02-0100000000000000000000000
Portugal2020-02-0100000000000000000000000
Qatar2020-02-0100000000000000000000000
Romania2020-02-0100000000000000000000000
Russia2020-02-0110000000000000000000002
Saudi Arabia2020-02-0100000000000000000000000
Serbia2020-02-0100000000000000000000000
Singapore2020-02-01900000300330031001000016
Slovakia2020-02-0100000000000000000000000
Slovenia2020-02-0100000000000000000000000
South Africa2020-02-0100000000000000000000000
Spain2020-02-0100000000000000000000001
Sweden2020-02-0110000000000000000000001
Switzerland2020-02-0100000000000000000000000
Thailand2020-02-011006000700750053003200219
Tunisia2020-02-0100000000000000000000000
Turkey2020-02-0100000000000000000000000
Ukraine2020-02-0100000000000000000000000
United Arab Emirates2020-02-0130000000000000000000004
United Kingdom2020-02-0110000000000000000000002
Uruguay2020-02-0100000000000000000000000
US2020-02-01100000020022002100110018
Venezuela2020-02-0100000000000000000000000
Afghanistan2020-02-0200000000000000000000000
Albania2020-02-0200000000000000000000000
Algeria2020-02-0200000000000000000000000
Andorra2020-02-0200000000000000000000000
Argentina2020-02-0200000000000000000000000
Armenia2020-02-0200000000000000000000000
Australia2020-02-02703000400400000000000012
Austria2020-02-0200000000000000000000000
Azerbaijan2020-02-0200000000000000000000000
Bangladesh2020-02-0200000000000000000000000
Belarus2020-02-0200000000000000000000000
Belgium2020-02-0200000000000000000000000
Bosnia and Herzegovina2020-02-0200000000000000000000000
Brazil2020-02-0200000000000000000000000
Bulgaria2020-02-0200000000000000000000000
Burkina Faso2020-02-0200000000000000000000000
Cameroon2020-02-0200000000000000000000000
Canada2020-02-0270000010010000000000004
Chile2020-02-0200000000000000000000000
China2020-02-02111111511112075495619701406394213259203626858643301859516630
Colombia2020-02-0200000000000000000000000
Cote d'Ivoire2020-02-0200000000000000000000000
Croatia2020-02-0200000000000000000000000
Cuba2020-02-0200000000000000000000000
Czechia2020-02-0200000000000000000000000
Denmark2020-02-0200000000000000000000000
Diamond Princess2020-02-0200000000000000000000000
Dominican Republic2020-02-0200000000000000000000000
Ecuador2020-02-0200000000000000000000000
Egypt2020-02-0200000000000000000000000
Estonia2020-02-0200000000000000000000000
Finland2020-02-0240000000000000000000001
France2020-02-0290000030033003200200006
Germany2020-02-02600000000000000000000010
Greece2020-02-0200000000000000000000000
Hungary2020-02-0200000000000000000000000
Iceland2020-02-0200000000000000000000000
India2020-02-0230000000000000000000002
Indonesia2020-02-0200000000000000000000000
Iran2020-02-0200000000000000000000000
Iraq2020-02-0200000000000000000000000
Ireland2020-02-0200000000000000000000000
Israel2020-02-0200000000000000000000000
Italy2020-02-0220000000000000000000002
Japan2020-02-021107000410320022002200220
Kazakhstan2020-02-0200000000000000000000000
Korea South2020-02-0211000003003200220021001
Kuwait2020-02-0200000000000000000000000
Latvia2020-02-0200000000000000000000000
Lebanon2020-02-0200000000000000000000000
Lithuania2020-02-0200000000000000000000000
Luxembourg2020-02-0200000000000000000000000
Malaysia2020-02-0280000040043003000000008
Mexico2020-02-0200000000000000000000000
Moldova2020-02-0200000000000000000000000
Morocco2020-02-0200000000000000000000000
Netherlands2020-02-0200000000000000000000000
New Zealand2020-02-0200000000000000000000000
Niger2020-02-0200000000000000000000000
Nigeria2020-02-0200000000000000000000000
North Macedonia2020-02-0200000000000000000000000
Pakistan2020-02-0200000000000000000000000
Panama2020-02-0200000000000000000000000
Peru2020-02-0200000000000000000000000
Philippines2020-02-0230000000000000000000002
Poland2020-02-0200000000000000000000000
Portugal2020-02-0200000000000000000000000
Qatar2020-02-0200000000000000000000000
Romania2020-02-0200000000000000000000000
Russia2020-02-0220000000000000000000002
Saudi Arabia2020-02-0200000000000000000000000
Serbia2020-02-0200000000000000000000000
Singapore2020-02-021000000400430033003100118
Slovakia2020-02-0200000000000000000000000
Slovenia2020-02-0200000000000000000000000
South Africa2020-02-0200000000000000000000000
Spain2020-02-0210000000000000000000001
Sweden2020-02-0220000000000000000000001
Switzerland2020-02-0200000000000000000000000
Thailand2020-02-021107000820670075005300319
Tunisia2020-02-0200000000000000000000000
Turkey2020-02-0200000000000000000000000
Ukraine2020-02-0200000000000000000000000
United Arab Emirates2020-02-0240000000000000000000005
United Kingdom2020-02-0220000000000000000000002
Uruguay2020-02-0200000000000000000000000
US2020-02-02110000050052002200210018
Venezuela2020-02-0200000000000000000000000
Afghanistan2020-02-0300000000000000000000000
Albania2020-02-0300000000000000000000000
Algeria2020-02-0300000000000000000000000
Andorra2020-02-0300000000000000000000000
Argentina2020-02-0300000000000000000000000
Armenia2020-02-0300000000000000000000000
Australia2020-02-03804000500540040000000012
Austria2020-02-0300000000000000000000000
Azerbaijan2020-02-0300000000000000000000000
Bangladesh2020-02-0300000000000000000000000
Belarus2020-02-0300000000000000000000000
Belgium2020-02-0300000000000000000000000
Bosnia and Herzegovina2020-02-0300000000000000000000000
Brazil2020-02-0300000000000000000000000
Bulgaria2020-02-0300000000000000000000000
Burkina Faso2020-02-0300000000000000000000000
Cameroon2020-02-0300000000000000000000000
Canada2020-02-0380000010011001000000004
Chile2020-02-0300000000000000000000000
China2020-02-0312121261212287758822737207549561970140639421325920362685819716
Colombia2020-02-0300000000000000000000000
Cote d'Ivoire2020-02-0300000000000000000000000
Croatia2020-02-0300000000000000000000000
Cuba2020-02-0300000000000000000000000
Czechia2020-02-0300000000000000000000000
Denmark2020-02-0300000000000000000000000
Diamond Princess2020-02-0300000000000000000000000
Dominican Republic2020-02-0300000000000000000000000
Ecuador2020-02-0300000000000000000000000
Egypt2020-02-0300000000000000000000000
Estonia2020-02-0300000000000000000000000
Finland2020-02-0350000000000000000000001
France2020-02-03100000030033003300320026
Germany2020-02-03700000100100000000000012
Greece2020-02-0300000000000000000000000
Hungary2020-02-0300000000000000000000000
Iceland2020-02-0300000000000000000000000
India2020-02-0340000000000000000000003
Indonesia2020-02-0300000000000000000000000
Iran2020-02-0300000000000000000000000
Iraq2020-02-0300000000000000000000000
Ireland2020-02-0300000000000000000000000
Israel2020-02-0300000000000000000000000
Italy2020-02-0330000000000000000000002
Japan2020-02-031208000410341032002200220
Kazakhstan2020-02-0300000000000000000000000
Korea South2020-02-0312000004004300320022002
Kuwait2020-02-0300000000000000000000000
Latvia2020-02-0300000000000000000000000
Lebanon2020-02-0300000000000000000000000
Lithuania2020-02-0300000000000000000000000
Luxembourg2020-02-0300000000000000000000000
Malaysia2020-02-0390000040044004300300008
Mexico2020-02-0300000000000000000000000
Moldova2020-02-0300000000000000000000000
Morocco2020-02-0300000000000000000000000
Netherlands2020-02-0300000000000000000000000
New Zealand2020-02-0300000000000000000000000
Niger2020-02-0300000000000000000000000
Nigeria2020-02-0300000000000000000000000
North Macedonia2020-02-0300000000000000000000000
Pakistan2020-02-0300000000000000000000000
Panama2020-02-0300000000000000000000000
Peru2020-02-0300000000000000000000000
Philippines2020-02-0340001000000000000000002
Poland2020-02-0300000000000000000000000
Portugal2020-02-0300000000000000000000000
Qatar2020-02-0300000000000000000000000
Romania2020-02-0300000000000000000000000
Russia2020-02-0330000000000000000000002
Saudi Arabia2020-02-0300000000000000000000000
Serbia2020-02-0300000000000000000000000
Singapore2020-02-031100000500540043003300318
Slovakia2020-02-0300000000000000000000000
Slovenia2020-02-0300000000000000000000000
South Africa2020-02-0300000000000000000000000
Spain2020-02-0320000000000000000000001
Sweden2020-02-0330000000000000000000001
Switzerland2020-02-0300000000000000000000000
Thailand2020-02-031208000820682067007500519
Tunisia2020-02-0300000000000000000000000
Turkey2020-02-0300000000000000000000000
Ukraine2020-02-0300000000000000000000000
United Arab Emirates2020-02-0350000000000000000000005
United Kingdom2020-02-0330000000000000000000002
Uruguay2020-02-0300000000000000000000000
US2020-02-031200000500550052002200211
Venezuela2020-02-0300000000000000000000000
Afghanistan2020-02-0400000000000000000000000
Albania2020-02-0400000000000000000000000
Algeria2020-02-0400000000000000000000000
Andorra2020-02-0400000000000000000000000
Argentina2020-02-0400000000000000000000000
Armenia2020-02-0400000000000000000000000
Australia2020-02-04905000500550054004000013
Austria2020-02-0400000000000000000000000
Azerbaijan2020-02-0400000000000000000000000
Bangladesh2020-02-0400000000000000000000000
Belarus2020-02-0400000000000000000000000
Belgium2020-02-0400000000000000000000001
Bosnia and Herzegovina2020-02-0400000000000000000000000
Brazil2020-02-0400000000000000000000000
Bulgaria2020-02-0400000000000000000000000
Burkina Faso2020-02-0400000000000000000000000
Cameroon2020-02-0400000000000000000000000
Canada2020-02-0490000020021001100100004
Chile2020-02-0400000000000000000000000
China2020-02-04131313713135509101131527728775882273720754956197014063942132523707
Colombia2020-02-0400000000000000000000000
Cote d'Ivoire2020-02-0400000000000000000000000
Croatia2020-02-0400000000000000000000000
Cuba2020-02-0400000000000000000000000
Czechia2020-02-0400000000000000000000000
Denmark2020-02-0400000000000000000000000
Diamond Princess2020-02-0400000000000000000000000
Dominican Republic2020-02-0400000000000000000000000
Ecuador2020-02-0400000000000000000000000
Egypt2020-02-0400000000000000000000000
Estonia2020-02-0400000000000000000000000
Finland2020-02-0460000000000000000000001
France2020-02-04110000040043003300330036
Germany2020-02-04800000400410010000000012
Greece2020-02-0400000000000000000000000
Hungary2020-02-0400000000000000000000000
Iceland2020-02-0400000000000000000000000
India2020-02-0450000000000000000000003
Indonesia2020-02-0400000000000000000000000
Iran2020-02-0400000000000000000000000
Iraq2020-02-0400000000000000000000000
Ireland2020-02-0400000000000000000000000
Israel2020-02-0400000000000000000000000
Italy2020-02-0440000000000000000000002
Japan2020-02-041309000710641034103200222
Kazakhstan2020-02-0400000000000000000000000
Korea South2020-02-0413000004004400430032002
Kuwait2020-02-0400000000000000000000000
Latvia2020-02-0400000000000000000000000
Lebanon2020-02-0400000000000000000000000
Lithuania2020-02-0400000000000000000000000
Luxembourg2020-02-0400000000000000000000000
Malaysia2020-02-041000000400440044004300310
Mexico2020-02-0400000000000000000000000
Moldova2020-02-0400000000000000000000000
Morocco2020-02-0400000000000000000000000
Netherlands2020-02-0400000000000000000000000
New Zealand2020-02-0400000000000000000000000
Niger2020-02-0400000000000000000000000
Nigeria2020-02-0400000000000000000000000
North Macedonia2020-02-0400000000000000000000000
Pakistan2020-02-0400000000000000000000000
Panama2020-02-0400000000000000000000000
Peru2020-02-0400000000000000000000000
Philippines2020-02-0450002000000000000000002
Poland2020-02-0400000000000000000000000
Portugal2020-02-0400000000000000000000000
Qatar2020-02-0400000000000000000000000
Romania2020-02-0400000000000000000000000
Russia2020-02-0440000000000000000000002
Saudi Arabia2020-02-0400000000000000000000000
Serbia2020-02-0400000000000000000000000
Singapore2020-02-041200000700750054004300324
Slovakia2020-02-0400000000000000000000000
Slovenia2020-02-0400000000000000000000000
South Africa2020-02-0400000000000000000000000
Spain2020-02-0430000000000000000000001
Sweden2020-02-0440000000000000000000001
Switzerland2020-02-0400000000000000000000000
Thailand2020-02-0413090001450982068206700725
Tunisia2020-02-0400000000000000000000000
Turkey2020-02-0400000000000000000000000
Ukraine2020-02-0400000000000000000000000
United Arab Emirates2020-02-0460000000000000000000005
United Kingdom2020-02-0440000000000000000000002
Uruguay2020-02-0400000000000000000000000
US2020-02-041300000500550055005200211
Venezuela2020-02-0400000000000000000000000
Afghanistan2020-02-0500000000000000000000000
Albania2020-02-0500000000000000000000000
Algeria2020-02-0500000000000000000000000
Andorra2020-02-0500000000000000000000000
Argentina2020-02-0500000000000000000000000
Armenia2020-02-0500000000000000000000000
Australia2020-02-051006000600650055005400413
Austria2020-02-0500000000000000000000000
Azerbaijan2020-02-0500000000000000000000000
Bangladesh2020-02-0500000000000000000000000
Belarus2020-02-0500000000000000000000000
Belgium2020-02-0510000000000000000000001
Bosnia and Herzegovina2020-02-0500000000000000000000000
Brazil2020-02-0500000000000000000000000
Bulgaria2020-02-0500000000000000000000000
Burkina Faso2020-02-0500000000000000000000000
Cameroon2020-02-0500000000000000000000000
Canada2020-02-05100000020022002100110015
Chile2020-02-0500000000000000000000000
China2020-02-0514141481414608712013358345509101131527728775882273720754956197027440
Colombia2020-02-0500000000000000000000000
Cote d'Ivoire2020-02-0500000000000000000000000
Croatia2020-02-0500000000000000000000000
Cuba2020-02-0500000000000000000000000
Czechia2020-02-0500000000000000000000000
Denmark2020-02-0500000000000000000000000
Diamond Princess2020-02-0500000000000000000000000
Dominican Republic2020-02-0500000000000000000000000
Ecuador2020-02-0500000000000000000000000
Egypt2020-02-0500000000000000000000000
Estonia2020-02-0500000000000000000000000
Finland2020-02-0570000010010000000000001
France2020-02-05120000050054004300330036
Germany2020-02-05900000400440041001000012
Greece2020-02-0500000000000000000000000
Hungary2020-02-0500000000000000000000000
Iceland2020-02-0500000000000000000000000
India2020-02-0560000000000000000000003
Indonesia2020-02-0500000000000000000000000
Iran2020-02-0500000000000000000000000
Iraq2020-02-0500000000000000000000000
Ireland2020-02-0500000000000000000000000
Israel2020-02-0500000000000000000000000
Italy2020-02-0550000000000000000000002
Japan2020-02-0514010000710671064103410322
Kazakhstan2020-02-0500000000000000000000000
Korea South2020-02-0514000004004400440043003
Kuwait2020-02-0500000000000000000000000
Latvia2020-02-0500000000000000000000000
Lebanon2020-02-0500000000000000000000000
Lithuania2020-02-0500000000000000000000000
Luxembourg2020-02-0500000000000000000000000
Malaysia2020-02-051100000700740044004400412
Mexico2020-02-0500000000000000000000000
Moldova2020-02-0500000000000000000000000
Morocco2020-02-0500000000000000000000000
Netherlands2020-02-0500000000000000000000000
New Zealand2020-02-0500000000000000000000000
Niger2020-02-0500000000000000000000000
Nigeria2020-02-0500000000000000000000000
North Macedonia2020-02-0500000000000000000000000
Pakistan2020-02-0500000000000000000000000
Panama2020-02-0500000000000000000000000
Peru2020-02-0500000000000000000000000
Philippines2020-02-0560003000000000000000002
Poland2020-02-0500000000000000000000000
Portugal2020-02-0500000000000000000000000
Qatar2020-02-0500000000000000000000000
Romania2020-02-0500000000000000000000000
Russia2020-02-0550000000000000000000002
Saudi Arabia2020-02-0500000000000000000000000
Serbia2020-02-0500000000000000000000000
Singapore2020-02-051300000700770075005400428
Slovakia2020-02-0500000000000000000000000
Slovenia2020-02-0500000000000000000000000
South Africa2020-02-0500000000000000000000000
Spain2020-02-0540000000000000000000001
Sweden2020-02-0550000000000000000000001
Switzerland2020-02-0500000000000000000000000
Thailand2020-02-051401000014509145098206820625
Tunisia2020-02-0500000000000000000000000
Turkey2020-02-0500000000000000000000000
Ukraine2020-02-0500000000000000000000000
United Arab Emirates2020-02-0570000040040000000000005
United Kingdom2020-02-0550000000000000000000002
Uruguay2020-02-0500000000000000000000000
US2020-02-051400000500550055005500511
Venezuela2020-02-0500000000000000000000000
Afghanistan2020-02-0600000000000000000000000
Albania2020-02-0600000000000000000000000
Algeria2020-02-0600000000000000000000000
Andorra2020-02-0600000000000000000000000
Argentina2020-02-0600000000000000000000000
Armenia2020-02-0600000000000000000000000
Australia2020-02-061107000920760065005500514
Austria2020-02-0600000000000000000000000
Azerbaijan2020-02-0600000000000000000000000
Bangladesh2020-02-0600000000000000000000000
Belarus2020-02-0600000000000000000000000
Belgium2020-02-0620000000000000000000001
Bosnia and Herzegovina2020-02-0600000000000000000000000
Brazil2020-02-0600000000000000000000000
Bulgaria2020-02-0600000000000000000000000
Burkina Faso2020-02-0600000000000000000000000
Cameroon2020-02-0600000000000000000000000
Canada2020-02-06110000020022002200210015
Chile2020-02-0600000000000000000000000
China2020-02-061515159151581411351717835608712013358345509101131527728775882273730587
Colombia2020-02-0600000000000000000000000
Cote d'Ivoire2020-02-0600000000000000000000000
Croatia2020-02-0600000000000000000000000
Cuba2020-02-0600000000000000000000000
Czechia2020-02-0600000000000000000000000
Denmark2020-02-0600000000000000000000000
Diamond Princess2020-02-0600000000000000000000000
Dominican Republic2020-02-0600000000000000000000000
Ecuador2020-02-0600000000000000000000000
Egypt2020-02-0600000000000000000000000
Estonia2020-02-0600000000000000000000000
Finland2020-02-0680000010011001000000001
France2020-02-06130000050055005400430036
Germany2020-02-061000000400440044004100112
Greece2020-02-0600000000000000000000000
Hungary2020-02-0600000000000000000000000
Iceland2020-02-0600000000000000000000000
India2020-02-0670000010010000000000003
Indonesia2020-02-0600000000000000000000000
Iran2020-02-0600000000000000000000000
Iraq2020-02-0600000000000000000000000
Ireland2020-02-0600000000000000000000000
Israel2020-02-0600000000000000000000000
Italy2020-02-0660000000000000000000002
Japan2020-02-061501100011101071067106410322
Kazakhstan2020-02-0600000000000000000000000
Korea South2020-02-0615000004004400440044004
Kuwait2020-02-0600000000000000000000000
Latvia2020-02-0600000000000000000000000
Lebanon2020-02-0600000000000000000000000
Lithuania2020-02-0600000000000000000000000
Luxembourg2020-02-0600000000000000000000000
Malaysia2020-02-061200000800870074004400412
Mexico2020-02-0600000000000000000000000
Moldova2020-02-0600000000000000000000000
Morocco2020-02-0600000000000000000000000
Netherlands2020-02-0600000000000000000000000
New Zealand2020-02-0600000000000000000000000
Niger2020-02-0600000000000000000000000
Nigeria2020-02-0600000000000000000000000
North Macedonia2020-02-0600000000000000000000000
Pakistan2020-02-0600000000000000000000000
Panama2020-02-0600000000000000000000000
Peru2020-02-0600000000000000000000000
Philippines2020-02-0670004010010000000000002
Poland2020-02-0600000000000000000000000
Portugal2020-02-0600000000000000000000000
Qatar2020-02-0600000000000000000000000
Romania2020-02-0600000000000000000000000
Russia2020-02-0660000000000000000000002
Saudi Arabia2020-02-0600000000000000000000000
Serbia2020-02-0600000000000000000000000
Singapore2020-02-06140000010001070077007500528
Slovakia2020-02-0600000000000000000000000
Slovenia2020-02-0600000000000000000000000
South Africa2020-02-0600000000000000000000000
Spain2020-02-0650000000000000000000001
Sweden2020-02-0660000000000000000000001
Switzerland2020-02-0600000000000000000000000
Thailand2020-02-0615011000145091450914509820625
Tunisia2020-02-0600000000000000000000000
Turkey2020-02-0600000000000000000000000
Ukraine2020-02-0600000000000000000000000
United Arab Emirates2020-02-0680000040044004000000005
United Kingdom2020-02-0660000000000000000000002
Uruguay2020-02-0600000000000000000000000
US2020-02-061500000500550055005500511
Venezuela2020-02-0600000000000000000000000
Afghanistan2020-02-0700000000000000000000000
Albania2020-02-0700000000000000000000000
Algeria2020-02-0700000000000000000000000
Andorra2020-02-0700000000000000000000000
Argentina2020-02-0700000000000000000000000
Armenia2020-02-0700000000000000000000000
Australia2020-02-071208000920792076006500515
Austria2020-02-0700000000000000000000000
Azerbaijan2020-02-0700000000000000000000000
Bangladesh2020-02-0700000000000000000000000
Belarus2020-02-0700000000000000000000000
Belgium2020-02-0730000000000000000000001
Bosnia and Herzegovina2020-02-0700000000000000000000000
Brazil2020-02-0700000000000000000000000
Bulgaria2020-02-0700000000000000000000000
Burkina Faso2020-02-0700000000000000000000000
Cameroon2020-02-0700000000000000000000000
Canada2020-02-07120000040042002200220027
Chile2020-02-0700000000000000000000000
China2020-02-071616161016169802214213937581411351717835608712013358345509101131527734110
Colombia2020-02-0700000000000000000000000
Cote d'Ivoire2020-02-0700000000000000000000000
Croatia2020-02-0700000000000000000000000
Cuba2020-02-0700000000000000000000000
Czechia2020-02-0700000000000000000000000
Denmark2020-02-0700000000000000000000000
Diamond Princess2020-02-07000000000000000000000061
Dominican Republic2020-02-0700000000000000000000000
Ecuador2020-02-0700000000000000000000000
Egypt2020-02-0700000000000000000000000
Estonia2020-02-0700000000000000000000000
Finland2020-02-0790000010011001100100001
France2020-02-07140000050055005500540046
Germany2020-02-071100000500540044004400413
Greece2020-02-0700000000000000000000000
Hungary2020-02-0700000000000000000000000
Iceland2020-02-0700000000000000000000000
India2020-02-0780000010011001000000003
Indonesia2020-02-0700000000000000000000000
Iran2020-02-0700000000000000000000000
Iraq2020-02-0700000000000000000000000
Ireland2020-02-0700000000000000000000000
Israel2020-02-0700000000000000000000000
Italy2020-02-0770000020020000000000003
Japan2020-02-07160120001510141110107106710625
Kazakhstan2020-02-0700000000000000000000000
Korea South2020-02-071600000110011400440044004
Kuwait2020-02-0700000000000000000000000
Latvia2020-02-0700000000000000000000000
Lebanon2020-02-0700000000000000000000000
Lithuania2020-02-0700000000000000000000000
Luxembourg2020-02-0700000000000000000000000
Malaysia2020-02-071300000800880087007400412
Mexico2020-02-0700000000000000000000000
Moldova2020-02-0700000000000000000000000
Morocco2020-02-0700000000000000000000000
Netherlands2020-02-0700000000000000000000000
New Zealand2020-02-0700000000000000000000000
Niger2020-02-0700000000000000000000000
Nigeria2020-02-0700000000000000000000000
North Macedonia2020-02-0700000000000000000000000
Pakistan2020-02-0700000000000000000000000
Panama2020-02-0700000000000000000000000
Peru2020-02-0700000000000000000000000
Philippines2020-02-0780005010011001000000003
Poland2020-02-0700000000000000000000000
Portugal2020-02-0700000000000000000000000
Qatar2020-02-0700000000000000000000000
Romania2020-02-0700000000000000000000000
Russia2020-02-0770000020020000000000002
Saudi Arabia2020-02-0700000000000000000000000
Serbia2020-02-0700000000000000000000000
Singapore2020-02-0715000001300131000107007700730
Slovakia2020-02-0700000000000000000000000
Slovenia2020-02-0700000000000000000000000
South Africa2020-02-0700000000000000000000000
Spain2020-02-0760000000000000000000001
Sweden2020-02-0770000010010000000000001
Switzerland2020-02-0700000000000000000000000
Thailand2020-02-071601200019501414509145091450925
Tunisia2020-02-0700000000000000000000000
Turkey2020-02-0700000000000000000000000
Ukraine2020-02-0700000000000000000000000
United Arab Emirates2020-02-0790000040044004400400005
United Kingdom2020-02-0770000020020000000000003
Uruguay2020-02-0700000000000000000000000
US2020-02-071600000700750055005500511
Venezuela2020-02-0700000000000000000000000
Afghanistan2020-02-0800000000000000000000000
Albania2020-02-0800000000000000000000000
Algeria2020-02-0800000000000000000000000
Andorra2020-02-0800000000000000000000000
Argentina2020-02-0800000000000000000000000
Armenia2020-02-0800000000000000000000000
Australia2020-02-08130900012201092079207600615
Austria2020-02-0800000000000000000000000
Azerbaijan2020-02-0800000000000000000000000
Bangladesh2020-02-0800000000000000000000000
Belarus2020-02-0800000000000000000000000
Belgium2020-02-0840000000000000000000001
Bosnia and Herzegovina2020-02-0800000000000000000000000
Brazil2020-02-0800000000000000000000000
Bulgaria2020-02-0800000000000000000000000
Burkina Faso2020-02-0800000000000000000000000
Cameroon2020-02-0800000000000000000000000
Canada2020-02-08130000040044004200220027
Chile2020-02-0800000000000000000000000
China2020-02-08171717111717118912752591135798022142139375814113517178356087120133583436814
Colombia2020-02-0800000000000000000000000
Cote d'Ivoire2020-02-0800000000000000000000000
Croatia2020-02-0800000000000000000000000
Cuba2020-02-0800000000000000000000000
Czechia2020-02-0800000000000000000000000
Denmark2020-02-0800000000000000000000000
Diamond Princess2020-02-08100000000000000000000061
Dominican Republic2020-02-0800000000000000000000000
Ecuador2020-02-0800000000000000000000000
Egypt2020-02-0800000000000000000000000
Estonia2020-02-0800000000000000000000000
Finland2020-02-08100000010011001100110011
France2020-02-081500000600650055005500511
Germany2020-02-081200000800850054004400413
Greece2020-02-0800000000000000000000000
Hungary2020-02-0800000000000000000000000
Iceland2020-02-0800000000000000000000000
India2020-02-0890000010011001100100003
Indonesia2020-02-0800000000000000000000000
Iran2020-02-0800000000000000000000000
Iraq2020-02-0800000000000000000000000
Ireland2020-02-0800000000000000000000000
Israel2020-02-0800000000000000000000000
Italy2020-02-0880000020022002000000003
Japan2020-02-0817013000201019151014111010710625
Kazakhstan2020-02-0800000000000000000000000
Korea South2020-02-08170100012001211001140044004
Kuwait2020-02-0800000000000000000000000
Latvia2020-02-0800000000000000000000000
Lebanon2020-02-0800000000000000000000000
Lithuania2020-02-0800000000000000000000000
Luxembourg2020-02-0800000000000000000000000
Malaysia2020-02-081401000800880088008700716
Mexico2020-02-0800000000000000000000000
Moldova2020-02-0800000000000000000000000
Morocco2020-02-0800000000000000000000000
Netherlands2020-02-0800000000000000000000000
New Zealand2020-02-0800000000000000000000000
Niger2020-02-0800000000000000000000000
Nigeria2020-02-0800000000000000000000000
North Macedonia2020-02-0800000000000000000000000
Pakistan2020-02-0800000000000000000000000
Panama2020-02-0800000000000000000000000
Peru2020-02-0800000000000000000000000
Philippines2020-02-0890006010011001100100003
Poland2020-02-0800000000000000000000000
Portugal2020-02-0800000000000000000000000
Qatar2020-02-0800000000000000000000000
Romania2020-02-0800000000000000000000000
Russia2020-02-0880000020022002000000002
Saudi Arabia2020-02-0800000000000000000000000
Serbia2020-02-0800000000000000000000000
Singapore2020-02-081600000160016130013100010700733
Slovakia2020-02-0800000000000000000000000
Slovenia2020-02-0800000000000000000000000
South Africa2020-02-0800000000000000000000000
Spain2020-02-0870000010010000000000001
Sweden2020-02-0880000010011001000000001
Switzerland2020-02-0800000000000000000000000
Thailand2020-02-0817013000195014195014145091450932
Tunisia2020-02-0800000000000000000000000
Turkey2020-02-0800000000000000000000000
Ukraine2020-02-0800000000000000000000000
United Arab Emirates2020-02-08100000040044004400440047
United Kingdom2020-02-0880000020022002000000003
Uruguay2020-02-0800000000000000000000000
US2020-02-081700000800870075005500511
Venezuela2020-02-0800000000000000000000000
Afghanistan2020-02-0900000000000000000000000
Albania2020-02-0900000000000000000000000
Algeria2020-02-0900000000000000000000000
Andorra2020-02-0900000000000000000000000
Argentina2020-02-0900000000000000000000000
Armenia2020-02-0900000000000000000000000
Australia2020-02-09140100001220101220109207920715
Austria2020-02-0900000000000000000000000
Azerbaijan2020-02-0900000000000000000000000
Bangladesh2020-02-0900000000000000000000000
Belarus2020-02-0900000000000000000000000
Belgium2020-02-0950000000000000000000001
Bosnia and Herzegovina2020-02-0900000000000000000000000
Brazil2020-02-0900000000000000000000000
Bulgaria2020-02-0900000000000000000000000
Burkina Faso2020-02-0900000000000000000000000
Cameroon2020-02-0900000000000000000000000
Canada2020-02-09140000040044004400420027
Chile2020-02-0900000000000000000000000
China2020-02-0918181812181816630463361158061189127525911357980221421393758141135171783539829
Colombia2020-02-0900000000000000000000000
Cote d'Ivoire2020-02-0900000000000000000000000
Croatia2020-02-0900000000000000000000000
Cuba2020-02-0900000000000000000000000
Czechia2020-02-0900000000000000000000000
Denmark2020-02-0900000000000000000000000
Diamond Princess2020-02-09200000000000000000000064
Dominican Republic2020-02-0900000000000000000000000
Ecuador2020-02-0900000000000000000000000
Egypt2020-02-0900000000000000000000000
Estonia2020-02-0900000000000000000000000
Finland2020-02-09110000010011001100110011
France2020-02-091600000600660065005500511
Germany2020-02-09130000010001080085005400414
Greece2020-02-0900000000000000000000000
Hungary2020-02-0900000000000000000000000
Iceland2020-02-0900000000000000000000000
India2020-02-09100000020021001100110013
Indonesia2020-02-0900000000000000000000000
Iran2020-02-0900000000000000000000000
Iraq2020-02-0900000000000000000000000
Ireland2020-02-0900000000000000000000000
Israel2020-02-0900000000000000000000000
Italy2020-02-0990000020022002200200003
Japan2020-02-091801400020101920101915101411101026
Kazakhstan2020-02-0900000000000000000000000
Korea South2020-02-0918020001500151200121100114004
Kuwait2020-02-0900000000000000000000000
Latvia2020-02-0900000000000000000000000
Lebanon2020-02-0900000000000000000000000
Lithuania2020-02-0900000000000000000000000
Luxembourg2020-02-0900000000000000000000000
Malaysia2020-02-091502000800880088008800816
Mexico2020-02-0900000000000000000000000
Moldova2020-02-0900000000000000000000000
Morocco2020-02-0900000000000000000000000
Netherlands2020-02-0900000000000000000000000
New Zealand2020-02-0900000000000000000000000
Niger2020-02-0900000000000000000000000
Nigeria2020-02-0900000000000000000000000
North Macedonia2020-02-0900000000000000000000000
Pakistan2020-02-0900000000000000000000000
Panama2020-02-0900000000000000000000000
Peru2020-02-0900000000000000000000000
Philippines2020-02-09100007020111001100110013
Poland2020-02-0900000000000000000000000
Portugal2020-02-0900000000000000000000000
Qatar2020-02-0900000000000000000000000
Romania2020-02-0900000000000000000000000
Russia2020-02-0990000020022002200200002
Saudi Arabia2020-02-0900000000000000000000000
Serbia2020-02-0900000000000000000000000
Singapore2020-02-09170100018001816001613001310001040
Slovakia2020-02-0900000000000000000000000
Slovenia2020-02-0900000000000000000000000
South Africa2020-02-0900000000000000000000000
Spain2020-02-0980000010011001000000002
Sweden2020-02-0990000010011001100100001
Switzerland2020-02-0900000000000000000000000
Thailand2020-02-09180140001950141950141950141450932
Tunisia2020-02-0900000000000000000000000
Turkey2020-02-0900000000000000000000000
Ukraine2020-02-0900000000000000000000000
United Arab Emirates2020-02-09110000050054004400440047
United Kingdom2020-02-0990000020022002200200003
Uruguay2020-02-0900000000000000000000000
US2020-02-091800000800880087007500511
Venezuela2020-02-0900000000000000000000000
Afghanistan2020-02-1000000000000000000000000
Albania2020-02-1000000000000000000000000
Algeria2020-02-1000000000000000000000000
Andorra2020-02-1000000000000000000000000
Argentina2020-02-1000000000000000000000000
Armenia2020-02-1000000000000000000000000
Australia2020-02-1015011000122010122010122010920715
Austria2020-02-1000000000000000000000000
Azerbaijan2020-02-1000000000000000000000000
Bangladesh2020-02-1000000000000000000000000
Belarus2020-02-1000000000000000000000000
Belgium2020-02-1060000000000000000000001
Bosnia and Herzegovina2020-02-1000000000000000000000000
Brazil2020-02-1000000000000000000000000
Bulgaria2020-02-1000000000000000000000000
Burkina Faso2020-02-1000000000000000000000000
Cameroon2020-02-1000000000000000000000000
Canada2020-02-10150000040044004400440047
Chile2020-02-1000000000000000000000000
China2020-02-101919191319191971661442518677166304633611580611891275259113579802214213937542354
Colombia2020-02-1000000000000000000000000
Cote d'Ivoire2020-02-1000000000000000000000000
Croatia2020-02-1000000000000000000000000
Cuba2020-02-1000000000000000000000000
Czechia2020-02-1000000000000000000000000
Denmark2020-02-1000000000000000000000000
Diamond Princess2020-02-103000000000000000000000135
Dominican Republic2020-02-1000000000000000000000000
Ecuador2020-02-1000000000000000000000000
Egypt2020-02-1000000000000000000000000
Estonia2020-02-1000000000000000000000000
Finland2020-02-10120000010011001100110011
France2020-02-101700000600660066006500511
Germany2020-02-1014000001200121000108008500514
Greece2020-02-1000000000000000000000000
Hungary2020-02-1000000000000000000000000
Iceland2020-02-1000000000000000000000000
India2020-02-10110000030032002100110013
Indonesia2020-02-1000000000000000000000000
Iran2020-02-1000000000000000000000000
Iraq2020-02-1000000000000000000000000
Ireland2020-02-1000000000000000000000000
Israel2020-02-1000000000000000000000000
Italy2020-02-10100000020022002200220023
Japan2020-02-101901500020101920101920101915101426
Kazakhstan2020-02-1000000000000000000000000
Korea South2020-02-101903000150015150015120012110011
Kuwait2020-02-1000000000000000000000000
Latvia2020-02-1000000000000000000000000
Lebanon2020-02-1000000000000000000000000
Lithuania2020-02-1000000000000000000000000
Luxembourg2020-02-1000000000000000000000000
Malaysia2020-02-101603000800880088008800818
Mexico2020-02-1000000000000000000000000
Moldova2020-02-1000000000000000000000000
Morocco2020-02-1000000000000000000000000
Netherlands2020-02-1000000000000000000000000
New Zealand2020-02-1000000000000000000000000
Niger2020-02-1000000000000000000000000
Nigeria2020-02-1000000000000000000000000
North Macedonia2020-02-1000000000000000000000000
Pakistan2020-02-1000000000000000000000000
Panama2020-02-1000000000000000000000000
Peru2020-02-1000000000000000000000000
Philippines2020-02-10110008020112011100110013
Poland2020-02-1000000000000000000000000
Portugal2020-02-1000000000000000000000000
Qatar2020-02-1000000000000000000000000
Romania2020-02-1000000000000000000000000
Russia2020-02-10100000020022002200220022
Saudi Arabia2020-02-1000000000000000000000000
Serbia2020-02-1000000000000000000000000
Singapore2020-02-10180200018001818001816001613001345
Slovakia2020-02-1000000000000000000000000
Slovenia2020-02-1000000000000000000000000
South Africa2020-02-1000000000000000000000000
Spain2020-02-1090000010011001100100002
Sweden2020-02-10100000010011001100110011
Switzerland2020-02-1000000000000000000000000
Thailand2020-02-101901500019501419501419501419501432
Tunisia2020-02-1000000000000000000000000
Turkey2020-02-1000000000000000000000000
Ukraine2020-02-1000000000000000000000000
United Arab Emirates2020-02-10120000050055005400440048
United Kingdom2020-02-10100000020022002200220028
Uruguay2020-02-1000000000000000000000000
US2020-02-10190100011001180088008700711
Venezuela2020-02-1000000000000000000000000
Afghanistan2020-02-1100000000000000000000000
Albania2020-02-1100000000000000000000000
Algeria2020-02-1100000000000000000000000
Andorra2020-02-1100000000000000000000000
Argentina2020-02-1100000000000000000000000
Armenia2020-02-1100000000000000000000000
Australia2020-02-111601200013201112201012201012201015
Austria2020-02-1100000000000000000000000
Azerbaijan2020-02-1100000000000000000000000
Bangladesh2020-02-1100000000000000000000000
Belarus2020-02-1100000000000000000000000
Belgium2020-02-1170000010010000000000001
Bosnia and Herzegovina2020-02-1100000000000000000000000
Brazil2020-02-1100000000000000000000000
Bulgaria2020-02-1100000000000000000000000
Burkina Faso2020-02-1100000000000000000000000
Cameroon2020-02-1100000000000000000000000
Canada2020-02-11160000040044004400440047
Chile2020-02-1100000000000000000000000
China2020-02-11202020142020237078434912237319716614425186771663046336115806118912752591135744386
Colombia2020-02-1100000000000000000000000
Cote d'Ivoire2020-02-1100000000000000000000000
Croatia2020-02-1100000000000000000000000
Cuba2020-02-1100000000000000000000000
Czechia2020-02-1100000000000000000000000
Denmark2020-02-1100000000000000000000000
Diamond Princess2020-02-114100000000000000000000135
Dominican Republic2020-02-1100000000000000000000000
Ecuador2020-02-1100000000000000000000000
Egypt2020-02-1100000000000000000000000
Estonia2020-02-1100000000000000000000000
Finland2020-02-11130000010011001100110011
France2020-02-111800000600660066006600611
Germany2020-02-111500000120012120012100010800816
Greece2020-02-1100000000000000000000000
Hungary2020-02-1100000000000000000000000
Iceland2020-02-1100000000000000000000000
India2020-02-11120000030033003200210013
Indonesia2020-02-1100000000000000000000000
Iran2020-02-1100000000000000000000000
Iraq2020-02-1100000000000000000000000
Ireland2020-02-1100000000000000000000000
Israel2020-02-1100000000000000000000000
Italy2020-02-11110000020022002200220023
Japan2020-02-112001600022102120101920101920101926
Kazakhstan2020-02-1100000000000000000000000
Korea South2020-02-112004000160016150015150015120012
Kuwait2020-02-1100000000000000000000000
Latvia2020-02-1100000000000000000000000
Lebanon2020-02-1100000000000000000000000
Lithuania2020-02-1100000000000000000000000
Luxembourg2020-02-1100000000000000000000000
Malaysia2020-02-11170400010001080088008800818
Mexico2020-02-1100000000000000000000000
Moldova2020-02-1100000000000000000000000
Morocco2020-02-1100000000000000000000000
Netherlands2020-02-1100000000000000000000000
New Zealand2020-02-1100000000000000000000000
Niger2020-02-1100000000000000000000000
Nigeria2020-02-1100000000000000000000000
North Macedonia2020-02-1100000000000000000000000
Pakistan2020-02-1100000000000000000000000
Panama2020-02-1100000000000000000000000
Peru2020-02-1100000000000000000000000
Philippines2020-02-11120009020112011201110013
Poland2020-02-1100000000000000000000000
Portugal2020-02-1100000000000000000000000
Qatar2020-02-1100000000000000000000000
Romania2020-02-1100000000000000000000000
Russia2020-02-11110000020022002200220022
Saudi Arabia2020-02-1100000000000000000000000
Serbia2020-02-1100000000000000000000000
Singapore2020-02-11190300024002418001818001816001647
Slovakia2020-02-1100000000000000000000000
Slovenia2020-02-1100000000000000000000000
South Africa2020-02-1100000000000000000000000
Spain2020-02-11100000010011001100110012
Sweden2020-02-11110000010011001100110011
Switzerland2020-02-1100000000000000000000000
Thailand2020-02-112001600025502019501419501419501433
Tunisia2020-02-1100000000000000000000000
Turkey2020-02-1100000000000000000000000
Ukraine2020-02-1100000000000000000000000
United Arab Emirates2020-02-11130000050055005500540048
United Kingdom2020-02-11110000020022002200220028
Uruguay2020-02-1100000000000000000000000
US2020-02-1120020001100111100118008800812
Venezuela2020-02-1100000000000000000000000
Afghanistan2020-02-1200000000000000000000000
Albania2020-02-1200000000000000000000000
Algeria2020-02-1200000000000000000000000
Andorra2020-02-1200000000000000000000000
Argentina2020-02-1200000000000000000000000
Armenia2020-02-1200000000000000000000000
Australia2020-02-121701300013201113201112201012201015
Austria2020-02-1200000000000000000000000
Azerbaijan2020-02-1200000000000000000000000
Bangladesh2020-02-1200000000000000000000000
Belarus2020-02-1200000000000000000000000
Belgium2020-02-1280000010011001000000001
Bosnia and Herzegovina2020-02-1200000000000000000000000
Brazil2020-02-1200000000000000000000000
Bulgaria2020-02-1200000000000000000000000
Burkina Faso2020-02-1200000000000000000000000
Cameroon2020-02-1200000000000000000000000
Canada2020-02-12170000050054004400440047
Chile2020-02-1200000000000000000000000
China2020-02-122121211521212744011155632576223707843491223731971661442518677166304633611580644759
Colombia2020-02-1200000000000000000000000
Cote d'Ivoire2020-02-1200000000000000000000000
Croatia2020-02-1200000000000000000000000
Cuba2020-02-1200000000000000000000000
Czechia2020-02-1200000000000000000000000
Denmark2020-02-1200000000000000000000000
Diamond Princess2020-02-125200000000000000000000175
Dominican Republic2020-02-1200000000000000000000000
Ecuador2020-02-1200000000000000000000000
Egypt2020-02-1200000000000000000000000
Estonia2020-02-1200000000000000000000000
Finland2020-02-12140000010011001100110011

In [5]:
# With this registered as a temp view, it will only be available to this particular notebook. If you'd like other users to be able to query this table, you can also create a table from the DataFrame.
# Once saved, this table will persist across cluster restarts as well as allow various users across different notebooks to query this data.
# To do so, choose your table name and uncomment the bottom line.

permanent_table_name = "covid19_spread"
df.write.format("parquet").saveAsTable(permanent_table_name)