johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
658 rows where active = 283 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 28
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3217986 | 3217986 | 2021-07-26 | Albania | 132891 | 2456 | 130152 | 283 | 41.1533 | 20.1683 | 2021-07-27 04:21:18 | Albania | |||
1330091 | 1330091 | 2021-07-24 | Colombia | Choco | 15770 | 380 | 15107 | 283 | 5.2528 | -76.82600000000002 | 2021-07-25 04:22:12 | Choco, Colombia | ||
295702 | 295702 | 2021-07-15 | Andorra | 14239 | 127 | 13829 | 283 | 42.5063 | 1.5218 | 2021-07-16 04:21:22 | Andorra | |||
582478 | 582478 | 2021-07-13 | Ukraine | Zhytomyr Oblast | 88573 | 1795 | 86495 | 283 | 50.2547 | 28.6587 | 2021-07-14 04:21:35 | Zhytomyr Oblast, Ukraine | ||
2697334 | 2697334 | 2021-07-06 | Ukraine | Zhytomyr Oblast | 88504 | 1793 | 86428 | 283 | 50.2547 | 28.6587 | 2021-07-07 04:21:20 | Zhytomyr Oblast, Ukraine | ||
1893154 | 1893154 | 2021-06-30 | Japan | Ibaraki | 10544 | 164 | 10097 | 283 | 36.303588 | 140.319591 | 2021-07-01 04:21:19 | Ibaraki, Japan | ||
107499 | 107499 | 2021-06-19 | Japan | Yamanashi | 1962 | 20 | 1659 | 283 | 35.612364 | 138.61148899999998 | 2021-06-20 04:21:48 | Yamanashi, Japan | ||
2339599 | 2339599 | 2021-06-15 | Russia | Kalmykia Republic | 21086 | 392 | 20411 | 283 | 46.2313018 | 45.3275745 | 2021-06-16 04:22:32 | Kalmykia Republic, Russia | ||
2339230 | 2339230 | 2021-06-15 | Colombia | Arauca | 8858 | 265 | 8310 | 283 | 7.0762 | -70.7105 | 2021-06-16 04:22:32 | Arauca, Colombia | ||
1563926 | 1563926 | 2021-06-14 | Colombia | Arauca | 8858 | 265 | 8310 | 283 | 7.0762 | -70.7105 | 2021-06-15 04:22:22 | Arauca, Colombia | ||
1448922 | 1448922 | 2021-06-03 | Togo | 13513 | 125 | 13105 | 283 | 8.6195 | 0.8248 | 2021-06-04 04:23:37 | Togo | |||
1708145 | 1708145 | 2021-06-02 | Colombia | Arauca | 7975 | 236 | 7456 | 283 | 7.0762 | -70.7105 | 2021-06-03 04:23:32 | Arauca, Colombia | ||
1806603 | 1806603 | 2021-05-27 | Colombia | San Andres y Providencia | 5380 | 82 | 5015 | 283 | 12.5567 | -81.7185 | 2021-05-28 04:20:36 | San Andres y Providencia, Colombia | ||
82929 | 82929 | 2021-05-25 | Colombia | Arauca | 7394 | 217 | 6894 | 283 | 7.0762 | -70.7105 | 2021-05-26 04:20:35 | Arauca, Colombia | ||
1771377 | 1771377 | 2021-05-23 | Japan | Saga | 2411 | 18 | 2110 | 283 | 33.286977 | 130.115738 | 2021-05-24 04:20:53 | Saga, Japan | ||
1913082 | 1913082 | 2021-05-20 | Cote d'Ivoire | 46834 | 298 | 46253 | 283 | 7.54 | -5.5471 | 2021-05-21 04:20:43 | Cote d'Ivoire | |||
1551841 | 1551841 | 2021-05-08 | Cote d'Ivoire | 46385 | 291 | 45811 | 283 | 7.54 | -5.5471 | 2021-05-09 04:20:35 | Cote d'Ivoire | |||
954720 | 954720 | 2021-04-25 | Colombia | Putumayo | 9133 | 340 | 8510 | 283 | 0.436 | -75.5277 | 2021-04-26 04:21:04 | Putumayo, Colombia | ||
2571724 | 2571724 | 2021-04-13 | Japan | Wakayama | 1589 | 19 | 1287 | 283 | 33.911879 | 135.505446 | 2021-04-14 04:20:41 | Wakayama, Japan | ||
2983464 | 2983464 | 2021-04-10 | Russia | Kemerovo Oblast | 33788 | 632 | 32873 | 283 | 54.53357809999999 | 87.342861 | 2021-04-11 04:20:56 | Kemerovo Oblast, Russia | ||
605728 | 605728 | 2021-04-09 | Japan | Tochigi | 4891 | 70 | 4538 | 283 | 36.689912 | 139.819213 | 2021-04-10 04:20:59 | Tochigi, Japan | ||
1289796 | 1289796 | 2021-03-29 | Chile | Magallanes | 23051 | 344 | 22424 | 283 | -52.368 | -70.9863 | 2021-03-30 04:26:23 | Magallanes, Chile | ||
3453064 | 3453064 | 2021-03-18 | Russia | Kemerovo Oblast | 32644 | 591 | 31770 | 283 | 54.53357809999999 | 87.342861 | 2021-03-19 05:26:09 | Kemerovo Oblast, Russia | ||
3669852 | 3669852 | 2021-03-06 | US | New York | Hamilton | 36041 | 285 | 2 | 0 | 283 | 43.66146647 | -74.49721957 | 2021-03-07 05:21:54 | Hamilton, New York, US |
3668947 | 3668947 | 2021-03-06 | US | Kansas | Rawlins | 20153 | 291 | 8 | 0 | 283 | 39.78525843 | -101.0761617 | 2021-03-07 05:21:54 | Rawlins, Kansas, US |
1618473 | 1618473 | 2021-03-05 | US | New York | Hamilton | 36041 | 285 | 2 | 0 | 283 | 43.66146647 | -74.49721957 | 2021-03-06 04:23:41 | Hamilton, New York, US |
1617568 | 1617568 | 2021-03-05 | US | Kansas | Rawlins | 20153 | 291 | 8 | 0 | 283 | 39.78525843 | -101.0761617 | 2021-03-06 04:23:41 | Rawlins, Kansas, US |
2209884 | 2209884 | 2021-03-04 | US | New York | Hamilton | 36041 | 285 | 2 | 0 | 283 | 43.66146647 | -74.49721957 | 2021-03-05 05:26:29 | Hamilton, New York, US |
2207411 | 2207411 | 2021-03-04 | Burkina Faso | 12103 | 143 | 11677 | 283 | 12.2383 | -1.5616 | 2021-03-05 05:26:29 | Burkina Faso | |||
1092305 | 1092305 | 2021-03-03 | US | New York | Hamilton | 36041 | 285 | 2 | 0 | 283 | 43.66146647 | -74.49721957 | 2021-03-04 05:24:24 | Hamilton, New York, US |
3256377 | 3256377 | 2021-03-02 | US | New York | Hamilton | 36041 | 285 | 2 | 0 | 283 | 43.66146647 | -74.49721957 | 2021-03-03 05:23:28 | Hamilton, New York, US |
1002107 | 1002107 | 2021-03-01 | US | Alaska | Chugach | 2063 | 286 | 3 | 0 | 283 | 61.16666 | -149.9 | 2021-04-02 15:13:53 | Chugach, Alaska, US |
3065839 | 3065839 | 2021-02-27 | Colombia | Caqueta | 17018 | 632 | 16103 | 283 | 0.8699 | -73.8419 | 2021-02-28 05:22:20 | Caqueta, Colombia | ||
1939599 | 1939599 | 2021-02-23 | US | Texas | Lipscomb | 48295 | 345 | 11 | 0 | 283 | 36.27783108 | -100.2733151 | 2021-02-24 05:29:16 | Lipscomb, Texas, US |
1937067 | 1937067 | 2021-02-23 | US | Colorado | Huerfano | 8055 | 313 | 16 | 0 | 283 | 37.68473101 | -104.9612585 | 2021-02-24 05:29:16 | Huerfano, Colorado, US |
531322 | 531322 | 2021-02-22 | US | Colorado | Huerfano | 8055 | 311 | 16 | 0 | 283 | 37.68473101 | -104.9612585 | 2021-02-23 05:23:41 | Huerfano, Colorado, US |
530516 | 530516 | 2021-02-22 | China | Hong Kong | 10884 | 197 | 10404 | 283 | 22.3 | 114.2 | 2021-02-23 05:23:41 | Hong Kong, China | ||
182656 | 182656 | 2021-02-21 | US | Colorado | Huerfano | 8055 | 310 | 16 | 0 | 283 | 37.68473101 | -104.9612585 | 2021-02-22 05:24:21 | Huerfano, Colorado, US |
742930 | 742930 | 2021-02-20 | US | Colorado | Huerfano | 8055 | 309 | 16 | 0 | 283 | 37.68473101 | -104.9612585 | 2021-02-21 05:24:33 | Huerfano, Colorado, US |
473959 | 473959 | 2021-02-19 | US | Oklahoma | Harmon | 40057 | 286 | 3 | 0 | 283 | 34.7440135 | -99.84741652 | 2021-02-20 05:22:51 | Harmon, Oklahoma, US |
1156632 | 1156632 | 2021-02-18 | US | West Virginia | Webster | 54101 | 285 | 2 | 0 | 283 | 38.49370949 | -80.4202023 | 2021-02-19 05:24:16 | Webster, West Virginia, US |
3604089 | 3604089 | 2021-02-17 | US | Texas | Concho | 48095 | 345 | 7 | 0 | 283 | 31.32635934 | -99.86473038 | 2021-02-18 05:22:58 | Concho, Texas, US |
3053687 | 3053687 | 2021-02-16 | US | West Virginia | Webster | 54101 | 284 | 1 | 0 | 283 | 38.49370949 | -80.4202023 | 2021-02-17 05:23:10 | Webster, West Virginia, US |
3052723 | 3052723 | 2021-02-16 | US | Oklahoma | Harmon | 40057 | 285 | 2 | 0 | 283 | 34.7440135 | -99.84741652 | 2021-02-17 05:23:10 | Harmon, Oklahoma, US |
1341786 | 1341786 | 2021-02-15 | US | West Virginia | Webster | 54101 | 283 | 0 | 0 | 283 | 38.49370949 | -80.4202023 | 2021-02-16 05:24:38 | Webster, West Virginia, US |
2285788 | 2285788 | 2021-02-14 | US | North Carolina | Tyrrell | 37177 | 289 | 6 | 0 | 283 | 35.87147226 | -76.17055253 | 2021-02-15 05:24:49 | Tyrrell, North Carolina, US |
3541595 | 3541595 | 2021-02-12 | US | Nevada | Mineral | 32021 | 288 | 5 | 0 | 283 | 38.53841696 | -118.4344506 | 2021-02-13 05:22:12 | Mineral, Nevada, US |
3539575 | 3539575 | 2021-02-12 | Netherlands | Aruba | 7368 | 68 | 7017 | 283 | 12.5211 | -69.9683 | 2021-02-13 05:22:12 | Aruba, Netherlands | ||
2641074 | 2641074 | 2021-02-11 | US | Virginia | King and Queen | 51097 | 287 | 4 | 0 | 283 | 37.71044922 | -76.88689628 | 2021-02-12 05:23:29 | King and Queen, Virginia, US |
2639858 | 2639858 | 2021-02-11 | US | Nevada | Mineral | 32021 | 288 | 5 | 0 | 283 | 38.53841696 | -118.4344506 | 2021-02-12 05:23:29 | Mineral, Nevada, US |
3980713 | 3980713 | 2021-02-10 | US | Nevada | Mineral | 32021 | 288 | 5 | 0 | 283 | 38.53841696 | -118.4344506 | 2021-02-11 05:23:55 | Mineral, Nevada, US |
1530033 | 1530033 | 2021-02-09 | US | Nevada | Mineral | 32021 | 288 | 5 | 0 | 283 | 38.53841696 | -118.4344506 | 2021-02-10 05:22:41 | Mineral, Nevada, US |
977655 | 977655 | 2021-02-06 | US | Puerto Rico | Hormigueros | 72067 | 283 | 0 | 0 | 283 | 18.134532 | -67.113972 | 2021-02-07 05:23:00 | Hormigueros, Puerto Rico, US |
1591369 | 1591369 | 2021-02-05 | US | Texas | Real | 48385 | 313 | 12 | 0 | 283 | 29.83321503 | -99.82018052 | 2021-02-06 05:23:55 | Real, Texas, US |
1588445 | 1588445 | 2021-02-05 | San Marino | 3125 | 68 | 2774 | 283 | 43.9424 | 12.4578 | 2021-02-06 05:23:55 | San Marino | |||
791685 | 791685 | 2021-02-04 | US | Kansas | Logan | 20109 | 289 | 6 | 0 | 283 | 38.91735806 | -101.148475 | 2021-02-05 05:22:38 | Logan, Kansas, US |
342134 | 342134 | 2021-02-03 | US | Missouri | Atchison | 29005 | 289 | 6 | 0 | 283 | 40.43238737 | -95.42970639 | 2021-02-04 05:22:26 | Atchison, Missouri, US |
341577 | 341577 | 2021-02-03 | US | Kansas | Logan | 20109 | 289 | 6 | 0 | 283 | 38.91735806 | -101.148475 | 2021-02-04 05:22:26 | Logan, Kansas, US |
1686360 | 1686360 | 2021-02-02 | US | Missouri | Atchison | 29005 | 289 | 6 | 0 | 283 | 40.43238737 | -95.42970639 | 2021-02-03 05:22:52 | Atchison, Missouri, US |
1685803 | 1685803 | 2021-02-02 | US | Kansas | Logan | 20109 | 289 | 6 | 0 | 283 | 38.91735806 | -101.148475 | 2021-02-03 05:22:52 | Logan, Kansas, US |
1678330 | 1678330 | 2021-02-01 | US | Missouri | Atchison | 29005 | 289 | 6 | 0 | 283 | 40.43238737 | -95.42970639 | 2021-02-02 05:22:49 | Atchison, Missouri, US |
1677773 | 1677773 | 2021-02-01 | US | Kansas | Logan | 20109 | 289 | 6 | 0 | 283 | 38.91735806 | -101.148475 | 2021-02-02 05:22:49 | Logan, Kansas, US |
1460178 | 1460178 | 2021-01-31 | US | Alaska | Ketchikan Gateway | 2130 | 284 | 1 | 0 | 283 | 55.57445008 | -130.975561 | 2021-02-01 05:22:53 | Ketchikan Gateway, Alaska, US |
12174 | 12174 | 2021-01-26 | Colombia | Arauca | 5213 | 150 | 4780 | 283 | 7.0762 | -70.7105 | 2021-01-27 05:23:41 | Arauca, Colombia | ||
2567498 | 2567498 | 2021-01-25 | Colombia | Arauca | 5213 | 150 | 4780 | 283 | 7.0762 | -70.7105 | 2021-01-26 05:22:02 | Arauca, Colombia | ||
1760209 | 1760209 | 2021-01-24 | US | Idaho | Boise | 16015 | 285 | 2 | 0 | 283 | 43.98829931 | -115.7309284 | 2021-01-25 05:22:16 | Boise, Idaho, US |
2427816 | 2427816 | 2021-01-23 | US | Idaho | Boise | 16015 | 285 | 2 | 0 | 283 | 43.98829931 | -115.7309284 | 2021-01-24 05:22:35 | Boise, Idaho, US |
438421 | 438421 | 2021-01-21 | US | Texas | Donley | 48129 | 384 | 9 | 0 | 283 | 34.96517499 | -100.8140093 | 2021-01-22 05:22:10 | Donley, Texas, US |
1097152 | 1097152 | 2021-01-20 | US | Texas | Donley | 48129 | 384 | 9 | 0 | 283 | 34.96517499 | -100.8140093 | 2021-01-21 05:22:01 | Donley, Texas, US |
1095445 | 1095445 | 2021-01-20 | US | Kentucky | Ballard | 21007 | 286 | 3 | 0 | 283 | 37.05842757 | -88.99427697 | 2021-01-21 05:22:01 | Ballard, Kentucky, US |
237288 | 237288 | 2021-01-18 | Japan | Yamaguchi | 921 | 5 | 633 | 283 | 34.201190000000004 | 131.573293 | 2021-01-19 05:22:15 | Yamaguchi, Japan | ||
3105086 | 3105086 | 2021-01-16 | United Kingdom | Channel Islands | 0 | 0 | 2997 | 283 | 49.3723 | -2.3644 | 2021-01-17 05:22:17 | Channel Islands, United Kingdom | ||
3103562 | 3103562 | 2021-01-16 | US | Nebraska | Webster | 31181 | 287 | 4 | 0 | 283 | 40.17642643 | -98.50019851 | 2021-01-17 05:22:17 | Webster, Nebraska, US |
3101580 | 3101580 | 2021-01-16 | Pakistan | Azad Jammu and Kashmir | 8606 | 241 | 8082 | 283 | 34.027401 | 73.947253 | 2021-01-17 05:22:17 | Azad Jammu and Kashmir, Pakistan | ||
3518915 | 3518915 | 2021-01-15 | US | West Virginia | Wirt | 54105 | 284 | 1 | 0 | 283 | 39.02775007 | -81.37473928 | 2021-01-16 05:22:40 | Wirt, West Virginia, US |
3517524 | 3517524 | 2021-01-15 | US | Nebraska | Webster | 31181 | 287 | 4 | 0 | 283 | 40.17642643 | -98.50019851 | 2021-01-16 05:22:40 | Webster, Nebraska, US |
3308342 | 3308342 | 2021-01-13 | Pakistan | Azad Jammu and Kashmir | 8540 | 236 | 8021 | 283 | 34.027401 | 73.947253 | 2021-01-14 05:22:32 | Azad Jammu and Kashmir, Pakistan | ||
777442 | 777442 | 2021-01-12 | US | Texas | Hall | 48191 | 445 | 9 | 0 | 283 | 34.5307555 | -100.6813852 | 2021-01-13 05:22:15 | Hall, Texas, US |
2626294 | 2626294 | 2021-01-10 | US | Alaska | Nome | 2180 | 283 | 0 | 0 | 283 | 64.90320724 | -164.0353804 | 2021-01-11 05:21:50 | Nome, Alaska, US |
3900382 | 3900382 | 2021-01-09 | US | Alaska | Nome | 2180 | 283 | 0 | 0 | 283 | 64.90320724 | -164.0353804 | 2021-01-10 05:22:12 | Nome, Alaska, US |
2544294 | 2544294 | 2021-01-07 | US | South Dakota | Perkins | 46105 | 294 | 11 | 0 | 283 | 45.49049506 | -102.4755586 | 2021-01-08 05:22:42 | Perkins, South Dakota, US |
2867603 | 2867603 | 2021-01-06 | US | South Dakota | Perkins | 46105 | 294 | 11 | 0 | 283 | 45.49049506 | -102.4755586 | 2021-01-07 05:22:03 | Perkins, South Dakota, US |
2865624 | 2865624 | 2021-01-06 | US | Idaho | Bear Lake | 16007 | 285 | 2 | 0 | 283 | 42.28269683 | -111.32892379999998 | 2021-01-07 05:22:03 | Bear Lake, Idaho, US |
3034939 | 3034939 | 2021-01-05 | US | Colorado | Phillips | 8095 | 323 | 12 | 0 | 283 | 40.59414277 | -102.3577703 | 2021-01-06 05:22:16 | Phillips, Colorado, US |
1139785 | 1139785 | 2021-01-01 | US | South Dakota | Ziebach | 46137 | 291 | 8 | 0 | 283 | 44.97881876 | -101.6654622 | 2021-01-02 05:22:33 | Ziebach, South Dakota, US |
1137152 | 1137152 | 2021-01-01 | San Marino | 2384 | 59 | 2042 | 283 | 43.9424 | 12.4578 | 2021-01-02 05:22:33 | San Marino | |||
3698391 | 3698391 | 2020-12-31 | US | South Dakota | Ziebach | 46137 | 291 | 8 | 0 | 283 | 44.97881876 | -101.6654622 | 2021-01-01 05:23:07 | Ziebach, South Dakota, US |
3696356 | 3696356 | 2020-12-31 | US | Georgia | Talbot | 13263 | 292 | 9 | 0 | 283 | 32.69642758 | -84.53351366 | 2021-01-01 05:23:07 | Talbot, Georgia, US |
3696070 | 3696070 | 2020-12-31 | US | California | Trinity | 6105 | 299 | 2 | 0 | 283 | 40.64917670000001 | -123.114713 | 2021-01-01 05:23:07 | Trinity, California, US |
1013206 | 1013206 | 2020-12-30 | US | South Dakota | Ziebach | 46137 | 291 | 8 | 0 | 283 | 44.97881876 | -101.6654622 | 2020-12-31 05:22:49 | Ziebach, South Dakota, US |
3763536 | 3763536 | 2020-12-28 | US | Missouri | Shelby | 29205 | 286 | 3 | 0 | 283 | 39.79742518 | -92.07634971 | 2020-12-29 05:22:37 | Shelby, Missouri, US |
3761610 | 3761610 | 2020-12-28 | Japan | Nagasaki | 584 | 3 | 298 | 283 | 33.235712 | 129.608033 | 2020-12-29 05:22:37 | Nagasaki, Japan | ||
3781181 | 3781181 | 2020-12-27 | US | Vermont | Orleans | 50019 | 287 | 4 | 0 | 283 | 44.82964024 | -72.24562697 | 2020-12-28 05:22:06 | Orleans, Vermont, US |
3779879 | 3779879 | 2020-12-27 | US | Montana | Broadwater | 30007 | 285 | 2 | 0 | 283 | 46.33277565 | -111.4955813 | 2020-12-28 05:22:06 | Broadwater, Montana, US |
2226786 | 2226786 | 2020-12-26 | US | Vermont | Orleans | 50019 | 286 | 3 | 0 | 283 | 44.82964024 | -72.24562697 | 2020-12-27 05:22:55 | Orleans, Vermont, US |
204961 | 204961 | 2020-12-25 | US | Puerto Rico | Aibonito | 72009 | 283 | 0 | 0 | 283 | 18.131361 | -66.264131 | 2020-12-26 05:22:28 | Aibonito, Puerto Rico, US |
203728 | 203728 | 2020-12-25 | US | Kentucky | Wolfe | 21237 | 284 | 1 | 0 | 283 | 37.73941626 | -83.49303612 | 2020-12-26 05:22:28 | Wolfe, Kentucky, US |
3694184 | 3694184 | 2020-12-24 | US | Puerto Rico | Aibonito | 72009 | 283 | 0 | 0 | 283 | 18.131361 | -66.264131 | 2020-12-25 05:22:48 | Aibonito, Puerto Rico, US |
3692951 | 3692951 | 2020-12-24 | US | Kentucky | Wolfe | 21237 | 284 | 1 | 0 | 283 | 37.73941626 | -83.49303612 | 2020-12-25 05:22:48 | Wolfe, Kentucky, US |
3691619 | 3691619 | 2020-12-24 | Pakistan | Balochistan | 18028 | 181 | 17564 | 283 | 28.328492 | 65.898403 | 2020-12-25 05:22:48 | Balochistan, Pakistan |
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]);