musiccaps_details (view)
4 rows where musiccaps_aspects contains "live performance", musiccaps_aspects contains "unbalanced stereo" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 38 ✖
- live performance · 4 ✖
- low quality 4
- unbalanced stereo · 4 ✖
- groovy bass 2
- happy 2
- noisy 2
- passionate 2
- shimmering cymbals 2
- accordion melody 1
- acoustic rhythm guitar 1
- arpeggiate synth keys melody 1
- big bend 1
- boomy kick 1
- crowd excitement 1
- crushed 1
- distorted bass 1
- easygoing 1
- fat snare 1
- folk 1
- fun 1
- groovy double bass 1
- harmonizing female vocal 1
- harmonizing mixed vocals 1
- harsh 1
- jazz 1
- mellow piano chords 1
- mystical 1
- passionate trumpet melody 1
- punchy kick 1
- punchy snare 1
- reverberant 1
- saxophone melody 1
- shimmering hi hats 1
- shimmering tambourine 1
- short strings melody 1
- soulful 1
- traditional music 1
- trumpet melody 1
musiccaps_names (array) 9 ✖
- Music 3
- Accordion 1
- Brass instrument 1
- Musical instrument 1
- Saxophone 1
- Swing music 1
- Traditional music 1
- Trombone 1
- Whoop 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ethiopian Traditional Music Hiywet Fiqer | The low quality recording features a live performance of traditional music and it consists of harmonizing female vocals singing over shimmering hi hats and tambourine hits, fat snare, boomy kick, groovy bass and short strings melody. The stereo image is unbalanced as the vocals are leaning towards the right channel of the stereo image. It sounds soulful and happy. | 2014-11-01T21:19:53Z | OneLoveNetwork | ["Traditional music", "Music"] | ["low quality", "soulful", "live performance", "happy", "traditional music", "harmonizing female vocal", "unbalanced stereo", "shimmering hi hats", "fat snare", "groovy bass", "short strings melody", "boomy kick", "shimmering tambourine"] | 4 | 1i1sbQOILb0 | 300 | ||
The Rescues - Shout by Tears for Fears | The low quality recording features a live performance that consists of harmonizing mixed vocals singing over distorted bass and arpeggiated synth keys melody. It sounds crushed, harsh and the stereo image is unbalanced since the sound is leaning towards the right channel of the stereo image. There are some crowd excitement sounds in the background. | 2009-08-30T15:17:59Z | thevmannc | New Project 1 | ["Music", "Whoop"] | ["low quality", "harmonizing mixed vocals", "harsh", "live performance", "distorted bass", "arpeggiate synth keys melody", "crushed", "crowd excitement", "unbalanced stereo", "mystical"] | 4 | DKBbLySEGic | 1463 | |
Welcome to Big Band Music - Swing and Jazz in Denmark | The low quality recording features a live performance of a jazz big bend that consists of passionate trumpet melody, over groovy double bass, shimmering cymbals and mellow piano chords. It sounds reverberant, happy, passionate and fun. The recording is a bit noisy and the sound is leaning towards the right channel, which makes the stereo image unbalanced. | 2010-02-04T21:07:14Z | Kurt Lykke Lindved | Randers Big Band is one of the best Big Bands in Denmark with more More than 30 years experience in the fields of swing, jazz and musicals - A dynamic band and popular in a greater part of the world. The repertoire is wide spread in styles and performances including the music from evergreens to our today`s modern tunes in swing and jazz. Several famous vocalists have been performing with the band and a yearly tradition like the New Year`s Brunch Concert is always popular and visited again and again by the same audience including the newcomers. | ["Brass instrument", "Saxophone", "Trombone"] | ["low quality", "noisy", "live performance", "unbalanced stereo", "reverberant", "passionate trumpet melody", "jazz", "big bend", "shimmering cymbals", "mellow piano chords", "groovy double bass", "passionate", "happy", "fun"] | 4 | S0W_zIUYwrE | 2733 | |
Karène Neuville 14 ans - Pasos Lesterps 2015 | The low quality recording features a live performance of a folk song that contains an accordion melody playing over acoustic rhythm guitar, groovy bass, punchy kick and snare hits, shimmering cymbals, saxophone and trumpet melody. It sounds passionate and easygoing, even though the recording is noisy and the stereo image is unbalanced, due to the fact that the sound is leaning towards the left channel. | 2015-07-21T19:29:48Z | Armand Boudet | Je vous invite aujourd'hui à visiter le site www.kareneneuville.fr dans lequel vous trouverez toutes les infos sur l'agenda de Karène et les CD disponibles à la vente | ["Swing music", "Music", "Musical instrument", "Accordion"] | ["low quality", "live performance", "folk", "accordion melody", "acoustic rhythm guitar", "shimmering cymbals", "punchy kick", "punchy snare", "saxophone melody", "trumpet melody", "groovy bass", "noisy", "unbalanced stereo", "passionate", "easygoing"] | 4 | gsIB8HjsRtw | 4064 |
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;