Merging¶
An OCDS record aggregates all the releases available for a contracting process at a given time, and can include:
a compiled release, which expresses the current state of the contracting process, by showing only the most recent field values
a versioned release, which expresses all historical states of the contracting process, by showing all the field values over time
Merging is the process of combining individual releases into a compiled or versioned release, described in more detail below. At a high level:
A compiled release is created by taking only the most recent values of fields from releases in a given contracting process.
A versioned release is created by taking all values of fields from releases in a given contracting process, copying metadata about the release from which they are taken, and putting them in chronological order.
Worked Example
A public procurement agency publishes a release to announce an opportunity on January 1, in which the total estimated value of the procurement is $1,000. On January 31, it publishes a release to correct the information, in which the description of the procurement is expanded. On February 5, the agency publishes a release to amend the opportunity, in which the total estimated value of the procurement is increased to $2,000.
The agency decides to award the opportunity to two of the bidders. On March 1, the agency publishes a release to announce that Company A is awarded a contract of $750. On March 3, the agency publishes a release to announce that Company B is awarded a contract of $750.
Through these individual releases, the agency provides real-time data about the contracting process.
At each release, the agency also updates the record, which combines all the releases to date. In the final record:
The compiled release contains all the information about the opportunity and awards, using the same schema as a release.
The versioned release makes it easy to see how the description and total estimated value changed over time.
[
{
"ocid": "ocds-213czf-000-00002",
"id": "ocds-213czf-000-00002-01-tender",
"date": "2016-01-01T09:30:00Z",
"language": "en",
"tag": [
"tender"
],
"initiationType": "tender",
"parties": [
{
"name": "Open Data Services",
"identifier": {
"scheme": "GB-COH",
"id": "09506232",
"legalName": "Open Data Services Co-operative",
"uri": "https://opencorporates.com/companies/gb/09506232"
},
"roles": [
"buyer"
],
"id": "GB-COH-09506232"
}
],
"buyer": {
"id": "GB-COH-09506232",
"name": "Open Data Services"
},
"tender": {
"id": "ocds-213czf-000-00002-01-tender",
"title": "Data merging tool",
"description": "Data merge tool.",
"status": "active",
"value": {
"amount": 1000,
"currency": "USD"
},
"procurementMethod": "open",
"awardCriteria": "bestProposal",
"submissionMethod": [
"electronicSubmission"
],
"tenderPeriod": {
"startDate": "2016-01-31T09:00:00Z",
"endDate": "2016-02-15T18:00:00Z"
},
"awardPeriod": {
"startDate": "2016-04-01T00:00:00Z",
"endDate": "2016-06-01T23:59:59Z"
}
}
}
]
[
{
"ocid": "ocds-213czf-000-00002",
"id": "ocds-213czf-000-00002-01-tender-amendment",
"date": "2016-02-05T10:30:00Z",
"language": "en",
"tag": [
"tenderAmendment"
],
"initiationType": "tender",
"parties": [
{
"name": "Open Data Services",
"identifier": {
"scheme": "GB-COH",
"id": "09506232",
"legalName": "Open Data Services Co-operative",
"uri": "https://opencorporates.com/companies/gb/09506232"
},
"roles": [
"buyer"
],
"id": "GB-COH-09506232"
}
],
"buyer": {
"id": "GB-COH-09506232",
"name": "Open Data Services"
},
"tender": {
"id": "ocds-213czf-000-00002-01-tender",
"title": "Data merging tool",
"description": "Creation of a data merging tool. The tool should by written in Python. Proposals should be submitted by e-mail.",
"status": "active",
"value": {
"amount": 2000,
"currency": "USD"
},
"procurementMethod": "open",
"awardCriteria": "bestProposal",
"submissionMethod": [
"electronicSubmission"
],
"tenderPeriod": {
"startDate": "2016-01-31T09:00:00Z",
"endDate": "2016-02-20T18:00:00Z"
},
"awardPeriod": {
"startDate": "2016-04-01T00:00:00Z",
"endDate": "2016-06-01T23:59:59Z"
},
"amendments": [
{
"id": "amendment-1",
"date": "2016-02-04T09:30:00Z",
"rationale": "Based on feedback from potential bidders, the total budget was increased by $1000, and the deadline extended",
"amendsReleaseID": "ocds-213czf-000-00002-01-tender",
"releaseID": "ocds-213czf-000-00002-01-tender-amendment"
}
]
}
}
]
[
{
"ocid": "ocds-213czf-000-00002",
"id": "ocds-213czf-000-00002-01-award1",
"date": "2016-03-01T09:30:00Z",
"language": "en",
"tag": [
"award"
],
"initiationType": "tender",
"parties": [
{
"name": "Open Data Services",
"identifier": {
"scheme": "GB-COH",
"id": "09506232",
"legalName": "Open Data Services Co-operative",
"uri": "https://opencorporates.com/companies/gb/09506232"
},
"roles": [
"buyer"
],
"id": "GB-COH-09506232"
}
],
"buyer": {
"id": "GB-COH-09506232",
"name": "Open Data Services"
},
"awards": [
{
"id": "ocds-213czf-000-00002-award-supplier-one",
"title": "Award of contract to create the data merging tool.",
"description": "Supplier 1 has been commissioned to create the merge tool. A separate contract will be awarded to write the documentation",
"status": "active",
"date": "2016-03-01T09:30:00Z",
"value": {
"amount": 750,
"currency": "USD"
}
}
]
}
]
[
{
"ocid": "ocds-213czf-000-00002",
"id": "ocds-213czf-000-00002-01-award2",
"date": "2016-03-03T09:30:00Z",
"language": "en",
"tag": [
"award"
],
"initiationType": "tender",
"parties": [
{
"name": "Open Data Services",
"identifier": {
"scheme": "GB-COH",
"id": "09506232",
"legalName": "Open Data Services Co-operative",
"uri": "https://opencorporates.com/companies/gb/09506232"
},
"roles": [
"buyer"
],
"id": "GB-COH-09506232"
}
],
"buyer": {
"id": "GB-COH-09506232",
"name": "Open Data Services"
},
"awards": [
{
"id": "ocds-213czf-000-00002-award-supplier-two",
"title": "Award of contract to create the data merging tool.",
"description": "Supplier 2 has been commissioned to create the documentation. A separate contract will be awarded to create the tool",
"status": "active",
"date": "2016-03-03T09:30:00Z",
"value": {
"amount": 750,
"currency": "USD"
}
}
]
}
]
{
"uri": "https://standard.open-contracting.org/examples/records/ocds-213czf-000-00002-merge.json",
"publisher": {
"scheme": "GB-COH",
"uid": "09506232",
"name": "Open Data Services Co-operative Limited",
"uri": "https://standard.open-contracting.org/examples/"
},
"publishedDate": "2016-03-05T13:02:00Z",
"license": "http://opendatacommons.org/licenses/pddl/1.0/",
"publicationPolicy": "https://github.com/open-contracting/sample-data/",
"version": "1.1",
"packages": [
"https://standard.open-contracting.org/examples/releases/ocds-213czf-000-00002-01-award1.json",
"https://standard.open-contracting.org/examples/releases/ocds-213czf-000-00002-01-award2.json",
"https://standard.open-contracting.org/examples/releases/ocds-213czf-000-00002-01-tender.json",
"https://standard.open-contracting.org/examples/releases/ocds-213czf-000-00002-01-tender-update.json",
"https://standard.open-contracting.org/examples/releases/ocds-213czf-000-00002-01-tender-amendment.json"
],
"records": [
{
"ocid": "ocds-213czf-000-00002",
"releases": [
{
"url": "https://standard.open-contracting.org/examples/releases/ocds-213czf-000-00002-01-award1.json#ocds-213czf-000-00002-01-award1",
"date": "2016-03-01T09:30:00Z",
"tag": [
"award"
]
},
{
"url": "https://standard.open-contracting.org/examples/releases/ocds-213czf-000-00002-01-award2.json#ocds-213czf-000-00002-01-award2",
"date": "2016-03-03T09:30:00Z",
"tag": [
"award"
]
},
{
"url": "https://standard.open-contracting.org/examples/releases/ocds-213czf-000-00002-01-tender.json#ocds-213czf-000-00002-01-tender",
"date": "2016-01-01T09:30:00Z",
"tag": [
"tender"
]
},
{
"url": "https://standard.open-contracting.org/examples/releases/ocds-213czf-000-00002-01-tender-update.json#ocds-213czf-000-00002-01-tender-update",
"date": "2016-01-31T09:30:00Z",
"tag": [
"tenderUpdate"
]
},
{
"url": "https://standard.open-contracting.org/examples/releases/ocds-213czf-000-00002-01-tender-amendment.json#ocds-213czf-000-00002-01-tender-amendment",
"date": "2016-02-05T10:30:00Z",
"tag": [
"tenderAmendment"
]
}
],
"compiledRelease": {
"tag": [
"compiled"
],
"id": "ocds-213czf-000-00002-2016-03-03T09:30:00Z",
"date": "2016-03-03T09:30:00Z",
"ocid": "ocds-213czf-000-00002",
"language": "en",
"initiationType": "tender",
"parties": [
{
"id": "GB-COH-09506232",
"name": "Open Data Services",
"identifier": {
"scheme": "GB-COH",
"id": "09506232",
"legalName": "Open Data Services Co-operative",
"uri": "https://opencorporates.com/companies/gb/09506232"
},
"roles": [
"buyer"
]
}
],
"buyer": {
"id": "GB-COH-09506232",
"name": "Open Data Services"
},
"tender": {
"id": "ocds-213czf-000-00002-01-tender",
"title": "Data merging tool",
"description": "Creation of a data merging tool. The tool should by written in Python. Proposals should be submitted by e-mail.",
"status": "active",
"value": {
"amount": 2000,
"currency": "USD"
},
"procurementMethod": "open",
"awardCriteria": "bestProposal",
"submissionMethod": [
"electronicSubmission"
],
"tenderPeriod": {
"startDate": "2016-01-31T09:00:00Z",
"endDate": "2016-02-20T18:00:00Z"
},
"awardPeriod": {
"startDate": "2016-04-01T00:00:00Z",
"endDate": "2016-06-01T23:59:59Z"
},
"amendments": [
{
"id": "amendment-1",
"date": "2016-02-04T09:30:00Z",
"rationale": "Based on feedback from potential bidders, the total budget was increased by $1000, and the deadline extended",
"amendsReleaseID": "ocds-213czf-000-00002-01-tender",
"releaseID": "ocds-213czf-000-00002-01-tender-amendment"
}
]
},
"awards": [
{
"id": "ocds-213czf-000-00002-award-supplier-one",
"title": "Award of contract to create the data merging tool.",
"description": "Supplier 1 has been commissioned to create the merge tool. A separate contract will be awarded to write the documentation",
"status": "active",
"date": "2016-03-01T09:30:00Z",
"value": {
"amount": 750,
"currency": "USD"
}
},
{
"id": "ocds-213czf-000-00002-award-supplier-two",
"title": "Award of contract to create the data merging tool.",
"description": "Supplier 2 has been commissioned to create the documentation. A separate contract will be awarded to create the tool",
"status": "active",
"date": "2016-03-03T09:30:00Z",
"value": {
"amount": 750,
"currency": "USD"
}
}
]
}
}
]
}
{
"uri": "https://standard.open-contracting.org/examples/records/ocds-213czf-000-00002-merge.json",
"publisher": {
"scheme": "GB-COH",
"uid": "09506232",
"name": "Open Data Services Co-operative Limited",
"uri": "https://standard.open-contracting.org/examples/"
},
"publishedDate": "2016-03-05T13:02:00Z",
"license": "http://opendatacommons.org/licenses/pddl/1.0/",
"publicationPolicy": "https://github.com/open-contracting/sample-data/",
"version": "1.1",
"packages": [
"https://standard.open-contracting.org/examples/releases/ocds-213czf-000-00002-01-award1.json",
"https://standard.open-contracting.org/examples/releases/ocds-213czf-000-00002-01-award2.json",
"https://standard.open-contracting.org/examples/releases/ocds-213czf-000-00002-01-tender.json",
"https://standard.open-contracting.org/examples/releases/ocds-213czf-000-00002-01-tender-update.json",
"https://standard.open-contracting.org/examples/releases/ocds-213czf-000-00002-01-tender-amendment.json"
],
"records": [
{
"ocid": "ocds-213czf-000-00002",
"releases": [
{
"url": "https://standard.open-contracting.org/examples/releases/ocds-213czf-000-00002-01-award1.json#ocds-213czf-000-00002-01-award1",
"date": "2016-03-01T09:30:00Z",
"tag": [
"award"
]
},
{
"url": "https://standard.open-contracting.org/examples/releases/ocds-213czf-000-00002-01-award2.json#ocds-213czf-000-00002-01-award2",
"date": "2016-03-03T09:30:00Z",
"tag": [
"award"
]
},
{
"url": "https://standard.open-contracting.org/examples/releases/ocds-213czf-000-00002-01-tender.json#ocds-213czf-000-00002-01-tender",
"date": "2016-01-01T09:30:00Z",
"tag": [
"tender"
]
},
{
"url": "https://standard.open-contracting.org/examples/releases/ocds-213czf-000-00002-01-tender-update.json#ocds-213czf-000-00002-01-tender-update",
"date": "2016-01-31T09:30:00Z",
"tag": [
"tenderUpdate"
]
},
{
"url": "https://standard.open-contracting.org/examples/releases/ocds-213czf-000-00002-01-tender-amendment.json#ocds-213czf-000-00002-01-tender-amendment",
"date": "2016-02-05T10:30:00Z",
"tag": [
"tenderAmendment"
]
}
],
"compiledRelease": {
"tag": [
"compiled"
],
"id": "ocds-213czf-000-00002-2016-03-03T09:30:00Z",
"date": "2016-03-03T09:30:00Z",
"ocid": "ocds-213czf-000-00002",
"language": "en",
"initiationType": "tender",
"parties": [
{
"id": "GB-COH-09506232",
"name": "Open Data Services",
"identifier": {
"scheme": "GB-COH",
"id": "09506232",
"legalName": "Open Data Services Co-operative",
"uri": "https://opencorporates.com/companies/gb/09506232"
},
"roles": [
"buyer"
]
}
],
"buyer": {
"id": "GB-COH-09506232",
"name": "Open Data Services"
},
"tender": {
"id": "ocds-213czf-000-00002-01-tender",
"title": "Data merging tool",
"description": "Creation of a data merging tool. The tool should by written in Python. Proposals should be submitted by e-mail.",
"status": "active",
"value": {
"amount": 2000,
"currency": "USD"
},
"procurementMethod": "open",
"awardCriteria": "bestProposal",
"submissionMethod": [
"electronicSubmission"
],
"tenderPeriod": {
"startDate": "2016-01-31T09:00:00Z",
"endDate": "2016-02-20T18:00:00Z"
},
"awardPeriod": {
"startDate": "2016-04-01T00:00:00Z",
"endDate": "2016-06-01T23:59:59Z"
},
"amendments": [
{
"id": "amendment-1",
"date": "2016-02-04T09:30:00Z",
"rationale": "Based on feedback from potential bidders, the total budget was increased by $1000, and the deadline extended",
"amendsReleaseID": "ocds-213czf-000-00002-01-tender",
"releaseID": "ocds-213czf-000-00002-01-tender-amendment"
}
]
},
"awards": [
{
"id": "ocds-213czf-000-00002-award-supplier-one",
"title": "Award of contract to create the data merging tool.",
"description": "Supplier 1 has been commissioned to create the merge tool. A separate contract will be awarded to write the documentation",
"status": "active",
"date": "2016-03-01T09:30:00Z",
"value": {
"amount": 750,
"currency": "USD"
}
},
{
"id": "ocds-213czf-000-00002-award-supplier-two",
"title": "Award of contract to create the data merging tool.",
"description": "Supplier 2 has been commissioned to create the documentation. A separate contract will be awarded to create the tool",
"status": "active",
"date": "2016-03-03T09:30:00Z",
"value": {
"amount": 750,
"currency": "USD"
}
}
]
},
"versionedRelease": {
"ocid": "ocds-213czf-000-00002",
"language": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": "en"
}
],
"initiationType": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": "tender"
}
],
"parties": [
{
"id": "GB-COH-09506232",
"name": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": "Open Data Services"
}
],
"identifier": {
"scheme": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": "GB-COH"
}
],
"id": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": "09506232"
}
],
"legalName": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": "Open Data Services Co-operative"
}
],
"uri": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": "https://opencorporates.com/companies/gb/09506232"
}
]
},
"roles": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": [
"buyer"
]
}
]
}
],
"buyer": {
"id": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": "GB-COH-09506232"
}
],
"name": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": "Open Data Services"
}
]
},
"tender": {
"id": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": "ocds-213czf-000-00002-01-tender"
}
],
"title": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": "Data merging tool"
}
],
"description": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": "Data merge tool."
},
{
"releaseID": "ocds-213czf-000-00002-01-tender-update",
"releaseDate": "2016-01-31T09:30:00Z",
"releaseTag": [
"tenderUpdate"
],
"value": "Creation of a data merging tool. The tool should by written in Python. Proposals should be submitted by e-mail."
}
],
"status": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": "active"
}
],
"value": {
"amount": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": 1000
},
{
"releaseID": "ocds-213czf-000-00002-01-tender-amendment",
"releaseDate": "2016-02-05T10:30:00Z",
"releaseTag": [
"tenderAmendment"
],
"value": 2000
}
],
"currency": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": "USD"
}
]
},
"procurementMethod": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": "open"
}
],
"awardCriteria": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": "bestProposal"
}
],
"submissionMethod": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": [
"electronicSubmission"
]
}
],
"tenderPeriod": {
"startDate": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": "2016-01-31T09:00:00Z"
}
],
"endDate": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": "2016-02-15T18:00:00Z"
},
{
"releaseID": "ocds-213czf-000-00002-01-tender-amendment",
"releaseDate": "2016-02-05T10:30:00Z",
"releaseTag": [
"tenderAmendment"
],
"value": "2016-02-20T18:00:00Z"
}
]
},
"awardPeriod": {
"startDate": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": "2016-04-01T00:00:00Z"
}
],
"endDate": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": "2016-06-01T23:59:59Z"
}
]
},
"amendments": [
{
"id": "amendment-1",
"date": [
{
"releaseID": "ocds-213czf-000-00002-01-tender-amendment",
"releaseDate": "2016-02-05T10:30:00Z",
"releaseTag": [
"tenderAmendment"
],
"value": "2016-02-04T09:30:00Z"
}
],
"rationale": [
{
"releaseID": "ocds-213czf-000-00002-01-tender-amendment",
"releaseDate": "2016-02-05T10:30:00Z",
"releaseTag": [
"tenderAmendment"
],
"value": "Based on feedback from potential bidders, the total budget was increased by $1000, and the deadline extended"
}
],
"amendsReleaseID": [
{
"releaseID": "ocds-213czf-000-00002-01-tender-amendment",
"releaseDate": "2016-02-05T10:30:00Z",
"releaseTag": [
"tenderAmendment"
],
"value": "ocds-213czf-000-00002-01-tender"
}
],
"releaseID": [
{
"releaseID": "ocds-213czf-000-00002-01-tender-amendment",
"releaseDate": "2016-02-05T10:30:00Z",
"releaseTag": [
"tenderAmendment"
],
"value": "ocds-213czf-000-00002-01-tender-amendment"
}
]
}
]
},
"awards": [
{
"id": "ocds-213czf-000-00002-award-supplier-one",
"title": [
{
"releaseID": "ocds-213czf-000-00002-01-award1",
"releaseDate": "2016-03-01T09:30:00Z",
"releaseTag": [
"award"
],
"value": "Award of contract to create the data merging tool."
}
],
"description": [
{
"releaseID": "ocds-213czf-000-00002-01-award1",
"releaseDate": "2016-03-01T09:30:00Z",
"releaseTag": [
"award"
],
"value": "Supplier 1 has been commissioned to create the merge tool. A separate contract will be awarded to write the documentation"
}
],
"status": [
{
"releaseID": "ocds-213czf-000-00002-01-award1",
"releaseDate": "2016-03-01T09:30:00Z",
"releaseTag": [
"award"
],
"value": "active"
}
],
"date": [
{
"releaseID": "ocds-213czf-000-00002-01-award1",
"releaseDate": "2016-03-01T09:30:00Z",
"releaseTag": [
"award"
],
"value": "2016-03-01T09:30:00Z"
}
],
"value": {
"amount": [
{
"releaseID": "ocds-213czf-000-00002-01-award1",
"releaseDate": "2016-03-01T09:30:00Z",
"releaseTag": [
"award"
],
"value": 750
}
],
"currency": [
{
"releaseID": "ocds-213czf-000-00002-01-award1",
"releaseDate": "2016-03-01T09:30:00Z",
"releaseTag": [
"award"
],
"value": "USD"
}
]
}
},
{
"id": "ocds-213czf-000-00002-award-supplier-two",
"title": [
{
"releaseID": "ocds-213czf-000-00002-01-award2",
"releaseDate": "2016-03-03T09:30:00Z",
"releaseTag": [
"award"
],
"value": "Award of contract to create the data merging tool."
}
],
"description": [
{
"releaseID": "ocds-213czf-000-00002-01-award2",
"releaseDate": "2016-03-03T09:30:00Z",
"releaseTag": [
"award"
],
"value": "Supplier 2 has been commissioned to create the documentation. A separate contract will be awarded to create the tool"
}
],
"status": [
{
"releaseID": "ocds-213czf-000-00002-01-award2",
"releaseDate": "2016-03-03T09:30:00Z",
"releaseTag": [
"award"
],
"value": "active"
}
],
"date": [
{
"releaseID": "ocds-213czf-000-00002-01-award2",
"releaseDate": "2016-03-03T09:30:00Z",
"releaseTag": [
"award"
],
"value": "2016-03-03T09:30:00Z"
}
],
"value": {
"amount": [
{
"releaseID": "ocds-213czf-000-00002-01-award2",
"releaseDate": "2016-03-03T09:30:00Z",
"releaseTag": [
"award"
],
"value": 750
}
],
"currency": [
{
"releaseID": "ocds-213czf-000-00002-01-award2",
"releaseDate": "2016-03-03T09:30:00Z",
"releaseTag": [
"award"
],
"value": "USD"
}
]
}
}
]
}
}
]
}
Merging specification¶
Discarded fields¶
In the release schema, "omitWhenMerged": true is declared on fields that must be discarded during merging. These are presently: id, date and tag.
For a compiled release:
Both the fields and their values are discarded, because they are metadata about the individual releases; the compiled release replaces these with its own metadata.
For a versioned release:
The fields are discarded, but their values are moved, as described below, in order to indicate from which releases each other field value is taken.
If omitWhenMerged is set to false, ignore it.
Note
The compiled release presently uses the same schema as the release schema, which means that the id, date and tag fields are required in a compiled release. We invite discussion on whether to change these requirements in a separate compiled release schema in issue #330, and on how to identify and date compiled and versioned releases in issue #834.
In the meantime, an intermediate solution is to set tag to ["compiled"], date to the date of the most recent release, and id to {ocid}-{date}, like in the reference implementation of the merge routine.
Versioned values¶
To convert a field's value in a release to a versioned value, you must:
Create an empty JSON object
Set its
releaseID,releaseDate,releaseTagfields to the release'sid,date,tagvaluesSet its
valuefield to the field's value in the release
A versioned value thus describes a field's value in a specific release.
For example, in the above worked example, the estimated value of the procurement was $1,000 in a release (tender/value/amount was 1000). Following the steps above, the versioned value is:
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": 1000
}
In a versioned release, with a few exceptions, a field's value is replaced with an array of versioned values, which should be in chronological order by releaseDate.
For example, in the above worked example, the estimated value was $1,000 in a release published January 1, 2016 and then $2,000 in a release published February 5, 2016. In a versioned release, this is serialized as below:
{
"amount": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": 1000
},
{
"releaseID": "ocds-213czf-000-00002-01-tender-amendment",
"releaseDate": "2016-02-05T10:30:00Z",
"releaseTag": [
"tenderAmendment"
],
"value": 2000
}
],
"currency": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": "USD"
}
]
}
{
"uri": "https://standard.open-contracting.org/examples/records/ocds-213czf-000-00002-merge.json",
"publisher": {
"scheme": "GB-COH",
"uid": "09506232",
"name": "Open Data Services Co-operative Limited",
"uri": "https://standard.open-contracting.org/examples/"
},
"publishedDate": "2016-03-05T13:02:00Z",
"license": "http://opendatacommons.org/licenses/pddl/1.0/",
"publicationPolicy": "https://github.com/open-contracting/sample-data/",
"version": "1.1",
"packages": [
"https://standard.open-contracting.org/examples/releases/ocds-213czf-000-00002-01-award1.json",
"https://standard.open-contracting.org/examples/releases/ocds-213czf-000-00002-01-award2.json",
"https://standard.open-contracting.org/examples/releases/ocds-213czf-000-00002-01-tender.json",
"https://standard.open-contracting.org/examples/releases/ocds-213czf-000-00002-01-tender-update.json",
"https://standard.open-contracting.org/examples/releases/ocds-213czf-000-00002-01-tender-amendment.json"
],
"records": [
{
"ocid": "ocds-213czf-000-00002",
"releases": [
{
"url": "https://standard.open-contracting.org/examples/releases/ocds-213czf-000-00002-01-award1.json#ocds-213czf-000-00002-01-award1",
"date": "2016-03-01T09:30:00Z",
"tag": [
"award"
]
},
{
"url": "https://standard.open-contracting.org/examples/releases/ocds-213czf-000-00002-01-award2.json#ocds-213czf-000-00002-01-award2",
"date": "2016-03-03T09:30:00Z",
"tag": [
"award"
]
},
{
"url": "https://standard.open-contracting.org/examples/releases/ocds-213czf-000-00002-01-tender.json#ocds-213czf-000-00002-01-tender",
"date": "2016-01-01T09:30:00Z",
"tag": [
"tender"
]
},
{
"url": "https://standard.open-contracting.org/examples/releases/ocds-213czf-000-00002-01-tender-update.json#ocds-213czf-000-00002-01-tender-update",
"date": "2016-01-31T09:30:00Z",
"tag": [
"tenderUpdate"
]
},
{
"url": "https://standard.open-contracting.org/examples/releases/ocds-213czf-000-00002-01-tender-amendment.json#ocds-213czf-000-00002-01-tender-amendment",
"date": "2016-02-05T10:30:00Z",
"tag": [
"tenderAmendment"
]
}
],
"compiledRelease": {
"tag": [
"compiled"
],
"id": "ocds-213czf-000-00002-2016-03-03T09:30:00Z",
"date": "2016-03-03T09:30:00Z",
"ocid": "ocds-213czf-000-00002",
"language": "en",
"initiationType": "tender",
"parties": [
{
"id": "GB-COH-09506232",
"name": "Open Data Services",
"identifier": {
"scheme": "GB-COH",
"id": "09506232",
"legalName": "Open Data Services Co-operative",
"uri": "https://opencorporates.com/companies/gb/09506232"
},
"roles": [
"buyer"
]
}
],
"buyer": {
"id": "GB-COH-09506232",
"name": "Open Data Services"
},
"tender": {
"id": "ocds-213czf-000-00002-01-tender",
"title": "Data merging tool",
"description": "Creation of a data merging tool. The tool should by written in Python. Proposals should be submitted by e-mail.",
"status": "active",
"value": {
"amount": 2000,
"currency": "USD"
},
"procurementMethod": "open",
"awardCriteria": "bestProposal",
"submissionMethod": [
"electronicSubmission"
],
"tenderPeriod": {
"startDate": "2016-01-31T09:00:00Z",
"endDate": "2016-02-20T18:00:00Z"
},
"awardPeriod": {
"startDate": "2016-04-01T00:00:00Z",
"endDate": "2016-06-01T23:59:59Z"
},
"amendments": [
{
"id": "amendment-1",
"date": "2016-02-04T09:30:00Z",
"rationale": "Based on feedback from potential bidders, the total budget was increased by $1000, and the deadline extended",
"amendsReleaseID": "ocds-213czf-000-00002-01-tender",
"releaseID": "ocds-213czf-000-00002-01-tender-amendment"
}
]
},
"awards": [
{
"id": "ocds-213czf-000-00002-award-supplier-one",
"title": "Award of contract to create the data merging tool.",
"description": "Supplier 1 has been commissioned to create the merge tool. A separate contract will be awarded to write the documentation",
"status": "active",
"date": "2016-03-01T09:30:00Z",
"value": {
"amount": 750,
"currency": "USD"
}
},
{
"id": "ocds-213czf-000-00002-award-supplier-two",
"title": "Award of contract to create the data merging tool.",
"description": "Supplier 2 has been commissioned to create the documentation. A separate contract will be awarded to create the tool",
"status": "active",
"date": "2016-03-03T09:30:00Z",
"value": {
"amount": 750,
"currency": "USD"
}
}
]
},
"versionedRelease": {
"ocid": "ocds-213czf-000-00002",
"language": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": "en"
}
],
"initiationType": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": "tender"
}
],
"parties": [
{
"id": "GB-COH-09506232",
"name": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": "Open Data Services"
}
],
"identifier": {
"scheme": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": "GB-COH"
}
],
"id": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": "09506232"
}
],
"legalName": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": "Open Data Services Co-operative"
}
],
"uri": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": "https://opencorporates.com/companies/gb/09506232"
}
]
},
"roles": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": [
"buyer"
]
}
]
}
],
"buyer": {
"id": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": "GB-COH-09506232"
}
],
"name": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": "Open Data Services"
}
]
},
"tender": {
"id": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": "ocds-213czf-000-00002-01-tender"
}
],
"title": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": "Data merging tool"
}
],
"description": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": "Data merge tool."
},
{
"releaseID": "ocds-213czf-000-00002-01-tender-update",
"releaseDate": "2016-01-31T09:30:00Z",
"releaseTag": [
"tenderUpdate"
],
"value": "Creation of a data merging tool. The tool should by written in Python. Proposals should be submitted by e-mail."
}
],
"status": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": "active"
}
],
"value": {
"amount": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": 1000
},
{
"releaseID": "ocds-213czf-000-00002-01-tender-amendment",
"releaseDate": "2016-02-05T10:30:00Z",
"releaseTag": [
"tenderAmendment"
],
"value": 2000
}
],
"currency": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": "USD"
}
]
},
"procurementMethod": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": "open"
}
],
"awardCriteria": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": "bestProposal"
}
],
"submissionMethod": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": [
"electronicSubmission"
]
}
],
"tenderPeriod": {
"startDate": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": "2016-01-31T09:00:00Z"
}
],
"endDate": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": "2016-02-15T18:00:00Z"
},
{
"releaseID": "ocds-213czf-000-00002-01-tender-amendment",
"releaseDate": "2016-02-05T10:30:00Z",
"releaseTag": [
"tenderAmendment"
],
"value": "2016-02-20T18:00:00Z"
}
]
},
"awardPeriod": {
"startDate": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": "2016-04-01T00:00:00Z"
}
],
"endDate": [
{
"releaseID": "ocds-213czf-000-00002-01-tender",
"releaseDate": "2016-01-01T09:30:00Z",
"releaseTag": [
"tender"
],
"value": "2016-06-01T23:59:59Z"
}
]
},
"amendments": [
{
"id": "amendment-1",
"date": [
{
"releaseID": "ocds-213czf-000-00002-01-tender-amendment",
"releaseDate": "2016-02-05T10:30:00Z",
"releaseTag": [
"tenderAmendment"
],
"value": "2016-02-04T09:30:00Z"
}
],
"rationale": [
{
"releaseID": "ocds-213czf-000-00002-01-tender-amendment",
"releaseDate": "2016-02-05T10:30:00Z",
"releaseTag": [
"tenderAmendment"
],
"value": "Based on feedback from potential bidders, the total budget was increased by $1000, and the deadline extended"
}
],
"amendsReleaseID": [
{
"releaseID": "ocds-213czf-000-00002-01-tender-amendment",
"releaseDate": "2016-02-05T10:30:00Z",
"releaseTag": [
"tenderAmendment"
],
"value": "ocds-213czf-000-00002-01-tender"
}
],
"releaseID": [
{
"releaseID": "ocds-213czf-000-00002-01-tender-amendment",
"releaseDate": "2016-02-05T10:30:00Z",
"releaseTag": [
"tenderAmendment"
],
"value": "ocds-213czf-000-00002-01-tender-amendment"
}
]
}
]
},
"awards": [
{
"id": "ocds-213czf-000-00002-award-supplier-one",
"title": [
{
"releaseID": "ocds-213czf-000-00002-01-award1",
"releaseDate": "2016-03-01T09:30:00Z",
"releaseTag": [
"award"
],
"value": "Award of contract to create the data merging tool."
}
],
"description": [
{
"releaseID": "ocds-213czf-000-00002-01-award1",
"releaseDate": "2016-03-01T09:30:00Z",
"releaseTag": [
"award"
],
"value": "Supplier 1 has been commissioned to create the merge tool. A separate contract will be awarded to write the documentation"
}
],
"status": [
{
"releaseID": "ocds-213czf-000-00002-01-award1",
"releaseDate": "2016-03-01T09:30:00Z",
"releaseTag": [
"award"
],
"value": "active"
}
],
"date": [
{
"releaseID": "ocds-213czf-000-00002-01-award1",
"releaseDate": "2016-03-01T09:30:00Z",
"releaseTag": [
"award"
],
"value": "2016-03-01T09:30:00Z"
}
],
"value": {
"amount": [
{
"releaseID": "ocds-213czf-000-00002-01-award1",
"releaseDate": "2016-03-01T09:30:00Z",
"releaseTag": [
"award"
],
"value": 750
}
],
"currency": [
{
"releaseID": "ocds-213czf-000-00002-01-award1",
"releaseDate": "2016-03-01T09:30:00Z",
"releaseTag": [
"award"
],
"value": "USD"
}
]
}
},
{
"id": "ocds-213czf-000-00002-award-supplier-two",
"title": [
{
"releaseID": "ocds-213czf-000-00002-01-award2",
"releaseDate": "2016-03-03T09:30:00Z",
"releaseTag": [
"award"
],
"value": "Award of contract to create the data merging tool."
}
],
"description": [
{
"releaseID": "ocds-213czf-000-00002-01-award2",
"releaseDate": "2016-03-03T09:30:00Z",
"releaseTag": [
"award"
],
"value": "Supplier 2 has been commissioned to create the documentation. A separate contract will be awarded to create the tool"
}
],
"status": [
{
"releaseID": "ocds-213czf-000-00002-01-award2",
"releaseDate": "2016-03-03T09:30:00Z",
"releaseTag": [
"award"
],
"value": "active"
}
],
"date": [
{
"releaseID": "ocds-213czf-000-00002-01-award2",
"releaseDate": "2016-03-03T09:30:00Z",
"releaseTag": [
"award"
],
"value": "2016-03-03T09:30:00Z"
}
],
"value": {
"amount": [
{
"releaseID": "ocds-213czf-000-00002-01-award2",
"releaseDate": "2016-03-03T09:30:00Z",
"releaseTag": [
"award"
],
"value": 750
}
],
"currency": [
{
"releaseID": "ocds-213czf-000-00002-01-award2",
"releaseDate": "2016-03-03T09:30:00Z",
"releaseTag": [
"award"
],
"value": "USD"
}
]
}
}
]
}
}
]
}
The structure of the versioned release is described by the versioned release schema; note that the ocid field's value is not versioned.
Merge routine¶
To create a compiled or versioned release, you must:
Get all releases with the same
ocidvalueOrder the releases in chronological order by
dateCreate an empty JSON object for the compiled or versioned release
Merge each release (input), in order, into the JSON object (output), as follows:
Object values¶
The release is itself an object, so this case is encountered first.
If the object is empty in input, do nothing. For each field within the object in input:
For a compiled release:
If the field in input has a value of
null, remove the field from the object in output, if presentIf the field isn't in output, add the field to the object in output, and set it to its value in input
If the field is in output, merge the field's values in output and input according to the merge routine
For a versioned release:
Merge the field's values in output and input according to the merge routine; if there is a result, add the field to the object in output if not already added, and set it to the result
Literal values¶
If the input value is neither an object nor an array, then:
For a compiled release:
If the input value is different from the output value, replace the output value with the input value
For a versioned release:
If there is no output value, set the output value to an empty JSON array, convert the input value to a versioned value, and append it to the new array of versioned values in output
If the input value is different from the value of the
valuefield of the most recent versioned value in output, convert the input value to a versioned value, and append it to the array of versioned values in output
Array values¶
If the input array contains anything other than objects, treat the array as a literal value. Otherwise, there are two sub-routines for arrays of objects: whole list merge and identifier merge.
Whole list merge¶
An input array must be treated as a literal value if the corresponding field in a dereferenced copy of the release schema has "array" in its type and if any of the following are also true:
The field has
"wholeListMerge": trueThe field sets
items/type, and has anything other than"object"initems/typeThe field has
"object"in itsitems/type, setsitems/properties, and has noidfield initems/properties
Identifier merge¶
This case is encountered if the above conditions aren't met. If the array is empty in input, do nothing. For each object within the array in input:
For a compiled release:
If there is an object in the array in output with the same
idvalue as the object in input, merge the matching objects in input and output according to the merge routineOtherwise, append the object in input to the array in output
For a versioned release:
If there is an object in the array in output with the same
idvalue as the object in input, merge the matching objects in input and output according to the merge routine except for theidfield, which is not versioned and instead kept as-isOtherwise, merge an empty JSON object and the object in input according to the merge routine except for the
idfield, which is not versioned and instead kept as-is, and append the result to the array in output
Note
In this case, to remove an object from an array, you need to instead set each of its fields to null. We invite discussion on how to remove objects from arrays in issue #232.
Note
In the release schema, "versionId": true is declared on id fields that must be versioned. This is only for convenience and might be removed in future versions of OCDS (see issue #812). If "versionId": true is declared on the id field of an object within an array, it is ignored. "versionId": false has no meaning and is ignored.
Reference implementation¶
A reference implementation of the merge routine is available in Python on GitHub. We strongly encourage any re-implementations to read its commented code and use its test cases, to ensure correctness.