johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where province_or_state = "Shiga" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
deaths 179 ✖
- 1 73
- 104 73
- 9 43
- 11 29
- 8 28
- 90 27
- 219 26
- 221 22
- 7 19
- 102 17
- 61 16
- 95 16
- 103 15
- 4 13
- 213 13
- 97 11
- 93 9
- 94 9
- 99 9
- 33 8
- 47 8
- 51 8
- 59 8
- 105 8
- 217 8
- 222 8
- 106 7
- 54 6
- 79 6
- 98 6
- 188 6
- 204 6
- 16 5
- 48 5
- 67 5
- 96 5
- 100 5
- 223 5
- 225 5
- 3 4
- 39 4
- 44 4
- 56 4
- 58 4
- 74 4
- 82 4
- 83 4
- 88 4
- 200 4
- 307 4
- 2 3
- 5 3
- 13 3
- 19 3
- 26 3
- 40 3
- 69 3
- 75 3
- 81 3
- 91 3
- 92 3
- 117 3
- 120 3
- 134 3
- 192 3
- 210 3
- 234 3
- 284 3
- 289 3
- 300 3
- 6 2
- 12 2
- 14 2
- 18 2
- 20 2
- 27 2
- 30 2
- 35 2
- 43 2
- 46 2
- 52 2
- 60 2
- 68 2
- 89 2
- 110 2
- 111 2
- 112 2
- 115 2
- 118 2
- 131 2
- 165 2
- 183 2
- 185 2
- 190 2
- 191 2
- 196 2
- 199 2
- 224 2
- 228 2
- 233 2
- 252 2
- 256 2
- 259 2
- 271 2
- 287 2
- 297 2
- 306 2
- 10 1
- 15 1
- 17 1
- 25 1
- 28 1
- 29 1
- 31 1
- 42 1
- 45 1
- 49 1
- 55 1
- 63 1
- 64 1
- 72 1
- 76 1
- 80 1
- 84 1
- 85 1
- 86 1
- 87 1
- 101 1
- 108 1
- 122 1
- 124 1
- 125 1
- 129 1
- 133 1
- 135 1
- 137 1
- 141 1
- 146 1
- 150 1
- 152 1
- 154 1
- 158 1
- 159 1
- 161 1
- 166 1
- 168 1
- 172 1
- 176 1
- 179 1
- 182 1
- 194 1
- 197 1
- 205 1
- 211 1
- 214 1
- 216 1
- 220 1
- 231 1
- 232 1
- 235 1
- 236 1
- 237 1
- 241 1
- 244 1
- 248 1
- 257 1
- 263 1
- 267 1
- 269 1
- 275 1
- 277 1
- 283 1
- 285 1
- 286 1
- 292 1
- 294 1
- 295 1
- 302 1
- 303 1
province_or_state 1
- Shiga · 846 ✖
country_or_region 1
- Japan 846
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2016744 | 2016744 | 2022-09-20 | Japan | Shiga | 226735 | 307 | 0 | 35.215827 | 136.138064 | 2022-09-21 04:23:22 | Shiga, Japan | |||
3570617 | 3570617 | 2022-09-19 | Japan | Shiga | 226168 | 307 | 0 | 35.215827 | 136.138064 | 2022-09-20 04:22:48 | Shiga, Japan | |||
419356 | 419356 | 2022-09-18 | Japan | Shiga | 225646 | 307 | 0 | 35.215827 | 136.138064 | 2022-09-19 04:21:49 | Shiga, Japan | |||
3373380 | 3373380 | 2022-09-17 | Japan | Shiga | 224746 | 307 | 0 | 35.215827 | 136.138064 | 2022-09-18 04:22:50 | Shiga, Japan | |||
2355488 | 2355488 | 2022-09-16 | Japan | Shiga | 223787 | 306 | 0 | 35.215827 | 136.138064 | 2022-09-17 04:20:19 | Shiga, Japan | |||
3986645 | 3986645 | 2022-09-15 | Japan | Shiga | 222491 | 306 | 0 | 35.215827 | 136.138064 | 2022-09-16 04:21:19 | Shiga, Japan | |||
1889162 | 1889162 | 2022-09-14 | Japan | Shiga | 221557 | 303 | 0 | 35.215827 | 136.138064 | 2022-09-15 04:21:02 | Shiga, Japan | |||
372217 | 372217 | 2022-09-13 | Japan | Shiga | 220348 | 302 | 0 | 35.215827 | 136.138064 | 2022-09-14 04:20:44 | Shiga, Japan | |||
2394822 | 2394822 | 2022-09-12 | Japan | Shiga | 218929 | 300 | 0 | 35.215827 | 136.138064 | 2022-09-13 04:20:57 | Shiga, Japan | |||
3765900 | 3765900 | 2022-09-11 | Japan | Shiga | 218007 | 300 | 0 | 35.215827 | 136.138064 | 2022-09-12 04:20:58 | Shiga, Japan | |||
3824475 | 3824475 | 2022-09-10 | Japan | Shiga | 217211 | 300 | 0 | 35.215827 | 136.138064 | 2022-09-11 04:20:50 | Shiga, Japan | |||
962932 | 962932 | 2022-09-09 | Japan | Shiga | 215833 | 297 | 0 | 35.215827 | 136.138064 | 2022-09-10 04:21:10 | Shiga, Japan | |||
253334 | 253334 | 2022-09-08 | Japan | Shiga | 214430 | 297 | 0 | 35.215827 | 136.138064 | 2022-09-09 04:21:11 | Shiga, Japan | |||
3745132 | 3745132 | 2022-09-07 | Japan | Shiga | 212968 | 295 | 0 | 35.215827 | 136.138064 | 2022-09-08 04:21:02 | Shiga, Japan | |||
114772 | 114772 | 2022-09-06 | Japan | Shiga | 211198 | 294 | 0 | 35.215827 | 136.138064 | 2022-09-07 04:20:59 | Shiga, Japan | |||
2633744 | 2633744 | 2022-09-05 | Japan | Shiga | 209338 | 292 | 0 | 35.215827 | 136.138064 | 2022-09-06 04:21:02 | Shiga, Japan | |||
2987308 | 2987308 | 2022-09-04 | Japan | Shiga | 208480 | 289 | 0 | 35.215827 | 136.138064 | 2022-09-05 04:21:01 | Shiga, Japan | |||
2712993 | 2712993 | 2022-09-03 | Japan | Shiga | 207424 | 289 | 0 | 35.215827 | 136.138064 | 2022-09-04 04:21:22 | Shiga, Japan | |||
1393698 | 1393698 | 2022-09-02 | Japan | Shiga | 205865 | 289 | 0 | 35.215827 | 136.138064 | 2022-09-03 04:21:04 | Shiga, Japan | |||
3547527 | 3547527 | 2022-09-01 | Japan | Shiga | 204130 | 287 | 0 | 35.215827 | 136.138064 | 2022-09-02 04:21:07 | Shiga, Japan | |||
2343447 | 2343447 | 2022-08-31 | Japan | Shiga | 202219 | 287 | 0 | 35.215827 | 136.138064 | 2022-09-01 04:21:03 | Shiga, Japan | |||
3773927 | 3773927 | 2022-08-30 | Japan | Shiga | 200186 | 286 | 0 | 35.215827 | 136.138064 | 2022-08-31 04:20:57 | Shiga, Japan | |||
1680523 | 1680523 | 2022-08-29 | Japan | Shiga | 198162 | 285 | 0 | 35.215827 | 136.138064 | 2022-08-30 04:21:03 | Shiga, Japan | |||
1877007 | 1877007 | 2022-08-28 | Japan | Shiga | 196735 | 284 | 0 | 35.215827 | 136.138064 | 2022-08-29 04:21:06 | Shiga, Japan | |||
2096134 | 2096134 | 2022-08-27 | Japan | Shiga | 194774 | 284 | 0 | 35.215827 | 136.138064 | 2022-08-28 04:21:02 | Shiga, Japan | |||
1531949 | 1531949 | 2022-08-26 | Japan | Shiga | 192299 | 284 | 0 | 35.215827 | 136.138064 | 2022-08-27 04:20:57 | Shiga, Japan | |||
2828836 | 2828836 | 2022-08-25 | Japan | Shiga | 189556 | 283 | 0 | 35.215827 | 136.138064 | 2022-08-26 04:21:02 | Shiga, Japan | |||
2323369 | 2323369 | 2022-08-24 | Japan | Shiga | 187028 | 277 | 0 | 35.215827 | 136.138064 | 2022-08-25 04:21:13 | Shiga, Japan | |||
1250778 | 1250778 | 2022-08-23 | Japan | Shiga | 184009 | 275 | 0 | 35.215827 | 136.138064 | 2022-08-24 04:20:46 | Shiga, Japan | |||
2852882 | 2852882 | 2022-08-22 | Japan | Shiga | 181345 | 271 | 0 | 35.215827 | 136.138064 | 2022-08-23 04:20:56 | Shiga, Japan | |||
2402854 | 2402854 | 2022-08-21 | Japan | Shiga | 179254 | 271 | 0 | 35.215827 | 136.138064 | 2022-08-22 04:20:38 | Shiga, Japan | |||
3797932 | 3797932 | 2022-08-20 | Japan | Shiga | 176741 | 269 | 0 | 35.215827 | 136.138064 | 2022-08-21 04:20:44 | Shiga, Japan | |||
2363518 | 2363518 | 2022-08-19 | Japan | Shiga | 173869 | 267 | 0 | 35.215827 | 136.138064 | 2022-08-20 04:21:01 | Shiga, Japan | |||
1161189 | 1161189 | 2022-08-18 | Japan | Shiga | 170588 | 263 | 0 | 35.215827 | 136.138064 | 2022-08-19 04:20:54 | Shiga, Japan | |||
3950513 | 3950513 | 2022-08-17 | Japan | Shiga | 168245 | 259 | 0 | 35.215827 | 136.138064 | 2022-08-18 04:21:11 | Shiga, Japan | |||
991015 | 991015 | 2022-08-16 | Japan | Shiga | 166097 | 259 | 0 | 35.215827 | 136.138064 | 2022-08-17 04:20:59 | Shiga, Japan | |||
2494054 | 2494054 | 2022-08-15 | Japan | Shiga | 164389 | 257 | 0 | 35.215827 | 136.138064 | 2022-08-16 04:20:58 | Shiga, Japan | |||
3647604 | 3647604 | 2022-08-14 | Japan | Shiga | 162561 | 256 | 0 | 35.215827 | 136.138064 | 2022-08-15 04:20:59 | Shiga, Japan | |||
1968610 | 1968610 | 2022-08-13 | Japan | Shiga | 160396 | 256 | 0 | 35.215827 | 136.138064 | 2022-08-14 04:20:55 | Shiga, Japan | |||
2888419 | 2888419 | 2022-08-12 | Japan | Shiga | 157729 | 252 | 0 | 35.215827 | 136.138064 | 2022-08-13 04:20:52 | Shiga, Japan | |||
3908024 | 3908024 | 2022-08-11 | Japan | Shiga | 155660 | 252 | 0 | 35.215827 | 136.138064 | 2022-08-12 04:20:54 | Shiga, Japan | |||
1346341 | 1346341 | 2022-08-10 | Japan | Shiga | 152748 | 248 | 0 | 35.215827 | 136.138064 | 2022-08-11 04:20:49 | Shiga, Japan | |||
1086096 | 1086096 | 2022-08-09 | Japan | Shiga | 150170 | 244 | 0 | 35.215827 | 136.138064 | 2022-08-10 04:20:57 | Shiga, Japan | |||
3543511 | 3543511 | 2022-08-08 | Japan | Shiga | 147985 | 241 | 0 | 35.215827 | 136.138064 | 2022-08-09 04:20:34 | Shiga, Japan | |||
1069914 | 1069914 | 2022-08-07 | Japan | Shiga | 145960 | 237 | 0 | 35.215827 | 136.138064 | 2022-08-08 04:21:08 | Shiga, Japan | |||
1940502 | 1940502 | 2022-08-06 | Japan | Shiga | 143689 | 236 | 0 | 35.215827 | 136.138064 | 2022-08-07 04:20:54 | Shiga, Japan | |||
880301 | 880301 | 2022-08-05 | Japan | Shiga | 141034 | 235 | 0 | 35.215827 | 136.138064 | 2022-08-06 04:20:56 | Shiga, Japan | |||
2008712 | 2008712 | 2022-08-04 | Japan | Shiga | 138138 | 234 | 0 | 35.215827 | 136.138064 | 2022-08-05 04:20:52 | Shiga, Japan | |||
1098139 | 1098139 | 2022-08-03 | Japan | Shiga | 135412 | 234 | 0 | 35.215827 | 136.138064 | 2022-08-04 04:20:58 | Shiga, Japan | |||
1405064 | 1405064 | 2022-08-02 | Japan | Shiga | 133174 | 234 | 0 | 35.215827 | 136.138064 | 2022-08-03 04:20:59 | Shiga, Japan | |||
3617102 | 3617102 | 2022-08-01 | Japan | Shiga | 130177 | 233 | 0 | 35.215827 | 136.138064 | 2022-08-02 04:20:53 | Shiga, Japan | |||
3871582 | 3871582 | 2022-07-31 | Japan | Shiga | 128047 | 233 | 0 | 35.215827 | 136.138064 | 2022-08-01 04:21:03 | Shiga, Japan | |||
674336 | 674336 | 2022-07-30 | Japan | Shiga | 125409 | 232 | 0 | 35.215827 | 136.138064 | 2022-07-31 04:21:02 | Shiga, Japan | |||
1783535 | 1783535 | 2022-07-29 | Japan | Shiga | 123228 | 231 | 0 | 35.215827 | 136.138064 | 2022-07-30 04:20:42 | Shiga, Japan | |||
1065898 | 1065898 | 2022-07-28 | Japan | Shiga | 120926 | 228 | 0 | 35.215827 | 136.138064 | 2022-07-29 04:20:45 | Shiga, Japan | |||
2335417 | 2335417 | 2022-07-27 | Japan | Shiga | 118722 | 228 | 0 | 35.215827 | 136.138064 | 2022-07-28 04:20:56 | Shiga, Japan | |||
1487607 | 1487607 | 2022-07-26 | Japan | Shiga | 116527 | 225 | 0 | 35.215827 | 136.138064 | 2022-07-27 04:21:04 | Shiga, Japan | |||
2594053 | 2594053 | 2022-07-25 | Japan | Shiga | 114864 | 225 | 0 | 35.215827 | 136.138064 | 2022-07-26 04:20:58 | Shiga, Japan | |||
896168 | 896168 | 2022-07-24 | Japan | Shiga | 113574 | 225 | 0 | 35.215827 | 136.138064 | 2022-07-25 04:20:51 | Shiga, Japan | |||
91162 | 91162 | 2022-07-23 | Japan | Shiga | 112068 | 225 | 0 | 35.215827 | 136.138064 | 2022-07-24 04:20:47 | Shiga, Japan | |||
900184 | 900184 | 2022-07-22 | Japan | Shiga | 110825 | 225 | 0 | 35.215827 | 136.138064 | 2022-07-23 04:20:53 | Shiga, Japan | |||
670320 | 670320 | 2022-07-21 | Japan | Shiga | 109065 | 224 | 0 | 35.215827 | 136.138064 | 2022-07-22 04:21:15 | Shiga, Japan | |||
1608283 | 1608283 | 2022-07-20 | Japan | Shiga | 107754 | 224 | 0 | 35.215827 | 136.138064 | 2022-07-21 04:21:10 | Shiga, Japan | |||
958916 | 958916 | 2022-07-19 | Japan | Shiga | 106388 | 223 | 0 | 35.215827 | 136.138064 | 2022-07-20 04:20:59 | Shiga, Japan | |||
3210303 | 3210303 | 2022-07-18 | Japan | Shiga | 105512 | 223 | 0 | 35.215827 | 136.138064 | 2022-07-19 04:20:58 | Shiga, Japan | |||
3405478 | 3405478 | 2022-07-17 | Japan | Shiga | 104458 | 223 | 0 | 35.215827 | 136.138064 | 2022-07-18 04:20:59 | Shiga, Japan | |||
2151678 | 2151678 | 2022-07-16 | Japan | Shiga | 103467 | 223 | 0 | 35.215827 | 136.138064 | 2022-07-17 04:21:15 | Shiga, Japan | |||
2418911 | 2418911 | 2022-07-15 | Japan | Shiga | 102726 | 223 | 0 | 35.215827 | 136.138064 | 2022-07-16 04:21:05 | Shiga, Japan | |||
3428986 | 3428986 | 2022-07-14 | Japan | Shiga | 101736 | 222 | 0 | 35.215827 | 136.138064 | 2022-07-15 04:20:53 | Shiga, Japan | |||
3109506 | 3109506 | 2022-07-13 | Japan | Shiga | 100680 | 222 | 0 | 35.215827 | 136.138064 | 2022-07-14 04:20:57 | Shiga, Japan | |||
629929 | 629929 | 2022-07-12 | Japan | Shiga | 99949 | 222 | 0 | 35.215827 | 136.138064 | 2022-07-13 04:20:58 | Shiga, Japan | |||
1211573 | 1211573 | 2022-07-11 | Japan | Shiga | 99209 | 222 | 0 | 35.215827 | 136.138064 | 2022-07-12 04:20:51 | Shiga, Japan | |||
2789055 | 2789055 | 2022-07-10 | Japan | Shiga | 98401 | 222 | 0 | 35.215827 | 136.138064 | 2022-07-11 04:20:46 | Shiga, Japan | |||
142008 | 142008 | 2022-07-09 | Japan | Shiga | 98000 | 222 | 0 | 35.215827 | 136.138064 | 2022-07-10 04:20:54 | Shiga, Japan | |||
1417108 | 1417108 | 2022-07-08 | Japan | Shiga | 97648 | 222 | 0 | 35.215827 | 136.138064 | 2022-07-09 04:20:59 | Shiga, Japan | |||
2741033 | 2741033 | 2022-07-07 | Japan | Shiga | 97315 | 222 | 0 | 35.215827 | 136.138064 | 2022-07-08 04:20:56 | Shiga, Japan | |||
1199828 | 1199828 | 2022-07-06 | Japan | Shiga | 96911 | 221 | 0 | 35.215827 | 136.138064 | 2022-07-07 04:20:55 | Shiga, Japan | |||
3966571 | 3966571 | 2022-07-05 | Japan | Shiga | 96515 | 221 | 0 | 35.215827 | 136.138064 | 2022-07-06 04:20:58 | Shiga, Japan | |||
3078082 | 3078082 | 2022-07-04 | Japan | Shiga | 96152 | 221 | 0 | 35.215827 | 136.138064 | 2022-07-05 04:20:45 | Shiga, Japan | |||
1767364 | 1767364 | 2022-07-03 | Japan | Shiga | 95978 | 221 | 0 | 35.215827 | 136.138064 | 2022-07-04 04:20:54 | Shiga, Japan | |||
3365350 | 3365350 | 2022-07-02 | Japan | Shiga | 95853 | 221 | 0 | 35.215827 | 136.138064 | 2022-07-03 04:20:59 | Shiga, Japan | |||
593679 | 593679 | 2022-07-01 | Japan | Shiga | 95581 | 221 | 0 | 35.215827 | 136.138064 | 2022-07-02 04:21:16 | Shiga, Japan | |||
3940080 | 3940080 | 2022-06-30 | Japan | Shiga | 95429 | 221 | 0 | 35.215827 | 136.138064 | 2022-07-01 04:21:10 | Shiga, Japan | |||
2490038 | 2490038 | 2022-06-29 | Japan | Shiga | 95229 | 221 | 0 | 35.215827 | 136.138064 | 2022-06-30 04:21:01 | Shiga, Japan | |||
2239420 | 2239420 | 2022-06-28 | Japan | Shiga | 95018 | 221 | 0 | 35.215827 | 136.138064 | 2022-06-29 04:20:59 | Shiga, Japan | |||
2147662 | 2147662 | 2022-06-27 | Japan | Shiga | 94870 | 221 | 0 | 35.215827 | 136.138064 | 2022-06-28 04:20:58 | Shiga, Japan | |||
475463 | 475463 | 2022-06-26 | Japan | Shiga | 94794 | 221 | 0 | 35.215827 | 136.138064 | 2022-06-27 04:21:00 | Shiga, Japan | |||
938838 | 938838 | 2022-06-25 | Japan | Shiga | 94679 | 221 | 0 | 35.215827 | 136.138064 | 2022-06-26 04:21:02 | Shiga, Japan | |||
3346658 | 3346658 | 2022-06-24 | Japan | Shiga | 94509 | 221 | 0 | 35.215827 | 136.138064 | 2022-06-25 04:20:57 | Shiga, Japan | |||
1648399 | 1648399 | 2022-06-23 | Japan | Shiga | 94330 | 221 | 0 | 35.215827 | 136.138064 | 2022-06-24 04:20:58 | Shiga, Japan | |||
2187634 | 2187634 | 2022-06-22 | Japan | Shiga | 94173 | 221 | 0 | 35.215827 | 136.138064 | 2022-06-23 04:20:55 | Shiga, Japan | |||
166065 | 166065 | 2022-06-21 | Japan | Shiga | 93972 | 221 | 0 | 35.215827 | 136.138064 | 2022-06-22 04:20:54 | Shiga, Japan | |||
1763348 | 1763348 | 2022-06-20 | Japan | Shiga | 93806 | 221 | 0 | 35.215827 | 136.138064 | 2022-06-21 04:20:56 | Shiga, Japan | |||
3269534 | 3269534 | 2022-06-19 | Japan | Shiga | 93721 | 221 | 0 | 35.215827 | 136.138064 | 2022-06-20 04:21:01 | Shiga, Japan | |||
3397446 | 3397446 | 2022-06-18 | Japan | Shiga | 93559 | 221 | 0 | 35.215827 | 136.138064 | 2022-06-19 04:20:51 | Shiga, Japan | |||
2311323 | 2311323 | 2022-06-17 | Japan | Shiga | 93413 | 221 | 0 | 35.215827 | 136.138064 | 2022-06-18 04:21:10 | Shiga, Japan | |||
558827 | 558827 | 2022-06-16 | Japan | Shiga | 93261 | 221 | 0 | 35.215827 | 136.138064 | 2022-06-17 04:20:56 | Shiga, Japan | |||
3982629 | 3982629 | 2022-06-15 | Japan | Shiga | 93093 | 221 | 0 | 35.215827 | 136.138064 | 2022-06-16 04:20:55 | Shiga, Japan | |||
946870 | 946870 | 2022-06-14 | Japan | Shiga | 92941 | 220 | 0 | 35.215827 | 136.138064 | 2022-06-15 04:20:54 | Shiga, Japan | |||
2979278 | 2979278 | 2022-06-13 | Japan | Shiga | 92739 | 219 | 0 | 35.215827 | 136.138064 | 2022-06-14 04:20:52 | Shiga, 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]);