Link with tool to check for any country

https://rows.com/Henrique/world-data/country-electricity-production-4xqtJEDPR7ppP2bKOjzjFh/live

Source data is from Our World in Data

Visualization tool: rows.com

[removed]

Is there a reason why it has to load every time? Instead of already having the numbers/emojies stored somewhere?

Numbers and countries most likely in a cloud mpp database. The load time is due to the api running a query. This is a really great example of embedded analytics!!

Good question! This is done on a spreadsheet with a table with the energy breakdown by source per country. Then it builds the emoji table when the country changes.

Having one build emoji table per country would be way too heavy, that’s why.

Why there are only 90 emojis and not 100?

It was a bug, thanks for spotting! Just fixed it

Amazing! And such a great tool to get data automatically from any source!

Thank you 🙏

I think it is supposed to say "Electricity production" instead of "Energy production". A lot of most countries energy "production" is done by internal combustion engines in cars.

You're right, it is electricity. The title is incorrect.

Energy would also count heating (not generated by electricity) and transportation, right.

is it a great example because it's really slow?

[removed]

this. People forgot how to make good websites. Nothing is slower than javascript shit that queries a database for every little thing.

Don't think that data looks right. Data shows Hong Kong at 99.71% generated from oil.

Wiki sources showing them at a much more balanced spread in 2020 with Natural gas (44.26%), Coal (28.63%), Imports (26.51%), Other (0.6%). Considering they also list power stations that use gas-fired, coal, and wind power stations the data may be incorrect.

I just confirmed and you’re right. I was pulling data from Our world in data be must be doing something wrong in some countries.

According to them, Hong Kong in 2019 is 65% coal and 35% gas.

Thanks for spotting this, I’ll update the underlaying dataset

yeah it's only about 1kb data total for every country combined there's no reason you should have multi second loading times every single time

[removed]

Really cool thanks for sharing! I'm assuming the breakdown is by energy source proportion of total energy output?

[removed]

[deleted]

Am I missing it or adding combined data of all of the countries could have been nice

You have 8 numbers (for each energy source) per country - let's say it's a 64 bit number. There is a total of 195 countries on earth.

That's a total weight of about 12.5 KB.

Didn't want to rant, interesting solution though, was fun to discover - but the load times could be better.

It’s true, it should be faster. The backend of this is a spreadsheet (so is the FE) so it’s a bunch of Vlookups together to create grid.