daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
659 rows where active = 318 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-07-26 | Colombia | Putumayo | 15152 | 618 | 14216 | 318 | 0.436 | -75.5277 | 2021-07-27 04:21:18 | Putumayo, Colombia | ||
2021-07-24 | Germany | Thuringen | 129025 | 4362 | 124400 | 318 | 51.011 | 10.8453 | 2021-07-25 04:22:12 | Thuringen, Germany | ||
2021-07-23 | Ukraine | Luhansk Oblast | 26964 | 965 | 25681 | 318 | 48.574 | 39.3078 | 2021-07-24 00:21:36 | Luhansk Oblast, Ukraine | ||
2021-07-12 | Colombia | Arauca | 11732 | 356 | 11058 | 318 | 7.0762 | -70.7105 | 2021-07-13 04:21:18 | Arauca, Colombia | ||
2021-07-06 | Bhutan | 2210 | 1 | 1891 | 318 | 27.5142 | 90.4336 | 2021-07-07 04:21:20 | Bhutan | |||
2021-07-03 | Ukraine | Poltava Oblast | 77909 | 1860 | 75731 | 318 | 49.5883 | 34.5514 | 2021-07-04 04:21:38 | Poltava Oblast, Ukraine | ||
2021-06-24 | Singapore | 62493 | 35 | 62140 | 318 | 1.2833 | 103.8333 | 2021-06-25 04:21:33 | Singapore | |||
2021-06-04 | Chile | Magallanes | 27991 | 413 | 27260 | 318 | -52.368 | -70.9863 | 2021-06-05 04:23:03 | Magallanes, Chile | ||
2021-05-29 | Japan | Aomori | 2340 | 30 | 1992 | 318 | 40.781541 | 140.828896 | 2021-05-30 04:20:55 | Aomori, Japan | ||
2021-05-28 | Japan | Toyama | 1838 | 35 | 1485 | 318 | 36.637464 | 137.26934599999998 | 2021-05-29 04:20:41 | Toyama, Japan | ||
2021-05-28 | Japan | Nara | 7719 | 114 | 7287 | 318 | 34.317451 | 135.871644 | 2021-05-29 04:20:41 | Nara, Japan | ||
2021-05-26 | Colombia | Arauca | 7455 | 217 | 6920 | 318 | 7.0762 | -70.7105 | 2021-05-27 04:20:59 | Arauca, Colombia | ||
2021-05-03 | Netherlands | Curacao | 12213 | 111 | 11784 | 318 | 12.1696 | -68.99 | 2021-05-04 04:20:34 | Curacao, Netherlands | ||
2021-04-28 | Japan | Ishikawa | 2428 | 71 | 2039 | 318 | 36.769464 | 136.771027 | 2021-04-29 04:20:55 | Ishikawa, Japan | ||
2021-04-19 | Singapore | 60851 | 30 | 60503 | 318 | 1.2833 | 103.8333 | 2021-04-20 04:20:41 | Singapore | |||
2021-04-16 | Japan | Shizuoka | 6111 | 121 | 5672 | 318 | 34.916975 | 138.40778400000002 | 2021-04-17 04:20:40 | Shizuoka, Japan | ||
2021-04-15 | Japan | Wakayama | 1666 | 19 | 1329 | 318 | 33.911879 | 135.505446 | 2021-04-16 04:20:46 | Wakayama, Japan | ||
2021-04-01 | Japan | Ehime | 1396 | 24 | 1054 | 318 | 33.624835 | 132.856842 | 2021-04-02 04:20:36 | Ehime, Japan | ||
2021-03-24 | France | Wallis and Futuna | 338 | 2 | 18 | 318 | -14.2938 | -178.1165 | 2021-03-25 05:27:00 | Wallis and Futuna, France | ||
2021-03-24 | Colombia | La Guajira | 17180 | 648 | 16214 | 318 | 11.3548 | -72.5205 | 2021-03-25 05:27:00 | La Guajira, Colombia | ||
2021-03-15 | Japan | Okinawa | 8512 | 122 | 8072 | 318 | 25.768923 | 126.668016 | 2021-03-16 05:25:13 | Okinawa, Japan | ||
2021-03-06 | Niger | 4740 | 172 | 4250 | 318 | 17.607789 | 8.081666 | 2021-03-07 05:21:54 | Niger | |||
2021-03-05 | Niger | 4740 | 172 | 4250 | 318 | 17.607789 | 8.081666 | 2021-03-06 04:23:41 | Niger | |||
2021-03-04 | Niger | 4740 | 172 | 4250 | 318 | 17.607789 | 8.081666 | 2021-03-05 05:26:29 | Niger | |||
2021-03-03 | US | South Dakota | Marshall | 46091 | 323 | 5 | 0 | 318 | 45.75870838 | -97.59855639 | 2021-03-04 05:24:24 | Marshall, South Dakota, US |
2021-03-03 | US | Kentucky | Hickman | 21105 | 325 | 7 | 0 | 318 | 36.67948079999999 | -88.97875928 | 2021-03-04 05:24:24 | Hickman, Kentucky, US |
2021-03-03 | US | Georgia | Schley | 13249 | 322 | 4 | 0 | 318 | 32.2654021 | -84.31258912 | 2021-03-04 05:24:24 | Schley, Georgia, US |
2021-03-03 | Niger | 4740 | 172 | 4250 | 318 | 17.607789 | 8.081666 | 2021-03-04 05:24:24 | Niger | |||
2021-03-02 | US | Georgia | Schley | 13249 | 321 | 3 | 0 | 318 | 32.2654021 | -84.31258912 | 2021-03-03 05:23:28 | Schley, Georgia, US |
2021-03-02 | Niger | 4740 | 172 | 4250 | 318 | 17.607789 | 8.081666 | 2021-03-03 05:23:28 | Niger | |||
2021-03-01 | Niger | 4740 | 172 | 4250 | 318 | 17.607789 | 8.081666 | 2021-03-02 05:23:30 | Niger | |||
2021-02-28 | US | West Virginia | Webster | 54101 | 321 | 3 | 0 | 318 | 38.49370949 | -80.4202023 | 2021-03-01 05:23:01 | Webster, West Virginia, US |
2021-02-28 | Niger | 4740 | 172 | 4250 | 318 | 17.607789 | 8.081666 | 2021-03-01 05:23:01 | Niger | |||
2021-02-28 | India | Himachal Pradesh | 58645 | 995 | 57332 | 318 | 31.927213 | 77.233081 | 2021-03-01 05:23:01 | Himachal Pradesh, India | ||
2021-02-27 | Niger | 4740 | 172 | 4250 | 318 | 17.607789 | 8.081666 | 2021-02-28 05:22:20 | Niger | |||
2021-02-26 | US | Puerto Rico | Rincon | 72117 | 318 | 0 | 0 | 318 | 18.335443 | -67.23174 | 2021-02-27 05:22:28 | Rincon, Puerto Rico, US |
2021-02-26 | Niger | 4740 | 172 | 4250 | 318 | 17.607789 | 8.081666 | 2021-02-27 05:22:28 | Niger | |||
2021-02-26 | Andorra | 10822 | 110 | 10394 | 318 | 42.5063 | 1.5218 | 2021-02-27 05:22:28 | Andorra | |||
2021-02-25 | Niger | 4740 | 172 | 4250 | 318 | 17.607789 | 8.081666 | 2021-02-26 05:22:40 | Niger | |||
2021-02-24 | Niger | 4740 | 172 | 4250 | 318 | 17.607789 | 8.081666 | 2021-02-25 05:24:57 | Niger | |||
2021-02-23 | Niger | 4740 | 172 | 4250 | 318 | 17.607789 | 8.081666 | 2021-02-24 05:29:16 | Niger | |||
2021-02-22 | Niger | 4740 | 172 | 4250 | 318 | 17.607789 | 8.081666 | 2021-02-23 05:23:41 | Niger | |||
2021-02-17 | US | Idaho | Adams | 16003 | 321 | 3 | 0 | 318 | 44.89333571 | -116.4545247 | 2021-02-18 05:22:58 | Adams, Idaho, US |
2021-02-14 | US | Colorado | Phillips | 8095 | 353 | 13 | 0 | 318 | 40.59414277 | -102.3577703 | 2021-02-15 05:24:49 | Phillips, Colorado, US |
2021-02-13 | US | Virginia | Falls Church | 51610 | 325 | 7 | 0 | 318 | 38.88485255 | -77.17560759 | 2021-02-14 05:23:43 | Falls Church, Virginia, US |
2021-02-13 | US | Colorado | Phillips | 8095 | 353 | 13 | 0 | 318 | 40.59414277 | -102.3577703 | 2021-02-14 05:23:43 | Phillips, Colorado, US |
2021-02-12 | US | Colorado | Phillips | 8095 | 351 | 13 | 0 | 318 | 40.59414277 | -102.3577703 | 2021-02-13 05:22:12 | Phillips, Colorado, US |
2021-02-11 | US | Colorado | Phillips | 8095 | 351 | 13 | 0 | 318 | 40.59414277 | -102.3577703 | 2021-02-12 05:23:29 | Phillips, Colorado, US |
2021-02-11 | Sao Tome and Principe | 1431 | 19 | 1094 | 318 | 0.1864 | 6.6131 | 2021-02-12 05:23:29 | Sao Tome and Principe | |||
2021-02-09 | US | South Dakota | Stanley | 46117 | 320 | 2 | 0 | 318 | 44.41381872 | -100.7349153 | 2021-02-10 05:22:41 | Stanley, South Dakota, US |
2021-02-09 | US | South Dakota | Hand | 46059 | 324 | 6 | 0 | 318 | 44.54708407 | -99.00386459 | 2021-02-10 05:22:41 | Hand, South Dakota, US |
2021-02-09 | US | Kansas | Stafford | 20185 | 327 | 9 | 0 | 318 | 38.03100851 | -98.71762001 | 2021-02-10 05:22:41 | Stafford, Kansas, US |
2021-02-09 | US | Colorado | Phillips | 8095 | 351 | 13 | 0 | 318 | 40.59414277 | -102.3577703 | 2021-02-10 05:22:41 | Phillips, Colorado, US |
2021-02-09 | Netherlands | Aruba | 7286 | 66 | 6902 | 318 | 12.5211 | -69.9683 | 2021-02-10 05:22:41 | Aruba, Netherlands | ||
2021-02-08 | US | Washington | Lincoln | 53043 | 322 | 4 | 0 | 318 | 47.57705241 | -118.4194388 | 2021-02-09 05:23:30 | Lincoln, Washington, US |
2021-02-08 | US | South Dakota | Stanley | 46117 | 320 | 2 | 0 | 318 | 44.41381872 | -100.7349153 | 2021-02-09 05:23:30 | Stanley, South Dakota, US |
2021-02-08 | US | Kansas | Stafford | 20185 | 327 | 9 | 0 | 318 | 38.03100851 | -98.71762001 | 2021-02-09 05:23:30 | Stafford, Kansas, US |
2021-02-08 | US | Colorado | Phillips | 8095 | 351 | 13 | 0 | 318 | 40.59414277 | -102.3577703 | 2021-02-09 05:23:30 | Phillips, Colorado, US |
2021-02-08 | US | Alaska | Nome | 2180 | 318 | 0 | 0 | 318 | 64.90320724 | -164.0353804 | 2021-02-09 05:23:30 | Nome, Alaska, US |
2021-02-07 | US | South Dakota | Stanley | 46117 | 320 | 2 | 0 | 318 | 44.41381872 | -100.7349153 | 2021-02-08 05:22:39 | Stanley, South Dakota, US |
2021-02-07 | US | Colorado | Phillips | 8095 | 350 | 13 | 0 | 318 | 40.59414277 | -102.3577703 | 2021-02-08 05:22:39 | Phillips, Colorado, US |
2021-02-06 | US | South Dakota | Stanley | 46117 | 320 | 2 | 0 | 318 | 44.41381872 | -100.7349153 | 2021-02-07 05:23:00 | Stanley, South Dakota, US |
2021-02-06 | US | Colorado | Phillips | 8095 | 350 | 13 | 0 | 318 | 40.59414277 | -102.3577703 | 2021-02-07 05:23:00 | Phillips, Colorado, US |
2021-02-05 | US | South Dakota | Stanley | 46117 | 320 | 2 | 0 | 318 | 44.41381872 | -100.7349153 | 2021-02-06 05:23:55 | Stanley, South Dakota, US |
2021-02-04 | Japan | Hiroshima | 4864 | 94 | 4452 | 318 | 34.605309000000005 | 132.788719 | 2021-02-05 05:22:38 | Hiroshima, Japan | ||
2021-02-02 | US | Texas | Kinney | 48271 | 375 | 4 | 0 | 318 | 29.34967888 | -100.4186638 | 2021-02-03 05:22:52 | Kinney, Texas, US |
2021-02-01 | US | Texas | Kinney | 48271 | 375 | 4 | 0 | 318 | 29.34967888 | -100.4186638 | 2021-02-02 05:22:49 | Kinney, Texas, US |
2021-02-01 | US | Minnesota | Red Lake | 27125 | 322 | 4 | 0 | 318 | 47.87197525 | -96.09561104 | 2021-02-02 05:22:49 | Red Lake, Minnesota, US |
2021-01-31 | US | Texas | Kinney | 48271 | 375 | 4 | 0 | 318 | 29.34967888 | -100.4186638 | 2021-02-01 05:22:53 | Kinney, Texas, US |
2021-01-30 | US | Minnesota | Red Lake | 27125 | 322 | 4 | 0 | 318 | 47.87197525 | -96.09561104 | 2021-01-31 05:22:42 | Red Lake, Minnesota, US |
2021-01-29 | US | Minnesota | Red Lake | 27125 | 322 | 4 | 0 | 318 | 47.87197525 | -96.09561104 | 2021-01-30 05:22:49 | Red Lake, Minnesota, US |
2021-01-28 | US | Minnesota | Red Lake | 27125 | 322 | 4 | 0 | 318 | 47.87197525 | -96.09561104 | 2021-01-29 05:22:23 | Red Lake, Minnesota, US |
2021-01-27 | US | Texas | Hardeman | 48197 | 322 | 12 | 0 | 318 | 34.28944521 | -99.74632408 | 2021-01-28 05:22:24 | Hardeman, Texas, US |
2021-01-27 | US | Texas | Goliad | 48175 | 411 | 9 | 0 | 318 | 28.65696592 | -97.42760647 | 2021-01-28 05:22:24 | Goliad, Texas, US |
2021-01-27 | US | New Mexico | Guadalupe | 35019 | 326 | 8 | 0 | 318 | 34.86319296 | -104.790669 | 2021-01-28 05:22:24 | Guadalupe, New Mexico, US |
2021-01-27 | US | Minnesota | Red Lake | 27125 | 322 | 4 | 0 | 318 | 47.87197525 | -96.09561104 | 2021-01-28 05:22:24 | Red Lake, Minnesota, US |
2021-01-27 | Japan | Fukushima | 1678 | 40 | 1320 | 318 | 37.378867 | 140.223295 | 2021-01-28 05:22:24 | Fukushima, Japan | ||
2021-01-26 | US | Texas | Goliad | 48175 | 411 | 9 | 0 | 318 | 28.65696592 | -97.42760647 | 2021-01-27 05:23:41 | Goliad, Texas, US |
2021-01-25 | US | Texas | Goliad | 48175 | 411 | 9 | 0 | 318 | 28.65696592 | -97.42760647 | 2021-01-26 05:22:02 | Goliad, Texas, US |
2021-01-25 | Pakistan | Azad Jammu and Kashmir | 8855 | 257 | 8280 | 318 | 34.027401 | 73.947253 | 2021-01-26 05:22:02 | Azad Jammu and Kashmir, Pakistan | ||
2021-01-22 | US | West Virginia | Clay | 54015 | 322 | 4 | 0 | 318 | 38.46231092 | -81.07652217 | 2021-01-23 05:22:03 | Clay, West Virginia, US |
2021-01-22 | US | Texas | Hartley | 48205 | 485 | 2 | 0 | 318 | 35.84008013 | -102.6029022 | 2021-01-23 05:22:03 | Hartley, Texas, US |
2021-01-21 | US | Oregon | Curry | 41015 | 323 | 5 | 0 | 318 | 42.45911325 | -124.157282 | 2021-01-22 05:22:10 | Curry, Oregon, US |
2021-01-20 | US | Oregon | Curry | 41015 | 323 | 5 | 0 | 318 | 42.45911325 | -124.157282 | 2021-01-21 05:22:01 | Curry, Oregon, US |
2021-01-20 | Canada | New Brunswick | 1025 | 13 | 694 | 318 | 46.5653 | -66.4619 | 2021-01-21 05:22:01 | New Brunswick, Canada | ||
2021-01-17 | US | Michigan | Oscoda | 26135 | 337 | 19 | 0 | 318 | 44.68192279 | -84.12939244 | 2021-01-18 05:22:34 | Oscoda, Michigan, US |
2021-01-16 | US | South Dakota | Sanborn | 46111 | 321 | 3 | 0 | 318 | 44.02351092 | -98.0909816 | 2021-01-17 05:22:17 | Sanborn, South Dakota, US |
2021-01-16 | US | Michigan | Oscoda | 26135 | 337 | 19 | 0 | 318 | 44.68192279 | -84.12939244 | 2021-01-17 05:22:17 | Oscoda, Michigan, US |
2021-01-15 | US | Texas | Carson | 48065 | 599 | 11 | 0 | 318 | 35.40365929 | -101.3542669 | 2021-01-16 05:22:40 | Carson, Texas, US |
2021-01-15 | US | South Dakota | Sanborn | 46111 | 321 | 3 | 0 | 318 | 44.02351092 | -98.0909816 | 2021-01-16 05:22:40 | Sanborn, South Dakota, US |
2021-01-15 | US | Michigan | Oscoda | 26135 | 337 | 19 | 0 | 318 | 44.68192279 | -84.12939244 | 2021-01-16 05:22:40 | Oscoda, Michigan, US |
2021-01-14 | US | Texas | Carson | 48065 | 599 | 11 | 0 | 318 | 35.40365929 | -101.3542669 | 2021-01-15 05:22:24 | Carson, Texas, US |
2021-01-13 | US | Texas | Carson | 48065 | 599 | 11 | 0 | 318 | 35.40365929 | -101.3542669 | 2021-01-14 05:22:32 | Carson, Texas, US |
2021-01-13 | US | South Dakota | Ziebach | 46137 | 326 | 8 | 0 | 318 | 44.97881876 | -101.6654622 | 2021-01-14 05:22:32 | Ziebach, South Dakota, US |
2021-01-13 | US | Missouri | Shelby | 29205 | 322 | 4 | 0 | 318 | 39.79742518 | -92.07634971 | 2021-01-14 05:22:32 | Shelby, Missouri, US |
2021-01-12 | US | Nebraska | Nuckolls | 31129 | 319 | 1 | 0 | 318 | 40.17637905 | -98.04743961 | 2021-01-13 05:22:15 | Nuckolls, Nebraska, US |
2021-01-12 | US | Montana | Sweet Grass | 30097 | 324 | 6 | 0 | 318 | 45.81367654 | -109.9425686 | 2021-01-13 05:22:15 | Sweet Grass, Montana, US |
2021-01-12 | US | Kansas | Barber | 20007 | 321 | 3 | 0 | 318 | 37.2288586 | -98.68460053 | 2021-01-13 05:22:15 | Barber, Kansas, US |
2021-01-11 | US | Kansas | Barber | 20007 | 321 | 3 | 0 | 318 | 37.2288586 | -98.68460053 | 2021-01-12 05:22:15 | Barber, Kansas, US |
2021-01-10 | US | South Dakota | Hanson | 46061 | 321 | 3 | 0 | 318 | 43.6746384 | -97.78715148 | 2021-01-11 05:21:50 | Hanson, South Dakota, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;