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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
1168823 | 1168823 | 2021-07-04 | United Kingdom | Gibraltar | 4366 | 94 | 4240 | 32 | 36.1408 | -5.3536 | 2021-07-05 04:21:28 | Gibraltar, United Kingdom | ||
1499257 | 1499257 | 2021-07-03 | United Kingdom | Gibraltar | 4364 | 94 | 4229 | 41 | 36.1408 | -5.3536 | 2021-07-04 04:21:38 | Gibraltar, United Kingdom | ||
2075572 | 2075572 | 2021-07-02 | United Kingdom | Gibraltar | 4357 | 94 | 4229 | 34 | 36.1408 | -5.3536 | 2021-07-03 04:21:37 | Gibraltar, United Kingdom | ||
2768588 | 2768588 | 2021-07-01 | United Kingdom | Gibraltar | 4351 | 94 | 4229 | 28 | 36.1408 | -5.3536 | 2021-07-02 04:21:47 | Gibraltar, United Kingdom | ||
1896796 | 1896796 | 2021-06-30 | United Kingdom | Gibraltar | 4348 | 94 | 4226 | 28 | 36.1408 | -5.3536 | 2021-07-01 04:21:19 | Gibraltar, United Kingdom | ||
403919 | 403919 | 2021-06-29 | United Kingdom | Gibraltar | 4348 | 94 | 4226 | 28 | 36.1408 | -5.3536 | 2021-06-30 04:21:41 | Gibraltar, United Kingdom | ||
3129162 | 3129162 | 2021-06-28 | United Kingdom | Gibraltar | 4346 | 94 | 4223 | 29 | 36.1408 | -5.3536 | 2021-06-29 04:21:28 | Gibraltar, United Kingdom | ||
2593657 | 2593657 | 2021-06-27 | United Kingdom | Gibraltar | 4345 | 94 | 4221 | 30 | 36.1408 | -5.3536 | 2021-06-28 04:21:29 | Gibraltar, United Kingdom | ||
3962161 | 3962161 | 2021-06-26 | United Kingdom | Gibraltar | 4339 | 94 | 4217 | 28 | 36.1408 | -5.3536 | 2021-06-27 04:21:39 | Gibraltar, United Kingdom | ||
1715980 | 1715980 | 2021-06-25 | United Kingdom | Gibraltar | 4338 | 94 | 4217 | 27 | 36.1408 | -5.3536 | 2021-06-26 04:21:43 | Gibraltar, United Kingdom | ||
2299105 | 2299105 | 2021-06-24 | United Kingdom | Gibraltar | 4335 | 94 | 4216 | 25 | 36.1408 | -5.3536 | 2021-06-25 04:21:33 | Gibraltar, United Kingdom | ||
2426544 | 2426544 | 2021-06-23 | United Kingdom | Gibraltar | 4332 | 94 | 4216 | 22 | 36.1408 | -5.3536 | 2021-06-24 04:21:55 | Gibraltar, United Kingdom | ||
566621 | 566621 | 2021-06-22 | United Kingdom | Gibraltar | 4323 | 94 | 4214 | 15 | 36.1408 | -5.3536 | 2021-06-23 04:21:46 | Gibraltar, United Kingdom | ||
3362323 | 3362323 | 2021-06-21 | United Kingdom | Gibraltar | 4321 | 94 | 4211 | 16 | 36.1408 | -5.3536 | 2021-06-22 04:21:34 | Gibraltar, United Kingdom | ||
2888022 | 2888022 | 2021-06-20 | United Kingdom | Gibraltar | 4321 | 94 | 4209 | 18 | 36.1408 | -5.3536 | 2021-06-21 04:21:41 | Gibraltar, United Kingdom | ||
111105 | 111105 | 2021-06-19 | United Kingdom | Gibraltar | 4319 | 94 | 4208 | 17 | 36.1408 | -5.3536 | 2021-06-20 04:21:48 | Gibraltar, United Kingdom | ||
1129248 | 1129248 | 2021-06-18 | United Kingdom | Gibraltar | 4318 | 94 | 4206 | 18 | 36.1408 | -5.3536 | 2021-06-19 04:22:33 | Gibraltar, United Kingdom | ||
2914826 | 2914826 | 2021-06-17 | United Kingdom | Gibraltar | 4317 | 94 | 4206 | 17 | 36.1408 | -5.3536 | 2021-06-18 04:22:16 | Gibraltar, United Kingdom | ||
3033942 | 3033942 | 2021-06-16 | United Kingdom | Gibraltar | 4315 | 94 | 4206 | 15 | 36.1408 | -5.3536 | 2021-06-17 04:22:36 | Gibraltar, United Kingdom | ||
2343048 | 2343048 | 2021-06-15 | United Kingdom | Gibraltar | 4312 | 94 | 4205 | 13 | 36.1408 | -5.3536 | 2021-06-16 04:22:32 | Gibraltar, United Kingdom | ||
1567744 | 1567744 | 2021-06-14 | United Kingdom | Gibraltar | 4312 | 94 | 4205 | 13 | 36.1408 | -5.3536 | 2021-06-15 04:22:22 | Gibraltar, United Kingdom | ||
3385027 | 3385027 | 2021-06-13 | United Kingdom | Gibraltar | 4312 | 94 | 4203 | 15 | 36.1408 | -5.3536 | 2021-06-14 04:22:46 | Gibraltar, United Kingdom | ||
1740161 | 1740161 | 2021-06-12 | United Kingdom | Gibraltar | 4310 | 94 | 4201 | 15 | 36.1408 | -5.3536 | 2021-06-13 04:22:44 | Gibraltar, United Kingdom | ||
3974202 | 3974202 | 2021-06-11 | United Kingdom | Gibraltar | 4308 | 94 | 4200 | 14 | 36.1408 | -5.3536 | 2021-06-12 04:22:22 | Gibraltar, United Kingdom | ||
2720624 | 2720624 | 2021-06-10 | United Kingdom | Gibraltar | 4306 | 94 | 4200 | 12 | 36.1408 | -5.3536 | 2021-06-11 04:23:20 | Gibraltar, United Kingdom | ||
526509 | 526509 | 2021-06-09 | United Kingdom | Gibraltar | 4304 | 94 | 4199 | 11 | 36.1408 | -5.3536 | 2021-06-10 04:23:17 | Gibraltar, United Kingdom | ||
3475949 | 3475949 | 2021-06-08 | United Kingdom | Gibraltar | 4302 | 94 | 4199 | 9 | 36.1408 | -5.3536 | 2021-06-09 04:23:31 | Gibraltar, United Kingdom | ||
3149233 | 3149233 | 2021-06-07 | United Kingdom | Gibraltar | 4300 | 94 | 4199 | 7 | 36.1408 | -5.3536 | 2021-06-08 04:22:35 | 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]);