OBSERVED REMOVALS
Delisting Timestamps
Every advert is monitored on automated verification loops. Disappearances are recorded as delisted_at within 24–48 hours of removal.
Poland / Structured Dataset Collection
Complete Polish automotive marketplace dataset collection from Otomoto.pl. Spans 350,000+ active listings with native PLN asking prices, dealer attributes, engine specifications, and voivodeship geocoding across Poland.
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 Otomoto 50k listings remotely via HTTPS (Zero local disk required)
hf_parquet = "https://huggingface.co/datasets/KTHESAT/otomoto-poland-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/otomoto-poland-50k-sample/*.parquet")
WHERE price > 0
ORDER BY first_registration_year DESC
LIMIT 5
''').df()
print(df)| Make & Model | Year | Price (PLN) | Mileage | Fuel | Voivodeship |
|---|---|---|---|---|---|
| Skoda Octavia 2.0 TDI Style DSG | 2023 | 119,000 PLN | 32,000 km | Diesel | Mazowieckie |
| Toyota Corolla 1.8 Hybrid Comfort | 2024 | 108,500 PLN | 12,400 km | Hybrid | Malopolskie |
| Volkswagen Passat Variant Elegance | 2022 | 129,900 PLN | 54,000 km | Diesel | Wielkopolskie |
| Kia Sportage 1.6 T-GDI Business Line | 2023 | 124,000 PLN | 22,800 km | Gasoline | Dolnoslaskie |
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) | Otomoto unique advert identifier | oto_61294821 |
make | VARCHAR(64) | Vehicle brand | Skoda |
model | VARCHAR(64) | Model line | Octavia |
generation | VARCHAR(32) | Model generation (e.g. IV) | IV (2020-) |
year | SMALLINT | Production year | 2021 |
price_pln | NUMERIC(12,2) | Asking price in Polish Złoty (PLN) | 84500.00 |
price_eur | NUMERIC(10,2) | EUR converted equivalent | 19650.00 |
mileage_km | INTEGER | Odometer in kilometres | 67000 |
fuel_type | VARCHAR(32) | Fuel classification (Benzyna, Diesel, Hybryda) | Benzyna |
engine_capacity_cm3 | INTEGER | Displacement in cubic centimetres | 1498 |
voivodeship | VARCHAR(64) | Polish administrative region (Województwo) | Mazowieckie |
city | VARCHAR(64) | Seller town or city | Warszawa |
first_seen_at | TIMESTAMP | First observed timestamp (UTC) | 2026-08-20 08:10:00 |
last_seen_at | TIMESTAMP | Last observed active timestamp (UTC) | 2026-10-17 19:15:00 |
status | VARCHAR(16) | Current status | active |
Sample active record payload
Inspect the exact structure of a representative active listing from the Otomoto collection.
{
"listing_id": "oto_61294821",
"make": "Skoda",
"model": "Octavia",
"generation": "IV",
"year": 2021,
"price_pln": 84500,
"price_eur": 19650,
"mileage_km": 67000,
"fuel_type": "Benzyna",
"voivodeship": "Mazowieckie",
"city": "Warszawa",
"status": "active"
}Historical delisted archive
In addition to active vehicle inventory snapshots, our Otomoto collection includes comprehensive historical delisted archives. Track listing duration, asking price reductions, and removal timestamps across Poland.
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": "oto_60918241",
"source": "Otomoto",
"make": "Skoda",
"model": "Octavia Combi",
"year": 2021,
"initial_asking_price_pln": 89900,
"final_asking_price_pln": 84500,
"price_changes_count": 2,
"first_observed_at": "2026-08-20T08:10:00Z",
"delisted_at": "2026-10-10T12:00:00Z",
"observed_days_on_market": 51,
"voivodeship": "Mazowieckie",
"last_known_status": "delisted"
}SELECT make, model, year, initial_asking_price, final_asking_price, observed_days_on_market, delisted_at FROM "otomoto-dataset_delisted.parquet" WHERE observed_days_on_market <= 30;Source methodology & context
Original Złoty pricing recorded directly from Polish sellers.
Complete regional classification across all 16 Polish voivodeships.
180,000+ delisted Polish listings with price cut history.
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. The primary field is native PLN, and a standardized EUR conversion is computed with exchange rate timestamps.
Yes. Professional dealer adverts include trading names and postal addresses.
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.