MeridianMERIDIAN

Vehicle Identification Number

17-character alphanumeric code uniquely identifying motor vehicles. Uses characters A-H, J-N, P, R-Z, 0-9 (excludes I, O, Q to avoid confusion with 1, 0). Encodes manufacturer, vehicle attributes, and serial number.

Vehicle Identification Number

identity.government.vin

17-character alphanumeric code uniquely identifying motor vehicles. Uses characters A-H, J-N, P, R-Z, 0-9 (excludes I, O, Q to avoid confusion with 1, 0). Encodes manufacturer, vehicle attributes, and serial number.

Domain
identity
Category
government
Casts to
VARCHAR
Scope
Universal

Try it

CLI
$ finetype infer -i "1HGBH41JXMN109186"
→ identity.government.vin

DuckDB

Detect
SELECT finetype('1HGBH41JXMN109186');
-- → 'identity.government.vin'
Cast expression
CAST({col} AS VARCHAR)
Safe cast pipeline
-- Normalise and cast in one step
SELECT TRY_CAST(finetype_cast(my_column) AS VARCHAR) AS clean_value
FROM my_table
WHERE finetype(my_column) = 'identity.government.vin';

JSON Schema

finetype schema identity.government.vin
{
  "$id": "https://meridian.online/schemas/identity.government.vin",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "17-character alphanumeric code uniquely identifying motor vehicles. Uses characters A-H, J-N, P, R-Z, 0-9 (excludes I, O, Q to avoid confusion with 1, 0). Encodes manufacturer, vehicle attributes, and serial number.",
  "examples": [
    "1HGBH41JXMN109186",
    "WVWZZZ3CZWE123456",
    "JM1BK343551234567",
    "5YJSA1DN5DFP12345"
  ],
  "maxLength": 17,
  "minLength": 17,
  "pattern": "^[A-HJ-NPR-Z0-9]{17}$",
  "title": "Vehicle Identification Number",
  "type": "string",
  "x-finetype-broad-type": "VARCHAR",
  "x-finetype-transform": "CAST({col} AS VARCHAR)"
}

Examples

1HGBH41JXMN109186WVWZZZ3CZWE123456JM1BK3435512345675YJSA1DN5DFP12345

Aliases

vehicle_id

Type Registry