musiccaps_details (view)
3 rows where musiccaps_aspects contains "bells" and musiccaps_aspects contains "percussion" sorted by musiccaps_caption
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- bells · 3 ✖
- percussion · 3 ✖
- amateur recording 1
- cheerful 1
- christmas 1
- cymbals 1
- electronic drums 1
- female vocals 1
- festive 1
- gongs 1
- instrumental 1
- joyful 1
- lighthearted 1
- lomba gong 1
- marimba 1
- melodic singing 1
- orchestra 1
- original pilipino music 1
- playful 1
- remix 1
- strings 1
- timpani 1
- traditional string instrument 1
musiccaps_names (array) 7 ✖
video | youtube_link | musiccaps_caption ▼ | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Lomba Gong Kebyar Pria Dewasa 2010 | Someone is splaying a series of bell sounds and a big gong hit that rings out for a long time. Wild percussive hits are being played for a moment. Then a traditional string instrument takes over playing a single long note with a bow and a lot of vibrato. This is an amateur recording and of poor audio-quality. This song may be playing in a traditional festival. | 2011-09-14T21:37:44Z | Pande Cannel | Budaya Kerawitan dalam rangka memperingati hari Jadi kota kabupaten Badung Mangupura bulan September 2010 | ["Music", "Middle Eastern music"] | ["lomba gong", "traditional string instrument", "gongs", "percussion", "bells", "amateur recording"] | 6 | Hg4f2xt3oKA | 1827 | |
雪灯籠 白虎 | This is an instrumental percussion piece performed by an orchestra. There is a marimba playing the main melody at the forefront while bell percussion adds texture around it. There is a timpani that plays a loud drum line that is accentuated by occasional cymbal hits. The atmosphere is lighthearted. This piece would fit perfectly in the soundtrack of an arcade video game. | 2009-09-20T13:55:29Z | hiratama1995 | 打楽器五重奏です。ニコニコより転送。 | ["Timpani", "Music", "Percussion"] | ["percussion", "orchestra", "instrumental", "marimba", "cymbals", "timpani", "bells", "playful", "joyful", "lighthearted"] | 9 | lTuEsrVV6Uw | 4403 | |
opm christmas song (megamix) ft.dj klu - part 2 | This is the remix of an Original Pilipino Music (OPM) Christmas song. The female vocalist is singing melodically and in a festive manner. The melody is being played by a strings section while the rhythm consists of an electronic drum beat with heavy usage of percussive elements. The atmosphere is cheerful. This piece could be played at Christmas events in the Philippines. | 2009-09-11T06:15:35Z | edwell143 | wala lang trip lang to.ramdam ko kasi pasko na..advance merry christmas sa inyong lahat... | ["Christmas music", "Music of Asia", "Christian music", "Music"] | ["original pilipino music", "christmas", "remix", "female vocals", "melodic singing", "electronic drums", "percussion", "bells", "strings", "festive", "cheerful"] | 9 | lZavPVn7O4Q | 4409 |
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;