"internal-agtransport-usda-gov/export-sales-wnn7-29tu:latest"."export_sales"

SELECT
    ":id", -- Socrata column ID
    "unit", -- Metric tons.
    "outstanding_sales_total", -- Sum of CMY and NMY outstanding sales.
    "myear", -- Calculated based on date, where corn and soybean marketing years start in September and wheat starts in June.
    "totcommcmy", -- The grand total of outstanding sales plus accumulated exports by country and/or commodity at any given time during the marketing year. 
    "netsalesnmy", -- For the next marketing year, the sum total resulting from new export sales, increases resulting from changes in destination, decreases resulting from changes in destination, decreases resulting from purchases from foreign sellers, and cancellations resulting from contract adjustments, buybacks, loading tolerances, changes in marketing year, or change in commodity.
    "marketingmonth", -- Calculated for each commodity by offsetting the calendar year month to match the marketing year.
    "accexportscmy", -- Accumulated shipments of reportable commodities from the beginning of the marketing year (for each commodity) to the current week ending date. * Note:Accumulated exports are revised periodically due to adjustments made by reporting exporters. 
    "country", -- Export destination.
    "year", -- Year number calculated from the reported week ending date (Date field). Week ending dates falling on or after January 4 correspond to the calendar year of the reported week. Week ending dates falling on or before January 3 correspond to the previous calendar year. For example, a week ending date falling on January 2, 2018 would be “2017.” Values range from 2000 to the present.
    "week", -- Week number calculated from the reported week ending date (Date field). Week 1 is the first week of the year with a week ending date falling on or after January 4. In other words, it is the first reported week of data which includes four days in the new year. Values range from 1 to 52 or 53, depending on the year.
    "date", -- Calendar week ending date.
    "net_sales_total", -- Sum of CMY and NMY net sales.
    "month", -- Month number calculated from the reported week ending date (Date field). Week ending dates falling before the fourth day of the month are assigned to the previous month. For example, a week ending date falling on February 1st, 2nd, or 3rd would correspond to “1” (January), since there are less than four days in the reported week that fall in February. Values range from 1 through 12, where 1 refers to January, 2 to February, etc.
    "wkexportscmy", -- Shipments of reportable commodities exported against sales for a reporting week Friday through Thursday. 
    "my", -- When the calendar year spans the marketing year end, this row designates the values attributable to the previous and next marketing years.
    "commodity", -- Wheat, Corn, or Soybeans.
    "outsalescmy", -- The total outstanding export sales contracts for the current marketing year that have not yet been shipped.
    "grosalescmy", -- Includes increases resulting from new export sales, contract adjustments, loading tolerances, changes in marketing year, change in commodity or sales made against exports for the exporter's own account. Note: Gross new sales will include sales that were unshipped (carryover sales) at the end of the marketing year. 
    "netsalescmy", -- For the current marketing year, the sum total resulting from new export sales, increases resulting from changes in destination, decreases resulting from changes in destination, decreases resulting from purchases from foreign sellers, and cancellations resulting from contract adjustments, buybacks, loading tolerances, changes in marketing year, or change in commodity.
    "outsalesnmy", -- The total outstanding export sales contracts for the next marketing year.
    "type" -- Subcategory of commodity, if it exists.
FROM
    "internal-agtransport-usda-gov/export-sales-wnn7-29tu:latest"."export_sales"
LIMIT 100;

sgr mount socrata \
  "internal-agtransport-usda-gov/export-sales-wnn7-29tu" \
  --handler-options '{
    "domain": "internal.agtransport.usda.gov",
    "tables": {
        "export_sales": "wnn7-29tu"
    }
}'