# YSWS true spend

What each Hack Club YSWS program actually spent, published from the Hack Club
data warehouse. HCB reports a program's spend as everything that left its
account, which counts transfers to reviewer budgets, author funds and the fiscal
host; this site classifies every outflow and counts only what left for the
outside world.

Every page is rendered from the JSON below, so the two never disagree. Static
files, no auth. Amounts are US dollars, dates ISO-8601, timestamps UTC.

## Data

The home page is rendered from /index.json, which holds the metadata (when HCB
was last pulled, when the spend was last recalculated) and the four sections of
the site: ysws_programs_with_linked_hcbs, ysws_programs_with_no_linked_hcbs,
ysws_marketing, and hcb_orgs_no_program_claims. Each program there carries its
totals and its nested HCB org tree, and points at its own document.

Each program page is rendered from /programs/{program_name}.json, for example
/programs/flavortown.json, which holds that program's totals, category
breakdown, HCB org tree, and every transaction counted.

The same data is also published as a DuckDB database at /ysws-true-spend.duckdb, for
querying rather than walking the JSON, with tables programs, program_orgs,
spend_transactions, revenue_transactions, withheld_orgs, unmatched_orgs,
unlinked_programs and metadata:

    duckdb ysws-true-spend.duckdb
    SELECT name, true_spend_dollars FROM programs ORDER BY 2 DESC LIMIT 10;

## Mapping contract

A program owns the HCB organization its Unified YSWS DB record links to, plus
every HCB sub-organization beneath it. Nothing else is matched; the gaps are in
index.json under ysws_programs_with_no_linked_hcbs and
hcb_orgs_no_program_claims.

## Transaction detail

Mirrors hcb.hackclub.com: names published, email addresses removed, organizations outside HCB transparency mode summarised rather than listed.

Site: https://github.com/hackclub/ysws-true-spend
Source: https://github.com/hackclub/data-warehouse (asset ysws_true_spend_site)