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: which anm
|   anm | anm_name                    |
|------:|:----------------------------|
|     1 | BARROW HILL & SHOOT UP HILL |
|     2 | CHILTERNS RIDGE             |
|     3 | CROUCH HILL                 |
|     4 | CROYDON                     |
|     5 | DARENTH                     |
|     6 | FINSBURY PLUS               |
|     7 | GUILDFORD                   |
|     8 | HAMPTON, EALING & KEMPTON   |
|     9 | MAIDEN LANE & PUTNEY        |
|    10 | NEWBURY & DIDCOT            |


Table: which csl_processed
| dma      |   number_csl_jobs |   leakage_saving_l/s |
|:---------|------------------:|---------------------:|
| ZBEPRV07 |                 1 |            0.0231481 |
| ZMAIDL35 |                 1 |            0.0231481 |
| ZMOULS01 |                 1 |            0.0231481 |
| ZBARHT29 |                 1 |            0.0231481 |
| ZCRYSB07 |                 1 |            0.0231481 |
| ZPUTNY09 |                 1 |            0.0231481 |
| ZSTHFL12 |                 1 |            0.0231481 |
| ZBICLY04 |                 1 |            0.0231481 |
| ZHORNS01 |                 1 |            0.0231481 |
| ZBLUNS15 |                 1 |            0.0231481 |


Table: which dma
|   dma | dma_code   | fmz_code   | fmz_name   | anm_name   |
|------:|:-----------|:-----------|:-----------|:-----------|
|  1580 | ZWOODF08   | ZWOODF     | WOODFORD   | WOODFORD   |
|  1581 | ZWOODF104  | ZWOODF     | WOODFORD   | WOODFORD   |
|  1582 | ZWOODF105  | ZWOODF     | WOODFORD   | WOODFORD   |
|  1583 | ZWOODF107  | ZWOODF     | WOODFORD   | WOODFORD   |
|  1584 | ZWOODF109  | ZWOODF     | WOODFORD   | WOODFORD   |
|  1585 | ZWOODF11   | ZWOODF     | WOODFORD   | WOODFORD   |
|  1586 | ZWOODF110  | ZWOODF     | WOODFORD   | WOODFORD   |
|  1587 | ZWOODF111  | ZWOODF     | WOODFORD   | WOODFORD   |
|  1588 | ZWOODF112  | ZWOODF     | WOODFORD   | WOODFORD   |
|  1589 | ZWOODF113  | ZWOODF     | WOODFORD   | WOODFORD   |


Table: which flow_hist_mcf
| dma      | date                    |      mcf |   perc_data_available |
|:---------|:------------------------|---------:|----------------------:|
| ZBARHT50 | 2019-08-23 00:00:00.000 | 0.406845 |                     0 |
| ZCHIGW03 | 2019-08-23 00:00:00.000 | 0.579909 |                     0 |
| ZCRCHH83 | 2019-08-23 00:00:00.000 | 0.343533 |                     0 |
| ZFINSB57 | 2019-08-23 00:00:00.000 | 0.721471 |                     0 |
| ZFINSB66 | 2019-08-23 00:00:00.000 | 0.210542 |                     0 |
| ZFINSB91 | 2019-08-23 00:00:00.000 | 0.447458 |                     0 |
| ZHAM3002 | 2019-08-23 00:00:00.000 | 0.475597 |                     0 |
| ZHAM4211 | 2019-08-23 00:00:00.000 | 1.29416  |                     0 |
| ZHAMCO15 | 2019-08-23 00:00:00.000 | 0.844942 |                     0 |
| ZNEWFM07 | 2019-08-23 00:00:00.000 | 0.147338 |                     0 |


Table: which flow_live_dma
| dma       | timestamp               |   value |   perc_data_available |
|:----------|:------------------------|--------:|----------------------:|
| ZFINSB102 | 2019-08-23 07:30:00.000 |       0 |                     0 |
| ZFINSB102 | 2019-08-23 10:30:00.000 |       0 |                     0 |
| ZFINSB102 | 2019-08-24 10:00:00.000 |       0 |                     0 |
| ZFINSB102 | 2019-08-23 18:45:00.000 |       0 |                     0 |
| ZFINSB102 | 2019-08-23 22:15:00.000 |       0 |                     0 |
| ZFINSB102 | 2019-08-24 01:00:00.000 |       0 |                     0 |
| ZFINSB102 | 2019-08-23 17:45:00.000 |       0 |                     0 |
| ZFINSB102 | 2019-08-24 22:15:00.000 |       0 |                     0 |
| ZFINSB102 | 2019-08-24 02:15:00.000 |       0 |                     0 |
| ZFINSB102 | 2019-08-23 00:00:00.000 |       0 |                     0 |


Table: which fmz
|   fmz | fmz_code   | fmz_name             |   fk_anm |
|------:|:-----------|:---------------------|---------:|
|     1 | ZABIND     | ABINGDON             |       12 |
|     2 | ZABINB     | ABINGER              |        7 |
|     3 | ZADDIN     | ADDINGTON            |        4 |
|     4 | ZALDBN     | ALDBOURNE            |       17 |
|     5 | ZALDBR     | ALDERBROOK           |        7 |
|     6 | ZALDTW     | ALDWORTH TOWER       |       10 |
|     7 | ZAMERH     | AMERSHAM HILL        |       20 |
|     8 | ZANGLB     | ANGLIAN WATER IMPORT |       12 |
|     9 | ZARDLY     | ARDLEY               |       12 |
|    10 | ZASHDN     | ASHENDON             |        2 |


Table: which laol_clean
| dma      | jr13_dma_avg   | jr13_avg_src   | jr13_tenth_perc   | jr14_dma_avg   | jr14_avg_src   | jr14_tenth_perc   | jr15_dma_avg   | jr15_avg_src   | jr15_tenth_perc   | jr16_dma_avg   | jr16_avg_src   | jr16_tenth_perc   |   latest_laol_value | date_set                | original   | name   | comments   |
|:---------|:---------------|:---------------|:------------------|:---------------|:---------------|:------------------|:---------------|:---------------|:------------------|:---------------|:---------------|:------------------|--------------------:|:------------------------|:-----------|:-------|:-----------|
| ZFLAXL00 |                |                |                   |                |                |                   |                |                |                   |                |                |                   |                   0 | 2017-03-15 00:00:00.000 |            |        |            |
| ZFRITH00 |                |                |                   |                |                |                   |                |                |                   |                |                |                   |                   0 | 2017-03-15 00:00:00.000 |            |        |            |
| ZFRNBO00 |                |                |                   |                |                |                   |                |                |                   |                |                |                   |                   0 | 2017-03-15 00:00:00.000 |            |        |            |
| ZFRNBO01 |                |                |                   |                |                |                   |                |                |                   |                |                |                   |                   0 | 2017-03-15 00:00:00.000 |            |        |            |
| ZHAGBH00 |                |                |                   |                |                |                   |                |                |                   |                |                |                   |                   0 | 2017-03-15 00:00:00.000 |            |        |            |
| ZHAM3000 |                |                |                   |                |                |                   |                |                |                   |                |                |                   |                   0 | 2017-03-15 00:00:00.000 |            |        |            |
| ZHAM3600 |                |                |                   |                |                |                   |                |                |                   |                |                |                   |                   0 | 2017-03-15 00:00:00.000 |            |        |            |
| ZHAM3636 |                |                |                   |                |                |                   |                |                |                   |                |                |                   |                   0 | 2017-03-15 00:00:00.000 |            |        |            |
| ZHAM4200 |                |                |                   |                |                |                   |                |                |                   |                |                |                   |                   0 | 2017-03-15 00:00:00.000 |            |        |            |
| ZHAMCO00 |                |                |                   |                |                |                   |                |                |                   |                |                |                   |                   0 | 2017-03-15 00:00:00.000 |            |        |            |


Table: which netbase_bma_clean
| region        | anm           | zone          | dma      | valid_from_date         | valid_to_date   |   total_properties |   total_length_of_mains |   household_properties |   non_household_properties |   continuously_logged_properties |   length_of_distribution_mains |   length_of_trunk_mains | last_pzt_date   | last_pzt_successful   | dma_events_affecting_leakage_targeting   | dma_events_not_affecting_leakage_targeting   | days_since_last_available   |   nightline_week2 |   nightline_week1 |   measured_tdf_week2 |   measured_tdf_week1 |   leakage_week2 |   leakage_week1 |   outstanding_leakage_week2_ls |   outstanding_leakage_week2_lph | outstanding_leakage_week2_lskm   | area       |
|:--------------|:--------------|:--------------|:---------|:------------------------|:----------------|-------------------:|------------------------:|-----------------------:|---------------------------:|---------------------------------:|-------------------------------:|------------------------:|:----------------|:----------------------|:-----------------------------------------|:---------------------------------------------|:----------------------------|------------------:|------------------:|---------------------:|---------------------:|----------------:|----------------:|-------------------------------:|--------------------------------:|:---------------------------------|:-----------|
| Eastern North | FINSBURY PLUS | FINSBURY PARK | ZFINSB14 | 2019-01-01 00:00:00.000 |                 |                 24 |                       0 |                     24 |                          0 |                                0 |                              0 |                       0 |                 |                       |                                          |                                              |                             |        0.0047619  |        0.0047619  |            0.153704  |           0.215195   |               0 |               0 |                              0 |                               0 |                                  | BMA0000014 |
| Eastern North | FINSBURY PLUS | FINSBURY PARK | ZFINSB79 | 2016-01-05 00:00:00.000 |                 |                 88 |                       0 |                     88 |                          0 |                                0 |                              0 |                       0 |                 |                       |                                          |                                              |                             |        0.206689   |        0.117857   |            0.530404  |           0.451108   |               0 |               0 |                              0 |                               0 |                                  | BMA0001336 |
| Eastern North | FINSBURY PLUS | FINSBURY PARK | ZFINSB90 | 2016-01-05 00:00:00.000 |                 |                 53 |                       0 |                     53 |                          0 |                                0 |                              0 |                       0 |                 |                       |                                          |                                              |                             |        0.212698   |        0.232937   |            0.336243  |           0.331862   |               0 |               0 |                              0 |                               0 |                                  | BMA0001420 |
| Eastern North | FINSBURY PLUS | FINSBURY PARK | ZFINSB09 | 2019-01-31 00:00:00.000 |                 |                 34 |                       0 |                     34 |                          0 |                                0 |                              0 |                       0 |                 |                       |                                          |                                              |                             |        0          |        0          |            0         |           0          |               0 |               0 |                              0 |                               0 |                                  | BMA0001209 |
| Eastern North | FINSBURY PLUS | FINSBURY PARK | ZFINSB64 | 2018-01-16 00:00:00.000 |                 |                 42 |                       0 |                     42 |                          0 |                                0 |                              0 |                       0 |                 |                       |                                          |                                              |                             |        0.0765873  |        0.0686508  |            0.1854    |           0.180655   |               0 |               0 |                              0 |                               0 |                                  | BMA0002284 |
| Eastern North | FINSBURY PLUS | FINSBURY PARK | ZFINSB46 |                         |                 |                 59 |                       0 |                     59 |                          0 |                                0 |                              0 |                       0 |                 |                       |                                          |                                              |                             |        0          |        0          |            0         |           0          |               0 |               0 |                              0 |                               0 |                                  | BMA0000738 |
| Eastern North | FINSBURY PLUS | FINSBURY PARK | ZFINSB95 |                         |                 |                 95 |                       0 |                     95 |                          0 |                                0 |                              0 |                       0 |                 |                       |                                          |                                              |                             |        0.3        |        0.250794   |            0.521792  |           0.546131   |               0 |               0 |                              0 |                               0 |                                  | BMA0000780 |
| Eastern North | FINSBURY PLUS | FINSBURY PARK | ZFINSB33 | 2016-01-19 00:00:00.000 |                 |                 15 |                       0 |                     15 |                          0 |                                0 |                              0 |                       0 |                 |                       |                                          |                                              |                             |        0.00464286 |        0.0018254  |            0.02854   |           0.00358631 |               0 |               0 |                              0 |                               0 |                                  | BMA0000031 |
| Eastern North | FINSBURY PLUS | FINSBURY PARK | ZFINSB42 | 2018-01-15 00:00:00.000 |                 |                 31 |                       0 |                     31 |                          0 |                                0 |                              0 |                       0 |                 |                       |                                          |                                              |                             |        0.027381   |        0.0281746  |            0.124388  |           0.117394   |               0 |               0 |                              0 |                               0 |                                  | BMA0000264 |
| Eastern North | FINSBURY PLUS | FINSBURY PARK | ZFINSB42 | 2019-01-01 00:00:00.000 |                 |                 32 |                       0 |                     32 |                          0 |                                0 |                              0 |                       0 |                 |                       |                                          |                                              |                             |        0.00436508 |        0.00621693 |            0.0127149 |           0.0128665  |               0 |               0 |                              0 |                               0 |                                  | BMA0000284 |


Table: which netbase_bma_summary
| dma      |   leakage_movement_l/s |   available_indi |   unavailable_indi |   total_number_bma |
|:---------|-----------------------:|-----------------:|-------------------:|-------------------:|
| ZFINSB48 |                      0 |                1 |                  1 |                  2 |
| ZBROML05 |                      0 |                1 |                  1 |                  2 |
| ZCHIGB01 |                      0 |                1 |                  1 |                  2 |
| ZMAIDL03 |                      0 |                1 |                  1 |                  2 |
| ZBISHW18 |                      0 |                1 |                  1 |                  2 |
| ZFARNH03 |                      0 |                1 |                  1 |                  2 |
| ZWOODF86 |                      0 |                1 |                  1 |                  2 |
| ZHAM4211 |                      0 |                1 |                  1 |                  2 |
| ZHAMCO15 |                      0 |                1 |                  1 |                  2 |
| ZPUTNY38 |                      0 |                1 |                  1 |                  2 |


Table: which netbase_dma_clean
| dma      | lan_entry_date          |      lan |   da_nightline_lan_variance | region        | anm                         | zone             | valid_from_date         | valid_to_date   |   total_properties |   total_length_of_mains |   household_properties |   non_household_properties |   continuously_logged_properties |   length_of_distribution_mains |   length_of_trunk_mains | last_pzt_date           | last_pzt_successful   | dma_events_affecting_leakage_targeting   | dma_events_not_affecting_leakage_targeting   | days_since_last_available   |   nightline_week2 |   nightline_week1 |   measured_tdf_week2 |   measured_tdf_week1 |   leakage_week2 |   leakage_week1 |   outstanding_leakage_week2_ls |   outstanding_leakage_week2_lph |   outstanding_leakage_week2_lskm |   main_productivity_rank |   service_productivity_rank |   al_mains_day3 |   al_mains_day2 |   al_mains_day1 |   al_comms_day3 |   al_comms_day2 |   al_comms_day1 |   vs_mains_day3 |   vs_mains_day2 |   vs_mains_day1 |   days_since_last_leakage_detection | targeted_in_the_last_two_months_if_unavailable   | csls_unproven   | csls_proven   | burst_mains   | comm_pipe_repairs   | other_leaks   |   survey_id_telsa_no_current | survey_start_date       | survey_type_current_open_tesla   | scheduled_survey_end_date   | last_accoustic_logging_survey   | second_last_sounding_survey   | last_sounding_survey    | last_step_test_survey   |   survey_id_last_closed_survey | survey_type_last_closed_survey   |   opening_nightline |   closing_nightline |   target_exit_level |   reduction_perc | target_achieved   | comments                       | actual_end              |   duration |   total_detection_hours |   direct_hours |   indirect_hours |   aqual |   cancelled |   corrp |   corrsu |   cslc |   csld |   fldsu |   leakq |   perml |   recl |   sound |   step |   zetadm |   dmad |   dmam |   dmdiv |   leaka |   prvm |   prvo |   leave |   sick |   train |   no_tesla_leaks_raised | tesla_leakage_raised   | tesla_leaks_raised   | mains_repairs_ac   | mains_repairs_de   | valve_exc_install   | valve_repack   | service_repair_relay   | osv   | fh_wo   | meter_last_closed_survey_section   | bb   | other   | csl_detected   |   residual_water_week2 |   perc_mains_material_metal |   perc_mains_material_plastic |   dma_operability_week2 |   boundary_link |   meter_operability_failures_last_month |   summary_data_missing |   summary_data_partial |   summary_data_invalid |   residual_out_of_range | basis_of_estimation           |   total_length_of_mains_km |   dma_operability_% |   LAN Confidence | valid_from_date_origin   |
|:---------|:------------------------|---------:|----------------------------:|:--------------|:----------------------------|:-----------------|:------------------------|:----------------|-------------------:|------------------------:|-----------------------:|---------------------------:|---------------------------------:|-------------------------------:|------------------------:|:------------------------|:----------------------|:-----------------------------------------|:---------------------------------------------|:----------------------------|------------------:|------------------:|---------------------:|---------------------:|----------------:|----------------:|-------------------------------:|--------------------------------:|---------------------------------:|-------------------------:|----------------------------:|----------------:|----------------:|----------------:|----------------:|----------------:|----------------:|----------------:|----------------:|----------------:|------------------------------------:|:-------------------------------------------------|:----------------|:--------------|:--------------|:--------------------|:--------------|-----------------------------:|:------------------------|:---------------------------------|:----------------------------|:--------------------------------|:------------------------------|:------------------------|:------------------------|-------------------------------:|:---------------------------------|--------------------:|--------------------:|--------------------:|-----------------:|:------------------|:-------------------------------|:------------------------|-----------:|------------------------:|---------------:|-----------------:|--------:|------------:|--------:|---------:|-------:|-------:|--------:|--------:|--------:|-------:|--------:|-------:|---------:|-------:|-------:|--------:|--------:|-------:|-------:|--------:|-------:|--------:|------------------------:|:-----------------------|:---------------------|:-------------------|:-------------------|:--------------------|:---------------|:-----------------------|:------|:--------|:-----------------------------------|:-----|:--------|:---------------|-----------------------:|----------------------------:|------------------------------:|------------------------:|----------------:|----------------------------------------:|-----------------------:|-----------------------:|-----------------------:|------------------------:|:------------------------------|---------------------------:|--------------------:|-----------------:|:-------------------------|
| ZBISHW14 | 2015-07-24 00:00:00.000 |  4       |                   -2.79944  | Central North | NORTH WESTERNERS            | BISHOPSWOOD      |                         |                 |               1198 |                 3538.58 |                   1145 |                         53 |                                0 |                        3538.58 |                   0     |                         | N                     | D                                        | R,S                                          | 4                           |          1.20056  |         -0.294444 |              2.55375 |              0       |        2.37228  |         2.05195 |                       2.27969  |                         6.85049 |                        0.670405  |                     1045 |                        1601 |               0 |               1 |               1 |               0 |               0 |               0 |               0 |               0 |               2 |                                  49 | Y                                                | 1               | 0             | 0             | 0                   | 1             |                        63591 | 2019-04-01 00:00:00.000 | Sound                            | 2020-03-31 00:00:00.000     |                                 | 2016-03-15 00:00:00.000       | 2018-03-26 00:00:00.000 |                         |                          62449 | ZALDBR02                         |            5.10906  |            5.99548  |            4.8      |        17.3499   | No                |                                | 2018-06-13 00:00:00.000 |         73 |                    43   |           43   |                0 |       0 |           0 |       0 |        0 |      0 |      0 |       0 |       0 |      40 |    0   |     3   |      0 |        0 |      0 |      0 |       0 |       0 |      0 |      0 |       0 |      0 |       0 |                       0 |                        |                      |                    |                    |                     |                |                        |       |         |                                    |      |         |                |               -48.5245 |                       94.89 |                          5.11 |                   0     |               0 |                                       0 |                      0 |                      0 |                     30 |                       1 | Aggregated From All Days      |                    3.53858 |             0       |              0.3 | Initial                  |
| ZBISHW18 | 2015-05-04 00:00:00.000 |  6.9     |                    3.52525  | Central North | NORTH WESTERNERS            | BISHOPSWOOD      |                         |                 |               2354 |                12259.9  |                   2148 |                        206 |                                1 |                       12259.9  |                   0     | 2018-11-30 00:00:00.000 | Y                     |                                          | R,S                                          |                             |         10.4253   |         10.8224   |             17.6088  |             18.7509  |        7.23278  |         7.26634 |                       6.955    |                        10.6364  |                        0.589956  |                      542 |                         516 |               0 |               3 |               0 |               7 |               6 |              13 |               0 |               8 |               2 |                                  33 | Y                                                | 2               | 0             | 0             | 1                   | 6             |                        63588 | 2019-04-01 00:00:00.000 | Sound                            | 2020-03-31 00:00:00.000     |                                 | 2017-02-01 00:00:00.000       | 2018-01-09 00:00:00.000 |                         |                          62453 | ZALDBR02                         |           15.6255   |           10.7249   |            8.28     |       -31.3633   | No                |                                | 2019-03-28 00:00:00.000 |        361 |                   475   |          475   |                0 |       0 |           0 |      16 |        0 |      0 |      0 |       0 |       0 |       9 |    0   |   450   |      0 |        0 |      0 |      0 |       0 |       0 |      0 |      0 |       0 |      0 |       0 |                       6 | 0.024                  | 3                    | 0                  | 0                  | 0                   | 1              | 0                      | 0     | 1       | 0                                  | 0    | 2       | 2              |               -13.1059 |                      100    |                          0    |                  28.571 |               0 |                                       0 |                      0 |                      0 |                      0 |                      10 | Aggregated From All Days      |                   12.2599  |             0.28571 |              1   | Initial                  |
| ZBLUNS15 | 2013-04-24 00:00:00.000 | 14.09    |                    6.49208  | Thames Valley | SWINDON                     | BLUNSDON         |                         |                 |               7293 |                37413.7  |                   6171 |                       1122 |                                1 |                       35194.3  |                2219.4   |                         | N                     |                                          | R                                            |                             |         20.5821   |         22.2509   |             41.9709  |             43.0351  |        9.10666  |        11.0981  |                       8.13444  |                         4.01535 |                        0.217419  |                      197 |                          18 |               1 |               6 |               7 |              15 |              21 |              80 |               5 |               5 |               4 |                                  14 |                                                  | 0               | 0             | 1             | 6                   | 3             |                        63678 | 2019-04-01 00:00:00.000 | Sound                            | 2020-03-31 00:00:00.000     |                                 | 2015-03-26 00:00:00.000       | 2017-03-31 00:00:00.000 |                         |                          60660 | ZALDBR02                         |           21.2667   |           22.8874   |           16.9081   |         7.62094  | No                | Sounding                       | 2019-03-29 00:00:00.000 |        727 |                  1969   |         1946   |               23 |     723 |           0 |     415 |        1 |      0 |      0 |     162 |       0 |      16 |  176.5 |   452.5 |      0 |        0 |      0 |      0 |       0 |      23 |      0 |      0 |       0 |      0 |       0 |                       0 |                        |                      |                    |                    |                     |                |                        |       |         |                                    |      |         |                |                -8.8178 |                       73.68 |                         23.26 |                 100     |               0 |                                       0 |                      0 |                      0 |                      0 |                       0 | Calculated From Weekly Flows  |                   37.4137  |             1       |              1   | Initial                  |
| ZCHIGB01 | 2015-10-10 00:00:00.000 |  9.11111 |                    3.33408  | Eastern North | SEWARDSTONE PLUS            | CHIGWELL BOOSTER |                         |                 |               3284 |                36210.3  |                   3163 |                        121 |                                1 |                       32908.1  |                3302.25  | 2019-06-25 00:00:00.000 | Y                     |                                          | R,S                                          |                             |         12.4452   |         12.4844   |             24.1566  |             24.5579  |        8.12562  |         8.03489 |                       7.61636  |                         8.34924 |                        0.224401  |                      104 |                         130 |               4 |               3 |               0 |              13 |              34 |              12 |               6 |              19 |               7 |                                  18 | Y                                                | 13              | 0             | 0             | 3                   | 5             |                        63098 | 2019-04-01 00:00:00.000 | Sound                            | 2020-03-31 00:00:00.000     | 2011-02-07 00:00:00.000         | 2014-03-07 00:00:00.000       | 2015-09-04 00:00:00.000 |                         |                          62513 | ZALDBR02                         |           11.483    |           10.9336   |           10.9333   |        -4.78527  | No                |                                | 2019-03-27 00:00:00.000 |        360 |                   432.5 |          432.5 |                0 |       0 |           0 |       0 |        0 |      0 |      0 |       0 |       0 |     199 |    0   |   233.5 |      0 |        0 |      0 |      0 |       0 |       0 |      0 |      0 |       0 |      0 |       0 |                      24 | 0.208                  | 26                   | 2                  | 2                  | 0                   | 3              | 0                      | 3     | 0       | 0                                  | 0    | 6       | 8              |               -10.6066 |                       81.32 |                         17.87 |                  57.143 |               0 |                                       0 |                      0 |                      0 |                      0 |                      13 | Aggregated From Operable Days |                   36.2103  |             0.57143 |              1   | Initial                  |
| ZHOGSB03 | 2017-09-11 00:00:00.000 |  0.28    |                    0.460306 | Central South | GUILDFORD                   | HOGS BACK        | 2015-01-01 00:00:00.000 |                 |                130 |                 4843.87 |                     78 |                         52 |                               39 |                        4150.08 |                 693.79  | 2017-11-07 00:00:00.000 | Y                     |                                          | S                                            |                             |          0.740306 |          0.815028 |              1.47422 |              1.56517 |        0.462281 |         0.53409 |                       0.462281 |                        12.8016  |                        0.0954363 |                     1471 |                        1601 |               0 |               0 |               0 |               0 |               0 |               0 |               0 |               0 |               0 |                                 221 |                                                  |                 |               |               |                     |               |                        61215 | 2017-04-01 00:00:00.000 | ZALDBR02                         | 2025-03-31 00:00:00.000     |                                 |                               | 2017-02-17 00:00:00.000 |                         |                          59141 | Sound                            |            0.516367 |            0.670685 |            0.336111 |        29.8855   | No                |                                | 2017-02-17 00:00:00.000 |        322 |                    55   |           55   |                0 |       0 |           0 |       0 |        1 |      0 |      0 |       4 |       0 |       0 |    0   |    50   |      0 |        0 |      0 |      0 |       0 |       0 |      0 |      0 |       0 |      0 |       0 |                       0 |                        |                      |                    |                    |                     |                |                        |       |         |                                    |      |         |                |                -9.7391 |                       95.01 |                          4.99 |                 100     |               0 |                                       0 |                      0 |                      0 |                      0 |                       0 | Calculated From Weekly Flows  |                    4.84387 |             1       |              1   |                          |
| ZMAIDL33 | 2010-04-22 00:00:00.000 |  7.56111 |                    0.144306 | Central North | MAIDEN LANE & PUTNEY        | MAIDEN LANE      |                         |                 |               3436 |                12505.9  |                   3361 |                         75 |                                0 |                       11918.6  |                 587.366 | 2016-08-02 00:00:00.000 | Y                     |                                          | R,S                                          |                             |          7.70542  |          8.30894  |             17.7341  |             18.3819  |        3.78542  |         4.40477 |                       3.20672  |                         3.35978 |                        0.30269   |                      251 |                         695 |               1 |               1 |               6 |               2 |               5 |              10 |               1 |               9 |               6 |                                  29 |                                                  | 1               | 0             | 1             | 2                   | 2             |                        63387 | 2019-04-01 00:00:00.000 | Sound                            | 2020-03-31 00:00:00.000     |                                 | 2016-03-10 00:00:00.000       | 2018-02-27 00:00:00.000 |                         |                          62370 | ZALDBR02                         |            8.01636  |            8.1871   |            9.075    |         2.12989  | Yes               |                                | 2019-02-13 00:00:00.000 |        318 |                   274   |          274   |                0 |       0 |           0 |      12 |        0 |      0 |      0 |       0 |       0 |     129 |    3   |   130   |      0 |        0 |      0 |      0 |       0 |       0 |      0 |      0 |       0 |      0 |       0 |                       4 | 0.048                  | 6                    | 1                  | 0                  | 0                   | 0              | 0                      | 1     | 0       | 0                                  | 0    | 0       | 2              |                -9.4007 |                       96.44 |                          3.56 |                 100     |               0 |                                       0 |                      0 |                      0 |                      0 |                       0 | Calculated From Weekly Flows  |                   12.5059  |             1       |              1   | Initial                  |
| ZOVERT03 | 2016-06-22 00:00:00.000 |  5.45    |                    1.25686  | Thames Valley | SWINDON                     | OVERTOWN         |                         |                 |               3688 |                18730.7  |                   3267 |                        421 |                                0 |                       18652.5  |                  78.149 |                         | N                     |                                          | R,S                                          |                             |          6.70686  |          6.70939  |             16.5266  |             16.9016  |        1.66632  |         1.79002 |                       1.62002  |                         1.58137 |                        0.0864903 |                      714 |                         285 |               2 |               1 |               0 |               1 |              27 |              14 |               0 |               2 |               4 |                                   1 |                                                  | 0               | 0             | 0             | 0                   | 2             |                        63744 | 2019-04-01 00:00:00.000 | Sound                            | 2020-03-31 00:00:00.000     |                                 | 2013-03-21 00:00:00.000       | 2015-03-10 00:00:00.000 |                         |                          60705 | ZALDBR02                         |            5.97112  |            7.87799  |            6.54     |        31.9349   | No                | Sounding                       | 2019-01-08 00:00:00.000 |        647 |                   426   |          424   |                2 |      86 |           0 |      77 |        0 |      0 |      0 |      23 |       0 |       0 |   13.5 |   154.5 |     70 |        0 |      0 |      0 |       0 |       2 |      0 |      0 |       0 |      0 |       0 |                       2 | 0.038                  | 4.75                 | 1                  | 0                  | 0                   | 0              | 1                      | 0     | 0       | 0                                  | 0    | 0       | 0              |                -8.1583 |                       56.29 |                         43.22 |                 100     |               0 |                                       0 |                      0 |                      0 |                      0 |                       0 | Calculated From Weekly Flows  |                   18.7307  |             1       |              1   | Initial                  |
| ZTILEH25 | 2015-04-25 00:00:00.000 |  7.02    |                    4.56508  | Thames Valley | READING                     | TILEHURST        |                         |                 |               3685 |                24257.9  |                   3597 |                         88 |                                1 |                       23175.9  |                1082.03  | 2019-04-17 00:00:00.000 | Y                     |                                          | R                                            |                             |         11.5851   |         11.7712   |             22.2586  |             23.0487  |        7.22828  |         7.39138 |                       5.88569  |                         5.74993 |                        0.24263   |                      471 |                         122 |               0 |               3 |               4 |               9 |              27 |              20 |               0 |               5 |               1 |                                   4 |                                                  | 0               | 0             | 2             | 7                   | 1             |                        64052 | 2019-04-01 00:00:00.000 | Sound                            | 2020-03-31 00:00:00.000     |                                 | 2015-03-03 00:00:00.000       | 2017-02-14 00:00:00.000 |                         |                          60514 | ZALDBR02                         |            8.33003  |            9.66431  |            8.42389  |        16.0177   | No                | Full Investigate - Full survey | 2019-03-27 00:00:00.000 |        725 |                  1181   |         1176   |                5 |     269 |           0 |     135 |       18 |      0 |      0 |      97 |       0 |       0 |   43.5 |   601.5 |      8 |        4 |      0 |      0 |       0 |       5 |      0 |      0 |       0 |      0 |       0 |                       0 |                        |                      |                    |                    |                     |                |                        |       |         |                                    |      |         |                |                -3.2432 |                       94.62 |                          5.38 |                 100     |               0 |                                       0 |                      0 |                      0 |                      0 |                       0 | Calculated From Weekly Flows  |                   24.2579  |             1       |              1   | Initial                  |
| ZBARHT50 | 2014-09-26 00:00:00.000 |  3.2     |                    2.01008  | Central North | BARROW HILL & SHOOT UP HILL | BARROW HILL      |                         |                 |                793 |                 4811.58 |                    780 |                         13 |                                0 |                        4811.58 |                   0     | 2018-03-23 00:00:00.000 | Y                     |                                          | R,S                                          |                             |          5.21008  |          5.52186  |              8.23113 |              8.94509 |        4.12794  |         4.38994 |                       3.4798   |                        15.7973  |                        0.723213  |                     1341 |                         591 |               0 |               0 |               0 |               3 |               3 |              11 |               0 |               0 |               1 |                                  28 |                                                  | 0               | 0             | 0             | 6                   | 1             |                        63256 | 2019-04-01 00:00:00.000 | Sound                            | 2020-03-31 00:00:00.000     |                                 | 2016-03-02 00:00:00.000       | 2018-02-22 00:00:00.000 |                         |                          62296 | ZALDBR02                         |            3.90859  |            4.32198  |            3.84     |        10.5763   | No                |                                | 2019-03-14 00:00:00.000 |        347 |                   166   |          166   |                0 |       0 |           0 |       0 |        0 |      0 |      0 |       0 |       0 |       0 |    0   |   166   |      0 |        0 |      0 |      0 |       0 |       0 |      0 |      0 |       0 |      0 |       0 |                      11 | 0.076                  | 9.5                  | 0                  | 0                  | 0                   | 0              | 0                      | 0     | 0       | 0                                  | 0    | 2       | 9              |                 1.0936 |                       24.25 |                         67.9  |                 100     |               0 |                                       0 |                      0 |                      0 |                      0 |                       0 | Calculated From Weekly Flows  |                    4.81158 |             1       |              1   | Initial                  |
| ZCHIGW03 | 2017-03-15 00:00:00.000 |  4.23056 |                    2.35722  | Eastern North | SEWARDSTONE PLUS            | CHIGWELL         |                         |                 |               2007 |                13015.1  |                   1677 |                        330 |                                2 |                       13015.1  |                   0     | 2018-09-28 00:00:00.000 | Y                     |                                          | R,S                                          |                             |          6.58778  |          6.29575  |             13.8909  |             14.0467  |        3.36424  |         2.98614 |                       2.99387  |                         5.37018 |                        0.230031  |                      204 |                          67 |               5 |               5 |               4 |              17 |              58 |               5 |               0 |              12 |               2 |                                  16 |                                                  | 8               | 0             | 0             | 2                   | 2             |                        63103 | 2019-04-01 00:00:00.000 | Sound                            | 2020-03-31 00:00:00.000     |                                 | 2014-03-30 00:00:00.000       | 2014-09-15 00:00:00.000 |                         |                          62518 | ZALDBR02                         |            5.69559  |            5.66219  |            5.075    |        -0.586549 | No                |                                | 2019-03-15 00:00:00.000 |        348 |                   335.5 |          335.5 |                0 |       0 |           0 |      26 |        0 |      0 |      0 |       0 |       0 |      24 |    0   |   285.5 |      0 |        0 |      0 |      0 |       0 |       0 |      0 |      0 |       0 |      0 |       0 |                       7 | 0.032                  | 4                    | 0                  | 0                  | 0                   | 0              | 0                      | 1     | 0       | 0                                  | 0    | 3       | 3              |                -1.2393 |                       93.63 |                          6.37 |                 100     |               0 |                                       0 |                      0 |                      0 |                      0 |                       0 | Calculated From Weekly Flows  |                   13.0151  |             1       |              1   | Initial                  |


Table: which netbase_pipes
| dma      | pipe_function          | length   |
|:---------|:-----------------------|:---------|
| ZBISHW14 | valid_from_date_origin |          |
| ZBISHW18 | valid_from_date_origin |          |
| ZBLUNS15 | valid_from_date_origin |          |
| ZCHIGB01 | valid_from_date_origin |          |
| ZMAIDL03 | valid_from_date_origin |          |
| ZMAIDL33 | valid_from_date_origin |          |
| ZOVERT03 | valid_from_date_origin |          |
| ZOVPRV05 | valid_from_date_origin |          |
| ZSTKWD19 | valid_from_date_origin |          |
| ZSTKWD42 | valid_from_date_origin |          |


Table: which netbase_properties
| dma      | property_type   |   number_properties |
|:---------|:----------------|--------------------:|
| ZBISHW14 | Household       |                1145 |
| ZBISHW18 | Household       |                2148 |
| ZBLUNS15 | Household       |                6171 |
| ZCHIGB01 | Household       |                3163 |
| ZHAM3613 | Household       |                2088 |
| ZHOGSB03 | Household       |                  78 |
| ZMAIDL03 | Household       |                2195 |
| ZMAIDL33 | Household       |                3361 |
| ZNORWD44 | Household       |                1141 |
| ZOVERT03 | Household       |                3267 |


Table: which permanet_source
| dma      |   total_sites | dma_name           | region       | phase   |
|:---------|--------------:|:-------------------|:-------------|:--------|
| ZOVPRV08 |           146 | DMA - ZOVPRV08     | South London |         |
| ZOVPRV05 |           121 | DMA - ZOVPRV05     | South London |         |
| ZSTRMR05 |            19 | DMA - ZSTRMR05     | South London |         |
| ZSTRMR04 |           109 | DMA - ZSTRMR04 PH2 | South London |         |
| ZRUSSH19 |            98 | DMA - ZRUSSH19 PH2 | South London |         |
| ZNORWD19 |           106 | DMA - ZNORWD19     | South London |         |
| ZFRNBO25 |           123 | DMA - ZFRNBO25 PH2 | South London |         |
| ZHAM4209 |           149 | DMA - ZHAM4209     | South London |         |
| ZNORWD20 |           118 | DMA - ZNORWD20 PH2 | South London |         |
| ZSTRMR08 |            87 | DMA - ZSTRMR08     | South London |         |


Table: which rank_categorisation
| dma      | category      | leakagepriority   | laolpriority   |   onestep |   onestepexit |   fullstep |   fullstepexit |   prioritisation |   lan_v_/_detection_duration |   rank |
|:---------|:--------------|:------------------|:---------------|----------:|--------------:|-----------:|---------------:|-----------------:|-----------------------------:|-------:|
| ZABIND02 | DMA Reduction | Low               | Low            |  1.30712  |      1.21461  |   2.52173  |              0 |        1.27015   |                    1.25968   |    699 |
| ZABIND04 | DMA Reduction | Low               | Low            |  0.407212 |      0.537067 |   0.944279 |              0 |        1.01483   |                    0.896321  |    879 |
| ZABIND05 | DMA Reduction | Low               | Low            |  0.432444 |      0.502136 |   0.93458  |              0 |        1.1051    |                    0.990392  |    834 |
| ZABIND06 | DMA Reduction | Low               | Low            |  0.456409 |      0.453909 |   0.910318 |              0 |        1.53713   |                    1.48595   |    611 |
| ZABIND08 | DMA Reduction | Low               | Low            |  0.133307 |      0.435888 |   0.569196 |              0 |        1.54182   |                    1.59583   |    568 |
| ZADDIN05 | DMA Reduction | Low               | Low            |  2.17985  |      1.62242  |   3.80226  |              0 |        1.18354   |                    1.05663   |    796 |
| ZALDBN01 | DMA Reduction | Low               | Low            |  1.8323   |      0.791963 |   2.62427  |              0 |        2.79848   |                    2.20835   |    408 |
| ZALDTW01 | DMA Reduction | Low               | Low            |  0.729743 |      0.145276 |   0.875019 |              0 |        2.67775   |                    2.46771   |    358 |
| ZARDLY03 | DMA Reduction | Low               | Low            |  0.656706 |      1.39668  |   2.05339  |              0 |        2.15699   |                    0.977799  |    841 |
| ZARDLY04 | DMA Reduction | Low               | Low            |  0.283594 |      0.714568 |   0.998162 |              0 |       -0.0450532 |                   -0.0290083 |   1263 |


Table: which rank_categorisation_leakage_steps
| dma      | Level          |   Leakage Value | Step      |
|:---------|:---------------|----------------:|:----------|
| ZABINB01 | Full Step Exit |               0 | Full Step |
| ZABIND02 | Full Step Exit |               0 | Full Step |
| ZABIND04 | Full Step Exit |               0 | Full Step |
| ZABIND05 | Full Step Exit |               0 | Full Step |
| ZABIND06 | Full Step Exit |               0 | Full Step |
| ZABIND08 | Full Step Exit |               0 | Full Step |
| ZADDIN01 | Full Step Exit |               0 | Full Step |
| ZADDIN02 | Full Step Exit |               0 | Full Step |
| ZADDIN03 | Full Step Exit |               0 | Full Step |
| ZADDIN05 | Full Step Exit |               0 | Full Step |


Table: which rank_reactive
| dma      | date                    |      mcf |   perc_data_available |    day_move |   week_move |   reactive_step | week_day   |      lan | suspect_meter_error   |   reactive_rank | lan_entry_date          | nightline_confidence   |   data_availability |
|:---------|:------------------------|---------:|----------------------:|------------:|------------:|----------------:|:-----------|---------:|:----------------------|----------------:|:------------------------|:-----------------------|--------------------:|
| ZNEWFM08 | 2019-08-24 00:00:00.000 | 0.33048  |                     0 | -0.02568    |           0 |               0 | W          | 0.127872 | null                  |             895 | 2015-01-10 00:00:00.000 | Good                   |                   1 |
| ZRUSSH03 | 2019-08-24 00:00:00.000 | 0.836694 |                     0 | -0.0124859  |           0 |               0 | W          | 0.703032 | null                  |             895 | 2013-10-01 00:00:00.000 | Good                   |                   1 |
| ZBISHW19 | 2019-08-24 00:00:00.000 | 0.531433 |                     0 | -0.0291367  |           0 |               0 | W          | 0.405744 | null                  |             895 | 2007-03-10 00:00:00.000 | Good                   |                   1 |
| ZCRCHH15 | 2019-08-24 00:00:00.000 | 0.612586 |                     0 | -0.0248079  |           0 |               0 | W          | 0.45792  | null                  |             895 | 2015-05-04 00:00:00.000 | Good                   |                   1 |
| ZCRCHH86 | 2019-08-24 00:00:00.000 | 0.604859 |                     0 | -0.0327982  |           0 |               0 | W          | 0.6048   | null                  |             895 | 2016-09-22 00:00:00.000 | Good                   |                   1 |
| ZSEWRD56 | 2019-08-24 00:00:00.000 | 0.349912 |                     0 | -0.0078942  |           0 |               0 | W          | 0.31272  | null                  |             895 | 2016-12-15 00:00:00.000 | Good                   |                   1 |
| ZCHIGW31 | 2019-08-24 00:00:00.000 | 0.341294 |                     0 | -0.0638463  |           0 |               0 | W          | 0.32304  | null                  |             895 | 2016-11-30 00:00:00.000 | Good                   |                   1 |
| ZFRNBO13 | 2019-08-24 00:00:00.000 | 0.567341 |                     0 | -0.00746448 |           0 |               0 | W          | 0.100392 | null                  |             895 | 2014-07-14 00:00:00.000 | Good                   |                   1 |
| ZHOGSB02 | 2019-08-24 00:00:00.000 | 9.09369  |                     0 | -0.631001   |           0 |               0 | W          | 0.308448 | null                  |             895 | 2017-10-12 00:00:00.000 | Good                   |                   1 |
| ZSUR3018 | 2019-08-24 00:00:00.000 | 0.6496   |                     0 | -0.0123361  |           0 |               0 | W          | 0.44064  | null                  |             895 | 2002-05-22 00:00:00.000 | Good                   |                   1 |


Table: which rank_recovery
| dma      |   net_night_flow_l/s |   net_night_flow_lan_variance_l/s |   latest_laol_value |   dma_laol_variance_l/s |   detection_duration_factor |   lan_v_/_detection_duration |   laol_v_/_detection_duration |   rank_laol |   rank_lan | net_night_flow_confidence   | comments   |
|:---------|---------------------:|----------------------------------:|--------------------:|------------------------:|----------------------------:|-----------------------------:|------------------------------:|------------:|-----------:|:----------------------------|:-----------|
| ZFARNH16 |             13.6756  |                          10.0306  |           0         |                11.4216  |                   0.0178639 |                     561.501  |                      639.37   |           2 |          1 | High                        | Operable   |
| ZWOODF56 |             27.155   |                          16.7251  |           0         |                25.9959  |                   0.0371809 |                     449.831  |                      699.173  |           1 |          2 | High                        | Operable   |
| ZHAM3641 |              7.26483 |                           7.15006 |           0         |                 6.91567 |                   0.0594127 |                     120.346  |                      116.4    |           3 |          3 | High                        | Operable   |
| ZHAM3643 |             24.64    |                          23.7422  |          10.45      |                 8.15577 |                   0.343871  |                      69.044  |                       23.7176 |          14 |          4 | High                        | Operable   |
| ZHAM3624 |              1.34956 |                           1.43625 |           0.0861111 |                 1.08386 |                   0.040333  |                      35.6098 |                       26.8728 |          11 |          6 | High                        | Operable   |
| ZWIDDN30 |              7.2905  |                           6.14364 |           0.347222  |                 3.79022 |                   0.219383  |                      28.0041 |                       17.2767 |          21 |          7 | High                        | Operable   |
| ZEALNG15 |              8.25511 |                           5.98    |           1.95602   |                 4.65826 |                   0.271152  |                      22.054  |                       17.1795 |          22 |         10 | High                        | Operable   |
| ZHOGSB04 |              1.99458 |                           1.90875 |           0.02015   |                 1.77804 |                   0.099639  |                      19.1567 |                       17.8448 |          20 |         15 | High                        | Operable   |
| ZRIVSE27 |              1.47378 |                           1.04192 |           0         |                 1.27485 |                   0.060213  |                      17.3039 |                       21.1723 |          15 |         17 | High                        | Operable   |
| ZWOODF84 |              9.80787 |                           5.56947 |           2.25694   |                 4.89665 |                   0.415355  |                      13.4089 |                       11.7891 |          32 |         20 | High                        | Operable   |


Table: which rank_reduction
| dma      |   current_dma_leakage_l/s |   current_dma_leakage_l/prop/d |   current_dma_leakage_m3/km/d | reduce_rank_value   | current_dma_leakage_rank   |
|:---------|--------------------------:|-------------------------------:|------------------------------:|:--------------------|:---------------------------|
| ZBISHW14 |                 2.05195   |                       147.987  |                      50.1015  |                     |                            |
| ZMAIDL03 |                 2.04816   |                        75.8514 |                      30.2652  |                     |                            |
| ZSEWRD39 |                 0.0500868 |                       116.959  |                       1.96152 |                     |                            |
| ZEARLB08 |                 1.72571   |                        93.0722 |                      11.4504  |                     |                            |
| ZNORWD43 |                 5.29299   |                       155.022  |                      34.6048  |                     |                            |
| ZPUTNY42 |                 6.13274   |                       197.934  |                      56.2164  |                     |                            |
| ZSHEPD01 |                 2.43475   |                        99.4622 |                      10.1827  |                     |                            |
| ZFRNBO10 |                 2.97637   |                       123.634  |                      12.6195  |                     |                            |
| ZPUTNY09 |                 3.39113   |                        66.2281 |                      19.8409  |                     |                            |
| ZWOODF26 |                 0.731469  |                        16.4752 |                       2.00061 |                     |                            |


Table: which sap_ecc_processed
| dma      | maintactivitytype   | mains_comm_other   |   count |   outstanding_work |
|:---------|:--------------------|:-------------------|--------:|-------------------:|
| ZOXLWD27 | AL                  | Comms              |       1 |                  1 |
| ZCRCHH68 | AL                  | Comms              |       1 |                  1 |
| ZTILET03 | AL                  | Comms              |       1 |                  1 |
| ZWIDDN14 | AL                  | Comms              |       1 |                  1 |
| ZCRCHH80 | AL                  | Comms              |       1 |                  1 |
| ZRIVSE07 | AL                  | Comms              |       1 |                  1 |
| ZFINSB77 | AL                  | Comms              |       1 |                  1 |
| ZHAM3630 | AL                  | Comms              |       1 |                  1 |
| ZCRYST02 | AL                  | Comms              |       1 |                  1 |
| ZHORNS12 | AL                  | Comms              |       1 |                  1 |


Table: which tow
| dma   | work_type   |   outstanding_work_l/s |
|:------|:------------|-----------------------:|
|       | SAP         |                      1 |
|       | SAP         |                      1 |
|       | SAP         |                      1 |
|       | SAP         |                      1 |
|       | SAP         |                      1 |
|       | SAP         |                      1 |
|       | SAP         |                      1 |
|       | SAP         |                      1 |
|       | SAP         |                      1 |
|       | SAP         |                      1 |


Table: which war_processed
| dma      |   contd_logged_meters |   available_contd_logged_meters |   contd_logged_meters_no_unavailable |
|:---------|----------------------:|--------------------------------:|-------------------------------------:|
| ZKIDDP04 |                     0 |                               0 |                                    0 |
| ZELTHM03 |                     0 |                               0 |                                    0 |
| ZCIREN04 |                     0 |                               0 |                                    0 |
| ZEALNG15 |                     0 |                               0 |                                    0 |
| ZBEGBH07 |                     0 |                               0 |                                    0 |
| ZSEWRD42 |                     0 |                               0 |                                    0 |
| ZOXLWD21 |                     0 |                               0 |                                    0 |
| ZBRASN04 |                     0 |                               0 |                                    0 |
| ZFINSB50 |                     0 |                               0 |                                    0 |
| ZCHIGW53 |                     0 |                               0 |                                    0 |


Table: which z_one_closed_campaigns
| dma       | survey_finish_date      | job_type                 |   job_id | activity_type   | validation   |
|:----------|:------------------------|:-------------------------|---------:|:----------------|:-------------|
| ZCRCHH100 | 2019-04-09 00:00:00.000 | DMA Targeting - Recovery |   223240 | SOUNDING        |              |
| ZEALNG17  | 2019-07-23 00:00:00.000 | DMA Targeting - Recovery |   228403 | SOUNDING        |              |
| ZMAIDL08  | 2019-06-25 00:00:00.000 | DMA Targeting - Recovery |   229985 | SOUNDING        |              |
| ZMAIDL34  | 2019-01-29 00:00:00.000 | DMA Targeting - Recovery |   217624 | SOUNDING        |              |
| ZMAIDL49  | 2019-06-20 00:00:00.000 | DMA Targeting - Recovery |   229695 | SOUNDING        |              |
| ZPUTNY20  | 2019-02-19 00:00:00.000 | DMA Targeting - Recovery |   220167 | SOUNDING        |              |
| ZSEWRD26  | 2019-06-23 00:00:00.000 | DMA Targeting - Recovery |   228158 | SOUNDING        |              |
| ZWOODF34  | 2019-08-28 00:00:00.000 | DMA Targeting - Recovery |   233706 | SOUNDING        |              |
| ZALDTW01  | 2016-04-13 00:00:00.000 | DMA Targeting - Recovery |   147512 | SOUNDING        |              |
| ZBEGBH08  | 2016-09-28 00:00:00.000 | DMA Targeting - Recovery |   159093 | SOUNDING        |              |


Table: which z_one_open_campaigns
| dma      | type     |   days_at_status | target        | status   |
|:---------|:---------|-----------------:|:--------------|:---------|
| ZRIVSE24 | Recovery |                3 | Noise Logging | Schedule |
| ZRIVSE07 | Recovery |               30 | Noise Logging | Schedule |
| ZRIVSE19 | Recovery |               16 | Noise Logging | Schedule |
| ZRIVSE29 | Recovery |               30 | Noise Logging | Schedule |
| ZRUSSH06 | Recovery |               48 | Noise Logging | Schedule |
| ZELTHM22 | Recovery |              122 | Noise Logging | Schedule |
| ZWWICK05 | Recovery |               17 | Noise Logging | Schedule |
| ZWWICK01 | Recovery |               16 | Noise Logging | Schedule |
| ZEALNG23 | Recovery |               59 | Noise Logging | Schedule |
| ZHAMPS02 | Recovery |               17 | Noise Logging | Schedule |

 


tables: name: which anm
data: which anm.csv
name: which csl_processed
data: which csl_processed.csv
name: which dma
data: which dma.csv
name: which flow_hist_mcf
data: which flow_hist_mcf.csv
name: which flow_live_dma
data: which flow_live_dma.csv
name: which fmz
data: which fmz.csv
name: which laol_clean
data: which laol_clean.csv
name: which netbase_bma_clean
data: which netbase_bma_clean.csv
name: which netbase_bma_summary
data: which netbase_bma_summary.csv
name: which netbase_dma_clean
data: which netbase_dma_clean.csv
name: which netbase_pipes
data: which netbase_pipes.csv
name: which netbase_properties
data: which netbase_properties.csv
name: which permanet_source
data: which permanet_source.csv
name: which rank_categorisation
data: which rank_categorisation.csv
name: which rank_categorisation_leakage_steps
data: which rank_categorisation_leakage_steps.csv
name: which rank_reactive
data: which rank_reactive.csv
name: which rank_recovery
data: which rank_recovery.csv
name: which rank_reduction
data: which rank_reduction.csv
name: which sap_ecc_processed
data: which sap_ecc_processed.csv
name: which tow
data: which tow.csv
name: which war_processed
data: which war_processed.csv
name: which z_one_closed_campaigns
data: which z_one_closed_campaigns.csv
name: which z_one_open_campaigns
data: which z_one_open_campaigns.csv
label: which rank_reduction
dma
which dma
dma_code
which rank_reactive
dma
which dma
dma_code
which rank_categorisation
dma
which dma
dma_code
which rank_recovery
dma
which dma
dma_code
which permanet_source
dma
which dma
dma_code
which netbase_dma_clean
dma
which dma
dma_code
which laol_clean
dma
which dma
dma_code
which flow_hist_mcf
dma
which dma
dma_code
which flow_live_dma
dma
which dma
dma_code
which dma
fmz_code
which fmz
fmz_code
which fmz
fk_anm
which anm
anm
which netbase_properties
dma
which dma
dma_code
which netbase_pipes
dma
which dma
dma_code
which z_one_closed_campaigns
dma
which dma
dma_code
which z_one_open_campaigns
dma
which dma
dma_code
which war_processed
dma
which dma
dma_code
which netbase_bma_summary
dma
which dma
dma_code
which sap_ecc_processed
dma
which dma
dma_code
which csl_processed
dma
which dma
dma_code
which tow
dma
which dma
dma_code
which rank_categorisation_leakage_steps
dma
which dma
dma_code
which netbase_bma_clean
dma
which dma
dma_code
output: {
    "joins": [
        {
            "from_table": "which rank_reduction",
            "from_column": "dma",
            "to_table": "which dma",
            "to_column": "dma_code"
        },
        {
            "from_table": "which rank_reactive",
            "from_column": "dma",
            "to_table": "which dma",
            "to_column": "dma_code"
        },
        {
            "from_table": "which rank_categorisation",
            "from_column": "dma",
            "to_table": "which dma",
            "to_column": "dma_code"
        },
        {
            "from_table": "which rank_recovery",
            "from_column": "dma",
            "to_table": "which dma",
            "to_column": "dma_code"
        },
        {
            "from_table": "which permanet_source",
            "from_column": "dma",
            "to_table": "which dma",
            "to_column": "dma_code"
        },
        {
            "from_table": "which netbase_dma_clean",
            "from_column": "dma",
            "to_table": "which dma",
            "to_column": "dma_code"
        },
        {
            "from_table": "which laol_clean",
            "from_column": "dma",
            "to_table": "which dma",
            "to_column": "dma_code"
        },
        {
            "from_table": "which flow_hist_mcf",
            "from_column": "dma",
            "to_table": "which dma",
            "to_column": "dma_code"
        },
        {
            "from_table": "which flow_live_dma",
            "from_column": "dma",
            "to_table": "which dma",
            "to_column": "dma_code"
        },
        {
            "from_table": "which dma",
            "from_column": "fmz_code",
            "to_table": "which fmz",
            "to_column": "fmz_code"
        },
        {
            "from_table": "which fmz",
            "from_column": "fk_anm",
            "to_table": "which anm",
            "to_column": "anm"
        },
        {
            "from_table": "which netbase_properties",
            "from_column": "dma",
            "to_table": "which dma",
            "to_column": "dma_code"
        },
        {
            "from_table": "which netbase_pipes",
            "from_column": "dma",
            "to_table": "which dma",
            "to_column": "dma_code"
        },
        {
            "from_table": "which z_one_closed_campaigns",
            "from_column": "dma",
            "to_table": "which dma",
            "to_column": "dma_code"
        },
        {
            "from_table": "which z_one_open_campaigns",
            "from_column": "dma",
            "to_table": "which dma",
            "to_column": "dma_code"
        },
        {
            "from_table": "which war_processed",
            "from_column": "dma",
            "to_table": "which dma",
            "to_column": "dma_code"
        },
        {
            "from_table": "which netbase_bma_summary",
            "from_column": "dma",
            "to_table": "which dma",
            "to_column": "dma_code"
        },
        {
            "from_table": "which sap_ecc_processed",
            "from_column": "dma",
            "to_table": "which dma",
            "to_column": "dma_code"
        },
        {
            "from_table": "which csl_processed",
            "from_column": "dma",
            "to_table": "which dma",
            "to_column": "dma_code"
        },
        {
            "from_table": "which tow",
            "from_column": "dma",
            "to_table": "which dma",
            "to_column": "dma_code"
        },
        {
            "from_table": "which rank_categorisation_leakage_steps",
            "from_column": "dma",
            "to_table": "which dma",
            "to_column": "dma_code"
        },
        {
            "from_table": "which netbase_bma_clean",
            "from_column": "dma",
            "to_table": "which dma",
            "to_column": "dma_code"
        }
    ]
}