johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where country_or_region = "Japan" and province_or_state = "Akita" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2533383 | 2533383 | 2022-05-12 | Japan | Akita | 27698 | 64 | 0 | 39.748679 | 140.408228 | 2022-05-13 04:20:51 | Akita, Japan | |||
3444829 | 3444829 | 2022-05-11 | Japan | Akita | 27475 | 64 | 0 | 39.748679 | 140.408228 | 2022-05-12 04:20:54 | Akita, Japan | |||
3535446 | 3535446 | 2022-05-10 | Japan | Akita | 27213 | 64 | 0 | 39.748679 | 140.408228 | 2022-05-11 04:20:48 | Akita, Japan | |||
221981 | 221981 | 2022-05-09 | Japan | Akita | 26841 | 64 | 0 | 39.748679 | 140.408228 | 2022-05-10 04:20:50 | Akita, Japan | |||
2331366 | 2331366 | 2022-05-08 | Japan | Akita | 26652 | 64 | 0 | 39.748679 | 140.408228 | 2022-05-09 04:20:54 | Akita, Japan | |||
360328 | 360328 | 2022-05-07 | Japan | Akita | 26383 | 62 | 0 | 39.748679 | 140.408228 | 2022-05-08 04:20:49 | Akita, Japan | |||
1397679 | 1397679 | 2022-05-06 | Japan | Akita | 26054 | 62 | 0 | 39.748679 | 140.408228 | 2022-05-07 04:21:09 | Akita, Japan | |||
2598034 | 2598034 | 2022-05-05 | Japan | Akita | 25873 | 62 | 0 | 39.748679 | 140.408228 | 2022-05-06 04:21:00 | Akita, Japan | |||
3265483 | 3265483 | 2022-05-04 | Japan | Akita | 25703 | 60 | 0 | 39.748679 | 140.408228 | 2022-05-05 04:20:55 | Akita, Japan | |||
1572122 | 1572122 | 2022-05-03 | Japan | Akita | 25530 | 60 | 0 | 39.748679 | 140.408228 | 2022-05-04 04:20:59 | Akita, Japan | |||
463382 | 463382 | 2022-05-02 | Japan | Akita | 25220 | 57 | 0 | 39.748679 | 140.408228 | 2022-05-03 04:21:00 | Akita, Japan | |||
3916021 | 3916021 | 2022-05-01 | Japan | Akita | 25106 | 57 | 0 | 39.748679 | 140.408228 | 2022-05-02 04:21:10 | Akita, Japan | |||
2840825 | 2840825 | 2022-04-30 | Japan | Akita | 24877 | 57 | 0 | 39.748679 | 140.408228 | 2022-05-01 04:20:57 | Akita, Japan | |||
1157138 | 1157138 | 2022-04-29 | Japan | Akita | 24698 | 57 | 0 | 39.748679 | 140.408228 | 2022-04-30 04:21:05 | Akita, Japan | |||
1696320 | 1696320 | 2022-04-28 | Japan | Akita | 24421 | 57 | 0 | 39.748679 | 140.408228 | 2022-04-29 04:20:59 | Akita, Japan | |||
3851803 | 3851803 | 2022-04-27 | Japan | Akita | 24119 | 57 | 0 | 39.748679 | 140.408228 | 2022-04-28 04:20:47 | Akita, Japan | |||
1326233 | 1326233 | 2022-04-26 | Japan | Akita | 23805 | 54 | 0 | 39.748678999999996 | 140.408228 | 2022-04-27 04:20:52 | Akita, Japan | |||
3722187 | 3722187 | 2022-04-25 | Japan | Akita | 23466 | 54 | 0 | 39.748678999999996 | 140.408228 | 2022-04-26 04:20:51 | Akita, Japan | |||
2028755 | 2028755 | 2022-04-24 | Japan | Akita | 23342 | 52 | 0 | 39.748678999999996 | 140.408228 | 2022-04-25 04:20:56 | Akita, Japan | |||
746330 | 746330 | 2022-04-23 | Japan | Akita | 23070 | 52 | 0 | 39.748678999999996 | 140.408228 | 2022-04-24 04:20:56 | Akita, Japan | |||
3436815 | 3436815 | 2022-04-22 | Japan | Akita | 22787 | 52 | 0 | 39.748678999999996 | 140.408228 | 2022-04-23 04:20:50 | Akita, Japan | |||
2892400 | 2892400 | 2022-04-21 | Japan | Akita | 22549 | 52 | 0 | 39.748678999999996 | 140.408228 | 2022-04-22 04:20:45 | Akita, Japan | |||
2307272 | 2307272 | 2022-04-20 | Japan | Akita | 22261 | 52 | 0 | 39.748678999999996 | 140.408228 | 2022-04-21 04:20:46 | Akita, Japan | |||
2251411 | 2251411 | 2022-04-19 | Japan | Akita | 21973 | 52 | 0 | 39.748678999999996 | 140.408228 | 2022-04-20 04:20:45 | Akita, Japan | |||
1845961 | 1845961 | 2022-04-18 | Japan | Akita | 21610 | 52 | 0 | 39.748678999999996 | 140.408228 | 2022-04-19 04:21:00 | Akita, Japan | |||
3416905 | 3416905 | 2022-04-17 | Japan | Akita | 21429 | 52 | 0 | 39.748678999999996 | 140.408228 | 2022-04-18 04:21:12 | Akita, Japan | |||
303854 | 303854 | 2022-04-16 | Japan | Akita | 21182 | 52 | 0 | 39.748678999999996 | 140.408228 | 2022-04-17 04:20:59 | Akita, Japan | |||
2669799 | 2669799 | 2022-04-15 | Japan | Akita | 20886 | 52 | 0 | 39.748678999999996 | 140.408228 | 2022-04-16 04:20:48 | Akita, Japan | |||
1223584 | 1223584 | 2022-04-14 | Japan | Akita | 20524 | 51 | 0 | 39.748678999999996 | 140.408228 | 2022-04-15 04:20:57 | Akita, Japan | |||
2442742 | 2442742 | 2022-04-13 | Japan | Akita | 20167 | 51 | 0 | 39.748678999999996 | 140.408228 | 2022-04-13 23:21:06 | Akita, Japan | |||
1948499 | 1948499 | 2022-04-12 | Japan | Akita | 19808 | 49 | 0 | 39.748678999999996 | 140.408228 | 2022-04-13 04:21:03 | Akita, Japan | |||
3206252 | 3206252 | 2022-04-11 | Japan | Akita | 19363 | 49 | 0 | 39.748678999999996 | 140.408228 | 2022-04-12 04:20:49 | Akita, Japan | |||
1576138 | 1576138 | 2022-04-10 | Japan | Akita | 19218 | 49 | 0 | 39.748678999999996 | 140.408228 | 2022-04-11 04:21:02 | Akita, Japan | |||
1652380 | 1652380 | 2022-04-09 | Japan | Akita | 18966 | 49 | 0 | 39.748678999999996 | 140.408228 | 2022-04-10 04:20:52 | Akita, Japan | |||
2115702 | 2115702 | 2022-04-08 | Japan | Akita | 18681 | 49 | 0 | 39.748678999999996 | 140.408228 | 2022-04-09 04:20:42 | Akita, Japan | |||
3320226 | 3320226 | 2022-04-07 | Japan | Akita | 18316 | 49 | 0 | 39.748678999999996 | 140.408228 | 2022-04-08 04:20:48 | Akita, Japan | |||
2800762 | 2800762 | 2022-04-06 | Japan | Akita | 17970 | 49 | 0 | 39.748678999999996 | 140.408228 | 2022-04-07 04:20:53 | Akita, Japan | |||
3867531 | 3867531 | 2022-04-05 | Japan | Akita | 17634 | 49 | 0 | 39.748678999999996 | 140.408228 | 2022-04-06 04:20:49 | Akita, Japan | |||
2748873 | 2748873 | 2022-04-04 | Japan | Akita | 17245 | 49 | 0 | 39.748678999999996 | 140.408228 | 2022-04-05 04:20:48 | Akita, Japan | |||
3730219 | 3730219 | 2022-04-03 | Japan | Akita | 17097 | 47 | 0 | 39.748678999999996 | 140.408228 | 2022-04-04 04:20:51 | Akita, Japan | |||
499654 | 499654 | 2022-04-02 | Japan | Akita | 16876 | 47 | 0 | 39.748678999999996 | 140.408228 | 2022-04-03 04:20:48 | Akita, Japan | |||
3350639 | 3350639 | 2022-04-01 | Japan | Akita | 16599 | 46 | 0 | 39.748678999999996 | 140.408228 | 2022-04-02 04:20:47 | Akita, Japan | |||
1539944 | 1539944 | 2022-03-31 | Japan | Akita | 16333 | 46 | 0 | 39.748678999999996 | 140.408228 | 2022-04-01 04:20:28 | Akita, Japan | |||
2477957 | 2477957 | 2022-03-30 | Japan | Akita | 16049 | 45 | 0 | 39.748678999999996 | 140.408228 | 2022-03-31 04:20:56 | Akita, Japan | |||
157998 | 157998 | 2022-03-29 | Japan | Akita | 15746 | 45 | 0 | 39.748678999999996 | 140.408228 | 2022-03-30 04:20:45 | Akita, Japan | |||
1436569 | 1436569 | 2022-03-28 | Japan | Akita | 15421 | 45 | 0 | 39.748678999999996 | 140.408228 | 2022-03-29 04:20:46 | Akita, Japan | |||
876250 | 876250 | 2022-03-27 | Japan | Akita | 15269 | 45 | 0 | 39.748678999999996 | 140.408228 | 2022-03-28 04:20:33 | Akita, Japan | |||
2163533 | 2163533 | 2022-03-26 | Japan | Akita | 15038 | 45 | 0 | 39.748678999999996 | 140.408228 | 2022-03-27 04:20:47 | Akita, Japan | |||
1720469 | 1720469 | 2022-03-25 | Japan | Akita | 14750 | 45 | 0 | 39.748678999999996 | 140.408228 | 2022-03-26 04:20:23 | Akita, Japan | |||
1468086 | 1468086 | 2022-03-24 | Japan | Akita | 14494 | 45 | 0 | 39.748678999999996 | 140.408228 | 2022-03-25 04:20:46 | Akita, Japan | |||
3022260 | 3022260 | 2022-03-23 | Japan | Akita | 14256 | 44 | 0 | 39.748678999999996 | 140.408228 | 2022-03-24 04:20:43 | Akita, Japan | |||
1905182 | 1905182 | 2022-03-22 | Japan | Akita | 13970 | 44 | 0 | 39.748678999999996 | 140.408228 | 2022-03-23 04:20:48 | Akita, Japan | |||
3238313 | 3238313 | 2022-03-21 | Japan | Akita | 13862 | 44 | 0 | 39.748678999999996 | 140.408228 | 2022-03-22 04:20:54 | Akita, Japan | |||
24386 | 24386 | 2022-03-20 | Japan | Akita | 13727 | 43 | 0 | 39.748678999999996 | 140.408228 | 2022-03-21 04:20:50 | Akita, Japan | |||
1656396 | 1656396 | 2022-03-19 | Japan | Akita | 13554 | 43 | 0 | 39.748678999999996 | 140.408228 | 2022-03-20 04:20:45 | Akita, Japan | |||
335922 | 335922 | 2022-03-18 | Japan | Akita | 13329 | 43 | 0 | 39.748678999999996 | 140.408228 | 2022-03-19 04:20:47 | Akita, Japan | |||
694375 | 694375 | 2022-03-17 | Japan | Akita | 13135 | 43 | 0 | 39.748678999999996 | 140.408228 | 2022-03-18 04:20:55 | Akita, Japan | |||
2319318 | 2319318 | 2022-03-16 | Japan | Akita | 12928 | 43 | 0 | 39.748678999999996 | 140.408228 | 2022-03-17 04:20:56 | Akita, Japan | |||
261518 | 261518 | 2022-03-15 | Japan | Akita | 12701 | 43 | 0 | 39.748678999999996 | 140.408228 | 2022-03-16 04:20:50 | Akita, Japan | |||
2263877 | 2263877 | 2022-03-14 | Japan | Akita | 12407 | 41 | 0 | 39.748678999999996 | 140.408228 | 2022-03-15 04:20:47 | Akita, Japan | |||
3627943 | 3627943 | 2022-03-13 | Japan | Akita | 12307 | 41 | 0 | 39.748678999999996 | 140.408228 | 2022-03-14 04:20:46 | Akita, Japan | |||
950851 | 950851 | 2022-03-12 | Japan | Akita | 12126 | 41 | 0 | 39.748678999999996 | 140.408228 | 2022-03-13 04:20:49 | Akita, Japan | |||
356312 | 356312 | 2022-03-11 | Japan | Akita | 11913 | 40 | 0 | 39.748678999999996 | 140.408228 | 2022-03-12 04:20:50 | Akita, Japan | |||
1865464 | 1865464 | 2022-03-10 | Japan | Akita | 11723 | 40 | 0 | 39.748678999999996 | 140.408228 | 2022-03-11 04:20:50 | Akita, Japan | |||
2140159 | 2140159 | 2022-03-09 | Japan | Akita | 11519 | 40 | 0 | 39.748678999999996 | 140.408228 | 2022-03-10 04:20:48 | Akita, Japan | |||
919670 | 919670 | 2022-03-08 | Japan | Akita | 11289 | 40 | 0 | 39.748678999999996 | 140.408228 | 2022-03-09 04:20:59 | Akita, Japan | |||
1547957 | 1547957 | 2022-03-07 | Japan | Akita | 11039 | 37 | 0 | 39.748678999999996 | 140.408228 | 2022-03-08 04:20:54 | Akita, Japan | |||
2199626 | 2199626 | 2022-03-06 | Japan | Akita | 10926 | 37 | 0 | 39.748678999999996 | 140.408228 | 2022-03-07 04:20:47 | Akita, Japan | |||
2092083 | 2092083 | 2022-03-05 | Japan | Akita | 10769 | 35 | 0 | 39.748678999999996 | 140.408228 | 2022-03-06 04:20:49 | Akita, Japan | |||
2665783 | 2665783 | 2022-03-04 | Japan | Akita | 10547 | 35 | 0 | 39.748678999999996 | 140.408228 | 2022-03-05 04:21:10 | Akita, Japan | |||
1644348 | 1644348 | 2022-03-03 | Japan | Akita | 10301 | 33 | 0 | 39.748678999999996 | 140.408228 | 2022-03-04 04:21:09 | Akita, Japan | |||
2525351 | 2525351 | 2022-03-02 | Japan | Akita | 10065 | 33 | 0 | 39.748678999999996 | 140.408228 | 2022-03-03 04:21:01 | Akita, Japan | |||
1992645 | 1992645 | 2022-03-01 | Japan | Akita | 9828 | 33 | 0 | 39.748678999999996 | 140.408228 | 2022-03-02 04:21:07 | Akita, Japan | |||
942819 | 942819 | 2022-02-28 | Japan | Akita | 9529 | 32 | 0 | 39.748678999999996 | 140.408228 | 2022-03-01 04:21:09 | Akita, Japan | |||
2733010 | 2733010 | 2022-02-27 | Japan | Akita | 9410 | 32 | 0 | 39.748678999999996 | 140.408228 | 2022-02-28 04:21:05 | Akita, Japan | |||
3046163 | 3046163 | 2022-02-26 | Japan | Akita | 9237 | 32 | 0 | 39.748678999999996 | 140.408228 | 2022-02-27 04:21:04 | Akita, Japan | |||
574818 | 574818 | 2022-02-25 | Japan | Akita | 9003 | 32 | 0 | 39.748678999999996 | 140.408228 | 2022-02-26 04:21:12 | Akita, Japan | |||
1511394 | 1511394 | 2022-02-24 | Japan | Akita | 8736 | 31 | 0 | 39.748678999999996 | 140.408228 | 2022-02-25 04:21:11 | Akita, Japan | |||
1057835 | 1057835 | 2022-02-23 | Japan | Akita | 8614 | 31 | 0 | 39.748678999999996 | 140.408228 | 2022-02-24 04:21:14 | Akita, Japan | |||
2446758 | 2446758 | 2022-02-22 | Japan | Akita | 8389 | 31 | 0 | 39.748678999999996 | 140.408228 | 2022-02-23 04:21:09 | Akita, Japan | |||
3718171 | 3718171 | 2022-02-21 | Japan | Akita | 8118 | 31 | 0 | 39.748678999999996 | 140.408228 | 2022-02-22 04:21:01 | Akita, Japan | |||
3912005 | 3912005 | 2022-02-20 | Japan | Akita | 8000 | 31 | 0 | 39.748678999999996 | 140.408228 | 2022-02-21 04:21:05 | Akita, Japan | |||
3875563 | 3875563 | 2022-02-19 | Japan | Akita | 7836 | 31 | 0 | 39.748678999999996 | 140.408228 | 2022-02-20 04:21:00 | Akita, Japan | |||
3855819 | 3855819 | 2022-02-18 | Japan | Akita | 7608 | 31 | 0 | 39.748678999999996 | 140.408228 | 2022-02-19 04:21:11 | Akita, Japan | |||
1298038 | 1298038 | 2022-02-17 | Japan | Akita | 7392 | 31 | 0 | 39.748678999999996 | 140.408228 | 2022-02-18 04:21:04 | Akita, Japan | |||
3820424 | 3820424 | 2022-02-16 | Japan | Akita | 7191 | 29 | 0 | 39.748678999999996 | 140.408228 | 2022-02-17 04:20:56 | Akita, Japan | |||
3671638 | 3671638 | 2022-02-15 | Japan | Akita | 6973 | 29 | 0 | 39.748678999999996 | 140.408228 | 2022-02-16 04:21:10 | Akita, Japan | |||
2641739 | 2641739 | 2022-02-14 | Japan | Akita | 6752 | 29 | 0 | 39.748678999999996 | 140.408228 | 2022-02-15 04:21:09 | Akita, Japan | |||
186056 | 186056 | 2022-02-13 | Japan | Akita | 6655 | 29 | 0 | 39.748678999999996 | 140.408228 | 2022-02-14 04:20:51 | Akita, Japan | |||
315902 | 315902 | 2022-02-12 | Japan | Akita | 6506 | 29 | 0 | 39.748678999999996 | 140.408228 | 2022-02-13 04:21:00 | Akita, Japan | |||
233228 | 233228 | 2022-02-11 | Japan | Akita | 6376 | 29 | 0 | 39.748678999999996 | 140.408228 | 2022-02-12 04:21:06 | Akita, Japan | |||
1464070 | 1464070 | 2022-02-10 | Japan | Akita | 6155 | 29 | 0 | 39.748678999999996 | 140.408228 | 2022-02-11 04:21:09 | Akita, Japan | |||
3074031 | 3074031 | 2022-02-09 | Japan | Akita | 5939 | 27 | 0 | 39.748678999999996 | 140.408228 | 2022-02-10 04:21:14 | Akita, Japan | |||
1362338 | 1362338 | 2022-02-08 | Japan | Akita | 5719 | 27 | 0 | 39.748678999999996 | 140.408228 | 2022-02-09 04:21:04 | Akita, Japan | |||
71076 | 71076 | 2022-02-07 | Japan | Akita | 5477 | 27 | 0 | 39.748678999999996 | 140.408228 | 2022-02-08 04:21:15 | Akita, Japan | |||
2012692 | 2012692 | 2022-02-06 | Japan | Akita | 5380 | 27 | 0 | 39.748678999999996 | 140.408228 | 2022-02-07 04:21:05 | Akita, Japan | |||
1294021 | 1294021 | 2022-02-05 | Japan | Akita | 5206 | 27 | 0 | 39.748678999999996 | 140.408228 | 2022-02-06 04:21:00 | Akita, Japan | |||
2327349 | 2327349 | 2022-02-04 | Japan | Akita | 4947 | 27 | 0 | 39.748678999999996 | 140.408228 | 2022-02-05 04:21:05 | Akita, Japan | |||
2473940 | 2473940 | 2022-02-03 | Japan | Akita | 4795 | 27 | 0 | 39.748678999999996 | 140.408228 | 2022-02-04 04:21:10 | Akita, Japan | |||
459365 | 459365 | 2022-02-02 | Japan | Akita | 4606 | 27 | 0 | 39.748678999999996 | 140.408228 | 2022-02-03 04:21:21 | Akita, 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]);