Author: Adam DuVander

Show Wikipedia Images on a Google Map

Compared to spreadsheets, maps are better at visualizing your information and helping you make sense of your data’s geography. Yet, even the most customized map doesn’t always tell the whole story.

You can give your location markers more context by going beyond textual information — we’re talking about incorporating images. After all, a picture is worth 1,000 words.

BatchGeo is already the easiest way to map your spreadsheet data. If images are part of that information, BatchGeo maps can display those, too. And while there are many places to find free-to-use photos, nothing beats Wikipedia for images.

The Best Wikipedia Pages Have Tables and Images

To level up your map, start by finding some images. Since we’re focusing on images from Wikipedia, we’ll start there.

Pop your topic into a Google search bar. While Wikipedia may organically top the results, you can further filter your search by adding “site:Wikipedia.org.”

You will likely see quite a few options. Those starting with “List of” will be your best bets, as these Wikipedia pages often contain images as well as text.

Automatically Capture Wikipedia Table and Image Data

While Wikitables make copying and pasting the data into a spreadsheet easier than the alternative, you still don’t want to manually do so for rows and columns of information, including the image links. Instead, you can use a tool that automatically grabs the data for you to paste into your spreadsheet while maintaining the table format from Wikipedia.

We recommend the Table Capture browser extension in Chrome. Here’s how to use it:

  • Add the Table Capture extension to your Google Chrome browser.
  • Because we want to pull in images, click the extension in the upper right corner of your browser and choose “Options.”
  • In the “Options” tab, check “Extract Image and Icon Attributes” and make sure “Ignore Images Completely” is unchecked.
  • Hit “Save.”
  • Navigate to the Wikipedia page where you want to pull a data table.
  • Once again, click on the Table Capture extension.
  • Select your desired table(s).
  • Click the icon representing the action you want, such as “Copy table data to the clipboard.”
  • Paste to your spreadsheet.

Now that you’ve gathered your data, you may still need to do a few clean-up tasks, such as splitting the associated text into different columns from the actual image links. You can prepare your data in Excel, but follow these steps if you’re a Google Sheets user:

  • Select the column containing the information you want to split.
  • In the “Data” tab, opt to “Split text to columns.”
  • In the pop-up box, choose “Custom” and type in the “Separator” (in our case, an open parenthesis).

Most of your data should now be separated into two columns, though you can manually fix any that weren’t formatted properly. Update each heading to better distinguish the two, and now you’re ready to create a custom map of your data and images.

Map Your Data and Images

Follow the usual steps of creating a BatchGeo map:

  • In your spreadsheet, select (Ctrl+A or Cmd+A) and copy (Ctrl+C or Cmd+C) your data, including image links.
  • Open your web browser and navigate to batchgeo.com.
  • Click on the location data box with the example data, then paste your data (Ctrl+V or Cmd+V).
  • Check that you have the proper location data columns by clicking “Set Options.”

Here’s the important part: Before you click “Map Your Data,” select “Show Advanced Options” and select the correct column for your image data in the “Image URL” dropdown. Now you can watch the geocoder perform its process while also incorporating your images into the map, which should look something like this:

View National flowers and trees in a full screen map

There you have it! Your map of Wikipedia data is complete with images thanks to BatchGeo!

Coffee Consumption by Country

In a world where jokes about needing coffee to start the day are ubiquitous, and Starbucks is practically everywhere, uncovering exactly how much coffee people consume may just be a grande undertaking.

In this post, we’ll examine annual coffee consumption across 66 countries in terms of sheer volume and per capita. While the most significant consumer in volume alone may not be too surprising, the list changes drastically when population is taken into account.

We’ll also take a look at which countries are the largest producers of the nearly 20 billion pounds of coffee consumed in the world every year. Finally, we’ll explore how tea performs against that morning cup of joe.

View Coffee Consumption by Country in a full screen map

The US Tops Volume of Coffee Consumed Each Year

Coffee Consumption Rank Country Coffee Consumption (bags) Coffee Consumption (lbs)
1 United States of America 26,651,000 3,525,314,327
2 Brazil 22,000,000 2,910,094,000
3 Germany 8,670,000 1,146,841,590
4 Japan 7,355,000 972,897,335
5 France 6,192,000 819,059,184
6 Italy 5,469,000 723,422,913
7 Indonesia 4,806,000 635,723,262
8 Russia 4,631,000 612,574,787
9 Canada 3,929,000 519,716,333
10 Ethiopia 3,781,000 500,139,337

Over 500 million pounds of coffee are consumed by each of the top coffee-consuming countries, with the United States in the lead. Americans consume a staggering 3,525,314,327 pounds of coffee each year. Brazil is next, with 2,910,094,000 pounds, followed by Germany, Japan, and France.

But how do these top countries fare once population is taken into account?

Per Capita Tells a Different Story (Nordic Supremacy)

Accounting for population, the US and Brazil fall to #24 and #12, respectively.

Meanwhile, the tiny country of Luxembourg leads the per capita consumption list with a remarkable 45 lbs of coffee per person per year. Rounding the numbers to the nearest pound, Finland (32), Sweden (22), Norway (22), and Denmark (17) also exhibit high per capita consumption, emphasizing the strong affinity for coffee across Nordic countries.

Other nations also maintain significant coffee consumption patterns, including Austria (17) and Switzerland (16). The Netherlands, Greece, and Germany follow them.

Moving on from consumption, it’s also interesting to delve into where our coffee beans come from.

Coffee Production Around the World

The following are the top producers of everyone’s favorite morning cup.

  • Brazil: 7,699,936,764 lbs of coffee produced annually
  • Vietnam: 4,032,755,354
  • Colombia: 1,865,118,928
  • Indonesia: 1,512,309,713
  • Ethiopia: 971,362,922
  • Honduras: 784,561,342
  • Uganda: 728,740,448
  • India: 659,744,765
  • Mexico: 527,070,934
  • Peru: 507,467,483

Brazil, the world’s second-largest consumer of coffee, also stands out as the largest producer by a significant margin, contributing over seven billion to the world’s coffee output. The field of coffee production appears to be particularly concentrated in South America and Southeast Asia.

But coffee isn’t the only drink loved by millions.

What About Tea?

The world consumes nearly 20 billion pounds of coffee every year. Yet many opt for a comforting cup of tea instead. The following countries consume the most tea each year:

  • Turkey: 6.96 lbs of tea consumed annually per capita
  • Ireland: 4.83
  • United Kingdom: 4.28
  • Iran: 3.30
  • Pakistan: 3.30
  • Russia: 3.05
  • Morocco: 2.68
  • New Zealand: 2.63
  • Chile: 2.62
  • Egypt : 2.23

While the largest consumer of tea — Turkey, with around seven lbs per capita — doesn’t come anywhere near the largest consumer of coffee — Luxembourg, with over 45 lbs per capita — the number is still significant.

Ireland, with a per capita consumption of around five pounds, stands out as another notable consumer of the hot beverage. Meanwhile, the UK, arguably the best-known country for tea, ranks third.

Both coffee and tea are among the world’s national drinks. Tea is the more popular choice as a national drink (36 countries) than coffee (25). Learn more by checking out our world’s national drinks map.

The Largest Universities Across the World

​​Size isn’t everything. Yet, when it comes to higher education, some universities stand out for their considerable enrollment numbers.

Among the 69 largest universities on our list, Indira Gandhi National Open University is the largest, with over seven million students enrolled. Beyond size, we’ll also look at the oldest among these large institutions and whether the largest are more likely to be public or private.

Top 10 Largest Universities by Country

View Largest Universities in a full screen map

Each of the 69 universities depicted on the map is the largest in its country. However, the top 10 have significantly higher enrollment figures than the smallest.

University Enrollment
Indira Gandhi National Open University 7,140,000
National University, Bangladesh 2,097,182
Anadolu University 1,969,733
Universitas Terbuka 1,045,665
Islamic Azad University 1,000,000
Tribhuvan University 604,437
Ramkhamhaeng University 525,000
National Autonomous University of Mexico 349,515
University of South Africa 328,179
Spiru Haret University 311,928

Indira Gandhi National Open University (IGNOU) in India leads the list with a staggering 7,140,000 enrolled students. The National University in Bangladesh follows IGNOU with 2,097,182 students. Next is Anadolu University in Turkey, with 1,969,733 students, and Universitas Terbuka in Indonesia, with 1,045,665 students. Iran’s Islamic Azad University and Pakistan’s Allama Iqbal Open University also have enrollment numbers that break the million mark.

Six of the top ten universities are in Asia, though the count extends to seven if we include Turkey’s Anadolu University.

As for the US, the largest university is Texas A&M. This institution doesn’t even rank among the largest 30 across the globe; however, spread across 5,115 acres, it ranks ninth in terms of the largest US campuses. Founded in 1876, it’s not anywhere near the oldest, though, which we’ll examine next.

10 Oldest Large Universities

While we’ve just highlighted the top 10 largest universities, most were relatively recently established in the 20th century. However, there are far older large universities:

  • University of Lisbon: founded in 1288
  • Sapienza University of Rome: 1303
  • University of Vienna: 1365
  • KU Leuven: 1425
  • Universidad Autónoma de Santo Domingo: 1538
  • National University of San Marcos: 1551
  • National Autonomous University of Mexico: 1551
  • University of Amsterdam: 1632
  • University of Helsinki: 1640
  • Lund University: 1666

The largest university in Portugal, the University of Lisbon, was established more than seven centuries ago, in 1288. We could argue that the current university was established much later — in 1911, 1930, or even in 2013. Successive mergers aside, the institution can trace its roots back to the original University of Coimbra in 1288.

Following the University of Lisbon are two more public universities: Sapienza University of Rome and the University of Vienna, both founded during the 14th century. Speaking of public universities, let’s dive into the types of large universities.

Are the Largest Universities More Likely to Be Public or Private?

The largest university in the US, Texas A&M, is a public university. This designation means the state owns the university, or the government provides a significant amount of its funding. While the majority of large universities are public, there are other types too:

  • Public: 59 of the largest universities
  • Private: 7
  • Semi-private: 1
  • Public (formerly private): 1
  • Private, state-funded: 1

So, 59 of the 69 universities we’re looking at are public or publicly funded institutions.
Private universities, or institutions that are not operated, owned, or institutionally funded by governments, follow, with a count of seven. The largest is Spiru Haret University in Romania, the only private university in the top ten. Additionally, there is a single semi-private university (Islamic Azad University).

One university also transitioned from private to public status (University College Dublin), while the other is private but state-funded (Belgium’s KU Leuven).

Explore More Top University Stats

Although large universities have their appeal, we know that the biggest doesn’t always mean the best. Explore our Map of Top Colleges in the US for a different perspective.