World Refinery Database

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.

This dataset includes:

- 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

<p><br/></p>

Sample Tables:<br/>A ) CAPACITY<br/>B ) MARGINS<br/>C ) OUTAGES

Sample Fields:<br/>A ) CAPACITY

- YEAR
- QUARTER
- CAPACITY_ID
- MBCD
- MBSD
- MMTCD

B ) MARGINS

- DATE
- MARGIN
- MODIFIED_DATE
- MARGIN_TYPE_ID
- MARGIN_TYPE_NAME

C ) OUTAGES

- YEAR
- QUARTER
- DATE
- PLANNING_STATUS
- OUTAGE_ID

View Descriptions:

- 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