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: 2016Census_G10A_VIC_SSC
| Suburb       | Country   |      Year |   Attribute.2 | Attribute.3   | Attribute.4   | Attribute.5   |   Value | Attribute - Copy   |      Sort |
|:-------------|:----------|----------:|--------------:|:--------------|:--------------|:--------------|--------:|:-------------------|----------:|
| Beaconsfield | Canada    | 2006_2016 |          2016 |               |               |               |       0 | Canada_2016        | 2006_2016 |
| Beaconsfield | Croatia   | 2006_2016 |          2016 |               |               |               |       0 | Croatia_2016       | 2006_2016 |
| Beaconsfield | Egypt     | 2006_2016 |          2016 |               |               |               |       0 | Egypt_2016         | 2006_2016 |
| Beaconsfield | Fiji      | 2006_2016 |          2016 |               |               |               |       0 | Fiji_2016          | 2006_2016 |
| Beaconsfield | Germany   | 2006_2016 |          2016 |               |               |               |       0 | Germany_2016       | 2006_2016 |
| Beaconsfield | Greece    | 2006_2016 |          2016 |               |               |               |       0 | Greece_2016        | 2006_2016 |
| Beaconsfield | India     | 2006_2016 |          2016 |               |               |               |       0 | India_2016         | 2006_2016 |
| Beaconsfield | Indonesia | 2006_2016 |          2016 |               |               |               |       0 | Indonesia_2016     | 2006_2016 |
| Beaconsfield | Iran      | 2006_2016 |          2016 |               |               |               |       0 | Iran_2016          | 2006_2016 |
| Beaconsfield | Iraq      | 2006_2016 |          2016 |               |               |               |       0 | Iraq_2016          | 2006_2016 |


Table: 2Education
| Suburb       | AQF Level          |   Value |
|:-------------|:-------------------|--------:|
| Beaconsfield | Level 9 or 10      |      15 |
| Beaconsfield | Level 8            |      10 |
| Beaconsfield | Level 7            |      30 |
| Beaconsfield | Level 6            |      28 |
| Beaconsfield | Level 3 or 4       |      92 |
| Beaconsfield | Years 10 and above |     142 |
| Beaconsfield | Level 1 or 2       |       0 |
| Beaconsfield | Years 9 and below  |      31 |
| Berwick      | Level 9 or 10      |    1667 |
| Berwick      | Level 8            |     801 |


Table: 2Employed
| Suburb       | Attribute      |   Value |
|:-------------|:---------------|--------:|
| Beaconsfield | Work Full Time |     219 |
| Beaconsfield | Work Part Time |      61 |
| Beaconsfield | Work Unkown    |       8 |
| Beaconsfield | Is Not Working |      84 |
| Berwick      | Work Full Time |   19057 |
| Berwick      | Work Part Time |    6005 |
| Berwick      | Work Unkown    |     937 |
| Berwick      | Is Not Working |    9331 |
| Blind Bight  | Work Full Time |     489 |
| Blind Bight  | Work Part Time |     179 |


Table: 2Industry
| Suburb       | Attribute                                  |   Value |
|:-------------|:-------------------------------------------|--------:|
| Beaconsfield | Agriculture, Forestry and Fishing          |       0 |
| Beaconsfield | Mining                                     |       0 |
| Beaconsfield | Manufacturing                              |      25 |
| Beaconsfield | Electricity, Gas, Water and Waste Services |       3 |
| Beaconsfield | Construction                               |      40 |
| Beaconsfield | Wholesale Trade                            |       8 |
| Beaconsfield | Retail Trade                               |      24 |
| Beaconsfield | Accommodation and Food Services            |      21 |
| Beaconsfield | Transport, Postal and Warehousing          |      11 |
| Beaconsfield | Information Media and Telecommunications   |       6 |


Table: 2Place of Work Agg
| Suburb           |   Percent who work in Casey |
|:-----------------|----------------------------:|
| Berwick          |                    0.352104 |
| Blind Bight      |                    0.359932 |
| Botanic Ridge    |                    0.292135 |
| Cannons Creek    |                    0.305455 |
| Clyde North      |                    0.26802  |
| Cranbourne       |                    0.313508 |
| Cranbourne East  |                    0.285547 |
| Cranbourne North |                    0.300305 |
| Cranbourne South |                    0.437086 |
| Cranbourne West  |                    0.222303 |


Table: 2Place of Work
| Suburb   | LGA        |   Value |
|:---------|:-----------|--------:|
| Warneet  | Alpine     |       0 |
| Warneet  | Ararat     |       0 |
| Warneet  | Ballarat   |       0 |
| Warneet  | Banyule    |       0 |
| Warneet  | Bass Coast |       0 |
| Warneet  | Baw Baw    |       0 |
| Warneet  | Bayside    |       0 |
| Warneet  | Benalla    |       0 |
| Warneet  | Boroondara |       0 |
| Warneet  | Buloke     |       0 |


Table: 2Position
| Suburb       | Attribute                              |   Value |
|:-------------|:---------------------------------------|--------:|
| Beaconsfield | Managers                               |      27 |
| Beaconsfield | Professionals                          |      49 |
| Beaconsfield | Technicians and Trades Workers         |      45 |
| Beaconsfield | Community and Personal Service Workers |      18 |
| Beaconsfield | Clerical and Administrative Workers    |      48 |
| Beaconsfield | Sales Workers                          |      30 |
| Beaconsfield | Machinery Operators and Drivers        |      18 |
| Beaconsfield | Labourers                              |      21 |
| Berwick      | Managers                               |    3170 |
| Berwick      | Professionals                          |    4755 |


Table: 2TravelType
| Suburb       | Attribute         |   Value |
|:-------------|:------------------|--------:|
| Beaconsfield | Bus               |       0 |
| Beaconsfield | Ferry             |       0 |
| Beaconsfield | Tram              |       0 |
| Beaconsfield | Taxi              |       0 |
| Beaconsfield | Truck             |       0 |
| Beaconsfield | Motorbike/scooter |       0 |
| Beaconsfield | Bicycle           |       0 |
| Blind Bight  | Bus               |       0 |
| Blind Bight  | Ferry             |       0 |
| Blind Bight  | Tram              |       0 |


Table: Age (Bracket)
| Suburb       | Attribute            |   People | Gender   | Age Range   |   Sort |
|:-------------|:---------------------|---------:|:---------|:------------|-------:|
| Beaconsfield | Age_yr_90_94_F       |        0 | F        | 90_94       |     90 |
| Beaconsfield | Age_yr_95_99_M       |        0 | M        | 95_99       |     95 |
| Beaconsfield | Age_yr_100_yr_over_M |        0 | M        | 100_yr      |    100 |
| Beaconsfield | Age_yr_100_yr_over_F |        0 | F        | 100_yr      |    100 |
| Berwick      | Age_yr_100_yr_over_M |        0 | M        | 100_yr      |    100 |
| Blind Bight  | Age_yr_85_89_F       |        0 | F        | 85_89       |     85 |
| Blind Bight  | Age_yr_90_94_M       |        0 | M        | 90_94       |     90 |
| Blind Bight  | Age_yr_90_94_F       |        0 | F        | 90_94       |     90 |
| Blind Bight  | Age_yr_95_99_M       |        0 | M        | 95_99       |     95 |
| Blind Bight  | Age_yr_95_99_F       |        0 | F        | 95_99       |     95 |


Table: Age Continent
| Region   | Attribute   |      Value |   Sort |
|:---------|:------------|-----------:|-------:|
| Europe   | 0-4         | 0.00292898 |      0 |
| Europe   | 5-9         | 0.0106128  |      5 |
| Europe   | 10-14       | 0.015672   |     10 |
| Europe   | 15-19       | 0.0179923  |     15 |
| Europe   | 20-24       | 0.021568   |     20 |
| Europe   | 25-29       | 0.0312298  |     25 |
| Europe   | 30-34       | 0.0436685  |     30 |
| Europe   | 35-39       | 0.0507817  |     35 |
| Europe   | 40-44       | 0.0581232  |     40 |
| Europe   | 45-49       | 0.083495   |     45 |


Table: Assistance
| Age org     |   Year |   Has need for assistance male |   Has need for assistance female |   Sort | Age         |
|:------------|-------:|-------------------------------:|---------------------------------:|-------:|:------------|
| 0-4 years   |   2006 |                      0.0111875 |                       0.00695376 |      0 | 00-04 years |
| 5-14 years  |   2006 |                      0.027255  |                       0.0148902  |     11 | 05-14 years |
| 15-19 years |   2006 |                      0.0194094 |                       0.00933982 |     15 | 15-19 years |
| 20-24 years |   2006 |                      0.011708  |                       0.0102112  |     20 | 20-24 years |
| 25-34 years |   2006 |                      0.0123179 |                       0.00990769 |     25 | 25-34 years |
| 35-44 years |   2006 |                      0.014802  |                       0.0139568  |     35 | 35-44 years |
| 45-54 years |   2006 |                      0.0229744 |                       0.0283567  |     45 | 45-54 years |
| 55-64 years |   2006 |                      0.0581948 |                       0.0554822  |     55 | 55-64 years |
| 65-74 years |   2006 |                      0.0827793 |                       0.101263   |     65 | 65-74 years |
| 75-84 years |   2006 |                      0.207909  |                       0.280225   |     75 | 75-84 years |


Table: ATSI
| Age         | Gender   |   Value |
|:------------|:---------|--------:|
| 0-9 years   | Male     |     177 |
| 0-9 years   | Female   |     213 |
| 10-19 years | Male     |     199 |
| 10-19 years | Female   |     158 |
| 20-29 years | Male     |     116 |
| 20-29 years | Female   |     141 |
| 30-39 years | Male     |      87 |
| 30-39 years | Female   |     103 |
| 40-49 years | Male     |      97 |
| 40-49 years | Female   |      91 |


Table: CaseySuburbBirthplace2011
| Suburb      | Country     |   2011 |
|:------------|:------------|-------:|
| Clyde North | Afghanistan |      0 |
| Clyde North | Albania     |      0 |
| Clyde North | Algeria     |      0 |
| Clyde North | Angola      |      0 |
| Clyde North | Argentina   |      0 |
| Clyde North | Armenia     |      0 |
| Clyde North | Austria     |      0 |
| Clyde North | Azerbaijan  |      0 |
| Clyde North | Bahrain     |      0 |
| Clyde North | Bangladesh  |      0 |


Table: CaseySuburbBirthplace2016
| Suburb   | Country     |   2016 |
|:---------|:------------|-------:|
| Warneet  | Afghanistan |      0 |
| Warneet  | Albania     |      0 |
| Warneet  | Algeria     |      0 |
| Warneet  | Angola      |      0 |
| Warneet  | Argentina   |      0 |
| Warneet  | Armenia     |      0 |
| Warneet  | Austria     |      0 |
| Warneet  | Azerbaijan  |      0 |
| Warneet  | Bahrain     |      0 |
| Warneet  | Bangladesh  |      0 |


Table: Compare Pivot
| Language     | Attribute   |   Value |
|:-------------|:------------|--------:|
| Beaconsfield | Arabic      |       0 |
| Beaconsfield | Cantonese   |       0 |
| Beaconsfield | Dari        |       0 |
| Beaconsfield | Filipino    |       0 |
| Beaconsfield | French      |       0 |
| Beaconsfield | Gujarati    |       0 |
| Beaconsfield | Hazaraghi   |       0 |
| Beaconsfield | Khmer       |       0 |
| Beaconsfield | Mandarin    |       0 |
| Beaconsfield | Pashto      |       0 |


Table: Country
| Country     |
|:------------|
| Afghanistan |
| Albania     |
| Algeria     |
| Angola      |
| Argentina   |
| Armenia     |
| Austria     |
| Azerbaijan  |
| Bahrain     |
| Bangladesh  |


Table: Family Struc
| Suburb           |   Couple family with no children |   Couple family with children |   One parent family |   Other family |   Not applicable |
|:-----------------|---------------------------------:|------------------------------:|--------------------:|---------------:|-----------------:|
| Beaconsfield     |                               34 |                            75 |                  22 |              4 |               31 |
| Berwick          |                             3681 |                          7311 |                1769 |            135 |             4327 |
| Blind Bight      |                              134 |                           174 |                  48 |              0 |              143 |
| Botanic Ridge    |                              332 |                           680 |                  85 |              3 |              232 |
| Cannons Creek    |                               70 |                            77 |                  22 |              3 |               95 |
| Clyde            |                              198 |                           303 |                  72 |              9 |              223 |
| Clyde North      |                              705 |                          1287 |                 273 |             31 |              599 |
| Cranbourne       |                             1531 |                          2428 |                1136 |            109 |             2717 |
| Cranbourne East  |                             1223 |                          2480 |                 557 |             48 |             1372 |
| Cranbourne North |                             1267 |                          3074 |                 899 |             70 |             1711 |


Table: Homeless
| Location   |   Count |
|:-----------|--------:|
| Australia  |    48.9 |
| Victoria   |    42.6 |
| Casey      |    36.9 |


Table: Homelessness
| Region                 | Attribute                                                      |   Value |
|:-----------------------|:---------------------------------------------------------------|--------:|
| Melbourne - Inner      | Persons who are in improvised dwellings, tents or sleeping out |     384 |
| Melbourne - Inner      | Persons in supported accommodation for the homeless            |    1546 |
| Melbourne - Inner      | Persons staying temporarily with other households              |     405 |
| Melbourne - Inner      | Persons staying in boarding houses                             |    2140 |
| Melbourne - Inner      | Persons in other temporary lodging                             |      37 |
| Melbourne - Inner      | Persons living in 'severely' crowded dwellings                 |     415 |
| Melbourne - Inner      | Total                                                          |    4927 |
| Melbourne - Inner East | Persons who are in improvised dwellings, tents or sleeping out |       0 |
| Melbourne - Inner East | Persons in supported accommodation for the homeless            |     354 |
| Melbourne - Inner East | Persons staying temporarily with other households              |     130 |


Table: Ind Status
| Suburb           |   Non-Indigenous |   Aboriginal |   Torres Strait Islander |   Both Aboriginal and Torres Strait Islander |   Indigenous |   Not stated |   Total |    Total % |
|:-----------------|-----------------:|-------------:|-------------------------:|---------------------------------------------:|-------------:|-------------:|--------:|-----------:|
| Beaconsfield     |              469 |            0 |                        0 |                                            0 |            0 |           16 |     486 | 0          |
| Berwick          |            45791 |          170 |                       11 |                                            0 |          181 |         1698 |   47674 | 0.00379662 |
| Blind Bight      |             1174 |            7 |                        0 |                                            0 |            7 |           62 |    1252 | 0.00559105 |
| Botanic Ridge    |             3724 |           34 |                        0 |                                            0 |           34 |          162 |    3916 | 0.00868233 |
| Cannons Creek    |              574 |           10 |                        3 |                                            0 |           13 |           58 |     645 | 0.020155   |
| Clyde            |             1977 |            9 |                        0 |                                            0 |            9 |          130 |    2117 | 0.0042513  |
| Clyde North      |             7754 |           28 |                        8 |                                            3 |           39 |          367 |    8155 | 0.00478234 |
| Cranbourne       |            18537 |          165 |                        7 |                                            0 |          172 |         1380 |   20091 | 0.00856105 |
| Cranbourne East  |            15424 |          106 |                        0 |                                            0 |          106 |          664 |   16193 | 0.00654604 |
| Cranbourne North |            18973 |           87 |                        6 |                                            8 |          101 |         1044 |   20113 | 0.00502163 |


Table: Ind Total
|   Year |   Count Ind |
|-------:|------------:|
|   2011 |        1403 |
|   2016 |        1619 |
|   2006 |        1167 |


Table: Lang by Sub 2016 %
| Suburb   | Language   |   Percent of people |
|:---------|:-----------|--------------------:|
| Warneet  | Punjabi    |                   0 |
| Warneet  | Hazaraghi  |                   0 |
| Warneet  | Samoan     |                   0 |
| Warneet  | Dari       |                   0 |
| Warneet  | Khmer      |                   0 |
| Warneet  | Sinhalese  |                   0 |
| Warneet  | Arabic     |                   0 |
| Warneet  | Malayalam  |                   0 |
| Warneet  | Tamil      |                   0 |
| Warneet  | Spanish    |                   0 |


Table: Lang by Sub 2016 %2
| Suburb   | Language          |   Percent of People |
|:---------|:------------------|--------------------:|
| Warneet  | Gaelic (Scotland) |                   0 |
| Warneet  | Irish             |                   0 |
| Warneet  | Welsh             |                   0 |
| Warneet  | German            |                   0 |
| Warneet  | Dutch             |                   0 |
| Warneet  | Frisian           |                   0 |
| Warneet  | Afrikaans         |                   0 |
| Warneet  | Danish            |                   0 |
| Warneet  | Norwegian         |                   0 |
| Warneet  | Swedish           |                   0 |


Table: Lang by Sub 2016 Pivot
| Suburb       | Language   |   Count of People |
|:-------------|:-----------|------------------:|
| Beaconsfield | Sinhalese  |                 0 |
| Beaconsfield | Punjabi    |                 0 |
| Beaconsfield | Dari       |                 0 |
| Beaconsfield | Mandarin   |                 0 |
| Beaconsfield | Arabic     |                 0 |
| Beaconsfield | Tamil      |                 0 |
| Beaconsfield | Hazaraghi  |                 0 |
| Beaconsfield | Spanish    |                 0 |
| Beaconsfield | Serbian    |                 0 |
| Beaconsfield | Samoan     |                 0 |


Table: Lang by SuburbV2
| Suburb   | Language          |   People |
|:---------|:------------------|---------:|
| Warneet  | Gaelic (Scotland) |        0 |
| Warneet  | Irish             |        0 |
| Warneet  | Welsh             |        0 |
| Warneet  | German            |        0 |
| Warneet  | Dutch             |        0 |
| Warneet  | Frisian           |        0 |
| Warneet  | Afrikaans         |        0 |
| Warneet  | Danish            |        0 |
| Warneet  | Norwegian         |        0 |
| Warneet  | Swedish           |        0 |


Table: Lang
| Attribute   |
|:------------|
| Arabic      |
| Cantonese   |
| Croatian    |
| Dari        |
| English     |
| Filipino    |
| French      |
| Greek       |
| Gujarati    |
| Hazaraghi   |


Table: LangV2
| Language          |
|:------------------|
| Gaelic (Scotland) |
| Irish             |
| Welsh             |
| English           |
| German            |
| Dutch             |
| Frisian           |
| Afrikaans         |
| Danish            |
| Norwegian         |


Table: LGA Birthplace
|   Percent living in Casey |     Vic |   Casey |   Rank | Country     |
|--------------------------:|--------:|--------:|-------:|:------------|
|                 0.470718  |   18117 |    8528 |      1 | Afghanistan |
|                 0.0436958 | 3845494 |  168032 |      2 | Australia   |
|                 0.132996  |    8489 |    1129 |      3 | Bosnia      |
|                 0.0163157 |   10971 |     179 |     11 | Burma       |
|                 0.121992  |   13591 |    1658 |      2 | Cambodia    |
|                 0.0259784 |    8969 |     233 |     16 | Canada      |
|                 0.0265481 |  160652 |    4265 |     12 | China       |
|                 0.0816656 |   15490 |    1265 |      3 | Croatia     |
|                 0.0893489 |   13285 |    1187 |      1 | Egypt       |
|                 0.178166  |   10827 |    1929 |      1 | Fiji        |


Table: LGA on map
| LGA        | Attribute                          |     Value |
|:-----------|:-----------------------------------|----------:|
| Alpine     | Speaks English not well/not at all |  1.03855  |
| Ararat     | Speaks English not well/not at all |  0.739718 |
| Ballarat   | Speaks English not well/not at all |  0.741708 |
| Banyule    | Speaks English not well/not at all |  3.16773  |
| Bass Coast | Speaks English not well/not at all |  0.692484 |
| Baw Baw    | Speaks English not well/not at all |  0.540016 |
| Bayside    | Speaks English not well/not at all |  1.85137  |
| Benalla    | Speaks English not well/not at all |  0.376235 |
| Boroondara | Speaks English not well/not at all |  4.25771  |
| Brimbank   | Speaks English not well/not at all | 14.2521   |


Table: mapkey csv
| Suburb           | MapKey   |
|:-----------------|:---------|
| Beaconsfield     | BEA      |
| Berwick          | BER      |
| Blind Bight      | BLI      |
| Botanic Ridge    | BOT      |
| Cannons Creek    | CAN      |
| Clyde            | CLY      |
| Cranbourne       | CRA      |
| Cranbourne East  | CRE      |
| Cranbourne North | CRN      |
| Cranbourne South | CRS      |


Table: Marriage Status
| Gender   | Status         |   Count |   Year |      Perc |
|:---------|:---------------|--------:|-------:|----------:|
| Male     | Never married  |   39974 |   2016 | 0.268246  |
| Male     | Widowed        |    1942 |   2016 | 0.0130318 |
| Male     | Divorced       |    6604 |   2016 | 0.0443162 |
| Male     | Separated      |    3158 |   2016 | 0.0211918 |
| Male     | Married        |   62517 |   2016 | 0.419521  |
| Male     | Not applicable |   34825 |   2016 | 0.233693  |
| Female   | Never married  |   34018 |   2016 | 0.226372  |
| Female   | Widowed        |    7240 |   2016 | 0.0481783 |
| Female   | Divorced       |    9858 |   2016 | 0.0655997 |
| Female   | Separated      |    4049 |   2016 | 0.0269439 |


Table: Mortgage by family by suburb
| Suburb       |   Sort |   Attribute.3 | Attribute.4   | Attribute.5   | Attribute.6   |   People | Attribute - Copy   | Mortgage     | Custom.1   | Attribute    | Custom - Copy   |
|:-------------|-------:|--------------:|:--------------|:--------------|:--------------|---------:|:-------------------|:-------------|:-----------|:-------------|:----------------|
| Beaconsfield |      0 |           149 | OthF          |               |               |        0 | M_0_149_OthF       | 0 to 149     |            | Other family | Other Family    |
| Beaconsfield |    150 |           299 | OthF          |               |               |        0 | M_150_299_OthF     | 150 to 299   |            | Other family | Other Family    |
| Beaconsfield |    300 |           449 | OthF          |               |               |        0 | M_300_449_OthF     | 300 to 449   |            | Other family | Other Family    |
| Beaconsfield |    450 |           599 | OthF          |               |               |        0 | M_450_599_OthF     | 450 to 599   |            | Other family | Other Family    |
| Beaconsfield |    600 |           799 | OthF          |               |               |        0 | M_600_799_OthF     | 600 to 799   |            | Other family | Other Family    |
| Beaconsfield |    800 |           999 | OthF          |               |               |        0 | M_800_999_OthF     | 800 to 999   |            | Other family | Other Family    |
| Beaconsfield |   1000 |          1199 | OthF          |               |               |        0 | M_1000_1199_OthF   | 1000 to 1199 |            | Other family | Other Family    |
| Beaconsfield |   1200 |          1399 | OthF          |               |               |        0 | M_1200_1399_OthF   | 1200 to 1399 |            | Other family | Other Family    |
| Beaconsfield |   1400 |          1599 | OthF          |               |               |        0 | M_1400_1599_OthF   | 1400 to 1599 |            | Other family | Other Family    |
| Beaconsfield |   1600 |          1799 | OthF          |               |               |        0 | M_1600_1799_OthF   | 1600 to 1799 |            | Other family | Other Family    |


Table: Religion by Suburb
| Suburb       | Religion                                                                 |   Count of People |
|:-------------|:-------------------------------------------------------------------------|------------------:|
| Beaconsfield | Buddhism                                                                 |                 0 |
| Beaconsfield | Christianity                                                             |               283 |
| Beaconsfield | Hinduism                                                                 |                 5 |
| Beaconsfield | Islam                                                                    |                 0 |
| Beaconsfield | Judaism                                                                  |                 0 |
| Beaconsfield | Other Religions                                                          |                 0 |
| Beaconsfield | Secular Beliefs and Other Spiritual Beliefs and No Religious Affiliation |               173 |
| Beaconsfield | Inadequately described                                                   |                 0 |
| Beaconsfield | Not stated                                                               |                20 |
| Berwick      | Buddhism                                                                 |              1691 |


Table: Religion_LGA
| Religion                 |   Count | Rank   |   Casey |   Vic |
|:-------------------------|--------:|:-------|--------:|------:|
| Sikhism                  |    6367 | 6      |   0.023 | 0.009 |
| Buddhism                 |   13641 | 7      |   0.05  | 0.034 |
| Christianity             |  145530 |        |   0.529 | 0.529 |
| Hinduism                 |   12502 | 5      |   0.045 | 0.025 |
| Islam                    |   22195 | 4      |   0.081 | 0.037 |
| No Religious Affiliation |   73667 |        |   0.268 | 0.354 |


Table: Rent_2016Census_G36_VIC_SSC
| Suburb       |   Value |   Sort |   Attribute - Copy.3 | Landlord type                                | Rent       |
|:-------------|--------:|-------:|---------------------:|:---------------------------------------------|:-----------|
| Beaconsfield |       0 |      0 |                   74 | Housing  co-operative/community/church group | 0 to 74    |
| Beaconsfield |       0 |     75 |                   99 | Housing  co-operative/community/church group | 75 to 99   |
| Beaconsfield |       0 |    100 |                  149 | Housing  co-operative/community/church group | 100 to 149 |
| Beaconsfield |       0 |    150 |                  199 | Housing  co-operative/community/church group | 150 to 199 |
| Beaconsfield |       0 |    200 |                  224 | Housing  co-operative/community/church group | 200 to 224 |
| Beaconsfield |       0 |    225 |                  274 | Housing  co-operative/community/church group | 225 to 274 |
| Beaconsfield |       0 |    275 |                  349 | Housing  co-operative/community/church group | 275 to 349 |
| Beaconsfield |       0 |    350 |                  449 | Housing  co-operative/community/church group | 350 to 449 |
| Beaconsfield |       0 |    450 |                  549 | Housing  co-operative/community/church group | 450 to 549 |
| Beaconsfield |       0 |    550 |                  649 | Housing  co-operative/community/church group | 550 to 649 |


Table: Same-sex
| suburb       | Attribute              |   Value |
|:-------------|:-----------------------|--------:|
| Beaconsfield | Male same-sex couple   |       0 |
| Beaconsfield | Female same-sex couple |       0 |
| Beaconsfield | Opposite-sex couple    |     105 |
| Beaconsfield | Not applicable         |      53 |
| Berwick      | Male same-sex couple   |      13 |
| Berwick      | Female same-sex couple |      24 |
| Berwick      | Opposite-sex couple    |   10954 |
| Berwick      | Not applicable         |    6230 |
| Blind Bight  | Male same-sex couple   |       0 |
| Blind Bight  | Female same-sex couple |       0 |


Table: Sub Comparison
| Suburb       | Attribute                              |     Value |
|:-------------|:---------------------------------------|----------:|
| Beaconsfield | Median weekly household income         | 1912      |
| Beaconsfield | Median monthly mortgage repayments     | 1950      |
| Beaconsfield | Median weekly rent                     |  302      |
| Beaconsfield | Language spoken other than English (%) |   10.4938 |
| Beaconsfield | Indigenous                             |    0      |
| Beaconsfield | Provided unpaid assistance (%)         |   12.1399 |
| Beaconsfield | Median Age                             |   39      |
| Beaconsfield | Owned with a mortgage                  |   51.9    |
| Beaconsfield | Population                             |  486      |
| Beaconsfield | Population growth since 2011           |   27      |


Table: Table1
| Rank   |   Column1 |
|:-------|----------:|
| 1      |         1 |
| 2      |         1 |
| 3      |         1 |
| Other  |         1 |


Table: Unpaid to Person Disability
|   Provided unpaid assistance |   Provided unpaid assistance (%) | Suburb           |
|-----------------------------:|---------------------------------:|:-----------------|
|                           59 |                        0.121399  | Beaconsfield     |
|                         4113 |                        0.0862734 | Berwick          |
|                          130 |                        0.103834  | Blind Bight      |
|                          267 |                        0.0681818 | Botanic Ridge    |
|                           54 |                        0.0837209 | Cannons Creek    |
|                          148 |                        0.0699103 | Clyde            |
|                          501 |                        0.0614347 | Clyde North      |
|                         1772 |                        0.0881987 | Cranbourne       |
|                         1268 |                        0.0783054 | Cranbourne East  |
|                         1608 |                        0.0799483 | Cranbourne North |


Table: Volunter
| Suburb        | Attribute               |   People | Gender   | Age   | Volunteer Status   |
|:--------------|:------------------------|---------:|:---------|:------|:-------------------|
| Beaconsfield  | 85ov_Volunteer          |        0 | F        | 85_ov | A Volunteer        |
| Blind Bight   | 85ov_Volunteer          |        0 | M        | 85_ov | A Volunteer        |
| Blind Bight   | 85_ov_Voluntary_work_ns |        0 | M        | 85_ov | Not Stated         |
| Blind Bight   | 85ov_Volunteer          |        0 | F        | 85_ov | A Volunteer        |
| Blind Bight   | 85ov_N_a_volunteer      |        0 | F        | 85_ov | Not a Volunteer    |
| Blind Bight   | 85_ov_Voluntary_work_ns |        0 | F        | 85_ov | Not Stated         |
| Botanic Ridge | 85ov_Volunteer          |        0 | M        | 85_ov | A Volunteer        |
| Botanic Ridge | 85_ov_Voluntary_work_ns |        0 | M        | 85_ov | Not Stated         |
| Botanic Ridge | 85ov_Volunteer          |        0 | F        | 85_ov | A Volunteer        |
| Botanic Ridge | 85ov_N_a_volunteer      |        0 | F        | 85_ov | Not a Volunteer    |

 


tables: name: 2016Census_G10A_VIC_SSC
data: 2016Census_G10A_VIC_SSC.csv
name: 2Education
data: 2Education.csv
name: 2Employed
data: 2Employed.csv
name: 2Industry
data: 2Industry.csv
name: 2Place of Work Agg
data: 2Place of Work Agg.csv
name: 2Place of Work
data: 2Place of Work.csv
name: 2Position
data: 2Position.csv
name: 2TravelType
data: 2TravelType.csv
name: Age (Bracket)
data: Age (Bracket).csv
name: Age Continent
data: Age Continent.csv
name: Assistance
data: Assistance.csv
name: ATSI
data: ATSI.csv
name: CaseySuburbBirthplace2011
data: CaseySuburbBirthplace2011.csv
name: CaseySuburbBirthplace2016
data: CaseySuburbBirthplace2016.csv
name: Compare Pivot
data: Compare Pivot.csv
name: Country
data: Country.csv
name: Family Struc
data: Family Struc.csv
name: Homeless
data: Homeless.csv
name: Homelessness
data: Homelessness.csv
name: Ind Status
data: Ind Status.csv
name: Ind Total
data: Ind Total.csv
name: Lang by Sub 2016 %
data: Lang by Sub 2016 %.csv
name: Lang by Sub 2016 %2
data: Lang by Sub 2016 %2.csv
name: Lang by Sub 2016 Pivot
data: Lang by Sub 2016 Pivot.csv
name: Lang by SuburbV2
data: Lang by SuburbV2.csv
name: Lang
data: Lang.csv
name: LangV2
data: LangV2.csv
name: LGA Birthplace
data: LGA Birthplace.csv
name: LGA on map
data: LGA on map.csv
name: mapkey csv
data: mapkey csv.csv
name: Marriage Status
data: Marriage Status.csv
name: Mortgage by family by suburb
data: Mortgage by family by suburb.csv
name: Religion by Suburb
data: Religion by Suburb.csv
name: Religion_LGA
data: Religion_LGA.csv
name: Rent_2016Census_G36_VIC_SSC
data: Rent_2016Census_G36_VIC_SSC.csv
name: Same-sex
data: Same-sex.csv
name: Sub Comparison
data: Sub Comparison.csv
name: Table1
data: Table1.csv
name: Unpaid to Person Disability
data: Unpaid to Person Disability.csv
name: Volunter
data: Volunter.csv
label: Lang by Sub 2016 Pivot
Suburb
mapkey csv
Suburb
Compare Pivot
Language
mapkey csv
Suburb
Compare Pivot
Attribute
Lang
Attribute
Lang by Sub 2016 Pivot
Language
Lang
Attribute
Lang by Sub 2016 %
Suburb
mapkey csv
Suburb
Lang by Sub 2016 %
Language
Lang
Attribute
Ind Status
Suburb
mapkey csv
Suburb
CaseySuburbBirthplace2011
Country
Country
Country
CaseySuburbBirthplace2016
Country
Country
Country
CaseySuburbBirthplace2016
Suburb
mapkey csv
Suburb
CaseySuburbBirthplace2011
Suburb
mapkey csv
Suburb
Unpaid to Person Disability
Suburb
mapkey csv
Suburb
Marriage Status
Year
Ind Total
Year
Family Struc
Suburb
mapkey csv
Suburb
Volunter
Suburb
mapkey csv
Suburb
Age (Bracket)
Suburb
mapkey csv
Suburb
Same-sex
suburb
mapkey csv
Suburb
Mortgage by family by suburb
Suburb
mapkey csv
Suburb
Rent_2016Census_G36_VIC_SSC
Suburb
mapkey csv
Suburb
Sub Comparison
Suburb
mapkey csv
Suburb
2016Census_G10A_VIC_SSC
Suburb
mapkey csv
Suburb
Lang by SuburbV2
Suburb
mapkey csv
Suburb
Lang by Sub 2016 %2
Suburb
mapkey csv
Suburb
Lang by Sub 2016 Pivot
Language
LangV2
Language
Lang by Sub 2016 %
Language
LangV2
Language
Lang by SuburbV2
Language
LangV2
Language
Lang by Sub 2016 %2
Language
LangV2
Language
Religion by Suburb
Religion
Religion_LGA
Religion
LGA Birthplace
Country
Country
Country
Same-sex
Value
ATSI
Value
Rent_2016Census_G36_VIC_SSC
Value
ATSI
Value
2016Census_G10A_VIC_SSC
Value
ATSI
Value
LGA on map
Value
ATSI
Value
Age Continent
Value
ATSI
Value
2Place of Work Agg
Suburb
mapkey csv
Suburb
2Place of Work
Suburb
2Place of Work Agg
Suburb
2Education
Value
ATSI
Value
2TravelType
Value
ATSI
Value
2Industry
Value
ATSI
Value
output: {
    "joins": [
        {
            "from_table": "Lang by Sub 2016 Pivot",
            "from_column": "Suburb",
            "to_table": "mapkey csv",
            "to_column": "Suburb"
        },
        {
            "from_table": "Compare Pivot",
            "from_column": "Language",
            "to_table": "mapkey csv",
            "to_column": "Suburb"
        },
        {
            "from_table": "Compare Pivot",
            "from_column": "Attribute",
            "to_table": "Lang",
            "to_column": "Attribute"
        },
        {
            "from_table": "Lang by Sub 2016 Pivot",
            "from_column": "Language",
            "to_table": "Lang",
            "to_column": "Attribute"
        },
        {
            "from_table": "Lang by Sub 2016 %",
            "from_column": "Suburb",
            "to_table": "mapkey csv",
            "to_column": "Suburb"
        },
        {
            "from_table": "Lang by Sub 2016 %",
            "from_column": "Language",
            "to_table": "Lang",
            "to_column": "Attribute"
        },
        {
            "from_table": "Ind Status",
            "from_column": "Suburb",
            "to_table": "mapkey csv",
            "to_column": "Suburb"
        },
        {
            "from_table": "CaseySuburbBirthplace2011",
            "from_column": "Country",
            "to_table": "Country",
            "to_column": "Country"
        },
        {
            "from_table": "CaseySuburbBirthplace2016",
            "from_column": "Country",
            "to_table": "Country",
            "to_column": "Country"
        },
        {
            "from_table": "CaseySuburbBirthplace2016",
            "from_column": "Suburb",
            "to_table": "mapkey csv",
            "to_column": "Suburb"
        },
        {
            "from_table": "CaseySuburbBirthplace2011",
            "from_column": "Suburb",
            "to_table": "mapkey csv",
            "to_column": "Suburb"
        },
        {
            "from_table": "Unpaid to Person Disability",
            "from_column": "Suburb",
            "to_table": "mapkey csv",
            "to_column": "Suburb"
        },
        {
            "from_table": "Marriage Status",
            "from_column": "Year",
            "to_table": "Ind Total",
            "to_column": "Year"
        },
        {
            "from_table": "Family Struc",
            "from_column": "Suburb",
            "to_table": "mapkey csv",
            "to_column": "Suburb"
        },
        {
            "from_table": "Volunter",
            "from_column": "Suburb",
            "to_table": "mapkey csv",
            "to_column": "Suburb"
        },
        {
            "from_table": "Age (Bracket)",
            "from_column": "Suburb",
            "to_table": "mapkey csv",
            "to_column": "Suburb"
        },
        {
            "from_table": "Same-sex",
            "from_column": "suburb",
            "to_table": "mapkey csv",
            "to_column": "Suburb"
        },
        {
            "from_table": "Mortgage by family by suburb",
            "from_column": "Suburb",
            "to_table": "mapkey csv",
            "to_column": "Suburb"
        },
        {
            "from_table": "Rent_2016Census_G36_VIC_SSC",
            "from_column": "Suburb",
            "to_table": "mapkey csv",
            "to_column": "Suburb"
        },
        {
            "from_table": "Sub Comparison",
            "from_column": "Suburb",
            "to_table": "mapkey csv",
            "to_column": "Suburb"
        },
        {
            "from_table": "2016Census_G10A_VIC_SSC",
            "from_column": "Suburb",
            "to_table": "mapkey csv",
            "to_column": "Suburb"
        },
        {
            "from_table": "Lang by SuburbV2",
            "from_column": "Suburb",
            "to_table": "mapkey csv",
            "to_column": "Suburb"
        },
        {
            "from_table": "Lang by Sub 2016 %2",
            "from_column": "Suburb",
            "to_table": "mapkey csv",
            "to_column": "Suburb"
        },
        {
            "from_table": "Lang by Sub 2016 Pivot",
            "from_column": "Language",
            "to_table": "LangV2",
            "to_column": "Language"
        },
        {
            "from_table": "Lang by Sub 2016 %",
            "from_column": "Language",
            "to_table": "LangV2",
            "to_column": "Language"
        },
        {
            "from_table": "Lang by SuburbV2",
            "from_column": "Language",
            "to_table": "LangV2",
            "to_column": "Language"
        },
        {
            "from_table": "Lang by Sub 2016 %2",
            "from_column": "Language",
            "to_table": "LangV2",
            "to_column": "Language"
        },
        {
            "from_table": "Religion by Suburb",
            "from_column": "Religion",
            "to_table": "Religion_LGA",
            "to_column": "Religion"
        },
        {
            "from_table": "LGA Birthplace",
            "from_column": "Country",
            "to_table": "Country",
            "to_column": "Country"
        },
        {
            "from_table": "Same-sex",
            "from_column": "Value",
            "to_table": "ATSI",
            "to_column": "Value"
        },
        {
            "from_table": "Rent_2016Census_G36_VIC_SSC",
            "from_column": "Value",
            "to_table": "ATSI",
            "to_column": "Value"
        },
        {
            "from_table": "2016Census_G10A_VIC_SSC",
            "from_column": "Value",
            "to_table": "ATSI",
            "to_column": "Value"
        },
        {
            "from_table": "LGA on map",
            "from_column": "Value",
            "to_table": "ATSI",
            "to_column": "Value"
        },
        {
            "from_table": "Age Continent",
            "from_column": "Value",
            "to_table": "ATSI",
            "to_column": "Value"
        },
        {
            "from_table": "2Place of Work Agg",
            "from_column": "Suburb",
            "to_table": "mapkey csv",
            "to_column": "Suburb"
        },
        {
            "from_table": "2Place of Work",
            "from_column": "Suburb",
            "to_table": "2Place of Work Agg",
            "to_column": "Suburb"
        },
        {
            "from_table": "2Education",
            "from_column": "Value",
            "to_table": "ATSI",
            "to_column": "Value"
        },
        {
            "from_table": "2TravelType",
            "from_column": "Value",
            "to_table": "ATSI",
            "to_column": "Value"
        },
        {
            "from_table": "2Industry",
            "from_column": "Value",
            "to_table": "ATSI",
            "to_column": "Value"
        }
    ]
}