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: Adult Asthma
|   State Code | State    |   CensusTract |   Year |   Value | Data Comment   | 95% Confidence Interval   |   Confidence Interval Low |   Confidence Interval High |
|-------------:|:---------|--------------:|-------:|--------:|:---------------|:--------------------------|--------------------------:|---------------------------:|
|           36 | New York |   36001000403 |   2018 |   0.102 |                | (9.7% - 10.8%)            |                     0.097 |                      0.108 |
|           36 | New York |   36001013706 |   2018 |   0.099 |                | (9.2% - 10.8%)            |                     0.092 |                      0.108 |
|           36 | New York |   36001014501 |   2018 |   0.102 |                | (9.8% - 10.8%)            |                     0.098 |                      0.108 |
|           36 | New York |   36001014502 |   2018 |   0.104 |                | (10.1% - 10.8%)           |                     0.101 |                      0.108 |
|           36 | New York |   36005008400 |   2018 |   0.102 |                | (9.6% - 10.8%)            |                     0.096 |                      0.108 |
|           36 | New York |   36005009800 |   2018 |   0.103 |                | (9.6% - 10.8%)            |                     0.096 |                      0.108 |
|           36 | New York |   36005015200 |   2018 |   0.102 |                | (9.7% - 10.8%)            |                     0.097 |                      0.108 |
|           36 | New York |   36005026100 |   2018 |   0.103 |                | (9.6% - 10.8%)            |                     0.096 |                      0.108 |
|           36 | New York |   36005027401 |   2018 |   0.101 |                | (9.6% - 10.8%)            |                     0.096 |                      0.108 |
|           36 | New York |   36005028800 |   2018 |   0.102 |                | (9.6% - 10.8%)            |                     0.096 |                      0.108 |


Table: Air Toxic Concentrations (Year Values)
|   Air Toxin Index | Air Toxin Name       |    Value |   Year |
|------------------:|:---------------------|---------:|-------:|
|                 7 | Acetaldehyde         | 1.58553  |   2005 |
|                24 | Benzene              | 1.07326  |   2005 |
|                41 | 1,3-Butadiene        | 0.144916 |   2005 |
|                57 | Carbon tetrachloride | 0.66082  |   2005 |
|                68 | Formaldehyde         | 2.81808  |   2005 |
|                 7 | Acetaldehyde         | 1.29771  |   2006 |
|                24 | Benzene              | 1.01478  |   2006 |
|                41 | 1,3-Butadiene        | 0.103184 |   2006 |
|                57 | Carbon tetrachloride | 0.624721 |   2006 |
|                68 | Formaldehyde         | 2.50965  |   2006 |


Table: Air Toxic Concentrations
|   Air Toxin Index | Air Toxin Name   |   Site Code | CITY          | STATE   |   MONITOR_LATITUDE |   MONITOR_LONGITUDE | County               | LOCATION_TYPE         |     2005 |     2006 |     2007 |     2008 |     2009 |     2010 |     2011 |     2012 |     2013 |     2014 |     2015 |     2016 |     2017 |     2018 |
|------------------:|:-----------------|------------:|:--------------|:--------|-------------------:|--------------------:|:---------------------|:----------------------|---------:|---------:|---------:|---------:|---------:|---------:|---------:|---------:|---------:|---------:|---------:|---------:|---------:|---------:|
|                 1 | Acetaldehyde     |   110010043 | Washington    | DC      |            38.9218 |            -77.0132 | District of Columbia | URBAN AND CENTER CITY | 0.948572 | 1.17049  | 1.10587  | 0.912627 | 0.733922 | 0.951627 | 0.918493 | 0.874341 | 0.516241 | 0.772078 | 1.25031  | 1.00987  | 0.765686 | 0.800124 |
|                 2 | Acetaldehyde     |   240053001 | Baltimore     | MD      |            39.3108 |            -76.4744 | Essex                | SUBURBAN              | 0.429495 | 0.201322 | 0.945281 | 0.718095 | 0.547818 | 0.692828 | 0.473151 | 0.810581 | 0.449882 | 0.573049 | 4.37612  | 3.32584  | 0.611042 | 0.770664 |
|                 3 | Acetaldehyde     |   340273001 | NOT IN A CITY | NJ      |            40.7876 |            -74.6763 | Morris               | RURAL                 | 1.57561  | 1.20055  | 1.31245  | 1.43393  | 1.36874  | 1.32693  | 1.64233  | 1.53905  | 1.33833  | 1.284    | 1.24874  | 1.21348  | 1.15057  | 1.03303  |
|                 4 | Acetaldehyde     |   340390004 | Elizabeth     | NJ      |            40.6414 |            -74.2084 | Union                | SUBURBAN              | 5.23669  | 5.76529  | 5.97883  | 2.42235  | 2.55629  | 2.81285  | 3.35157  | 2.74687  | 2.69917  | 2.89293  | 2.57256  | 2.58163  | 2.56463  | 2.35227  |
|                 5 | Acetaldehyde     |   360310003 | SUNY          | NY      |            44.3931 |            -73.8589 | Essex                | RURAL                 | 0.287657 | 0.79167  | 0.548007 | 0.537828 | 0.544007 | 0.501643 | 0.522264 | 0.615973 | 0.666141 | 0.517042 | 0.613315 | 0.756854 | 0.519729 | 0.938093 |
|                 6 | Acetaldehyde     |   360551007 | Rochester     | NY      |            43.1462 |            -77.5482 | Monroe               | URBAN AND CENTER CITY | 0.81344  | 0.573684 | 0.947234 | 1.20497  | 0.920708 | 0.932798 | 0.88776  | 0.971274 | 1.12506  | 1.00087  | 1.0728   | 1.12412  | 1.02001  | 1.00898  |
|                 7 | Acetaldehyde     |   360810124 | New York City | NY      |            40.7361 |            -73.8215 | Queens               | URBAN AND CENTER CITY | 1.58553  | 1.29771  | 1.31648  | 1.41458  | 1.27058  | 1.39889  | 1.18246  | 1.30127  | 1.82045  | 1.21914  | 2.36478  | 1.47131  | 2.9385   | 1.76263  |
|                 8 | Acetaldehyde     |   360850111 | New York City | NY      |            40.5803 |            -74.1983 | Richmond             | SUBURBAN              | 1.9234   | 1.37579  | 1.44273  | 1.64803  | 1.50764  | 1.88067  | 1.48401  | 2.15223  | 1.44681  | 1.41161  | 1.67609  | 1.75646  | 1.82843  | 1.65853  |
|                 9 | Acetaldehyde     |   420030031 | PITTSBURGH    | PA      |            40.4434 |            -79.9903 | Allegheny            | URBAN AND CENTER CITY | 1.59747  | 1.79171  | 1.84875  | 1.42788  | 1.40935  | 1.61399  | 1.51595  | 1.61682  | 1.25115  | 1.47372  | 1.628    | 1.54967  | 1.27001  | 1.39297  |
|                10 | Acetaldehyde     |   421010014 | PHILADELPHIA  | PA      |            40.0496 |            -75.2408 | Philadelphia         | SUBURBAN              | 1.64767  | 1.65933  | 1.94821  | 2.22101  | 1.13875  | 0.801234 | 0.866122 | 1.24595  | 1.86057  | 2.20245  | 2.04505  | 1.86783  | 1.54616  | 1.54616  |


Table: Air Toxins Master Table
| Air Toxin Name       |
|:---------------------|
| Acetaldehyde         |
| Benzene              |
| 1,3-Butadiene        |
| Carbon tetrachloride |
| Formaldehyde         |


Table: Child Asthma
| State    |   Year | Value              | Data Comment   | Race Ethnicity                    | Value Number   | Comment   |
|:---------|-------:|:-------------------|:---------------|:----------------------------------|:---------------|:----------|
| Delaware |   2011 | Data Not Collected |                | *State Total                      |                | No data   |
| Delaware |   2011 | Data Not Collected |                | Black not including Hispanic      |                | No data   |
| Delaware |   2011 | Data Not Collected |                | Hispanic                          |                | No data   |
| Delaware |   2011 | Data Not Collected |                | Multi Race not including Hispanic |                | No data   |
| Delaware |   2011 | Data Not Collected |                | Other not including Hispanic      |                | No data   |
| Delaware |   2011 | Data Not Collected |                | White not including Hispanic      |                | No data   |
| Delaware |   2012 | Data Not Collected |                | *State Total                      |                | No data   |
| Delaware |   2012 | Data Not Collected |                | Black not including Hispanic      |                | No data   |
| Delaware |   2012 | Data Not Collected |                | Hispanic                          |                | No data   |
| Delaware |   2012 | Data Not Collected |                | Multi Race not including Hispanic |                | No data   |


Table: Contamination
| State   | Site Name   | Fiscal Year   | Site ID   | Primary Latitude   | Primary Longitude   | HE Status   |
|:--------|:------------|:--------------|:----------|:-------------------|:--------------------|:------------|
|         |             |               |           |                    |                     |             |
|         |             |               |           |                    |                     |             |
|         |             |               |           |                    |                     |             |
|         |             |               |           |                    |                     |             |
|         |             |               |           |                    |                     |             |
|         |             |               |           |                    |                     |             |
|         |             |               |           |                    |                     |             |
|         |             |               |           |                    |                     |             |
|         |             |               |           |                    |                     |             |
|         |             |               |           |                    |                     |             |


Table: Data Collection Site Name
| Data Collection Site Name                  | State Abbreviation   |
|:-------------------------------------------|:---------------------|
| Albany International Airport               | NY                   |
| Lehigh Valley International Airport        | PA                   |
| Buffalo Niagara International Airport      | NY                   |
| Baltimore/Washington International Airport | MD                   |
| Yeager Airport                             | WV                   |
| Ronald Reagan Washington National Airport  | DC                   |
| Dover, Delaware                            | DE                   |
| Erie International Airport                 | PA                   |
| John F. Kennedy International Airport      | NY                   |
| LaGuardia Airport                          | NY                   |


Table: HE Sort
| HE Status               |   Sort | Short HE Status   |
|:------------------------|-------:|:------------------|
| No concern for exposure |      0 | No concern        |
| Insufficient Data       |      1 | Insufficient Data |
| Potential for exposure  |      2 | Potential         |


Table: Human Exposure to Contamination
| State   | Site Name   | Fiscal Year   | Site ID   | Primary Latitude   | Primary Longitude   | HE Status   | HE status new   |
|:--------|:------------|:--------------|:----------|:-------------------|:--------------------|:------------|:----------------|
|         |             |               |           |                    |                     |             |                 |
|         |             |               |           |                    |                     |             |                 |
|         |             |               |           |                    |                     |             |                 |
|         |             |               |           |                    |                     |             |                 |
|         |             |               |           |                    |                     |             |                 |
|         |             |               |           |                    |                     |             |                 |
|         |             |               |           |                    |                     |             |                 |
|         |             |               |           |                    |                     |             |                 |
|         |             |               |           |                    |                     |             |                 |
|         |             |               |           |                    |                     |             |                 |


Table: k03_Final_trends___final_ann_avg_Crosstab
| Air Toxin Name   |   Site Code |
|:-----------------|------------:|
| Acetaldehyde     |   110010043 |
| Acetaldehyde     |   240053001 |
| Acetaldehyde     |   340273001 |
| Acetaldehyde     |   340390004 |
| Acetaldehyde     |   360310003 |
| Acetaldehyde     |   360551007 |
| Acetaldehyde     |   360810124 |
| Acetaldehyde     |   360850111 |
| Acetaldehyde     |   420030031 |
| Acetaldehyde     |   421010014 |


Table: Rainfall (Locations)
|   Site Latitude |   Site Longitude | Data Collection Site Name    | State Abbreviation   |
|----------------:|-----------------:|:-----------------------------|:---------------------|
|         42.7422 |         -73.8094 | Albany International Airport | NY                   |
|         42.7422 |         -73.8094 | Albany International Airport | NY                   |
|         42.7422 |         -73.8094 | Albany International Airport | NY                   |
|         42.7422 |         -73.8094 | Albany International Airport | NY                   |
|         42.7422 |         -73.8094 | Albany International Airport | NY                   |
|         42.7422 |         -73.8094 | Albany International Airport | NY                   |
|         42.7422 |         -73.8094 | Albany International Airport | NY                   |
|         42.7422 |         -73.8094 | Albany International Airport | NY                   |
|         42.7422 |         -73.8094 | Albany International Airport | NY                   |
|         42.7422 |         -73.8094 | Albany International Airport | NY                   |


Table: Rainfall (Rainfall)
| Data Collection Site Name    |   Year | Rainfall Category          |   Number of Days | Rainfall Category (inches)   | Rainfall Category (rain or no rain)   |
|:-----------------------------|-------:|:---------------------------|-----------------:|:-----------------------------|:--------------------------------------|
| Albany International Airport |   1953 | Frequency in >2in rainfall |                0 | > 2.0 in                     | Rain                                  |
| Albany International Airport |   1955 | Frequency in >2in rainfall |                0 | > 2.0 in                     | Rain                                  |
| Albany International Airport |   1956 | Frequency in >2in rainfall |                0 | > 2.0 in                     | Rain                                  |
| Albany International Airport |   1957 | Frequency in >2in rainfall |                0 | > 2.0 in                     | Rain                                  |
| Albany International Airport |   1958 | Frequency in >2in rainfall |                0 | > 2.0 in                     | Rain                                  |
| Albany International Airport |   1959 | Frequency in >2in rainfall |                0 | > 2.0 in                     | Rain                                  |
| Albany International Airport |   1962 | Frequency in >2in rainfall |                0 | > 2.0 in                     | Rain                                  |
| Albany International Airport |   1963 | Frequency in >2in rainfall |                0 | > 2.0 in                     | Rain                                  |
| Albany International Airport |   1964 | Frequency in >2in rainfall |                0 | > 2.0 in                     | Rain                                  |
| Albany International Airport |   1965 | Frequency in >2in rainfall |                0 | > 2.0 in                     | Rain                                  |


Table: Rainfall
|   Site Latitude |   Site Longitude | Data Collection Site Name             |   Year Summary |   Frequency in >2in rainfall |   Frequency in >1in rainfall |   Frequency in > 0.5in |   Frequency in 0 inches |
|----------------:|-----------------:|:--------------------------------------|---------------:|-----------------------------:|-----------------------------:|-----------------------:|------------------------:|
|         42.7422 |         -73.8094 | Albany International Airport          |           1957 |                            0 |                            5 |                     16 |                     243 |
|         42.7422 |         -73.8094 | Albany International Airport          |           1958 |                            0 |                            5 |                     18 |                     227 |
|         42.7422 |         -73.8094 | Albany International Airport          |           1967 |                            0 |                            5 |                     23 |                     226 |
|         42.7422 |         -73.8094 | Albany International Airport          |           1978 |                            0 |                            5 |                     24 |                     239 |
|         40.6529 |         -75.4365 | Lehigh Valley International Airport   |           1992 |                            0 |                            5 |                     26 |                     232 |
|         42.9311 |         -78.7373 | Buffalo Niagara International Airport |           1956 |                            0 |                            5 |                     27 |                     189 |
|         42.9311 |         -78.7373 | Buffalo Niagara International Airport |           1961 |                            0 |                            5 |                     22 |                     188 |
|         42.9311 |         -78.7373 | Buffalo Niagara International Airport |           1972 |                            0 |                            5 |                     24 |                     169 |
|         42.9311 |         -78.7373 | Buffalo Niagara International Airport |           1981 |                            0 |                            5 |                     23 |                     195 |
|         42.9311 |         -78.7373 | Buffalo Niagara International Airport |           1988 |                            0 |                            5 |                     23 |                     208 |


Table: State Populations
| State                |   2018 Population |
|:---------------------|------------------:|
| New York             |          19862512 |
| Pennsylvania         |          12823989 |
| New Jersey           |           9032872 |
| Virginia             |           8525660 |
| Maryland             |           6079602 |
| West Virginia        |           1803077 |
| Delaware             |            971180 |
| District of Columbia |            703608 |


Table: State table
| State Name           | State Code   |
|:---------------------|:-------------|
| Delaware             | DE           |
| District of Columbia | DC           |
| Maryland             | MD           |
| New Jersey           | NJ           |
| New York             | NY           |
| Pennsylvania         | PA           |
| Virginia             | VA           |
| West Virginia        | WV           |


Table: Year Table
|   Year |
|-------:|
|   1950 |
|   1951 |
|   1952 |
|   1953 |
|   1954 |
|   1955 |
|   1956 |
|   1957 |
|   1958 |
|   1959 |

 


tables: name: Adult Asthma
data: Adult Asthma.csv
name: Air Toxic Concentrations (Year Values)
data: Air Toxic Concentrations (Year Values).csv
name: Air Toxic Concentrations
data: Air Toxic Concentrations.csv
name: Air Toxins Master Table
data: Air Toxins Master Table.csv
name: Child Asthma
data: Child Asthma.csv
name: Contamination
data: Contamination.csv
name: Data Collection Site Name
data: Data Collection Site Name.csv
name: HE Sort
data: HE Sort.csv
name: Human Exposure to Contamination
data: Human Exposure to Contamination.csv
name: k03_Final_trends___final_ann_avg_Crosstab
data: k03_Final_trends___final_ann_avg_Crosstab.csv
name: Rainfall (Locations)
data: Rainfall (Locations).csv
name: Rainfall (Rainfall)
data: Rainfall (Rainfall).csv
name: Rainfall
data: Rainfall.csv
name: State Populations
data: State Populations.csv
name: State table
data: State table.csv
name: Year Table
data: Year Table.csv
label: Child Asthma
Year
Year Table
Year
State table
State Name
State Populations
State
Contamination
State
State table
State Code
Child Asthma
State
State table
State Name
Adult Asthma
State
State table
State Name
Adult Asthma
Year
Year Table
Year
Air Toxic Concentrations (Year Values)
Air Toxin Index
Air Toxic Concentrations
Air Toxin Index
Air Toxic Concentrations (Year Values)
Year
Year Table
Year
Air Toxic Concentrations
STATE
State table
State Code
Contamination
HE Status
HE Sort
HE Status
Human Exposure to Contamination
HE Status
HE Sort
HE Status
Rainfall (Locations)
Data Collection Site Name
Rainfall (Rainfall)
Data Collection Site Name
Rainfall (Rainfall)
Number of Days
Year Table
Year
Contamination
Fiscal Year
Year Table
Year
Data Collection Site Name
State Abbreviation
State table
State Code
Rainfall (Locations)
State Abbreviation
State table
State Code
output: {
    "joins": [
        {
            "from_table": "Child Asthma",
            "from_column": "Year",
            "to_table": "Year Table",
            "to_column": "Year"
        },
        {
            "from_table": "State table",
            "from_column": "State Name",
            "to_table": "State Populations",
            "to_column": "State"
        },
        {
            "from_table": "Contamination",
            "from_column": "State",
            "to_table": "State table",
            "to_column": "State Code"
        },
        {
            "from_table": "Child Asthma",
            "from_column": "State",
            "to_table": "State table",
            "to_column": "State Name"
        },
        {
            "from_table": "Adult Asthma",
            "from_column": "State",
            "to_table": "State table",
            "to_column": "State Name"
        },
        {
            "from_table": "Adult Asthma",
            "from_column": "Year",
            "to_table": "Year Table",
            "to_column": "Year"
        },
        {
            "from_table": "Air Toxic Concentrations (Year Values)",
            "from_column": "Air Toxin Index",
            "to_table": "Air Toxic Concentrations",
            "to_column": "Air Toxin Index"
        },
        {
            "from_table": "Air Toxic Concentrations (Year Values)",
            "from_column": "Year",
            "to_table": "Year Table",
            "to_column": "Year"
        },
        {
            "from_table": "Air Toxic Concentrations",
            "from_column": "STATE",
            "to_table": "State table",
            "to_column": "State Code"
        },
        {
            "from_table": "Contamination",
            "from_column": "HE Status",
            "to_table": "HE Sort",
            "to_column": "HE Status"
        },
        {
            "from_table": "Human Exposure to Contamination",
            "from_column": "HE Status",
            "to_table": "HE Sort",
            "to_column": "HE Status"
        },
        {
            "from_table": "Rainfall (Locations)",
            "from_column": "Data Collection Site Name",
            "to_table": "Rainfall (Rainfall)",
            "to_column": "Data Collection Site Name"
        },
        {
            "from_table": "Rainfall (Rainfall)",
            "from_column": "Number of Days",
            "to_table": "Year Table",
            "to_column": "Year"
        },
        {
            "from_table": "Contamination",
            "from_column": "Fiscal Year",
            "to_table": "Year Table",
            "to_column": "Year"
        },
        {
            "from_table": "Data Collection Site Name",
            "from_column": "State Abbreviation",
            "to_table": "State table",
            "to_column": "State Code"
        },
        {
            "from_table": "Rainfall (Locations)",
            "from_column": "State Abbreviation",
            "to_table": "State table",
            "to_column": "State Code"
        }
    ]
}