| key |
id |
string(8)* |
= |
The id field uniquely identifies the entity record. |
| link |
batch |
Batch* |
= |
The Batch for which this BatchRun is an instance. |
| link |
batchRun |
BatchRun* |
= |
The BatchRun in which the Price is calculated. |
|
berthingHoursAverage |
decimal{15,9} |
|
Average time in hours vessels spent in berth. |
|
berthingHoursMax |
decimal{15,9} |
|
Maximum time in hours a vessel spent in berth. |
|
berthingHoursMedian |
decimal{15,9} |
|
Median time in hours vessels spent in berth. |
|
berthingHoursMin |
decimal{15,9} |
|
Minimum time in hours a vessel spent in berth. |
|
date |
date* |
|
Date on which these metrics were collected |
|
isActive |
boolean |
|
Indicates the record is active |
|
iso2 |
string(2) |
|
Standardized UN ISO2 country code if applicable |
|
iso3 |
string(3) |
|
Standardized UN ISO3 country code if applicable |
|
lastUpdateDate |
dateTime* |
|
Date and Time of the last update applied to any of the data contained within the record. |
|
metricPeriodDays |
long(1,31) |
|
Number of days used in calculation of port related time metrics |
|
metricsDate |
dateTime* |
|
Date time of when these metrics were pulled |
| filter_list |
month |
long(1,12) |
=< >= |
The month when the Batch will have a BatchRun. |
|
portHoursAverage |
decimal{15,9} |
|
Average time in hours vessels spent in port. |
|
portHoursMax |
decimal{15,9} |
|
Maximum time in hours a vessel spent in port. |
|
portHoursMedian |
decimal{15,9} |
|
Median time in hours vessels spent in port. |
|
portHoursMin |
decimal{15,9} |
|
Minimum time in hours a vessel spent in port. |
| link |
portId |
Ports* |
= |
Port where the container passed through |
|
regionCode |
string(3) |
|
Code for the geographic region of the port |
|
regionName |
string(30) |
|
Full name of the geographic region of the port |
|
territoryName |
string(50)* |
|
Full name of the territory of the port |
|
uniqueVesselsBerthed |
long(0,10000) |
|
Number of unique vessels berthed at port in the number of days denoted in metricPeriodDays |
|
uniqueVesselsWaiting |
long(0,10000) |
|
Number of unique vessels waiting at port in the number of days denoted in metricPeriodDays |
|
vesselsBerthed |
long(0,10000) |
|
Number of vessels berthed at port |
|
vesselsWaiting |
long(0,10000) |
|
Number of vessels waiting at port. |
|
waitingHoursAverage |
decimal{15,9} |
|
Average waiting time in hours vessels spent in the anchorage zone. |
|
waitingHoursMax |
decimal{15,9} |
|
Maximum waiting time in hours a vessel spent in the anchorage zone. |
|
waitingHoursMedian |
decimal{15,9} |
|
Average waiting time in hours vessels spent in the anchorage zone. |
|
waitingHoursMin |
decimal{15,9} |
|
Minimum waiting time in hours a vessel spent in the anchorage zone. |
|
waitingHoursTotal |
decimal{15,9} |
|
Total waiting time in hours vessels spent in the anchorage zone. |
| filter_list |
year |
long(2000,2100) |
=< >= |
The years when the Batch will have a BatchRun. |