musiccaps_details (view)
1 row where search matches "guitar", musiccaps_aspects contains "passionate male vocal" and musiccaps_aspects contains "thin snare" sorted by musiccaps_caption
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 12 ✖
- addictive 1
- electric rhythm guitar chords 1
- energetic 1
- energetic crash 1
- groovy bass 1
- harmonizing background male vocal 1
- passionate male vocal · 1 ✖
- punchy kick hits 1
- reverberant 1
- rock 1
- shimmering hi hats 1
- thin snare · 1 ✖
musiccaps_names (array) 3 ✖
- Music 1
- Rock and roll 1
- Roll 1
video | youtube_link | musiccaps_caption ▼ | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Connells - Scotty's Lament | The Rock song features a passionate male vocal, layered with harmonizing background male vocals, singing over electric rhythm guitar chords spread widely in the stereo image, thin snare, energetic crash, groovy bass, shimmering hi hats and punchy kick hits. The drums are very reverberant, which is probably the reason why they sound softer. It sounds addictive, thanks to those harmonizing vocals, and energetic overall. | 2007-11-12T22:30:12Z | streetsintherain | The video for "Scotty's Lament", made in 1987. | ["Music", "Roll", "Rock and roll"] | ["rock", "passionate male vocal", "harmonizing background male vocal", "electric rhythm guitar chords", "groovy bass", "thin snare", "energetic crash", "shimmering hi hats", "punchy kick hits", "reverberant", "addictive", "energetic"] | 4 | hKSg3zFB2dE | 4095 |
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;