daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
35 rows where active = 4878 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-30 | Russia | Zabaykalsky Krai | 56022 | 931 | 50213 | 4878 | 52.248521 | 115.956325 | 2021-07-31 04:21:35 | Zabaykalsky Krai, Russia | ||
2021-07-26 | Netherlands | Unknown | 2841 | 23 | 0 | 4878 | 2021-07-27 04:21:18 | Unknown, Netherlands | ||||
2021-07-26 | Brazil | Sergipe | 273330 | 5896 | 262556 | 4878 | -10.5741 | -37.3857 | 2021-07-27 04:21:18 | Sergipe, Brazil | ||
2021-03-24 | Germany | Hamburg | 57749 | 1358 | 51917 | 4878 | 53.5511 | 9.9937 | 2021-03-25 05:27:00 | Hamburg, Germany | ||
2021-02-26 | US | Maryland | Cecil | 24015 | 4998 | 120 | 0 | 4878 | 39.56647682 | -75.94627411 | 2021-02-27 05:22:28 | Cecil, Maryland, US |
2021-02-24 | US | Michigan | Lapeer | 26087 | 4997 | 119 | 0 | 4878 | 43.09052506 | -83.22153148 | 2021-02-25 05:24:57 | Lapeer, Michigan, US |
2021-02-22 | US | Minnesota | Chisago | 27025 | 4922 | 44 | 0 | 4878 | 45.5021011 | -92.90861945 | 2021-02-23 05:23:41 | Chisago, Minnesota, US |
2021-02-20 | US | Ohio | Darke | 39037 | 4998 | 120 | 0 | 4878 | 40.13412966 | -84.6194517 | 2021-02-21 05:24:33 | Darke, Ohio, US |
2021-02-20 | US | Illinois | Ogle | 17141 | 4950 | 72 | 0 | 4878 | 42.04165196 | -89.32184679 | 2021-02-21 05:24:33 | Ogle, Illinois, US |
2021-02-11 | US | Texas | Atascosa | 48013 | 5226 | 126 | 0 | 4878 | 28.89333001 | -98.52730485 | 2021-02-12 05:23:29 | Atascosa, Texas, US |
2021-01-30 | US | Tennessee | Dyer | 47045 | 5082 | 87 | 0 | 4878 | 36.05931946 | -89.41542855 | 2021-01-31 05:22:42 | Dyer, Tennessee, US |
2021-01-26 | US | Virginia | Bedford | 51019 | 4915 | 37 | 0 | 4878 | 37.3080028 | -79.5281964 | 2021-01-27 05:23:41 | Bedford, Virginia, US |
2021-01-21 | US | North Carolina | Wilkes | 37193 | 4964 | 86 | 0 | 4878 | 36.2084135 | -81.16232895 | 2021-01-22 05:22:10 | Wilkes, North Carolina, US |
2021-01-16 | US | Wisconsin | Columbia | 55021 | 4921 | 43 | 0 | 4878 | 43.46492199 | -89.33589004 | 2021-01-17 05:22:17 | Columbia, Wisconsin, US |
2021-01-10 | US | Colorado | Fremont | 8043 | 4960 | 35 | 0 | 4878 | 38.47362326 | -105.4399667 | 2021-01-11 05:21:50 | Fremont, Colorado, US |
2021-01-09 | US | Mississippi | Lowndes | 28087 | 4976 | 98 | 0 | 4878 | 33.47386518 | -88.44191529999998 | 2021-01-10 05:22:12 | Lowndes, Mississippi, US |
2021-01-07 | US | Illinois | Whiteside | 17195 | 5009 | 131 | 0 | 4878 | 41.75509713 | -89.91556058 | 2021-01-08 05:22:42 | Whiteside, Illinois, US |
2020-12-31 | US | Georgia | Troup | 13285 | 5006 | 128 | 0 | 4878 | 33.03349196 | -85.02812115 | 2021-01-01 05:23:07 | Troup, Georgia, US |
2020-12-20 | US | Tennessee | Anderson | 47001 | 5019 | 48 | 0 | 4878 | 36.12684348 | -84.19965764 | 2020-12-21 05:27:58 | Anderson, Tennessee, US |
2020-12-19 | US | North Carolina | Wilson | 37195 | 4975 | 97 | 0 | 4878 | 35.70625477 | -77.917978 | 2020-12-20 05:27:32 | Wilson, North Carolina, US |
2020-10-27 | US | Louisiana | Tangipahoa | 22105 | 5004 | 126 | 0 | 4878 | 30.62888673 | -90.40664996 | 2020-10-28 04:24:39 | Tangipahoa, Louisiana, US |
2020-10-21 | Russia | Stavropol Krai | 19421 | 387 | 14156 | 4878 | 44.86325770000001 | 43.4406913 | 2020-10-22 04:24:27 | Stavropol Krai, Russia | ||
2020-10-06 | US | South Carolina | Florence | 45041 | 5074 | 196 | 0 | 4878 | 34.02361754 | -79.70189312 | 2020-10-07 04:23:40 | Florence, South Carolina, US |
2020-09-30 | US | Wisconsin | Racine | 55101 | 4976 | 98 | 0 | 4878 | 42.74753117 | -88.05941254 | 2020-10-01 04:23:42 | Racine, Wisconsin, US |
2020-09-26 | Russia | Saratov Oblast | 15072 | 98 | 10096 | 4878 | 51.6520555 | 46.8631952 | 2020-09-27 04:23:00 | Saratov Oblast, Russia | ||
2020-09-14 | India | Puducherry | 19833 | 385 | 14570 | 4878 | 11.882658 | 78.86498 | 2020-09-15 03:22:50 | Puducherry, India | ||
2020-09-13 | India | Puducherry | 19833 | 385 | 14570 | 4878 | 11.882658 | 78.86498 | 2020-09-14 04:26:00 | Puducherry, India | ||
2020-09-11 | India | Puducherry | 19026 | 365 | 13783 | 4878 | 11.882658 | 78.86498 | 2020-09-12 04:25:05 | Puducherry, India | ||
2020-09-06 | US | Alabama | Shelby | 1117 | 4918 | 40 | 0 | 4878 | 33.26879845 | -86.66232561 | 2020-09-07 04:28:30 | Shelby, Alabama, US |
2020-08-08 | Sudan | 11894 | 773 | 6243 | 4878 | 12.8628 | 30.2176 | 2020-08-09 04:34:54 | Sudan | |||
2020-08-07 | Sudan | 11894 | 773 | 6243 | 4878 | 12.8628 | 30.2176 | 2020-08-08 04:34:53 | Sudan | |||
2020-07-29 | Peru | Cajamarca | 5560 | 682 | 0 | 4878 | -6.430284 | -78.74559599999998 | 2020-07-30 04:35:05 | Cajamarca, Peru | ||
2020-07-08 | US | Arizona | Pinal | 4021 | 4959 | 81 | 0 | 4878 | 32.90525627 | -111.3449483 | 2020-07-09 04:34:23 | Pinal, Arizona, US |
2020-07-06 | Ghana | 21077 | 129 | 16070 | 4878 | 7.9465 | -1.0232 | 2020-07-07 04:34:00 | Ghana | |||
2020-05-22 | US | Maryland | Baltimore | 24005 | 5170 | 292 | 0 | 4878 | 39.45784712 | -76.62911955 | 2020-05-23 02:32:42 | Baltimore, Maryland, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;