# Mekanismirealismi / MeV — Finnish Legislative Analysis > Analysis of 8,438 Finnish government proposals (hallituksen esitys, HE) > with LLM-annotated expert statements, plenary debates, committee reports, > cross-document discourse analysis, and fault detection. > Finnish language corpus. Analysis tools and metadata in Finnish. ## Key pages - /mev/he-viewer.html — Interactive HE explorer (per-HE SQLite DB loaded via sql.js) - /mev/lakikartta.html — Finnish statute citation graph (60,000 statutes) - /mev/wall-of-red.html — Overview dashboard of all HEs with quality signals - /mev/flow-trajectory.html — Longitudinal benefit flow analysis - /mev/mekanismitase.html — Mechanism balance sheet (8 case studies) - /mev/lakiauditointi.html — Finlex divergence audit ## Data architecture - Per-HE SQLite databases: /he-dbs/{he-id}.db (loaded client-side via sql.js) - Per-HE JSON summaries: /he-dbs/{he-id}.json (structured, LLM-friendly) - HE manifest: /mev/he-manifest.json (all 1303 enriched HEs with metadata) - State causal map: /fi_state_causal_map.db (92K statutes, 119K citation edges) ## Per-HE database tables Each .db contains: atoms (document sections), metadata, claims (fiscal), expert_statement, committee_report, ptk_speeches (plenary), ev_decisions, dissents, span_tags (concern/question/proposal/reference/admission/fiscal/law_ref), discourse_edges (ENDORSES/UNADDRESSED/CONTRADICTS/CORROBORATES), sentence_tags (role x quality x topic), lausunto_tags, mietinto_tags, edge_previews (cross-document link metadata), law_refs, delegation_drift. ## For AI agents - Structured JSON per HE: /he-dbs/{he-id}.json - AI metadata: /ai.json (also at /.well-known/ai.json) - WebMCP tools available when he-viewer.html is open (Chrome 146+)