HTTP Status Code

technology.internet.http_status_code

HTTP response status code (100-599). Numeric string or integer. When inferred as VARCHAR, transforms to SMALLINT.

Domain

technology

Try it

CLI

$ finetype infer -i "200"
→ technology.internet.http_status_code

DuckDB

Detect

SELECT finetype('200');
-- → 'technology.internet.http_status_code'

Cast expression

CAST({col} AS SMALLINT)

Safe cast pipeline

-- Normalise and cast in one step
SELECT TRY_CAST(finetype_cast(my_column) AS SMALLINT) AS clean_value
FROM my_table
WHERE finetype(my_column) = 'technology.internet.http_status_code';

JSON Schema

finetype schema technology.internet.http_status_code

{
  "$id": "https://meridian.online/schemas/technology.internet.http_status_code",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "HTTP response status code (100-599). Numeric string or integer. When inferred as VARCHAR, transforms to SMALLINT.",
  "examples": [
    "200",
    "404",
    "500",
    "301"
  ],
  "pattern": "^([1-5][0-9]{2})$",
  "title": "HTTP Status Code",
  "type": "string",
  "x-finetype-broad-type": "VARCHAR",
  "x-finetype-transform": "CAST({col} AS SMALLINT)"
}

Examples

200404500301

Aliases

http_status