musiccaps_details (view)
2 rows where musiccaps_aspects contains "distorted music" and musiccaps_author = 7 sorted by musiccaps_names
This data as json, CSV (advanced)
musiccaps_aspects (array) 40 ✖
- distorted music · 2 ✖
- instrumental 2
- ambient outdoor sounds 1
- boomy bass drops 1
- buoyant 1
- catchy vocal riff 1
- celebratory 1
- club music 1
- dance groove 1
- dance music 1
- distorted sound 1
- dj 1
- edm 1
- electro pop 1
- electro rock 1
- fast tempo 1
- female vocals 1
- festive 1
- guiro 1
- guiro accompaniment 1
- happy 1
- high strung 1
- inferior audio quality 1
- inferior sound quality 1
- joyful 1
- latin dance music 1
- latin music 1
- latin regional music 1
- live music 1
- live performance 1
- lively acordion 1
- party music 1
- punchy youthful 1
- scraper instrument 1
- spirited 1
- spirited congas 1
- static 1
- synthesiser arrangements 1
- vibrant 1
- world music 1
musiccaps_names (array) 11 ✖
- Music 2
- Accordion 1
- Drum and bass 1
- Dubstep 1
- Electronic dance music 1
- House music 1
- Maraca 1
- Musical instrument 1
- Shuffle 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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | ||
LUIS E.MARTINEZ EL CANTOR DE FONSECA | This music is a spirited Latin music instrumental. The tempo is fast with a lively accordion harmony, spirited congas beat and guiro accompaniment. The music is happy, vivacious, upbeat, vigorous, cheerful , celebratory and cheerful with ambient outdoor sounds like wind, people talking, clapping and a lot of static indicating that this is a live performance. The audio quality is inferior and this looks like an amateur home recording. | 2008-06-20T18:46:59Z | ALVARO VILLA FONTALVO | INTERPRETA EL CANTOR DE FONSECA EN COMPAÑIA DE SU AUTOR CARLOS HUERTAS EL CANTOR DE FONSECA- LUIS ENRIQUE INTERPRETA MAGISTRALMENTE SU ACORDEON, ENTRE LOS ASISTENTES ESTABA GABO, FUE EN EL AÑO 1993 EN B/QUILLA | ["Music", "Musical instrument", "Accordion", "Maraca"] | ["instrumental", "fast tempo", "distorted music", "static", "guiro accompaniment", "scraper instrument", "world music", "latin regional music", "latin dance music", "lively acordion", "spirited congas", "guiro", "latin music", "latin dance music", "happy", "spirited", "live performance", "live music", "ambient outdoor sounds", "inferior audio quality", "celebratory", "festive", "joyful"] | 7 | kpsYSXR1wao | 4360 |
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;