{"version":"1.0.0","snapshot":{"snapshotSha256":"7d6e677299352a7b989393edc6a851c0822df0e5f2355d2bd0f6d0b3c86192df","schemaVersion":4,"classificationVersion":"wellficent-source-purpose-v2","classificationSha256":"83e4157601b4d73cb883d6e8578f9fe1ea467bb929d96a74071d77068ee8ca48","shardCount":4},"filters":{"spudFrom":"1973","spudTo":"1973"},"records":221,"sourceWellFamilies":218,"additionalFamilyRows":3,"purposeClassification":{"classified":218,"unclassified":3,"ruleVersion":"wellficent-source-purpose-v2","ruleSha256":"83e4157601b4d73cb883d6e8578f9fe1ea467bb929d96a74071d77068ee8ca48","kind":"derived-from-source-purpose","independentOutcomeLabel":false},"fields":{"operator":{"present":203,"missing":18,"missingFraction":0.08144796380090498},"sourceStatus":{"present":217,"missing":4,"missingFraction":0.01809954751131222},"spudDate":{"present":221,"missing":0,"missingFraction":0},"measuredDepthM":{"present":213,"missing":8,"missingFraction":0.03619909502262444}},"catalogues":[{"catalogue":"israel-petroleum-2020","records":3,"sourceWellFamilies":3,"unclassifiedPurpose":3,"fields":{"operator":{"present":3,"missing":0,"missingFraction":0},"sourceStatus":{"present":0,"missing":3,"missingFraction":1},"spudDate":{"present":3,"missing":0,"missingFraction":0},"measuredDepthM":{"present":0,"missing":3,"missingFraction":1}},"sourceAsOf":"2020-07-06","checkedAt":"2026-10-02","commercialUseAllowed":null,"catalogueCard":"https://wellficent.com/api/v1/wells/catalogues/israel-petroleum-2020"},{"catalogue":"netherlands-nlog","records":82,"sourceWellFamilies":82,"unclassifiedPurpose":0,"fields":{"operator":{"present":82,"missing":0,"missingFraction":0},"sourceStatus":{"present":82,"missing":0,"missingFraction":0},"spudDate":{"present":82,"missing":0,"missingFraction":0},"measuredDepthM":{"present":82,"missing":0,"missingFraction":0}},"sourceAsOf":null,"checkedAt":"2026-10-02","commercialUseAllowed":null,"catalogueCard":"https://wellficent.com/api/v1/wells/catalogues/netherlands-nlog"},{"catalogue":"new-zealand-nzpam","records":3,"sourceWellFamilies":3,"unclassifiedPurpose":0,"fields":{"operator":{"present":2,"missing":1,"missingFraction":0.3333333333333333},"sourceStatus":{"present":2,"missing":1,"missingFraction":0.3333333333333333},"spudDate":{"present":3,"missing":0,"missingFraction":0},"measuredDepthM":{"present":3,"missing":0,"missingFraction":0}},"sourceAsOf":null,"checkedAt":"2026-10-02","commercialUseAllowed":null,"catalogueCard":"https://wellficent.com/api/v1/wells/catalogues/new-zealand-nzpam"},{"catalogue":"norway-sodir","records":23,"sourceWellFamilies":23,"unclassifiedPurpose":0,"fields":{"operator":{"present":23,"missing":0,"missingFraction":0},"sourceStatus":{"present":23,"missing":0,"missingFraction":0},"spudDate":{"present":23,"missing":0,"missingFraction":0},"measuredDepthM":{"present":23,"missing":0,"missingFraction":0}},"sourceAsOf":null,"checkedAt":"2026-10-02","commercialUseAllowed":null,"catalogueCard":"https://wellficent.com/api/v1/wells/catalogues/norway-sodir"},{"catalogue":"uk-nsta-offshore","records":92,"sourceWellFamilies":89,"unclassifiedPurpose":0,"fields":{"operator":{"present":92,"missing":0,"missingFraction":0},"sourceStatus":{"present":92,"missing":0,"missingFraction":0},"spudDate":{"present":92,"missing":0,"missingFraction":0},"measuredDepthM":{"present":88,"missing":4,"missingFraction":0.043478260869565216}},"sourceAsOf":null,"checkedAt":"2026-10-02","commercialUseAllowed":null,"catalogueCard":"https://wellficent.com/api/v1/wells/catalogues/uk-nsta-offshore"},{"catalogue":"uk-nsta-onshore","records":18,"sourceWellFamilies":18,"unclassifiedPurpose":0,"fields":{"operator":{"present":1,"missing":17,"missingFraction":0.9444444444444444},"sourceStatus":{"present":18,"missing":0,"missingFraction":0},"spudDate":{"present":18,"missing":0,"missingFraction":0},"measuredDepthM":{"present":17,"missing":1,"missingFraction":0.05555555555555555}},"sourceAsOf":null,"checkedAt":"2026-10-02","commercialUseAllowed":false,"catalogueCard":"https://wellficent.com/api/v1/wells/catalogues/uk-nsta-onshore"}],"rowQuality":{"ruleVersion":"wellficent-row-quality-v1","checks":["completion-before-spud","measured-depth-reference-unreported"],"scope":"Per-row source consistency checks retain original facts. Empty flags are not a guarantee of correctness."},"semantics":["Nulls are not imputed.","Additional family rows include sidetracks and boreholes, not established physical duplicates.","Completeness does not prove source accuracy, predictive performance or current operations."],"sortContract":{"default":"name","tieBreaker":"id ascending","nulls":"last for nullable sort fields","textCollation":"SQLite NOCASE (ASCII case folding)","available":["name","spud","spud-oldest","depth","operator","status","source-id"]}}