Query Reference

Getting elements

c.phone c.lexicon_phone c.speaker c.discourse

Attributes

In addition to any values that get added through enrichment, there are several built in attributes that allow access to different parts of the database.

Attribute type	Code	Notes
Label [1]	c.phone.label
Name [2]	c.speaker.name
Begin [3]	c.phone.begin
End [3]	c.phone.end
Duration [3]	c.phone.duration
Previous annotation [3]	c.phone.previous
Following annotation [3]	c.phone.following
Previous pause [3]	c.phone.word.previous_pause	Must be from a word annotation
Following pause [3]	c.phone.word.following_pause	Must be from a word annotation
Speaker [3]	c.phone.speaker
Discourse [3]	c.phone.discourse
Pitch attribute [3]	c.phone.pitch
Formants attribute [3]	c.phone.formants
Intensity attribute [3]	c.phone.intensity
Minimum value [4]	c.phone.pitch.min
Maximum value [4]	c.phone.pitch.max
Mean value [4]	c.phone.pitch.mean
Raw track [4]	c.phone.pitch.track
Sampled track [4]	c.phone.pitch.sampled_track
Interpolated track [4]	c.phone.pitch.interpolated_track

[1]	Only available for graph annotations and lexicon annotations

[2]	Only available for speakers/discourses

[3]	(1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12) Only available for graph annotations

[4]	(1, 2, 3, 4, 5, 6) Only available for acoustic attributes

Filters

Filter type	Code	Notes
Equal	c.phone.label == 'aa'
Not equal	c.phone.label != 'aa'
Greater than	c.phone.begin > 0
Greater than or equal	c.phone.begin >= 0
Less than	c.phone.end < 10
Less than or equal	c.phone.end <= 10
In	c.phone.label.in_(['aa','ae'])	in_ can also take a query
Not in	c.phone.label.not_in_(['aa'])	not_in_ can also take a query
Is null	c.phone.label == None
Is not null	c.phone.label != None
Regular expression match	c.phone.label.regex('a,')
In subset	c.phone.subset == 'syllabic'
Not in subset	c.phone.subset != 'syllabic'
Precedes pause	c.word.precedes_pause == True	Only available for graph annotations
Does not precede pause	c.word.precedes_pause == False	Only available for graph annotations
Follows pause	c.word.follows_pause == True	Only available for graph annotations
Does not follow pause	c.word.follows_pause == False	Only available for graph annotations
Right aligned	c.phone.end == c.phone.word.end	Only available for graph annotations
Not right aligned	c.phone.end != c.phone.word.end`	Only available for graph annotations
Left aligned	c.phone.begin == c.phone.word.begin	Only available for graph annotations
Not left aligned	c.phone.begin != c.phone.word.begin	Only available for graph annotations