Baselight
Sign In

Contracts Finder Notices 05–2018

Crown Commercial Service

@ukgov.contracts_finder_notices_05_20182_1

Loading...
Loading...

About this Dataset

Contracts Finder Notices 05–2018

This dataset contains Contracts Finder notices for May 2018. The dataset uses the Open Contracting Data Standard (OCDS) flattened CSV format. Each file contains all OCDS releases for a given calendar day
Publisher name: Crown Commercial Service
Last updated: 2023-02-27T04:27:26Z

Tables

Contracts Finder OCDS 2018-05-26

@ukgov.contracts_finder_notices_05_20182_1.contracts_finder_ocds_2018_05_26
  • 189.23 kB
  • 20 rows
  • 200 columns
Loading... 
CREATE TABLE contracts_finder_ocds_2018_05_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_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_datepublished" VARCHAR,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_classification_scheme" VARCHAR,
  "releases_0_tender_classification_id" DOUBLE,
  "releases_0_tender_classification_description" VARCHAR,
  "releases_0_tender_additionalclassifications_0_scheme" DOUBLE,
  "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" TIMESTAMP,
  "releases_0_tender_additionalclassifications_1_description" TIMESTAMP,
  "releases_0_tender_additionalclassifications_2_scheme" TIMESTAMP,
  "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" TIMESTAMP,
  "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,
  "releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_2_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_3_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_4_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_5_countryname" VARCHAR,
  "releases_0_tender_value_amount" VARCHAR,
  "releases_0_tender_value_currency" VARCHAR,
  "releases_0_tender_procurementmethod" VARCHAR,
  "releases_0_tender_procurementmethoddetails" VARCHAR,
  "releases_0_tender_tenderperiod_enddate" VARCHAR,
  "releases_0_tender_contractperiod_startdate" VARCHAR,
  "releases_0_tender_contractperiod_enddate" VARCHAR,
  "releases_0_tender_suitability_sme" VARCHAR,
  "releases_0_tender_suitability_vcse" VARCHAR,
  "releases_0_tender_mainprocurementcategory" VARCHAR,
  "releases_0_tender_documents_0_id" VARCHAR,
  "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" VARCHAR,
  "releases_0_tender_documents_0_format" VARCHAR,
  "releases_0_tender_documents_0_language" VARCHAR,
  "releases_0_tender_documents_1_id" DOUBLE,
  "releases_0_tender_documents_1_documenttype" VARCHAR,
  "releases_0_tender_documents_1_description" VARCHAR,
  "releases_0_tender_documents_1_url" VARCHAR,
  "releases_0_parties_0_id" VARCHAR,
  "releases_0_parties_0_name" VARCHAR,
  "releases_0_parties_0_identifier_legalname" VARCHAR,
  "releases_0_parties_0_identifier_scheme" VARCHAR,
  "releases_0_parties_0_identifier_id" VARCHAR,
  "releases_0_parties_0_address_streetaddress" VARCHAR,
  "releases_0_parties_0_address_locality" VARCHAR,
  "releases_0_parties_0_address_postalcode" VARCHAR,
  "releases_0_parties_0_address_countryname" VARCHAR,
  "releases_0_parties_0_contactpoint_name" VARCHAR,
  "releases_0_parties_0_contactpoint_email" VARCHAR,
  "releases_0_parties_0_contactpoint_telephone" DOUBLE,
  "releases_0_parties_0_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
);

Contracts Finder OCDS 2018-05-27

@ukgov.contracts_finder_notices_05_20182_1.contracts_finder_ocds_2018_05_27
  • 130.7 kB
  • 12 rows
  • 119 columns
Loading... 
CREATE TABLE contracts_finder_ocds_2018_05_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_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_items_0_deliveryaddresses_0_postalcode" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_2_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_3_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_4_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_5_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_6_region" 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_roles_0" VARCHAR,
  "releases_0_buyer_id" VARCHAR,
  "releases_0_buyer_name" 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_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_awards_0_id" VARCHAR,
  "releases_0_awards_0_status" VARCHAR
);

Contracts Finder OCDS 2018-05-28

@ukgov.contracts_finder_notices_05_20182_1.contracts_finder_ocds_2018_05_28
  • 116.88 kB
  • 18 rows
  • 102 columns
Loading... 
CREATE TABLE contracts_finder_ocds_2018_05_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_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_datepublished" TIMESTAMP,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_classification_scheme" VARCHAR,
  "releases_0_tender_classification_id" BIGINT,
  "releases_0_tender_classification_description" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_2_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_3_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_4_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_5_countryname" VARCHAR,
  "releases_0_tender_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_buyer_id" VARCHAR,
  "releases_0_buyer_name" VARCHAR,
  "releases_0_awards_0_id" VARCHAR,
  "releases_0_awards_0_status" VARCHAR,
  "releases_0_awards_0_date" TIMESTAMP,
  "releases_0_awards_0_datepublished" TIMESTAMP,
  "releases_0_awards_0_value_amount" DOUBLE,
  "releases_0_awards_0_value_currency" VARCHAR,
  "releases_0_awards_0_suppliers_0_id" VARCHAR,
  "releases_0_awards_0_suppliers_0_name" VARCHAR,
  "releases_0_awards_0_contractperiod_startdate" TIMESTAMP,
  "releases_0_awards_0_contractperiod_enddate" TIMESTAMP,
  "releases_0_awards_0_documents_0_id" DOUBLE,
  "releases_0_awards_0_documents_0_documenttype" VARCHAR,
  "releases_0_awards_0_documents_0_description" VARCHAR,
  "releases_0_awards_0_documents_0_url" VARCHAR,
  "releases_0_awards_0_documents_0_datepublished" TIMESTAMP,
  "releases_0_awards_0_documents_0_format" VARCHAR,
  "releases_0_awards_0_documents_0_language" VARCHAR,
  "releases_0_awards_0_documents_1_id" DOUBLE,
  "releases_0_awards_0_documents_1_documenttype" VARCHAR
);

Contracts Finder OCDS 2018-05-29

@ukgov.contracts_finder_notices_05_20182_1.contracts_finder_ocds_2018_05_29
  • 533.12 kB
  • 77 rows
  • 705 columns
Loading... 
CREATE TABLE contracts_finder_ocds_2018_05_29 (
  "https_www_contractsfinder_service_gov_uk_published_not_51e02c04" VARCHAR  -- Https://www.contractsfinder.service.gov.uk/Published/Notice/releases/ddb929d6-bb80-4627-a241-780fb48f2fa8.json,
  "n_2018_05_29t13_46_16_01_00" TIMESTAMP  -- 2018-05-29T13:46:16+01:00,
  "cabinet_office" VARCHAR,
  "gb_gor" VARCHAR,
  "d2" VARCHAR,
  "https_www_gov_uk_government_organisations_cabinet_office" VARCHAR  -- Https://www.gov.uk/government/organisations/cabinet-office,
  "n_1_1" DOUBLE  -- 1.1,
  "https_standard_open_contracting_org_profiles_eu_master_9a25c439" VARCHAR  -- Https://standard.open-contracting.org/profiles/eu/master/en/extension.json,
  "https_raw_githubusercontent_com_portaledcahn_ocds_tend_899e42ae" VARCHAR  -- Https://raw.githubusercontent.com/portaledcahn/ocds TenderDatePublished Extension/master/extension.json,
  "https_raw_githubusercontent_com_open_contracting_exten_283fb799" VARCHAR  -- Https://raw.githubusercontent.com/open-contracting-extensions/ocds Budget Breakdown Extension/master/extension.json,
  "https_raw_githubusercontent_com_crown_commercial_servi_751afc7f" VARCHAR  -- Https://raw.githubusercontent.com/Crown-Commercial-Service/ocds Awards DatePublished Extension/main/extension.json,
  "https_raw_githubusercontent_com_crown_commercial_servi_e4036c70" VARCHAR  -- Https://raw.githubusercontent.com/Crown-Commercial-Service/ocds PartyDetails Vcse Extension/main/extension.json,
  "https_raw_githubusercontent_com_crown_commercial_servi_a93234bd" VARCHAR  -- Https://raw.githubusercontent.com/Crown-Commercial-Service/ocds Tender Suitability Extension/main/extension.json,
  "https_raw_githubusercontent_com_open_contracting_exten_ff7b0709" VARCHAR  -- Https://raw.githubusercontent.com/open-contracting-extensions/ocds Pagination Extension/master/extension.json,
  "http_www_nationalarchives_gov_uk_doc_open_government_l_ed0688a9" VARCHAR  -- Http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/,
  "https_www_gov_uk_government_publications_open_contracting" VARCHAR  -- Https://www.gov.uk/government/publications/open-contracting,
  "ocds_b5fd17_58fbb819_5201_40b8_99e8_a94834b9fc5c" VARCHAR,
  "ddb929d6_bb80_4627_a241_780fb48f2fa8_218807" VARCHAR,
  "en" VARCHAR,
  "n_2018_05_29t13_46_16_01_00_1" TIMESTAMP  -- 2018-05-29T13:46:16+01:00.1,
  "awardupdate" VARCHAR,
  "tender" VARCHAR,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" DOUBLE  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "unnamed_26" TIMESTAMP  -- Unnamed: 26,
  "unnamed_27" DOUBLE  -- Unnamed: 27,
  "unnamed_28" TIMESTAMP  -- Unnamed: 28,
  "unnamed_29" TIMESTAMP  -- Unnamed: 29,
  "unnamed_30" VARCHAR  -- Unnamed: 30,
  "unnamed_31" DOUBLE  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" DOUBLE  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "unnamed_36" VARCHAR  -- Unnamed: 36,
  "unnamed_37" TIMESTAMP  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "unnamed_39" VARCHAR  -- Unnamed: 39,
  "unnamed_40" DOUBLE  -- Unnamed: 40,
  "unnamed_41" VARCHAR  -- Unnamed: 41,
  "unnamed_42" VARCHAR  -- Unnamed: 42,
  "unnamed_43" VARCHAR  -- Unnamed: 43,
  "bolt001_dn333818_36778202" VARCHAR,
  "q049_restaurant_shell_fit_out_and_associated_works_at__6425a4a2" VARCHAR  -- Q049 - Restaurant Shell Fit Out And Associated Works At Albert Halls, Bolton Town Hall,
  "the_borough_council_of_bolton_the_authority_is_prepare_e53eb1a8" VARCHAR  -- The Borough Council Of Bolton (\the Authority\") Is Prepared To Receive Tenders For Restaurant Shell Fit Out And Associated Works At Albert Halls,
  "n__bolton_town_hall_which_will_be_subject_to_the_information" TIMESTAMP  -- Bolton Town Hall Which Will Be Subject To The Information,
  "n__specification_and_tender_package_enclosed_the_works_ed11db7c" VARCHAR  -- Specification And Tender Package Enclosed. The Works Entail Full Refurbishment Of The Rooms To Provide A Catering Store,
  "n__restaurant_shell_fit_out" VARCHAR  -- Restaurant Shell Fit Out,
  "n__quiet_room_and_beer_cellar_the_type_of_works_to_be__9464d735" VARCHAR  -- Quiet Room And Beer Cellar. The Type Of Works To Be Undertaken Are Includes,
  "n__but_is_not_limited_to_refurbishment_of_fire_ducts" VARCHAR  -- But Is Not Limited To: Refurbishment Of Fire Ducts,
  "n__forming_new_partition_walls" VARCHAR  -- Forming New Partition Walls,
  "n__removal_of_redundant_mechanical_and_electrical_serv_5afeaa9a" DOUBLE  -- Removal Of Redundant Mechanical And Electrical Services And Installation Of New,
  "n__installation_of_wc_connection_of_the_new_sanitary_a_95367d1d" VARCHAR  -- Installation Of WC Connection Of The New Sanitary Appliances To Existing Drainage,
  "n__installation_of_new_windows" VARCHAR  -- Installation Of New Windows,
  "n__installation_of_hygienic_wall_cladding" DOUBLE  -- Installation Of Hygienic Wall Cladding,
  "n__new_floor_and_wall_finishes_including_decoration_si_277ac49c" VARCHAR  -- New Floor And Wall Finishes Including Decoration. Site Visits For Albert Halls Is A Mandatory Requirement And Must Be Requested Via The Chest Messaging Portal. Site Visits Will Take Place On Tuesday 17 April And Thursday 19 April 2018,
  "n__between_the_hours_10am_and_2pm_the_council_will_off_f7f1e824" VARCHAR  -- Between The Hours 10am And 2pm. The Council Will Offer And Allocate Individual Slots On A First Come,
  "n__first_served_basis" DOUBLE  -- First Served Basis.",
  "n_2018_04_11t15_13_25_01_00" VARCHAR  -- 2018-04-11T15:13:25+01:00,
  "complete" VARCHAR,
  "cpv" DOUBLE,
  "n_45000000" VARCHAR  -- 45000000,
  "construction_work" VARCHAR,
  "cpv_1" DOUBLE,
  "n_71500000" VARCHAR  -- 71500000,
  "construction_related_services" VARCHAR,
  "unnamed_68" DOUBLE  -- Unnamed: 68,
  "unnamed_69" VARCHAR  -- Unnamed: 69,
  "unnamed_70" VARCHAR  -- Unnamed: 70,
  "unnamed_71" DOUBLE  -- Unnamed: 71,
  "unnamed_72" VARCHAR  -- Unnamed: 72,
  "unnamed_73" VARCHAR  -- Unnamed: 73,
  "unnamed_74" VARCHAR  -- Unnamed: 74,
  "unnamed_75" VARCHAR  -- Unnamed: 75,
  "unnamed_76" VARCHAR  -- Unnamed: 76,
  "unnamed_77" VARCHAR  -- Unnamed: 77,
  "unnamed_78" VARCHAR  -- Unnamed: 78,
  "unnamed_79" VARCHAR  -- Unnamed: 79,
  "unnamed_80" VARCHAR  -- Unnamed: 80,
  "unnamed_81" VARCHAR  -- Unnamed: 81,
  "unnamed_82" VARCHAR  -- Unnamed: 82,
  "unnamed_83" DOUBLE  -- Unnamed: 83,
  "unnamed_84" VARCHAR  -- Unnamed: 84,
  "unnamed_85" VARCHAR  -- Unnamed: 85,
  "unnamed_86" DOUBLE  -- Unnamed: 86,
  "unnamed_87" VARCHAR  -- Unnamed: 87,
  "unnamed_88" VARCHAR  -- Unnamed: 88,
  "unnamed_89" DOUBLE  -- Unnamed: 89,
  "unnamed_90" VARCHAR  -- Unnamed: 90,
  "unnamed_91" VARCHAR  -- Unnamed: 91,
  "unnamed_92" DOUBLE  -- Unnamed: 92,
  "unnamed_93" VARCHAR  -- Unnamed: 93,
  "unnamed_94" DOUBLE  -- Unnamed: 94,
  "unnamed_95" VARCHAR  -- Unnamed: 95,
  "unnamed_96" VARCHAR  -- Unnamed: 96,
  "unnamed_97" VARCHAR  -- Unnamed: 97,
  "unnamed_98" VARCHAR  -- Unnamed: 98,
  "unnamed_99" VARCHAR  -- Unnamed: 99
);

Contracts Finder OCDS 2018-05-30

@ukgov.contracts_finder_notices_05_20182_1.contracts_finder_ocds_2018_05_30
  • 757.51 kB
  • 156 rows
  • 640 columns
Loading... 
CREATE TABLE contracts_finder_ocds_2018_05_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_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_planning_documents_3_id" DOUBLE,
  "releases_0_planning_documents_3_documenttype" VARCHAR,
  "releases_0_planning_documents_3_description" VARCHAR,
  "releases_0_planning_documents_3_url" VARCHAR,
  "releases_0_planning_documents_3_format" VARCHAR,
  "releases_0_planning_documents_4_id" DOUBLE,
  "releases_0_planning_documents_4_documenttype" VARCHAR,
  "releases_0_planning_documents_4_description" VARCHAR,
  "releases_0_planning_documents_4_url" VARCHAR,
  "releases_0_planning_documents_4_format" VARCHAR,
  "releases_0_planning_documents_5_id" DOUBLE,
  "releases_0_planning_documents_5_documenttype" VARCHAR,
  "releases_0_planning_documents_5_description" VARCHAR,
  "releases_0_planning_documents_5_url" VARCHAR,
  "releases_0_planning_documents_5_format" VARCHAR,
  "releases_0_planning_documents_6_id" DOUBLE,
  "releases_0_planning_documents_6_documenttype" VARCHAR,
  "releases_0_planning_documents_6_description" VARCHAR,
  "releases_0_planning_documents_6_url" VARCHAR,
  "releases_0_planning_documents_6_format" VARCHAR,
  "releases_0_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
);

Contracts Finder OCDS 2018-05-31

@ukgov.contracts_finder_notices_05_20182_1.contracts_finder_ocds_2018_05_31
  • 582.13 kB
  • 181 rows
  • 428 columns
Loading... 
CREATE TABLE contracts_finder_ocds_2018_05_31 (
  "uri" VARCHAR,
  "publisheddate" VARCHAR,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" VARCHAR,
  "extensions_1" VARCHAR,
  "extensions_2" VARCHAR,
  "extensions_3" VARCHAR,
  "extensions_4" VARCHAR,
  "extensions_5" VARCHAR,
  "extensions_6" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" TIMESTAMP,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_title" VARCHAR,
  "releases_0_planning_milestones_0_id" 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_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" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_0_amount_currency" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_1_id" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_1_period_startdate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_1_period_enddate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_1_description" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_1_amount_amount" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_1_amount_currency" VARCHAR,
  "releases_0_planning_documents_0_id" DOUBLE,
  "releases_0_planning_documents_0_documenttype" VARCHAR,
  "releases_0_planning_documents_0_description" VARCHAR,
  "releases_0_planning_documents_0_url" VARCHAR,
  "releases_0_planning_documents_0_datepublished" TIMESTAMP,
  "releases_0_planning_documents_0_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" VARCHAR,
  "releases_0_planning_documents_2_documenttype" VARCHAR,
  "releases_0_planning_documents_2_description" VARCHAR,
  "releases_0_planning_documents_2_url" VARCHAR,
  "releases_0_planning_documents_2_format" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_datepublished" VARCHAR,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_classification_scheme" VARCHAR,
  "releases_0_tender_classification_id" DOUBLE,
  "releases_0_tender_classification_description" VARCHAR,
  "releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_0_id" DOUBLE,
  "releases_0_tender_additionalclassifications_0_description" VARCHAR,
  "releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_1_id" DOUBLE,
  "releases_0_tender_additionalclassifications_1_description" VARCHAR,
  "releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_2_id" 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,
  "releases_0_tender_items_0_deliveryaddresses_0_postalcode" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_2_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_2_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_3_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_3_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_4_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_4_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_5_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_5_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_6_region" VARCHAR
);

Share link

Anyone who has the link will be able to view this.