johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
30 rows where recovered = 481 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3006952 | 3006952 | 2021-04-06 | United Kingdom | Cayman Islands | 512 | 2 | 481 | 29 | 19.3133 | -81.2546 | 2021-04-07 04:20:53 | Cayman Islands, United Kingdom | ||
2677872 | 2677872 | 2021-02-13 | Japan | Yamagata | 532 | 15 | 481 | 36 | 38.448396 | 140.102154 | 2021-02-14 05:23:43 | Yamagata, Japan | ||
3539505 | 3539505 | 2021-02-12 | Japan | Yamagata | 531 | 15 | 481 | 35 | 38.448396 | 140.102154 | 2021-02-13 05:22:12 | Yamagata, Japan | ||
1759104 | 1759104 | 2021-01-24 | China | Hebei | 1294 | 7 | 481 | 806 | 37.8957 | 114.9042 | 2021-01-25 05:22:16 | Hebei, China | ||
774350 | 774350 | 2021-01-12 | Japan | Aomori | 569 | 8 | 481 | 80 | 40.781541 | 140.828896 | 2021-01-13 05:22:15 | Aomori, Japan | ||
774073 | 774073 | 2021-01-12 | Bhutan | 831 | 1 | 481 | 349 | 27.5142 | 90.4336 | 2021-01-13 05:22:15 | Bhutan | |||
2227563 | 2227563 | 2021-01-02 | Japan | Toyama | 572 | 26 | 481 | 65 | 36.637464 | 137.26934599999998 | 2021-01-03 05:22:52 | Toyama, Japan | ||
3149638 | 3149638 | 2020-12-16 | Japan | Wakayama | 568 | 7 | 481 | 80 | 33.911879 | 135.505446 | 2020-12-17 05:28:12 | Wakayama, Japan | ||
845393 | 845393 | 2020-12-12 | China | Shaanxi | 502 | 3 | 481 | 18 | 35.1917 | 108.8701 | 2020-12-13 05:27:20 | Shaanxi, China | ||
860500 | 860500 | 2020-12-11 | China | Shaanxi | 502 | 3 | 481 | 18 | 35.1917 | 108.8701 | 2020-12-12 05:26:19 | Shaanxi, China | ||
272194 | 272194 | 2020-11-10 | Japan | Tochigi | 503 | 1 | 481 | 21 | 36.689912 | 139.819213 | 2020-11-11 05:25:30 | Tochigi, Japan | ||
1728546 | 1728546 | 2020-11-08 | Liechtenstein | 818 | 3 | 481 | 334 | 47.14 | 9.55 | 2020-11-09 05:25:45 | Liechtenstein | |||
1544006 | 1544006 | 2020-11-07 | Liechtenstein | 803 | 3 | 481 | 319 | 47.14 | 9.55 | 2020-11-08 05:24:56 | Liechtenstein | |||
379858 | 379858 | 2020-11-06 | Malaysia | Perak | 550 | 8 | 481 | 61 | 4.5921 | 101.0901 | 2020-11-07 05:24:52 | Perak, Malaysia | ||
376244 | 376244 | 2020-11-06 | Liechtenstein | 781 | 3 | 481 | 297 | 47.14 | 9.55 | 2020-11-07 05:24:52 | Liechtenstein | |||
895796 | 895796 | 2020-11-05 | Malaysia | Perak | 532 | 8 | 481 | 43 | 4.5921 | 101.0901 | 2020-11-06 05:24:55 | Perak, Malaysia | ||
2079808 | 2079808 | 2020-10-31 | Denmark | Faroe Islands | 495 | 0 | 481 | 14 | 61.8926 | -6.9118 | 2020-11-01 04:36:19 | Faroe Islands, Denmark | ||
2195243 | 2195243 | 2020-10-21 | United Kingdom | Gibraltar | 621 | 0 | 481 | 140 | 36.1408 | -5.3536 | 2020-10-22 04:24:27 | Gibraltar, United Kingdom | ||
2661803 | 2661803 | 2020-09-04 | Japan | Nara | 525 | 8 | 481 | 36 | 34.317451 | 135.871644 | 2020-09-05 04:28:19 | Nara, Japan | ||
1354329 | 1354329 | 2020-09-03 | Japan | Ibaraki | 559 | 14 | 481 | 64 | 36.303588 | 140.319591 | 2020-09-04 04:28:26 | Ibaraki, Japan | ||
3435788 | 3435788 | 2020-07-11 | Japan | Aichi | 534 | 34 | 481 | 19 | 35.035551 | 137.211621 | 2020-07-12 04:34:30 | Aichi, Japan | ||
3237939 | 3237939 | 2020-07-10 | Suriname | 726 | 18 | 481 | 227 | 3.9193 | -56.0278 | 2020-07-11 04:34:26 | Suriname | |||
3237286 | 3237286 | 2020-07-10 | Japan | Aichi | 532 | 34 | 481 | 17 | 35.035551 | 137.211621 | 2020-07-11 04:34:26 | Aichi, Japan | ||
3682745 | 3682745 | 2020-06-18 | Ukraine | Odessa Oblast | 1188 | 19 | 481 | 688 | 46.4846 | 30.7326 | 2020-06-19 04:33:17 | Odessa Oblast, Ukraine | ||
3061076 | 3061076 | 2020-06-13 | Mexico | Durango | 920 | 73 | 481 | 366 | 24.5593 | -104.6588 | 2020-06-14 03:33:15 | Durango, Mexico | ||
1431875 | 1431875 | 2020-05-20 | Mexico | Guanajuato | 821 | 80 | 481 | 260 | 21.019000000000002 | -101.2574 | 2020-05-21 02:32:48 | Guanajuato, Mexico | ||
3276363 | 3276363 | 2020-05-15 | Cyprus | 907 | 17 | 481 | 409 | 35.1264 | 33.4299 | 2020-05-16 02:32:19 | Cyprus | |||
1404537 | 1404537 | 2020-05-14 | Cyprus | 905 | 17 | 481 | 407 | 35.1264 | 33.4299 | 2020-05-15 02:33:02 | Cyprus | |||
1932026 | 1932026 | 2020-05-05 | Nigeria | 2950 | 98 | 481 | 2371 | 9.082 | 8.6753 | 2020-05-06 02:32:31 | Nigeria | |||
934453 | 934453 | 2020-04-16 | Malaysia | W.P. Kuala Lumpur | 956 | 13 | 481 | 462 | 3.139 | 101.6869 | 2020-04-16 23:30:51 | W.P. Kuala Lumpur, Malaysia |
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]);