musiccaps_details (view)
2 rows where musiccaps_aspects contains "bad quality audio" and musiccaps_aspects contains "strong bass line"
This data as json, CSV (advanced)
musiccaps_aspects (array) 43 ✖
- bad quality audio · 2 ✖
- spirited 2
- strong bass line · 2 ✖
- bollywood music 1
- buzzing 1
- cheerful 1
- cheerful positive 1
- clapping rhythm 1
- dance groove 1
- deteriorated audio quality 1
- different music tracks superimposed 1
- emotional 1
- female singers 1
- fun 1
- game show 1
- game time 1
- group singing 1
- guitar accompaniment 1
- humming 1
- longing for you 1
- love song 1
- madly in love 1
- male singer 1
- male singer singing 1
- medium fast tempo 1
- medium tempo 1
- movie soundtrack 1
- musical background 1
- no percussion instruments 1
- passionate 1
- piano accompaniment 1
- poor audio quality 1
- pop song 1
- retro pop song 1
- romantic 1
- soaring vocals 1
- steady drumming bass line 1
- strong abs slime 1
- talent show 1
- tamil love songs 1
- tamil movie songs 1
- trumpets blaring 1
- violin accompaniment 1
youtube_published (date) 2 ✖
- 2010-08-29 1
- 2014-03-17 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Gincana Criativa 2010 - Gritos de Guerra | A male singer sings this cool melody in the background with a bunch of female singers singing a little jig in a different key. The song is medium tempo with steady drumming, tambourine percussion, trumpets blaring, strong bass line and a piano accompaniment. The song serves as a background music to a group of females singing a jig in a different key. The song is a modern pop dance tune. | 2010-08-29T18:50:10Z | Ketty Ritzke | -- STAFF -- Gritos de Guerra das Equipes participantes da Gincana Criativa 2010 - Uniasselvi, realizada pela Professora Márcia. | ["Music", "Clapping"] | ["female singers", "male singer singing", "different music tracks superimposed", "bad quality audio", "group singing", "strong bass line", "game show", "talent show", "musical background", "trumpets blaring", "medium fast tempo", "clapping rhythm", "steady drumming bass line", "piano accompaniment", "strong abs slime", "dance groove", "pop song", "retro pop song", "cheerful positive", "spirited", "game time", "fun", "cheerful"] | 1 | gigxzYegRqM | 4048 | |
Nenjam Pesuthey Male Humming song | A male singer sings this soaring melody. The song is medium tempo with a guitar accompaniment, strong bass line and a violin accompaniment. The song quality is poor and badly deteriorated. The song is a romantic love song from a Tamil movie. | 2014-03-17T01:41:42Z | VENGADASSALAM K | Photo Add | ["Humming", "Music"] | ["male singer", "soaring vocals", "bad quality audio", "tamil love songs", "poor audio quality", "medium tempo", "emotional", "passionate", "madly in love", "longing for you", "tamil movie songs", "movie soundtrack", "guitar accompaniment", "violin accompaniment", "no percussion instruments", "romantic", "deteriorated audio quality", "humming", "buzzing", "romantic", "love song", "spirited", "passionate", "bollywood music", "strong bass line"] | 1 | k3A5xX8yfig | 4295 |
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;