musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "groovy bass line", musiccaps_aspects contains "guitar lead" and musiccaps_aspects contains "keyboard harmony"
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- groovy bass line · 2 ✖
- guitar lead · 2 ✖
- keyboard harmony · 2 ✖
- amateur playing 1
- amateur rock band 1
- ambient music 1
- backup singers 1
- casual rock 1
- chill-out music 1
- choral harmony 1
- christian praise songs 1
- classic rock influences 1
- congregational 1
- congregational singing 1
- devotional 1
- echo tones 1
- female singer 1
- filler music 1
- guitar rhythm 1
- home recording 1
- inspiring 1
- male singer 1
- meditative 1
- medium tempo 1
- modern pop 1
- motivational 1
- out of time 1
- poor audio quality 1
- praise and worship 1
- prayer 1
- relaxing 1
- slow tempo 1
- steady drumming rhythm 1
- string drumming rhythm 1
- vocal duet 1
musiccaps_names (array) 7 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Relaxation Music Progressive Rock | The song is an instrumental music piece. The song is slow tempo with an electric guitar playing lead with heavy echoes, steady drumming and a keyboard harmony. The song is casual and slightly out of rhythm. The song is an instrumental with a casual listening vibe. | 2011-10-11T06:06:56Z | Gothenburg Music | Relaxation Music Progressive Rock, Rock jam and improvisation | ["Electric guitar", "New-age music", "Music", "Rock music", "Steel guitar, slide guitar", "Distortion"] | ["slow tempo", "guitar lead", "steady drumming rhythm", "filler music", "relaxing", "home recording", "chill-out music", "modern pop", "classic rock influences", "amateur rock band", "ambient music", "groovy bass line", "echo tones", "relaxing", "out of time", "amateur playing", "keyboard harmony", "casual rock"] | 1 | UrgzGbGVV8I | 2948 | |
Mighty To Save | A male and female singer sing this vocal duet with a choral vocal harmony. The song is medium tempo with a groovy bass line, steady drumming rhythm, guitar lead, guitars playing rhythm and keyboard harmony. The song is devotional and congregational. The song is a Christian praise and worship song with poor audio quality. | 2007-01-03T22:51:34Z | Rachel Thomson | PLEASE READ - Comments have been disabled. If you do have any positive comments you would like to share, please do mail me. I’d be really encouraged to hear from you. John 13 v 34-35 "A new command I give you: Love one another. As I have loved you, so you must love one another. 35 By this everyone will know that you are my disciples, if you love one another." I know the reference should be 2 Chronicles 7:14, at the end, not 2 Corinthians 7:14. Sorry for that mistake, but I can't amend it. This is one of my favourite songs ever , the message is fantastic, it speaks of how God is mighty to save us and how is so mighty that he can move mountains. Also, there is no copyright infringement intended here, just the spreading of Gods word. Also, I don't own the bible verses, they're from God's word, which He wants the whole world to hear, so no fear of copyright there! Haha. His Word is unique :) Enjoy, | ["Christian music", "Music"] | ["poor audio quality", "male singer", "female singer", "guitar lead", "choral harmony", "backup singers", "vocal duet", "congregational singing", "christian praise songs", "praise and worship", "medium tempo", "guitar rhythm", "groovy bass line", "keyboard harmony", "meditative", "congregational", "devotional", "inspiring", "prayer", "motivational", "string drumming rhythm"] | 1 | sR8rlTIU8_Y | 4949 |
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;