Sports Pitches by UK Government | Sports

About this Dataset

Sports Pitches

Data showing details on the playing and sports pitches in Plymouth.
Publisher name: Plymouth City Council
Last updated: 2022-07-01T04:04:33Z

Tables

Table 1

@ukgov.sports_pitches1.table_1

212.17 KB
98 rows
212 columns


CREATE TABLE table_1 (
  "name" VARCHAR,
  "availability" VARCHAR,
  "ownership" VARCHAR,
  "sub_area" VARCHAR,
  "changing" DOUBLE,
  "floodlights" DOUBLE,
  "pitches_other" VARCHAR,
  "built_facility_score" DOUBLE,
  "built_facility_rating" VARCHAR,
  "relevant_comments_from_consultatioin" VARCHAR,
  "other_site_comments" VARCHAR,
  "notes_on_school_use_and_activity_where_known" VARCHAR,
  "community_access_policy_as_relevant" VARCHAR,
  "confirmed_school_club_links_in_2012_audit" VARCHAR,
  "adult_male_football_teams" DOUBLE,
  "adult_female_football_teams" DOUBLE,
  "youth_male_football_11v11_12_15" DOUBLE,
  "youth_female_football_11v11_12_15" DOUBLE,
  "youth_male_football_9v9_10_11" DOUBLE,
  "youth_female_football_9v9_10_11" DOUBLE,
  "minisoccer_7v7_8_9" DOUBLE,
  "minisoccer_5v5_6_7" DOUBLE,
  "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" DOUBLE,
  "youth_male_female_football_11v11_sun_am" DOUBLE,
  "youth_male_female_football_11v11_sun_pm" DOUBLE,
  "youth_male_female_football_11v11_mw" DOUBLE,
  "youth_male_female_football_9v9_sat_am" DOUBLE,
  "youth_male_female_football_9v9_sat_pm" DOUBLE,
  "youth_male_female_football_9v9_sun_am" DOUBLE,
  "youth_male_female_football_9v9_sun_pm" DOUBLE,
  "youth_male_female_football_9v9_mw" DOUBLE,
  "minisoccer_7v7_sat_am" DOUBLE,
  "minisoccer_7v7_sat_pm" DOUBLE,
  "minisoccer_7v7_sun_am" DOUBLE,
  "minisoccer_7v7_sun_pm" DOUBLE,
  "minisoccer_7v7_mw" DOUBLE,
  "minisoccer_5v5_sat_am" DOUBLE,
  "minisoccer_5v5_sat_pm" DOUBLE,
  "minisoccer_5v5_sun_am" DOUBLE,
  "minisoccer_5v5_sun_pm" DOUBLE,
  "minisoccer_5v5_mw" DOUBLE,
  "net_supply_adult_male_female_football_sat_am" DOUBLE,
  "net_supply_adult_male_female_football_sat_pm" DOUBLE,
  "net_supply_adult_male_female_football_sun_am" DOUBLE,
  "net_supply_adult_male_female_football_sun_pm" DOUBLE,
  "net_supply_adult_male_female_football_mw" DOUBLE,
  "net_supply_male_female_youth_football_11v11_sat_am" DOUBLE,
  "net_supply_male_female_youth_football_11v11_sat_pm" DOUBLE,
  "net_supply_male_female_youth_football_11v11_sun_am" DOUBLE,
  "net_supply_male_female_youth_football_11v11_sun_pm" DOUBLE,
  "net_supply_male_female_youth_football_11v11_mw" DOUBLE,
  "net_supply_male_female_youth_football_9v9_sat_am" DOUBLE,
  "net_supply_male_female_youth_football_9v9_sat_pm" DOUBLE,
  "net_supply_male_female_youth_football_9v9_sun_am" DOUBLE,
  "net_supply_male_female_youth_football_9v9_sun_pm" DOUBLE,
  "net_supply_male_female_youth_football_9v9_mw" DOUBLE,
  "net_supply_minisoccer_7v7_sat_am" VARCHAR,
  "net_supply_minisoccer_7v7_sat_pm" VARCHAR,
  "net_supply_minisoccer_7v7_sun_am" VARCHAR,
  "net_supply_minisoccer_7v7_sun_pm" VARCHAR,
  "net_supply_minisoccer_7v7_mw" VARCHAR,
  "net_supply_minisoccer_5v5_sat_am" VARCHAR,
  "net_supply_minisoccer_5v5_sat_pm" VARCHAR,
  "net_supply_minisoccer_5v5_sun_am" VARCHAR,
  "net_supply_minisoccer_5v5_sun_pm" VARCHAR,
  "net_supply_minisoccer_5v5_mw" VARCHAR,
  "adult_football_match_length" DOUBLE,
  "adult_football_training_squad_size" DOUBLE,
  "adult_football_home_away_factor" DOUBLE,
  "total_adult_football_training_squads" DOUBLE,
  "total_adult_football_training_session_hours_week_te" DOUBLE,
  "total_adult_football_teams" DOUBLE,
  "total_adult_football_matches_played_week" DOUBLE,
  "total_adult_football_match_hours_week" DOUBLE,
  "total_adult_football_match_equivalent_hours_week_te" DOUBLE,
  "junior_football_match_length" DOUBLE,
  "junior_football_training_squad_size" DOUBLE,
  "junior_football_home_away_factor" DOUBLE,
  "total_junior_football_training_squads" DOUBLE,
  "total_junior_football_training_session_hours_week_te" DOUBLE,
  "total_junior_football_teams" DOUBLE,
  "total_junior_football_matches_played_week" DOUBLE,
  "total_junior_football_match_hours_week" DOUBLE,
  "total_junior_football_match_equivalent_hours_week_te" DOUBLE,
  "minisoccer_football_match_length" DOUBLE,
  "minisoccer_training_squad_size" DOUBLE,
  "minisoccer_home_away_factor" DOUBLE,
  "total_minisoccer_training_squads" DOUBLE,
  "total_minisoccer_training_session_hours_week_te" DOUBLE,
  "total_minisoccer_teams" DOUBLE,
  "total_minisoccer_matches_played_week" DOUBLE,
  "total_minisoccer_match_hours_week" DOUBLE,
  "total_minisoccer_match_equivalent_hours_week_te" DOUBLE,
  "pitches_adult_football" DOUBLE
);