musiccaps_details (view)
2 rows where musiccaps_aspects contains "piano accompaniment" and musiccaps_aspects contains "retro pop song" sorted by video
This data as json, CSV (advanced)
musiccaps_aspects (array) 43 ✖
- piano accompaniment · 2 ✖
- retro pop song · 2 ✖
- backup singers 1
- bad audio quality 1
- bad quality audio 1
- cheerful 1
- cheerful positive 1
- clapping rhythm 1
- cymbals crashing 1
- dance groove 1
- different music tracks superimposed 1
- disco music 1
- disco romance hits 1
- emotional 1
- falsetto 1
- female singer 1
- female singers 1
- fun 1
- game show 1
- game time 1
- groovy bass line 1
- group singing 1
- guitar rhythm 1
- love song 1
- male singer singing 1
- marry me 1
- medium fast tempo 1
- musical background 1
- passionate 1
- pop song 1
- retro hits 1
- slowing down 1
- song retarding 1
- spirited 1
- steady drumming 1
- steady drumming bass line 1
- strong abs slime 1
- strong bass line 1
- talent show 1
- tambourine percussions 1
- together forever 1
- trumpets blaring 1
- vocal harmony 1
musiccaps_names (array) 3 ✖
- Music 2
- Clapping 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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
PACHUCO ROLAS VOL 1 | A female singer sings this passionate melody with backup singers in vocal harmony. The tempo is medium and gradually slows down towards the end. The drumming rhythm is steady and retards to the end with a percussive bass line and keyboard accompaniment. The song is a retro disco or R&B love song. The song has poor audio quality. | 2009-03-23T07:20:30Z | pachucojae | PACHUCO MEMORIES.... | ["Music", "Soul music"] | ["female singer", "disco music", "song retarding", "bad audio quality", "slowing down", "backup singers", "falsetto", "vocal harmony", "steady drumming", "groovy bass line", "piano accompaniment", "guitar rhythm", "tambourine percussions", "cymbals crashing", "retro pop song", "retro hits", "emotional", "love song", "passionate", "together forever", "disco romance hits", "marry me"] | 1 | iS-iTbHndw8 | 4185 |
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;