Baselight
Sign In

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/11/2016 - 30/11/2016

@ukgov.leeds_city_centre_footfall_data.n_01_11_2016_30_11_2016
  • 92.2 kB
  • 6,912 rows
  • 17 columns
Loading... 
CREATE TABLE n_01_11_2016_30_11_2016 (
  "site" VARCHAR,
  "location" VARCHAR,
  "brcyear" DOUBLE,
  "brcmonthname" VARCHAR,
  "brcweek" DOUBLE,
  "dayofweek" VARCHAR,
  "date" VARCHAR,
  "hour" DOUBLE,
  "incount" DOUBLE,
  "outcount" DOUBLE,
  "reportcount" DOUBLE,
  "factoredincount" DOUBLE,
  "factoredoutcount" DOUBLE,
  "factoredreportcount" DOUBLE,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16
);

01/11/2017 - 31/11/2017

@ukgov.leeds_city_centre_footfall_data.n_01_11_2017_31_11_2017
  • 16.3 kB
  • 240 rows
  • 14 columns
Loading... 
CREATE TABLE n_01_11_2017_31_11_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/11/2018 - 30/11/2018

@ukgov.leeds_city_centre_footfall_data.n_01_11_2018_30_11_2018
  • 109.13 kB
  • 10,080 rows
  • 15 columns
Loading... 
CREATE TABLE n_01_11_2018_30_11_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
);

01/12/2016 - 31/12/2016

@ukgov.leeds_city_centre_footfall_data.n_01_12_2016_31_12_2016
  • 99.14 kB
  • 5,952 rows
  • 19 columns
Loading... 
CREATE TABLE n_01_12_2016_31_12_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/12/2018 - 31/12/2018

@ukgov.leeds_city_centre_footfall_data.n_01_12_2018_31_12_2018
  • 87.9 kB
  • 6,768 rows
  • 15 columns
Loading... 
CREATE TABLE n_01_12_2018_31_12_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
);

04/01/2016 - 31/01/2016

@ukgov.leeds_city_centre_footfall_data.n_04_01_2016_31_01_2016
  • 80.13 kB
  • 5,376 rows
  • 19 columns
Loading... 
CREATE TABLE n_04_01_2016_31_01_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
);

04/04/2016 - 01/05/2016

@ukgov.leeds_city_centre_footfall_data.n_04_04_2016_01_05_2016
  • 81.2 kB
  • 5,376 rows
  • 19 columns
Loading... 
CREATE TABLE n_04_04_2016_01_05_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
);

04/05/2015 - 31/05/2015

@ukgov.leeds_city_centre_footfall_data.n_04_05_2015_31_05_2015
  • 81.32 kB
  • 5,376 rows
  • 19 columns
Loading... 
CREATE TABLE n_04_05_2015_31_05_2015 (
  "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
);

05/01/2015 - 01/02/2015

@ukgov.leeds_city_centre_footfall_data.n_05_01_2015_01_02_2015
  • 75.55 kB
  • 5,376 rows
  • 19 columns
Loading... 
CREATE TABLE n_05_01_2015_01_02_2015 (
  "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
);

06/04/2015 - 03/05/2015

@ukgov.leeds_city_centre_footfall_data.n_06_04_2015_03_05_2015
  • 81.49 kB
  • 5,376 rows
  • 19 columns
Loading... 
CREATE TABLE n_06_04_2015_03_05_2015 (
  "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
);

07/07/2014 - 03/08/2014

@ukgov.leeds_city_centre_footfall_data.n_07_07_2014_03_08_2014
  • 43.3 kB
  • 5,376 rows
  • 12 columns
Loading... 
CREATE TABLE n_07_07_2014_03_08_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
);

29/02/2016 - 03/04/2016

@ukgov.leeds_city_centre_footfall_data.n_29_02_2016_03_04_2016
  • 92.68 kB
  • 6,720 rows
  • 19 columns
Loading... 
CREATE TABLE n_29_02_2016_03_04_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
);

30/05/2016 - 03/07/2016

@ukgov.leeds_city_centre_footfall_data.n_30_05_2016_03_07_2016
  • 93.62 kB
  • 6,720 rows
  • 19 columns
Loading... 
CREATE TABLE n_30_05_2016_03_07_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
);

Weekly Data 01.02.21 - 07.02.21

@ukgov.leeds_city_centre_footfall_data.weekly_data_01_02_21_07_02_21
  • 21.93 kB
  • 1,008 rows
  • 15 columns
Loading... 
CREATE TABLE weekly_data_01_02_21_07_02_21 (
  "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
);

Weekly Data 01.03.21 - 07.03.21

@ukgov.leeds_city_centre_footfall_data.weekly_data_01_03_21_07_03_21
  • 31.18 kB
  • 1,344 rows
  • 15 columns
Loading... 
CREATE TABLE weekly_data_01_03_21_07_03_21 (
  "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
);

Weekly Data 03.08.20 -09.08.20

@ukgov.leeds_city_centre_footfall_data.weekly_data_03_08_20_09_08_20
  • 26.28 kB
  • 1,008 rows
  • 15 columns
Loading... 
CREATE TABLE weekly_data_03_08_20_09_08_20 (
  "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
);

Weekly Data 04.01.21 - 10.01.21

@ukgov.leeds_city_centre_footfall_data.weekly_data_04_01_21_10_01_21
  • 22.7 kB
  • 1,008 rows
  • 15 columns
Loading... 
CREATE TABLE weekly_data_04_01_21_10_01_21 (
  "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
);

Weekly Data 05.04.21 - 11.04.21

@ukgov.leeds_city_centre_footfall_data.weekly_data_05_04_21_11_04_21
  • 32.01 kB
  • 1,344 rows
  • 15 columns
Loading... 
CREATE TABLE weekly_data_05_04_21_11_04_21 (
  "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
);

Weekly Data 07.09.20 - 13.09.20

@ukgov.leeds_city_centre_footfall_data.weekly_data_07_09_20_13_09_20
  • 26.34 kB
  • 1,008 rows
  • 15 columns
Loading... 
CREATE TABLE weekly_data_07_09_20_13_09_20 (
  "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
);

Weekly Data 08.02.21 - 14.02.21

@ukgov.leeds_city_centre_footfall_data.weekly_data_08_02_21_14_02_21
  • 22.23 kB
  • 1,008 rows
  • 15 columns
Loading... 
CREATE TABLE weekly_data_08_02_21_14_02_21 (
  "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
);

Weekly Data 08.03.21 - 14.03.21

@ukgov.leeds_city_centre_footfall_data.weekly_data_08_03_21_14_03_21
  • 31.92 kB
  • 1,344 rows
  • 15 columns
Loading... 
CREATE TABLE weekly_data_08_03_21_14_03_21 (
  "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
);

Weekly Data 08.06.20 - 14.06.20

@ukgov.leeds_city_centre_footfall_data.weekly_data_08_06_20_14_06_20
  • 21.96 kB
  • 1,008 rows
  • 15 columns
Loading... 
CREATE TABLE weekly_data_08_06_20_14_06_20 (
  "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
);

Weekly Data 09.11.20 - 15.11.20

@ukgov.leeds_city_centre_footfall_data.weekly_data_09_11_20_15_11_20
  • 23.49 kB
  • 1,008 rows
  • 15 columns
Loading... 
CREATE TABLE weekly_data_09_11_20_15_11_20 (
  "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
);

Weekly Data 10.08.20 - 16.08.20

@ukgov.leeds_city_centre_footfall_data.weekly_data_10_08_20_16_08_20
  • 26.5 kB
  • 1,008 rows
  • 15 columns
Loading... 
CREATE TABLE weekly_data_10_08_20_16_08_20 (
  "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
);

Weekly Data 12.04.21 - 18.04.21

@ukgov.leeds_city_centre_footfall_data.weekly_data_12_04_21_18_04_21
  • 38.13 kB
  • 1,344 rows
  • 15 columns
Loading... 
CREATE TABLE weekly_data_12_04_21_18_04_21 (
  "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.