python 请问: 三个list中有关联的字典如何取值生成新的list

有如下三个list

province = [{"name": "浙江省", "id": "330"}, {"name": "江苏省", "id": "320"}]
city = [{"name": "杭州市", "id": "330100", "province_id": "330"}, {"name": "南京市", "id": "320100", "province_id": "320"}]
district = [{"name": "上城区", "id": "330114", "city_id": "330100", "province_id": "330"}, {"name": "余杭区", "id": "330110", "city_id": "330100", "province_id": "330"}, {"name": "鼓楼区", "id": "320106", "city_id": "320100", "province_id": "320"}, {"name": "江宁区", "id": "320115", "city_id": "320100", "province_id": "320"}]

#需生成如下list
new_list = [{"name":"浙江省杭州市上城区"}, {"name":"浙江省杭州市余杭区"}, {"name":"江苏省南京市鼓楼区"}, {"name":"江苏省南京市江宁区"}]

思路,拿到前一个的现在的province_id对比前一个id,province_id,如果是,则组合数据返回

province = [{"name": "浙江省", "id": "330"}, {"name": "江苏省", "id": "320"}]
city = [{"name": "杭州市", "id": "330100", "province_id": "330"}, {"name": "南京市", "id": "320100", "province_id": "320"}]
district = [{"name": "上城区", "id": "330114", "city_id": "330100", "province_id": "330"},
            {"name": "余杭区", "id": "330110", "city_id": "330100", "province_id": "330"},
            {"name": "鼓楼区", "id": "320106", "city_id": "320100", "province_id": "320"},
            {"name": "江宁区", "id": "320115", "city_id": "320100", "province_id": "320"}]
# 需生成如下list
new_list = []

for k in district:
    for i in province:
        if i.get('id')==k['province_id']:
            p=i["name"]
    for i in city:
        if i.get('id')==k['city_id']:
            c=i["name"]

    new_list.append({"name":p+c+k['name']})
print(new_list)