daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
24 rows where active = 5066 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-24 | Malaysia | Sabah | 78653 | 591 | 72996 | 5066 | 5.9788 | 116.0753 | 2021-07-25 04:22:12 | Sabah, Malaysia | ||
2021-04-07 | Spain | Ceuta | 5327 | 98 | 163 | 5066 | 35.8894 | -5.3213 | 2021-04-08 04:21:13 | Ceuta, Spain | ||
2021-02-28 | US | Ohio | Union | 39159 | 5112 | 46 | 0 | 5066 | 40.30016061 | -83.37239023 | 2021-03-01 05:23:01 | Union, Ohio, US |
2021-02-21 | Ukraine | Kiev Oblast | 73388 | 1215 | 67107 | 5066 | 50.053 | 30.7667 | 2021-02-22 05:24:21 | Kiev Oblast, Ukraine | ||
2021-02-13 | US | North Carolina | Lenoir | 37107 | 5167 | 101 | 0 | 5066 | 35.24032589999999 | -77.64245615 | 2021-02-14 05:23:43 | Lenoir, North Carolina, US |
2021-02-08 | US | Indiana | Cass | 18017 | 5158 | 92 | 0 | 5066 | 40.76135835 | -86.34830753 | 2021-02-09 05:23:30 | Cass, Indiana, US |
2021-02-06 | Australia | New South Wales | 5120 | 54 | 0 | 5066 | -33.8688 | 151.2093 | 2021-02-07 05:23:00 | New South Wales, Australia | ||
2021-02-04 | US | Arizona | Graham | 4009 | 5133 | 67 | 0 | 5066 | 32.93166885 | -109.8882178 | 2021-02-05 05:22:38 | Graham, Arizona, US |
2021-01-30 | US | Indiana | Marshall | 18099 | 5163 | 97 | 0 | 5066 | 41.32467367 | -86.26185087 | 2021-01-31 05:22:42 | Marshall, Indiana, US |
2021-01-27 | US | Oklahoma | Grady | 40051 | 5121 | 55 | 0 | 5066 | 35.0167709 | -97.88339847 | 2021-01-28 05:22:24 | Grady, Oklahoma, US |
2021-01-25 | US | Wisconsin | Columbia | 55021 | 5111 | 45 | 0 | 5066 | 43.46492199 | -89.33589004 | 2021-01-26 05:22:02 | Columbia, Wisconsin, US |
2021-01-23 | US | South Carolina | Kershaw | 45055 | 5153 | 87 | 0 | 5066 | 34.33988254 | -80.58763164 | 2021-01-24 05:22:35 | Kershaw, South Carolina, US |
2021-01-22 | US | Florida | Monroe | 12087 | 5105 | 39 | 0 | 5066 | 25.20904673 | -81.07812416 | 2021-01-23 05:22:03 | Monroe, Florida, US |
2021-01-14 | Russia | Saratov Oblast | 38944 | 459 | 33419 | 5066 | 51.6520555 | 46.86319520000001 | 2021-01-15 05:22:24 | Saratov Oblast, Russia | ||
2021-01-01 | Brazil | Mato Grosso | 180659 | 4530 | 170171 | 5066 | -12.6819 | -56.9211 | 2021-01-02 05:22:33 | Mato Grosso, Brazil | ||
2020-12-30 | US | Mississippi | Jones | 28067 | 5163 | 97 | 0 | 5066 | 31.62257767 | -89.16896899999998 | 2020-12-31 05:22:49 | Jones, Mississippi, US |
2020-12-29 | US | South Carolina | Oconee | 45073 | 5127 | 61 | 0 | 5066 | 34.75225169 | -83.06742317 | 2020-12-30 05:22:34 | Oconee, South Carolina, US |
2020-11-28 | US | California | Shasta | 6089 | 5105 | 43 | 0 | 5066 | 40.76391419 | -122.0396884 | 2020-11-29 05:25:55 | Shasta, California, US |
2020-11-24 | Egypt | 113742 | 6573 | 102103 | 5066 | 26.820553000000004 | 30.802498 | 2020-11-25 05:27:20 | Egypt | |||
2020-11-21 | US | Indiana | Monroe | 18105 | 5115 | 49 | 0 | 5066 | 39.16130004 | -86.52414358 | 2020-11-22 05:25:45 | Monroe, Indiana, US |
2020-10-22 | Italy | Liguria | 20581 | 1673 | 13842 | 5066 | 44.41149315 | 8.9326992 | 2020-10-23 04:24:46 | Liguria, Italy | ||
2020-10-17 | US | North Carolina | Johnston | 37101 | 5125 | 59 | 0 | 5066 | 35.51745004 | -78.36622717 | 2020-10-18 04:24:25 | Johnston, North Carolina, US |
2020-08-14 | US | Texas | Hays | 48209 | 4545 | 45 | 0 | 5066 | 30.05669873 | -98.02944344 | 2020-08-15 04:27:31 | Hays, Texas, US |
2020-05-23 | Bolivia | 5915 | 240 | 609 | 5066 | -16.2902 | -63.5887 | 2020-05-24 02:32:43 | Bolivia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;