About this Dataset

COVID-19 Restrictions Timeseries

National and local restrictions and policies affecting London, by date. Supplied as an experimental dataset to provide context for analysis of other social or economic datasets, for instance, footfall and spend data timeseries. Information was mainly gathered from government announcements published by the Prime Minister's Office. The restrictions and policies included are: * School closures - complete closures only * Pub closures - excluding pubs that serve food * Shop closures - non-essential * Eating Places closures - including pubs that serve food * Stay at home orders * Household mixing indoors banned * Working from home encouraged * Rule of 6 indoors * 10pm curfew on hospitality * Eat Out to Help Out scheme
Publisher name: Greater London Authority
Last updated: 2024-06-13T04:07:43Z

Tables

Restrictions Daily

@ukgov.covid_19_restrictions_timeseries.restrictions_daily

21 KB
1416 rows
11 columns


CREATE TABLE restrictions_daily (
  "date" TIMESTAMP,
  "schools_closed" BIGINT,
  "pubs_closed" BIGINT,
  "shops_closed" BIGINT,
  "eating_places_closed" BIGINT,
  "stay_at_home" BIGINT,
  "household_mixing_indoors_banned" BIGINT,
  "wfh" BIGINT,
  "rule_of_6_indoors" BIGINT,
  "curfew" BIGINT,
  "eat_out_to_help_out" BIGINT
);

Restrictions Summary

@ukgov.covid_19_restrictions_timeseries.restrictions_summary

11.75 KB
30 rows
13 columns


CREATE TABLE restrictions_summary (
  "date" VARCHAR,
  "restriction" VARCHAR,
  "source" VARCHAR,
  "schools_closed" BIGINT,
  "pubs_closed" BIGINT,
  "shops_closed" BIGINT,
  "eating_places_closed" BIGINT,
  "stay_at_home" BIGINT,
  "household_mixing_indoors_banned" BIGINT,
  "wfh" BIGINT,
  "rule_of_6_indoors" BIGINT,
  "curfew" BIGINT,
  "eat_out_to_help_out" BIGINT
);

Restrictions Weekly

@ukgov.covid_19_restrictions_timeseries.restrictions_weekly

10.71 KB
202 rows
11 columns


CREATE TABLE restrictions_weekly (
  "week_start" TIMESTAMP,
  "schools_closed" BIGINT,
  "pubs_closed" BIGINT,
  "shops_closed" BIGINT,
  "eating_places_closed" BIGINT,
  "stay_at_home" BIGINT,
  "household_mixing_indoors_banned" BIGINT,
  "wfh" BIGINT,
  "rule_of_6_indoors" BIGINT,
  "curfew" BIGINT,
  "eat_out_to_help_out" BIGINT
);