musiccaps_details (view)
3 rows where musiccaps_aspects contains "average audio quality" and musiccaps_aspects contains "youthful" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 45 ✖
- average audio quality · 3 ✖
- youthful · 3 ✖
- energetic 2
- groovy bass line 2
- instrumental music 2
- medium tempo 2
- banjo band 1
- banjo players 1
- banjo playing demonstration 1
- cheerful 1
- classic rock 1
- classical music 1
- clean tones 1
- dance club 1
- dance floor 1
- distorted guitars 1
- dj 1
- electric guitar lead 1
- electronic dance music 1
- folk music 1
- groovy rhythm 1
- grunge keyboard tones 1
- harmony 1
- home video recording 1
- instrumental duet 1
- male singer 1
- medium fast tempo 1
- music practice 1
- mysterious 1
- no other instrumentation 1
- no percussion instruments 1
- passionate 1
- people dancing 1
- percussive guitar strumming 1
- powerful 1
- retro rock 1
- rock band 1
- rock music 1
- spirited 1
- string rock drumming 1
- strong tones 1
- studio recording 1
- synth trumpet lead 1
- tambourine percussions 1
- techno dance rhythm 1
musiccaps_names (array) 11 ✖
- Music 3
- Banjo 1
- Cacophony 1
- Dubstep 1
- Electronic dance music 1
- Grunge 1
- Heavy metal 1
- Progressive rock 1
- Punk rock 1
- Strum 1
- Techno 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
ROCK 'N ROLL ICE CREAM - Marky Ramone & Missing Sound.mov | A male singer sings this rock melody. The song is medium fast tempo with a strong rock drumming rhythm, percussive bass line, distorted guitars playing rhythm and lead along with tambourine percussion. The song is energetic and cheerful. The song is a rock song with an average quality audio. | 2012-02-10T11:45:21Z | gian maria emendatori | ["Heavy metal", "Music", "Punk rock", "Progressive rock", "Grunge"] | ["male singer", "rock music", "classic rock", "string rock drumming", "average audio quality", "retro rock", "passionate", "rock band", "youthful", "energetic", "cheerful", "studio recording", "medium fast tempo", "string rock drumming", "tambourine percussions", "electric guitar lead", "percussive guitar strumming", "groovy bass line", "distorted guitars"] | 1 | fXhN3_gGpQw | 3957 | ||
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;