musiccaps_details (view)
2 rows where musiccaps_aspects contains "digital drums" and musiccaps_aspects contains "groovy bass lines"
This data as json, CSV (advanced)
musiccaps_aspects (array) 48 ✖
- buoyant 2
- digital drums · 2 ✖
- fast tempo 2
- groovy bass lines · 2 ✖
- advanced chord structure 1
- ambient mixes 1
- atmospheric 1
- club music 1
- dance groove 1
- dance pop 1
- dancing 1
- deep house 1
- edm 1
- electrifying 1
- electronic effects 1
- electronica 1
- energetic 1
- enthusiastic 1
- female vocalist 1
- hard rock 1
- incessant beats 1
- inferior quality audio 1
- intense 1
- intense electric guitar feed back 1
- loud singing 1
- male singer 1
- melodious 1
- muffled audio 1
- passionate 1
- pop rock 1
- psychedelic 1
- pulsating beats 1
- punchy 1
- punchy drum beats 1
- repetitive 1
- reverb 1
- rock 1
- soulful vocals 1
- spirited 1
- stimulating 1
- synth arrangements 1
- synthesiser arrangements 1
- techno music 1
- throbbing 1
- unobstructive 1
- vibrant 1
- vigorous drumming 1
- youthful 1
musiccaps_names (array) 3 ✖
- Music 2
- Disco 1
- Independent music 1
youtube_published (date) 2 ✖
- 2007-09-09 1
- 2014-02-20 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
ITV Chart Show Indie Chart July 1995 | A female vocalist sings this energetic song. The tempo is fast with furiously energetic drumming, intense electric guitar, groovy bass lines, keyboard harmony, vocal backup and synthesiser arrangements. The song is passionate, spirited,youthful, buoyant, punchy, energetic and animated. The audio is muddy and incoherent. This song is Pop Rock. | 2007-09-09T16:56:00Z | David Bryant | Features: Buffalo Tom - Summer Song Menswear - Daydreamer | ["Music", "Independent music"] | ["female vocalist", "loud singing", "fast tempo", "pop rock", "hard rock", "dance groove", "buoyant", "spirited", "passionate", "vibrant", "enthusiastic", "energetic", "intense", "vigorous drumming", "intense electric guitar feed back", "groovy bass lines", "synth arrangements", "digital drums", "muffled audio", "inferior quality audio", "rock"] | 7 | J48F0e0guSQ | 1966 | |
|Deep house| Cutting Shapes | A male vocalist sings this catchy song. The tempo is fast with synthesiser arrangement, punchy digital drum beats, groovy bass line and melodic vocal backup. The music has a repetitive, catchy vocal riff. It is youthful, punchy, bouncy, thumping, pulsating, and throbbing with soulful vocals and a dance groove. This music is Deep House/Techno pop. | 2014-02-20T00:28:06Z | Simon Boles | ["Disco", "Music"] | ["male singer", "fast tempo", "punchy drum beats", "digital drums", "synthesiser arrangements", "electronic effects", "reverb", "techno music", "edm", "electronica", "dance pop", "club music", "deep house", "pulsating beats", "electrifying", "youthful", "punchy", "throbbing", "buoyant", "psychedelic", "repetitive", "incessant beats", "melodious", "groovy bass lines", "ambient mixes", "atmospheric", "advanced chord structure", "soulful vocals", "unobstructive", "stimulating", "dancing"] | 7 | poxsF3-HeP0 | 4736 |
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;