Scope by Vehicle Category
Leboncoin stores passenger cars (Voitures) and light commercial utility vehicles (Utilitaires). Category filtering is maintained explicitly.
France / Structured Dataset Collection
Explore the existing Leboncoin automotive database collection covering 750,000+ French vehicle classifieds across all 96 metropolitan departments, with EUR asking prices, Crit'Air tags, and pro dealer networks.
Complete database schema
Every export cut contains standardized field names, explicit SQL types, and consistent formatting. Missing values in optional columns remain explicit NULLs.
| Column Name | Data Type | Description | Sample Value |
|---|---|---|---|
listing_id | VARCHAR(32) | Leboncoin listing ID | lbc_2481920491 |
category | VARCHAR(32) | Vehicle category (Voitures, Utilitaires) | Voitures |
make | VARCHAR(64) | Manufacturer brand | Renault |
model | VARCHAR(64) | Model line | Clio |
year | SMALLINT | Model year of production | 2021 |
price_eur | NUMERIC(10,2) | Advertised asking price in EUR | 14200.00 |
mileage_km | INTEGER | Odometer in kilometres | 39500 |
fuel_type | VARCHAR(32) | Fuel (Essence, Diesel, Hybride, Électrique) | Essence |
gearbox | VARCHAR(32) | Transmission (Manuelle, Automatique) | Manuelle |
body_type | VARCHAR(48) | Berline, Break, SUV, Citadine | Berline |
crit_air | SMALLINT | French Crit'Air environmental air quality vignette (1-5) | 1 |
seller_type | VARCHAR(16) | Pro (Dealer) or Particulier (Private) | Pro |
city | VARCHAR(64) | City location | Lyon |
department | VARCHAR(32) | French Department name or number | Rhône (69) |
zip | VARCHAR(8) | French 5-digit postal code | 69003 |
first_seen_at | TIMESTAMP | First observed timestamp (UTC) | 2026-09-12 15:00:00 |
last_seen_at | TIMESTAMP | Last verified timestamp (UTC) | 2026-10-17 20:30:00 |
status | VARCHAR(16) | Active or removed status | active |
Sample record payload
Inspect the exact structure of a representative listing from the Leboncoin collection.
{
"listing_id": "lbc_2481920491",
"category": "Voitures",
"make": "Renault",
"model": "Clio",
"year": 2021,
"mileage_km": 39500,
"asking_price_eur": 14200,
"fuel_type": "Essence",
"gearbox": "Manuelle",
"body_type": "Berline",
"crit_air": 1,
"seller": {
"type": "Pro",
"city": "Lyon",
"department": "Rh\u00f4ne (69)",
"zip": "69003"
},
"first_observed_at": "2026-09-12T15:00:00Z",
"last_seen_at": "2026-10-17T20:30:00Z",
"status": "active"
}Source methodology & context
Leboncoin stores passenger cars (Voitures) and light commercial utility vehicles (Utilitaires). Category filtering is maintained explicitly.
Includes the official French Crit'Air badge level (1 through 5, or electric), critical for Low Emission Zone (ZFE) access compliance analysis.
Geocoded across all 96 metropolitan French departments and overseas territories with standardized 5-digit INSEE postal codes.
Available delivery formats
Columnar storage compressed with Zstandard / Snappy. Optimal for DuckDB, Polars, PySpark, Snowflake, and BigQuery data warehousing.
Self-contained, serverless relational database with pre-built indexes on listing IDs, VINs, makes, models, and timestamps.
UTF-8 formatted flat comma-separated files with standard header rows, compatible with any spreadsheet tool or custom ETL loader.
Frequently asked questions
Yes. Records distinguish between professional automotive dealerships ("Pro") and private individual sellers ("Particulier").
Yes, light commercial vans and utility vehicles can be included or isolated based on your requirements.
Prices are captured in native Euros (EUR) as published on the listing at time of observation.
Before you order
Include in your request: desired vehicle make/model scope, geographic filter (states/regions), active or historical scope, preferred file format (Parquet, SQLite, CSV), and delivery method.
We will provide a representative validation sample and exact row count before payment. All deliveries include checksum validation files.