
Overview
** The offer comprises a sample data set containing approximately 100 dated records **
S&P Global Energy World Refinery Database provides an in-depth, historical and forward-looking view of the entire downstream value chain, from crude inputs to detailed product outputs.
You can utilize this dataset to analyze specific refineries, or get a regional, national or global perspective with up-to-date and historic information for every refinery in the world. Quickly retrieve, download and integrate data into your own models, dashboards, business intelligence and visualization tools to develop confident trading, investment, and risk management strategies.
Dataset Overview:
- Capacity data by unit and configuration
- Detailed ownership status and history
- Refinery-by-refinery crude slate, yields and outages data
- A complete view of the entire downstream value chain - from crude inputs to detailed product outputs at the refinery level
Tables:
| CAPACITY |
|---|
| YEAR |
| QUARTER |
| CAPACITY_ID |
| MBCD |
| MBSD |
| MMTCD |
| MARGINS |
|---|
| DATE |
| MARGIN |
| MODIFIED_DATE |
| MARGIN_TYPE_ID |
| MARGIN_TYPE_NAME |
| OUTAGES |
|---|
| YEAR |
| QUARTER |
| DATE |
| PLANNING_STATUS |
| OUTAGE_ID |
Views:
| VIEW TITLE | VIEW DESCRIPTION |
|---|---|
| CAPACITY | Get capacity changes |
| MARGINS | Get margin data |
| OUTAGES | Get outages by OutageId, Year, Quarter, Date, RefineryId, ProcessUnitId, OwnerId, and PlanningStatus |
| OWNERSHIP | Get ownership history by Year, Quarter, RefineryId, and OwnerId |
| RUNS | Get the annual crude runs for each refinery |
| YIELDS | Get refinery yields. Every refinery is evaluated for annual product yields |
| REF_DATA_CAPACITY_STATUSES | Get the list of Capacity statuses and their corresponding Ids |
| REF_DATA_CITIES | Get a list of all cities and their corresponding Ids |
| REF_DATA_CONFIGURATIONS | Get refinery configurations and their corresponding Ids |
| REF_DATA_COUNTRIES | Get a collection of all countries and their corresponding Ids |
| REF_DATA_MARGIN_TYPES | Get all margin types and their corresponding Ids |
| REF_DATA_OPERATORS | Get all refinery operators |
| REF_DATA_OUTAGE_UNITS | Get all outage process units |
| REF_DATA_OWNERS | Get all refinery owners. Users can query by owner for all the data including capacity, crude run, product yield and outage. Owner groups are also provided to allow search by various categories such as OPEC, major integrated oil companies, independents, state-owned, etc |
| REF_DATA_PADDS | Get all PADDs |
| REF_DATA_PROCESS_UNITS | Get all refinery process units. Process Units with Id below 200 are applicable to Capacity, while starting at 200 and below 300 - applicable to Runs and Ids at 300 and above - to Yields |
| REF_DATA_PROCESS_UNIT_CATEGORIES | Get a single refinery process unit category |
| REF_DATA_PROCESS_UNIT_GROUPS | Get all refinery process unit groups. Process units are combined into Process Unit Groups |
| REF_DATA_REFINERIES | Get all refineries and corresponding information such as latitude/longitude, Country name, City Name and Owner, or refinery configuration and owner |
| REF_DATA_REGIONS | Get all regions |
| REF_DATA_STATES | Get all states/provinces |
| WORLDREFINERYDATA_DICTIONARY | Contains descriptions and examples of each of the columns in the above views for a better understanding of the dataset |
Details
Introducing multi-product solutions
You can now purchase comprehensive solutions tailored to use cases and industries.
Features and programs
Financing for AWS Marketplace purchases
Pricing
Vendor refund policy
Not applicable - product available free of charge.
How can we make this page better?
Legal
Vendor terms and conditions
Content disclaimer
Delivery details
AWS Data Exchange (ADX)
AWS Data Exchange is a service that helps AWS easily share and manage data entitlements from other organizations at scale.
Additional details
You will receive access to the following data sets.
Data set name | Type | Historical revisions | Future revisions | Sensitive information | Data dictionaries | Data samples |
|---|---|---|---|---|---|---|
world-refinery-database | All historical revisions | All future revisions | Not included | Not included |