Summary of currently loaded LA spend data for : North Tyneside

Lastfile: NorthTyneside_202003     LA spend page opens in new window
Sourcefile name Total Amount £ OrigRecs AggRecs AvgAmt£ AAZ   MaxAmt £     MinDate MaxDate Dif     Comment
NorthTyneside_201401.csv 26,993,228.21 17599 0 1,533.79 0.0 1,386,049.24   2014-01-02 2014-01-31 0    
NorthTyneside_201402.csv 22,828,991.73 16518 0 1,382.07 0.0 1,375,829.98   2014-02-03 2014-02-28 0    
NorthTyneside_201403.csv 29,872,356.65 18213 0 1,640.17 0.0 1,388,880.54   2014-03-03 2014-03-31 0    
NorthTyneside_201404.csv 24,111,542.58 11748 0 2,052.40 0.0 1,400,669.05   2014-04-01 2014-04-30 0    
NorthTyneside_201405.csv 26,073,752.00 12245 0 2,129.34 0.0 1,497,124.58   2014-05-01 2014-05-30 0    
NorthTyneside_201406.csv 70,608,530.03 13122 0 5,380.93 0.0 12,398,399.00   2014-06-02 2014-06-30 0     Jump in Total Amt. Analysis
NorthTyneside_201407.csv 28,623,600.25 13223 0 2,164.68 0.0 1,511,397.98   2014-07-01 2014-07-31 0    
NorthTyneside_201408.csv 27,525,511.99 11017 0 2,498.46 0.0 3,163,200.00   2014-08-04 2014-08-29 0    
NorthTyneside_201409.csv 29,907,569.20 13075 0 2,287.39 0.0 1,511,208.81   2014-09-01 2014-09-30 0    
NorthTyneside_201410.csv 29,165,365.37 13404 0 2,175.87 0.0 1,207,234.00   2014-10-01 2014-10-31 0    
NorthTyneside_201411.csv 26,340,590.38 11423 0 2,305.93 0.0 1,503,705.51   2014-11-03 2014-11-28 0    
NorthTyneside_201412.csv 35,870,849.69 12523 0 2,864.40 0.0 1,816,863.80   2014-12-01 2014-12-23 0    
NorthTyneside_201501.csv 26,303,078.91 12179 0 2,159.71 0.0 2,324,370.04   2015-01-05 2015-01-30 0    
NorthTyneside_201502.csv 30,484,358.73 11242 0 2,711.65 0.0 1,522,353.55   2015-02-02 2015-02-27 0    
NorthTyneside_201503.csv 32,290,622.84 14478 0 2,230.32 0.0 1,538,398.96   2015-03-02 2015-03-31 0    
NorthTyneside_201504.csv 26,068,093.05 11971 0 2,177.60 0.0 1,542,965.28   2015-04-01 2015-04-30 0    
NorthTyneside_201505.csv 28,354,629.33 11825 0 2,397.85 0.0 1,536,450.40   2015-05-01 2015-05-29 0    
NorthTyneside_201506.csv 38,907,426.02 14229 0 2,734.38 0.0 3,840,713.49   2015-06-01 2015-06-30 0    
NorthTyneside_201507.csv 38,858,249.86 13609 0 2,855.33 0.0 1,824,767.44   2015-07-01 2015-07-31 0    
NorthTyneside_201508.csv 27,843,623.70 11055 0 2,518.65 0.0 1,564,912.52   2015-08-03 2015-08-28 0    
NorthTyneside_201509.csv 56,610,504.28 13879 0 4,078.86 0.0 12,199,080.00   2015-09-01 2015-09-30 0     Jump in Total Amt. Analysis
NorthTyneside_201510.csv 33,259,324.78 12867 0 2,584.85 0.0 1,539,890.10   2015-10-01 2015-10-30 0    
NorthTyneside_201511.csv 31,343,999.67 13133 0 2,386.66 0.0 1,566,751.25   2015-11-02 2015-11-30 0    
NorthTyneside_201512.csv 36,835,205.90 11692 0 3,150.46 0.0 5,222,558.58   2015-12-01 2015-12-23 0    
NorthTyneside_201601.csv 30,270,416.34 12519 0 2,417.96 0.0 1,562,882.28   2016-01-04 2016-01-29 0    
NorthTyneside_201602.csv 31,611,924.09 13520 0 2,338.16 0.0 1,543,035.81   2016-02-01 2016-02-29 0    
NorthTyneside_201603.csv 38,923,968.71 13604 0 2,861.21 0.0 1,555,616.00   2016-03-01 2016-03-31 0    
NorthTyneside_201604.csv 27,172,099.32 11884 0 2,286.44 0.0 1,549,607.28   2016-04-01 2016-04-29 0    
NorthTyneside_201605.csv 34,139,810.67 15648 0 2,181.74 0.0 1,537,617.63   2016-05-03 2016-05-31 0    
NorthTyneside_201606.csv 15,041,876.71 12487 0 1,204.60 0.0 1,533,730.21   2016-06-01 2016-06-30 0    
NorthTyneside_201607.csv 32,858,837.00 13669 0 2,403.89 0.0 1,581,986.64   2016-07-01 2016-07-29 0     Jump in Total Amt. Analysis
NorthTyneside_201608.csv 33,250,497.23 14069 0 2,363.39 0.0 1,567,926.51   2016-08-01 2016-08-31 0    
NorthTyneside_201609.csv 33,906,783.42 12057 0 2,812.21 0.0 1,556,437.52   2016-09-01 2016-09-30 0    
NorthTyneside_201610.csv 29,012,224.94 13338 0 2,175.16 0.0 1,549,112.25   2016-10-03 2016-10-28 0    
NorthTyneside_201611.csv 33,410,725.51 13031 0 2,563.94 0.0 1,539,804.37   2016-11-01 2016-11-30 0    
NorthTyneside_201612.csv 31,247,980.45 11799 0 2,648.36 0.0 1,539,126.96   2016-12-01 2016-12-23 0    
NorthTyneside_201701.csv 32,926,672.37 14908 0 2,208.66 0.0 1,542,761.25   2017-01-03 2017-01-31 0    
NorthTyneside_201702.csv 31,110,342.69 12112 0 2,568.56 0.0 2,060,067.00   2017-02-01 2017-02-28 0    
NorthTyneside_201703.csv 64,126,372.01 13430 0 4,774.86 0.0 11,801,677.00   2017-03-01 2017-03-31 0     Jump in Total Amt. Analysis
NorthTyneside_201704.csv 30,004,104.12 12651 0 2,371.68 0.0 1,527,271.05   2017-04-03 2017-04-28 0    
NorthTyneside_201705.csv 33,449,015.97 14563 0 2,296.85 0.0 1,667,368.55   2017-05-02 2017-05-31 0    
NorthTyneside_201706.csv 40,301,506.70 12776 1143 3,154.47 0.0 3,596,457.92   2017-06-01 2017-06-01 0    
NorthTyneside_201707.csv 39,942,922.06 15680 1279 2,547.38 0.0 3,647,738.21   2017-07-01 2017-07-01 0    
NorthTyneside_201708.csv 27,623,614.49 13773 941 2,005.64 0.0 3,590,916.52   2017-08-01 2017-08-01 0    
NorthTyneside_201709.csv 33,374,141.18 11841 1075 2,818.52 0.0 3,598,946.64   2017-09-01 2017-09-01 0    
NorthTyneside_201710.csv 36,318,274.08 14982 1161 2,424.13 0.0 4,047,350.58   2017-10-01 2017-10-01 0    
NorthTyneside_201711.csv 33,856,052.33 12263 1141 2,760.83 0.0 3,562,178.45   2017-11-01 2017-11-01 0    
NorthTyneside_201712.csv 36,687,366.86 12104 1055 3,031.01 0.0 3,561,227.40   2017-12-01 2017-12-01 0    
NorthTyneside_201801.csv 32,987,766.40 15887 1239 2,076.40 0.0 3,694,752.95   2018-01-01 2018-01-01 0    
NorthTyneside_201802.csv 33,336,180.22 13623 1006 2,447.05 0.0 3,868,500.22   2018-02-01 2018-02-01 0    
NorthTyneside_201803.csv 39,041,036.30 13579 1331 2,875.10 0.0 5,378,406.47   2018-03-01 2018-03-01 0    
NorthTyneside_201804.xlsx 32,547,041.30 14839 1086 2,193.34 0.0 3,540,299.62   2018-04-01 2018-04-01 0    
NorthTyneside_201805.xlsx 34,545,422.31 14195 1071 2,433.63 0.0 3,758,676.49   2018-05-01 2018-05-01 0    
NorthTyneside_201806.xlsx 40,072,297.75 13260 1093 3,022.04 0.0 4,762,857.05   2018-06-01 2018-06-01 0    
NorthTyneside_201807.xlsx 37,975,621.77 16542 1291 2,295.71 0.0 3,599,372.03   2018-07-01 2018-07-01 0    
NorthTyneside_201808.xlsx 35,325,501.47 14113 1082 2,503.05 0.0 3,584,304.16   2018-08-01 2018-08-01 0    
NorthTyneside_201809.xlsx 31,844,666.59 12354 919 2,577.68 0.0 3,622,807.63   2018-09-01 2018-09-01 0    
NorthTyneside_201810.xlsx 35,665,564.21 16773 1202 2,126.37 0.0 3,499,312.06   2018-10-01 2018-10-01 0    
NorthTyneside_201811.xlsx 29,056,176.14 14101 1217 2,060.58 0.0 3,544,731.75   2018-11-01 2018-11-01 0    
NorthTyneside_201812.xlsx 38,531,758.89 14933 1001 2,580.31 0.0 4,211,992.49   2018-12-01 2018-12-01 0    
NorthTyneside_201901.xlsx 32,997,223.06 14606 1264 2,259.16 0.0 3,742,038.28   2019-01-01 2019-01-01 0    
NorthTyneside_201902.xlsx 34,056,049.47 13976 996 2,436.75 0.0 3,607,866.27   2019-02-01 2019-02-01 0    
NorthTyneside_201903.csv 38,198,065.42 16807 1369 2,272.75 0.0 4,415,635.47   2019-03-01 2019-03-01 0    
NorthTyneside_201904.csv 29,490,280.76 14699 1102 2,006.28 0.0 3,666,305.68   2019-04-01 2019-04-01 0    
NorthTyneside_201905.csv 31,423,744.27 14432 1187 2,177.37 0.0 3,964,113.74   2019-05-01 2019-05-01 0    
NorthTyneside_201906.csv 37,907,889.36 14814 1207 2,558.92 0.0 3,987,540.21   2019-06-01 2019-06-01 0    
NorthTyneside_201907.csv 38,319,168.09 19304 1297 1,985.04 0.0 4,037,388.99   2019-07-01 2019-07-01 0    
NorthTyneside_201908.csv 31,625,450.70 15587 1041 2,028.96 0.0 3,974,603.20   2019-08-01 2019-08-01 0    
NorthTyneside_201909.csv 30,868,349.86 18062 1255 1,709.02 0.0 2,011,995.76   2019-09-01 2019-09-01 0    
NorthTyneside_201910.csv 32,787,759.11 17747 1305 1,847.51 0.0 3,976,516.01   2019-10-01 2019-10-01 0    
NorthTyneside_201911.csv 56,269,480.62 16033 1218 3,509.60 0.0 9,217,120.00   2019-11-01 2019-11-01 0    
NorthTyneside_201912.csv 37,497,815.80 18834 1207 1,990.96 0.0 4,054,070.72   2019-12-01 2019-12-01 0    
NorthTyneside_202001.csv 55,670,409.50 17147 1352 3,246.66 0.0 9,217,120.00   2020-01-01 2020-01-01 0    
NorthTyneside_202002.csv 30,699,903.36 18399 1181 1,668.56 0.0 4,052,493.93   2020-02-01 2020-02-01 0    
NorthTyneside_202003.csv 46,030,818.67 21918 1567 2,100.14 0.0 10,460,000.00   2020-03-01 2020-03-01 0    

Totals: £2,580,419,975.80 from 1,061,541 original records (581,439 actual records) in 75 source files. Tot AvgAmt = £184,610.33

Averages: Amount/file: £34,405,599.68    Orig Records/file: 14,154    AvgAmt mean: 2,461.47    AvgAmt Std Dev: 0.00

LA Range: 2014/01 - 2020/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 North Tyneside has been re-used under the Open Government Licence.