using the main database on gunpowder, and lead and shot, I have extracted the information for the USA colonies. As the country celebrates its 250th anniversary, i hope this data will help shed a bit more light on those pivotal decades. Refer to the main database for units (cwt, qwt, lbs).

Powder and Lead to the US Colonies

                                
CUSTVolumeYearCarolina   Georgia   New England   New Providence   New York   Pennsylvania   VA & MD    
CUST311698 26920    301410    37820     1349219 
CUST321698         100 120 16110     399121 
CUST331699        354114    6420 2410 81632 
CUST341700 23214    9817    19183024103010314 
CUST35170175216    10614216    43122073103311226 
CUST361702199214    866214    161210852014226 
CUST3717034230    591200 720 80021830347014 
CUST381704 18920     251221     10320 6410 5000 
CUST391706 120    4237    5710 19074628 
CUST31017076420    41900    81320 8530641637 
CUST3111708 15      90620    21020 350001600 
CUST312170937720    949121    1012014592012600 
CUST3131710241400    28037    13123011800461338 
CUST314171111100    298321    51730232018930 
CUST315171315100    31210    5102002114042214 
CUST31617148300    95310    8100019002011225 
CUST31717153720    521303    902041200537021 
CUST3181716040014    401917    632036204917014 
CUST319171711000    551210    411039005911119 
CUST320171841620    16400    072766104217212 
CUST32117196900    731120    817003820791510 
CUST322172051800    321630    5921441530181710 
CUST323172141210    13900    42304510191110 
CUST324172215410    261110    28009500456021 
CUST3251723101230    5118014    513141100018107 
CUST3261724331420            71800121511736418 
CUST327172591200    711900    4920910003214115 
CUST328A1726*101630    90000    1217201314203218016 
CUST329172926820    736023    14120014520303223 
CUST3301730121320    6400    64001415205111225 
CUST331173115110    1421037    1952044203512018 
CUST332173280000700491920    414209700260125 
CUST3331733109002900391430    101700802034037 
CUST334173417000290936340    1113001613007414210 
CUST3351735296103140071100    8700191720525320 
CUST33617363281142400801120    25130083004018211 
CUST33717371352031400551320    9130793204019224 
CUST33817381491116720771020    7120231100371611 
CUST33917391900011500761410    3111102210003813119 
CUST3401740411800200081420     90026500492016 
CUST341174134000300034800    44132042800315012 
CUST34217422040071600391700    15910351800338118 
CUST3431743    0112031000    3193019160043910 
CUST3441744111020    341500    71500394004113316 
CUST3451745141200    191120    3140012120028430 
CUST346174628160001100301800    121300210004811114 
CUST3471747291400    62930    29182035300275314 
CUST348174849300    962212    198204440038728 
CUST3491749481400    35400    13170011690066430 
CUST35017503019201500521720    24180065220132513 
CUST35117512742140020821020    3642030140072924 
CUST3521752441200    7714014    3110203900062030 
CUST353175346932439005516020    3012033000411212 
CUST354175428720    541000    5162083900387025 
CUST355175542000    130800    341020461720574026 
CUST356175651121004001324316    629001080001101923 
CUST3571757651800    72100    34620548007518012 
CUST3581758411104    581920    154007017206210326 
CUST35917596372001600655014    31129941120126507 
CUST3601760421320    59130    259184872013713214 
CUST3611761611300390038430    240201714008519110 
CUST36217622512003130023600    2610004080051610 
CUST363176383112013100177321    30011934930589114 
CUST36417644112006800324200150026172065520630125 
CUST36517653311004800257020    22600614206615119 
CUST36617663120019130034620    53821865120551030 
CUST36717674011201415002900001300491607122830811920 
CUST3681768441800201600261800    7313007490012917014 
CUST3691769581012122140084330110015600511007918316 
CUST37017702913001300016713200100010181018770018213020 
CUST3711771311900276009319116    1561700911320219200 
CUST37217724450019300787000700321600580001463214 
CUST373177337400181200621200020025500371730781400 
CUST3741774281821416180063630020032140059600481020 
CUST3751775    212020060011800             
CUST3761776                             
CUST3771777                             
CUST3781778                             
CUST3791779                             
CUST38017801118428533321        551834         
CUST177178150121001400        3311320         
CUST1771782                5510         
CUST178178324130031800711314    9102064133030210 
                                
                                
 VolumeYearCarolina   Georgia   New England   New Providence   New York   Pennsylvania   VA & MD