daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
56 rows where active = 3341 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-05 | Sudan | 36709 | 2760 | 30608 | 3341 | 12.8628 | 30.2176 | 2021-07-06 04:21:32 | Sudan | |||
2021-03-28 | Russia | Kirov Oblast | 39479 | 321 | 35817 | 3341 | 57.9665589 | 49.4074599 | 2021-03-29 04:28:35 | Kirov Oblast, Russia | ||
2021-03-04 | US | Washington | Grays Harbor | 53027 | 3390 | 49 | 0 | 3341 | 47.14003705 | -123.7820567 | 2021-03-05 05:26:29 | Grays Harbor, Washington, US |
2021-03-04 | US | Pennsylvania | Venango | 42121 | 3425 | 84 | 0 | 3341 | 41.40323442 | -79.75845449 | 2021-03-05 05:26:29 | Venango, Pennsylvania, US |
2021-02-28 | US | Ohio | Clinton | 39027 | 3399 | 58 | 0 | 3341 | 39.41485808 | -83.80852286 | 2021-03-01 05:23:01 | Clinton, Ohio, US |
2021-02-28 | US | New Mexico | Rio Arriba | 35039 | 3405 | 64 | 0 | 3341 | 36.51072137 | -106.6931674 | 2021-03-01 05:23:01 | Rio Arriba, New Mexico, US |
2021-02-28 | US | Kansas | Harvey | 20079 | 3402 | 61 | 0 | 3341 | 38.04293782 | -97.42747573 | 2021-03-01 05:23:01 | Harvey, Kansas, US |
2021-02-27 | US | Louisiana | Iberville | 22047 | 3432 | 91 | 0 | 3341 | 30.25734305 | -91.3499598 | 2021-02-28 05:22:20 | Iberville, Louisiana, US |
2021-02-27 | US | Kansas | Harvey | 20079 | 3402 | 61 | 0 | 3341 | 38.04293782 | -97.42747573 | 2021-02-28 05:22:20 | Harvey, Kansas, US |
2021-02-26 | US | Louisiana | Iberville | 22047 | 3432 | 91 | 0 | 3341 | 30.25734305 | -91.3499598 | 2021-02-27 05:22:28 | Iberville, Louisiana, US |
2021-02-26 | US | Kansas | Harvey | 20079 | 3402 | 61 | 0 | 3341 | 38.04293782 | -97.42747573 | 2021-02-27 05:22:28 | Harvey, Kansas, US |
2021-02-22 | US | Texas | Bee | 48025 | 4080 | 62 | 0 | 3341 | 28.41761668 | -97.74215593 | 2021-02-23 05:23:41 | Bee, Texas, US |
2021-02-18 | US | Texas | Cooke | 48097 | 3567 | 58 | 0 | 3341 | 33.63979567 | -97.21240912 | 2021-02-19 05:24:16 | Cooke, Texas, US |
2021-02-17 | US | Texas | Cooke | 48097 | 3567 | 58 | 0 | 3341 | 33.63979567 | -97.21240912 | 2021-02-18 05:22:58 | Cooke, Texas, US |
2021-02-15 | US | Missouri | Butler | 29023 | 3371 | 30 | 0 | 3341 | 36.71462476 | -90.40421163 | 2021-02-16 05:24:38 | Butler, Missouri, US |
2021-02-15 | US | Illinois | Montgomery | 17135 | 3408 | 67 | 0 | 3341 | 39.23198845 | -89.47809254 | 2021-02-16 05:24:38 | Montgomery, Illinois, US |
2021-02-14 | US | North Carolina | Davie | 37059 | 3364 | 23 | 0 | 3341 | 35.93099927 | -80.54496571 | 2021-02-15 05:24:49 | Davie, North Carolina, US |
2021-02-14 | US | Michigan | Montcalm | 26117 | 3425 | 84 | 0 | 3341 | 43.31082541 | -85.15252824 | 2021-02-15 05:24:49 | Montcalm, Michigan, US |
2021-02-13 | US | Michigan | Montcalm | 26117 | 3425 | 84 | 0 | 3341 | 43.31082541 | -85.15252824 | 2021-02-14 05:23:43 | Montcalm, Michigan, US |
2021-02-07 | US | Georgia | Oconee | 13219 | 3394 | 53 | 0 | 3341 | 33.83749973 | -83.43679568 | 2021-02-08 05:22:39 | Oconee, Georgia, US |
2021-02-05 | US | North Carolina | Yadkin | 37197 | 3381 | 40 | 0 | 3341 | 36.16222629 | -80.66239436 | 2021-02-06 05:23:55 | Yadkin, North Carolina, US |
2021-02-05 | Italy | Basilicata | 13524 | 331 | 9852 | 3341 | 40.63947052 | 15.80514834 | 2021-02-06 05:23:55 | Basilicata, Italy | ||
2021-02-03 | US | Washington | Lewis | 53041 | 3380 | 39 | 0 | 3341 | 46.57756476 | -122.3925769 | 2021-02-04 05:22:26 | Lewis, Washington, US |
2021-02-01 | India | Gujarat | 261838 | 4388 | 254109 | 3341 | 22.694884 | 71.590923 | 2021-02-02 05:22:49 | Gujarat, India | ||
2021-01-31 | US | Arkansas | Independence | 5063 | 3454 | 113 | 0 | 3341 | 35.74242707 | -91.57001641 | 2021-02-01 05:22:53 | Independence, Arkansas, US |
2021-01-26 | US | North Carolina | Alexander | 37003 | 3398 | 57 | 0 | 3341 | 35.922379600000006 | -81.17751948 | 2021-01-27 05:23:41 | Alexander, North Carolina, US |
2021-01-20 | US | Indiana | DeKalb | 18033 | 3413 | 72 | 0 | 3341 | 41.39804622 | -84.99906934 | 2021-01-21 05:22:01 | DeKalb, Indiana, US |
2021-01-15 | US | Vermont | Chittenden | 50007 | 3419 | 78 | 0 | 3341 | 44.46322849 | -73.08359212 | 2021-01-16 05:22:40 | Chittenden, Vermont, US |
2021-01-07 | Colombia | Narino | 34620 | 1041 | 30238 | 3341 | 1.2892 | -77.3579 | 2021-01-08 05:22:42 | Narino, Colombia | ||
2021-01-02 | US | Oklahoma | Kay | 40071 | 3374 | 33 | 0 | 3341 | 36.81799745 | -97.14421435 | 2021-01-03 05:22:52 | Kay, Oklahoma, US |
2021-01-02 | US | Alabama | Dale | 1045 | 3404 | 63 | 0 | 3341 | 31.43037123 | -85.61095742 | 2021-01-03 05:22:52 | Dale, Alabama, US |
2020-12-30 | US | Pennsylvania | Armstrong | 42005 | 3408 | 67 | 0 | 3341 | 40.81665618 | -79.46290811 | 2020-12-31 05:22:49 | Armstrong, Pennsylvania, US |
2020-12-19 | US | Texas | Navarro | 48349 | 3546 | 46 | 0 | 3341 | 32.04620681 | -96.47428766 | 2020-12-20 05:27:32 | Navarro, Texas, US |
2020-12-14 | Uruguay | 10029 | 95 | 6593 | 3341 | -32.5228 | -55.7658 | 2020-12-15 05:26:38 | Uruguay | |||
2020-12-13 | US | Indiana | Noble | 18113 | 3398 | 57 | 0 | 3341 | 41.39672484 | -85.41966713 | 2020-12-14 05:26:27 | Noble, Indiana, US |
2020-12-13 | Brazil | Mato Grosso | 166974 | 4259 | 158568 | 3341 | -12.6819 | -56.9211 | 2020-12-14 05:26:27 | Mato Grosso, Brazil | ||
2020-12-10 | US | Tennessee | Dickson | 47043 | 3395 | 41 | 0 | 3341 | 36.14669837 | -87.35891709 | 2020-12-11 05:26:59 | Dickson, Tennessee, US |
2020-12-06 | US | Nebraska | Madison | 31119 | 3369 | 28 | 0 | 3341 | 41.91676024 | -97.6005481 | 2020-12-07 05:26:14 | Madison, Nebraska, US |
2020-11-21 | US | Florida | Highlands | 12055 | 3479 | 138 | 0 | 3341 | 27.34254618 | -81.34071957 | 2020-11-22 05:25:45 | Highlands, Florida, US |
2020-11-10 | US | North Carolina | Wilson | 37195 | 3411 | 70 | 0 | 3341 | 35.70625477 | -77.917978 | 2020-11-11 05:25:30 | Wilson, North Carolina, US |
2020-11-08 | US | Maryland | Charles | 24017 | 3443 | 102 | 0 | 3341 | 38.51092331 | -76.98580666 | 2020-11-09 05:25:45 | Charles, Maryland, US |
2020-11-08 | US | Arkansas | Saline | 5125 | 3382 | 41 | 0 | 3341 | 34.64916145 | -92.67583224 | 2020-11-09 05:25:45 | Saline, Arkansas, US |
2020-10-26 | US | Tennessee | Sevier | 47155 | 3350 | 23 | 0 | 3341 | 35.78077323 | -83.52244332 | 2020-10-27 04:24:45 | Sevier, Tennessee, US |
2020-10-26 | US | Illinois | Kankakee | 17091 | 3421 | 80 | 0 | 3341 | 41.13746989 | -87.86205334 | 2020-10-27 04:24:45 | Kankakee, Illinois, US |
2020-09-22 | US | Tennessee | Wilson | 47189 | 3408 | 43 | 0 | 3341 | 36.15496772 | -86.29775884 | 2020-09-23 04:23:00 | Wilson, Tennessee, US |
2020-09-19 | US | Nebraska | Sarpy | 31153 | 3356 | 15 | 0 | 3341 | 41.11314181 | -96.11156432 | 2020-09-20 04:22:00 | Sarpy, Nebraska, US |
2020-09-17 | US | Georgia | Douglas | 13097 | 3410 | 69 | 0 | 3341 | 33.70291126 | -84.77026156 | 2020-09-18 05:05:00 | Douglas, Georgia, US |
2020-09-05 | Germany | Nordrhein-Westfalen | 60085 | 1823 | 54921 | 3341 | 51.4332 | 7.6616 | 2020-09-06 04:28:33 | Nordrhein-Westfalen, Germany | ||
2020-09-01 | US | Tennessee | Unassigned | 90047 | 559 | 7 | 0 | 3341 | 36.55606529 | 0.0 | 2020-09-02 04:28:25 | Unassigned, Tennessee, US |
2020-09-01 | US | Florida | Columbia | 12023 | 3379 | 38 | 0 | 3341 | 30.22509788 | -82.62160164 | 2020-09-02 04:28:25 | Columbia, Florida, US |
2020-08-26 | US | Georgia | Lowndes | 13185 | 3402 | 61 | 0 | 3341 | 30.83568832 | -83.27056716 | 2020-08-27 04:28:15 | Lowndes, Georgia, US |
2020-08-08 | US | Ohio | Summit | 39153 | 3523 | 182 | 0 | 3341 | 41.12464734 | -81.53123079 | 2020-08-09 04:34:54 | Summit, Ohio, US |
2020-08-05 | US | Tennessee | Williamson | 47187 | 3323 | 22 | 0 | 3341 | 35.89099229 | -86.89281867 | 2020-08-06 04:35:02 | Williamson, Tennessee, US |
2020-07-15 | US | Iowa | Woodbury | 19193 | 3386 | 45 | 0 | 3341 | 42.38979414 | -96.0459439 | 2020-07-16 04:44:59 | Woodbury, Iowa, US |
2020-07-12 | US | California | Marin | 6041 | 3363 | 21 | 0 | 3341 | 38.07122463 | -122.72106310000001 | 2020-07-13 04:43:04 | Marin, California, US |
2020-06-04 | Sudan | 5499 | 333 | 1825 | 3341 | 12.8628 | 30.2176 | 2020-06-05 02:33:06 | Sudan |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;