Weather Impacted Apparel Retail Analytics Set (US)
Overview
This weather-impacted apparel retail product connects daily city rainfall, temperature, humidity, wind, condition and alerts to monthly sales for rainwear, outerwear, knitwear, tops, bottoms, dresses, activewear and weather accessories. Products, prices, stores, channels, promotions, inventory, returns and finance share the same city and time dimensions. Leakage-controlled features separate forecast weather and pre-period retail signals from sales labels. Real city names provide geography while weather observations, products, stores and transactions are modelled. The design supports assortment planning, weather-triggered merchandising, demand forecasting, markdown analysis, channel comparison and margin protection. Below the category the assortment is modelled the way a fast-fashion buyer works: an article carries a model and quality reference, its colourways and its sizes, and every article, colour and size combination is a sellable variant with its own monthly sales and its own stock roll-forward. Size curves differ by garment type and by market, so the Asian, American and European ladders carry different labels and different mixes, and broken size analysis records the months when the major sizes have gone and an option is finished commercially while stock remains on hand.
Analytics
Four entries from the packaged tables, with the performance the dataset records for them. Every value below is read from the shipped files.
Row Counts by Table
Counted from the files that ship, not estimated.
| Table | Rows |
|---|---|
| us_weather_retail_cities | 25 |
| us_weather_retail_years | 12 |
| us_weather_retail_countries | 1 |
| us_weather_retail_seasons | 4 |
| us_weather_retail_months | 144 |
| us_weather_retail_sales_channels | 6 |
| us_weather_retail_stores | 150 |
| us_weather_retail_apparel_categories | 8 |
| us_weather_retail_products | 44 |
| us_weather_retail_product_media | 44 |
| us_weather_retail_weather_stations | 25 |
| us_weather_retail_daily_weather | 109,575 |
| us_weather_retail_weather_alerts | 2,127 |
| us_weather_retail_price_lists | 528 |
| us_weather_retail_promotions | 3,600 |
| us_weather_retail_monthly_category_sales | 28,800 |
| us_weather_retail_inventory_monthly | 28,800 |
| us_weather_retail_returns_monthly | 28,800 |
| us_weather_retail_store_monthly_financials | 3,600 |
| us_weather_retail_monthly_city_weather_sales | 3,600 |
| us_weather_retail_weather_sales_features | 28,800 |
| us_weather_retail_weather_sales_forecasts | 28,800 |
| us_weather_retail_size_scales | 4 |
| us_weather_retail_sizes | 18 |
| us_weather_retail_size_curves | 42 |
| us_weather_retail_colours | 16 |
| us_weather_retail_product_variants | 714 |
| us_weather_retail_variant_monthly_sales | 102,816 |
| us_weather_retail_variant_monthly_stock | 102,816 |
| us_weather_retail_size_availability_monthly | 19,008 |
Table Relationships
One parent record and seven child tables, each joined back on the same key.
Schema
Every table ships with typed columns, referential integrity, and documentation.
| Column | Type | Description |
|---|---|---|
| city_id | varchar(8) | Stable identifier for city; use it for declared joins. |
| city_name | varchar(16) | Human-readable city name; names are modelled where the disclosure states so. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| country_code | varchar(8) | Stable code for country. |
| climate_zone | varchar(24) | Climate zone for the us_weather_retail_cities record. |
| latitude | numeric(6,2) | Latitude for the us_weather_retail_cities record. |
| longitude | numeric(7,2) | Longitude for the us_weather_retail_cities record. |
+4 more columns in us_weather_retail_cities. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| calendar_year | integer | Calendar year for the us_weather_retail_years record. |
| source_status | varchar(32) | source status in the declared lifecycle, result or source-status vocabulary. |
| vintage_date | date | vintage date as an ISO 8601 calendar date. |
| Column | Type | Description |
|---|---|---|
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| country_code | varchar(8) | Stable code for country. |
| country_name | varchar(16) | Human-readable country name; names are modelled where the disclosure states so. |
| region_name | varchar(24) | Human-readable region name; names are modelled where the disclosure states so. |
| currency_code | varchar(8) | Stable code for currency. |
| tax_rate_pct | numeric(5,2) | tax rate expressed as a percentage. |
| price_level_index | numeric(6,2) | price level index as the declared analytical score or index. |
+2 more columns in us_weather_retail_countries. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| season_id | varchar(8) | Stable identifier for season; use it for declared joins. |
| season_code | varchar(8) | Stable code for season. |
| season_name | varchar(16) | Human-readable season name; names are modelled where the disclosure states so. |
| retail_role | varchar(32) | Retail role for the us_weather_retail_seasons record. |
| Column | Type | Description |
|---|---|---|
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| calendar_year | integer | Calendar year for the us_weather_retail_months record. |
| month_number | varchar(8) | Month number for the us_weather_retail_months record. |
| month_name | varchar(16) | Human-readable month name; names are modelled where the disclosure states so. |
| season_id | varchar(8) | Stable identifier for season; use it for declared joins. |
| month_start | date | month start as an ISO 8601 calendar date. |
+3 more columns in us_weather_retail_months. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| channel_id | varchar(8) | Stable identifier for channel; use it for declared joins. |
| channel_code | varchar(8) | Stable code for channel. |
| channel_name | varchar(40) | Human-readable channel name; names are modelled where the disclosure states so. |
| channel_group | varchar(16) | Channel group for the us_weather_retail_sales_channels record. |
| weather_sensitivity_index | numeric(5,2) | weather sensitivity index as the declared analytical score or index. |
| Column | Type | Description |
|---|---|---|
| store_id | varchar(16) | Stable identifier for store; use it for declared joins. |
| store_name | varchar(56) | Human-readable store name; names are modelled where the disclosure states so. |
| city_id | varchar(8) | Stable identifier for city; use it for declared joins. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| channel_id | varchar(8) | Stable identifier for channel; use it for declared joins. |
| opened_on | date | opened on as an ISO 8601 calendar date. |
| floor_area_sqm | integer | Floor area sqm for the us_weather_retail_stores record. |
+4 more columns in us_weather_retail_stores. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| apparel_category_id | varchar(8) | Stable identifier for apparel category; use it for declared joins. |
| category_code | varchar(8) | Stable code for category. |
| category_name | varchar(24) | Human-readable category name; names are modelled where the disclosure states so. |
| rainfall_elasticity | numeric(5,2) | Rainfall elasticity for the us_weather_retail_apparel_categories record. |
| temperature_elasticity | numeric(5,2) | Temperature elasticity for the us_weather_retail_apparel_categories record. |
| merchandising_role | varchar(24) | Merchandising role for the us_weather_retail_apparel_categories record. |
| Column | Type | Description |
|---|---|---|
| product_id | varchar(16) | Stable identifier for product; use it for declared joins. |
| apparel_category_id | varchar(8) | Stable identifier for apparel category; use it for declared joins. |
| product_name | varchar(56) | Human-readable product name; names are modelled where the disclosure states so. |
| model_code | varchar(8) | Five digit model number: the garment design, before the fabric it is executed in. |
| quality_code | varchar(8) | Three digit quality number: the fabric and make specification the model is executed in. |
| article_reference | varchar(16) | The reference as a price ticket prints it, model and quality separated by a slash, with the leading zero of the model dropped. |
| padded_reference | varchar(16) | The same reference zero padded to eight digits, which is the form the source systems key on; join on this rather than on the printed form. |
+17 more columns in us_weather_retail_products. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| product_media_id | varchar(16) | Stable identifier for product media; use it for declared joins. |
| product_id | varchar(16) | Stable identifier for product; use it for declared joins. |
| image_file | varchar(32) | Image file for the us_weather_retail_product_media record. |
| image_format | varchar(16) | Image format for the us_weather_retail_product_media record. |
| image_width_px | integer | Image width px for the us_weather_retail_product_media record. |
| image_height_px | integer | Image height px for the us_weather_retail_product_media record. |
| media_usage | varchar(24) | Media usage for the us_weather_retail_product_media record. |
+1 more columns in us_weather_retail_product_media. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| weather_station_id | varchar(8) | Stable identifier for weather station; use it for declared joins. |
| city_id | varchar(8) | Stable identifier for city; use it for declared joins. |
| station_name | varchar(48) | Human-readable station name; names are modelled where the disclosure states so. |
| station_type | varchar(24) | Station type for the us_weather_retail_weather_stations record. |
| elevation_m | integer | Elevation m for the us_weather_retail_weather_stations record. |
| observation_start | date | observation start as an ISO 8601 calendar date. |
| quality_band | varchar(32) | Quality band for the us_weather_retail_weather_stations record. |
+2 more columns in us_weather_retail_weather_stations. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| daily_weather_id | varchar(24) | Stable identifier for daily weather; use it for declared joins. |
| weather_station_id | varchar(8) | Stable identifier for weather station; use it for declared joins. |
| city_id | varchar(8) | Stable identifier for city; use it for declared joins. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| calendar_date | date | calendar date as an ISO 8601 calendar date. |
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
| rainfall_mm | numeric(5,1) | rainfall in millimetres. |
+9 more columns in us_weather_retail_daily_weather. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| weather_alert_id | varchar(16) | Stable identifier for weather alert; use it for declared joins. |
| city_id | varchar(8) | Stable identifier for city; use it for declared joins. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| calendar_date | date | calendar date as an ISO 8601 calendar date. |
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
| alert_type | varchar(16) | Alert type for the us_weather_retail_weather_alerts record. |
| severity_band | varchar(16) | Severity band for the us_weather_retail_weather_alerts record. |
+3 more columns in us_weather_retail_weather_alerts. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| price_list_id | varchar(24) | Stable identifier for price list; use it for declared joins. |
| product_id | varchar(16) | Stable identifier for product; use it for declared joins. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| currency_code | varchar(8) | Stable code for currency. |
| base_price_usd | numeric(7,2) | base price in United States dollars. |
| country_price_adjustment_pct | numeric(5,2) | country price adjustment expressed as a percentage. |
+5 more columns in us_weather_retail_price_lists. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| promotion_id | varchar(16) | Stable identifier for promotion; use it for declared joins. |
| city_id | varchar(8) | Stable identifier for city; use it for declared joins. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
| apparel_category_id | varchar(8) | Stable identifier for apparel category; use it for declared joins. |
| promotion_name | varchar(32) | Human-readable promotion name; names are modelled where the disclosure states so. |
| promotion_mechanic | varchar(24) | Promotion mechanic for the us_weather_retail_promotions record. |
+6 more columns in us_weather_retail_promotions. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| monthly_category_sales_id | varchar(24) | Stable identifier for monthly category sales; use it for declared joins. |
| city_id | varchar(8) | Stable identifier for city; use it for declared joins. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
| season_id | varchar(8) | Stable identifier for season; use it for declared joins. |
| apparel_category_id | varchar(8) | Stable identifier for apparel category; use it for declared joins. |
| units_sold | integer | Units sold for the us_weather_retail_monthly_category_sales record. |
+13 more columns in us_weather_retail_monthly_category_sales. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| inventory_month_id | varchar(24) | Stable identifier for inventory month; use it for declared joins. |
| city_id | varchar(8) | Stable identifier for city; use it for declared joins. |
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
| apparel_category_id | varchar(8) | Stable identifier for apparel category; use it for declared joins. |
| opening_units | integer | Opening units for the us_weather_retail_inventory_monthly record. |
| received_units | integer | Received units for the us_weather_retail_inventory_monthly record. |
| units_sold | integer | Units sold for the us_weather_retail_inventory_monthly record. |
+6 more columns in us_weather_retail_inventory_monthly. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| return_month_id | varchar(24) | Stable identifier for return month; use it for declared joins. |
| city_id | varchar(8) | Stable identifier for city; use it for declared joins. |
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
| apparel_category_id | varchar(8) | Stable identifier for apparel category; use it for declared joins. |
| units_returned | integer | Units returned for the us_weather_retail_returns_monthly record. |
| return_rate_pct | numeric(6,2) | return rate expressed as a percentage. |
| refund_value_usd | numeric(10,2) | refund value in United States dollars. |
+3 more columns in us_weather_retail_returns_monthly. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| store_month_financial_id | varchar(16) | Stable identifier for store month financial; use it for declared joins. |
| city_id | varchar(8) | Stable identifier for city; use it for declared joins. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
| net_revenue_usd | numeric(11,2) | net revenue in United States dollars. |
| cost_goods_usd | numeric(11,2) | cost goods in United States dollars. |
| gross_margin_usd | numeric(11,2) | gross margin in United States dollars. |
+6 more columns in us_weather_retail_store_monthly_financials. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| monthly_city_weather_sales_id | varchar(16) | Stable identifier for monthly city weather sales; use it for declared joins. |
| city_id | varchar(8) | Stable identifier for city; use it for declared joins. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
| season_id | varchar(8) | Stable identifier for season; use it for declared joins. |
| total_rainfall_mm | numeric(6,1) | total rainfall in millimetres. |
| rain_days | integer | rain in days. |
+10 more columns in us_weather_retail_monthly_city_weather_sales. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| weather_sales_feature_id | varchar(24) | Stable identifier for weather sales feature; use it for declared joins. |
| city_id | varchar(8) | Stable identifier for city; use it for declared joins. |
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
| apparel_category_id | varchar(8) | Stable identifier for apparel category; use it for declared joins. |
| feature_source_cutoff | date | Latest source date available to this feature row; it is strictly earlier than the target event or period when history exists. |
| lag_units_1m | integer | Lag units 1m for the us_weather_retail_weather_sales_features record. |
| rolling_units_3m | integer | Rolling units 3m for the us_weather_retail_weather_sales_features record. |
+8 more columns in us_weather_retail_weather_sales_features. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| weather_sales_forecast_id | varchar(24) | Stable identifier for weather sales forecast; use it for declared joins. |
| weather_sales_feature_id | varchar(24) | Stable identifier for weather sales feature; use it for declared joins. |
| city_id | varchar(8) | Stable identifier for city; use it for declared joins. |
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
| apparel_category_id | varchar(8) | Stable identifier for apparel category; use it for declared joins. |
| forecast_created_on | date | forecast created on as an ISO 8601 calendar date. |
| model_version | varchar(24) | Model version for the us_weather_retail_weather_sales_forecasts record. |
+8 more columns in us_weather_retail_weather_sales_forecasts. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| size_scale_id | varchar(8) | Stable identifier for size scale; use it for declared joins. |
| scale_code | varchar(16) | Stable code for scale. |
| scale_name | varchar(48) | Human-readable scale name; names are modelled where the disclosure states so. |
| size_system | varchar(24) | The national or house size system whose labels this ladder prints. |
| scale_kind | varchar(16) | Which family of ladder this is: alpha, numeric, footwear or single size. |
| market_region | varchar(24) | The market this ladder is sold into; the same body is labelled differently in each. |
| size_count | integer | Size count for the us_weather_retail_size_scales record. |
+4 more columns in us_weather_retail_size_scales. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| size_id | varchar(8) | Stable identifier for size; use it for declared joins. |
| size_scale_id | varchar(8) | Stable identifier for size scale; use it for declared joins. |
| size_code | varchar(8) | Three digit size segment of the reference, which is what the barcode carries rather than the printed label. |
| size_label | varchar(16) | The size as it is printed on the ticket in this market. |
| size_order | integer | Position on the ladder from smallest to largest. |
| core_size_flag | boolean | Whether this is a major size: the contiguous run in the middle of the ladder that carries seventy per cent of the buy, and the run whose loss finishes an option commercially. |
| base_buy_share_pct | integer | Share of the market buy placed on this size before the garment type sharpens or flattens the curve. |
+7 more columns in us_weather_retail_sizes. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| size_curve_id | varchar(16) | Stable identifier for size curve; use it for declared joins. |
| garment_block | varchar(16) | The garment family this curve is cut for; a tailored coat and a knitted jumper are bought in different ratios on the same ladder. |
| size_scale_id | varchar(8) | Stable identifier for size scale; use it for declared joins. |
| size_id | varchar(8) | Stable identifier for size; use it for declared joins. |
| size_code | varchar(8) | Stable code for size. |
| size_label | varchar(16) | Size label for the us_weather_retail_size_curves record. |
| size_order | integer | Size order for the us_weather_retail_size_curves record. |
+5 more columns in us_weather_retail_size_curves. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| colour_id | varchar(8) | Stable identifier for colour; use it for declared joins. |
| colour_code | varchar(8) | Three digit colour segment of the reference, stable across models so that a colour is joinable. |
| colour_name | varchar(16) | Human-readable colour name; names are modelled where the disclosure states so. |
| colour_family | varchar(16) | The tonal family the colourway belongs to. |
| seasonal_role | varchar(24) | Whether the colourway is carried across seasons or belongs to one. |
| Column | Type | Description |
|---|---|---|
| variant_id | varchar(16) | Stable identifier for variant; use it for declared joins. |
| product_id | varchar(16) | Stable identifier for product; use it for declared joins. |
| apparel_category_id | varchar(8) | Stable identifier for apparel category; use it for declared joins. |
| colour_id | varchar(8) | Stable identifier for colour; use it for declared joins. |
| size_id | varchar(8) | Stable identifier for size; use it for declared joins. |
| size_scale_id | varchar(8) | Stable identifier for size scale; use it for declared joins. |
| sku_code | varchar(24) | The fourteen digit sellable unit code, being model, quality, colour and size concatenated. |
+12 more columns in us_weather_retail_product_variants. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| variant_monthly_sales_id | varchar(16) | Stable identifier for variant monthly sales; use it for declared joins. |
| variant_id | varchar(16) | Stable identifier for variant; use it for declared joins. |
| product_id | varchar(16) | Stable identifier for product; use it for declared joins. |
| apparel_category_id | varchar(8) | Stable identifier for apparel category; use it for declared joins. |
| colour_id | varchar(8) | Stable identifier for colour; use it for declared joins. |
| size_id | varchar(8) | Stable identifier for size; use it for declared joins. |
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
+12 more columns in us_weather_retail_variant_monthly_sales. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| variant_stock_id | varchar(16) | Stable identifier for variant stock; use it for declared joins. |
| variant_id | varchar(16) | Stable identifier for variant; use it for declared joins. |
| product_id | varchar(16) | Stable identifier for product; use it for declared joins. |
| apparel_category_id | varchar(8) | Stable identifier for apparel category; use it for declared joins. |
| colour_id | varchar(8) | Stable identifier for colour; use it for declared joins. |
| size_id | varchar(8) | Stable identifier for size; use it for declared joins. |
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
+11 more columns in us_weather_retail_variant_monthly_stock. The full schema ships with the download.
| Column | Type | Description |
|---|---|---|
| size_availability_id | varchar(16) | Stable identifier for size availability; use it for declared joins. |
| product_id | varchar(16) | Stable identifier for product; use it for declared joins. |
| colour_id | varchar(8) | Stable identifier for colour; use it for declared joins. |
| apparel_category_id | varchar(8) | Stable identifier for apparel category; use it for declared joins. |
| month_id | varchar(16) | Stable identifier for month; use it for declared joins. |
| season_id | varchar(8) | Stable identifier for season; use it for declared joins. |
| size_scale_id | varchar(8) | Stable identifier for size scale; use it for declared joins. |
+20 more columns in us_weather_retail_size_availability_monthly. The full schema ships with the download.
Sample Data
A snapshot of real rows from the dataset (values are fully synthetic).
| variant_id | product_id | colour_id | size_label | core_size_flag | month_id | units_sold | net_sales_usd | gross_margin_usd | average_unit_price_usd |
|---|---|---|---|---|---|---|---|---|---|
| VAR00001 | APU0101 | CLR14 | XS | false | M201501 | 134 | 7447.54 | 3745.61 | 55.58 |
| VAR00002 | APU0101 | CLR14 | S | false | M201501 | 492 | 27344.68 | 13752.51 | 55.58 |
| VAR00003 | APU0101 | CLR14 | M | true | M201501 | 1616 | 89815.06 | 45170.84 | 55.58 |
Version History
| v1.2.0 | 2026-08-21 | Every garment now carries its colourways and sizes as sellable variants, because a set about apparel could not answer how many units sold in size M, and each region gets the assortment, the product names, the size curves and the renders its own market actually buys. |
Related Datasets
European Skincare Product Operations and Sales Analytics Set (EU)
RetailCPGSKN934 is a deterministic synthetic skincare operations and sales warehouse for fictional London-based Alderquay, linking brands and products to research, regulation, sourcing, production, inventory, customers, sales teams, returns, disposal and profitability across Europe, North America and selected Asian markets.
FMCG Manufacturing Product Performance Set (EU)
RetailA complete Europe analytical warehouse covering company, plant, product, material, batch, quality, location, channel, customer, shipment, inventory, promotion, sales, return, trade-spend, finance, rating and forecast data.
FMCG Manufacturing Product Performance Set (US)
RetailA complete United States analytical warehouse covering company, plant, product, material, batch, quality, location, channel, customer, shipment, inventory, promotion, sales, return, trade-spend, finance, rating and forecast data.