musiccaps_details (view)
5 rows where musiccaps_aspects contains "amateur recording" and musiccaps_aspects contains "playful"
This data as json, CSV (advanced)
musiccaps_aspects (array) 40 ✖
- amateur recording · 5 ✖
- playful · 5 ✖
- instrumental 2
- percussion 2
- afrobeat 1
- amadinda 1
- amateur production 1
- bass guitar 1
- beatbox music 1
- cheerful 1
- children’s favourite 1
- cozy 1
- crowd cheering 1
- dance 1
- electronic drums 1
- fast tempo 1
- fun venture 1
- game song cover 1
- game theme song cover 1
- game tune cover 1
- irish flute 1
- irish folk music 1
- joyful 1
- keyboard 1
- male singers 1
- male vocal 1
- medium tempo 1
- no instrumentation 1
- no singer 1
- retro game theme 1
- rolling tongues 1
- single instrument 1
- spitting vocals 1
- tablas 1
- ugandan traditional music 1
- vocal acapella 1
- vocal harmony 1
- vocal mimicry 1
- xylophone 1
- zitar 1
musiccaps_names (array) 10 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Super Mario Beatbox | The song is an acapella cover of a game theme song. The song is medium tempo with no instrumentation by different male vocals engaging in different vocal mimicry of actual instruments, like bass line, melody , percussion and harmony tones. The song is cheerful and amateurish in production. The song is a cover of a popular game theme. | 2006-01-19T03:08:47Z | poizunus | Super Mario audio and sfx re-done by beatboxer Poizunus. For more music from Poizunus, visit the links below. Find http://beatsxpoizun.com/ http://beatsxpoizun.com/hip-hop-beats/ http://producedxpoizun.com/ http://producedxpoizun.com/streaming-hip-hop-and-rap-instrumentals/ Keep up to date with Poizunus on Twitter: https://twitter.com/poizunus | ["Beatboxing", "Music"] | ["beatbox music", "game tune cover", "male singers", "children’s favourite", "retro game theme", "amateur production", "cheerful", "fun venture", "vocal mimicry", "game theme song cover", "vocal harmony", "spitting vocals", "rolling tongues", "playful", "game song cover", "medium tempo", "no instrumentation", "vocal acapella", "cheerful", "amateur recording"] | 1 | 9r01cpNx2vk | 1046 | |
amadinda in kampala | This is an amateur recording of a Ugandan traditional music piece. The piece is instrumental and percussive in nature. The amadinda (which is a Ugandan xylophone) is playing a joyful tune. The atmosphere is playful. | 2011-03-13T17:40:54Z | Philipp Troestl | amadinda playing with albert ssempeke in kampala "naagenda kasana nga bulaba ("we will leave when it is daylight") | ["Wood block", "Percussion"] | ["ugandan traditional music", "instrumental", "percussion", "amadinda", "xylophone", "playful", "joyful", "amateur recording"] | 9 | KY5TY6ovKQg | 2093 | |
The winner of the Best African Music Dancer competition 2012 | This is an amateur recording of an afrobeat piece playing in the background of a dance performance. The piece can be barely heard from the cheering sounds coming from the crowd. The piece has a clear afrobeat rhythm and it is used as an accompaniment for an African dance. | 2012-08-20T22:16:29Z | Motherland Media | Afro Top Star Dancer Competition 2012, Minnesota August 18, 2012, | ["Music of Africa", "Music", "Music of Latin America"] | ["amateur recording", "afrobeat", "dance", "crowd cheering", "male vocal", "bass guitar", "keyboard", "electronic drums", "percussion", "playful"] | 9 | T7bG4kIEw-M | 2813 | |
Low Tin Whistle Morrison's Jig irish flute music | This is an amateur recording of an Irish folk music piece. It is an instrumental piece. There is an Irish flute playing a playful melody in a home setting. The atmosphere is cozy. This piece could be used in the soundtrack of an arcade adventure video game during the parts where the protagonist is traversing through forested areas. | 2007-10-17T13:57:59Z | spennamac | Morrisons Jig played on an Overton low whistle in D low whistle | ["Wind instrument, woodwind instrument", "Flute"] | ["amateur recording", "irish folk music", "no singer", "instrumental", "single instrument", "irish flute", "playful", "cozy"] | 9 | YjTz5y8DnWo | 3307 | |
Nishat Khan & Zakir Hussain in Calcutta - Part 2 | This audio contains someone playing a complex groove on tablas along with someone playing a solo on a zitar with the same complex rhythm. This song may be playing in a live concert having a little solo together with instruments. | 2010-02-18T13:51:36Z | Alexandre de Mortemart | Part 2 of extracts of a concert of Ustad Nishat Khan (Sitar) and Ustad Zakir Hussain (Tablas) held on 9th February 2010 at Kalamandir in Calcutta, India. | ["Tabla", "Drum", "Percussion"] | ["amateur recording", "tablas", "zitar", "fast tempo", "playful"] | 6 | dj-DWiV1z9g | 3809 |
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;