MeridianMERIDIAN
Finetype

Type Registry

Browse all 251 semantic types detected by Finetype.

Types that are easy to mistake for one another are set side by side in Types told apart.

251

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
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]
S-Expressions_expression
VARCHAR(ROOT (S (NP (NN cat)) (VP (…
XML Documentxml
VARCHAR<root><name>John</name><age>…
YAML Documentyaml
VARCHARname: John age: 30 active: t…

datetime

Dates, times, timestamps, durations, and timezone offsets89
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
Timezone Abbreviationtimezone_abbreviation
VARCHAREST
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 Datetime with Milliseconds (no timezone)iso_milliseconds
TIMESTAMP2013-06-04T01:02:03.123
ISO Datetime, minute precision (no timezone)iso_minutes
TIMESTAMP2013-06-04T01:02
ISO Datetime, second precision (no timezone)iso_seconds
TIMESTAMP2013-06-04T01:02:03
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 +0…
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 Minute-Precision Datetimesql_minutes
TIMESTAMP2024-01-15 10:30
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 identifiers29
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 (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 Numbercredit_card_number
VARCHAR4532015112830366
Basis Pointsbasis_points
VARCHAR125 bps
Financial Yield / Returnyield
VARCHAR+2.5%
CUSIPcusip
VARCHAR037833100
FIGIfigi
VARCHARBBG000BLNQ16
ISINisin
VARCHARUS0378331005
LEIlei
VARCHAR529900T8BM49AURSDO55
SEDOLsedol
VARCHAR0263494
Stock Tickerticker
VARCHARAAPL

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
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
State/Province Codestate_code
VARCHARCA
HS Tariff Codehs_code
VARCHAR8471.30
IATA Airport Codeiata_code
VARCHARJFK
ICAO Airport Codeicao_code
VARCHARKJFK
Shipping Container Code (ISO 6346)iso6346
VARCHARMSCU1234566
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
NAICS Industry Codenaics
VARCHAR541511
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
VARCHARjohn.smith@example.com
Email with Display Nameemail_display
VARCHAR"John Doe" <john@example.com…
First Namefirst_name
VARCHARJohn
Full Namefull_name
VARCHARJohn Smith
Gendergender
VARCHARMale
Gender Codegender_code
VARCHARM
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 notation32
Binary Boolean (0/1)binary
BOOLEAN0
Boolean Initials (T/F, Y/N)initials
BOOLEANT
Boolean Terms (True/False, Yes/No)terms
BOOLEANtrue
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
Protein Sequenceprotein_sequence
VARCHARMKVLLIVGS
RNA Sequencerna_sequence
VARCHARAUGCAGC
SMILES Notationsmiles
VARCHARO
Emojiemoji
VARCHAR😀
Entity Nameentity_name
VARCHARThe Olive Garden
Plain Textplain_text
VARCHARThis is a plain text descrip…
Single Wordword
VARCHARhello

technology

Network addresses, hashes, URIs, and device identifiers30
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
Qualified Namequalified_name
VARCHARcom.google.javascript.jscomp…
Cryptographic Hashhash
VARCHAR5d41402abc4b2a76b9719d911017…
JSON Web Tokenjwt
VARCHAReyJhbGciOiJIUzI1NiIsInR5cCI6…
URL-Safe Base64 Tokentoken_urlsafe
VARCHARSFMyNDI5STExOjEwMQ
Calendar Versioncalver
VARCHAR2024.02.09
Docker/OCI Image Referencedocker_ref
VARCHARnginx:latest
Version Numberversion
VARCHAR1.2.3
Filenamefilename
VARCHARreport_final.xlsx
Windows File Pathwindows_path
VARCHARC:\Windows\System32\drivers\…
Snowflake IDsnowflake_id
BIGINT175928847299117063
TSIDtsid
VARCHAR0JMVQ049NFN6K
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
Email Message-IDmessage_id
VARCHAR<30365805.1075860998985.Java…
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

Profile, validate and classify text data inside DuckDB with the Finetype community extension: install it, profile a table, and call its scalar functions.

FAQ

Common questions about Meridian and Finetype: what each one is, how accurate Finetype's type detection is, and how to contribute to the project.

Type Registry