musiccaps_details (view)
2 rows where musiccaps_aspects contains "acoustic guitar", musiccaps_aspects contains "folk song" and musiccaps_aspects contains "violin"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- acoustic guitar · 2 ✖
- folk song · 2 ✖
- violin · 2 ✖
- accordion 1
- amateur recording 1
- bass 1
- instrumental 1
- male voice 1
- moderate tempo 1
- no other instruments 1
- no percussion 1
- no voices 1
- romantic feel 1
- shaker 1
- waltz 1
musiccaps_names (array) 6 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Derick Mar09 Irish Heartbeat | This folk song features a male voice singing the main melody. This is accompanied by an acoustic guitar. A shaker plays in place of the percussion. Violins play a melody in the background. The mood of this song is romantic. This song can be played in a flashback scene of a movie. | 2009-04-10T22:33:44Z | Ken Persson | Copyright music and lyrics reproduced by kind permission of Exile for original, exclusive performances by Van Morison, check-out the official channel at www.youtube.com/officialexilefilms. Recorded at a practice of Irish Street for a St Patrick's Day performance at Muldoon's. From L to R, Eileen, bodhran, Derick, vocals & guitar, Margaret, accordion, Brendan, fiddle, and Ken, whistle. | ["Acoustic guitar", "Music", "Steel guitar, slide guitar", "Strum", "Bluegrass"] | ["amateur recording", "acoustic guitar", "male voice", "shaker", "violin", "folk song", "romantic feel", "moderate tempo"] | 0 | etmmUjsRNRs | 3903 | |
Б.Тихонов вальс "Пушинка" | This folk song features a quarter. The main melody starts off with the accordion playing an ascending run. This is accompanied by the bass playing the root and fifth of the chords. An acoustic guitar strums chords in waltz time. After the accordion part, the violin plays the main melody and the same instruments back the violin. This song can be played in a village fair. | 2010-05-26T14:23:55Z | Сергей Боганов | Концерт в К/З МГИМ им. Шнитке 27.11.09г.: "Emotion Orchestra" под руководством Ю.Медяника | ["Accordion"] | ["folk song", "waltz", "no voices", "instrumental", "violin", "accordion", "bass", "acoustic guitar", "no percussion", "no other instruments"] | 0 | pDgWT99uaJ0 | 4691 |
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;