johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,073 rows where province_or_state = "Scotland" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, deaths, day (date), last_update (date)
active 416 ✖
- 0 81
- 16635 3
- 13322 2
- 16063 2
- 16536 2
- 100237 1
- 101261 1
- 102059 1
- 102793 1
- 103614 1
- 104265 1
- 105093 1
- 105801 1
- 106332 1
- 107263 1
- 108767 1
- 110040 1
- 111183 1
- 112454 1
- 113619 1
- 114768 1
- 115508 1
- 116475 1
- 118319 1
- 120321 1
- 122875 1
- 125414 1
- 127551 1
- 130015 1
- 131920 1
- 13239 1
- 13248 1
- 13249 1
- 13256 1
- 13259 1
- 13270 1
- 13278 1
- 13287 1
- 13288 1
- 13302 1
- 13308 1
- 13312 1
- 13325 1
- 13326 1
- 13332 1
- 13333 1
- 13336 1
- 13340 1
- 13342 1
- 13361 1
- 134394 1
- 136365 1
- 138936 1
- 141152 1
- 142924 1
- 144798 1
- 146579 1
- 148400 1
- 150270 1
- 151913 1
- 154012 1
- 155687 1
- 157028 1
- 15778 1
- 15789 1
- 15799 1
- 15808 1
- 15812 1
- 15814 1
- 15820 1
- 15843 1
- 158457 1
- 15850 1
- 15869 1
- 15875 1
- 15878 1
- 15883 1
- 15894 1
- 15910 1
- 15931 1
- 15954 1
- 159551 1
- 15961 1
- 15983 1
- 15993 1
- 16009 1
- 16029 1
- 16056 1
- 16060 1
- 16089 1
- 16106 1
- 161115 1
- 16136 1
- 16154 1
- 16185 1
- 16203 1
- 16226 1
- 162662 1
- 16290 1
- 16356 1
- 16399 1
- 164071 1
- 16459 1
- 16507 1
- 165302 1
- 166496 1
- 167244 1
- 16798 1
- 168206 1
- 16841 1
- 16867 1
- 16916 1
- 169444 1
- 16965 1
- 17042 1
- 170563 1
- 17113 1
- 171648 1
- 17236 1
- 172582 1
- 17319 1
- 173579 1
- 17385 1
- 17429 1
- 174421 1
- 17494 1
- 175110 1
- 17562 1
- 176000 1
- 17613 1
- 17701 1
- 177096 1
- 177930 1
- 17824 1
- 178777 1
- 179354 1
- 17984 1
- 180277 1
- 181041 1
- 18138 1
- 181794 1
- 182576 1
- 18293 1
- 183339 1
- 18393 1
- 184202 1
- 185101 1
- 18552 1
- 185660 1
- 186384 1
- 18693 1
- 187441 1
- 188069 1
- 188923 1
- 18901 1
- 189697 1
- 19047 1
- 190519 1
- 191234 1
- 191833 1
- 19220 1
- 192584 1
- 193322 1
- 19379 1
- 193876 1
- 194383 1
- 194953 1
- 195339 1
- 19540 1
- 195848 1
- 196184 1
- 196657 1
- 197144 1
- 19715 1
- 197687 1
- 198077 1
- 198577 1
- 199024 1
- 19936 1
- 199695 1
- 200264 1
- 200929 1
- 201560 1
- 20180 1
- 202042 1
- 202498 1
- 20250 1
- 203088 1
- 203701 1
- 204318 1
- 204965 1
- 20516 1
- 205445 1
- 205977 1
- 206336 1
- 206824 1
- 207513 1
- 20782 1
- 208027 1
- 208564 1
- 209121 1
- 209543 1
- 209895 1
- 210294 1
- 21072 1
- 210830 1
- 211222 1
- 211632 1
- 212029 1
- 212372 1
- 212620 1
- 21274 1
- 212879 1
- 213163 1
- 213526 1
- 213805 1
- 214082 1
- 214332 1
- 214531 1
- 214749 1
- 215024 1
- 215260 1
- 215621 1
- 215829 1
- 216040 1
- 21621 1
- 216272 1
- 216448 1
- 216722 1
- 216950 1
- 217204 1
- 217377 1
- 217552 1
- 217694 1
- 217826 1
- 218029 1
- 218202 1
- 218393 1
- 218567 1
- 21866 1
- 218713 1
- 218845 1
- 218984 1
- 219069 1
- 219352 1
- 219587 1
- 219811 1
- 220011 1
- 220179 1
- 220417 1
- 220762 1
- 221031 1
- 22121 1
- 221244 1
- 221657 1
- 221949 1
- 222110 1
- 222378 1
- 222772 1
- 223204 1
- 223618 1
- 223988 1
- 224366 1
- 224679 1
- 224995 1
- 22503 1
- 225541 1
- 226005 1
- 226644 1
- 227227 1
- 227753 1
- 228242 1
- 228720 1
- 229396 1
- 22987 1
- 230227 1
- 231217 1
- 232076 1
- 232851 1
- 233492 1
- 234187 1
- 23450 1
- 235197 1
- 235931 1
- 237035 1
- 238063 1
- 239099 1
- 239860 1
- 24008 1
- 240832 1
- 241960 1
- 243273 1
- 244221 1
- 245428 1
- 246633 1
- 24721 1
- 247883 1
- 250046 1
- 25064 1
- 25286 1
- 253010 1
- 256004 1
- 257749 1
- 260582 1
- 26092 1
- 263220 1
- 266505 1
- 26725 1
- 269622 1
- 273506 1
- 27390 1
- 277734 1
- 281553 1
- 28161 1
- 284658 1
- 287384 1
- 28921 1
- 289756 1
- 292113 1
- 295907 1
- 29679 1
- 298705 1
- 301915 1
- 30376 1
- 304098 1
- 306146 1
- 308280 1
- 310805 1
- 31174 1
- 313430 1
- 315497 1
- 317539 1
- 319852 1
- 321587 1
- 32227 1
- 323051 1
- 324642 1
- 326321 1
- 328124 1
- 329623 1
- 330919 1
- 332156 1
- 33249 1
- 333156 1
- 333396 1
- 334193 1
- 334780 1
- 336228 1
- 337237 1
- 338268 1
- 339062 1
- 340066 1
- 341321 1
- 34489 1
- 35492 1
- 36448 1
- 37409 1
- 38699 1
- 40113 1
- 41451 1
- 42638 1
- 43790 1
- 44106 1
- 45098 1
- 46539 1
- 48250 1
- 49945 1
- 51328 1
- 52750 1
- 54052 1
- 55173 1
- 56475 1
- 57649 1
- 58740 1
- 59993 1
- 61070 1
- 62212 1
- 63163 1
- 64134 1
- 65517 1
- 66694 1
- 67735 1
- 69292 1
- 70404 1
- 71315 1
- 72108 1
- 73305 1
- 74472 1
- 75773 1
- 76855 1
- 78014 1
- 78725 1
- 79936 1
- 81146 1
- 82185 1
- 83171 1
- 84021 1
- 84858 1
- 85807 1
- 86537 1
- 87373 1
- 88547 1
- 89479 1
- 90223 1
- 90967 1
- 91333 1
- 92052 1
- 92965 1
- 93872 1
- 94797 1
- 95552 1
- 96190 1
- 96866 1
- 97525 1
- 98383 1
- 99266 1
province_or_state 1
- Scotland · 1,073 ✖
country_or_region 1
- United Kingdom 1,073
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756576 | 2756576 | 2022-12-29 | United Kingdom | Scotland | 2136695 | 16187 | 0 | 56.4907 | -4.2026 | 2022-12-30 04:21:04 | Scotland, United Kingdom | |||
1077582 | 1077582 | 2022-12-28 | United Kingdom | Scotland | 2136695 | 16187 | 0 | 56.4907 | -4.2026 | 2022-12-29 04:21:01 | Scotland, United Kingdom | |||
331579 | 331579 | 2022-12-27 | United Kingdom | Scotland | 2136695 | 16187 | 0 | 56.4907 | -4.2026 | 2022-12-28 04:21:04 | Scotland, United Kingdom | |||
221652 | 221652 | 2022-12-26 | United Kingdom | Scotland | 2136695 | 16187 | 0 | 56.4907 | -4.2026 | 2022-12-27 04:21:07 | Scotland, United Kingdom | |||
3226109 | 3226109 | 2022-12-25 | United Kingdom | Scotland | 2136695 | 16187 | 0 | 56.4907 | -4.2026 | 2022-12-26 04:21:06 | Scotland, United Kingdom | |||
1022023 | 1022023 | 2022-12-24 | United Kingdom | Scotland | 2136695 | 16187 | 0 | 56.4907 | -4.2026 | 2022-12-25 04:21:04 | Scotland, United Kingdom | |||
694046 | 694046 | 2022-12-23 | United Kingdom | Scotland | 2136695 | 16187 | 0 | 56.4907 | -4.2026 | 2022-12-24 04:21:02 | Scotland, United Kingdom | |||
2183256 | 2183256 | 2022-12-22 | United Kingdom | Scotland | 2136695 | 16187 | 0 | 56.4907 | -4.2026 | 2022-12-23 04:21:04 | Scotland, United Kingdom | |||
455060 | 455060 | 2022-12-21 | United Kingdom | Scotland | 2133905 | 16187 | 0 | 56.4907 | -4.2026 | 2022-12-22 04:20:56 | Scotland, United Kingdom | |||
2955059 | 2955059 | 2022-12-20 | United Kingdom | Scotland | 2133905 | 16187 | 0 | 56.4907 | -4.2026 | 2022-12-21 04:21:03 | Scotland, United Kingdom | |||
3177461 | 3177461 | 2022-12-19 | United Kingdom | Scotland | 2133905 | 16187 | 0 | 56.4907 | -4.2026 | 2022-12-20 04:21:04 | Scotland, United Kingdom | |||
1631978 | 1631978 | 2022-12-18 | United Kingdom | Scotland | 2133905 | 16187 | 0 | 56.4907 | -4.2026 | 2022-12-19 04:21:03 | Scotland, United Kingdom | |||
507357 | 507357 | 2022-12-17 | United Kingdom | Scotland | 2133905 | 16187 | 0 | 56.4907 | -4.2026 | 2022-12-18 04:21:03 | Scotland, United Kingdom | |||
3327929 | 3327929 | 2022-12-16 | United Kingdom | Scotland | 2133905 | 16187 | 0 | 56.4907 | -4.2026 | 2022-12-17 04:21:04 | Scotland, United Kingdom | |||
546441 | 546441 | 2022-12-15 | United Kingdom | Scotland | 2133905 | 16187 | 0 | 56.4907 | -4.2026 | 2022-12-16 04:21:01 | Scotland, United Kingdom | |||
351969 | 351969 | 2022-12-14 | United Kingdom | Scotland | 2131615 | 16187 | 0 | 56.4907 | -4.2026 | 2022-12-15 04:20:58 | Scotland, United Kingdom | |||
311557 | 311557 | 2022-12-13 | United Kingdom | Scotland | 2131615 | 16187 | 0 | 56.4907 | -4.2026 | 2022-12-14 04:21:04 | Scotland, United Kingdom | |||
1152618 | 1152618 | 2022-12-12 | United Kingdom | Scotland | 2131615 | 16187 | 0 | 56.4907 | -4.2026 | 2022-12-13 04:21:01 | Scotland, United Kingdom | |||
872472 | 872472 | 2022-12-11 | United Kingdom | Scotland | 2131615 | 16187 | 0 | 56.4907 | -4.2026 | 2022-12-12 04:21:01 | Scotland, United Kingdom | |||
261002 | 261002 | 2022-12-10 | United Kingdom | Scotland | 2131615 | 16187 | 0 | 56.4907 | -4.2026 | 2022-12-11 04:20:50 | Scotland, United Kingdom | |||
3939716 | 3939716 | 2022-12-09 | United Kingdom | Scotland | 2131615 | 16187 | 0 | 56.4907 | -4.2026 | 2022-12-10 04:21:02 | Scotland, United Kingdom | |||
3381048 | 3381048 | 2022-12-08 | United Kingdom | Scotland | 2131615 | 16187 | 0 | 56.4907 | -4.2026 | 2022-12-09 04:21:05 | Scotland, United Kingdom | |||
1988319 | 1988319 | 2022-12-07 | United Kingdom | Scotland | 2129682 | 16187 | 0 | 56.4907 | -4.2026 | 2022-12-08 04:21:07 | Scotland, United Kingdom | |||
3717842 | 3717842 | 2022-12-06 | United Kingdom | Scotland | 2129682 | 16187 | 0 | 56.4907 | -4.2026 | 2022-12-07 04:20:58 | Scotland, United Kingdom | |||
2418547 | 2418547 | 2022-12-05 | United Kingdom | Scotland | 2129682 | 16187 | 0 | 56.4907 | -4.2026 | 2022-12-06 04:21:03 | Scotland, United Kingdom | |||
722155 | 722155 | 2022-12-04 | United Kingdom | Scotland | 2129682 | 16187 | 0 | 56.4907 | -4.2026 | 2022-12-05 04:20:58 | Scotland, United Kingdom | |||
2820444 | 2820444 | 2022-12-03 | United Kingdom | Scotland | 2129682 | 16187 | 0 | 56.4907 | -4.2026 | 2022-12-04 04:20:56 | Scotland, United Kingdom | |||
837300 | 837300 | 2022-12-02 | United Kingdom | Scotland | 2129682 | 16187 | 0 | 56.4907 | -4.2026 | 2022-12-03 04:21:02 | Scotland, United Kingdom | |||
2139830 | 2139830 | 2022-12-01 | United Kingdom | Scotland | 2129682 | 16181 | 0 | 56.4907 | -4.2026 | 2022-12-02 04:21:07 | Scotland, United Kingdom | |||
1968246 | 1968246 | 2022-11-30 | United Kingdom | Scotland | 2125838 | 16176 | 0 | 56.4907 | -4.2026 | 2022-12-01 04:21:03 | Scotland, United Kingdom | |||
2560260 | 2560260 | 2022-11-29 | United Kingdom | Scotland | 2125838 | 16170 | 0 | 56.4907 | -4.2026 | 2022-11-30 04:21:07 | Scotland, United Kingdom | |||
1243334 | 1243334 | 2022-11-28 | United Kingdom | Scotland | 2125838 | 16163 | 0 | 56.4907 | -4.2026 | 2022-11-29 04:21:05 | Scotland, United Kingdom | |||
3555322 | 3555322 | 2022-11-27 | United Kingdom | Scotland | 2125838 | 16156 | 0 | 56.4907 | -4.2026 | 2022-11-28 04:21:02 | Scotland, United Kingdom | |||
2103802 | 2103802 | 2022-11-26 | United Kingdom | Scotland | 2125838 | 16150 | 0 | 56.4907 | -4.2026 | 2022-11-27 04:21:05 | Scotland, United Kingdom | |||
491293 | 491293 | 2022-11-25 | United Kingdom | Scotland | 2125838 | 16144 | 0 | 56.4907 | -4.2026 | 2022-11-26 04:21:11 | Scotland, United Kingdom | |||
3527122 | 3527122 | 2022-11-24 | United Kingdom | Scotland | 2125838 | 16143 | 0 | 56.4907 | -4.2026 | 2022-11-25 04:21:06 | Scotland, United Kingdom | |||
3315905 | 3315905 | 2022-11-23 | United Kingdom | Scotland | 2125838 | 16136 | 0 | 56.4907 | -4.2026 | 2022-11-24 04:21:09 | Scotland, United Kingdom | |||
1623946 | 1623946 | 2022-11-22 | United Kingdom | Scotland | 2125838 | 16133 | 0 | 56.4907 | -4.2026 | 2022-11-23 04:21:06 | Scotland, United Kingdom | |||
3463834 | 3463834 | 2022-11-21 | United Kingdom | Scotland | 2125838 | 16124 | 0 | 56.4907 | -4.2026 | 2022-11-22 04:20:47 | Scotland, United Kingdom | |||
1644019 | 1644019 | 2022-11-20 | United Kingdom | Scotland | 2125838 | 16120 | 0 | 56.4907 | -4.2026 | 2022-11-21 04:21:05 | Scotland, United Kingdom | |||
2067576 | 2067576 | 2022-11-19 | United Kingdom | Scotland | 2125838 | 16115 | 0 | 56.4907 | -4.2026 | 2022-11-20 04:21:08 | Scotland, United Kingdom | |||
1758970 | 1758970 | 2022-11-18 | United Kingdom | Scotland | 2125838 | 16107 | 0 | 56.4907 | -4.2026 | 2022-11-19 04:21:14 | Scotland, United Kingdom | |||
3029963 | 3029963 | 2022-11-17 | United Kingdom | Scotland | 2125838 | 16103 | 0 | 56.4907 | -4.2026 | 2022-11-18 04:21:15 | Scotland, United Kingdom | |||
2489674 | 2489674 | 2022-11-16 | United Kingdom | Scotland | 2123527 | 16098 | 0 | 56.4907 | -4.2026 | 2022-11-17 04:21:11 | Scotland, United Kingdom | |||
295685 | 295685 | 2022-11-15 | United Kingdom | Scotland | 2123527 | 16093 | 0 | 56.4907 | -4.2026 | 2022-11-16 04:21:09 | Scotland, United Kingdom | |||
3600715 | 3600715 | 2022-11-14 | United Kingdom | Scotland | 2123527 | 16088 | 0 | 56.4907 | -4.2026 | 2022-11-15 04:21:16 | Scotland, United Kingdom | |||
315573 | 315573 | 2022-11-13 | United Kingdom | Scotland | 2123527 | 16084 | 0 | 56.4907 | -4.2026 | 2022-11-14 04:21:09 | Scotland, United Kingdom | |||
66734 | 66734 | 2022-11-12 | United Kingdom | Scotland | 2123527 | 16081 | 0 | 56.4907 | -4.2026 | 2022-11-13 04:21:14 | Scotland, United Kingdom | |||
2930896 | 2930896 | 2022-11-11 | United Kingdom | Scotland | 2123527 | 16073 | 0 | 56.4907 | -4.2026 | 2022-11-12 04:20:41 | Scotland, United Kingdom | |||
2509732 | 2509732 | 2022-11-10 | United Kingdom | Scotland | 2123527 | 16061 | 0 | 56.4907 | -4.2026 | 2022-11-11 04:21:22 | Scotland, United Kingdom | |||
2434607 | 2434607 | 2022-11-09 | United Kingdom | Scotland | 2121084 | 16056 | 0 | 56.4907 | -4.2026 | 2022-11-10 04:21:16 | Scotland, United Kingdom | |||
483263 | 483263 | 2022-11-08 | United Kingdom | Scotland | 2121084 | 16049 | 0 | 56.4907 | -4.2026 | 2022-11-09 04:21:22 | Scotland, United Kingdom | |||
2442413 | 2442413 | 2022-11-07 | United Kingdom | Scotland | 2121084 | 16046 | 0 | 56.4907 | -4.2026 | 2022-11-08 04:21:21 | Scotland, United Kingdom | |||
1053511 | 1053511 | 2022-11-06 | United Kingdom | Scotland | 2121084 | 16038 | 0 | 56.4907 | -4.2026 | 2022-11-07 04:21:26 | Scotland, United Kingdom | |||
621535 | 621535 | 2022-11-05 | United Kingdom | Scotland | 2121084 | 16034 | 0 | 56.4907 | -4.2026 | 2022-11-06 04:21:24 | Scotland, United Kingdom | |||
1026039 | 1026039 | 2022-11-04 | United Kingdom | Scotland | 2121084 | 16027 | 0 | 56.4907 | -4.2026 | 2022-11-05 04:21:52 | Scotland, United Kingdom | |||
435030 | 435030 | 2022-11-03 | United Kingdom | Scotland | 2121084 | 16015 | 0 | 56.4907 | -4.2026 | 2022-11-04 04:22:11 | Scotland, United Kingdom | |||
853272 | 853272 | 2022-11-02 | United Kingdom | Scotland | 2118188 | 16008 | 0 | 56.4907 | -4.2026 | 2022-11-03 04:22:05 | Scotland, United Kingdom | |||
714123 | 714123 | 2022-11-01 | United Kingdom | Scotland | 2118188 | 16000 | 0 | 56.4907 | -4.2026 | 2022-11-02 04:22:09 | Scotland, United Kingdom | |||
3288572 | 3288572 | 2022-10-31 | United Kingdom | Scotland | 2118188 | 15991 | 0 | 56.4907 | -4.2026 | 2022-11-01 04:22:36 | Scotland, United Kingdom | |||
323605 | 323605 | 2022-10-30 | United Kingdom | Scotland | 2118188 | 15982 | 0 | 56.4907 | -4.2026 | 2022-10-31 04:21:36 | Scotland, United Kingdom | |||
915881 | 915881 | 2022-10-29 | United Kingdom | Scotland | 2118188 | 15977 | 0 | 56.4907 | -4.2026 | 2022-10-30 04:22:14 | Scotland, United Kingdom | |||
1370150 | 1370150 | 2022-10-28 | United Kingdom | Scotland | 2118188 | 15971 | 0 | 56.4907 | -4.2026 | 2022-10-29 04:21:13 | Scotland, United Kingdom | |||
3042005 | 3042005 | 2022-10-27 | United Kingdom | Scotland | 2118188 | 15967 | 0 | 56.4907 | -4.2026 | 2022-10-28 04:22:31 | Scotland, United Kingdom | |||
542425 | 542425 | 2022-10-26 | United Kingdom | Scotland | 2114972 | 15964 | 0 | 56.4907 | -4.2026 | 2022-10-27 04:22:01 | Scotland, United Kingdom | |||
1833826 | 1833826 | 2022-10-25 | United Kingdom | Scotland | 2114972 | 15960 | 0 | 56.4907 | -4.2026 | 2022-10-26 04:22:19 | Scotland, United Kingdom | |||
798087 | 798087 | 2022-10-24 | United Kingdom | Scotland | 2114972 | 15951 | 0 | 56.4907 | -4.2026 | 2022-10-25 04:21:53 | Scotland, United Kingdom | |||
3280542 | 3280542 | 2022-10-23 | United Kingdom | Scotland | 2114972 | 15946 | 0 | 56.4907 | -4.2026 | 2022-10-24 04:22:29 | Scotland, United Kingdom | |||
2271580 | 2271580 | 2022-10-22 | United Kingdom | Scotland | 2114972 | 15939 | 0 | 56.4907 | -4.2026 | 2022-10-23 04:22:46 | Scotland, United Kingdom | |||
1595880 | 1595880 | 2022-10-21 | United Kingdom | Scotland | 2114972 | 15932 | 0 | 56.4907 | -4.2026 | 2022-10-22 04:22:53 | Scotland, United Kingdom | |||
2275596 | 2275596 | 2022-10-20 | United Kingdom | Scotland | 2114972 | 15923 | 0 | 56.4907 | -4.2026 | 2022-10-21 04:22:23 | Scotland, United Kingdom | |||
201931 | 201931 | 2022-10-19 | United Kingdom | Scotland | 2111605 | 15917 | 0 | 56.4907 | -4.2026 | 2022-10-20 04:22:59 | Scotland, United Kingdom | |||
2760592 | 2760592 | 2022-10-18 | United Kingdom | Scotland | 2111605 | 15909 | 0 | 56.4907 | -4.2026 | 2022-10-19 04:22:26 | Scotland, United Kingdom | |||
2028426 | 2028426 | 2022-10-17 | United Kingdom | Scotland | 2111605 | 15901 | 0 | 56.4907 | -4.2026 | 2022-10-18 04:22:42 | Scotland, United Kingdom | |||
2163204 | 2163204 | 2022-10-16 | United Kingdom | Scotland | 2111605 | 15894 | 0 | 56.4907 | -4.2026 | 2022-10-17 04:20:31 | Scotland, United Kingdom | |||
519401 | 519401 | 2022-10-15 | United Kingdom | Scotland | 2111605 | 15891 | 0 | 56.4907 | -4.2026 | 2022-10-16 04:22:39 | Scotland, United Kingdom | |||
2036458 | 2036458 | 2022-10-14 | United Kingdom | Scotland | 2111605 | 15883 | 0 | 56.4907 | -4.2026 | 2022-10-15 04:22:00 | Scotland, United Kingdom | |||
3757146 | 3757146 | 2022-10-13 | United Kingdom | Scotland | 2111605 | 15877 | 0 | 56.4907 | -4.2026 | 2022-10-14 04:22:28 | Scotland, United Kingdom | |||
3217971 | 3217971 | 2022-10-12 | United Kingdom | Scotland | 2107886 | 15872 | 0 | 56.4907 | -4.2026 | 2022-10-13 04:22:39 | Scotland, United Kingdom | |||
3253820 | 3253820 | 2022-10-11 | United Kingdom | Scotland | 2107886 | 15867 | 0 | 56.4907 | -4.2026 | 2022-10-12 04:22:51 | Scotland, United Kingdom | |||
2971079 | 2971079 | 2022-10-10 | United Kingdom | Scotland | 2107886 | 15863 | 0 | 56.4907 | -4.2026 | 2022-10-11 04:23:05 | Scotland, United Kingdom | |||
3101115 | 3101115 | 2022-10-09 | United Kingdom | Scotland | 2107886 | 15860 | 0 | 56.4907 | -4.2026 | 2022-10-10 04:22:32 | Scotland, United Kingdom | |||
4006340 | 4006340 | 2022-10-08 | United Kingdom | Scotland | 2107886 | 15854 | 0 | 56.4907 | -4.2026 | 2022-10-09 04:21:16 | Scotland, United Kingdom | |||
399937 | 399937 | 2022-10-07 | United Kingdom | Scotland | 2107886 | 15848 | 0 | 56.4907 | -4.2026 | 2022-10-08 04:22:56 | Scotland, United Kingdom | |||
2533054 | 2533054 | 2022-10-06 | United Kingdom | Scotland | 2107886 | 15840 | 0 | 56.4907 | -4.2026 | 2022-10-07 04:23:08 | Scotland, United Kingdom | |||
1814448 | 1814448 | 2022-10-05 | United Kingdom | Scotland | 2105010 | 15834 | 0 | 56.4907 | -4.2026 | 2022-10-06 04:21:22 | Scotland, United Kingdom | |||
134422 | 134422 | 2022-10-04 | United Kingdom | Scotland | 2105010 | 15825 | 0 | 56.4907 | -4.2026 | 2022-10-05 04:23:06 | Scotland, United Kingdom | |||
2689369 | 2689369 | 2022-10-03 | United Kingdom | Scotland | 2105010 | 15818 | 0 | 56.4907 | -4.2026 | 2022-10-04 04:22:55 | Scotland, United Kingdom | |||
2263436 | 2263436 | 2022-10-02 | United Kingdom | Scotland | 2105010 | 15812 | 0 | 56.4907 | -4.2026 | 2022-10-03 04:23:11 | Scotland, United Kingdom | |||
2998962 | 2998962 | 2022-10-01 | United Kingdom | Scotland | 2105010 | 15807 | 0 | 56.4907 | -4.2026 | 2022-10-02 04:21:23 | Scotland, United Kingdom | |||
857288 | 857288 | 2022-09-30 | United Kingdom | Scotland | 2105010 | 15799 | 0 | 56.4907 | -4.2026 | 2022-10-01 04:23:01 | Scotland, United Kingdom | |||
2379214 | 2379214 | 2022-09-29 | United Kingdom | Scotland | 2105010 | 15791 | 0 | 56.4907 | -4.2026 | 2022-09-30 04:23:09 | Scotland, United Kingdom | |||
1563765 | 1563765 | 2022-09-28 | United Kingdom | Scotland | 2101498 | 15783 | 0 | 56.4907 | -4.2026 | 2022-09-29 04:22:34 | Scotland, United Kingdom | |||
3998308 | 3998308 | 2022-09-27 | United Kingdom | Scotland | 2101498 | 15782 | 0 | 56.4907 | -4.2026 | 2022-09-28 04:23:01 | Scotland, United Kingdom | |||
2772636 | 2772636 | 2022-09-26 | United Kingdom | Scotland | 2101498 | 15774 | 0 | 56.4907 | -4.2026 | 2022-09-27 04:23:01 | Scotland, United Kingdom | |||
1980289 | 1980289 | 2022-09-25 | United Kingdom | Scotland | 2101498 | 15767 | 0 | 56.4907 | -4.2026 | 2022-09-26 04:20:52 | Scotland, United Kingdom | |||
2653456 | 2653456 | 2022-09-24 | United Kingdom | Scotland | 2101498 | 15761 | 0 | 56.4907 | -4.2026 | 2022-09-25 04:23:31 | Scotland, United Kingdom | |||
387896 | 387896 | 2022-09-23 | United Kingdom | Scotland | 2101498 | 15754 | 0 | 56.4907 | -4.2026 | 2022-09-24 04:21:40 | Scotland, United Kingdom | |||
1627962 | 1627962 | 2022-09-22 | United Kingdom | Scotland | 2101498 | 15745 | 0 | 56.4907 | -4.2026 | 2022-09-23 04:23:13 | Scotland, United Kingdom | |||
1374166 | 1374166 | 2022-09-21 | United Kingdom | Scotland | 2098635 | 15743 | 0 | 56.4907 | -4.2026 | 2022-09-22 04:22:56 | Scotland, United Kingdom |
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]);