遇见数据集

World Refinery Database

收藏
Databricks2024-05-09 收录
官方服务:

资源简介:

**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

**概述** 标普全球能源(S&P Global Energy)全球炼油厂数据库(World Refinery Database)可提供从原油进料至精细化产品产出的全下游价值链的深度、历史及前瞻性视角。 您可利用该数据集针对具体炼油厂开展分析,或获取全球每家炼油厂的最新及历史信息,以掌握区域、国家乃至全球层面的行业视角。您可快速检索、下载数据并将其集成至自有模型、仪表板、商业智能及可视化工具中,从而制定稳妥可靠的交易、投资与风险管理策略。 本数据集包含以下内容: - 按装置及配置划分的产能数据 - 详细的所有权现状及历史沿革 - 逐厂的原油加工方案、产品收率及停工数据 - 覆盖原油进料至炼油厂端精细化产品产出的全下游价值链完整视图 **应用场景** - 基本面分析:针对具体炼油厂开展分析,或借助全球每家炼油厂的最新、历史信息及前瞻性的所有权与产能数据,获取区域、国家乃至全球层面的行业视角。通过自动获取原油及成品油的停工、产能、加工量与收率数据,全面掌握完整工艺流程。 - 市场分析:快速评估行业竞争格局,并按企业、区域或设施维度获取统一的行业视图。 - 风险管理分析:快速检索、下载并将数据集成至自有模型、仪表板、商业智能及可视化工具中,从而制定稳妥可靠的交易、投资与风险管理策略。 **产品详情** 示例数据表: A) 产能(CAPACITY) B) 毛利(MARGINS) C) 停工事件(OUTAGES) 示例字段: A) 产能(CAPACITY): YEAR(年份)、QUARTER(季度)、CAPACITY_ID(产能ID)、MBCD、MBSD、MMTCD B) 毛利(MARGINS): DATE(日期)、MARGIN(毛利)、MODIFIED_DATE(修改日期)、MARGIN_TYPE_ID(毛利类型ID)、MARGIN_TYPE_NAME(毛利类型名称) C) 停工事件(OUTAGES): YEAR(年份)、QUARTER(季度)、DATE(日期)、PLANNING_STATUS(规划状态)、OUTAGE_ID(停工ID) 视图说明: - 产能(CAPACITY):获取产能变动情况 - 毛利(MARGINS):获取毛利数据 - 停工事件(OUTAGES):按停工ID、年份、季度、日期、炼油厂ID、工艺装置ID、所有者ID及规划状态查询停工事件 - 所有权(OWNERSHIP):按年份、季度、炼油厂ID及所有者ID查询所有权历史 - 加工量(RUNS):获取每家炼油厂的年度原油加工量 - 收率(YIELDS):获取炼油厂产品收率,所有炼油厂均会被评估其年度产品收率情况 - 参考数据-产能状态(REF_DATA_CAPACITY_STATUSES):获取产能状态列表及其对应ID - 参考数据-城市(REF_DATA_CITIES):获取所有城市列表及其对应ID - 参考数据-配置类型(REF_DATA_CONFIGURATIONS):获取炼油厂配置类型及其对应ID - 参考数据-国家(REF_DATA_COUNTRIES):获取所有国家及其对应ID的集合 - 参考数据-毛利类型(REF_DATA_MARGIN_TYPES):获取所有毛利类型及其对应ID - 参考数据-运营商(REF_DATA_OPERATORS):获取所有炼油厂运营商信息 - 参考数据-停工装置(REF_DATA_OUTAGE_UNITS):获取所有涉及停工的工艺装置 - 参考数据-所有者(REF_DATA_OWNERS):获取所有炼油厂所有者信息。用户可按所有者查询包括产能、原油加工量、产品收率及停工在内的全量数据。同时提供所有者分组,支持按欧佩克(OPEC)、大型综合石油公司、独立炼油商、国有石油企业等各类类别进行检索 - 参考数据-PADD区域(REF_DATA_PADDS):获取所有PADD区域 - 参考数据-工艺装置(REF_DATA_PROCESS_UNITS):获取所有炼油厂工艺装置。ID低于200的工艺装置适用于产能相关数据,ID介于200(含)至300(不含)之间的适用于加工量相关数据,ID为300及以上的则适用于收率相关数据 - 参考数据-工艺装置类别(REF_DATA_PROCESS_UNIT_CATEGORIES):获取单类炼油厂工艺装置类别 - 参考数据-工艺装置组(REF_DATA_PROCESS_UNIT_GROUPS):获取所有炼油厂工艺装置组。工艺装置将被整合至工艺装置组中 - 参考数据-炼油厂信息(REF_DATA_REFINERIES):获取所有炼油厂及其对应信息,包括经纬度、国家名称、城市名称与所有者,或炼油厂配置及所有者信息 - 参考数据-区域(REF_DATA_REGIONS):获取所有区域信息 - 参考数据-州/省(REF_DATA_STATES):获取所有州/省信息 - 全球炼油厂数据字典(WORLDREFINERYDATA_DICTIONARY):收录上述所有视图中各字段的说明与示例,以便用户更深入地理解本数据集

搜集汇总
数据集介绍
World Refinery Database 数据集图片
背景与挑战
背景概述
该数据集提供全球炼油厂的全面运营数据,包括产能配置、所有权历史、原油加工及产品产出等详细信息,支持区域、国家或全球层面的分析,适用于基本面分析、市场评估和风险管理等多种用途。
以上内容由遇见数据集搜集并总结生成
二维码
社区交流群
二维码
科研交流群
商业服务