#!/usr/bin/env python3
import csv
from collections import Counter

with open('verified-scored-facilities.csv', 'r', encoding='utf-8') as f:
    reader = csv.DictReader(f)
    facilities = list(reader)

total = len(facilities)
by_confidence = Counter(f['Confidence Level'] for f in facilities)

print(f"Total facilities: {total}")
print(f"\nBy Confidence Level:")
for level, count in sorted(by_confidence.items(), key=lambda x: -x[1]):
    pct = count/total*100
    print(f"  {level}: {count} ({pct:.1f}%)")

verified = by_confidence.get('Verified', 0)
confirmed = by_confidence.get('Confirmed', 0)
estimated = by_confidence.get('Estimated', 0)
remaining = confirmed + estimated

print(f"\n{'='*60}")
print(f"PROGRESS: {verified}/{total} Verified ({verified/total*100:.1f}%)")
print(f"REMAINING: {remaining} facilities ({confirmed} Confirmed + {estimated} Estimated)")
print(f"{'='*60}")