musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "groovy bass" and musiccaps_aspects contains "shimmering open hats" sorted by youtube_published
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 25 ✖
- groovy bass · 2 ✖
- low quality 2
- shimmering open hats · 2 ✖
- 4 on the floor kick 1
- crushed 1
- distorted 1
- electro 1
- energetic 1
- exciting 1
- flat male vocal 1
- funky guitar chords 1
- groovy piano melody 1
- harmonizing male vocals 1
- live performance 1
- melodic background male vocals 1
- mono 1
- northern soul 1
- nostalgic 1
- punchy "4 on the floor" kick 1
- repetitive electric guitar melody 1
- repetitive synth keys melody 1
- sentimental 1
- shimmering hi hats 1
- vintage 1
- warm 1
musiccaps_names (array) 6 ✖
- Music 2
- Burst, pop 1
- Exciting music 1
- Funk 1
- Ska 1
- Soul music 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Benjamin Diamond - Music Sounds Better With You (Part One) @ CABARET ALEATOIRE | The low quality recording features a live performance that contains harmonizing male vocals singing over repetitive synth keys and electric guitar melody, followed by groovy bass, shimmering hats and punchy "4 on the floor" kick pattern. The recording is noisy, distorted and crushed, but it sounds energetic and exciting. | 2009-02-21T12:37:05Z | mikanou2410 | Stardust - Music Sounds Better With You WWW.SPLASHMYMILK.COM | ["Music", "Burst, pop", "Exciting music"] | ["harmonizing male vocals", "low quality", "electro", "energetic", "exciting", "punchy \"4 on the floor\" kick", "distorted", "repetitive electric guitar melody", "repetitive synth keys melody", "groovy bass", "shimmering open hats", "shimmering hi hats", "live performance", "crushed"] | 4 | kbAMGp-TKJo | 4333 | |
Dooley Silverspoon - Game Players : Northern Soul | The low quality recording features a northern soul song that consists of flat male vocals, alongside melodic male background vocals, singing over funky guitar chords, groovy piano chords, groovy bass, "4 on the floor" kick pattern and shimmering open hats. It is noisy and in mono and therefore vintage, but it also sounds warm, nostalgic and sentimental. | 2013-05-03T20:08:03Z | Mike Patterson | Dooley Silverspoon - Game Players : Northern Soul, with some Northern Soul Video Clips | ["Funk", "Music", "Ska", "Soul music"] | ["low quality", "vintage", "northern soul", "groovy bass", "groovy piano melody", "funky guitar chords", "shimmering open hats", "4 on the floor kick", "flat male vocal", "melodic background male vocals", "mono", "warm", "nostalgic", "sentimental"] | 4 | EUNTykrvpok | 1563 |
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;