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: Imo Rep race
| State   | Constituency            | Rep                         | Gender   | Party   | Previous Party   | Prev Rep                        | Gender_1   |
|:--------|:------------------------|:----------------------------|:---------|:--------|:-----------------|:--------------------------------|:-----------|
| IMO     | ABO-MBAISE / NGOR       | BEDE UCHENNA EKE            | M        | PDP     | PDP              | BEDE EKE UCHENNA                | M          |
|         | OKPALA                  |                             |          |         |                  |                                 |            |
| IMO     | AHIAZU MBAISE /         | EMEKA MARTINS CHINEDU       | M        | PDP     | PDP              | RAPHAEL UZOCHI IGBOKWE          | M          |
|         | EZINIHITTE              |                             |          |         |                  |                                 |            |
| IMO     | EHIME MBANO / IHITE     | PENDING                     |          |         | APC              | CHIKE JOHN OKAFOR               | M          |
|         | UBOMA / OBOWO           |                             |          |         |                  |                                 |            |
| IMO     | IDEATO NORTH / IDEATO   | PASCHAL OBI                 | M        | AA      | APC              | CHUKWUKERE AUSTINE IKECHUKWU O. | M          |
|         | SOUTH                   |                             |          |         |                  |                                 |            |
| IMO     | IKEDURU / MBAITOLI      | NWAWUBA HENRY NDOCHUKWU     | M        | PDP     | PDP              | NWAWUBA HENRY UGOCHUKWU         | M          |
| IMO     | ISIALA MBANO / OKIGWE / | ONWUBUARIRI OBINNA KINGSLEY | M        | PDP     | PDP              | ONWUBUARIA KINSLEY OBINNA       | M          |
|         | ONUIMO                  |                             |          |         |                  |                                 |            |
| IMO     | ISU/NJABA / NKWERE /    | UGONNA OZURIGBO             | M        | APC     | PDP              | CHUKWUDI VICTOR JONES ONYERERI  | M          |
|         | NWANGELE                |                             |          |         |                  |                                 |            |
| IMO     | OGUTA / OHAJI-EGBEMA /  | KINGSLEY C. UJU             | M        | AA      | PDP              | GOODLUCK OPIA NANAH             | M          |
|         | ORU WEST                |                             |          |         |                  |                                 |            |
| IMO     | ORU EAST / ORSU / ORLU  | JERRY ALAGBAOSO             | M        | PDP     |                  |                                 |            |
| IMO     | OWERRI MUNICIPAL/       | ELEZIEANYA IKENNA           | M        | PDP     | PDP              | EZENWA ONYEWUCHI                | M          |
|         | OWERRI NORTH / OWERRI   | ONYECHERE                   |          |         |                  |                                 |            |
|         | WEST                    |                             |          |         |                  |                                 |            |


Table: Senatorial
| State   | Federal Constituency   | Senator                           | Gender   | Party   | Prev Party   | Prev Senator                   |
|:--------|:-----------------------|:----------------------------------|:---------|:--------|:-------------|:-------------------------------|
| LAGOS   | CENTRAL                | TINUBU OLUREMI SHADE              | F        | APC     | APC          | Sen. OLUREMI TINUBU            |
| LAGOS   | EAST                   | OSINOWO SIKIRU ADEBAYO            | M        | APC     | APC          | Sen. BAREEHU ASHAFA            |
| LAGOS   | WEST                   | ADEOLA SOLOMAN OLAMILEKAN         | M        | APC     | APC          | Sen. OLAMILEKAN ADEOLA         |
| EDO     | CENTRAL                | ORDIA AKHIMIENMONA CLIFFFORD      | M        | PDP     | PDP          | Sen. ORDIA CLIFFORD            |
| EDO     | NORTH                  | ALIMIKHENA FRANCIS ASEKHAME       | M        | APC     | APC          | Sen. ALIMIKHENA FRANCIS        |
| EDO     | SOUTH                  | URHOGHIDE MATTHEW AISAGBONRIODION | M        | PDP     | PDP          | Sen. AISAGBONRIODION URHOGHIDE |
| ANAMBRA | NORTH                  | ODUAH STELLA ADAEZE PRINCESS      | F        | PDP     | PDP          | Sen. ODUAH STELLA              |
| ANAMBRA | CENTRAL                | UCHE LILIAN EKWUNIFE              | F        | PDP     | APGA         | Sen. VICTOR UMEH               |
| ANAMBRA | SOUTH                  | PATRICK IFEANYI UBAH              | M        | YPP     | PDP          | Sen. EMMANUEL UBA              |
| OYO     | CENTRAL                | FOLARIN TESLIM KOLAWOLE           | M        | APC     | PDP          | Sen. MONSURAT SUNMONU          |


Table: Sheet1
| Zone   | State         |
|:-------|:--------------|
| NC     | Benue State   |
| NC     | Plateau State |
| NE     | Adamawa State |
| NE     | Taraba State  |
| NW     | Kaduna State  |
| NW     | Kano State    |
| SE     | Anambra State |
| SE     | Imo State     |
| SS     | Edo State     |
| SS     | Rivers State  |


Table: Sheet10
| State         | LGAs          | Volunteers Base   |   Policy House Held | APC vote   | PDP Votes   | APC+PDP+Others   | Est. Voters TurnOut=(APC+PDP+Other)/Age Group (20-50)   |   Population |   Age Group (20-50) |   overallAG |   overallVB |   OverAll PHH |   Weight |     Score |
|:--------------|:--------------|:------------------|--------------------:|:-----------|:------------|:-----------------|:--------------------------------------------------------|-------------:|--------------------:|------------:|------------:|--------------:|---------:|----------:|
| Anambra State | Awka South    | 4                 |                   0 |            |             |                  |                                                         |       450017 |              182918 |   0.155077  |         0.8 |             0 | 0.955077 | 0.238769  |
| Anambra State | Njikoka       | 2                 |                   0 |            |             |                  |                                                         |       284927 |              115118 |   0.0975963 |         0.4 |             0 | 0.497596 | 0.124399  |
| Anambra State | Onitsha North | 2                 |                   0 |            |             |                  |                                                         |       142259 |               67270 |   0.057031  |         0.4 |             0 | 0.457031 | 0.114258  |
| Anambra State | Aguata        | 1                 |                   0 |            |             |                  |                                                         |       742601 |              290051 |   0.245903  |         0.2 |             0 | 0.445903 | 0.111476  |
| Anambra State | Idemili South | 1                 |                   0 |            |             |                  |                                                         |       332090 |              129802 |   0.110045  |         0.2 |             0 | 0.310045 | 0.0775113 |
| Anambra State | Idemili North |                   |                   0 |            |             |                  |                                                         |       695510 |              288870 |   0.244902  |         0   |             0 | 0.244902 | 0.0612255 |
| Anambra State | Ihiala        |                   |                   0 |            |             |                  |                                                         |       561834 |              205634 |   0.174335  |         0   |             0 | 0.174335 | 0.0435838 |
| Anambra State | Ekwusigo      |                   |                   0 |            |             |                  |                                                         |       346834 |              135158 |   0.114586  |         0   |             0 | 0.114586 | 0.0286465 |
| Anambra State | Nnewi North   |                   |                   0 |            |             |                  |                                                         |       331500 |              125205 |   0.106148  |         0   |             0 | 0.106148 | 0.026537  |
| Anambra State | Nnewi South   |                   |                   0 |            |             |                  |                                                         |       345773 |              124942 |   0.105925  |         0   |             0 | 0.105925 | 0.0264812 |


Table: Sheet11
| State       | LGAs         |   Volunteers Base |   Policy House Held |   APC vote |   PDP Votes | Others   |   Est. Turnout |   APC vote_1 |   PDP Votes_2 | Others_3   |   Turnout |   Population |   Age Group (20-50) |   Overall Fed Election Turnout |   Overall  State ElectTurnOut |   overallAG |   overallVB |   OverAll PHH |   Weight |     Score |
|:------------|:-------------|------------------:|--------------------:|-----------:|------------:|:---------|---------------:|-------------:|--------------:|:-----------|----------:|-------------:|--------------------:|-------------------------------:|------------------------------:|------------:|------------:|--------------:|---------:|----------:|
| Lagos State | Alimosho     |                32 |                   0 |      65206 |       44461 |          |       0.16017  |        78379 |         22135 |            |  0.146802 |      1817200 |              684691 |                       0.136478 |                      0.129479 |   0.13792   |   0.426667  |             0 | 0.830544 | 0.075504  |
| Lagos State | Ibeju-Lekki  |                 3 |                   0 |      12179 |        9222 |          |       0.380984 |        23298 |          3320 |            |  0.473858 |       162200 |               56173 |                       0.32463  |                      0.417942 |   0.0113152 |   0.04      |             0 | 0.793888 | 0.0721716 |
| Lagos State | Epe          |                 1 |                   0 |      17710 |       13305 |          |       0.371428 |        35609 |          6464 |            |  0.503856 |       250300 |               83502 |                       0.316488 |                      0.444401 |   0.0168201 |   0.0133333 |             0 | 0.791043 | 0.071913  |
| Lagos State | Ikorodu      |                16 |                   0 |      40719 |       21252 |          |       0.230517 |        45879 |         14769 |            |  0.225596 |       727000 |              268835 |                       0.19642  |                      0.198975 |   0.0541525 |   0.213333  |             0 | 0.662881 | 0.0602619 |
| Lagos State | Badagry      |                 3 |                   0 |      21417 |       17936 |          |       0.336624 |        28921 |         10089 |            |  0.33369  |       327400 |              116905 |                       0.286832 |                      0.294314 |   0.0235486 |   0.04      |             0 | 0.644695 | 0.0586086 |
| Lagos State | Eti Osa      |                11 |                   0 |      20963 |       25216 |          |       0.259109 |        30504 |         10678 |            |  0.231071 |       390800 |              178222 |                       0.220783 |                      0.203805 |   0.0359    |   0.146667  |             0 | 0.607155 | 0.0551959 |
| Lagos State | Shomolu      |                12 |                   0 |      28418 |       21978 |          |       0.222837 |        40408 |          9991 |            |  0.222851 |       555800 |              226156 |                       0.189876 |                      0.196554 |   0.0455555 |   0.16      |             0 | 0.591986 | 0.0538169 |
| Lagos State | Lagos Island |                 3 |                   0 |      27452 |        7396 |          |       0.278849 |        31991 |          4346 |            |  0.290763 |       292900 |              124971 |                       0.237603 |                      0.256453 |   0.0251734 |   0.04      |             0 | 0.559229 | 0.050839  |
| Lagos State | Amuwo-Odofin |                 7 |                   0 |      16670 |       34312 |          |       0.269023 |        23267 |         13700 |            |  0.195068 |       453000 |              189508 |                       0.22923  |                      0.17205  |   0.0381734 |   0.0933333 |             0 | 0.532787 | 0.0484352 |
| Lagos State | Oshodi-Isolo |                14 |                   0 |      29860 |       28806 |          |       0.167531 |        39945 |         12585 |            |  0.150009 |       866300 |              350180 |                       0.142751 |                      0.132307 |   0.0705382 |   0.186667  |             0 | 0.532263 | 0.0483875 |


Table: Sheet12
| State     | LGAs            | Volunteers Base   |   Policy House Held |   APC vote |   PDP Votes | Others   |   TurnOut |   Population |   Age Group (20-50) |   overallAG |   overall TurnOut |   overallVB |   OverAll PHH |   Weight |     Score |
|:----------|:----------------|:------------------|--------------------:|-----------:|------------:|:---------|----------:|-------------:|--------------------:|------------:|------------------:|------------:|--------------:|---------:|----------:|
| Edo State | Ikpoba Okha     | 3                 |                   0 |      25404 |       30122 |          |  0.152879 |       723552 |              363203 |   0.449856  |         0.0630192 |    0.857143 |             0 | 1.37002  | 0.171252  |
| Edo State | Egor            | 2                 |                   0 |      12482 |       23566 |          |  0.16216  |       442470 |              222299 |   0.275335  |         0.0668451 |    0.571429 |             0 | 0.913609 | 0.114201  |
| Edo State | Oredo           | 2                 |                   0 |      15099 |       13787 |          |  0.548934 |       149881 |               52622 |   0.0651766 |         0.22628   |    0.571429 |             0 | 0.862885 | 0.107861  |
| Edo State | Owan East       |                   |                   0 |      18678 |       15221 |          |  0.934938 |        98577 |               36258 |   0.0449084 |         0.385397  |    0        |             0 | 0.430306 | 0.0537882 |
| Edo State | Esan South-East |                   |                   0 |      11039 |       11435 |          |  0.946832 |        70495 |               23736 |   0.0293989 |         0.3903    |    0        |             0 | 0.419699 | 0.0524624 |
| Edo State | Owan West       |                   |                   0 |      12524 |       10758 |          |  0.878003 |        73431 |               26517 |   0.0328434 |         0.361927  |    0        |             0 | 0.394771 | 0.0493464 |
| Edo State | Orhionmwon      |                   |                   0 |      21496 |       34841 |          |  0.266488 |       415168 |              211405 |   0.261842  |         0.109851  |    0        |             0 | 0.371693 | 0.0464616 |
| Edo State | Igueben         |                   |                   0 |       7503 |        6553 |          |  0.834283 |        51339 |               16848 |   0.0208676 |         0.343905  |    0        |             0 | 0.364773 | 0.0455966 |
| Edo State | Etsako Central  |                   |                   0 |      11437 |        9011 |          |  0.79524  |        74839 |               25713 |   0.0318476 |         0.327811  |    0        |             0 | 0.359659 | 0.0449573 |
| Edo State | Akoko-Edo       |                   |                   0 |      23945 |       17511 |          |  0.673348 |       116856 |               61567 |   0.0762557 |         0.277565  |    0        |             0 | 0.353821 | 0.0442276 |


Table: Sheet2 (2)
| State   |     score | Constituency   | Representative           | Gender   | Party   | PREVParty   | PREVRepresentative      | Column9   | Column10   |
|:--------|----------:|:---------------|:-------------------------|:---------|:--------|:------------|:------------------------|:----------|:-----------|
| Lagos   | 0.0376276 | AGEGE          | ADEJARE SAMUEL           | M        | APC     | APC         | Hon. TAOFEEK ADARANIJO  |           |            |
|         |           |                | BABATUNDE                |          |         |             |                         |           |            |
| Lagos   | 0.075504  | ALIMOSHO       | OLUFEMI BANDELE ADEBANJO | M        | APC     | APC         | Hon. OLUFEMI ADEBANJO   |           |            |
| Lagos   | 0.0394043 | APAPA          | EGBERONGBE MUFUTAU       | M        | APC     | APC         | Hon. AYODEJI JOSEPH     |           |            |
|         |           |                | ADEWALE                  |          |         |             |                         |           |            |
| Lagos   | 0.0586086 | BADAGRY        | HUMPE ADANDE BABATUNDE   | M        | APC     | APC         | Hon. JOSEPH BAMGBOSE    |           |            |
| Lagos   | 0.071913  | EPE            | TASIR RAJI OLAWALE       | M        | APC     | APC         | Hon. TASIR RAJI         |           |            |
| Lagos   | 0.0551959 | ETI-OSA        | OBANIKORO IBRAHIM        | M        | APC     | APC         | Hon. AKINLOYE BABAJIDE  |           |            |
|         |           |                | BABAJIDE                 |          |         |             |                         |           |            |
| Lagos   | 0.0721716 | IBEJU LEKKI    | BALOGUN ADEBAYO          | M        | APC     | APC         | Hon. AYEOLA ABAYOMI     |           |            |
|         |           |                | OLUSEGUN                 |          |         |             |                         |           |            |
| Lagos   | 0.0392946 | IFAKO-IJAIYE   | OWOLABI ADISA JAMES      | M        | APC     | APC         | Hon. NURUDEEN AKINWUNMI |           |            |
| Lagos   | 0.0427579 | IKEJA          | JAMES ABIODUN FALEKE     | M        | APC     | APC         | Hon. FALEKE ABIODUN     |           |            |
| Lagos   | 0.0602619 | IKORODU        | BENSON BABAJIMI ADEGOKE  | M        | APC     | APC         | Hon. BABAJIMI BENSON    |           |            |


Table: Sheet2
| State        | LGAs        | volunteer Base   | Policy House   | APC vote   | PDP Votes   |   Est. Turnout |   20-29 |   30-39 |   40-49 |   20 - 49 |   Overall Turnout |   OverAll AG |   OverAll VB |   P TurnOut |   OverAll PH |    Weight |     Score |
|:-------------|:------------|:-----------------|:---------------|:-----------|:------------|---------------:|--------:|--------:|--------:|----------:|------------------:|-------------:|-------------:|------------:|-------------:|----------:|----------:|
| Rivers State | Abua/Odual  |                  |                | 42496      | 20416       |      0.565064  |   50661 |   34856 |   25819 |    111336 |         0.384172  |    0.0496781 |    0         |  0.0240107  |            0 | 0.0736889 | 0.0219051 |
| Rivers State | Ahoada East |                  |                | 4693       | 10612       |      0.137467  |   30168 |   20325 |   14952 |     65445 |         0.0934599 |    0.0292016 |    0         |  0.00584125 |            0 | 0.0350428 | 0.010417  |
| Rivers State | Ahoada West | 2                |                |            |             |      0         |   45051 |   30327 |   22895 |     98273 |         0         |    0.0438494 |    0.0512821 |  0.019      |            0 | 0.114131  | 0.0339273 |
| Rivers State | Akuku-Toru  |                  |                |            |             |      0         |   29353 |   20287 |   14983 |     64623 |         0         |    0.0288348 |    0         |  0.019      |            0 | 0.0478348 | 0.0142196 |
| Rivers State | Andoni      |                  |                | 10766      | 72330       |      0.746353  |   38691 |   26695 |   19837 |     85223 |         0.507426  |    0.0380265 |    0         |  0.0317141  |            0 | 0.0697406 | 0.0207315 |
| Rivers State | Asari-Toru  |                  |                | 8180       | 3175        |      0.101989  |   40769 |   27173 |   20612 |     88554 |         0.0693393 |    0.0395128 |    0         |  0.0043337  |            0 | 0.0438465 | 0.013034  |
| Rivers State | Bonny       |                  |                |            |             |      0         |   46072 |   32301 |   20132 |     98505 |         0         |    0.0439529 |    0         |  0.019      |            0 | 0.0629529 | 0.0187137 |
| Rivers State | Degema      |                  |                | 7298       | 14083       |      0.19204   |   44688 |   30595 |   23198 |     98481 |         0.130563  |    0.0439422 |    0         |  0.00816019 |            0 | 0.0521024 | 0.0154882 |
| Rivers State | Eleme       | 2                |                | 2412       | 8464        |      0.0976863 |   36534 |   23541 |   18114 |     78189 |         0.0664143 |    0.0348879 |    0.0512821 |  0.00415089 |            0 | 0.0903209 | 0.0268493 |
| Rivers State | Emuoha      |                  |                | 7148       | 72745       |      0.717585  |   37109 |   24572 |   17815 |     79496 |         0.487866  |    0.0354711 |    0         |  0.0304916  |            0 | 0.0659628 | 0.0196084 |


Table: Sheet3 (2)
| State   | CONSTITUENCY    | CANDIDATE                       | GENDER    | PARTY    | Prev Party   | Prev Candidate                | Column8   | Column9   | Column10   |
|:--------|:----------------|:--------------------------------|:----------|:---------|:-------------|:------------------------------|:----------|:----------|:-----------|
| LAGOS   | ALIMOSHO I      | YUSUF ADEBISI ABDULRAHMAN       | M         | APC      | APC          | Hon. Adebisi Yusuff           |           |           |            |
| LAGOS   | ALIMOSHO II     | KEHINDE OLAIDE JOSEPH           | M         | APC      | PDP          | Hon. Oduntan Omotayo          |           |           |            |
| LAGOS   | BADAGRY I       | LAYODE IBRAHIM .O.              | M         | APC      | APC          | Hon. Layode Olanrewaju        |           |           |            |
| LAGOS   | BADAGRY II      | SETONJI SAMUEL DAVID            | M         | APC      | APC          | Engr. Setonji David           |           |           |            |
| LAGOS   | EPE I           | ABIODUN TOBUN MUSTAINU          | M         | APC      | APC          | Hon. Tobun Abiodun            |           |           |            |
| LAGOS   | EPE II          | OGUNKELU SYLVESTER OLUWADAHUNSI | M         | APC      | APC          | Hon. Segun Olulade            |           |           |            |
| LAGOS   | ETI-OSA I       | ADAMS NOHEEM BABATUNDE          | M         | APC      | APC          | Hon. Alimi Kazeem Ademola     |           |           |            |
| LAGOS   | ETI-OSA II      | YISHAWU GBOLAHAN RUFAI ALABI    | M         | APC      | APC          | Hon. Yisawu Olusegun Gbolahan |           |           |            |
| LAGOS   | IBEJU-LEKKI I   | MOJEED FATAI ADEBOLA            | M         | APC      | APC          | Hon Mojeed Fatai A.           |           |           |            |
| LAGOS   | IBEJU-LEKKI II  | KAZEEM RAHEEM ADEWALE           | M         | APC      | APC          | Hon. Kazeem Raheem Adewale    |           |           |            |


Table: Sheet3
| State      | LGAs         | Volunteers Base   | Policy House Held   |   GandujeAPC |   Abba PDP |   Salihu PRP |   TurnOut |   Population |   Age Group (20-50) |   overallAG |   overallVB |   P TurnOut |   OverAll PHH |   Weight |     Score |
|:-----------|:-------------|:------------------|:--------------------|-------------:|-----------:|-------------:|----------:|-------------:|--------------------:|------------:|------------:|------------:|--------------:|---------:|----------:|
| Kano State | Ajingi       |                   |                     |        17711 |      14585 |          500 |  0.460896 |       257514 |               71157 |   0.0626335 |        0    |    0.141149 |             0 | 0.203782 | 0.0156755 |
| Kano State | Albasu       |                   |                     |        25358 |      18401 |          347 |  0.735566 |       217086 |               59962 |   0.0527795 |        0    |    0.225266 |             0 | 0.278045 | 0.0213881 |
| Kano State | Bagwai       |                   |                     |        29768 |      18511 |          749 |  0.902112 |       204231 |               54348 |   0.0478379 |        0    |    0.27627  |             0 | 0.324108 | 0.0249314 |
| Kano State | Bebeji       |                   |                     |        17418 |      18533 |          788 |  0.470506 |       259668 |               78084 |   0.0687307 |        0    |    0.144092 |             0 | 0.212822 | 0.0163709 |
| Kano State | Bichi        |                   |                     |        31958 |      27644 |         1522 |  0.480951 |       459770 |              127090 |   0.111867  |        0    |    0.14729  |             0 | 0.259157 | 0.0199351 |
| Kano State | Bunkure      |                   |                     |        20407 |      20222 |         2875 |  0.715868 |       220438 |               60771 |   0.0534916 |        0    |    0.219233 |             0 | 0.272725 | 0.0209788 |
| Kano State | Dala         | 1                 |                     |        32530 |      60082 |         2875 |  0.50639  |       456487 |              188564 |   0.165977  |        0.04 |    0.155081 |             0 | 0.361058 | 0.0277737 |
| Kano State | Dambatta     |                   |                     |        24696 |      18686 |         2793 |  0.374105 |       412449 |              123428 |   0.108643  |        0    |    0.114569 |             0 | 0.223212 | 0.0171702 |
| Kano State | Dawakin Kudu |                   |                     |        25657 |      30901 |         1575 |  0.534468 |       380767 |              108768 |   0.0957393 |        0    |    0.16368  |             0 | 0.259419 | 0.0199553 |
| Kano State | Dawakin Tofa |                   |                     |        32945 |      17418 |         1151 |  0.426225 |       433077 |              120861 |   0.106384  |        0    |    0.130531 |             0 | 0.236914 | 0.0182242 |


Table: Sheet4
| State     | LGAs          | Volunteers Base   | Policy House Held   |   PDP Votes |   APC vote |   TurnOut | Est. Voters TurnOut=(APC+PDP+Other)/Age Group (20-50)   |   Population |   Age Group (20-50) |   overallAG |   overallVB |   p TurnOut |   OverAll PHH |   Weight |     Score |
|:----------|:--------------|:------------------|:--------------------|------------:|-----------:|----------:|:--------------------------------------------------------|-------------:|--------------------:|------------:|------------:|------------:|--------------:|---------:|----------:|
| Imo State | Aboh Mbaise   |                   |                     |       33476 |       5789 | 0.299699  |                                                         |       343725 |              131015 |   0.0884209 |    0        |    0.475735 |             0 | 0.564156 | 0.0512869 |
| Imo State | Ahiazu Mbaise |                   |                     |       18866 |       2727 | 0.22114   |                                                         |       245379 |               97644 |   0.0658991 |    0        |    0.351033 |             0 | 0.416932 | 0.0379029 |
| Imo State | Ehime Mbano   |                   |                     |       14669 |       7784 | 0.170402  |                                                         |       340867 |              131765 |   0.0889271 |    0        |    0.270492 |             0 | 0.359419 | 0.0326745 |
| Imo State | Ezinihitte    |                   |                     |       21606 |       3188 | 0.281267  |                                                         |       235201 |               88151 |   0.0594924 |    0        |    0.446478 |             0 | 0.50597  | 0.0459973 |
| Imo State | Ideato North  |                   |                     |       13248 |       3765 | 0.0897959 |                                                         |       527177 |              189463 |   0.127867  |    0        |    0.14254  |             0 | 0.270407 | 0.0245825 |
| Imo State | Ideato South  |                   |                     |        8844 |      20663 | 0.452672  |                                                         |       181289 |               65184 |   0.0439921 |    0        |    0.718562 |             0 | 0.762554 | 0.0693231 |
| Imo State | Ihitte/Uboma  | 1                 |                     |        9671 |       3805 | 0.225566  |                                                         |       150527 |               59743 |   0.0403201 |    0.111111 |    0.358059 |             0 | 0.50949  | 0.0463173 |
| Imo State | Ikeduru       |                   |                     |       20302 |       4708 | 0.17028   |                                                         |       392988 |              146876 |   0.0991254 |    0        |    0.270298 |             0 | 0.369424 | 0.033584  |
| Imo State | Isiala Mbano  |                   |                     |       11804 |       3965 | 0.100247  |                                                         |       436101 |              157302 |   0.106162  |    0        |    0.159129 |             0 | 0.265291 | 0.0241174 |
| Imo State | Isu           |                   |                     |        8673 |       6487 | 0.280403  |                                                         |       143968 |               54065 |   0.036488  |    0        |    0.445106 |             0 | 0.481594 | 0.0437813 |


Table: Sheet5
| State         | LGAs     | Volunteers Base   |   Policy House Held |   APC vote |   PDP Votes |   Turnout |   Population |   Age Group (20-50) |   overallAG |   overallVB |   P TurnOut |   OverAll PHH |   Weight |     Score |
|:--------------|:---------|:------------------|--------------------:|-----------:|------------:|----------:|-------------:|--------------------:|------------:|------------:|------------:|--------------:|---------:|----------:|
| Adamawa State | Demsa    |                   |                   0 |       6989 |       29997 |  0.845394 |       147004 |               43750 |   0.0806002 |    0        |    0.445878 |             0 | 0.526479 | 0.0478617 |
| Adamawa State | Fufure   |                   |                   0 |      29507 |       16430 |  0.661449 |       252767 |               69449 |   0.127945  |    0        |    0.348862 |             0 | 0.476807 | 0.0433461 |
| Adamawa State | Ganye    |                   |                   0 |      20360 |       17770 |  0.703259 |       177381 |               54219 |   0.0998872 |    0        |    0.370913 |             0 | 0.4708   | 0.0428    |
| Adamawa State | Gayuk    |                   |                   0 |      10825 |       22059 |  0.541149 |       189711 |               60767 |   0.11195   |    0        |    0.285413 |             0 | 0.397364 | 0.036124  |
| Adamawa State | Gombi    |                   |                   0 |      12805 |       18172 |  0.522924 |       195796 |               59238 |   0.109134  |    0        |    0.275801 |             0 | 0.384935 | 0.0349941 |
| Adamawa State | Grie     | 4                 |                   0 |      17765 |       14673 |  0.558871 |       204820 |               58042 |   0.10693   |    0.444444 |    0.29476  |             0 | 0.846135 | 0.0769213 |
| Adamawa State | Hong     |                   |                   0 |      20471 |       23039 |  0.656428 |       224757 |               66283 |   0.122113  |    0        |    0.346213 |             0 | 0.468326 | 0.0425751 |
| Adamawa State | Jada     |                   |                   0 |      21322 |       22877 |  0.710424 |       206542 |               62215 |   0.114618  |    0        |    0.374692 |             0 | 0.48931  | 0.0444827 |
| Adamawa State | Lamurde  |                   |                   0 |       8123 |       21404 |  1.22814  |        81811 |               24042 |   0.0442924 |    0        |    0.647747 |             0 | 0.69204  | 0.0629127 |
| Adamawa State | Madagali |                   |                   0 |       8208 |       14594 |  0.624541 |       128636 |               36510 |   0.067262  |    0        |    0.329396 |             0 | 0.396658 | 0.0360598 |


Table: Sheet6
| State     | LGAs              | Volunteers Base   | Policy House Held   | ADC   | ADP   |   APC vote |   PDP Votes |   Est. Voters TurnOut=(APC+PDP+Other)/Age Group (20-50) |   Population |   Age Group (20-50) |   overallAG |   overallVB |   P TurnOut |   OverAll PHH |   Weight |     Score |
|:----------|:------------------|:------------------|:--------------------|:------|:------|-----------:|------------:|--------------------------------------------------------:|-------------:|--------------------:|------------:|------------:|------------:|--------------:|---------:|----------:|
| Oyo State | Afijio            | 1                 |                     | 1022  | 306   |       6874 |        8325 |                                                0.425614 |       110613 |               38831 |   0.0633809 |   0.0833333 |   0.202552  |             0 | 0.349267 | 0.0249476 |
| Oyo State | Akinyele          | 1                 |                     | 2640  | 799   |      13695 |       14433 |                                                0.182381 |       410900 |              173083 |   0.28251   |   0.0833333 |   0.0867962 |             0 | 0.45264  | 0.0323314 |
| Oyo State | Atiba             |                   |                     | 1646  | 960   |      13116 |        7983 |                                                0.924712 |        75823 |               25635 |   0.041842  |   0         |   0.440077  |             0 | 0.481919 | 0.0344228 |
| Oyo State | Atisbo            |                   |                     | 517   | 308   |       8550 |        8128 |                                                0.55034  |        97241 |               31804 |   0.0519112 |   0         |   0.26191   |             0 | 0.313822 | 0.0224158 |
| Oyo State | Egbeda            | 1                 |                     | 831   | 378   |      17295 |       15065 |                                                0.138928 |       528490 |              241628 |   0.394391  |   0.0833333 |   0.066117  |             0 | 0.543841 | 0.0388458 |
| Oyo State | Ibadan North      | 7                 |                     | 1352  | 375   |      23210 |       24887 |                                                1.15889  |        86528 |               42993 |   0.0701742 |   0.583333  |   0.551522  |             0 | 1.20503  | 0.0860735 |
| Oyo State | Ibadan North-East | 1                 |                     | 1759  | 595   |      12048 |       21165 |                                                0.34116  |       219839 |              104253 |   0.170164  |   0.0833333 |   0.162361  |             0 | 0.415858 | 0.0297042 |
| Oyo State | Ibadan North-West | 6                 |                     | 1264  | 160   |      11126 |        1450 |                                                0.459062 |        62034 |               30497 |   0.0497779 |   0.5       |   0.218471  |             0 | 0.768248 | 0.0548749 |
| Oyo State | Ibadan South-East |                   |                     |       |       |      14937 |       13844 |                                                0.410208 |       146077 |               70162 |   0.11452   |   0         |   0.195221  |             0 | 0.309741 | 0.0221243 |
| Oyo State | Ibadan South-West |                   |                     | 1656  | 418   |      22546 |       20233 |                                                0.568537 |       157933 |               78892 |   0.128769  |   0         |   0.270571  |             0 | 0.39934  | 0.0285243 |


Table: Sheet7
| State        | LGAs        | Volunteer Base   | Policy House   |   APC vote |   PDP Votes | Others   |   TurnOut |   20-29 |   30-39 |   40-49 |   20 - 49 |   OverAll AG |   OverAll VB |   pTurnOut |   OverAll PH |   Weight |     Score |
|:-------------|:------------|:-----------------|:---------------|-----------:|------------:|:---------|----------:|--------:|--------:|--------:|----------:|-------------:|-------------:|-----------:|-------------:|---------:|----------:|
| Benue  State | Ado         |                  |                |       5373 |        8614 |          |  0.221215 |   30017 |   20095 |   13116 |     63228 |    0.0862559 |    0         |   0.158834 |            0 | 0.24509  | 0.0222809 |
| Benue  State | Agatu       |                  |                |       4170 |        8225 |          |  0.196037 |   18968 |   12725 |    8047 |     39740 |    0.0542135 |    0         |   0.140755 |            0 | 0.194969 | 0.0177244 |
| Benue  State | Apa         |                  |                |       5255 |        8073 |          |  0.210793 |   16185 |   10520 |    6640 |     33345 |    0.0454894 |    0         |   0.15135  |            0 | 0.19684  | 0.0178945 |
| Benue  State | Buruku      |                  |                |      17033 |       23236 |          |  0.636886 |   33811 |   21629 |   13560 |     69000 |    0.0941301 |    0         |   0.457287 |            0 | 0.551417 | 0.0501288 |
| Benue  State | Gboko       | 2                |                |      35750 |       31117 |          |  1.05755  |   63808 |   38273 |   25424 |    127505 |    0.173943  |    0.0833333 |   0.759329 |            0 | 1.01661  | 0.0924187 |
| Benue  State | Guma        |                  |                |       6172 |       21641 |          |  0.439884 |   32187 |   20704 |   12970 |     65861 |    0.0898479 |    0         |   0.315839 |            0 | 0.405687 | 0.0368806 |
| Benue  State | Gwer East   |                  |                |      14907 |       18192 |          |  0.523486 |   28434 |   17437 |   11399 |     57270 |    0.078128  |    0         |   0.375866 |            0 | 0.453994 | 0.0412722 |
| Benue  State | Gwer West   |                  |                |       6275 |       14660 |          |  0.331103 |   20169 |   13310 |    8372 |     41851 |    0.0570933 |    0         |   0.237734 |            0 | 0.294827 | 0.0268025 |
| Benue  State | Katsina-Ala |                  |                |      20315 |       24197 |          |  0.703992 |   38448 |   22977 |   14648 |     76073 |    0.103779  |    0         |   0.50547  |            0 | 0.609249 | 0.0553863 |
| Benue  State | Konshisha   |                  |                |      27165 |        8726 |          |  0.567644 |   36012 |   22785 |   14991 |     73788 |    0.100662  |    0         |   0.407571 |            0 | 0.508233 | 0.046203  |


Table: Sheet8
| State         | LGAs           | Volunteer Base   | Policy House   |   APC vote |   PDP Votes | Others   |   Turnout |   APC vote_1 |   PDP Votes_2 | Others_3   |   Turnout_4 |   20-29 |   30-39 |   40-49 |   20 - 49 |   OverAll AG |   OverAll VB |   P TurnOut |   G TurnOut |   Weight |     Score |
|:--------------|:---------------|:-----------------|:---------------|-----------:|------------:|:---------|----------:|-------------:|--------------:|:-----------|------------:|--------:|--------:|--------:|----------:|-------------:|-------------:|------------:|------------:|---------:|----------:|
| Plateau State | Barkin Ladi    |                  |                |      15390 |       42136 |          |  0.888282 |        17080 |         44529 |            |    0.951329 |   32419 |   20314 |   12028 |     64761 |    0.11052   |     0        |    0.491436 |    0.231638 | 0.833594 | 0.0555729 |
| Plateau State | Bassa          |                  |                |      27632 |       34822 |          |  0.928988 |        30441 |         33192 |            |    0.946525 |   32821 |   21179 |   13228 |     67228 |    0.11473   |     0        |    0.513956 |    0.230468 | 0.859155 | 0.057277  |
| Plateau State | Bokkos         |                  |                |      18328 |       32236 |          |  0.812887 |        27561 |         26700 |            |    0.872321 |   30894 |   19572 |   11737 |     62203 |    0.106155  |     0        |    0.449724 |    0.2124   | 0.768279 | 0.0512186 |
| Plateau State | Jos East       |                  |                |      11847 |        8853 |          |  0.65779  |        18602 |          7994 |            |    0.845149 |   15478 |    9878 |    6113 |     31469 |    0.0537046 |     0        |    0.363918 |    0.205784 | 0.623407 | 0.0415604 |
| Plateau State | Jos North      | 4                |                |      93800 |       53277 |          |  0.845066 |       109161 |         68149 |            |    1.01878  |   88414 |   51950 |   33678 |    174042 |    0.297018  |     0.235294 |    0.467527 |    0.248061 | 1.2479   | 0.0831933 |
| Plateau State | Jos South      | 11               |                |      25574 |      106526 |          |  1.02734  |        33075 |         91846 |            |    0.971513 |   64208 |   39623 |   24753 |    128584 |    0.21944   |     0.647059 |    0.568371 |    0.236552 | 1.67142  | 0.111428  |
| Plateau State | Kanam          |                  |                |      51017 |       18331 |          |  1.23918  |        55338 |         22432 |            |    1.38967  |   26928 |   17845 |   11190 |     55963 |    0.0955058 |     0        |    0.685565 |    0.338368 | 1.11944  | 0.0746293 |
| Plateau State | Kanke          |                  |                |      17946 |       22875 |          |  0.931433 |        23360 |         22831 |            |    1.05396  |   21067 |   13925 |    8834 |     43826 |    0.0747929 |     0        |    0.515309 |    0.256628 | 0.84673  | 0.0564487 |
| Plateau State | Langtang North |                  |                |      16665 |       34105 |          |  0.977079 |        18979 |         40519 |            |    1.14505  |   24700 |   16874 |   10387 |     51961 |    0.088676  |     0        |    0.540562 |    0.278807 | 0.908045 | 0.0605363 |
| Plateau State | Langtang South |                  |                |      11224 |       18477 |          |  0.765076 |        14467 |         18868 |            |    0.858685 |   18565 |   12948 |    7308 |     38821 |    0.0662515 |     0        |    0.423273 |    0.20908  | 0.698604 | 0.0465736 |


Table: Sheet9
| State        | LGAs         | Volunteers Base   |   APC vote |   PDP Votes | Others   |   Turnout |   APC vote_1 |   PDP Votes_2 | Others_3   |   Turnout_4 |   Population |   Age Group (20-50) |   overallAG |   overallVB |   P Turnout |   G Turnout |   Weight |     Score |
|:-------------|:-------------|:------------------|-----------:|------------:|:---------|----------:|-------------:|--------------:|:-----------|------------:|-------------:|--------------------:|------------:|------------:|------------:|------------:|---------:|----------:|
| Kaduna State | Kaduna South | 11                |      92637 |       41004 |          |  1.04607  |       102035 |         37948 |            |    1.09571  |       287824 |              127755 |   0.0843231 |   0.255814  |    0.319345 |    0.295804 | 0.955286 | 0.0868442 |
| Kaduna State | Chikun       | 15                |      21930 |       82909 |          |  0.366823 |        24262 |         86261 |            |    0.38671  |       784295 |              285803 |   0.188641  |   0.348837  |    0.111984 |    0.104398 | 0.75386  | 0.0685327 |
| Kaduna State | Kaduna North | 4                 |      97514 |       27185 |          |  0.972388 |        97243 |         27665 |            |    0.974017 |       284412 |              128240 |   0.0846432 |   0.0930233 |    0.296851 |    0.26295  | 0.737467 | 0.0670425 |
| Kaduna State | Zaria        | 4                 |     111082 |       23882 |          |  0.650561 |       111014 |         37356 |            |    0.715181 |       525059 |              207458 |   0.13693   |   0.0930233 |    0.198603 |    0.193073 | 0.62163  | 0.0565118 |
| Kaduna State | Sabon Gari   | 3                 |      58467 |       22644 |          |  0.656658 |        57655 |         25519 |            |    0.673359 |       319821 |              123521 |   0.0815285 |   0.0697674 |    0.200464 |    0.181783 | 0.533543 | 0.048504  |
| Kaduna State | Kudan        |                   |      30577 |       11692 |          |  0.795278 |        28624 |         22022 |            |    0.952888 |       162011 |               53150 |   0.035081  |   0         |    0.242782 |    0.257246 | 0.535109 | 0.0486463 |
| Kaduna State | Igabi        | 2                 |      97308 |       20281 |          |  0.389232 |       102612 |         31429 |            |    0.44369  |       844956 |              302105 |   0.199401  |   0.0465116 |    0.118825 |    0.119781 | 0.484518 | 0.0440471 |
| Kaduna State | Zangon Kataf | 1                 |      10411 |       62622 |          |  0.585032 |        13448 |         87546 |            |    0.809013 |       377275 |              124836 |   0.0823965 |   0.0232558 |    0.178598 |    0.218405 | 0.502656 | 0.045696  |
| Kaduna State | Jema'a       |                   |      19412 |       61763 |          |  0.752157 |        21265 |         63129 |            |    0.781983 |       295756 |              107923 |   0.0712332 |   0         |    0.229618 |    0.211108 | 0.511959 | 0.0465418 |
| Kaduna State | Lere         | 1                 |      64299 |       32426 |          |  0.537953 |        71056 |         45215 |            |    0.646661 |       549175 |              179802 |   0.118676  |   0.0232558 |    0.164226 |    0.174576 | 0.480734 | 0.0437031 |

 


tables: name: Imo Rep race
data: Imo Rep race.csv
name: Senatorial
data: Senatorial.csv
name: Sheet1
data: Sheet1.csv
name: Sheet10
data: Sheet10.csv
name: Sheet11
data: Sheet11.csv
name: Sheet12
data: Sheet12.csv
name: Sheet2 (2)
data: Sheet2 (2).csv
name: Sheet2
data: Sheet2.csv
name: Sheet3 (2)
data: Sheet3 (2).csv
name: Sheet3
data: Sheet3.csv
name: Sheet4
data: Sheet4.csv
name: Sheet5
data: Sheet5.csv
name: Sheet6
data: Sheet6.csv
name: Sheet7
data: Sheet7.csv
name: Sheet8
data: Sheet8.csv
name: Sheet9
data: Sheet9.csv
label: Sheet10
State
Sheet1
State
Sheet11
State
Sheet1
State
Sheet12
State
Sheet1
State
Sheet2
State
Sheet1
State
Sheet3
State
Sheet1
State
Sheet4
State
Sheet1
State
Sheet5
State
Sheet1
State
Sheet6
State
Sheet1
State
Sheet8
State
Sheet1
State
Sheet9
State
Sheet1
State
Sheet7
State
Sheet1
State
Senatorial
State
Sheet1
State
Sheet2 (2)
State
Sheet1
State
Sheet3 (2)
State
Sheet1
State
output: {
    "joins": [
        {
            "from_table": "Sheet10",
            "from_column": "State",
            "to_table": "Sheet1",
            "to_column": "State"
        },
        {
            "from_table": "Sheet11",
            "from_column": "State",
            "to_table": "Sheet1",
            "to_column": "State"
        },
        {
            "from_table": "Sheet12",
            "from_column": "State",
            "to_table": "Sheet1",
            "to_column": "State"
        },
        {
            "from_table": "Sheet2",
            "from_column": "State",
            "to_table": "Sheet1",
            "to_column": "State"
        },
        {
            "from_table": "Sheet3",
            "from_column": "State",
            "to_table": "Sheet1",
            "to_column": "State"
        },
        {
            "from_table": "Sheet4",
            "from_column": "State",
            "to_table": "Sheet1",
            "to_column": "State"
        },
        {
            "from_table": "Sheet5",
            "from_column": "State",
            "to_table": "Sheet1",
            "to_column": "State"
        },
        {
            "from_table": "Sheet6",
            "from_column": "State",
            "to_table": "Sheet1",
            "to_column": "State"
        },
        {
            "from_table": "Sheet8",
            "from_column": "State",
            "to_table": "Sheet1",
            "to_column": "State"
        },
        {
            "from_table": "Sheet9",
            "from_column": "State",
            "to_table": "Sheet1",
            "to_column": "State"
        },
        {
            "from_table": "Sheet7",
            "from_column": "State",
            "to_table": "Sheet1",
            "to_column": "State"
        },
        {
            "from_table": "Senatorial",
            "from_column": "State",
            "to_table": "Sheet1",
            "to_column": "State"
        },
        {
            "from_table": "Sheet2 (2)",
            "from_column": "State",
            "to_table": "Sheet1",
            "to_column": "State"
        },
        {
            "from_table": "Sheet3 (2)",
            "from_column": "State",
            "to_table": "Sheet1",
            "to_column": "State"
        }
    ]
}