Entur Timetable data

This table comprises planned public transport trips, including historical and future data. Historical entries represent trips planned the day before the actual occurrence, ensuring the latest dataset update before each trip. The table is partitioned by operating_date, and using it as a required input in the WHERE filter optimizes searches and boosts query performance. The table is clustered by agency_id which can be used to further limit the search space and improve performance. The table contains data from 2023-01-01 and onward and is updated every morning at 03:00 CET.