musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "funky electric guitar melody", musiccaps_aspects contains "low quality" and musiccaps_aspects contains "passionate male vocal"
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- funky electric guitar melody · 2 ✖
- groovy bass 2
- low quality · 2 ✖
- passionate male vocal · 2 ✖
- punchy kick 2
- punchy snare 2
- addictive 1
- energetic 1
- funky 1
- groovy 1
- groovy synth keys 1
- latin urban 1
- noisy 1
- rock playback 1
- shimmering cymbals 1
- shimmering hi hats 1
- synth keys melody 1
- synth lead melody 1
- synth pad chords 1
- wide harmonizing vocals 1
musiccaps_names (array) 8 ✖
- Electric piano 1
- Electronic organ 1
- Folk music 1
- Keyboard (musical) 1
- Music 1
- Organ 1
- Piano 1
- Rhythm and blues 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Upgrade Music vs. Jeon - Ataniro & Ritmo - Amor Cruel | The low quality recording features a latin urban song that consists of a passionate male vocal, alongside wide harmonizing vocals, singing over punchy kick and snare hits, shimmering cymbals, funky electric guitar melody, synth pad chords, groovy bass and synth keys melody. It sounds energetic and addictive. | 2014-05-19T23:20:11Z | Javier' Abreu | Upgrade Music Aruba - Amor Cruel | ["Folk music", "Music", "Rhythm and blues"] | ["low quality", "latin urban", "passionate male vocal", "punchy kick", "punchy snare", "shimmering cymbals", "funky electric guitar melody", "synth pad chords", "groovy bass", "wide harmonizing vocals", "synth keys melody", "energetic", "addictive"] | 4 | 8OsmFmhNjoA | 920 | |
Love me two times 2 (Doors) played on Gibson and piano bass | The low quality recording features a synth lead melody and groovy synth piano playing over rock songs played on playback. The song consists of a punchy kick and snare hits, shimmering hi hats, funky electric guitar melody, groovy bass and passionate male vocals singing over it in the beginning. It sounds funky and groovy, while the recording is a bit noisy. | 2007-04-13T18:21:38Z | serenities | The Doors; Love me two times, played on a Gibson G101 (1967) and a Fender Rhodes Piano Bass (1966). Original background song by The Doors. | ["Organ", "Electric piano", "Electronic organ", "Keyboard (musical)", "Piano"] | ["low quality", "noisy", "rock playback", "punchy snare", "shimmering hi hats", "funky electric guitar melody", "groovy bass", "passionate male vocal", "punchy kick", "groovy synth keys", "synth lead melody", "groovy", "funky"] | 4 | Simd4JoehW8 | 2782 |
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;