musiccaps_details (view)
4 rows where musiccaps_aspects contains "no other instruments" and musiccaps_names contains "Flute"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- no other instruments · 4 ✖
- no voices 4
- instrumental 3
- moderate tempo 2
- slow tempo 2
- amateur recording 1
- bamboo flute song 1
- cello 1
- classical music 1
- flute 1
- flute music 1
- folk melody 1
- high pitch sound 1
- middle eastern flute 1
- middle-eastern melody 1
- romantic mood 1
musiccaps_names (array) 2 ✖
- Flute · 4 ✖
- Wind instrument, woodwind instrument 4
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Galway Spirit | This song features a flute being played at a high pitch. The melody is of a folk song. There are no other instruments in this song. There are no voices in this song. This song can be played in an animation movie featuring a person skipping in a forest. | 2010-03-19T20:39:03Z | galwaybentgenvideo | Sir James Galway demonstrates the new Conn-Selmer "Galway Spirit" Flute --designed by Sir James Galway & Conn-Selmer | ["Wind instrument, woodwind instrument", "Flute"] | ["flute music", "folk melody", "no other instruments", "no voices", "high pitch sound", "moderate tempo"] | 0 | 8tY6nioUQIw | 958 | |
عتابه حزينه تموت | 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 | |
Marin Marais Les Folies d'Espagne pour flûte et violoncelle | This song features a flute playing the main melody. The flute plays staccato notes and allows only the last note to be sustained. This is accompanied by a cello playing the same melody in the lower register. There are no voices in this song. This song is an instrumental. This folk song features no other instruments. This song can be played in an animation movie featuring fairies. | 2011-04-07T21:54:26Z | susancello | Duo à Cord'Air Nathalie Lourties Flûte Susan Edward Violoncelle En concert le 3 avril 2011 à Salle Cuzin, Auch www.acordair.com | ["Wind instrument, woodwind instrument", "Flute"] | ["classical music", "flute", "cello", "no other instruments", "no voices", "instrumental", "moderate tempo"] | 0 | dUlQepCYXgw | 3793 | |
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 |
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;