Contracts Finder Notices 10–2019
Crown Commercial Service
@ukgov.contracts_finder_notices_10_20192_1
Loading...
Loading...
Loading...
Loading...
About this Dataset
Contracts Finder Notices 10–2019
Tables
Contracts Finder OCDS 2019-10-01
@ukgov.contracts_finder_notices_10_20192_1.contracts_finder_ocds_2019_10_01
- 1018.09 KB
- 202 rows
- 875 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_10_01 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"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" VARCHAR,
"releases_0_planning_documents_0_format" VARCHAR,
"releases_0_planning_documents_0_language" VARCHAR,
"releases_0_planning_documents_1_id" VARCHAR,
"releases_0_planning_documents_1_documenttype" VARCHAR,
"releases_0_planning_documents_1_description" VARCHAR,
"releases_0_planning_documents_1_url" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_datepublished" VARCHAR,
"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_items_0_deliveryaddresses_7_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_7_countryname" VARCHAR
);
Contracts Finder OCDS 2019-10-02
@ukgov.contracts_finder_notices_10_20192_1.contracts_finder_ocds_2019_10_02
- 817.75 KB
- 200 rows
- 714 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_10_02 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"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" VARCHAR,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_planning_milestones_0_id" VARCHAR,
"releases_0_planning_milestones_0_title" VARCHAR,
"releases_0_planning_milestones_0_type" VARCHAR,
"releases_0_planning_milestones_0_duedate" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_0_id" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_0_period_startdate" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_0_period_enddate" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_0_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_0_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_0_amount_currency" VARCHAR,
"releases_0_planning_documents_0_id" DOUBLE,
"releases_0_planning_documents_0_documenttype" VARCHAR,
"releases_0_planning_documents_0_description" VARCHAR,
"releases_0_planning_documents_0_url" VARCHAR,
"releases_0_planning_documents_0_datepublished" TIMESTAMP,
"releases_0_planning_documents_0_format" VARCHAR,
"releases_0_planning_documents_0_language" VARCHAR,
"releases_0_planning_documents_1_id" DOUBLE,
"releases_0_planning_documents_1_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_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" VARCHAR,
"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" VARCHAR,
"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" VARCHAR,
"releases_0_tender_additionalclassifications_9_description" VARCHAR,
"releases_0_tender_additionalclassifications_10_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_10_id" VARCHAR,
"releases_0_tender_additionalclassifications_10_description" VARCHAR,
"releases_0_tender_additionalclassifications_11_scheme" VARCHAR
);
Contracts Finder OCDS 2019-10-03
@ukgov.contracts_finder_notices_10_20192_1.contracts_finder_ocds_2019_10_03
- 561.41 KB
- 208 rows
- 389 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_10_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_planning_budget_budgetbreakdown_0_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_0_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_0_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_0_amount_currency" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_1_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_1_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_1_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_1_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_1_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_1_amount_currency" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_planning_milestones_0_id" DOUBLE,
"releases_0_planning_milestones_0_title" VARCHAR,
"releases_0_planning_milestones_0_type" VARCHAR,
"releases_0_planning_milestones_0_duedate" TIMESTAMP,
"releases_0_planning_documents_0_id" DOUBLE,
"releases_0_planning_documents_0_documenttype" VARCHAR,
"releases_0_planning_documents_0_description" VARCHAR,
"releases_0_planning_documents_0_url" VARCHAR,
"releases_0_planning_documents_0_datepublished" TIMESTAMP,
"releases_0_planning_documents_0_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_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_datepublished" TIMESTAMP,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_classification_scheme" VARCHAR,
"releases_0_tender_classification_id" BIGINT,
"releases_0_tender_classification_description" VARCHAR,
"releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_0_id" DOUBLE,
"releases_0_tender_additionalclassifications_0_description" VARCHAR,
"releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_1_id" DOUBLE,
"releases_0_tender_additionalclassifications_1_description" VARCHAR,
"releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_2_id" DOUBLE,
"releases_0_tender_additionalclassifications_2_description" VARCHAR,
"releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_3_id" DOUBLE,
"releases_0_tender_additionalclassifications_3_description" VARCHAR,
"releases_0_tender_additionalclassifications_4_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_4_id" DOUBLE,
"releases_0_tender_additionalclassifications_4_description" VARCHAR,
"releases_0_tender_additionalclassifications_5_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_5_id" DOUBLE,
"releases_0_tender_additionalclassifications_5_description" VARCHAR,
"releases_0_tender_additionalclassifications_6_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_6_id" DOUBLE,
"releases_0_tender_additionalclassifications_6_description" VARCHAR,
"releases_0_tender_additionalclassifications_7_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_7_id" DOUBLE,
"releases_0_tender_additionalclassifications_7_description" VARCHAR,
"releases_0_tender_additionalclassifications_8_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_8_id" DOUBLE,
"releases_0_tender_additionalclassifications_8_description" VARCHAR,
"releases_0_tender_additionalclassifications_9_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_9_id" DOUBLE,
"releases_0_tender_additionalclassifications_9_description" VARCHAR,
"releases_0_tender_additionalclassifications_10_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_10_id" DOUBLE,
"releases_0_tender_additionalclassifications_10_description" VARCHAR,
"releases_0_tender_additionalclassifications_11_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_11_id" DOUBLE,
"releases_0_tender_additionalclassifications_11_description" VARCHAR
);
Contracts Finder OCDS 2019-10-04
@ukgov.contracts_finder_notices_10_20192_1.contracts_finder_ocds_2019_10_04
- 713.25 KB
- 228 rows
- 555 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_10_04 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"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" VARCHAR,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_planning_milestones_0_id" VARCHAR,
"releases_0_planning_milestones_0_title" VARCHAR,
"releases_0_planning_milestones_0_type" VARCHAR,
"releases_0_planning_milestones_0_duedate" VARCHAR,
"releases_0_planning_documents_0_id" VARCHAR,
"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" VARCHAR,
"releases_0_planning_documents_0_datemodified" VARCHAR,
"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_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_suitability_sme" DOUBLE,
"releases_0_tender_suitability_vcse" DOUBLE,
"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_roles_0" VARCHAR,
"releases_0_buyer_id" VARCHAR,
"releases_0_buyer_name" VARCHAR,
"releases_0_tender_datepublished" VARCHAR,
"releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_0_id" VARCHAR,
"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" VARCHAR,
"releases_0_tender_additionalclassifications_3_description" VARCHAR,
"releases_0_tender_additionalclassifications_4_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_4_id" VARCHAR,
"releases_0_tender_additionalclassifications_4_description" VARCHAR,
"releases_0_tender_additionalclassifications_5_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_5_id" VARCHAR,
"releases_0_tender_additionalclassifications_5_description" VARCHAR,
"releases_0_tender_additionalclassifications_6_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_6_id" VARCHAR,
"releases_0_tender_additionalclassifications_6_description" VARCHAR,
"releases_0_tender_additionalclassifications_7_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_7_id" VARCHAR,
"releases_0_tender_additionalclassifications_7_description" VARCHAR,
"releases_0_tender_additionalclassifications_8_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_8_id" DOUBLE,
"releases_0_tender_additionalclassifications_8_description" VARCHAR,
"releases_0_tender_additionalclassifications_9_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_9_id" DOUBLE
);
Contracts Finder OCDS 2019-10-05
@ukgov.contracts_finder_notices_10_20192_1.contracts_finder_ocds_2019_10_05
- 228.23 KB
- 6 rows
- 239 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_10_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_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_items_0_id" BIGINT,
"releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_1_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" 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" BIGINT,
"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_parties_2_id" VARCHAR,
"releases_0_parties_2_name" VARCHAR,
"releases_0_parties_2_identifier_legalname" VARCHAR,
"releases_0_parties_2_address_streetaddress" VARCHAR,
"releases_0_parties_2_details_scale" VARCHAR,
"releases_0_parties_2_details_vcse" VARCHAR,
"releases_0_parties_2_roles_0" VARCHAR,
"releases_0_parties_3_id" VARCHAR,
"releases_0_parties_3_name" VARCHAR,
"releases_0_parties_3_identifier_legalname" VARCHAR
);
Contracts Finder OCDS 2019-10-06
@ukgov.contracts_finder_notices_10_20192_1.contracts_finder_ocds_2019_10_06
- 155.49 KB
- 11 rows
- 149 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_10_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_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_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_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_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" DOUBLE,
"releases_0_parties_1_address_streetaddress" VARCHAR,
"releases_0_parties_1_details_scale" VARCHAR
);
Contracts Finder OCDS 2019-10-07
@ukgov.contracts_finder_notices_10_20192_1.contracts_finder_ocds_2019_10_07
- 574.81 KB
- 169 rows
- 445 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_10_07 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"extensions_1" VARCHAR,
"extensions_2" VARCHAR,
"extensions_3" VARCHAR,
"extensions_4" VARCHAR,
"extensions_5" VARCHAR,
"extensions_6" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_planning_milestones_0_id" DOUBLE,
"releases_0_planning_milestones_0_title" VARCHAR,
"releases_0_planning_milestones_0_type" VARCHAR,
"releases_0_planning_milestones_0_duedate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_0_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_0_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_0_amount_currency" VARCHAR,
"releases_0_planning_documents_0_id" DOUBLE,
"releases_0_planning_documents_0_documenttype" VARCHAR,
"releases_0_planning_documents_0_description" VARCHAR,
"releases_0_planning_documents_0_url" VARCHAR,
"releases_0_planning_documents_0_datepublished" TIMESTAMP,
"releases_0_planning_documents_0_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_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_datepublished" VARCHAR,
"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" VARCHAR,
"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" VARCHAR,
"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" VARCHAR,
"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
);
Contracts Finder OCDS 2019-10-08
@ukgov.contracts_finder_notices_10_20192_1.contracts_finder_ocds_2019_10_08
- 723.79 KB
- 238 rows
- 609 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_10_08 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"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" VARCHAR,
"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" VARCHAR,
"releases_0_planning_documents_0_format" VARCHAR,
"releases_0_planning_documents_0_language" VARCHAR,
"releases_0_planning_documents_1_id" VARCHAR,
"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" VARCHAR,
"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" VARCHAR,
"releases_0_tender_additionalclassifications_0_description" VARCHAR,
"releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_1_id" VARCHAR,
"releases_0_tender_additionalclassifications_1_description" VARCHAR,
"releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_2_id" VARCHAR,
"releases_0_tender_additionalclassifications_2_description" VARCHAR,
"releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_3_id" VARCHAR,
"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" VARCHAR,
"releases_0_tender_additionalclassifications_6_description" VARCHAR,
"releases_0_tender_additionalclassifications_7_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_7_id" DOUBLE,
"releases_0_tender_additionalclassifications_7_description" VARCHAR,
"releases_0_tender_items_0_id" 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_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_2_region" 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
);
Contracts Finder OCDS 2019-10-09
@ukgov.contracts_finder_notices_10_20192_1.contracts_finder_ocds_2019_10_09
- 558.39 KB
- 181 rows
- 415 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_10_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_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" BIGINT,
"releases_0_tender_classification_description" VARCHAR,
"releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_0_id" DOUBLE,
"releases_0_tender_additionalclassifications_0_description" VARCHAR,
"releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_1_id" DOUBLE,
"releases_0_tender_additionalclassifications_1_description" VARCHAR,
"releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_2_id" DOUBLE,
"releases_0_tender_additionalclassifications_2_description" VARCHAR,
"releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_3_id" DOUBLE,
"releases_0_tender_additionalclassifications_3_description" VARCHAR,
"releases_0_tender_additionalclassifications_4_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_4_id" DOUBLE,
"releases_0_tender_additionalclassifications_4_description" VARCHAR,
"releases_0_tender_additionalclassifications_5_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_5_id" DOUBLE,
"releases_0_tender_additionalclassifications_5_description" VARCHAR,
"releases_0_tender_additionalclassifications_6_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_6_id" DOUBLE,
"releases_0_tender_additionalclassifications_6_description" VARCHAR,
"releases_0_tender_additionalclassifications_7_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_7_id" DOUBLE,
"releases_0_tender_additionalclassifications_7_description" VARCHAR,
"releases_0_tender_additionalclassifications_8_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_8_id" DOUBLE,
"releases_0_tender_additionalclassifications_8_description" VARCHAR,
"releases_0_tender_additionalclassifications_9_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_9_id" DOUBLE,
"releases_0_tender_additionalclassifications_9_description" VARCHAR,
"releases_0_tender_additionalclassifications_10_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_10_id" DOUBLE,
"releases_0_tender_additionalclassifications_10_description" VARCHAR,
"releases_0_tender_additionalclassifications_11_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_11_id" DOUBLE,
"releases_0_tender_additionalclassifications_11_description" VARCHAR,
"releases_0_tender_additionalclassifications_12_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_12_id" DOUBLE,
"releases_0_tender_additionalclassifications_12_description" VARCHAR,
"releases_0_tender_additionalclassifications_13_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_13_id" DOUBLE,
"releases_0_tender_additionalclassifications_13_description" VARCHAR,
"releases_0_tender_items_0_id" BIGINT
);
Contracts Finder OCDS 2019-10-10
@ukgov.contracts_finder_notices_10_20192_1.contracts_finder_ocds_2019_10_10
- 926.16 KB
- 204 rows
- 782 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_10_10 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"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_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" VARCHAR,
"releases_0_planning_documents_2_documenttype" VARCHAR,
"releases_0_planning_documents_2_description" VARCHAR,
"releases_0_planning_documents_2_url" VARCHAR,
"releases_0_planning_documents_2_format" VARCHAR,
"releases_0_planning_documents_3_id" DOUBLE,
"releases_0_planning_documents_3_documenttype" VARCHAR,
"releases_0_planning_documents_3_description" VARCHAR,
"releases_0_planning_documents_3_url" VARCHAR,
"releases_0_planning_documents_3_format" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_datepublished" TIMESTAMP,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_classification_scheme" VARCHAR,
"releases_0_tender_classification_id" DOUBLE,
"releases_0_tender_classification_description" VARCHAR,
"releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_0_id" DOUBLE,
"releases_0_tender_additionalclassifications_0_description" VARCHAR,
"releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_1_id" VARCHAR,
"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" VARCHAR,
"releases_0_tender_additionalclassifications_3_description" VARCHAR,
"releases_0_tender_additionalclassifications_4_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_4_id" VARCHAR,
"releases_0_tender_additionalclassifications_4_description" VARCHAR,
"releases_0_tender_additionalclassifications_5_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_5_id" VARCHAR,
"releases_0_tender_additionalclassifications_5_description" VARCHAR,
"releases_0_tender_additionalclassifications_6_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_6_id" VARCHAR,
"releases_0_tender_additionalclassifications_6_description" VARCHAR,
"releases_0_tender_additionalclassifications_7_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_7_id" DOUBLE,
"releases_0_tender_additionalclassifications_7_description" VARCHAR,
"releases_0_tender_items_0_id" 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_items_0_deliveryaddresses_7_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_7_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_8_region" VARCHAR
);
Contracts Finder OCDS 2019-10-11
@ukgov.contracts_finder_notices_10_20192_1.contracts_finder_ocds_2019_10_11
- 685.06 KB
- 167 rows
- 551 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_10_11 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"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" VARCHAR,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_planning_milestones_0_id" VARCHAR,
"releases_0_planning_milestones_0_title" VARCHAR,
"releases_0_planning_milestones_0_type" VARCHAR,
"releases_0_planning_milestones_0_duedate" 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" VARCHAR,
"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_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" VARCHAR,
"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_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_items_0_deliveryaddresses_7_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_7_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_8_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_8_countryname" VARCHAR
);
Contracts Finder OCDS 2019-10-12
@ukgov.contracts_finder_notices_10_20192_1.contracts_finder_ocds_2019_10_12
- 368.08 KB
- 12 rows
- 361 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_10_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_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_datepublished" TIMESTAMP,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_classification_scheme" VARCHAR,
"releases_0_tender_classification_id" BIGINT,
"releases_0_tender_classification_description" VARCHAR,
"releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_0_id" DOUBLE,
"releases_0_tender_additionalclassifications_0_description" VARCHAR,
"releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_1_id" DOUBLE,
"releases_0_tender_additionalclassifications_1_description" VARCHAR,
"releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_2_id" DOUBLE,
"releases_0_tender_additionalclassifications_2_description" VARCHAR,
"releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_3_id" DOUBLE,
"releases_0_tender_additionalclassifications_3_description" VARCHAR,
"releases_0_tender_additionalclassifications_4_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_4_id" DOUBLE,
"releases_0_tender_additionalclassifications_4_description" VARCHAR,
"releases_0_tender_additionalclassifications_5_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_5_id" DOUBLE,
"releases_0_tender_additionalclassifications_5_description" VARCHAR,
"releases_0_tender_additionalclassifications_6_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_6_id" DOUBLE,
"releases_0_tender_additionalclassifications_6_description" VARCHAR,
"releases_0_tender_additionalclassifications_7_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_7_id" DOUBLE,
"releases_0_tender_additionalclassifications_7_description" VARCHAR,
"releases_0_tender_additionalclassifications_8_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_8_id" DOUBLE,
"releases_0_tender_additionalclassifications_8_description" VARCHAR,
"releases_0_tender_additionalclassifications_9_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_9_id" DOUBLE,
"releases_0_tender_additionalclassifications_9_description" VARCHAR,
"releases_0_tender_additionalclassifications_10_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_10_id" DOUBLE,
"releases_0_tender_additionalclassifications_10_description" VARCHAR,
"releases_0_tender_additionalclassifications_11_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_11_id" DOUBLE,
"releases_0_tender_additionalclassifications_11_description" VARCHAR,
"releases_0_tender_additionalclassifications_12_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_12_id" DOUBLE,
"releases_0_tender_additionalclassifications_12_description" VARCHAR,
"releases_0_tender_additionalclassifications_13_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_13_id" DOUBLE,
"releases_0_tender_additionalclassifications_13_description" VARCHAR,
"releases_0_tender_additionalclassifications_14_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_14_id" DOUBLE,
"releases_0_tender_additionalclassifications_14_description" VARCHAR,
"releases_0_tender_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,
"releases_0_tender_additionalclassifications_18_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_18_id" DOUBLE,
"releases_0_tender_additionalclassifications_18_description" VARCHAR,
"releases_0_tender_additionalclassifications_19_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_19_id" DOUBLE,
"releases_0_tender_additionalclassifications_19_description" VARCHAR,
"releases_0_tender_additionalclassifications_20_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_20_id" DOUBLE,
"releases_0_tender_additionalclassifications_20_description" VARCHAR,
"releases_0_tender_additionalclassifications_21_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_21_id" DOUBLE,
"releases_0_tender_additionalclassifications_21_description" VARCHAR,
"releases_0_tender_additionalclassifications_22_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_22_id" DOUBLE,
"releases_0_tender_additionalclassifications_22_description" VARCHAR,
"releases_0_tender_additionalclassifications_23_scheme" VARCHAR
);
Contracts Finder OCDS 2019-10-13
@ukgov.contracts_finder_notices_10_20192_1.contracts_finder_ocds_2019_10_13
- 141.29 KB
- 17 rows
- 131 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_10_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_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_datepublished" TIMESTAMP,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_classification_scheme" VARCHAR,
"releases_0_tender_classification_id" BIGINT,
"releases_0_tender_classification_description" VARCHAR,
"releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_0_id" DOUBLE,
"releases_0_tender_additionalclassifications_0_description" VARCHAR,
"releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_1_id" DOUBLE,
"releases_0_tender_additionalclassifications_1_description" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_0_postalcode" VARCHAR,
"releases_0_tender_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_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_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_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" DOUBLE,
"releases_0_parties_1_address_streetaddress" VARCHAR,
"releases_0_parties_1_details_scale" VARCHAR,
"releases_0_parties_1_details_vcse" VARCHAR,
"releases_0_parties_1_roles_0" VARCHAR,
"releases_0_parties_2_id" VARCHAR,
"releases_0_parties_2_name" VARCHAR,
"releases_0_parties_2_identifier_legalname" VARCHAR,
"releases_0_parties_2_address_streetaddress" VARCHAR,
"releases_0_parties_2_details_scale" VARCHAR,
"releases_0_parties_2_details_vcse" VARCHAR
);
Contracts Finder OCDS 2019-10-14
@ukgov.contracts_finder_notices_10_20192_1.contracts_finder_ocds_2019_10_14
- 755.39 KB
- 215 rows
- 613 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_10_14 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"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_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_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_datepublished" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_classification_scheme" VARCHAR,
"releases_0_tender_classification_id" VARCHAR,
"releases_0_tender_classification_description" VARCHAR,
"releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_0_id" VARCHAR,
"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" VARCHAR,
"releases_0_tender_additionalclassifications_10_description" VARCHAR,
"releases_0_tender_additionalclassifications_11_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_11_id" VARCHAR,
"releases_0_tender_additionalclassifications_11_description" VARCHAR,
"releases_0_tender_additionalclassifications_12_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_12_id" VARCHAR,
"releases_0_tender_additionalclassifications_12_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
);
Contracts Finder OCDS 2019-10-15
@ukgov.contracts_finder_notices_10_20192_1.contracts_finder_ocds_2019_10_15
- 910.14 KB
- 214 rows
- 749 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_10_15 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"extensions_1" VARCHAR,
"extensions_2" VARCHAR,
"extensions_3" VARCHAR,
"extensions_4" VARCHAR,
"extensions_5" VARCHAR,
"extensions_6" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_planning_milestones_0_id" DOUBLE,
"releases_0_planning_milestones_0_title" VARCHAR,
"releases_0_planning_milestones_0_type" VARCHAR,
"releases_0_planning_milestones_0_duedate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_0_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_0_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_0_amount_currency" VARCHAR,
"releases_0_planning_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_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_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_datepublished" TIMESTAMP,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_classification_scheme" VARCHAR,
"releases_0_tender_classification_id" BIGINT,
"releases_0_tender_classification_description" VARCHAR,
"releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_0_id" DOUBLE,
"releases_0_tender_additionalclassifications_0_description" VARCHAR,
"releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_1_id" DOUBLE,
"releases_0_tender_additionalclassifications_1_description" VARCHAR,
"releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_2_id" DOUBLE,
"releases_0_tender_additionalclassifications_2_description" VARCHAR,
"releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_3_id" DOUBLE,
"releases_0_tender_additionalclassifications_3_description" VARCHAR,
"releases_0_tender_additionalclassifications_4_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_4_id" DOUBLE,
"releases_0_tender_additionalclassifications_4_description" VARCHAR,
"releases_0_tender_additionalclassifications_5_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_5_id" DOUBLE,
"releases_0_tender_additionalclassifications_5_description" VARCHAR
);
Contracts Finder OCDS 2019-10-16
@ukgov.contracts_finder_notices_10_20192_1.contracts_finder_ocds_2019_10_16
- 540.87 KB
- 216 rows
- 383 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_10_16 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"extensions_1" VARCHAR,
"extensions_2" VARCHAR,
"extensions_3" VARCHAR,
"extensions_4" VARCHAR,
"extensions_5" VARCHAR,
"extensions_6" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_0_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_0_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_0_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_0_amount_currency" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_1_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_1_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_1_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_1_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_1_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_1_amount_currency" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_planning_milestones_0_id" DOUBLE,
"releases_0_planning_milestones_0_title" VARCHAR,
"releases_0_planning_milestones_0_type" VARCHAR,
"releases_0_planning_milestones_0_duedate" TIMESTAMP,
"releases_0_planning_documents_0_id" DOUBLE,
"releases_0_planning_documents_0_documenttype" VARCHAR,
"releases_0_planning_documents_0_description" VARCHAR,
"releases_0_planning_documents_0_url" VARCHAR,
"releases_0_planning_documents_0_datepublished" TIMESTAMP,
"releases_0_planning_documents_0_datemodified" TIMESTAMP,
"releases_0_planning_documents_0_format" VARCHAR,
"releases_0_planning_documents_0_language" VARCHAR,
"releases_0_planning_documents_1_id" DOUBLE,
"releases_0_planning_documents_1_documenttype" VARCHAR,
"releases_0_planning_documents_1_description" VARCHAR,
"releases_0_planning_documents_1_url" VARCHAR,
"releases_0_planning_documents_1_format" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_datepublished" VARCHAR,
"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" VARCHAR,
"releases_0_tender_additionalclassifications_0_description" VARCHAR,
"releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_1_id" VARCHAR,
"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" VARCHAR,
"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" VARCHAR,
"releases_0_tender_additionalclassifications_12_description" VARCHAR,
"releases_0_tender_additionalclassifications_13_scheme" VARCHAR
);
Contracts Finder OCDS 2019-10-17
@ukgov.contracts_finder_notices_10_20192_1.contracts_finder_ocds_2019_10_17
- 891.86 KB
- 212 rows
- 739 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_10_17 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"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" VARCHAR,
"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" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_0_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_0_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_0_amount_currency" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_1_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_1_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_1_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_1_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_1_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_1_amount_currency" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_planning_milestones_0_id" DOUBLE,
"releases_0_planning_milestones_0_title" VARCHAR,
"releases_0_planning_milestones_0_type" VARCHAR,
"releases_0_planning_milestones_0_duedate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_2_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_2_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_2_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_2_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_2_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_2_amount_currency" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_3_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_3_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_3_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_3_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_3_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_3_amount_currency" VARCHAR,
"releases_0_planning_documents_0_id" DOUBLE,
"releases_0_planning_documents_0_documenttype" VARCHAR,
"releases_0_planning_documents_0_description" VARCHAR,
"releases_0_planning_documents_0_url" VARCHAR,
"releases_0_planning_documents_0_datepublished" TIMESTAMP,
"releases_0_planning_documents_0_format" VARCHAR,
"releases_0_planning_documents_0_language" VARCHAR,
"releases_0_planning_documents_1_id" DOUBLE,
"releases_0_planning_documents_1_documenttype" VARCHAR,
"releases_0_planning_documents_1_description" VARCHAR,
"releases_0_planning_documents_1_url" VARCHAR,
"releases_0_planning_documents_1_format" VARCHAR,
"releases_0_planning_documents_2_id" DOUBLE,
"releases_0_planning_documents_2_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_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_datepublished" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_classification_scheme" VARCHAR,
"releases_0_tender_classification_id" VARCHAR,
"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
);
Contracts Finder OCDS 2019-10-18
@ukgov.contracts_finder_notices_10_20192_1.contracts_finder_ocds_2019_10_18
- 668.74 KB
- 209 rows
- 506 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_10_18 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"extensions_1" VARCHAR,
"extensions_2" VARCHAR,
"extensions_3" VARCHAR,
"extensions_4" VARCHAR,
"extensions_5" VARCHAR,
"extensions_6" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_planning_milestones_0_id" DOUBLE,
"releases_0_planning_milestones_0_title" VARCHAR,
"releases_0_planning_milestones_0_type" VARCHAR,
"releases_0_planning_milestones_0_duedate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_0_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_0_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_0_amount_currency" VARCHAR,
"releases_0_planning_documents_0_id" DOUBLE,
"releases_0_planning_documents_0_documenttype" VARCHAR,
"releases_0_planning_documents_0_description" VARCHAR,
"releases_0_planning_documents_0_url" VARCHAR,
"releases_0_planning_documents_0_datepublished" TIMESTAMP,
"releases_0_planning_documents_0_format" VARCHAR,
"releases_0_planning_documents_0_language" VARCHAR,
"releases_0_planning_documents_1_id" DOUBLE,
"releases_0_planning_documents_1_documenttype" VARCHAR,
"releases_0_planning_documents_1_description" VARCHAR,
"releases_0_planning_documents_1_url" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_datepublished" TIMESTAMP,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_classification_scheme" VARCHAR,
"releases_0_tender_classification_id" BIGINT,
"releases_0_tender_classification_description" VARCHAR,
"releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_0_id" DOUBLE,
"releases_0_tender_additionalclassifications_0_description" VARCHAR,
"releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_1_id" DOUBLE,
"releases_0_tender_additionalclassifications_1_description" VARCHAR,
"releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_2_id" DOUBLE,
"releases_0_tender_additionalclassifications_2_description" VARCHAR,
"releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_3_id" DOUBLE,
"releases_0_tender_additionalclassifications_3_description" VARCHAR,
"releases_0_tender_additionalclassifications_4_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_4_id" DOUBLE,
"releases_0_tender_additionalclassifications_4_description" VARCHAR,
"releases_0_tender_additionalclassifications_5_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_5_id" DOUBLE,
"releases_0_tender_additionalclassifications_5_description" VARCHAR,
"releases_0_tender_additionalclassifications_6_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_6_id" DOUBLE,
"releases_0_tender_additionalclassifications_6_description" VARCHAR,
"releases_0_tender_additionalclassifications_7_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_7_id" DOUBLE,
"releases_0_tender_additionalclassifications_7_description" VARCHAR,
"releases_0_tender_additionalclassifications_8_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_8_id" DOUBLE,
"releases_0_tender_additionalclassifications_8_description" VARCHAR,
"releases_0_tender_additionalclassifications_9_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_9_id" DOUBLE,
"releases_0_tender_additionalclassifications_9_description" VARCHAR,
"releases_0_tender_additionalclassifications_10_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_10_id" DOUBLE,
"releases_0_tender_additionalclassifications_10_description" VARCHAR,
"releases_0_tender_additionalclassifications_11_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_11_id" DOUBLE,
"releases_0_tender_additionalclassifications_11_description" VARCHAR,
"releases_0_tender_additionalclassifications_12_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_12_id" DOUBLE,
"releases_0_tender_additionalclassifications_12_description" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_0_postalcode" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_1_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_2_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_2_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_3_region" VARCHAR
);
Contracts Finder OCDS 2019-10-19
@ukgov.contracts_finder_notices_10_20192_1.contracts_finder_ocds_2019_10_19
- 124.66 KB
- 12 rows
- 113 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_10_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_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_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_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_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_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 2019-10-20
@ukgov.contracts_finder_notices_10_20192_1.contracts_finder_ocds_2019_10_20
- 130.5 KB
- 9 rows
- 127 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_10_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_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_datepublished" TIMESTAMP,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_classification_scheme" VARCHAR,
"releases_0_tender_classification_id" BIGINT,
"releases_0_tender_classification_description" VARCHAR,
"releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_0_id" DOUBLE,
"releases_0_tender_additionalclassifications_0_description" VARCHAR,
"releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_1_id" DOUBLE,
"releases_0_tender_additionalclassifications_1_description" VARCHAR,
"releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_2_id" DOUBLE,
"releases_0_tender_additionalclassifications_2_description" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_deliveryaddresses_0_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_items_0_deliveryaddresses_6_countryname" VARCHAR,
"releases_0_tender_minvalue_amount" DOUBLE,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" DOUBLE,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_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_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_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
);
Contracts Finder OCDS 2019-10-21
@ukgov.contracts_finder_notices_10_20192_1.contracts_finder_ocds_2019_10_21
- 626.8 KB
- 234 rows
- 454 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_10_21 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"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_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" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_classification_scheme" VARCHAR,
"releases_0_tender_classification_id" VARCHAR,
"releases_0_tender_classification_description" VARCHAR,
"releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_0_id" VARCHAR,
"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" VARCHAR,
"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" VARCHAR,
"releases_0_tender_additionalclassifications_12_description" VARCHAR,
"releases_0_tender_additionalclassifications_13_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_13_id" VARCHAR,
"releases_0_tender_additionalclassifications_13_description" VARCHAR,
"releases_0_tender_additionalclassifications_14_scheme" VARCHAR
);
Contracts Finder OCDS 2019-10-22
@ukgov.contracts_finder_notices_10_20192_1.contracts_finder_ocds_2019_10_22
- 883.73 KB
- 186 rows
- 755 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_10_22 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"extensions_1" VARCHAR,
"extensions_2" VARCHAR,
"extensions_3" VARCHAR,
"extensions_4" VARCHAR,
"extensions_5" VARCHAR,
"extensions_6" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_planning_milestones_0_id" DOUBLE,
"releases_0_planning_milestones_0_title" VARCHAR,
"releases_0_planning_milestones_0_type" VARCHAR,
"releases_0_planning_milestones_0_duedate" TIMESTAMP,
"releases_0_planning_documents_0_id" DOUBLE,
"releases_0_planning_documents_0_documenttype" VARCHAR,
"releases_0_planning_documents_0_description" VARCHAR,
"releases_0_planning_documents_0_url" VARCHAR,
"releases_0_planning_documents_0_datepublished" TIMESTAMP,
"releases_0_planning_documents_0_format" VARCHAR,
"releases_0_planning_documents_0_language" VARCHAR,
"releases_0_planning_documents_1_id" DOUBLE,
"releases_0_planning_documents_1_documenttype" VARCHAR,
"releases_0_planning_documents_1_description" VARCHAR,
"releases_0_planning_documents_1_url" VARCHAR,
"releases_0_planning_documents_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_1_format" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_datepublished" TIMESTAMP,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_classification_scheme" VARCHAR,
"releases_0_tender_classification_id" BIGINT,
"releases_0_tender_classification_description" VARCHAR,
"releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_0_id" DOUBLE,
"releases_0_tender_additionalclassifications_0_description" VARCHAR,
"releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_1_id" DOUBLE,
"releases_0_tender_additionalclassifications_1_description" VARCHAR,
"releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_2_id" DOUBLE,
"releases_0_tender_additionalclassifications_2_description" VARCHAR,
"releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_3_id" DOUBLE,
"releases_0_tender_additionalclassifications_3_description" VARCHAR,
"releases_0_tender_additionalclassifications_4_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_4_id" DOUBLE,
"releases_0_tender_additionalclassifications_4_description" VARCHAR,
"releases_0_tender_additionalclassifications_5_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_5_id" DOUBLE,
"releases_0_tender_additionalclassifications_5_description" VARCHAR,
"releases_0_tender_additionalclassifications_6_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_6_id" DOUBLE,
"releases_0_tender_additionalclassifications_6_description" VARCHAR,
"releases_0_tender_additionalclassifications_7_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_7_id" DOUBLE,
"releases_0_tender_additionalclassifications_7_description" VARCHAR,
"releases_0_tender_additionalclassifications_8_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_8_id" DOUBLE,
"releases_0_tender_additionalclassifications_8_description" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_0_postalcode" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_1_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_2_region" VARCHAR,
"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_items_0_deliveryaddresses_7_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_7_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_8_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_8_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_9_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_10_countryname" VARCHAR
);
Contracts Finder OCDS 2019-10-23
@ukgov.contracts_finder_notices_10_20192_1.contracts_finder_ocds_2019_10_23
- 560.03 KB
- 168 rows
- 431 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_10_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_format" VARCHAR,
"releases_0_planning_documents_0_language" VARCHAR,
"releases_0_planning_documents_1_id" DOUBLE,
"releases_0_planning_documents_1_documenttype" VARCHAR,
"releases_0_planning_documents_1_description" VARCHAR,
"releases_0_planning_documents_1_url" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_datepublished" TIMESTAMP,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_classification_scheme" VARCHAR,
"releases_0_tender_classification_id" BIGINT,
"releases_0_tender_classification_description" VARCHAR,
"releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_0_id" DOUBLE,
"releases_0_tender_additionalclassifications_0_description" VARCHAR,
"releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_1_id" DOUBLE,
"releases_0_tender_additionalclassifications_1_description" VARCHAR,
"releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_2_id" DOUBLE,
"releases_0_tender_additionalclassifications_2_description" VARCHAR,
"releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_3_id" DOUBLE,
"releases_0_tender_additionalclassifications_3_description" VARCHAR,
"releases_0_tender_additionalclassifications_4_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_4_id" DOUBLE,
"releases_0_tender_additionalclassifications_4_description" VARCHAR,
"releases_0_tender_additionalclassifications_5_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_5_id" DOUBLE,
"releases_0_tender_additionalclassifications_5_description" VARCHAR,
"releases_0_tender_additionalclassifications_6_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_6_id" DOUBLE,
"releases_0_tender_additionalclassifications_6_description" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_deliveryaddresses_0_postalcode" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_1_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_2_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_2_region" 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_communication_futurenoticedate" 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
);
Contracts Finder OCDS 2019-10-24
@ukgov.contracts_finder_notices_10_20192_1.contracts_finder_ocds_2019_10_24
- 876.68 KB
- 192 rows
- 762 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_10_24 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"extensions_1" VARCHAR,
"extensions_2" VARCHAR,
"extensions_3" VARCHAR,
"extensions_4" VARCHAR,
"extensions_5" VARCHAR,
"extensions_6" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_planning_milestones_0_id" DOUBLE,
"releases_0_planning_milestones_0_title" VARCHAR,
"releases_0_planning_milestones_0_type" VARCHAR,
"releases_0_planning_milestones_0_duedate" TIMESTAMP,
"releases_0_planning_documents_0_id" DOUBLE,
"releases_0_planning_documents_0_documenttype" VARCHAR,
"releases_0_planning_documents_0_description" VARCHAR,
"releases_0_planning_documents_0_url" VARCHAR,
"releases_0_planning_documents_0_datepublished" TIMESTAMP,
"releases_0_planning_documents_0_format" VARCHAR,
"releases_0_planning_documents_0_language" VARCHAR,
"releases_0_planning_documents_1_id" DOUBLE,
"releases_0_planning_documents_1_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" BIGINT,
"releases_0_tender_classification_description" VARCHAR,
"releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_0_id" DOUBLE,
"releases_0_tender_additionalclassifications_0_description" VARCHAR,
"releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_1_id" DOUBLE,
"releases_0_tender_additionalclassifications_1_description" VARCHAR,
"releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_2_id" DOUBLE,
"releases_0_tender_additionalclassifications_2_description" VARCHAR,
"releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_3_id" DOUBLE,
"releases_0_tender_additionalclassifications_3_description" VARCHAR,
"releases_0_tender_additionalclassifications_4_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_4_id" DOUBLE,
"releases_0_tender_additionalclassifications_4_description" VARCHAR,
"releases_0_tender_additionalclassifications_5_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_5_id" DOUBLE,
"releases_0_tender_additionalclassifications_5_description" VARCHAR,
"releases_0_tender_additionalclassifications_6_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_6_id" DOUBLE,
"releases_0_tender_additionalclassifications_6_description" VARCHAR,
"releases_0_tender_additionalclassifications_7_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_7_id" DOUBLE,
"releases_0_tender_additionalclassifications_7_description" VARCHAR,
"releases_0_tender_additionalclassifications_8_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_8_id" DOUBLE,
"releases_0_tender_additionalclassifications_8_description" VARCHAR,
"releases_0_tender_additionalclassifications_9_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_9_id" DOUBLE,
"releases_0_tender_additionalclassifications_9_description" VARCHAR,
"releases_0_tender_additionalclassifications_10_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_10_id" DOUBLE,
"releases_0_tender_additionalclassifications_10_description" VARCHAR,
"releases_0_tender_additionalclassifications_11_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_11_id" DOUBLE,
"releases_0_tender_additionalclassifications_11_description" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_0_postalcode" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_1_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_2_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_2_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_3_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_3_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_4_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_4_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_5_region" VARCHAR
);
Contracts Finder OCDS 2019-10-25
@ukgov.contracts_finder_notices_10_20192_1.contracts_finder_ocds_2019_10_25
- 842.56 KB
- 211 rows
- 683 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_10_25 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"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_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" VARCHAR,
"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" VARCHAR,
"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" VARCHAR,
"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
);