musiccaps_details (view)
2 rows where musiccaps_aspects contains "devotional", musiccaps_aspects contains "emotional" and musiccaps_names contains "Independent music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- devotional · 2 ✖
- emotional · 2 ✖
- acoustic drums 1
- acoustic guitar 1
- bass guitar 1
- christian gospel music 1
- christian praise and worship 1
- christian song 1
- foreign language 1
- gospel 1
- holy 1
- hymn 1
- jewish 1
- male singer 1
- male vocal 1
- mellow 1
- melodic singing 1
- minimalist music 1
- prayerful 1
- religious 1
- reverence 1
- rhythmic acoustic guitar 1
- slow tempo 1
- soft 1
- soft piano accompaniment 1
- steady drumming 1
- strings 1
musiccaps_names (array) 6 ✖
- Independent music · 2 ✖
- Music 2
- Music of Asia 1
- Song 1
- Soul music 1
- Swing music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
אברימי רוט - אלבום 'אמת ויציב' ♫ Rote&Green Sampler | This is a Jewish gospel music piece. There is a male vocalist singing melodically in the Hebrew language. A strings section is playing the melody with the acoustic guitar and the bass guitar in the backing. In the rhythmic background, the acoustic drums are playing a simple 4/4 beat. The atmosphere of this piece is religious/devotional. It could be used in Jewish religious events or related social media content. | 2013-09-16T12:16:05Z | אברימי רוט Avremi Roth | אברימי בפייסבוק: https://Facebook.com/AvremiR אברימי באינסטגרם: https://instagram.com/avremiroth אברימי בטוויטר: https://Twitter.com/avremi_roth אברימי ביוטיוב: https://YouTube.com/ybaudio להזמנת אירועים ומופעים: נייד: 054-8087150 דוא"ל: Avremiroth@gmail.com | ["Swing music", "Music", "Independent music"] | ["jewish", "gospel", "male vocal", "melodic singing", "strings", "acoustic guitar", "bass guitar", "acoustic drums", "religious", "emotional", "devotional"] | 9 | JU4CZ-GApu4 | 2010 | |
Ով Մեծ Աստված - Ժիլպերդ Հովսէփեան | This song is a mellow Christian hymn in a foreign language. The tempo is slow with soft piano, rhythmic acoustic guitar, steady drumming and keyboard harmony. The music is minimalist and the song is a prayerful, melodious, devotional, emotional and thankful Gospel Song/Hymn. | 2009-08-01T11:53:11Z | abbcnj | Armenian Christian music video - Gilbert Hovsepian | ["Music of Asia", "Music", "Independent music", "Song", "Soul music"] | ["male singer", "slow tempo", "foreign language", "soft piano accompaniment", "rhythmic acoustic guitar", "steady drumming", "minimalist music", "christian song", "christian praise and worship", "hymn", "christian gospel music", "soft", "mellow", "devotional", "emotional", "prayerful", "reverence", "holy"] | 7 | Jdy08IPLKdw | 2025 |
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;