Descubre Pandipedia

Tracking buyers, suppliers, values, deadlines, and SME status in UK procurement data

The cleanest way to work with UK procurement data is to treat each procurement process as the anchor, then join buyers, suppliers, dates, and contract details back to that process. The attached guidance says the main sheet is the starting point for buyer and procedure analysis, with child sheets linked by `main_ocid` and nested sheets joined with their parent ID fields^[1][2].

For award data specifically, the contracts extract says it covers published contract awards from 1 April 2017 onward and includes the buyer, awarded suppliers, contract value, and duration. It also notes the dataset is still incomplete and is updated quarterly^[3][4][5].

1) Identify the buyer

Start with the buyer or procedure record in the main sheet, then carry that process forward through the rest of the model using `main_ocid`. That gives you a stable anchor for dashboard filters, pipeline reporting, and cross-sheet joins^[6][7].

2) Link suppliers

The guide recommends joining `contracts` to `awardssuppliers` on `mainocid` and `contracts.awardID = awardssuppliers.awardsid`, then linking suppliers to `parties` to inspect fields such as `details_scale` for SME analysis^[8].

A key limitation is that some below-threshold contracts do not have declared supplier identifiers, so SME matching is not always complete. The source also warns that a single contract can have multiple suppliers, so you should aggregate back to one contract row before calculating contract-level metrics^[9][10].

3) Choose the right date

Use the date that matches the question. The guide says the main-sheet `date` is the latest update date for the procedure, `contracts.dateSigned` is best for contract trends over time, and the first notice publication date can be used as a start date when needed^[11].

4) Read contract value and duration

For award-level reporting, the contracts extract explicitly includes contract value and duration, which makes it suitable for spend and term analysis^[12]. The guide also points to contract value as the basis for indicators such as total contract value awarded by procurement method, excluding framework agreements^[13].

5) Calculate the core metrics

Compact field-to-use-case table

Final checklist for dashboard builders and proposal teams

Bottom line

If you need one practical rule, it is this: anchor on the procurement process, join suppliers through award tables, pick the date that matches the question, and aggregate to contract level before calculating metrics^{[40][41][42][43]}. That approach fits both dashboarding and proposal work, while staying within the limitations of the published UK data^[44][45].