Summary of currently loaded LA spend data for : Isle of Wight

Lastfile: IsleofWight_202102     LA spend page opens in new window
Sourcefile name Total Amount £ OrigRecs AggRecs AvgAmt£ AAZ   MaxAmt £     MinDate MaxDate Dif     Comment
IsleofWight_201101-03.csv 40,688,030.69 9355 0 4,349.34 0.0 1,000,000.00   2011-01-01 2011-03-31 2    
IsleofWight_201104-06.csv 39,872,302.14 8200 0 4,862.48 0.0 1,236,265.00   2011-04-01 2011-06-30 2    
IsleofWight_201107-09.csv 38,687,548.39 8419 0 4,595.27 0.0 1,131,408.00   2011-07-01 2011-09-30 2    
IsleofWight_201110-12.csv 44,722,050.68 8682 0 5,151.12 0.0 2,168,435.00   2011-10-01 2011-12-30 2    
IsleofWight_201201-03.csv 43,435,612.16 10821 0 4,014.01 0.0 1,257,500.00   2012-01-01 2012-03-30 2    
IsleofWight_201204.csv 13,439,536.54 2305 0 5,830.60 0.0 1,702,350.00   2012-04-04 2012-04-30 0     Drop in Total Amt. Analysis
IsleofWight_201205.csv 15,511,126.58 2967 0 5,227.88 0.0 1,789,650.00   2012-05-01 2012-05-31 0    
IsleofWight_201206.csv 11,794,440.83 2486 0 4,744.34 0.0 1,391,950.00   2012-06-01 2012-06-29 0    
IsleofWight_201207.csv 17,724,552.82 2844 0 6,232.26 0.0 1,488,950.00   2012-07-02 2012-07-31 0    
IsleofWight_201208.csv 13,184,906.93 2692 0 4,897.81 0.0 1,564,000.00   2012-08-01 2012-08-31 0    
IsleofWight_201209.csv 11,617,493.07 2561 0 4,536.31 0.0 1,262,021.20   2012-09-03 2012-09-30 0    
IsleofWight_201210.csv 12,754,123.88 12685 0 1,005.45 0.0 607,433.59   2012-09-27 2012-10-31 1    
IsleofWight_201211.csv 15,088,866.00 12430 0 1,213.91 0.0 2,260,000.00   2012-10-23 2012-11-30 1    
IsleofWight_201212.csv 9,422,894.74 9233 0 1,020.57 0.0 435,149.25   2012-11-27 2012-12-27 1    
IsleofWight_201301.csv 15,353,520.73 13581 0 1,130.51 0.0 1,104,268.55   2012-12-28 2013-01-31 1    
IsleofWight_201302.csv 10,982,559.24 11985 0 916.36 0.0 346,407.71   2013-01-28 2013-02-28 1    
IsleofWight_201303.csv 13,866,790.37 13096 0 1,058.86 0.0 346,132.31   2013-02-27 2013-03-31 1    
IsleofWight_201304.csv 14,325,380.11 11285 0 1,269.42 0.0 1,394,790.66   2013-03-27 2013-04-30 1    
IsleofWight_201305.csv 12,220,593.98 11552 0 1,057.88 0.0 1,394,790.66   2013-04-25 2013-05-31 1    
IsleofWight_201306.csv 14,287,145.62 11266 0 1,268.16 0.0 1,978,000.00   2013-03-11 2013-06-30 3    
IsleofWight_201307.csv 13,288,504.69 12087 0 1,099.40 0.0 1,374,800.71   2013-06-27 2013-07-31 1    
IsleofWight_201308.csv 12,170,570.99 12042 0 1,010.68 0.0 1,394,535.73   2013-07-25 2013-08-31 1    
IsleofWight_201309.csv 11,603,687.79 10877 0 1,066.81 0.0 1,393,261.08   2013-07-25 2013-09-30 2    
IsleofWight_201504.csv 19,849,538.87 11406 0 1,740.27 0.0 1,501,661.76   2015-03-26 2015-04-30 1    
IsleofWight_201505.csv 11,175,017.82 11825 0 945.03 0.0 1,583,679.62   2015-04-17 2015-05-31 1    
IsleofWight_201506.csv 14,180,979.63 10311 0 1,375.33 0.0 1,566,721.25   2015-04-02 2015-07-03 3    
IsleofWight_201507.csv 12,486,077.68 10680 0 1,169.11 0.0 1,581,956.62   2015-04-17 2015-07-31 3    
IsleofWight_201508.csv 12,183,956.70 9789 0 1,244.66 0.0 1,563,847.73   2015-04-17 2015-08-31 4    
IsleofWight_201509.csv 13,934,174.17 9637 0 1,445.90 0.0 1,557,973.84   2015-04-17 2015-09-30 5    
IsleofWight_201510.csv 20,874,228.76 10690 0 1,952.69 0.0 4,000,000.00   2015-04-17 2015-10-31 6    
IsleofWight_201511.csv 16,073,941.16 11255 0 1,428.16 0.0 1,477,794.51   2015-10-07 2015-11-30 1    
IsleofWight_201512.csv 14,795,784.25 9278 0 1,594.72 0.0 1,669,840.34   2015-11-26 2015-12-31 1    
IsleofWight_201601.csv 14,355,677.67 9630 0 1,490.72 0.0 1,675,467.38   2015-12-28 2016-01-31 1    
IsleofWight_201602.csv 12,451,084.03 10021 0 1,242.50 0.0 1,682,254.99   2016-01-21 2016-03-02 2    
IsleofWight_201603.csv 18,341,164.14 10495 0 1,747.61 0.0 1,681,993.93   2016-02-12 2016-03-31 1    
IsleofWight_201604.csv 13,365,513.77 8383 0 1,594.36 0.0 1,688,811.66   2016-03-28 2016-04-30 1    
IsleofWight_201605.csv 11,755,666.23 9621 0 1,221.88 0.0 2,726,548.09   2016-04-15 2016-05-31 1    
IsleofWight_201606.csv 13,965,061.85 8470 0 1,648.77 0.0 1,700,000.00   2016-05-06 2016-06-30 1    
IsleofWight_201607.csv 12,053,895.49 9143 0 1,318.37 0.0 4,638,265.87   2016-06-28 2016-07-31 1    
IsleofWight_201608.csv 19,746,724.37 8912 0 2,215.75 0.0 2,074,677.57   2016-07-26 2016-08-31 1    
IsleofWight_201609.csv 14,341,021.68 8629 0 1,661.96 0.0 1,688,416.75   2016-08-26 2016-09-30 1    
IsleofWight_201610.csv 16,028,422.51 9395 0 1,706.06 0.0 1,600,199.52   2016-09-02 2016-10-31 1    
IsleofWight_201611.csv 15,595,029.99 8893 0 1,753.63 0.0 1,676,954.11   2016-10-19 2016-12-02 2    
IsleofWight_201612.csv 12,636,830.85 7232 0 1,747.35 0.0 1,678,322.72   2016-11-04 2017-01-03 2    
IsleofWight_201701.csv 13,513,525.71 8681 0 1,556.68 0.0 1,875,248.90   2016-12-02 2017-01-31 1    
IsleofWight_201702.csv 13,103,122.87 9131 0 1,435.02 0.0 1,794,472.11   2017-01-27 2017-03-01 2    
IsleofWight_201703.csv 17,396,942.38 10746 0 1,618.92 0.0 1,985,990.94   2017-02-01 2017-03-31 1    
IsleofWight_201704.csv 16,008,806.50 7066 0 2,265.61 0.0 3,916,019.75   2017-03-07 2017-04-30 1    
IsleofWight_201705.csv 9,933,416.78 8033 0 1,236.58 0.0 1,906,718.30   2017-04-24 2017-05-31 1    
IsleofWight_201706.csv 22,272,337.25 9688 0 2,298.96 0.0 5,290,916.37   2017-05-10 2017-06-30 1     Jump in Total Amt. Analysis
IsleofWight_201707.csv 11,844,241.36 8428 0 1,405.34 0.0 1,976,835.74   2017-05-10 2017-07-31 2    
IsleofWight_201708.csv 20,452,492.82 8809 0 2,321.77 0.0 6,467,484.79   2017-04-19 2017-08-31 4    
IsleofWight_201709.csv 17,488,816.75 7484 2580 2,336.83 0.0 3,149,139.59   2017-01-01 2017-09-01 8    
IsleofWight_201710.csv 16,689,099.03 9201 2705 1,813.84 0.0 2,019,093.69   2017-09-01 2017-10-01 1    
IsleofWight_201711.csv 29,128,098.63 9920 3143 2,936.30 0.0 3,085,081.00   2017-10-01 2017-11-01 1    
IsleofWight_201712.csv 15,722,576.64 7437 2532 2,114.10 0.0 2,042,410.99   2017-11-01 2017-12-01 1    
IsleofWight_201801.csv 17,611,510.86 8647 2956 2,036.72 0.0 2,364,313.23   2017-12-01 2018-01-01 1    
IsleofWight_201802.csv 13,227,595.15 8314 2880 1,591.00 0.0 2,039,998.86   2018-01-01 2018-02-01 1    
IsleofWight_201803.csv 19,938,565.77 9903 3027 2,013.39 0.0 2,437,489.59   2018-02-01 2018-03-01 1    
IsleofWight_201804.csv 39,076,282.25 8204 2892 4,763.08 0.0 20,400,620.80   2018-03-01 2018-04-01 1    
IsleofWight_201805.csv 11,334,480.77 8599 2868 1,318.12 0.0 2,092,886.79   2018-03-01 2018-05-01 2     Drop in Total Amt. Analysis
IsleofWight_201806.csv 17,666,047.83 8833 2905 2,000.01 0.0 3,248,786.81   2018-05-01 2018-06-01 1    
IsleofWight_201807.csv 16,154,465.48 7954 2732 2,030.99 0.0 2,265,389.86   2018-06-01 2018-07-01 1    
IsleofWight_201808.csv 14,973,131.48 8615 2770 1,738.03 0.0 2,091,512.89   2018-05-01 2018-08-01 3    
IsleofWight_201809.csv 15,604,927.97 7192 2638 2,169.76 0.0 2,092,612.01   2018-08-01 2018-09-01 1    
IsleofWight_201810.csv 26,516,017.60 9873 3047 2,685.71 0.0 2,838,837.00   2018-09-01 2018-10-01 1    
IsleofWight_201811.csv 25,058,298.40 8243 2781 3,039.95 0.0 10,514,815.86   2018-10-01 2018-11-01 1    
IsleofWight_201812.csv 24,081,801.20 7877 2653 3,057.23 0.0 4,119,311.95   2018-10-01 2018-12-01 2    
IsleofWight_201901.csv 17,853,600.01 8530 3027 2,093.04 0.0 2,094,260.69   2018-12-01 2019-01-01 1    
IsleofWight_201902.csv 28,957,549.68 13753 4586 2,105.54 0.0 3,294,103.61   2019-01-01 2019-02-01 1    
IsleofWight_201903.csv 27,888,398.73 15337 4715 1,818.37 0.0 2,093,985.91   2019-02-01 2019-03-01 1    
IsleofWight_201904.csv 17,135,775.89 7937 2795 2,158.97 0.0 2,127,705.12   2019-03-01 2019-04-01 1    
IsleofWight_201905.csv 12,573,346.01 7691 2587 1,634.81 0.0 2,095,075.63   2019-03-01 2019-05-01 2    
IsleofWight_201906.csv 11,818,425.90 8137 2760 1,452.43 0.0 2,123,517.95   2019-05-01 2019-06-01 1    
IsleofWight_201907.csv 14,237,975.75 8181 2754 1,740.37 0.0 2,126,588.54   2019-03-01 2019-07-01 4    
IsleofWight_201908.csv 74,564,671.56 8305 2818 8,978.29 0.0 20,000,000.00   2019-03-01 2019-08-01 5     Large jump in Total Amt. Analysis
IsleofWight_201909.csv 16,873,052.74 7949 2558 2,122.66 0.0 2,109,456.07   2019-03-01 2019-09-01 6     Drop in Total Amt. Analysis
IsleofWight_201910.csv 18,460,611.12 7826 2620 2,358.88 0.0 2,131,229.38   2019-03-01 2019-10-01 7    
IsleofWight_201911.csv 15,707,457.26 7990 2793 1,965.89 0.0 1,978,462.54   2019-03-01 2019-11-01 8    
IsleofWight_201912.csv 20,200,495.15 8039 2723 2,512.81 0.0 2,133,462.54   2019-03-01 2019-12-01 9    
IsleofWight_202001.csv 22,157,954.63 8834 2874 2,508.26 0.0 6,228,272.00   2019-06-01 2020-01-01 7    
IsleofWight_202002.csv 28,664,597.47 8258 3012 3,471.13 0.0 13,229,848.00   2020-01-01 2020-02-01 1    
IsleofWight_202003.csv 21,384,438.00 10296 3139 2,076.97 0.0 2,155,392.60   2020-02-01 2020-03-01 1    
IsleofWight_202004.csv 18,522,036.04 7128 2235 2,598.49 0.0 2,190,066.12   2020-01-01 2020-04-01 3    
IsleofWight_202005.csv 13,755,921.11 5719 1804 2,405.30 0.0 2,161,381.22   2020-03-01 2020-05-01 2    
IsleofWight_202006.csv 13,796,013.03 5940 1894 2,322.56 0.0 2,154,942.79   2019-10-01 2020-06-01 8    
IsleofWight_202007.csv 14,611,555.52 6934 2123 2,107.23 0.0 2,120,428.71   2020-06-01 2020-07-01 1    
IsleofWight_202008.csv 18,727,461.97 7228 2068 2,590.96 0.0 2,192,972.48   2020-07-01 2020-08-01 1    
IsleofWight_202009.csv 18,666,565.55 6916 2205 2,699.04 0.0 2,179,243.09   2020-07-01 2020-09-01 2    
IsleofWight_202010.csv 14,382,418.98 6793 2094 2,117.24 0.0 2,193,633.36   2020-09-01 2020-10-01 1    
IsleofWight_202011.csv 16,524,759.86 7098 2192 2,328.09 0.0 2,161,062.73   2020-09-01 2020-11-01 2    
IsleofWight_202012.csv 16,069,114.28 7018 2170 2,289.70 0.0 2,193,633.36   2020-11-01 2020-12-01 1    
IsleofWight_202101.csv 19,274,289.07 7187 2315 2,681.83 0.0 2,190,224.58   2020-12-01 2021-01-01 1    
IsleofWight_202102.csv 14,637,616.50 6754 2064 2,167.25 0.0 2,190,016.47   2021-01-01 2021-02-01 1    

Totals: £1,728,474,733.88 from 825,802 original records (591,762 actual records) in 94 source files. Tot AvgAmt = £216,894.29

Averages: Amount/file: £18,388,029.08    Orig Records/file: 8,785    AvgAmt mean: 2,307.39    AvgAmt Std Dev: 0.00

LA Range: 2011/01 - 2022/05

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