musiccaps_details (view)
2 rows where musiccaps_aspects contains "acoustic rhythm guitar", musiccaps_aspects contains "passionate male vocal" and musiccaps_aspects contains "rock"
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- acoustic rhythm guitar · 2 ✖
- low quality 2
- passionate male vocal · 2 ✖
- rock · 2 ✖
- addictive 1
- bouncy snare hits 1
- electric rhythm guitar melody 1
- emotional 1
- energetic 1
- groovy 1
- groovy bass guitar 1
- groovy double bass 1
- harmonizing background vocals 1
- plucked violin melody 1
- reverberant 1
- shimmering wide cymbals 1
- simple piano keys chords 1
- smooth 1
- soft kick hits 1
- wide toms roll 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Crags - Please, Sniff The Air (Official) | The low quality recording features a rock song that consists passionate male vocal, alongside, harmonizing background vocals, singing over shimmering wide cymbals, bouncy snare hits, soft kick hits, electric rhythm guitar melody in the left channel, groovy bass guitar, acoustic rhythm guitar in the right channel of the stereo image and some wide toms roll. It sounds addictive and energetic. | 2015-08-24T07:36:04Z | Mathieu Epiney | Please, Sniff The Air by The Crags © 2015 www.thecrags.ch https://www.facebook.com/thecragsmusic Music Video by EPIDEMIC music video epidemic.ch epidemicmusicvideos@gmail.com Recorded & Mixed by Claude Lander @ Taurus Studio | ["Music", "Punk rock", "Grunge", "Soul music"] | ["low quality", "rock", "passionate male vocal", "harmonizing background vocals", "shimmering wide cymbals", "bouncy snare hits", "soft kick hits", "electric rhythm guitar melody", "groovy bass guitar", "wide toms roll", "addictive", "energetic", "acoustic rhythm guitar"] | 4 | U-UF93NA3ko | 2881 | |
The Infamous Stringdusters Here Comes The Sun into Chopping Can at nTelos Pavilion 5/12/12 | The low quality recording features a live performance of a rock song and it features a passionate male vocal singing over groovy double bass, acoustic rhythm guitar, plucked violin melody and simple piano chords. It sounds reverberant, emotional, groovy and smooth - like something you would sing along to at the concert. | 2012-08-31T10:03:14Z | ConcertCasters | Check out the jam half way through! The Infamous Stringdusters cover Here Comes The Sun into Chopping Can at Charlottesville Virginia "nTelos Pavilion" 5/12/12 bluegrass live concert stage banjo slide guitar bass "blue mountain sports" "sound board mix" | ["Singing", "Music", "Song", "Bluegrass"] | ["low quality", "rock", "reverberant", "passionate male vocal", "acoustic rhythm guitar", "groovy double bass", "plucked violin melody", "simple piano keys chords", "smooth", "groovy", "emotional"] | 4 | dW4eW0Xreik | 3795 |
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;