musiccaps_details (view)
3 rows where musiccaps_aspects contains "groovy bass", musiccaps_aspects contains "passionate male vocal", musiccaps_aspects contains "reverberant" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
"Odyssey" Shuffle | The low quality recording features a R&B song playing on a speaker, judging by the reverberant and boomy sound of it. The song consists of passionate male vocal singing over shimmering hi hats, claps, groovy bass and "4 on the floor" kick pattern, It sounds passionate, like something you would dance to with your partner. | 2009-12-01T13:37:07Z | Freda Terry | Chicago Vocational School's (CVS) line dance instructor Graham is teaching a few of his students Betty 1, Betty 2, Faylesha, Jackie and Freda the "Odyssey" shuffle. His class is held at CVS on Mondays at 7pm to 8:30pm. Music is a Temptation's remix. | ["Music", "Shuffle"] | ["low quality", "r&b", "boomy", "passionate male vocal", "claps", "shimmering hi hats", "groovy bass", "noisy", "passionate", "speaker", "reverberant", "4 on the floor kick"] | 4 | -M6K3QoHh40 | 38 | |
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 | ||
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;