Skip to content

Instantly share code, notes, and snippets.

@psychemedia
Last active December 17, 2015 15:40
Show Gist options
  • Save psychemedia/5633865 to your computer and use it in GitHub Desktop.
Save psychemedia/5633865 to your computer and use it in GitHub Desktop.
Data to support the School Of Data data expedition "Mapping the garment factories" [ http://schoolofdata.org/2013/05/18/data-expedition-mapping-the-garment-factories/ ] Data source: http://bgmea.com.bd/home/pages/TradeInformation
Country Woven (million US$) 2008-09 Woven (million US$) 2009-10 Woven (million US$) 2010-11 Woven (million US$) 2011-12 Knit (million US$) 2008-09 Knit (million US$) 2009-10 Knit (million US$) 2010-11 Knit (million US$) 2011-12 Total (million US$) 2008-09 Total (million US$) 2009-10 Total (million US$) 2010-11 Total (million US$) 2011-12
Austria 3.01 1.93 6.36 17.5 19.2 13.87 27.75 34.49 22.21 15.8 34.11 51.99
Belgium 95.02 87.78 162.93 238.61 157.52 155.79 299.74 320.46 252.54 243.57 462.67 559.07
Bulgaria 0.38 0.41 0.21 0.54 0.39 0.47 0.97 0.68 0.77 0.88 1.18 1.23
Denmark 23.94 33.51 50.43 86.8 131.23 178.24 256.32 318.72 155.17 211.75 306.75 405.51
Finland 6.1 5.47 11.22 7.85 15.52 15.59 28.73 29.25 21.62 21.06 39.95 37.1
France 264.11 260.92 405.98 416.72 705.69 692 999.71 855.18 969.8 952.92 1405.69 1271.9
Germany 801.4 717.31 1108.91 1358.92 1334.4 1282.77 2022.05 2039.97 2135.8 2000.08 3130.97 3398.89
Greece 8.86 8.92 9.42 8.14 29.57 20.66 20.89 21.17 38.43 29.58 30.31 29.31
Italy 153.42 161.34 236.76 291.15 368.86 379.04 525.17 571.46 522.28 540.38 761.93 862.62
Ireland 41.89 54.14 54.28 63.03 52.16 80.16 105.59 123.92 94.05 134.3 159.87 186.95
Netherlands 393.82 388.79 374.13 226.76 513.98 528.57 591.07 325.28 907.8 917.36 965.2 552.04
Portugal 6.53 4.87 6.03 6.68 24.51 23.08 32.57 25.57 31.04 27.95 38.61 32.25
Romania 3.34 3.03 3.34 4.3 7.89 4.3 4.37 7.62 11.23 7.34 7.71 11.93
Spain 141.66 136.98 253.49 410.39 404.23 384.55 595.92 660.73 545.89 521.54 849.41 1071.12
Sweden 49.18 54.98 93.91 109.07 125.74 129.89 206.86 203.87 174.92 184.86 300.78 312.94
U.K. 502.34 534.29 768.9 1026.77 720.58 725.74 990.98 1103.3 1222.92 1260.02 1759.87 2130.07
Cyprus 0.01 0.27 0.03 0.08 0.63 0.84 1.12 1.11 0.64 1.11 1.16 1.18
Czech Republic 1.84 1.24 4.31 37.99 15.66 14.59 23.98 25.77 17.5 15.83 28.29 63.75
Estonia 0 0.1 0.91 0.74 0.13 0.24 0.62 2.52 0.13 0.34 1.53 3.26
Hungary 0 0.31 0.29 0.21 0 9.98 7.01 2.14 0 10.28 7.31 2.34
Latvia 0.07 0.04 0.14 0.29 0.16 0.3 0.34 1.22 0.23 0.33 0.48 1.51
Lithuania 0 0.07 0 0.18 0.05 0.04 0.62 0.98 0.05 0.11 0.62 1.16
Malta 0.04 0 0 0.02 0.66 0.12 0.32 0.45 0.7 0.12 0.32 0.47
Poland 5.57 6.03 38.34 112.77 43.49 44.56 123.33 209.96 49.06 50.59 161.67 322.74
Slovakia 14.8 15.56 19.01 20.31 26.22 24.29 39.59 36.54 41.02 39.84 58.61 56.85
Slovenia 0.37 0.24 0.77 1.04 2.08 2.57 4.08 6.33 2.45 2.81 4.85 7.37
USA 2733.98 2736.44 3506.12 3515.45 959.42 891.61 1119.04 1013.95 3693.40 3628.05 4625.16 4529.40
Canada 295.00 311.69 461.75 473.04 292.05 283.86 432.92 401.82 587.05 595.55 894.67 874.85
Australia 13.49 25.15 49.82 94.83 35.8 60.41 143.08 212.72 49.29 85.56 192.9 307.54
Brazil 11.14 11.84 32.6 50.45 28.43 33.33 62.04 77.33 39.57 45.17 94.64 127.78
Chile 1.6 3.65 3.62 5.57 4.81 4.45 9.31 11.36 6.41 8.09 12.93 16.93
China 4.11 10.44 26.6 57.83 5.37 8.51 26.21 46.69 9.49 18.95 52.81 104.52
India 9.52 9.99 25.45 42.2 1.41 2.55 10.49 12.82 10.94 12.53 35.94 55.02
Japan 52.34 120.26 153.68 239.99 21.99 53.06 93.83 163.65 74.33 173.32 247.51 403.65
Korea Rep. 4.24 15.36 34.46 61.27 1.19 7 12.75 18.75 5.42 22.36 47.21 80.01
Mexico 41.43 25.53 30.34 36.74 40.45 35.88 50.83 61.91 81.88 61.41 81.16 98.65
Russia 4.87 6.67 9.53 27.67 11.29 13.72 42.33 48.82 16.16 20.39 51.86 76.49
South Africa 22.92 21.36 28.09 29.31 19.59 14.9 20.35 26.45 42.51 36.26 48.43 55.76
Turkey 108.43 123.76 245.79 231.2 131.11 182.52 272.52 124.73 239.54 306.27 518.32 355.93
Other Countries 97.735 112.777 214.925 290.918 175.8 179.282 276.64 336.679 273.535 292.059 491.569 627.597
Month Woven 2010/11 Woven 2011/12 Woven Growth 10/11-11/12 Knit 2010/11 Knit 2011/12 Knit Growth 10/11-11/12 Total (Woven+Knit) 2010/11 Total (Woven+Knit) 2010/11 2011/12 Total (Woven+Knit) Growth 10/11-11/12
July 671.28 888 32.28 798.66 1007.88 26.2 1469.94 1895.88 28.98
August 645.39 870.63 34.9 790.06 1052.43 33.21 1435.45 1923.06 33.97
September 473.57 475.93 0.5 592.56 519.21 -12.38 1066.13 995.14 -6.66
October 559.27 704.7 26 706.75 796.05 12.64 1266.02 1500.75 18.54
November 534.38 626.91 17.32 644.94 621.73 -3.6 1179.32 1248.64 5.88
December 752.68 890.8 18.35 778.95 794.23 1.96 1531.63 1685.03 10.02
January 749.32 930.81 24.22 760.61 773.48 1.69 1509.93 1704.29 12.87
February 737.65 873.29 18.39 718.95 732.09 1.83 1456.6 1605.38 10.21
March 838.28 847.52 1.1 814 699.16 -14.11 1652.28 1546.68 -6.39
April 736.7 721.72 -2.03 866.41 698.68 -19.36 1603.11 1420.4 -11.4
May 816.18 866.63 6.18 972.76 875.98 -9.95 1788.94 1742.61 -2.59
June 917.7 906.4 -1.23 1037.41 915.43 -11.76 1955.11 1821.83 -6.82
Month Woven 2011/12 Woven 2012/13 Woven Growth 11/12-12/13 Knit 2011/12 Knit 2012/13 Knit Growth 11/12-12/13 Total (Woven+Knit) 2011/12 Total (Woven+Knit) 2011/12 2012/13 Total (Woven+Knit) Growth 11/12-12/13
July 888 993.84 11.92 1007.88 1001.07 -0.68 1895.88 1994.91 5.22
August 870.63 997.72 14.6 1052.43 1004.24 -4.58 1923.06 2001.96 4.1
September 475.93 465.3 -2.23 519.21 534.52 2.95 995.14 999.82 0.47
October 704.7 761.48 8.06 796.05 873.16 9.69 1500.75 1634.64 8.92
November 626.91 710.04 13.26 621.73 653.96 5.18 1248.64 1364 9.24
December 890.8 1042.68 17.05 794.23 908.94 14.44 1685.03 1951.62 15.82
January 930.81 1147.64 23.29 773.48 944.96 22.17 1704.29 2092.6 22.78
February 873.29 979.71 12.19 732.09 811.24 10.81 1605.38 1790.95 11.56
March 847.52 991.77 17.02 699.16 854.68 22.24 1546.68 1846.45 19.38
April 721.72 835.17 15.72 698.68 795.11 13.8 1420.4 1630.28 14.78
Fiscal Year To From Garment Factories Workers (millions)
1984-85 1985 1984 384 0.12
1985-86 1986 1985 594 0.2
1986-87 1987 1986 629 0.28
1987-88 1988 1987 685 0.31
1988-89 1989 1988 725 0.32
1989-90 1990 1989 759 0.34
1990-91 1991 1990 834 0.4
1991-92 1992 1991 1163 0.58
1992-93 1993 1992 1537 0.8
1993-94 1994 1993 1839 0.83
1994-95 1995 1994 2182 1.2
1995-96 1996 1995 2353 1.29
1996-97 1997 1996 2503 1.3
1997-98 1998 1997 2726 1.5
1998-99 1999 1998 2963 1.5
1999-00 1900 1999 3200 1.6
2000-01 2001 2000 3480 1.8
2001-02 2002 2001 3618 1.8
2002-03 2003 2002 3760 2
2003-04 2004 2003 3957 2
2004-05 2005 2004 4107 2
2005-06 2006 2005 4220 2.2
2006-07 2007 2006 4490 2.4
2007-08 2008 2007 4743 2.8
2008-09 2009 2008 4925 3.5
2009-10 2010 2009 5063 3.6
2010-11 2011 2010 5150 3.6
2011-12 2012 2011 5400 4
Fiscal Year To From RMG Export (Million US$) Total Exports from Bangladesh (millions $US) % OF RMG'S TO RMG as % of Total Export
1983-84 1984 1983 31.57 811 3.89
1984-85 1985 1984 116.2 934.43 12.44
1985-86 1986 1985 131.48 819.21 16.05
1986-87 1987 1986 298.67 1076.61 27.74
1987-88 1988 1987 433.92 1231.2 35.24
1988-89 1989 1988 471.09 1291.56 36.47
1989-90 1990 1989 624.16 1923.7 32.45
1990-91 1991 1990 866.82 1717.55 50.47
1991-92 1992 1991 1182.57 1993.9 59.31
1992-93 1993 1992 1445.02 2382.89 60.64
1993-94 1994 1993 1555.79 2533.9 61.4
1994-95 1995 1994 2228.35 3472.56 64.17
1995-96 1996 1995 2547.13 3882.42 65.61
1996-97 1997 1996 3001.25 4418.28 67.93
1997-98 1998 1997 3781.94 5161.2 73.28
1998-99 1999 1998 4019.98 5312.86 75.67
1999-00 1900 1999 4349.41 5752.2 75.61
2000-01 2001 2000 4859.83 6467.3 75.14
2001-02 2002 2001 4583.75 5986.09 76.57
2002-03 2003 2002 4912.09 6548.44 75.01
2003-04 2004 2003 5686.09 7602.99 74.79
2004-05 2005 2004 6417.67 8654.52 74.15
2005-06 2006 2005 7900.8 10526.16 75.06
2006-07 2007 2006 9211.23 12177.86 75.64
2007-08 2008 2007 10699.8 14110.8 75.83
2008-09 2009 2008 12347.77 15565.19 79.33
2009-10 2010 2009 12496.72 16204.65 77.12
2010-11 2011 2010 17914.46 22924.38 78.15
2011-12 2012 2011 19089.69 24287.66 78.6
{
"name": "scoda-de-garments-bgmea-tradeinformation-scrape",
"title": "School of Data garment mapping data expedition - trade information data scraped from BGMEA",
"sources": [{
"name": "Bangladesh Garment Manufacturers and Exporters Association (BGMEA)",
"web": "http://bgmea.com.bd/home/pages/TradeInformation"
}],
"resources": [
{
"path": "BGMEA-COMPARATIVE-STATEMENT-ON-EXPORT-OF-RMG-AND-TOTAL-EXPORT-OF-BANGLADESH.csv",
"schema": {
"fields": [
{
"id":"Fiscal Year",
"type": "string"
},
{
"id":"To",
"type": "integer"
},
{
"id":"From",
"type": "integer"
},
{
"id":"RMG Export (Million US$)",
"type":"number"
},
{
"id":"Total Exports from Bangladesh (millions $US)",
"type":"number"
},
{
"id":"% OF RMG'S TO RMG as % of Total Export",
"type":"number"
}
]
}
},
{
"path":"BGEA-MEMBERSHIP-AND-EMPLOYMENT.csv",
"schema": {
"fields": [
{
"id":"Fiscal Year",
"type":"string"
},
{
"id":"To",
"type":"integer"
},
{
"id":"From",
"type":"integer"
},
{
"id":"Garment Factories",
"type":"integer"
},
{
"id":"Workers (millions)",
"type":"number"
}
]
}
}
]
}
Fiscal Year SHIRTS (million US$) TROUSERS (million US$) JACKETS (million US$) T-SHIRT (million US$) SWEATER (million US$)
1993-94 805.34 80.56 126.85 225.9
1994-95 791.2 101.23 146.83 232.24
1995-96 807.66 112.02 171.73 366.36 70.41
1996-97 759.57 230.98 309.21 391.21 196.6
1997-98 961.13 333.28 467.19 388.5 296.29
1998-99 1043.11 394.85 393.44 471.88 271.7
1999-2000 1021.17 484.06 439.77 563.58 325.07
2000-2001 1073.59 656.33 573.74 597.42 476.87
2001-2002 871.21 636.61 412.34 546.28 517.83
2002-2003 1019.87 643.66 464.51 642.62 578.37
2003-2004 1116.57 1334.85 364.77 1062.1 616.31
2004-2005 1053.34 1667.72 430.28 1349.71 893.12
2005-2006 1056.69 2165.25 389.52 1781.51 1044.01
2006-2007 943.44 2201.32 1005.06 2208.9 1248.09
2007-2008 915.6 2512.74 1181.52 2765.56 1474.09
2008-2009 1000.16 3007.29 1299.74 3065.86 1858.62
2009-2010 993.41 3035.35 1350.43 3145.52 1795.39
2010-2011 1566.42 4164.16 1887.5 4696.57 2488.19
2011-2012 1733.54 4686.39 2231.16 4713.11 2340.34
Fiscal Year Woven value (million US$) Knit value (million US$) Total Value (million US$) Woven quantity (million dozen) Knit quantity (million dozen) Total Value (million dozen)
1992-93 1240.48 204.54 1445.02 36.05 10.66 46.71
1993-94 1291.65 264.14 1555.79 34.35 10.81 45.16
1994-95 1835.09 393.26 2228.35 47.21 15.3 62.51
1995-96 1948.81 598.32 2547.13 48.82 23.18 72
1996-97 2237.95 763.3 3001.25 53.45 27.54 80.99
1997-98 2844.43 937.51 3781.94 65.59 32.6 98.19
1998-99 2984.96 1035.02 4019.98 64.79 36.66 101.45
1999-2000 3081.19 1268.22 4349.41 66.63 45.27 111.9
2000-2001 3364.32 1495.51 4859.83 71.48 52.54 124.02
2001-2002 3124.82 1458.93 4583.75 77.05 63.39 140.44
2002-2003 3258.27 1653.82 4912.09 82.83 69.18 152.01
2003-2004 3538.07 2148.02 5686.09 90.48 91.6 182.08
2004-2005 3598.2 2819.47 6417.67 92.26 120.13 212.39
2005-2006 4083.82 3816.98 7900.8 108.82 165.02 273.84
2006-2007 4657.63 4553.6 9211.23 133.08 199.54 332.62
2007-2008 5167.28 5532.52 10699.8 147.43 241.6 389.03
2008-2009 5918.51 6429.26 12347.77 169.59 290.92 460.51
2009-2010 6013.43 6483.29 12496.72 172.8 292.7 465.5
2010-2011 8432.4 9482.06 17914.46 247.28 441.03 688.31
2011-2012 9603.34 9486.39 19089.73 49.94 56.46 106.39
Year WOVEN (million US$) KNIT (million US$) TOTAL (million US$) WOVEN (million dozen) KNIT (million dozen) TOTAL (million dozen)
1994 1544.89 341.53 1886.42 41.64 13.77 55.41
1995 1976.4 512.18 2488.58 49.38 19.83 69.21
1996 1942.37 686.27 2628.64 47.54 26.11 73.65
1997 2621.33 810.49 3431.82 60.56 27.99 88.55
1998 2871.06 976.29 3847.35 64.23 34.59 98.82
1999 2987.73 1169.9 4157.63 64.93 41.3 106.23
2000 3376.49 1448.22 4824.71 71.63 51.58 123.21
2001 3162.28 1432.72 4595 67.72 50.18 117.9
2002 3076.28 1573.4 4649.68 83.44 70.71 154.15
2003 3398.84 1850.36 5249.2 85.83 80.5 166.33
2004 3686.78 2532.62 6219.4 94.22 104.9 199.12
2005 3689.6 3210.48 6900.08 96.39 138.19 234.58
2006 4544.79 4388.72 8933.51 125.65 190.6 316.25
2007 4608.4 4741.93 9350.33 133.62 212.08 345.7
2008 5654.12 6222.95 11877.07 161.51 272.17 433.68
2009 5695.42 6196.58 11892 163.27 279.91 443.18
2010 7067.04 7787.76 14854.8 203.48 357.76 561.24
2011 9251.62 9961.36 19212.98 42.36 51.84 94.20
@rufuspollock
Copy link

id should in fact be the name of the column in the csv so i think your id values should just be label field (and you could drop label).

It makes me think that perhaps we should rename id to name to make this clearer (and also clear that label is just optional)

@Floppy
Copy link

Floppy commented May 24, 2013

I was just about to say the same thing, I was looking at this in my data viewer and saw no data :)

@psychemedia
Copy link
Author

Fixed..

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment