musiccaps_details (view)
3 rows where musiccaps_aspects contains "shimmering hi hats", musiccaps_names = "["Music", "Happy music"]" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
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 | |
Pieter T - If My Girl | The low quality recording features a R&B song that consists of passionate male vocals, alongside background harmonizing male vocals, singing over tinny bells melody, synth strings melody, tinny high pitched synth lead melody, shimmering hi hats, gliding bass, punchy kick and claps. It sounds passionate and emotional, even though the mix of the song is poor. | 2011-10-30T05:12:06Z | IceFrettz | Pieter T - If My Girl From the album Life, Love & Lessons. Available now on itunes. | ["Music", "Happy music"] | ["low quality", "r&b", "passionate male vocal", "background harmonizing male vocals", "tinny bells melody", "synth strings melody", "tinny high pitched synth lead melody", "shimmering hi hats", "gliding bass", "punchy kick", "claps", "passionate", "emotional", "poor quality mix"] | 4 | 3IYd8cCmUkQ | 454 | |
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;