Contracts Finder Notices 12–2024
Crown Commercial Service
@ukgov.contracts_finder_notices_12_2024
Loading...
Loading...
Loading...
Loading...
About this Dataset
Contracts Finder Notices 12–2024
Tables
Contracts Finder OCDS 2024-12-01
@ukgov.contracts_finder_notices_12_2024.contracts_finder_ocds_2024_12_01
- 108.39 KB
- 10 rows
- 106 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2024_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_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_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_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" 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_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_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_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_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
);
Contracts Finder OCDS 2024-12-02
@ukgov.contracts_finder_notices_12_2024.contracts_finder_ocds_2024_12_02
- 1.16 MB
- 359 rows
- 914 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2024_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_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_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_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_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
);
Contracts Finder OCDS 2024-12-03
@ukgov.contracts_finder_notices_12_2024.contracts_finder_ocds_2024_12_03
- 743.25 KB
- 292 rows
- 483 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2024_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_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_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_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_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_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_4_id" DOUBLE,
"releases_0_planning_documents_4_documenttype" VARCHAR,
"releases_0_planning_documents_4_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
);
Contracts Finder OCDS 2024-12-04
@ukgov.contracts_finder_notices_12_2024.contracts_finder_ocds_2024_12_04
- 1.63 MB
- 399 rows
- 1413 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2024_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_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_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_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_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_5_id" DOUBLE,
"releases_0_planning_documents_5_documenttype" VARCHAR,
"releases_0_planning_documents_5_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 2024-12-05
@ukgov.contracts_finder_notices_12_2024.contracts_finder_ocds_2024_12_05
- 2.9 MB
- 333 rows
- 2947 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2024_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_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,
"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 2024-12-06
@ukgov.contracts_finder_notices_12_2024.contracts_finder_ocds_2024_12_06
- 925.48 KB
- 347 rows
- 661 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2024_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_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_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_4_id" DOUBLE,
"releases_0_planning_documents_4_description" VARCHAR,
"releases_0_planning_documents_4_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
);
Contracts Finder OCDS 2024-12-07
@ukgov.contracts_finder_notices_12_2024.contracts_finder_ocds_2024_12_07
- 108.71 KB
- 3 rows
- 108 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2024_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_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_datepublished" TIMESTAMP,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_classification_scheme" VARCHAR,
"releases_0_tender_classification_id" BIGINT,
"releases_0_tender_classification_description" VARCHAR,
"releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_0_id" DOUBLE,
"releases_0_tender_additionalclassifications_0_description" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_deliveryaddresses_0_postalcode" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_1_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_1_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_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" 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_tender_documents_2_id" DOUBLE,
"releases_0_tender_documents_2_documenttype" VARCHAR,
"releases_0_tender_documents_2_description" VARCHAR,
"releases_0_tender_documents_2_url" VARCHAR,
"releases_0_tender_documents_2_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" DOUBLE,
"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
);
Contracts Finder OCDS 2024-12-08
@ukgov.contracts_finder_notices_12_2024.contracts_finder_ocds_2024_12_08
- 99.82 KB
- 3 rows
- 102 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2024_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_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_minvalue_amount" DOUBLE,
"releases_0_tender_minvalue_currency" 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_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_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_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_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_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_description" VARCHAR
);
Contracts Finder OCDS 2024-12-09
@ukgov.contracts_finder_notices_12_2024.contracts_finder_ocds_2024_12_09
- 1.1 MB
- 300 rows
- 891 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2024_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_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_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_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_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_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_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
);
Contracts Finder OCDS 2024-12-10
@ukgov.contracts_finder_notices_12_2024.contracts_finder_ocds_2024_12_10
- 1.11 MB
- 300 rows
- 909 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2024_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_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_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_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_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
);
Contracts Finder OCDS 2024-12-11
@ukgov.contracts_finder_notices_12_2024.contracts_finder_ocds_2024_12_11
- 1.77 MB
- 424 rows
- 1584 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2024_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_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_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_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
);
Contracts Finder OCDS 2024-12-12
@ukgov.contracts_finder_notices_12_2024.contracts_finder_ocds_2024_12_12
- 917.31 KB
- 355 rows
- 622 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2024_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_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_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_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
);
Contracts Finder OCDS 2024-12-13
@ukgov.contracts_finder_notices_12_2024.contracts_finder_ocds_2024_12_13
- 812.67 KB
- 314 rows
- 567 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2024_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_documents_0_id" DOUBLE,
"releases_0_planning_documents_0_documenttype" VARCHAR,
"releases_0_planning_documents_0_description" VARCHAR,
"releases_0_planning_documents_0_url" VARCHAR,
"releases_0_planning_documents_0_datepublished" TIMESTAMP,
"releases_0_planning_documents_0_format" VARCHAR,
"releases_0_planning_documents_0_language" VARCHAR,
"releases_0_planning_documents_1_id" DOUBLE,
"releases_0_planning_documents_1_description" VARCHAR,
"releases_0_planning_documents_1_url" VARCHAR,
"releases_0_planning_documents_1_format" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_datepublished" TIMESTAMP,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_classification_scheme" VARCHAR,
"releases_0_tender_classification_id" 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,
"releases_0_tender_additionalclassifications_14_id" DOUBLE,
"releases_0_tender_additionalclassifications_14_description" VARCHAR,
"releases_0_tender_additionalclassifications_15_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_15_id" DOUBLE,
"releases_0_tender_additionalclassifications_15_description" VARCHAR,
"releases_0_tender_additionalclassifications_16_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_16_id" DOUBLE,
"releases_0_tender_additionalclassifications_16_description" VARCHAR,
"releases_0_tender_additionalclassifications_17_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_17_id" DOUBLE,
"releases_0_tender_additionalclassifications_17_description" VARCHAR
);
Contracts Finder OCDS 2024-12-14
@ukgov.contracts_finder_notices_12_2024.contracts_finder_ocds_2024_12_14
- 61.75 KB
- 2 rows
- 67 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2024_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" 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" DOUBLE,
"releases_0_tender_classification_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_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_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_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" VARCHAR,
"releases_0_parties_0_roles_0" VARCHAR,
"releases_0_buyer_id" VARCHAR,
"releases_0_buyer_name" VARCHAR
);
Contracts Finder OCDS 2024-12-15
@ukgov.contracts_finder_notices_12_2024.contracts_finder_ocds_2024_12_15
- 89.25 KB
- 2 rows
- 93 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2024_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_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_additionalclassifications_0_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_0_id" DOUBLE,
"releases_0_tender_additionalclassifications_0_description" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_deliveryaddresses_0_postalcode" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_2_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_3_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_4_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_5_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_6_countryname" VARCHAR,
"releases_0_tender_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" DOUBLE,
"releases_0_tender_mainprocurementcategory" VARCHAR,
"releases_0_parties_0_id" VARCHAR,
"releases_0_parties_0_name" VARCHAR,
"releases_0_parties_0_identifier_legalname" VARCHAR,
"releases_0_parties_0_address_streetaddress" VARCHAR,
"releases_0_parties_0_address_locality" VARCHAR,
"releases_0_parties_0_address_postalcode" VARCHAR,
"releases_0_parties_0_address_countryname" VARCHAR,
"releases_0_parties_0_contactpoint_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_buyer_id" VARCHAR,
"releases_0_buyer_name" VARCHAR,
"releases_0_awards_0_id" VARCHAR,
"releases_0_awards_0_status" VARCHAR,
"releases_0_awards_0_date" TIMESTAMP,
"releases_0_awards_0_datepublished" TIMESTAMP,
"releases_0_awards_0_value_amount" BIGINT,
"releases_0_awards_0_value_currency" VARCHAR,
"releases_0_awards_0_suppliers_0_id" VARCHAR,
"releases_0_awards_0_suppliers_0_name" VARCHAR,
"releases_0_awards_0_contractperiod_startdate" TIMESTAMP,
"releases_0_awards_0_contractperiod_enddate" TIMESTAMP,
"releases_0_awards_0_description" VARCHAR,
"releases_0_awards_0_documents_0_id" BIGINT,
"releases_0_awards_0_documents_0_documenttype" VARCHAR,
"releases_0_awards_0_documents_0_description" VARCHAR,
"releases_0_awards_0_documents_0_url" VARCHAR,
"releases_0_awards_0_documents_0_datepublished" TIMESTAMP,
"releases_0_awards_0_documents_0_format" VARCHAR,
"releases_0_awards_0_documents_0_language" VARCHAR
);
Contracts Finder OCDS 2024-12-16
@ukgov.contracts_finder_notices_12_2024.contracts_finder_ocds_2024_12_16
- 1.49 MB
- 391 rows
- 1260 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2024_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_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_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_budget_budgetbreakdown_8_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_8_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_8_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_8_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_8_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_8_amount_currency" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_9_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_9_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_9_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_9_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_9_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_9_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
);
Contracts Finder OCDS 2024-12-17
@ukgov.contracts_finder_notices_12_2024.contracts_finder_ocds_2024_12_17
- 1.18 MB
- 376 rows
- 873 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2024_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_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_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_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
);
Contracts Finder OCDS 2024-12-18
@ukgov.contracts_finder_notices_12_2024.contracts_finder_ocds_2024_12_18
- 1.15 MB
- 437 rows
- 837 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2024_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_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_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
);
Contracts Finder OCDS 2024-12-19
@ukgov.contracts_finder_notices_12_2024.contracts_finder_ocds_2024_12_19
- 2.5 MB
- 443 rows
- 2368 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2024_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_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,
"releases_0_tender_additionalclassifications_14_id" DOUBLE,
"releases_0_tender_additionalclassifications_14_description" VARCHAR,
"releases_0_tender_additionalclassifications_15_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_15_id" DOUBLE,
"releases_0_tender_additionalclassifications_15_description" VARCHAR,
"releases_0_tender_additionalclassifications_16_scheme" VARCHAR
);
Contracts Finder OCDS 2024-12-20
@ukgov.contracts_finder_notices_12_2024.contracts_finder_ocds_2024_12_20
- 1.07 MB
- 472 rows
- 691 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2024_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_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_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_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
);
Contracts Finder OCDS 2024-12-21
@ukgov.contracts_finder_notices_12_2024.contracts_finder_ocds_2024_12_21
- 93.79 KB
- 3 rows
- 91 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2024_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_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" 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_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_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
);
Contracts Finder OCDS 2024-12-22
@ukgov.contracts_finder_notices_12_2024.contracts_finder_ocds_2024_12_22
- 112.32 KB
- 5 rows
- 114 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2024_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_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_items_0_deliveryaddresses_0_postalcode" 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_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_tender_documents_2_id" DOUBLE,
"releases_0_tender_documents_2_documenttype" VARCHAR,
"releases_0_tender_documents_2_description" VARCHAR,
"releases_0_tender_documents_2_url" VARCHAR,
"releases_0_tender_documents_2_format" VARCHAR,
"releases_0_tender_documents_3_id" DOUBLE,
"releases_0_tender_documents_3_documenttype" VARCHAR,
"releases_0_tender_documents_3_description" VARCHAR,
"releases_0_tender_documents_3_url" VARCHAR,
"releases_0_tender_documents_3_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" 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
);
Contracts Finder OCDS 2024-12-23
@ukgov.contracts_finder_notices_12_2024.contracts_finder_ocds_2024_12_23
- 1.04 MB
- 339 rows
- 832 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2024_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_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_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_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_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,
"releases_0_tender_minvalue_currency" VARCHAR
);
Contracts Finder OCDS 2024-12-24
@ukgov.contracts_finder_notices_12_2024.contracts_finder_ocds_2024_12_24
- 795.1 KB
- 204 rows
- 652 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2024_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_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_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_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_minvalue_amount" DOUBLE,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_7_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_8_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_9_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_10_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_11_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_12_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_13_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_14_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_15_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_16_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_17_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_18_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_19_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_20_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_21_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_22_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_23_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_24_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_25_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_26_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_27_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_28_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_29_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_30_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_31_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_32_countryname" VARCHAR
);
Contracts Finder OCDS 2024-12-25
@ukgov.contracts_finder_notices_12_2024.contracts_finder_ocds_2024_12_25
- 104.27 KB
- 3 rows
- 108 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2024_12_25 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"extensions_1" VARCHAR,
"extensions_2" VARCHAR,
"extensions_3" VARCHAR,
"extensions_4" VARCHAR,
"extensions_5" VARCHAR,
"extensions_6" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_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" BIGINT,
"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_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_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_2_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_3_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_4_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_5_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_6_countryname" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_contractperiod_startdate" TIMESTAMP,
"releases_0_tender_contractperiod_enddate" TIMESTAMP,
"releases_0_tender_suitability_sme" 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_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_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_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_description" VARCHAR,
"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
);