OBSERVED REMOVALS
Delisting Timestamps
Every advert is monitored on automated verification loops. Disappearances are recorded as delisted_at within 24β48 hours of removal.
Pan-Europe / Structured Dataset Collection
Standardized cross-border automotive dataset collection covering Germany, Netherlands, Spain, Italy, Belgium, France, and Austria. Includes 2,000,000+ active listings and comprehensive delisted turnover archives with uniform price handling.
Community sandbox & live test slice
Evaluate real data structures, field population rates, and pricing distributions directly in your browser or through remote SQL pipelines without contacting sales or downloading gigabytes.
π Hosted on Hugging Face & Kaggle git-LFS stores. Repositories are strictly immutable and protected against tampering.
import duckdb
# Query AutoScout24 50k listings remotely via HTTPS (Zero local disk required)
hf_parquet = "https://huggingface.co/datasets/KTHESAT/european-used-cars-100k-sample/*.parquet"
con = duckdb.connect()
# Instant SQL aggregations over HTTP range requests
df = con.sql(f'''
SELECT make, model, first_registration_year, price, mileage
FROM read_parquet("https://huggingface.co/datasets/KTHESAT/european-used-cars-100k-sample/*.parquet")
WHERE price > 0
ORDER BY first_registration_year DESC
LIMIT 5
''').df()
print(df)| Make & Model | Year | Price (EUR) | Mileage | Fuel | Country |
|---|---|---|---|---|---|
| Mercedes-Benz C 220 d AMG Line | 2023 | β¬46,800 | 24,000 km | Diesel | Belgium |
| Volkswagen Golf 2.0 TDI Life | 2022 | β¬22,900 | 41,200 km | Diesel | Italy |
| BMW 118i M Sport Shadow | 2023 | β¬28,400 | 18,900 km | Gasoline | Austria |
| Volvo XC40 Recharge Plus | 2023 | β¬39,900 | 15,400 km | Electric | Netherlands |
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) | AutoScout24 canonical listing identifier | as24_9812401 |
country | CHAR(2) | Listing origin market (DE, NL, ES, IT, BE, FR, AT) | DE |
make | VARCHAR(64) | Vehicle manufacturer | BMW |
model | VARCHAR(64) | Model range | 320 |
trim | VARCHAR(128) | Trim description | Touring M Sport xDrive |
year | SMALLINT | Registration year | 2020 |
price_eur | NUMERIC(10,2) | Advertised asking price normalized to EUR | 24990.00 |
mileage_km | INTEGER | Odometer reading in kilometres | 58400 |
fuel_type | VARCHAR(32) | Standardized fuel type (Diesel, Petrol, Hybrid, Electric) | Diesel |
transmission | VARCHAR(32) | Transmission (Automatic, Manual) | Automatic |
dealer_country | VARCHAR(32) | Dealership registered country | Germany |
first_seen_at | TIMESTAMP | First observed timestamp (UTC) | 2026-07-28 11:15:00 |
last_seen_at | TIMESTAMP | Last observed active timestamp (UTC) | 2026-10-17 19:00:00 |
status | VARCHAR(16) | Status (active or delisted) | active |
Sample active record payload
Inspect the exact structure of a representative active listing from the AutoScout24 collection.
{
"listing_id": "as24_9812401",
"country": "DE",
"make": "BMW",
"model": "320",
"trim": "Touring M Sport",
"year": 2020,
"price_eur": 24990,
"mileage_km": 58400,
"fuel_type": "Diesel",
"transmission": "Automatic",
"dealer_country": "Germany",
"first_seen_at": "2026-07-28T11:15:00Z",
"last_seen_at": "2026-10-17T19:00:00Z",
"status": "active"
}Historical delisted archive
In addition to active vehicle inventory snapshots, our AutoScout24 collection includes comprehensive historical delisted archives. Track listing duration, asking price reductions, and removal timestamps across Pan-Europe.
OBSERVED REMOVALS
Every advert is monitored on automated verification loops. Disappearances are recorded as delisted_at within 24β48 hours of removal.
PRICE REVISIONS
Compare initial advertised price against final asking price, revision counters, and gross discounts prior to listing removal.
DAYS ON MARKET
Analyze median observed days on market by make, model, year, and price bracket to measure liquidity across dealer and private inventory.
{
"listing_id": "as24_9720194",
"source": "AutoScout24",
"country": "DE",
"make": "BMW",
"model": "320d Touring",
"year": 2020,
"initial_asking_price_eur": 26900,
"final_asking_price_eur": 24990,
"price_changes_count": 1,
"first_observed_at": "2026-07-28T11:15:00Z",
"delisted_at": "2026-10-05T14:30:00Z",
"observed_days_on_market": 69,
"dealer_country": "Germany",
"last_known_status": "delisted"
}SELECT make, model, year, initial_asking_price, final_asking_price, observed_days_on_market, delisted_at FROM "autoscout24-dataset_delisted.parquet" WHERE observed_days_on_market <= 30;Source methodology & context
Consistent schema across DE, NL, ES, IT, BE, FR, and AT.
All national markets normalized to EUR for seamless cross-border analysis.
Includes 850k+ historical removed listings with turnover velocity.
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. You can request a single-market export (e.g. Italy only or Spain only) or the complete 7-country lake.
Yes. Complete snapshot cuts include observed delisting timestamps and days on market.
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.