Day of the month Day of the year | | Field ID | _NORMALIZED_DATE_FIELD_DAY | | Type | DAY | | Data Type | dimension |
|
Day of the week Week of the year | | Field ID | _NORMALIZED_DATE_FIELD_DAY_OF_WEEK | | Type | DAY_OF_WEEK | | Data Type | dimension |
|
Hour of the day Hour of the day | | Field ID | _NORMALIZED_DATE_FIELD_HOUR | | Type | HOUR | | Data Type | dimension |
|
Month of the year Month of the year | | Field ID | _NORMALIZED_DATE_FIELD_MONTH | | Type | MONTH | | Data Type | dimension |
|
Month and day Month and day | | Field ID | _NORMALIZED_DATE_FIELD_MONTH_DAY | | Type | MONTH_DAY | | Data Type | dimension |
|
Quarter of the year Quarter of the year | | Field ID | _NORMALIZED_DATE_FIELD_QUARTER | | Type | QUARTER | | Data Type | dimension |
|
Week of the year Week of the year | | Field ID | _NORMALIZED_DATE_FIELD_WEEK | | Type | WEEK | | Data Type | dimension |
|
Week of the year (start Sunday) Week of the year | | Field ID | _NORMALIZED_DATE_FIELD_WEEK_START_SUNDAY | | Type | WEEK | | Data Type | dimension |
|
Year Year such as 2017. | | Field ID | _NORMALIZED_DATE_FIELD_YEAR | | Type | YEAR | | Data Type | dimension |
|
Year month Year and month. | | Field ID | _NORMALIZED_DATE_FIELD_YEAR_MONTH | | Type | YEAR_MONTH | | Data Type | dimension |
|
Date Year, month, and day. | | Field ID | _NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY | | Type | YEAR_MONTH_DAY | | Data Type | dimension |
|
Year month day hour Year, month, day, and hour. | | Field ID | _NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR | | Type | YEAR_MONTH_DAY_HOUR | | Data Type | dimension |
|
Year Quarter Year and quarter. | | Field ID | _NORMALIZED_DATE_FIELD_YEAR_QUARTER | | Type | YEAR_QUARTER | | Data Type | dimension |
|
Year week Year and week. | | Field ID | _NORMALIZED_DATE_FIELD_YEAR_WEEK | | Type | YEAR_WEEK | | Data Type | dimension |
|
Airtable Base ID The Airtable base identifier that owns the selected table. | | Field ID | _airtable_base_id | | Type | TEXT | | Data Type | dimension |
|
Airtable Base Name The Airtable base name that owns the selected table. | | Field ID | _airtable_base_name | | Type | TEXT | | Data Type | dimension |
|
Airtable Created Time The record creation timestamp returned by Airtable for the selected row. | | Field ID | _airtable_created_time | | Type | YEAR_MONTH_DAY_SECOND | | Data Type | dimension |
|
Airtable Record ID The Airtable record identifier returned for the selected table row. | | Field ID | _airtable_record_id | | Type | TEXT | | Data Type | dimension |
|
Airtable Table ID The Airtable table identifier selected in Catchr. | | Field ID | _airtable_table_id | | Type | TEXT | | Data Type | dimension |
|
Airtable Table Name The Airtable table name selected in Catchr. | | Field ID | _airtable_table_name | | Type | TEXT | | Data Type | dimension |
|
.svg){kind=logo}