musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "vibrant" and musiccaps_names contains "Accordion" sorted by musiccaps_aspects
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 25 ✖
- lively 3
- vibrant · 3 ✖
- accordion 2
- bass guitar 2
- instrumental 2
- acordion harmony 1
- acoustic drums 1
- acoustic guitar 1
- acoustic guitar accompaniment 1
- cheerful 1
- energetic 1
- enthusiastic 1
- flute 1
- folk dance 1
- folk music 1
- happy 1
- live performance 1
- male voice 1
- medium fast tempo 1
- mexican folk music 1
- no singer 1
- percussion 1
- punjabi film music 1
- shouting 1
- warm 1
musiccaps_names (array) 3 ✖
- Accordion · 3 ✖
- Flute 1
- Wind instrument, woodwind instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects ▼ | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Prieta Linda "Adrian Duran y Fred Mancilla" | This song is a lively instrumental. The tempo is medium fast with an enthusiastic accordion harmony and acoustic guitar accompaniment. The music is spirited, melodious, warm, cheerful, happy, vivacious and colourful. This music is a Folk song instrumental. | 2011-07-20T01:59:52Z | chikiturris1 | para contractiones # (714) 579-9074 Chubbz # (909) 277- 8651 Nanas | ["Accordion"] | ["instrumental", "medium fast tempo", "acordion harmony", "acoustic guitar accompaniment", "lively", "cheerful", "happy", "warm", "enthusiastic", "energetic", "vibrant", "folk music"] | 7 | 6dFCMXNlmzQ | 773 | |
EL ORIGINAL DE LA SIERRA "LA DESVELADA" | This is a Mexican folk music piece being performed live. There is male voice shouting at the end of the piece. The accordion is playing the main melody. The acoustic guitar and the bass guitar are playing in the background. The rhythmic background consists of a latin acoustic drum beat. The atmosphere is lively. This piece could be playing in the background at a Mexican restaurant. | 2009-10-14T02:38:05Z | FRONTERAVISUAL09 | MUSICAL EN BILLBOARD | ["Accordion"] | ["mexican folk music", "live performance", "male voice", "shouting", "accordion", "bass guitar", "acoustic guitar", "acoustic drums", "lively", "vibrant"] | 9 | XOsHEjo-RSg | 3181 | |
Channa Sachi Muchi [Full Song] Channa Sachi Muchi | This is a Punjabi film music piece. At first, the melody is being played by the accordion. Then, it is being played by the flute. In the background, a bass guitar is playing. The rhythm is provided by the percussion. The atmosphere is vibrant. This piece could be used as an accompaniment piece for a folk dance course. | 2011-05-17T00:20:26Z | T-Series | Song - Channa Sachi Muchi Film - Channa Sachi Muchi Singer - Miss Pooja Lyricist - Romi Tahli Music Director - Jassi Bros. Artist - Miss Pooja, Goldy Sumal, Jas Dhillon, Rana Ranbir Music On - T-Series | ["Wind instrument, woodwind instrument", "Flute", "Accordion"] | ["punjabi film music", "no singer", "instrumental", "accordion", "flute", "bass guitar", "percussion", "vibrant", "lively", "folk dance"] | 9 | eWSA0xubW7I | 3871 |
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;