daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where country_or_region = "Japan" and province_or_state = "Aomori" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-09-20 | Japan | Aomori | 159589 | 288 | 0 | 40.781541 | 140.828896 | 2022-09-21 04:23:22 | Aomori, Japan | |||
2022-09-19 | Japan | Aomori | 159367 | 288 | 0 | 40.781541 | 140.828896 | 2022-09-20 04:22:48 | Aomori, Japan | |||
2022-09-18 | Japan | Aomori | 159064 | 287 | 0 | 40.781541 | 140.828896 | 2022-09-19 04:21:49 | Aomori, Japan | |||
2022-09-17 | Japan | Aomori | 158591 | 285 | 0 | 40.781541 | 140.828896 | 2022-09-18 04:22:50 | Aomori, Japan | |||
2022-09-16 | Japan | Aomori | 158060 | 279 | 0 | 40.781541 | 140.828896 | 2022-09-17 04:20:19 | Aomori, Japan | |||
2022-09-15 | Japan | Aomori | 157499 | 277 | 0 | 40.781541 | 140.828896 | 2022-09-16 04:21:19 | Aomori, Japan | |||
2022-09-14 | Japan | Aomori | 156908 | 273 | 0 | 40.781541 | 140.828896 | 2022-09-15 04:21:02 | Aomori, Japan | |||
2022-09-13 | Japan | Aomori | 156072 | 272 | 0 | 40.781541 | 140.828896 | 2022-09-14 04:20:44 | Aomori, Japan | |||
2022-09-12 | Japan | Aomori | 155604 | 268 | 0 | 40.781541 | 140.828896 | 2022-09-13 04:20:57 | Aomori, Japan | |||
2022-09-11 | Japan | Aomori | 155116 | 266 | 0 | 40.781541 | 140.828896 | 2022-09-12 04:20:58 | Aomori, Japan | |||
2022-09-10 | Japan | Aomori | 154322 | 264 | 0 | 40.781541 | 140.828896 | 2022-09-11 04:20:50 | Aomori, Japan | |||
2022-09-09 | Japan | Aomori | 153425 | 262 | 0 | 40.781541 | 140.828896 | 2022-09-10 04:21:10 | Aomori, Japan | |||
2022-09-08 | Japan | Aomori | 152406 | 260 | 0 | 40.781541 | 140.828896 | 2022-09-09 04:21:11 | Aomori, Japan | |||
2022-09-07 | Japan | Aomori | 151203 | 259 | 0 | 40.781541 | 140.828896 | 2022-09-08 04:21:02 | Aomori, Japan | |||
2022-09-06 | Japan | Aomori | 149580 | 255 | 0 | 40.781541 | 140.828896 | 2022-09-07 04:20:59 | Aomori, Japan | |||
2022-09-05 | Japan | Aomori | 148867 | 255 | 0 | 40.781541 | 140.828896 | 2022-09-06 04:21:02 | Aomori, Japan | |||
2022-09-04 | Japan | Aomori | 147947 | 252 | 0 | 40.781541 | 140.828896 | 2022-09-05 04:21:01 | Aomori, Japan | |||
2022-09-03 | Japan | Aomori | 146578 | 245 | 0 | 40.781541 | 140.828896 | 2022-09-04 04:21:22 | Aomori, Japan | |||
2022-09-02 | Japan | Aomori | 145141 | 234 | 0 | 40.781541 | 140.828896 | 2022-09-03 04:21:04 | Aomori, Japan | |||
2022-09-01 | Japan | Aomori | 143529 | 232 | 0 | 40.781541 | 140.828896 | 2022-09-02 04:21:07 | Aomori, Japan | |||
2022-08-31 | Japan | Aomori | 141500 | 222 | 0 | 40.781541 | 140.828896 | 2022-09-01 04:21:03 | Aomori, Japan | |||
2022-08-30 | Japan | Aomori | 139556 | 211 | 0 | 40.781541 | 140.828896 | 2022-08-31 04:20:57 | Aomori, Japan | |||
2022-08-29 | Japan | Aomori | 138297 | 210 | 0 | 40.781541 | 140.828896 | 2022-08-30 04:21:03 | Aomori, Japan | |||
2022-08-28 | Japan | Aomori | 136985 | 206 | 0 | 40.781541 | 140.828896 | 2022-08-29 04:21:06 | Aomori, Japan | |||
2022-08-27 | Japan | Aomori | 135175 | 203 | 0 | 40.781541 | 140.828896 | 2022-08-28 04:21:02 | Aomori, Japan | |||
2022-08-26 | Japan | Aomori | 132982 | 195 | 0 | 40.781541 | 140.828896 | 2022-08-27 04:20:57 | Aomori, Japan | |||
2022-08-25 | Japan | Aomori | 130658 | 192 | 0 | 40.781541 | 140.828896 | 2022-08-26 04:21:02 | Aomori, Japan | |||
2022-08-24 | Japan | Aomori | 127860 | 186 | 0 | 40.781541 | 140.828896 | 2022-08-25 04:21:13 | Aomori, Japan | |||
2022-08-23 | Japan | Aomori | 125831 | 184 | 0 | 40.781541 | 140.828896 | 2022-08-24 04:20:46 | Aomori, Japan | |||
2022-08-22 | Japan | Aomori | 124888 | 179 | 0 | 40.781541 | 140.828896 | 2022-08-23 04:20:56 | Aomori, Japan | |||
2022-08-21 | Japan | Aomori | 123594 | 176 | 0 | 40.781541 | 140.828896 | 2022-08-22 04:20:38 | Aomori, Japan | |||
2022-08-20 | Japan | Aomori | 121740 | 173 | 0 | 40.781541 | 140.828896 | 2022-08-21 04:20:44 | Aomori, Japan | |||
2022-08-19 | Japan | Aomori | 119400 | 167 | 0 | 40.781541 | 140.828896 | 2022-08-20 04:21:01 | Aomori, Japan | |||
2022-08-18 | Japan | Aomori | 117029 | 167 | 0 | 40.781541 | 140.828896 | 2022-08-19 04:20:54 | Aomori, Japan | |||
2022-08-17 | Japan | Aomori | 114991 | 166 | 0 | 40.781541 | 140.828896 | 2022-08-18 04:21:11 | Aomori, Japan | |||
2022-08-16 | Japan | Aomori | 113049 | 164 | 0 | 40.781541 | 140.828896 | 2022-08-17 04:20:59 | Aomori, Japan | |||
2022-08-15 | Japan | Aomori | 111819 | 161 | 0 | 40.781541 | 140.828896 | 2022-08-16 04:20:58 | Aomori, Japan | |||
2022-08-14 | Japan | Aomori | 111007 | 158 | 0 | 40.781541 | 140.828896 | 2022-08-15 04:20:59 | Aomori, Japan | |||
2022-08-13 | Japan | Aomori | 109503 | 157 | 0 | 40.781541 | 140.828896 | 2022-08-14 04:20:55 | Aomori, Japan | |||
2022-08-12 | Japan | Aomori | 108053 | 154 | 0 | 40.781541 | 140.828896 | 2022-08-13 04:20:52 | Aomori, Japan | |||
2022-08-11 | Japan | Aomori | 106653 | 153 | 0 | 40.781541 | 140.828896 | 2022-08-12 04:20:54 | Aomori, Japan | |||
2022-08-10 | Japan | Aomori | 104944 | 152 | 0 | 40.781541 | 140.828896 | 2022-08-11 04:20:49 | Aomori, Japan | |||
2022-08-09 | Japan | Aomori | 102885 | 152 | 0 | 40.781541 | 140.828896 | 2022-08-10 04:20:57 | Aomori, Japan | |||
2022-08-08 | Japan | Aomori | 101852 | 150 | 0 | 40.781541 | 140.828896 | 2022-08-09 04:20:34 | Aomori, Japan | |||
2022-08-07 | Japan | Aomori | 100777 | 150 | 0 | 40.781541 | 140.828896 | 2022-08-08 04:21:08 | Aomori, Japan | |||
2022-08-06 | Japan | Aomori | 99529 | 149 | 0 | 40.781541 | 140.828896 | 2022-08-07 04:20:54 | Aomori, Japan | |||
2022-08-05 | Japan | Aomori | 97997 | 149 | 0 | 40.781541 | 140.828896 | 2022-08-06 04:20:56 | Aomori, Japan | |||
2022-08-04 | Japan | Aomori | 96503 | 147 | 0 | 40.781541 | 140.828896 | 2022-08-05 04:20:52 | Aomori, Japan | |||
2022-08-03 | Japan | Aomori | 95058 | 145 | 0 | 40.781541 | 140.828896 | 2022-08-04 04:20:58 | Aomori, Japan | |||
2022-08-02 | Japan | Aomori | 93735 | 142 | 0 | 40.781541 | 140.828896 | 2022-08-03 04:20:59 | Aomori, Japan | |||
2022-08-01 | Japan | Aomori | 92161 | 142 | 0 | 40.781541 | 140.828896 | 2022-08-02 04:20:53 | Aomori, Japan | |||
2022-07-31 | Japan | Aomori | 91280 | 139 | 0 | 40.781541 | 140.828896 | 2022-08-01 04:21:03 | Aomori, Japan | |||
2022-07-30 | Japan | Aomori | 90114 | 139 | 0 | 40.781541 | 140.828896 | 2022-07-31 04:21:02 | Aomori, Japan | |||
2022-07-29 | Japan | Aomori | 88594 | 138 | 0 | 40.781541 | 140.828896 | 2022-07-30 04:20:42 | Aomori, Japan | |||
2022-07-28 | Japan | Aomori | 87123 | 137 | 0 | 40.781541 | 140.828896 | 2022-07-29 04:20:45 | Aomori, Japan | |||
2022-07-27 | Japan | Aomori | 85554 | 136 | 0 | 40.781541 | 140.828896 | 2022-07-28 04:20:56 | Aomori, Japan | |||
2022-07-26 | Japan | Aomori | 84045 | 131 | 0 | 40.781541 | 140.828896 | 2022-07-27 04:21:04 | Aomori, Japan | |||
2022-07-25 | Japan | Aomori | 82536 | 127 | 0 | 40.781541 | 140.828896 | 2022-07-26 04:20:58 | Aomori, Japan | |||
2022-07-24 | Japan | Aomori | 81602 | 123 | 0 | 40.781541 | 140.828896 | 2022-07-25 04:20:51 | Aomori, Japan | |||
2022-07-23 | Japan | Aomori | 80295 | 123 | 0 | 40.781541 | 140.828896 | 2022-07-24 04:20:47 | Aomori, Japan | |||
2022-07-22 | Japan | Aomori | 78710 | 122 | 0 | 40.781541 | 140.828896 | 2022-07-23 04:20:53 | Aomori, Japan | |||
2022-07-21 | Japan | Aomori | 77091 | 122 | 0 | 40.781541 | 140.828896 | 2022-07-22 04:21:15 | Aomori, Japan | |||
2022-07-20 | Japan | Aomori | 75514 | 122 | 0 | 40.781541 | 140.828896 | 2022-07-21 04:21:10 | Aomori, Japan | |||
2022-07-19 | Japan | Aomori | 74079 | 121 | 0 | 40.781541 | 140.828896 | 2022-07-20 04:20:59 | Aomori, Japan | |||
2022-07-18 | Japan | Aomori | 73383 | 121 | 0 | 40.781541 | 140.828896 | 2022-07-19 04:20:58 | Aomori, Japan | |||
2022-07-17 | Japan | Aomori | 72604 | 118 | 0 | 40.781541 | 140.828896 | 2022-07-18 04:20:59 | Aomori, Japan | |||
2022-07-16 | Japan | Aomori | 71784 | 118 | 0 | 40.781541 | 140.828896 | 2022-07-17 04:21:15 | Aomori, Japan | |||
2022-07-15 | Japan | Aomori | 70810 | 118 | 0 | 40.781541 | 140.828896 | 2022-07-16 04:21:05 | Aomori, Japan | |||
2022-07-14 | Japan | Aomori | 69890 | 117 | 0 | 40.781541 | 140.828896 | 2022-07-15 04:20:53 | Aomori, Japan | |||
2022-07-13 | Japan | Aomori | 68979 | 117 | 0 | 40.781541 | 140.828896 | 2022-07-14 04:20:57 | Aomori, Japan | |||
2022-07-12 | Japan | Aomori | 68279 | 117 | 0 | 40.781541 | 140.828896 | 2022-07-13 04:20:58 | Aomori, Japan | |||
2022-07-11 | Japan | Aomori | 67580 | 117 | 0 | 40.781541 | 140.828896 | 2022-07-12 04:20:51 | Aomori, Japan | |||
2022-07-10 | Japan | Aomori | 67141 | 117 | 0 | 40.781541 | 140.828896 | 2022-07-11 04:20:46 | Aomori, Japan | |||
2022-07-09 | Japan | Aomori | 66723 | 116 | 0 | 40.781541 | 140.828896 | 2022-07-10 04:20:54 | Aomori, Japan | |||
2022-07-08 | Japan | Aomori | 66224 | 116 | 0 | 40.781541 | 140.828896 | 2022-07-09 04:20:59 | Aomori, Japan | |||
2022-07-07 | Japan | Aomori | 65954 | 116 | 0 | 40.781541 | 140.828896 | 2022-07-08 04:20:56 | Aomori, Japan | |||
2022-07-06 | Japan | Aomori | 65504 | 115 | 0 | 40.781541 | 140.828896 | 2022-07-07 04:20:55 | Aomori, Japan | |||
2022-07-05 | Japan | Aomori | 65114 | 115 | 0 | 40.781541 | 140.828896 | 2022-07-06 04:20:58 | Aomori, Japan | |||
2022-07-04 | Japan | Aomori | 64809 | 114 | 0 | 40.781541 | 140.828896 | 2022-07-05 04:20:45 | Aomori, Japan | |||
2022-07-03 | Japan | Aomori | 64597 | 114 | 0 | 40.781541 | 140.828896 | 2022-07-04 04:20:54 | Aomori, Japan | |||
2022-07-02 | Japan | Aomori | 64364 | 114 | 0 | 40.781541 | 140.828896 | 2022-07-03 04:20:59 | Aomori, Japan | |||
2022-07-01 | Japan | Aomori | 64089 | 113 | 0 | 40.781541 | 140.828896 | 2022-07-02 04:21:16 | Aomori, Japan | |||
2022-06-30 | Japan | Aomori | 63834 | 112 | 0 | 40.781541 | 140.828896 | 2022-07-01 04:21:10 | Aomori, Japan | |||
2022-06-29 | Japan | Aomori | 63594 | 112 | 0 | 40.781541 | 140.828896 | 2022-06-30 04:21:01 | Aomori, Japan | |||
2022-06-28 | Japan | Aomori | 63321 | 112 | 0 | 40.781541 | 140.828896 | 2022-06-29 04:20:59 | Aomori, Japan | |||
2022-06-27 | Japan | Aomori | 63098 | 112 | 0 | 40.781541 | 140.828896 | 2022-06-28 04:20:58 | Aomori, Japan | |||
2022-06-26 | Japan | Aomori | 62947 | 110 | 0 | 40.781541 | 140.828896 | 2022-06-27 04:21:00 | Aomori, Japan | |||
2022-06-25 | Japan | Aomori | 62792 | 110 | 0 | 40.781541 | 140.828896 | 2022-06-26 04:21:02 | Aomori, Japan | |||
2022-06-24 | Japan | Aomori | 62520 | 109 | 0 | 40.781541 | 140.828896 | 2022-06-25 04:20:57 | Aomori, Japan | |||
2022-06-23 | Japan | Aomori | 62246 | 109 | 0 | 40.781541 | 140.828896 | 2022-06-24 04:20:58 | Aomori, Japan | |||
2022-06-22 | Japan | Aomori | 62000 | 108 | 0 | 40.781541 | 140.828896 | 2022-06-23 04:20:55 | Aomori, Japan | |||
2022-06-21 | Japan | Aomori | 61724 | 108 | 0 | 40.781541 | 140.828896 | 2022-06-22 04:20:54 | Aomori, Japan | |||
2022-06-20 | Japan | Aomori | 61500 | 108 | 0 | 40.781541 | 140.828896 | 2022-06-21 04:20:56 | Aomori, Japan | |||
2022-06-19 | Japan | Aomori | 61411 | 108 | 0 | 40.781541 | 140.828896 | 2022-06-20 04:21:01 | Aomori, Japan | |||
2022-06-18 | Japan | Aomori | 61234 | 108 | 0 | 40.781541 | 140.828896 | 2022-06-19 04:20:51 | Aomori, Japan | |||
2022-06-17 | Japan | Aomori | 60968 | 107 | 0 | 40.781541 | 140.828896 | 2022-06-18 04:21:10 | Aomori, Japan | |||
2022-06-16 | Japan | Aomori | 60734 | 107 | 0 | 40.781541 | 140.828896 | 2022-06-17 04:20:56 | Aomori, Japan | |||
2022-06-15 | Japan | Aomori | 60527 | 107 | 0 | 40.781541 | 140.828896 | 2022-06-16 04:20:55 | Aomori, Japan | |||
2022-06-14 | Japan | Aomori | 60297 | 107 | 0 | 40.781541 | 140.828896 | 2022-06-15 04:20:54 | Aomori, Japan | |||
2022-06-13 | Japan | Aomori | 60071 | 104 | 0 | 40.781541 | 140.828896 | 2022-06-14 04:20:52 | Aomori, Japan |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;