musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "melancholic" and musiccaps_aspects contains "rock"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- melancholic · 3 ✖
- rock · 3 ✖
- acoustic drums 1
- acoustic guitar 1
- americana 1
- bouncy snare 1
- country 1
- e-bass 1
- e-guitars 1
- emotional 1
- gravelly voice 1
- groovy 1
- groovy bass guitar 1
- higher register 1
- low quality 1
- male vocal 1
- male voice singing 1
- medium to uptempo 1
- melancholic male vocal 1
- messy 1
- muddy 1
- noisy 1
- percussion 1
- punchy kick 1
- sentimental 1
- steady tempo 1
- wide electric guitar melody 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Johnny Cash Your Own Personal Jesus Music Video | This is a country/Americana music piece. There is a male vocalist with a gravelly voice singing in the lead. An acoustic guitar is playing a simple tune. There is a faint percussive element that can be heard in the background that resembles pinched harmonics coming from a guitar. The atmosphere is melancholic. This piece could be used in the soundtrack of a drama movie or a TV show during a scene of introspection where a character is experiencing dark thoughts. | 2008-01-30T02:15:17Z | bayekane | Johnny Cash Your Own Personal Jesus Music Video | ["Country", "Music", "Bluegrass"] | ["country", "americana", "rock", "male vocal", "gravelly voice", "acoustic guitar", "percussion", "melancholic", "sentimental", "steady tempo"] | 9 | 6OcoDIrbMtY | 750 | |
Peter Doherty - Nothing Comes To Nothing (DEMO Track) | This song contains acoustic drums playing kind of a slow drum&bass rhythm along with a bass playing the rootnote of a e-guitar strumming along. Another e-guitar is strumming along, panned to the right side of the speakers. A male voice is singing in a higher key with delay in his voice. This song may be playing with headphones on a rainy colder day. | 2012-12-10T19:03:53Z | enenes | "Nothing Comes To Nothing" Won't you come, come back to earth Cause they're all concerned You know how they're worried for you. And all their words, they jar my nerves I know Each curse by each new kiss is run through Nothing comes to nothing without my baby, Nothing ever comes to nothing without my baby At an Amwellian Do a tongue soaked in booze says "He's filthy and much older than you" Oh the sick sick muse, the sickly muse Pulls out her sickle so shiny, cuts the tongue in two While the music sways and forays and searches and says: "Give me the young man in blue" While the music sways and forays and searches and says: "Break your heart in two" Nothing comes to nothing without my baby, Nothing ever comes to nothing with my baby, All I ever do Where's the happy prince? Where? There's his smiling bride. He's right beside you Flo... Nothing ever comes to nothing without my baby, Nothing's ever good for nothing with that lady Nothing ever comes to nothing without my baby, Nothing ever comes to nothing without my baby | ["Singing", "Music", "Ska"] | ["rock", "e-bass", "e-guitars", "acoustic drums", "male voice singing", "higher register", "melancholic", "medium to uptempo"] | 6 | FY8bZRm_QiE | 1647 | |
Smashing Pumpkins - Whir (Whirl) | The low quality recording features a rock song that consists of melancholic male vocal singing over a wide electric guitar melody, bouncy snare, groovy bass guitar and punchy kick. The recording is noisy, muddy and messy, since the frequencies are clashing with each other - drums cymbals are inaudible. Regardless, it sounds groovy, emotional and melancholic thanks to that vocal. | 2012-04-26T21:13:42Z | xthreenightsx | Demo '92 | ["Music", "Independent music", "Grunge"] | ["low quality", "rock", "wide electric guitar melody", "melancholic male vocal", "bouncy snare", "groovy bass guitar", "noisy", "muddy", "messy", "punchy kick", "melancholic", "emotional", "groovy"] | 4 | aO0QzRPiEC4 | 3533 |
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;