Summary of currently loaded LA spend data for : Islington

Lastfile: Islington_201909-11     LA spend page opens in new window
Sourcefile name Total Amount £ OrigRecs AggRecs AvgAmt£ AAZ   MaxAmt £     MinDate MaxDate Dif     Comment
Islington_201101.csv 23,414,496.56 1542 0 15,184.50 0.0 2,874,166.33   2011-01-01 2011-01-01 0    
Islington_201102.csv 23,127,501.43 1977 0 11,698.28 0.0 695,350.00   2011-02-01 2011-02-01 0    
Islington_201103.csv 35,170,289.75 2767 0 12,710.62 0.0 721,496.34   2011-03-01 2011-03-01 0    
Islington_201104.csv 21,267,695.98 1798 0 11,828.53 0.0 998,641.61   2011-04-01 2011-04-01 0    
Islington_201105.csv 19,053,769.78 1383 0 13,777.13 0.0 1,065,863.67   2011-05-01 2011-05-01 0    
Islington_201106.csv 20,837,328.88 1419 0 14,684.52 0.0 698,964.63   2011-06-01 2011-06-01 0    
Islington_201107.csv 22,863,761.19 1510 0 15,141.56 0.0 3,225,991.20   2011-07-01 2011-07-01 0    
Islington_201108.csv 27,532,670.95 1485 0 18,540.52 0.0 1,474,466.40   2011-08-01 2011-08-01 0    
Islington_201109.csv 35,238,102.73 1368 0 25,758.85 0.0 15,448,630.80   2011-09-01 2011-09-01 0    
Islington_201110.csv 23,351,122.91 1523 0 15,332.32 0.0 1,474,466.40   2011-10-01 2011-10-01 0    
Islington_201111.csv 22,501,337.72 1517 0 14,832.79 0.0 1,134,430.80   2011-11-01 2011-11-01 0    
Islington_201112.csv 18,959,141.17 1229 0 15,426.48 0.0 1,515,569.32   2011-12-01 2011-12-01 0    
Islington_201201.csv 30,845,420.33 1639 0 18,819.66 0.0 2,803,200.52   2012-01-01 2012-01-01 0    
Islington_201202.csv 24,976,964.16 1676 0 14,902.72 0.0 1,474,466.40   2012-02-01 2012-02-01 0    
Islington_201203.csv 34,968,186.72 2442 0 14,319.49 0.0 1,153,930.80   2012-03-01 2012-03-01 0    
Islington_201204.csv 31,849,158.00 1597 0 19,943.12 0.0 6,150,104.00   2012-04-01 2012-04-01 0    
Islington_201205.csv 27,415,187.00 1562 0 17,551.34 0.0 2,300,952.00   2012-05-01 2012-05-01 0    
Islington_201206.csv 26,856,140.00 1642 0 16,355.75 0.0 2,366,377.00   2012-06-01 2012-06-01 0    
Islington_201207.csv 29,664,898.00 1815 0 16,344.30 0.0 2,414,283.00   2012-07-01 2012-07-01 0    
Islington_201208.csv 30,994,176.11 1640 0 18,898.89 0.0 2,413,980.00   2012-08-01 2012-08-01 0    
Islington_201209.csv 24,805,324.28 1501 0 16,525.87 0.0 2,388,924.79   2012-09-01 2012-09-01 0    
Islington_201210.csv 33,218,297.64 2110 0 15,743.27 0.0 2,429,317.63   2012-10-01 2012-10-01 0    
Islington_201211.csv 25,865,331.67 1864 0 13,876.25 0.0 2,389,637.07   2012-11-01 2012-11-01 0    
Islington_201212.csv 31,979,901.65 1713 0 18,668.94 0.0 2,391,474.49   2012-12-01 2012-12-01 0    
Islington_201301.csv 25,949,045.87 1660 0 15,631.96 0.0 2,159,911.57   2013-01-01 2013-01-01 0    
Islington_201302.csv 26,776,075.87 1843 0 14,528.53 0.0 1,302,902.97   2013-02-01 2013-02-01 0    
Islington_201303.csv 32,921,694.55 2786 0 11,816.83 0.0 906,543.18   2013-03-01 2013-03-01 0    
Islington_201304.csv 28,335,357.70 1456 0 19,461.10 0.0 5,878,205.99   2013-04-01 2013-04-01 0    
Islington_201305.csv 21,829,046.63 1736 0 12,574.34 0.0 1,124,651.94   2013-05-01 2013-05-01 0    
Islington_201306.csv 30,173,050.28 1603 0 18,822.86 0.0 2,434,265.32   2013-06-01 2013-06-01 0    
Islington_201307.csv 30,534,231.11 2014 0 15,160.99 0.0 2,423,219.83   2013-07-01 2013-07-01 0    
Islington_201308.csv 28,017,372.48 1811 0 15,470.66 0.0 2,360,495.42   2013-08-01 2013-08-01 0    
Islington_201309.csv 23,690,086.85 1735 0 13,654.23 0.0 2,433,900.93   2013-09-01 2013-09-01 0    
Islington_201310.csv 31,964,662.24 2147 0 14,888.06 0.0 2,600,030.57   2013-10-01 2013-10-01 0    
Islington_201311.csv 27,872,561.13 1913 0 14,570.08 0.0 2,435,129.88   2013-11-01 2013-11-01 0    
Islington_201312.xlsx 28,310,300.69 2057 0 13,762.91 0.0 2,436,810.02   2013-12-01 2013-12-01 0    
Islington_201401.xlsx 27,336,438.09 2045 0 13,367.45 0.0 2,199,951.98   2014-01-01 2014-01-01 0    
Islington_201402.xlsx 21,641,857.39 1975 0 10,957.90 0.0 478,004.83   2014-02-01 2014-02-01 0    
Islington_201403.xlsx 34,624,410.89 2971 0 11,654.13 0.0 1,429,089.67   2014-03-01 2014-03-01 0    
Islington_201404.xlsx 29,373,286.20 2231 0 13,165.97 0.0 900,344.65   2014-04-01 2014-04-01 0    
Islington_201405.xlsx 31,611,400.07 1707 0 18,518.69 0.0 5,785,999.45   2014-05-01 2014-05-01 0    
Islington_201406.xlsx 25,703,981.72 1886 0 13,628.83 0.0 2,462,585.22   2014-06-01 2014-06-01 0    
Islington_201407.xlsx 33,955,900.94 2402 0 14,136.51 0.0 2,458,652.46   2014-07-01 2014-07-01 0    
Islington_201408.xlsx 25,572,697.99 1999 0 12,792.75 0.0 2,384,301.13   2014-08-01 2014-08-01 0    
Islington_201409.xlsx 22,842,932.51 3057 0 7,472.34 0.0 2,589,236.06   2014-09-01 2014-09-01 0    
Islington_201410.xlsx 28,774,861.79 3458 0 8,321.24 0.0 1,126,395.46   2014-10-01 2014-10-01 0    
Islington_201411.xlsx 26,666,445.90 3422 0 7,792.65 0.0 2,452,522.45   2014-11-01 2014-11-01 0    
Islington_201412.xlsx 28,824,203.52 3835 0 7,516.09 0.0 2,459,254.42   2014-12-01 2014-12-01 0    
Islington_201501-03.xlsx 72,883,491.46 10205 0 7,141.94 0.0 2,220,100.80   2014-10-31 2015-06-09 8     Jump in Total Amt. Analysis
Islington_201504-06.xlsx 86,034,458.22 11314 0 7,604.25 0.0 5,749,572.65   2013-02-27 2015-07-02 29    
Islington_201507-09.xlsx 83,032,296.36 9996 0 8,306.55 0.0 2,642,970.01   2014-04-14 2015-09-29 17    
Islington_201510-12.xlsx 94,159,215.01 11196 0 8,410.08 0.0 2,469,256.95   2015-03-11 2015-12-31 9    
Islington_201601-03.xlsx 87,885,714.73 11475 0 7,658.89 0.0 2,305,533.64   2015-08-21 2016-04-01 8    
Islington_201604-06.xlsx 97,710,972.39 11871 0 8,231.06 0.0 5,682,613.90   2015-09-22 2016-06-30 9    
Islington_201607-09.xlsx 88,554,017.72 11223 0 7,890.41 0.0 2,671,409.52   2015-12-08 2016-09-30 9    
Islington_201610-12.xlsx 100,814,052.92 11704 0 8,613.64 0.0 2,488,432.66   2016-04-06 2017-01-09 9    
Islington_201701-03.csv 102,543,056.58 13431 0 7,634.80 0.0 2,247,616.59   2015-09-22 2017-04-07 19    
Islington_201704-06.csv 95,250,305.80 11739 0 8,114.01 0.0 5,465,075.63   2017-01-09 2017-07-03 6    
Islington_201707-09.csv 84,904,725.81 10791 5596 7,868.11 0.0 5,061,918.99   2017-07-01 2017-09-01 2    
Islington_201710-12.csv 86,101,927.18 12519 6884 6,877.70 0.0 2,529,147.73   2017-08-01 2018-01-01 5    
Islington_201801-03.csv 50,587,821.45 6012 3283 8,414.47 0.0 2,420,588.71   2015-09-01 2018-03-01 30    
Islington_201804-05.csv 57,701,118.44 7816 4122 7,382.44 0.0 5,421,949.44   2018-03-01 2018-05-01 2    
Islington_201806-08.csv 61,997,988.78 8039 4181 7,712.15 0.0 2,577,109.03   2018-06-01 2018-08-01 2    
Islington_201809-11.csv 83,694,032.54 11760 5762 7,116.84 0.0 2,825,272.04   2018-09-01 2018-12-01 3    
Islington_201812-201902.csv 82,183,404.33 11117 5748 7,392.59 0.0 2,573,321.24   2018-07-01 2019-02-01 7    
Islington_201903-05.csv 72,226,063.52 10147 5168 7,117.97 0.0 5,171,611.46   2015-08-01 2019-06-01 46    
Islington_201906-08.csv 64,076,653.33 8868 4503 7,225.60 0.0 6,153,246.00   2019-04-01 2019-09-01 5    
Islington_201909-11.csv 55,090,663.50 9473 4639 5,815.55 0.0 2,890,992.15   2019-07-01 2019-12-01 5    

Totals: £2,927,490,087.09 from 305,164 original records (258,508 actual records) in 68 source files. Tot AvgAmt = £859,061.80

Averages: Amount/file: £43,051,324.81    Orig Records/file: 4,488    AvgAmt mean: 12,633.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 Islington has been re-used under the Open Government Licence.