Data dictionary · one row per variant, 343 documented spec fields, every value nullable
The variants table includes 343 documented spec fields from 346 physical columns — system and identity columns like id and timestamps are omitted). Coverage percentages reflect 2026-09-15.2. The %pop column is measured against the field's applicable denominator (e.g., battery capacity against BEV + PHEV, not all 43,077 variants). Some fields are populated for a small slice today and grow with each snapshot as new sources land. Per-cell provenance lives in a side-table keyed by (variant_id, field_name).
What each download carries. The full per-record document — every populated field below, each with its provenance — is delivered as JSON: the REST /v1 responses and the snapshot apex.json. The flat tabular files in the snapshot ( apex.csv, apex.sqlite, apex.parquet) are a curated extract of the most-used identity and summary columns for quick analysis — not the full schema. The bundle's schema.ts and manifest.json → schema declare the exact columns and field counts of every format.
Identity & body10 fields
| name | type | desc | applies to | % populated | sources |
|---|---|---|---|---|---|
| model_year | int · year | all variants | 100% | 3 | |
| powertrain | text | all variants | 100% | 7 | |
| variant_name | text | all variants | 100% | — | |
| body_class | text | NHTSA body-class category from VIN decode: "Sedan/Saloon", "SUV/Crossover", "Pickup", "Hatchback/Liftback/Notchback", "Convertible/Cabriolet", "Coupe", "Wagon/Estate", "Van/Minivan". Populated only fr | all variants | 94% | 12 |
| engine_name | text | all variants | 94% | — | |
| generation_id | int | Optional FK to the generation this variant belongs to. NULL until Phase 2 (Wikidata bootstrap). ON DELETE SET NULL keeps variants stable when generations are cleaned up. The generation_id is an inferr | all variants | 94% | — |
| markets | jsonb | Array of market codes where this variant is sold/registered. ISO 3166-1 alpha-2 codes (e.g. US, DE, FI, KR) plus the deliberate supranational extension 'EU', used by EEA-wide and JRC sources (eea-co2 | all variants | 93% | — |
| seats | int | Number of seats as type-approved. Sources: SVV (antall_seter), NHTSA vPIC, manufacturer press. Universal (BEV/ICE/HEV/PHEV all have seats). | all variants | 40% | 13 |
| doors | int | Number of doors as type-approved. Sources: SVV (antall_dorer), NHTSA vPIC, manufacturer press. Universal. | all variants | 25% | 7 |
| seats_max | int | Maximum seating capacity including optional/fold-down seats, as type-approved. Always >= seats (standard layout). Sources: DGT NUM_PLAZAS_MAX. Universal — no powertrain gating. Source: spain-dgt. | all variants | 6% | 2 |
Engine9 fields
| name | type | desc | applies to | % populated | sources |
|---|---|---|---|---|---|
| displacement_cc | int · cm³ | ICE+HEV+PHEV+MHEV | 93% | 37 | |
| cylinders | int | ICE+HEV+PHEV+MHEV | 71% | 22 | |
| turbocharger | bool | ICE+HEV+PHEV+MHEV | 30% | 5 | |
| engine_configuration | text | ICE+HEV+PHEV+MHEV | 12% | 5 | |
| engine_description | text | all variants | 12% | 2 | |
| fuel_system | text | ICE+HEV+PHEV+MHEV | 11% | 2 | |
| axle_ratio | numeric | Final drive (axle) ratio from EPA test-car list. Differential gear ratio between driveshaft and axle. | all variants | 4% | 1 |
| nv_ratio | numeric | N/V ratio (engine rpm per mph in top gear, EPA test-car list). Useful for computing cruise rpm at a given speed. | all variants | 4% | 1 |
| supercharger | bool | all variants | 1% | 3 |
Power & torque8 fields
| name | type | desc | applies to | % populated | sources |
|---|---|---|---|---|---|
| power_hp | int · hp | Legacy power_hp column. Typically reflects PEAK (manufacturer marketing) because most hp-reporting sources (israel-mot, *-press) use that convention — but not guaranteed. For unambiguous semantics use | all variants | 91% | 29 |
| power_kw | int · kW | Legacy power_kw column. SEMANTIC IS SOURCE-DEPENDENT — may be peak OR continuous depending on the highest-priority source. For BEV variants, check power_kw_peak vs power_kw_continuous explicitly (the | all variants | 91% | 37 |
| torque_nm | int · N·m | all variants | 86% | 23 | |
| power_kw_continuous | numeric | UNECE R85 CONTINUOUS regulatory power rating (kW): 30-minute sustained maximum. For BEVs this is the most-relevant number for sustained performance (towing, high-speed cruising). Derived from EU regul | all variants | 13% | — |
| power_rpm | int · rpm | all variants | 9% | 10 | |
| power_kw_peak | numeric | Manufacturer PEAK rated power (kW). The marketing-spec-sheet number. For BEVs, this is typically the short-burst peak motor output. For ICE this is the max-rpm peak. Derived from sources that report p | all variants | 7% | — |
| torque_rpm_low | int | all variants | 7% | 7 | |
| torque_rpm_high | int | all variants | 0.0% | 4 |
Drivetrain5 fields
| name | type | desc | applies to | % populated | sources |
|---|---|---|---|---|---|
| drive_type | text | all variants | 77% | 24 | |
| gearbox_type | text | all variants | 75% | 15 | |
| gears | int | all variants | 67% | 14 | |
| transmission_description | text | all variants | 10% | 4 | |
| transmission_features | jsonb | all variants | 0.0% | — |
Battery & motors25 fields
| name | type | desc | applies to | % populated | sources |
|---|---|---|---|---|---|
| battery_capacity_gross_kwh | numeric · kWh | BEV+PHEV | 78% | 16 | |
| battery_capacity_usable_kwh | numeric · kWh | BEV+PHEV | 39% | 6 | |
| motor_count | int | BEV+PHEV | 13% | 5 | |
| battery_chemistry | text | Cathode electrochemistry: 'NMC', 'NCA', 'LFP', 'LMFP' (manganese-rich LFP), 'LCO', 'NCM811'. New chemistries should be added as observed (no enum constraint). | BEV+PHEV | 12% | 5 |
| battery_thermal_management | text | BEV+PHEV | 8% | 1 | |
| pack_voltage_v | int · V | BEV+PHEV | 7% | 8 | |
| heat_pump | bool | BEV+PHEV | 5% | 2 | |
| battery_assembly_country | text | BEV+PHEV | 0.0% | — | |
| battery_cell_count | int | Total battery cell count: cells_per_module * modules_per_pack * packs_per_vehicle. Computed from staging.nhtsa_vpic sub-fields when all three are non-NULL. BEV, PHEV, FCEV, REEV only. Range [1, 20000] | BEV+PHEV | 0.0% | — |
| battery_cell_country | text | BEV+PHEV | 0.0% | — | |
| battery_cell_format | text | BEV+PHEV | 0.0% | — | |
| battery_cell_supplier | text | BEV+PHEV | 0.0% | — | |
| battery_product_name | text | Manufacturer marketing/architecture name for the battery pack. Examples: 'Blade' (BYD CTP LFP), 'Qilin' (CATL CTP), 'Shenxing' (CATL fast-charge LFP), 'M3P' (CATL LMFP), '4680' (Tesla cylindrical). Di | BEV+PHEV | 0.0% | — |
| battery_warranty_capacity_pct | int · % | DEPRECATED 2026-05-21 — merged into warranty_battery_capacity_pct via schema/213. Writes are auto-routed by trigger a_variants_canonicalize_fields. Column is always NULL. See field_canonical_map. | BEV+PHEV | 0.0% | — |
| battery_warranty_km | int · km | DEPRECATED 2026-05-21 — merged into warranty_battery_km via schema/213. Writes are auto-routed by trigger a_variants_canonicalize_fields. Column is always NULL. See field_canonical_map. | BEV+PHEV | 0.0% | — |
| battery_warranty_years | int · years | DEPRECATED 2026-05-21 — merged into warranty_battery_years via schema/213. Writes are auto-routed by trigger a_variants_canonicalize_fields. Column is always NULL. See field_canonical_map. | BEV+PHEV | 0.0% | — |
| battery_weight_kg | int · kg | BEV+PHEV | 0.0% | — | |
| electric_power_kw_combined | int | all variants | 0.0% | 2 | |
| electric_torque_nm_combined | int | all variants | 0.0% | 1 | |
| motor_front_power_kw | int · kW | all variants | 0.0% | 2 | |
| motor_front_torque_nm | int · N·m | all variants | 0.0% | 1 | |
| motor_front_type | text | all variants | 0.0% | 1 | |
| motor_rear_power_kw | int · kW | all variants | 0.0% | 2 | |
| motor_rear_torque_nm | int · N·m | all variants | 0.0% | 1 | |
| motor_rear_type | text | all variants | 0.0% | 1 |
Charging8 fields
| name | type | desc | applies to | % populated | sources |
|---|---|---|---|---|---|
| charging_dc_max_kw | int · kW | BEV+PHEV (port) | 53% | 10 | |
| charging_ac_max_kw | numeric · kW | BEV+PHEV (port) | 44% | 7 | |
| charging_ac_phases | int | BEV+PHEV (port) | 6% | 2 | |
| charging_ac_time_h | numeric | Full AC charge time (0→100%) in hours, as rated by the certifying authority. MIIT 慢充时间 for China-market NEVs. Precision: 0.1 h. Range: 0.5–72 h. ESG / fleet-electrification use: parking duration plann | BEV+PHEV (port) | 0.0% | — |
| charging_curve | jsonb | BEV+PHEV (port) | 0.0% | — | |
| charging_dc_10_80_min | int | BEV+PHEV (port) | 0.0% | 2 | |
| charging_dc_time_min | int | Full DC fast-charge time (0→100%) in minutes, as rated by the certifying authority. DISTINCT from charging_dc_10_80_min (partial charge). MIIT 快充时间 for China-market NEVs. Range: 10–600 min. BEV, PHEV, | BEV+PHEV (port) | 0.0% | — |
| charging_port_type | text | BEV+PHEV (port) | 0.0% | 1 |
Range15 fields
| name | type | desc | applies to | % populated | sources |
|---|---|---|---|---|---|
| range_wltp_km | int · km | BEV+PHEV (port) | 54% | 18 | |
| range_epa_mi | int · mi | BEV+PHEV (port) | 21% | 10 | |
| phev_charge_depleting_range_km | int · km | BEV+PHEV | 17% | 8 | |
| phev_charge_depleting_kwh_100km | numeric · kWh/100km | BEV+PHEV | 7% | 2 | |
| range_wltp_city_km | int · km | WLTP city-phase electric range, km. Always >= combined range_wltp_km due to regenerative braking advantage at low urban speeds. BEV and PHEV only. Source: uk-vca (OGL v3.0). | BEV+PHEV (port) | 7% | 1 |
| phev_canadian_electric_range_km | int · km | PHEV charge-depleting range from NRCan (Canadian 5-cycle, "Range 1" column). | BEV+PHEV | 6% | 1 |
| phev_charge_sustaining_l_100km | numeric · L/100km | BEV+PHEV | 6% | 2 | |
| phev_charge_sustaining_mpg_us | numeric · mpg | BEV+PHEV | 2% | 1 | |
| phev_utility_factor | numeric | BEV+PHEV | 2% | 1 | |
| phev_charge_depleting_range_mi | int · mi | BEV+PHEV | 1% | 2 | |
| range_cltc_km | int · km | BEV+PHEV (port) | 1% | 2 | |
| range_nedc_km | int · km | BEV+PHEV (port) | 1% | 3 | |
| range_canadian_km | int · km | Range from NRCan / Transport Canada (Canadian 5-cycle, BEV). For PHEV, see phev_canadian_electric_range_km. | all variants | 0.0% | 1 |
| range_jc08_km | int · km | all variants | 0.0% | — | |
| range_real_highway_km | int · km | all variants | 0.0% | — |
Emissions & fuel economy77 fields
| name | type | desc | applies to | % populated | sources |
|---|---|---|---|---|---|
| fuel_mode | text | all variants | 99% | 4 | |
| fuel_type | text | all variants | 98% | 27 | |
| frontal_area_m2 | numeric · m² | all variants | 50% | 1 | |
| co2_combined_g_km | int · g/km | ICE+HEV+PHEV+MHEV | 38% | 13 | |
| consumption_combined_l_100km | numeric · L/100km | ICE+HEV+PHEV+MHEV | 35% | 13 | |
| co2_nedc_combined_g_km | int · g/km | ICE+HEV+PHEV+MHEV | 21% | 14 | |
| consumption_city_l_100km | numeric · L/100km | ICE+HEV+PHEV+MHEV | 12% | 9 | |
| consumption_highway_l_100km | numeric · L/100km | ICE+HEV+PHEV+MHEV | 12% | 9 | |
| co2_tailpipe_g_mi | numeric · g/mi | ICE+HEV+PHEV+MHEV | 10% | 1 | |
| co2_wltp_combined_g_km | int · g/km | ICE+HEV+PHEV+MHEV | 10% | 16 | |
| epa_vehicle_class | text | all variants | 10% | 1 | |
| fuel_cost_annual_usd | int | EPA estimated annual fuel or electricity cost in USD. Based on 15,000 mi/yr and EPA test-cycle fuel economy. Source: fueleconomy.gov fuelCost08 field. | all variants | 10% | 1 |
| mpg_city_us | numeric | ICE+HEV+PHEV+MHEV | 10% | 5 | |
| mpg_combined_us | numeric | ICE+HEV+PHEV+MHEV | 10% | 9 | |
| mpg_highway_us | numeric | ICE+HEV+PHEV+MHEV | 10% | 5 | |
| consumption_wltp_combined_l_100km | numeric · L/100km | ICE+HEV+PHEV+MHEV | 9% | 6 | |
| emissions_class | text | Pollutant emissions class verbatim from regulator. EU: 'Euro 6d', 'Euro 6d-TEMP', 'Euro 6e'. China: 'China 6a', 'China 6b'. US Tier 3 / California LEV III tags also accepted. | ICE+HEV+PHEV+MHEV | 9% | 7 |
| fuel_barrels_annual | numeric | EPA estimated annual petroleum consumption in barrels (42 US gal). Populated for ICE/HEV/MHEV/PHEV only — BEV values in EPA source represent electricity equivalents, which are excluded here to avoid c | all variants | 9% | 1 |
| consumption_nedc_combined_l_100km | numeric · L/100km | ICE+HEV+PHEV+MHEV | 8% | 4 | |
| co2_real_world_g_km | int · g/km | Real-world CO2 emissions in g/km, measured on-road with a Portable Emissions Measurement System (PEMS). Source family: JRC research datasets. Distinct from co2_wltp_combined_g_km — real-world numbers | ICE+HEV+PHEV+MHEV | 6% | 2 |
| epa_fe_score | int | all variants | 6% | 1 | |
| epa_ghg_score | int | all variants | 6% | 1 | |
| fuel_consumption_real_world_l_100km | numeric · L/100km | Real-world fuel consumption in l/100 km from on-road PEMS testing. Distinct from consumption_wltp_combined_l_100km. | all variants | 6% | 2 |
| ch4_epa_g_mi | numeric · g/mi | Methane (CH4) from the US EPA FTP-family regulatory exhaust test, g/mi. GHG-relevant: CH4 has a 100-yr GWP of 27.9 (IPCC AR6). Used in PCAF Scope 3 well-to-wheel emission modelling. Source: epa-certif | all variants | 5% | 1 |
| co_epa_g_mi | numeric · g/mi | Carbon monoxide (CO) from the US EPA FTP-family regulatory exhaust test, in grams per mile. Typical Tier 3 limit: 4.2 g/mi for LDV. Source: epa-certification (staging.epa_test_car.co_g_mi). | all variants | 5% | 1 |
| co_wltp_mg_km | numeric · km | WLTP CO emissions in mg/km (CO_WLTP). EU WLTP protocol measurement. Euro 6 limit: 1000 mg/km for gasoline. ESG / air-quality accounting. ICE, HEV, PHEV only. Source: israel-mot. | all variants | 5% | 2 |
| noise_db_a | numeric · dB(A) | Drive-by noise level, dB(A), from Euro-standard pass-by noise test (UN ECE R51.03). Present for every UK type-approved vehicle. Universal — no powertrain gating. Source: uk-vca (OGL v3.0). | all variants | 5% | 4 |
| nox_epa_g_mi | numeric · g/mi | Oxides of nitrogen (NOx) from the US EPA FTP-family regulatory exhaust test, in grams per mile. Derived from the FTP-75 / 2-day / 3-day diurnal composite test procedures in the EPA Test Car List. Sour | all variants | 5% | 1 |
| thc_epa_g_mi | numeric · g/mi | Total hydrocarbons (THC) from the US EPA FTP-family regulatory exhaust test, in grams per mile. Used in NMOG+NOx combined-standard calculations (Tier 3 / LEV III). Source: epa-certification (staging.e | all variants | 5% | 1 |
| epa_aftertreatment_device | text | Exhaust aftertreatment description from EPA test row, e.g. "TWC", "GPF+TWC", "DPF+SCR", "Three-way catalyst". | all variants | 4% | 1 |
| epa_engine_code | text | Manufacturer engine code as reported on the EPA test-car row. | all variants | 4% | 1 |
| epa_test_group | text | EPA emission test group / certification family code (a.k.a. testgroup), e.g. "RASXV04.0AES". Used by EPA to identify a vehicle's certification under the Tier 3 standards. | all variants | 4% | 1 |
| epa_test_procedure | text | EPA Test Procedure description, e.g. "Federal fuel 2-day exhaust (w/can load)". | all variants | 4% | 1 |
| equivalent_test_weight_kg | int · kg | EPA "Equivalent Test Weight" (ETW) — dyno inertia bin used during certification, converted lbs → kg. Always rounded to 250 lb (~113 kg) bins. | all variants | 4% | 1 |
| hc_wltp_mg_km | numeric · km | WLTP HC (total hydrocarbons) emissions in mg/km (HC_WLTP). EU WLTP protocol measurement. Euro 6 gasoline limit: 100 mg/km. ESG / ICCT air-quality use. ICE, HEV, PHEV only. Source: israel-mot. | all variants | 4% | 2 |
| n2o_epa_g_mi | numeric · g/mi | Nitrous oxide (N2O) from the US EPA FTP-family regulatory exhaust test, g/mi. GHG-relevant: N2O has a 100-yr GWP of 273 (IPCC AR6). Typical values 0.001–0.010 g/mi for modern ICE. Source: epa-certific | all variants | 4% | 1 |
| nox_wltp_mg_km | numeric · km | WLTP NOx emissions in mg/km (NOX_WLTP). EU WLTP protocol measurement. Euro 6 diesel limit: 80 mg/km; gasoline: 60 mg/km. ESG / PCAF / ICCT use: per-km NOx for fleet air-quality and health-impact accou | all variants | 4% | 3 |
| target_coef_a_lbf | numeric | EPA dyno target road-load coefficient A (constant friction term, lbf). Used to recreate the vehicle's road load on the dyno. | all variants | 4% | 1 |
| target_coef_b_lbf_per_mph | numeric · mph | EPA dyno target road-load coefficient B (lbf per mph, viscous term). | all variants | 4% | 1 |
| target_coef_c_lbf_per_mph2 | numeric | EPA dyno target road-load coefficient C (lbf per mph^2, aero term). | all variants | 4% | 1 |
| co2_ecoinnovation_wltp_g_km | numeric · g/km | ICE+HEV+PHEV+MHEV | 3% | 3 | |
| drag_coefficient_cd | numeric | all variants | 3% | 4 | |
| pm_wltp_mg_km | numeric · km | WLTP particulate-matter (PM) mass emissions in mg/km from Euro 6 type-approval certification. Canonical for (particulates_mg_km, pm_wltp_mg_km) per schema/660. Euro 6 limit: 4.5 mg/km (direct-injectio | all variants | 3% | 2 |
| certificate_number | text | EPA certificate of conformity number, e.g. "VKMXT02.5MP3-001". | all variants | 2% | 2 |
| certification_region | text | EPA certification region: "Federal" or "California + CAA Section 177 states". | all variants | 2% | 1 |
| certification_year | int · year | Model year for which the EPA certification was issued (matches model_year for in-year certs). | all variants | 2% | 2 |
| co2_lifecycle_g_km | numeric · g/km | Full lifecycle (well-to-wheel) CO2 in g/km. Includes fuel extraction, transport, refining, and combustion. Source: australia-gvg (fuel_lifecycle_co2_g_km). Observed range 79–711 g/km. BEV excluded (GV | ICE+HEV+PHEV+MHEV | 2% | 1 |
| emission_standard_code | text | EPA Annual Cert: emission standard level under which the variant was certified — e.g. "Federal Tier 3 Bin 30", "California LEV-III SULEV30", "California ZEV". Pulled from EPA Annual Cert Test Results | all variants | 2% | 1 |
| epa_certification_level_g_mi | numeric · g/mi | Per-vehicle NOx certification threshold in g/mi — the maximum emission level this specific variant was permitted at certification. Tier 3 Bin 30 vehicles certify at ≤ 0.030 g/mi; Bin 70 at ≤ 0.070 g/m | all variants | 2% | 1 |
| epa_emission_standard | text | EPA exhaust emission standard code under which this vehicle was certified (e.g. "T3B30", "T3B70", "L3ULEV70", "B5"). Derived from the NOx emission row in the EPA Annual Certification Tests file — the | all variants | 2% | 1 |
| epa_useful_life_miles | int | EPA required durability mileage in thousands of miles (k-miles). Typical values: 120 (Tier 2 and most Tier 3 light-duty) or 150 (LEV III / CA advanced Tier 3). Determines how long the emissions-contro | all variants | 2% | 1 |
| evap_family_code | text | EPA Annual Cert: certified evaporative family code, e.g. "VKMXR0151MPG". | all variants | 2% | 1 |
| evap_standard_code | text | EPA Annual Cert: evaporative emission standard, e.g. "Federal Tier 3 Evap", "California LEV-III Zero Evap (Option 2)". | all variants | 2% | 1 |
| innovative_tech_codes | jsonb | EEA 'IT' — list of European Commission Eco-innovation codes (e.g. SAT0026, EMS0001) credited toward the manufacturer's fleet CO2 target. | all variants | 2% | 1 |
| co2_ecoinnovation_code | text | Raw eco-innovation reference code from EEA Ech field (Reg. 443/2009 Art. 12). Examples: "AP" (approved package), "AX", "715/2007*2018/1832AP". Identifies the specific eco-innovation bundle applied to | ICE+HEV+PHEV+MHEV | 1% | 1 |
| co2_ecoinnovation_nedc_g_km | numeric · g/km | ICE+HEV+PHEV+MHEV | 1% | 1 | |
| co_real_world_mg_km | int · km | Real-world CO emissions in mg/km from on-road PEMS testing. | all variants | 1% | 2 |
| consumption_jc08_combined_l_100km | numeric · L/100km | ICE+HEV+PHEV+MHEV | 1% | 1 | |
| consumption_wltp_city_l_100km | numeric · L/100km | ICE+HEV+PHEV+MHEV | 1% | 1 | |
| consumption_wltp_highway_l_100km | numeric · L/100km | ICE+HEV+PHEV+MHEV | 1% | 1 | |
| nox_real_world_mg_km | int · km | Real-world NOx emissions in mg/km from on-road PEMS testing. Not corrected for extended ambient conditions or on-road/laboratory CO2 ratio. Useful for tracking how aged-vehicle / extended-condition NO | all variants | 1% | 2 |
| co2_cltc_combined_g_km | int · g/km | ICE+HEV+PHEV+MHEV | 0.0% | — | |
| co2_wltp_weighted_g_km | int · g/km | Utility-factor weighted WLTP CO2, g/km. PHEV-only: the weighted figure blends the charge-depleting (BEV-mode) and charge-sustaining (ICE-mode) CO2 by the SAE J2841 utility factor. This is the figure t | ICE+HEV+PHEV+MHEV | 0.0% | 4 |
| consumption_cltc_combined_l_100km | numeric · L/100km | ICE+HEV+PHEV+MHEV | 0.0% | — | |
| consumption_cng_city_kg_100km | numeric | ICE+HEV+PHEV+MHEV | 0.0% | — | |
| consumption_cng_combined_kg_100km | numeric | ICE+HEV+PHEV+MHEV | 0.0% | — | |
| consumption_cng_highway_kg_100km | numeric | ICE+HEV+PHEV+MHEV | 0.0% | — | |
| consumption_e100_city_l_100km | numeric · L/100km | Brazilian flex-fuel ethanol (E100) city cycle fuel consumption in L/100km. Source: brazil-pbe. See consumption_e100_combined_l_100km for context. | ICE+HEV+PHEV+MHEV | 0.0% | 1 |
| consumption_e100_combined_l_100km | numeric · L/100km | Brazilian flex-fuel ethanol (E100 / Etanol Hidratado) combined fuel consumption in L/100km. Derived from PBE km/L (55% city + 45% highway weighting). Applies only to BR flex-fuel variants (fuel_code=F | ICE+HEV+PHEV+MHEV | 0.0% | 1 |
| consumption_e100_highway_l_100km | numeric · L/100km | Brazilian flex-fuel ethanol (E100) highway cycle fuel consumption in L/100km. Source: brazil-pbe. See consumption_e100_combined_l_100km for context. | ICE+HEV+PHEV+MHEV | 0.0% | 1 |
| fuel_capacity_cng_kg | numeric · kg | all variants | 0.0% | — | |
| fuel_capacity_cng_l | numeric | all variants | 0.0% | — | |
| fuel_capacity_l | numeric | all variants | 0.0% | 5 | |
| fuel_capacity_optional_l | numeric | all variants | 0.0% | — | |
| fuel_delivery | text | all variants | 0.0% | — | |
| fuel_type_secondary | text | all variants | 0.0% | — | |
| thc_real_world_mg_km | int · km | Real-world total hydrocarbon emissions in mg/km from on-road PEMS testing. Available only on certain JRC/TNO tests. | all variants | 0.0% | 2 |
Weight6 fields
| name | type | desc | applies to | % populated | sources |
|---|---|---|---|---|---|
| curb_weight_kg | int · kg | Vehicle mass ready-to-drive: no driver, no cargo, full tank of fuel. US/Canada convention (EPA, transport-canada-cvs). EU equivalent is mass_in_running_order_kg which ADDS 75kg for driver. Source orde | all variants | 40% | 21 |
| mass_in_running_order_kg | int · kg | EU regulatory mass per Reg (EU) 692/2008: curb weight + 75kg driver + 90% fuel tank + AdBlue/coolant where applicable. Reported by EEA + EU member-state regulators (Finland Traficom, Spain DGT, etc.). | all variants | 37% | 13 |
| gross_weight_kg | int · kg | Maximum permitted laden mass in kg (vehicle + driver + passengers + cargo + fluids, up to the regulator's certified max). Canonical of (gross_vehicle_weight_rating_kg [US GVWR], gross_weight_kg [EU te | all variants | 22% | 11 |
| weight_distribution_front_pct | int · % | Percentage of curb weight on the front axle (rear axle carries 100 - this). Source: Transport Canada CVS WDIST column, e.g. "57/43" → 57. Range 20-80. | all variants | 3% | 1 |
| gross_vehicle_weight_rating_kg | int · kg | DEPRECATED 2026-05-21 — merged into gross_weight_kg via schema/214. Writes are auto-routed by trigger a_variants_canonicalize_fields. Column is always NULL. See field_canonical_map. | all variants | 0.0% | — |
| kerb_weight_kg | int · kg | DEPRECATED 2026-05-20 — merged into curb_weight_kg via schema/176. Writes are auto-routed by trigger a_variants_canonicalize_fields. Column is always NULL. See field_canonical_map. | all variants | 0.0% | — |
Dimensions9 fields
| name | type | desc | applies to | % populated | sources |
|---|---|---|---|---|---|
| width_mm | int · mm | all variants | 59% | 22 | |
| length_mm | int · mm | all variants | 58% | 21 | |
| height_mm | int · mm | all variants | 57% | 22 | |
| wheelbase_mm | int · mm | all variants | 52% | 21 | |
| track_front_mm | int · mm | all variants | 13% | 3 | |
| track_rear_mm | int · mm | all variants | 13% | 3 | |
| towing_braked_kg | int · kg | all variants | 5% | 6 | |
| towing_unbraked_kg | int · kg | all variants | 4% | 1 | |
| ground_clearance_mm | int · mm | all variants | 0.0% | 5 |
Tires & wheels4 fields
| name | type | desc | applies to | % populated | sources |
|---|---|---|---|---|---|
| tire_size_front | text | all variants | 12% | 8 | |
| tire_size_rear | text | all variants | 12% | 5 | |
| wheel_diameter_front_in | int | all variants | 11% | 4 | |
| wheel_diameter_rear_in | int | all variants | 11% | 3 |
Performance4 fields
| name | type | desc | applies to | % populated | sources |
|---|---|---|---|---|---|
| zero_to_100_s | numeric · s | all variants | 42% | 15 | |
| top_speed_kmh | int · km/h | Mechanical/derestricted top speed (or sole published figure for non-EV). | all variants | 19% | 18 |
| zero_to_60_s | numeric · s | all variants | 2% | 14 | |
| top_speed_electric_kmh | int · km/h | Electronically-limited top speed for EVs (where manufacturer publishes a limit distinct from mechanical max). | all variants | 0.0% | — |
Safety equipment12 fields
| name | type | desc | applies to | % populated | sources |
|---|---|---|---|---|---|
| airbag_count | int | Total number of airbags fitted (mispar_kariot_avir). Range observed 0–17. Insurance / safety underwriting use. Source: israel-mot. | all variants | 11% | 1 |
| has_abs | bool | ABS (anti-lock braking system) fitted. Source: israel-mot (abs_ind flag, 0/1). Universal — no powertrain gating. | all variants | 9% | 3 |
| has_adaptive_cruise | bool | Adaptive cruise control fitted. Source: israel-mot (bakarat_shyut_adaptivit_ind). Universal — no powertrain gating. | all variants | 9% | 2 |
| has_blind_spot_monitoring | bool | Blind-spot detection / monitoring fitted. Source: israel-mot (zihuy_beshetah_nistar_ind). Universal — no powertrain gating. | all variants | 9% | 2 |
| has_brake_assist | bool | Brake assist (emergency brake assist / EBA) fitted. Source: israel-mot (maarechet_ezer_labalam_ind). Universal — no powertrain gating. | all variants | 9% | 1 |
| has_esp | bool | Electronic stability control (ESP/ESC) fitted. Source: israel-mot (bakarat_yatzivut_ind). Universal — no powertrain gating. | all variants | 9% | 2 |
| has_forward_collision_warning | bool | Forward collision warning / forward distance monitoring fitted. Source: israel-mot (nitur_merhak_milfanim_ind). Universal — no powertrain gating. | all variants | 9% | 2 |
| has_lane_departure_warning | bool | Lane departure warning / lane keeping assist fitted. Source: israel-mot (bakarat_stiya_menativ_ind). Universal — no powertrain gating. | all variants | 9% | 2 |
| has_pedestrian_detection | bool | Pedestrian detection / AEB pedestrian fitted. Source: israel-mot (zihuy_holchey_regel_ind). Universal — no powertrain gating. | all variants | 9% | 1 |
| has_reverse_camera | bool | Reverse / rear-view camera fitted. Source: israel-mot (matzlemat_reverse_ind). Universal — no powertrain gating. | all variants | 9% | 1 |
| adas_features | jsonb | all variants | 0.0% | — | |
| airbags | jsonb | Per-location airbag flags. Keys (boolean): front_driver, front_passenger, side_front, side_rear, curtain_front, curtain_rear, knee_driver, knee_passenger, center, rear_center, seat_cushion. Sourced fr | all variants | 0.0% | — |
Safety ratings10 fields
| name | type | desc | applies to | % populated | sources |
|---|---|---|---|---|---|
| iihs_head_restraints | text | all variants | 0.0% | — | |
| iihs_headlights | text | all variants | 0.0% | — | |
| iihs_moderate_overlap | text | all variants | 0.0% | — | |
| iihs_roof_strength | text | all variants | 0.0% | — | |
| iihs_side_orig | text | all variants | 0.0% | — | |
| iihs_side_updated | text | all variants | 0.0% | — | |
| iihs_small_overlap_driver | text | all variants | 0.0% | — | |
| iihs_small_overlap_passenger | text | all variants | 0.0% | — | |
| iihs_top_safety_pick | text | all variants | 0.0% | — | |
| iihs_year_tested | int | all variants | 0.0% | — |
Recalls3 fields
| name | type | desc | applies to | % populated | sources |
|---|---|---|---|---|---|
| nhtsa_recall_categories | jsonb | all variants | 15% | 1 | |
| recall_count | int | all variants | 15% | 1 | |
| recall_last_date | date | all variants | 15% | 1 |
Registry & regulatory IDs16 fields
| name | type | desc | applies to | % populated | sources |
|---|---|---|---|---|---|
| eea_type_code | text | all variants | 9% | 2 | |
| eea_variant_code | text | all variants | 9% | 2 | |
| eea_version_code | text | all variants | 9% | 2 | |
| israel_mot_pollution_group | int | Israeli pollution group (kvutzat_zihum). Ordinal scale 1–15; lower = cleaner. Used in Israeli road-tax and registration-fee calculations. ESG use: Israeli regulatory emission bracket. Source: israel-m | all variants | 9% | 1 |
| israel_mot_safety_score | numeric | Israeli Ministry of Transport safety score (nikud_betihut). Scale 0–10.5 in 0.5 increments; higher = safer. Analogous to EuroNCAP overall score but uses a different methodology. ESG / insurance use: I | all variants | 6% | 1 |
| canadian_co2_rating | int | NRCan CO2 rating 1-10 (higher = lower emissions). 0/n/a stored as NULL. | all variants | 5% | 1 |
| eea_vehicle_family | text | all variants | 5% | 2 | |
| israel_mot_safety_equip_level | int | Israeli safety equipment level (ramat_eivzur_betihuty). Ordinal scale 1–8; reflects the number/quality of safety systems fitted. Insurance underwriting use: Israeli-market mandatory equipment bracket. | all variants | 5% | 1 |
| canadian_smog_rating | int | NRCan Smog rating 1-10 (higher = lower smog-forming emissions). 0/n/a stored as NULL. | all variants | 4% | 1 |
| dvsa_mot_avg_test_mileage_km | int · km | Mean odometer reading at MOT test for this (make, model, first-use-year) cohort, in kilometres (DVSA stores miles; apex converts at aggregation). | all variants | 2% | 1 |
| dvsa_mot_common_defects | jsonb | Top-5 RfR (Reason-for-Rejection) top-level categories observed for this cohort, ordered by frequency descending. Vocabulary is the DVSA item_group top-level item set (e.g. BRAKES, LAMPS, STEERING, TY | all variants | 2% | 1 |
| dvsa_mot_failure_rate_pct | numeric · % | Percent of first-attempt UK MOT tests that resulted in Fail outcome for this (make, model, first-use-year) cohort. Source: DVSA anonymised MOT dataset, Class 4 normal-test rows only. OGL v3.0. | all variants | 2% | 1 |
| dvsa_mot_sample_year | int · year | Calendar year of the DVSA source file the aggregate was derived from (e.g. 2023 for tests carried out during calendar year 2023). | all variants | 2% | 1 |
| dvsa_mot_test_count | int | Number of DVSA MOT tests in the bucket this aggregate was derived from. Readers can filter on this for statistical significance (e.g. >= 50). | all variants | 2% | 1 |
| kr_fe_grade | text | Korean KEA 등급 (fuel-economy efficiency grade). Numeric "1등급" through "5등급" stored as "1".."5". Special categories ("PHEV", "FCEV", "초소형", "경형") preserved verbatim. Source: 한국에너지공단 (KOGL Type 1). | all variants | 1% | 1 |
| israel_mot_green_index | int | Israeli green index (madad_yarok). Scale 1–100; higher = greener. Sentinel values above 100 excluded. ESG / PCAF use. Source: israel-mot. | all variants | 0.0% | 1 |
Manufacturing6 fields
| name | type | desc | applies to | % populated | sources |
|---|---|---|---|---|---|
| plant_company | text | all variants | 51% | 1 | |
| plant_city | text | all variants | 22% | 1 | |
| plant_country | text | all variants | 22% | 1 | |
| plant_state | text | all variants | 18% | 1 | |
| manufacturer_pool | text | all variants | 7% | 2 | |
| mfr_emission_cert_code | text | all variants | 7% | 3 |
Homologation3 fields
| name | type | desc | applies to | % populated | sources |
|---|---|---|---|---|---|
| eu_vehicle_category | text | UNECE vehicle category. M1 = passenger car ≤8 seats; M2 = bus ≤5t; N1 = light truck ≤3.5t; etc. | all variants | 13% | 4 |
| homologation_date | date | Date of Swiss type-approval (Homologationsdatum) from ASTRA TARGA. Parsed from the emissionen.txt Homologationsdatum column (format YYYYMMDD). For EU-harmonised type approvals this is the date the var | all variants | 7% | 1 |
| cycle | text | all variants | 0.0% | 2 |
Warranty12 fields
| name | type | desc | applies to | % populated | sources |
|---|---|---|---|---|---|
| warranty_basic_km | int · km | all variants | 0.0% | — | |
| warranty_basic_years | int · years | all variants | 0.0% | — | |
| warranty_battery_capacity_pct | int · % | EV battery state-of-health guarantee at end of warranty period (e.g. 70%). Canonical of (battery_warranty_capacity_pct, warranty_battery_capacity_pct) per schema/213. | all variants | 0.0% | — |
| warranty_battery_km | int · km | EV battery warranty distance limit in km. Canonical of (battery_warranty_km, warranty_battery_km) per schema/213. | all variants | 0.0% | 1 |
| warranty_battery_years | int · years | EV battery warranty length in years. Canonical of (battery_warranty_years, warranty_battery_years) per schema/213. | all variants | 0.0% | 1 |
| warranty_corrosion_years | int · years | all variants | 0.0% | — | |
| warranty_maintenance_km | int · km | all variants | 0.0% | — | |
| warranty_maintenance_years | int · years | all variants | 0.0% | — | |
| warranty_paint_years | int · years | all variants | 0.0% | — | |
| warranty_powertrain_km | int · km | all variants | 0.0% | — | |
| warranty_powertrain_years | int · years | all variants | 0.0% | — | |
| warranty_roadside | bool | all variants | 0.0% | — |
Pricing & launch4 fields
| name | type | desc | applies to | % populated | sources |
|---|---|---|---|---|---|
| msrp_launch_eur | int | all variants | 0.0% | 1 | |
| msrp_launch_usd | int | all variants | 0.0% | 1 | |
| msrp_launch_year | int · year | all variants | 0.0% | 1 | |
| msrp_thb | int | Manufacturer-recommended retail price in Thai Baht (rounded to nearest baht). Range: ฿100,000–฿100,000,000 (sanity-clamped). Source: Thailand ECO Sticker OIE — recomend_retail_price_new field. Use for | all variants | 0.0% | 1 |
Other92 fields
| name | type | desc | applies to | % populated | sources |
|---|---|---|---|---|---|
| market_scope | text | Derived (schema/792): eu-type-approval | mixed | national-registration — distinguishes EU-wide type approval from national registration data. | all variants | 86% | — |
| energy_efficiency_class | text | Swiss Energieeffizienzkategorie (A–G) per the Swiss federal energy-label scheme. Calculated from fuel consumption and kerb weight. BEVs uniformly receive A. Published by ASTRA in the TARGA verbrauch.t | all variants | 6% | 1 |
| start_stop | bool | all variants | 6% | 1 | |
| wltp_test_mass_kg | int · kg | WLTP test mass: mass_in_running_order_kg + optional-equipment adjustment per WLTP regulation. Used as the basis for CO2 + consumption homologation. EEA reports this per type-approval; one variant can | all variants | 5% | 2 |
| front_overhang_mm | int · mm | Distance from front axle centerline to front bumper face, mm. SAE J1100 dimension F. Source: Transport Canada CVS (rank 2). Range 300-3000. | all variants | 3% | 1 |
| rear_overhang_mm | int · mm | Distance from rear axle centerline to rear bumper face, mm. SAE J1100 dimension G. Source: Transport Canada CVS (rank 2). Range 300-3000. | all variants | 3% | 1 |
| efficiency_combined_kwh_100km | numeric · kWh/100km | all variants | 2% | 7 | |
| efficiency_wltp_combined_kwh_100km | numeric · kWh/100km | all variants | 2% | 8 | |
| efficiency_epa_combined_kwh_100km | numeric · kWh/100km | all variants | 1% | 3 | |
| epa_guzzler | text | all variants | 1% | 1 | |
| gb_emission_class | text | all variants | 1% | 1 | |
| pbe_efficiency_class_absolute | text | Brazilian INMETRO PBE "Absoluta Geral" energy efficiency class (A-E). A = most efficient vehicles across the entire BR fleet; E = least efficient. Used by INMETRO and energy-policy bodies for macro fl | all variants | 1% | 1 |
| pbe_efficiency_class_relative | text | Brazilian INMETRO PBE "Relativa à Categoria" energy efficiency class (A-E). A = top 25%% of vehicle segment; E = bottom 25%%. Printed on the ENCE sticker. Segment-relative: a large SUV rated A may be | all variants | 1% | 1 |
| wltp_phases | jsonb | all variants | 1% | 1 | |
| axle_width_front_mm | int · mm | all variants | 0.0% | — | |
| axle_width_rear_mm | int · mm | all variants | 0.0% | — | |
| bed_length_mm | int · mm | all variants | 0.0% | — | |
| bed_type | text | all variants | 0.0% | — | |
| brake_front_type | text | all variants | 0.0% | 2 | |
| brake_rear_type | text | all variants | 0.0% | 2 | |
| charge_120v_hours | numeric | Time to full charge from empty on 120V/12A Level 1 AC (hours). BEV and PHEV only. Source: fueleconomy.gov charge120 field. | all variants | 0.0% | 1 |
| charge_240v_b_hours | numeric | Time to full charge on 240V Level 2 AC with optional second onboard charger (hours). BEV only; present for dual-charger variants (e.g. early Tesla with optional twin charger). Source: fueleconomy.gov | all variants | 0.0% | 1 |
| charge_240v_hours | numeric | Time to full charge from empty on 240V Level 2 AC (J1772) in hours. BEV and PHEV only. Source: fueleconomy.gov charge240 field. | all variants | 0.0% | 1 |
| combined_power_hp | int · hp | all variants | 0.0% | 2 | |
| combined_torque_nm | int · N·m | all variants | 0.0% | 1 | |
| efficiency_canadian_city_kwh_100km | numeric · kWh/100km | City electricity consumption from NRCan (Canadian 5-cycle, EV only). | all variants | 0.0% | 1 |
| efficiency_canadian_combined_kwh_100km | numeric · kWh/100km | Combined electricity consumption from NRCan / Transport Canada Fuel Consumption Ratings (Canadian 5-cycle, EV only). Distinct from EPA combined — same methodology family but slightly different US06/co | all variants | 0.0% | 1 |
| efficiency_canadian_highway_kwh_100km | numeric · kWh/100km | Highway electricity consumption from NRCan (Canadian 5-cycle, EV only). | all variants | 0.0% | 1 |
| efficiency_cltc_combined_kwh_100km | numeric · kWh/100km | all variants | 0.0% | 1 | |
| efficiency_epa_city_kwh_100km | numeric · kWh/100km | all variants | 0.0% | 1 | |
| efficiency_epa_highway_kwh_100km | numeric · kWh/100km | all variants | 0.0% | 1 | |
| efficiency_nedc_combined_kwh_100km | numeric · kWh/100km | all variants | 0.0% | 1 | |
| electrification_level | text | DEPRECATED 2026-05-21 — merged into powertrain via schema/219. Writes are auto-routed by trigger a_variants_canonicalize_fields. Column is always NULL. See field_canonical_map. | all variants | 0.0% | — |
| engine_compression_ratio | numeric | Static compression ratio (dimensionless, e.g. 10.5 means 10.5:1). ICE, HEV, PHEV only — BEV variants have no compression ratio. Typical gasoline range 8–14; diesel 14–20; Atkinson / HCCI gasoline 13–1 | all variants | 0.0% | 1 |
| engine_stroke_cycles | int | all variants | 0.0% | — | |
| equipment_options | jsonb | all variants | 0.0% | — | |
| ev_charger_level | text | Maximum EV charger level supported: L1 (120V AC), L2 (240V AC), or DC (fast charge). Normalised from staging.nhtsa_vpic.charger_level (NHTSA free text): "Level 1" -> L1, "Level 2" -> L2, "Level 3" / " | all variants | 0.0% | — |
| ev_motor_description | text | EPA free-text description of the electric motor (e.g. "150 KW AC Synchronous", "62 KW AC Induction"). BEV and PHEV only. Source: fueleconomy.gov evMotor field. | all variants | 0.0% | 1 |
| fame_score | numeric | all variants | 0.0% | — | |
| insurance_group_de | int | all variants | 0.0% | — | |
| insurance_group_fr | int | all variants | 0.0% | — | |
| insurance_group_uk | int | all variants | 0.0% | — | |
| interior_options | jsonb | Available interior materials/colors. Format: [{"name":"Rotor Grey","material":"leather","seats_pattern":"diamond-quilted"}] | all variants | 0.0% | — |
| korea_cert_date | date | 인증일 (NIER emission certification issue date). | all variants | 0.0% | — |
| korea_cert_number | text | 배출가스인증번호 (NIER emission certification number). One per variant; multi-cert variants keep the most-recent value (provenance has the full history). | all variants | 0.0% | — |
| korea_emission_standard | text | 국립환경과학원 배출허용기준 category (e.g. KMVES-10, KMVES-9). NIER native. | all variants | 0.0% | — |
| korea_noise_standard | text | 국립환경과학원 소음허용기준 category. NIER native. | all variants | 0.0% | — |
| korea_one_charge_range_km | int · km | 국립환경과학원 1회충전주행거리 (combined, ambient). KMVES one-charge driving distance — Korean Ministry of Environment certification cycle. NIER native. | all variants | 0.0% | 1 |
| korea_one_charge_range_lowtemp_km | int · km | 국립환경과학원 저온 1회충전주행거리 (combined, low-temperature, -7 C). KMVES low-temp one-charge driving distance. NIER native. | all variants | 0.0% | 1 |
| mpge_city_us | numeric | all variants | 0.0% | 2 | |
| mpge_combined_us | numeric | all variants | 0.0% | 4 | |
| mpge_highway_us | numeric | all variants | 0.0% | 2 | |
| nev_catalogue_listed | bool | Listed in MIIT 新能源汽车推广应用推荐车型目录 (NEV Recommended Catalogue). Required for green license plate eligibility in China. | all variants | 0.0% | — |
| nev_credit_type | text | all variants | 0.0% | — | |
| nev_credit_value | numeric | all variants | 0.0% | — | |
| obc_power_kw | numeric · kW | Onboard AC charger (OBC) rated power output in kW. MIIT 额定功率 (nameplate rating). Distinct from charging_ac_max_kw (max grid input, European TA-cert side); OBC is the vehicle-side rated output — conver | all variants | 0.0% | — |
| obfcm_phev_cd_fuel_l_100km | numeric · L/100km | Real-world PHEV charge-depleting fuel consumption (l/100km), fleet-averaged from EEA OBFCM per-vehicle telemetry (Reg. 2021/392). Computed as: SUM(cd_fuel_l) / SUM(total_distance_km) × 100 across repo | all variants | 0.0% | 1 |
| obfcm_phev_grid_kwh_100km | numeric · kWh/100km | Real-world PHEV grid energy per 100km (kWh/100km), fleet-averaged from EEA OBFCM per-vehicle telemetry. Computed as: SUM(grid_energy_kwh) / SUM(total_distance_km) × 100 across reporting vehicles. In-u | all variants | 0.0% | 1 |
| ota_capable | bool | all variants | 0.0% | — | |
| ota_scope | jsonb | all variants | 0.0% | — | |
| paint_options | jsonb | List of available paint colors when the variant launched. Format: [{"name":"Mythos Black","code":"LZ9Y","type":"metallic","extra_cost_eur":1200}]. Many cars publish 8-15 options. | all variants | 0.0% | — |
| particle_number_real_world_per_km | numeric · km | Real-world solid particle number emissions per km (PN > 23 nm) from on-road PEMS testing. Stored as double precision because values commonly span 1e8 to 1e12 #/km. | all variants | 0.0% | 1 |
| particulates_mg_km | numeric · km | DEPRECATED 2026-06-05 — merged into pm_wltp_mg_km via schema/660. Writes are auto-routed by trigger a_variants_canonicalize_fields. Column is always NULL. See field_canonical_map. | all variants | 0.0% | 2 |
| plug_and_charge | bool | all variants | 0.0% | — | |
| production_volume | int | all variants | 0.0% | — | |
| quarter_mile_s | numeric · s | all variants | 0.0% | — | |
| rde_nox_combined_mg_km | numeric · km | Real Driving Emissions NOx, combined cycle, mg/km. Sourced from UK VCA type-approval data (Euro 6d regime). ICE, HEV, MHEV, PHEV only. ESG use: PCAF financed-emissions, ICCT RDE conformity-factor anal | all variants | 0.0% | 1 |
| rde_nox_urban_mg_km | numeric · km | Real Driving Emissions NOx, urban sub-trip, mg/km. Typically higher than combined due to cold-start and low-speed operation. ICE, HEV, MHEV, PHEV only. Source: uk-vca (OGL v3.0). | all variants | 0.0% | 1 |
| reliability_consumer_reports | int | all variants | 0.0% | — | |
| reliability_jdp_dependability | int | all variants | 0.0% | — | |
| reliability_jdp_iqs | int | all variants | 0.0% | — | |
| reliability_source | text | all variants | 0.0% | — | |
| residual_1yr_pct | int · % | all variants | 0.0% | — | |
| residual_3yr_pct | int · % | all variants | 0.0% | — | |
| residual_5yr_pct | int · % | all variants | 0.0% | — | |
| residual_source | text | all variants | 0.0% | — | |
| roof_load_kg | int · kg | Maximum permitted roof load in kg, as type-approved. Source: SVV (taklast_kg). Universal. | all variants | 0.0% | — |
| service_brake_fluid_km | int · km | all variants | 0.0% | — | |
| service_brake_fluid_months | int | all variants | 0.0% | — | |
| service_oil_km | int · km | all variants | 0.0% | — | |
| service_oil_months | int | all variants | 0.0% | — | |
| service_transmission_km | int · km | all variants | 0.0% | — | |
| software_platform | text | all variants | 0.0% | — | |
| thailand_excise_tax_pct | numeric · % | Thai excise tax rate as a percentage (e.g. 8.0, 30.0). Set by the Thai Excise Department per vehicle type/engine size/CO2 band. Lower rates (2%, 8%) for eco-cars and BEVs; higher (30–40%) for large-en | all variants | 0.0% | 1 |
| us_ira_clean_credit_usd | int | all variants | 0.0% | — | |
| us_ira_eligible_from | date | all variants | 0.0% | — | |
| us_ira_eligible_to | date | all variants | 0.0% | — | |
| v2g_supported | bool | all variants | 0.0% | — | |
| v2h_supported | bool | all variants | 0.0% | — | |
| v2l_power_w | int | all variants | 0.0% | 1 | |
| v2l_supported | bool | all variants | 0.0% | 1 | |
| valve_train | text | all variants | 0.0% | — |
System / identity5 fields
| name | type | desc | applies to | % populated | sources |
|---|---|---|---|---|---|
| id | int | Surrogate primary key (bigint). Auto-incrementing, stable for the lifetime of a row; never reused. This is the join target for the provenance side-table (variant_id) and all external cross-references. | all variants | 100% | — |
| brand | text | Denormalized manufacturer brand name (e.g. "Toyota"). Copied from the canonical brands table at write time for query convenience; the authoritative normalised form lives in brands. | all variants | 100% | — |
| model_name | text | Denormalized canonical model name (e.g. "Corolla"). Copied from the models table at write time for query convenience; the authoritative form lives in models. | all variants | 100% | — |
| created_at | date | Row creation timestamp (timestamptz). Set once when the variant is first written through the write-gate; never updated thereafter. Use for audit trails and incremental loads. | all variants | 100% | — |
| updated_at | date | Row last-update timestamp (timestamptz). Refreshed on every write-gate upsert. Use for incremental polling (WHERE updated_at > $last_seen) to fetch only changed variants since your last pull. | all variants | 100% | — |
Field-level requests for unshipped columns: data@apex-db.org. Fields with commercial-use cleared provenance land in the next snapshot release.