Summary of currently loaded spend data for: Department for International Development

Lastfile: DFID_201912
File name TotalAmt£ OrigRecs AggRecs     AvgAmt£ MaxAmt£           MinDate       MaxDate     Diff     Comment
DFID_201101.csv 379,706,377.95 688 0 551,898.81 48,000,000.00 2011-01-01 2011-01-31 30    
DFID_201102.csv 303,996,865.24 751 0 404,789.43 47,250,000.00 2011-02-01 2011-02-28 27    
DFID_201103.csv 804,182,998.10 1182 0 680,357.87 97,630,000.00 2011-03-01 2011-03-31 30     Jump in TotalAmt.
DFID_201104.csv 190,557,254.45 2322 0 82,066.00 42,540,000.00 2011-04-01 2011-04-30 29     Drop in TotalAmt. Drop in AvgAmt
DFID_201105.csv 211,912,142.27 3333 0 63,580.00 15,397,725.00 2011-05-02 2011-05-31 29    
DFID_201106.csv 324,912,092.11 5271 0 61,641.45 66,000,000.00 2011-06-01 2011-06-30 29    
DFID_201107.csv 633,336,281.59 4840 0 130,854.60 130,712,400.00 2011-07-01 2011-07-29 28     Jump in AvgAmt
DFID_201108.csv 438,920,421.57 4740 0 92,599.25 55,712,834.68 2011-08-01 2011-08-31 30    
DFID_201109.csv 451,975,902.16 1950 0 231,782.51 70,000,000.00 2011-09-01 2011-09-30 29     Jump in AvgAmt
DFID_201110.csv 655,216,165.34 2144 0 305,604.55 83,760,000.00 2011-10-03 2011-10-31 28    
DFID_201111.csv 571,976,418.01 2079 0 275,120.93 127,863,583.00 2011-11-01 2011-12-01 30    
DFID_201112.csv 1,463,721,530.00 2207 0 663,217.73 240,786,468.00 2011-12-01 2011-12-30 29     Jump in TotalAmt. Jump in AvgAmt
DFID_201201.csv 241,918,168.00 2051 0 117,951.33 36,000,000.00 2012-01-02 2012-02-01 30     Large drop in TotalAmt. Drop in AvgAmt
DFID_201202.csv 372,279,943.00 2388 0 155,896.12 83,760,000.00 2012-02-01 2012-02-29 28    
DFID_201203.csv 478,588,868.00 2472 0 193,603.91 50,000,000.00 2012-03-01 2012-03-31 30    
DFID_201204.csv 735,036,112.00 3498 0 210,130.39 33,000,000.00 2012-04-02 2012-05-01 29    
DFID_201205.csv 209,200,926.00 1820 0 114,945.56 15,501,975.00 2012-05-01 2012-05-31 30     Drop in TotalAmt.
DFID_201206.csv 514,388,413.00 1803 0 285,295.85 159,840,000.00 2012-06-01 2012-06-30 29     Jump in TotalAmt. Jump in AvgAmt
DFID_201207.csv 556,592,633.31 2203 0 252,652.13 81,917,500.00 2012-07-01 2012-07-31 30    
DFID_201208.csv 477,939,842.12 1790 0 267,005.50 68,000,000.00 2012-08-01 2012-08-31 30    
DFID_201209.csv 677,581,714.00 1698 0 399,046.95 129,000,000.00 2012-09-03 2012-09-30 27    
DFID_201210.csv 703,217,814.85 2504 0 280,837.79 85,000,000.00 2012-10-01 2012-10-31 30    
DFID_201211.csv 401,262,847.58 2035 0 197,180.76 27,347,000.00 2012-11-01 2012-11-30 29    
DFID_201212.csv 1,015,279,026.00 2000 0 507,639.51 222,735,708.00 2012-12-03 2012-12-31 28     Jump in TotalAmt. Jump in AvgAmt
DFID_201301.csv 542,202,362.55 2195 0 247,017.02 81,917,500.00 2013-01-02 2013-01-31 29    
DFID_201302.csv 356,110,194.57 1874 0 190,026.78 20,927,848.42 2013-02-01 2013-02-28 27    
DFID_201303.csv 456,912,109.04 2669 0 171,192.25 31,857,940.82 2013-03-01 2013-03-27 26    
DFID_201304.csv 740,957,239.83 2000 0 370,478.62 81,917,500.00 2013-04-02 2013-04-30 28     Jump in AvgAmt
DFID_201305.csv 369,851,530.01 2128 0 173,802.41 43,553,622.89 2013-05-01 2013-05-31 30    
DFID_201306.csv 413,003,646.78 1944 0 212,450.44 42,500,000.00 2013-06-03 2013-06-30 27    
DFID_201307.csv 837,232,900.87 2357 0 355,211.24 112,490,000.00 2013-07-01 2013-07-31 30     Jump in TotalAmt.
DFID_201308.csv 431,679,507.99 1999 0 215,947.73 60,820,000.00 2013-08-01 2013-08-30 29    
DFID_201309.csv 673,239,068.76 1961 0 343,314.16 253,000,000.00 2013-09-01 2013-09-30 29    
DFID_201310.csv 748,221,732.75 2349 0 318,527.77 118,547,500.00 2013-10-01 2013-10-31 30    
DFID_201311.csv 1,064,702,451.96 2331 0 456,757.81 100,000,000.00 2013-11-01 2013-11-29 28    
DFID_201312.csv 1,314,781,089.02 2082 0 631,499.08 250,665,480.00 2013-12-01 2013-12-31 30    
DFID_201401.csv 758,051,391.59 2618 0 289,553.63 118,547,500.00 2014-01-02 2014-01-31 29    
DFID_201402.csv 479,791,560.02 2252 0 213,051.31 189,003,840.06 2014-02-01 2014-02-28 27    
DFID_201403.csv 443,754,294.53 2286 0 194,118.24 60,820,000.00 2014-03-01 2014-03-31 30    
DFID_201404.csv 518,324,459.66 1943 0 266,765.03 118,547,500.00 2014-04-01 2014-04-30 29    
DFID_201405.csv 368,709,733.03 2217 0 166,310.21 71,045,883.16 2014-05-01 2014-05-31 30    
DFID_201406.csv 386,267,812.84 2323 0 166,279.73 78,300,000.00 2014-06-01 2014-06-30 29    
DFID_201407.csv 437,355,998.42 2502 0 174,802.56 100,196,752.01 2014-07-01 2014-07-31 30    
DFID_201408.csv 309,572,234.21 2007 0 154,246.26 21,361,507.96 2014-08-01 2014-08-30 29    
DFID_201409.csv 566,175,805.33 1970 0 287,398.89 198,400,000.00 2014-09-01 2014-09-30 29    
DFID_201410.csv 680,780,778.04 2759 0 246,749.10 107,892,500.00 2014-10-01 2014-10-31 30    
DFID_201411.csv 757,280,569.67 2277 0 332,578.20 82,000,000.00 2014-11-03 2014-11-30 27    
DFID_201412.csv 1,128,382,226.82 2110 0 534,778.31 175,483,620.00 2014-12-01 2014-12-31 30    
DFID_201501.csv 428,406,908.64 2288 0 187,240.78 55,377,500.00 2015-01-02 2015-01-31 29     Drop in TotalAmt.
DFID_201502.csv 186,743,461.79 2255 0 82,813.07 7,926,756.02 2015-02-01 2015-02-28 27    
DFID_201503.csv 425,920,422.53 2793 0 152,495.68 46,415,000.00 2015-03-01 2015-03-31 30     Jump in TotalAmt.
DFID_201504.csv 755,234,244.65 1907 0 396,032.64 107,892,500.00 2015-04-01 2015-04-30 29     Jump in AvgAmt
DFID_201505.csv 413,719,033.84 1791 0 230,998.90 39,963,172.43 2015-05-01 2015-05-31 30    
DFID_201506.csv 415,024,499.07 2018 0 205,661.30 46,000,000.00 2015-01-06 2015-12-06 334    
DFID_201507.csv 934,818,803.54 2016 0 463,699.80 94,730,000.00 2015-01-07 2015-10-07 273     Jump in TotalAmt. Jump in AvgAmt
DFID_201508.csv 444,635,190.46 1665 0 267,048.16 30,000,000.00 2015-08-01 2015-08-31 30    
DFID_201509.csv 761,963,363.11 1596 0 477,420.65 265,465,429.49 2015-09-01 2015-09-30 29    
DFID_201510.csv 925,732,466.68 1760 0 525,984.36 40,000,000.00 2015-10-01 2015-10-30 29    
DFID_201511.csv 1,327,174,375.62 1878 0 706,695.62 95,905,000.00 2015-11-02 2015-11-30 28    
DFID_201512.csv 1,059,026,003.81 2308 0 458,850.09 198,539,400.93 2015-12-01 2015-12-31 30    
DFID_201601.csv 524,379,023.58 1229 0 426,671.30 95,905,000.00 2016-01-05 2016-01-29 24    
DFID_201602.csv 269,918,194.85 1532 0 176,186.81 22,922,434.05 2016-02-01 2016-02-29 28    
DFID_201603.csv 289,183,819.92 1776 0 162,828.73 15,000,000.00 2016-03-01 2016-03-31 30    
DFID_201604.csv 1,021,582,002.08 1550 0 659,085.16 200,000,000.00 2016-04-01 2016-04-29 28     Jump in TotalAmt. Jump in AvgAmt
DFID_201605.csv 440,687,424.85 1545 0 285,234.58 26,334,565.23 2016-05-03 2016-05-31 28    
DFID_201606.csv 777,418,349.68 1599 0 486,190.34 58,338,000.00 2016-06-01 2016-06-30 29    
DFID_201607.csv 847,224,230.45 1650 0 513,469.23 130,302,597.27 2016-07-01 2016-07-31 30    
DFID_201608.csv 624,522,367.28 1358 0 459,883.92 27,500,000.00 2016-08-01 2016-08-31 30    
DFID_201609.csv 545,057,293.88 1742 0 312,891.67 30,000,000.00 2016-09-01 2016-09-30 29    
DFID_201610.csv 1,519,658,197.94 1943 0 782,119.50 415,000,000.00 2016-10-02 2016-10-31 29     Jump in TotalAmt. Jump in AvgAmt
DFID_201611.csv 984,644,683.81 2012 0 489,386.03 99,707,990.63 2016-11-01 2016-11-30 29    
DFID_201612.csv 1,326,633,062.81 2246 0 590,664.77 211,062,735.00 2016-12-01 2016-12-30 29    
DFID_201701.csv 934,020,302.50 1378 0 677,808.64 274,987,500.00 2017-01-02 2017-01-31 29    
DFID_201702.csv 182,414,896.04 1593 0 114,510.29 6,000,000.00 2017-02-01 2017-02-28 27     Large drop in TotalAmt. Drop in AvgAmt
DFID_201703.csv 448,066,809.04 1876 0 238,841.58 100,000,000.00 2017-03-01 2017-03-31 30     Jump in TotalAmt. Jump in AvgAmt
DFID_201704.csv 1,341,996,621.86 1576 0 851,520.70 285,000,000.00 2017-04-01 2017-04-28 27     Jump in TotalAmt. Jump in AvgAmt
DFID_201705.csv 463,407,820.20 1613 0 287,295.61 34,750,368.13 2017-05-02 2017-05-31 29     Drop in TotalAmt.
DFID_201706.csv 580,502,508.39 1645 0 352,889.06 73,720,666.78 2017-06-01 2017-06-30 29    
DFID_201707.csv 849,067,864.68 1497 0 567,179.60 171,053,151.62 2017-07-02 2017-07-31 29    
DFID_201708.csv 412,915,224.82 1584 0 260,678.80 28,000,000.00 2017-08-01 2017-08-31 30    
DFID_201709.csv 622,464,044.62 1464 0 425,180.36 55,000,000.00 2017-09-01 2017-09-29 28    
DFID_201710.csv 1,054,329,021.45 1788 0 589,669.48 152,940,000.00 2017-10-02 2017-10-31 29    
DFID_201711.csv 1,288,772,345.86 1691 0 762,136.22 119,072,877.00 2017-11-01 2017-11-30 29    
DFID_201712.csv 997,534,071.28 1960 0 508,945.95 151,142,240.01 2017-12-01 2017-12-31 30    
DFID_201801.csv 610,082,486.73 1164 0 524,125.85 115,145,843.94 2018-01-02 2018-01-31 29    
DFID_201802.csv 302,797,373.83 1322 0 229,044.91 21,968,404.00 2018-02-01 2018-02-28 27    
DFID_201803.csv 819,787,799.78 1813 0 452,171.98 210,873,328.00 2018-03-01 2018-03-31 30     Jump in TotalAmt.
DFID_201804.csv 573,487,030.76 1479 0 387,753.23 89,718,000.00 2018-04-01 2018-04-30 29    
DFID_201805.csv 466,095,833.44 1624 0 287,004.82 48,500,000.00 2018-05-01 2018-05-31 30    
DFID_201806.csv 704,417,530.62 1611 0 437,254.83 145,930,000.00 2018-06-01 2018-06-30 29    
DFID_201807.csv 841,399,691.98 1624 0 518,103.26 170,018,639.02 2018-07-01 2018-07-31 30    
DFID_201808.csv 731,332,847.80 1532 0 477,371.31 48,300,000.00 2018-08-01 2018-08-31 30    
DFID_201809.csv 441,776,474.98 1229 0 359,460.11 48,205,900.00 2018-09-01 2018-09-28 27    
DFID_201810.csv 1,108,389,747.32 1872 0 592,088.54 270,000,000.00 2018-10-01 2018-10-31 30     Jump in TotalAmt.
DFID_201811.csv 1,215,121,110.95 1817 0 668,751.30 116,524,169.86 2018-11-01 2018-11-30 29    
DFID_201812.csv 761,087,055.31 1952 0 389,901.16 34,000,000.00 2018-12-02 2018-12-31 29    
DFID_201901.csv 855,898,531.61 1428 0 599,368.72 260,134,503.64 2019-01-02 2019-01-31 29    
DFID_201902.csv 305,925,370.93 1474 0 207,547.74 21,373,410.00 2019-02-01 2019-02-28 27     Drop in TotalAmt.
DFID_201903.csv 666,709,936.08 1949 0 342,077.96 302,400,000.00 2019-03-01 2019-03-29 28     Jump in TotalAmt.
DFID_201904.csv 1,007,301,157.37 1322 0 761,952.46 200,000,000.00 2019-04-01 2019-04-30 29     Jump in AvgAmt
DFID_201905.csv 554,292,582.13 1602 0 346,000.36 25,230,185.68 2019-05-01 2019-05-31 30    
DFID_201906.csv 426,830,114.29 1397 0 305,533.37 70,000,000.00 2019-06-01 2019-06-30 29    
DFID_201907.csv 1,086,545,119.91 1623 0 669,467.11 198,035,867.80 2019-07-01 2019-07-31 30     Jump in TotalAmt. Jump in AvgAmt
DFID_201908.csv 606,085,331.04 1437 0 421,771.28 44,100,000.00 2019-08-01 2019-08-30 29    
DFID_201909.csv 460,051,585.92 1013 0 454,147.67 40,000,000.00 2019-09-02 2019-09-30 28    
DFID_201910.csv 2,118,212,166.46 1760 0 1,203,529.64 300,000,000.00 2019-10-01 2019-10-31 30     Large jump in TotalAmt. Jump in AvgAmt
DFID_201911.csv 968,911,264.55 1463 0 662,277.01 113,804,074.79 2019-11-01 2019-11-30 29    
DFID_201912.csv 1,786,047,692.62 1716 0 1,040,820.33 300,000,000.00 2019-12-02 2019-12-31 29    

Total amount : £73,440,426,246.96 in 212,267 records from 108 source files (mean= £680,003,947 and 1,965 recs/mth) (Range=2011/01 - 2019/12)

OrigRecs shows the number of records that were in the original source file.
AggRecs shows the number of records if aggregation has been used - similar transactions (eg for the same supplier in the same month with the same expenditure type etc) have been combined together to give a single record with a total amount and the date set to the first of the month. Typically this results in a 70% reduction in the number of records.
AvgAmt shows the average (mean) transaction value per original record in that file. One might expect this value to be roughly constant across files.
MaxAmt shows the value of the single largest transaction in that file. Note that errors may be reversed out by subsequent contrary transactions.
MinDate shows the earliest transaction date in that file. MaxDate shows the highest transaction date. Diff shows the difference in days.
Comment highlights significant potential anomalies - large increases/decreases in Total Amt or Avg Amt.


Acknowledgement: Spend data provided by this department has been re-used under the Open Government Licence.