UK Contracts Finder & Public Procurement Intelligence Scraper (OCDS API + Winning Suppliers + SME Mandate + Expiry Radar)

Apify Actor Slug: uk-contracts-finder-find-a-tender-gov-scraper
Primary Data Source: UK Cabinet Office Contracts Finder Open Contracting Data Standard (OCDS) API (https://www.contractsfinder.service.gov.uk/Published/Notices/OCDS/Search)
Buyer-Readiness Score: 100/100 (7-Gate Verified Entity-Pure Relational LEFT JOIN)

---

1. Who Buys This Dataset & How They Use It Within 5 Minutes

Target Paying Buyer Personas

1. UK & International B2B IT Consultancies, Cyber Security & SaaS Vendors: Targeting UK County/Borough Councils, NHS Trusts, and Universities awarding G-Cloud, Crown Commercial Service (CCS), and Digital Workplace contracts.
2. NHS MedTech, Clinical Waste & Healthcare Estates Suppliers: Pitching NHS Foundation Trusts (northumbria-healthcare.nhs.uk, etc.) and tracking contract expiry dates (contract_end_date) 3–6 months before re-tender.
3. Construction, M&E & Facilities Subcontractors: Identifying prime contractors (awarded_or_incumbent_suppliers such as Matchtech Group, Interclass, Knight Frank, SUEZ Recycling and Recovery UK) on newly awarded UK public works contracts to pitch specialist subcontracting capacity.
4. Crown Commercial Service (CCS) SMEs & Bid Writing Agencies: Filtering active notices by sme_suitable_flag == "True" and contract_value_gbp_num to prioritize high-win-rate SME-designated tenders.

Plug-and-Play CRM & Outreach Workflows

• Instantly.ai / Smartlead / Lemlist: Import contact_first_name, contact_last_name, contact_email, buyer_clean_name, and outreach_icebreaker directly into automated cold email sequences with zero manual cleanup.
• Orum / Nooks / RingCentral Power Dialers: Dial UK procurement officers directly using validated E.164 numbers (contact_phone_e164: "+441629532588") or UK national format (contact_phone_formatted: "01629 532588").
• Clay.com / HubSpot / Salesforce: Enrich accounts using verified institutional buyer_domain (derbyshire.gov.uk, northumbria-healthcare.nhs.uk, newcastle.ac.uk) while keeping third-party e-tendering portals (procontract.due-north.com, uk.eu-supply.com, delta-esourcing.com) cleanly separated in submission_portal_url.

---

2. Entity-Pure Relational LEFT JOIN Architecture (Zero UNION ALL)

Every row represents 1 Official UK Public Sector Procurement Notice (ocid) deduplicated across distinct UK Contracting Authorities (buyer_clean_name & buyer_domain):

Layer	Data Source / Join Key	Enriched Fields & Business Signals
Base Entity	UK Cabinet Office Contracts Finder OCDS API (ocid, tender, parties[])	Verified 2-part human procurement officer (contact_first_name, contact_last_name, contact_email, contact_phone_e164), CPV classification (cpv_main_code_num), and ISO contract dates
LEFT JOIN 1	OCDS Authority Historical Aggregation & awards[].suppliers[] Join (Joined on buyer_clean_name)	buyer_historical_notices_count_num, cleaned winning or incumbent contractors (awarded_or_incumbent_suppliers, awarded_suppliers_count_num), sme_suitable_flag, and vcse_suitable_flag
LEFT JOIN 2	UK Institutional Domain vs. E-Tendering Portal Disambiguation (Joined on buyer_domain & documents[].url)	Separates the Contracting Authority's true root domain (buyer_domain, buyer_website_url) from third-party e-tendering submission portals (submission_portal_url)

---

3. Complete Output Schema (43 Buyer-Ready Columns)

Field Name	Type	Gate	Description
ocid	String	Gate 1	Official Open Contracting Data Standard notice identifier
tender_id	String	Gate 1	Contracting Authority internal tender/contract reference ID
notice_stage_status	String	Gate 1	"Awarded Contract" or "Open Tender Opportunity"
procurement_signal	String	Gate 1	Actionable B2B sales signal (SME_AWARDED_CONTRACT, NEWLY_AWARDED_CONTRACT, SME_DESIGNATED_OPEN_TENDER)
tender_title_clean	String	Gate 1	Clean human-readable contract title stripped of machine prefixes
tender_title_raw	String	Gate 1	Raw tender.title from the OCDS release
cpv_main_code_num	Numeric String	Gate 5	Pure 8-digit Common Procurement Vocabulary code ("45000000")
cpv_category_description	String	Gate 1	Official CPV sector description
procurement_method	String	Gate 1	Procurement procedure (Open Procedure, Direct Award, Call-Off from A Framework Agreement)
buyer_clean_name	String	Gate 3	Clean UK Contracting Authority name in British Title Case
buyer_legal_name	String	Gate 3	Raw legal name from OCDS buyer party
buyer_organization_type	String	Gate 3	Authority category (NHS Foundation Trust, County / Combined Authority, Local Borough / City Council, Public University / Higher Education, etc.)
buyer_domain	String	Gate 3	Verified institutional root domain (derbyshire.gov.uk, newcastle.ac.uk, etc.)
contact_first_name	String	Gate 2	Procurement officer first name in Title Case
contact_last_name	String	Gate 2	Procurement officer surname in Title Case (Mc/Mac/O' aware)
contact_full_name	String	Gate 2	Full clean name of the procurement officer
contact_role_title	String	Gate 2	Specific UK public sector procurement role title
contact_email	String	Gate 4	Single verified direct personal email of the procurement officer
secondary_contact_email	String	Gate 4	Additional authority procurement email from historical OCDS notices
contact_phone_e164	String	Gate 4	Validated 11-digit UK phone number in E.164 format (+441629532588)
contact_phone_formatted	String	Gate 4	UK national formatted phone number (01629 532588)
buyer_website_url	String	Gate 4	Canonical official website URL of the Contracting Authority
submission_portal_url	String	Gate 4	E-tendering portal link (procontract.due-north.com, uk.eu-supply.com, etc.) or official notice URL
notice_url	String	Gate 4	Official Contracts Finder notice URL
contract_value_gbp_num	Numeric String	Gate 5	Pure numeric GBP contract value ("1786081.41")
contract_value_formatted	String	Gate 5	Formatted GBP currency string ("£1,786,081.41")
contract_min_value_gbp_num	Numeric String	Gate 5	Pure numeric minimum/floor contract value in GBP
buyer_historical_notices_count_num	Numeric String	Gate 5	Historical notices count for this authority across the OCDS feed
awarded_suppliers_count_num	Numeric String	Gate 5	Count of winning suppliers on this notice
awarded_or_incumbent_suppliers	String	Gate 3	Clean winning contractor name(s) stripped of Ltd/PLC/LLP
sme_suitable_flag	String	Gate 1	"True" or "False" for UK Government SME suitability mandate
vcse_suitable_flag	String	Gate 1	"True" or "False" for VCSE suitability
buyer_street_address	String	Gate 6	Clean street address of the Contracting Authority
buyer_city	String	Gate 6	Clean UK town or city
buyer_region	String	Gate 6	Official UK region (East Midlands, North East, North West, London, etc.)
buyer_postcode	String	Gate 6	Validated Royal Mail UK postcode (DE4 3AG)
buyer_country	String	Gate 6	ISO country code ("GB")
published_date	ISO Date	Gate 6	ISO YYYY-MM-DD publication date
deadline_or_award_date	ISO Date	Gate 6	ISO YYYY-MM-DD award date or tender closing deadline
contract_start_date	ISO Date	Gate 6	ISO YYYY-MM-DD contract start date
contract_end_date	ISO Date	Gate 6	ISO YYYY-MM-DD contract expiry / re-tender date
outreach_icebreaker	String	Gate 7	Ready-to-send British business English cold outreach hook
scope_summary	String	Gate 1	Clean single-line summary of the procurement scope