musiccaps_details (view)
3 rows where musiccaps_aspects contains "organ keys chords" and musiccaps_aspects contains "passionate" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- organ keys chords · 3 ✖
- passionate · 3 ✖
- emotional 2
- jazz 2
- punchy snare 2
- cover 1
- electric guitar chords 1
- energetic cymbals 1
- groovy bass 1
- groovy double bass 1
- groovy piano chords 1
- heartfelt 1
- live performance 1
- low quality 1
- manic tom roll 1
- melancholic female vocal 1
- mellow piano chords 1
- mellow piano melody 1
- passionate saxophone melody 1
- punchy kick 1
- r&b 1
- reverberant 1
- saxophone solo melody 1
- shimmering hi hats 1
- smooth bass 1
- snappy rimshots 1
- soft hi hats 1
- soft kick 1
- soft kick hits 1
- synth lead melody 1
- upbeat 1
musiccaps_names (array) 12 ✖
- Bass drum 1
- Brass instrument 1
- Cowbell 1
- Drum 1
- Drum kit 1
- Electronic organ 1
- Independent music 1
- Music 1
- Percussion 1
- Rimshot 1
- Saxophone 1
- Snare drum 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Erisa Nicole - How to Play Safety In His Arms - Gospel Sax Cover | The low quality recording features a jazz song cover that consists of a passionate saxophone melody played over soft hi hats and kick hits, snappy rimshots, smooth bass, organ keys chords and mellow piano chords. It sounds emotional, passionate and reverberant - as it was probably recorded in a medium size room. | 2011-06-20T01:58:54Z | Erisa Nicole | Please watch my new video (link below) Please watch my new video (link below) https://youtu.be/ggVo_CdFmqY Erisa Nicole Safety In His Arms - Vicki Winans | ["Brass instrument", "Saxophone"] | ["snappy rimshots", "soft hi hats", "soft kick", "cover", "smooth bass", "organ keys chords", "mellow piano chords", "passionate saxophone melody", "passionate", "emotional", "jazz", "low quality", "reverberant"] | 4 | 0ZNFJz-eZTU | 180 | |
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 | |
Shirazette Tinnin - Inner Frustration | The low quality recording features a jazz live performance that consists of saxophone solo melody played over energetic cymbals, manic tom roll, punchy snare and kick hits, organ keys chords, groovy double bass and groovy piano chords. It sounds passionate and upbeat. | 2012-08-16T17:50:49Z | Latin Percussion | Shirazette Tinnin visits the LP studio to perform "Inner Frustration." Drums: Shirazette Tinnin Piano : Willerm Delisfort Piano: Rachel Eckroft Guitar: Seth Johnson Bass: Tom DiCarlo Saxophone: Camille Thurman LP LP204A Black Beauty Cowbell LP204A LP Americana Series Peruvian Cajon LP1439 | ["Cowbell", "Drum", "Drum kit", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["live performance", "jazz", "saxophone solo melody", "manic tom roll", "energetic cymbals", "punchy snare", "organ keys chords", "groovy double bass", "punchy kick", "groovy piano chords", "passionate", "upbeat"] | 4 | t1ULMDpL35I | 4998 |
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;