johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
70 rows where recovered = 170 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 22
- Japan 15
- Brunei 7
- Mainland China 7
- United Kingdom 7
- Malaysia 5
- Australia 4
- Colombia 4
- China 3
- Liechtenstein 3
- Antigua and Barbuda 2
- Ukraine 2
- Bulgaria 1
- Guinea 1
- India 1
- Iraq 1
- Jordan 1
- Mexico 1
- Mongolia 1
- Nigeria 1
- Paraguay 1
- Russia 1
- Timor-Leste 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2103826 | 2103826 | 2021-06-01 | Australia | Northern Territory | 173 | 0 | 170 | 3 | -12.4634 | 130.8456 | 2021-06-02 04:24:34 | Northern Territory, Australia | ||
1188442 | 1188442 | 2021-05-31 | Australia | Northern Territory | 173 | 0 | 170 | 3 | -12.4634 | 130.8456 | 2021-06-01 04:23:09 | Northern Territory, Australia | ||
3089119 | 3089119 | 2021-05-30 | Australia | Northern Territory | 173 | 0 | 170 | 3 | -12.4634 | 130.8456 | 2021-05-31 03:08:59 | Northern Territory, Australia | ||
1290339 | 1290339 | 2021-03-29 | Timor-Leste | 512 | 0 | 170 | 342 | -8.874217 | 125.727539 | 2021-03-30 04:26:23 | Timor-Leste | |||
340031 | 340031 | 2021-02-03 | Brunei | 180 | 3 | 170 | 7 | 4.5353 | 114.7277 | 2021-02-04 05:22:26 | Brunei | |||
1684257 | 1684257 | 2021-02-02 | Brunei | 180 | 3 | 170 | 7 | 4.5353 | 114.7277 | 2021-02-03 05:22:52 | Brunei | |||
1676227 | 1676227 | 2021-02-01 | Brunei | 180 | 3 | 170 | 7 | 4.5353 | 114.7277 | 2021-02-02 05:22:49 | Brunei | |||
1459515 | 1459515 | 2021-01-31 | Brunei | 180 | 3 | 170 | 7 | 4.5353 | 114.7277 | 2021-02-01 05:22:53 | Brunei | |||
2211423 | 2211423 | 2021-01-30 | Brunei | 180 | 3 | 170 | 7 | 4.5353 | 114.7277 | 2021-01-31 05:22:42 | Brunei | |||
1896910 | 1896910 | 2021-01-29 | Brunei | 180 | 3 | 170 | 7 | 4.5353 | 114.7277 | 2021-01-30 05:22:49 | Brunei | |||
2481726 | 2481726 | 2021-01-28 | Brunei | 180 | 3 | 170 | 7 | 4.5353 | 114.7277 | 2021-01-29 05:22:23 | Brunei | |||
12033 | 12033 | 2021-01-26 | Antigua and Barbuda | 201 | 6 | 170 | 25 | 17.0608 | -61.7964 | 2021-01-27 05:23:41 | Antigua and Barbuda | |||
2567357 | 2567357 | 2021-01-25 | Antigua and Barbuda | 201 | 6 | 170 | 25 | 17.0608 | -61.7964 | 2021-01-26 05:22:02 | Antigua and Barbuda | |||
2466806 | 2466806 | 2021-01-22 | Japan | Akita | 235 | 1 | 170 | 64 | 39.748679 | 140.408228 | 2021-01-23 05:22:03 | Akita, Japan | ||
202293 | 202293 | 2020-12-25 | Japan | Shimane | 190 | 0 | 170 | 20 | 35.07076 | 132.55406399999998 | 2020-12-26 05:22:28 | Shimane, Japan | ||
2975268 | 2975268 | 2020-12-09 | Japan | Tokushima | 187 | 9 | 170 | 8 | 33.919178 | 134.242091 | 2020-12-10 05:26:19 | Tokushima, Japan | ||
1818828 | 1818828 | 2020-12-08 | Japan | Tokushima | 187 | 9 | 170 | 8 | 33.919178 | 134.242091 | 2020-12-09 05:28:01 | Tokushima, Japan | ||
2347464 | 2347464 | 2020-12-07 | Japan | Tokushima | 185 | 9 | 170 | 6 | 33.919178 | 134.242091 | 2020-12-08 05:27:42 | Tokushima, Japan | ||
1006334 | 1006334 | 2020-12-06 | Japan | Tokushima | 185 | 9 | 170 | 6 | 33.919178 | 134.242091 | 2020-12-07 05:26:14 | Tokushima, Japan | ||
126391 | 126391 | 2020-11-18 | Malaysia | W.P. Putrajaya | 194 | 1 | 170 | 23 | 2.9264 | 101.6964 | 2020-11-19 05:25:23 | W.P. Putrajaya, Malaysia | ||
3342279 | 3342279 | 2020-11-17 | Malaysia | W.P. Putrajaya | 193 | 1 | 170 | 22 | 2.9264 | 101.6964 | 2020-11-18 05:40:31 | W.P. Putrajaya, Malaysia | ||
3173324 | 3173324 | 2020-11-16 | Malaysia | W.P. Putrajaya | 191 | 1 | 170 | 20 | 2.9264 | 101.6964 | 2020-11-17 05:25:54 | W.P. Putrajaya, Malaysia | ||
3307865 | 3307865 | 2020-11-02 | Malaysia | Kelantan | 182 | 3 | 170 | 9 | 6.1254 | 102.2381 | 2020-11-03 06:00:16 | Kelantan, Malaysia | ||
8394 | 8394 | 2020-10-25 | Liechtenstein | 412 | 1 | 170 | 241 | 47.14 | 9.55 | 2020-10-26 04:25:02 | Liechtenstein | |||
3651631 | 3651631 | 2020-10-24 | Liechtenstein | 375 | 1 | 170 | 204 | 47.14 | 9.55 | 2020-10-25 04:24:36 | Liechtenstein | |||
1053886 | 1053886 | 2020-10-23 | Liechtenstein | 352 | 1 | 170 | 181 | 47.14 | 9.55 | 2020-10-24 04:24:46 | Liechtenstein | |||
79116 | 79116 | 2020-10-14 | Japan | Niigata | 178 | 0 | 170 | 8 | 37.521819 | 138.918647 | 2020-10-15 04:24:28 | Niigata, Japan | ||
3781931 | 3781931 | 2020-10-13 | Japan | Niigata | 178 | 0 | 170 | 8 | 37.521819 | 138.918647 | 2020-10-14 04:24:05 | Niigata, Japan | ||
3789531 | 3789531 | 2020-10-11 | United Kingdom | Bermuda | 184 | 9 | 170 | 5 | 32.3078 | -64.7505 | 2020-10-12 04:23:45 | Bermuda, United Kingdom | ||
2605669 | 2605669 | 2020-10-10 | United Kingdom | Bermuda | 184 | 9 | 170 | 5 | 32.3078 | -64.7505 | 2020-10-11 04:23:46 | Bermuda, United Kingdom | ||
821202 | 821202 | 2020-10-09 | United Kingdom | Bermuda | 184 | 9 | 170 | 5 | 32.3078 | -64.7505 | 2020-10-10 04:23:57 | Bermuda, United Kingdom | ||
2693317 | 2693317 | 2020-10-08 | United Kingdom | Bermuda | 182 | 9 | 170 | 3 | 32.3078 | -64.7505 | 2020-10-09 04:23:59 | Bermuda, United Kingdom | ||
1045459 | 1045459 | 2020-10-07 | United Kingdom | Bermuda | 181 | 9 | 170 | 2 | 32.3078 | -64.7505 | 2020-10-08 04:23:56 | Bermuda, United Kingdom | ||
3121120 | 3121120 | 2020-10-06 | United Kingdom | Bermuda | 181 | 9 | 170 | 2 | 32.3078 | -64.7505 | 2020-10-07 04:23:40 | Bermuda, United Kingdom | ||
3805532 | 3805532 | 2020-10-05 | United Kingdom | Bermuda | 181 | 9 | 170 | 2 | 32.3078 | -64.7505 | 2020-10-06 04:23:33 | Bermuda, United Kingdom | ||
2848887 | 2848887 | 2020-09-18 | Japan | Yamaguchi | 195 | 1 | 170 | 24 | 34.20119 | 131.573293 | 2020-09-19 04:22:00 | Yamaguchi, Japan | ||
1121779 | 1121779 | 2020-09-17 | Russia | Chukotka Autonomous Okrug | 180 | 2 | 170 | 8 | 66.0006475 | 169.4900869 | 2020-09-18 05:05:00 | Chukotka Autonomous Okrug, Russia | ||
2059907 | 2059907 | 2020-09-01 | Japan | Nagano | 261 | 1 | 170 | 90 | 36.132134 | 138.045528 | 2020-09-02 04:28:25 | Nagano, Japan | ||
3178053 | 3178053 | 2020-08-18 | Japan | Wakayama | 209 | 4 | 170 | 35 | 33.911879 | 135.505446 | 2020-08-19 04:27:00 | Wakayama, Japan | ||
371162 | 371162 | 2020-08-08 | Colombia | Arauca | 335 | 8 | 170 | 157 | 7.0762 | -70.7105 | 2020-08-09 04:34:54 | Arauca, Colombia | ||
753641 | 753641 | 2020-08-01 | Colombia | Putumayo | 943 | 38 | 170 | 735 | 0.436 | -75.5277 | 2020-08-02 04:34:47 | Putumayo, Colombia | ||
61757 | 61757 | 2020-07-23 | India | Andaman and Nicobar Islands | 240 | 0 | 170 | 70 | 11.225999 | 92.968178 | 2020-07-24 05:30:40 | Andaman and Nicobar Islands, India | ||
844900 | 844900 | 2020-07-22 | Colombia | Quindio | 223 | 6 | 170 | 47 | 4.461 | -75.6674 | 2020-07-23 05:15:04 | Quindio, Colombia | ||
326931 | 326931 | 2020-07-20 | Japan | Hiroshima | 213 | 3 | 170 | 40 | 34.605309000000005 | 132.788719 | 2020-07-21 04:38:46 | Hiroshima, Japan | ||
415199 | 415199 | 2020-07-05 | Colombia | Cauca | 507 | 20 | 170 | 317 | 2.705 | -76.82600000000002 | 2020-07-06 04:33:57 | Cauca, Colombia | ||
2234459 | 2234459 | 2020-07-03 | Ukraine | Donetsk Oblast | 599 | 9 | 170 | 420 | 48.0159 | 37.8028 | 2020-07-04 04:33:51 | Donetsk Oblast, Ukraine | ||
2625461 | 2625461 | 2020-06-25 | Mongolia | 216 | 0 | 170 | 49 | 46.8625 | 103.8467 | 2020-06-26 04:33:43 | Mongolia | |||
2625248 | 2625248 | 2020-06-25 | Ukraine | Sevastopol* | 215 | 3 | 170 | 42 | 44.6054 | 33.522 | 2020-06-26 04:33:43 | Sevastopol*, Ukraine | ||
1837251 | 1837251 | 2020-06-14 | Japan | Port Quarantine | 256 | 0 | 170 | 86 | 2020-06-15 03:33:14 | Port Quarantine, Japan | ||||
3061303 | 3061303 | 2020-06-13 | Japan | Port Quarantine | 242 | 0 | 170 | 72 | 2020-06-14 03:33:15 | Port Quarantine, Japan | ||||
737623 | 737623 | 2020-06-12 | Japan | Port Quarantine | 239 | 0 | 170 | 69 | 2020-06-13 03:33:14 | Port Quarantine, Japan | ||||
1041307 | 1041307 | 2020-05-26 | Mexico | Zacatecas | 251 | 29 | 170 | 52 | 22.7709 | -102.5832 | 2020-05-27 02:32:31 | Zacatecas, Mexico | ||
3331124 | 3331124 | 2020-05-11 | Paraguay | 724 | 10 | 170 | 544 | -23.4425 | -58.4438 | 2020-05-12 03:32:27 | Paraguay | |||
2524878 | 2524878 | 2020-04-23 | Guinea | 862 | 6 | 170 | 686 | 9.9456 | -9.6966 | 2020-04-24 03:30:31 | Guinea | |||
522351 | 522351 | 2020-04-21 | Bulgaria | 975 | 45 | 170 | 760 | 42.7339 | 25.4858 | 2020-04-21 23:30:30 | Bulgaria | |||
1385221 | 1385221 | 2020-04-19 | Nigeria | 627 | 21 | 170 | 436 | 9.082 | 8.6753 | 2020-04-19 23:40:41 | Nigeria | |||
43353 | 43353 | 2020-04-13 | Malaysia | Perak | 246 | 6 | 170 | 70 | 4.5921 | 101.0901 | 2020-04-13 23:07:54 | Perak, Malaysia | ||
1250294 | 1250294 | 2020-04-10 | Jordan | 372 | 7 | 170 | 195 | 31.24 | 36.51 | 2020-04-10 22:53:48 | Jordan | |||
3949942 | 3949942 | 2020-04-09 | Australia | Western Australia | 495 | 6 | 170 | 319 | -31.9505 | 115.8605 | 2020-04-09 23:09:19 | Western Australia, Australia | ||
3815958 | 3815958 | 2020-03-31 | Iraq | 694 | 50 | 170 | 474 | 33.223191 | 43.679291 | 2020-03-31 23:43:43 | Iraq | |||
3765302 | 3765302 | 2020-03-13 | China | Yunnan | 174 | 2 | 170 | 24.974 | 101.487 | 2020-03-11T02:18:14 | ||||
2282900 | 2282900 | 2020-03-12 | China | Yunnan | 174 | 2 | 170 | 24.974 | 101.487 | 2020-03-11T02:18:14 | ||||
2127470 | 2127470 | 2020-03-11 | China | Yunnan | 174 | 2 | 170 | 24.974 | 101.487 | 2020-03-11T02:18:14 | ||||
3752849 | 3752849 | 2020-03-10 | Mainland China | Yunnan | 174 | 2 | 170 | 24.974 | 101.487 | 2020-03-06T03:23:06 | ||||
657715 | 657715 | 2020-03-09 | Mainland China | Yunnan | 174 | 2 | 170 | 24.974 | 101.487 | 2020-03-06T03:23:06 | ||||
1527231 | 1527231 | 2020-03-08 | Mainland China | Yunnan | 174 | 2 | 170 | 24.974 | 101.487 | 2020-03-06T03:23:06 | ||||
62500 | 62500 | 2020-03-07 | Mainland China | Yunnan | 174 | 2 | 170 | 24.974 | 101.487 | 2020-03-06T03:23:06 | ||||
3177502 | 3177502 | 2020-03-06 | Mainland China | Yunnan | 174 | 2 | 170 | 24.974 | 101.487 | 2020-03-06T03:23:06 | ||||
3173354 | 3173354 | 2020-02-23 | Mainland China | Fujian | 293 | 1 | 170 | 26.0789 | 117.9874 | 2020-02-23T10:33:03 | ||||
1559659 | 1559659 | 2020-02-13 | Mainland China | Jiangxi | 872 | 1 | 170 | 27.614 | 115.7221 | 2020-02-13T01:13:08 |
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]);