Sobyeans Project Meta Data

Data Repositories

This report analyzed public data available from NOAA, USDA, AND FAO. The data and files used in this analysis are available at the following sites:

• GitHub: rdslack/soybeans
  • R markdown notebook
  • R Script
  • RData file
• BigQuery NOAA/GSOD
  • Weather data
• USDA National Agricultural Statistics Service (NASS)
  • National soybean production and price data
• USDA International Production Assessment Division (IPAD)
  • Global soybean production data
• FAO FAOSTAT
  • Global crops production data

Soybean Data

Top 10 Global Crops

• Source: Food and Agriculture Organization (FAO)
  

• Metadata:

  • Field Name	Type
    crop	STRING
    tons	INTEGER
    billion_tons	FLOAT

Top 5 Soybean Producing Countries

• Source: USDA International Production Assessment Division (IPAD)

• Metadata:

  • Field Name	Type
    top5_countries	STRING
    top5_countries_pct	INTEGER

Soybean Production - All States

• Source: Soybean Total and Yield per Acre by State: NASS: Years 2000-2022
• Table: prod_yield_all_states_2000_2022
• Metadata:

  • Field Name	Type	Mode
    Program	STRING	NULLABLE
    Year	INTEGER	NULLABLE
    Period	STRING	NULLABLE
    Week_Ending	STRING	NULLABLE
    Geo_Level	STRING	NULLABLE
    State	STRING	NULLABLE
    State_ANSI	INTEGER	NULLABLE
    Ag_District	STRING	NULLABLE
    Ag_District_Code	STRING	NULLABLE
    County	STRING	NULLABLE
    County_ANSI	STRING	NULLABLE
    Zip_Code	STRING	NULLABLE
    Region	STRING	NULLABLE
    watershed_code	INTEGER	NULLABLE
    Watershed	STRING	NULLABLE
    Commodity	STRING	NULLABLE
    Data_Item	STRING	NULLABLE
    Domain	STRING	NULLABLE
    Domain_Category	STRING	NULLABLE
    Value	FLOAT	NULLABLE
    CV____	STRING	NULLABLE

    
    

FIPS State Codes

• Table: bigquery-public-data.census_utility.fips_codes_states
  
• Metadata:

  • Field Name	Type	Mode
    state_fips_code	STRING	NULLABLE
    state_postal_abbreviation	STRING	NULLABLE
    state_name	STRING	NULLABLE
    state_gnisid	STRING	NULLABLE

    
    

Top 11 Soybean Producing States

• Table: top_11_soy_states
  • Separate table for Top 11 States to facilitate joins with weather tables
• Metadata:

  • Field Name	Type	Mode
    state	STRING	NULLABLE
    st_abv	STRING	NULLABLE
    bushels_total	FLOAT	NULLABLE
    pct_total_bushels	FLOAT	NULLABLE
    cumulative_pct	FLOAT	NULLABLE

    
    

Soybean Production and Yield per Acre for Top 11 States

• Table: prod_yield_top11_states
• Metadata:

  • Field Name	Type	Mode
    year	INTEGER	NULLABLE
    state	STRING	NULLABLE
    measure	STRING	NULLABLE
    quantity	FLOAT	NULLABLE

    
    

Soybean Monthly Prices for All States: 2000-2022

• USD per Bushel and Pct of Parity, by State: NASS: Years 2000-2022
• Table: prices_bushel_pct_parity_2000-22
• Data Withheld: Price data for 61 observations were withheld to avoid disclosing data for individual operations NASS Glossary
• Metadata:

  • Field Name	Type	Mode
    Program	STRING	NULLABLE
    Year	INTEGER	NULLABLE
    Period	STRING	NULLABLE
    Week_Ending	STRING	NULLABLE
    Geo_Level	STRING	NULLABLE
    State	STRING	NULLABLE
    State_ANSI	INTEGER	NULLABLE
    Ag_District	STRING	NULLABLE
    Ag_District_Code	STRING	NULLABLE
    County	STRING	NULLABLE
    County_ANSI	STRING	NULLABLE
    Zip_Code	STRING	NULLABLE
    Region	STRING	NULLABLE
    watershed_code	INTEGER	NULLABLE
    Watershed	STRING	NULLABLE
    Commodity	STRING	NULLABLE
    Data_Item	STRING	NULLABLE
    Domain	STRING	NULLABLE
    Domain_Category	STRING	NULLABLE
    Value	STRING	NULLABLE
    CV____	STRING	NULLABLE

    
    

Soybean Monthly Prices for Top 11 States: 2000-2022

• Table: soybean_prices_monthly_top11_states
• Metadata:

  • Field Name	Type	Mode
    price_period	DATE	NULLABLE
    state	STRING	NULLABLE
    st_abv	STRING	NULLABLE
    usd_bushel	FLOAT	NULLABLE

Weather Data

• Source: BigQuery Public Dataset: noaa_gsod
  • GSOD Definitions
    

Global NOAA GSOD Stations

• Table: bigquery-public-data.noaa_gsod.stations
• Metadata:

  • Field Name	Type	Mode
    usaf	STRING	NULLABLE
    wban	STRING	NULLABLE
    name	STRING	NULLABLE
    country	STRING	NULLABLE
    state	STRING	NULLABLE
    call	STRING	NULLABLE
    lat	FLOAT	NULLABLE
    lon	FLOAT	NULLABLE
    elev	STRING	NULLABLE
    begin	STRING	NULLABLE
    end	STRING	NULLABLE

    
    

NOAA GSOD Stations for Top 11 Soybean States

• Table: soy_states_noaa_stns
• Metadata:

  • Field Name	Type	Mode
    usaf	STRING	NULLABLE
    wban	STRING	NULLABLE
    name	STRING	NULLABLE
    state	STRING	NULLABLE
    st_abv	STRING	NULLABLE

Weather Data 2000-2022 for Top 11 Soybean States

• Table: weather_top11_states_nulls
• Metadata:

  • Field Name	Type	Mode
    station	STRING	NULLABLE
    weather_date	DATE	NULLABLE
    location	STRING	NULLABLE
    state	STRING	NULLABLE
    st_abv	STRING	NULLABLE
    mean_temp	FLOAT	NULLABLE
    max_temp	FLOAT	NULLABLE
    min_temp	FLOAT	NULLABLE
    precip	FLOAT	NULLABLE