home / regos

CertificatesExternalPublicDataWarehouse-csv

3 rows where textbox39 contains "Ecotricity"

View and edit SQL

Link rowid textbox4 textbox13 textbox19 textbox5 textbox12 textbox15 textbox31 textbox18 textbox21 textbox24 textbox27 textbox37 textbox30 textbox33 textbox36 textbox39 textbox45
1545 G00207NWEN LYNCH KNOLL 500.0 REGO England Wind   Feb-2019 2 G00207NWEN0000000089010219280219GEN G00207NWEN0000000090010219280219GEN 1.0 06/03/2019 Revoked 06/03/2019 Ecotricity Group Ltd 3043412
32966 G00207NWEN LYNCH KNOLL 500.0 REGO England Wind   Sep-2018 1 G00207NWEN0000000038010918300918GEN G00207NWEN0000000038010918300918GEN 1.0 03/10/2018 Revoked 03/10/2018 Ecotricity Group Ltd 3043412
84997 G03036NWEN Alveston Wind Park Ltd 6930.0 REGO England Wind   Apr-2018 916 G03036NWEN0000000000010418300418GEN G03036NWEN0000000915010418300418GEN 1.0 16/05/2018 Revoked 10/09/2018 Ecotricity Group Ltd 3043412

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "CertificatesExternalPublicDataWarehouse-csv" (
"textbox4" TEXT,
  "textbox13" TEXT,
  "textbox19" REAL,
  "textbox5" TEXT,
  "textbox12" TEXT,
  "textbox15" TEXT,
  "textbox31" TEXT,
  "textbox18" TEXT,
  "textbox21" INTEGER,
  "textbox24" TEXT,
  "textbox27" TEXT,
  "textbox37" REAL,
  "textbox30" TEXT,
  "textbox33" TEXT,
  "textbox36" TEXT,
  "textbox39" TEXT,
  "textbox45" TEXT
)
Powered by Datasette · Query took 1060.154ms