daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
28 rows where confirmed = 17138 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 6
- US 20
- Sweden 4
- Colombia 1
- Mexico 1
- Netherlands 1
- Tajikistan 1
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-10-05 | US | Oklahoma | Garfield | 40047 | 17138 | 301 | 0 | 36.3791334 | -97.78265517 | 2022-10-06 04:21:22 | Garfield, Oklahoma, US | |
2022-10-04 | US | Oklahoma | Garfield | 40047 | 17138 | 301 | 0 | 36.3791334 | -97.78265517 | 2022-10-05 04:23:06 | Garfield, Oklahoma, US | |
2022-10-03 | US | Oklahoma | Garfield | 40047 | 17138 | 301 | 0 | 36.3791334 | -97.78265517 | 2022-10-04 04:22:55 | Garfield, Oklahoma, US | |
2022-10-02 | US | Oklahoma | Garfield | 40047 | 17138 | 301 | 0 | 36.3791334 | -97.78265517 | 2022-10-03 04:23:11 | Garfield, Oklahoma, US | |
2022-10-02 | US | California | San Benito | 6069 | 17138 | 106 | 0 | 36.60308176 | -121.069975 | 2022-10-03 04:23:11 | San Benito, California, US | |
2022-10-01 | US | Oklahoma | Garfield | 40047 | 17138 | 301 | 0 | 36.3791334 | -97.78265517 | 2022-10-02 04:21:23 | Garfield, Oklahoma, US | |
2022-09-30 | US | Oklahoma | Garfield | 40047 | 17138 | 301 | 0 | 36.3791334 | -97.78265517 | 2022-10-01 04:23:01 | Garfield, Oklahoma, US | |
2022-09-29 | US | Oklahoma | Garfield | 40047 | 17138 | 301 | 0 | 36.3791334 | -97.78265517 | 2022-09-30 04:23:09 | Garfield, Oklahoma, US | |
2022-08-18 | US | New Hampshire | Cheshire | 33005 | 17138 | 121 | 0 | 42.92015988 | -72.25311043 | 2022-08-19 04:20:54 | Cheshire, New Hampshire, US | |
2022-08-06 | US | Tennessee | Jefferson | 47089 | 17138 | 278 | 0 | 36.04818632 | -83.45148924 | 2022-08-07 04:20:54 | Jefferson, Tennessee, US | |
2022-06-07 | US | Wisconsin | Sauk | 55111 | 17138 | 137 | 0 | 43.42574087 | -89.94966132 | 2022-06-08 04:20:55 | Sauk, Wisconsin, US | |
2022-02-08 | US | Kentucky | Oldham | 21185 | 17138 | 121 | 0 | 38.39791089 | -85.448222 | 2022-02-09 04:21:04 | Oldham, Kentucky, US | |
2021-12-09 | US | Indiana | Howard | 18067 | 17138 | 320 | 0 | 40.48527731 | -86.11351892 | 2021-12-10 04:22:28 | Howard, Indiana, US | |
2021-09-21 | US | California | Marin | 6041 | 17138 | 242 | 0 | 38.07122463 | -122.72106310000001 | 2021-09-22 04:21:45 | Marin, California, US | |
2021-09-16 | US | Alabama | Marshall | 1095 | 17138 | 255 | 0 | 34.36975964 | -86.30486727 | 2021-09-17 04:21:46 | Marshall, Alabama, US | |
2021-08-28 | Tajikistan | 17138 | 125 | 0 | 38.861 | 71.2761 | 2021-08-29 04:21:14 | Tajikistan | ||||
2021-07-21 | US | North Carolina | Davidson | 37057 | 17138 | 201 | 0 | 35.79115496 | -80.21256572 | 2021-07-22 04:21:19 | Davidson, North Carolina, US | |
2021-06-07 | US | New Jersey | Cumberland | 34011 | 17138 | 440 | 0 | 39.37199394 | -75.10712559 | 2021-06-08 04:22:35 | Cumberland, New Jersey, US | |
2021-06-04 | US | Maine | Cumberland | 23005 | 17138 | 196 | 0 | 43.8370751 | -70.37226999 | 2021-06-05 04:23:03 | Cumberland, Maine, US | |
2021-03-26 | US | South Carolina | Florence | 45041 | 17138 | 396 | 0 | 34.02361754 | -79.70189312 | 2021-03-27 05:25:04 | Florence, South Carolina, US | |
2021-03-20 | Colombia | Caqueta | 17138 | 643 | 16291 | 204 | 0.8699 | -73.8419 | 2021-03-21 05:25:44 | Caqueta, Colombia | ||
2021-03-06 | Netherlands | Zeeland | 17138 | 183 | 0 | 16936 | 51.47936 | 3.861559 | 2021-03-07 05:21:54 | Zeeland, Netherlands | ||
2021-02-08 | Sweden | Vastmanland | 17138 | 309 | 0 | 16829 | 59.6714 | 16.2159 | 2021-02-09 05:23:30 | Vastmanland, Sweden | ||
2021-02-07 | Sweden | Vastmanland | 17138 | 309 | 0 | 16829 | 59.6714 | 16.2159 | 2021-02-08 05:22:39 | Vastmanland, Sweden | ||
2021-02-06 | Sweden | Vastmanland | 17138 | 309 | 0 | 16829 | 59.6714 | 16.2159 | 2021-02-07 05:23:00 | Vastmanland, Sweden | ||
2021-02-05 | Sweden | Vastmanland | 17138 | 309 | 0 | 16829 | 59.6714 | 16.2159 | 2021-02-06 05:23:55 | Vastmanland, Sweden | ||
2020-12-01 | US | New York | Orange | 36071 | 17138 | 531 | 0 | 16607 | 41.40337468 | -74.30240757 | 2020-12-02 05:27:41 | Orange, New York, US |
2020-07-31 | Mexico | Nuevo Leon | 17138 | 1066 | 13049 | 3023 | 25.5922 | -99.9962 | 2020-08-01 04:36:27 | Nuevo Leon, Mexico |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;