daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
50 rows where active = 3954 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 | Arunachal Pradesh | 48122 | 229 | 43939 | 3954 | 27.768456 | 96.384277 | 2021-08-01 04:21:50 | Arunachal Pradesh, India | ||
2021-07-06 | Belarus | 422521 | 3204 | 415363 | 3954 | 53.7098 | 27.9534 | 2021-07-07 04:21:20 | Belarus | |||
2021-05-28 | Qatar | 216885 | 552 | 212379 | 3954 | 25.3548 | 51.1839 | 2021-05-29 04:20:41 | Qatar | |||
2021-04-26 | Chile | Biobio | 113301 | 1854 | 107493 | 3954 | -37.4464 | -72.1416 | 2021-04-27 04:20:52 | Biobio, Chile | ||
2021-03-06 | Italy | Basilicata | 16445 | 378 | 12113 | 3954 | 40.63947052 | 15.80514834 | 2021-03-07 05:21:54 | Basilicata, Italy | ||
2021-03-05 | US | Oklahoma | Custer | 40039 | 4026 | 72 | 0 | 3954 | 35.63853802 | -99.00170785 | 2021-03-06 04:23:41 | Custer, Oklahoma, US |
2021-03-05 | India | Tamil Nadu | 853992 | 12513 | 837525 | 3954 | 11.006091 | 78.400624 | 2021-03-06 04:23:41 | Tamil Nadu, India | ||
2021-03-01 | US | Michigan | Isabella | 26073 | 4027 | 73 | 0 | 3954 | 43.64060976 | -84.84664923 | 2021-03-02 05:23:30 | Isabella, Michigan, US |
2021-02-28 | US | Virginia | Campbell | 51031 | 4009 | 55 | 0 | 3954 | 37.20553386 | -79.09678609 | 2021-03-01 05:23:01 | Campbell, Virginia, US |
2021-02-21 | US | Minnesota | Mower | 27099 | 3985 | 31 | 0 | 3954 | 43.67142874 | -92.75234549 | 2021-02-22 05:24:21 | Mower, Minnesota, US |
2021-02-20 | US | Alabama | Russell | 1113 | 3984 | 30 | 0 | 3954 | 32.28725256 | -85.18415324 | 2021-02-21 05:24:33 | Russell, Alabama, US |
2021-02-12 | US | West Virginia | Putnam | 54079 | 4028 | 74 | 0 | 3954 | 38.50782345 | -81.9082131 | 2021-02-13 05:22:12 | Putnam, West Virginia, US |
2021-02-11 | US | West Virginia | Mercer | 54055 | 4052 | 98 | 0 | 3954 | 37.40481169 | -81.11023142 | 2021-02-12 05:23:29 | Mercer, West Virginia, US |
2021-02-09 | US | Washington | Cowlitz | 53015 | 4003 | 49 | 0 | 3954 | 46.19074721 | -122.6782231 | 2021-02-10 05:22:41 | Cowlitz, Washington, US |
2021-02-08 | US | Illinois | Livingston | 17105 | 4023 | 69 | 0 | 3954 | 40.89188292 | -88.55784752 | 2021-02-09 05:23:30 | Livingston, Illinois, US |
2021-02-03 | US | New York | Genesee | 36037 | 4063 | 109 | 0 | 3954 | 43.0022601 | -78.19135193 | 2021-02-04 05:22:26 | Genesee, New York, US |
2021-01-28 | US | North Carolina | Pender | 37141 | 3996 | 42 | 0 | 3954 | 34.52265624 | -77.90352133 | 2021-01-29 05:22:23 | Pender, North Carolina, US |
2021-01-27 | US | Iowa | Des Moines | 19057 | 3997 | 43 | 0 | 3954 | 40.92012606 | -91.18326592 | 2021-01-28 05:22:24 | Des Moines, Iowa, US |
2021-01-22 | US | Mississippi | Oktibbeha | 28105 | 4035 | 81 | 0 | 3954 | 33.42491685 | -88.87905132 | 2021-01-23 05:22:03 | Oktibbeha, Mississippi, US |
2021-01-19 | Japan | Aichi | 21691 | 337 | 17400 | 3954 | 35.035551 | 137.211621 | 2021-01-20 05:21:54 | Aichi, Japan | ||
2021-01-06 | US | Ohio | Mercer | 39107 | 4033 | 79 | 0 | 3954 | 40.54043046 | -84.62912742 | 2021-01-07 05:22:03 | Mercer, Ohio, US |
2021-01-05 | US | Indiana | Dearborn | 18029 | 4003 | 49 | 0 | 3954 | 39.14647946 | -84.97333539 | 2021-01-06 05:22:16 | Dearborn, Indiana, US |
2021-01-01 | US | Oregon | Deschutes | 41017 | 3976 | 22 | 0 | 3954 | 43.91570171 | -121.2289121 | 2021-01-02 05:22:33 | Deschutes, Oregon, US |
2020-12-31 | US | Oregon | Deschutes | 41017 | 3976 | 22 | 0 | 3954 | 43.91570171 | -121.2289121 | 2021-01-01 05:23:07 | Deschutes, Oregon, US |
2020-12-26 | US | Virginia | Lynchburg | 51680 | 4002 | 48 | 0 | 3954 | 37.40021399 | -79.19888138 | 2020-12-27 05:22:55 | Lynchburg, Virginia, US |
2020-12-20 | US | Arkansas | White | 5145 | 4019 | 65 | 0 | 3954 | 35.25688493 | -91.74908296 | 2020-12-21 05:27:58 | White, Arkansas, US |
2020-12-13 | US | Georgia | Gordon | 13129 | 4014 | 60 | 0 | 3954 | 34.50487351 | -84.87296253 | 2020-12-14 05:26:27 | Gordon, Georgia, US |
2020-12-06 | US | Illinois | Whiteside | 17195 | 4053 | 99 | 0 | 3954 | 41.75509713 | -89.91556058 | 2020-12-07 05:26:14 | Whiteside, Illinois, US |
2020-12-05 | US | Wisconsin | Shawano | 55115 | 4009 | 55 | 0 | 3954 | 44.78902246 | -88.76443896 | 2020-12-06 05:26:18 | Shawano, Wisconsin, US |
2020-11-26 | US | Kentucky | Hardin | 21093 | 3983 | 29 | 0 | 3954 | 37.6976111 | -85.96319251 | 2020-11-27 05:26:53 | Hardin, Kentucky, US |
2020-11-25 | US | Kentucky | Hardin | 21093 | 3983 | 29 | 0 | 3954 | 37.6976111 | -85.96319251 | 2020-11-26 05:27:44 | Hardin, Kentucky, US |
2020-11-21 | US | Washington | Grant | 53025 | 3983 | 29 | 0 | 3954 | 47.20753737 | -119.4500749 | 2020-11-22 05:25:45 | Grant, Washington, US |
2020-11-16 | US | Missouri | Cape Girardeau | 29031 | 4012 | 58 | 0 | 3954 | 37.38489388 | -89.6843587 | 2020-11-17 05:25:54 | Cape Girardeau, Missouri, US |
2020-11-06 | US | Florida | Indian River | 12061 | 4080 | 126 | 0 | 3954 | 27.69308961 | -80.60556721 | 2020-11-07 05:24:52 | Indian River, Florida, US |
2020-11-05 | Sweden | Gavleborg | 4125 | 171 | 0 | 3954 | 61.3012 | 16.1534 | 2020-11-06 05:24:55 | Gavleborg, Sweden | ||
2020-10-31 | Russia | Karachay-Cherkess Republic | 9610 | 33 | 5623 | 3954 | 43.7368326 | 41.7267991 | 2020-11-01 04:36:19 | Karachay-Cherkess Republic, Russia | ||
2020-10-20 | US | North Carolina | Catawba | 37035 | 4013 | 59 | 0 | 3954 | 35.66211129 | -81.2132617 | 2020-10-21 04:24:14 | Catawba, North Carolina, US |
2020-10-20 | US | California | Placer | 6061 | 4012 | 56 | 0 | 3954 | 39.06167234 | -120.7240569 | 2020-10-21 04:24:14 | Placer, California, US |
2020-10-18 | US | Arizona | Mohave | 4015 | 4183 | 229 | 0 | 3954 | 35.70471703 | -113.7577902 | 2020-10-19 04:24:16 | Mohave, Arizona, US |
2020-10-11 | US | Virginia | Alexandria | 51510 | 4027 | 73 | 0 | 3954 | 38.814003 | -77.08183073 | 2020-10-12 04:23:45 | Alexandria, Virginia, US |
2020-09-28 | US | Arizona | Coconino | 4005 | 4098 | 144 | 0 | 3954 | 35.83883429 | -111.7707178 | 2020-09-29 04:23:42 | Coconino, Arizona, US |
2020-09-02 | US | Oklahoma | Cleveland | 40027 | 4019 | 65 | 0 | 3954 | 35.20413532 | -97.32519562 | 2020-09-03 04:28:22 | Cleveland, Oklahoma, US |
2020-08-26 | US | Iowa | Woodbury | 19193 | 4008 | 54 | 0 | 3954 | 42.38979414 | -96.0459439 | 2020-08-27 04:28:15 | Woodbury, Iowa, US |
2020-08-26 | Australia | New South Wales | 4006 | 52 | 0 | 3954 | -33.8688 | 151.2093 | 2020-08-27 04:28:15 | New South Wales, Australia | ||
2020-08-23 | US | South Carolina | York | 45091 | 3993 | 39 | 0 | 3954 | 34.97281497 | -81.18085944 | 2020-08-24 04:27:56 | York, South Carolina, US |
2020-08-21 | Mexico | Mexico | 63709 | 7579 | 52176 | 3954 | 19.4969 | -99.7233 | 2020-08-22 04:27:49 | Mexico, Mexico | ||
2020-07-17 | US | Tennessee | Hamilton | 47065 | 3933 | 40 | 0 | 3954 | 35.17670231 | -85.16652245 | 2020-07-18 04:34:45 | Hamilton, Tennessee, US |
2020-07-08 | US | Arizona | Navajo | 4017 | 4089 | 135 | 0 | 3954 | 35.3997715 | -110.3218983 | 2020-07-09 04:34:23 | Navajo, Arizona, US |
2020-05-17 | US | Missouri | St. Louis | 29189 | 4287 | 333 | 0 | 3954 | 38.63770039999999 | -90.4458375 | 2020-05-18 02:32:21 | St. Louis, Missouri, US |
2020-04-14 | Indonesia | 4839 | 459 | 426 | 3954 | -0.7893 | 113.9213 | 2020-04-14 23:33:12 | Indonesia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;