| key |
id |
string* |
= |
ISO 3166-1 alpha-2 codes are two-letter country codes defined in ISO 3166-1, part of the ISO 3166 standard published by the International Organization for Standardization (ISO), to represent countries, dependent territories, and special areas of geographical interest. |
| timeline |
fromDbDate |
dateTime |
=< >= |
When the record was created in the source table - UTC datetime. This field is maintained on a go-forward basis starting Q3 2023. |
|
autoMarket |
string |
|
Refers to the division of the seven global region(s) into 15 sales markets and their respective countries. |
|
autoRegion |
string |
|
Indicates the region where final sale occurs. |
| link |
batch |
Batch* |
= |
The batch that provided the data |
| link |
batchRun |
BatchRun* |
= |
The batchRun that provided the data |
|
countryName |
string |
|
Indicates the specific country or territory where the vehicle is sold or registered. |
|
countryNameImr |
string |
|
Indicates the specific country or territory where the vehicle is sold or registered. S&P Global Mobility's nomenclature. Use it to connect to other data products. |
|
countryNamePs |
string |
|
Indicates the specific country or territory where the vehicle is sold or registered. S&P Global Mobility's nomenclature. Use it to connect to other data products. |
|
fileDate |
date |
|
file identifier in data lake |
|
geographyId |
long* |
|
Auto generated sequential number |
|
timestamp |
dateTime |
|
UTC timestamp in which the record was inserted in the database. |
|
toDbDate |
dateTime |
|
The end datetime (UTC) of the record in the database.This date is when the value changes and the record is closed; it can be used to track history of changes. In most cases, the toDBDate field is NULL, meaning the record is current. This field is maintained on a go-forward basis starting Q3 2023. |