musiccaps_details (view)
2 rows where musiccaps_aspects contains "average audio quality", musiccaps_aspects contains "instrumental music" and musiccaps_aspects contains "youthful"
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- average audio quality · 2 ✖
- instrumental music · 2 ✖
- medium tempo 2
- youthful · 2 ✖
- banjo band 1
- banjo players 1
- banjo playing demonstration 1
- classical music 1
- clean tones 1
- dance club 1
- dance floor 1
- dj 1
- electronic dance music 1
- energetic 1
- folk music 1
- groovy bass line 1
- groovy rhythm 1
- grunge keyboard tones 1
- harmony 1
- home video recording 1
- instrumental duet 1
- music practice 1
- mysterious 1
- no other instrumentation 1
- no percussion instruments 1
- people dancing 1
- powerful 1
- spirited 1
- strong tones 1
- synth trumpet lead 1
- techno dance rhythm 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Azzido Da Bass - Music For Bagpipes (TRASHLINE Remix) [HD] | The song is an instrumental. The song is medium tempo with a groovy bass line, grunge keyboard tones, synth trumpet lead and techno drumming rhythm. The song is entertaining and energetic. The song is an electronic dance song with average quality recording. | 2010-09-04T16:45:36Z | PapayaOficiallRP | Azzido Da Bass - Music For Bagpipes (TRASHLINE Remix) Watch in HD! Suscribe! ;) MSN: PAPAiiA-JEtAiiME@hotmail.fr By: PapayaOficiallRP | ["Music", "Techno", "Dubstep", "Cacophony", "Electronic dance music"] | ["average audio quality", "groovy rhythm", "electronic dance music", "instrumental music", "groovy bass line", "medium tempo", "synth trumpet lead", "people dancing", "dj", "techno dance rhythm", "dance club", "dance floor", "spirited", "energetic", "youthful", "grunge keyboard tones"] | 1 | 4Mm5mBgktG0 | 562 | |
Dueling Banjos - Sleepy Man Banjo Boys - Revenge of the Guitar | Two banjo players trade solos in this instrumental song. The song is medium tempo with banjos playing in a call and response manner and no other instrumentation. The song is energetic and has a middle eastern classical music vibe. The audio quality is average and recorded at Jo e. | 2012-03-13T03:15:13Z | Sleepy Man | Become a fan! https://sleepyman.com/fanclub The boys practice a version of Eric Weissberg's "Dueling Banjos" in the Bedroom - Sleepy Man Banjo Boys - 9 Year old Jonny Mizzone (banjo) and his brothers Robbie Mizzone, 13 (fiddle), and Tommy Mizzone,14 (guitar). | ["Banjo", "Music", "Strum"] | ["banjo players", "instrumental duet", "average audio quality", "harmony", "home video recording", "banjo band", "youthful", "classical music", "clean tones", "mysterious", "folk music", "instrumental music", "medium tempo", "banjo playing demonstration", "no percussion instruments", "powerful", "strong tones", "music practice", "no other instrumentation"] | 1 | RFbWkL818XQ | 2685 |
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;