musiccaps_details (view)
2 rows where musiccaps_aspects contains "catchy vocal riff", musiccaps_author = 7 and musiccaps_names contains "Shuffle"
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- catchy vocal riff · 2 ✖
- dance music 2
- edm 2
- instrumental 2
- background chatter 1
- boomy bass drops 1
- buoyant 1
- club music 1
- dance groove 1
- distorted music 1
- distorted sound 1
- dj 1
- electro pop 1
- electro rock 1
- electronic music 1
- electronically arranged music 1
- fast tempo 1
- female vocals 1
- high strung 1
- home recording 1
- home video 1
- inferior sound quality 1
- muffled audio 1
- obscure audio 1
- party music 1
- psychedelic 1
- punchy beats 1
- punchy youthful 1
- robotic voice 1
- synthesiser arrangements 1
- thumping sounds 1
- vibrant 1
- vocalisation 1
musiccaps_names (array) 8 ✖
- Music 2
- Shuffle · 2 ✖
- Drum and bass 1
- Dubstep 1
- Electronic dance music 1
- House music 1
- Techno 1
- Trance music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
jamie and millie couple shuffle | This is Electronic Dance music. The tempo is fast with synthesiser arrangements, punchy Digital drum rhythm, electronic sounds and a recurring, catchy vocal riff with the sound of talking in the background.The music is obscure as it is an amateur recording . It is buoyant, youthful, energetic, enthusiastic, and pulsating with a dance groove. | 2009-05-03T12:50:31Z | Carnesy | ["Music", "Shuffle"] | ["instrumental", "fast tempo", "electronic music", "obscure audio", "thumping sounds", "vocalisation", "punchy beats", "robotic voice", "background chatter", "electronically arranged music", "home video", "home recording", "muffled audio", "psychedelic", "dance music", "edm", "catchy vocal riff"] | 7 | K2h6UiZSoZ4 | 2054 | ||
endless squad SHUFFLE | A female vocalist sings this high energy pop song. The tempo is fast with vigorous drumming, synthesiser arrangements and boomy bass drops. The song is vibrant, lively, spirited, buoyant, punchy and youthful with a catchy vocal riff. The sound quality of this song is inferior and distorted. This song is an EDM/Synth Pop song. | 2011-08-12T07:05:36Z | omingendless | ["Drum and bass", "House music", "Music", "Techno", "Trance music", "Shuffle", "Dubstep", "Electronic dance music"] | ["instrumental", "vibrant", "high strung", "female vocals", "punchy youthful", "dance groove", "inferior sound quality", "distorted sound", "catchy vocal riff", "electro rock", "electro pop", "edm", "distorted music", "synthesiser arrangements", "dj", "dance music", "party music", "club music", "vibrant", "buoyant", "boomy bass drops"] | 7 | YWf3I4jKusI | 3291 |
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;