Data Dwellers – Bombus inexspectatus Tkalcu, 1963

1.0 Introduction

Time to get started on the first real Data Dwellers. The previous two posts were to introduce the series and give short highlights of the methodology behind the series.

In the first post (Introducing the Data Dwellers) I already gave a first glimpse of the species we’ll cover today. What you read here will be the basic outline that each Data Dwellers post will follow. It will include a short introduction to the species and then will highlight the data analysis process. What did I do with the data? Did I find anything interesting? What does the data show us? Can I make improvements in the future and are we missing something in the data?
To round it all off I’ll provide links, and references to the data used.

I have only recently started on my data analysis journey, so part of the process is me learning and documenting my work. You can see this as an extended portfolio, if anyone is interested in my skills they can come here and see what I’ve done and how I have done it.

So, to start, I needed a dataset that was manageable for my current competency level. I needed to find a species of bee or butterfly that would not have millions of data entry points (very common species will have millions of occurrences) so that I could easily review the work that I had done and see where I can improve or simplify my data analysis processes. Two bumblebee species were the first that popped into my mind … the blog’s namesake and a very rare species I have been interested in. Let’s take a closer look in the next section.

Key Takeaways

  • The goal is to learn by doing and you as reader can follow along as we build our data analysis competencies while exploring insect species.
  • Each post will have a similar structure. This spaced repetition learning technique will build up our base skills (continuous learning) and will make any anomalies stand out when we find them in future Data Dwellers posts.

2.0 Species Introduction – Bombus inexspectatus

I actually started on the blog’s namesake (Bombus cullumanus), and I’ve finished the work, but the dataset required quite a lot of cleaning, so I thought I’d leave that for a future post because I have to do more explaining around my data analysis processes. Let’s keep it relatively simple for a first time. This post is going to be a bit longer than usual – grab a coffee and settle in!

Bombus inexspectatus Tkalcu, 1963 is an extremely rare bumblebee species that can be found in the Cantabrian Mountains and the Alps (see the IUCN link below). The reason it is so rare is because it has an incredibly unique lifestyle. I know of one other bumblebee species like it, Bombus hyperboreus Schönherr, 1809, which is found above the Arctic Circle in Norway, Finland, and Russia. What makes this species so special is that the queens cannot make their own nests, but at the same time, they do not parasitize a host’s nest like a cuckoo bumblebee does. Cuckoo bumblebee queens kill or “dominate” the host queen, and the hive then thinks that the usurper is one of their own. Unknowingly, the nest starts rearing the cuckoo bumblebee’s eggs! Think of the Cuckoo bird, where the adult removes a host bird’s eggs (a Robin or Blackbird for example) from the nest and lays her own in it. The host bird then rears the Cuckoo’s egg to adulthood!

Bombus inexspectatus queens cannot make wax (to create the cells into which eggs are lain), so she enters a nest and needs to work with the host (in this case the species she relies upon is Bombus ruderarius (Red-shanked carder bee)). Also, she needs the host’s workers to forage for pollen because she cannot do that (nor any of her offspring). To make things even more difficult, Bombus ruderarius is not a common species in the Cantabrian Mountains, and Bombus inexspectatus bees look very similar to their hosts. This second aspect is why the species was only identified in 1963, and only years later it was confirmed that the two species I’ve mentioned here are connected (Hines & Cameron, 2010 – see below).
I have photos of a bumblebee that fits the coloration of Bombus inexspectatus, but they aren’t good enough for identification. So, I will not post anything until I have something that is certain.

Anyway, all of this means that there are very few observations of this species that we can analyse. The last registered observation is from 2018, with most prior observations coming from entomological collections where the bee was initially misidentified as B. ruderarius. Needless to say, this means that there could still be mislabelled specimens in some of the smaller entomological collections, or private collections, which would help bolster historical data. Given how elusive Bombus inexspectatus is, every data point matters. So, let’s dig into what’s available and see what patterns—if any—we can uncover through analysis.

Key Takeaways

  • Bombus inexspectatus has an unusual lifestyle, where it must cooperate with the host.
  • It is a very rare bumblebee species, both because it is difficult to identify and because its range is very limited.
  • Most observations are historical, making citizen science and scientific fieldwork key to uncovering new data on the species.

3.0 Analysing the Data

3.1 First Steps

Bumblebee data for Europe can come from two main sources.

  • Atlas Hymenoptera – you can download a .csv file per species. The main issue is that the data has not been updated since around 2013, and the type of data per observation is very limited, with only really the basics (location and date(sometimes)). The data comes from old scientific articles and from old collections.
  • GBIF – a massive data repository. You can download a data package with lots of information per observation (if the people uploading the observation have decided to include it). GBIF includes all verified data from the website I use, Observation.org.

So, the first step is to remove most of the data columns (each row in a dataset is an observation), because many of the columns are empty (e.g. life stage), or have information that is not interesting to us (e.g., some of the taxonomy elements are too detailed).

The next step is to integrate both the Atlas Hymenoptera and GBIF data sets together. I add the AH data to the cleaned GBIF file and make sure to tag the imported data as coming from the AH so I can split it out later for visualisation.

Step three is to remove all data that falls outside of Spain, in this case all the observations in the Alps. Not that those aren’t interesting … but the blog is focused on Cantabria and the surrounding regions, and adding the Alps data might distract the reader. In future posts, I’ll need to decide if I keep the focus on this region of Spain or show the data for all of Spain.

3.2 Assumptions Made & Manipulation of Data

These are basic initial steps I do each time, I won’t highlight them in detail for each Data Dwellers post, but you can always ask below if you want to know more. The most important element are the assumptions I apply when I go to visualise the data.

For example, in this case, a number of observations in the dataset came with a NULL (this means nothing is entered in a cell in the database) or N/A in the column of counts of individuals observed. To resolve the issue around counts I decided to replace those NULLs with a “1”, so that it indicated that at least 1 individual was observed at that location. Reasoning being, why would you record an observation if you didn’t see anything? Keeping the count to “1” (and not “2” or “10”) meant that the data doesn’t skew towards those NULL observations and weights each equally, compared to the overall dataset.

Another decision I had to make was around data duplication. Combining both datasets meant that some observations could be counted twice because they are recorded in both the GBIF and Atlas Hymenoptera datasets.
For example, if you look at 1988, there are 4 observations in both datasets. However, on the map they aren’t in exactly the same spot. Keeping both in, allows the viewer to see any trend in each dataset (hence the different colours used to visualise them). The larger the datasets the less impact this will have.

Data counts is also the reason for not adding totals to each bar in the bar chart. For example, for 2015 the bar could have a number 10 above or in it. However, we aren’t really interested in totals per se, we’re more interested in trends (i.e., how does the height of each bar in the bar chart relate to the others?). I should not that with such low numbers of observations, any trends are quite speculative. Most people won’t be able to identify Bombus inexspectatus out in the field considering it looks so similar to other species. So, any large upticks are probably due to a focused effort to record bumblebee species by scientists.

I did not find any mistakes (yet) therefore we’ve reached the end of this section. Below is a picture of the dashboard and you can click it to link to the Tableau page where you can check it out.
For those of you who are new to dashboards, you can hover over things and additional information will pop up. For example, each dot on the map has some information about the observation (if anything was available). You can also zoom in on the map, move it around or uncheck observations from a certain source.

Now that we’ve visualised the data and explored some initial patterns, it’s time to think about what comes next—both in terms of improving the analysis and expanding the scope of future posts.

Bombus_inexspectatus Dashboard

Fig 1. – Link to a Tableau Dashboard of Bombus inexspectatus observations. Data from Atlas Hymenoptera and GBIF. Click on the image to visit the dashboard in a new tab.

Key Takeaways

  • Assumptions are key when analysing data. So, we have to be very clear about the assumptions that we are making.
  • Two main sources of data were used. The focus has been on data showing the species’ presence in Spain.
  • The goal here has been to visualise the data and to look for patterns over time and space. The result is the dashboard.

4.0 Next Steps …

As this project evolves, there are several exciting directions I’m planning to explore:

•  Standardising the Dataset. The current Tableau dashboard works well, but the underlying dataset still has inconsistencies due to merging multiple sources. I’ll be refining the structure to ensure smoother integration and more reliable visualisations.

•  Sharing My Workflow in R Markdown. I’m working on creating R Markdown documents to publish on my GitHub. These will walk through my analysis step-by-step, making it easier for others to follow, replicate, or even critique the process. It’s a way to open the door to collaboration and feedback.

•  Learning from the GBIF Data Use Club. I’ll be attending the upcoming webinar on Mapping Occurrences hosted by the GBIF Data Use Club. Their previous sessions have already taught me valuable tricks—like using the taxonKey instead of the scientific name for more consistent searches. I’m excited to apply these insights to future posts, especially when I start diving into butterfly data.

•  Exploring Alternative Mapping Tools. While Tableau has served me well so far, I’m curious about other platforms for species mapping. Depending on what I learn through GBIF and other sources, I may experiment with new tools to enhance the visual storytelling.

•  Tapping into Cleaned Spanish Bee Data. I recently discovered a GitHub repository where someone has already cleaned and organised Spanish bee data from GBIF. I’ll be reviewing their work to see how it might complement or improve my own dataset. More updates on this soon.

If you’re following along and have thoughts, questions, or ideas—drop them in the comments. I’d love to hear from you and keep this conversation going.

5.0 Links

Hines & Cameron, 2010 – Research article on Bombus inexspectatus https://www.life.illinois.edu/scameron/publications/pdfs/HinesCameron2010.pdf

Atlas Hymenoptera data link http://www.atlashymenoptera.net/pagetaxon.aspx?tx_id=3016

GBIF downloaded dataset https://www.gbif.org/occurrence/download/0010366-250711103210423

GBIF Data Use Club https://www.gbif.org/data-use-club

IUCN Red List https://www.iucnredlist.org/species/13340462/57349805

Bumblebee Conservation blog post https://www.bumblebeeconservation.org/bumblebees-of-the-world-blog-series-7-bombus-inexspectatus/

Spanish Ministry for the Environment https://www.miteco.gob.es/content/dam/miteco/es/biodiversidad/temas/inventarios-nacionales/Bombus_inexspectatus_tcm30-198244.pdf

Data Dwellers – Bombus inexspectatus Tkalcu, 1963

Bee-news – Early Bumblebee – Bombus pratorum (Linnaeus, 1761)

Introduction
I was going to write about one of my favourite bumblebees next, but due to the season (early spring) I thought I’d write about a species that starts showing up at this time of year and is actually not all that common in this area (Cabezón de la Sal, Cantabria, Spain).

Early Bumblebee
Bombus pratorum belongs to the subgenus Pyrobombus. The queens are relatively small and one of the earliest to appear each year (as the name might suggest). Queens pop out with regards to colours as the orangey tail makes them look a bit darker and more drab when compared to the whitish tailed bumblebees that are also out. The yellow bands are a crisper colour yellow.

Early Bumblebee (queen) on an unknown plant in Cantabria, Spain.
Early Bumblebee (queen) on an unknown plant in Cantabria, Spain.

Males are fuzzy balls of yellow, with yellow hairs on their heads and with an orangey tail.
I have yet to see a worker.

Early Bumblebee (male) on a dead nettle (Lamium sp.) in Cantabria, Spain.
Early Bumblebee (male) on a dead nettle (Lamium sp.) in Cantabria, Spain.

The subspecies B. p. santonae can be found on the Iberian peninsula, but I have no idea what the differences are, but it is the only subspecies found here. If I compare my pictures with those found in the Falk link (see below) then here the bees have more extensive yellow bands.
There is conflicting information on this subspecies and I do not really know which is correct. Some sources state that this is a higher altitude species (500m+ above sea level), but I’m at around 100m. However, I do not know which other species it could be (see Complicating Factors below). Furthermore, there are very few pictures on the internet.

The one thing that could help me out it a book called Fauna iberíca. Vol. 23. Hymenpotera: Apoidea 1 by Ortíz-Sánchez and Ornosa, but it is costly and in Spanish.

Sigh, bees are not that well detailed in Spain as butterflies are and information is difficult to obtain. Once I find out more I’ll post a follow-up article, as this one’s pretty poor with regards to actual information! haha

Complicating Factors
So, not only is it difficult to find out what B. p. santonae actually looks like, but apparently the subspecies of the Red-tailed Bumblebee (B. lapidarius), which is called B. l. decipiens, has the same colouration in queens! However, they are also normally found at higher altitudes (apparently) here and queens emerge much later (May). Furthermore, they are bigger, but this is something you can only really pick up once you have gained quite some experience out in the field. After only one summer season, I am still far from that required level.

So, I guess the bumblebees I’m seeing are Bombus pratorum santonae, but at the moment I cannot be 100% certain. All I know is that the UK situation is a lot simpler.

Further Reading
– Here is a link to Steven Falk’s Flickr page, lots of good pictures and basic info. He has a good book out on Bees in GB & Ireland!
– A link to P. Rasmont’s page with a distribution map and some other basic info.
– A link to the Natural History Museum page that gives an overview of the colouration of the Early Bumblebee.
– A link to the IUCN page. Great site.
– The Bumblebee Conservation Trust is a great organisation, especially if you live in the UK, they’ve got a helpful site for the beginner and also a place to upload photos and ID other people’s photos. I’m a member even though I live abroad.
– There’s a cool app for the iPad/iPhone by NatureGuides with great drawings. I’ve got the Pro version which has been a good resource for info.
– Dave Goulson’s A Sting in the Tail is a fun read about the world of bumblebees.
– My sightings to date on Observation.org of this species in Cantabria.

Bee-news – Early Bumblebee – Bombus pratorum (Linnaeus, 1761)

Bee-news – Common Carder Bee – Bombus pascuorum (Scopoli, 1763)

I was not sure with which insect/animal I’d start off the blog, but have decided to go with the Common Carder Bee (Bombus pascuorum). Since I’ve been out and about in nature (start of 2015) and recording what I see … well, to the extent that I record what I know about and what interests me … this little bumblebee has been present throughout. I first saw one mid March and have seen them around till now (October). Furthermore, I’ve seen them in all types of environments, from in the city, to near the coast to the farmland around our house. So, without further ado …

Introduction
Bumblebees are social bees that form small hives of 50 to maybe 250 individuals, depending on the species. These bees are usually recognised by their roundish, compact, hairy bodies and can be anywhere from around 10mm to over 20mm in size, the larger forms being some of the larger bees you’ll see around and thus when they land on certain flowers the stalks will bend due to the weight of the bee.

Carder
Carder bees are a group of bumblebees that (subgenus Thoracobombus) usually build their nests in grasses etc. near the ground. The nests are built of mosses and such materials. The name carder comes from the term carding in wool-making, which is the separating and cleaning of the wool fibres. The bees do a similar action with their rear legs in taking moss and such.
Here in Cantabria there are a possible 9 species of carder bee present. I’ve seen 4 of which the Bombus pascuorum is by far the most common. 4 of the species are on IUCN’s Red List with a category of Near Threatened or worse, one of those is also on Spain’s Red List as Vulnerable.

Common Carder
So, yes, the Common Carder is quite common, and here too. It is the one little bumblebee I can rely on seeing when going out. One of the reasons why it might not be as famous as the black and yellow cousins is that the colour is a gingery brown, not something that flashes between all the flowers that it visits … as it visits all types of flowers, both for pollen and nectar.
There are 23 subspecies (ssp.) of B. pascuorum and I’m not quite sure which can be found here, more research to do on my part … I think B. p. dusmeti and/or B. p. maculatus, but don’t quote me on that and I don’t know the differences.
One of the things that makes identification difficult is that these bees look quite similar to Bombus muscorum (Moss Carder) and Bombus humilis (Brown-banded Carder) and I’ve seen both those around here too … therefore, when spotting a fresh Common Carder looking bee it takes a clear photo etc. in order to really ID it properly, the other two bees are quite rare. The Common Carder has more black hairs on both the thorax and abdomen. Also you can approach these bees quite closely and really get down to have a good look as they are rummaging about in a flower. Sometimes they are a bit in a rush, but if you’re lucky it is just slowly moving from flower to flower and there will probably be others around so you can just sit and wait for them to come to you. A good sized bush of Lavender is great as they love it (as do other bees and insects!). There is a park in Santander (Las Llamas) where they have huge stretches of lavender … on sunny days those flowers are covered in bumblebees including some Common Carder (however, Buff-tailed Bumblebees (Bombus terrestris) were more common when I was there this past summer).

I’ll post a couple of pictures of Bombus pascuorum bees from around here, however, for this bee other sites (see below) are better to really get a good idea how to properly ID one.

Common Carder on a type of Knapweed (Centaurea spec.) in Cantabria, Spain.
Common Carder on a type of Knapweed (Centaurea spec.) in Cantabria, Spain.

Common Carder on an unknown plant in Cantabria, Spain.
Common Carder on a type of Betany (Stachys spec.) in Cantabria, Spain.

Further Reading
– Here is a link to Steven Falk’s Flickr page, lots of good pictures and basic info. He’s got a book coming out in a week (early November 2015) or so on Bees in GB & Ireland!
– A link to P. Rasmont’s page with a distribution map and some other basic info.
– A link to the Natural History Museum page that gives an overview of the colouration of the Common Carder Bee. I love how they’ve created the images, can at times be better than a drawing. The site can be used to compare different bees’ colourations.
– A link to the IUCN page. Great site.
– The Bumblebee Conservation Trust is a great organisation, especially if you live in the UK, they’ve got a helpful site for the beginner and also a place to upload photos and ID other people’s photos. I’m a member even though I live abroad.
– There’s a cool app for the iPad/iPhone by NatureGuides with great drawings (those will probably be in S. Falk’s book as it is the same artist). I’ve got the Pro version which has been a good resource for info.
– Dave Goulson’s A Sting in the Tail is a fun read about the world of bumblebees.
– My sightings to date on Observation.org of this species in Cantabria.

Bee-news – Common Carder Bee – Bombus pascuorum (Scopoli, 1763)

Background Info.

So … a little background info on the title of the blog:

One of the bugs you catch when going out to look at birds, butterflies and what not is that you start to want to encounter new species. In the beginning it may just be enough to go out and see what’s around your home, in your garden … you’ve probably spent time flipping through field guides studying the small distribution maps that accompany each specie … with the first steps out the door you may recognise that Magpie (Pica pica) and the coming days each time you go out you may notice small groups of magpies (called parliaments) in the fields surrounding your village … at a certain point you’re ready to see something new and not just what you com across on a daily basis. You can do two things:
– look closer at the things around you.
– go further afield to new types of habitat (go to a nearby river, walk up a hill nearby to a large area of pine trees).

Cullum’s Bumblebee (Bombus cullumanus) is one of those species you just really hope to come across one day (usually through luck). Hence the title of the blog. Not only will me finding that bumblebee require me to look closer at the things around me, but it will also require me to go a little further afield that where I’ve been up till now …
Will ever find this species? Who knows. They say it is extinct in this part of Europe but they also say that more research is required into the distribution of the species. Who are they? The bee experts.
I’m stubborn and will try my best. I’ve already found certain species of butterfly and dragonfly that weren’t thought to fly here so who knows …

Cullum’s Bumblebee will probably be one of the most difficult searches, but for many species there will be a similar urge to try to find them in Cantabria.

Cheers,
bart.

Should you want to know more about Cullum’s Bumblebee go to the:
Atlas Hymenoptera run by Pierre Rasmont (a highly rated Belgian scholar on bees).
IUCN Red List page for the species to get more information about habitat and distribution (you’ll note that P. Rasmont is one of the assessors there).
Flickr page created by the excellent Steven Falk, who will be coming out with a book on European bees soon.
– A difficult/academic article (PDF) by Paul Williams et al. (including P. Rasmont), from 2012, on just how extinct this extinct bumblebee is.
– I’ll write a more extensive post in the future on Bombus cullumanus.

Background Info.