verify_salary_data.py

import psycopg
from dotenv import load_dotenv
import os

load_dotenv('.env')
conn = psycopg.connect(os.getenv('DATABASE_URL'))
rows = conn.execute(
    'SELECT t.name, s.median_salary_usd, s.average_salary_usd, s.market_cap_usd FROM market_cap_snapshots s JOIN tasks t ON t.id=s.entity_id WHERE s.entity_type=%s ORDER BY s.composite_score DESC LIMIT 5',
    ('task',)
).fetchall()

for r in rows:
    median_str = f"${r[1]:,.0f}" if r[1] else "N/A"
    avg_str = f"${r[2]:,.0f}" if r[2] else "N/A"
    mcap_str = f"${r[3]:,.0f}" if r[3] else "N/A"
    print(f'{r[0]}: median={median_str}, avg={avg_str}, mcap={mcap_str}')