daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
46 rows where confirmed = 14727 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-08-17 | US | Minnesota | Otter Tail | 27111 | 14727 | 172 | 0 | 46.40846929 | -95.70835255 | 2022-08-18 04:21:11 | Otter Tail, Minnesota, US | |
2022-08-16 | US | Minnesota | Otter Tail | 27111 | 14727 | 172 | 0 | 46.40846929 | -95.70835255 | 2022-08-17 04:20:59 | Otter Tail, Minnesota, US | |
2022-08-15 | US | Minnesota | Otter Tail | 27111 | 14727 | 172 | 0 | 46.40846929 | -95.70835255 | 2022-08-16 04:20:58 | Otter Tail, Minnesota, US | |
2022-08-14 | US | Minnesota | Otter Tail | 27111 | 14727 | 172 | 0 | 46.40846929 | -95.70835255 | 2022-08-15 04:20:59 | Otter Tail, Minnesota, US | |
2022-08-13 | US | Minnesota | Otter Tail | 27111 | 14727 | 172 | 0 | 46.40846929 | -95.70835255 | 2022-08-14 04:20:55 | Otter Tail, Minnesota, US | |
2022-08-12 | US | Minnesota | Otter Tail | 27111 | 14727 | 172 | 0 | 46.40846929 | -95.70835255 | 2022-08-13 04:20:52 | Otter Tail, Minnesota, US | |
2022-08-11 | US | Minnesota | Otter Tail | 27111 | 14727 | 172 | 0 | 46.40846929 | -95.70835255 | 2022-08-12 04:20:54 | Otter Tail, Minnesota, US | |
2022-07-19 | US | North Carolina | McDowell | 37111 | 14727 | 176 | 0 | 35.67736232 | -82.0482425 | 2022-07-20 04:20:59 | McDowell, North Carolina, US | |
2022-07-18 | US | North Carolina | McDowell | 37111 | 14727 | 176 | 0 | 35.67736232 | -82.0482425 | 2022-07-19 04:20:58 | McDowell, North Carolina, US | |
2022-07-17 | US | North Carolina | McDowell | 37111 | 14727 | 176 | 0 | 35.67736232 | -82.0482425 | 2022-07-18 04:20:59 | McDowell, North Carolina, US | |
2022-07-16 | US | North Carolina | McDowell | 37111 | 14727 | 176 | 0 | 35.67736232 | -82.0482425 | 2022-07-17 04:21:15 | McDowell, North Carolina, US | |
2022-07-15 | US | North Carolina | McDowell | 37111 | 14727 | 176 | 0 | 35.67736232 | -82.0482425 | 2022-07-16 04:21:05 | McDowell, North Carolina, US | |
2022-07-14 | US | North Carolina | McDowell | 37111 | 14727 | 176 | 0 | 35.67736232 | -82.0482425 | 2022-07-15 04:20:53 | McDowell, North Carolina, US | |
2022-07-13 | US | North Carolina | McDowell | 37111 | 14727 | 176 | 0 | 35.67736232 | -82.0482425 | 2022-07-14 04:20:57 | McDowell, North Carolina, US | |
2022-06-24 | US | New York | Madison | 36053 | 14727 | 128 | 0 | 42.91653905 | -75.67266639 | 2022-06-25 04:20:57 | Madison, New York, US | |
2022-06-05 | US | Puerto Rico | Toa Alta | 72135 | 14727 | 0 | 0 | 18.362406 | -66.246616 | 2022-06-06 04:20:57 | Toa Alta, Puerto Rico, US | |
2022-05-31 | US | Michigan | Barry | 26015 | 14727 | 170 | 0 | 42.59513984 | -85.30834519 | 2022-06-01 04:20:55 | Barry, Michigan, US | |
2022-05-30 | US | Michigan | Barry | 26015 | 14727 | 170 | 0 | 42.59513984 | -85.30834519 | 2022-05-31 04:20:51 | Barry, Michigan, US | |
2022-05-29 | US | Michigan | Barry | 26015 | 14727 | 170 | 0 | 42.59513984 | -85.30834519 | 2022-05-30 04:20:50 | Barry, Michigan, US | |
2022-05-28 | US | Michigan | Barry | 26015 | 14727 | 170 | 0 | 42.59513984 | -85.30834519 | 2022-05-29 04:20:53 | Barry, Michigan, US | |
2022-05-27 | US | Michigan | Barry | 26015 | 14727 | 170 | 0 | 42.59513984 | -85.30834519 | 2022-05-28 04:21:07 | Barry, Michigan, US | |
2022-05-26 | US | Michigan | Barry | 26015 | 14727 | 170 | 0 | 42.59513984 | -85.30834519 | 2022-05-27 04:20:56 | Barry, Michigan, US | |
2022-05-25 | US | Michigan | Barry | 26015 | 14727 | 170 | 0 | 42.59513984 | -85.30834519 | 2022-05-26 04:20:50 | Barry, Michigan, US | |
2022-05-22 | US | Michigan | Barry | 26015 | 14727 | 170 | 0 | 42.59513984 | -85.30834519 | 2022-05-26 04:20:50 | Barry, Michigan, US | |
2022-02-27 | US | Oregon | Benton | 41003 | 14727 | 61 | 0 | 44.49167306 | -123.4316987 | 2022-02-28 04:21:05 | Benton, Oregon, US | |
2022-02-26 | US | Oregon | Benton | 41003 | 14727 | 61 | 0 | 44.49167306 | -123.4316987 | 2022-02-27 04:21:04 | Benton, Oregon, US | |
2022-02-25 | US | Oregon | Benton | 41003 | 14727 | 61 | 0 | 44.49167306 | -123.4316987 | 2022-02-26 04:21:12 | Benton, Oregon, US | |
2022-01-17 | US | South Carolina | Laurens | 45059 | 14727 | 249 | 0 | 34.48244419 | -82.00490796 | 2022-01-18 04:21:04 | Laurens, South Carolina, US | |
2022-01-16 | US | South Carolina | Laurens | 45059 | 14727 | 249 | 0 | 34.48244419 | -82.00490796 | 2022-01-17 04:21:08 | Laurens, South Carolina, US | |
2022-01-15 | US | South Carolina | Laurens | 45059 | 14727 | 249 | 0 | 34.48244419 | -82.00490796 | 2022-01-16 04:21:12 | Laurens, South Carolina, US | |
2022-01-14 | US | South Carolina | Laurens | 45059 | 14727 | 249 | 0 | 34.48244419 | -82.00490796 | 2022-01-15 04:21:07 | Laurens, South Carolina, US | |
2022-01-05 | US | Utah | Tooele | 49045 | 14727 | 84 | 0 | 40.44862644 | -113.12957150000001 | 2022-01-06 04:22:09 | Tooele, Utah, US | |
2022-01-04 | US | Iowa | Story | 19169 | 14727 | 64 | 0 | 42.03621213 | -93.46499005 | 2022-01-05 04:21:59 | Story, Iowa, US | |
2022-01-03 | US | Iowa | Story | 19169 | 14727 | 64 | 0 | 42.03621213 | -93.46499005 | 2022-01-04 04:22:17 | Story, Iowa, US | |
2022-01-02 | US | Iowa | Story | 19169 | 14727 | 64 | 0 | 42.03621213 | -93.46499005 | 2022-01-03 02:22:25 | Story, Iowa, US | |
2022-01-01 | US | Iowa | Story | 19169 | 14727 | 64 | 0 | 42.03621213 | -93.46499005 | 2022-01-02 04:20:52 | Story, Iowa, US | |
2021-12-31 | US | Iowa | Story | 19169 | 14727 | 64 | 0 | 42.03621213 | -93.46499005 | 2022-01-01 04:22:14 | Story, Iowa, US | |
2021-12-30 | US | Iowa | Story | 19169 | 14727 | 64 | 0 | 42.03621213 | -93.46499005 | 2021-12-31 04:21:50 | Story, Iowa, US | |
2021-12-29 | US | Iowa | Story | 19169 | 14727 | 64 | 0 | 42.03621213 | -93.46499005 | 2021-12-30 04:21:25 | Story, Iowa, US | |
2021-07-23 | US | Maryland | Washington | 24043 | 14727 | 334 | 0 | 39.60835778 | -77.82002295 | 2021-07-24 00:21:36 | Washington, Maryland, US | |
2021-05-31 | US | Pennsylvania | Monroe | 42089 | 14727 | 317 | 0 | 41.05934058 | -75.34031025 | 2021-06-01 04:23:09 | Monroe, Pennsylvania, US | |
2021-05-23 | US | Georgia | Houston | 13153 | 14727 | 262 | 0 | 32.45802497 | -83.66879087 | 2021-05-24 04:20:53 | Houston, Georgia, US | |
2021-04-12 | US | Ohio | Medina | 39103 | 14727 | 265 | 0 | 41.11770589 | -81.89986209999998 | 2021-04-13 04:20:37 | Medina, Ohio, US | |
2020-12-08 | Peru | Ayacucho | 14727 | 812 | 0 | 13915 | -14.091648 | -74.08344 | 2020-12-09 05:28:01 | Ayacucho, Peru | ||
2020-12-07 | Peru | Ayacucho | 14727 | 811 | 0 | 13916 | -14.091648 | -74.08344 | 2020-12-08 05:27:42 | Ayacucho, Peru | ||
2020-11-28 | Russia | Tver Oblast | 14727 | 378 | 9899 | 4450 | 57.1134475 | 35.174442799999994 | 2020-11-29 05:25:55 | Tver Oblast, Russia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;