musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "acoustic guitar" and musiccaps_aspects contains "bird chirping" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- acoustic guitar · 2 ✖
- bird chirping · 2 ✖
- backing vocals 1
- bass guitar 1
- children having fun 1
- drums 1
- happy 1
- low fidelity 1
- male voice 1
- open chords 1
- quiet male vocals 1
- singing 1
- strumming 1
- uplifting atmosphere 1
musiccaps_names (array) 5 ✖
- Music 2
- Acoustic guitar 1
- Flamenco 1
- Happy music 1
- Strum 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
BELAJAR GITAR SHAGGY DOG DI SAYIDAN | happy music featuring a solo acoustic strummed guitar playing open chords, quiet male singing, and a bird chirping in the background. | 2015-09-11T05:14:36Z | FERDI Alfarizi | ["Flamenco", "Acoustic guitar", "Music", "Strum"] | ["acoustic guitar", "strumming", "open chords", "bird chirping", "quiet male vocals", "singing", "low fidelity", "happy"] | 8 | MPe6ztPtF0Y | 2263 | ||
Sesame Street: Preview: Singing With The Stars DVD | The music features a male voice singing and being accompanied by backing vocals. The drums play a laid-back rhythm and together with the bass guitar drive the pulse of the music. An acoustic guitar is accompanying the singer lightly. In the background one can hear birds chirping and children having fun. The overall atmosphere is uplifting. | 2012-04-24T22:13:13Z | Sesame Street | Enjoy this preview of the all new Singing With The Stars DVD. This DVD includes special guest appearances by Adam Sandler, REM, Destiny's Child, Jason Mraz, Feist and so many more! DVD Available 5/1/2012. Available in the official Sesame Street Store http://store.sesamestreet.org/Product.aspx?cp=21415_21456_21463&pc=6EAM1251 For more fun games and videos for your preschooler in a safe, child-friendly environment, visit us at http://www.sesamestreet.org Sesame Street is a production of Sesame Workshop, a nonprofit educational organization which also produces Pinky Dinky Doo, The Electric Company, and other programs for children around the world. | ["Music", "Happy music"] | ["male voice", "backing vocals", "drums", "bass guitar", "acoustic guitar", "uplifting atmosphere", "bird chirping", "children having fun"] | 2 | Vr7wbGcvFts | 3035 |
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;