musiccaps_details (view)
4 rows where musiccaps_aspects contains "moderate tempo", musiccaps_aspects contains "no other instruments", musiccaps_aspects contains "no voices" 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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Heart of Gold - Neil Young cover with harmonica | This folk song features a harmonica playing the main melody. The harmonica plays three descending notes. This is followed by a double stop being played a total of nine times in groupings of two, three, three and one time. Then it plays a higher note going down a descending scale of two more notes. This is accompanied by an acoustic guitar strumming chords. The mood of this song is sad. This song can be played at a house party. | 2007-06-22T22:38:17Z | mynamesche | **TUTORIAL IN RESPONSES** There are sixty million covers of heart of gold on youtube so I thought i'd add sixty million and one. Such a great, simple pop song from an amazing man who has pumped out so much amazing music over the years. Unfortunately no Linda Ronstadt and James Taylor on backing vocals but hey there's a wee bit o' harp in there at least. Please be careful if you're wearing headphones, i almost blew my ears up listening back to this and the harmonica came through like a sonic laser into my ear drum. | ["Harmonica", "Wind instrument, woodwind instrument"] | ["folk song", "acoustic song", "harmonica", "no voices", "no other instruments", "instrumental", "no percussion", "sad melody", "moderate tempo"] | 0 | XdBf_omYIO4 | 3203 | |
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 | |
Guitar Harmonica WildWood Flower Folk music Country rack blues | This folk song features a harmonica playing the main melody. This is accompanied by an acoustic guitar strumming chords. There are no other instruments in this song. This is an instrumental song. There are no voices in this song. The mood of this song is upbeat and happy. This song can be played in a movie scene involving a highway drive. | 2008-06-01T07:49:24Z | Matthew Shelton | http://harmonicasuperstart.com/ Guitar and Harmonica simultaneously played: WildWood Flower Folk to Country styles, same song, 1 harmonica, two different keys. Go to HarmonicaSuperStart.com for more great info on playing the harmonica | ["Harmonica", "Wind instrument, woodwind instrument"] | ["harmonica", "acoustic guitar", "country song", "folk song", "no voices", "instrumental", "no percussion", "no other instruments", "moderate tempo", "upbeat"] | 0 | fWfQxB2pVrc | 3952 |
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;