musiccaps
1 row where aspect_list contains "child singer" and aspect_list contains "pleasant"
This data as json, CSV (advanced)
aspect_list (array) 16 ✖
- austria 1
- child singer · 1 ✖
- country side singing 1
- energetic 1
- enthusiastic 1
- enthusiastic acoustic guitar accompaniment 1
- falsetto 1
- fast tempo 1
- melodic 1
- no lyrics 1
- pleasant · 1 ✖
- sweet 1
- switzerland music 1
- vocal emphasis 1
- vocalisation 1
- yodelling 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
8ntKBILZ06k | This song is a child yodelling .The tempo is medium with an enthusiastic guitar accompaniment. The yodelling is melodic, calm, engaging, and pleasant. The song has minimal instrumentation with vocal emphasis. | ["child singer", "fast tempo", "yodelling", "vocalisation", "falsetto", "vocal emphasis", "country side singing", "enthusiastic acoustic guitar accompaniment", "vocalisation", "no lyrics", "austria", "switzerland music", "energetic", "enthusiastic", "pleasant", "sweet", "melodic"] | ["Yodeling", "Music", "Vocal music"] | 7 | 30 | 40 | 0 | 1 | ["/m/01swy6", "/m/04rlf", "/m/0y4f8"] |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [musiccaps] ( [ytid] TEXT PRIMARY KEY, [url] TEXT, [caption] TEXT, [aspect_list] TEXT, [audioset_names] TEXT, [author_id] TEXT, [start_s] TEXT, [end_s] TEXT, [is_balanced_subset] INTEGER, [is_audioset_eval] INTEGER, [audioset_ids] TEXT );