Name: Procurement Pipeline
Creator: UK Government
License: https://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/

About this Dataset

Procurement Pipeline

This dataset contains the current procurement pipeline for Lincolnshire County Council. It details all planned procurement activities for the next 18 months from the date of publication.
Publisher name: Lincolnshire County Council
Last updated: 2024-08-13T04:00:01Z

Tables

Procurement Pipeline

@ukgov.pipeline.procurement_pipeline

57.82 kB
236 rows
23 columns

CREATE TABLE procurement_pipeline (
  "organisationname" VARCHAR,
  "organisationcode" VARCHAR,
  "publisheddate" TIMESTAMP,
  "latestdata" BOOLEAN,
  "durationfrom" TIMESTAMP,
  "durationto" TIMESTAMP,
  "geoentityname" VARCHAR,
  "geocode" VARCHAR,
  "geoname" VARCHAR,
  "geouri" VARCHAR,
  "directorate" VARCHAR,
  "new_or_existing" VARCHAR,
  "reference" VARCHAR,
  "contract_title" VARCHAR,
  "summary" VARCHAR,
  "procurement_start_date" VARCHAR,
  "anticipated_contract_length_months" VARCHAR  -- Anticipated Contract Length (Months),
  "anticipated_contract_start_date" VARCHAR,
  "estimated_value" VARCHAR,
  "procurement_route" VARCHAR,
  "category_cpv_code" VARCHAR  -- Category - CPV Code,
  "department" VARCHAR,
  "primary_contact" VARCHAR
);

Table 2

@ukgov.pipeline.table_2

11.58 kB
23 rows
12 columns

CREATE TABLE table_2 (
  "dataset_id_dsid" BIGINT  -- Dataset ID (DSID),
  "dataset_name" VARCHAR,
  "field" VARCHAR,
  "type" VARCHAR,
  "mandatory_or_optional_requirement_mor" VARCHAR  -- Mandatory Or Optional Requirement (MOR),
  "field_description" VARCHAR,
  "schema" VARCHAR,
  "lcc_mapping" VARCHAR,
  "schema_comments" VARCHAR,
  "schema_data_rules_comment" VARCHAR,
  "formatreference" VARCHAR,
  "example" VARCHAR
);