musiccaps_details (view)
2 rows where musiccaps_aspects contains "rock", musiccaps_aspects contains "soft male vocal" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- electric guitar melody 2
- rock · 2 ✖
- soft male vocal · 2 ✖
- addictive 1
- addictive synth keys melody 1
- cool 1
- cover 1
- easygoing 1
- energetic 1
- groovy 1
- groovy bass guitar 1
- low quality 1
- mellow 1
- mono 1
- noisy 1
- punchy kick 1
- punchy snare 1
- shimmering cymbals 1
- shimmering shakers 1
- smooth bass 1
- snappy rimshots 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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Maps (UCSC Version) - Yeah Yeah Yeahs | The cover of a rock song consists of soft male vocal singing over shimmering cymbals, punchy snare and kick hits, groovy bass guitar, addictive synth keys melody and electric guitar melody. It sounds energetic, but yet mellow and addictive - thanks to that cadence. | 2006-08-06T04:59:47Z | Michael Tucker | "Fantastically Creepy" is one way it has been described. How would you describe it? Video for "Maps" by the Yeah Yeah Yeahs. Go UCSC (University of California at Santa Cruz). Check out more of our movies at http://www.finite-films.com | ["Independent music"] | ["cover", "rock", "soft male vocal", "shimmering cymbals", "punchy snare", "punchy kick", "groovy bass guitar", "addictive synth keys melody", "electric guitar melody", "energetic", "addictive", "mellow"] | 4 | nZOgoVEud_w | 4553 |
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;