musiccaps_details (view)
3 rows where musiccaps_aspects contains "choral harmony" and musiccaps_aspects contains "keyboard accompaniment"
This data as json, CSV (advanced)
musiccaps_aspects (array) 52 ✖
- choral harmony · 3 ✖
- keyboard accompaniment · 3 ✖
- fast tempo 2
- backup singers 1
- bad audio quality 1
- black gospel influences 1
- charming 1
- composer 1
- concert hall 1
- conductor 1
- crooners 1
- emotional 1
- energetic 1
- ethereal music 1
- ethereal tones 1
- exciting 1
- female singers 1
- female voice 1
- groovy bass line 1
- instrumental music 1
- jazz music influences 1
- love song 1
- magical energy 1
- magical journey 1
- mellifluous 1
- melodic 1
- movie soundtrack 1
- music 1
- music you 1
- need your loving 1
- opera hall 1
- passionate 1
- percussive horn section 1
- philharmonic orchestra 1
- pleasant 1
- pulsating energy 1
- retro pop influences 1
- rhythm section 1
- simple 1
- slow rap chants 1
- sonic effects 1
- soothing 1
- soul singers 1
- sprightly acoustic guitar 1
- string section harmony 1
- stro telling 1
- sweet 1
- tranquil 1
- violins 1
- vocal harmony 1
- vocalisation 1
- western classical music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
I Seek Sensei Song - SGI Youth March16 toward 2030.wmv | This song is an instrumental. The tempo is fast with an enthusiastic acoustic guitar melody, keyboard accompaniment and a mellifluous female vocalisation with choral harmony. The music is rhythmic, youthful, simple,beautiful, charming, soothing, pleasant, charming, and tranquil. | 2012-03-07T17:18:10Z | OricoApps | Celebrating Youth Division and future growth toward Soka Gakkai's 100thanniversary. ChantBuddy creates "I seek Sensei" clip for everybody to sing along in group activity. Enjoy http://www.chantbuddy.com/ | ["Music", "Happy music"] | ["female voice", "fast tempo", "choral harmony", "charming", "pleasant", "simple", "tranquil", "soothing", "keyboard accompaniment", "sweet", "mellifluous", "melodic", "vocalisation", "sprightly acoustic guitar"] | 7 | 3VEMHWnewuc | 473 | |
SHOUT - The Fabsisters [Cover Of - The Isley Brothers/Lulu] | A female singer sings this soulful melody with backup singers in vocal harmony. The song is fast tempo with a quick drumming rhythm, percussive bass line, guitar strumming rhythm and keyboard accompaniment. The song has black gospel roots. | 2012-02-22T18:56:06Z | The Fabsisters | Please watch: "The Drinks are all on him-Folake (The Fabsisters)" https://www.youtube.com/watch?v=pTs3mNrht_4 -~-~~-~~~-~~-~- Please watch: "The Fabsisters - Can't Be With You Tonight" ➨ https://www.youtube.com/watch?v=lG1ce8BrEQ4 | ["Music", "Whoop", "Yell"] | ["female singers", "vocal harmony", "backup singers", "passionate", "music you", "need your loving", "soul singers", "percussive horn section", "keyboard accompaniment", "crooners", "stro telling", "love song", "emotional", "choral harmony", "black gospel influences", "emotional", "exciting", "energetic", "jazz music influences", "retro pop influences", "music", "fast tempo", "groovy bass line"] | 1 | qpt3umHYfmY | 4824 | |
Harry Potter And The Prisoner Of Askaban - Expecto Patronum | The song is an instrumental. The tempo is slow with a choir harmonising and creating ethereal chants, string section and a philharmonic orchestra harmony backing. The song is ethereal and magical. The song has poor audio quality. | 2012-01-03T20:03:03Z | GillyWeed | Harry Cunjur's a patronus to save him and his god father sirus black, I DO NOT OWN ANY OF THS CONTENT IT ALL BELONGS TO WARNER BROTHERS ECT ,, THANKS FOR WATCHING (Y) | ["Music", "Scary music"] | ["instrumental music", "movie soundtrack", "ethereal music", "philharmonic orchestra", "slow rap chants", "choral harmony", "magical energy", "magical journey", "violins", "string section harmony", "rhythm section", "ethereal tones", "pulsating energy", "bad audio quality", "concert hall", "opera hall", "conductor", "composer", "western classical music", "sonic effects", "keyboard accompaniment"] | 1 | xlxxWFENWr8 | 5351 |
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;