musiccaps_details (view)
3 rows where musiccaps_aspects contains "accordion" and musiccaps_aspects contains "happy mood"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- accordion · 3 ✖
- happy mood · 3 ✖
- flute 2
- instrumental 2
- no voice 2
- acoustic drums 1
- bass 1
- children's song 1
- croaking sound 1
- double base 1
- e-bass 1
- folk song 1
- folksong 1
- hammered dulcimer 1
- medium to uptempo 1
- moderate tempo 1
- no voices 1
- percussion 1
- quirky sounds 1
- slow tempo 1
- violin 1
- xylophone family instrument 1
musiccaps_names (array) 5 ✖
youtube_published (date) 3 ✖
- 2007-10-29 1
- 2009-11-07 1
- 2013-04-30 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Banjo-Tooie Music: Glitter Gulch Mine | This children's song features an accordion playing chords. This is accompanied by percussion playing a simple beat. The bass plays the root notes of the chords. An instrument like the xylophone plays the main melody on the low frequencies. There are no voices in this song. This song is an instrumental. The mood of this song is happy. This song can be played in a children's animation series. | 2007-10-29T03:32:40Z | southernpickle | The theme to Glitter Gulch Mine from the game Banjo-Tooie. | ["Music", "Tender music"] | ["children's song", "quirky sounds", "percussion", "bass", "happy mood", "accordion", "croaking sound", "slow tempo", "instrumental", "no voice", "xylophone family instrument"] | 0 | 2UnlMwW8nyI | 372 | |
Clip #4 Walter Eriksson , Hasse Tellemar " Lörda mé Larssons " SWEDISH TV | This song contains acoustic drums playing together with an e-bass. An accordion is playing the main melody together with a flute playing in a higher register. This song may be playing while waiting in line for a phone call. | 2009-11-07T17:35:31Z | Scandinavian Echoes | www.WalterEriksson.com - Walter Eriksson , Hasse Telemar , Kjell Wigren " Lorda Me Larssons " SWEDISH TV | ["Accordion"] | ["folksong", "accordion", "acoustic drums", "e-bass", "flute", "medium to uptempo", "happy mood"] | 6 | dCCh6POPUeA | 3769 | |
Sile de la Cernica, Marius Turneanu, Cezar Cazanoi - Hora re minor | This folk song features a variety of instruments. The main melody is played on a violin, flute and accordion. The double bass plays a running bass pattern. An acoustic guitar strums chords. A hammered dulcimer plays parts that give a percussive feel. There are no voices in this song. This is an instrumental song. This song can be played in a luxurious and lively brunch. | 2013-04-30T22:01:22Z | Ionascu George Florian | Sile de la Cernica, Marius Turneanu, Cezar Căzănoi, George Miu, Marius Gore, Victor de la Tr. Severin | ["Traditional music", "Music", "Musical instrument", "Accordion"] | ["folk song", "accordion", "violin", "double base", "flute", "hammered dulcimer", "no voices", "instrumental", "no voice", "moderate tempo", "happy mood"] | 0 | u68Ghaf_Phs | 5089 |
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;