musiccaps_details (view)
3 rows where musiccaps_aspects contains "percussive bass line" and musiccaps_aspects contains "tambourine percussions"
This data as json, CSV (advanced)
musiccaps_aspects (array) 49 ✖
- percussive bass line · 3 ✖
- tambourine percussions · 3 ✖
- bad audio quality 2
- passionate 2
- people dancing 2
- adrenaline rush 1
- arabic dance hits 1
- arabic dance music 1
- arabic folk song 1
- arabic music 1
- arabic percussion instruments 1
- backup singers 1
- beeping tones 1
- christian contemporary music 1
- church service 1
- congregational music 1
- dance groove 1
- dance rhythm 1
- desert sands 1
- energetic 1
- excitement 1
- fast tempo 1
- fats tempo 1
- folk music influences 1
- gospel band 1
- groovy music 1
- grunge keyboard tones 1
- hissing tones 1
- hymns 1
- instrumental music 1
- male rapper 1
- male singer 1
- meditational 1
- medium tempo 1
- organ accompaniment 1
- piano acc 1
- poor audio quality 1
- praise and worship 1
- prayers 1
- rap hits 1
- rejoicing 1
- retro rap hits 1
- singing 1
- steady drumming rhythm 1
- story telling 1
- strong drumming rhythm 1
- traditional dance music 1
- vocal harmony 1
- wind instrument 1
musiccaps_names (array) 5 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Kai - Grind Low | A male rapper sings this exciting melody. The tempo is fast with a groovy bass line, grunge keyboard tones, strong drumming rhythm, various percussion hits and beeping tones. The song is pulsating and energetic. The audio quality is very poor. | 2008-03-06T13:46:34Z | kilickai | ["Music", "Rapping"] | ["male rapper", "poor audio quality", "beeping tones", "fast tempo", "people dancing", "retro rap hits", "tambourine percussions", "strong drumming rhythm", "percussive bass line", "story telling", "adrenaline rush", "passionate", "energetic", "excitement", "dance rhythm", "dance groove", "fats tempo", "poor audio quality", "rap hits", "grunge keyboard tones"] | 1 | 9STauy5DsC8 | 1009 | ||
Wahraïniate Cheikha Zalamite | The song is an instrumental. The tempo is medium with a percussive Arabic percussion groove, tambourine percussions, percussive bass line and a ethnic wind instrument playing an enthusiastic solo. The song has folk music influences and reminds us of a desert journey. The song audio quality is very poor. | 2013-03-02T12:47:47Z | WahranRai | Cheikha Zalamite, une belle voix Blues Raï de Saïda (Ouest algérien). Cheikha Zalamite me fait penser à cette grande dame du bédoui algérien Cheikha Djénia (Paix à son âme). Elle nous interprète ... Hanini ou n'hanik / Laisse moi tranquille et je te laisserai tranquille... La région de Saïda (Algérie) est connue par ses grands chanteurs, Chioukhs et cheikhates (Mami, Cheikha Djénia, Cheb Aïssa...). Zalamite est l'arabisation du mot Les allumettes. Hommage à Cheikha Zalamite et aux Chioukhs et Cheikhates de l' Ouest algérien. Wahran Raï / Oran Rai. | ["Music", "Rattle (instrument)"] | ["arabic music", "instrumental music", "people dancing", "folk music influences", "passionate", "traditional dance music", "arabic percussion instruments", "tambourine percussions", "groovy music", "percussive bass line", "hissing tones", "arabic folk song", "arabic dance music", "desert sands", "singing", "people dancing", "arabic dance hits", "wind instrument", "bad audio quality"] | 1 | eXrJL1VUQNE | 3876 | |
Gospel Music - Because He Lives!! | A male singer leads backup singers into a gospel song in vocal harmony. The tempo is medium with a groovy bass line , organ accompaniment, tambourine percussion, guitar strumming and keyboard accompaniment. The song is prayerful and spirited. The song has bad audio quality. | 2007-10-06T00:34:24Z | Leah274 | Im not sure who is actually singing, i know the original guy is in the start then its another guy, i like this version. | ["Gospel music", "Christian music", "Music"] | ["male singer", "backup singers", "vocal harmony", "medium tempo", "percussive bass line", "tambourine percussions", "christian contemporary music", "praise and worship", "meditational", "congregational music", "hymns", "prayers", "rejoicing", "bad audio quality", "organ accompaniment", "gospel band", "church service", "steady drumming rhythm", "piano acc"] | 1 | wPmTJWybq_E | 5263 |
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;