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: 2000 Avg MSL cf STND
|   nwlon_station_id |   Year |   2000 MSL cf STND (m) |
|-------------------:|-------:|-----------------------:|
|        9.44409e+06 |   2000 |               10.4908  |
|        9.4449e+06  |   2000 |                2.516   |
|        9.44648e+06 |   2000 |                2.2435  |
|        9.44713e+06 |   2000 |                4.42008 |
|        9.44942e+06 |   2000 |                3.50867 |
|        9.44988e+06 |   2000 |                2.52858 |


Table: Annual Avg MSL cf STND
|   Year |   MSL cf STND (m) |   nwlon_station_id |   2000 MSL cf STND (m) | Year Date               | tidal_stations.Tide Station Name   |   Change in Mean Sea Level since 2000 (in) |
|-------:|------------------:|-------------------:|-----------------------:|:------------------------|:-----------------------------------|-------------------------------------------:|
|   1950 |           4.36617 |            9447130 |                4.42008 | 1950-01-01 00:00:00.000 | Seattle, WA                        |                                  -2.1227   |
|   1951 |           4.37075 |            9447130 |                4.42008 | 1951-01-01 00:00:00.000 | Seattle, WA                        |                                  -1.94226  |
|   1952 |           4.34475 |            9447130 |                4.42008 | 1952-01-01 00:00:00.000 | Seattle, WA                        |                                  -2.96588  |
|   1953 |           4.36358 |            9447130 |                4.42008 | 1953-01-01 00:00:00.000 | Seattle, WA                        |                                  -2.22441  |
|   1954 |           4.38442 |            9447130 |                4.42008 | 1954-01-01 00:00:00.000 | Seattle, WA                        |                                  -1.4042   |
|   1955 |           4.31108 |            9447130 |                4.42008 | 1955-01-01 00:00:00.000 | Seattle, WA                        |                                  -4.29134  |
|   1956 |           4.3515  |            9447130 |                4.42008 | 1956-01-01 00:00:00.000 | Seattle, WA                        |                                  -2.70013  |
|   1957 |           4.37975 |            9447130 |                4.42008 | 1957-01-01 00:00:00.000 | Seattle, WA                        |                                  -1.58793  |
|   1958 |           4.42475 |            9447130 |                4.42008 | 1958-01-01 00:00:00.000 | Seattle, WA                        |                                   0.183727 |
|   1959 |           4.38817 |            9447130 |                4.42008 | 1959-01-01 00:00:00.000 | Seattle, WA                        |                                  -1.25656  |


Table: Combined CO2 data
| Source                                        | Data Source        |    Year |   CO2 ppm |
|:----------------------------------------------|:-------------------|--------:|----------:|
| EPICA Dome C and  Vostok Station,  Antarctica | Ice Core Estimates | -796562 |     191   |
| EPICA Dome C and  Vostok Station,  Antarctica | Ice Core Estimates | -795149 |     188.4 |
| EPICA Dome C and  Vostok Station,  Antarctica | Ice Core Estimates | -794517 |     189.3 |
| EPICA Dome C and  Vostok Station,  Antarctica | Ice Core Estimates | -793252 |     195.2 |
| EPICA Dome C and  Vostok Station,  Antarctica | Ice Core Estimates | -792658 |     199.4 |
| EPICA Dome C and  Vostok Station,  Antarctica | Ice Core Estimates | -791310 |     209   |
| EPICA Dome C and  Vostok Station,  Antarctica | Ice Core Estimates | -790993 |     204   |
| EPICA Dome C and  Vostok Station,  Antarctica | Ice Core Estimates | -790131 |     205.1 |
| EPICA Dome C and  Vostok Station,  Antarctica | Ice Core Estimates | -789541 |     215.4 |
| EPICA Dome C and  Vostok Station,  Antarctica | Ice Core Estimates | -788588 |     221.3 |


Table: Grain Per Capita
|   Market_Year | Attribute_Description   | Unit_Description   | Date                    |   Total Sum |   tidied_data_world_bank_SP POP TOTL.World Population | tidied_data_world_bank_SP POP TOTL.Download Timestamp   |   kg Grain Per Capita |
|--------------:|:------------------------|:-------------------|:------------------------|------------:|------------------------------------------------------:|:--------------------------------------------------------|----------------------:|
|          1960 | Production              | (1000 MT)          | 1960-07-01 00:00:00.000 |      808385 |                                            3032156070 |                                                         |               266.604 |
|          1961 | Production              | (1000 MT)          | 1961-07-01 00:00:00.000 |      775719 |                                            3071596055 |                                                         |               252.546 |
|          1962 | Production              | (1000 MT)          | 1962-07-01 00:00:00.000 |      828022 |                                            3124561005 |                                                         |               265.004 |
|          1963 | Production              | (1000 MT)          | 1963-07-01 00:00:00.000 |      841587 |                                            3189655687 |                                                         |               263.849 |
|          1964 | Production              | (1000 MT)          | 1964-07-01 00:00:00.000 |      890631 |                                            3255145692 |                                                         |               273.607 |
|          1965 | Production              | (1000 MT)          | 1965-07-01 00:00:00.000 |      886854 |                                            3322046795 |                                                         |               266.96  |
|          1966 | Production              | (1000 MT)          | 1966-07-01 00:00:00.000 |      972368 |                                            3392097729 |                                                         |               286.657 |
|          1967 | Production              | (1000 MT)          | 1967-07-01 00:00:00.000 |      995612 |                                            3461619724 |                                                         |               287.614 |
|          1968 | Production              | (1000 MT)          | 1968-07-01 00:00:00.000 |      989424 |                                            3532782993 |                                                         |               280.069 |
|          1969 | Production              | (1000 MT)          | 1969-07-01 00:00:00.000 |      997256 |                                            3606553753 |                                                         |               276.512 |


Table: psd_grains_pulses
|   Market_Year | Attribute_Description   | Unit_Description   | Date      |   Total Sum |
|--------------:|:------------------------|:-------------------|:----------|------------:|
|          1960 | Production              | (1000 MT)          | 1960-7-01 |      808385 |
|          1961 | Production              | (1000 MT)          | 1961-7-01 |      775719 |
|          1962 | Production              | (1000 MT)          | 1962-7-01 |      828022 |
|          1963 | Production              | (1000 MT)          | 1963-7-01 |      841587 |
|          1964 | Production              | (1000 MT)          | 1964-7-01 |      890631 |
|          1965 | Production              | (1000 MT)          | 1965-7-01 |      886854 |
|          1966 | Production              | (1000 MT)          | 1966-7-01 |      972368 |
|          1967 | Production              | (1000 MT)          | 1967-7-01 |      995612 |
|          1968 | Production              | (1000 MT)          | 1968-7-01 |      989424 |
|          1969 | Production              | (1000 MT)          | 1969-7-01 |      997256 |


Table: SNOTEL SWE 1983-1999 Avg
|   snotel_station_id | station_name    |   Base SWE In | First Date              | Last Date               |
|--------------------:|:----------------|--------------:|:------------------------|:------------------------|
|                 418 | Corral Pass     |       33.2824 | 1983-04-01 00:00:00.000 | 1999-04-01 00:00:00.000 |
|                 420 | Cougar Mountain |       15.7882 | 1983-04-01 00:00:00.000 | 1999-04-01 00:00:00.000 |
|                 515 | Harts Pass      |       44.9824 | 1983-04-01 00:00:00.000 | 1999-04-01 00:00:00.000 |
|                 672 | Olallie Meadows |       52.2765 | 1983-04-01 00:00:00.000 | 1999-04-01 00:00:00.000 |
|                 679 | Paradise        |       68.625  | 1983-04-01 00:00:00.000 | 1999-04-01 00:00:00.000 |
|                 711 | Rainy Pass      |       42.2059 | 1983-04-01 00:00:00.000 | 1999-04-01 00:00:00.000 |
|                 788 | Stampede Pass   |       44.4706 | 1983-04-01 00:00:00.000 | 1999-04-01 00:00:00.000 |
|                 791 | Stevens Pass    |       41.8412 | 1983-04-01 00:00:00.000 | 1999-04-01 00:00:00.000 |


Table: steamflow_stations
| River Type          | River Name      |   USGS Site Number |   Hydrologic Unit | Station Name                                     | Latitude   | Longitude   | GPS Datum   | Site_URL                                                                   | URL                                                                                                                                                                               |
|:--------------------|:----------------|-------------------:|------------------:|:-------------------------------------------------|:-----------|:------------|:------------|:---------------------------------------------------------------------------|:----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Rain dominant       | Samish River    |           12201500 |          17110002 | SAMISH RIVER NEAR BURLINGTON, WA                 | 48°32'46"  | 122°20'13"  | NAD27       | https://waterdata.usgs.gov/nwis/inventory/?site_no=12201500&agency_cd=USGS | https://waterdata.usgs.gov/nwis/monthly?site_no=12201500&agency_cd=USGS&por_12201500_149446=1180018,00060,149446,1943-08,2100-01&partial_periods=on&referred_module=sw&format=rdb |
| Mixed rain and snow | Snohomish River |           12150800 |          17110011 | SNOHOMISH RIVER NEAR MONROE, WA                  | 47°49'52"  | 122°02'50"  | NAD27       | https://waterdata.usgs.gov/nwis/inventory/?site_no=12150800&agency_cd=USGS | https://waterdata.usgs.gov/nwis/monthly?site_no=12150800&agency_cd=USGS&por_12150800_149182=1179792,00060,149182,1963-02,2100-01&partial_periods=on&referred_module=sw&format=rdb |
| Snow dominant       | Sauk River      |           12189500 |          17110006 | SAUK RIVER NEAR SAUK, WA                         | 48°25'29"  | 121°34'02"  | NAD27       | https://waterdata.usgs.gov/nwis/inventory/?site_no=12187500&agency_cd=USGS | https://waterdata.usgs.gov/nwis/monthly?site_no=12189500&agency_cd=USGS&por_12189500_149390=1179943,00060,149390,1911-04,2100-01&partial_periods=on&referred_module=sw&format=rdb |
| Snow dominant       | Sauk River      |           12186000 |          17110006 | SAUK RIVER AB WHITE CHUCK RIVER NR DARRINGTON, W | 48°10'08"  | 121°28'10"  | NAD27       | https://waterdata.usgs.gov/nwis/inventory/?site_no=12186000&agency_cd=USGS | https://waterdata.usgs.gov/nwis/monthly?site_no=12186000&agency_cd=USGS&por_12186000_149376=1179932,00060,149376,1917-10,2100-01&partial_periods=on&referred_module=sw&format=rdb |


Table: Streamflow Get Latest Date Per Month Station
|   site_no |   month_nu | Max Date                |
|----------:|-----------:|:------------------------|
|  12150800 |          2 | 2021-02-01 00:00:00.000 |
|  12150800 |          3 | 2021-03-01 00:00:00.000 |
|  12150800 |          4 | 2021-04-01 00:00:00.000 |
|  12150800 |          5 | 2021-05-01 00:00:00.000 |
|  12150800 |          6 | 2021-06-01 00:00:00.000 |
|  12150800 |          7 | 2021-07-01 00:00:00.000 |
|  12150800 |          8 | 2020-08-01 00:00:00.000 |
|  12150800 |          9 | 2020-09-01 00:00:00.000 |
|  12150800 |         10 | 2020-10-01 00:00:00.000 |
|  12150800 |         11 | 2020-11-01 00:00:00.000 |


Table: Streamflow Last 30 Years
|   site_no |   month_nu | Time Period   |   monthly_cfs |
|----------:|-----------:|:--------------|--------------:|
|  12150800 |          1 | Last 30 Years |      13637.1  |
|  12150800 |          2 | Last 30 Years |      11065.9  |
|  12150800 |          3 | Last 30 Years |      10147.3  |
|  12150800 |          4 | Last 30 Years |      11193.2  |
|  12150800 |          5 | Last 30 Years |      13167.5  |
|  12150800 |          6 | Last 30 Years |      11325.6  |
|  12150800 |          7 | Last 30 Years |       5759.4  |
|  12150800 |          8 | Last 30 Years |       2670    |
|  12150800 |          9 | Last 30 Years |       2901.79 |
|  12150800 |         10 | Last 30 Years |       7256.21 |


Table: Streamflow Last 5 Years
|   site_no |   month_nu | Time Period   |   monthly_cfs |
|----------:|-----------:|:--------------|--------------:|
|  12150800 |          1 | Last 5 Years  |      14726    |
|  12150800 |          2 | Last 5 Years  |      14491.6  |
|  12150800 |          3 | Last 5 Years  |       9203.6  |
|  12150800 |          4 | Last 5 Years  |      12376.6  |
|  12150800 |          5 | Last 5 Years  |      14242.6  |
|  12150800 |          6 | Last 5 Years  |      10485.6  |
|  12150800 |          7 | Last 5 Years  |       4623.6  |
|  12150800 |          8 | Last 5 Years  |       1835.5  |
|  12150800 |          9 | Last 5 Years  |       2546.75 |
|  12150800 |         10 | Last 5 Years  |       8517.75 |


Table: Streamflow Latest Available Date
|   site_no |   month_nu |   monthly_cfs | Time Period      |
|----------:|-----------:|--------------:|:-----------------|
|  12150800 |          8 |          2204 | Latest Available |
|  12150800 |          9 |          3416 | Latest Available |
|  12150800 |         10 |         11090 | Latest Available |
|  12150800 |         11 |         13850 | Latest Available |
|  12150800 |         12 |         13090 | Latest Available |
|  12150800 |          1 |         16980 | Latest Available |
|  12150800 |          2 |         11800 | Latest Available |
|  12150800 |          3 |          7637 | Latest Available |
|  12150800 |          4 |          9116 | Latest Available |
|  12150800 |          5 |         12860 | Latest Available |


Table: Streamflow Month Reorder
|   Month |   Order | Month Abbr   |
|--------:|--------:|:-------------|
|       9 |       1 | Sep          |
|      10 |       2 | Oct          |
|      11 |       3 | Nov          |
|      12 |       4 | Dec          |
|       1 |       5 | Jan          |
|       2 |       6 | Feb          |
|       3 |       7 | Mar          |
|       4 |       8 | Apr          |
|       5 |       9 | May          |
|       6 |      10 | Jun          |


Table: streamflow_master
|   site_no |   month_nu | Time Period   |   monthly_cfs | River Type    | River Name   | Station Name                                     |   Order | Month Abbr   |
|----------:|-----------:|:--------------|--------------:|:--------------|:-------------|:-------------------------------------------------|--------:|:-------------|
|  12186000 |          1 | 1970 - 1999   |      1047.95  | Snow dominant | Sauk River   | SAUK RIVER AB WHITE CHUCK RIVER NR DARRINGTON, W |       5 | Jan          |
|  12186000 |          2 | 1970 - 1999   |       990.233 | Snow dominant | Sauk River   | SAUK RIVER AB WHITE CHUCK RIVER NR DARRINGTON, W |       6 | Feb          |
|  12186000 |          3 | 1970 - 1999   |       877.26  | Snow dominant | Sauk River   | SAUK RIVER AB WHITE CHUCK RIVER NR DARRINGTON, W |       7 | Mar          |
|  12186000 |          4 | 1970 - 1999   |      1035.77  | Snow dominant | Sauk River   | SAUK RIVER AB WHITE CHUCK RIVER NR DARRINGTON, W |       8 | Apr          |
|  12186000 |          5 | 1970 - 1999   |      1776.77  | Snow dominant | Sauk River   | SAUK RIVER AB WHITE CHUCK RIVER NR DARRINGTON, W |       9 | May          |
|  12186000 |          6 | 1970 - 1999   |      2035.05  | Snow dominant | Sauk River   | SAUK RIVER AB WHITE CHUCK RIVER NR DARRINGTON, W |      10 | Jun          |
|  12186000 |          7 | 1970 - 1999   |      1406.02  | Snow dominant | Sauk River   | SAUK RIVER AB WHITE CHUCK RIVER NR DARRINGTON, W |      11 | Jul          |
|  12186000 |          8 | 1970 - 1999   |       629.32  | Snow dominant | Sauk River   | SAUK RIVER AB WHITE CHUCK RIVER NR DARRINGTON, W |      12 | Aug          |
|  12186000 |          9 | 1970 - 1999   |       467.143 | Snow dominant | Sauk River   | SAUK RIVER AB WHITE CHUCK RIVER NR DARRINGTON, W |       1 | Sep          |
|  12186000 |         10 | 1970 - 1999   |       665.117 | Snow dominant | Sauk River   | SAUK RIVER AB WHITE CHUCK RIVER NR DARRINGTON, W |       2 | Oct          |


Table: tidal_stations
|   NWLON Station ID | Tide Station Name   | Latitude    | Longitude    | URL                                                           |
|-------------------:|:--------------------|:------------|:-------------|:--------------------------------------------------------------|
|            9446484 | Tacoma, WA          | 47° 16.2' N | 122° 24.8' W | https://tidesandcurrents.noaa.gov/stationhome.html?id=9446484 |
|            9447130 | Seattle, WA         | 47° 36.1' N | 122° 20.3' W | https://tidesandcurrents.noaa.gov/stationhome.html?id=9447130 |
|            9444900 | Port Townsend, WA   | 48° 6.8' N  | 122° 45.6' W | https://tidesandcurrents.noaa.gov/stationhome.html?id=9444900 |
|            9444090 | Port Angeles, WA    | 48° 7.5' N  | 123° 26.5' W | https://tidesandcurrents.noaa.gov/stationhome.html?id=9444090 |
|            9449880 | Friday Harbor, WA   | 48° 32.7' N | 123° 0.8' W  | https://tidesandcurrents.noaa.gov/stationhome.html?id=9449880 |
|            9449424 | Cherry Point, WA    | 48° 51.8' N | 122° 45.5' W | https://tidesandcurrents.noaa.gov/stationhome.html?id=9449424 |


Table: tidied_data_CO2_ice_cores
|    Year |   CO2 ppm | Source                                        |
|--------:|----------:|:----------------------------------------------|
| -796562 |     191   | EPICA Dome C and  Vostok Station,  Antarctica |
| -795149 |     188.4 | EPICA Dome C and  Vostok Station,  Antarctica |
| -794517 |     189.3 | EPICA Dome C and  Vostok Station,  Antarctica |
| -793252 |     195.2 | EPICA Dome C and  Vostok Station,  Antarctica |
| -792658 |     199.4 | EPICA Dome C and  Vostok Station,  Antarctica |
| -791310 |     209   | EPICA Dome C and  Vostok Station,  Antarctica |
| -790993 |     204   | EPICA Dome C and  Vostok Station,  Antarctica |
| -790131 |     205.1 | EPICA Dome C and  Vostok Station,  Antarctica |
| -789541 |     215.4 | EPICA Dome C and  Vostok Station,  Antarctica |
| -788588 |     221.3 | EPICA Dome C and  Vostok Station,  Antarctica |


Table: tidied_data_CO2_ppm
| Date                    |   year |   month |   decimal date |   avg CO2 ppm |   interpolated CO2 ppm |   trend |   ndays |   unknown |
|:------------------------|-------:|--------:|---------------:|--------------:|-----------------------:|--------:|--------:|----------:|
| 1958-03-01 00:00:00.000 |   1958 |       3 |        1958.2  |        315.7  |                 314.43 |      -1 |   -9.99 |     -0.99 |
| 1958-04-01 00:00:00.000 |   1958 |       4 |        1958.29 |        317.45 |                 315.16 |      -1 |   -9.99 |     -0.99 |
| 1958-05-01 00:00:00.000 |   1958 |       5 |        1958.37 |        317.51 |                 314.71 |      -1 |   -9.99 |     -0.99 |
| 1958-06-01 00:00:00.000 |   1958 |       6 |        1958.45 |        317.24 |                 315.14 |      -1 |   -9.99 |     -0.99 |
| 1958-07-01 00:00:00.000 |   1958 |       7 |        1958.54 |        315.86 |                 315.18 |      -1 |   -9.99 |     -0.99 |
| 1958-08-01 00:00:00.000 |   1958 |       8 |        1958.62 |        314.93 |                 316.18 |      -1 |   -9.99 |     -0.99 |
| 1958-09-01 00:00:00.000 |   1958 |       9 |        1958.71 |        313.2  |                 316.08 |      -1 |   -9.99 |     -0.99 |
| 1958-10-01 00:00:00.000 |   1958 |      10 |        1958.79 |        312.43 |                 315.41 |      -1 |   -9.99 |     -0.99 |
| 1958-11-01 00:00:00.000 |   1958 |      11 |        1958.87 |        313.33 |                 315.2  |      -1 |   -9.99 |     -0.99 |
| 1958-12-01 00:00:00.000 |   1958 |      12 |        1958.96 |        314.67 |                 315.43 |      -1 |   -9.99 |     -0.99 |


Table: tidied_data_HadCRUT_global_temperature_anomalies
| Date                    | DateText   |   Median Global Temp C Deviation |   Bias Uncertainty (Lower 95 CI) |   Bias Uncertainty (Upper 95 CI) |   Measurement and Sampling Uncertainty (Lower 95 CI) |   Measurement and Sampling Uncertainty (Upper 95 CI) |   Coverage Uncertainty (Lower 95 CI) |   Coverage Uncertainty (Upper 95 CI) |   Measurement, Sampling, and Bias Uncertainty (Lower 95 CI) |   Measurement, Sampling, and Bias Uncertainty (Upper 95 CI) |   Combined Uncertainty (Lower 95 CI) |   Combined Uncertainty (Upper 95 CI) | Column1   |
|:------------------------|:-----------|---------------------------------:|---------------------------------:|---------------------------------:|-----------------------------------------------------:|-----------------------------------------------------:|-------------------------------------:|-------------------------------------:|------------------------------------------------------------:|------------------------------------------------------------:|-------------------------------------:|-------------------------------------:|:----------|
| 1850-01-01 00:00:00.000 | 1850/01    |                           -0.7   |                           -0.757 |                           -0.627 |                                               -0.889 |                                               -0.51  |                               -1.047 |                               -0.352 |                                                      -0.898 |                                                      -0.5   |                               -1.1   |                               -0.299 |           |
| 1850-02-01 00:00:00.000 | 1850/02    |                           -0.286 |                           -0.342 |                           -0.218 |                                               -0.474 |                                               -0.098 |                               -0.625 |                                0.052 |                                                      -0.482 |                                                      -0.082 |                               -0.676 |                                0.111 |           |
| 1850-03-01 00:00:00.000 | 1850/03    |                           -0.732 |                           -0.799 |                           -0.68  |                                               -0.934 |                                               -0.529 |                               -1.009 |                               -0.454 |                                                      -0.942 |                                                      -0.519 |                               -1.08  |                               -0.382 |           |
| 1850-04-01 00:00:00.000 | 1850/04    |                           -0.563 |                           -0.62  |                           -0.493 |                                               -0.767 |                                               -0.36  |                               -0.816 |                               -0.31  |                                                      -0.777 |                                                      -0.349 |                               -0.894 |                               -0.231 |           |
| 1850-05-01 00:00:00.000 | 1850/05    |                           -0.327 |                           -0.386 |                           -0.279 |                                               -0.521 |                                               -0.132 |                               -0.589 |                               -0.064 |                                                      -0.533 |                                                      -0.128 |                               -0.661 |                                0.001 |           |
| 1850-06-01 00:00:00.000 | 1850/06    |                           -0.213 |                           -0.273 |                           -0.159 |                                               -0.403 |                                               -0.023 |                               -0.435 |                                0.008 |                                                      -0.414 |                                                      -0.017 |                               -0.513 |                                0.081 |           |
| 1850-07-01 00:00:00.000 | 1850/07    |                           -0.125 |                           -0.187 |                           -0.072 |                                               -0.313 |                                                0.062 |                               -0.388 |                                0.137 |                                                      -0.322 |                                                       0.069 |                               -0.454 |                                0.201 |           |
| 1850-08-01 00:00:00.000 | 1850/08    |                           -0.237 |                           -0.286 |                           -0.187 |                                               -0.423 |                                               -0.05  |                               -0.543 |                                0.07  |                                                      -0.429 |                                                      -0.042 |                               -0.598 |                                0.127 |           |
| 1850-09-01 00:00:00.000 | 1850/09    |                           -0.439 |                           -0.491 |                           -0.386 |                                               -0.646 |                                               -0.232 |                               -0.743 |                               -0.135 |                                                      -0.653 |                                                      -0.223 |                               -0.81  |                               -0.065 |           |
| 1850-10-01 00:00:00.000 | 1850/10    |                           -0.451 |                           -0.504 |                           -0.39  |                                               -0.659 |                                               -0.243 |                               -0.719 |                               -0.184 |                                                      -0.664 |                                                      -0.231 |                               -0.792 |                               -0.103 |           |


Table: tidied_data_nclimdiv-cddcdv (2)
|   STATE-CODE |   DIVISION-NUMBER |   YEAR |   Annual Cooling Degree Days |
|-------------:|------------------:|-------:|-----------------------------:|
|           45 |                 3 |   1895 |                           49 |
|           45 |                 3 |   1896 |                           83 |
|           45 |                 3 |   1897 |                           84 |
|           45 |                 3 |   1898 |                           97 |
|           45 |                 3 |   1899 |                           53 |
|           45 |                 3 |   1900 |                           56 |
|           45 |                 3 |   1901 |                           52 |
|           45 |                 3 |   1902 |                           44 |
|           45 |                 3 |   1903 |                           38 |
|           45 |                 3 |   1904 |                           66 |


Table: tidied_data_nclimdiv-cddcdv
|   STATE-CODE |   DIVISION-NUMBER |   YEAR |   Annual Cooling Degree Days |
|-------------:|------------------:|-------:|-----------------------------:|
|           45 |                 3 |   1895 |                           49 |
|           45 |                 3 |   1896 |                           83 |
|           45 |                 3 |   1897 |                           84 |
|           45 |                 3 |   1898 |                           97 |
|           45 |                 3 |   1899 |                           53 |
|           45 |                 3 |   1900 |                           56 |
|           45 |                 3 |   1901 |                           52 |
|           45 |                 3 |   1902 |                           44 |
|           45 |                 3 |   1903 |                           38 |
|           45 |                 3 |   1904 |                           66 |


Table: tidied_data_world_bank_SP POP TOTL
| Country   | Indicator         | Indicator ID   | Date                    |   World Population |   Year | Column1   |
|:----------|:------------------|:---------------|:------------------------|-------------------:|-------:|:----------|
| World     | Population, total | SP.POP.TOTL    | 1960-01-01 00:00:00.000 |         3032156070 |   1960 |           |
| World     | Population, total | SP.POP.TOTL    | 1961-01-01 00:00:00.000 |         3071596055 |   1961 |           |
| World     | Population, total | SP.POP.TOTL    | 1962-01-01 00:00:00.000 |         3124561005 |   1962 |           |
| World     | Population, total | SP.POP.TOTL    | 1963-01-01 00:00:00.000 |         3189655687 |   1963 |           |
| World     | Population, total | SP.POP.TOTL    | 1964-01-01 00:00:00.000 |         3255145692 |   1964 |           |
| World     | Population, total | SP.POP.TOTL    | 1965-01-01 00:00:00.000 |         3322046795 |   1965 |           |
| World     | Population, total | SP.POP.TOTL    | 1966-01-01 00:00:00.000 |         3392097729 |   1966 |           |
| World     | Population, total | SP.POP.TOTL    | 1967-01-01 00:00:00.000 |         3461619724 |   1967 |           |
| World     | Population, total | SP.POP.TOTL    | 1968-01-01 00:00:00.000 |         3532782993 |   1968 |           |
| World     | Population, total | SP.POP.TOTL    | 1969-01-01 00:00:00.000 |         3606553753 |   1969 |           |


Table: tidy_data_master_snotel_swe_hx
| Date                    |   Snow Water Equivalent (in) Start of Day Values |   snotel_station_id |   Year |   Month |   Day | station_name   |   Base SWE In |   Snowpack SWE % Change |
|:------------------------|-------------------------------------------------:|--------------------:|-------:|--------:|------:|:---------------|--------------:|------------------------:|
| 1982-04-01 00:00:00.000 |                                             41.3 |                 418 |   1982 |       4 |     1 | Corral Pass    |       33.2824 |              0.240898   |
| 1983-04-01 00:00:00.000 |                                             29   |                 418 |   1983 |       4 |     1 | Corral Pass    |       33.2824 |             -0.128667   |
| 1984-04-01 00:00:00.000 |                                              8.2 |                 418 |   1984 |       4 |     1 | Corral Pass    |       33.2824 |             -0.753623   |
| 1985-04-01 00:00:00.000 |                                             23.9 |                 418 |   1985 |       4 |     1 | Corral Pass    |       33.2824 |             -0.281902   |
| 1986-04-01 00:00:00.000 |                                             33.1 |                 418 |   1986 |       4 |     1 | Corral Pass    |       33.2824 |             -0.00547897 |
| 1987-04-01 00:00:00.000 |                                             33.4 |                 418 |   1987 |       4 |     1 | Corral Pass    |       33.2824 |              0.00353482 |
| 1988-04-01 00:00:00.000 |                                             37.1 |                 418 |   1988 |       4 |     1 | Corral Pass    |       33.2824 |              0.114705   |
| 1989-04-01 00:00:00.000 |                                             39.3 |                 418 |   1989 |       4 |     1 | Corral Pass    |       33.2824 |              0.180806   |
| 1990-04-01 00:00:00.000 |                                             39.7 |                 418 |   1990 |       4 |     1 | Corral Pass    |       33.2824 |              0.192824   |
| 1991-04-01 00:00:00.000 |                                             33.6 |                 418 |   1991 |       4 |     1 | Corral Pass    |       33.2824 |              0.00954401 |


Table: tidy_data_master_usgs_streamflow
|   site_no |   year_nu |   month_nu |   monthly_cfs | Streamflow Month Date   |
|----------:|----------:|-----------:|--------------:|:------------------------|
|  12186000 |      1917 |         10 |         420.5 | 1917-10-01 00:00:00.000 |
|  12186000 |      1918 |         10 |        1128   | 1918-10-01 00:00:00.000 |
|  12186000 |      1919 |         10 |         260.3 | 1919-10-01 00:00:00.000 |
|  12186000 |      1920 |         10 |        1889   | 1920-10-01 00:00:00.000 |
|  12186000 |      1921 |         10 |        1429   | 1921-10-01 00:00:00.000 |
|  12186000 |      1928 |         10 |        1075   | 1928-10-01 00:00:00.000 |
|  12186000 |      1929 |         10 |         239.5 | 1929-10-01 00:00:00.000 |
|  12186000 |      1930 |         10 |         563.5 | 1930-10-01 00:00:00.000 |
|  12186000 |      1931 |         10 |         585.5 | 1931-10-01 00:00:00.000 |
|  12186000 |      1932 |         10 |         704.8 | 1932-10-01 00:00:00.000 |


Table: WA03_Annual_Temp
|   STATE-CODE |   DIVISION-NUMBER |   YEAR |   Avg Annual Temp F |   Base Temp F |   Annual Temp F Deviation | RPT_MO_STRT_DT          |   month count |
|-------------:|------------------:|-------:|--------------------:|--------------:|--------------------------:|:------------------------|--------------:|
|           45 |                 3 |   1895 |             49.5917 |       50.5011 |                -0.909444  | 1895-01-01 00:00:00.000 |            12 |
|           45 |                 3 |   1896 |             49.1    |       50.5011 |                -1.40111   | 1896-01-01 00:00:00.000 |            12 |
|           45 |                 3 |   1897 |             49.5583 |       50.5011 |                -0.942778  | 1897-01-01 00:00:00.000 |            12 |
|           45 |                 3 |   1898 |             50.2167 |       50.5011 |                -0.284444  | 1898-01-01 00:00:00.000 |            12 |
|           45 |                 3 |   1899 |             49.4833 |       50.5011 |                -1.01778   | 1899-01-01 00:00:00.000 |            12 |
|           45 |                 3 |   1900 |             51.05   |       50.5011 |                 0.548889  | 1900-01-01 00:00:00.000 |            12 |
|           45 |                 3 |   1901 |             50.1417 |       50.5011 |                -0.359444  | 1901-01-01 00:00:00.000 |            12 |
|           45 |                 3 |   1902 |             50.1667 |       50.5011 |                -0.334444  | 1902-01-01 00:00:00.000 |            12 |
|           45 |                 3 |   1903 |             49.25   |       50.5011 |                -1.25111   | 1903-01-01 00:00:00.000 |            12 |
|           45 |                 3 |   1904 |             50.4667 |       50.5011 |                -0.0344444 | 1904-01-01 00:00:00.000 |            12 |


Table: WA03_Degree_Days 1970-1999_Avg
|   STATE-CODE |   DIVISION-NUMBER |   Base Annual Heating Degree Days |   Base Annual Cooling Degree Days |   2050 Mod Emissions Lower Bound HDD |   2050 Mod Emissions Avg HDD |   2050 Mod Emissions Higher Bound HDD |   2050 Mod Emissions Lower Bound CDD |   2050 Mod Emissions Avg CDD |   2050 Mod Emissions Higher Bound CDD |
|-------------:|------------------:|----------------------------------:|----------------------------------:|-------------------------------------:|-----------------------------:|--------------------------------------:|-------------------------------------:|-----------------------------:|--------------------------------------:|
|           45 |                 3 |                            5366.9 |                           91.1667 |                               3066.9 |                       3766.9 |                                4366.9 |                              96.1667 |                      108.167 |                               147.167 |


Table: WA03_Degree_Days
|   STATE-CODE |   DIVISION-NUMBER |   YEAR |   Annual Heating Degree Days |   Annual Cooling Degree Days |   Base Annual Heating Degree Days |   Base Annual Cooling Degree Days |   2050 Mod Emissions Lower Bound HDD |   2050 Mod Emissions Avg HDD |   2050 Mod Emissions Higher Bound HDD |   2050 Mod Emissions Lower Bound CDD |   2050 Mod Emissions Avg CDD |   2050 Mod Emissions Higher Bound CDD | DD Year Date            |   Heating Degree Days Deviation |   Cooling Degree Days Deviation |
|-------------:|------------------:|-------:|-----------------------------:|-----------------------------:|----------------------------------:|----------------------------------:|-------------------------------------:|-----------------------------:|--------------------------------------:|-------------------------------------:|-----------------------------:|--------------------------------------:|:------------------------|--------------------------------:|--------------------------------:|
|           45 |                 3 |   1895 |                         5657 |                           49 |                            5366.9 |                           91.1667 |                               3066.9 |                       3766.9 |                                4366.9 |                              96.1667 |                      108.167 |                               147.167 | 1895-01-01 00:00:00.000 |                           290.1 |                       -42.1667  |
|           45 |                 3 |   1896 |                         5871 |                           83 |                            5366.9 |                           91.1667 |                               3066.9 |                       3766.9 |                                4366.9 |                              96.1667 |                      108.167 |                               147.167 | 1896-01-01 00:00:00.000 |                           504.1 |                        -8.16667 |
|           45 |                 3 |   1897 |                         5703 |                           84 |                            5366.9 |                           91.1667 |                               3066.9 |                       3766.9 |                                4366.9 |                              96.1667 |                      108.167 |                               147.167 | 1897-01-01 00:00:00.000 |                           336.1 |                        -7.16667 |
|           45 |                 3 |   1898 |                         5482 |                           97 |                            5366.9 |                           91.1667 |                               3066.9 |                       3766.9 |                                4366.9 |                              96.1667 |                      108.167 |                               147.167 | 1898-01-01 00:00:00.000 |                           115.1 |                         5.83333 |
|           45 |                 3 |   1899 |                         5694 |                           53 |                            5366.9 |                           91.1667 |                               3066.9 |                       3766.9 |                                4366.9 |                              96.1667 |                      108.167 |                               147.167 | 1899-01-01 00:00:00.000 |                           327.1 |                       -38.1667  |
|           45 |                 3 |   1900 |                         5124 |                           56 |                            5366.9 |                           91.1667 |                               3066.9 |                       3766.9 |                                4366.9 |                              96.1667 |                      108.167 |                               147.167 | 1900-01-01 00:00:00.000 |                          -242.9 |                       -35.1667  |
|           45 |                 3 |   1901 |                         5453 |                           52 |                            5366.9 |                           91.1667 |                               3066.9 |                       3766.9 |                                4366.9 |                              96.1667 |                      108.167 |                               147.167 | 1901-01-01 00:00:00.000 |                            86.1 |                       -39.1667  |
|           45 |                 3 |   1902 |                         5449 |                           44 |                            5366.9 |                           91.1667 |                               3066.9 |                       3766.9 |                                4366.9 |                              96.1667 |                      108.167 |                               147.167 | 1902-01-01 00:00:00.000 |                            82.1 |                       -47.1667  |
|           45 |                 3 |   1903 |                         5760 |                           38 |                            5366.9 |                           91.1667 |                               3066.9 |                       3766.9 |                                4366.9 |                              96.1667 |                      108.167 |                               147.167 | 1903-01-01 00:00:00.000 |                           393.1 |                       -53.1667  |
|           45 |                 3 |   1904 |                         5351 |                           66 |                            5366.9 |                           91.1667 |                               3066.9 |                       3766.9 |                                4366.9 |                              96.1667 |                      108.167 |                               147.167 | 1904-01-01 00:00:00.000 |                           -15.9 |                       -25.1667  |


Table: WA03_Fall_Precip (2)
|   YEAR |   Fall Precipitation Inches |
|-------:|----------------------------:|
|   1895 |                        5.94 |
|   1896 |                       15.58 |
|   1897 |                       14.56 |
|   1898 |                       12.53 |
|   1899 |                       15.12 |
|   1900 |                       11.07 |
|   1901 |                       13.09 |
|   1902 |                       13.52 |
|   1903 |                       16.49 |
|   1904 |                       11.95 |


Table: WA03_Fall_Precip
|   YEAR |   Fall Precipitation Inches |
|-------:|----------------------------:|
|   1895 |                        5.94 |
|   1896 |                       15.58 |
|   1897 |                       14.56 |
|   1898 |                       12.53 |
|   1899 |                       15.12 |
|   1900 |                       11.07 |
|   1901 |                       13.09 |
|   1902 |                       13.52 |
|   1903 |                       16.49 |
|   1904 |                       11.95 |


Table: WA03_Precip
|   YEAR |   Spring Precipitation Inches |   Summer Precipitation Inches |   Fall Precipitation Inches |   Winter Precipitation Inches |   STATE-CODE |   DIVISION-NUMBER |   Base Spring Precip In |   Base Summer Precip In |   Base Fall Precip In |   Base Winter Precip In | Delete me date          |   Spring Precip % Deviation |   Summer Precip % Deviation |   Fall Precip % Deviation |   Winter Precip % Deviation |   Annual Precipitation Inches | Precip YearDate         |
|-------:|------------------------------:|------------------------------:|----------------------------:|------------------------------:|-------------:|------------------:|------------------------:|------------------------:|----------------------:|------------------------:|:------------------------|----------------------------:|----------------------------:|--------------------------:|----------------------------:|------------------------------:|:------------------------|
|   1895 |                         10.58 |                          1.59 |                        5.94 |                         18.83 |           45 |                 3 |                 10.3413 |                 4.62067 |                 12.81 |                 17.5107 | 1895-01-01 00:00:00.000 |                   0.0230789 |                  -0.655894  |                -0.5363    |                   0.0753446 |                         36.94 | 1895-01-01 00:00:00.000 |
|   1896 |                         11.09 |                          2.45 |                       15.58 |                         21.65 |           45 |                 3 |                 10.3413 |                 4.62067 |                 12.81 |                 17.5107 | 1896-01-01 00:00:00.000 |                   0.0723956 |                  -0.469773  |                 0.216237  |                   0.236389  |                         50.77 | 1896-01-01 00:00:00.000 |
|   1897 |                          8.82 |                          5.13 |                       14.56 |                         19.61 |           45 |                 3 |                 10.3413 |                 4.62067 |                 12.81 |                 17.5107 | 1897-01-01 00:00:00.000 |                  -0.147112  |                   0.110229  |                 0.136612  |                   0.119889  |                         48.12 | 1897-01-01 00:00:00.000 |
|   1898 |                          6.66 |                          4.41 |                       12.53 |                         15.06 |           45 |                 3 |                 10.3413 |                 4.62067 |                 12.81 |                 17.5107 | 1898-01-01 00:00:00.000 |                  -0.355982  |                  -0.0455923 |                -0.0218579 |                  -0.139953  |                         38.66 | 1898-01-01 00:00:00.000 |
|   1899 |                         11.2  |                          5.83 |                       15.12 |                         20.9  |           45 |                 3 |                 10.3413 |                 4.62067 |                 12.81 |                 17.5107 | 1899-01-01 00:00:00.000 |                   0.0830325 |                   0.261723  |                 0.180328  |                   0.193558  |                         53.05 | 1899-01-01 00:00:00.000 |
|   1900 |                         11.97 |                          6.23 |                       11.07 |                         17.7  |           45 |                 3 |                 10.3413 |                 4.62067 |                 12.81 |                 17.5107 | 1900-01-01 00:00:00.000 |                   0.157491  |                   0.34829   |                -0.135831  |                   0.0108125 |                         46.97 | 1900-01-01 00:00:00.000 |
|   1901 |                          9.81 |                          2.93 |                       13.09 |                         14.54 |           45 |                 3 |                 10.3413 |                 4.62067 |                 12.81 |                 17.5107 | 1901-01-01 00:00:00.000 |                  -0.0513796 |                  -0.365892  |                 0.0218579 |                  -0.169649  |                         40.37 | 1901-01-01 00:00:00.000 |
|   1902 |                         11.49 |                          4.19 |                       13.52 |                         20.67 |           45 |                 3 |                 10.3413 |                 4.62067 |                 12.81 |                 17.5107 | 1902-01-01 00:00:00.000 |                   0.111075  |                  -0.0932044 |                 0.0554254 |                   0.180423  |                         49.87 | 1902-01-01 00:00:00.000 |
|   1903 |                         11.11 |                          4.75 |                       16.49 |                         13.17 |           45 |                 3 |                 10.3413 |                 4.62067 |                 12.81 |                 17.5107 | 1903-01-01 00:00:00.000 |                   0.0743296 |                   0.0279902 |                 0.287276  |                  -0.247887  |                         45.52 | 1903-01-01 00:00:00.000 |
|   1904 |                         11.16 |                          3.52 |                       11.95 |                         19.79 |           45 |                 3 |                 10.3413 |                 4.62067 |                 12.81 |                 17.5107 | 1904-01-01 00:00:00.000 |                   0.0791645 |                  -0.238205  |                -0.0671351 |                   0.130168  |                         46.42 | 1904-01-01 00:00:00.000 |


Table: WA03_Precip_1970-1999_Avg
|   STATE-CODE |   DIVISION-NUMBER |   Base Spring Precip In |   Base Summer Precip In |   Base Fall Precip In |   Base Winter Precip In |
|-------------:|------------------:|------------------------:|------------------------:|----------------------:|------------------------:|
|           45 |                 3 |                 10.3413 |                 4.62067 |                 12.81 |                 17.5107 |


Table: WA03_Summer_Precip (2)
|   YEAR |   Summer Precipitation Inches |
|-------:|------------------------------:|
|   1895 |                          1.59 |
|   1896 |                          2.45 |
|   1897 |                          5.13 |
|   1898 |                          4.41 |
|   1899 |                          5.83 |
|   1900 |                          6.23 |
|   1901 |                          2.93 |
|   1902 |                          4.19 |
|   1903 |                          4.75 |
|   1904 |                          3.52 |


Table: WA03_Summer_Precip
|   YEAR |   Summer Precipitation Inches |
|-------:|------------------------------:|
|   1895 |                          1.59 |
|   1896 |                          2.45 |
|   1897 |                          5.13 |
|   1898 |                          4.41 |
|   1899 |                          5.83 |
|   1900 |                          6.23 |
|   1901 |                          2.93 |
|   1902 |                          4.19 |
|   1903 |                          4.75 |
|   1904 |                          3.52 |


Table: WA03_Temp_1970-1999_Avg
|   STATE-CODE |   Base Temp F |   DIVISION-NUMBER |
|-------------:|--------------:|------------------:|
|           45 |       50.5011 |                 3 |


Table: WA03_Winter_Precip (2)
|   YEAR |   Winter Precipitation Inches |
|-------:|------------------------------:|
|   1895 |                         18.83 |
|   1896 |                         21.65 |
|   1897 |                         19.61 |
|   1898 |                         15.06 |
|   1899 |                         20.9  |
|   1900 |                         17.7  |
|   1901 |                         14.54 |
|   1902 |                         20.67 |
|   1903 |                         13.17 |
|   1904 |                         19.79 |


Table: WA03_Winter_Precip
|   YEAR |   Winter Precipitation Inches |
|-------:|------------------------------:|
|   1895 |                         18.83 |
|   1896 |                         21.65 |
|   1897 |                         19.61 |
|   1898 |                         15.06 |
|   1899 |                         20.9  |
|   1900 |                         17.7  |
|   1901 |                         14.54 |
|   1902 |                         20.67 |
|   1903 |                         13.17 |
|   1904 |                         19.79 |


Table: WA_SNOTEL_STATION_LIST (2)
|   snotel_station_id | snow_survey_prog_acton_id   | station_name      | state_sub-basin_name   |   latitude |   longitude |   elevation_ft |
|--------------------:|:----------------------------|:------------------|:-----------------------|-----------:|------------:|---------------:|
|                 418 | 21B13S                      | Corral Pass       | SOUTH PUGET SOUND      |    47.0167 |    -121.467 |           5800 |
|                1085 | 21C41S                      | Cayuse Pass       | SOUTH PUGET SOUND      |    46.8667 |    -121.533 |           5240 |
|                 679 | 21C35S                      | Paradise          | SOUTH PUGET SOUND      |    46.7833 |    -121.75  |           5130 |
|                1068 | 21B31S                      | Sawmill Ridge     | SOUTH PUGET SOUND      |    47.1667 |    -121.417 |           4640 |
|                 942 | 21B63S                      | Burnt Mountain    | SOUTH PUGET SOUND      |    47.05   |    -121.933 |           4170 |
|                1069 | 21B50S                      | Lynn Lake         | SOUTH PUGET SOUND      |    47.2    |    -121.783 |           3900 |
|                 788 | 21B10S                      | Stampede Pass     | SOUTH PUGET SOUND      |    47.2667 |    -121.333 |           3850 |
|                 420 | 21B42S                      | Cougar Mountain   | SOUTH PUGET SOUND      |    47.2833 |    -121.667 |           3200 |
|                 941 | 21C40S                      | Mowich            | SOUTH PUGET SOUND      |    46.9333 |    -121.95  |           3160 |
|                 928 | 21B62S                      | Huckleberry Creek | SOUTH PUGET SOUND      |    47.0667 |    -121.583 |           2250 |


Table: WA_SNOTEL_STATION_LIST
|   snotel_station_id | snow_survey_prog_acton_id   | station_name      | state_sub-basin_name   |   latitude |   longitude |   elevation_ft |
|--------------------:|:----------------------------|:------------------|:-----------------------|-----------:|------------:|---------------:|
|                 418 | 21B13S                      | Corral Pass       | SOUTH PUGET SOUND      |    47.0167 |    -121.467 |           5800 |
|                1085 | 21C41S                      | Cayuse Pass       | SOUTH PUGET SOUND      |    46.8667 |    -121.533 |           5240 |
|                 679 | 21C35S                      | Paradise          | SOUTH PUGET SOUND      |    46.7833 |    -121.75  |           5130 |
|                1068 | 21B31S                      | Sawmill Ridge     | SOUTH PUGET SOUND      |    47.1667 |    -121.417 |           4640 |
|                 942 | 21B63S                      | Burnt Mountain    | SOUTH PUGET SOUND      |    47.05   |    -121.933 |           4170 |
|                1069 | 21B50S                      | Lynn Lake         | SOUTH PUGET SOUND      |    47.2    |    -121.783 |           3900 |
|                 788 | 21B10S                      | Stampede Pass     | SOUTH PUGET SOUND      |    47.2667 |    -121.333 |           3850 |
|                 420 | 21B42S                      | Cougar Mountain   | SOUTH PUGET SOUND      |    47.2833 |    -121.667 |           3200 |
|                 941 | 21C40S                      | Mowich            | SOUTH PUGET SOUND      |    46.9333 |    -121.95  |           3160 |
|                 928 | 21B62S                      | Huckleberry Creek | SOUTH PUGET SOUND      |    47.0667 |    -121.583 |           2250 |

 


tables: name: 2000 Avg MSL cf STND
data: 2000 Avg MSL cf STND.csv
name: Annual Avg MSL cf STND
data: Annual Avg MSL cf STND.csv
name: Combined CO2 data
data: Combined CO2 data.csv
name: Grain Per Capita
data: Grain Per Capita.csv
name: psd_grains_pulses
data: psd_grains_pulses.csv
name: SNOTEL SWE 1983-1999 Avg
data: SNOTEL SWE 1983-1999 Avg.csv
name: steamflow_stations
data: steamflow_stations.csv
name: Streamflow Get Latest Date Per Month Station
data: Streamflow Get Latest Date Per Month Station.csv
name: Streamflow Last 30 Years
data: Streamflow Last 30 Years.csv
name: Streamflow Last 5 Years
data: Streamflow Last 5 Years.csv
name: Streamflow Latest Available Date
data: Streamflow Latest Available Date.csv
name: Streamflow Month Reorder
data: Streamflow Month Reorder.csv
name: streamflow_master
data: streamflow_master.csv
name: tidal_stations
data: tidal_stations.csv
name: tidied_data_CO2_ice_cores
data: tidied_data_CO2_ice_cores.csv
name: tidied_data_CO2_ppm
data: tidied_data_CO2_ppm.csv
name: tidied_data_HadCRUT_global_temperature_anomalies
data: tidied_data_HadCRUT_global_temperature_anomalies.csv
name: tidied_data_nclimdiv-cddcdv (2)
data: tidied_data_nclimdiv-cddcdv (2).csv
name: tidied_data_nclimdiv-cddcdv
data: tidied_data_nclimdiv-cddcdv.csv
name: tidied_data_world_bank_SP POP TOTL
data: tidied_data_world_bank_SP POP TOTL.csv
name: tidy_data_master_snotel_swe_hx
data: tidy_data_master_snotel_swe_hx.csv
name: tidy_data_master_usgs_streamflow
data: tidy_data_master_usgs_streamflow.csv
name: WA03_Annual_Temp
data: WA03_Annual_Temp.csv
name: WA03_Degree_Days 1970-1999_Avg
data: WA03_Degree_Days 1970-1999_Avg.csv
name: WA03_Degree_Days
data: WA03_Degree_Days.csv
name: WA03_Fall_Precip (2)
data: WA03_Fall_Precip (2).csv
name: WA03_Fall_Precip
data: WA03_Fall_Precip.csv
name: WA03_Precip
data: WA03_Precip.csv
name: WA03_Precip_1970-1999_Avg
data: WA03_Precip_1970-1999_Avg.csv
name: WA03_Summer_Precip (2)
data: WA03_Summer_Precip (2).csv
name: WA03_Summer_Precip
data: WA03_Summer_Precip.csv
name: WA03_Temp_1970-1999_Avg
data: WA03_Temp_1970-1999_Avg.csv
name: WA03_Winter_Precip (2)
data: WA03_Winter_Precip (2).csv
name: WA03_Winter_Precip
data: WA03_Winter_Precip.csv
name: WA_SNOTEL_STATION_LIST (2)
data: WA_SNOTEL_STATION_LIST (2).csv
name: WA_SNOTEL_STATION_LIST
data: WA_SNOTEL_STATION_LIST.csv
label: WA03_Annual_Temp
STATE-CODE
WA03_Temp_1970-1999_Avg
STATE-CODE
WA03_Summer_Precip
YEAR
WA03_Annual_Temp
YEAR
WA03_Annual_Temp
YEAR
WA03_Fall_Precip
YEAR
WA03_Annual_Temp
YEAR
WA03_Winter_Precip
YEAR
WA03_Annual_Temp
YEAR
WA03_Precip
YEAR
WA03_Summer_Precip (2)
YEAR
WA03_Winter_Precip
YEAR
WA03_Fall_Precip (2)
YEAR
WA03_Winter_Precip
YEAR
WA03_Winter_Precip (2)
YEAR
WA03_Precip
YEAR
WA03_Precip_1970-1999_Avg
STATE-CODE
WA03_Temp_1970-1999_Avg
STATE-CODE
tidied_data_nclimdiv-cddcdv
YEAR
WA03_Winter_Precip
YEAR
WA03_Degree_Days
YEAR
WA03_Winter_Precip
YEAR
tidied_data_nclimdiv-cddcdv (2)
YEAR
WA03_Winter_Precip
YEAR
WA03_Degree_Days 1970-1999_Avg
STATE-CODE
WA03_Temp_1970-1999_Avg
STATE-CODE
tidy_data_master_snotel_swe_hx
Year
tidied_data_world_bank_SP POP TOTL
Year
streamflow_master
Station Name
steamflow_stations
Station Name
streamflow_master
Order
Streamflow Month Reorder
Order
Annual Avg MSL cf STND
Year
WA03_Winter_Precip
YEAR
2000 Avg MSL cf STND
Year
WA03_Winter_Precip
YEAR
Annual Avg MSL cf STND
nwlon_station_id
tidal_stations
NWLON Station ID
2000 Avg MSL cf STND
nwlon_station_id
tidal_stations
NWLON Station ID
output: {
    "joins": [
        {
            "from_table": "WA03_Annual_Temp",
            "from_column": "STATE-CODE",
            "to_table": "WA03_Temp_1970-1999_Avg",
            "to_column": "STATE-CODE"
        },
        {
            "from_table": "WA03_Summer_Precip",
            "from_column": "YEAR",
            "to_table": "WA03_Annual_Temp",
            "to_column": "YEAR"
        },
        {
            "from_table": "WA03_Annual_Temp",
            "from_column": "YEAR",
            "to_table": "WA03_Fall_Precip",
            "to_column": "YEAR"
        },
        {
            "from_table": "WA03_Annual_Temp",
            "from_column": "YEAR",
            "to_table": "WA03_Winter_Precip",
            "to_column": "YEAR"
        },
        {
            "from_table": "WA03_Annual_Temp",
            "from_column": "YEAR",
            "to_table": "WA03_Precip",
            "to_column": "YEAR"
        },
        {
            "from_table": "WA03_Summer_Precip (2)",
            "from_column": "YEAR",
            "to_table": "WA03_Winter_Precip",
            "to_column": "YEAR"
        },
        {
            "from_table": "WA03_Fall_Precip (2)",
            "from_column": "YEAR",
            "to_table": "WA03_Winter_Precip",
            "to_column": "YEAR"
        },
        {
            "from_table": "WA03_Winter_Precip (2)",
            "from_column": "YEAR",
            "to_table": "WA03_Precip",
            "to_column": "YEAR"
        },
        {
            "from_table": "WA03_Precip_1970-1999_Avg",
            "from_column": "STATE-CODE",
            "to_table": "WA03_Temp_1970-1999_Avg",
            "to_column": "STATE-CODE"
        },
        {
            "from_table": "tidied_data_nclimdiv-cddcdv",
            "from_column": "YEAR",
            "to_table": "WA03_Winter_Precip",
            "to_column": "YEAR"
        },
        {
            "from_table": "WA03_Degree_Days",
            "from_column": "YEAR",
            "to_table": "WA03_Winter_Precip",
            "to_column": "YEAR"
        },
        {
            "from_table": "tidied_data_nclimdiv-cddcdv (2)",
            "from_column": "YEAR",
            "to_table": "WA03_Winter_Precip",
            "to_column": "YEAR"
        },
        {
            "from_table": "WA03_Degree_Days 1970-1999_Avg",
            "from_column": "STATE-CODE",
            "to_table": "WA03_Temp_1970-1999_Avg",
            "to_column": "STATE-CODE"
        },
        {
            "from_table": "tidy_data_master_snotel_swe_hx",
            "from_column": "Year",
            "to_table": "tidied_data_world_bank_SP POP TOTL",
            "to_column": "Year"
        },
        {
            "from_table": "streamflow_master",
            "from_column": "Station Name",
            "to_table": "steamflow_stations",
            "to_column": "Station Name"
        },
        {
            "from_table": "streamflow_master",
            "from_column": "Order",
            "to_table": "Streamflow Month Reorder",
            "to_column": "Order"
        },
        {
            "from_table": "Annual Avg MSL cf STND",
            "from_column": "Year",
            "to_table": "WA03_Winter_Precip",
            "to_column": "YEAR"
        },
        {
            "from_table": "2000 Avg MSL cf STND",
            "from_column": "Year",
            "to_table": "WA03_Winter_Precip",
            "to_column": "YEAR"
        },
        {
            "from_table": "Annual Avg MSL cf STND",
            "from_column": "nwlon_station_id",
            "to_table": "tidal_stations",
            "to_column": "NWLON Station ID"
        },
        {
            "from_table": "2000 Avg MSL cf STND",
            "from_column": "nwlon_station_id",
            "to_table": "tidal_stations",
            "to_column": "NWLON Station ID"
        }
    ]
}