SQL accessible phoneme data

Statistics on our segmented data are available here. You can select a table and enter selection criteria to get a listing or descriptive statistics.
(Rob.van.Son@hum.uva.nl). You can test the statistics used here.

With some server/browser on some platforms combinations there can be problems with that result in broken connections for POST requests. If you have any problems receiving data, please check the GET button below and click on the CHANGE button.

DATABASE CONNECTION ERROR: 'ifacorpus' has no readable tables

Copyrigth © 2000, 2012, 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 R.J.J.H.vanSon@uva.nl.

You can find information on the label protocol, the naming conventions, and the phoneme labels here (in Dutch) and here (some of it in English).

Text types are:

• Fixed: Textual materials read by each speaker
• Variable: Speaker specific textual materials derived from the unique (informal) story told by each speaker

Speaking styles are:

• Informal: An elicited story about a vacation trip told to an interviewer (face to face)
  
• Retold: A previously read story (a fixed fairy tale or the vacation trip) retold in an empty room
• Read: A long text read from a cueing screen
• Sentence: Isolated sentences read from a cueing screen
• Pseudo Sentence: Non-sentences, constructed by stringing randomly picked words, read from a cueing screen
• Word: Word lists read from a cueing screen
• Syllable: Syllable lists read from a cueing screen
• Pronunciation: Diagnostic and idiomatic lists
  (note: specifying these sub-styles can slow down queries involving multiple tables)
  • ABC: The alphabet read from a cueing screen
  • NUM: The numbers from 0-12 read from a cueing screen
  • VOW: Isolated vowels read from a cueing screen
  • HVD: Vowels in H_D context read from a cueing screen
  • VCV: Isolated intervocalic consonants read from a cueing screen

Information on how to use our Web interface to the IFA-corpus PostgreSQL database, look here.

The form below allows you to construct an SQL Query in the format:

SELECT <attr1>, <attr2>, ... FROM <table> WHERE <cond1> AND/OR <cond2> AND/OR .... ;

The results of the queries are available either as printed lists, or as summary statistics (e.g., frequencies, means, correlations).

Queries

Select

STATISTICS