johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
24 rows where recovered = 905 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2371512 | 2371512 | 2021-07-20 | Japan | Akita | 977 | 20 | 905 | 52 | 39.748679 | 140.408228 | 2021-07-21 04:21:40 | Akita, Japan | ||
36473 | 36473 | 2021-04-12 | Japan | Toyama | 1050 | 29 | 905 | 116 | 36.637464 | 137.26934599999998 | 2021-04-13 04:20:37 | Toyama, Japan | ||
1837633 | 1837633 | 2021-03-12 | Australia | Western Australia | 923 | 9 | 905 | 9 | -31.9505 | 115.8605 | 2021-03-13 05:25:15 | Western Australia, Australia | ||
351998 | 351998 | 2021-03-11 | Australia | Western Australia | 922 | 9 | 905 | 8 | -31.9505 | 115.8605 | 2021-03-12 05:26:50 | Western Australia, Australia | ||
3962222 | 3962222 | 2021-03-10 | Australia | Western Australia | 922 | 9 | 905 | 8 | -31.9505 | 115.8605 | 2021-03-11 05:25:48 | Western Australia, Australia | ||
2283454 | 2283454 | 2021-02-14 | Japan | Niigata | 1005 | 13 | 905 | 87 | 37.521819 | 138.918647 | 2021-02-15 05:24:49 | Niigata, Japan | ||
1061865 | 1061865 | 2021-01-04 | Japan | Kagoshima | 1072 | 14 | 905 | 153 | 31.009484000000004 | 130.430665 | 2021-01-05 05:21:49 | Kagoshima, Japan | ||
395882 | 395882 | 2020-11-27 | United Kingdom | Gibraltar | 999 | 5 | 905 | 89 | 36.1408 | -5.3536 | 2020-11-28 05:25:50 | Gibraltar, United Kingdom | ||
825256 | 825256 | 2020-11-19 | Malaysia | W.P. Labuan | 1213 | 2 | 905 | 306 | 5.2831 | 115.2308 | 2020-11-20 05:26:28 | W.P. Labuan, Malaysia | ||
1452374 | 1452374 | 2020-10-27 | Chile | Aysen | 992 | 3 | 905 | 84 | -45.9864 | -73.7669 | 2020-10-28 04:24:39 | Aysen, Chile | ||
762044 | 762044 | 2020-10-18 | Botswana | 5242 | 20 | 905 | 4317 | -22.3285 | 24.6849 | 2020-10-19 04:24:16 | Botswana | |||
1026082 | 1026082 | 2020-10-17 | Botswana | 5242 | 20 | 905 | 4317 | -22.3285 | 24.6849 | 2020-10-18 04:24:25 | Botswana | |||
2856577 | 2856577 | 2020-10-16 | Botswana | 5242 | 20 | 905 | 4317 | -22.3285 | 24.6849 | 2020-10-17 04:24:12 | Botswana | |||
786107 | 786107 | 2020-10-15 | Botswana | 3914 | 20 | 905 | 2989 | -22.3285 | 24.6849 | 2020-10-16 04:24:01 | Botswana | |||
2159156 | 2159156 | 2020-07-14 | Uruguay | 997 | 31 | 905 | 61 | -32.5228 | -55.7658 | 2020-07-15 04:34:39 | Uruguay | |||
1510976 | 1510976 | 2020-06-22 | Mauritania | 3121 | 112 | 905 | 2104 | 21.0079 | -10.9408 | 2020-06-23 04:33:22 | Mauritania | |||
1510485 | 1510485 | 2020-06-22 | Mexico | Durango | 1374 | 106 | 905 | 363 | 24.5593 | -104.6588 | 2020-06-23 04:33:22 | Durango, Mexico | ||
287144 | 287144 | 2020-06-15 | India | Jharkhand | 1763 | 8 | 905 | 850 | 23.654536 | 85.557631 | 2020-06-16 04:33:09 | Jharkhand, India | ||
3061168 | 3061168 | 2020-06-13 | Russia | Khakassia Republic | 1299 | 10 | 905 | 384 | 53.72258845 | 91.44293627 | 2020-06-14 03:33:15 | Khakassia Republic, Russia | ||
2555942 | 2555942 | 2020-06-02 | Japan | Saitama | 1000 | 49 | 905 | 46 | 35.997101 | 139.347635 | 2020-06-03 02:33:13 | Saitama, Japan | ||
1105011 | 1105011 | 2020-05-25 | Mexico | Tamaulipas | 1289 | 86 | 905 | 298 | 24.2669 | -98.8363 | 2020-05-26 02:32:35 | Tamaulipas, Mexico | ||
1404541 | 1404541 | 2020-05-14 | Djibouti | 1284 | 3 | 905 | 376 | 11.8251 | 42.5903 | 2020-05-15 02:33:02 | Djibouti | |||
2899250 | 2899250 | 2020-05-09 | Lithuania | 1386 | 35 | 905 | 519 | 55.1694 | 23.8813 | 2020-05-10 02:32:30 | Lithuania | |||
114350 | 114350 | 2020-05-08 | Slovakia | 1455 | 26 | 905 | 524 | 48.669 | 19.699 | 2020-05-09 02:32:35 | Slovakia |
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]);