The Relational Foundation of
World-Class Fine Vintages
Eliminating synthetic estimates and mathematical impossibilities. Explore verified cuvees, strict
third-normal form (3NF) schemas, database-level varietal blend sum triggers (SUM ≤ 100%),
and secondary auction valuations enforced by our ≥ 3 Observations Rule.
Sommelier Vintage Portal
Search real-time denormalized vintage tables, filter by appellation and varietal composition, or inspect secondary auction valuations.
| Vintage ID | Producer | Cuvee Name | Year | ABV % | Format (ml) | Release Price | Valuation Index (3+ Obs) | Provenance |
|---|
| Vintage ID | Producer | Cuvee Name | Year | Grape Variety | Composition % | Blend Sum Check |
|---|
| Vintage ID | Producer | Cuvee Name | Year | Organoleptic Descriptor | Category |
|---|
Precision Varietal Composition
Visualizing exact technical sheet percentages and database triggers that prevent over-100% mathematical errors.
Insignia 2019
- Cabernet Sauvignon (92.0%)
- Merlot (6.0%)
- Petit Verdot (2.0%)
Monte Bello 2019
- Cabernet Sauvignon (77.0%)
- Merlot (14.0%)
- Petit Verdot (9.0%)
Opus One 2019
- Cab. Sauvignon (78%) • Merlot (8%)
- Petit Verdot (6%) • Cab. Franc (6%) • Malbec (2%)
Relational 3NF Architecture
How WineDB separates producer metadata from vintage expressions and enforces strict schema constraints.
Third-Normal Form (3NF)
Flat spreadsheets repeat producer foundation years and appellation details thousands of times. WineDB normalizes entities into wineries, wines, vintages, blends, and tasting_profiles linked by strict foreign keys.
Controlled VIVC Ampelography
Grape varietal names are automatically normalized against VIVC ampelographic registries during ingestion, mapping synonyms (e.g., Shiraz → Syrah, Cannonau → Grenache) to canonical keys.
Verified Data Guarantees
Strict mathematical check constraints, primary audit registries, and valuation rules enforced at the database layer.
Blend Sum Check Trigger
Database trigger trg_check_blend_sum_insert fires on every INSERT or UPDATE to blends. If the cumulative sum across varieties for a vintage exceeds 100.001%, SQLite raises an immediate ABORT.
Valuation Rule (≥ 3 Observations)
Secondary market indexes are calculated strictly from public auction hammer prices. If fewer than 3 independent lots are observed within 18 months, the index remains NULL to prevent speculative bias.
Primary Source Audit Registry
Every single cuvee and vintage record links directly to our master data_sources table with exact URLs pointing to US TTB COLA label filings, SAQ/LCBO laboratory sheets, and estate technical notes.
Quantitative Laboratory Chemistry
Instead of subjective sommelier descriptors alone, WineDB records precise laboratory chemistry: exact residual_sugar_g_l, titratable_acidity_g_l, ph_level, and bottle format volume dimensions (`750ml`, `1500ml`).
Commercial & Open Data Tiers
Start with our free preview sample, or unlock the full 3,675-vintage relational database with complete chemistry, secondary market benchmarks, and master audit logs.
Free Preview Sample
Evaluate an 11-column sample of the vintages schema and test integration before purchasing.
- ✓ 59 verified sample vintages across 6 relational tables
- ✓ Full schema with chemistry & audit columns
- ✓ Preview
winedb.sqliterelational database - ✓ Open VIVC ampelographic & appellation taxonomies
- ✓ Creative Commons Attribution 4.0 license
Full Dataset Snapshot
The complete, production-ready fine wine relational dataset for enterprises and analysts.
- ✓ 3,675 verified fine wine vintages across 143 iconic cuvees
- ✓ 106 prestige wineries & 57 global appellations
- ✓ SAQ/LCBO Laboratory Chemistry (residual sugar & acidity)
- ✓ Liv-ex & Auction Benchmarks with ≥3 observations rule
- ✓ US TTB COLA Registry verified label IDs & OCR extracts
- ✓ Master 3,746-row provenance registry (
data_sources.csv) - ✓ Complete 3NF
winedb.sqlite+ all 7 CSV exports - ✓ Current edition (2026.09) & commercial rights
Custom work (subsets, extraction pipelines, schema mapping): from $99 — contact the desk
Enterprise Custom Scope Form
Need bespoke estate history, custom Apify scrapers, or live REST API webhooks? Submit your extraction specs right here or email us at winedb@dataengineered.io.