Skip to content

HTTP Status Code

Type Registry

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›internet
Casts to SMALLINT
Scope Universal

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://noon.sh/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"
}

Examples

200404500301

Also known as

http_status

Types in technology