musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "emotional" and musiccaps_names contains "Accordion" sorted by musiccaps_rowid
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- emotional · 2 ✖
- accordion harmony 1
- accordion players 1
- accordion virtuosos 1
- acordian harmony 1
- ambient sounds 1
- bad audio quality 1
- blues 1
- chaotic harmonies 1
- cheerful 1
- fast tempo 1
- folk music 1
- foreign language 1
- groovy music 1
- guitar strumming 1
- gypsy music 1
- happy 1
- improvisational music 1
- inferior audio quality 1
- instrumental music 1
- live music 1
- live performance 1
- lively 1
- loud 1
- loud ambient room noise 1
- male harmony 1
- male singers 1
- medium fast tempo 1
- passionate singing 1
- percussions playing rhythmically 1
- rhythmic acoustic guitar 1
- spirited exciting 1
- three part harmony 1
- upbeat 1
- walking bass style 1
musiccaps_names (array) 4 ✖
- Accordion · 2 ✖
- Music 2
- Musical instrument 2
- Traditional music 2
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid ▼ |
---|---|---|---|---|---|---|---|---|---|---|
Cel ce legi rani care dor-grup burla&horodnic | A group of male vocalists sing this charming melody in a foreign language. The tempo is fast with accordion lead music and acoustic guitar accompaniment. The song is lively, happy, light , warm, cheerful and charming . The audio quality is inferior as it seems to be an amateur home recording with ambient sounds. This Song is a Folk song. | 2011-11-13T02:38:31Z | dorin juravle | Dorin Gach, Dorin Medrihan, Valy Motac, Florin Motac, Danut Covali, Cornel Mihalescu | ["Traditional music", "Music", "Musical instrument", "Accordion"] | ["male singers", "male harmony", "fast tempo", "rhythmic acoustic guitar", "acordian harmony", "lively", "loud", "folk music", "emotional", "passionate singing", "three part harmony", "live performance", "ambient sounds", "inferior audio quality", "cheerful", "upbeat", "happy", "foreign language"] | 7 | QHCHK-NPO_U | 2607 | |
Taraful George Ness & Costel de la Bolintin 1.mp4 | The song is an instrumental. The tempo is medium fast with three accordions playing in harmony and virtuoso style , guitar strumming and other percussion instruments. The song is highly improvisational and has a bad audio quality with ambient room noises. | 2011-11-23T21:01:09Z | Taraful George Ness | tel :0768 174 804 George Ness | ["Traditional music", "Music", "Musical instrument", "Accordion"] | ["live music", "accordion players", "accordion harmony", "percussions playing rhythmically", "blues", "guitar strumming", "chaotic harmonies", "loud ambient room noise", "bad audio quality", "medium fast tempo", "walking bass style", "groovy music", "gypsy music", "improvisational music", "emotional", "spirited exciting", "instrumental music", "accordion virtuosos"] | 1 | t6XtW3SHQNE | 5006 |
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;