musiccaps_details (view)
5 rows where search matches "guitar", musiccaps_aspects contains "passionate", musiccaps_aspects contains "pop" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 46 ✖
- passionate · 5 ✖
- pop · 5 ✖
- low quality 4
- emotional 3
- addictive 2
- groovy bass 2
- passionate female vocal 2
- punchy kick 2
- punchy snare 2
- acoustic guitar melody 1
- acoustic rhythm guitar chords 1
- arpeggiated electric guitar solo melody 1
- background music 1
- cinematic 1
- claps 1
- compilation 1
- cover 1
- echoing female vocal 1
- echoing synth bell melody 1
- electric guitar chords 1
- electric guitar melody 1
- fade out 1
- flat female vocal 1
- groovy 1
- intimate 1
- mono 1
- noisy 1
- pulsating synth melody 1
- reverberant passionate female vocal 1
- shimmering hi hats 1
- shimmering open hat 1
- shimmering shakers 1
- simple hi hats 1
- smooth bass 1
- smooth bass guitar 1
- soft kick 1
- straight piano melody 1
- sustained strings melody 1
- sustained strings progression 1
- synth keys melody 1
- uplifting 1
- wide brass melody 1
- wide electric guitar melodies 1
- wide harmonizing female vocals 1
- wide harmonizing male vocals 1
- wide shimmering hi hats 1
musiccaps_names (array) 8 ✖
- Music 4
- Singing 2
- Country 1
- Funk 1
- Song 1
- Tender music 1
- Vocal 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 |
---|---|---|---|---|---|---|---|---|---|---|
Cry Baby Soundtrack - Teardrops Are Falling | The low quality recording features a pop song that contains a passionate female vocal, alongside wide harmonizing male vocals, singing over wide brass melody, electric guitar chords, straight piano melody, punchy snare and smooth bass guitar. It sounds groovy, addictive and passionate. | 2009-09-11T13:34:33Z | MortRaineyFan | Cry Baby Soundtrack - Teardrops Are Falling. :) | ["Music", "Vocal music"] | ["low quality", "pop", "wide harmonizing male vocals", "wide shimmering hi hats", "wide brass melody", "electric guitar chords", "straight piano melody", "reverberant passionate female vocal", "punchy snare", "smooth bass guitar", "groovy", "addictive", "passionate"] | 4 | 46WpyRUqwXU | 539 | |
Lee Min Ho - Faith Korean Drama 2012 | The low quality recording features a pop song that consists of an electric guitar melody, shimmering hi hats, groovy bass, sustained strings melody, pulsating synth melody, punchy kick and echoing synth bell melody. It sounds emotional, passionate and cinematic, as it also sounds like something that would go well as a background music for movies. | 2012-11-02T12:16:52Z | MsDallia91 | Faith also called the great doctor is a Korean historical drama made in 2012 with Lee Min Ho and Kim Hee Sun. | ["Music", "Tender music"] | ["pop", "low quality", "electric guitar melody", "shimmering hi hats", "groovy bass", "sustained strings melody", "pulsating synth melody", "punchy kick", "echoing synth bell melody", "emotional", "passionate", "cinematic", "background music"] | 4 | 8FZb_R2UANY | 906 | |
Nasty Girl by Destiny's Child | The Pop song features a passionate female vocal singing over groovy bass, wide electric guitar melodies and shimmering shakers, as the overall audio is slowly fading out. It sounds addictive, passionate and intimate. | 2007-04-15T07:50:17Z | Bubblez1636 | Destiny's Child's song, Nasty Girl, with a compilation of video footage they made AFTERWARDS. Funny | ["Singing", "Funk"] | ["pop", "passionate female vocal", "groovy bass", "wide electric guitar melodies", "shimmering shakers", "fade out", "addictive", "passionate", "intimate"] | 4 | C-7ubPOCeJk | 1314 | |
Demi lovato head voice and whistle register | The low quality recording features a compilation of pop songs. The first song features an echoing female vocal sining, alongside wide harmonizing female vocals, over arpeggiated solo electric guitar melody, sustained strings progression, smooth bass, soft kick hits, punchy snare, simple hi hats and shimmering open hat. At the very end of the loop, there is a short snippet of the second song that consists of flat female vocals singing over claps, synth keys melody and punchy kick. It sounds emotional and passionate, even though the mix is bad. | 2014-03-08T13:11:42Z | Richard Cross | Demi lovato head voice whistle register and exclamations. The last one is an F7 not an F8. Follow me on Twitter @Richardtcross | ["Singing", "Music", "Song", "Zing"] | ["low quality", "pop", "echoing female vocal", "punchy snare", "shimmering open hat", "simple hi hats", "wide harmonizing female vocals", "smooth bass", "arpeggiated electric guitar solo melody", "sustained strings progression", "soft kick", "compilation", "claps", "punchy kick", "flat female vocal", "synth keys melody", "emotional", "passionate", "uplifting"] | 4 | GHQlBD-6rkA | 1707 | |
Set Fire To The Rain - Adele (Cover) | The low quality recording features a cover of a pop song sung by passionate female vocalists over acoustic guitar melody and acoustic rhythm guitar chords. It sounds emotional, passionate and the recording is noisy and in mono. | 2011-12-15T21:25:02Z | 30secondstomars44 | I know it's definitely not perfect, but we did so many versions and we just don't wanna do that song anymore! :D Enjoy :) Lyrics: I let it fall, my heart And as it fell, you rose to claim it It was dark and I was over Until you kissed my lips and you saved me My hands, they were strong, but my knees were far too weak To stand in your arms without falling to your feet But there's a side to you that I never knew, never knew All the things you'd say, they were never true, never true And the games you'd play, you would always win, always win But I set fire to the rain Watched it pour as I touched your face Well, it burned while I cried 'Cause I heard it screaming out your name, your name When laying with you I could stay there Close my eyes, feel you here forever You and me together, nothing is better 'Cause there's a side to you that I never knew, never knew All the things you'd say, they were never true, never true And the games you's play, you would always win, always win But I set fire to the rain Watched it pour as I touched your face Well, it burned while I cried 'Cause I heard it screaming out your name, your name I set fire to the rain And I threw us into the flames When we fell, something died 'Cause I knew that that was the last time, the last time Sometimes I wake up by the door That heart you caught must be waiting for you Even now when we're already over I can't help myself from looking for you I set fire to the rain Watched it pour as I touch your face Well, it burned while I cried 'Cause I heard it screaming out your name, your name I set fire to the rain And I threw us into the flames When we fell, something died 'Cause I knew that that was the last time, the last time, oh Oh, no Let it burn, oh Let it burn Let it burn | ["Country", "Music"] | ["low quality", "pop", "mono", "noisy", "cover", "acoustic guitar melody", "acoustic rhythm guitar chords", "passionate female vocal", "emotional", "passionate"] | 4 | I5mESbabhZY | 1874 |
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;