johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
19,730 rows where country_or_region = "United Kingdom" sorted by last_update
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update (date)
day (date) >30 ✖
- 2020-04-04 19
- 2020-04-05 19
- 2020-04-06 19
- 2020-04-07 19
- 2020-04-08 19
- 2020-04-09 19
- 2020-04-10 19
- 2020-04-11 19
- 2020-04-12 19
- 2020-04-13 19
- 2020-04-14 19
- 2020-04-15 19
- 2020-04-16 19
- 2020-04-17 19
- 2020-04-18 19
- 2020-04-19 19
- 2020-04-20 19
- 2020-04-21 19
- 2020-04-22 19
- 2020-04-23 19
- 2020-04-27 19
- 2020-04-28 19
- 2020-04-29 19
- 2020-04-30 19
- 2020-05-01 19
- 2020-05-02 19
- 2020-05-03 19
- 2020-05-04 19
- 2020-05-05 19
- 2020-05-06 19
- …
province_or_state 20
- England 1,073
- Guernsey 1,073
- Jersey 1,073
- Northern Ireland 1,073
- Pitcairn Islands 1,073
- Scotland 1,073
- Unknown 1,073
- Wales 1,073
- Channel Islands 1,024
- Gibraltar 1,024
- Cayman Islands 1,019
- Montserrat 1,017
- Bermuda 1,016
- Isle of Man 1,015
- Saint Helena, Ascension and Tristan da Cunha 1,010
- Anguilla 1,007
- British Virgin Islands 1,007
- Turks and Caicos Islands 1,007
- Falkland Islands (Malvinas) 997
- Falkland Islands (Islas Malvinas) 3
country_or_region 1
- United Kingdom · 19,730 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update ▼ | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1802403 | 1802403 | 2020-01-22 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 1/22/2020 17:00 | ||||
1802404 | 1802404 | 2020-01-22 | United Kingdom | Guernsey | 0 | 0 | 0 | 49.448196 | -2.58949 | 1/22/2020 17:00 | ||||
1802407 | 1802407 | 2020-01-22 | United Kingdom | England | 0 | 0 | 0 | 52.3555 | -1.1743 | 1/22/2020 17:00 | ||||
1802408 | 1802408 | 2020-01-22 | United Kingdom | Northern Ireland | 0 | 0 | 0 | 54.7877 | -6.4923 | 1/22/2020 17:00 | ||||
1802409 | 1802409 | 2020-01-22 | United Kingdom | Scotland | 0 | 0 | 0 | 56.4907 | -4.2026 | 1/22/2020 17:00 | ||||
1802410 | 1802410 | 2020-01-22 | United Kingdom | Wales | 0 | 0 | 0 | 52.1307 | -3.7837 | 1/22/2020 17:00 | ||||
1802411 | 1802411 | 2020-01-22 | United Kingdom | Unknown | 0 | 0 | 0 | 55.3781 | -3.436 | 1/22/2020 17:00 | ||||
1802415 | 1802415 | 2020-01-22 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | -24.3768 | -128.3242 | 1/22/2020 17:00 | ||||
864447 | 864447 | 2020-01-23 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 1/23/20 17:00 | ||||
864448 | 864448 | 2020-01-23 | United Kingdom | Guernsey | 0 | 0 | 0 | 49.448196 | -2.58949 | 1/23/20 17:00 | ||||
864451 | 864451 | 2020-01-23 | United Kingdom | England | 0 | 0 | 0 | 52.3555 | -1.1743 | 1/23/20 17:00 | ||||
864452 | 864452 | 2020-01-23 | United Kingdom | Northern Ireland | 0 | 0 | 0 | 54.7877 | -6.4923 | 1/23/20 17:00 | ||||
864453 | 864453 | 2020-01-23 | United Kingdom | Scotland | 0 | 0 | 0 | 56.4907 | -4.2026 | 1/23/20 17:00 | ||||
864454 | 864454 | 2020-01-23 | United Kingdom | Wales | 0 | 0 | 0 | 52.1307 | -3.7837 | 1/23/20 17:00 | ||||
864455 | 864455 | 2020-01-23 | United Kingdom | Unknown | 0 | 0 | 0 | 55.3781 | -3.436 | 1/23/20 17:00 | ||||
864459 | 864459 | 2020-01-23 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | -24.3768 | -128.3242 | 1/23/20 17:00 | ||||
197825 | 197825 | 2020-01-24 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 1/24/20 17:00 | ||||
197826 | 197826 | 2020-01-24 | United Kingdom | Guernsey | 0 | 0 | 0 | 49.448196 | -2.58949 | 1/24/20 17:00 | ||||
197829 | 197829 | 2020-01-24 | United Kingdom | England | 0 | 0 | 0 | 52.3555 | -1.1743 | 1/24/20 17:00 | ||||
197830 | 197830 | 2020-01-24 | United Kingdom | Northern Ireland | 0 | 0 | 0 | 54.7877 | -6.4923 | 1/24/20 17:00 | ||||
197831 | 197831 | 2020-01-24 | United Kingdom | Scotland | 0 | 0 | 0 | 56.4907 | -4.2026 | 1/24/20 17:00 | ||||
197832 | 197832 | 2020-01-24 | United Kingdom | Wales | 0 | 0 | 0 | 52.1307 | -3.7837 | 1/24/20 17:00 | ||||
197833 | 197833 | 2020-01-24 | United Kingdom | Unknown | 0 | 0 | 0 | 55.3781 | -3.436 | 1/24/20 17:00 | ||||
197837 | 197837 | 2020-01-24 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | -24.3768 | -128.3242 | 1/24/20 17:00 | ||||
2939000 | 2939000 | 2020-01-25 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 1/25/20 17:00 | ||||
2939001 | 2939001 | 2020-01-25 | United Kingdom | Guernsey | 0 | 0 | 0 | 49.448196 | -2.58949 | 1/25/20 17:00 | ||||
2939004 | 2939004 | 2020-01-25 | United Kingdom | England | 0 | 0 | 0 | 52.3555 | -1.1743 | 1/25/20 17:00 | ||||
2939005 | 2939005 | 2020-01-25 | United Kingdom | Northern Ireland | 0 | 0 | 0 | 54.7877 | -6.4923 | 1/25/20 17:00 | ||||
2939006 | 2939006 | 2020-01-25 | United Kingdom | Scotland | 0 | 0 | 0 | 56.4907 | -4.2026 | 1/25/20 17:00 | ||||
2939007 | 2939007 | 2020-01-25 | United Kingdom | Wales | 0 | 0 | 0 | 52.1307 | -3.7837 | 1/25/20 17:00 | ||||
2939008 | 2939008 | 2020-01-25 | United Kingdom | Unknown | 0 | 0 | 0 | 55.3781 | -3.436 | 1/25/20 17:00 | ||||
2939012 | 2939012 | 2020-01-25 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | -24.3768 | -128.3242 | 1/25/20 17:00 | ||||
415902 | 415902 | 2020-01-26 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 1/26/20 16:00 | ||||
415903 | 415903 | 2020-01-26 | United Kingdom | Guernsey | 0 | 0 | 0 | 49.448196 | -2.58949 | 1/26/20 16:00 | ||||
415906 | 415906 | 2020-01-26 | United Kingdom | England | 0 | 0 | 0 | 52.3555 | -1.1743 | 1/26/20 16:00 | ||||
415907 | 415907 | 2020-01-26 | United Kingdom | Northern Ireland | 0 | 0 | 0 | 54.7877 | -6.4923 | 1/26/20 16:00 | ||||
415908 | 415908 | 2020-01-26 | United Kingdom | Scotland | 0 | 0 | 0 | 56.4907 | -4.2026 | 1/26/20 16:00 | ||||
415909 | 415909 | 2020-01-26 | United Kingdom | Wales | 0 | 0 | 0 | 52.1307 | -3.7837 | 1/26/20 16:00 | ||||
415910 | 415910 | 2020-01-26 | United Kingdom | Unknown | 0 | 0 | 0 | 55.3781 | -3.436 | 1/26/20 16:00 | ||||
415914 | 415914 | 2020-01-26 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | -24.3768 | -128.3242 | 1/26/20 16:00 | ||||
3753131 | 3753131 | 2020-01-27 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 1/27/20 23:59 | ||||
3753132 | 3753132 | 2020-01-27 | United Kingdom | Guernsey | 0 | 0 | 0 | 49.448196 | -2.58949 | 1/27/20 23:59 | ||||
3753135 | 3753135 | 2020-01-27 | United Kingdom | England | 0 | 0 | 0 | 52.3555 | -1.1743 | 1/27/20 23:59 | ||||
3753136 | 3753136 | 2020-01-27 | United Kingdom | Northern Ireland | 0 | 0 | 0 | 54.7877 | -6.4923 | 1/27/20 23:59 | ||||
3753137 | 3753137 | 2020-01-27 | United Kingdom | Scotland | 0 | 0 | 0 | 56.4907 | -4.2026 | 1/27/20 23:59 | ||||
3753138 | 3753138 | 2020-01-27 | United Kingdom | Wales | 0 | 0 | 0 | 52.1307 | -3.7837 | 1/27/20 23:59 | ||||
3753139 | 3753139 | 2020-01-27 | United Kingdom | Unknown | 0 | 0 | 0 | 55.3781 | -3.436 | 1/27/20 23:59 | ||||
3753143 | 3753143 | 2020-01-27 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | -24.3768 | -128.3242 | 1/27/20 23:59 | ||||
1305829 | 1305829 | 2020-01-28 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 1/28/20 23:00 | ||||
1305830 | 1305830 | 2020-01-28 | United Kingdom | Guernsey | 0 | 0 | 0 | 49.448196 | -2.58949 | 1/28/20 23:00 | ||||
1305833 | 1305833 | 2020-01-28 | United Kingdom | England | 0 | 0 | 0 | 52.3555 | -1.1743 | 1/28/20 23:00 | ||||
1305834 | 1305834 | 2020-01-28 | United Kingdom | Northern Ireland | 0 | 0 | 0 | 54.7877 | -6.4923 | 1/28/20 23:00 | ||||
1305835 | 1305835 | 2020-01-28 | United Kingdom | Scotland | 0 | 0 | 0 | 56.4907 | -4.2026 | 1/28/20 23:00 | ||||
1305836 | 1305836 | 2020-01-28 | United Kingdom | Wales | 0 | 0 | 0 | 52.1307 | -3.7837 | 1/28/20 23:00 | ||||
1305837 | 1305837 | 2020-01-28 | United Kingdom | Unknown | 0 | 0 | 0 | 55.3781 | -3.436 | 1/28/20 23:00 | ||||
1305841 | 1305841 | 2020-01-28 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | -24.3768 | -128.3242 | 1/28/20 23:00 | ||||
197916 | 197916 | 2020-01-29 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 1/29/20 19:30 | ||||
197917 | 197917 | 2020-01-29 | United Kingdom | Guernsey | 0 | 0 | 0 | 49.448196 | -2.58949 | 1/29/20 19:30 | ||||
197920 | 197920 | 2020-01-29 | United Kingdom | England | 0 | 0 | 0 | 52.3555 | -1.1743 | 1/29/20 19:30 | ||||
197921 | 197921 | 2020-01-29 | United Kingdom | Northern Ireland | 0 | 0 | 0 | 54.7877 | -6.4923 | 1/29/20 19:30 | ||||
197922 | 197922 | 2020-01-29 | United Kingdom | Scotland | 0 | 0 | 0 | 56.4907 | -4.2026 | 1/29/20 19:30 | ||||
197923 | 197923 | 2020-01-29 | United Kingdom | Wales | 0 | 0 | 0 | 52.1307 | -3.7837 | 1/29/20 19:30 | ||||
197924 | 197924 | 2020-01-29 | United Kingdom | Unknown | 0 | 0 | 0 | 55.3781 | -3.436 | 1/29/20 19:30 | ||||
197928 | 197928 | 2020-01-29 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | -24.3768 | -128.3242 | 1/29/20 19:30 | ||||
1527572 | 1527572 | 2020-01-30 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 1/30/20 16:00 | ||||
1527573 | 1527573 | 2020-01-30 | United Kingdom | Guernsey | 0 | 0 | 0 | 49.448196 | -2.58949 | 1/30/20 16:00 | ||||
1527576 | 1527576 | 2020-01-30 | United Kingdom | England | 0 | 1 | 0 | 52.3555 | -1.1743 | 1/30/20 16:00 | ||||
1527577 | 1527577 | 2020-01-30 | United Kingdom | Northern Ireland | 0 | 0 | 0 | 54.7877 | -6.4923 | 1/30/20 16:00 | ||||
1527578 | 1527578 | 2020-01-30 | United Kingdom | Scotland | 0 | 0 | 0 | 56.4907 | -4.2026 | 1/30/20 16:00 | ||||
1527579 | 1527579 | 2020-01-30 | United Kingdom | Wales | 0 | 0 | 0 | 52.1307 | -3.7837 | 1/30/20 16:00 | ||||
1527580 | 1527580 | 2020-01-30 | United Kingdom | Unknown | 0 | 0 | 0 | 55.3781 | -3.436 | 1/30/20 16:00 | ||||
1527584 | 1527584 | 2020-01-30 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | -24.3768 | -128.3242 | 1/30/20 16:00 | ||||
3761224 | 3761224 | 2020-01-31 | United Kingdom | Unknown | 2 | 0 | 0 | 55.3781 | -3.436 | 1/31/2020 23:59 | ||||
3761261 | 3761261 | 2020-01-31 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 1/31/2020 23:59 | ||||
3761262 | 3761262 | 2020-01-31 | United Kingdom | Guernsey | 0 | 0 | 0 | 49.448196 | -2.58949 | 1/31/2020 23:59 | ||||
3761265 | 3761265 | 2020-01-31 | United Kingdom | England | 0 | 1 | 0 | 52.3555 | -1.1743 | 1/31/2020 23:59 | ||||
3761266 | 3761266 | 2020-01-31 | United Kingdom | Northern Ireland | 0 | 0 | 0 | 54.7877 | -6.4923 | 1/31/2020 23:59 | ||||
3761267 | 3761267 | 2020-01-31 | United Kingdom | Scotland | 0 | 0 | 0 | 56.4907 | -4.2026 | 1/31/2020 23:59 | ||||
3761268 | 3761268 | 2020-01-31 | United Kingdom | Wales | 0 | 0 | 0 | 52.1307 | -3.7837 | 1/31/2020 23:59 | ||||
3761272 | 3761272 | 2020-01-31 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | -24.3768 | -128.3242 | 1/31/2020 23:59 | ||||
3413231 | 3413231 | 2020-02-01 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 2/1/2020 11:53 | ||||
3413232 | 3413232 | 2020-02-01 | United Kingdom | Guernsey | 0 | 0 | 0 | 49.448196 | -2.58949 | 2/1/2020 11:53 | ||||
3413235 | 3413235 | 2020-02-01 | United Kingdom | England | 0 | 1 | 0 | 52.3555 | -1.1743 | 2/1/2020 11:53 | ||||
3413236 | 3413236 | 2020-02-01 | United Kingdom | Northern Ireland | 0 | 0 | 0 | 54.7877 | -6.4923 | 2/1/2020 11:53 | ||||
3413237 | 3413237 | 2020-02-01 | United Kingdom | Scotland | 0 | 0 | 0 | 56.4907 | -4.2026 | 2/1/2020 11:53 | ||||
3413238 | 3413238 | 2020-02-01 | United Kingdom | Wales | 0 | 0 | 0 | 52.1307 | -3.7837 | 2/1/2020 11:53 | ||||
3413242 | 3413242 | 2020-02-01 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | -24.3768 | -128.3242 | 2/1/2020 11:53 | ||||
3413187 | 3413187 | 2020-02-01 | United Kingdom | Unknown | 2 | 0 | 0 | 55.3781 | -3.436 | 2/1/2020 1:52 | ||||
566719 | 566719 | 2020-02-06 | United Kingdom | Unknown | 2 | 0 | 0 | 55.3781 | -3.436 | 2020-02-01T01:52:40 | ||||
2091712 | 2091712 | 2020-02-05 | United Kingdom | Unknown | 2 | 0 | 0 | 55.3781 | -3.436 | 2020-02-01T01:52:40 | ||||
2379278 | 2379278 | 2020-02-02 | United Kingdom | Unknown | 2 | 0 | 0 | 55.3781 | -3.436 | 2020-02-01T01:52:40 | ||||
2860592 | 2860592 | 2020-02-03 | United Kingdom | Unknown | 2 | 0 | 0 | 55.3781 | -3.436 | 2020-02-01T01:52:40 | ||||
3471928 | 3471928 | 2020-02-04 | United Kingdom | Unknown | 2 | 0 | 0 | 55.3781 | -3.436 | 2020-02-01T01:52:40 | ||||
2379319 | 2379319 | 2020-02-02 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 2020-02-02T23:43:02 | ||||
2379320 | 2379320 | 2020-02-02 | United Kingdom | Guernsey | 0 | 0 | 0 | 49.448196 | -2.58949 | 2020-02-02T23:43:02 | ||||
2379323 | 2379323 | 2020-02-02 | United Kingdom | England | 0 | 2 | 0 | 52.3555 | -1.1743 | 2020-02-02T23:43:02 | ||||
2379324 | 2379324 | 2020-02-02 | United Kingdom | Northern Ireland | 0 | 0 | 0 | 54.7877 | -6.4923 | 2020-02-02T23:43:02 | ||||
2379325 | 2379325 | 2020-02-02 | United Kingdom | Scotland | 0 | 0 | 0 | 56.4907 | -4.2026 | 2020-02-02T23:43:02 | ||||
2379326 | 2379326 | 2020-02-02 | United Kingdom | Wales | 0 | 0 | 0 | 52.1307 | -3.7837 | 2020-02-02T23:43:02 | ||||
2379330 | 2379330 | 2020-02-02 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-02-02T23:43:02 |
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]);