Most people know that the Bald Eagle represents the United States. But can you name the national bird of Argentina or Luxembourg? A total of 114 countries are represented by one avian species or another—whether officially or unofficially. In fact, some have more than one! Despite a representation that feels unique, some countries have feathered friends in common. So let’s go over the world’s national birds, conveniently plotted on the map below.

View National birds in a full screen map

Official vs. Unofficial National Jays, Falcons, and Storks

Most of the 120 birds on the map are officially designated. Yet some hold only an unofficial status. In total, 91 are official national birds. The remaining 29—though not official—still have meaning to their associated countries. Let’s take a closer look at some of these unofficial birds.

Notably, most Caribbean countries have official national birds, that is, aside from Puerto Rico. The Puerto Rican spindalis, also known as reina mora, may be native to the island country, yet it’s still only connected to Puerto Rico unofficially. These birds help in seed dispersal and plant reproduction, making them a key part of the Puerto Rican ecosystem. You can find the species all over the island.

Contrary to the U.S.’s official national bird (the Bald eagle), neighbor-country Canada’s own Canada jay remains unofficial. Canadian Geographic magazine suggested the bird should be validated, but the federal government has yet to acknowledge the proposal.

The 29 countries without an official national bird aren’t only made up of places like Puerto Rico and Canada that have no official national bird. Both Pakistan and Poland have official and unofficial national birds. The Chukar partridge has been officially designated in Pakistan, while the Shaheen falcon is only considered a heritage bird. Moreover, the Polish have anointed the White-tailed eagle officially, though the White stork has yet to be.

Group the map by “Official status” to learn more, because we’re flying to the most bird-happy nations.

Countries with Multiple National Birds

We’ve already mentioned two of the countries with multiple national birds, Pakistan and Poland. Yet there are four more countries that have multiple national birds:

• Trinidad and Tobago: 2 national birds
• Denmark: 2
• Aruba: 2
• Serbia: 2

Trinidad and Tobago’s multiple national birds include the Cocrico and Scarlet ibis, while Denmark’s are that of the Eurasian skylark and Mute swan (while not entirely mute, its name does derive from it being less vocal than other swan species). Aruba, on the other hand, is home to the Prikichi (also known as the Brown-throated Parakeet), along with the Shoco (Burrowing Owl).

As for Serbia, the country’s choices for national birds are the Griffon vulture and Eastern imperial eagle. Speaking of eagles…

Countries with the Same National Storks, Condors, and Eagles

Not only do countries like Aruba and Denmark have multiple national birds, some even share the exact same national bird. Coincidentally, or perhaps not, most of these countries with the same national bird are located near each other, or right next door.

Bird	No. of countries with this national bird
White stork	4
Andean condor	4
Golden eagle	3
African fish eagle	3
Turquoise-browed motmot	2
Saker falcon	2
Eurasian oystercatcher	2
Common nightingale	2
Barn swallow	2

What do Belarus, Lithuania, Poland, and Ukraine have in common, other than their borders? Their national bird is the White stork, though, it’s only officially so in Lithuania. Like the White stork, the Andean condor is the national bird of four countries: Bolivia, Chile, Colombia, and Ecuador. It’s officially recognized in all four countries.

Meanwhile, two more species of national birds, both eagles, are represented by three countries. Specifically, Albania, Mexico, and Scotland have the Golden eagle to represent them, albeit it’s unofficial in Scotland. And then there’s the African fish eagle, the national bird of Namibia, Zambia, and Zimbabwe; all are official.

The Turquoise-browed motmot, Saker falcon, Eurasian oystercatcher, Common nightingale, and Barn swallow are the national birds of two countries.

Want less flying and more running? Check out the National Animals of Every Country on a Map, which includes mythical animals like the double-tailed lion.

The Guinness Book of World Records lists world records both of human achievements and the extremes of the natural world. This can be anything from the tallest living woman to the longest-airing sitcom—or the largest running events.

The world’s largest running events are based on the number of registrants, not distance. The 10 largest had more than one million people registered. And while not all registrants will complete the race, it’s estimated that between 80 to 85% do. However, that doesn’t mean these large running events aren’t also long, with distances up to 87.6 kilometers.

View Largest running races in a full screen map

1+ Million People Registered for the 10 Largest Races

At least 20,000 people have registered in each of the world’s largest running events. In total, it’s been over 3.5 million. Yet the top 10 make up nearly 30% of that.

• Wings for Life World Run: 184,236 registrants
• A Run for the Pasig River: 116,086
• Bay to Breakers: 110,000
• Cursa El Corte Ingles: 109,457
• Royal Run: 93,620
• Broloppet / Broløbet: 92,266
• Vancouver Sun Run: 89,000
• City2Surf: 86,696
• Dam tot Damloop: 74,020
• Hong Kong Marathon: 73,070

The 2021 Wings for Life World Run was the largest race in the world. However, that’s not surprising, seeing as the race is global. Participants from all over the world start running at the same time in support of spinal cord research.

The Philippines’ 2010 A Run for the Pasig River has also had registrants in the hundreds of thousands. At one point, it even held The Guinness World Record for having the most participants in a racing event. Previously in 1986, San Francisco, California’s Bay to Breakers was recognized by the Guinness Book of World Records as the world’s largest footrace.

It’s also worth mentioning that Copenhagen is home to both the Royal Run and Broloppet which each have seen more than 90,000 registrants. The Royal Run was held in May of 2023 while Broloppet took place in June 2000.

Speaking of months, specifically May and June, this is the most common time these large races occurred. In addition to Royal Run, May has also held Wings for Life World Run and Bay to Breakers. June, on the other hand, was the month of not only Broloppet but Cursa El Corte Ingles as well.

You’ll have to check out the rest of the largest races’ registrants and months on the map because we’re moving on to distance.

Largest in Distance

The world’s “largest” races might have many meanings. While in this case, we’re talking about participation, we also have information about their distances. So let’s see the longest of these, starting with the Comrades Marathon.

In June of 2000, the KwaZulu-Natal Province of South Africa saw 20,047 participants run 87.6 km (54.4 miles) in the annual Comrades Marathon. While that participation may seem low compared to the Wings for Life World Run or A Run for the Pasig River, it’s also the only ultramarathon (any footrace longer than the traditional marathon length of 42.195 kilometers) on the map.

Meanwhile, there are many (24) traditional marathons (42.195 km) with high participation from the Hong Kong Marathon to the Naha Marathon. Group the map by “Distance (km)” and filter by “87.6 – 30” to see them.

Where the Largest Races Take Place

We’ve mentioned the locations of some of the 10 largest races and longest races. But some countries are home to multiple of the world’s largest races.

• United States – 20 largest races
• Australia – 7
• United Kingdom – 5
• The Netherlands – 5
• India – 3

More of the largest races are held in the U.S. than anywhere else in the world. Among the most popular cities are Chicago, which is home to the Bank of America Shamrock Shuffle, Chicago Marathon, and JPMorgan Corporate Challenge. Philadelphia and New York City also put on two of the largest races each: the Broad Street Run and Philadelphia Marathon along with the New York City Marathon (held in November) and New York City Half Marathon (held in March). California also is hosts to two, albeit in different cities: Bay to Breakers in San Francisco, which has the largest participation of any U.S.-based race, and the Los Angeles Marathon in L.A.

Australia, the United Kingdom, the Netherlands, and India also have multiple large races. Get insights into your data’s most common locations when you make a map with BatchGeo.

Many modern teachers tell their students not to rely on Wikipedia as a source of information. But it’s difficult to ignore one of the Internet’s top sites, peer-reviewed all day long by the connected world. The free online encyclopedia is often the only place some information is aggregated. With crowd-sourced data about anything and everything, Wikipedia’s attraction is obvious. And that’s not to mention its lists and data tables that make it easy to copy and paste information into spreadsheets like Excel for further data analysis.

That said, there are still limitations to data gathering on Wikipedia, especially if locations are involved. While many Wikipedia tables contain the exact latitude and longitude coordinates of each location, other times, that information is missing. There are plenty of reasons to need that specific information. One example is if you’re dealing with locations that formerly existed. Exact coordinates of where these places once stood would be necessary as they may no longer exist on a map.

While you can certainly click on most Wikipedia pages to see a location’s coordinates in the upper right-hand corner, you wouldn’t want to have to do that for each item in a 135-location table. There’s an easier way to obtain coordinates from Wikipedia locations using the MediaWiki API result—and we’ll show you how in this post.

Copy All Wikipedia Table Data to a Spreadsheet

Step one of capturing location data from a Wikipedia table in a spreadsheet is getting the data from a Wikipedia table into a spreadsheet. While there are multiple ways of doing so, including just regular copy-paste, to get gather what we need to use the MediaWiki API, we’ll need to use a tool like Table Capture.

1. Add the Table Capture Google Chrome extension
2. IMPORTANT: Click the extension in the upper right-hand corner of your browser and opt for options
3. On the page that pops up, ensure Extract link URLs from table cells is checked
4. Now, navigate the Wikipedia page with a table you wish to pull data from
5. Click the extension
6. Select your desired table
7. Click the icon that represents the action you want to take (i.e. Copy table data to the clipboard, Export table to Google Sheets, etc.)
8. Paste to your spreadsheet if necessary

Now that you have the Wikipedia table data in your spreadsheet, we’ll need to isolate captured links from table in your spreadsheet so that we can use the MediaWiki API.

Isolate Captured Links & Queries in Your Spreadsheet

The data we captured from the Wikipedia table in the previous section contains Wikipedia page links, which we’ll need in order to obtain exact geographic coordinates. However, these URLs are buried within the data, not useful until we can isolate them into one column.

The method we’re about to show you is quicker, especially if you have hundreds of locations, as with our Former Major League Baseball stadiums. So let’s continue.

• In your spreadsheet, identify the column that contains both the names of your locations and their corresponding Wikipedia page URLs (if the previous step was done correctly). In our case, that’s the “Stadium” column
• Next, you’ll need to separate location names from the URLs using Excel’s “Text to Columns” tool (Google Sheets has a similar feature called “Split text to columns”):
  • Navigate to the “Data” tab in Excel and select “Text to Columns…”
  • Opt for Delimited characters seeing as the URLs should be contained within parentheses
  • Click Next and check “Other”
  • Type in an open parenthesis ((), then click Finish
    • Note: If any rows end up split into three columns instead of two (one for location names, one for Wikipedia page URLs), you’ll need to use =CONCATENTATE to combine the two parts of the links
    • First, make these easy to identify by using “Sort & Filter” > “Sort A to Z”
    • Then, in the second cell of a fourth column, type =CONCATENTATE, click the first cell with part of a URL, “(”, followed by a comma and the second URL cell
    • Drag that formula down to all of the similar cells in the column
    • Copy and “Paste Values” into that same column, then select the previous two columns, delete and shift them left
  • You’ll finish up by following the same “Text to Columns” steps above and splitting the entire column by ending parentheses
• Then, use “Conditional Formatting” in the Home tab to highlight any link cells in which a starting parenthesis remains as part of the link
• You can either use ‘=CONCATENATE’ or manually add back the closing “)” to all of the highlighted cells
• Just one more step: we only need the query string or parameter part of the link, so you’ll once again use “Text to Columns,” this time noting “/” in the “Other” space
• Delete the other split link columns and you’re done!

Now you have the exact links to the exact Wikipedia pages, and can use the MediaWiki API result to more easily grab their exact coordinates.

Use MediaWiki API Result to Get Coordinates

With our data gathered and locations and link queries in their respective columns, we can finally use the MediaWiki API result in order to obtain latitude and longitude coordinates with minimal clicks. Non-developers needn’t worry—this is the easy part for any experience level.

• In your spreadsheet, copy (Ctrl+C or Cmd+C) your first Wikipedia page query
• Navigate to MediaWiki API result and paste your query at the end of the URL bar, replacing our Sahlen_Field example
• Press enter, then copy and paste the resulting “lat” and “long” into your spreadsheet!

They’re even in the perfect format for making a custom Google Map from your data…

Map Your Coordinates & Data

As an optional, final step, you might plot your newly gathered data points on a Google Map. Here’s how:

View MLB Stadiums in a full screen map

1. Open your spreadsheet
2. Select (Ctrl+A or Cmd+A) and copy (Ctrl+C or Cmd+C) your data
3. Open your web browser and head to batchgeo.com
4. Click on the location data box with the example data in it, then paste (Ctrl+V or Cmd+V) your own data
5. Check to make sure you have the proper location data columns available by clicking “Validate and Set Options”
6. Select the proper location column from each drop-down
7. Click “Make Map” and watch as the geocoder performs its process

Get started for free at batchgeo.com.