Copyrigth © 2000, 2004, Nederlandse Taalunie and
R.J.J.H. van Son
All materials presented here are licensed under the
GNU General Public License (GPL) unless explicitely stated
otherwise. Please note that these materials are presented WITHOUT ANY WARRANTY.
For information or further details
see the License,
GNU.org, or contact me
at Rob.van.Son@hum.uva.nl.
Use this button to change the query | Use this button to select the speech fragments that were used |
# # COUNT # # Group (rows X columns): # WORDSPHONEME_speaker X Case1 # # Nrows: 329 # # The surfacing of underlying /n/ (N vs Schwa) in # plural /@n/ in Read speech. (next word does not start with /n/) # Spontaneous combines: # I: Informal # R: retold # # Read combines: # T: text Reading # S: Sentence Reading # # Counts N Schwa Total F20N 9 25 34 F28G 37 32 69 F40L 12 50 62 F60E 7 45 52 M15R 9 22 31 M40K 8 32 40 M56H 17 15 32 M66O 9 0 9 Total 108 221 329 # # # Nrows: 329 # Table: WORDSPHONEME # Function: COUNT # # Date: Sun Feb 29 13:13:41 2004 # QUERY: # SELECT DISTINCT # WORDSPHONEME.speaker as WORDSPHONEME_speaker, # WORDSPHONEME.ID as COUNTID, # CASE # WHEN CGNPHONEME.value ~ '@n$' THEN TEXT('N') # WHEN CGNPHONEME.value ~ '@$' THEN TEXT('Schwa') # END AS Case1 # FROM # WORDSPHONEME, # TRANSLITPHONEME, # LEXCGNPHONEME, # POSPOS, # CGNPHONEME, # POSSPECPOS, # INTAS915 # WHERE # (CGNPHONEME.id = WORDSPHONEME.id AND # WORDSPHONEME.id = CGNPHONEME.id AND # LEXCGNPHONEME.id = WORDSPHONEME.id AND # WORDSPHONEME.id = LEXCGNPHONEME.id AND # TRANSLITPHONEME.id = WORDSPHONEME.sentenceid AND # WORDSPHONEME.sentenceid = TRANSLITPHONEME.id AND # TRANSLITPHONEME.id = LEXCGNPHONEME.sentenceid AND # LEXCGNPHONEME.sentenceid = TRANSLITPHONEME.id AND # TRANSLITPHONEME.id = CGNPHONEME.sentenceid AND # CGNPHONEME.sentenceid = TRANSLITPHONEME.id AND # POSPOS.id = WORDSPHONEME.id AND # WORDSPHONEME.id = POSPOS.id AND # POSSPECPOS.id = WORDSPHONEME.id AND # WORDSPHONEME.id = POSSPECPOS.id AND # INTAS915.id = TRANSLITPHONEME.id AND # TRANSLITPHONEME.id = INTAS915.id) AND # WORDSPHONEME.ID IS NOT NULL AND # ( POSPOS.value != 'TSW' AND # CGNPHONEME.value ~ '(@|@n)$' AND # WORDSPHONEME.value ~ 'en$' AND # CGNPHONEME.nextvalue !~ '^n' AND # INTAS915.style IN ('T', 'S', 'PS') AND # POSPOS.value IN ('N', 'WW') AND # POSSPECPOS.value ~ 'mv' # ) #