johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
35 rows where recovered = 595 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3296215 | 3296215 | 2021-07-30 | Japan | Shimane | 713 | 2 | 595 | 116 | 35.07076 | 132.55406399999998 | 2021-07-31 04:21:35 | Shimane, Japan | ||
487270 | 487270 | 2021-07-19 | Malaysia | Perlis | 628 | 8 | 595 | 25 | 6.4449 | 100.2048 | 2021-07-20 04:21:48 | Perlis, Malaysia | ||
1896792 | 1896792 | 2021-06-30 | United Kingdom | Cayman Islands | 614 | 2 | 595 | 17 | 19.3133 | -81.2546 | 2021-07-01 04:21:19 | Cayman Islands, United Kingdom | ||
403915 | 403915 | 2021-06-29 | United Kingdom | Cayman Islands | 614 | 2 | 595 | 17 | 19.3133 | -81.2546 | 2021-06-30 04:21:41 | Cayman Islands, United Kingdom | ||
3129158 | 3129158 | 2021-06-28 | United Kingdom | Cayman Islands | 614 | 2 | 595 | 17 | 19.3133 | -81.2546 | 2021-06-29 04:21:28 | Cayman Islands, United Kingdom | ||
3472098 | 3472098 | 2021-06-08 | China | Fujian | 632 | 1 | 595 | 36 | 26.0789 | 117.9874 | 2021-06-09 04:23:31 | Fujian, China | ||
3145382 | 3145382 | 2021-06-07 | China | Fujian | 631 | 1 | 595 | 35 | 26.0789 | 117.9874 | 2021-06-08 04:22:35 | Fujian, China | ||
726270 | 726270 | 2021-05-22 | Canada | Nunavut | 638 | 4 | 595 | 39 | 70.2998 | -83.1076 | 2021-05-23 04:20:51 | Nunavut, Canada | ||
339975 | 339975 | 2021-02-03 | Australia | South Australia | 601 | 4 | 595 | 2 | -34.9285 | 138.6007 | 2021-02-04 05:22:26 | South Australia, Australia | ||
861005 | 861005 | 2020-12-11 | Taiwan* | 725 | 7 | 595 | 123 | 23.7 | 121.0 | 2020-12-12 05:26:19 | Taiwan* | |||
75314 | 75314 | 2020-12-03 | Russia | Nenets Autonomous Okrug | 660 | 0 | 595 | 65 | 68.27557185 | 57.1686375 | 2020-12-04 05:27:27 | Nenets Autonomous Okrug, Russia | ||
1350340 | 1350340 | 2020-11-24 | Japan | Mie | 737 | 7 | 595 | 135 | 34.508018 | 136.376013 | 2020-11-25 05:27:20 | Mie, Japan | ||
678334 | 678334 | 2020-11-23 | Japan | Mie | 732 | 7 | 595 | 130 | 34.508018 | 136.376013 | 2020-11-24 05:27:31 | Mie, Japan | ||
3801905 | 3801905 | 2020-10-05 | Japan | Gifu | 630 | 10 | 595 | 25 | 35.778671 | 137.055925 | 2020-10-06 04:23:33 | Gifu, Japan | ||
3393008 | 3393008 | 2020-10-02 | Ukraine | Luhansk Oblast | 1140 | 15 | 595 | 530 | 48.574 | 39.3078 | 2020-10-03 04:23:40 | Luhansk Oblast, Ukraine | ||
966906 | 966906 | 2020-09-29 | Japan | Gunma | 699 | 19 | 595 | 85 | 36.504479 | 138.985605 | 2020-09-30 04:23:33 | Gunma, Japan | ||
1515403 | 1515403 | 2020-09-28 | Japan | Gunma | 699 | 19 | 595 | 85 | 36.504479 | 138.985605 | 2020-09-29 04:23:42 | Gunma, Japan | ||
546767 | 546767 | 2020-09-12 | Japan | Ishikawa | 730 | 42 | 595 | 93 | 36.769464 | 136.771027 | 2020-09-13 04:30:52 | Ishikawa, Japan | ||
2958610 | 2958610 | 2020-07-29 | India | Nagaland | 1513 | 5 | 595 | 913 | 26.06702 | 94.470302 | 2020-07-30 04:35:05 | Nagaland, India | ||
177400 | 177400 | 2020-07-27 | China | Sichuan | 604 | 3 | 595 | 6 | 30.6171 | 102.7103 | 2020-07-28 04:58:43 | Sichuan, China | ||
367394 | 367394 | 2020-07-16 | Ukraine | Kirovohrad Oblast | 675 | 33 | 595 | 47 | 48.5079 | 32.2623 | 2020-07-17 04:34:50 | Kirovohrad Oblast, Ukraine | ||
2223158 | 2223158 | 2020-07-08 | Yemen | 1318 | 351 | 595 | 372 | 15.552726999999999 | 48.516388 | 2020-07-09 04:34:23 | Yemen | |||
887728 | 887728 | 2020-07-07 | Rwanda | 1172 | 3 | 595 | 574 | -1.9403 | 29.8739 | 2020-07-08 05:33:48 | Rwanda | |||
529730 | 529730 | 2020-07-04 | China | Beijing | 928 | 9 | 595 | 324 | 40.1824 | 116.4142 | 2020-07-05 04:33:46 | Beijing, China | ||
2306738 | 2306738 | 2020-06-28 | Australia | Western Australia | 609 | 9 | 595 | 5 | -31.9505 | 115.8605 | 2020-06-29 04:33:44 | Western Australia, Australia | ||
2040073 | 2040073 | 2020-06-27 | Australia | Western Australia | 609 | 9 | 595 | 5 | -31.9505 | 115.8605 | 2020-06-28 04:34:04 | Western Australia, Australia | ||
1136354 | 1136354 | 2020-06-26 | Australia | Western Australia | 608 | 9 | 595 | 4 | -31.9505 | 115.8605 | 2020-06-27 04:33:35 | Western Australia, Australia | ||
2625341 | 2625341 | 2020-06-25 | Australia | Western Australia | 608 | 9 | 595 | 4 | -31.9505 | 115.8605 | 2020-06-26 04:33:43 | Western Australia, Australia | ||
2700981 | 2700981 | 2020-06-24 | Australia | Western Australia | 608 | 9 | 595 | 4 | -31.9505 | 115.8605 | 2020-06-25 05:26:54 | Western Australia, Australia | ||
3061501 | 3061501 | 2020-06-13 | Congo (Kinshasa) | 4724 | 106 | 595 | 4023 | -4.0383 | 21.7587 | 2020-06-14 03:33:15 | Congo (Kinshasa) | |||
2863908 | 2863908 | 2020-06-10 | Ukraine | Kiev Oblast | 1865 | 38 | 595 | 1232 | 50.053 | 30.7667 | 2020-06-11 03:33:41 | Kiev Oblast, Ukraine | ||
805456 | 805456 | 2020-06-01 | Mexico | Queretaro | 933 | 108 | 595 | 230 | 20.5888 | -100.3899 | 2020-06-02 02:33:08 | Queretaro, Mexico | ||
997763 | 997763 | 2020-05-23 | Mexico | Guanajuato | 1028 | 85 | 595 | 348 | 21.019000000000002 | -101.2574 | 2020-05-24 02:32:43 | Guanajuato, Mexico | ||
3276346 | 3276346 | 2020-05-15 | Burkina Faso | 780 | 51 | 595 | 134 | 12.2383 | -1.5616 | 2020-05-16 02:32:19 | Burkina Faso | |||
2110866 | 2110866 | 2020-05-06 | Albania | 832 | 31 | 595 | 206 | 41.1533 | 20.1683 | 2020-05-07 02:32:28 | Albania |
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]);