musiccaps_details (view)
2 rows where musiccaps_author = 4, musiccaps_names contains "Exciting music" and musiccaps_names contains "Rhythm and blues"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 20 ✖
- addictive 1
- addictive synth lead melody 1
- background filtered male vocals 1
- distorted 808 bass 1
- energetic 1
- flat male vocal 1
- groovy bass 1
- harmonizing male vocals 1
- hip hop/rap 1
- low quality 1
- mono 1
- offbeat hi hats 1
- passionate male vocal 1
- punchy kick 1
- punchy snare 1
- repetitive plucked synth melody 1
- rock 1
- shimmering cymbals 1
- snaps 1
- wide electric guitar melody 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Billy Talent - Fallen Leaves Music Video (HQ) | The Rock song features a passionate male vocal, alongside harmonizing male vocals, singing over wide electric guitar melody, groovy bass guitar, punchy kick and snare hits and some shimmering cymbals. It sounds energetic and kind of addictive thanks to those harmonizing vocals - like something you would hear on a radio during the 00s. | 2010-04-27T14:20:24Z | Jimmy Karlsson | The official music video of the song with the same name enjoy... Update 2012-12-01 Thanks for 100 000 views | ["Music", "Rhythm and blues", "Exciting music"] | ["rock", "passionate male vocal", "harmonizing male vocals", "wide electric guitar melody", "groovy bass", "punchy kick", "punchy snare", "shimmering cymbals", "energetic", "addictive"] | 4 | 0LE6Ll1rVlg | 150 | |
Krucial Kidz Promo Video (NEW MUSIC COMMING SOON) | The Hip Hop/Rap song features a flat male vocal with filtered, background male vocals, rapping over repetitive plucked synth melody and addictive synth lead melody, followed by distorted 808 bass, snaps and some offbeat hi hats. The whole sound is distorted and everything is in mono, which makes the song low quality. | 2012-02-03T07:56:29Z | Krucial Kidz | - This Is Not The Official Video PLEASE keep Supporting , | ["Afrobeat", "Music", "Rhythm and blues", "Hip hop music", "Exciting music"] | ["hip hop/rap", "repetitive plucked synth melody", "snaps", "flat male vocal", "background filtered male vocals", "distorted 808 bass", "addictive synth lead melody", "low quality", "mono", "offbeat hi hats"] | 4 | PFX2OO75sRQ | 2521 |
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;