johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
49 rows where recovered = 392 sorted by day descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3137381 | 3137381 | 2021-07-23 | China | Yunnan | 696 | 2 | 392 | 302 | 24.974 | 101.487 | 2021-07-24 00:21:36 | Yunnan, China | ||
3137364 | 3137364 | 2021-07-23 | China | Inner Mongolia | 399 | 1 | 392 | 6 | 44.0935 | 113.9448 | 2021-07-24 00:21:36 | Inner Mongolia, China | ||
3476141 | 3476141 | 2021-07-22 | China | Yunnan | 691 | 2 | 392 | 297 | 24.974 | 101.487 | 2021-07-23 04:21:29 | Yunnan, China | ||
3476124 | 3476124 | 2021-07-22 | China | Inner Mongolia | 399 | 1 | 392 | 6 | 44.0935 | 113.9448 | 2021-07-23 04:21:29 | Inner Mongolia, China | ||
3331343 | 3331343 | 2021-07-21 | China | Inner Mongolia | 399 | 1 | 392 | 6 | 44.0935 | 113.9448 | 2021-07-22 04:21:19 | Inner Mongolia, China | ||
2371324 | 2371324 | 2021-07-20 | China | Inner Mongolia | 399 | 1 | 392 | 6 | 44.0935 | 113.9448 | 2021-07-21 04:21:40 | Inner Mongolia, China | ||
483403 | 483403 | 2021-07-19 | China | Inner Mongolia | 399 | 1 | 392 | 6 | 44.0935 | 113.9448 | 2021-07-20 04:21:48 | Inner Mongolia, China | ||
2673626 | 2673626 | 2021-07-18 | China | Inner Mongolia | 399 | 1 | 392 | 6 | 44.0935 | 113.9448 | 2021-07-19 04:21:24 | Inner Mongolia, China | ||
3705938 | 3705938 | 2021-07-17 | China | Inner Mongolia | 398 | 1 | 392 | 5 | 44.0935 | 113.9448 | 2021-07-18 04:22:07 | Inner Mongolia, China | ||
2947182 | 2947182 | 2021-07-16 | China | Tianjin | 412 | 3 | 392 | 17 | 39.3054 | 117.323 | 2021-07-17 04:22:22 | Tianjin, China | ||
2947169 | 2947169 | 2021-07-16 | China | Inner Mongolia | 397 | 1 | 392 | 4 | 44.0935 | 113.9448 | 2021-07-17 04:22:22 | Inner Mongolia, China | ||
295838 | 295838 | 2021-07-15 | China | Tianjin | 412 | 3 | 392 | 17 | 39.3054 | 117.323 | 2021-07-16 04:21:22 | Tianjin, China | ||
295825 | 295825 | 2021-07-15 | China | Inner Mongolia | 397 | 1 | 392 | 4 | 44.0935 | 113.9448 | 2021-07-16 04:21:22 | Inner Mongolia, China | ||
3631783 | 3631783 | 2021-07-14 | China | Tianjin | 408 | 3 | 392 | 13 | 39.3054 | 117.323 | 2021-07-15 04:21:48 | Tianjin, China | ||
3631770 | 3631770 | 2021-07-14 | China | Inner Mongolia | 397 | 1 | 392 | 4 | 44.0935 | 113.9448 | 2021-07-15 04:21:48 | Inner Mongolia, China | ||
578658 | 578658 | 2021-07-13 | China | Tianjin | 408 | 3 | 392 | 13 | 39.3054 | 117.323 | 2021-07-14 04:21:35 | Tianjin, China | ||
578645 | 578645 | 2021-07-13 | China | Inner Mongolia | 397 | 1 | 392 | 4 | 44.0935 | 113.9448 | 2021-07-14 04:21:35 | Inner Mongolia, China | ||
3740894 | 3740894 | 2021-07-12 | China | Inner Mongolia | 397 | 1 | 392 | 4 | 44.0935 | 113.9448 | 2021-07-13 04:21:18 | Inner Mongolia, China | ||
3659407 | 3659407 | 2021-07-11 | China | Inner Mongolia | 397 | 1 | 392 | 4 | 44.0935 | 113.9448 | 2021-07-12 04:21:34 | Inner Mongolia, China | ||
625691 | 625691 | 2021-07-10 | China | Inner Mongolia | 394 | 1 | 392 | 1 | 44.0935 | 113.9448 | 2021-07-11 04:21:43 | Inner Mongolia, China | ||
829410 | 829410 | 2021-07-09 | China | Inner Mongolia | 394 | 1 | 392 | 1 | 44.0935 | 113.9448 | 2021-07-10 04:21:25 | Inner Mongolia, China | ||
778174 | 778174 | 2021-07-08 | China | Inner Mongolia | 394 | 1 | 392 | 1 | 44.0935 | 113.9448 | 2021-07-09 04:21:21 | Inner Mongolia, China | ||
1440396 | 1440396 | 2021-07-07 | China | Inner Mongolia | 394 | 1 | 392 | 1 | 44.0935 | 113.9448 | 2021-07-08 04:21:26 | Inner Mongolia, China | ||
1567878 | 1567878 | 2021-04-22 | Canada | Nunavut | 432 | 4 | 392 | 36 | 70.2998 | -83.1076 | 2021-04-23 04:20:52 | Nunavut, Canada | ||
3242099 | 3242099 | 2021-04-21 | Canada | Nunavut | 429 | 4 | 392 | 33 | 70.2998 | -83.1076 | 2021-04-22 04:20:53 | Nunavut, Canada | ||
911866 | 911866 | 2021-01-19 | Malaysia | W.P. Putrajaya | 613 | 6 | 392 | 215 | 2.9264 | 101.6964 | 2021-01-20 05:21:54 | W.P. Putrajaya, Malaysia | ||
907940 | 907940 | 2021-01-19 | Cambodia | 448 | 0 | 392 | 56 | 11.55 | 104.9167 | 2021-01-20 05:21:54 | Cambodia | |||
3883260 | 3883260 | 2021-01-14 | Malaysia | Terengganu | 663 | 1 | 392 | 270 | 5.3117 | 103.1324 | 2021-01-15 05:22:24 | Terengganu, Malaysia | ||
3863508 | 3863508 | 2020-12-04 | Malaysia | Pahang | 426 | 7 | 392 | 27 | 3.8126 | 103.3256 | 2020-12-05 05:27:36 | Pahang, Malaysia | ||
78766 | 78766 | 2020-12-03 | Malaysia | Pahang | 411 | 7 | 392 | 12 | 3.8126 | 103.3256 | 2020-12-04 05:27:27 | Pahang, Malaysia | ||
3338599 | 3338599 | 2020-11-17 | Japan | Fukushima | 441 | 6 | 392 | 43 | 37.378867 | 140.223295 | 2020-11-18 05:40:31 | Fukushima, Japan | ||
3781946 | 3781946 | 2020-10-13 | Japan | Toyama | 422 | 26 | 392 | 4 | 36.637464 | 137.26934599999998 | 2020-10-14 04:24:05 | Toyama, Japan | ||
427345 | 427345 | 2020-09-07 | Japan | Gunma | 491 | 19 | 392 | 80 | 36.504479 | 138.985605 | 2020-09-08 04:28:25 | Gunma, Japan | ||
3161630 | 3161630 | 2020-09-06 | Japan | Gunma | 482 | 19 | 392 | 71 | 36.504479 | 138.985605 | 2020-09-07 04:28:30 | Gunma, Japan | ||
613308 | 613308 | 2020-08-29 | Ukraine | Sevastopol* | 502 | 18 | 392 | 92 | 44.6054 | 33.522 | 2020-08-30 04:28:22 | Sevastopol*, Ukraine | ||
206112 | 206112 | 2020-08-19 | Colombia | Quindio | 721 | 19 | 392 | 310 | 4.461 | -75.6674 | 2020-08-20 04:27:43 | Quindio, Colombia | ||
837591 | 837591 | 2020-08-17 | Italy | Basilicata | 485 | 28 | 392 | 65 | 40.63947052 | 15.80514834 | 2020-08-18 04:27:56 | Basilicata, Italy | ||
1555949 | 1555949 | 2020-08-16 | Italy | Basilicata | 485 | 28 | 392 | 65 | 40.63947052 | 15.80514834 | 2020-08-17 04:27:20 | Basilicata, Italy | ||
145951 | 145951 | 2020-08-15 | Italy | Basilicata | 486 | 28 | 392 | 66 | 40.63947052 | 15.80514834 | 2020-08-16 04:27:42 | Basilicata, Italy | ||
458687 | 458687 | 2020-08-07 | Colombia | Putumayo | 1356 | 59 | 392 | 905 | 0.436 | -75.5277 | 2020-08-08 04:34:53 | Putumayo, Colombia | ||
3612690 | 3612690 | 2020-08-06 | Vietnam | 750 | 10 | 392 | 348 | 14.058324 | 108.277199 | 2020-08-07 04:35:11 | Vietnam | |||
2563541 | 2563541 | 2020-07-24 | India | Arunachal Pradesh | 1056 | 3 | 392 | 661 | 27.768456 | 96.384277 | 2020-07-25 04:47:39 | Arunachal Pradesh, India | ||
2701151 | 2701151 | 2020-06-24 | Togo | 583 | 14 | 392 | 177 | 8.6195 | 0.8248 | 2020-06-25 05:26:54 | Togo | |||
2437788 | 2437788 | 2020-06-20 | Ukraine | Cherkasy Oblast | 592 | 21 | 392 | 179 | 49.4444 | 32.0598 | 2020-06-21 04:33:19 | Cherkasy Oblast, Ukraine | ||
1691382 | 1691382 | 2020-06-19 | Ukraine | Crimea Republic* | 575 | 7 | 392 | 176 | 45.2835 | 34.2008 | 2020-06-20 04:33:19 | Crimea Republic*, Ukraine | ||
2555860 | 2555860 | 2020-06-02 | Mexico | Nayarit | 638 | 68 | 392 | 178 | 21.7514 | -104.8455 | 2020-06-03 02:33:13 | Nayarit, Mexico | ||
2548470 | 2548470 | 2020-05-27 | Paraguay | 884 | 11 | 392 | 481 | -23.4425 | -58.4438 | 2020-05-28 02:32:31 | Paraguay | |||
3847340 | 3847340 | 2020-05-13 | Jordan | 582 | 9 | 392 | 181 | 31.24 | 36.51 | 2020-05-14 03:32:28 | Jordan | |||
2278732 | 2278732 | 2020-05-03 | Malta | 477 | 4 | 392 | 81 | 35.9375 | 14.3754 | 2020-05-04 02:32:28 | Malta |
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]);