musiccaps_details (view)
2 rows where musiccaps_aspects contains "no percussion" and musiccaps_names contains "Vocal music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- no percussion · 2 ✖
- acoustic guitar 1
- amateur recording 1
- ambient sounds 1
- calming song 1
- child's voice 1
- dreamy feel 1
- holiday song 1
- low pitched synths 1
- low pitched voices 1
- low quality audio 1
- meditation music 1
- no other instruments 1
- relaxing music 1
- religious chanting 1
- slow tempo 1
- vocables backing 1
musiccaps_names (array) 9 ✖
- Music 2
- Vocal music · 2 ✖
- Chant 1
- Child speech, kid speaking 1
- Choir 1
- Christmas music 1
- Humming 1
- Mantra 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Mercado Kids Singing Christmas song Mary Did You Know by Mark Lowry | This low quality audio features a child singing the main melody. This is accompanied by other children's voices singing vocables in the background in harmony. An acoustic guitar strums chords. There are no other instruments in this song. This song has a holiday mood. This song can be played in a Christmas movie. | 2014-01-01T03:51:21Z | MercadoFamilyMusic | Hey all! This is our first YouTube upload. We are a sibling group from North Carolina. We love music, performing and most of all we love our Lord and Savior, Jesus Christ. We hope that you enjoy what we have to share. God bless! ~The Mercados Jeremiah 1:5-9 Please like, comment, subscribe and share! Be looking for more videos from us. mercadofamilymusic@gmail.com | ["Christmas music", "Singing", "Humming", "Music", "Choir", "Vocal music", "Child speech, kid speaking"] | ["amateur recording", "low quality audio", "child's voice", "vocables backing", "acoustic guitar", "no percussion", "no other instruments", "holiday song", "slow tempo"] | 0 | Ve6Zy1BXBbY | 3015 | |
Green Tara Mantra - Dalai Lama - Meditation | This meditation song features male voices chanting in deep, low voices. This is accompanied by synth sounds playing at different pitches. One of the synths plays a droning low pitch sound. The mid and higher register sounds play instruments sounding like wind instruments. The sounds produced are ambient sounds and have a dreamy feel. The song is relaxing and calming. This song can be played in a meditation center. | 2011-05-13T23:11:11Z | Luciano Antunes | Mantra entoado por Sua Santidade o Dalai Lama. mantra chanted by His Holiness the Dalai Lama. OM TARE TUTTARE TURE SOHA | ["Mantra", "Chant", "Music", "Vocal music"] | ["meditation music", "low pitched synths", "low pitched voices", "dreamy feel", "calming song", "no percussion", "religious chanting", "relaxing music", "ambient sounds"] | 0 | ac_8oRMgDz0 | 3558 |
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;