user: ### NOW ANSWER:
Question: How many different civil parishes is Canrooska a part of?
Columns: ['Townland', 'Area( acres )', 'Barony', 'Civil parish', 'Poor law union']
Types: ['text', 'real', 'text', 'text', 'text']
Sample row: ['Adrigole', 293.0, 'Bear', 'Kilcaskan', 'Castletown']
SQL:

assistant: SELECT COUNT("Civil parish") FROM "Table" WHERE "Townland" = 'Canrooska';