musiccaps_details (view)
2 rows where musiccaps_aspects contains "jazz" and musiccaps_names contains "Lullaby"
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- jazz · 2 ✖
- audio crackles 1
- calming 1
- emotional 1
- gentle 1
- groovy 1
- groovy piano chords 1
- improvisation 1
- instrumental 1
- jam 1
- keyboard 1
- live performance 1
- low quality 1
- no singer 1
- passionate 1
- passionate female vocal 1
- piano sound 1
- shimmering hi hats 1
- single instrument 1
- smooth double bass 1
musiccaps_names (array) 6 ✖
- Lullaby · 2 ✖
- Music 2
- Keyboard (musical) 1
- Musical instrument 1
- Piano 1
- Synthesizer 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Lullaby of Birdland - Shearing & Weiss - Nasiya Alzhanova | The low quality recording features a live performance of a jazz song and it features a passionate female vocal singing over shimmering hi hats, groovy piano chords and smooth double bass. The recording has some audio crackles and that would be the only reason for it to go under the "low quality" category. It sounds emotional, passionate and groovy. | 2014-07-17T20:13:49Z | accademiadelsuono | Nasiya Alzhanova is a Modern Music Singing Course student. Nasiya studies Singing with Leyla Tommasi. Nasiya Alzhanova è iscritta al Corso di Canto Moderno. Nasiya studia canto con Leyla Tommasi. | ["Music", "Lullaby"] | ["low quality", "jazz", "passionate female vocal", "groovy piano chords", "smooth double bass", "shimmering hi hats", "audio crackles", "live performance", "emotional", "passionate", "groovy"] | 4 | ETl0hYRlVmg | 1562 | |
Nord Stage 2 - Demo (Full version) | This is the recording of a jazz improvisation performance. It is in an instrumental piece performed with a keyboard that utilizes a classical piano sound. The chords are being played gently which creates a calming atmosphere. Due to various chords and lines being played in this performance, parts of it could be lifted to be used as piano samples for a beat. It could also be playing in the background of a restaurant or a jazz bar. | 2011-06-29T11:02:48Z | nordkeyboards | Demonstration of Nord's new flagship keyboard, the Nord Stage 2. Read more about the Nord Stage 2 here: bitly.com/nordstage2 Music and performance: Federico Solazzo Thanks to our Italian distributor Mogar for creating the video! | ["Music", "Musical instrument", "Keyboard (musical)", "Piano", "Lullaby", "Synthesizer"] | ["jazz", "improvisation", "no singer", "instrumental", "single instrument", "jam", "keyboard", "piano sound", "gentle", "calming"] | 9 | M4rXhyyvERM | 2240 |
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;