Sports Pitches

CREATE TABLE table_1 (
  "name" VARCHAR,
  "availability" VARCHAR,
  "ownership" VARCHAR,
  "sub_area" VARCHAR,
  "changing" DOUBLE  -- Changing?,
  "floodlights" DOUBLE  -- Floodlights?,
  "pitches_other" VARCHAR  -- Pitches (other),
  "built_facility_score" DOUBLE  -- Built Facility Score (%),
  "built_facility_rating" VARCHAR,
  "relevant_comments_from_consultatioin" VARCHAR,
  "other_site_comments" VARCHAR,
  "notes_on_school_use_and_activity_where_known" VARCHAR  -- Notes On School Use And Activity (where Known),
  "community_access_policy_as_relevant" VARCHAR  -- Community Access Policy (as Relevant),
  "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 Male Football 11v11 (12-15),
  "youth_female_football_11v11_12_15" DOUBLE  -- Youth Female Football 11v11 (12-15),
  "youth_male_football_9v9_10_11" DOUBLE  -- Youth Male Football 9v9 (10-11),
  "youth_female_football_9v9_10_11" DOUBLE  -- Youth Female Football 9v9 (10-11),
  "minisoccer_7v7_8_9" DOUBLE  -- Minisoccer 7v7 (8-9),
  "minisoccer_5v5_6_7" DOUBLE  -- Minisoccer 5v5 (6-7),
  "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 Training Session Hours/week (TE),
  "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  -- Total Adult Football Match Equivalent Hours/week (TE),
  "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 Training Session Hours/week (TE),
  "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  -- Total Junior Football Match Equivalent Hours/week (TE),
  "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 Training Session Hours/week (TE),
  "total_minisoccer_teams" DOUBLE,
  "total_minisoccer_matches_played_week" DOUBLE,
  "total_minisoccer_match_hours_week" DOUBLE,
  "total_minisoccer_match_equivalent_hours_week_te" DOUBLE  -- Total Minisoccer Match Equivalent Hours/week (TE),
  "pitches_adult_football" DOUBLE
);