Coronavirus (COVID-19) Mobility Report
Greater London Authority
@ukgov.coronavirus_covid_19_mobility_report
Greater London Authority
@ukgov.coronavirus_covid_19_mobility_report
CREATE TABLE footfall_by_age (
"merged_age_range" VARCHAR,
"date" TIMESTAMP,
"total" DOUBLE
);
CREATE TABLE home_working_indicators (
"location" VARCHAR,
"activity" VARCHAR,
"date" TIMESTAMP,
"change" BIGINT,
"value" BIGINT,
"source" VARCHAR
);
CREATE TABLE mobility_indices (
"date" TIMESTAMP,
"activity" VARCHAR,
"value" DOUBLE,
"roll" DOUBLE,
"source" VARCHAR
);
CREATE TABLE pedestrian_footfall (
"location" VARCHAR,
"activity" VARCHAR,
"date" TIMESTAMP,
"change" VARCHAR,
"value" VARCHAR,
"source" VARCHAR,
"roll" VARCHAR
);
CREATE TABLE retail_and_recreation (
"location" VARCHAR,
"activity" VARCHAR,
"date" TIMESTAMP,
"change" DOUBLE,
"value" DOUBLE,
"source" VARCHAR,
"roll" DOUBLE
);
Anyone who has the link will be able to view this.