Baselight
Sign In

Northern Ireland Traffic Count Data

OpenDataNI

@ukgov.northern_ireland_traffic_count_data

Loading...
Loading...

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
  • 110.09 KB
  • 346 rows
  • 50 columns
Loading... 

CREATE TABLE northern_ireland_traffic_count_data_2012_summary (
  "cp_no" BIGINT,
  "route" VARCHAR,
  "divn" VARCHAR,
  "location" VARCHAR,
  "channel_1" VARCHAR,
  "channel_2" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "n_24_hour_aadt_7_day_flow" DOUBLE,
  "n_24_hour_aadt_7_day_flow_rounded" DOUBLE,
  "n__hgv_7_day_flow" VARCHAR,
  "am_mean_weekday_peak_hour_5_day_flow" DOUBLE,
  "am_mean_weekday_peak_hour_5_day_flow_rounded" DOUBLE,
  "am_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR,
  "pm_mean_weekday_peak_hour_5_day_flow" DOUBLE,
  "pm_mean_weekday_peak_hour_5_day_flow_rounded" DOUBLE,
  "pm_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR,
  "n_24_hour_7_day_flow_ch_1" DOUBLE,
  "n_24_hour_7_day_flow_ch_2" DOUBLE,
  "n_24_hour_7_day_flow_ch_1_rounded" DOUBLE,
  "n_24_hour_7_day_flow_ch_2_rounded" VARCHAR,
  "percentage_traffic_composition_car_van" VARCHAR,
  "percentage_traffic_composition_med_com" VARCHAR,
  "percentage_traffic_composition_rigid" VARCHAR,
  "percentage_traffic_composition_artic" VARCHAR,
  "percentage_traffic_composition_bus_coach" VARCHAR,
  "n_24_hour_5_day_flow_ch_1" DOUBLE,
  "n_24_hour_5_day_flow_ch_2" DOUBLE,
  "n_24_hour_aadt_5_day_flow" DOUBLE,
  "n_24_hour_5_day_flow_ch_1_rounded" DOUBLE,
  "n_24_hour_5_day_flow_ch_2_rounded" DOUBLE,
  "n_24_hour_aadt_5_day_flow_rounded" DOUBLE,
  "am_peak_hour_flow_weekday_channel_1" DOUBLE,
  "am_peak_hour_flow_weekday_channel_1_rounded" DOUBLE,
  "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_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_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_start_time" VARCHAR,
  "n_2010_24_hour_aadt_7_day_flow_rounded" DOUBLE,
  "n_2011_age_incr_decr_over_2010_24hraadt_7_day_flow" DOUBLE,
  "n_2011_24_hour_aadt_7_day_flow_rounded" DOUBLE,
  "n_2012_age_incr_decr_over_2011_24hraadt_7_day_flow" DOUBLE,
  "n_2012_24_hour_aadt_7_day_flow_rounded" DOUBLE,
  "comments" VARCHAR
);

Northern Ireland Traffic Count Data 2013 Summary

@ukgov.northern_ireland_traffic_count_data.northern_ireland_traffic_count_data_2013_summary
  • 112.82 KB
  • 351 rows
  • 50 columns
Loading... 

CREATE TABLE northern_ireland_traffic_count_data_2013_summary (
  "cp_no" BIGINT,
  "route" VARCHAR,
  "divn" VARCHAR,
  "location" VARCHAR,
  "channel_1" VARCHAR,
  "channel_2" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "n_24_hour_aadt_7_day_flow" VARCHAR,
  "n_24_hour_aadt_7_day_flow_rounded" DOUBLE,
  "n__hgv_7_day_flow" DOUBLE,
  "am_mean_weekday_peak_hour_5_day_flow" DOUBLE,
  "am_mean_weekday_peak_hour_5_day_flow_rounded" DOUBLE,
  "am_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR,
  "pm_mean_weekday_peak_hour_5_day_flow" DOUBLE,
  "pm_mean_weekday_peak_hour_5_day_flow_rounded" DOUBLE,
  "pm_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR,
  "n_24_hour_7_day_flow_ch_1" DOUBLE,
  "n_24_hour_7_day_flow_ch_2" VARCHAR,
  "n_24_hour_7_day_flow_ch_1_rounded" DOUBLE,
  "n_24_hour_7_day_flow_ch_2_rounded" DOUBLE,
  "percentage_traffic_composition_car_van" DOUBLE,
  "percentage_traffic_composition_med_com" DOUBLE,
  "percentage_traffic_composition_rigid" DOUBLE,
  "percentage_traffic_composition_artic" DOUBLE,
  "percentage_traffic_composition_bus_coach" DOUBLE,
  "n_24_hour_5_day_flow_ch_1" DOUBLE,
  "n_24_hour_5_day_flow_ch_2" VARCHAR,
  "n_24_hour_aadt_5_day_flow" DOUBLE,
  "n_24_hour_5_day_flow_ch_1_rounded" DOUBLE,
  "n_24_hour_5_day_flow_ch_2_rounded" DOUBLE,
  "n_24_hour_aadt_5_day_flow_rounded" DOUBLE,
  "am_peak_hour_flow_weekday_channel_1" DOUBLE,
  "am_peak_hour_flow_weekday_channel_1_rounded" DOUBLE,
  "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_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_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_start_time" VARCHAR,
  "n_2011_24_hour_aadt_7_day_flow_rounded" VARCHAR,
  "n_2012_age_incr_decr_over_2011_24hraadt_7_day_flow" VARCHAR,
  "n_2012_24_hour_aadt_7_day_flow_rounded" DOUBLE,
  "n_2013_age_incr_decr_over_2012_24hraadt_7_day_flow" VARCHAR,
  "n_2013_24_hour_aadt_7_day_flow_rounded" VARCHAR,
  "comments" VARCHAR
);

Northern Ireland Traffic Count Data 2014 Summary

@ukgov.northern_ireland_traffic_count_data.northern_ireland_traffic_count_data_2014_summary
  • 114.45 KB
  • 351 rows
  • 50 columns
Loading... 

CREATE TABLE northern_ireland_traffic_count_data_2014_summary (
  "cp_no" BIGINT,
  "route" VARCHAR,
  "divn" VARCHAR,
  "location" VARCHAR,
  "channel_1" VARCHAR,
  "channel_2" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "n_24_hour_aadt_7_day_flow" VARCHAR,
  "n_24_hour_aadt_7_day_flow_rounded" BIGINT,
  "n__hgv_7_day_flow" VARCHAR,
  "am_mean_weekday_peak_hour_5_day_flow" VARCHAR,
  "am_mean_weekday_peak_hour_5_day_flow_rounded" VARCHAR,
  "am_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR,
  "pm_mean_weekday_peak_hour_5_day_flow" VARCHAR,
  "pm_mean_weekday_peak_hour_5_day_flow_rounded" VARCHAR,
  "pm_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR,
  "n_24_hour_7_day_flow_ch_1" VARCHAR,
  "n_24_hour_7_day_flow_ch_2" VARCHAR,
  "n_24_hour_7_day_flow_ch_1_rounded" VARCHAR,
  "n_24_hour_7_day_flow_ch_2_rounded" VARCHAR,
  "percentage_traffic_composition_car_van" VARCHAR,
  "percentage_traffic_composition_med_com" VARCHAR,
  "percentage_traffic_composition_rigid" VARCHAR,
  "percentage_traffic_composition_artic" VARCHAR,
  "percentage_traffic_composition_bus_coach" VARCHAR,
  "n_24_hour_5_day_flow_ch_1" VARCHAR,
  "n_24_hour_5_day_flow_ch_2" VARCHAR,
  "n_24_hour_aadt_5_day_flow" VARCHAR,
  "n_24_hour_5_day_flow_ch_1_rounded" VARCHAR,
  "n_24_hour_5_day_flow_ch_2_rounded" VARCHAR,
  "n_24_hour_aadt_5_day_flow_rounded" VARCHAR,
  "am_peak_hour_flow_weekday_channel_1" VARCHAR,
  "am_peak_hour_flow_weekday_channel_1_rounded" VARCHAR,
  "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_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_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_start_time" VARCHAR,
  "n_2012_24_hour_aadt_7_day_flow_rounded" VARCHAR,
  "n_2013_age_incr_decr_over_2012_24hraadt_7_day_flow" VARCHAR,
  "n_2013_24_hour_aadt_7_day_flow_rounded" VARCHAR,
  "n_2014_age_incr_decr_over_2013_24hraadt_7_day_flow" VARCHAR,
  "n_2014_24_hour_aadt_7_day_flow_rounded" BIGINT,
  "comments" VARCHAR
);

Northern Ireland Traffic Count Data 2015 Summary

@ukgov.northern_ireland_traffic_count_data.northern_ireland_traffic_count_data_2015_summary
  • 115.39 KB
  • 351 rows
  • 50 columns
Loading... 

CREATE TABLE northern_ireland_traffic_count_data_2015_summary (
  "cp_no" BIGINT,
  "route" VARCHAR,
  "divn" VARCHAR,
  "location" VARCHAR,
  "channel_1" VARCHAR,
  "channel_2" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "n_24_hour_aadt_7_day_flow" DOUBLE,
  "n_24_hour_aadt_7_day_flow_rounded" DOUBLE,
  "n__hgv_7_day_flow" DOUBLE,
  "am_mean_weekday_peak_hour_5_day_flow" DOUBLE,
  "am_mean_weekday_peak_hour_5_day_flow_rounded" DOUBLE,
  "am_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR,
  "pm_mean_weekday_peak_hour_5_day_flow" DOUBLE,
  "pm_mean_weekday_peak_hour_5_day_flow_rounded" DOUBLE,
  "pm_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR,
  "n_24_hour_7_day_flow_ch_1" DOUBLE,
  "n_24_hour_7_day_flow_ch_2" DOUBLE,
  "n_24_hour_7_day_flow_ch_1_rounded" DOUBLE,
  "n_24_hour_7_day_flow_ch_2_rounded" DOUBLE,
  "percentage_traffic_composition_car_van" DOUBLE,
  "percentage_traffic_composition_med_com" DOUBLE,
  "percentage_traffic_composition_rigid" DOUBLE,
  "percentage_traffic_composition_artic" DOUBLE,
  "percentage_traffic_composition_bus_coach" DOUBLE,
  "n_24_hour_5_day_flow_ch_1" DOUBLE,
  "n_24_hour_5_day_flow_ch_2" DOUBLE,
  "n_24_hour_aadt_5_day_flow" DOUBLE,
  "n_24_hour_5_day_flow_ch_1_rounded" DOUBLE,
  "n_24_hour_5_day_flow_ch_2_rounded" DOUBLE,
  "n_24_hour_aadt_5_day_flow_rounded" DOUBLE,
  "am_peak_hour_flow_weekday_channel_1" DOUBLE,
  "am_peak_hour_flow_weekday_channel_1_rounded" DOUBLE,
  "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_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_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_start_time" VARCHAR,
  "n_2013_24_hour_aadt_7_day_flow_rounded" DOUBLE,
  "n_2014_age_incr_decr_over_2013_24hraadt_7_day_flow" DOUBLE,
  "n_2014_24_hour_aadt_7_day_flow_rounded" DOUBLE,
  "n_2015_age_incr_decr_over_2014_24hraadt_7_day_flow" DOUBLE,
  "n_2015_24_hour_aadt_7_day_flow_rounded" DOUBLE,
  "comments" VARCHAR
);

Northern Ireland Traffic Count Data 2016 Summary

@ukgov.northern_ireland_traffic_count_data.northern_ireland_traffic_count_data_2016_summary
  • 107.43 KB
  • 351 rows
  • 57 columns
Loading... 

CREATE TABLE northern_ireland_traffic_count_data_2016_summary (
  "cp_no" BIGINT,
  "route" VARCHAR,
  "divn" VARCHAR,
  "location" VARCHAR,
  "channel_1" VARCHAR,
  "channel_2" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "n_24_hour_aadt_7_day_flow" DOUBLE,
  "n_24_hour_aadt_7_day_flow_rounded" DOUBLE,
  "n__hgv_7_day_flow" VARCHAR,
  "am_mean_weekday_peak_hour_5_day_flow" DOUBLE,
  "am_mean_weekday_peak_hour_5_day_flow_rounded" DOUBLE,
  "am_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR,
  "pm_mean_weekday_peak_hour_5_day_flow" DOUBLE,
  "pm_mean_weekday_peak_hour_5_day_flow_rounded" DOUBLE,
  "pm_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR,
  "n_24_hour_7_day_flow_ch_1" DOUBLE,
  "n_24_hour_7_day_flow_ch_2" VARCHAR,
  "n_24_hour_7_day_flow_ch_1_rounded" DOUBLE,
  "n_24_hour_7_day_flow_ch_2_rounded" VARCHAR,
  "percentage_traffic_composition_car_van" VARCHAR,
  "percentage_traffic_composition_med_com" VARCHAR,
  "percentage_traffic_composition_rigid" VARCHAR,
  "percentage_traffic_composition_artic" VARCHAR,
  "percentage_traffic_composition_bus_coach" VARCHAR,
  "n_24_hour_5_day_flow_ch_1" DOUBLE,
  "n_24_hour_5_day_flow_ch_2" DOUBLE,
  "n_24_hour_aadt_5_day_flow" DOUBLE,
  "n_24_hour_5_day_flow_ch_1_rounded" DOUBLE,
  "n_24_hour_5_day_flow_ch_2_rounded" DOUBLE,
  "n_24_hour_aadt_5_day_flow_rounded" DOUBLE,
  "am_peak_hour_flow_weekday_channel_1" DOUBLE,
  "am_peak_hour_flow_weekday_channel_1_rounded" DOUBLE,
  "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_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_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_start_time" VARCHAR,
  "n_2014_24_hour_aadt_7_day_flow_rounded" DOUBLE,
  "n_2015_age_incr_decr_over_2014_24hraadt_7_day_flow" DOUBLE,
  "n_2015_24_hour_aadt_7_day_flow_rounded" DOUBLE,
  "n_2016_age_incr_decr_over_2015_24hraadt_7_day_flow" VARCHAR,
  "n_2016_24_hour_aadt_7_day_flow_rounded" VARCHAR,
  "comments" VARCHAR,
  "unnamed_50" VARCHAR,
  "unnamed_51" VARCHAR,
  "unnamed_52" VARCHAR,
  "unnamed_53" VARCHAR,
  "unnamed_54" VARCHAR,
  "unnamed_55" VARCHAR,
  "unnamed_56" VARCHAR
);

Northern Ireland Traffic Count Data 2017 Summary

@ukgov.northern_ireland_traffic_count_data.northern_ireland_traffic_count_data_2017_summary
  • 74.07 KB
  • 86 rows
  • 63 columns
Loading... 

CREATE TABLE northern_ireland_traffic_count_data_2017_summary (
  "cp_no" VARCHAR,
  "route" VARCHAR,
  "divn" VARCHAR,
  "location" VARCHAR,
  "channel_1" VARCHAR,
  "channel_2" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "n_24_hour_aadt_7_day_flow" BIGINT,
  "n_24_hour_aadt_7_day_flow_rounded" BIGINT,
  "n__hgv_7_day_flow" VARCHAR,
  "am_mean_weekday_peak_hour_5_day_flow" BIGINT,
  "am_mean_weekday_peak_hour_5_day_flow_rounded" BIGINT,
  "am_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR,
  "pm_mean_weekday_peak_hour_5_day_flow" BIGINT,
  "pm_mean_weekday_peak_hour_5_day_flow_rounded" BIGINT,
  "pm_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR,
  "n_24_hour_7_day_flow_ch_1" BIGINT,
  "n_24_hour_7_day_flow_ch_2" VARCHAR,
  "n_24_hour_7_day_flow_ch_1_rounded" BIGINT,
  "n_24_hour_7_day_flow_ch_2_rounded" VARCHAR,
  "percentage_traffic_composition_euro_6_class_1" VARCHAR,
  "percentage_traffic_composition_euro_6_class_2" VARCHAR,
  "percentage_traffic_composition_euro_6_class_3" VARCHAR,
  "percentage_traffic_composition_euro_6_class_4" VARCHAR,
  "percentage_traffic_composition_euro_6_class_5" VARCHAR,
  "percentage_traffic_composition_euro_6_class_6" VARCHAR,
  "percentage_traffic_composition_doeni5_class_1" VARCHAR,
  "percentage_traffic_composition_doeni5_class_2" VARCHAR,
  "percentage_traffic_composition_doeni5_class_3" VARCHAR,
  "percentage_traffic_composition_doeni5_class_4" VARCHAR,
  "percentage_traffic_composition_doeni5_class_5" VARCHAR,
  "n_24_hour_5_day_flow_ch_1" BIGINT,
  "n_24_hour_5_day_flow_ch_2" VARCHAR,
  "n_24_hour_aadt_5_day_flow" BIGINT,
  "n_24_hour_5_day_flow_ch_1_rounded" BIGINT,
  "n_24_hour_5_day_flow_ch_2_rounded" VARCHAR,
  "n_24_hour_aadt_5_day_flow_rounded" BIGINT,
  "am_peak_hour_flow_weekday_channel_1" BIGINT,
  "am_peak_hour_flow_weekday_channel_1_rounded" BIGINT,
  "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_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_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_start_time" VARCHAR,
  "n_2015_24_hour_aadt_7_day_flow_rounded" VARCHAR,
  "n_2016_age_incr_decr_over_2015_24hraadt_7_day_flow" VARCHAR,
  "n_2016_24_hour_aadt_7_day_flow_rounded" VARCHAR,
  "n_2017_age_incr_decr_over_2016_24hraadt_7_day_flow" VARCHAR,
  "n_2017_24_hour_aadt_7_day_flow_rounded" BIGINT,
  "comments" VARCHAR,
  "unnamed_56" VARCHAR,
  "unnamed_57" VARCHAR,
  "unnamed_58" VARCHAR,
  "unnamed_59" VARCHAR,
  "unnamed_60" VARCHAR,
  "unnamed_61" VARCHAR,
  "unnamed_62" VARCHAR
);

Northern Ireland Traffic Count Data 2018 Summary

@ukgov.northern_ireland_traffic_count_data.northern_ireland_traffic_count_data_2018_summary
  • 66.85 KB
  • 89 rows
  • 52 columns
Loading... 

CREATE TABLE northern_ireland_traffic_count_data_2018_summary (
  "cp_no" VARCHAR,
  "route" VARCHAR,
  "divn" VARCHAR,
  "location" VARCHAR,
  "channel_1" VARCHAR,
  "channel_2" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "n_24_hour_aadt_7_day_flow" VARCHAR,
  "n_24_hour_aadt_7_day_flow_rounded" VARCHAR,
  "n__hgv_7_day_flow" VARCHAR,
  "am_mean_weekday_peak_hour_5_day_flow" VARCHAR,
  "am_mean_weekday_peak_hour_5_day_flow_rounded" VARCHAR,
  "am_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR,
  "pm_mean_weekday_peak_hour_5_day_flow" VARCHAR,
  "pm_mean_weekday_peak_hour_5_day_flow_rounded" VARCHAR,
  "pm_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR,
  "n_24_hour_7_day_flow_ch_1" VARCHAR,
  "n_24_hour_7_day_flow_ch_2" VARCHAR,
  "n_24_hour_7_day_flow_ch_1_rounded" VARCHAR,
  "n_24_hour_7_day_flow_ch_2_rounded" VARCHAR,
  "percentage_traffic_composition_euro_6_class_1" VARCHAR,
  "percentage_traffic_composition_euro_6_class_2" VARCHAR,
  "percentage_traffic_composition_euro_6_class_3" VARCHAR,
  "percentage_traffic_composition_euro_6_class_4" VARCHAR,
  "percentage_traffic_composition_euro_6_class_5" VARCHAR,
  "percentage_traffic_composition_euro_6_class_6" VARCHAR,
  "n_24_hour_5_day_flow_ch_1" VARCHAR,
  "n_24_hour_5_day_flow_ch_2" VARCHAR,
  "n_24_hour_aadt_5_day_flow" VARCHAR,
  "n_24_hour_5_day_flow_ch_1_rounded" VARCHAR,
  "n_24_hour_5_day_flow_ch_2_rounded" VARCHAR,
  "n_24_hour_aadt_5_day_flow_rounded" VARCHAR,
  "am_peak_hour_flow_weekday_channel_1" VARCHAR,
  "am_peak_hour_flow_weekday_channel_1_rounded" VARCHAR,
  "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_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_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_start_time" VARCHAR,
  "n_2016_24_hour_aadt_7_day_flow_rounded" VARCHAR,
  "n_2017_age_incr_decr_over_2016_24hraadt_7_day_flow" VARCHAR,
  "n_2017_24_hour_aadt_7_day_flow_rounded" VARCHAR,
  "n_2018_age_incr_decr_over_2017_24hraadt_7_day_flow" VARCHAR,
  "n_2018_24_hour_aadt_7_day_flow_rounded" VARCHAR,
  "comments" VARCHAR,
  "unnamed_51" VARCHAR
);

Northern Ireland Traffic Count Data 2019 Summary

@ukgov.northern_ireland_traffic_count_data.northern_ireland_traffic_count_data_2019_summary
  • 64.16 KB
  • 90 rows
  • 51 columns
Loading... 

CREATE TABLE northern_ireland_traffic_count_data_2019_summary (
  "cp_no" VARCHAR,
  "route" VARCHAR,
  "divn" VARCHAR,
  "location" VARCHAR,
  "channel_1" VARCHAR,
  "channel_2" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "n_24_hour_aadt_7_day_flow" VARCHAR,
  "n_24_hour_aadt_7_day_flow_rounded" VARCHAR,
  "n__hgv_7_day_flow" VARCHAR,
  "am_mean_weekday_peak_hour_5_day_flow" VARCHAR,
  "am_mean_weekday_peak_hour_5_day_flow_rounded" VARCHAR,
  "am_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR,
  "pm_mean_weekday_peak_hour_5_day_flow" VARCHAR,
  "pm_mean_weekday_peak_hour_5_day_flow_rounded" VARCHAR,
  "pm_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR,
  "n_24_hour_7_day_flow_ch_1" VARCHAR,
  "n_24_hour_7_day_flow_ch_2" VARCHAR,
  "n_24_hour_7_day_flow_ch_1_rounded" VARCHAR,
  "n_24_hour_7_day_flow_ch_2_rounded" VARCHAR,
  "percentage_traffic_composition_euro_6_class_1" VARCHAR,
  "percentage_traffic_composition_euro_6_class_2" VARCHAR,
  "percentage_traffic_composition_euro_6_class_3" VARCHAR,
  "percentage_traffic_composition_euro_6_class_4" VARCHAR,
  "percentage_traffic_composition_euro_6_class_5" VARCHAR,
  "percentage_traffic_composition_euro_6_class_6" VARCHAR,
  "n_24_hour_5_day_flow_ch_1" VARCHAR,
  "n_24_hour_5_day_flow_ch_2" VARCHAR,
  "n_24_hour_aadt_5_day_flow" VARCHAR,
  "n_24_hour_5_day_flow_ch_1_rounded" VARCHAR,
  "n_24_hour_5_day_flow_ch_2_rounded" VARCHAR,
  "n_24_hour_aadt_5_day_flow_rounded" VARCHAR,
  "am_peak_hour_flow_weekday_channel_1" VARCHAR,
  "am_peak_hour_flow_weekday_channel_1_rounded" VARCHAR,
  "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_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_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_start_time" VARCHAR,
  "n_2017_24_hour_aadt_7_day_flow_rounded" VARCHAR,
  "n_2018_age_incr_decr_over_2017_24hraadt_7_day_flow" VARCHAR,
  "n_2018_24_hour_aadt_7_day_flow_rounded" VARCHAR,
  "n_2019_age_incr_decr_over_2018_24hraadt_7_day_flow" VARCHAR,
  "n_2019_24_hour_aadt_7_day_flow_rounded" VARCHAR,
  "comments" VARCHAR
);

Northern Ireland Traffic Count Data 2020 Summary

@ukgov.northern_ireland_traffic_count_data.northern_ireland_traffic_count_data_2020_summary
  • 65.95 KB
  • 234 rows
  • 51 columns
Loading... 

CREATE TABLE northern_ireland_traffic_count_data_2020_summary (
  "cp_no" VARCHAR,
  "route" VARCHAR,
  "divn" VARCHAR,
  "location" VARCHAR,
  "channel_1" VARCHAR,
  "channel_2" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "n_24_hour_aadt_7_day_flow" DOUBLE,
  "n_24_hour_aadt_7_day_flow_rounded" DOUBLE,
  "n__hgv_7_day_flow" DOUBLE,
  "am_mean_weekday_peak_hour_5_day_flow" DOUBLE,
  "am_mean_weekday_peak_hour_5_day_flow_rounded" DOUBLE,
  "am_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR,
  "pm_mean_weekday_peak_hour_5_day_flow" DOUBLE,
  "pm_mean_weekday_peak_hour_5_day_flow_rounded" DOUBLE,
  "pm_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR,
  "n_24_hour_7_day_flow_ch_1" DOUBLE,
  "n_24_hour_7_day_flow_ch_2" DOUBLE,
  "n_24_hour_7_day_flow_ch_1_rounded" DOUBLE,
  "n_24_hour_7_day_flow_ch_2_rounded" DOUBLE,
  "percentage_traffic_composition_euro_6_class_1" DOUBLE,
  "percentage_traffic_composition_euro_6_class_2" DOUBLE,
  "percentage_traffic_composition_euro_6_class_3" DOUBLE,
  "percentage_traffic_composition_euro_6_class_4" DOUBLE,
  "percentage_traffic_composition_euro_6_class_5" DOUBLE,
  "percentage_traffic_composition_euro_6_class_6" DOUBLE,
  "n_24_hour_5_day_flow_ch_1" DOUBLE,
  "n_24_hour_5_day_flow_ch_2" DOUBLE,
  "n_24_hour_aadt_5_day_flow" DOUBLE,
  "n_24_hour_5_day_flow_ch_1_rounded" DOUBLE,
  "n_24_hour_5_day_flow_ch_2_rounded" DOUBLE,
  "n_24_hour_aadt_5_day_flow_rounded" DOUBLE,
  "am_peak_hour_flow_weekday_channel_1" DOUBLE,
  "am_peak_hour_flow_weekday_channel_1_rounded" DOUBLE,
  "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_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_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_start_time" VARCHAR,
  "n_2018_24_hour_aadt_7_day_flow_rounded" VARCHAR,
  "n_2019_age_incr_decr_over_2018_24hraadt_7_day_flow" DOUBLE,
  "n_2019_24_hour_aadt_7_day_flow_rounded" DOUBLE,
  "n_2020_age_incr_decr_over_2019_24hraadt_7_day_flow" DOUBLE,
  "n_2020_24_hour_aadt_7_day_flow_rounded" DOUBLE,
  "comments" VARCHAR
);

Northern Ireland Traffic Count Data 2021 Summary

@ukgov.northern_ireland_traffic_count_data.northern_ireland_traffic_count_data_2021_summary
  • 63.75 KB
  • 96 rows
  • 51 columns
Loading... 

CREATE TABLE northern_ireland_traffic_count_data_2021_summary (
  "cp_no" VARCHAR,
  "route" VARCHAR,
  "divn" VARCHAR,
  "location" VARCHAR,
  "channel_1" VARCHAR,
  "channel_2" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "n_24_hour_aadt_7_day_flow" VARCHAR,
  "n_24_hour_aadt_7_day_flow_rounded" VARCHAR,
  "n__hgv_7_day_flow" VARCHAR,
  "am_mean_weekday_peak_hour_5_day_flow" VARCHAR,
  "am_mean_weekday_peak_hour_5_day_flow_rounded" VARCHAR,
  "am_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR,
  "pm_mean_weekday_peak_hour_5_day_flow" VARCHAR,
  "pm_mean_weekday_peak_hour_5_day_flow_rounded" VARCHAR,
  "pm_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR,
  "n_24_hour_7_day_flow_ch_1" VARCHAR,
  "n_24_hour_7_day_flow_ch_2" VARCHAR,
  "n_24_hour_7_day_flow_ch_1_rounded" VARCHAR,
  "n_24_hour_7_day_flow_ch_2_rounded" VARCHAR,
  "percentage_traffic_composition_euro_6_class_1" VARCHAR,
  "percentage_traffic_composition_euro_6_class_2" VARCHAR,
  "percentage_traffic_composition_euro_6_class_3" VARCHAR,
  "percentage_traffic_composition_euro_6_class_4" VARCHAR,
  "percentage_traffic_composition_euro_6_class_5" VARCHAR,
  "percentage_traffic_composition_euro_6_class_6" VARCHAR,
  "n_24_hour_5_day_flow_ch_1" VARCHAR,
  "n_24_hour_5_day_flow_ch_2" VARCHAR,
  "n_24_hour_aadt_5_day_flow" VARCHAR,
  "n_24_hour_5_day_flow_ch_1_rounded" VARCHAR,
  "n_24_hour_5_day_flow_ch_2_rounded" VARCHAR,
  "n_24_hour_aadt_5_day_flow_rounded" VARCHAR,
  "am_peak_hour_flow_weekday_channel_1" VARCHAR,
  "am_peak_hour_flow_weekday_channel_1_rounded" VARCHAR,
  "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_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_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_start_time" VARCHAR,
  "n_2019_24_hour_aadt_7_day_flow_rounded" VARCHAR,
  "n_2020_age_incr_decr_over_2019_24hraadt_7_day_flow" VARCHAR,
  "n_2020_24_hour_aadt_7_day_flow_rounded" VARCHAR,
  "n_2021_age_incr_decr_over_2020_24hraadt_7_day_flow" VARCHAR,
  "n_2021_24_hour_aadt_7_day_flow_rounded" VARCHAR,
  "comments" VARCHAR
);

Northern Ireland Traffic Count Data 2022 Summary

@ukgov.northern_ireland_traffic_count_data.northern_ireland_traffic_count_data_2022_summary
  • 63.64 KB
  • 96 rows
  • 51 columns
Loading... 

CREATE TABLE northern_ireland_traffic_count_data_2022_summary (
  "cp_no" VARCHAR,
  "route" VARCHAR,
  "divn" VARCHAR,
  "location" VARCHAR,
  "channel_1" VARCHAR,
  "channel_2" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "n_24_hour_aadt_7_day_flow" VARCHAR,
  "n_24_hour_aadt_7_day_flow_rounded" VARCHAR,
  "n__hgv_7_day_flow" VARCHAR,
  "am_mean_weekday_peak_hour_5_day_flow" VARCHAR,
  "am_mean_weekday_peak_hour_5_day_flow_rounded" VARCHAR,
  "am_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR,
  "pm_mean_weekday_peak_hour_5_day_flow" VARCHAR,
  "pm_mean_weekday_peak_hour_5_day_flow_rounded" VARCHAR,
  "pm_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR,
  "n_24_hour_7_day_flow_ch_1" VARCHAR,
  "n_24_hour_7_day_flow_ch_2" VARCHAR,
  "n_24_hour_7_day_flow_ch_1_rounded" VARCHAR,
  "n_24_hour_7_day_flow_ch_2_rounded" VARCHAR,
  "percentage_traffic_composition_euro_6_class_1" VARCHAR,
  "percentage_traffic_composition_euro_6_class_2" VARCHAR,
  "percentage_traffic_composition_euro_6_class_3" VARCHAR,
  "percentage_traffic_composition_euro_6_class_4" VARCHAR,
  "percentage_traffic_composition_euro_6_class_5" VARCHAR,
  "percentage_traffic_composition_euro_6_class_6" VARCHAR,
  "n_24_hour_5_day_flow_ch_1" VARCHAR,
  "n_24_hour_5_day_flow_ch_2" VARCHAR,
  "n_24_hour_aadt_5_day_flow" VARCHAR,
  "n_24_hour_5_day_flow_ch_1_rounded" VARCHAR,
  "n_24_hour_5_day_flow_ch_2_rounded" VARCHAR,
  "n_24_hour_aadt_5_day_flow_rounded" VARCHAR,
  "am_peak_hour_flow_weekday_channel_1" VARCHAR,
  "am_peak_hour_flow_weekday_channel_1_rounded" VARCHAR,
  "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_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_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_start_time" VARCHAR,
  "n_2020_24_hour_aadt_7_day_flow_rounded" VARCHAR,
  "n_2021_age_incr_decr_over_2020_24hraadt_7_day_flow" VARCHAR,
  "n_2021_24_hour_aadt_7_day_flow_rounded" VARCHAR,
  "n_2022_age_incr_decr_over_2021_24hraadt_7_day_flow" VARCHAR,
  "n_2022_24_hour_aadt_7_day_flow_rounded" VARCHAR,
  "n_2022_available_data" VARCHAR
);

Northern Ireland Traffic Count Data 2023 Summary

@ukgov.northern_ireland_traffic_count_data.northern_ireland_traffic_count_data_2023_summary
  • 63.41 KB
  • 238 rows
  • 51 columns
Loading... 

CREATE TABLE northern_ireland_traffic_count_data_2023_summary (
  "cp_no" VARCHAR,
  "route" VARCHAR,
  "divn" VARCHAR,
  "location" VARCHAR,
  "channel_1" VARCHAR,
  "channel_2" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "n_24_hour_aadt_7_day_flow" VARCHAR,
  "n_24_hour_aadt_7_day_flow_rounded" VARCHAR,
  "n__hgv_7_day_flow" VARCHAR,
  "am_mean_weekday_peak_hour_5_day_flow" VARCHAR,
  "am_mean_weekday_peak_hour_5_day_flow_rounded" VARCHAR,
  "am_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR,
  "pm_mean_weekday_peak_hour_5_day_flow" VARCHAR,
  "pm_mean_weekday_peak_hour_5_day_flow_rounded" VARCHAR,
  "pm_mean_weekday_peak_hour_5_day_flow_start_time" VARCHAR,
  "n_24_hour_7_day_flow_ch_1" VARCHAR,
  "n_24_hour_7_day_flow_ch_2" VARCHAR,
  "n_24_hour_7_day_flow_ch_1_rounded" VARCHAR,
  "n_24_hour_7_day_flow_ch_2_rounded" VARCHAR,
  "percentage_traffic_composition_euro_6_class_1" VARCHAR,
  "percentage_traffic_composition_euro_6_class_2" VARCHAR,
  "percentage_traffic_composition_euro_6_class_3" VARCHAR,
  "percentage_traffic_composition_euro_6_class_4" VARCHAR,
  "percentage_traffic_composition_euro_6_class_5" VARCHAR,
  "percentage_traffic_composition_euro_6_class_6" VARCHAR,
  "n_24_hour_5_day_flow_ch_1" VARCHAR,
  "n_24_hour_5_day_flow_ch_2" VARCHAR,
  "n_24_hour_aadt_5_day_flow" VARCHAR,
  "n_24_hour_5_day_flow_ch_1_rounded" VARCHAR,
  "n_24_hour_5_day_flow_ch_2_rounded" VARCHAR,
  "n_24_hour_aadt_5_day_flow_rounded" VARCHAR,
  "am_peak_hour_flow_weekday_channel_1" VARCHAR,
  "am_peak_hour_flow_weekday_channel_1_rounded" VARCHAR,
  "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_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_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_start_time" VARCHAR,
  "n_2021_24_hour_aadt_7_day_flow_rounded" VARCHAR,
  "n_2022_age_incr_decr_over_2021_24hraadt_7_day_flow" VARCHAR,
  "n_2022_24_hour_aadt_7_day_flow_rounded" VARCHAR,
  "n_2023_age_incr_decr_over_2022_24hraadt_7_day_flow" VARCHAR,
  "n_2023_24_hour_aadt_7_day_flow_rounded" VARCHAR,
  "n_2023_available_data" VARCHAR
);

Share link

Anyone who has the link will be able to view this.