musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "male singer" and musiccaps_aspects contains "song fade" sorted by youtube_id
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 33 ✖
- male singer · 2 ✖
- song fade · 2 ✖
- adventurous 1
- ambient noises 1
- electric rhythm guitar plays 1
- energetic 1
- engine whirring noises 1
- enthusiastic 1
- exciting 1
- groovy music 1
- guitar accompaniment 1
- hip hop music 1
- jeep stopping 1
- keyboard accompaniment 1
- keyboard beep tones 1
- medium tempo 1
- melancholic music 1
- noise ambient sounds 1
- passionate 1
- poor audio quality 1
- rapping vocals 1
- rough male vocals 1
- slick drumming rhythm 1
- song stops playing 1
- story telling 1
- tambourine percussions 1
- tarmac sounds 1
- telephone ringing 1
- travel show background music 1
- travel show sound track 1
- vehicle driving sounds 1
- violins playing sadly 1
- wanderlust 1
musiccaps_names (array) 5 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
In Asia - Episode 1 - MALAYSIA | A male singer sings this emotional song. The song is medium tempo with guitar accompaniment, strong bass line, steady drumming rhythm, violins playing emotional and tambourine percussion. The song is overlapped with sounds of a vehicle engine and Tarmac sounds. | 2011-10-04T07:30:49Z | ISENSEVEN | This is the first out of four Episodes about a trip to SouthEast Asia in Fall 2010. Stefan, Clemens and Vincent were travelling in a Landrover through Malaysia, Thailand, Laos and Cambodia for 2 months. Of course, they brought our little DSLRs to capture every great moment of this memorable journey. Connect with us: ▶SUBSCRIBE: http://www.goo.gl/Wuj2mu ▶OFFICIAL SITE: http://www.isenseven.tv/ ▶FACEBOOK: http://www.facebook.com/isen7 ▶TWITTER: @isen7official ▶INSTAGRAM: http://statigr.am/isensevencrew ▶TRAILER: http://www.youtube.com/watch?v=fKGT_WQ7iM8 ▶EPISODE 2 - THAILAND: http://www.youtube.com/watch?v=aPl2TICNWA8 ▶EPISODE 3 - LAOS: http://www.youtube.com/watch?v=evCd1dLg4I0 ▶EPISODE 4 - CAMBODIA: https://www.youtube.com/watch?v=4I4USTI-Ap8 Filmed by Vincent Urban & Clemens Krüger Shot with Canon 7D Edited by Vincent Urban Uzi & Ari - "Mountain / Molehill" The Travelling Band - "Sundial" | ["Reversing beeps", "Music"] | ["male singer", "melancholic music", "song fade", "travel show sound track", "wanderlust", "adventurous", "exciting", "vehicle driving sounds", "jeep stopping", "travel show background music", "ambient noises", "guitar accompaniment", "tambourine percussions", "engine whirring noises", "tarmac sounds", "noise ambient sounds", "violins playing sadly"] | 1 | AFwmMFq_xlc | 1093 | |
'For Little Jimmy' (Official Music Video) - Ron Killings aka WWE Superstar "R-Truth" | A male singer with a rough voice sings this hip hop dance song. The song is medium tempo with a distorted electric guitar playing rhythm, keyboard accompaniment, slick drumming rhythm, telephone ring tones and various percussion hits. The song ends with a fade . The song has poor audio quality. | 2013-02-10T14:09:09Z | RonKillingsTV | 'For Little Jimmy' official music video from Ron Killings aka WWE Superstar "R-Truth" #RTruth #WWE #ForLittleJimmy #RonKillings #LittleJimmy Subscribe to RonKillingsTV: https://www.youtube.com/channel/UCkK8dn3G5IxAigWgRbdJmyw Website: https://www.theofficialronkillings.com Merchandise: https://www.ronkillings.com Facebook: https://www.facebook.com/ronkillings Twitter: https://www.twitter.com/ronkillings Tik Tok: https://www.tiktok.com/ronkillings1 Youtube: https://www.youtube.com/ronkillingstv IG: https://www.instagram.com/ronkillings1 Booking info: ronkillingsbooking1@gmail.com https://www.textrke.com (fan text line) (310) 406-7100 Director IG handle(s): @shotbyreginald | ["Music", "Telephone bell ringing", "Inside, small room", "Inside, large room or hall"] | ["male singer", "rapping vocals", "hip hop music", "telephone ringing", "slick drumming rhythm", "song stops playing", "keyboard beep tones", "keyboard accompaniment", "story telling", "enthusiastic", "medium tempo", "rough male vocals", "energetic", "passionate", "poor audio quality", "groovy music", "electric rhythm guitar plays", "song fade"] | 1 | sgJT5lIFttM | 4970 |
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;