johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
15 rows where confirmed = 26406 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1620061 | 1620061 | 2022-11-22 | China | Guangdong | 26406 | 8 | 0 | 23.3417 | 113.4244 | 2022-11-23 04:21:06 | Guangdong, China | |||
3041908 | 3041908 | 2022-10-27 | US | Wisconsin | Ozaukee | 55089 | 26406 | 194 | 0 | 43.38352225 | -87.94625009 | 2022-10-28 04:22:31 | Ozaukee, Wisconsin, US | |
1992670 | 1992670 | 2022-03-01 | Japan | Nagasaki | 26406 | 108 | 0 | 33.235712 | 129.608033 | 2022-03-02 04:21:07 | Nagasaki, Japan | |||
3467856 | 3467856 | 2022-01-18 | United Kingdom | Jersey | 26406 | 92 | 0 | 0 | 49.2138 | -2.1358 | 2022-01-19 04:21:23 | Jersey, United Kingdom | ||
3689757 | 3689757 | 2022-01-13 | US | New York | Ulster | 36111 | 26406 | 319 | 0 | 41.89027881 | -74.26252104 | 2022-01-14 04:21:54 | Ulster, New York, US | |
2609963 | 2609963 | 2022-01-06 | Haiti | 26406 | 780 | 0 | 18.9712 | -72.2852 | 2022-01-07 04:22:09 | Haiti | ||||
1742186 | 1742186 | 2021-12-05 | US | Michigan | Jackson | 26075 | 26406 | 386 | 0 | 42.24807035 | -84.42258681 | 2021-12-06 04:22:34 | Jackson, Michigan, US | |
139618 | 139618 | 2021-12-04 | US | Michigan | Jackson | 26075 | 26406 | 386 | 0 | 42.24807035 | -84.42258681 | 2021-12-05 04:22:25 | Jackson, Michigan, US | |
2197271 | 2197271 | 2021-12-03 | US | Michigan | Jackson | 26075 | 26406 | 386 | 0 | 42.24807035 | -84.42258681 | 2021-12-04 04:22:18 | Jackson, Michigan, US | |
1120072 | 1120072 | 2021-08-06 | US | Ohio | Lorain | 39093 | 26406 | 516 | 0 | 41.29553751 | -82.15083537 | 2021-08-07 04:21:30 | Lorain, Ohio, US | |
1881145 | 1881145 | 2021-03-26 | Peru | Huanuco | 26406 | 1944 | 0 | 24462 | -9.421676 | -76.040642 | 2021-03-27 05:25:04 | Huanuco, Peru | ||
1980775 | 1980775 | 2021-03-25 | Peru | Huanuco | 26406 | 1941 | 0 | 24465 | -9.421676 | -76.040642 | 2021-03-26 05:26:55 | Huanuco, Peru | ||
12330 | 12330 | 2021-01-26 | Italy | P.A. Trento | 26406 | 1141 | 23246 | 2019 | 46.06893511 | 11.12123097 | 2021-01-27 05:23:41 | P.A. Trento, Italy | ||
1095140 | 1095140 | 2021-01-20 | US | Illinois | Winnebago | 17201 | 26406 | 377 | 0 | 26029 | 42.33641854 | -89.16085327 | 2021-01-21 05:22:01 | Winnebago, Illinois, US |
415154 | 415154 | 2020-07-05 | Colombia | Atlantico | 26406 | 1488 | 9077 | 15841 | 10.6966 | -74.8741 | 2020-07-06 04:33:57 | Atlantico, Colombia |
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]);