daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
56 rows where active = 3045 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-25 | Russia | Khakassia Republic | 29219 | 714 | 25460 | 3045 | 53.72258845 | 91.44293627 | 2021-07-26 04:21:28 | Khakassia Republic, Russia | ||
2021-05-04 | Cabo Verde | 24742 | 228 | 21469 | 3045 | 16.5388 | -23.0418 | 2021-05-05 04:20:43 | Cabo Verde | |||
2021-04-24 | Russia | Altai Krai | 49189 | 2029 | 44115 | 3045 | 52.6932243 | 82.69314240000001 | 2021-04-25 04:20:32 | Altai Krai, Russia | ||
2021-04-17 | Russia | Orenburg Oblast | 41414 | 798 | 37571 | 3045 | 52.02692620000001 | 54.7276647 | 2021-04-18 04:20:41 | Orenburg Oblast, Russia | ||
2021-03-30 | Chile | Araucania | 54385 | 671 | 50669 | 3045 | -38.9489 | -72.3311 | 2021-03-31 04:26:25 | Araucania, Chile | ||
2021-02-24 | US | Missouri | Platte | 29165 | 3087 | 42 | 0 | 3045 | 39.38154439 | -94.77068479 | 2021-02-25 05:24:57 | Platte, Missouri, US |
2021-02-13 | US | Wisconsin | Green | 55045 | 3067 | 22 | 0 | 3045 | 42.6794956 | -89.60243287 | 2021-02-14 05:23:43 | Green, Wisconsin, US |
2021-02-11 | US | Ohio | Ottawa | 39123 | 3119 | 74 | 0 | 3045 | 41.53781826 | -83.0940185 | 2021-02-12 05:23:29 | Ottawa, Ohio, US |
2021-02-08 | US | New York | Columbia | 36021 | 3135 | 90 | 0 | 3045 | 42.24819348 | -73.63089095 | 2021-02-09 05:23:30 | Columbia, New York, US |
2021-02-07 | US | North Carolina | Jackson | 37099 | 3091 | 46 | 0 | 3045 | 35.28814273 | -83.14093385 | 2021-02-08 05:22:39 | Jackson, North Carolina, US |
2021-02-07 | US | Colorado | Montrose | 8085 | 3249 | 55 | 0 | 3045 | 38.40214114 | -108.26390220000002 | 2021-02-08 05:22:39 | Montrose, Colorado, US |
2021-01-30 | US | Kentucky | Greenup | 21089 | 3068 | 23 | 0 | 3045 | 38.54332505 | -82.9215658 | 2021-01-31 05:22:42 | Greenup, Kentucky, US |
2021-01-29 | US | Illinois | Christian | 17021 | 3106 | 61 | 0 | 3045 | 39.54581621 | -89.27780482 | 2021-01-30 05:22:49 | Christian, Illinois, US |
2021-01-25 | Russia | Smolensk Oblast | 21251 | 424 | 17782 | 3045 | 55.03434960000001 | 33.0192065 | 2021-01-26 05:22:02 | Smolensk Oblast, Russia | ||
2021-01-22 | US | Alaska | Bethel | 2050 | 3059 | 14 | 0 | 3045 | 60.90980451 | -159.8561831 | 2021-01-23 05:22:03 | Bethel, Alaska, US |
2021-01-18 | US | Tennessee | Carroll | 47017 | 3162 | 59 | 0 | 3045 | 35.97366108 | -88.45189331 | 2021-01-19 05:22:15 | Carroll, Tennessee, US |
2021-01-17 | US | Ohio | Crawford | 39033 | 3132 | 87 | 0 | 3045 | 40.85065156 | -82.91989099 | 2021-01-18 05:22:34 | Crawford, Ohio, US |
2021-01-17 | US | Indiana | Miami | 18103 | 3098 | 53 | 0 | 3045 | 40.76940965 | -86.04525048 | 2021-01-18 05:22:34 | Miami, Indiana, US |
2021-01-15 | Russia | Tomsk Oblast | 26496 | 235 | 23216 | 3045 | 58.6124279 | 82.04753149999998 | 2021-01-16 05:22:40 | Tomsk Oblast, Russia | ||
2021-01-11 | US | Virginia | Henry | 51089 | 3105 | 60 | 0 | 3045 | 36.68542395 | -79.87634026 | 2021-01-12 05:22:15 | Henry, Virginia, US |
2021-01-09 | US | Alabama | Russell | 1113 | 3052 | 7 | 0 | 3045 | 32.28725256 | -85.18415324 | 2021-01-10 05:22:12 | Russell, Alabama, US |
2021-01-08 | US | Michigan | Montcalm | 26117 | 3116 | 71 | 0 | 3045 | 43.31082541 | -85.15252824 | 2021-01-09 05:22:18 | Montcalm, Michigan, US |
2021-01-07 | US | Illinois | Morgan | 17137 | 3111 | 66 | 0 | 3045 | 39.71654544 | -90.20255104 | 2021-01-08 05:22:42 | Morgan, Illinois, US |
2021-01-02 | US | Kentucky | Shelby | 21211 | 3074 | 29 | 0 | 3045 | 38.21476019 | -85.194223 | 2021-01-03 05:22:52 | Shelby, Kentucky, US |
2021-01-02 | US | Florida | Unassigned | 90012 | 3045 | 0 | 0 | 3045 | 30.86747479 | 0.0 | 2021-01-03 05:22:52 | Unassigned, Florida, US |
2020-12-10 | US | Kansas | Saline | 20169 | 3087 | 42 | 0 | 3045 | 38.78369175 | -97.65185177 | 2020-12-11 05:26:59 | Saline, Kansas, US |
2020-12-09 | US | Kansas | Saline | 20169 | 3087 | 42 | 0 | 3045 | 38.78369175 | -97.65185177 | 2020-12-10 05:26:19 | Saline, Kansas, US |
2020-12-08 | US | Alabama | Autauga | 1001 | 3087 | 42 | 0 | 3045 | 32.53952745 | -86.64408227 | 2020-12-09 05:28:01 | Autauga, Alabama, US |
2020-12-08 | Russia | Orenburg Oblast | 24626 | 241 | 21340 | 3045 | 52.02692620000001 | 54.7276647 | 2020-12-09 05:28:01 | Orenburg Oblast, Russia | ||
2020-12-06 | US | Oklahoma | Wagoner | 40145 | 3083 | 38 | 0 | 3045 | 35.96024096 | -95.51911308 | 2020-12-07 05:26:14 | Wagoner, Oklahoma, US |
2020-11-23 | US | Virginia | Portsmouth | 51740 | 3115 | 70 | 0 | 3045 | 36.85914825 | -76.35971629 | 2020-11-24 05:27:31 | Portsmouth, Virginia, US |
2020-11-17 | Brazil | Acre | 33475 | 709 | 29721 | 3045 | -9.0238 | -70.812 | 2020-11-18 05:40:31 | Acre, Brazil | ||
2020-11-08 | US | Alabama | Walker | 1127 | 3141 | 96 | 0 | 3045 | 33.80270512 | -87.30027177 | 2020-11-09 05:25:45 | Walker, Alabama, US |
2020-10-24 | US | Georgia | Paulding | 13223 | 3105 | 60 | 0 | 3045 | 33.91969522 | -84.86848792 | 2020-10-25 04:24:36 | Paulding, Georgia, US |
2020-10-23 | Colombia | Santander | 39224 | 1593 | 34586 | 3045 | 6.6437 | -73.6536 | 2020-10-24 04:24:46 | Santander, Colombia | ||
2020-10-14 | US | Pennsylvania | Westmoreland | 42129 | 3109 | 64 | 0 | 3045 | 40.31377979999999 | -79.46615476 | 2020-10-15 04:24:28 | Westmoreland, Pennsylvania, US |
2020-10-14 | India | Arunachal Pradesh | 12768 | 29 | 9694 | 3045 | 27.768456 | 96.384277 | 2020-10-15 04:24:28 | Arunachal Pradesh, India | ||
2020-10-07 | US | South Carolina | Orangeburg | 45075 | 3172 | 127 | 0 | 3045 | 33.4391073 | -80.79886287 | 2020-10-08 04:23:56 | Orangeburg, South Carolina, US |
2020-09-27 | US | Wisconsin | La Crosse | 55063 | 3047 | 2 | 0 | 3045 | 43.90632465 | -91.11451093 | 2020-09-28 04:23:00 | La Crosse, Wisconsin, US |
2020-09-27 | US | Ohio | Warren | 39165 | 3096 | 51 | 0 | 3045 | 39.42581994 | -84.16557457 | 2020-09-28 04:23:00 | Warren, Ohio, US |
2020-09-26 | Uzbekistan | 54819 | 452 | 51322 | 3045 | 41.377491 | 64.585262 | 2020-09-27 04:23:00 | Uzbekistan | |||
2020-09-20 | US | South Carolina | Sumter | 45085 | 3122 | 77 | 0 | 3045 | 33.91826534 | -80.37942316 | 2020-09-21 04:23:00 | Sumter, South Carolina, US |
2020-09-19 | Italy | Veneto | 25609 | 2158 | 20406 | 3045 | 45.43490485 | 12.33845213 | 2020-09-20 04:22:00 | Veneto, Italy | ||
2020-09-06 | US | Louisiana | St. Landry | 22097 | 3161 | 116 | 0 | 3045 | 30.59724262 | -92.00135806 | 2020-09-07 04:28:30 | St. Landry, Louisiana, US |
2020-08-27 | Mexico | Guanajuato | 29912 | 1653 | 25214 | 3045 | 21.019 | -101.2574 | 2020-08-28 04:28:11 | Guanajuato, Mexico | ||
2020-08-18 | US | Florida | Columbia | 12023 | 3071 | 26 | 0 | 3045 | 30.22509788 | -82.62160164 | 2020-08-19 04:27:00 | Columbia, Florida, US |
2020-07-14 | Sweden | Skane | 3301 | 256 | 0 | 3045 | 55.9903 | 13.5958 | 2020-07-15 04:34:39 | Skane, Sweden | ||
2020-07-10 | Peru | Amazonas | 3238 | 193 | 0 | 3045 | -5.077253 | -78.050172 | 2020-07-11 04:34:26 | Amazonas, Peru | ||
2020-07-08 | US | Wisconsin | Brown | 55009 | 3087 | 42 | 0 | 3045 | 44.4526553 | -88.00411844 | 2020-07-09 04:34:23 | Brown, Wisconsin, US |
2020-07-02 | US | Florida | Manatee | 12081 | 3175 | 130 | 0 | 3045 | 27.47196942 | -82.31831044 | 2020-07-03 04:33:54 | Manatee, Florida, US |
2020-07-02 | US | New Hampshire | Hillsborough | 33011 | 3295 | 250 | 0 | 3045 | 42.91537785 | -71.7200253 | 2020-07-03 04:33:54 | Hillsborough, New Hampshire, US |
2020-05-19 | US | Iowa | Polk | 19153 | 3128 | 83 | 0 | 3045 | 41.68679484 | -93.57767461 | 2020-05-20 02:32:19 | Polk, Iowa, US |
2020-05-16 | Ireland | 24048 | 1533 | 19470 | 3045 | 53.1424 | -7.6921 | 2020-05-17 02:32:32 | Ireland | |||
2020-05-13 | Moldova | 5406 | 185 | 2176 | 3045 | 47.4116 | 28.3699 | 2020-05-14 03:32:28 | Moldova | |||
2020-05-09 | US | Maryland | Baltimore City | 24510 | 3208 | 163 | 0 | 3045 | 39.30211911 | -76.61151012 | 2020-05-10 02:32:30 | Baltimore City, Maryland, US |
2020-04-14 | Belarus | 3281 | 33 | 203 | 3045 | 53.7098 | 27.9534 | 2020-04-14 23:33:12 | Belarus |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;