MeridianMERIDIAN

ISRC

International Standard Recording Code — 12-character identifier for sound recordings and music videos. Format: CC-XXX-YY-NNNNN where CC is country code, XXX is registrant, YY is year, NNNNN is designation.

ISRC

identity.commerce.isrc

International Standard Recording Code — 12-character identifier for sound recordings and music videos. Format: CC-XXX-YY-NNNNN where CC is country code, XXX is registrant, YY is year, NNNNN is designation.

Domain
identity
Category
commerce
Casts to
VARCHAR
Scope
Universal

Try it

CLI
$ finetype infer -i "USUAN1400011"
→ identity.commerce.isrc

DuckDB

Detect
SELECT finetype('USUAN1400011');
-- → 'identity.commerce.isrc'
Cast expression
CAST({col} AS VARCHAR)
Safe cast pipeline
-- Normalise and cast in one step
SELECT TRY_CAST(finetype_cast(my_column) AS VARCHAR) AS clean_value
FROM my_table
WHERE finetype(my_column) = 'identity.commerce.isrc';

Struct Expansion

Expression
country_code: REGEXP_EXTRACT({col}, '^([A-Z]{2})')
designation: REGEXP_EXTRACT({col}, '(\d{5})$')
registrant: REGEXP_EXTRACT({col}, '^[A-Z]{2}([A-Z0-9]{3})')
year: REGEXP_EXTRACT({col}, '^[A-Z]{2}[A-Z0-9]{3}(\d{2})')

JSON Schema

finetype schema identity.commerce.isrc
{
  "$id": "https://meridian.online/schemas/identity.commerce.isrc",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "International Standard Recording Code — 12-character identifier for sound recordings and music videos. Format: CC-XXX-YY-NNNNN where CC is country code, XXX is registrant, YY is year, NNNNN is designation.",
  "examples": [
    "USUAN1400011",
    "GBAYE7700223",
    "FRUM71200001",
    "DEAB51300001"
  ],
  "maxLength": 12,
  "minLength": 12,
  "pattern": "^[A-Z]{2}[A-Z0-9]{3}\\d{7}$",
  "title": "ISRC",
  "type": "string",
  "x-finetype-broad-type": "VARCHAR",
  "x-finetype-transform": "CAST({col} AS VARCHAR)"
}

Examples

USUAN1400011GBAYE7700223FRUM71200001DEAB51300001

Aliases

recording_code

Type Registry