johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
81 rows where country_or_region = "United Kingdom" and fips = 82601 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2864396 | 2864396 | 2020-06-10 | United Kingdom | England | 82601 | 0 | 46930 | 0 | 0 | 52.3555 | -1.1743 | 2020-06-11 03:33:41 | England, United Kingdom | |
1211215 | 1211215 | 2020-06-09 | United Kingdom | England | 82601 | 0 | 46788 | 0 | 0 | 52.3555 | -1.1743 | 2020-06-10 04:07:00 | England, United Kingdom | |
217642 | 217642 | 2020-06-08 | United Kingdom | England | 82601 | 0 | 46661 | 0 | 0 | 52.3555 | -1.1743 | 2020-06-09 03:33:03 | England, United Kingdom | |
2800439 | 2800439 | 2020-06-07 | United Kingdom | England | 82601 | 0 | 46519 | 0 | 0 | 52.3555 | -1.1743 | 2020-06-08 03:33:22 | England, United Kingdom | |
574495 | 574495 | 2020-06-06 | United Kingdom | England | 82601 | 0 | 46382 | 0 | 0 | 52.3555 | -1.1743 | 2020-06-07 03:53:30 | England, United Kingdom | |
1270192 | 1270192 | 2020-06-05 | United Kingdom | England | 82601 | 0 | 46253 | 0 | 0 | 52.3555 | -1.1743 | 2020-06-06 02:33:00 | England, United Kingdom | |
1281653 | 1281653 | 2020-06-04 | United Kingdom | England | 82601 | 0 | 46093 | 0 | 0 | 52.3555 | -1.1743 | 2020-06-05 02:33:06 | England, United Kingdom | |
3867208 | 3867208 | 2020-06-03 | United Kingdom | England | 82601 | 0 | 45930 | 0 | 0 | 52.3555 | -1.1743 | 2020-06-04 02:33:14 | England, United Kingdom | |
2556250 | 2556250 | 2020-06-02 | United Kingdom | England | 82601 | 0 | 45751 | 0 | 0 | 52.3555 | -1.1743 | 2020-06-03 02:33:13 | England, United Kingdom | |
805787 | 805787 | 2020-06-01 | United Kingdom | England | 82601 | 0 | 45547 | 0 | 0 | 52.3555 | -1.1743 | 2020-06-02 02:33:08 | England, United Kingdom | |
1794323 | 1794323 | 2020-05-31 | United Kingdom | England | 82601 | 0 | 45368 | 0 | 0 | 52.3555 | -1.1743 | 2020-06-01 02:32:46 | England, United Kingdom | |
3639216 | 3639216 | 2020-05-30 | United Kingdom | England | 82601 | 0 | 45193 | 0 | 0 | 52.3555 | -1.1743 | 2020-05-31 02:32:45 | England, United Kingdom | |
1790756 | 1790756 | 2020-05-29 | United Kingdom | England | 82601 | 0 | 45005 | 0 | 0 | 52.3555 | -1.1743 | 2020-05-30 02:32:48 | England, United Kingdom | |
2712635 | 2712635 | 2020-05-28 | United Kingdom | England | 82601 | 0 | 44789 | 0 | 0 | 52.3555 | -1.1743 | 2020-05-29 02:32:50 | England, United Kingdom | |
2548554 | 2548554 | 2020-05-27 | United Kingdom | England | 82601 | 0 | 44548 | 0 | 0 | 52.3555 | -1.1743 | 2020-05-28 02:32:31 | England, United Kingdom | |
1041517 | 1041517 | 2020-05-26 | United Kingdom | England | 82601 | 0 | 44315 | 0 | 0 | 52.3555 | -1.1743 | 2020-05-27 02:32:31 | England, United Kingdom | |
1105247 | 1105247 | 2020-05-25 | United Kingdom | England | 82601 | 0 | 44055 | 0 | 0 | 52.3555 | -1.1743 | 2020-05-26 02:32:35 | England, United Kingdom | |
875927 | 875927 | 2020-05-24 | United Kingdom | England | 82601 | 0 | 43815 | 0 | 0 | 52.3555 | -1.1743 | 2020-05-25 02:32:44 | England, United Kingdom | |
998118 | 998118 | 2020-05-23 | United Kingdom | England | 82601 | 0 | 43581 | 0 | 0 | 52.3555 | -1.1743 | 2020-05-24 02:32:43 | England, United Kingdom | |
1865141 | 1865141 | 2020-05-22 | United Kingdom | England | 82601 | 0 | 43326 | 0 | 0 | 52.3555 | -1.1743 | 2020-05-23 02:32:42 | England, United Kingdom | |
268647 | 268647 | 2020-05-21 | United Kingdom | England | 82601 | 0 | 43070 | 0 | 0 | 52.3555 | -1.1743 | 2020-05-22 02:36:51 | England, United Kingdom | |
1432230 | 1432230 | 2020-05-20 | United Kingdom | England | 82601 | 0 | 42784 | 0 | 0 | 52.3555 | -1.1743 | 2020-05-21 02:32:48 | England, United Kingdom | |
2390450 | 2390450 | 2020-05-19 | United Kingdom | England | 82601 | 0 | 42481 | 0 | 0 | 52.3555 | -1.1743 | 2020-05-20 02:32:19 | England, United Kingdom | |
3261188 | 3261188 | 2020-05-18 | United Kingdom | England | 82601 | 0 | 42165 | 0 | 0 | 52.3555 | -1.1743 | 2020-05-19 02:32:18 | England, United Kingdom | |
3416582 | 3416582 | 2020-05-17 | United Kingdom | England | 82601 | 0 | 41821 | 0 | 0 | 52.3555 | -1.1743 | 2020-05-18 02:32:21 | England, United Kingdom | |
1829816 | 1829816 | 2020-05-16 | United Kingdom | England | 82601 | 0 | 41505 | 0 | 0 | 52.3555 | -1.1743 | 2020-05-17 02:32:32 | England, United Kingdom | |
3276532 | 3276532 | 2020-05-15 | United Kingdom | England | 82601 | 0 | 41154 | 0 | 0 | 52.3555 | -1.1743 | 2020-05-16 02:32:19 | England, United Kingdom | |
1404706 | 1404706 | 2020-05-14 | United Kingdom | England | 82601 | 0 | 40795 | 0 | 0 | 52.3555 | -1.1743 | 2020-05-15 02:33:02 | England, United Kingdom | |
3847469 | 3847469 | 2020-05-13 | United Kingdom | England | 82601 | 0 | 40422 | 0 | 0 | 52.3555 | -1.1743 | 2020-05-14 03:32:28 | England, United Kingdom | |
2581675 | 2581675 | 2020-05-12 | United Kingdom | England | 82601 | 0 | 40049 | 0 | 0 | 52.3555 | -1.1743 | 2020-05-13 03:32:26 | England, United Kingdom | |
3331209 | 3331209 | 2020-05-11 | United Kingdom | England | 82601 | 0 | 39669 | 0 | 0 | 52.3555 | -1.1743 | 2020-05-12 03:32:27 | England, United Kingdom | |
3459824 | 3459824 | 2020-05-10 | United Kingdom | England | 82601 | 0 | 39314 | 0 | 0 | 52.3555 | -1.1743 | 2020-05-11 02:32:30 | England, United Kingdom | |
2899365 | 2899365 | 2020-05-09 | United Kingdom | England | 82601 | 0 | 38891 | 0 | 0 | 52.3555 | -1.1743 | 2020-05-10 02:32:30 | England, United Kingdom | |
114414 | 114414 | 2020-05-08 | United Kingdom | England | 82601 | 0 | 38428 | 0 | 0 | 52.3555 | -1.1743 | 2020-05-09 02:32:35 | England, United Kingdom | |
3295857 | 3295857 | 2020-05-07 | United Kingdom | England | 82601 | 0 | 37946 | 0 | 0 | 52.3555 | -1.1743 | 2020-05-08 02:32:32 | England, United Kingdom | |
2111078 | 2111078 | 2020-05-06 | United Kingdom | England | 82601 | 0 | 37411 | 0 | 0 | 52.3555 | -1.1743 | 2020-05-07 02:32:28 | England, United Kingdom | |
1932116 | 1932116 | 2020-05-05 | United Kingdom | England | 82601 | 0 | 36887 | 0 | 0 | 52.3555 | -1.1743 | 2020-05-06 02:32:31 | England, United Kingdom | |
3084979 | 3084979 | 2020-05-04 | United Kingdom | England | 82601 | 0 | 36350 | 0 | 0 | 52.3555 | -1.1743 | 2020-05-05 02:32:34 | England, United Kingdom | |
2278838 | 2278838 | 2020-05-03 | United Kingdom | England | 82601 | 0 | 35788 | 0 | 0 | 52.3555 | -1.1743 | 2020-05-04 02:32:28 | England, United Kingdom | |
2043514 | 2043514 | 2020-05-02 | United Kingdom | England | 82601 | 0 | 35232 | 0 | 0 | 52.3555 | -1.1743 | 2020-05-03 02:32:28 | England, United Kingdom | |
1184408 | 1184408 | 2020-05-01 | United Kingdom | England | 82601 | 0 | 34642 | 0 | 0 | 52.3555 | -1.1743 | 2020-05-02 02:32:27 | England, United Kingdom | |
228889 | 228889 | 2020-04-30 | United Kingdom | England | 82601 | 0 | 33981 | 0 | 0 | 52.3555 | -1.1743 | 2020-05-01 02:32:28 | England, United Kingdom | |
137634 | 137634 | 2020-04-29 | United Kingdom | England | 82601 | 0 | 33321 | 0 | 0 | 52.3555 | -1.1743 | 2020-04-30 02:32:27 | England, United Kingdom | |
271848 | 271848 | 2020-04-28 | United Kingdom | England | 82601 | 0 | 32622 | 0 | 0 | 52.3555 | -1.1743 | 2020-04-29 02:32:29 | England, United Kingdom | |
3589511 | 3589511 | 2020-04-27 | United Kingdom | England | 82601 | 0 | 31921 | 0 | 0 | 52.3555 | -1.1743 | 2020-04-28 02:30:51 | England, United Kingdom | |
3592689 | 3592689 | 2020-04-26 | United Kingdom | England | 82601 | 0 | 31197 | 0 | 0 | 52.3555 | -1.1743 | 2020-04-27 02:30:52 | England, United Kingdom | |
3503038 | 3503038 | 2020-04-25 | United Kingdom | England | 82601 | 0 | 30434 | 0 | 0 | 52.3555 | -1.1743 | 2020-04-26 02:30:51 | England, United Kingdom | |
1459439 | 1459439 | 2020-04-24 | United Kingdom | England | 82601 | 0 | 29663 | 0 | 0 | 52.3555 | -1.1743 | 2020-04-25 06:30:53 | England, United Kingdom | |
2525028 | 2525028 | 2020-04-23 | United Kingdom | England | 82601 | 0 | 28789 | 0 | 0 | 52.3555 | -1.1743 | 2020-04-24 03:30:50 | England, United Kingdom | |
1199470 | 1199470 | 2020-04-22 | United Kingdom | England | 82601 | 0 | 27896 | 0 | 0 | 52.3555 | -1.1743 | 2020-04-22 23:30:53 | England, United Kingdom | |
522536 | 522536 | 2020-04-21 | United Kingdom | England | 82601 | 0 | 26957 | 0 | 0 | 52.3555 | -1.1743 | 2020-04-21 23:30:50 | England, United Kingdom | |
2473618 | 2473618 | 2020-04-20 | United Kingdom | England | 82601 | 0 | 26041 | 0 | 0 | 52.3555 | -1.1743 | 2020-04-20 23:36:47 | England, United Kingdom | |
1385310 | 1385310 | 2020-04-19 | United Kingdom | England | 82601 | 0 | 25049 | 0 | 0 | 52.3555 | -1.1743 | 2020-04-19 23:41:01 | England, United Kingdom | |
418998 | 418998 | 2020-04-18 | United Kingdom | England | 82601 | 0 | 24082 | 0 | 0 | 52.3555 | -1.1743 | 2020-04-18 22:32:47 | England, United Kingdom | |
50470 | 50470 | 2020-04-17 | United Kingdom | England | 82601 | 0 | 23052 | 0 | 0 | 52.3555 | -1.1743 | 2020-04-17 23:30:52 | England, United Kingdom | |
934464 | 934464 | 2020-04-16 | United Kingdom | England | 82601 | 0 | 21945 | 0 | 0 | 52.3555 | -1.1743 | 2020-04-16 23:30:51 | England, United Kingdom | |
860358 | 860358 | 2020-04-15 | United Kingdom | England | 82601 | 0 | 20798 | 0 | 0 | 52.3555 | -1.1743 | 2020-04-15 22:56:51 | England, United Kingdom | |
3338274 | 3338274 | 2020-04-14 | United Kingdom | England | 82601 | 0 | 19698 | 0 | 0 | 52.3555 | -1.1743 | 2020-04-14 23:33:31 | England, United Kingdom | |
43371 | 43371 | 2020-04-13 | United Kingdom | England | 82601 | 0 | 18618 | 0 | 0 | 52.3555 | -1.1743 | 2020-04-13 23:07:54 | England, United Kingdom | |
2578398 | 2578398 | 2020-04-12 | United Kingdom | England | 82601 | 0 | 17542 | 0 | 0 | 52.3555 | -1.1743 | 2020-04-12 23:18:00 | England, United Kingdom | |
2567235 | 2567235 | 2020-04-11 | United Kingdom | England | 82601 | 0 | 16334 | 0 | 0 | 52.3555 | -1.1743 | 2020-04-11 22:45:33 | England, United Kingdom | |
1250420 | 1250420 | 2020-04-10 | United Kingdom | England | 82601 | 0 | 15131 | 0 | 0 | 52.3555 | -1.1743 | 2020-04-10 22:54:07 | England, United Kingdom | |
3950155 | 3950155 | 2020-04-09 | United Kingdom | England | 82601 | 0 | 13968 | 0 | 0 | 52.3555 | -1.1743 | 2020-04-09 23:02:37 | England, United Kingdom | |
3562262 | 3562262 | 2020-04-08 | United Kingdom | England | 82601 | 0 | 12791 | 0 | 0 | 52.3555 | -1.1743 | 2020-04-08 22:51:58 | England, United Kingdom | |
3021937 | 3021937 | 2020-04-07 | United Kingdom | England | 82601 | 0 | 11505 | 0 | 0 | 52.3555 | -1.1743 | 2020-04-07 23:04:49 | England, United Kingdom | |
3627620 | 3627620 | 2020-04-06 | United Kingdom | England | 82601 | 0 | 10360 | 0 | 0 | 52.3555 | -1.1743 | 4/6/20 23:22 | England, United Kingdom | |
589307 | 589307 | 2020-04-05 | United Kingdom | England | 82601 | 0 | 9335 | 0 | 0 | 52.3555 | -1.1743 | 2020-04-05 23:06:45 | England, United Kingdom | |
1750949 | 1750949 | 2020-04-04 | United Kingdom | England | 82601 | 0 | 8272 | 0 | 0 | 52.3555 | -1.1743 | 4/4/20 23:34 | England, United Kingdom | |
3740760 | 3740760 | 2020-04-03 | United Kingdom | England | 82601 | 0 | 7249 | 0 | 0 | 52.3555 | -1.1743 | 2020-04-03 22:46:37 | England, United Kingdom | |
3701790 | 3701790 | 2020-04-02 | United Kingdom | England | 82601 | 0 | 6322 | 0 | 0 | 52.3555 | -1.1743 | 4/2/20 23:25 | England, United Kingdom | |
3364992 | 3364992 | 2020-04-01 | United Kingdom | England | 82601 | 0 | 5430 | 0 | 0 | 52.3555 | -1.1743 | 2020-04-01 21:58:49 | England, United Kingdom | |
3816085 | 3816085 | 2020-03-31 | United Kingdom | England | 82601 | 0 | 4604 | 0 | 0 | 52.3555 | -1.1743 | 2020-03-31 23:43:56 | England, United Kingdom | |
1872635 | 1872635 | 2020-03-30 | United Kingdom | England | 82601 | 0 | 3863 | 0 | 0 | 52.3555 | -1.1743 | 3/30/20 22:52 | England, United Kingdom | |
2875871 | 2875871 | 2020-03-29 | United Kingdom | England | 82601 | 0 | 3232 | 0 | 0 | 52.3555 | -1.1743 | 3/29/20 23:08 | England, United Kingdom | |
3947207 | 3947207 | 2020-03-28 | United Kingdom | England | 82601 | 0 | 2701 | 0 | 0 | 52.3555 | -1.1743 | 3/28/20 23:05 | England, United Kingdom | |
809255 | 809255 | 2020-03-27 | United Kingdom | England | 82601 | 0 | 2252 | 0 | 0 | 52.3555 | -1.1743 | 2020-03-27 22:14:55 | England, United Kingdom | |
919347 | 919347 | 2020-03-26 | United Kingdom | England | 82601 | 0 | 1836 | 0 | 0 | 52.3555 | -1.1743 | 2020-03-26 23:48:35 | England, United Kingdom | |
1132746 | 1132746 | 2020-03-25 | United Kingdom | England | 82601 | 0 | 1466 | 0 | 0 | 52.3555 | -1.1743 | 2020-03-25 23:33:19 | England, United Kingdom | |
1479250 | 1479250 | 2020-03-24 | United Kingdom | England | 82601 | 0 | 1167 | 0 | 0 | 52.3555 | -1.1743 | 2020-03-24 23:37:31 | England, United Kingdom | |
2147304 | 2147304 | 2020-03-23 | United Kingdom | England | 82601 | 0 | 930 | 0 | 0 | 52.3555 | -1.1743 | 2020-03-23 23:19:34 | England, United Kingdom | |
2910851 | 2910851 | 2020-03-22 | United Kingdom | England | 82601 | 0 | 742 | 0 | 0 | 52.3555 | -1.1743 | 3/22/20 23:45 | England, 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]);