musiccaps_details (view)
3 rows where musiccaps_aspects contains "guitar accompaniment", musiccaps_aspects contains "instrumental music" and musiccaps_aspects contains "poor audio quality"
This data as json, CSV (advanced)
musiccaps_aspects (array) 42 ✖
- guitar accompaniment · 3 ✖
- instrumental music · 3 ✖
- poor audio quality · 3 ✖
- emotional 2
- guitar lead 2
- passionate 2
- adventure sports 1
- ambient noises 1
- ambient street noises 1
- beautiful love 1
- classic rock music 1
- documentary sound track 1
- endless love 1
- entertaining 1
- exciting 1
- forever together 1
- groovy bass line 1
- guitar band 1
- guitars playing in harmony 1
- home video recording 1
- home video sound track 1
- keyboard harmony 1
- lilting 1
- live audience 1
- live performance 1
- love song 1
- medium tempo 1
- melancholic music 1
- percussive bass line 1
- pure and innocent 1
- roller skating wheel sounds 1
- romantic 1
- sad 1
- silastic rock music 1
- skating home video 1
- slow tempo 1
- spirited 1
- steady rock drumming 1
- theremin 1
- workout playlist 1
- youtube music video 1
- youtube video 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 |
---|---|---|---|---|---|---|---|---|---|---|
Tubular Bells (Start of the 2nd part) on Theremin | The song is an instrumental. The song is in slow tempo with a theremin playing a melancholic melody with a guitar accompaniment. The song is emotional and lilting. The audio quality is poor. | 2007-05-29T15:55:35Z | DANI ROTTENBRAIN | Versión thereministica del principio de la segunda parte de tubular bells de Mike Oldfield | ["Music", "Theremin"] | ["theremin", "emotional", "guitar accompaniment", "poor audio quality", "romantic", "love song", "endless love", "forever together", "ambient noises", "youtube music video", "beautiful love", "pure and innocent", "live performance", "live audience", "melancholic music", "instrumental music", "slow tempo", "emotional", "sad"] | 1 | 03frQGyrgQ4 | 114 | |
Tubular Bells | The song is an instrumental. The song is medium tempo with three guitars playing in harmony, guitar accompaniment, guitar harmony, guitar lead and a strong bass line. The song is emotional and spirited. The song has an average audio quality and is played in front of a live audience. | 2009-07-01T03:28:17Z | Christine Robertson | California Guitar Trio's version of Tubular Bells live at B.B. King's June 22, 2009 with Tyler Trotter on Melodica | ["Banjo", "Tapping (guitar technique)", "Music"] | ["poor audio quality", "home video recording", "guitar band", "instrumental music", "medium tempo", "guitars playing in harmony", "groovy bass line", "guitar lead", "guitar accompaniment", "entertaining", "emotional", "passionate", "spirited", "lilting"] | 1 | 1RwhRTe-OKk | 275 | |
KYLE WALKER & CHIMA FERGUSON - VANS: PROPELLER RAW FILES RE-EDIT | The song is an instrumental. The tempo is medium fast with a guitar lead, guitar rhythm, steady rock drumming , a percussive bass line along with ambient street noises and roller skate wheel noises. The song is a home video sound track with lots of energy. The song audio quality is poor. | 2015-09-11T19:42:40Z | Justin Behan | Here is the second last and last part in the Vans: Propeller re-edit of the Raw Files video. Still trying to figure out a way to get the entire video online. All footage by Vans & Thrasher Hope you like it! | ["Music", "Psychedelic rock", "Skateboard", "Progressive rock"] | ["roller skating wheel sounds", "ambient street noises", "poor audio quality", "classic rock music", "documentary sound track", "exciting", "instrumental music", "silastic rock music", "guitar lead", "steady rock drumming", "percussive bass line", "keyboard harmony", "guitar accompaniment", "exciting", "skating home video", "youtube video", "poor audio quality", "home video sound track", "passionate", "adventure sports", "workout playlist"] | 1 | 9gkppwB5CXA | 1034 |
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;