Skip to content

Instantly share code, notes, and snippets.

@wildmolasses

wildmolasses/script.R

Last active March 16, 2020 06:17
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save wildmolasses/040f43ebe4f900f7f481ffeb3c963f02 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save wildmolasses/040f43ebe4f900f7f481ffeb3c963f02 to your computer and use it in GitHub Desktop.
Download ZIP
COVID-19 hacking
Raw
script.R
require(tidyverse)
original.data <- read_csv("https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_19-covid-Confirmed.csv")
# combined data with simple state column
data <- original.data %>%
filter(`Country/Region` == 'US') %>%
mutate(State = sub(".*,\ ", "", `Province/State`)) %>%
rowwise() %>%
mutate(State = ifelse(nchar(State) == 2, state.name[grep(State, state.abb)], `Province/State`)) %>%
ungroup() %>%
select_if(function(x) {is.character(x) || sum(x) != 0}) %>%
select(State, c(1:"State")) %>%
group_by(State) %>%
summarize_at(vars(-`Province/State`, -`Country/Region`, -Lat, -Long), ~sum(.)) %>%
ungroup() %>%
mutate(sumConfirmed = rowSums((.)[-c(1:4)])) %>%
select(c(State, sumConfirmed), everything())
# simple confirmed cases plot, top 10 states
data %>%
arrange(desc(sumConfirmed)) %>%
top_n(10) %>%
select(-sumConfirmed) %>%
group_by(State) %>%
gather(key = "date", value="nConfirmed", -c(State)) %>%
mutate(date = as.Date(date, format="%m/%d/%y")) %>%
mutate(log.nConfirmed = log(nConfirmed)) %>%
ggplot(aes(x=date, y=nConfirmed, color=State)) +
geom_line()
Raw
zz-arcgis-response.json
{
"objectIdFieldName": "OBJECTID",
"uniqueIdField": {
"name": "OBJECTID",
"isSystemMaintained": true
},
"globalIdFieldName": "",
"geometryType": "esriGeometryPoint",
"spatialReference": {
"wkid": 102100,
"latestWkid": 3857
},
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"sqlType": "sqlTypeOther",
"domain": null,
"defaultValue": null
},
{
"name": "Country_Region",
"type": "esriFieldTypeString",
"alias": "Country_Region",
"sqlType": "sqlTypeOther",
"length": 8000,
"domain": null,
"defaultValue": null
},
{
"name": "Last_Update",
"type": "esriFieldTypeDate",
"alias": "Last_Update",
"sqlType": "sqlTypeOther",
"length": 8,
"domain": null,
"defaultValue": null
},
{
"name": "Lat",
"type": "esriFieldTypeDouble",
"alias": "Lat",
"sqlType": "sqlTypeOther",
"domain": null,
"defaultValue": null
},
{
"name": "Long_",
"type": "esriFieldTypeDouble",
"alias": "Long",
"sqlType": "sqlTypeOther",
"domain": null,
"defaultValue": null
},
{
"name": "Confirmed",
"type": "esriFieldTypeInteger",
"alias": "Confirmed",
"sqlType": "sqlTypeOther",
"domain": null,
"defaultValue": null
},
{
"name": "Deaths",
"type": "esriFieldTypeInteger",
"alias": "Deaths",
"sqlType": "sqlTypeOther",
"domain": null,
"defaultValue": null
},
{
"name": "Recovered",
"type": "esriFieldTypeInteger",
"alias": "Recovered",
"sqlType": "sqlTypeOther",
"domain": null,
"defaultValue": null
},
{
"name": "Active",
"type": "esriFieldTypeInteger",
"alias": "Active",
"sqlType": "sqlTypeOther",
"domain": null,
"defaultValue": null
}
],
"features": [
{
"attributes": {
"OBJECTID": 53,
"Country_Region": "China",
"Last_Update": 1584097775000,
"Lat": 30.5928,
"Long_": 114.3055,
"Confirmed": 81020,
"Deaths": 3217,
"Recovered": 67843,
"Active": 9960
}
},
{
"attributes": {
"OBJECTID": 115,
"Country_Region": "Italy",
"Last_Update": 1584318130000,
"Lat": 41.8719,
"Long_": 12.5674,
"Confirmed": 24747,
"Deaths": 1809,
"Recovered": 2335,
"Active": 20603
}
},
{
"attributes": {
"OBJECTID": 84,
"Country_Region": "Iran",
"Last_Update": 1584296418000,
"Lat": 32.4279,
"Long_": 53.688,
"Confirmed": 13938,
"Deaths": 724,
"Recovered": 4590,
"Active": 8624
}
},
{
"attributes": {
"OBJECTID": 106,
"Country_Region": "Korea, South",
"Last_Update": 1584322383000,
"Lat": 35.9078,
"Long_": 127.7669,
"Confirmed": 8162,
"Deaths": 75,
"Recovered": 834,
"Active": 7253
}
},
{
"attributes": {
"OBJECTID": 18,
"Country_Region": "Spain",
"Last_Update": 1584321191000,
"Lat": 40.4637,
"Long_": -3.7492,
"Confirmed": 7844,
"Deaths": 292,
"Recovered": 517,
"Active": 7035
}
},
{
"attributes": {
"OBJECTID": 17,
"Country_Region": "Germany",
"Last_Update": 1584324795000,
"Lat": 51.1657,
"Long_": 10.4515,
"Confirmed": 5813,
"Deaths": 13,
"Recovered": 46,
"Active": 5754
}
},
{
"attributes": {
"OBJECTID": 44,
"Country_Region": "France",
"Last_Update": 1584203583000,
"Lat": 17.9,
"Long_": -62.8333,
"Confirmed": 5437,
"Deaths": 127,
"Recovered": 12,
"Active": 5298
}
},
{
"attributes": {
"OBJECTID": 69,
"Country_Region": "US",
"Last_Update": 1584325988000,
"Lat": 40,
"Long_": -100,
"Confirmed": 3774,
"Deaths": 69,
"Recovered": 12,
"Active": 3693
}
},
{
"attributes": {
"OBJECTID": 98,
"Country_Region": "Switzerland",
"Last_Update": 1584296418000,
"Lat": 46.8182,
"Long_": 8.2275,
"Confirmed": 2200,
"Deaths": 14,
"Recovered": 4,
"Active": 2182
}
},
{
"attributes": {
"OBJECTID": 92,
"Country_Region": "Denmark",
"Last_Update": 1584325988000,
"Lat": 56,
"Long_": 10,
"Confirmed": 1739,
"Deaths": 5,
"Recovered": 2,
"Active": 1732
}
},
{
"attributes": {
"OBJECTID": 145,
"Country_Region": "United Kingdom",
"Last_Update": 1584296418000,
"Lat": 55,
"Long_": -3,
"Confirmed": 1395,
"Deaths": 35,
"Recovered": 21,
"Active": 1339
}
},
{
"attributes": {
"OBJECTID": 48,
"Country_Region": "Norway",
"Last_Update": 1584322383000,
"Lat": 60.472,
"Long_": 8.4689,
"Confirmed": 1256,
"Deaths": 3,
"Recovered": 1,
"Active": 1252
}
},
{
"attributes": {
"OBJECTID": 19,
"Country_Region": "Netherlands",
"Last_Update": 1584324795000,
"Lat": 52.3167,
"Long_": 5.55,
"Confirmed": 1136,
"Deaths": 20,
"Recovered": 2,
"Active": 1114
}
},
{
"attributes": {
"OBJECTID": 61,
"Country_Region": "Sweden",
"Last_Update": 1584321191000,
"Lat": 60.1282,
"Long_": 18.6435,
"Confirmed": 1032,
"Deaths": 3,
"Recovered": 1,
"Active": 1028
}
},
{
"attributes": {
"OBJECTID": 88,
"Country_Region": "Belgium",
"Last_Update": 1584296418000,
"Lat": 50.5039,
"Long_": 4.4699,
"Confirmed": 886,
"Deaths": 4,
"Recovered": 1,
"Active": 881
}
},
{
"attributes": {
"OBJECTID": 71,
"Country_Region": "Austria",
"Last_Update": 1584318130000,
"Lat": 47.5162,
"Long_": 14.5501,
"Confirmed": 860,
"Deaths": 1,
"Recovered": 6,
"Active": 853
}
},
{
"attributes": {
"OBJECTID": 72,
"Country_Region": "Japan",
"Last_Update": 1584323583000,
"Lat": 36.2048,
"Long_": 138.2529,
"Confirmed": 839,
"Deaths": 22,
"Recovered": 144,
"Active": 673
}
},
{
"attributes": {
"OBJECTID": 7,
"Country_Region": "Cruise Ship",
"Last_Update": 1584108805000,
"Lat": 35.4498,
"Long_": 139.6649,
"Confirmed": 696,
"Deaths": 7,
"Recovered": 325,
"Active": 364
}
},
{
"attributes": {
"OBJECTID": 70,
"Country_Region": "Malaysia",
"Last_Update": 1584296418000,
"Lat": 4.2105,
"Long_": 101.9758,
"Confirmed": 428,
"Deaths": 0,
"Recovered": 42,
"Active": 386
}
},
{
"attributes": {
"OBJECTID": 114,
"Country_Region": "Qatar",
"Last_Update": 1584318130000,
"Lat": 25.3548,
"Long_": 51.1839,
"Confirmed": 401,
"Deaths": 0,
"Recovered": 4,
"Active": 397
}
},
{
"attributes": {
"OBJECTID": 1,
"Country_Region": "Canada",
"Last_Update": 1584318130000,
"Lat": 60.001,
"Long_": -95.001,
"Confirmed": 339,
"Deaths": 1,
"Recovered": 9,
"Active": 329
}
},
{
"attributes": {
"OBJECTID": 146,
"Country_Region": "Greece",
"Last_Update": 1584318130000,
"Lat": 39.0742,
"Long_": 21.8243,
"Confirmed": 331,
"Deaths": 4,
"Recovered": 8,
"Active": 319
}
},
{
"attributes": {
"OBJECTID": 83,
"Country_Region": "Australia",
"Last_Update": 1584318130000,
"Lat": -25,
"Long_": 133,
"Confirmed": 297,
"Deaths": 3,
"Recovered": 23,
"Active": 271
}
},
{
"attributes": {
"OBJECTID": 86,
"Country_Region": "Czechia",
"Last_Update": 1584325988000,
"Lat": 49.8175,
"Long_": 15.473,
"Confirmed": 293,
"Deaths": 0,
"Recovered": 0,
"Active": 293
}
},
{
"attributes": {
"OBJECTID": 125,
"Country_Region": "Israel",
"Last_Update": 1584318130000,
"Lat": 31.0461,
"Long_": 34.8516,
"Confirmed": 251,
"Deaths": 0,
"Recovered": 4,
"Active": 247
}
},
{
"attributes": {
"OBJECTID": 101,
"Country_Region": "Portugal",
"Last_Update": 1584296418000,
"Lat": 39.3999,
"Long_": -8.2245,
"Confirmed": 245,
"Deaths": 0,
"Recovered": 2,
"Active": 243
}
},
{
"attributes": {
"OBJECTID": 58,
"Country_Region": "Finland",
"Last_Update": 1584318130000,
"Lat": 61.9241,
"Long_": 25.7482,
"Confirmed": 244,
"Deaths": 0,
"Recovered": 10,
"Active": 234
}
},
{
"attributes": {
"OBJECTID": 143,
"Country_Region": "Singapore",
"Last_Update": 1584296418000,
"Lat": 1.3521,
"Long_": 103.8198,
"Confirmed": 226,
"Deaths": 0,
"Recovered": 105,
"Active": 121
}
},
{
"attributes": {
"OBJECTID": 13,
"Country_Region": "Slovenia",
"Last_Update": 1584296418000,
"Lat": 46.1512,
"Long_": 14.9955,
"Confirmed": 219,
"Deaths": 1,
"Recovered": 0,
"Active": 218
}
},
{
"attributes": {
"OBJECTID": 11,
"Country_Region": "Bahrain",
"Last_Update": 1584325988000,
"Lat": 26.0667,
"Long_": 50.5577,
"Confirmed": 214,
"Deaths": 0,
"Recovered": 77,
"Active": 137
}
},
{
"attributes": {
"OBJECTID": 73,
"Country_Region": "Brazil",
"Last_Update": 1584325988000,
"Lat": -14.235,
"Long_": -51.9253,
"Confirmed": 200,
"Deaths": 0,
"Recovered": 1,
"Active": 199
}
},
{
"attributes": {
"OBJECTID": 126,
"Country_Region": "Iceland",
"Last_Update": 1584324795000,
"Lat": 64.9631,
"Long_": -19.0208,
"Confirmed": 180,
"Deaths": 0,
"Recovered": 0,
"Active": 180
}
},
{
"attributes": {
"OBJECTID": 102,
"Country_Region": "Estonia",
"Last_Update": 1584318130000,
"Lat": 58.5953,
"Long_": 25.0136,
"Confirmed": 171,
"Deaths": 0,
"Recovered": 1,
"Active": 170
}
},
{
"attributes": {
"OBJECTID": 93,
"Country_Region": "Philippines",
"Last_Update": 1584322383000,
"Lat": 12.8797,
"Long_": 121.774,
"Confirmed": 140,
"Deaths": 12,
"Recovered": 2,
"Active": 126
}
},
{
"attributes": {
"OBJECTID": 65,
"Country_Region": "Romania",
"Last_Update": 1584322383000,
"Lat": 45.9432,
"Long_": 24.9668,
"Confirmed": 139,
"Deaths": 0,
"Recovered": 9,
"Active": 130
}
},
{
"attributes": {
"OBJECTID": 79,
"Country_Region": "Ireland",
"Last_Update": 1584216796000,
"Lat": 53.1424,
"Long_": -7.6921,
"Confirmed": 129,
"Deaths": 2,
"Recovered": 0,
"Active": 127
}
},
{
"attributes": {
"OBJECTID": 108,
"Country_Region": "Egypt",
"Last_Update": 1584325988000,
"Lat": 26.8206,
"Long_": 30.8025,
"Confirmed": 126,
"Deaths": 2,
"Recovered": 27,
"Active": 97
}
},
{
"attributes": {
"OBJECTID": 133,
"Country_Region": "Poland",
"Last_Update": 1584322383000,
"Lat": 51.9194,
"Long_": 19.1451,
"Confirmed": 125,
"Deaths": 3,
"Recovered": 13,
"Active": 109
}
},
{
"attributes": {
"OBJECTID": 90,
"Country_Region": "Iraq",
"Last_Update": 1584324795000,
"Lat": 33.2232,
"Long_": 43.6793,
"Confirmed": 124,
"Deaths": 10,
"Recovered": 26,
"Active": 88
}
},
{
"attributes": {
"OBJECTID": 12,
"Country_Region": "Saudi Arabia",
"Last_Update": 1584321192000,
"Lat": 23.8859,
"Long_": 45.0792,
"Confirmed": 118,
"Deaths": 0,
"Recovered": 2,
"Active": 116
}
},
{
"attributes": {
"OBJECTID": 59,
"Country_Region": "Indonesia",
"Last_Update": 1584296418000,
"Lat": -0.7893,
"Long_": 113.9213,
"Confirmed": 117,
"Deaths": 5,
"Recovered": 8,
"Active": 104
}
},
{
"attributes": {
"OBJECTID": 89,
"Country_Region": "Thailand",
"Last_Update": 1584296418000,
"Lat": 15.87,
"Long_": 100.9925,
"Confirmed": 114,
"Deaths": 1,
"Recovered": 35,
"Active": 78
}
},
{
"attributes": {
"OBJECTID": 32,
"Country_Region": "India",
"Last_Update": 1584318131000,
"Lat": 20.5937,
"Long_": 78.9629,
"Confirmed": 113,
"Deaths": 2,
"Recovered": 13,
"Active": 98
}
},
{
"attributes": {
"OBJECTID": 120,
"Country_Region": "Kuwait",
"Last_Update": 1584323583000,
"Lat": 29.3117,
"Long_": 47.4818,
"Confirmed": 112,
"Deaths": 0,
"Recovered": 9,
"Active": 103
}
},
{
"attributes": {
"OBJECTID": 42,
"Country_Region": "San Marino",
"Last_Update": 1584322383000,
"Lat": 43.9424,
"Long_": 12.4578,
"Confirmed": 109,
"Deaths": 7,
"Recovered": 4,
"Active": 98
}
},
{
"attributes": {
"OBJECTID": 105,
"Country_Region": "Lebanon",
"Last_Update": 1584318131000,
"Lat": 33.8547,
"Long_": 35.8623,
"Confirmed": 99,
"Deaths": 3,
"Recovered": 1,
"Active": 95
}
},
{
"attributes": {
"OBJECTID": 29,
"Country_Region": "United Arab Emirates",
"Last_Update": 1584318131000,
"Lat": 23.4241,
"Long_": 53.8478,
"Confirmed": 98,
"Deaths": 0,
"Recovered": 23,
"Active": 75
}
},
{
"attributes": {
"OBJECTID": 77,
"Country_Region": "Luxembourg",
"Last_Update": 1584323583000,
"Lat": 49.8153,
"Long_": 6.1296,
"Confirmed": 77,
"Deaths": 1,
"Recovered": 0,
"Active": 76
}
},
{
"attributes": {
"OBJECTID": 87,
"Country_Region": "Chile",
"Last_Update": 1584325988000,
"Lat": -35.6751,
"Long_": -71.543,
"Confirmed": 75,
"Deaths": 0,
"Recovered": 0,
"Active": 75
}
},
{
"attributes": {
"OBJECTID": 47,
"Country_Region": "Peru",
"Last_Update": 1584322383000,
"Lat": -9.19,
"Long_": -75.0152,
"Confirmed": 71,
"Deaths": 0,
"Recovered": 0,
"Active": 71
}
},
{
"attributes": {
"OBJECTID": 63,
"Country_Region": "Russia",
"Last_Update": 1584296418000,
"Lat": 61.524,
"Long_": 105.3188,
"Confirmed": 63,
"Deaths": 0,
"Recovered": 8,
"Active": 55
}
},
{
"attributes": {
"OBJECTID": 46,
"Country_Region": "Slovakia",
"Last_Update": 1584321192000,
"Lat": 48.669,
"Long_": 19.699,
"Confirmed": 61,
"Deaths": 0,
"Recovered": 0,
"Active": 61
}
},
{
"attributes": {
"OBJECTID": 67,
"Country_Region": "South Africa",
"Last_Update": 1584321192000,
"Lat": -30.5595,
"Long_": 22.9375,
"Confirmed": 61,
"Deaths": 0,
"Recovered": 0,
"Active": 61
}
},
{
"attributes": {
"OBJECTID": 99,
"Country_Region": "Taiwan*",
"Last_Update": 1584255183000,
"Lat": 23.7,
"Long_": 121,
"Confirmed": 59,
"Deaths": 1,
"Recovered": 20,
"Active": 38
}
},
{
"attributes": {
"OBJECTID": 62,
"Country_Region": "Vietnam",
"Last_Update": 1584296418000,
"Lat": 14.0583,
"Long_": 108.2772,
"Confirmed": 56,
"Deaths": 0,
"Recovered": 16,
"Active": 40
}
},
{
"attributes": {
"OBJECTID": 20,
"Country_Region": "Pakistan",
"Last_Update": 1584296418000,
"Lat": 30.3753,
"Long_": 69.3451,
"Confirmed": 53,
"Deaths": 0,
"Recovered": 2,
"Active": 51
}
},
{
"attributes": {
"OBJECTID": 64,
"Country_Region": "Bulgaria",
"Last_Update": 1584318131000,
"Lat": 42.7339,
"Long_": 25.4858,
"Confirmed": 51,
"Deaths": 2,
"Recovered": 0,
"Active": 49
}
},
{
"attributes": {
"OBJECTID": 82,
"Country_Region": "Brunei",
"Last_Update": 1584296418000,
"Lat": 4.5353,
"Long_": 114.7277,
"Confirmed": 50,
"Deaths": 0,
"Recovered": 0,
"Active": 50
}
},
{
"attributes": {
"OBJECTID": 148,
"Country_Region": "Croatia",
"Last_Update": 1584325988000,
"Lat": 45.1,
"Long_": 15.2,
"Confirmed": 49,
"Deaths": 0,
"Recovered": 2,
"Active": 47
}
},
{
"attributes": {
"OBJECTID": 85,
"Country_Region": "Algeria",
"Last_Update": 1584296418000,
"Lat": 28.0339,
"Long_": 1.6596,
"Confirmed": 48,
"Deaths": 4,
"Recovered": 12,
"Active": 32
}
},
{
"attributes": {
"OBJECTID": 144,
"Country_Region": "Serbia",
"Last_Update": 1584321192000,
"Lat": 44.0165,
"Long_": 21.0059,
"Confirmed": 48,
"Deaths": 0,
"Recovered": 1,
"Active": 47
}
},
{
"attributes": {
"OBJECTID": 49,
"Country_Region": "Argentina",
"Last_Update": 1584325988000,
"Lat": -38.4161,
"Long_": -63.6167,
"Confirmed": 46,
"Deaths": 2,
"Recovered": 1,
"Active": 43
}
},
{
"attributes": {
"OBJECTID": 75,
"Country_Region": "Panama",
"Last_Update": 1584296418000,
"Lat": 8.538,
"Long_": -80.7821,
"Confirmed": 43,
"Deaths": 1,
"Recovered": 0,
"Active": 42
}
},
{
"attributes": {
"OBJECTID": 104,
"Country_Region": "Mexico",
"Last_Update": 1584322383000,
"Lat": 23.6345,
"Long_": -102.5528,
"Confirmed": 43,
"Deaths": 0,
"Recovered": 4,
"Active": 39
}
},
{
"attributes": {
"OBJECTID": 28,
"Country_Region": "Albania",
"Last_Update": 1584296418000,
"Lat": 41.1533,
"Long_": 20.1683,
"Confirmed": 42,
"Deaths": 1,
"Recovered": 0,
"Active": 41
}
},
{
"attributes": {
"OBJECTID": 81,
"Country_Region": "Ecuador",
"Last_Update": 1584325988000,
"Lat": -1.8312,
"Long_": -78.1834,
"Confirmed": 37,
"Deaths": 2,
"Recovered": 0,
"Active": 35
}
},
{
"attributes": {
"OBJECTID": 76,
"Country_Region": "Costa Rica",
"Last_Update": 1584325988000,
"Lat": 9.7489,
"Long_": -83.7534,
"Confirmed": 35,
"Deaths": 0,
"Recovered": 0,
"Active": 35
}
},
{
"attributes": {
"OBJECTID": 110,
"Country_Region": "Colombia",
"Last_Update": 1584296418000,
"Lat": 4.5709,
"Long_": -74.2973,
"Confirmed": 34,
"Deaths": 0,
"Recovered": 0,
"Active": 34
}
},
{
"attributes": {
"OBJECTID": 91,
"Country_Region": "Georgia",
"Last_Update": 1584324796000,
"Lat": 42.3154,
"Long_": 43.3569,
"Confirmed": 33,
"Deaths": 0,
"Recovered": 1,
"Active": 32
}
},
{
"attributes": {
"OBJECTID": 113,
"Country_Region": "Cyprus",
"Last_Update": 1584325988000,
"Lat": 35.1264,
"Long_": 33.4299,
"Confirmed": 33,
"Deaths": 0,
"Recovered": 0,
"Active": 33
}
},
{
"attributes": {
"OBJECTID": 41,
"Country_Region": "Hungary",
"Last_Update": 1584296418000,
"Lat": 47.1625,
"Long_": 19.5033,
"Confirmed": 32,
"Deaths": 1,
"Recovered": 1,
"Active": 30
}
},
{
"attributes": {
"OBJECTID": 136,
"Country_Region": "Latvia",
"Last_Update": 1584296418000,
"Lat": 56.8796,
"Long_": 24.6032,
"Confirmed": 30,
"Deaths": 0,
"Recovered": 1,
"Active": 29
}
},
{
"attributes": {
"OBJECTID": 95,
"Country_Region": "Morocco",
"Last_Update": 1584296418000,
"Lat": 31.7917,
"Long_": -7.0926,
"Confirmed": 28,
"Deaths": 1,
"Recovered": 1,
"Active": 26
}
},
{
"attributes": {
"OBJECTID": 138,
"Country_Region": "Belarus",
"Last_Update": 1584138119000,
"Lat": 53.7098,
"Long_": 27.9534,
"Confirmed": 27,
"Deaths": 0,
"Recovered": 3,
"Active": 24
}
},
{
"attributes": {
"OBJECTID": 54,
"Country_Region": "Armenia",
"Last_Update": 1584318131000,
"Lat": 40.0691,
"Long_": 45.0382,
"Confirmed": 26,
"Deaths": 0,
"Recovered": 0,
"Active": 26
}
},
{
"attributes": {
"OBJECTID": 15,
"Country_Region": "Bosnia and Herzegovina",
"Last_Update": 1584318131000,
"Lat": 43.9159,
"Long_": 17.6791,
"Confirmed": 24,
"Deaths": 0,
"Recovered": 0,
"Active": 24
}
},
{
"attributes": {
"OBJECTID": 127,
"Country_Region": "Senegal",
"Last_Update": 1584321193000,
"Lat": 14.4974,
"Long_": -14.4524,
"Confirmed": 24,
"Deaths": 0,
"Recovered": 2,
"Active": 22
}
},
{
"attributes": {
"OBJECTID": 33,
"Country_Region": "Azerbaijan",
"Last_Update": 1584318131000,
"Lat": 40.1431,
"Long_": 47.5769,
"Confirmed": 23,
"Deaths": 1,
"Recovered": 6,
"Active": 16
}
},
{
"attributes": {
"OBJECTID": 94,
"Country_Region": "Moldova",
"Last_Update": 1584318131000,
"Lat": 47.4116,
"Long_": 28.3699,
"Confirmed": 23,
"Deaths": 0,
"Recovered": 0,
"Active": 23
}
},
{
"attributes": {
"OBJECTID": 21,
"Country_Region": "Oman",
"Last_Update": 1584318131000,
"Lat": 21.4735,
"Long_": 55.9754,
"Confirmed": 22,
"Deaths": 0,
"Recovered": 9,
"Active": 13
}
},
{
"attributes": {
"OBJECTID": 119,
"Country_Region": "Malta",
"Last_Update": 1584323583000,
"Lat": 35.9375,
"Long_": 14.3754,
"Confirmed": 21,
"Deaths": 0,
"Recovered": 2,
"Active": 19
}
},
{
"attributes": {
"OBJECTID": 142,
"Country_Region": "Tunisia",
"Last_Update": 1584321193000,
"Lat": 33.8869,
"Long_": 9.5375,
"Confirmed": 20,
"Deaths": 0,
"Recovered": 0,
"Active": 20
}
},
{
"attributes": {
"OBJECTID": 37,
"Country_Region": "Turkey",
"Last_Update": 1584321193000,
"Lat": 38.9637,
"Long_": 35.2433,
"Confirmed": 18,
"Deaths": 0,
"Recovered": 0,
"Active": 18
}
},
{
"attributes": {
"OBJECTID": 147,
"Country_Region": "Sri Lanka",
"Last_Update": 1584318131000,
"Lat": 7.8731,
"Long_": 80.7718,
"Confirmed": 18,
"Deaths": 0,
"Recovered": 1,
"Active": 17
}
},
{
"attributes": {
"OBJECTID": 123,
"Country_Region": "Venezuela",
"Last_Update": 1584319983000,
"Lat": 6.4238,
"Long_": -66.5897,
"Confirmed": 17,
"Deaths": 0,
"Recovered": 0,
"Active": 17
}
},
{
"attributes": {
"OBJECTID": 38,
"Country_Region": "Afghanistan",
"Last_Update": 1584325988000,
"Lat": 33.9391,
"Long_": 67.71,
"Confirmed": 16,
"Deaths": 0,
"Recovered": 1,
"Active": 15
}
},
{
"attributes": {
"OBJECTID": 22,
"Country_Region": "North Macedonia",
"Last_Update": 1584142385000,
"Lat": 41.6086,
"Long_": 21.7453,
"Confirmed": 14,
"Deaths": 0,
"Recovered": 1,
"Active": 13
}
},
{
"attributes": {
"OBJECTID": 2,
"Country_Region": "Maldives",
"Last_Update": 1584296418000,
"Lat": 3.2028,
"Long_": 73.2207,
"Confirmed": 13,
"Deaths": 0,
"Recovered": 0,
"Active": 13
}
},
{
"attributes": {
"OBJECTID": 3,
"Country_Region": "Lithuania",
"Last_Update": 1584296418000,
"Lat": 55.1694,
"Long_": 23.8813,
"Confirmed": 12,
"Deaths": 0,
"Recovered": 1,
"Active": 11
}
},
{
"attributes": {
"OBJECTID": 130,
"Country_Region": "Jordan",
"Last_Update": 1584323583000,
"Lat": 30.5852,
"Long_": 36.2384,
"Confirmed": 12,
"Deaths": 0,
"Recovered": 1,
"Active": 11
}
},
{
"attributes": {
"OBJECTID": 55,
"Country_Region": "Dominican Republic",
"Last_Update": 1584219182000,
"Lat": 18.7357,
"Long_": -70.1627,
"Confirmed": 11,
"Deaths": 0,
"Recovered": 0,
"Active": 11
}
},
{
"attributes": {
"OBJECTID": 8,
"Country_Region": "Bolivia",
"Last_Update": 1584190387000,
"Lat": -16.2902,
"Long_": -63.5887,
"Confirmed": 10,
"Deaths": 0,
"Recovered": 0,
"Active": 10
}
},
{
"attributes": {
"OBJECTID": 27,
"Country_Region": "Jamaica",
"Last_Update": 1584323583000,
"Lat": 18.1096,
"Long_": -77.2975,
"Confirmed": 10,
"Deaths": 0,
"Recovered": 2,
"Active": 8
}
},
{
"attributes": {
"OBJECTID": 131,
"Country_Region": "Martinique",
"Last_Update": 1584323583000,
"Lat": 14.6415,
"Long_": -61.0242,
"Confirmed": 10,
"Deaths": 0,
"Recovered": 0,
"Active": 10
}
},
{
"attributes": {
"OBJECTID": 132,
"Country_Region": "Kazakhstan",
"Last_Update": 1584318131000,
"Lat": 48.0196,
"Long_": 66.9237,
"Confirmed": 9,
"Deaths": 0,
"Recovered": 0,
"Active": 9
}
},
{
"attributes": {
"OBJECTID": 25,
"Country_Region": "New Zealand",
"Last_Update": 1584296418000,
"Lat": -40.9006,
"Long_": 174.886,
"Confirmed": 8,
"Deaths": 0,
"Recovered": 0,
"Active": 8
}
},
{
"attributes": {
"OBJECTID": 4,
"Country_Region": "Cambodia",
"Last_Update": 1584190387000,
"Lat": 12.5657,
"Long_": 104.991,
"Confirmed": 7,
"Deaths": 0,
"Recovered": 1,
"Active": 6
}
},
{
"attributes": {
"OBJECTID": 10,
"Country_Region": "Burkina Faso",
"Last_Update": 1584325988000,
"Lat": 12.2383,
"Long_": -1.5616,
"Confirmed": 7,
"Deaths": 0,
"Recovered": 0,
"Active": 7
}
},
{
"attributes": {
"OBJECTID": 111,
"Country_Region": "Reunion",
"Last_Update": 1584296419000,
"Lat": -21.1151,
"Long_": 55.5364,
"Confirmed": 7,
"Deaths": 0,
"Recovered": 0,
"Active": 7
}
},
{
"attributes": {
"OBJECTID": 135,
"Country_Region": "Paraguay",
"Last_Update": 1584322383000,
"Lat": -23.4425,
"Long_": -58.4438,
"Confirmed": 7,
"Deaths": 0,
"Recovered": 0,
"Active": 7
}
},
{
"attributes": {
"OBJECTID": 57,
"Country_Region": "Ghana",
"Last_Update": 1584296418000,
"Lat": 7.9465,
"Long_": -1.0232,
"Confirmed": 6,
"Deaths": 0,
"Recovered": 0,
"Active": 6
}
},
{
"attributes": {
"OBJECTID": 39,
"Country_Region": "Bangladesh",
"Last_Update": 1584325988000,
"Lat": 23.685,
"Long_": 90.3563,
"Confirmed": 5,
"Deaths": 0,
"Recovered": 2,
"Active": 3
}
},
{
"attributes": {
"OBJECTID": 45,
"Country_Region": "Rwanda",
"Last_Update": 1584322383000,
"Lat": -1.9403,
"Long_": 29.8739,
"Confirmed": 5,
"Deaths": 0,
"Recovered": 0,
"Active": 5
}
},
{
"attributes": {
"OBJECTID": 5,
"Country_Region": "Ethiopia",
"Last_Update": 1584324796000,
"Lat": 9.145,
"Long_": 40.4897,
"Confirmed": 4,
"Deaths": 0,
"Recovered": 0,
"Active": 4
}
},
{
"attributes": {
"OBJECTID": 9,
"Country_Region": "Cameroon",
"Last_Update": 1584325988000,
"Lat": 3.848,
"Long_": 11.5021,
"Confirmed": 4,
"Deaths": 0,
"Recovered": 0,
"Active": 4
}
},
{
"attributes": {
"OBJECTID": 31,
"Country_Region": "Uruguay",
"Last_Update": 1584203583000,
"Lat": -32.5228,
"Long_": -55.7658,
"Confirmed": 4,
"Deaths": 0,
"Recovered": 0,
"Active": 4
}
},
{
"attributes": {
"OBJECTID": 50,
"Country_Region": "Cuba",
"Last_Update": 1584143582000,
"Lat": 21.5218,
"Long_": -77.7812,
"Confirmed": 4,
"Deaths": 0,
"Recovered": 0,
"Active": 4
}
},
{
"attributes": {
"OBJECTID": 68,
"Country_Region": "Liechtenstein",
"Last_Update": 1584219182000,
"Lat": 47.166,
"Long_": 9.5554,
"Confirmed": 4,
"Deaths": 0,
"Recovered": 0,
"Active": 4
}
},
{
"attributes": {
"OBJECTID": 137,
"Country_Region": "Guyana",
"Last_Update": 1584296419000,
"Lat": 4.8604,
"Long_": -58.9302,
"Confirmed": 4,
"Deaths": 1,
"Recovered": 0,
"Active": 3
}
},
{
"attributes": {
"OBJECTID": 30,
"Country_Region": "Guam",
"Last_Update": 1584324796000,
"Lat": 13.4443,
"Long_": 144.7937,
"Confirmed": 3,
"Deaths": 0,
"Recovered": 0,
"Active": 3
}
},
{
"attributes": {
"OBJECTID": 36,
"Country_Region": "Kenya",
"Last_Update": 1584318131000,
"Lat": -0.0236,
"Long_": 37.9062,
"Confirmed": 3,
"Deaths": 0,
"Recovered": 0,
"Active": 3
}
},
{
"attributes": {
"OBJECTID": 56,
"Country_Region": "Ukraine",
"Last_Update": 1584138122000,
"Lat": 48.3794,
"Long_": 31.1656,
"Confirmed": 3,
"Deaths": 1,
"Recovered": 0,
"Active": 2
}
},
{
"attributes": {
"OBJECTID": 100,
"Country_Region": "Seychelles",
"Last_Update": 1584321193000,
"Lat": -4.6796,
"Long_": 55.492,
"Confirmed": 3,
"Deaths": 0,
"Recovered": 0,
"Active": 3
}
},
{
"attributes": {
"OBJECTID": 139,
"Country_Region": "Guadeloupe",
"Last_Update": 1584318131000,
"Lat": 16.265,
"Long_": -61.551,
"Confirmed": 3,
"Deaths": 0,
"Recovered": 0,
"Active": 3
}
},
{
"attributes": {
"OBJECTID": 140,
"Country_Region": "Honduras",
"Last_Update": 1584296419000,
"Lat": 15.2,
"Long_": -86.2419,
"Confirmed": 3,
"Deaths": 0,
"Recovered": 0,
"Active": 3
}
},
{
"attributes": {
"OBJECTID": 6,
"Country_Region": "Aruba",
"Last_Update": 1584143583000,
"Lat": 12.5211,
"Long_": -69.9683,
"Confirmed": 2,
"Deaths": 0,
"Recovered": 0,
"Active": 2
}
},
{
"attributes": {
"OBJECTID": 24,
"Country_Region": "Monaco",
"Last_Update": 1584227585000,
"Lat": 43.7384,
"Long_": 7.4246,
"Confirmed": 2,
"Deaths": 0,
"Recovered": 0,
"Active": 2
}
},
{
"attributes": {
"OBJECTID": 26,
"Country_Region": "Jersey",
"Last_Update": 1584203583000,
"Lat": 49.19,
"Long_": -2.11,
"Confirmed": 2,
"Deaths": 0,
"Recovered": 0,
"Active": 2
}
},
{
"attributes": {
"OBJECTID": 40,
"Country_Region": "Saint Lucia",
"Last_Update": 1584318131000,
"Lat": 13.9094,
"Long_": -60.9789,
"Confirmed": 2,
"Deaths": 0,
"Recovered": 0,
"Active": 2
}
},
{
"attributes": {
"OBJECTID": 78,
"Country_Region": "Andorra",
"Last_Update": 1584325988000,
"Lat": 42.5063,
"Long_": 1.5218,
"Confirmed": 2,
"Deaths": 0,
"Recovered": 1,
"Active": 1
}
},
{
"attributes": {
"OBJECTID": 80,
"Country_Region": "Nigeria",
"Last_Update": 1584138122000,
"Lat": 9.082,
"Long_": 8.6753,
"Confirmed": 2,
"Deaths": 0,
"Recovered": 0,
"Active": 2
}
},
{
"attributes": {
"OBJECTID": 96,
"Country_Region": "Namibia",
"Last_Update": 1584203583000,
"Lat": -22.9576,
"Long_": 18.4904,
"Confirmed": 2,
"Deaths": 0,
"Recovered": 0,
"Active": 2
}
},
{
"attributes": {
"OBJECTID": 103,
"Country_Region": "Kosovo",
"Last_Update": 1584296419000,
"Lat": 42.6026,
"Long_": 20.903,
"Confirmed": 2,
"Deaths": 0,
"Recovered": 0,
"Active": 2
}
},
{
"attributes": {
"OBJECTID": 121,
"Country_Region": "Congo (Kinshasa)",
"Last_Update": 1584138122000,
"Lat": -4.0383,
"Long_": 21.7587,
"Confirmed": 2,
"Deaths": 0,
"Recovered": 0,
"Active": 2
}
},
{
"attributes": {
"OBJECTID": 129,
"Country_Region": "Trinidad and Tobago",
"Last_Update": 1584202501000,
"Lat": 10.6918,
"Long_": -61.2225,
"Confirmed": 2,
"Deaths": 0,
"Recovered": 0,
"Active": 2
}
},
{
"attributes": {
"OBJECTID": 14,
"Country_Region": "Guatemala",
"Last_Update": 1584149583000,
"Lat": 15.7835,
"Long_": -90.2308,
"Confirmed": 1,
"Deaths": 0,
"Recovered": 0,
"Active": 1
}
},
{
"attributes": {
"OBJECTID": 16,
"Country_Region": "Guinea",
"Last_Update": 1584254514000,
"Lat": 9.9456,
"Long_": -9.6966,
"Confirmed": 1,
"Deaths": 0,
"Recovered": 0,
"Active": 1
}
},
{
"attributes": {
"OBJECTID": 23,
"Country_Region": "Gabon",
"Last_Update": 1584192784000,
"Lat": -0.8037,
"Long_": 11.6094,
"Confirmed": 1,
"Deaths": 0,
"Recovered": 0,
"Active": 1
}
},
{
"attributes": {
"OBJECTID": 34,
"Country_Region": "Congo (Brazzaville)",
"Last_Update": 1584296419000,
"Lat": -4.0383,
"Long_": 21.7587,
"Confirmed": 1,
"Deaths": 0,
"Recovered": 0,
"Active": 1
}
},
{
"attributes": {
"OBJECTID": 35,
"Country_Region": "Saint Vincent and the Grenadines",
"Last_Update": 1584203583000,
"Lat": 12.9843,
"Long_": -61.2872,
"Confirmed": 1,
"Deaths": 0,
"Recovered": 0,
"Active": 1
}
},
{
"attributes": {
"OBJECTID": 43,
"Country_Region": "Mongolia",
"Last_Update": 1584138122000,
"Lat": 46.8625,
"Long_": 103.8467,
"Confirmed": 1,
"Deaths": 0,
"Recovered": 0,
"Active": 1
}
},
{
"attributes": {
"OBJECTID": 51,
"Country_Region": "Republic of the Congo",
"Last_Update": 1584329583000,
"Lat": -1.44,
"Long_": 15.556,
"Confirmed": 1,
"Deaths": 0,
"Recovered": 0,
"Active": 1
}
},
{
"attributes": {
"OBJECTID": 52,
"Country_Region": "Togo",
"Last_Update": 1584138122000,
"Lat": 8.6195,
"Long_": 0.8248,
"Confirmed": 1,
"Deaths": 0,
"Recovered": 0,
"Active": 1
}
},
{
"attributes": {
"OBJECTID": 60,
"Country_Region": "Central African Republic",
"Last_Update": 1584329583000,
"Lat": 6.6111,
"Long_": 20.9394,
"Confirmed": 1,
"Deaths": 0,
"Recovered": 0,
"Active": 1
}
},
{
"attributes": {
"OBJECTID": 66,
"Country_Region": "Cayman Islands",
"Last_Update": 1584102783000,
"Lat": 19.3133,
"Long_": -81.2546,
"Confirmed": 1,
"Deaths": 0,
"Recovered": 0,
"Active": 1
}
},
{
"attributes": {
"OBJECTID": 74,
"Country_Region": "The Bahamas",
"Last_Update": 1584329583000,
"Lat": 24.25,
"Long_": -76,
"Confirmed": 1,
"Deaths": 0,
"Recovered": 0,
"Active": 1
}
},
{
"attributes": {
"OBJECTID": 97,
"Country_Region": "Guernsey",
"Last_Update": 1584138123000,
"Lat": 49.45,
"Long_": -2.58,
"Confirmed": 1,
"Deaths": 0,
"Recovered": 0,
"Active": 1
}
},
{
"attributes": {
"OBJECTID": 107,
"Country_Region": "Uzbekistan",
"Last_Update": 1584329583000,
"Lat": 41.3775,
"Long_": 64.5853,
"Confirmed": 1,
"Deaths": 0,
"Recovered": 0,
"Active": 1
}
},
{
"attributes": {
"OBJECTID": 109,
"Country_Region": "Antigua and Barbuda",
"Last_Update": 1584296419000,
"Lat": 17.0608,
"Long_": -61.7964,
"Confirmed": 1,
"Deaths": 0,
"Recovered": 0,
"Active": 1
}
},
{
"attributes": {
"OBJECTID": 112,
"Country_Region": "Eswatini",
"Last_Update": 1584254514000,
"Lat": -26.5225,
"Long_": 31.4659,
"Confirmed": 1,
"Deaths": 0,
"Recovered": 0,
"Active": 1
}
},
{
"attributes": {
"OBJECTID": 116,
"Country_Region": "Bhutan",
"Last_Update": 1584138122000,
"Lat": 27.5142,
"Long_": 90.4336,
"Confirmed": 1,
"Deaths": 0,
"Recovered": 0,
"Active": 1
}
},
{
"attributes": {
"OBJECTID": 117,
"Country_Region": "Sudan",
"Last_Update": 1584148412000,
"Lat": 12.8628,
"Long_": 30.2176,
"Confirmed": 1,
"Deaths": 1,
"Recovered": 0,
"Active": 0
}
},
{
"attributes": {
"OBJECTID": 118,
"Country_Region": "Nepal",
"Last_Update": 1584138123000,
"Lat": 28.3949,
"Long_": 84.124,
"Confirmed": 1,
"Deaths": 0,
"Recovered": 1,
"Active": 0
}
},
{
"attributes": {
"OBJECTID": 122,
"Country_Region": "Suriname",
"Last_Update": 1584203583000,
"Lat": 3.9193,
"Long_": -56.0278,
"Confirmed": 1,
"Deaths": 0,
"Recovered": 0,
"Active": 1
}
},
{
"attributes": {
"OBJECTID": 124,
"Country_Region": "Holy See",
"Last_Update": 1584138122000,
"Lat": 41.9029,
"Long_": 12.4534,
"Confirmed": 1,
"Deaths": 0,
"Recovered": 0,
"Active": 1
}
},
{
"attributes": {
"OBJECTID": 128,
"Country_Region": "Cote d'Ivoire",
"Last_Update": 1584138122000,
"Lat": 7.54,
"Long_": -5.5471,
"Confirmed": 1,
"Deaths": 0,
"Recovered": 0,
"Active": 1
}
},
{
"attributes": {
"OBJECTID": 134,
"Country_Region": "Mauritania",
"Last_Update": 1584296419000,
"Lat": 21.0079,
"Long_": -10.9408,
"Confirmed": 1,
"Deaths": 0,
"Recovered": 0,
"Active": 1
}
},
{
"attributes": {
"OBJECTID": 141,
"Country_Region": "Equatorial Guinea",
"Last_Update": 1584254514000,
"Lat": 1.5,
"Long_": 10,
"Confirmed": 1,
"Deaths": 0,
"Recovered": 0,
"Active": 1
}
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment