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