musiccaps_details (view)
2 rows where musiccaps_aspects contains "emphatic", musiccaps_aspects contains "foreign language" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- emphatic · 2 ✖
- foreign language · 2 ✖
- slow tempo 2
- beautiful melody 1
- burgeoning music 1
- call response 1
- chant 1
- church organ 1
- delicate 1
- eloquent vocals 1
- emotional 1
- enchanting 1
- harmonious singing 1
- intense 1
- keyboard harmony 1
- lilting melody 1
- male duet 1
- male singer 1
- mellifluous 1
- mellow 1
- melodic 1
- minimalist 1
- passioante 1
- passionate 1
- persuasive 1
- powerful vocals 1
- ritual 1
- sad vibe 1
- soft 1
- soothing 1
- two part harmony 1
musiccaps_names (array) 3 ✖
- Music 2
- Mantra 1
- Vocal music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
SRPSKE RASE PASA-Serbian Dog Breeds | A male vocalist sings this intense melody in a foreign language.The tempo is slow with a keyboard and organ accompaniment that is burgeoning as the song progresses. The vocals are eloquent, emphatic, persuasive and lilting and the vibe of the song is mellow, persuasive, passionate, emotional and appealing. | 2014-06-08T08:25:31Z | Miroslav Visnjic | http://www.srpskipas.com/ | ["Mantra", "Music"] | ["male singer", "slow tempo", "foreign language", "passionate", "burgeoning music", "eloquent vocals", "emphatic", "persuasive", "sad vibe", "keyboard harmony", "church organ", "minimalist", "lilting melody", "soft", "mellow", "emotional", "passioante", "intense"] | 7 | 2dyxjGTXSpA | 393 | |
Блаженны - Знаменный распев с исоном. | This song is a duet sung in a two part harmony in a foreign language. The tempo is slow with a male voice chanting a call to which the response is this melodious harmony. The song is soothing, calming, delicate, charming and melodic. This could possibly be a religious ritual. | 2014-01-22T17:17:01Z | Иеродиакон Герман | Московское подворье Валаамского монастыря. Божественная литургия. 22 января 2014. | ["Music", "Vocal music"] | ["male duet", "slow tempo", "two part harmony", "emphatic", "powerful vocals", "ritual", "mellifluous", "beautiful melody", "delicate", "chant", "call response", "soothing", "harmonious singing", "melodic", "enchanting", "foreign language"] | 7 | ppAT0f2YCyM | 4738 |
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;