Thursday, 9 May 2013

Londonland rents - a year later

One of the most popular posts on this site, as you can see from the sidebar, is my post from May 2012 about the average rents in each London borough. Admittedly a lot of traffic comes from google sending people here looking for a map of London boroughs, but anyhoo, its still an interesting topic.

Yesterday, on twitter Sarah retweeted comment from Emma Jackson about how rents in London were crazy and average rents in Newham had shot up 39% the last year. Alas this information came from a press release a year ago, but it got me wondering about what rents were like now that the Olympics is firmly in the past, and how rents have changed from last year.

So I dug out my old spreadsheet, went through the rightmove.com property website, and counted up how many two bedroom flats there were in each London borough at each price point, weaved some Excel magic and well here's a list of average rents last year and this year, and their percentage change.

London Borough 10 May 2012 08 May 2013 Change
Redbridge  £      1,080.05  £      1,193.77 110.53%
Hillington  £      1,112.92  £      1,201.08 107.92%
Merton  £      1,581.29  £      1,702.12 107.64%
Bexley  £         858.70  £         914.26 106.47%
Enfield  £      1,135.41  £      1,201.74 105.84%
Croydon  £      1,014.19  £      1,063.27 104.84%
Greenwich  £      1,332.97  £      1,387.40 104.08%
Waltham Forest  £      1,092.00  £      1,134.49 103.89%
Barnet  £      1,419.80  £      1,465.49 103.22%
Barking and Dagenham  £         967.14  £         994.93 102.87%
Ealing  £      1,578.19  £      1,606.16 101.77%
Sutton  £      1,029.41  £      1,046.86 101.70%
Southwark  £      1,840.94  £      1,869.72 101.56%
Hounslow  £      1,785.18  £      1,808.97 101.33%
Lewisham  £      1,224.56  £      1,236.24 100.95%
Kingston Upon Thames  £      1,402.73  £      1,412.13 100.67%
Brent  £      1,483.54  £      1,491.47 100.53%
Hackney  £      1,876.80  £      1,885.32 100.45%
Harrow  £      1,248.56  £      1,253.38 100.39%
Bromley  £      1,127.81  £      1,131.87 100.36%
Havering  £         967.49  £         963.83 99.62%
Kensington and Chelsea  £      2,856.73  £      2,820.08 98.72%
Lambeth  £      1,745.46  £      1,708.09 97.86%
Haringey  £      1,432.51  £      1,401.14 97.81%
Camden  £      2,359.67  £      2,307.76 97.80%
Newham  £      1,410.63  £      1,373.49 97.37%
Islington  £      2,217.82  £      2,139.80 96.48%
Westminster  £      2,796.06  £      2,696.96 96.46%
Wandsworth  £      1,844.08  £      1,756.62 95.26%
Richmond  £      1,927.33  £      1,834.90 95.20%
Hammersmith and Fulham  £      2,102.78  £      1,978.86 94.11%
Tower Hamlets  £      2,066.11  £      1,942.07 94.00%
City of London  £      2,817.34  £      2,474.32 87.82%

So, nothing too exciting there. From the raw data, it seems the increases and decreases Redbridge, Hillington, Tower Hamlets and City of London are caused mainly by either loads more properties coming onto the market since last year, or fewer properties being available.

On the whole, property in desirable boroughs is still more expensive than property in less desirable boroughs. Desirability here is mostly proximity to the centre of the capital city of the UK, which isn't really surprising. Kensington, Westminster, and City of London are still most expensive. Havering, Barking and Bexley are still the cheapest boroughs to rent in.

The average change in average rents for two bedroom flats since this time last year for the whole of London, by my calculations is about half a percent, so within the margin of error for the data.

Sunday, 5 May 2013

Thick Creamy Podcast 30-04-2013

Here's the eighteenth Thick Creamy Podcast, three bands recorded live from the Fortuna Pop night at The Bull and Gate in Kentish Town.


The podcast features tracks from The Fireworks, Cosines and The Understudies.

Sadly I missed most of the first band of the night, The Listening Party, they played loud and with great gusto, they certainly sounded like they were having fun.

The Fireworks in a introspective moment
The second band up were The Fireworks, who were wonderful. Its been about a year since I last saw them, a richer tapestry of sounds, fuzz and feedback with more introspective moments.

Then there were Cosines who were lovely. At this point I find myself asking is an individual member of the band called a Cosine? Who's your favourite Cosine? etc.

As I become more familiar with their songs favourites bubble to the top, I loved the crazy wigout end to the first song in the set, and third song along 'Commuter Love' is a classic.

I've just finished reading this book about post-punk music and the music DIY culture of the early 1980's and I wonder, why aren't bands like The Fireworks and Cosines a lot bigger and more successful, I mean, how long should it take?

And finally were The Understudies who were great, this was the first time I'd seen them since the lineup change, and you know, I think its a bit of an improvement. Although I've seen them play live countless times (well, six times according to Songkick) this was the first time I've really listened to them and they're better than I previously thought. Now the tunes stick in your mind, and the snapshots of contemporary life, are filled with humour, sadness, pathos, and dreams.

I think my favourite Understudies track is 'A Girl I Used To Muck About With'. It sounds like snowfall in Worsley Woods in 1996.

Sometimes I want to chomp a cigar and march up to band and demand the let me out their record out. Then I remember what happened last time, and think perhaps not.

Its possible to subscribe to these Thick Creamy Podcasts on iTunes so they download automagically every time I put up a new one. Simply go into the 'Advanced' menu in iTunes, click 'Subscribe to Podcast' and then paste in this rss feed


http://feeds.feedburner.com/ThickCreamyPodcast

and that should give you all the podcasts, forever.

Tuesday, 9 April 2013

Thick Creamy Podcast 30-03-2013

Here's the seventeenth Thick Creamy Podcast, featuring bands playing live at Stereo in Glasgow at The Plimptons All Day Farewell Party

The cream of Glasgow's music scene had gathered for the end of an era, and the beginning of a new Post-Plimptopolypse epoch of humanity.

The podcast features tracks from Eddy and the T-Bolts, Colonel Mustard and the Dijon 5 and of course, The Plimptons.

Colonel Mustard and the Dijon 5 and their mighty horn section

Colonel Mustard and the Dijon 5 and their feisty backing singers

Martin Plimpton - crowd surfer extrordinaire

Adam Plimpton riding the crowd away from the stage

Its possible to subscribe to these Thick Creamy Podcasts on iTunes so they download automagically every time I put up a new one. Simply go into the 'Advanced' menu in iTunes, click 'Subscribe to Podcast' and then paste in this rss feed


http://feeds.feedburner.com/ThickCreamyPodcast

and that should give you all the podcasts, forever.

Sunday, 7 April 2013

Thick Creamy Podcast 29-03-2013

Here's the sixteenth Thick Creamy Podcast, bands playing live at the Sounds XP Easter alldayer and me talking.


The bands were recorded live at the Windmill in Brixton, there were loads of bands playing, but I only taped four of them; Simon Love, No Cars, Viv Albertine and Big Wave.

Please enjoy.


Its possible to subscribe to these Thick Creamy Podcasts on iTunes so they download automagically every time I put up a new one. Simply go into the 'Advanced' menu in iTunes, click 'Subscribe to Podcast' and then paste in this rss feed

http://feeds.feedburner.com/ThickCreamyPodcast

and that should give you all the podcasts, forever.

Sunday, 24 March 2013

No More Page 3 and the Tabloid Monstering of Lucy Meadows

Oh, I used to have a passion for blogging. I used to churn out writings all hours of the day on all topics that bubbled up, from the state of my jobbies, to the vagaries of the UK jobs market. I used to think it all meant something, that it was gently prodding my readers and society in some positive direction.

But as I've grown older, and faced the trauma of unemployment and just plain getting on with life, its all faded away. I no longer have the passion to write.

Other people do.

I still read blogs, I still click on links on twitter, but its all like a sheet of tracing paper has been placed over it all, its all opaque. Its less meaningful. Its just plain wrong.

Moments ago the member of parliament for West Bromwich East, Tom Watson re-tweeted a link to the No More Page 3 campaign's blog.

At this point I should point out that I don't buy The Sun newspaper, and when it is the only newspaper lying around in the canteen at work, I skip past page 3. Although, I fully appreciate that it is the most popular newspaper in the UK and that it arguably represents a centrist political viewpoint.

Anyhoo, the thrust of the No More Page 3 campaign blogpost seems to be that if only The Sun newspaper stopped publishing photos of topless women on page three then 13 to 16 year old girls wouldn't have their skirts lifted by teenage boys in the queue at the school canteen.

I think this is foolish. There's plenty of nudity and objectifying women in every other newspaper and magazine. The are plenty of websites that offer nudity for free.

Stopping page three will do nothing to stop teenage boys lifting girl's skirts.

Why are schools tolerating sexual abuse in their canteens? Why aren't teachers and headmasters disciplining teenage boys and educating them in the acceptable ways to behave in polite society.

What makes a 16 year old girl think that banning a page in a newspaper will change the behaviour of teenage boys? Its just so tenuous that it astounds me.

Does the member of parliament for West Bromwich East actually agree and believe that if The Sun newspaper stopped printing titties in their newspaper then it would affect the behaviour of teenage boys? Does he actually think this?
Does he really think that cause and effect work like this?
Is this really the sort of belief that the residents of West Bromwich East want in their representative in parliament?

I spent most of this morning investigating the tabloid monstering of Lucy Meadows. There's a variety of petitions out at the moment lobbying for the Daily Mail to sack their columnist Richard LittleJohn.

At this point I should point out that I don't buy the Daily Mail newspaper, and on the rare occasions where I have the opportunity and inclination to read it, I usually skip past the columnist pages. Although I do appreciate that its the second most popular newspaper in the UK.

I'm still unclear as to what degree Richard Littlejohn monstered Lucy Meadows. He wrote a column about her, but the press intrusion that she complained about wasn't about opinion pieces, it was closer to home. She wrote a series of emails to a friend as follows (source):
I was lucky to have a supportive head, but I think I’d have done it here regardless as I couldn’t put it off any longer and I have family and financial commitments as well. The guidance I’ve had from the trans community has been generally sound and very much appreciated, and I’d like to be able to say I’ve given something back. I suppose the best way for me to do this would be to educate the people around me and children at school – I am a teacher after all!
[...]
I know the press offered parents money if they could get a picture of me.
[...]
I became pretty good at avoiding the press before Christmas. I live about a three-minute walk from school so they were parked outside my house as well as school. I’m just glad they didn’t realise I also have a back door. I was usually in school before the press arrived and stayed until late so I could avoid them going home.
[...]
[M]any parents have been quite annoyed with the press, too, especially those that were trying to give positive comments but were turned away.
Richard Littlejohn isn't a reporter, the sort of intrusion that Lucy was talking about seems to be the work of people like:-


I see no petitions calling for these people to be sacked.

Even if Littlejohn's career did meet an untimely demise, then Lisa Woodhouse, Stuart Pike, James Tozer and Nazia Parveen would still camp on people's doorsteps, and wait outside their places of work, and hassle parents for photos and juicy details. At no point in their line of work would they think, "I better not do this, remember what happened to Littlejohn". That isn't going to cross their mind, ever.

Here's a picture of Stuart Pike, and presumably his wife Alia Pike, that I grabbed from his Facebook page. How much guilt does his feel for the death of Lucy Meadows? Is he wondering if he'd done something different, Lucy would still be alive, the pupils of St Mary Magdalen's School in Accrington wouldn't be mourning the loss of a popular teacher.

This is Lisa Woodhouse from the Lancashire Telegraph, I ripped her photo from her twitter account, although for a journalist, she doesn't tweet much. I can't find her on Facebook, so I'm guessing she's got something to hide.

This is 30 year old Nazia Parveen from The Daily Mail, I ripped her photo from twitter. She was named Young Journalist of the year in 2011, when she worked at the Lancashire Telegraph. Her prize for being a young journalist was £500 and a week's work experience at The Daily Mail, presumably they liked her work.

Anyhoo, my point is, that rather than tenuously going for trophy heads on spikes to change behaviour and society, people should be going for the people who commit the offences.

If 16 year old boys are abusing 16 year old girls, then discipline the specific 16 year old boys rather than signing a petition about a page in a newspaper.

If tabloid reporters are hassling someone to the point of suicide, then have a go at the tabloid reporters who are doing the hassling, rather than signing a petition about a page in a newspaper.

*** UPDATE1 *** 24/03/2013 13:44
Just to be sure, I used twitter:-


Eagerly awaiting a response.

*** UPDATE2 *** 24/03/2013 15:17
Looking through other tabloids for reporters who may have monstered Lucy Meadows, I find that in The Mirror, reporter Steve White reports Lucy Meadows's death with the headline "Nathan Upton: Sex-change teacher found dead at 32".

Its a little unclear why Steve White is referring to Lucy as Nathan, when the main thrust of the story, of both the sex change and the suicide, is that Lucy wished to be referred to as Lucy, not Nathan.

Monday, 7 January 2013

2012 in numbers

Just a tote of various personal numbers and statistics from last year. Could really do with being an infographic, maybe later.


Weight change
+6 Kg

Distance walked or run (exercise)
385 miles
(164 miles in 2011)

Distance travelled by car
8197 miles (5803 miles approx in 2011)

Petrol Spend
£1014.85 - 758 litres
(£724.00 in 2011)

Foot/car ratio
1:21
(1:35 in 2011)

Distance flown
2876 miles

CO2 emissions from travel
1587 Kg
(Air - @0.21 Kg/mile; Road - @0.115 Kg/mile; Foot - @0.105 Kg/mile)

Change in wealth
+£6393.93
(+£5389.49 in 2011)

Stocks & Shares change
+9.58%

Gigs attended
20
(15 in 2011)

Gigs played
1
(nil in 2011)

Songs recorded
3

Programming, markup and scripting languages used
8 (Java, Javascript, Python, html, php, SQL, R, CSS)

Xbox games completed
7

Websites created
4

Website unique visitors
13600

Items knitted or crocheted
5

Thursday, 6 December 2012

Starbucks and lower prices


I had this idea the other day over lunch, a frothing at the mouth libertarian Ayn Rand kind of thought about multinational companies and tax, and the sanction of the victim.

The idea was that Starbucks, instead of giving the government a voluntary donation of £10 million, should instead reduce their prices by whatever the amount that they are being accused of avoiding. So the money stays in their customers pockets and the HMRC, the taxman is cut out of the equation. I thought it was a fine idea.

Besides, don't businesses usually expect something in return when they give the government voluntary donations? It seems a bit corrupt if you ask me, there should be no place for it in government.

Elsewhere, a Times journalist called Alexi Mostrous claimed that it was "One Reuters story reut.rs/Xcs29h yields £10m to UK taxpayer..." somehow equating paying money to the tax man was the same as paying money to the taxpayer. I had a bit of a rant at him, the taxpayer is the complete opposite of the taxman. Alexi has it completely the wrong way round, money that goes to the taxman is explicitly not the taxpayers, it ceases to be the taxpayer's money as soon as it is paid. That's what tax is, money that no longer belongs to the taxpayer.

Anyhoo, cast your mind back to my second paragraph, maybe this is what businesses already do, they keep their prices as low as possible, to keep money in people's pockets as any excess money, profits, would go to the taxman, and thus be of no use to the business.

Businesses strive for perfect balance between prices, turnover, profits and tax. If any of these things chance then the business becomes unbalanced.

Anyhoo, just to very carefully remove any doubt from the reader's mind, I believe that businesses (and people) should pay the exact amount of tax they owe, and not a penny more, nor a penny less.

And there hangs a problem.

For personal banking I don't have an ISA savings account, I just have a regular savings account. So I pay tax on any interest I receive. If I moved my money into an ISA then I could avoid some tax, but that would be morally wrong.

I have a free choice here, and I choose to pay all the tax that I owe.

Monday, 19 November 2012

The neverending awesomeness of Indiepop Eyespy

Days have past, hundreds have died elsewhere in the world, but still I keep on hammering away at my keyboard. I keep on pushing, keep on fighting for something I believe in, something I've fought for for years, and that is Indie Eyespy.

Here try this
London Indiepop Eyespy

What you've got there may look pretty basic, but under the hood I've pushed the envelope of my skills. Its got html, JavaScript, php and MySQL.

It even looks pretty good when you view the source.

The list of bands and band members comes from a database that's 5 Normal Form, so the same person can be worth more points depending on what band they're in.

Now I just need to add a few more bands, and use the magic of CSS3 to make it look pretty.

And also do something slightly different for dealing with scenesters, promoters and DJs who aren't necessarily in any bands.

And then maybe I can work on adding a highscore table, and maybe a page to add new bands and band members, and then a special thing that looks up how many listeners each band has on last.fm and splits them into divisions based on how popular they are.

Thursday, 15 November 2012

Order of the day


I've given some thought to what order to have the bands on the London Indiepop Eyespy website, this is another form over function problem.

Its got to be easy to use, easy to find the scensters that users want to claim points for.

This suggests alphabetical order for all the bands. This wouldn't be a problem if there were only two pages of bands. But if we're listing band members, that would be less than ten bands in total.

Besides, from my experience with the Skilmo site, people don't really want to work through a long list of bands, it puts people off using the site, their attention wanders and I've lost a scenester.

Back in the dusty days of Glasgow Indie Eyespy, the hundred or so bands of the Glasgow indie scene were split into about half a dozen divisions based on popularity, so in the premiership you'd find Franz Ferdinand, the Belles, the Obscuras, the Mogwai, in the first division you'd find the Felt Tips, The Plimptons, Wake The President etc. Scenesters could intuitively know where to look for the bands.

Which divisions the bands were in was a carefully calculated algorithm based on last.fm, technorati and MySpace data, but those vectors aren't really appropriate this decade for the twenty or so London Indiepop bands.

Sure I could work out some kind of popularity rankings, but having bands in divisions doesn't look nice if all the band members are listed. Alternatively, the site could list the bands and then expand to list the members once you've clicked on the name, but that's not very satisfactory.

I'm having real doubts about the viability of the website at this stage, I can't envisage people using it.

Doubts aside, if we look at the sort of sites I'm hoping to ape, like Last.fm and Songkick, they don't have alphabetical lists of bands, they intuitively know what band names you want to see, they don't have lists that you have to wade through.

So, with the tools I have available, what would Phil Cowans and Gideon Bullock do? What would Russ Garrett do?

Something like this?

Wednesday, 14 November 2012

Getting all Fifth Normal Form on your ass


I've been reading up on database normalisation and thinking about how the London Indiepop Eyespy website would work.

Data normalisation is incredibly interesting, but not quite as important as what the site looks like, form dictates function here.

In the original pub game of indie eyespy, you'd spot a band member then look up how many point they are worth.

There's Stuart Murdoch from Belle and Sebastian, four points!

As many of the bands are quite obscure, it would be less likely that you'd know the names of band members, but you could still get points for identifying the person.
There's wassisname the drummer from Camera Obscura, would be worth the same as correctly remembering his name was Lee. Although, if playing indie eyespy competitively with friends, the person who get his name would claim the points.

So here we have the dilema for a website, what should it list:-

  • Check boxes for each band member by name for each band
  • Check boxes for numbered members for each band
  • Text box for number of members spotted and leave the rest to banter

With the limitless possibilities of computing power, I'm tempted to go for option one, and make life easier for folk who can't remember names

As bands evolved and lineups changed so did the way points were allocated, for example spotting Gav from Camera Obscura would get you three points, but if you instead noted it was Gav the bass player from Stabiliser, it would be five points. However, you couldn't then claim eight points for identifying him as playing in both bands. You only get points for one person once.

So the website would need a way of dealing with the same person in many bands.

With the Skilmo website, this sort of problem was easily resolved when it processed the checklist page, each skill was only logged once, for example tunisian crochet only counted once if you clicked it in both the textile arts category and the crochet category because the program ignored categories when logging stuff.

But with indie eyespy, because of the different points values this isn't possible, and rather awesomely, this is precisely in what 5th Normal Form is about in database normalisation theory.

On the database side of things I'd need three tables:-

  • List of people and their nominal point values
  • List of bands and their points values
  • List of which people are in which bands

Then every time the website is accessed a list is constructed by SQL of bands and their members and points values.

Then with PHP an html page is generated which displays this list, with form checkboxes and also generates so neat JavaScript which greys out people who play in different bands when you select them.

Then submitting this form should post a list of people and their points values.

The next page would get a list of the people in the database, and run through the posted data, tote up the score, and log the score.

That seems to work in my head.

Of course the list of names will be normalised with id numbers to cover for there being more than one person with the same name, and same with the list of bands.

The list of bands also needs a status column for whether a band is currently active, on haitus or split up. Cos, of course, active bands are worth more points than bands that are on haitus, but not as much as a band who split up in 1989.

And the list of which people are in which bands needs a column indicating former band members. Because, as I'm sure you understand, spotting the original guitarist from Pocketbooks is worth more points than the current guitarist.