Table of Contents

Field Reference

Every field in a request has a type, one of the values listed below, plus settings specific to that type, plus the common settings (map, unique, nullPercentageMin/nullPercentageMax, seed) described in Building a Request.

Type Produces
Address A real street address. Number, street, unit, and the city, county, state and postal code it is in.
Airport A real airport, with its codes, its location, its elevation, its time zone and its position.
Boolean A true/false value, with a configurable chance of true.
Calculated A value derived from other columns of the same row: arithmetic, text, dates, geometry, and conditionals.
Date A calendar date.
DateRange A start and end date, a set number of days apart.
DateTime A date and time, with no UTC offset.
DateTimeRange A start and end date and time, a set number of hours apart.
Flight A journey between two real airports: an airline, a flight number, times in each airport's own zone, a duration, the route and a seat.
Format A value in a published identifier format that passes its own validation. Credit card numbers, IBANs, national and tax IDs.
Geospatial A point, line, polygon, or other OGC geometry. Optionally bounded to a real place via boundingLocation.
Identifier A unique identifier. A GUID, ULID, UUID version 7, or a Prefix-Id-Postfix pattern.
Interval A duration.
Location A real place. A city, county, state, or ZIP/postal area.
Name A single first or last name for a chosen country.
Number Numeric values. Sequential, random, clustered, or from a fixed list.
Person A person: names, sex, date of birth, US race and ethnicity, and identifiers built from them, all describing the same person.
Reference A value taken from a column generated in an earlier table, for a foreign key.
String Text. Random characters, dictionary words, sentences, or a fixed list.
Time A time of day.
TimeRange A start and end time of day, a set number of minutes apart.
Timestamp A date, time, and UTC offset.
Vehicle A real vehicle configuration sold in the United States, with a VIN, a registration state and a license plate.