johns_hopkins_csse_daily_reports

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

7 rows where active = 425 and country_or_region = "Colombia" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: combined_key

province_or_state 5

country_or_region 1

  • Colombia · 7 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2673663 2673663 2021-07-18 Colombia La Guajira     40606 1283 38898 425 11.3548 -72.5205 2021-07-19 04:21:24 La Guajira, Colombia
2422734 2422734 2021-06-23 Colombia Choco     13792 337 13030 425 5.2528 -76.82600000000002 2021-06-24 04:21:55 Choco, Colombia
1872811 1872811 2021-05-15 Colombia Putumayo     10946 413 10108 425 0.436 -75.5277 2021-05-16 04:20:49 Putumayo, Colombia
3539319 3539319 2021-02-12 Colombia Sucre     19983 740 18818 425 8.814 -74.7233 2021-02-13 05:22:12 Sucre, Colombia
237091 237091 2021-01-18 Colombia La Guajira     15072 576 14071 425 11.3548 -72.5205 2021-01-19 05:22:15 La Guajira, Colombia
2935093 2935093 2020-11-28 Colombia Sucre     16438 645 15368 425 8.814 -74.7233 2020-11-29 05:25:55 Sucre, Colombia
3440657 3440657 2020-11-11 Colombia Casanare     5754 117 5212 425 5.7589 -71.5724 2020-11-12 05:25:55 Casanare, Colombia

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [johns_hopkins_csse_daily_reports] (
   [day] TEXT,
   [country_or_region] TEXT,
   [province_or_state] TEXT,
   [admin2] TEXT,
   [fips] TEXT,
   [confirmed] INTEGER,
   [deaths] INTEGER,
   [recovered] INTEGER,
   [active] TEXT,
   [latitude] TEXT,
   [longitude] TEXT,
   [last_update] TEXT,
   [combined_key] TEXT
);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day]
    ON [johns_hopkins_csse_daily_reports] ([day]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state]
    ON [johns_hopkins_csse_daily_reports] ([province_or_state]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region]
    ON [johns_hopkins_csse_daily_reports] ([country_or_region]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key]
    ON [johns_hopkins_csse_daily_reports] ([combined_key]);