johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
44 rows where deaths = 43 and province_or_state = "Yamaguchi" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3393442 | 3393442 | 2021-04-28 | Japan | Yamaguchi | 1790 | 43 | 1449 | 298 | 34.201190000000004 | 131.573293 | 2021-04-29 04:20:55 | Yamaguchi, Japan | ||
3702158 | 3702158 | 2021-04-27 | Japan | Yamaguchi | 1764 | 43 | 1449 | 272 | 34.201190000000004 | 131.573293 | 2021-04-28 04:20:32 | Yamaguchi, Japan | ||
888167 | 888167 | 2021-04-26 | Japan | Yamaguchi | 1724 | 43 | 1433 | 248 | 34.201190000000004 | 131.573293 | 2021-04-27 04:20:52 | Yamaguchi, Japan | ||
954912 | 954912 | 2021-04-25 | Japan | Yamaguchi | 1718 | 43 | 1429 | 246 | 34.201190000000004 | 131.573293 | 2021-04-26 04:21:04 | Yamaguchi, Japan | ||
3924059 | 3924059 | 2021-04-24 | Japan | Yamaguchi | 1696 | 43 | 1419 | 234 | 34.201190000000004 | 131.573293 | 2021-04-25 04:20:32 | Yamaguchi, Japan | ||
1409090 | 1409090 | 2021-04-23 | Japan | Yamaguchi | 1673 | 43 | 1413 | 217 | 34.201190000000004 | 131.573293 | 2021-04-24 04:20:38 | Yamaguchi, Japan | ||
1568153 | 1568153 | 2021-04-22 | Japan | Yamaguchi | 1639 | 43 | 1411 | 185 | 34.201190000000004 | 131.573293 | 2021-04-23 04:20:52 | Yamaguchi, Japan | ||
3242374 | 3242374 | 2021-04-21 | Japan | Yamaguchi | 1617 | 43 | 1406 | 168 | 34.201190000000004 | 131.573293 | 2021-04-22 04:20:53 | Yamaguchi, Japan | ||
2020770 | 2020770 | 2021-04-20 | Japan | Yamaguchi | 1593 | 43 | 1401 | 149 | 34.201190000000004 | 131.573293 | 2021-04-21 04:21:14 | Yamaguchi, Japan | ||
2410891 | 2410891 | 2021-04-19 | Japan | Yamaguchi | 1570 | 43 | 1396 | 131 | 34.201190000000004 | 131.573293 | 2021-04-20 04:20:41 | Yamaguchi, Japan | ||
3129568 | 3129568 | 2021-04-18 | Japan | Yamaguchi | 1553 | 43 | 1418 | 92 | 34.201190000000004 | 131.573293 | 2021-04-19 04:20:57 | Yamaguchi, Japan | ||
982996 | 982996 | 2021-04-17 | Japan | Yamaguchi | 1540 | 43 | 1390 | 107 | 34.201190000000004 | 131.573293 | 2021-04-18 04:20:41 | Yamaguchi, Japan | ||
170091 | 170091 | 2021-04-16 | Japan | Yamaguchi | 1503 | 43 | 1388 | 72 | 34.201190000000004 | 131.573293 | 2021-04-17 04:20:40 | Yamaguchi, Japan | ||
2548922 | 2548922 | 2021-04-15 | Japan | Yamaguchi | 1485 | 43 | 1384 | 58 | 34.201190000000004 | 131.573293 | 2021-04-16 04:20:46 | Yamaguchi, Japan | ||
1841992 | 1841992 | 2021-04-14 | Japan | Yamaguchi | 1473 | 43 | 1382 | 48 | 34.201190000000004 | 131.573293 | 2021-04-15 04:20:54 | Yamaguchi, Japan | ||
2571726 | 2571726 | 2021-04-13 | Japan | Yamaguchi | 1468 | 43 | 1383 | 42 | 34.201190000000004 | 131.573293 | 2021-04-14 04:20:41 | Yamaguchi, Japan | ||
36477 | 36477 | 2021-04-12 | Japan | Yamaguchi | 1462 | 43 | 1380 | 39 | 34.201190000000004 | 131.573293 | 2021-04-13 04:20:37 | Yamaguchi, Japan | ||
3883636 | 3883636 | 2021-04-11 | Japan | Yamaguchi | 1461 | 43 | 1375 | 43 | 34.201190000000004 | 131.573293 | 2021-04-12 04:21:00 | Yamaguchi, Japan | ||
2983304 | 2983304 | 2021-04-10 | Japan | Yamaguchi | 1458 | 43 | 1368 | 47 | 34.201190000000004 | 131.573293 | 2021-04-11 04:20:56 | Yamaguchi, Japan | ||
605736 | 605736 | 2021-04-09 | Japan | Yamaguchi | 1455 | 43 | 1368 | 44 | 34.201190000000004 | 131.573293 | 2021-04-10 04:20:59 | Yamaguchi, Japan | ||
2645800 | 2645800 | 2021-04-08 | Japan | Yamaguchi | 1448 | 43 | 1363 | 42 | 34.201190000000004 | 131.573293 | 2021-04-09 04:21:13 | Yamaguchi, Japan | ||
2247442 | 2247442 | 2021-04-07 | Japan | Yamaguchi | 1443 | 43 | 1361 | 39 | 34.201190000000004 | 131.573293 | 2021-04-08 04:21:13 | Yamaguchi, Japan | ||
3003352 | 3003352 | 2021-04-06 | Japan | Yamaguchi | 1440 | 43 | 1358 | 39 | 34.201190000000004 | 131.573293 | 2021-04-07 04:20:53 | Yamaguchi, Japan | ||
3085347 | 3085347 | 2021-04-05 | Japan | Yamaguchi | 1439 | 43 | 1357 | 39 | 34.201190000000004 | 131.573293 | 2021-04-06 04:20:32 | Yamaguchi, Japan | ||
388270 | 388270 | 2021-04-04 | Japan | Yamaguchi | 1438 | 43 | 1355 | 40 | 34.201190000000004 | 131.573293 | 2021-04-05 04:20:35 | Yamaguchi, Japan | ||
3710186 | 3710186 | 2021-04-03 | Japan | Yamaguchi | 1435 | 43 | 1353 | 39 | 34.201190000000004 | 131.573293 | 2021-04-04 04:20:49 | Yamaguchi, Japan | ||
241302 | 241302 | 2021-04-02 | Japan | Yamaguchi | 1427 | 43 | 1351 | 33 | 34.201190000000004 | 131.573293 | 2021-04-03 04:20:44 | Yamaguchi, Japan | ||
1302099 | 1302099 | 2021-04-01 | Japan | Yamaguchi | 1421 | 43 | 1351 | 27 | 34.201190000000004 | 131.573293 | 2021-04-02 04:20:36 | Yamaguchi, Japan | ||
637971 | 637971 | 2021-03-31 | Japan | Yamaguchi | 1418 | 43 | 1349 | 26 | 34.201190000000004 | 131.573293 | 2021-04-01 04:27:05 | Yamaguchi, Japan | ||
3643600 | 3643600 | 2021-03-30 | Japan | Yamaguchi | 1415 | 43 | 1349 | 23 | 34.201190000000004 | 131.573293 | 2021-03-31 04:26:25 | Yamaguchi, Japan | ||
1290053 | 1290053 | 2021-03-29 | Japan | Yamaguchi | 1409 | 43 | 1348 | 18 | 34.201190000000004 | 131.573293 | 2021-03-30 04:26:23 | Yamaguchi, Japan | ||
1535975 | 1535975 | 2021-03-28 | Japan | Yamaguchi | 1406 | 43 | 1345 | 18 | 34.201190000000004 | 131.573293 | 2021-03-29 04:28:35 | Yamaguchi, Japan | ||
1219615 | 1219615 | 2021-03-27 | Japan | Yamaguchi | 1406 | 43 | 1345 | 18 | 34.201190000000004 | 131.573293 | 2021-03-28 05:28:10 | Yamaguchi, Japan | ||
1881033 | 1881033 | 2021-03-26 | Japan | Yamaguchi | 1403 | 43 | 1345 | 15 | 34.201190000000004 | 131.573293 | 2021-03-27 05:25:04 | Yamaguchi, Japan | ||
1980663 | 1980663 | 2021-03-25 | Japan | Yamaguchi | 1403 | 43 | 1343 | 17 | 34.201190000000004 | 131.573293 | 2021-03-26 05:26:55 | Yamaguchi, Japan | ||
2781041 | 2781041 | 2021-03-24 | Japan | Yamaguchi | 1402 | 43 | 1341 | 18 | 34.201190000000004 | 131.573293 | 2021-03-25 05:27:00 | Yamaguchi, Japan | ||
1798686 | 1798686 | 2021-03-23 | Japan | Yamaguchi | 1399 | 43 | 1336 | 20 | 34.201190000000004 | 131.573293 | 2021-03-24 05:25:40 | Yamaguchi, Japan | ||
1203854 | 1203854 | 2021-03-22 | Japan | Yamaguchi | 1397 | 43 | 1336 | 18 | 34.201190000000004 | 131.573293 | 2021-03-23 05:26:18 | Yamaguchi, Japan | ||
3369376 | 3369376 | 2021-03-21 | Japan | Yamaguchi | 1397 | 43 | 1336 | 18 | 34.201190000000004 | 131.573293 | 2021-03-22 05:25:43 | Yamaguchi, Japan | ||
1744586 | 1744586 | 2021-03-20 | Japan | Yamaguchi | 1397 | 43 | 1336 | 18 | 34.201190000000004 | 131.573293 | 2021-03-21 05:25:44 | Yamaguchi, Japan | ||
3420966 | 3420966 | 2021-03-19 | Japan | Yamaguchi | 1397 | 43 | 1336 | 18 | 34.201190000000004 | 131.573293 | 2021-03-20 05:25:46 | Yamaguchi, Japan | ||
3452904 | 3452904 | 2021-03-18 | Japan | Yamaguchi | 1396 | 43 | 1335 | 18 | 34.201190000000004 | 131.573293 | 2021-03-19 05:26:09 | Yamaguchi, Japan | ||
3621128 | 3621128 | 2021-03-17 | Japan | Yamaguchi | 1395 | 43 | 1331 | 21 | 34.201190000000004 | 131.573293 | 2021-03-18 05:26:22 | Yamaguchi, Japan | ||
702452 | 702452 | 2021-03-16 | Japan | Yamaguchi | 1393 | 43 | 1326 | 24 | 34.201190000000004 | 131.573293 | 2021-03-17 05:25:07 | Yamaguchi, 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]);