OBSERVED REMOVALS
Delisting Timestamps
Every advert is monitored on automated verification loops. Disappearances are recorded as delisted_at within 24–48 hours of removal.
Germany / Structured Dataset Collection
Complete German automotive marketplace dataset collection from Mobile.de. Spans 1,400,000+ active dealer listings and over 600,000 observed historical delistings with verified EUR prices, VAT deductibility tags, and dealer location codes.
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 Mobile.de 50k listings remotely via HTTPS (Zero local disk required)
hf_parquet = "https://huggingface.co/datasets/KTHESAT/mobilede-germany-50k-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/mobilede-germany-50k-sample/*.parquet")
WHERE price > 0
ORDER BY first_registration_year DESC
LIMIT 5
''').df()
print(df)| Make & Model | Year | Price (EUR) | Mileage | Fuel | City |
|---|---|---|---|---|---|
| Porsche 911 GT3 (992) | 2024 | €218,500 | 4,200 km | Gasoline | Stuttgart |
| BMW M3 Competition M xDrive | 2023 | €89,900 | 18,500 km | Gasoline | Munich |
| Audi RS6 Avant performance | 2023 | €124,000 | 22,100 km | Mild Hybrid | Ingolstadt |
| Mercedes-Benz G 63 AMG | 2022 | €179,000 | 31,400 km | Gasoline | Frankfurt |
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) | Mobile.de canonical advert identifier | mobile_381920194 |
make | VARCHAR(64) | Manufacturer brand name | Volkswagen |
model | VARCHAR(64) | Vehicle model line | Golf |
version | VARCHAR(128) | Model variant and trim package | VIII GTI Clubsport 300PS |
first_registration | VARCHAR(10) | Month and year of first registration (MM/YYYY) | 06/2021 |
price_eur | NUMERIC(10,2) | Advertised dealer asking price in EUR | 32900.00 |
vat_deductible | BOOLEAN | Whether VAT is deductible for commercial buyers (MwSt. ausweisbar) | true |
mileage_km | INTEGER | Odometer reading in kilometres | 42500 |
fuel_type | VARCHAR(32) | Fuel type (Benzin, Diesel, Elektro, Hybrid) | Benzin |
power_kw | INTEGER | Engine power output in kilowatts | 221 |
power_hp | INTEGER | Engine power output in horsepower | 300 |
transmission | VARCHAR(32) | Transmission type (Automatik, Schaltgetriebe) | Automatik |
category | VARCHAR(48) | Vehicle category (Limousine, Kombi, SUV/Geländewagen) | Limousine |
dealer_name | VARCHAR(128) | Selling dealership business name | Autohaus Schmidt GmbH |
postal_code | VARCHAR(10) | 5-digit German postal code (PLZ) | 60311 |
city | VARCHAR(64) | Dealership city location | Frankfurt am Main |
first_seen_at | TIMESTAMP | First observed crawl timestamp (UTC) | 2026-08-14 09:20:00 |
last_seen_at | TIMESTAMP | Last verified active timestamp (UTC) | 2026-10-17 18:30:00 |
status | VARCHAR(16) | Listing status (active or delisted) | active |
Sample active record payload
Inspect the exact structure of a representative active listing from the Mobile.de collection.
{
"listing_id": "mobile_381920194",
"make": "Volkswagen",
"model": "Golf",
"version": "VIII GTI Clubsport",
"first_registration": "06/2021",
"price_eur": 32900,
"vat_deductible": true,
"mileage_km": 42500,
"fuel_type": "Benzin",
"power_hp": 300,
"transmission": "Automatik",
"dealer_name": "Autohaus Schmidt GmbH",
"city": "Frankfurt am Main",
"postal_code": "60311",
"first_seen_at": "2026-08-14T09:20:00Z",
"last_seen_at": "2026-10-17T18:30:00Z",
"status": "active"
}Historical delisted archive
In addition to active vehicle inventory snapshots, our Mobile.de collection includes comprehensive historical delisted archives. Track listing duration, asking price reductions, and removal timestamps across Germany.
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": "mobile_380129481",
"source": "Mobile.de",
"make": "Volkswagen",
"model": "Golf GTI",
"year": 2021,
"initial_asking_price_eur": 34900,
"final_asking_price_eur": 32900,
"price_changes_count": 2,
"vat_deductible": true,
"first_observed_at": "2026-08-14T09:20:00Z",
"delisted_at": "2026-10-12T16:45:00Z",
"observed_days_on_market": 59,
"postal_code": "60311",
"city": "Frankfurt am Main",
"last_known_status": "delisted"
}SELECT make, model, year, initial_asking_price, final_asking_price, observed_days_on_market, delisted_at FROM "mobilede-dataset_delisted.parquet" WHERE observed_days_on_market <= 30;Source methodology & context
Over 1.4M active German dealer and private adverts, refreshed daily.
Explicit MwSt. deductible boolean field on wholesale fleet listings.
Track price reductions, days to delist, and 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. In addition to active snapshots, our Mobile.de archive includes over 600,000 observed removed listings tracking days on market and price drops.
Yes. The vat_deductible boolean explicitly denotes listings with reclaimable VAT.
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.