musiccaps_details (view)
3 rows where musiccaps_aspects contains "addictive", musiccaps_aspects contains "low quality" and musiccaps_aspects contains "soft kick hits"
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- addictive · 3 ✖
- low quality · 3 ✖
- soft kick hits · 3 ✖
- groovy bass guitar 2
- punchy snare 2
- rock 2
- acoustic rhythm guitar 1
- bouncy snare hits 1
- claps 1
- electric guitar melody 1
- electric rhythm guitar melody 1
- emotional 1
- energetic 1
- groovy 1
- groovy bass 1
- groovy piano melody 1
- harmonizing background vocals 1
- harmonizing male vocals 1
- passionate 1
- passionate female vocal 1
- passionate male vocal 1
- repetitive low plucked string melody 1
- shimmering cymbals 1
- shimmering hi hats 1
- shimmering wide cymbals 1
- snare roll 1
- soul/funk 1
- wide strings chords 1
- wide toms roll 1
musiccaps_names (array) 7 ✖
- Music 2
- Country 1
- Grunge 1
- Happy music 1
- Punk rock 1
- Singing 1
- Soul music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Crags - Please, Sniff The Air (Official) | The low quality recording features a rock song that consists passionate male vocal, alongside, harmonizing background vocals, singing over shimmering wide cymbals, bouncy snare hits, soft kick hits, electric rhythm guitar melody in the left channel, groovy bass guitar, acoustic rhythm guitar in the right channel of the stereo image and some wide toms roll. It sounds addictive and energetic. | 2015-08-24T07:36:04Z | Mathieu Epiney | Please, Sniff The Air by The Crags © 2015 www.thecrags.ch https://www.facebook.com/thecragsmusic Music Video by EPIDEMIC music video epidemic.ch epidemicmusicvideos@gmail.com Recorded & Mixed by Claude Lander @ Taurus Studio | ["Music", "Punk rock", "Grunge", "Soul music"] | ["low quality", "rock", "passionate male vocal", "harmonizing background vocals", "shimmering wide cymbals", "bouncy snare hits", "soft kick hits", "electric rhythm guitar melody", "groovy bass guitar", "wide toms roll", "addictive", "energetic", "acoustic rhythm guitar"] | 4 | U-UF93NA3ko | 2881 | |
Kansas - Point of Know Return (Official Video) | The low quality recording features a rock song that consists of harmonizing male vocals singing over groovy piano melody, groovy bass guitar, electric guitar melody, punchy snare, soft kick hits and shimmering hi-hats. There is a short snare roll that serves as a transition into a new section. It sounds groovy and addictive. | 2013-01-17T11:25:12Z | kansasVEVO | Official music video for “Point of Know Return” by Kansas Listen to Kansas: https://Kansas.lnk.to/listenYD Watch more videos by Kansas: https://Kansas.lnk.to/listenYD/youtube Subscribe to the official Kansas YouTube channel: https://Kansas.lnk.to/subscribeYD Follow Kansas Facebook: https://Kansas.lnk.to/followYD/facebook Instagram: https://Kansas.lnk.to/followYD/instagram Twitter: https://Kansas.lnk.to/followYD/twitter Website: https://Kansas.lnk.to/followYD/websitegeneral Spotify: https://Kansas.lnk.to/followYD/spotify Lyrics: Your father, he said he needs you Your mother, she says she loves you Your brothers, they echo your words: "How far to the point of know return?" "Well, how long?" #Kansas #PointofKnowReturn #Rock | ["Singing", "Country"] | ["low quality", "rock", "harmonizing male vocals", "groovy piano melody", "groovy bass", "electric guitar melody", "punchy snare", "snare roll", "soft kick hits", "shimmering hi hats", "groovy", "addictive"] | 4 | iFWtsT5zRKo | 4174 | |
[HD] House Season 7 Promo Music | Macy Gray - Help Me | The low quality recording features a funk/soul song that consists of a passionate female vocal singing over groovy bass guitar, wide strings chords, low repetitive plucked strings melody, punchy snare layered with claps, soft kicks and shimmering cymbals. It sounds emotional, passionate and addictive. | 2010-09-03T17:57:32Z | mercman | Music from one of the promos of seventh season of House on FOX. | ["Music", "Happy music"] | ["low quality", "soul/funk", "passionate female vocal", "groovy bass guitar", "repetitive low plucked string melody", "wide strings chords", "punchy snare", "claps", "shimmering cymbals", "soft kick hits", "emotional", "passionate", "addictive"] | 4 | tnDUwvxQU3k | 5065 |
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;