musiccaps_details (view)
3 rows where musiccaps_aspects contains "folk song", musiccaps_aspects contains "foreign language" and musiccaps_aspects contains "regional music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 45 ✖
- folk song · 3 ✖
- foreign language · 3 ✖
- regional music · 3 ✖
- happy 2
- male singer 2
- peppy 2
- acordion accompaniment 1
- amateur recording 1
- buoyant 1
- catchy 1
- cheerful 1
- cheering 1
- chirpy 1
- conga 1
- country music 1
- dutch 1
- energetic 1
- enthusiastic 1
- fast tempo 1
- flute melody 1
- folk pop 1
- hand percussion 1
- home video 1
- hooting 1
- inferior audio quality 1
- keyboard harmony 1
- lively trumpets 1
- male vocalist 1
- medium fast tempo 1
- metallic clicking sound 1
- middle eastern music 1
- party songs 1
- people talking 1
- pop 1
- popular songs 1
- rustling 1
- slow tempo 1
- steady bass line 1
- steady drumming 1
- straight bass lines 1
- synthesiser arrangement 1
- upbeat 1
- vocal backup 1
- vocal emphasis 1
- world music 1
musiccaps_names (array) 6 ✖
- Music 2
- Accordion 1
- Music of Africa 1
- Music of Latin America 1
- Singing 1
- Ska 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Shira Choir Rocking it away with Pinky Weber Music by Pinny Ostreicher | A male vocalist sings this spirited song. The tempo is fast with trumpets, keyboard harmony, steady drumming and simple bass lines along with vocal backup. The song is happy, energetic, enthusiastic, popular, peppy, vivacious and celebratory. There are sounds in the background of people talking, hooting, cheering and scuttling and rustling. This is a popular Folk/Regional song. | 2015-09-04T19:04:46Z | Go Jewish Music | At a Siyem in Upstate! | ["Singing", "Music", "Ska", "Music of Latin America"] | ["male singer", "fast tempo", "vocal backup", "popular songs", "hooting", "rustling", "home video", "amateur recording", "party songs", "foreign language", "lively trumpets", "keyboard harmony", "steady drumming", "straight bass lines", "vocal backup", "people talking", "cheering", "energetic", "happy", "enthusiastic", "home video", "inferior audio quality", "folk song", "regional music", "happy", "peppy", "chirpy"] | 7 | 1hABzqBHh7w | 297 | |
Boudewijn de Groot - Verdronken vlinder | A male vocalist sings this passionate song in Dutch. The tempo is slow with vocal emphasis and an accordion harmony. The song is a simple, narrative, slow Folk song. | 2007-08-01T21:46:42Z | Thijs Hanrath | Lied van Boudewijn de groot: verdronken vlinder. A dutch song of Boudewijn de groot about jealousy at a butterfly | ["Accordion"] | ["male singer", "slow tempo", "foreign language", "world music", "country music", "acordion accompaniment", "vocal emphasis", "dutch", "folk song", "pop", "folk pop", "regional music", "metallic clicking sound"] | 7 | 2Q20hVyYjBM | 361 | |
Simo Issaoui 2008 by WWW.TOP2008.NEW.FR**05** | A male vocalist sings this upbeat song in a foreign language. The tempo is medium fast with a very perky and bouncy beat. The song is happy, cheerful, groovy, simple light and catchy with middle eastern music influences. This song is a contemporary Folk song. | 2008-07-17T18:21:13Z | jamalyoussef2010 | Simo issaoui issawi hyooh nachat guercif jamal youssef super_jamal@hotmail.fr | ["Music of Africa", "Music"] | ["male vocalist", "medium fast tempo", "foreign language", "buoyant", "peppy", "happy", "cheerful", "middle eastern music", "upbeat", "catchy", "synthesiser arrangement", "conga", "hand percussion", "steady bass line", "flute melody", "folk song", "regional music"] | 7 | XCQMJXkI5bA | 3166 |
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;