Summary of currently loaded spend data for: Department of Health & Social Care

Lastfile: DH_201912
File name TotalAmt£ OrigRecs AggRecs     AvgAmt£ MaxAmt£           MinDate       MaxDate     Diff     Comment
DH_201101.csv 7,488,217,477.12 1607 0 4,659,749.52 99,999,999.99 2011-01-01 2011-01-31 30    
DH_201102.csv 7,511,282,511.92 1195 0 6,285,592.06 99,999,999.99 2011-02-01 2011-02-28 27    
DH_201103.csv 8,697,004,326.38 2040 0 4,263,237.41 99,999,999.99 2011-03-01 2011-03-31 30    
DH_201104.csv 7,997,446,991.32 1452 0 5,507,883.60 99,999,999.99 2011-04-01 2011-04-29 28    
DH_201105.csv 7,167,566,082.77 701 0 10,224,773.30 99,999,999.99 2011-05-01 2011-05-31 30    
DH_201106.csv 8,343,835,859.76 1889 0 4,417,065.04 99,999,999.99 2011-06-01 2011-06-30 29    
DH_201107.csv 7,859,445,322.24 1324 0 5,936,136.95 99,999,999.99 2011-07-01 2011-07-29 28    
DH_201108.csv 7,079,141,226.40 819 0 8,643,640.08 99,999,999.99 2011-08-01 2011-08-31 30    
DH_201109.csv 7,443,486,122.90 1533 0 4,855,503.02 99,999,999.99 2011-09-01 2011-09-30 29    
DH_201110.csv 7,760,129,015.57 1375 0 5,643,730.19 99,999,999.99 2011-08-30 2011-10-31 62    
DH_201111.csv 7,119,759,807.02 839 0 8,486,006.92 99,999,999.99 2011-11-01 2011-11-30 29    
DH_201112.csv 7,443,292,512.39 1662 0 4,478,515.35 99,999,999.99 2011-09-01 2011-12-30 120    
DH_201201.csv 7,524,126,595.54 1578 0 4,768,141.06 99,999,999.99 2011-12-23 2012-01-31 39    
DH_201202.csv 7,368,672,040.72 725 0 10,163,685.57 99,999,999.99 2012-02-01 2012-02-29 28     Jump in AvgAmt
DH_201203.csv 9,311,602,407.21 2074 0 4,489,682.94 99,999,999.99 2012-02-01 2012-03-30 58    
DH_201204.csv 7,813,103,647.71 1571 0 4,973,331.41 99,999,999.99 2012-04-01 2012-04-30 29    
DH_201205.csv 8,284,573,047.89 909 0 9,113,941.75 99,999,999.99 2012-05-01 2012-05-31 30    
DH_201206.csv 7,588,303,122.82 1640 0 4,627,014.10 99,999,999.99 2012-06-01 2012-06-29 28    
DH_201207.csv 8,042,641,989.56 1625 0 4,949,318.15 151,200,000.00 2012-07-01 2012-07-31 30    
DH_201208.csv 8,930,757,313.00 723 0 12,352,361.43 1,710,000,000.00 2012-08-01 2012-08-31 30     Jump in AvgAmt
DH_201209.csv 7,759,127,168.00 1491 0 5,203,975.30 153,300,000.00 2012-09-01 2012-09-28 27    
DH_201210.csv 8,625,687,494.00 1175 0 7,341,010.63 912,000,000.00 2012-10-01 2012-10-31 30    
DH_201211.csv 9,189,780,825.94 949 0 9,683,646.81 1,715,000,000.00 2012-11-01 2012-11-30 29    
DH_201212.csv 8,828,747,375.49 1775 0 4,973,942.18 903,000,000.00 2012-12-01 2012-12-31 30    
DH_201301.csv 8,205,771,981.02 1349 0 6,082,855.43 226,069,000.00 2013-01-01 2013-01-31 30    
DH_201302.csv 11,143,100,702.00 2254 0 4,943,700.40 868,000,000.00 2013-03-01 2013-03-31 30    
DH_201303.csv 9,334,835,652.25 760 0 12,282,678.49 882,000,000.00 2013-02-01 2013-02-28 27     Jump in AvgAmt
DH_201304.csv 11,930,137,020.78 1080 0 11,046,423.17 5,038,338,000.00 2013-04-01 2013-04-30 29    
DH_201305.csv 9,780,340,320.77 559 0 17,496,136.53 4,544,901,000.00 2013-05-01 2013-05-31 30    
DH_201306.csv 6,945,602,431.93 1616 0 4,298,021.31 3,932,753,000.00 2013-06-01 2013-06-28 27    
DH_201307.csv 8,872,768,869.00 1004 0 8,837,419.19 4,249,206,000.00 2013-07-01 2013-07-31 30     Jump in AvgAmt
DH_201308.csv 9,020,565,948.96 762 0 11,838,013.06 4,226,006,000.00 2013-08-01 2013-08-30 29    
DH_201309.csv 8,006,519,111.95 1405 0 5,698,590.12 4,490,363,000.00 2013-09-01 2013-09-30 29    
DH_201310.csv 9,273,026,973.40 882 0 10,513,636.02 4,567,235,000.00 2013-10-01 2013-10-31 30    
DH_201311.csv 8,971,835,315.18 547 0 16,401,892.72 4,553,761,000.00 2013-11-01 2013-11-29 28    
DH_201312.csv 8,948,186,183.00 1657 0 5,400,233.06 4,565,671,000.00 2013-12-01 2013-12-31 30    
DH_201401.csv 9,439,542,240.17 669 0 14,109,928.61 4,783,717,000.00 2014-01-01 2014-01-31 30     Jump in AvgAmt
DH_201402.csv 9,130,611,639.00 568 0 16,075,020.49 4,673,016,000.00 2014-02-01 2014-02-28 27    
DH_201403.csv 9,620,228,546.81 2185 0 4,402,850.59 5,152,251,000.00 2014-03-01 2014-03-31 30    
DH_201404.csv 10,184,670,477.82 738 0 13,800,366.50 5,235,724,000.00 2014-04-01 2014-04-30 29     Jump in AvgAmt
DH_201405.csv 9,671,306,830.58 546 0 17,713,016.17 4,783,390,000.00 2014-05-01 2014-05-30 29    
DH_201406.csv 7,781,803,383.42 1646 0 4,727,705.58 4,601,880,000.00 2014-06-01 2014-06-30 29    
DH_201407.csv 9,667,999,790.65 753 0 12,839,309.15 4,760,607,000.00 2014-07-01 2014-07-31 30     Jump in AvgAmt
DH_201408.csv 8,897,758,436.91 864 0 10,298,331.52 4,699,304,000.00 2014-08-01 2014-08-29 28    
DH_201409.csv 9,232,088,741.92 1493 0 6,183,582.55 4,746,094,000.00 2014-09-01 2014-09-30 29    
DH_201410.csv 10,522,890,052.20 720 0 14,615,125.07 4,829,192,000.00 2014-10-01 2014-10-31 30     Jump in AvgAmt
DH_201411.csv 7,972,535,066.82 613 0 13,005,766.83 4,709,602,000.00 2014-11-01 2014-11-28 27    
DH_201412.csv 9,943,965,886.98 1695 0 5,866,646.54 4,862,006,000.00 2014-12-01 2014-12-31 30    
DH_201501.csv 10,597,235,503.81 849 0 12,482,020.62 5,031,014,000.00 2015-01-01 2015-01-30 29     Jump in AvgAmt
DH_201502.csv 9,211,992,496.13 691 0 13,331,392.90 4,912,232,000.00 2015-02-01 2015-02-27 26    
DH_201503.csv 10,140,193,666.39 2205 0 4,598,727.29 5,263,040,000.00 2015-03-01 2015-03-31 30    
DH_201504.csv 10,737,673,912.92 869 0 12,356,356.63 5,345,255,000.00 2015-04-01 2015-04-30 29     Jump in AvgAmt
DH_201505.csv 9,010,331,172.55 523 0 17,228,166.68 4,951,089,000.00 2015-05-01 2015-05-29 28    
DH_201506.csv 9,280,534,107.24 1758 0 5,279,029.64 4,834,189,000.00 2015-06-01 2015-06-30 29    
DH_201507.csv 11,392,373,427.61 923 0 12,342,766.44 5,172,894,000.00 2015-07-01 2015-07-31 30     Jump in AvgAmt
DH_201508.csv 8,949,119,115.74 596 0 15,015,300.53 5,118,667,000.00 2015-08-01 2015-08-28 27    
DH_201509.csv 9,561,195,996.03 1709 0 5,594,614.39 5,101,215,000.00 2015-09-01 2015-09-30 29    
DH_201510.csv 11,202,883,553.00 551 0 20,331,912.07 5,229,470,000.00 2015-10-01 2015-10-30 29     Jump in AvgAmt
DH_201511.csv 8,561,992,690.00 619 0 13,831,975.27 5,063,772,000.00 2015-11-01 2015-11-30 29    
DH_201512.csv 10,832,279,631.46 1424 0 7,606,937.94 5,049,082,000.00 2015-12-01 2015-12-30 29    
DH_201601.csv 8,914,893,779.00 703 0 12,681,214.48 5,143,199,000.00 2016-01-01 2016-01-29 28    
DH_201602.csv 9,801,038,772.29 692 0 14,163,350.83 4,956,369,000.00 2016-02-01 2016-03-07 35    
DH_201603.csv 10,458,017,341.57 2032 0 5,146,662.08 5,327,729,000.00 2016-03-01 2016-03-31 30    
DH_201604.csv 11,962,451,160.68 736 0 16,253,330.38 5,699,067,000.00 2016-04-01 2016-04-29 28     Jump in AvgAmt
DH_201605.csv 8,680,334,585.41 554 0 15,668,473.98 5,494,420,000.00 2016-05-01 2016-05-31 30    
DH_201606.csv 9,590,872,453.48 1448 0 6,623,530.70 5,442,131,000.00 2016-06-01 2016-06-30 29    
DH_201607.csv 10,751,736,501.87 817 0 13,160,020.20 5,758,156,000.00 2016-07-01 2016-07-29 28    
DH_201608.csv 9,737,148,106.75 554 0 17,576,079.62 5,508,855,000.00 2016-07-20 2016-08-31 42    
DH_201609.csv 10,511,231,382.00 1441 0 7,294,400.68 5,631,778,000.00 2016-09-01 2016-09-30 29    
DH_201610.csv 9,774,557,734.14 612 0 15,971,499.57 5,735,679,000.00 2016-10-01 2016-10-31 30     Jump in AvgAmt
DH_201611.csv 10,079,215,806.00 631 0 15,973,400.64 5,590,687,000.00 2016-11-01 2016-11-30 29    
DH_201612.csv 10,400,493,579.00 1318 0 7,891,118.04 5,561,905,000.00 2016-12-01 2016-12-30 29    
DH_201701.csv 9,760,703,769.00 531 0 18,381,739.68 5,712,497,000.00 2017-01-01 2017-01-31 30     Jump in AvgAmt
DH_201702.csv 9,898,172,041.37 527 0 18,782,110.14 5,622,470,000.00 2017-02-01 2017-02-28 27    
DH_201703.csv 10,765,161,393.78 1532 0 7,026,867.75 6,008,324,000.00 2017-03-01 2017-03-31 30    
DH_201704.csv 12,242,531,530.00 417 0 29,358,588.80 6,166,101,000.00 2017-04-01 2017-04-28 27     Jump in AvgAmt
DH_201705.csv 8,775,424,159.24 452 0 19,414,655.22 5,880,162,000.00 2017-05-01 2017-05-31 30    
DH_201706.csv 11,082,704,571.00 1404 0 7,893,664.22 5,907,039,000.00 2017-06-01 2017-07-12 41    
DH_201707.csv 9,954,347,777.72 502 0 19,829,378.04 6,028,104,000.00 2017-07-01 2017-07-31 30     Jump in AvgAmt
DH_201708.csv 9,790,599,517.21 560 0 17,483,213.42 5,928,681,000.00 2017-08-01 2017-08-31 30    
DH_201709.csv 16,793,588,962.74 1598 0 10,509,129.51 5,975,483,000.00 2017-09-01 2017-09-29 28    
DH_201710.csv 9,923,868,546.59 612 0 16,215,471.48 5,975,483,000.00 1900-01-04 2017-10-31 43034    
DH_201711.csv 9,889,547,495.84 681 0 14,522,096.18 5,846,685,000.00 2017-11-01 2017-11-30 29    
DH_201712.csv 11,161,674,590.53 1438 0 7,761,943.39 5,957,573,000.00 2017-09-30 2017-12-29 90    
DH_201801.csv 10,224,359,617.47 794 0 12,877,027.23 6,059,983,000.00 2018-01-01 2018-01-31 30    
DH_201802.csv 10,026,962,660.67 597 0 16,795,582.35 5,971,410,000.00 2018-02-01 2018-02-28 27    
DH_201803.csv 11,452,011,950.24 1892 0 6,052,860.44 6,337,517,000.00 2018-03-01 2018-03-29 28    
DH_201804.csv 11,155,716,044.98 493 0 22,628,227.27 6,213,547,000.00 2018-04-01 2018-04-30 29     Jump in AvgAmt
DH_201805.csv 10,443,464,275.23 407 0 25,659,617.38 6,093,455,000.00 2018-05-01 2018-05-31 30    
DH_201806.csv 11,027,859,040.85 1509 0 7,308,057.68 6,229,201,000.00 2018-06-01 2018-06-29 28    
DH_201807.csv 11,606,670,564.06 763 0 15,211,888.03 6,385,701,000.00 2018-07-01 2018-07-31 30     Jump in AvgAmt
DH_201808.csv 10,968,017,490.42 872 0 12,578,001.71 6,193,387,000.00 2018-08-01 2018-08-31 30    
DH_201809.csv 9,448,332,434.88 1570 0 6,018,046.14 6,170,324,000.00 2018-09-01 2018-09-28 27    
DH_201810.csv 11,276,864,855.31 861 0 13,097,404.01 6,364,286,000.00 2018-10-01 2018-10-31 30     Jump in AvgAmt
DH_201811.csv 10,848,013,895.54 885 0 12,257,642.82 6,227,882,000.00 2018-11-01 2018-11-30 29    
DH_201812.csv 11,033,230,499.98 1797 0 6,139,805.51 6,278,379,000.00 2018-12-03 2018-12-31 28    
DH_201901.csv 10,686,551,134.36 886 0 12,061,570.13 6,423,132,000.00 2019-01-02 2019-01-31 29    
DH_201902.csv 10,328,862,365.97 785 0 13,157,786.45 6,230,064,000.00 2019-02-01 2019-02-28 27    
DH_201903.csv 11,568,726,637.86 2041 0 5,668,165.92 6,690,050,000.00 2019-03-01 2019-03-29 28    
DH_201904.csv 11,425,363,412.34 627 0 18,222,270.20 6,549,394,000.00 2019-04-01 2019-04-30 29     Jump in AvgAmt
DH_201905.csv 12,105,129,392.85 429 0 28,217,084.83 6,594,398,000.00 2019-05-01 2019-05-31 30    
DH_201906.csv 10,069,768,223.86 1357 0 7,420,610.33 6,727,463,000.00 2019-06-01 2019-06-28 27    
DH_201907.csv 14,235,591,005.25 531 0 26,809,022.61 6,893,959,000.00 2019-07-01 2019-07-31 30     Jump in AvgAmt
DH_201908.csv 11,702,006,957.53 465 0 25,165,606.36 6,821,539,000.00 2019-08-01 2019-08-30 29    
DH_201909.csv 10,477,411,976.27 1290 0 8,122,024.79 6,784,104,000.00 2019-09-01 2019-09-30 29    
DH_201910.csv 11,822,753,443.79 626 0 18,886,187.61 6,782,905,000.00 2019-10-01 2019-10-31 30     Jump in AvgAmt
DH_201911.csv 12,121,772,707.71 608 0 19,937,126.16 6,703,087,000.00 2019-11-01 2019-11-29 28    
DH_201912.csv 11,445,661,669.13 1654 0 6,919,988.92 6,798,024,000.00 2019-12-01 2019-12-31 30    

Total amount : £1,051,355,044,973.83 in 117,284 records from 108 source files (mean= £9,734,768,935 and 1,085 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.