musiccaps_details (view)
3 rows where musiccaps_aspects contains "entertaining" and musiccaps_aspects contains "groovy rhythm"
This data as json, CSV (advanced)
musiccaps_aspects (array) 41 ✖
- cheerful 3
- entertaining · 3 ✖
- groovy rhythm · 3 ✖
- bad audio quality 2
- keyboard accompaniment 2
- medium tempo 2
- positive 2
- vocal harmony 2
- accordion accompaniment 1
- accordion players 1
- animated vocals 1
- average audio quality 1
- backup singer 1
- backup singers 1
- bouncy drum rhythm 1
- dance rhythm 1
- emotional 1
- energetic 1
- groovy bass line 1
- guitar accompaniment 1
- guitar lead 1
- guitar rhythm 1
- gypsy music influences 1
- horns playing 1
- idyllic fun 1
- instrumental music 1
- keybiard accompaniment 1
- latin dance song 1
- latin pop song 1
- love song 1
- male latin singer 1
- male singer 1
- nostalgic 1
- organ accompaniment 1
- pop song 1
- reggae music influences 1
- retro instrumental 1
- romantic 1
- steady bass line 1
- the good life 1
- video sound track 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
พ่อพันธุ์วัวไทยพื้นเมือง | A male singer sings this cool and animated melody with backup singers in vocal harmony. The song is medium tempo with steady drumming rhythm, groovy bass line, organ accompaniment and horns playing. The song is entertaining and cheerful. The audio quality is bad. | 2012-07-22T11:31:33Z | thanandorn limlek | ขออนุญาตเจ้าของวัวครับ | ["Afrobeat", "Music of Africa", "Music"] | ["male singer", "backup singer", "vocal harmony", "cheerful", "positive", "animated vocals", "video sound track", "guitar rhythm", "horns playing", "organ accompaniment", "steady bass line", "groovy rhythm", "energetic", "entertaining", "bad audio quality", "pop song", "medium tempo", "keyboard accompaniment"] | 1 | Ipow026xzVw | 1945 | |
PABLITO CERRANO Y ARIEL TORRES A PURO CHAMAME | The song is an instrumental. The song is medium tempo with two accordion players playing on harmony and no other instrumentation. The music is romantic and passionate. The song has gypsy music roots. | 2012-11-01T00:48:18Z | RAM TOR | POR CONTRATACIONES COMUNICARSE AL( 03844)(15)468108 | ["Accordion"] | ["accordion players", "accordion accompaniment", "gypsy music influences", "emotional", "dance rhythm", "retro instrumental", "nostalgic", "entertaining", "cheerful", "positive", "the good life", "idyllic fun", "instrumental music", "bad audio quality", "groovy rhythm", "medium tempo"] | 1 | Jsk3ZUGvP-o | 2042 | |
Bowl for Two - The Expendables | A male singer sings this cheerful melody with backup singers in vocal harmony. The song is medium tempo with a reggae style drum and guitar accompaniment, guitar lead and a groovy bass line. The song is romantic and cheerful . The song is a Latin pop dance song. The audio quality is average. | 2007-09-02T03:29:08Z | P3DRO2 | lovin it | ["Music", "Happy music"] | ["male latin singer", "backup singers", "vocal harmony", "keyboard accompaniment", "average audio quality", "groovy bass line", "guitar accompaniment", "guitar lead", "bouncy drum rhythm", "reggae music influences", "keybiard accompaniment", "entertaining", "cheerful", "romantic", "love song", "latin pop song", "latin dance song", "groovy rhythm"] | 1 | euAQCWBX6ns | 3904 |
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;