Contracts Finder Notices 01–2016
Crown Commercial Service
@ukgov.contracts_finder_notices_01_20161_1
Loading...
Loading...
Loading...
Loading...
About this Dataset
Contracts Finder Notices 01–2016
Tables
Contracts Finder OCDS 2016-01-02
@ukgov.contracts_finder_notices_01_20161_1.contracts_finder_ocds_2016_01_02
- 98.1 KB
- 1 row
- 97 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2016_01_02 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"extensions_1" VARCHAR,
"extensions_2" VARCHAR,
"extensions_3" VARCHAR,
"extensions_4" VARCHAR,
"extensions_5" VARCHAR,
"extensions_6" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_datepublished" TIMESTAMP,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_classification_scheme" VARCHAR,
"releases_0_tender_classification_id" BIGINT,
"releases_0_tender_classification_description" VARCHAR,
"releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_0_id" BIGINT,
"releases_0_tender_additionalclassifications_0_description" VARCHAR,
"releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_1_id" BIGINT,
"releases_0_tender_additionalclassifications_1_description" VARCHAR,
"releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_2_id" BIGINT,
"releases_0_tender_additionalclassifications_2_description" VARCHAR,
"releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_3_id" BIGINT,
"releases_0_tender_additionalclassifications_3_description" VARCHAR,
"releases_0_tender_additionalclassifications_4_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_4_id" BIGINT,
"releases_0_tender_additionalclassifications_4_description" VARCHAR,
"releases_0_tender_additionalclassifications_5_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_5_id" BIGINT,
"releases_0_tender_additionalclassifications_5_description" VARCHAR,
"releases_0_tender_additionalclassifications_6_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_6_id" BIGINT,
"releases_0_tender_additionalclassifications_6_description" VARCHAR,
"releases_0_tender_additionalclassifications_7_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_7_id" BIGINT,
"releases_0_tender_additionalclassifications_7_description" VARCHAR,
"releases_0_tender_additionalclassifications_8_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_8_id" BIGINT,
"releases_0_tender_additionalclassifications_8_description" VARCHAR,
"releases_0_tender_additionalclassifications_9_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_9_id" BIGINT,
"releases_0_tender_additionalclassifications_9_description" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
"releases_0_tender_value_amount" BIGINT,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_contractperiod_startdate" TIMESTAMP,
"releases_0_tender_contractperiod_enddate" TIMESTAMP,
"releases_0_tender_suitability_sme" BIGINT,
"releases_0_tender_suitability_vcse" BIGINT,
"releases_0_tender_mainprocurementcategory" VARCHAR,
"releases_0_tender_documents_0_id" BIGINT,
"releases_0_tender_documents_0_documenttype" VARCHAR,
"releases_0_tender_documents_0_description" VARCHAR,
"releases_0_tender_documents_0_url" VARCHAR,
"releases_0_tender_documents_0_datepublished" TIMESTAMP,
"releases_0_tender_documents_0_format" VARCHAR,
"releases_0_tender_documents_0_language" VARCHAR,
"releases_0_tender_documents_1_id" BIGINT,
"releases_0_tender_documents_1_documenttype" VARCHAR,
"releases_0_tender_documents_1_description" VARCHAR,
"releases_0_tender_documents_1_url" VARCHAR,
"releases_0_parties_0_id" VARCHAR,
"releases_0_parties_0_name" VARCHAR,
"releases_0_parties_0_identifier_legalname" VARCHAR,
"releases_0_parties_0_address_streetaddress" VARCHAR,
"releases_0_parties_0_address_locality" VARCHAR,
"releases_0_parties_0_address_postalcode" VARCHAR,
"releases_0_parties_0_address_countryname" VARCHAR,
"releases_0_parties_0_contactpoint_name" VARCHAR,
"releases_0_parties_0_contactpoint_email" VARCHAR,
"releases_0_parties_0_contactpoint_telephone" BIGINT,
"releases_0_parties_0_roles_0" VARCHAR,
"releases_0_buyer_id" VARCHAR,
"releases_0_buyer_name" VARCHAR
);
Contracts Finder OCDS 2016-01-03
@ukgov.contracts_finder_notices_01_20161_1.contracts_finder_ocds_2016_01_03
- 93.36 KB
- 2 rows
- 94 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2016_01_03 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"extensions_1" VARCHAR,
"extensions_2" VARCHAR,
"extensions_3" VARCHAR,
"extensions_4" VARCHAR,
"extensions_5" VARCHAR,
"extensions_6" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_datepublished" TIMESTAMP,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_classification_scheme" VARCHAR,
"releases_0_tender_classification_id" BIGINT,
"releases_0_tender_classification_description" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_deliveryaddresses_0_postalcode" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_1_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
"releases_0_tender_minvalue_amount" DOUBLE,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
"releases_0_tender_value_amount" BIGINT,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_contractperiod_startdate" TIMESTAMP,
"releases_0_tender_contractperiod_enddate" TIMESTAMP,
"releases_0_tender_suitability_sme" DOUBLE,
"releases_0_tender_suitability_vcse" DOUBLE,
"releases_0_tender_mainprocurementcategory" VARCHAR,
"releases_0_tender_documents_0_id" DOUBLE,
"releases_0_tender_documents_0_documenttype" VARCHAR,
"releases_0_tender_documents_0_description" VARCHAR,
"releases_0_tender_documents_0_url" VARCHAR,
"releases_0_tender_documents_0_datepublished" TIMESTAMP,
"releases_0_tender_documents_0_format" VARCHAR,
"releases_0_tender_documents_0_language" VARCHAR,
"releases_0_parties_0_id" VARCHAR,
"releases_0_parties_0_name" VARCHAR,
"releases_0_parties_0_identifier_legalname" VARCHAR,
"releases_0_parties_0_identifier_scheme" VARCHAR,
"releases_0_parties_0_identifier_id" VARCHAR,
"releases_0_parties_0_address_streetaddress" VARCHAR,
"releases_0_parties_0_address_locality" VARCHAR,
"releases_0_parties_0_address_postalcode" VARCHAR,
"releases_0_parties_0_address_countryname" VARCHAR,
"releases_0_parties_0_contactpoint_name" VARCHAR,
"releases_0_parties_0_contactpoint_email" VARCHAR,
"releases_0_parties_0_contactpoint_telephone" DOUBLE,
"releases_0_parties_0_roles_0" VARCHAR,
"releases_0_parties_1_id" VARCHAR,
"releases_0_parties_1_name" VARCHAR,
"releases_0_parties_1_identifier_legalname" VARCHAR,
"releases_0_parties_1_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 2016-01-04
@ukgov.contracts_finder_notices_01_20161_1.contracts_finder_ocds_2016_01_04
- 469 KB
- 105 rows
- 379 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2016_01_04 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"extensions_1" VARCHAR,
"extensions_2" VARCHAR,
"extensions_3" VARCHAR,
"extensions_4" VARCHAR,
"extensions_5" VARCHAR,
"extensions_6" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_planning_milestones_0_id" DOUBLE,
"releases_0_planning_milestones_0_title" VARCHAR,
"releases_0_planning_milestones_0_type" VARCHAR,
"releases_0_planning_milestones_0_duedate" TIMESTAMP,
"releases_0_planning_documents_0_id" DOUBLE,
"releases_0_planning_documents_0_documenttype" VARCHAR,
"releases_0_planning_documents_0_description" VARCHAR,
"releases_0_planning_documents_0_url" VARCHAR,
"releases_0_planning_documents_0_datepublished" TIMESTAMP,
"releases_0_planning_documents_0_format" VARCHAR,
"releases_0_planning_documents_0_language" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_datepublished" TIMESTAMP,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_classification_scheme" VARCHAR,
"releases_0_tender_classification_id" 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_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
);
Contracts Finder OCDS 2016-01-05
@ukgov.contracts_finder_notices_01_20161_1.contracts_finder_ocds_2016_01_05
- 370.06 KB
- 117 rows
- 262 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2016_01_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_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_items_0_id" BIGINT,
"releases_0_tender_items_0_deliveryaddresses_0_postalcode" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_1_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_2_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_2_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_3_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_3_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_4_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_4_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_5_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_5_countryname" VARCHAR,
"releases_0_tender_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_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_9_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_10_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_10_countryname" VARCHAR
);
Contracts Finder OCDS 2016-01-06
@ukgov.contracts_finder_notices_01_20161_1.contracts_finder_ocds_2016_01_06
- 415.72 KB
- 79 rows
- 343 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2016_01_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_planning_budget_budgetbreakdown_0_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_0_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_0_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_0_amount_currency" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_planning_milestones_0_id" DOUBLE,
"releases_0_planning_milestones_0_title" VARCHAR,
"releases_0_planning_milestones_0_type" VARCHAR,
"releases_0_planning_milestones_0_duedate" TIMESTAMP,
"releases_0_planning_documents_0_id" DOUBLE,
"releases_0_planning_documents_0_documenttype" VARCHAR,
"releases_0_planning_documents_0_description" VARCHAR,
"releases_0_planning_documents_0_url" VARCHAR,
"releases_0_planning_documents_0_datepublished" TIMESTAMP,
"releases_0_planning_documents_0_format" VARCHAR,
"releases_0_planning_documents_0_language" VARCHAR,
"releases_0_planning_documents_1_id" DOUBLE,
"releases_0_planning_documents_1_documenttype" VARCHAR,
"releases_0_planning_documents_1_description" VARCHAR,
"releases_0_planning_documents_1_url" VARCHAR,
"releases_0_planning_documents_1_format" VARCHAR,
"releases_0_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,
"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
);
Contracts Finder OCDS 2016-01-07
@ukgov.contracts_finder_notices_01_20161_1.contracts_finder_ocds_2016_01_07
- 696.97 KB
- 82 rows
- 659 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2016_01_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_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_5_id" DOUBLE,
"releases_0_planning_documents_5_documenttype" VARCHAR,
"releases_0_planning_documents_5_description" VARCHAR,
"releases_0_planning_documents_5_url" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_datepublished" TIMESTAMP,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_classification_scheme" VARCHAR,
"releases_0_tender_classification_id" BIGINT,
"releases_0_tender_classification_description" VARCHAR,
"releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_0_id" DOUBLE,
"releases_0_tender_additionalclassifications_0_description" VARCHAR,
"releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_1_id" DOUBLE,
"releases_0_tender_additionalclassifications_1_description" VARCHAR,
"releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_2_id" DOUBLE,
"releases_0_tender_additionalclassifications_2_description" VARCHAR,
"releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_3_id" DOUBLE,
"releases_0_tender_additionalclassifications_3_description" VARCHAR,
"releases_0_tender_additionalclassifications_4_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_4_id" DOUBLE,
"releases_0_tender_additionalclassifications_4_description" VARCHAR,
"releases_0_tender_additionalclassifications_5_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_5_id" DOUBLE,
"releases_0_tender_additionalclassifications_5_description" VARCHAR,
"releases_0_tender_additionalclassifications_6_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_6_id" DOUBLE,
"releases_0_tender_additionalclassifications_6_description" VARCHAR,
"releases_0_tender_additionalclassifications_7_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_7_id" DOUBLE,
"releases_0_tender_additionalclassifications_7_description" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_deliveryaddresses_0_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_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_5_countryname" VARCHAR,
"releases_0_tender_minvalue_amount" DOUBLE
);
Contracts Finder OCDS 2016-01-08
@ukgov.contracts_finder_notices_01_20161_1.contracts_finder_ocds_2016_01_08
- 721.07 KB
- 126 rows
- 628 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2016_01_08 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"extensions_1" VARCHAR,
"extensions_2" VARCHAR,
"extensions_3" VARCHAR,
"extensions_4" VARCHAR,
"extensions_5" VARCHAR,
"extensions_6" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_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" 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
);
Contracts Finder OCDS 2016-01-09
@ukgov.contracts_finder_notices_01_20161_1.contracts_finder_ocds_2016_01_09
- 99.14 KB
- 3 rows
- 102 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2016_01_09 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"extensions_1" VARCHAR,
"extensions_2" VARCHAR,
"extensions_3" VARCHAR,
"extensions_4" VARCHAR,
"extensions_5" VARCHAR,
"extensions_6" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_datepublished" TIMESTAMP,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_classification_scheme" VARCHAR,
"releases_0_tender_classification_id" BIGINT,
"releases_0_tender_classification_description" VARCHAR,
"releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_0_id" DOUBLE,
"releases_0_tender_additionalclassifications_0_description" VARCHAR,
"releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_1_id" DOUBLE,
"releases_0_tender_additionalclassifications_1_description" VARCHAR,
"releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_2_id" DOUBLE,
"releases_0_tender_additionalclassifications_2_description" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
"releases_0_tender_value_amount" BIGINT,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_contractperiod_startdate" TIMESTAMP,
"releases_0_tender_contractperiod_enddate" TIMESTAMP,
"releases_0_tender_suitability_sme" DOUBLE,
"releases_0_tender_suitability_vcse" 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_identifier_scheme" VARCHAR,
"releases_0_parties_0_identifier_id" VARCHAR,
"releases_0_parties_0_address_streetaddress" VARCHAR,
"releases_0_parties_0_address_locality" VARCHAR,
"releases_0_parties_0_address_postalcode" VARCHAR,
"releases_0_parties_0_address_countryname" VARCHAR,
"releases_0_parties_0_contactpoint_name" VARCHAR,
"releases_0_parties_0_contactpoint_email" VARCHAR,
"releases_0_parties_0_contactpoint_telephone" DOUBLE,
"releases_0_parties_0_roles_0" VARCHAR,
"releases_0_parties_1_id" VARCHAR,
"releases_0_parties_1_name" VARCHAR,
"releases_0_parties_1_identifier_legalname" VARCHAR,
"releases_0_parties_1_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
);
Contracts Finder OCDS 2016-01-10
@ukgov.contracts_finder_notices_01_20161_1.contracts_finder_ocds_2016_01_10
- 281.63 KB
- 3 rows
- 279 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2016_01_10 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"extensions_1" VARCHAR,
"extensions_2" VARCHAR,
"extensions_3" VARCHAR,
"extensions_4" VARCHAR,
"extensions_5" VARCHAR,
"extensions_6" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_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 2016-01-11
@ukgov.contracts_finder_notices_01_20161_1.contracts_finder_ocds_2016_01_11
- 475.26 KB
- 117 rows
- 373 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2016_01_11 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"extensions_1" VARCHAR,
"extensions_2" VARCHAR,
"extensions_3" VARCHAR,
"extensions_4" VARCHAR,
"extensions_5" VARCHAR,
"extensions_6" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_planning_milestones_0_id" DOUBLE,
"releases_0_planning_milestones_0_title" VARCHAR,
"releases_0_planning_milestones_0_type" VARCHAR,
"releases_0_planning_milestones_0_duedate" TIMESTAMP,
"releases_0_planning_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" 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
);
Contracts Finder OCDS 2016-01-12
@ukgov.contracts_finder_notices_01_20161_1.contracts_finder_ocds_2016_01_12
- 622.56 KB
- 147 rows
- 522 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2016_01_12 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"extensions_1" VARCHAR,
"extensions_2" VARCHAR,
"extensions_3" VARCHAR,
"extensions_4" VARCHAR,
"extensions_5" VARCHAR,
"extensions_6" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_planning_milestones_0_id" DOUBLE,
"releases_0_planning_milestones_0_title" VARCHAR,
"releases_0_planning_milestones_0_type" VARCHAR,
"releases_0_planning_milestones_0_duedate" TIMESTAMP,
"releases_0_planning_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" 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
);
Contracts Finder OCDS 2016-01-13
@ukgov.contracts_finder_notices_01_20161_1.contracts_finder_ocds_2016_01_13
- 391.76 KB
- 64 rows
- 323 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2016_01_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_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_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" 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
);
Contracts Finder OCDS 2016-01-14
@ukgov.contracts_finder_notices_01_20161_1.contracts_finder_ocds_2016_01_14
- 691.67 KB
- 145 rows
- 554 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2016_01_14 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"extensions_1" VARCHAR,
"extensions_2" VARCHAR,
"extensions_3" VARCHAR,
"extensions_4" VARCHAR,
"extensions_5" VARCHAR,
"extensions_6" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_0_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_0_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_0_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_0_amount_currency" VARCHAR,
"releases_0_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_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
);
Contracts Finder OCDS 2016-01-15
@ukgov.contracts_finder_notices_01_20161_1.contracts_finder_ocds_2016_01_15
- 495.15 KB
- 128 rows
- 360 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2016_01_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_planning_budget_budgetbreakdown_0_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_0_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_0_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_0_amount_currency" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_planning_milestones_0_id" DOUBLE,
"releases_0_planning_milestones_0_title" VARCHAR,
"releases_0_planning_milestones_0_type" VARCHAR,
"releases_0_planning_milestones_0_duedate" TIMESTAMP,
"releases_0_planning_documents_0_id" DOUBLE,
"releases_0_planning_documents_0_documenttype" VARCHAR,
"releases_0_planning_documents_0_description" VARCHAR,
"releases_0_planning_documents_0_url" VARCHAR,
"releases_0_planning_documents_0_datepublished" TIMESTAMP,
"releases_0_planning_documents_0_format" VARCHAR,
"releases_0_planning_documents_0_language" VARCHAR,
"releases_0_planning_documents_1_id" DOUBLE,
"releases_0_planning_documents_1_documenttype" VARCHAR,
"releases_0_planning_documents_1_description" VARCHAR,
"releases_0_planning_documents_1_url" VARCHAR,
"releases_0_planning_documents_1_format" VARCHAR,
"releases_0_planning_documents_2_id" DOUBLE,
"releases_0_planning_documents_2_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_additionalclassifications_14_scheme" VARCHAR
);
Contracts Finder OCDS 2016-01-16
@ukgov.contracts_finder_notices_01_20161_1.contracts_finder_ocds_2016_01_16
- 123.53 KB
- 14 rows
- 105 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2016_01_16 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"extensions_1" VARCHAR,
"extensions_2" VARCHAR,
"extensions_3" VARCHAR,
"extensions_4" VARCHAR,
"extensions_5" VARCHAR,
"extensions_6" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_datepublished" TIMESTAMP,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_classification_scheme" VARCHAR,
"releases_0_tender_classification_id" BIGINT,
"releases_0_tender_classification_description" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_1_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_2_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_3_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_4_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_5_countryname" VARCHAR,
"releases_0_tender_minvalue_amount" DOUBLE,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" DOUBLE,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_contractperiod_startdate" TIMESTAMP,
"releases_0_tender_contractperiod_enddate" TIMESTAMP,
"releases_0_tender_suitability_sme" BIGINT,
"releases_0_tender_suitability_vcse" DOUBLE,
"releases_0_tender_mainprocurementcategory" VARCHAR,
"releases_0_tender_documents_0_id" DOUBLE,
"releases_0_tender_documents_0_documenttype" VARCHAR,
"releases_0_tender_documents_0_description" VARCHAR,
"releases_0_tender_documents_0_url" VARCHAR,
"releases_0_tender_documents_0_datepublished" TIMESTAMP,
"releases_0_tender_documents_0_format" VARCHAR,
"releases_0_tender_documents_0_language" VARCHAR,
"releases_0_tender_documents_1_id" DOUBLE,
"releases_0_tender_documents_1_documenttype" VARCHAR,
"releases_0_tender_documents_1_description" VARCHAR,
"releases_0_tender_documents_1_url" VARCHAR,
"releases_0_parties_0_id" VARCHAR,
"releases_0_parties_0_name" VARCHAR,
"releases_0_parties_0_identifier_legalname" VARCHAR,
"releases_0_parties_0_address_streetaddress" VARCHAR,
"releases_0_parties_0_address_locality" VARCHAR,
"releases_0_parties_0_address_postalcode" VARCHAR,
"releases_0_parties_0_address_countryname" VARCHAR,
"releases_0_parties_0_contactpoint_name" VARCHAR,
"releases_0_parties_0_contactpoint_email" VARCHAR,
"releases_0_parties_0_details_url" VARCHAR,
"releases_0_parties_0_contactpoint_telephone" DOUBLE,
"releases_0_parties_0_roles_0" VARCHAR,
"releases_0_parties_1_id" VARCHAR,
"releases_0_parties_1_name" VARCHAR,
"releases_0_parties_1_identifier_legalname" VARCHAR,
"releases_0_parties_1_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 2016-01-17
@ukgov.contracts_finder_notices_01_20161_1.contracts_finder_ocds_2016_01_17
- 200.46 KB
- 7 rows
- 196 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2016_01_17 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"extensions_1" VARCHAR,
"extensions_2" VARCHAR,
"extensions_3" VARCHAR,
"extensions_4" VARCHAR,
"extensions_5" VARCHAR,
"extensions_6" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_datepublished" TIMESTAMP,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_classification_scheme" VARCHAR,
"releases_0_tender_classification_id" BIGINT,
"releases_0_tender_classification_description" VARCHAR,
"releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_0_id" DOUBLE,
"releases_0_tender_additionalclassifications_0_description" VARCHAR,
"releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_1_id" DOUBLE,
"releases_0_tender_additionalclassifications_1_description" VARCHAR,
"releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_2_id" DOUBLE,
"releases_0_tender_additionalclassifications_2_description" VARCHAR,
"releases_0_tender_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_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
);
Contracts Finder OCDS 2016-01-18
@ukgov.contracts_finder_notices_01_20161_1.contracts_finder_ocds_2016_01_18
- 1.48 MB
- 147 rows
- 1359 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2016_01_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_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
);
Contracts Finder OCDS 2016-01-19
@ukgov.contracts_finder_notices_01_20161_1.contracts_finder_ocds_2016_01_19
- 564.01 KB
- 120 rows
- 455 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2016_01_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_planning_budget_budgetbreakdown_0_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_0_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_0_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_0_amount_currency" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_planning_milestones_0_id" DOUBLE,
"releases_0_planning_milestones_0_title" VARCHAR,
"releases_0_planning_milestones_0_type" VARCHAR,
"releases_0_planning_milestones_0_duedate" TIMESTAMP,
"releases_0_planning_documents_0_id" DOUBLE,
"releases_0_planning_documents_0_documenttype" VARCHAR,
"releases_0_planning_documents_0_description" VARCHAR,
"releases_0_planning_documents_0_url" VARCHAR,
"releases_0_planning_documents_0_datepublished" TIMESTAMP,
"releases_0_planning_documents_0_format" VARCHAR,
"releases_0_planning_documents_0_language" VARCHAR,
"releases_0_planning_documents_1_id" DOUBLE,
"releases_0_planning_documents_1_documenttype" VARCHAR,
"releases_0_planning_documents_1_description" VARCHAR,
"releases_0_planning_documents_1_url" VARCHAR,
"releases_0_planning_documents_1_format" VARCHAR,
"releases_0_planning_documents_2_id" DOUBLE,
"releases_0_planning_documents_2_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,
"releases_0_tender_additionalclassifications_12_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_12_id" DOUBLE,
"releases_0_tender_additionalclassifications_12_description" VARCHAR,
"releases_0_tender_additionalclassifications_13_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_13_id" DOUBLE,
"releases_0_tender_additionalclassifications_13_description" VARCHAR
);
Contracts Finder OCDS 2016-01-20
@ukgov.contracts_finder_notices_01_20161_1.contracts_finder_ocds_2016_01_20
- 616.84 KB
- 146 rows
- 523 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2016_01_20 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"extensions_1" VARCHAR,
"extensions_2" VARCHAR,
"extensions_3" VARCHAR,
"extensions_4" VARCHAR,
"extensions_5" VARCHAR,
"extensions_6" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_0_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_0_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_0_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_0_amount_currency" VARCHAR,
"releases_0_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_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
);
Contracts Finder OCDS 2016-01-21
@ukgov.contracts_finder_notices_01_20161_1.contracts_finder_ocds_2016_01_21
- 483.33 KB
- 151 rows
- 345 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2016_01_21 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"extensions_1" VARCHAR,
"extensions_2" VARCHAR,
"extensions_3" VARCHAR,
"extensions_4" VARCHAR,
"extensions_5" VARCHAR,
"extensions_6" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_planning_milestones_0_id" DOUBLE,
"releases_0_planning_milestones_0_title" VARCHAR,
"releases_0_planning_milestones_0_type" VARCHAR,
"releases_0_planning_milestones_0_duedate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_0_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_0_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_0_amount_currency" VARCHAR,
"releases_0_planning_documents_0_id" DOUBLE,
"releases_0_planning_documents_0_documenttype" VARCHAR,
"releases_0_planning_documents_0_description" VARCHAR,
"releases_0_planning_documents_0_url" VARCHAR,
"releases_0_planning_documents_0_datepublished" TIMESTAMP,
"releases_0_planning_documents_0_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_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
);
Contracts Finder OCDS 2016-01-22
@ukgov.contracts_finder_notices_01_20161_1.contracts_finder_ocds_2016_01_22
- 544.82 KB
- 151 rows
- 411 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2016_01_22 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"extensions_1" VARCHAR,
"extensions_2" VARCHAR,
"extensions_3" VARCHAR,
"extensions_4" VARCHAR,
"extensions_5" VARCHAR,
"extensions_6" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_datepublished" TIMESTAMP,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_classification_scheme" VARCHAR,
"releases_0_tender_classification_id" BIGINT,
"releases_0_tender_classification_description" VARCHAR,
"releases_0_tender_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 2016-01-23
@ukgov.contracts_finder_notices_01_20161_1.contracts_finder_ocds_2016_01_23
- 161.22 KB
- 6 rows
- 154 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2016_01_23 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"extensions_1" VARCHAR,
"extensions_2" VARCHAR,
"extensions_3" VARCHAR,
"extensions_4" VARCHAR,
"extensions_5" VARCHAR,
"extensions_6" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_datepublished" TIMESTAMP,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_classification_scheme" VARCHAR,
"releases_0_tender_classification_id" BIGINT,
"releases_0_tender_classification_description" VARCHAR,
"releases_0_tender_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_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_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_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
);
Contracts Finder OCDS 2016-01-24
@ukgov.contracts_finder_notices_01_20161_1.contracts_finder_ocds_2016_01_24
- 244.54 KB
- 8 rows
- 248 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2016_01_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_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_items_0_id" BIGINT,
"releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_0_postalcode" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_1_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_2_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_3_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_4_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_5_countryname" VARCHAR,
"releases_0_tender_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
);
Contracts Finder OCDS 2016-01-25
@ukgov.contracts_finder_notices_01_20161_1.contracts_finder_ocds_2016_01_25
- 522.02 KB
- 140 rows
- 392 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2016_01_25 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"extensions_1" VARCHAR,
"extensions_2" VARCHAR,
"extensions_3" VARCHAR,
"extensions_4" VARCHAR,
"extensions_5" VARCHAR,
"extensions_6" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_0_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_0_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_0_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_0_amount_currency" VARCHAR,
"releases_0_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,
"releases_0_tender_additionalclassifications_12_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_12_id" DOUBLE,
"releases_0_tender_additionalclassifications_12_description" VARCHAR,
"releases_0_tender_additionalclassifications_13_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_13_id" DOUBLE,
"releases_0_tender_additionalclassifications_13_description" VARCHAR
);
Contracts Finder OCDS 2016-01-26
@ukgov.contracts_finder_notices_01_20161_1.contracts_finder_ocds_2016_01_26
- 519.02 KB
- 158 rows
- 382 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2016_01_26 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"extensions_1" VARCHAR,
"extensions_2" VARCHAR,
"extensions_3" VARCHAR,
"extensions_4" VARCHAR,
"extensions_5" VARCHAR,
"extensions_6" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_planning_milestones_0_id" DOUBLE,
"releases_0_planning_milestones_0_title" VARCHAR,
"releases_0_planning_milestones_0_type" VARCHAR,
"releases_0_planning_milestones_0_duedate" TIMESTAMP,
"releases_0_planning_documents_0_id" DOUBLE,
"releases_0_planning_documents_0_documenttype" VARCHAR,
"releases_0_planning_documents_0_description" VARCHAR,
"releases_0_planning_documents_0_url" VARCHAR,
"releases_0_planning_documents_0_datepublished" TIMESTAMP,
"releases_0_planning_documents_0_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_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
);