standardgraph: Command for Claude Code

Refresh (or audit) every published fact and figure across BOTH public surfaces — the StandardGraph GitHub repo and the walkmakewalk portfolio — so they match the live database.

1. Gather the authoritative numbers

python3 - <<'PY'
import sqlite3, os
c=sqlite3.connect(os.path.expanduser("~/.standardgraph/common_core.db"))
def q(s): return c.execute(s).fetchone()[0]
std   = q("SELECT COUNT(*) FROM standards")
sysN  = q("SELECT COUNT(DISTINCT system) FROM standards")
xw    = q("SELECT COUNT(*) FROM crosswalk_mappings")
scored= q("SELECT COUNT(*) FROM crosswalk_mappings WHERE notes LIKE '%[LLM score%'")
flagged=q("SELECT COUNT(*) FROM crosswalk_mappings WHERE flagged_for_review=1")
direct= q("SELECT COUNT(*) FROM crosswalk_mappings WHERE notes LIKE '%direct_family%'")
rel   = q("SELECT COUNT(*) FROM standard_relationships")
subj  = q("SELECT COUNT(DISTINCT subject) FROM standards")
size  = os.path.getsize(os.path.expanduser("~/.standardgraph/common_core.db"))/1073741824
print(f"standards      = {std:,}      (display as '{std//1000}k+' or exact)")
print(f"systems        = {sysN}")
print(f"subjects       = {subj}")
print(f"crosswalks     = {xw:,}")
print(f"scored         = {scored:,}   ({100*scored/xw:.0f}% of crosswalks)")
print(f"flagged        = {flagged:,}")
print(f"direct_family  = {direct:,}")
print(f"relationships  = {rel:,}      (display as '{rel/1e6:.1f}M')")
print(f"db_size_gb     = {size:.2f}   (display as '~{size:.1f} GB')")
# per-region coverage counts used on the landing-page cards
for label, clause in [("US","system IN ('ccss','ccss-ela','ngss','c3','csta') OR system GLOB '[a-z][a-z]' OR system LIKE '%-sci' OR system LIKE '%-ela' OR system LIKE '%-ss' OR system LIKE '%-cs' OR system LIKE 'ap-%'"),
                       ("Canada","system LIKE 'ca-%'"),("UK","system IN ('uk-nc','uk-aqa','gb-sco')")]:
    print(f"coverage[{label}] = {q(f'SELECT COUNT(*) FROM standards WHERE {clause}'):,}")
c.close()
PY

Formatting rules:

• "N+ standards" displays round DOWN to nearest thousand (175,738 → "175,000+"). Exact stat blocks use the full number.
• DB size: one decimal GB (~2.1 GB).
• Relationships: one decimal million (3.8M).
• Scored %: whole number.