johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
48 rows where recovered = 395 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3385202 | 3385202 | 2021-07-29 | China | Inner Mongolia | 403 | 1 | 395 | 7 | 44.0935 | 113.9448 | 2021-07-30 04:21:34 | Inner Mongolia, China | ||
408107 | 408107 | 2021-07-28 | China | Inner Mongolia | 403 | 1 | 395 | 7 | 44.0935 | 113.9448 | 2021-07-29 04:21:33 | Inner Mongolia, China | ||
1305968 | 1305968 | 2021-07-27 | China | Inner Mongolia | 403 | 1 | 395 | 7 | 44.0935 | 113.9448 | 2021-07-28 04:21:39 | Inner Mongolia, China | ||
3218111 | 3218111 | 2021-07-26 | China | Inner Mongolia | 403 | 1 | 395 | 7 | 44.0935 | 113.9448 | 2021-07-27 04:21:18 | Inner Mongolia, China | ||
1378320 | 1378320 | 2021-07-25 | China | Inner Mongolia | 403 | 1 | 395 | 7 | 44.0935 | 113.9448 | 2021-07-26 04:21:28 | Inner Mongolia, China | ||
1330060 | 1330060 | 2021-07-24 | China | Inner Mongolia | 401 | 1 | 395 | 5 | 44.0935 | 113.9448 | 2021-07-25 04:22:12 | Inner Mongolia, China | ||
3331356 | 3331356 | 2021-07-21 | China | Tianjin | 415 | 3 | 395 | 17 | 39.3054 | 117.323 | 2021-07-22 04:21:19 | Tianjin, China | ||
2371337 | 2371337 | 2021-07-20 | China | Tianjin | 415 | 3 | 395 | 17 | 39.3054 | 117.323 | 2021-07-21 04:21:40 | Tianjin, China | ||
483416 | 483416 | 2021-07-19 | China | Tianjin | 415 | 3 | 395 | 17 | 39.3054 | 117.323 | 2021-07-20 04:21:48 | Tianjin, China | ||
2673639 | 2673639 | 2021-07-18 | China | Tianjin | 412 | 3 | 395 | 14 | 39.3054 | 117.323 | 2021-07-19 04:21:24 | Tianjin, China | ||
1771385 | 1771385 | 2021-05-23 | Japan | Tottori | 455 | 2 | 395 | 58 | 35.359069 | 133.863619 | 2021-05-24 04:20:53 | Tottori, Japan | ||
606022 | 606022 | 2021-04-09 | Timor-Leste | 877 | 1 | 395 | 481 | -8.874217 | 125.727539 | 2021-04-10 04:20:59 | Timor-Leste | |||
280223 | 280223 | 2021-02-24 | Japan | Tokushima | 448 | 16 | 395 | 37 | 33.919178 | 134.242091 | 2021-02-25 05:24:57 | Tokushima, Japan | ||
1527715 | 1527715 | 2021-02-09 | China | Liaoning | 402 | 2 | 395 | 5 | 41.2956 | 122.6085 | 2021-02-10 05:22:41 | Liaoning, China | ||
435164 | 435164 | 2021-01-21 | China | Hebei | 1252 | 7 | 395 | 850 | 37.8957 | 114.9042 | 2021-01-22 05:22:10 | Hebei, China | ||
1093896 | 1093896 | 2021-01-20 | China | Hebei | 1231 | 7 | 395 | 829 | 37.8957 | 114.9042 | 2021-01-21 05:22:01 | Hebei, China | ||
1061850 | 1061850 | 2021-01-04 | Japan | Aomori | 516 | 8 | 395 | 113 | 40.781541 | 140.828896 | 2021-01-05 05:21:49 | Aomori, Japan | ||
202275 | 202275 | 2020-12-25 | Japan | Kochi | 604 | 6 | 395 | 203 | 33.422519 | 133.367307 | 2020-12-26 05:22:28 | Kochi, Japan | ||
2123389 | 2123389 | 2020-12-20 | Malaysia | Melaka | 690 | 6 | 395 | 289 | 2.1896 | 102.2501 | 2020-12-21 05:27:58 | Melaka, Malaysia | ||
2934896 | 2934896 | 2020-12-19 | Malaysia | Melaka | 689 | 6 | 395 | 288 | 2.1896 | 102.2501 | 2020-12-20 05:27:32 | Melaka, Malaysia | ||
1599945 | 1599945 | 2020-12-10 | Bhutan | 434 | 0 | 395 | 39 | 27.5142 | 90.4336 | 2020-12-11 05:26:59 | Bhutan | |||
2974954 | 2974954 | 2020-12-09 | Bhutan | 433 | 0 | 395 | 38 | 27.5142 | 90.4336 | 2020-12-10 05:26:19 | Bhutan | |||
1009971 | 1009971 | 2020-12-06 | Malaysia | Pahang | 432 | 7 | 395 | 30 | 3.8126 | 103.3256 | 2020-12-07 05:26:14 | Pahang, Malaysia | ||
1635980 | 1635980 | 2020-12-05 | Malaysia | Pahang | 428 | 7 | 395 | 26 | 3.8126 | 103.3256 | 2020-12-06 05:26:18 | Pahang, Malaysia | ||
2510222 | 2510222 | 2020-08-27 | Japan | Shizuoka | 472 | 1 | 395 | 76 | 34.916975 | 138.40778400000002 | 2020-08-28 04:28:11 | Shizuoka, Japan | ||
1996682 | 1996682 | 2020-08-26 | Japan | Shizuoka | 460 | 1 | 395 | 64 | 34.916975 | 138.40778400000002 | 2020-08-27 04:28:15 | Shizuoka, Japan | ||
1483224 | 1483224 | 2020-08-21 | Malaysia | Sabah | 417 | 8 | 395 | 14 | 5.9788 | 116.0753 | 2020-08-22 04:27:49 | Sabah, Malaysia | ||
3487973 | 3487973 | 2020-08-20 | Malaysia | Sabah | 417 | 8 | 395 | 14 | 5.9788 | 116.0753 | 2020-08-21 04:27:41 | Sabah, Malaysia | ||
209922 | 209922 | 2020-08-19 | Malaysia | Sabah | 417 | 8 | 395 | 14 | 5.9788 | 116.0753 | 2020-08-20 04:27:43 | Sabah, Malaysia | ||
583155 | 583155 | 2020-08-13 | Syria | 1432 | 55 | 395 | 982 | 34.802075 | 38.99681500000001 | 2020-08-14 04:51:19 | Syria | |||
3923653 | 3923653 | 2020-08-09 | Vietnam | 841 | 13 | 395 | 433 | 14.058324 | 108.277199 | 2020-08-10 04:34:55 | Vietnam | |||
371821 | 371821 | 2020-08-08 | Vietnam | 812 | 10 | 395 | 407 | 14.058324 | 108.277199 | 2020-08-09 04:34:54 | Vietnam | |||
459005 | 459005 | 2020-08-07 | Vietnam | 789 | 10 | 395 | 384 | 14.058324 | 108.277199 | 2020-08-08 04:34:53 | Vietnam | |||
1928672 | 1928672 | 2020-07-30 | Angola | 1109 | 51 | 395 | 663 | -11.2027 | 17.8739 | 2020-07-31 04:35:18 | Angola | |||
3185108 | 3185108 | 2020-07-28 | Colombia | Huila | 746 | 18 | 395 | 333 | 2.5359 | -75.5277 | 2020-07-29 04:35:11 | Huila, Colombia | ||
326995 | 326995 | 2020-07-20 | Japan | Kyoto | 566 | 18 | 395 | 153 | 35.253815 | 135.443341 | 2020-07-21 04:38:46 | Kyoto, Japan | ||
121900 | 121900 | 2020-07-19 | Japan | Kyoto | 539 | 18 | 395 | 126 | 35.253815 | 135.443341 | 2020-07-20 05:34:40 | Kyoto, Japan | ||
3205289 | 3205289 | 2020-07-18 | Japan | Kyoto | 527 | 18 | 395 | 114 | 35.253815 | 135.443341 | 2020-07-19 04:34:58 | Kyoto, Japan | ||
2748519 | 2748519 | 2020-07-15 | Zimbabwe | 1089 | 20 | 395 | 674 | -19.015438 | 29.154857 | 2020-07-16 04:44:59 | Zimbabwe | |||
2223082 | 2223082 | 2020-07-08 | Liberia | 917 | 41 | 395 | 481 | 6.4280550000000005 | -9.429499 | 2020-07-09 04:34:23 | Liberia | |||
415204 | 415204 | 2020-07-05 | India | Chandigarh | 466 | 6 | 395 | 65 | 30.733839 | 76.76827800000002 | 2020-07-06 04:33:57 | Chandigarh, India | ||
529766 | 529766 | 2020-07-04 | India | Chandigarh | 460 | 6 | 395 | 59 | 30.733839 | 76.76827800000002 | 2020-07-05 04:33:46 | Chandigarh, India | ||
1136524 | 1136524 | 2020-06-26 | Togo | 591 | 14 | 395 | 182 | 8.6195 | 0.8248 | 2020-06-27 04:33:35 | Togo | |||
2624887 | 2624887 | 2020-06-25 | Pakistan | Azad Jammu and Kashmir | 962 | 25 | 395 | 542 | 34.027401 | 73.947253 | 2020-06-26 04:33:43 | Azad Jammu and Kashmir, Pakistan | ||
2437904 | 2437904 | 2020-06-20 | Russia | Karelia Republic | 960 | 2 | 395 | 563 | 62.61940309999999 | 33.4920267 | 2020-06-21 04:33:19 | Karelia Republic, Russia | ||
3416530 | 3416530 | 2020-05-17 | Taiwan* | 440 | 7 | 395 | 38 | 23.7 | 121.0 | 2020-05-18 02:32:21 | Taiwan* | |||
1932096 | 1932096 | 2020-05-05 | Malaysia | Negeri Sembilan | 599 | 8 | 395 | 196 | 2.7258 | 101.9424 | 2020-05-06 02:32:31 | Negeri Sembilan, Malaysia | ||
3589384 | 3589384 | 2020-04-27 | Kyrgyzstan | 695 | 8 | 395 | 292 | 41.20438 | 74.766098 | 2020-04-28 02:30:32 | Kyrgyzstan |
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]);