johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
30 rows where recovered = 647 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3015387 | 3015387 | 2021-08-01 | Japan | Shimane | 738 | 2 | 647 | 89 | 35.07076 | 132.55406399999998 | 2021-08-02 04:21:36 | Shimane, Japan | ||
1579913 | 1579913 | 2021-03-13 | Cambodia | 1305 | 1 | 647 | 657 | 11.55 | 104.9167 | 2021-03-14 05:25:37 | Cambodia | |||
3695514 | 3695514 | 2020-12-31 | Japan | Miyazaki | 757 | 8 | 647 | 102 | 32.193203999999994 | 131.299374 | 2021-01-01 05:23:07 | Miyazaki, Japan | ||
1010329 | 1010329 | 2020-12-30 | Japan | Miyazaki | 739 | 6 | 647 | 86 | 32.193203999999994 | 131.299374 | 2020-12-31 05:22:49 | Miyazaki, Japan | ||
766344 | 766344 | 2020-12-29 | Japan | Miyazaki | 727 | 6 | 647 | 74 | 32.193203999999994 | 131.299374 | 2020-12-30 05:22:34 | Miyazaki, Japan | ||
2223837 | 2223837 | 2020-12-26 | Taiwan* | 783 | 7 | 647 | 129 | 23.7 | 121.0 | 2020-12-27 05:22:55 | Taiwan* | |||
1972623 | 1972623 | 2020-11-25 | Japan | Shiga | 756 | 9 | 647 | 100 | 35.21582700000001 | 136.138064 | 2020-11-26 05:27:44 | Shiga, Japan | ||
376192 | 376192 | 2020-11-06 | Japan | Hiroshima | 670 | 5 | 647 | 18 | 34.605309000000005 | 132.788719 | 2020-11-07 05:24:52 | Hiroshima, Japan | ||
2919190 | 2919190 | 2020-11-04 | Japan | Gifu | 700 | 12 | 647 | 41 | 35.778671 | 137.055925 | 2020-11-05 06:05:03 | Gifu, Japan | ||
2498027 | 2498027 | 2020-11-03 | Japan | Gifu | 698 | 11 | 647 | 40 | 35.778671 | 137.055925 | 2020-11-04 05:25:09 | Gifu, Japan | ||
3612231 | 3612231 | 2020-08-06 | Ukraine | Kirovohrad Oblast | 713 | 36 | 647 | 30 | 48.5079 | 32.2623 | 2020-08-07 04:35:11 | Kirovohrad Oblast, Ukraine | ||
753950 | 753950 | 2020-08-01 | Togo | 958 | 19 | 647 | 292 | 8.6195 | 0.8248 | 2020-08-02 04:34:47 | Togo | |||
1928233 | 1928233 | 2020-07-30 | India | Chandigarh | 1016 | 14 | 647 | 355 | 30.733839 | 76.76827800000002 | 2020-07-31 04:35:18 | Chandigarh, India | ||
2958818 | 2958818 | 2020-07-29 | Australia | Western Australia | 661 | 9 | 647 | 5 | -31.9505 | 115.8605 | 2020-07-30 04:35:05 | Western Australia, Australia | ||
3185435 | 3185435 | 2020-07-28 | Australia | Western Australia | 661 | 9 | 647 | 5 | -31.9505 | 115.8605 | 2020-07-29 04:35:11 | Western Australia, Australia | ||
177485 | 177485 | 2020-07-27 | Australia | Western Australia | 659 | 9 | 647 | 3 | -31.9505 | 115.8605 | 2020-07-28 04:58:43 | Western Australia, Australia | ||
442798 | 442798 | 2020-07-26 | Australia | Western Australia | 658 | 9 | 647 | 2 | -31.9505 | 115.8605 | 2020-07-27 04:35:02 | Western Australia, Australia | ||
367761 | 367761 | 2020-07-16 | Jamaica | 765 | 10 | 647 | 108 | 18.1096 | -77.2975 | 2020-07-17 04:34:50 | Jamaica | |||
2748429 | 2748429 | 2020-07-15 | Jamaica | 763 | 10 | 647 | 106 | 18.1096 | -77.2975 | 2020-07-16 04:44:59 | Jamaica | |||
303435 | 303435 | 2020-07-01 | Malta | 671 | 9 | 647 | 15 | 35.9375 | 14.3754 | 2020-07-02 04:33:46 | Malta | |||
2701128 | 2701128 | 2020-06-24 | San Marino | 713 | 42 | 647 | 24 | 43.9424 | 12.4578 | 2020-06-25 05:26:54 | San Marino | |||
3061587 | 3061587 | 2020-06-13 | Paraguay | 1261 | 11 | 647 | 603 | -23.4425 | -58.4438 | 2020-06-14 03:33:15 | Paraguay | |||
573988 | 573988 | 2020-06-06 | Japan | Hyogo | 699 | 42 | 647 | 10 | 35.039913 | 134.828057 | 2020-06-07 03:53:30 | Hyogo, Japan | ||
1269685 | 1269685 | 2020-06-05 | Japan | Hyogo | 699 | 42 | 647 | 10 | 35.039913 | 134.828057 | 2020-06-06 02:33:00 | Hyogo, Japan | ||
1105227 | 1105227 | 2020-05-25 | Malaysia | Negeri Sembilan | 793 | 8 | 647 | 138 | 2.7258 | 101.9424 | 2020-05-26 02:32:35 | Negeri Sembilan, Malaysia | ||
1105058 | 1105058 | 2020-05-25 | Bolivia | 6660 | 261 | 647 | 5752 | -16.2902 | -63.5887 | 2020-05-26 02:32:35 | Bolivia | |||
997872 | 997872 | 2020-05-23 | China | Shanghai | 668 | 7 | 647 | 14 | 31.202 | 121.4491 | 2020-05-24 02:32:43 | Shanghai, China | ||
1864895 | 1864895 | 2020-05-22 | China | Shanghai | 667 | 7 | 647 | 13 | 31.201999999999998 | 121.4491 | 2020-05-23 02:32:42 | Shanghai, China | ||
271588 | 271588 | 2020-04-28 | China | Jiangsu | 653 | 0 | 647 | 6 | 32.9711 | 119.455 | 2020-04-29 02:32:29 | Jiangsu, China | ||
3950080 | 3950080 | 2020-04-09 | Romania | 5202 | 248 | 647 | 4307 | 45.9432 | 24.9668 | 2020-04-09 23:02:19 | Romania |
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]);