┌──────────────────────────┬─────────────┬─────────┬─────────┬─────────┬─────────┐
│       column_name        │ column_type │  null   │   key   │ default │  extra  │
│         varchar          │   varchar   │ varchar │ varchar │ varchar │ varchar │
├──────────────────────────┼─────────────┼─────────┼─────────┼─────────┼─────────┤
│ id                       │ VARCHAR     │ YES     │ NULL    │ NULL    │ NULL    │
│ url                      │ VARCHAR     │ YES     │ NULL    │ NULL    │ NULL    │
│ host                     │ VARCHAR     │ YES     │ NULL    │ NULL    │ NULL    │
│ domain                   │ VARCHAR     │ YES     │ NULL    │ NULL    │ NULL    │
│ ip                       │ VARCHAR     │ YES     │ NULL    │ NULL    │ NULL    │
│ timestamp                │ VARCHAR     │ YES     │ NULL    │ NULL    │ NULL    │
│ status_code              │ BIGINT      │ YES     │ NULL    │ NULL    │ NULL    │
│ content_type             │ VARCHAR     │ YES     │ NULL    │ NULL    │ NULL    │
│ content_length           │ BIGINT      │ YES     │ NULL    │ NULL    │ NULL    │
│ hop_path                 │ VARCHAR     │ YES     │ NULL    │ NULL    │ NULL    │
│ annotations              │ VARCHAR     │ YES     │ NULL    │ NULL    │ NULL    │
│ content_digest           │ VARCHAR     │ YES     │ NULL    │ NULL    │ NULL    │
│ via                      │ VARCHAR     │ YES     │ NULL    │ NULL    │ NULL    │
│ start_time_plus_duration │ VARCHAR     │ YES     │ NULL    │ NULL    │ NULL    │
│ seed                     │ VARCHAR     │ YES     │ NULL    │ NULL    │ NULL    │
│ start_time               │ TIMESTAMP   │ YES     │ NULL    │ NULL    │ NULL    │
│ duration                 │ BIGINT      │ YES     │ NULL    │ NULL    │ NULL    │
│ warc_type                │ VARCHAR     │ YES     │ NULL    │ NULL    │ NULL    │
│ warc_filename            │ VARCHAR     │ YES     │ NULL    │ NULL    │ NULL    │
│ warc_offset              │ BIGINT      │ YES     │ NULL    │ NULL    │ NULL    │
│ warc_length              │ BIGINT      │ YES     │ NULL    │ NULL    │ NULL    │
│ wire_bytes               │ BIGINT      │ YES     │ NULL    │ NULL    │ NULL    │
├──────────────────────────┴─────────────┴─────────┴─────────┴─────────┴─────────┤
│ 22 rows                                                              6 columns │
└────────────────────────────────────────────────────────────────────────────────┘

url_surtkey: Canonical form of URL with host name reversed
url: URL that was archived
url_host_name: The host name
url_host_tld: The TLD (e.g. au)
url_host_2nd_last_part, … url_host_5th_last_part: The parts of the host name separated by .
url_host_registry_suffix: e.g. .com.au
url_host_private_domain
url_protocol: e.g. https
url_port: The port accesed, it seems to be blank for default ports (80 for http, 443 for https).
url_path: The path of the URL (everything from the first / to the query parameter starting at ?)
url_query: Query parameter; everything after the ?
fetch_time: When the page was retrieved
fetch_status: The HTTP status of the request (e.g. 200 is OK)
content_digest: A digest to uniquely identify the content
content_mime_type: The type of content in the header
content_mime_detected: The type of content detected
content_charset: The characterset of the data (e.g. UTF-8)
content_languages: Languages declared of the content
warc_filename: The filename the archived data is in (ANJ: Actually the full file path)
warc_record_offset: The offset in bytes in the archived file where the corresponding data starts
warc_record_length: The length of the archived data in bytes
warc_segment: The segment the data is archived in; this is part of the filename (ANJ: path)
crawl: The id of the crawl (e.g. CC-MAIN-YYYY-WW where YYYY is the year and WW is the ISO week of the year).
subset: Is this the ‘warc’, or ‘robotstxt’, or ‘crawldiagnostics’