Zoom Connector Reference

20 metrics249 dimensions

The Zoom connector exposes 269 fields (20 metrics, 249 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.


Zoom Fields

Zoom General fields

The General report of the Zoom connector includes 3 fields.

ID Type Name Description
account_id TEXT Account ID The unique identifier for the account.
account_name TEXT Account Name The name of the account.
date DATE Date The date of the record.

Zoom meeting_poll_results fields

The meeting_poll_results report of the Zoom connector includes 7 fields.

ID Type Name Description
meeting_poll_results__email TEXT meeting_poll_results.email meeting_poll_results.email
meeting_poll_results__first_name TEXT meeting_poll_results.first_name meeting_poll_results.first_name
meeting_poll_results__last_name TEXT meeting_poll_results.last_name meeting_poll_results.last_name
meeting_poll_results__meeting_id TEXT meeting_poll_results.meeting_id meeting_poll_results.meeting_id
meeting_poll_results__meeting_uuid TEXT meeting_poll_results.meeting_uuid meeting_poll_results.meeting_uuid
meeting_poll_results__name TEXT meeting_poll_results.name meeting_poll_results.name
meeting_poll_results__question_details OBJECT meeting_poll_results.question_details meeting_poll_results.question_details

Zoom meeting_polls fields

The meeting_polls report of the Zoom connector includes 7 fields.

ID Type Name Description
meeting_polls__anonymous BOOLEAN meeting_polls.anonymous meeting_polls.anonymous
meeting_polls__id TEXT meeting_polls.id meeting_polls.id
meeting_polls__meeting_id TEXT meeting_polls.meeting_id meeting_polls.meeting_id
meeting_polls__poll_type NUMERIC meeting_polls.poll_type meeting_polls.poll_type
meeting_polls__questions OBJECT meeting_polls.questions meeting_polls.questions
meeting_polls__status TEXT meeting_polls.status meeting_polls.status
meeting_polls__title TEXT meeting_polls.title meeting_polls.title

Zoom meeting_registrants fields

The meeting_registrants report of the Zoom connector includes 22 fields.

ID Type Name Description
meeting_registrants__address TEXT meeting_registrants.address meeting_registrants.address
meeting_registrants__city CITY meeting_registrants.city meeting_registrants.city
meeting_registrants__comments TEXT meeting_registrants.comments meeting_registrants.comments
meeting_registrants__country COUNTRY meeting_registrants.country meeting_registrants.country
meeting_registrants__create_time TIMESTAMP meeting_registrants.create_time meeting_registrants.create_time
meeting_registrants__custom_questions OBJECT meeting_registrants.custom_questions meeting_registrants.custom_questions
meeting_registrants__email TEXT meeting_registrants.email meeting_registrants.email
meeting_registrants__first_name TEXT meeting_registrants.first_name meeting_registrants.first_name
meeting_registrants__id TEXT meeting_registrants.id meeting_registrants.id
meeting_registrants__industry TEXT meeting_registrants.industry meeting_registrants.industry
meeting_registrants__job_title TEXT meeting_registrants.job_title meeting_registrants.job_title
meeting_registrants__join_url TEXT meeting_registrants.join_url meeting_registrants.join_url
meeting_registrants__last_name TEXT meeting_registrants.last_name meeting_registrants.last_name
meeting_registrants__meeting_id TEXT meeting_registrants.meeting_id meeting_registrants.meeting_id
meeting_registrants__no_of_employees TEXT meeting_registrants.no_of_employees meeting_registrants.no_of_employees
meeting_registrants__org TEXT meeting_registrants.org meeting_registrants.org
meeting_registrants__phone TEXT meeting_registrants.phone meeting_registrants.phone
meeting_registrants__purchasing_time_frame TEXT meeting_registrants.purchasing_time_frame meeting_registrants.purchasing_time_frame
meeting_registrants__role_in_purchase_process TEXT meeting_registrants.role_in_purchase_process meeting_registrants.role_in_purchase_process
meeting_registrants__state TEXT meeting_registrants.state meeting_registrants.state
meeting_registrants__status TEXT meeting_registrants.status meeting_registrants.status
meeting_registrants__zip TEXT meeting_registrants.zip meeting_registrants.zip

Zoom meeting_registration_questions fields

The meeting_registration_questions report of the Zoom connector includes 3 fields.

ID Type Name Description
meeting_registration_questions__custom_questions OBJECT meeting_registration_questions.custom_questions meeting_registration_questions.custom_questions
meeting_registration_questions__meeting_id TEXT meeting_registration_questions.meeting_id meeting_registration_questions.meeting_id
meeting_registration_questions__questions OBJECT meeting_registration_questions.questions meeting_registration_questions.questions

Zoom meetings fields

The meetings report of the Zoom connector includes 28 fields.

ID Type Name Description
meetings__agenda TEXT meetings.agenda meetings.agenda
meetings__assistant_id TEXT meetings.assistant_id meetings.assistant_id
meetings__chat_join_url TEXT meetings.chat_join_url meetings.chat_join_url
meetings__created_at TIMESTAMP meetings.created_at meetings.created_at
meetings__duration NUMERIC meetings.duration meetings.duration
meetings__encrypted_password TEXT meetings.encrypted_password meetings.encrypted_password
meetings__h323_password TEXT meetings.h323_password meetings.h323_password
meetings__host_email TEXT meetings.host_email meetings.host_email
meetings__host_id TEXT meetings.host_id meetings.host_id
meetings__id TEXT meetings.id meetings.id
meetings__join_url TEXT meetings.join_url meetings.join_url
meetings__occurrences OBJECT meetings.occurrences meetings.occurrences
meetings__password TEXT meetings.password meetings.password
meetings__pmi TEXT meetings.pmi meetings.pmi
meetings__pre_schedule BOOLEAN meetings.pre_schedule meetings.pre_schedule
meetings__pstn_password TEXT meetings.pstn_password meetings.pstn_password
meetings__recurrence OBJECT meetings.recurrence meetings.recurrence
meetings__registration_url TEXT meetings.registration_url meetings.registration_url
meetings__resources OBJECT meetings.resources meetings.resources
meetings__settings OBJECT meetings.settings meetings.settings
meetings__start_time TIMESTAMP meetings.start_time meetings.start_time
meetings__start_url TEXT meetings.start_url meetings.start_url
meetings__status TEXT meetings.status meetings.status
meetings__timezone TEXT meetings.timezone meetings.timezone
meetings__topic TEXT meetings.topic meetings.topic
meetings__tracking_fields OBJECT meetings.tracking_fields meetings.tracking_fields
meetings__type NUMERIC meetings.type meetings.type
meetings__uuid TEXT meetings.uuid meetings.uuid

Zoom report_meeting_participants fields

The report_meeting_participants report of the Zoom connector includes 16 fields.

ID Type Name Description
report_meeting_participants__attentiveness_score TEXT report_meeting_participants.attentiveness_score report_meeting_participants.attentiveness_score
report_meeting_participants__bo_mtg_id TEXT report_meeting_participants.bo_mtg_id report_meeting_participants.bo_mtg_id
report_meeting_participants__customer_key TEXT report_meeting_participants.customer_key report_meeting_participants.customer_key
report_meeting_participants__duration NUMERIC report_meeting_participants.duration report_meeting_participants.duration
report_meeting_participants__failover BOOLEAN report_meeting_participants.failover report_meeting_participants.failover
report_meeting_participants__id TEXT report_meeting_participants.id report_meeting_participants.id
report_meeting_participants__join_time TIMESTAMP report_meeting_participants.join_time report_meeting_participants.join_time
report_meeting_participants__leave_time TIMESTAMP report_meeting_participants.leave_time report_meeting_participants.leave_time
report_meeting_participants__meeting_id TEXT report_meeting_participants.meeting_id report_meeting_participants.meeting_id
report_meeting_participants__meeting_uuid TEXT report_meeting_participants.meeting_uuid report_meeting_participants.meeting_uuid
report_meeting_participants__name TEXT report_meeting_participants.name report_meeting_participants.name
report_meeting_participants__participant_user_id TEXT report_meeting_participants.participant_user_id report_meeting_participants.participant_user_id
report_meeting_participants__registrant_id TEXT report_meeting_participants.registrant_id report_meeting_participants.registrant_id
report_meeting_participants__status TEXT report_meeting_participants.status report_meeting_participants.status
report_meeting_participants__user_email TEXT report_meeting_participants.user_email report_meeting_participants.user_email
report_meeting_participants__user_id TEXT report_meeting_participants.user_id report_meeting_participants.user_id

Zoom report_meetings fields

The report_meetings report of the Zoom connector includes 16 fields.

ID Type Name Description
report_meetings__custom_keys OBJECT report_meetings.custom_keys report_meetings.custom_keys
report_meetings__dept TEXT report_meetings.dept report_meetings.dept
report_meetings__duration NUMERIC report_meetings.duration report_meetings.duration
report_meetings__end_time TIMESTAMP report_meetings.end_time report_meetings.end_time
report_meetings__host_id TEXT report_meetings.host_id report_meetings.host_id
report_meetings__id TEXT report_meetings.id report_meetings.id
report_meetings__meeting_uuid TEXT report_meetings.meeting_uuid report_meetings.meeting_uuid
report_meetings__participants_count NUMERIC report_meetings.participants_count report_meetings.participants_count
report_meetings__start_time TIMESTAMP report_meetings.start_time report_meetings.start_time
report_meetings__topic TEXT report_meetings.topic report_meetings.topic
report_meetings__total_minutes NUMERIC report_meetings.total_minutes report_meetings.total_minutes
report_meetings__tracking_fields OBJECT report_meetings.tracking_fields report_meetings.tracking_fields
report_meetings__type NUMERIC report_meetings.type report_meetings.type
report_meetings__user_email TEXT report_meetings.user_email report_meetings.user_email
report_meetings__user_name TEXT report_meetings.user_name report_meetings.user_name
report_meetings__uuid TEXT report_meetings.uuid report_meetings.uuid

Zoom report_webinar_participants fields

The report_webinar_participants report of the Zoom connector includes 13 fields.

ID Type Name Description
report_webinar_participants__customer_key TEXT report_webinar_participants.customer_key report_webinar_participants.customer_key
report_webinar_participants__duration NUMERIC report_webinar_participants.duration report_webinar_participants.duration
report_webinar_participants__failover BOOLEAN report_webinar_participants.failover report_webinar_participants.failover
report_webinar_participants__id TEXT report_webinar_participants.id report_webinar_participants.id
report_webinar_participants__join_time TIMESTAMP report_webinar_participants.join_time report_webinar_participants.join_time
report_webinar_participants__leave_time TIMESTAMP report_webinar_participants.leave_time report_webinar_participants.leave_time
report_webinar_participants__name TEXT report_webinar_participants.name report_webinar_participants.name
report_webinar_participants__registrant_id TEXT report_webinar_participants.registrant_id report_webinar_participants.registrant_id
report_webinar_participants__status TEXT report_webinar_participants.status report_webinar_participants.status
report_webinar_participants__user_email TEXT report_webinar_participants.user_email report_webinar_participants.user_email
report_webinar_participants__user_id TEXT report_webinar_participants.user_id report_webinar_participants.user_id
report_webinar_participants__webinar_id TEXT report_webinar_participants.webinar_id report_webinar_participants.webinar_id
report_webinar_participants__webinar_uuid TEXT (Deprecated) report_webinar_participants.webinar_uuid (Deprecated) report_webinar_participants.webinar_uuid

Zoom report_webinars fields

The report_webinars report of the Zoom connector includes 15 fields.

ID Type Name Description
report_webinars__custom_keys OBJECT report_webinars.custom_keys report_webinars.custom_keys
report_webinars__dept TEXT report_webinars.dept report_webinars.dept
report_webinars__duration NUMERIC report_webinars.duration report_webinars.duration
report_webinars__end_time TIMESTAMP report_webinars.end_time report_webinars.end_time
report_webinars__id TEXT report_webinars.id report_webinars.id
report_webinars__participants_count NUMERIC report_webinars.participants_count report_webinars.participants_count
report_webinars__start_time TIMESTAMP report_webinars.start_time report_webinars.start_time
report_webinars__topic TEXT report_webinars.topic report_webinars.topic
report_webinars__total_minutes NUMERIC report_webinars.total_minutes report_webinars.total_minutes
report_webinars__tracking_fields OBJECT report_webinars.tracking_fields report_webinars.tracking_fields
report_webinars__type NUMERIC report_webinars.type report_webinars.type
report_webinars__user_email TEXT report_webinars.user_email report_webinars.user_email
report_webinars__user_name TEXT report_webinars.user_name report_webinars.user_name
report_webinars__uuid TEXT report_webinars.uuid report_webinars.uuid
report_webinars__webinar_uuid TEXT report_webinars.webinar_uuid report_webinars.webinar_uuid

Zoom users fields

The users report of the Zoom connector includes 23 fields.

ID Type Name Description
users__created_at TIMESTAMP users.created_at users.created_at
users__custom_attributes OBJECT users.custom_attributes users.custom_attributes
users__dept TEXT users.dept users.dept
users__display_name TEXT users.display_name users.display_name
users__email TEXT users.email users.email
users__employee_unique_id TEXT users.employee_unique_id users.employee_unique_id
users__first_name TEXT users.first_name users.first_name
users__group_ids OBJECT users.group_ids users.group_ids
users__id TEXT users.id users.id
users__im_group_ids OBJECT users.im_group_ids users.im_group_ids
users__language TEXT users.language users.language
users__last_client_version TEXT users.last_client_version users.last_client_version
users__last_login_time TIMESTAMP users.last_login_time users.last_login_time
users__last_name TEXT users.last_name users.last_name
users__phone_number TEXT users.phone_number users.phone_number
users__plan_united_type TEXT users.plan_united_type users.plan_united_type
users__pmi TEXT users.pmi users.pmi
users__role_id TEXT users.role_id users.role_id
users__status TEXT users.status users.status
users__timezone TEXT users.timezone users.timezone
users__type NUMERIC users.type users.type
users__user_created_at TIMESTAMP users.user_created_at users.user_created_at
users__verified NUMERIC users.verified users.verified

Zoom webinar_absentees fields

The webinar_absentees report of the Zoom connector includes 22 fields.

ID Type Name Description
webinar_absentees__address TEXT webinar_absentees.address webinar_absentees.address
webinar_absentees__city CITY webinar_absentees.city webinar_absentees.city
webinar_absentees__comments TEXT webinar_absentees.comments webinar_absentees.comments
webinar_absentees__country COUNTRY webinar_absentees.country webinar_absentees.country
webinar_absentees__create_time TIMESTAMP webinar_absentees.create_time webinar_absentees.create_time
webinar_absentees__custom_questions OBJECT webinar_absentees.custom_questions webinar_absentees.custom_questions
webinar_absentees__email TEXT webinar_absentees.email webinar_absentees.email
webinar_absentees__first_name TEXT webinar_absentees.first_name webinar_absentees.first_name
webinar_absentees__id TEXT webinar_absentees.id webinar_absentees.id
webinar_absentees__industry TEXT webinar_absentees.industry webinar_absentees.industry
webinar_absentees__job_title TEXT webinar_absentees.job_title webinar_absentees.job_title
webinar_absentees__join_url TEXT webinar_absentees.join_url webinar_absentees.join_url
webinar_absentees__last_name TEXT webinar_absentees.last_name webinar_absentees.last_name
webinar_absentees__no_of_employees TEXT webinar_absentees.no_of_employees webinar_absentees.no_of_employees
webinar_absentees__org TEXT webinar_absentees.org webinar_absentees.org
webinar_absentees__phone TEXT webinar_absentees.phone webinar_absentees.phone
webinar_absentees__purchasing_time_frame TEXT webinar_absentees.purchasing_time_frame webinar_absentees.purchasing_time_frame
webinar_absentees__role_in_purchase_process TEXT webinar_absentees.role_in_purchase_process webinar_absentees.role_in_purchase_process
webinar_absentees__state TEXT webinar_absentees.state webinar_absentees.state
webinar_absentees__status TEXT webinar_absentees.status webinar_absentees.status
webinar_absentees__webinar_uuid TEXT webinar_absentees.webinar_uuid webinar_absentees.webinar_uuid
webinar_absentees__zip TEXT webinar_absentees.zip webinar_absentees.zip

Zoom webinar_panelists fields

The webinar_panelists report of the Zoom connector includes 10 fields.

ID Type Name Description
webinar_panelists__email TEXT webinar_panelists.email webinar_panelists.email
webinar_panelists__id TEXT webinar_panelists.id webinar_panelists.id
webinar_panelists__join_url TEXT webinar_panelists.join_url webinar_panelists.join_url
webinar_panelists__name TEXT webinar_panelists.name webinar_panelists.name
webinar_panelists__name_tag_description TEXT webinar_panelists.name_tag_description webinar_panelists.name_tag_description
webinar_panelists__name_tag_id TEXT webinar_panelists.name_tag_id webinar_panelists.name_tag_id
webinar_panelists__name_tag_name TEXT webinar_panelists.name_tag_name webinar_panelists.name_tag_name
webinar_panelists__name_tag_pronouns TEXT webinar_panelists.name_tag_pronouns webinar_panelists.name_tag_pronouns
webinar_panelists__virtual_background_id TEXT webinar_panelists.virtual_background_id webinar_panelists.virtual_background_id
webinar_panelists__webinar_id TEXT webinar_panelists.webinar_id webinar_panelists.webinar_id

Zoom webinar_poll_results fields

The webinar_poll_results report of the Zoom connector includes 4 fields.

ID Type Name Description
webinar_poll_results__email TEXT webinar_poll_results.email webinar_poll_results.email
webinar_poll_results__name TEXT webinar_poll_results.name webinar_poll_results.name
webinar_poll_results__question_details OBJECT webinar_poll_results.question_details webinar_poll_results.question_details
webinar_poll_results__webinar_uuid TEXT webinar_poll_results.webinar_uuid webinar_poll_results.webinar_uuid

Zoom webinar_polls fields

The webinar_polls report of the Zoom connector includes 7 fields.

ID Type Name Description
webinar_polls__anonymous BOOLEAN webinar_polls.anonymous webinar_polls.anonymous
webinar_polls__id TEXT webinar_polls.id webinar_polls.id
webinar_polls__poll_type NUMERIC webinar_polls.poll_type webinar_polls.poll_type
webinar_polls__questions OBJECT webinar_polls.questions webinar_polls.questions
webinar_polls__status TEXT webinar_polls.status webinar_polls.status
webinar_polls__title TEXT webinar_polls.title webinar_polls.title
webinar_polls__webinar_id TEXT webinar_polls.webinar_id webinar_polls.webinar_id

Zoom webinar_qna_results fields

The webinar_qna_results report of the Zoom connector includes 4 fields.

ID Type Name Description
webinar_qna_results__email TEXT webinar_qna_results.email webinar_qna_results.email
webinar_qna_results__name TEXT webinar_qna_results.name webinar_qna_results.name
webinar_qna_results__question_details OBJECT webinar_qna_results.question_details webinar_qna_results.question_details
webinar_qna_results__webinar_uuid TEXT webinar_qna_results.webinar_uuid webinar_qna_results.webinar_uuid

Zoom webinar_registrants fields

The webinar_registrants report of the Zoom connector includes 22 fields.

ID Type Name Description
webinar_registrants__address TEXT webinar_registrants.address webinar_registrants.address
webinar_registrants__city CITY webinar_registrants.city webinar_registrants.city
webinar_registrants__comments TEXT webinar_registrants.comments webinar_registrants.comments
webinar_registrants__country COUNTRY webinar_registrants.country webinar_registrants.country
webinar_registrants__create_time TIMESTAMP webinar_registrants.create_time webinar_registrants.create_time
webinar_registrants__custom_questions OBJECT webinar_registrants.custom_questions webinar_registrants.custom_questions
webinar_registrants__email TEXT webinar_registrants.email webinar_registrants.email
webinar_registrants__first_name TEXT webinar_registrants.first_name webinar_registrants.first_name
webinar_registrants__id TEXT webinar_registrants.id webinar_registrants.id
webinar_registrants__industry TEXT webinar_registrants.industry webinar_registrants.industry
webinar_registrants__job_title TEXT webinar_registrants.job_title webinar_registrants.job_title
webinar_registrants__join_url TEXT webinar_registrants.join_url webinar_registrants.join_url
webinar_registrants__last_name TEXT webinar_registrants.last_name webinar_registrants.last_name
webinar_registrants__no_of_employees TEXT webinar_registrants.no_of_employees webinar_registrants.no_of_employees
webinar_registrants__org TEXT webinar_registrants.org webinar_registrants.org
webinar_registrants__phone TEXT webinar_registrants.phone webinar_registrants.phone
webinar_registrants__purchasing_time_frame TEXT webinar_registrants.purchasing_time_frame webinar_registrants.purchasing_time_frame
webinar_registrants__role_in_purchase_process TEXT webinar_registrants.role_in_purchase_process webinar_registrants.role_in_purchase_process
webinar_registrants__state TEXT webinar_registrants.state webinar_registrants.state
webinar_registrants__status TEXT webinar_registrants.status webinar_registrants.status
webinar_registrants__webinar_id TEXT webinar_registrants.webinar_id webinar_registrants.webinar_id
webinar_registrants__zip TEXT webinar_registrants.zip webinar_registrants.zip

Zoom webinar_registration_questions fields

The webinar_registration_questions report of the Zoom connector includes 3 fields.

ID Type Name Description
webinar_registration_questions__custom_questions OBJECT webinar_registration_questions.custom_questions webinar_registration_questions.custom_questions
webinar_registration_questions__questions OBJECT webinar_registration_questions.questions webinar_registration_questions.questions
webinar_registration_questions__webinar_id TEXT webinar_registration_questions.webinar_id webinar_registration_questions.webinar_id

Zoom webinar_tracking_sources fields

The webinar_tracking_sources report of the Zoom connector includes 6 fields.

ID Type Name Description
webinar_tracking_sources__id TEXT webinar_tracking_sources.id webinar_tracking_sources.id
webinar_tracking_sources__registration_count NUMERIC webinar_tracking_sources.registration_count webinar_tracking_sources.registration_count
webinar_tracking_sources__source_name TEXT webinar_tracking_sources.source_name webinar_tracking_sources.source_name
webinar_tracking_sources__tracking_url TEXT webinar_tracking_sources.tracking_url webinar_tracking_sources.tracking_url
webinar_tracking_sources__visitor_count NUMERIC webinar_tracking_sources.visitor_count webinar_tracking_sources.visitor_count
webinar_tracking_sources__webinar_id TEXT webinar_tracking_sources.webinar_id webinar_tracking_sources.webinar_id

Zoom webinars fields

The webinars report of the Zoom connector includes 20 fields.

ID Type Name Description
webinars__agenda TEXT webinars.agenda webinars.agenda
webinars__created_at TIMESTAMP webinars.created_at webinars.created_at
webinars__duration NUMERIC webinars.duration webinars.duration
webinars__host_email TEXT webinars.host_email webinars.host_email
webinars__host_id TEXT webinars.host_id webinars.host_id
webinars__id TEXT webinars.id webinars.id
webinars__is_simulive BOOLEAN webinars.is_simulive webinars.is_simulive
webinars__join_url TEXT webinars.join_url webinars.join_url
webinars__occurrences OBJECT webinars.occurrences webinars.occurrences
webinars__password TEXT webinars.password webinars.password
webinars__record_file_id TEXT webinars.record_file_id webinars.record_file_id
webinars__recurrence OBJECT webinars.recurrence webinars.recurrence
webinars__settings OBJECT webinars.settings webinars.settings
webinars__start_time TIMESTAMP webinars.start_time webinars.start_time
webinars__start_url TEXT webinars.start_url webinars.start_url
webinars__timezone TEXT webinars.timezone webinars.timezone
webinars__topic TEXT webinars.topic webinars.topic
webinars__tracking_fields OBJECT webinars.tracking_fields webinars.tracking_fields
webinars__type NUMERIC webinars.type webinars.type
webinars__uuid TEXT webinars.uuid webinars.uuid

Zoom other fields

The Zoom connector has 18 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID Type Name Description Report
data_fetched_at TIMESTAMP Data fetched at UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource TEXT Data Source The name of the Windsor connector returning the row
day_of_month TEXT Day of month Day of the month
month TEXT Month Number of the month
now TIMESTAMP Now Current timestamp
source TEXT Source The name of the Windsor connector returning the row
today DATE Today Today's date
week TEXT Week Week (Sun-Sat).
week_day TEXT Day of week and day number Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_iso TEXT Day of week and day number, ISO Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_iso TEXT Week ISO Week, ISO format (Mon-Sun).
year TEXT Year Year
year_month TEXT Yearmonth Year and month, e.g. 2024|3
year_month_name TEXT Year month name Year and month with the month name written out, e.g. "Jan 2025".
year_of_week TEXT Year of week The year that contains first day of the week (Sun-Sat).
year_of_week_iso TEXT Year of week, ISO The year that contains first day of the ISO week (Mon-Sun).
year_week TEXT Year week Year and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_iso TEXT Year week ISO Year and week for ISO weeks (Mon-Sun), e.g. 2024|20