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: Calendar
| Date                    |   Year | Month   |   Month Number | Quater   | Year-Mon   | IsToday       |   Week Number | Weekend_date            |   Index |
|:------------------------|-------:|:--------|---------------:|:---------|:-----------|:--------------|--------------:|:------------------------|--------:|
| 2020-07-01 00:00:00.000 |   2020 | July    |              7 | Q3       | Jul-20     | Previous_days |            27 | 2020-07-04 00:00:00.000 |     250 |
| 2020-07-02 00:00:00.000 |   2020 | July    |              7 | Q3       | Jul-20     | Previous_days |            27 | 2020-07-04 00:00:00.000 |     249 |
| 2020-07-03 00:00:00.000 |   2020 | July    |              7 | Q3       | Jul-20     | Previous_days |            27 | 2020-07-04 00:00:00.000 |     248 |
| 2020-07-04 00:00:00.000 |   2020 | July    |              7 | Q3       | Jul-20     | Previous_days |            27 | 2020-07-04 00:00:00.000 |     247 |
| 2020-07-05 00:00:00.000 |   2020 | July    |              7 | Q3       | Jul-20     | Previous_days |            28 | 2020-07-11 00:00:00.000 |     246 |
| 2020-07-06 00:00:00.000 |   2020 | July    |              7 | Q3       | Jul-20     | Previous_days |            28 | 2020-07-11 00:00:00.000 |     245 |
| 2020-07-07 00:00:00.000 |   2020 | July    |              7 | Q3       | Jul-20     | Previous_days |            28 | 2020-07-11 00:00:00.000 |     244 |
| 2020-07-08 00:00:00.000 |   2020 | July    |              7 | Q3       | Jul-20     | Previous_days |            28 | 2020-07-11 00:00:00.000 |     243 |
| 2020-07-09 00:00:00.000 |   2020 | July    |              7 | Q3       | Jul-20     | Previous_days |            28 | 2020-07-11 00:00:00.000 |     242 |
| 2020-07-10 00:00:00.000 |   2020 | July    |              7 | Q3       | Jul-20     | Previous_days |            28 | 2020-07-11 00:00:00.000 |     241 |


Table: Census2019
|   FIPS | County    | State   |   Population Count |
|-------:|:----------|:--------|-------------------:|
|  48001 | Anderson  | Texas   |               1527 |
|  48003 | Andrews   | Texas   |                811 |
|  48005 | Angelina  | Texas   |               3063 |
|  48007 | Aransas   | Texas   |                727 |
|  48009 | Archer    | Texas   |                212 |
|  48011 | Armstrong | Texas   |                 48 |
|  48013 | Atascosa  | Texas   |               1717 |
|  48015 | Austin    | Texas   |                860 |
|  48017 | Bailey    | Texas   |                228 |
|  48019 | Bandera   | Texas   |                480 |


Table: Counties
|   Fips_code | County     | State   |
|------------:|:-----------|:--------|
|       48029 | Bexar      | Texas   |
|       48157 | Fort Bend  | Texas   |
|       48201 | Harris     | Texas   |
|       48085 | Collin     | Texas   |
|       48113 | Dallas     | Texas   |
|       48339 | Montgomery | Texas   |
|       48439 | Tarrant    | Texas   |
|       48183 | Gregg      | Texas   |
|       48027 | Bell       | Texas   |
|       48141 | El Paso    | Texas   |


Table: Mask_use_by_county
|   COUNTYFP |   NEVER |   RARELY |   SOMETIMES |   FREQUENTLY |   ALWAYS |
|-----------:|--------:|---------:|------------:|-------------:|---------:|
|       1001 |   0.053 |    0.074 |       0.134 |        0.295 |    0.444 |
|       1003 |   0.083 |    0.059 |       0.098 |        0.323 |    0.436 |
|       1005 |   0.067 |    0.121 |       0.12  |        0.201 |    0.491 |
|       1007 |   0.02  |    0.034 |       0.096 |        0.278 |    0.572 |
|       1009 |   0.053 |    0.114 |       0.18  |        0.194 |    0.459 |
|       1011 |   0.031 |    0.04  |       0.144 |        0.286 |    0.5   |
|       1013 |   0.102 |    0.053 |       0.257 |        0.137 |    0.451 |
|       1015 |   0.152 |    0.108 |       0.13  |        0.167 |    0.442 |
|       1017 |   0.117 |    0.037 |       0.15  |        0.136 |    0.56  |
|       1019 |   0.135 |    0.027 |       0.161 |        0.158 |    0.52  |


Table: References
| Data Source                         | Metrics                                                          | URL                                            |   Order |
|:------------------------------------|:-----------------------------------------------------------------|:-----------------------------------------------|--------:|
| New York Times Github Repository    | COVID-19 Confirmed Cases and Deaths by County since Jan 21, 2020 | https://github.com/nytimes/covid-19-data       |       1 |
| US Census                           | Population broken out at County & State                          | https://data.census.gov/cedsci/                |       2 |
| Report Author - Sai Dheeraj Tanneru | Sai Dheeraj's LinkedIn profile                                   | https://www.linkedin.com/in/saidheerajtanneru/ |       3 |


Table: Top N
|   Top N |
|--------:|
|       1 |
|       2 |
|       3 |
|       4 |
|       5 |
|       6 |
|       7 |
|       8 |
|       9 |
|      10 |


Table: US_counties-cases
| Date                    | County   | State   |   Cases |   Deaths |   Fips_code |
|:------------------------|:---------|:--------|--------:|---------:|------------:|
| 2020-11-17 00:00:00.000 | Loving   | Texas   |       1 |        0 |       48301 |
| 2020-11-18 00:00:00.000 | Loving   | Texas   |       1 |        0 |       48301 |
| 2020-11-19 00:00:00.000 | Loving   | Texas   |       1 |        0 |       48301 |
| 2020-11-20 00:00:00.000 | Loving   | Texas   |       1 |        0 |       48301 |
| 2020-11-21 00:00:00.000 | Loving   | Texas   |       1 |        0 |       48301 |
| 2020-11-22 00:00:00.000 | Loving   | Texas   |       1 |        0 |       48301 |
| 2020-11-23 00:00:00.000 | Loving   | Texas   |       1 |        0 |       48301 |
| 2020-11-24 00:00:00.000 | Loving   | Texas   |       1 |        0 |       48301 |
| 2020-11-25 00:00:00.000 | Loving   | Texas   |       1 |        0 |       48301 |
| 2020-11-26 00:00:00.000 | Loving   | Texas   |       1 |        0 |       48301 |

 


tables: name: Calendar
data: Calendar.csv
name: Census2019
data: Census2019.csv
name: Counties
data: Counties.csv
name: Mask_use_by_county
data: Mask_use_by_county.csv
name: References
data: References.csv
name: Top N
data: Top N.csv
name: US_counties-cases
data: US_counties-cases.csv
label: US_counties-cases
Fips_code
Counties
Fips_code
Census2019
FIPS
Counties
Fips_code
Mask_use_by_county
COUNTYFP
Counties
Fips_code
output: {
    "joins": [
        {
            "from_table": "US_counties-cases",
            "from_column": "Fips_code",
            "to_table": "Counties",
            "to_column": "Fips_code"
        },
        {
            "from_table": "Census2019",
            "from_column": "FIPS",
            "to_table": "Counties",
            "to_column": "Fips_code"
        },
        {
            "from_table": "Mask_use_by_county",
            "from_column": "COUNTYFP",
            "to_table": "Counties",
            "to_column": "Fips_code"
        }
    ]
}