{"version":"1.0.0","snapshot":{"snapshotSha256":"7d6e677299352a7b989393edc6a851c0822df0e5f2355d2bd0f6d0b3c86192df","schemaVersion":4,"classificationVersion":"wellficent-source-purpose-v2","classificationSha256":"83e4157601b4d73cb883d6e8578f9fe1ea467bb929d96a74071d77068ee8ca48","shardCount":4},"filters":{"query":"1094"},"records":17,"sourceWellFamilies":17,"additionalFamilyRows":0,"purposeClassification":{"classified":9,"unclassified":8,"ruleVersion":"wellficent-source-purpose-v2","ruleSha256":"83e4157601b4d73cb883d6e8578f9fe1ea467bb929d96a74071d77068ee8ca48","kind":"derived-from-source-purpose","independentOutcomeLabel":false},"fields":{"operator":{"present":2,"missing":15,"missingFraction":0.8823529411764706},"sourceStatus":{"present":12,"missing":5,"missingFraction":0.29411764705882354},"spudDate":{"present":2,"missing":15,"missingFraction":0.8823529411764706},"measuredDepthM":{"present":2,"missing":15,"missingFraction":0.8823529411764706}},"catalogues":[{"catalogue":"california-calgem-geothermal","records":1,"sourceWellFamilies":1,"unclassifiedPurpose":0,"fields":{"operator":{"present":0,"missing":1,"missingFraction":1},"sourceStatus":{"present":1,"missing":0,"missingFraction":0},"spudDate":{"present":0,"missing":1,"missingFraction":1},"measuredDepthM":{"present":0,"missing":1,"missingFraction":1}},"sourceAsOf":null,"checkedAt":"2026-10-02","commercialUseAllowed":null,"catalogueCard":"https://wellficent.com/api/v1/wells/catalogues/california-calgem-geothermal"},{"catalogue":"canada-bcer","records":9,"sourceWellFamilies":9,"unclassifiedPurpose":2,"fields":{"operator":{"present":0,"missing":9,"missingFraction":1},"sourceStatus":{"present":9,"missing":0,"missingFraction":0},"spudDate":{"present":0,"missing":9,"missingFraction":1},"measuredDepthM":{"present":0,"missing":9,"missingFraction":1}},"sourceAsOf":null,"checkedAt":"2026-10-02","commercialUseAllowed":null,"catalogueCard":"https://wellficent.com/api/v1/wells/catalogues/canada-bcer"},{"catalogue":"jordan-water-ufz","records":5,"sourceWellFamilies":5,"unclassifiedPurpose":5,"fields":{"operator":{"present":0,"missing":5,"missingFraction":1},"sourceStatus":{"present":0,"missing":5,"missingFraction":1},"spudDate":{"present":0,"missing":5,"missingFraction":1},"measuredDepthM":{"present":0,"missing":5,"missingFraction":1}},"sourceAsOf":null,"checkedAt":"2026-10-02","commercialUseAllowed":null,"catalogueCard":"https://wellficent.com/api/v1/wells/catalogues/jordan-water-ufz"},{"catalogue":"netherlands-nlog","records":1,"sourceWellFamilies":1,"unclassifiedPurpose":0,"fields":{"operator":{"present":1,"missing":0,"missingFraction":0},"sourceStatus":{"present":1,"missing":0,"missingFraction":0},"spudDate":{"present":1,"missing":0,"missingFraction":0},"measuredDepthM":{"present":1,"missing":0,"missingFraction":0}},"sourceAsOf":null,"checkedAt":"2026-10-02","commercialUseAllowed":null,"catalogueCard":"https://wellficent.com/api/v1/wells/catalogues/netherlands-nlog"},{"catalogue":"norway-sodir","records":1,"sourceWellFamilies":1,"unclassifiedPurpose":1,"fields":{"operator":{"present":1,"missing":0,"missingFraction":0},"sourceStatus":{"present":1,"missing":0,"missingFraction":0},"spudDate":{"present":1,"missing":0,"missingFraction":0},"measuredDepthM":{"present":1,"missing":0,"missingFraction":0}},"sourceAsOf":null,"checkedAt":"2026-10-02","commercialUseAllowed":null,"catalogueCard":"https://wellficent.com/api/v1/wells/catalogues/norway-sodir"}],"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"]}}