Summary of currently loaded LA spend data for : Peterborough

Lastfile: Peterborough_201911
Sourcefile name Total Amount £ OrigRecs AggRecs AvgAmt£ AAZ   MaxAmt £     MinDate MaxDate DDif     Comment
Peterborough_201301.csv 24,031,532.77 3176 907 7,566.60 0.0 3,586,965.09   2013-01-01 2013-01-01 0    
Peterborough_201302.csv 21,393,568.38 3202 847 6,681.31 0.0 2,269,420.43   2013-02-01 2013-02-01 0    
Peterborough_201303.csv 28,411,088.64 3330 858 8,531.86 0.0 2,908,210.74   2013-03-01 2013-03-01 0    
Peterborough_201304.csv 33,118,663.28 3464 918 9,560.82 0.0 3,361,007.79   2013-04-01 2013-04-01 0    
Peterborough_201305.csv 26,734,430.90 3261 775 8,198.23 0.0 2,840,617.01   2013-05-01 2013-05-01 0    
Peterborough_201306.csv 36,126,714.32 3089 825 11,695.28 0.0 9,282,440.53   2013-06-01 2013-06-01 0    
Peterborough_201307.csv 27,298,991.33 3779 826 7,223.87 0.0 2,210,882.05   2013-07-01 2013-07-01 0    
Peterborough_201308.csv 27,247,227.32 2855 699 9,543.69 0.0 3,045,605.20   2013-08-01 2013-08-01 0    
Peterborough_201309.csv 24,754,727.99 3158 811 7,838.74 0.0 1,974,246.10   2013-09-01 2013-09-01 0    
Peterborough_201310.csv 24,276,069.94 3355 829 7,235.79 0.0 2,461,648.55   2013-10-01 2013-10-01 0    
Peterborough_201311.csv 25,069,638.28 3253 806 7,706.62 0.0 3,413,030.45   2013-11-01 2013-11-01 0    
Peterborough_201312.csv 35,624,322.44 3017 719 11,807.86 0.0 4,479,022.84   2013-12-01 2013-12-01 0    
Peterborough_201401.csv 25,975,909.13 3483 901 7,457.91 0.0 3,494,772.93   2014-01-01 2014-01-01 0    
Peterborough_201402.csv 19,781,781.29 2964 839 6,674.02 0.0 1,308,293.27   2014-02-01 2014-02-01 0    
Peterborough_201403.csv 27,290,397.68 3346 869 8,156.13 0.0 3,385,688.02   2014-03-01 2014-03-01 0    
Peterborough_201404.csv 31,393,744.98 3532 897 8,888.38 0.0 3,782,451.33   2014-04-01 2014-04-01 0    
Peterborough_201405.csv 22,802,429.64 3161 723 7,213.68 0.0 1,725,465.46   2014-05-01 2014-05-01 0    
Peterborough_201406.csv 32,092,633.14 3508 857 9,148.41 0.0 3,000,605.29   2014-06-01 2014-06-01 0    
Peterborough_201407.csv 25,918,916.38 3615 813 7,169.82 0.0 1,682,093.65   2014-07-01 2014-07-01 0    
Peterborough_201408.csv 26,296,718.87 3167 808 8,303.35 0.0 6,266,140.86   2014-08-01 2014-08-01 0    
Peterborough_201409.csv 23,941,941.88 2917 773 8,207.73 0.0 1,552,140.65   2014-09-01 2014-09-01 0    
Peterborough_201411.csv 29,485,100.84 3370 837 8,749.29 0.0 2,988,780.46   2014-11-01 2014-11-01 0    
Peterborough_201412.csv 41,601,368.34 3477 886 11,964.73 0.0 11,083,271.29   2014-12-01 2014-12-01 0    
Peterborough_201501.csv 27,299,828.31 3270 904 8,348.57 0.0 2,535,829.87   2015-01-01 2015-01-01 0    
Peterborough_201502.csv 20,272,396.27 3068 769 6,607.69 0.0 1,144,877.70   2015-02-01 2015-02-01 0    
Peterborough_201503.csv 32,130,189.32 3529 801 9,104.62 0.0 8,490,766.89   2015-03-01 2015-03-01 0    
Peterborough_201504.csv 30,417,894.17 3500 1006 8,690.83 0.0 3,431,823.69   2015-04-01 2015-04-01 0    
Peterborough_201505.csv 21,891,778.58 3074 722 7,121.59 0.0 1,624,592.02   2015-05-01 2015-05-01 0    
Peterborough_201506.csv 33,999,640.31 3436 881 9,895.12 0.0 3,211,154.86   2015-06-01 2015-06-01 0    
Peterborough_201507.csv 19,256,054.86 3722 783 5,173.58 0.0 1,472,950.56   2015-07-01 2015-07-01 0    
Peterborough_201508.csv 27,262,894.32 3117 768 8,746.52 0.0 5,739,609.62   2015-08-01 2015-08-01 0    
Peterborough_201509.csv 19,242,627.68 2963 681 6,494.31 0.0 1,813,564.79   2015-09-01 2015-09-01 0    
Peterborough_201510.csv 33,500,215.34 4074 859 8,222.93 0.0 6,235,524.57   2015-10-01 2015-10-01 0    
Peterborough_201511.csv 14,661,355.48 2674 575 5,482.93 0.0 1,197,729.79   2015-11-01 2015-11-01 0    
Peterborough_201512.csv 23,090,440.02 3121 669 7,398.41 0.0 1,959,728.89   2015-12-01 2015-12-01 0    
Peterborough_201601.csv 23,421,594.59 3337 823 7,018.76 0.0 1,570,985.65   2016-01-01 2016-01-01 0    
Peterborough_201602.csv 24,615,296.06 3461 791 7,112.19 0.0 4,520,971.94   2016-02-01 2016-02-01 0    
Peterborough_201603.csv 22,244,194.51 3314 783 6,712.19 0.0 1,600,783.65   2016-03-01 2016-03-01 0    
Peterborough_201605.csv 19,625,923.10 2875 623 6,826.41 0.0 1,754,056.75   2016-05-01 2016-05-01 0    
Peterborough_201606.csv 24,082,390.70 4004 874 6,014.58 0.0 1,527,532.57   2016-06-01 2016-06-01 0    
Peterborough_201607.csv 26,658,012.30 3618 748 7,368.16 0.0 3,050,557.97   2016-07-01 2016-07-01 0    
Peterborough_201608.csv 22,315,092.26 4042 734 5,520.80 0.0 2,041,099.82   2016-08-01 2018-03-01 577    
Peterborough_201609.csv 22,689,857.21 3339 707 6,795.40 0.0 1,875,780.18   2016-09-01 2019-07-01 1033    
Peterborough_201610.csv 23,934,308.77 3389 687 7,062.35 0.0 2,401,865.18   2016-10-01 2016-10-01 0    
Peterborough_201611.csv 23,470,587.21 3653 766 6,425.02 0.0 2,141,371.83   2016-11-01 2016-11-01 0    
Peterborough_201612.csv 26,199,477.03 3331 750 7,865.35 0.0 4,126,031.24   2016-12-01 2016-12-01 0    
Peterborough_201701.csv 20,666,668.43 3208 704 6,442.23 0.0 1,986,139.34   2017-01-01 2017-01-01 0    
Peterborough_201702.csv 19,827,715.14 3344 776 5,929.34 0.0 1,839,260.04   2017-02-01 2017-02-01 0    
Peterborough_201703.csv 27,021,789.93 4076 875 6,629.49 0.0 2,628,347.29   2017-03-01 2017-03-01 0    
Peterborough_201704.csv 21,947,715.26 2871 782 7,644.62 0.0 3,312,885.26   2017-04-01 2017-11-01 214    
Peterborough_201705.csv 21,736,755.20 2932 705 7,413.63 0.0 1,584,021.64   2017-05-01 2017-12-01 214    
Peterborough_201706.csv 24,454,755.15 3055 754 8,004.83 0.0 2,122,673.62   2017-06-01 2017-06-01 0    
Peterborough_201707.csv 22,775,680.25 2952 669 7,715.34 0.0 2,056,011.05   2017-07-01 2017-07-01 0    
Peterborough_201708.csv 24,026,356.55 3320 694 7,236.85 0.0 2,806,684.58   2017-08-01 2018-07-01 334    
Peterborough_201709.csv 25,474,237.65 2817 588 9,043.04 0.0 1,939,778.32   2017-09-01 2017-09-01 0    
Peterborough_201710.csv 22,080,076.60 2820 657 7,829.81 0.0 2,478,758.60   2017-10-01 2017-10-01 0    
Peterborough_201711.csv 27,223,332.49 3188 791 8,539.31 0.0 2,311,628.37   2017-11-01 2017-11-01 0    
Peterborough_201712.csv 26,019,724.18 3122 685 8,334.31 0.0 2,386,317.87   2017-12-01 2018-12-01 365    
Peterborough_201801.csv 24,480,387.41 3028 699 8,084.67 0.0 2,107,522.47   2018-01-01 2018-01-01 0    
Peterborough_201802.csv 24,981,696.80 3070 716 8,137.36 0.0 2,243,394.11   2018-02-01 2018-02-01 0    
Peterborough_201803.csv 24,738,499.06 3284 704 7,533.04 0.0 2,110,840.32   2018-03-01 2018-03-01 0    
Peterborough_201804.csv 28,805,232.28 3257 790 8,844.10 0.0 3,376,844.65   2018-04-01 2018-04-01 0    
Peterborough_201805.csv 19,976,508.68 3053 620 6,543.24 0.0 1,866,936.77   2018-05-01 2018-05-01 0    
Peterborough_201806.csv 30,742,854.40 3132 708 9,815.73 0.0 2,656,944.17   2018-06-01 2018-06-01 0    
Peterborough_201807.csv 27,220,456.01 3094 666 8,797.82 0.0 2,602,861.72   2018-07-01 2018-07-01 0    
Peterborough_201808.csv 25,115,555.06 3730 722 6,733.39 0.0 2,524,471.00   2018-08-01 2018-08-01 0    
Peterborough_201809.csv 23,108,417.60 2950 664 7,833.36 0.0 2,355,809.60   2018-09-01 2018-09-01 0    
Peterborough_201810.csv 28,495,461.02 3206 725 8,888.17 0.0 3,441,647.19   2018-10-01 2018-10-01 0    
Peterborough_201811.csv 23,424,346.46 3520 746 6,654.64 0.0 2,756,587.03   2018-11-01 2018-11-01 0    
Peterborough_201812.csv 24,789,063.74 3045 740 8,140.91 0.0 2,969,971.57   2018-12-01 2018-12-01 0    
Peterborough_201901.csv 28,986,667.22 3301 709 8,781.18 0.0 2,418,333.95   2019-01-01 2019-01-01 0    
Peterborough_201902.csv 22,990,644.41 3472 777 6,621.73 0.0 1,481,507.25   2019-02-01 2019-02-01 0    
Peterborough_201903.csv 29,772,846.31 3518 853 8,463.00 0.0 2,223,784.23   2019-03-01 2019-03-01 0    
Peterborough_201904.xlsx 26,353,383.55 3382 794 7,792.25 0.0 3,863,150.46   2019-04-01 2019-04-01 0    
Peterborough_201905.csv 19,211,461.51 3285 733 5,848.24 0.0 1,212,928.19   2019-05-01 2019-05-01 0    
Peterborough_201906.csv 31,660,825.09 3583 829 8,836.40 0.0 4,694,500.00   2019-06-01 2019-06-01 0    
Peterborough_201907.csv 24,303,205.48 3939 824 6,169.89 0.0 1,640,662.40   2019-07-01 2019-07-01 0    
Peterborough_201908.csv 23,852,569.84 3106 710 7,679.51 0.0 1,702,902.31   2019-08-01 2019-08-01 0    
Peterborough_201909.csv 26,044,105.23 2906 651 8,962.18 0.0 2,263,076.96   2019-09-01 2019-09-01 0    
Peterborough_201910.csv 22,308,080.86 3523 728 6,332.13 0.0 1,858,236.84   2019-09-01 2019-10-01 30    
Peterborough_201911.csv 26,109,761.14 4098 830 6,371.34 0.0 1,738,990.64   2019-02-01 2019-12-01 303    

Totals: £2,073,676,802.15 from 267,577 original records (62,345 actual records) in 81 source files. Tot AvgAmt = £630,159.51

Averages: Amount/file: £25,600,948.17    Orig Records/file: 3,303    AvgAmt mean: 7,779.75    AvgAmt Std Dev: 0.00

LA Range: 2013/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.
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. DDif shows the difference in days.
Comment highlights significant potential anomalies - large increases/decreases in Total Amt or high AAZ scores.

Spend details and charts


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