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 active descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1310170 | 1310170 | 2021-05-26 | Japan | Akita | 753 | 12 | 642 | 99 | 39.748679 | 140.408228 | 2021-05-27 04:20:59 | Akita, Japan | ||
2824786 | 2824786 | 2021-05-01 | Japan | Akita | 480 | 9 | 374 | 97 | 39.748679 | 140.408228 | 2021-05-02 04:20:48 | Akita, Japan | ||
1806746 | 1806746 | 2021-05-27 | Japan | Akita | 755 | 12 | 650 | 93 | 39.748679 | 140.408228 | 2021-05-28 04:20:36 | Akita, Japan | ||
400265 | 400265 | 2021-06-29 | Japan | Akita | 862 | 20 | 750 | 92 | 39.748679 | 140.408228 | 2021-06-30 04:21:41 | Akita, Japan | ||
864771 | 864771 | 2020-11-12 | Japan | Akita | 70 | 0 | 61 | 9 | 39.748679 | 140.408228 | 2020-11-13 05:25:30 | Akita, Japan | ||
1203808 | 1203808 | 2021-03-22 | Japan | Akita | 277 | 6 | 262 | 9 | 39.748679 | 140.408228 | 2021-03-23 05:26:18 | Akita, Japan | ||
1290007 | 1290007 | 2021-03-29 | Japan | Akita | 283 | 6 | 268 | 9 | 39.748679 | 140.408228 | 2021-03-30 04:26:23 | Akita, Japan | ||
1744540 | 1744540 | 2021-03-20 | Japan | Akita | 277 | 6 | 262 | 9 | 39.748679 | 140.408228 | 2021-03-21 05:25:44 | Akita, Japan | ||
2780995 | 2780995 | 2021-03-24 | Japan | Akita | 278 | 6 | 263 | 9 | 39.748679 | 140.408228 | 2021-03-25 05:27:00 | Akita, Japan | ||
2785006 | 2785006 | 2020-11-13 | Japan | Akita | 70 | 0 | 61 | 9 | 39.748679 | 140.408228 | 2020-11-14 05:25:37 | Akita, Japan | ||
2915184 | 2915184 | 2020-11-14 | Japan | Akita | 71 | 0 | 62 | 9 | 39.748679 | 140.408228 | 2020-11-15 05:26:53 | Akita, Japan | ||
3369330 | 3369330 | 2021-03-21 | Japan | Akita | 277 | 6 | 262 | 9 | 39.748679 | 140.408228 | 2021-03-22 05:25:43 | Akita, Japan | ||
3643554 | 3643554 | 2021-03-30 | Japan | Akita | 283 | 6 | 268 | 9 | 39.748679 | 140.408228 | 2021-03-31 04:26:25 | Akita, Japan | ||
1636317 | 1636317 | 2021-04-29 | Japan | Akita | 452 | 9 | 359 | 84 | 39.748679 | 140.408228 | 2021-04-30 04:21:03 | Akita, Japan | ||
3125508 | 3125508 | 2021-06-28 | Japan | Akita | 848 | 20 | 745 | 83 | 39.748679 | 140.408228 | 2021-06-29 04:21:28 | Akita, Japan | ||
20371 | 20371 | 2021-05-28 | Japan | Akita | 755 | 12 | 663 | 80 | 39.748679 | 140.408228 | 2021-05-29 04:20:41 | Akita, Japan | ||
107452 | 107452 | 2021-06-19 | Japan | Akita | 765 | 20 | 737 | 8 | 39.748679 | 140.408228 | 2021-06-20 04:21:48 | Akita, Japan | ||
122705 | 122705 | 2020-11-18 | Japan | Akita | 74 | 0 | 66 | 8 | 39.748679 | 140.408228 | 2020-11-19 05:25:23 | Akita, Japan | ||
182041 | 182041 | 2021-02-21 | Japan | Akita | 269 | 6 | 255 | 8 | 39.748679 | 140.408228 | 2021-02-22 05:24:21 | Akita, Japan | ||
272156 | 272156 | 2020-11-10 | Japan | Akita | 68 | 0 | 60 | 8 | 39.748679 | 140.408228 | 2020-11-11 05:25:30 | Akita, Japan | ||
530707 | 530707 | 2021-02-22 | Japan | Akita | 269 | 6 | 255 | 8 | 39.748679 | 140.408228 | 2021-02-23 05:23:41 | Akita, Japan | ||
742315 | 742315 | 2021-02-20 | Japan | Akita | 269 | 6 | 255 | 8 | 39.748679 | 140.408228 | 2021-02-21 05:24:33 | Akita, Japan | ||
1302053 | 1302053 | 2021-04-01 | Japan | Akita | 285 | 6 | 271 | 8 | 39.748679 | 140.408228 | 2021-04-02 04:20:36 | Akita, Japan | ||
1996645 | 1996645 | 2020-08-26 | Japan | Akita | 48 | 0 | 40 | 8 | 39.748679 | 140.408228 | 2020-08-27 04:28:15 | Akita, Japan | ||
2880206 | 2880206 | 2020-11-15 | Japan | Akita | 73 | 0 | 65 | 8 | 39.748679 | 140.408228 | 2020-11-16 05:25:57 | Akita, Japan | ||
3169638 | 3169638 | 2020-11-16 | Japan | Akita | 73 | 0 | 65 | 8 | 39.748679 | 140.408228 | 2020-11-17 05:25:54 | Akita, Japan | ||
3338593 | 3338593 | 2020-11-17 | Japan | Akita | 74 | 0 | 66 | 8 | 39.748679 | 140.408228 | 2020-11-18 05:40:31 | Akita, Japan | ||
3440816 | 3440816 | 2020-11-11 | Japan | Akita | 68 | 0 | 60 | 8 | 39.748679 | 140.408228 | 2020-11-12 05:25:55 | Akita, Japan | ||
2693689 | 2693689 | 2021-07-06 | Japan | Akita | 915 | 20 | 816 | 79 | 39.748679 | 140.408228 | 2021-07-07 04:21:20 | Akita, Japan | ||
380194 | 380194 | 2021-04-30 | Japan | Akita | 455 | 9 | 368 | 78 | 39.748679 | 140.408228 | 2021-05-01 04:20:47 | Akita, Japan | ||
3393396 | 3393396 | 2021-04-28 | Japan | Akita | 430 | 9 | 344 | 77 | 39.748679 | 140.408228 | 2021-04-29 04:20:55 | Akita, Japan | ||
3924013 | 3924013 | 2021-04-24 | Japan | Akita | 413 | 9 | 331 | 73 | 39.748679 | 140.408228 | 2021-04-25 04:20:32 | Akita, Japan | ||
888121 | 888121 | 2021-04-26 | Japan | Akita | 417 | 9 | 336 | 72 | 39.748679 | 140.408228 | 2021-04-27 04:20:52 | Akita, Japan | ||
954866 | 954866 | 2021-04-25 | Japan | Akita | 414 | 9 | 333 | 72 | 39.748679 | 140.408228 | 2021-04-26 04:21:04 | Akita, Japan | ||
2590003 | 2590003 | 2021-06-27 | Japan | Akita | 835 | 20 | 743 | 72 | 39.748679 | 140.408228 | 2021-06-28 04:21:29 | Akita, Japan | ||
3702112 | 3702112 | 2021-04-27 | Japan | Akita | 425 | 9 | 344 | 72 | 39.748679 | 140.408228 | 2021-04-28 04:20:32 | Akita, Japan | ||
2567665 | 2567665 | 2021-01-25 | Japan | Akita | 250 | 1 | 178 | 71 | 39.748679 | 140.408228 | 2021-01-26 05:22:02 | Akita, Japan | ||
376183 | 376183 | 2020-11-06 | Japan | Akita | 67 | 0 | 60 | 7 | 39.748679 | 140.408228 | 2020-11-07 05:24:52 | Akita, Japan | ||
609689 | 609689 | 2020-08-29 | Japan | Akita | 49 | 0 | 42 | 7 | 39.748679 | 140.408228 | 2020-08-30 04:28:22 | Akita, Japan | ||
821571 | 821571 | 2020-11-19 | Japan | Akita | 74 | 0 | 67 | 7 | 39.748679 | 140.408228 | 2020-11-20 05:26:28 | Akita, Japan | ||
892121 | 892121 | 2020-11-05 | Japan | Akita | 67 | 0 | 60 | 7 | 39.748679 | 140.408228 | 2020-11-06 05:24:55 | Akita, Japan | ||
1523184 | 1523184 | 2020-08-28 | Japan | Akita | 48 | 0 | 41 | 7 | 39.748679 | 140.408228 | 2020-08-29 04:28:19 | Akita, Japan | ||
1543945 | 1543945 | 2020-11-07 | Japan | Akita | 67 | 0 | 60 | 7 | 39.748679 | 140.408228 | 2020-11-08 05:24:56 | Akita, Japan | ||
1632304 | 1632304 | 2020-12-05 | Japan | Akita | 90 | 1 | 82 | 7 | 39.748679 | 140.408228 | 2020-12-06 05:26:18 | Akita, Japan | ||
1728485 | 1728485 | 2020-11-08 | Japan | Akita | 67 | 0 | 60 | 7 | 39.748679 | 140.408228 | 2020-11-09 05:25:45 | Akita, Japan | ||
1936452 | 1936452 | 2021-02-23 | Japan | Akita | 269 | 6 | 256 | 7 | 39.748679 | 140.408228 | 2021-02-24 05:29:16 | Akita, Japan | ||
1988633 | 1988633 | 2020-11-09 | Japan | Akita | 67 | 0 | 60 | 7 | 39.748679 | 140.408228 | 2020-11-10 05:40:07 | Akita, Japan | ||
2510185 | 2510185 | 2020-08-27 | Japan | Akita | 48 | 0 | 41 | 7 | 39.748679 | 140.408228 | 2020-08-28 04:28:11 | Akita, Japan | ||
2701511 | 2701511 | 2020-11-20 | Japan | Akita | 74 | 0 | 67 | 7 | 39.748679 | 140.408228 | 2020-11-21 05:25:51 | Akita, Japan | ||
3562569 | 3562569 | 2020-08-25 | Japan | Akita | 46 | 0 | 39 | 7 | 39.748679 | 140.408228 | 2020-08-26 04:28:11 | Akita, Japan | ||
2020724 | 2020724 | 2021-04-20 | Japan | Akita | 390 | 9 | 312 | 69 | 39.748679 | 140.408228 | 2021-04-21 04:21:14 | Akita, Japan | ||
2426904 | 2426904 | 2021-01-23 | Japan | Akita | 242 | 1 | 172 | 69 | 39.748679 | 140.408228 | 2021-01-24 05:22:35 | Akita, Japan | ||
1759297 | 1759297 | 2021-01-24 | Japan | Akita | 247 | 1 | 178 | 68 | 39.748679 | 140.408228 | 2021-01-25 05:22:16 | Akita, Japan | ||
778362 | 778362 | 2021-07-08 | Japan | Akita | 929 | 20 | 842 | 67 | 39.748679 | 140.408228 | 2021-07-09 04:21:21 | Akita, Japan | ||
1409044 | 1409044 | 2021-04-23 | Japan | Akita | 402 | 9 | 326 | 67 | 39.748679 | 140.408228 | 2021-04-24 04:20:38 | Akita, Japan | ||
1568107 | 1568107 | 2021-04-22 | Japan | Akita | 399 | 9 | 323 | 67 | 39.748679 | 140.408228 | 2021-04-23 04:20:52 | Akita, Japan | ||
12341 | 12341 | 2021-01-26 | Japan | Akita | 251 | 1 | 185 | 65 | 39.748679 | 140.408228 | 2021-01-27 05:23:41 | Akita, Japan | ||
50792 | 50792 | 2021-05-29 | Japan | Akita | 755 | 12 | 678 | 65 | 39.748679 | 140.408228 | 2021-05-30 04:20:55 | Akita, Japan | ||
3242328 | 3242328 | 2021-04-21 | Japan | Akita | 395 | 9 | 321 | 65 | 39.748679 | 140.408228 | 2021-04-22 04:20:53 | Akita, Japan | ||
2466806 | 2466806 | 2021-01-22 | Japan | Akita | 235 | 1 | 170 | 64 | 39.748679 | 140.408228 | 2021-01-23 05:22:03 | Akita, Japan | ||
3958507 | 3958507 | 2021-06-26 | Japan | Akita | 825 | 20 | 741 | 64 | 39.748679 | 140.408228 | 2021-06-27 04:21:39 | Akita, Japan | ||
2410845 | 2410845 | 2021-04-19 | Japan | Akita | 377 | 9 | 305 | 63 | 39.748679 | 140.408228 | 2021-04-20 04:20:41 | Akita, Japan | ||
1440584 | 1440584 | 2021-07-07 | Japan | Akita | 918 | 20 | 836 | 62 | 39.748679 | 140.408228 | 2021-07-08 04:21:26 | Akita, Japan | ||
1094089 | 1094089 | 2021-01-20 | Japan | Akita | 227 | 1 | 166 | 60 | 39.748679 | 140.408228 | 2021-01-21 05:22:01 | Akita, Japan | ||
194068 | 194068 | 2020-08-31 | Japan | Akita | 49 | 0 | 43 | 6 | 39.748679 | 140.408228 | 2020-09-01 04:28:31 | Akita, Japan | ||
280184 | 280184 | 2021-02-24 | Japan | Akita | 269 | 6 | 257 | 6 | 39.748679 | 140.408228 | 2021-02-25 05:24:57 | Akita, Japan | ||
637925 | 637925 | 2021-03-31 | Japan | Akita | 283 | 6 | 271 | 6 | 39.748679 | 140.408228 | 2021-04-01 04:27:05 | Akita, Japan | ||
678313 | 678313 | 2020-11-23 | Japan | Akita | 74 | 0 | 68 | 6 | 39.748679 | 140.408228 | 2020-11-24 05:27:31 | Akita, Japan | ||
1350319 | 1350319 | 2020-11-24 | Japan | Akita | 75 | 1 | 68 | 6 | 39.748679 | 140.408228 | 2020-11-25 05:27:20 | Akita, Japan | ||
2059883 | 2059883 | 2020-09-01 | Japan | Akita | 49 | 0 | 43 | 6 | 39.748679 | 140.408228 | 2020-09-02 04:28:25 | Akita, Japan | ||
2291444 | 2291444 | 2020-10-12 | Japan | Akita | 59 | 0 | 53 | 6 | 39.748679 | 140.408228 | 2020-10-13 04:24:02 | Akita, Japan | ||
3189989 | 3189989 | 2020-11-22 | Japan | Akita | 74 | 0 | 68 | 6 | 39.748679 | 140.408228 | 2020-11-23 05:25:26 | Akita, Japan | ||
3420920 | 3420920 | 2021-03-19 | Japan | Akita | 274 | 6 | 262 | 6 | 39.748679 | 140.408228 | 2021-03-20 05:25:46 | Akita, Japan | ||
3781904 | 3781904 | 2020-10-13 | Japan | Akita | 59 | 0 | 53 | 6 | 39.748679 | 140.408228 | 2020-10-14 04:24:05 | Akita, Japan | ||
3785897 | 3785897 | 2020-10-11 | Japan | Akita | 59 | 0 | 53 | 6 | 39.748679 | 140.408228 | 2020-10-12 04:23:45 | Akita, Japan | ||
3836483 | 3836483 | 2020-11-21 | Japan | Akita | 74 | 0 | 68 | 6 | 39.748679 | 140.408228 | 2020-11-22 05:25:45 | Akita, Japan | ||
3932027 | 3932027 | 2020-08-30 | Japan | Akita | 49 | 0 | 43 | 6 | 39.748679 | 140.408228 | 2020-08-31 04:28:27 | Akita, Japan | ||
435357 | 435357 | 2021-01-21 | Japan | Akita | 229 | 1 | 169 | 59 | 39.748679 | 140.408228 | 2021-01-22 05:22:10 | Akita, Japan | ||
3153606 | 3153606 | 2021-01-27 | Japan | Akita | 253 | 1 | 193 | 59 | 39.748679 | 140.408228 | 2021-01-28 05:22:24 | Akita, Japan | ||
3659595 | 3659595 | 2021-07-11 | Japan | Akita | 939 | 20 | 860 | 59 | 39.748679 | 140.408228 | 2021-07-12 04:21:34 | Akita, Japan | ||
829598 | 829598 | 2021-07-09 | Japan | Akita | 931 | 20 | 853 | 58 | 39.748679 | 140.408228 | 2021-07-10 04:21:25 | Akita, Japan | ||
3089423 | 3089423 | 2021-05-30 | Japan | Akita | 755 | 12 | 685 | 58 | 39.748679 | 140.408228 | 2021-05-31 03:08:59 | Akita, Japan | ||
3129522 | 3129522 | 2021-04-18 | Japan | Akita | 367 | 9 | 300 | 58 | 39.748679 | 140.408228 | 2021-04-19 04:20:57 | Akita, Japan | ||
237242 | 237242 | 2021-01-18 | Japan | Akita | 216 | 1 | 159 | 56 | 39.748679 | 140.408228 | 2021-01-19 05:22:15 | Akita, Japan | ||
1188746 | 1188746 | 2021-05-31 | Japan | Akita | 755 | 14 | 685 | 56 | 39.748679 | 140.408228 | 2021-06-01 04:23:09 | Akita, Japan | ||
625879 | 625879 | 2021-07-10 | Japan | Akita | 935 | 20 | 860 | 55 | 39.748679 | 140.408228 | 2021-07-11 04:21:43 | Akita, Japan | ||
982950 | 982950 | 2021-04-17 | Japan | Akita | 362 | 9 | 298 | 55 | 39.748679 | 140.408228 | 2021-04-18 04:20:41 | Akita, Japan | ||
908179 | 908179 | 2021-01-19 | Japan | Akita | 219 | 1 | 164 | 54 | 39.748679 | 140.408228 | 2021-01-20 05:21:54 | Akita, Japan | ||
170045 | 170045 | 2021-04-16 | Japan | Akita | 356 | 9 | 294 | 53 | 39.748679 | 140.408228 | 2021-04-17 04:20:40 | Akita, Japan | ||
331907 | 331907 | 2021-08-04 | Japan | Akita | 1038 | 20 | 965 | 53 | 39.748679 | 140.408228 | 2021-08-05 04:21:51 | Akita, Japan | ||
1459760 | 1459760 | 2021-01-31 | Japan | Akita | 261 | 1 | 207 | 53 | 39.748679 | 140.408228 | 2021-02-01 05:22:53 | Akita, Japan | ||
1897155 | 1897155 | 2021-01-29 | Japan | Akita | 260 | 1 | 206 | 53 | 39.748679 | 140.408228 | 2021-01-30 05:22:49 | Akita, Japan | ||
2211668 | 2211668 | 2021-01-30 | Japan | Akita | 260 | 1 | 207 | 52 | 39.748679 | 140.408228 | 2021-01-31 05:22:42 | Akita, Japan | ||
2371512 | 2371512 | 2021-07-20 | Japan | Akita | 977 | 20 | 905 | 52 | 39.748679 | 140.408228 | 2021-07-21 04:21:40 | Akita, Japan | ||
2481971 | 2481971 | 2021-01-28 | Japan | Akita | 255 | 1 | 203 | 51 | 39.748679 | 140.408228 | 2021-01-29 05:22:23 | Akita, Japan | ||
3706126 | 3706126 | 2021-07-17 | Japan | Akita | 972 | 20 | 901 | 51 | 39.748679 | 140.408228 | 2021-07-18 04:22:07 | Akita, Japan | ||
483591 | 483591 | 2021-07-19 | Japan | Akita | 974 | 20 | 904 | 50 | 39.748679 | 140.408228 | 2021-07-20 04:21:48 | Akita, Japan | ||
2673814 | 2673814 | 2021-07-18 | Japan | Akita | 974 | 20 | 904 | 50 | 39.748679 | 140.408228 | 2021-07-19 04:21:24 | Akita, Japan | ||
3331531 | 3331531 | 2021-07-21 | Japan | Akita | 984 | 20 | 914 | 50 | 39.748679 | 140.408228 | 2021-07-22 04:21:19 | Akita, Japan | ||
3503359 | 3503359 | 2021-01-17 | Japan | Akita | 208 | 1 | 157 | 50 | 39.748679 | 140.408228 | 2021-01-18 05:22:34 | 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]);