Archived pivot tables – July 1996 to August 2009
The following tables contain data up to August 2009, before the survey change in September 2009. The tables contain data based on 1996 regional tourism organisation (RTO) boundaries and still include the 'hosted' accommodation type.
Regional Tourism Organisation (RTO) Area by Accommodation Type (Type): August 2009 (Excel, 25.1MB)
Origin of Guests and Employment Information by Regional Tourism Organisation (RTO): August 2009 (Excel, 20.1MB)
Territorial Authority (TA) by Total Accommodation: August 2009 (Excel, 1.2MB)
Latest pivot tables
See Accommodation Survey information releases to view the latest pivot tables, which have data from the early 2000s.
From the page, select the latest month, then go to the 'Downloads' box on the page.
We usually publish information releases and pivot tables by the 12th of the month, except January when we publish by about the 20th.
Types of pivot tables
RTO and accommodation type
Previously called Regional Tourism Organisation (RTO) Area by Accommodation Type (Type).
Contains the number of establishments, capacity, occupancy rates, guest nights, guest arrivals, length of stay, and some ratios of these variables.
The graph on the 'Guest nights graph' worksheet changes according to the RTO and accommodation type selected on the worksheet to its right.
RTO and origin
Previously called Origin of Guests and Employment Information by Regional Tourism Organisation (RTO).
Contains domestic and international guest night variables.
Territorial authority area
Previously called Territorial Authority (TA) by Total Accommodation.
Contains the number of establishments, capacity, guest nights, guest arrivals, length of stay, occupancy rates, and some ratios of these variables.
Most of the statistics in the pivot tables are also available from Infoshare.
Problems opening files
If you problems viewing the pivot tables or files, see opening files and PDFs.
Using the pivot tables
Click on the shaded boxes in cell B1, B2, or B3 and select the desired region, territorial authority, or accommodation type. Do not use 'All' in any drop-down menu as 'All' includes every category including 'Total' and is therefore larger than the total.
Printing a selection of data in a spreadsheet
If you only want to print out some of the information in a spreadsheet, either select the pages you want in the print box, or hide the data you don't want to print by highlighting the columns or rows of data you don't want; then right-mouse-click and select 'Hide'.