NAP & APK Inspection Markers
Dutch vehicle listings feature Nationale Auto Pas (NAP) odometer verification status and mandatory APK inspection validity dates.
Netherlands / Structured Dataset Collection
Enquire about the structured Marktplaats automotive dataset capturing 280,000+ active Dutch vehicle listings with EUR asking prices, APK validity tags, NAP odometer records, and dealer locations across all 12 Dutch provinces.
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 |
|---|---|---|---|
advert_id | VARCHAR(32) | Marktplaats advert ID | mp_m2019283741 |
make | VARCHAR(64) | Vehicle brand | Volvo |
model | VARCHAR(64) | Vehicle model | XC40 |
year | SMALLINT | Registration year | 2021 |
price_eur | NUMERIC(10,2) | EUR advertised asking price | 32500.00 |
mileage_km | INTEGER | Odometer reading in kilometres | 49200 |
fuel_type | VARCHAR(32) | Fuel type (Benzine, Diesel, Hybride, Elektrisch) | Hybride |
transmission | VARCHAR(32) | Gearbox (Automaat, Handgeschakeld) | Automaat |
body_type | VARCHAR(48) | SUV, Stationwagon, Hatchback, Sedan | SUV |
apk_valid_until | DATE | Algemene Periodieke Keuring (APK) expiry date | 2027-05-15 |
nap_check | BOOLEAN | Nationale Auto Pas verified odometer tag | true |
seller_type | VARCHAR(32) | Autobedrijf (Dealer) or Particulier (Private) | Autobedrijf |
city | VARCHAR(64) | Dealership city | Utrecht |
postal_code | VARCHAR(8) | Dutch 4-digit postal code | 3543 |
province | VARCHAR(32) | Dutch province | Utrecht |
first_seen_at | TIMESTAMP | First observed timestamp (UTC) | 2026-09-15 11:45:00 |
last_seen_at | TIMESTAMP | Last verified active timestamp (UTC) | 2026-10-17 18:20:00 |
status | VARCHAR(16) | Active or removed status | active |
Sample record payload
Inspect the exact structure of a representative listing from the Marktplaats collection.
{
"advert_id": "mp_m2019283741",
"make": "Volvo",
"model": "XC40",
"year": 2021,
"mileage_km": 49200,
"asking_price_eur": 32500,
"fuel_type": "Hybride",
"transmission": "Automaat",
"body_type": "SUV",
"nap_check": true,
"seller": {
"type": "Autobedrijf",
"city": "Utrecht",
"postal_code": "3543",
"province": "Utrecht"
},
"first_observed_at": "2026-09-15T11:45:00Z",
"last_seen_at": "2026-10-17T18:20:00Z",
"status": "active"
}Source methodology & context
Dutch vehicle listings feature Nationale Auto Pas (NAP) odometer verification status and mandatory APK inspection validity dates.
Prices reflect Dutch EUR retail market asking prices, which incorporate Netherlands BPM and BTW tax structures.
Every dealer listing contains standardized 4-digit Dutch postal codes for spatial analysis across North Holland, South Holland, Utrecht, and regional provinces.
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 collection identifies professional dealerships (Autobedrijven) and private sellers (Particulieren) with separate tags.
Where Dutch dealers publish the registration plate on the advert, it is captured in the raw listing attributes.
Parquet, SQLite 3, and CSV are all supported with full UTF-8 character encoding for Dutch diacritics.
The collection daemon refreshes active classifieds on a continuous 24-48 hour rotation.
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.