Skip to content

Latest commit

 

History

History
122 lines (108 loc) · 11.9 KB

queries_reference.rst

File metadata and controls

122 lines (108 loc) · 11.9 KB
Raw

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
Label1

c.phone.label
Name2

c.speaker.name
Begin3

c.phone.begin
End4

c.phone.end
Duration5

c.phone.duration
Previous annotation6

c.phone.previous
Following annotation7

c.phone.following
Previous pause8

c.phone.word.previous_pause

Must be from a word annotation
Following pause9

c.phone.word.following_pause

Must be from a word annotation
Speaker10

c.phone.speaker
Discourse11

c.phone.discourse
Pitch attribute12

c.phone.pitch
Formants attribute13

c.phone.formants
Intensity attribute14

c.phone.intensity
Minimum value15

c.phone.pitch.min
Maximum value16

c.phone.pitch.max
Mean value17

c.phone.pitch.mean
Raw track18

c.phone.pitch.track
Sampled track19

c.phone.pitch.sampled_track
Interpolated track20

c.phone.pitch.interpolated_track

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 :code: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

  1. Only available for graph annotations and lexicon annotations↩

  2. Only available for speakers/discourses↩

  3. Only available for graph annotations↩

  4. Only available for graph annotations↩

  5. Only available for graph annotations↩

  6. Only available for graph annotations↩

  7. Only available for graph annotations↩

  8. Only available for graph annotations↩

  9. Only available for graph annotations↩

  10. Only available for graph annotations↩

  11. Only available for graph annotations↩

  12. Only available for graph annotations↩

  13. Only available for graph annotations↩

  14. Only available for graph annotations↩

  15. Only available for acoustic attributes↩

  16. Only available for acoustic attributes↩

  17. Only available for acoustic attributes↩

  18. Only available for acoustic attributes↩

  19. Only available for acoustic attributes↩

  20. Only available for acoustic attributes↩