Dataset: UN-LOCODE Code List

About this Dataset

UN-LOCODE Code List

UN/LOCODE, the United Nations Code for Trade and Transport Locations, is a geographic coding scheme developed and maintained by United Nations Economic Commission for Europe. Wikipedia

Tables

Code List

@kaggle.programmerrdai_unlocode_code_list.code_list

3.43 MB
111553 rows
12 columns


CREATE TABLE code_list (
  "change" VARCHAR,
  "country" VARCHAR,
  "location" VARCHAR,
  "name" VARCHAR,
  "namewodiacritics" VARCHAR,
  "subdivision" VARCHAR,
  "status" VARCHAR,
  "function" VARCHAR,
  "date" DOUBLE,
  "iata" VARCHAR,
  "coordinates" VARCHAR,
  "remarks" VARCHAR
);

Country Codes 1

@kaggle.programmerrdai_unlocode_code_list.country_codes_1

6.42 KB
249 rows
2 columns


CREATE TABLE country_codes_1 (
  "countrycode" VARCHAR,
  "countryname" VARCHAR
);

Function Classifiers

@kaggle.programmerrdai_unlocode_code_list.function_classifiers

2.42 KB
10 rows
2 columns


CREATE TABLE function_classifiers (
  "functioncode" VARCHAR,
  "functiondescription" VARCHAR
);

Status Indicators

@kaggle.programmerrdai_unlocode_code_list.status_indicators

2.82 KB
14 rows
2 columns


CREATE TABLE status_indicators (
  "ststatus" VARCHAR,
  "stdescription" VARCHAR
);

Subdivision Codes

@kaggle.programmerrdai_unlocode_code_list.subdivision_codes

72.74 KB
4650 rows
3 columns


CREATE TABLE subdivision_codes (
  "sucountry" VARCHAR,
  "sucode" VARCHAR,
  "suname" VARCHAR
);