Leeds City Centre Footfall Data
Leeds City Council
@ukgov.leeds_city_centre_footfall_data
Leeds City Council
@ukgov.leeds_city_centre_footfall_data
CREATE TABLE n_01_01_2018_31_01_2018 (
"site" VARCHAR,
"locationname" VARCHAR,
"brcyear" BIGINT,
"brcmonthname" VARCHAR,
"brcweeknum" BIGINT,
"dayname" VARCHAR,
"date" VARCHAR,
"hour" VARCHAR,
"incount" BIGINT,
"outcount" BIGINT,
"reportcount" BIGINT,
"factoredincount" BIGINT,
"factoredoutcount" BIGINT,
"factoredreportcount" BIGINT
);
CREATE TABLE n_01_01_2019_31_01_2019 (
"site" VARCHAR,
"locationname" VARCHAR,
"brcyear" BIGINT,
"brcmonthname" VARCHAR,
"brcweeknum" BIGINT,
"dayname" VARCHAR,
"date" VARCHAR,
"hour" VARCHAR,
"incount" BIGINT,
"outcount" BIGINT,
"reportcount" BIGINT,
"factoredincount" BIGINT,
"factoredoutcount" BIGINT,
"factoredreportcount" BIGINT,
"locationgroup" VARCHAR
);
CREATE TABLE n_01_01_2020_31_01_2020 (
"site" VARCHAR,
"locationname" VARCHAR,
"brcyear" BIGINT,
"brcmonthname" VARCHAR,
"brcweeknum" BIGINT,
"dayname" VARCHAR,
"date" VARCHAR,
"hour" VARCHAR,
"incount" BIGINT,
"outcount" BIGINT,
"reportcount" BIGINT,
"factoredincount" BIGINT,
"factoredoutcount" BIGINT,
"factoredreportcount" BIGINT,
"locationgroup" VARCHAR
);
CREATE TABLE n_01_02_2017_28_02_2017 (
"site" VARCHAR,
"location" VARCHAR,
"brcyear" BIGINT,
"brcmonthname" VARCHAR,
"brcweek" BIGINT,
"dayofweek" VARCHAR,
"date" VARCHAR,
"hour" VARCHAR,
"incount" BIGINT,
"outcount" BIGINT,
"reportcount" BIGINT,
"factoredincount" BIGINT,
"factoredoutcount" BIGINT,
"factoredreportcount" BIGINT
);
CREATE TABLE n_01_02_2018_28_02_2018 (
"site" VARCHAR,
"locationname" VARCHAR,
"brcyear" BIGINT,
"brcmonthname" VARCHAR,
"brcweeknum" BIGINT,
"dayname" VARCHAR,
"date" VARCHAR,
"hour" VARCHAR,
"incount" BIGINT,
"outcount" BIGINT,
"reportcount" BIGINT,
"factoredincount" BIGINT,
"factoredoutcount" BIGINT,
"factoredreportcount" BIGINT
);
CREATE TABLE n_01_02_2020_29_02_2020 (
"site" VARCHAR,
"locationname" VARCHAR,
"brcyear" BIGINT,
"brcmonthname" VARCHAR,
"brcweeknum" BIGINT,
"dayname" VARCHAR,
"date" VARCHAR,
"hour" VARCHAR,
"incount" BIGINT,
"outcount" BIGINT,
"reportcount" BIGINT,
"factoredincount" BIGINT,
"factoredoutcount" BIGINT,
"factoredreportcount" BIGINT,
"locationgroup" VARCHAR
);
CREATE TABLE n_01_03_2018_31_03_2018 (
"site" VARCHAR,
"locationname" VARCHAR,
"brcyear" BIGINT,
"brcmonthname" VARCHAR,
"brcweeknum" BIGINT,
"dayname" VARCHAR,
"date" VARCHAR,
"hour" VARCHAR,
"incount" BIGINT,
"outcount" BIGINT,
"reportcount" BIGINT,
"factoredincount" BIGINT,
"factoredoutcount" BIGINT,
"factoredreportcount" BIGINT
);
CREATE TABLE n_01_03_2019_31_03_2019 (
"site" VARCHAR,
"locationname" VARCHAR,
"brcyear" BIGINT,
"brcmonthname" VARCHAR,
"brcweeknum" BIGINT,
"dayname" VARCHAR,
"date" VARCHAR,
"hour" VARCHAR,
"incount" BIGINT,
"outcount" BIGINT,
"reportcount" BIGINT,
"factoredincount" BIGINT,
"factoredoutcount" BIGINT,
"factoredreportcount" BIGINT,
"locationgroup" VARCHAR
);
CREATE TABLE n_01_03_2020_31_03_2020 (
"site" VARCHAR,
"locationname" VARCHAR,
"brcyear" BIGINT,
"brcmonthname" VARCHAR,
"brcweeknum" BIGINT,
"dayname" VARCHAR,
"date" VARCHAR,
"hour" VARCHAR,
"incount" BIGINT,
"outcount" BIGINT,
"reportcount" BIGINT,
"factoredincount" BIGINT,
"factoredoutcount" BIGINT,
"factoredreportcount" BIGINT,
"locationgroup" VARCHAR
);
CREATE TABLE n_01_04_2017_30_04_2017 (
"site" VARCHAR,
"location" VARCHAR,
"brcyear" DOUBLE,
"brcmonthname" VARCHAR,
"brcweek" DOUBLE,
"dayofweek" VARCHAR,
"date" VARCHAR,
"hour" VARCHAR,
"incount" DOUBLE,
"outcount" DOUBLE,
"reportcount" DOUBLE,
"factoredincount" DOUBLE,
"factoredoutcount" DOUBLE,
"factoredreportcount" DOUBLE
);
CREATE TABLE n_01_04_2018_30_04_2018 (
"site" VARCHAR,
"locationname" VARCHAR,
"brcyear" BIGINT,
"brcmonthname" VARCHAR,
"brcweeknum" BIGINT,
"dayname" VARCHAR,
"date" VARCHAR,
"hour" VARCHAR,
"incount" BIGINT,
"outcount" BIGINT,
"reportcount" BIGINT,
"factoredincount" BIGINT,
"factoredoutcount" BIGINT,
"factoredreportcount" BIGINT
);
CREATE TABLE n_01_04_2020_30_04_2020 (
"site" VARCHAR,
"locationname" VARCHAR,
"brcyear" BIGINT,
"brcmonthname" VARCHAR,
"brcweeknum" BIGINT,
"dayname" VARCHAR,
"date" VARCHAR,
"hour" VARCHAR,
"incount" BIGINT,
"outcount" BIGINT,
"reportcount" BIGINT,
"factoredincount" BIGINT,
"factoredoutcount" BIGINT,
"factoredreportcount" BIGINT,
"locationgroup" VARCHAR
);
CREATE TABLE n_01_05_2017_31_05_2017 (
"site" VARCHAR,
"locationname" VARCHAR,
"brcyear" BIGINT,
"brcmonthname" VARCHAR,
"brcweeknum" BIGINT,
"dayname" VARCHAR,
"date" VARCHAR,
"hour" VARCHAR,
"incount" BIGINT,
"outcount" BIGINT,
"reportcount" BIGINT,
"factoredincount" BIGINT,
"factoredoutcount" BIGINT,
"factoredreportcount" BIGINT
);
CREATE TABLE n_01_05_2019_31_05_2019 (
"site" VARCHAR,
"locationname" VARCHAR,
"brcyear" BIGINT,
"brcmonthname" VARCHAR,
"brcweeknum" BIGINT,
"dayname" VARCHAR,
"date" VARCHAR,
"hour" VARCHAR,
"incount" BIGINT,
"outcount" BIGINT,
"reportcount" BIGINT,
"factoredincount" BIGINT,
"factoredoutcount" BIGINT,
"factoredreportcount" BIGINT,
"locationgroup" VARCHAR
);
CREATE TABLE n_01_05_2020_31_05_2020 (
"site" VARCHAR,
"locationname" VARCHAR,
"brcyear" BIGINT,
"brcmonthname" VARCHAR,
"brcweeknum" BIGINT,
"dayname" VARCHAR,
"date" VARCHAR,
"hour" VARCHAR,
"incount" BIGINT,
"outcount" BIGINT,
"reportcount" BIGINT,
"factoredincount" BIGINT,
"factoredoutcount" BIGINT,
"factoredreportcount" BIGINT,
"locationgroup" VARCHAR
);
CREATE TABLE n_01_07_2017_31_07_2017 (
"site" VARCHAR,
"locationname" VARCHAR,
"brcyear" BIGINT,
"brcmonthname" VARCHAR,
"brcweeknum" BIGINT,
"dayname" VARCHAR,
"date" VARCHAR,
"hour" VARCHAR,
"incount" BIGINT,
"outcount" BIGINT,
"reportcount" BIGINT,
"factoredincount" BIGINT,
"factoredoutcount" BIGINT,
"factoredreportcount" BIGINT
);
CREATE TABLE n_01_08_2016_31_08_2016 (
"date" TIMESTAMP,
"hour" BIGINT,
"sitename" VARCHAR,
"locationname" VARCHAR,
"locationgroup" VARCHAR,
"weekday" VARCHAR,
"brcyear" BIGINT,
"brcquarter" BIGINT,
"brcmonthname" VARCHAR,
"brcweek" BIGINT,
"incount" BIGINT,
"outcount" BIGINT,
"totalcount" BIGINT,
"businessincount" BIGINT,
"businessoutcount" BIGINT,
"businesstotalcount" BIGINT,
"factoredincount" BIGINT,
"factoredoutcount" BIGINT,
"factoredtotalcount" BIGINT
);
CREATE TABLE n_01_08_2017_31_08_2017 (
"site" VARCHAR,
"locationname" VARCHAR,
"brcyear" BIGINT,
"brcmonthname" VARCHAR,
"brcweeknum" BIGINT,
"dayname" VARCHAR,
"date" VARCHAR,
"hour" VARCHAR,
"incount" BIGINT,
"outcount" BIGINT,
"reportcount" BIGINT,
"factoredincount" BIGINT,
"factoredoutcount" BIGINT,
"factoredreportcount" BIGINT
);
CREATE TABLE n_01_08_2018_31_08_2018 (
"site" VARCHAR,
"locationname" VARCHAR,
"brcyear" BIGINT,
"brcmonthname" VARCHAR,
"brcweeknum" BIGINT,
"dayname" VARCHAR,
"date" VARCHAR,
"hour" VARCHAR,
"incount" BIGINT,
"outcount" BIGINT,
"reportcount" BIGINT,
"factoredincount" BIGINT,
"factoredoutcount" BIGINT,
"factoredreportcount" BIGINT
);
CREATE TABLE n_01_08_2019_31_08_2019 (
"site" VARCHAR,
"locationname" VARCHAR,
"brcyear" BIGINT,
"brcmonthname" VARCHAR,
"brcweeknum" BIGINT,
"dayname" VARCHAR,
"date" VARCHAR,
"hour" VARCHAR,
"incount" BIGINT,
"outcount" BIGINT,
"reportcount" BIGINT,
"factoredincount" BIGINT,
"factoredoutcount" BIGINT,
"factoredreportcount" BIGINT,
"locationgroup" VARCHAR
);
CREATE TABLE n_01_09_2014_05_10_2014 (
"date" TIMESTAMP,
"hour" BIGINT,
"locationname" VARCHAR,
"locationgroup" VARCHAR,
"weekday" VARCHAR,
"brcyear" BIGINT,
"brcquarter" BIGINT,
"brcmonthname" VARCHAR,
"brcweek" BIGINT,
"incount" BIGINT,
"outcount" BIGINT,
"totalcount" BIGINT
);
CREATE TABLE n_01_09_2016_30_09_2016 (
"date" TIMESTAMP,
"hour" BIGINT,
"sitename" VARCHAR,
"locationname" VARCHAR,
"locationgroup" VARCHAR,
"weekday" VARCHAR,
"brcyear" BIGINT,
"brcquarter" BIGINT,
"brcmonthname" VARCHAR,
"brcweek" BIGINT,
"incount" BIGINT,
"outcount" BIGINT,
"totalcount" BIGINT,
"businessincount" BIGINT,
"businessoutcount" BIGINT,
"businesstotalcount" BIGINT,
"factoredincount" BIGINT,
"factoredoutcount" BIGINT,
"factoredtotalcount" BIGINT
);
CREATE TABLE n_01_10_2016_31_10_2016 (
"date" TIMESTAMP,
"hour" BIGINT,
"sitename" VARCHAR,
"locationname" VARCHAR,
"locationgroup" VARCHAR,
"weekday" VARCHAR,
"brcyear" BIGINT,
"brcquarter" BIGINT,
"brcmonthname" VARCHAR,
"brcweek" BIGINT,
"incount" BIGINT,
"outcount" BIGINT,
"totalcount" BIGINT,
"businessincount" BIGINT,
"businessoutcount" BIGINT,
"businesstotalcount" BIGINT,
"factoredincount" BIGINT,
"factoredoutcount" BIGINT,
"factoredtotalcount" BIGINT
);
CREATE TABLE n_01_10_2017_31_10_2017 (
"site" VARCHAR,
"locationname" VARCHAR,
"brcyear" BIGINT,
"brcmonthname" VARCHAR,
"brcweeknum" BIGINT,
"dayname" VARCHAR,
"date" VARCHAR,
"hour" VARCHAR,
"incount" BIGINT,
"outcount" BIGINT,
"reportcount" BIGINT,
"factoredincount" BIGINT,
"factoredoutcount" BIGINT,
"factoredreportcount" BIGINT
);
CREATE TABLE n_01_10_2018_31_10_2018 (
"site" VARCHAR,
"locationname" VARCHAR,
"brcyear" BIGINT,
"brcmonthname" VARCHAR,
"brcweeknum" BIGINT,
"dayname" VARCHAR,
"date" VARCHAR,
"hour" VARCHAR,
"incount" BIGINT,
"outcount" BIGINT,
"reportcount" BIGINT,
"factoredincount" BIGINT,
"factoredoutcount" BIGINT,
"factoredreportcount" BIGINT,
"locationgroup" VARCHAR
);
Anyone who has the link will be able to view this.