import json, collections, os, time

P = '/Users/liuxinyuan/Desktop/Hermes输出-工作类/数据/mcp_complaints.json'
d = json.load(open(P, encoding='utf-8'))
print('top keys:', list(d.keys()) if isinstance(d, dict) else 'LIST')
items = d.get('items') if isinstance(d, dict) else d
print('n =', len(items))
print('updated_at =', (d.get('updated_at') or d.get('updated')) if isinstance(d, dict) else None)
print('mtime =', time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(os.path.getmtime(P))))
print('sample keys:', list(items[0].keys()))
creator = collections.Counter((it.get('creator') or '') for it in items)
print('黄明月 =', creator.get('黄明月', 0), '| 张立娅 =', creator.get('张立娅', 0), '| 刘子研 =', creator.get('刘子研', 0))
print('area top:', collections.Counter((it.get('area') or '') for it in items).most_common(8))
print('status top:', collections.Counter((it.get('status') or '') for it in items).most_common(8))
print('created sample:', [it.get('created') for it in items[:3]])
print('has all 4 fields:', all(all(k in it for k in ('creator', 'area', 'status', 'created')) for it in items))
print('missing keys count:', sum(1 for it in items if not all(k in it for k in ('creator', 'area', 'status', 'created'))))