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 = "Guernsey" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2732688 | 2732688 | 2020-09-15 | United Kingdom | Guernsey | 254 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-09-16 04:22:53 | Guernsey, United Kingdom | ||
347960 | 347960 | 2020-09-14 | United Kingdom | Guernsey | 254 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-09-15 03:22:50 | Guernsey, United Kingdom | ||
2872399 | 2872399 | 2020-09-13 | United Kingdom | Guernsey | 254 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-09-14 04:26:00 | Guernsey, United Kingdom | ||
550438 | 550438 | 2020-09-12 | United Kingdom | Guernsey | 254 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-09-13 04:30:52 | Guernsey, United Kingdom | ||
1448267 | 1448267 | 2020-09-11 | United Kingdom | Guernsey | 254 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-09-12 04:25:05 | Guernsey, United Kingdom | ||
1176868 | 1176868 | 2020-09-10 | United Kingdom | Guernsey | 254 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-09-11 04:46:23 | Guernsey, United Kingdom | ||
2175233 | 2175233 | 2020-09-09 | United Kingdom | Guernsey | 254 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-09-10 04:29:01 | Guernsey, United Kingdom | ||
1247442 | 1247442 | 2020-09-08 | United Kingdom | Guernsey | 254 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-09-09 04:28:48 | Guernsey, United Kingdom | ||
431021 | 431021 | 2020-09-07 | United Kingdom | Guernsey | 253 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-09-08 04:28:25 | Guernsey, United Kingdom | ||
3165306 | 3165306 | 2020-09-06 | United Kingdom | Guernsey | 253 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-09-07 04:28:30 | Guernsey, United Kingdom | ||
817261 | 817261 | 2020-09-05 | United Kingdom | Guernsey | 253 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-09-06 04:28:33 | Guernsey, United Kingdom | ||
2665461 | 2665461 | 2020-09-04 | United Kingdom | Guernsey | 253 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-09-05 04:28:19 | Guernsey, United Kingdom | ||
1358001 | 1358001 | 2020-09-03 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-09-04 04:28:26 | Guernsey, United Kingdom | ||
1109238 | 1109238 | 2020-09-02 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-09-03 04:28:22 | Guernsey, United Kingdom | ||
2063567 | 2063567 | 2020-09-01 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-09-02 04:28:25 | Guernsey, United Kingdom | ||
197752 | 197752 | 2020-08-31 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-09-01 04:28:31 | Guernsey, United Kingdom | ||
3935707 | 3935707 | 2020-08-30 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-08-31 04:28:27 | Guernsey, United Kingdom | ||
613369 | 613369 | 2020-08-29 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-08-30 04:28:22 | Guernsey, United Kingdom | ||
1526864 | 1526864 | 2020-08-28 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-08-29 04:28:19 | Guernsey, United Kingdom | ||
2513865 | 2513865 | 2020-08-27 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-08-28 04:28:11 | Guernsey, United Kingdom | ||
2000325 | 2000325 | 2020-08-26 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-08-27 04:28:15 | Guernsey, United Kingdom | ||
3566249 | 3566249 | 2020-08-25 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-08-26 04:28:11 | Guernsey, United Kingdom | ||
2994953 | 2994953 | 2020-08-24 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-08-25 04:28:02 | Guernsey, United Kingdom | ||
2219348 | 2219348 | 2020-08-23 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-08-24 04:27:56 | Guernsey, United Kingdom | ||
2303130 | 2303130 | 2020-08-22 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-08-23 04:27:48 | Guernsey, United Kingdom | ||
1483236 | 1483236 | 2020-08-21 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-08-22 04:27:49 | Guernsey, United Kingdom | ||
3487985 | 3487985 | 2020-08-20 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-08-21 04:27:41 | Guernsey, United Kingdom | ||
209934 | 209934 | 2020-08-19 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-08-20 04:27:43 | Guernsey, United Kingdom | ||
3181686 | 3181686 | 2020-08-18 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-08-19 04:27:00 | Guernsey, United Kingdom | ||
841290 | 841290 | 2020-08-17 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-08-18 04:27:56 | Guernsey, United Kingdom | ||
1559646 | 1559646 | 2020-08-16 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-08-17 04:27:20 | Guernsey, United Kingdom | ||
149648 | 149648 | 2020-08-15 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-08-16 04:27:42 | Guernsey, United Kingdom | ||
1615923 | 1615923 | 2020-08-14 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-08-15 04:27:31 | Guernsey, United Kingdom | ||
586507 | 586507 | 2020-08-13 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-08-14 04:51:19 | Guernsey, United Kingdom | ||
3535124 | 3535124 | 2020-08-12 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-08-13 04:29:15 | Guernsey, United Kingdom | ||
665973 | 665973 | 2020-08-11 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-08-12 04:27:29 | Guernsey, United Kingdom | ||
1920883 | 1920883 | 2020-08-10 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-08-11 04:35:08 | Guernsey, United Kingdom | ||
3923692 | 3923692 | 2020-08-09 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-08-10 04:34:55 | Guernsey, United Kingdom | ||
371860 | 371860 | 2020-08-08 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-08-09 04:34:54 | Guernsey, United Kingdom | ||
459044 | 459044 | 2020-08-07 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-08-08 04:34:53 | Guernsey, United Kingdom | ||
3612729 | 3612729 | 2020-08-06 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-08-07 04:35:11 | Guernsey, United Kingdom | ||
3793559 | 3793559 | 2020-08-05 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-08-06 04:35:02 | Guernsey, United Kingdom | ||
98794 | 98794 | 2020-08-04 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-08-05 04:34:43 | Guernsey, United Kingdom | ||
2740676 | 2740676 | 2020-08-03 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-08-04 04:41:59 | Guernsey, United Kingdom | ||
2808428 | 2808428 | 2020-08-02 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-08-03 04:34:35 | Guernsey, United Kingdom | ||
753996 | 753996 | 2020-08-01 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-08-02 04:34:47 | Guernsey, United Kingdom | ||
3265161 | 3265161 | 2020-07-31 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-08-01 04:36:27 | Guernsey, United Kingdom | ||
1928870 | 1928870 | 2020-07-30 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-07-31 04:35:18 | Guernsey, United Kingdom | ||
2959038 | 2959038 | 2020-07-29 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-07-30 04:35:05 | Guernsey, United Kingdom | ||
3185655 | 3185655 | 2020-07-28 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-07-29 04:35:11 | Guernsey, United Kingdom | ||
177706 | 177706 | 2020-07-27 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-07-28 04:58:43 | Guernsey, United Kingdom | ||
443019 | 443019 | 2020-07-26 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-07-27 04:35:02 | Guernsey, United Kingdom | ||
1503263 | 1503263 | 2020-07-25 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-07-26 04:35:00 | Guernsey, United Kingdom | ||
2564233 | 2564233 | 2020-07-24 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-07-25 04:47:39 | Guernsey, United Kingdom | ||
62464 | 62464 | 2020-07-23 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-07-24 05:30:40 | Guernsey, United Kingdom | ||
845252 | 845252 | 2020-07-22 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-07-23 05:15:04 | Guernsey, United Kingdom | ||
1707991 | 1707991 | 2020-07-21 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-07-22 04:34:42 | Guernsey, United Kingdom | ||
327570 | 327570 | 2020-07-20 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-07-21 04:38:46 | Guernsey, United Kingdom | ||
122387 | 122387 | 2020-07-19 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-07-20 05:34:40 | Guernsey, United Kingdom | ||
3205775 | 3205775 | 2020-07-18 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-07-19 04:34:58 | Guernsey, United Kingdom | ||
2709077 | 2709077 | 2020-07-17 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-07-18 04:34:45 | Guernsey, United Kingdom | ||
367883 | 367883 | 2020-07-16 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-07-17 04:34:50 | Guernsey, United Kingdom | ||
2748551 | 2748551 | 2020-07-15 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-07-16 04:44:59 | Guernsey, United Kingdom | ||
2159195 | 2159195 | 2020-07-14 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-07-15 04:34:39 | Guernsey, United Kingdom | ||
3491837 | 3491837 | 2020-07-13 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-07-14 04:34:46 | Guernsey, United Kingdom | ||
3738098 | 3738098 | 2020-07-12 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-07-13 04:43:04 | Guernsey, United Kingdom | ||
3436493 | 3436493 | 2020-07-11 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-07-12 04:34:30 | Guernsey, United Kingdom | ||
3237991 | 3237991 | 2020-07-10 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-07-11 04:34:26 | Guernsey, United Kingdom | ||
1005976 | 1005976 | 2020-07-09 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-07-10 04:34:24 | Guernsey, United Kingdom | ||
2223191 | 2223191 | 2020-07-08 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-07-09 04:34:23 | Guernsey, United Kingdom | ||
887800 | 887800 | 2020-07-07 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-07-08 05:33:48 | Guernsey, United Kingdom | ||
2685360 | 2685360 | 2020-07-06 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-07-07 04:34:00 | Guernsey, United Kingdom | ||
415824 | 415824 | 2020-07-05 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-07-06 04:33:57 | Guernsey, United Kingdom | ||
530386 | 530386 | 2020-07-04 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-07-05 04:33:46 | Guernsey, United Kingdom | ||
2235047 | 2235047 | 2020-07-03 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-07-04 04:33:51 | Guernsey, United Kingdom | ||
3045841 | 3045841 | 2020-07-02 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-07-03 04:33:54 | Guernsey, United Kingdom | ||
303532 | 303532 | 2020-07-01 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-07-02 04:33:46 | Guernsey, United Kingdom | ||
2974910 | 2974910 | 2020-06-30 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-07-01 04:33:52 | Guernsey, United Kingdom | ||
2633387 | 2633387 | 2020-06-29 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-06-30 04:33:48 | Guernsey, United Kingdom | ||
2306950 | 2306950 | 2020-06-28 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-06-29 04:33:44 | Guernsey, United Kingdom | ||
2040285 | 2040285 | 2020-06-27 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-06-28 04:34:04 | Guernsey, United Kingdom | ||
1136566 | 1136566 | 2020-06-26 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-06-27 04:33:35 | Guernsey, United Kingdom | ||
2625553 | 2625553 | 2020-06-25 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-06-26 04:33:43 | Guernsey, United Kingdom | ||
2701193 | 2701193 | 2020-06-24 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-06-25 05:26:54 | Guernsey, United Kingdom | ||
1522878 | 1522878 | 2020-06-23 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-06-24 04:33:28 | Guernsey, United Kingdom | ||
1511072 | 1511072 | 2020-06-22 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-06-23 04:33:22 | Guernsey, United Kingdom | ||
3249811 | 3249811 | 2020-06-21 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-06-22 04:33:20 | Guernsey, United Kingdom | ||
2438404 | 2438404 | 2020-06-20 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-06-21 04:33:19 | Guernsey, United Kingdom | ||
1691982 | 1691982 | 2020-06-19 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-06-20 04:33:19 | Guernsey, United Kingdom | ||
3683131 | 3683131 | 2020-06-18 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-06-19 04:33:17 | Guernsey, United Kingdom | ||
1196334 | 1196334 | 2020-06-17 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-06-18 04:33:18 | Guernsey, United Kingdom | ||
2387097 | 2387097 | 2020-06-16 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-06-17 04:33:21 | Guernsey, United Kingdom | ||
287660 | 287660 | 2020-06-15 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-06-16 04:33:09 | Guernsey, United Kingdom | ||
1837611 | 1837611 | 2020-06-14 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-06-15 03:33:14 | Guernsey, United Kingdom | ||
3061663 | 3061663 | 2020-06-13 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-06-14 03:33:15 | Guernsey, United Kingdom | ||
737983 | 737983 | 2020-06-12 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-06-13 03:33:14 | Guernsey, United Kingdom | ||
1273953 | 1273953 | 2020-06-11 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-06-12 05:09:52 | Guernsey, United Kingdom | ||
2864393 | 2864393 | 2020-06-10 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-06-11 03:33:41 | Guernsey, United Kingdom | ||
1211212 | 1211212 | 2020-06-09 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-06-10 04:07:00 | Guernsey, United Kingdom | ||
217639 | 217639 | 2020-06-08 | United Kingdom | Guernsey | 252 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-06-09 03:33:03 | Guernsey, 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]);