musiccaps_details (view)
3 rows where musiccaps_aspects contains "strong bass line" and musiccaps_aspects contains "suspense"
This data as json, CSV (advanced)
musiccaps_aspects (array) 53 ✖
- strong bass line · 3 ✖
- suspense · 3 ✖
- instrumental music 2
- slow tempo 2
- averts sound quality 1
- bad audio quality 1
- competition 1
- eerie harmonies 1
- electric guitar 1
- electric guitar demo 1
- emotional 1
- emotional passionate 1
- fashion show tune 1
- fear 1
- female singer 1
- groovy music 1
- guitar accompaniment 1
- guitar amplifier 1
- guitar lead 1
- guitar solo artist 1
- hissing and buzzing distortions 1
- hissing tones 1
- home music video 1
- inspiring 1
- keyboard accompaniment 1
- life’s lessons 1
- medium tempo 1
- modern pop covers 1
- movie soundtrack 1
- music demo 1
- mysterious 1
- no other instrumentation 1
- odern pop hits 1
- passionate 1
- percussive hits 1
- poor audio quality 1
- pop song 1
- positive 1
- reverb tones 1
- secret agent man 1
- show soundtrack 1
- slamming door percussion 1
- soloist 1
- song cover 1
- song fade 1
- sonic effects 1
- spirited 1
- story telling 1
- stress 1
- synth string pads 1
- tension 1
- various percussion hits 1
- vocal echoes 1
musiccaps_names (array) 9 ✖
youtube_published (date) 3 ✖
- 2008-07-09 1
- 2011-08-12 1
- 2013-11-14 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
LORDE | Everybody Wants to Rule the World (Lyrics) | A female singer sings this iconic pop cover. The song is slow tempo with a piano accompaniment, strong drum hit and low pitched keyboard harmony. The song is tense and mysterious. The song is a modern pop cover and has poor audio quality with hissing and buzzing tones. | 2013-11-14T05:03:56Z | hrbrocks10 | Song: Everybody Wants to Rule the World : Lorde - Tears For Fears Cover No copyright infringement intended! | ["Music", "Scary music"] | ["bad audio quality", "hissing tones", "female singer", "hissing and buzzing distortions", "emotional", "spirited", "passionate", "inspiring", "life’s lessons", "vocal echoes", "slamming door percussion", "pop song", "song cover", "suspense", "slow tempo", "odern pop hits", "movie soundtrack", "strong bass line", "story telling", "modern pop covers", "keyboard accompaniment"] | 1 | cY3g6N5Sokk | 3716 | |
Randall Kirk Hammett Signature Amp | The song is an instrumental. The tempo is slow with an electric guitar playing lead and a strong bass line in a rhythmic manner. The song is strong and mysterious like a secret agent movie theme. The song is recorded at home and has an average sound quality. The song is a music demo. | 2008-07-09T15:06:58Z | Guitar World | Guitar World's gear editor Paul Riario demonstrates the features of the Randall Kirk Hammett Signature Head and Cabinet. For more gear reviews, lessons, interviews and more check out guitarworld.com! (more) | ["Bass guitar", "Reverberation", "Silence", "Effects unit", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["instrumental music", "slow tempo", "electric guitar", "music demo", "song fade", "reverb tones", "guitar lead", "guitar accompaniment", "strong bass line", "electric guitar demo", "guitar amplifier", "suspense", "no other instrumentation", "soloist", "guitar solo artist", "home music video", "averts sound quality", "emotional passionate", "positive", "mysterious", "secret agent man"] | 1 | kKihNQ44dDQ | 4309 | |
Vivienne Mackinder demonstrates the latest techniques to create short style haircuts | The song is an instrumental. The tempo is medium with a keyboard accompaniment, sonic effects, various percussion hits, strong bass line and synth pad section. The song is eerie and full of tension. The song is tv show theme and has poor audio quality. | 2011-08-12T02:03:07Z | hikariscissors | Vivienne Mackinder is one of the most highly respected international leaders and innovators in the hairdressing profession today. In her work as Artistic Director for industry 'Grand Masters' Vidal Sassoon and Trevor Sorbie, Vivienne developed an expertise for precision cutting and an eye for original hair design, from the classic and the commercial, to the avant-garde. Based in New York City, she grew up in London and subsequently opted to 'spread her wings' to the United States. She has been honoured with numerous awards, including the prestigious IBS 'Editors' Choice Awards (three times). As well as, the much coveted North American Hairstyling Awards (NAHA) (five times), including "Masters." Honouree - North American Hair Styling Awards "Life Time Achievement" 2009. For more information on Vivienne Mackinder, please visit her website www.hairdesignertv.com. | ["Music", "Scary music"] | ["instrumental music", "suspense", "tension", "fashion show tune", "show soundtrack", "percussive hits", "strong bass line", "synth string pads", "eerie harmonies", "fear", "stress", "medium tempo", "sonic effects", "various percussion hits", "groovy music", "poor audio quality", "competition", "medium tempo"] | 1 | oC0e8GXYy_4 | 4610 |
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;