johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,073 rows where country_or_region = "United Kingdom" and province_or_state = "Scotland" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1495265 | 1495265 | 2021-10-12 | United Kingdom | Scotland | 594623 | 11451 | 0 | 56.4907 | -4.2026 | 2021-10-13 04:20:51 | Scotland, United Kingdom | |||
3010998 | 3010998 | 2021-10-11 | United Kingdom | Scotland | 592721 | 11431 | 0 | 56.4907 | -4.2026 | 2021-10-12 04:21:09 | Scotland, United Kingdom | |||
427014 | 427014 | 2021-10-10 | United Kingdom | Scotland | 590424 | 11404 | 0 | 56.4907 | -4.2026 | 2021-10-11 04:21:31 | Scotland, United Kingdom | |||
2879871 | 2879871 | 2021-10-09 | United Kingdom | Scotland | 588062 | 11387 | 0 | 56.4907 | -4.2026 | 2021-10-10 04:21:38 | Scotland, United Kingdom | |||
2963037 | 2963037 | 2021-10-08 | United Kingdom | Scotland | 585647 | 11372 | 0 | 56.4907 | -4.2026 | 2021-10-09 04:21:34 | Scotland, United Kingdom | |||
471075 | 471075 | 2021-10-07 | United Kingdom | Scotland | 583019 | 11359 | 0 | 56.4907 | -4.2026 | 2021-10-08 04:21:25 | Scotland, United Kingdom | |||
2462455 | 2462455 | 2021-10-06 | United Kingdom | Scotland | 580332 | 11339 | 0 | 56.4907 | -4.2026 | 2021-10-07 04:21:36 | Scotland, United Kingdom | |||
3836148 | 3836148 | 2021-10-05 | United Kingdom | Scotland | 577282 | 11326 | 0 | 56.4907 | -4.2026 | 2021-10-06 04:21:33 | Scotland, United Kingdom | |||
990641 | 990641 | 2021-10-04 | United Kingdom | Scotland | 575231 | 11298 | 0 | 56.4907 | -4.2026 | 2021-10-05 04:21:27 | Scotland, United Kingdom | |||
1277951 | 1277951 | 2021-10-03 | United Kingdom | Scotland | 573471 | 11282 | 0 | 56.4907 | -4.2026 | 2021-10-04 04:21:31 | Scotland, United Kingdom | |||
3931704 | 3931704 | 2021-10-02 | United Kingdom | Scotland | 571431 | 11264 | 0 | 56.4907 | -4.2026 | 2021-10-03 04:21:24 | Scotland, United Kingdom | |||
2135684 | 2135684 | 2021-10-01 | United Kingdom | Scotland | 568916 | 11240 | 0 | 56.4907 | -4.2026 | 2021-10-02 04:21:25 | Scotland, United Kingdom | |||
2776641 | 2776641 | 2021-09-30 | United Kingdom | Scotland | 566231 | 11221 | 0 | 56.4907 | -4.2026 | 2021-10-01 04:21:35 | Scotland, United Kingdom | |||
710097 | 710097 | 2021-09-29 | United Kingdom | Scotland | 563326 | 11205 | 0 | 56.4907 | -4.2026 | 2021-09-30 04:21:20 | Scotland, United Kingdom | |||
1337939 | 1337939 | 2021-09-28 | United Kingdom | Scotland | 560334 | 11181 | 0 | 56.4907 | -4.2026 | 2021-09-29 04:21:45 | Scotland, United Kingdom | |||
1239308 | 1239308 | 2021-09-27 | United Kingdom | Scotland | 557970 | 11161 | 0 | 56.4907 | -4.2026 | 2021-09-28 04:21:28 | Scotland, United Kingdom | |||
2079609 | 2079609 | 2021-09-26 | United Kingdom | Scotland | 555906 | 11136 | 0 | 56.4907 | -4.2026 | 2021-09-27 04:21:16 | Scotland, United Kingdom | |||
1728161 | 1728161 | 2021-09-25 | United Kingdom | Scotland | 553350 | 11118 | 0 | 56.4907 | -4.2026 | 2021-09-26 04:21:29 | Scotland, United Kingdom | |||
1924881 | 1924881 | 2021-09-24 | United Kingdom | Scotland | 550090 | 11096 | 0 | 56.4907 | -4.2026 | 2021-09-25 04:21:31 | Scotland, United Kingdom | |||
605352 | 605352 | 2021-09-23 | United Kingdom | Scotland | 546426 | 11074 | 0 | 56.4907 | -4.2026 | 2021-09-24 04:21:44 | Scotland, United Kingdom | |||
3014996 | 3014996 | 2021-09-22 | United Kingdom | Scotland | 542411 | 11054 | 0 | 56.4907 | -4.2026 | 2021-09-23 04:21:43 | Scotland, United Kingdom | |||
3761134 | 3761134 | 2021-09-21 | United Kingdom | Scotland | 538819 | 11024 | 0 | 56.4907 | -4.2026 | 2021-09-22 04:21:45 | Scotland, United Kingdom | |||
813237 | 813237 | 2021-09-20 | United Kingdom | Scotland | 535955 | 11000 | 0 | 56.4907 | -4.2026 | 2021-09-21 04:21:26 | Scotland, United Kingdom | |||
1818436 | 1818436 | 2021-09-19 | United Kingdom | Scotland | 533038 | 10976 | 0 | 56.4907 | -4.2026 | 2021-09-20 04:21:22 | Scotland, United Kingdom | |||
20016 | 20016 | 2021-09-18 | United Kingdom | Scotland | 529207 | 10946 | 0 | 56.4907 | -4.2026 | 2021-09-19 04:21:34 | Scotland, United Kingdom | |||
2621701 | 2621701 | 2021-09-17 | United Kingdom | Scotland | 523095 | 10923 | 0 | 56.4907 | -4.2026 | 2021-09-18 04:21:24 | Scotland, United Kingdom | |||
2812409 | 2812409 | 2021-09-16 | United Kingdom | Scotland | 517216 | 10900 | 0 | 56.4907 | -4.2026 | 2021-09-17 04:21:46 | Scotland, United Kingdom | |||
1378153 | 1378153 | 2021-09-15 | United Kingdom | Scotland | 517216 | 10881 | 0 | 56.4907 | -4.2026 | 2021-09-16 04:22:19 | Scotland, United Kingdom | |||
2466452 | 2466452 | 2021-09-14 | United Kingdom | Scotland | 512312 | 10862 | 0 | 56.4907 | -4.2026 | 2021-09-15 03:22:37 | Scotland, United Kingdom | |||
1389291 | 1389291 | 2021-09-13 | United Kingdom | Scotland | 508882 | 10838 | 0 | 56.4907 | -4.2026 | 2021-09-14 04:21:41 | Scotland, United Kingdom | |||
1888660 | 1888660 | 2021-09-12 | United Kingdom | Scotland | 504650 | 10817 | 0 | 56.4907 | -4.2026 | 2021-09-13 04:21:15 | Scotland, United Kingdom | |||
3809563 | 3809563 | 2021-09-11 | United Kingdom | Scotland | 498745 | 10797 | 0 | 56.4907 | -4.2026 | 2021-09-12 04:21:13 | Scotland, United Kingdom | |||
3452503 | 3452503 | 2021-09-10 | United Kingdom | Scotland | 494457 | 10777 | 0 | 56.4907 | -4.2026 | 2021-09-11 04:21:30 | Scotland, United Kingdom | |||
1266449 | 1266449 | 2021-09-09 | United Kingdom | Scotland | 487654 | 10753 | 0 | 56.4907 | -4.2026 | 2021-09-10 04:21:20 | Scotland, United Kingdom | |||
2282819 | 2282819 | 2021-09-08 | United Kingdom | Scotland | 480824 | 10734 | 0 | 56.4907 | -4.2026 | 2021-09-09 04:21:27 | Scotland, United Kingdom | |||
645598 | 645598 | 2021-09-07 | United Kingdom | Scotland | 475027 | 10723 | 0 | 56.4907 | -4.2026 | 2021-09-08 04:21:31 | Scotland, United Kingdom | |||
3197661 | 3197661 | 2021-09-06 | United Kingdom | Scotland | 469341 | 10704 | 0 | 56.4907 | -4.2026 | 2021-09-07 04:21:35 | Scotland, United Kingdom | |||
3284529 | 3284529 | 2021-09-05 | United Kingdom | Scotland | 462288 | 10690 | 0 | 56.4907 | -4.2026 | 2021-09-06 04:21:22 | Scotland, United Kingdom | |||
252943 | 252943 | 2021-09-04 | United Kingdom | Scotland | 455926 | 10673 | 0 | 56.4907 | -4.2026 | 2021-09-05 04:21:33 | Scotland, United Kingdom | |||
3978224 | 3978224 | 2021-09-03 | United Kingdom | Scotland | 449780 | 10663 | 0 | 56.4907 | -4.2026 | 2021-09-04 04:21:28 | Scotland, United Kingdom | |||
181686 | 181686 | 2021-09-02 | United Kingdom | Scotland | 443080 | 10652 | 0 | 56.4907 | -4.2026 | 2021-09-03 04:21:20 | Scotland, United Kingdom | |||
70721 | 70721 | 2021-09-01 | United Kingdom | Scotland | 436688 | 10642 | 0 | 56.4907 | -4.2026 | 2021-09-02 04:21:15 | Scotland, United Kingdom | |||
2071563 | 2071563 | 2021-08-31 | United Kingdom | Scotland | 430525 | 10633 | 0 | 56.4907 | -4.2026 | 2021-09-01 04:21:38 | Scotland, United Kingdom | |||
1779017 | 1779017 | 2021-08-30 | United Kingdom | Scotland | 424508 | 10623 | 0 | 56.4907 | -4.2026 | 2021-08-31 04:21:46 | Scotland, United Kingdom | |||
3895591 | 3895591 | 2021-08-29 | United Kingdom | Scotland | 420622 | 10618 | 0 | 56.4907 | -4.2026 | 2021-08-30 04:21:23 | Scotland, United Kingdom | |||
2796694 | 2796694 | 2021-08-28 | United Kingdom | Scotland | 413518 | 10610 | 0 | 56.4907 | -4.2026 | 2021-08-29 04:21:14 | Scotland, United Kingdom | |||
2926853 | 2926853 | 2021-08-27 | United Kingdom | Scotland | 407660 | 10601 | 0 | 56.4907 | -4.2026 | 2021-08-28 04:21:28 | Scotland, United Kingdom | |||
1599867 | 1599867 | 2021-08-26 | United Kingdom | Scotland | 400842 | 10590 | 0 | 56.4907 | -4.2026 | 2021-08-27 04:21:37 | Scotland, United Kingdom | |||
36076 | 36076 | 2021-08-25 | United Kingdom | Scotland | 395918 | 10583 | 0 | 56.4907 | -4.2026 | 2021-08-26 04:21:28 | Scotland, United Kingdom | |||
3109115 | 3109115 | 2021-08-24 | United Kingdom | Scotland | 390908 | 10576 | 0 | 56.4907 | -4.2026 | 2021-08-25 04:21:41 | Scotland, United Kingdom | |||
3169286 | 3169286 | 2021-08-23 | United Kingdom | Scotland | 386591 | 10572 | 0 | 56.4907 | -4.2026 | 2021-08-24 04:21:19 | Scotland, United Kingdom | |||
2179213 | 2179213 | 2021-08-22 | United Kingdom | Scotland | 383403 | 10563 | 0 | 56.4907 | -4.2026 | 2021-08-23 04:21:27 | Scotland, United Kingdom | |||
3559309 | 3559309 | 2021-08-21 | United Kingdom | Scotland | 380217 | 10557 | 0 | 56.4907 | -4.2026 | 2021-08-22 04:21:29 | Scotland, United Kingdom | |||
1857651 | 1857651 | 2021-08-20 | United Kingdom | Scotland | 376753 | 10552 | 0 | 56.4907 | -4.2026 | 2021-08-21 04:21:38 | Scotland, United Kingdom | |||
515358 | 515358 | 2021-08-19 | United Kingdom | Scotland | 373143 | 10544 | 0 | 56.4907 | -4.2026 | 2021-08-20 04:21:33 | Scotland, United Kingdom | |||
2521837 | 2521837 | 2021-08-18 | United Kingdom | Scotland | 369779 | 10537 | 0 | 56.4907 | -4.2026 | 2021-08-19 04:21:15 | Scotland, United Kingdom | |||
248929 | 248929 | 2021-08-17 | United Kingdom | Scotland | 367241 | 10530 | 0 | 56.4907 | -4.2026 | 2021-08-18 04:21:35 | Scotland, United Kingdom | |||
1607892 | 1607892 | 2021-08-16 | United Kingdom | Scotland | 365427 | 10526 | 0 | 56.4907 | -4.2026 | 2021-08-17 04:21:49 | Scotland, United Kingdom | |||
106986 | 106986 | 2021-08-15 | United Kingdom | Scotland | 363860 | 10522 | 0 | 56.4907 | -4.2026 | 2021-08-16 04:21:31 | Scotland, United Kingdom | |||
511344 | 511344 | 2021-08-14 | United Kingdom | Scotland | 362366 | 10515 | 0 | 56.4907 | -4.2026 | 2021-08-15 04:21:41 | Scotland, United Kingdom | |||
1487216 | 1487216 | 2021-08-13 | United Kingdom | Scotland | 360983 | 10507 | 0 | 56.4907 | -4.2026 | 2021-08-14 04:21:25 | Scotland, United Kingdom | |||
2903346 | 2903346 | 2021-08-12 | United Kingdom | Scotland | 359442 | 10497 | 0 | 56.4907 | -4.2026 | 2021-08-13 04:21:24 | Scotland, United Kingdom | |||
1345950 | 1345950 | 2021-08-11 | United Kingdom | Scotland | 357917 | 10494 | 0 | 56.4907 | -4.2026 | 2021-08-12 04:21:25 | Scotland, United Kingdom | |||
2355097 | 2355097 | 2021-08-10 | United Kingdom | Scotland | 356419 | 10489 | 0 | 56.4907 | -4.2026 | 2021-08-11 04:21:58 | Scotland, United Kingdom | |||
653626 | 653626 | 2021-08-09 | United Kingdom | Scotland | 355388 | 10484 | 0 | 56.4907 | -4.2026 | 2021-08-10 04:21:27 | Scotland, United Kingdom | |||
593288 | 593288 | 2021-08-08 | United Kingdom | Scotland | 354538 | 10478 | 0 | 56.4907 | -4.2026 | 2021-08-09 04:21:24 | Scotland, United Kingdom | |||
2207300 | 2207300 | 2021-08-07 | United Kingdom | Scotland | 353301 | 10471 | 0 | 56.4907 | -4.2026 | 2021-08-08 04:21:33 | Scotland, United Kingdom | |||
1121250 | 1121250 | 2021-08-06 | United Kingdom | Scotland | 351915 | 10462 | 0 | 56.4907 | -4.2026 | 2021-08-07 04:21:30 | Scotland, United Kingdom | |||
1960187 | 1960187 | 2021-08-05 | United Kingdom | Scotland | 350667 | 10455 | 0 | 56.4907 | -4.2026 | 2021-08-06 04:21:18 | Scotland, United Kingdom | |||
335566 | 335566 | 2021-08-04 | United Kingdom | Scotland | 349286 | 10448 | 0 | 341321 | 56.4907 | -4.2026 | 2021-08-05 04:21:51 | Scotland, United Kingdom | ||
3471837 | 3471837 | 2021-08-03 | United Kingdom | Scotland | 348018 | 10441 | 0 | 340066 | 56.4907 | -4.2026 | 2021-08-04 04:21:25 | Scotland, United Kingdom | ||
3687111 | 3687111 | 2021-08-02 | United Kingdom | Scotland | 347005 | 10438 | 0 | 339062 | 56.4907 | -4.2026 | 2021-08-03 04:21:39 | Scotland, United Kingdom | ||
3019010 | 3019010 | 2021-08-01 | United Kingdom | Scotland | 346210 | 10431 | 0 | 338268 | 56.4907 | -4.2026 | 2021-08-02 04:21:36 | Scotland, United Kingdom | ||
3907633 | 3907633 | 2021-07-31 | United Kingdom | Scotland | 345176 | 10419 | 0 | 337237 | 56.4907 | -4.2026 | 2021-08-01 04:21:50 | Scotland, United Kingdom | ||
3299838 | 3299838 | 2021-07-30 | United Kingdom | Scotland | 344158 | 10412 | 0 | 336228 | 56.4907 | -4.2026 | 2021-07-31 04:21:35 | Scotland, United Kingdom | ||
3389049 | 3389049 | 2021-07-29 | United Kingdom | Scotland | 342704 | 10405 | 0 | 334780 | 56.4907 | -4.2026 | 2021-07-30 04:21:34 | Scotland, United Kingdom | ||
411954 | 411954 | 2021-07-28 | United Kingdom | Scotland | 341307 | 10399 | 0 | 333396 | 56.4907 | -4.2026 | 2021-07-29 04:21:33 | Scotland, United Kingdom | ||
1309815 | 1309815 | 2021-07-27 | United Kingdom | Scotland | 342059 | 10392 | 0 | 334193 | 56.4907 | -4.2026 | 2021-07-28 04:21:39 | Scotland, United Kingdom | ||
3221958 | 3221958 | 2021-07-26 | United Kingdom | Scotland | 341015 | 10383 | 0 | 333156 | 56.4907 | -4.2026 | 2021-07-27 04:21:18 | Scotland, United Kingdom | ||
1382167 | 1382167 | 2021-07-25 | United Kingdom | Scotland | 340015 | 10377 | 0 | 332156 | 56.4907 | -4.2026 | 2021-07-26 04:21:28 | Scotland, United Kingdom | ||
1333907 | 1333907 | 2021-07-24 | United Kingdom | Scotland | 338778 | 10372 | 0 | 330919 | 56.4907 | -4.2026 | 2021-07-25 04:22:12 | Scotland, United Kingdom | ||
3141211 | 3141211 | 2021-07-23 | United Kingdom | Scotland | 337471 | 10370 | 0 | 329623 | 56.4907 | -4.2026 | 2021-07-24 00:21:36 | Scotland, United Kingdom | ||
3479971 | 3479971 | 2021-07-22 | United Kingdom | Scotland | 335966 | 10362 | 0 | 328124 | 56.4907 | -4.2026 | 2021-07-23 04:21:29 | Scotland, United Kingdom | ||
3335190 | 3335190 | 2021-07-21 | United Kingdom | Scotland | 334141 | 10354 | 0 | 326321 | 56.4907 | -4.2026 | 2021-07-22 04:21:19 | Scotland, United Kingdom | ||
2375171 | 2375171 | 2021-07-20 | United Kingdom | Scotland | 332455 | 10345 | 0 | 324642 | 56.4907 | -4.2026 | 2021-07-21 04:21:40 | Scotland, United Kingdom | ||
487250 | 487250 | 2021-07-19 | United Kingdom | Scotland | 330851 | 10339 | 0 | 323051 | 56.4907 | -4.2026 | 2021-07-20 04:21:48 | Scotland, United Kingdom | ||
2677473 | 2677473 | 2021-07-18 | United Kingdom | Scotland | 329387 | 10330 | 0 | 321587 | 56.4907 | -4.2026 | 2021-07-19 04:21:24 | Scotland, United Kingdom | ||
3709785 | 3709785 | 2021-07-17 | United Kingdom | Scotland | 327652 | 10321 | 0 | 319852 | 56.4907 | -4.2026 | 2021-07-18 04:22:07 | Scotland, United Kingdom | ||
2951016 | 2951016 | 2021-07-16 | United Kingdom | Scotland | 325335 | 10315 | 0 | 317539 | 56.4907 | -4.2026 | 2021-07-17 04:22:22 | Scotland, United Kingdom | ||
299672 | 299672 | 2021-07-15 | United Kingdom | Scotland | 323288 | 10310 | 0 | 315497 | 56.4907 | -4.2026 | 2021-07-16 04:21:22 | Scotland, United Kingdom | ||
3635617 | 3635617 | 2021-07-14 | United Kingdom | Scotland | 321202 | 10302 | 0 | 313430 | 56.4907 | -4.2026 | 2021-07-15 04:21:48 | Scotland, United Kingdom | ||
582492 | 582492 | 2021-07-13 | United Kingdom | Scotland | 318566 | 10295 | 0 | 310805 | 56.4907 | -4.2026 | 2021-07-14 04:21:35 | Scotland, United Kingdom | ||
3744741 | 3744741 | 2021-07-12 | United Kingdom | Scotland | 316037 | 10287 | 0 | 308280 | 56.4907 | -4.2026 | 2021-07-13 04:21:18 | Scotland, United Kingdom | ||
3663254 | 3663254 | 2021-07-11 | United Kingdom | Scotland | 313903 | 10280 | 0 | 306146 | 56.4907 | -4.2026 | 2021-07-12 04:21:34 | Scotland, United Kingdom | ||
629538 | 629538 | 2021-07-10 | United Kingdom | Scotland | 311855 | 10275 | 0 | 304098 | 56.4907 | -4.2026 | 2021-07-11 04:21:43 | Scotland, United Kingdom | ||
833257 | 833257 | 2021-07-09 | United Kingdom | Scotland | 309665 | 10266 | 0 | 301915 | 56.4907 | -4.2026 | 2021-07-10 04:21:25 | Scotland, United Kingdom | ||
782021 | 782021 | 2021-07-08 | United Kingdom | Scotland | 306449 | 10258 | 0 | 298705 | 56.4907 | -4.2026 | 2021-07-09 04:21:21 | Scotland, United Kingdom | ||
1444243 | 1444243 | 2021-07-07 | United Kingdom | Scotland | 303647 | 10247 | 0 | 295907 | 56.4907 | -4.2026 | 2021-07-08 04:21:26 | Scotland, United Kingdom | ||
2697348 | 2697348 | 2021-07-06 | United Kingdom | Scotland | 299848 | 10241 | 0 | 292113 | 56.4907 | -4.2026 | 2021-07-07 04:21:20 | Scotland, United Kingdom | ||
1936097 | 1936097 | 2021-07-05 | United Kingdom | Scotland | 297485 | 10228 | 0 | 289756 | 56.4907 | -4.2026 | 2021-07-06 04:21:32 | 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]);