musiccaps_details (view)
2 rows where musiccaps_aspects contains "people dancing" and musiccaps_aspects contains "strong drumming rhythm"
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- energetic 2
- people dancing · 2 ✖
- strong drumming rhythm · 2 ✖
- adrenaline rush 1
- aggressive vocals 1
- bad audio quality 1
- beeping tones 1
- dance groove 1
- dance music 1
- dance rhythm 1
- disco club 1
- dj 1
- edm 1
- electronic dance music 1
- excitement 1
- explicit trance keyboard tones 1
- fast tempo 1
- fats tempo 1
- groovy bass line 1
- grunge keyboard tones 1
- keyboard harmony 1
- male rapper 1
- male singer 1
- medium tempo 1
- passionate 1
- percussive bass line 1
- poor audio quality 1
- rap hits 1
- retro rap hits 1
- robotic harmony tones 1
- story telling 1
- string drumming rhythm 1
- tambourine percussions 1
- trance music 1
- youthful 1
musiccaps_names (array) 5 ✖
- Music 2
- Dubstep 1
- Electronic music 1
- Field recording 1
- Rapping 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Wowee one - heavy bass clear sound - playing dubstep | A male singer sings this aggressive vocal. The song is medium tempo with a slick drumming rhythm, groovy bass line, sonic tones, keyboard harmony and various percussive hits. The song is a modern electronic dance music with trance influences. The song has bad quality audio issues. | 2011-08-21T14:51:25Z | FRAGGA1992 | wowee one heavy bass clear sound test dubstep | ["Electronic music", "Music", "Field recording", "Dubstep"] | ["bad audio quality", "electronic dance music", "dj", "strong drumming rhythm", "trance music", "medium tempo", "string drumming rhythm", "groovy bass line", "keyboard harmony", "energetic", "youthful", "robotic harmony tones", "male singer", "dance music", "disco club", "edm", "people dancing", "aggressive vocals", "explicit trance keyboard tones"] | 1 | 2ZgEbNi--8Q | 380 | |
Kai - Grind Low | A male rapper sings this exciting melody. The tempo is fast with a groovy bass line, grunge keyboard tones, strong drumming rhythm, various percussion hits and beeping tones. The song is pulsating and energetic. The audio quality is very poor. | 2008-03-06T13:46:34Z | kilickai | ["Music", "Rapping"] | ["male rapper", "poor audio quality", "beeping tones", "fast tempo", "people dancing", "retro rap hits", "tambourine percussions", "strong drumming rhythm", "percussive bass line", "story telling", "adrenaline rush", "passionate", "energetic", "excitement", "dance rhythm", "dance groove", "fats tempo", "poor audio quality", "rap hits", "grunge keyboard tones"] | 1 | 9STauy5DsC8 | 1009 |
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;