musiccaps_details (view)
3 rows where musiccaps_aspects contains "emotional", musiccaps_author = 4 and musiccaps_names contains "Christmas music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- emotional · 3 ✖
- passionate 3
- low quality 2
- noisy 2
- audio cut 1
- country 1
- electric guitar melody 1
- fruity male vocal 1
- groovy bass guitar 1
- heartfelt 1
- keys chords 1
- live performance 1
- mellow piano chords 1
- mono 1
- passionate male vocal 1
- percussive acoustic rhythm guitar 1
- punchy kick 1
- regional mexican 1
- shimmering hi hats 1
- shimmering tambourine 1
- simple bass 1
- soft synth keys melody 1
- soulful 1
musiccaps_names (array) 8 ✖
- Christmas music · 3 ✖
- Music 3
- Christian music 1
- Classical music 1
- Electric piano 1
- Gospel music 1
- Musical instrument 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Johanna Kurkela - Joululaulu | The low quality recording features mellow piano chords playing. There is a short audio cut and the recording is noisy and in mono. | 2006-09-15T02:41:39Z | biljardi | Johanna Kurkela esittää Mel Tormén Joululaulun. | ["Christmas music", "Electric piano", "Christian music", "Music", "Musical instrument", "Classical music"] | ["low quality", "mellow piano chords", "noisy", "mono", "passionate", "emotional", "audio cut"] | 4 | NBnz0xV9nb4 | 2324 | |
Chiquilla. Interpretacion GRUPO FREE SOUNDS de Ensenada, BC | The low quality recording features a live performance of a regional Mexican song and it consists of passionate male vocal singing over groovy bass guitar, mellow synth keys melody and electric guitar melody, followed by shimmering tambourine, hi hats and punchy kick. It sounds passionate, emotional and soulful - like something you would hear at family gathering events. | 2012-04-20T18:44:22Z | victor lopez | PRESENTACION EN EL PROGRAMA LA VELADA DE SINTESIS TELEVISION TIJUANA (DERECHOS RESERVADOS) DEL GRUPO MUSICAL FREE SOUNDS DE ENSENADA, BC | ["Christmas music", "Gospel music", "Music", "Song"] | ["low quality", "live performance", "regional mexican", "passionate male vocal", "groovy bass guitar", "soft synth keys melody", "shimmering tambourine", "punchy kick", "electric guitar melody", "noisy", "passionate", "emotional", "soulful", "shimmering hi hats"] | 4 | RNwiEsjrhiQ | 2694 | |
George Jones - Colour of the Blues - Country Music Experience | The Country song features a fruity male vocal singing over percussive acoustic rhythm guitar, simple bass and keys chords. It sounds emotional, passionate and heartfelt - like something you would hear in the old pubs and bars. | 2012-10-07T07:52:56Z | Country Music Experience | Country Music Experience : (Re)Discover the finestcountry Music Selection. Country Music experience is your channel for all the country music, where you can experience music, in high audio quality. Subscribe to stay connected to our channel and receive all of our video updates! -Country Music experience | ["Christmas music", "Music"] | ["country", "percussive acoustic rhythm guitar", "keys chords", "fruity male vocal", "emotional", "passionate", "heartfelt", "simple bass"] | 4 | tGic59TlrVg | 5022 |
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;