Vehicle

Produces a real vehicle configuration certified for sale in the United States, with a VIN built for it, the state it is registered in and a license plate in that state's format.

Use it for any record that describes a vehicle: an inventory, a fleet, an insurance policy, a service history or a parking permit. Every sub-field of a row describes the same vehicle, so the make, model, model year, engine, fuel economy, VIN and plate in one row always match.

Sub-fields: at least one must be mapped. See Sub-fields.

Every JSON block on this page is a single field object, one entry in a table's fields array. See Building a Request for the full request structure.

Sub-fields

Sub-field	Produces
bodyCategory	The broad body category, written out, e.g. Sport Utility Vehicle. See VehicleBodyCategory.
bodyClass	The body style, e.g. Coupe or Sedan/Saloon. Null where none is recorded. See Body and size.
cityMpg	City fuel economy in miles per gallon, e.g. 21. For an electric vehicle, the miles-per-gallon equivalent.
co2GramsPerMile	Tailpipe carbon dioxide in grams per mile, e.g. 355. Null where none is recorded.
combinedMpg	Combined city and highway fuel economy in miles per gallon, e.g. 25. For an electric vehicle, the miles-per-gallon equivalent.
doors	The number of doors, e.g. 4. Null where none is recorded.
drive	Which wheels are driven, written out, e.g. Front-Wheel Drive. See VehicleDrive.
electricRangeMiles	The range on electricity alone, in miles, e.g. 260. Null for a vehicle that cannot be charged from the grid.
engineCylinders	The number of cylinders, e.g. 6. Null for an electric vehicle.
engineDisplacement	The engine displacement in liters, to one decimal place, e.g. 3.5. Null for an electric vehicle.
fuelType	The fuel the vehicle is rated on, e.g. Regular Gasoline, Premium Gasoline or Electricity.
highwayMpg	Highway fuel economy in miles per gallon, e.g. 30. For an electric vehicle, the miles-per-gallon equivalent.
licensePlate	A license plate in the registration state's standard passenger format, e.g. 7KAJ227. See Registration and plates.
make	The make, e.g. Honda.
manufacturer	The company that manufactured the vehicle, e.g. American Honda Motor Co., Inc..
model	The model, e.g. Accord.
modelVariant	The model as sold in this configuration, e.g. Camry AWD LE/SE. Often the same as model.
modelYear	The model year, e.g. 2021.
plantCity	The city of the plant that built the vehicle, e.g. Marysville. Null where none is recorded.
plantCountry	The country of the plant that built the vehicle, e.g. United States. Null where none is recorded.
plantState	The state or province of the plant that built the vehicle, e.g. Ohio. Null where none is recorded.
powertrain	What powers the vehicle, written out, e.g. Plug-in Hybrid. See VehiclePowertrain.
registrationCountry	The country the vehicle is registered in. Always US.
registrationRegion / registrationState	The two-letter code of the state the vehicle is registered in, e.g. CA, or DC for the District of Columbia.
registrationRegionName / registrationStateName	The name of the state the vehicle is registered in, e.g. California.
supercharged	Whether the engine is supercharged, as true or false.
transmission	The transmission as recorded, e.g. Automatic 6-spd, Manual 5-spd or Automatic (S8).
transmissionSpeeds	The number of forward gears, e.g. 8. Null for a transmission without fixed gears.
transmissionType	The kind of transmission, e.g. Automatic or Continuously Variable. See VehicleTransmission.
turbocharged	Whether the engine is turbocharged, as true or false.
vehicleClass	The size class, e.g. Midsize Cars or Standard Pickup Trucks. See Body and size.
vin	A 17-character vehicle identification number built for this vehicle, e.g. 1HGGK5H7XGY664391. See VIN.
wmi	The three-character manufacturer identifier the VIN starts with, e.g. 1HG.

transmission is the transmission as it is recorded for the vehicle, so its wording varies. transmissionType and transmissionSpeeds give the same information as consistent values.

cityMpg, highwayMpg and combinedMpg are whole numbers. engineDisplacement is a decimal with one decimal place, so map it to a Decimal, Double or text column.

Properties

Property	Type	Default	Description
bodyCategories	VehicleBodyCategory[]?	none	The body categories of the vehicles. Omit for any category.
drives	VehicleDrive[]?	none	The drives of the vehicles. Omit for any drive.
makes	VehicleMakeWeight[]?	none	The makes of the vehicles, each with a weight. Omit for any make. Cannot be combined with models. See Weighting.
map	object	required	Maps the field's sub-fields to destination columns. See Building a Request.
models	VehicleModelWeight[]?	none	The models of the vehicles, each with a weight and optionally its make. Omit for any model. Cannot be combined with makes. See Weighting.
modelYearMax	integer?	none	The latest model year. Omit for no upper bound.
modelYearMin	integer?	none	The earliest model year. Omit for no lower bound. Must not be after modelYearMax.
nullPercentageMax	number	0	Upper bound (0-100) of the percentage of rows that should be null. See nullPercentageMin.
nullPercentageMin	number	0	Lower bound (0-100) of the percentage of rows that should be null. The rate is fixed once for the whole field from this range, not recalculated per row. Set equal to nullPercentageMax for an exact rate.
powertrains	VehiclePowertrain[]?	none	The powertrains of the vehicles. Omit for any powertrain.
registrationCountries	CountryWeight[]?	none	Countries to register vehicles in, each with a weight. Only US registers vehicles. Omit for every country.
registrationStates / registrationRegions	StateWeight[]?	none	States to register vehicles in, each with a weight. Omit to select every state in proportion to the vehicles it registers. Set one name or the other, not both. See Weighting.
seed	integer	random	Per-field seed, overriding the request's own seed for this field only.
spreadBy	VehicleSpread	Model	How rows are shared among the vehicles the filters allow. See Spreading rows across vehicles.
transmissionTypes	VehicleTransmission[]?	none	The transmission types of the vehicles. Omit for any transmission.
unique	boolean	false	Whether every generated value must differ from the others. See Unique vehicles.
vehicleClasses	string[]?	none	The size classes of the vehicles, matched without regard to case, such as Compact Cars. Omit for any class.

Every filter narrows the same set, so with a make and a powertrain set, a vehicle must match both. Every makes or models entry must match at least one vehicle under the other filters, and an entry that matches none is rejected before any data is generated:

{
  "type": "urn:alchemy:error:invalid-generation-request",
  "title": "Invalid generation request.",
  "status": 400,
  "detail": "No vehicle matched make Honda, powertrains Diesel."
}

registrationCountries and registrationStates choose where vehicles are registered. They do not narrow which vehicles are selected.

CountryWeight

Property	Type	Default	Description
country	string	required	The ISO 3166-1 alpha-2 code of the country, matched without regard to case. Only US registers vehicles.
weight	number	1	The country's relative weight in the distribution, against the other entries. Must be greater than 0.

StateWeight

Property	Type	Default	Description
country	string?	none	The country the state is in. Optional. Only US is accepted.
state / region	string	required	The two-letter code of the state, matched without regard to case, such as CA, or DC for the District of Columbia.
weight	number	1	The state's relative weight in the distribution, against the other entries. Must be greater than 0.

VehicleBodyCategory

Value	Body category	bodyCategory writes
Car	A car, from two-seater to large.	Car
Pickup	A pickup truck.	Pickup Truck
SpecialPurpose	A special purpose vehicle, such as a cab chassis or a hearse.	Special Purpose Vehicle
SportUtility	A sport utility vehicle.	Sport Utility Vehicle
StationWagon	A station wagon.	Station Wagon
Van	A van or minivan.	Van

VehicleDrive

Value	Drive	drive writes
AllWheel	All-wheel drive.	All-Wheel Drive
FourWheel	Four-wheel drive, full-time or part-time.	4-Wheel Drive
FrontWheel	Front-wheel drive.	Front-Wheel Drive
RearWheel	Rear-wheel drive.	Rear-Wheel Drive
TwoWheel	Two-wheel drive, recorded without saying which axle.	2-Wheel Drive

VehicleMakeWeight

Property	Type	Default	Description
make	string	required	The make, matched without regard to case, such as Honda. See GET /v1/vehicles/makes.
weight	number	1	The make's relative weight in the distribution, against the other entries. Must be greater than 0.

VehicleModelWeight

Property	Type	Default	Description
make	string?	none	The make of the model, matched without regard to case. Optional. Without it, the entry matches the model under every make that has one by that name.
model	string	required	The model, matched without regard to case, such as Accord. See GET /v1/vehicles/models.
weight	number	1	The model's relative weight in the distribution, against the other entries. Must be greater than 0.

VehiclePowertrain

Value	Powertrain	powertrain writes
Diesel	A diesel engine.	Diesel
Electric	A battery electric vehicle.	Electric
FlexFuel	A flex-fuel vehicle that runs on gasoline or E85.	Flex Fuel
FuelCell	A hydrogen fuel cell vehicle.	Fuel Cell
Gasoline	A gasoline engine.	Gasoline
Hybrid	A hybrid that cannot be charged from the grid.	Hybrid
NaturalGas	A vehicle that runs on compressed natural gas, alone or with gasoline.	Natural Gas
PlugInHybrid	A plug-in hybrid.	Plug-in Hybrid
Propane	A vehicle that runs on propane, alone or with gasoline.	Propane

VehicleSpread

Value	Effect
Model	Every make, model and model year has the same chance, however many configurations it was sold in.
Variant	Every configuration has the same chance, so models sold in many configurations receive more rows.

VehicleTransmission

Value	Transmission	transmissionType writes
AutomatedManual	An automated manual, such as a dual-clutch transmission.	Automated Manual
Automatic	A conventional automatic.	Automatic
ContinuouslyVariable	A continuously variable transmission.	Continuously Variable
Manual	A manual.	Manual

Weighting

makes, models, registrationCountries and registrationStates are weighted lists. Each entry's weight is relative to the other entries in the same list. It is not a percentage and the weights need not add up to any total, so weights of 3 and 1 give the first entry three rows for every one the second gets. An entry with no weight counts as 1, so a list with no weights set shares the rows evenly.

List	How rows are shared
makes	Among the makes, by weight. Within a make, spreadBy sets how its vehicles share the rows.
models	Among the models, by weight. Within a model, spreadBy sets how its vehicles share the rows.
registrationCountries	Among the countries, by weight. Only US registers vehicles, so the list has no effect on which states are selected.
registrationStates	Among the states, by weight. Without the list, every state is selected in proportion to the vehicles it registers.

makes and models cannot be combined. To weight models of different makes, name the make in each models entry.

Weighted makes

{
  "type": "Vehicle",
  "makes": [
    { "make": "Toyota", "weight": 3 },
    { "make": "Honda", "weight": 2 },
    { "make": "Mazda" }
  ],
  "modelYearMin": 2015,
  "seed": 1,
  "map": {
    "make": { "column": "make", "dataType": "VarChar" },
    "model": { "column": "model", "dataType": "VarChar" },
    "modelYear": { "column": "year", "dataType": "Integer" }
  }
}

make	model	year
Toyota	Tundra	2015
Toyota	86	2020
Honda	Odyssey	2018
Honda	Civic	2015
Toyota	Highlander	2015
Toyota	Prius c	2017
Mazda	3	2026
Toyota	Sequoia	2023

Over many rows, half are Toyotas, a third are Hondas and a sixth are Mazdas.

Weighted models

{
  "type": "Vehicle",
  "models": [
    { "make": "Ford", "model": "F150", "weight": 4 },
    { "make": "Chevrolet", "model": "Silverado", "weight": 3 },
    { "make": "Toyota", "model": "Tundra" }
  ],
  "modelYearMin": 2015,
  "seed": 1,
  "map": {
    "make": { "column": "make", "dataType": "VarChar" },
    "model": { "column": "model", "dataType": "VarChar" },
    "modelVariant": { "column": "variant", "dataType": "VarChar" },
    "modelYear": { "column": "year", "dataType": "Integer" }
  }
}

make	model	variant	year
Ford	F150	F150 Pickup 4WD FFV	2017
Ford	F150	F150 5.0L 2WD FFV GVWR>7599 LBS PAYLOAD PACKAGE	2016
Chevrolet	Silverado	Silverado 2WD	2020
Chevrolet	Silverado	Silverado K10 4WD	2019
Ford	F150	F150 RAPTOR 4WD	2026
Ford	F150	F150 Pickup 4WD FFV	2015
Toyota	Tundra	Tundra 2WD	2020
Ford	F150	F150 Pickup 2WD FFV	2022

Weighted states

{
  "type": "Vehicle",
  "registrationStates": [
    { "state": "TX", "weight": 3 },
    { "state": "OK" },
    { "state": "NM" }
  ],
  "seed": 1,
  "map": {
    "registrationState": { "column": "state", "dataType": "Char" },
    "licensePlate": { "column": "plate", "dataType": "VarChar" },
    "modelYear": { "column": "year", "dataType": "Integer" },
    "make": { "column": "make", "dataType": "VarChar" }
  }
}

state	plate	year	make
TX	VSL-3916	2027	Volkswagen
TX	JZS-6267	2007	Mercedes-Benz
OK	CEJ-717	2021	Audi
TX	XPT-6098	2021	Nissan
NM	552-ZRJ	2022	Mercedes-Benz
TX	SMG-3513	2008	Hummer
OK	EYC-946	1997	GMC
TX	GCJ-5398	2015	Porsche

Over many rows, three in five are registered in Texas and one in five in each of the other two states.

VIN

vin is a 17-character vehicle identification number built for the vehicle in the same row:

Positions	Content
1 to 3	The manufacturer identifier, the same value wmi writes.
4 to 8	The vehicle descriptor the manufacturer uses for this vehicle.
9	The check digit, computed over the other sixteen characters.
10	The model year code.
11	The plant code.
12 to 17	A random serial number.

The descriptor matches the vehicle as closely as the manufacturer's VIN patterns allow: to the model and engine where possible, otherwise to the model, otherwise to the make. A VIN decoder therefore reads back the make and model year of every VIN, and the model of most. The letters I, O and Q never appear, and the check digit is always valid.

The serial number is random, so a VIN is well formed and decodes, but it is not taken from any vehicle.

{
  "type": "Vehicle",
  "models": [
    { "make": "Chevrolet", "model": "Silverado" }
  ],
  "seed": 1,
  "map": {
    "vin": { "column": "vin", "dataType": "Char" },
    "wmi": { "column": "wmi", "dataType": "Char" },
    "modelYear": { "column": "year", "dataType": "Integer" },
    "modelVariant": { "column": "variant", "dataType": "VarChar" }
  }
}

vin	wmi	year	variant
1GCGK04VX22147643	1GC	2002	Silverado 1500 2WD
1GCKC54VXY8916023	1GC	2000	Silverado 1500 2WD
1GC2WPBH7LF966267	1GC	2020	Silverado Cab Chassis 2WD
1GCVYAHD6K1790137	1GC	2019	Silverado K10 4WD
1GCVAEBD7SF173885	1GC	2025	Silverado 2WD
2CNMT84V113760988	2CN	2001	Silverado 1500 4WD

The tenth character is the model year code: 2 for 2002, Y for 2000, L for 2020, K for 2019, S for 2025 and 1 for 2001.

Registration and plates

Each row is registered in one of the 50 states or the District of Columbia. Without registrationStates, states are selected in proportion to the number of vehicles each one registers, so California and Texas appear far more often than Wyoming or Vermont. With it, rows are shared among the listed states by their weights. See Weighting.

licensePlate follows the registration state's standard passenger format, with the spaces and dashes the plate shows. Letters a state does not issue, such as I, O and Q in most states, are left out. Specialty and vanity plates are not produced.

Formats follow the model year

Where a state has changed its format, the plate uses the format the state was issuing in the vehicle's model year, so an older vehicle has an older plate. Colorado shows all three of its recent formats:

{
  "type": "Vehicle",
  "registrationStates": [
    { "state": "CO" }
  ],
  "modelYearMin": 2008,
  "seed": 1,
  "map": {
    "modelYear": { "column": "year", "dataType": "Integer" },
    "licensePlate": { "column": "plate", "dataType": "VarChar" }
  }
}

year	plate
2017	URL-391
2014	239-RRH
2017	SYC-137
2011	388-OSS
2022	UWB-N52
2023	KLR-R42
2021	EJR-K19
2024	MQB-D20

County-coded states

Alabama, Hawaii, Idaho, Mississippi, Montana, Nebraska, South Dakota and Wyoming put a county code at the start of the plate. The county is selected in proportion to its population, so the codes of the most populous counties appear most often.

{
  "type": "Vehicle",
  "registrationStates": [
    { "state": "AL" },
    { "state": "MT" },
    { "state": "ID" }
  ],
  "seed": 1,
  "map": {
    "registrationState": { "column": "state", "dataType": "Char" },
    "licensePlate": { "column": "plate", "dataType": "VarChar" },
    "make": { "column": "make", "dataType": "VarChar" }
  }
}

state	plate	make
AL	5ZNM9LP	Volkswagen
ID	1A EUH8V	Mercedes-Benz
ID	K UW05U	Audi
MT	15-EJ631	Nissan
ID	2C 1203P	Mercedes-Benz
MT	7-YK7914	Hummer

5 is Baldwin County in Alabama. 1A is Ada County, 2C is Canyon County and K is Kootenai County in Idaho. 15 is Lake County and 7 is Flathead County in Montana. An Idaho plate ends in V in Ada County, P in Canyon County and U in every other county.

A generated plate follows a real format, so it can match the plate of a real vehicle. Treat a plate column as you would any other value that can identify a vehicle.

Body and size

vehicleClass is the size class the vehicle is rated in, such as Compact Cars, Small Sport Utility Vehicle or Standard Pickup Trucks. bodyCategory groups those classes into the broad categories in VehicleBodyCategory. bodyClass is the body style recorded for the vehicle's VIN. It is recorded separately from the size class, so the two can describe the same vehicle differently, and it is null where none is recorded:

{
  "type": "Vehicle",
  "makes": [
    { "make": "Subaru" },
    { "make": "Volvo" }
  ],
  "modelYearMin": 2012,
  "seed": 1,
  "map": {
    "make": { "column": "make", "dataType": "VarChar" },
    "model": { "column": "model", "dataType": "VarChar" },
    "bodyCategory": { "column": "category", "dataType": "VarChar" },
    "bodyClass": { "column": "body", "dataType": "VarChar" },
    "doors": { "column": "doors", "dataType": "Integer" },
    "drive": { "column": "drive", "dataType": "VarChar" }
  }
}

make	model	category	body	doors	drive
Subaru	BRZ	Car			Rear-Wheel Drive
Subaru	Tribeca	Sport Utility Vehicle			All-Wheel Drive
Volvo	S90	Car	Sedan/Saloon	4	Front-Wheel Drive
Volvo	S90	Car	Sedan/Saloon	4	All-Wheel Drive
Subaru	Crosstrek	Sport Utility Vehicle	Sport Utility Vehicle [SUV]/Multipurpose Vehicle [MPV]	5	All-Wheel Drive
Subaru	BRZ	Car	Coupe	2	Rear-Wheel Drive

Filter by bodyCategories or vehicleClasses. bodyClass is for output only.

Spreading rows across vehicles

Some models were sold in many more configurations than others. With spreadBy set to Model, the default, every make, model and model year has the same chance of being selected, so a model year sold in 40 configurations appears no more often than one sold in two. With Variant, every configuration has the same chance, so models sold in many configurations appear more often.

{
  "type": "Vehicle",
  "makes": [
    { "make": "Ford" }
  ],
  "modelYearMin": 2020,
  "spreadBy": "Variant",
  "seed": 1,
  "map": {
    "model": { "column": "model", "dataType": "VarChar" },
    "modelVariant": { "column": "variant", "dataType": "VarChar" },
    "modelYear": { "column": "year", "dataType": "Integer" }
  }
}

model	variant	year
Fusion	Fusion FWD	2020
Explorer	Explorer AWD	2020
Explorer	Explorer RWD	2023
Mustang Mach-E	Mustang Mach-E Rally	2024
Bronco	Bronco Sasquatch 4WD	2023
F150	F150 Pickup 4WD	2026
Explorer	Explorer RWD	2023
Ranger	Ranger RAPTOR 4WD	2025

Unique vehicles

With unique set, no two rows have the same mapped values. How many rows that allows depends on what is mapped:

Mapped	Distinct rows available
vin or licensePlate	No fixed limit, because each row has its own random serial number or plate.
A registration state or state name, without vin or licensePlate	The number of different combinations of the other mapped values among the matching vehicles, multiplied by the number of states.
Anything else	The number of different combinations of the mapped values among the matching vehicles. With only make mapped, it is the number of makes.

With makes or models, the matching vehicles are those of every entry together, and a vehicle that matches more than one entry counts once.

A table with more rows than the field can make distinct is rejected before any data is generated:

{
  "type": "urn:alchemy:error:invalid-generation-request",
  "title": "Invalid generation request.",
  "status": 400,
  "detail": "This field (table 'vehicles', column 'make') is unique for 40 rows, but its settings allow only 36 distinct value(s). Lower rowCount, widen the field's range, or turn off unique."
}

Finding filter values

makes, models and vehicleClasses take names exactly as the vehicle data spells them, apart from case. These endpoints list the values each filter accepts, with the model years each one covers:

Endpoint	Lists
GET /v1/vehicles/makes	Every make, for makes.
GET /v1/vehicles/models	Every model, or the models of one make, for models.
GET /v1/vehicles/options	The values of bodyCategories, drives, powertrains, registrationRegions, transmissionTypes and vehicleClasses.
GET /v1/vehicles/manufacturers	Every make with the manufacturer identifiers its VINs start with.

Examples

Each example below is a single field object, one entry in a table's fields array within a full request. See Building a Request for how it fits into a full DatasetRequest.

A dealer inventory

Recent vehicles of two makes in equal shares, each with a VIN.

{
  "type": "Vehicle",
  "makes": [
    { "make": "Honda" },
    { "make": "Toyota" }
  ],
  "modelYearMin": 2020,
  "modelYearMax": 2025,
  "seed": 1,
  "map": {
    "vin": { "column": "vin", "dataType": "Char" },
    "modelYear": { "column": "year", "dataType": "Integer" },
    "make": { "column": "make", "dataType": "VarChar" },
    "model": { "column": "model", "dataType": "VarChar" },
    "modelVariant": { "column": "variant", "dataType": "VarChar" },
    "transmission": { "column": "transmission", "dataType": "VarChar" },
    "combinedMpg": { "column": "mpg", "dataType": "Integer" }
  }
}

vin	year	make	model	variant	transmission	mpg
5J6YF6H18LM476439	2020	Honda	Pilot	Pilot AWD	Automatic (S9)	22
5J6RL6H38RB602396	2024	Honda	Odyssey	Odyssey	Automatic (S10)	22
5TDAS5EC4M2267790	2021	Toyota	Sienna	Sienna Hybrid 2WD	Automatic (AV-S6)	36
1HGZE4F77LX371738	2020	Honda	Insight	Insight	Automatic (variable gear ratios)	52
4T1A11AB3MU576098	2021	Toyota	GR Supra	GR Supra	Automatic (S8)	25
JTDAFAAF0SJ055296	2025	Toyota	Crown	Crown AWD	Automatic (AV-S6)	30

Vehicles registered in one state

{
  "type": "Vehicle",
  "registrationStates": [
    { "state": "CA" }
  ],
  "seed": 1,
  "map": {
    "registrationState": { "column": "state", "dataType": "Char" },
    "licensePlate": { "column": "plate", "dataType": "VarChar" },
    "modelYear": { "column": "year", "dataType": "Integer" },
    "make": { "column": "make", "dataType": "VarChar" },
    "model": { "column": "model", "dataType": "VarChar" }
  }
}

state	plate	year	make	model
CA	764JYC6	2027	Volkswagen	Jetta
CA	3ZRS267	2007	Mercedes-Benz	CL-Class
CA	1DJV173	2021	Audi	SQ5
CA	6TSA988	2021	Nissan	Leaf
CA	5GZS346	2022	Mercedes-Benz	CLA-Class
CA	3JND363	2008	Hummer	H3

Vehicles registered across a region

registrationRegions is the synonym of registrationStates, and each entry can name its state with region in place of state. With no weights set, the three states share the rows evenly.

{
  "type": "Vehicle",
  "registrationRegions": [
    { "region": "NY" },
    { "region": "NJ" },
    { "region": "CT" }
  ],
  "modelYearMin": 2005,
  "seed": 1,
  "map": {
    "registrationStateName": { "column": "state", "dataType": "VarChar" },
    "licensePlate": { "column": "plate", "dataType": "VarChar" },
    "modelYear": { "column": "year", "dataType": "Integer" },
    "make": { "column": "make", "dataType": "VarChar" },
    "model": { "column": "model", "dataType": "VarChar" }
  }
}

state	plate	year	make	model
New York	USK-3916	2006	BMW	M
New York	HZS-6267	2020	BMW	3 Series
Connecticut	013 VDV	2008	Dodge	Caliber
New York	XNT-6098	2018	Nissan	Sentra
Connecticut	552 ZSJ	2006	Mercury	Monterey
New Jersey	R42-JND	2021	Subaru	Impreza
New Jersey	J19-BZM	2024	Audi	RS Q8
New Jersey	C20-HNH	2017	Kia	Soul

Electric and plug-in hybrid vehicles

electricRangeMiles is the range on electricity alone. For a plug-in hybrid, combinedMpg is the economy on gasoline, and for an electric vehicle it is the miles-per-gallon equivalent.

{
  "type": "Vehicle",
  "powertrains": ["Electric", "PlugInHybrid"],
  "modelYearMin": 2018,
  "seed": 1,
  "map": {
    "make": { "column": "make", "dataType": "VarChar" },
    "model": { "column": "model", "dataType": "VarChar" },
    "modelYear": { "column": "year", "dataType": "Integer" },
    "powertrain": { "column": "powertrain", "dataType": "VarChar" },
    "electricRangeMiles": { "column": "electric_range_mi", "dataType": "Integer" },
    "combinedMpg": { "column": "mpge", "dataType": "Integer" }
  }
}

make	model	year	powertrain	electric_range_mi	mpge
Audi	e-tron S	2022	Electric	185	65
Aston Martin	Valhalla	2026	Plug-in Hybrid	6	16
Volvo	S60	2025	Plug-in Hybrid	40	31
Tesla	Model S	2024	Electric	359	107
Lucid	Air	2026	Electric	480	120
Tesla	Model 3	2020	Electric	322	121

Four-wheel drive pickups

An electric pickup has no cylinders or displacement, so those columns are null on its row.

{
  "type": "Vehicle",
  "bodyCategories": ["Pickup"],
  "drives": ["FourWheel"],
  "seed": 20,
  "map": {
    "make": { "column": "make", "dataType": "VarChar" },
    "model": { "column": "model", "dataType": "VarChar" },
    "modelYear": { "column": "year", "dataType": "Integer" },
    "engineCylinders": { "column": "cylinders", "dataType": "Integer" },
    "engineDisplacement": { "column": "liters", "dataType": "Decimal" },
    "transmission": { "column": "transmission", "dataType": "VarChar" },
    "fuelType": { "column": "fuel", "dataType": "VarChar" }
  }
}

make	model	year	cylinders	liters	transmission	fuel
Rivian	R1T	2024			Automatic (A1)	Electricity
Nissan	Frontier	2015	6	4	Manual 6-spd	Regular Gasoline
Chevrolet	K1500 Pickup	1991	6	4.3	Automatic 4-spd	Regular Gasoline
Chevrolet	K1500 Pickup	1991	8	6.2	Automatic 4-spd	Diesel
Dodge	W100/W150 Pickup	1991	8	5.9	Manual 4-spd	Regular Gasoline
Isuzu	i-370 Crew Cab	2007	5	3.7	Automatic 4-spd	Regular Gasoline

Manual sports cars

{
  "type": "Vehicle",
  "vehicleClasses": ["Two Seaters", "Minicompact Cars"],
  "transmissionTypes": ["Manual"],
  "modelYearMin": 2010,
  "seed": 1,
  "map": {
    "make": { "column": "make", "dataType": "VarChar" },
    "model": { "column": "model", "dataType": "VarChar" },
    "modelYear": { "column": "year", "dataType": "Integer" },
    "vehicleClass": { "column": "class", "dataType": "VarChar" },
    "transmission": { "column": "transmission", "dataType": "VarChar" },
    "drive": { "column": "drive", "dataType": "VarChar" },
    "turbocharged": { "column": "turbo", "dataType": "Boolean" }
  }
}

make	model	year	class	transmission	drive	turbo
Audi	R8 Spyder	2014	Two Seaters	Manual 6-spd	All-Wheel Drive	false
Dodge	Viper	2017	Two Seaters	Manual 6-spd	Rear-Wheel Drive	false
Aston Martin	Vantage	2015	Two Seaters	Manual 6-spd	Rear-Wheel Drive	false
Nissan	370Z	2017	Two Seaters	Manual 6-spd	Rear-Wheel Drive	false
Porsche	Boxster	2010	Two Seaters	Manual 6-spd	Rear-Wheel Drive	false
Lotus	Evora	2017	Minicompact Cars	Manual 6-spd	Rear-Wheel Drive	false

Where vehicles were built

A plant column is null where that value is not recorded for the vehicle.

{
  "type": "Vehicle",
  "makes": [
    { "make": "Ford" },
    { "make": "Honda" },
    { "make": "Toyota" }
  ],
  "modelYearMin": 2015,
  "seed": 2,
  "map": {
    "vin": { "column": "vin", "dataType": "Char" },
    "make": { "column": "make", "dataType": "VarChar" },
    "manufacturer": { "column": "manufacturer", "dataType": "VarChar" },
    "plantCountry": { "column": "plant_country", "dataType": "VarChar" },
    "plantState": { "column": "plant_state", "dataType": "VarChar" },
    "plantCity": { "column": "plant_city", "dataType": "VarChar" }
  }
}

vin	make	manufacturer	plant_country	plant_state	plant_city
5J6RM4H90GS191384	Honda	American Honda Motor Co., Inc.	Japan	Mie	Suzuka
3FA6P0U98GR070053	Ford	Ford Motor Company, Mexico	Mexico		Hermosillo
1FMSK7VB7MG727003	Ford	Ford Motor Company	United States	Illinois	Chicago
MAJ6S2KL8MC788690	Ford	Ford India Ltd	India	Tamil Nadu	Chennai
JTDBVRFD5K1991038	Toyota	Toyota Motor Corporation
4T1BK1EB1HU760022	Toyota	Toyota Motor Manufacturing, Kentucky, Inc.	United States	Kentucky	Georgetown

Every configuration of one make, each used once

{
  "type": "Vehicle",
  "makes": [
    { "make": "Polestar" }
  ],
  "unique": true,
  "seed": 1,
  "map": {
    "model": { "column": "model", "dataType": "VarChar" },
    "modelYear": { "column": "year", "dataType": "Integer" },
    "modelVariant": { "column": "variant", "dataType": "VarChar" },
    "electricRangeMiles": { "column": "range_mi", "dataType": "Integer" }
  }
}

model	year	variant	range_mi
2	2025	2 Single Motor (20 Inch Wheels)	300
4	2026	4 Long Range Dual Motor Performance	255
2	2021	2	233
3	2026	3 Long Range Single Motor (20 Inch Wheels)	286
1	2020	1	52
2	2024	2 Single Motor (20 Inch Wheels)	307

Some rows with no vehicle

{
  "type": "Vehicle",
  "nullPercentageMin": 25,
  "nullPercentageMax": 25,
  "seed": 2,
  "map": {
    "make": { "column": "make", "dataType": "VarChar" },
    "model": { "column": "model", "dataType": "VarChar" },
    "licensePlate": { "column": "plate", "dataType": "VarChar" },
    "registrationState": { "column": "state", "dataType": "Char" }
  }
}

make	model	plate	state
Kia	EV9	CHU-L20	CO
Honda	Odyssey	532 SFT	AZ
Cadillac	CT4	XV 69069	IL
Plymouth	Reliant	4WRU600	CA
Audi	A3	ZNA M34	FL
Subaru	Legacy/Outback	XPK-0402	NY

Every mapped column goes empty together on a null row, so a row never has a plate with no vehicle.