Searching the PRTB Database

The PRTB publish a list of all registered rental properties in Ireland on their website. The data is split up into 47 separate spreadsheets (xls), one for each county and Dublin postcode. There’s a lot of interesting information in there but it’s very difficult to get at it when it’s in so many files. For this reason I’ve loaded all the information into a database.

Before looking at the data it’s worth bearing a few things in mind,

  • the data is effective 1-Apr-2011
  • there are a lot of properties included in “County Dublin” that are really part of an area code. this has the effect of bumping up the number of properties in “County Dublin”
  • some properties appear to have their floorspace given in square meters while others have it in square feet. this makes it difficult to do a consistent analysis of the full dataset
  • there seems to be a few properties with duplicate entries

I’ve included some high level numbers below. If you’d like to have a look at the data yourself I’ve published it in searchable form here. The code for this application is available on my GitHub page.

Total number of properties: 221,315

Number of properties per county:

Dublin 67,828
Cork 27,631
Galway 15,626
Kildare 8,807
Waterford 6,079
Kerry 5,684
Wexford 5,571
Meath 5,441
Wicklow 5,372
Tipperary 5,250
Sligo 4,545
Westmeath 4,520
Mayo 4,269
Louth 4,223
Clare 3,888
Donegal 3,566
Kilkenny 3,134
Carlow 2,806
Laois 2,276
Offaly 2,165
Longford 1,947
Roscommon 1,922
Cavan 1,783
Limerick 1,764
Leitrim 1,185
Monaghan 222

Number of properties per Dublin area code:

Dublin County 18,216
Dublin 8 8,472
Dublin 15 7,417
Dublin 1 6,792
Dublin 4 6,732
Dublin 7 6,529
Dublin 9 4,726
Dublin 24 3,930
Dublin 2 3,736
Dublin 3 3,708
Dublin 18 3,201
Dublin 14 2,902
Dublin 6W 2,599
Dublin 11 2,595
Dublin 12 2,098
Dublin 22 1,960
Dublin 16 1,555
Dublin 13 1,496
Dublin 5 1,485
Dublin 20 586
Dublin 17 542
Dublin 10 362