musiccaps
2 rows where aspect_list contains "deep" and audioset_ids contains "/m/04szw"
This data as json, CSV (advanced)
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
4ls_8xIjBzM | This music is instrumental. The tempo is medium with an electric guitar riff and the voice of a man giving instructions on electric guitar techniques. The music is loud, clear, amplified, vivid, emphatic and powerful. This is a tutorial/ lesson on electric guitar techniques. | ["instrumental", "medium tempo", "male voice speaking", "demonstration", "electric guitar", "stringed instrument", "amplified instrument", "loud", "clear", "rich", "deep", "rock", "hard rock", "metal", "heavy metal", "pop", "powerful", "emphatic", "intense", "electric guitar lesson", "electric guitar tutorial", "learning electric guitar", "electric guitar techniques", "vibrations"] | ["Tapping (guitar technique)", "Guitar", "Music", "Musical instrument", "Speech", "Plucked string instrument"] | 7 | 150 | 160 | 0 | 0 | ["/m/01glhc", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/09x0r", "/m/0fx80y"] | |
6_zzu2KON6c | A male guitarist plays a cool guitar like on an electric guitar. The song is medium tempo with a guitar solo with heavy a[echoes played though a guitar amplifier and no other instrumentation. The song is bluesy and passionate. The song is a casual blue slick played on a guitar. | ["home video", "poor audio quality", "sound check", "deep", "emotional", "passionate", "blues influences", "instrumental music", "guitar solo", "tremolo effect", "guitar amplifier", "guitar lead", "echo tone", "solo guitar", "bad audio recording", "no other instrumentation", "guitar technique", "moody blues", "spirited", "passionate", "medium tempo", "blues lick"] | ["Reverberation", "Electric guitar", "Guitar", "Music", "Musical instrument"] | 1 | 80 | 90 | 0 | 1 | ["/m/01b9nn", "/m/02sgy", "/m/0342h", "/m/04rlf", "/m/04szw"] |
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 );