Summary of currently loaded LA spend data for : Havering

Lastfile: Havering_201911     LA spend page opens in new window
Sourcefile name Total Amount £ OrigRecs AggRecs AvgAmt£ AAZ   MaxAmt £     MinDate MaxDate Dif     Comment
Havering_201101.csv 39,471,098.80 5360 0 7,364.01 0.0 2,759,683.62   2010-10-01 2011-01-31 3    
Havering_201102.csv 18,604,727.03 5199 0 3,578.52 0.0 1,162,804.08   2010-09-23 2011-02-25 5    
Havering_201103.csv 63,156,047.05 6822 0 9,257.70 0.0 2,759,683.62   2010-11-25 2011-03-30 4     Large jump in Total Amt. Analysis
Havering_201104.csv 19,927,920.15 3590 0 5,550.95 0.0 2,757,362.20   2001-03-18 2011-04-28 121     Drop in Total Amt. Analysis
Havering_201105.csv 48,554,580.65 4996 0 9,718.69 0.0 2,757,362.20   2011-01-13 2011-05-31 4     Jump in Total Amt. Analysis
Havering_201106.csv 29,909,933.32 5563 0 5,376.58 0.0 2,757,362.20   2010-09-27 2011-06-30 9    
Havering_201107.csv 23,435,772.20 4840 0 4,842.10 0.0 2,213,238.18   2011-01-31 2011-07-29 6    
Havering_201108.csv 28,013,030.44 4379 0 6,397.13 0.0 2,757,362.20   2010-12-23 2011-08-31 8    
Havering_201109.csv 22,760,391.05 4279 0 5,319.09 0.0 4,138,268.18   2011-03-10 2011-09-30 6    
Havering_201110.csv 27,444,073.81 4152 0 6,609.84 0.0 2,757,362.20   2011-03-29 2011-10-31 7    
Havering_201111.csv 41,097,082.21 4524 0 9,084.24 0.0 2,757,362.20   2011-03-27 2011-11-30 8    
Havering_201112.csv 41,097,082.21 4524 0 9,084.24 0.0 2,757,362.20   2011-03-27 2011-11-30 8    
Havering_201201.csv 40,470,998.43 5372 0 7,533.69 0.0 2,757,362.20   2011-02-22 2012-01-31 11    
Havering_201202.csv 40,044,190.82 4906 0 8,162.29 0.0 2,757,362.20   2012-01-31 2012-02-29 1    
Havering_201203.csv 56,228,216.92 5889 0 9,548.01 0.0 2,757,362.20   2011-04-01 2012-03-30 11    
Havering_201204.csv 28,692,791.51 4398 0 6,524.05 0.0 2,790,943.39   2011-12-02 2012-04-30 4    
Havering_201205.csv 50,477,186.12 5055 0 9,985.60 0.0 2,790,943.41   2012-04-04 2012-05-31 1    
Havering_201206.csv 27,969,147.04 4611 0 6,065.74 0.0 1,798,384.99   2012-05-25 2012-07-09 2    
Havering_201207.csv 44,769,970.29 6803 0 6,580.92 0.0 2,790,943.41   2012-03-14 2012-07-31 4    
Havering_201208.csv 50,266,071.92 4949 0 10,156.81 0.0 2,790,943.41   2012-08-01 2012-08-31 0    
Havering_201209.csv 28,398,265.87 4692 0 6,052.49 0.0 2,790,943.41   2012-04-05 2012-09-29 5    
Havering_201210.csv 35,846,778.52 5666 0 6,326.65 0.0 837,450.77   2012-06-06 2012-10-31 4    
Havering_201211.csv 21,666,672.71 6040 0 3,587.20 0.0 861,375.78   2012-04-12 2012-11-30 7    
Havering_201212.csv 33,836,438.52 6203 0 5,454.85 0.0 4,224,147.02   2012-03-08 2012-12-31 9    
Havering_201301.csv 27,816,937.55 6103 0 4,557.91 0.0 510,825.76   2012-04-14 2013-01-31 9    
Havering_201302.csv 33,994,890.86 6255 0 5,434.83 0.0 434,560.00   2012-08-09 2013-02-28 6    
Havering_201303.csv 34,577,827.71 6681 0 5,175.55 0.0 900,325.54   2012-02-06 2013-03-30 13    
Havering_201304.csv 19,328,865.98 5547 0 3,484.56 0.0 403,897.35   2013-02-08 2013-04-30 2    
Havering_201305.csv 26,227,135.42 5653 0 4,639.51 0.0 446,440.00   2012-09-21 2013-05-31 8    
Havering_201306.csv 27,157,867.12 5425 0 5,006.06 0.0 452,580.00   2013-04-11 2013-06-29 2    
Havering_201307.csv 30,666,113.96 7648 0 4,009.69 0.0 697,430.00   2012-07-05 2013-07-31 12    
Havering_201308.csv 26,535,296.44 5177 0 5,125.61 0.0 414,720.00   2013-02-04 2013-08-30 6    
Havering_201309.csv 30,979,277.41 5476 0 5,657.28 0.0 855,174.05   2012-04-03 2013-09-30 17    
Havering_201310.csv 33,629,261.43 6291 0 5,345.61 0.0 515,871.00   2011-09-22 2013-10-31 25    
Havering_201311.csv 32,958,163.99 6458 0 5,103.46 0.0 403,897.31   2013-01-11 2013-11-29 10    
Havering_201312.csv 22,026,042.81 5144 0 4,281.89 0.0 840,775.79   2013-07-31 2013-12-31 5    
Havering_201401.csv 29,457,551.66 6167 0 4,776.64 0.0 518,681.49   2013-08-02 2014-01-31 5    
Havering_201402.csv 20,381,505.02 5758 0 3,539.68 0.0 398,926.00   2012-10-08 2014-02-28 16    
Havering_201403.csv 32,356,728.50 6859 0 4,717.41 0.0 830,613.34   2014-03-01 2014-03-31 0    
Havering_201404.csv 19,742,261.21 5523 0 3,574.55 0.0 416,959.62   2013-09-03 2014-04-30 7    
Havering_201405.csv 23,059,132.51 6086 0 3,788.88 0.0 878,047.71   2013-03-05 2014-05-31 14    
Havering_201406.csv 27,051,346.54 5959 0 4,539.58 0.0 409,680.00   2014-03-07 2014-06-30 3    
Havering_201407.csv 39,969,086.70 7409 0 5,394.67 0.0 432,936.00   2013-11-28 2014-07-22 8    
Havering_201408.csv 9,244,716.06 6395 0 1,445.62 0.0 192,590.00   2014-08-01 2014-08-29 0     Drop in Total Amt. Analysis
Havering_201409.csv 11,035,594.22 5326 0 2,072.02 0.0 216,433.88   2014-09-01 2014-09-30 0    
Havering_201410.csv 9,294,344.94 4536 0 2,049.02 0.0 258,601.27   2014-10-01 2014-10-31 0    
Havering_201411.csv 9,080,178.21 4927 0 1,842.94 0.0 515,278.31   2014-11-01 2014-11-29 0    
Havering_201412.csv 11,694,560.41 5606 0 2,086.08 0.0 257,639.16   2014-12-01 2014-12-31 0    
Havering_201501.csv 10,242,057.95 5148 0 1,989.52 0.0 668,984.70   2015-01-01 2015-01-31 0    
Havering_201502.csv 10,366,225.43 4888 0 2,120.75 0.0 400,000.00   2015-02-01 2015-02-28 0    
Havering_201503.csv 12,877,336.15 5643 0 2,282.00 0.0 222,240.84   2015-03-01 2015-03-31 0    
Havering_201504.csv 9,561,089.86 4886 0 1,956.83 0.0 339,486.00   2015-04-01 2015-04-30 0    
Havering_201505.csv 12,458,374.33 6842 0 1,820.87 0.0 234,073.00   2015-05-01 2015-05-31 0    
Havering_201506.csv 11,911,303.69 5600 0 2,127.02 0.0 1,344,520.60   2015-06-01 2015-06-30 0    
Havering_201507.csv 20,804,651.67 5548 0 3,749.94 0.0 420,730.00   2015-07-01 2015-07-31 0    
Havering_201508.csv 8,318,357.68 4677 0 1,778.57 0.0 234,073.00   2015-08-01 2015-08-31 0     Drop in Total Amt. Analysis
Havering_201509.csv 8,546,061.79 5055 0 1,690.62 0.0 171,282.58   2015-09-01 2015-09-30 0    
Havering_201510.csv 9,191,223.11 4616 0 1,991.17 0.0 171,282.58   2015-10-01 2015-10-30 0    
Havering_201511.csv 10,133,921.15 5749 0 1,762.73 0.0 190,835.00   2015-11-01 2015-11-30 0    
Havering_201512.csv 9,460,273.52 5110 0 1,851.33 0.0 195,751.52   2015-12-01 2015-12-31 0    
Havering_201601.csv 8,921,586.75 4991 0 1,787.53 0.0 722,514.06   2015-03-04 2016-01-29 10    
Havering_201602.csv 10,481,851.66 6229 0 1,682.75 0.0 220,220.46   2015-02-02 2016-02-29 12    
Havering_201603.csv 21,756,108.62 7403 0 2,938.82 0.0 488,000.00   2015-01-09 2016-03-31 14     Jump in Total Amt. Analysis
Havering_201604.csv 24,385,352.63 5892 0 4,138.72 0.0 369,531.00   2014-06-03 2016-04-30 22    
Havering_201605.csv 20,244,545.09 6516 0 3,106.90 0.0 369,531.00   2015-11-09 2016-05-31 6    
Havering_201606.csv 21,495,203.65 6727 0 3,195.36 0.0 1,724,610.49   2015-03-03 2016-06-30 15    
Havering_201607.csv 18,449,500.73 5370 0 3,435.66 0.0 371,293.00   2016-06-09 2016-07-29 1    
Havering_201608.csv 10,966,625.66 5262 0 2,084.12 0.0 700,000.00   2016-06-24 2016-08-31 2    
Havering_201609.csv 10,525,918.73 5274 0 1,995.81 0.0 277,000.00   2016-07-04 2016-09-30 2    
Havering_201610.csv 18,899,270.33 6010 0 3,144.64 0.0 370,677.00   2016-09-01 2016-10-31 1    
Havering_201611.csv 10,705,047.66 5778 0 1,852.73 0.0 224,898.00   2016-09-09 2016-11-30 2    
Havering_201612.csv 10,040,735.71 6017 0 1,668.73 0.0 202,888.65   2016-01-07 2016-12-30 11    
Havering_201701.csv 9,396,388.70 5923 0 1,586.42 0.0 228,249.73   2016-01-07 2017-01-31 12    
Havering_201702.csv 18,891,501.74 5575 0 3,388.61 0.0 797,435.11   2016-11-08 2017-02-28 3     Jump in Total Amt. Analysis
Havering_201703.csv 19,563,297.47 6576 0 2,974.95 0.0 385,927.00   2016-12-08 2017-03-31 3    
Havering_201704.csv 10,176,999.77 5139 0 1,980.35 0.0 253,610.82   2017-03-04 2017-04-30 1    
Havering_201705.csv 18,481,015.02 5629 0 3,283.18 0.0 912,608.00   2017-04-02 2017-05-31 1    
Havering_201706.csv 9,751,500.90 5148 0 1,894.23 0.0 251,225.10   2017-05-03 2017-06-28 1    
Havering_201707.csv 9,893,186.42 5387 0 1,836.49 0.0 223,311.20   2017-06-02 2017-07-31 1    
Havering_201708.csv 9,617,392.47 5184 0 1,855.21 0.0 195,397.30   2017-07-02 2017-08-31 1    
Havering_201709.csv 11,391,018.21 6391 1229 1,782.35 0.0 868,456.36   2017-09-01 2017-09-01 0    
Havering_201710.csv 10,314,715.11 6108 1261 1,688.72 0.0 835,411.29   2017-09-01 2017-10-01 1    
Havering_201711.csv 9,248,169.45 5366 1317 1,723.48 0.0 828,590.83   2017-10-01 2017-11-01 1    
Havering_201712.csv 8,706,750.81 4886 1130 1,781.98 0.0 824,767.03   2017-12-01 2017-12-01 0    
Havering_201801.csv 11,010,082.45 5864 1358 1,877.57 0.0 824,749.27   2017-12-01 2018-01-01 1    
Havering_201802.csv 9,913,651.08 5274 1274 1,879.72 0.0 826,105.93   2018-01-01 2018-02-01 1    
Havering_201803.csv 11,200,129.95 5456 1322 2,052.81 0.0 812,908.61   2018-01-01 2018-03-01 2    
Havering_201804.csv 9,513,494.48 4846 1146 1,963.16 0.0 535,974.28   2018-02-01 2018-04-01 2    
Havering_201805.csv 9,608,925.54 5238 1456 1,834.46 0.0 787,127.42   2018-02-01 2018-05-01 3    
Havering_201806.csv 9,860,695.16 6176 1309 1,596.62 0.0 775,219.51   2018-04-01 2018-06-01 2    
Havering_201807.csv 12,650,431.32 5341 1238 2,368.55 0.0 1,497,763.52   2018-06-01 2018-07-01 1    
Havering_201808.csv 12,651,607.40 6149 1265 2,057.51 0.0 508,667.93   2018-06-01 2018-08-01 2    
Havering_201809.csv 12,109,370.54 6590 1410 1,837.54 0.0 857,236.26   2018-06-01 2018-09-01 3    
Havering_201810.csv 11,639,534.66 5644 1329 2,062.28 0.0 911,652.06   2018-02-01 2018-10-01 8    
Havering_201811.csv 11,552,633.48 9116 3852 1,267.29 0.0 744,135.22   2014-07-01 2018-11-01 52    
Havering_201812.csv 10,605,039.54 5559 1428 1,907.72 0.0 723,032.17   2016-02-01 2018-12-01 34    
Havering_201901.csv 9,524,611.62 5621 1604 1,694.47 0.0 703,075.36   2018-05-01 2019-01-01 8    
Havering_201902.csv 9,911,333.18 5225 1450 1,896.91 0.0 699,859.36   2017-05-01 2019-02-01 21    
Havering_201903.csv 12,336,829.34 7144 2376 1,726.88 0.0 696,099.87   2015-04-01 2019-03-01 47    
Havering_201904.csv 10,751,352.16 5443 1460 1,975.26 0.0 698,566.00   2018-04-01 2019-04-01 12    
Havering_201905.csv 10,771,533.24 6634 1449 1,623.69 0.0 692,865.78   2019-03-01 2019-05-01 2    
Havering_201906.csv 10,285,300.03 5351 1499 1,922.13 0.0 759,407.39   2019-03-01 2019-06-01 3    
Havering_201907.csv 10,416,383.27 5529 1427 1,883.95 0.0 749,574.65   2015-12-01 2019-07-01 43    
Havering_201908.csv 11,305,859.83 6064 1349 1,864.42 0.0 720,818.21   2017-05-01 2019-08-01 27    
Havering_201909.csv 14,532,680.13 6247 1276 2,326.35 0.0 967,004.73   2019-07-01 2019-09-01 2    
Havering_201910.csv 14,857,786.15 6837 1969 2,173.14 0.0 2,890,676.67   2017-02-01 2019-10-01 32    
Havering_201911.csv 11,695,497.76 6149 1418 1,902.02 0.0 717,740.94   2017-08-01 2019-11-01 27    

Totals: £2,175,282,476.18 from 605,261 original records (485,614 actual records) in 107 source files. Tot AvgAmt = £391,434.00

Averages: Amount/file: £20,329,742.77    Orig Records/file: 5,657    AvgAmt mean: 3,658.26    AvgAmt Std Dev: 0.00

LA Range: 2011/01 - 2019/11

The link on Sourcefile name will transfer to a new page to display all the records for that file.
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.
AAZ shows the number of standard deviations from the mean for the AvgAmt. Greater than ± 1.1 could suggest an unusual value. Now deprecated.
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. Dif shows the difference in months.
Comment highlights significant potential anomalies - large increases/decreases in Total Amt or high AAZ scores.
Analysis compares two files to identify possible factors relating to the anomaly. Opens in new window. NB under development.

Spend details and charts


Acknowledgement: Spend data from Havering has been re-used under the Open Government Licence.