About this Dataset

Northern Ireland Traffic Count Data

Annual traffic count data collected by the Department for Infrastructure at permanent counter sites across Northern Ireland from 2012
Publisher name: OpenDataNI
Last updated: 2024-12-24T04:01:25Z

Tables

Northern Ireland Traffic Count Data 2012 Summary

@ukgov.northern_ireland_traffic_count_data.northern_ireland_traffic_count_data_2012_summary

112.74 kB
346 rows
50 columns

CREATE TABLE northern_ireland_traffic_count_data_2012_summary (
  "cp_no" BIGINT  -- CP No.,
  "route" VARCHAR,
  "divn" VARCHAR  -- Divn.,
  "location" VARCHAR,
  "channel_1" VARCHAR,
  "channel_2" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "n_24_hour_aadt_7_day_flow" DOUBLE  -- 24 Hour AADT (7 Day Flow),
  "n_24_hour_aadt_7_day_flow_rounded" DOUBLE  -- 24 Hour AADT (7 Day Flow) Rounded,
  "n__hgv_7_day_flow" VARCHAR  -- % HGV (7 Day Flow),
  "am_mean_weekday_peak_hour_5_day_flow" DOUBLE  -- AM Mean Weekday Peak Hour (5 Day Flow),
  "am_mean_weekday_peak_hour_5_day_flow_rounded" DOUBLE  -- AM Mean Weekday Peak Hour (5 Day Flow) Rounded,
  "am_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR  -- AM Mean Weekday Peak Hour (5 Day Flow) Start Time,
  "pm_mean_weekday_peak_hour_5_day_flow" DOUBLE  -- PM Mean Weekday Peak Hour (5 Day Flow),
  "pm_mean_weekday_peak_hour_5_day_flow_rounded" DOUBLE  -- PM Mean Weekday Peak Hour (5 Day Flow) Rounded,
  "pm_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR  -- PM Mean Weekday Peak Hour (5 Day Flow) Start Time,
  "n_24_hour_7_day_flow_ch_1" DOUBLE  -- 24 Hour 7 Day Flow CH. 1,
  "n_24_hour_7_day_flow_ch_2" DOUBLE  -- 24 Hour 7 Day Flow CH. 2,
  "n_24_hour_7_day_flow_ch_1_rounded" DOUBLE  -- 24 Hour 7 Day Flow CH. 1 (rounded),
  "n_24_hour_7_day_flow_ch_2_rounded" VARCHAR  -- 24 Hour 7 Day Flow CH. 2 (rounded),
  "percentage_traffic_composition_car_van" VARCHAR  -- Percentage Traffic Composition (car / Van),
  "percentage_traffic_composition_med_com" VARCHAR  -- Percentage Traffic Composition (med Com),
  "percentage_traffic_composition_rigid" VARCHAR  -- Percentage Traffic Composition (rigid),
  "percentage_traffic_composition_artic" VARCHAR  -- Percentage Traffic Composition (artic),
  "percentage_traffic_composition_bus_coach" VARCHAR  -- Percentage Traffic Composition (bus / Coach),
  "n_24_hour_5_day_flow_ch_1" DOUBLE  -- 24 Hour 5 Day Flow CH. 1,
  "n_24_hour_5_day_flow_ch_2" DOUBLE  -- 24 Hour 5 Day Flow CH. 2,
  "n_24_hour_aadt_5_day_flow" DOUBLE  -- 24 Hour AADT (5 Day Flow),
  "n_24_hour_5_day_flow_ch_1_rounded" DOUBLE  -- 24 Hour 5 Day Flow CH. 1 (rounded),
  "n_24_hour_5_day_flow_ch_2_rounded" DOUBLE  -- 24 Hour 5 Day Flow CH. 2 (rounded),
  "n_24_hour_aadt_5_day_flow_rounded" DOUBLE  -- 24 Hour AADT (5 Day Flow) Rounded,
  "am_peak_hour_flow_weekday_channel_1" DOUBLE,
  "am_peak_hour_flow_weekday_channel_1_rounded" DOUBLE  -- AM Peak Hour Flow Weekday Channel 1 (rounded),
  "am_peak_hour_flow_weekday_channel_1_start_time" VARCHAR,
  "pm_peak_hour_flow_weekday_channel_1" VARCHAR,
  "pm_peak_hour_flow_weekday_channel_1_rounded" VARCHAR  -- PM Peak Hour Flow Weekday Channel 1 (rounded),
  "pm_peak_hour_flow_weekday_channel_1_start_time" VARCHAR,
  "am_peak_hour_flow_weekday_channel_2" DOUBLE,
  "am_peak_hour_flow_weekday_channel_2_rounded" DOUBLE  -- AM Peak Hour Flow Weekday Channel 2 (rounded),
  "am_peak_hour_flow_weekday_channel_2_start_time" VARCHAR,
  "pm_peak_hour_flow_weekday_channel_2" DOUBLE,
  "pm_peak_hour_flow_weekday_channel_2_rounded" DOUBLE  -- PM Peak Hour Flow Weekday Channel 2 (rounded),
  "pm_peak_hour_flow_weekday_channel_2_start_time" VARCHAR,
  "n_2010_24_hour_aadt_7_day_flow_rounded" DOUBLE  -- 2010–24 Hour AADT (7 Day Flow) Rounded,
  "n_2011_age_incr_decr_over_2010_24hraadt_7_day_flow" DOUBLE  -- 2011 %age Incr/decr Over 2010–24HrAADT (7 Day Flow),
  "n_2011_24_hour_aadt_7_day_flow_rounded" DOUBLE  -- 2011–24 Hour AADT (7 Day Flow) Rounded,
  "n_2012_age_incr_decr_over_2011_24hraadt_7_day_flow" DOUBLE  -- 2012 %age Incr/decr Over 2011–24HrAADT (7 Day Flow),
  "n_2012_24_hour_aadt_7_day_flow_rounded" DOUBLE  -- 2012–24 Hour AADT (7 Day Flow) Rounded,
  "comments" VARCHAR
);

Northern Ireland Traffic Count Data 2013 Summary

@ukgov.northern_ireland_traffic_count_data.northern_ireland_traffic_count_data_2013_summary

115.53 kB
351 rows
50 columns

CREATE TABLE northern_ireland_traffic_count_data_2013_summary (
  "cp_no" BIGINT  -- CP No.,
  "route" VARCHAR,
  "divn" VARCHAR  -- Divn.,
  "location" VARCHAR,
  "channel_1" VARCHAR,
  "channel_2" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "n_24_hour_aadt_7_day_flow" VARCHAR  -- 24 Hour AADT (7 Day Flow),
  "n_24_hour_aadt_7_day_flow_rounded" DOUBLE  -- 24 Hour AADT (7 Day Flow) Rounded,
  "n__hgv_7_day_flow" DOUBLE  -- % HGV (7 Day Flow),
  "am_mean_weekday_peak_hour_5_day_flow" DOUBLE  -- AM Mean Weekday Peak Hour (5 Day Flow),
  "am_mean_weekday_peak_hour_5_day_flow_rounded" DOUBLE  -- AM Mean Weekday Peak Hour (5 Day Flow) Rounded,
  "am_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR  -- AM Mean Weekday Peak Hour (5 Day Flow) Start Time,
  "pm_mean_weekday_peak_hour_5_day_flow" DOUBLE  -- PM Mean Weekday Peak Hour (5 Day Flow),
  "pm_mean_weekday_peak_hour_5_day_flow_rounded" DOUBLE  -- PM Mean Weekday Peak Hour (5 Day Flow) Rounded,
  "pm_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR  -- PM Mean Weekday Peak Hour (5 Day Flow) Start Time,
  "n_24_hour_7_day_flow_ch_1" DOUBLE  -- 24 Hour 7 Day Flow CH. 1,
  "n_24_hour_7_day_flow_ch_2" VARCHAR  -- 24 Hour 7 Day Flow CH. 2,
  "n_24_hour_7_day_flow_ch_1_rounded" DOUBLE  -- 24 Hour 7 Day Flow CH. 1 (rounded),
  "n_24_hour_7_day_flow_ch_2_rounded" DOUBLE  -- 24 Hour 7 Day Flow CH. 2 (rounded),
  "percentage_traffic_composition_car_van" DOUBLE  -- Percentage Traffic Composition (car / Van),
  "percentage_traffic_composition_med_com" DOUBLE  -- Percentage Traffic Composition (med Com),
  "percentage_traffic_composition_rigid" DOUBLE  -- Percentage Traffic Composition (rigid),
  "percentage_traffic_composition_artic" DOUBLE  -- Percentage Traffic Composition (artic),
  "percentage_traffic_composition_bus_coach" DOUBLE  -- Percentage Traffic Composition (bus / Coach),
  "n_24_hour_5_day_flow_ch_1" DOUBLE  -- 24 Hour 5 Day Flow CH. 1,
  "n_24_hour_5_day_flow_ch_2" VARCHAR  -- 24 Hour 5 Day Flow CH. 2,
  "n_24_hour_aadt_5_day_flow" DOUBLE  -- 24 Hour AADT (5 Day Flow),
  "n_24_hour_5_day_flow_ch_1_rounded" DOUBLE  -- 24 Hour 5 Day Flow CH. 1 (rounded),
  "n_24_hour_5_day_flow_ch_2_rounded" DOUBLE  -- 24 Hour 5 Day Flow CH. 2 (rounded),
  "n_24_hour_aadt_5_day_flow_rounded" DOUBLE  -- 24 Hour AADT (5 Day Flow) Rounded,
  "am_peak_hour_flow_weekday_channel_1" DOUBLE,
  "am_peak_hour_flow_weekday_channel_1_rounded" DOUBLE  -- AM Peak Hour Flow Weekday Channel 1 (rounded),
  "am_peak_hour_flow_weekday_channel_1_start_time" VARCHAR,
  "pm_peak_hour_flow_weekday_channel_1" DOUBLE,
  "pm_peak_hour_flow_weekday_channel_1_rounded" DOUBLE  -- PM Peak Hour Flow Weekday Channel 1 (rounded),
  "pm_peak_hour_flow_weekday_channel_1_start_time" VARCHAR,
  "am_peak_hour_flow_weekday_channel_2" DOUBLE,
  "am_peak_hour_flow_weekday_channel_2_rounded" DOUBLE  -- AM Peak Hour Flow Weekday Channel 2 (rounded),
  "am_peak_hour_flow_weekday_channel_2_start_time" VARCHAR,
  "pm_peak_hour_flow_weekday_channel_2" DOUBLE,
  "pm_peak_hour_flow_weekday_channel_2_rounded" DOUBLE  -- PM Peak Hour Flow Weekday Channel 2 (rounded),
  "pm_peak_hour_flow_weekday_channel_2_start_time" VARCHAR,
  "n_2011_24_hour_aadt_7_day_flow_rounded" VARCHAR  -- 2011–24 Hour AADT (7 Day Flow) Rounded,
  "n_2012_age_incr_decr_over_2011_24hraadt_7_day_flow" VARCHAR  -- 2012 %age Incr/decr Over 2011–24HrAADT (7 Day Flow),
  "n_2012_24_hour_aadt_7_day_flow_rounded" DOUBLE  -- 2012–24 Hour AADT (7 Day Flow) Rounded,
  "n_2013_age_incr_decr_over_2012_24hraadt_7_day_flow" VARCHAR  -- 2013 %age Incr/decr Over 2012–24HrAADT (7 Day Flow),
  "n_2013_24_hour_aadt_7_day_flow_rounded" VARCHAR  -- 2013–24 Hour AADT (7 Day Flow) Rounded,
  "comments" VARCHAR
);

Northern Ireland Traffic Count Data 2014 Summary

@ukgov.northern_ireland_traffic_count_data.northern_ireland_traffic_count_data_2014_summary

117.19 kB
351 rows
50 columns

CREATE TABLE northern_ireland_traffic_count_data_2014_summary (
  "cp_no" BIGINT  -- CP No.,
  "route" VARCHAR,
  "divn" VARCHAR  -- Divn.,
  "location" VARCHAR,
  "channel_1" VARCHAR,
  "channel_2" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "n_24_hour_aadt_7_day_flow" VARCHAR  -- 24 Hour AADT (7 Day Flow),
  "n_24_hour_aadt_7_day_flow_rounded" BIGINT  -- 24 Hour AADT (7 Day Flow) Rounded,
  "n__hgv_7_day_flow" VARCHAR  -- % HGV (7 Day Flow),
  "am_mean_weekday_peak_hour_5_day_flow" VARCHAR  -- AM Mean Weekday Peak Hour (5 Day Flow),
  "am_mean_weekday_peak_hour_5_day_flow_rounded" VARCHAR  -- AM Mean Weekday Peak Hour (5 Day Flow) Rounded,
  "am_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR  -- AM Mean Weekday Peak Hour (5 Day Flow) Start Time,
  "pm_mean_weekday_peak_hour_5_day_flow" VARCHAR  -- PM Mean Weekday Peak Hour (5 Day Flow),
  "pm_mean_weekday_peak_hour_5_day_flow_rounded" VARCHAR  -- PM Mean Weekday Peak Hour (5 Day Flow) Rounded,
  "pm_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR  -- PM Mean Weekday Peak Hour (5 Day Flow) Start Time,
  "n_24_hour_7_day_flow_ch_1" VARCHAR  -- 24 Hour 7 Day Flow CH. 1,
  "n_24_hour_7_day_flow_ch_2" VARCHAR  -- 24 Hour 7 Day Flow CH. 2,
  "n_24_hour_7_day_flow_ch_1_rounded" VARCHAR  -- 24 Hour 7 Day Flow CH. 1 (rounded),
  "n_24_hour_7_day_flow_ch_2_rounded" VARCHAR  -- 24 Hour 7 Day Flow CH. 2 (rounded),
  "percentage_traffic_composition_car_van" VARCHAR  -- Percentage Traffic Composition (car / Van),
  "percentage_traffic_composition_med_com" VARCHAR  -- Percentage Traffic Composition (med Com),
  "percentage_traffic_composition_rigid" VARCHAR  -- Percentage Traffic Composition (rigid),
  "percentage_traffic_composition_artic" VARCHAR  -- Percentage Traffic Composition (artic),
  "percentage_traffic_composition_bus_coach" VARCHAR  -- Percentage Traffic Composition (bus / Coach),
  "n_24_hour_5_day_flow_ch_1" VARCHAR  -- 24 Hour 5 Day Flow CH. 1,
  "n_24_hour_5_day_flow_ch_2" VARCHAR  -- 24 Hour 5 Day Flow CH. 2,
  "n_24_hour_aadt_5_day_flow" VARCHAR  -- 24 Hour AADT (5 Day Flow),
  "n_24_hour_5_day_flow_ch_1_rounded" VARCHAR  -- 24 Hour 5 Day Flow CH. 1 (rounded),
  "n_24_hour_5_day_flow_ch_2_rounded" VARCHAR  -- 24 Hour 5 Day Flow CH. 2 (rounded),
  "n_24_hour_aadt_5_day_flow_rounded" VARCHAR  -- 24 Hour AADT (5 Day Flow) Rounded,
  "am_peak_hour_flow_weekday_channel_1" VARCHAR,
  "am_peak_hour_flow_weekday_channel_1_rounded" VARCHAR  -- AM Peak Hour Flow Weekday Channel 1 (rounded),
  "am_peak_hour_flow_weekday_channel_1_start_time" VARCHAR,
  "pm_peak_hour_flow_weekday_channel_1" VARCHAR,
  "pm_peak_hour_flow_weekday_channel_1_rounded" VARCHAR  -- PM Peak Hour Flow Weekday Channel 1 (rounded),
  "pm_peak_hour_flow_weekday_channel_1_start_time" VARCHAR,
  "am_peak_hour_flow_weekday_channel_2" VARCHAR,
  "am_peak_hour_flow_weekday_channel_2_rounded" VARCHAR  -- AM Peak Hour Flow Weekday Channel 2 (rounded),
  "am_peak_hour_flow_weekday_channel_2_start_time" VARCHAR,
  "pm_peak_hour_flow_weekday_channel_2" VARCHAR,
  "pm_peak_hour_flow_weekday_channel_2_rounded" VARCHAR  -- PM Peak Hour Flow Weekday Channel 2 (rounded),
  "pm_peak_hour_flow_weekday_channel_2_start_time" VARCHAR,
  "n_2012_24_hour_aadt_7_day_flow_rounded" VARCHAR  -- 2012–24 Hour AADT (7 Day Flow) Rounded,
  "n_2013_age_incr_decr_over_2012_24hraadt_7_day_flow" VARCHAR  -- 2013 %age Incr/decr Over 2012–24HrAADT (7 Day Flow),
  "n_2013_24_hour_aadt_7_day_flow_rounded" VARCHAR  -- 2013–24 Hour AADT (7 Day Flow) Rounded,
  "n_2014_age_incr_decr_over_2013_24hraadt_7_day_flow" VARCHAR  -- 2014 %age Incr/decr Over 2013–24HrAADT (7 Day Flow),
  "n_2014_24_hour_aadt_7_day_flow_rounded" BIGINT  -- 2014–24 Hour AADT (7 Day Flow) Rounded,
  "comments" VARCHAR
);

Northern Ireland Traffic Count Data 2015 Summary

@ukgov.northern_ireland_traffic_count_data.northern_ireland_traffic_count_data_2015_summary

118.16 kB
351 rows
50 columns

CREATE TABLE northern_ireland_traffic_count_data_2015_summary (
  "cp_no" BIGINT  -- CP No.,
  "route" VARCHAR,
  "divn" VARCHAR  -- Divn.,
  "location" VARCHAR,
  "channel_1" VARCHAR,
  "channel_2" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "n_24_hour_aadt_7_day_flow" DOUBLE  -- 24 Hour AADT (7 Day Flow),
  "n_24_hour_aadt_7_day_flow_rounded" DOUBLE  -- 24 Hour AADT (7 Day Flow) Rounded,
  "n__hgv_7_day_flow" DOUBLE  -- % HGV (7 Day Flow),
  "am_mean_weekday_peak_hour_5_day_flow" DOUBLE  -- AM Mean Weekday Peak Hour (5 Day Flow),
  "am_mean_weekday_peak_hour_5_day_flow_rounded" DOUBLE  -- AM Mean Weekday Peak Hour (5 Day Flow) Rounded,
  "am_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR  -- AM Mean Weekday Peak Hour (5 Day Flow) Start Time,
  "pm_mean_weekday_peak_hour_5_day_flow" DOUBLE  -- PM Mean Weekday Peak Hour (5 Day Flow),
  "pm_mean_weekday_peak_hour_5_day_flow_rounded" DOUBLE  -- PM Mean Weekday Peak Hour (5 Day Flow) Rounded,
  "pm_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR  -- PM Mean Weekday Peak Hour (5 Day Flow) Start Time,
  "n_24_hour_7_day_flow_ch_1" DOUBLE  -- 24 Hour 7 Day Flow CH. 1,
  "n_24_hour_7_day_flow_ch_2" DOUBLE  -- 24 Hour 7 Day Flow CH. 2,
  "n_24_hour_7_day_flow_ch_1_rounded" DOUBLE  -- 24 Hour 7 Day Flow CH. 1 (rounded),
  "n_24_hour_7_day_flow_ch_2_rounded" DOUBLE  -- 24 Hour 7 Day Flow CH. 2 (rounded),
  "percentage_traffic_composition_car_van" DOUBLE  -- Percentage Traffic Composition (car / Van),
  "percentage_traffic_composition_med_com" DOUBLE  -- Percentage Traffic Composition (med Com),
  "percentage_traffic_composition_rigid" DOUBLE  -- Percentage Traffic Composition (rigid),
  "percentage_traffic_composition_artic" DOUBLE  -- Percentage Traffic Composition (artic),
  "percentage_traffic_composition_bus_coach" DOUBLE  -- Percentage Traffic Composition (bus / Coach),
  "n_24_hour_5_day_flow_ch_1" DOUBLE  -- 24 Hour 5 Day Flow CH. 1,
  "n_24_hour_5_day_flow_ch_2" DOUBLE  -- 24 Hour 5 Day Flow CH. 2,
  "n_24_hour_aadt_5_day_flow" DOUBLE  -- 24 Hour AADT (5 Day Flow),
  "n_24_hour_5_day_flow_ch_1_rounded" DOUBLE  -- 24 Hour 5 Day Flow CH. 1 (rounded),
  "n_24_hour_5_day_flow_ch_2_rounded" DOUBLE  -- 24 Hour 5 Day Flow CH. 2 (rounded),
  "n_24_hour_aadt_5_day_flow_rounded" DOUBLE  -- 24 Hour AADT (5 Day Flow) Rounded,
  "am_peak_hour_flow_weekday_channel_1" DOUBLE,
  "am_peak_hour_flow_weekday_channel_1_rounded" DOUBLE  -- AM Peak Hour Flow Weekday Channel 1 (rounded),
  "am_peak_hour_flow_weekday_channel_1_start_time" VARCHAR,
  "pm_peak_hour_flow_weekday_channel_1" DOUBLE,
  "pm_peak_hour_flow_weekday_channel_1_rounded" DOUBLE  -- PM Peak Hour Flow Weekday Channel 1 (rounded),
  "pm_peak_hour_flow_weekday_channel_1_start_time" VARCHAR,
  "am_peak_hour_flow_weekday_channel_2" DOUBLE,
  "am_peak_hour_flow_weekday_channel_2_rounded" DOUBLE  -- AM Peak Hour Flow Weekday Channel 2 (rounded),
  "am_peak_hour_flow_weekday_channel_2_start_time" VARCHAR,
  "pm_peak_hour_flow_weekday_channel_2" DOUBLE,
  "pm_peak_hour_flow_weekday_channel_2_rounded" DOUBLE  -- PM Peak Hour Flow Weekday Channel 2 (rounded),
  "pm_peak_hour_flow_weekday_channel_2_start_time" VARCHAR,
  "n_2013_24_hour_aadt_7_day_flow_rounded" DOUBLE  -- 2013–24 Hour AADT (7 Day Flow) Rounded,
  "n_2014_age_incr_decr_over_2013_24hraadt_7_day_flow" DOUBLE  -- 2014 %age Incr/decr Over 2013–24HrAADT (7 Day Flow),
  "n_2014_24_hour_aadt_7_day_flow_rounded" DOUBLE  -- 2014–24 Hour AADT (7 Day Flow) Rounded,
  "n_2015_age_incr_decr_over_2014_24hraadt_7_day_flow" DOUBLE  -- 2015 %age Incr/decr Over 2014–24HrAADT (7 Day Flow),
  "n_2015_24_hour_aadt_7_day_flow_rounded" DOUBLE  -- 2015–24 Hour AADT (7 Day Flow) Rounded,
  "comments" VARCHAR
);

Northern Ireland Traffic Count Data 2016 Summary

@ukgov.northern_ireland_traffic_count_data.northern_ireland_traffic_count_data_2016_summary

110.01 kB
351 rows
57 columns

CREATE TABLE northern_ireland_traffic_count_data_2016_summary (
  "cp_no" BIGINT  -- CP No.,
  "route" VARCHAR,
  "divn" VARCHAR  -- Divn.,
  "location" VARCHAR,
  "channel_1" VARCHAR,
  "channel_2" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "n_24_hour_aadt_7_day_flow" DOUBLE  -- 24 Hour AADT (7 Day Flow),
  "n_24_hour_aadt_7_day_flow_rounded" DOUBLE  -- 24 Hour AADT (7 Day Flow) Rounded,
  "n__hgv_7_day_flow" VARCHAR  -- % HGV (7 Day Flow),
  "am_mean_weekday_peak_hour_5_day_flow" DOUBLE  -- AM Mean Weekday Peak Hour (5 Day Flow),
  "am_mean_weekday_peak_hour_5_day_flow_rounded" DOUBLE  -- AM Mean Weekday Peak Hour (5 Day Flow) Rounded,
  "am_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR  -- AM Mean Weekday Peak Hour (5 Day Flow) Start Time,
  "pm_mean_weekday_peak_hour_5_day_flow" DOUBLE  -- PM Mean Weekday Peak Hour (5 Day Flow),
  "pm_mean_weekday_peak_hour_5_day_flow_rounded" DOUBLE  -- PM Mean Weekday Peak Hour (5 Day Flow) Rounded,
  "pm_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR  -- PM Mean Weekday Peak Hour (5 Day Flow) Start Time,
  "n_24_hour_7_day_flow_ch_1" DOUBLE  -- 24 Hour 7 Day Flow CH. 1,
  "n_24_hour_7_day_flow_ch_2" VARCHAR  -- 24 Hour 7 Day Flow CH. 2,
  "n_24_hour_7_day_flow_ch_1_rounded" DOUBLE  -- 24 Hour 7 Day Flow CH. 1 (rounded),
  "n_24_hour_7_day_flow_ch_2_rounded" VARCHAR  -- 24 Hour 7 Day Flow CH. 2 (rounded),
  "percentage_traffic_composition_car_van" VARCHAR  -- Percentage Traffic Composition (car / Van),
  "percentage_traffic_composition_med_com" VARCHAR  -- Percentage Traffic Composition (med Com),
  "percentage_traffic_composition_rigid" VARCHAR  -- Percentage Traffic Composition (rigid),
  "percentage_traffic_composition_artic" VARCHAR  -- Percentage Traffic Composition (artic),
  "percentage_traffic_composition_bus_coach" VARCHAR  -- Percentage Traffic Composition (bus / Coach),
  "n_24_hour_5_day_flow_ch_1" DOUBLE  -- 24 Hour 5 Day Flow CH. 1,
  "n_24_hour_5_day_flow_ch_2" DOUBLE  -- 24 Hour 5 Day Flow CH. 2,
  "n_24_hour_aadt_5_day_flow" DOUBLE  -- 24 Hour AADT (5 Day Flow),
  "n_24_hour_5_day_flow_ch_1_rounded" DOUBLE  -- 24 Hour 5 Day Flow CH. 1 (rounded),
  "n_24_hour_5_day_flow_ch_2_rounded" DOUBLE  -- 24 Hour 5 Day Flow CH. 2 (rounded),
  "n_24_hour_aadt_5_day_flow_rounded" DOUBLE  -- 24 Hour AADT (5 Day Flow) Rounded,
  "am_peak_hour_flow_weekday_channel_1" DOUBLE,
  "am_peak_hour_flow_weekday_channel_1_rounded" DOUBLE  -- AM Peak Hour Flow Weekday Channel 1 (rounded),
  "am_peak_hour_flow_weekday_channel_1_start_time" VARCHAR,
  "pm_peak_hour_flow_weekday_channel_1" DOUBLE,
  "pm_peak_hour_flow_weekday_channel_1_rounded" DOUBLE  -- PM Peak Hour Flow Weekday Channel 1 (rounded),
  "pm_peak_hour_flow_weekday_channel_1_start_time" VARCHAR,
  "am_peak_hour_flow_weekday_channel_2" DOUBLE,
  "am_peak_hour_flow_weekday_channel_2_rounded" DOUBLE  -- AM Peak Hour Flow Weekday Channel 2 (rounded),
  "am_peak_hour_flow_weekday_channel_2_start_time" VARCHAR,
  "pm_peak_hour_flow_weekday_channel_2" DOUBLE,
  "pm_peak_hour_flow_weekday_channel_2_rounded" DOUBLE  -- PM Peak Hour Flow Weekday Channel 2 (rounded),
  "pm_peak_hour_flow_weekday_channel_2_start_time" VARCHAR,
  "n_2014_24_hour_aadt_7_day_flow_rounded" DOUBLE  -- 2014–24 Hour AADT (7 Day Flow) Rounded,
  "n_2015_age_incr_decr_over_2014_24hraadt_7_day_flow" DOUBLE  -- 2015 %age Incr/decr Over 2014–24HrAADT (7 Day Flow),
  "n_2015_24_hour_aadt_7_day_flow_rounded" DOUBLE  -- 2015–24 Hour AADT (7 Day Flow) Rounded,
  "n_2016_age_incr_decr_over_2015_24hraadt_7_day_flow" VARCHAR  -- 2016 %age Incr/decr Over 2015–24HrAADT (7 Day Flow),
  "n_2016_24_hour_aadt_7_day_flow_rounded" VARCHAR  -- 2016–24 Hour AADT (7 Day Flow) Rounded,
  "comments" VARCHAR,
  "unnamed_50" VARCHAR  -- Unnamed: 50,
  "unnamed_51" VARCHAR  -- Unnamed: 51,
  "unnamed_52" VARCHAR  -- Unnamed: 52,
  "unnamed_53" VARCHAR  -- Unnamed: 53,
  "unnamed_54" VARCHAR  -- Unnamed: 54,
  "unnamed_55" VARCHAR  -- Unnamed: 55,
  "unnamed_56" VARCHAR  -- Unnamed: 56
);

Northern Ireland Traffic Count Data 2017 Summary

@ukgov.northern_ireland_traffic_count_data.northern_ireland_traffic_count_data_2017_summary

75.84 kB
86 rows
63 columns

CREATE TABLE northern_ireland_traffic_count_data_2017_summary (
  "cp_no" VARCHAR  -- CP No.,
  "route" VARCHAR,
  "divn" VARCHAR  -- Divn.,
  "location" VARCHAR,
  "channel_1" VARCHAR,
  "channel_2" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "n_24_hour_aadt_7_day_flow" BIGINT  -- 24 Hour AADT (7 Day Flow),
  "n_24_hour_aadt_7_day_flow_rounded" BIGINT  -- 24 Hour AADT (7 Day Flow) Rounded,
  "n__hgv_7_day_flow" VARCHAR  -- % HGV (7 Day Flow),
  "am_mean_weekday_peak_hour_5_day_flow" BIGINT  -- AM Mean Weekday Peak Hour (5 Day Flow),
  "am_mean_weekday_peak_hour_5_day_flow_rounded" BIGINT  -- AM Mean Weekday Peak Hour (5 Day Flow) Rounded,
  "am_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR  -- AM Mean Weekday Peak Hour (5 Day Flow) Start Time,
  "pm_mean_weekday_peak_hour_5_day_flow" BIGINT  -- PM Mean Weekday Peak Hour (5 Day Flow),
  "pm_mean_weekday_peak_hour_5_day_flow_rounded" BIGINT  -- PM Mean Weekday Peak Hour (5 Day Flow) Rounded,
  "pm_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR  -- PM Mean Weekday Peak Hour (5 Day Flow) Start Time,
  "n_24_hour_7_day_flow_ch_1" BIGINT  -- 24 Hour 7 Day Flow CH. 1,
  "n_24_hour_7_day_flow_ch_2" VARCHAR  -- 24 Hour 7 Day Flow CH. 2,
  "n_24_hour_7_day_flow_ch_1_rounded" BIGINT  -- 24 Hour 7 Day Flow CH. 1 (rounded),
  "n_24_hour_7_day_flow_ch_2_rounded" VARCHAR  -- 24 Hour 7 Day Flow CH. 2 (rounded),
  "percentage_traffic_composition_euro_6_class_1" VARCHAR  -- Percentage Traffic Composition (Euro 6 Class 1),
  "percentage_traffic_composition_euro_6_class_2" VARCHAR  -- Percentage Traffic Composition (Euro 6 Class 2),
  "percentage_traffic_composition_euro_6_class_3" VARCHAR  -- Percentage Traffic Composition (Euro 6 Class 3),
  "percentage_traffic_composition_euro_6_class_4" VARCHAR  -- Percentage Traffic Composition (Euro 6 Class 4),
  "percentage_traffic_composition_euro_6_class_5" VARCHAR  -- Percentage Traffic Composition (Euro 6 Class 5),
  "percentage_traffic_composition_euro_6_class_6" VARCHAR  -- Percentage Traffic Composition (Euro 6 Class 6),
  "percentage_traffic_composition_doeni5_class_1" VARCHAR  -- Percentage Traffic Composition (DoENI5 Class 1),
  "percentage_traffic_composition_doeni5_class_2" VARCHAR  -- Percentage Traffic Composition (DoENI5 Class 2),
  "percentage_traffic_composition_doeni5_class_3" VARCHAR  -- Percentage Traffic Composition (DoENI5 Class 3),
  "percentage_traffic_composition_doeni5_class_4" VARCHAR  -- Percentage Traffic Composition (DoENI5 Class 4),
  "percentage_traffic_composition_doeni5_class_5" VARCHAR  -- Percentage Traffic Composition (DoENI5 Class 5),
  "n_24_hour_5_day_flow_ch_1" BIGINT  -- 24 Hour 5 Day Flow CH. 1,
  "n_24_hour_5_day_flow_ch_2" VARCHAR  -- 24 Hour 5 Day Flow CH. 2,
  "n_24_hour_aadt_5_day_flow" BIGINT  -- 24 Hour AADT (5 Day Flow),
  "n_24_hour_5_day_flow_ch_1_rounded" BIGINT  -- 24 Hour 5 Day Flow CH. 1 (rounded),
  "n_24_hour_5_day_flow_ch_2_rounded" VARCHAR  -- 24 Hour 5 Day Flow CH. 2 (rounded),
  "n_24_hour_aadt_5_day_flow_rounded" BIGINT  -- 24 Hour AADT (5 Day Flow) Rounded,
  "am_peak_hour_flow_weekday_channel_1" BIGINT,
  "am_peak_hour_flow_weekday_channel_1_rounded" BIGINT  -- AM Peak Hour Flow Weekday Channel 1 (rounded),
  "am_peak_hour_flow_weekday_channel_1_start_time" VARCHAR,
  "pm_peak_hour_flow_weekday_channel_1" BIGINT,
  "pm_peak_hour_flow_weekday_channel_1_rounded" BIGINT  -- PM Peak Hour Flow Weekday Channel 1 (rounded),
  "pm_peak_hour_flow_weekday_channel_1_start_time" VARCHAR,
  "am_peak_hour_flow_weekday_channel_2" VARCHAR,
  "am_peak_hour_flow_weekday_channel_2_rounded" VARCHAR  -- AM Peak Hour Flow Weekday Channel 2 (rounded),
  "am_peak_hour_flow_weekday_channel_2_start_time" VARCHAR,
  "pm_peak_hour_flow_weekday_channel_2" VARCHAR,
  "pm_peak_hour_flow_weekday_channel_2_rounded" VARCHAR  -- PM Peak Hour Flow Weekday Channel 2 (rounded),
  "pm_peak_hour_flow_weekday_channel_2_start_time" VARCHAR,
  "n_2015_24_hour_aadt_7_day_flow_rounded" VARCHAR  -- 2015–24 Hour AADT (7 Day Flow) Rounded,
  "n_2016_age_incr_decr_over_2015_24hraadt_7_day_flow" VARCHAR  -- 2016%age Incr/decr Over 2015–24HrAADT (7 Day Flow),
  "n_2016_24_hour_aadt_7_day_flow_rounded" VARCHAR  -- 2016–24 Hour AADT (7 Day Flow) Rounded,
  "n_2017_age_incr_decr_over_2016_24hraadt_7_day_flow" VARCHAR  -- 2017 %age Incr/decr Over 2016–24HrAADT (7 Day Flow),
  "n_2017_24_hour_aadt_7_day_flow_rounded" BIGINT  -- 2017–24 Hour AADT (7 Day Flow) Rounded,
  "comments" VARCHAR,
  "unnamed_56" VARCHAR  -- Unnamed: 56,
  "unnamed_57" VARCHAR  -- Unnamed: 57,
  "unnamed_58" VARCHAR  -- Unnamed: 58,
  "unnamed_59" VARCHAR  -- Unnamed: 59,
  "unnamed_60" VARCHAR  -- Unnamed: 60,
  "unnamed_61" VARCHAR  -- Unnamed: 61,
  "unnamed_62" VARCHAR  -- Unnamed: 62
);

Northern Ireland Traffic Count Data 2018 Summary

@ukgov.northern_ireland_traffic_count_data.northern_ireland_traffic_count_data_2018_summary

68.45 kB
89 rows
52 columns

CREATE TABLE northern_ireland_traffic_count_data_2018_summary (
  "cp_no" VARCHAR  -- CP No.,
  "route" VARCHAR,
  "divn" VARCHAR  -- Divn.,
  "location" VARCHAR,
  "channel_1" VARCHAR,
  "channel_2" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "n_24_hour_aadt_7_day_flow" VARCHAR  -- 24 Hour AADT (7 Day Flow),
  "n_24_hour_aadt_7_day_flow_rounded" VARCHAR  -- 24 Hour AADT (7 Day Flow) Rounded,
  "n__hgv_7_day_flow" VARCHAR  -- % HGV (7 Day Flow),
  "am_mean_weekday_peak_hour_5_day_flow" VARCHAR  -- AM Mean Weekday Peak Hour (5 Day Flow),
  "am_mean_weekday_peak_hour_5_day_flow_rounded" VARCHAR  -- AM Mean Weekday Peak Hour (5 Day Flow) Rounded,
  "am_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR  -- AM Mean Weekday Peak Hour (5 Day Flow) Start Time,
  "pm_mean_weekday_peak_hour_5_day_flow" VARCHAR  -- PM Mean Weekday Peak Hour (5 Day Flow),
  "pm_mean_weekday_peak_hour_5_day_flow_rounded" VARCHAR  -- PM Mean Weekday Peak Hour (5 Day Flow) Rounded,
  "pm_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR  -- PM Mean Weekday Peak Hour (5 Day Flow) Start Time,
  "n_24_hour_7_day_flow_ch_1" VARCHAR  -- 24 Hour 7 Day Flow CH. 1,
  "n_24_hour_7_day_flow_ch_2" VARCHAR  -- 24 Hour 7 Day Flow CH. 2,
  "n_24_hour_7_day_flow_ch_1_rounded" VARCHAR  -- 24 Hour 7 Day Flow CH. 1 (rounded),
  "n_24_hour_7_day_flow_ch_2_rounded" VARCHAR  -- 24 Hour 7 Day Flow CH. 2 (rounded),
  "percentage_traffic_composition_euro_6_class_1" VARCHAR  -- Percentage Traffic Composition (Euro 6 Class 1),
  "percentage_traffic_composition_euro_6_class_2" VARCHAR  -- Percentage Traffic Composition (Euro 6 Class 2),
  "percentage_traffic_composition_euro_6_class_3" VARCHAR  -- Percentage Traffic Composition (Euro 6 Class 3),
  "percentage_traffic_composition_euro_6_class_4" VARCHAR  -- Percentage Traffic Composition (Euro 6 Class 4),
  "percentage_traffic_composition_euro_6_class_5" VARCHAR  -- Percentage Traffic Composition (Euro 6 Class 5),
  "percentage_traffic_composition_euro_6_class_6" VARCHAR  -- Percentage Traffic Composition (Euro 6 Class 6),
  "n_24_hour_5_day_flow_ch_1" VARCHAR  -- 24 Hour 5 Day Flow CH. 1,
  "n_24_hour_5_day_flow_ch_2" VARCHAR  -- 24 Hour 5 Day Flow CH. 2,
  "n_24_hour_aadt_5_day_flow" VARCHAR  -- 24 Hour AADT (5 Day Flow),
  "n_24_hour_5_day_flow_ch_1_rounded" VARCHAR  -- 24 Hour 5 Day Flow CH. 1 (rounded),
  "n_24_hour_5_day_flow_ch_2_rounded" VARCHAR  -- 24 Hour 5 Day Flow CH. 2 (rounded),
  "n_24_hour_aadt_5_day_flow_rounded" VARCHAR  -- 24 Hour AADT (5 Day Flow) Rounded,
  "am_peak_hour_flow_weekday_channel_1" VARCHAR,
  "am_peak_hour_flow_weekday_channel_1_rounded" VARCHAR  -- AM Peak Hour Flow Weekday Channel 1 (rounded),
  "am_peak_hour_flow_weekday_channel_1_start_time" VARCHAR,
  "pm_peak_hour_flow_weekday_channel_1" VARCHAR,
  "pm_peak_hour_flow_weekday_channel_1_rounded" VARCHAR  -- PM Peak Hour Flow Weekday Channel 1 (rounded),
  "pm_peak_hour_flow_weekday_channel_1_start_time" VARCHAR,
  "am_peak_hour_flow_weekday_channel_2" VARCHAR,
  "am_peak_hour_flow_weekday_channel_2_rounded" VARCHAR  -- AM Peak Hour Flow Weekday Channel 2 (rounded),
  "am_peak_hour_flow_weekday_channel_2_start_time" VARCHAR,
  "pm_peak_hour_flow_weekday_channel_2" VARCHAR,
  "pm_peak_hour_flow_weekday_channel_2_rounded" VARCHAR  -- PM Peak Hour Flow Weekday Channel 2 (rounded),
  "pm_peak_hour_flow_weekday_channel_2_start_time" VARCHAR,
  "n_2016_24_hour_aadt_7_day_flow_rounded" VARCHAR  -- 2016–24 Hour AADT (7 Day Flow) Rounded,
  "n_2017_age_incr_decr_over_2016_24hraadt_7_day_flow" VARCHAR  -- 2017%age Incr/decr Over 2016–24HrAADT (7 Day Flow),
  "n_2017_24_hour_aadt_7_day_flow_rounded" VARCHAR  -- 2017–24 Hour AADT (7 Day Flow) Rounded,
  "n_2018_age_incr_decr_over_2017_24hraadt_7_day_flow" VARCHAR  -- 2018 %age Incr/decr Over 2017–24HrAADT (7 Day Flow),
  "n_2018_24_hour_aadt_7_day_flow_rounded" VARCHAR  -- 2018–24 Hour AADT (7 Day Flow) Rounded,
  "comments" VARCHAR,
  "unnamed_51" VARCHAR  -- Unnamed: 51
);

Northern Ireland Traffic Count Data 2019 Summary

@ukgov.northern_ireland_traffic_count_data.northern_ireland_traffic_count_data_2019_summary

65.7 kB
90 rows
51 columns

CREATE TABLE northern_ireland_traffic_count_data_2019_summary (
  "cp_no" VARCHAR  -- CP No.,
  "route" VARCHAR,
  "divn" VARCHAR  -- Divn.,
  "location" VARCHAR,
  "channel_1" VARCHAR,
  "channel_2" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "n_24_hour_aadt_7_day_flow" VARCHAR  -- 24 Hour AADT (7 Day Flow),
  "n_24_hour_aadt_7_day_flow_rounded" VARCHAR  -- 24 Hour AADT (7 Day Flow) Rounded,
  "n__hgv_7_day_flow" VARCHAR  -- % HGV (7 Day Flow),
  "am_mean_weekday_peak_hour_5_day_flow" VARCHAR  -- AM Mean Weekday Peak Hour (5 Day Flow),
  "am_mean_weekday_peak_hour_5_day_flow_rounded" VARCHAR  -- AM Mean Weekday Peak Hour (5 Day Flow) Rounded,
  "am_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR  -- AM Mean Weekday Peak Hour (5 Day Flow) Start Time,
  "pm_mean_weekday_peak_hour_5_day_flow" VARCHAR  -- PM Mean Weekday Peak Hour (5 Day Flow),
  "pm_mean_weekday_peak_hour_5_day_flow_rounded" VARCHAR  -- PM Mean Weekday Peak Hour (5 Day Flow) Rounded,
  "pm_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR  -- PM Mean Weekday Peak Hour (5 Day Flow) Start Time,
  "n_24_hour_7_day_flow_ch_1" VARCHAR  -- 24 Hour 7 Day Flow CH. 1,
  "n_24_hour_7_day_flow_ch_2" VARCHAR  -- 24 Hour 7 Day Flow CH. 2,
  "n_24_hour_7_day_flow_ch_1_rounded" VARCHAR  -- 24 Hour 7 Day Flow CH. 1 (rounded),
  "n_24_hour_7_day_flow_ch_2_rounded" VARCHAR  -- 24 Hour 7 Day Flow CH. 2 (rounded),
  "percentage_traffic_composition_euro_6_class_1" VARCHAR  -- Percentage Traffic Composition (Euro 6 Class 1),
  "percentage_traffic_composition_euro_6_class_2" VARCHAR  -- Percentage Traffic Composition (Euro 6 Class 2),
  "percentage_traffic_composition_euro_6_class_3" VARCHAR  -- Percentage Traffic Composition (Euro 6 Class 3),
  "percentage_traffic_composition_euro_6_class_4" VARCHAR  -- Percentage Traffic Composition (Euro 6 Class 4),
  "percentage_traffic_composition_euro_6_class_5" VARCHAR  -- Percentage Traffic Composition (Euro 6 Class 5),
  "percentage_traffic_composition_euro_6_class_6" VARCHAR  -- Percentage Traffic Composition (Euro 6 Class 6),
  "n_24_hour_5_day_flow_ch_1" VARCHAR  -- 24 Hour 5 Day Flow CH. 1,
  "n_24_hour_5_day_flow_ch_2" VARCHAR  -- 24 Hour 5 Day Flow CH. 2,
  "n_24_hour_aadt_5_day_flow" VARCHAR  -- 24 Hour AADT (5 Day Flow),
  "n_24_hour_5_day_flow_ch_1_rounded" VARCHAR  -- 24 Hour 5 Day Flow CH. 1 (rounded),
  "n_24_hour_5_day_flow_ch_2_rounded" VARCHAR  -- 24 Hour 5 Day Flow CH. 2 (rounded),
  "n_24_hour_aadt_5_day_flow_rounded" VARCHAR  -- 24 Hour AADT (5 Day Flow) Rounded,
  "am_peak_hour_flow_weekday_channel_1" VARCHAR,
  "am_peak_hour_flow_weekday_channel_1_rounded" VARCHAR  -- AM Peak Hour Flow Weekday Channel 1 (rounded),
  "am_peak_hour_flow_weekday_channel_1_start_time" VARCHAR,
  "pm_peak_hour_flow_weekday_channel_1" VARCHAR,
  "pm_peak_hour_flow_weekday_channel_1_rounded" VARCHAR  -- PM Peak Hour Flow Weekday Channel 1 (rounded),
  "pm_peak_hour_flow_weekday_channel_1_start_time" VARCHAR,
  "am_peak_hour_flow_weekday_channel_2" VARCHAR,
  "am_peak_hour_flow_weekday_channel_2_rounded" VARCHAR  -- AM Peak Hour Flow Weekday Channel 2 (rounded),
  "am_peak_hour_flow_weekday_channel_2_start_time" VARCHAR,
  "pm_peak_hour_flow_weekday_channel_2" VARCHAR,
  "pm_peak_hour_flow_weekday_channel_2_rounded" VARCHAR  -- PM Peak Hour Flow Weekday Channel 2 (rounded),
  "pm_peak_hour_flow_weekday_channel_2_start_time" VARCHAR,
  "n_2017_24_hour_aadt_7_day_flow_rounded" VARCHAR  -- 2017–24 Hour AADT (7 Day Flow) Rounded,
  "n_2018_age_incr_decr_over_2017_24hraadt_7_day_flow" VARCHAR  -- 2018%age Incr/decr Over 2017–24HrAADT (7 Day Flow),
  "n_2018_24_hour_aadt_7_day_flow_rounded" VARCHAR  -- 2018–24 Hour AADT (7 Day Flow) Rounded,
  "n_2019_age_incr_decr_over_2018_24hraadt_7_day_flow" VARCHAR  -- 2019 %age Incr/decr Over 2018–24HrAADT (7 Day Flow),
  "n_2019_24_hour_aadt_7_day_flow_rounded" VARCHAR  -- 2019–24 Hour AADT (7 Day Flow) Rounded,
  "comments" VARCHAR
);

Northern Ireland Traffic Count Data 2020 Summary

@ukgov.northern_ireland_traffic_count_data.northern_ireland_traffic_count_data_2020_summary

67.53 kB
234 rows
51 columns

CREATE TABLE northern_ireland_traffic_count_data_2020_summary (
  "cp_no" VARCHAR  -- CP No.,
  "route" VARCHAR,
  "divn" VARCHAR  -- Divn.,
  "location" VARCHAR,
  "channel_1" VARCHAR,
  "channel_2" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "n_24_hour_aadt_7_day_flow" DOUBLE  -- 24 Hour AADT (7 Day Flow),
  "n_24_hour_aadt_7_day_flow_rounded" DOUBLE  -- 24 Hour AADT (7 Day Flow) Rounded,
  "n__hgv_7_day_flow" DOUBLE  -- % HGV (7 Day Flow),
  "am_mean_weekday_peak_hour_5_day_flow" DOUBLE  -- AM Mean Weekday Peak Hour (5 Day Flow),
  "am_mean_weekday_peak_hour_5_day_flow_rounded" DOUBLE  -- AM Mean Weekday Peak Hour (5 Day Flow) Rounded,
  "am_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR  -- AM Mean Weekday Peak Hour (5 Day Flow) Start Time,
  "pm_mean_weekday_peak_hour_5_day_flow" DOUBLE  -- PM Mean Weekday Peak Hour (5 Day Flow),
  "pm_mean_weekday_peak_hour_5_day_flow_rounded" DOUBLE  -- PM Mean Weekday Peak Hour (5 Day Flow) Rounded,
  "pm_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR  -- PM Mean Weekday Peak Hour (5 Day Flow) Start Time,
  "n_24_hour_7_day_flow_ch_1" DOUBLE  -- 24 Hour 7 Day Flow CH. 1,
  "n_24_hour_7_day_flow_ch_2" DOUBLE  -- 24 Hour 7 Day Flow CH. 2,
  "n_24_hour_7_day_flow_ch_1_rounded" DOUBLE  -- 24 Hour 7 Day Flow CH. 1 (rounded),
  "n_24_hour_7_day_flow_ch_2_rounded" DOUBLE  -- 24 Hour 7 Day Flow CH. 2 (rounded),
  "percentage_traffic_composition_euro_6_class_1" DOUBLE  -- Percentage Traffic Composition (Euro 6 Class 1),
  "percentage_traffic_composition_euro_6_class_2" DOUBLE  -- Percentage Traffic Composition (Euro 6 Class 2),
  "percentage_traffic_composition_euro_6_class_3" DOUBLE  -- Percentage Traffic Composition (Euro 6 Class 3),
  "percentage_traffic_composition_euro_6_class_4" DOUBLE  -- Percentage Traffic Composition (Euro 6 Class 4),
  "percentage_traffic_composition_euro_6_class_5" DOUBLE  -- Percentage Traffic Composition (Euro 6 Class 5),
  "percentage_traffic_composition_euro_6_class_6" DOUBLE  -- Percentage Traffic Composition (Euro 6 Class 6),
  "n_24_hour_5_day_flow_ch_1" DOUBLE  -- 24 Hour 5 Day Flow CH. 1,
  "n_24_hour_5_day_flow_ch_2" DOUBLE  -- 24 Hour 5 Day Flow CH. 2,
  "n_24_hour_aadt_5_day_flow" DOUBLE  -- 24 Hour AADT (5 Day Flow),
  "n_24_hour_5_day_flow_ch_1_rounded" DOUBLE  -- 24 Hour 5 Day Flow CH. 1 (rounded),
  "n_24_hour_5_day_flow_ch_2_rounded" DOUBLE  -- 24 Hour 5 Day Flow CH. 2 (rounded),
  "n_24_hour_aadt_5_day_flow_rounded" DOUBLE  -- 24 Hour AADT (5 Day Flow) Rounded,
  "am_peak_hour_flow_weekday_channel_1" DOUBLE,
  "am_peak_hour_flow_weekday_channel_1_rounded" DOUBLE  -- AM Peak Hour Flow Weekday Channel 1 (rounded),
  "am_peak_hour_flow_weekday_channel_1_start_time" VARCHAR,
  "pm_peak_hour_flow_weekday_channel_1" DOUBLE,
  "pm_peak_hour_flow_weekday_channel_1_rounded" DOUBLE  -- PM Peak Hour Flow Weekday Channel 1 (rounded),
  "pm_peak_hour_flow_weekday_channel_1_start_time" VARCHAR,
  "am_peak_hour_flow_weekday_channel_2" DOUBLE,
  "am_peak_hour_flow_weekday_channel_2_rounded" DOUBLE  -- AM Peak Hour Flow Weekday Channel 2 (rounded),
  "am_peak_hour_flow_weekday_channel_2_start_time" VARCHAR,
  "pm_peak_hour_flow_weekday_channel_2" DOUBLE,
  "pm_peak_hour_flow_weekday_channel_2_rounded" DOUBLE  -- PM Peak Hour Flow Weekday Channel 2 (rounded),
  "pm_peak_hour_flow_weekday_channel_2_start_time" VARCHAR,
  "n_2018_24_hour_aadt_7_day_flow_rounded" VARCHAR  -- 2018–24 Hour AADT (7 Day Flow) Rounded,
  "n_2019_age_incr_decr_over_2018_24hraadt_7_day_flow" DOUBLE  -- 2019%age Incr/decr Over 2018–24HrAADT (7 Day Flow),
  "n_2019_24_hour_aadt_7_day_flow_rounded" DOUBLE  -- 2019–24 Hour AADT (7 Day Flow) Rounded,
  "n_2020_age_incr_decr_over_2019_24hraadt_7_day_flow" DOUBLE  -- 2020 %age Incr/decr Over 2019–24HrAADT (7 Day Flow),
  "n_2020_24_hour_aadt_7_day_flow_rounded" DOUBLE  -- 2020–24 Hour AADT (7 Day Flow) Rounded,
  "comments" VARCHAR
);

Northern Ireland Traffic Count Data 2021 Summary

@ukgov.northern_ireland_traffic_count_data.northern_ireland_traffic_count_data_2021_summary

65.28 kB
96 rows
51 columns

CREATE TABLE northern_ireland_traffic_count_data_2021_summary (
  "cp_no" VARCHAR  -- CP No.,
  "route" VARCHAR,
  "divn" VARCHAR  -- Divn.,
  "location" VARCHAR,
  "channel_1" VARCHAR,
  "channel_2" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "n_24_hour_aadt_7_day_flow" VARCHAR  -- 24 Hour AADT (7 Day Flow),
  "n_24_hour_aadt_7_day_flow_rounded" VARCHAR  -- 24 Hour AADT (7 Day Flow) Rounded,
  "n__hgv_7_day_flow" VARCHAR  -- % HGV (7 Day Flow),
  "am_mean_weekday_peak_hour_5_day_flow" VARCHAR  -- AM Mean Weekday Peak Hour (5 Day Flow),
  "am_mean_weekday_peak_hour_5_day_flow_rounded" VARCHAR  -- AM Mean Weekday Peak Hour (5 Day Flow) Rounded,
  "am_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR  -- AM Mean Weekday Peak Hour (5 Day Flow) Start Time,
  "pm_mean_weekday_peak_hour_5_day_flow" VARCHAR  -- PM Mean Weekday Peak Hour (5 Day Flow),
  "pm_mean_weekday_peak_hour_5_day_flow_rounded" VARCHAR  -- PM Mean Weekday Peak Hour (5 Day Flow) Rounded,
  "pm_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR  -- PM Mean Weekday Peak Hour (5 Day Flow) Start Time,
  "n_24_hour_7_day_flow_ch_1" VARCHAR  -- 24 Hour 7 Day Flow CH. 1,
  "n_24_hour_7_day_flow_ch_2" VARCHAR  -- 24 Hour 7 Day Flow CH. 2,
  "n_24_hour_7_day_flow_ch_1_rounded" VARCHAR  -- 24 Hour 7 Day Flow CH. 1 (rounded),
  "n_24_hour_7_day_flow_ch_2_rounded" VARCHAR  -- 24 Hour 7 Day Flow CH. 2 (rounded),
  "percentage_traffic_composition_euro_6_class_1" VARCHAR  -- Percentage Traffic Composition (Euro 6 Class 1),
  "percentage_traffic_composition_euro_6_class_2" VARCHAR  -- Percentage Traffic Composition (Euro 6 Class 2),
  "percentage_traffic_composition_euro_6_class_3" VARCHAR  -- Percentage Traffic Composition (Euro 6 Class 3),
  "percentage_traffic_composition_euro_6_class_4" VARCHAR  -- Percentage Traffic Composition (Euro 6 Class 4),
  "percentage_traffic_composition_euro_6_class_5" VARCHAR  -- Percentage Traffic Composition (Euro 6 Class 5),
  "percentage_traffic_composition_euro_6_class_6" VARCHAR  -- Percentage Traffic Composition (Euro 6 Class 6),
  "n_24_hour_5_day_flow_ch_1" VARCHAR  -- 24 Hour 5 Day Flow CH. 1,
  "n_24_hour_5_day_flow_ch_2" VARCHAR  -- 24 Hour 5 Day Flow CH. 2,
  "n_24_hour_aadt_5_day_flow" VARCHAR  -- 24 Hour AADT (5 Day Flow),
  "n_24_hour_5_day_flow_ch_1_rounded" VARCHAR  -- 24 Hour 5 Day Flow CH. 1 (rounded),
  "n_24_hour_5_day_flow_ch_2_rounded" VARCHAR  -- 24 Hour 5 Day Flow CH. 2 (rounded),
  "n_24_hour_aadt_5_day_flow_rounded" VARCHAR  -- 24 Hour AADT (5 Day Flow) Rounded,
  "am_peak_hour_flow_weekday_channel_1" VARCHAR,
  "am_peak_hour_flow_weekday_channel_1_rounded" VARCHAR  -- AM Peak Hour Flow Weekday Channel 1 (rounded),
  "am_peak_hour_flow_weekday_channel_1_start_time" VARCHAR,
  "pm_peak_hour_flow_weekday_channel_1" VARCHAR,
  "pm_peak_hour_flow_weekday_channel_1_rounded" VARCHAR  -- PM Peak Hour Flow Weekday Channel 1 (rounded),
  "pm_peak_hour_flow_weekday_channel_1_start_time" VARCHAR,
  "am_peak_hour_flow_weekday_channel_2" VARCHAR,
  "am_peak_hour_flow_weekday_channel_2_rounded" VARCHAR  -- AM Peak Hour Flow Weekday Channel 2 (rounded),
  "am_peak_hour_flow_weekday_channel_2_start_time" VARCHAR,
  "pm_peak_hour_flow_weekday_channel_2" VARCHAR,
  "pm_peak_hour_flow_weekday_channel_2_rounded" VARCHAR  -- PM Peak Hour Flow Weekday Channel 2 (rounded),
  "pm_peak_hour_flow_weekday_channel_2_start_time" VARCHAR,
  "n_2019_24_hour_aadt_7_day_flow_rounded" VARCHAR  -- 2019–24 Hour AADT (7 Day Flow) Rounded,
  "n_2020_age_incr_decr_over_2019_24hraadt_7_day_flow" VARCHAR  -- 2020%age Incr/decr Over 2019–24HrAADT (7 Day Flow),
  "n_2020_24_hour_aadt_7_day_flow_rounded" VARCHAR  -- 2020–24 Hour AADT (7 Day Flow) Rounded,
  "n_2021_age_incr_decr_over_2020_24hraadt_7_day_flow" VARCHAR  -- 2021 %age Incr/decr Over 2020–24HrAADT (7 Day Flow),
  "n_2021_24_hour_aadt_7_day_flow_rounded" VARCHAR  -- 2021–24 Hour AADT (7 Day Flow) Rounded,
  "comments" VARCHAR
);

Northern Ireland Traffic Count Data 2022 Summary

@ukgov.northern_ireland_traffic_count_data.northern_ireland_traffic_count_data_2022_summary

65.16 kB
96 rows
51 columns

CREATE TABLE northern_ireland_traffic_count_data_2022_summary (
  "cp_no" VARCHAR  -- CP No.,
  "route" VARCHAR,
  "divn" VARCHAR  -- Divn.,
  "location" VARCHAR,
  "channel_1" VARCHAR,
  "channel_2" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "n_24_hour_aadt_7_day_flow" VARCHAR  -- 24 Hour AADT (7 Day Flow),
  "n_24_hour_aadt_7_day_flow_rounded" VARCHAR  -- 24 Hour AADT (7 Day Flow) Rounded,
  "n__hgv_7_day_flow" VARCHAR  -- % HGV (7 Day Flow),
  "am_mean_weekday_peak_hour_5_day_flow" VARCHAR  -- AM Mean Weekday Peak Hour (5 Day Flow),
  "am_mean_weekday_peak_hour_5_day_flow_rounded" VARCHAR  -- AM Mean Weekday Peak Hour (5 Day Flow) Rounded,
  "am_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR  -- AM Mean Weekday Peak Hour (5 Day Flow) Start Time,
  "pm_mean_weekday_peak_hour_5_day_flow" VARCHAR  -- PM Mean Weekday Peak Hour (5 Day Flow),
  "pm_mean_weekday_peak_hour_5_day_flow_rounded" VARCHAR  -- PM Mean Weekday Peak Hour (5 Day Flow) Rounded,
  "pm_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR  -- PM Mean Weekday Peak Hour (5 Day Flow) Start Time,
  "n_24_hour_7_day_flow_ch_1" VARCHAR  -- 24 Hour 7 Day Flow CH. 1,
  "n_24_hour_7_day_flow_ch_2" VARCHAR  -- 24 Hour 7 Day Flow CH. 2,
  "n_24_hour_7_day_flow_ch_1_rounded" VARCHAR  -- 24 Hour 7 Day Flow CH. 1 (rounded),
  "n_24_hour_7_day_flow_ch_2_rounded" VARCHAR  -- 24 Hour 7 Day Flow CH. 2 (rounded),
  "percentage_traffic_composition_euro_6_class_1" VARCHAR  -- Percentage Traffic Composition (Euro 6 Class 1),
  "percentage_traffic_composition_euro_6_class_2" VARCHAR  -- Percentage Traffic Composition (Euro 6 Class 2),
  "percentage_traffic_composition_euro_6_class_3" VARCHAR  -- Percentage Traffic Composition (Euro 6 Class 3),
  "percentage_traffic_composition_euro_6_class_4" VARCHAR  -- Percentage Traffic Composition (Euro 6 Class 4),
  "percentage_traffic_composition_euro_6_class_5" VARCHAR  -- Percentage Traffic Composition (Euro 6 Class 5),
  "percentage_traffic_composition_euro_6_class_6" VARCHAR  -- Percentage Traffic Composition (Euro 6 Class 6),
  "n_24_hour_5_day_flow_ch_1" VARCHAR  -- 24 Hour 5 Day Flow CH. 1,
  "n_24_hour_5_day_flow_ch_2" VARCHAR  -- 24 Hour 5 Day Flow CH. 2,
  "n_24_hour_aadt_5_day_flow" VARCHAR  -- 24 Hour AADT (5 Day Flow),
  "n_24_hour_5_day_flow_ch_1_rounded" VARCHAR  -- 24 Hour 5 Day Flow CH. 1 (rounded),
  "n_24_hour_5_day_flow_ch_2_rounded" VARCHAR  -- 24 Hour 5 Day Flow CH. 2 (rounded),
  "n_24_hour_aadt_5_day_flow_rounded" VARCHAR  -- 24 Hour AADT (5 Day Flow) Rounded,
  "am_peak_hour_flow_weekday_channel_1" VARCHAR,
  "am_peak_hour_flow_weekday_channel_1_rounded" VARCHAR  -- AM Peak Hour Flow Weekday Channel 1 (rounded),
  "am_peak_hour_flow_weekday_channel_1_start_time" VARCHAR,
  "pm_peak_hour_flow_weekday_channel_1" VARCHAR,
  "pm_peak_hour_flow_weekday_channel_1_rounded" VARCHAR  -- PM Peak Hour Flow Weekday Channel 1 (rounded),
  "pm_peak_hour_flow_weekday_channel_1_start_time" VARCHAR,
  "am_peak_hour_flow_weekday_channel_2" VARCHAR,
  "am_peak_hour_flow_weekday_channel_2_rounded" VARCHAR  -- AM Peak Hour Flow Weekday Channel 2 (rounded),
  "am_peak_hour_flow_weekday_channel_2_start_time" VARCHAR,
  "pm_peak_hour_flow_weekday_channel_2" VARCHAR,
  "pm_peak_hour_flow_weekday_channel_2_rounded" VARCHAR  -- PM Peak Hour Flow Weekday Channel 2 (rounded),
  "pm_peak_hour_flow_weekday_channel_2_start_time" VARCHAR,
  "n_2020_24_hour_aadt_7_day_flow_rounded" VARCHAR  -- 2020–24 Hour AADT (7 Day Flow) Rounded,
  "n_2021_age_incr_decr_over_2020_24hraadt_7_day_flow" VARCHAR  -- 2021%age Incr/decr Over 2020–24HrAADT (7 Day Flow),
  "n_2021_24_hour_aadt_7_day_flow_rounded" VARCHAR  -- 2021–24 Hour AADT (7 Day Flow) Rounded,
  "n_2022_age_incr_decr_over_2021_24hraadt_7_day_flow" VARCHAR  -- 2022 %age Incr/decr Over 2021–24HrAADT (7 Day Flow),
  "n_2022_24_hour_aadt_7_day_flow_rounded" VARCHAR  -- 2022–24 Hour AADT (7 Day Flow) Rounded,
  "n_2022_available_data" VARCHAR  -- 2022 Available Data
);

Northern Ireland Traffic Count Data 2023 Summary

@ukgov.northern_ireland_traffic_count_data.northern_ireland_traffic_count_data_2023_summary

64.93 kB
238 rows
51 columns

CREATE TABLE northern_ireland_traffic_count_data_2023_summary (
  "cp_no" VARCHAR  -- CP No.,
  "route" VARCHAR,
  "divn" VARCHAR  -- Divn.,
  "location" VARCHAR,
  "channel_1" VARCHAR,
  "channel_2" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "n_24_hour_aadt_7_day_flow" VARCHAR  -- 24 Hour AADT (7 Day Flow),
  "n_24_hour_aadt_7_day_flow_rounded" VARCHAR  -- 24 Hour AADT (7 Day Flow) Rounded,
  "n__hgv_7_day_flow" VARCHAR  -- % HGV (7 Day Flow),
  "am_mean_weekday_peak_hour_5_day_flow" VARCHAR  -- AM Mean Weekday Peak Hour (5 Day Flow),
  "am_mean_weekday_peak_hour_5_day_flow_rounded" VARCHAR  -- AM Mean Weekday Peak Hour (5 Day Flow) Rounded,
  "am_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR  -- AM Mean Weekday Peak Hour (5 Day Flow) Start Time,
  "pm_mean_weekday_peak_hour_5_day_flow" VARCHAR  -- PM Mean Weekday Peak Hour (5 Day Flow),
  "pm_mean_weekday_peak_hour_5_day_flow_rounded" VARCHAR  -- PM Mean Weekday Peak Hour (5 Day Flow) Rounded,
  "pm_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR  -- PM Mean Weekday Peak Hour (5 Day Flow) Start Time,
  "n_24_hour_7_day_flow_ch_1" VARCHAR  -- 24 Hour 7 Day Flow CH. 1,
  "n_24_hour_7_day_flow_ch_2" VARCHAR  -- 24 Hour 7 Day Flow CH. 2,
  "n_24_hour_7_day_flow_ch_1_rounded" VARCHAR  -- 24 Hour 7 Day Flow CH. 1 (rounded),
  "n_24_hour_7_day_flow_ch_2_rounded" VARCHAR  -- 24 Hour 7 Day Flow CH. 2 (rounded),
  "percentage_traffic_composition_euro_6_class_1" VARCHAR  -- Percentage Traffic Composition (Euro 6 Class 1),
  "percentage_traffic_composition_euro_6_class_2" VARCHAR  -- Percentage Traffic Composition (Euro 6 Class 2),
  "percentage_traffic_composition_euro_6_class_3" VARCHAR  -- Percentage Traffic Composition (Euro 6 Class 3),
  "percentage_traffic_composition_euro_6_class_4" VARCHAR  -- Percentage Traffic Composition (Euro 6 Class 4),
  "percentage_traffic_composition_euro_6_class_5" VARCHAR  -- Percentage Traffic Composition (Euro 6 Class 5),
  "percentage_traffic_composition_euro_6_class_6" VARCHAR  -- Percentage Traffic Composition (Euro 6 Class 6),
  "n_24_hour_5_day_flow_ch_1" VARCHAR  -- 24 Hour 5 Day Flow CH. 1,
  "n_24_hour_5_day_flow_ch_2" VARCHAR  -- 24 Hour 5 Day Flow CH. 2,
  "n_24_hour_aadt_5_day_flow" VARCHAR  -- 24 Hour AADT (5 Day Flow),
  "n_24_hour_5_day_flow_ch_1_rounded" VARCHAR  -- 24 Hour 5 Day Flow CH. 1 (rounded),
  "n_24_hour_5_day_flow_ch_2_rounded" VARCHAR  -- 24 Hour 5 Day Flow CH. 2 (rounded),
  "n_24_hour_aadt_5_day_flow_rounded" VARCHAR  -- 24 Hour AADT (5 Day Flow) Rounded,
  "am_peak_hour_flow_weekday_channel_1" VARCHAR,
  "am_peak_hour_flow_weekday_channel_1_rounded" VARCHAR  -- AM Peak Hour Flow Weekday Channel 1 (rounded),
  "am_peak_hour_flow_weekday_channel_1_start_time" VARCHAR,
  "pm_peak_hour_flow_weekday_channel_1" VARCHAR,
  "pm_peak_hour_flow_weekday_channel_1_rounded" VARCHAR  -- PM Peak Hour Flow Weekday Channel 1 (rounded),
  "pm_peak_hour_flow_weekday_channel_1_start_time" VARCHAR,
  "am_peak_hour_flow_weekday_channel_2" VARCHAR,
  "am_peak_hour_flow_weekday_channel_2_rounded" VARCHAR  -- AM Peak Hour Flow Weekday Channel 2 (rounded),
  "am_peak_hour_flow_weekday_channel_2_start_time" VARCHAR,
  "pm_peak_hour_flow_weekday_channel_2" VARCHAR,
  "pm_peak_hour_flow_weekday_channel_2_rounded" VARCHAR  -- PM Peak Hour Flow Weekday Channel 2 (rounded),
  "pm_peak_hour_flow_weekday_channel_2_start_time" VARCHAR,
  "n_2021_24_hour_aadt_7_day_flow_rounded" VARCHAR  -- 2021–24 Hour AADT (7 Day Flow) Rounded,
  "n_2022_age_incr_decr_over_2021_24hraadt_7_day_flow" VARCHAR  -- 2022%age Incr/decr Over 2021–24HrAADT (7 Day Flow),
  "n_2022_24_hour_aadt_7_day_flow_rounded" VARCHAR  -- 2022–24 Hour AADT (7 Day Flow) Rounded,
  "n_2023_age_incr_decr_over_2022_24hraadt_7_day_flow" VARCHAR  -- 2023 %age Incr/decr Over 2022–24HrAADT (7 Day Flow),
  "n_2023_24_hour_aadt_7_day_flow_rounded" VARCHAR  -- 2023–24 Hour AADT (7 Day Flow) Rounded,
  "n_2023_available_data" VARCHAR  -- 2023 Available Data
);