musiccaps_details (view)
2 rows where musiccaps_aspects contains "beautiful melody" and musiccaps_author = 7 sorted by musiccaps_caption
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- beautiful melody · 2 ✖
- melodic 2
- call response 1
- chant 1
- cheerful 1
- delicate 1
- double reed 1
- emphatic 1
- enchanting 1
- energetic 1
- fast tempo 1
- flute harmony 1
- foreign language 1
- happy 1
- harmonious singing 1
- high pitched flute 1
- instrumental 1
- low pitch instrument 1
- low pitched bassoon accompaniment 1
- male duet 1
- mellifluous 1
- powerful vocals 1
- rich 1
- ritual 1
- shakers 1
- slow tempo 1
- soothing 1
- spirited 1
- tenor bass range 1
- two part harmony 1
- warm 1
- wind instrument 1
- woodwindninst 1
musiccaps_names (array) 3 ✖
- Accordion 1
- Music 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 |
---|---|---|---|---|---|---|---|---|---|---|
Alluring Secret~Black Vow- flute, piano, violin, clarinet and bassoon | This music is instrumental. The tempo is fast with an enthusiastic flute harmony and bassoon accompaniment. The music is upbeat, catchy, engaging, vivacious, melodic, cheerful, happy and pleasant. This music is an upbeat classical instrumental. | 2011-02-11T23:15:01Z | Lauren Gould | Sheet music download: http://www.mediafire.com/view/?ekb99fzjbkb1fpd Please credit me if you use my sheets :3 Thank you so much for watching :3 original song by Vocaloid, arranged by me I DO NOT OWN THIS SONG, I just arranged it. | ["Accordion"] | ["instrumental", "fast tempo", "flute harmony", "wind instrument", "melodic", "cheerful", "happy", "warm", "woodwindninst", "double reed", "tenor bass range", "low pitch instrument", "high pitched flute", "rich", "beautiful melody", "energetic", "spirited", "low pitched bassoon accompaniment", "shakers"] | 7 | O25IKwo2HkE | 2392 | |
Блаженны - Знаменный распев с исоном. | 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;