稍微处理一下数据，Power Query 是真不会用…手打 Python 去了

import requests

response = requests.get("https://relay.nya.one/domains.json")

data = response.json()

with open("invalid.tsv", "w", encoding="utf-8") as f:
    for i in ("unresolved", "not_functioning", "misformatted_nodeinfo_list", "no_available_nodeinfo_schema", "misformatted_nodeinfo_schema"):
        for j in data[i]:
            print("\t".join([i, j, data[i][j]]),file=f)
    for i in data["wrong_code"]:
        print("\t".join(["wrong_code", i, data["wrong_code"][i]["since"], str(data["wrong_code"][i]["code"])]),file=f)
with open("valid.tsv", "w", encoding="utf-8") as f:
    for i in data["valid"]:
        x = data["valid"][i]
        def nn():
            try: return x["metadata"]["nodeName"]
            except: return None
        def nd():
            try: return x["metadata"]["nodeDescription"]
            except: return None
        def lp():
            try: return x["usage"]["localPosts"]
            except: return None
        y = [i, x["software"]["name"], x["software"]["version"], x["openRegistrations"], x["usage"]["users"]["total"], lp(), nn(), nd()]
        print("\t".join([str(i).replace("\t","").replace("\r\n","\\r\\n").replace("\n","\\n") for i in y]),file=f)

编辑：vaild.tsv 整上站点名称