musiccaps_details (view)
2 rows where musiccaps_aspects contains "clapping" and musiccaps_aspects contains "e-bass"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- acoustic drums 2
- clapping · 2 ✖
- e-bass · 2 ✖
- amateur production 1
- cheerful vibe 1
- cowbell 1
- e-piano 1
- gospel/blues 1
- loud 1
- mixed voices singing 1
- saxophone 1
- solo male singer 1
- soul/jazz 1
- tambourine 1
- trumpet 1
- uplifting mood 1
- uptempo 1
- voices cheering 1
musiccaps_names (array) 3 ✖
- Music 2
- Jazz 1
- Tambourine 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Now THIS is how you play a tambourine!!!! | Due to the sound quality and background cheering it can be assumed that this is a phone recorded audiofile. A male loud voice is singing a gospel song through a microphone that is overdriving through the speakers: He is accompanied by a tambourine, clapping and cheering from people while acoustic drums are backing him up. In the background you can hear an e-bass playing some licks as fill-ins. This song could be played in a gospel church or a disney movie. | 2010-06-15T01:14:37Z | Michael S. Fitts | A woman really gets into her tambourine praise when The Birmingham Community Mass Choir of the Gospel Music Workshop of America along with SEM MUSIC PRODUCTIONS presents Mr. Daryl Coley at the Mount Moriah Baptist Church where Dr. Bernard Williams Sr. is pastor. | ["Music", "Tambourine"] | ["gospel/blues", "tambourine", "solo male singer", "voices cheering", "acoustic drums", "clapping", "e-bass", "amateur production", "loud", "uplifting mood"] | 6 | Jcd63Ev7JXA | 2024 | |
Incognito - Nights Over Egypt (Live) | This song contains an acoustic drum-set holding the groove and changing his beat after a fill-in to a four on the floor with a kick on every beat. Mixed voices are singing a soulful sounding melody then an e-piano takes over playing a melody before a trumpet and a saxophone come in playing a loud melody. In the background you can hear percussion such as a cowbell being panned to the right side of the speakers. The crowd is cheering and clapping along. This song may be playing at a live concert. | 2006-06-12T01:23:49Z | Marcelo Kalef | Incognito plays "Nights Over Egypt" live in Seoul. | ["Jazz", "Music"] | ["soul/jazz", "e-piano", "acoustic drums", "mixed voices singing", "cowbell", "trumpet", "saxophone", "e-bass", "clapping", "uptempo", "cheerful vibe"] | 6 | UoxHwOl2gN0 | 2946 |
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;