musiccaps_details (view)
1 row where musiccaps_names contains "Classical music" and youtube_description = "Again the Queen song, the old video had such a bad picture quality, and I wanted to present my new Ukulele. This is a "Platinum S-Edition" by Schaepe. Two modifications were done to this 14(!) Euro instrument (which doubled it's value), first it got guitar tuners, and second it got Worth strings."
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_names (array) 6 ✖
- Classical music · 1 ✖
- Guitar 1
- Music 1
- Musical instrument 1
- Plucked string instrument 1
- Ukulele 1
musiccaps_aspects (array) 3 ✖
youtube_description 1 ✖
- Again the Queen song, the old video had such a bad picture quality, and I wanted to present my new Ukulele. This is a "Platinum S-Edition" by Schaepe. Two modifications were done to this 14(!) Euro instrument (which doubled it's value), first it got guitar tuners, and second it got Worth strings. · 1 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Bohemian Rhapsody | This song contains someone playing a ukulele fingerstly. This song may be playing live sitting around a bonfire with friends. | 2006-12-15T15:29:06Z | WS64 | Again the Queen song, the old video had such a bad picture quality, and I wanted to present my new Ukulele. This is a "Platinum S-Edition" by Schaepe. Two modifications were done to this 14(!) Euro instrument (which doubled it's value), first it got guitar tuners, and second it got Worth strings. | ["Guitar", "Music", "Musical instrument", "Ukulele", "Plucked string instrument", "Classical music"] | ["amateur recording", "ukulele", "medium to uptempo"] | 6 | Wdl7A3de0L4 | 3114 |
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;