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)
province_or_state 1
- Scotland · 973 ✖
country_or_region 1
- United Kingdom 973
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2020395 | 2020395 | 2022-09-20 | United Kingdom | Scotland | 2098635 | 15740 | 0 | 56.4907 | -4.2026 | 2022-09-21 04:23:22 | Scotland, United Kingdom | |||
3574268 | 3574268 | 2022-09-19 | United Kingdom | Scotland | 2098635 | 15738 | 0 | 56.4907 | -4.2026 | 2022-09-20 04:22:48 | Scotland, United Kingdom | |||
423007 | 423007 | 2022-09-18 | United Kingdom | Scotland | 2098635 | 15733 | 0 | 56.4907 | -4.2026 | 2022-09-19 04:21:49 | Scotland, United Kingdom | |||
3377031 | 3377031 | 2022-09-17 | United Kingdom | Scotland | 2098635 | 15724 | 0 | 56.4907 | -4.2026 | 2022-09-18 04:22:50 | Scotland, United Kingdom | |||
2359139 | 2359139 | 2022-09-16 | United Kingdom | Scotland | 2098635 | 15717 | 0 | 56.4907 | -4.2026 | 2022-09-17 04:20:19 | Scotland, United Kingdom | |||
3990296 | 3990296 | 2022-09-15 | United Kingdom | Scotland | 2098635 | 15710 | 0 | 56.4907 | -4.2026 | 2022-09-16 04:21:19 | Scotland, United Kingdom | |||
1892813 | 1892813 | 2022-09-14 | United Kingdom | Scotland | 2095171 | 15706 | 0 | 56.4907 | -4.2026 | 2022-09-15 04:21:02 | Scotland, United Kingdom | |||
375869 | 375869 | 2022-09-13 | United Kingdom | Scotland | 2095171 | 15700 | 0 | 56.4907 | -4.2026 | 2022-09-14 04:20:44 | Scotland, United Kingdom | |||
2398470 | 2398470 | 2022-09-12 | United Kingdom | Scotland | 2095171 | 15698 | 0 | 56.4907 | -4.2026 | 2022-09-13 04:20:57 | Scotland, United Kingdom | |||
3769548 | 3769548 | 2022-09-11 | United Kingdom | Scotland | 2095171 | 15692 | 0 | 56.4907 | -4.2026 | 2022-09-12 04:20:58 | Scotland, United Kingdom | |||
3828123 | 3828123 | 2022-09-10 | United Kingdom | Scotland | 2095171 | 15685 | 0 | 56.4907 | -4.2026 | 2022-09-11 04:20:50 | Scotland, United Kingdom | |||
966580 | 966580 | 2022-09-09 | United Kingdom | Scotland | 2095171 | 15675 | 0 | 56.4907 | -4.2026 | 2022-09-10 04:21:10 | Scotland, United Kingdom | |||
256982 | 256982 | 2022-09-08 | United Kingdom | Scotland | 2095171 | 15671 | 0 | 56.4907 | -4.2026 | 2022-09-09 04:21:11 | Scotland, United Kingdom | |||
3748780 | 3748780 | 2022-09-07 | United Kingdom | Scotland | 2091313 | 15666 | 0 | 56.4907 | -4.2026 | 2022-09-08 04:21:02 | Scotland, United Kingdom | |||
118420 | 118420 | 2022-09-06 | United Kingdom | Scotland | 2091313 | 15664 | 0 | 56.4907 | -4.2026 | 2022-09-07 04:20:59 | Scotland, United Kingdom | |||
2637392 | 2637392 | 2022-09-05 | United Kingdom | Scotland | 2091313 | 15657 | 0 | 56.4907 | -4.2026 | 2022-09-06 04:21:02 | Scotland, United Kingdom | |||
2990956 | 2990956 | 2022-09-04 | United Kingdom | Scotland | 2091313 | 15653 | 0 | 56.4907 | -4.2026 | 2022-09-05 04:21:01 | Scotland, United Kingdom | |||
2716641 | 2716641 | 2022-09-03 | United Kingdom | Scotland | 2091313 | 15649 | 0 | 56.4907 | -4.2026 | 2022-09-04 04:21:22 | Scotland, United Kingdom | |||
1397346 | 1397346 | 2022-09-02 | United Kingdom | Scotland | 2091313 | 15641 | 0 | 56.4907 | -4.2026 | 2022-09-03 04:21:04 | Scotland, United Kingdom | |||
3551175 | 3551175 | 2022-09-01 | United Kingdom | Scotland | 2091313 | 15637 | 0 | 56.4907 | -4.2026 | 2022-09-02 04:21:07 | Scotland, United Kingdom | |||
2347095 | 2347095 | 2022-08-31 | United Kingdom | Scotland | 2091313 | 15629 | 0 | 56.4907 | -4.2026 | 2022-09-01 04:21:03 | Scotland, United Kingdom | |||
3777575 | 3777575 | 2022-08-30 | United Kingdom | Scotland | 2087616 | 15618 | 0 | 56.4907 | -4.2026 | 2022-08-31 04:20:57 | Scotland, United Kingdom | |||
1684171 | 1684171 | 2022-08-29 | United Kingdom | Scotland | 2087616 | 15615 | 0 | 56.4907 | -4.2026 | 2022-08-30 04:21:03 | Scotland, United Kingdom | |||
1880655 | 1880655 | 2022-08-28 | United Kingdom | Scotland | 2087616 | 15612 | 0 | 56.4907 | -4.2026 | 2022-08-29 04:21:06 | Scotland, United Kingdom | |||
2099782 | 2099782 | 2022-08-27 | United Kingdom | Scotland | 2087616 | 15606 | 0 | 56.4907 | -4.2026 | 2022-08-28 04:21:02 | Scotland, United Kingdom | |||
1535597 | 1535597 | 2022-08-26 | United Kingdom | Scotland | 2087616 | 15603 | 0 | 56.4907 | -4.2026 | 2022-08-27 04:20:57 | Scotland, United Kingdom | |||
2832484 | 2832484 | 2022-08-25 | United Kingdom | Scotland | 2087616 | 15597 | 0 | 56.4907 | -4.2026 | 2022-08-26 04:21:02 | Scotland, United Kingdom | |||
2327017 | 2327017 | 2022-08-24 | United Kingdom | Scotland | 2083741 | 15594 | 0 | 56.4907 | -4.2026 | 2022-08-25 04:21:13 | Scotland, United Kingdom | |||
1254426 | 1254426 | 2022-08-23 | United Kingdom | Scotland | 2083741 | 15588 | 0 | 56.4907 | -4.2026 | 2022-08-24 04:20:46 | Scotland, United Kingdom | |||
2856530 | 2856530 | 2022-08-22 | United Kingdom | Scotland | 2083741 | 15583 | 0 | 56.4907 | -4.2026 | 2022-08-23 04:20:56 | Scotland, United Kingdom | |||
2406502 | 2406502 | 2022-08-21 | United Kingdom | Scotland | 2083741 | 15579 | 0 | 56.4907 | -4.2026 | 2022-08-22 04:20:38 | Scotland, United Kingdom | |||
3801580 | 3801580 | 2022-08-20 | United Kingdom | Scotland | 2083741 | 15573 | 0 | 56.4907 | -4.2026 | 2022-08-21 04:20:44 | Scotland, United Kingdom | |||
2367166 | 2367166 | 2022-08-19 | United Kingdom | Scotland | 2083741 | 15568 | 0 | 56.4907 | -4.2026 | 2022-08-20 04:21:01 | Scotland, United Kingdom | |||
1164837 | 1164837 | 2022-08-18 | United Kingdom | Scotland | 2083741 | 15558 | 0 | 56.4907 | -4.2026 | 2022-08-19 04:20:54 | Scotland, United Kingdom | |||
3954161 | 3954161 | 2022-08-17 | United Kingdom | Scotland | 2083741 | 15553 | 0 | 56.4907 | -4.2026 | 2022-08-18 04:21:11 | Scotland, United Kingdom | |||
994663 | 994663 | 2022-08-16 | United Kingdom | Scotland | 2079366 | 15547 | 0 | 56.4907 | -4.2026 | 2022-08-17 04:20:59 | Scotland, United Kingdom | |||
2497702 | 2497702 | 2022-08-15 | United Kingdom | Scotland | 2079366 | 15543 | 0 | 56.4907 | -4.2026 | 2022-08-16 04:20:58 | Scotland, United Kingdom | |||
3651252 | 3651252 | 2022-08-14 | United Kingdom | Scotland | 2079366 | 15533 | 0 | 56.4907 | -4.2026 | 2022-08-15 04:20:59 | Scotland, United Kingdom | |||
1972258 | 1972258 | 2022-08-13 | United Kingdom | Scotland | 2079366 | 15521 | 0 | 56.4907 | -4.2026 | 2022-08-14 04:20:55 | Scotland, United Kingdom | |||
2892067 | 2892067 | 2022-08-12 | United Kingdom | Scotland | 2079366 | 15518 | 0 | 56.4907 | -4.2026 | 2022-08-13 04:20:52 | Scotland, United Kingdom | |||
3911672 | 3911672 | 2022-08-11 | United Kingdom | Scotland | 2079366 | 15511 | 0 | 56.4907 | -4.2026 | 2022-08-12 04:20:54 | Scotland, United Kingdom | |||
1349989 | 1349989 | 2022-08-10 | United Kingdom | Scotland | 2079366 | 15502 | 0 | 56.4907 | -4.2026 | 2022-08-11 04:20:49 | Scotland, United Kingdom | |||
1089744 | 1089744 | 2022-08-09 | United Kingdom | Scotland | 2074217 | 15499 | 0 | 56.4907 | -4.2026 | 2022-08-10 04:20:57 | Scotland, United Kingdom | |||
3547159 | 3547159 | 2022-08-08 | United Kingdom | Scotland | 2074217 | 15489 | 0 | 56.4907 | -4.2026 | 2022-08-09 04:20:34 | Scotland, United Kingdom | |||
1073562 | 1073562 | 2022-08-07 | United Kingdom | Scotland | 2074217 | 15474 | 0 | 56.4907 | -4.2026 | 2022-08-08 04:21:08 | Scotland, United Kingdom | |||
1944150 | 1944150 | 2022-08-06 | United Kingdom | Scotland | 2074217 | 15466 | 0 | 56.4907 | -4.2026 | 2022-08-07 04:20:54 | Scotland, United Kingdom | |||
883949 | 883949 | 2022-08-05 | United Kingdom | Scotland | 2074217 | 15459 | 0 | 56.4907 | -4.2026 | 2022-08-06 04:20:56 | Scotland, United Kingdom | |||
2012360 | 2012360 | 2022-08-04 | United Kingdom | Scotland | 2074217 | 15449 | 0 | 56.4907 | -4.2026 | 2022-08-05 04:20:52 | Scotland, United Kingdom | |||
1101787 | 1101787 | 2022-08-03 | United Kingdom | Scotland | 2074217 | 15440 | 0 | 56.4907 | -4.2026 | 2022-08-04 04:20:58 | Scotland, United Kingdom | |||
1408712 | 1408712 | 2022-08-02 | United Kingdom | Scotland | 2067712 | 15433 | 0 | 56.4907 | -4.2026 | 2022-08-03 04:20:59 | Scotland, United Kingdom | |||
3620750 | 3620750 | 2022-08-01 | United Kingdom | Scotland | 2067712 | 15423 | 0 | 56.4907 | -4.2026 | 2022-08-02 04:20:53 | Scotland, United Kingdom | |||
3875230 | 3875230 | 2022-07-31 | United Kingdom | Scotland | 2067712 | 15416 | 0 | 56.4907 | -4.2026 | 2022-08-01 04:21:03 | Scotland, United Kingdom | |||
677984 | 677984 | 2022-07-30 | United Kingdom | Scotland | 2067712 | 15403 | 0 | 56.4907 | -4.2026 | 2022-07-31 04:21:02 | Scotland, United Kingdom | |||
1787183 | 1787183 | 2022-07-29 | United Kingdom | Scotland | 2067712 | 15395 | 0 | 56.4907 | -4.2026 | 2022-07-30 04:20:42 | Scotland, United Kingdom | |||
1069546 | 1069546 | 2022-07-28 | United Kingdom | Scotland | 2067712 | 15389 | 0 | 56.4907 | -4.2026 | 2022-07-29 04:20:45 | Scotland, United Kingdom | |||
2339065 | 2339065 | 2022-07-27 | United Kingdom | Scotland | 2067712 | 15378 | 0 | 56.4907 | -4.2026 | 2022-07-28 04:20:56 | Scotland, United Kingdom | |||
1491255 | 1491255 | 2022-07-26 | United Kingdom | Scotland | 2058616 | 15371 | 0 | 56.4907 | -4.2026 | 2022-07-27 04:21:04 | Scotland, United Kingdom | |||
2597701 | 2597701 | 2022-07-25 | United Kingdom | Scotland | 2058616 | 15356 | 0 | 56.4907 | -4.2026 | 2022-07-26 04:20:58 | Scotland, United Kingdom | |||
899816 | 899816 | 2022-07-24 | United Kingdom | Scotland | 2058616 | 15346 | 0 | 56.4907 | -4.2026 | 2022-07-25 04:20:51 | Scotland, United Kingdom | |||
94810 | 94810 | 2022-07-23 | United Kingdom | Scotland | 2058616 | 15332 | 0 | 56.4907 | -4.2026 | 2022-07-24 04:20:47 | Scotland, United Kingdom | |||
903832 | 903832 | 2022-07-22 | United Kingdom | Scotland | 2058616 | 15318 | 0 | 56.4907 | -4.2026 | 2022-07-23 04:20:53 | Scotland, United Kingdom | |||
673968 | 673968 | 2022-07-21 | United Kingdom | Scotland | 2058616 | 15305 | 0 | 56.4907 | -4.2026 | 2022-07-22 04:21:15 | Scotland, United Kingdom | |||
1611931 | 1611931 | 2022-07-20 | United Kingdom | Scotland | 2058616 | 15289 | 0 | 56.4907 | -4.2026 | 2022-07-21 04:21:10 | Scotland, United Kingdom | |||
962564 | 962564 | 2022-07-19 | United Kingdom | Scotland | 2045821 | 15279 | 0 | 56.4907 | -4.2026 | 2022-07-20 04:20:59 | Scotland, United Kingdom | |||
3213951 | 3213951 | 2022-07-18 | United Kingdom | Scotland | 2045821 | 15269 | 0 | 56.4907 | -4.2026 | 2022-07-19 04:20:58 | Scotland, United Kingdom | |||
3409126 | 3409126 | 2022-07-17 | United Kingdom | Scotland | 2045821 | 15257 | 0 | 56.4907 | -4.2026 | 2022-07-18 04:20:59 | Scotland, United Kingdom | |||
2155326 | 2155326 | 2022-07-16 | United Kingdom | Scotland | 2045821 | 15242 | 0 | 56.4907 | -4.2026 | 2022-07-17 04:21:15 | Scotland, United Kingdom | |||
2422559 | 2422559 | 2022-07-15 | United Kingdom | Scotland | 2045821 | 15231 | 0 | 56.4907 | -4.2026 | 2022-07-16 04:21:05 | Scotland, United Kingdom | |||
3432634 | 3432634 | 2022-07-14 | United Kingdom | Scotland | 2045821 | 15225 | 0 | 56.4907 | -4.2026 | 2022-07-15 04:20:53 | Scotland, United Kingdom | |||
3113154 | 3113154 | 2022-07-13 | United Kingdom | Scotland | 2045821 | 15215 | 0 | 56.4907 | -4.2026 | 2022-07-14 04:20:57 | Scotland, United Kingdom | |||
633577 | 633577 | 2022-07-12 | United Kingdom | Scotland | 2028133 | 15200 | 0 | 56.4907 | -4.2026 | 2022-07-13 04:20:58 | Scotland, United Kingdom | |||
1215220 | 1215220 | 2022-07-11 | United Kingdom | Scotland | 2028133 | 15187 | 0 | 56.4907 | -4.2026 | 2022-07-12 04:20:51 | Scotland, United Kingdom | |||
2792702 | 2792702 | 2022-07-10 | United Kingdom | Scotland | 2028133 | 15171 | 0 | 56.4907 | -4.2026 | 2022-07-11 04:20:46 | Scotland, United Kingdom | |||
145655 | 145655 | 2022-07-09 | United Kingdom | Scotland | 2028133 | 15156 | 0 | 56.4907 | -4.2026 | 2022-07-10 04:20:54 | Scotland, United Kingdom | |||
1420755 | 1420755 | 2022-07-08 | United Kingdom | Scotland | 2028133 | 15146 | 0 | 56.4907 | -4.2026 | 2022-07-09 04:20:59 | Scotland, United Kingdom | |||
2744680 | 2744680 | 2022-07-07 | United Kingdom | Scotland | 2028133 | 15131 | 0 | 56.4907 | -4.2026 | 2022-07-08 04:20:56 | Scotland, United Kingdom | |||
1203475 | 1203475 | 2022-07-06 | United Kingdom | Scotland | 2028133 | 15121 | 0 | 56.4907 | -4.2026 | 2022-07-07 04:20:55 | Scotland, United Kingdom | |||
3970218 | 3970218 | 2022-07-05 | United Kingdom | Scotland | 2005335 | 15106 | 0 | 56.4907 | -4.2026 | 2022-07-06 04:20:58 | Scotland, United Kingdom | |||
3081729 | 3081729 | 2022-07-04 | United Kingdom | Scotland | 2005335 | 15094 | 0 | 56.4907 | -4.2026 | 2022-07-05 04:20:45 | Scotland, United Kingdom | |||
1771011 | 1771011 | 2022-07-03 | United Kingdom | Scotland | 2005335 | 15083 | 0 | 56.4907 | -4.2026 | 2022-07-04 04:20:54 | Scotland, United Kingdom | |||
3368997 | 3368997 | 2022-07-02 | United Kingdom | Scotland | 2005335 | 15075 | 0 | 56.4907 | -4.2026 | 2022-07-03 04:20:59 | Scotland, United Kingdom | |||
597326 | 597326 | 2022-07-01 | United Kingdom | Scotland | 2005335 | 15059 | 0 | 56.4907 | -4.2026 | 2022-07-02 04:21:16 | Scotland, United Kingdom | |||
3943727 | 3943727 | 2022-06-30 | United Kingdom | Scotland | 2005335 | 15050 | 0 | 56.4907 | -4.2026 | 2022-07-01 04:21:10 | Scotland, United Kingdom | |||
2493685 | 2493685 | 2022-06-29 | United Kingdom | Scotland | 2005335 | 15035 | 0 | 56.4907 | -4.2026 | 2022-06-30 04:21:01 | Scotland, United Kingdom | |||
2243067 | 2243067 | 2022-06-28 | United Kingdom | Scotland | 1990859 | 15027 | 0 | 56.4907 | -4.2026 | 2022-06-29 04:20:59 | Scotland, United Kingdom | |||
2151309 | 2151309 | 2022-06-27 | United Kingdom | Scotland | 1990859 | 15010 | 0 | 56.4907 | -4.2026 | 2022-06-28 04:20:58 | Scotland, United Kingdom | |||
479110 | 479110 | 2022-06-26 | United Kingdom | Scotland | 1990859 | 14999 | 0 | 56.4907 | -4.2026 | 2022-06-27 04:21:00 | Scotland, United Kingdom | |||
942485 | 942485 | 2022-06-25 | United Kingdom | Scotland | 1990859 | 14992 | 0 | 56.4907 | -4.2026 | 2022-06-26 04:21:02 | Scotland, United Kingdom | |||
3350305 | 3350305 | 2022-06-24 | United Kingdom | Scotland | 1990859 | 14985 | 0 | 56.4907 | -4.2026 | 2022-06-25 04:20:57 | Scotland, United Kingdom | |||
1652046 | 1652046 | 2022-06-23 | United Kingdom | Scotland | 1990859 | 14979 | 0 | 56.4907 | -4.2026 | 2022-06-24 04:20:58 | Scotland, United Kingdom | |||
2191281 | 2191281 | 2022-06-22 | United Kingdom | Scotland | 1990859 | 14970 | 0 | 56.4907 | -4.2026 | 2022-06-23 04:20:55 | Scotland, United Kingdom | |||
169712 | 169712 | 2022-06-21 | United Kingdom | Scotland | 1975331 | 14959 | 0 | 56.4907 | -4.2026 | 2022-06-22 04:20:54 | Scotland, United Kingdom | |||
1766995 | 1766995 | 2022-06-20 | United Kingdom | Scotland | 1975331 | 14944 | 0 | 56.4907 | -4.2026 | 2022-06-21 04:20:56 | Scotland, United Kingdom | |||
3273181 | 3273181 | 2022-06-19 | United Kingdom | Scotland | 1975331 | 14940 | 0 | 56.4907 | -4.2026 | 2022-06-20 04:21:01 | Scotland, United Kingdom | |||
3401093 | 3401093 | 2022-06-18 | United Kingdom | Scotland | 1975331 | 14931 | 0 | 56.4907 | -4.2026 | 2022-06-19 04:20:51 | Scotland, United Kingdom | |||
2314970 | 2314970 | 2022-06-17 | United Kingdom | Scotland | 1975331 | 14926 | 0 | 56.4907 | -4.2026 | 2022-06-18 04:21:10 | Scotland, United Kingdom | |||
562474 | 562474 | 2022-06-16 | United Kingdom | Scotland | 1975331 | 14921 | 0 | 56.4907 | -4.2026 | 2022-06-17 04:20:56 | Scotland, United Kingdom | |||
3986276 | 3986276 | 2022-06-15 | United Kingdom | Scotland | 1975331 | 14914 | 0 | 56.4907 | -4.2026 | 2022-06-16 04:20:55 | Scotland, United Kingdom | |||
950517 | 950517 | 2022-06-14 | United Kingdom | Scotland | 1963426 | 14908 | 0 | 56.4907 | -4.2026 | 2022-06-15 04:20:54 | Scotland, United Kingdom | |||
2982925 | 2982925 | 2022-06-13 | United Kingdom | Scotland | 1963426 | 14902 | 0 | 56.4907 | -4.2026 | 2022-06-14 04:20:52 | 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]);