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 = "Miyagi" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2533405 | 2533405 | 2022-05-12 | Japan | Miyagi | 78957 | 193 | 0 | 38.446859 | 140.927086 | 2022-05-13 04:20:51 | Miyagi, Japan | |||
3444851 | 3444851 | 2022-05-11 | Japan | Miyagi | 78482 | 192 | 0 | 38.446859 | 140.927086 | 2022-05-12 04:20:54 | Miyagi, Japan | |||
3535468 | 3535468 | 2022-05-10 | Japan | Miyagi | 77860 | 191 | 0 | 38.446859 | 140.927086 | 2022-05-11 04:20:48 | Miyagi, Japan | |||
222003 | 222003 | 2022-05-09 | Japan | Miyagi | 77220 | 191 | 0 | 38.446859 | 140.927086 | 2022-05-10 04:20:50 | Miyagi, Japan | |||
2331388 | 2331388 | 2022-05-08 | Japan | Miyagi | 76980 | 191 | 0 | 38.446859 | 140.927086 | 2022-05-09 04:20:54 | Miyagi, Japan | |||
360350 | 360350 | 2022-05-07 | Japan | Miyagi | 76410 | 191 | 0 | 38.446859 | 140.927086 | 2022-05-08 04:20:49 | Miyagi, Japan | |||
1397701 | 1397701 | 2022-05-06 | Japan | Miyagi | 75872 | 191 | 0 | 38.446859 | 140.927086 | 2022-05-07 04:21:09 | Miyagi, Japan | |||
2598056 | 2598056 | 2022-05-05 | Japan | Miyagi | 75642 | 190 | 0 | 38.446859 | 140.927086 | 2022-05-06 04:21:00 | Miyagi, Japan | |||
3265505 | 3265505 | 2022-05-04 | Japan | Miyagi | 75432 | 190 | 0 | 38.446859 | 140.927086 | 2022-05-05 04:20:55 | Miyagi, Japan | |||
1572144 | 1572144 | 2022-05-03 | Japan | Miyagi | 75106 | 188 | 0 | 38.446859 | 140.927086 | 2022-05-04 04:20:59 | Miyagi, Japan | |||
463404 | 463404 | 2022-05-02 | Japan | Miyagi | 74717 | 188 | 0 | 38.446859 | 140.927086 | 2022-05-03 04:21:00 | Miyagi, Japan | |||
3916043 | 3916043 | 2022-05-01 | Japan | Miyagi | 74489 | 188 | 0 | 38.446859 | 140.927086 | 2022-05-02 04:21:10 | Miyagi, Japan | |||
2840847 | 2840847 | 2022-04-30 | Japan | Miyagi | 74200 | 188 | 0 | 38.446859 | 140.927086 | 2022-05-01 04:20:57 | Miyagi, Japan | |||
1157160 | 1157160 | 2022-04-29 | Japan | Miyagi | 73923 | 188 | 0 | 38.446859 | 140.927086 | 2022-04-30 04:21:05 | Miyagi, Japan | |||
1696342 | 1696342 | 2022-04-28 | Japan | Miyagi | 73464 | 188 | 0 | 38.446859 | 140.927086 | 2022-04-29 04:20:59 | Miyagi, Japan | |||
3851825 | 3851825 | 2022-04-27 | Japan | Miyagi | 73020 | 188 | 0 | 38.446859 | 140.927086 | 2022-04-28 04:20:47 | Miyagi, Japan | |||
1326255 | 1326255 | 2022-04-26 | Japan | Miyagi | 72370 | 186 | 0 | 38.446859 | 140.927086 | 2022-04-27 04:20:52 | Miyagi, Japan | |||
3722209 | 3722209 | 2022-04-25 | Japan | Miyagi | 71789 | 186 | 0 | 38.446859 | 140.927086 | 2022-04-26 04:20:51 | Miyagi, Japan | |||
2028777 | 2028777 | 2022-04-24 | Japan | Miyagi | 71533 | 183 | 0 | 38.446859 | 140.927086 | 2022-04-25 04:20:56 | Miyagi, Japan | |||
746352 | 746352 | 2022-04-23 | Japan | Miyagi | 71015 | 183 | 0 | 38.446859 | 140.927086 | 2022-04-24 04:20:56 | Miyagi, Japan | |||
3436837 | 3436837 | 2022-04-22 | Japan | Miyagi | 70301 | 183 | 0 | 38.446859 | 140.927086 | 2022-04-23 04:20:50 | Miyagi, Japan | |||
2892422 | 2892422 | 2022-04-21 | Japan | Miyagi | 69687 | 183 | 0 | 38.446859 | 140.927086 | 2022-04-22 04:20:45 | Miyagi, Japan | |||
2307294 | 2307294 | 2022-04-20 | Japan | Miyagi | 69160 | 182 | 0 | 38.446859 | 140.927086 | 2022-04-21 04:20:46 | Miyagi, Japan | |||
2251433 | 2251433 | 2022-04-19 | Japan | Miyagi | 68426 | 182 | 0 | 38.446859 | 140.927086 | 2022-04-20 04:20:45 | Miyagi, Japan | |||
1845983 | 1845983 | 2022-04-18 | Japan | Miyagi | 67845 | 182 | 0 | 38.446859 | 140.927086 | 2022-04-19 04:21:00 | Miyagi, Japan | |||
3416927 | 3416927 | 2022-04-17 | Japan | Miyagi | 67629 | 180 | 0 | 38.446859 | 140.927086 | 2022-04-18 04:21:12 | Miyagi, Japan | |||
303876 | 303876 | 2022-04-16 | Japan | Miyagi | 67214 | 180 | 0 | 38.446859 | 140.927086 | 2022-04-17 04:20:59 | Miyagi, Japan | |||
2669821 | 2669821 | 2022-04-15 | Japan | Miyagi | 66648 | 180 | 0 | 38.446859 | 140.927086 | 2022-04-16 04:20:48 | Miyagi, Japan | |||
1223606 | 1223606 | 2022-04-14 | Japan | Miyagi | 66141 | 179 | 0 | 38.446859 | 140.927086 | 2022-04-15 04:20:57 | Miyagi, Japan | |||
2442764 | 2442764 | 2022-04-13 | Japan | Miyagi | 65543 | 178 | 0 | 38.446859 | 140.927086 | 2022-04-13 23:21:06 | Miyagi, Japan | |||
1948521 | 1948521 | 2022-04-12 | Japan | Miyagi | 64795 | 178 | 0 | 38.446859 | 140.927086 | 2022-04-13 04:21:03 | Miyagi, Japan | |||
3206274 | 3206274 | 2022-04-11 | Japan | Miyagi | 64186 | 178 | 0 | 38.446859 | 140.927086 | 2022-04-12 04:20:49 | Miyagi, Japan | |||
1576160 | 1576160 | 2022-04-10 | Japan | Miyagi | 63861 | 176 | 0 | 38.446859 | 140.927086 | 2022-04-11 04:21:02 | Miyagi, Japan | |||
1652402 | 1652402 | 2022-04-09 | Japan | Miyagi | 63288 | 176 | 0 | 38.446859 | 140.927086 | 2022-04-10 04:20:52 | Miyagi, Japan | |||
2115724 | 2115724 | 2022-04-08 | Japan | Miyagi | 62721 | 176 | 0 | 38.446859 | 140.927086 | 2022-04-09 04:20:42 | Miyagi, Japan | |||
3320248 | 3320248 | 2022-04-07 | Japan | Miyagi | 62116 | 176 | 0 | 38.446859 | 140.927086 | 2022-04-08 04:20:48 | Miyagi, Japan | |||
2800784 | 2800784 | 2022-04-06 | Japan | Miyagi | 61440 | 176 | 0 | 38.446859 | 140.927086 | 2022-04-07 04:20:53 | Miyagi, Japan | |||
3867553 | 3867553 | 2022-04-05 | Japan | Miyagi | 60673 | 175 | 0 | 38.446859 | 140.927086 | 2022-04-06 04:20:49 | Miyagi, Japan | |||
2748895 | 2748895 | 2022-04-04 | Japan | Miyagi | 60025 | 175 | 0 | 38.446859 | 140.927086 | 2022-04-05 04:20:48 | Miyagi, Japan | |||
3730241 | 3730241 | 2022-04-03 | Japan | Miyagi | 59746 | 174 | 0 | 38.446859 | 140.927086 | 2022-04-04 04:20:51 | Miyagi, Japan | |||
499676 | 499676 | 2022-04-02 | Japan | Miyagi | 59188 | 174 | 0 | 38.446859 | 140.927086 | 2022-04-03 04:20:48 | Miyagi, Japan | |||
3350661 | 3350661 | 2022-04-01 | Japan | Miyagi | 58536 | 174 | 0 | 38.446859 | 140.927086 | 2022-04-02 04:20:47 | Miyagi, Japan | |||
1539966 | 1539966 | 2022-03-31 | Japan | Miyagi | 57994 | 174 | 0 | 38.446859 | 140.927086 | 2022-04-01 04:20:28 | Miyagi, Japan | |||
2477979 | 2477979 | 2022-03-30 | Japan | Miyagi | 57370 | 174 | 0 | 38.446859 | 140.927086 | 2022-03-31 04:20:56 | Miyagi, Japan | |||
158020 | 158020 | 2022-03-29 | Japan | Miyagi | 56627 | 174 | 0 | 38.446859 | 140.927086 | 2022-03-30 04:20:45 | Miyagi, Japan | |||
1436591 | 1436591 | 2022-03-28 | Japan | Miyagi | 56053 | 173 | 0 | 38.446859 | 140.927086 | 2022-03-29 04:20:46 | Miyagi, Japan | |||
876272 | 876272 | 2022-03-27 | Japan | Miyagi | 55751 | 172 | 0 | 38.446859 | 140.927086 | 2022-03-28 04:20:33 | Miyagi, Japan | |||
2163555 | 2163555 | 2022-03-26 | Japan | Miyagi | 55277 | 171 | 0 | 38.446859 | 140.927086 | 2022-03-27 04:20:47 | Miyagi, Japan | |||
1720491 | 1720491 | 2022-03-25 | Japan | Miyagi | 54713 | 171 | 0 | 38.446859 | 140.927086 | 2022-03-26 04:20:23 | Miyagi, Japan | |||
1468108 | 1468108 | 2022-03-24 | Japan | Miyagi | 54276 | 170 | 0 | 38.446859 | 140.927086 | 2022-03-25 04:20:46 | Miyagi, Japan | |||
3022282 | 3022282 | 2022-03-23 | Japan | Miyagi | 53577 | 170 | 0 | 38.446859 | 140.927086 | 2022-03-24 04:20:43 | Miyagi, Japan | |||
1905204 | 1905204 | 2022-03-22 | Japan | Miyagi | 53047 | 170 | 0 | 38.446859 | 140.927086 | 2022-03-23 04:20:48 | Miyagi, Japan | |||
3238335 | 3238335 | 2022-03-21 | Japan | Miyagi | 52797 | 169 | 0 | 38.446859 | 140.927086 | 2022-03-22 04:20:54 | Miyagi, Japan | |||
24408 | 24408 | 2022-03-20 | Japan | Miyagi | 52521 | 168 | 0 | 38.446859 | 140.927086 | 2022-03-21 04:20:50 | Miyagi, Japan | |||
1656418 | 1656418 | 2022-03-19 | Japan | Miyagi | 52032 | 167 | 0 | 38.446859 | 140.927086 | 2022-03-20 04:20:45 | Miyagi, Japan | |||
335944 | 335944 | 2022-03-18 | Japan | Miyagi | 51431 | 166 | 0 | 38.446859 | 140.927086 | 2022-03-19 04:20:47 | Miyagi, Japan | |||
694397 | 694397 | 2022-03-17 | Japan | Miyagi | 50925 | 166 | 0 | 38.446859 | 140.927086 | 2022-03-18 04:20:55 | Miyagi, Japan | |||
2319340 | 2319340 | 2022-03-16 | Japan | Miyagi | 50383 | 165 | 0 | 38.446859 | 140.927086 | 2022-03-17 04:20:56 | Miyagi, Japan | |||
261540 | 261540 | 2022-03-15 | Japan | Miyagi | 49654 | 165 | 0 | 38.446859 | 140.927086 | 2022-03-16 04:20:50 | Miyagi, Japan | |||
2263899 | 2263899 | 2022-03-14 | Japan | Miyagi | 49084 | 163 | 0 | 38.446859 | 140.927086 | 2022-03-15 04:20:47 | Miyagi, Japan | |||
3627965 | 3627965 | 2022-03-13 | Japan | Miyagi | 48815 | 163 | 0 | 38.446859 | 140.927086 | 2022-03-14 04:20:46 | Miyagi, Japan | |||
950873 | 950873 | 2022-03-12 | Japan | Miyagi | 48271 | 160 | 0 | 38.446859 | 140.927086 | 2022-03-13 04:20:49 | Miyagi, Japan | |||
356334 | 356334 | 2022-03-11 | Japan | Miyagi | 47500 | 157 | 0 | 38.446859 | 140.927086 | 2022-03-12 04:20:50 | Miyagi, Japan | |||
1865486 | 1865486 | 2022-03-10 | Japan | Miyagi | 46893 | 157 | 0 | 38.446859 | 140.927086 | 2022-03-11 04:20:50 | Miyagi, Japan | |||
2140181 | 2140181 | 2022-03-09 | Japan | Miyagi | 46200 | 156 | 0 | 38.446859 | 140.927086 | 2022-03-10 04:20:48 | Miyagi, Japan | |||
919692 | 919692 | 2022-03-08 | Japan | Miyagi | 45457 | 154 | 0 | 38.446859 | 140.927086 | 2022-03-09 04:20:59 | Miyagi, Japan | |||
1547979 | 1547979 | 2022-03-07 | Japan | Miyagi | 44821 | 152 | 0 | 38.446859 | 140.927086 | 2022-03-08 04:20:54 | Miyagi, Japan | |||
2199648 | 2199648 | 2022-03-06 | Japan | Miyagi | 44414 | 151 | 0 | 38.446859 | 140.927086 | 2022-03-07 04:20:47 | Miyagi, Japan | |||
2092105 | 2092105 | 2022-03-05 | Japan | Miyagi | 43796 | 150 | 0 | 38.446859 | 140.927086 | 2022-03-06 04:20:49 | Miyagi, Japan | |||
2665805 | 2665805 | 2022-03-04 | Japan | Miyagi | 43131 | 148 | 0 | 38.446859 | 140.927086 | 2022-03-05 04:21:10 | Miyagi, Japan | |||
1644370 | 1644370 | 2022-03-03 | Japan | Miyagi | 42458 | 146 | 0 | 38.446859 | 140.927086 | 2022-03-04 04:21:09 | Miyagi, Japan | |||
2525373 | 2525373 | 2022-03-02 | Japan | Miyagi | 41807 | 146 | 0 | 38.446859 | 140.927086 | 2022-03-03 04:21:01 | Miyagi, Japan | |||
1992667 | 1992667 | 2022-03-01 | Japan | Miyagi | 41024 | 143 | 0 | 38.446859 | 140.927086 | 2022-03-02 04:21:07 | Miyagi, Japan | |||
942841 | 942841 | 2022-02-28 | Japan | Miyagi | 40385 | 141 | 0 | 38.446859 | 140.927086 | 2022-03-01 04:21:09 | Miyagi, Japan | |||
2733032 | 2733032 | 2022-02-27 | Japan | Miyagi | 39916 | 139 | 0 | 38.446859 | 140.927086 | 2022-02-28 04:21:05 | Miyagi, Japan | |||
3046185 | 3046185 | 2022-02-26 | Japan | Miyagi | 39360 | 139 | 0 | 38.446859 | 140.927086 | 2022-02-27 04:21:04 | Miyagi, Japan | |||
574840 | 574840 | 2022-02-25 | Japan | Miyagi | 38567 | 138 | 0 | 38.446859 | 140.927086 | 2022-02-26 04:21:12 | Miyagi, Japan | |||
1511416 | 1511416 | 2022-02-24 | Japan | Miyagi | 37957 | 135 | 0 | 38.446859 | 140.927086 | 2022-02-25 04:21:11 | Miyagi, Japan | |||
1057857 | 1057857 | 2022-02-23 | Japan | Miyagi | 37486 | 134 | 0 | 38.446859 | 140.927086 | 2022-02-24 04:21:14 | Miyagi, Japan | |||
2446780 | 2446780 | 2022-02-22 | Japan | Miyagi | 36639 | 130 | 0 | 38.446859 | 140.927086 | 2022-02-23 04:21:09 | Miyagi, Japan | |||
3718193 | 3718193 | 2022-02-21 | Japan | Miyagi | 35956 | 129 | 0 | 38.446859 | 140.927086 | 2022-02-22 04:21:01 | Miyagi, Japan | |||
3912027 | 3912027 | 2022-02-20 | Japan | Miyagi | 35554 | 129 | 0 | 38.446859 | 140.927086 | 2022-02-21 04:21:05 | Miyagi, Japan | |||
3875585 | 3875585 | 2022-02-19 | Japan | Miyagi | 34860 | 129 | 0 | 38.446859 | 140.927086 | 2022-02-20 04:21:00 | Miyagi, Japan | |||
3855841 | 3855841 | 2022-02-18 | Japan | Miyagi | 34031 | 128 | 0 | 38.446859 | 140.927086 | 2022-02-19 04:21:11 | Miyagi, Japan | |||
1298060 | 1298060 | 2022-02-17 | Japan | Miyagi | 33249 | 126 | 0 | 38.446859 | 140.927086 | 2022-02-18 04:21:04 | Miyagi, Japan | |||
3820446 | 3820446 | 2022-02-16 | Japan | Miyagi | 32343 | 126 | 0 | 38.446859 | 140.927086 | 2022-02-17 04:20:56 | Miyagi, Japan | |||
3671660 | 3671660 | 2022-02-15 | Japan | Miyagi | 31522 | 125 | 0 | 38.446859 | 140.927086 | 2022-02-16 04:21:10 | Miyagi, Japan | |||
2641761 | 2641761 | 2022-02-14 | Japan | Miyagi | 30719 | 125 | 0 | 38.446859 | 140.927086 | 2022-02-15 04:21:09 | Miyagi, Japan | |||
186078 | 186078 | 2022-02-13 | Japan | Miyagi | 30326 | 125 | 0 | 38.446859 | 140.927086 | 2022-02-14 04:20:51 | Miyagi, Japan | |||
315924 | 315924 | 2022-02-12 | Japan | Miyagi | 29654 | 125 | 0 | 38.446859 | 140.927086 | 2022-02-13 04:21:00 | Miyagi, Japan | |||
233250 | 233250 | 2022-02-11 | Japan | Miyagi | 29066 | 124 | 0 | 38.446859 | 140.927086 | 2022-02-12 04:21:06 | Miyagi, Japan | |||
1464092 | 1464092 | 2022-02-10 | Japan | Miyagi | 28307 | 124 | 0 | 38.446859 | 140.927086 | 2022-02-11 04:21:09 | Miyagi, Japan | |||
3074053 | 3074053 | 2022-02-09 | Japan | Miyagi | 27594 | 124 | 0 | 38.446859 | 140.927086 | 2022-02-10 04:21:14 | Miyagi, Japan | |||
1362360 | 1362360 | 2022-02-08 | Japan | Miyagi | 26660 | 121 | 0 | 38.446859 | 140.927086 | 2022-02-09 04:21:04 | Miyagi, Japan | |||
71098 | 71098 | 2022-02-07 | Japan | Miyagi | 25984 | 121 | 0 | 38.446859 | 140.927086 | 2022-02-08 04:21:15 | Miyagi, Japan | |||
2012714 | 2012714 | 2022-02-06 | Japan | Miyagi | 25561 | 121 | 0 | 38.446859 | 140.927086 | 2022-02-07 04:21:05 | Miyagi, Japan | |||
1294043 | 1294043 | 2022-02-05 | Japan | Miyagi | 24944 | 118 | 0 | 38.446859 | 140.927086 | 2022-02-06 04:21:00 | Miyagi, Japan | |||
2327371 | 2327371 | 2022-02-04 | Japan | Miyagi | 24200 | 118 | 0 | 38.446859 | 140.927086 | 2022-02-05 04:21:05 | Miyagi, Japan | |||
2473962 | 2473962 | 2022-02-03 | Japan | Miyagi | 23503 | 118 | 0 | 38.446859 | 140.927086 | 2022-02-04 04:21:10 | Miyagi, Japan | |||
459387 | 459387 | 2022-02-02 | Japan | Miyagi | 22820 | 118 | 0 | 38.446859 | 140.927086 | 2022-02-03 04:21:21 | Miyagi, 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]);