musiccaps_details (view)
2 rows where musiccaps_aspects contains "moderate tempo" and musiccaps_names contains "Flute"
This data as json, CSV (advanced)
musiccaps_aspects (array) 10 ✖
- moderate tempo · 2 ✖
- no other instruments 2
- no voices 2
- cello 1
- classical music 1
- flute 1
- flute music 1
- folk melody 1
- high pitch sound 1
- instrumental 1
musiccaps_names (array) 2 ✖
- Flute · 2 ✖
- Wind instrument, woodwind instrument 2
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 | |
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 |
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;