Summary of currently loaded LA spend data for : Hounslow

Lastfile: Hounslow_202101     LA spend page opens in new window
Sourcefile name Total Amount £ OrigRecs AggRecs AvgAmt£ AAZ   MaxAmt £     MinDate MaxDate Dif     Comment
Hounslow_201101.csv 16,299,317.67 2790 0 5,842.05 0.0 888,433.17   2011-01-04 2011-01-31 0    
Hounslow_201102.csv 16,568,411.66 3685 0 4,496.18 0.0 888,433.17   2011-02-02 2011-02-28 0    
Hounslow_201103.csv 20,302,068.95 3710 0 5,472.26 0.0 885,879.84   2011-03-02 2011-03-31 0    
Hounslow_201104.csv 19,693,678.44 3959 0 4,974.41 0.0 837,737.06   2011-03-16 2011-04-28 1    
Hounslow_201105.csv 13,588,776.17 2341 0 5,804.69 0.0 837,707.06   2011-05-04 2011-05-31 0    
Hounslow_201106.csv 18,725,902.22 3679 0 5,089.94 0.0 880,229.68   2011-06-01 2011-06-30 0    
Hounslow_201107.csv 15,063,613.78 2848 0 5,289.19 0.0 967,550.00   2011-07-01 2011-07-29 0    
Hounslow_201108.csv 16,715,512.57 3433 0 4,869.07 0.0 896,453.77   2011-08-01 2011-08-31 0    
Hounslow_201109.csv 14,392,225.25 2609 0 5,516.38 0.0 896,453.77   2011-09-05 2011-09-29 0    
Hounslow_201110.csv 16,840,582.54 3208 0 5,249.56 0.0 895,248.44   2011-10-03 2011-10-31 0    
Hounslow_201111.csv 16,891,413.58 3234 0 5,223.07 0.0 896,084.89   2011-11-01 2011-11-30 0    
Hounslow_201112.csv 10,434,109.28 2360 0 4,421.23 0.0 895,953.77   2011-12-01 2011-12-31 0    
Hounslow_201201.csv 18,840,763.14 3784 0 4,979.06 0.0 896,453.77   2012-01-03 2012-01-31 0    
Hounslow_201202.csv 16,944,866.08 3599 0 4,708.22 0.0 896,453.77   2012-02-01 2012-02-29 0    
Hounslow_201203.csv 13,946,477.33 3413 0 4,086.28 0.0 896,453.77   2012-03-01 2012-03-30 0    
Hounslow_201204.csv 22,006,466.04 4192 0 5,249.63 0.0 896,453.77   2012-04-02 2012-04-30 0    
Hounslow_201205.csv 18,119,691.32 3097 0 5,850.72 0.0 983,524.00   2012-05-02 2012-05-31 0    
Hounslow_201206.csv 14,996,938.83 3108 0 4,825.27 0.0 491,515.54   2012-06-01 2012-06-29 0    
Hounslow_201207.csv 17,865,345.69 3292 0 5,426.90 0.0 877,244.63   2012-07-02 2012-07-31 0    
Hounslow_201208.csv 15,675,855.92 3302 0 4,747.38 0.0 1,020,389.10   2012-08-01 2012-08-30 0    
Hounslow_201209.csv 16,097,616.12 3057 0 5,265.82 0.0 906,992.22   2012-09-02 2012-09-27 0    
Hounslow_201210.csv 20,664,490.48 4033 0 5,123.85 0.0 902,968.24   2012-10-01 2012-10-31 0    
Hounslow_201211.csv 14,947,214.89 3309 0 4,517.14 0.0 491,515.54   2012-11-02 2012-11-30 0    
Hounslow_201212.csv 16,859,790.95 3653 0 4,615.33 0.0 906,422.88   2012-12-02 2012-12-27 0    
Hounslow_201301.csv 11,332,232.93 2531 0 4,477.37 0.0 869,979.71   2013-01-07 2013-01-31 0    
Hounslow_201302.csv 14,295,549.90 2942 0 4,859.13 0.0 1,109,947.80   2013-02-04 2013-02-28 0    
Hounslow_201303.csv 15,585,134.58 2836 0 5,495.46 0.0 857,867.28   2013-03-01 2013-03-28 0    
Hounslow_201304.csv 14,112,570.08 2900 0 4,866.40 0.0 1,079,007.78   2013-04-02 2013-04-29 0    
Hounslow_201305.csv 19,575,644.42 2785 0 7,028.96 0.0 1,413,491.36   2013-05-01 2013-05-31 0    
Hounslow_201306.csv 11,351,823.45 2405 0 4,720.09 0.0 1,109,968.00   2013-06-02 2013-06-28 0    
Hounslow_201307.csv 15,685,595.88 3348 0 4,685.06 0.0 1,081,734.78   2013-07-01 2013-07-31 0    
Hounslow_201308.csv 18,461,439.00 2556 0 7,222.79 0.0 1,166,105.15   2013-08-01 2013-08-29 0    
Hounslow_201309.csv 19,329,695.26 2570 0 7,521.28 0.0 1,098,502.54   2013-09-01 2013-09-30 0    
Hounslow_201310.csv 18,527,530.83 3103 0 5,970.84 0.0 1,458,829.48   2013-10-02 2013-10-31 0    
Hounslow_201311.csv 14,377,670.38 1999 0 7,192.43 0.0 1,195,914.45   2013-11-04 2013-11-28 0    
Hounslow_201312.csv 16,942,366.76 2842 0 5,961.42 0.0 1,186,842.99   2013-12-02 2013-12-24 0    
Hounslow_201401.csv 15,613,359.64 2469 0 6,323.76 0.0 1,308,879.22   2014-01-02 2014-01-30 0    
Hounslow_201402.csv 19,226,048.67 2567 0 7,489.70 0.0 1,492,998.04   2014-02-03 2014-02-28 0    
Hounslow_201403.csv 20,761,870.69 2842 0 7,305.37 0.0 1,250,112.26   2014-03-03 2014-03-31 0    
Hounslow_201404.csv 24,785,095.63 2593 0 9,558.46 0.0 2,954,167.00   2014-04-02 2014-04-30 0    
Hounslow_201405.csv 12,990,565.49 1857 0 6,995.46 0.0 1,348,919.60   2014-05-01 2014-05-31 0    
Hounslow_201406.csv 31,355,009.42 3031 0 10,344.77 0.0 2,954,167.00   2014-06-02 2014-06-30 0     Jump in Total Amt. Analysis
Hounslow_201407.csv 20,030,980.91 2803 0 7,146.27 0.0 1,551,017.64   2014-07-01 2014-07-31 0    
Hounslow_201408.csv 16,166,638.57 1951 0 8,286.33 0.0 1,854,994.56   2014-08-04 2014-08-28 0    
Hounslow_201409.csv 23,929,491.06 2441 0 9,803.15 0.0 1,875,112.44   2014-09-01 2014-09-29 0    
Hounslow_201410.csv 27,121,358.99 3444 0 7,874.96 0.0 1,409,524.18   2014-10-01 2014-10-31 0    
Hounslow_201411.csv 16,307,493.15 2138 0 7,627.45 0.0 1,642,822.46   2014-11-03 2014-11-27 0    
Hounslow_201412.csv 21,959,484.93 2427 0 9,048.00 0.0 1,413,812.73   2014-12-01 2014-12-24 0    
Hounslow_201501.csv 14,420,083.72 2686 0 5,368.61 0.0 1,360,756.47   2015-01-06 2015-01-30 0    
Hounslow_201502.csv 17,586,893.84 2640 0 6,661.70 0.0 1,490,803.38   2015-02-04 2015-02-27 0    
Hounslow_201504.csv 18,160,688.25 2596 0 6,995.64 0.0 1,108,597.25   2015-04-01 2015-04-29 0    
Hounslow_201505.csv 27,434,653.92 3220 0 8,520.08 0.0 1,514,115.11   2015-05-01 2015-05-29 0    
Hounslow_201506.csv 24,825,099.86 2841 0 8,738.16 0.0 1,763,839.71   2015-06-01 2015-06-30 0    
Hounslow_201507.csv 20,964,289.68 3041 0 6,893.88 0.0 1,482,106.94   2015-07-01 2015-07-31 0    
Hounslow_201508.csv 19,303,257.47 2057 0 9,384.18 0.0 1,535,068.01   2015-08-04 2015-08-28 0    
Hounslow_201509.csv 21,352,216.95 3059 0 6,980.13 0.0 1,522,533.96   2015-09-01 2015-09-29 0    
Hounslow_201510-11.csv -4,161,386.21 5428 0 -766.65 0.0 1,533,870.46   2015-10-01 2015-11-27 1     Large drop in Total Amt. Analysis
Hounslow_201512.csv 23,186,299.25 2467 0 9,398.58 0.0 2,034,375.00   2015-12-01 2015-12-24 0     Large drop in Total Amt. Analysis
Hounslow_201601.csv 18,125,719.79 2253 0 8,045.15 0.0 1,512,954.96   2016-01-01 2016-01-29 0    
Hounslow_201602.csv 14,697,090.03 1957 0 7,510.01 0.0 1,589,106.29   2016-02-02 2016-02-29 0    
Hounslow_201603.csv 26,029,445.82 2944 0 8,841.52 0.0 1,533,480.70   2016-03-01 2016-03-31 0    
Hounslow_201604.csv 26,195,564.00 3066 0 8,543.89 0.0 1,571,719.76   2016-04-01 2016-04-29 0    
Hounslow_201605.csv 20,091,133.18 2346 0 8,564.00 0.0 1,587,158.59   2016-05-03 2016-05-31 0    
Hounslow_201606.csv 17,364,320.33 2181 0 7,961.63 0.0 1,611,427.43   2016-06-01 2016-06-30 0    
Hounslow_201607.csv 22,872,696.44 2421 0 9,447.62 0.0 1,609,946.42   2016-07-01 2016-07-31 0    
Hounslow_201608.csv 20,151,186.38 2350 0 8,574.97 0.0 1,621,291.06   2016-08-02 2016-08-30 0    
Hounslow_201609.csv 21,682,977.09 2125 0 10,203.75 0.0 1,646,401.40   2016-09-01 2016-09-30 0    
Hounslow_201610.csv 24,771,999.01 2484 0 9,972.62 0.0 1,606,632.28   2016-10-04 2016-10-31 0    
Hounslow_201611.csv 48,899,278.60 4609 0 10,609.52 0.0 1,695,500.00   2016-10-04 2016-11-30 1    
Hounslow_201612.csv 47,953,766.64 4296 0 11,162.42 0.0 4,727,000.00   2016-11-01 2016-12-31 1    
Hounslow_201701.csv 20,607,715.93 2168 0 9,505.40 0.0 1,625,448.15   2017-01-03 2017-01-31 0    
Hounslow_201702.csv 21,180,059.99 2124 0 9,971.78 0.0 1,695,500.00   2017-02-02 2017-02-28 0    
Hounslow_201703.csv 27,358,097.05 2610 0 10,482.03 0.0 1,673,168.27   2017-03-01 2017-03-31 0    
Hounslow_201704.csv 27,898,153.69 1809 0 15,421.86 0.0 4,224,264.00   2017-04-04 2017-04-30 0    
Hounslow_201705.csv 27,977,598.53 2172 0 12,881.03 0.0 1,712,280.47   2017-05-03 2017-05-30 0    
Hounslow_201706.csv 23,209,080.74 2072 0 11,201.29 0.0 1,711,252.37   2017-06-01 2017-06-30 0    
Hounslow_201707.csv 22,542,184.67 1925 778 11,710.23 0.0 2,776,506.11   2017-07-01 2017-07-01 0    
Hounslow_201708.csv 23,770,956.02 2090 873 11,373.66 0.0 2,501,149.13   2017-08-01 2017-08-01 0    
Hounslow_201709.csv 26,024,944.96 1774 764 14,670.21 0.0 3,137,511.21   2017-09-01 2017-09-01 0    
Hounslow_201710.csv 24,478,990.71 1998 787 12,251.75 0.0 3,058,896.00   2017-10-01 2017-10-01 0    
Hounslow_201711.csv 25,758,744.23 1931 727 13,339.59 0.0 2,888,288.41   2017-11-01 2017-11-01 0    
Hounslow_201712.csv 21,505,220.23 1901 803 11,312.58 0.0 2,653,050.00   2017-12-01 2017-12-01 0    
Hounslow_201801.csv 30,569,616.66 2404 931 12,716.15 0.0 4,431,374.00   2018-01-01 2018-01-01 0    
Hounslow_201802.csv 25,821,335.90 2474 969 10,437.08 0.0 2,656,196.00   2018-02-01 2018-02-01 0    
Hounslow_201803.csv 30,295,710.43 2554 987 11,862.06 0.0 5,621,750.00   2018-03-01 2018-03-01 0    
Hounslow_201804.csv 19,563,323.10 2151 824 9,094.99 0.0 2,183,937.98   2018-04-01 2018-04-01 0    
Hounslow_201805.csv 23,119,248.17 2469 932 9,363.81 0.0 1,809,929.22   2018-05-01 2018-05-01 0    
Hounslow_201806.csv 18,855,284.75 1885 709 10,002.80 0.0 2,546,697.52   2018-06-01 2018-06-01 0    
Hounslow_201807.csv 19,775,215.40 2170 816 9,113.00 0.0 1,786,864.12   2018-07-01 2018-07-01 0    
Hounslow_201808.csv 27,448,906.73 2082 729 13,183.91 0.0 2,042,697.52   2018-08-01 2018-08-01 0    
Hounslow_201809.csv 22,912,963.79 1674 666 13,687.55 0.0 3,114,500.00   2018-09-01 2018-09-01 0    
Hounslow_201810.csv 24,379,156.20 2161 908 11,281.42 0.0 1,884,639.77   2018-10-01 2018-10-01 0    
Hounslow_201811.csv 19,349,414.27 1940 765 9,973.92 0.0 1,783,995.58   2018-11-01 2018-11-01 0    
Hounslow_201812.csv 16,666,306.66 1808 735 9,218.09 0.0 1,783,424.68   2018-12-01 2018-12-01 0    
Hounslow_201901.csv 26,347,640.16 2059 759 12,796.33 0.0 2,042,697.52   2019-01-01 2019-01-01 0    
Hounslow_201902.csv 81,865,415.28 2293 945 35,702.32 0.0 56,600,000.00   2019-02-01 2019-02-01 0     Large jump in Total Amt. Analysis
Hounslow_201903.csv 22,124,737.97 2185 842 10,125.74 0.0 1,902,619.76   2019-03-01 2019-03-01 0     Drop in Total Amt. Analysis
Hounslow_201904.csv 19,963,644.04 2146 854 9,302.72 0.0 1,802,762.92   2019-04-01 2019-04-01 0    
Hounslow_201905.csv 27,882,995.23 2400 865 11,617.91 0.0 2,442,784.00   2019-05-01 2019-05-01 0    
Hounslow_201906.csv 18,146,968.73 1847 738 9,825.10 0.0 1,819,431.75   2019-06-01 2019-06-01 0    
Hounslow_201907.csv 18,363,724.70 2057 796 8,927.43 0.0 1,928,062.13   2019-07-01 2019-07-01 0    
Hounslow_201908.csv 27,907,407.91 2233 870 12,497.72 0.0 2,703,000.00   2019-08-01 2019-08-01 0    
Hounslow_201909.csv 14,746,105.34 1494 572 9,870.22 0.0 1,859,363.11   2019-09-01 2019-09-01 0    
Hounslow_201910.csv 32,662,439.48 2242 894 14,568.44 0.0 3,666,370.68   2019-10-01 2019-10-01 0     Jump in Total Amt. Analysis
Hounslow_201911.csv 24,183,845.97 2166 1032 11,165.21 0.0 1,845,434.61   2019-11-01 2019-11-01 0    
Hounslow_201912.csv 26,418,785.02 2028 742 13,027.01 0.0 5,887,760.00   2019-12-01 2019-12-01 0    
Hounslow_202002.csv 23,152,931.33 2240 986 10,336.13 0.0 1,987,006.86   2020-02-01 2020-02-01 0    
Hounslow_202003.csv 26,177,317.08 2480 1040 10,555.37 0.0 1,906,855.19   2020-03-01 2020-03-01 0    
Hounslow_202004.csv 52,379,882.68 3813 810 13,737.18 0.0 20,530,000.00   2020-04-01 2020-04-01 0     Jump in Total Amt. Analysis
Hounslow_202005.csv 29,512,747.57 2908 688 10,148.81 0.0 10,380,000.00   2020-05-01 2020-05-01 0    
Hounslow_202006.csv 35,046,142.73 2429 734 14,428.22 0.0 2,895,000.00   2020-06-01 2020-06-01 0    
Hounslow_202007.csv 22,942,958.51 2267 666 10,120.41 0.0 2,715,000.00   2020-07-01 2020-07-01 0    
Hounslow_202008.csv 29,337,321.06 2079 715 14,111.27 0.0 1,896,970.00   2020-08-01 2020-08-01 0    
Hounslow_202009.csv 23,287,707.55 2119 725 10,989.95 0.0 2,118,022.38   2020-09-01 2020-09-01 0    
Hounslow_202010.csv 34,406,826.50 2546 835 13,514.07 0.0 2,334,152.62   2020-10-01 2020-10-01 0    
Hounslow_202011.csv 30,241,649.35 3100 844 9,755.37 0.0 1,844,766.37   2020-11-01 2020-11-01 0    
Hounslow_202101.csv 31,055,873.17 3437 854 9,035.75 0.0 2,118,022.38   2021-01-01 2021-01-01 0    

Totals: £2,583,436,349.73 from 311,056 original records (252,606 actual records) in 117 source files. Tot AvgAmt = £1,027,274.88

Averages: Amount/file: £22,080,652.56    Orig Records/file: 2,659    AvgAmt mean: 8,780.13    AvgAmt Std Dev: 0.00

LA Range: 2011/01 - 2021/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 Hounslow has been re-used under the Open Government Licence.