This data as json, CSV (advanced)
Link | Date | Country | AreaCode | Area | TotalCases |
---|---|---|---|---|---|
2020-03-19,England,E06000042,Milton Keynes | 2020-03-19 | England | E06000042 | Milton Keynes | 26 |
2020-03-19,England,E08000008,Tameside | 2020-03-19 | England | E08000008 | Tameside | 26 |
2020-03-19,England,E08000026,Coventry | 2020-03-19 | England | E08000026 | Coventry | 26 |
2020-03-19,England,E10000029,Suffolk | 2020-03-19 | England | E10000029 | Suffolk | 26 |
JSON shape: default, array, newline-delimited, object
CREATE TABLE "cases" ( "Date" TEXT, "Country" TEXT, "AreaCode" TEXT, "Area" TEXT, "TotalCases" INTEGER ,PRIMARY KEY ([Date], [Country], [AreaCode], [Area]) );