About this Dataset

Stumpd Counters 2019 Devonport And The Hoe

Footfall counters - Devonport park, Autumn 2019. The Hoe, Christmas 2019 This is an evolving dataset being progressed by the Future Parks Accelerator programme: https://www.plymouth.gov.uk/workingcollaboratively1/dataandtech1
Publisher name: Plymouth City Council
Last updated: 2024-09-14T16:30:49Z

Tables

Counters

@ukgov.stumpd_counters_2019_devonport_park.counters

5.35 kB
10 rows
6 columns

CREATE TABLE counters (
  "index" BIGINT,
  "n__park_id" VARCHAR  -- Park ID,
  "n__counter_id" VARCHAR  -- Counter ID,
  "n__location_description" VARCHAR  -- Location Description,
  "n__latitude" DOUBLE  -- Latitude,
  "n__longitude" DOUBLE  -- Longitude
);

Hoecounters

@ukgov.stumpd_counters_2019_devonport_park.hoecounters

5.45 kB
13 rows
6 columns

CREATE TABLE hoecounters (
  "index" BIGINT,
  "n__park_id" VARCHAR  -- Park ID,
  "n__counter_id" VARCHAR  -- Counter ID,
  "n__location_description" VARCHAR  -- Location Description,
  "n__latitude" DOUBLE  -- Latitude,
  "n__longitude" DOUBLE  -- Longitude
);

Hoe-observations

@ukgov.stumpd_counters_2019_devonport_park.hoe_observations

1.88 MB
170,946 rows
5 columns

CREATE TABLE hoe_observations (
  "index" BIGINT,
  "n__counterid" VARCHAR  -- CounterID,
  "n__date" TIMESTAMP  -- Date,
  "n__time" VARCHAR  -- Time,
  "n__triggers" BIGINT  -- Triggers
);

Observations

@ukgov.stumpd_counters_2019_devonport_park.observations

2.78 MB
257,133 rows
5 columns

CREATE TABLE observations (
  "index" BIGINT,
  "n__counterid" VARCHAR  -- CounterID,
  "n__date" TIMESTAMP  -- Date,
  "n__time" VARCHAR  -- Time,
  "n__triggers" BIGINT  -- Triggers
);

Parks

@ukgov.stumpd_counters_2019_devonport_park.parks

4.27 kB
3 rows
5 columns

CREATE TABLE parks (
  "name" VARCHAR,
  "n__id_string" VARCHAR  -- ID String,
  "n__address" VARCHAR  -- Address,
  "n__description" VARCHAR  -- Description,
  "n__more_info" VARCHAR  -- More Info
);