get_stats.py

import sqlite3
db = sqlite3.connect(r'C:\Users\simon\.openclaw\workspace\commonweave\data\commonweave_directory.db')
c = db.cursor()
c.execute("SELECT COUNT(*) FROM organizations WHERE status != 'removed'")
active = c.fetchone()[0]
c.execute("SELECT COUNT(DISTINCT country_code) FROM organizations WHERE status != 'removed'")
countries = c.fetchone()[0]
print(f'ACTIVE={active}')
print(f'COUNTRIES={countries}')
c.execute("SELECT framework_area, COUNT(*) FROM organizations WHERE status != 'removed' AND framework_area IS NOT NULL GROUP BY framework_area ORDER BY framework_area")
for area, cnt in c.fetchall():
    print(f'SECTION_{area}={cnt}')
db.close()