musiccaps_details (view)
2 rows where musiccaps_aspects contains "synth keys chords" and musiccaps_names contains "Rhythm and blues"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- energetic 2
- punchy kick 2
- synth keys chords · 2 ✖
- addictive 1
- alternative/indie 1
- buzzy groovy synth bass 1
- echoing passionate female vocal 1
- electric guitar licks 1
- energetic crash cymbal 1
- groovy 1
- groovy bass 1
- halloween 1
- haunting 1
- indie/alternative 1
- passionate 1
- soft claps 1
- tinny off beat percussion 1
musiccaps_names (array) 5 ✖
- Music 2
- Rhythm and blues · 2 ✖
- Drum machine 1
- Ska 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 |
---|---|---|---|---|---|---|---|---|---|---|
José Cid- Mellotron - O Planeta Fantástico | The Alternative/Indie song features layered punchy kicks, energetic crash cymbals, groovy bass and synth key chords, followed by electric guitar licks. It sounds haunting and energetic, almost like a halloween themed song. | 2010-09-24T02:02:36Z | jerudoriginal91 | ["Music", "Rhythm and blues", "Ska", "Soul music"] | ["alternative/indie", "punchy kick", "groovy bass", "synth keys chords", "electric guitar licks", "energetic crash cymbal", "energetic", "haunting", "halloween"] | 4 | 1Xtkou9dtyA | 285 | ||
Lossy - Rain Came Down | The Alternative/Indie song features an echoing, passionate female vocal singing over groovy, buzzy synth bass, punchy kick, soft claps, tinny offbeat percussion and synth keys chords that appear at the end of the loop. It sounds groovy, energetic, passionate and addictive. | 2011-09-18T12:27:21Z | miroNZ1983 | http://lossylossylossy.tumblr.com http://soundcloud.com/lossylossylossy | ["Music", "Rhythm and blues", "Drum machine"] | ["indie/alternative", "echoing passionate female vocal", "soft claps", "tinny off beat percussion", "punchy kick", "buzzy groovy synth bass", "synth keys chords", "energetic", "groovy", "passionate", "addictive"] | 4 | fpVlYpgTKZI | 3979 |
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;