musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "soulful" and musiccaps_names contains "Gospel music" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- emotional 2
- low quality 2
- passionate 2
- shimmering hi hats 2
- soulful · 2 ✖
- acoustic rhythm guitar 1
- country 1
- electric guitar melody 1
- electric guitar solo melody 1
- groovy bass guitar 1
- harmonizing vocals 1
- live performance 1
- noisy 1
- passionate male vocal 1
- punchy kick 1
- regional mexican 1
- shimmering tambourine 1
- smooth bass guitar 1
- snappy rimshot 1
- soft kick hits 1
- soft synth keys melody 1
musiccaps_names (array) 6 ✖
- Gospel music · 2 ✖
- Music 2
- Christian music 1
- Christmas music 1
- Happy music 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Singing Cooke's--Family Circle | The low quality recording features a country song that contains harmonizing vocals singing over electric guitar solo melody, smooth bass guitar, acoustic rhythm guitar, snappy rimshots, shimmering hi hats and soft kick hits. It sounds soulful, emotional and passionate. | 2010-12-11T03:34:48Z | Nexar41834 | ["Gospel music", "Christian music", "Music", "Happy music"] | ["low quality", "country", "harmonizing vocals", "electric guitar solo melody", "smooth bass guitar", "snappy rimshot", "shimmering hi hats", "soft kick hits", "acoustic rhythm guitar", "soulful", "emotional", "passionate"] | 4 | mlpTCec4igo | 4490 | ||
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 |
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;