daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
68 rows where active = 2774 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-19 | Russia | Karelia Republic | 53702 | 686 | 50242 | 2774 | 62.61940309999999 | 33.4920267 | 2021-07-20 04:21:48 | Karelia Republic, Russia | ||
2021-07-17 | Russia | Saratov Oblast | 69645 | 1553 | 65318 | 2774 | 51.6520555 | 46.86319520000001 | 2021-07-18 04:22:07 | Saratov Oblast, Russia | ||
2021-07-07 | Russia | Yaroslavl Oblast | 44926 | 738 | 41414 | 2774 | 57.77819760000001 | 39.0021095 | 2021-07-08 04:21:26 | Yaroslavl Oblast, Russia | ||
2021-06-15 | Ukraine | Dnipropetrovsk Oblast | 135012 | 4373 | 127865 | 2774 | 48.4647 | 35.0462 | 2021-06-16 04:22:32 | Dnipropetrovsk Oblast, Ukraine | ||
2021-05-27 | Russia | Altai Krai | 51404 | 2266 | 46364 | 2774 | 52.6932243 | 82.69314240000001 | 2021-05-28 04:20:36 | Altai Krai, Russia | ||
2021-05-24 | Russia | Saratov Oblast | 61929 | 1040 | 58115 | 2774 | 51.6520555 | 46.86319520000001 | 2021-05-25 04:21:08 | Saratov Oblast, Russia | ||
2021-05-20 | Russia | Chelyabinsk Oblast | 60861 | 1558 | 56529 | 2774 | 54.4223954 | 61.1865846 | 2021-05-21 04:20:43 | Chelyabinsk Oblast, Russia | ||
2021-03-20 | India | Uttar Pradesh | 607050 | 8758 | 595518 | 2774 | 26.925425 | 80.560982 | 2021-03-21 05:25:44 | Uttar Pradesh, India | ||
2021-03-08 | Luxembourg | 56677 | 663 | 53240 | 2774 | 49.8153 | 6.1296 | 2021-03-09 05:28:19 | Luxembourg | |||
2021-03-01 | US | South Dakota | Yankton | 46135 | 2802 | 28 | 0 | 2774 | 43.00924485 | -97.39467635 | 2021-03-02 05:23:30 | Yankton, South Dakota, US |
2021-02-28 | US | South Dakota | Yankton | 46135 | 2802 | 28 | 0 | 2774 | 43.00924485 | -97.39467635 | 2021-03-01 05:23:01 | Yankton, South Dakota, US |
2021-02-28 | India | Chhattisgarh | 312560 | 3835 | 305951 | 2774 | 21.264705 | 82.035366 | 2021-03-01 05:23:01 | Chhattisgarh, India | ||
2021-02-27 | US | New York | Warren | 36113 | 2829 | 55 | 0 | 2774 | 43.56173026 | -73.8433699 | 2021-02-28 05:22:20 | Warren, New York, US |
2021-02-26 | US | South Dakota | Lawrence | 46081 | 2819 | 45 | 0 | 2774 | 44.35919441 | -103.7929428 | 2021-02-27 05:22:28 | Lawrence, South Dakota, US |
2021-02-26 | US | Missouri | Howell | 29091 | 2816 | 42 | 0 | 2774 | 36.77383887 | -91.88683935 | 2021-02-27 05:22:28 | Howell, Missouri, US |
2021-02-25 | US | Missouri | Howell | 29091 | 2816 | 42 | 0 | 2774 | 36.77383887 | -91.88683935 | 2021-02-26 05:22:40 | Howell, Missouri, US |
2021-02-21 | US | Minnesota | Pine | 27115 | 2790 | 16 | 0 | 2774 | 46.12105238 | -92.74070188 | 2021-02-22 05:24:21 | Pine, Minnesota, US |
2021-02-21 | Luxembourg | 53782 | 622 | 50386 | 2774 | 49.8153 | 6.1296 | 2021-02-22 05:24:21 | Luxembourg | |||
2021-02-20 | Luxembourg | 53782 | 622 | 50386 | 2774 | 49.8153 | 6.1296 | 2021-02-21 05:24:33 | Luxembourg | |||
2021-02-19 | Luxembourg | 53782 | 622 | 50386 | 2774 | 49.8153 | 6.1296 | 2021-02-20 05:22:51 | Luxembourg | |||
2021-02-17 | US | Utah | Southeast Utah | 2794 | 20 | 0 | 2774 | 38.99617072 | -110.7013958 | 2021-02-18 05:22:58 | Southeast Utah, Utah, US | |
2021-02-13 | US | North Carolina | Bladen | 37017 | 2812 | 38 | 0 | 2774 | 34.61296243 | -78.56180059 | 2021-02-14 05:23:43 | Bladen, North Carolina, US |
2021-02-10 | US | Mississippi | Scott | 28123 | 2839 | 65 | 0 | 2774 | 32.406704100000006 | -89.53789439 | 2021-02-11 05:23:55 | Scott, Mississippi, US |
2021-02-09 | US | Indiana | Jefferson | 18077 | 2836 | 62 | 0 | 2774 | 38.78576239 | -85.43633383 | 2021-02-10 05:22:41 | Jefferson, Indiana, US |
2021-02-05 | US | Idaho | Cassia | 16031 | 2797 | 23 | 0 | 2774 | 42.28347888 | -113.6012409 | 2021-02-06 05:23:55 | Cassia, Idaho, US |
2021-02-05 | US | Georgia | Chattahoochee | 13053 | 2779 | 5 | 0 | 2774 | 32.34341231 | -84.78809239 | 2021-02-06 05:23:55 | Chattahoochee, Georgia, US |
2021-02-04 | US | Indiana | White | 18181 | 2825 | 51 | 0 | 2774 | 40.74911165 | -86.86492015 | 2021-02-05 05:22:38 | White, Indiana, US |
2021-01-29 | US | Texas | Upshur | 48459 | 3110 | 44 | 0 | 2774 | 32.73706798 | -94.93999853 | 2021-01-30 05:22:49 | Upshur, Texas, US |
2021-01-29 | US | Oklahoma | Adair | 40001 | 2793 | 19 | 0 | 2774 | 35.88494195 | -94.65859267 | 2021-01-30 05:22:49 | Adair, Oklahoma, US |
2021-01-28 | US | New York | Columbia | 36021 | 2853 | 79 | 0 | 2774 | 42.24819348 | -73.63089095 | 2021-01-29 05:22:23 | Columbia, New York, US |
2021-01-28 | Russia | Orel Oblast | 26235 | 340 | 23121 | 2774 | 52.96854329999999 | 36.0692477 | 2021-01-29 05:22:23 | Orel Oblast, Russia | ||
2021-01-23 | Colombia | Huila | 43430 | 1354 | 39302 | 2774 | 2.5359 | -75.5277 | 2021-01-24 05:22:35 | Huila, Colombia | ||
2021-01-16 | US | Florida | Baker | 12003 | 2814 | 40 | 0 | 2774 | 30.33060121 | -82.28467476 | 2021-01-17 05:22:17 | Baker, Florida, US |
2021-01-13 | US | Maryland | Calvert | 24009 | 2821 | 47 | 0 | 2774 | 38.53961642 | -76.56820632 | 2021-01-14 05:22:32 | Calvert, Maryland, US |
2021-01-06 | Russia | Tatarstan Republic | 13818 | 203 | 10841 | 2774 | 55.7648572 | 52.43104273 | 2021-01-07 05:22:03 | Tatarstan Republic, Russia | ||
2020-12-30 | US | Tennessee | Cocke | 47029 | 2821 | 40 | 0 | 2774 | 35.9278914 | -83.11828725 | 2020-12-31 05:22:49 | Cocke, Tennessee, US |
2020-12-28 | US | North Carolina | Chatham | 37037 | 2839 | 65 | 0 | 2774 | 35.70394416 | -79.25541492 | 2020-12-29 05:22:37 | Chatham, North Carolina, US |
2020-12-28 | US | Illinois | Jefferson | 17081 | 2850 | 76 | 0 | 2774 | 38.29980057 | -88.9240025 | 2020-12-29 05:22:37 | Jefferson, Illinois, US |
2020-12-27 | US | Virginia | Washington | 51191 | 2817 | 43 | 0 | 2774 | 36.72341572 | -81.95666289 | 2020-12-28 05:22:06 | Washington, Virginia, US |
2020-12-26 | US | Tennessee | Henderson | 47077 | 2848 | 41 | 0 | 2774 | 35.65581134 | -88.38600175 | 2020-12-27 05:22:55 | Henderson, Tennessee, US |
2020-12-26 | Russia | Sakhalin Oblast | 15005 | 15 | 12216 | 2774 | 49.7219665 | 143.448533 | 2020-12-27 05:22:55 | Sakhalin Oblast, Russia | ||
2020-12-21 | US | Illinois | Morgan | 17137 | 2834 | 60 | 0 | 2774 | 39.71654544 | -90.20255104 | 2020-12-22 05:22:33 | Morgan, Illinois, US |
2020-12-19 | US | Oklahoma | Texas | 40139 | 2789 | 15 | 0 | 2774 | 36.74777635 | -101.4889765 | 2020-12-20 05:27:32 | Texas, Oklahoma, US |
2020-12-19 | US | Ohio | Athens | 39009 | 2797 | 23 | 0 | 2774 | 39.33425634 | -82.04278644 | 2020-12-20 05:27:32 | Athens, Ohio, US |
2020-12-10 | US | Alabama | Franklin | 1059 | 2808 | 34 | 0 | 2774 | 34.44235334 | -87.84289505 | 2020-12-11 05:26:59 | Franklin, Alabama, US |
2020-12-04 | US | Missouri | Scott | 29201 | 2816 | 42 | 0 | 2774 | 37.05588075 | -89.56474493 | 2020-12-05 05:27:36 | Scott, Missouri, US |
2020-11-21 | US | New Mexico | Curry | 35009 | 2790 | 16 | 0 | 2774 | 34.57421077 | -103.3468876 | 2020-11-22 05:25:45 | Curry, New Mexico, US |
2020-11-20 | US | North Carolina | Craven | 37049 | 2842 | 68 | 0 | 2774 | 35.11833364 | -77.08398081 | 2020-11-21 05:25:51 | Craven, North Carolina, US |
2020-11-17 | US | North Carolina | Henderson | 37089 | 2844 | 70 | 0 | 2774 | 35.33788927 | -82.4766782 | 2020-11-18 05:40:31 | Henderson, North Carolina, US |
2020-11-13 | US | Texas | Bowie | 48037 | 2605 | 88 | 0 | 2774 | 33.44626922 | -94.41834132 | 2020-11-14 05:25:37 | Bowie, Texas, US |
2020-11-13 | US | Nebraska | Dakota | 31043 | 2823 | 49 | 0 | 2774 | 42.39040144 | -96.56656425 | 2020-11-14 05:25:37 | Dakota, Nebraska, US |
2020-11-09 | US | Oklahoma | Muskogee | 40101 | 2802 | 28 | 0 | 2774 | 35.61318461 | -95.37802952 | 2020-11-10 05:40:07 | Muskogee, Oklahoma, US |
2020-11-05 | US | Colorado | Pueblo | 8101 | 3871 | 84 | 0 | 2774 | 38.17359144 | -104.5127437 | 2020-11-06 05:24:55 | Pueblo, Colorado, US |
2020-10-31 | US | Arkansas | Pope | 5115 | 2811 | 37 | 0 | 2774 | 35.44871474 | -93.03212219 | 2020-11-01 04:36:19 | Pope, Arkansas, US |
2020-10-27 | US | Wisconsin | Jefferson | 55055 | 2785 | 11 | 0 | 2774 | 43.02054068 | -88.77529134 | 2020-10-28 04:24:39 | Jefferson, Wisconsin, US |
2020-10-22 | Sweden | Dalarna | 2957 | 183 | 0 | 2774 | 61.0917 | 14.6664 | 2020-10-23 04:24:46 | Dalarna, Sweden | ||
2020-10-15 | US | Oregon | Clackamas | 41005 | 2839 | 65 | 0 | 2774 | 45.18787398 | -122.2179634 | 2020-10-16 04:24:01 | Clackamas, Oregon, US |
2020-10-13 | US | Florida | Suwannee | 12121 | 2849 | 75 | 0 | 2774 | 30.19746066 | -82.99099670000003 | 2020-10-14 04:24:05 | Suwannee, Florida, US |
2020-10-13 | Croatia | 20993 | 330 | 17889 | 2774 | 45.1 | 15.2 | 2020-10-14 04:24:05 | Croatia | |||
2020-09-23 | Senegal | 14795 | 303 | 11718 | 2774 | 14.4974 | -14.4524 | 2020-09-24 04:23:00 | Senegal | |||
2020-09-18 | US | Tennessee | Unassigned | 90047 | 726 | 6 | 0 | 2774 | 36.55606529 | 0.0 | 2020-09-19 04:22:00 | Unassigned, Tennessee, US |
2020-08-21 | North Macedonia | 13308 | 557 | 9977 | 2774 | 41.6086 | 21.7453 | 2020-08-22 04:27:49 | North Macedonia | |||
2020-08-19 | Colombia | Cesar | 6439 | 139 | 3526 | 2774 | 9.3373 | -73.6536 | 2020-08-20 04:27:43 | Cesar, Colombia | ||
2020-07-29 | US | North Dakota | Cass | 38017 | 2881 | 76 | 0 | 2774 | 46.93201724 | -97.2444719 | 2020-07-30 04:35:05 | Cass, North Dakota, US |
2020-07-08 | US | Colorado | Weld | 8123 | 3143 | 135 | 0 | 2774 | 40.55499405 | -104.39296209999999 | 2020-07-09 04:34:23 | Weld, Colorado, US |
2020-06-26 | US | California | Santa Barbara | 6083 | 2810 | 25 | 0 | 2774 | 34.65329488 | -120.0188492 | 2020-06-27 04:33:35 | Santa Barbara, California, US |
2020-06-17 | US | Georgia | Out of GA | 80013 | 2813 | 39 | 0 | 2774 | 34.91369188 | 0.0 | 2020-06-18 04:33:18 | Out of GA, Georgia, US |
2020-05-29 | Peru | Arequipa | 2921 | 147 | 0 | 2774 | -15.843523999999999 | -72.475539 | 2020-05-30 02:32:48 | Arequipa, Peru |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;