musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "easygoing", musiccaps_aspects contains "low quality" and musiccaps_aspects contains "smooth bass"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 29 ✖
- easygoing · 4 ✖
- low quality · 4 ✖
- smooth bass · 4 ✖
- electric guitar melody 2
- snappy rimshots 2
- chill 1
- cool 1
- electric guitar solo melody 1
- groovy 1
- groovy piano chords 1
- jazzy 1
- mellow 1
- mellow piano chords 1
- mono 1
- noisy 1
- passionate 1
- passionate male vocal 1
- percussive 1
- repetitive cowbell 1
- rock 1
- shimmering hi hats 1
- shimmering shakers 1
- short brass stabs 1
- soft 1
- soft male vocal 1
- sustained strings chords 1
- synth pad chords 1
- unbalanced stereo 1
- wide electric guitar arpeggiated melody 1
musiccaps_names (array) 9 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Crash Sampler | The low quality recording features a jazzy song that consists of shimmering hi hats, repetitive cowbell, snappy rimshots and smooth bass in the right channel, short brass stabs and groovy piano chords in the left channel of the stereo image and electric guitar solo melody in the middle. The stereo image of the song is a bit unbalanced, due to the spreadness of low frequency sounds throughout the stereo image. It sounds easygoing and percussive. | 2006-05-18T07:30:39Z | Ninja Pat | group of friends crashing!!! | ["Swing music", "Music", "Musical instrument", "Music of Latin America"] | ["low quality", "jazzy", "unbalanced stereo", "shimmering hi hats", "repetitive cowbell", "short brass stabs", "electric guitar solo melody", "groovy piano chords", "smooth bass", "easygoing", "percussive", "snappy rimshots"] | 4 | JRfU_hF1wdM | 2005 | |
دورة المياه في الطبيعة | The low quality recording features a smooth bass, electric guitar melody, synth pad chords and mellow piano chords playing. It sounds soft, mellow and easygoing. | 2013-01-13T18:52:46Z | Malak Msarwa | ["Music", "Sad music"] | ["low quality", "smooth bass", "electric guitar melody", "synth pad chords", "mellow piano chords", "soft", "mellow", "easygoing"] | 4 | Vwekk3EOa-U | 3043 | ||
Nothing In This World - The Kinks | The low quality recording features a rock song that consists of an electric guitar melody, smooth bass, shimmering shakers, snappy rimshots and soft male vocals singing over it. The recording is really noisy and in mono. It sounds cool, groovy and easygoing. | 2008-10-25T20:42:37Z | weeniebobeenie | Nothin in this world can stop me worryin bout that girl | ["Bass guitar", "Guitar", "Music", "Plucked string instrument"] | ["rock", "low quality", "electric guitar melody", "smooth bass", "shimmering shakers", "snappy rimshots", "soft male vocal", "noisy", "mono", "cool", "easygoing", "groovy"] | 4 | hOSzGYKaJGE | 4100 | |
Miles Away by Colin Blunstone...with Lyrics | The low quality recording features a passionate male vocal singing over sustained strings chords, wide electric guitar arpeggiated melody and smooth bass. It sounds easygoing, passionate and chill. | 2011-02-02T00:17:49Z | Rommel 1020 | Thanks for watching... | ["Music", "Tender music"] | ["low quality", "sustained strings chords", "wide electric guitar arpeggiated melody", "smooth bass", "passionate male vocal", "easygoing", "passionate", "chill"] | 4 | zir3uL14ijM | 5504 |
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;