The Census Bureau reports trade data in a number of ways, and Haver banks a good deal of them in regional databases. The REGIONAL database includes a monthly summary of exports of goods by state, which is released at the same time as the other detail on the monthly trade reports. Just a few hours later, data on shipments through specific ports are released for both exports and imports; Haver includes these in the PORTS database. Once a quarter an incredible amount of detail is published for exports by states by NAICS Code by country. So you can see there, for instance, the value of machinery shipped from Tennessee to Azerbaijan. These data are divided among nine databases, one for each Census Region.

Today's January trade report, as noted by Tom Moeller, saw a widening of the trade deficit for January. But even so, US exports appear to be quite strong. Shipments of goods abroad totaled $66.38 billion, not seasonally adjusted, up 12.2% from a year ago, following December's 13.5% increase. In all of last year these exports grew 12.8% from 2003.

As seen in the table below, Texas is the biggest exporting state, with $9.8 billion, representing 14.8% of January's total. In the PORTS database, we see that the Houston District is, as would be expected, the largest volume point of departure; but the Laredo District is also very significant, a circumstance which would highlight the role of NAFTA relationships with Mexico and trade elsewhere in Latin America.

California follows close behind, shipping $8.72 billion in January. Then there is a big gap to number 3 New York, with $3.86 billion in shipments. We've included a couple of other states in our table to illustrate various magnitudes. Virtually every state exports something, although for a few, it can be well under $100 million each month. These data became important a number of years ago to illustrate the significance of sales abroad for local and regional economies. Indeed, 22 states have exports that have recently been averaging over $1 billion a month. This dataset includes, by the way, the District of Columbia, Puerto Rico and the Virgin Islands. "Origin of Movement" classifies this information according to the location where shipping began; this is more reliable than the location of the exporter, since that may not be close to the place where the goods are actually produced and shipped.

Haver's software, DLXVG3, makes comparisons among the states simple. We used the "Excel Mode" to insert codes for all 53 of these these states and locales into a spreadsheet with one quick operation, and then applied a regular DLX retrieval operation to bring the data in. Excel's sorting capabilities make it easy to rank the states.