Notes on the Database

This database was composed as part of research for the Digital Arts and Humanities PhD. This data was transcribed from the 'Abstracts of Irish Exports and Imports' in the National Library of Ireland. Some alterations to the original database were required to allow for browsing online.

The original, unaltered database, which is available here, is where much of the data for the thesis was taken. This data was transcribed in imperial units, as it appears in the ledgers. This database contains 26,258 data points for the imports table, 19,488 in the exports table, 1,552 types of product in the goods table, and lists 121 countries or regions in the countries table. The goods table and the country table contain the primary keys to search the database. If you are using this database please find the list of country codes here and the goods codes here.

The normalised database contains half the number of data points in both the exports and imports tables. This is due to the exclusion of a total column that contained the overall volumes of Irish trade. The reasons for this exclusion are detailed below, but this column has been replaced by a dynamically generated totals column on the website that calculates the overall volumes of Cork's trade in a product. For use online this database was altered to make it both user friendly to search and to standardise the measurement units, as much as possible. If this was not done it would have been very difficult to create dynamic visualisations based on user input.

Whereas the un-normalised database lists 1,522 types of goods as recorded in the ledgers, the normalised database has been rationalised to 641 types of goods. Many of the 1,522 goods listed in the un-normalised database were duplicates or variations of the same product, but with a different unit of measurement. In some years, if volumes of trade were low, a good may have been recorded in pounds rather than stones. This were standardised. In other years there were variations in how the hundredweight unit was recorded. This is especially apparent in the beef and butter trade. In some years the hundredweight was recorded as CWT, which divided as hundredweight-stone-pounds. However, in some instances this was recorded as CQLB, which breaks down as hundredweight-quarters-pounds. Both types of hundredweight were standardised to CWT to facilitate calculating totals. They were then decimalised to facilitate visualisations. For example, and entry of 1.4.7 CWT, which would be one hundredweight, four stone and seven pounds, becomes 1.5625 CWT in the database. Some other goods, such as wool and wood products, were simplified. There were 137 varieties of wood product recorded and this level of detail was excessive for the purposes of the online database, and in many instances only a single entry was recorded under a product. For wood staves alone there were 22 variations. This was simplified down to 12 types of wood product. A full list of the normalised goods can be accessed here.

The other major area where normalisation was undertaken was in the country and region table. The un-normalised database contains 121 listed regions. This was simplified down to 97. This normalisation was straightforward. An example of this type of normalisation would be Spain, which in the original database distinguished between whether Spanish regions were on the Mediterranean or not. This was also the case for France and Portugal. This were simpliefied to simply record the country as there was little trade between Cork and the Mediterranean regions. After 1819 there were four distinct entries for England, which had seperate listings for goods that were subject to duty, free from duty or foreign and colonial produce. This was also normalised to England. This changes were undertaken to facilitate both the search and visualisation functionality. A breakdown of this process is available here.

This database also contains an additional column that was removed from the online version. This column, the 'totals' column, records the total volumes of a product traded by Ireland with a region for that year. However, this was only transcribed when Cork also undertook that trade in that year. This means that there is a very great potential to unintentionally misrepresent the volumes of Irish trade unless great care is taken. A more accurate overview of volumes of Irish trade is available here. Due to this issue this column was excluded from the final database and replaced with a dynamically generated 'Total' column. This column is calculated by the database based on the users request and it returns the total volumes of Cork's trade in a good. This column is not available in the downloadable normalised database as it is recalculated on each query. Although it is possible to do similar calculations on the unnormalised database they are not accurate due to the variations in goods and measurements already mentioned.