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: ASBWard
| WardName               | WardCode   |   Anti-social behaviour |
|:-----------------------|:-----------|------------------------:|
| Audley                 | E05001620  |                     509 |
| Bastwell               | E05001621  |                     313 |
| Beardwood with Lammack | E05001622  |                     100 |
| Corporation Park       | E05001623  |                     286 |
| Earcroft               | E05001624  |                     207 |
| East Rural             | E05001625  |                      51 |
| Ewood                  | E05001626  |                     695 |
| Fernhurst              | E05001627  |                     140 |
| Higher Croft           | E05001628  |                     409 |
| Little Harwood         | E05001629  |                     368 |


Table: CCGLSOA
| CCG CD   | CCG NM   | LSOA CD   |
|:---------|:---------|:----------|
|          |          |           |
|          |          |           |
|          |          |           |
|          |          |           |
|          |          |           |
|          |          |           |
|          |          |           |
|          |          |           |
|          |          |           |
|          |          |           |


Table: ClaimantCountNationalMarch17
| Area name   |   Claimant count |   Claimants as a proportion of residents aged 16-64 |
|:------------|-----------------:|----------------------------------------------------:|
| England     |           663085 |                                                 1.9 |


Table: ClaimantCountWardMarch17
| Area code   | Area name              |   Claimant count |   Claimants as a proportion of residents aged 16-64 |
|:------------|:-----------------------|-----------------:|----------------------------------------------------:|
| E05001620   | Audley                 |              225 |                                                 4   |
| E05001621   | Bastwell               |              155 |                                                 3.2 |
| E05001622   | Beardwood with Lammack |               30 |                                                 0.9 |
| E05001623   | Corporation Park       |              115 |                                                 2.5 |
| E05001624   | Earcroft               |               90 |                                                 3.5 |
| E05001625   | East Rural             |                5 |                                                 0.6 |
| E05001626   | Ewood                  |              145 |                                                 3.1 |
| E05001627   | Fernhurst              |               20 |                                                 0.5 |
| E05001628   | Higher Croft           |              120 |                                                 2.4 |
| E05001629   | Little Harwood         |              130 |                                                 3   |


Table: CountytoDistrictHierarchy
| County Code   | County name           | District code   | District Name         |
|:--------------|:----------------------|:----------------|:----------------------|
| E06000008     | Blackburn with Darwen | E06000008       | Blackburn with Darwen |
| E06000009     | Blackpool             | E06000009       | Blackpool             |
| E10000017     | Lancashire            | E07000117       | Burnley               |
| E10000017     | Lancashire            | E07000118       | Chorley               |
| E10000017     | Lancashire            | E07000119       | Fylde                 |
| E10000017     | Lancashire            | E07000120       | Hyndburn              |
| E10000017     | Lancashire            | E07000121       | Lancaster             |
| E10000017     | Lancashire            | E07000122       | Pendle                |
| E10000017     | Lancashire            | E07000123       | Preston               |
| E10000017     | Lancashire            | E07000124       | Ribble Valley         |


Table: DeathsUnder75England
| Area Code   | Area Code (old)   | Area Name   |   Numerator |   Denominator |   Indicator Value |   LCI |   UCI |
|:------------|:------------------|:------------|------------:|--------------:|------------------:|------:|------:|
| E92000001   |                   | England     |      751654 |        751654 |               100 |  99.8 | 100.2 |


Table: DeathsUnder75Ward
| ward Code   | Ward Name                   | DISTRICT              | WDNM15                      |   Numerator |   Denominator |   Indicator Value |   LCI |   UCI |
|:------------|:----------------------------|:----------------------|:----------------------------|------------:|--------------:|------------------:|------:|------:|
| E05001620   | Audley Ward                 | Blackburn with Darwen | Audley Ward                 |         167 |          96.1 |             173.7 | 148.4 | 202.2 |
| E05001621   | Bastwell Ward               | Blackburn with Darwen | Bastwell Ward               |          77 |          64.2 |             119.9 |  94.6 | 149.9 |
| E05001622   | Beardwood with Lammack Ward | Blackburn with Darwen | Beardwood with Lammack Ward |          56 |          92.9 |              60.3 |  45.5 |  78.3 |
| E05001623   | Corporation Park Ward       | Blackburn with Darwen | Corporation Park Ward       |          88 |          70.5 |             124.8 | 100.1 | 153.7 |
| E05001624   | Earcroft Ward               | Blackburn with Darwen | Earcroft Ward               |         117 |          61.8 |             189.2 | 156.4 | 226.7 |
| E05001625   | East Rural Ward             | Blackburn with Darwen | East Rural Ward             |          27 |          35.6 |              75.9 |  50   | 110.4 |
| E05001626   | Ewood Ward                  | Blackburn with Darwen | Ewood Ward                  |         109 |          84.8 |             128.5 | 105.5 | 155   |
| E05001627   | Fernhurst Ward              | Blackburn with Darwen | Fernhurst Ward              |          61 |          68.2 |              89.4 |  68.4 | 114.9 |
| E05001628   | Higher Croft Ward           | Blackburn with Darwen | Higher Croft Ward           |         135 |          92.1 |             146.6 | 122.9 | 173.5 |
| E05001629   | Little Harwood Ward         | Blackburn with Darwen | Little Harwood Ward         |          95 |          77.3 |             122.9 |  99.4 | 150.2 |


Table: District2015Pop
| District Code   | District Name         |   2015 MYE |   Thous | Area          |
|:----------------|:----------------------|-----------:|--------:|:--------------|
| NG              | Not geocoded          |          0 |   0     | Lancashire-14 |
| E06000008       | Blackburn with Darwen |     146846 | 146.846 | Lancashire-14 |
| E06000009       | Blackpool             |     139578 | 139.578 | Lancashire-14 |
| E07000117       | Burnley               |      87371 |  87.371 | Lancashire-14 |
| E07000118       | Chorley               |     112969 | 112.969 | Lancashire-14 |
| E07000119       | Fylde                 |      77322 |  77.322 | Lancashire-14 |
| E07000120       | Hyndburn              |      80228 |  80.228 | Lancashire-14 |
| E07000121       | Lancaster             |     142283 | 142.283 | Lancashire-14 |
| E07000122       | Pendle                |      90111 |  90.111 | Lancashire-14 |
| E07000123       | Preston               |     141302 | 141.302 | Lancashire-14 |


Table: DistrictStory
| Area code   | District              | Deprivation                                                      | Mosaic                                                                                                                                                                            | Female_LE                                                   | Male_LE                                                    | Sentence1                                                                                                                                                                                                                                                                                                                                                                                                                                                                | Sentence2                                                                                                                                                                                                                                                                                                                                                  | Sentence3                                                                                                                                                                                                                                                                                                                                                      | Sentence4                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
|:------------|:----------------------|:-----------------------------------------------------------------|:----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:------------------------------------------------------------|:-----------------------------------------------------------|:-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| E06000008   | Blackburn with Darwen | This district is ranked in the 20% most deprived in Lancashire.  | The dominant Mosaic group is I - Urban Cohesion, which makes up 18% of households. It's decscribed as residents of settled urban communities with a strong sense of identity.     | Female life expectancy is significantly lower than England. | Male life expectancy is significantly lower than England.  | Most health, wellbeing and wider-determinant indicators in Blackburn with Darwen are poor and in-line with its deprivation ranking. Blackburn with Darwen has the third lowest life expectancy for males and females in Lancashire, with the joint highest low birth rate along with Preston.                                                                                                                                                                            | Blackburn with Darwen has the highest emergency admissions and second highest ratio of deaths from circulatory disease in Lancashire.                                                                                                                                                                                                                      | This authority has the second highest ratio of hospital admissions for alcohol attributable harm, despite having the lowest percentage of binge drinking adults in Lancashire. Blackburn with Darwen performs better than would be expected for ratio of respiratory disease deaths and percentage of residents with limiting long term illness or disability. | Blackburn with Darwen has the second highest number of vacant dwellings and number of housing benefit claimants in Lancashire. It also has the third highest percentage of overcrowding, households with 1 or more rooms too few, of all the districts and third highest number of killed or seriously injured in road traffic accidents behind Lancaster and Preston.                                                                                                                       |
| E06000009   | Blackpool             | This district is ranked in the 20% most deprived in Lancashire.  | The dominant Mosaic group is L - Transient Renters, which makes up 23% of households. It's decscribed as single people privately renting low cost homes for the short term .      | Female life expectancy is significantly lower than England. | Male life expectancy is significantly lower than England.  | Blackpool performs poorly in most deprivation sub-domains and comes in as fourth most deprived district in the country, making it the most deprived district in Lancashire. Most health, wellbeing and wider-determinant indicators in Blackpool are poor and in-line with its deprivation ranking.                                                                                                                                                                      | Blackpool has the lowest life expectancy of male and females in Lancashire. This authority has the highest ratio of respiratory disease deaths, deaths under 75, percentage of bad or very bad general health, highest prevalence of smokers and highest percentage of residents with a limiting long term illness or disability.                          | Blackpool has, by far, the highest rate of drug misuse deaths and hospital stays for intentional self-harm in Lancashire. This district has a lower percentage of binge drinking adults as would be expected, at only seventh highest of the fourteen districts, despite having the highest ratio of hospital admissions for alcohol attributable harm.        | Blackpool has the highest amount of children in low income families, vacant dwellings and housing benefit claimants in Lancashire. 40% of year 6 children are overweight or obese, the highest percentage in Lancashire. This aligns with Blackpool having the lowest percentage of healthy eating adults and highest percentage of obese adults of all the districts in Lancashire. Blackpool has only the third lowest percentage of physically active adults, behind Burnley and Preston. |
| E07000117   | Burnley               | This district is ranked in the 20% most deprived in Lancashire.  | The dominant Mosaic group is L - Transient Renters, which makes up 23% of households. It's decscribed as single people privately renting low cost homes for the short term .      | Female life expectancy is significantly lower than England. | Male life expectancy is significantly lower than England.  | Most health, wellbeing and wider-determinant indicators in Burnley are poor and in-line with its deprivation ranking. Burnley has the second lowest life expectancy for male and females, the highest ratio of cancer deaths and second highest ratio of deaths under 75 in Lancashire. Burnley has the second highest percentage of residents in bad or very bad general health and third highest percentage of limiting long term illness or disability in Lancashire. | Burnley has the highest rate of infant deaths under 1 year of age per 1000 live births, the second highest rate of emergency hospital admissions for children under the age of five, the second highest for children in low income families, the third highest proportion of low birth rate and second highest percentage for fuel poverty.                | This authority has the second highest drug misuse deaths rate and second highest ratio in hospital stays for intentional self-harm.                                                                                                                                                                                                                            | Burnley has a slightly lower percentage of obese adults than would be expected considering that it has the lowest percentage in physically active adults and second lowest percentage of healthy eating adults in Lancashire. Burnley has the third highest smoking prevalence in adults in Lancashire.                                                                                                                                                                                      |
| E07000118   | Chorley               | This district is ranked in the 40% least deprived.               | The dominant Mosaic group is H - Aspiring Homemakers, which makes up 15% of households. It's decscribed as younger households settling down in housing priced within their means. | Female life expectancy is significantly lower than England. | Male life expectancy is similar to  England.               | Most health, wellbeing and wider-determinant indicators are good in Chorley and in-line with its deprivation ranking. Despite this, female life expectancy in Chorley is lower than the national average.                                                                                                                                                                                                                                                                | Chorley has the third lowest ratio of cancer deaths, rate of drug misuse deaths, percentage of fuel poverty and percentage of bad or very bad general health. Chorley has the third highest percentage of binge drinking adults in Lancashire.                                                                                                             | This authority has the lowest rate of emergency hospital admissions for children under five. Chorley has the second highest rate of infant deaths (under 1 year of age per 1000 live births).                                                                                                                                                                  | The dominant Mosaic group is H - Aspiring Homemakers, which makes up 15% of households. It's described as younger households settling down in housing priced within their means.                                                                                                                                                                                                                                                                                                             |
| E07000119   | Fylde                 | This district is ranked in the 20% least deprived.               | The dominant Mosaic group is F - Senior Security, which makes up 18% of households. It's decscribed as elderly people with assets who are enjoying a comfortable retirement.      | Female life expectancy is similar to England.               | Male life expectancy is similar to  England.               | Most health, wellbeing and wider-determinant indicators are good in Fylde and in-line with its deprivation ranking.                                                                                                                                                                                                                                                                                                                                                      | Fylde has the second lowest rate of respiratory disease deaths in Lancashire. It has the lowest proportion of low birth rates in Lancashire, the lowest percentage of overweight or obese year 6 children and second lowest percentage of obese adults.                                                                                                    | Fylde has the joint highest percentage of healthy eating adults, with Ribble Valley, and the third lowest percentage of binge drinking adults in Lancashire.                                                                                                                                                                                                   | This authority has the second lowest ratio of emergency hospital admissions and second lowest crude rate of emergency hospital admissions for children (aged under 5 years).                                                                                                                                                                                                                                                                                                                 |
| E07000120   | Hyndburn              | This district is ranked in the 40% most deprived.                | The dominant Mosaic group is L - Transient Renters, which makes up 18% of households. It's decscribed as single people privately renting low cost homes for the short term .      | Female life expectancy is significantly lower than England. | Male life expectancy is significantly lower than England.  | Most health, wellbeing and wider-determinant indicators in Hyndburn are poor and in-line with its deprivation ranking. Life expectancy in Hyndburn is significantly lower than the national average.                                                                                                                                                                                                                                                                     | Hyndburn has the highest ratio of circulatory disease deaths and the highest crude rate of emergency hospital admissions for children. This authority has the second highest percentage of obese adults and third lowest percentage of healthy eating adults.                                                                                              | Hyndburn has one of Lancashire's lowest smoking prevalence in adults and a lower than expected percentage of binge drinking adults in Lancashire.                                                                                                                                                                                                              | Hyndburn has the fifth lowest ratio of infant deaths under 1 year of age per 1000 live births.                                                                                                                                                                                                                                                                                                                                                                                               |
| E07000121   | Lancaster             | Deprivation in this district is ranked as average in Lancashire. | The dominant Mosaic group is F - Senior Security, which makes up 12% of households. It's decscribed as elderly people with assets who are enjoying a comfortable retirement.      | Female life expectancy is significantly lower than England. | Male life expectancy is significantly lower than England.  | Health, wellbeing and wider-determinant indicators in Lancaster are mixed and come out as average in Lancashire.  Life expectancy in Lancaster is significantly lower than the national average.                                                                                                                                                                                                                                                                         | Lancaster has the second lowest percentage of obese adults in Lancashire and the second lowest infant deaths under 1 year of age per 1000 live births.                                                                                                                                                                                                     | This authority has the second highest percentage of binge drinkers in the district despite being average for hospital admissions for alcohol attributable harm compared to the rest of Lancashire.                                                                                                                                                             | Lancaster has the highest amount of killed or seriously injured in a road traffic accident of all other districts in Lancashire.                                                                                                                                                                                                                                                                                                                                                             |
| E07000122   | Pendle                | This district is ranked in the 40% most deprived.                | The dominant Mosaic group is L - Transient Renters, which makes up 18% of households. It's decscribed as single people privately renting low cost homes for the short term .      | Female life expectancy is significantly lower than England. | Male life expectancy is significantly lower than England.  | Most health, wellbeing and wider-determinant indicators are fairly poor compared to the rest of Lancashire and in-line with its deprivation ranking. Life expectancy in Pendle is significantly lower than the national average.                                                                                                                                                                                                                                         | Pendle has the highest percentage of overweight or obese year 6 children. This authority fairs poorly on other lifestyle indicators including obese adults, smoking prevalence, healthy eating and physically active adults. However, there is a much smaller percentage of binge drinking adults than would be expected - it is the lowest in Lancashire. | Pendle has the largest percentage of fuel poverty in Lancashire and performs poorly in the deprivation sub-domain, living environment rank. The living environment rank considers housing quality, air quality and road traffic accidents.                                                                                                                     | This district has the fourth lowest ratio on hospital stays for intentional self-harm.                                                                                                                                                                                                                                                                                                                                                                                                       |
| E07000123   | Preston               | This district is ranked in the 40% most deprived.                | The dominant Mosaic group is L - Transient Renters, which makes up 13% of households. It's decscribed as single people privately renting low cost homes for the short term .      | Female life expectancy is significantly lower than England. | Male life expectancy is significantly lower than England.  | Health, wellbeing and wider-determinant indicators in Preston are mixed and come out as average in Lancashire. Preston is ranked in the 40% most deprived of Lancashire. Life expectancy in Preston is significantly lower than the national average.                                                                                                                                                                                                                    | Preston has the highest proportion of low birth-weight births, joint with Blackburn with Darwen, yet has the lowest proportion of infant deaths under 1 year of age per 1000 live births in Lancashire.                                                                                                                                                    | Preston has the third lowest percentage of year 6 children who were classified as overweight or obese and the lowest percentage of obese adults in Lancashire, despite having the second lowest percentage of physically active adults.                                                                                                                        | This district has, by far, the highest percentage of overcrowded households, percentage of households with 1 or more rooms too few, in Lancashire.                                                                                                                                                                                                                                                                                                                                           |
| E07000124   | Ribble Valley         | This district is ranked in the 20% least deprived.               | The dominant Mosaic group is A - Country Living, which makes up 21% of households. It's decscribed as well-off owners in rural locations enjoying the benefits of rural life..    | Female life expectancy is similar to England.               | Male life expectancy is significantly higher than England. | Most health, wellbeing and wider-determinant indicators are good and in-line with its deprivation ranking. Ribble Valley is the least deprived district in Lancashire and the 36th least deprived authority of the 326 nationwide. Males have the highest life expectancy in Ribble Valley, which is significantly higher than the national average, and females have the second highest life expectancy in Lancashire.                                                  | This district has the lowest ratio of adult deaths from respiratory disease, cancer and under 75 years of age. It is also has the lowest ratio of emergency hospital admissions, lowest percentage of overweight or obese year 6 children and lowest for children in low income families.                                                                  | Ribble Valley has the third highest percentage of binge drinking adults, yet the lowest percentage of hospital admissions for alcohol attributable harm. This district also has the highest percentage of healthy eating adults in Lancashire. It has the second highest percentage of physically active adults and lowest smoking prevalence in adults.       | Infant mortality, percentage of obese adults and fuel poverty are higher in Ribble Valley than would be expected.                                                                                                                                                                                                                                                                                                                                                                            |


Table: England
| National code   | National name   |
|:----------------|:----------------|
| E92000001       | England         |


Table: EnglandPopulationData
| Area Code   | England   | Age Grou   | Gender   |   Quantity |
|:------------|:----------|:-----------|:---------|-----------:|
| E92000001   | England   | 0 to 4     | Males    |    1760388 |
| E92000001   | England   | 05 to 09   | Males    |    1718905 |
| E92000001   | England   | 10 to 14   | Males    |    1535237 |
| E92000001   | England   | 15 to 19   | Males    |    1650514 |
| E92000001   | England   | 20 to 24   | Males    |    1832468 |
| E92000001   | England   | 25 to 29   | Males    |    1887380 |
| E92000001   | England   | 30 to 34   | Males    |    1857883 |
| E92000001   | England   | 35 to 39   | Males    |    1730642 |
| E92000001   | England   | 40 to 44   | Males    |    1805140 |
| E92000001   | England   | 45 to 49   | Males    |    1921807 |


Table: GCSEsEngland
| Area Code   | Area Name   |   Numerator |   Denominator |   National % |   LCI |   UCI |
|:------------|:------------|------------:|--------------:|-------------:|------:|------:|
| E92000001   | England     |      315795 |        558181 |         56.6 |  56.4 |  56.7 |


Table: GCSEsWard
| Area Code   | Area Code (old)   | Area Name              |   Numerator |   Denominator |   Local % |   LCI |   UCI |
|:------------|:------------------|:-----------------------|------------:|--------------:|----------:|------:|------:|
| E05001620   | 00EXMZ            | Audley                 |          55 |           127 |      43.1 |  34.8 |  51.8 |
| E05001621   | 00EXNA            | Bastwell               |          65 |           110 |      59.1 |  49.7 |  67.8 |
| E05001622   | 00EXNB            | Beardwood with Lammack |          52 |            75 |      69.1 |  57.9 |  78.4 |
| E05001623   | 00EXNC            | Corporation Park       |          66 |           103 |      63.7 |  54.1 |  72.3 |
| E05001624   | 00EXND            | Earcroft               |          15 |            32 |      46.6 |  30.5 |  63.3 |
| E05001625   | 00EXNE            | East Rural             |          13 |            16 |      79.7 |  55.5 |  92.5 |
| E05001626   | 00EXNF            | Ewood                  |          49 |            86 |      56.5 |  46   |  66.5 |
| E05001627   | 00EXNG            | Fernhurst              |          51 |            78 |      65.7 |  54.6 |  75.2 |
| E05001628   | 00EXNH            | Higher Croft           |          50 |           103 |      48.9 |  39.4 |  58.4 |
| E05001629   | 00EXNJ            | Little Harwood         |          49 |            93 |      53.5 |  43.4 |  63.3 |


Table: GeneralHealthBadorVBadNational
| Area Code   | Area Code (old)   | Area Name   |   Numerator |   Denominator |   Indicator Value |   LCI |   UCI |
|:------------|:------------------|:------------|------------:|--------------:|------------------:|------:|------:|
| E92000001   |                   | England     |     2911195 |      53012456 |               5.5 |   5.5 |   5.5 |


Table: GeneralHealthBadorVBadWards
| ward Code   | Ward Name                   | DISTRICT              | WDNM15                      |   Numerator |   Denominator |   Indicator Value |   LCI |   UCI |
|:------------|:----------------------------|:----------------------|:----------------------------|------------:|--------------:|------------------:|------:|------:|
| E05001620   | Audley Ward                 | Blackburn with Darwen | Audley Ward                 |         903 |          9183 |               9.8 |   9.2 |  10.5 |
| E05001621   | Bastwell Ward               | Blackburn with Darwen | Bastwell Ward               |         596 |          7699 |               7.7 |   7.2 |   8.4 |
| E05001622   | Beardwood with Lammack Ward | Blackburn with Darwen | Beardwood with Lammack Ward |         250 |          5997 |               4.2 |   3.7 |   4.7 |
| E05001623   | Corporation Park Ward       | Blackburn with Darwen | Corporation Park Ward       |         475 |          7353 |               6.5 |   5.9 |   7   |
| E05001624   | Earcroft Ward               | Blackburn with Darwen | Earcroft Ward               |         427 |          4339 |               9.8 |   9   |  10.8 |
| E05001625   | East Rural Ward             | Blackburn with Darwen | East Rural Ward             |          93 |          1924 |               4.8 |   4   |   5.9 |
| E05001626   | Ewood Ward                  | Blackburn with Darwen | Ewood Ward                  |         502 |          6927 |               7.2 |   6.7 |   7.9 |
| E05001627   | Fernhurst Ward              | Blackburn with Darwen | Fernhurst Ward              |         181 |          5928 |               3.1 |   2.6 |   3.5 |
| E05001628   | Higher Croft Ward           | Blackburn with Darwen | Higher Croft Ward           |         651 |          7840 |               8.3 |   7.7 |   8.9 |
| E05001629   | Little Harwood Ward         | Blackburn with Darwen | Little Harwood Ward         |         494 |          6752 |               7.3 |   6.7 |   8   |


Table: HealthyEatingAdultsCountry
| Area Code   | Area Name   |   Numerator |   Denominator |   Indicator Value |   LCI |   UCI |
|:------------|:------------|------------:|--------------:|------------------:|------:|------:|
| E92000001   | England     |    11907157 |      41422025 |              28.7 |    28 |  29.3 |


Table: HealthyEatingAdultsWard
| Area Code   | Area Code (old)   | Area Name              |   Numerator |   Denominator |   Indicator Value |   LCI |   UCI |
|:------------|:------------------|:-----------------------|------------:|--------------:|------------------:|------:|------:|
| E05001620   | 00EXMZ            | Audley                 |      1176.1 |        5920.9 |              19.9 |  10.4 |  34.8 |
| E05001621   | 00EXNA            | Bastwell               |      1116.8 |        5076.7 |              22   |  11.1 |  39   |
| E05001622   | 00EXNB            | Beardwood with Lammack |      1443   |        4540.4 |              31.8 |  15.8 |  54.1 |
| E05001623   | 00EXNC            | Corporation Park       |      1431.1 |        4981.2 |              28.7 |  14.6 |  49   |
| E05001624   | 00EXND            | Earcroft               |       857.3 |        3473.6 |              24.7 |  10.9 |  47   |
| E05001625   | 00EXNE            | East Rural             |       580.5 |        1626.7 |              35.7 |  12.4 |  69.6 |
| E05001626   | 00EXNF            | Ewood                  |      1168.8 |        4980.3 |              23.5 |  11.3 |  42.7 |
| E05001627   | 00EXNG            | Fernhurst              |      1159.9 |        4387.1 |              26.4 |  12.9 |  46.9 |
| E05001628   | 00EXNH            | Higher Croft           |      1166.9 |        5591.8 |              20.9 |  10   |  38.6 |
| E05001629   | 00EXNJ            | Little Harwood         |      1172.5 |        4633.1 |              25.3 |  11.9 |  46.3 |


Table: IMD Ward(Calc)
| WardCode   | WardName              | District              |   IMD Decile |   IMD Quintile |   IMD Rank |   IMD Score |   Employment Decile |   Employment Quintile |   Employment Rank |   Employment Score (rate) |   Income Decile |   Income Quintile |   Income Rank |   Income Score (rate) |   Income Deprivation Affecting Children Index (IDACI) Decile |   Income Deprivation Affecting Children Index (IDACI) Quintile |   Income Deprivation Affecting Children Index (IDACI) Rank |   Income Deprivation Affecting Children Index (IDACI) Score (rate) |   Income Deprivation Affecting Older People (IDAOPI) Decile |   Income Deprivation Affecting Older People (IDAOPI) Quintile |   Income Deprivation Affecting Older People (IDAOPI) Rank |   Income Deprivation Affecting Older People (IDAOPI) Score (rate) |   Education, Skills and Training Decile |   Education, Skills and Training Quintile |   Education, Skills and Training Rank |   Education, Skills and Training Score |   Children and Young People Sub-domain Decile |   Children and Young People Sub-domain Quintile |   Children and Young People Sub-domain Rank |   Children and Young People Sub-domain Score |   Adult Skills Sub-domain Decile |   Adult Skills Sub-domain Quintile |   Adult Skills Sub-domain Rank |   Adult Skills Sub-domain Score |   Health Deprivation and Disability Decile |   Health Deprivation and Disability Quintile |   Health Deprivation and Disability Rank |   Health Deprivation and Disability Score |   Crime Decile |   Crime Quintile |   Crime Rank |   Crime Score |   Barriers to Housing and Services Decile |   Barriers to Housing and Services Quintile |   Barriers to Housing and Services Rank |   Barriers to Housing and Services Score |   Geographical Barriers Sub-domain Decile |   Geographical Barriers Sub-domain Quintile |   Geographical Barriers Sub-domain Rank |   Geographical Barriers Sub-domain Score |   Wider Barriers Sub-domain Decile |   Wider Barriers Sub-domain Quintile |   Wider Barriers Sub-domain Rank |   Wider Barriers Sub-domain Score |   Living Environment Decile |   Living Environment Quintile |   Living Environment Rank |   Living Environment Score |   Indoors Sub-domain Decile |   Indoors Sub-domain Quintile |   Indoors Sub-domain Rank |   Indoors Sub-domain Score |   Outdoors Sub-domain Decile |   Outdoors Sub-domain Quintile |   Outdoors Sub-domain Rank |   Outdoors Sub-domain Score |
|:-----------|:----------------------|:----------------------|-------------:|---------------:|-----------:|------------:|--------------------:|----------------------:|------------------:|--------------------------:|----------------:|------------------:|--------------:|----------------------:|-------------------------------------------------------------:|---------------------------------------------------------------:|-----------------------------------------------------------:|-------------------------------------------------------------------:|------------------------------------------------------------:|--------------------------------------------------------------:|----------------------------------------------------------:|------------------------------------------------------------------:|----------------------------------------:|------------------------------------------:|--------------------------------------:|---------------------------------------:|----------------------------------------------:|------------------------------------------------:|--------------------------------------------:|---------------------------------------------:|---------------------------------:|-----------------------------------:|-------------------------------:|--------------------------------:|-------------------------------------------:|---------------------------------------------:|-----------------------------------------:|------------------------------------------:|---------------:|-----------------:|-------------:|--------------:|------------------------------------------:|--------------------------------------------:|----------------------------------------:|-----------------------------------------:|------------------------------------------:|--------------------------------------------:|----------------------------------------:|-----------------------------------------:|-----------------------------------:|-------------------------------------:|---------------------------------:|----------------------------------:|----------------------------:|------------------------------:|--------------------------:|---------------------------:|----------------------------:|------------------------------:|--------------------------:|---------------------------:|-----------------------------:|-------------------------------:|---------------------------:|----------------------------:|
| E05001620  | Audley Ward           | Blackburn with Darwen |            1 |              1 |        217 |     47.739  |                   1 |                     1 |               282 |                  0.235362 |               1 |                 1 |           163 |              0.3237   |                                                            2 |                                                              1 |                                                       1306 |                                                           0.256794 |                                                           1 |                                                             1 |                                                         6 |                                                          0.604621 |                                       1 |                                         1 |                                   169 |                                55.5237 |                                             2 |                                               1 |                                        1284 |                                    0.568351  |                                1 |                                  1 |                             31 |                        0.559038 |                                          1 |                                            1 |                                      111 |                                  1.55198  |              2 |                1 |         1194 |     0.533825  |                                         9 |                                           5 |                                    6483 |                                 13.3903  |                                        10 |                                           5 |                                    7356 |                               -0.962024  |                                  3 |                                    2 |                             1558 |                         0.825983  |                           3 |                             2 |                      1735 |                    30.8716 |                           4 |                             2 |                      2464 |                   0.40463  |                            2 |                              1 |                        939 |                   0.615185  |
| E05001621  | Bastwell Ward         | Blackburn with Darwen |            1 |              1 |        408 |     41.5551 |                   1 |                     1 |               439 |                  0.215377 |               1 |                 1 |           316 |              0.287586 |                                                            3 |                                                              2 |                                                       1629 |                                                           0.23434  |                                                           1 |                                                             1 |                                                         9 |                                                          0.600068 |                                       1 |                                         1 |                                   168 |                                55.5407 |                                             3 |                                               2 |                                        2201 |                                    0.30947   |                                1 |                                  1 |                             13 |                        0.579747 |                                          1 |                                            1 |                                      298 |                                  1.21391  |              4 |                2 |         2443 |     0.113652  |                                         9 |                                           5 |                                    6401 |                                 13.6782  |                                        10 |                                           5 |                                    7499 |                               -1.14214   |                                  2 |                                    1 |                             1515 |                         0.872594  |                           2 |                             1 |                      1475 |                    33.3506 |                           3 |                             2 |                      1784 |                   0.640666 |                            2 |                              1 |                       1282 |                   0.441106  |
| E05001623  | Corporation Park Ward | Blackburn with Darwen |            2 |              1 |        939 |     33.2511 |                   2 |                     1 |              1176 |                  0.163727 |               2 |                 1 |          1100 |              0.207014 |                                                            5 |                                                              3 |                                                       3110 |                                                           0.154379 |                                                           1 |                                                             1 |                                                       406 |                                                          0.33626  |                                       3 |                                         2 |                                  1533 |                                30.6812 |                                             5 |                                               3 |                                        3153 |                                    0.0769007 |                                1 |                                  1 |                            608 |                        0.431238 |                                          1 |                                            1 |                                      738 |                                  0.865828 |              1 |                1 |          653 |     0.786561  |                                        10 |                                           5 |                                    7477 |                                  7.59831 |                                        10 |                                           5 |                                    7592 |                               -1.39795   |                                  5 |                                    3 |                             3540 |                        -0.679742  |                           1 |                             1 |                       514 |                    46.8394 |                           1 |                             1 |                       530 |                   1.30726  |                            3 |                              2 |                       1818 |                   0.223253  |
| E05001624  | Earcroft Ward         | Blackburn with Darwen |            1 |              1 |        551 |     38.6723 |                   1 |                     1 |               536 |                  0.206066 |               2 |                 1 |           918 |              0.220743 |                                                            2 |                                                              1 |                                                       1285 |                                                           0.258404 |                                                           2 |                                                             1 |                                                      1073 |                                                          0.25044  |                                       2 |                                         1 |                                  1512 |                                30.9289 |                                             3 |                                               2 |                                        2132 |                                    0.327638  |                                2 |                                  1 |                            936 |                        0.404419 |                                          1 |                                            1 |                                       65 |                                  1.73548  |              2 |                1 |          889 |     0.662541  |                                        10 |                                           5 |                                    7520 |                                  6.96593 |                                        10 |                                           5 |                                    7309 |                               -0.905581  |                                  6 |                                    3 |                             4132 |                        -1.0364    |                           2 |                             1 |                      1426 |                    33.901  |                           3 |                             2 |                      1627 |                   0.697062 |                            3 |                              2 |                       1616 |                   0.305013  |
| E05001626  | Ewood Ward            | Blackburn with Darwen |            1 |              1 |        346 |     43.1164 |                   1 |                     1 |               602 |                  0.200021 |               1 |                 1 |           574 |              0.253986 |                                                            1 |                                                              1 |                                                        538 |                                                           0.33293  |                                                           2 |                                                             1 |                                                      1228 |                                                          0.238459 |                                       1 |                                         1 |                                   738 |                                40.2304 |                                             1 |                                               1 |                                         642 |                                    0.832773  |                                2 |                                  1 |                            904 |                        0.406615 |                                          1 |                                            1 |                                      252 |                                  1.27255  |              1 |                1 |           68 |     1.3252    |                                        10 |                                           5 |                                    7071 |                                 10.8845  |                                         9 |                                           5 |                                    6830 |                               -0.585885  |                                  6 |                                    3 |                             4152 |                        -1.04544   |                           1 |                             1 |                       685 |                    43.4443 |                           2 |                             1 |                       901 |                   1.05725  |                            2 |                              1 |                       1278 |                   0.442794  |
| E05001628  | Higher Croft Ward     | Blackburn with Darwen |            1 |              1 |        497 |     39.5931 |                   1 |                     1 |               442 |                  0.214535 |               1 |                 1 |           479 |              0.264766 |                                                            1 |                                                              1 |                                                        596 |                                                           0.324959 |                                                           2 |                                                             1 |                                                       781 |                                                          0.2795   |                                       1 |                                         1 |                                   539 |                                44.0443 |                                             2 |                                               1 |                                         832 |                                    0.743025  |                                1 |                                  1 |                            574 |                        0.43405  |                                          1 |                                            1 |                                      133 |                                  1.50168  |              3 |                2 |         2221 |     0.177163  |                                         9 |                                           5 |                                    6729 |                                 12.502   |                                         8 |                                           4 |                                    5782 |                               -0.24597   |                                  6 |                                    3 |                             4095 |                        -1.01695   |                           8 |                             4 |                      4815 |                    13.1911 |                           8 |                             4 |                      5628 |                  -0.457769 |                            3 |                              2 |                       1715 |                   0.263379  |
| E05001629  | Little Harwood Ward   | Blackburn with Darwen |            2 |              1 |        994 |     32.5113 |                   2 |                     1 |              1136 |                  0.165218 |               2 |                 1 |           868 |              0.224778 |                                                            3 |                                                              2 |                                                       1618 |                                                           0.234891 |                                                           1 |                                                             1 |                                                       217 |                                                          0.388988 |                                       1 |                                         1 |                                   616 |                                42.4607 |                                             3 |                                               2 |                                        1721 |                                    0.43659   |                                1 |                                  1 |                            283 |                        0.475303 |                                          1 |                                            1 |                                      659 |                                  0.914666 |              5 |                3 |         3176 |    -0.0894681 |                                         9 |                                           5 |                                    6514 |                                 13.2947  |                                        10 |                                           5 |                                    7117 |                               -0.74301   |                                  4 |                                    2 |                             2515 |                        -0.0364058 |                           2 |                             1 |                      1216 |                    36.223  |                           2 |                             1 |                      1216 |                   0.883223 |                            3 |                              2 |                       1718 |                   0.262472  |
| E05001631  | Marsh House Ward      | Blackburn with Darwen |            4 |              2 |       2310 |     22.1403 |                   3 |                     2 |              1819 |                  0.137282 |               5 |                 3 |          3205 |              0.11687  |                                                            6 |                                                              3 |                                                       3853 |                                                           0.127269 |                                                           5 |                                                             3 |                                                      3395 |                                                          0.140807 |                                       4 |                                         2 |                                  2752 |                                21.1702 |                                             5 |                                               3 |                                        3301 |                                    0.0440163 |                                3 |                                  2 |                           2035 |                        0.345523 |                                          2 |                                            1 |                                     1054 |                                  0.68546  |              3 |                2 |         2078 |     0.230194  |                                         9 |                                           5 |                                    6735 |                                 12.4716  |                                         8 |                                           4 |                                    4596 |                                0.0118958 |                                  9 |                                    5 |                             6137 |                        -2.24472   |                           4 |                             2 |                      2926 |                    22.2297 |                           5 |                             3 |                      3373 |                   0.147521 |                            4 |                              2 |                       2412 |                   0.0269727 |
| E05001632  | Meadowhead Ward       | Blackburn with Darwen |            2 |              1 |        912 |     33.5158 |                   1 |                     1 |               664 |                  0.194232 |               2 |                 1 |           932 |              0.219213 |                                                            2 |                                                              1 |                                                        984 |                                                           0.283159 |                                                           2 |                                                             1 |                                                      1522 |                                                          0.218544 |                                       2 |                                         1 |                                  1277 |                                33.0506 |                                             3 |                                               2 |                                        2227 |                                    0.301586  |                                2 |                                  1 |                           1015 |                        0.398585 |                                          1 |                                            1 |                                      347 |                                  1.16692  |              3 |                2 |         1856 |     0.305265  |                                        10 |                                           5 |                                    7384 |                                  8.66447 |                                         8 |                                           4 |                                    5930 |                               -0.286413  |                                  8 |                                    4 |                             6036 |                        -2.16383   |                           5 |                             3 |                      3401 |                    19.4733 |                           5 |                             3 |                      3181 |                   0.199114 |                            4 |                              2 |                       2443 |                   0.0188583 |
| E05001633  | Mill Hill Ward        | Blackburn with Darwen |            1 |              1 |        163 |     50.2372 |                   1 |                     1 |               227 |                  0.245748 |               1 |                 1 |           308 |              0.289422 |                                                            1 |                                                              1 |                                                        419 |                                                           0.348961 |                                                           1 |                                                             1 |                                                       632 |                                                          0.299646 |                                       1 |                                         1 |                                   397 |                                48.2049 |                                             1 |                                               1 |                                         336 |                                    1.02015   |                                1 |                                  1 |                            541 |                        0.438296 |                                          1 |                                            1 |                                       64 |                                  1.73677  |              1 |                1 |          283 |     1.02351   |                                        10 |                                           5 |                                    7479 |                                  7.5677  |                                        10 |                                           5 |                                    7411 |                               -1.02055   |                                  5 |                                    3 |                             3593 |                        -0.713365  |                           1 |                             1 |                       423 |                    48.9401 |                           1 |                             1 |                       525 |                   1.31275  |                            2 |                              1 |                       1408 |                   0.395812  |


Table: LancsInsightLinks
| Area Type                     | Area Name                        | Link to profile                                                                                                                   |
|:------------------------------|:---------------------------------|:----------------------------------------------------------------------------------------------------------------------------------|
| Clinical Commissioning Groups | NHS West Lancashire CCG          | http://www.lancashire.gov.uk/lancashire-insight/area-profiles/clinical-commissioning-groups/nhs-west-lancashire-ccg.aspx          |
| Clinical Commissioning Groups | NHS Lancashire North CCG         | http://www.lancashire.gov.uk/lancashire-insight/area-profiles/clinical-commissioning-groups/nhs-lancashire-north-ccg.aspx         |
| Clinical Commissioning Groups | NHS Greater Preston CCG          | http://www.lancashire.gov.uk/lancashire-insight/area-profiles/clinical-commissioning-groups/nhs-greater-preston-ccg.aspx          |
| Clinical Commissioning Groups | NHS Fylde and Wyre CCG           | http://www.lancashire.gov.uk/lancashire-insight/area-profiles/clinical-commissioning-groups/nhs-fylde-and-wyre-ccg.aspx           |
| Clinical Commissioning Groups | NHS East Lancashire CCG          | http://www.lancashire.gov.uk/lancashire-insight/area-profiles/clinical-commissioning-groups/nhs-east-lancashire-ccg.aspx          |
| Clinical Commissioning Groups | NHS Chorley and South Ribble CCG | http://www.lancashire.gov.uk/lancashire-insight/area-profiles/clinical-commissioning-groups/nhs-chorley-and-south-ribble-ccg.aspx |
| Local Authority               | Burnley                          | http://www.lancashire.gov.uk/lancashire-insight/area-profiles/local-authority-profiles/burnley-district.aspx                      |
| Local Authority               | Chorley                          | http://www.lancashire.gov.uk/lancashire-insight/area-profiles/local-authority-profiles/chorley-district.aspx                      |
| Local Authority               | Fylde                            | http://www.lancashire.gov.uk/lancashire-insight/area-profiles/local-authority-profiles/fylde-district.aspx                        |
| Local Authority               | Hyndburn                         | http://www.lancashire.gov.uk/lancashire-insight/area-profiles/local-authority-profiles/hyndburn-district.aspx                     |


Table: LifeExpectancyWard
| Ward code   | Ward Name      |   Male LE at birth |   LCI |   UCI | Male Benchamrked with England   |   Female LE at birth |   LCI2 |   UCI3 | Female Benchamrked with England   |
|:------------|:---------------|-------------------:|------:|------:|:--------------------------------|---------------------:|-------:|-------:|:----------------------------------|
| E05001627   | Fernhurst      |                 80 |  77.8 |  83   | Similar to England              |                   81 |   78.4 |   84.1 | Similar to England                |
| E05001629   | Little Harwood |                 77 |  75.1 |  79.7 | Similar to England              |                   84 |   81   |   87.2 | Similar to England                |
| E05001631   | Marsh House    |                 78 |  75.9 |  80.5 | Similar to England              |                   84 |   82   |   86   | Similar to England                |
| E05001640   | Sunnyhurst     |                 80 |  77.4 |  82.6 | Similar to England              |                   82 |   79.6 |   84.5 | Similar to England                |
| E05001642   | Whitehall      |                 79 |  76.3 |  82.3 | Similar to England              |                   81 |   77.8 |   83.9 | Similar to England                |
| E05001649   | Greenlands     |                 78 |  75.6 |  80.1 | Similar to England              |                   82 |   80.2 |   84.2 | Similar to England                |
| E05001651   | Highfield      |                 78 |  76   |  79.8 | Similar to England              |                   82 |   80.1 |   83.5 | Similar to England                |
| E05001654   | Marton         |                 77 |  75.1 |  79.4 | Similar to England              |                   81 |   79.3 |   83   | Similar to England                |
| E05001655   | Norbreck       |                 78 |  74.6 |  81.2 | Similar to England              |                   81 |   78.3 |   83.6 | Similar to England                |
| E05001658   | Stanley        |                 78 |  76.1 |  80.1 | Similar to England              |                   83 |   81.1 |   85.2 | Similar to England                |


Table: MedianHousePriceQ32016Wards
| Local authority name   | Ward code   | Ward name              |   Q3-2016 |
|:-----------------------|:------------|:-----------------------|----------:|
| Blackburn with Darwen  | E05001620   | Audley                 |     67250 |
| Blackburn with Darwen  | E05001621   | Bastwell               |     74000 |
| Blackburn with Darwen  | E05001622   | Beardwood with Lammack |    172000 |
| Blackburn with Darwen  | E05001623   | Corporation Park       |     88000 |
| Blackburn with Darwen  | E05001624   | Earcroft               |     80000 |
| Blackburn with Darwen  | E05001625   | East Rural             |    145500 |
| Blackburn with Darwen  | E05001626   | Ewood                  |     73250 |
| Blackburn with Darwen  | E05001627   | Fernhurst              |    146250 |
| Blackburn with Darwen  | E05001628   | Higher Croft           |    102250 |
| Blackburn with Darwen  | E05001629   | Little Harwood         |     83000 |


Table: MetadataAllDashboard
| Indicator                                                                                                     | Dashboard                 | Description                                                                                                                                                                                                                                                                                                                                                                                                           | Geographies            | Date                                                 | Source                | Hyperlink                      |
|:--------------------------------------------------------------------------------------------------------------|:--------------------------|:----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:-----------------------|:-----------------------------------------------------|:----------------------|:-------------------------------|
| Crude rate of emergency hospital admissions for children (aged under 5 years), per 1,000 resident population. | Children and young people | Lancashire-14. Crude rate of emergency hospital admissions for children (aged under 5 years), per 1,000 resident population from 2012/13-2014/15 (financial years pooled).                                                                                                                                                                                                                                            | Ward, district and CCG | 2012/13-2014/15 (financial years pooled).            | Local Health          | http://www.localhealth.org.uk  |
| GCSE achievement (5 A*-C incl. Eng & Maths)                                                                   | Children and young people | Percentage of pupils at end of Key Stage 4, achieving 5 or more GCSEs at grades A*-C (including English and Maths) or equivalent, in schools maintained by the Local Authority, at the end of the academic year 2013/14.                                                                                                                                                                                              | Ward, district and CCG | 2013 - 2014                                          | Local Health          | http://www.localhealth.org.uk  |
| Year 6 Overweight or obese                                                                                    | Children and young people | Number of children in Year 6 (aged 10-11 years) classified as overweight or obese in the National Child Measurement Programme (NCMP) attending participating state maintained schools in England as a proportion of all children measured. Children are classified as overweight (including obese) if their BMI is on or above the 85th centile of the British 1990 growth reference (UK90) according to age and sex. | Ward, district and CCG | 2012/13-2014/15- Ward & CCG. 2015/16 - LA & England. | Local Health          | http://www.localhealth.org.uk  |
| Children in low income families (under 16s)                                                                   | Children and young people | Percentage of children in low income families (children living in families in receipt of out of work benefits or tax credits where their reported income is less than 60% median income) for under 16s only.                                                                                                                                                                                                          | District               | 2006 - 2014                                          | Public Health England | https://fingertips.phe.org.uk/ |
| Number of statutory EHC Plans in place (0 to 25 years)                                                        | Children and young people | Lancashire-12                                                                                                                                                                                                                                                                                                                                                                                                         |                        |                                                      |                       |                                |
| Number of pupils with Statement of SEN                                                                        | Children and young people | Lancashire-12                                                                                                                                                                                                                                                                                                                                                                                                         |                        |                                                      |                       |                                |
| Percentage of delivery episodes, where the mother is aged under 18 years.                                     | Children and young people | Teenage mothers: Percentage of delivery episodes, where the mother is aged under 18 years, 2010/11-2014/15.                                                                                                                                                                                                                                                                                                           | Ward, district and CCG | 2010/11-2014/15                                      | Local Health          | http://www.localhealth.org.uk  |
| Average Attainment 8 score at GCSE                                                                            | Children and young people | Lancashire-12                                                                                                                                                                                                                                                                                                                                                                                                         |                        |                                                      |                       |                                |
| Percentage of KS2 pupils reaching the expected standard in reading, writing and mathematics                   | Children and young people | Lancashire-12                                                                                                                                                                                                                                                                                                                                                                                                         | Ward and district      |                                                      |                       |                                |
| Percentage of KS4 pupils reaching the expected standard in reading, writing and mathematics                   | Children and young people | Lancashire-12                                                                                                                                                                                                                                                                                                                                                                                                         | Ward and district      |                                                      |                       |                                |


Table: MultipleSupportReasonsWard
| WDCD      | WDNM                          |   18+ population |   Rate per 1,000 population |
|:----------|:------------------------------|-----------------:|----------------------------:|
| E05001620 | Audley Ward                   |             6227 |                    0        |
| E05001622 | Beardwood with Lammack Ward   |             4619 |                    0        |
| E05001623 | Corporation Park Ward         |             5085 |                    0        |
| E05001624 | Earcroft Ward                 |             3344 |                    0        |
| E05001625 | East Rural Ward               |             1559 |                    0        |
| E05001626 | Ewood Ward                    |             5402 |                    0.185117 |
| E05001627 | Fernhurst Ward                |             4385 |                    0        |
| E05001628 | Higher Croft Ward             |             5569 |                    0        |
| E05001629 | Little Harwood Ward           |             5101 |                    0.19604  |
| E05001630 | Livesey with Pleasington Ward |             5336 |                    0.562219 |


Table: NationalLifeExpectancy
| Area code   | Area Name   |   Male LE at birth  |   Lower CI |   Upper CI |   Female LE at birth  |   Lower CI2 |   Upper CI3 |
|:------------|:------------|--------------------:|-----------:|-----------:|----------------------:|------------:|------------:|
| E92000001   | England     |             79.4587 |    79.4294 |    79.4881 |               83.1083 |     83.0807 |      83.136 |


Table: NI_URL_Links_Contents
| Neigbourhood Intelligence page   | Link                                                                                                                                                        |
|:---------------------------------|:------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Demographics                     | https://app.powerbi.com/view?r=eyJrIjoiZWVkMDRiYjYtMTRlNi00ZTFmLThmOWYtZjcwMjJmYzFlNjBhIiwidCI6IjlmNjgzZTI2LWQ4YjktNDYwOS05ZWM0LWUxYTM2ZTRiYjRkMiIsImMiOjh9 |
| Health and wellbeing             | https://app.powerbi.com/view?r=eyJrIjoiYzIyZjg1MGQtOGQxNy00YjQxLWE3ODQtYTVjYzc3NjM2NTA3IiwidCI6IjlmNjgzZTI2LWQ4YjktNDYwOS05ZWM0LWUxYTM2ZTRiYjRkMiIsImMiOjh9 |
| Children and young people        | https://app.powerbi.com/view?r=eyJrIjoiY2Y3MWFjNmUtMDg4Yi00Yjk1LTlhOWQtNGVmNDJjMzVjYWVkIiwidCI6IjlmNjgzZTI2LWQ4YjktNDYwOS05ZWM0LWUxYTM2ZTRiYjRkMiIsImMiOjh9 |
| Deprivation                      | https://app.powerbi.com/view?r=eyJrIjoiYWJmMDQ5ZmMtNGVjYy00OWEzLWFlNWUtYzYxMTMwZmM0OTNjIiwidCI6IjlmNjgzZTI2LWQ4YjktNDYwOS05ZWM0LWUxYTM2ZTRiYjRkMiIsImMiOjh9 |
| Community safety                 | https://app.powerbi.com/view?r=eyJrIjoiN2I2NWM1MmQtMTExMi00MTI1LWFmZDYtYjQxYTEwNWVlMWZlIiwidCI6IjlmNjgzZTI2LWQ4YjktNDYwOS05ZWM0LWUxYTM2ZTRiYjRkMiIsImMiOjh9 |
| Adult social care                | https://app.powerbi.com/view?r=eyJrIjoiOTY4ZDNjYzQtMDE3ZS00MGVjLWFiZjAtYzU3OWFiY2MxZDlmIiwidCI6IjlmNjgzZTI2LWQ4YjktNDYwOS05ZWM0LWUxYTM2ZTRiYjRkMiIsImMiOjh9 |
| Mortality                        | https://app.powerbi.com/view?r=eyJrIjoiOGVmZTg2NjktNDdkYy00Yjc2LThhNjctMTRiM2JjYmQwYWQ1IiwidCI6IjlmNjgzZTI2LWQ4YjktNDYwOS05ZWM0LWUxYTM2ZTRiYjRkMiIsImMiOjh9 |
| Lifestyle                        | https://app.powerbi.com/view?r=eyJrIjoiMzAxYjBhMjAtNmI0OC00M2U0LTk2MGEtMWViMjRjZTQ1NGY4IiwidCI6IjlmNjgzZTI2LWQ4YjktNDYwOS05ZWM0LWUxYTM2ZTRiYjRkMiIsImMiOjh9 |
| Economic                         | https://app.powerbi.com/view?r=eyJrIjoiZTA1NWZiOTAtMzc0ZC00NmNlLWFiOTQtMzk2YWUyY2VjMjI5IiwidCI6IjlmNjgzZTI2LWQ4YjktNDYwOS05ZWM0LWUxYTM2ZTRiYjRkMiIsImMiOjh9 |
| Housing                          | https://app.powerbi.com/view?r=eyJrIjoiZWUzYTJiYWEtOGI3NC00NDk1LTk2ZWQtNjVlZDI0NGY0NWJkIiwidCI6IjlmNjgzZTI2LWQ4YjktNDYwOS05ZWM0LWUxYTM2ZTRiYjRkMiIsImMiOjh9 |


Table: NoOfSUsWard
| WDCD      | WDNM                          |   Total |   18+ population |   Rate per 1,000 adult population |
|:----------|:------------------------------|--------:|-----------------:|----------------------------------:|
| E05001620 | Audley Ward                   |       0 |             6227 |                          0.481773 |
| E05001622 | Beardwood with Lammack Ward   |       0 |             4619 |                          0.216497 |
| E05001623 | Corporation Park Ward         |      19 |             5085 |                          3.73648  |
| E05001624 | Earcroft Ward                 |      11 |             3344 |                          3.28947  |
| E05001625 | East Rural Ward               |       0 |             1559 |                          1.92431  |
| E05001626 | Ewood Ward                    |       0 |             5402 |                          0.185117 |
| E05001627 | Fernhurst Ward                |       0 |             4385 |                          0.22805  |
| E05001628 | Higher Croft Ward             |       0 |             5569 |                          0.538696 |
| E05001629 | Little Harwood Ward           |       5 |             5101 |                          0.9802   |
| E05001630 | Livesey with Pleasington Ward |       5 |             5336 |                          0.937031 |


Table: ObeseAdultsCountry
| Area Code   | Area Name   |   Numerator |   Denominator |   Indicator Value |   LCI |   UCI |
|:------------|:------------|------------:|--------------:|------------------:|------:|------:|
| E92000001   | England     |     9983436 |      41422025 |              24.2 |  23.6 |  24.7 |


Table: ObeseAdultsWard
| Area Code   | Area Code (old)   | Area Name              |   Numerator |   Denominator |   Indicator Value |   LCI |   UCI |
|:------------|:------------------|:-----------------------|------------:|--------------:|------------------:|------:|------:|
| E05001620   | 00EXMZ            | Audley                 |      1469.2 |        5920.9 |              24.8 |  18.5 |  32.5 |
| E05001621   | 00EXNA            | Bastwell               |      1223.3 |        5076.7 |              24.1 |  17.6 |  32   |
| E05001622   | 00EXNB            | Beardwood with Lammack |       922.4 |        4540.4 |              20.3 |  14.1 |  28.4 |
| E05001623   | 00EXNC            | Corporation Park       |      1065.9 |        4981.2 |              21.4 |  15.2 |  29.2 |
| E05001624   | 00EXND            | Earcroft               |       853.7 |        3473.6 |              24.6 |  16.8 |  34.5 |
| E05001625   | 00EXNE            | East Rural             |       343.9 |        1626.7 |              21.1 |  12.1 |  34.1 |
| E05001626   | 00EXNF            | Ewood                  |      1293   |        4980.3 |              26   |  18.5 |  35   |
| E05001627   | 00EXNG            | Fernhurst              |      1084.5 |        4387.1 |              24.7 |  17.6 |  33.6 |
| E05001628   | 00EXNH            | Higher Croft           |      1457.3 |        5591.8 |              26.1 |  18.8 |  34.8 |
| E05001629   | 00EXNJ            | Little Harwood         |      1080.6 |        4633.1 |              23.3 |  16.3 |  32.2 |


Table: Ward2015
| Ward name                   | Ward code   | DISTRICT              |   Longitude |   Latitude |   2015 MYE Pop |   Pop/Thous | D&WN                                              | Ward                                  | Name                   | WdCom                                 | WdDis                                        |
|:----------------------------|:------------|:----------------------|------------:|-----------:|---------------:|------------:|:--------------------------------------------------|:--------------------------------------|:-----------------------|:--------------------------------------|:---------------------------------------------|
| Audley Ward                 | E05001620   | Blackburn with Darwen |    -2.46344 |    53.7488 |           9036 |       9.036 | Audley Ward Blackburn with Darwen                 | Audley Ward E05001620                 | Audley                 | E05001620 Audley Ward                 | Audley Blackburn with Darwen                 |
| Bastwell Ward               | E05001621   | Blackburn with Darwen |    -2.47449 |    53.758  |           7619 |       7.619 | Bastwell Ward Blackburn with Darwen               | Bastwell Ward E05001621               | Bastwell               | E05001621 Bastwell Ward               | Bastwell Blackburn with Darwen               |
| Beardwood with Lammack Ward | E05001622   | Blackburn with Darwen |    -2.51145 |    53.7548 |           6087 |       6.087 | Beardwood with Lammack Ward Blackburn with Darwen | Beardwood with Lammack Ward E05001622 | Beardwood with Lammack | E05001622 Beardwood with Lammack Ward | Beardwood with Lammack Blackburn with Darwen |
| Corporation Park Ward       | E05001623   | Blackburn with Darwen |    -2.49986 |    53.753  |           7371 |       7.371 | Corporation Park Ward Blackburn with Darwen       | Corporation Park Ward E05001623       | Corporation Park       | E05001623 Corporation Park Ward       | Corporation Park Blackburn with Darwen       |
| Earcroft Ward               | E05001624   | Blackburn with Darwen |    -2.48329 |    53.7099 |           4224 |       4.224 | Earcroft Ward Blackburn with Darwen               | Earcroft Ward E05001624               | Earcroft               | E05001624 Earcroft Ward               | Earcroft Blackburn with Darwen               |
| East Rural Ward             | E05001625   | Blackburn with Darwen |    -2.43245 |    53.7033 |           1874 |       1.874 | East Rural Ward Blackburn with Darwen             | East Rural Ward E05001625             | East Rural             | E05001625 East Rural Ward             | East Rural Blackburn with Darwen             |
| Ewood Ward                  | E05001626   | Blackburn with Darwen |    -2.49084 |    53.7308 |           7193 |       7.193 | Ewood Ward Blackburn with Darwen                  | Ewood Ward E05001626                  | Ewood                  | E05001626 Ewood Ward                  | Ewood Blackburn with Darwen                  |
| Fernhurst Ward              | E05001627   | Blackburn with Darwen |    -2.48494 |    53.7198 |           5940 |       5.94  | Fernhurst Ward Blackburn with Darwen              | Fernhurst Ward E05001627              | Fernhurst              | E05001627 Fernhurst Ward              | Fernhurst Blackburn with Darwen              |
| Higher Croft Ward           | E05001628   | Blackburn with Darwen |    -2.46995 |    53.7272 |           7642 |       7.642 | Higher Croft Ward Blackburn with Darwen           | Higher Croft Ward E05001628           | Higher Croft           | E05001628 Higher Croft Ward           | Higher Croft Blackburn with Darwen           |
| Little Harwood Ward         | E05001629   | Blackburn with Darwen |    -2.4601  |    53.7641 |           7449 |       7.449 | Little Harwood Ward Blackburn with Darwen         | Little Harwood Ward E05001629         | Little Harwood         | E05001629 Little Harwood Ward         | Little Harwood Blackburn with Darwen         |


Table: WardDomGroup
| WardCd    | WardNm                      | Type                       | Group                  |
|:----------|:----------------------------|:---------------------------|:-----------------------|
| E05001620 | Audley Ward                 | I38 - Asian Heritage       | I - Urban Cohesion     |
| E05001621 | Bastwell Ward               | I38 - Asian Heritage       | I - Urban Cohesion     |
| E05001622 | Beardwood with Lammack Ward | B06 - Bank of Mum and Dad  | B - Prestige Positions |
| E05001623 | Corporation Park Ward       | I38 - Asian Heritage       | I - Urban Cohesion     |
| E05001624 | Earcroft Ward               | L51 - Make Do & Move On    | L - Transient Renters  |
| E05001625 | East Rural Ward             | F25 - Classic Grandparents | E - Suburban Stability |
| E05001626 | Ewood Ward                  | L50 - Renting a Room       | L - Transient Renters  |
| E05001627 | Fernhurst Ward              | D15 - Modern Parents       | D - Domestic Success   |
| E05001628 | Higher Croft Ward           | M55 - Families with Needs  | M - Family Basics      |
| E05001629 | Little Harwood Ward         | I38 - Asian Heritage       | I - Urban Cohesion     |


Table: WardPopulationData
| WardCode   | WardName               | AgeGroup   | Gender   |   Qty |
|:-----------|:-----------------------|:-----------|:---------|------:|
| E05001620  | Audley                 | 0 to 4     | males    |   381 |
| E05001621  | Bastwell               | 0 to 4     | males    |   353 |
| E05001622  | Beardwood with Lammack | 0 to 4     | males    |   213 |
| E05001623  | Corporation Park       | 0 to 4     | males    |   378 |
| E05001624  | Earcroft               | 0 to 4     | males    |   128 |
| E05001625  | East Rural             | 0 to 4     | males    |    32 |
| E05001626  | Ewood                  | 0 to 4     | males    |   292 |
| E05001627  | Fernhurst              | 0 to 4     | males    |   215 |
| E05001628  | Higher Croft           | 0 to 4     | males    |   286 |
| E05001629  | Little Harwood         | 0 to 4     | males    |   358 |


Table: Ward_Story
| Ward_code   | Deprivation                                                 | Mosaic                                                                                                                                                                           | Female_LE                                     | Male_LE                                     | Health 1                                                                                                                                | Health 2                                                                                                        | House prices and deprivation domains                                                                                                                                                                    | CS Sentence                                                                                                                           |
|:------------|:------------------------------------------------------------|:---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:----------------------------------------------|:--------------------------------------------|:----------------------------------------------------------------------------------------------------------------------------------------|:----------------------------------------------------------------------------------------------------------------|:--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:--------------------------------------------------------------------------------------------------------------------------------------|
| E05005274   | This ward is ranked in the 20% most deprived in Lancashire. | The dominant Mosaic group is I - Urban Cohesion, which makes up 61% of households. It's described as residents of settled urban communities with a strong sense of identity.     | Female life expectancy is similar to England. | Male life expectancy is similar to England. | Most health, wellbeing and wider-determinant indicators and outcomes are better than the wards deprivation ranking.                     | Deaths from cancer is relatively good and the number of lont term limiting health conditions is relatively low. | House prices are relatively low average in this ward, whilst the outdoor living environment is poor, indoor standards are relatively poor and access to services is good.                               | This ward is above average, but not in the worst quintile in the county for community safety related issues, April 2016 to March 2017 |
| E05005271   | This ward is ranked in the 20% most deprived in Lancashire. | The dominant Mosaic group is M - Family Basics, which makes up 31% of households. It's described as families with limited resources who have to budget to make ends meet .       | Female life expectancy is similar to England. | Male life expectancy is similar to England. | Most health, wellbeing and wider-determinant indicators and outcomes are better than the wards deprivation ranking.                     | Deaths from circulatory disease is relatively good.                                                             | House prices are relatively low average in this ward, whilst the outdoor living environment is poor, indoor standards are relatively good  and access to services is relatively good.                   | This ward is above average, but not in the worst quintile in the county for community safety related issues, April 2016 to March 2017 |
| E05005215   | This ward is ranked in the 20% most deprived in Lancashire. | The dominant Mosaic group is L - Transient Renters, which makes up 28% of households. It's described as single people privately renting low cost homes for the short term .      | Female life expectancy is similar to England. | Male life expectancy is similar to England. | Most health, wellbeing and wider-determinant indicators and outcomes are better than the wards deprivation ranking.                     | Babies birth weights are fairly good.                                                                           | House prices are low in this ward, whilst the outdoor living environment is poor, indoor standards are poor and access to services is good.                                                             | This ward is above average, but not in the worst quintile in the county for community safety related issues, April 2016 to March 2017 |
| E05005267   | This ward is ranked in the 40% most deprived.               | The dominant Mosaic group is I - Urban Cohesion, which makes up 32% of households. It's described as residents of settled urban communities with a strong sense of identity.     | Female life expectancy is similar to England. | Male life expectancy is similar to England. | Some health, wellbeing and wider-determinant indicators and outcomes are better than the wards deprivation ranking.                     | This ward has a high percentage of BME residents and a low number of adults who binge drink.                    | House prices are low in this ward, whilst the outdoor living environment is poor, indoor standards are poor and access to services is good.                                                             | This ward is above average, but not in the worst quintile in the county for community safety related issues, April 2016 to March 2017 |
| E05005325   | This ward is ranked in the 40% most deprived.               | The dominant Mosaic group is L - Transient Renters, which makes up 16% of households. It's described as single people privately renting low cost homes for the short term .      | Female life expectancy is similar to England. | Male life expectancy is similar to England. | Most health, wellbeing and wider-determinant indicators and outcomes are poor and worsethan the wards deprivation ranking.              | With the exception of respiratory disease deaths are more in line with the county average.                      | House prices are average in this ward, whilst the outdoor living environment is average, indoor standards are average for the county  and access to services is fairly poor.                            | This ward is above average, but not in the worst quintile in the county for community safety related issues, April 2016 to March 2017 |
| E05009612   | This ward is ranked in the 40% most deprived.               | The dominant Mosaic group is L - Transient Renters, which makes up 22% of households. It's described as single people privately renting low cost homes for the short term .      | Female life expectancy is similar to England. | Male life expectancy is similar to England. | Most health, wellbeing and wider-determinant indicators and outcomes are fairly poor and in-line with the wards deprivation ranking.    | Long term limiting health conditions are relatively low.                                                        | House prices are relatively low average in this ward, whilst the outdoor living environment is relatively poor, indoor standards are poor and access to services is relatively good.                    | This ward is in the worst 20% in the county for community safety related issues, April 2016 to March 2017                             |
| E05001629   | This ward is ranked in the 40% most deprived.               | The dominant Mosaic group is I - Urban Cohesion, which makes up 40% of households. It's described as residents of settled urban communities with a strong sense of identity.     | Female life expectancy is similar to England. | Male life expectancy is similar to England. | Some health, wellbeing and wider-determinant indicators and outcomes are fairly good and and better than the wards deprivation ranking. | This ward has a high percentage of BME residents and a low number of adults who binge drink.                    | House prices are low in this ward, whilst the outdoor living environment is relatively poor, indoor standards are relatively poor and access to services is good.                                       | This ward is above average, but not in the worst quintile in the county for community safety related issues, April 2016 to March 2017 |
| E05005159   | This ward is ranked in the 40% most deprived.               | The dominant Mosaic group is L - Transient Renters, which makes up 17% of households. It's described as single people privately renting low cost homes for the short term .      | Female life expectancy is similar to England. | Male life expectancy is similar to England. | Most health, wellbeing and wider-determinant indicators and outcomes are fairly poor and in-line with the wards deprivation ranking.    | Deaths from circulatory disease is good.                                                                        | House prices are low in this ward, whilst the outdoor living environment is relatively poor, indoor standards are relatively good  and access to services is average.                                   | This ward is above average, but not in the worst quintile in the county for community safety related issues, April 2016 to March 2017 |
| E05005266   | This ward is ranked in the 40% most deprived.               | The dominant Mosaic group is M - Family Basics, which makes up 26% of households. It's described as families with limited resources who have to budget to make ends meet .       | Female life expectancy is similar to England. | Male life expectancy is similar to England. | Most health, wellbeing and wider-determinant indicators and outcomes are fairly poor and in-line with the wards deprivation ranking.    | Emergency hospital admissions for children are good and binge drinking in adults is low.                        | House prices are relatively low average in this ward, whilst the outdoor living environment is average, indoor standards are relatively poor and access to services is relatively good.                 | This ward is average in the county for community safety related issues, April 2016 to March 2018                                      |
| E05001651   | This ward is ranked in the 40% most deprived.               | The dominant Mosaic group is H - Aspiring Homemakers, which makes up 19% of households. It's described as younger households settling down in housing priced within their means. | Female life expectancy is similar to England. | Male life expectancy is similar to England. | Most health, wellbeing and wider-determinant indicators and outcomes are fairly poor and in-line with the wards deprivation ranking.    | Deaths from circulatory disease is fairly good.                                                                 | House prices are relatively low average in this ward, whilst the outdoor living environment is relatively poor, indoor standards are average for the county  and access to services is relatively good. | This ward is average in the county for community safety related issues, April 2016 to March 2018                                      |


Table: Year6OverweightObeseEnglandTable4
| Area Code   | Area Code (old)   | Area Name   |   Numerator |   Denominator |   National % |     LCI |     UCI |
|:------------|:------------------|:------------|------------:|--------------:|-------------:|--------:|--------:|
| E92000001   |                   | England     |      186074 |        544615 |      34.1662 | 34.0403 | 34.2922 |


Table: Year6OverweightObeseWard
| ward Code   | Ward Name                   | DISTRICT              | WDNM15                      |   Numerator |   Denominator |   Local % |   LCI |   UCI |
|:------------|:----------------------------|:----------------------|:----------------------------|------------:|--------------:|----------:|------:|------:|
| E05001620   | Audley Ward                 | Blackburn with Darwen | Audley Ward                 |       145.8 |         467.2 |      31.2 |  27.2 |  35.6 |
| E05001621   | Bastwell Ward               | Blackburn with Darwen | Bastwell Ward               |       144.7 |         404.8 |      35.8 |  31.2 |  40.5 |
| E05001622   | Beardwood with Lammack Ward | Blackburn with Darwen | Beardwood with Lammack Ward |        54.5 |         199.2 |      27.4 |  21.7 |  33.9 |
| E05001623   | Corporation Park Ward       | Blackburn with Darwen | Corporation Park Ward       |        93.2 |         318.2 |      29.3 |  24.6 |  34.5 |
| E05001624   | Earcroft Ward               | Blackburn with Darwen | Earcroft Ward               |        36.1 |         120.2 |      30   |  22.6 |  38.8 |
| E05001625   | East Rural Ward             | Blackburn with Darwen | East Rural Ward             |         9.5 |          45   |      21.2 |  11.8 |  35.2 |
| E05001626   | Ewood Ward                  | Blackburn with Darwen | Ewood Ward                  |        84.2 |         248.8 |      33.9 |  28.3 |  39.9 |
| E05001627   | Fernhurst Ward              | Blackburn with Darwen | Fernhurst Ward              |        74.2 |         236.8 |      31.4 |  25.8 |  37.5 |
| E05001628   | Higher Croft Ward           | Blackburn with Darwen | Higher Croft Ward           |        98.6 |         291.2 |      33.9 |  28.7 |  39.5 |
| E05001629   | Little Harwood Ward         | Blackburn with Darwen | Little Harwood Ward         |       119.7 |         319   |      37.5 |  32.4 |  42.9 |

 


tables: name: ASBWard
data: ASBWard.csv
name: CCGLSOA
data: CCGLSOA.csv
name: ClaimantCountNationalMarch17
data: ClaimantCountNationalMarch17.csv
name: ClaimantCountWardMarch17
data: ClaimantCountWardMarch17.csv
name: CountytoDistrictHierarchy
data: CountytoDistrictHierarchy.csv
name: DeathsUnder75England
data: DeathsUnder75England.csv
name: DeathsUnder75Ward
data: DeathsUnder75Ward.csv
name: District2015Pop
data: District2015Pop.csv
name: DistrictStory
data: DistrictStory.csv
name: England
data: England.csv
name: EnglandPopulationData
data: EnglandPopulationData.csv
name: GCSEsEngland
data: GCSEsEngland.csv
name: GCSEsWard
data: GCSEsWard.csv
name: GeneralHealthBadorVBadNational
data: GeneralHealthBadorVBadNational.csv
name: GeneralHealthBadorVBadWards
data: GeneralHealthBadorVBadWards.csv
name: HealthyEatingAdultsCountry
data: HealthyEatingAdultsCountry.csv
name: HealthyEatingAdultsWard
data: HealthyEatingAdultsWard.csv
name: IMD Ward(Calc)
data: IMD Ward(Calc).csv
name: LancsInsightLinks
data: LancsInsightLinks.csv
name: LifeExpectancyWard
data: LifeExpectancyWard.csv
name: MedianHousePriceQ32016Wards
data: MedianHousePriceQ32016Wards.csv
name: MetadataAllDashboard
data: MetadataAllDashboard.csv
name: MultipleSupportReasonsWard
data: MultipleSupportReasonsWard.csv
name: NationalLifeExpectancy
data: NationalLifeExpectancy.csv
name: NI_URL_Links_Contents
data: NI_URL_Links_Contents.csv
name: NoOfSUsWard
data: NoOfSUsWard.csv
name: ObeseAdultsCountry
data: ObeseAdultsCountry.csv
name: ObeseAdultsWard
data: ObeseAdultsWard.csv
name: Ward2015
data: Ward2015.csv
name: WardDomGroup
data: WardDomGroup.csv
name: WardPopulationData
data: WardPopulationData.csv
name: Ward_Story
data: Ward_Story.csv
name: Year6OverweightObeseEnglandTable4
data: Year6OverweightObeseEnglandTable4.csv
name: Year6OverweightObeseWard
data: Year6OverweightObeseWard.csv
label: Ward2015
Ward code
LifeExpectancyWard
Ward code
WardPopulationData
WardCode
Ward2015
Ward code
Ward2015
Ward code
ObeseAdultsWard
Area Code
Ward2015
Ward code
GeneralHealthBadorVBadWards
ward Code
Ward2015
Ward code
Year6OverweightObeseWard
ward Code
Ward2015
Ward code
HealthyEatingAdultsWard
Area Code
Ward2015
Ward code
ClaimantCountWardMarch17
Area code
Ward2015
Ward code
GCSEsWard
Area Code
DeathsUnder75Ward
ward Code
Ward2015
Ward code
Ward2015
Ward code
ASBWard
WardCode
MedianHousePriceQ32016Wards
Ward code
Ward2015
Ward code
WardDomGroup
WardCd
Ward2015
Ward code
NationalLifeExpectancy
Area code
England
National code
EnglandPopulationData
Area Code
England
National code
GeneralHealthBadorVBadNational
Area Code
England
National code
ObeseAdultsCountry
Area Code
England
National code
Year6OverweightObeseEnglandTable4
Area Code
England
National code
HealthyEatingAdultsCountry
Area Code
England
National code
ClaimantCountNationalMarch17
Area name
England
National name
GCSEsEngland
Area Code
England
National code
DeathsUnder75England
Area Code
England
National code
IMD Ward(Calc)
WardCode
Ward2015
Ward code
NoOfSUsWard
WDCD
Ward2015
Ward code
Ward2015
Ward code
MultipleSupportReasonsWard
WDCD
Ward_Story
Ward_code
Ward2015
Ward code
Ward2015
DISTRICT
District2015Pop
District Name
LancsInsightLinks
Area Name
District2015Pop
District Name
DistrictStory
District
District2015Pop
District Name
output: {
    "joins": [
        {
            "from_table": "Ward2015",
            "from_column": "Ward code",
            "to_table": "LifeExpectancyWard",
            "to_column": "Ward code"
        },
        {
            "from_table": "WardPopulationData",
            "from_column": "WardCode",
            "to_table": "Ward2015",
            "to_column": "Ward code"
        },
        {
            "from_table": "Ward2015",
            "from_column": "Ward code",
            "to_table": "ObeseAdultsWard",
            "to_column": "Area Code"
        },
        {
            "from_table": "Ward2015",
            "from_column": "Ward code",
            "to_table": "GeneralHealthBadorVBadWards",
            "to_column": "ward Code"
        },
        {
            "from_table": "Ward2015",
            "from_column": "Ward code",
            "to_table": "Year6OverweightObeseWard",
            "to_column": "ward Code"
        },
        {
            "from_table": "Ward2015",
            "from_column": "Ward code",
            "to_table": "HealthyEatingAdultsWard",
            "to_column": "Area Code"
        },
        {
            "from_table": "Ward2015",
            "from_column": "Ward code",
            "to_table": "ClaimantCountWardMarch17",
            "to_column": "Area code"
        },
        {
            "from_table": "Ward2015",
            "from_column": "Ward code",
            "to_table": "GCSEsWard",
            "to_column": "Area Code"
        },
        {
            "from_table": "DeathsUnder75Ward",
            "from_column": "ward Code",
            "to_table": "Ward2015",
            "to_column": "Ward code"
        },
        {
            "from_table": "Ward2015",
            "from_column": "Ward code",
            "to_table": "ASBWard",
            "to_column": "WardCode"
        },
        {
            "from_table": "MedianHousePriceQ32016Wards",
            "from_column": "Ward code",
            "to_table": "Ward2015",
            "to_column": "Ward code"
        },
        {
            "from_table": "WardDomGroup",
            "from_column": "WardCd",
            "to_table": "Ward2015",
            "to_column": "Ward code"
        },
        {
            "from_table": "NationalLifeExpectancy",
            "from_column": "Area code",
            "to_table": "England",
            "to_column": "National code"
        },
        {
            "from_table": "EnglandPopulationData",
            "from_column": "Area Code",
            "to_table": "England",
            "to_column": "National code"
        },
        {
            "from_table": "GeneralHealthBadorVBadNational",
            "from_column": "Area Code",
            "to_table": "England",
            "to_column": "National code"
        },
        {
            "from_table": "ObeseAdultsCountry",
            "from_column": "Area Code",
            "to_table": "England",
            "to_column": "National code"
        },
        {
            "from_table": "Year6OverweightObeseEnglandTable4",
            "from_column": "Area Code",
            "to_table": "England",
            "to_column": "National code"
        },
        {
            "from_table": "HealthyEatingAdultsCountry",
            "from_column": "Area Code",
            "to_table": "England",
            "to_column": "National code"
        },
        {
            "from_table": "ClaimantCountNationalMarch17",
            "from_column": "Area name",
            "to_table": "England",
            "to_column": "National name"
        },
        {
            "from_table": "GCSEsEngland",
            "from_column": "Area Code",
            "to_table": "England",
            "to_column": "National code"
        },
        {
            "from_table": "DeathsUnder75England",
            "from_column": "Area Code",
            "to_table": "England",
            "to_column": "National code"
        },
        {
            "from_table": "IMD Ward(Calc)",
            "from_column": "WardCode",
            "to_table": "Ward2015",
            "to_column": "Ward code"
        },
        {
            "from_table": "NoOfSUsWard",
            "from_column": "WDCD",
            "to_table": "Ward2015",
            "to_column": "Ward code"
        },
        {
            "from_table": "Ward2015",
            "from_column": "Ward code",
            "to_table": "MultipleSupportReasonsWard",
            "to_column": "WDCD"
        },
        {
            "from_table": "Ward_Story",
            "from_column": "Ward_code",
            "to_table": "Ward2015",
            "to_column": "Ward code"
        },
        {
            "from_table": "Ward2015",
            "from_column": "DISTRICT",
            "to_table": "District2015Pop",
            "to_column": "District Name"
        },
        {
            "from_table": "LancsInsightLinks",
            "from_column": "Area Name",
            "to_table": "District2015Pop",
            "to_column": "District Name"
        },
        {
            "from_table": "DistrictStory",
            "from_column": "District",
            "to_table": "District2015Pop",
            "to_column": "District Name"
        }
    ]
}