musiccaps_details (view)
2 rows where musiccaps_aspects contains "fast tempo", musiccaps_aspects contains "inspiring" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 43 ✖
- emotional 2
- fast tempo · 2 ✖
- inspiring · 2 ✖
- keyboard harmony 2
- boomy 1
- boomy bass drops 1
- digital instrumentation 1
- distorted audio 1
- electric guitar melody 1
- electroni music 1
- electronic music 1
- engaging 1
- female power 1
- female vocalist 1
- feminism 1
- feminist 1
- girl power 1
- groovy bass lines 1
- inferior audio quality 1
- instrumental 1
- mellifluous 1
- muddled audio 1
- muffled 1
- passionate 1
- pleasant 1
- pleasant melody 1
- pop 1
- powerful 1
- rhythmic acoustic guitar 1
- simple 1
- simple melody 1
- soothing 1
- static 1
- steady drumming 1
- steady rhythm 1
- string instruments 1
- synthesiser articulation 1
- syth pop 1
- thumping beats 1
- turn table effects 1
- vocal backup 1
- vocalisation 1
- youthful 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Multifemales│I am woman {Collab w/ thegurlfrom12} | A female vocalist sings this enthusiastic song. The tempo is fast with keyboard harmony, infectious drumming, turntable effects, digital drumming, electronic music arrangements, boomy bass lines, vocal backup, vocalisation and synthesiser articulation. The song is passionate, emotional, powerful, impactful, engaging and inspiring with a punchy and youthful dance groove. This song is a powerful Synth Pop. | 2014-08-27T14:21:07Z | Divergent Nephilim | ► My first collab! :D And I'm really happy, she's an amazing editor and even more amazing person, thank you so so so much hunnie and hope we'll do more collabs :) And, of course, don't forget to subscribe to her, she's awesome: https://www.youtube.com/channel/UCqXPViM5obueUWuKar1OJCQ ► Fandoms: Teen Wolf Kick Ass 2 Vampire Diaries Vampire Academy The Originals TMI: City of Bones Divergent The Avengers The Hunger Games & Catching Fire Pretty Little Liars Lucy Harry Potter Brave silver linings playbook Anacondas X Men Miss Congeniality ► Song: I am woman, by Jordin Sparks THANKS FOR WATCHING! ♥ Like, comment and subscribe for more videos ☺ | ["Music", "Zing"] | ["female vocalist", "fast tempo", "distorted audio", "syth pop", "youthful", "inspiring", "powerful", "passionate", "emotional", "vocal backup", "vocalisation", "feminist", "feminism", "female power", "girl power", "turn table effects", "boomy bass drops", "keyboard harmony", "static", "electroni music", "boomy", "thumping beats", "inferior audio quality", "muddled audio", "muffled", "synthesiser articulation", "electronic music", "digital instrumentation"] | 7 | HFH9tcIK_PM | 1784 | |
NapoliTube | Maradona: palleggio con pallone, palla da tennis e pallina da ping pong! | RIP D10S! | This music is instrumental. The tempo is fast with rhythmic acoustic guitar, steady drumming, keyboard harmony, groovy bass line and electric guitar accompaniment. The music is mellow,nostalgic, emotional, simple, pleasant, charming and melodic pop. | 2013-11-19T20:26:34Z | NapoliTube | NAPOLITUBE | La Videoenciclopedia del Napoli: https://www.napolitube.eu SEGUI TUTTA LA STORIA DEL NAPOLI IN VIDEO SU https://www.napolitube.eu LA VIDEOENCICLOPEDIA DEL NAPOLI! | ["Music", "Ping"] | ["instrumental", "fast tempo", "rhythmic acoustic guitar", "pop", "steady drumming", "simple melody", "pleasant", "mellifluous", "inspiring", "emotional", "string instruments", "keyboard harmony", "steady drumming", "groovy bass lines", "electric guitar melody", "pleasant melody", "simple", "steady rhythm", "soothing", "engaging"] | 7 | aYoRcnmz6ZE | 3553 |
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;