A Singapore Government Agency Website

How to identify

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 Weather APIs will be unavailable from 24 Nov 2024 12:00 AM to 12:00 PM due to upstream maintenance.

Economy

Monthly Gazetted Hotels Statistics

Data from Jan 2013 to Dec 2015Updated 6 months ago

STB (Singapore Tourism Board)

Data explorer

MonthlyGazettedHotelsStatistics.csv (36 rows, 2.2 KB)

Year-Month Month (YYYY-MM)	Maximum Room Nights Numeric	Paid Lettings Numeric	Available Room Nights Numeric	Gross lettings (Room Nights) Numeric	Standard Average Occupancy Rate (AOR) Numeric	Total Room Revenue Numeric	Standard Average Room Rate (ARR) Numeric	Revenue Per Available Room (RevPAR) Numeric
(Null)0.0%	(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-01	1138320	930160	1108416	935253	84.4	238.0	254.5	214.8
2013-02	1028160	860987	1006850	865561	86.0	219.5	253.6	218.0
2013-03	1138289	978904	1116897	984355	88.1	250.8	254.7	224.5
2013-04	1101870	908096	1078754	912760	84.6	231.0	253.1	214.2
2013-05	1138599	939340	1113709	944633	84.8	239.7	253.8	215.3
2013-06	1101870	946398	1082298	951709	87.9	246.5	259.0	227.7
2013-07	1138760	985951	1120089	991271	88.5	244.9	247.1	218.6
2013-08	1135074	997854	1113655	1003270	90.1	258.1	257.2	231.7
2013-09	1098150	906494	1076367	911655	84.7	253.1	277.6	235.2
2013-10	1137371	969669	1112329	975330	87.7	257.1	263.6	231.1

Column legend

Title	Column name	Data type	Unit of measure	Description
Year-Month	period	Month (YYYY-MM)	-	-
Maximum Room Nights	max	Numeric	Room-Nights	-
Paid Lettings	paid	Numeric	Room-Nights	Room lettings paid for by hotel guests
Available Room Nights	available	Numeric	Room-Nights	Available room nights = Maximum rooms - Rooms under renovation, for staff use, others
Gross lettings (Room Nights)	occupied	Numeric	Room-Nights	Gross lettings (Room Nights) = Adjusted Paid lettings + Complimentary lettings
Standard Average Occupancy Rate (AOR)	aor	Numeric	%	Standard AOR = [Gross lettings (Room Nights) / Available room nights] x 100
Total Room Revenue	rm_revenue	Numeric	S$ million	-
Standard Average Room Rate (ARR)	arr	Numeric	S$	Standard ARR = Total room revenue / Gross lettings
Revenue Per Available Room (RevPAR)	revpar	Numeric	S$	RevPAR = AOR x ARR

Analyse this dataset with Colab Notebook

1. Copy this dataset ID: d_1db0bd2ffd95ac09c66db600e60d3400
2. Click on the button below

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
          
dataset_id = "d_1db0bd2ffd95ac09c66db600e60d3400"
url = "https://data.gov.sg/api/action/datastore_search?resource_id="  + dataset_id 
        
response = requests.get(url)
print(response.json())

Citation

This dataset can be reused and cited in research publications.

Singapore Tourism Board. (2016). Monthly Gazetted Hotels Statistics (2024) [Dataset]. data.gov.sg. Retrieved November 23, 2024 from https://data.gov.sg/datasets/d_1db0bd2ffd95ac09c66db600e60d3400/view

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

231
Views

15
Downloads

23
API calls