Summary of currently loaded LA spend data for : Shropshire

Lastfile: Shropshire_202103     LA spend page opens in new window
Sourcefile name Total Amount £ OrigRecs AggRecs AvgAmt£ AAZ   MaxAmt £     MinDate MaxDate Dif     Comment
Shropshire_202001.csv 29,876,307.18 6549 1696 4,561.96 0.0 2,994,672.00   2020-01-01 2020-02-01 1    
Shropshire_202002.csv 57,587,554.64 6513 1747 8,841.94 0.0 10,000,000.00   2020-02-01 2020-03-01 1    
Shropshire_202003.csv 47,197,410.29 6993 1938 6,749.24 0.0 5,000,000.00   2020-03-01 2020-04-01 1    
Shropshire_202004.csv 31,746,867.20 7143 1930 4,444.47 0.0 3,018,331.12   2020-04-01 2020-05-01 1    
Shropshire_202005.csv 25,903,732.85 5767 1430 4,491.72 0.0 4,865,005.20   2020-05-01 2020-06-01 1    
Shropshire_202006.csv 36,942,505.92 10063 2028 3,671.12 0.0 5,278,824.18   2020-06-01 2020-07-01 1    
Shropshire_202007.csv 28,145,933.58 6293 1481 4,472.58 0.0 3,320,071.34   2020-07-01 2020-08-01 1    
Shropshire_202008.csv 31,239,959.92 6101 1524 5,120.47 0.0 5,000,000.00   2020-08-01 2020-09-01 1    
Shropshire_202009.csv 30,067,415.76 5665 1335 5,307.58 0.0 4,083,090.18   2020-09-01 2020-10-01 1    
Shropshire_202010.csv 19,604,574.07 5557 1218 3,527.91 0.0 787,912.88   2020-10-01 2020-11-01 1    
Shropshire_202011.csv 28,557,599.86 5809 1550 4,916.10 0.0 4,382,846.28   2020-11-01 2020-12-01 1    
Shropshire_202012.csv 34,836,100.43 6863 1648 5,075.93 0.0 4,083,090.18   2020-12-01 2020-12-01 0    
Shropshire_202101.csv 32,215,739.75 5771 1504 5,582.35 0.0 4,083,090.18   2021-01-01 2021-02-01 1    
Shropshire_202102.csv 26,244,962.94 6031 1624 4,351.68 0.0 1,960,738.69   2021-02-01 2021-03-01 1    
Shropshire_202103.csv 45,668,785.95 7089 2030 6,442.20 0.0 5,000,000.00   2021-03-01 2021-04-01 1    

Totals: £505,835,450.34 from 98,207 original records (24,683 actual records) in 15 source files. Tot AvgAmt = £77,557.23

Averages: Amount/file: £33,722,363.36    Orig Records/file: 6,547    AvgAmt mean: 5,170.48    AvgAmt Std Dev: 0.00

LA Range: 2020/01 - 2022/03

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