johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,024 rows where country_or_region = "United Kingdom" and province_or_state = "Gibraltar" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2732643 | 2732643 | 2020-09-15 | United Kingdom | Gibraltar | 334 | 0 | 307 | 27 | 36.1408 | -5.3536 | 2020-09-16 04:22:53 | Gibraltar, United Kingdom | ||
347915 | 347915 | 2020-09-14 | United Kingdom | Gibraltar | 330 | 0 | 303 | 27 | 36.1408 | -5.3536 | 2020-09-15 03:22:50 | Gibraltar, United Kingdom | ||
2872354 | 2872354 | 2020-09-13 | United Kingdom | Gibraltar | 330 | 0 | 298 | 32 | 36.1408 | -5.3536 | 2020-09-14 04:26:00 | Gibraltar, United Kingdom | ||
550393 | 550393 | 2020-09-12 | United Kingdom | Gibraltar | 327 | 0 | 294 | 33 | 36.1408 | -5.3536 | 2020-09-13 04:30:52 | Gibraltar, United Kingdom | ||
1448222 | 1448222 | 2020-09-11 | United Kingdom | Gibraltar | 323 | 0 | 289 | 34 | 36.1408 | -5.3536 | 2020-09-12 04:25:05 | Gibraltar, United Kingdom | ||
1176823 | 1176823 | 2020-09-10 | United Kingdom | Gibraltar | 323 | 0 | 287 | 36 | 36.1408 | -5.3536 | 2020-09-11 04:46:23 | Gibraltar, United Kingdom | ||
2175188 | 2175188 | 2020-09-09 | United Kingdom | Gibraltar | 322 | 0 | 277 | 45 | 36.1408 | -5.3536 | 2020-09-10 04:29:01 | Gibraltar, United Kingdom | ||
1247397 | 1247397 | 2020-09-08 | United Kingdom | Gibraltar | 320 | 0 | 276 | 44 | 36.1408 | -5.3536 | 2020-09-09 04:28:48 | Gibraltar, United Kingdom | ||
430976 | 430976 | 2020-09-07 | United Kingdom | Gibraltar | 315 | 0 | 273 | 42 | 36.1408 | -5.3536 | 2020-09-08 04:28:25 | Gibraltar, United Kingdom | ||
3165261 | 3165261 | 2020-09-06 | United Kingdom | Gibraltar | 315 | 0 | 273 | 42 | 36.1408 | -5.3536 | 2020-09-07 04:28:30 | Gibraltar, United Kingdom | ||
817216 | 817216 | 2020-09-05 | United Kingdom | Gibraltar | 312 | 0 | 255 | 57 | 36.1408 | -5.3536 | 2020-09-06 04:28:33 | Gibraltar, United Kingdom | ||
2665416 | 2665416 | 2020-09-04 | United Kingdom | Gibraltar | 305 | 0 | 248 | 57 | 36.1408 | -5.3536 | 2020-09-05 04:28:19 | Gibraltar, United Kingdom | ||
1357956 | 1357956 | 2020-09-03 | United Kingdom | Gibraltar | 298 | 0 | 246 | 52 | 36.1408 | -5.3536 | 2020-09-04 04:28:26 | Gibraltar, United Kingdom | ||
1109193 | 1109193 | 2020-09-02 | United Kingdom | Gibraltar | 295 | 0 | 240 | 55 | 36.1408 | -5.3536 | 2020-09-03 04:28:22 | Gibraltar, United Kingdom | ||
2063522 | 2063522 | 2020-09-01 | United Kingdom | Gibraltar | 290 | 0 | 237 | 53 | 36.1408 | -5.3536 | 2020-09-02 04:28:25 | Gibraltar, United Kingdom | ||
197707 | 197707 | 2020-08-31 | United Kingdom | Gibraltar | 288 | 0 | 232 | 56 | 36.1408 | -5.3536 | 2020-09-01 04:28:31 | Gibraltar, United Kingdom | ||
3935662 | 3935662 | 2020-08-30 | United Kingdom | Gibraltar | 285 | 0 | 228 | 57 | 36.1408 | -5.3536 | 2020-08-31 04:28:27 | Gibraltar, United Kingdom | ||
613324 | 613324 | 2020-08-29 | United Kingdom | Gibraltar | 275 | 0 | 226 | 49 | 36.1408 | -5.3536 | 2020-08-30 04:28:22 | Gibraltar, United Kingdom | ||
1526819 | 1526819 | 2020-08-28 | United Kingdom | Gibraltar | 274 | 0 | 221 | 53 | 36.1408 | -5.3536 | 2020-08-29 04:28:19 | Gibraltar, United Kingdom | ||
2513820 | 2513820 | 2020-08-27 | United Kingdom | Gibraltar | 272 | 0 | 216 | 56 | 36.1408 | -5.3536 | 2020-08-28 04:28:11 | Gibraltar, United Kingdom | ||
2000280 | 2000280 | 2020-08-26 | United Kingdom | Gibraltar | 270 | 0 | 203 | 67 | 36.1408 | -5.3536 | 2020-08-27 04:28:15 | Gibraltar, United Kingdom | ||
3566204 | 3566204 | 2020-08-25 | United Kingdom | Gibraltar | 256 | 0 | 203 | 53 | 36.1408 | -5.3536 | 2020-08-26 04:28:11 | Gibraltar, United Kingdom | ||
2994908 | 2994908 | 2020-08-24 | United Kingdom | Gibraltar | 248 | 0 | 203 | 45 | 36.1408 | -5.3536 | 2020-08-25 04:28:02 | Gibraltar, United Kingdom | ||
2219303 | 2219303 | 2020-08-23 | United Kingdom | Gibraltar | 246 | 0 | 201 | 45 | 36.1408 | -5.3536 | 2020-08-24 04:27:56 | Gibraltar, United Kingdom | ||
2303085 | 2303085 | 2020-08-22 | United Kingdom | Gibraltar | 239 | 0 | 201 | 38 | 36.1408 | -5.3536 | 2020-08-23 04:27:48 | Gibraltar, United Kingdom | ||
1483191 | 1483191 | 2020-08-21 | United Kingdom | Gibraltar | 231 | 0 | 200 | 31 | 36.1408 | -5.3536 | 2020-08-22 04:27:49 | Gibraltar, United Kingdom | ||
3487940 | 3487940 | 2020-08-20 | United Kingdom | Gibraltar | 229 | 0 | 200 | 29 | 36.1408 | -5.3536 | 2020-08-21 04:27:41 | Gibraltar, United Kingdom | ||
209889 | 209889 | 2020-08-19 | United Kingdom | Gibraltar | 223 | 0 | 197 | 26 | 36.1408 | -5.3536 | 2020-08-20 04:27:43 | Gibraltar, United Kingdom | ||
3181641 | 3181641 | 2020-08-18 | United Kingdom | Gibraltar | 222 | 0 | 195 | 27 | 36.1408 | -5.3536 | 2020-08-19 04:27:00 | Gibraltar, United Kingdom | ||
841245 | 841245 | 2020-08-17 | United Kingdom | Gibraltar | 217 | 0 | 194 | 23 | 36.1408 | -5.3536 | 2020-08-18 04:27:56 | Gibraltar, United Kingdom | ||
1559601 | 1559601 | 2020-08-16 | United Kingdom | Gibraltar | 215 | 0 | 190 | 25 | 36.1408 | -5.3536 | 2020-08-17 04:27:20 | Gibraltar, United Kingdom | ||
149603 | 149603 | 2020-08-15 | United Kingdom | Gibraltar | 209 | 0 | 190 | 19 | 36.1408 | -5.3536 | 2020-08-16 04:27:42 | Gibraltar, United Kingdom | ||
1615878 | 1615878 | 2020-08-14 | United Kingdom | Gibraltar | 206 | 0 | 188 | 18 | 36.1408 | -5.3536 | 2020-08-15 04:27:31 | Gibraltar, United Kingdom | ||
586462 | 586462 | 2020-08-13 | United Kingdom | Gibraltar | 205 | 0 | 188 | 17 | 36.1408 | -5.3536 | 2020-08-14 04:51:19 | Gibraltar, United Kingdom | ||
3535079 | 3535079 | 2020-08-12 | United Kingdom | Gibraltar | 203 | 0 | 187 | 16 | 36.1408 | -5.3536 | 2020-08-13 04:29:15 | Gibraltar, United Kingdom | ||
662669 | 662669 | 2020-08-11 | United Kingdom | Gibraltar | 202 | 0 | 187 | 15 | 36.1408 | -5.3536 | 2020-08-12 04:27:29 | Gibraltar, United Kingdom | ||
1920301 | 1920301 | 2020-08-10 | United Kingdom | Gibraltar | 201 | 0 | 186 | 15 | 36.1408 | -5.3536 | 2020-08-11 04:35:08 | Gibraltar, United Kingdom | ||
3923110 | 3923110 | 2020-08-09 | United Kingdom | Gibraltar | 201 | 0 | 186 | 15 | 36.1408 | -5.3536 | 2020-08-10 04:34:55 | Gibraltar, United Kingdom | ||
371278 | 371278 | 2020-08-08 | United Kingdom | Gibraltar | 197 | 0 | 184 | 13 | 36.1408 | -5.3536 | 2020-08-09 04:34:54 | Gibraltar, United Kingdom | ||
458462 | 458462 | 2020-08-07 | United Kingdom | Gibraltar | 190 | 0 | 184 | 6 | 36.1408 | -5.3536 | 2020-08-08 04:34:53 | Gibraltar, United Kingdom | ||
3612147 | 3612147 | 2020-08-06 | United Kingdom | Gibraltar | 190 | 0 | 184 | 6 | 36.1408 | -5.3536 | 2020-08-07 04:35:11 | Gibraltar, United Kingdom | ||
3792977 | 3792977 | 2020-08-05 | United Kingdom | Gibraltar | 189 | 0 | 183 | 6 | 36.1408 | -5.3536 | 2020-08-06 04:35:02 | Gibraltar, United Kingdom | ||
98213 | 98213 | 2020-08-04 | United Kingdom | Gibraltar | 189 | 0 | 183 | 6 | 36.1408 | -5.3536 | 2020-08-05 04:34:43 | Gibraltar, United Kingdom | ||
2740096 | 2740096 | 2020-08-03 | United Kingdom | Gibraltar | 188 | 0 | 183 | 5 | 36.1408 | -5.3536 | 2020-08-04 04:41:59 | Gibraltar, United Kingdom | ||
2807848 | 2807848 | 2020-08-02 | United Kingdom | Gibraltar | 188 | 0 | 183 | 5 | 36.1408 | -5.3536 | 2020-08-03 04:34:35 | Gibraltar, United Kingdom | ||
753416 | 753416 | 2020-08-01 | United Kingdom | Gibraltar | 188 | 0 | 182 | 6 | 36.1408 | -5.3536 | 2020-08-02 04:34:47 | Gibraltar, United Kingdom | ||
3264581 | 3264581 | 2020-07-31 | United Kingdom | Gibraltar | 187 | 0 | 181 | 6 | 36.1408 | -5.3536 | 2020-08-01 04:36:27 | Gibraltar, United Kingdom | ||
1928288 | 1928288 | 2020-07-30 | United Kingdom | Gibraltar | 187 | 0 | 180 | 7 | 36.1408 | -5.3536 | 2020-07-31 04:35:18 | Gibraltar, United Kingdom | ||
2958456 | 2958456 | 2020-07-29 | United Kingdom | Gibraltar | 186 | 0 | 180 | 6 | 36.1408 | -5.3536 | 2020-07-30 04:35:05 | Gibraltar, United Kingdom | ||
3185072 | 3185072 | 2020-07-28 | United Kingdom | Gibraltar | 186 | 0 | 180 | 6 | 36.1408 | -5.3536 | 2020-07-29 04:35:11 | Gibraltar, United Kingdom | ||
177124 | 177124 | 2020-07-27 | United Kingdom | Gibraltar | 185 | 0 | 180 | 5 | 36.1408 | -5.3536 | 2020-07-28 04:58:43 | Gibraltar, United Kingdom | ||
442437 | 442437 | 2020-07-26 | United Kingdom | Gibraltar | 185 | 0 | 180 | 5 | 36.1408 | -5.3536 | 2020-07-27 04:35:02 | Gibraltar, United Kingdom | ||
1502681 | 1502681 | 2020-07-25 | United Kingdom | Gibraltar | 185 | 0 | 180 | 5 | 36.1408 | -5.3536 | 2020-07-26 04:35:00 | Gibraltar, United Kingdom | ||
2563651 | 2563651 | 2020-07-24 | United Kingdom | Gibraltar | 184 | 0 | 180 | 4 | 36.1408 | -5.3536 | 2020-07-25 04:47:39 | Gibraltar, United Kingdom | ||
61873 | 61873 | 2020-07-23 | United Kingdom | Gibraltar | 184 | 0 | 180 | 4 | 36.1408 | -5.3536 | 2020-07-24 05:30:40 | Gibraltar, United Kingdom | ||
844671 | 844671 | 2020-07-22 | United Kingdom | Gibraltar | 182 | 0 | 180 | 2 | 36.1408 | -5.3536 | 2020-07-23 05:15:04 | Gibraltar, United Kingdom | ||
1707410 | 1707410 | 2020-07-21 | United Kingdom | Gibraltar | 180 | 0 | 180 | 0 | 36.1408 | -5.3536 | 2020-07-22 04:34:42 | Gibraltar, United Kingdom | ||
326901 | 326901 | 2020-07-20 | United Kingdom | Gibraltar | 180 | 0 | 180 | 0 | 36.1408 | -5.3536 | 2020-07-21 04:38:46 | Gibraltar, United Kingdom | ||
121806 | 121806 | 2020-07-19 | United Kingdom | Gibraltar | 180 | 0 | 180 | 0 | 36.1408 | -5.3536 | 2020-07-20 05:34:40 | Gibraltar, United Kingdom | ||
3205195 | 3205195 | 2020-07-18 | United Kingdom | Gibraltar | 180 | 0 | 180 | 0 | 36.1408 | -5.3536 | 2020-07-19 04:34:58 | Gibraltar, United Kingdom | ||
2708497 | 2708497 | 2020-07-17 | United Kingdom | Gibraltar | 180 | 0 | 180 | 0 | 36.1408 | -5.3536 | 2020-07-18 04:34:45 | Gibraltar, United Kingdom | ||
367312 | 367312 | 2020-07-16 | United Kingdom | Gibraltar | 180 | 0 | 180 | 0 | 36.1408 | -5.3536 | 2020-07-17 04:34:50 | Gibraltar, United Kingdom | ||
2747980 | 2747980 | 2020-07-15 | United Kingdom | Gibraltar | 180 | 0 | 180 | 0 | 36.1408 | -5.3536 | 2020-07-16 04:44:59 | Gibraltar, United Kingdom | ||
2158624 | 2158624 | 2020-07-14 | United Kingdom | Gibraltar | 180 | 0 | 179 | 1 | 36.1408 | -5.3536 | 2020-07-15 04:34:39 | Gibraltar, United Kingdom | ||
3491265 | 3491265 | 2020-07-13 | United Kingdom | Gibraltar | 180 | 0 | 179 | 1 | 36.1408 | -5.3536 | 2020-07-14 04:34:46 | Gibraltar, United Kingdom | ||
3737527 | 3737527 | 2020-07-12 | United Kingdom | Gibraltar | 180 | 0 | 176 | 4 | 36.1408 | -5.3536 | 2020-07-13 04:43:04 | Gibraltar, United Kingdom | ||
3435922 | 3435922 | 2020-07-11 | United Kingdom | Gibraltar | 180 | 0 | 176 | 4 | 36.1408 | -5.3536 | 2020-07-12 04:34:30 | Gibraltar, United Kingdom | ||
3237420 | 3237420 | 2020-07-10 | United Kingdom | Gibraltar | 180 | 0 | 176 | 4 | 36.1408 | -5.3536 | 2020-07-11 04:34:26 | Gibraltar, United Kingdom | ||
1005405 | 1005405 | 2020-07-09 | United Kingdom | Gibraltar | 180 | 0 | 176 | 4 | 36.1408 | -5.3536 | 2020-07-10 04:34:24 | Gibraltar, United Kingdom | ||
2222621 | 2222621 | 2020-07-08 | United Kingdom | Gibraltar | 179 | 0 | 176 | 3 | 36.1408 | -5.3536 | 2020-07-09 04:34:23 | Gibraltar, United Kingdom | ||
887230 | 887230 | 2020-07-07 | United Kingdom | Gibraltar | 179 | 0 | 176 | 3 | 36.1408 | -5.3536 | 2020-07-08 05:33:48 | Gibraltar, United Kingdom | ||
2684790 | 2684790 | 2020-07-06 | United Kingdom | Gibraltar | 179 | 0 | 176 | 3 | 36.1408 | -5.3536 | 2020-07-07 04:34:00 | Gibraltar, United Kingdom | ||
415255 | 415255 | 2020-07-05 | United Kingdom | Gibraltar | 179 | 0 | 176 | 3 | 36.1408 | -5.3536 | 2020-07-06 04:33:57 | Gibraltar, United Kingdom | ||
529817 | 529817 | 2020-07-04 | United Kingdom | Gibraltar | 178 | 0 | 176 | 2 | 36.1408 | -5.3536 | 2020-07-05 04:33:46 | Gibraltar, United Kingdom | ||
2234478 | 2234478 | 2020-07-03 | United Kingdom | Gibraltar | 178 | 0 | 176 | 2 | 36.1408 | -5.3536 | 2020-07-04 04:33:51 | Gibraltar, United Kingdom | ||
3045272 | 3045272 | 2020-07-02 | United Kingdom | Gibraltar | 178 | 0 | 176 | 2 | 36.1408 | -5.3536 | 2020-07-03 04:33:54 | Gibraltar, United Kingdom | ||
302963 | 302963 | 2020-07-01 | United Kingdom | Gibraltar | 178 | 0 | 176 | 2 | 36.1408 | -5.3536 | 2020-07-02 04:33:46 | Gibraltar, United Kingdom | ||
2974341 | 2974341 | 2020-06-30 | United Kingdom | Gibraltar | 177 | 0 | 176 | 1 | 36.1408 | -5.3536 | 2020-07-01 04:33:52 | Gibraltar, United Kingdom | ||
2632818 | 2632818 | 2020-06-29 | United Kingdom | Gibraltar | 177 | 0 | 176 | 1 | 36.1408 | -5.3536 | 2020-06-30 04:33:48 | Gibraltar, United Kingdom | ||
2306381 | 2306381 | 2020-06-28 | United Kingdom | Gibraltar | 177 | 0 | 176 | 1 | 36.1408 | -5.3536 | 2020-06-29 04:33:44 | Gibraltar, United Kingdom | ||
2039716 | 2039716 | 2020-06-27 | United Kingdom | Gibraltar | 177 | 0 | 176 | 1 | 36.1408 | -5.3536 | 2020-06-28 04:34:04 | Gibraltar, United Kingdom | ||
1135997 | 1135997 | 2020-06-26 | United Kingdom | Gibraltar | 176 | 0 | 176 | 0 | 36.1408 | -5.3536 | 2020-06-27 04:33:35 | Gibraltar, United Kingdom | ||
2624984 | 2624984 | 2020-06-25 | United Kingdom | Gibraltar | 176 | 0 | 176 | 0 | 36.1408 | -5.3536 | 2020-06-26 04:33:43 | Gibraltar, United Kingdom | ||
2700624 | 2700624 | 2020-06-24 | United Kingdom | Gibraltar | 176 | 0 | 176 | 0 | 36.1408 | -5.3536 | 2020-06-25 05:26:54 | Gibraltar, United Kingdom | ||
1522309 | 1522309 | 2020-06-23 | United Kingdom | Gibraltar | 176 | 0 | 176 | 0 | 36.1408 | -5.3536 | 2020-06-24 04:33:28 | Gibraltar, United Kingdom | ||
1510503 | 1510503 | 2020-06-22 | United Kingdom | Gibraltar | 176 | 0 | 176 | 0 | 36.1408 | -5.3536 | 2020-06-23 04:33:22 | Gibraltar, United Kingdom | ||
3249242 | 3249242 | 2020-06-21 | United Kingdom | Gibraltar | 176 | 0 | 176 | 0 | 36.1408 | -5.3536 | 2020-06-22 04:33:20 | Gibraltar, United Kingdom | ||
2437835 | 2437835 | 2020-06-20 | United Kingdom | Gibraltar | 176 | 0 | 176 | 0 | 36.1408 | -5.3536 | 2020-06-21 04:33:19 | Gibraltar, United Kingdom | ||
1691413 | 1691413 | 2020-06-19 | United Kingdom | Gibraltar | 176 | 0 | 176 | 0 | 36.1408 | -5.3536 | 2020-06-20 04:33:19 | Gibraltar, United Kingdom | ||
3682562 | 3682562 | 2020-06-18 | United Kingdom | Gibraltar | 176 | 0 | 176 | 0 | 36.1408 | -5.3536 | 2020-06-19 04:33:17 | Gibraltar, United Kingdom | ||
1195765 | 1195765 | 2020-06-17 | United Kingdom | Gibraltar | 176 | 0 | 176 | 0 | 36.1408 | -5.3536 | 2020-06-18 04:33:18 | Gibraltar, United Kingdom | ||
2386528 | 2386528 | 2020-06-16 | United Kingdom | Gibraltar | 176 | 0 | 174 | 2 | 36.1408 | -5.3536 | 2020-06-17 04:33:21 | Gibraltar, United Kingdom | ||
287091 | 287091 | 2020-06-15 | United Kingdom | Gibraltar | 176 | 0 | 174 | 2 | 36.1408 | -5.3536 | 2020-06-16 04:33:09 | Gibraltar, United Kingdom | ||
1837042 | 1837042 | 2020-06-14 | United Kingdom | Gibraltar | 176 | 0 | 173 | 3 | 36.1408 | -5.3536 | 2020-06-15 03:33:14 | Gibraltar, United Kingdom | ||
3061094 | 3061094 | 2020-06-13 | United Kingdom | Gibraltar | 176 | 0 | 173 | 3 | 36.1408 | -5.3536 | 2020-06-14 03:33:15 | Gibraltar, United Kingdom | ||
737414 | 737414 | 2020-06-12 | United Kingdom | Gibraltar | 176 | 0 | 172 | 4 | 36.1408 | -5.3536 | 2020-06-13 03:33:14 | Gibraltar, United Kingdom | ||
1273384 | 1273384 | 2020-06-11 | United Kingdom | Gibraltar | 176 | 0 | 171 | 5 | 36.1408 | -5.3536 | 2020-06-12 05:09:52 | Gibraltar, United Kingdom | ||
2863827 | 2863827 | 2020-06-10 | United Kingdom | Gibraltar | 176 | 0 | 169 | 7 | 36.1408 | -5.3536 | 2020-06-11 03:33:41 | Gibraltar, United Kingdom | ||
1210676 | 1210676 | 2020-06-09 | United Kingdom | Gibraltar | 176 | 0 | 165 | 11 | 36.1408 | -5.3536 | 2020-06-10 04:07:00 | Gibraltar, United Kingdom | ||
217103 | 217103 | 2020-06-08 | United Kingdom | Gibraltar | 176 | 0 | 165 | 11 | 36.1408 | -5.3536 | 2020-06-09 03:33:03 | Gibraltar, 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]);