Category: mapping

Life Expectancy in China, Japan & 180+ Other Countries

There are billions of people on the planet, all with varying quality of healthcare, economic circumstances, diet and exercise regimes, and genetic predispositions. Even with all these factors, biologists have been estimating the average life expectancy of human beings for centuries. While it’s generally increased, thanks to advancements in medicine and technology and a growing understanding of how to lead a healthy lifestyle, your life expectancy still differs depending on your country.

We’ll examine the average life expectancy of 183 countries, including the differences between males and females in each location. We’ll also look at which countries have seen the largest change (be that an increase or decrease in life expectancy) in recent years on the map below.

View Country by Country Life Expectancy in a full screen map

The map contains the World Health Organization’s 2019 data via Wikipedia. Multiple ways of sorting the map include various things (male, female, both, and changes) of the following four things: life expectancy at birth and at age 60 along with Health-adjusted Life Expectancy (HALE) at birth and again at 60. Let’s begin with the life expectancy at birth of both sexes.

Japan Life Expectancy Is Best & 9 More Long-Living Countries

Each of the countries listed below has male and female life expectancies at birth over 82.5 years. One location’s average is as high as 84.3 years, though the median life expectancy of the top 10 is 83.15 years.

  1. Japan
  2. Switzerland
  3. South Korea
  4. Singapore (tied with Spain)
  5. Spain (tied with Singapore)
  6. Cyprus
  7. Australia (tied with Italy and Norway)
  8. Italy (tied with Australia and Norway)
  9. Norway (tied with Australia and Italy)
  10. Israel

As mentioned, the Japan life expectancy is the highest of the world’s 183 countries at 84.3 years. Many attribute the high life expectancy in Japan to a diet traditionally high in seafood and low in wheat. It’s no wonder the country also has one of the lowest rates of obesity.

Switzerland (83.4) and South Korea (83.3) are within 0.9-1 years of the life expectancy of Japan. Similarly, Singapore and Spain are tied with life expectancies of (83.2) while Cyprus’s is .1 less at 83.1. The life expectancy in Italy, Australia, and Norway is 83. Finally, Israel (82.6) rounds out the 10 countries with life expectancies above 82.5 years. You’ll note these 10 countries are distributed among four continents: five are in Europe, four in Asia, and, of course, Australia.

As for countries that just missed the mark, the France life expectancy is 82.5 years, making it the 11th country with the highest life expectancy. Just below France, the Sweden life expectancy (tied with Luxembourg) is #12 at 82.4 years.

Surprisingly Low Life Expectancy Leaders

No country in either North or South America appears on the list of the 10 countries with the highest life expectancy. Canada is home to the longest living population in the either of Americas, though it’s still further down at #15.

If you’re wondering where world leaders like the United States and China stand, they’re surprisingly low. The U.S.’s average life expectancy is 78.5 years, making it #40. As for the life expectancy in China, the country falls even lower than the U.S. The China life expectancy is 77.4 years (#48). Let’s move on to a more positive metric, though life expectancy changes also contain a couple of negative stats.

Notable Changes in Life Expectancy

More than countries with the longest-living populations or those with shorter lifespans, quite a few places saw notable changes in their life expectancy. Occurring between 2000 and 2019, most are a positive increase, though it’s not the case for every country.

Places with Positive Increases

The 10 countries with the largest increases in life expectancy are all located in the various regions of Africa. This includes the following seven East African countries:

  • Rwanda (+21.6 years)
  • Malawi (+20.9)
  • Burundi (+20)
  • Ethiopia (+18.1)
  • Zambia (+18)
  • Uganda (+17.9)
  • Tanzania (+14.8)

As of 2019, Rwanda’s new average life expectancy is 69.1 years. That of Malawi has risen to 65.6. The life expectancy of Burundi’s population has been updated to 63.8 years while Ethiopia’s stands at 68.7. Those who live in Zambia now have a life expectancy of 62.5 years, Uganda now equals 66.7, and Tanzania 67.3 years.

In addition to the seven countries in East Africa, three Southern Africa countries have seen a significant increase in their life expectancy. These include Botswana (+16.6 years), Zimbabwe (+14.1), and Angola (+13.8).

Locations with Less Life to Live

Now, changes in life expectancy aren’t all positive. Some countries’ life expectancies have actually gone down in recent years. Since 2000, the life expectancy of those who live in the Dominican Republic has decreased by -0.4 years to 72.8 years. Additionally, Venezuela has also seen a decrease in life expectancy since the beginning of the century (-0.2 years). The South American country’s current average is 73.9 years.

View Your Maps on Google Earth

We zeroed in on the life expectancy at birth estimation. However, there is also information on how long people live once they hit their 60s, along with healthy life expectancy. This is the average number of years that a person can expect to live in “full health” (and a more recently adapted estimation). Explore the map to learn more about these groups.

There’s a lot you can do with BatchGeo: group your additional data, embed maps to your website, and email them to friends. But there may be occasions when you need your maps in the format of another popular mapping tool. Instead of starting from scratch, you can export a KML file to view Your Maps in the likes of Google Earth, Google Maps, ArcMap.

To find out more about exporting KLM, visit our page on how to Generate Google Earth KML documents. Otherwise, get started making your own flexible maps at batchgeo.com.

3 Google Sheets Tips You Should Use Daily

Google Sheets is a popular Excel alternative for a variety of reasons. Whether you’re a student who was advised to take advantage of Google Sheet’s auto-save over Excel before Excel followed suit with the same feature or a member of the workforce who finds Sheets more intuitive than Microsoft’s option, there are always new Google Sheets tips and tricks that could improve your workflow.

It seems worth a focus on Google Sheets since we’ve previously covered a lot of Excel tips:

Many of those can be adjusted to function with Google Sheets, but in this post, we’ll look at three tips for Google Sheets exclusively. And if you use it as often as we do, you might find yourself employing them every day.

1. Capture Data with Ease

This first tip is for Google Sheets users who don’t have time to spare (which, let’s face it, is everybody). Instead of painstakingly copying and pasting data from a webpage, you can easily make Google Sheets grab your desired information all at once and display it in the spreadsheet.

We’ll do this via =IMPORTHTML. With this formula, we can enter the site URL with a table we wish to manipulate, in addition to specifying the table and whether it’s the first or second table. For example:

=IMPORTHTML("https://en.wikipedia.org/wiki/List_of_shipwrecks_in_the_Great_Lakes", "table",4)

These are the results. But for those who prefer to steer clear of formulas, an alternative option is an extension like TableCapture for Chrome. Once you’ve captured your data, let’s jump into how to work with it offline.

2. Work Offline with the Google Drive Offline Extension

Whether you’re an international jet setter who finds airport Wifi painfully slow or you’re a homebody who just wants to be prepared, the tools you use for work and personal projects should be able to go anywhere. But because Google Sheets is known as a web-based spreadsheet application, you may think you’re out of luck if you don’t turn your iPhone into a hotspot.

Thankfully that’s not the case when you enable the Google Drive Offline Extension for always accessible data. Sheets offline allows you to easily create, view, and edit files while disconnected from Wifi or data. And while the focus is using Google Sheets offline mode, the same extension also enables you to work offline in Google Slides and use Google Docs offline. Note you must set this up while you still have access to the internet. Then, follow the steps below.

  1. Add the Google Docs Offline extension to Chrome
  2. Navigate to Google Drive, click on the Settings gear in the top right, and select Settings
  3. Remain in the General section to check Offline, and you’re done!

Now that you’ve taken your work offline, it may be time to level up your data in perhaps the most visual way.

3. Make It Visual With a Map

This last tip is for all the visual learners out there, whether you’re using Sheets offline or not. More than capturing and accessing your data in Google Sheets, visualizing your data is also within reach. Via a chart subtype, you can make a Map of your country, continent, or regional data—all within Google Sheets. Here’s how.

  • Under Insert, opt for Chart
  • Click the dropdown for Chart type and scroll down until you see the two Map options
  • Select either Geo chart or Geo chart with markers
    • Note: for latitude and longitude data, the marker option works best.

You can pick and choose the Chart style of your map (Background color, Font, Chart border color) and narrow down your region of focus (the World, Europe, the U.S., etc.), but that’s about as specific as a Google Sheets map can get. So, for an alternative that’s more customizable, just copy and post your data from Google Sheets into a free online mapping tool.

BatchGeo Is Made for Maps

The Google Sheets Chart-Map hybrid is useful when you need to remain in the same platform as your data. However, it doesn’t always offer the insights you could get with a tool that’s dedicated to map-making, which can be as easy as copy and paste. Only with such a tool can you get clickable markers that show info window boxes, like those on our map of Santa Monica Mechanics below.

View Santa Monica Mechanics (With Images) in a full screen map

Click on a map marker to reveal each customized info window box. These can even include your chosen images. Get started with a quick copy-paste of your Google Sheets data into BatchGeo for clickable markers with info window boxes now.

Birthplaces and Dates of U.S. Vice Presidents

U.S. presidents rely heavily on their second-in-command, the vice president. Oftentimes, vice-presidential candidates are selected to balance the ticket. Diversity in race, gender (as with the 2020 election), age, and geography can increase an administration’s chances of winning the election. As such, let’s take a look at the birthplaces of past U.S. vice presidents to see which state most V.P.s have been from and which states are without ties to a vice president. Additionally, birth dates and age ranges at inauguration are included on the map below.

View Birthdates and birthplaces of U.S. vice presidents in a full screen map

The data displayed on the map is from the List of vice presidents of the United States by place of primary affiliation on Wikipedia, though we used some Excel skills to note the age of each vice president when they first took office. You can sort the map by that information or if you’re more interested in where each V.P. started Biden their time, note the geographic facts about the vice presidency below.

Most Vice Presidents Were Born in This State

As we learned from the map of US president births and burials, eight presidents were born in Virginia, which is also incidentally nicknamed the Mother of Presidents. Additionally, seven presidents are buried in Virginia, so the state tops in both births and burials. Let’s see if the same state that produced the most U.S. presidents also resulted in the most V.P.s.

Home state Number of VPs
New York 8
Virginia 3
Vermont 3
Ohio 3
Massachusetts 3
Kentucky 3
Indiana 3
Texas 2
Pennsylvania 2
North Carolina 2
New Jersey 2
Nebraska 2
Maine 2
California 2
South Dakota 1
South Carolina 1
New Hampshire 1
Missouri 1
Minnesota 1
Maryland 1
Kansas 1
Iowa 1
District of Columbia 1
Grand Total 49

New York has been the home state of eight past Vice Presidents. These are George Clinton (the 4th V.P.), Daniel D. Tompkins (6th), Martin Van Buren (8th), Millard Fillmore (12th), William A. Wheeler (19th), Schuyler Colfax (17th), Theodore Roosevelt (25th), and James S. Sherman (27th). Additionally, New York City is the only city where more than one vice president was born. Both the 17th and 25th V.P.s were born in the Big Apple: Schuyler Colfax and Theodore Roosevelt, respectively.

The other 49 states have each borne three or fewer V.P.s. Explore them via the map—you may note the only Western state that can claim vice presidents is California. Let’s see which other states lack V.P. representation.

States With Zero Vice Presidential Ties

Twenty-two states have been the early home of past vice presidents, leaving 28 without a tie to a V.P. This includes 10 of the 11 Western states (and Alaska and Hawaii), with California being the only exception.

Three Southwestern states lack a connection to a vice president: Oklahoma, Arizona, and New Mexico. The same can be said for four states in the Midwest including North Dakota, Michigan, Illinois, and Wisconsin. Eight Southeastern states of West Virginia, Tennessee, Georgia, Alabama, Mississippi, Arkansas, Louisiana, and Florida are also sans a V.P. birth. Additionally, three states in the Northeast are in the same boat: Rhode Island, Connecticut, and Delaware. Now let’s switch gears from birthplace to birth month.

Birth Months and Ages of the V.P.s

A heartbeat away from the presidency means that V.P.s must meet the requirements, including the minimum age of 35. There are political reasons for candidates to choose either youthful or elder statesman running mates. But astrologists might also consider their Zodiac sign. We’ve included both age and birth month in this section.

Vice Presidential Age Ranges

John Adams and Kamala Harris may both be V.P.s with October birthdays, but there’s also a 229-year age gap between the two. Let’s take a look at some more notable age differences between the V.P.s.

The youngest U.S. vice president to take office was just 36 years old. That youngster was John C. Breckinridge, who held the position for one term between 1857 and 1861. On the other hand, Alben W. Barkley was the oldest V.P. to ever hold office. He first took the oath at the ripe age of 72 in 1949. As for the average age of all the vice presidents, it’s about 55 (55.163 to be exact).

Popular Veep Birth Months

Unlike with the 50 U.S. states, all 12 months of the year are represented, though one month only has a single V.P. October is the birth month of eight vice presidents. These include John Adams (the 1st V.P.), Richard M. Johnson (9th), Chester A. Arthur (20th), Adlai E. Stevenson (23rd), Theodore Roosevelt (25th), James S. Sherman (27th), Henry A. Wallace (33rd), and Kamala Harris (49th).

Six V.P.s each were born in January and July. For January, it’s Millard Fillmore (12th), John C. Breckinridge (14th), Charles Curtis (31st), Richard Nixon (36th), Walter Mondale (42nd), and Dick Cheney (46th). Then, George Clinton (4th), Elbridge Gerry (5th), George M. Dallas (11th), Calvin Coolidge (29th), Gerald Ford (40th), and Nelson Rockefeller (41st) were all born in July.

March and June bore five Vice Presidents. The March births were John C. Calhoun (7th), John Tyler (10th), Schuyler Colfax (17th), Thomas R. Marshall (28th), and Al Gore (45th). June saw Daniel D. Tompkins (6th), William A. Wheeler (19th), Garret Hobart (24th), George H. W. Bush (43rd), and Mike Pence (48th) born.

The remaining months have under five V.P. births, the lowest of which is September with the birth of just one vice president: Thomas A. Hendricks.

More Political Maps Made With BatchGeo

Below is a list of related maps you can create online for free with BatchGeo.

Take a look, or make a map of your own so that you too can get visual insights into any dataset.