Fusion Tables

Fusion Table of Irish Population

Above is a heat map made from a fusion table of the Irish population by each county and how each county is made up of male and female population according to the the 2011 Irish census obtained by the Central Statistics Office displayed using google maps and its geo-sync so give a visualization of the data.

What we can observe from the data is that the larger population centers are based around the coastal areas and that the largest populations centered in counties with major ports/airports, which would traditionally coincide with the Irish cities (Dublin, Galway and Cork) allowing for trade and commerce throughout the ages. The development and availability of public transport, the construction and upgrading of roads, technological development has had bleed off effects from these counties can be seen in the surrounding areas increasing the population.

This information can be used for the planning of roads and transport routes between larger population centers that might encourage growth in counties with lower figures. It can also be used for looking at house and rental prices in relation to population

Creating the Fusion Table

The first step in creating the above heat map was to install Google Fusion Tables on Chrome and import the files that were to be merged into Google Fusion Tables with a geographical map.

To begin data of the population of Ireland extracted from the 2011 census downloaded from the Central Statistics Office Website http://www.cso.ie/en/statistics/population/populationofeachprovincecountyandcity2011/

The next table uploaded contained the geometry information of Ireland and the name of the counties. This in information was taken from Irish independent Website


The information had to be then cleaned taking out errors correcting the locations so that it would match the statistics table. The main issues to be corrected were the county names and also the break down of some counties into north and south areas which had to be combined into the one.

The two files were then merged together creating a new document named ‘Irish Population by County’. When the table was merged, the map was then styled and edited.

To create a random distribution of counties based on population density, on the map view going to the configure map menu and clicking on the change feature styles button. Clicking on the buckets tap option and selecting the fill color tab and selecting 8 buckets. For this map, each bucket was allocated a different colour for each of the population ranges. The colours and ranges assigned were as follows: Grey for counties with a population between 31,798 and 75,000, light purple for counties with a population between 75,000 and 100,000, light blue for counties with a population between 100,000 and 125,000, dark blue for counties with a population between 125,000 and 150,000, green for counties with a population between 150,000 and 200,000, yellow for counties with a population between 200,000 and 400,000, orange for counties with a population between 400,000 and 1,000,000, and finally red for counties with a population between 1,000,000 – 1,274,000. This distribution was chosen to clearly highlight the highly populated counties against the lowly populated counties using contracting colours to highlight the different ranges.

Population Gender Breakdown

Below are charts showing the Population of the whole of Ireland through 1911 – 2011

This graph shows the sum of the population through the ages and then with it broken down by male and female.

This graph shows the male and female population in the Republic of Ireland from 1911 – 2011. This graph shows that the was a large drop in the population until the 1961 at which point the population grew until 1986 where it stayed steady for female population and a drop for males until 1991 where we see an increase with female population increasing more than male.

This graph shows the break down of the Northern Ireland’s gender break down from 1911 – 2011. This shows that there has always been an larger amount of females than males but that the birthrates have increased year on year since 1936 and this gender balance has continued. Possible reasons of this could be for geographical, environmental or economic. With the size of Northern Ireland being so small the opportunities available to its population in relation to employment and livelihood historically younger men would travel to areas where employment was more likely, be that in the England, Scotland, Wales, Republic of Ireland or further afield. With this to consider it would be understandable that the ratio of male to females would be different.

Using this information it was a matter of looking at why the population was so low in the 1960s and why at this point of time the occurrence that would allow for such an increase in population to occur. Possible reasons can be considered as the world in general was going through a population increase after World War 2, but where in the rest of the world and europe this had been happening for a number of years the increase in Ireland took a number of years later to take effect. This coupled with the  change of long period of economic isolation and attempt at self reliance ended and a more open market was introduced. This resulted in better employment opportunities causing a reduction in the amount of people emigrating to other countries with younger people staying in the country and having a family at home which was also helped with the expansion of the welfare system.

Leave a Reply

Your email address will not be published. Required fields are marked *