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.

Scam alert

Government officers will never ask you to send money or share your details over the phone. When unsure, hang up and call Scamshield at 1799.
 

Licensed Premises for Liquors & Tabacco Products

CUSTOMS (Singapore Customs)

Last updated 6 Jun 2024


Attribute Legend

AttributesData TypeDescription
NameText-
DescriptionText-

Dataset preview

This code can be used to view the raw JSON dataset for Licensed Premises for Liquors & Tabacco Products. Large datasets may be truncated in the preview. Please download the dataset for complete data.

{
  "type": "FeatureCollection",
  "crs": {
    "type": "name",
    "properties": {
      "name": "urn:ogc:def:crs:OGC:1.3:CRS84"
    }
  },
  "features": [
    {
      "type": "Feature",
      "properties": {
        "Name": "kml_1",
        "Description": "<center><table><tr><th colspan='2' align='center'><em>Attributes</em></th></tr><tr bgcolor=\"#E3E3F3\"> <th>X</th> <td>12662.56755357</td> </tr><tr bgcolor=\"\"> <th>Y</th> <td>33453.17534071</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>POSTALCODE</th> <td>627751</td> </tr><tr bgcolor=\"\"> <th>ROAD_NAME</th> <td>6 Pioneer Walk</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>FLOOR_UNIT</th> <td> </td> </tr><tr bgcolor=\"\"> <th>TELNO</th> <td>6416 3316</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>FAX_NO</th> <td>6323 6411</td> </tr><tr bgcolor=\"\"> <th>COMPANY_NAME</th> <td>Lubritrade Trading Pte Ltd</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>BUILDING_NAME</th> <td> Goldin Logistic Hub</td> </tr><tr bgcolor=\"\"> <th>INC_CRC</th> <td>1AD5C0E5AF6222EE</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>FMEL_UPD_D</th> <td>20120601152401</td> </tr></table></center>"
      },
      "geometry": {
        "type": "Point",
        "coordinates": [
          103.695503951142,
          1.31880931406144,
          0
        ]
      }
    },
    {
      "type": "Feature",
      "properties": {
        "Name": "kml_2",
        "Description": "<center><table><tr><th colspan='2' align='center'><em>Attributes</em></th></tr><tr bgcolor=\"#E3E3F3\"> <th>X</th> <td>17039.40243163</td> </tr><tr bgcolor=\"\"> <th>Y</th> <td>33744.6533679</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>POSTALCODE</th> <td>609124</td> </tr><tr bgcolor=\"\"> <th>ROAD_NAME</th> <td>10 Penjuru Road</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>FLOOR_UNIT</th> <td> </td> </tr><tr bgcolor=\"\"> <th>TELNO</th> <td>6268 1208</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>FAX_NO</th> <td>6268 1669</td> </tr><tr bgcolor=\"\"> <th>COMPANY_NAME</th> <td>Menlo Worldwide Asia Pacific Pte Ltd</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>BUILDING_NAME</th> <td> </td> </tr><tr bgcolor=\"\"> <th>INC_CRC</th> <td>75277D181116382D</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>FMEL_UPD_D</th> <td>20120601152401</td> </tr></table></center>"
      },
      "geometry": {
        "type": "Point",
        "coordinates": [
          103.734831887124,
          1.32144721325154,
          0
        ]
      }
    },
    {
      "type": "Feature",
      "properties": {
        "Name": "kml_3",
        "Description": "<center><table><tr><th colspan='2' align='center'><em>Attributes</em></th></tr><tr bgcolor=\"#E3E3F3\"> <th>X</th> <td>13617.4339514</td> </tr><tr bgcolor=\"\"> <th>Y</th> <td>35078.26614088</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>POSTALCODE</th> <td>629822</td> </tr><tr bgcolor=\"\"> <th>ROAD_NAME</th> <td>10 Enterprise Road</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>FLOOR_UNIT</th> <td> </td> </tr><tr bgcolor=\"\"> <th>TELNO</th> <td>6265 8377</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>FAX_NO</th> <td>6265 3197</td> </tr><tr bgcolor=\"\"> <th>COMPANY_NAME</th> <td>MGB Logistics Pte Ltd</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>BUILDING_NAME</th> <td> </td> </tr><tr bgcolor=\"\"> <th>INC_CRC</th> <td>E7CF0C780270B10D</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>FMEL_UPD_D</th> <td>20120601152401</td> </tr></table></center>"
      },
      "geometry": {
        "type": "Point",
        "coordinates": [
          103.704083133664,
          1.33350648576469,
          0
        ]
      }
    },
    {
      "type": "Feature",
      "properties": {
        "Name": "kml_4",
        "Description": "<center><table><tr><th colspan='2' align='center'><em>Attributes</em></th></tr><tr bgcolor=\"#E3E3F3\"> <th>X</th> <td>23774.31824632</td> </tr><tr bgcolor=\"\"> <th>Y</th> <td>28325.66546217</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>POSTALCODE</th> <td>118480</td> </tr><tr bgcolor=\"\"> <th>ROAD_NAME</th> <td>151 Pasir Panjang Road</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>FLOOR_UNIT</th> <td> </td> </tr><tr bgcolor=\"\"> <th>TELNO</th> <td>6278 9196</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>FAX_NO</th> <td>6278 9198</td> </tr><tr bgcolor=\"\"> <th>COMPANY_NAME</th> <td>New Port Duty Free Pte Ltd</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>BUILDING_NAME</th> <td>#01-06  Pasir Panjang Distripark</td> </tr><tr bgcolor=\"\"> <th>INC_CRC</th> <td>0741F53B69964458</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>FMEL_UPD_D</th> <td>20120601152401</td> </tr></table></center>"
      },
      "geometry": {
        "type": "Point",
        "coordinates": [
          103.795349336797,
          1.27244147666626,
          0
        ]
      }
    },
    {
      "type": "Feature",
      "properties": {
        "Name": "kml_5",
        "Description": "<center><table><tr><th colspan='2' align='center'><em>Attributes</em></th></tr><tr bgcolor=\"#E3E3F3\"> <th>X</th> <td>23774.31824632</td> </tr><tr bgcolor=\"\"> <th>Y</th> <td>28325.66546217</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>POSTALCODE</th> <td>118480</td> </tr><tr bgcolor=\"\"> <th>ROAD_NAME</th> <td>1 Pasir Panjang Road</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>FLOOR_UNIT</th> <td> </td> </tr><tr bgcolor=\"\"> <th>TELNO</th> <td>6272 0912</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>FAX_NO</th> <td>6273 0332</td> </tr><tr bgcolor=\"\"> <th>COMPANY_NAME</th> <td>Oceanic Trading Co Pte Ltd</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>BUILDING_NAME</th> <td>#02-03A Pasir Panjang Distripark</td> </tr><tr bgcolor=\"\"> <th>INC_CRC</th> <td>0741F53BD4A1193E</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>FMEL_UPD_D</th> <td>20120601152401</td> </tr></table></center>"
      },
      "geometry": {
        "type": "Point",
        "coordinates": [
          103.795349336797,
          1.27244147666626,
          0
        ]
      }
    },
    {
      "type": "Feature",
      "properties": {
        "Name": "kml_6",
        "Description": "<center><table><tr><th colspan='2' align='center'><em>Attributes</em></th></tr><tr bgcolor=\"#E3E3F3\"> <th>X</th> <td>13489.7472665</td> </tr><tr bgcolor=\"\"> <th>Y</th> <td>34734.24350689</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>POSTALCODE</th> <td>629785</td> </tr><tr bgcolor=\"\"> <th>ROAD_NAME</th> <td>7 Fan Yoong Road</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>FLOOR_UNIT</th> <td> </td> </tr><tr bgcolor=\"\"> <th>TELNO</th> <td>6266 3320</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>FAX_NO</th> <td>6266 3371</td> </tr><tr bgcolor=\"\"> <th>COMPANY_NAME</th> <td>Pan Ocean Transport Pte Ltd</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>BUILDING_NAME</th> <td> </td> </tr><tr bgcolor=\"\"> <th>INC_CRC</th> <td>DD2367327884B3A6</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>FMEL_UPD_D</th> <td>20120601152401</td> </tr></table></center>"
      },
      "geometry": {
        "type": "Point",
        "coordinates": [
          103.702935962503,
          1.33039521416967,
          0
        ]
      }
    },
    {
      "type": "Feature",
      "properties": {
        "Name": "kml_7",
        "Description": "<center><table><tr><th colspan='2' align='center'><em>Attributes</em></th></tr><tr bgcolor=\"#E3E3F3\"> <th>X</th> <td>42954.54019162</td> </tr><tr bgcolor=\"\"> <th>Y</th> <td>34873.87869781</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>POSTALCODE</th> <td>486443</td> </tr><tr bgcolor=\"\"> <th>ROAD_NAME</th> <td>23 Changi South Avenue 2</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>FLOOR_UNIT</th> <td> #04-02</td> </tr><tr bgcolor=\"\"> <th>TELNO</th> <td>6543 2038</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>FAX_NO</th> <td>6543 2078</td> </tr><tr bgcolor=\"\"> <th>COMPANY_NAME</th> <td>RS Bonded Logistics (S) Pte Ltd</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>BUILDING_NAME</th> <td> KTL Distribution Centre</td> </tr><tr bgcolor=\"\"> <th>INC_CRC</th> <td>BF00B6FC6900B0A6</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>FMEL_UPD_D</th> <td>20120601152401</td> </tr></table></center>"
      },
      "geometry": {
        "type": "Point",
        "coordinates": [
          103.967693424383,
          1.33165780793395,
          0
        ]
      }
    },
    {
      "type": "Feature",
      "properties": {
        "Name": "kml_8",
        "Description": "<center><table><tr><th colspan='2' align='center'><em>Attributes</em></th></tr><tr bgcolor=\"#E3E3F3\"> <th>X</th> <td>18558.19808118</td> </tr><tr bgcolor=\"\"> <th>Y</th> <td>32730.22901415</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>POSTALCODE</th> <td>128410</td> </tr><tr bgcolor=\"\"> <th>ROAD_NAME</th> <td>222 Pandan Loop</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>FLOOR_UNIT</th> <td> </td> </tr><tr bgcolor=\"\"> <th>TELNO</th> <td>6771 2113</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>FAX_NO</th> <td>6774 1401</td> </tr><tr bgcolor=\"\"> <th>COMPANY_NAME</th> <td>Shin Tai Ho & Co Pte Ltd</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>BUILDING_NAME</th> <td> </td> </tr><tr bgcolor=\"\"> <th>INC_CRC</th> <td>730FA85E4FA5CC69</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>FMEL_UPD_D</th> <td>20120601152401</td> </tr></table></center>"
      },
      "geometry": {
        "type": "Point",
        "coordinates": [
          103.748479358418,
          1.31227363465514,
          0
        ]
      }
    },
    {
      "type": "Feature",
      "properties": {
        "Name": "kml_9",
        "Description": "<center><table><tr><th colspan='2' align='center'><em>Attributes</em></th></tr><tr bgcolor=\"#E3E3F3\"> <th>X</th> <td>9874.68613643</td> </tr><tr bgcolor=\"\"> <th>Y</th> <td>34068.44563827</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>POSTALCODE</th> <td>629057</td> </tr><tr bgcolor=\"\"> <th>ROAD_NAME</th> <td>28 Joo Koon Circle</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>FLOOR_UNIT</th> <td> </td> </tr><tr bgcolor=\"\"> <th>TELNO</th> <td>6349 5983</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>FAX_NO</th> <td>6862 8300</td> </tr><tr bgcolor=\"\"> <th>COMPANY_NAME</th> <td>Sinwa (Singapore) Pte Ltd</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>BUILDING_NAME</th> <td> </td> </tr><tr bgcolor=\"\"> <th>INC_CRC</th> <td>FD356EC6A166DE5D</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>FMEL_UPD_D</th> <td>20120601152401</td> </tr></table></center>"
      },
 

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

Adding an API key gives you higher rate limits and priority support. Log in to create your API key.

import requests
          
dataset_id = "d_50db8a47e7e5902a29c25fa24978a690"
url = "https://api-open.data.gov.sg/v1/public/api/datasets/" + dataset_id + "/poll-download"
        
response = requests.get(url)
json_data = response.json()
if json_data['code'] != 0:
    print(json_data['errMsg'])
    exit(1)

url = json_data['data']['url']
response = requests.get(url)
print(response.text)

Citation

This dataset can be reused and cited in research publications.

Singapore Customs. (2023). Licensed Premises for Liquors & Tabacco Products (2024) [Dataset]. data.gov.sg. Retrieved September 9, 2026 from https://data.gov.sg/datasets/d_50db8a47e7e5902a29c25fa24978a690/view

About this dataset

Contact

feedback@data.gov.sg

Created on

31 Jul 2023

Licence

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

Agency

CUSTOMS (Singapore Customs)