musiccaps_details (view)
3 rows where musiccaps_aspects contains "cool" and musiccaps_aspects contains "groovy" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- cool · 3 ✖
- groovy · 3 ✖
- low quality 3
- noisy 2
- clapping 1
- country blues 1
- dj scratching 1
- easygoing 1
- electric guitar melody 1
- electro dub 1
- energetic 1
- fruity male vocal 1
- groovy bass 1
- groovy electric guitar melodies 1
- mellow snare 1
- mono 1
- passionate 1
- punchy kick 1
- punchy snare 1
- rock 1
- shimmering cymbals 1
- shimmering shakers 1
- short bass stabs 1
- simple synth bells melody 1
- smooth bass 1
- snappy rimshots 1
- soft crash cymbal 1
- soft kick hits 1
- soft male vocal 1
- uptempo 1
- uptempo hi hats 1
- vintage 1
musiccaps_names (array) 15 ✖
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Blues, Country Blues, Rhythm & Blues | The low quality recording features a country blues song that consists of fruity male vocal singing over groovy electric guitar melodies, groovy bass, shimmering cymbals, mellow snare, soft kick hits and clapping. The recording is a bit noisy, as it is vintage, and it sounds passionate, groovy, uptempo and cool. | 2010-06-04T21:51:03Z | StrontiumDawg | 3 fine slices of blues music. Got my mojo workin' - Muddy Waters, Frankie - Missisipi John Hurt, Crawling up a hill - John Mayall | ["Blues", "Singing", "Swing music", "Country", "Music", "Rhythm and blues", "Music of Latin America"] | ["low quality", "country blues", "vintage", "noisy", "fruity male vocal", "groovy electric guitar melodies", "groovy bass", "shimmering cymbals", "mellow snare", "soft kick hits", "clapping", "uptempo", "groovy", "passionate", "cool"] | 4 | ZzyWbehtt0M | 3433 | |
DJ Architect Serbia - IDA WORLD SCRATCH BATTLE 2014 | The low quality recording features a DJ scratching a vinyl of an electro dub song that consists of uptempo hi hats, punchy kick and snare hits, short bass stabs, soft crash cymbal and simple synth melody. It sounds energetic, cool and groovy. | 2014-11-15T22:53:54Z | IDAWORLDOFFICIAL | First round of Reebok IDA WORLD SCRATCH Online BATTLE 2014 supported by TRAKTOR 1:30 min. scratch freestyle to DJ Odilon's "Kut Komando II Loop" Judges choose 4 best Dj's by giving them points. One extra Dj with the biggest number of youtube views will also make 2nd round. Our jury are: MODULATORS (POL) - one vote DJ ROB BANKZ (GER) -- IDA World Champion 2008 DJ MANDRAYQ (ITA) -- IDA World Champion 2010 DJ CROSS (BEL) -- IDA World Champion 2011 DJ ESQUIRE (USA) -- 2 x DMC USA Champion DJ TIGERSTYLE (UK) -- 3 x World Champion FONG FONG (FR) -- DMC Online 2012 World Champion For more info follow our facebook fanpage: https://www.facebook.com/pages/IDA-World-Fan-Page/115550591841669?ref=hl | ["Scratching (performance technique)", "Sampler", "Music", "Scratch", "Dubstep", "Drum machine"] | ["low quality", "electro dub", "dj scratching", "punchy snare", "punchy kick", "uptempo hi hats", "soft crash cymbal", "simple synth bells melody", "energetic", "cool", "groovy", "short bass stabs"] | 4 | A6ilKRqIDH4 | 1069 | |
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 |
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;