musiccaps_details (view)
2 rows where musiccaps_aspects contains "energetic", musiccaps_aspects contains "groovy rhythm" and musiccaps_aspects contains "strong bass line"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
spray paint can | The song is an instrumental. The song is medium tempo with a groovy bass line, techno drumming rhythm, keyboard synth string accompaniment and other percussive hits. The song is energetic and passionate. The song is a techno dance tune and has poor audio quality, | 2010-07-27T10:08:45Z | newfantachrome | http://www.newfantachrome.com Chrome Spray !!! Dear Customers, We never stop developing new ideas ! See our new Spray Chrome SOLUTION !!! VIDEO DEMONSTRATION (CLICK HERE) Call us for more info about this AMAZING application ! | ["Music", "Spray"] | ["techno dance music", "poor audio quality", "medium tempo", "poor audio quality", "groovy rhythm", "ad jingle", "hissing tones", "instrumental music", "keyboard synth harmony", "strong bass line", "techno drum rhythm", "hissing tones", "energetic", "emotional", "passionate", "dance groove", "tv advertisement sound track"] | 1 | AU1l1i0H0j0 | 1119 | |
DJ Shortee - "Watch Out Now" Beatjuggle Routine 2003 | A DJ plays a cool groove with some female vocals. The song is medium tempo with a steady drumming rhythm, scratch disc percussions, and percussive bass line. The song is exciting and groovy. The audio quality is average. | 2006-08-07T01:33:25Z | DJ Shortee | Turntablist beat juggle routine performed by Shortee in 2003 with the Beatnuts' song "Watch Out Now". Featured on "Shortee's DJ 202" Instructional DVD available on www.how2dj.com. Learn more about shortee at www.djshortee.com! | ["Scratching (performance technique)", "Music", "Speech", "Hip hop music"] | ["dj", "female singer", "repeated vocal phrases", "techno dance music", "average audio quality", "groovy music", "dj turntable", "spinning discs", "scratching disc", "energetic", "groovy rhythm", "strong bass line", "steady rhythm", "medium tempo", "people dancing", "retro electronica", "electronic dance music", "dance floor"] | 1 | J0t4VMnXDNM | 1960 |
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;