Baselight
Sign In

Contracts Finder Notices 06–2025

Crown Commercial Service

@ukgov.contracts_finder_notices_06_2025

Loading...
Loading...

About this Dataset

Contracts Finder Notices 06–2025

This dataset contains Contracts Finder notices for Jun 2025. The dataset uses the Open Contracting Data Standard (OCDS) flattened CSV format. Each file contains all OCDS releases for a given calendar day
Publisher name: Crown Commercial Service
Last updated: 2025-06-30T04:00:29Z

Tables

Contracts Finder OCDS 2025-06-20

@ukgov.contracts_finder_notices_06_2025.contracts_finder_ocds_2025_06_20
  • 496.36 KB
  • 167 rows
  • 372 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2025_06_20 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" VARCHAR,
  "extensions_1" VARCHAR,
  "extensions_2" VARCHAR,
  "extensions_3" VARCHAR,
  "extensions_4" VARCHAR,
  "extensions_5" VARCHAR,
  "extensions_6" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" TIMESTAMP,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_title" VARCHAR,
  "releases_0_planning_milestones_0_id" DOUBLE,
  "releases_0_planning_milestones_0_title" VARCHAR,
  "releases_0_planning_milestones_0_type" VARCHAR,
  "releases_0_planning_milestones_0_duedate" TIMESTAMP,
  "releases_0_planning_documents_0_id" DOUBLE,
  "releases_0_planning_documents_0_documenttype" VARCHAR,
  "releases_0_planning_documents_0_description" VARCHAR,
  "releases_0_planning_documents_0_url" VARCHAR,
  "releases_0_planning_documents_0_datepublished" TIMESTAMP,
  "releases_0_planning_documents_0_format" VARCHAR,
  "releases_0_planning_documents_0_language" VARCHAR,
  "releases_0_planning_documents_1_id" DOUBLE,
  "releases_0_planning_documents_1_description" VARCHAR,
  "releases_0_planning_documents_1_url" VARCHAR,
  "releases_0_planning_documents_1_format" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_datepublished" TIMESTAMP,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_classification_scheme" VARCHAR,
  "releases_0_tender_classification_id" BIGINT,
  "releases_0_tender_classification_description" VARCHAR,
  "releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_0_id" DOUBLE,
  "releases_0_tender_additionalclassifications_0_description" VARCHAR,
  "releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_1_id" DOUBLE,
  "releases_0_tender_additionalclassifications_1_description" VARCHAR,
  "releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_2_id" DOUBLE,
  "releases_0_tender_additionalclassifications_2_description" VARCHAR,
  "releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_3_id" DOUBLE,
  "releases_0_tender_additionalclassifications_3_description" VARCHAR,
  "releases_0_tender_additionalclassifications_4_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_4_id" DOUBLE,
  "releases_0_tender_additionalclassifications_4_description" VARCHAR,
  "releases_0_tender_additionalclassifications_5_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_5_id" DOUBLE,
  "releases_0_tender_additionalclassifications_5_description" VARCHAR,
  "releases_0_tender_additionalclassifications_6_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_6_id" DOUBLE,
  "releases_0_tender_additionalclassifications_6_description" VARCHAR,
  "releases_0_tender_additionalclassifications_7_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_7_id" DOUBLE,
  "releases_0_tender_additionalclassifications_7_description" VARCHAR,
  "releases_0_tender_additionalclassifications_8_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_8_id" DOUBLE,
  "releases_0_tender_additionalclassifications_8_description" VARCHAR,
  "releases_0_tender_additionalclassifications_9_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_9_id" DOUBLE,
  "releases_0_tender_additionalclassifications_9_description" VARCHAR,
  "releases_0_tender_additionalclassifications_10_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_10_id" DOUBLE,
  "releases_0_tender_additionalclassifications_10_description" VARCHAR,
  "releases_0_tender_additionalclassifications_11_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_11_id" DOUBLE,
  "releases_0_tender_additionalclassifications_11_description" VARCHAR,
  "releases_0_tender_additionalclassifications_12_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_12_id" DOUBLE,
  "releases_0_tender_additionalclassifications_12_description" VARCHAR,
  "releases_0_tender_additionalclassifications_13_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_13_id" DOUBLE,
  "releases_0_tender_additionalclassifications_13_description" VARCHAR,
  "releases_0_tender_additionalclassifications_14_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_14_id" DOUBLE,
  "releases_0_tender_additionalclassifications_14_description" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_deliveryaddresses_0_postalcode" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_2_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_2_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_3_region" VARCHAR
);

Contracts Finder OCDS 2025-06-21

@ukgov.contracts_finder_notices_06_2025.contracts_finder_ocds_2025_06_21
  • 87.01 KB
  • 6 rows
  • 86 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2025_06_21 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" VARCHAR,
  "extensions_1" VARCHAR,
  "extensions_2" VARCHAR,
  "extensions_3" VARCHAR,
  "extensions_4" VARCHAR,
  "extensions_5" VARCHAR,
  "extensions_6" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" TIMESTAMP,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_datepublished" TIMESTAMP,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_classification_scheme" VARCHAR,
  "releases_0_tender_classification_id" BIGINT,
  "releases_0_tender_classification_description" VARCHAR,
  "releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_0_id" DOUBLE,
  "releases_0_tender_additionalclassifications_0_description" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_deliveryaddresses_0_postalcode" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_2_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_3_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_4_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_5_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_6_countryname" VARCHAR,
  "releases_0_tender_procurementmethod" VARCHAR,
  "releases_0_tender_procurementmethoddetails" VARCHAR,
  "releases_0_tender_tenderperiod_enddate" TIMESTAMP,
  "releases_0_tender_contractperiod_startdate" TIMESTAMP,
  "releases_0_tender_contractperiod_enddate" TIMESTAMP,
  "releases_0_tender_suitability_sme" DOUBLE,
  "releases_0_tender_suitability_vcse" VARCHAR,
  "releases_0_tender_mainprocurementcategory" VARCHAR,
  "releases_0_parties_0_id" VARCHAR,
  "releases_0_parties_0_name" VARCHAR,
  "releases_0_parties_0_identifier_legalname" VARCHAR,
  "releases_0_parties_0_address_streetaddress" VARCHAR,
  "releases_0_parties_0_address_locality" VARCHAR,
  "releases_0_parties_0_address_postalcode" VARCHAR,
  "releases_0_parties_0_address_countryname" VARCHAR,
  "releases_0_parties_0_contactpoint_name" VARCHAR,
  "releases_0_parties_0_contactpoint_email" VARCHAR,
  "releases_0_parties_0_contactpoint_telephone" VARCHAR,
  "releases_0_parties_0_details_url" VARCHAR,
  "releases_0_parties_0_roles_0" VARCHAR,
  "releases_0_parties_1_id" VARCHAR,
  "releases_0_parties_1_name" VARCHAR,
  "releases_0_parties_1_identifier_legalname" VARCHAR,
  "releases_0_parties_1_address_streetaddress" VARCHAR,
  "releases_0_parties_1_roles_0" VARCHAR,
  "releases_0_buyer_id" VARCHAR,
  "releases_0_buyer_name" VARCHAR,
  "releases_0_awards_0_id" VARCHAR,
  "releases_0_awards_0_status" VARCHAR,
  "releases_0_awards_0_date" TIMESTAMP,
  "releases_0_awards_0_datepublished" TIMESTAMP,
  "releases_0_awards_0_value_amount" BIGINT,
  "releases_0_awards_0_value_currency" VARCHAR,
  "releases_0_awards_0_suppliers_0_id" VARCHAR,
  "releases_0_awards_0_suppliers_0_name" VARCHAR,
  "releases_0_awards_0_contractperiod_startdate" TIMESTAMP,
  "releases_0_awards_0_contractperiod_enddate" TIMESTAMP,
  "releases_0_awards_0_documents_0_id" BIGINT,
  "releases_0_awards_0_documents_0_documenttype" VARCHAR,
  "releases_0_awards_0_documents_0_description" VARCHAR,
  "releases_0_awards_0_documents_0_url" VARCHAR,
  "releases_0_awards_0_documents_0_datepublished" TIMESTAMP,
  "releases_0_awards_0_documents_0_datemodified" TIMESTAMP,
  "releases_0_awards_0_documents_0_format" VARCHAR,
  "releases_0_awards_0_documents_0_language" VARCHAR
);

Contracts Finder OCDS 2025-06-22

@ukgov.contracts_finder_notices_06_2025.contracts_finder_ocds_2025_06_22
  • 84.43 KB
  • 6 rows
  • 83 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2025_06_22 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" VARCHAR,
  "extensions_1" VARCHAR,
  "extensions_2" VARCHAR,
  "extensions_3" VARCHAR,
  "extensions_4" VARCHAR,
  "extensions_5" VARCHAR,
  "extensions_6" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" TIMESTAMP,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_classification_scheme" VARCHAR,
  "releases_0_tender_classification_id" BIGINT,
  "releases_0_tender_classification_description" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_2_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_2_countryname" VARCHAR,
  "releases_0_tender_value_amount" BIGINT,
  "releases_0_tender_value_currency" VARCHAR,
  "releases_0_tender_procurementmethod" VARCHAR,
  "releases_0_tender_procurementmethoddetails" VARCHAR,
  "releases_0_tender_tenderperiod_enddate" TIMESTAMP,
  "releases_0_tender_contractperiod_startdate" TIMESTAMP,
  "releases_0_tender_contractperiod_enddate" TIMESTAMP,
  "releases_0_tender_suitability_sme" BIGINT,
  "releases_0_tender_suitability_vcse" DOUBLE,
  "releases_0_tender_mainprocurementcategory" VARCHAR,
  "releases_0_parties_0_id" VARCHAR,
  "releases_0_parties_0_name" VARCHAR,
  "releases_0_parties_0_identifier_legalname" VARCHAR,
  "releases_0_parties_0_address_streetaddress" VARCHAR,
  "releases_0_parties_0_address_locality" VARCHAR,
  "releases_0_parties_0_address_postalcode" VARCHAR,
  "releases_0_parties_0_address_countryname" VARCHAR,
  "releases_0_parties_0_contactpoint_email" VARCHAR,
  "releases_0_parties_0_roles_0" VARCHAR,
  "releases_0_parties_1_id" VARCHAR,
  "releases_0_parties_1_name" VARCHAR,
  "releases_0_parties_1_identifier_legalname" VARCHAR,
  "releases_0_parties_1_identifier_scheme" VARCHAR,
  "releases_0_parties_1_identifier_id" DOUBLE,
  "releases_0_parties_1_address_streetaddress" VARCHAR,
  "releases_0_parties_1_details_scale" VARCHAR,
  "releases_0_parties_1_details_vcse" DOUBLE,
  "releases_0_parties_1_roles_0" VARCHAR,
  "releases_0_buyer_id" VARCHAR,
  "releases_0_buyer_name" VARCHAR,
  "releases_0_awards_0_id" VARCHAR,
  "releases_0_awards_0_status" VARCHAR,
  "releases_0_awards_0_date" TIMESTAMP,
  "releases_0_awards_0_datepublished" TIMESTAMP,
  "releases_0_awards_0_value_amount" BIGINT,
  "releases_0_awards_0_value_currency" VARCHAR,
  "releases_0_awards_0_suppliers_0_id" VARCHAR,
  "releases_0_awards_0_suppliers_0_name" VARCHAR,
  "releases_0_awards_0_contractperiod_startdate" TIMESTAMP,
  "releases_0_awards_0_contractperiod_enddate" TIMESTAMP,
  "releases_0_awards_0_documents_0_id" BIGINT,
  "releases_0_awards_0_documents_0_documenttype" VARCHAR,
  "releases_0_awards_0_documents_0_description" VARCHAR,
  "releases_0_awards_0_documents_0_url" VARCHAR,
  "releases_0_awards_0_documents_0_datepublished" TIMESTAMP,
  "releases_0_awards_0_documents_0_format" VARCHAR,
  "releases_0_awards_0_documents_0_language" VARCHAR
);

Contracts Finder OCDS 2025-06-23

@ukgov.contracts_finder_notices_06_2025.contracts_finder_ocds_2025_06_23
  • 415.89 KB
  • 206 rows
  • 267 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2025_06_23 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" VARCHAR,
  "extensions_1" VARCHAR,
  "extensions_2" VARCHAR,
  "extensions_3" VARCHAR,
  "extensions_4" VARCHAR,
  "extensions_5" VARCHAR,
  "extensions_6" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" TIMESTAMP,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_0_id" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_0_period_startdate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_0_period_enddate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_0_description" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_0_amount_amount" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_0_amount_currency" VARCHAR,
  "releases_0_planning_documents_0_id" DOUBLE,
  "releases_0_planning_documents_0_documenttype" VARCHAR,
  "releases_0_planning_documents_0_description" VARCHAR,
  "releases_0_planning_documents_0_url" VARCHAR,
  "releases_0_planning_documents_0_datepublished" TIMESTAMP,
  "releases_0_planning_documents_0_format" VARCHAR,
  "releases_0_planning_documents_0_language" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_datepublished" TIMESTAMP,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_classification_scheme" VARCHAR,
  "releases_0_tender_classification_id" DOUBLE,
  "releases_0_tender_classification_description" VARCHAR,
  "releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_0_id" DOUBLE,
  "releases_0_tender_additionalclassifications_0_description" VARCHAR,
  "releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_1_id" DOUBLE,
  "releases_0_tender_additionalclassifications_1_description" VARCHAR,
  "releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_2_id" DOUBLE,
  "releases_0_tender_additionalclassifications_2_description" VARCHAR,
  "releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_3_id" DOUBLE,
  "releases_0_tender_additionalclassifications_3_description" VARCHAR,
  "releases_0_tender_additionalclassifications_4_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_4_id" DOUBLE,
  "releases_0_tender_additionalclassifications_4_description" VARCHAR,
  "releases_0_tender_additionalclassifications_5_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_5_id" DOUBLE,
  "releases_0_tender_additionalclassifications_5_description" VARCHAR,
  "releases_0_tender_additionalclassifications_6_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_6_id" DOUBLE,
  "releases_0_tender_additionalclassifications_6_description" VARCHAR,
  "releases_0_tender_additionalclassifications_7_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_7_id" DOUBLE,
  "releases_0_tender_additionalclassifications_7_description" VARCHAR,
  "releases_0_tender_additionalclassifications_8_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_8_id" DOUBLE,
  "releases_0_tender_additionalclassifications_8_description" VARCHAR,
  "releases_0_tender_additionalclassifications_9_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_9_id" DOUBLE,
  "releases_0_tender_additionalclassifications_9_description" VARCHAR,
  "releases_0_tender_additionalclassifications_10_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_10_id" DOUBLE,
  "releases_0_tender_additionalclassifications_10_description" VARCHAR,
  "releases_0_tender_additionalclassifications_11_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_11_id" DOUBLE,
  "releases_0_tender_additionalclassifications_11_description" VARCHAR,
  "releases_0_tender_additionalclassifications_12_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_12_id" DOUBLE,
  "releases_0_tender_additionalclassifications_12_description" VARCHAR,
  "releases_0_tender_additionalclassifications_13_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_13_id" DOUBLE,
  "releases_0_tender_additionalclassifications_13_description" VARCHAR,
  "releases_0_tender_items_0_id" DOUBLE,
  "releases_0_tender_items_0_deliveryaddresses_0_postalcode" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_2_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_2_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_3_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_3_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_4_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_5_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_6_countryname" VARCHAR,
  "releases_0_tender_minvalue_amount" DOUBLE,
  "releases_0_tender_minvalue_currency" VARCHAR
);

Contracts Finder OCDS 2025-06-24

@ukgov.contracts_finder_notices_06_2025.contracts_finder_ocds_2025_06_24
  • 805.5 KB
  • 180 rows
  • 681 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2025_06_24 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" VARCHAR,
  "extensions_1" VARCHAR,
  "extensions_2" VARCHAR,
  "extensions_3" VARCHAR,
  "extensions_4" VARCHAR,
  "extensions_5" VARCHAR,
  "extensions_6" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" TIMESTAMP,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_title" VARCHAR,
  "releases_0_planning_milestones_0_id" DOUBLE,
  "releases_0_planning_milestones_0_title" VARCHAR,
  "releases_0_planning_milestones_0_type" VARCHAR,
  "releases_0_planning_milestones_0_duedate" TIMESTAMP,
  "releases_0_planning_documents_0_id" DOUBLE,
  "releases_0_planning_documents_0_documenttype" VARCHAR,
  "releases_0_planning_documents_0_description" VARCHAR,
  "releases_0_planning_documents_0_url" VARCHAR,
  "releases_0_planning_documents_0_datepublished" TIMESTAMP,
  "releases_0_planning_documents_0_format" VARCHAR,
  "releases_0_planning_documents_0_language" VARCHAR,
  "releases_0_planning_documents_1_id" DOUBLE,
  "releases_0_planning_documents_1_description" VARCHAR,
  "releases_0_planning_documents_1_url" VARCHAR,
  "releases_0_planning_documents_2_id" DOUBLE,
  "releases_0_planning_documents_2_description" VARCHAR,
  "releases_0_planning_documents_2_url" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_datepublished" TIMESTAMP,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_classification_scheme" VARCHAR,
  "releases_0_tender_classification_id" BIGINT,
  "releases_0_tender_classification_description" VARCHAR,
  "releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_0_id" DOUBLE,
  "releases_0_tender_additionalclassifications_0_description" VARCHAR,
  "releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_1_id" DOUBLE,
  "releases_0_tender_additionalclassifications_1_description" VARCHAR,
  "releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_2_id" DOUBLE,
  "releases_0_tender_additionalclassifications_2_description" VARCHAR,
  "releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_3_id" DOUBLE,
  "releases_0_tender_additionalclassifications_3_description" VARCHAR,
  "releases_0_tender_additionalclassifications_4_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_4_id" DOUBLE,
  "releases_0_tender_additionalclassifications_4_description" VARCHAR,
  "releases_0_tender_additionalclassifications_5_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_5_id" DOUBLE,
  "releases_0_tender_additionalclassifications_5_description" VARCHAR,
  "releases_0_tender_additionalclassifications_6_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_6_id" DOUBLE,
  "releases_0_tender_additionalclassifications_6_description" VARCHAR,
  "releases_0_tender_additionalclassifications_7_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_7_id" DOUBLE,
  "releases_0_tender_additionalclassifications_7_description" VARCHAR,
  "releases_0_tender_additionalclassifications_8_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_8_id" DOUBLE,
  "releases_0_tender_additionalclassifications_8_description" VARCHAR,
  "releases_0_tender_additionalclassifications_9_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_9_id" DOUBLE,
  "releases_0_tender_additionalclassifications_9_description" VARCHAR,
  "releases_0_tender_additionalclassifications_10_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_10_id" DOUBLE,
  "releases_0_tender_additionalclassifications_10_description" VARCHAR,
  "releases_0_tender_additionalclassifications_11_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_11_id" DOUBLE,
  "releases_0_tender_additionalclassifications_11_description" VARCHAR,
  "releases_0_tender_additionalclassifications_12_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_12_id" DOUBLE,
  "releases_0_tender_additionalclassifications_12_description" VARCHAR,
  "releases_0_tender_additionalclassifications_13_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_13_id" DOUBLE,
  "releases_0_tender_additionalclassifications_13_description" VARCHAR,
  "releases_0_tender_additionalclassifications_14_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_14_id" DOUBLE,
  "releases_0_tender_additionalclassifications_14_description" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_0_postalcode" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_2_region" VARCHAR
);

Contracts Finder OCDS 2025-06-25

@ukgov.contracts_finder_notices_06_2025.contracts_finder_ocds_2025_06_25
  • 1.19 MB
  • 189 rows
  • 1135 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2025_06_25 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" VARCHAR,
  "extensions_1" VARCHAR,
  "extensions_2" VARCHAR,
  "extensions_3" VARCHAR,
  "extensions_4" VARCHAR,
  "extensions_5" VARCHAR,
  "extensions_6" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" TIMESTAMP,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_0_id" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_0_period_startdate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_0_period_enddate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_0_description" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_0_amount_amount" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_0_amount_currency" VARCHAR,
  "releases_0_planning_documents_0_id" DOUBLE,
  "releases_0_planning_documents_0_documenttype" VARCHAR,
  "releases_0_planning_documents_0_description" VARCHAR,
  "releases_0_planning_documents_0_url" VARCHAR,
  "releases_0_planning_documents_0_datepublished" TIMESTAMP,
  "releases_0_planning_documents_0_format" VARCHAR,
  "releases_0_planning_documents_0_language" VARCHAR,
  "releases_0_planning_documents_1_id" DOUBLE,
  "releases_0_planning_documents_1_description" VARCHAR,
  "releases_0_planning_documents_1_url" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_datepublished" TIMESTAMP,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_classification_scheme" VARCHAR,
  "releases_0_tender_classification_id" BIGINT,
  "releases_0_tender_classification_description" VARCHAR,
  "releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_0_id" DOUBLE,
  "releases_0_tender_additionalclassifications_0_description" VARCHAR,
  "releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_1_id" DOUBLE,
  "releases_0_tender_additionalclassifications_1_description" VARCHAR,
  "releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_2_id" DOUBLE,
  "releases_0_tender_additionalclassifications_2_description" VARCHAR,
  "releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_3_id" DOUBLE,
  "releases_0_tender_additionalclassifications_3_description" VARCHAR,
  "releases_0_tender_additionalclassifications_4_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_4_id" DOUBLE,
  "releases_0_tender_additionalclassifications_4_description" VARCHAR,
  "releases_0_tender_additionalclassifications_5_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_5_id" DOUBLE,
  "releases_0_tender_additionalclassifications_5_description" VARCHAR,
  "releases_0_tender_additionalclassifications_6_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_6_id" DOUBLE,
  "releases_0_tender_additionalclassifications_6_description" VARCHAR,
  "releases_0_tender_additionalclassifications_7_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_7_id" DOUBLE,
  "releases_0_tender_additionalclassifications_7_description" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_deliveryaddresses_0_postalcode" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_2_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_2_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_3_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_3_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_4_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_4_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_5_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_5_countryname" VARCHAR,
  "releases_0_tender_minvalue_amount" DOUBLE,
  "releases_0_tender_minvalue_currency" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_6_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_6_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_7_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_7_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_8_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_8_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_9_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_10_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_11_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_12_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_13_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_14_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_15_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_16_countryname" VARCHAR
);

Contracts Finder OCDS 2025-06-26

@ukgov.contracts_finder_notices_06_2025.contracts_finder_ocds_2025_06_26
  • 703.38 KB
  • 185 rows
  • 573 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2025_06_26 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" VARCHAR,
  "extensions_1" VARCHAR,
  "extensions_2" VARCHAR,
  "extensions_3" VARCHAR,
  "extensions_4" VARCHAR,
  "extensions_5" VARCHAR,
  "extensions_6" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" TIMESTAMP,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_title" VARCHAR,
  "releases_0_planning_milestones_0_id" DOUBLE,
  "releases_0_planning_milestones_0_title" VARCHAR,
  "releases_0_planning_milestones_0_type" VARCHAR,
  "releases_0_planning_milestones_0_duedate" TIMESTAMP,
  "releases_0_planning_documents_0_id" DOUBLE,
  "releases_0_planning_documents_0_documenttype" VARCHAR,
  "releases_0_planning_documents_0_description" VARCHAR,
  "releases_0_planning_documents_0_url" VARCHAR,
  "releases_0_planning_documents_0_datepublished" TIMESTAMP,
  "releases_0_planning_documents_0_datemodified" TIMESTAMP,
  "releases_0_planning_documents_0_format" VARCHAR,
  "releases_0_planning_documents_0_language" VARCHAR,
  "releases_0_planning_documents_1_id" DOUBLE,
  "releases_0_planning_documents_1_description" VARCHAR,
  "releases_0_planning_documents_1_url" VARCHAR,
  "releases_0_planning_documents_1_format" VARCHAR,
  "releases_0_planning_documents_2_id" DOUBLE,
  "releases_0_planning_documents_2_description" VARCHAR,
  "releases_0_planning_documents_2_url" VARCHAR,
  "releases_0_planning_documents_2_format" VARCHAR,
  "releases_0_planning_documents_3_id" DOUBLE,
  "releases_0_planning_documents_3_description" VARCHAR,
  "releases_0_planning_documents_3_url" VARCHAR,
  "releases_0_planning_documents_3_format" VARCHAR,
  "releases_0_planning_documents_4_id" DOUBLE,
  "releases_0_planning_documents_4_description" VARCHAR,
  "releases_0_planning_documents_4_url" VARCHAR,
  "releases_0_planning_documents_4_format" VARCHAR,
  "releases_0_planning_documents_5_id" DOUBLE,
  "releases_0_planning_documents_5_description" VARCHAR,
  "releases_0_planning_documents_5_url" VARCHAR,
  "releases_0_planning_documents_5_format" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_datepublished" TIMESTAMP,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_classification_scheme" VARCHAR,
  "releases_0_tender_classification_id" DOUBLE,
  "releases_0_tender_classification_description" VARCHAR,
  "releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_0_id" DOUBLE,
  "releases_0_tender_additionalclassifications_0_description" VARCHAR,
  "releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_1_id" DOUBLE,
  "releases_0_tender_additionalclassifications_1_description" VARCHAR,
  "releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_2_id" DOUBLE,
  "releases_0_tender_additionalclassifications_2_description" VARCHAR,
  "releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_3_id" DOUBLE,
  "releases_0_tender_additionalclassifications_3_description" VARCHAR,
  "releases_0_tender_additionalclassifications_4_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_4_id" DOUBLE,
  "releases_0_tender_additionalclassifications_4_description" VARCHAR,
  "releases_0_tender_additionalclassifications_5_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_5_id" DOUBLE,
  "releases_0_tender_additionalclassifications_5_description" VARCHAR,
  "releases_0_tender_additionalclassifications_6_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_6_id" DOUBLE,
  "releases_0_tender_additionalclassifications_6_description" VARCHAR,
  "releases_0_tender_additionalclassifications_7_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_7_id" DOUBLE,
  "releases_0_tender_additionalclassifications_7_description" VARCHAR,
  "releases_0_tender_additionalclassifications_8_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_8_id" DOUBLE,
  "releases_0_tender_additionalclassifications_8_description" VARCHAR,
  "releases_0_tender_additionalclassifications_9_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_9_id" DOUBLE,
  "releases_0_tender_additionalclassifications_9_description" VARCHAR,
  "releases_0_tender_additionalclassifications_10_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_10_id" DOUBLE,
  "releases_0_tender_additionalclassifications_10_description" VARCHAR,
  "releases_0_tender_additionalclassifications_11_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_11_id" DOUBLE,
  "releases_0_tender_additionalclassifications_11_description" VARCHAR,
  "releases_0_tender_additionalclassifications_12_scheme" VARCHAR
);

Share link

Anyone who has the link will be able to view this.