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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
2239051 | 2239051 | 2022-06-12 | United Kingdom | Scotland | 1963426 | 14894 | 0 | 56.4907 | -4.2026 | 2022-06-13 04:21:14 | Scotland, United Kingdom | |||
3145249 | 3145249 | 2022-06-11 | United Kingdom | Scotland | 1963426 | 14887 | 0 | 56.4907 | -4.2026 | 2022-06-12 04:20:53 | Scotland, United Kingdom | |||
1948165 | 1948165 | 2022-06-10 | United Kingdom | Scotland | 1963426 | 14883 | 0 | 56.4907 | -4.2026 | 2022-06-11 04:21:01 | Scotland, United Kingdom | |||
3161304 | 3161304 | 2022-06-09 | United Kingdom | Scotland | 1963426 | 14873 | 0 | 56.4907 | -4.2026 | 2022-06-10 04:20:55 | Scotland, United Kingdom | |||
1424771 | 1424771 | 2022-06-08 | United Kingdom | Scotland | 1963426 | 14868 | 0 | 56.4907 | -4.2026 | 2022-06-09 04:20:54 | Scotland, United Kingdom | |||
3729885 | 3729885 | 2022-06-07 | United Kingdom | Scotland | 1958838 | 14859 | 0 | 56.4907 | -4.2026 | 2022-06-08 04:20:55 | Scotland, United Kingdom | |||
3891287 | 3891287 | 2022-06-06 | United Kingdom | Scotland | 1958838 | 14855 | 0 | 56.4907 | -4.2026 | 2022-06-07 04:21:08 | Scotland, United Kingdom | |||
3511056 | 3511056 | 2022-06-05 | United Kingdom | Scotland | 1955185 | 14853 | 0 | 56.4907 | -4.2026 | 2022-06-06 04:20:57 | Scotland, United Kingdom | |||
3531133 | 3531133 | 2022-06-04 | United Kingdom | Scotland | 1955185 | 14849 | 0 | 56.4907 | -4.2026 | 2022-06-05 04:20:55 | Scotland, United Kingdom | |||
3137219 | 3137219 | 2022-06-03 | United Kingdom | Scotland | 1955185 | 14844 | 0 | 56.4907 | -4.2026 | 2022-06-04 04:20:58 | Scotland, United Kingdom | |||
3582294 | 3582294 | 2022-06-02 | United Kingdom | Scotland | 1955185 | 14841 | 0 | 56.4907 | -4.2026 | 2022-06-03 04:20:58 | Scotland, United Kingdom | |||
974587 | 974587 | 2022-06-01 | United Kingdom | Scotland | 1955185 | 14833 | 0 | 56.4907 | -4.2026 | 2022-06-02 05:20:39 | Scotland, United Kingdom | |||
232894 | 232894 | 2022-05-31 | United Kingdom | Scotland | 1955185 | 14833 | 0 | 56.4907 | -4.2026 | 2022-06-01 04:20:55 | Scotland, United Kingdom | |||
3189659 | 3189659 | 2022-05-30 | United Kingdom | Scotland | 1955185 | 14828 | 0 | 56.4907 | -4.2026 | 2022-05-31 04:20:51 | Scotland, United Kingdom | |||
3201808 | 3201808 | 2022-05-29 | United Kingdom | Scotland | 1951671 | 14823 | 0 | 56.4907 | -4.2026 | 2022-05-30 04:20:50 | Scotland, United Kingdom | |||
2728686 | 2728686 | 2022-05-28 | United Kingdom | Scotland | 1951671 | 14820 | 0 | 56.4907 | -4.2026 | 2022-05-29 04:20:53 | Scotland, United Kingdom | |||
1317867 | 1317867 | 2022-05-27 | United Kingdom | Scotland | 1951671 | 14818 | 0 | 56.4907 | -4.2026 | 2022-05-28 04:21:07 | Scotland, United Kingdom | |||
1853659 | 1853659 | 2022-05-26 | United Kingdom | Scotland | 1951671 | 14814 | 0 | 56.4907 | -4.2026 | 2022-05-27 04:20:56 | Scotland, United Kingdom | |||
2051535 | 2051535 | 2022-05-25 | United Kingdom | Scotland | 1960940 | 14811 | 0 | 56.4907 | -4.2026 | 2022-05-26 04:20:50 | Scotland, United Kingdom | |||
3002973 | 3002973 | 2022-05-24 | United Kingdom | Scotland | 1960940 | 14807 | 0 | 56.4907 | -4.2026 | 2022-05-25 04:20:56 | Scotland, United Kingdom | |||
3596694 | 3596694 | 2022-05-23 | United Kingdom | Scotland | 1960940 | 14798 | 0 | 56.4907 | -4.2026 | 2022-05-24 04:20:57 | Scotland, United Kingdom | |||
625546 | 625546 | 2022-05-22 | United Kingdom | Scotland | 1960940 | 14792 | 0 | 56.4907 | -4.2026 | 2022-05-26 04:20:50 | Scotland, United Kingdom | |||
1113242 | 1113242 | 2022-05-21 | United Kingdom | Scotland | 1949599 | 14785 | 0 | 56.4907 | -4.2026 | 2022-05-22 04:20:52 | Scotland, United Kingdom | |||
1172866 | 1172866 | 2022-05-20 | United Kingdom | Scotland | 1949599 | 14780 | 0 | 56.4907 | -4.2026 | 2022-05-21 04:20:58 | Scotland, United Kingdom | |||
3899629 | 3899629 | 2022-05-19 | United Kingdom | Scotland | 1949599 | 14769 | 0 | 56.4907 | -4.2026 | 2022-05-20 04:20:57 | Scotland, United Kingdom | |||
1188413 | 1188413 | 2022-05-18 | United Kingdom | Scotland | 1944429 | 14760 | 0 | 56.4907 | -4.2026 | 2022-05-19 04:20:54 | Scotland, United Kingdom | |||
3586310 | 3586310 | 2022-05-17 | United Kingdom | Scotland | 1944429 | 14757 | 0 | 56.4907 | -4.2026 | 2022-05-18 04:20:50 | Scotland, United Kingdom | |||
1507267 | 1507267 | 2022-05-16 | United Kingdom | Scotland | 1944429 | 14748 | 0 | 56.4907 | -4.2026 | 2022-05-17 04:20:59 | Scotland, United Kingdom | |||
2087626 | 2087626 | 2022-05-15 | United Kingdom | Scotland | 1939321 | 14738 | 0 | 56.4907 | -4.2026 | 2022-05-16 04:20:47 | Scotland, United Kingdom | |||
3358336 | 3358336 | 2022-05-14 | United Kingdom | Scotland | 1939321 | 14733 | 0 | 56.4907 | -4.2026 | 2022-05-15 04:20:53 | Scotland, United Kingdom | |||
661981 | 661981 | 2022-05-13 | United Kingdom | Scotland | 1939321 | 14728 | 0 | 56.4907 | -4.2026 | 2022-05-14 04:20:48 | Scotland, United Kingdom | |||
2537064 | 2537064 | 2022-05-12 | United Kingdom | Scotland | 1939321 | 14727 | 0 | 56.4907 | -4.2026 | 2022-05-13 04:20:51 | Scotland, United Kingdom | |||
3448510 | 3448510 | 2022-05-11 | United Kingdom | Scotland | 1935488 | 14718 | 0 | 56.4907 | -4.2026 | 2022-05-12 04:20:54 | Scotland, United Kingdom | |||
3539127 | 3539127 | 2022-05-10 | United Kingdom | Scotland | 1935488 | 14703 | 0 | 56.4907 | -4.2026 | 2022-05-11 04:20:48 | Scotland, United Kingdom | |||
225662 | 225662 | 2022-05-09 | United Kingdom | Scotland | 1935488 | 14696 | 0 | 56.4907 | -4.2026 | 2022-05-10 04:20:50 | Scotland, United Kingdom | |||
2335047 | 2335047 | 2022-05-08 | United Kingdom | Scotland | 1931816 | 14691 | 0 | 56.4907 | -4.2026 | 2022-05-09 04:20:54 | Scotland, United Kingdom | |||
364009 | 364009 | 2022-05-07 | United Kingdom | Scotland | 1931816 | 14685 | 0 | 56.4907 | -4.2026 | 2022-05-08 04:20:49 | Scotland, United Kingdom | |||
1401360 | 1401360 | 2022-05-06 | United Kingdom | Scotland | 1931816 | 14676 | 0 | 56.4907 | -4.2026 | 2022-05-07 04:21:09 | 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]);