musiccaps_details (view)
2 rows where musiccaps_aspects contains "live audience", musiccaps_aspects contains "medium fast tempo" and musiccaps_aspects contains "youthful"
This data as json, CSV (advanced)
musiccaps_aspects (array) 41 ✖
- live audience · 2 ✖
- live performance 2
- medium fast tempo · 2 ✖
- youthful · 2 ✖
- adrenaline junkies 1
- ambient sounds 1
- booming 1
- boomy 1
- club music 1
- dance rhythm 1
- dj 1
- dj mixer 1
- electro music 1
- energetic 1
- energetic drumming rhythm 1
- entertaining 1
- groovy bass line 1
- hip-hop 1
- instrumental 1
- instrumental music 1
- new age music 1
- people cheering 1
- percussive sounds 1
- percussive tap dancing 1
- positive 1
- pulsating 1
- rap 1
- resonating 1
- reverb 1
- rhythmic 1
- robotic sounds 1
- scratching 1
- snares riding fast 1
- spirited 1
- tap dancers 1
- techno music 1
- turn table 1
- turntablist 1
- various percussion hits 1
- vibrations 1
- vinyl record scratching 1
musiccaps_names (array) 5 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
DJ Q-Bert "Method Man" scratch 2009 | This music is instrumental. The tempo is medium fast with boomy bass, turntable scratching and digitally arranged music. The music is muffled as the audio quality is inferior but the beats are punchy, buoyant, bouncy, youthful, groovy and energetic. This music is a turntable scratching technique. | 2009-09-16T00:20:26Z | Trikpah | DJ Q-Bert live 2009 | ["Scratching (performance technique)", "Music", "Musical instrument", "Hip hop music"] | ["instrumental", "medium fast tempo", "boomy", "live performance", "live audience", "ambient sounds", "reverb", "resonating", "robotic sounds", "turn table", "scratching", "dj", "dj mixer", "club music", "pulsating", "vibrations", "booming", "vinyl record scratching", "youthful", "new age music", "techno music", "electro music", "percussive sounds", "rhythmic", "turntablist", "hip-hop", "rap"] | 7 | YJKZVSvz1Bk | 3274 | |
Tap Dogs I Beams | The song is an instrumental. The song is medium fast tempo with a groovy bass line, energetic drumming, and tap dancers in a percussive groove. The song is entertaining and energetic. | 2009-07-26T17:06:46Z | Tap Dogs Official | ["Music", "Tap"] | ["tap dancers", "percussive tap dancing", "adrenaline junkies", "live audience", "live performance", "instrumental music", "groovy bass line", "people cheering", "energetic drumming rhythm", "medium fast tempo", "various percussion hits", "snares riding fast", "entertaining", "energetic", "positive", "spirited", "youthful", "dance rhythm"] | 1 | oRUdvu3Qo-E | 4628 |
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;