johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
454 rows where active = 0 and country_or_region = "Summer Olympics 2020" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1129266 | 1129266 | 2021-06-18 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-06-19 04:22:33 | Summer Olympics 2020 | |||
2914844 | 2914844 | 2021-06-17 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-06-18 04:22:16 | Summer Olympics 2020 | |||
3033962 | 3033962 | 2021-06-16 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-06-17 04:22:36 | Summer Olympics 2020 | |||
2343068 | 2343068 | 2021-06-15 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-06-16 04:22:32 | Summer Olympics 2020 | |||
1567764 | 1567764 | 2021-06-14 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-06-15 04:22:22 | Summer Olympics 2020 | |||
3385047 | 3385047 | 2021-06-13 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-06-14 04:22:46 | Summer Olympics 2020 | |||
1740181 | 1740181 | 2021-06-12 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-06-13 04:22:44 | Summer Olympics 2020 | |||
3974222 | 3974222 | 2021-06-11 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-06-12 04:22:22 | Summer Olympics 2020 | |||
2720644 | 2720644 | 2021-06-10 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-06-11 04:23:20 | Summer Olympics 2020 | |||
526529 | 526529 | 2021-06-09 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-06-10 04:23:17 | Summer Olympics 2020 | |||
3475969 | 3475969 | 2021-06-08 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-06-09 04:23:31 | Summer Olympics 2020 | |||
3149253 | 3149253 | 2021-06-07 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-06-08 04:22:35 | Summer Olympics 2020 | |||
829255 | 829255 | 2021-06-06 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-06-07 04:22:51 | Summer Olympics 2020 | |||
2589660 | 2589660 | 2021-06-05 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-06-06 04:24:03 | Summer Olympics 2020 | |||
2318974 | 2318974 | 2021-06-04 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-06-05 04:23:03 | Summer Olympics 2020 | |||
1452259 | 1452259 | 2021-06-03 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-06-04 04:23:37 | Summer Olympics 2020 | |||
1711983 | 1711983 | 2021-06-02 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-06-03 04:23:32 | Summer Olympics 2020 | |||
2107801 | 2107801 | 2021-06-01 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-06-02 04:24:34 | Summer Olympics 2020 | |||
1192417 | 1192417 | 2021-05-31 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-06-01 04:23:09 | Summer Olympics 2020 | |||
3093094 | 3093094 | 2021-05-30 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-05-31 03:08:59 | Summer Olympics 2020 | |||
54463 | 54463 | 2021-05-29 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-05-30 04:20:55 | Summer Olympics 2020 | |||
24042 | 24042 | 2021-05-28 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-05-29 04:20:41 | Summer Olympics 2020 | |||
1810417 | 1810417 | 2021-05-27 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-05-28 04:20:36 | Summer Olympics 2020 | |||
1313841 | 1313841 | 2021-05-26 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-05-27 04:20:59 | Summer Olympics 2020 | |||
86767 | 86767 | 2021-05-25 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-05-26 04:20:35 | Summer Olympics 2020 | |||
1416729 | 1416729 | 2021-05-24 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-05-25 04:21:08 | Summer Olympics 2020 | |||
1775015 | 1775015 | 2021-05-23 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-05-24 04:20:53 | Summer Olympics 2020 | |||
730170 | 730170 | 2021-05-22 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-05-23 04:20:51 | Summer Olympics 2020 | |||
1956185 | 1956185 | 2021-05-21 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-05-22 04:20:45 | Summer Olympics 2020 | |||
1916884 | 1916884 | 2021-05-20 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-05-21 04:20:43 | Summer Olympics 2020 | |||
2259405 | 2259405 | 2021-05-19 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-05-20 04:21:05 | Summer Olympics 2020 | |||
2394443 | 2394443 | 2021-05-18 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-05-19 04:20:42 | Summer Olympics 2020 | |||
3578268 | 3578268 | 2021-05-17 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-05-18 04:20:33 | Summer Olympics 2020 | |||
2942998 | 2942998 | 2021-05-16 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-05-17 04:20:34 | Summer Olympics 2020 | |||
1876628 | 1876628 | 2021-05-15 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-05-16 04:20:49 | Summer Olympics 2020 | |||
1085597 | 1085597 | 2021-05-14 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-05-15 04:20:58 | Summer Olympics 2020 | |||
3057863 | 3057863 | 2021-05-13 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-05-14 04:20:41 | Summer Olympics 2020 | |||
2008333 | 2008333 | 2021-05-12 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-05-13 04:20:51 | Summer Olympics 2020 | |||
3958164 | 3958164 | 2021-05-11 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-05-12 04:21:29 | Summer Olympics 2020 | |||
2824443 | 2824443 | 2021-05-10 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-05-11 04:20:41 | Summer Olympics 2020 | |||
1428775 | 1428775 | 2021-05-09 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-05-10 04:20:38 | Summer Olympics 2020 | |||
1555643 | 1555643 | 2021-05-08 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-05-09 04:20:35 | Summer Olympics 2020 | |||
2505701 | 2505701 | 2021-05-07 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-05-08 04:21:04 | Summer Olympics 2020 | |||
3117157 | 3117157 | 2021-05-06 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-05-07 04:20:40 | Summer Olympics 2020 | |||
649624 | 649624 | 2021-05-05 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-05-06 04:20:38 | Summer Olympics 2020 | |||
3679324 | 3679324 | 2021-05-04 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-05-05 04:20:43 | Summer Olympics 2020 | |||
2764591 | 2764591 | 2021-05-03 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-05-04 04:20:34 | Summer Olympics 2020 | |||
2454444 | 2454444 | 2021-05-02 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-05-03 04:20:39 | Summer Olympics 2020 | |||
2828457 | 2828457 | 2021-05-01 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-05-02 04:20:48 | Summer Olympics 2020 | |||
383865 | 383865 | 2021-04-30 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-05-01 04:20:47 | Summer Olympics 2020 | |||
1639988 | 1639988 | 2021-04-29 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-04-30 04:21:03 | Summer Olympics 2020 | |||
3397067 | 3397067 | 2021-04-28 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-04-29 04:20:55 | Summer Olympics 2020 | |||
3705783 | 3705783 | 2021-04-27 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-04-28 04:20:32 | Summer Olympics 2020 | |||
891792 | 891792 | 2021-04-26 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-04-27 04:20:52 | Summer Olympics 2020 | |||
958537 | 958537 | 2021-04-25 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-04-26 04:21:04 | Summer Olympics 2020 | |||
3927684 | 3927684 | 2021-04-24 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-04-25 04:20:32 | Summer Olympics 2020 | |||
1412715 | 1412715 | 2021-04-23 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-04-24 04:20:38 | Summer Olympics 2020 | |||
1571778 | 1571778 | 2021-04-22 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-04-23 04:20:52 | Summer Olympics 2020 | |||
3245999 | 3245999 | 2021-04-21 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-04-22 04:20:53 | Summer Olympics 2020 | |||
2024395 | 2024395 | 2021-04-20 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-04-21 04:21:14 | Summer Olympics 2020 | |||
2414516 | 2414516 | 2021-04-19 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-04-20 04:20:41 | Summer Olympics 2020 | |||
3133193 | 3133193 | 2021-04-18 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-04-19 04:20:57 | Summer Olympics 2020 | |||
986621 | 986621 | 2021-04-17 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-04-18 04:20:41 | Summer Olympics 2020 | |||
173716 | 173716 | 2021-04-16 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-04-17 04:20:40 | Summer Olympics 2020 | |||
2552547 | 2552547 | 2021-04-15 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-04-16 04:20:46 | Summer Olympics 2020 | |||
1845617 | 1845617 | 2021-04-14 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-04-15 04:20:54 | Summer Olympics 2020 | |||
2575351 | 2575351 | 2021-04-13 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-04-14 04:20:41 | Summer Olympics 2020 | |||
40102 | 40102 | 2021-04-12 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-04-13 04:20:37 | Summer Olympics 2020 | |||
3887261 | 3887261 | 2021-04-11 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-04-12 04:21:00 | Summer Olympics 2020 | |||
2986929 | 2986929 | 2021-04-10 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-04-11 04:20:56 | Summer Olympics 2020 | |||
609361 | 609361 | 2021-04-09 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-04-10 04:20:59 | Summer Olympics 2020 | |||
2649425 | 2649425 | 2021-04-08 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-04-09 04:21:13 | Summer Olympics 2020 | |||
2251067 | 2251067 | 2021-04-07 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-04-08 04:21:13 | Summer Olympics 2020 | |||
3006977 | 3006977 | 2021-04-06 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-04-07 04:20:53 | Summer Olympics 2020 | |||
3088972 | 3088972 | 2021-04-05 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-04-06 04:20:32 | Summer Olympics 2020 | |||
391895 | 391895 | 2021-04-04 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-04-05 04:20:35 | Summer Olympics 2020 | |||
3713811 | 3713811 | 2021-04-03 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-04-04 04:20:49 | Summer Olympics 2020 | |||
244927 | 244927 | 2021-04-02 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-04-03 04:20:44 | Summer Olympics 2020 | |||
1305724 | 1305724 | 2021-04-01 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-04-02 04:20:36 | Summer Olympics 2020 | |||
641596 | 641596 | 2021-03-31 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-04-01 04:27:05 | Summer Olympics 2020 | |||
3647225 | 3647225 | 2021-03-30 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-03-31 04:26:25 | Summer Olympics 2020 | |||
1293678 | 1293678 | 2021-03-29 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-03-30 04:26:23 | Summer Olympics 2020 | |||
1539600 | 1539600 | 2021-03-28 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-03-29 04:28:35 | Summer Olympics 2020 | |||
1223240 | 1223240 | 2021-03-27 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-03-28 05:28:10 | Summer Olympics 2020 | |||
1884658 | 1884658 | 2021-03-26 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-03-27 05:25:04 | Summer Olympics 2020 | |||
1984288 | 1984288 | 2021-03-25 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-03-26 05:26:55 | Summer Olympics 2020 | |||
2784666 | 2784666 | 2021-03-24 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-03-25 05:27:00 | Summer Olympics 2020 | |||
1802311 | 1802311 | 2021-03-23 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-03-24 05:25:40 | Summer Olympics 2020 | |||
1207479 | 1207479 | 2021-03-22 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-03-23 05:26:18 | Summer Olympics 2020 | |||
3373001 | 3373001 | 2021-03-21 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-03-22 05:25:43 | Summer Olympics 2020 | |||
1748211 | 1748211 | 2021-03-20 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-03-21 05:25:44 | Summer Olympics 2020 | |||
3424591 | 3424591 | 2021-03-19 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-03-20 05:25:46 | Summer Olympics 2020 | |||
3456529 | 3456529 | 2021-03-18 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-03-19 05:26:09 | Summer Olympics 2020 | |||
3624753 | 3624753 | 2021-03-17 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-03-18 05:26:22 | Summer Olympics 2020 | |||
706077 | 706077 | 2021-03-16 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-03-17 05:25:07 | Summer Olympics 2020 | |||
2059555 | 2059555 | 2021-03-15 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-03-16 05:25:13 | Summer Olympics 2020 | |||
1736167 | 1736167 | 2021-03-14 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-03-15 05:25:51 | Summer Olympics 2020 | |||
1583824 | 1583824 | 2021-03-13 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-03-14 05:25:37 | Summer Olympics 2020 | |||
1841603 | 1841603 | 2021-03-12 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-03-13 05:25:15 | Summer Olympics 2020 | |||
355968 | 355968 | 2021-03-11 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2021-03-12 05:26:50 | 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]);