Summary of currently loaded LA spend data for : Oxfordshire

Lastfile: Oxfordshire_202004     LA spend page opens in new window
Sourcefile name Total Amount £ OrigRecs AggRecs AvgAmt£ AAZ   MaxAmt £     MinDate MaxDate Dif     Comment
Oxfordshire_201101.csv 36,633,985.07 4805 0 7,624.14 0.0 4,166,958.00   2011-01-01 2011-01-31 0    
Oxfordshire_201102.csv 34,402,809.15 5905 0 5,826.05 0.0 1,564,752.08   2011-02-01 2011-02-28 0    
Oxfordshire_201103.csv 43,736,938.19 5799 0 7,542.15 0.0 3,104,836.77   2011-03-01 2011-03-31 0    
Oxfordshire_201104.csv 37,813,145.44 5986 0 6,316.93 0.0 1,831,710.56   2011-04-01 2011-04-30 0    
Oxfordshire_201105.csv 38,335,511.01 4518 0 8,485.06 0.0 3,712,118.68   2011-05-01 2011-05-31 0    
Oxfordshire_201106.csv 34,939,783.87 4589 0 7,613.81 0.0 3,715,393.22   2011-06-01 2011-06-30 0    
Oxfordshire_201107.csv 30,320,238.76 4155 0 7,297.29 0.0 3,700,490.84   2011-07-01 2011-07-31 0    
Oxfordshire_201108.csv 43,256,203.34 5700 0 7,588.81 0.0 3,749,861.88   2011-08-01 2011-08-31 0    
Oxfordshire_201109.csv 43,342,142.65 4285 0 10,114.85 0.0 3,619,365.16   2011-09-01 2011-09-30 0    
Oxfordshire_201110.csv 35,356,035.37 4651 0 7,601.81 0.0 3,610,026.71   2011-10-01 2011-10-31 0    
Oxfordshire_201111.csv 39,691,617.42 5116 0 7,758.33 0.0 3,588,732.08   2011-11-01 2011-11-30 0    
Oxfordshire_201112.csv 43,787,018.78 5399 0 8,110.21 0.0 3,535,661.03   2011-12-01 2011-12-31 0    
Oxfordshire_201201.csv 33,801,429.14 4890 0 6,912.36 0.0 3,528,851.81   2012-01-01 2012-01-31 0    
Oxfordshire_201202.csv 33,467,699.40 5477 0 6,110.59 0.0 3,527,821.76   2012-02-01 2012-02-29 0    
Oxfordshire_201203.csv 40,830,820.87 6177 0 6,610.14 0.0 3,518,567.61   2012-03-01 2012-03-31 0    
Oxfordshire_201204.csv 47,261,798.94 6701 0 7,052.95 0.0 3,451,926.38   2012-04-01 2012-04-30 0    
Oxfordshire_201205.csv 40,494,449.98 5928 0 6,831.05 0.0 3,414,717.75   2012-05-01 2012-05-31 0    
Oxfordshire_201206.csv 35,637,484.38 5555 0 6,415.39 0.0 3,430,490.26   2012-06-01 2012-06-30 0    
Oxfordshire_201207.csv 36,369,399.79 5670 0 6,414.36 0.0 3,444,053.14   2012-07-01 2012-07-31 0    
Oxfordshire_201208.csv 35,397,729.39 5338 0 6,631.27 0.0 3,305,424.19   2012-08-01 2012-08-31 0    
Oxfordshire_201209.csv 38,517,304.20 4704 0 8,188.20 0.0 3,267,335.55   2012-09-01 2012-09-30 0    
Oxfordshire_201210.csv 41,221,692.25 6006 0 6,863.42 0.0 3,217,289.03   2012-10-01 2012-10-31 0    
Oxfordshire_201211.csv 40,101,933.41 5542 0 7,236.00 0.0 3,202,445.51   2012-11-01 2012-11-30 0    
Oxfordshire_201212.csv 36,643,369.85 5037 0 7,274.84 0.0 3,164,666.62   2012-12-01 2012-12-31 0    
Oxfordshire_201301.csv 40,991,709.51 6094 0 6,726.57 0.0 3,160,722.02   2013-01-01 2013-01-31 0    
Oxfordshire_201302.csv 34,539,899.28 5768 0 5,988.19 0.0 3,139,270.96   2013-02-01 2013-02-28 0    
Oxfordshire_201303.csv 39,985,579.59 5732 0 6,975.85 0.0 3,381,551.08   2013-03-01 2013-03-31 0    
Oxfordshire_201304.csv 47,693,203.40 6735 0 7,081.40 0.0 3,138,873.17   2013-04-01 2013-04-30 0    
Oxfordshire_201305.csv 41,885,699.73 6024 0 6,953.14 0.0 3,160,625.66   2013-05-01 2013-05-31 0    
Oxfordshire_201306.csv 40,863,142.89 5995 0 6,816.20 0.0 3,201,404.59   2013-06-01 2013-06-30 0    
Oxfordshire_201307.csv 43,512,420.58 6992 0 6,223.17 0.0 3,180,323.86   2013-07-01 2013-07-31 0    
Oxfordshire_201308.csv 38,018,673.41 5043 0 7,538.90 0.0 3,286,441.45   2013-08-01 2013-08-31 0    
Oxfordshire_201309.csv 49,661,446.49 5712 0 8,694.23 0.0 3,178,597.23   2013-09-01 2013-09-30 0    
Oxfordshire_201310.csv 53,623,936.59 6534 0 8,206.91 0.0 3,277,420.00   2013-10-01 2013-10-31 0    
Oxfordshire_201311.csv 44,410,599.67 5680 0 7,818.77 0.0 3,175,461.15   2013-11-01 2013-11-30 0    
Oxfordshire_201312.csv 50,974,143.16 6913 0 7,373.66 0.0 3,178,337.94   2013-12-02 2013-12-31 0    
Oxfordshire_201401.csv 39,266,337.63 5616 0 6,991.87 0.0 3,188,619.17   2014-01-01 2014-01-31 0    
Oxfordshire_201402.csv 40,015,392.05 5786 0 6,915.90 0.0 3,187,621.22   2014-02-01 2014-02-28 0    
Oxfordshire_201403.csv 46,094,106.62 6438 0 7,159.69 0.0 3,166,202.34   2014-03-01 2014-03-31 0    
Oxfordshire_201404.csv 50,082,932.21 7271 0 6,888.04 0.0 3,171,257.61   2014-04-01 2014-04-30 0    
Oxfordshire_201405.csv 43,696,211.06 5764 0 7,580.88 0.0 3,303,831.68   2014-05-01 2014-05-31 0    
Oxfordshire_201406.csv 49,342,542.26 6711 0 7,352.49 0.0 3,330,785.37   2014-06-01 2014-06-30 0    
Oxfordshire_201407.csv 45,759,833.09 6800 0 6,729.39 0.0 3,332,432.17   2014-07-01 2014-07-31 0    
Oxfordshire_201408.csv 41,230,250.62 5732 0 7,193.00 0.0 3,322,429.02   2014-08-01 2014-08-31 0    
Oxfordshire_201409.csv 56,391,378.58 5915 0 9,533.62 0.0 3,286,201.02   2014-09-01 2014-09-30 0    
Oxfordshire_201410.csv 45,293,029.39 6785 0 6,675.46 0.0 3,292,960.06   2014-10-01 2014-10-31 0    
Oxfordshire_201411.csv 41,200,750.72 6214 0 6,630.31 0.0 3,286,394.99   2014-11-01 2014-11-30 0    
Oxfordshire_201412.csv 56,196,050.62 7153 0 7,856.29 0.0 3,285,591.02   2014-12-01 2014-12-31 0    
Oxfordshire_201501.csv 50,886,075.69 6687 0 7,609.70 0.0 3,313,009.72   2015-01-01 2015-01-31 0    
Oxfordshire_201502.csv 46,871,367.86 6368 0 7,360.45 0.0 3,280,176.12   2015-02-01 2015-02-28 0    
Oxfordshire_201503.csv 52,255,071.52 7014 0 7,450.11 0.0 3,251,342.48   2015-03-01 2015-03-31 0    
Oxfordshire_201504.csv 49,605,016.75 7063 0 7,023.22 0.0 3,245,897.07   2015-04-01 2015-04-30 0    
Oxfordshire_201505.csv 62,984,463.86 5857 0 10,753.71 0.0 3,312,089.36   2015-05-01 2015-05-31 0    
Oxfordshire_201506.csv 66,154,468.20 8714 0 7,591.75 0.0 3,286,187.83   2015-06-01 2015-06-30 0    
Oxfordshire_201507.csv 10,649,120.98 7063 0 1,507.73 0.0 1,202,402.29   2015-07-01 2015-07-31 0     Large drop in Total Amt. Analysis
Oxfordshire_201508.csv 57,431,655.45 5312 0 10,811.68 0.0 2,429,352.79   2015-08-01 2015-08-31 0     Large jump in Total Amt. Analysis
Oxfordshire_201509.csv 56,442,552.75 5116 0 11,032.56 0.0 2,327,265.97   2015-09-01 2015-09-30 0    
Oxfordshire_201510.csv 50,692,506.05 5288 0 9,586.33 0.0 2,360,250.06   2015-10-01 2015-10-31 0    
Oxfordshire_201511.csv 59,540,899.06 6235 0 9,549.46 0.0 2,340,139.79   2015-11-01 2015-11-30 0    
Oxfordshire_201512.csv 62,611,505.03 8337 0 7,510.08 0.0 2,291,172.19   2015-12-01 2015-12-31 0    
Oxfordshire_201601.csv 46,083,163.88 6411 0 7,188.14 0.0 2,307,997.33   2016-01-01 2016-01-29 0    
Oxfordshire_201602.csv 51,005,469.98 6833 0 7,464.58 0.0 1,745,878.55   2016-02-01 2016-02-29 0    
Oxfordshire_201603.csv 65,500,834.05 7711 0 8,494.47 0.0 4,850,064.79   2016-03-01 2016-03-31 0    
Oxfordshire_201604.csv 57,585,201.30 6832 0 8,428.75 0.0 2,307,534.15   2016-04-01 2016-04-30 0    
Oxfordshire_201605.csv 43,837,141.52 6246 0 7,018.43 0.0 1,141,451.50   2016-05-01 2016-05-31 0    
Oxfordshire_201606.csv 57,527,310.61 8009 0 7,182.83 0.0 2,341,341.82   2016-06-01 2016-06-30 0    
Oxfordshire_201607.csv 46,898,571.16 6813 0 6,883.69 0.0 1,147,782.71   2016-07-01 2016-07-30 0    
Oxfordshire_201608.csv 53,569,521.69 6573 0 8,149.93 0.0 2,325,483.32   2016-08-01 2016-08-31 0    
Oxfordshire_201609.csv 59,153,248.90 7049 0 8,391.72 0.0 5,410,408.18   2016-09-01 2016-09-30 0    
Oxfordshire_201610.csv 46,743,670.16 6801 0 6,873.06 0.0 1,226,970.83   2016-10-01 2016-10-31 0    
Oxfordshire_201611.csv 54,707,121.64 8465 0 6,462.74 0.0 1,185,523.76   2016-11-01 2016-11-30 0    
Oxfordshire_201612.csv 53,636,500.00 6752 0 7,943.79 0.0 2,320,416.00   2016-12-01 2016-12-31 0    
Oxfordshire_201701.csv 43,620,911.91 6029 0 7,235.18 0.0 2,323,881.89   2017-01-01 2017-01-31 0    
Oxfordshire_201702.csv 47,557,509.42 5904 0 8,055.13 0.0 2,292,531.06   2017-02-01 2017-02-28 0    
Oxfordshire_201703.csv 48,602,591.86 7186 0 6,763.51 0.0 2,257,391.65   2017-03-01 2017-03-31 0    
Oxfordshire_201704.csv 48,838,454.00 6299 0 7,753.37 0.0 2,226,480.01   2017-04-01 2017-04-30 0    
Oxfordshire_201705.csv 41,628,430.41 7078 0 5,881.38 0.0 905,009.21   2017-05-01 2017-05-31 0    
Oxfordshire_201706.csv 56,177,001.56 7378 0 7,614.12 0.0 2,235,484.29   2017-06-01 2017-06-30 0    
Oxfordshire_201707.csv 36,414,064.53 5647 0 6,448.39 0.0 1,236,984.66   2017-07-01 2017-07-31 0    
Oxfordshire_201708.csv 48,368,623.14 6366 0 7,597.96 0.0 2,231,907.62   2017-08-01 2017-08-31 0    
Oxfordshire_201709.csv 44,791,938.97 5812 0 7,706.80 0.0 2,237,907.16   2017-09-01 2017-09-29 0    
Oxfordshire_201710.csv 48,602,665.01 5737 1793 8,471.79 0.0 2,222,007.95   2017-10-01 2017-10-01 0    
Oxfordshire_201711.csv 53,991,496.76 7827 2366 6,898.11 0.0 3,888,647.58   2017-11-01 2017-11-01 0    
Oxfordshire_201712.csv 46,693,149.90 9787 2359 4,770.94 0.0 2,892,310.78   2017-12-01 2017-12-01 0    
Oxfordshire_201801.csv 52,978,861.43 11359 3095 4,664.04 0.0 1,461,084.66   2018-01-01 2018-01-01 0    
Oxfordshire_201802.csv 43,301,561.89 10724 2577 4,037.82 0.0 2,187,869.24   2018-02-01 2018-02-01 0    
Oxfordshire_201803.csv 48,554,444.20 10404 2761 4,666.90 0.0 1,948,283.33   2018-03-01 2018-03-01 0    
Oxfordshire_201804.csv 50,458,839.87 9637 2805 5,235.95 0.0 2,095,541.28   2018-04-01 2018-04-01 0    
Oxfordshire_201805.csv 46,488,984.16 10463 2343 4,443.18 0.0 2,294,043.37   2018-05-01 2018-05-01 0    
Oxfordshire_201806.csv 54,875,270.61 10800 3008 5,081.04 0.0 2,412,491.17   2018-06-01 2018-06-01 0    
Oxfordshire_201807.csv 52,200,623.27 9985 2384 5,227.90 0.0 5,478,701.22   2018-07-01 2018-07-01 0    
Oxfordshire_201808.csv 52,538,726.46 10280 2775 5,110.77 0.0 5,297,853.14   2018-08-01 2018-08-01 0    
Oxfordshire_201809.csv 43,356,708.00 9459 2259 4,583.65 0.0 1,829,204.23   2018-09-01 2018-09-01 0    
Oxfordshire_201810.csv 59,574,611.50 12804 3631 4,652.81 0.0 5,380,559.58   2018-10-01 2018-10-01 0    
Oxfordshire_201811.csv 51,575,679.06 11346 3343 4,545.71 0.0 3,529,956.43   2018-11-01 2018-11-01 0    
Oxfordshire_201812.csv 55,865,950.89 10114 2412 5,523.63 0.0 4,741,414.89   2018-12-01 2018-12-01 0    
Oxfordshire_201901.csv 44,949,924.85 11120 2967 4,042.26 0.0 1,083,571.68   2019-01-01 2019-01-01 0    
Oxfordshire_201902.csv 46,800,738.07 10558 1829 4,432.73 0.0 1,666,824.27   2019-02-01 2019-02-01 0    
Oxfordshire_201903.csv 61,205,770.09 10914 2774 5,608.01 0.0 5,250,000.00   2019-03-01 2019-03-01 0    
Oxfordshire_201904.csv 55,017,457.30 10561 3115 5,209.49 0.0 2,484,675.80   2019-04-01 2019-04-01 0    
Oxfordshire_201905.csv 60,183,850.62 10999 1625 5,471.76 0.0 5,324,628.21   2019-05-01 2019-05-01 0    
Oxfordshire_201906.csv 68,378,922.69 11512 2254 5,939.80 0.0 5,297,001.51   2019-06-01 2019-06-01 0    
Oxfordshire_201907.csv 64,933,448.77 11627 2732 5,584.71 0.0 5,179,383.99   2019-07-01 2019-07-01 0    
Oxfordshire_201908.csv 65,037,293.97 10152 2645 6,406.35 0.0 5,274,855.35   2019-08-01 2019-08-01 0    
Oxfordshire_201909.csv 54,209,669.88 10236 2972 5,295.98 0.0 1,930,541.38   2019-09-01 2019-09-01 0    
Oxfordshire_201910.csv 54,341,040.96 11510 2769 4,721.20 0.0 5,103,243.02   2019-10-01 2019-10-01 0    
Oxfordshire_201911.csv 60,148,217.40 11115 3061 5,411.45 0.0 3,882,672.25   2019-11-01 2019-11-01 0    
Oxfordshire_201912.csv 54,551,789.05 10868 2604 5,019.49 0.0 4,084,212.24   2019-12-01 2019-12-01 0    
Oxfordshire_202001.csv 52,269,039.51 10485 3046 4,985.13 0.0 1,951,446.25   2020-01-01 2020-01-01 0    
Oxfordshire_202002.csv 43,154,560.46 10118 2766 4,265.13 0.0 1,172,602.29   2020-02-01 2020-02-01 0    
Oxfordshire_202003.csv 67,460,765.27 11933 3325 5,653.29 0.0 2,043,222.26   2020-03-01 2020-03-01 0    
Oxfordshire_202004.csv 71,688,761.08 12314 3735 5,821.73 0.0 1,916,261.00   2020-04-01 2020-04-01 0    

Totals: £5,365,850,616.67 from 825,336 original records (582,718 actual records) in 112 source files. Tot AvgAmt = £763,431.46

Averages: Amount/file: £47,909,380.51    Orig Records/file: 7,369    AvgAmt mean: 6,816.35    AvgAmt Std Dev: 0.00

LA Range: 2011/01 - 2020/04

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