About This Project

The story behind Autoen

The idea of this project started years ago after the SNCA made the registrations public via data.public.lu. Initially I just wanted to know how often my car's model was registered in Luxembourg so I imported the XML files into a local database and ran multiple SQL queries, just for fun.

Over the years, friends asked me similar questions and to avoid having to manually restart the project and manually run SQL queries I decided to publish the project online and make it available to everybody. It was also the ideal project to test OpenAI's latest codex release. Yes, everything here was "Vibe coded". Sue me! :P

Author

Filipe DA COSTA, Senior Developer at Apart Design Studio

Data

All the data is sourced from the "Société Nationale de Circulation Automobile", Luxembourg's official vehicle registration entity and processed into static JSON files used to fuel this project.

The quality of the data is in a very bad shape. Not only do we have duplicates, like two Seat brands, but there are also a lot of models that should be variants (ex: Golf, Golf GTI, 118i, 118d, ...). We have some fixes in place to clean some models (ex: Polo) but we may remove them in the future, just to make the incoherence visible.

The data is updated automatically. A scheduled task checks data.public.lu for new XML snapshots and, when one is available, downloads it, imports it into a local database and generates the static JSON files used by this website. The generated files are then committed and pushed to the project repository, which triggers an automatic deployment on Vercel.

Notable mention

Parc Automobile du Luxembourg: https://data.public.lu/en/datasets/parc-automobile-du-luxembourg/

Brand logos by filippofilip95