johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
24 rows where deaths = 13 and province_or_state = "Kumamoto" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: recovered, day (date), last_update (date)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2119734 | 2119734 | 2020-12-20 | Japan | Kumamoto | 1457 | 13 | 1097 | 347 | 32.608154 | 130.74523100000002 | 2020-12-21 05:27:58 | Kumamoto, Japan | ||
2931241 | 2931241 | 2020-12-19 | Japan | Kumamoto | 1436 | 13 | 1085 | 338 | 32.608154 | 130.74523100000002 | 2020-12-20 05:27:32 | Kumamoto, Japan | ||
1901187 | 1901187 | 2020-12-18 | Japan | Kumamoto | 1406 | 13 | 1085 | 308 | 32.608154 | 130.74523100000002 | 2020-12-19 05:27:52 | Kumamoto, Japan | ||
2128013 | 2128013 | 2020-12-17 | Japan | Kumamoto | 1377 | 13 | 1072 | 292 | 32.608154 | 130.74523100000002 | 2020-12-18 05:28:18 | Kumamoto, Japan | ||
3149613 | 3149613 | 2020-12-16 | Japan | Kumamoto | 1343 | 13 | 1071 | 259 | 32.608154 | 130.74523100000002 | 2020-12-17 05:28:12 | Kumamoto, Japan | ||
1034394 | 1034394 | 2020-12-15 | Japan | Kumamoto | 1318 | 13 | 1056 | 249 | 32.608154 | 130.74523100000002 | 2020-12-16 05:28:04 | Kumamoto, Japan | ||
1751288 | 1751288 | 2020-12-14 | Japan | Kumamoto | 1286 | 13 | 1030 | 243 | 32.608154 | 130.74523100000002 | 2020-12-15 05:26:38 | Kumamoto, Japan | ||
3847808 | 3847808 | 2020-12-13 | Japan | Kumamoto | 1256 | 13 | 1030 | 213 | 32.608154 | 130.74523100000002 | 2020-12-14 05:26:27 | Kumamoto, Japan | ||
845590 | 845590 | 2020-12-12 | Japan | Kumamoto | 1227 | 13 | 1020 | 194 | 32.608154 | 130.74523100000002 | 2020-12-13 05:27:20 | Kumamoto, Japan | ||
860697 | 860697 | 2020-12-11 | Japan | Kumamoto | 1195 | 13 | 1012 | 170 | 32.608154 | 130.74523100000002 | 2020-12-12 05:26:19 | Kumamoto, Japan | ||
1600239 | 1600239 | 2020-12-10 | Japan | Kumamoto | 1170 | 13 | 1004 | 153 | 32.608154 | 130.74523100000002 | 2020-12-11 05:26:59 | Kumamoto, Japan | ||
2975248 | 2975248 | 2020-12-09 | Japan | Kumamoto | 1143 | 13 | 986 | 144 | 32.608154 | 130.74523100000002 | 2020-12-10 05:26:19 | Kumamoto, Japan | ||
1818808 | 1818808 | 2020-12-08 | Japan | Kumamoto | 1127 | 13 | 977 | 137 | 32.608154 | 130.74523100000002 | 2020-12-09 05:28:01 | Kumamoto, Japan | ||
2347444 | 2347444 | 2020-12-07 | Japan | Kumamoto | 1100 | 13 | 969 | 118 | 32.608154 | 130.74523100000002 | 2020-12-08 05:27:42 | Kumamoto, Japan | ||
1006314 | 1006314 | 2020-12-06 | Japan | Kumamoto | 1092 | 13 | 964 | 115 | 32.608154 | 130.74523100000002 | 2020-12-07 05:26:14 | Kumamoto, Japan | ||
1632323 | 1632323 | 2020-12-05 | Japan | Kumamoto | 1083 | 13 | 954 | 116 | 32.608154 | 130.74523100000002 | 2020-12-06 05:26:18 | Kumamoto, Japan | ||
3859851 | 3859851 | 2020-12-04 | Japan | Kumamoto | 1075 | 13 | 948 | 114 | 32.608154 | 130.74523100000002 | 2020-12-05 05:27:36 | Kumamoto, Japan | ||
75109 | 75109 | 2020-12-03 | Japan | Kumamoto | 1060 | 13 | 940 | 107 | 32.608154 | 130.74523100000002 | 2020-12-04 05:27:27 | Kumamoto, Japan | ||
738321 | 738321 | 2020-12-02 | Japan | Kumamoto | 1052 | 13 | 924 | 115 | 32.608154 | 130.74523100000002 | 2020-12-03 05:28:22 | Kumamoto, Japan | ||
2537415 | 2537415 | 2020-12-01 | Japan | Kumamoto | 1041 | 13 | 921 | 107 | 32.608154 | 130.74523100000002 | 2020-12-02 05:27:41 | Kumamoto, Japan | ||
1584184 | 1584184 | 2020-11-30 | Japan | Kumamoto | 1023 | 13 | 921 | 89 | 32.608154 | 130.74523100000002 | 2020-12-01 05:26:18 | Kumamoto, Japan | ||
3566587 | 3566587 | 2020-11-29 | Japan | Kumamoto | 1018 | 13 | 914 | 91 | 32.608154 | 130.74523100000002 | 2020-11-30 05:26:13 | Kumamoto, Japan | ||
2935252 | 2935252 | 2020-11-28 | Japan | Kumamoto | 1010 | 13 | 903 | 94 | 32.608154 | 130.74523100000002 | 2020-11-29 05:25:55 | Kumamoto, Japan | ||
392255 | 392255 | 2020-11-27 | Japan | Kumamoto | 1006 | 13 | 891 | 102 | 32.608154 | 130.74523100000002 | 2020-11-28 05:25:50 | Kumamoto, Japan |
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]);