musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "low quality" and musiccaps_aspects contains "shimmering open hats" sorted by musiccaps_author
This data as json, CSV (advanced)
musiccaps_aspects (array) 40 ✖
- low quality · 4 ✖
- shimmering open hats · 4 ✖
- live performance 3
- flat male vocal 2
- groovy 2
- groovy bass 2
- harmonizing male vocals 2
- punchy kick 2
- punchy snare 2
- rock 2
- shimmering hi hats 2
- 4 on the floor kick 1
- arpeggiated electric guitar melody 1
- boomy bass guitar 1
- crushed 1
- distorted 1
- easygoing 1
- electro 1
- emotional 1
- energetic 1
- exciting 1
- funky 1
- funky guitar chords 1
- groovy keys chords 1
- groovy piano melody 1
- melodic background male vocals 1
- messy 1
- mono 1
- noisy 1
- northern soul 1
- nostalgic 1
- passionate male vocal 1
- punchy "4 on the floor" kick 1
- repetitive electric guitar melody 1
- repetitive synth keys melody 1
- sentimental 1
- smooth bass guitar 1
- vintage 1
- warm 1
- wide electric guitar melody 1
musiccaps_names (array) 10 ✖
- Music 4
- Rock and roll 2
- Ska 2
- Bass guitar 1
- Burst, pop 1
- Country 1
- Exciting music 1
- Funk 1
- Punk rock 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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
Shake Rattle n' Roll demo video 1 | The low quality recording features a live performance of a rock song that consists of flat male vocal singing over a wide electric guitar melody, groovy keys chords, located in the right channel of the stereo image, smooth bass guitar, shimmering open hats and hi hats and punchy kick and snare hits. It sounds groovy, funky and easygoing - like something you could lightly dance to. | 2009-09-30T03:58:48Z | Bill Crane | Demo video recorded 9/28/09. | ["Country", "Music", "Ska", "Rock and roll"] | ["low quality", "rock", "live performance", "flat male vocal", "wide electric guitar melody", "groovy keys chords", "smooth bass guitar", "shimmering hi hats", "punchy snare", "punchy kick", "shimmering open hats", "groovy", "funky", "easygoing"] | 4 | rmKh9uaikTU | 4900 | |
"11 O'Clock Tick Tock" - Belfast , January 1981 | The low quality recording features a live performance of a rock song and it features passionate male vocals, alongside harmonizing male vocals, singing over arpeggiated electric guitar melody, boomy bass guitar, punchy kick and snare hits and shimmering open hats. It sounds noisy and messy, as the frequencies are clashing with each other, but it is still groovy and emotional regardless. | 2006-04-19T19:19:34Z | u2log | The audience reaction is great in this clip. | ["Bass guitar", "Music", "Punk rock", "Rock and roll"] | ["low quality", "rock", "live performance", "arpeggiated electric guitar melody", "passionate male vocal", "harmonizing male vocals", "boomy bass guitar", "shimmering open hats", "punchy kick", "punchy snare", "messy", "noisy", "groovy", "emotional"] | 4 | zWJC_qr2610 | 5486 |
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;