johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,714 rows where active = 85 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
- US 1,506
- Japan 47
- Malaysia 15
- Colombia 13
- Italy 12
- China 10
- India 9
- Ukraine 8
- Germany 6
- Russia 6
- Burundi 5
- France 5
- Madagascar 5
- Burma 4
- Canada 4
- Benin 3
- Bhutan 3
- Central African Republic 3
- Chile 3
- Eritrea 3
- Gabon 3
- Netherlands 3
- New Zealand 3
- Jordan 2
- Liechtenstein 2
- Niger 2
- Rwanda 2
- Saint Lucia 2
- Thailand 2
- Trinidad and Tobago 2
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1818463 | 1818463 | 2021-09-19 | Malaysia | W.P. Labuan | 9921 | 148 | 9688 | 85 | 5.2831 | 115.2308 | 2021-09-20 04:21:22 | W.P. Labuan, Malaysia | ||
653653 | 653653 | 2021-08-09 | Malaysia | W.P. Labuan | 9718 | 148 | 9485 | 85 | 5.2831 | 115.2308 | 2021-08-10 04:21:27 | W.P. Labuan, Malaysia | ||
408142 | 408142 | 2021-07-28 | Colombia | Guaviare | 4992 | 87 | 4820 | 85 | 1.0654 | -73.2603 | 2021-07-29 04:21:33 | Guaviare, Colombia | ||
1306172 | 1306172 | 2021-07-27 | Japan | Kagoshima | 3878 | 39 | 3754 | 85 | 31.009484000000004 | 130.430665 | 2021-07-28 04:21:39 | Kagoshima, Japan | ||
1378321 | 1378321 | 2021-07-25 | China | Jiangsu | 829 | 0 | 744 | 85 | 32.9711 | 119.455 | 2021-07-26 04:21:28 | Jiangsu, China | ||
487228 | 487228 | 2021-07-19 | Ukraine | Rivne Oblast | 79613 | 1206 | 78322 | 85 | 50.6199 | 26.2516 | 2021-07-20 04:21:48 | Rivne Oblast, Ukraine | ||
483599 | 483599 | 2021-07-19 | Japan | Gunma | 8154 | 154 | 7915 | 85 | 36.504479 | 138.985605 | 2021-07-20 04:21:48 | Gunma, Japan | ||
2677451 | 2677451 | 2021-07-18 | Ukraine | Rivne Oblast | 79611 | 1206 | 78320 | 85 | 50.6199 | 26.2516 | 2021-07-19 04:21:24 | Rivne Oblast, Ukraine | ||
2947214 | 2947214 | 2021-07-16 | Colombia | San Andres y Providencia | 6581 | 131 | 6365 | 85 | 12.5567 | -81.7185 | 2021-07-17 04:22:22 | San Andres y Providencia, Colombia | ||
3744707 | 3744707 | 2021-07-12 | Ukraine | Ivano-Frankivsk Oblast | 86729 | 2103 | 84541 | 85 | 48.9226 | 24.7111 | 2021-07-13 04:21:18 | Ivano-Frankivsk Oblast, Ukraine | ||
625914 | 625914 | 2021-07-10 | Japan | Shiga | 5621 | 90 | 5446 | 85 | 35.21582700000001 | 136.138064 | 2021-07-11 04:21:43 | Shiga, Japan | ||
829611 | 829611 | 2021-07-09 | Japan | Ishikawa | 4008 | 115 | 3808 | 85 | 36.769464 | 136.771027 | 2021-07-10 04:21:25 | Ishikawa, Japan | ||
2693703 | 2693703 | 2021-07-06 | Japan | Iwate | 1737 | 47 | 1605 | 85 | 39.593287 | 141.361777 | 2021-07-07 04:21:20 | Iwate, Japan | ||
1932666 | 1932666 | 2021-07-05 | Russia | Nenets Autonomous Okrug | 1249 | 10 | 1154 | 85 | 68.27557185 | 57.1686375 | 2021-07-06 04:21:32 | Nenets Autonomous Okrug, Russia | ||
1495647 | 1495647 | 2021-07-03 | Japan | Wakayama | 2693 | 49 | 2559 | 85 | 33.911879 | 135.505446 | 2021-07-04 04:21:38 | Wakayama, Japan | ||
2071962 | 2071962 | 2021-07-02 | Japan | Wakayama | 2690 | 49 | 2556 | 85 | 33.911879 | 135.505446 | 2021-07-03 04:21:37 | Wakayama, Japan | ||
2764978 | 2764978 | 2021-07-01 | Japan | Wakayama | 2689 | 49 | 2555 | 85 | 33.911879 | 135.505446 | 2021-07-02 04:21:47 | Wakayama, Japan | ||
2764743 | 2764743 | 2021-07-01 | China | Hong Kong | 11927 | 211 | 11631 | 85 | 22.3 | 114.2 | 2021-07-02 04:21:47 | Hong Kong, China | ||
1893168 | 1893168 | 2021-06-30 | Japan | Nara | 8206 | 131 | 7990 | 85 | 34.317451 | 135.871644 | 2021-07-01 04:21:19 | Nara, Japan | ||
400252 | 400252 | 2021-06-29 | Italy | Molise | 13717 | 491 | 13141 | 85 | 41.55774754 | 14.65916051 | 2021-06-30 04:21:41 | Molise, Italy | ||
3958643 | 3958643 | 2021-06-26 | Niger | 5478 | 193 | 5200 | 85 | 17.607789 | 8.081666 | 2021-06-27 04:21:39 | Niger | |||
1712462 | 1712462 | 2021-06-25 | Niger | 5478 | 193 | 5200 | 85 | 17.607789 | 8.081666 | 2021-06-26 04:21:43 | Niger | |||
566655 | 566655 | 2021-06-22 | Malaysia | W.P. Putrajaya | 2178 | 13 | 2080 | 85 | 2.9264 | 101.6964 | 2021-06-23 04:21:46 | W.P. Putrajaya, Malaysia | ||
562984 | 562984 | 2021-06-22 | Japan | Kagoshima | 3641 | 38 | 3518 | 85 | 31.009484000000004 | 130.430665 | 2021-06-23 04:21:46 | Kagoshima, Japan | ||
562955 | 562955 | 2021-06-22 | Italy | Molise | 13683 | 491 | 13107 | 85 | 41.55774754 | 14.65916051 | 2021-06-23 04:21:46 | Molise, Italy | ||
2884377 | 2884377 | 2021-06-20 | Japan | Gunma | 8003 | 149 | 7769 | 85 | 36.504479 | 138.985605 | 2021-06-21 04:21:41 | Gunma, Japan | ||
3030490 | 3030490 | 2021-06-16 | Russia | Jewish Autonomous Okrug | 4571 | 146 | 4340 | 85 | 48.57527615 | 132.66307460000002 | 2021-06-17 04:22:36 | Jewish Autonomous Okrug, Russia | ||
1564114 | 1564114 | 2021-06-14 | Japan | Mie | 5148 | 109 | 4954 | 85 | 34.508018 | 136.376013 | 2021-06-15 04:22:22 | Mie, Japan | ||
3970538 | 3970538 | 2021-06-11 | Italy | Molise | 13626 | 491 | 13050 | 85 | 41.55774754 | 14.65916051 | 2021-06-12 04:22:22 | Molise, Italy | ||
3145469 | 3145469 | 2021-06-07 | Eswatini | 18664 | 673 | 17906 | 85 | -26.5225 | 31.4659 | 2021-06-08 04:22:35 | Eswatini | |||
2104133 | 2104133 | 2021-06-01 | Japan | Ehime | 2718 | 72 | 2561 | 85 | 33.624835 | 132.856842 | 2021-06-02 04:24:34 | Ehime, Japan | ||
1310016 | 1310016 | 2021-05-26 | Colombia | Guainia | 1705 | 22 | 1598 | 85 | 2.5854 | -68.5247 | 2021-05-27 04:20:59 | Guainia, Colombia | ||
1916857 | 1916857 | 2021-05-20 | United Kingdom | Bermuda | 2483 | 32 | 2366 | 85 | 32.3078 | -64.7505 | 2021-05-21 04:20:43 | Bermuda, United Kingdom | ||
2004666 | 2004666 | 2021-05-12 | Japan | Fukui | 963 | 34 | 844 | 85 | 35.846614 | 136.22465400000002 | 2021-05-13 04:20:51 | Fukui, Japan | ||
2004430 | 2004430 | 2021-05-12 | Canada | Newfoundland and Labrador | 1166 | 6 | 1075 | 85 | 53.1355 | -57.6604 | 2021-05-13 04:20:51 | Newfoundland and Labrador, Canada | ||
1428718 | 1428718 | 2021-05-09 | Uganda | 42355 | 346 | 41924 | 85 | 1.373333 | 32.290275 | 2021-05-10 04:20:38 | Uganda | |||
3675424 | 3675424 | 2021-05-04 | Canada | Nunavut | 535 | 4 | 446 | 85 | 70.2998 | -83.1076 | 2021-05-05 04:20:43 | Nunavut, Canada | ||
2760691 | 2760691 | 2021-05-03 | Canada | Nunavut | 528 | 4 | 439 | 85 | 70.2998 | -83.1076 | 2021-05-04 04:20:34 | Nunavut, Canada | ||
1567830 | 1567830 | 2021-04-22 | Bhutan | 992 | 1 | 906 | 85 | 27.5142 | 90.4336 | 2021-04-23 04:20:52 | Bhutan | |||
2020989 | 2020989 | 2021-04-20 | Saint Lucia | 4419 | 69 | 4265 | 85 | 13.9094 | -60.9789 | 2021-04-21 04:21:14 | Saint Lucia | |||
1841775 | 1841775 | 2021-04-14 | China | Yunnan | 325 | 2 | 238 | 85 | 24.974 | 101.487 | 2021-04-15 04:20:54 | Yunnan, China | ||
605397 | 605397 | 2021-04-09 | Barbados | 3708 | 44 | 3579 | 85 | 13.1939 | -59.5432 | 2021-04-10 04:20:59 | Barbados | |||
2780692 | 2780692 | 2021-03-24 | Australia | Queensland | 1429 | 6 | 1338 | 85 | -27.4698 | 153.0251 | 2021-03-25 05:27:00 | Queensland, Australia | ||
1798418 | 1798418 | 2021-03-23 | Central African Republic | 5087 | 64 | 4938 | 85 | 6.6111 | 20.9394 | 2021-03-24 05:25:40 | Central African Republic | |||
1203586 | 1203586 | 2021-03-22 | Central African Republic | 5087 | 64 | 4938 | 85 | 6.6111 | 20.9394 | 2021-03-23 05:26:18 | Central African Republic | |||
3369108 | 3369108 | 2021-03-21 | Central African Republic | 5087 | 64 | 4938 | 85 | 6.6111 | 20.9394 | 2021-03-22 05:25:43 | Central African Republic | |||
3420753 | 3420753 | 2021-03-19 | Colombia | Arauca | 5652 | 173 | 5394 | 85 | 7.0762 | -70.7105 | 2021-03-20 05:25:46 | Arauca, Colombia | ||
3452890 | 3452890 | 2021-03-18 | Japan | Port Quarantine | 2320 | 2 | 2233 | 85 | 2021-03-19 05:26:09 | Port Quarantine, Japan | ||||
1580378 | 1580378 | 2021-03-13 | Russia | Nenets Autonomous Okrug | 1057 | 3 | 969 | 85 | 68.27557185 | 57.1686375 | 2021-03-14 05:25:37 | Nenets Autonomous Okrug, Russia | ||
352140 | 352140 | 2021-03-11 | Colombia | Choco | 6602 | 202 | 6315 | 85 | 5.2528 | -76.82600000000002 | 2021-03-12 05:26:50 | Choco, Colombia | ||
3962653 | 3962653 | 2021-03-10 | New Zealand | 2416 | 28 | 2305 | 85 | -40.9006 | 174.886 | 2021-03-11 05:25:48 | New Zealand | |||
3962305 | 3962305 | 2021-03-10 | Chile | Aysen | 3204 | 25 | 3094 | 85 | -45.9864 | -73.7669 | 2021-03-11 05:25:48 | Aysen, Chile | ||
3670495 | 3670495 | 2021-03-06 | US | South Dakota | Jones | 46075 | 85 | 0 | 0 | 85 | 43.96278565 | -100.6940008 | 2021-03-07 05:21:54 | Jones, South Dakota, US |
3669618 | 3669618 | 2021-03-06 | US | Montana | Judith Basin | 30045 | 86 | 1 | 0 | 85 | 47.04581276 | -110.2660688 | 2021-03-07 05:21:54 | Judith Basin, Montana, US |
3667636 | 3667636 | 2021-03-06 | Japan | Ishikawa | 1877 | 62 | 1730 | 85 | 36.769464 | 136.771027 | 2021-03-07 05:21:54 | Ishikawa, Japan | ||
3667466 | 3667466 | 2021-03-06 | Colombia | Choco | 6564 | 201 | 6278 | 85 | 5.2528 | -76.82600000000002 | 2021-03-07 05:21:54 | Choco, Colombia | ||
1619116 | 1619116 | 2021-03-05 | US | South Dakota | Jones | 46075 | 85 | 0 | 0 | 85 | 43.96278565 | -100.6940008 | 2021-03-06 04:23:41 | Jones, South Dakota, US |
1618239 | 1618239 | 2021-03-05 | US | Montana | Judith Basin | 30045 | 86 | 1 | 0 | 85 | 47.04581276 | -110.2660688 | 2021-03-06 04:23:41 | Judith Basin, Montana, US |
1616087 | 1616087 | 2021-03-05 | Colombia | Choco | 6564 | 201 | 6278 | 85 | 5.2528 | -76.82600000000002 | 2021-03-06 04:23:41 | Choco, Colombia | ||
2210527 | 2210527 | 2021-03-04 | US | South Dakota | Jones | 46075 | 85 | 0 | 0 | 85 | 43.96278565 | -100.6940008 | 2021-03-05 05:26:29 | Jones, South Dakota, US |
2209650 | 2209650 | 2021-03-04 | US | Montana | Judith Basin | 30045 | 86 | 1 | 0 | 85 | 47.04581276 | -110.2660688 | 2021-03-05 05:26:29 | Judith Basin, Montana, US |
1092948 | 1092948 | 2021-03-03 | US | South Dakota | Jones | 46075 | 85 | 0 | 0 | 85 | 43.96278565 | -100.6940008 | 2021-03-04 05:24:24 | Jones, South Dakota, US |
1092071 | 1092071 | 2021-03-03 | US | Montana | Judith Basin | 30045 | 86 | 1 | 0 | 85 | 47.04581276 | -110.2660688 | 2021-03-04 05:24:24 | Judith Basin, Montana, US |
3257020 | 3257020 | 2021-03-02 | US | South Dakota | Jones | 46075 | 85 | 0 | 0 | 85 | 43.96278565 | -100.6940008 | 2021-03-03 05:23:28 | Jones, South Dakota, US |
3256143 | 3256143 | 2021-03-02 | US | Montana | Judith Basin | 30045 | 86 | 1 | 0 | 85 | 47.04581276 | -110.2660688 | 2021-03-03 05:23:28 | Judith Basin, Montana, US |
3254423 | 3254423 | 2021-03-02 | Singapore | 59956 | 29 | 59842 | 85 | 1.2833 | 103.8333 | 2021-03-03 05:23:28 | Singapore | |||
3253991 | 3253991 | 2021-03-02 | Colombia | Choco | 6558 | 201 | 6272 | 85 | 5.2528 | -76.82600000000002 | 2021-03-03 05:23:28 | Choco, Colombia | ||
1001312 | 1001312 | 2021-03-01 | US | South Dakota | Jones | 46075 | 85 | 0 | 0 | 85 | 43.96278565 | -100.6940008 | 2021-03-02 05:23:30 | Jones, South Dakota, US |
1000435 | 1000435 | 2021-03-01 | US | Montana | Judith Basin | 30045 | 86 | 1 | 0 | 85 | 47.04581276 | -110.2660688 | 2021-03-02 05:23:30 | Judith Basin, Montana, US |
2370370 | 2370370 | 2021-02-28 | US | South Dakota | Jones | 46075 | 85 | 0 | 0 | 85 | 43.96278565 | -100.6940008 | 2021-03-01 05:23:01 | Jones, South Dakota, US |
2369493 | 2369493 | 2021-02-28 | US | Montana | Judith Basin | 30045 | 86 | 1 | 0 | 85 | 47.04581276 | -110.2660688 | 2021-03-01 05:23:01 | Judith Basin, Montana, US |
3068872 | 3068872 | 2021-02-27 | US | South Dakota | Jones | 46075 | 85 | 0 | 0 | 85 | 43.96278565 | -100.6940008 | 2021-02-28 05:22:20 | Jones, South Dakota, US |
283056 | 283056 | 2021-02-24 | US | South Dakota | Jones | 46075 | 85 | 0 | 0 | 85 | 43.96278565 | -100.6940008 | 2021-02-25 05:24:57 | Jones, South Dakota, US |
1939906 | 1939906 | 2021-02-23 | US | Washington | Wahkiakum | 53069 | 85 | 0 | 0 | 85 | 46.29180039999999 | -123.4250831 | 2021-02-24 05:29:16 | Wahkiakum, Washington, US |
1939324 | 1939324 | 2021-02-23 | US | South Dakota | Jones | 46075 | 85 | 0 | 0 | 85 | 43.96278565 | -100.6940008 | 2021-02-24 05:29:16 | Jones, South Dakota, US |
534161 | 534161 | 2021-02-22 | US | Washington | Wahkiakum | 53069 | 85 | 0 | 0 | 85 | 46.29180039999999 | -123.4250831 | 2021-02-23 05:23:41 | Wahkiakum, Washington, US |
533579 | 533579 | 2021-02-22 | US | South Dakota | Jones | 46075 | 85 | 0 | 0 | 85 | 43.96278565 | -100.6940008 | 2021-02-23 05:23:41 | Jones, South Dakota, US |
530768 | 530768 | 2021-02-22 | Liechtenstein | 2624 | 55 | 2484 | 85 | 47.14 | 9.55 | 2021-02-23 05:23:41 | Liechtenstein | |||
530474 | 530474 | 2021-02-22 | Canada | New Brunswick | 1424 | 26 | 1313 | 85 | 46.5653 | -66.4619 | 2021-02-23 05:23:41 | New Brunswick, Canada | ||
184913 | 184913 | 2021-02-21 | US | South Dakota | Jones | 46075 | 85 | 0 | 0 | 85 | 43.96278565 | -100.6940008 | 2021-02-22 05:24:21 | Jones, South Dakota, US |
742268 | 742268 | 2021-02-20 | India | Lakshadweep | 277 | 0 | 192 | 85 | 13.6999972 | 72.18333259999999 | 2021-02-21 05:24:33 | Lakshadweep, India | ||
742137 | 742137 | 2021-02-20 | China | Shanghai | 1781 | 7 | 1689 | 85 | 31.202 | 121.4491 | 2021-02-21 05:24:33 | Shanghai, China | ||
471369 | 471369 | 2021-02-19 | India | Manipur | 29230 | 373 | 28772 | 85 | 24.738975 | 93.882541 | 2021-02-20 05:22:51 | Manipur, India | ||
471235 | 471235 | 2021-02-19 | China | Shanghai | 1778 | 7 | 1686 | 85 | 31.202 | 121.4491 | 2021-02-20 05:22:51 | Shanghai, China | ||
1153147 | 1153147 | 2021-02-18 | Japan | Nagasaki | 1590 | 36 | 1469 | 85 | 33.235712 | 129.608033 | 2021-02-19 05:24:16 | Nagasaki, Japan | ||
2283471 | 2283471 | 2021-02-14 | Japan | Wakayama | 1147 | 16 | 1046 | 85 | 33.911879 | 135.505446 | 2021-02-15 05:24:49 | Wakayama, Japan | ||
613645 | 613645 | 2021-02-08 | India | Manipur | 29130 | 373 | 28672 | 85 | 24.738975 | 93.882541 | 2021-02-09 05:23:30 | Manipur, India | ||
974878 | 974878 | 2021-02-06 | India | Nagaland | 12148 | 88 | 11975 | 85 | 26.06702 | 94.470302 | 2021-02-07 05:23:00 | Nagaland, India | ||
1591522 | 1591522 | 2021-02-05 | US | Virginia | Highland | 51091 | 85 | 0 | 0 | 85 | 38.35799465 | -79.56124594 | 2021-02-06 05:23:55 | Highland, Virginia, US |
1684466 | 1684466 | 2021-02-02 | India | Sikkim | 6096 | 135 | 5876 | 85 | 27.571671 | 88.472712 | 2021-02-03 05:22:52 | Sikkim, India | ||
1679747 | 1679747 | 2021-02-01 | US | Vermont | Grand Isle | 50013 | 85 | 0 | 0 | 85 | 44.7975824 | -73.29679772 | 2021-02-02 05:22:49 | Grand Isle, Vermont, US |
1676485 | 1676485 | 2021-02-01 | Japan | Ishikawa | 1466 | 58 | 1323 | 85 | 36.769464 | 136.771027 | 2021-02-02 05:22:49 | Ishikawa, Japan | ||
1463035 | 1463035 | 2021-01-31 | US | Vermont | Grand Isle | 50013 | 85 | 0 | 0 | 85 | 44.7975824 | -73.29679772 | 2021-02-01 05:22:53 | Grand Isle, Vermont, US |
1460378 | 1460378 | 2021-01-31 | US | Colorado | Kiowa | 8061 | 92 | 3 | 0 | 85 | 38.43260896 | -102.7392145 | 2021-02-01 05:22:53 | Kiowa, Colorado, US |
2214943 | 2214943 | 2021-01-30 | US | Vermont | Grand Isle | 50013 | 85 | 0 | 0 | 85 | 44.7975824 | -73.29679772 | 2021-01-31 05:22:42 | Grand Isle, Vermont, US |
2212286 | 2212286 | 2021-01-30 | US | Colorado | Kiowa | 8061 | 92 | 3 | 0 | 85 | 38.43260896 | -102.7392145 | 2021-01-31 05:22:42 | Kiowa, Colorado, US |
1900430 | 1900430 | 2021-01-29 | US | Vermont | Grand Isle | 50013 | 85 | 0 | 0 | 85 | 44.7975824 | -73.29679772 | 2021-01-30 05:22:49 | Grand Isle, Vermont, US |
1897773 | 1897773 | 2021-01-29 | US | Colorado | Kiowa | 8061 | 92 | 3 | 0 | 85 | 38.43260896 | -102.7392145 | 2021-01-30 05:22:49 | Kiowa, Colorado, US |
2485246 | 2485246 | 2021-01-28 | US | Vermont | Grand Isle | 50013 | 85 | 0 | 0 | 85 | 44.7975824 | -73.29679772 | 2021-01-29 05:22:23 | Grand Isle, Vermont, US |
2482589 | 2482589 | 2021-01-28 | US | Colorado | Kiowa | 8061 | 92 | 3 | 0 | 85 | 38.43260896 | -102.7392145 | 2021-01-29 05:22:23 | Kiowa, Colorado, US |
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]);