Procurement Contracts
Lincolnshire County Council
@ukgov.contracts1
Lincolnshire County Council
@ukgov.contracts1
CREATE TABLE procurement_contracts (
"organisation_name" VARCHAR,
"organisation_code" VARCHAR,
"published_date" TIMESTAMP,
"latest_data" BOOLEAN,
"duration_from" TIMESTAMP,
"duration_to" TIMESTAMP,
"geo_entity_name" VARCHAR,
"geo_code" VARCHAR,
"geo_name" VARCHAR,
"geo_uri" VARCHAR,
"reporting_period_type" VARCHAR,
"period" VARCHAR,
"contractreferenceno" VARCHAR,
"titleoftheagreement" VARCHAR,
"localauthoritydirectorateorserviceresponsible" VARCHAR,
"descriptionofgoodsandservices" VARCHAR,
"contractstartdate" TIMESTAMP,
"enddate" TIMESTAMP,
"reviewdate" TIMESTAMP,
"contractvalue" DOUBLE,
"irrecoverablevat" DOUBLE,
"tendertype" VARCHAR,
"suppliername" VARCHAR,
"supplierpostcode" VARCHAR,
"supplierregisteredcompanynumber" VARCHAR,
"smesupplier" VARCHAR,
"vcssupplier" VARCHAR,
"vcsregistrationnumber" DOUBLE
);
CREATE TABLE table_1 (
"dataset_id" 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.