Task: equi-join-detect (source dataset: Auto-BI)

Your are given a database with related tables used for business intelligence analysis. Your task is to identify all key/foreign-key join relationships between the tables for this database. Recall that a join is a relationship between two tables, that allows rows from one table to be combined with rows from another, based on a set of common join columns.
 
 
No explanation needed. Please return all join relationships in the following JSON format:
{
  "joins": [
    {
      "from_table": "table-1",
      "from_column": "column-1",
      "to_table": "table-2",
      "to_column": "column-3"
    }, 
	...
  ]
}

Tables:

Table: Care_activities
| REPORTING_PERIOD_START   | REPORTING_PERIOD_END    | ORG_CODE   | ORG_NAME                    | ORG_LEVEL            | DIMENSION    | COUNT_OF       |   MEASURE | MEASURE_DESC                             |   MEASURE_VALUE |   MEASURE_VALUE_0_18 |   MEASURE_VALUE_19_64 |   MEASURE_VALUE_65_PLUS |
|:-------------------------|:------------------------|:-----------|:----------------------------|:---------------------|:-------------|:---------------|----------:|:-----------------------------------------|----------------:|---------------------:|----------------------:|------------------------:|
| 2020-10-01 00:00:00.000  | 2020-10-31 00:00:00.000 | Y56        | LONDON COMMISSIONING REGION | NHS England (Region) | ActivityType | CareActivities |         1 | Administering Tests                      |           18205 |                 3990 |                  1970 |                   12245 |
| 2020-10-01 00:00:00.000  | 2020-10-31 00:00:00.000 | Y56        | LONDON COMMISSIONING REGION | NHS England (Region) | ActivityType | CareActivities |         2 | Assessment                               |          195680 |                28045 |                 46145 |                  121495 |
| 2020-10-01 00:00:00.000  | 2020-10-31 00:00:00.000 | Y56        | LONDON COMMISSIONING REGION | NHS England (Region) | ActivityType | CareActivities |         3 | Clinical Intervention                    |          508380 |                58240 |                 93395 |                  356745 |
| 2020-10-01 00:00:00.000  | 2020-10-31 00:00:00.000 | Y56        | LONDON COMMISSIONING REGION | NHS England (Region) | ActivityType | CareActivities |         4 | Counselling, Advice, Support             |          179300 |                74930 |                 34460 |                   69910 |
| 2020-10-01 00:00:00.000  | 2020-10-31 00:00:00.000 | Y56        | LONDON COMMISSIONING REGION | NHS England (Region) | ActivityType | CareActivities |         5 | Patient Specific Health Promotion        |           11800 |                 4175 |                  5835 |                    1790 |
| 2020-10-01 00:00:00.000  | 2020-10-31 00:00:00.000 | Y56        | LONDON COMMISSIONING REGION | NHS England (Region) | ActivityType | CareActivities |         6 | Multidisciplinary Team Review            |            8515 |                 5390 |                   800 |                    2320 |
| 2020-10-01 00:00:00.000  | 2020-10-31 00:00:00.000 | Y56        | LONDON COMMISSIONING REGION | NHS England (Region) | ActivityType | CareActivities |         7 | Supporting Another Clinician             |            1060 |                  180 |                   215 |                     665 |
| 2020-10-01 00:00:00.000  | 2020-10-31 00:00:00.000 | Y56        | LONDON COMMISSIONING REGION | NHS England (Region) | ActivityType | CareActivities |         8 | Health Visitor New Birth Visit           |           78365 |                56620 |                 21745 |                       0 |
| 2020-10-01 00:00:00.000  | 2020-10-31 00:00:00.000 | Y56        | LONDON COMMISSIONING REGION | NHS England (Region) | ActivityType | CareActivities |         9 | Health Visitor Health Review (6-8 weeks) |            6095 |                 3865 |                  2230 |                       0 |
| 2020-10-01 00:00:00.000  | 2020-10-31 00:00:00.000 | Y56        | LONDON COMMISSIONING REGION | NHS England (Region) | ActivityType | CareActivities |        10 | Health Visitor Health Review (1  year)   |           43075 |                42470 |                   595 |                      10 |


Table: Care_by_Provider
| ORG_CODE   | ORG_NAME                              | DIMENSION             | COUNT_OF   | MEASURE_DESC            |   MEASURE_VALUE |   MEASURE_VALUE_0_18 |   MEASURE_VALUE_19_64 |   MEASURE_VALUE_65_PLUS |
|:-----------|:--------------------------------------|:----------------------|:-----------|:------------------------|----------------:|---------------------:|----------------------:|------------------------:|
|            | WILTSHIRE HEALTH & CARE               | PrimaryReferralReason | Referrals  | Accident/Trauma         |               5 |                    0 |                     0 |                       5 |
|            | WILTSHIRE HEALTH & CARE               | PrimaryReferralReason | Referrals  | Cardiac Conditions      |               5 |                    0 |                     0 |                       5 |
|            | WILTSHIRE HEALTH & CARE               | PrimaryReferralReason | Referrals  | Cognitive Problems      |               5 |                    0 |                     0 |                       5 |
|            | WILTSHIRE HEALTH & CARE               | PrimaryReferralReason | Referrals  | Diabetes                |               5 |                    0 |                     0 |                       5 |
|            | WILTSHIRE HEALTH & CARE               | PrimaryReferralReason | Referrals  | Ear Infections/Problems |               5 |                    0 |                     0 |                       5 |
|            | WILTSHIRE HEALTH & CARE               | PrimaryReferralReason | Referrals  | Nutrition and Dietetics |               5 |                    0 |                     0 |                       5 |
|            | WILTSHIRE HEALTH & CARE               | PrimaryReferralReason | Referrals  | Pain/Symptom Control    |               5 |                    0 |                     0 |                       5 |
|            | WILTSHIRE HEALTH & CARE               | PrimaryReferralReason | Referrals  | Parkinson's Disease     |               5 |                    0 |                     0 |                       5 |
|            | WILTSHIRE HEALTH & CARE               | PrimaryReferralReason | Referrals  | Vascular Problems       |               5 |                    0 |                     0 |                       5 |
|            | EAST COAST COMMUNITY HEALTHCARE C.I.C | PrimaryReferralReason | Referrals  | Catheter Problems       |               5 |                    0 |                     0 |                       5 |


Table: Care_Contact
| REPORTING_PERIOD_START   | REPORTING_PERIOD_END    | ORG_CODE   | ORG_NAME                    | ORG_LEVEL            | DIMENSION          | COUNT_OF     | MEASURE   | MEASURE_DESC                                          |   MEASURE_VALUE |   MEASURE_VALUE_0_18 |   MEASURE_VALUE_19_64 |   MEASURE_VALUE_65_PLUS |
|:-------------------------|:------------------------|:-----------|:----------------------------|:---------------------|:-------------------|:-------------|:----------|:------------------------------------------------------|----------------:|---------------------:|----------------------:|------------------------:|
| 2020-10-01 00:00:00.000  | 2020-10-31 00:00:00.000 | Y56        | LONDON COMMISSIONING REGION | NHS England (Region) | AttendCode_Group   | CareContacts | 1         | Attended                                              |          937410 |               222030 |                190880 |                  524500 |
| 2020-10-01 00:00:00.000  | 2020-10-31 00:00:00.000 | Y56        | LONDON COMMISSIONING REGION | NHS England (Region) | AttendCode_Group   | CareContacts | 2         | Patient did not attend or arrived too late to be seen |           29245 |                11920 |                  9755 |                    7570 |
| 2020-10-01 00:00:00.000  | 2020-10-31 00:00:00.000 | Y56        | LONDON COMMISSIONING REGION | NHS England (Region) | AttendCode_Group   | CareContacts | 3         | Patient cancellation                                  |           24970 |                 3345 |                  5375 |                   16255 |
| 2020-10-01 00:00:00.000  | 2020-10-31 00:00:00.000 | Y56        | LONDON COMMISSIONING REGION | NHS England (Region) | AttendCode_Group   | CareContacts | 4         | Health care provider cancellation                     |           53590 |                 5385 |                 11225 |                   36980 |
| 2020-10-01 00:00:00.000  | 2020-10-31 00:00:00.000 | Y56        | LONDON COMMISSIONING REGION | NHS England (Region) | AttendCode_Group   | CareContacts | MV/OP     | Missing Value / Value Outside Parameters              |          141300 |                32630 |                 35285 |                   73385 |
| 2020-10-01 00:00:00.000  | 2020-10-31 00:00:00.000 | Y56        | LONDON COMMISSIONING REGION | NHS England (Region) | ConsultType        | CareContacts | 1         | Initial Consultation                                  |          139105 |                37230 |                 37070 |                   64805 |
| 2020-10-01 00:00:00.000  | 2020-10-31 00:00:00.000 | Y56        | LONDON COMMISSIONING REGION | NHS England (Region) | ConsultType        | CareContacts | 2         | Follow-up Consultation                                |          976860 |               224230 |                195165 |                  557465 |
| 2020-10-01 00:00:00.000  | 2020-10-31 00:00:00.000 | Y56        | LONDON COMMISSIONING REGION | NHS England (Region) | ConsultType        | CareContacts | MV/OP     | Missing Value / Value Outside Parameters              |           70550 |                13850 |                 20285 |                   36415 |
| 2020-10-01 00:00:00.000  | 2020-10-31 00:00:00.000 | Y56        | LONDON COMMISSIONING REGION | NHS England (Region) | ConsultationMedium | CareContacts | 1         | Face to face communication                            |          643735 |               112035 |                119545 |                  412155 |
| 2020-10-01 00:00:00.000  | 2020-10-31 00:00:00.000 | Y56        | LONDON COMMISSIONING REGION | NHS England (Region) | ConsultationMedium | CareContacts | 2         | Telephone                                             |          170615 |                66445 |                 44440 |                   59730 |


Table: Care_Patient_Gender
| REPORTING_PERIOD_START   | REPORTING_PERIOD_END    | ORG_CODE   | ORG_NAME                        | ORG_LEVEL            | DIMENSION   | COUNT_OF               | MEASURE   | MEASURE_DESC                                                     | MEASURE_2   | MEASURE_2_DESC   |   MEASURE_VALUE |   MEASURE_VALUE_0_18 |   MEASURE_VALUE_19_64 |   MEASURE_VALUE_65_PLUS |
|:-------------------------|:------------------------|:-----------|:--------------------------------|:---------------------|:------------|:-----------------------|:----------|:-----------------------------------------------------------------|:------------|:-----------------|----------------:|---------------------:|----------------------:|------------------------:|
| 2020-10-01 00:00:00.000  | 2020-10-31 00:00:00.000 | Y56        | LONDON COMMISSIONING REGION     | NHS England (Region) | Gender      | PatientWithCareContact | 1         | Male                                                             |             |                  |          131920 |                65005 |                 26015 |                   40930 |
| 2020-10-01 00:00:00.000  | 2020-10-31 00:00:00.000 | Y56        | LONDON COMMISSIONING REGION     | NHS England (Region) | Gender      | PatientWithCareContact | 2         | Female                                                           |             |                  |          165595 |                49665 |                 58140 |                   57820 |
| 2020-10-01 00:00:00.000  | 2020-10-31 00:00:00.000 | Y56        | LONDON COMMISSIONING REGION     | NHS England (Region) | Gender      | PatientWithCareContact | 9         | Indeterminate (Unable to be classified as either male or female) |             |                  |               5 |                    0 |                     5 |                       0 |
| 2020-10-01 00:00:00.000  | 2020-10-31 00:00:00.000 | Y56        | LONDON COMMISSIONING REGION     | NHS England (Region) | Gender      | PatientWithCareContact | X         | Not Known (PERSON STATED GENDER CODE not recorded)               |             |                  |              15 |                    5 |                    10 |                       5 |
| 2020-10-01 00:00:00.000  | 2020-10-31 00:00:00.000 | Y58        | SOUTH WEST COMMISSIONING REGION | NHS England (Region) | Gender      | PatientWithCareContact | 1         | Male                                                             |             |                  |           54130 |                18740 |                 10565 |                   24840 |
| 2020-10-01 00:00:00.000  | 2020-10-31 00:00:00.000 | Y58        | SOUTH WEST COMMISSIONING REGION | NHS England (Region) | Gender      | PatientWithCareContact | 2         | Female                                                           |             |                  |           66945 |                14910 |                 20665 |                   31385 |
| 2020-10-01 00:00:00.000  | 2020-10-31 00:00:00.000 | Y58        | SOUTH WEST COMMISSIONING REGION | NHS England (Region) | Gender      | PatientWithCareContact | 9         | Indeterminate (Unable to be classified as either male or female) |             |                  |               5 |                    5 |                     5 |                       5 |
| 2020-10-01 00:00:00.000  | 2020-10-31 00:00:00.000 | Y58        | SOUTH WEST COMMISSIONING REGION | NHS England (Region) | Gender      | PatientWithCareContact | MV/OP     | Missing Value / Value Outside Parameters                         |             |                  |               5 |                    0 |                     5 |                       0 |
| 2020-10-01 00:00:00.000  | 2020-10-31 00:00:00.000 | Y58        | SOUTH WEST COMMISSIONING REGION | NHS England (Region) | Gender      | PatientWithCareContact | X         | Not Known (PERSON STATED GENDER CODE not recorded)               |             |                  |               5 |                    5 |                     5 |                       5 |
| 2020-10-01 00:00:00.000  | 2020-10-31 00:00:00.000 | Y59        | SOUTH EAST COMMISSIONING REGION | NHS England (Region) | Gender      | PatientWithCareContact | 1         | Male                                                             |             |                  |           93550 |                43885 |                 15220 |                   34465 |


Table: Counties_and_Unitary_Authorities_December_2019
|   objectid | ctyua19cd   | Local area                   | ctyua19nm                    | ctyua19nmw   |   bng_e |   bng_n |      long |     lat |   st_areashape |   st_lengthshape |
|-----------:|:------------|:-----------------------------|:-----------------------------|:-------------|--------:|--------:|----------:|--------:|---------------:|-----------------:|
|         94 | E09000002   | Barking and Dagenham         | Barking and Dagenham         |              |  547757 |  185111 |  0.129479 | 51.5456 |    3.60996e+07 |          40848.9 |
|         95 | E09000003   | Barnet                       | Barnet                       |              |  523472 |  191753 | -0.21821  | 51.6111 |    8.67483e+07 |          50818.6 |
|         72 | E08000016   | Barnsley                     | Barnsley                     |              |  429979 |  403327 | -1.54925  | 53.5258 |    3.29078e+08 |         126421   |
|         22 | E06000022   | Bath and North East Somerset | Bath and North East Somerset |              |  366217 |  161999 | -2.48654  | 51.356  |    3.51123e+08 |         141685   |
|         52 | E06000055   | Bedford                      | Bedford                      |              |  505721 |  256463 | -0.45463  | 52.1963 |    4.76408e+08 |         131721   |
|         96 | E09000004   | Bexley                       | Bexley                       |              |  549203 |  175435 |  0.146227 | 51.4582 |    6.0569e+07  |          47929.8 |
|         80 | E08000025   | Birmingham                   | Birmingham                   |              |  408150 |  287352 | -1.88141  | 52.484  |    2.67791e+08 |         106261   |
|          8 | E06000008   | Blackburn with Darwen        | Blackburn with Darwen        |              |  369490 |  422806 | -2.4636   | 53.7008 |    1.37022e+08 |          65285   |
|          9 | E06000009   | Blackpool                    | Blackpool                    |              |  332819 |  436635 | -3.02199  | 53.8216 |    3.48709e+07 |          34483.5 |
|         57 | E08000001   | Bolton                       | Bolton                       |              |  368352 |  409873 | -2.47952  | 53.5845 |    1.39792e+08 |          82647.2 |


Table: Ethnicity - SEN data (2)
| School Type                  | Ethnic Group   | Ethnicity                   | Type of support   |   Number of pupils |
|:-----------------------------|:---------------|:----------------------------|:------------------|-------------------:|
| State-funded primary schools | White          | White British               | EHC Plan          |              48060 |
| State-funded primary schools | White          | Irish                       | EHC Plan          |                194 |
| State-funded primary schools | White          | Traveller of Irish heritage | EHC Plan          |                 91 |
| State-funded primary schools | White          | Gypsy / Roma                | EHC Plan          |                318 |
| State-funded primary schools | White          | Any other White background  | EHC Plan          |               4358 |
| State-funded primary schools | Mixed          | White and Black Caribbean   | EHC Plan          |               1328 |
| State-funded primary schools | Mixed          | White and Black African     | EHC Plan          |                734 |
| State-funded primary schools | Mixed          | White and Asian             | EHC Plan          |               1016 |
| State-funded primary schools | Mixed          | Any other mixed background  | EHC Plan          |               1938 |
| State-funded primary schools | Asian          | Indian                      | EHC Plan          |               1886 |


Table: External_Dashboards
| Organisation                 | Resource                                                                      | Notes                                                                                                                                                                         | Link                                                                                                                                                                                                                          |
|:-----------------------------|:------------------------------------------------------------------------------|:------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Department for Education     | Special educational needs: an analysis and summary of data sources – May 2018 | Provides an analysis of a range of national datasets linked to children and young people with SEND. There are also links to other relevant datasets.                          | https://www.gov.uk/government/publications/sen-analysis-and-summary-of-data-sources                                                                                                                                           |
| Department for Education     | Local Authority Interactive Tool (LAIT)                                       | Interactive spreadsheet comparing a range of data across all local authorities in England.                                                                                    | https://www.gov.uk/government/publications/local-authority-interactive-tool-lait                                                                                                                                              |
| Department for Education     | Search for schools and colleges to compare                                    | Data tables on all the schools and colleges in England.                                                                                                                       | https://www.compare-school-performance.service.gov.uk/                                                                                                                                                                        |
| Ofsted/CQC                   | Local area SEND inspection outcome letters                                    | Links to all local area SEND inspection outcome letters from March 2017. Previously they were published on the DfE site.                                                      | https://reports.ofsted.gov.uk/resources/local-authority-school-improvement-arrangements-inspections-and-focused-school-inspections                                                                                            |
| NASEN                        |                                                                               | New schools SEND dashboard – out soon.                                                                                                                                        |                                                                                                                                                                                                                               |
| Local Government Association | LG Inform                                                                     | Brings together a range of performance and finance indicators to enable benchmarking across local authorities.                                                                | https://lginform.local.gov.uk/                                                                                                                                                                                                |
| Local Government Association | LG Inform Plus                                                                | Online suite of tools to promote information sharing, improving quality and efficiency of services.                                                                           | https://www.local.gov.uk/our-support/lg-inform-plus                                                                                                                                                                           |
| Local Government Association | Transforming Care Programme                                                   | Access to a range of information and resources relating to the Transforming Care Programme.                                                                                   | https://www.local.gov.uk/our-support/our-improvement-offer/care-and-health-improvement/transforming-care                                                                                                                      |
| NHS Digital                  | Monthly statistics on learning disability and autism                          | Monthly statistics from the Assuring Transformation and Mental Health Services datasets. Monthly data is presented at a national, Specialist Commissioning Hub and CCG level. | https://digital.nhs.uk/data-and-information/publications/statistical/learning-disability-services-statistics/learning-disability-services-monthly-statistics---provisional-statistics-at-april-2018-mhsds-february-2018-final |
| NHS Digital                  | Mental health services monthly statistics                                     | Monthly data presented at a national, CCG, LA, STP and provider level.                                                                                                        | https://digital.nhs.uk/data-and-information/publications/statistical/mental-health-services-monthly-statistics/final-june-provisional-july-2018                                                                               |


Table: Free School Meals - SEN data
| School Type                    | Type of support   |   Number of Pupils |   Number known to be eligible for and claiming free school meals |
|:-------------------------------|:------------------|-------------------:|-----------------------------------------------------------------:|
| State-funded primary schools   | EHC Plan          |              74404 |                                                            20634 |
| State-funded secondary schools | EHC Plan          |              55233 |                                                            15388 |
| Special schools                | EHC Plan          |             122268 |                                                            46387 |
| State-funded primary schools   | SEN Support       |             595708 |                                                           169740 |
| State-funded secondary schools | SEN Support       |             358555 |                                                            89562 |
| Special schools                | SEN Support       |               2014 |                                                              497 |


Table: Gender - SEN data
| Gender   | School Type                    | Type of support   |   Number of pupils |
|:---------|:-------------------------------|:------------------|-------------------:|
| Male     | State-funded primary schools   | SEN Support       |             395504 |
| Male     | state-funded secondary schools | SEN Support       |             223120 |
| Male     | Special schools                | SEN Support       |               1400 |
| Female   | State-funded primary schools   | SEN Support       |             200204 |
| Female   | state-funded secondary schools | SEN Support       |             135435 |
| Female   | Special schools                | SEN Support       |                614 |
| Male     | State-funded primary schools   | EHC Plan          |              54845 |
| Male     | state-funded secondary schools | EHC Plan          |              40260 |
| Male     | Special schools                | EHC Plan          |              88606 |
| Female   | State-funded primary schools   | EHC Plan          |              19559 |


Table: LAGroupList
| Local Area           |
|:---------------------|
| ENGLAND              |
| Darlington           |
| Durham               |
| Gateshead            |
| Hartlepool           |
| Middlesbrough        |
| Newcastle upon Tyne  |
| North Tyneside       |
| Northumberland       |
| Redcar and Cleveland |


Table: LDHC (14-18yrs)
| REGION_CODE   | REGION_NAME   | STP_CODE   | STP_NAME                                          | CCG_CODE   | CCG_NAME       | PRACTICE_CODE   | PRACTICE_NAME            | MEASURE   |   VALUE | Measure Details                                                                                                                                           |
|:--------------|:--------------|:-----------|:--------------------------------------------------|:-----------|:---------------|:----------------|:-------------------------|:----------|--------:|:----------------------------------------------------------------------------------------------------------------------------------------------------------|
| Y56           | LONDON        | QRV        | NORTH WEST LONDON HEALTH & CARE PARTNERSHIP (STP) | 07W        | NHS Ealing CCG | E85006          | WATERSIDE MEDICAL CENTRE | LDHCMI002 |       0 | Received a learning disability health check by the GP practice and have not received a health check in a previous quarter in this financial year.         |
| Y56           | LONDON        | QRV        | NORTH WEST LONDON HEALTH & CARE PARTNERSHIP (STP) | 07W        | NHS Ealing CCG | E85006          | WATERSIDE MEDICAL CENTRE | LDHCMI004 |       0 | Declined a learning disability health check offered by the GP practice and have not declined a health check in a previous quarter in this financial year. |
| Y56           | LONDON        | QRV        | NORTH WEST LONDON HEALTH & CARE PARTNERSHIP (STP) | 07W        | NHS Ealing CCG | E85006          | WATERSIDE MEDICAL CENTRE | LDHCMI008 |       0 | Identified as having a QOF diagnostic learning disability who received a learning disability health check by the GP practice                              |
| Y56           | LONDON        | QRV        | NORTH WEST LONDON HEALTH & CARE PARTNERSHIP (STP) | 07W        | NHS Ealing CCG | E85006          | WATERSIDE MEDICAL CENTRE | LDHCMI010 |       0 | Received a learning disability health check by the GP practice and have been provided a health action plan                                                |
| Y56           | LONDON        | QRV        | NORTH WEST LONDON HEALTH & CARE PARTNERSHIP (STP) | 07W        | NHS Ealing CCG | E85006          | WATERSIDE MEDICAL CENTRE | LDHCMI012 |       0 | Received a learning disability health check by the GP practice and declined a health action plan                                                          |
| Y56           | LONDON        | QRV        | NORTH WEST LONDON HEALTH & CARE PARTNERSHIP (STP) | 07W        | NHS Ealing CCG | E85006          | WATERSIDE MEDICAL CENTRE | LDHCMI014 |       0 | Received a learning disability health check by the GP practice and who have neither received nor declined a health action plan.                           |
| Y56           | LONDON        | QRV        | NORTH WEST LONDON HEALTH & CARE PARTNERSHIP (STP) | 07W        | NHS Ealing CCG | E85012          | KS MEDICAL CENTRE        | LDHCMI002 |       0 | Received a learning disability health check by the GP practice and have not received a health check in a previous quarter in this financial year.         |
| Y56           | LONDON        | QRV        | NORTH WEST LONDON HEALTH & CARE PARTNERSHIP (STP) | 07W        | NHS Ealing CCG | E85012          | KS MEDICAL CENTRE        | LDHCMI004 |       0 | Declined a learning disability health check offered by the GP practice and have not declined a health check in a previous quarter in this financial year. |
| Y56           | LONDON        | QRV        | NORTH WEST LONDON HEALTH & CARE PARTNERSHIP (STP) | 07W        | NHS Ealing CCG | E85012          | KS MEDICAL CENTRE        | LDHCMI008 |       0 | Identified as having a QOF diagnostic learning disability who received a learning disability health check by the GP practice                              |
| Y56           | LONDON        | QRV        | NORTH WEST LONDON HEALTH & CARE PARTNERSHIP (STP) | 07W        | NHS Ealing CCG | E85012          | KS MEDICAL CENTRE        | LDHCMI010 |       0 | Received a learning disability health check by the GP practice and have been provided a health action plan                                                |


Table: LDS - Gender
| Gender   | Age-Band   |   No. of patients |   % of patients |
|:---------|:-----------|------------------:|----------------:|
| Male     | Under-18   |                60 |              30 |
| Male     | 18-24      |               270 |              68 |
| Male     | 25-34      |               470 |              77 |
| Male     | 35-44      |               310 |              77 |
| Male     | 45-54      |               185 |              78 |
| Male     | 55-64      |               135 |              83 |
| Male     | 65+        |                30 |              72 |
| Female   | Under-18   |               145 |              69 |
| Female   | 18-24      |               125 |              32 |
| Female   | 25-34      |               135 |              23 |


Table: LDS - TCP
| Transforming Care Partnerships                    | Learning disability or autism   |   Number of patients |   % of patients | Column5   |
|:--------------------------------------------------|:--------------------------------|---------------------:|----------------:|:----------|
| Arden                                             | Learning disability only        |                   20 |            0.36 |           |
| Bath, Swindon and Wiltshire                       | Learning disability only        |                    0 |            0    |           |
| Bedford, Luton and Milton Keynes                  | Learning disability only        |                   10 |            0.32 |           |
| Berkshire                                         | Learning disability only        |                   10 |            0.33 |           |
| Birmingham                                        | Learning disability only        |                   30 |            0.53 |           |
| Black Country                                     | Learning disability only        |                   30 |            0.49 |           |
| Bristol, North Somerset and South Gloucestershire | Learning disability only        |                   15 |            0.39 |           |
| Buckinghamshire                                   | Learning disability only        |                    0 |            0    |           |
| Cambridge and Peterborough                        | Learning disability only        |                   15 |            0.53 |           |
| Cheshire and Merseyside                           | Learning disability only        |                   40 |            0.44 |           |


Table: LDS - Ward Security
| Ward Security   | Age-Band   |   Number of Patients |   % of Patients |
|:----------------|:-----------|---------------------:|----------------:|
| General         | Under-18   |                  160 |            0.76 |
| General         | 18-24      |                  200 |            0.5  |
| General         | 25-34      |                  250 |            0.41 |
| General         | 35-44      |                  165 |            0.4  |
| General         | 45-54      |                  120 |            0.52 |
| General         | 55-64      |                   90 |            0.56 |
| General         | 65+        |                   30 |            0.72 |
| PICU            | Under-18   |                   15 |            0.07 |
| PICU            | 18-24      |                   20 |            0.05 |
| PICU            | 25-34      |                   15 |            0.02 |


Table: MHSDS - CCG_Total
| Responsible CCG                                             |   a) Number of CYP with one MH visit before the age of 18 |   b) New referrals with eating disorder issues, aged 0 to 18 |   c) Open referrals not on EIP pathway aged 0 to 17 |   d) Open referrals on EIP pathway in treatment , Aged 0 to 17 |   e) Open referrals on EIP pathway waiting for treatment , Aged 0 to 17 |   f) Open referrals on EIP pathway waiting for treatment more than two weeks , Aged 0 to 17 |   g) Open referrals on EIP pathway waiting for treatment within two weeks , Aged 0 to 17 |   Referrals not on EIP pathway, receiving a first contact and assigned a care co-ordinator with any team aged 0 to 17 |   Referrals not on EIP pathway, Receiving a first contact and assigned a care co-ordinator with any team more than two weeks after referral aged 0 to 17 |   Referrals not on EIP pathway, Receiving a first contact and assigned a care co-ordinator with any team two weeks or less after referral aged 0 to 17 |   k) Referrals on EIP pathway entering treatment , Aged 0 to 17 |   l) Referrals on EIP pathway entering treatment more than two weeks , Aged 0 to 17 |   m) Referrals on EIP pathway entering treatment within two weeks , Aged 0 to 17 |
|:------------------------------------------------------------|----------------------------------------------------------:|-------------------------------------------------------------:|----------------------------------------------------:|---------------------------------------------------------------:|------------------------------------------------------------------------:|--------------------------------------------------------------------------------------------:|-----------------------------------------------------------------------------------------:|----------------------------------------------------------------------------------------------------------------------:|---------------------------------------------------------------------------------------------------------------------------------------------------------:|-------------------------------------------------------------------------------------------------------------------------------------------------------:|----------------------------------------------------------------:|------------------------------------------------------------------------------------:|---------------------------------------------------------------------------------:|
| NHS BARKING AND DAGENHAM CCG                                |                                                       140 |                                                            0 |                                                   0 |                                                              0 |                                                                       0 |                                                                                           0 |                                                                                        0 |                                                                                                                     0 |                                                                                                                                                        0 |                                                                                                                                                      0 |                                                               0 |                                                                                   0 |                                                                                0 |
| NHS BARNSLEY CCG                                            |                                                       100 |                                                           15 |                                                   0 |                                                             10 |                                                                       0 |                                                                                           0 |                                                                                        0 |                                                                                                                     0 |                                                                                                                                                        0 |                                                                                                                                                      0 |                                                               0 |                                                                                   0 |                                                                                0 |
| NHS BASILDON AND BRENTWOOD CCG                              |                                                       105 |                                                           25 |                                                   0 |                                                              0 |                                                                       0 |                                                                                           0 |                                                                                        0 |                                                                                                                     0 |                                                                                                                                                        0 |                                                                                                                                                      0 |                                                               0 |                                                                                   0 |                                                                                0 |
| NHS BASSETLAW CCG                                           |                                                        25 |                                                           10 |                                                   0 |                                                              0 |                                                                       0 |                                                                                           0 |                                                                                        0 |                                                                                                                     0 |                                                                                                                                                        0 |                                                                                                                                                      0 |                                                               0 |                                                                                   0 |                                                                                0 |
| NHS BATH AND NORTH EAST SOMERSET, SWINDON AND WILTSHIRE CCG |                                                       280 |                                                          115 |                                                   0 |                                                              5 |                                                                       0 |                                                                                           0 |                                                                                        0 |                                                                                                                     0 |                                                                                                                                                        0 |                                                                                                                                                      0 |                                                               0 |                                                                                   0 |                                                                                0 |
| NHS BEDFORDSHIRE CCG                                        |                                                       365 |                                                           10 |                                                   0 |                                                              5 |                                                                       0 |                                                                                           0 |                                                                                        0 |                                                                                                                     0 |                                                                                                                                                        0 |                                                                                                                                                      0 |                                                               0 |                                                                                   0 |                                                                                0 |
| NHS BLACKPOOL CCG                                           |                                                       110 |                                                           10 |                                                   0 |                                                              0 |                                                                      10 |                                                                                          10 |                                                                                        0 |                                                                                                                     0 |                                                                                                                                                        0 |                                                                                                                                                      0 |                                                               0 |                                                                                   0 |                                                                                0 |
| NHS BRENT CCG                                               |                                                       130 |                                                           45 |                                                   0 |                                                             10 |                                                                       0 |                                                                                           0 |                                                                                        0 |                                                                                                                     0 |                                                                                                                                                        0 |                                                                                                                                                      0 |                                                               0 |                                                                                   0 |                                                                                0 |
| NHS BRIGHTON AND HOVE CCG                                   |                                                       135 |                                                           70 |                                                   0 |                                                              0 |                                                                       0 |                                                                                           0 |                                                                                        0 |                                                                                                                     0 |                                                                                                                                                        0 |                                                                                                                                                      0 |                                                               0 |                                                                                   0 |                                                                                0 |
| NHS BUCKINGHAMSHIRE CCG                                     |                                                       365 |                                                          115 |                                                   0 |                                                              0 |                                                                       0 |                                                                                           0 |                                                                                        0 |                                                                                                                     0 |                                                                                                                                                        0 |                                                                                                                                                      0 |                                                               0 |                                                                                   0 |                                                                                0 |


Table: MHSDS Measures (2)
| Unique ID   | Measures                                                                                                                                               |   Index |
|:------------|:-------------------------------------------------------------------------------------------------------------------------------------------------------|--------:|
| a           | Number of CYP with one MH visit before the age of 18                                                                                                   |       1 |
| b           | New referrals with eating disorder issues, aged 0 to 18                                                                                                |       2 |
| c           | Open referrals not on EIP pathway aged 0 to 17                                                                                                         |       3 |
| d           | Open referrals on EIP pathway in treatment , Aged 0 to 17                                                                                              |       4 |
| e           | Open referrals on EIP pathway waiting for treatment , Aged 0 to 17                                                                                     |       5 |
| f           | Open referrals on EIP pathway waiting for treatment more than two weeks , Aged 0 to 17                                                                 |       6 |
| g           | Open referrals on EIP pathway waiting for treatment within two weeks , Aged 0 to 17                                                                    |       7 |
| h           | Referrals not on EIP pathway, receiving a first contact and assigned a care co-ordinator with any team aged 0 to 17                                    |       8 |
| i           | Referrals not on EIP pathway, Receiving a first contact and assigned a care co-ordinator with any team more than two weeks after referral aged 0 to 17 |       9 |
| j           | Referrals not on EIP pathway, Receiving a first contact and assigned a care co-ordinator with any team two weeks or less after referral aged 0 to 17   |      10 |


Table: NEET_SEND_16-17yr-olds
| Region     | LA name              |   with SEND (EHCP or statement) |   with SEND % 16-17 year olds recorded as NEET or not known |   with SEN support: Number of 16/17 year olds known to LA |   with SEN support: % 16-17 year olds recorded as NEET or not known |   without SEND (no EHCP or statement, no SEN support): Number of 16/17 year olds known to LA |   without SEND (no EHCP or statement, no SEN support): % 16-17 year olds recorded as NEET or not known |   Total: Number of 16/17 year olds known to LA |   Total: % 16-17 year olds recorded as NEET or not known |
|:-----------|:---------------------|--------------------------------:|------------------------------------------------------------:|----------------------------------------------------------:|--------------------------------------------------------------------:|---------------------------------------------------------------------------------------------:|-------------------------------------------------------------------------------------------------------:|-----------------------------------------------:|---------------------------------------------------------:|
| North East | County Durham        |                             490 |                                                   0.104801  |                                                       860 |                                                           0.0945581 |                                                                                         8890 |                                                                                              0.0407574 |                                          10250 |                                                0.0483735 |
| North East | Darlington           |                              80 |                                                   0.178571  |                                                        30 |                                                           0.111111  |                                                                                         2190 |                                                                                              0.0355894 |                                           2300 |                                                0.0416908 |
| North East | Gateshead            |                             190 |                                                   0.135274  |                                                        10 |                                                           0         |                                                                                         3400 |                                                                                              0.0476937 |                                           3610 |                                                0.0522429 |
| North East | Hartlepool           |                              90 |                                                   0.0943396 |                                                         0 |                                                           0         |                                                                                         2020 |                                                                                              0.0343404 |                                           2110 |                                                0.0368205 |
| North East | Middlesbrough        |                             130 |                                                   0.0687023 |                                                       450 |                                                           0.0652335 |                                                                                         2450 |                                                                                              0.0429331 |                                           3030 |                                                0.047362  |
| North East | Newcastle upon Tyne  |                             150 |                                                   0.140389  |                                                       470 |                                                           0.17      |                                                                                         4330 |                                                                                              0.0816217 |                                           4950 |                                                0.0917777 |
| North East | North Tyneside       |                             150 |                                                   0.0633188 |                                                         0 |                                                           0         |                                                                                         4050 |                                                                                              0.0370462 |                                           4200 |                                                0.0380008 |
| North East | Northumberland       |                             300 |                                                   0.123077  |                                                        80 |                                                           0         |                                                                                         5850 |                                                                                              0.0436738 |                                           6240 |                                                0.0469702 |
| North East | Redcar and Cleveland |                             140 |                                                   0.145585  |                                                       350 |                                                           0.0979087 |                                                                                         2260 |                                                                                              0.043209  |                                           2750 |                                                0.0553805 |
| North East | South Tyneside       |                             150 |                                                   0.187215  |                                                         0 |                                                           0.5       |                                                                                         2900 |                                                                                              0.0674028 |                                           3050 |                                                0.0734296 |


Table: Power BI - 14
| Local Area           | National Area   |   Total Pupils |   Total Pupils with SEN |   Total Pupils with SEN % |   Total Pupils (primary school) |   Pupils with statements or EHC plans (pri) |   Pupils with statements or EHC plans % (pri) |   Pupils with SEN support (pri) |   Pupils with SEN support % (pri) |   Total pupils with SEN (pri) |   Total pupils with SEN % (pri) |   Total Pupils (secondary school) |   Pupils with statements or EHC plans (sec) |   Pupils with statements or EHC plans % (sec) |   Pupils with SEN support (sec) |   Pupils with SEN support % (sec) |   Total pupils with SEN (sec) |   Total pupils with SEN % (sec) |   Total Pupils (Special Schools) |   Pupils with statements or EHC plans (spe) |   Pupils with statements or EHC plans % (spe) |   Pupils with SEN support (spe) |   Pupils with SEN support % (spe) |   Total pupils with SEN (spe) |   Total pupils with SEN %.1 |   Nat pupils with SEN (tot) |   Nat pupils with SEN (pri) |   Nat pupils with SEN (sec) |   Nat pupils with SEN (spe) | Local Area (groups)   |
|:---------------------|:----------------|---------------:|------------------------:|--------------------------:|--------------------------------:|--------------------------------------------:|----------------------------------------------:|--------------------------------:|----------------------------------:|------------------------------:|--------------------------------:|----------------------------------:|--------------------------------------------:|----------------------------------------------:|--------------------------------:|----------------------------------:|------------------------------:|--------------------------------:|---------------------------------:|--------------------------------------------:|----------------------------------------------:|--------------------------------:|----------------------------------:|------------------------------:|----------------------------:|----------------------------:|----------------------------:|----------------------------:|----------------------------:|:----------------------|
| Darlington           | NORTH EAST      |          16140 |                    2546 |                  0.157745 |                            9252 |                                         165 |                                      1.7834   |                            1219 |                           13.1755 |                          1384 |                         14.9589 |                              6577 |                                          80 |                                      1.21636  |                             771 |                          11.7227  |                           851 |                        12.939   |                              311 |                                         311 |                                      100      |                               0 |                          0        |                           311 |                         100 |                    0.144345 |                     13.7918 |                     12.2697 |                     99.8619 | Local Authorities     |
| Durham               | NORTH EAST      |          72407 |                   10743 |                  0.14837  |                           42305 |                                         442 |                                      1.04479  |                            6042 |                           14.282  |                          6484 |                         15.3268 |                             28713 |                                         272 |                                      0.947306 |                            2598 |                           9.04817 |                          2870 |                         9.99547 |                             1389 |                                        1389 |                                      100      |                               0 |                          0        |                          1389 |                         100 |                    0.144345 |                     13.7918 |                     12.2697 |                     99.8619 | Local Authorities     |
| Gateshead            | NORTH EAST      |          28524 |                    4127 |                  0.144685 |                           16214 |                                         209 |                                      1.28901  |                            2189 |                           13.5007 |                          2398 |                         14.7897 |                             11669 |                                         164 |                                      1.40543  |                             924 |                           7.91842 |                          1088 |                         9.32385 |                              641 |                                         638 |                                       99.532  |                               3 |                          0.468019 |                           641 |                         100 |                    0.144345 |                     13.7918 |                     12.2697 |                     99.8619 | Local Authorities     |
| Hartlepool           | NORTH EAST      |          15334 |                    2441 |                  0.159189 |                            9539 |                                          71 |                                      0.744313 |                            1343 |                           14.079  |                          1414 |                         14.8234 |                              5556 |                                          97 |                                      1.74586  |                             691 |                          12.437   |                           788 |                        14.1829  |                              239 |                                         239 |                                      100      |                               0 |                          0        |                           239 |                         100 |                    0.144345 |                     13.7918 |                     12.2697 |                     99.8619 | Local Authorities     |
| Newcastle upon Tyne  | NORTH EAST      |          40259 |                    6410 |                  0.159219 |                           22980 |                                         246 |                                      1.0705   |                            3054 |                           13.2898 |                          3300 |                         14.3603 |                             16409 |                                         149 |                                      0.908038 |                            2091 |                          12.743   |                          2240 |                        13.651   |                              870 |                                         840 |                                       96.5517 |                              30 |                          3.44828  |                           870 |                         100 |                    0.144345 |                     13.7918 |                     12.2697 |                     99.8619 | Local Authorities     |
| Northumberland       | NORTH EAST      |          45370 |                    6506 |                  0.143399 |                           22446 |                                         260 |                                      1.15834  |                            2789 |                           12.4254 |                          3049 |                         13.5837 |                             22000 |                                         333 |                                      1.51364  |                            2200 |                          10       |                          2533 |                        11.5136  |                              924 |                                         914 |                                       98.9177 |                              10 |                          1.08225  |                           924 |                         100 |                    0.144345 |                     13.7918 |                     12.2697 |                     99.8619 | Local Authorities     |
| Redcar and Cleveland | NORTH EAST      |          21963 |                    3616 |                  0.164641 |                           13326 |                                         226 |                                      1.69593  |                            1900 |                           14.2578 |                          2126 |                         15.9538 |                              8257 |                                         237 |                                      2.87029  |                             873 |                          10.5728  |                          1110 |                        13.4431  |                              380 |                                         366 |                                       96.3158 |                              14 |                          3.68421  |                           380 |                         100 |                    0.144345 |                     13.7918 |                     12.2697 |                     99.8619 | Local Authorities     |
| South Tyneside       | NORTH EAST      |          22005 |                    4504 |                  0.204681 |                           12923 |                                         181 |                                      1.4006   |                            2339 |                           18.0995 |                          2520 |                         19.5001 |                              8538 |                                         173 |                                      2.02624  |                            1267 |                          14.8395  |                          1440 |                        16.8658  |                              544 |                                         544 |                                      100      |                               0 |                          0        |                           544 |                         100 |                    0.144345 |                     13.7918 |                     12.2697 |                     99.8619 | Local Authorities     |
| Stockton-on-Tees     | NORTH EAST      |          31734 |                    4832 |                  0.152266 |                           19557 |                                         273 |                                      1.39592  |                            2345 |                           11.9906 |                          2618 |                         13.3865 |                             11604 |                                         185 |                                      1.59428  |                            1456 |                          12.5474  |                          1641 |                        14.1417  |                              573 |                                         568 |                                       99.1274 |                               5 |                          0.8726   |                           573 |                         100 |                    0.144345 |                     13.7918 |                     12.2697 |                     99.8619 | Local Authorities     |
| Sunderland           | NORTH EAST      |          40275 |                    6390 |                  0.158659 |                           23668 |                                         208 |                                      0.878824 |                            3252 |                           13.7401 |                          3460 |                         14.6189 |                             15902 |                                         242 |                                      1.52182  |                            1983 |                          12.4701  |                          2225 |                        13.992   |                              705 |                                         677 |                                       96.0284 |                              28 |                          3.97163  |                           705 |                         100 |                    0.144345 |                     13.7918 |                     12.2697 |                     99.8619 | Local Authorities     |


Table: Power BI - 16, 17, 18
| Local Area           | National Area   |   Specific LD  |   Specific LD % |   Moderate LD |   Moderate LD % |   Severe LD  |   Severe LD % |   Profound LD |   Profound LD % |   Social, Emotional and MH |   Social, Emotional and MH % |   SLC needs |   SLC needs % |   SEN Hearing |   SEN Hearing % |   SEN Visual  |   SEN Visual _1 |   Multi-Sensory |   Multi-Sensory % |   Physical Disability |   Physical Disability % |   Autistic Spectrum  |   Autistic Spectrum % |   Other Difficulty |   Other Difficulty % |   No specialist assessment |   No specialist assessment % |   Total  |   Total % | Column31   | Column32   | Column33   | Local Area (groups)   | SelectedLA   |
|:---------------------|:----------------|---------------:|----------------:|--------------:|----------------:|-------------:|--------------:|--------------:|----------------:|---------------------------:|-----------------------------:|------------:|--------------:|--------------:|----------------:|--------------:|----------------:|----------------:|------------------:|----------------------:|------------------------:|---------------------:|----------------------:|-------------------:|---------------------:|---------------------------:|-----------------------------:|---------:|----------:|:-----------|:-----------|:-----------|:----------------------|:-------------|
| Darlington           | NORTH EAST      |            224 |         22.8397 |           632 |         70.4899 |           25 |       6.67861 |            31 |         9.01594 |                        495 |                      60.5911 |         547 |       48.5588 |            41 |         3.6865  |            28 |         3.08699 |              15 |          1.26483  |                    95 |                11.372   |                  265 |               46.3819 |                 43 |              4.32881 |                        105 |                     11.7049  |     2546 |       300 |            |            |            | LAs                   |              |
| Durham               | NORTH EAST      |           1071 |         26.547  |          2753 |         71.6481 |          322 |      20.7952  |           106 |         5.89709 |                       2060 |                      60.549  |        2271 |       41.9232 |           123 |         2.79033 |            80 |         2.23861 |              50 |          0.965335 |                   271 |                 6.41879 |                 1198 |               50.6699 |                297 |              6.48963 |                        141 |                      3.06793 |    10743 |       300 |            |            |            | LAs                   |              |
| Gateshead            | NORTH EAST      |            443 |         29.4804 |           800 |         54.4406 |           93 |      13.466   |            28 |         3.96117 |                        629 |                      51.0442 |         917 |       49.6378 |            84 |         5.48889 |            49 |         3.4407  |               5 |          0.258717 |                   113 |                 7.06036 |                  462 |               48.6426 |                329 |             23.0193  |                        175 |                     10.0593  |     4127 |       300 |            |            |            | LAs                   |              |
| Hartlepool           | NORTH EAST      |            301 |         33.3949 |           568 |         74.3748 |           67 |      22.4493  |            21 |         7.50822 |                        358 |                      35.5614 |         605 |       57.1742 |            41 |         4.14618 |            21 |         2.10315 |              15 |          1.28555  |                    96 |                10.0796  |                  219 |               39.7902 |                 67 |              7.57923 |                         62 |                      4.55327 |     2441 |       300 |            |            |            | LAs                   |              |
| Middlesbrough        | NORTH EAST      |            443 |         26.5307 |          1297 |         71.3054 |          203 |      30.8583  |            45 |         8.09241 |                        733 |                      57.0373 |         560 |       28.4976 |           128 |         6.90248 |            63 |         3.50338 |               6 |          0.438791 |                   104 |                 5.72107 |                  364 |               45.5371 |                188 |             11.0135  |                         95 |                      4.56199 |     4229 |       300 |            |            |            | LAs                   |              |
| Newcastle upon Tyne  | NORTH EAST      |            755 |         30.3715 |          1503 |         57.6864 |          315 |      34.7149  |            58 |         6.32811 |                       1090 |                      55.3671 |        1431 |       47.7075 |           184 |         9.13447 |            68 |         2.60412 |              12 |          0.505635 |                   139 |                 5.17149 |                  676 |               44.0538 |                 98 |              3.67095 |                         81 |                      2.68398 |     6410 |       300 |            |            |            | LAs                   |              |
| North Tyneside       | NORTH EAST      |            614 |         33.8124 |           551 |         36.8874 |           66 |       8.8275  |            55 |         7.45817 |                       1004 |                      59.99   |        1424 |       77.5424 |            63 |         3.52183 |            35 |         2.24169 |               7 |          0.406818 |                   169 |                14.1452  |                  390 |               38.2904 |                285 |             15.4477  |                         32 |                      1.42845 |     4695 |       300 |            |            |            | LAs                   |              |
| Northumberland       | NORTH EAST      |            521 |         20.9718 |          1250 |         48.9069 |          226 |      23.5738  |            60 |         6.04762 |                       1462 |                      65.7887 |        1531 |       58.8819 |           168 |         6.44168 |            88 |         3.49049 |               5 |          0.170669 |                   188 |                 8.19371 |                  693 |               42.9896 |                210 |             10.8249  |                        104 |                      3.71829 |     6506 |       300 |            |            |            | LAs                   |              |
| Redcar and Cleveland | NORTH EAST      |            552 |         42.6801 |           901 |         55.3477 |          113 |      26.0189  |            49 |        12.2464  |                        687 |                      56.1378 |         650 |       38.3862 |            54 |         3.53021 |            35 |         2.63822 |               9 |          0.466384 |                   132 |                 9.96218 |                  311 |               43.7421 |                 86 |              6.24259 |                         37 |                      2.60143 |     3616 |       300 |            |            |            | LAs                   |              |
| South Tyneside       | NORTH EAST      |            649 |         39.2145 |           772 |         58.7926 |          112 |      18.9478  |            33 |         5.34547 |                        748 |                      47.8741 |         876 |       41.5628 |            84 |         5.44818 |            35 |         2.06874 |              15 |          1.08718  |                   208 |                16.7577  |                  437 |               34.5933 |                248 |             15.1331  |                        287 |                     13.1746  |     4504 |       300 |            |            |            | LAs                   |              |


Table: Power BI - 19
| Local Area           | National Area   |   Total pupils (SEN support, PS) |   Pupils attending SEN units (SEN support, PS) |   % of pupils attending SEN units (Sen support, PS) |   Pupils placed in resourced provision (SEN support, PS) |   % of pupils placed in resourced provision (SEN support, PS) |   Total pupils (SEHC, PS) |   Pupils attending SEN units (SEHC,PS) |   % of pupils attending SEN units (SEHC,PS) |   Pupils placed in resourced provision (SEHC,PS) |   % of pupils placed in resourced provision (SEHC,PS) |   Total pupils (Sen support, SS) |   Pupils attending SEN units (Sen support, SS) |   % of pupils attending SEN units (SEN support, SS) |   Pupils placed in resourced provision (SEN support, SC) |   % of pupils placed in resourced provision (SEN support, SC) |   Total pupils (SEHC, SS) |   Pupils attending SEN units (SEHC, SS) |   % of pupils attending SEN units (SEHC, SS) |   Pupils placed in resourced provision (SEHC, SS) |   % of pupils placed in resourced provision (SEHC, SS) | Column24   | Column27   | Column28   | Column29   | Column30   | Column31   | Column32   |
|:---------------------|:----------------|---------------------------------:|-----------------------------------------------:|----------------------------------------------------:|---------------------------------------------------------:|--------------------------------------------------------------:|--------------------------:|---------------------------------------:|--------------------------------------------:|-------------------------------------------------:|------------------------------------------------------:|---------------------------------:|-----------------------------------------------:|----------------------------------------------------:|---------------------------------------------------------:|--------------------------------------------------------------:|--------------------------:|----------------------------------------:|---------------------------------------------:|--------------------------------------------------:|-------------------------------------------------------:|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|
| England              | England         |                           595708 |                                           2011 |                                           0.337581  |                                                     2770 |                                                      0.464993 |                     74404 |                                   4428 |                                    5.95129  |                                             5629 |                                              7.56545  |                           358555 |                                           5619 |                                            1.56712  |                                                     5213 |                                                      1.45389  |                     55233 |                                    2710 |                                      4.90649 |                                              5328 |                                                9.64641 |            |            |            |            |            |            |            |
| Darlington           | NORTH EAST      |                             1219 |                                              0 |                                           0         |                                                       21 |                                                      1.72272  |                       165 |                                      0 |                                    0        |                                               17 |                                             10.303    |                              771 |                                             64 |                                            8.30091  |                                                        9 |                                                      1.16732  |                        80 |                                       4 |                                      5       |                                                 9 |                                               11.25    |            |            |            |            |            |            |            |
| Durham               | NORTH EAST      |                             6042 |                                             11 |                                           0.182059  |                                                       40 |                                                      0.662032 |                       442 |                                      7 |                                    1.58371  |                                               32 |                                              7.23982  |                             2598 |                                             12 |                                            0.461894 |                                                       13 |                                                      0.500385 |                       272 |                                      13 |                                      4.77941 |                                                19 |                                                6.98529 |            |            |            |            |            |            |            |
| Gateshead            | NORTH EAST      |                             2189 |                                              0 |                                           0         |                                                        1 |                                                      0.045683 |                       209 |                                     10 |                                    4.78469  |                                                0 |                                              0        |                              924 |                                              0 |                                            0        |                                                       64 |                                                      6.92641  |                       164 |                                       0 |                                      0       |                                                27 |                                               16.4634  |            |            |            |            |            |            |            |
| Hartlepool           | NORTH EAST      |                             1343 |                                              1 |                                           0.0744602 |                                                       31 |                                                      2.30827  |                        71 |                                      0 |                                    0        |                                                9 |                                             12.6761   |                              691 |                                              0 |                                            0        |                                                        2 |                                                      0.289436 |                        97 |                                       0 |                                      0       |                                                34 |                                               35.0515  |            |            |            |            |            |            |            |
| Middlesbrough        | NORTH EAST      |                             1976 |                                             57 |                                           2.88462   |                                                       14 |                                                      0.708502 |                       200 |                                    112 |                                   56        |                                               21 |                                             10.5      |                             1371 |                                             39 |                                            2.84464  |                                                       17 |                                                      1.23997  |                       154 |                                      30 |                                     19.4805  |                                                32 |                                               20.7792  |            |            |            |            |            |            |            |
| Newcastle upon Tyne  | NORTH EAST      |                             3054 |                                             29 |                                           0.949574  |                                                       39 |                                                      1.27701  |                       246 |                                     22 |                                    8.94309  |                                               21 |                                              8.53659  |                             2091 |                                              2 |                                            0.095648 |                                                      110 |                                                      5.26064  |                       149 |                                       0 |                                      0       |                                                33 |                                               22.1477  |            |            |            |            |            |            |            |
| North Tyneside       | NORTH EAST      |                             2308 |                                              1 |                                           0.0433276 |                                                       11 |                                                      0.476603 |                       156 |                                      1 |                                    0.641026 |                                               27 |                                             17.3077   |                             1263 |                                              0 |                                            0        |                                                        9 |                                                      0.712589 |                       240 |                                       0 |                                      0       |                                                69 |                                               28.75    |            |            |            |            |            |            |            |
| Northumberland       | NORTH EAST      |                             2789 |                                              0 |                                           0         |                                                        5 |                                                      0.179276 |                       260 |                                      0 |                                    0        |                                                2 |                                              0.769231 |                             2200 |                                              0 |                                            0        |                                                        0 |                                                      0        |                       333 |                                       0 |                                      0       |                                                 0 |                                                0       |            |            |            |            |            |            |            |
| Redcar and Cleveland | NORTH EAST      |                             1900 |                                             42 |                                           2.21053   |                                                       64 |                                                      3.36842  |                       226 |                                     50 |                                   22.1239   |                                               18 |                                              7.9646   |                              873 |                                             22 |                                            2.52005  |                                                       56 |                                                      6.41466  |                       237 |                                       3 |                                      1.26582 |                                                 4 |                                                1.68776 |            |            |            |            |            |            |            |


Table: Power BI - Absence
| SEN need                                  |   Overall absence |   Authorised absence |   Unauthorised absence |   Number of pupil enrolments who are persistent absentees |   Percentage of pupil enrolments who are persistent absentees |
|:------------------------------------------|------------------:|---------------------:|-----------------------:|----------------------------------------------------------:|--------------------------------------------------------------:|
| Specific Learning Difficulty              |               6   |                  4.3 |                    1.7 |                                                     20740 |                                                          15.8 |
| Moderate Learning Difficulty              |               6.5 |                  4.3 |                    2.2 |                                                     42560 |                                                          18.5 |
| Severe Learning Difficulty                |               7.8 |                  6.6 |                    1.2 |                                                      5965 |                                                          23.1 |
| Profound & Multiple Learning Difficulty   |              14.9 |                 13.7 |                    1.2 |                                                      3735 |                                                          44.6 |
| Social, Emotional and Mental Health (6)   |               9.3 |                  5.9 |                    3.4 |                                                     48110 |                                                          27.6 |
| Speech, Language and Communications Needs |               5.4 |                  3.9 |                    1.5 |                                                     27010 |                                                          13.7 |
| Hearing Impairment                        |               5.9 |                  4.5 |                    1.4 |                                                      2845 |                                                          15.4 |
| Visual Impairment                         |               6.4 |                  4.9 |                    1.5 |                                                      1845 |                                                          17.7 |
| Multi- Sensory Impairment                 |               6.5 |                  5.4 |                    1.1 |                                                       440 |                                                          17.3 |
| Physical Disability                       |               9.1 |                  7.7 |                    1.4 |                                                      8570 |                                                          29.1 |


Table: Power BI - CCG Pop
| Area Codes    | AREA       | Region                                           | CCG                          | STP                     |   All Ages |     0-4 |     5-9 |   10-14 |   15-19 |     0-18 |    EYFS |     KS1 |     KS2 |     KS4 |   16-18 |   Age 19-25 |
|:--------------|:-----------|:-------------------------------------------------|:-----------------------------|:------------------------|-----------:|--------:|--------:|--------:|--------:|---------:|--------:|--------:|--------:|--------:|--------:|------------:|
| E92000001     | ENGLAND    | All                                              | All                          | All                     |   55977178 | 3346727 | 3523866 | 3274119 | 3096575 | 12584854 | 4050118 | 1435384 | 2749270 | 1197701 | 1242441 |     4908163 |
| E40000010     | North West | All                                              | All                          | All                     |    7012947 |  420939 |  438916 |  412623 |  393595 |  1580620 |  508452 |  178771 |  343926 |  151105 |  157037 |      631126 |
| E39000026     | North West | NHS England North West (Cheshire and Merseyside) | All                          | All                     |    2482336 |  140968 |  146734 |  138605 |  135679 |   531980 |  170109 |   60235 |  114778 |   51462 |   54211 |      215998 |
| E38000056     | North West | NHS England North West (Cheshire and Merseyside) | NHS Eastern Cheshire CCG     | Cheshire and Merseyside |     197296 |   10251 |   11227 |   11258 |    9763 |    41045 |   12517 |    4578 |    9022 |    4150 |    4159 |       10449 |
| E38000068     | North West | NHS England North West (Cheshire and Merseyside) | NHS Halton CCG               | Cheshire and Merseyside |     128432 |    7676 |    8488 |    8148 |    7075 |    30090 |    9379 |    3332 |    6833 |    2834 |    2944 |        9859 |
| E38000091     | North West | NHS England North West (Cheshire and Merseyside) | NHS Knowsley CCG             | Cheshire and Merseyside |     149571 |   10076 |    9630 |    8784 |    8344 |    35166 |   11975 |    4002 |    7309 |    3263 |    3413 |       12807 |
| E38000101     | North West | NHS England North West (Cheshire and Merseyside) | NHS Liverpool CCG            | Cheshire and Merseyside |     494814 |   29676 |   27557 |   24011 |   30674 |   100806 |   35284 |   11520 |   20631 |    8975 |   10587 |       72550 |
| E38000151     | North West | NHS England North West (Cheshire and Merseyside) | NHS South Cheshire CCG       | Cheshire and Merseyside |     183494 |   10011 |   10807 |   10762 |    9650 |    39593 |   12093 |    4435 |    8713 |    3937 |    4076 |       13425 |
| E38000161     | North West | NHS England North West (Cheshire and Merseyside) | NHS South Sefton CCG         | Cheshire and Merseyside |     159237 |    9097 |    9380 |    8638 |    8334 |    33941 |   10931 |    3834 |    7311 |    3357 |    3469 |       11822 |
| E38000170     | North West | NHS England North West (Cheshire and Merseyside) | NHS Southport and Formby CCG | Cheshire and Merseyside |     116159 |    5344 |    6267 |    6304 |    5847 |    22817 |    6553 |    2499 |    5178 |    2427 |    2475 |        7094 |


Table: Power BI - CIN
| National Area   | Local Area            |   Number of episodes |   Rate of episodes of need of at any point during 2016-17 per 10,000 children4 |   Number of children |   Rate of children with an episode of need of at any point during 2016-17 per 10,000 children4 |   Episodes of need starting in the year |   Rate of episodes of need starting in 2016-17 per 10,000 children  |   Children starting an episode of need in the year |   Rate of children starting an episode of need in the year per 10,000 children4 |   Episodes of need ending in the year4 |   Rate of episode of need ending in 2016-17 per 10,000 children4 |    Children ending an episode of need in the year4 |   Children ending care episode |   Children in need episodes at 31 March |   CIN as at 31 Mar |   CIN episodes at 31 March |   CIN episodes at 31 March with a disability |   Percentage of children in need episodes at 31 March with a disability recorded |   Percentage : Autism/Asperger Syndrome |   Percentage : Behaviour |   Percentage : Communication |   Percentage : Consciousness |   Percentage : Hand Function |   Percentage : Hearing |   Percentage : Incontinence |   Percentage : Learning |   Percentage : Mobility |   Percentage : Personal Care |   Percentage : Vision |   Percentage : Other Disability |   Number of Children in need episodes at 31 March2 |   N1 - Abuse or neglect |   N2 - Child's disability or illness |   N3 - Parent's disability or illness |   N4 - Family in acute stress |   N5 - Family dysfunction |   N6 - Socially unacceptable behaviour |   N7 - Low income |   N8 - Absent parenting |   N9 - Cases other than children In need |   N0 - Not stated |
|:----------------|:----------------------|---------------------:|-------------------------------------------------------------------------------:|---------------------:|-----------------------------------------------------------------------------------------------:|----------------------------------------:|--------------------------------------------------------------------:|---------------------------------------------------:|--------------------------------------------------------------------------------:|---------------------------------------:|-----------------------------------------------------------------:|---------------------------------------------------:|-------------------------------:|----------------------------------------:|-------------------:|---------------------------:|---------------------------------------------:|---------------------------------------------------------------------------------:|----------------------------------------:|-------------------------:|-----------------------------:|-----------------------------:|-----------------------------:|-----------------------:|----------------------------:|------------------------:|------------------------:|-----------------------------:|----------------------:|--------------------------------:|---------------------------------------------------:|------------------------:|-------------------------------------:|--------------------------------------:|------------------------------:|--------------------------:|---------------------------------------:|------------------:|------------------------:|-----------------------------------------:|------------------:|
| North East      | Gateshead             |                 2342 |                                                                          591.3 |                 2291 |                                                                                          578.5 |                                     840 |                                                               212.1 |                                                826 |                                                                           208.6 |                                    837 |                                                            211.3 |                                                832 |                          210.1 |                                    1505 |              380   |                       1505 |                                          278 |                                                                             18.5 |                                    36   |                     14   |                         32   |                          5.8 |                            0 |                    7.6 |                         7.6 |                    43.2 |                    17.3 |                          8.6 |                  12.9 |                            60.4 |                                               1505 |                     408 |                                  166 |                                    21 |                           131 |                       726 |                                     24 |                 0 |                      24 |                                        0 |                 0 |
| North East      | Middlesbrough         |                 3559 |                                                                         1094.6 |                 3346 |                                                                                         1029.1 |                                    1692 |                                                               520.4 |                                               1629 |                                                                           501   |                                   1390 |                                                            427.5 |                                               1337 |                          411.2 |                                    2169 |              667.1 |                       2169 |                                          266 |                                                                             12.3 |                                    38.7 |                      6.4 |                          8.3 |                          0   |                            0 |                    4.5 |                         0   |                    49.6 |                    19.9 |                          3.8 |                   4.9 |                             5.6 |                                               2169 |                    1259 |                                  236 |                                     0 |                           125 |                       487 |                                     22 |                 0 |                      14 |                                       16 |                 0 |
| North East      | North Tyneside        |                 2039 |                                                                          493   |                 1962 |                                                                                          474.4 |                                     916 |                                                               221.5 |                                                878 |                                                                           212.3 |                                    693 |                                                            167.6 |                                                679 |                          164.2 |                                    1346 |              325.4 |                       1346 |                                          165 |                                                                             12.3 |                                     9.1 |                      3.6 |                          0   |                          0   |                            0 |                    6.7 |                         0   |                    82.4 |                     0   |                          0   |                  11.5 |                             0   |                                               1346 |                     763 |                                  141 |                                     0 |                           157 |                       229 |                                     10 |                 0 |                      27 |                                        8 |                 0 |
| North East      | Northumberland        |                 4803 |                                                                          813.9 |                 4476 |                                                                                          758.5 |                                    2362 |                                                               400.3 |                                               2246 |                                                                           380.6 |                                   2443 |                                                            414   |                                               2364 |                          400.6 |                                    2360 |              399.9 |                       2360 |                                          429 |                                                                             18.2 |                                    42   |                      6.3 |                          5.4 |                          0   |                            0 |                    2.8 |                         1.6 |                    55.5 |                    13.8 |                          0   |                   6.3 |                            15.2 |                                               2360 |                     699 |                                  241 |                                    12 |                           461 |                       887 |                                     20 |                10 |                      30 |                                        0 |                 0 |
| North East      | Redcar and Cleveland  |                 2338 |                                                                          846.3 |                 2232 |                                                                                          807.9 |                                    1122 |                                                               406.1 |                                               1084 |                                                                           392.4 |                                   1053 |                                                            381.2 |                                               1015 |                          367.4 |                                    1285 |              465.1 |                       1285 |                                          184 |                                                                             14.3 |                                    41.8 |                      0   |                          8.7 |                         13.6 |                            0 |                    5.4 |                         0   |                    45.7 |                    15.2 |                          0   |                  11.4 |                            39.1 |                                               1285 |                     627 |                                  121 |                                     0 |                           159 |                       313 |                                      0 |                 0 |                      23 |                                       33 |                 0 |
| North West      | Blackburn with Darwen |                 3536 |                                                                          918.9 |                 3293 |                                                                                          855.7 |                                    1954 |                                                               507.8 |                                               1862 |                                                                           483.9 |                                   1684 |                                                            437.6 |                                               1618 |                          420.5 |                                    1852 |              481.3 |                       1852 |                                          122 |                                                                              6.6 |                                    27   |                     18   |                         18   |                          0   |                            0 |                    0   |                         0   |                    46.7 |                    29.5 |                          5.7 |                   8.2 |                             7.4 |                                               1852 |                    1276 |                                  115 |                                     0 |                           129 |                       287 |                                      0 |                 0 |                      36 |                                        0 |                 0 |
| North West      | Bolton                |                 4382 |                                                                          647.6 |                 4111 |                                                                                          607.5 |                                    2445 |                                                               361.3 |                                               2294 |                                                                           339   |                                   2024 |                                                            299.1 |                                               1932 |                          285.5 |                                    2358 |              348.5 |                       2358 |                                          117 |                                                                              5   |                                    20.5 |                     28.2 |                         25.6 |                          5.1 |                            0 |                    0   |                        10.3 |                    49.6 |                    16.2 |                         15.4 |                   0   |                             8.5 |                                               2358 |                    1802 |                                  133 |                                    25 |                           125 |                       189 |                                      0 |                 0 |                      58 |                                        0 |                 0 |
| North West      | Cheshire East         |                 3626 |                                                                          473.8 |                 3465 |                                                                                          452.8 |                                    1641 |                                                               214.4 |                                               1588 |                                                                           207.5 |                                   1518 |                                                            198.4 |                                               1478 |                          193.1 |                                    2108 |              275.5 |                       2108 |                                          190 |                                                                              9   |                                    36.8 |                     13.2 |                         12.6 |                          0   |                            0 |                    5.3 |                         6.3 |                    30   |                    17.4 |                          6.3 |                  13.2 |                            16.8 |                                               2108 |                    1552 |                                  115 |                                     0 |                           279 |                        94 |                                      0 |                 0 |                      55 |                                        0 |                 0 |
| North West      | Halton                |                 2163 |                                                                          755.8 |                 2018 |                                                                                          705.2 |                                    1031 |                                                               360.3 |                                                990 |                                                                           345.9 |                                   1232 |                                                            430.5 |                                               1191 |                          416.2 |                                     931 |              325.3 |                        931 |                                          125 |                                                                             13.4 |                                    24   |                     27.2 |                         12.8 |                          0   |                            0 |                    0   |                         8   |                    20   |                    12.8 |                          5.6 |                   0   |                            23.2 |                                                931 |                     525 |                                   32 |                                    15 |                            33 |                       291 |                                     20 |                 0 |                       0 |                                        0 |                 0 |
| North West      | Knowsley              |                 2245 |                                                                          670.6 |                 2100 |                                                                                          627.3 |                                    1131 |                                                               337.8 |                                               1069 |                                                                           319.3 |                                   1073 |                                                            320.5 |                                               1014 |                          302.9 |                                    1172 |              350.1 |                       1172 |                                           93 |                                                                              7.9 |                                    47.3 |                      6.5 |                         14   |                          0   |                            0 |                    0   |                         0   |                    41.9 |                    11.8 |                          0   |                   7.5 |                            11.8 |                                               1172 |                     620 |                                   56 |                                    12 |                           126 |                       292 |                                     55 |                 0 |                       0 |                                        0 |                 0 |


Table: Power BI - Excl
| SEN Need                                  |   Number of pupils |   Number Permanent exclusions |   Rate of Permanent exclusions |
|:------------------------------------------|-------------------:|------------------------------:|-------------------------------:|
| Specific learning difficulty              |             147679 |                           255 |                        0.17267 |
| Moderate learning difficulty              |             252431 |                           435 |                        0.17232 |
| Severe learning difficulty                |              32680 |                            14 |                        0.04284 |
| Profound & multiple learning difficulty   |              10969 |                             4 |                        0.03647 |
| Social, emotional and mental health       |             193657 |                          1982 |                        1.02346 |
| Speech, language and communications needs |             247041 |                           218 |                        0.08824 |
| Hearing impairment                        |              21746 |                            18 |                        0.08277 |
| Visual impairment                         |              12290 |                            14 |                        0.11391 |
| Multi- sensory impairment                 |               3020 |                             2 |                        0.06623 |
| Physical disability                       |              34765 |                            16 |                        0.04602 |


Table: Power BI - EYFS
| Lookup     | National Area         |   Year |   Children (All) |   Children (Girls) |   Children (Boys) |   % GLD All |   % GLD Girls |   % GLD Boys |   % GLD Gap | Column11   |
|:-----------|:----------------------|-------:|-----------------:|-------------------:|------------------:|------------:|--------------:|-------------:|------------:|:-----------|
| NORTH WEST | Blackburn with Darwen |   2013 |             2114 |               1029 |              1085 |        39.8 |          46   |         34   |        12   |            |
| NORTH WEST | Blackburn with Darwen |   2014 |             2197 |               1081 |              1116 |        46.5 |          54   |         39.2 |        14.8 |            |
| NORTH WEST | Blackburn with Darwen |   2015 |             2076 |               1002 |              1074 |        56   |          64.7 |         48   |        16.7 |            |
| NORTH WEST | Blackburn with Darwen |   2016 |             2226 |               1094 |              1132 |        63   |          70.8 |         55.5 |        15.4 |            |
| NORTH WEST | Blackburn with Darwen |   2017 |             2208 |               1072 |              1136 |        65.6 |          71.8 |         59.8 |        12.1 |            |
| NORTH WEST | Blackpool             |   2013 |             1691 |                839 |               852 |        51.6 |          61.4 |         42   |        19.4 |            |
| NORTH WEST | Blackpool             |   2014 |             1603 |                769 |               834 |        54.5 |          65.3 |         44.5 |        20.8 |            |
| NORTH WEST | Blackpool             |   2015 |             1697 |                848 |               849 |        60.5 |          69.2 |         51.7 |        17.5 |            |
| NORTH WEST | Blackpool             |   2016 |             1645 |                838 |               807 |        64.5 |          71   |         57.7 |        13.3 |            |
| NORTH WEST | Blackpool             |   2017 |             1711 |                845 |               866 |        66.7 |          73.5 |         60   |        13.4 |            |


Table: Power BI - KS1
| National Area                  | Local area   |   English Reading Number of eligible pupils1 All4 |   English Reading Number of eligible pupils2 Boys4 |   English Reading Number of eligible pupils3 Girls4 |   English Reading Percentage reaching the expected standard2 All |   English Reading Percentage reaching the expected standard3 Boys |   English Reading Percentage reaching the expected standard4 Girls |   English Reading Percentage working at greater depth All |   English Reading Percentage working at greater depth Boys |   English Reading Percentage working at greater depth Girls |   English Writing Number of eligible pupils1 All4 |   English Writing Number of eligible pupils2 Boys4 |   English Writing Number of eligible pupils3 Girls4 |   English Writing Percentage reaching the expected standard2 All |   English Writing Percentage reaching the expected standard3 Boys |   English Writing Percentage reaching the expected standard4 Girls |   English Writing Percentage working at greater depth All |   English Writing Percentage working at greater depth Boys |   English Writing Percentage working at greater depth Girls |   Mathematics Number of eligible pupils1 All4 |   Mathematics Number of eligible pupils2 Boys4 |   Mathematics Number of eligible pupils3 Girls4 |   Mathematics Percentage reaching the expected standard2 All |   Mathematics Percentage reaching the expected standard3 Boys |   Mathematics Percentage reaching the expected standard4 Girls |   Mathematics Percentage working at greater depth All |   Mathematics Percentage working at greater depth Boys |   Mathematics Percentage working at greater depth Girls |   Science Number of eligible pupils1 All4 |   Science Number of eligible pupils2 Boys4 |   Science Number of eligible pupils3 Girls4 |   Science Percentage reaching the expected standard2 All |   Science Percentage reaching the expected standard3 Boys |   Science Percentage reaching the expected standard4 Girls | Column36   | Column37   | Column38   | Column39   | Column40   | Column41   | Column42   | Column43   | Column44   | Column45   | Column46   | Column47   |
|:-------------------------------|:-------------|--------------------------------------------------:|---------------------------------------------------:|----------------------------------------------------:|-----------------------------------------------------------------:|------------------------------------------------------------------:|-------------------------------------------------------------------:|----------------------------------------------------------:|-----------------------------------------------------------:|------------------------------------------------------------:|--------------------------------------------------:|---------------------------------------------------:|----------------------------------------------------:|-----------------------------------------------------------------:|------------------------------------------------------------------:|-------------------------------------------------------------------:|----------------------------------------------------------:|-----------------------------------------------------------:|------------------------------------------------------------:|----------------------------------------------:|-----------------------------------------------:|------------------------------------------------:|-------------------------------------------------------------:|--------------------------------------------------------------:|---------------------------------------------------------------:|------------------------------------------------------:|-------------------------------------------------------:|--------------------------------------------------------:|------------------------------------------:|-------------------------------------------:|--------------------------------------------:|---------------------------------------------------------:|----------------------------------------------------------:|-----------------------------------------------------------:|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|
| ENGLAND (state-funded schools) | All          |                                            666393 |                                             341213 |                                              325180 |                                                             0.75 |                                                              0.71 |                                                               0.79 |                                                      0.25 |                                                       0.22 |                                                        0.29 |                                            666393 |                                             341213 |                                              325180 |                                                             0.69 |                                                              0.63 |                                                               0.76 |                                                      0.15 |                                                       0.11 |                                                        0.19 |                                        666392 |                                         341213 |                                          325179 |                                                         0.76 |                                                          0.75 |                                                           0.77 |                                                  0.22 |                                                   0.24 |                                                    0.19 |                                    666394 |                                     341213 |                                      325181 |                                                     0.82 |                                                      0.8  |                                                       0.85 |            |            |            |            |            |            |            |            |            |            |            |            |
| North East                     | All          |                                             30780 |                                              15790 |                                               14980 |                                                             0.76 |                                                              0.72 |                                                               0.8  |                                                      0.26 |                                                       0.22 |                                                        0.29 |                                             30780 |                                              15790 |                                               14980 |                                                             0.71 |                                                              0.65 |                                                               0.78 |                                                      0.17 |                                                       0.13 |                                                        0.21 |                                         30780 |                                          15790 |                                           14980 |                                                         0.77 |                                                          0.75 |                                                           0.78 |                                                  0.23 |                                                   0.24 |                                                    0.21 |                                     30780 |                                      15790 |                                       14980 |                                                     0.82 |                                                      0.8  |                                                       0.85 |            |            |            |            |            |            |            |            |            |            |            |            |
| North West                     | All          |                                             90000 |                                              45970 |                                               44030 |                                                             0.73 |                                                              0.69 |                                                               0.78 |                                                      0.22 |                                                       0.19 |                                                        0.26 |                                             90000 |                                              45970 |                                               44030 |                                                             0.67 |                                                              0.61 |                                                               0.74 |                                                      0.13 |                                                       0.09 |                                                        0.16 |                                         90000 |                                          45970 |                                           44030 |                                                         0.74 |                                                          0.73 |                                                           0.75 |                                                  0.19 |                                                   0.22 |                                                    0.17 |                                     90000 |                                      45970 |                                       44030 |                                                     0.81 |                                                      0.78 |                                                       0.83 |            |            |            |            |            |            |            |            |            |            |            |            |
| Yorkshire and The Humber       | All          |                                             67280 |                                              34280 |                                               33010 |                                                             0.73 |                                                              0.68 |                                                               0.77 |                                                      0.23 |                                                       0.2  |                                                        0.26 |                                             67280 |                                              34280 |                                               33010 |                                                             0.67 |                                                              0.6  |                                                               0.74 |                                                      0.13 |                                                       0.1  |                                                        0.17 |                                         67280 |                                          34280 |                                           33010 |                                                         0.74 |                                                          0.72 |                                                           0.75 |                                                  0.21 |                                                   0.23 |                                                    0.18 |                                     67280 |                                      34280 |                                       33010 |                                                     0.8  |                                                      0.77 |                                                       0.83 |            |            |            |            |            |            |            |            |            |            |            |            |
| East Midlands                  | All          |                                             57350 |                                              29490 |                                               27850 |                                                             0.73 |                                                              0.69 |                                                               0.77 |                                                      0.23 |                                                       0.2  |                                                        0.27 |                                             57350 |                                              29490 |                                               27850 |                                                             0.68 |                                                              0.61 |                                                               0.75 |                                                      0.14 |                                                       0.1  |                                                        0.18 |                                         57350 |                                          29490 |                                           27850 |                                                         0.74 |                                                          0.73 |                                                           0.76 |                                                  0.2  |                                                   0.22 |                                                    0.18 |                                     57350 |                                      29490 |                                       27850 |                                                     0.81 |                                                      0.79 |                                                       0.84 |            |            |            |            |            |            |            |            |            |            |            |            |
| West Midlands                  | All          |                                             74700 |                                              38310 |                                               36390 |                                                             0.74 |                                                              0.7  |                                                               0.79 |                                                      0.24 |                                                       0.2  |                                                        0.27 |                                             74700 |                                              38310 |                                               36390 |                                                             0.68 |                                                              0.62 |                                                               0.75 |                                                      0.14 |                                                       0.1  |                                                        0.18 |                                         74700 |                                          38310 |                                           36390 |                                                         0.75 |                                                          0.73 |                                                           0.77 |                                                  0.21 |                                                   0.22 |                                                    0.19 |                                     74700 |                                      38310 |                                       36390 |                                                     0.81 |                                                      0.78 |                                                       0.84 |            |            |            |            |            |            |            |            |            |            |            |            |
| East of England                | All          |                                             74660 |                                              38090 |                                               36580 |                                                             0.75 |                                                              0.71 |                                                               0.79 |                                                      0.26 |                                                       0.22 |                                                        0.29 |                                             74660 |                                              38090 |                                               36580 |                                                             0.68 |                                                              0.62 |                                                               0.75 |                                                      0.15 |                                                       0.11 |                                                        0.19 |                                         74660 |                                          38090 |                                           36580 |                                                         0.75 |                                                          0.74 |                                                           0.76 |                                                  0.22 |                                                   0.25 |                                                    0.2  |                                     74660 |                                      38090 |                                       36580 |                                                     0.82 |                                                      0.8  |                                                       0.84 |            |            |            |            |            |            |            |            |            |            |            |            |
| London                         | All          |                                            103290 |                                              52760 |                                               50530 |                                                             0.77 |                                                              0.74 |                                                               0.81 |                                                      0.28 |                                                       0.24 |                                                        0.31 |                                            103290 |                                              52760 |                                               50530 |                                                             0.73 |                                                              0.67 |                                                               0.78 |                                                      0.18 |                                                       0.14 |                                                        0.22 |                                        103290 |                                          52760 |                                           50530 |                                                         0.78 |                                                          0.77 |                                                           0.8  |                                                  0.25 |                                                   0.27 |                                                    0.23 |                                    103290 |                                      52760 |                                       50530 |                                                     0.83 |                                                      0.81 |                                                       0.86 |            |            |            |            |            |            |            |            |            |            |            |            |
| Inner London                   | All          |                                             34540 |                                              17530 |                                               17010 |                                                             0.78 |                                                              0.74 |                                                               0.81 |                                                      0.27 |                                                       0.24 |                                                        0.31 |                                             34540 |                                              17530 |                                               17010 |                                                             0.73 |                                                              0.68 |                                                               0.78 |                                                      0.18 |                                                       0.14 |                                                        0.22 |                                         34540 |                                          17530 |                                           17010 |                                                         0.78 |                                                          0.77 |                                                           0.8  |                                                  0.25 |                                                   0.27 |                                                    0.22 |                                     34540 |                                      17530 |                                       17010 |                                                     0.83 |                                                      0.8  |                                                       0.86 |            |            |            |            |            |            |            |            |            |            |            |            |
| Outer London                   | All          |                                             68750 |                                              35230 |                                               33520 |                                                             0.77 |                                                              0.73 |                                                               0.81 |                                                      0.28 |                                                       0.24 |                                                        0.31 |                                             68750 |                                              35230 |                                               33520 |                                                             0.72 |                                                              0.67 |                                                               0.78 |                                                      0.18 |                                                       0.14 |                                                        0.21 |                                         68750 |                                          35230 |                                           33520 |                                                         0.79 |                                                          0.77 |                                                           0.8  |                                                  0.26 |                                                   0.28 |                                                    0.23 |                                     68750 |                                      35230 |                                       33520 |                                                     0.84 |                                                      0.81 |                                                       0.86 |            |            |            |            |            |            |            |            |            |            |            |            |


Table: Power BI - KS2 Att
| National Area                   | Local Area   |   Number of eligible pupils2 Reading All |   Number of eligible pupils3 Reading Boys |   Number of eligible pupils4 Reading Girls |   Number of eligible pupils5 Grammar, punctuation and spelling All |   Number of eligible pupils6 Grammar, punctuation and spelling Boys |   Number of eligible pupils7 Grammar, punctuation and spelling Girls |   Number of eligible pupils8 Mathematics All |   Number of eligible pupils9 Mathematics Boys |   Number of eligible pupils10 Mathematics Girls |   Number of eligible pupils11 Reading All |   Percentage reaching the expected standard3 Reading Boys |   Percentage reaching the expected standard4 Reading Girls |   Percentage reaching the expected standard5 Grammar, punctuation and spelling All |   Percentage reaching the expected standard6 Grammar, punctuation and spelling Boys |   Percentage reaching the expected standard7 Grammar, punctuation and spelling Girls |   Percentage reaching the expected standard8 Mathematics All |   Percentage reaching the expected standard9 Mathematics Boys |   Percentage reaching the expected standard10 Mathematics Girls |   Percentage achieving a high score4 Reading All |   Percentage achieving a high score5 Reading Boys |   Percentage achieving a high score6 Reading Girls |   Percentage achieving a high score7 Grammar, punctuation and spelling All |   Percentage achieving a high score8 Grammar, punctuation and spelling Boys |   Percentage achieving a high score9 Grammar, punctuation and spelling Girls |   Percentage achieving a high score10 Mathematics All |   Percentage achieving a high score11 Mathematics Boys |   Percentage achieving a high score12 Mathematics Girls |   Average scaled score5 Reading All |   Average scaled score6 Reading Boys |   Average scaled score7 Reading Girls |   Average scaled score8 Grammar, punctuation and spelling All |   Average scaled score9 Grammar, punctuation and spelling Boys |   Average scaled score10 Grammar, punctuation and spelling Girls |   Average scaled score11 Mathematics All |   Average scaled score12 Mathematics Boys |   Average scaled score13 Mathematics Girls |
|:--------------------------------|:-------------|-----------------------------------------:|------------------------------------------:|-------------------------------------------:|-------------------------------------------------------------------:|--------------------------------------------------------------------:|---------------------------------------------------------------------:|---------------------------------------------:|----------------------------------------------:|------------------------------------------------:|------------------------------------------:|----------------------------------------------------------:|-----------------------------------------------------------:|-----------------------------------------------------------------------------------:|------------------------------------------------------------------------------------:|-------------------------------------------------------------------------------------:|-------------------------------------------------------------:|--------------------------------------------------------------:|----------------------------------------------------------------:|-------------------------------------------------:|--------------------------------------------------:|---------------------------------------------------:|---------------------------------------------------------------------------:|----------------------------------------------------------------------------:|-----------------------------------------------------------------------------:|------------------------------------------------------:|-------------------------------------------------------:|--------------------------------------------------------:|------------------------------------:|-------------------------------------:|--------------------------------------:|--------------------------------------------------------------:|---------------------------------------------------------------:|-----------------------------------------------------------------:|-----------------------------------------:|------------------------------------------:|-------------------------------------------:|
| ENGLAND (state-funded schools)6 | All          |                                   639986 |                                    326451 |                                     313534 |                                                             639947 |                                                              326431 |                                                               313515 |                                       639941 |                                        326429 |                                          313511 |                                   73.7557 |                                                   69.204  |                                                    78.4952 |                                                                            78.4965 |                                                                             74.1011 |                                                                              83.0732 |                                                      79.0949 |                                                       78.5564 |                                                         79.6559 |                                          27.2318 |                                           22.5103 |                                            32.148  |                                                                    35.9338 |                                                                     30.9526 |                                                                      41.1202 |                                               26.8229 |                                                29.1534 |                                                 24.3966 |                             104.469 |                              103.399 |                               105.559 |                                                       106.376 |                                                        105.327 |                                                          107.446 |                                  105.082 |                                   105.379 |                                    104.778 |
| East Midlands                   | All          |                                    55453 |                                     26994 |                                      28459 |                                                              55424 |                                                               28447 |                                                                26977 |                                        55453 |                                         28459 |                                           26994 |                                   71.4226 |                                                   66.9454 |                                                    76.1428 |                                                                            77.1597 |                                                                             72.7704 |                                                                              81.7882 |                                                      77.9471 |                                                       77.5783 |                                                         78.3359 |                                          24.8733 |                                           20.3029 |                                            29.6918 |                                                                    33.702  |                                                                     28.6463 |                                                                      39.0333 |                                               24.8174 |                                                27.4078 |                                                 22.0864 |                             103.845 |                              102.762 |                               104.964 |                                                       105.905 |                                                        104.812 |                                                          107.036 |                                  104.695 |                                   105.008 |                                    104.372 |
| East of England                 | All          |                                    71719 |                                     34904 |                                      36815 |                                                              71716 |                                                               36814 |                                                                34902 |                                        71677 |                                         36794 |                                           34883 |                                   72.858  |                                                   68.2439 |                                                    77.7246 |                                                                            76.5269 |                                                                             71.8531 |                                                                              81.4567 |                                                      77.6525 |                                                       77.3197 |                                                         78.0036 |                                          26.371  |                                           21.7737 |                                            31.2199 |                                                                    33.0122 |                                                                     28.0736 |                                                                      38.2213 |                                               25.3498 |                                                27.5969 |                                                 22.9797 |                             104.236 |                              103.149 |                               105.357 |                                                       105.752 |                                                        104.69  |                                                          106.849 |                                  104.711 |                                   105.023 |                                    104.387 |
| Inner London                    | All          |                                    33146 |                                     16498 |                                      16648 |                                                              33147 |                                                               16648 |                                                                16499 |                                        33144 |                                         16648 |                                           16496 |                                   77.3246 |                                                   72.5613 |                                                    82.1312 |                                                                            82.7767 |                                                                             78.8383 |                                                                              86.7507 |                                                      82.8928 |                                                       81.4272 |                                                         84.372  |                                          30.785  |                                           25.9431 |                                            35.671  |                                                                    44.3298 |                                                                     39.6504 |                                                                      49.0515 |                                               32.4222 |                                                34.6228 |                                                 30.2013 |                             105.491 |                              104.42  |                               106.542 |                                                       108.097 |                                                        107.207 |                                                          108.971 |                                  106.3   |                                   106.546 |                                    106.057 |
| London                          | All          |                                    98073 |                                     48543 |                                      49530 |                                                              98075 |                                                               49530 |                                                                48545 |                                        98072 |                                         49530 |                                           48542 |                                   77.582  |                                                   73.1234 |                                                    82.1313 |                                                                            83.583  |                                                                             79.8607 |                                                                              87.3808 |                                                      83.4061 |                                                       82.3844 |                                                         84.4485 |                                          31.084  |                                           26.0388 |                                            36.2318 |                                                                    45.405  |                                                                     40.5169 |                                                                      50.3924 |                                               34.1453 |                                                36.3436 |                                                 31.9023 |                             105.473 |                              104.404 |                               106.538 |                                                       108.231 |                                                        107.308 |                                                          109.151 |                                  106.471 |                                   106.761 |                                    106.181 |
| North East                      | All          |                                    30170 |                                     14929 |                                      15241 |                                                              30169 |                                                               15240 |                                                                14929 |                                        30170 |                                         15241 |                                           14929 |                                   74.5244 |                                                   70.0938 |                                                    79.0475 |                                                                            78.7497 |                                                                             74.1076 |                                                                              83.4885 |                                                      80.5303 |                                                       79.7061 |                                                         81.3718 |                                          26.1783 |                                           21.7965 |                                            30.6518 |                                                                    34.5255 |                                                                     29.3438 |                                                                      39.8151 |                                               26.0325 |                                                28.2068 |                                                 23.8127 |                             104.472 |                              103.437 |                               105.507 |                                                       106.209 |                                                        105.107 |                                                          107.313 |                                  105.174 |                                   105.397 |                                    104.95  |
| North West                      | All          |                                    87340 |                                     42660 |                                      44679 |                                                              87339 |                                                               44678 |                                                                42660 |                                        87339 |                                         44679 |                                           42659 |                                   73.1337 |                                                   68.8444 |                                                    77.6278 |                                                                            78.9361 |                                                                             74.9138 |                                                                              83.1505 |                                                      78.8846 |                                                       78.5044 |                                                         79.2846 |                                          25.6011 |                                           20.9696 |                                            30.4524 |                                                                    34.9409 |                                                                     29.9454 |                                                                      40.1735 |                                               25.559  |                                                27.7491 |                                                 23.2659 |                             104.203 |                              103.18  |                               105.255 |                                                       106.307 |                                                        105.289 |                                                          107.353 |                                  104.917 |                                   105.205 |                                    104.621 |
| Outer London                    | All          |                                    64927 |                                     32045 |                                      32882 |                                                              64928 |                                                               32882 |                                                                32046 |                                        64928 |                                         32882 |                                           32046 |                                   77.7134 |                                                   73.4079 |                                                    82.1314 |                                                                            83.9946 |                                                                             80.3783 |                                                                              87.7052 |                                                      83.6681 |                                                       82.869  |                                                         84.4879 |                                          31.2366 |                                           26.0872 |                                            36.5205 |                                                                    45.954  |                                                                     40.9555 |                                                                      51.0828 |                                               35.025  |                                                37.2149 |                                                 32.7779 |                             105.464 |                              104.396 |                               106.536 |                                                       108.299 |                                                        107.359 |                                                          109.242 |                                  106.557 |                                   106.869 |                                    106.244 |
| South East                      | All          |                                   101089 |                                     49466 |                                      51623 |                                                             101085 |                                                               51622 |                                                                49463 |                                       101090 |                                         51624 |                                           49466 |                                   75.4078 |                                                   70.9393 |                                                    80.0712 |                                                                            77.9631 |                                                                             73.5597 |                                                                              82.5587 |                                                      79.0751 |                                                       78.7792 |                                                         79.3838 |                                          29.7896 |                                           24.9172 |                                            34.8745 |                                                                    35.3099 |                                                                     30.6458 |                                                                      40.1775 |                                               27.3073 |                                                30.0829 |                                                 24.4107 |                             104.995 |                              103.932 |                               106.078 |                                                       106.219 |                                                        105.206 |                                                          107.254 |                                  105.116 |                                   105.484 |                                    104.74  |
| South West                      | All          |                                    59299 |                                     29171 |                                      30128 |                                                              59298 |                                                               30126 |                                                                29172 |                                        59298 |                                         30127 |                                           29171 |                                   73.5375 |                                                   69.0886 |                                                    78.1324 |                                                                            76.3145 |                                                                             71.6823 |                                                                              81.0983 |                                                      77.4141 |                                                       77.4056 |                                                         77.4228 |                                          27.7694 |                                           22.899  |                                            32.7997 |                                                                    32.0787 |                                                                     27.0431 |                                                                      37.2789 |                                               24.4308 |                                                26.78   |                                                 22.0047 |                             104.513 |                              103.455 |                               105.581 |                                                       105.627 |                                                        104.539 |                                                          106.727 |                                  104.603 |                                   104.962 |                                    104.24  |


Table: Power BI - KS2 Prog
| National Area                   | Local Area   |   Reading progress score |   Reading Lower confidence interval |   Reading Upper confidence interval |   Writing progress score |   Writing Lower confidence interval |   Writing Upper confidence interval |   Maths progress score |   Mathematics Lower confidence interval |   Mathematics Upper confidence interval |   Min Progress |   Max progress |   Target start |   Target end |
|:--------------------------------|:-------------|-------------------------:|------------------------------------:|------------------------------------:|-------------------------:|------------------------------------:|------------------------------------:|-----------------------:|----------------------------------------:|----------------------------------------:|---------------:|---------------:|---------------:|-------------:|
| ENGLAND (state-funded schools)2 | All          |                0.0288172 |                           0.0133144 |                           0.04432   |                0.029908  |                           0.01565   |                           0.0441661 |              0.0348877 |                               0.0213495 |                               0.0484258 |             -7 |              7 |              0 |            7 |
| East Midlands                   | All          |               -0.346977  |                          -0.399476  |                          -0.294477  |                0.0640161 |                           0.0157039 |                           0.112328  |             -0.137821  |                              -0.183662  |                              -0.0919797 |             -7 |              7 |              0 |            7 |
| East of England                 | All          |               -0.474123  |                          -0.520342  |                          -0.427904  |               -0.492719  |                          -0.535214  |                          -0.450223  |             -0.557935  |                              -0.598296  |                              -0.517574  |             -7 |              7 |              0 |            7 |
| Inner London                    | All          |                1.08619   |                           1.01719   |                           1.1552    |                1.06212   |                           0.99879   |                           1.12546   |              1.2342    |                               1.17392   |                               1.29449   |             -7 |              7 |              0 |            7 |
| London                          | All          |                0.849207  |                           0.809084  |                           0.889329  |                0.765048  |                           0.728154  |                           0.801942  |              1.19709   |                               1.16205   |                               1.23213   |             -7 |              7 |              0 |            7 |
| North East                      | All          |                0.392996  |                           0.322314  |                           0.463678  |                0.7902    |                           0.72517   |                           0.855231  |              0.510866  |                               0.449167  |                               0.572566  |             -7 |              7 |              0 |            7 |
| North West                      | All          |                0.231936  |                           0.19004   |                           0.273832  |                0.150473  |                           0.111945  |                           0.189002  |              0.291874  |                               0.255285  |                               0.328462  |             -7 |              7 |              0 |            7 |
| Outer London                    | All          |                0.728167  |                           0.678851  |                           0.777483  |                0.612449  |                           0.567058  |                           0.65784   |              1.17816   |                               1.1351    |                               1.22122   |             -7 |              7 |              0 |            7 |
| South East                      | All          |               -0.0136916 |                          -0.0526973 |                           0.0253142 |               -0.358579  |                          -0.394444  |                          -0.322714  |             -0.432127  |                              -0.46619   |                              -0.398065  |             -7 |              7 |              0 |            7 |
| South West                      | All          |               -0.145527  |                          -0.196271  |                          -0.0947835 |               -0.290913  |                          -0.337598  |                          -0.244229  |             -0.60084   |                              -0.645162  |                              -0.556518  |             -7 |              7 |              0 |            7 |


Table: Power BI - KS4
| National Area   | Local Area   |   Number of eligible pupils(4) Pupils with no identified SEN All |   Number of eligible pupils(4) Pupils with no identified SEN Boys |   Number of eligible pupils(4) Pupils with no identified SEN Girls |   Number of eligible pupils(4) SEN support All |   Number of eligible pupils(4) SEN support Boys |   Number of eligible pupils(4) SEN support Girls |   Number of eligible pupils(4) SEN with a statement or EHC plan All |   Number of eligible pupils(4) SEN with a statement or EHC plan Boys |   Number of eligible pupils(4) SEN with a statement or EHC plan Girls |   Number of eligible pupils(4) All pupils(9) All |   Number of eligible pupils(4) All pupils(9) Boys |   Number of eligible pupils(4) All pupils(9) Girls |   Average Attainment 8 score per pupil (5) Pupils with no identified SEN All |   Average Attainment 8 score per pupil (5) Pupils with no identified SEN Boys |   Average Attainment 8 score per pupil (5) Pupils with no identified SEN Girls |   Average Attainment 8 score per pupil (5) SEN support All |   Average Attainment 8 score per pupil (5) SEN support Boys |   Average Attainment 8 score per pupil (5) SEN support Girls |   Average Attainment 8 score per pupil (5) SEN with a statement or EHC plan All |   Average Attainment 8 score per pupil (5) SEN with a statement or EHC plan Boys |   Average Attainment 8 score per pupil (5) SEN with a statement or EHC plan Girls |   Average Attainment 8 score per pupil (5) All pupils(9) All |   Average Attainment 8 score per pupil (5) All pupils(9) Boys |   Average Attainment 8 score per pupil (5) All pupils(9) Girls |
|:----------------|:-------------|-----------------------------------------------------------------:|------------------------------------------------------------------:|-------------------------------------------------------------------:|-----------------------------------------------:|------------------------------------------------:|-------------------------------------------------:|--------------------------------------------------------------------:|---------------------------------------------------------------------:|----------------------------------------------------------------------:|-------------------------------------------------:|--------------------------------------------------:|---------------------------------------------------:|-----------------------------------------------------------------------------:|------------------------------------------------------------------------------:|-------------------------------------------------------------------------------:|-----------------------------------------------------------:|------------------------------------------------------------:|-------------------------------------------------------------:|--------------------------------------------------------------------------------:|---------------------------------------------------------------------------------:|----------------------------------------------------------------------------------:|-------------------------------------------------------------:|--------------------------------------------------------------:|---------------------------------------------------------------:|
| England10       | All          |                                                           462016 |                                                            225626 |                                                             236390 |                                          56527 |                                           34213 |                                            22314 |                                                               20371 |                                                                14791 |                                                                  5580 |                                           540006 |                                            275185 |                                             264821 |                                                                         50.1 |                                                                          48.1 |                                                                           52   |                                                       32.6 |                                                        31.5 |                                                         34.3 |                                                                            13.7 |                                                                             14.2 |                                                                              12.2 |                                                         46.8 |                                                          44.2 |                                                           49.6 |
| East Midlands   | All          |                                                            40507 |                                                             19875 |                                                              20632 |                                           4927 |                                            3038 |                                             1889 |                                                                1584 |                                                                 1166 |                                                                   418 |                                            47019 |                                             24079 |                                              22940 |                                                                         48.9 |                                                                          46.7 |                                                                           51   |                                                       31.7 |                                                        30.3 |                                                         33.8 |                                                                            11.8 |                                                                             12.6 |                                                                               9.8 |                                                         45.8 |                                                          43   |                                                           48.8 |
| East of England | All          |                                                            52672 |                                                             25767 |                                                              26905 |                                           6043 |                                            3739 |                                             2304 |                                                                2252 |                                                                 1641 |                                                                   611 |                                            60993 |                                             31157 |                                              29836 |                                                                         50   |                                                                          48.2 |                                                                           51.8 |                                                       33.2 |                                                        32   |                                                         35   |                                                                            14.6 |                                                                             15.5 |                                                                              12.1 |                                                         47   |                                                          44.5 |                                                           49.7 |
| Inner London    | All          |                                                            22129 |                                                             10387 |                                                              11742 |                                           3539 |                                            2095 |                                             1444 |                                                                1171 |                                                                  812 |                                                                   359 |                                            26861 |                                             13307 |                                              13554 |                                                                         52.1 |                                                                          50   |                                                                           53.9 |                                                       36.7 |                                                        35.6 |                                                         38.4 |                                                                            15.4 |                                                                             15.4 |                                                                              15.3 |                                                         48.4 |                                                          45.6 |                                                           51.2 |
| London          | All          |                                                            67424 |                                                             32441 |                                                              34983 |                                           9007 |                                            5281 |                                             3726 |                                                                3139 |                                                                 2264 |                                                                   875 |                                            79701 |                                             40067 |                                              39634 |                                                                         53.2 |                                                                          51.1 |                                                                           55.1 |                                                       36.1 |                                                        34.5 |                                                         38.3 |                                                                            15.6 |                                                                             16.1 |                                                                              14.6 |                                                         49.7 |                                                          46.9 |                                                           52.6 |
| North East      | All          |                                                            21681 |                                                             10630 |                                                              11051 |                                           2560 |                                            1508 |                                             1052 |                                                                1116 |                                                                  818 |                                                                   298 |                                            25455 |                                             13023 |                                              12432 |                                                                         48.2 |                                                                          46.5 |                                                                           49.7 |                                                       31.6 |                                                        31.2 |                                                         32.1 |                                                                            11.6 |                                                                             11.9 |                                                                              10.8 |                                                         44.7 |                                                          42.4 |                                                           47.2 |
| North West      | All          |                                                            63876 |                                                             31099 |                                                              32777 |                                           7204 |                                            4416 |                                             2788 |                                                                2812 |                                                                 2019 |                                                                   793 |                                            74006 |                                             37583 |                                              36423 |                                                                         48.6 |                                                                          46.5 |                                                                           50.7 |                                                       31.2 |                                                        30.3 |                                                         32.6 |                                                                            12.7 |                                                                             13.1 |                                                                              11.8 |                                                         45.5 |                                                          42.8 |                                                           48.4 |
| Outer London    | All          |                                                            45295 |                                                             22054 |                                                              23241 |                                           5468 |                                            3186 |                                             2282 |                                                                1968 |                                                                 1452 |                                                                   516 |                                            52840 |                                             26760 |                                              26080 |                                                                         53.7 |                                                                          51.6 |                                                                           55.7 |                                                       35.7 |                                                        33.9 |                                                         38.3 |                                                                            15.8 |                                                                             16.4 |                                                                              14   |                                                         50.4 |                                                          47.5 |                                                           53.3 |
| South East      | All          |                                                            73656 |                                                             36165 |                                                              37491 |                                           8823 |                                            5345 |                                             3478 |                                                                3423 |                                                                 2510 |                                                                   913 |                                            85952 |                                             44042 |                                              41910 |                                                                         51.5 |                                                                          49.6 |                                                                           53.3 |                                                       32.8 |                                                        31.9 |                                                         34.2 |                                                                            14.2 |                                                                             14.8 |                                                                              12.4 |                                                         48   |                                                          45.5 |                                                           50.8 |
| South West      | All          |                                                            43735 |                                                             21527 |                                                              22208 |                                           5700 |                                            3445 |                                             2255 |                                                                1902 |                                                                 1407 |                                                                   495 |                                            51455 |                                             26437 |                                              25018 |                                                                         50.2 |                                                                          48.4 |                                                                           51.9 |                                                       31.7 |                                                        30.6 |                                                         33.3 |                                                                            14   |                                                                             14.3 |                                                                              13.3 |                                                         46.7 |                                                          44.2 |                                                           49.4 |


Table: Power BI - LA region lookup
| LA                   | Region     |
|:---------------------|:-----------|
| England              | ENGLAND    |
| Darlington           | NORTH EAST |
| Durham               | NORTH EAST |
| Gateshead            | NORTH EAST |
| Hartlepool           | NORTH EAST |
| Middlesbrough        | NORTH EAST |
| Newcastle upon Tyne  | NORTH EAST |
| North Tyneside       | NORTH EAST |
| Northumberland       | NORTH EAST |
| Redcar and Cleveland | NORTH EAST |


Table: Power BI - MHSDS (2)
| REPORTING_PERIOD        | BREAKDOWN                      | PRIMARY_LEVEL   | Organisation name               | SECONDARY_LEVEL   | SECONDARY_LEVEL_DESCRIPTION   |   In contact with CYP's Mental Health Services |   CYP02 - People in contact with children and young people's mental health services on CPA, end RP |   CYP21 - Open ward stays (children and young people's mental health services), end RP |   CYP23 - Open referrals (children's and young people's mental health services), end RP |   CYP32 - Referrals to children and young people's mental health services, starting in RP |   CYP32a - Referrals to children and young people's mental health services, starting in RP, aged 0-18 |   MH01a - People in contact with mental health services aged 0 to 18, end RP |   MHS07a - People with an open hospital spell, end RP aged 0 to 18 |   MHS21a - Open ward stays, end RP, aged 0-18 |   MHS24a - Under 16 bed days on adult wards, in RP |   MHS24b - Age 16 bed days on adult wards, in RP |   MHS24c - Age 17 bed days on adult wards, in RP |   MHS30d - Attended contacts in RP, aged 0-18 |   MHS30e - Attended contacts in RP, 0-18, by consultation medium |   MHS32a - Referrals starting in RP, aged 0-18 |   MHS32b - Referrals starting in RP, aged 0-18, that were self-referrals |   MHS38a - Referrals active at any point in RP, aged 0-18 |   MHS38b - Referrals active at any point in RP, with indirect activity in RP, aged 0-18 |   MHS39a - People with a referral starting in RP, aged 0-18 |   Looked after child, 0-18 |   CYP with a child protection plan, 0-18 |   MHS42 - Young carers with a referral starting in RP, aged 0-18 |   MHS55a - People attending at least one contact in RP, aged 0-18 |   MHS56a - People with indirect activity in RP, aged 0-18 |   MHS57a - People discharged from a referral in RP, aged 0-18 |   MHS58a - Missed care contacts in RP, aged 0-18, by DNA reason |   MHS61a - First attended contacts for referrals open in RP, aged 0-18 |   MHS61b - First attended contacts for referrals open in RP, aged 0-18, by consultation medium |   MHS68 - Referrals with any SNOMED Codes and valid PERS score from MH Assess Scale Current View completed in RP, aged 0-18 | Column36   | Column37   | Column38   | Column39   | Column40   | Column41   | Column42   | Column43   | Column44   | Column45   |
|:------------------------|:-------------------------------|:----------------|:--------------------------------|:------------------|:------------------------------|-----------------------------------------------:|---------------------------------------------------------------------------------------------------:|---------------------------------------------------------------------------------------:|----------------------------------------------------------------------------------------:|------------------------------------------------------------------------------------------:|------------------------------------------------------------------------------------------------------:|-----------------------------------------------------------------------------:|-------------------------------------------------------------------:|----------------------------------------------:|---------------------------------------------------:|-------------------------------------------------:|-------------------------------------------------:|----------------------------------------------:|-----------------------------------------------------------------:|-----------------------------------------------:|-------------------------------------------------------------------------:|----------------------------------------------------------:|----------------------------------------------------------------------------------------:|------------------------------------------------------------:|---------------------------:|-----------------------------------------:|-----------------------------------------------------------------:|------------------------------------------------------------------:|----------------------------------------------------------:|--------------------------------------------------------------:|----------------------------------------------------------------:|-----------------------------------------------------------------------:|-----------------------------------------------------------------------------------------------:|----------------------------------------------------------------------------------------------------------------------------:|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|:-----------|
| 2019-11-01 00:00:00.000 | CCG - GP Practice or Residence | 00Q             | NHS BLACKBURN WITH DARWEN CCG   | NONE              | NONE                          |                                            190 |                                                                                                  0 |                                                                                      0 |                                                                                     195 |                                                                                        45 |                                                                                                    45 |                                                                          825 |                                                                  0 |                                             0 |                                                  0 |                                                0 |                                                0 |                                          1480 |                                                                0 |                                            185 |                                                                        0 |                                                      1100 |                                                                                      35 |                                                         145 |                          5 |                                        0 |                                                                0 |                                                               510 |                                                        35 |                                                           145 |                                                               0 |                                                                    155 |                                                                                              0 |                                                                                                                           0 |            |            |            |            |            |            |            |            |            |            |
| 2019-11-01 00:00:00.000 | CCG - GP Practice or Residence | 01E             | NHS GREATER PRESTON CCG         | NONE              | NONE                          |                                            240 |                                                                                                  0 |                                                                                      0 |                                                                                     285 |                                                                                        25 |                                                                                                    25 |                                                                         1230 |                                                                  0 |                                             0 |                                                  0 |                                                0 |                                                0 |                                          1210 |                                                                0 |                                            195 |                                                                        0 |                                                      2265 |                                                                                      95 |                                                         180 |                          5 |                                        0 |                                                                0 |                                                               475 |                                                        95 |                                                           205 |                                                               0 |                                                                    260 |                                                                                              0 |                                                                                                                           0 |            |            |            |            |            |            |            |            |            |            |
| 2019-11-01 00:00:00.000 | CCG - GP Practice or Residence | 02D             | NHS VALE ROYAL CCG              | NONE              | NONE                          |                                            360 |                                                                                                  0 |                                                                                      0 |                                                                                     385 |                                                                                        50 |                                                                                                    50 |                                                                          635 |                                                                  0 |                                             0 |                                                  0 |                                                0 |                                                0 |                                           495 |                                                                0 |                                            125 |                                                                        0 |                                                       810 |                                                                                       5 |                                                          90 |                          0 |                                        0 |                                                                0 |                                                               225 |                                                         0 |                                                           110 |                                                               0 |                                                                     70 |                                                                                              0 |                                                                                                                           0 |            |            |            |            |            |            |            |            |            |            |
| 2019-11-01 00:00:00.000 | CCG - GP Practice or Residence | 02G             | NHS WEST LANCASHIRE CCG         | NONE              | NONE                          |                                            780 |                                                                                                  0 |                                                                                      0 |                                                                                     860 |                                                                                        75 |                                                                                                    75 |                                                                          880 |                                                                  0 |                                             0 |                                                  0 |                                                0 |                                                0 |                                           830 |                                                                0 |                                            135 |                                                                        0 |                                                      1455 |                                                                                      50 |                                                         125 |                          5 |                                        0 |                                                                0 |                                                               395 |                                                        50 |                                                           100 |                                                               0 |                                                                    230 |                                                                                              0 |                                                                                                                           0 |            |            |            |            |            |            |            |            |            |            |
| 2019-11-01 00:00:00.000 | CCG - GP Practice or Residence | 03H             | NHS NORTH EAST LINCOLNSHIRE CCG | NONE              | NONE                          |                                             35 |                                                                                                  0 |                                                                                      0 |                                                                                      35 |                                                                                         0 |                                                                                                     0 |                                                                          745 |                                                                  0 |                                             0 |                                                  0 |                                                0 |                                                0 |                                          1160 |                                                                0 |                                            160 |                                                                        0 |                                                       935 |                                                                                      40 |                                                         145 |                          0 |                                        0 |                                                                0 |                                                               460 |                                                        40 |                                                           150 |                                                               0 |                                                                    125 |                                                                                              0 |                                                                                                                           0 |            |            |            |            |            |            |            |            |            |            |
| 2019-11-01 00:00:00.000 | CCG - GP Practice or Residence | 05D             | NHS EAST STAFFORDSHIRE CCG      | NONE              | NONE                          |                                            445 |                                                                                                  0 |                                                                                      0 |                                                                                     465 |                                                                                       110 |                                                                                                   110 |                                                                          675 |                                                                  0 |                                             0 |                                                  0 |                                                0 |                                                0 |                                           805 |                                                                0 |                                            195 |                                                                        0 |                                                       960 |                                                                                      10 |                                                         175 |                         10 |                                        0 |                                                                0 |                                                               310 |                                                        10 |                                                           135 |                                                               0 |                                                                     90 |                                                                                              0 |                                                                                                                           0 |            |            |            |            |            |            |            |            |            |            |
| 2019-11-01 00:00:00.000 | CCG - GP Practice or Residence | 06A             | NHS WOLVERHAMPTON CCG           | NONE              | NONE                          |                                           1420 |                                                                                                  0 |                                                                                      0 |                                                                                    1810 |                                                                                       310 |                                                                                                   310 |                                                                         2030 |                                                                  0 |                                             0 |                                                  0 |                                                0 |                                                0 |                                          1595 |                                                                0 |                                            450 |                                                                        0 |                                                      2970 |                                                                                      30 |                                                         395 |                          0 |                                        0 |                                                                0 |                                                               815 |                                                        30 |                                                           295 |                                                               0 |                                                                    255 |                                                                                              0 |                                                                                                                           0 |            |            |            |            |            |            |            |            |            |            |
| 2019-11-01 00:00:00.000 | CCG - GP Practice or Residence | 06D             | NHS WYRE FOREST CCG             | NONE              | NONE                          |                                            175 |                                                                                                  0 |                                                                                      0 |                                                                                     180 |                                                                                        25 |                                                                                                    15 |                                                                          745 |                                                                  0 |                                             0 |                                                  0 |                                                0 |                                                0 |                                           470 |                                                                0 |                                            105 |                                                                        0 |                                                       945 |                                                                                      40 |                                                          85 |                          0 |                                        0 |                                                                0 |                                                               245 |                                                        40 |                                                            70 |                                                               0 |                                                                     75 |                                                                                              0 |                                                                                                                           0 |            |            |            |            |            |            |            |            |            |            |
| 2019-11-01 00:00:00.000 | CCG - GP Practice or Residence | 08J             | NHS KINGSTON CCG                | NONE              | NONE                          |                                            470 |                                                                                                  0 |                                                                                      0 |                                                                                     495 |                                                                                       130 |                                                                                                   130 |                                                                          975 |                                                                  0 |                                             0 |                                                  0 |                                                0 |                                                0 |                                          1000 |                                                                0 |                                            275 |                                                                        0 |                                                      1320 |                                                                                      10 |                                                         230 |                          0 |                                        0 |                                                                0 |                                                               440 |                                                         5 |                                                           205 |                                                               0 |                                                                    130 |                                                                                              0 |                                                                                                                           0 |            |            |            |            |            |            |            |            |            |            |
| 2019-11-01 00:00:00.000 | CCG - GP Practice or Residence | 08P             | NHS RICHMOND CCG                | NONE              | NONE                          |                                            615 |                                                                                                  0 |                                                                                      0 |                                                                                     645 |                                                                                       130 |                                                                                                   125 |                                                                         1195 |                                                                  0 |                                             0 |                                                  0 |                                                0 |                                                0 |                                          1140 |                                                                0 |                                            275 |                                                                        0 |                                                      1555 |                                                                                       0 |                                                         230 |                          0 |                                        0 |                                                                0 |                                                               450 |                                                         0 |                                                           195 |                                                               0 |                                                                    110 |                                                                                              0 |                                                                                                                           0 |            |            |            |            |            |            |            |            |            |            |


Table: Power BI - NEET
| National Area      | National Area_1   |   Number known to LA with SEND |   % recorded as participating in education or training with SEND |   Number known to LA without SEND |   % recorded as participating in education or training without SEND |   Number known to LA Total |   % recorded as participating in education or training Total |
|:-------------------|:------------------|-------------------------------:|-----------------------------------------------------------------:|----------------------------------:|--------------------------------------------------------------------:|---------------------------:|-------------------------------------------------------------:|
| ENGLAND            | All               |                          43930 |                                                         0.873697 |                           1116440 |                                                            0.915293 |                    1160370 |                                                     0.913718 |
| SOUTH EAST         | All               |                           7240 |                                                         0.864409 |                            177960 |                                                            0.890145 |                     185200 |                                                     0.88914  |
| LONDON             | All               |                           5870 |                                                         0.919448 |                            166210 |                                                            0.942868 |                     172090 |                                                     0.942069 |
| EAST OF ENGLAND    | All               |                           4950 |                                                         0.872044 |                            125480 |                                                            0.915    |                     130430 |                                                     0.91337  |
| SOUTH WEST         | All               |                           4450 |                                                         0.873119 |                            108730 |                                                            0.91408  |                     113180 |                                                     0.912468 |
| WEST MIDLANDS      | All               |                           5300 |                                                         0.866742 |                            121720 |                                                            0.914392 |                     127020 |                                                     0.912405 |
| EAST MIDLANDS      | All               |                           3520 |                                                         0.889679 |                             97660 |                                                            0.918468 |                     101170 |                                                     0.917467 |
| YORKS & THE HUMBER | All               |                           3760 |                                                         0.881775 |                            112600 |                                                            0.922104 |                     116360 |                                                     0.9208   |
| NORTH WEST         | All               |                           6390 |                                                         0.84419  |                            153120 |                                                            0.908529 |                     159510 |                                                     0.905953 |
| NORTH EAST         | All               |                           2460 |                                                         0.852559 |                             52960 |                                                            0.917729 |                      55420 |                                                     0.914834 |


Table: Power BI - PHB
| CCG Code   | CCG                             |   EHC Plans with a Personal Health Budget |   EHC Plan PHBs delivered as Direct Payment |   EHC Plan PHBs delivered as 3rd party budget |   EHC Plan PHBs delivered as Notional Budget |   Children with LD / Autism and PHB |   LD / Autism PHBs delivered as Direct Payment |   LD / Autism PHBs delivered as 3rd Party Budget |   LD / Autism PHBd delivered as Notional Budget | STP                                             |
|:-----------|:--------------------------------|------------------------------------------:|--------------------------------------------:|----------------------------------------------:|---------------------------------------------:|------------------------------------:|-----------------------------------------------:|-------------------------------------------------:|------------------------------------------------:|:------------------------------------------------|
| 09C        | NHS Ashford CCG                 |                                         0 |                                           0 |                                             0 |                                            0 |                                   1 |                                              1 |                                                0 |                                               0 | Kent and Medway                                 |
| 07L        | NHS Barking and Dagenham CCG    |                                         0 |                                           0 |                                             0 |                                            0 |                                   1 |                                              1 |                                                0 |                                               0 | East London Health and Care Partnership         |
| 07M        | NHS Barnet CCG                  |                                         0 |                                           0 |                                             0 |                                            0 |                                   6 |                                              6 |                                                0 |                                               0 | North London Partners in Health and Care        |
| 02P        | NHS Barnsley CCG                |                                         0 |                                           0 |                                             0 |                                            0 |                                   0 |                                              0 |                                                0 |                                               0 | South Yorkshire and Bassetlaw                   |
| 02Q        | NHS Bassetlaw CCG               |                                         0 |                                           0 |                                             0 |                                            0 |                                   0 |                                              0 |                                                0 |                                               0 | South Yorkshire and Bassetlaw                   |
| 15A        | NHS Berkshire West CCG          |                                         0 |                                           0 |                                             0 |                                            0 |                                   0 |                                              0 |                                                0 |                                               0 | Buckinghamshire, Oxfordshire and Berkshire West |
| 15E        | NHS Birmingham and Solihull CCG |                                         0 |                                           0 |                                             0 |                                            0 |                                   3 |                                              0 |                                                1 |                                               2 | Birmingham and Solihull                         |
| 00Q        | NHS Blackburn With Darwen CCG   |                                         0 |                                           0 |                                             0 |                                            0 |                                   0 |                                              0 |                                                0 |                                               0 | Healthier Lancashire and South Cumbria          |
| 00R        | NHS Blackpool CCG               |                                         0 |                                           0 |                                             0 |                                            0 |                                   0 |                                              0 |                                                0 |                                               0 | Healthier Lancashire and South Cumbria          |
| 09D        | NHS Brighton and Hove CCG       |                                         0 |                                           0 |                                             0 |                                            0 |                                   2 |                                              2 |                                                0 |                                               0 | Sussex and East Surrey                          |


Table: Power BI - Pop (2)
| Code      | Name              | Geographic area type      |   0-4 |   5-9 |   10-14 |   15-19 |   0-18 |   EYFS |   KS1 |   KS2 |   KS4 |   16-18 |   Age 19-25 |   All ages |   KS3 |
|:----------|:------------------|:--------------------------|------:|------:|--------:|--------:|-------:|-------:|------:|------:|------:|--------:|------------:|-----------:|------:|
| E07000026 | Allerdale         | Non-metropolitan District |  3686 |  5323 |    5151 |    4985 |  19207 |   5659 |  2119 |  4336 |  2041 |    2038 |        6559 |      97527 |  3014 |
| E07000027 | Barrow-in-Furness | Non-metropolitan District |  2987 |  3670 |    3735 |    3531 |  13952 |   4443 |  1480 |  2975 |  1371 |    1466 |        5265 |      67137 |  2217 |
| E07000028 | Carlisle          | Non-metropolitan District |  4643 |  6280 |    5935 |    5394 |  22461 |   7065 |  2637 |  4881 |  2125 |    2212 |        8289 |     108387 |  3541 |
| E07000029 | Copeland          | Non-metropolitan District |  2745 |  3736 |    3661 |    3288 |  13589 |   4226 |  1533 |  2956 |  1371 |    1347 |        4768 |      68424 |  2156 |
| E07000030 | Eden              | Non-metropolitan District |  1709 |  2608 |    2762 |    2515 |   9644 |   2744 |   992 |  2151 |  1026 |    1064 |        3058 |      52881 |  1667 |
| E07000031 | South Lakeland    | Non-metropolitan District |  3221 |  4829 |    5362 |    5359 |  18809 |   5043 |  1913 |  4129 |  2260 |    2223 |        6287 |     104532 |  3241 |
| E07000117 | Burnley           | Non-metropolitan District |  4734 |  6028 |    5573 |    4738 |  21438 |   7184 |  2372 |  4793 |  1931 |    1953 |        6804 |      88527 |  3205 |
| E07000118 | Chorley           | Non-metropolitan District |  5056 |  7117 |    6803 |    5714 |  25112 |   7834 |  2934 |  5526 |  2358 |    2395 |        7751 |     116821 |  4065 |
| E07000119 | Fylde             | Non-metropolitan District |  2563 |  4137 |    4222 |    3777 |  14884 |   4091 |  1666 |  3427 |  1575 |    1621 |        4360 |      79770 |  2504 |
| E07000120 | Hyndburn          | Non-metropolitan District |  4204 |  5504 |    5073 |    4601 |  19643 |   6455 |  2173 |  4265 |  1890 |    1893 |        6439 |      80815 |  2967 |


Table: Power BI - S251 (2)
| Geographic comparator for:   |   Neighbour_code | Neighbour_name               |   Individual Schools Budget (before Academy recoupment), including high needs place funding (B) |   Individual Schools Budget (before Academy recoupment), including high needs place funding AVERAGE |   Top up - maintained |   1.2.1 Top-up funding – maintained schools AVERAGE |   Top up - academies/free schools/colleges |   1.2.2 Top-up funding – academies, free schools and colleges AVERAGE |   Top up  / other - NM and independent |   1.2.3 Top-up and other funding – non-maintained and independent providers AVERAGE |   Add HN funding |   1.2.4 Additional high needs targeted funding for mainstream schools and academies AVERAGE |   SEN support service |   1.2.5 SEN support service AVERAGE |   Hosp education services |   1.2.6 Hospital education services AVERAGE |   Other AP services |   1.2.7 Other alternative provision services AVERAGE |   Support for inclusion |   1.2.8 Support for inclusion AVERAGE |   Direct payments (SEND) |   1.2.11 Direct payments (SEN and disability) AVERAGE |   Therapies / other health services |   1.2.13 Therapies and other health related services AVERAGE |   HN TOTAL (E) |   HN TOTAL AVERAGE |   Schools budget |   Schools budget - comparator average |   SEN admin / assess / coordination /monitoring |   Direct payments |   Short breaks (respite) |   Other support | Column34   | Column35   | Column36   | Column37   |
|:-----------------------------|-----------------:|:-----------------------------|------------------------------------------------------------------------------------------------:|----------------------------------------------------------------------------------------------------:|----------------------:|----------------------------------------------------:|-------------------------------------------:|----------------------------------------------------------------------:|---------------------------------------:|------------------------------------------------------------------------------------:|-----------------:|--------------------------------------------------------------------------------------------:|----------------------:|------------------------------------:|--------------------------:|--------------------------------------------:|--------------------:|-----------------------------------------------------:|------------------------:|--------------------------------------:|-------------------------:|------------------------------------------------------:|------------------------------------:|-------------------------------------------------------------:|---------------:|-------------------:|-----------------:|--------------------------------------:|------------------------------------------------:|------------------:|-------------------------:|----------------:|:-----------|:-----------|:-----------|:-----------|
| All LAs                      |              301 | Barking and Dagenham         |                                                                                            5461 |                                                                                             4608.12 |                    82 |                                             124.733 |                                         70 |                                                               70.4333 |                                     86 |                                                                             84.2133 |               28 |                                                                                     4.36667 |                    15 |                             33.9533 |                         0 |                                        4.02 |                  16 |                                                10.78 |                       9 |                               11.8267 |                        0 |                                              0.873333 |                                   0 |                                                      2.04667 |            305 |             348.06 |             6094 |                                5281.3 |                                               5 |                10 |                        6 |               8 |            |            |            |            |
| All LAs                      |              370 | Barnsley                     |                                                                                            4576 |                                                                                             4608.12 |                    29 |                                             124.733 |                                        175 |                                                               70.4333 |                                    101 |                                                                             84.2133 |                0 |                                                                                     4.36667 |                    17 |                             33.9533 |                         2 |                                        4.02 |                   9 |                                                10.78 |                       2 |                               11.8267 |                        0 |                                              0.873333 |                                   0 |                                                      2.04667 |            334 |             348.06 |             5200 |                                5281.3 |                                              16 |                 8 |                       31 |               0 |            |            |            |            |
| All LAs                      |              800 | Bath and North East Somerset |                                                                                            4003 |                                                                                             4608.12 |                    46 |                                             124.733 |                                        129 |                                                               70.4333 |                                    151 |                                                                             84.2133 |               16 |                                                                                     4.36667 |                     8 |                             33.9533 |                         7 |                                        4.02 |                  51 |                                                10.78 |                      28 |                               11.8267 |                        0 |                                              0.873333 |                                   0 |                                                      2.04667 |            438 |             348.06 |             4787 |                                5281.3 |                                              25 |                 3 |                       10 |               3 |            |            |            |            |
| All LAs                      |              822 | Bedford Borough              |                                                                                            4252 |                                                                                             4608.12 |                    64 |                                             124.733 |                                        154 |                                                               70.4333 |                                     35 |                                                                             84.2133 |                0 |                                                                                     4.36667 |                    54 |                             33.9533 |                        15 |                                        4.02 |                  34 |                                                10.78 |                       2 |                               11.8267 |                        0 |                                              0.873333 |                                   0 |                                                      2.04667 |            358 |             348.06 |             5068 |                                5281.3 |                                               7 |                 7 |                       45 |               0 |            |            |            |            |
| All LAs                      |              303 | Bexley                       |                                                                                            4397 |                                                                                             4608.12 |                    67 |                                             124.733 |                                        170 |                                                               70.4333 |                                    110 |                                                                             84.2133 |                0 |                                                                                     4.36667 |                    31 |                             33.9533 |                         0 |                                        4.02 |                   0 |                                                10.78 |                       3 |                               11.8267 |                        0 |                                              0.873333 |                                   0 |                                                      2.04667 |            382 |             348.06 |             5015 |                                5281.3 |                                              18 |                 8 |                       10 |              19 |            |            |            |            |
| All LAs                      |              330 | Birmingham                   |                                                                                            5017 |                                                                                             4608.12 |                   116 |                                             124.733 |                                         53 |                                                               70.4333 |                                     68 |                                                                             84.2133 |                2 |                                                                                     4.36667 |                    35 |                             33.9533 |                         0 |                                        4.02 |                  13 |                                                10.78 |                       1 |                               11.8267 |                        0 |                                              0.873333 |                                   0 |                                                      2.04667 |            288 |             348.06 |             5586 |                                5281.3 |                                               8 |                 3 |                        5 |               1 |            |            |            |            |
| All LAs                      |              890 | Blackpool                    |                                                                                            4575 |                                                                                             4608.12 |                    79 |                                             124.733 |                                         71 |                                                               70.4333 |                                    159 |                                                                             84.2133 |                4 |                                                                                     4.36667 |                    59 |                             33.9533 |                        20 |                                        4.02 |                   0 |                                                10.78 |                      11 |                               11.8267 |                        0 |                                              0.873333 |                                   0 |                                                      2.04667 |            402 |             348.06 |             5315 |                                5281.3 |                                              17 |                21 |                       37 |               6 |            |            |            |            |
| All LAs                      |              801 | Bristol, City of             |                                                                                            4771 |                                                                                             4608.12 |                   108 |                                             124.733 |                                         92 |                                                               70.4333 |                                     53 |                                                                             84.2133 |                0 |                                                                                     4.36667 |                     7 |                             33.9533 |                        16 |                                        4.02 |                  20 |                                                10.78 |                      17 |                               11.8267 |                        0 |                                              0.873333 |                                   0 |                                                      2.04667 |            317 |             348.06 |             5444 |                                5281.3 |                                              25 |                 9 |                       11 |               2 |            |            |            |            |
| All LAs                      |              305 | Bromley                      |                                                                                            4349 |                                                                                             4608.12 |                   181 |                                             124.733 |                                          4 |                                                               70.4333 |                                    174 |                                                                             84.2133 |                0 |                                                                                     4.36667 |                    40 |                             33.9533 |                         7 |                                        4.02 |                  13 |                                                10.78 |                       8 |                               11.8267 |                        0 |                                              0.873333 |                                   0 |                                                      2.04667 |            427 |             348.06 |             5074 |                                5281.3 |                                              21 |                 7 |                        9 |               8 |            |            |            |            |
| All LAs                      |              381 | Calderdale                   |                                                                                            4293 |                                                                                             4608.12 |                    99 |                                             124.733 |                                         33 |                                                               70.4333 |                                     10 |                                                                             84.2133 |                0 |                                                                                     4.36667 |                    27 |                             33.9533 |                         0 |                                        4.02 |                  48 |                                                10.78 |                      59 |                               11.8267 |                        0 |                                              0.873333 |                                   0 |                                                      2.04667 |            275 |             348.06 |             4732 |                                5281.3 |                                               0 |                 9 |                       11 |               4 |            |            |            |            |


Table: Power BI - S251
|   Comparator_code | Statistical neighbour comparator for:   |   Neighbour_code | Neighbour_name       |   Individual Schools Budget (before Academy recoupment), including high needs place funding (B) |   Individual Schools Budget (before Academy recoupment), including high needs place funding AVERAGE |   Top-up – maintained |   1.2.1 Top-up funding – maintained schools AVERAGE |   Top-up - academies/free schools/colleges |   1.2.2 Top-up funding – academies, free schools and colleges AVERAGE |   Top-up/other – NM and Ind providers |   1.2.3 Top-up and other funding – non-maintained and independent providers AVERAGE |   Additional HN funding - mainstream/academies |   1.2.4 Additional high needs targeted funding for mainstream schools and academies AVERAGE |   SEN support service |   1.2.5 SEN support service AVERAGE |   Hosp. education services |   1.2.6 Hospital education services AVERAGE |   Other AP services |   1.2.7 Other alternative provision services AVERAGE |   Support for inclusion |   1.2.8 Support for inclusion AVERAGE |   Direct payments (SEND) |   1.2.11 Direct payments (SEN and disability) AVERAGE |   Therapies / other health services |   1.2.13 Therapies and other health related services AVERAGE |   HN TOTAL (E) |   HN comparator average |   Schools budget |   Schools budget - comparator average |   SEN admin / assess / coordination / monitoring |   Direct payment |   Short breaks / respite |   Other support | Column35   | Column36   | Column37   |
|------------------:|:----------------------------------------|-----------------:|:---------------------|------------------------------------------------------------------------------------------------:|----------------------------------------------------------------------------------------------------:|----------------------:|----------------------------------------------------:|-------------------------------------------:|----------------------------------------------------------------------:|--------------------------------------:|------------------------------------------------------------------------------------:|-----------------------------------------------:|--------------------------------------------------------------------------------------------:|----------------------:|------------------------------------:|---------------------------:|--------------------------------------------:|--------------------:|-----------------------------------------------------:|------------------------:|--------------------------------------:|-------------------------:|------------------------------------------------------:|------------------------------------:|-------------------------------------------------------------:|---------------:|------------------------:|-----------------:|--------------------------------------:|-------------------------------------------------:|-----------------:|-------------------------:|----------------:|:-----------|:-----------|:-----------|
|               370 | Barnsley                                |              807 | Redcar and Cleveland |                                                                                            4723 |                                                                                             4624.73 |                   148 |                                            111.636  |                                         74 |                                                               73.8182 |                                    74 |                                                                             83.7273 |                                              0 |                                                                                    0.545455 |                    46 |                             40.1818 |                         12 |                                     2.90909 |                   0 |                                              3.63636 |                       1 |                               5.90909 |                        0 |                                               1.81818 |                                   0 |                                                    0.181818  |            356 |                 324.818 |             5285 |                               5191.18 |                                                0 |          16      |                       12 |               0 |            |            |            |
|               370 | Barnsley                                |              342 | St Helens            |                                                                                            4340 |                                                                                             4624.73 |                   255 |                                            111.636  |                                          1 |                                                               73.8182 |                                   100 |                                                                             83.7273 |                                              0 |                                                                                    0.545455 |                    45 |                             40.1818 |                          0 |                                     2.90909 |                   0 |                                              3.63636 |                       0 |                               5.90909 |                        0 |                                               1.81818 |                                   0 |                                                    0.181818  |            401 |                 324.818 |             5023 |                               5191.18 |                                                7 |          16      |                       17 |               0 |            |            |            |
|               889 | Blackburn with Darwen                   |              353 | Oldham               |                                                                                            4608 |                                                                                             4567.36 |                    64 |                                            126.091  |                                        172 |                                                               58.5455 |                                    62 |                                                                             73      |                                              0 |                                                                                    1.72727  |                    43 |                             36.1818 |                          2 |                                     2.27273 |                   0 |                                              7.27273 |                      23 |                               6.90909 |                        0 |                                               0       |                                   0 |                                                    3.27273   |            365 |                 316.182 |             5267 |                               5143.64 |                                               17 |          10.4545 |                       39 |               0 |            |            |            |
|               890 | Blackpool                               |              807 | Redcar and Cleveland |                                                                                            4723 |                                                                                             4602.55 |                   148 |                                             97      |                                         74 |                                                               97.4545 |                                    74 |                                                                             94.8182 |                                              0 |                                                                                    2.45455  |                    46 |                             32.1818 |                         12 |                                     4.36364 |                   0 |                                              9.90909 |                       1 |                               7.72727 |                        0 |                                               1.81818 |                                   0 |                                                    0.0909091 |            356 |                 348.273 |             5285 |                               5234.91 |                                                0 |          17.0909 |                       12 |               0 |            |            |            |
|               380 | Bradford                                |              353 | Oldham               |                                                                                            4608 |                                                                                             4547.18 |                    64 |                                            128.364  |                                        172 |                                                               59.0909 |                                    62 |                                                                             67.7273 |                                              0 |                                                                                    1.36364  |                    43 |                             35.1818 |                          2 |                                     2.45455 |                   0 |                                              6.90909 |                      23 |                               9.72727 |                        0 |                                               0       |                                   0 |                                                    3.36364   |            365 |                 315.455 |             5267 |                               5131.73 |                                               17 |          10.4545 |                       39 |               0 |            |            |            |
|               841 | Darlington                              |              342 | St Helens            |                                                                                            4340 |                                                                                             4493.09 |                   255 |                                            132.273  |                                          1 |                                                               58.1818 |                                   100 |                                                                             58.7273 |                                              0 |                                                                                    0.727273 |                    45 |                             42.9091 |                          0 |                                     2.63636 |                   0 |                                              5.81818 |                       0 |                              10.4545  |                        0 |                                               1.81818 |                                   0 |                                                    0.272727  |            401 |                 314.636 |             5023 |                               5057.09 |                                                7 |          12.8182 |                       17 |               0 |            |            |            |
|               841 | Darlington                              |              390 | Gateshead            |                                                                                            4227 |                                                                                             4493.09 |                   132 |                                            132.273  |                                         54 |                                                               58.1818 |                                    47 |                                                                             58.7273 |                                              0 |                                                                                    0.727273 |                    83 |                             42.9091 |                          0 |                                     2.63636 |                   0 |                                              5.81818 |                      14 |                              10.4545  |                        0 |                                               1.81818 |                                   0 |                                                    0.272727  |            329 |                 314.636 |             4812 |                               5057.09 |                                                0 |          12.8182 |                       16 |               0 |            |            |            |
|               371 | Doncaster                               |              807 | Redcar and Cleveland |                                                                                            4723 |                                                                                             4581.64 |                   148 |                                             95.3636 |                                         74 |                                                               66.8182 |                                    74 |                                                                             76.7273 |                                              0 |                                                                                    0.454545 |                    46 |                             44.4545 |                         12 |                                     2.36364 |                   0 |                                              9.90909 |                       1 |                               5.54545 |                        0 |                                               0       |                                   0 |                                                    0.0909091 |            356 |                 302.455 |             5285 |                               5102.73 |                                                0 |          13.1818 |                       12 |               0 |            |            |            |
|               840 | Durham                                  |              342 | St Helens            |                                                                                            4340 |                                                                                             4562.82 |                   255 |                                            112.182  |                                          1 |                                                               72.5455 |                                   100 |                                                                             63.2727 |                                              0 |                                                                                    0.545455 |                    45 |                             42.9091 |                          0 |                                     2.63636 |                   0 |                                              1.27273 |                       0 |                               6.72727 |                        0 |                                               1.81818 |                                   0 |                                                    0.272727  |            401 |                 305.091 |             5023 |                               5120.73 |                                                7 |          14.8182 |                       17 |               0 |            |            |            |
|               840 | Durham                                  |              390 | Gateshead            |                                                                                            4227 |                                                                                             4562.82 |                   132 |                                            112.182  |                                         54 |                                                               72.5455 |                                    47 |                                                                             63.2727 |                                              0 |                                                                                    0.545455 |                    83 |                             42.9091 |                          0 |                                     2.63636 |                   0 |                                              1.27273 |                      14 |                               6.72727 |                        0 |                                               1.81818 |                                   0 |                                                    0.272727  |            329 |                 305.091 |             4812 |                               5120.73 |                                                0 |          14.8182 |                       16 |               0 |            |            |            |


Table: Power BI - SEN2
| Locality              |   Year |   % within 20 weeks (exc exceptions) |   Number of new EHC Plans issued (inc exceptions) |   % of EHC Plans issued within 20 weeks (inc exceptions) |   Number of new EHC Plans issues (exc exceptions) |
|:----------------------|-------:|-------------------------------------:|--------------------------------------------------:|---------------------------------------------------------:|--------------------------------------------------:|
| Barking and Dagenham  |   2014 |                                    0 |                                                 0 |                                                        0 |                                                 0 |
| Barnet                |   2014 |                                    0 |                                                 0 |                                                        0 |                                                 0 |
| Barnsley              |   2014 |                                    0 |                                                 0 |                                                        0 |                                                 0 |
| Bexley                |   2014 |                                    0 |                                                 0 |                                                        0 |                                                 0 |
| Blackburn with Darwen |   2014 |                                    0 |                                                 0 |                                                        0 |                                                 0 |
| Blackpool             |   2014 |                                    0 |                                                 0 |                                                        0 |                                                 0 |
| Bracknell Forest      |   2014 |                                    0 |                                                 0 |                                                        0 |                                                 0 |
| Bradford              |   2014 |                                    0 |                                                 0 |                                                        0 |                                                 0 |
| Bury                  |   2014 |                                    0 |                                                 0 |                                                        0 |                                                 0 |
| Cambridgeshire        |   2014 |                                    0 |                                                 0 |                                                        0 |                                                 0 |


Table: Power BI - Tribunal 1st Court
|   Year | Attribute                                         |   Value |
|-------:|:--------------------------------------------------|--------:|
|   2012 | Total appeals registered                          |    3557 |
|   2012 | Autistic Spectrum Disorder (ASD)                  |    1024 |
|   2012 | Behaviour, Emotional and Social Difficulty (BESD) |     364 |
|   2012 | Hearing Impairment (HI)                           |      87 |
|   2012 | Moderate Learning Difficulty (MLD)                |     130 |
|   2012 | Physical Disability (PD)                          |     258 |
|   2012 | Profound and Multiple Learning Difficulty (PMLD)  |      82 |
|   2012 | Severe Learning Difficulty (SLD)                  |      41 |
|   2012 | Specific Learning Difficulty (SpLD)               |     301 |
|   2012 | Speech, Language and Communication Needs (SLCN)   |     298 |


Table: Power BI - Tribunal
| Region     | Local Area           |   Number of mediation cases held during 2017 |   Of which followed by an appeal Number |   Of which followed by appeal % |
|:-----------|:---------------------|---------------------------------------------:|----------------------------------------:|--------------------------------:|
| ENGLAND    | England              |                                         3202 |                                     845 |                         26.3898 |
| NORTH EAST | Darlington           |                                            9 |                                       2 |                         22.2222 |
| NORTH EAST | Durham               |                                           19 |                                       3 |                         15.7895 |
| NORTH EAST | Gateshead            |                                            6 |                                       2 |                         33.3333 |
| NORTH EAST | Hartlepool           |                                            0 |                                       0 |                          0      |
| NORTH EAST | Middlesbrough        |                                            1 |                                       0 |                          0      |
| NORTH EAST | Newcastle upon Tyne  |                                            0 |                                       0 |                          0      |
| NORTH EAST | North Tyneside       |                                           22 |                                      11 |                         50      |
| NORTH EAST | Northumberland       |                                           12 |                                       0 |                          0      |
| NORTH EAST | Redcar and Cleveland |                                            6 |                                       4 |                         66.6667 |


Table: Ref_Age
| Age-Band   |
|:-----------|
| Under-18   |
| 18-24      |
| 25-34      |
| 35-44      |
| 45-54      |
| 55-64      |
| 65+        |


Table: Ref_Ethinicity
| Ethnicity              |
|:-----------------------|
| Asian or Asian British |
| Black or Black British |
| Mixed                  |
| Not known              |
| Other Ethnic Groups    |
| White                  |


Table: Ref_Gender
| Gender   |
|:---------|
| Male     |
| Female   |


Table: Ref_School Type
| School Type                    |
|:-------------------------------|
| State-funded primary schools   |
| State-funded secondary schools |
| Special schools                |


Table: Ref_Type of support
| Type of support   |
|:------------------|
| SEN Support       |
| EHC Plan          |


Table: Table
| Local Area (groups)   |   sales amount |   Autistic Spectrum  |
|:----------------------|---------------:|---------------------:|
| LAs                   |            530 |                  265 |
| LAs                   |           1198 |                 1198 |
| LAs                   |            924 |                  462 |
| LAs                   |            219 |                  219 |
| LAs                   |            364 |                  364 |
| LAs                   |            676 |                  676 |
| LAs                   |            780 |                  390 |
| LAs                   |            693 |                  693 |
| LAs                   |            311 |                  311 |
| LAs                   |            437 |                  437 |

 


tables: name: Care_activities
data: Care_activities.csv
name: Care_by_Provider
data: Care_by_Provider.csv
name: Care_Contact
data: Care_Contact.csv
name: Care_Patient_Gender
data: Care_Patient_Gender.csv
name: Counties_and_Unitary_Authorities_December_2019
data: Counties_and_Unitary_Authorities_December_2019.csv
name: Ethnicity - SEN data (2)
data: Ethnicity - SEN data (2).csv
name: External_Dashboards
data: External_Dashboards.csv
name: Free School Meals - SEN data
data: Free School Meals - SEN data.csv
name: Gender - SEN data
data: Gender - SEN data.csv
name: LAGroupList
data: LAGroupList.csv
name: LDHC (14-18yrs)
data: LDHC (14-18yrs).csv
name: LDS - Gender
data: LDS - Gender.csv
name: LDS - TCP
data: LDS - TCP.csv
name: LDS - Ward Security
data: LDS - Ward Security.csv
name: MHSDS - CCG_Total
data: MHSDS - CCG_Total.csv
name: MHSDS Measures (2)
data: MHSDS Measures (2).csv
name: NEET_SEND_16-17yr-olds
data: NEET_SEND_16-17yr-olds.csv
name: Power BI - 14
data: Power BI - 14.csv
name: Power BI - 16, 17, 18
data: Power BI - 16, 17, 18.csv
name: Power BI - 19
data: Power BI - 19.csv
name: Power BI - Absence
data: Power BI - Absence.csv
name: Power BI - CCG Pop
data: Power BI - CCG Pop.csv
name: Power BI - CIN
data: Power BI - CIN.csv
name: Power BI - Excl
data: Power BI - Excl.csv
name: Power BI - EYFS
data: Power BI - EYFS.csv
name: Power BI - KS1
data: Power BI - KS1.csv
name: Power BI - KS2 Att
data: Power BI - KS2 Att.csv
name: Power BI - KS2 Prog
data: Power BI - KS2 Prog.csv
name: Power BI - KS4
data: Power BI - KS4.csv
name: Power BI - LA region lookup
data: Power BI - LA region lookup.csv
name: Power BI - MHSDS (2)
data: Power BI - MHSDS (2).csv
name: Power BI - NEET
data: Power BI - NEET.csv
name: Power BI - PHB
data: Power BI - PHB.csv
name: Power BI - Pop (2)
data: Power BI - Pop (2).csv
name: Power BI - S251 (2)
data: Power BI - S251 (2).csv
name: Power BI - S251
data: Power BI - S251.csv
name: Power BI - SEN2
data: Power BI - SEN2.csv
name: Power BI - Tribunal 1st Court
data: Power BI - Tribunal 1st Court.csv
name: Power BI - Tribunal
data: Power BI - Tribunal.csv
name: Ref_Age
data: Ref_Age.csv
name: Ref_Ethinicity
data: Ref_Ethinicity.csv
name: Ref_Gender
data: Ref_Gender.csv
name: Ref_School Type
data: Ref_School Type.csv
name: Ref_Type of support
data: Ref_Type of support.csv
name: Table
data: Table.csv
label: Power BI - 16, 17, 18
Local Area
Power BI - 19
Local Area
Power BI - LA region lookup
Region
Power BI - Pop (2)
Name
Power BI - EYFS
National Area
Power BI - LA region lookup
LA
Power BI - SEN2
Locality
Power BI - LA region lookup
LA
Power BI - Excl
SEN Need
Power BI - Absence
SEN need
Power BI - LA region lookup
LA
Power BI - Tribunal
Local Area
Power BI - KS2 Att
Local Area
Power BI - LA region lookup
LA
Power BI - KS4
Local Area
Power BI - LA region lookup
LA
Power BI - KS2 Prog
Local Area
Power BI - LA region lookup
LA
Power BI - NEET
National Area_1
Power BI - LA region lookup
LA
Power BI - CIN
Local Area
Power BI - LA region lookup
LA
Power BI - KS1
Local area
Power BI - LA region lookup
LA
Counties_and_Unitary_Authorities_December_2019
Local area
Power BI - Tribunal
Local Area
Power BI - 19
Local Area
Counties_and_Unitary_Authorities_December_2019
Local area
Free School Meals - SEN data
Type of support
Ref_Type of support
Type of support
Gender - SEN data
Type of support
Ref_Type of support
Type of support
Free School Meals - SEN data
School Type
Ref_School Type
School Type
Gender - SEN data
School Type
Ref_School Type
School Type
Ethnicity - SEN data (2)
Type of support
Ref_Type of support
Type of support
Ethnicity - SEN data (2)
School Type
Ref_School Type
School Type
LDS - Ward Security
Age-Band
Ref_Age
Age-Band
LDS - Gender
Age-Band
Ref_Age
Age-Band
output: {
    "joins": [
        {
            "from_table": "Power BI - 16, 17, 18",
            "from_column": "Local Area",
            "to_table": "Power BI - 19",
            "to_column": "Local Area"
        },
        {
            "from_table": "Power BI - LA region lookup",
            "from_column": "Region",
            "to_table": "Power BI - Pop (2)",
            "to_column": "Name"
        },
        {
            "from_table": "Power BI - EYFS",
            "from_column": "National Area",
            "to_table": "Power BI - LA region lookup",
            "to_column": "LA"
        },
        {
            "from_table": "Power BI - SEN2",
            "from_column": "Locality",
            "to_table": "Power BI - LA region lookup",
            "to_column": "LA"
        },
        {
            "from_table": "Power BI - Excl",
            "from_column": "SEN Need",
            "to_table": "Power BI - Absence",
            "to_column": "SEN need"
        },
        {
            "from_table": "Power BI - LA region lookup",
            "from_column": "LA",
            "to_table": "Power BI - Tribunal",
            "to_column": "Local Area"
        },
        {
            "from_table": "Power BI - KS2 Att",
            "from_column": "Local Area",
            "to_table": "Power BI - LA region lookup",
            "to_column": "LA"
        },
        {
            "from_table": "Power BI - KS4",
            "from_column": "Local Area",
            "to_table": "Power BI - LA region lookup",
            "to_column": "LA"
        },
        {
            "from_table": "Power BI - KS2 Prog",
            "from_column": "Local Area",
            "to_table": "Power BI - LA region lookup",
            "to_column": "LA"
        },
        {
            "from_table": "Power BI - NEET",
            "from_column": "National Area_1",
            "to_table": "Power BI - LA region lookup",
            "to_column": "LA"
        },
        {
            "from_table": "Power BI - CIN",
            "from_column": "Local Area",
            "to_table": "Power BI - LA region lookup",
            "to_column": "LA"
        },
        {
            "from_table": "Power BI - KS1",
            "from_column": "Local area",
            "to_table": "Power BI - LA region lookup",
            "to_column": "LA"
        },
        {
            "from_table": "Counties_and_Unitary_Authorities_December_2019",
            "from_column": "Local area",
            "to_table": "Power BI - Tribunal",
            "to_column": "Local Area"
        },
        {
            "from_table": "Power BI - 19",
            "from_column": "Local Area",
            "to_table": "Counties_and_Unitary_Authorities_December_2019",
            "to_column": "Local area"
        },
        {
            "from_table": "Free School Meals - SEN data",
            "from_column": "Type of support",
            "to_table": "Ref_Type of support",
            "to_column": "Type of support"
        },
        {
            "from_table": "Gender - SEN data",
            "from_column": "Type of support",
            "to_table": "Ref_Type of support",
            "to_column": "Type of support"
        },
        {
            "from_table": "Free School Meals - SEN data",
            "from_column": "School Type",
            "to_table": "Ref_School Type",
            "to_column": "School Type"
        },
        {
            "from_table": "Gender - SEN data",
            "from_column": "School Type",
            "to_table": "Ref_School Type",
            "to_column": "School Type"
        },
        {
            "from_table": "Ethnicity - SEN data (2)",
            "from_column": "Type of support",
            "to_table": "Ref_Type of support",
            "to_column": "Type of support"
        },
        {
            "from_table": "Ethnicity - SEN data (2)",
            "from_column": "School Type",
            "to_table": "Ref_School Type",
            "to_column": "School Type"
        },
        {
            "from_table": "LDS - Ward Security",
            "from_column": "Age-Band",
            "to_table": "Ref_Age",
            "to_column": "Age-Band"
        },
        {
            "from_table": "LDS - Gender",
            "from_column": "Age-Band",
            "to_table": "Ref_Age",
            "to_column": "Age-Band"
        }
    ]
}