| key |
id |
string* |
= |
An auto generated sequential number by S&P Global Mobility to uniquely identify a component sales record. It is a unique combination of componentRelationId, componentOriginISOCode and oemAssemblyISOCode. |
| timeline |
fileDate |
date |
=< >= |
Date of the incoming source file. This indicates the date the database was updated to reflect the latest forecast/historical revision date. |
| query_stats |
periodDate |
date |
|
This indicates the year componentVolume, componentPotentialRevenue and vehicleVolumes are forecasted/provided. If the periodDate is greater than the forecastDate, it is a forecasted value. If the periodDate is less than the forecastDate, it is a historical actual value. |
|
componentOriginCountry |
string |
|
Name of the country/territory where the component was manufactured. |
|
componentOriginIso2CountryCode |
string |
|
ISO2 code of the country/territory where the component was manufactured. |
|
componentOriginRegion |
string |
|
Region of the country/territory where the component was manufactured. |
|
componentPotentialRevenue |
long |
|
The forecasted or actual annual revenue in USD for a component in a particular year, identified by periodDate. |
|
componentRelationId |
string |
|
An auto generated sequential number by S&P Global Mobility to uniquely identify the relationship between a componentName, the componentDomain, the supplierId, and the oemId. |
|
componentVolume |
decimal |
|
The forecasted or actual number of individual components that were sold in a particular year, identified by periodDate. |
|
dbDate |
dateTime |
|
The date when the record was created in the source tables in UTC datetime. |
|
forecastDate |
date |
|
Date when the S&P Global Mobility Analyst made/updated the forecast for a particular component. If the forecastDate is greater than the periodDate, it is a historical actual value. If the forecastDate is less than the periodDate, it is a forecasted value. |
|
oemAssemblyCountry |
string |
|
Name of the country/territory where the final assembly took place. |
|
oemAssemblyIso2CountryCode |
string |
|
ISO2 code of the country/territory where the final assembly took place. |
|
oemAssemblyRegion |
string |
|
Region of the country/territory where the final assembly took place. |
|
vehicleProductionVolume |
long |
|
The forecasted or actual number of vehicles that were produced in a particular year, identified by periodDate. |