musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "electric guitar chords" and musiccaps_aspects contains "emotional" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- electric guitar chords · 3 ✖
- emotional · 3 ✖
- passionate 2
- groovy bass 1
- heartfelt 1
- indie 1
- low quality 1
- melancholic female vocal 1
- mellow piano melody 1
- mono 1
- noisy 1
- organ keys chords 1
- passionate electric guitar lick 1
- passionate reverberant male vocal 1
- punchy snare 1
- r&b 1
- sad 1
- shimmering hi hats 1
- soft kick hits 1
- soulful 1
- synth lead melody 1
musiccaps_names (array) 9 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Lana del Rey - Kill Kill | The R&B song features a melancholic female vocal singing over mellow piano melody, electric guitar chords, synth lead melody, groovy bass, organ keys chords, shimmering hi hats, punchy snare and soft kick hits. It sounds emotional, passionate and heartfelt. | 2011-11-03T15:59:06Z | zentalau | Lana del Rey - Kill Kill ound up the stairs I'm in the shower Do you know I am going to leave you? Do you know I am going To leave you? I'm in love with a dying man I'm in love with a dying man All our love's flying in the sand I'm in love with a dying man I'm in love with a dying man I have done everything I can Tell me about Brian and his girl Do I know, Brian is going to meet you? Love you, I do Stay here, I won't As stars fade from your eyes I'm in love with a dying man I'm in love with a dying man All our love flying in the sand I'm in love with a dying man I'm in love with a dying man I have done everything I can Want to Make it fun Don't trust Anyone I'm in love with a dying man I'm in love with a dying man I have done everything I can I'm in love with a dying man I'm in love with a dying man I have done everything I can... | ["Electronic organ", "Music", "Independent music"] | ["r&b", "synth lead melody", "melancholic female vocal", "mellow piano melody", "electric guitar chords", "groovy bass", "organ keys chords", "shimmering hi hats", "punchy snare", "soft kick hits", "emotional", "passionate", "heartfelt"] | 4 | hHS5C0RKa8A | 4091 | |
Stuck in the Sound - Tender [Official Video] | The Indie song features a reverberant male vocal passionately singing over electric guitar chords. It sounds emotional, sad and passionate - like something you would listen to while feeling down. | 2012-10-08T10:32:53Z | STUCK IN THE SOUND | NEW VIDEO "Riots" https://youtu.be/AtVZifGCX7s NEW ALBUM https://idol.lnk.to/billy-believe PURSUIT on vinyl https://shop.uptonpark.biz/produit/stuck-in-the-sound-pursuit-lp/ WATCH OUR NEW VIDEOS: http://bit.ly/2DN5Kc3 FACEBOOK: http://www.facebook.com/stuckinthesound TWITTER: https://twitter.com/stuckinthesound INSTAGRAM https://www.instagram.com/stuckinthesoundofficial/ Directed By JALIL LESPERT © JALYAPROD / IT'S RECORDS / DISCOGRAPH (2012) Thanks to : Yaniss LESPERT- Yann SOITINO- Jalil LESPERT-Marcus MORIN -Mélanie MASSIAS-Olivier LE PEUC'H-Margaux BAIL-Brice MARTINAT- Philippe BAILLEUX- Marion DURAND- Matthieu THILL_ Elin KIRSCHFINK_ Etienne SALDES- Marie CELETTE-- Philippe ARQUÉ- Carrie Arbogast -Mélanie VAGENHEIM-- Tina - Mareva BOURJAC- Stephane ALBERT DESFONS - Théo VanStaevel - Julien Favier- Simon Petillon -- Felder MUHONGO DA SILVA Cast : SOPHIE HELARD, JOSE REIS FONTAO, DIVA NOVITA, LEO MARINIER, DEBORAH DURAND, LITTLE MIKE, PHILIPPE PASKINI, ARNO BORDAS, FRANCOIS ERNIE, EMMANUEL BARRICHASSE, ROMAIN DELLA VALLE, HENRI JAMET, DAVID FONTAO, JULIE HOUTTEMANE, JENNY, JEAN MARIE NARAINEN, YAKHOUBA KANOUTE, YANN SOITINO, JONATHAN PERU, CANELLA, SERGIO, I AM UN CHIEN,... Thanks to CARBON KEVLAR Thanks to the girls from the CRAZY HORSE ! http://www.stuckinthesound.com #StuckInTheSound #BillyBelieve #IndieRock | ["Music", "Tender music"] | ["electric guitar chords", "passionate reverberant male vocal", "emotional", "passionate", "sad", "indie"] | 4 | AkbCw7oVkw0 | 1163 | |
Shinedown - Sound of Madness Guitar Cover | The low quality recording features a passionate electric guitar lick played over electric guitar chords. It sounds emotional, soulful and the recording is noisy and in mono. | 2010-11-12T17:07:08Z | UnitedWeTabDailyVid | Sound of Madness cover by Matt Hogan. | ["Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument", "Inside, small room"] | ["low quality", "noisy", "mono", "passionate electric guitar lick", "electric guitar chords", "emotional", "soulful"] | 4 | sGVzzQLcT0U | 4936 |
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;