Frictionless Table Schema
ID frictionless
other
Open specification from the Frictionless Data project for describing tabular data in JSON. A schema lists fields, each with a type and an optional format; the specification defines string formats for email addresses, URIs, UUIDs and base64 binary data, plus date and time types, years, year-months, durations, geographic points and GeoJSON. Implementations such as frictionless-py use the declared type to validate and cast values. It describes columns, it does not detect types. The supported types cover only registry datatypes that match a documented type.
- Website
- https://specs.frictionlessdata.io/table-schema/
- Supported types
- 11
Supported semantic types
| ID | Name | Categories | Countries | Description |
|---|---|---|---|---|
| date | Date | datetime | global | Calendar date. The regexp covers the ISO 8601 extended form YYYY-MM-DD; other notations, such as DD.MM.YYYY, are patterns of this datatype. |
| datetime | Date and time | datetime | global | Date and time of day. The regexp covers the ISO 8601 extended form YYYY-MM-DDThh:mm[:ss[.fff]] with an optional time zone (Z or an... |
| duration | Time duration | datetime | global | The amount of time elapsed between two events |
| Email address PII | common, internet, pii | global | Address of an electronic mailbox in the form local-part@domain, defined in section 3.4.1 of RFC 5322. The local part names the mailbox,... | |
| geojson | GeoJSON geometry draft | geo | global | Geometry, feature or feature collection written in GeoJSON (RFC 7946), the JSON format for geographic data. Positions are longitude... |
| geopoint | Geopoint draft | geo | global | Basic geopoint as coordinates |
| time | Time draft | datetime | global | Time of the day, like 12:00 or 10PM or 11:05 or 18:01:27 |
| uri | Uniform Resource Identifier (URI) draft | internet | global | Identifier of a resource in the generic syntax of RFC 3986: a scheme, a colon and a scheme-specific part, optionally followed by ?query... |
| uuid | Universally unique identifier (UUID) | identifiers | global | 128-bit identifier that systems generate without a central registry, defined by RFC 9562 (2024), which replaced RFC 4122. Microsoft... |
| year | Year | datetime | global | A calendar year in western notation like 2022 or 1913 |
| yearmonth | Year and month | datetime | global | Defines a part of a date - the year and month. Example YYYY-MM. |
Use this record
- JSON: API v1 · legacy shape
- Improve it: edit
data/tools/other/frictionless.yamlon GitHub