The latest articles on DEV Community by pkwliste (@pkwliste). https://dev.to/pkwliste https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F3851378%2F1733b929-c63b-41b6-add5-12d47c44898c.png https://dev.to/pkwliste en pkwliste Mon, 30 Mar 2026 11:35:31 +0000 https://dev.to/pkwliste/hsn-tsn-vehicle-database-sql-csv-xlsx-for-developers-20h6 https://dev.to/pkwliste/hsn-tsn-vehicle-database-sql-csv-xlsx-for-developers-20h6 <h1> HSN TSN Vehicle Database (SQL, CSV, XLSX) </h1> <p>I created a HSN TSN vehicle database for developers, shops and automotive projects.</p> <p>The database contains structured vehicle data based on HSN (manufacturer code) and TSN (type code).</p> <h2> Features </h2> <ul> <li>35,000+ vehicles</li> <li>80+ manufacturers</li> <li>HSN / TSN search</li> <li>SQL, CSV and XLSX format</li> <li>Easy integration</li> <li>Perfect for shop filters</li> <li>Regular updates</li> </ul> <h2> Example </h2> <p>HSN: 0603<br><br> TSN: 764 </p> <p>Result (JSON):<br> </p> <div class="highlight js-code-highlight"> <pre class="highlight ruby"><code><span class="p">{</span> <span class="s2">"fahrzeugdaten"</span><span class="p">:</span> <span class="p">[</span> <span class="p">{</span> <span class="s2">"hersteller_id"</span><span class="p">:</span> <span class="s2">"22958"</span><span class="p">,</span> <span class="s2">"hersteller_name"</span><span class="p">:</span> <span class="s2">"VW"</span><span class="p">,</span> <span class="s2">"modell_id"</span><span class="p">:</span> <span class="s2">"24613"</span><span class="p">,</span> <span class="s2">"modell_name"</span><span class="p">:</span> <span class="s2">"Golf V"</span><span class="p">,</span> <span class="s2">"fahrzeug_id"</span><span class="p">:</span> <span class="s2">"111845"</span><span class="p">,</span> <span class="s2">"fahrzeug_name"</span><span class="p">:</span> <span class="s2">"Golf GTI"</span><span class="p">,</span> <span class="s2">"fahrzeug_typ"</span><span class="p">:</span> <span class="s2">"1K"</span><span class="p">,</span> <span class="s2">"fahrzeug_form"</span><span class="p">:</span> <span class="s2">"Schrägheck"</span><span class="p">,</span> <span class="s2">"fahrzeug_eg_nummer"</span><span class="p">:</span> <span class="s2">"E1*2001/116*0242*"</span><span class="p">,</span> <span class="s2">"fahrzeug_antriebsachse"</span><span class="p">:</span> <span class="s2">"Frontantrieb"</span><span class="p">,</span> <span class="s2">"fahrzeug_achslast_va"</span><span class="p">:</span> <span class="s2">"1050"</span><span class="p">,</span> <span class="s2">"fahrzeug_achslast_ha"</span><span class="p">:</span> <span class="s2">"900"</span><span class="p">,</span> <span class="s2">"fahrzeug_zul_gesamtgewicht"</span><span class="p">:</span> <span class="s2">"1920"</span><span class="p">,</span> <span class="s2">"fahrzeug_laenge"</span><span class="p">:</span> <span class="s2">"4319"</span><span class="p">,</span> <span class="s2">"fahrzeug_breite"</span><span class="p">:</span> <span class="s2">"1759"</span><span class="p">,</span> <span class="s2">"fahrzeug_hoehe"</span><span class="p">:</span> <span class="s2">"1505"</span><span class="p">,</span> <span class="s2">"fahrzeug_stuetzlast"</span><span class="p">:</span> <span class="n">null</span><span class="p">,</span> <span class="s2">"fahrzeug_anhaengelast_gebremst"</span><span class="p">:</span> <span class="s2">"1400"</span><span class="p">,</span> <span class="s2">"fahrzeug_anhaengelast_ungebremst"</span><span class="p">:</span> <span class="s2">"710"</span><span class="p">,</span> <span class="s2">"fahrzeug_treibstoff"</span><span class="p">:</span> <span class="s2">"Benzin"</span><span class="p">,</span> <span class="s2">"fahrzeug_motor"</span><span class="p">:</span> <span class="s2">"Ottomotor"</span><span class="p">,</span> <span class="s2">"fahrzeug_motorcode"</span><span class="p">:</span> <span class="s2">"AXX, BWA, CAWB"</span><span class="p">,</span> <span class="s2">"fahrzeug_motor_oelmenge"</span><span class="p">:</span> <span class="s2">"4,6"</span><span class="p">,</span> <span class="s2">"fahrzeug_schaltgetriebecode"</span><span class="p">:</span> <span class="s2">"02Q (MQ350) 6/1"</span><span class="p">,</span> <span class="s2">"fahrzeug_schaltgetriebe_menge"</span><span class="p">:</span> <span class="s2">"2,3"</span><span class="p">,</span> <span class="s2">"fahrzeug_automatikgetriebecode"</span><span class="p">:</span> <span class="s2">"DSG 02E (DQ250) 6/1"</span><span class="p">,</span> <span class="s2">"fahrzeug_automatikgetriebe_menge"</span><span class="p">:</span> <span class="n">null</span><span class="p">,</span> <span class="s2">"fahrzeug_bremsfluessigkeits_menge"</span><span class="p">:</span> <span class="s2">"1"</span><span class="p">,</span> <span class="s2">"fahrzeug_kuehlfluessigkeits_menge"</span><span class="p">:</span> <span class="s2">"8"</span><span class="p">,</span> <span class="s2">"fahrzeug_ps"</span><span class="p">:</span> <span class="s2">"200"</span><span class="p">,</span> <span class="s2">"fahrzeug_kw"</span><span class="p">:</span> <span class="s2">"147"</span><span class="p">,</span> <span class="s2">"fahrzeug_leistung_bei_umdrehungen"</span><span class="p">:</span> <span class="s2">"6000"</span><span class="p">,</span> <span class="s2">"fahrzeug_hubraum"</span><span class="p">:</span> <span class="s2">"1984"</span><span class="p">,</span> <span class="s2">"fahrzeug_co2_emissions_wert"</span><span class="p">:</span> <span class="s2">"191"</span><span class="p">,</span> <span class="s2">"fahrzeug_leergewicht"</span><span class="p">:</span> <span class="s2">"1558"</span><span class="p">,</span> <span class="s2">"fahrzeug_max_kmh"</span><span class="p">:</span> <span class="s2">"235"</span><span class="p">,</span> <span class="s2">"fahrzeug_sitzanzahl"</span><span class="p">:</span> <span class="s2">"5"</span><span class="p">,</span> <span class="s2">"fahrzeug_tueranzahl"</span><span class="p">:</span> <span class="s2">"3"</span><span class="p">,</span> <span class="s2">"fahrzeug_prod_monat_von"</span><span class="p">:</span> <span class="s2">"09"</span><span class="p">,</span> <span class="s2">"fahrzeug_prod_monat_bis"</span><span class="p">:</span> <span class="s2">"09"</span><span class="p">,</span> <span class="s2">"fahrzeug_prod_jahr_von"</span><span class="p">:</span> <span class="s2">"2004"</span><span class="p">,</span> <span class="s2">"fahrzeug_prod_jahr_bis"</span><span class="p">:</span> <span class="s2">"2008"</span><span class="p">,</span> <span class="s2">"fahrzeug_hsn"</span><span class="p">:</span> <span class="s2">"0603"</span><span class="p">,</span> <span class="s2">"fahrzeug_tsn"</span><span class="p">:</span> <span class="s2">"764"</span><span class="p">,</span> <span class="s2">"fahrzeug_vsn"</span><span class="p">:</span> <span class="s2">"001"</span> <span class="p">}</span> <span class="p">]</span> <span class="p">}</span> </code></pre> </div> <h2> Use cases </h2> <ul> <li>Automotive shops</li> <li>Wheel configurators</li> <li>Spare parts catalogs</li> <li>Vehicle filters</li> <li>Developer projects</li> </ul> <h2> Demo &amp; Download </h2> <p>You can find more information and a demo here:</p> <p><a href="https://www.pkwliste.com/de/hsn-tsn-datenbank" rel="noopener noreferrer">https://www.pkwliste.com/de/hsn-tsn-datenbank</a></p> <h2> Integration </h2> <p>The database can be integrated into:</p> <ul> <li>PHP projects</li> <li>Web applications</li> <li>E-commerce platforms</li> <li>Local databases</li> <li>APIs</li> </ul> <h2> Formats </h2> <p>The download includes:</p> <ul> <li>SQL database</li> <li>CSV file</li> <li>XLSX file</li> </ul> database automotive sql php