musiccaps_details (view)
2 rows where musiccaps_aspects contains "harmonizing background vocals", musiccaps_aspects contains "passionate male vocal" and musiccaps_aspects contains "rock"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- energetic 2
- harmonizing background vocals · 2 ✖
- low quality 2
- passionate male vocal · 2 ✖
- rock · 2 ✖
- acoustic rhythm guitar 1
- addictive 1
- bouncy snare hits 1
- electric rhythm guitar melody 1
- groovy bass guitar 1
- noisy 1
- punchy snare 1
- saxophone melody 1
- shimmering wide cymbals 1
- simple hi hats 1
- smooth bass 1
- soft kick hits 1
- thin kick 1
- uplifting 1
- vintage 1
- wide toms roll 1
musiccaps_names (array) 7 ✖
- Music 2
- Grunge 1
- Music of Africa 1
- Punk rock 1
- Ska 1
- Soul music 1
- Swing music 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 | |
Edsels - Rama Lama Ding Dong - Youngstown Ohio Doo Wop Sound | The low quality recording features a rock song that consists of harmonizing background vocals, alongside passionate male vocals, singing over, at least, punchy snare, simple hi hats, smooth bass, thin kick and punchy snare hits. The recording is so noisy that the actual song can barely be heard, but regardless it sounds vintage, energetic and uplifting. | 2010-04-13T01:59:16Z | PJDooWop | This is a true doo wop classic, coming to you from the very rare original "Lama Rama Ding Dong" pressing on Dub records. | ["Swing music", "Music of Africa", "Music", "Ska"] | ["low quality", "noisy", "vintage", "harmonizing background vocals", "passionate male vocal", "punchy snare", "saxophone melody", "rock", "simple hi hats", "thin kick", "smooth bass", "uplifting", "energetic"] | 4 | s6U8DtBK3Us | 4925 |
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;