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 province_or_state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state ▼ | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
337 | 337 | 2021-12-02 | Japan | Miyagi | 16280 | 118 | 0 | 38.446859 | 140.927086 | 2021-12-03 04:23:05 | Miyagi, Japan | |||
4353 | 4353 | 2021-10-28 | Japan | Miyagi | 16259 | 118 | 0 | 38.446859 | 140.927086 | 2021-10-29 04:22:03 | Miyagi, Japan | |||
8355 | 8355 | 2020-10-25 | Japan | Miyagi | 602 | 2 | 504 | 96 | 38.446859 | 140.927086 | 2020-10-26 04:25:02 | Miyagi, Japan | ||
12363 | 12363 | 2021-01-26 | Japan | Miyagi | 3302 | 22 | 2788 | 492 | 38.446859 | 140.927086 | 2021-01-27 05:23:41 | Miyagi, Japan | ||
16378 | 16378 | 2021-09-18 | Japan | Miyagi | 15968 | 113 | 0 | 38.446859 | 140.927086 | 2021-09-19 04:21:34 | Miyagi, Japan | |||
20393 | 20393 | 2021-05-28 | Japan | Miyagi | 8823 | 83 | 8456 | 284 | 38.446859 | 140.927086 | 2021-05-29 04:20:41 | Miyagi, Japan | ||
24408 | 24408 | 2022-03-20 | Japan | Miyagi | 52521 | 168 | 0 | 38.446859 | 140.927086 | 2022-03-21 04:20:50 | Miyagi, Japan | |||
28423 | 28423 | 2021-11-11 | Japan | Miyagi | 16274 | 118 | 0 | 38.446859 | 140.927086 | 2021-11-12 04:22:01 | Miyagi, Japan | |||
32439 | 32439 | 2021-08-25 | Japan | Miyagi | 13762 | 97 | 0 | 38.446859 | 140.927086 | 2021-08-26 04:21:28 | Miyagi, Japan | |||
36453 | 36453 | 2021-04-12 | Japan | Miyagi | 7200 | 43 | 5942 | 1215 | 38.446859 | 140.927086 | 2021-04-13 04:20:37 | Miyagi, Japan | ||
43715 | 43715 | 2021-11-02 | Japan | Miyagi | 16268 | 118 | 0 | 38.446859 | 140.927086 | 2021-11-03 06:22:09 | Miyagi, Japan | |||
50814 | 50814 | 2021-05-29 | Japan | Miyagi | 8840 | 83 | 8494 | 263 | 38.446859 | 140.927086 | 2021-05-30 04:20:55 | Miyagi, Japan | ||
54828 | 54828 | 2021-03-07 | Japan | Miyagi | 3790 | 25 | 3554 | 211 | 38.446859 | 140.927086 | 2021-03-08 05:24:48 | Miyagi, Japan | ||
62007 | 62007 | 2020-07-23 | Japan | Miyagi | 140 | 1 | 113 | 26 | 38.446859 | 140.927086 | 2020-07-24 05:30:40 | Miyagi, Japan | ||
63069 | 63069 | 2022-11-12 | Japan | Miyagi | 306897 | 446 | 0 | 38.446859 | 140.927086 | 2022-11-13 04:21:14 | Miyagi, Japan | |||
67084 | 67084 | 2021-09-01 | Japan | Miyagi | 14882 | 103 | 0 | 38.446859 | 140.927086 | 2021-09-02 04:21:15 | Miyagi, Japan | |||
71098 | 71098 | 2022-02-07 | Japan | Miyagi | 25984 | 121 | 0 | 38.446859 | 140.927086 | 2022-02-08 04:21:15 | Miyagi, Japan | |||
75112 | 75112 | 2020-12-03 | Japan | Miyagi | 1251 | 10 | 1075 | 166 | 38.446859 | 140.927086 | 2020-12-04 05:27:27 | Miyagi, Japan | ||
79111 | 79111 | 2020-10-14 | Japan | Miyagi | 504 | 2 | 442 | 60 | 38.446859 | 140.927086 | 2020-10-15 04:24:28 | Miyagi, Japan | ||
83118 | 83118 | 2021-05-25 | Japan | Miyagi | 8755 | 82 | 8359 | 314 | 38.446859 | 140.927086 | 2021-05-26 04:20:35 | Miyagi, Japan | ||
87132 | 87132 | 2021-11-09 | Japan | Miyagi | 16273 | 118 | 0 | 38.446859 | 140.927086 | 2021-11-10 04:21:38 | Miyagi, Japan | |||
91149 | 91149 | 2022-07-23 | Japan | Miyagi | 112733 | 205 | 0 | 38.446859 | 140.927086 | 2022-07-24 04:20:47 | Miyagi, Japan | |||
98354 | 98354 | 2020-08-04 | Japan | Miyagi | 176 | 1 | 144 | 31 | 38.446859 | 140.927086 | 2020-08-05 04:34:43 | Miyagi, Japan | ||
99333 | 99333 | 2022-01-14 | Japan | Miyagi | 16618 | 118 | 0 | 38.446859 | 140.927086 | 2022-01-15 04:21:07 | Miyagi, Japan | |||
103349 | 103349 | 2021-08-15 | Japan | Miyagi | 11599 | 93 | 0 | 38.446859 | 140.927086 | 2021-08-16 04:21:31 | Miyagi, Japan | |||
107474 | 107474 | 2021-06-19 | Japan | Miyagi | 9064 | 86 | 8885 | 93 | 38.446859 | 140.927086 | 2021-06-20 04:21:48 | Miyagi, Japan | ||
114759 | 114759 | 2022-09-06 | Japan | Miyagi | 236144 | 327 | 0 | 38.446859 | 140.927086 | 2022-09-07 04:20:59 | Miyagi, Japan | |||
121946 | 121946 | 2020-07-19 | Japan | Miyagi | 132 | 1 | 100 | 31 | 38.446859 | 140.927086 | 2020-07-20 05:34:40 | Miyagi, Japan | ||
122727 | 122727 | 2020-11-18 | Japan | Miyagi | 1046 | 9 | 815 | 222 | 38.446859 | 140.927086 | 2020-11-19 05:25:23 | Miyagi, Japan | ||
126740 | 126740 | 2022-01-09 | Japan | Miyagi | 16380 | 118 | 0 | 38.446859 | 140.927086 | 2022-01-10 04:22:07 | Miyagi, Japan | |||
130757 | 130757 | 2022-10-04 | Japan | Miyagi | 262088 | 397 | 0 | 38.446859 | 140.927086 | 2022-10-05 04:23:06 | Miyagi, Japan | |||
137978 | 137978 | 2021-12-04 | Japan | Miyagi | 16282 | 118 | 0 | 38.446859 | 140.927086 | 2021-12-05 04:22:25 | Miyagi, Japan | |||
141995 | 141995 | 2022-07-09 | Japan | Miyagi | 96989 | 202 | 0 | 38.446859 | 140.927086 | 2022-07-10 04:20:54 | Miyagi, Japan | |||
145995 | 145995 | 2020-08-15 | Japan | Miyagi | 184 | 1 | 168 | 15 | 38.446859 | 140.927086 | 2020-08-16 04:27:42 | Miyagi, Japan | ||
149991 | 149991 | 2021-11-29 | Japan | Miyagi | 16280 | 118 | 0 | 38.446859 | 140.927086 | 2021-11-30 04:22:53 | Miyagi, Japan | |||
154006 | 154006 | 2021-01-08 | Japan | Miyagi | 2488 | 17 | 2022 | 449 | 38.446859 | 140.927086 | 2021-01-09 05:22:18 | Miyagi, Japan | ||
158020 | 158020 | 2022-03-29 | Japan | Miyagi | 56627 | 174 | 0 | 38.446859 | 140.927086 | 2022-03-30 04:20:45 | Miyagi, Japan | |||
162035 | 162035 | 2021-11-19 | Japan | Miyagi | 16275 | 118 | 0 | 38.446859 | 140.927086 | 2021-11-20 04:22:17 | Miyagi, Japan | |||
166052 | 166052 | 2022-06-21 | Japan | Miyagi | 92133 | 198 | 0 | 38.446859 | 140.927086 | 2022-06-22 04:20:54 | Miyagi, Japan | |||
170067 | 170067 | 2021-04-16 | Japan | Miyagi | 7489 | 46 | 6314 | 1129 | 38.446859 | 140.927086 | 2021-04-17 04:20:40 | Miyagi, Japan | ||
177264 | 177264 | 2020-07-27 | Japan | Miyagi | 147 | 1 | 127 | 19 | 38.446859 | 140.927086 | 2020-07-28 04:58:43 | Miyagi, Japan | ||
178049 | 178049 | 2021-09-02 | Japan | Miyagi | 15029 | 104 | 0 | 38.446859 | 140.927086 | 2021-09-03 04:21:20 | Miyagi, Japan | |||
182063 | 182063 | 2021-02-21 | Japan | Miyagi | 3563 | 24 | 3431 | 108 | 38.446859 | 140.927086 | 2021-02-22 05:24:21 | Miyagi, Japan | ||
186078 | 186078 | 2022-02-13 | Japan | Miyagi | 30326 | 125 | 0 | 38.446859 | 140.927086 | 2022-02-14 04:20:51 | Miyagi, Japan | |||
190092 | 190092 | 2021-01-11 | Japan | Miyagi | 2654 | 17 | 2126 | 511 | 38.446859 | 140.927086 | 2021-01-12 05:22:15 | Miyagi, Japan | ||
194090 | 194090 | 2020-08-31 | Japan | Miyagi | 207 | 2 | 189 | 16 | 38.446859 | 140.927086 | 2020-09-01 04:28:31 | Miyagi, Japan | ||
198266 | 198266 | 2022-10-19 | Japan | Miyagi | 272087 | 405 | 0 | 38.446859 | 140.927086 | 2022-10-20 04:22:59 | Miyagi, Japan | |||
202279 | 202279 | 2020-12-25 | Japan | Miyagi | 1969 | 13 | 1490 | 466 | 38.446859 | 140.927086 | 2020-12-26 05:22:28 | Miyagi, Japan | ||
206277 | 206277 | 2020-08-19 | Japan | Miyagi | 187 | 2 | 176 | 9 | 38.446859 | 140.927086 | 2020-08-20 04:27:43 | Miyagi, Japan | ||
210263 | 210263 | 2020-10-29 | Japan | Miyagi | 689 | 2 | 528 | 159 | 38.446859 | 140.927086 | 2020-10-30 04:24:49 | Miyagi, Japan | ||
217225 | 217225 | 2020-06-08 | Japan | Miyagi | 88 | 1 | 87 | 0 | 38.446859 | 140.927086 | 2020-06-09 03:33:03 | Miyagi, Japan | ||
217987 | 217987 | 2022-12-26 | Japan | Miyagi | 449379 | 683 | 0 | 38.446859 | 140.927086 | 2022-12-27 04:21:07 | Miyagi, Japan | |||
222003 | 222003 | 2022-05-09 | Japan | Miyagi | 77220 | 191 | 0 | 38.446859 | 140.927086 | 2022-05-10 04:20:50 | Miyagi, Japan | |||
229234 | 229234 | 2022-05-31 | Japan | Miyagi | 86873 | 197 | 0 | 38.446859 | 140.927086 | 2022-06-01 04:20:55 | Miyagi, Japan | |||
233250 | 233250 | 2022-02-11 | Japan | Miyagi | 29066 | 124 | 0 | 38.446859 | 140.927086 | 2022-02-12 04:21:06 | Miyagi, Japan | |||
237264 | 237264 | 2021-01-18 | Japan | Miyagi | 2984 | 21 | 2345 | 618 | 38.446859 | 140.927086 | 2021-01-19 05:22:15 | Miyagi, Japan | ||
241278 | 241278 | 2021-04-02 | Japan | Miyagi | 6284 | 32 | 4582 | 1670 | 38.446859 | 140.927086 | 2021-04-03 04:20:44 | Miyagi, Japan | ||
245292 | 245292 | 2021-08-17 | Japan | Miyagi | 11882 | 93 | 0 | 38.446859 | 140.927086 | 2021-08-18 04:21:35 | Miyagi, Japan | |||
249306 | 249306 | 2021-09-04 | Japan | Miyagi | 15230 | 104 | 0 | 38.446859 | 140.927086 | 2021-09-05 04:21:33 | Miyagi, Japan | |||
253321 | 253321 | 2022-09-08 | Japan | Miyagi | 239652 | 340 | 0 | 38.446859 | 140.927086 | 2022-09-09 04:21:11 | Miyagi, Japan | |||
257337 | 257337 | 2022-12-10 | Japan | Miyagi | 395875 | 573 | 0 | 38.446859 | 140.927086 | 2022-12-11 04:20:50 | Miyagi, Japan | |||
261540 | 261540 | 2022-03-15 | Japan | Miyagi | 49654 | 165 | 0 | 38.446859 | 140.927086 | 2022-03-16 04:20:50 | Miyagi, Japan | |||
272178 | 272178 | 2020-11-10 | Japan | Miyagi | 892 | 6 | 652 | 234 | 38.446859 | 140.927086 | 2020-11-11 05:25:30 | Miyagi, Japan | ||
276190 | 276190 | 2021-11-03 | Japan | Miyagi | 16269 | 118 | 0 | 38.446859 | 140.927086 | 2021-11-04 04:22:20 | Miyagi, Japan | |||
280206 | 280206 | 2021-02-24 | Japan | Miyagi | 3580 | 25 | 3448 | 107 | 38.446859 | 140.927086 | 2021-02-25 05:24:57 | Miyagi, Japan | ||
287229 | 287229 | 2020-06-15 | Japan | Miyagi | 88 | 1 | 87 | 0 | 38.446859 | 140.927086 | 2020-06-16 04:33:09 | Miyagi, Japan | ||
288003 | 288003 | 2021-10-31 | Japan | Miyagi | 16266 | 118 | 0 | 38.446859 | 140.927086 | 2021-11-01 04:22:01 | Miyagi, Japan | |||
292020 | 292020 | 2022-11-15 | Japan | Miyagi | 313509 | 451 | 0 | 38.446859 | 140.927086 | 2022-11-16 04:21:09 | Miyagi, Japan | |||
296035 | 296035 | 2021-07-15 | Japan | Miyagi | 9448 | 91 | 9099 | 258 | 38.446859 | 140.927086 | 2021-07-16 04:21:22 | Miyagi, Japan | ||
303101 | 303101 | 2020-07-01 | Japan | Miyagi | 95 | 1 | 88 | 6 | 38.446859 | 140.927086 | 2020-07-02 04:33:46 | Miyagi, Japan | ||
303876 | 303876 | 2022-04-16 | Japan | Miyagi | 67214 | 180 | 0 | 38.446859 | 140.927086 | 2022-04-17 04:20:59 | Miyagi, Japan | |||
307892 | 307892 | 2022-12-13 | Japan | Miyagi | 405409 | 589 | 0 | 38.446859 | 140.927086 | 2022-12-14 04:21:04 | Miyagi, Japan | |||
311908 | 311908 | 2022-11-13 | Japan | Miyagi | 309090 | 447 | 0 | 38.446859 | 140.927086 | 2022-11-14 04:21:09 | Miyagi, Japan | |||
315924 | 315924 | 2022-02-12 | Japan | Miyagi | 29654 | 125 | 0 | 38.446859 | 140.927086 | 2022-02-13 04:21:00 | Miyagi, Japan | |||
319940 | 319940 | 2022-10-30 | Japan | Miyagi | 281816 | 417 | 0 | 38.446859 | 140.927086 | 2022-10-31 04:21:36 | Miyagi, Japan | |||
327041 | 327041 | 2020-07-20 | Japan | Miyagi | 136 | 1 | 100 | 35 | 38.446859 | 140.927086 | 2020-07-21 04:38:46 | Miyagi, Japan | ||
327914 | 327914 | 2022-12-27 | Japan | Miyagi | 452976 | 685 | 0 | 38.446859 | 140.927086 | 2022-12-28 04:21:04 | Miyagi, Japan | |||
331929 | 331929 | 2021-08-04 | Japan | Miyagi | 10128 | 91 | 9557 | 480 | 38.446859 | 140.927086 | 2021-08-05 04:21:51 | Miyagi, Japan | ||
335944 | 335944 | 2022-03-18 | Japan | Miyagi | 51431 | 166 | 0 | 38.446859 | 140.927086 | 2022-03-19 04:20:47 | Miyagi, Japan | |||
340298 | 340298 | 2021-02-03 | Japan | Miyagi | 3436 | 22 | 3157 | 257 | 38.446859 | 140.927086 | 2021-02-04 05:22:26 | Miyagi, Japan | ||
344298 | 344298 | 2020-09-14 | Japan | Miyagi | 313 | 2 | 236 | 75 | 38.446859 | 140.927086 | 2020-09-15 03:22:50 | Miyagi, Japan | ||
348304 | 348304 | 2022-12-14 | Japan | Miyagi | 410113 | 595 | 0 | 38.446859 | 140.927086 | 2022-12-15 04:20:58 | Miyagi, Japan | |||
352319 | 352319 | 2021-03-11 | Japan | Miyagi | 3943 | 25 | 3611 | 307 | 38.446859 | 140.927086 | 2021-03-12 05:26:50 | Miyagi, Japan | ||
356334 | 356334 | 2022-03-11 | Japan | Miyagi | 47500 | 157 | 0 | 38.446859 | 140.927086 | 2022-03-12 04:20:50 | Miyagi, Japan | |||
360350 | 360350 | 2022-05-07 | Japan | Miyagi | 76410 | 191 | 0 | 38.446859 | 140.927086 | 2022-05-08 04:20:49 | Miyagi, Japan | |||
367449 | 367449 | 2020-07-16 | Japan | Miyagi | 126 | 1 | 100 | 25 | 38.446859 | 140.927086 | 2020-07-17 04:34:50 | Miyagi, Japan | ||
371419 | 371419 | 2020-08-08 | Japan | Miyagi | 182 | 1 | 153 | 28 | 38.446859 | 140.927086 | 2020-08-09 04:34:54 | Miyagi, Japan | ||
372204 | 372204 | 2022-09-13 | Japan | Miyagi | 245295 | 360 | 0 | 38.446859 | 140.927086 | 2022-09-14 04:20:44 | Miyagi, Japan | |||
376205 | 376205 | 2020-11-06 | Japan | Miyagi | 834 | 3 | 573 | 258 | 38.446859 | 140.927086 | 2020-11-07 05:24:52 | Miyagi, Japan | ||
380216 | 380216 | 2021-04-30 | Japan | Miyagi | 8042 | 66 | 7413 | 563 | 38.446859 | 140.927086 | 2021-05-01 04:20:47 | Miyagi, Japan | ||
384231 | 384231 | 2022-09-23 | Japan | Miyagi | 254510 | 386 | 0 | 38.446859 | 140.927086 | 2022-09-24 04:21:40 | Miyagi, Japan | |||
388246 | 388246 | 2021-04-04 | Japan | Miyagi | 6498 | 33 | 4831 | 1634 | 38.446859 | 140.927086 | 2021-04-05 04:20:35 | Miyagi, Japan | ||
392258 | 392258 | 2020-11-27 | Japan | Miyagi | 1181 | 10 | 945 | 226 | 38.446859 | 140.927086 | 2020-11-28 05:25:50 | Miyagi, Japan | ||
396272 | 396272 | 2022-10-07 | Japan | Miyagi | 264143 | 400 | 0 | 38.446859 | 140.927086 | 2022-10-08 04:22:56 | Miyagi, Japan | |||
400287 | 400287 | 2021-06-29 | Japan | Miyagi | 9120 | 90 | 8959 | 71 | 38.446859 | 140.927086 | 2021-06-30 04:21:41 | Miyagi, Japan | ||
404301 | 404301 | 2021-12-07 | Japan | Miyagi | 16285 | 118 | 0 | 38.446859 | 140.927086 | 2021-12-08 04:22:46 | Miyagi, Japan | |||
408317 | 408317 | 2021-07-28 | Japan | Miyagi | 9755 | 91 | 9416 | 248 | 38.446859 | 140.927086 | 2021-07-29 04:21:33 | Miyagi, Japan | ||
415393 | 415393 | 2020-07-05 | Japan | Miyagi | 98 | 1 | 90 | 7 | 38.446859 | 140.927086 | 2020-07-06 04:33:57 | Miyagi, Japan | ||
419343 | 419343 | 2022-09-18 | Japan | Miyagi | 250352 | 376 | 0 | 38.446859 | 140.927086 | 2022-09-19 04:21:49 | Miyagi, Japan | |||
423358 | 423358 | 2021-10-10 | Japan | Miyagi | 16242 | 117 | 0 | 38.446859 | 140.927086 | 2021-10-11 04:21:31 | 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]);