OBSERVED REMOVALS
Delisting Timestamps
Every advert is monitored on automated verification loops. Disappearances are recorded as delisted_at within 24β48 hours of removal.
Switzerland / Structured Dataset Collection
Swiss domestic automotive marketplace dataset collection from Autolina.ch. Spans 90,000+ active listings with native Swiss Franc (CHF) asking prices, canton geolocation, dealer network details, and historical delisted archives.
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 Autolina 50k listings remotely via HTTPS (Zero local disk required)
hf_parquet = "https://huggingface.co/datasets/KTHESAT/autolina-swiss-25k-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/autolina-swiss-25k-sample/*.parquet")
WHERE price > 0
ORDER BY first_registration_year DESC
LIMIT 5
''').df()
print(df)| Make & Model | Year | Price (CHF) | Mileage | Fuel | Canton |
|---|---|---|---|---|---|
| Subaru Outback 2.5i AWD Luxury | 2023 | 38,900 CHF | 19,800 km | Gasoline | Zurich |
| Audi Q5 40 TDI quattro S Line | 2023 | 54,800 CHF | 22,400 km | Diesel | Bern |
| Volkswagen Tiguan 2.0 TDI R-Line | 2022 | 41,500 CHF | 34,100 km | Diesel | Basel |
| Volvo XC60 B5 AWD Plus Dark | 2023 | 52,900 CHF | 18,200 km | Mild Hybrid | Geneva |
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) | Autolina listing identifier | lina_440192 |
make | VARCHAR(64) | Brand name | Porsche |
model | VARCHAR(64) | Model designation | Macan |
year | SMALLINT | Registration year | 2022 |
price_chf | NUMERIC(10,2) | Asking price in Swiss Francs (CHF) | 76500.00 |
mileage_km | INTEGER | Odometer reading in kilometres | 34000 |
fuel_type | VARCHAR(32) | Fuel type (Benzin, Diesel, Hybrid, Elektro) | Benzin |
transmission | VARCHAR(32) | Gearbox | Automat |
canton | CHAR(2) | Swiss 2-letter Canton code (ZH, BE, GE, etc.) | ZH |
dealer_name | VARCHAR(128) | Swiss dealership name | Porsche Zentrum ZΓΌrich |
first_seen_at | TIMESTAMP | First observed timestamp (UTC) | 2026-08-01 10:00:00 |
last_seen_at | TIMESTAMP | Last observed active timestamp (UTC) | 2026-10-17 19:20:00 |
status | VARCHAR(16) | Status (active or delisted) | active |
Sample active record payload
Inspect the exact structure of a representative active listing from the Autolina collection.
{
"listing_id": "lina_440192",
"make": "Porsche",
"model": "Macan",
"year": 2022,
"price_chf": 76500,
"mileage_km": 34000,
"fuel_type": "Benzin",
"canton": "ZH",
"dealer_name": "Porsche Zentrum Z\u00fcrich",
"status": "active"
}Historical delisted archive
In addition to active vehicle inventory snapshots, our Autolina collection includes comprehensive historical delisted archives. Track listing duration, asking price reductions, and removal timestamps across Switzerland.
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": "lina_438012",
"source": "Autolina",
"make": "Porsche",
"model": "Macan GTS",
"year": 2022,
"initial_asking_price_chf": 79900,
"final_asking_price_chf": 76500,
"price_changes_count": 1,
"first_observed_at": "2026-08-01T10:00:00Z",
"delisted_at": "2026-10-08T17:20:00Z",
"observed_days_on_market": 68,
"canton": "ZH",
"last_known_status": "delisted"
}SELECT make, model, year, initial_asking_price, final_asking_price, observed_days_on_market, delisted_at FROM "autolina-dataset_delisted.parquet" WHERE observed_days_on_market <= 30;Source methodology & context
Original Swiss Franc pricing without foreign currency skew.
Enriched with official 2-letter Swiss cantonal codes.
45,000+ delisted Swiss records for residual value studies.
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. Stored prices reflect native Swiss Francs (CHF).
Yes. Complete snapshot cuts include first_seen_at, delisted_at, and observed_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.