Share this page!

Enter URL or ID to Unroll

You can paste full URL like: https://x.com/threadreaderapp/status/1644127596119195649
or just the ID like: 1644127596119195649

How to get URL link on X (Twitter) App

  1. On the Twitter thread, click on or icon on the bottom
  2. Click again on or Share Via icon
  3. Click on Copy Link to Tweet
  4. Paste it above and click "Unroll Thread"!
  5. More info at Twitter Help
Tom Forth Profile picture
@thomasforth
Apr 25, 2022 • 34 tweets • 14 min read • Read on X
Scrolly
BRB, calculating the most Macron and most Le Pen protected French wine region.
French wine AOCs are, of course, highly defined. And now #opendata.
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. Image
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. ImageImageImageImage
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. ImageImage
France is varied eh? ImageImageImage
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… Image
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. ImageImage
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,... ImageImage
I am not to be able to justify that purchase I don't think. Understanding this "President of the Rich" thing now TBH. ImageImage
Yeah that's not happening Macron. Image
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. Image
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. ImageImageImage
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. ImageImage
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… ImageImage
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. Image
More data on French boozing since 1960. insee.fr/fr/statistique… Image
Gone back to 1950 via some PDFs. The decline (in boozing, thus improvement in health and lots of other things) started in the 60s. ImageImageImage
1956 infamously when French children stopped being given wine at school. smdh.
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/… Image
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.
@latitude_wine Final results were here. -->
Et voilà. Image
And look how good the cycle paths are. ImageImageImageImage
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. Image

• • •

Missing some Tweet in this thread? You can try to force a refresh
　

Keep Current with Tom Forth

Tom Forth Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @thomasforth

Tom Forth Profile picture
May 1
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…Image
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…Image
Read 17 tweets
Tom Forth Profile picture
Feb 10
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. Image
Read 20 tweets
Tom Forth Profile picture
Feb 4
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"?
Read 6 tweets
Tom Forth Profile picture
Jan 21
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. Image
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.
Read 9 tweets
Tom Forth Profile picture
Jan 17
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. Image
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? Image
Read 12 tweets
Tom Forth Profile picture
Dec 1, 2024
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.
Read 10 tweets

Did Thread Reader help you today?

Support us! We are indie developers!

This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Don't want to be a Premium member but still want to support us?

Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal

Or Donate anonymously using crypto!

Ethereum

0xfe58350B80634f60Fa6Dc149a72b4DFbc17D341E copy

Bitcoin

3ATGMxNzCUFzxpMCHL5sWSt4DVtS8UqXpi copy

Thank you for your support!

Follow Us!

Send Email!

:(