Dataset: PPRS View

About this Dataset

PPRS View

{{description}}
Publisher name: North Sea Transition Authority
Last updated: 2025-06-14T04:00:06Z

Tables

Table 1

@ukgov.pprs_view3.table_1

7.1 MB
131235 rows
48 columns


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "fieldname" VARCHAR,
  "fieldarea" VARCHAR,
  "location" VARCHAR,
  "orggrpnm" VARCHAR,
  "unitname" VARCHAR,
  "unittypcod" VARCHAR,
  "unittypdes" VARCHAR,
  "periodyrmn" BIGINT,
  "periodyr" BIGINT,
  "periodmnth" BIGINT,
  "periodmnnm" VARCHAR,
  "perioddate" TIMESTAMP,
  "oilprodmas" DOUBLE,
  "oilprodm3" DOUBLE,
  "oilprodmbd" DOUBLE,
  "oilprddens" DOUBLE,
  "agasprodma" DOUBLE,
  "agasproksm" DOUBLE,
  "agaspromms" DOUBLE,
  "agasproden" DOUBLE,
  "dgasprodma" DOUBLE,
  "dgasproksm" DOUBLE,
  "dgaspromms" DOUBLE,
  "dgasproden" DOUBLE,
  "gcondmass" DOUBLE,
  "gcondvol" DOUBLE,
  "gcondmbd" DOUBLE,
  "gcondden" DOUBLE,
  "gasinjcv" DOUBLE,
  "gasinjvol" DOUBLE,
  "gasflarvol" DOUBLE,
  "gasflarden" DOUBLE,
  "gasflarnh" DOUBLE,
  "gasventvol" DOUBLE,
  "gasventden" DOUBLE,
  "gasventnh" DOUBLE,
  "injwatvol" DOUBLE,
  "injwatmbd" DOUBLE,
  "watprodvol" DOUBLE,
  "watprodmbd" DOUBLE,
  "reinjwatvo" DOUBLE,
  "gaspipcv" DOUBLE,
  "gaspipvol" DOUBLE,
  "gaspipvolm" DOUBLE,
  "gaspipdens" DOUBLE
);