musiccaps_details (view)
3 rows where musiccaps_aspects contains "bad audio quality", musiccaps_aspects contains "instrumental music" and musiccaps_aspects contains "poor audio quality"
This data as json, CSV (advanced)
musiccaps_aspects (array) 55 ✖
- bad audio quality · 3 ✖
- instrumental music · 3 ✖
- poor audio quality · 3 ✖
- emotional 2
- medium tempo 2
- accordion accompaniment 1
- acoustic guitar lead 1
- amateur play 1
- blues dance music 1
- blues guitar 1
- blues legends 1
- calming 1
- classical music 1
- comfort 1
- country blues band 1
- country blues hits 1
- country blues music 1
- enthusiastic 1
- european instruments 1
- exciting 1
- flute melody 1
- folk music 1
- folk musicians 1
- forgotten traditional 1
- good old days 1
- groovy music 1
- guitar rhythm 1
- gypsy music 1
- home video 1
- learner 1
- legato playing 1
- live audience 1
- live in concert 1
- live performance 1
- memdium tempo 1
- no other instrumentation 1
- no percussions 1
- nostalgic 1
- olden days 1
- passionate 1
- recital 1
- retro blues 1
- retro blues hits 1
- romantic 1
- sax cover 1
- sax tonguing 1
- saxophone lessons online 1
- soothing 1
- spirited 1
- steady rock drumming 1
- strong walking bass 1
- tenor sax 1
- traditional instruments 1
- vibrato style 1
- youtube music video 1
musiccaps_names (array) 8 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Tam w Gorlyciach - Lemko ( Лемко) ( Carpatho-Rusyn NOT Ukrainian!) | The song is an instrumental. The song is medium tempo with an accordion accompaniment, violin solo and a flute melody. The song is beautiful and nostalgic. The audio quality is poor. The song has an old gypsy soul to it. | 2009-12-12T22:29:21Z | kayetanowicz | Lemko soldier's song A lot of Lemko (Carpatho-Rusyn) people form an independent nation and we are officially recognized as one of the national minorities in some countries where we live ( Poland, Slovakia, Serbia). | ["Wind instrument, woodwind instrument", "Flute"] | ["instrumental music", "gypsy music", "medium tempo", "poor audio quality", "accordion accompaniment", "flute melody", "guitar rhythm", "european instruments", "memdium tempo", "bad audio quality", "folk music", "folk musicians", "nostalgic", "olden days", "forgotten traditional", "traditional instruments", "calming", "soothing", "good old days", "comfort"] | 1 | 0Wdh45yt7tY | 178 | |
Roy Rogers (slide guitar) - Look Over Yonders Wall | The song is an instrumental. The song is medium tempo, with an acoustic guitar playing blues, strong drumming rhythm, walking bass line and keyboard harmony. The song is exciting and has a dance rhythm. The audio quality is poor. | 2007-11-22T23:21:53Z | Vladimir BluesJammer | Roy Rogers (slide guitar) - performance from his video "Slide Guitar For Rock & Blues" http://www.homespuntapes.com | ["Blues", "Guitar", "Music", "Steel guitar, slide guitar"] | ["acoustic guitar lead", "country blues music", "poor audio quality", "instrumental music", "blues legends", "blues legends", "live performance", "live audience", "live in concert", "country blues band", "retro blues hits", "bad audio quality", "strong walking bass", "blues guitar", "steady rock drumming", "exciting", "enthusiastic", "retro blues", "country blues hits", "emotional", "enthusiastic", "groovy music", "blues dance music"] | 1 | hzznbzry5R8 | 4156 | |
CCB sax tenor hino 119 | The song is an instrumental. The song is medium tempo with a tenor saxophone playing a lilting melody in legato style. The song has no other instrumentation support. The audio quality is very poor. | 2010-01-07T21:22:33Z | Lucas Cerqueira | CCB sax tenor hino 119 | ["Brass instrument", "Saxophone"] | ["tenor sax", "amateur play", "legato playing", "poor audio quality", "saxophone lessons online", "recital", "vibrato style", "instrumental music", "no other instrumentation", "sax tonguing", "emotional", "romantic", "home video", "bad audio quality", "learner", "youtube music video", "sax cover", "passionate", "spirited", "classical music", "passionate", "no percussions", "medium tempo"] | 1 | m--xEFqqrLc | 4434 |
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;