musiccaps_details (view)
1 row where musiccaps_aspects contains "emotional", musiccaps_aspects contains "indie", musiccaps_aspects contains "passionate reverberant male vocal" and musiccaps_aspects contains "sad"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 |
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;