But there's an even better way in. This table (.csv format) has all the protected designation products listed out by commune. And of course we have election results by commune. So it should be pretty easy. data.gouv.fr/fr/datasets/ai…
Stick it together with that in Excel.
Results are in. Top AOC for Macron is from the commune of Le Clat (11140) a tiny village in Aude département, in Occitanie, in French Catalonia. 43 registered voters. 25 voted for Macron, 1 was a blank vote, 0 for Le Pen.
Oops, got my numbers wrong there. only 31 registered voters. 25 voted for Macron. 1 Blank. 0 for Le Pen. Anyway. The rest is right. But thinking about it, maybe I need to up the quality. Require a top tier AOC. I'll do Le Pen's now and think again.
Flammerécourt (52110) in Grand-Est. Quality sparkling wine. 57 registered voters. 48 votes. 1 for Macron (absolute LOL at this village trying to figure out the splitter 🤣). 1 spoiled. 46 for Le Pen.
France is varied eh?
This will need a rethink.
Right. We go again. This time a map. Much less efficient, but built in vibe checks make it less likely I'll mess up, and it should help me refine the question. And this time I'm just looking at AOC wines. But where is Champagne?!?! data.gouv.fr/fr/datasets/de…
Okay. This is another way in. Get each AOC Wine, add up all the votes for its communes. That way the two winners are ones I can actually buy. And who cares about Champagne. I'll figure out why that's missing some other day.
Looking good. Especially for Le Pen. Crikey. Some BIG names in there. Saint-Estèphe, Chablis, Châteauneuf-du-Pape, Pauillac. It's as we'd guess. The Loire for Macron. The Rhône for Le Pen.
I'm going to have to pick ones I can purchase (so not Clairette). So I'll go red. Le Pen's two are gonna be Cotes Du Rhone Villages Plan De Dieu and a Saint Estephe (£££s eek). Macron's --- oh dear,...
I am not to be able to justify that purchase I don't think. Understanding this "President of the Rich" thing now TBH.
Yeah that's not happening Macron.
A lot of prime Burgundy is Macron territory, I didn't realise. I guess it's rich people. The Loire being Macron was expected. I'd have though Bordeaux would be too, but Le Pen is strong in some parts. I think I'd best put this on a map.
People asking after the Crémants. Crémant de Loire is your Macron choice. Crémant de Limoux (the original sparkling wine) is your Le Pen choice.
Well there we are. Yet again with apologies to Champagne, I'll try and fix you another day. I'm using the standard colours, Yellow = Macron, Le Pen = Dark Blue. Here around Angers is dominant Macron wine country. Chablis goes for Le Pen. Big choices.
The lower Rhône is all Le Pen, but Clairette de Die just a bit higher up and off the river a bit is strong Macron. As for Bordeaux, well.
The former bulk wine areas in Languedoc are very Le Pen. Perhaps a desire for protection against cheaper Spanish bulk wine. It's an anti-globalisation sentiment that I can understand. French wine growers want French to drink French wine like in the past. theguardian.com/lifeandstyle/2…
The decline in French alcohol consumption is just astonishing. The average French person drinks less than a quarter as much wine today as they did in the 1960s. And look at that cidre decline.
Did Le Pen promise to bring school wine back in her manifesto? I have my reservations, but I think it's important for cultures to find common ground at this time so it may be worth investigation?
Well, well, well. UK drinking trends are nothing like French ones. Astonishing. jrf.org.uk/sites/default/…
Armed with my tables and maps from yesterday, I shall now go to @latitude_wine and try and buy their most Macron and their most Le Pen wine.
It's very important to ship early, get feedback, digest that feedback, and make improvement. Agile or something. And what I've learned from the first two iterations of this is that I need to extend my methodology to the first round too. And also to French Rhum.
I also still need to think through how I map overlapping AOCs. And how I do the labelling when there's so much repetition. Do you like wine @undertheraedar? I might need to call in a favour.
@undertheraedar But first the data analysis. We're now beyond the Excel and QGIS stage. This needs reproducible and fast analysis (so I can do lots of rounds of analysis). For most people that means Python or R. For me that means C# .NET in Visual Studio. It's what I'm used to and it's fast.
@undertheraedar One of the reasons I love @datagouvfr -- the discussions are fantastic. Here, someone has asked the same question I had about Champagne, and the data owner has replied with an explanation and a promise to work on the solution. Really good stuff.
• • •
Missing some Tweet in this thread? You can try to
force a refresh
I've done my four days (of the last six working ones) in London. Hopefully enough for the year. And now on the train home I think I'll do a thread on,... productivity.
Productivity is GVA per hour worked or GVA per job filled or (controversially) GVA per person (at a real push). So here's the GVA per hour worked dataset since 2004, from the ONS, for the UK's four nations. ons.gov.uk/employmentandl…
We can actually look back at productivity in the UK's four nations since 1998 if we use a different dataset. Scotland's performance is again extremely strong. ons.gov.uk/employmentandl…
Can I make a map in an hour? I'm going to try. The home region of every Member of the House of Lords.
House of Lords expenses are here and when a member makes a claim they report the county (or similar) of the claim. Published in Excel and CSV. parliament.uk/business/lords…
27 downloaded. Now I'll write some code to analyse them. Most people would use R or Python I guess, I'll use C#, because old.
The Chagos Islands for £18bn things is so ridiculous that I can't even process it. I can't even begin to think about whether it's true or not, or good or not, because is just so big it can't possibly be right.
Like if you were in IKEA and a table you wanted was £120,000. You'd just assume the label was wrong and take it to the checkout anyway expecting to pay £120.
At what stage of signing the mortgage form at Ikea for the table would you snap out if it and say "hold on, just checking it's not REALLY £120,000 is it? That would be ridiculous"?
Hey, let's look at the bright side, I've been writing about why North England's poor for a week or so now and I'm learning more and more about why Thatcher was bad.
Gonna have to add some Northern examples to the origins of polytechnics page on Wikipedia.
You have a thing like the Leeds Mechanics Institute, founded locally in 1824 as a technical and vocational alternative to universities, which were banned in the North by the UK government, and it evolves all the way to Leeds Polytechnic and then Thatcher makes them central gov.
England has two potential megacity urban areas. Both about 20 million people. Both 200km across. We've already built the blue circle, centred on London, a very strong economy. We could built the red one if we wanted. Currently it's a very weak economy.
I don't think the red circle's economy will ever again be as rich as the blue circle's economy. So 60% growth seems out of the question. But 40% growth in the long term feels reasonable. And 20% growth above trend over the next three decades should work. It did in East Germany.
20% growth for the circle means getting its economy up to the strength of the Scottish central belt. We surely can't think that's beyond the realms of possibility?
The University of Hull is to close its chemistry department.
It said student numbers were "so low that these courses are no longer sustainable".
The chemistry department was rated the fourth best in the UK in The Guardian's University Guide 2024. bbc.com/news/articles/…
I guess the safe thing to say on twitter is "I think this is really bad, not fine, not good, but really really bad" and not hurt anyone's feelings. Keep it a safe space for the anons and not actually think about this, or think about how we might reverse it if we think it's bad.
I worked in the East Riding of Yorkshire's chemical industry. My brother worked in the East Riding of Yorkshire's chemical industry. I applied for further jobs for about a year after a graduated (relevant PhD). Didn't even get an interview. Brother left. Tough sell to be honest.