A Singapore Government Agency Website
Official website links end with .gov.sg
Government agencies communicate via .gov.sg websites (e.g. go.gov.sg/open). Trusted websites

Secure websites use HTTPS

Look for a lock () or https:// as an added precaution. Share sensitive information only on official, secure websites.

Real-time APIs will be unavailable from September 19th, 2024, 06:00 pm to September 19th, 2024, 10:00 pm due to upstream service's system maintenance. We apologise for the inconvenience caused.

Monthly Gazetted Hotels Statistics

Data from Jan 2013 to Dec 2015Updated 4 months ago

STB (Singapore Tourism Board)

Data explorer

MonthlyGazettedHotelsStatistics.csv (36 rows, 2.2 KB)

Year-Month
Datetime (Month) "YYYY-MM"
Maximum Room Nights
Numeric (General)
Paid Lettings
Numeric (General)
Available Room Nights
Numeric (General)
Gross lettings (Room Nights)
Numeric (General)
Standard Average Occupancy Rate (AOR)
Numeric (General)
Total Room Revenue
Numeric (General)
Standard Average Room Rate (ARR)
Numeric (General)
Revenue Per Available Room (RevPAR)
Numeric (General)
(Null)0.0%
(Null)0.0%
(Null)0.0%
(Null)0.0%
(Null)0.0%
(Null)0.0%
(Null)0.0%
(Null)0.0%
2013-011138320930160110841693525384.4238.0254.5214.8
2013-021028160860987100685086556186.0219.5253.6218.0
2013-031138289978904111689798435588.1250.8254.7224.5
2013-041101870908096107875491276084.6231.0253.1214.2
2013-051138599939340111370994463384.8239.7253.8215.3
2013-061101870946398108229895170987.9246.5259.0227.7
2013-071138760985951112008999127188.5244.9247.1218.6
2013-0811350749978541113655100327090.1258.1257.2231.7
2013-091098150906494107636791165584.7253.1277.6235.2
2013-101137371969669111232997533087.7257.1263.6231.1

Column legend

Title
Column name
Data type
Unit of measure
Description
Year-MonthperiodDatetime (Month) "YYYY-MM"--
Maximum Room NightsmaxNumeric (General)Room-Nights-
Available Room NightsavailableNumeric (General)Room-NightsAvailable room nights = Maximum rooms - Rooms under renovation, for staff use, others
Gross lettings (Room Nights)occupiedNumeric (General)Room-NightsGross lettings (Room Nights) = Adjusted Paid lettings + Complimentary lettings
Standard Average Occupancy Rate (AOR)aorNumeric (General)%Standard AOR = [Gross lettings (Room Nights) / Available room nights] x 100
Total Room Revenuerm_revenueNumeric (General)S$ million-
Standard Average Room Rate (ARR)arrNumeric (General)S$Standard ARR = Total room revenue / Gross lettings
Revenue Per Available Room (RevPAR)revparNumeric (General)S$ RevPAR = AOR x ARR

Sample OpenAPI query

This code can be used to test a sample API query. It retrieves the data catalogue of this dataset. For a complete guide on query parameters and syntax, please refer to the API documentation. Try it out on your browser to see the response schema.

import requests
          
datasetId = "d_1db0bd2ffd95ac09c66db600e60d3400"
url = "https://data.gov.sg/api/action/datastore_search?resource_id="  + datasetId 
        
response = requests.get(url)
print(response.json())

About this dataset

Contact

feedback@data.gov.sg

Created on

08 Jul 2016

Licence

Free forever for personal or commercial use, under the Open Data Licence.

Agency

STB (Singapore Tourism Board)

Dataset usage

226
Views
15
Downloads
23
API calls