daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
354 rows where active = 632 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-07-31 | India | Uttarakhand | 342139 | 7362 | 334145 | 632 | 30.156447 | 79.197608 | 2021-08-01 04:21:50 | Uttarakhand, India | ||
2021-07-02 | Russia | Kurgan Oblast | 22537 | 449 | 21456 | 632 | 55.7655302 | 64.5632681 | 2021-07-03 04:21:37 | Kurgan Oblast, Russia | ||
2021-06-09 | Russia | Kaliningrad Oblast | 34084 | 507 | 32945 | 632 | 54.7293041 | 21.1489473 | 2021-06-10 04:23:17 | Kaliningrad Oblast, Russia | ||
2021-06-08 | Russia | Novgorod Oblast | 31255 | 177 | 30446 | 632 | 58.2843833 | 32.5169757 | 2021-06-09 04:23:31 | Novgorod Oblast, Russia | ||
2021-06-06 | Russia | Novgorod Oblast | 31193 | 174 | 30387 | 632 | 58.2843833 | 32.5169757 | 2021-06-07 04:22:51 | Novgorod Oblast, Russia | ||
2021-05-29 | Russia | Novgorod Oblast | 30913 | 157 | 30124 | 632 | 58.2843833 | 32.5169757 | 2021-05-30 04:20:55 | Novgorod Oblast, Russia | ||
2021-05-15 | Russia | Tomsk Oblast | 32470 | 417 | 31421 | 632 | 58.6124279 | 82.04753149999998 | 2021-05-16 04:20:49 | Tomsk Oblast, Russia | ||
2021-05-10 | Russia | Tomsk Oblast | 32358 | 411 | 31315 | 632 | 58.6124279 | 82.04753149999998 | 2021-05-11 04:20:41 | Tomsk Oblast, Russia | ||
2021-05-08 | Colombia | Casanare | 16381 | 363 | 15386 | 632 | 5.7589 | -71.5724 | 2021-05-09 04:20:35 | Casanare, Colombia | ||
2021-05-01 | Italy | Molise | 13259 | 478 | 12149 | 632 | 41.55774754 | 14.65916051 | 2021-05-02 04:20:48 | Molise, Italy | ||
2021-04-15 | Italy | Molise | 12747 | 460 | 11655 | 632 | 41.55774754 | 14.65916051 | 2021-04-16 04:20:46 | Molise, Italy | ||
2021-04-10 | Cote d'Ivoire | 45089 | 260 | 44197 | 632 | 7.54 | -5.5471 | 2021-04-11 04:20:56 | Cote d'Ivoire | |||
2021-04-09 | Cote d'Ivoire | 45089 | 260 | 44197 | 632 | 7.54 | -5.5471 | 2021-04-10 04:20:59 | Cote d'Ivoire | |||
2021-03-24 | Chile | Arica y Parinacota | 16850 | 342 | 15876 | 632 | -18.594 | -69.4785 | 2021-03-25 05:27:00 | Arica y Parinacota, Chile | ||
2021-03-20 | Colombia | Norte de Santander | 51531 | 2751 | 48148 | 632 | 7.9463 | -72.8988 | 2021-03-21 05:25:44 | Norte de Santander, Colombia | ||
2021-03-10 | Japan | Aichi | 26281 | 548 | 25101 | 632 | 35.035551 | 137.211621 | 2021-03-11 05:25:48 | Aichi, Japan | ||
2021-03-09 | Japan | Aichi | 26237 | 545 | 25060 | 632 | 35.035551 | 137.211621 | 2021-03-10 05:24:35 | Aichi, Japan | ||
2021-03-08 | India | Goa | 55463 | 799 | 54032 | 632 | 15.359682 | 74.057396 | 2021-03-09 05:28:19 | Goa, India | ||
2021-03-07 | Saint Vincent and the Grenadines | 1663 | 8 | 1023 | 632 | 12.9843 | -61.2872 | 2021-03-08 05:24:48 | Saint Vincent and the Grenadines | |||
2021-03-07 | India | Uttarakhand | 97422 | 1695 | 95095 | 632 | 30.156447 | 79.197608 | 2021-03-08 05:24:48 | Uttarakhand, India | ||
2021-03-06 | US | Washington | Pend Oreille | 53051 | 639 | 7 | 0 | 632 | 48.53234021 | -117.2741804 | 2021-03-07 05:21:54 | Pend Oreille, Washington, US |
2021-03-05 | US | Washington | Pend Oreille | 53051 | 639 | 7 | 0 | 632 | 48.53234021 | -117.2741804 | 2021-03-06 04:23:41 | Pend Oreille, Washington, US |
2021-03-04 | US | Kentucky | Gallatin | 21077 | 651 | 19 | 0 | 632 | 38.75398691 | -84.8558382 | 2021-03-05 05:26:29 | Gallatin, Kentucky, US |
2021-03-03 | US | Kentucky | Gallatin | 21077 | 651 | 19 | 0 | 632 | 38.75398691 | -84.8558382 | 2021-03-04 05:24:24 | Gallatin, Kentucky, US |
2021-03-02 | US | New Mexico | Torrance | 35057 | 644 | 12 | 0 | 632 | 34.64048375 | -105.8508949 | 2021-03-03 05:23:28 | Torrance, New Mexico, US |
2021-03-02 | Russia | Bryansk Oblast | 33092 | 257 | 32203 | 632 | 52.8873315 | 33.41585300000001 | 2021-03-03 05:23:28 | Bryansk Oblast, Russia | ||
2021-03-01 | US | Virginia | Essex | 51057 | 638 | 6 | 0 | 632 | 37.93357639 | -76.94230311 | 2021-03-02 05:23:30 | Essex, Virginia, US |
2021-02-28 | US | Michigan | Presque Isle | 26141 | 660 | 28 | 0 | 632 | 45.34018577 | -83.91498656 | 2021-03-01 05:23:01 | Presque Isle, Michigan, US |
2021-02-27 | US | Michigan | Presque Isle | 26141 | 660 | 28 | 0 | 632 | 45.34018577 | -83.91498656 | 2021-02-28 05:22:20 | Presque Isle, Michigan, US |
2021-02-26 | US | Texas | Trinity | 48455 | 867 | 22 | 0 | 632 | 31.0879489 | -95.1367187 | 2021-02-27 05:22:28 | Trinity, Texas, US |
2021-02-26 | US | Michigan | Presque Isle | 26141 | 660 | 28 | 0 | 632 | 45.34018577 | -83.91498656 | 2021-02-27 05:22:28 | Presque Isle, Michigan, US |
2021-02-26 | Chile | Arica y Parinacota | 15012 | 293 | 14087 | 632 | -18.594 | -69.4785 | 2021-02-27 05:22:28 | Arica y Parinacota, Chile | ||
2021-02-23 | US | South Dakota | Day | 46037 | 660 | 28 | 0 | 632 | 45.367281 | -97.60737498 | 2021-02-24 05:29:16 | Day, South Dakota, US |
2021-02-23 | US | Oregon | Baker | 41001 | 639 | 7 | 0 | 632 | 44.70915557 | -117.6749883 | 2021-02-24 05:29:16 | Baker, Oregon, US |
2021-02-23 | US | Oklahoma | Cotton | 40033 | 645 | 13 | 0 | 632 | 34.28845626 | -98.37053567 | 2021-02-24 05:29:16 | Cotton, Oklahoma, US |
2021-02-23 | US | Colorado | Archuleta | 8007 | 656 | 1 | 0 | 632 | 37.19474156 | -107.0476867 | 2021-02-24 05:29:16 | Archuleta, Colorado, US |
2021-02-22 | US | California | Plumas | 6063 | 635 | 4 | 0 | 632 | 40.00355989 | -120.8395236 | 2021-02-23 05:23:41 | Plumas, California, US |
2021-02-21 | US | Kansas | Wabaunsee | 20197 | 646 | 14 | 0 | 632 | 38.95471985 | -96.20350509 | 2021-02-22 05:24:21 | Wabaunsee, Kansas, US |
2021-02-21 | US | California | Plumas | 6063 | 635 | 4 | 0 | 632 | 40.00355989 | -120.8395236 | 2021-02-22 05:24:21 | Plumas, California, US |
2021-02-20 | US | Kansas | Wabaunsee | 20197 | 646 | 14 | 0 | 632 | 38.95471985 | -96.20350509 | 2021-02-21 05:24:33 | Wabaunsee, Kansas, US |
2021-02-19 | US | Kansas | Wabaunsee | 20197 | 646 | 14 | 0 | 632 | 38.95471985 | -96.20350509 | 2021-02-20 05:22:51 | Wabaunsee, Kansas, US |
2021-02-18 | US | Colorado | Moffat | 8081 | 710 | 22 | 0 | 632 | 40.61810999 | -108.2070876 | 2021-02-19 05:24:16 | Moffat, Colorado, US |
2021-02-10 | US | New Mexico | Sierra | 35051 | 675 | 43 | 0 | 632 | 33.13028233 | -107.1925893 | 2021-02-11 05:23:55 | Sierra, New Mexico, US |
2021-02-09 | US | New Mexico | Sierra | 35051 | 675 | 43 | 0 | 632 | 33.13028233 | -107.1925893 | 2021-02-10 05:22:41 | Sierra, New Mexico, US |
2021-02-08 | US | Puerto Rico | Coamo | 72043 | 632 | 0 | 0 | 632 | 18.097597 | -66.36014 | 2021-02-09 05:23:30 | Coamo, Puerto Rico, US |
2021-02-08 | US | New Mexico | Sierra | 35051 | 675 | 43 | 0 | 632 | 33.13028233 | -107.1925893 | 2021-02-09 05:23:30 | Sierra, New Mexico, US |
2021-02-07 | US | Texas | Blanco | 48031 | 719 | 15 | 0 | 632 | 30.26640707 | -98.3999852 | 2021-02-08 05:22:39 | Blanco, Texas, US |
2021-02-07 | US | New Mexico | Sierra | 35051 | 675 | 43 | 0 | 632 | 33.13028233 | -107.1925893 | 2021-02-08 05:22:39 | Sierra, New Mexico, US |
2021-02-06 | US | Texas | Blanco | 48031 | 719 | 15 | 0 | 632 | 30.26640707 | -98.3999852 | 2021-02-07 05:23:00 | Blanco, Texas, US |
2021-02-06 | US | New Mexico | Sierra | 35051 | 675 | 43 | 0 | 632 | 33.13028233 | -107.1925893 | 2021-02-07 05:23:00 | Sierra, New Mexico, US |
2021-02-03 | US | South Dakota | Hamlin | 46057 | 670 | 38 | 0 | 632 | 44.67385954 | -97.18829593 | 2021-02-04 05:22:26 | Hamlin, South Dakota, US |
2021-02-03 | US | Oklahoma | Jefferson | 40067 | 639 | 7 | 0 | 632 | 34.11130184 | -97.83182974 | 2021-02-04 05:22:26 | Jefferson, Oklahoma, US |
2021-02-03 | US | North Dakota | Bottineau | 38009 | 652 | 20 | 0 | 632 | 48.79106111 | -100.8378166 | 2021-02-04 05:22:26 | Bottineau, North Dakota, US |
2021-02-02 | US | Maine | Washington | 23029 | 642 | 10 | 0 | 632 | 45.01607142 | -67.62813524 | 2021-02-03 05:22:52 | Washington, Maine, US |
2021-01-29 | US | Nebraska | Kearney | 31099 | 636 | 4 | 0 | 632 | 40.50663314 | -98.94877182 | 2021-01-30 05:22:49 | Kearney, Nebraska, US |
2021-01-28 | US | Nebraska | Kearney | 31099 | 636 | 4 | 0 | 632 | 40.50663314 | -98.94877182 | 2021-01-29 05:22:23 | Kearney, Nebraska, US |
2021-01-28 | US | Kansas | Republic | 20157 | 642 | 10 | 0 | 632 | 39.82799632 | -97.65036709 | 2021-01-29 05:22:23 | Republic, Kansas, US |
2021-01-27 | US | Kansas | Republic | 20157 | 642 | 10 | 0 | 632 | 39.82799632 | -97.65036709 | 2021-01-28 05:22:24 | Republic, Kansas, US |
2021-01-25 | US | Puerto Rico | Utuado | 72141 | 632 | 0 | 0 | 632 | 18.271214 | -66.702984 | 2021-01-26 05:22:02 | Utuado, Puerto Rico, US |
2021-01-22 | US | Georgia | Lanier | 13173 | 642 | 10 | 0 | 632 | 31.038285700000007 | -83.06472457 | 2021-01-23 05:22:03 | Lanier, Georgia, US |
2021-01-21 | US | Wyoming | Sublette | 56035 | 639 | 7 | 0 | 632 | 42.76558279 | -109.9130922 | 2021-01-22 05:22:10 | Sublette, Wyoming, US |
2021-01-21 | US | Texas | Winkler | 48495 | 639 | 15 | 0 | 632 | 31.85008651 | -103.0485163 | 2021-01-22 05:22:10 | Winkler, Texas, US |
2021-01-20 | US | Iowa | Osceola | 19143 | 641 | 9 | 0 | 632 | 43.37824276 | -95.62422844 | 2021-01-21 05:22:01 | Osceola, Iowa, US |
2021-01-19 | US | South Dakota | Tripp | 46123 | 646 | 14 | 0 | 632 | 43.34459388 | -99.8854891 | 2021-01-20 05:21:54 | Tripp, South Dakota, US |
2021-01-17 | US | Kentucky | Leslie | 21131 | 634 | 2 | 0 | 632 | 37.09246661 | -83.37999606 | 2021-01-18 05:22:34 | Leslie, Kentucky, US |
2021-01-16 | US | Oklahoma | Tillman | 40141 | 643 | 11 | 0 | 632 | 34.37288446 | -98.92426619 | 2021-01-17 05:22:17 | Tillman, Oklahoma, US |
2021-01-15 | US | Georgia | Jenkins | 13165 | 666 | 34 | 0 | 632 | 32.79248718 | -81.96040187 | 2021-01-16 05:22:40 | Jenkins, Georgia, US |
2021-01-14 | US | Tennessee | Van Buren | 47175 | 730 | 7 | 0 | 632 | 35.69864497 | -85.45221699 | 2021-01-15 05:22:24 | Van Buren, Tennessee, US |
2021-01-14 | US | Indiana | Warren | 18171 | 642 | 10 | 0 | 632 | 40.34728141 | -87.35602659 | 2021-01-15 05:22:24 | Warren, Indiana, US |
2021-01-14 | US | Illinois | Marshall | 17123 | 644 | 12 | 0 | 632 | 41.0327901 | -89.34510444 | 2021-01-15 05:22:24 | Marshall, Illinois, US |
2021-01-14 | US | Georgia | Wilcox | 13315 | 671 | 39 | 0 | 632 | 31.97496928 | -83.43438555 | 2021-01-15 05:22:24 | Wilcox, Georgia, US |
2021-01-14 | US | Georgia | Miller | 13201 | 635 | 3 | 0 | 632 | 31.16568912 | -84.73151117 | 2021-01-15 05:22:24 | Miller, Georgia, US |
2021-01-13 | US | Maine | Hancock | 23009 | 655 | 23 | 0 | 632 | 44.59816444 | -68.38401854 | 2021-01-14 05:22:32 | Hancock, Maine, US |
2021-01-12 | US | West Virginia | Braxton | 54007 | 633 | 1 | 0 | 632 | 38.70036159 | -80.72011184 | 2021-01-13 05:22:15 | Braxton, West Virginia, US |
2021-01-12 | US | Minnesota | Lac qui Parle | 27073 | 648 | 16 | 0 | 632 | 44.9973857 | -96.17488219 | 2021-01-13 05:22:15 | Lac qui Parle, Minnesota, US |
2021-01-12 | US | Iowa | Lucas | 19117 | 640 | 8 | 0 | 632 | 41.02958964 | -93.32780803 | 2021-01-13 05:22:15 | Lucas, Iowa, US |
2021-01-10 | Belize | 11303 | 274 | 10397 | 632 | 17.1899 | -88.4976 | 2021-01-11 05:21:50 | Belize | |||
2021-01-09 | Chile | Magallanes | 17810 | 237 | 16941 | 632 | -52.368 | -70.9863 | 2021-01-10 05:22:12 | Magallanes, Chile | ||
2021-01-08 | US | Michigan | Manistee | 26101 | 651 | 19 | 0 | 632 | 44.33352407 | -86.05626916 | 2021-01-09 05:22:18 | Manistee, Michigan, US |
2021-01-07 | US | Puerto Rico | Barranquitas | 72019 | 632 | 0 | 0 | 632 | 18.201592 | -66.30963 | 2021-01-08 05:22:42 | Barranquitas, Puerto Rico, US |
2021-01-07 | US | Kentucky | Metcalfe | 21169 | 639 | 7 | 0 | 632 | 36.99459295 | -85.63123699 | 2021-01-08 05:22:42 | Metcalfe, Kentucky, US |
2021-01-06 | US | South Dakota | Walworth | 46129 | 646 | 14 | 0 | 632 | 45.43019636 | -100.0307514 | 2021-01-07 05:22:03 | Walworth, South Dakota, US |
2021-01-05 | US | South Dakota | Brule | 46015 | 639 | 7 | 0 | 632 | 43.71756379 | -99.08118954 | 2021-01-06 05:22:16 | Brule, South Dakota, US |
2021-01-04 | US | Nebraska | Custer | 31041 | 646 | 14 | 0 | 632 | 41.39374521 | -99.72805369 | 2021-01-05 05:21:49 | Custer, Nebraska, US |
2021-01-04 | US | Iowa | Davis | 19051 | 652 | 20 | 0 | 632 | 40.74773536 | -92.41005468 | 2021-01-05 05:21:49 | Davis, Iowa, US |
2021-01-03 | US | Michigan | Leelanau | 26089 | 640 | 8 | 0 | 632 | 44.94430054 | -85.80150326 | 2021-01-04 05:22:02 | Leelanau, Michigan, US |
2021-01-02 | US | Michigan | Leelanau | 26089 | 640 | 8 | 0 | 632 | 44.94430054 | -85.80150326 | 2021-01-03 05:22:52 | Leelanau, Michigan, US |
2021-01-02 | US | Louisiana | Red River | 22081 | 661 | 29 | 0 | 632 | 32.09530039 | -93.34213308 | 2021-01-03 05:22:52 | Red River, Louisiana, US |
2021-01-02 | US | Georgia | Wilkes | 13317 | 642 | 10 | 0 | 632 | 33.78290391 | -82.74286107 | 2021-01-03 05:22:52 | Wilkes, Georgia, US |
2021-01-01 | US | Michigan | Benzie | 26019 | 658 | 26 | 0 | 632 | 44.63899297 | -86.01608482 | 2021-01-02 05:22:33 | Benzie, Michigan, US |
2021-01-01 | US | Louisiana | Red River | 22081 | 661 | 29 | 0 | 632 | 32.09530039 | -93.34213308 | 2021-01-02 05:22:33 | Red River, Louisiana, US |
2021-01-01 | US | Georgia | Hancock | 13141 | 680 | 48 | 0 | 632 | 33.2721566 | -82.99766919 | 2021-01-02 05:22:33 | Hancock, Georgia, US |
2021-01-01 | Chile | Antofagasta | 23887 | 585 | 22670 | 632 | -23.6509 | -70.3975 | 2021-01-02 05:22:33 | Antofagasta, Chile | ||
2020-12-31 | US | Missouri | Carroll | 29033 | 650 | 18 | 0 | 632 | 39.42762566 | -93.50626255 | 2021-01-01 05:23:07 | Carroll, Missouri, US |
2020-12-31 | US | Michigan | Benzie | 26019 | 658 | 26 | 0 | 632 | 44.63899297 | -86.01608482 | 2021-01-01 05:23:07 | Benzie, Michigan, US |
2020-12-31 | US | Louisiana | Red River | 22081 | 661 | 29 | 0 | 632 | 32.09530039 | -93.34213308 | 2021-01-01 05:23:07 | Red River, Louisiana, US |
2020-12-31 | US | Georgia | Turner | 13287 | 657 | 25 | 0 | 632 | 31.71612656 | -83.62069378 | 2021-01-01 05:23:07 | Turner, Georgia, US |
2020-12-30 | US | Michigan | Benzie | 26019 | 658 | 26 | 0 | 632 | 44.63899297 | -86.01608482 | 2020-12-31 05:22:49 | Benzie, Michigan, US |
2020-12-30 | US | Iowa | Monroe | 19135 | 648 | 16 | 0 | 632 | 41.02988815 | -92.8690667 | 2020-12-31 05:22:49 | Monroe, Iowa, US |
2020-12-28 | US | Missouri | Ralls | 29173 | 638 | 6 | 0 | 632 | 39.52817427 | -91.51838643 | 2020-12-29 05:22:37 | Ralls, Missouri, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;