MeridianMERIDIAN

Type Registry

Browse all 250 semantic types detected by FineType.

250

container

Structured data — JSON, CSV, query strings, key-value pairs12
Comma-Separated Values (Simple)comma_separated
VARCHARapple,banana,cherry
Pipe-Separated Valuespipe_separated
VARCHARapple|banana|cherry
Semicolon-Separated Valuessemicolon_separated
VARCHARapple;banana;cherry
Whitespace-Separated Valueswhitespace_separated
VARCHARapple banana cherry
Form Dataform_data
VARCHARusername=john&password=secre…
Query String Parametersquery_string
VARCHARname=John&age=30&city=NewYor…
CSV Recordcsv
VARCHARJohn,30,true
HTML Contenthtml
VARCHAR<p>Hello world</p>
JSON Objectjson
JSON{"user": "john", "age": 30}
JSON Arrayjson_array
JSON[1, 2, 3]
XML Documentxml
VARCHAR<root><name>John</name><age>…
YAML Documentyaml
VARCHARname: John age: 30 active: t…

datetime

Dates, times, timestamps, durations, and timezone offsets84
Day of Week Nameday_of_week
VARCHARMonday
Full Month Namemonth_name
VARCHARJanuary
Periodicityperiodicity
VARCHARDaily
Calendar Yearyear
SMALLINT2024
Abbreviated Month Day Year (no comma)abbrev_month_no_comma
DATEJan 15 2024
Abbreviated Month Dateabbreviated_month
DATEJan 15, 2024
Chinese Standard Datechinese_ymd
DATE2024年1月15日
Compact Date (DDMMYYYY)compact_dmy
DATE15012024
Compact Date (MMDDYYYY)compact_mdy
DATE01152024
Compact Year-Month (YYYYMM)compact_ym
DATE202401
Compact Date (YYYYMMDD)compact_ymd
DATE20240115
DMY Date (dash-separated)dmy_dash
DATE15-01-2024
DMY Date with Abbreviated Month (dash-separated)dmy_dash_abbrev
DATE15-Jan-2024
DMY Date with Abbreviated Month (dash, 2-digit year)dmy_dash_abbrev_short
DATE15-Jan-24
DMY Date (dot-separated)dmy_dot
DATE15.01.2024
DMY Short Date (dot, 2-digit year)dmy_short_dot
DATE15.01.24
DMY Short Date (slash, 2-digit year)dmy_short_slash
DATE15/01/24
DMY Date (slash-separated)dmy_slash
DATE15/01/2024
DMY Date with Abbreviated Month (space-separated)dmy_space_abbrev
DATE15 Jan 2024
DMY Date with Full Month (space-separated)dmy_space_full
DATE15 January 2024
Full Month Day Year (no comma)full_month_no_comma
DATEJanuary 15 2024
ISO Dateiso
DATE2024-01-15
ISO Week Dateiso_week
DATE2024-W03
Japanese Imperial Year (Long/Kanji)jp_era_long
DATE令和6年1月15日
Japanese Imperial Year (Short)jp_era_short
DATER6/01/15
Julian Datejulian
DATE24-015
Korean Standard Datekorean_ymd
DATE2024년 1월 15일
Long Date with Full Month Namelong_full_month
DATEJanuary 15, 2024
MDY Date (dash-separated)mdy_dash
DATE01-15-2024
MDY Short Date (slash, 2-digit year)mdy_short_slash
DATE01/15/24
MDY Date (slash-separated)mdy_slash
DATE01/15/2024
Abbreviated Month Yearmonth_year_abbrev
DATEJan 2024
Full Month Yearmonth_year_full
DATEJanuary 2024
Month/Year (slash-separated)month_year_slash
DATE01/2024
Ordinal Dateordinal
DATE2024-015
Short Date (Day-Month-Year, 2-digit year)short_dmy
DATE15-01-24
Short Date (Month-Day-Year, 2-digit year)short_mdy
DATE01-15-24
Short Date (Year-Month-Day, 2-digit year)short_ymd
DATE24-01-15
Full Weekday with Abbreviated Monthweekday_abbreviated_month
DATEMonday, Jan 15, 2024
Weekday DMY Full (formal)weekday_dmy_full
DATEMonday, 15 January 2024
Full Weekday with Full Month Nameweekday_full_month
DATEMonday, January 15, 2024
Year-Month (ISO truncated)year_month
DATE2024-01
YMD Date (dot-separated)ymd_dot
DATE2024.01.15
YMD Date (slash-separated)ymd_slash
DATE2024/01/15
ISO 8601 Durationiso_8601
INTERVALPT30M
Unix Timestamp (microseconds)unix_microseconds
TIMESTAMP1705312200000000
Unix Timestamp (milliseconds)unix_milliseconds
TIMESTAMP1705312200000
Unix Timestamp (seconds)unix_seconds
TIMESTAMP1705312200
IANA Timezone Nameiana
VARCHARAmerica/New_York
UTC Offsetutc
VARCHARUTC +05:00
Fiscal Yearfiscal_year
VARCHARFY2024
Calendar Quarterquarter
DATEQ1 2024
12-Hour Time (HH:MM AM/PM)hm_12h
TIME10:30 AM
24-Hour Time (HH:MM)hm_24h
TIME10:30
12-Hour Time with AM/PMhms_12h
TIME10:30:00 AM
24-Hour Time (HH:MM:SS)hms_24h
TIME10:30:00
ISO Time with Microsecondsiso
TIME10:30:00.123456
Common Log Format (Apache/Nginx)clf
TIMESTAMPTZ15/Jan/2024:14:30:00 +0000
C ctime / asctime Formatctime
TIMESTAMPMon Jan 15 14:30:00 2024
DMY Hour-Minute Datetimedmy_hm
TIMESTAMP15/01/2024 10:30
European Dot Timestamp (DMY 24h)dot_dmy_24h
TIMESTAMP15.01.2024 14:30:00
Dot YMD Timestamp (24h)dot_ymd_24h
TIMESTAMP2024.01.15 14:30:00
Unix Epoch Nanosecondsepoch_nanoseconds
TIMESTAMP1705325400000000000
ISO 8601iso_8601
TIMESTAMP2024-01-15T10:30:00Z
ISO 8601 Compactiso_8601_compact
TIMESTAMP20240115T103000
ISO 8601 with Microseconds and Offsetiso_8601_micros_offset
TIMESTAMPTZ2024-01-15T14:30:00.123456+0…
ISO 8601 with Microsecondsiso_8601_microseconds
TIMESTAMP2024-01-15T10:30:00.123456Z
ISO 8601 with Milliseconds and Offsetiso_8601_millis_offset
TIMESTAMPTZ2024-01-15T14:30:00.123+05:3…
ISO 8601 with Millisecondsiso_8601_milliseconds
TIMESTAMP2024-01-15T14:30:00.123Z
ISO 8601 with Timezone Offsetiso_8601_offset
TIMESTAMPTZ2024-01-15T10:30:00+05:00
ISO Datetime with Microseconds (no timezone)iso_microseconds
TIMESTAMP2024-01-15T10:30:00.123456
ISO with Space Separator and Ziso_space_zulu
TIMESTAMP2024-01-15 14:30:00Z
MDY 12-Hour Datetimemdy_12h
TIMESTAMP01/15/2024 10:30 AM
MDY 24-Hour Datetimemdy_24h
TIMESTAMP01/15/2024 10:30:00
PostgreSQL Short Offsetpg_short_offset
TIMESTAMPTZ2024-01-15 14:30:00.123456-0…
RFC 2822rfc_2822
TIMESTAMPTZTue, 15 Jan 2024 10:30:00 GM…
RFC 2822 with Ordinal Indicatorsrfc_2822_ordinal
TIMESTAMPTZ15th Jan 2024 10:30:00 +0000
RFC 3339 (Space Separator)rfc_3339
TIMESTAMPTZ2024-01-15 10:30:00+00:00
Slash YMD Timestamp (24h)slash_ymd_24h
TIMESTAMP2024/01/15 14:30:00
SQL Timestamp with Microsecondssql_microseconds
TIMESTAMP2024-01-15 14:30:00.123456
SQL Timestamp with Microseconds and Offsetsql_microseconds_offset
TIMESTAMPTZ2024-01-15 14:30:00.123456+0…
SQL Timestamp with Millisecondssql_milliseconds
TIMESTAMP2024-01-15 14:30:00.123
SQL Standardsql_standard
TIMESTAMP2024-01-15 10:30:00
BSD Syslog (RFC 3164)syslog_bsd
VARCHARJan 15 14:30:00

finance

Currencies, monetary amounts, and financial identifiers31
ABA Routing Numberaba_routing
VARCHAR021000021
BSB Numberbsb
VARCHAR062-000
IBANiban
VARCHARGB29NWBK60161331926819
SWIFT/BICswift_bic
VARCHARDEUTDEFF
Bitcoin Addressbitcoin_address
VARCHAR1A1z7agoat2GPFH7pPPPP...
Ethereum Addressethereum_address
VARCHAR0x742d35Cc6634C0532925a3b844…
Currency Amount (US Format)amount
DECIMAL$1,234.56
Currency Amount (US Accounting)amount_accounting
VARCHAR$1,234.56
Currency Amount (Swiss Apostrophe)amount_apostrophe
VARCHARCHF 1'234.56
Currency Amount (ISO Code Prefix)amount_code_prefix
VARCHARUSD 1,234.56
Currency Amount (EU Format)amount_comma
DECIMAL€1.234,56
Currency Amount (EU Suffix)amount_comma_suffix
VARCHAR1.234,56 €
Currency Amount (Cryptocurrency)amount_crypto
VARCHAR0.00123456 BTC
Currency Amount (Indian Lakh/Crore)amount_lakh
VARCHAR₹12,34,567.89
Currency Amount (Minor Unit Integer)amount_minor_int
VARCHAR12345
Currency Amount (Multi-Character Symbol)amount_multisym
VARCHARR$ 1.234,56
Currency Amount (Trailing Negative)amount_neg_trailing
VARCHAR$1,234.56-
Currency Amount (Zero-Decimal Currency)amount_nodecimal
VARCHAR¥1,234
Currency Amount (Space-Separated Thousands)amount_space
VARCHAR1 234,56 €
Currency Code (ISO 4217)currency_code
VARCHARUSD
Currency Symbolcurrency_symbol
VARCHAR$
Credit Card Expiration Datecredit_card_expiration_date
DATE12/25
Credit Card Numbercredit_card_number
VARCHAR4532015112830366
PayPal Emailpaypal_email
VARCHAR[email protected]
Basis Pointsbasis_points
VARCHAR125 bps
Financial Yield / Returnyield
VARCHAR+2.5%
CUSIPcusip
VARCHAR037833100
FIGIfigi
VARCHARBBG000BLNQ16
ISINisin
VARCHARUS0378331005
LEIlei
VARCHAR529900T8BM49AURSDO55
SEDOLsedol
VARCHAR0263494

geography

Locations, addresses, coordinates, and regional identifiers25
Full Addressfull_address
VARCHAR123 Main Street, New York, N…
Postal Codepostal_code
VARCHAR10001
Street Namestreet_name
VARCHARMain Street
Street Suffixstreet_suffix
VARCHARStreet
International Calling Codecalling_code
VARCHAR+1
Coordinate Pair (Lat, Lon)coordinates
POINT40.7128,-74.0060
Degrees Minutes Secondsdms
VARCHAR40°26'46"N 79°58'56"W
Geohashgeohash
VARCHAR9q8yyk8yuv
Latitudelatitude
DOUBLE40.7128
Longitudelongitude
DOUBLE-74.0060
Military Grid Reference Systemmgrs
VARCHAR18SUJ2348306479
Plus Code (Open Location Code)plus_code
VARCHAR849VCWC8+R9
GeoJSON Geometrygeojson
VARCHAR{"type": "Point", "coordinat…
Well-Known Text Geometrywkt
VARCHARPOINT (30 10)
H3 Hex Indexh3
VARCHAR8928308280fffff
City Namecity
VARCHARNew York
Continent Namecontinent
VARCHARNorth America
Country Namecountry
VARCHARUnited States
Country Codecountry_code
VARCHARUS
Region / Stateregion
VARCHARCalifornia
HS Tariff Codehs_code
VARCHAR8471.30
IATA Airport Codeiata_code
VARCHARJFK
ICAO Airport Codeicao_code
VARCHARKJFK
Shipping Container Code (ISO 6346)iso6346
VARCHARMSCU1234567
UN/LOCODEunlocode
VARCHARUSLAX

identity

People, payments, credentials, and personal data34
ORCIDorcid
VARCHAR0000-0002-1825-0097
EANean
VARCHAR5901234123457
ISBNisbn
VARCHAR978-0-13-110362-7
ISRCisrc
VARCHARUSUAN1400011
ISSNissn
VARCHAR0028-0836
UPCupc
VARCHAR042100005264
Australian Business Numberabn
VARCHAR51 824 753 556
US Employer Identification Numberein
VARCHAR12-3456789
EU VAT Numbereu_vat
VARCHARDE123456789
Indian PANpan_india
VARCHARABCPD1234E
US Social Security Numberssn
VARCHAR078-05-1120
Vehicle Identification Numbervin
VARCHAR1HGBH41JXMN109186
CPT Procedure Codecpt
VARCHAR99213
DEA Numberdea_number
VARCHARAB1234563
HCPCS Level II Codehcpcs
VARCHARJ1234
ICD-10 Diagnosis Codeicd10
VARCHARE11.9
LOINC Codeloinc
VARCHAR2951-2
NDC (National Drug Code)ndc
VARCHAR0002-1433-80
NPI (National Provider Identifier)npi
VARCHAR1234567893
Blood Typeblood_type
VARCHARO+
Email Addressemail
VARCHAR[email protected]
Email with Display Nameemail_display
VARCHAR"John Doe" <[email protected]…
First Namefirst_name
VARCHARJohn
Full Namefull_name
VARCHARJohn Smith
Gendergender
VARCHARMale
Gender Codegender_code
VARCHARM
Gender Symbolgender_symbol
VARCHAR♂
Heightheight
DOUBLE180 cm
Last Namelast_name
VARCHARSmith
Passwordpassword
VARCHARaB3#xY9@mK2
Phone Number (E.164)phone_e164
VARCHAR+61412345678
Phone Numberphone_number
VARCHAR+1 (555) 123-4567
Usernameusername
VARCHARjohn.smith
Weightweight
DOUBLE75 kg

representation

Numbers, booleans, encodings, and scientific notation36
Binary Boolean (0/1)binary
BOOLEAN0
Boolean Initials (T/F, Y/N)initials
BOOLEANT
Boolean Terms (True/False, Yes/No)terms
BOOLEANtrue
Categorical Valuecategorical
ENUMactive
Ordinal Valueordinal
VARCHARhigh
Excel Number Format Stringexcel_format
VARCHAR#,##0.00
File Extensionextension
VARCHARtxt
File Sizefile_size
BIGINT1024
MIME Typemime_type
VARCHARtext/plain
Color (Hexadecimal)color_hex
VARCHAR#FF0000
Color (HSL)color_hsl
VARCHARhsl(120, 100%, 50%)
Color (RGB)color_rgb
VARCHARrgb(255, 0, 0)
Alphanumeric Identifieralphanumeric_id
VARCHARSKU-12345
Increment / Counterincrement
BIGINT1
Numeric Codenumeric_code
VARCHAR840
UUIDuuid
UUID550e8400-e29b-41d4-a716-4466…
Decimal Numberdecimal_number
DOUBLE3.14
Decimal Number (Comma Separator)decimal_number_comma
DOUBLE1.234,56
Integer Numberinteger_number
BIGINT42
Percentagepercentage
DOUBLE50%
Scientific Notationscientific_notation
DOUBLE1.23e-4
SI-Prefix Numbersi_number
DOUBLE12.2K
CAS Registry Numbercas_number
VARCHAR7732-18-5
DNA Sequencedna_sequence
VARCHARATGCAGC
InChI Identifierinchi
VARCHARInChI=1S/H2O/h1H2
Measurement Unitmeasurement_unit
VARCHARmeter
Metric Prefixmetric_prefix
VARCHARkilo
Protein Sequenceprotein_sequence
VARCHARMKVLLIVGS
RNA Sequencerna_sequence
VARCHARAUGCAGC
SMILES Notationsmiles
VARCHARO
Emojiemoji
VARCHAR😀
Entity Nameentity_name
VARCHARThe Olive Garden
Paragraphparagraph
VARCHARThis product works great. I …
Plain Textplain_text
VARCHARThis is a plain text descrip…
Sentencesentence
VARCHARThis is a complete sentence.
Single Wordword
VARCHARhello

technology

Network addresses, hashes, URIs, and device identifiers28
AWS ARNaws_arn
VARCHARarn:aws:s3:::my-bucket
S3 URIs3_uri
VARCHARs3://my-bucket/data/file.csv
DOIdoi
VARCHAR10.1038/nature12373
IMEIimei
VARCHAR490154203237518
Locale Codelocale_code
VARCHARen
Cryptographic Hashhash
VARCHAR5d41402abc4b2a76b9719d911017…
JSON Web Tokenjwt
VARCHAReyJhbGciOiJIUzI1NiIsInR5cCI6…
Hexadecimal Tokentoken_hex
VARCHARa1b2c3d4e5f67890ab
URL-Safe Base64 Tokentoken_urlsafe
VARCHARSFMyNDI5STExOjEwMQ
Calendar Versioncalver
VARCHAR2024.02
Docker/OCI Image Referencedocker_ref
VARCHARnginx:latest
Git Commit SHAgit_sha
VARCHARa1b2c3d4e5f6a7b8c9d0e1f2a3b4…
Version Numberversion
VARCHAR1.2.3
Snowflake IDsnowflake_id
BIGINT175928847299117063
TSIDtsid
VARCHAR0190a1b2c3d4e5f6a7b8c9d0e1f2…
ULIDulid
VARCHAR01ARZ3NDEKTSV4RRFFQ69G5FAV
CIDR Notationcidr
VARCHAR192.168.1.0/24
Data URIdata_uri
VARCHARdata:text/plain;base64,SGVsb…
Hostnamehostname
VARCHARexample.com
HTTP Methodhttp_method
VARCHARGET
IPv4 Addressip_v4
VARCHAR192.168.1.1
IPv4 Address with Portip_v4_with_port
VARCHAR192.168.1.1:8080
IPv6 Addressip_v6
VARCHAR2001:0db8:85a3:0000:0000:8a2…
MAC Addressmac_address
VARCHAR00:1a:2b:3c:4d:5e
Top-Level Domain (TLD)top_level_domain
VARCHARcom
URLurl
VARCHARhttps://example.com/path/to/…
URNurn
VARCHARurn:isbn:0451450523
User Agent Stringuser_agent
VARCHARMozilla/5.0 (Windows NT 10.0…

DuckDB Extension

Classify, inspect, and cast text data directly inside DuckDB using the FineType community extension.

FAQ

Common questions about Meridian and FineType.

Type Registry