johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
11 rows where active = 10110 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3015568 | 3015568 | 2021-08-01 | Russia | Krasnoyarsk Krai | 91462 | 4466 | 76886 | 10110 | 63.3233807 | 97.0979974 | 2021-08-02 04:21:36 | Krasnoyarsk Krai, Russia | ||
3242638 | 3242638 | 2021-04-21 | Sweden | Jamtland Harjedalen | 10228 | 118 | 0 | 10110 | 63.1712 | 14.9592 | 2021-04-22 04:20:53 | Jamtland Harjedalen, Sweden | ||
2208826 | 2208826 | 2021-03-04 | US | Iowa | Dallas | 19049 | 10202 | 92 | 0 | 10110 | 41.68560356 | -94.04127625 | 2021-03-05 05:26:29 | Dallas, Iowa, US |
2482967 | 2482967 | 2021-01-28 | US | Illinois | Kendall | 17093 | 10185 | 75 | 0 | 10110 | 41.59081014 | -88.42869583 | 2021-01-29 05:22:23 | Kendall, Illinois, US |
1094137 | 1094137 | 2021-01-20 | Jordan | 317405 | 4187 | 303108 | 10110 | 31.24 | 36.51 | 2021-01-21 05:22:01 | Jordan | |||
909786 | 909786 | 2021-01-19 | US | Michigan | Berrien | 26021 | 10322 | 212 | 0 | 10110 | 41.95447397 | -86.41313079999998 | 2021-01-20 05:21:54 | Berrien, Michigan, US |
2410376 | 2410376 | 2020-12-23 | US | Wisconsin | La Crosse | 55063 | 10163 | 53 | 0 | 10110 | 43.90632465 | -91.11451093 | 2020-12-24 05:23:04 | La Crosse, Wisconsin, US |
846295 | 846295 | 2020-12-12 | US | Florida | St. Johns | 12109 | 10215 | 105 | 0 | 10110 | 29.90096506 | -81.43589967 | 2020-12-13 05:27:20 | St. Johns, Florida, US |
196225 | 196225 | 2020-08-31 | US | New Jersey | Monmouth | 34025 | 10968 | 858 | 0 | 10110 | 40.26549699 | -74.22240686 | 2020-09-01 04:28:31 | Monmouth, New Jersey, US |
146681 | 146681 | 2020-08-15 | US | Florida | Osceola | 12097 | 10228 | 118 | 0 | 10110 | 28.06312234 | -81.14882926 | 2020-08-16 04:27:42 | Osceola, Florida, US |
3262027 | 3262027 | 2020-07-31 | US | Nebraska | Douglas | 31055 | 10241 | 131 | 0 | 10110 | 41.29518299 | -96.15085305 | 2020-08-01 04:36:27 | Douglas, Nebraska, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);