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 = "Okayama" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2462822 | 2462822 | 2021-09-14 | Japan | Okayama | 14792 | 134 | 0 | 34.89246 | 133.826252 | 2021-09-15 03:22:37 | Okayama, Japan | |||
1385661 | 1385661 | 2021-09-13 | Japan | Okayama | 14754 | 133 | 0 | 34.89246 | 133.826252 | 2021-09-14 04:21:41 | Okayama, Japan | |||
1885030 | 1885030 | 2021-09-12 | Japan | Okayama | 14730 | 133 | 0 | 34.89246 | 133.826252 | 2021-09-13 04:21:15 | Okayama, Japan | |||
3805933 | 3805933 | 2021-09-11 | Japan | Okayama | 14667 | 132 | 0 | 34.89246 | 133.826252 | 2021-09-12 04:21:13 | Okayama, Japan | |||
3448873 | 3448873 | 2021-09-10 | Japan | Okayama | 14621 | 132 | 0 | 34.89246 | 133.826252 | 2021-09-11 04:21:30 | Okayama, Japan | |||
1262819 | 1262819 | 2021-09-09 | Japan | Okayama | 14538 | 132 | 0 | 34.89246 | 133.826252 | 2021-09-10 04:21:20 | Okayama, Japan | |||
2279189 | 2279189 | 2021-09-08 | Japan | Okayama | 14466 | 132 | 0 | 34.89246 | 133.826252 | 2021-09-09 04:21:27 | Okayama, Japan | |||
641968 | 641968 | 2021-09-07 | Japan | Okayama | 14353 | 132 | 0 | 34.89246 | 133.826252 | 2021-09-08 04:21:31 | Okayama, Japan | |||
3194031 | 3194031 | 2021-09-06 | Japan | Okayama | 14291 | 132 | 0 | 34.89246 | 133.826252 | 2021-09-07 04:21:35 | Okayama, Japan | |||
3280899 | 3280899 | 2021-09-05 | Japan | Okayama | 14223 | 132 | 0 | 34.89246 | 133.826252 | 2021-09-06 04:21:22 | Okayama, Japan | |||
249313 | 249313 | 2021-09-04 | Japan | Okayama | 14090 | 130 | 0 | 34.89246 | 133.826252 | 2021-09-05 04:21:33 | Okayama, Japan | |||
3974594 | 3974594 | 2021-09-03 | Japan | Okayama | 13949 | 129 | 0 | 34.89246 | 133.826252 | 2021-09-04 04:21:28 | Okayama, Japan | |||
178056 | 178056 | 2021-09-02 | Japan | Okayama | 13764 | 129 | 0 | 34.89246 | 133.826252 | 2021-09-03 04:21:20 | Okayama, Japan | |||
67091 | 67091 | 2021-09-01 | Japan | Okayama | 13601 | 128 | 0 | 34.89246 | 133.826252 | 2021-09-02 04:21:15 | Okayama, Japan | |||
2067933 | 2067933 | 2021-08-31 | Japan | Okayama | 13383 | 128 | 0 | 34.89246 | 133.826252 | 2021-09-01 04:21:38 | Okayama, Japan | |||
1775387 | 1775387 | 2021-08-30 | Japan | Okayama | 13244 | 127 | 0 | 34.89246 | 133.826252 | 2021-08-31 04:21:46 | Okayama, Japan | |||
3891961 | 3891961 | 2021-08-29 | Japan | Okayama | 13093 | 127 | 0 | 34.89246 | 133.826252 | 2021-08-30 04:21:23 | Okayama, Japan | |||
2793064 | 2793064 | 2021-08-28 | Japan | Okayama | 12905 | 127 | 0 | 34.89246 | 133.826252 | 2021-08-29 04:21:14 | Okayama, Japan | |||
2923223 | 2923223 | 2021-08-27 | Japan | Okayama | 12695 | 127 | 0 | 34.89246 | 133.826252 | 2021-08-28 04:21:28 | Okayama, Japan | |||
1596237 | 1596237 | 2021-08-26 | Japan | Okayama | 12447 | 127 | 0 | 34.89246 | 133.826252 | 2021-08-27 04:21:37 | Okayama, Japan | |||
32446 | 32446 | 2021-08-25 | Japan | Okayama | 12241 | 127 | 0 | 34.89246 | 133.826252 | 2021-08-26 04:21:28 | Okayama, Japan | |||
3105485 | 3105485 | 2021-08-24 | Japan | Okayama | 11939 | 127 | 0 | 34.89246 | 133.826252 | 2021-08-25 04:21:41 | Okayama, Japan | |||
3165656 | 3165656 | 2021-08-23 | Japan | Okayama | 11779 | 127 | 0 | 34.89246 | 133.826252 | 2021-08-24 04:21:19 | Okayama, Japan | |||
2175583 | 2175583 | 2021-08-22 | Japan | Okayama | 11612 | 127 | 0 | 34.89246 | 133.826252 | 2021-08-23 04:21:27 | Okayama, Japan | |||
3555679 | 3555679 | 2021-08-21 | Japan | Okayama | 11366 | 127 | 0 | 34.89246 | 133.826252 | 2021-08-22 04:21:29 | Okayama, Japan | |||
1854021 | 1854021 | 2021-08-20 | Japan | Okayama | 11115 | 127 | 0 | 34.89246 | 133.826252 | 2021-08-21 04:21:38 | Okayama, Japan | |||
511728 | 511728 | 2021-08-19 | Japan | Okayama | 10841 | 127 | 0 | 34.89246 | 133.826252 | 2021-08-20 04:21:33 | Okayama, Japan | |||
2518207 | 2518207 | 2021-08-18 | Japan | Okayama | 10587 | 127 | 0 | 34.89246 | 133.826252 | 2021-08-19 04:21:15 | Okayama, Japan | |||
245299 | 245299 | 2021-08-17 | Japan | Okayama | 10280 | 127 | 0 | 34.89246 | 133.826252 | 2021-08-18 04:21:35 | Okayama, Japan | |||
1604262 | 1604262 | 2021-08-16 | Japan | Okayama | 10117 | 127 | 0 | 34.89246 | 133.826252 | 2021-08-17 04:21:49 | Okayama, Japan | |||
103356 | 103356 | 2021-08-15 | Japan | Okayama | 9975 | 127 | 0 | 34.89246 | 133.826252 | 2021-08-16 04:21:31 | Okayama, Japan | |||
507714 | 507714 | 2021-08-14 | Japan | Okayama | 9806 | 127 | 0 | 34.89246 | 133.826252 | 2021-08-15 04:21:41 | Okayama, Japan | |||
1483586 | 1483586 | 2021-08-13 | Japan | Okayama | 9607 | 127 | 0 | 34.89246 | 133.826252 | 2021-08-14 04:21:25 | Okayama, Japan | |||
2899716 | 2899716 | 2021-08-12 | Japan | Okayama | 9440 | 127 | 0 | 34.89246 | 133.826252 | 2021-08-13 04:21:24 | Okayama, Japan | |||
1342320 | 1342320 | 2021-08-11 | Japan | Okayama | 9223 | 127 | 0 | 34.89246 | 133.826252 | 2021-08-12 04:21:25 | Okayama, Japan | |||
2351467 | 2351467 | 2021-08-10 | Japan | Okayama | 9086 | 127 | 0 | 34.89246 | 133.826252 | 2021-08-11 04:21:58 | Okayama, Japan | |||
649996 | 649996 | 2021-08-09 | Japan | Okayama | 9022 | 127 | 0 | 34.89246 | 133.826252 | 2021-08-10 04:21:27 | Okayama, Japan | |||
589658 | 589658 | 2021-08-08 | Japan | Okayama | 8935 | 127 | 0 | 34.89246 | 133.826252 | 2021-08-09 04:21:24 | Okayama, Japan | |||
2203670 | 2203670 | 2021-08-07 | Japan | Okayama | 8848 | 127 | 0 | 34.89246 | 133.826252 | 2021-08-08 04:21:33 | Okayama, Japan | |||
1117620 | 1117620 | 2021-08-06 | Japan | Okayama | 8728 | 127 | 0 | 34.89246 | 133.826252 | 2021-08-07 04:21:30 | Okayama, Japan | |||
1956557 | 1956557 | 2021-08-05 | Japan | Okayama | 8627 | 127 | 0 | 34.89246 | 133.826252 | 2021-08-06 04:21:18 | Okayama, Japan | |||
331936 | 331936 | 2021-08-04 | Japan | Okayama | 8538 | 127 | 7612 | 799 | 34.89246 | 133.826252 | 2021-08-05 04:21:51 | Okayama, Japan | ||
3468207 | 3468207 | 2021-08-03 | Japan | Okayama | 8407 | 127 | 7612 | 668 | 34.89246 | 133.826252 | 2021-08-04 04:21:25 | Okayama, Japan | ||
3683481 | 3683481 | 2021-08-02 | Japan | Okayama | 8329 | 127 | 7612 | 590 | 34.89246 | 133.826252 | 2021-08-03 04:21:39 | Okayama, Japan | ||
3015380 | 3015380 | 2021-08-01 | Japan | Okayama | 8279 | 127 | 7612 | 540 | 34.89246 | 133.826252 | 2021-08-02 04:21:36 | Okayama, Japan | ||
3904003 | 3904003 | 2021-07-31 | Japan | Okayama | 8185 | 127 | 7612 | 446 | 34.89246 | 133.826252 | 2021-08-01 04:21:50 | Okayama, Japan | ||
3296208 | 3296208 | 2021-07-30 | Japan | Okayama | 8120 | 127 | 7518 | 475 | 34.89246 | 133.826252 | 2021-07-31 04:21:35 | Okayama, Japan | ||
3385419 | 3385419 | 2021-07-29 | Japan | Okayama | 8043 | 127 | 7518 | 398 | 34.89246 | 133.826252 | 2021-07-30 04:21:34 | Okayama, Japan | ||
408324 | 408324 | 2021-07-28 | Japan | Okayama | 7984 | 127 | 7518 | 339 | 34.89246 | 133.826252 | 2021-07-29 04:21:33 | Okayama, Japan | ||
1306185 | 1306185 | 2021-07-27 | Japan | Okayama | 7926 | 127 | 7518 | 281 | 34.89246 | 133.826252 | 2021-07-28 04:21:39 | Okayama, Japan | ||
3218328 | 3218328 | 2021-07-26 | Japan | Okayama | 7891 | 127 | 7518 | 246 | 34.89246 | 133.826252 | 2021-07-27 04:21:18 | Okayama, Japan | ||
1378537 | 1378537 | 2021-07-25 | Japan | Okayama | 7868 | 127 | 7518 | 223 | 34.89246 | 133.826252 | 2021-07-26 04:21:28 | Okayama, Japan | ||
1330277 | 1330277 | 2021-07-24 | Japan | Okayama | 7841 | 127 | 7518 | 196 | 34.89246 | 133.826252 | 2021-07-25 04:22:12 | Okayama, Japan | ||
3137581 | 3137581 | 2021-07-23 | Japan | Okayama | 7810 | 127 | 7472 | 211 | 34.89246 | 133.826252 | 2021-07-24 00:21:36 | Okayama, Japan | ||
3476341 | 3476341 | 2021-07-22 | Japan | Okayama | 7782 | 127 | 7472 | 183 | 34.89246 | 133.826252 | 2021-07-23 04:21:29 | Okayama, Japan | ||
3331560 | 3331560 | 2021-07-21 | Japan | Okayama | 7749 | 127 | 7472 | 150 | 34.89246 | 133.826252 | 2021-07-22 04:21:19 | Okayama, Japan | ||
2371541 | 2371541 | 2021-07-20 | Japan | Okayama | 7716 | 127 | 7472 | 117 | 34.89246 | 133.826252 | 2021-07-21 04:21:40 | Okayama, Japan | ||
483620 | 483620 | 2021-07-19 | Japan | Okayama | 7700 | 127 | 7472 | 101 | 34.89246 | 133.826252 | 2021-07-20 04:21:48 | Okayama, Japan | ||
2673843 | 2673843 | 2021-07-18 | Japan | Okayama | 7686 | 127 | 7472 | 87 | 34.89246 | 133.826252 | 2021-07-19 04:21:24 | Okayama, Japan | ||
3706155 | 3706155 | 2021-07-17 | Japan | Okayama | 7677 | 127 | 7472 | 78 | 34.89246 | 133.826252 | 2021-07-18 04:22:07 | Okayama, Japan | ||
2947386 | 2947386 | 2021-07-16 | Japan | Okayama | 7668 | 127 | 7455 | 86 | 34.89246 | 133.826252 | 2021-07-17 04:22:22 | Okayama, Japan | ||
296042 | 296042 | 2021-07-15 | Japan | Okayama | 7657 | 127 | 7455 | 75 | 34.89246 | 133.826252 | 2021-07-16 04:21:22 | Okayama, Japan | ||
3631987 | 3631987 | 2021-07-14 | Japan | Okayama | 7638 | 127 | 7455 | 56 | 34.89246 | 133.826252 | 2021-07-15 04:21:48 | Okayama, Japan | ||
578862 | 578862 | 2021-07-13 | Japan | Okayama | 7628 | 127 | 7455 | 46 | 34.89246 | 133.826252 | 2021-07-14 04:21:35 | Okayama, Japan | ||
3741111 | 3741111 | 2021-07-12 | Japan | Okayama | 7622 | 126 | 7455 | 41 | 34.89246 | 133.826252 | 2021-07-13 04:21:18 | Okayama, Japan | ||
3659624 | 3659624 | 2021-07-11 | Japan | Okayama | 7616 | 126 | 7455 | 35 | 34.89246 | 133.826252 | 2021-07-12 04:21:34 | Okayama, Japan | ||
625908 | 625908 | 2021-07-10 | Japan | Okayama | 7613 | 126 | 7455 | 32 | 34.89246 | 133.826252 | 2021-07-11 04:21:43 | Okayama, Japan | ||
829627 | 829627 | 2021-07-09 | Japan | Okayama | 7609 | 126 | 7439 | 44 | 34.89246 | 133.826252 | 2021-07-10 04:21:25 | Okayama, Japan | ||
778391 | 778391 | 2021-07-08 | Japan | Okayama | 7605 | 126 | 7439 | 40 | 34.89246 | 133.826252 | 2021-07-09 04:21:21 | Okayama, Japan | ||
1440613 | 1440613 | 2021-07-07 | Japan | Okayama | 7603 | 126 | 7439 | 38 | 34.89246 | 133.826252 | 2021-07-08 04:21:26 | Okayama, Japan | ||
2693718 | 2693718 | 2021-07-06 | Japan | Okayama | 7599 | 126 | 7439 | 34 | 34.89246 | 133.826252 | 2021-07-07 04:21:20 | Okayama, Japan | ||
1932467 | 1932467 | 2021-07-05 | Japan | Okayama | 7596 | 126 | 7439 | 31 | 34.89246 | 133.826252 | 2021-07-06 04:21:32 | Okayama, Japan | ||
1165198 | 1165198 | 2021-07-04 | Japan | Okayama | 7596 | 126 | 7439 | 31 | 34.89246 | 133.826252 | 2021-07-05 04:21:28 | Okayama, Japan | ||
1495632 | 1495632 | 2021-07-03 | Japan | Okayama | 7595 | 126 | 7439 | 30 | 34.89246 | 133.826252 | 2021-07-04 04:21:38 | Okayama, Japan | ||
2071947 | 2071947 | 2021-07-02 | Japan | Okayama | 7595 | 126 | 7385 | 84 | 34.89246 | 133.826252 | 2021-07-03 04:21:37 | Okayama, Japan | ||
2764963 | 2764963 | 2021-07-01 | Japan | Okayama | 7591 | 126 | 7385 | 80 | 34.89246 | 133.826252 | 2021-07-02 04:21:47 | Okayama, Japan | ||
1893171 | 1893171 | 2021-06-30 | Japan | Okayama | 7590 | 126 | 7385 | 79 | 34.89246 | 133.826252 | 2021-07-01 04:21:19 | Okayama, Japan | ||
400294 | 400294 | 2021-06-29 | Japan | Okayama | 7588 | 126 | 7385 | 77 | 34.89246 | 133.826252 | 2021-06-30 04:21:41 | Okayama, Japan | ||
3125537 | 3125537 | 2021-06-28 | Japan | Okayama | 7588 | 126 | 7385 | 77 | 34.89246 | 133.826252 | 2021-06-29 04:21:28 | Okayama, Japan | ||
2590032 | 2590032 | 2021-06-27 | Japan | Okayama | 7588 | 126 | 7385 | 77 | 34.89246 | 133.826252 | 2021-06-28 04:21:29 | Okayama, Japan | ||
3958536 | 3958536 | 2021-06-26 | Japan | Okayama | 7587 | 126 | 7385 | 76 | 34.89246 | 133.826252 | 2021-06-27 04:21:39 | Okayama, Japan | ||
1712355 | 1712355 | 2021-06-25 | Japan | Okayama | 7584 | 126 | 7302 | 156 | 34.89246 | 133.826252 | 2021-06-26 04:21:43 | Okayama, Japan | ||
2295480 | 2295480 | 2021-06-24 | Japan | Okayama | 7584 | 126 | 7302 | 156 | 34.89246 | 133.826252 | 2021-06-25 04:21:33 | Okayama, Japan | ||
2422920 | 2422920 | 2021-06-23 | Japan | Okayama | 7582 | 125 | 7302 | 155 | 34.89246 | 133.826252 | 2021-06-24 04:21:55 | Okayama, Japan | ||
562997 | 562997 | 2021-06-22 | Japan | Okayama | 7581 | 124 | 7302 | 155 | 34.89246 | 133.826252 | 2021-06-23 04:21:46 | Okayama, Japan | ||
3358699 | 3358699 | 2021-06-21 | Japan | Okayama | 7580 | 124 | 7302 | 154 | 34.89246 | 133.826252 | 2021-06-22 04:21:34 | Okayama, Japan | ||
2884398 | 2884398 | 2021-06-20 | Japan | Okayama | 7579 | 124 | 7302 | 153 | 34.89246 | 133.826252 | 2021-06-21 04:21:41 | Okayama, Japan | ||
107481 | 107481 | 2021-06-19 | Japan | Okayama | 7577 | 124 | 7302 | 151 | 34.89246 | 133.826252 | 2021-06-20 04:21:48 | Okayama, Japan | ||
1125624 | 1125624 | 2021-06-18 | Japan | Okayama | 7571 | 123 | 7125 | 323 | 34.89246 | 133.826252 | 2021-06-19 04:22:33 | Okayama, Japan | ||
2911202 | 2911202 | 2021-06-17 | Japan | Okayama | 7568 | 123 | 7125 | 320 | 34.89246 | 133.826252 | 2021-06-18 04:22:16 | Okayama, Japan | ||
3030320 | 3030320 | 2021-06-16 | Japan | Okayama | 7564 | 123 | 7125 | 316 | 34.89246 | 133.826252 | 2021-06-17 04:22:36 | Okayama, Japan | ||
2339426 | 2339426 | 2021-06-15 | Japan | Okayama | 7556 | 121 | 7125 | 310 | 34.89246 | 133.826252 | 2021-06-16 04:22:32 | Okayama, Japan | ||
1564122 | 1564122 | 2021-06-14 | Japan | Okayama | 7551 | 120 | 7125 | 306 | 34.89246 | 133.826252 | 2021-06-15 04:22:22 | Okayama, Japan | ||
3381405 | 3381405 | 2021-06-13 | Japan | Okayama | 7550 | 120 | 7125 | 305 | 34.89246 | 133.826252 | 2021-06-14 04:22:46 | Okayama, Japan | ||
1736539 | 1736539 | 2021-06-12 | Japan | Okayama | 7544 | 120 | 7125 | 299 | 34.89246 | 133.826252 | 2021-06-13 04:22:44 | Okayama, Japan | ||
3970580 | 3970580 | 2021-06-11 | Japan | Okayama | 7533 | 120 | 6712 | 701 | 34.89246 | 133.826252 | 2021-06-12 04:22:22 | Okayama, Japan | ||
2717002 | 2717002 | 2021-06-10 | Japan | Okayama | 7521 | 119 | 6712 | 690 | 34.89246 | 133.826252 | 2021-06-11 04:23:20 | Okayama, Japan | ||
522887 | 522887 | 2021-06-09 | Japan | Okayama | 7509 | 115 | 6712 | 682 | 34.89246 | 133.826252 | 2021-06-10 04:23:17 | Okayama, Japan | ||
3472327 | 3472327 | 2021-06-08 | Japan | Okayama | 7496 | 114 | 6712 | 670 | 34.89246 | 133.826252 | 2021-06-09 04:23:31 | Okayama, Japan | ||
3145611 | 3145611 | 2021-06-07 | Japan | Okayama | 7488 | 113 | 6712 | 663 | 34.89246 | 133.826252 | 2021-06-08 04:22:35 | Okayama, 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]);