daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
44 rows where deaths = 6 and province_or_state = "Aomori" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-12-25 | Japan | Aomori | 414 | 6 | 368 | 40 | 40.781541 | 140.828896 | 2020-12-26 05:22:28 | Aomori, Japan | ||
2020-12-24 | Japan | Aomori | 407 | 6 | 367 | 34 | 40.781541 | 140.828896 | 2020-12-25 05:22:48 | Aomori, Japan | ||
2020-12-23 | Japan | Aomori | 403 | 6 | 365 | 32 | 40.781541 | 140.828896 | 2020-12-24 05:23:04 | Aomori, Japan | ||
2020-12-22 | Japan | Aomori | 396 | 6 | 360 | 30 | 40.781541 | 140.828896 | 2020-12-23 05:22:03 | Aomori, Japan | ||
2020-12-21 | Japan | Aomori | 391 | 6 | 345 | 40 | 40.781541 | 140.828896 | 2020-12-22 05:22:33 | Aomori, Japan | ||
2020-12-20 | Japan | Aomori | 390 | 6 | 345 | 39 | 40.781541 | 140.828896 | 2020-12-21 05:27:58 | Aomori, Japan | ||
2020-12-19 | Japan | Aomori | 390 | 6 | 344 | 40 | 40.781541 | 140.828896 | 2020-12-20 05:27:32 | Aomori, Japan | ||
2020-12-18 | Japan | Aomori | 390 | 6 | 337 | 47 | 40.781541 | 140.828896 | 2020-12-19 05:27:52 | Aomori, Japan | ||
2020-12-17 | Japan | Aomori | 390 | 6 | 329 | 55 | 40.781541 | 140.828896 | 2020-12-18 05:28:18 | Aomori, Japan | ||
2020-12-16 | Japan | Aomori | 383 | 6 | 325 | 52 | 40.781541 | 140.828896 | 2020-12-17 05:28:12 | Aomori, Japan | ||
2020-12-15 | Japan | Aomori | 382 | 6 | 314 | 62 | 40.781541 | 140.828896 | 2020-12-16 05:28:04 | Aomori, Japan | ||
2020-12-14 | Japan | Aomori | 375 | 6 | 308 | 61 | 40.781541 | 140.828896 | 2020-12-15 05:26:38 | Aomori, Japan | ||
2020-12-13 | Japan | Aomori | 373 | 6 | 298 | 69 | 40.781541 | 140.828896 | 2020-12-14 05:26:27 | Aomori, Japan | ||
2020-12-12 | Japan | Aomori | 371 | 6 | 293 | 72 | 40.781541 | 140.828896 | 2020-12-13 05:27:20 | Aomori, Japan | ||
2020-12-11 | Japan | Aomori | 364 | 6 | 291 | 67 | 40.781541 | 140.828896 | 2020-12-12 05:26:19 | Aomori, Japan | ||
2020-12-10 | Japan | Aomori | 358 | 6 | 287 | 65 | 40.781541 | 140.828896 | 2020-12-11 05:26:59 | Aomori, Japan | ||
2020-12-09 | Japan | Aomori | 354 | 6 | 286 | 62 | 40.781541 | 140.828896 | 2020-12-10 05:26:19 | Aomori, Japan | ||
2020-12-08 | Japan | Aomori | 345 | 6 | 274 | 65 | 40.781541 | 140.828896 | 2020-12-09 05:28:01 | Aomori, Japan | ||
2020-12-07 | Japan | Aomori | 343 | 6 | 273 | 64 | 40.781541 | 140.828896 | 2020-12-08 05:27:42 | Aomori, Japan | ||
2020-12-06 | Japan | Aomori | 330 | 6 | 273 | 51 | 40.781541 | 140.828896 | 2020-12-07 05:26:14 | Aomori, Japan | ||
2020-12-05 | Japan | Aomori | 324 | 6 | 273 | 45 | 40.781541 | 140.828896 | 2020-12-06 05:26:18 | Aomori, Japan | ||
2020-12-04 | Japan | Aomori | 321 | 6 | 269 | 46 | 40.781541 | 140.828896 | 2020-12-05 05:27:36 | Aomori, Japan | ||
2020-12-03 | Japan | Aomori | 315 | 6 | 268 | 41 | 40.781541 | 140.828896 | 2020-12-04 05:27:27 | Aomori, Japan | ||
2020-12-02 | Japan | Aomori | 307 | 6 | 267 | 34 | 40.781541 | 140.828896 | 2020-12-03 05:28:22 | Aomori, Japan | ||
2020-12-01 | Japan | Aomori | 299 | 6 | 267 | 26 | 40.781541 | 140.828896 | 2020-12-02 05:27:41 | Aomori, Japan | ||
2020-11-30 | Japan | Aomori | 295 | 6 | 265 | 24 | 40.781541 | 140.828896 | 2020-12-01 05:26:18 | Aomori, Japan | ||
2020-11-29 | Japan | Aomori | 287 | 6 | 265 | 16 | 40.781541 | 140.828896 | 2020-11-30 05:26:13 | Aomori, Japan | ||
2020-11-28 | Japan | Aomori | 287 | 6 | 265 | 16 | 40.781541 | 140.828896 | 2020-11-29 05:25:55 | Aomori, Japan | ||
2020-11-27 | Japan | Aomori | 287 | 6 | 263 | 18 | 40.781541 | 140.828896 | 2020-11-28 05:25:50 | Aomori, Japan | ||
2020-11-26 | Japan | Aomori | 285 | 6 | 262 | 17 | 40.781541 | 140.828896 | 2020-11-27 05:26:53 | Aomori, Japan | ||
2020-11-25 | Japan | Aomori | 284 | 6 | 260 | 18 | 40.781541 | 140.828896 | 2020-11-26 05:27:44 | Aomori, Japan | ||
2020-11-24 | Japan | Aomori | 281 | 6 | 256 | 19 | 40.781541 | 140.828896 | 2020-11-25 05:27:20 | Aomori, Japan | ||
2020-11-23 | Japan | Aomori | 281 | 6 | 255 | 20 | 40.781541 | 140.828896 | 2020-11-24 05:27:31 | Aomori, Japan | ||
2020-11-22 | Japan | Aomori | 280 | 6 | 255 | 19 | 40.781541 | 140.828896 | 2020-11-23 05:25:26 | Aomori, Japan | ||
2020-11-21 | Japan | Aomori | 280 | 6 | 255 | 19 | 40.781541 | 140.828896 | 2020-11-22 05:25:45 | Aomori, Japan | ||
2020-11-20 | Japan | Aomori | 280 | 6 | 248 | 26 | 40.781541 | 140.828896 | 2020-11-21 05:25:51 | Aomori, Japan | ||
2020-11-19 | Japan | Aomori | 280 | 6 | 247 | 27 | 40.781541 | 140.828896 | 2020-11-20 05:26:28 | Aomori, Japan | ||
2020-11-18 | Japan | Aomori | 280 | 6 | 243 | 31 | 40.781541 | 140.828896 | 2020-11-19 05:25:23 | Aomori, Japan | ||
2020-11-17 | Japan | Aomori | 280 | 6 | 241 | 33 | 40.781541 | 140.828896 | 2020-11-18 05:40:31 | Aomori, Japan | ||
2020-11-16 | Japan | Aomori | 279 | 6 | 237 | 36 | 40.781541 | 140.828896 | 2020-11-17 05:25:54 | Aomori, Japan | ||
2020-11-15 | Japan | Aomori | 278 | 6 | 235 | 37 | 40.781541 | 140.828896 | 2020-11-16 05:25:57 | Aomori, Japan | ||
2020-11-14 | Japan | Aomori | 278 | 6 | 231 | 41 | 40.781541 | 140.828896 | 2020-11-15 05:26:53 | Aomori, Japan | ||
2020-11-13 | Japan | Aomori | 275 | 6 | 222 | 47 | 40.781541 | 140.828896 | 2020-11-14 05:25:37 | Aomori, Japan | ||
2020-11-12 | Japan | Aomori | 275 | 6 | 215 | 54 | 40.781541 | 140.828896 | 2020-11-13 05:25:30 | Aomori, Japan |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;