Contracts Finder Notices 12–2023
Crown Commercial Service
@ukgov.contracts_finder_notices_12_2023
Loading...
Loading...
Loading...
Loading...
About this Dataset
Contracts Finder Notices 12–2023
Tables
Contracts Finder OCDS 2023-12-01
@ukgov.contracts_finder_notices_12_2023.contracts_finder_ocds_2023_12_01
- 2.5 MB
- 360 rows
- 2508 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2023_12_01 (
"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_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_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_documenttype" VARCHAR,
"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_documenttype" VARCHAR,
"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_documenttype" VARCHAR,
"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_documenttype" VARCHAR,
"releases_0_planning_documents_4_description" VARCHAR,
"releases_0_planning_documents_4_url" VARCHAR,
"releases_0_planning_documents_4_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
);
Contracts Finder OCDS 2023-12-02
@ukgov.contracts_finder_notices_12_2023.contracts_finder_ocds_2023_12_02
- 64.24 KB
- 1 row
- 66 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2023_12_02 (
"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_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_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" VARCHAR,
"releases_0_tender_mainprocurementcategory" VARCHAR,
"releases_0_tender_documents_0_id" BIGINT,
"releases_0_tender_documents_0_documenttype" VARCHAR,
"releases_0_tender_documents_0_description" VARCHAR,
"releases_0_tender_documents_0_url" VARCHAR,
"releases_0_tender_documents_0_datepublished" TIMESTAMP,
"releases_0_tender_documents_0_format" VARCHAR,
"releases_0_tender_documents_0_language" VARCHAR,
"releases_0_tender_documents_1_id" BIGINT,
"releases_0_tender_documents_1_documenttype" VARCHAR,
"releases_0_tender_documents_1_description" VARCHAR,
"releases_0_tender_documents_1_url" 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_contactpoint_telephone" BIGINT,
"releases_0_parties_0_roles_0" VARCHAR,
"releases_0_buyer_id" VARCHAR,
"releases_0_buyer_name" VARCHAR
);
Contracts Finder OCDS 2023-12-03
@ukgov.contracts_finder_notices_12_2023.contracts_finder_ocds_2023_12_03
- 141.23 KB
- 4 rows
- 140 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2023_12_03 (
"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_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_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_minvalue_amount" DOUBLE,
"releases_0_tender_minvalue_currency" 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" DOUBLE,
"releases_0_tender_suitability_vcse" DOUBLE,
"releases_0_tender_mainprocurementcategory" VARCHAR,
"releases_0_tender_documents_0_id" DOUBLE,
"releases_0_tender_documents_0_documenttype" VARCHAR,
"releases_0_tender_documents_0_description" VARCHAR,
"releases_0_tender_documents_0_url" VARCHAR,
"releases_0_tender_documents_0_datepublished" TIMESTAMP,
"releases_0_tender_documents_0_datemodified" TIMESTAMP,
"releases_0_tender_documents_0_format" VARCHAR,
"releases_0_tender_documents_0_language" VARCHAR,
"releases_0_tender_documents_1_id" DOUBLE,
"releases_0_tender_documents_1_documenttype" VARCHAR,
"releases_0_tender_documents_1_description" VARCHAR,
"releases_0_tender_documents_1_url" VARCHAR,
"releases_0_parties_0_id" VARCHAR,
"releases_0_parties_0_name" VARCHAR,
"releases_0_parties_0_identifier_legalname" VARCHAR,
"releases_0_parties_0_identifier_scheme" VARCHAR,
"releases_0_parties_0_identifier_id" 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_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" VARCHAR,
"releases_0_parties_1_roles_0" VARCHAR,
"releases_0_parties_2_id" VARCHAR,
"releases_0_parties_2_name" VARCHAR,
"releases_0_parties_2_identifier_legalname" VARCHAR,
"releases_0_parties_2_identifier_scheme" VARCHAR,
"releases_0_parties_2_identifier_id" DOUBLE,
"releases_0_parties_2_address_streetaddress" VARCHAR,
"releases_0_parties_2_details_scale" VARCHAR,
"releases_0_parties_2_details_vcse" VARCHAR,
"releases_0_parties_2_roles_0" VARCHAR,
"releases_0_buyer_id" VARCHAR,
"releases_0_buyer_name" VARCHAR
);
Contracts Finder OCDS 2023-12-04
@ukgov.contracts_finder_notices_12_2023.contracts_finder_ocds_2023_12_04
- 944.63 KB
- 321 rows
- 643 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2023_12_04 (
"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_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_budget_budgetbreakdown_1_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_1_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_1_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_1_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_1_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_1_amount_currency" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_2_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_2_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_2_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_2_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_2_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_2_amount_currency" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_3_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_3_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_3_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_3_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_3_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_3_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_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_documenttype" VARCHAR,
"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_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
);
Contracts Finder OCDS 2023-12-05
@ukgov.contracts_finder_notices_12_2023.contracts_finder_ocds_2023_12_05
- 988.29 KB
- 369 rows
- 674 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2023_12_05 (
"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_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_items_0_id" DOUBLE,
"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,
"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_items_0_deliveryaddresses_6_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_6_countryname" VARCHAR,
"releases_0_tender_minvalue_amount" DOUBLE
);
Contracts Finder OCDS 2023-12-06
@ukgov.contracts_finder_notices_12_2023.contracts_finder_ocds_2023_12_06
- 1.26 MB
- 400 rows
- 957 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2023_12_06 (
"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_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_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_documenttype" VARCHAR,
"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_documenttype" 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_documenttype" 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_documenttype" 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_documenttype" VARCHAR,
"releases_0_planning_documents_5_url" VARCHAR,
"releases_0_planning_documents_5_format" VARCHAR,
"releases_0_planning_documents_6_id" DOUBLE,
"releases_0_planning_documents_6_documenttype" VARCHAR,
"releases_0_planning_documents_6_url" VARCHAR,
"releases_0_planning_documents_6_format" VARCHAR,
"releases_0_planning_documents_7_id" DOUBLE,
"releases_0_planning_documents_7_documenttype" VARCHAR,
"releases_0_planning_documents_7_url" VARCHAR,
"releases_0_planning_documents_7_format" VARCHAR,
"releases_0_planning_documents_8_id" DOUBLE,
"releases_0_planning_documents_8_documenttype" VARCHAR,
"releases_0_planning_documents_8_url" VARCHAR,
"releases_0_planning_documents_8_format" VARCHAR,
"releases_0_planning_documents_9_id" DOUBLE,
"releases_0_planning_documents_9_documenttype" VARCHAR,
"releases_0_planning_documents_9_url" VARCHAR,
"releases_0_planning_documents_9_format" VARCHAR,
"releases_0_planning_documents_10_id" DOUBLE,
"releases_0_planning_documents_10_documenttype" VARCHAR,
"releases_0_planning_documents_10_url" VARCHAR,
"releases_0_planning_documents_10_format" VARCHAR,
"releases_0_planning_documents_11_id" DOUBLE,
"releases_0_planning_documents_11_documenttype" VARCHAR,
"releases_0_planning_documents_11_url" VARCHAR,
"releases_0_planning_documents_11_format" VARCHAR,
"releases_0_planning_documents_12_id" DOUBLE,
"releases_0_planning_documents_12_documenttype" VARCHAR,
"releases_0_planning_documents_12_url" VARCHAR,
"releases_0_planning_documents_12_format" VARCHAR,
"releases_0_planning_documents_13_id" DOUBLE,
"releases_0_planning_documents_13_documenttype" VARCHAR,
"releases_0_planning_documents_13_url" VARCHAR,
"releases_0_planning_documents_13_format" VARCHAR,
"releases_0_planning_documents_14_id" DOUBLE,
"releases_0_planning_documents_14_documenttype" VARCHAR,
"releases_0_planning_documents_14_url" VARCHAR,
"releases_0_planning_documents_14_format" VARCHAR,
"releases_0_planning_documents_15_id" DOUBLE
);
Contracts Finder OCDS 2023-12-07
@ukgov.contracts_finder_notices_12_2023.contracts_finder_ocds_2023_12_07
- 808.13 KB
- 313 rows
- 543 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2023_12_07 (
"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_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_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_documenttype" VARCHAR,
"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_documenttype" VARCHAR,
"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_documenttype" VARCHAR,
"releases_0_planning_documents_3_url" VARCHAR,
"releases_0_planning_documents_3_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
);
Contracts Finder OCDS 2023-12-08
@ukgov.contracts_finder_notices_12_2023.contracts_finder_ocds_2023_12_08
- 1.11 MB
- 352 rows
- 863 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2023_12_08 (
"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" 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_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_budget_budgetbreakdown_1_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_1_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_1_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_1_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_1_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_1_amount_currency" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_2_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_2_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_2_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_2_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_2_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_2_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_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_documenttype" VARCHAR,
"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_documenttype" VARCHAR,
"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_documenttype" VARCHAR,
"releases_0_planning_documents_3_description" VARCHAR,
"releases_0_planning_documents_3_url" VARCHAR,
"releases_0_planning_documents_3_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
);
Contracts Finder OCDS 2023-12-09
@ukgov.contracts_finder_notices_12_2023.contracts_finder_ocds_2023_12_09
- 69.46 KB
- 2 rows
- 69 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2023_12_09 (
"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_items_0_id" BIGINT,
"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_value_amount" DOUBLE,
"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_tender_documents_0_id" BIGINT,
"releases_0_tender_documents_0_documenttype" VARCHAR,
"releases_0_tender_documents_0_description" VARCHAR,
"releases_0_tender_documents_0_url" VARCHAR,
"releases_0_tender_documents_0_datepublished" TIMESTAMP,
"releases_0_tender_documents_0_format" VARCHAR,
"releases_0_tender_documents_0_language" VARCHAR,
"releases_0_tender_documents_1_id" BIGINT,
"releases_0_tender_documents_1_description" VARCHAR,
"releases_0_tender_documents_1_url" VARCHAR,
"releases_0_tender_documents_1_format" 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_buyer_id" VARCHAR,
"releases_0_buyer_name" VARCHAR
);
Contracts Finder OCDS 2023-12-10
@ukgov.contracts_finder_notices_12_2023.contracts_finder_ocds_2023_12_10
- 133.11 KB
- 8 rows
- 135 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2023_12_10 (
"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_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_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_value_amount" DOUBLE,
"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" DOUBLE,
"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_identifier_scheme" VARCHAR,
"releases_0_parties_0_identifier_id" 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_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" VARCHAR,
"releases_0_parties_1_roles_0" VARCHAR,
"releases_0_parties_2_id" VARCHAR,
"releases_0_parties_2_name" VARCHAR,
"releases_0_parties_2_identifier_legalname" VARCHAR,
"releases_0_parties_2_identifier_scheme" VARCHAR,
"releases_0_parties_2_identifier_id" DOUBLE,
"releases_0_parties_2_address_streetaddress" VARCHAR,
"releases_0_parties_2_details_scale" VARCHAR,
"releases_0_parties_2_details_vcse" VARCHAR,
"releases_0_parties_2_roles_0" VARCHAR,
"releases_0_parties_3_id" VARCHAR,
"releases_0_parties_3_name" VARCHAR,
"releases_0_parties_3_identifier_legalname" VARCHAR,
"releases_0_parties_3_identifier_scheme" VARCHAR,
"releases_0_parties_3_identifier_id" DOUBLE,
"releases_0_parties_3_address_streetaddress" VARCHAR,
"releases_0_parties_3_details_scale" VARCHAR,
"releases_0_parties_3_details_vcse" VARCHAR,
"releases_0_parties_3_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" DOUBLE,
"releases_0_awards_0_value_currency" VARCHAR,
"releases_0_awards_0_suppliers_0_id" VARCHAR
);
Contracts Finder OCDS 2023-12-11
@ukgov.contracts_finder_notices_12_2023.contracts_finder_ocds_2023_12_11
- 1.03 MB
- 322 rows
- 751 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2023_12_11 (
"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_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_budget_budgetbreakdown_1_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_1_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_1_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_1_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_1_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_1_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_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_documenttype" VARCHAR,
"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_documenttype" VARCHAR,
"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_documenttype" VARCHAR,
"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_documenttype" VARCHAR,
"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_documenttype" VARCHAR,
"releases_0_planning_documents_5_description" VARCHAR,
"releases_0_planning_documents_5_url" VARCHAR,
"releases_0_planning_documents_5_format" VARCHAR,
"releases_0_planning_documents_6_id" DOUBLE,
"releases_0_planning_documents_6_documenttype" VARCHAR,
"releases_0_planning_documents_6_description" VARCHAR,
"releases_0_planning_documents_6_url" VARCHAR,
"releases_0_planning_documents_6_format" VARCHAR,
"releases_0_planning_documents_7_id" DOUBLE,
"releases_0_planning_documents_7_documenttype" VARCHAR,
"releases_0_planning_documents_7_description" VARCHAR,
"releases_0_planning_documents_7_url" VARCHAR,
"releases_0_planning_documents_7_format" VARCHAR,
"releases_0_planning_documents_8_id" DOUBLE,
"releases_0_planning_documents_8_documenttype" VARCHAR,
"releases_0_planning_documents_8_description" VARCHAR,
"releases_0_planning_documents_8_url" VARCHAR,
"releases_0_planning_documents_8_format" VARCHAR,
"releases_0_planning_documents_9_id" DOUBLE,
"releases_0_planning_documents_9_documenttype" VARCHAR,
"releases_0_planning_documents_9_description" VARCHAR,
"releases_0_planning_documents_9_url" VARCHAR,
"releases_0_planning_documents_9_format" VARCHAR,
"releases_0_planning_documents_10_id" DOUBLE,
"releases_0_planning_documents_10_documenttype" VARCHAR,
"releases_0_planning_documents_10_description" VARCHAR,
"releases_0_planning_documents_10_url" VARCHAR,
"releases_0_planning_documents_10_format" VARCHAR,
"releases_0_planning_documents_11_id" DOUBLE,
"releases_0_planning_documents_11_documenttype" VARCHAR,
"releases_0_planning_documents_11_description" VARCHAR
);
Contracts Finder OCDS 2023-12-12
@ukgov.contracts_finder_notices_12_2023.contracts_finder_ocds_2023_12_12
- 1.31 MB
- 318 rows
- 1129 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2023_12_12 (
"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_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_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_documenttype" VARCHAR,
"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" 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_items_0_id" DOUBLE,
"releases_0_tender_items_0_deliveryaddresses_0_postalcode" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_1_region" 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_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_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,
"releases_0_tender_value_amount" DOUBLE,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_communication_futurenoticedate" TIMESTAMP,
"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" DOUBLE,
"releases_0_tender_mainprocurementcategory" VARCHAR,
"releases_0_tender_documents_0_id" DOUBLE,
"releases_0_tender_documents_0_documenttype" VARCHAR,
"releases_0_tender_documents_0_description" VARCHAR,
"releases_0_tender_documents_0_url" VARCHAR
);
Contracts Finder OCDS 2023-12-13
@ukgov.contracts_finder_notices_12_2023.contracts_finder_ocds_2023_12_13
- 1.68 MB
- 368 rows
- 1432 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2023_12_13 (
"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_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_budget_budgetbreakdown_1_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_1_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_1_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_1_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_1_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_1_amount_currency" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_2_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_2_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_2_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_2_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_2_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_2_amount_currency" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_3_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_3_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_3_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_3_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_3_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_3_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_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_documenttype" 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_3_id" DOUBLE,
"releases_0_planning_documents_3_description" VARCHAR,
"releases_0_planning_documents_3_url" VARCHAR,
"releases_0_planning_documents_2_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
);
Contracts Finder OCDS 2023-12-14
@ukgov.contracts_finder_notices_12_2023.contracts_finder_ocds_2023_12_14
- 1.36 MB
- 361 rows
- 1162 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2023_12_14 (
"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_budget_budgetbreakdown_1_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_1_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_1_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_1_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_1_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_1_amount_currency" 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_documenttype" VARCHAR,
"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_documenttype" VARCHAR,
"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_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
);
Contracts Finder OCDS 2023-12-15
@ukgov.contracts_finder_notices_12_2023.contracts_finder_ocds_2023_12_15
- 2.08 MB
- 348 rows
- 2009 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2023_12_15 (
"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_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_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_documenttype" VARCHAR,
"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_documenttype" VARCHAR,
"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_documenttype" 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_documenttype" 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_documenttype" 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
);
Contracts Finder OCDS 2023-12-16
@ukgov.contracts_finder_notices_12_2023.contracts_finder_ocds_2023_12_16
- 334.46 KB
- 6 rows
- 371 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2023_12_16 (
"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_additionalclassifications_1_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_1_id" DOUBLE,
"releases_0_tender_additionalclassifications_1_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_value_amount" DOUBLE,
"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" DOUBLE,
"releases_0_tender_suitability_vcse" VARCHAR,
"releases_0_tender_mainprocurementcategory" VARCHAR,
"releases_0_tender_documents_0_id" DOUBLE,
"releases_0_tender_documents_0_documenttype" VARCHAR,
"releases_0_tender_documents_0_description" VARCHAR,
"releases_0_tender_documents_0_url" VARCHAR,
"releases_0_tender_documents_0_datepublished" TIMESTAMP,
"releases_0_tender_documents_0_datemodified" TIMESTAMP,
"releases_0_tender_documents_0_format" VARCHAR,
"releases_0_tender_documents_0_language" VARCHAR,
"releases_0_tender_documents_1_id" DOUBLE,
"releases_0_tender_documents_1_documenttype" VARCHAR,
"releases_0_tender_documents_1_description" VARCHAR,
"releases_0_tender_documents_1_url" VARCHAR,
"releases_0_tender_documents_1_format" VARCHAR,
"releases_0_parties_0_id" VARCHAR,
"releases_0_parties_0_name" VARCHAR,
"releases_0_parties_0_identifier_legalname" VARCHAR,
"releases_0_parties_0_identifier_scheme" VARCHAR,
"releases_0_parties_0_identifier_id" 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_identifier_scheme" VARCHAR,
"releases_0_parties_1_identifier_id" VARCHAR,
"releases_0_parties_1_address_streetaddress" VARCHAR,
"releases_0_parties_1_details_scale" VARCHAR,
"releases_0_parties_1_details_vcse" VARCHAR,
"releases_0_parties_1_roles_0" VARCHAR,
"releases_0_parties_2_id" VARCHAR,
"releases_0_parties_2_name" VARCHAR,
"releases_0_parties_2_identifier_legalname" VARCHAR,
"releases_0_parties_2_identifier_scheme" VARCHAR,
"releases_0_parties_2_identifier_id" DOUBLE,
"releases_0_parties_2_address_streetaddress" VARCHAR,
"releases_0_parties_2_details_scale" VARCHAR,
"releases_0_parties_2_details_vcse" VARCHAR,
"releases_0_parties_2_roles_0" VARCHAR,
"releases_0_parties_3_id" VARCHAR,
"releases_0_parties_3_name" VARCHAR,
"releases_0_parties_3_identifier_legalname" VARCHAR,
"releases_0_parties_3_identifier_scheme" VARCHAR,
"releases_0_parties_3_identifier_id" DOUBLE
);
Contracts Finder OCDS 2023-12-17
@ukgov.contracts_finder_notices_12_2023.contracts_finder_ocds_2023_12_17
- 104.2 KB
- 3 rows
- 102 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2023_12_17 (
"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_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_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_value_amount" DOUBLE,
"releases_0_tender_value_currency" 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_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_tender_documents_0_id" DOUBLE,
"releases_0_tender_documents_0_documenttype" VARCHAR,
"releases_0_tender_documents_0_description" VARCHAR,
"releases_0_tender_documents_0_url" VARCHAR,
"releases_0_tender_documents_0_datepublished" TIMESTAMP,
"releases_0_tender_documents_0_datemodified" TIMESTAMP,
"releases_0_tender_documents_0_format" VARCHAR,
"releases_0_tender_documents_0_language" VARCHAR,
"releases_0_tender_documents_1_id" DOUBLE,
"releases_0_tender_documents_1_description" VARCHAR,
"releases_0_tender_documents_1_url" 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" DOUBLE,
"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" DOUBLE,
"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
);
Contracts Finder OCDS 2023-12-18
@ukgov.contracts_finder_notices_12_2023.contracts_finder_ocds_2023_12_18
- 1.08 MB
- 397 rows
- 777 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2023_12_18 (
"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_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_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_documenttype" VARCHAR,
"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_documenttype" VARCHAR,
"releases_0_planning_documents_2_url" VARCHAR,
"releases_0_planning_documents_2_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,
"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
);
Contracts Finder OCDS 2023-12-19
@ukgov.contracts_finder_notices_12_2023.contracts_finder_ocds_2023_12_19
- 1.51 MB
- 442 rows
- 1206 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2023_12_19 (
"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_documenttype" VARCHAR,
"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_documenttype" VARCHAR,
"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_documenttype" VARCHAR,
"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_documenttype" VARCHAR,
"releases_0_planning_documents_4_url" VARCHAR,
"releases_0_planning_documents_4_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,
"releases_0_tender_additionalclassifications_12_id" DOUBLE
);
Contracts Finder OCDS 2023-12-20
@ukgov.contracts_finder_notices_12_2023.contracts_finder_ocds_2023_12_20
- 1.27 MB
- 536 rows
- 880 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2023_12_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_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_budget_budgetbreakdown_1_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_1_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_1_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_1_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_1_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_1_amount_currency" 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_budget_budgetbreakdown_2_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_2_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_2_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_2_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_2_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_2_amount_currency" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_3_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_3_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_3_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_3_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_3_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_3_amount_currency" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_4_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_4_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_4_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_4_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_4_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_4_amount_currency" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_5_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_5_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_5_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_5_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_5_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_5_amount_currency" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_6_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_6_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_6_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_6_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_6_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_6_amount_currency" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_7_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_7_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_7_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_7_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_7_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_7_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_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_documenttype" VARCHAR,
"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_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
);
Contracts Finder OCDS 2023-12-21
@ukgov.contracts_finder_notices_12_2023.contracts_finder_ocds_2023_12_21
- 1.35 MB
- 456 rows
- 1009 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2023_12_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_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_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_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_documenttype" VARCHAR,
"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_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_additionalclassifications_14_scheme" VARCHAR
);
Contracts Finder OCDS 2023-12-22
@ukgov.contracts_finder_notices_12_2023.contracts_finder_ocds_2023_12_22
- 1.04 MB
- 276 rows
- 841 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2023_12_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_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_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_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_documenttype" VARCHAR,
"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" 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_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_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_4_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_5_region" VARCHAR
);
Contracts Finder OCDS 2023-12-23
@ukgov.contracts_finder_notices_12_2023.contracts_finder_ocds_2023_12_23
- 94.57 KB
- 3 rows
- 97 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2023_12_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_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_items_0_id" BIGINT,
"releases_0_tender_items_0_deliveryaddresses_0_postalcode" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_0_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_tender_documents_0_id" DOUBLE,
"releases_0_tender_documents_0_documenttype" VARCHAR,
"releases_0_tender_documents_0_description" VARCHAR,
"releases_0_tender_documents_0_url" VARCHAR,
"releases_0_tender_documents_0_datepublished" TIMESTAMP,
"releases_0_tender_documents_0_datemodified" TIMESTAMP,
"releases_0_tender_documents_0_format" VARCHAR,
"releases_0_tender_documents_0_language" VARCHAR,
"releases_0_parties_0_id" VARCHAR,
"releases_0_parties_0_name" VARCHAR,
"releases_0_parties_0_identifier_legalname" VARCHAR,
"releases_0_parties_0_identifier_scheme" VARCHAR,
"releases_0_parties_0_identifier_id" 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" DOUBLE,
"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_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" 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" DOUBLE,
"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" DOUBLE,
"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,
"releases_0_awards_0_documents_1_id" DOUBLE,
"releases_0_awards_0_documents_1_documenttype" VARCHAR,
"releases_0_awards_0_documents_1_url" VARCHAR,
"releases_0_awards_0_documents_1_format" VARCHAR
);
Contracts Finder OCDS 2023-12-24
@ukgov.contracts_finder_notices_12_2023.contracts_finder_ocds_2023_12_24
- 73.62 KB
- 1 row
- 68 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2023_12_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_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_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_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" BIGINT,
"releases_0_tender_mainprocurementcategory" VARCHAR,
"releases_0_tender_documents_0_id" BIGINT,
"releases_0_tender_documents_0_documenttype" VARCHAR,
"releases_0_tender_documents_0_description" VARCHAR,
"releases_0_tender_documents_0_url" VARCHAR,
"releases_0_tender_documents_0_datepublished" TIMESTAMP,
"releases_0_tender_documents_0_datemodified" TIMESTAMP,
"releases_0_tender_documents_0_format" VARCHAR,
"releases_0_tender_documents_0_language" VARCHAR,
"releases_0_tender_documents_1_id" BIGINT,
"releases_0_tender_documents_1_documenttype" VARCHAR,
"releases_0_tender_documents_1_description" VARCHAR,
"releases_0_tender_documents_1_url" 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_roles_0" VARCHAR,
"releases_0_buyer_id" VARCHAR,
"releases_0_buyer_name" VARCHAR
);
Contracts Finder OCDS 2023-12-27
@ukgov.contracts_finder_notices_12_2023.contracts_finder_ocds_2023_12_27
- 651.91 KB
- 116 rows
- 574 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2023_12_27 (
"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_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_documenttype" VARCHAR,
"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_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
);