musiccaps_details (view)
2 rows where musiccaps_aspects contains "low quality", musiccaps_aspects contains "passionate", musiccaps_aspects contains "shimmering hi hats" and musiccaps_aspects contains "soft"
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 | |
BOBBY HACKETT THE GREATEST CORNETIST | The low quality recording features a jazz song that consists of a passionate trumpet melody in the left channel of the stereo image and mellow piano chords in the right channel, followed by smooth double bass and shimmering hi hats. It sounds soft, mellow, passionate and relaxing. The recording is a bit noisy. | 2009-02-20T18:31:54Z | TheMurphyFamily | Bobby Hackett, the cornetist whose mellow tone and graceful style made him a favorite of both jazz and pop music audiences. Whitney Balliett described Bobby Hackett in The New Yorker as "a unique and extremely successful alloy of Beiderbecke and Armstrong." "His tone." Mr. Balliett wrote "which is quiet and shining, resembles Beiderbecke's and so does his three-steps-up, two steps down method of improvising. But his sustained notes and way of playing just behind the beat and of occasionally slipping into double time are straight out of Louis Armstrong." Born in Providence, R.I. Bobby Hackett began his music career by studying the violin but switched to the trumpet and later to the cornet. He began playing professionally while in his teens and was soon appearing with some of the best known names of the "Big Band Era." Bobby Hackett appeared with Benny Goodman, Louis Armstrong, Glenn Miller and Paul Whiteman among others. "Music should be pretty," he said. "You should hear and recognize the melody. And real greatness is in the simplicity. Simple things are the hardest to play and the easiest to listen to." | ["Brass instrument", "Saxophone"] | ["low quality", "noisy", "jazz", "passionate trumpet melody", "shimmering hi hats", "mellow piano chords", "smooth double bass", "soft", "mellow", "passionate", "relaxing"] | 4 | TIAj-fi_R7c | 2828 |
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;