musiccaps_details (view)
3 rows where "youtube_published" is on date 2009-09-16 sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 44 ✖
- acoustic guitar 1
- ambient sounds 1
- booming 1
- boomy 1
- clapping 1
- club music 1
- dj 1
- dj mixer 1
- electro 1
- electro music 1
- filtered synth bass 1
- higher pitch 1
- hindi/pop 1
- hip-hop 1
- instrumental 1
- live audience 1
- live performance 1
- low quality 1
- male voice singing 1
- medium fast tempo 1
- medium to uptempo 1
- new age music 1
- peaceful sounding 1
- percussive sounds 1
- poor mix 1
- pulsating 1
- rap 1
- resonating 1
- reverb 1
- reverberant "4 on the floor" kick hits 1
- rhythmic 1
- robotic sounds 1
- scratching 1
- short riser 1
- suspenseful synth stab 1
- tablas 1
- techno music 1
- thin 1
- turn table 1
- turntablist 1
- vibrations 1
- vinyl record scratching 1
- violin 1
- youthful 1
musiccaps_names (array) 10 ✖
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 | |
Carrom - 10 Slams and 100 Ideas for Dynamic Carrom - Part1 of 12 | This song contains a tabla rhythm spread across both sides of the speakers. An acoustic guitar melody panned to the right side of the speakers. Far in the background you can hear clapping as part of the song. A male voice is singing in a higher register than a violin takes over playing a melody in a higher register with reverb and a little delay. This song may be playing in a lovely movie-scene. | 2009-09-16T03:35:04Z | carrompassion | 10 Slams and 100 Ideas for Dynamic Carrom - Part1 of 12 | ["Folk music", "Music"] | ["hindi/pop", "tablas", "violin", "acoustic guitar", "clapping", "male voice singing", "higher pitch", "medium to uptempo", "peaceful sounding"] | 6 | nFoktpUVeVw | 4528 | |
gensan tuna fest sound system rumble | The low quality recording features an electro song that consists of a reverberant "4 on the floor" kick pattern, followed by suspenseful synth stabs. At the very end of the loop there is a short riser, after which comes the snippet of a filtered synth bass. It sounds thin, as it was poorly mixed. | 2009-09-16T08:22:06Z | ostjay26 | ["Music", "Techno", "Rumble", "Dubstep", "Electronic dance music", "Dance music"] | ["low quality", "reverberant \"4 on the floor\" kick hits", "suspenseful synth stab", "filtered synth bass", "short riser", "electro", "thin", "poor mix"] | 4 | H6rZwBc6aNM | 1776 |
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;