musiccaps_details (view)
2 rows where musiccaps_aspects contains "jazzy" and musiccaps_aspects contains "shimmering hi hats" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- jazzy · 2 ✖
- shimmering hi hats · 2 ✖
- smooth bass 2
- easygoing 1
- electric guitar solo melody 1
- groovy piano chords 1
- hip hop 1
- live performance 1
- low quality 1
- percussive 1
- repetitive cowbell 1
- repetitive male vocal 1
- repetitive piano melody 1
- short brass stabs 1
- snappy rimshots 1
- soft kick 1
- soft snare 1
- unbalanced stereo 1
- warm 1
musiccaps_names (array) 5 ✖
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 | |
Rafael Lechowsky y la Banda de Jazz - Concierto Radio 3 | The Hip Hip songs live performance consists of repetitive male vocal singing over repetitive piano melody, smooth bass, shimmering hi hats and soft kick and snare hits. It sounds jazzy and warm. | 2008-04-19T22:10:21Z | MrSlowFlow23 | Rafael Lechowsky y la Banda de Jazz - Concierto Radio 3 | ["Jazz", "Music"] | ["hip hop", "live performance", "warm", "repetitive piano melody", "smooth bass", "repetitive male vocal", "shimmering hi hats", "soft snare", "soft kick", "jazzy"] | 4 | 3bg0iy-ypcw | 487 |
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;