def write_countries_data():
countries = ['AUSTRALIA',
'AUSTRIA',
'CANADA',
'CHINA',
'DENMARK',
'FINLAND',
'FRANCE',
'GERMANY',
'ICELAND',
'IRELAND',
'ITALY',
'NETHERLANDS',
'NORWAY',
'RUSSIA',
'SWEDEN',
'SWITZERLAND',
'UNITEDKINGDOM',
'US',
'SPAIN',
'MEXICO',
'CHILE',
'BRAZIL',
'PERU',
'COLOMBIA',
'JAPAN',
'UKRAINE',
'INDIA',
'PAKISTAN',
'AFGHANISTAN',
'ALBANIA',
'ALGERIA',
'ANDORRA',
'ANGOLA',
'ANTIGUAANDBARBUDA',
'ARGENTINA',
'ARMENIA',
'AZERBAIJAN',
'BAHAMAS',
'BAHRAIN',
'BANGLADESH',
'BARBADOS',
'BELARUS',
'BELGIUM',
'BELIZE',
'BENIN',
'BHUTAN',
'BOLIVIA',
'BOSNIAANDHERZEGOVINA',
'BOTSWANA',
'BRUNEI',
'BULGARIA',
'BURKINAFASO',
'BURMA',
'BURUNDI',
'CABOVERDE',
'CAMBODIA',
'CAMEROON',
'CENTRALAFRICANREPUBLIC',
'CHAD',
'COMOROS',
'CONGOBRAZZAVILLE',
'CONGOKINSHASA',
'COSTARICA',
'COTEDIVOIRE',
'CROATIA',
'CUBA',
'CYPRUS',
'CZECHIA',
'DIAMONDPRINCESS',
'DJIBOUTI',
'DOMINICA',
'DOMINICANREPUBLIC',
'ECUADOR',
'EGYPT',
'ELSALVADOR',
'EQUATORIALGUINEA',
'ERITREA',
'ESTONIA',
'ESWATINI',
'ETHIOPIA',
'FIJI',
'GABON',
'GAMBIA',
'GEORGIA',
'GHANA',
'GREECE',
'GRENADA',
'GUATEMALA',
'GUINEA',
'GUINEABISSAU',
'GUYANA',
'HAITI',
'HOLYSEE',
'HONDURAS',
'HUNGARY',
'INDONESIA',
'IRAN',
'IRAQ',
'ISRAEL',
'JAMAICA',
'JORDAN',
'KAZAKHSTAN',
'KENYA',
'KOREASOUTH',
'KOSOVO',
'KUWAIT',
'KYRGYZSTAN',
'LAOS',
'LATVIA',
'LEBANON',
'LESOTHO',
'LIBERIA',
'LIBYA',
'LIECHTENSTEIN',
'LITHUANIA',
'LUXEMBOURG',
'MSZAANDAM',
'MADAGASCAR',
'MALAWI',
'MALAYSIA',
'MALDIVES',
'MALI',
'MALTA',
'MAURITANIA',
'MAURITIUS',
'MOLDOVA',
'MONACO',
'MONGOLIA',
'MONTENEGRO',
'MOROCCO',
'MOZAMBIQUE',
'NAMIBIA',
'NEPAL',
'NEWZEALAND',
'NICARAGUA',
'NIGER',
'NIGERIA',
'NORTHMACEDONIA',
'OMAN',
'PANAMA',
'PAPUANEWGUINEA',
'PARAGUAY',
'PHILIPPINES',
'POLAND',
'PORTUGAL',
'QATAR',
'ROMANIA',
'RWANDA',
'SAINTKITTSANDNEVIS',
'SAINTLUCIA',
'SAINTVINCENTANDTHEGRENADINES',
'SANMARINO',
'SAOTOMEANDPRINCIPE',
'SAUDIARABIA',
'SENEGAL',
'SERBIA',
'SEYCHELLES',
'SIERRALEONE',
'SINGAPORE',
'SLOVAKIA',
'SLOVENIA',
'SOMALIA',
'SOUTHAFRICA',
'SOUTHSUDAN',
'SRILANKA',
'SUDAN',
'SURINAME',
'SYRIA',
'TAIWAN',
'TAJIKISTAN',
'TANZANIA',
'THAILAND',
'TIMORLESTE',
'TOGO',
'TRINIDADANDTOBAGO',
'TUNISIA',
'TURKEY',
'UGANDA',
'UNITEDARABEMIRATES',
'URUGUAY',
'UZBEKISTAN',
'VENEZUELA',
'VIETNAM',
'WESTBANKANDGAZA',
'WESTERNSAHARA',
'YEMEN',
'ZAMBIA',
'ZIMBABWE']
countries.sort()
countries_sheet = gsheets.Sheet(cred_file, scope, sheet_name, 'Countries', state_data)
countries_sheet.write_data(country_list=countries)
def write_china_data():
china_sheet = gsheets.Sheet(cred_file, scope, sheet_name, 'China')
china = JHU.China
china_sheet.write_data(china.cases, china.deaths, china.recovered)
def write_us_data():
us_sheet = gsheets.Sheet(cred_file, scope, sheet_name, 'US', state_data)
us = JHU.US
get_all_state_data()
us_sheet.write_data(us.cases, us.deaths, us.recovered, state_data)
def write_world_data():
world_sheet = gsheets.Sheet(cred_file, scope, sheet_name, 'World')
total = JHU.Total
world_sheet.write_data(total.cases, total.deaths, total.recovered)