musiccaps
1 row where aspect_list contains "reindeers" and aspect_list contains "santa claus"
This data as json, CSV (advanced)
aspect_list (array) 28 ✖
- christmas 1
- christmas ade nature 1
- christmas carols 1
- christmas classics 1
- christmas time 1
- devotional 1
- emotional 1
- groovy bass line 1
- hissing noise 1
- inspiring 1
- male singer 1
- medium tempo 1
- miracles 1
- motivational 1
- movie soundtrack 1
- orchestra playing 1
- passionate 1
- philharmonic orchestra 1
- piano accompaniment 1
- poor quality audio 1
- pop hits 1
- reindeers · 1 ✖
- santa claus · 1 ✖
- snow 1
- soaring vocals 1
- steady drumming rhythm 1
- string section harmony 1
- winter wonderland 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
nZ19mW-TMRk | A male singer sings this passionate and emotional melody. The song is medium tempo with a groovy bass line, steady drumming rhythm, piano accompaniment and an emotional string section harmony. The song is inspiring and emotional. The song is a Christmas classic and movie soundtrack. The audio quality is poor with a lot of hissing noises. | ["male singer", "soaring vocals", "hissing noise", "string section harmony", "medium tempo", "movie soundtrack", "christmas", "inspiring", "steady drumming rhythm", "groovy bass line", "piano accompaniment", "orchestra playing", "inspiring", "motivational", "devotional", "christmas time", "winter wonderland", "poor quality audio", "pop hits", "christmas classics", "miracles", "santa claus", "christmas ade nature", "christmas carols", "emotional", "passionate", "reindeers", "snow", "philharmonic orchestra"] | ["Christian music", "Music"] | 1 | 200 | 210 | 1 | 1 | ["/m/02mscn", "/m/04rlf"] |
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 );