Catalog: ranch_intel β€’ Version: v0.0.1
Store: Local Livestock Markets (local_markets) β€’ Coordinate: A01-S01-B01
Tags: markets, overview, fips:48285, geo:lavaca_tx
Bin Description
Markets in/near Lavaca County with freshness indicators.
MD Frontmatter
{
  "access_policy": "public",
  "coordinate": "A01-S01-B01",
  "sources": [
    "legacy:regional_markets"
  ],
  "store_id": "local_markets",
  "tags": [
    "markets",
    "overview",
    "fips:48285",
    "geo:lavaca_tx"
  ],
  "title": "Lavaca County Market Overview",
  "updated_at": "2025-12-13T00:00:00+00:00"
}
MD Body
## What this bin provides
- A county-first entry point to local market intelligence for Lavaca County.

## How to use
- Snapshot will include:
  - markets in/near county
  - latest sale report freshness
  - links to map UI


Add to Cart
Store this bin in your browser cart for context-pack export.
Snapshot (runtime)
{
  "payload": {
    "kind": "local_markets_county_overview",
    "links": {
      "legacy_map": "/intelligence/local-markets/map",
      "county_shelf": "/supercenter/county/48285",
      "legacy_overview": "/intelligence/local-markets"
    },
    "county": "Lavaca",
    "status": "ok",
    "markets": [
      {
        "name": "Hallettsville Livestock Commission",
        "phone": "(361) 798-4336",
        "state": "TX",
        "county": "Lavaca",
        "status": "scouting",
        "website": "https://www.hallettsvillelivestock.com/",
        "latitude": 29.4433,
        "location": "Hallettsville, TX",
        "sale_day": "Tuesday",
        "longitude": -96.9411,
        "market_id": "hallettsville",
        "key_prices": {
          "steer_400_500": {
            "price_avg": 447.5,
            "price_low": 390,
            "price_high": 505
          },
          "heifer_400_500": {
            "price_avg": 414.0,
            "price_low": 350,
            "price_high": 478
          },
          "slaughter_cows_high": {
            "price_avg": 149.0,
            "price_low": 139,
            "price_high": 159
          },
          "slaughter_bulls_high": {
            "price_avg": 189.0,
            "price_low": 185,
            "price_high": 193
          }
        },
        "total_head": 1611,
        "harvested_at": "2025-12-06T15:01:16.569336",
        "distance_miles": null,
        "freshness_days": 11,
        "latest_report_date": "2025-12-02"
      },
      {
        "name": "Flatonia Livestock Commission",
        "phone": "(361) 865-2121",
        "state": "TX",
        "county": "Fayette",
        "status": "scouting",
        "website": "https://flatonialivestock.com/",
        "latitude": 29.6872,
        "location": "Flatonia, TX",
        "sale_day": "Monday",
        "longitude": -97.1056,
        "market_id": "flatonia",
        "key_prices": {},
        "total_head": 244,
        "harvested_at": "2025-12-06T14:09:58.455724",
        "distance_miles": 23.720296503777163,
        "freshness_days": 12,
        "latest_report_date": "2025-12-01"
      },
      {
        "name": "Cuero Livestock Commission",
        "phone": "(361) 275-3661",
        "state": "TX",
        "county": "DeWitt",
        "status": "ready",
        "website": "https://cuerols.com/",
        "latitude": 29.0938,
        "location": "Cuero, TX",
        "sale_day": "Friday",
        "longitude": -97.2889,
        "market_id": "cuero",
        "key_prices": {},
        "total_head": null,
        "harvested_at": "2025-12-06T15:01:16.569336",
        "distance_miles": 29.71672098112093,
        "freshness_days": 3,
        "latest_report_date": "2025-12-10"
      },
      {
        "name": "Columbus Livestock Co.",
        "phone": "(979) 732-2622",
        "state": "TX",
        "county": "Colorado",
        "status": "ready",
        "website": "https://southernlivestock.com/market-report-city/columbus-tx/",
        "latitude": 29.7066,
        "location": "Columbus, TX",
        "sale_day": "Tuesday",
        "longitude": -96.5397,
        "market_id": "columbus",
        "key_prices": {
          "steer_400_500": {
            "price_avg": 445.0,
            "price_low": 360.0,
            "price_high": 530.0
          },
          "heifer_400_500": {
            "price_avg": 410.0,
            "price_low": 350.0,
            "price_high": 470.0
          }
        },
        "total_head": 1266,
        "harvested_at": "2025-12-13T17:37:53.069900",
        "distance_miles": 32.15279515311834,
        "freshness_days": 2,
        "latest_report_date": "2025-12-11"
      },
      {
        "name": "Edna Livestock Auction",
        "phone": "(361) 782-3306",
        "state": "TX",
        "county": "Jackson",
        "status": "scouting",
        "website": "https://www.whartonlivestock.com/",
        "latitude": 28.9786,
        "location": "Edna, TX",
        "sale_day": "Monday",
        "longitude": -96.6458,
        "market_id": "edna",
        "key_prices": {},
        "total_head": null,
        "harvested_at": "2025-12-06T14:14:08.852987",
        "distance_miles": 32.55752919195638,
        "freshness_days": 12,
        "latest_report_date": "2025-12-01"
      },
      {
        "name": "Gonzales Livestock Market",
        "phone": "(830) 672-2845",
        "state": "TX",
        "county": "Gonzales",
        "status": "blocked",
        "website": "https://www.gonzaleslivestock.com/",
        "latitude": 29.5016,
        "location": "Gonzales, TX",
        "sale_day": "Saturday",
        "longitude": -97.4526,
        "market_id": "gonzales",
        "key_prices": {},
        "total_head": 850,
        "harvested_at": "2025-12-06T16:05:07.606562",
        "distance_miles": 32.87325388733333,
        "freshness_days": 21,
        "latest_report_date": "2025-11-22"
      },
      {
        "name": "El Campo Livestock Exchange",
        "phone": "(979) 543-6381",
        "state": "TX",
        "county": "Wharton",
        "status": "ready",
        "website": "https://www.elcampolivestock.com/",
        "latitude": 29.1966,
        "location": "El Campo, TX",
        "sale_day": "Tuesday",
        "longitude": -96.2694,
        "market_id": "elcampo",
        "key_prices": {
          "steer_400_500": {
            "price_avg": 386.0,
            "price_low": 242.0,
            "price_high": 530.0
          },
          "heifer_400_500": {
            "price_avg": 435.0,
            "price_low": 370.0,
            "price_high": 500.0
          }
        },
        "total_head": 2300,
        "harvested_at": "2025-12-13T17:37:54.413100",
        "distance_miles": 41.46553248529741,
        "freshness_days": 3,
        "latest_report_date": "2025-12-10"
      },
      {
        "name": "Wharton Livestock Auction",
        "phone": "(979) 532-3691",
        "state": "TX",
        "county": "Wharton",
        "status": "blocked",
        "website": "https://www.whartonlivestock.com/",
        "latitude": 29.3116,
        "location": "Wharton, TX",
        "sale_day": "Wednesday",
        "longitude": -96.1027,
        "market_id": "wharton",
        "key_prices": {
          "steer_400_500": {
            "avg": 361,
            "prices": [
              "200 - 440"
            ]
          },
          "heifer_400_500": {
            "avg": 309,
            "prices": [
              "160 - 435"
            ]
          }
        },
        "total_head": 748,
        "harvested_at": "2025-12-06T16:05:07.606562",
        "distance_miles": 49.6843858200361,
        "freshness_days": 24,
        "latest_report_date": "2025-11-19"
      },
      {
        "name": "Giddings Livestock Auction",
        "phone": null,
        "state": "TX",
        "county": "Lee",
        "status": "ready",
        "website": "https://southernlivestock.com/market-report-city/giddings-tx/",
        "latitude": 30.1824,
        "location": "Giddings, TX",
        "sale_day": "Wednesday",
        "longitude": -96.9364,
        "market_id": "giddings",
        "key_prices": {
          "steer_400_500": {
            "price_avg": 468.5,
            "price_low": 422.0,
            "price_high": 515.0
          },
          "heifer_400_500": {
            "price_avg": 448.25,
            "price_low": 394.0,
            "price_high": 502.5
          }
        },
        "total_head": 1989,
        "harvested_at": "2025-12-13T17:38:30.016264",
        "distance_miles": 55.26773945364986,
        "freshness_days": 4,
        "latest_report_date": "2025-12-09"
      },
      {
        "name": "Giddings Livestock Auction - Giddings",
        "phone": null,
        "state": "TX",
        "county": "Lee",
        "status": "scouting",
        "website": null,
        "latitude": 30.18305,
        "location": "Giddings, TX",
        "sale_day": null,
        "longitude": -96.936611,
        "market_id": "ams_3724",
        "key_prices": {},
        "total_head": 757,
        "harvested_at": "2025-12-09T03:36:18.109602",
        "distance_miles": 55.31282241238965,
        "freshness_days": 11,
        "latest_report_date": "2025-12-02"
      }
    ],
    "summary": {
      "ready": 4,
      "blocked": 2,
      "unknown": 0,
      "scouting": 4,
      "market_count": 10,
      "with_reports": 10
    },
    "fips_code": "48285",
    "center_lat": 29.382578,
    "center_lon": -96.923633,
    "state_abbr": "TX",
    "generated_at": "2025-12-13T20:11:04.170013"
  },
  "citations": [
    {
      "kind": "internal_db",
      "source": "TopHand Regional Markets Harvester",
      "tables": [
        "regional_markets",
        "regional_market_reports",
        "v_regional_latest_reports"
      ]
    },
    {
      "url": "/intelligence/local-markets",
      "kind": "ui",
      "source": "Local Markets UI"
    }
  ],
  "confidence": 0.85,
  "computed_at": "2025-12-13T20:11:04.182128",
  "expires_at": "2025-12-14T20:11:04.178461"
}