Summary of currently loaded LA spend data for : Bexley

Lastfile: Bexley_202001     LA spend page opens in new window
Sourcefile name Total Amount £ OrigRecs AggRecs AvgAmt£ AAZ   MaxAmt £     MinDate MaxDate Dif     Comment
Bexley_201101.csv 19,830,886.59 2923 0 6,784.43 0.0 2,225,635.46   2011-01-04 2011-01-31 0    
Bexley_201102.csv 22,629,627.39 3022 0 7,488.29 0.0 2,422,118.13   2011-01-26 2011-03-14 2    
Bexley_201103.csv 35,119,421.50 4139 0 8,485.00 0.0 2,143,845.14   2011-03-01 2011-04-04 1    
Bexley_201104.csv 22,914,675.53 2541 0 9,017.98 0.0 2,187,256.10   2011-03-24 2011-04-28 1    
Bexley_201105.csv 19,391,934.00 3082 0 6,292.00 0.0 2,187,256.08   2011-05-01 2011-05-31 0    
Bexley_201106.csv 21,767,780.62 3748 0 5,807.84 0.0 2,187,256.08   2011-05-31 2011-06-30 1    
Bexley_201107.csv 21,316,817.14 3106 0 6,863.11 0.0 1,465,623.44   2011-06-15 2011-07-29 1    
Bexley_201108.csv 29,956,308.13 4634 0 6,464.46 0.0 2,187,256.08   2011-07-29 2011-08-31 1    
Bexley_201109.csv 22,445,367.03 3140 0 7,148.21 0.0 2,187,256.08   2011-09-01 2011-09-30 0    
Bexley_201110.csv 21,238,097.42 3232 0 6,571.19 0.0 2,187,256.08   2011-10-03 2011-10-31 0    
Bexley_201111.csv 20,371,485.14 3404 0 5,984.57 0.0 2,187,256.08   2011-10-31 2011-11-30 1    
Bexley_201112.csv 27,269,935.36 3537 0 7,709.91 0.0 2,187,256.08   2011-12-01 2011-12-30 0    
Bexley_201201.csv 18,656,366.42 3233 0 5,770.61 0.0 1,124,233.94   2012-01-03 2012-01-31 0    
Bexley_201202.csv 21,734,726.42 3636 0 5,977.65 0.0 2,187,256.08   2012-02-01 2012-02-29 0    
Bexley_201203.csv 25,246,082.74 4241 0 5,952.86 0.0 2,187,256.08   2012-03-01 2012-03-30 0    
Bexley_201204.csv 14,259,805.05 2479 0 5,752.24 0.0 2,162,503.80   2012-03-30 2012-04-30 1    
Bexley_201205.csv 20,223,769.90 4578 0 4,417.60 0.0 2,162,503.80   2012-04-16 2012-05-31 1    
Bexley_201206.csv 20,537,751.60 4174 0 4,920.40 0.0 1,148,378.33   2012-05-11 2012-06-30 1    
Bexley_201207.csv 18,336,684.49 3860 0 4,750.44 0.0 2,162,503.80   2012-07-01 2012-07-31 0    
Bexley_201208.csv 25,147,391.92 4335 0 5,801.01 0.0 2,162,503.80   2012-07-31 2012-08-31 1    
Bexley_201209.csv 20,769,546.93 3959 0 5,246.16 0.0 2,162,503.80   2012-09-03 2012-09-28 0    
Bexley_201210.csv 28,989,043.80 5356 0 5,412.44 0.0 2,896,032.75   2012-09-25 2012-10-31 1    
Bexley_201211.csv 16,171,231.55 4148 0 3,898.56 0.0 2,162,503.80   2012-10-31 2012-11-30 1    
Bexley_201212.csv 23,972,507.95 4347 0 5,514.72 0.0 2,162,503.80   2012-11-30 2012-12-31 1    
Bexley_201301.csv 15,575,188.79 4693 0 3,318.81 0.0 608,322.63   2013-01-02 2013-01-31 0    
Bexley_201302.csv 16,772,215.58 4104 0 4,086.80 0.0 2,162,503.80   2013-01-30 2013-02-28 1    
Bexley_201303.csv 23,813,989.12 5116 0 4,654.81 0.0 2,162,503.80   2013-02-28 2013-03-28 1    
Bexley_201304.csv 20,230,005.50 4045 0 5,001.24 0.0 1,850,724.00   2013-04-02 2013-05-12 1    
Bexley_201305.csv 21,238,625.16 4829 0 4,398.14 0.0 1,850,724.00   2013-05-01 2013-05-31 0    
Bexley_201306.csv 22,522,013.00 4499 0 5,006.00 0.0 1,601,959.51   2013-05-17 2013-06-28 1    
Bexley_201307.csv 23,302,241.54 4749 0 4,906.77 0.0 1,982,973.45   2013-06-27 2013-07-31 1    
Bexley_201308.csv 27,150,430.23 4715 0 5,758.31 0.0 2,701,978.69   2013-08-01 2013-08-30 0    
Bexley_201309.csv 29,545,218.34 4079 0 7,243.25 0.0 2,645,404.43   2013-09-02 2013-09-30 0    
Bexley_201310.csv 26,297,649.55 6827 0 3,852.01 0.0 1,970,980.14   2013-10-01 2013-10-31 0    
Bexley_201311.csv 22,493,778.53 5130 0 4,384.75 0.0 2,604,262.44   2013-10-21 2013-11-29 1    
Bexley_201312.csv 36,143,050.42 5239 0 6,898.85 0.0 2,087,109.78   2013-10-11 2013-12-31 2    
Bexley_201401.csv 21,177,867.56 4329 0 4,892.09 0.0 1,850,724.00   2014-01-02 2014-01-31 0    
Bexley_201402.csv 21,442,462.41 5031 0 4,262.07 0.0 1,986,300.35   2014-01-31 2014-02-28 1    
Bexley_201403.csv 29,556,511.51 5736 0 5,152.81 0.0 1,850,724.00   2014-02-28 2014-03-31 1    
Bexley_201404.csv 22,176,367.85 4668 0 4,750.72 0.0 1,909,464.83   2014-04-01 2014-04-30 0    
Bexley_201405.csv 26,811,324.94 4637 0 5,782.04 0.0 1,909,464.83   2014-05-01 2014-05-30 0    
Bexley_201406.csv 21,297,923.14 4655 0 4,575.28 0.0 1,215,929.17   2014-06-02 2014-06-30 0    
Bexley_201407.csv 23,189,036.41 5906 0 3,926.35 0.0 1,909,464.83   2014-07-01 2014-07-31 0    
Bexley_201408.csv 24,795,197.14 4720 0 5,253.22 0.0 1,909,464.83   2014-07-31 2014-08-29 1    
Bexley_201409.csv 22,894,055.13 5381 0 4,254.61 0.0 1,909,464.83   2014-08-28 2014-09-30 1    
Bexley_201410.csv 21,607,966.90 5222 0 4,137.87 0.0 1,909,464.83   2014-10-01 2014-10-31 0    
Bexley_201411.csv 21,308,430.59 4706 0 4,527.93 0.0 2,291,357.80   2014-11-03 2014-11-28 0    
Bexley_201412.csv 28,588,184.87 5511 0 5,187.48 0.0 1,459,115.00   2014-10-31 2014-12-31 2    
Bexley_201501.csv 15,424,892.33 4850 0 3,180.39 0.0 1,008,740.00   2014-10-21 2015-01-30 3    
Bexley_201502.csv 20,655,549.80 4853 0 4,256.24 0.0 2,291,357.80   2015-02-02 2015-02-27 0    
Bexley_201503.csv 28,865,323.36 6273 0 4,601.52 0.0 2,291,357.80   2015-03-02 2015-03-31 0    
Bexley_201504.csv 23,647,148.04 4515 0 5,237.46 0.0 2,306,618.95   2015-04-01 2015-04-30 0    
Bexley_201505.csv 22,211,845.59 4553 0 4,878.51 0.0 2,306,618.99   2015-05-01 2015-05-29 0    
Bexley_201506.csv 24,146,386.01 4583 0 5,268.69 0.0 2,306,618.99   2015-06-01 2015-06-30 0    
Bexley_201507.csv 25,169,360.25 5550 0 4,535.02 0.0 1,221,948.00   2015-07-01 2015-07-31 0    
Bexley_201508.csv 26,340,897.92 5783 0 4,554.88 0.0 2,306,618.99   2015-08-03 2015-08-28 0    
Bexley_201509.csv 24,391,275.80 4635 0 5,262.41 0.0 2,306,618.99   2015-09-01 2015-09-30 0    
Bexley_201510.csv 24,988,693.63 5604 0 4,459.08 0.0 2,306,618.99   2015-07-14 2015-10-31 3    
Bexley_201511.csv 22,753,362.01 4915 0 4,629.37 0.0 2,306,618.99   2015-11-02 2015-11-30 0    
Bexley_201512.csv 31,741,806.56 5168 0 6,141.99 0.0 2,306,618.99   2015-12-01 2015-12-31 0    
Bexley_201601-03.csv 67,530,655.02 17432 0 3,873.95 0.0 2,306,618.99   2015-03-30 2016-03-31 12     Jump in Total Amt. Analysis
Bexley_201604.csv 27,898,029.08 5027 0 5,549.64 0.0 2,199,616.83   2016-04-01 2016-04-29 0    
Bexley_201605.csv 21,404,254.87 4378 0 4,889.05 0.0 2,199,616.88   2016-05-03 2016-05-31 0    
Bexley_201606.csv 27,949,818.52 5914 0 4,726.04 0.0 2,962,437.96   2016-04-01 2016-06-30 2    
Bexley_201607.csv 28,291,469.88 5891 0 4,802.49 0.0 2,199,616.88   2016-07-01 2016-07-29 0    
Bexley_201608.csv 22,723,664.95 5145 0 4,416.65 0.0 2,199,616.88   2016-08-01 2016-08-31 0    
Bexley_201609.csv 25,205,900.71 4749 0 5,307.62 0.0 2,199,616.88   2016-09-01 2016-09-30 0    
Bexley_201610.csv 19,158,593.13 4844 0 3,955.12 0.0 2,199,616.88   2016-10-03 2016-10-31 0    
Bexley_201611.csv 24,329,894.18 7374 0 3,299.42 0.0 2,199,616.88   2016-03-30 2016-11-30 8    
Bexley_201612.csv 28,733,063.48 5105 0 5,628.42 0.0 2,199,616.88   2016-04-04 2016-12-30 8    
Bexley_201701.csv 18,756,671.25 4505 0 4,163.52 0.0 1,119,875.00   2017-01-03 2017-01-31 0    
Bexley_201702.csv 21,565,566.73 4791 0 4,501.27 0.0 2,199,616.88   2017-02-01 2017-02-28 0    
Bexley_201703.csv 27,493,197.81 6357 0 4,324.87 0.0 2,199,616.88   2016-03-31 2017-04-03 13    
Bexley_201704.csv 27,994,314.40 4706 0 5,948.64 0.0 2,438,382.00   2017-04-03 2017-04-28 0    
Bexley_201705.csv 26,002,075.37 5554 0 4,681.68 0.0 2,438,382.00   2017-05-02 2017-05-31 0    
Bexley_201706.csv 31,083,172.74 5761 0 5,395.45 0.0 3,041,270.08   2017-06-01 2017-06-30 0    
Bexley_201707.csv 23,417,715.44 5323 0 4,399.35 0.0 2,438,382.00   2017-07-03 2017-07-31 0    
Bexley_201708.csv 29,617,455.34 5491 0 5,393.82 0.0 2,244,938.26   2017-08-01 2017-08-31 0    
Bexley_201709.csv 24,927,039.25 4533 709 5,499.02 0.0 4,581,432.26   2017-09-01 2017-09-01 0    
Bexley_201710.csv 25,257,555.33 5228 870 4,831.21 0.0 4,581,432.26   2017-10-01 2017-10-01 0    
Bexley_201711.csv 26,095,071.07 5397 888 4,835.11 0.0 4,581,432.26   2017-11-01 2017-11-01 0    
Bexley_201712.csv 30,757,990.16 5177 874 5,941.28 0.0 2,336,494.00   2017-12-01 2017-12-01 0    
Bexley_201801.csv 23,724,581.34 4928 798 4,814.24 0.0 4,581,432.26   2018-01-01 2018-01-01 0    
Bexley_201802.csv 26,438,772.33 5178 841 5,105.98 0.0 4,581,432.26   2018-02-01 2018-02-01 0    
Bexley_201803.csv 26,324,721.38 5260 885 5,004.70 0.0 4,581,439.88   2018-03-01 2018-03-01 0    
Bexley_201804.csv 29,217,171.27 5351 849 5,460.13 0.0 4,550,308.11   2018-04-01 2018-04-01 0    
Bexley_201805.csv 26,816,351.39 5327 872 5,034.04 0.0 4,550,308.10   2018-04-01 2018-05-01 1    
Bexley_201806.csv 34,669,847.50 5668 866 6,116.77 0.0 2,474,993.91   2018-06-01 2018-06-01 0    
Bexley_201807.csv 4,286,287.24 569 212 7,533.02 0.0 468,962.55   2018-07-01 2018-07-01 0     Large drop in Total Amt. Analysis
Bexley_201808.csv 27,356,404.17 5542 919 4,936.20 0.0 4,334,514.10   2018-08-01 2018-08-01 0     Large jump in Total Amt. Analysis
Bexley_201809.csv 25,601,356.40 4760 681 5,378.44 0.0 4,334,514.10   2018-09-01 2018-09-01 0    
Bexley_201810.csv 25,789,303.85 5204 809 4,955.67 0.0 4,334,514.10   2018-10-01 2018-10-01 0    
Bexley_201811.csv 28,544,229.70 5235 889 5,452.57 0.0 4,334,514.10   2018-11-01 2018-11-01 0    
Bexley_201812.csv 32,195,657.51 5237 815 6,147.73 0.0 4,334,514.10   2018-12-01 2018-12-01 0    
Bexley_201901.csv 22,129,686.64 4891 858 4,524.57 0.0 1,896,799.00   2019-01-01 2019-01-01 0    
Bexley_201902.csv 25,260,281.19 4943 791 5,110.31 0.0 4,334,514.10   2019-02-01 2019-02-01 0    
Bexley_201903.csv 33,100,976.30 5048 912 6,557.25 0.0 4,334,510.10   2019-03-01 2019-03-01 0    
Bexley_201904.csv 29,481,528.84 11659 860 2,528.65 0.0 2,626,291.00   2019-04-01 2019-04-01 0    
Bexley_201905.csv 26,663,356.49 4858 794 5,488.55 0.0 2,626,290.99   2019-05-01 2019-05-01 0    
Bexley_201906.csv 35,583,544.57 5191 798 6,854.85 0.0 2,626,290.99   2019-06-01 2019-06-01 0    
Bexley_201907.csv 28,636,207.00 6969 878 4,109.08 0.0 3,402,203.16   2019-07-01 2019-07-01 0    
Bexley_201908.csv 29,500,681.10 5181 860 5,694.01 0.0 2,626,290.99   2019-08-01 2019-08-01 0    
Bexley_201909.csv 30,801,984.47 5272 812 5,842.56 0.0 2,626,290.99   2019-09-01 2019-09-01 0    
Bexley_201910.csv 29,491,335.07 5380 895 5,481.66 0.0 2,626,290.99   2019-10-01 2019-10-01 0    
Bexley_201911.csv 28,044,750.55 5223 923 5,369.47 0.0 2,626,290.99   2019-11-01 2019-11-01 0    
Bexley_201912.csv 34,418,196.58 5435 859 6,332.69 0.0 2,643,733.05   2019-12-01 2019-12-01 0    
Bexley_202001.csv 22,724,574.98 5025 746 4,522.30 0.0 2,626,290.99   2020-01-01 2020-01-01 0    

Totals: £2,691,558,476.70 from 530,679 original records (400,773 actual records) in 107 source files. Tot AvgAmt = £561,968.51

Averages: Amount/file: £25,154,752.12    Orig Records/file: 4,960    AvgAmt mean: 5,252.04    AvgAmt Std Dev: 0.00

LA Range: 2011/01 - 2020/01

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 Bexley has been re-used under the Open Government Licence.