{"version":"1.0.0","snapshot":{"snapshotSha256":"7d6e677299352a7b989393edc6a851c0822df0e5f2355d2bd0f6d0b3c86192df","schemaVersion":4,"classificationVersion":"wellficent-source-purpose-v2","classificationSha256":"83e4157601b4d73cb883d6e8578f9fe1ea467bb929d96a74071d77068ee8ca48","shardCount":4},"filters":{},"records":71431,"sourceWellFamilies":62174,"additionalFamilyRows":9257,"purposeClassification":{"classified":53652,"unclassified":17779,"ruleVersion":"wellficent-source-purpose-v2","ruleSha256":"83e4157601b4d73cb883d6e8578f9fe1ea467bb929d96a74071d77068ee8ca48","kind":"derived-from-source-purpose","independentOutcomeLabel":false},"fields":{"operator":{"present":30796,"missing":40635,"missingFraction":0.5688706583976145},"sourceStatus":{"present":63412,"missing":8019,"missingFraction":0.11226218308577508},"spudDate":{"present":32331,"missing":39100,"missingFraction":0.5473813890327729},"measuredDepthM":{"present":31137,"missing":40294,"missingFraction":0.564096820708096}},"catalogues":[{"catalogue":"california-calgem-geothermal","records":2895,"sourceWellFamilies":2895,"unclassifiedPurpose":464,"fields":{"operator":{"present":151,"missing":2744,"missingFraction":0.9478411053540587},"sourceStatus":{"present":2895,"missing":0,"missingFraction":0},"spudDate":{"present":0,"missing":2895,"missingFraction":1},"measuredDepthM":{"present":0,"missing":2895,"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":28928,"sourceWellFamilies":28928,"unclassifiedPurpose":8637,"fields":{"operator":{"present":0,"missing":28928,"missingFraction":1},"sourceStatus":{"present":28928,"missing":0,"missingFraction":0},"spudDate":{"present":0,"missing":28928,"missingFraction":1},"measuredDepthM":{"present":0,"missing":28928,"missingFraction":1}},"sourceAsOf":null,"checkedAt":"2026-10-02","commercialUseAllowed":null,"catalogueCard":"https://wellficent.com/api/v1/wells/catalogues/canada-bcer"},{"catalogue":"israel-petroleum-2020","records":609,"sourceWellFamilies":548,"unclassifiedPurpose":609,"fields":{"operator":{"present":607,"missing":2,"missingFraction":0.003284072249589491},"sourceStatus":{"present":0,"missing":609,"missingFraction":1},"spudDate":{"present":597,"missing":12,"missingFraction":0.019704433497536946},"measuredDepthM":{"present":0,"missing":609,"missingFraction":1}},"sourceAsOf":"2020-07-06","checkedAt":"2026-10-02","commercialUseAllowed":null,"catalogueCard":"https://wellficent.com/api/v1/wells/catalogues/israel-petroleum-2020"},{"catalogue":"jordan-water-ufz","records":6729,"sourceWellFamilies":6729,"unclassifiedPurpose":6729,"fields":{"operator":{"present":0,"missing":6729,"missingFraction":1},"sourceStatus":{"present":0,"missing":6729,"missingFraction":1},"spudDate":{"present":0,"missing":6729,"missingFraction":1},"measuredDepthM":{"present":0,"missing":6729,"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":5758,"sourceWellFamilies":5758,"unclassifiedPurpose":0,"fields":{"operator":{"present":5670,"missing":88,"missingFraction":0.01528308440430705},"sourceStatus":{"present":5484,"missing":274,"missingFraction":0.04758596734977423},"spudDate":{"present":5758,"missing":0,"missingFraction":0},"measuredDepthM":{"present":5651,"missing":107,"missingFraction":0.018582841264327892}},"sourceAsOf":null,"checkedAt":"2026-10-02","commercialUseAllowed":null,"catalogueCard":"https://wellficent.com/api/v1/wells/catalogues/netherlands-nlog"},{"catalogue":"new-zealand-nzpam","records":1210,"sourceWellFamilies":1210,"unclassifiedPurpose":0,"fields":{"operator":{"present":1177,"missing":33,"missingFraction":0.02727272727272727},"sourceStatus":{"present":1165,"missing":45,"missingFraction":0.0371900826446281},"spudDate":{"present":1209,"missing":1,"missingFraction":0.0008264462809917355},"measuredDepthM":{"present":1195,"missing":15,"missingFraction":0.012396694214876033}},"sourceAsOf":null,"checkedAt":"2026-10-02","commercialUseAllowed":null,"catalogueCard":"https://wellficent.com/api/v1/wells/catalogues/new-zealand-nzpam"},{"catalogue":"norway-sodir","records":9781,"sourceWellFamilies":6024,"unclassifiedPurpose":1340,"fields":{"operator":{"present":9781,"missing":0,"missingFraction":0},"sourceStatus":{"present":9419,"missing":362,"missingFraction":0.03701053062059094},"spudDate":{"present":9247,"missing":534,"missingFraction":0.054595644617114816},"measuredDepthM":{"present":9041,"missing":740,"missingFraction":0.07565688579899806}},"sourceAsOf":null,"checkedAt":"2026-10-02","commercialUseAllowed":null,"catalogueCard":"https://wellficent.com/api/v1/wells/catalogues/norway-sodir"},{"catalogue":"uk-nsta-offshore","records":13383,"sourceWellFamilies":8295,"unclassifiedPurpose":0,"fields":{"operator":{"present":13342,"missing":41,"missingFraction":0.0030635881342001045},"sourceStatus":{"present":13383,"missing":0,"missingFraction":0},"spudDate":{"present":13383,"missing":0,"missingFraction":0},"measuredDepthM":{"present":13188,"missing":195,"missingFraction":0.014570724052902937}},"sourceAsOf":null,"checkedAt":"2026-10-02","commercialUseAllowed":null,"catalogueCard":"https://wellficent.com/api/v1/wells/catalogues/uk-nsta-offshore"},{"catalogue":"uk-nsta-onshore","records":2138,"sourceWellFamilies":1787,"unclassifiedPurpose":0,"fields":{"operator":{"present":68,"missing":2070,"missingFraction":0.9681945743685687},"sourceStatus":{"present":2138,"missing":0,"missingFraction":0},"spudDate":{"present":2137,"missing":1,"missingFraction":0.0004677268475210477},"measuredDepthM":{"present":2062,"missing":76,"missingFraction":0.03554724041159962}},"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 in JSON/NDJSON/CSV/GeoJSON qualityFlags. Aggregate fields above describe indexed missingness only; obtain all-row flag counts with the offline profile. Empty flags are not a guarantee of correctness."},"semantics":["Missing fractions are null for an empty selection. Nulls are not imputed.","Additional family rows include sidetracks or boreholes, not established duplicate physical wells.","Coverage is snapshot completeness, not source accuracy or predictive performance.","Source statuses and operators are historical reported values, not verified current operations."],"sortContract":{"default":"name","tieBreaker":"id ascending","nulls":"last for nullable sort fields","textCollation":"SQLite NOCASE (ASCII case folding); source status is sorted as text, not lifecycle priority.","available":["name","spud","spud-oldest","depth","operator","status","source-id"]}}