johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
408 rows where active = 642 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3468400 | 3468400 | 2021-08-03 | Russia | Magadan Oblast | 9578 | 162 | 8774 | 642 | 62.48858785 | 153.9903764 | 2021-08-04 04:21:25 | Magadan Oblast, Russia | ||
1306274 | 1306274 | 2021-07-27 | Netherlands | Curacao | 13378 | 126 | 12610 | 642 | 12.1696 | -68.99 | 2021-07-28 04:21:39 | Curacao, Netherlands | ||
3137495 | 3137495 | 2021-07-23 | India | Delhi | 1435778 | 25041 | 1410095 | 642 | 28.646519 | 77.10898 | 2021-07-24 00:21:36 | Delhi, India | ||
3709812 | 3709812 | 2021-07-17 | Malaysia | W.P. Labuan | 9376 | 139 | 8595 | 642 | 5.2831 | 115.2308 | 2021-07-18 04:22:07 | W.P. Labuan, Malaysia | ||
629502 | 629502 | 2021-07-10 | Ukraine | Dnipropetrovsk Oblast | 135836 | 4459 | 130735 | 642 | 48.4647 | 35.0462 | 2021-07-11 04:21:43 | Dnipropetrovsk Oblast, Ukraine | ||
1440347 | 1440347 | 2021-07-07 | Canada | British Columbia | 147856 | 1759 | 145455 | 642 | 53.7267 | -127.6476 | 2021-07-08 04:21:26 | British Columbia, Canada | ||
1495821 | 1495821 | 2021-07-03 | Russia | Kurgan Oblast | 22607 | 451 | 21514 | 642 | 55.7655302 | 64.5632681 | 2021-07-04 04:21:38 | Kurgan Oblast, Russia | ||
2426517 | 2426517 | 2021-06-23 | Ukraine | Kherson Oblast | 35635 | 1132 | 33861 | 642 | 46.6354 | 32.6169 | 2021-06-24 04:21:55 | Kherson Oblast, Ukraine | ||
1564322 | 1564322 | 2021-06-14 | Russia | Novgorod Oblast | 31469 | 182 | 30645 | 642 | 58.2843833 | 32.5169757 | 2021-06-15 04:22:22 | Novgorod Oblast, Russia | ||
825695 | 825695 | 2021-06-06 | Montenegro | 99812 | 1592 | 97578 | 642 | 42.708678000000006 | 19.37439 | 2021-06-07 04:22:51 | Montenegro | |||
2586018 | 2586018 | 2021-06-05 | Japan | Okayama | 7464 | 110 | 6712 | 642 | 34.89246 | 133.826252 | 2021-06-06 04:24:03 | Okayama, Japan | ||
1806996 | 1806996 | 2021-05-27 | Russia | Tomsk Oblast | 32760 | 431 | 31687 | 642 | 58.6124279 | 82.04753149999998 | 2021-05-28 04:20:36 | Tomsk Oblast, Russia | ||
1771593 | 1771593 | 2021-05-23 | Russia | Tomsk Oblast | 32662 | 426 | 31594 | 642 | 58.6124279 | 82.04753149999998 | 2021-05-24 04:20:53 | Tomsk Oblast, Russia | ||
1408892 | 1408892 | 2021-04-23 | Colombia | Huila | 52826 | 1842 | 50342 | 642 | 2.5359 | -75.5277 | 2021-04-24 04:20:38 | Huila, Colombia | ||
2410832 | 2410832 | 2021-04-19 | Italy | Molise | 12885 | 465 | 11778 | 642 | 41.55774754 | 14.65916051 | 2021-04-20 04:20:41 | Molise, Italy | ||
3003159 | 3003159 | 2021-04-06 | Colombia | Norte de Santander | 52257 | 2773 | 48842 | 642 | 7.9463 | -72.8988 | 2021-04-07 04:20:53 | Norte de Santander, Colombia | ||
3369329 | 3369329 | 2021-03-21 | Japan | Aichi | 26745 | 570 | 25533 | 642 | 35.035551 | 137.211621 | 2021-03-22 05:25:43 | Aichi, Japan | ||
3620842 | 3620842 | 2021-03-17 | Cambodia | 1541 | 1 | 898 | 642 | 11.55 | 104.9167 | 2021-03-18 05:26:22 | Cambodia | |||
352267 | 352267 | 2021-03-11 | India | Uttarakhand | 97634 | 1698 | 95294 | 642 | 30.156447 | 79.197608 | 2021-03-12 05:26:50 | Uttarakhand, India | ||
1618538 | 1618538 | 2021-03-05 | US | North Carolina | Clay | 37043 | 660 | 18 | 0 | 642 | 35.05704275 | -83.74353633 | 2021-03-06 04:23:41 | Clay, North Carolina, US |
1618449 | 1618449 | 2021-03-05 | US | New Mexico | Torrance | 35057 | 654 | 12 | 0 | 642 | 34.64048375 | -105.8508949 | 2021-03-06 04:23:41 | Torrance, New Mexico, US |
1616803 | 1616803 | 2021-03-05 | US | California | Plumas | 6063 | 645 | 4 | 0 | 642 | 40.00355989 | -120.8395236 | 2021-03-06 04:23:41 | Plumas, California, US |
2370725 | 2370725 | 2021-02-28 | US | Texas | Trinity | 48455 | 877 | 22 | 0 | 642 | 31.0879489 | -95.1367187 | 2021-03-01 05:23:01 | Trinity, Texas, US |
2184174 | 2184174 | 2021-02-26 | US | Colorado | Archuleta | 8007 | 671 | 1 | 0 | 642 | 37.19474156 | -107.0476867 | 2021-02-27 05:22:28 | Archuleta, Colorado, US |
1861358 | 1861358 | 2021-02-25 | US | Virginia | Lancaster | 51103 | 651 | 9 | 0 | 642 | 37.71889653 | -76.46400482 | 2021-02-26 05:22:40 | Lancaster, Virginia, US |
1938654 | 1938654 | 2021-02-23 | US | New Mexico | Sierra | 35051 | 685 | 43 | 0 | 642 | 33.13028233 | -107.1925893 | 2021-02-24 05:29:16 | Sierra, New Mexico, US |
532909 | 532909 | 2021-02-22 | US | New Mexico | Sierra | 35051 | 685 | 43 | 0 | 642 | 33.13028233 | -107.1925893 | 2021-02-23 05:23:41 | Sierra, New Mexico, US |
184243 | 184243 | 2021-02-21 | US | New Mexico | Sierra | 35051 | 685 | 43 | 0 | 642 | 33.13028233 | -107.1925893 | 2021-02-22 05:24:21 | Sierra, New Mexico, US |
3601996 | 3601996 | 2021-02-17 | US | Illinois | Brown | 17009 | 648 | 6 | 0 | 642 | 39.96209138 | -90.75068024 | 2021-02-18 05:22:58 | Brown, Illinois, US |
3051131 | 3051131 | 2021-02-16 | US | Illinois | Brown | 17009 | 648 | 6 | 0 | 642 | 39.96209138 | -90.75068024 | 2021-02-17 05:23:10 | Brown, Illinois, US |
1340654 | 1340654 | 2021-02-15 | US | North Dakota | Bottineau | 38009 | 668 | 20 | 0 | 642 | 48.79106111 | -100.8378166 | 2021-02-16 05:24:38 | Bottineau, North Dakota, US |
1339230 | 1339230 | 2021-02-15 | US | Illinois | Brown | 17009 | 648 | 6 | 0 | 642 | 39.96209138 | -90.75068024 | 2021-02-16 05:24:38 | Brown, Illinois, US |
2285606 | 2285606 | 2021-02-14 | US | New Mexico | Colfax | 35007 | 687 | 45 | 0 | 642 | 36.60569702 | -104.64726740000002 | 2021-02-15 05:24:49 | Colfax, New Mexico, US |
2284381 | 2284381 | 2021-02-14 | US | Illinois | Brown | 17009 | 648 | 6 | 0 | 642 | 39.96209138 | -90.75068024 | 2021-02-15 05:24:49 | Brown, Illinois, US |
2680006 | 2680006 | 2021-02-13 | US | New Mexico | Colfax | 35007 | 687 | 45 | 0 | 642 | 36.60569702 | -104.64726740000002 | 2021-02-14 05:23:43 | Colfax, New Mexico, US |
2678781 | 2678781 | 2021-02-13 | US | Illinois | Brown | 17009 | 648 | 6 | 0 | 642 | 39.96209138 | -90.75068024 | 2021-02-14 05:23:43 | Brown, Illinois, US |
2677756 | 2677756 | 2021-02-13 | Guyana | 8207 | 186 | 7379 | 642 | 4.860416000000002 | -58.93018000000001 | 2021-02-14 05:23:43 | Guyana | |||
3540414 | 3540414 | 2021-02-12 | US | Illinois | Brown | 17009 | 648 | 6 | 0 | 642 | 39.96209138 | -90.75068024 | 2021-02-13 05:22:12 | Brown, Illinois, US |
2640802 | 2640802 | 2021-02-11 | US | Texas | Franklin | 48159 | 781 | 21 | 0 | 642 | 33.17653242 | -95.21917243 | 2021-02-12 05:23:29 | Franklin, Texas, US |
2639775 | 2639775 | 2021-02-11 | US | Nebraska | Dawes | 31045 | 660 | 18 | 0 | 642 | 42.71985036 | -103.1313774 | 2021-02-12 05:23:29 | Dawes, Nebraska, US |
2638677 | 2638677 | 2021-02-11 | US | Illinois | Brown | 17009 | 648 | 6 | 0 | 642 | 39.96209138 | -90.75068024 | 2021-02-12 05:23:29 | Brown, Illinois, US |
3979532 | 3979532 | 2021-02-10 | US | Illinois | Brown | 17009 | 648 | 6 | 0 | 642 | 39.96209138 | -90.75068024 | 2021-02-11 05:23:55 | Brown, Illinois, US |
3979080 | 3979080 | 2021-02-10 | US | Arkansas | Newton | 5101 | 668 | 26 | 0 | 642 | 35.91947491 | -93.21612969 | 2021-02-11 05:23:55 | Newton, Arkansas, US |
3978433 | 3978433 | 2021-02-10 | Colombia | Quindio | 30941 | 897 | 29402 | 642 | 4.461 | -75.6674 | 2021-02-11 05:23:55 | Quindio, Colombia | ||
1531278 | 1531278 | 2021-02-09 | US | Virginia | Poquoson | 51735 | 652 | 10 | 0 | 642 | 37.14259351 | -76.35798148 | 2021-02-10 05:22:41 | Poquoson, Virginia, US |
1530913 | 1530913 | 2021-02-09 | US | Texas | Blanco | 48031 | 729 | 15 | 0 | 642 | 30.26640707 | -98.3999852 | 2021-02-10 05:22:41 | Blanco, Texas, US |
1529033 | 1529033 | 2021-02-09 | US | Indiana | Union | 18161 | 652 | 10 | 0 | 642 | 39.62550777 | -84.92497066 | 2021-02-10 05:22:41 | Union, Indiana, US |
1528852 | 1528852 | 2021-02-09 | US | Illinois | Brown | 17009 | 648 | 6 | 0 | 642 | 39.96209138 | -90.75068024 | 2021-02-10 05:22:41 | Brown, Illinois, US |
1590709 | 1590709 | 2021-02-05 | US | Oklahoma | Coal | 40029 | 652 | 10 | 0 | 642 | 34.58840127 | -96.29798747 | 2021-02-06 05:23:55 | Coal, Oklahoma, US |
792259 | 792259 | 2021-02-04 | US | Missouri | Cedar | 29039 | 652 | 10 | 0 | 642 | 37.72391475 | -93.85445441 | 2021-02-05 05:22:38 | Cedar, Missouri, US |
790396 | 790396 | 2021-02-04 | Japan | Ibaraki | 4978 | 71 | 4265 | 642 | 36.303588 | 140.319591 | 2021-02-05 05:22:38 | Ibaraki, Japan | ||
790167 | 790167 | 2021-02-04 | Chile | Arica y Parinacota | 13266 | 258 | 12366 | 642 | -18.594 | -69.4785 | 2021-02-05 05:22:38 | Arica y Parinacota, Chile | ||
790144 | 790144 | 2021-02-04 | Cabo Verde | 14290 | 135 | 13513 | 642 | 16.5388 | -23.0418 | 2021-02-05 05:22:38 | Cabo Verde | |||
343565 | 343565 | 2021-02-03 | US | Virginia | Amelia | 51007 | 654 | 12 | 0 | 642 | 37.34081025 | -77.98584649 | 2021-02-04 05:22:26 | Amelia, Virginia, US |
343172 | 343172 | 2021-02-03 | US | South Dakota | Tripp | 46123 | 657 | 15 | 0 | 642 | 43.34459388 | -99.8854891 | 2021-02-04 05:22:26 | Tripp, South Dakota, US |
1687791 | 1687791 | 2021-02-02 | US | Virginia | Amelia | 51007 | 653 | 11 | 0 | 642 | 37.34081025 | -77.98584649 | 2021-02-03 05:22:52 | Amelia, Virginia, US |
1687398 | 1687398 | 2021-02-02 | US | South Dakota | Tripp | 46123 | 657 | 15 | 0 | 642 | 43.34459388 | -99.8854891 | 2021-02-03 05:22:52 | Tripp, South Dakota, US |
1685925 | 1685925 | 2021-02-02 | US | Kentucky | Livingston | 21139 | 658 | 16 | 0 | 642 | 37.21137452 | -88.34797529 | 2021-02-03 05:22:52 | Livingston, Kentucky, US |
1685823 | 1685823 | 2021-02-02 | US | Kansas | Phillips | 20147 | 659 | 17 | 0 | 642 | 39.78465501 | -99.34668865 | 2021-02-03 05:22:52 | Phillips, Kansas, US |
1677793 | 1677793 | 2021-02-01 | US | Kansas | Phillips | 20147 | 659 | 17 | 0 | 642 | 39.78465501 | -99.34668865 | 2021-02-02 05:22:49 | Phillips, Kansas, US |
1460978 | 1460978 | 2021-01-31 | US | Iowa | Osceola | 19143 | 654 | 12 | 0 | 642 | 43.37824276 | -95.62422844 | 2021-02-01 05:22:53 | Osceola, Iowa, US |
2215273 | 2215273 | 2021-01-30 | US | Wyoming | Sublette | 56035 | 649 | 7 | 0 | 642 | 42.76558279 | -109.9130922 | 2021-01-31 05:22:42 | Sublette, Wyoming, US |
2212493 | 2212493 | 2021-01-30 | US | Georgia | Lincoln | 13181 | 659 | 17 | 0 | 642 | 33.79201475 | -82.45024131 | 2021-01-31 05:22:42 | Lincoln, Georgia, US |
1900760 | 1900760 | 2021-01-29 | US | Wyoming | Sublette | 56035 | 649 | 7 | 0 | 642 | 42.76558279 | -109.9130922 | 2021-01-30 05:22:49 | Sublette, Wyoming, US |
1900658 | 1900658 | 2021-01-29 | US | West Virginia | Summers | 54089 | 663 | 21 | 0 | 642 | 37.65390597 | -80.86009693 | 2021-01-30 05:22:49 | Summers, West Virginia, US |
1898373 | 1898373 | 2021-01-29 | US | Iowa | Osceola | 19143 | 653 | 11 | 0 | 642 | 43.37824276 | -95.62422844 | 2021-01-30 05:22:49 | Osceola, Iowa, US |
1897807 | 1897807 | 2021-01-29 | US | Colorado | Yuma | 8125 | 801 | 16 | 0 | 642 | 40.00346839 | -102.4258673 | 2021-01-30 05:22:49 | Yuma, Colorado, US |
1897459 | 1897459 | 2021-01-29 | Suriname | 8364 | 154 | 7568 | 642 | 3.9193 | -56.0278 | 2021-01-30 05:22:49 | Suriname | |||
1896995 | 1896995 | 2021-01-29 | Colombia | Casanare | 11314 | 226 | 10446 | 642 | 5.7589 | -71.5724 | 2021-01-30 05:22:49 | Casanare, Colombia | ||
2484751 | 2484751 | 2021-01-28 | US | Puerto Rico | Yabucoa | 72151 | 642 | 0 | 0 | 642 | 18.070399 | -65.896289 | 2021-01-29 05:22:23 | Yabucoa, Puerto Rico, US |
2481810 | 2481810 | 2021-01-28 | Colombia | Caqueta | 16492 | 583 | 15267 | 642 | 0.8699 | -73.8419 | 2021-01-29 05:22:23 | Caqueta, Colombia | ||
3153961 | 3153961 | 2021-01-27 | US | Alabama | Coosa | 1037 | 661 | 19 | 0 | 642 | 32.93690146 | -86.24847739 | 2021-01-28 05:22:24 | Coosa, Alabama, US |
1762623 | 1762623 | 2021-01-24 | US | Virginia | Floyd | 51063 | 660 | 18 | 0 | 642 | 36.9302126 | -80.36738849 | 2021-01-25 05:22:16 | Floyd, Virginia, US |
2428835 | 2428835 | 2021-01-23 | US | Missouri | Oregon | 29149 | 645 | 3 | 0 | 642 | 36.68710164 | -91.4033755 | 2021-01-24 05:22:35 | Oregon, Missouri, US |
2467840 | 2467840 | 2021-01-22 | US | Illinois | Schuyler | 17169 | 646 | 4 | 0 | 642 | 40.1571798 | -90.61114163 | 2021-01-23 05:22:03 | Schuyler, Illinois, US |
436716 | 436716 | 2021-01-21 | US | Kentucky | Bath | 21011 | 652 | 10 | 0 | 642 | 38.14735938 | -83.74588932 | 2021-01-22 05:22:10 | Bath, Kentucky, US |
909383 | 909383 | 2021-01-19 | US | Iowa | Lucas | 19117 | 650 | 8 | 0 | 642 | 41.02958964 | -93.32780803 | 2021-01-20 05:21:54 | Lucas, Iowa, US |
3102258 | 3102258 | 2021-01-16 | US | Georgia | Jenkins | 13165 | 676 | 34 | 0 | 642 | 32.79248718 | -81.96040187 | 2021-01-17 05:22:17 | Jenkins, Georgia, US |
3882547 | 3882547 | 2021-01-14 | US | Tennessee | Pickett | 47137 | 686 | 19 | 0 | 642 | 36.55606529 | -85.07763299999998 | 2021-01-15 05:22:24 | Pickett, Tennessee, US |
3881009 | 3881009 | 2021-01-14 | US | Kentucky | McLean | 21149 | 662 | 20 | 0 | 642 | 37.5301951 | -87.26803443 | 2021-01-15 05:22:24 | McLean, Kentucky, US |
3311664 | 3311664 | 2021-01-13 | US | West Virginia | Braxton | 54007 | 643 | 1 | 0 | 642 | 38.70036159 | -80.72011184 | 2021-01-14 05:22:32 | Braxton, West Virginia, US |
3310802 | 3310802 | 2021-01-13 | US | Oregon | Clatsop | 41007 | 646 | 4 | 0 | 642 | 45.99712889 | -123.660711 | 2021-01-14 05:22:32 | Clatsop, Oregon, US |
774652 | 774652 | 2021-01-12 | Suriname | 7178 | 138 | 6398 | 642 | 3.9193 | -56.0278 | 2021-01-13 05:22:15 | Suriname | |||
193243 | 193243 | 2021-01-11 | US | Texas | Newton | 48351 | 586 | 19 | 0 | 642 | 30.78548982 | -93.74408813 | 2021-01-12 05:22:15 | Newton, Texas, US |
193072 | 193072 | 2021-01-11 | US | Texas | Archer | 48009 | 672 | 6 | 0 | 642 | 33.61569967 | -98.68754589 | 2021-01-12 05:22:15 | Archer, Texas, US |
191216 | 191216 | 2021-01-11 | US | Iowa | Adair | 19001 | 662 | 20 | 0 | 642 | 41.33075609 | -94.47105874 | 2021-01-12 05:22:15 | Adair, Iowa, US |
2629046 | 2629046 | 2021-01-10 | US | Texas | Newton | 48351 | 586 | 19 | 0 | 642 | 30.78548982 | -93.74408813 | 2021-01-11 05:21:50 | Newton, Texas, US |
2628875 | 2628875 | 2021-01-10 | US | Texas | Archer | 48009 | 672 | 6 | 0 | 642 | 33.61569967 | -98.68754589 | 2021-01-11 05:21:50 | Archer, Texas, US |
2626070 | 2626070 | 2021-01-10 | Russia | Jewish Autonomous Okrug | 3895 | 77 | 3176 | 642 | 48.57527615 | 132.66307460000002 | 2021-01-11 05:21:50 | Jewish Autonomous Okrug, Russia | ||
3903134 | 3903134 | 2021-01-09 | US | Texas | Newton | 48351 | 586 | 19 | 0 | 642 | 30.78548982 | -93.74408813 | 2021-01-10 05:22:12 | Newton, Texas, US |
3902963 | 3902963 | 2021-01-09 | US | Texas | Archer | 48009 | 672 | 6 | 0 | 642 | 33.61569967 | -98.68754589 | 2021-01-10 05:22:12 | Archer, Texas, US |
157157 | 157157 | 2021-01-08 | US | Texas | Newton | 48351 | 586 | 19 | 0 | 642 | 30.78548982 | -93.74408813 | 2021-01-09 05:22:18 | Newton, Texas, US |
156882 | 156882 | 2021-01-08 | US | South Dakota | Walworth | 46129 | 656 | 14 | 0 | 642 | 45.43019636 | -100.0307514 | 2021-01-09 05:22:18 | Walworth, South Dakota, US |
3037311 | 3037311 | 2021-01-05 | US | Texas | Bandera | 48019 | 764 | 13 | 0 | 642 | 29.74619598 | -99.24598147 | 2021-01-06 05:22:16 | Bandera, Texas, US |
3036328 | 3036328 | 2021-01-05 | US | Montana | Valley | 30105 | 650 | 8 | 0 | 642 | 48.36435097 | -106.6669635 | 2021-01-06 05:22:16 | Valley, Montana, US |
3231634 | 3231634 | 2021-01-03 | US | Iowa | Greene | 19073 | 649 | 7 | 0 | 642 | 42.03614551 | -94.39658081 | 2021-01-04 05:22:02 | Greene, Iowa, US |
3231289 | 3231289 | 2021-01-03 | US | Georgia | Montgomery | 13209 | 652 | 10 | 0 | 642 | 32.17201038 | -82.53527476 | 2021-01-04 05:22:02 | Montgomery, Georgia, US |
3231218 | 3231218 | 2021-01-03 | US | Georgia | Clinch | 13065 | 656 | 14 | 0 | 642 | 30.91395822 | -82.70432472 | 2021-01-04 05:22:02 | Clinch, Georgia, US |
1010673 | 1010673 | 2020-12-30 | US | Alabama | Greene | 1063 | 662 | 20 | 0 | 642 | 32.85504247 | -87.95684022 | 2020-12-31 05:22:49 | Greene, Alabama, US |
768678 | 768678 | 2020-12-29 | US | North Carolina | Swain | 37173 | 649 | 7 | 0 | 642 | 35.48665845 | -83.48748932 | 2020-12-30 05:22:34 | Swain, North Carolina, 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]);