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.57 kB
248 rows
14 columns

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

65.7 kB
4,464 rows
15 columns

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

65.73 kB
4,464 rows
15 columns

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

83.64 kB
5,376 rows
14 columns

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.42 kB
224 rows
14 columns

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

63.28 kB
4,176 rows
15 columns

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.95 kB
248 rows
14 columns

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

67.72 kB
4,464 rows
15 columns

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

60.44 kB
4,464 rows
15 columns

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

87.87 kB
5,952 rows
14 columns

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

82.41 kB
5,760 rows
14 columns

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

37.69 kB
4,320 rows
15 columns

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

89.27 kB
5,952 rows
14 columns

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

67.83 kB
4,464 rows
15 columns

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

39.36 kB
4,464 rows
15 columns

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

89.83 kB
5,759 rows
14 columns

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

88.91 kB
5,952 rows
19 columns

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

91.3 kB
5,952 rows
14 columns

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

83.08 kB
5,952 rows
14 columns

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

68.53 kB
4,464 rows
15 columns

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

53.97 kB
6,720 rows
12 columns

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

91.33 kB
5,760 rows
19 columns

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

99.89 kB
5,952 rows
19 columns

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.78 kB
224 rows
14 columns

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

68.84 kB
4,464 rows
15 columns

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