Summary of currently loaded LA spend data for : Barnet

Lastfile: Barnet_201911
Sourcefile name Total Amount £ OrigRecs AggRecs AvgAmt£ AAZ   MaxAmt £     MinDate MaxDate Dif     Comment
Barnet_201101.csv 24,682,764.27 4277 0 5,771.05 0.0 1,886,000.00   2011-01-01 2011-02-02 1    
Barnet_201102.csv 33,276,339.01 4562 0 7,294.24 0.0 5,935,000.00   2011-02-01 2011-03-01 1    
Barnet_201103.csv 42,532,064.72 6178 0 6,884.44 0.0 4,313,959.97   2011-03-01 2011-04-04 1    
Barnet_201104.csv 24,856,639.43 3548 0 7,005.82 0.0 4,326,853.21   2011-03-30 2011-04-28 1    
Barnet_201105.csv 26,666,245.28 5038 0 5,293.02 0.0 4,326,853.21   2011-05-01 2011-06-01 1    
Barnet_201106.csv 28,300,412.32 4802 0 5,893.46 0.0 4,326,853.21   2011-06-01 2011-07-01 1    
Barnet_201107.csv 22,760,258.00 4997 0 4,554.78 0.0 953,225.83   2011-07-01 2011-08-01 1    
Barnet_201108.csv 21,694,697.14 4811 0 4,509.39 0.0 1,900,000.00   2011-08-01 2011-08-31 0    
Barnet_201109.csv 28,793,697.82 4827 0 5,965.13 0.0 4,326,853.21   2011-09-01 2011-09-30 0    
Barnet_201110.csv 24,544,224.20 4135 0 5,935.73 0.0 4,326,853.21   2011-10-01 2011-11-01 1    
Barnet_201111.csv 25,904,349.73 4499 0 5,757.80 0.0 4,326,853.21   2011-11-01 2011-11-30 0    
Barnet_201112.csv 29,104,086.65 3977 0 7,318.10 0.0 4,326,853.21   2011-12-01 2011-12-30 0    
Barnet_201201.csv 25,224,423.15 5447 0 4,630.88 0.0 953,225.83   2012-01-03 2012-02-01 1    
Barnet_201202.csv 30,831,986.09 4121 0 7,481.68 0.0 4,326,853.21   2012-02-01 2012-03-01 1    
Barnet_201203.csv 33,248,904.90 5946 0 5,591.81 0.0 4,326,853.21   2012-03-01 2012-04-03 1    
Barnet_201204.csv 25,554,793.23 3351 0 7,626.02 0.0 4,391,555.58   2012-04-01 2012-05-01 1    
Barnet_201205.csv 28,015,062.73 3724 0 7,522.84 0.0 4,391,555.62   2012-05-01 2012-06-01 1    
Barnet_201206.csv 29,094,785.94 3889 0 7,481.30 0.0 4,391,555.62   2012-06-01 2012-07-02 1    
Barnet_201207.csv 24,672,147.47 5068 0 4,868.22 0.0 1,000,000.00   2012-07-02 2012-08-01 1    
Barnet_201208.csv 31,897,348.70 4861 0 6,561.89 0.0 4,391,555.62   2012-08-01 2012-09-03 1    
Barnet_201209.csv 25,588,429.17 3840 0 6,663.65 0.0 4,391,555.62   2012-09-03 2012-10-01 1    
Barnet_201210.csv 29,614,275.87 4400 0 6,730.52 0.0 4,391,555.62   2012-10-01 2012-10-31 0    
Barnet_201211.csv 31,594,810.68 4952 0 6,380.21 0.0 4,391,555.62   2012-11-01 2012-12-03 1    
Barnet_201212.csv 30,412,774.86 4268 0 7,125.77 0.0 4,391,555.62   2012-12-03 2012-12-31 0    
Barnet_201301.csv 31,258,706.62 4532 0 6,897.33 0.0 4,391,555.62   2013-01-02 2013-02-01 1    
Barnet_201302.csv 31,311,179.08 5133 0 6,099.98 0.0 3,500,000.00   2013-02-01 2013-03-01 1    
Barnet_201303.csv 39,766,871.02 5638 0 7,053.36 0.0 4,391,555.62   2013-03-01 2013-04-02 1    
Barnet_201304.csv 31,299,763.60 4227 0 7,404.72 0.0 3,796,408.20   2013-04-02 2013-05-01 1    
Barnet_201305.csv 46,616,651.99 4663 0 9,997.14 0.0 6,803,028.40   2013-05-01 2013-06-03 1    
Barnet_201306.csv 32,633,660.94 3501 0 9,321.24 0.0 3,796,408.20   2013-06-03 2013-06-28 0    
Barnet_201307.csv 51,662,537.79 5530 0 9,342.23 0.0 14,739,960.00   2013-07-01 2013-08-01 1    
Barnet_201308.csv 43,728,943.06 3217 0 13,593.08 0.0 4,620,000.00   2013-08-01 2013-08-30 0    
Barnet_201309.csv 39,252,006.14 4028 0 9,744.79 0.0 3,796,408.20   2013-09-02 2013-09-30 0    
Barnet_201310.csv 41,435,630.47 4137 0 10,015.86 0.0 5,177,323.95   2013-10-01 2013-10-31 0    
Barnet_201311.csv 36,527,043.15 3673 0 9,944.74 0.0 3,796,408.20   2013-11-01 2013-11-29 0    
Barnet_201312.csv 49,611,132.42 3348 0 14,818.14 0.0 6,887,092.63   2013-12-02 2013-12-24 0    
Barnet_201401.csv 48,239,383.80 4280 0 11,270.88 0.0 5,881,402.00   2014-01-02 2014-01-31 0    
Barnet_201402.csv 31,463,457.58 4649 0 6,767.79 0.0 3,517,932.00   2014-02-03 2014-02-28 0    
Barnet_201403.csv 40,052,673.07 4654 0 8,606.08 0.0 6,887,092.63   2014-03-03 2014-03-31 0    
Barnet_201404.csv 30,878,581.44 1923 0 16,057.50 0.0 4,390,443.92   2014-04-04 2014-04-30 0    
Barnet_201405.csv 35,686,139.11 2101 0 16,985.31 0.0 4,390,443.92   2014-05-01 2014-05-30 0    
Barnet_201406.csv 45,847,919.05 2712 0 16,905.57 0.0 5,757,255.04   2014-06-02 2014-06-30 0    
Barnet_201407.csv 35,505,850.05 2707 0 13,116.31 0.0 4,388,866.42   2014-07-01 2014-07-31 0    
Barnet_201408.csv 43,230,651.28 2386 0 18,118.46 0.0 7,167,500.00   2014-08-01 2014-08-29 0    
Barnet_201409.csv 46,325,654.66 3377 0 13,717.99 0.0 5,896,708.00   2014-09-01 2014-09-30 0    
Barnet_201410.csv 39,483,764.67 3483 0 11,336.14 0.0 3,841,043.70   2014-10-01 2014-10-31 0    
Barnet_201411.csv 30,744,371.23 2841 0 10,821.67 0.0 3,841,043.70   2014-11-03 2014-11-28 0    
Barnet_201412.csv 64,709,391.74 4166 0 15,532.74 0.0 9,624,708.04   2014-12-01 2014-12-30 0     Jump in Total Amt. Analysis
Barnet_201501.csv 28,341,461.56 3293 0 8,606.58 0.0 5,140,443.92   2015-01-05 2015-01-30 0    
Barnet_201502.csv 31,924,417.34 2874 0 11,108.01 0.0 4,000,690.73   2015-02-02 2015-02-27 0    
Barnet_201503.csv 43,935,523.57 4613 0 9,524.28 0.0 3,841,043.70   2015-03-02 2015-03-31 0    
Barnet_201504.csv 34,697,405.65 2979 0 11,647.33 0.0 4,004,237.40   2015-04-01 2015-04-30 0    
Barnet_201505.csv 29,173,697.15 2443 0 11,941.75 0.0 4,004,237.40   2015-05-01 2015-05-29 0    
Barnet_201506.csv 59,686,155.51 4034 0 14,795.77 0.0 6,612,754.00   2015-06-01 2015-06-30 0     Jump in Total Amt. Analysis
Barnet_201507.csv 40,431,573.87 6563 0 6,160.53 0.0 4,004,237.40   2015-07-01 2015-07-31 0    
Barnet_201508.csv 30,159,207.23 4021 0 7,500.42 0.0 3,754,156.00   2015-08-03 2015-08-28 0    
Barnet_201509.csv 58,274,936.16 4772 0 12,211.85 0.0 6,612,754.00   2015-09-01 2015-09-30 0    
Barnet_201510.csv 48,868,606.91 5867 0 8,329.40 0.0 7,167,500.00   2015-10-01 2015-10-30 0    
Barnet_201511.csv 38,777,839.40 4961 0 7,816.54 0.0 4,004,237.40   2015-11-02 2015-11-30 0    
Barnet_201512.csv 47,747,986.90 5238 0 9,115.69 0.0 10,115,342.00   2015-12-01 2015-12-29 0    
Barnet_201601.csv 36,945,305.78 5177 0 7,136.43 0.0 2,087,943.92   2016-01-05 2016-01-29 0    
Barnet_201602.csv 48,510,936.61 5266 0 9,212.10 0.0 4,004,237.40   2016-02-01 2016-02-29 0    
Barnet_201603.csv 44,736,219.84 5709 0 7,836.09 0.0 5,000,000.00   2016-03-01 2016-03-31 0    
Barnet_201604.csv 49,717,835.17 4551 0 10,924.60 0.0 4,027,293.00   2016-04-01 2016-04-29 0    
Barnet_201605.csv 39,926,801.20 3992 0 10,001.70 0.0 3,891,785.34   2016-05-03 2016-05-31 0    
Barnet_201606.csv 55,612,957.99 4211 0 13,206.59 0.0 7,879,241.83   2016-06-01 2016-06-30 0    
Barnet_201607.csv 29,917,341.67 4473 0 6,688.43 0.0 1,711,467.00   2016-07-01 2016-07-29 0    
Barnet_201608.csv 40,560,496.94 4533 0 8,947.83 0.0 3,891,785.34   2016-08-01 2016-08-31 0    
Barnet_201609.csv 49,185,011.79 4382 0 11,224.33 0.0 6,344,127.00   2016-09-01 2016-09-30 0    
Barnet_201610.csv 47,061,987.55 4341 0 10,841.28 0.0 5,689,184.00   2016-10-03 2016-10-31 0    
Barnet_201611.csv 40,500,546.61 4542 0 8,916.90 0.0 3,891,785.34   2016-11-01 2016-11-30 0    
Barnet_201612.csv 104,714,948.57 4439 0 23,589.76 0.0 19,089,468.93   2016-12-01 2016-12-28 0     Jump in Total Amt. Analysis
Barnet_201701.csv 37,403,316.86 4375 0 8,549.33 0.0 3,891,785.34   2017-01-03 2017-01-31 0     Drop in Total Amt. Analysis
Barnet_201702.csv 49,138,954.81 4212 0 11,666.42 0.0 6,000,000.00   2017-02-01 2017-02-28 0    
Barnet_201703.csv 53,135,827.29 6424 0 8,271.46 0.0 4,047,341.00   2017-03-01 2017-03-31 0    
Barnet_201704.csv 31,597,915.96 3701 0 8,537.67 0.0 4,014,752.67   2017-04-03 2017-04-28 0    
Barnet_201705.csv 58,494,805.32 5069 0 11,539.71 0.0 5,000,000.00   2017-05-02 2017-05-31 0    
Barnet_201706.csv 70,683,015.29 6382 1070 11,075.37 0.0 15,921,337.00   2017-06-01 2017-06-01 0    
Barnet_201707.csv 35,265,356.42 9652 1253 3,653.68 0.0 4,091,347.82   2017-07-01 2017-07-01 0    
Barnet_201708.csv 46,179,850.49 9005 1043 5,128.25 0.0 7,727,402.25   2017-08-01 2017-08-01 0    
Barnet_201709.csv 43,123,913.78 11930 1196 3,614.75 0.0 4,014,752.61   2017-08-01 2017-09-01 1    
Barnet_201710.csv 59,543,617.94 12466 1196 4,776.48 0.0 7,933,333.34   2017-10-01 2017-10-01 0    
Barnet_201711.csv 47,779,784.86 14613 1207 3,269.68 0.0 7,727,402.25   2017-11-01 2017-11-01 0    
Barnet_201712.csv 48,180,931.84 11763 1312 4,095.97 0.0 7,727,402.25   2017-12-01 2017-12-01 0    
Barnet_201801.csv 48,388,524.58 10581 1303 4,573.15 0.0 7,265,840.59   2018-01-01 2018-01-01 0    
Barnet_201802.csv 39,127,195.43 11544 1052 3,389.40 0.0 3,712,649.64   2018-02-01 2018-02-01 0    
Barnet_201803.csv 58,909,112.27 13499 1443 4,363.96 0.0 7,727,400.20   2018-01-01 2018-03-01 2    
Barnet_201804.csv 66,598,200.70 10468 1167 6,362.07 0.0 13,894,546.36   2018-04-01 2018-04-01 0    
Barnet_201805.csv 47,136,999.84 11235 1320 4,195.55 0.0 8,420,188.80   2018-05-01 2018-05-01 0    
Barnet_201806.csv 49,566,284.79 10567 1030 4,690.67 0.0 8,276,474.81   2018-06-01 2018-06-01 0    
Barnet_201807.csv 58,281,766.21 12740 1397 4,574.71 0.0 5,929,152.82   2018-07-01 2018-07-01 0    
Barnet_201808.csv 60,462,771.37 13310 1182 4,542.66 0.0 9,633,424.30   2018-08-01 2018-08-01 0    
Barnet_201809.csv 43,117,494.29 9876 1085 4,365.89 0.0 7,968,563.29   2017-11-01 2018-09-01 10    
Barnet_201810.csv 74,852,781.24 14192 1273 5,274.29 0.0 13,279,363.33   2018-10-01 2018-10-01 0    
Barnet_201811.csv 49,218,403.54 13126 1314 3,749.69 0.0 4,648,981.80   2018-11-01 2018-11-01 0    
Barnet_201812.csv 66,174,482.04 9245 1244 7,157.87 0.0 13,031,950.83   2018-12-01 2018-12-01 0    
Barnet_201901.csv 65,543,727.93 12216 1524 5,365.40 0.0 7,514,583.00   2019-01-01 2019-01-01 0    
Barnet_201902.csv 48,710,905.80 9747 1335 4,997.53 0.0 5,143,585.89   2019-02-01 2019-02-01 0    
Barnet_201903.csv 79,124,963.33 12988 1526 6,092.16 0.0 8,159,092.05   2019-03-01 2019-03-01 0    
Barnet_201904.csv 47,824,697.68 10042 1291 4,762.47 0.0 9,000,000.00   2019-04-01 2019-04-01 0    
Barnet_201905.csv 67,975,267.25 13581 1360 5,005.17 0.0 6,603,100.56   2019-04-01 2019-05-01 1    
Barnet_201906.csv 60,327,042.03 13127 1283 4,595.65 0.0 8,548,839.82   2019-06-01 2019-06-01 0    
Barnet_201907.csv 63,784,713.70 11762 1345 5,422.95 0.0 8,521,225.14   2019-06-01 2019-07-01 1    
Barnet_201908.csv 51,746,523.83 9658 1462 5,357.89 0.0 6,185,283.56   2019-08-01 2019-08-01 0    
Barnet_201909.csv 64,870,001.16 12248 1227 5,296.38 0.0 7,743,625.85   2019-09-01 2019-09-01 0    
Barnet_201910.csv 50,779,263.31 11645 1291 4,360.61 0.0 6,640,931.56   2019-10-01 2019-10-01 0    
Barnet_201911.csv 53,734,549.89 10864 1350 4,946.11 0.0 9,642,000.00   2019-11-01 2019-11-01 0    

Totals: £4,622,329,649.36 from 675,551 original records (369,560 actual records) in 107 source files. Tot AvgAmt = £869,222.01

Averages: Amount/file: £43,199,342.52    Orig Records/file: 6,314    AvgAmt mean: 8,123.57    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 Barnet has been re-used under the Open Government Licence.