Data
From QED
| Maps |
| Narratives |
| Data and Analysis |
Table tbl_ports
Contents |
Overview
The tbl_ports table gives details about annual trade by SITC code in selected years. The volume of trade in each direction is given in US dollars .... using ..... conversion....
The relationships between tbl_ports and other MG tables is shown in the following diagram:
Fields
| Field | Type | Null | Primary | Comments |
|---|---|---|---|---|
| recidp | double(15,5) | No | Key | Record ID for this table |
| year | decimal(11,0) | Yes | yyyy | |
| sitc | varchar(5) | Yes | Standard International Trade Classification Rev.3 or "Total"" | |
| from | varchar(50) | Yes | country code for source | |
| **** |
Notes:
- With the following exceptions, the country codes are the two-letter codes defined by ISO_3166-1_alpha-2ISO.
- "Fm EGy" is the former East Germany (....)
- "Fm Yug" is the former Yugoslavia (....)
- "FmCzech" is the former Czechoslovakia
- "USSR" is the former Soviet Union
- "World" is ????
Here "World" signifies .....
Sources
Quality Control
Download
To download the table as a CSV file or Excel spreadsheet including headers, follow this link: ExportTable/tbl_ports
Alternatively ....
The following summary statistics and checksums are applicable for the current dataset as of 2006/05/15.
Summary Statistics
| N | 2117502 |
|---|---|
| Number of two-letter country codes | 83 |
Notes:
- N is the number of data rows in the table; the header is not counted.
Checksums
These checksums apply to the file obtained by following the link above.
Archived Versions
| Date | Link |
|---|---|
| 2006/05/15 | Media:tobedetermined |
