Deferral Rate
Share of executive answers containing deferral phrasing such as "we will consider it (kentou shimasu)", "we will study it (kenkyuu shimasu)", or "we will take it back (mochikaeri)".
Machikarte is one of the flagship sites operated by ISVD. Explore our other thematic sites below.
Share of executive answers containing deferral phrasing such as "we will consider it (kentou shimasu)", "we will study it (kenkyuu shimasu)", or "we will take it back (mochikaeri)".
(Answers containing deferral phrasing) ÷ (Total answers for the council and period) × 100Aggregated from answers recorded in councils whose minutes are indexed by Machikarte.
SELECT
council_id,
COUNTIF(REGEXP_CONTAINS(content, r"検討します|研究します|持ち帰り")) / COUNT(*) AS sakiokuri_rate
FROM `{project}.{dataset}.speeches`
WHERE speech_type = "answer"
GROUP BY council_id;