johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
32 rows where recovered = 621 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 15
- China 6
- Colombia 5
- Japan 5
- Ukraine 4
- Russia 2
- Australia 1
- Canada 1
- Italy 1
- Liberia 1
- Mainland China 1
- Malaysia 1
- Mexico 1
- Monaco 1
- Sierra Leone 1
- Uzbekistan 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3631778 | 3631778 | 2021-07-14 | China | Shaanxi | 637 | 3 | 621 | 13 | 35.1917 | 108.8701 | 2021-07-15 04:21:48 | Shaanxi, China | ||
578653 | 578653 | 2021-07-13 | China | Shaanxi | 637 | 3 | 621 | 13 | 35.1917 | 108.8701 | 2021-07-14 04:21:35 | Shaanxi, China | ||
3740902 | 3740902 | 2021-07-12 | China | Shaanxi | 636 | 3 | 621 | 12 | 35.1917 | 108.8701 | 2021-07-13 04:21:18 | Shaanxi, China | ||
3659415 | 3659415 | 2021-07-11 | China | Shaanxi | 635 | 3 | 621 | 11 | 35.1917 | 108.8701 | 2021-07-12 04:21:34 | Shaanxi, China | ||
625699 | 625699 | 2021-07-10 | China | Shaanxi | 634 | 3 | 621 | 10 | 35.1917 | 108.8701 | 2021-07-11 04:21:43 | Shaanxi, China | ||
829418 | 829418 | 2021-07-09 | China | Shaanxi | 634 | 3 | 621 | 10 | 35.1917 | 108.8701 | 2021-07-10 04:21:25 | Shaanxi, China | ||
1309941 | 1309941 | 2021-05-26 | Canada | Nunavut | 647 | 4 | 621 | 22 | 70.2998 | -83.1076 | 2021-05-27 04:20:59 | Nunavut, Canada | ||
3242367 | 3242367 | 2021-04-21 | Japan | Tokushima | 1000 | 28 | 621 | 351 | 33.919178 | 134.242091 | 2021-04-22 04:20:53 | Tokushima, Japan | ||
3620780 | 3620780 | 2021-03-17 | Australia | South Australia | 640 | 4 | 621 | 15 | -34.9285 | 138.6007 | 2021-03-18 05:26:22 | South Australia, Australia | ||
1153314 | 1153314 | 2021-02-18 | Russia | Chukotka Autonomous Okrug | 675 | 4 | 621 | 50 | 66.0006475 | 169.4900869 | 2021-02-19 05:24:16 | Chukotka Autonomous Okrug, Russia | ||
2119822 | 2119822 | 2020-12-20 | Monaco | 728 | 3 | 621 | 104 | 43.7333 | 7.4167 | 2020-12-21 05:27:58 | Monaco | |||
845587 | 845587 | 2020-12-12 | Japan | Kagoshima | 813 | 13 | 621 | 179 | 31.009484000000004 | 130.430665 | 2020-12-13 05:27:20 | Kagoshima, Japan | ||
860694 | 860694 | 2020-12-11 | Japan | Kagoshima | 796 | 13 | 621 | 162 | 31.009484000000004 | 130.430665 | 2020-12-12 05:26:19 | Kagoshima, Japan | ||
1600236 | 1600236 | 2020-12-10 | Japan | Kagoshima | 771 | 13 | 621 | 137 | 31.009484000000004 | 130.430665 | 2020-12-11 05:26:59 | Kagoshima, Japan | ||
1053803 | 1053803 | 2020-10-23 | Italy | Basilicata | 1570 | 42 | 621 | 907 | 40.63947052 | 15.80514834 | 2020-10-24 04:24:46 | Basilicata, Italy | ||
3121104 | 3121104 | 2020-10-06 | Ukraine | Luhansk Oblast | 1333 | 18 | 621 | 694 | 48.574 | 39.3078 | 2020-10-07 04:23:40 | Luhansk Oblast, Ukraine | ||
666292 | 666292 | 2020-09-16 | Japan | Ishikawa | 736 | 44 | 621 | 71 | 36.769464 | 136.771027 | 2020-09-17 04:22:00 | Ishikawa, Japan | ||
1247377 | 1247377 | 2020-09-08 | Ukraine | Mykolaiv Oblast | 1690 | 40 | 621 | 1029 | 46.975 | 31.9946 | 2020-09-09 04:28:48 | Mykolaiv Oblast, Ukraine | ||
609524 | 609524 | 2020-08-29 | Colombia | Arauca | 915 | 17 | 621 | 277 | 7.0762 | -70.7105 | 2020-08-30 04:28:22 | Arauca, Colombia | ||
3923146 | 3923146 | 2020-08-09 | Colombia | Huila | 1614 | 36 | 621 | 957 | 2.5359 | -75.5277 | 2020-08-10 04:34:55 | Huila, Colombia | ||
3793353 | 3793353 | 2020-08-05 | Ukraine | Zaporizhia Oblast | 871 | 21 | 621 | 229 | 47.8388 | 35.1396 | 2020-08-06 04:35:02 | Zaporizhia Oblast, Ukraine | ||
98589 | 98589 | 2020-08-04 | Ukraine | Zaporizhia Oblast | 851 | 21 | 621 | 209 | 47.8388 | 35.1396 | 2020-08-05 04:34:43 | Zaporizhia Oblast, Ukraine | ||
442675 | 442675 | 2020-07-26 | Colombia | Risaralda | 1298 | 25 | 621 | 652 | 5.3158 | -75.9928 | 2020-07-27 04:35:02 | Risaralda, Colombia | ||
1502919 | 1502919 | 2020-07-25 | Colombia | Risaralda | 1298 | 25 | 621 | 652 | 5.3158 | -75.9928 | 2020-07-26 04:35:00 | Risaralda, Colombia | ||
2564119 | 2564119 | 2020-07-24 | Liberia | 1117 | 71 | 621 | 425 | 6.4280550000000005 | -9.429499 | 2020-07-25 04:47:39 | Liberia | |||
2158590 | 2158590 | 2020-07-14 | Mexico | Colima | 939 | 115 | 621 | 203 | 19.1223 | -104.0072 | 2020-07-15 04:34:39 | Colima, Mexico | ||
2625101 | 2625101 | 2020-06-25 | Colombia | Magdalena | 1390 | 91 | 621 | 678 | 10.4113 | -74.4057 | 2020-06-26 04:33:43 | Magdalena, Colombia | ||
2386614 | 2386614 | 2020-06-16 | Russia | Kostroma Oblast | 1175 | 12 | 621 | 542 | 58.424756 | 44.2533273 | 2020-06-17 04:33:21 | Kostroma Oblast, Russia | ||
1211152 | 1211152 | 2020-06-09 | Sierra Leone | 1025 | 50 | 621 | 354 | 8.460555000000001 | -11.779889 | 2020-06-10 04:07:00 | Sierra Leone | |||
3639192 | 3639192 | 2020-05-30 | Malaysia | Johor | 678 | 18 | 621 | 39 | 1.4854 | 103.7618 | 2020-05-31 02:32:45 | Johor, Malaysia | ||
1459395 | 1459395 | 2020-04-24 | Uzbekistan | 1804 | 8 | 621 | 1175 | 41.377491 | 64.585262 | 2020-04-25 06:30:33 | Uzbekistan | |||
657698 | 657698 | 2020-03-09 | Mainland China | Jiangsu | 631 | 0 | 621 | 32.9711 | 119.455 | 2020-03-09T08:53:03 |
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]);