johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where province_or_state = "Aomori" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2016710 | 2016710 | 2022-09-20 | Japan | Aomori | 159589 | 288 | 0 | 40.781541 | 140.828896 | 2022-09-21 04:23:22 | Aomori, Japan | |||
3570583 | 3570583 | 2022-09-19 | Japan | Aomori | 159367 | 288 | 0 | 40.781541 | 140.828896 | 2022-09-20 04:22:48 | Aomori, Japan | |||
419322 | 419322 | 2022-09-18 | Japan | Aomori | 159064 | 287 | 0 | 40.781541 | 140.828896 | 2022-09-19 04:21:49 | Aomori, Japan | |||
3373346 | 3373346 | 2022-09-17 | Japan | Aomori | 158591 | 285 | 0 | 40.781541 | 140.828896 | 2022-09-18 04:22:50 | Aomori, Japan | |||
2355454 | 2355454 | 2022-09-16 | Japan | Aomori | 158060 | 279 | 0 | 40.781541 | 140.828896 | 2022-09-17 04:20:19 | Aomori, Japan | |||
3986611 | 3986611 | 2022-09-15 | Japan | Aomori | 157499 | 277 | 0 | 40.781541 | 140.828896 | 2022-09-16 04:21:19 | Aomori, Japan | |||
1889128 | 1889128 | 2022-09-14 | Japan | Aomori | 156908 | 273 | 0 | 40.781541 | 140.828896 | 2022-09-15 04:21:02 | Aomori, Japan | |||
372183 | 372183 | 2022-09-13 | Japan | Aomori | 156072 | 272 | 0 | 40.781541 | 140.828896 | 2022-09-14 04:20:44 | Aomori, Japan | |||
2394788 | 2394788 | 2022-09-12 | Japan | Aomori | 155604 | 268 | 0 | 40.781541 | 140.828896 | 2022-09-13 04:20:57 | Aomori, Japan | |||
3765866 | 3765866 | 2022-09-11 | Japan | Aomori | 155116 | 266 | 0 | 40.781541 | 140.828896 | 2022-09-12 04:20:58 | Aomori, Japan | |||
3824441 | 3824441 | 2022-09-10 | Japan | Aomori | 154322 | 264 | 0 | 40.781541 | 140.828896 | 2022-09-11 04:20:50 | Aomori, Japan | |||
962898 | 962898 | 2022-09-09 | Japan | Aomori | 153425 | 262 | 0 | 40.781541 | 140.828896 | 2022-09-10 04:21:10 | Aomori, Japan | |||
253300 | 253300 | 2022-09-08 | Japan | Aomori | 152406 | 260 | 0 | 40.781541 | 140.828896 | 2022-09-09 04:21:11 | Aomori, Japan | |||
3745098 | 3745098 | 2022-09-07 | Japan | Aomori | 151203 | 259 | 0 | 40.781541 | 140.828896 | 2022-09-08 04:21:02 | Aomori, Japan | |||
114738 | 114738 | 2022-09-06 | Japan | Aomori | 149580 | 255 | 0 | 40.781541 | 140.828896 | 2022-09-07 04:20:59 | Aomori, Japan | |||
2633710 | 2633710 | 2022-09-05 | Japan | Aomori | 148867 | 255 | 0 | 40.781541 | 140.828896 | 2022-09-06 04:21:02 | Aomori, Japan | |||
2987274 | 2987274 | 2022-09-04 | Japan | Aomori | 147947 | 252 | 0 | 40.781541 | 140.828896 | 2022-09-05 04:21:01 | Aomori, Japan | |||
2712959 | 2712959 | 2022-09-03 | Japan | Aomori | 146578 | 245 | 0 | 40.781541 | 140.828896 | 2022-09-04 04:21:22 | Aomori, Japan | |||
1393664 | 1393664 | 2022-09-02 | Japan | Aomori | 145141 | 234 | 0 | 40.781541 | 140.828896 | 2022-09-03 04:21:04 | Aomori, Japan | |||
3547493 | 3547493 | 2022-09-01 | Japan | Aomori | 143529 | 232 | 0 | 40.781541 | 140.828896 | 2022-09-02 04:21:07 | Aomori, Japan | |||
2343413 | 2343413 | 2022-08-31 | Japan | Aomori | 141500 | 222 | 0 | 40.781541 | 140.828896 | 2022-09-01 04:21:03 | Aomori, Japan | |||
3773893 | 3773893 | 2022-08-30 | Japan | Aomori | 139556 | 211 | 0 | 40.781541 | 140.828896 | 2022-08-31 04:20:57 | Aomori, Japan | |||
1680489 | 1680489 | 2022-08-29 | Japan | Aomori | 138297 | 210 | 0 | 40.781541 | 140.828896 | 2022-08-30 04:21:03 | Aomori, Japan | |||
1876973 | 1876973 | 2022-08-28 | Japan | Aomori | 136985 | 206 | 0 | 40.781541 | 140.828896 | 2022-08-29 04:21:06 | Aomori, Japan | |||
2096100 | 2096100 | 2022-08-27 | Japan | Aomori | 135175 | 203 | 0 | 40.781541 | 140.828896 | 2022-08-28 04:21:02 | Aomori, Japan | |||
1531915 | 1531915 | 2022-08-26 | Japan | Aomori | 132982 | 195 | 0 | 40.781541 | 140.828896 | 2022-08-27 04:20:57 | Aomori, Japan | |||
2828802 | 2828802 | 2022-08-25 | Japan | Aomori | 130658 | 192 | 0 | 40.781541 | 140.828896 | 2022-08-26 04:21:02 | Aomori, Japan | |||
2323335 | 2323335 | 2022-08-24 | Japan | Aomori | 127860 | 186 | 0 | 40.781541 | 140.828896 | 2022-08-25 04:21:13 | Aomori, Japan | |||
1250744 | 1250744 | 2022-08-23 | Japan | Aomori | 125831 | 184 | 0 | 40.781541 | 140.828896 | 2022-08-24 04:20:46 | Aomori, Japan | |||
2852848 | 2852848 | 2022-08-22 | Japan | Aomori | 124888 | 179 | 0 | 40.781541 | 140.828896 | 2022-08-23 04:20:56 | Aomori, Japan | |||
2402820 | 2402820 | 2022-08-21 | Japan | Aomori | 123594 | 176 | 0 | 40.781541 | 140.828896 | 2022-08-22 04:20:38 | Aomori, Japan | |||
3797898 | 3797898 | 2022-08-20 | Japan | Aomori | 121740 | 173 | 0 | 40.781541 | 140.828896 | 2022-08-21 04:20:44 | Aomori, Japan | |||
2363484 | 2363484 | 2022-08-19 | Japan | Aomori | 119400 | 167 | 0 | 40.781541 | 140.828896 | 2022-08-20 04:21:01 | Aomori, Japan | |||
1161155 | 1161155 | 2022-08-18 | Japan | Aomori | 117029 | 167 | 0 | 40.781541 | 140.828896 | 2022-08-19 04:20:54 | Aomori, Japan | |||
3950479 | 3950479 | 2022-08-17 | Japan | Aomori | 114991 | 166 | 0 | 40.781541 | 140.828896 | 2022-08-18 04:21:11 | Aomori, Japan | |||
990981 | 990981 | 2022-08-16 | Japan | Aomori | 113049 | 164 | 0 | 40.781541 | 140.828896 | 2022-08-17 04:20:59 | Aomori, Japan | |||
2494020 | 2494020 | 2022-08-15 | Japan | Aomori | 111819 | 161 | 0 | 40.781541 | 140.828896 | 2022-08-16 04:20:58 | Aomori, Japan | |||
3647570 | 3647570 | 2022-08-14 | Japan | Aomori | 111007 | 158 | 0 | 40.781541 | 140.828896 | 2022-08-15 04:20:59 | Aomori, Japan | |||
1968576 | 1968576 | 2022-08-13 | Japan | Aomori | 109503 | 157 | 0 | 40.781541 | 140.828896 | 2022-08-14 04:20:55 | Aomori, Japan | |||
2888385 | 2888385 | 2022-08-12 | Japan | Aomori | 108053 | 154 | 0 | 40.781541 | 140.828896 | 2022-08-13 04:20:52 | Aomori, Japan | |||
3907990 | 3907990 | 2022-08-11 | Japan | Aomori | 106653 | 153 | 0 | 40.781541 | 140.828896 | 2022-08-12 04:20:54 | Aomori, Japan | |||
1346307 | 1346307 | 2022-08-10 | Japan | Aomori | 104944 | 152 | 0 | 40.781541 | 140.828896 | 2022-08-11 04:20:49 | Aomori, Japan | |||
1086062 | 1086062 | 2022-08-09 | Japan | Aomori | 102885 | 152 | 0 | 40.781541 | 140.828896 | 2022-08-10 04:20:57 | Aomori, Japan | |||
3543477 | 3543477 | 2022-08-08 | Japan | Aomori | 101852 | 150 | 0 | 40.781541 | 140.828896 | 2022-08-09 04:20:34 | Aomori, Japan | |||
1069880 | 1069880 | 2022-08-07 | Japan | Aomori | 100777 | 150 | 0 | 40.781541 | 140.828896 | 2022-08-08 04:21:08 | Aomori, Japan | |||
1940468 | 1940468 | 2022-08-06 | Japan | Aomori | 99529 | 149 | 0 | 40.781541 | 140.828896 | 2022-08-07 04:20:54 | Aomori, Japan | |||
880267 | 880267 | 2022-08-05 | Japan | Aomori | 97997 | 149 | 0 | 40.781541 | 140.828896 | 2022-08-06 04:20:56 | Aomori, Japan | |||
2008678 | 2008678 | 2022-08-04 | Japan | Aomori | 96503 | 147 | 0 | 40.781541 | 140.828896 | 2022-08-05 04:20:52 | Aomori, Japan | |||
1098105 | 1098105 | 2022-08-03 | Japan | Aomori | 95058 | 145 | 0 | 40.781541 | 140.828896 | 2022-08-04 04:20:58 | Aomori, Japan | |||
1405030 | 1405030 | 2022-08-02 | Japan | Aomori | 93735 | 142 | 0 | 40.781541 | 140.828896 | 2022-08-03 04:20:59 | Aomori, Japan | |||
3617068 | 3617068 | 2022-08-01 | Japan | Aomori | 92161 | 142 | 0 | 40.781541 | 140.828896 | 2022-08-02 04:20:53 | Aomori, Japan | |||
3871548 | 3871548 | 2022-07-31 | Japan | Aomori | 91280 | 139 | 0 | 40.781541 | 140.828896 | 2022-08-01 04:21:03 | Aomori, Japan | |||
674302 | 674302 | 2022-07-30 | Japan | Aomori | 90114 | 139 | 0 | 40.781541 | 140.828896 | 2022-07-31 04:21:02 | Aomori, Japan | |||
1783501 | 1783501 | 2022-07-29 | Japan | Aomori | 88594 | 138 | 0 | 40.781541 | 140.828896 | 2022-07-30 04:20:42 | Aomori, Japan | |||
1065864 | 1065864 | 2022-07-28 | Japan | Aomori | 87123 | 137 | 0 | 40.781541 | 140.828896 | 2022-07-29 04:20:45 | Aomori, Japan | |||
2335383 | 2335383 | 2022-07-27 | Japan | Aomori | 85554 | 136 | 0 | 40.781541 | 140.828896 | 2022-07-28 04:20:56 | Aomori, Japan | |||
1487573 | 1487573 | 2022-07-26 | Japan | Aomori | 84045 | 131 | 0 | 40.781541 | 140.828896 | 2022-07-27 04:21:04 | Aomori, Japan | |||
2594019 | 2594019 | 2022-07-25 | Japan | Aomori | 82536 | 127 | 0 | 40.781541 | 140.828896 | 2022-07-26 04:20:58 | Aomori, Japan | |||
896134 | 896134 | 2022-07-24 | Japan | Aomori | 81602 | 123 | 0 | 40.781541 | 140.828896 | 2022-07-25 04:20:51 | Aomori, Japan | |||
91128 | 91128 | 2022-07-23 | Japan | Aomori | 80295 | 123 | 0 | 40.781541 | 140.828896 | 2022-07-24 04:20:47 | Aomori, Japan | |||
900150 | 900150 | 2022-07-22 | Japan | Aomori | 78710 | 122 | 0 | 40.781541 | 140.828896 | 2022-07-23 04:20:53 | Aomori, Japan | |||
670286 | 670286 | 2022-07-21 | Japan | Aomori | 77091 | 122 | 0 | 40.781541 | 140.828896 | 2022-07-22 04:21:15 | Aomori, Japan | |||
1608249 | 1608249 | 2022-07-20 | Japan | Aomori | 75514 | 122 | 0 | 40.781541 | 140.828896 | 2022-07-21 04:21:10 | Aomori, Japan | |||
958882 | 958882 | 2022-07-19 | Japan | Aomori | 74079 | 121 | 0 | 40.781541 | 140.828896 | 2022-07-20 04:20:59 | Aomori, Japan | |||
3210269 | 3210269 | 2022-07-18 | Japan | Aomori | 73383 | 121 | 0 | 40.781541 | 140.828896 | 2022-07-19 04:20:58 | Aomori, Japan | |||
3405444 | 3405444 | 2022-07-17 | Japan | Aomori | 72604 | 118 | 0 | 40.781541 | 140.828896 | 2022-07-18 04:20:59 | Aomori, Japan | |||
2151644 | 2151644 | 2022-07-16 | Japan | Aomori | 71784 | 118 | 0 | 40.781541 | 140.828896 | 2022-07-17 04:21:15 | Aomori, Japan | |||
2418877 | 2418877 | 2022-07-15 | Japan | Aomori | 70810 | 118 | 0 | 40.781541 | 140.828896 | 2022-07-16 04:21:05 | Aomori, Japan | |||
3428952 | 3428952 | 2022-07-14 | Japan | Aomori | 69890 | 117 | 0 | 40.781541 | 140.828896 | 2022-07-15 04:20:53 | Aomori, Japan | |||
3109472 | 3109472 | 2022-07-13 | Japan | Aomori | 68979 | 117 | 0 | 40.781541 | 140.828896 | 2022-07-14 04:20:57 | Aomori, Japan | |||
629895 | 629895 | 2022-07-12 | Japan | Aomori | 68279 | 117 | 0 | 40.781541 | 140.828896 | 2022-07-13 04:20:58 | Aomori, Japan | |||
1211539 | 1211539 | 2022-07-11 | Japan | Aomori | 67580 | 117 | 0 | 40.781541 | 140.828896 | 2022-07-12 04:20:51 | Aomori, Japan | |||
2789021 | 2789021 | 2022-07-10 | Japan | Aomori | 67141 | 117 | 0 | 40.781541 | 140.828896 | 2022-07-11 04:20:46 | Aomori, Japan | |||
141974 | 141974 | 2022-07-09 | Japan | Aomori | 66723 | 116 | 0 | 40.781541 | 140.828896 | 2022-07-10 04:20:54 | Aomori, Japan | |||
1417074 | 1417074 | 2022-07-08 | Japan | Aomori | 66224 | 116 | 0 | 40.781541 | 140.828896 | 2022-07-09 04:20:59 | Aomori, Japan | |||
2740999 | 2740999 | 2022-07-07 | Japan | Aomori | 65954 | 116 | 0 | 40.781541 | 140.828896 | 2022-07-08 04:20:56 | Aomori, Japan | |||
1199794 | 1199794 | 2022-07-06 | Japan | Aomori | 65504 | 115 | 0 | 40.781541 | 140.828896 | 2022-07-07 04:20:55 | Aomori, Japan | |||
3966537 | 3966537 | 2022-07-05 | Japan | Aomori | 65114 | 115 | 0 | 40.781541 | 140.828896 | 2022-07-06 04:20:58 | Aomori, Japan | |||
3078048 | 3078048 | 2022-07-04 | Japan | Aomori | 64809 | 114 | 0 | 40.781541 | 140.828896 | 2022-07-05 04:20:45 | Aomori, Japan | |||
1767330 | 1767330 | 2022-07-03 | Japan | Aomori | 64597 | 114 | 0 | 40.781541 | 140.828896 | 2022-07-04 04:20:54 | Aomori, Japan | |||
3365316 | 3365316 | 2022-07-02 | Japan | Aomori | 64364 | 114 | 0 | 40.781541 | 140.828896 | 2022-07-03 04:20:59 | Aomori, Japan | |||
593645 | 593645 | 2022-07-01 | Japan | Aomori | 64089 | 113 | 0 | 40.781541 | 140.828896 | 2022-07-02 04:21:16 | Aomori, Japan | |||
3940046 | 3940046 | 2022-06-30 | Japan | Aomori | 63834 | 112 | 0 | 40.781541 | 140.828896 | 2022-07-01 04:21:10 | Aomori, Japan | |||
2490004 | 2490004 | 2022-06-29 | Japan | Aomori | 63594 | 112 | 0 | 40.781541 | 140.828896 | 2022-06-30 04:21:01 | Aomori, Japan | |||
2239386 | 2239386 | 2022-06-28 | Japan | Aomori | 63321 | 112 | 0 | 40.781541 | 140.828896 | 2022-06-29 04:20:59 | Aomori, Japan | |||
2147628 | 2147628 | 2022-06-27 | Japan | Aomori | 63098 | 112 | 0 | 40.781541 | 140.828896 | 2022-06-28 04:20:58 | Aomori, Japan | |||
475429 | 475429 | 2022-06-26 | Japan | Aomori | 62947 | 110 | 0 | 40.781541 | 140.828896 | 2022-06-27 04:21:00 | Aomori, Japan | |||
938804 | 938804 | 2022-06-25 | Japan | Aomori | 62792 | 110 | 0 | 40.781541 | 140.828896 | 2022-06-26 04:21:02 | Aomori, Japan | |||
3346624 | 3346624 | 2022-06-24 | Japan | Aomori | 62520 | 109 | 0 | 40.781541 | 140.828896 | 2022-06-25 04:20:57 | Aomori, Japan | |||
1648365 | 1648365 | 2022-06-23 | Japan | Aomori | 62246 | 109 | 0 | 40.781541 | 140.828896 | 2022-06-24 04:20:58 | Aomori, Japan | |||
2187600 | 2187600 | 2022-06-22 | Japan | Aomori | 62000 | 108 | 0 | 40.781541 | 140.828896 | 2022-06-23 04:20:55 | Aomori, Japan | |||
166031 | 166031 | 2022-06-21 | Japan | Aomori | 61724 | 108 | 0 | 40.781541 | 140.828896 | 2022-06-22 04:20:54 | Aomori, Japan | |||
1763314 | 1763314 | 2022-06-20 | Japan | Aomori | 61500 | 108 | 0 | 40.781541 | 140.828896 | 2022-06-21 04:20:56 | Aomori, Japan | |||
3269500 | 3269500 | 2022-06-19 | Japan | Aomori | 61411 | 108 | 0 | 40.781541 | 140.828896 | 2022-06-20 04:21:01 | Aomori, Japan | |||
3397412 | 3397412 | 2022-06-18 | Japan | Aomori | 61234 | 108 | 0 | 40.781541 | 140.828896 | 2022-06-19 04:20:51 | Aomori, Japan | |||
2311289 | 2311289 | 2022-06-17 | Japan | Aomori | 60968 | 107 | 0 | 40.781541 | 140.828896 | 2022-06-18 04:21:10 | Aomori, Japan | |||
558793 | 558793 | 2022-06-16 | Japan | Aomori | 60734 | 107 | 0 | 40.781541 | 140.828896 | 2022-06-17 04:20:56 | Aomori, Japan | |||
3982595 | 3982595 | 2022-06-15 | Japan | Aomori | 60527 | 107 | 0 | 40.781541 | 140.828896 | 2022-06-16 04:20:55 | Aomori, Japan | |||
946836 | 946836 | 2022-06-14 | Japan | Aomori | 60297 | 107 | 0 | 40.781541 | 140.828896 | 2022-06-15 04:20:54 | Aomori, Japan | |||
2979244 | 2979244 | 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 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]);