cases

99 rows where AreaCode = "E06000044"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Date (date)

Link Date Country AreaCode Area TotalCases
2020-03-09,England,E06000044,Portsmouth 2020-03-09 England E06000044 Portsmouth 1
2020-03-12,England,E06000044,Portsmouth 2020-03-12 England E06000044 Portsmouth 2
2020-03-13,England,E06000044,Portsmouth 2020-03-13 England E06000044 Portsmouth 3
2020-03-14,England,E06000044,Portsmouth 2020-03-14 England E06000044 Portsmouth 6
2020-03-15,England,E06000044,Portsmouth 2020-03-15 England E06000044 Portsmouth 9
2020-03-16,England,E06000044,Portsmouth 2020-03-16 England E06000044 Portsmouth 14
2020-03-17,England,E06000044,Portsmouth 2020-03-17 England E06000044 Portsmouth 17
2020-03-18,England,E06000044,Portsmouth 2020-03-18 England E06000044 Portsmouth 20
2020-03-19,England,E06000044,Portsmouth 2020-03-19 England E06000044 Portsmouth 24
2020-03-20,England,E06000044,Portsmouth 2020-03-20 England E06000044 Portsmouth 27
2020-03-21,England,E06000044,Portsmouth 2020-03-21 England E06000044 Portsmouth 28
2020-03-22,England,E06000044,Portsmouth 2020-03-22 England E06000044 Portsmouth 36
2020-03-23,England,E06000044,Portsmouth 2020-03-23 England E06000044 Portsmouth 45
2020-03-24,England,E06000044,Portsmouth 2020-03-24 England E06000044 Portsmouth 51
2020-03-25,England,E06000044,Portsmouth 2020-03-25 England E06000044 Portsmouth 65
2020-03-26,England,E06000044,Portsmouth 2020-03-26 England E06000044 Portsmouth 70
2020-03-27,England,E06000044,Portsmouth 2020-03-27 England E06000044 Portsmouth 73
2020-03-28,England,E06000044,Portsmouth 2020-03-28 England E06000044 Portsmouth 78
2020-03-29,England,E06000044,Portsmouth 2020-03-29 England E06000044 Portsmouth 80
2020-03-30,England,E06000044,Portsmouth 2020-03-30 England E06000044 Portsmouth 84
2020-03-31,England,E06000044,Portsmouth 2020-03-31 England E06000044 Portsmouth 85
2020-04-01,England,E06000044,Portsmouth 2020-04-01 England E06000044 Portsmouth 91
2020-04-02,England,E06000044,Portsmouth 2020-04-02 England E06000044 Portsmouth 96
2020-04-03,England,E06000044,Portsmouth 2020-04-03 England E06000044 Portsmouth 106
2020-04-04,England,E06000044,Portsmouth 2020-04-04 England E06000044 Portsmouth 112
2020-04-05,England,E06000044,Portsmouth 2020-04-05 England E06000044 Portsmouth 122
2020-04-06,England,E06000044,Portsmouth 2020-04-06 England E06000044 Portsmouth 132
2020-04-07,England,E06000044,Portsmouth 2020-04-07 England E06000044 Portsmouth 140
2020-04-08,England,E06000044,Portsmouth 2020-04-08 England E06000044 Portsmouth 152
2020-04-09,England,E06000044,Portsmouth 2020-04-09 England E06000044 Portsmouth 162
2020-04-10,England,E06000044,Portsmouth 2020-04-10 England E06000044 Portsmouth 171
2020-04-11,England,E06000044,Portsmouth 2020-04-11 England E06000044 Portsmouth 184
2020-04-12,England,E06000044,Portsmouth 2020-04-12 England E06000044 Portsmouth 191
2020-04-13,England,E06000044,Portsmouth 2020-04-13 England E06000044 Portsmouth 195
2020-04-14,England,E06000044,Portsmouth 2020-04-14 England E06000044 Portsmouth 206
2020-04-15,England,E06000044,Portsmouth 2020-04-15 England E06000044 Portsmouth 218
2020-04-16,England,E06000044,Portsmouth 2020-04-16 England E06000044 Portsmouth 224
2020-04-17,England,E06000044,Portsmouth 2020-04-17 England E06000044 Portsmouth 233
2020-04-18,England,E06000044,Portsmouth 2020-04-18 England E06000044 Portsmouth 238
2020-04-19,England,E06000044,Portsmouth 2020-04-19 England E06000044 Portsmouth 241
2020-04-20,England,E06000044,Portsmouth 2020-04-20 England E06000044 Portsmouth 242
2020-04-21,England,E06000044,Portsmouth 2020-04-21 England E06000044 Portsmouth 256
2020-04-22,England,E06000044,Portsmouth 2020-04-22 England E06000044 Portsmouth 283
2020-04-23,England,E06000044,Portsmouth 2020-04-23 England E06000044 Portsmouth 296
2020-04-24,England,E06000044,Portsmouth 2020-04-24 England E06000044 Portsmouth 308
2020-04-25,England,E06000044,Portsmouth 2020-04-25 England E06000044 Portsmouth 314
2020-04-26,England,E06000044,Portsmouth 2020-04-26 England E06000044 Portsmouth 330
2020-04-27,England,E06000044,Portsmouth 2020-04-27 England E06000044 Portsmouth 339
2020-04-28,England,E06000044,Portsmouth 2020-04-28 England E06000044 Portsmouth 350
2020-04-29,England,E06000044,Portsmouth 2020-04-29 England E06000044 Portsmouth 361
2020-04-30,England,E06000044,Portsmouth 2020-04-30 England E06000044 Portsmouth 370
2020-05-01,England,E06000044,Portsmouth 2020-05-01 England E06000044 Portsmouth 383
2020-05-02,England,E06000044,Portsmouth 2020-05-02 England E06000044 Portsmouth 391
2020-05-03,England,E06000044,Portsmouth 2020-05-03 England E06000044 Portsmouth 393
2020-05-04,England,E06000044,Portsmouth 2020-05-04 England E06000044 Portsmouth 399
2020-05-05,England,E06000044,Portsmouth 2020-05-05 England E06000044 Portsmouth 408
2020-05-06,England,E06000044,Portsmouth 2020-05-06 England E06000044 Portsmouth 422
2020-05-07,England,E06000044,Portsmouth 2020-05-07 England E06000044 Portsmouth 429
2020-05-08,England,E06000044,Portsmouth 2020-05-08 England E06000044 Portsmouth 434
2020-05-10,England,E06000044,Portsmouth 2020-05-10 England E06000044 Portsmouth 437
2020-05-11,England,E06000044,Portsmouth 2020-05-11 England E06000044 Portsmouth 438
2020-05-13,England,E06000044,Portsmouth 2020-05-13 England E06000044 Portsmouth 445
2020-05-14,England,E06000044,Portsmouth 2020-05-14 England E06000044 Portsmouth 446
2020-05-15,England,E06000044,Portsmouth 2020-05-15 England E06000044 Portsmouth 448
2020-05-16,England,E06000044,Portsmouth 2020-05-16 England E06000044 Portsmouth 450
2020-05-17,England,E06000044,Portsmouth 2020-05-17 England E06000044 Portsmouth 453
2020-05-18,England,E06000044,Portsmouth 2020-05-18 England E06000044 Portsmouth 458
2020-05-19,England,E06000044,Portsmouth 2020-05-19 England E06000044 Portsmouth 461
2020-05-20,England,E06000044,Portsmouth 2020-05-20 England E06000044 Portsmouth 463
2020-05-22,England,E06000044,Portsmouth 2020-05-22 England E06000044 Portsmouth 465
2020-05-23,England,E06000044,Portsmouth 2020-05-23 England E06000044 Portsmouth 466
2020-05-25,England,E06000044,Portsmouth 2020-05-25 England E06000044 Portsmouth 467
2020-05-26,England,E06000044,Portsmouth 2020-05-26 England E06000044 Portsmouth 470
2020-05-27,England,E06000044,Portsmouth 2020-05-27 England E06000044 Portsmouth 472
2020-05-28,England,E06000044,Portsmouth 2020-05-28 England E06000044 Portsmouth 476
2020-05-29,England,E06000044,Portsmouth 2020-05-29 England E06000044 Portsmouth 477
2020-05-30,England,E06000044,Portsmouth 2020-05-30 England E06000044 Portsmouth 478
2020-06-02,England,E06000044,Portsmouth 2020-06-02 England E06000044 Portsmouth 479
2020-06-05,England,E06000044,Portsmouth 2020-06-05 England E06000044 Portsmouth 481
2020-06-06,England,E06000044,Portsmouth 2020-06-06 England E06000044 Portsmouth 483
2020-06-07,England,E06000044,Portsmouth 2020-06-07 England E06000044 Portsmouth 484
2020-06-08,England,E06000044,Portsmouth 2020-06-08 England E06000044 Portsmouth 487
2020-06-09,England,E06000044,Portsmouth 2020-06-09 England E06000044 Portsmouth 488
2020-06-10,England,E06000044,Portsmouth 2020-06-10 England E06000044 Portsmouth 489
2020-06-19,England,E06000044,Portsmouth 2020-06-19 England E06000044 Portsmouth 490
2020-06-20,England,E06000044,Portsmouth 2020-06-20 England E06000044 Portsmouth 491
2020-06-29,England,E06000044,Portsmouth 2020-06-29 England E06000044 Portsmouth 493
2020-07-01,England,E06000044,Portsmouth 2020-07-01 England E06000044 Portsmouth 494
2020-07-05,England,E06000044,Portsmouth 2020-07-05 England E06000044 Portsmouth 495
2020-07-06,England,E06000044,Portsmouth 2020-07-06 England E06000044 Portsmouth 496
2020-07-07,England,E06000044,Portsmouth 2020-07-07 England E06000044 Portsmouth 497
2020-07-08,England,E06000044,Portsmouth 2020-07-08 England E06000044 Portsmouth 501
2020-07-13,England,E06000044,Portsmouth 2020-07-13 England E06000044 Portsmouth 502
2020-07-14,England,E06000044,Portsmouth 2020-07-14 England E06000044 Portsmouth 503
2020-07-16,England,E06000044,Portsmouth 2020-07-16 England E06000044 Portsmouth 504
2020-07-18,England,E06000044,Portsmouth 2020-07-18 England E06000044 Portsmouth 505
2020-07-20,England,E06000044,Portsmouth 2020-07-20 England E06000044 Portsmouth 506
2020-07-22,England,E06000044,Portsmouth 2020-07-22 England E06000044 Portsmouth 507
2020-07-25,England,E06000044,Portsmouth 2020-07-25 England E06000044 Portsmouth 507

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "cases" (
"Date" TEXT,
  "Country" TEXT,
  "AreaCode" TEXT,
  "Area" TEXT,
  "TotalCases" INTEGER
  ,PRIMARY KEY ([Date], [Country], [AreaCode], [Area])
);
Powered by Datasette · Query took 43.793ms · About: https://github.com/tomwhite/covid-19-uk-data