musiccaps_details (view)
2 rows where musiccaps_aspects contains "bad audio quality", musiccaps_aspects contains "song cover" and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 41 ✖
- bad audio quality · 2 ✖
- male singer 2
- song cover · 2 ✖
- amateur singer 1
- autoharp accompaniment 1
- backup singers 1
- band audio quality 1
- classic county hits 1
- country classics 1
- country music 1
- emotional 1
- enthusiastic 1
- euro pop 1
- everlasting hits 1
- exciting 1
- friendship 1
- groovy rhythm 1
- guitar strumming 1
- heartfelt 1
- home music video 1
- inspiring 1
- love song 1
- medium tempo 1
- memdium tempo 1
- modern pop hits 1
- nostalgia 1
- old memories 1
- pleasant 1
- pop song 1
- pop song cover 1
- pop super hits 1
- retro hits 1
- romantic 1
- steady drumming 1
- story telling 1
- touching 1
- ukulele accompaniment 1
- ukulele playing rhythm 1
- walking bas s line 1
- walking bass line 1
- youtube music video 1
musiccaps_names (array) 5 ✖
- Music 2
- Musical instrument · 2 ✖
- Christian music 1
- Plucked string instrument 1
- Ukulele 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Aleksander Mežek - Siva pot | A male singer sings this popular country hit with backup singers in vocal harmony. The song is in medium tempo with a walking bass , acoustic guitar strumming rhythmically, autoharp accompaniment and steady drumming rhythm. The song is an emotional and nostalgic country hit. The audio quality is poor. | 2006-12-19T14:33:29Z | jaki386 | Aleksander Mežek - Siva pot | ["Christian music", "Music", "Musical instrument"] | ["male singer", "backup singers", "guitar strumming", "everlasting hits", "euro pop", "medium tempo", "walking bass line", "autoharp accompaniment", "walking bas s line", "steady drumming", "story telling", "nostalgia", "pleasant", "exciting", "enthusiastic", "old memories", "classic county hits", "pop super hits", "retro hits", "groovy rhythm", "country classics", "bad audio quality", "song cover", "country music"] | 1 | 3KQy3Cajo4E | 456 | |
Ukulele Tutorial #54 (Count On Me, Bruno Mars) | A male singer sings this popular song. The tempo is medium with an ukulele playing rhythm accompanying the male vocals with no other instrumentation. The song is emotional and inspiring. The audio quality is bad. | 2010-07-06T19:06:01Z | Krankthat22 | NEW WEBSITE is up and running! Check it out and let me know what you think!! Feedback is much appreciated! Thank me later. Click here now! http://tinyurl.com/Krankthat22 Em - 0432 C - 0003 Am - 2000 F - 2010 Dm - 2210 G - 0121 verse/chorus C Em Am G F bridge #1 Dm Em F G Bridge #2 ("a shoulder to cry on" part of lyrics) Dm G C G | ["Music", "Musical instrument", "Ukulele", "Plucked string instrument"] | ["male singer", "ukulele accompaniment", "bad audio quality", "inspiring", "amateur singer", "ukulele playing rhythm", "memdium tempo", "song cover", "emotional", "love song", "romantic", "touching", "youtube music video", "friendship", "touching", "heartfelt", "pop song", "pop song cover", "modern pop hits", "band audio quality", "home music video"] | 1 | MpjN21Z93JY | 2302 |
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;