musiccaps_details (view)
5 rows where musiccaps_aspects contains "instrumental", musiccaps_aspects contains "no other instruments", musiccaps_aspects contains "slow tempo" and musiccaps_names contains "Wind instrument, woodwind instrument"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
שופרות בחופה מיקרופון אלחוטי | This song features a synth playing the rhythm section using a piano tone. The shofar plays a tremulous note. There is no percussion in this song. The mood of this song is melancholic. There are no other instruments in this song. There is no voice in this song. This song can be used in a romantic movie. | 2010-12-06T03:19:53Z | Roki Balboa | שופרות בחופה פתיחת טקס החופה בתקיעת שופר בחיבור של מיקרופון אלחוטי ביצוע: נועם ביט www.justbeat.co.ill 050-5151518 | ["Wind instrument, woodwind instrument", "Shofar"] | ["synth song", "shofar", "piano tone", "melancholic feel", "slow tempo", "no percussion", "no voice", "no other instruments", "instrumental"] | 0 | 3PoC1-xd4Yw | 463 | |
SHOFAR IN THE DESERT | This song features a shofar playing the main melody. This is accompanied by a synth playing chords in the background. There are no other instruments in this song. There are no voices in this song. This song can be played in a sad scene in a movie. | 2007-09-27T07:25:37Z | essnerhaim | SHOFAR IN THE DESERT ARIK DAVIDOFF UZI$HAIM ESSNER | ["Wind instrument, woodwind instrument", "Shofar"] | ["shofar song", "synth sounds", "no other instruments", "no percussion", "no voice", "instrumental", "slow tempo", "sad melody"] | 0 | 7YWMPBHKdyY | 856 | |
عتابه حزينه تموت | This song features a middle-eastern melody played on a flute. This song has no other instruments. There are no voices in this song. This is an amateur recording. This song can be played at a desert party. | 2015-07-25T07:17:39Z | امير كركوك | عتابه ونايل حزين يموت | ["Wind instrument, woodwind instrument", "Flute"] | ["middle eastern flute", "no other instruments", "no voices", "instrumental", "amateur recording", "middle-eastern melody", "slow tempo"] | 0 | Ki7Bxz1CThI | 2108 | |
Types and Range of Dizi (Chinese Bamboo Flute) - Part 4 | This song is played on the bamboo flute. The melody is simple and traditional. The sound is tremulous. There are no other instruments in this song. There are no voices in this song. This song can be played in a children's kung fu animation movie. | 2009-02-17T08:14:46Z | Eason Music Pte Ltd | A video that introduces the various types and pitch ranges of the Dizi (Chinese Bamboo Flute). The final part (Part 4) talks about the Da Di/ Xin Di. To see our range of dizis, go to: http://www.easonmusicstore.com/catego... To purchase dizi accessories, go to: http://www.easonmusicstore.com/catego... | ["Wind instrument, woodwind instrument", "Flute"] | ["bamboo flute song", "instrumental", "no voices", "no other instruments", "romantic mood", "slow tempo"] | 0 | rVdI-aD9pq8 | 4881 | |
SGPB Sleeping Tune.mpg | This song features a synth playing the main melody. The synth plays a heavenly voice with a pad like backing. There are no other instruments in this song. There is no voice in this song. The mood of this song is relaxing. This song can be played in a meditation center. | 2010-03-06T18:33:49Z | gwwoodworth | Bagpipe concert 3/5/10 | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["synth song", "no other instruments", "no percussion", "no voices", "instrumental", "slow tempo", "relaxing song", "meditation song"] | 0 | w0yHqPxybQE | 5230 |
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;