Procurement Pipeline
Lincolnshire County Council
@ukgov.pipeline
Lincolnshire County Council
@ukgov.pipeline
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_start_date" VARCHAR,
"estimated_value" VARCHAR,
"procurement_route" VARCHAR,
"category_cpv_code" VARCHAR,
"department" VARCHAR,
"primary_contact" VARCHAR
);
CREATE TABLE table_2 (
"dataset_id_dsid" BIGINT,
"dataset_name" VARCHAR,
"field" VARCHAR,
"type" VARCHAR,
"mandatory_or_optional_requirement_mor" VARCHAR,
"field_description" VARCHAR,
"schema" VARCHAR,
"lcc_mapping" VARCHAR,
"schema_comments" VARCHAR,
"schema_data_rules_comment" VARCHAR,
"formatreference" VARCHAR,
"example" VARCHAR
);
Anyone who has the link will be able to view this.