musiccaps_details (view)
2 rows where musiccaps_aspects contains "instrumental", musiccaps_aspects contains "keyboard accompaniment" and musiccaps_aspects contains "spirited"
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- instrumental · 2 ✖
- keyboard accompaniment · 2 ✖
- muddled audio 2
- spirited · 2 ✖
- buoyant 1
- cajun 1
- chatter of people 1
- clapping 1
- congas 1
- crowd cheering 1
- crowd hooting 1
- dance music 1
- distorted audio 1
- drums 1
- electric guitar harmony 1
- energetic 1
- enthusiastic 1
- enthusiastic amplified guitar 1
- gig 1
- groovy bass line 1
- hard rock 1
- intense 1
- keyboard harmony 1
- live performance 1
- lively 1
- loud electric guitar feedback 1
- people talking 1
- punchy drumming 1
- synthesiser 1
- wind instrument harmony 1
- youthful 1
musiccaps_names (array) 3 ✖
- Music 2
- Field recording 1
- Steelpan 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Sounds - Diana | This song is a hard rock instrumental. The tempo is fast with bright electric guitars playing lead, steady bass line, punchy drumming and upbeat keyboard harmony The music is energetic, upbeat, youthful, engaging, buoyant, peppy, and groovy.it is a crowd pleaser ,as clapping, cheering , chatter and hooting can be heard in the background. | 2011-01-24T20:11:57Z | katrin3417 | The Sounds am 21. Januar 2011 bei der Snowhite Music Night im Postbahnhof in Berlin | ["Music", "Field recording"] | ["loud electric guitar feedback", "punchy drumming", "keyboard accompaniment", "keyboard harmony", "groovy bass line", "instrumental", "hard rock", "enthusiastic amplified guitar", "muddled audio", "crowd cheering", "crowd hooting", "people talking", "clapping", "live performance", "gig", "synthesiser", "enthusiastic", "spirited", "energetic", "youthful", "buoyant", "intense"] | 7 | 3dUo62RsD00 | 489 | |
demo kisanola | This song is an instrumental. The tempo is medium fast with enthusiastic drumming, congas and canon rhythm,electronic guitar harmony, keyboard accompaniment and a wind instrument playing a melodious harmony. There is the sound of chattering in the background. The audio is of inferior quality and muddled. The song is energetic, spirited and melodic with a catchy dance groove. | 2007-11-17T14:44:37Z | llawal41 | african men dancing like men, not women | ["Music", "Steelpan"] | ["instrumental", "distorted audio", "drums", "dance music", "wind instrument harmony", "congas", "electric guitar harmony", "keyboard accompaniment", "cajun", "lively", "spirited", "dance music", "muddled audio", "chatter of people"] | 7 | rTBQmP6Vt0g | 4878 |
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;