johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
28 rows where deaths = 37 and province_or_state = "Cherkasy Oblast" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: recovered, day (date), last_update (date)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3566169 | 3566169 | 2020-08-25 | Ukraine | Cherkasy Oblast | 1300 | 37 | 903 | 360 | 49.4444 | 32.0598 | 2020-08-26 04:28:11 | Cherkasy Oblast, Ukraine | ||
2994873 | 2994873 | 2020-08-24 | Ukraine | Cherkasy Oblast | 1297 | 37 | 896 | 364 | 49.4444 | 32.0598 | 2020-08-25 04:28:02 | Cherkasy Oblast, Ukraine | ||
2219268 | 2219268 | 2020-08-23 | Ukraine | Cherkasy Oblast | 1286 | 37 | 891 | 358 | 49.4444 | 32.0598 | 2020-08-24 04:27:56 | Cherkasy Oblast, Ukraine | ||
2303050 | 2303050 | 2020-08-22 | Ukraine | Cherkasy Oblast | 1248 | 37 | 883 | 328 | 49.4444 | 32.0598 | 2020-08-23 04:27:48 | Cherkasy Oblast, Ukraine | ||
1483156 | 1483156 | 2020-08-21 | Ukraine | Cherkasy Oblast | 1219 | 37 | 873 | 309 | 49.4444 | 32.0598 | 2020-08-22 04:27:49 | Cherkasy Oblast, Ukraine | ||
3487905 | 3487905 | 2020-08-20 | Ukraine | Cherkasy Oblast | 1200 | 37 | 861 | 302 | 49.4444 | 32.0598 | 2020-08-21 04:27:41 | Cherkasy Oblast, Ukraine | ||
209854 | 209854 | 2020-08-19 | Ukraine | Cherkasy Oblast | 1175 | 37 | 842 | 296 | 49.4444 | 32.0598 | 2020-08-20 04:27:43 | Cherkasy Oblast, Ukraine | ||
3181606 | 3181606 | 2020-08-18 | Ukraine | Cherkasy Oblast | 1167 | 37 | 835 | 295 | 49.4444 | 32.0598 | 2020-08-19 04:27:00 | Cherkasy Oblast, Ukraine | ||
841210 | 841210 | 2020-08-17 | Ukraine | Cherkasy Oblast | 1165 | 37 | 821 | 307 | 49.4444 | 32.0598 | 2020-08-18 04:27:56 | Cherkasy Oblast, Ukraine | ||
1559566 | 1559566 | 2020-08-16 | Ukraine | Cherkasy Oblast | 1148 | 37 | 819 | 292 | 49.4444 | 32.0598 | 2020-08-17 04:27:20 | Cherkasy Oblast, Ukraine | ||
149568 | 149568 | 2020-08-15 | Ukraine | Cherkasy Oblast | 1114 | 37 | 819 | 258 | 49.4444 | 32.0598 | 2020-08-16 04:27:42 | Cherkasy Oblast, Ukraine | ||
1615843 | 1615843 | 2020-08-14 | Ukraine | Cherkasy Oblast | 1092 | 37 | 814 | 241 | 49.4444 | 32.0598 | 2020-08-15 04:27:31 | Cherkasy Oblast, Ukraine | ||
586427 | 586427 | 2020-08-13 | Ukraine | Cherkasy Oblast | 1067 | 37 | 792 | 238 | 49.4444 | 32.0598 | 2020-08-14 04:51:19 | Cherkasy Oblast, Ukraine | ||
3535044 | 3535044 | 2020-08-12 | Ukraine | Cherkasy Oblast | 1049 | 37 | 789 | 223 | 49.4444 | 32.0598 | 2020-08-13 04:29:15 | Cherkasy Oblast, Ukraine | ||
662634 | 662634 | 2020-08-11 | Ukraine | Cherkasy Oblast | 1039 | 37 | 779 | 223 | 49.4444 | 32.0598 | 2020-08-12 04:27:29 | Cherkasy Oblast, Ukraine | ||
1920250 | 1920250 | 2020-08-10 | Ukraine | Cherkasy Oblast | 1036 | 37 | 770 | 229 | 49.4444 | 32.0598 | 2020-08-11 04:35:08 | Cherkasy Oblast, Ukraine | ||
3923059 | 3923059 | 2020-08-09 | Ukraine | Cherkasy Oblast | 1022 | 37 | 767 | 218 | 49.4444 | 32.0598 | 2020-08-10 04:34:55 | Cherkasy Oblast, Ukraine | ||
371227 | 371227 | 2020-08-08 | Ukraine | Cherkasy Oblast | 996 | 37 | 766 | 193 | 49.4444 | 32.0598 | 2020-08-09 04:34:54 | Cherkasy Oblast, Ukraine | ||
458411 | 458411 | 2020-08-07 | Ukraine | Cherkasy Oblast | 975 | 37 | 760 | 178 | 49.4444 | 32.0598 | 2020-08-08 04:34:53 | Cherkasy Oblast, Ukraine | ||
3612096 | 3612096 | 2020-08-06 | Ukraine | Cherkasy Oblast | 969 | 37 | 747 | 185 | 49.4444 | 32.0598 | 2020-08-07 04:35:11 | Cherkasy Oblast, Ukraine | ||
3792926 | 3792926 | 2020-08-05 | Ukraine | Cherkasy Oblast | 959 | 37 | 737 | 185 | 49.4444 | 32.0598 | 2020-08-06 04:35:02 | Cherkasy Oblast, Ukraine | ||
98162 | 98162 | 2020-08-04 | Ukraine | Cherkasy Oblast | 955 | 37 | 730 | 188 | 49.4444 | 32.0598 | 2020-08-05 04:34:43 | Cherkasy Oblast, Ukraine | ||
2740045 | 2740045 | 2020-08-03 | Ukraine | Cherkasy Oblast | 954 | 37 | 717 | 200 | 49.4444 | 32.0598 | 2020-08-04 04:41:59 | Cherkasy Oblast, Ukraine | ||
2807797 | 2807797 | 2020-08-02 | Ukraine | Cherkasy Oblast | 949 | 37 | 716 | 196 | 49.4444 | 32.0598 | 2020-08-03 04:34:35 | Cherkasy Oblast, Ukraine | ||
753365 | 753365 | 2020-08-01 | Ukraine | Cherkasy Oblast | 942 | 37 | 716 | 189 | 49.4444 | 32.0598 | 2020-08-02 04:34:47 | Cherkasy Oblast, Ukraine | ||
3264530 | 3264530 | 2020-07-31 | Ukraine | Cherkasy Oblast | 924 | 37 | 713 | 174 | 49.4444 | 32.0598 | 2020-08-01 04:36:27 | Cherkasy Oblast, Ukraine | ||
1928237 | 1928237 | 2020-07-30 | Ukraine | Cherkasy Oblast | 919 | 37 | 700 | 182 | 49.4444 | 32.0598 | 2020-07-31 04:35:18 | Cherkasy Oblast, Ukraine | ||
2958405 | 2958405 | 2020-07-29 | Ukraine | Cherkasy Oblast | 910 | 37 | 681 | 192 | 49.4444 | 32.0598 | 2020-07-30 04:35:05 | Cherkasy Oblast, Ukraine |
Advanced export
JSON shape: default, array, newline-delimited
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]);