musiccaps_details (view)
2 rows where musiccaps_aspects contains "beatboxing" and musiccaps_aspects contains "instrumental"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- beatboxing · 2 ✖
- instrumental · 2 ✖
- amateur beat boxer 1
- analog sounding 1
- bad beat boxing 1
- beatboxing failed attempt 1
- cheerful 1
- female voice speaking 1
- funny 1
- groovy 1
- medium tempo 1
- no singer 1
- playful 1
- small keyboard 1
- video game theme 1
- vocal percussion 1
musiccaps_names (array) 5 ✖
- Beatboxing 2
- Music 1
- Soundtrack music 1
- Speech 1
- Vocal music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Wii Music - Super Mario Bros feat. Beatboxing Jesus | This is a video game theme cover. The theme belongs to the Super Mario franchise. The main theme is being played on an analog sounding small keyboard. There is an added rhythmic background of beatboxing in this version. The atmosphere is playful. This piece could be used in the background of arcade gaming social media content. | 2009-05-06T19:15:34Z | Blozcot | The four presidential and vice presidential candidates perform the Super Mario Bros theme on their NES Horns, while a special guest brings down the beat! Credits: Me, Jesus | ["Beatboxing", "Music", "Soundtrack music"] | ["video game theme", "no singer", "instrumental", "analog sounding", "small keyboard", "beatboxing", "playful", "cheerful", "groovy"] | 9 | GiTmjE7az74 | 1748 | |
bu çocuk muhteşem | This clip is an amateur attempt at beatboxing. The tempo is medium and the beat is Catchy but it is a failed attempt at imitating digital drums. There is a female voice speaking in foreign language. | 2007-06-20T07:36:43Z | vefa82 | komik,kozanli,akp,korku,eğlence,oyun, | ["Beatboxing", "Speech", "Vocal music"] | ["instrumental", "medium tempo", "beatboxing", "vocal percussion", "amateur beat boxer", "funny", "female voice speaking", "beatboxing failed attempt", "bad beat boxing"] | 7 | j4A1ObGurUk | 4233 |
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;