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

31 rows where deaths = 2795 sorted by day descending

✎ View and edit SQL

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

These facets timed out: province_or_state

Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
433534 433534 2022-11-03 US New Jersey Hudson 34017 219352 2795 0   40.73766234 -74.07515667 2022-11-04 04:22:11 Hudson, New Jersey, US
3109307 3109307 2022-07-13 Colombia Boyaca     126425 2795 0   5.4545 -73.362 2022-07-14 04:20:57 Boyaca, Colombia
629730 629730 2022-07-12 Colombia Boyaca     126425 2795 0   5.4545 -73.362 2022-07-13 04:20:58 Boyaca, Colombia
1211374 1211374 2022-07-11 Colombia Boyaca     126425 2795 0   5.4545 -73.362 2022-07-12 04:20:51 Boyaca, Colombia
2788856 2788856 2022-07-10 Colombia Boyaca     126425 2795 0   5.4545 -73.362 2022-07-11 04:20:46 Boyaca, Colombia
141809 141809 2022-07-09 Colombia Boyaca     126425 2795 0   5.4545 -73.362 2022-07-10 04:20:54 Boyaca, Colombia
1416909 1416909 2022-07-08 Colombia Boyaca     126425 2795 0   5.4545 -73.362 2022-07-09 04:20:59 Boyaca, Colombia
2740834 2740834 2022-07-07 Colombia Boyaca     126425 2795 0   5.4545 -73.362 2022-07-08 04:20:56 Boyaca, Colombia
3727818 3727818 2022-06-07 US Massachusetts Essex 25009 221563 2795 0   42.6687626 -70.94687179 2022-06-08 04:20:55 Essex, Massachusetts, US
1109842 1109842 2022-05-21 Russia Yaroslavl Oblast     160967 2795 0   57.7781976 39.0021095 2022-05-22 04:20:52 Yaroslavl Oblast, Russia
463521 463521 2022-05-02 Netherlands Gelderland     982527 2795 0   52.061738 5.939114 2022-05-03 04:21:00 Gelderland, Netherlands
3205952 3205952 2022-04-11 Australia Victoria     1401380 2795 0   -37.8136 144.9631 2022-04-12 04:20:49 Victoria, Australia
2446756 2446756 2022-02-22 Jamaica       127706 2795 0   18.1096 -77.2975 2022-02-23 04:21:09 Jamaica
1436211 1436211 2021-12-28 Ukraine Sumy Oblast     130487 2795 0   50.9077 34.7981 2021-12-29 03:21:43 Sumy Oblast, Ukraine
734172 734172 2021-12-27 Ukraine Sumy Oblast     130431 2795 0   50.9077 34.7981 2021-12-28 04:21:47 Sumy Oblast, Ukraine
2115344 2115344 2021-12-26 Ukraine Sumy Oblast     130393 2795 0   50.9077 34.7981 2021-12-27 04:21:58 Sumy Oblast, Ukraine
3608716 3608716 2021-12-25 Ukraine Sumy Oblast     130287 2795 0   50.9077 34.7981 2021-12-26 04:21:50 Sumy Oblast, Ukraine
2787 2787 2021-12-02 US Ohio Cuyahoga 39035 166949 2795 0   41.424119 -81.65918339 2021-12-03 04:23:05 Cuyahoga, Ohio, US
567197 567197 2021-10-29 Mexico Nayarit     33913 2795 0   21.7514 -104.8455 2021-10-30 04:22:03 Nayarit, Mexico
1885054 1885054 2021-09-12 Kosovo       157002 2795 0   42.602636 20.902977 2021-09-13 04:21:15 Kosovo
3808979 3808979 2021-09-11 US Texas El Paso 48141 122831 2795 0   31.76980765 -106.23632749999999 2021-09-12 04:21:13 El Paso, Texas, US
2796665 2796665 2021-08-28 Ukraine Kiev Oblast     129259 2795 0   50.053000000000004 30.7667 2021-08-29 04:21:14 Kiev Oblast, Ukraine
185692 185692 2021-02-21 United Kingdom Northern Ireland     110979 2795 0 108946 54.7877 -6.4923 2021-02-22 05:24:21 Northern Ireland, United Kingdom
1338185 1338185 2021-02-15 Germany Brandenburg     73241 2795 65350 5097 52.4125 12.5316 2021-02-16 05:24:38 Brandenburg, Germany
1094371 1094371 2021-01-20 Spain Aragon     90406 2795 3772 83839 41.5976 -0.9057 2021-01-21 05:22:01 Aragon, Spain
3517529 3517529 2021-01-15 US Nevada Clark 32003 197652 2795 0 194857 36.21458855 -115.0130241 2021-01-16 05:22:40 Clark, Nevada, US
2785086 2785086 2020-11-13 Mexico Coahuila     37352 2795 0 34557 27.0587 -101.7068 2020-11-14 05:25:37 Coahuila, Mexico
2812848 2812848 2020-09-25 Mexico Tabasco     31396 2795 27745 856 17.8409 -92.6189 2020-09-26 04:23:00 Tabasco, Mexico
206427 206427 2020-08-19 Philippines       173774 2795 113481 57498 12.879721 121.774017 2020-08-20 04:27:43 Philippines
844609 844609 2020-07-22 Spain Castilla y Leon     19963 2795 8716 8452 41.8357 -4.3976 2020-07-23 05:15:04 Castilla y Leon, Spain
1707348 1707348 2020-07-21 Spain Castilla y Leon     19946 2795 8716 8435 41.8357 -4.3976 2020-07-22 04:34:42 Castilla y Leon, Spain

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