musiccaps_details (view)
3 rows where musiccaps_author = 3 and musiccaps_names contains "Disco"
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- funky 2
- simple drum beat 2
- upbeat 2
- bright brass sounding instruments 1
- bright synths 1
- chanting male background vocal 1
- complex fast drum beat 1
- dance 1
- dance song 1
- deep house 1
- deep techno house 1
- disco 1
- fuzzy bass 1
- groovy 1
- raspy male voice 1
- screaming female background vocal 1
- simple bass pattern 1
- soulful 1
- speaking 1
- vibrant soulful male vocal 1
musiccaps_names (array) 5 ✖
- Disco · 3 ✖
- Music 3
- Electronic music 1
- Funk 1
- House music 1
youtube_published (date) 3 ✖
- 2008-06-23 1
- 2009-09-10 1
- 2016-03-15 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Sunfire - Never Too Late For Your Lovin' (12" Funk 1983) | The song is a funky, soulful disco song. The whole vibe is vibrant and upbeat and features a bouncy groove from a bass guitar as well as bright and shimmery sounding brass instruments. There's a sustained silky synth sound. The singer sounds cheerful. The song is suitable for dancing. | 2016-03-15T18:37:57Z | Coolfunk Zézé 2 | Funk Never Too Late For Your Lovin' (12" Funk 1983) | ["Disco", "Funk", "Music"] | ["disco", "funky", "soulful", "upbeat", "groovy", "dance", "vibrant soulful male vocal", "bright synths", "simple drum beat", "bright brass sounding instruments"] | 3 | ABr4Q_ecoPw | 1082 | |
Rick james SLAP | The clip has no melodic instruments. It is mainly built of a complex persuasive rhythm played on the drums, and a repeated phrase by a male speaker in a raspy vocal. In the background, we have a soulful male voice chanting the same phrase repeatedly, and a female screaming voice once roughly every two bars. | 2008-06-23T18:28:43Z | mohem10 | yeeeeaaaaaaaaaa | ["Disco", "Music"] | ["raspy male voice", "speaking", "dance song", "upbeat", "funky", "complex fast drum beat", "chanting male background vocal", "screaming female background vocal"] | 3 | IhNPDueFVSo | 1929 | |
Musica de discoteca...mesmo brutal...xd | This is a deep tech house song with a simple beat, and simple bassline that consists of one note. There aren't any melodic components to the song besides the one bass note that is played with the same repeated rhythm. | 2009-09-10T15:27:15Z | cimbalino0 | Esta musica é totil fixe...xd é de discoteca klaru!!!!...xd | ["Disco", "Electronic music", "House music", "Music"] | ["deep house", "deep techno house", "simple drum beat", "fuzzy bass", "simple bass pattern"] | 3 | SSVlD_ZDb70 | 2768 |
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;