World Refinery Database

**Overview**

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

**Use cases**
- Fundamental Analysis - Analyze specific refineries, or get a regional, national or global perspective with up-to-date and historic information and forward-looking ownership and capacity data for every refinery in the world. Gain a comprehensive view of the full process flow with automated access to outage, capacity, runs and yields data for crude and refined products
- Market Analysis - Quickly assess the competition and get a single view by company, region or facility
- Risk Analysis - Rapidly retrieve, download and integrate data into your own models, dashboards, business intelligence and visualization tools to develop confident trading, investment, and risk management strategies.

**Product details**

Sample Tables:
A ) CAPACITY
B ) MARGINS
C ) OUTAGES

Sample Fields:
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

搜集汇总

背景与挑战

背景概述

该数据集提供全球炼油厂的全面运营数据，包括产能配置、所有权历史、原油加工及产品产出等详细信息，支持区域、国家或全球层面的分析，适用于基本面分析、市场评估和风险管理等多种用途。