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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1495260 | 1495260 | 2021-10-12 | United Kingdom | Gibraltar | 5682 | 97 | 0 | 36.1408 | -5.3536 | 2021-10-13 04:20:51 | Gibraltar, United Kingdom | |||
3010993 | 3010993 | 2021-10-11 | United Kingdom | Gibraltar | 5655 | 97 | 0 | 36.1408 | -5.3536 | 2021-10-12 04:21:09 | Gibraltar, United Kingdom | |||
427009 | 427009 | 2021-10-10 | United Kingdom | Gibraltar | 5626 | 97 | 0 | 36.1408 | -5.3536 | 2021-10-11 04:21:31 | Gibraltar, United Kingdom | |||
2879866 | 2879866 | 2021-10-09 | United Kingdom | Gibraltar | 5613 | 97 | 0 | 36.1408 | -5.3536 | 2021-10-10 04:21:38 | Gibraltar, United Kingdom | |||
2963032 | 2963032 | 2021-10-08 | United Kingdom | Gibraltar | 5608 | 97 | 0 | 36.1408 | -5.3536 | 2021-10-09 04:21:34 | Gibraltar, United Kingdom | |||
471070 | 471070 | 2021-10-07 | United Kingdom | Gibraltar | 5606 | 97 | 0 | 36.1408 | -5.3536 | 2021-10-08 04:21:25 | Gibraltar, United Kingdom | |||
2462450 | 2462450 | 2021-10-06 | United Kingdom | Gibraltar | 5597 | 97 | 0 | 36.1408 | -5.3536 | 2021-10-07 04:21:36 | Gibraltar, United Kingdom | |||
3836143 | 3836143 | 2021-10-05 | United Kingdom | Gibraltar | 5590 | 97 | 0 | 36.1408 | -5.3536 | 2021-10-06 04:21:33 | Gibraltar, United Kingdom | |||
990636 | 990636 | 2021-10-04 | United Kingdom | Gibraltar | 5579 | 97 | 0 | 36.1408 | -5.3536 | 2021-10-05 04:21:27 | Gibraltar, United Kingdom | |||
1277946 | 1277946 | 2021-10-03 | United Kingdom | Gibraltar | 5573 | 97 | 0 | 36.1408 | -5.3536 | 2021-10-04 04:21:31 | Gibraltar, United Kingdom | |||
3931699 | 3931699 | 2021-10-02 | United Kingdom | Gibraltar | 5566 | 97 | 0 | 36.1408 | -5.3536 | 2021-10-03 04:21:24 | Gibraltar, United Kingdom | |||
2135679 | 2135679 | 2021-10-01 | United Kingdom | Gibraltar | 5555 | 97 | 0 | 36.1408 | -5.3536 | 2021-10-02 04:21:25 | Gibraltar, United Kingdom | |||
2776636 | 2776636 | 2021-09-30 | United Kingdom | Gibraltar | 5549 | 97 | 0 | 36.1408 | -5.3536 | 2021-10-01 04:21:35 | Gibraltar, United Kingdom | |||
710092 | 710092 | 2021-09-29 | United Kingdom | Gibraltar | 5541 | 97 | 0 | 36.1408 | -5.3536 | 2021-09-30 04:21:20 | Gibraltar, United Kingdom | |||
1337934 | 1337934 | 2021-09-28 | United Kingdom | Gibraltar | 5532 | 97 | 0 | 36.1408 | -5.3536 | 2021-09-29 04:21:45 | Gibraltar, United Kingdom | |||
1239303 | 1239303 | 2021-09-27 | United Kingdom | Gibraltar | 5517 | 97 | 0 | 36.1408 | -5.3536 | 2021-09-28 04:21:28 | Gibraltar, United Kingdom | |||
2079604 | 2079604 | 2021-09-26 | United Kingdom | Gibraltar | 5514 | 97 | 0 | 36.1408 | -5.3536 | 2021-09-27 04:21:16 | Gibraltar, United Kingdom | |||
1728156 | 1728156 | 2021-09-25 | United Kingdom | Gibraltar | 5510 | 97 | 0 | 36.1408 | -5.3536 | 2021-09-26 04:21:29 | Gibraltar, United Kingdom | |||
1924876 | 1924876 | 2021-09-24 | United Kingdom | Gibraltar | 5502 | 97 | 0 | 36.1408 | -5.3536 | 2021-09-25 04:21:31 | Gibraltar, United Kingdom | |||
605347 | 605347 | 2021-09-23 | United Kingdom | Gibraltar | 5497 | 97 | 0 | 36.1408 | -5.3536 | 2021-09-24 04:21:44 | Gibraltar, United Kingdom | |||
3014991 | 3014991 | 2021-09-22 | United Kingdom | Gibraltar | 5490 | 97 | 0 | 36.1408 | -5.3536 | 2021-09-23 04:21:43 | Gibraltar, United Kingdom | |||
3761129 | 3761129 | 2021-09-21 | United Kingdom | Gibraltar | 5483 | 97 | 0 | 36.1408 | -5.3536 | 2021-09-22 04:21:45 | Gibraltar, United Kingdom | |||
813232 | 813232 | 2021-09-20 | United Kingdom | Gibraltar | 5479 | 97 | 0 | 36.1408 | -5.3536 | 2021-09-21 04:21:26 | Gibraltar, United Kingdom | |||
1818431 | 1818431 | 2021-09-19 | United Kingdom | Gibraltar | 5477 | 97 | 0 | 36.1408 | -5.3536 | 2021-09-20 04:21:22 | Gibraltar, United Kingdom | |||
20011 | 20011 | 2021-09-18 | United Kingdom | Gibraltar | 5476 | 97 | 0 | 36.1408 | -5.3536 | 2021-09-19 04:21:34 | Gibraltar, United Kingdom | |||
2621696 | 2621696 | 2021-09-17 | United Kingdom | Gibraltar | 5469 | 97 | 0 | 36.1408 | -5.3536 | 2021-09-18 04:21:24 | Gibraltar, United Kingdom | |||
2812404 | 2812404 | 2021-09-16 | United Kingdom | Gibraltar | 5463 | 97 | 0 | 36.1408 | -5.3536 | 2021-09-17 04:21:46 | Gibraltar, United Kingdom | |||
1378148 | 1378148 | 2021-09-15 | United Kingdom | Gibraltar | 5449 | 97 | 0 | 36.1408 | -5.3536 | 2021-09-16 04:22:19 | Gibraltar, United Kingdom | |||
2466447 | 2466447 | 2021-09-14 | United Kingdom | Gibraltar | 5445 | 97 | 0 | 36.1408 | -5.3536 | 2021-09-15 03:22:37 | Gibraltar, United Kingdom | |||
1389286 | 1389286 | 2021-09-13 | United Kingdom | Gibraltar | 5436 | 97 | 0 | 36.1408 | -5.3536 | 2021-09-14 04:21:41 | Gibraltar, United Kingdom | |||
1888655 | 1888655 | 2021-09-12 | United Kingdom | Gibraltar | 5431 | 97 | 0 | 36.1408 | -5.3536 | 2021-09-13 04:21:15 | Gibraltar, United Kingdom | |||
3809558 | 3809558 | 2021-09-11 | United Kingdom | Gibraltar | 5419 | 97 | 0 | 36.1408 | -5.3536 | 2021-09-12 04:21:13 | Gibraltar, United Kingdom | |||
3452498 | 3452498 | 2021-09-10 | United Kingdom | Gibraltar | 5414 | 97 | 0 | 36.1408 | -5.3536 | 2021-09-11 04:21:30 | Gibraltar, United Kingdom | |||
1266444 | 1266444 | 2021-09-09 | United Kingdom | Gibraltar | 5409 | 97 | 0 | 36.1408 | -5.3536 | 2021-09-10 04:21:20 | Gibraltar, United Kingdom | |||
2282814 | 2282814 | 2021-09-08 | United Kingdom | Gibraltar | 5402 | 97 | 0 | 36.1408 | -5.3536 | 2021-09-09 04:21:27 | Gibraltar, United Kingdom | |||
645593 | 645593 | 2021-09-07 | United Kingdom | Gibraltar | 5399 | 97 | 0 | 36.1408 | -5.3536 | 2021-09-08 04:21:31 | Gibraltar, United Kingdom | |||
3197656 | 3197656 | 2021-09-06 | United Kingdom | Gibraltar | 5392 | 97 | 0 | 36.1408 | -5.3536 | 2021-09-07 04:21:35 | Gibraltar, United Kingdom | |||
3284524 | 3284524 | 2021-09-05 | United Kingdom | Gibraltar | 5388 | 97 | 0 | 36.1408 | -5.3536 | 2021-09-06 04:21:22 | Gibraltar, United Kingdom | |||
252938 | 252938 | 2021-09-04 | United Kingdom | Gibraltar | 5386 | 97 | 0 | 36.1408 | -5.3536 | 2021-09-05 04:21:33 | Gibraltar, United Kingdom | |||
3978219 | 3978219 | 2021-09-03 | United Kingdom | Gibraltar | 5376 | 97 | 0 | 36.1408 | -5.3536 | 2021-09-04 04:21:28 | Gibraltar, United Kingdom | |||
181681 | 181681 | 2021-09-02 | United Kingdom | Gibraltar | 5371 | 97 | 0 | 36.1408 | -5.3536 | 2021-09-03 04:21:20 | Gibraltar, United Kingdom | |||
70716 | 70716 | 2021-09-01 | United Kingdom | Gibraltar | 5367 | 97 | 0 | 36.1408 | -5.3536 | 2021-09-02 04:21:15 | Gibraltar, United Kingdom | |||
2071558 | 2071558 | 2021-08-31 | United Kingdom | Gibraltar | 5354 | 97 | 0 | 36.1408 | -5.3536 | 2021-09-01 04:21:38 | Gibraltar, United Kingdom | |||
1779012 | 1779012 | 2021-08-30 | United Kingdom | Gibraltar | 5342 | 97 | 0 | 36.1408 | -5.3536 | 2021-08-31 04:21:46 | Gibraltar, United Kingdom | |||
3895586 | 3895586 | 2021-08-29 | United Kingdom | Gibraltar | 5338 | 97 | 0 | 36.1408 | -5.3536 | 2021-08-30 04:21:23 | Gibraltar, United Kingdom | |||
2796689 | 2796689 | 2021-08-28 | United Kingdom | Gibraltar | 5332 | 97 | 0 | 36.1408 | -5.3536 | 2021-08-29 04:21:14 | Gibraltar, United Kingdom | |||
2926848 | 2926848 | 2021-08-27 | United Kingdom | Gibraltar | 5323 | 97 | 0 | 36.1408 | -5.3536 | 2021-08-28 04:21:28 | Gibraltar, United Kingdom | |||
1599862 | 1599862 | 2021-08-26 | United Kingdom | Gibraltar | 5314 | 96 | 0 | 36.1408 | -5.3536 | 2021-08-27 04:21:37 | Gibraltar, United Kingdom | |||
36071 | 36071 | 2021-08-25 | United Kingdom | Gibraltar | 5308 | 96 | 0 | 36.1408 | -5.3536 | 2021-08-26 04:21:28 | Gibraltar, United Kingdom | |||
3109110 | 3109110 | 2021-08-24 | United Kingdom | Gibraltar | 5299 | 96 | 0 | 36.1408 | -5.3536 | 2021-08-25 04:21:41 | Gibraltar, United Kingdom | |||
3169281 | 3169281 | 2021-08-23 | United Kingdom | Gibraltar | 5290 | 96 | 0 | 36.1408 | -5.3536 | 2021-08-24 04:21:19 | Gibraltar, United Kingdom | |||
2179208 | 2179208 | 2021-08-22 | United Kingdom | Gibraltar | 5287 | 96 | 0 | 36.1408 | -5.3536 | 2021-08-23 04:21:27 | Gibraltar, United Kingdom | |||
3559304 | 3559304 | 2021-08-21 | United Kingdom | Gibraltar | 5278 | 96 | 0 | 36.1408 | -5.3536 | 2021-08-22 04:21:29 | Gibraltar, United Kingdom | |||
1857646 | 1857646 | 2021-08-20 | United Kingdom | Gibraltar | 5269 | 96 | 0 | 36.1408 | -5.3536 | 2021-08-21 04:21:38 | Gibraltar, United Kingdom | |||
515353 | 515353 | 2021-08-19 | United Kingdom | Gibraltar | 5261 | 96 | 0 | 36.1408 | -5.3536 | 2021-08-20 04:21:33 | Gibraltar, United Kingdom | |||
2521832 | 2521832 | 2021-08-18 | United Kingdom | Gibraltar | 5248 | 96 | 0 | 36.1408 | -5.3536 | 2021-08-19 04:21:15 | Gibraltar, United Kingdom | |||
248924 | 248924 | 2021-08-17 | United Kingdom | Gibraltar | 5235 | 96 | 0 | 36.1408 | -5.3536 | 2021-08-18 04:21:35 | Gibraltar, United Kingdom | |||
1607887 | 1607887 | 2021-08-16 | United Kingdom | Gibraltar | 5220 | 96 | 0 | 36.1408 | -5.3536 | 2021-08-17 04:21:49 | Gibraltar, United Kingdom | |||
106981 | 106981 | 2021-08-15 | United Kingdom | Gibraltar | 5212 | 95 | 0 | 36.1408 | -5.3536 | 2021-08-16 04:21:31 | Gibraltar, United Kingdom | |||
511339 | 511339 | 2021-08-14 | United Kingdom | Gibraltar | 5205 | 95 | 0 | 36.1408 | -5.3536 | 2021-08-15 04:21:41 | Gibraltar, United Kingdom | |||
1487211 | 1487211 | 2021-08-13 | United Kingdom | Gibraltar | 5196 | 95 | 0 | 36.1408 | -5.3536 | 2021-08-14 04:21:25 | Gibraltar, United Kingdom | |||
2903341 | 2903341 | 2021-08-12 | United Kingdom | Gibraltar | 5187 | 95 | 0 | 36.1408 | -5.3536 | 2021-08-13 04:21:24 | Gibraltar, United Kingdom | |||
1345945 | 1345945 | 2021-08-11 | United Kingdom | Gibraltar | 5171 | 95 | 0 | 36.1408 | -5.3536 | 2021-08-12 04:21:25 | Gibraltar, United Kingdom | |||
2355092 | 2355092 | 2021-08-10 | United Kingdom | Gibraltar | 5154 | 95 | 0 | 36.1408 | -5.3536 | 2021-08-11 04:21:58 | Gibraltar, United Kingdom | |||
653621 | 653621 | 2021-08-09 | United Kingdom | Gibraltar | 5136 | 95 | 0 | 36.1408 | -5.3536 | 2021-08-10 04:21:27 | Gibraltar, United Kingdom | |||
593283 | 593283 | 2021-08-08 | United Kingdom | Gibraltar | 5127 | 95 | 0 | 36.1408 | -5.3536 | 2021-08-09 04:21:24 | Gibraltar, United Kingdom | |||
2207295 | 2207295 | 2021-08-07 | United Kingdom | Gibraltar | 5116 | 95 | 0 | 36.1408 | -5.3536 | 2021-08-08 04:21:33 | Gibraltar, United Kingdom | |||
1121245 | 1121245 | 2021-08-06 | United Kingdom | Gibraltar | 5101 | 95 | 0 | 36.1408 | -5.3536 | 2021-08-07 04:21:30 | Gibraltar, United Kingdom | |||
1960182 | 1960182 | 2021-08-05 | United Kingdom | Gibraltar | 5089 | 95 | 0 | 36.1408 | -5.3536 | 2021-08-06 04:21:18 | Gibraltar, United Kingdom | |||
335561 | 335561 | 2021-08-04 | United Kingdom | Gibraltar | 5056 | 95 | 4670 | 291 | 36.1408 | -5.3536 | 2021-08-05 04:21:51 | Gibraltar, United Kingdom | ||
3471832 | 3471832 | 2021-08-03 | United Kingdom | Gibraltar | 5031 | 94 | 4644 | 293 | 36.1408 | -5.3536 | 2021-08-04 04:21:25 | Gibraltar, United Kingdom | ||
3687106 | 3687106 | 2021-08-02 | United Kingdom | Gibraltar | 5000 | 94 | 4635 | 271 | 36.1408 | -5.3536 | 2021-08-03 04:21:39 | Gibraltar, United Kingdom | ||
3019005 | 3019005 | 2021-08-01 | United Kingdom | Gibraltar | 4980 | 94 | 4614 | 272 | 36.1408 | -5.3536 | 2021-08-02 04:21:36 | Gibraltar, United Kingdom | ||
3907628 | 3907628 | 2021-07-31 | United Kingdom | Gibraltar | 4965 | 94 | 4471 | 400 | 36.1408 | -5.3536 | 2021-08-01 04:21:50 | Gibraltar, United Kingdom | ||
3299833 | 3299833 | 2021-07-30 | United Kingdom | Gibraltar | 4947 | 94 | 4471 | 382 | 36.1408 | -5.3536 | 2021-07-31 04:21:35 | Gibraltar, United Kingdom | ||
3389044 | 3389044 | 2021-07-29 | United Kingdom | Gibraltar | 4922 | 94 | 4471 | 357 | 36.1408 | -5.3536 | 2021-07-30 04:21:34 | Gibraltar, United Kingdom | ||
411949 | 411949 | 2021-07-28 | United Kingdom | Gibraltar | 4892 | 94 | 4470 | 328 | 36.1408 | -5.3536 | 2021-07-29 04:21:33 | Gibraltar, United Kingdom | ||
1309810 | 1309810 | 2021-07-27 | United Kingdom | Gibraltar | 4857 | 94 | 4403 | 360 | 36.1408 | -5.3536 | 2021-07-28 04:21:39 | Gibraltar, United Kingdom | ||
3221953 | 3221953 | 2021-07-26 | United Kingdom | Gibraltar | 4822 | 94 | 4393 | 335 | 36.1408 | -5.3536 | 2021-07-27 04:21:18 | Gibraltar, United Kingdom | ||
1382162 | 1382162 | 2021-07-25 | United Kingdom | Gibraltar | 4799 | 94 | 4374 | 331 | 36.1408 | -5.3536 | 2021-07-26 04:21:28 | Gibraltar, United Kingdom | ||
1333902 | 1333902 | 2021-07-24 | United Kingdom | Gibraltar | 4780 | 94 | 4371 | 315 | 36.1408 | -5.3536 | 2021-07-25 04:22:12 | Gibraltar, United Kingdom | ||
3141206 | 3141206 | 2021-07-23 | United Kingdom | Gibraltar | 4753 | 94 | 4336 | 323 | 36.1408 | -5.3536 | 2021-07-24 00:21:36 | Gibraltar, United Kingdom | ||
3479966 | 3479966 | 2021-07-22 | United Kingdom | Gibraltar | 4728 | 94 | 4336 | 298 | 36.1408 | -5.3536 | 2021-07-23 04:21:29 | Gibraltar, United Kingdom | ||
3335185 | 3335185 | 2021-07-21 | United Kingdom | Gibraltar | 4704 | 94 | 4319 | 291 | 36.1408 | -5.3536 | 2021-07-22 04:21:19 | Gibraltar, United Kingdom | ||
2375166 | 2375166 | 2021-07-20 | United Kingdom | Gibraltar | 4671 | 94 | 4302 | 275 | 36.1408 | -5.3536 | 2021-07-21 04:21:40 | Gibraltar, United Kingdom | ||
487245 | 487245 | 2021-07-19 | United Kingdom | Gibraltar | 4628 | 94 | 4299 | 235 | 36.1408 | -5.3536 | 2021-07-20 04:21:48 | Gibraltar, United Kingdom | ||
2677468 | 2677468 | 2021-07-18 | United Kingdom | Gibraltar | 4595 | 94 | 4286 | 215 | 36.1408 | -5.3536 | 2021-07-19 04:21:24 | Gibraltar, United Kingdom | ||
3709780 | 3709780 | 2021-07-17 | United Kingdom | Gibraltar | 4586 | 94 | 4285 | 207 | 36.1408 | -5.3536 | 2021-07-18 04:22:07 | Gibraltar, United Kingdom | ||
2951011 | 2951011 | 2021-07-16 | United Kingdom | Gibraltar | 4555 | 94 | 4278 | 183 | 36.1408 | -5.3536 | 2021-07-17 04:22:22 | Gibraltar, United Kingdom | ||
299667 | 299667 | 2021-07-15 | United Kingdom | Gibraltar | 4518 | 94 | 4272 | 152 | 36.1408 | -5.3536 | 2021-07-16 04:21:22 | Gibraltar, United Kingdom | ||
3635612 | 3635612 | 2021-07-14 | United Kingdom | Gibraltar | 4486 | 94 | 4266 | 126 | 36.1408 | -5.3536 | 2021-07-15 04:21:48 | Gibraltar, United Kingdom | ||
582487 | 582487 | 2021-07-13 | United Kingdom | Gibraltar | 4460 | 94 | 4266 | 100 | 36.1408 | -5.3536 | 2021-07-14 04:21:35 | Gibraltar, United Kingdom | ||
3744736 | 3744736 | 2021-07-12 | United Kingdom | Gibraltar | 4437 | 94 | 4254 | 89 | 36.1408 | -5.3536 | 2021-07-13 04:21:18 | Gibraltar, United Kingdom | ||
3663249 | 3663249 | 2021-07-11 | United Kingdom | Gibraltar | 4430 | 94 | 4254 | 82 | 36.1408 | -5.3536 | 2021-07-12 04:21:34 | Gibraltar, United Kingdom | ||
629533 | 629533 | 2021-07-10 | United Kingdom | Gibraltar | 4413 | 94 | 4254 | 65 | 36.1408 | -5.3536 | 2021-07-11 04:21:43 | Gibraltar, United Kingdom | ||
833252 | 833252 | 2021-07-09 | United Kingdom | Gibraltar | 4403 | 94 | 4250 | 59 | 36.1408 | -5.3536 | 2021-07-10 04:21:25 | Gibraltar, United Kingdom | ||
782016 | 782016 | 2021-07-08 | United Kingdom | Gibraltar | 4392 | 94 | 4250 | 48 | 36.1408 | -5.3536 | 2021-07-09 04:21:21 | Gibraltar, United Kingdom | ||
1444238 | 1444238 | 2021-07-07 | United Kingdom | Gibraltar | 4385 | 94 | 4246 | 45 | 36.1408 | -5.3536 | 2021-07-08 04:21:26 | Gibraltar, United Kingdom | ||
2697343 | 2697343 | 2021-07-06 | United Kingdom | Gibraltar | 4379 | 94 | 4243 | 42 | 36.1408 | -5.3536 | 2021-07-07 04:21:20 | Gibraltar, United Kingdom | ||
1936092 | 1936092 | 2021-07-05 | United Kingdom | Gibraltar | 4372 | 94 | 4243 | 35 | 36.1408 | -5.3536 | 2021-07-06 04:21:32 | 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]);