← back to Wine Finder
FRENCH_WINE_DATA_SOURCES.md
288 lines
# French Wine Data Sources - Implementation Guide
## Overview
This document catalogs all identified public domain and open data sources for French wine information, suitable for integration into the Red Thunder Wine Tracker.
## Data Sources Summary
### 1. INAO (Institut National de l'Origine et de la Qualité)
**Official French Government Wine Authority**
#### Dataset: Aires et produits AOC/AOP et IGP
- **URL**: https://www.data.gouv.fr/datasets/aires-et-produits-aoc-aop-et-igp/
- **Format**: CSV (473.8 KB)
- **License**: Licence Ouverte / Open Licence (Public Domain Compatible)
- **Last Updated**: October 9, 2025
- **Content**:
- Geographical areas of AOC/AOP appellations
- IGP (Indications Géographiques Protégées) regions
- Products attached to each geographical area
- Wine appellations across France
#### Direct CSV Download
```
https://www.data.gouv.fr/fr/datasets/r/[resource-id].csv
```
#### Additional INAO Datasets
- **Délimitation Parcellaire des AOC Viticoles**: Parcel-level delimitation of wine AOCs
- **Cartes des grandes régions productrices de vins AOP**: Maps of major AOP wine-producing regions
- **Website**: https://www.inao.gouv.fr/en/geographic-data
---
### 2. FranceAgriMer
**National Establishment for Agricultural and Marine Products**
#### Wine Statistics Portal
- **URL**: https://www.franceagrimer.fr/filieres-Vin-et-cidre/Vin/Eclairer/Etudes-et-Analyses/Chiffres-et-bilans
- **Content**:
- Production statistics
- Consumption data
- International wine trade exchanges
- Still wine sales in large-scale distribution
- Wine purchases by French households
- Regional production data
#### Data Characteristics
- Regularly updated reports
- Free access to statistical data
- PDF reports and data tables
- Historical data from 2003+
---
### 3. OpenWines Project (GitHub)
**Community Open Data Initiative**
#### Repository: openwines-area-cepages-fr
- **GitHub**: https://github.com/foodopendata/openwines-area-cepages-fr
- **Alternative**: https://github.com/OpenWines/area_cepages_france
- **Format**: CSV
- **License**: Public Domain Dedication and License (PDDL)
- **Content**:
- French wine grape varieties (cépages) by year
- Area coverage per variety
- Historical data trends
- Source: FranceAgriMer agricultural observatory
#### Data Fields
- Year
- Grape variety (cépage)
- Area (hectares)
- Region/Department
---
### 4. IEEE DataPort - Bordeaux Wines Dataset
**Academic Research Dataset**
#### Wineinformatics: 21st Century Bordeaux Wines
- **URL**: https://ieee-dataport.org/open-access/wineinformatics-21st-century-bordeaux-wines-dataset
- **Content**:
- Bordeaux wines 2000-2016
- 1855 Bordeaux classification wines
- Quality metrics
- Historical pricing data
#### Access
- Free registration required
- Open access dataset
- Research-grade data quality
---
### 5. Le Mans Université - French Wine Harvest Dataset
**Academic Research (2024)**
#### French Wine Dataset - Harvest Value Mapping
- **URL**: https://univ-lemans.hal.science/hal-04628325v1
- **Content**:
- Expected harvest value by county
- Built from open data sources
- Regional production forecasts
- Agricultural statistics
#### Format
- Academic publication with supplementary data
- CSV/tabular data available
---
### 6. Mets & Vins - Wine Pairing Database
#### Open Food-Wine Pairing Data
- **URL**: https://metsvins.fr/data
- **Format**: CSV download
- **License**: ODbL (Open Database License)
- **Content**:
- Food and wine pairing recommendations
- Wine characteristics
- Flavor profiles
- Complementary foods
---
### 7. European Commission - Agri-food Data Portal
#### EU Wine Production Database
- **URL**: https://agridata.ec.europa.eu/extensions/DataPortal/wine.html
- **Content**:
- Annual production since 1997/1998
- Per Member State statistics
- Wine type classifications
- Color breakdowns (red, white, rosé)
- French production in European context
#### Data Characteristics
- Official EU statistics
- Comprehensive historical data
- Downloadable formats
- Regular updates
---
### 8. GitHub - liberatinao Wine CSV
#### INAO Data in GitHub
- **URL**: https://github.com/24eme/liberatinao/blob/master/data/vins.csv
- **Format**: CSV
- **Content**:
- Processed INAO wine data
- Structured for easy consumption
- French wine appellations
- Regional classifications
---
## Implementation Priority
### Tier 1 (Immediate Implementation)
1. **INAO AOC/AOP Dataset** - Core French appellation data
2. **OpenWines Grape Varieties** - Comprehensive cépage information
3. **GitHub liberatinao CSV** - Ready-to-use structured data
### Tier 2 (Secondary Implementation)
4. **EU Agri-food Portal** - Broader European context
5. **Bordeaux IEEE Dataset** - Premium wine segment
6. **Mets & Vins Pairings** - Value-added recommendations
### Tier 3 (Future Enhancement)
7. **FranceAgriMer Statistics** - Economic and market data
8. **Le Mans Université** - Academic research integration
---
## Technical Implementation Notes
### Data Access Methods
#### 1. Direct CSV Downloads
- INAO datasets available as direct CSV downloads
- OpenWines data accessible via raw GitHub URLs
- No authentication required
#### 2. API Access
- EU Agri-food portal may have API endpoints (TBD)
- data.gouv.fr provides API access to datasets
#### 3. Web Scraping
- FranceAgriMer reports may require PDF parsing
- IEEE DataPort requires registration
### Integration Architecture
```javascript
// Proposed Service Structure
services/
frenchWine/
inaoAOC.js // INAO AOC/AOP dataset scraper
openWinesCepages.js // Grape varieties data
bordeauxWines.js // IEEE Bordeaux dataset
euAgridata.js // EU statistics
francePairings.js // Mets & Vins pairing data
```
### Data Update Frequency
- **INAO**: Quarterly updates (appellation changes are infrequent)
- **OpenWines**: Annual updates (grape variety cultivation data)
- **EU Portal**: Annual production statistics
- **FranceAgriMer**: Monthly/quarterly reports
### Caching Strategy
- **Static data** (appellations, regions): Cache for 90 days
- **Production statistics**: Cache for 30 days
- **Price/market data**: Cache for 7 days
- **Pairing data**: Cache for 180 days (rarely changes)
---
## License Compliance
### Compatible Open Licenses Found
✅ **Licence Ouverte / Open Licence** (INAO)
✅ **PDDL (Public Domain Dedication and License)** (OpenWines)
✅ **ODbL (Open Database License)** (Mets & Vins)
✅ **Open Access** (IEEE DataPort - registration required)
✅ **EU Open Data** (Agri-food Portal)
All identified sources are compatible with commercial use in the Wine Tracker application.
---
## Data Quality Notes
### Strengths
- **Official government sources** (INAO, FranceAgriMer)
- **Academic validation** (IEEE, university research)
- **Regular updates** from authoritative bodies
- **Comprehensive coverage** of French wine regions
### Limitations
- **Price data limited**: Most datasets focus on classification, not current retail prices
- **Translation needed**: Many sources are French-language only
- **Historical focus**: Some datasets emphasize production statistics over consumer pricing
- **Fragmented data**: No single source covers all wine attributes
### Recommended Approach
Combine multiple sources:
1. **INAO** for appellation/region data
2. **OpenWines** for grape variety information
3. **Current scrapers** (Vivino, Total Wine) for real-time pricing
4. **EU Portal** for production context and market trends
---
## Next Steps
1. ✅ Research and identify data sources (COMPLETED)
2. ⏳ Implement INAO AOC/AOP scraper
3. ⏳ Implement OpenWines grape variety scraper
4. ⏳ Create French wine aggregator service
5. ⏳ Integrate with existing wine aggregator
6. ⏳ Add UI filters for French appellations
7. ⏳ Test with real French wine searches
---
## Contact & Resources
### Official Contacts
- **INAO**: https://www.inao.gouv.fr/
- **FranceAgriMer**: https://www.franceagrimer.fr/
- **data.gouv.fr**: https://www.data.gouv.fr/
### Community Resources
- **OpenWines GitHub**: https://github.com/OpenWines
- **Wine Industry Data**: https://www.winestats.info/
---
*Document compiled: November 2025*
*For: Red Thunder Wine Tracker - French Wine Integration*