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

Weekly Data 12.10.20 - 18.10.20

@ukgov.leeds_city_centre_footfall_data.weekly_data_12_10_20_18_10_20

25.12 KB
1008 rows
15 columns


CREATE TABLE weekly_data_12_10_20_18_10_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 13.07.20 - 19.07.20

@ukgov.leeds_city_centre_footfall_data.weekly_data_13_07_20_19_07_20

25.22 KB
1008 rows
15 columns


CREATE TABLE weekly_data_13_07_20_19_07_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 14.12.20 - 20.12.20

@ukgov.leeds_city_centre_footfall_data.weekly_data_14_12_20_20_12_20

25.48 KB
1008 rows
15 columns


CREATE TABLE weekly_data_14_12_20_20_12_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 16.11.20 - 22.11.20

@ukgov.leeds_city_centre_footfall_data.weekly_data_16_11_20_22_11_20

22.64 KB
1008 rows
15 columns


CREATE TABLE weekly_data_16_11_20_22_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 17.08.20 - 23.08.20

@ukgov.leeds_city_centre_footfall_data.weekly_data_17_08_20_23_08_20

25.88 KB
1008 rows
15 columns


CREATE TABLE weekly_data_17_08_20_23_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 18.01.21 - 24.01.21

@ukgov.leeds_city_centre_footfall_data.weekly_data_18_01_21_24_01_21

21.78 KB
1008 rows
15 columns


CREATE TABLE weekly_data_18_01_21_24_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 19.04.21 - 25.04.21

@ukgov.leeds_city_centre_footfall_data.weekly_data_19_04_21_25_04_21

36.97 KB
1344 rows
15 columns


CREATE TABLE weekly_data_19_04_21_25_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 21.09.20 - 27.09.20

@ukgov.leeds_city_centre_footfall_data.weekly_data_21_09_20_27_09_20

36.51 KB
1344 rows
15 columns


CREATE TABLE weekly_data_21_09_20_27_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 22.02.21 - 28.02.21

@ukgov.leeds_city_centre_footfall_data.weekly_data_22_02_21_28_02_21

30.59 KB
1344 rows
15 columns


CREATE TABLE weekly_data_22_02_21_28_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 22.03.21 - 28.03.21

@ukgov.leeds_city_centre_footfall_data.weekly_data_22_03_21_28_03_21

31.31 KB
1344 rows
15 columns


CREATE TABLE weekly_data_22_03_21_28_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 22.06.20 - 28.06.20

@ukgov.leeds_city_centre_footfall_data.weekly_data_22_06_20_28_06_20

24.21 KB
1008 rows
15 columns


CREATE TABLE weekly_data_22_06_20_28_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 23.11.20 - 29.11.20

@ukgov.leeds_city_centre_footfall_data.weekly_data_23_11_20_29_11_20

23.13 KB
1008 rows
15 columns


CREATE TABLE weekly_data_23_11_20_29_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 24.08.20 - 30.08.20

@ukgov.leeds_city_centre_footfall_data.weekly_data_24_08_20_30_08_20

26.06 KB
1008 rows
15 columns


CREATE TABLE weekly_data_24_08_20_30_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 25.01.21 - 31.01.21

@ukgov.leeds_city_centre_footfall_data.weekly_data_25_01_21_31_01_21

21.71 KB
1008 rows
15 columns


CREATE TABLE weekly_data_25_01_21_31_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 26.10.20 - 01.11.20

@ukgov.leeds_city_centre_footfall_data.weekly_data_26_10_20_01_11_20

25.59 KB
1008 rows
15 columns


CREATE TABLE weekly_data_26_10_20_01_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 28.12.20 - 03.01.21

@ukgov.leeds_city_centre_footfall_data.weekly_data_28_12_20_03_01_21

23.34 KB
1008 rows
15 columns


CREATE TABLE weekly_data_28_12_20_03_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 29.03.21 - 04.04.21

@ukgov.leeds_city_centre_footfall_data.weekly_data_29_03_21_04_04_21

31.29 KB
1344 rows
15 columns


CREATE TABLE weekly_data_29_03_21_04_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 29.06.2020 - 05.07.2020

@ukgov.leeds_city_centre_footfall_data.weekly_data_29_06_2020_05_07_2020

24.33 KB
1008 rows
15 columns


CREATE TABLE weekly_data_29_06_2020_05_07_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
);

Weekly Data 30.11.20 - 06.12.20

@ukgov.leeds_city_centre_footfall_data.weekly_data_30_11_20_06_12_20

25 KB
1008 rows
15 columns


CREATE TABLE weekly_data_30_11_20_06_12_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 31.08.20 - 06.09.20

@ukgov.leeds_city_centre_footfall_data.weekly_data_31_08_20_06_09_20

25.78 KB
1008 rows
15 columns


CREATE TABLE weekly_data_31_08_20_06_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
);