Exports as a percentage of U.S. state GSP

[greenforest32]

I thought it would be interesting to see how much of a share exports made up of every state's GSP. It's basically just a ratio of a state's exports divided by its GSP

Export data: http://www.census.gov/foreign-trade/statistics/state/data/index.html
GSP data: http://www.usgovernmentspending.com/compare_state_spending_2010bZ0G

All data is from 2010

Exports as a percentage of U.S. state GSP list:

Louisiana - 18.91%
Texas - 17.14%
Vermont - 16.80%
Washington - 15.68%
South Carolina - 12.35%
Utah - 12.05%
Kentucky - 11.82%
Michigan - 11.66%
Indiana - 10.41%
Oregon - 10.16%
Tennessee - 10.16%
West Virginia - 9.91%
Idaho - 9.39%
Alabama - 8.98%
Ohio - 8.69%
Alaska - 8.55%
Mississippi - 8.41%
Delaware - 8.03%
Wisconsin    - 7.97%
Kansas - 7.78%
Illinois - 7.69%
Iowa - 7.64%
California - 7.53%
Florida - 7.41%
New Hampshire - 7.30%
North Dakota - 7.20%
Georgia - 7.19%
Minnesota - 7.00%
Massachusetts - 6.94%
Connecticut - 6.78%
New Jersey - 6.61%
Nebraska - 6.46%
Maine - 6.20%
Arizona - 6.15%
Pennsylvania - 6.13%
New York - 6.01%
North Carolina - 5.86%
Missouri - 5.29%
Arkansas - 5.07%
Nevada - 4.69%
Virginia - 4.06%
Montana - 3.88%
Rhode Island - 3.86%
Oklahoma    - 3.66%
Maryland - 3.45%
South Dakota - 3.26%
Colorado - 2.60%
Wyoming   2.60%
New Mexico - 1.88%
DC - 1.45%
Hawaii - 1.05%

U.S. National figure - 8.62%

[phk]

and what is it correlated with?

[Snowguy716]

How about export $$$ per capita?  LA is high on this list but has a relatively low GSP.

[phk]

How about export $$$ per capita?  LA is high on this list but has a relatively low GSP.

Oil and soybeans are driving LA.

[Zach Vega]

2. Texas - 17.14%

My estimate was around that number - 16%.

[phk]

Can you do imports as a % of US state GSP too?

[greenforest32]

Can you do imports as a % of US state GSP too?

Louisiana   27.82%
Michigan   22.90%
New Jersey   22.33%
Texas   21.99%
Kentucky   19.66%
Tennessee   18.92%
California   17.20%
Illinois   16.65%
Mississippi   16.31%
Delaware   15.57%
South Carolina   15.57%
Georgia   14.93%
New Hampshire   14.93%
Rhode Island   14.63%
Vermont   13.28%
Pennsylvania   13.09%
Montana   12.74%
Washington   12.48%
Indiana   12.04%
Ohio   11.09%
North Carolina   10.00%
New York   9.77%
Minnesota   9.74%
Alabama   8.75%
Kansas   8.49%
Massachusetts   8.11%
Maine   7.95%
Wisconsin   7.93%
Connecticut   7.84%
Oregon   7.75%
Florida   7.52%
Idaho   7.40%
North Dakota   7.20%
Hawaii   7.04%
Utah   6.72%
Maryland   6.71%
Arkansas   6.63%
Arizona   6.15%
Missouri   5.25%
Colorado   5.16%
West Virginia   4.95%
Iowa   4.91%
Nevada   4.85%
Virginia   4.81%
Wyoming   4.42%
Oklahoma    4.41%
New Mexico   4.02%
Nebraska   3.23%
Alaska   3.05%
South Dakota   1.75%
DC   0.68%

U.S. National figure   13.07%

[greenforest32]

How about export $$$ per capita?

Louisiana    $9,123
Texas    $8,231
Washington    $7,934
Vermont    $6,835
Alaska    $5,850
Delaware    $5,530
Utah    $4,996
Oregon    $4,613
Michigan    $4,530
Connecticut    $4,492
Kentucky    $4,458
Indiana    $4,433
South Carolina    $4,395
Tennessee    $4,088
Massachusetts    $4,017
Illinois    $3,901
California    $3,844
North Dakota    $3,770
New Jersey    $3,657
New York    $3,597
Ohio    $3,597
Iowa    $3,571
Minnesota    $3,564
West Virginia    $3,480
Wisconsin    $3,480
Kansas    $3,472
New Hampshire    $3,317
Idaho    $3,290
Alabama    $3,243
Nebraska    $3,187
Georgia    $2,988
Florida    $2,945
Mississippi    $2,773
Pennsylvania    $2,750
North Carolina    $2,612
DC    $2,495
Arizona    $2,446
Maine    $2,382
Nevada    $2,189
Missouri    $2,158
Virginia    $2,145
Rhode Island    $1,852
Arkansas    $1,790
Maryland    $1,760
South Dakota    $1,546
Wyoming    $1,744
Oklahoma    $1,427
Montana    $1,404
Colorado    $1,338
New Mexico    $748
Hawaii    $503

U.S. National figure $4,077

Used 2010 Census numbers for the population

[Yelnoc]

What is it that Louisiana exports?

[phk]

What is it that Louisiana exports?

SOYBEANS, WHETHER OR NOT BROKEN

OIL (NOT CRUDE) FROM PETROL & BITUM MINERAL ETC.   
CORN (MAIZE), OTHER THAN SEED CORN   
SOYBEAN OILCAKE & OTH SOLID RESIDUE, WH/NOT GROUND
LIGHT OILS& PREP (NOT CRUDE) FROM PETROL & BITUM
SOYBEAN OIL & FRACTIONS, CRUDE, WHETH/NOT DEGUMMED
WHEAT (OTHER THAN DURUM WHEAT), AND MESLIN   
BITUMINOUS COAL, NOT AGGLOMERATED   
OILS & PRODUCTS NESOI AS COAL TAR DISTILLATES ETC   
RICE IN THE HUSK (PADDY OR ROUGH)
PETROLEUM COKE, NOT CALCINED   
PETROLEUM COKE, CALCINED   
POLYMERS OF ETHYLENE NESOI, IN PRIMARY FORMS   
BREWING OR DISTILLING DREGS AND WASTE, W/NT PELLET   
ETHYLENE-PROPYLENE-NONCONJUGATED DIENE RUBBER   
STYRENE   
PARTS FOR BORING OR SINKING MACHINERY, NESOI   
POLYVINYL CHLORIDE, NOT MIXED WITH OTHER SUBSTANCE   
RICE, SEMI- OR WHOLLY MILLED, POLISHED ETC OR NOT   
RESIDUES OF STARCH MFR AND SIMILAR RESIDUES    25
AMINO-RESINS NESOI, PR FMS   
MTR VEH TRANS GDS SPK IG IN C P ENG, GVW NOV 5 MTN   
POLYETHYLENE HAVING A SPEC GRAVITY OF 0.94 OR MORE   
XYLENES   
CIVILIAN AIRCRAFT, ENGINES, AND PARTS   

[phk]

How about export $$$ per capita?

Louisiana    $9,123
Texas    $8,231
Washington    $7,934
Vermont    $6,835
Alaska    $5,850
Delaware    $5,530
Utah    $4,996
Oregon    $4,613
Michigan    $4,530
Connecticut    $4,492
Kentucky    $4,458
Indiana    $4,433
South Carolina    $4,395
Tennessee    $4,088
Massachusetts    $4,017
Illinois    $3,901
California    $3,844
North Dakota    $3,770
New Jersey    $3,657
New York    $3,597
Ohio    $3,597
Iowa    $3,571
Minnesota    $3,564
West Virginia    $3,480
Wisconsin    $3,480
Kansas    $3,472
New Hampshire    $3,317
Idaho    $3,290
Alabama    $3,243
Nebraska    $3,187
Georgia    $2,988
Florida    $2,945
Mississippi    $2,773
Pennsylvania    $2,750
North Carolina    $2,612
DC    $2,495
Arizona    $2,446
Maine    $2,382
Nevada    $2,189
Missouri    $2,158
Virginia    $2,145
Rhode Island    $1,852
Arkansas    $1,790
Maryland    $1,760
South Dakota    $1,546
Wyoming    $1,744
Oklahoma    $1,427
Montana    $1,404
Colorado    $1,338
New Mexico    $748
Hawaii    $503

U.S. National figure $4,077

Used 2010 Census numbers for the population

My numbers are slightly different from yours.

[Snowguy716]

What is it that Louisiana exports?

SOYBEANS, WHETHER OR NOT BROKEN

OIL (NOT CRUDE) FROM PETROL & BITUM MINERAL ETC.   
CORN (MAIZE), OTHER THAN SEED CORN   
SOYBEAN OILCAKE & OTH SOLID RESIDUE, WH/NOT GROUND
LIGHT OILS& PREP (NOT CRUDE) FROM PETROL & BITUM
SOYBEAN OIL & FRACTIONS, CRUDE, WHETH/NOT DEGUMMED
WHEAT (OTHER THAN DURUM WHEAT), AND MESLIN   
BITUMINOUS COAL, NOT AGGLOMERATED   
OILS & PRODUCTS NESOI AS COAL TAR DISTILLATES ETC   
RICE IN THE HUSK (PADDY OR ROUGH)
PETROLEUM COKE, NOT CALCINED   
PETROLEUM COKE, CALCINED   
POLYMERS OF ETHYLENE NESOI, IN PRIMARY FORMS   
BREWING OR DISTILLING DREGS AND WASTE, W/NT PELLET   
ETHYLENE-PROPYLENE-NONCONJUGATED DIENE RUBBER   
STYRENE   
PARTS FOR BORING OR SINKING MACHINERY, NESOI   
POLYVINYL CHLORIDE, NOT MIXED WITH OTHER SUBSTANCE   
RICE, SEMI- OR WHOLLY MILLED, POLISHED ETC OR NOT   
RESIDUES OF STARCH MFR AND SIMILAR RESIDUES    25
AMINO-RESINS NESOI, PR FMS   
MTR VEH TRANS GDS SPK IG IN C P ENG, GVW NOV 5 MTN   
POLYETHYLENE HAVING A SPEC GRAVITY OF 0.94 OR MORE   
XYLENES   
CIVILIAN AIRCRAFT, ENGINES, AND PARTS   

This is very misleading.  It is basically using a measure of products that are shipped directly from the state overseas.  If you grow the soybeans in Iowa and then ship them by barge down to New Orleans where they then leave the country, they are counted as being an export of Louisiana, not Iowa.

Therefore, all this does is measure the size of international ports within the various states.

Or maybe Louisiana is a significant producer of coal...

I'd like to see actual numbers of products originating in each state made for export, regardless of where they actually leave the country from.