musiccaps
1 row where aspect_list contains "jingle" and aspect_list contains "rock music"
This data as json, CSV (advanced)
aspect_list (array) 10 ✖
- acoustic sounding drums 1
- advertisement 1
- drill sounds 1
- electric guitar 1
- generic 1
- instrumental 1
- jingle · 1 ✖
- keyboard 1
- rock music · 1 ✖
- simple tune 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
0dPx94RPy2M | This is a jingle piece played in the background of an advertisement video. There are sounds coming from a drill. The piece in the background is an instrumental rock music piece. There is a keyboard and an electric guitar playing the melody while an acoustic sounding drum beat provides the rhythm. The sounds are bland and generic. The piece could be of some use as an advertisement jingle or it could be playing in the background of an instructive/tutorial video. | ["advertisement", "jingle", "drill sounds", "rock music", "instrumental", "electric guitar", "keyboard", "acoustic sounding drums", "generic", "simple tune"] | ["Music", "Dental drill, dentist's drill"] | 9 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/08j51y"] |
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 );