[{"_id":ObjectId("61479d4bc146b1663a8f2b7d"),"city":"SAO PAULO","name":"ANA","status":"ACTIVE","date1":ISODate("2020-09-01T08:14:30.000Z")},{"_id":ObjectId("61479d88c146b1663a8f2b7e"),"city":"SAO PAULO","name":"MARIA","status":"ACTIVE","date1":ISODate("2020-08-01T04:16:00.000Z")},{"_id":ObjectId("61479dc2c146b1663a8f2b7f"),"city":"RIO DE JANEIRO","name":"MARIA","status":"ACTIVE","date1":ISODate("2021-02-01T11:10:00.000Z")},{"_id":ObjectId("61479df1c146b1663a8f2b80"),"city":"SAO PAULO","name":"MARIA","status":"INACTIVE","date1":ISODate("2021-02-01T11:15:00.000Z")},{"_id":ObjectId("61479e60c146b1663a8f2b81"),"city":"BRASILIA","name":"JOHH","status":"ACTIVE","date1":ISODate("2021-06-01T01:18:00.000Z")}]

db.collection.aggregate([{"$match":{"status":"ACTIVE"}},{"$sort":{"date1":-1}},{"$group":{"_id":{"name":"$name"},"date1":{"$first":"$date1"},"city":{"$first":"$city"}}},{"$project":{"_id":0,"name":"$_id.name","city":1,"date1":1}}])