musiccaps_details (view)
2 rows where musiccaps_aspects contains "boomy", musiccaps_aspects contains "groovy" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- boomy · 2 ✖
- groovy · 2 ✖
- low quality 2
- background male ad libs 1
- boomy bass 1
- flat male vocal 1
- funky 1
- groovy synth keys bass 1
- groovy synth keys melody 1
- hip hop 1
- jazz 1
- mono 1
- muddy 1
- noisy 1
- poor mix 1
- punchy kick 1
- reverberant vocal chant 1
- shimmering hi hats 1
- slap snare 1
- tinny percussive elements 1
- weird funny repetitive percussion 1
musiccaps_names (array) 8 ✖
- Electric piano 1
- Electronic organ 1
- Hip hop 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 |
---|---|---|---|---|---|---|---|---|---|---|
Edo Maajka Feat Alejuandro Buendija - Boing | The low quality recording features a hip hop song that consists of flat male vocals, alongside background male ad libs, rapping over boomy bass, punchy kick, slap snare, shimmering hi hats, tinny percussive elements and weird, funny and repetitive percussion. It sounds groovy and boomy, but also muddy and poorly mixed. | 2009-03-24T12:32:06Z | interist89 | Edo Maajka Feat Alejuandro Buendija - Boing | ["Music", "Rhythm and blues", "Hip hop music"] | ["low quality", "hip hop", "reverberant vocal chant", "boomy bass", "punchy kick", "slap snare", "flat male vocal", "shimmering hi hats", "tinny percussive elements", "weird funny repetitive percussion", "groovy", "background male ad libs", "poor mix", "boomy", "muddy"] | 4 | GOujNXEtDmg | 1716 | |
Playing Jimmy Smith's "The Cat" | The low quality recording features a groovy synth keys melody and synth keys bass playing together. It sounds jazzy, funky, boomy and the recording is noisy and in mono. Sounds like something you would hear in jazz bars. | 2009-11-04T22:37:22Z | Seamus Beaghen | "The Cat" was written by Lalo Schifrin and originally recorded by Jimmy Smith. Jimmy Smith plays the pants off it. He was a true master of the Hammond organ. I'm just having a little go now that sadly, he's no longer with us... | ["Organ", "Electric piano", "Electronic organ", "Keyboard (musical)", "Piano"] | ["low quality", "groovy synth keys melody", "groovy synth keys bass", "noisy", "mono", "boomy", "funky", "jazz", "groovy"] | 4 | cX926M1_LqM | 3714 |
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;