Real USDA Shipping Point Data - Blackberries

1. PARSING REAL USDA CSV DATA
================================

✅ Parsed 10 rows of blackberry data

Sample Parsed Row:
  Date: 09/11/2025
  Location: Fresno California
  Commodity: Blackberries
  Package: flats 12 6-oz cups with lids
  Organic: Yes
  Import/Export: D (domestic)
  Price Range: $12 - $16
  Mostly: $12 - $14
  Market Tone: Lower
  Supply: 

2. AGGREGATED BY LOCATION
================================

📍 Fresno California - 09/11/2025
   Package: flats 12 6-oz cups with lids
   Organic: $12 - $16 (1 entries)
   Conventional: $9 - $13 (2 entries)
   Import: $8 - $12 (1 entries)
   Domestic: $11 - $15 (2 entries)
   Market Tone: Lower
   Supply: 

📍 Fresno California - 09/12/2025
   Package: flats 12 6-oz cups with lids
   Organic: $12 - $16 (1 entries)
   Conventional: $9 - $13 (2 entries)
   Import: $8 - $12 (1 entries)
   Domestic: $11 - $15 (2 entries)
   Market Tone: About Steady
   Supply: 

📍 Miami Florida - 09/12/2025
   Package: flats 12 6-oz cups with lids
   Conventional: $10 - $15 (1 entries)
   Import: $10 - $15 (1 entries)
   Market Tone: Steady
   Supply: 

📍 Fresno California - 09/15/2025
   Package: flats 12 6-oz cups with lids
   Organic: $10 - $14 (1 entries)
   Conventional: $7 - $11 (2 entries)
   Import: $6 - $10 (1 entries)
   Domestic: $9 - $13 (2 entries)
   Market Tone: Lower
   Supply: 

3. PRICE TREND ANALYSIS
================================

📅 09/11/2025
   Average Price: $12.00
   Market Tone: Lower, About Steady

📅 09/12/2025
   Average Price: $12.13
   Market Tone: About Steady, Steady

📅 09/15/2025
   Average Price: $10.00
   Market Tone: Lower

4. SUMMARY STATISTICS
================================

Overall Average: $11.45
Organic Average: $13.33
Conventional Average: $10.64
Import Average: $10.13
Domestic Average: $12.33

Price Range:
  Lowest: $8
  Highest: $14

5. KEY INSIGHTS FROM REAL DATA
================================

✓ Data shows both ORGANIC and CONVENTIONAL prices
✓ Includes IMPORT (from Mexico, Guatemala) and DOMESTIC sources
✓ Prices trending LOWER over the period (09/11 to 09/15)
✓ Supply is LIGHT to VERY LIGHT
✓ Wide range in prices due to previous commitments
✓ Package standard: flats 12 6-oz cups with lids
✓ F.O.B. Shipping Point pricing (at origin)

📊 How to Access This Data from USDA

  1. Go to https://mymarketnews.ams.usda.gov/public_data
  2. Click 'Search by Market Types'
  3. Select 'Shipping Point' as Market Type
  4. Choose your Commodity (e.g., Blackberries)
  5. Set date range (10 days prior to today)
  6. Click 'Get Data!' to download CSV

← Back to Dashboard