Skip to content

Type Registry

FineType recognises 171 semantic types across 6 domains. Each type is a transformation contract — a guarantee that the DuckDB cast expression will succeed on every matching value.

Click any type to see its full documentation — validation rules, DuckDB cast expressions, JSON Schema, and example values. Use / to focus search.

171 /

container

Structured data — JSON, CSV, query strings, key-value pairs

11

Comma-Separated Values (Simple) container.array.comma_separated

apple,banana,cherry1,2,3,4,5red,green,blue

Pipe-Separated Values container.array.pipe_separated

apple|banana|cherry1|2|3|4|5

Semicolon-Separated Values container.array.semicolon_separated

apple;banana;cherry1,5;2,3;4,7

Whitespace-Separated Values container.array.whitespace_separated

apple banana cherry1 2 3 4 5red green blue

Form Data container.key_value.form_data

username=john&password=secre…[email protected]&subsc…

Query String Parameters container.key_value.query_string

name=John&age=30&city=NewYor…q=python&page=1user_id=123&token=abc123xyz

CSV Record container.object.csv

John,30,true"Smith, John",30,Engineer

JSON Object container.object.json

{"user": "john", "age": 30}{"name": "Alice", "email": "…{"nested": {"key": "value"}}

JSON Array container.object.json_array

[1, 2, 3]["a", "b", "c"][{"id": 1, "name": "Alice"},…

XML Document container.object.xml

<root><name>John</name><age>…<user id="123"><email>john@e…

YAML Document container.object.yaml

name: John age: 30 active: t…user: id: 123 email: joh…

datetime

Dates, times, timestamps, durations, and timezone offsets

46

Century (Roman Numeral) datetime.component.century

Day of Month datetime.component.day_of_month

Day of Week Name datetime.component.day_of_week

MondayFridaySunday

Full Month Name datetime.component.month_name

JanuaryJuneDecember

Periodicity datetime.component.periodicity

DailyMonthlyQuarterly

Calendar Year datetime.component.year

Abbreviated Month Date datetime.date.abbreviated_month

Jan 15, 2024Dec 31, 2019Jun 01, 2000

Compact Date (DDMMYYYY) datetime.date.compact_dmy

1501202431122019

Compact Date (MMDDYYYY) datetime.date.compact_mdy

0115202412312019

Compact Date (YYYYMMDD) datetime.date.compact_ymd

2024011520191231

European Date (dot-separated) datetime.date.eu_dot

15.01.202431.12.2019

European Date (slash-separated) datetime.date.eu_slash

15/01/202431/12/2019

ISO Date datetime.date.iso

2024-01-152019-12-312000-01-01

ISO Week Date datetime.date.iso_week

2024-W032019-W52

Julian Date datetime.date.julian

Long Date with Full Month Name datetime.date.long_full_month

January 15, 2024December 31, 2019

Ordinal Date datetime.date.ordinal

2024-0152019-3652020-366

Short Date (Day-Month-Year, 2-digit year) datetime.date.short_dmy

15-01-2431-12-99

Short Date (Month-Day-Year, 2-digit year) datetime.date.short_mdy

01-15-2412-31-99

Short Date (Year-Month-Day, 2-digit year) datetime.date.short_ymd

24-01-1599-12-31

US Date (slash-separated) datetime.date.us_slash

01/15/202412/31/2019

Full Weekday with Abbreviated Month datetime.date.weekday_abbreviated_month

Monday, 15 Jan 2024Tuesday, 31 Dec 2019

Full Weekday with Full Month Name datetime.date.weekday_full_month

Monday, 15 January 2024Tuesday, 31 December 2019

ISO 8601 Duration datetime.duration.iso_8601

PT30MPT1H30MP1DT12H

Unix Timestamp (microseconds) datetime.epoch.unix_microseconds

17053122000000001577836799999999

Unix Timestamp (milliseconds) datetime.epoch.unix_milliseconds

17053122000001577836799999

Unix Timestamp (seconds) datetime.epoch.unix_seconds

170531220015778367991000000000

IANA Timezone Name datetime.offset.iana

America/New_YorkEurope/LondonAsia/Tokyo

UTC Offset datetime.offset.utc

UTC +05:00UTC -08:00UTC +00:00

12-Hour Time (HH:MM AM/PM) datetime.time.hm_12h

10:30 AM11:59 PM

24-Hour Time (HH:MM) datetime.time.hm_24h

10:3023:5900:00

12-Hour Time with AM/PM datetime.time.hms_12h

10:30:00 AM11:59:59 PM12:00:00 AM

24-Hour Time (HH:MM:SS) datetime.time.hms_24h

10:30:0023:59:5900:00:00

ISO Time with Microseconds datetime.time.iso

10:30:00.12345623:59:59.000000

American Datetime datetime.timestamp.american

01/15/2024 10:30 AM12/31/2019 11:59 PM

American Datetime (24-hour) datetime.timestamp.american_24h

01/15/2024 10:30:0012/31/2019 23:59:59

European Datetime datetime.timestamp.european

15/01/2024 10:3031/12/2019 23:59

ISO 8601 datetime.timestamp.iso_8601

2024-01-15T10:30:00Z2019-12-31T23:59:59Z2023-06-01T00:00:00Z

ISO 8601 Compact datetime.timestamp.iso_8601_compact

20240115T10300020191231T235959

ISO 8601 with Microseconds datetime.timestamp.iso_8601_microseconds

2024-01-15T10:30:00.123456Z2019-12-31T23:59:59.000000Z

ISO 8601 with Timezone Offset datetime.timestamp.iso_8601_offset

2024-01-15T10:30:00+05:002023-12-29T10:45:30-05:002024-06-15T12:00:00+00:00

ISO Datetime with Microseconds (no timezone) datetime.timestamp.iso_microseconds

2024-01-15T10:30:00.1234562019-12-31T23:59:59.000000

RFC 2822 datetime.timestamp.rfc_2822

Tue, 15 Jan 2024 10:30:00 GM…Sun, 31 Dec 2023 23:59:59 GM…

RFC 2822 with Ordinal Indicators datetime.timestamp.rfc_2822_ordinal

15th Jan 2024 10:30:00 +00001st Jan 2020 00:00:00 +000022nd Jul 2028 21:48:59 +0000

RFC 3339 (Space Separator) datetime.timestamp.rfc_3339

2024-01-15 10:30:00+00:002019-12-31 23:59:59-05:002023-06-01 12:00:00+09:00

SQL Standard datetime.timestamp.sql_standard

2024-01-15 10:30:002019-12-31 23:59:59

geography

Locations, addresses, coordinates, and regional identifiers

16

Full Address geography.address.full_address

123 Main Street, New York, N…456 Oxford Street, London, W…789 Rue de Rivoli, Paris, 75…

Postal Code geography.address.postal_code

1000175004W1C 1AX

Street Name geography.address.street_name

Main StreetOxford StreetFifth Avenue

Street Number geography.address.street_number

Street Suffix geography.address.street_suffix

StreetAvenueBoulevard

International Calling Code geography.contact.calling_code

Coordinate Pair (Lat, Lon) geography.coordinate.coordinates

40.7128,-74.006051.5074,-0.127835.6762 139.6917

Latitude geography.coordinate.latitude

40.7128-33.868851.5074

Longitude geography.coordinate.longitude

-74.0060151.2093-0.1278

City Name geography.location.city

New YorkSan FranciscoLondon

Continent Name geography.location.continent

North AmericaEuropeAsia

Country Name geography.location.country

United StatesFranceJapan

Country Code geography.location.country_code

Region / State geography.location.region

CaliforniaTexasOntario

IATA Airport Code geography.transportation.iata_code

ICAO Airport Code geography.transportation.icao_code

identity

People, payments, credentials, and personal data

35

Academic Degree identity.academic.degree

Bachelor DegreeMaster'sPhD

University / Institution identity.academic.university

Harvard UniversityStanford UniversityMIT

DEA Number identity.medical.dea_number

AB1234563FA5678901BJ3456782

NDC (National Drug Code) identity.medical.ndc

0002-1433-8012345-678-9012345-6789-0

NPI (National Provider Identifier) identity.medical.npi

123456789310030001261992789456

Bitcoin Address identity.payment.bitcoin_address

1A1z7agoat2GPFH7pPPPP...3J98t1WpEZ73CNmYviecrnyiWrnq…bc1qw508d6qejxtdg4y5r3zarvar…

Credit Card Expiration Date identity.payment.credit_card_expiration_date

12/2506/2803/2026

Credit Card Network identity.payment.credit_card_network

VisaMastercardAmex

Credit Card Number identity.payment.credit_card_number

45320151128303665425233010103442374245455400126

Currency Code (ISO 4217) identity.payment.currency_code

Currency Symbol identity.payment.currency_symbol

CUSIP identity.payment.cusip

03783310017275R102594918104

CVV / CVC identity.payment.cvv

Ethereum Address identity.payment.ethereum_address

0x742d35Cc6634C0532925a3b844…0x00000000000000000000000000…0xd9965507d3b0ce0ce6932b0337…

ISIN identity.payment.isin

US0378331005GB0002634946JP3633400001

LEI identity.payment.lei

529900T8BM49AURSDO55213800WSGIIZCXF1P572549300MLUDYVRQOOXS22

PayPal Email identity.payment.paypal_email

[email protected][email protected]

SEDOL identity.payment.sedol

0263494B0WNLY73134865

SWIFT/BIC identity.payment.swift_bic

DEUTDEFFBNPAFRPPCHASUS33XXX

Age identity.person.age

Blood Type identity.person.blood_type

Email Address identity.person.email

[email protected][email protected][email protected]

First Name identity.person.first_name

JohnMaríaJacques

Full Name identity.person.full_name

John SmithMaría GarcíaJacques Dubois

Gender identity.person.gender

MaleFemaleNon-binary

Gender Code identity.person.gender_code

Gender Symbol identity.person.gender_symbol

Height identity.person.height

180 cm5'10"70 inches

Last Name identity.person.last_name

SmithGarcíaDubois

Nationality identity.person.nationality

United StatesJapanGermany

Occupation identity.person.occupation

Software EngineerData ScientistProduct Manager

Password identity.person.password

aB3#xY9@mK2MySecureP@ss123correct-horse-battery-staple

Phone Number identity.person.phone_number

+1 (555) 123-4567555-123-4567+44 20 7946 0958

Username identity.person.username

john.smithuser_123alice-wonderland

Weight identity.person.weight

75 kg165 lbs68.5 kg

representation

Numbers, booleans, encodings, and scientific notation

29

Binary Boolean (0/1) representation.boolean.binary

Boolean Initials (T/F, Y/N) representation.boolean.initials

Boolean Terms (True/False, Yes/No) representation.boolean.terms

Alphanumeric Identifier representation.code.alphanumeric_id

SKU-12345C85A/5 21171

Categorical Value representation.discrete.categorical

Ordinal Value representation.discrete.ordinal

Excel Number Format String representation.file.excel_format

#,##0.00$#,##0.000.00%

File Extension representation.file.extension

File Size representation.file.file_size

MIME Type representation.file.mime_type

text/plainapplication/jsonimage/png

Decimal Number representation.numeric.decimal_number

3.14-0.51000.001

Increment / Counter representation.numeric.increment

Integer Number representation.numeric.integer_number

Percentage representation.numeric.percentage

Scientific Notation representation.numeric.scientific_notation

1.23e-45E+63.14e10

SI-Prefix Number representation.numeric.si_number

DNA Sequence representation.scientific.dna_sequence

ATGCAGCGCTAGCTAGCTAGATGATGATG

Measurement Unit representation.scientific.measurement_unit

meterkilogramsecond

Metric Prefix representation.scientific.metric_prefix

Protein Sequence representation.scientific.protein_sequence

MKVLLIVGSACDEFGHIKLMNPQRSTVWYFLMPKTAYIAKQRQISFVKSHFSRQLEERL…

RNA Sequence representation.scientific.rna_sequence

AUGCAGCGCUAGCUAGCUAGAUGAUGAUG

Color (Hexadecimal) representation.text.color_hex

#FF0000#f000000FF

Color (RGB) representation.text.color_rgb

rgb(255, 0, 0)255, 0, 0(128, 128, 128)

Emoji representation.text.emoji

Entity Name representation.text.entity_name

The Olive GardeniPhone 15 ProGame of Thrones

Paragraph representation.text.paragraph

This product works great. I …First, preheat the oven to 3…The hotel was located in the…

Plain Text representation.text.plain_text

This is a plain text descrip…A longer paragraph with mult…Single word

Sentence representation.text.sentence

This is a complete sentence.Is this a question?What an exclamation!

Single Word representation.text.word

helloworldhello-world

technology

Network addresses, hashes, URIs, and device identifiers

34

DOI technology.code.doi

10.1038/nature1237310.1000/xyz12310.1016/j.cell.2009.01.043

EAN technology.code.ean

5901234123457963850744006381333931

IMEI technology.code.imei

490154203237518352043068649149010000862422488

ISBN technology.code.isbn

978-0-13-110362-70-13-110362-99780131103627

ISSN technology.code.issn

0028-08361234-567X0003-7516

Locale Code technology.code.locale_code

PIN technology.code.pin

Cryptographic Hash technology.cryptographic.hash

5d41402abc4b2a76b9719d911017…aaf4c61ddcc5e8a2dabede0f3b48…2c26b46911185131006dfb3b57a9…

Hexadecimal Token technology.cryptographic.token_hex

a1b2c3d4e5f67890ab1234567890abcdef1234deadbeefcafebabe00ff11

URL-Safe Base64 Token technology.cryptographic.token_urlsafe

SFMyNDI5STExOjEwMQdGVzdC10b2tlbgaGVsbG8td29ybGQ

UUID technology.cryptographic.uuid

550e8400-e29b-41d4-a716-4466…6ba7b810-9dad-11d1-80b4-00c0…f47ac10b-58cc-4372-a567-0e02…

Calendar Version technology.development.calver

2024.022024.02.092023.12.31

Operating System technology.development.os

WindowsmacOSLinux

Programming Language technology.development.programming_language

PythonJavaScriptGo

Software License technology.development.software_license

MITApache 2.0GPL-3.0

Development Stage technology.development.stage

AlphaBetaReleased

Version Number technology.development.version

1.2.3v1.2.31.2.3-alpha

CPU Model technology.hardware.cpu

Intel Core i7-11700KAMD Ryzen 5 5600XApple M1

Hardware Generation technology.hardware.generation

Gen 311th Genv2

RAM Size technology.hardware.ram_size

16GB8192MB32 GB

Screen Size technology.hardware.screen_size

15.6 inches27"24.0cm

Hostname technology.internet.hostname

example.comwww.google.comsubdomain.example.org

HTTP Method technology.internet.http_method

HTTP Status Code technology.internet.http_status_code

IPv4 Address technology.internet.ip_v4

192.168.1.18.8.8.8127.0.0.1

IPv4 Address with Port technology.internet.ip_v4_with_port

192.168.1.1:808010.0.0.1:3306127.0.0.1:5432

IPv6 Address technology.internet.ip_v6

2001:0db8:85a3:0000:0000:8a2…2001:db8:85a3::8a2e:370:7334::1

MAC Address technology.internet.mac_address

00:1a:2b:3c:4d:5e08-00-27-00-00-00a0:b1:c2:d3:e4:f5

Port Number technology.internet.port

URL Slug technology.internet.slug

my-blog-postproduct_name_123hello-world

Top-Level Domain (TLD) technology.internet.top_level_domain

URI technology.internet.uri

https://example.com/pathmailto:[email protected]urn:isbn:0451450523

URL technology.internet.url

https://example.com/path/to/…http://www.google.comftp://ftp.example.org/file.t…

User Agent String technology.internet.user_agent

Mozilla/5.0 (Windows NT 10.0…Mozilla/5.0 (iPhone; CPU iPh…curl/7.64.1