musiccaps_details (view)
3 rows where musiccaps_aspects contains "groovy bass", musiccaps_aspects contains "mono" and musiccaps_aspects contains "passionate male vocal"
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- groovy bass · 3 ✖
- low quality 3
- mono · 3 ✖
- passionate male vocal · 3 ✖
- joyful 2
- noisy 2
- accordion melody 1
- acoustic rhythm guitar 1
- brass section 1
- electric guitar melody 1
- emotional 1
- harmonizing male vocals 1
- harmonizing mixed vocals 1
- hopeful 1
- jazz 1
- live performance 1
- passionate 1
- playback instrumental 1
- punchy snare 1
- reverberant 1
- shimmering tambourine 1
- shoe tapping 1
- soft kick hits 1
- soul 1
- soulful 1
- toms roll 1
musiccaps_names (array) 5 ✖
- Music 3
- /t/dd00003 1
- Applause 1
- Middle Eastern music 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Dance Theme Tap Line 2010 | The low quality recording features a jazz song playing in the background while people are shoe tapping to it. The jazz song at least consists of passionate male vocal, groovy bass and brass section, since those elements are audible. It is reverberant and in mono, as it was probably recorded with a phone. | 2010-08-09T05:32:35Z | Blake MacEachern | ["Applause", "Music"] | ["low quality", "shoe tapping", "jazz", "brass section", "passionate male vocal", "groovy bass", "reverberant", "mono"] | 4 | BlsbeyimUDE | 1290 | ||
loretta lynn "when the roll is called" | The low quality recording features a passionate male vocal, alongside harmonizing mixed vocals, singing over acoustic rhythm guitar, accordion melody and groovy bass. It sounds passionate and joyful. The recording is noisy and in mono - the sound is coming from the right channel only. | 2007-07-17T06:19:50Z | lorettafan1 | with teddy and doyle and the willis brothers | ["Singing", "Music", "Middle Eastern music"] | ["low quality", "noisy", "mono", "harmonizing mixed vocals", "passionate male vocal", "accordion melody", "acoustic rhythm guitar", "groovy bass", "passionate", "joyful"] | 4 | _2P_EJsnBls | 3437 | |
New York Subway's Danny Small aka Singing Dragon | The low quality recording features a live performance of a soul song and it consists of passionate male vocal singing over playback instrumentals. The instrumental consists of a shimmering tambourine layered with punchy snare hits, soft kick hits, some toms rolls, groovy bass, electric guitar melody and harmonizing male vocals. It sounds emotional, soulful, hopeful and joyful. | 2010-03-07T21:11:15Z | BayardStudios | He calls himself the "Singing Dragon", his name is Mitchell Hughes aka Danny Small of Gheechee Records LLC aka the Singing Dragon and he was performing at the 14th St/6th Ave station. Originally from South Carolina, there is logic to the moniker Singing Dragon, he was born the same year as Bruce Lee in the Chinese calendar year of the Dragon, of Puerto Rican, Dominican, Cuban, Brazilian, Mexican and Guyanese and even Chinese descent. A marvel amongst subway performers, what a wonderful way to end a walkabout. Shot with a Canon 5D Mark II, Canon 16-35mm f/2.8L, recorded with the in-camera mic and moderately mixed in Final Cut Pro 6. | ["Music", "/t/dd00003"] | ["low quality", "live performance", "noisy", "mono", "passionate male vocal", "soul", "playback instrumental", "shimmering tambourine", "punchy snare", "groovy bass", "electric guitar melody", "soft kick hits", "toms roll", "harmonizing male vocals", "emotional", "hopeful", "joyful", "soulful"] | 4 | l1coM570kVw | 4370 |
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;