The National Network dataset is as of December 22, 2020 and is from the Bureau of Transportation Statistics (BTS) along with the Federal Highway Administration (FHWA), and part of the U.S. Department of Transportation (USDOT)/Bureau of Transportation Statistics (BTS) National Transportation Atlas Database (NTAD). The National Network was authorized by the Surface Transportation Assistance Act of 1982 (P.L. 97-424) and specified in the U.S. Code of Federal Regulations (23 CFR 658) to require states to allow conventional combinations on "the Interstate System and those portions of the Federal-aid Primary System serving to link principal cities and densely developed portions of the states on high volume routes utilized extensively by large vehicles for interstate commerce which do not have any unusual characteristics causing current or anticipated safety problems. “The National Network (NN) includes almost all of the Interstate Highway System and other, specified non-Interstate highways. On March 31, 2025, four (4) records were updated to correct their "SIGNT1" and "SIGNN1" values. “The National Network (NN) includes almost all of the Interstate Highway System and other, specified non-Interstate highways. The network comprises more than 200,000 miles of highways. The National Network supports interstate commerce by regulating the size of trucks. This file is a geospatial representation of the National Network as described in 23 CFR 658 Appendix A and should not be interpreted as the official National Network and should not be used for truck size and weight enforcement purposes or for navigation. A data dictionary, or other source of attribute information, is accessible at https://doi.org/10.21949/1529045

The Means of Transportation to Work dataset was compiled using information from December 08, 2022 and updated September 01, 2023 from the Bureau of Transportation Statistics (BTS) and is part of the U.S. Department of Transportation (USDOT)/Bureau of Transportation Statistics (BTS) National Transportation Atlas Database (NTAD). The Means of Transportation to Work table from the 2021 American Community Survey (ACS) (5-year estimates) was joined by 2020 tract-level shapefiles for all 50 States, District of Columbia and Puerto Rico provided by the Census Bureau. A new file was created that combines the demographic variables from the former with the cartographic boundaries of the latter. The demographic variables contain count estimates for means of transportation to work, by Census tract, and the geospatial file allows these values to be visualized on a map. Percentage values for the count estimates were calculated and added, with workers 16 years and over as the denominator.

The dataset provides noise data to facilitate the tracking of trends in transportation-related noise. This dataset includes results from simplified noise modeling methods and should not be used to evaluate noise levels in individual locations. See the documentation for a full description of methodologies and assumptions: https://doi.org/10.21949/1519111 The 2016 National Transportation Noise Map dataset utilized transportation mode input data from 2016 in a model and is current as of October 2020, published by the Bureau of Transportation Statistics (BTS), and is part of the U.S. Department of Transportation (USDOT)/Bureau of Transportation Statistics (BTS) National Transportation Atlas Database (NTAD). Please see the website https://www.bts.gov/geospatial/national-transportation-noise-map, for downloads and more information about these datasets. For web services of these data, please navigate to https://geo.dot.gov/server/rest/services/Hosted and search for service names beginning with "Noise." Data within the National Transportation Noise Map represent potential noise levels across the nation for an average annual day for the specified year. These data are intended to facilitate the tracking of trends in transportation-related noise by mode collectively over time and should not be used to evaluate noise levels in individual locations and/or at specific times. This dataset is developed using a 24-hr equivalent A-weighted sound level (denoted by LAeq) noise metric. The results represent the approximate average noise energy due to transportation noise sources over a 24-hour period at the receptor locations where noise is computed. Layers include Aviation and Road Noise for the Lower 48 States as well as Alaska and Hawaii. The full listing can be found below. 2016 National Transportation Noise Alaska Alaska Aviation Noise Alaska Road and Aviation Noise Alaska Road Noise Lower 48 States (CONUS) Lower 48 States (CONUS) Aviation Noise Lower 48 States (CONUS) Road and Aviation Noise Lower 48 States (CONUS) Road Noise Hawaii Hawaii Aviation Noise Hawaii Road and Aviation Noise Hawaii Road Noise

The Airports dataset includes all official and operational aerodromes as of July 16, 2020 and is part of the U.S. Department of Transportation (USDOT)/Bureau of Transportation Statistics (BTS) National Transportation Atlas Database (NTAD). The Airports database is a geographic point database of official operational aerodromes in the United States and U.S. Territories. Attribute data is provided on the physical and operational characteristics of the aerodrome, current usage including enplanements and aircraft operations, congestion levels and usage categories. This geospatial data is derived from the FAA's National Airspace System Resource Aeronautical Data Product.

The Intermodal Freight Facilities Air-to-Truck dataset was compiled on January 15, 2019 and was updated on February 24, 2020 from the Bureau of Transportation Statistics (BTS) and is part of the U.S. Department of Transportation (USDOT)/Bureau of Transportation Statistics (BTS) National Transportation Atlas Database (NTAD). This dataset includes air to truck intermodal freight facilities for the top 60 airports by total freight moved in 2017. This dataset is one of several layers in the Bureau of Transportation Statistics (BTS) Intermodal Freight Facility Database. A data dictionary, or other source of attribute information, is accessible at https://doi.org/10.21949/1529031

The Household Size by Vehicles Available dataset was compiled on September 17, 2020 and was updated on October 07, 2021 from the Bureau of Transportation Statistics (BTS) and is part of the U.S. Department of Transportation (USDOT)/Bureau of Transportation Statistics’ (BTS') National Transportation Atlas Database (NTAD). This data was joined by 2019 tract-level shapefiles for all 50 States, District of Columbia and Puerto Rico, also provided by Census. A new file was created the combines the demographic variables from the former with the cartographic boundaries of the latter. The demographic variables contain count estimates for number of vehicles per person, by Census tract, the shapefile allows these values to be visualized on a map. Percentage values for the count estimates were calcluated and added, with households as the denominator.

The 2020 National Transportation Noise Map dataset utilized transportation mode input data from 2020 in a model and is current as of October 2022, published by the Bureau of Transportation Statistics (BTS), and is part of the U.S. Department of Transportation (USDOT)/Bureau of Transportation Statistics (BTS) National Transportation Atlas Database (NTAD). Please see the website https://www.bts.gov/geospatial/national-transportation-noise-map, for downloads and more information about these datasets. For web services of these data, please navigate to https://geo.dot.gov/server/rest/services/Hosted and search for service names beginning with "Noise." Please contact j.goworowska@dot.gov for any questions. Data within the National Transportation Noise Map represent potential noise levels across the nation for an average annual day for the specified year. These data are intended to facilitate the tracking of trends in transportation-related noise by mode collectively over time and should not be used to evaluate noise levels in individual locations and/or at specific times. This dataset is developed using a 24-hr equivalent A-weighted sound level (denoted by LAeq) noise metric. The results represent the approximate average noise energy due to transportation noise sources over a 24-hour period at the receptor locations where noise is computed. Layers include Aviation, Freight and Passenger Rail, and Road Noise for the Lower 48 States as well as Alaska and Hawaii. The full listing can be found below. 2020 National Transportation Noise

      Alaska

             Alaska Aviation Noise
             Alaska Freight and Passenger Rail Noise
             Alaska Freight and Passenger Rail, Road, and Aviation Noise
             Alaska Road and Aviation Noise
             Alaska Road Noise

      Lower 48 States (CONUS)

             Lower 48 States (CONUS) Aviation Noise
             Lower 48 States (CONUS) Freight and Passenger Rail Noise
             Lower 48 States (CONUS) Freight and Passenger Rail, Road, and Aviation Noise
             Lower 48 States (CONUS) Road and Aviation Noise
             Lower 48 States (CONUS) Road Noise

      Hawaii

             Hawaii Aviation Noise
             Hawaii Road and Aviation Noise
             Hawaii Road Noise

Context

Monthly Transportation Statistics is a compilation of national statistics on transportation. The Bureau of Transportation Statistics brings together the latest data from across the Federal government and transportation industry.

Monthly Transportation Statistics contains over 50 time series from nearly two dozen data sources.

Content

This includes counts of ridership across different transit types in the US, such as Air, Car, or train. The data is monthly from Jan 1947-August 2020

Acknowledgements

This data was collected and hosted by the U.S. Department of Transportation Bureau of Transportation Statistics

The North American Roads dataset was compiled on October 27, 2020 from the Bureau of Transportation Statistics (BTS) and is part of the U.S. Department of Transportation (USDOT)/Bureau of Transportation Statistics (BTS) National Transportation Atlas Database (NTAD). This dataset contains geospatial information regarding major roadways in North America. The data set covers the 48 contiguous United States plus the District of Columbia, Alaska, Hawaii, Canada and Mexico. The nominal scale of the data set is 1:100,000. The data within the North American Roads layer is a compilation of data from Natural Resources Canada, USDOT’s Federal Highway Administration, and the Mexican Transportation Institute. North American Roads is a digital single-line representation of major roads and highways for Canada, the United States, and Mexico with consistent definitions by road class, jurisdiction, lane counts, speed limits and surface type.

The National Census of Ferry Operators (NCFO) Terminals dataset was collected through December 31, 2020 and compiled on October 16, 2024 from the Bureau of Transportation Statistics (BTS) and is part of the U.S. Department of Transportation (USDOT)/Bureau of Transportation Statistics (BTS) National Transportation Atlas Database (NTAD). The Ferry Terminals dataset represents all ferry terminals from operators that provided responses to the 2020 National Census of Ferry Operators. Areas covered by the dataset include the 50 states as well as the territories of Puerto Rico, the United States Virgin Island, and American Samoa. The terminals represent departure and arrival locations for ferry segments in the NCFO. As part of the NCFO questionnaire, respondents were asked terminal name, city, and state. From this information, longitude and latitudes were obtained through open, online searches that include operator websites and map platforms such as Google Maps and Open Street Maps. As a result, termina sometimes do not represent the exact location where ferry vessels dock but may represent other locations such as the operator’s business location or alternative docking locations. However, whenever possible, the terminal locations represent departure and arrival points for that ferry segment. Each terminal contains information about its operation and ownership status, in addition to geographic location and transportation connections, whenever operators provided this information.

The National Census of Ferry Operators (NCFO) Routes dataset was collected through December 31, 2020 and compiled on October 16, 2024 from the Bureau of Transportation Statistics (BTS) and is part of the U.S. Department of Transportation (USDOT)/Bureau of Transportation Statistics (BTS) National Transportation Atlas Database (NTAD). The Ferry Routes dataset represents all ferry routes from operators that provided responses to the 2020 National Census of Ferry Operators. Areas covered by the dataset include the 50 states as well as the territories of Puerto Rico, the United States Virgin Island, and American Samoa. Each segment in the dataset connects to two terminals from the Ferry Terminals dataset, describing the route ferries travel between them. Route geometries were determined using GPS points from Automatic Identification System data, as well existing government datasets from the Census Bureau, the US Geological Survey, the National Oceanic and Atmospheric Association, and the US Army Corps of Engineers. Other routes were determined using least-cost analysis.

The Highway Performance Monitoring System (HPMS) 2020 dataset was compiled February 28, 2022 from the Federal Highway Administration (FHWA) and is part of the U.S. Department of Transportation (USDOT)/Bureau of Transportation Statistics (BTS) National Transportation Atlas Database (NTAD). This file geodatabase download provides HPMS data for each state as an individual feature class. This dataset represents the highway system as of the 2020 calendar year. HPMS provides data that reflects the extent, use, condition, and performance of the public roads in the United States. It consists of the All Road Network of Linear Referenced Data (ARNOLD) geometry and the Section Data which is the attribution. ARNOLD and Sections are linked though linear referencing and are part of the HPMS data program. These data are analytical for the purpose of supporting transportation programs, funding and policy decisions at a national level. Operational applications such as navigation and routing may take advantage of HPMS with the understanding that it represents the average and not “real-time†of the system. The Highway Performance Monitoring System Field Manual contains a detailed description of each data element including coding instructions and attribute definitions. The Field Manual is available at: https://doi.org/10.21949/1519108. A data dictionary, or other source of attribute information, is accessible at https://doi.org/10.21949/1519108

The 2020 Adjusted Urban Areas dataset was compiled on December 31, 2020 from the Federal Highway Administration (FHWA) and is part of the U.S. Department of Transportation (USDOT)/Bureau of Transportation Statistics (BTS) National Transportation Atlas Database (NTAD). The 2020 Federal Highway Administration (FHWA) Adjusted Urban Areas layer delineates the boundaries of adjusted urban areas as defined by the FHWA, based on the 2020 U.S. Census urban area boundaries. This nationwide geospatial dataset represents urbanized areas that have been modified through coordination between FHWA Division Offices, State Departments of Transportation (DOTs), and Metropolitan Planning Organizations (MPOs), in accordance with FHWA's Urban Area Boundary Adjustment guidelines. These boundaries are used for transportation planning and programming, eligibility determinations, and analysis purposes related to Federal-aid highway programs. A data dictionary, or other source of attribute information, is accessible at https://doi.org/10.21949/1528364

The USGS Transportation downloadable data from The National Map (TNM) is based on TIGER/Line data provided through U.S. Census Bureau and supplemented with HERE road data to create tile cache base maps. Some of the TIGER/Line data includes limited corrections done by USGS. Transportation data consists of roads, railroads, trails, airports, and other features associated with the transport of people or commerce. The data include the name or route designator, classification, and location. Transportation data support general mapping and geographic information system technology analysis for applications such as traffic safety, congestion mitigation, disaster planning, and emergency response. The National Map transportation data is commonly combined with other data themes, such as boundaries, elevation, hydrography, and structure ...

The National Census of Ferry Operators (NCFO) Routes dataset was collected through December 31, 2020 and compiled on October 16, 2024 from the Bureau of Transportation Statistics (BTS) and is part of the U.S. Department of Transportation (USDOT)/Bureau of Transportation Statistics (BTS) National Transportation Atlas Database (NTAD). The Ferry Routes dataset represents all ferry routes from operators that provided responses to the 2020 National Census of Ferry Operators. Areas covered by the dataset include the 50 states as well as the territories of Puerto Rico, the United States Virgin Island, and American Samoa. Each segment in the dataset connects to two terminals from the Ferry Terminals dataset, describing the route ferries travel between them. Route geometries were determined using GPS points from Automatic Identification System data, as well existing government datasets from the Census Bureau, the US Geological Survey, the National Oceanic and Atmospheric Association, and the US Army Corps of Engineers. Other routes were determined using least-cost analysis.

The 2018 National Transportation Noise Map dataset utilized transportation mode input data from 2018 in a model and is current as of October 2020, published by the Bureau of Transportation Statistics (BTS), and is part of the U.S. Department of Transportation (USDOT)/Bureau of Transportation Statistics (BTS) National Transportation Atlas Database (NTAD). Please see the website https://www.bts.gov/geospatial/national-transportation-noise-map, for downloads and more information about these datasets. For web services of these data, please navigate to https://geo.dot.gov/server/rest/services/Hosted and search for service names beginning with "Noise." Please contact the NTAD Program Manager at ntad@dot.gov for any questions. Data within the National Transportation Noise Map represent potential noise levels across the nation for an average annual day for the specified year. These data are intended to facilitate the tracking of trends in transportation-related noise by mode collectively over time and should not be used to evaluate noise levels in individual locations and/or at specific times. This dataset is developed using a 24-hr equivalent A-weighted sound level (denoted by LAeq) noise metric. The results represent the approximate average noise energy due to transportation noise sources over a 24-hour period at the receptor locations where noise is computed. Layers include Aviation, Passenger Rail (prototype), and Road Noise for the Lower 48 States as well as Alaska and Hawaii. The full listing can be found below. 2018 National Transportation Noise

      Alaska

             Alaska Aviation Noise
             Alaska Road and Aviation Noise
             Alaska Road Noise

      Lower 48 States (CONUS)

             Lower 48 States (CONUS) Aviation Noise
             Lower 48 States (CONUS) Passenger Rail Noise (prototype)
             Lower 48 States (CONUS) Passenger Rail, Road, and Aviation Noise (prototype)
             Lower 48 States (CONUS) Road and Aviation Noise
             Lower 48 States (CONUS) Road Noise

      Hawaii

             Hawaii Aviation Noise
             Hawaii Road and Aviation Noise
             Hawaii Road Noise

The Petroleum Product Pipelines dataset was updated on May 10, 2021 from the Energy Information Administration (EIA), with attribute data from the end of calendar year 2024 and is part of the U.S. Department of Transportation (USDOT)/Bureau of Transportation Statistics (BTS) National Transportation Atlas Database (NTAD). Major petroleum product pipelines in the United States. Layer includes interstate trunk lines and selected intrastate lines. Based on publicly available data from a variety of sources with varying scales and levels of accuracy. Updated January 2020. A data dictionary, or other source of attribute information, is accessible at https://doi.org/10.21949/1529022

Context

This data set was retrieved from the Transtats webpage of the Bureau of Transportation Statistics of the US Department of Transportation. This data was cleaned and made ready for use in an university project where the goal was to compare different database engines in terms of performance and more.

NOTE: December 2020 was not included in the data set since it was not made available by the BTS as of today, 18th Feb 2021.

Content

The data is split into CSV files for each year 2015 to 2020. flights.csv contains all the data in one file. The CSV files contain no headers for the columns. The headers are as follows:

'YEAR', 'MONTH', 'DAY_OF_MONTH', 'DAY_OF_WEEK', 'OP_UNIQUE_CARRIER', 'ORIGIN_CITY_NAME',
'ORIGIN_STATE_ABR', 'DEST_CITY_NAME', 'DEST_STATE_ABR', 'CRS_DEP_TIME', 'DEP_DELAY_NEW',
'CRS_ARR_TIME', 'ARR_DELAY_NEW', 'CANCELLED', 'CANCELLATION_CODE', 'AIR_TIME', 'DISTANCE'

NOTE: The headers were removed due to the requirement of easily importing the data into SQL

Other

If you have any questions about how I retrieved/cleaned the data or anything about my project, feel free to check out my Github repository or shoot me a message.

The Travel Monitoring Analysis System (TMAS) - Volume dataset was compiled on December 31, 2024 and was published on September 26, 2025 from the Federal Highway Administration (FHWA), and is part of the U.S. Department of Transportation (USDOT)/Bureau of Transportation Statistics (BTS) National Transportation Atlas Database (NTAD). The TMAS data included in this table have been collected by the FHWA from State DOTs through (temporal data representing each time period) permanent count data. DOTs determine what volume data is reported for any given month or day within the month. Each record in the volume data for the reported site, direction or lane is for the given day of record (it contains all 24 hours of data). The attributes are used by FHWA for its Travel Monitoring Analysis System and external agencies and have been intentionally limited to location referencing attributes since the core station description attribute data are contained within TMAS. The attributes in the Volume data correspond with the Volume file format found in Chapter 6 of the 2001 Traffic Monitoring Guide (https://doi.org/10.21949/1519109). A data dictionary, or other source of attribute information, is accessible at https://doi.org/10.21949/1529085