Supported tables

Spoonbill tool supports following core OCDS tables:

tables

Tables name	Extraction paths	Child tables names
tenders	/tender	tenders_items,tenders_tenderers
awards	/awards	awards_suppliers,awards_items
contracts	/contracts	contracts_items,contracts_relatedProcesses,transactions
planning	/planning
parties	/parties,/buyer	parties_ids
documents	/planning/documents,/tender/documents,/awards/documents,/contracts/documents,/contracts/implementation/documents
milestones	/planning/milestones,/tender/milestones,/contracts/milestones,/contracts/implementation/milestones
amendments	/planning/amendments,/tender/amendments,/awards/amendments,/contracts/amendments,/contracts/implementation/amendments
contracts_items	/contracts/items	contracts_items_class
contracts_relatedProcesses	/contracts/relatedProcesses
transactions	/contracts/implementation/transactions
contracts_items_class	/contracts/items/additionalClassifications
awards_suppliers	/awards/suppliers
awards_items	/awards/items	awards_items_class
awards_items_class	/awards/items/additionalClassifications
tenders_items	/tender/items	tenders_items_class
tenders_tenderers	/tender/tenderers
tenders_items_class	/tender/items/additionalClassifications
parties_ids	/parties/additionalIdentifiers

Table Name	Table columns
tenders	ocid,id,rowID,parentID,/tender/id,/tender/title,/tender/description,/tender/status,/tender/procurementMethod,/tender/procurementMethodDetails,/tender/procurementMethodRationale,/tender/mainProcurementCategory,/tender/additionalProcurementCategories,/tender/awardCriteria,/tender/awardCriteriaDetails,/tender/submissionMethod,/tender/submissionMethodDetails,/tender/hasEnquiries,/tender/eligibilityCriteria,/tender/numberOfTenderers,/tender/tenderers/name,/tender/tenderers/id,/tender/tenderers/name,/tender/tenderers/id,/tender/contractPeriod/startDate,/tender/contractPeriod/endDate,/tender/contractPeriod/maxExtentDate,/tender/contractPeriod/durationInDays,/tender/awardPeriod/startDate,/tender/awardPeriod/endDate,/tender/awardPeriod/maxExtentDate,/tender/awardPeriod/durationInDays,/tender/enquiryPeriod/startDate,/tender/enquiryPeriod/endDate,/tender/enquiryPeriod/maxExtentDate,/tender/enquiryPeriod/durationInDays,/tender/tenderPeriod/startDate,/tender/tenderPeriod/endDate,/tender/tenderPeriod/maxExtentDate,/tender/tenderPeriod/durationInDays,/tender/minValue/amount,/tender/minValue/currency,/tender/value/amount,/tender/value/currency,/tender/items/id,/tender/items/description,/tender/items/quantity,/tender/items/unit/scheme,/tender/items/unit/id,/tender/items/unit/name,/tender/items/unit/uri,/tender/items/unit/value/amount,/tender/items/unit/value/currency,/tender/items/additionalClassifications/scheme,/tender/items/additionalClassifications/id,/tender/items/additionalClassifications/description,/tender/items/additionalClassifications/uri,/tender/items/classification/scheme,/tender/items/classification/id,/tender/items/classification/description,/tender/items/classification/uri,/tender/procuringEntity/name,/tender/procuringEntity/id
awards	ocid,id,rowID,parentID,/awards/id,/awards/title,/awards/description,/awards/status,/awards/date,/awards/contractPeriod/startDate,/awards/contractPeriod/endDate,/awards/contractPeriod/maxExtentDate,/awards/contractPeriod/durationInDays,/awards/items/id,/awards/items/description,/awards/items/quantity,/awards/items/unit/scheme,/awards/items/unit/id,/awards/items/unit/name,/awards/items/unit/uri,/awards/items/unit/value/amount,/awards/items/unit/value/currency,/awards/items/additionalClassifications/scheme,/awards/items/additionalClassifications/id,/awards/items/additionalClassifications/description,/awards/items/additionalClassifications/uri,/awards/items/classification/scheme,/awards/items/classification/id,/awards/items/classification/description,/awards/items/classification/uri,/awards/suppliers/name,/awards/suppliers/id,/awards/value/amount,/awards/value/currency
contracts	ocid,id,rowID,parentID,/contracts/id,/contracts/awardID,/contracts/title,/contracts/description,/contracts/status,/contracts/dateSigned,/contracts/relatedProcesses/id,/contracts/relatedProcesses/relationship,/contracts/relatedProcesses/title,/contracts/relatedProcesses/scheme,/contracts/relatedProcesses/identifier,/contracts/relatedProcesses/uri,/contracts/implementation/transactions/id,/contracts/implementation/transactions/source,/contracts/implementation/transactions/date,/contracts/implementation/transactions/uri,/contracts/implementation/transactions/payee/name,/contracts/implementation/transactions/payee/id,/contracts/implementation/transactions/payer/name,/contracts/implementation/transactions/payer/id,/contracts/implementation/transactions/value/amount,/contracts/implementation/transactions/value/currency,/contracts/implementation/transactions/id,/contracts/implementation/transactions/source,/contracts/implementation/transactions/date,/contracts/implementation/transactions/uri,/contracts/implementation/transactions/payee/name,/contracts/implementation/transactions/payee/id,/contracts/implementation/transactions/payer/name,/contracts/implementation/transactions/payer/id,/contracts/implementation/transactions/value/amount,/contracts/implementation/transactions/value/currency,/contracts/items/id,/contracts/items/description,/contracts/items/quantity,/contracts/items/unit/scheme,/contracts/items/unit/id,/contracts/items/unit/name,/contracts/items/unit/uri,/contracts/items/unit/value/amount,/contracts/items/unit/value/currency,/contracts/items/additionalClassifications/scheme,/contracts/items/additionalClassifications/id,/contracts/items/additionalClassifications/description,/contracts/items/additionalClassifications/uri,/contracts/items/classification/scheme,/contracts/items/classification/id,/contracts/items/classification/description,/contracts/items/classification/uri,/contracts/value/amount,/contracts/value/currency,/contracts/period/startDate,/contracts/period/endDate,/contracts/period/maxExtentDate,/contracts/period/durationInDays
planning	ocid,id,rowID,parentID,/planning/rationale,/planning/budget/id,/planning/budget/description,/planning/budget/project,/planning/budget/projectID,/planning/budget/uri,/planning/budget/amount/amount,/planning/budget/amount/currency
parties	ocid,id,rowID,parentID,/buyer/name,/buyer/id,/parties/name,/parties/id,/parties/roles,/parties/contactPoint/name,/parties/contactPoint/email,/parties/contactPoint/telephone,/parties/contactPoint/faxNumber,/parties/contactPoint/url,/parties/address/streetAddress,/parties/address/locality,/parties/address/region,/parties/address/postalCode,/parties/address/countryName,/parties/identifier/scheme,/parties/identifier/id,/parties/identifier/legalName,/parties/identifier/uri,/parties/test
documents	ocid,id,rowID,parentID,parentTable,/documents/id,/documents/documentType,/documents/title,/documents/description,/documents/url,/documents/datePublished,/documents/dateModified,/documents/format,/documents/language
milestones	ocid,id,rowID,parentID,parentTable,/milestones/id,/milestones/title,/milestones/type,/milestones/description,/milestones/code,/milestones/dueDate,/milestones/dateMet,/milestones/dateModified,/milestones/status
amendments	ocid,id,rowID,parentID,parentTable,/amendments/date,/amendments/rationale,/amendments/id,/amendments/description,/amendments/amendsReleaseID,/amendments/releaseID
contracts_items	ocid,id,rowID,parentID,parentTable,/contracts/items/id,/contracts/items/description,/contracts/items/quantity,/contracts/items/unit/scheme,/contracts/items/unit/id,/contracts/items/unit/name,/contracts/items/unit/uri,/contracts/items/unit/value/amount,/contracts/items/unit/value/currency,/contracts/items/additionalClassifications/scheme,/contracts/items/additionalClassifications/id,/contracts/items/additionalClassifications/description,/contracts/items/additionalClassifications/uri,/contracts/items/classification/scheme,/contracts/items/classification/id,/contracts/items/classification/description,/contracts/items/classification/uri
contracts_relatedProcesses	ocid,id,rowID,parentID,parentTable,/contracts/relatedProcesses/id,/contracts/relatedProcesses/relationship,/contracts/relatedProcesses/title,/contracts/relatedProcesses/scheme,/contracts/relatedProcesses/identifier,/contracts/relatedProcesses/uri
transactions	ocid,id,rowID,parentID,parentTable,/contracts/implementation/transactions/id,/contracts/implementation/transactions/source,/contracts/implementation/transactions/date,/contracts/implementation/transactions/uri,/contracts/implementation/transactions/payee/name,/contracts/implementation/transactions/payee/id,/contracts/implementation/transactions/payer/name,/contracts/implementation/transactions/payer/id,/contracts/implementation/transactions/value/amount,/contracts/implementation/transactions/value/currency
contracts_items_class	ocid,id,rowID,parentID,parentTable,/contracts/items/additionalClassifications/scheme,/contracts/items/additionalClassifications/id,/contracts/items/additionalClassifications/description,/contracts/items/additionalClassifications/uri
awards_suppliers	ocid,id,rowID,parentID,parentTable,/awards/suppliers/name,/awards/suppliers/id
awards_items	ocid,id,rowID,parentID,parentTable,/awards/items/id,/awards/items/description,/awards/items/quantity,/awards/items/unit/scheme,/awards/items/unit/id,/awards/items/unit/name,/awards/items/unit/uri,/awards/items/unit/value/amount,/awards/items/unit/value/currency,/awards/items/additionalClassifications/scheme,/awards/items/additionalClassifications/id,/awards/items/additionalClassifications/description,/awards/items/additionalClassifications/uri,/awards/items/classification/scheme,/awards/items/classification/id,/awards/items/classification/description,/awards/items/classification/uri
awards_items_class	ocid,id,rowID,parentID,parentTable,/awards/items/additionalClassifications/scheme,/awards/items/additionalClassifications/id,/awards/items/additionalClassifications/description,/awards/items/additionalClassifications/uri
tenders_items	ocid,id,rowID,parentID,parentTable,/tender/items/id,/tender/items/description,/tender/items/quantity,/tender/items/unit/scheme,/tender/items/unit/id,/tender/items/unit/name,/tender/items/unit/uri,/tender/items/unit/value/amount,/tender/items/unit/value/currency,/tender/items/additionalClassifications/scheme,/tender/items/additionalClassifications/id,/tender/items/additionalClassifications/description,/tender/items/additionalClassifications/uri,/tender/items/classification/scheme,/tender/items/classification/id,/tender/items/classification/description,/tender/items/classification/uri
tenders_tenderers	ocid,id,rowID,parentID,parentTable,/tender/tenderers/name,/tender/tenderers/id
tenders_items_class	ocid,id,rowID,parentID,parentTable,/tender/items/additionalClassifications/scheme,/tender/items/additionalClassifications/id,/tender/items/additionalClassifications/description,/tender/items/additionalClassifications/uri
parties_ids	ocid,id,rowID,parentID,parentTable,/parties/additionalIdentifiers/scheme,/parties/additionalIdentifiers/id,/parties/additionalIdentifiers/legalName,/parties/additionalIdentifiers/uri