Creating this viz was fun. Had to look up all kinds of places like Sultan Kudarat, Puerto Princesa city, Sulu, Eastern Samar..
The Data
Covid-19 stats: from DOH
Population by Cities and Provinces: PSA
Coordinates: Google maps
*Key: Blue dots on the map are places with less than 1500 covid cases. Red dots are 1500 cases and beyond.
The map isn’t live. Will update every month until this is all over.
Stay safe. Happy Easter!!
Category: Weekly Chart
How Philippines contributes to the future of global sustainable energy.
There was an article today in the Economist about how lithium battery costs have fallen by 98% in three decades. Its good. It made me do some research and write this post.
Batteries play an important role in the global shift towards clean sustainable energy and reducing carbon emissions. Lithium-ion (Li-ion) rechargeable batteries are the most common. They are used in our phones, laptops and predominantly in EV’s since Tesla started the movement in 2008. Li-ion batteries are also used in Energy Storage Power Stations to harvest large amount of electricity generated by renewable energy sources such as Wind and Solar.
Increasing demand for Li-ion batteries has led to developments and production of more powerful, more efficient and less costly batteries.
An important component of almost all Li-ion batteries produced today is Cobalt.
Cobalt is a scarce lustrous mineral. It plays a huge role in stabilizing Li-ion batteries and increasing their energy density. It is rare, expensive and found only in a few places on earth. Philippines happens to be one of the few.
DR Congo by far is the largest Cobalt producing country, accounting for over 60%. The Philippines is the fifth largest with 3.8% of global production. What is even more significant is having an essential energy commodity at home as the world looks to a future of clean renewable energy, moving away from dependence on coal and oil.
Photo Credit : Wikipedia Commons
Data Source: BP Statistical Review of World Energy 2020
Download PDF document
01. World Cobalt Mines Production (Thousand Tonnes) 2015 – 2019
02. Share of World Total Cobalt Production 2019
PSE index – Ranking Largest Companies in Philippines by Market Capitalization.
The Data
Source: pse.com.ph (data saved on 21 March 2021)
Brief description
Market Capitalization is the market value of a company.
It is calculated by multiplying the stock price by the total number of outstanding shares.
The Market Cap value for all companies listed on the Philippines Stock Exchange(PSE) is available on the official website. We’ll focus on the top 30 companies that make up the PSE index.
Calculations
– All figures have been converted from Pesos to USD. ($20 billion is an easier view compared to P1 trillion).
Conversion rate is set at $1 = P50.
The actual rate of USD/PHP is around $1 = 48.50(1.5 pesos or $0.02 difference). It’s fine. Using P50/$1 undervalues all estimated figures by approximately 3%. It gives a fair leeway to account for the fluctuations in stock prices and rounding up of the numbers to one decimal place in billions.
For the most recent updated stock prices and market cap values in pesos, visit pse.com.ph. It is updated every 15 mins.
The charts:
Summary
We all know SM, BDO, BPI are some of the largest companies in the country. It’s interesting to look at the actual figures in a chart and compare the top 30.
You can download pdf copies of the charts here:
01. Top 30 largest companies in Philippines by market capitalization. Table
02. Top 30 largest companies in Philippines by market capitalization. Bar chart
Global warming by country – tree map or world map
Hi, welcome to another blog post.
For this post on global warming, we’ll be using the same data on two different charts: the world map chart and the tree map. And we’ll see how it looks.
Brief description.
You already know what global warming is.
Earth’s temperature getting hotter (since at least 1980 when we all started paying attention). Ice caps melting, oceans rising, forests cleared, rivers and lakes drying, Australia fires . .
Causes
Global warming is caused by humans activity that leads to emission of Green House Gases(GHG). These gases trap heat in the atmosphere causing earth’s temperature to warm. 80% of GHG is Carbon dioxide (CO2). CO2 is released from heat and smoke of factories, cars and electric power plants, all burning gas or coal. Methane released from waste of industrial livestock farming (beef, chicken..) and waste (our thrash) in landfills makes up 10% of GHG. The remaining 10% is made up of Nitrous oxide and other harmful gasses.
Data Source
climatewatchdata.org.
Measurement Unit : Million metric tons of carbon dioxide. (MtCO2e)
All GHG emissions are expressed in CO2 (or carbon) equivalent.
The figures shows the amount of GHG emitted in a country during a particular year.
I have used the most recent of the historical data accessible, 2018.
Summary
From the world map chart, we easily see countries with less GHG emissions in green. Most of Northern Europe and Africa. They are of lower income/smaller economies and have less factories and cars producing GHG.
The tree map on the other hand better shows countries with the highest GHG emissions in red. Larger economies with more factories and higher GDP.
To show the actual emissions figures on all 193 countries, I embedded the vizzes directly from Tableau public. All we have to do is to hover over an area on the map and the information is highlighted.
On Climate change.. watch Home by Yann Arthus-Bertrand . .
How much is the Philippines?
Hi, for our first data visuals post, we’ll be doing a brief overview of the economy.
For context, we’ll compare it with similar South East Asia nations and some of the worlds largest economies.
The data
source : data.worldbank.org
The indicators we’ll be using are:
- GDP
- GDP growth rate
- Total Population
- Population growth rate
- Per capita income
Brief descriptions - GDP: The Annual GDP (Gross Domestic Product) is the total money value of all goods and services produced within a country in a year. It’s what the economy is worth.
- Total Population: is the total number of everyone living in the country.
- Per capita Income: is GDP divided by the total population. Basically, it shows the overall annual average income of everyone living in the country.
In 2020, the Philippines economy was estimated to be worth approximately $367 billion, down from $377 billion in 2019.
From 2005 to 2015, the economy grew by around $100 billion every 5 years.
As the global pandemic hits hard in 2020, the economy fell by -9.5%. In the last 30 years since 1990, Philippines has had a negative growth rate in only 3 years. 2020, 1998 and 1991.
Total population has grown from 62 million people in 1990 to 110 million people in 2020. But, there’s been a gradual fall in the growth rate. In 1990, the population grew at a rate of 2.5% . In 2020, by 1.4%. Note how the population grows by 8 million people every 5 years.
In 2020, per capita income was $3600. Converting it to PHP with USD set at 1USD = 50PHP. 3600 x 50 = 180,000 PHP.
The estimated overall average income of everyone in Philippines in 2020, was 180,000PHP.
Divided by 12 months equals 15,000PHP per month.
Of the 5 countries compared in the chart, Malaysia’s GDP was the lowest. But in terms of per capita income, it’s the highest.
The U.S is the world’s largest economy with GDP of over $20 trillion.
China the world’s second largest economy, has a lower average per capita income than Malaysia, Japan, Canada.
Summary.
The charts were created using data from world bank. We can see 15 to 30 years trend on how much Philippines economy is worth, the total number of people and how much is earned on average per year. And we compared the economy with similar south east Asia countries and some of the world’s largest economies.
Download the PDF doc
01. Philippines GDP
02. Annual growth rate of GDP
03. Total population and population growth rate.
04. Per capita income since 1990
05. Comparing Philippines GDP with similar South East Asia countries.
06. Comparing Philippines GDP with similar SE Asia countries and world.
07. Philippines Per capita income with similar South East Asia countries.
08. Philippines Per capita income with similar SE Asia countries and world.