musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "slow tempo" and musiccaps_aspects contains "trumpets" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- slow tempo · 2 ✖
- trumpets · 2 ✖
- bass 1
- calm 1
- christian praise and worship 1
- christian song 1
- christmas song 1
- contemporary christian music 1
- crossover song 1
- dulcet 1
- easter song 1
- emotional 1
- emotional song 1
- euphonious 1
- female backing voices 1
- good friday 1
- gospel music 1
- guitar 1
- instrumental 1
- instrumental cover 1
- male voice 1
- mellow 1
- piano accompaniment 1
- reggae bassline 1
- reggae song 1
- rhythmic acoustic guitar 1
- sentimental 1
- sere 1
- simple percussion 1
- soft 1
- soothing 1
- soul song 1
- synth sounds 1
- synthesiser arrangement 1
- trombone harmony 1
- tuba accompaniment 1
musiccaps_names (array) 6 ✖
- Afrobeat 1
- Brass instrument 1
- French horn 1
- Music 1
- Music of Africa 1
- Reggae 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Thorns in the Straw | This song is an instrumental interlude of the Gospel song ‘Thorns in the Straw. The music is slow with a melancholic trombone and tuba harmony, acoustic guitar accompaniment , bass, steady drumming,and synthesiser arrangements. The music is soft, mellow, poignant,pensive, sentimental,emotional, reflective and serene. This song is a Gospel Instrumental. | 2008-12-22T00:26:42Z | Mike Rutter | A video using 'Thorns in the Straw' by Graham Kendrick | ["Brass instrument", "French horn"] | ["instrumental", "slow tempo", "rhythmic acoustic guitar", "trumpets", "trombone harmony", "tuba accompaniment", "bass", "piano accompaniment", "synthesiser arrangement", "soft", "mellow", "gospel music", "instrumental cover", "christian song", "christian praise and worship", "easter song", "good friday", "christmas song", "contemporary christian music", "mellow", "dulcet", "euphonious", "sentimental", "sere", "calm", "soothing", "emotional"] | 7 | 7OjXHfVoI64 | 843 | |
|AFRICA UNITE| Rebellion, Mandingo, DJ Taff, Good Vibration @ Stadtwerkstatt Linz | This song is a crossover of a reggae song with a soul song. This features a male voice singing the main melody. It starts off with the voice which is accompanied by the guitar, bass and percussion playing in the pause between lines. During the pause, a synth sound is played which is modulated by a ring modulator. After the pause, the voice starts the main melody. Trumpets play a melody. The bass and percussion continue to play with a reggae feel. Female backing voices sing vocables. This song is relaxing. This song can be played at the end of a war movie. | 2010-04-29T21:39:57Z | GoodVibrationSound | ["Afrobeat", "Music of Africa", "Music", "Reggae"] | ["reggae song", "soul song", "crossover song", "male voice", "guitar", "reggae bassline", "synth sounds", "trumpets", "simple percussion", "female backing voices", "slow tempo", "emotional song"] | 0 | chfTjqlrFQQ | 3731 |
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;