musiccaps_details (view)
2 rows where musiccaps_aspects contains "passionate female vocal", musiccaps_aspects contains "shimmering hi hats" and musiccaps_names contains "Happy music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- low quality 2
- passionate female vocal · 2 ✖
- shimmering hi hats · 2 ✖
- addictive 1
- easygoing 1
- emotional 1
- groovy bass 1
- harmonizing background female vocals 1
- mellow piano chords 1
- messy 1
- passionate 1
- passionate male vocal 1
- punchy kick 1
- punchy snare 1
- rock 1
- shimmering tambourine 1
- soft 1
- wide acoustic guitar chords 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
"Tara na Biyahe Tayo" Music video | The low quality recording features a passionate male vocal, alongside passionate female vocal, singing over shimmering tambourine, shimmering hi hats and mellow piano chords. It sounds soft, emotional and passionate. | 2012-07-30T11:30:46Z | John Nicolle Bueno | See my Indochina Tour 2019 with detailed itinerary itinerary. Click here: https://youtu.be/vt23Sd40SUM ---------------------------------------------------------- See my Boracay video by clicking below: https://www.youtube.com/watch?v=aHGosBwMzPw&t=43s Discover the beauty of El Rio Y Mar Resort in Coron Palawan, Philippines by watching this video http://www.youtube.com/watch?v=ig0BoLvQFj8 :) ------- Purpose of making this music video is for our report commercial.. I don't own any rights on any of the pictures shown in the video, all of it are from "Pilipino Ako" Facebook page. Photo credits to the owners.. | ["Music", "Happy music"] | ["low quality", "passionate male vocal", "passionate female vocal", "shimmering hi hats", "shimmering tambourine", "mellow piano chords", "soft", "emotional", "passionate"] | 4 | 0rNr_qnoPQ4 | 214 | |
Cristina D'Avena - Shugo Chara - La Magia del Cuore Videosigle HD Dvd version 2 minuti | The low quality recording features a rock song that consists of a passionate female vocal, alongside harmonizing background female vocals, singing over wide acoustic guitar chords, groovy bass, punchy kick and snare hits. It sounds addictive and easygoing, even though the recording is a bit messy. | 2011-03-15T21:08:19Z | Mondosigle | Cristina D'Avena - Shugo Chara - La Magia del Cuore Videosigle HD Dvd version 2 minuti | ["Music", "Happy music"] | ["low quality", "rock", "wide acoustic guitar chords", "groovy bass", "harmonizing background female vocals", "passionate female vocal", "punchy kick", "punchy snare", "shimmering hi hats", "addictive", "easygoing", "messy"] | 4 | 7RtQpW2dSU4 | 846 |
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;