johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
84 rows where recovered = 167 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 23
- China 27
- Tanzania 9
- Japan 8
- United Kingdom 8
- Russia 7
- India 3
- Burma 2
- Colombia 2
- Fiji 2
- Malaysia 2
- Ukraine 2
- Australia 1
- Bulgaria 1
- Cabo Verde 1
- Croatia 1
- Ethiopia 1
- Kenya 1
- Liberia 1
- Mainland China 1
- Monaco 1
- Sierra Leone 1
- Slovakia 1
- United Arab Emirates 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2104019 | 2104019 | 2021-06-01 | Fiji | 464 | 4 | 167 | 293 | -17.7134 | 178.065 | 2021-06-02 04:24:34 | Fiji | |||
1188635 | 1188635 | 2021-05-31 | Fiji | 438 | 4 | 167 | 267 | -17.7134 | 178.065 | 2021-06-01 04:23:09 | Fiji | |||
1153075 | 1153075 | 2021-02-18 | India | Lakshadweep | 263 | 0 | 167 | 96 | 13.6999972 | 72.18333259999999 | 2021-02-19 05:24:16 | Lakshadweep, India | ||
3543140 | 3543140 | 2021-02-12 | Malaysia | Perlis | 192 | 2 | 167 | 23 | 6.4449 | 100.2048 | 2021-02-13 05:22:12 | Perlis, Malaysia | ||
3859871 | 3859871 | 2020-12-04 | Japan | Tokushima | 184 | 9 | 167 | 8 | 33.919178 | 134.242091 | 2020-12-05 05:27:36 | Tokushima, Japan | ||
1049451 | 1049451 | 2020-09-30 | United Kingdom | Bermuda | 181 | 9 | 167 | 5 | 32.3078 | -64.7505 | 2020-10-01 04:23:42 | Bermuda, United Kingdom | ||
970532 | 970532 | 2020-09-29 | United Kingdom | Bermuda | 181 | 9 | 167 | 5 | 32.3078 | -64.7505 | 2020-09-30 04:23:33 | Bermuda, United Kingdom | ||
1519029 | 1519029 | 2020-09-28 | United Kingdom | Bermuda | 181 | 9 | 167 | 5 | 32.3078 | -64.7505 | 2020-09-29 04:23:42 | Bermuda, United Kingdom | ||
2585617 | 2585617 | 2020-09-27 | United Kingdom | Bermuda | 181 | 9 | 167 | 5 | 32.3078 | -64.7505 | 2020-09-28 04:23:00 | Bermuda, United Kingdom | ||
2617669 | 2617669 | 2020-09-26 | United Kingdom | Bermuda | 181 | 9 | 167 | 5 | 32.3078 | -64.7505 | 2020-09-27 04:23:00 | Bermuda, United Kingdom | ||
2816384 | 2816384 | 2020-09-25 | United Kingdom | Bermuda | 181 | 9 | 167 | 5 | 32.3078 | -64.7505 | 2020-09-26 04:23:00 | Bermuda, United Kingdom | ||
2812855 | 2812855 | 2020-09-25 | Monaco | 208 | 2 | 167 | 39 | 43.7333 | 7.4167 | 2020-09-26 04:23:00 | Monaco | |||
2609661 | 2609661 | 2020-09-24 | United Kingdom | Bermuda | 181 | 9 | 167 | 5 | 32.3078 | -64.7505 | 2020-09-25 04:23:00 | Bermuda, United Kingdom | ||
2657404 | 2657404 | 2020-09-23 | United Kingdom | Bermuda | 181 | 9 | 167 | 5 | 32.3078 | -64.7505 | 2020-09-24 04:23:00 | Bermuda, United Kingdom | ||
2848888 | 2848888 | 2020-09-18 | Japan | Yamanashi | 180 | 6 | 167 | 7 | 35.612364 | 138.611489 | 2020-09-19 04:22:00 | Yamanashi, Japan | ||
2171738 | 2171738 | 2020-09-09 | Russia | Chukotka Autonomous Okrug | 174 | 2 | 167 | 5 | 66.0006475 | 169.4900869 | 2020-09-10 04:29:01 | Chukotka Autonomous Okrug, Russia | ||
2171353 | 2171353 | 2020-09-09 | China | Gansu | 170 | 2 | 167 | 1 | 35.7518 | 104.2861 | 2020-09-10 04:29:01 | Gansu, China | ||
1243947 | 1243947 | 2020-09-08 | Russia | Chukotka Autonomous Okrug | 174 | 2 | 167 | 5 | 66.0006475 | 169.4900869 | 2020-09-09 04:28:48 | Chukotka Autonomous Okrug, Russia | ||
1243562 | 1243562 | 2020-09-08 | China | Gansu | 170 | 2 | 167 | 1 | 35.7518 | 104.2861 | 2020-09-09 04:28:48 | Gansu, China | ||
427526 | 427526 | 2020-09-07 | Russia | Chukotka Autonomous Okrug | 174 | 2 | 167 | 5 | 66.0006475 | 169.4900869 | 2020-09-08 04:28:25 | Chukotka Autonomous Okrug, Russia | ||
427141 | 427141 | 2020-09-07 | China | Gansu | 170 | 2 | 167 | 1 | 35.7518 | 104.2861 | 2020-09-08 04:28:25 | Gansu, China | ||
3161811 | 3161811 | 2020-09-06 | Russia | Chukotka Autonomous Okrug | 174 | 2 | 167 | 5 | 66.0006475 | 169.4900869 | 2020-09-07 04:28:30 | Chukotka Autonomous Okrug, Russia | ||
3161426 | 3161426 | 2020-09-06 | China | Gansu | 170 | 2 | 167 | 1 | 35.7518 | 104.2861 | 2020-09-07 04:28:30 | Gansu, China | ||
813766 | 813766 | 2020-09-05 | Russia | Chukotka Autonomous Okrug | 174 | 2 | 167 | 5 | 66.0006475 | 169.4900869 | 2020-09-06 04:28:33 | Chukotka Autonomous Okrug, Russia | ||
813381 | 813381 | 2020-09-05 | China | Gansu | 170 | 2 | 167 | 1 | 35.7518 | 104.2861 | 2020-09-06 04:28:33 | Gansu, China | ||
2661966 | 2661966 | 2020-09-04 | Russia | Chukotka Autonomous Okrug | 172 | 2 | 167 | 3 | 66.0006475 | 169.4900869 | 2020-09-05 04:28:19 | Chukotka Autonomous Okrug, Russia | ||
2661581 | 2661581 | 2020-09-04 | China | Gansu | 169 | 2 | 167 | 0 | 35.7518 | 104.2861 | 2020-09-05 04:28:19 | Gansu, China | ||
1354121 | 1354121 | 2020-09-03 | China | Gansu | 169 | 2 | 167 | 0 | 35.7518 | 104.2861 | 2020-09-04 04:28:26 | Gansu, China | ||
1105358 | 1105358 | 2020-09-02 | China | Gansu | 169 | 2 | 167 | 0 | 35.7518 | 104.2861 | 2020-09-03 04:28:22 | Gansu, China | ||
2059687 | 2059687 | 2020-09-01 | China | Gansu | 169 | 2 | 167 | 0 | 35.7518 | 104.2861 | 2020-09-02 04:28:25 | Gansu, China | ||
193872 | 193872 | 2020-08-31 | China | Gansu | 169 | 2 | 167 | 0 | 35.7518 | 104.2861 | 2020-09-01 04:28:31 | Gansu, China | ||
3931831 | 3931831 | 2020-08-30 | China | Gansu | 169 | 2 | 167 | 0 | 35.7518 | 104.2861 | 2020-08-31 04:28:27 | Gansu, China | ||
609493 | 609493 | 2020-08-29 | China | Gansu | 169 | 2 | 167 | 0 | 35.7518 | 104.2861 | 2020-08-30 04:28:22 | Gansu, China | ||
1522988 | 1522988 | 2020-08-28 | China | Gansu | 169 | 2 | 167 | 0 | 35.7518 | 104.2861 | 2020-08-29 04:28:19 | Gansu, China | ||
2513798 | 2513798 | 2020-08-27 | Ukraine | Luhansk Oblast | 264 | 2 | 167 | 95 | 48.574 | 39.3078 | 2020-08-28 04:28:11 | Luhansk Oblast, Ukraine | ||
2509989 | 2509989 | 2020-08-27 | China | Gansu | 169 | 2 | 167 | 0 | 35.7518 | 104.2861 | 2020-08-28 04:28:11 | Gansu, China | ||
1996449 | 1996449 | 2020-08-26 | China | Gansu | 169 | 2 | 167 | 0 | 35.7518 | 104.2861 | 2020-08-27 04:28:15 | Gansu, China | ||
3562373 | 3562373 | 2020-08-25 | China | Gansu | 169 | 2 | 167 | 0 | 35.7518 | 104.2861 | 2020-08-26 04:28:11 | Gansu, China | ||
2991077 | 2991077 | 2020-08-24 | China | Gansu | 169 | 2 | 167 | 0 | 35.7518 | 104.2861 | 2020-08-25 04:28:02 | Gansu, China | ||
2215472 | 2215472 | 2020-08-23 | China | Gansu | 169 | 2 | 167 | 0 | 35.7518 | 104.2861 | 2020-08-24 04:27:56 | Gansu, China | ||
2299254 | 2299254 | 2020-08-22 | China | Gansu | 169 | 2 | 167 | 0 | 35.7518 | 104.2861 | 2020-08-23 04:27:48 | Gansu, China | ||
1479361 | 1479361 | 2020-08-21 | China | Gansu | 169 | 2 | 167 | 0 | 35.7518 | 104.2861 | 2020-08-22 04:27:49 | Gansu, China | ||
3484110 | 3484110 | 2020-08-20 | China | Gansu | 169 | 2 | 167 | 0 | 35.7518 | 104.2861 | 2020-08-21 04:27:41 | Gansu, China | ||
206059 | 206059 | 2020-08-19 | China | Gansu | 169 | 2 | 167 | 0 | 35.7518 | 104.2861 | 2020-08-20 04:27:43 | Gansu, China | ||
3177813 | 3177813 | 2020-08-18 | China | Gansu | 169 | 2 | 167 | 0 | 35.7518 | 104.2861 | 2020-08-19 04:27:00 | Gansu, China | ||
837417 | 837417 | 2020-08-17 | China | Gansu | 169 | 2 | 167 | 0 | 35.7518 | 104.2861 | 2020-08-18 04:27:56 | Gansu, China | ||
1555775 | 1555775 | 2020-08-16 | China | Gansu | 169 | 2 | 167 | 0 | 35.7518 | 104.2861 | 2020-08-17 04:27:20 | Gansu, China | ||
145777 | 145777 | 2020-08-15 | China | Gansu | 169 | 2 | 167 | 0 | 35.7518 | 104.2861 | 2020-08-16 04:27:42 | Gansu, China | ||
1612270 | 1612270 | 2020-08-14 | Japan | Miyagi | 184 | 1 | 167 | 16 | 38.446859 | 140.927086 | 2020-08-15 04:27:31 | Miyagi, Japan | ||
121948 | 121948 | 2020-07-19 | India | Mizoram | 284 | 0 | 167 | 117 | 23.309381 | 92.83821999999999 | 2020-07-20 05:34:40 | Mizoram, India | ||
121836 | 121836 | 2020-07-19 | Japan | Hiroshima | 209 | 3 | 167 | 39 | 34.605309000000005 | 132.788719 | 2020-07-20 05:34:40 | Hiroshima, Japan | ||
3205337 | 3205337 | 2020-07-18 | India | Mizoram | 284 | 0 | 167 | 117 | 23.309381 | 92.83821999999999 | 2020-07-19 04:34:58 | Mizoram, India | ||
3205225 | 3205225 | 2020-07-18 | Japan | Hiroshima | 207 | 3 | 167 | 37 | 34.605309000000005 | 132.788719 | 2020-07-19 04:34:58 | Hiroshima, Japan | ||
2708527 | 2708527 | 2020-07-17 | Japan | Hiroshima | 205 | 3 | 167 | 35 | 34.605309000000005 | 132.788719 | 2020-07-18 04:34:45 | Hiroshima, Japan | ||
367341 | 367341 | 2020-07-16 | Japan | Hiroshima | 198 | 3 | 167 | 28 | 34.605309000000005 | 132.788719 | 2020-07-17 04:34:50 | Hiroshima, Japan | ||
3737566 | 3737566 | 2020-07-12 | Japan | Ibaraki | 199 | 10 | 167 | 22 | 36.303588 | 140.319591 | 2020-07-13 04:43:04 | Ibaraki, Japan | ||
3045253 | 3045253 | 2020-07-02 | Ukraine | Donetsk Oblast | 562 | 9 | 167 | 386 | 48.0159 | 37.8028 | 2020-07-03 04:33:54 | Donetsk Oblast, Ukraine | ||
3682522 | 3682522 | 2020-06-18 | Colombia | Choco | 841 | 24 | 167 | 650 | 5.2528 | -76.82600000000002 | 2020-06-19 04:33:17 | Choco, Colombia | ||
3682484 | 3682484 | 2020-06-18 | Colombia | Boyaca | 263 | 14 | 167 | 82 | 5.4545 | -73.362 | 2020-06-19 04:33:17 | Boyaca, Colombia | ||
1837440 | 1837440 | 2020-06-14 | Burma | 261 | 6 | 167 | 88 | 21.9162 | 95.956 | 2020-06-15 03:33:14 | Burma | |||
3061492 | 3061492 | 2020-06-13 | Burma | 261 | 6 | 167 | 88 | 21.9162 | 95.956 | 2020-06-14 03:33:15 | Burma | |||
2556137 | 2556137 | 2020-06-02 | Liberia | 296 | 27 | 167 | 102 | 6.4280550000000005 | -9.429499 | 2020-06-03 02:33:13 | Liberia | |||
805156 | 805156 | 2020-06-01 | Russia | Amur Oblast | 528 | 5 | 167 | 356 | 52.8032368 | 128.437295 | 2020-06-02 02:33:08 | Amur Oblast, Russia | ||
3639038 | 3639038 | 2020-05-30 | Cabo Verde | 421 | 4 | 167 | 250 | 16.5388 | -23.0418 | 2020-05-31 02:32:45 | Cabo Verde | |||
1041363 | 1041363 | 2020-05-26 | Ethiopia | 701 | 6 | 167 | 528 | 9.145 | 40.4897 | 2020-05-27 02:32:31 | Ethiopia | |||
2390385 | 2390385 | 2020-05-19 | Sierra Leone | 534 | 33 | 167 | 334 | 8.460555000000001 | -11.779889 | 2020-05-20 02:32:19 | Sierra Leone | |||
3295807 | 3295807 | 2020-05-07 | Tanzania | 480 | 16 | 167 | 297 | -6.369028 | 34.888822 | 2020-05-08 02:32:32 | Tanzania | |||
2111028 | 2111028 | 2020-05-06 | Tanzania | 480 | 16 | 167 | 297 | -6.369028 | 34.888822 | 2020-05-07 02:32:28 | Tanzania | |||
2110854 | 2110854 | 2020-05-06 | Australia | Tasmania | 226 | 13 | 167 | 46 | -42.8821 | 147.3272 | 2020-05-07 02:32:28 | Tasmania, Australia | ||
1932068 | 1932068 | 2020-05-05 | Tanzania | 480 | 16 | 167 | 297 | -6.369028 | 34.888822 | 2020-05-06 02:32:31 | Tanzania | |||
1931852 | 1931852 | 2020-05-05 | China | Inner Mongolia | 201 | 1 | 167 | 33 | 44.0935 | 113.9448 | 2020-05-06 02:32:31 | Inner Mongolia, China | ||
3084931 | 3084931 | 2020-05-04 | Tanzania | 480 | 16 | 167 | 297 | -6.369028 | 34.888822 | 2020-05-05 02:32:34 | Tanzania | |||
2278790 | 2278790 | 2020-05-03 | Tanzania | 480 | 16 | 167 | 297 | -6.369028 | 34.888822 | 2020-05-04 02:32:28 | Tanzania | |||
2278714 | 2278714 | 2020-05-03 | Kenya | 465 | 24 | 167 | 274 | -0.0236 | 37.9062 | 2020-05-04 02:32:28 | Kenya | |||
2043466 | 2043466 | 2020-05-02 | Tanzania | 480 | 16 | 167 | 297 | -6.369028 | 34.888822 | 2020-05-03 02:32:28 | Tanzania | |||
1184360 | 1184360 | 2020-05-01 | Tanzania | 480 | 16 | 167 | 297 | -6.369028 | 34.888822 | 2020-05-02 02:32:27 | Tanzania | |||
228841 | 228841 | 2020-04-30 | Tanzania | 480 | 16 | 167 | 297 | -6.369028 | 34.888822 | 2020-05-01 02:32:28 | Tanzania | |||
137586 | 137586 | 2020-04-29 | Tanzania | 480 | 16 | 167 | 297 | -6.369028 | 34.888822 | 2020-04-30 02:32:27 | Tanzania | |||
2473433 | 2473433 | 2020-04-20 | Bulgaria | 929 | 43 | 167 | 719 | 42.7339 | 25.4858 | 2020-04-20 23:36:27 | Bulgaria | |||
934403 | 934403 | 2020-04-16 | Slovakia | 977 | 8 | 167 | 802 | 48.669 | 19.699 | 2020-04-16 23:30:31 | Slovakia | |||
3021768 | 3021768 | 2020-04-07 | Croatia | 1282 | 18 | 167 | 1097 | 45.1 | 15.2 | 2020-04-07 23:04:29 | Croatia | |||
3627581 | 3627581 | 2020-04-06 | United Arab Emirates | 2076 | 11 | 167 | 1898 | 23.424076 | 53.847818 | 4/6/20 23:21 | United Arab Emirates | |||
3740749 | 3740749 | 2020-04-03 | Malaysia | W.P. Kuala Lumpur | 547 | 7 | 167 | 373 | 3.139 | 101.6869 | 2020-04-03 22:46:37 | W.P. Kuala Lumpur, Malaysia | ||
3089002 | 3089002 | 2020-02-10 | Mainland China | Guangdong | 1159 | 1 | 167 | 23.3417 | 113.4244 | 2020-02-10T13:43:02 |
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]);