Baselight

Leeds City Centre Footfall Data

Leeds City Council

@ukgov.leeds_city_centre_footfall_data

Loading...
Loading...

About this Dataset

Leeds City Centre Footfall Data

There are 7 cameras located at various locations around the city centre monitoring numbers of people walking past. These cameras calculate numbers on an hourly basis. This data can help identify footfall trends in the city centre and helps city centre management. Please note ----------- * The format of the data has changed as at 31/01/2014 to ensure one CSV document incorporates all camera sites. This will be the new format going forward. * Datasets will be published on a monthly basis in line with the British Retail Consortium (BRC) calendar (refer to PDF guidance document).
Publisher name: Leeds City Council
Last updated: 2024-09-14T10:02:05Z

Tables

01/01/2018 - 31/01/2018

@ukgov.leeds_city_centre_footfall_data.n_01_01_2018_31_01_2018
  • 16.18 KB
  • 248 rows
  • 14 columns
Loading...

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
);

01/01/2019 - 31/01/2019

@ukgov.leeds_city_centre_footfall_data.n_01_01_2019_31_01_2019
  • 64.16 KB
  • 4464 rows
  • 15 columns
Loading...

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
);

01/01/2020 - 31/01/2020

@ukgov.leeds_city_centre_footfall_data.n_01_01_2020_31_01_2020
  • 64.19 KB
  • 4464 rows
  • 15 columns
Loading...

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
);

01/02/2017 - 28/02/2017

@ukgov.leeds_city_centre_footfall_data.n_01_02_2017_28_02_2017
  • 81.68 KB
  • 5376 rows
  • 14 columns
Loading...

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
);

01/02/2018 - 28/02/2018

@ukgov.leeds_city_centre_footfall_data.n_01_02_2018_28_02_2018
  • 15.06 KB
  • 224 rows
  • 14 columns
Loading...

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
);

01/02/2020 - 29/02/2020

@ukgov.leeds_city_centre_footfall_data.n_01_02_2020_29_02_2020
  • 61.79 KB
  • 4176 rows
  • 15 columns
Loading...

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
);

01/03/2018 - 31/03/2018

@ukgov.leeds_city_centre_footfall_data.n_01_03_2018_31_03_2018
  • 15.57 KB
  • 248 rows
  • 14 columns
Loading...

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
);

01/03/2019 - 31/03/2019

@ukgov.leeds_city_centre_footfall_data.n_01_03_2019_31_03_2019
  • 66.13 KB
  • 4464 rows
  • 15 columns
Loading...

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
);

01/03/2020 - 31/03/2020

@ukgov.leeds_city_centre_footfall_data.n_01_03_2020_31_03_2020
  • 59.02 KB
  • 4464 rows
  • 15 columns
Loading...

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
);

01/04/2017 - 30/04/2017

@ukgov.leeds_city_centre_footfall_data.n_01_04_2017_30_04_2017
  • 85.81 KB
  • 5952 rows
  • 14 columns
Loading...

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
);

01/04/2018 - 30/04/2018

@ukgov.leeds_city_centre_footfall_data.n_01_04_2018_30_04_2018
  • 80.48 KB
  • 5760 rows
  • 14 columns
Loading...

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
);

01/04/2020 - 30/04/2020

@ukgov.leeds_city_centre_footfall_data.n_01_04_2020_30_04_2020
  • 36.81 KB
  • 4320 rows
  • 15 columns
Loading...

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
);

01/05/2017 - 31/05/2017

@ukgov.leeds_city_centre_footfall_data.n_01_05_2017_31_05_2017
  • 87.18 KB
  • 5952 rows
  • 14 columns
Loading...

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
);

01/05/2019 - 31/05/2019

@ukgov.leeds_city_centre_footfall_data.n_01_05_2019_31_05_2019
  • 66.24 KB
  • 4464 rows
  • 15 columns
Loading...

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
);

01/05/2020 - 31/05/2020

@ukgov.leeds_city_centre_footfall_data.n_01_05_2020_31_05_2020
  • 38.43 KB
  • 4464 rows
  • 15 columns
Loading...

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
);

01/07/2017 - 31/07/2017

@ukgov.leeds_city_centre_footfall_data.n_01_07_2017_31_07_2017
  • 87.73 KB
  • 5759 rows
  • 14 columns
Loading...

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
);

01/08/2016 - 31/08/2016

@ukgov.leeds_city_centre_footfall_data.n_01_08_2016_31_08_2016
  • 86.82 KB
  • 5952 rows
  • 19 columns
Loading...

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
);

01/08/2017 - 31/08/2017

@ukgov.leeds_city_centre_footfall_data.n_01_08_2017_31_08_2017
  • 89.16 KB
  • 5952 rows
  • 14 columns
Loading...

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
);

01/08/2018 - 31/08/2018

@ukgov.leeds_city_centre_footfall_data.n_01_08_2018_31_08_2018
  • 81.13 KB
  • 5952 rows
  • 14 columns
Loading...

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
);

01/08/2019 - 31/08/2019

@ukgov.leeds_city_centre_footfall_data.n_01_08_2019_31_08_2019
  • 66.92 KB
  • 4464 rows
  • 15 columns
Loading...

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
);

01/09/2014 - 05/10/2014

@ukgov.leeds_city_centre_footfall_data.n_01_09_2014_05_10_2014
  • 52.71 KB
  • 6720 rows
  • 12 columns
Loading...

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
);

01/09/2016 - 30/09/2016

@ukgov.leeds_city_centre_footfall_data.n_01_09_2016_30_09_2016
  • 89.19 KB
  • 5760 rows
  • 19 columns
Loading...

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
);

01/10/2016 - 31/10/2016

@ukgov.leeds_city_centre_footfall_data.n_01_10_2016_31_10_2016
  • 97.55 KB
  • 5952 rows
  • 19 columns
Loading...

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
);

01/10/2017 - 31/10/2017

@ukgov.leeds_city_centre_footfall_data.n_01_10_2017_31_10_2017
  • 15.41 KB
  • 224 rows
  • 14 columns
Loading...

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
);

01/10/2018 - 31/10/2018

@ukgov.leeds_city_centre_footfall_data.n_01_10_2018_31_10_2018
  • 67.23 KB
  • 4464 rows
  • 15 columns
Loading...

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
);

Share link

Anyone who has the link will be able to view this.