diff --git a/apply/mk-shochu.sh b/apply/mk-shochu.sh
new file mode 100755
index 0000000..e18a978
--- /dev/null
+++ b/apply/mk-shochu.sh
@@ -0,0 +1,11 @@
+#!/bin/sh
+if [ x"$1" = x"" ]; then
+  echo Usage: $0 CSVfile-From-mex.go.jp.csv > shochu-tohoku-niigata.csv
+  exit
+fi
+nkf -w "$1" \
+| awk -F, '$1 ~ /^[BCD]/ {printf("%s,%s,%s\n",$1,substr($3,1,2),$6) }' \
+| awk -F, '$2<=17{print }' \
+| egrep '[小中]|義務' | grep -v '高等'
+
+# | awk -F, '$2<=7 || $2==15{print }' \