johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
633 rows where active = 316 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 538
- Russia 11
- Japan 10
- France 7
- Germany 7
- Mexico 6
- Chile 5
- Colombia 5
- Belize 4
- Seychelles 4
- Malaysia 3
- China 2
- Congo (Brazzaville) 2
- Cyprus 2
- India 2
- Kyrgyzstan 2
- Latvia 2
- Pakistan 2
- Togo 2
- United Kingdom 2
- Antigua and Barbuda 1
- Burkina Faso 1
- Cabo Verde 1
- Canada 1
- Cote d'Ivoire 1
- Georgia 1
- Guyana 1
- Lithuania 1
- Mauritania 1
- San Marino 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3468095 | 3468095 | 2021-08-03 | Germany | Saarland | 42153 | 1029 | 40890 | 316 | 49.3964 | 7.023 | 2021-08-04 04:21:25 | Saarland, Germany | ||
3296088 | 3296088 | 2021-07-30 | Germany | Brandenburg | 109196 | 3817 | 105100 | 316 | 52.4125 | 12.5316 | 2021-07-31 04:21:35 | Brandenburg, Germany | ||
411934 | 411934 | 2021-07-28 | Ukraine | Sumy Oblast | 78389 | 1343 | 76730 | 316 | 50.9077 | 34.7981 | 2021-07-29 04:21:33 | Sumy Oblast, Ukraine | ||
3476105 | 3476105 | 2021-07-22 | Chile | OHiggins | 67043 | 1443 | 65284 | 316 | -34.5755 | -71.0022 | 2021-07-23 04:21:29 | OHiggins, Chile | ||
2673535 | 2673535 | 2021-07-18 | Belize | 13683 | 332 | 13035 | 316 | 17.1899 | -88.4976 | 2021-07-19 04:21:24 | Belize | |||
3705847 | 3705847 | 2021-07-17 | Belize | 13683 | 332 | 13035 | 316 | 17.1899 | -88.4976 | 2021-07-18 04:22:07 | Belize | |||
2947078 | 2947078 | 2021-07-16 | Belize | 13683 | 332 | 13035 | 316 | 17.1899 | -88.4976 | 2021-07-17 04:22:22 | Belize | |||
2693410 | 2693410 | 2021-07-06 | Belize | 13409 | 330 | 12763 | 316 | 17.1899 | -88.4976 | 2021-07-07 04:21:20 | Belize | |||
1932347 | 1932347 | 2021-07-05 | Germany | Brandenburg | 108718 | 3807 | 104600 | 316 | 52.4125 | 12.5316 | 2021-07-06 04:21:32 | Brandenburg, Germany | ||
3030320 | 3030320 | 2021-06-16 | Japan | Okayama | 7564 | 123 | 7125 | 316 | 34.89246 | 133.826252 | 2021-06-17 04:22:36 | Okayama, Japan | ||
1564003 | 1564003 | 2021-06-14 | Germany | Bremen | 27345 | 478 | 26550 | 316 | 53.0793 | 8.8017 | 2021-06-15 04:22:22 | Bremen, Germany | ||
2315484 | 2315484 | 2021-06-04 | Russia | Adygea Republic | 14706 | 207 | 14183 | 316 | 44.6939006 | 40.1520421 | 2021-06-05 04:23:03 | Adygea Republic, Russia | ||
2315157 | 2315157 | 2021-06-04 | Colombia | Putumayo | 12217 | 507 | 11394 | 316 | 0.436 | -75.5277 | 2021-06-05 04:23:03 | Putumayo, Colombia | ||
1448769 | 1448769 | 2021-06-03 | Russia | Adygea Republic | 14697 | 205 | 14176 | 316 | 44.6939006 | 40.1520421 | 2021-06-04 04:23:37 | Adygea Republic, Russia | ||
2939328 | 2939328 | 2021-05-16 | Japan | Aomori | 1952 | 27 | 1609 | 316 | 40.781541 | 140.828896 | 2021-05-17 04:20:34 | Aomori, Japan | ||
3054393 | 3054393 | 2021-05-13 | Russia | Kalmykia Republic | 20588 | 359 | 19913 | 316 | 46.2313018 | 45.3275745 | 2021-05-14 04:20:41 | Kalmykia Republic, Russia | ||
2004863 | 2004863 | 2021-05-12 | Russia | Kalmykia Republic | 20573 | 358 | 19899 | 316 | 46.2313018 | 45.3275745 | 2021-05-13 04:20:51 | Kalmykia Republic, Russia | ||
2820773 | 2820773 | 2021-05-10 | Japan | Aomori | 1813 | 26 | 1471 | 316 | 40.781541 | 140.828896 | 2021-05-11 04:20:41 | Aomori, Japan | ||
1425324 | 1425324 | 2021-05-09 | Russia | Mari El Republic | 13191 | 233 | 12642 | 316 | 56.5767504 | 47.8817512 | 2021-05-10 04:20:38 | Mari El Republic, Russia | ||
2450981 | 2450981 | 2021-05-02 | Russia | Khakassia Republic | 22396 | 526 | 21554 | 316 | 53.72258845 | 91.44293627 | 2021-05-03 04:20:39 | Khakassia Republic, Russia | ||
2824686 | 2824686 | 2021-05-01 | France | St Martin | 1728 | 13 | 1399 | 316 | 18.0708 | -63.0501 | 2021-05-02 04:20:48 | St Martin, France | ||
380094 | 380094 | 2021-04-30 | France | St Martin | 1728 | 13 | 1399 | 316 | 18.0708 | -63.0501 | 2021-05-01 04:20:47 | St Martin, France | ||
1636217 | 1636217 | 2021-04-29 | France | St Martin | 1728 | 13 | 1399 | 316 | 18.0708 | -63.0501 | 2021-04-30 04:21:03 | St Martin, France | ||
3393296 | 3393296 | 2021-04-28 | France | St Martin | 1728 | 13 | 1399 | 316 | 18.0708 | -63.0501 | 2021-04-29 04:20:55 | St Martin, France | ||
3702012 | 3702012 | 2021-04-27 | France | St Martin | 1728 | 13 | 1399 | 316 | 18.0708 | -63.0501 | 2021-04-28 04:20:32 | St Martin, France | ||
888021 | 888021 | 2021-04-26 | France | St Martin | 1728 | 13 | 1399 | 316 | 18.0708 | -63.0501 | 2021-04-27 04:20:52 | St Martin, France | ||
955139 | 955139 | 2021-04-25 | Seychelles | 5016 | 25 | 4675 | 316 | -4.6796 | 55.492 | 2021-04-26 04:21:04 | Seychelles | |||
954766 | 954766 | 2021-04-25 | France | St Martin | 1728 | 13 | 1399 | 316 | 18.0708 | -63.0501 | 2021-04-26 04:21:04 | St Martin, France | ||
3924286 | 3924286 | 2021-04-24 | Seychelles | 5016 | 25 | 4675 | 316 | -4.6796 | 55.492 | 2021-04-25 04:20:32 | Seychelles | |||
1409317 | 1409317 | 2021-04-23 | Seychelles | 5016 | 25 | 4675 | 316 | -4.6796 | 55.492 | 2021-04-24 04:20:38 | Seychelles | |||
1568380 | 1568380 | 2021-04-22 | Seychelles | 5016 | 25 | 4675 | 316 | -4.6796 | 55.492 | 2021-04-23 04:20:52 | Seychelles | |||
2410884 | 2410884 | 2021-04-19 | Japan | Tokushima | 939 | 27 | 596 | 316 | 33.919178 | 134.242091 | 2021-04-20 04:20:41 | Tokushima, Japan | ||
3129797 | 3129797 | 2021-04-18 | Singapore | 60831 | 30 | 60485 | 316 | 1.2833 | 103.8333 | 2021-04-19 04:20:57 | Singapore | |||
2571707 | 2571707 | 2021-04-13 | Japan | Niigata | 1769 | 18 | 1435 | 316 | 37.521819 | 138.918647 | 2021-04-14 04:20:41 | Niigata, Japan | ||
1535620 | 1535620 | 2021-03-28 | Antigua and Barbuda | 1128 | 28 | 784 | 316 | 17.0608 | -61.7964 | 2021-03-29 04:28:35 | Antigua and Barbuda | |||
1579962 | 1579962 | 2021-03-13 | China | Hong Kong | 11257 | 203 | 10738 | 316 | 22.3 | 114.2 | 2021-03-14 05:25:37 | Hong Kong, China | ||
352601 | 352601 | 2021-03-11 | Suriname | 8997 | 176 | 8505 | 316 | 3.9193 | -56.0278 | 2021-03-12 05:26:50 | Suriname | |||
3962310 | 3962310 | 2021-03-10 | Chile | Magallanes | 22320 | 327 | 21677 | 316 | -52.368 | -70.9863 | 2021-03-11 05:25:48 | Magallanes, Chile | ||
3663457 | 3663457 | 2021-03-09 | Colombia | Huila | 50078 | 1746 | 48016 | 316 | 2.5359 | -75.5277 | 2021-03-10 05:24:35 | Huila, Colombia | ||
3670022 | 3670022 | 2021-03-06 | US | North Dakota | McIntosh | 38051 | 323 | 7 | 0 | 316 | 46.11182017 | -99.44145858 | 2021-03-07 05:21:54 | McIntosh, North Dakota, US |
3670017 | 3670017 | 2021-03-06 | US | North Dakota | Hettinger | 38041 | 319 | 4 | 0 | 316 | 46.43375068 | -102.4632417 | 2021-03-07 05:21:54 | Hettinger, North Dakota, US |
1618643 | 1618643 | 2021-03-05 | US | North Dakota | McIntosh | 38051 | 323 | 7 | 0 | 316 | 46.11182017 | -99.44145858 | 2021-03-06 04:23:41 | McIntosh, North Dakota, US |
1618638 | 1618638 | 2021-03-05 | US | North Dakota | Hettinger | 38041 | 319 | 4 | 0 | 316 | 46.43375068 | -102.4632417 | 2021-03-06 04:23:41 | Hettinger, North Dakota, US |
2210054 | 2210054 | 2021-03-04 | US | North Dakota | McIntosh | 38051 | 323 | 7 | 0 | 316 | 46.11182017 | -99.44145858 | 2021-03-05 05:26:29 | McIntosh, North Dakota, US |
3257026 | 3257026 | 2021-03-02 | US | South Dakota | Marshall | 46091 | 321 | 5 | 0 | 316 | 45.75870838 | -97.59855639 | 2021-03-03 05:23:28 | Marshall, South Dakota, US |
999299 | 999299 | 2021-03-01 | US | Georgia | Schley | 13249 | 319 | 3 | 0 | 316 | 32.2654021 | -84.31258912 | 2021-03-02 05:23:30 | Schley, Georgia, US |
999083 | 999083 | 2021-03-01 | US | Colorado | Saguache | 8109 | 329 | 4 | 0 | 316 | 38.08054629 | -106.282466 | 2021-03-02 05:23:30 | Saguache, Colorado, US |
998867 | 998867 | 2021-03-01 | US | Alaska | Sitka | 2220 | 316 | 0 | 0 | 316 | 57.24124555 | -135.3206587 | 2021-03-02 05:23:30 | Sitka, Alaska, US |
2368904 | 2368904 | 2021-02-28 | US | Kentucky | Hickman | 21105 | 323 | 7 | 0 | 316 | 36.67948079999999 | -88.97875928 | 2021-03-01 05:23:01 | Hickman, Kentucky, US |
3069510 | 3069510 | 2021-02-27 | US | West Virginia | Webster | 54101 | 319 | 3 | 0 | 316 | 38.49370949 | -80.4202023 | 2021-02-28 05:22:20 | Webster, West Virginia, US |
1860768 | 1860768 | 2021-02-25 | US | Puerto Rico | Rincon | 72117 | 316 | 0 | 0 | 316 | 18.335443 | -67.23174 | 2021-02-26 05:22:40 | Rincon, Puerto Rico, US |
282946 | 282946 | 2021-02-24 | US | Puerto Rico | Rincon | 72117 | 316 | 0 | 0 | 316 | 18.335443 | -67.23174 | 2021-02-25 05:24:57 | Rincon, Puerto Rico, US |
1939214 | 1939214 | 2021-02-23 | US | Puerto Rico | Rincon | 72117 | 316 | 0 | 0 | 316 | 18.335443 | -67.23174 | 2021-02-24 05:29:16 | Rincon, Puerto Rico, US |
533469 | 533469 | 2021-02-22 | US | Puerto Rico | Rincon | 72117 | 316 | 0 | 0 | 316 | 18.335443 | -67.23174 | 2021-02-23 05:23:41 | Rincon, Puerto Rico, US |
184803 | 184803 | 2021-02-21 | US | Puerto Rico | Rincon | 72117 | 316 | 0 | 0 | 316 | 18.335443 | -67.23174 | 2021-02-22 05:24:21 | Rincon, Puerto Rico, US |
745077 | 745077 | 2021-02-20 | US | Puerto Rico | Rincon | 72117 | 316 | 0 | 0 | 316 | 18.335443 | -67.23174 | 2021-02-21 05:24:33 | Rincon, Puerto Rico, US |
1153304 | 1153304 | 2021-02-18 | Russia | Altai Republic | 15992 | 143 | 15533 | 316 | 50.7114101 | 86.8572186 | 2021-02-19 05:24:16 | Altai Republic, Russia | ||
3050611 | 3050611 | 2021-02-16 | US | Alaska | Yukon-Koyukuk | 2290 | 320 | 4 | 0 | 316 | 65.50815459 | -151.3907387 | 2021-02-17 05:23:10 | Yukon-Koyukuk, Alaska, US |
1339182 | 1339182 | 2021-02-15 | US | Idaho | Adams | 16003 | 319 | 3 | 0 | 316 | 44.89333571 | -116.4545247 | 2021-02-16 05:24:38 | Adams, Idaho, US |
2284333 | 2284333 | 2021-02-14 | US | Idaho | Adams | 16003 | 319 | 3 | 0 | 316 | 44.89333571 | -116.4545247 | 2021-02-15 05:24:49 | Adams, Idaho, US |
2678733 | 2678733 | 2021-02-13 | US | Idaho | Adams | 16003 | 319 | 3 | 0 | 316 | 44.89333571 | -116.4545247 | 2021-02-14 05:23:43 | Adams, Idaho, US |
3979158 | 3979158 | 2021-02-10 | US | California | Trinity | 6105 | 335 | 3 | 0 | 316 | 40.64917670000001 | -123.114713 | 2021-02-11 05:23:55 | Trinity, California, US |
1530513 | 1530513 | 2021-02-09 | US | Oregon | Lake | 41037 | 322 | 6 | 0 | 316 | 42.79246693 | -120.3850163 | 2021-02-10 05:22:41 | Lake, Oregon, US |
613497 | 613497 | 2021-02-08 | China | Heilongjiang | 1609 | 13 | 1280 | 316 | 47.862 | 127.7615 | 2021-02-09 05:23:30 | Heilongjiang, China | ||
1591617 | 1591617 | 2021-02-05 | US | Washington | Lincoln | 53043 | 320 | 4 | 0 | 316 | 47.57705241 | -118.4194388 | 2021-02-06 05:23:55 | Lincoln, Washington, US |
1589161 | 1589161 | 2021-02-05 | US | Illinois | Hardin | 17069 | 326 | 10 | 0 | 316 | 37.51810645 | -88.26873022 | 2021-02-06 05:23:55 | Hardin, Illinois, US |
791020 | 791020 | 2021-02-04 | US | Colorado | Phillips | 8095 | 349 | 13 | 0 | 316 | 40.59414277 | -102.3577703 | 2021-02-05 05:22:38 | Phillips, Colorado, US |
343169 | 343169 | 2021-02-03 | US | South Dakota | Stanley | 46117 | 318 | 2 | 0 | 316 | 44.41381872 | -100.7349153 | 2021-02-04 05:22:26 | Stanley, South Dakota, US |
342463 | 342463 | 2021-02-03 | US | New Mexico | Hidalgo | 35023 | 325 | 9 | 0 | 316 | 31.91383467 | -108.7151824 | 2021-02-04 05:22:26 | Hidalgo, New Mexico, US |
1687566 | 1687566 | 2021-02-02 | US | Texas | Donley | 48129 | 420 | 12 | 0 | 316 | 34.96517499 | -100.8140093 | 2021-02-03 05:22:52 | Donley, Texas, US |
1679536 | 1679536 | 2021-02-01 | US | Texas | Donley | 48129 | 420 | 12 | 0 | 316 | 34.96517499 | -100.8140093 | 2021-02-02 05:22:49 | Donley, Texas, US |
1462824 | 1462824 | 2021-01-31 | US | Texas | Donley | 48129 | 420 | 12 | 0 | 316 | 34.96517499 | -100.8140093 | 2021-02-01 05:22:53 | Donley, Texas, US |
2214984 | 2214984 | 2021-01-30 | US | Virginia | Cumberland | 51049 | 320 | 4 | 0 | 316 | 37.51328851 | -78.24398086 | 2021-01-31 05:22:42 | Cumberland, Virginia, US |
2214732 | 2214732 | 2021-01-30 | US | Texas | Donley | 48129 | 420 | 12 | 0 | 316 | 34.96517499 | -100.8140093 | 2021-01-31 05:22:42 | Donley, Texas, US |
1900209 | 1900209 | 2021-01-29 | US | Texas | Culberson | 48109 | 297 | 7 | 0 | 316 | 31.44506775 | -104.5185739 | 2021-01-30 05:22:49 | Culberson, Texas, US |
2485242 | 2485242 | 2021-01-28 | US | Vermont | Caledonia | 50005 | 320 | 4 | 0 | 316 | 44.46548598 | -72.10314651 | 2021-01-29 05:22:23 | Caledonia, Vermont, US |
12347 | 12347 | 2021-01-26 | Japan | Fukushima | 1653 | 39 | 1298 | 316 | 37.378867 | 140.223295 | 2021-01-27 05:23:41 | Fukushima, Japan | ||
2570767 | 2570767 | 2021-01-25 | US | Texas | Hartley | 48205 | 483 | 2 | 0 | 316 | 35.84008013 | -102.6029022 | 2021-01-26 05:22:02 | Hartley, Texas, US |
2569412 | 2569412 | 2021-01-25 | US | Minnesota | Red Lake | 27125 | 320 | 4 | 0 | 316 | 47.87197525 | -96.09561104 | 2021-01-26 05:22:02 | Red Lake, Minnesota, US |
2568123 | 2568123 | 2021-01-25 | US | Arkansas | Calhoun | 5013 | 318 | 2 | 0 | 316 | 33.55598792 | -92.49974403 | 2021-01-26 05:22:02 | Calhoun, Arkansas, US |
1762399 | 1762399 | 2021-01-24 | US | Texas | Hartley | 48205 | 483 | 2 | 0 | 316 | 35.84008013 | -102.6029022 | 2021-01-25 05:22:16 | Hartley, Texas, US |
1762351 | 1762351 | 2021-01-24 | US | Texas | Culberson | 48109 | 294 | 4 | 0 | 316 | 31.44506775 | -104.5185739 | 2021-01-25 05:22:16 | Culberson, Texas, US |
1761044 | 1761044 | 2021-01-24 | US | Minnesota | Red Lake | 27125 | 320 | 4 | 0 | 316 | 47.87197525 | -96.09561104 | 2021-01-25 05:22:16 | Red Lake, Minnesota, US |
1759755 | 1759755 | 2021-01-24 | US | Arkansas | Calhoun | 5013 | 318 | 2 | 0 | 316 | 33.55598792 | -92.49974403 | 2021-01-25 05:22:16 | Calhoun, Arkansas, US |
2430006 | 2430006 | 2021-01-23 | US | Texas | Hartley | 48205 | 483 | 2 | 0 | 316 | 35.84008013 | -102.6029022 | 2021-01-24 05:22:35 | Hartley, Texas, US |
2429763 | 2429763 | 2021-01-23 | US | South Dakota | Faulk | 46049 | 329 | 13 | 0 | 316 | 45.07082625 | -99.14535601 | 2021-01-24 05:22:35 | Faulk, South Dakota, US |
2428651 | 2428651 | 2021-01-23 | US | Minnesota | Red Lake | 27125 | 320 | 4 | 0 | 316 | 47.87197525 | -96.09561104 | 2021-01-24 05:22:35 | Red Lake, Minnesota, US |
438459 | 438459 | 2021-01-21 | US | Texas | Hartley | 48205 | 483 | 2 | 0 | 316 | 35.84008013 | -102.6029022 | 2021-01-22 05:22:10 | Hartley, Texas, US |
438372 | 438372 | 2021-01-21 | US | Texas | Blanco | 48031 | 399 | 11 | 0 | 316 | 30.26640707 | -98.3999852 | 2021-01-22 05:22:10 | Blanco, Texas, US |
436265 | 436265 | 2021-01-21 | US | Idaho | Bear Lake | 16007 | 318 | 2 | 0 | 316 | 42.28269683 | -111.32892379999998 | 2021-01-22 05:22:10 | Bear Lake, Idaho, US |
1097190 | 1097190 | 2021-01-20 | US | Texas | Hartley | 48205 | 483 | 2 | 0 | 316 | 35.84008013 | -102.6029022 | 2021-01-21 05:22:01 | Hartley, Texas, US |
3506954 | 3506954 | 2021-01-17 | US | Wyoming | Hot Springs | 56017 | 318 | 2 | 0 | 316 | 43.71930657 | -108.4423174 | 2021-01-18 05:22:34 | Hot Springs, Wyoming, US |
3506636 | 3506636 | 2021-01-17 | US | Vermont | Orleans | 50019 | 321 | 5 | 0 | 316 | 44.82964024 | -72.24562697 | 2021-01-18 05:22:34 | Orleans, Vermont, US |
3504616 | 3504616 | 2021-01-17 | US | Kansas | Cheyenne | 20023 | 327 | 11 | 0 | 316 | 39.78580976 | -101.7318201 | 2021-01-18 05:22:34 | Cheyenne, Kansas, US |
3104719 | 3104719 | 2021-01-16 | US | Vermont | Orleans | 50019 | 321 | 5 | 0 | 316 | 44.82964024 | -72.24562697 | 2021-01-17 05:22:17 | Orleans, Vermont, US |
3104305 | 3104305 | 2021-01-16 | US | South Dakota | Hand | 46059 | 320 | 4 | 0 | 316 | 44.54708407 | -99.00386459 | 2021-01-17 05:22:17 | Hand, South Dakota, US |
3102699 | 3102699 | 2021-01-16 | US | Kansas | Cheyenne | 20023 | 327 | 11 | 0 | 316 | 39.78580976 | -101.7318201 | 2021-01-17 05:22:17 | Cheyenne, Kansas, US |
3101775 | 3101775 | 2021-01-16 | Trinidad and Tobago | 7370 | 131 | 6923 | 316 | 10.6918 | -61.2225 | 2021-01-17 05:22:17 | Trinidad and Tobago | |||
3518498 | 3518498 | 2021-01-15 | US | Texas | Hall | 48191 | 479 | 10 | 0 | 316 | 34.5307555 | -100.6813852 | 2021-01-16 05:22:40 | Hall, Texas, US |
3518267 | 3518267 | 2021-01-15 | US | South Dakota | Hand | 46059 | 320 | 4 | 0 | 316 | 44.54708407 | -99.00386459 | 2021-01-16 05:22:40 | Hand, South Dakota, 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]);