Adult Social Care And Older People Demographics March 2016

CREATE TABLE clients_receiving_long_term_services_on_31_03_16_by_ageband (
  "key_team" VARCHAR,
  "n__18" DOUBLE  -- <18,
  "n_18_24" DOUBLE  -- 18-24,
  "n_25_29" DOUBLE  -- 25-29,
  "n_30_34" DOUBLE  -- 30-34,
  "n_35_39" DOUBLE  -- 35-39,
  "n_40_44" DOUBLE  -- 40-44,
  "n_45_49" DOUBLE  -- 45-49,
  "n_50_54" VARCHAR  -- 50-54,
  "n_55_59" VARCHAR  -- 55-59,
  "n_60_64" DOUBLE  -- 60-64,
  "n_65_69" DOUBLE  -- 65-69,
  "n_70_74" DOUBLE  -- 70-74,
  "n_75_79" VARCHAR  -- 75-79,
  "n_80_84" VARCHAR  -- 80-84,
  "n_85_89" VARCHAR  -- 85-89,
  "n_90_94" DOUBLE  -- 90-94,
  "n_95_99" DOUBLE  -- 95-99,
  "n_100_104" VARCHAR  -- 100-104,
  "n_105" VARCHAR  -- 105+
);

CREATE TABLE clients_receiving_long_term_services_on_31_03_16_by_gender (
  "key_team" VARCHAR,
  "male" DOUBLE,
  "female" DOUBLE,
  "neutral" VARCHAR
);

CREATE TABLE clients_receiving_long_term_services_on_31_03_16_by_pr_2d27009d (
  "key_team" VARCHAR,
  "access_mobility_only" VARCHAR  -- Access & Mobility Only,
  "personal_care" DOUBLE,
  "visual_impairment" VARCHAR,
  "hearing_impairment" VARCHAR,
  "dual_impairment" VARCHAR,
  "memory_cognition" VARCHAR  -- Memory & Cognition,
  "learning_disability" VARCHAR,
  "mental_health" VARCHAR,
  "substance_misuse" VARCHAR,
  "asylum_seeker" VARCHAR,
  "social_isolation_other" DOUBLE,
  "not_recorded" VARCHAR
);

CREATE TABLE clients_receiving_long_term_services_on_31_03_16_by_su_a4a99782 (
  "key_team" VARCHAR,
  "community" DOUBLE,
  "residential" DOUBLE,
  "nursing" DOUBLE
);

CREATE TABLE supported_service_users_2015_16 (
  "key_team" VARCHAR,
  "supported_at_period_end" DOUBLE,
  "supported_in_period" DOUBLE
);