musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "emotional", musiccaps_aspects contains "noisy" and musiccaps_aspects contains "shimmering hi hats"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- emotional · 3 ✖
- low quality 3
- noisy · 3 ✖
- passionate 3
- shimmering hi hats · 3 ✖
- electric guitar melody 2
- live performance 2
- mono 2
- arpeggiated guitar melody 1
- classical 1
- crowd clapping 1
- french horn melody 1
- groovy bass guitar 1
- passionate male vocal 1
- playback 1
- punchy kick 1
- regional mexican 1
- shimmering tambourine 1
- snappy rimshots 1
- soft synth keys melody 1
- soulful 1
- subtle female vocal 1
- sustained violin melody 1
- theremin solo 1
musiccaps_names (array) 10 ✖
- Music 2
- Brass instrument 1
- Christmas music 1
- Country 1
- French horn 1
- Gospel music 1
- Guitar 1
- Singing 1
- Song 1
- Wedding music 1
youtube_published (date) 3 ✖
- 2009-01-31 1
- 2012-04-20 1
- 2014-12-23 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Sweet Memories- Tess Sears tribute to her mom Dawn Sears | The low quality recording features a classical live performance of sustained violin melody, shimmering hi hats, electric guitar melody, theremin solo melody and subtle female vocals at the end of the loop. There are some crowd clapping sounds in the background. It is noisy, in mono and it sounds passionate and emotional. | 2014-12-23T23:40:06Z | Tesla Dawn | Tess Sears sings her moms song Sweet Memories in memory of her mother Dawn Sears at the first Monday night Time Jumper meeting after her passing. | ["Singing", "Country", "Guitar", "Music", "Wedding music"] | ["classical", "sustained violin melody", "crowd clapping", "shimmering hi hats", "theremin solo", "subtle female vocal", "live performance", "electric guitar melody", "low quality", "noisy", "mono", "passionate", "emotional"] | 4 | -WvVG0wHcTc | 57 | |
What a wonderful world Bb Horn | The low quality recording features a french horn melody played over playback that consists of snappy rimshots, shimmering hi hats and arpeggiated guitar melody. It sounds emotional and passionate, even though the recording is in mono and noisy. | 2009-01-31T21:52:21Z | KamilToni | Playing what a wonderful world on a Berkeley Bb piccolo/ mini french horn with a strawberries and creme mouthpieces MDC from kelly mouthpieces. i wasn't feeling good and i just wanted to post something up with this instrument.. | ["Brass instrument", "French horn"] | ["low quality", "mono", "noisy", "playback", "arpeggiated guitar melody", "snappy rimshots", "shimmering hi hats", "french horn melody", "emotional", "passionate"] | 4 | MNlzpCwdh4g | 2261 | |
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;