Name: Football Pitches
Creator: UK Government
License: http://reference.data.gov.uk/id/open-government-licence

About this Dataset

Football Pitches

Data showing the usage of football pitches in Plymouth by organisation, as recorded in 2016.
Publisher name: Plymouth City Council
Last updated: 2022-07-01T04:04:31Z

Tables

Plymouth Football Pitches - Plymouth 2016

@ukgov.football_pitches.plymouth_football_pitches_plymouth_2016

41.39 kB
390 rows
40 columns

CREATE TABLE plymouth_football_pitches_plymouth_2016 (
  "name" VARCHAR,
  "sub_area" VARCHAR,
  "ground" VARCHAR,
  "club_id" DOUBLE,
  "team_name" VARCHAR,
  "adult_male_11v11_16_45" DOUBLE  -- Adult Male 11v11 (16-45),
  "adult_female_11v11_16_45" DOUBLE  -- Adult Female 11v11 (16-45),
  "youth_male_11v11_12_15" DOUBLE  -- Youth Male 11v11 (12-15),
  "youth_female_11v11_12_15" DOUBLE  -- Youth Female 11v11 (12-15),
  "youth_male_9v9_10_11" DOUBLE  -- Youth Male 9v9 (10-11),
  "youth_female_9v9_10_11" DOUBLE  -- Youth Female 9v9 (10-11),
  "ms_7v7_8_9" DOUBLE  -- MS 7v7 (8-9),
  "ms_5v5_6_7" DOUBLE  -- MS 5v5 (6-7),
  "team_id" DOUBLE,
  "day_plays_on" VARCHAR,
  "adult_male_female_football_sat_am" DOUBLE,
  "adult_male_female_football_sat_pm" DOUBLE,
  "adult_male_female_football_sun_am" DOUBLE,
  "adult_male_female_football_sun_pm" DOUBLE,
  "adult_male_female_football_mw" DOUBLE,
  "youth_male_female_football_11v11_sat_am" DOUBLE,
  "youth_male_female_football_11v11_sat_pm" VARCHAR,
  "youth_male_female_football_11v11_sun_am" VARCHAR,
  "youth_male_female_football_11v11_sun_pm" VARCHAR,
  "youth_male_female_football_11v11_mw" VARCHAR,
  "youth_male_female_football_9v9_sat_am" DOUBLE,
  "youth_male_female_football_9v9_sat_pm" VARCHAR,
  "youth_male_female_football_9v9_sun_am" VARCHAR,
  "youth_male_female_football_9v9_sun_pm" VARCHAR,
  "youth_male_female_football_9v9_mw" VARCHAR,
  "minisoccer_7v7_sat_am" DOUBLE,
  "minisoccer_7v7_sat_pm" VARCHAR,
  "minisoccer_7v7_sun_am" DOUBLE,
  "minisoccer_7v7_sun_pm" VARCHAR,
  "minisoccer_7v7_mw" DOUBLE,
  "minisoccer_5v5_sat_am" DOUBLE,
  "minisoccer_5v5_sat_pm" VARCHAR,
  "minisoccer_5v5_sun_am" DOUBLE,
  "minisoccer_5v5_sun_pm" VARCHAR,
  "minisoccer_5v5_mw" VARCHAR
);