johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
930 rows where active = 192 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 834
- Japan 20
- Russia 9
- Chile 5
- China 5
- India 5
- Ukraine 5
- San Marino 4
- Colombia 3
- Italy 3
- France 2
- Germany 2
- Malaysia 2
- Mauritania 2
- Niger 2
- Armenia 1
- Barbados 1
- Brazil 1
- Burkina Faso 1
- Cabo Verde 1
- Canada 1
- Congo (Brazzaville) 1
- Cote d'Ivoire 1
- Djibouti 1
- Eritrea 1
- Estonia 1
- Guinea-Bissau 1
- Jordan 1
- Latvia 1
- Malta 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3468097 | 3468097 | 2021-08-03 | Germany | Sachsen-Anhalt | 99569 | 3454 | 95990 | 192 | 51.9503 | 11.6923 | 2021-08-04 04:21:25 | Sachsen-Anhalt, Germany | ||
3299865 | 3299865 | 2021-07-30 | Malaysia | W.P. Labuan | 9651 | 146 | 9313 | 192 | 5.2831 | 115.2308 | 2021-07-31 04:21:35 | W.P. Labuan, Malaysia | ||
1333889 | 1333889 | 2021-07-24 | Ukraine | Vinnytsia Oblast | 71355 | 1699 | 69464 | 192 | 49.2331 | 28.4682 | 2021-07-25 04:22:12 | Vinnytsia Oblast, Ukraine | ||
1444216 | 1444216 | 2021-07-07 | Ukraine | Luhansk Oblast | 26677 | 951 | 25534 | 192 | 48.574 | 39.3078 | 2021-07-08 04:21:26 | Luhansk Oblast, Ukraine | ||
1440503 | 1440503 | 2021-07-07 | Germany | Sachsen-Anhalt | 99255 | 3428 | 95690 | 192 | 51.9503 | 11.6923 | 2021-07-08 04:21:26 | Sachsen-Anhalt, Germany | ||
2764916 | 2764916 | 2021-07-01 | Italy | Friuli Venezia Giulia | 106957 | 3789 | 102976 | 192 | 45.6494354 | 13.76813649 | 2021-07-02 04:21:47 | Friuli Venezia Giulia, Italy | ||
1893124 | 1893124 | 2021-06-30 | Italy | Friuli Venezia Giulia | 106942 | 3789 | 102961 | 192 | 45.6494354 | 13.76813649 | 2021-07-01 04:21:19 | Friuli Venezia Giulia, Italy | ||
1736556 | 1736556 | 2021-06-12 | Japan | Yamaguchi | 3065 | 69 | 2804 | 192 | 34.201190000000004 | 131.573293 | 2021-06-13 04:22:44 | Yamaguchi, Japan | ||
523063 | 523063 | 2021-06-09 | Russia | Karachay-Cherkess Republic | 20559 | 153 | 20214 | 192 | 43.7368326 | 41.7267991 | 2021-06-10 04:23:17 | Karachay-Cherkess Republic, Russia | ||
825626 | 825626 | 2021-06-06 | Japan | Toyama | 1922 | 36 | 1694 | 192 | 36.637464 | 137.26934599999998 | 2021-06-07 04:22:51 | Toyama, Japan | ||
1708240 | 1708240 | 2021-06-02 | Guinea-Bissau | 3783 | 68 | 3523 | 192 | 11.8037 | -15.1804 | 2021-06-03 04:23:32 | Guinea-Bissau | |||
1189013 | 1189013 | 2021-05-31 | Saint Vincent and the Grenadines | 2035 | 12 | 1831 | 192 | 12.9843 | -61.2872 | 2021-06-01 04:23:09 | Saint Vincent and the Grenadines | |||
1310441 | 1310441 | 2021-05-26 | Senegal | 41181 | 1135 | 39854 | 192 | 14.4974 | -14.4524 | 2021-05-27 04:20:59 | Senegal | |||
1913098 | 1913098 | 2021-05-20 | Eritrea | 3906 | 14 | 3700 | 192 | 15.1794 | 39.7823 | 2021-05-21 04:20:43 | Eritrea | |||
2939366 | 2939366 | 2021-05-16 | Japan | Tokushima | 1571 | 56 | 1323 | 192 | 33.919178 | 134.242091 | 2021-05-17 04:20:34 | Tokushima, Japan | ||
2004731 | 2004731 | 2021-05-12 | Malta | 30469 | 417 | 29860 | 192 | 35.9375 | 14.3754 | 2021-05-13 04:20:51 | Malta | |||
3954697 | 3954697 | 2021-05-11 | Russia | Karachay-Cherkess Republic | 20198 | 85 | 19921 | 192 | 43.7368326 | 41.7267991 | 2021-05-12 04:21:29 | Karachay-Cherkess Republic, Russia | ||
3393586 | 3393586 | 2021-04-28 | Russia | Chechen Republic | 11976 | 122 | 11662 | 192 | 43.39761470000001 | 45.6985005 | 2021-04-29 04:20:55 | Chechen Republic, Russia | ||
3923797 | 3923797 | 2021-04-24 | Chile | Aysen | 4107 | 30 | 3885 | 192 | -45.9864 | -73.7669 | 2021-04-25 04:20:32 | Aysen, Chile | ||
1568132 | 1568132 | 2021-04-22 | Japan | Nagasaki | 1852 | 40 | 1620 | 192 | 33.235712 | 129.608033 | 2021-04-23 04:20:52 | Nagasaki, Japan | ||
2020762 | 2020762 | 2021-04-20 | Japan | Tochigi | 5103 | 70 | 4841 | 192 | 36.689912 | 139.819213 | 2021-04-21 04:21:14 | Tochigi, Japan | ||
2020725 | 2020725 | 2021-04-20 | Japan | Aomori | 1336 | 20 | 1124 | 192 | 40.781541 | 140.828896 | 2021-04-21 04:21:14 | Aomori, Japan | ||
3129593 | 3129593 | 2021-04-18 | Mauritania | 18129 | 453 | 17484 | 192 | 21.0079 | -10.9408 | 2021-04-19 04:20:57 | Mauritania | |||
982951 | 982951 | 2021-04-17 | Japan | Aomori | 1299 | 20 | 1087 | 192 | 40.781541 | 140.828896 | 2021-04-18 04:20:41 | Aomori, Japan | ||
1798648 | 1798648 | 2021-03-23 | Japan | Gunma | 4849 | 98 | 4559 | 192 | 36.504479 | 138.985605 | 2021-03-24 05:25:40 | Gunma, Japan | ||
1744578 | 1744578 | 2021-03-20 | Japan | Tochigi | 4419 | 70 | 4157 | 192 | 36.689912 | 139.819213 | 2021-03-21 05:25:44 | Tochigi, Japan | ||
1744247 | 1744247 | 2021-03-20 | Barbados | 3533 | 39 | 3302 | 192 | 13.1939 | -59.5432 | 2021-03-21 05:25:44 | Barbados | |||
3452992 | 3452992 | 2021-03-18 | Niger | 4906 | 185 | 4529 | 192 | 17.607789 | 8.081666 | 2021-03-19 05:26:09 | Niger | |||
3452895 | 3452895 | 2021-03-18 | Japan | Shizuoka | 5450 | 108 | 5150 | 192 | 34.916975 | 138.40778400000002 | 2021-03-19 05:26:09 | Shizuoka, Japan | ||
3962655 | 3962655 | 2021-03-10 | Niger | 4848 | 179 | 4477 | 192 | 17.607789 | 8.081666 | 2021-03-11 05:25:48 | Niger | |||
3663833 | 3663833 | 2021-03-09 | Russia | Murmansk Oblast | 47440 | 988 | 46260 | 192 | 68.00004179999999 | 33.9999151 | 2021-03-10 05:24:35 | Murmansk Oblast, Russia | ||
2207726 | 2207726 | 2021-03-04 | Mauritania | 17267 | 442 | 16633 | 192 | 21.0079 | -10.9408 | 2021-03-05 05:26:29 | Mauritania | |||
2368786 | 2368786 | 2021-02-28 | US | Kansas | Hodgeman | 20083 | 199 | 7 | 0 | 192 | 38.08780079 | -99.89829881 | 2021-03-01 05:23:01 | Hodgeman, Kansas, US |
2367717 | 2367717 | 2021-02-28 | Russia | Magadan Oblast | 8138 | 95 | 7851 | 192 | 62.48858785 | 153.9903764 | 2021-03-01 05:23:01 | Magadan Oblast, Russia | ||
3067288 | 3067288 | 2021-02-27 | US | Kansas | Hodgeman | 20083 | 199 | 7 | 0 | 192 | 38.08780079 | -99.89829881 | 2021-02-28 05:22:20 | Hodgeman, Kansas, US |
2184872 | 2184872 | 2021-02-26 | US | Kansas | Hodgeman | 20083 | 199 | 7 | 0 | 192 | 38.08780079 | -99.89829881 | 2021-02-27 05:22:28 | Hodgeman, Kansas, US |
1937804 | 1937804 | 2021-02-23 | US | Kansas | Woodson | 20207 | 196 | 4 | 0 | 192 | 37.8865336 | -95.74006277 | 2021-02-24 05:29:16 | Woodson, Kansas, US |
532059 | 532059 | 2021-02-22 | US | Kansas | Woodson | 20207 | 196 | 4 | 0 | 192 | 37.8865336 | -95.74006277 | 2021-02-23 05:23:41 | Woodson, Kansas, US |
183332 | 183332 | 2021-02-21 | US | Kansas | Jewell | 20089 | 196 | 4 | 0 | 192 | 39.78470589 | -98.21820662 | 2021-02-22 05:24:21 | Jewell, Kansas, US |
182002 | 182002 | 2021-02-21 | India | Puducherry | 39592 | 663 | 38737 | 192 | 11.882658 | 78.86498 | 2021-02-22 05:24:21 | Puducherry, India | ||
743606 | 743606 | 2021-02-20 | US | Kansas | Jewell | 20089 | 196 | 4 | 0 | 192 | 39.78470589 | -98.21820662 | 2021-02-21 05:24:33 | Jewell, Kansas, US |
742353 | 742353 | 2021-02-20 | Japan | Tochigi | 4028 | 64 | 3772 | 192 | 36.689912 | 139.819213 | 2021-02-21 05:24:33 | Tochigi, Japan | ||
472704 | 472704 | 2021-02-19 | US | Kansas | Jewell | 20089 | 196 | 4 | 0 | 192 | 39.78470589 | -98.21820662 | 2021-02-20 05:22:51 | Jewell, Kansas, US |
3603751 | 3603751 | 2021-02-17 | US | Puerto Rico | Arroyo | 72015 | 192 | 0 | 0 | 192 | 17.998457000000005 | -66.056546 | 2021-02-18 05:22:58 | Arroyo, Puerto Rico, US |
3052886 | 3052886 | 2021-02-16 | US | Puerto Rico | Arroyo | 72015 | 192 | 0 | 0 | 192 | 17.998457000000005 | -66.056546 | 2021-02-17 05:23:10 | Arroyo, Puerto Rico, US |
1339192 | 1339192 | 2021-02-15 | US | Idaho | Butte | 16023 | 193 | 1 | 0 | 192 | 43.72592209 | -113.1735463 | 2021-02-16 05:24:38 | Butte, Idaho, US |
2284343 | 2284343 | 2021-02-14 | US | Idaho | Butte | 16023 | 193 | 1 | 0 | 192 | 43.72592209 | -113.1735463 | 2021-02-15 05:24:49 | Butte, Idaho, US |
2678743 | 2678743 | 2021-02-13 | US | Idaho | Butte | 16023 | 193 | 1 | 0 | 192 | 43.72592209 | -113.1735463 | 2021-02-14 05:23:43 | Butte, Idaho, US |
3540376 | 3540376 | 2021-02-12 | US | Idaho | Butte | 16023 | 193 | 1 | 0 | 192 | 43.72592209 | -113.1735463 | 2021-02-13 05:22:12 | Butte, Idaho, US |
2638639 | 2638639 | 2021-02-11 | US | Idaho | Butte | 16023 | 193 | 1 | 0 | 192 | 43.72592209 | -113.1735463 | 2021-02-12 05:23:29 | Butte, Idaho, US |
3978853 | 3978853 | 2021-02-10 | Singapore | 59747 | 29 | 59526 | 192 | 1.2833 | 103.8333 | 2021-02-11 05:23:55 | Singapore | |||
1672265 | 1672265 | 2021-02-07 | China | Hebei | 1316 | 7 | 1117 | 192 | 37.8957 | 114.9042 | 2021-02-08 05:22:39 | Hebei, China | ||
977015 | 977015 | 2021-02-06 | US | Nebraska | Pawnee | 31133 | 193 | 1 | 0 | 192 | 40.13141096 | -96.23705437 | 2021-02-07 05:23:00 | Pawnee, Nebraska, US |
974726 | 974726 | 2021-02-06 | China | Hebei | 1316 | 7 | 1117 | 192 | 37.8957 | 114.9042 | 2021-02-07 05:23:00 | Hebei, China | ||
1590273 | 1590273 | 2021-02-05 | US | Nebraska | Pawnee | 31133 | 193 | 1 | 0 | 192 | 40.13141096 | -96.23705437 | 2021-02-06 05:23:55 | Pawnee, Nebraska, US |
1587984 | 1587984 | 2021-02-05 | China | Hebei | 1316 | 7 | 1117 | 192 | 37.8957 | 114.9042 | 2021-02-06 05:23:55 | Hebei, China | ||
794050 | 794050 | 2021-02-04 | US | Alaska | Copper River | 2066 | 192 | 0 | 0 | 192 | 60.3886 | -162.8905196 | 2021-04-02 15:13:53 | Copper River, Alaska, US |
790191 | 790191 | 2021-02-04 | China | Hebei | 1316 | 7 | 1117 | 192 | 37.8957 | 114.9042 | 2021-02-05 05:22:38 | Hebei, China | ||
343942 | 343942 | 2021-02-03 | US | Alaska | Copper River | 2066 | 192 | 0 | 0 | 192 | 60.3886 | -162.8905196 | 2021-04-02 15:13:53 | Copper River, Alaska, US |
1687111 | 1687111 | 2021-02-02 | US | Oregon | Harney | 41025 | 198 | 6 | 0 | 192 | 43.06422669 | -118.9666306 | 2021-02-03 05:22:52 | Harney, Oregon, US |
2482604 | 2482604 | 2021-01-28 | US | Colorado | Ouray | 8091 | 220 | 3 | 0 | 192 | 38.14717457 | -107.7675136 | 2021-01-29 05:22:23 | Ouray, Colorado, US |
2482239 | 2482239 | 2021-01-28 | San Marino | 2941 | 65 | 2684 | 192 | 43.9424 | 12.4578 | 2021-01-29 05:22:23 | San Marino | |||
3155158 | 3155158 | 2021-01-27 | US | Maine | Piscataquis | 23021 | 193 | 1 | 0 | 192 | 45.83839062 | -69.2860223 | 2021-01-28 05:22:24 | Piscataquis, Maine, US |
2570871 | 2570871 | 2021-01-25 | US | Texas | Schleicher | 48413 | 145 | 6 | 0 | 192 | 30.89740592 | -100.5384842 | 2021-01-26 05:22:02 | Schleicher, Texas, US |
2426649 | 2426649 | 2021-01-23 | Brazil | Piaui | 155362 | 3004 | 151914 | 192 | -7.7183 | -42.7289 | 2021-01-24 05:22:35 | Piaui, Brazil | ||
435370 | 435370 | 2021-01-21 | Japan | Ishikawa | 1393 | 56 | 1145 | 192 | 36.769464 | 136.771027 | 2021-01-22 05:22:10 | Ishikawa, Japan | ||
1094104 | 1094104 | 2021-01-20 | Japan | Kagawa | 555 | 6 | 357 | 192 | 34.217292 | 133.969047 | 2021-01-21 05:22:01 | Kagawa, Japan | ||
908446 | 908446 | 2021-01-19 | San Marino | 2787 | 65 | 2530 | 192 | 43.9424 | 12.4578 | 2021-01-20 05:21:54 | San Marino | |||
907987 | 907987 | 2021-01-19 | China | Heilongjiang | 1159 | 13 | 954 | 192 | 47.862 | 127.7615 | 2021-01-20 05:21:54 | Heilongjiang, China | ||
238964 | 238964 | 2021-01-18 | US | Minnesota | Lake of the Woods | 27077 | 193 | 1 | 0 | 192 | 48.77217001 | -94.90274472 | 2021-01-19 05:22:15 | Lake of the Woods, Minnesota, US |
237349 | 237349 | 2021-01-18 | Monaco | 1212 | 7 | 1013 | 192 | 43.7333 | 7.4167 | 2021-01-19 05:22:15 | Monaco | |||
3104199 | 3104199 | 2021-01-16 | US | Puerto Rico | Patillas | 72109 | 192 | 0 | 0 | 192 | 18.03174 | -66.012242 | 2021-01-17 05:22:17 | Patillas, Puerto Rico, US |
2629222 | 2629222 | 2021-01-10 | US | Virginia | King and Queen | 51097 | 194 | 2 | 0 | 192 | 37.71044922 | -76.88689628 | 2021-01-11 05:21:50 | King and Queen, Virginia, US |
2627221 | 2627221 | 2021-01-10 | US | Kansas | Wichita | 20203 | 197 | 5 | 0 | 192 | 38.48178252 | -101.3471509 | 2021-01-11 05:21:50 | Wichita, Kansas, US |
2627167 | 2627167 | 2021-01-10 | US | Kansas | Kiowa | 20097 | 194 | 2 | 0 | 192 | 37.55848695 | -99.2856537 | 2021-01-11 05:21:50 | Kiowa, Kansas, US |
3901309 | 3901309 | 2021-01-09 | US | Kansas | Wichita | 20203 | 197 | 5 | 0 | 192 | 38.48178252 | -101.3471509 | 2021-01-10 05:22:12 | Wichita, Kansas, US |
3901255 | 3901255 | 2021-01-09 | US | Kansas | Kiowa | 20097 | 194 | 2 | 0 | 192 | 37.55848695 | -99.2856537 | 2021-01-10 05:22:12 | Kiowa, Kansas, US |
3899745 | 3899745 | 2021-01-09 | Chile | Atacama | 8774 | 115 | 8467 | 192 | -27.5661 | -70.0503 | 2021-01-10 05:22:12 | Atacama, Chile | ||
155332 | 155332 | 2021-01-08 | US | Kansas | Wichita | 20203 | 197 | 5 | 0 | 192 | 38.48178252 | -101.3471509 | 2021-01-09 05:22:18 | Wichita, Kansas, US |
155278 | 155278 | 2021-01-08 | US | Kansas | Kiowa | 20097 | 194 | 2 | 0 | 192 | 37.55848695 | -99.2856537 | 2021-01-09 05:22:18 | Kiowa, Kansas, US |
154748 | 154748 | 2021-01-08 | US | Georgia | Clay | 13061 | 195 | 3 | 0 | 192 | 31.62221166 | -84.97713865 | 2021-01-09 05:22:18 | Clay, Georgia, US |
3037596 | 3037596 | 2021-01-05 | US | Virginia | Bath | 51017 | 192 | 0 | 0 | 192 | 38.05852573 | -79.73912095 | 2021-01-06 05:22:16 | Bath, Virginia, US |
3233898 | 3233898 | 2021-01-03 | US | Washington | Skamania | 53059 | 193 | 1 | 0 | 192 | 46.02408726 | -121.9164403 | 2021-01-04 05:22:02 | Skamania, Washington, US |
2227282 | 2227282 | 2021-01-02 | Cabo Verde | 11883 | 113 | 11578 | 192 | 16.5388 | -23.0418 | 2021-01-03 05:22:52 | Cabo Verde | |||
1138529 | 1138529 | 2021-01-01 | US | Michigan | Luce | 26095 | 192 | 0 | 0 | 192 | 46.47227431 | -85.54471223 | 2021-01-02 05:22:33 | Luce, Michigan, US |
3697135 | 3697135 | 2020-12-31 | US | Michigan | Luce | 26095 | 192 | 0 | 0 | 192 | 46.47227431 | -85.54471223 | 2021-01-01 05:23:07 | Luce, Michigan, US |
1011950 | 1011950 | 2020-12-30 | US | Michigan | Luce | 26095 | 192 | 0 | 0 | 192 | 46.47227431 | -85.54471223 | 2020-12-31 05:22:49 | Luce, Michigan, US |
767965 | 767965 | 2020-12-29 | US | Michigan | Luce | 26095 | 192 | 0 | 0 | 192 | 46.47227431 | -85.54471223 | 2020-12-30 05:22:34 | Luce, Michigan, US |
205388 | 205388 | 2020-12-25 | US | Texas | Kimble | 48267 | 182 | 6 | 0 | 192 | 30.48678918 | -99.74856473 | 2020-12-26 05:22:28 | Kimble, Texas, US |
3694990 | 3694990 | 2020-12-24 | US | West Virginia | Wirt | 54105 | 193 | 1 | 0 | 192 | 39.02775007 | -81.37473928 | 2020-12-25 05:22:48 | Wirt, West Virginia, US |
2406799 | 2406799 | 2020-12-23 | India | Tripura | 33216 | 384 | 32640 | 192 | 23.746783 | 91.743565 | 2020-12-24 05:23:04 | Tripura, India | ||
3772971 | 3772971 | 2020-12-22 | US | Texas | Hall | 48191 | 303 | 5 | 0 | 192 | 34.5307555 | -100.6813852 | 2020-12-23 05:22:03 | Hall, Texas, US |
3772923 | 3772923 | 2020-12-22 | US | Texas | Concho | 48095 | 246 | 3 | 0 | 192 | 31.32635934 | -99.86473038 | 2020-12-23 05:22:03 | Concho, Texas, US |
930735 | 930735 | 2020-12-21 | US | Texas | Collingsworth | 48087 | 234 | 5 | 0 | 192 | 34.96489496 | -100.2700111 | 2020-12-22 05:22:33 | Collingsworth, Texas, US |
930066 | 930066 | 2020-12-21 | US | North Dakota | Adams | 38001 | 189 | 2 | 0 | 192 | 46.09686891 | -102.5285397 | 2020-12-22 05:22:33 | Adams, North Dakota, US |
2122756 | 2122756 | 2020-12-20 | US | Texas | Collingsworth | 48087 | 230 | 5 | 0 | 192 | 34.96489496 | -100.2700111 | 2020-12-21 05:27:58 | Collingsworth, Texas, US |
2122087 | 2122087 | 2020-12-20 | US | North Dakota | Adams | 38001 | 189 | 2 | 0 | 192 | 46.09686891 | -102.5285397 | 2020-12-21 05:27:58 | Adams, North Dakota, US |
2120698 | 2120698 | 2020-12-20 | US | Illinois | Hardin | 17069 | 197 | 5 | 0 | 192 | 37.51810645 | -88.26873022 | 2020-12-21 05:27:58 | Hardin, Illinois, US |
2120263 | 2120263 | 2020-12-20 | US | California | Mariposa | 6043 | 196 | 4 | 0 | 192 | 37.57978556 | -119.9073334 | 2020-12-21 05:27:58 | Mariposa, California, US |
2934315 | 2934315 | 2020-12-19 | US | Texas | Hall | 48191 | 290 | 4 | 0 | 192 | 34.5307555 | -100.6813852 | 2020-12-20 05:27:32 | Hall, Texas, 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]);