Contracts Finder Notices 03–2019
Crown Commercial Service
@ukgov.contracts_finder_notices_03_20192_1
Loading...
Loading...
Loading...
Loading...
About this Dataset
Contracts Finder Notices 03–2019
Tables
Contracts Finder OCDS 2019-03-20
@ukgov.contracts_finder_notices_03_20192_1.contracts_finder_ocds_2019_03_20
- 656.85 KB
- 210 rows
- 498 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_03_20 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"extensions_0" VARCHAR,
"extensions_1" VARCHAR,
"extensions_2" VARCHAR,
"extensions_3" VARCHAR,
"extensions_4" VARCHAR,
"extensions_5" VARCHAR,
"extensions_6" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" 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" DOUBLE,
"releases_0_tender_classification_description" VARCHAR,
"releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_0_id" DOUBLE,
"releases_0_tender_additionalclassifications_0_description" VARCHAR,
"releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_1_id" DOUBLE,
"releases_0_tender_additionalclassifications_1_description" VARCHAR,
"releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_2_id" DOUBLE,
"releases_0_tender_additionalclassifications_2_description" VARCHAR,
"releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_3_id" DOUBLE,
"releases_0_tender_additionalclassifications_3_description" VARCHAR,
"releases_0_tender_additionalclassifications_4_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_4_id" DOUBLE,
"releases_0_tender_additionalclassifications_4_description" VARCHAR,
"releases_0_tender_additionalclassifications_5_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_5_id" DOUBLE,
"releases_0_tender_additionalclassifications_5_description" VARCHAR,
"releases_0_tender_additionalclassifications_6_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_6_id" DOUBLE,
"releases_0_tender_additionalclassifications_6_description" VARCHAR,
"releases_0_tender_additionalclassifications_7_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_7_id" DOUBLE,
"releases_0_tender_additionalclassifications_7_description" VARCHAR,
"releases_0_tender_additionalclassifications_8_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_8_id" DOUBLE,
"releases_0_tender_additionalclassifications_8_description" VARCHAR,
"releases_0_tender_additionalclassifications_9_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_9_id" DOUBLE,
"releases_0_tender_additionalclassifications_9_description" VARCHAR,
"releases_0_tender_additionalclassifications_10_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_10_id" DOUBLE,
"releases_0_tender_additionalclassifications_10_description" VARCHAR,
"releases_0_tender_additionalclassifications_11_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_11_id" DOUBLE,
"releases_0_tender_additionalclassifications_11_description" VARCHAR,
"releases_0_tender_additionalclassifications_12_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_12_id" DOUBLE,
"releases_0_tender_additionalclassifications_12_description" VARCHAR,
"releases_0_tender_additionalclassifications_13_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_13_id" DOUBLE,
"releases_0_tender_additionalclassifications_13_description" VARCHAR
);
Contracts Finder OCDS 2019-03-13
@ukgov.contracts_finder_notices_03_20192_1.contracts_finder_ocds_2019_03_13
- 540.34 KB
- 231 rows
- 362 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_03_13 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"extensions_0" VARCHAR,
"extensions_1" VARCHAR,
"extensions_2" VARCHAR,
"extensions_3" VARCHAR,
"extensions_4" VARCHAR,
"extensions_5" VARCHAR,
"extensions_6" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" VARCHAR,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_0_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_0_period_startdate" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_0_period_enddate" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_0_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_0_amount_amount" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_0_amount_currency" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_planning_milestones_0_id" VARCHAR,
"releases_0_planning_milestones_0_title" VARCHAR,
"releases_0_planning_milestones_0_type" VARCHAR,
"releases_0_planning_milestones_0_duedate" 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" DOUBLE,
"releases_0_tender_classification_description" VARCHAR,
"releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_0_id" DOUBLE,
"releases_0_tender_additionalclassifications_0_description" VARCHAR,
"releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_1_id" DOUBLE,
"releases_0_tender_additionalclassifications_1_description" VARCHAR,
"releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_2_id" DOUBLE,
"releases_0_tender_additionalclassifications_2_description" VARCHAR,
"releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_3_id" DOUBLE,
"releases_0_tender_additionalclassifications_3_description" VARCHAR,
"releases_0_tender_additionalclassifications_4_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_4_id" DOUBLE,
"releases_0_tender_additionalclassifications_4_description" VARCHAR,
"releases_0_tender_additionalclassifications_5_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_5_id" DOUBLE,
"releases_0_tender_additionalclassifications_5_description" VARCHAR,
"releases_0_tender_additionalclassifications_6_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_6_id" DOUBLE,
"releases_0_tender_additionalclassifications_6_description" VARCHAR,
"releases_0_tender_additionalclassifications_7_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_7_id" VARCHAR,
"releases_0_tender_additionalclassifications_7_description" VARCHAR,
"releases_0_tender_additionalclassifications_8_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_8_id" DOUBLE,
"releases_0_tender_additionalclassifications_8_description" VARCHAR,
"releases_0_tender_additionalclassifications_9_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_9_id" DOUBLE,
"releases_0_tender_additionalclassifications_9_description" VARCHAR,
"releases_0_tender_additionalclassifications_10_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_10_id" DOUBLE,
"releases_0_tender_additionalclassifications_10_description" VARCHAR,
"releases_0_tender_additionalclassifications_11_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_11_id" DOUBLE,
"releases_0_tender_additionalclassifications_11_description" VARCHAR,
"releases_0_tender_additionalclassifications_12_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_12_id" VARCHAR,
"releases_0_tender_additionalclassifications_12_description" VARCHAR,
"releases_0_tender_additionalclassifications_13_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_13_id" VARCHAR,
"releases_0_tender_additionalclassifications_13_description" VARCHAR,
"releases_0_tender_additionalclassifications_14_scheme" VARCHAR,
"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" VARCHAR
);
Contracts Finder OCDS 2019-03-21
@ukgov.contracts_finder_notices_03_20192_1.contracts_finder_ocds_2019_03_21
- 981.08 KB
- 238 rows
- 807 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_03_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_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 2019-03-10
@ukgov.contracts_finder_notices_03_20192_1.contracts_finder_ocds_2019_03_10
- 143.68 KB
- 14 rows
- 140 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_03_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_items_0_id" BIGINT,
"releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
"releases_0_tender_minvalue_amount" DOUBLE,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" DOUBLE,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" 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_procurementmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_contractperiod_startdate" TIMESTAMP,
"releases_0_tender_contractperiod_enddate" TIMESTAMP,
"releases_0_tender_suitability_sme" DOUBLE,
"releases_0_tender_suitability_vcse" DOUBLE,
"releases_0_tender_mainprocurementcategory" VARCHAR,
"releases_0_tender_documents_0_id" DOUBLE,
"releases_0_tender_documents_0_documenttype" VARCHAR,
"releases_0_tender_documents_0_description" VARCHAR,
"releases_0_tender_documents_0_url" VARCHAR,
"releases_0_tender_documents_0_datepublished" TIMESTAMP,
"releases_0_tender_documents_0_format" VARCHAR,
"releases_0_tender_documents_0_language" VARCHAR,
"releases_0_tender_documents_1_id" DOUBLE,
"releases_0_tender_documents_1_documenttype" VARCHAR,
"releases_0_tender_documents_1_description" VARCHAR,
"releases_0_tender_documents_1_url" VARCHAR,
"releases_0_parties_0_id" VARCHAR,
"releases_0_parties_0_name" VARCHAR,
"releases_0_parties_0_identifier_legalname" VARCHAR,
"releases_0_parties_0_address_streetaddress" VARCHAR,
"releases_0_parties_0_address_locality" VARCHAR,
"releases_0_parties_0_address_postalcode" VARCHAR,
"releases_0_parties_0_address_countryname" VARCHAR,
"releases_0_parties_0_contactpoint_email" VARCHAR,
"releases_0_parties_0_contactpoint_telephone" 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_parties_2_id" VARCHAR,
"releases_0_parties_2_name" VARCHAR,
"releases_0_parties_2_identifier_legalname" VARCHAR,
"releases_0_parties_2_address_streetaddress" VARCHAR,
"releases_0_parties_2_details_scale" VARCHAR,
"releases_0_parties_2_details_vcse" VARCHAR,
"releases_0_parties_2_roles_0" VARCHAR,
"releases_0_parties_3_id" VARCHAR,
"releases_0_parties_3_name" VARCHAR,
"releases_0_parties_3_identifier_legalname" VARCHAR,
"releases_0_parties_3_address_streetaddress" VARCHAR,
"releases_0_parties_3_details_scale" VARCHAR,
"releases_0_parties_3_details_vcse" VARCHAR,
"releases_0_parties_3_roles_0" VARCHAR,
"releases_0_parties_4_id" VARCHAR,
"releases_0_parties_4_name" VARCHAR
);
Contracts Finder OCDS 2019-03-14
@ukgov.contracts_finder_notices_03_20192_1.contracts_finder_ocds_2019_03_14
- 445.55 KB
- 193 rows
- 277 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_03_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_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_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_datepublished" TIMESTAMP,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_classification_scheme" VARCHAR,
"releases_0_tender_classification_id" DOUBLE,
"releases_0_tender_classification_description" VARCHAR,
"releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_0_id" VARCHAR,
"releases_0_tender_additionalclassifications_0_description" VARCHAR,
"releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_1_id" DOUBLE,
"releases_0_tender_additionalclassifications_1_description" VARCHAR,
"releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_2_id" VARCHAR,
"releases_0_tender_additionalclassifications_2_description" VARCHAR,
"releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_3_id" DOUBLE,
"releases_0_tender_additionalclassifications_3_description" VARCHAR,
"releases_0_tender_additionalclassifications_4_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_4_id" DOUBLE,
"releases_0_tender_additionalclassifications_4_description" VARCHAR,
"releases_0_tender_additionalclassifications_5_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_5_id" DOUBLE,
"releases_0_tender_additionalclassifications_5_description" VARCHAR,
"releases_0_tender_additionalclassifications_6_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_6_id" DOUBLE,
"releases_0_tender_additionalclassifications_6_description" VARCHAR,
"releases_0_tender_additionalclassifications_7_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_7_id" DOUBLE,
"releases_0_tender_additionalclassifications_7_description" VARCHAR,
"releases_0_tender_additionalclassifications_8_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_8_id" DOUBLE,
"releases_0_tender_additionalclassifications_8_description" VARCHAR,
"releases_0_tender_additionalclassifications_9_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_9_id" DOUBLE,
"releases_0_tender_additionalclassifications_9_description" VARCHAR,
"releases_0_tender_additionalclassifications_10_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_10_id" VARCHAR,
"releases_0_tender_additionalclassifications_10_description" VARCHAR,
"releases_0_tender_additionalclassifications_11_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_11_id" DOUBLE,
"releases_0_tender_additionalclassifications_11_description" VARCHAR,
"releases_0_tender_additionalclassifications_12_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_12_id" DOUBLE,
"releases_0_tender_additionalclassifications_12_description" VARCHAR,
"releases_0_tender_additionalclassifications_13_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_13_id" DOUBLE,
"releases_0_tender_additionalclassifications_13_description" VARCHAR,
"releases_0_tender_additionalclassifications_14_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_14_id" DOUBLE,
"releases_0_tender_additionalclassifications_14_description" VARCHAR,
"releases_0_tender_items_0_id" DOUBLE,
"releases_0_tender_items_0_deliveryaddresses_0_postalcode" VARCHAR
);
Contracts Finder OCDS 2019-03-18
@ukgov.contracts_finder_notices_03_20192_1.contracts_finder_ocds_2019_03_18
- 590.49 KB
- 219 rows
- 407 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_03_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_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_budget_budgetbreakdown_1_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_1_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_1_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_1_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_1_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_1_amount_currency" VARCHAR,
"releases_0_planning_documents_0_id" DOUBLE,
"releases_0_planning_documents_0_documenttype" VARCHAR,
"releases_0_planning_documents_0_description" VARCHAR,
"releases_0_planning_documents_0_url" VARCHAR,
"releases_0_planning_documents_0_datepublished" TIMESTAMP,
"releases_0_planning_documents_0_format" VARCHAR,
"releases_0_planning_documents_0_language" VARCHAR,
"releases_0_planning_documents_1_id" DOUBLE,
"releases_0_planning_documents_1_documenttype" VARCHAR,
"releases_0_planning_documents_1_description" VARCHAR,
"releases_0_planning_documents_1_url" VARCHAR,
"releases_0_planning_documents_1_format" VARCHAR,
"releases_0_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_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
);
Contracts Finder OCDS 2019-03-02
@ukgov.contracts_finder_notices_03_20192_1.contracts_finder_ocds_2019_03_02
- 231.69 KB
- 12 rows
- 241 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_03_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" 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_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_2_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_3_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_4_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_5_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_6_countryname" VARCHAR,
"releases_0_tender_minvalue_amount" DOUBLE,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" DOUBLE,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_contractperiod_startdate" TIMESTAMP,
"releases_0_tender_contractperiod_enddate" TIMESTAMP,
"releases_0_tender_suitability_sme" DOUBLE,
"releases_0_tender_suitability_vcse" DOUBLE,
"releases_0_tender_mainprocurementcategory" VARCHAR,
"releases_0_tender_documents_0_id" DOUBLE,
"releases_0_tender_documents_0_documenttype" VARCHAR,
"releases_0_tender_documents_0_description" VARCHAR,
"releases_0_tender_documents_0_url" VARCHAR,
"releases_0_tender_documents_0_datepublished" TIMESTAMP,
"releases_0_tender_documents_0_format" VARCHAR,
"releases_0_tender_documents_0_language" VARCHAR,
"releases_0_tender_documents_1_id" DOUBLE,
"releases_0_tender_documents_1_documenttype" VARCHAR,
"releases_0_tender_documents_1_description" VARCHAR,
"releases_0_tender_documents_1_url" VARCHAR,
"releases_0_parties_0_id" VARCHAR,
"releases_0_parties_0_name" VARCHAR,
"releases_0_parties_0_identifier_legalname" VARCHAR,
"releases_0_parties_0_address_streetaddress" VARCHAR,
"releases_0_parties_0_address_locality" VARCHAR,
"releases_0_parties_0_address_postalcode" VARCHAR,
"releases_0_parties_0_address_countryname" VARCHAR,
"releases_0_parties_0_contactpoint_name" VARCHAR,
"releases_0_parties_0_contactpoint_email" VARCHAR,
"releases_0_parties_0_contactpoint_telephone" VARCHAR,
"releases_0_parties_0_details_url" VARCHAR,
"releases_0_parties_0_roles_0" VARCHAR,
"releases_0_parties_1_id" VARCHAR
);
Contracts Finder OCDS 2019-03-05
@ukgov.contracts_finder_notices_03_20192_1.contracts_finder_ocds_2019_03_05
- 483.46 KB
- 212 rows
- 313 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_03_05 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"extensions_0" VARCHAR,
"extensions_1" VARCHAR,
"extensions_2" VARCHAR,
"extensions_3" VARCHAR,
"extensions_4" VARCHAR,
"extensions_5" VARCHAR,
"extensions_6" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_planning_milestones_0_id" DOUBLE,
"releases_0_planning_milestones_0_title" VARCHAR,
"releases_0_planning_milestones_0_type" VARCHAR,
"releases_0_planning_milestones_0_duedate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_0_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_0_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_0_amount_currency" VARCHAR,
"releases_0_planning_documents_0_id" DOUBLE,
"releases_0_planning_documents_0_documenttype" VARCHAR,
"releases_0_planning_documents_0_description" VARCHAR,
"releases_0_planning_documents_0_url" VARCHAR,
"releases_0_planning_documents_0_datepublished" TIMESTAMP,
"releases_0_planning_documents_0_format" VARCHAR,
"releases_0_planning_documents_0_language" VARCHAR,
"releases_0_planning_documents_1_id" DOUBLE,
"releases_0_planning_documents_1_documenttype" VARCHAR,
"releases_0_planning_documents_1_description" VARCHAR,
"releases_0_planning_documents_1_url" VARCHAR,
"releases_0_planning_documents_1_format" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_datepublished" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_classification_scheme" VARCHAR,
"releases_0_tender_classification_id" VARCHAR,
"releases_0_tender_classification_description" VARCHAR,
"releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_0_id" DOUBLE,
"releases_0_tender_additionalclassifications_0_description" VARCHAR,
"releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_1_id" VARCHAR,
"releases_0_tender_additionalclassifications_1_description" VARCHAR,
"releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_2_id" DOUBLE,
"releases_0_tender_additionalclassifications_2_description" VARCHAR,
"releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_3_id" VARCHAR,
"releases_0_tender_additionalclassifications_3_description" VARCHAR,
"releases_0_tender_additionalclassifications_4_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_4_id" DOUBLE,
"releases_0_tender_additionalclassifications_4_description" VARCHAR,
"releases_0_tender_additionalclassifications_5_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_5_id" DOUBLE,
"releases_0_tender_additionalclassifications_5_description" VARCHAR,
"releases_0_tender_additionalclassifications_6_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_6_id" DOUBLE,
"releases_0_tender_additionalclassifications_6_description" VARCHAR,
"releases_0_tender_additionalclassifications_7_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_7_id" VARCHAR,
"releases_0_tender_additionalclassifications_7_description" VARCHAR,
"releases_0_tender_additionalclassifications_8_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_8_id" VARCHAR,
"releases_0_tender_additionalclassifications_8_description" VARCHAR,
"releases_0_tender_additionalclassifications_9_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_9_id" DOUBLE,
"releases_0_tender_additionalclassifications_9_description" VARCHAR,
"releases_0_tender_additionalclassifications_10_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_10_id" VARCHAR,
"releases_0_tender_additionalclassifications_10_description" VARCHAR,
"releases_0_tender_additionalclassifications_11_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_11_id" VARCHAR,
"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" VARCHAR,
"releases_0_tender_additionalclassifications_13_description" VARCHAR,
"releases_0_tender_items_0_id" DOUBLE,
"releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_0_postalcode" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_1_region" VARCHAR
);
Contracts Finder OCDS 2019-03-19
@ukgov.contracts_finder_notices_03_20192_1.contracts_finder_ocds_2019_03_19
- 715.91 KB
- 189 rows
- 574 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_03_19 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"extensions_0" VARCHAR,
"extensions_1" VARCHAR,
"extensions_2" VARCHAR,
"extensions_3" VARCHAR,
"extensions_4" VARCHAR,
"extensions_5" VARCHAR,
"extensions_6" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_0_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_0_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_0_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_0_amount_currency" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_1_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_1_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_1_period_enddate" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_1_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_1_amount_amount" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_1_amount_currency" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_2_id" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_2_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_2_period_enddate" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_2_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_2_amount_amount" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_2_amount_currency" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_3_id" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_3_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_3_period_enddate" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_3_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_3_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_3_amount_currency" VARCHAR,
"releases_0_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" VARCHAR,
"releases_0_planning_documents_1_documenttype" VARCHAR,
"releases_0_planning_documents_1_description" VARCHAR,
"releases_0_planning_documents_1_url" VARCHAR,
"releases_0_planning_documents_1_format" VARCHAR,
"releases_0_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" DOUBLE,
"releases_0_tender_classification_description" VARCHAR,
"releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_0_id" DOUBLE,
"releases_0_tender_additionalclassifications_0_description" VARCHAR,
"releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_1_id" DOUBLE,
"releases_0_tender_additionalclassifications_1_description" VARCHAR,
"releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_2_id" VARCHAR,
"releases_0_tender_additionalclassifications_2_description" VARCHAR,
"releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_3_id" DOUBLE,
"releases_0_tender_additionalclassifications_3_description" VARCHAR,
"releases_0_tender_additionalclassifications_4_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_4_id" VARCHAR,
"releases_0_tender_additionalclassifications_4_description" VARCHAR,
"releases_0_tender_additionalclassifications_5_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_5_id" VARCHAR,
"releases_0_tender_additionalclassifications_5_description" VARCHAR,
"releases_0_tender_additionalclassifications_6_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_6_id" VARCHAR,
"releases_0_tender_additionalclassifications_6_description" VARCHAR,
"releases_0_tender_items_0_id" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR
);
Contracts Finder OCDS 2019-03-31
@ukgov.contracts_finder_notices_03_20192_1.contracts_finder_ocds_2019_03_31
- 144.05 KB
- 13 rows
- 142 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_03_31 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"extensions_1" VARCHAR,
"extensions_2" VARCHAR,
"extensions_3" VARCHAR,
"extensions_4" VARCHAR,
"extensions_5" VARCHAR,
"extensions_6" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_datepublished" TIMESTAMP,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_classification_scheme" VARCHAR,
"releases_0_tender_classification_id" BIGINT,
"releases_0_tender_classification_description" VARCHAR,
"releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_0_id" DOUBLE,
"releases_0_tender_additionalclassifications_0_description" VARCHAR,
"releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_1_id" DOUBLE,
"releases_0_tender_additionalclassifications_1_description" VARCHAR,
"releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_2_id" DOUBLE,
"releases_0_tender_additionalclassifications_2_description" VARCHAR,
"releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_3_id" DOUBLE,
"releases_0_tender_additionalclassifications_3_description" VARCHAR,
"releases_0_tender_additionalclassifications_4_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_4_id" DOUBLE,
"releases_0_tender_additionalclassifications_4_description" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_0_postalcode" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_2_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_3_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_4_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_5_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_6_countryname" VARCHAR,
"releases_0_tender_minvalue_amount" DOUBLE,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" DOUBLE,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_contractperiod_startdate" TIMESTAMP,
"releases_0_tender_contractperiod_enddate" TIMESTAMP,
"releases_0_tender_suitability_sme" DOUBLE,
"releases_0_tender_suitability_vcse" VARCHAR,
"releases_0_tender_mainprocurementcategory" VARCHAR,
"releases_0_tender_documents_0_id" DOUBLE,
"releases_0_tender_documents_0_documenttype" VARCHAR,
"releases_0_tender_documents_0_description" VARCHAR,
"releases_0_tender_documents_0_url" VARCHAR,
"releases_0_tender_documents_0_datepublished" TIMESTAMP,
"releases_0_tender_documents_0_format" VARCHAR,
"releases_0_tender_documents_0_language" VARCHAR,
"releases_0_tender_documents_1_id" DOUBLE,
"releases_0_tender_documents_1_documenttype" VARCHAR,
"releases_0_tender_documents_1_description" VARCHAR,
"releases_0_tender_documents_1_url" VARCHAR,
"releases_0_parties_0_id" VARCHAR,
"releases_0_parties_0_name" VARCHAR,
"releases_0_parties_0_identifier_legalname" VARCHAR,
"releases_0_parties_0_address_streetaddress" VARCHAR,
"releases_0_parties_0_address_locality" VARCHAR,
"releases_0_parties_0_address_postalcode" VARCHAR,
"releases_0_parties_0_address_countryname" VARCHAR,
"releases_0_parties_0_contactpoint_name" VARCHAR,
"releases_0_parties_0_contactpoint_email" VARCHAR,
"releases_0_parties_0_contactpoint_telephone" VARCHAR,
"releases_0_parties_0_details_url" VARCHAR,
"releases_0_parties_0_roles_0" VARCHAR,
"releases_0_parties_1_id" VARCHAR,
"releases_0_parties_1_name" VARCHAR,
"releases_0_parties_1_identifier_legalname" VARCHAR,
"releases_0_parties_1_address_streetaddress" VARCHAR,
"releases_0_parties_1_details_scale" VARCHAR,
"releases_0_parties_1_details_vcse" VARCHAR,
"releases_0_parties_1_roles_0" VARCHAR,
"releases_0_parties_2_id" VARCHAR,
"releases_0_parties_2_name" VARCHAR,
"releases_0_parties_2_identifier_legalname" VARCHAR
);
Contracts Finder OCDS 2019-03-06
@ukgov.contracts_finder_notices_03_20192_1.contracts_finder_ocds_2019_03_06
- 874.77 KB
- 244 rows
- 712 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_03_06 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"extensions_1" VARCHAR,
"extensions_2" VARCHAR,
"extensions_3" VARCHAR,
"extensions_4" VARCHAR,
"extensions_5" VARCHAR,
"extensions_6" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_planning_milestones_0_id" DOUBLE,
"releases_0_planning_milestones_0_title" VARCHAR,
"releases_0_planning_milestones_0_type" VARCHAR,
"releases_0_planning_milestones_0_duedate" TIMESTAMP,
"releases_0_planning_documents_0_id" DOUBLE,
"releases_0_planning_documents_0_documenttype" VARCHAR,
"releases_0_planning_documents_0_description" VARCHAR,
"releases_0_planning_documents_0_url" VARCHAR,
"releases_0_planning_documents_0_datepublished" TIMESTAMP,
"releases_0_planning_documents_0_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,
"releases_0_tender_additionalclassifications_16_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_16_id" DOUBLE,
"releases_0_tender_additionalclassifications_16_description" VARCHAR,
"releases_0_tender_additionalclassifications_17_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_17_id" DOUBLE,
"releases_0_tender_additionalclassifications_17_description" VARCHAR
);
Contracts Finder OCDS 2019-03-01
@ukgov.contracts_finder_notices_03_20192_1.contracts_finder_ocds_2019_03_01
- 641.89 KB
- 248 rows
- 442 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_03_01 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"extensions_1" VARCHAR,
"extensions_2" VARCHAR,
"extensions_3" VARCHAR,
"extensions_4" VARCHAR,
"extensions_5" VARCHAR,
"extensions_6" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_planning_milestones_0_id" DOUBLE,
"releases_0_planning_milestones_0_title" VARCHAR,
"releases_0_planning_milestones_0_type" VARCHAR,
"releases_0_planning_milestones_0_duedate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_0_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_0_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_0_amount_currency" VARCHAR,
"releases_0_planning_documents_0_id" DOUBLE,
"releases_0_planning_documents_0_documenttype" VARCHAR,
"releases_0_planning_documents_0_description" VARCHAR,
"releases_0_planning_documents_0_url" VARCHAR,
"releases_0_planning_documents_0_datepublished" TIMESTAMP,
"releases_0_planning_documents_0_format" VARCHAR,
"releases_0_planning_documents_0_language" VARCHAR,
"releases_0_planning_documents_1_id" DOUBLE,
"releases_0_planning_documents_1_documenttype" VARCHAR,
"releases_0_planning_documents_1_description" VARCHAR,
"releases_0_planning_documents_1_url" VARCHAR,
"releases_0_planning_documents_1_format" VARCHAR,
"releases_0_planning_documents_2_id" DOUBLE,
"releases_0_planning_documents_2_documenttype" VARCHAR,
"releases_0_planning_documents_2_description" VARCHAR,
"releases_0_planning_documents_2_url" VARCHAR,
"releases_0_planning_documents_2_format" VARCHAR,
"releases_0_planning_documents_3_id" DOUBLE,
"releases_0_planning_documents_3_documenttype" VARCHAR,
"releases_0_planning_documents_3_url" VARCHAR,
"releases_0_planning_documents_4_id" DOUBLE,
"releases_0_planning_documents_4_documenttype" VARCHAR,
"releases_0_planning_documents_4_url" VARCHAR,
"releases_0_planning_documents_5_id" DOUBLE,
"releases_0_planning_documents_5_documenttype" VARCHAR,
"releases_0_planning_documents_5_url" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_datepublished" TIMESTAMP,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_classification_scheme" VARCHAR,
"releases_0_tender_classification_id" 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
);
Contracts Finder OCDS 2019-03-07
@ukgov.contracts_finder_notices_03_20192_1.contracts_finder_ocds_2019_03_07
- 699.33 KB
- 164 rows
- 577 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_03_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_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_budget_budgetbreakdown_1_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_1_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_1_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_1_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_1_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_1_amount_currency" VARCHAR,
"releases_0_planning_documents_0_id" DOUBLE,
"releases_0_planning_documents_0_documenttype" VARCHAR,
"releases_0_planning_documents_0_description" VARCHAR,
"releases_0_planning_documents_0_url" VARCHAR,
"releases_0_planning_documents_0_datepublished" TIMESTAMP,
"releases_0_planning_documents_0_format" VARCHAR,
"releases_0_planning_documents_0_language" VARCHAR,
"releases_0_planning_documents_1_id" DOUBLE,
"releases_0_planning_documents_1_documenttype" VARCHAR,
"releases_0_planning_documents_1_description" VARCHAR,
"releases_0_planning_documents_1_url" VARCHAR,
"releases_0_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_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
);
Contracts Finder OCDS 2019-03-08
@ukgov.contracts_finder_notices_03_20192_1.contracts_finder_ocds_2019_03_08
- 841.31 KB
- 194 rows
- 699 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_03_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 2019-03-09
@ukgov.contracts_finder_notices_03_20192_1.contracts_finder_ocds_2019_03_09
- 146.43 KB
- 17 rows
- 138 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_03_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_minvalue_amount" DOUBLE,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" DOUBLE,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_2_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_3_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_4_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_5_countryname" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_contractperiod_startdate" TIMESTAMP,
"releases_0_tender_contractperiod_enddate" TIMESTAMP,
"releases_0_tender_suitability_sme" DOUBLE,
"releases_0_tender_suitability_vcse" DOUBLE,
"releases_0_tender_mainprocurementcategory" VARCHAR,
"releases_0_tender_documents_0_id" DOUBLE,
"releases_0_tender_documents_0_documenttype" VARCHAR,
"releases_0_tender_documents_0_description" VARCHAR,
"releases_0_tender_documents_0_url" VARCHAR,
"releases_0_tender_documents_0_datepublished" TIMESTAMP,
"releases_0_tender_documents_0_format" VARCHAR,
"releases_0_tender_documents_0_language" VARCHAR,
"releases_0_tender_documents_1_id" DOUBLE,
"releases_0_tender_documents_1_documenttype" VARCHAR,
"releases_0_tender_documents_1_description" VARCHAR,
"releases_0_tender_documents_1_url" VARCHAR,
"releases_0_tender_documents_2_id" DOUBLE,
"releases_0_tender_documents_2_documenttype" VARCHAR,
"releases_0_tender_documents_2_description" VARCHAR,
"releases_0_tender_documents_2_url" VARCHAR,
"releases_0_parties_0_id" VARCHAR,
"releases_0_parties_0_name" VARCHAR,
"releases_0_parties_0_identifier_legalname" VARCHAR,
"releases_0_parties_0_address_streetaddress" VARCHAR,
"releases_0_parties_0_address_locality" VARCHAR,
"releases_0_parties_0_address_postalcode" VARCHAR,
"releases_0_parties_0_address_countryname" VARCHAR,
"releases_0_parties_0_contactpoint_name" VARCHAR,
"releases_0_parties_0_contactpoint_email" VARCHAR,
"releases_0_parties_0_contactpoint_telephone" VARCHAR,
"releases_0_parties_0_details_url" VARCHAR,
"releases_0_parties_0_roles_0" VARCHAR,
"releases_0_parties_1_id" VARCHAR,
"releases_0_parties_1_name" VARCHAR,
"releases_0_parties_1_identifier_legalname" VARCHAR,
"releases_0_parties_1_address_streetaddress" VARCHAR,
"releases_0_parties_1_details_scale" VARCHAR,
"releases_0_parties_1_details_vcse" VARCHAR,
"releases_0_parties_1_roles_0" VARCHAR,
"releases_0_parties_2_id" VARCHAR,
"releases_0_parties_2_name" VARCHAR,
"releases_0_parties_2_identifier_legalname" VARCHAR,
"releases_0_parties_2_address_streetaddress" VARCHAR,
"releases_0_parties_2_details_scale" VARCHAR,
"releases_0_parties_2_details_vcse" VARCHAR,
"releases_0_parties_2_roles_0" VARCHAR
);
Contracts Finder OCDS 2019-03-29
@ukgov.contracts_finder_notices_03_20192_1.contracts_finder_ocds_2019_03_29
- 1.08 MB
- 195 rows
- 991 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_03_29 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"extensions_0" VARCHAR,
"extensions_1" VARCHAR,
"extensions_2" VARCHAR,
"extensions_3" VARCHAR,
"extensions_4" VARCHAR,
"extensions_5" VARCHAR,
"extensions_6" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_planning_milestones_0_id" DOUBLE,
"releases_0_planning_milestones_0_title" VARCHAR,
"releases_0_planning_milestones_0_type" VARCHAR,
"releases_0_planning_milestones_0_duedate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_0_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_0_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_0_amount_currency" VARCHAR,
"releases_0_planning_documents_0_id" DOUBLE,
"releases_0_planning_documents_0_documenttype" VARCHAR,
"releases_0_planning_documents_0_description" VARCHAR,
"releases_0_planning_documents_0_url" VARCHAR,
"releases_0_planning_documents_0_datepublished" TIMESTAMP,
"releases_0_planning_documents_0_format" VARCHAR,
"releases_0_planning_documents_0_language" VARCHAR,
"releases_0_planning_documents_1_id" DOUBLE,
"releases_0_planning_documents_1_documenttype" VARCHAR,
"releases_0_planning_documents_1_description" VARCHAR,
"releases_0_planning_documents_1_url" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_datepublished" TIMESTAMP,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_classification_scheme" VARCHAR,
"releases_0_tender_classification_id" DOUBLE,
"releases_0_tender_classification_description" VARCHAR,
"releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_0_id" DOUBLE,
"releases_0_tender_additionalclassifications_0_description" VARCHAR,
"releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_1_id" DOUBLE,
"releases_0_tender_additionalclassifications_1_description" VARCHAR,
"releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_2_id" DOUBLE,
"releases_0_tender_additionalclassifications_2_description" VARCHAR,
"releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_3_id" DOUBLE,
"releases_0_tender_additionalclassifications_3_description" VARCHAR,
"releases_0_tender_additionalclassifications_4_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_4_id" VARCHAR,
"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 2019-03-15
@ukgov.contracts_finder_notices_03_20192_1.contracts_finder_ocds_2019_03_15
- 792.28 KB
- 222 rows
- 603 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_03_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_items_0_id" BIGINT,
"releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_0_postalcode" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_1_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_2_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_2_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_3_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_3_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_4_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_4_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_5_region" VARCHAR
);
Contracts Finder OCDS 2019-03-22
@ukgov.contracts_finder_notices_03_20192_1.contracts_finder_ocds_2019_03_22
- 1.56 MB
- 209 rows
- 1447 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_03_22 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"extensions_0" VARCHAR,
"extensions_1" VARCHAR,
"extensions_2" VARCHAR,
"extensions_3" VARCHAR,
"extensions_4" VARCHAR,
"extensions_5" VARCHAR,
"extensions_6" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_planning_milestones_0_id" DOUBLE,
"releases_0_planning_milestones_0_title" VARCHAR,
"releases_0_planning_milestones_0_type" VARCHAR,
"releases_0_planning_milestones_0_duedate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_0_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_0_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_0_amount_currency" VARCHAR,
"releases_0_planning_documents_0_id" DOUBLE,
"releases_0_planning_documents_0_documenttype" VARCHAR,
"releases_0_planning_documents_0_description" VARCHAR,
"releases_0_planning_documents_0_url" VARCHAR,
"releases_0_planning_documents_0_datepublished" TIMESTAMP,
"releases_0_planning_documents_0_format" VARCHAR,
"releases_0_planning_documents_0_language" VARCHAR,
"releases_0_planning_documents_1_id" DOUBLE,
"releases_0_planning_documents_1_documenttype" VARCHAR,
"releases_0_planning_documents_1_description" VARCHAR,
"releases_0_planning_documents_1_url" VARCHAR,
"releases_0_planning_documents_1_format" VARCHAR,
"releases_0_planning_documents_2_id" DOUBLE,
"releases_0_planning_documents_2_documenttype" VARCHAR,
"releases_0_planning_documents_2_description" VARCHAR,
"releases_0_planning_documents_2_url" VARCHAR,
"releases_0_planning_documents_2_format" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_datepublished" TIMESTAMP,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_classification_scheme" VARCHAR,
"releases_0_tender_classification_id" DOUBLE,
"releases_0_tender_classification_description" VARCHAR,
"releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_0_id" DOUBLE,
"releases_0_tender_additionalclassifications_0_description" VARCHAR,
"releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_1_id" DOUBLE,
"releases_0_tender_additionalclassifications_1_description" VARCHAR,
"releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_2_id" DOUBLE,
"releases_0_tender_additionalclassifications_2_description" VARCHAR,
"releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_3_id" DOUBLE,
"releases_0_tender_additionalclassifications_3_description" VARCHAR,
"releases_0_tender_additionalclassifications_4_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_4_id" DOUBLE,
"releases_0_tender_additionalclassifications_4_description" VARCHAR,
"releases_0_tender_additionalclassifications_5_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_5_id" DOUBLE,
"releases_0_tender_additionalclassifications_5_description" VARCHAR,
"releases_0_tender_additionalclassifications_6_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_6_id" DOUBLE,
"releases_0_tender_additionalclassifications_6_description" VARCHAR,
"releases_0_tender_additionalclassifications_7_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_7_id" VARCHAR,
"releases_0_tender_additionalclassifications_7_description" VARCHAR,
"releases_0_tender_additionalclassifications_8_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_8_id" DOUBLE,
"releases_0_tender_additionalclassifications_8_description" VARCHAR,
"releases_0_tender_additionalclassifications_9_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_9_id" VARCHAR,
"releases_0_tender_additionalclassifications_9_description" VARCHAR,
"releases_0_tender_additionalclassifications_10_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_10_id" 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 2019-03-23
@ukgov.contracts_finder_notices_03_20192_1.contracts_finder_ocds_2019_03_23
- 130.17 KB
- 11 rows
- 131 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_03_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_items_0_id" BIGINT,
"releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_0_postalcode" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_2_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_3_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_4_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_5_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_6_countryname" VARCHAR,
"releases_0_tender_minvalue_amount" DOUBLE,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" DOUBLE,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_contractperiod_startdate" TIMESTAMP,
"releases_0_tender_contractperiod_enddate" TIMESTAMP,
"releases_0_tender_suitability_sme" DOUBLE,
"releases_0_tender_suitability_vcse" DOUBLE,
"releases_0_tender_mainprocurementcategory" VARCHAR,
"releases_0_tender_documents_0_id" DOUBLE,
"releases_0_tender_documents_0_documenttype" VARCHAR,
"releases_0_tender_documents_0_description" VARCHAR,
"releases_0_tender_documents_0_url" VARCHAR,
"releases_0_tender_documents_0_datepublished" TIMESTAMP,
"releases_0_tender_documents_0_datemodified" TIMESTAMP,
"releases_0_tender_documents_0_format" VARCHAR,
"releases_0_tender_documents_0_language" VARCHAR,
"releases_0_tender_documents_1_id" DOUBLE,
"releases_0_tender_documents_1_documenttype" VARCHAR,
"releases_0_tender_documents_1_description" VARCHAR,
"releases_0_tender_documents_1_url" VARCHAR,
"releases_0_tender_documents_1_format" VARCHAR,
"releases_0_tender_documents_2_id" DOUBLE,
"releases_0_tender_documents_2_documenttype" VARCHAR,
"releases_0_tender_documents_2_description" VARCHAR,
"releases_0_tender_documents_2_url" VARCHAR,
"releases_0_parties_0_id" VARCHAR,
"releases_0_parties_0_name" VARCHAR,
"releases_0_parties_0_identifier_legalname" VARCHAR,
"releases_0_parties_0_address_streetaddress" VARCHAR,
"releases_0_parties_0_address_locality" VARCHAR,
"releases_0_parties_0_address_postalcode" VARCHAR,
"releases_0_parties_0_address_countryname" VARCHAR,
"releases_0_parties_0_contactpoint_name" VARCHAR,
"releases_0_parties_0_contactpoint_email" VARCHAR,
"releases_0_parties_0_contactpoint_telephone" VARCHAR,
"releases_0_parties_0_roles_0" VARCHAR,
"releases_0_parties_1_id" VARCHAR,
"releases_0_parties_1_name" VARCHAR,
"releases_0_parties_1_identifier_legalname" VARCHAR,
"releases_0_parties_1_address_streetaddress" VARCHAR,
"releases_0_parties_1_details_scale" VARCHAR,
"releases_0_parties_1_details_vcse" VARCHAR,
"releases_0_parties_1_roles_0" VARCHAR,
"releases_0_parties_2_id" VARCHAR,
"releases_0_parties_2_name" VARCHAR,
"releases_0_parties_2_identifier_legalname" VARCHAR,
"releases_0_parties_2_address_streetaddress" VARCHAR,
"releases_0_parties_2_details_scale" VARCHAR,
"releases_0_parties_2_details_vcse" VARCHAR,
"releases_0_parties_2_roles_0" VARCHAR,
"releases_0_parties_3_id" VARCHAR,
"releases_0_parties_3_name" VARCHAR,
"releases_0_parties_3_identifier_legalname" VARCHAR
);
Contracts Finder OCDS 2019-03-24
@ukgov.contracts_finder_notices_03_20192_1.contracts_finder_ocds_2019_03_24
- 134.67 KB
- 11 rows
- 128 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_03_24 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"extensions_1" VARCHAR,
"extensions_2" VARCHAR,
"extensions_3" VARCHAR,
"extensions_4" VARCHAR,
"extensions_5" VARCHAR,
"extensions_6" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_datepublished" TIMESTAMP,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_classification_scheme" VARCHAR,
"releases_0_tender_classification_id" BIGINT,
"releases_0_tender_classification_description" VARCHAR,
"releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_0_id" DOUBLE,
"releases_0_tender_additionalclassifications_0_description" VARCHAR,
"releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_1_id" DOUBLE,
"releases_0_tender_additionalclassifications_1_description" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_0_postalcode" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_2_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_3_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_4_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_5_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_6_countryname" VARCHAR,
"releases_0_tender_minvalue_amount" DOUBLE,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" DOUBLE,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_contractperiod_startdate" TIMESTAMP,
"releases_0_tender_contractperiod_enddate" TIMESTAMP,
"releases_0_tender_suitability_sme" DOUBLE,
"releases_0_tender_suitability_vcse" 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_tender_documents_2_id" DOUBLE,
"releases_0_tender_documents_2_documenttype" VARCHAR,
"releases_0_tender_documents_2_description" VARCHAR,
"releases_0_tender_documents_2_url" VARCHAR,
"releases_0_parties_0_id" VARCHAR,
"releases_0_parties_0_name" VARCHAR,
"releases_0_parties_0_identifier_legalname" VARCHAR,
"releases_0_parties_0_address_streetaddress" VARCHAR,
"releases_0_parties_0_address_locality" VARCHAR,
"releases_0_parties_0_address_postalcode" VARCHAR,
"releases_0_parties_0_address_countryname" VARCHAR,
"releases_0_parties_0_contactpoint_name" VARCHAR,
"releases_0_parties_0_contactpoint_email" VARCHAR,
"releases_0_parties_0_contactpoint_telephone" VARCHAR,
"releases_0_parties_0_details_url" VARCHAR,
"releases_0_parties_0_roles_0" VARCHAR,
"releases_0_parties_1_id" VARCHAR,
"releases_0_parties_1_name" VARCHAR,
"releases_0_parties_1_identifier_legalname" VARCHAR,
"releases_0_parties_1_address_streetaddress" VARCHAR,
"releases_0_parties_1_details_scale" VARCHAR,
"releases_0_parties_1_details_vcse" VARCHAR,
"releases_0_parties_1_roles_0" VARCHAR,
"releases_0_parties_2_id" VARCHAR,
"releases_0_parties_2_name" VARCHAR,
"releases_0_parties_2_identifier_legalname" VARCHAR,
"releases_0_parties_2_address_streetaddress" VARCHAR,
"releases_0_parties_2_details_scale" VARCHAR,
"releases_0_parties_2_details_vcse" VARCHAR,
"releases_0_parties_2_roles_0" VARCHAR,
"releases_0_buyer_id" VARCHAR
);
Contracts Finder OCDS 2019-03-26
@ukgov.contracts_finder_notices_03_20192_1.contracts_finder_ocds_2019_03_26
- 473.56 KB
- 232 rows
- 318 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_03_26 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"extensions_0" VARCHAR,
"extensions_1" VARCHAR,
"extensions_2" VARCHAR,
"extensions_3" VARCHAR,
"extensions_4" VARCHAR,
"extensions_5" VARCHAR,
"extensions_6" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" VARCHAR,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_planning_milestones_0_id" VARCHAR,
"releases_0_planning_milestones_0_title" VARCHAR,
"releases_0_planning_milestones_0_type" VARCHAR,
"releases_0_planning_milestones_0_duedate" VARCHAR,
"releases_0_planning_documents_0_id" DOUBLE,
"releases_0_planning_documents_0_documenttype" VARCHAR,
"releases_0_planning_documents_0_description" VARCHAR,
"releases_0_planning_documents_0_url" VARCHAR,
"releases_0_planning_documents_0_datepublished" TIMESTAMP,
"releases_0_planning_documents_0_format" VARCHAR,
"releases_0_planning_documents_0_language" VARCHAR,
"releases_0_planning_documents_1_id" DOUBLE,
"releases_0_planning_documents_1_documenttype" VARCHAR,
"releases_0_planning_documents_1_description" VARCHAR,
"releases_0_planning_documents_1_url" VARCHAR,
"releases_0_planning_documents_1_format" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_datepublished" TIMESTAMP,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_classification_scheme" VARCHAR,
"releases_0_tender_classification_id" DOUBLE,
"releases_0_tender_classification_description" VARCHAR,
"releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_0_id" 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" VARCHAR,
"releases_0_tender_additionalclassifications_7_description" VARCHAR,
"releases_0_tender_additionalclassifications_8_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_8_id" VARCHAR,
"releases_0_tender_additionalclassifications_8_description" VARCHAR,
"releases_0_tender_additionalclassifications_9_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_9_id" VARCHAR,
"releases_0_tender_additionalclassifications_9_description" VARCHAR,
"releases_0_tender_items_0_id" DOUBLE,
"releases_0_tender_items_0_deliveryaddresses_0_postalcode" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_1_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_2_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_2_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_3_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_3_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_4_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_4_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_5_region" VARCHAR,
"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
);
Contracts Finder OCDS 2019-03-28
@ukgov.contracts_finder_notices_03_20192_1.contracts_finder_ocds_2019_03_28
- 627.02 KB
- 240 rows
- 442 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_03_28 (
"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_items_0_id" BIGINT,
"releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_0_postalcode" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_1_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_2_region" VARCHAR
);
Contracts Finder OCDS 2019-03-11
@ukgov.contracts_finder_notices_03_20192_1.contracts_finder_ocds_2019_03_11
- 630.68 KB
- 217 rows
- 442 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_03_11 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"extensions_1" VARCHAR,
"extensions_2" VARCHAR,
"extensions_3" VARCHAR,
"extensions_4" VARCHAR,
"extensions_5" VARCHAR,
"extensions_6" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_planning_milestones_0_id" DOUBLE,
"releases_0_planning_milestones_0_title" VARCHAR,
"releases_0_planning_milestones_0_type" VARCHAR,
"releases_0_planning_milestones_0_duedate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_id" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_0_period_startdate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_period_enddate" TIMESTAMP,
"releases_0_planning_budget_budgetbreakdown_0_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_0_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_0_amount_currency" VARCHAR,
"releases_0_planning_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_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,
"releases_0_tender_additionalclassifications_14_scheme" VARCHAR
);
Contracts Finder OCDS 2019-03-30
@ukgov.contracts_finder_notices_03_20192_1.contracts_finder_ocds_2019_03_30
- 131.13 KB
- 11 rows
- 121 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_03_30 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"extensions_1" VARCHAR,
"extensions_2" VARCHAR,
"extensions_3" VARCHAR,
"extensions_4" VARCHAR,
"extensions_5" VARCHAR,
"extensions_6" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_datepublished" TIMESTAMP,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_classification_scheme" VARCHAR,
"releases_0_tender_classification_id" BIGINT,
"releases_0_tender_classification_description" VARCHAR,
"releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_0_id" DOUBLE,
"releases_0_tender_additionalclassifications_0_description" VARCHAR,
"releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_1_id" DOUBLE,
"releases_0_tender_additionalclassifications_1_description" VARCHAR,
"releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_2_id" DOUBLE,
"releases_0_tender_additionalclassifications_2_description" VARCHAR,
"releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_3_id" DOUBLE,
"releases_0_tender_additionalclassifications_3_description" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
"releases_0_tender_minvalue_amount" DOUBLE,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" DOUBLE,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_2_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_3_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_4_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_5_countryname" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_contractperiod_startdate" TIMESTAMP,
"releases_0_tender_contractperiod_enddate" TIMESTAMP,
"releases_0_tender_suitability_sme" DOUBLE,
"releases_0_tender_suitability_vcse" DOUBLE,
"releases_0_tender_mainprocurementcategory" VARCHAR,
"releases_0_tender_documents_0_id" DOUBLE,
"releases_0_tender_documents_0_documenttype" VARCHAR,
"releases_0_tender_documents_0_description" VARCHAR,
"releases_0_tender_documents_0_url" VARCHAR,
"releases_0_tender_documents_0_datepublished" TIMESTAMP,
"releases_0_tender_documents_0_format" VARCHAR,
"releases_0_tender_documents_0_language" VARCHAR,
"releases_0_tender_documents_1_id" DOUBLE,
"releases_0_tender_documents_1_documenttype" VARCHAR,
"releases_0_tender_documents_1_description" VARCHAR,
"releases_0_tender_documents_1_url" VARCHAR,
"releases_0_tender_documents_2_id" DOUBLE,
"releases_0_tender_documents_2_documenttype" VARCHAR,
"releases_0_tender_documents_2_description" VARCHAR,
"releases_0_tender_documents_2_url" VARCHAR,
"releases_0_parties_0_id" VARCHAR,
"releases_0_parties_0_name" VARCHAR,
"releases_0_parties_0_identifier_legalname" VARCHAR,
"releases_0_parties_0_identifier_scheme" VARCHAR,
"releases_0_parties_0_identifier_id" VARCHAR,
"releases_0_parties_0_address_streetaddress" VARCHAR,
"releases_0_parties_0_address_locality" VARCHAR,
"releases_0_parties_0_address_postalcode" VARCHAR,
"releases_0_parties_0_address_countryname" VARCHAR,
"releases_0_parties_0_contactpoint_name" VARCHAR,
"releases_0_parties_0_contactpoint_email" VARCHAR,
"releases_0_parties_0_contactpoint_telephone" VARCHAR,
"releases_0_parties_0_details_url" VARCHAR,
"releases_0_parties_0_roles_0" VARCHAR,
"releases_0_parties_1_id" VARCHAR,
"releases_0_parties_1_name" VARCHAR,
"releases_0_parties_1_identifier_legalname" VARCHAR,
"releases_0_parties_1_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
);
Contracts Finder OCDS 2019-03-03
@ukgov.contracts_finder_notices_03_20192_1.contracts_finder_ocds_2019_03_03
- 138.47 KB
- 21 rows
- 128 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_03_03 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"extensions_1" VARCHAR,
"extensions_2" VARCHAR,
"extensions_3" VARCHAR,
"extensions_4" VARCHAR,
"extensions_5" VARCHAR,
"extensions_6" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_datepublished" TIMESTAMP,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_classification_scheme" VARCHAR,
"releases_0_tender_classification_id" BIGINT,
"releases_0_tender_classification_description" VARCHAR,
"releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_0_id" DOUBLE,
"releases_0_tender_additionalclassifications_0_description" VARCHAR,
"releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_1_id" DOUBLE,
"releases_0_tender_additionalclassifications_1_description" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_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_items_0_deliveryaddresses_0_postalcode" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_contractperiod_startdate" TIMESTAMP,
"releases_0_tender_contractperiod_enddate" TIMESTAMP,
"releases_0_tender_suitability_sme" DOUBLE,
"releases_0_tender_suitability_vcse" DOUBLE,
"releases_0_tender_mainprocurementcategory" VARCHAR,
"releases_0_tender_documents_0_id" DOUBLE,
"releases_0_tender_documents_0_documenttype" VARCHAR,
"releases_0_tender_documents_0_description" VARCHAR,
"releases_0_tender_documents_0_url" VARCHAR,
"releases_0_tender_documents_0_datepublished" TIMESTAMP,
"releases_0_tender_documents_0_format" VARCHAR,
"releases_0_tender_documents_0_language" VARCHAR,
"releases_0_tender_documents_1_id" DOUBLE,
"releases_0_tender_documents_1_documenttype" VARCHAR,
"releases_0_tender_documents_1_description" VARCHAR,
"releases_0_tender_documents_1_url" VARCHAR,
"releases_0_parties_0_id" VARCHAR,
"releases_0_parties_0_name" VARCHAR,
"releases_0_parties_0_identifier_legalname" VARCHAR,
"releases_0_parties_0_address_streetaddress" VARCHAR,
"releases_0_parties_0_address_locality" VARCHAR,
"releases_0_parties_0_address_postalcode" VARCHAR,
"releases_0_parties_0_address_countryname" VARCHAR,
"releases_0_parties_0_contactpoint_email" VARCHAR,
"releases_0_parties_0_contactpoint_telephone" VARCHAR,
"releases_0_parties_0_roles_0" VARCHAR,
"releases_0_parties_1_id" VARCHAR,
"releases_0_parties_1_name" VARCHAR,
"releases_0_parties_1_identifier_legalname" VARCHAR,
"releases_0_parties_1_address_streetaddress" VARCHAR,
"releases_0_parties_1_details_scale" VARCHAR,
"releases_0_parties_1_details_vcse" VARCHAR,
"releases_0_parties_1_roles_0" VARCHAR,
"releases_0_buyer_id" VARCHAR,
"releases_0_buyer_name" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_6_countryname" VARCHAR,
"releases_0_tender_documents_2_id" DOUBLE,
"releases_0_tender_documents_2_documenttype" VARCHAR,
"releases_0_tender_documents_2_description" VARCHAR,
"releases_0_tender_documents_2_url" VARCHAR,
"releases_0_parties_0_contactpoint_name" VARCHAR,
"releases_0_parties_0_details_url" 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
);
Contracts Finder OCDS 2019-03-12
@ukgov.contracts_finder_notices_03_20192_1.contracts_finder_ocds_2019_03_12
- 549.59 KB
- 199 rows
- 399 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_03_12 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"extensions_0" VARCHAR,
"extensions_1" VARCHAR,
"extensions_2" VARCHAR,
"extensions_3" VARCHAR,
"extensions_4" VARCHAR,
"extensions_5" VARCHAR,
"extensions_6" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" VARCHAR,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_planning_milestones_0_id" VARCHAR,
"releases_0_planning_milestones_0_title" VARCHAR,
"releases_0_planning_milestones_0_type" VARCHAR,
"releases_0_planning_milestones_0_duedate" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_0_id" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_0_period_startdate" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_0_period_enddate" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_0_description" VARCHAR,
"releases_0_planning_budget_budgetbreakdown_0_amount_amount" DOUBLE,
"releases_0_planning_budget_budgetbreakdown_0_amount_currency" VARCHAR,
"releases_0_planning_documents_0_id" VARCHAR,
"releases_0_planning_documents_0_documenttype" VARCHAR,
"releases_0_planning_documents_0_description" VARCHAR,
"releases_0_planning_documents_0_url" VARCHAR,
"releases_0_planning_documents_0_datepublished" VARCHAR,
"releases_0_planning_documents_0_format" VARCHAR,
"releases_0_planning_documents_0_language" VARCHAR,
"releases_0_planning_documents_1_id" DOUBLE,
"releases_0_planning_documents_1_documenttype" VARCHAR,
"releases_0_planning_documents_1_description" VARCHAR,
"releases_0_planning_documents_1_url" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_datepublished" TIMESTAMP,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_classification_scheme" VARCHAR,
"releases_0_tender_classification_id" DOUBLE,
"releases_0_tender_classification_description" VARCHAR,
"releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_0_id" DOUBLE,
"releases_0_tender_additionalclassifications_0_description" VARCHAR,
"releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_1_id" DOUBLE,
"releases_0_tender_additionalclassifications_1_description" VARCHAR,
"releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_2_id" DOUBLE,
"releases_0_tender_additionalclassifications_2_description" VARCHAR,
"releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_3_id" DOUBLE,
"releases_0_tender_additionalclassifications_3_description" VARCHAR,
"releases_0_tender_additionalclassifications_4_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_4_id" DOUBLE,
"releases_0_tender_additionalclassifications_4_description" VARCHAR,
"releases_0_tender_additionalclassifications_5_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_5_id" DOUBLE,
"releases_0_tender_additionalclassifications_5_description" VARCHAR,
"releases_0_tender_additionalclassifications_6_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_6_id" DOUBLE,
"releases_0_tender_additionalclassifications_6_description" VARCHAR,
"releases_0_tender_additionalclassifications_7_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_7_id" DOUBLE,
"releases_0_tender_additionalclassifications_7_description" VARCHAR,
"releases_0_tender_additionalclassifications_8_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_8_id" DOUBLE,
"releases_0_tender_additionalclassifications_8_description" VARCHAR,
"releases_0_tender_additionalclassifications_9_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_9_id" DOUBLE,
"releases_0_tender_additionalclassifications_9_description" VARCHAR,
"releases_0_tender_additionalclassifications_10_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_10_id" VARCHAR,
"releases_0_tender_additionalclassifications_10_description" VARCHAR,
"releases_0_tender_additionalclassifications_11_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_11_id" DOUBLE,
"releases_0_tender_additionalclassifications_11_description" VARCHAR,
"releases_0_tender_additionalclassifications_12_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_12_id" VARCHAR,
"releases_0_tender_additionalclassifications_12_description" VARCHAR,
"releases_0_tender_additionalclassifications_13_scheme" VARCHAR,
"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" VARCHAR,
"releases_0_tender_additionalclassifications_14_description" VARCHAR,
"releases_0_tender_additionalclassifications_15_scheme" VARCHAR,
"releases_0_tender_additionalclassifications_15_id" VARCHAR,
"releases_0_tender_additionalclassifications_15_description" VARCHAR
);
Contracts Finder OCDS 2019-03-04
@ukgov.contracts_finder_notices_03_20192_1.contracts_finder_ocds_2019_03_04
- 956.76 KB
- 238 rows
- 768 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_03_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_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 2019-03-27
@ukgov.contracts_finder_notices_03_20192_1.contracts_finder_ocds_2019_03_27
- 2.06 MB
- 245 rows
- 2032 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_03_27 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"extensions_1" VARCHAR,
"extensions_2" VARCHAR,
"extensions_3" VARCHAR,
"extensions_4" VARCHAR,
"extensions_5" VARCHAR,
"extensions_6" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_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_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 2019-03-25
@ukgov.contracts_finder_notices_03_20192_1.contracts_finder_ocds_2019_03_25
- 1016.8 KB
- 196 rows
- 883 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_03_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_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_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,
"releases_0_tender_additionalclassifications_14_scheme" VARCHAR
);
Contracts Finder OCDS 2019-03-17
@ukgov.contracts_finder_notices_03_20192_1.contracts_finder_ocds_2019_03_17
- 187.14 KB
- 12 rows
- 187 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_03_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_items_0_id" BIGINT,
"releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_0_postalcode" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_2_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_3_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_4_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_5_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_6_countryname" VARCHAR,
"releases_0_tender_minvalue_amount" DOUBLE,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" DOUBLE,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_1_region" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_contractperiod_startdate" TIMESTAMP,
"releases_0_tender_contractperiod_enddate" TIMESTAMP,
"releases_0_tender_suitability_sme" DOUBLE,
"releases_0_tender_suitability_vcse" DOUBLE,
"releases_0_tender_mainprocurementcategory" VARCHAR,
"releases_0_tender_documents_0_id" DOUBLE,
"releases_0_tender_documents_0_documenttype" VARCHAR,
"releases_0_tender_documents_0_description" VARCHAR,
"releases_0_tender_documents_0_url" VARCHAR,
"releases_0_tender_documents_0_datepublished" TIMESTAMP,
"releases_0_tender_documents_0_format" VARCHAR,
"releases_0_tender_documents_0_language" VARCHAR,
"releases_0_tender_documents_1_id" DOUBLE,
"releases_0_tender_documents_1_documenttype" VARCHAR,
"releases_0_tender_documents_1_description" VARCHAR,
"releases_0_tender_documents_1_url" VARCHAR,
"releases_0_parties_0_id" VARCHAR,
"releases_0_parties_0_name" VARCHAR,
"releases_0_parties_0_identifier_legalname" VARCHAR,
"releases_0_parties_0_address_streetaddress" VARCHAR,
"releases_0_parties_0_address_locality" VARCHAR,
"releases_0_parties_0_address_postalcode" VARCHAR,
"releases_0_parties_0_address_countryname" VARCHAR,
"releases_0_parties_0_contactpoint_name" VARCHAR,
"releases_0_parties_0_contactpoint_email" VARCHAR
);
Contracts Finder OCDS 2019-03-16
@ukgov.contracts_finder_notices_03_20192_1.contracts_finder_ocds_2019_03_16
- 131.86 KB
- 18 rows
- 122 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2019_03_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_0_postalcode" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_2_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_3_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_4_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_5_countryname" VARCHAR,
"releases_0_tender_items_0_deliveryaddresses_6_countryname" VARCHAR,
"releases_0_tender_minvalue_amount" DOUBLE,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" DOUBLE,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_contractperiod_startdate" TIMESTAMP,
"releases_0_tender_contractperiod_enddate" TIMESTAMP,
"releases_0_tender_suitability_sme" DOUBLE,
"releases_0_tender_suitability_vcse" DOUBLE,
"releases_0_tender_mainprocurementcategory" VARCHAR,
"releases_0_tender_documents_0_id" DOUBLE,
"releases_0_tender_documents_0_documenttype" VARCHAR,
"releases_0_tender_documents_0_description" VARCHAR,
"releases_0_tender_documents_0_url" VARCHAR,
"releases_0_tender_documents_0_datepublished" TIMESTAMP,
"releases_0_tender_documents_0_format" VARCHAR,
"releases_0_tender_documents_0_language" VARCHAR,
"releases_0_tender_documents_1_id" DOUBLE,
"releases_0_tender_documents_1_documenttype" VARCHAR,
"releases_0_tender_documents_1_description" VARCHAR,
"releases_0_tender_documents_1_url" VARCHAR,
"releases_0_parties_0_id" VARCHAR,
"releases_0_parties_0_name" VARCHAR,
"releases_0_parties_0_identifier_legalname" VARCHAR,
"releases_0_parties_0_address_streetaddress" VARCHAR,
"releases_0_parties_0_address_locality" VARCHAR,
"releases_0_parties_0_address_postalcode" VARCHAR,
"releases_0_parties_0_address_countryname" VARCHAR,
"releases_0_parties_0_contactpoint_name" VARCHAR,
"releases_0_parties_0_contactpoint_email" VARCHAR,
"releases_0_parties_0_contactpoint_telephone" VARCHAR,
"releases_0_parties_0_details_url" VARCHAR,
"releases_0_parties_0_roles_0" VARCHAR,
"releases_0_parties_1_id" VARCHAR,
"releases_0_parties_1_name" VARCHAR,
"releases_0_parties_1_identifier_legalname" VARCHAR,
"releases_0_parties_1_address_streetaddress" VARCHAR,
"releases_0_parties_1_details_scale" VARCHAR,
"releases_0_parties_1_details_vcse" VARCHAR,
"releases_0_parties_1_roles_0" VARCHAR,
"releases_0_parties_2_id" VARCHAR,
"releases_0_parties_2_name" VARCHAR,
"releases_0_parties_2_identifier_legalname" VARCHAR,
"releases_0_parties_2_address_streetaddress" VARCHAR,
"releases_0_parties_2_details_scale" VARCHAR,
"releases_0_parties_2_details_vcse" VARCHAR,
"releases_0_parties_2_roles_0" VARCHAR,
"releases_0_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_suppliers_1_id" VARCHAR
);