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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1491616 | 1491616 | 2021-10-12 | Japan | Okayama | 15192 | 136 | 0 | 34.89246 | 133.826252 | 2021-10-13 04:20:51 | Okayama, Japan | |||
3007349 | 3007349 | 2021-10-11 | Japan | Okayama | 15184 | 136 | 0 | 34.89246 | 133.826252 | 2021-10-12 04:21:09 | Okayama, Japan | |||
423365 | 423365 | 2021-10-10 | Japan | Okayama | 15178 | 136 | 0 | 34.89246 | 133.826252 | 2021-10-11 04:21:31 | Okayama, Japan | |||
2876222 | 2876222 | 2021-10-09 | Japan | Okayama | 15175 | 136 | 0 | 34.89246 | 133.826252 | 2021-10-10 04:21:38 | Okayama, Japan | |||
2959388 | 2959388 | 2021-10-08 | Japan | Okayama | 15171 | 136 | 0 | 34.89246 | 133.826252 | 2021-10-09 04:21:34 | Okayama, Japan | |||
467426 | 467426 | 2021-10-07 | Japan | Okayama | 15162 | 136 | 0 | 34.89246 | 133.826252 | 2021-10-08 04:21:25 | Okayama, Japan | |||
2458806 | 2458806 | 2021-10-06 | Japan | Okayama | 15154 | 136 | 0 | 34.89246 | 133.826252 | 2021-10-07 04:21:36 | Okayama, Japan | |||
3832500 | 3832500 | 2021-10-05 | Japan | Okayama | 15136 | 136 | 0 | 34.89246 | 133.826252 | 2021-10-06 04:21:33 | Okayama, Japan | |||
986993 | 986993 | 2021-10-04 | Japan | Okayama | 15129 | 136 | 0 | 34.89246 | 133.826252 | 2021-10-05 04:21:27 | Okayama, Japan | |||
1274303 | 1274303 | 2021-10-03 | Japan | Okayama | 15117 | 136 | 0 | 34.89246 | 133.826252 | 2021-10-04 04:21:31 | Okayama, Japan | |||
3928056 | 3928056 | 2021-10-02 | Japan | Okayama | 15111 | 136 | 0 | 34.89246 | 133.826252 | 2021-10-03 04:21:24 | Okayama, Japan | |||
2132036 | 2132036 | 2021-10-01 | Japan | Okayama | 15104 | 135 | 0 | 34.89246 | 133.826252 | 2021-10-02 04:21:25 | Okayama, Japan | |||
2772993 | 2772993 | 2021-09-30 | Japan | Okayama | 15094 | 135 | 0 | 34.89246 | 133.826252 | 2021-10-01 04:21:35 | Okayama, Japan | |||
706449 | 706449 | 2021-09-29 | Japan | Okayama | 15084 | 135 | 0 | 34.89246 | 133.826252 | 2021-09-30 04:21:20 | Okayama, Japan | |||
1334291 | 1334291 | 2021-09-28 | Japan | Okayama | 15067 | 135 | 0 | 34.89246 | 133.826252 | 2021-09-29 04:21:45 | Okayama, Japan | |||
1235660 | 1235660 | 2021-09-27 | Japan | Okayama | 15063 | 135 | 0 | 34.89246 | 133.826252 | 2021-09-28 04:21:28 | Okayama, Japan | |||
2075961 | 2075961 | 2021-09-26 | Japan | Okayama | 15061 | 135 | 0 | 34.89246 | 133.826252 | 2021-09-27 04:21:16 | Okayama, Japan | |||
1724513 | 1724513 | 2021-09-25 | Japan | Okayama | 15051 | 135 | 0 | 34.89246 | 133.826252 | 2021-09-26 04:21:29 | Okayama, Japan | |||
1921233 | 1921233 | 2021-09-24 | Japan | Okayama | 15038 | 135 | 0 | 34.89246 | 133.826252 | 2021-09-25 04:21:31 | Okayama, Japan | |||
601704 | 601704 | 2021-09-23 | Japan | Okayama | 15025 | 135 | 0 | 34.89246 | 133.826252 | 2021-09-24 04:21:44 | Okayama, Japan | |||
3011365 | 3011365 | 2021-09-22 | Japan | Okayama | 15002 | 135 | 0 | 34.89246 | 133.826252 | 2021-09-23 04:21:43 | Okayama, Japan | |||
3757503 | 3757503 | 2021-09-21 | Japan | Okayama | 14981 | 135 | 0 | 34.89246 | 133.826252 | 2021-09-22 04:21:45 | Okayama, Japan | |||
809606 | 809606 | 2021-09-20 | Japan | Okayama | 14978 | 135 | 0 | 34.89246 | 133.826252 | 2021-09-21 04:21:26 | Okayama, Japan | |||
1814805 | 1814805 | 2021-09-19 | Japan | Okayama | 14969 | 135 | 0 | 34.89246 | 133.826252 | 2021-09-20 04:21:22 | Okayama, Japan | |||
16385 | 16385 | 2021-09-18 | Japan | Okayama | 14948 | 135 | 0 | 34.89246 | 133.826252 | 2021-09-19 04:21:34 | Okayama, Japan | |||
2618070 | 2618070 | 2021-09-17 | Japan | Okayama | 14911 | 135 | 0 | 34.89246 | 133.826252 | 2021-09-18 04:21:24 | Okayama, Japan | |||
2808778 | 2808778 | 2021-09-16 | Japan | Okayama | 14886 | 135 | 0 | 34.89246 | 133.826252 | 2021-09-17 04:21:46 | Okayama, Japan | |||
1374523 | 1374523 | 2021-09-15 | Japan | Okayama | 14842 | 135 | 0 | 34.89246 | 133.826252 | 2021-09-16 04:22:19 | Okayama, Japan | |||
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 |
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]);