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 = "Kagawa" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2533398 | 2533398 | 2022-05-12 | Japan | Kagawa | 42878 | 123 | 0 | 34.217292 | 133.969047 | 2022-05-13 04:20:51 | Kagawa, Japan | |||
3444844 | 3444844 | 2022-05-11 | Japan | Kagawa | 42513 | 122 | 0 | 34.217292 | 133.969047 | 2022-05-12 04:20:54 | Kagawa, Japan | |||
3535461 | 3535461 | 2022-05-10 | Japan | Kagawa | 42032 | 122 | 0 | 34.217292 | 133.969047 | 2022-05-11 04:20:48 | Kagawa, Japan | |||
221996 | 221996 | 2022-05-09 | Japan | Kagawa | 41595 | 122 | 0 | 34.217292 | 133.969047 | 2022-05-10 04:20:50 | Kagawa, Japan | |||
2331381 | 2331381 | 2022-05-08 | Japan | Kagawa | 41323 | 122 | 0 | 34.217292 | 133.969047 | 2022-05-09 04:20:54 | Kagawa, Japan | |||
360343 | 360343 | 2022-05-07 | Japan | Kagawa | 40813 | 121 | 0 | 34.217292 | 133.969047 | 2022-05-08 04:20:49 | Kagawa, Japan | |||
1397694 | 1397694 | 2022-05-06 | Japan | Kagawa | 40410 | 121 | 0 | 34.217292 | 133.969047 | 2022-05-07 04:21:09 | Kagawa, Japan | |||
2598049 | 2598049 | 2022-05-05 | Japan | Kagawa | 40264 | 120 | 0 | 34.217292 | 133.969047 | 2022-05-06 04:21:00 | Kagawa, Japan | |||
3265498 | 3265498 | 2022-05-04 | Japan | Kagawa | 40117 | 120 | 0 | 34.217292 | 133.969047 | 2022-05-05 04:20:55 | Kagawa, Japan | |||
1572137 | 1572137 | 2022-05-03 | Japan | Kagawa | 39905 | 120 | 0 | 34.217292 | 133.969047 | 2022-05-04 04:20:59 | Kagawa, Japan | |||
463397 | 463397 | 2022-05-02 | Japan | Kagawa | 39579 | 120 | 0 | 34.217292 | 133.969047 | 2022-05-03 04:21:00 | Kagawa, Japan | |||
3916036 | 3916036 | 2022-05-01 | Japan | Kagawa | 39495 | 120 | 0 | 34.217292 | 133.969047 | 2022-05-02 04:21:10 | Kagawa, Japan | |||
2840840 | 2840840 | 2022-04-30 | Japan | Kagawa | 39203 | 120 | 0 | 34.217292 | 133.969047 | 2022-05-01 04:20:57 | Kagawa, Japan | |||
1157153 | 1157153 | 2022-04-29 | Japan | Kagawa | 39072 | 120 | 0 | 34.217292 | 133.969047 | 2022-04-30 04:21:05 | Kagawa, Japan | |||
1696335 | 1696335 | 2022-04-28 | Japan | Kagawa | 38790 | 120 | 0 | 34.217292 | 133.969047 | 2022-04-29 04:20:59 | Kagawa, Japan | |||
3851818 | 3851818 | 2022-04-27 | Japan | Kagawa | 38448 | 120 | 0 | 34.217292 | 133.969047 | 2022-04-28 04:20:47 | Kagawa, Japan | |||
1326248 | 1326248 | 2022-04-26 | Japan | Kagawa | 38036 | 120 | 0 | 34.217292 | 133.969047 | 2022-04-27 04:20:52 | Kagawa, Japan | |||
3722202 | 3722202 | 2022-04-25 | Japan | Kagawa | 37682 | 118 | 0 | 34.217292 | 133.969047 | 2022-04-26 04:20:51 | Kagawa, Japan | |||
2028770 | 2028770 | 2022-04-24 | Japan | Kagawa | 37551 | 117 | 0 | 34.217292 | 133.969047 | 2022-04-25 04:20:56 | Kagawa, Japan | |||
746345 | 746345 | 2022-04-23 | Japan | Kagawa | 37234 | 117 | 0 | 34.217292 | 133.969047 | 2022-04-24 04:20:56 | Kagawa, Japan | |||
3436830 | 3436830 | 2022-04-22 | Japan | Kagawa | 36864 | 116 | 0 | 34.217292 | 133.969047 | 2022-04-23 04:20:50 | Kagawa, Japan | |||
2892415 | 2892415 | 2022-04-21 | Japan | Kagawa | 36492 | 116 | 0 | 34.217292 | 133.969047 | 2022-04-22 04:20:45 | Kagawa, Japan | |||
2307287 | 2307287 | 2022-04-20 | Japan | Kagawa | 36143 | 116 | 0 | 34.217292 | 133.969047 | 2022-04-21 04:20:46 | Kagawa, Japan | |||
2251426 | 2251426 | 2022-04-19 | Japan | Kagawa | 35738 | 116 | 0 | 34.217292 | 133.969047 | 2022-04-20 04:20:45 | Kagawa, Japan | |||
1845976 | 1845976 | 2022-04-18 | Japan | Kagawa | 35355 | 116 | 0 | 34.217292 | 133.969047 | 2022-04-19 04:21:00 | Kagawa, Japan | |||
3416920 | 3416920 | 2022-04-17 | Japan | Kagawa | 35211 | 116 | 0 | 34.217292 | 133.969047 | 2022-04-18 04:21:12 | Kagawa, Japan | |||
303869 | 303869 | 2022-04-16 | Japan | Kagawa | 34858 | 116 | 0 | 34.217292 | 133.969047 | 2022-04-17 04:20:59 | Kagawa, Japan | |||
2669814 | 2669814 | 2022-04-15 | Japan | Kagawa | 34432 | 116 | 0 | 34.217292 | 133.969047 | 2022-04-16 04:20:48 | Kagawa, Japan | |||
1223599 | 1223599 | 2022-04-14 | Japan | Kagawa | 34052 | 116 | 0 | 34.217292 | 133.969047 | 2022-04-15 04:20:57 | Kagawa, Japan | |||
2442757 | 2442757 | 2022-04-13 | Japan | Kagawa | 33666 | 116 | 0 | 34.217292 | 133.969047 | 2022-04-13 23:21:06 | Kagawa, Japan | |||
1948514 | 1948514 | 2022-04-12 | Japan | Kagawa | 33242 | 114 | 0 | 34.217292 | 133.969047 | 2022-04-13 04:21:03 | Kagawa, Japan | |||
3206267 | 3206267 | 2022-04-11 | Japan | Kagawa | 32840 | 114 | 0 | 34.217292 | 133.969047 | 2022-04-12 04:20:49 | Kagawa, Japan | |||
1576153 | 1576153 | 2022-04-10 | Japan | Kagawa | 32667 | 114 | 0 | 34.217292 | 133.969047 | 2022-04-11 04:21:02 | Kagawa, Japan | |||
1652395 | 1652395 | 2022-04-09 | Japan | Kagawa | 32343 | 114 | 0 | 34.217292 | 133.969047 | 2022-04-10 04:20:52 | Kagawa, Japan | |||
2115717 | 2115717 | 2022-04-08 | Japan | Kagawa | 31993 | 113 | 0 | 34.217292 | 133.969047 | 2022-04-09 04:20:42 | Kagawa, Japan | |||
3320241 | 3320241 | 2022-04-07 | Japan | Kagawa | 31706 | 113 | 0 | 34.217292 | 133.969047 | 2022-04-08 04:20:48 | Kagawa, Japan | |||
2800777 | 2800777 | 2022-04-06 | Japan | Kagawa | 31405 | 113 | 0 | 34.217292 | 133.969047 | 2022-04-07 04:20:53 | Kagawa, Japan | |||
3867546 | 3867546 | 2022-04-05 | Japan | Kagawa | 31076 | 113 | 0 | 34.217292 | 133.969047 | 2022-04-06 04:20:49 | Kagawa, Japan | |||
2748888 | 2748888 | 2022-04-04 | Japan | Kagawa | 30714 | 113 | 0 | 34.217292 | 133.969047 | 2022-04-05 04:20:48 | Kagawa, Japan | |||
3730234 | 3730234 | 2022-04-03 | Japan | Kagawa | 30577 | 113 | 0 | 34.217292 | 133.969047 | 2022-04-04 04:20:51 | Kagawa, Japan | |||
499669 | 499669 | 2022-04-02 | Japan | Kagawa | 30241 | 113 | 0 | 34.217292 | 133.969047 | 2022-04-03 04:20:48 | Kagawa, Japan | |||
3350654 | 3350654 | 2022-04-01 | Japan | Kagawa | 29937 | 113 | 0 | 34.217292 | 133.969047 | 2022-04-02 04:20:47 | Kagawa, Japan | |||
1539959 | 1539959 | 2022-03-31 | Japan | Kagawa | 29596 | 111 | 0 | 34.217292 | 133.969047 | 2022-04-01 04:20:28 | Kagawa, Japan | |||
2477972 | 2477972 | 2022-03-30 | Japan | Kagawa | 29288 | 109 | 0 | 34.217292 | 133.969047 | 2022-03-31 04:20:56 | Kagawa, Japan | |||
158013 | 158013 | 2022-03-29 | Japan | Kagawa | 28884 | 108 | 0 | 34.217292 | 133.969047 | 2022-03-30 04:20:45 | Kagawa, Japan | |||
1436584 | 1436584 | 2022-03-28 | Japan | Kagawa | 28540 | 108 | 0 | 34.217292 | 133.969047 | 2022-03-29 04:20:46 | Kagawa, Japan | |||
876265 | 876265 | 2022-03-27 | Japan | Kagawa | 28389 | 107 | 0 | 34.217292 | 133.969047 | 2022-03-28 04:20:33 | Kagawa, Japan | |||
2163548 | 2163548 | 2022-03-26 | Japan | Kagawa | 28104 | 106 | 0 | 34.217292 | 133.969047 | 2022-03-27 04:20:47 | Kagawa, Japan | |||
1720484 | 1720484 | 2022-03-25 | Japan | Kagawa | 27831 | 105 | 0 | 34.217292 | 133.969047 | 2022-03-26 04:20:23 | Kagawa, Japan | |||
1468101 | 1468101 | 2022-03-24 | Japan | Kagawa | 27513 | 105 | 0 | 34.217292 | 133.969047 | 2022-03-25 04:20:46 | Kagawa, Japan | |||
3022275 | 3022275 | 2022-03-23 | Japan | Kagawa | 27095 | 102 | 0 | 34.217292 | 133.969047 | 2022-03-24 04:20:43 | Kagawa, Japan | |||
1905197 | 1905197 | 2022-03-22 | Japan | Kagawa | 26671 | 102 | 0 | 34.217292 | 133.969047 | 2022-03-23 04:20:48 | Kagawa, Japan | |||
3238328 | 3238328 | 2022-03-21 | Japan | Kagawa | 26513 | 101 | 0 | 34.217292 | 133.969047 | 2022-03-22 04:20:54 | Kagawa, Japan | |||
24401 | 24401 | 2022-03-20 | Japan | Kagawa | 26319 | 100 | 0 | 34.217292 | 133.969047 | 2022-03-21 04:20:50 | Kagawa, Japan | |||
1656411 | 1656411 | 2022-03-19 | Japan | Kagawa | 26018 | 99 | 0 | 34.217292 | 133.969047 | 2022-03-20 04:20:45 | Kagawa, Japan | |||
335937 | 335937 | 2022-03-18 | Japan | Kagawa | 25685 | 98 | 0 | 34.217292 | 133.969047 | 2022-03-19 04:20:47 | Kagawa, Japan | |||
694390 | 694390 | 2022-03-17 | Japan | Kagawa | 25316 | 96 | 0 | 34.217292 | 133.969047 | 2022-03-18 04:20:55 | Kagawa, Japan | |||
2319333 | 2319333 | 2022-03-16 | Japan | Kagawa | 24928 | 95 | 0 | 34.217292 | 133.969047 | 2022-03-17 04:20:56 | Kagawa, Japan | |||
261533 | 261533 | 2022-03-15 | Japan | Kagawa | 24465 | 95 | 0 | 34.217292 | 133.969047 | 2022-03-16 04:20:50 | Kagawa, Japan | |||
2263892 | 2263892 | 2022-03-14 | Japan | Kagawa | 24049 | 91 | 0 | 34.217292 | 133.969047 | 2022-03-15 04:20:47 | Kagawa, Japan | |||
3627958 | 3627958 | 2022-03-13 | Japan | Kagawa | 23819 | 89 | 0 | 34.217292 | 133.969047 | 2022-03-14 04:20:46 | Kagawa, Japan | |||
950866 | 950866 | 2022-03-12 | Japan | Kagawa | 23381 | 87 | 0 | 34.217292 | 133.969047 | 2022-03-13 04:20:49 | Kagawa, Japan | |||
356327 | 356327 | 2022-03-11 | Japan | Kagawa | 22950 | 87 | 0 | 34.217292 | 133.969047 | 2022-03-12 04:20:50 | Kagawa, Japan | |||
1865479 | 1865479 | 2022-03-10 | Japan | Kagawa | 22522 | 87 | 0 | 34.217292 | 133.969047 | 2022-03-11 04:20:50 | Kagawa, Japan | |||
2140174 | 2140174 | 2022-03-09 | Japan | Kagawa | 22052 | 86 | 0 | 34.217292 | 133.969047 | 2022-03-10 04:20:48 | Kagawa, Japan | |||
919685 | 919685 | 2022-03-08 | Japan | Kagawa | 21624 | 85 | 0 | 34.217292 | 133.969047 | 2022-03-09 04:20:59 | Kagawa, Japan | |||
1547972 | 1547972 | 2022-03-07 | Japan | Kagawa | 21190 | 85 | 0 | 34.217292 | 133.969047 | 2022-03-08 04:20:54 | Kagawa, Japan | |||
2199641 | 2199641 | 2022-03-06 | Japan | Kagawa | 21011 | 82 | 0 | 34.217292 | 133.969047 | 2022-03-07 04:20:47 | Kagawa, Japan | |||
2092098 | 2092098 | 2022-03-05 | Japan | Kagawa | 20678 | 80 | 0 | 34.217292 | 133.969047 | 2022-03-06 04:20:49 | Kagawa, Japan | |||
2665798 | 2665798 | 2022-03-04 | Japan | Kagawa | 20261 | 80 | 0 | 34.217292 | 133.969047 | 2022-03-05 04:21:10 | Kagawa, Japan | |||
1644363 | 1644363 | 2022-03-03 | Japan | Kagawa | 19816 | 79 | 0 | 34.217292 | 133.969047 | 2022-03-04 04:21:09 | Kagawa, Japan | |||
2525366 | 2525366 | 2022-03-02 | Japan | Kagawa | 19393 | 79 | 0 | 34.217292 | 133.969047 | 2022-03-03 04:21:01 | Kagawa, Japan | |||
1992660 | 1992660 | 2022-03-01 | Japan | Kagawa | 18957 | 78 | 0 | 34.217292 | 133.969047 | 2022-03-02 04:21:07 | Kagawa, Japan | |||
942834 | 942834 | 2022-02-28 | Japan | Kagawa | 18545 | 78 | 0 | 34.217292 | 133.969047 | 2022-03-01 04:21:09 | Kagawa, Japan | |||
2733025 | 2733025 | 2022-02-27 | Japan | Kagawa | 18314 | 74 | 0 | 34.217292 | 133.969047 | 2022-02-28 04:21:05 | Kagawa, Japan | |||
3046178 | 3046178 | 2022-02-26 | Japan | Kagawa | 17897 | 72 | 0 | 34.217292 | 133.969047 | 2022-02-27 04:21:04 | Kagawa, Japan | |||
574833 | 574833 | 2022-02-25 | Japan | Kagawa | 17432 | 71 | 0 | 34.217292 | 133.969047 | 2022-02-26 04:21:12 | Kagawa, Japan | |||
1511409 | 1511409 | 2022-02-24 | Japan | Kagawa | 17019 | 69 | 0 | 34.217292 | 133.969047 | 2022-02-25 04:21:11 | Kagawa, Japan | |||
1057850 | 1057850 | 2022-02-23 | Japan | Kagawa | 16760 | 66 | 0 | 34.217292 | 133.969047 | 2022-02-24 04:21:14 | Kagawa, Japan | |||
2446773 | 2446773 | 2022-02-22 | Japan | Kagawa | 16271 | 64 | 0 | 34.217292 | 133.969047 | 2022-02-23 04:21:09 | Kagawa, Japan | |||
3718186 | 3718186 | 2022-02-21 | Japan | Kagawa | 15866 | 63 | 0 | 34.217292 | 133.969047 | 2022-02-22 04:21:01 | Kagawa, Japan | |||
3912020 | 3912020 | 2022-02-20 | Japan | Kagawa | 15609 | 60 | 0 | 34.217292 | 133.969047 | 2022-02-21 04:21:05 | Kagawa, Japan | |||
3875578 | 3875578 | 2022-02-19 | Japan | Kagawa | 15207 | 58 | 0 | 34.217292 | 133.969047 | 2022-02-20 04:21:00 | Kagawa, Japan | |||
3855834 | 3855834 | 2022-02-18 | Japan | Kagawa | 14713 | 58 | 0 | 34.217292 | 133.969047 | 2022-02-19 04:21:11 | Kagawa, Japan | |||
1298053 | 1298053 | 2022-02-17 | Japan | Kagawa | 14269 | 57 | 0 | 34.217292 | 133.969047 | 2022-02-18 04:21:04 | Kagawa, Japan | |||
3820439 | 3820439 | 2022-02-16 | Japan | Kagawa | 13861 | 57 | 0 | 34.217292 | 133.969047 | 2022-02-17 04:20:56 | Kagawa, Japan | |||
3671653 | 3671653 | 2022-02-15 | Japan | Kagawa | 13422 | 56 | 0 | 34.217292 | 133.969047 | 2022-02-16 04:21:10 | Kagawa, Japan | |||
2641754 | 2641754 | 2022-02-14 | Japan | Kagawa | 12987 | 55 | 0 | 34.217292 | 133.969047 | 2022-02-15 04:21:09 | Kagawa, Japan | |||
186071 | 186071 | 2022-02-13 | Japan | Kagawa | 12830 | 53 | 0 | 34.217292 | 133.969047 | 2022-02-14 04:20:51 | Kagawa, Japan | |||
315917 | 315917 | 2022-02-12 | Japan | Kagawa | 12508 | 52 | 0 | 34.217292 | 133.969047 | 2022-02-13 04:21:00 | Kagawa, Japan | |||
233243 | 233243 | 2022-02-11 | Japan | Kagawa | 12283 | 50 | 0 | 34.217292 | 133.969047 | 2022-02-12 04:21:06 | Kagawa, Japan | |||
1464085 | 1464085 | 2022-02-10 | Japan | Kagawa | 11912 | 50 | 0 | 34.217292 | 133.969047 | 2022-02-11 04:21:09 | Kagawa, Japan | |||
3074046 | 3074046 | 2022-02-09 | Japan | Kagawa | 11544 | 48 | 0 | 34.217292 | 133.969047 | 2022-02-10 04:21:14 | Kagawa, Japan | |||
1362353 | 1362353 | 2022-02-08 | Japan | Kagawa | 11130 | 48 | 0 | 34.217292 | 133.969047 | 2022-02-09 04:21:04 | Kagawa, Japan | |||
71091 | 71091 | 2022-02-07 | Japan | Kagawa | 10772 | 47 | 0 | 34.217292 | 133.969047 | 2022-02-08 04:21:15 | Kagawa, Japan | |||
2012707 | 2012707 | 2022-02-06 | Japan | Kagawa | 10566 | 46 | 0 | 34.217292 | 133.969047 | 2022-02-07 04:21:05 | Kagawa, Japan | |||
1294036 | 1294036 | 2022-02-05 | Japan | Kagawa | 10235 | 45 | 0 | 34.217292 | 133.969047 | 2022-02-06 04:21:00 | Kagawa, Japan | |||
2327364 | 2327364 | 2022-02-04 | Japan | Kagawa | 9926 | 44 | 0 | 34.217292 | 133.969047 | 2022-02-05 04:21:05 | Kagawa, Japan | |||
2473955 | 2473955 | 2022-02-03 | Japan | Kagawa | 9558 | 44 | 0 | 34.217292 | 133.969047 | 2022-02-04 04:21:10 | Kagawa, Japan | |||
459380 | 459380 | 2022-02-02 | Japan | Kagawa | 9142 | 43 | 0 | 34.217292 | 133.969047 | 2022-02-03 04:21:21 | Kagawa, 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]);