Estimating County to County Trade Flow

Estimating count to county commodity trade flows is important for understanding a multitude of transportation, regional planning, and economic problems. While no primary data track intranational trade flows, gravity models have often been used to estimate these flows. However, to properly specify a gravity model, data on total commodity supply and total commodity demand for a consistent set of commodities and for every county must be obtained. Because these data are not available through primary data sources, a systematic process for estimating these values must be generated. This report details a process for starting with primary government data, specifically the quarterly census of employment and wages (QCEW) and national input-output accounts from the US Bureau of Economic Analysis (BEA), and generating employment, output, and commodity supplies and demands across 409 commodities in 3,142 counties. These commodity supplies and demands are then used in a gravity model to estimate bilateral trade for each commodity between every county in the United States. Employment, commodity trade data, and county to county trade totals are available at: https://tapestry.nkn.uidaho.edu/

• Record URL:
  • http://hdl.handle.net/1773/50995
• Record URL:
  • https://rosap.ntl.bts.gov/view/dot/73099
• Dataset URL:
  • https://rosap.ntl.bts.gov/view/dot/73137
• Supplemental Notes:
  • This document was sponsored by the U.S. Department of Transportation, University Transportation Centers Program. Supporting dataset available at: https://rosap.ntl.bts.gov/view/dot/73137
• Corporate Authors:

  University of Idaho

  ,    

  Pacific Northwest Transportation Consortium

  University of Washington
  More Hall Room 112
  Seattle, WA  United States  98195-2700

  Office of the Assistant Secretary for Research and Technology

  University Transportation Centers Program
  Department of Transportation
  Washington, DC  United States  20590
• Authors:
  • Watson, Philip
  • Lowry, Mike
  • 0000-0001-8485-4799
  • Khan, Fauwial
• Publication Date: 2023-6

Language

• English

Media Info

• Media Type: Digital/other
• Edition: Final Report
• Features: Appendices; Bibliography; Figures; References; Tables;
• Pagination: 35p

Subject/Index Terms

• TRT Terms: Commodity flow; Counties; Gravity models
• Geographic Terms: United States
• Subject Areas: Freight Transportation; Planning and Forecasting;

Filing Info

• Accession Number: 01904543
• Record Type: Publication
• Report/Paper Numbers: 2020-S-UI-1
• Contract Numbers: 69A3551747110
• Files: UTC, NTL, TRIS, USDOT
• Created Date: Jan 16 2024 9:02AM