musiccaps_details (view)
2 rows where musiccaps_aspects contains "fast tempo", musiccaps_aspects contains "female vocalist" and musiccaps_aspects contains "passionate"
This data as json, CSV (advanced)
musiccaps_aspects (array) 46 ✖
- fast tempo · 2 ✖
- female vocalist · 2 ✖
- passionate · 2 ✖
- boomy 1
- boomy bass drops 1
- buoyant 1
- dance groove 1
- digital drums 1
- digital instrumentation 1
- distorted audio 1
- electroni music 1
- electronic music 1
- emotional 1
- energetic 1
- enthusiastic 1
- female power 1
- feminism 1
- feminist 1
- girl power 1
- groovy bass lines 1
- hard rock 1
- inferior audio quality 1
- inferior quality audio 1
- inspiring 1
- intense 1
- intense electric guitar feed back 1
- keyboard harmony 1
- loud singing 1
- muddled audio 1
- muffled 1
- muffled audio 1
- pop rock 1
- powerful 1
- rock 1
- spirited 1
- static 1
- synth arrangements 1
- synthesiser articulation 1
- syth pop 1
- thumping beats 1
- turn table effects 1
- vibrant 1
- vigorous drumming 1
- vocal backup 1
- vocalisation 1
- youthful 1
musiccaps_names (array) 3 ✖
- Music 2
- Independent music 1
- Zing 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 | |
ITV Chart Show Indie Chart July 1995 | A female vocalist sings this energetic song. The tempo is fast with furiously energetic drumming, intense electric guitar, groovy bass lines, keyboard harmony, vocal backup and synthesiser arrangements. The song is passionate, spirited,youthful, buoyant, punchy, energetic and animated. The audio is muddy and incoherent. This song is Pop Rock. | 2007-09-09T16:56:00Z | David Bryant | Features: Buffalo Tom - Summer Song Menswear - Daydreamer | ["Music", "Independent music"] | ["female vocalist", "loud singing", "fast tempo", "pop rock", "hard rock", "dance groove", "buoyant", "spirited", "passionate", "vibrant", "enthusiastic", "energetic", "intense", "vigorous drumming", "intense electric guitar feed back", "groovy bass lines", "synth arrangements", "digital drums", "muffled audio", "inferior quality audio", "rock"] | 7 | J48F0e0guSQ | 1966 |
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;