johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,073 rows where country_or_region = "Summer Olympics 2020" sorted by active
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: active, day (date), last_update (date)
country_or_region 1
- Summer Olympics 2020 · 1,073 ✖
province_or_state 0
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▼ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
639 | 639 | 2021-12-02 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2021-12-03 04:23:05 | Summer Olympics 2020 | ||||
4655 | 4655 | 2021-10-28 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2021-10-29 04:22:03 | Summer Olympics 2020 | ||||
16663 | 16663 | 2021-09-18 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2021-09-19 04:21:34 | Summer Olympics 2020 | ||||
24710 | 24710 | 2022-03-20 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-03-21 04:20:50 | Summer Olympics 2020 | ||||
28725 | 28725 | 2021-11-11 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2021-11-12 04:22:01 | Summer Olympics 2020 | ||||
32724 | 32724 | 2021-08-25 | Summer Olympics 2020 | 716 | 0 | 0 | 35.6491 | 139.7737 | 2021-08-26 04:21:28 | Summer Olympics 2020 | ||||
40307 | 40307 | 2020-03-05 | Summer Olympics 2020 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2020-03-05T14:53:03 | |||||
44017 | 44017 | 2021-11-02 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2021-11-03 06:22:09 | Summer Olympics 2020 | ||||
62699 | 62699 | 2020-03-07 | Summer Olympics 2020 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2020-03-07T11:13:04 | |||||
63374 | 63374 | 2022-11-12 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-11-13 04:21:14 | Summer Olympics 2020 | ||||
67369 | 67369 | 2021-09-01 | Summer Olympics 2020 | 811 | 0 | 0 | 35.6491 | 139.7737 | 2021-09-02 04:21:15 | Summer Olympics 2020 | ||||
71400 | 71400 | 2022-02-07 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-02-08 04:21:15 | Summer Olympics 2020 | ||||
87434 | 87434 | 2021-11-09 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2021-11-10 04:21:38 | Summer Olympics 2020 | ||||
91452 | 91452 | 2022-07-23 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-07-24 04:20:47 | Summer Olympics 2020 | ||||
98964 | 98964 | 2020-03-04 | Summer Olympics 2020 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2020-03-04T12:53:03 | |||||
99635 | 99635 | 2022-01-14 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-01-15 04:21:07 | Summer Olympics 2020 | ||||
103634 | 103634 | 2021-08-15 | Summer Olympics 2020 | 542 | 0 | 0 | 35.6491 | 139.7737 | 2021-08-16 04:21:31 | Summer Olympics 2020 | ||||
107105 | 107105 | 2020-02-15 | Summer Olympics 2020 | 0 | 0 | 0 | 2020-02-15T23:13:05 | |||||||
115062 | 115062 | 2022-09-06 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-09-07 04:20:59 | Summer Olympics 2020 | ||||
127042 | 127042 | 2022-01-09 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-01-10 04:22:07 | Summer Olympics 2020 | ||||
131062 | 131062 | 2022-10-04 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-10-05 04:23:06 | Summer Olympics 2020 | ||||
138280 | 138280 | 2021-12-04 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2021-12-05 04:22:25 | Summer Olympics 2020 | ||||
142298 | 142298 | 2022-07-09 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-07-10 04:20:54 | Summer Olympics 2020 | ||||
150293 | 150293 | 2021-11-29 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2021-11-30 04:22:53 | Summer Olympics 2020 | ||||
158322 | 158322 | 2022-03-29 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-03-30 04:20:45 | Summer Olympics 2020 | ||||
162337 | 162337 | 2021-11-19 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2021-11-20 04:22:17 | Summer Olympics 2020 | ||||
166355 | 166355 | 2022-06-21 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-06-22 04:20:54 | Summer Olympics 2020 | ||||
178334 | 178334 | 2021-09-02 | Summer Olympics 2020 | 823 | 0 | 0 | 35.6491 | 139.7737 | 2021-09-03 04:21:20 | Summer Olympics 2020 | ||||
186380 | 186380 | 2022-02-13 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-02-14 04:20:51 | Summer Olympics 2020 | ||||
197804 | 197804 | 2020-01-24 | Summer Olympics 2020 | 0 | 0 | 0 | 1/24/20 17:00 | |||||||
197895 | 197895 | 2020-01-29 | Summer Olympics 2020 | 0 | 0 | 0 | 1/29/20 19:30 | |||||||
198571 | 198571 | 2022-10-19 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-10-20 04:22:59 | Summer Olympics 2020 | ||||
218292 | 218292 | 2022-12-26 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-12-27 04:21:07 | Summer Olympics 2020 | ||||
222305 | 222305 | 2022-05-09 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-05-10 04:20:50 | Summer Olympics 2020 | ||||
229537 | 229537 | 2022-05-31 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-06-01 04:20:55 | Summer Olympics 2020 | ||||
233552 | 233552 | 2022-02-11 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-02-12 04:21:06 | Summer Olympics 2020 | ||||
245577 | 245577 | 2021-08-17 | Summer Olympics 2020 | 574 | 0 | 0 | 35.6491 | 139.7737 | 2021-08-18 04:21:35 | Summer Olympics 2020 | ||||
249591 | 249591 | 2021-09-04 | Summer Olympics 2020 | 845 | 0 | 0 | 35.6491 | 139.7737 | 2021-09-05 04:21:33 | Summer Olympics 2020 | ||||
253624 | 253624 | 2022-09-08 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-09-09 04:21:11 | Summer Olympics 2020 | ||||
257642 | 257642 | 2022-12-10 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-12-11 04:20:50 | Summer Olympics 2020 | ||||
261170 | 261170 | 2020-03-03 | Summer Olympics 2020 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2020-03-03T11:43:02 | |||||
261842 | 261842 | 2022-03-15 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-03-16 04:20:50 | Summer Olympics 2020 | ||||
276492 | 276492 | 2021-11-03 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2021-11-04 04:22:20 | Summer Olympics 2020 | ||||
288305 | 288305 | 2021-10-31 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2021-11-01 04:22:01 | Summer Olympics 2020 | ||||
292325 | 292325 | 2022-11-15 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-11-16 04:21:09 | Summer Olympics 2020 | ||||
304178 | 304178 | 2022-04-16 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-04-17 04:20:59 | Summer Olympics 2020 | ||||
308197 | 308197 | 2022-12-13 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-12-14 04:21:04 | Summer Olympics 2020 | ||||
312213 | 312213 | 2022-11-13 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-11-14 04:21:09 | Summer Olympics 2020 | ||||
316226 | 316226 | 2022-02-12 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-02-13 04:21:00 | Summer Olympics 2020 | ||||
320245 | 320245 | 2022-10-30 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-10-31 04:21:36 | Summer Olympics 2020 | ||||
328219 | 328219 | 2022-12-27 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-12-28 04:21:04 | Summer Olympics 2020 | ||||
336246 | 336246 | 2022-03-18 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-03-19 04:20:47 | Summer Olympics 2020 | ||||
339930 | 339930 | 2020-03-21 | Summer Olympics 2020 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2020-03-21T10:13:08 | |||||
348609 | 348609 | 2022-12-14 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-12-15 04:20:58 | Summer Olympics 2020 | ||||
356636 | 356636 | 2022-03-11 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-03-12 04:20:50 | Summer Olympics 2020 | ||||
360652 | 360652 | 2022-05-07 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-05-08 04:20:49 | Summer Olympics 2020 | ||||
372509 | 372509 | 2022-09-13 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-09-14 04:20:44 | Summer Olympics 2020 | ||||
384536 | 384536 | 2022-09-23 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-09-24 04:21:40 | Summer Olympics 2020 | ||||
396577 | 396577 | 2022-10-07 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-10-08 04:22:56 | Summer Olympics 2020 | ||||
404603 | 404603 | 2021-12-07 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2021-12-08 04:22:46 | Summer Olympics 2020 | ||||
415881 | 415881 | 2020-01-26 | Summer Olympics 2020 | 0 | 0 | 0 | 1/26/20 16:00 | |||||||
419648 | 419648 | 2022-09-18 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-09-19 04:21:49 | Summer Olympics 2020 | ||||
423660 | 423660 | 2021-10-10 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2021-10-11 04:21:31 | Summer Olympics 2020 | ||||
431670 | 431670 | 2022-11-03 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-11-04 04:22:11 | Summer Olympics 2020 | ||||
443664 | 443664 | 2021-10-20 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2021-10-21 04:21:18 | Summer Olympics 2020 | ||||
447680 | 447680 | 2021-11-17 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2021-11-18 04:21:33 | Summer Olympics 2020 | ||||
451700 | 451700 | 2022-12-21 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-12-22 04:20:56 | Summer Olympics 2020 | ||||
459689 | 459689 | 2022-02-02 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-02-03 04:21:21 | Summer Olympics 2020 | ||||
463706 | 463706 | 2022-05-02 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-05-03 04:21:00 | Summer Olympics 2020 | ||||
467721 | 467721 | 2021-10-07 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2021-10-08 04:21:25 | Summer Olympics 2020 | ||||
475753 | 475753 | 2022-06-26 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-06-27 04:21:00 | Summer Olympics 2020 | ||||
479228 | 479228 | 2020-02-25 | Summer Olympics 2020 | 0 | 0 | 0 | 2020-02-25T15:23:04 | |||||||
479903 | 479903 | 2022-11-08 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-11-09 04:21:22 | Summer Olympics 2020 | ||||
487933 | 487933 | 2022-11-25 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-11-26 04:21:11 | Summer Olympics 2020 | ||||
491945 | 491945 | 2021-10-14 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2021-10-15 04:21:26 | Summer Olympics 2020 | ||||
495961 | 495961 | 2021-11-06 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2021-11-07 04:21:53 | Summer Olympics 2020 | ||||
499978 | 499978 | 2022-04-02 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-04-03 04:20:48 | Summer Olympics 2020 | ||||
503997 | 503997 | 2022-12-17 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-12-18 04:21:03 | Summer Olympics 2020 | ||||
507992 | 507992 | 2021-08-14 | Summer Olympics 2020 | 533 | 0 | 0 | 35.6491 | 139.7737 | 2021-08-15 04:21:41 | Summer Olympics 2020 | ||||
512006 | 512006 | 2021-08-19 | Summer Olympics 2020 | 578 | 0 | 0 | 35.6491 | 139.7737 | 2021-08-20 04:21:33 | Summer Olympics 2020 | ||||
516041 | 516041 | 2022-10-15 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-10-16 04:22:39 | Summer Olympics 2020 | ||||
535045 | 535045 | 2021-10-27 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2021-10-28 04:22:08 | Summer Olympics 2020 | ||||
539065 | 539065 | 2022-10-26 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-10-27 04:22:01 | Summer Olympics 2020 | ||||
543081 | 543081 | 2022-12-15 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-12-16 04:21:01 | Summer Olympics 2020 | ||||
551083 | 551083 | 2021-12-08 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2021-12-09 04:22:49 | Summer Olympics 2020 | ||||
555099 | 555099 | 2022-01-16 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-01-17 04:21:08 | Summer Olympics 2020 | ||||
559117 | 559117 | 2022-06-16 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-06-17 04:20:56 | Summer Olympics 2020 | ||||
562621 | 562621 | 2020-03-01 | Summer Olympics 2020 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2020-03-01T10:13:19 | |||||
566742 | 566742 | 2020-02-06 | Summer Olympics 2020 | 0 | 0 | 0 | 2020-02-06T23:23:02 | |||||||
567413 | 567413 | 2021-10-29 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2021-10-30 04:22:03 | Summer Olympics 2020 | ||||
575142 | 575142 | 2022-02-25 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-02-26 04:21:12 | Summer Olympics 2020 | ||||
589936 | 589936 | 2021-08-08 | Summer Olympics 2020 | 409 | 0 | 0 | 35.6491 | 139.7737 | 2021-08-09 04:21:24 | Summer Olympics 2020 | ||||
593969 | 593969 | 2022-07-01 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-07-02 04:21:16 | Summer Olympics 2020 | ||||
597983 | 597983 | 2021-10-19 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2021-10-20 04:21:00 | Summer Olympics 2020 | ||||
601999 | 601999 | 2021-09-23 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2021-09-24 04:21:44 | Summer Olympics 2020 | ||||
617500 | 617500 | 2020-02-27 | Summer Olympics 2020 | 0 | 0 | 0 | 2020-02-27T12:13:14 | |||||||
618175 | 618175 | 2022-11-05 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-11-06 04:21:24 | Summer Olympics 2020 | ||||
622189 | 622189 | 2022-05-22 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-05-26 04:20:50 | Summer Olympics 2020 | ||||
630219 | 630219 | 2022-07-12 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2022-07-13 04:20:58 | Summer Olympics 2020 | ||||
634233 | 634233 | 2021-10-13 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2021-10-14 04:21:29 | Summer Olympics 2020 |
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]);