musiccaps_details (view)
2 rows where musiccaps_author = 4 and "youtube_published" is on date 2012-07-30
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
musiccaps_names (array) 4 ✖
- Music 2
- A capella 1
- Classical music 1
- Happy music 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 | |
The Banana Boat Song ukulele cover with chords and lyrics - Harry Belafonte style (hopefully).wmv | The low quality recording features a cover of a song and it consists of passionate male vocals that together with the actual song's vocal, sounds harmonizing. There are simple acoustic guitar chords too. The recording is very noisy as it was probably recorded with a phone, but regardless it sounds emotional. | 2012-07-30T15:21:15Z | raffaport | Some calypso fun from a bygone age ... too piercing, man! | ["Music", "Classical music", "A capella"] | ["low quality", "cover", "harmonizing male vocals", "simple acoustic guitar chords", "emotional", "noisy", "phone recording", "passionate male vocal"] | 4 | BfMKdrK9D8M | 1272 |
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;