musiccaps_details (view)
2 rows where musiccaps_aspects contains "no other instruments", musiccaps_aspects contains "no percussion" and musiccaps_aspects contains "no vocal melody"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- male voice 2
- no other instruments · 2 ✖
- no percussion · 2 ✖
- no vocal melody · 2 ✖
- distortion guitar 1
- haunting theme 1
- heavy metal 1
- instructional audio 1
- instrumental 1
- moderate tempo 1
- narration 1
- octaves 1
- ring modulator 1
- synth song 1
musiccaps_names (array) 7 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
How to Play Trust by Megadeth Guitar Lesson (w/ Tabs!!) | This song features a distortion guitar. This is an instructional video. The song features an open note followed by the octave. Then a descending pattern is played on the distortion guitar. The voice gives instructions on how to play the pattern. There is no percussion in this song. There are no other instruments in this song. There is no vocal melody in this song. | 2009-03-15T04:06:25Z | m169marroquin | http://www.ObeyYourMATTster.com | ["Tapping (guitar technique)", "Guitar", "Music", "Musical instrument", "Speech", "Plucked string instrument"] | ["distortion guitar", "heavy metal", "male voice", "instructional audio", "octaves", "no other instruments", "no percussion", "no vocal melody", "moderate tempo"] | 0 | 52odOK7G2kg | 628 | |
Genuine Bigfoot Recording PART4 | This clip features a male voice in a narrative voice. This is accompanied by a synth sound using a ring modulator effect. The voice is calming. This song can be played in a documentary movie. There is no vocal melody in this song. There are no other instruments in this clip. | 2008-04-09T19:46:28Z | killlljoy | In April 2005, ferry operator Bobby Clarke wrote a new chapter in the legend of the Bigfoot. His 40-second video of a mysterious image ignited speculation that it was in fact a genuine Bigfoot recording. | ["Singing bowl"] | ["synth song", "no percussion", "male voice", "narration", "ring modulator", "no other instruments", "no vocal melody", "instrumental", "haunting theme"] | 0 | NjoKxRwQxCE | 2357 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW musiccaps_details AS select musiccaps.url as video, json_object( 'label', coalesce(videos.title, 'Missing from YouTube'), 'href', musiccaps.url ) as youtube_link, musiccaps.caption as musiccaps_caption, videos.publishedAt as youtube_published, videos.channelTitle as youtube_channel, videos.description as youtube_description, musiccaps.audioset_names as musiccaps_names, musiccaps.aspect_list as musiccaps_aspects, musiccaps.author_id as musiccaps_author, videos.id as youtube_id, musiccaps.rowid as musiccaps_rowid from musiccaps left join videos on musiccaps.ytid = videos.id;