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

19 rows where country_or_region = "Brazil" and province_or_state = "Unknown" sorted by day descending

✎ View and edit SQL

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

Suggested facets: last_update (date)

province_or_state 1

  • Unknown · 19 ✖

country_or_region 1

  • Brazil · 19 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2800192 2800192 2020-06-07 Brazil Unknown     0 0 283952 0     2020-06-08 03:33:22 Unknown, Brazil
574248 574248 2020-06-06 Brazil Unknown     0 0 277149 0     2020-06-07 03:53:30 Unknown, Brazil
1269945 1269945 2020-06-05 Brazil Unknown     0 0 266940 0     2020-06-06 02:33:00 Unknown, Brazil
1281411 1281411 2020-06-04 Brazil Unknown     0 0 254963 0     2020-06-05 02:33:06 Unknown, Brazil
3866966 3866966 2020-06-03 Brazil Unknown     0 0 238617 0     2020-06-04 02:33:14 Unknown, Brazil
2556008 2556008 2020-06-02 Brazil Unknown     0 0 223638 0     2020-06-03 02:33:13 Unknown, Brazil
805545 805545 2020-06-01 Brazil Unknown     0 0 211080 0     2020-06-02 02:33:08 Unknown, Brazil
1794092 1794092 2020-05-31 Brazil Unknown     0 0 206555 0     2020-06-01 02:32:46 Unknown, Brazil
3638985 3638985 2020-05-30 Brazil Unknown     0 0 200892 0     2020-05-31 02:32:45 Unknown, Brazil
1790526 1790526 2020-05-29 Brazil Unknown     0 0 189476 0     2020-05-30 02:32:48 Unknown, Brazil
2712405 2712405 2020-05-28 Brazil Unknown     0 0 177604 0     2020-05-29 02:32:50 Unknown, Brazil
2548329 2548329 2020-05-27 Brazil Unknown     0 0 166647 0     2020-05-28 02:32:31 Unknown, Brazil
1041292 1041292 2020-05-26 Brazil Unknown     0 0 158593 0     2020-05-27 02:32:31 Unknown, Brazil
1105022 1105022 2020-05-25 Brazil Unknown     0 0 153833 0     2020-05-26 02:32:35 Unknown, Brazil
875702 875702 2020-05-24 Brazil Unknown     0 0 149911 0     2020-05-25 02:32:44 Unknown, Brazil
997893 997893 2020-05-23 Brazil Unknown     0 0 142587 0     2020-05-24 02:32:43 Unknown, Brazil
1864916 1864916 2020-05-22 Brazil Unknown     0 0 135430 0     2020-05-23 02:32:42 Unknown, Brazil
268422 268422 2020-05-21 Brazil Unknown     0 0 125960 0     2020-05-22 02:36:51 Unknown, Brazil
1432005 1432005 2020-05-20 Brazil Unknown     0 0 116683 0     2020-05-21 02:32:48 Unknown, Brazil

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]);