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: 2006 (2)
|   Year | Region         | DISTRICTS                   |   Latitude |   Longitude |   MAIZE |   RICE |   CASSAVA |   YAM |   COCOYAM |   PLANTAIN |   TOMATO |   PEPPER |   GARDEN EGG |   OKRO |   SORGHUM |   G'NUTS |   MILLET |   COWPEA |   SOYABEAN |   SWEET POTATO |
|-------:|:---------------|:----------------------------|-----------:|------------:|--------:|-------:|----------:|------:|----------:|-----------:|---------:|---------:|-------------:|-------:|----------:|---------:|---------:|---------:|-----------:|---------------:|
|   2006 | WESTERN REGION | Shama Ahanta East           |    4.92482 |    -1.74458 |    1746 |    183 |     17995 |   114 |       491 |       2867 |        0 |        0 |            0 |      0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2006 | WESTERN REGION | West Ahanta                 |    4.88993 |    -1.96434 |    1538 |    109 |     37068 |    79 |       759 |       1415 |        0 |        0 |            0 |      0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2006 | WESTERN REGION | Mporhor Wassa East          |    5.13255 |    -1.75319 |    2775 |     65 |     58578 |  1104 |      9492 |      15613 |        0 |        0 |            0 |      0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2006 | WESTERN REGION | Wassa West                  |    5.43793 |    -2.14407 |    2843 |   1633 |     32448 |  1204 |      2894 |       8537 |        0 |        0 |            0 |      0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2006 | WESTERN REGION | East Nzema                  |    5.03777 |    -2.4494  |    2164 |    419 |     55443 |    89 |       555 |       4290 |        0 |        0 |            0 |      0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2006 | WESTERN REGION | Jomoro                      |    5.05314 |    -2.88944 |    2128 |   2099 |     44036 |    58 |       308 |       3332 |        0 |        0 |            0 |      0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2006 | WESTERN REGION | Amanfi East                 |    5.79641 |    -2.42821 |    7479 |   1398 |     41032 |  3695 |      6026 |      47450 |        0 |        0 |            0 |      0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2006 | WESTERN REGION | Amanfi  West (Wassa Amanfi) |    5.91924 |    -2.01533 |    7125 |   1491 |     31099 |  3599 |      4923 |      37485 |        0 |        0 |            0 |      0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2006 | WESTERN REGION | Aowin -Suaman               |    5.82974 |    -2.82118 |   13002 |   2125 |    101448 |  7455 |     30645 |      85990 |        0 |        0 |            0 |      0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2006 | WESTERN REGION | Bibiani-Anhwiaso-Bekwai     |    6.25618 |    -2.13631 |    6680 |   1725 |     64501 | 18070 |     49557 |      93511 |        0 |        0 |            0 |      0 |         0 |        0 |        0 |        0 |          0 |              0 |


Table: 2006
|   Year | Region         | DISTRICTS                   |   MAIZE |   RICE |   CASSAVA |   YAM |   COCOYAM |   PLANTAIN |   TOMATO |   PEPPER |   GARDEN EGG |   OKRO |   SORGHUM |   G'NUTS |   MILLET |   COWPEA |   SOYABEAN |   SWEET POTATO |
|-------:|:---------------|:----------------------------|--------:|-------:|----------:|------:|----------:|-----------:|---------:|---------:|-------------:|-------:|----------:|---------:|---------:|---------:|-----------:|---------------:|
|   2006 | WESTERN REGION | Shama Ahanta East           |    1746 |    183 |     17995 |   114 |       491 |       2867 |        0 |        0 |            0 |      0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2006 | WESTERN REGION | West Ahanta                 |    1538 |    109 |     37068 |    79 |       759 |       1415 |        0 |        0 |            0 |      0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2006 | WESTERN REGION | Mporhor Wassa East          |    2775 |     65 |     58578 |  1104 |      9492 |      15613 |        0 |        0 |            0 |      0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2006 | WESTERN REGION | Wassa West                  |    2843 |   1633 |     32448 |  1204 |      2894 |       8537 |        0 |        0 |            0 |      0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2006 | WESTERN REGION | East Nzema                  |    2164 |    419 |     55443 |    89 |       555 |       4290 |        0 |        0 |            0 |      0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2006 | WESTERN REGION | Jomoro                      |    2128 |   2099 |     44036 |    58 |       308 |       3332 |        0 |        0 |            0 |      0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2006 | WESTERN REGION | Amanfi East                 |    7479 |   1398 |     41032 |  3695 |      6026 |      47450 |        0 |        0 |            0 |      0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2006 | WESTERN REGION | Amanfi  West (Wassa Amanfi) |    7125 |   1491 |     31099 |  3599 |      4923 |      37485 |        0 |        0 |            0 |      0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2006 | WESTERN REGION | Aowin -Suaman               |   13002 |   2125 |    101448 |  7455 |     30645 |      85990 |        0 |        0 |            0 |      0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2006 | WESTERN REGION | Bibiani-Anhwiaso-Bekwai     |    6680 |   1725 |     64501 | 18070 |     49557 |      93511 |        0 |        0 |            0 |      0 |         0 |        0 |        0 |        0 |          0 |              0 |


Table: 2007 (2)
|   Year  | Region         | DISTRICTS                   |   Latitude |   Longitude |    MAIZE |    RICE |   CASSAVA |      YAM |   COCOYAM |   PLANTAIN |   PEPPER |   Tomato |   Garden Eggs |   Okro |   Lettuce |   Onion |   Cucumber |   Cabbage |   Watermelon |   SORGHUM |   G'NUTS |   MILLET |   COWPEA |   SOYABEAN |   SWEET POTATO |   GROUNDNUTS |
|--------:|:---------------|:----------------------------|-----------:|------------:|---------:|--------:|----------:|---------:|----------:|-----------:|---------:|---------:|--------------:|-------:|----------:|--------:|-----------:|----------:|-------------:|----------:|---------:|---------:|---------:|-----------:|---------------:|-------------:|
|    2007 | WESTERN REGION | Shama Ahanta East           |    4.92482 |    -1.74458 |  1333.4  |  110.7  |   18480   |   108.9  |     261.3 |     2730   |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |            0 |
|    2007 | WESTERN REGION | West Ahanta                 |    4.88993 |    -1.96434 |  1764    |  114    |   36800   |    99    |     884   |     1770   |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |            0 |
|    2007 | WESTERN REGION | Mporhor Wassa East          |    5.13255 |    -1.75319 |  2630.48 |   90.75 |   58374   |  1107.8  |    7639.5 |    15515.5 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |            0 |
|    2007 | WESTERN REGION | Wassa West                  |    5.43793 |    -2.14407 |  2677.5  | 1640.2  |   38665   |   875    |    3146   |     8676   |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |            0 |
|    2007 | WESTERN REGION | East Nzema                  |    5.03777 |    -2.4494  |  2085    |  660    |   54572.4 |   103.5  |     585.9 |     3232   |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |            0 |
|    2007 | WESTERN REGION | Jomoro                      |    5.05314 |    -2.88944 |  1179    | 1152    |   45695   |    67.41 |     315   |     3150   |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |            0 |
|    2007 | WESTERN REGION | Amanfi East                 |    5.79641 |    -2.42821 |  7853.58 | 1521    |   47411   |  3774    |    6608   |    50562   |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |            0 |
|    2007 | WESTERN REGION | Amanfi  West (Wassa Amanfi) |    5.91924 |    -2.01533 |  7387.8  | 1625    |   32108   |  3648    |    5490   |    44000   |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |            0 |
|    2007 | WESTERN REGION | Aowin -Suaman               |    5.82974 |    -2.82118 | 13288    | 2176.2  |  101520   |  7140    |   30876   |    86072   |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |            0 |
|    2007 | WESTERN REGION | Bibiani-Anhwiaso-Bekwai     |    6.25618 |    -2.13631 |  7114.2  | 1794    |   67252   | 18225    |   49800   |    94245   |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |            0 |


Table: 2007
|   Year  | Region         | DISTRICTS                   |    MAIZE |    RICE |   CASSAVA |      YAM |   COCOYAM |   PLANTAIN |   PEPPER |   Tomato |   Garden Eggs |   Okro |   Lettuce |   Onion |   Cucumber |   Cabbage |   Watermelon |   SORGHUM |   G'NUTS |   MILLET |   COWPEA |   SOYABEAN |   SWEET POTATO |   GROUNDNUTS |
|--------:|:---------------|:----------------------------|---------:|--------:|----------:|---------:|----------:|-----------:|---------:|---------:|--------------:|-------:|----------:|--------:|-----------:|----------:|-------------:|----------:|---------:|---------:|---------:|-----------:|---------------:|-------------:|
|    2007 | WESTERN REGION | Shama Ahanta East           |  1333.4  |  110.7  |   18480   |   108.9  |     261.3 |     2730   |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |            0 |
|    2007 | WESTERN REGION | West Ahanta                 |  1764    |  114    |   36800   |    99    |     884   |     1770   |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |            0 |
|    2007 | WESTERN REGION | Mporhor Wassa East          |  2630.48 |   90.75 |   58374   |  1107.8  |    7639.5 |    15515.5 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |            0 |
|    2007 | WESTERN REGION | Wassa West                  |  2677.5  | 1640.2  |   38665   |   875    |    3146   |     8676   |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |            0 |
|    2007 | WESTERN REGION | East Nzema                  |  2085    |  660    |   54572.4 |   103.5  |     585.9 |     3232   |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |            0 |
|    2007 | WESTERN REGION | Jomoro                      |  1179    | 1152    |   45695   |    67.41 |     315   |     3150   |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |            0 |
|    2007 | WESTERN REGION | Amanfi East                 |  7853.58 | 1521    |   47411   |  3774    |    6608   |    50562   |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |            0 |
|    2007 | WESTERN REGION | Amanfi  West (Wassa Amanfi) |  7387.8  | 1625    |   32108   |  3648    |    5490   |    44000   |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |            0 |
|    2007 | WESTERN REGION | Aowin -Suaman               | 13288    | 2176.2  |  101520   |  7140    |   30876   |    86072   |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |            0 |
|    2007 | WESTERN REGION | Bibiani-Anhwiaso-Bekwai     |  7114.2  | 1794    |   67252   | 18225    |   49800   |    94245   |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |            0 |


Table: 2008 (2)
|   Year | Region         | DISTRICTS                   |   Latitude |   Longitude |    MAIZE |    RICE |   CASSAVA |      YAM |   COCOYAM |   PLANTAIN |   Tomato |   Pepper |   Garden Eggs |   Okro |   Lettuce |   Onion |   Cucumber |   Cabbage |   Watermelon |   SORGHUM |   G'NUTS |   MILLET |   COWPEA |   SOYABEAN |   SWEET POTATO |
|-------:|:---------------|:----------------------------|-----------:|------------:|---------:|--------:|----------:|---------:|----------:|-----------:|---------:|---------:|--------------:|-------:|----------:|--------:|-----------:|----------:|-------------:|----------:|---------:|---------:|---------:|-----------:|---------------:|
|   2008 | WESTERN REGION | Shama Ahanta East           |    4.92482 |    -1.74458 |  1263.85 |  113.46 |   18915   |   111.6  |    257.4  |     2784.6 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2008 | WESTERN REGION | West Ahanta                 |    4.88993 |    -1.96434 |  1705.27 |  114.24 |   37720.8 |   105.6  |    855.54 |     1817.2 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2008 | WESTERN REGION | Mporhor Wassa East          |    5.13255 |    -1.75319 |  2684.88 |   97.2  |   60134   |  1131.2  |   7244.16 |    15670.2 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2008 | WESTERN REGION | Wassa West                  |    5.43793 |    -2.14407 |  2644.8  | 1659.08 |   39634.2 |   892.8  |   3010.48 |     8884.1 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2008 | WESTERN REGION | East Nzema                  |    5.03777 |    -2.4494  |  2139    |  757.35 |   55939.5 |   108.8  |    573.78 |     3260   |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2008 | WESTERN REGION | Jomoro                      |    5.05314 |    -2.88944 |  1206.4  | 1162.8  |   46841.3 |    70.4  |    346.5  |     3244.5 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2008 | WESTERN REGION | Amenfi East                 |    5.79641 |    -2.42821 |  8042.54 | 1429.01 |   48600   |  3852.36 |   7556.87 |    52077.8 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2008 | WESTERN REGION | Amenfi  West (Wassa Amenfi) |    5.91924 |    -2.01533 |  7554.4  | 1629.27 |   32905.6 |  3721.65 |   5940    |    46431   |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2008 | WESTERN REGION | Aowin -Suaman               |    5.82974 |    -2.82118 | 13479    | 2197.8  |  104025   |  7296.4  |  36618    |    88785.6 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2008 | WESTERN REGION | Bibiani-Anhwiaso-Bekwai     |    6.25618 |    -2.13631 |  7375.48 | 1751.6  |   68931.6 | 18607.7  |  47359.3  |    95268   |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |


Table: 2008
|   Year | Region         | DISTRICTS                   |    MAIZE |    RICE |   CASSAVA |      YAM |   COCOYAM |   PLANTAIN |   Tomato |   Pepper |   Garden Eggs |   Okro |   Lettuce |   Onion |   Cucumber |   Cabbage |   Watermelon |   SORGHUM |   G'NUTS |   MILLET |   COWPEA |   SOYABEAN |   SWEET POTATO |
|-------:|:---------------|:----------------------------|---------:|--------:|----------:|---------:|----------:|-----------:|---------:|---------:|--------------:|-------:|----------:|--------:|-----------:|----------:|-------------:|----------:|---------:|---------:|---------:|-----------:|---------------:|
|   2008 | WESTERN REGION | Shama Ahanta East           |  1263.85 |  113.46 |   18915   |   111.6  |    257.4  |     2784.6 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2008 | WESTERN REGION | West Ahanta                 |  1705.27 |  114.24 |   37720.8 |   105.6  |    855.54 |     1817.2 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2008 | WESTERN REGION | Mporhor Wassa East          |  2684.88 |   97.2  |   60134   |  1131.2  |   7244.16 |    15670.2 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2008 | WESTERN REGION | Wassa West                  |  2644.8  | 1659.08 |   39634.2 |   892.8  |   3010.48 |     8884.1 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2008 | WESTERN REGION | East Nzema                  |  2139    |  757.35 |   55939.5 |   108.8  |    573.78 |     3260   |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2008 | WESTERN REGION | Jomoro                      |  1206.4  | 1162.8  |   46841.3 |    70.4  |    346.5  |     3244.5 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2008 | WESTERN REGION | Amenfi East                 |  8042.54 | 1429.01 |   48600   |  3852.36 |   7556.87 |    52077.8 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2008 | WESTERN REGION | Amenfi  West (Wassa Amenfi) |  7554.4  | 1629.27 |   32905.6 |  3721.65 |   5940    |    46431   |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2008 | WESTERN REGION | Aowin -Suaman               | 13479    | 2197.8  |  104025   |  7296.4  |  36618    |    88785.6 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2008 | WESTERN REGION | Bibiani-Anhwiaso-Bekwai     |  7375.48 | 1751.6  |   68931.6 | 18607.7  |  47359.3  |    95268   |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |


Table: 2009 (2)
|   Year | Region         | DISTRICTS                   |   Latitude |   Longitude |   MAIZE |   RICE |   CASSAVA |   YAM |   COCOYAM |   PLANTAIN |   PEPPER |   TOMATO |   GARDEN EGGS |   OKRO |   LETTUCE |   ONION |   CUCUMBER |   CABBAGE |   WATERMELON |   SORGHUM |   G'NUTS |   COWPEA |   MILLET |   SOYABEAN |   SWEET POTATO |
|-------:|:---------------|:----------------------------|-----------:|------------:|--------:|-------:|----------:|------:|----------:|-----------:|---------:|---------:|--------------:|-------:|----------:|--------:|-----------:|----------:|-------------:|----------:|---------:|---------:|---------:|-----------:|---------------:|
|   2009 | WESTERN REGION | Shama Ahanta East           |    4.92482 |    -1.74458 |    1270 |    130 |     18960 |   110 |       230 |       2820 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2009 | WESTERN REGION | West Ahanta                 |    4.88993 |    -1.96434 |    1730 |    120 |     37850 |   100 |       840 |       1890 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2009 | WESTERN REGION | Mporhor Wassa East          |    5.13255 |    -1.75319 |    2690 |    120 |     60350 |  1120 |      6880 |      15930 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2009 | WESTERN REGION | Wassa West                  |    5.43793 |    -2.14407 |    2650 |   1660 |     39770 |   910 |      3050 |       9020 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2009 | WESTERN REGION | East Nzema                  |    5.03777 |    -2.4494  |    2150 |    830 |     56360 |   100 |       570 |       3300 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2009 | WESTERN REGION | Jomoro                      |    5.05314 |    -2.88944 |    1210 |   1160 |     47050 |    60 |       350 |       3310 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2009 | WESTERN REGION | Amanfi East                 |    5.79641 |    -2.42821 |    8160 |   1430 |     48690 |  3830 |      7540 |      53850 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2009 | WESTERN REGION | Amanfi  West (Wassa Amanfi) |    5.91924 |    -2.01533 |    7740 |   1780 |     33040 |  3740 |      5940 |      48020 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2009 | WESTERN REGION | Aowin -Suaman               |    5.82974 |    -2.82118 |   13800 |   2460 |    104880 |  7340 |     35160 |      92110 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2009 | WESTERN REGION | Bibiani-Anhwiaso-Bekwai     |    6.25618 |    -2.13631 |    7570 |   1750 |     69380 | 18610 |     46960 |     100880 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |


Table: 2009
|   Year | Region         | DISTRICTS                   |   MAIZE |   RICE |   CASSAVA |   YAM |   COCOYAM |   PLANTAIN |   PEPPER |   TOMATO |   GARDEN EGGS |   OKRO |   LETTUCE |   ONION |   CUCUMBER |   CABBAGE |   WATERMELON |   SORGHUM |   G'NUTS |   COWPEA |   MILLET |   SOYABEAN |   SWEET POTATO |
|-------:|:---------------|:----------------------------|--------:|-------:|----------:|------:|----------:|-----------:|---------:|---------:|--------------:|-------:|----------:|--------:|-----------:|----------:|-------------:|----------:|---------:|---------:|---------:|-----------:|---------------:|
|   2009 | WESTERN REGION | Shama Ahanta East           |    1270 |    130 |     18960 |   110 |       230 |       2820 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2009 | WESTERN REGION | West Ahanta                 |    1730 |    120 |     37850 |   100 |       840 |       1890 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2009 | WESTERN REGION | Mporhor Wassa East          |    2690 |    120 |     60350 |  1120 |      6880 |      15930 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2009 | WESTERN REGION | Wassa West                  |    2650 |   1660 |     39770 |   910 |      3050 |       9020 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2009 | WESTERN REGION | East Nzema                  |    2150 |    830 |     56360 |   100 |       570 |       3300 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2009 | WESTERN REGION | Jomoro                      |    1210 |   1160 |     47050 |    60 |       350 |       3310 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2009 | WESTERN REGION | Amanfi East                 |    8160 |   1430 |     48690 |  3830 |      7540 |      53850 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2009 | WESTERN REGION | Amanfi  West (Wassa Amanfi) |    7740 |   1780 |     33040 |  3740 |      5940 |      48020 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2009 | WESTERN REGION | Aowin -Suaman               |   13800 |   2460 |    104880 |  7340 |     35160 |      92110 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |
|   2009 | WESTERN REGION | Bibiani-Anhwiaso-Bekwai     |    7570 |   1750 |     69380 | 18610 |     46960 |     100880 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |         0 |        0 |        0 |        0 |          0 |              0 |


Table: 2011 (2)
|   Year | Region         | DISTRICTS                   |   Latitude |   Longitude |   MAIZE |   RICE |   CASSAVA |   YAM |   COCOYAM |   PLANTAIN |   GROUNDNUTS |   COWPEA |   Tomato |   Pepper |   Garden Eggs |   Okro |   Lettuce |   Onion |   Cucumber |   Cabbage |   Watermelon |   Carrot |   SORGHUM |   SOYBEAN |   MILLET |   SWEET POTATO |
|-------:|:---------------|:----------------------------|-----------:|------------:|--------:|-------:|----------:|------:|----------:|-----------:|-------------:|---------:|---------:|---------:|--------------:|-------:|----------:|--------:|-----------:|----------:|-------------:|---------:|----------:|----------:|---------:|---------------:|
|   2011 | WESTERN REGION | Shama Ahanta East           |    4.92482 |    -1.74458 |  1120   |  169.4 |     18240 |   147 |       294 |     3143   |            0 |        0 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |        0 |         0 |         0 |        0 |              0 |
|   2011 | WESTERN REGION | West Ahanta                 |    4.88993 |    -1.96434 |  1667.5 |  130.9 |     36800 |   144 |       960 |     2115   |            0 |        0 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |        0 |         0 |         0 |        0 |              0 |
|   2011 | WESTERN REGION | Mporhor Wassa East          |    5.13255 |    -1.75319 |  2772   |  146.4 |     60950 |   984 |      7440 |    15732.5 |            0 |        0 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |        0 |         0 |         0 |        0 |              0 |
|   2011 | WESTERN REGION | Wassa West                  |    5.43793 |    -2.14407 |  2596   | 1654.1 |     34400 |  1044 |      2850 |     8970   |            0 |        0 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |        0 |         0 |         0 |        0 |              0 |
|   2011 | WESTERN REGION | East Nzema                  |    5.03777 |    -2.4494  |  2154.6 |  854   |     54990 |   144 |       490 |     3447.5 |            0 |        0 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |        0 |         0 |         0 |        0 |              0 |
|   2011 | WESTERN REGION | Jomoro                      |    5.05314 |    -2.88944 |  1170   | 1213.8 |     45590 |    96 |       390 |     3240   |            0 |        0 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |        0 |         0 |         0 |        0 |              0 |
|   2011 | WESTERN REGION | Amenfi East                 |    5.79641 |    -2.42821 |  6348   | 1451.4 |     42930 |  3950 |      6984 |    50925   |            0 |        0 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |        0 |         0 |         0 |        0 |              0 |
|   2011 | WESTERN REGION | Amenfi  West (Wassa Amenfi) |    5.91924 |    -2.01533 |  6160   | 1930.5 |     32900 |  4080 |      4560 |    46080   |            0 |        0 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |        0 |         0 |         0 |        0 |              0 |
|   2011 | WESTERN REGION | Aowin -Suaman               |    5.82974 |    -2.82118 | 11534   | 2616.9 |     89835 |  5848 |     24480 |    90470   |            0 |        0 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |        0 |         0 |         0 |        0 |              0 |
|   2011 | WESTERN REGION | Bibiani-Anhwiaso-Bekwai     |    6.25618 |    -2.13631 |  6674   | 1937.2 |     73073 | 19890 |     37375 |    80190   |            0 |        0 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |        0 |         0 |         0 |        0 |              0 |


Table: 2011
|   Year | Region         | DISTRICTS                   |   MAIZE |   RICE |   CASSAVA |   YAM |   COCOYAM |   PLANTAIN |   GROUNDNUTS |   COWPEA |   Tomato |   Pepper |   Garden Eggs |   Okro |   Lettuce |   Onion |   Cucumber |   Cabbage |   Watermelon |   Carrot |   SORGHUM |   SOYBEAN |   MILLET |   SWEET POTATO |
|-------:|:---------------|:----------------------------|--------:|-------:|----------:|------:|----------:|-----------:|-------------:|---------:|---------:|---------:|--------------:|-------:|----------:|--------:|-----------:|----------:|-------------:|---------:|----------:|----------:|---------:|---------------:|
|   2011 | WESTERN REGION | Shama Ahanta East           |  1120   |  169.4 |     18240 |   147 |       294 |     3143   |            0 |        0 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |        0 |         0 |         0 |        0 |              0 |
|   2011 | WESTERN REGION | West Ahanta                 |  1667.5 |  130.9 |     36800 |   144 |       960 |     2115   |            0 |        0 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |        0 |         0 |         0 |        0 |              0 |
|   2011 | WESTERN REGION | Mporhor Wassa East          |  2772   |  146.4 |     60950 |   984 |      7440 |    15732.5 |            0 |        0 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |        0 |         0 |         0 |        0 |              0 |
|   2011 | WESTERN REGION | Wassa West                  |  2596   | 1654.1 |     34400 |  1044 |      2850 |     8970   |            0 |        0 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |        0 |         0 |         0 |        0 |              0 |
|   2011 | WESTERN REGION | East Nzema                  |  2154.6 |  854   |     54990 |   144 |       490 |     3447.5 |            0 |        0 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |        0 |         0 |         0 |        0 |              0 |
|   2011 | WESTERN REGION | Jomoro                      |  1170   | 1213.8 |     45590 |    96 |       390 |     3240   |            0 |        0 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |        0 |         0 |         0 |        0 |              0 |
|   2011 | WESTERN REGION | Amenfi East                 |  6348   | 1451.4 |     42930 |  3950 |      6984 |    50925   |            0 |        0 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |        0 |         0 |         0 |        0 |              0 |
|   2011 | WESTERN REGION | Amenfi  West (Wassa Amenfi) |  6160   | 1930.5 |     32900 |  4080 |      4560 |    46080   |            0 |        0 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |        0 |         0 |         0 |        0 |              0 |
|   2011 | WESTERN REGION | Aowin -Suaman               | 11534   | 2616.9 |     89835 |  5848 |     24480 |    90470   |            0 |        0 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |        0 |         0 |         0 |        0 |              0 |
|   2011 | WESTERN REGION | Bibiani-Anhwiaso-Bekwai     |  6674   | 1937.2 |     73073 | 19890 |     37375 |    80190   |            0 |        0 |        0 |        0 |             0 |      0 |         0 |       0 |          0 |         0 |            0 |        0 |         0 |         0 |        0 |              0 |


Table: Sheet1 (2)
|   NO. | COMPANY                           | ACTIVITY                                                                                     | DISTRICT                   | REGION        |   Employment |   Direct | Indirect   |
|------:|:----------------------------------|:---------------------------------------------------------------------------------------------|:---------------------------|:--------------|-------------:|---------:|:-----------|
|     1 | Pam Pharmaceuticals Ltd.          | Manufacture of Pharmaceutical products                                                       | Akwapim South              | Eastern       |          590 |      284 | 306        |
|     2 | Prefos Ghana Limited.             | Manufacture of street lights and poles including delivery of electrical and related services | Ejisu Municipal            | Ashanti       |          230 |      230 | -          |
|     3 | Brompton Portfolio                | Manufacturing toilet roll                                                                    | Akuapim South Municipal    | Eastern       |          105 |       25 | 80         |
|     4 | Profad Glazing System Limited     | Manufacturing roofing sheet                                                                  | Adentan Municipal Assembly | Greater Accra |           57 |       57 | -          |
|     5 | Osiadan Concretes Products        | Manufacturing of concrete                                                                    | Weija Gbawe                | Greater Accra |           15 |       15 | -          |
|       | Ltd                               | products                                                                                     |                            |               |              |          |            |
|     6 | Ankod Industries                  | Manufacturing and distribution of                                                            | Shai Osudoku               | Greater Accra |          120 |      120 | -          |
|       |                                   | roofing sheets, and related products                                                         |                            |               |              |          |            |
|     7 | Golden Milan Limited              | Manufacturing of aluminum                                                                    | Ningo Prampram             | Greater Accra |           65 |       65 | -          |
|       |                                   | profile to support the construction industry                                                 |                            |               |              |          |            |
|     8 | Zuriel Carbon                     | Manufacturing of briquettes from saw dust for the export market                              | Kwahu West                 | Eastern       |           91 |       30 | 61         |
|     9 | Skyline Steel Company Limited     | Manufacturing of steel roofing tiles                                                         | Ejisu                      | Ashanti       |           45 |       45 | -          |
|    10 | Springs and Bolts Company Limited | Manufacturing Of U-Bolts and Leaf Springs and Trailor                                        | Kumasi Asokwa              | Ashanti       |           65 |       65 | -          |
|       |                                   | Suspension                                                                                   |                            |               |              |          |            |


Table: Sheet1
|   NO. | COMPANY                           | ACTIVITY                                                                                     | DISTRICT                   | REGION        |   Employment |   Direct | Indirect   |
|------:|:----------------------------------|:---------------------------------------------------------------------------------------------|:---------------------------|:--------------|-------------:|---------:|:-----------|
|     1 | Pam Pharmaceuticals Ltd.          | Manufacture of Pharmaceutical products                                                       | Akwapim South              | Eastern       |          590 |      284 | 306        |
|     2 | Prefos Ghana Limited.             | Manufacture of street lights and poles including delivery of electrical and related services | Ejisu Municipal            | Ashanti       |          230 |      230 | -          |
|     3 | Brompton Portfolio                | Manufacturing toilet roll                                                                    | Akuapim South Municipal    | Eastern       |          105 |       25 | 80         |
|     4 | Profad Glazing System Limited     | Manufacturing roofing sheet                                                                  | Adentan Municipal Assembly | Greater Accra |           57 |       57 | -          |
|     5 | Osiadan Concretes Products        | Manufacturing of concrete                                                                    | Weija Gbawe                | Greater Accra |           15 |       15 | -          |
|       | Ltd                               | products                                                                                     |                            |               |              |          |            |
|     6 | Ankod Industries                  | Manufacturing and distribution of                                                            | Shai Osudoku               | Greater Accra |          120 |      120 | -          |
|       |                                   | roofing sheets, and related products                                                         |                            |               |              |          |            |
|     7 | Golden Milan Limited              | Manufacturing of aluminum                                                                    | Ningo Prampram             | Greater Accra |           65 |       65 | -          |
|       |                                   | profile to support the construction industry                                                 |                            |               |              |          |            |
|     8 | Zuriel Carbon                     | Manufacturing of briquettes from saw dust for the export market                              | Kwahu West                 | Eastern       |           91 |       30 | 61         |
|     9 | Skyline Steel Company Limited     | Manufacturing of steel roofing tiles                                                         | Ejisu                      | Ashanti       |           45 |       45 | -          |
|    10 | Springs and Bolts Company Limited | Manufacturing Of U-Bolts and Leaf Springs and Trailor                                        | Kumasi Asokwa              | Ashanti       |           65 |       65 | -          |
|       |                                   | Suspension                                                                                   |                            |               |              |          |            |

 


tables: name: 2006 (2)
data: 2006 (2).csv
name: 2006
data: 2006.csv
name: 2007 (2)
data: 2007 (2).csv
name: 2007
data: 2007.csv
name: 2008 (2)
data: 2008 (2).csv
name: 2008
data: 2008.csv
name: 2009 (2)
data: 2009 (2).csv
name: 2009
data: 2009.csv
name: 2011 (2)
data: 2011 (2).csv
name: 2011
data: 2011.csv
name: Sheet1 (2)
data: Sheet1 (2).csv
name: Sheet1
data: Sheet1.csv
label: 2008
DISTRICTS
2011
DISTRICTS
2008 (2)
DISTRICTS
2011
DISTRICTS
2011 (2)
DISTRICTS
2011
DISTRICTS
2008 (2)
DISTRICTS
2009
DISTRICTS
2006 (2)
DISTRICTS
2009
DISTRICTS
2009 (2)
DISTRICTS
2009
DISTRICTS
2007 (2)
DISTRICTS
2009
DISTRICTS
2008 (2)
DISTRICTS
2006
DISTRICTS
2008 (2)
DISTRICTS
2007
DISTRICTS
output: {
    "joins": [
        {
            "from_table": "2008",
            "from_column": "DISTRICTS",
            "to_table": "2011",
            "to_column": "DISTRICTS"
        },
        {
            "from_table": "2008 (2)",
            "from_column": "DISTRICTS",
            "to_table": "2011",
            "to_column": "DISTRICTS"
        },
        {
            "from_table": "2011 (2)",
            "from_column": "DISTRICTS",
            "to_table": "2011",
            "to_column": "DISTRICTS"
        },
        {
            "from_table": "2008 (2)",
            "from_column": "DISTRICTS",
            "to_table": "2009",
            "to_column": "DISTRICTS"
        },
        {
            "from_table": "2006 (2)",
            "from_column": "DISTRICTS",
            "to_table": "2009",
            "to_column": "DISTRICTS"
        },
        {
            "from_table": "2009 (2)",
            "from_column": "DISTRICTS",
            "to_table": "2009",
            "to_column": "DISTRICTS"
        },
        {
            "from_table": "2007 (2)",
            "from_column": "DISTRICTS",
            "to_table": "2009",
            "to_column": "DISTRICTS"
        },
        {
            "from_table": "2008 (2)",
            "from_column": "DISTRICTS",
            "to_table": "2006",
            "to_column": "DISTRICTS"
        },
        {
            "from_table": "2008 (2)",
            "from_column": "DISTRICTS",
            "to_table": "2007",
            "to_column": "DISTRICTS"
        }
    ]
}