Database

[{"data":["10451","10458","10467","10461","10462"]},{"zipcode":"10470","res_count":8},{"zipcode":"10454","res_count":10},{"zipcode":"10466","res_count":11},{"zipcode":"10455","res_count":9},{"zipcode":"10462","res_count":29},{"zipcode":"10461","res_count":25},{"zipcode":"10467","res_count":15},{"zipcode":"10465","res_count":28},{"zipcode":"10452","res_count":11},{"zipcode":"10469","res_count":10},{"zipcode":"10459","res_count":7},{"zipcode":"10457","res_count":14},{"zipcode":"10451","res_count":68},{"zipcode":"10463","res_count":28},{"zipcode":"10458","res_count":34},{"zipcode":"10468","res_count":12},{"zipcode":"10475","res_count":14},{"zipcode":"10474","res_count":10},{"zipcode":"10473","res_count":3}]

Query

db.collection.aggregate([{$group:{_id:"",dataDoc:{$push:{$cond:[{$eq:[{$type:"$data"},"array"]},"$$ROOT","$$REMOVE"]}},allDocs:{$push:{$cond:[{$eq:[{"$type":"$zipcode"},"string"]},"$$ROOT","$$REMOVE"]}}}},{$unwind:"$dataDoc"},{$addFields:{allDocs:{$filter:{input:"$allDocs",cond:{$in:["$$this.zipcode","$dataDoc.data"]}}}}},{$unwind:"$allDocs"},{$replaceRoot:{newRoot:"$allDocs"}}])

Result