musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "live performance", musiccaps_aspects contains "low quality" and musiccaps_names contains "Traditional music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 28 ✖
- live performance · 4 ✖
- low quality · 4 ✖
- noisy 3
- folk 2
- sitar guitar melody 2
- traditional 2
- accordion melody 1
- boomy bass 1
- clapping 1
- compressed 1
- crowd chattering 1
- electric guitar melody 1
- flute solo melody 1
- groovy 1
- groovy bass 1
- groovy percussive elements 1
- instrumental 1
- loud 1
- messy 1
- mono 1
- muddy 1
- passionate 1
- punchy snare 1
- shimmering bells melody 1
- shimmering hi hats 1
- steel guitar melody 1
- sustained strings melody 1
- wooden percussive instruments 1
musiccaps_names (array) 10 ✖
- Music 4
- Traditional music · 4 ✖
- Accordion 1
- Flamenco 1
- Music of Latin America 1
- Musical instrument 1
- Orchestra 1
- Singing 1
- Speech 1
- Vibraphone 1
youtube_published (date) 4 ✖
- 2008-07-21 1
- 2009-07-03 1
- 2011-06-16 1
- 2015-01-07 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Bulaklakan Dance - FJCC 2010 Israel Rejoicing | The low quality recording features a live performance of an instrumental folk song that contains sitar guitar melody and boomy bass. There are some background clapping sounds, probably from a crowd, by which we can conclude that it is in fact a live performance. It sounds like it was recorded with a phone. | 2011-06-16T07:27:53Z | redford bartolome | Adult dancers of the Friends of Jesus Christ Canada dancing Filipino Folk dance Bulaklakan at the 2010 Israel Rejoicing celebration at Earl Bales Park | ["Traditional music", "Music"] | ["folk", "sitar guitar melody", "boomy bass", "traditional", "clapping", "noisy", "low quality", "live performance", "instrumental"] | 4 | 9A4VNkMdwhk | 979 | |
Samuel Rossi Orchestra Ringo Story Goleada polka | The low quality recording features a live performance of a folk song that consists of an accordion melody playing over groovy bass, shimmering hi hats, punchy snare and electric guitar melody. There are crowd chattering noises in the background. It sounds passionate and groovy. | 2009-07-03T12:40:13Z | Tuttofisa | Samuel Rossi Orchestra Ringo Story Goleada polka | ["Singing", "Traditional music", "Music", "Musical instrument", "Orchestra", "Speech", "Music of Latin America", "Accordion"] | ["low quality", "live performance", "crowd chattering", "folk", "groovy bass", "accordion melody", "electric guitar melody", "shimmering hi hats", "punchy snare", "passionate", "groovy"] | 4 | ChqJYrmQIN4 | 1394 | |
Palestinian Traditional Music @ GlobalCAFE | The low quality recording features a live performance of percussive elements, sitar guitar melody, sustained strings melody, groovy percussive elements and flute solo melody. The recording is noisy and it sounds compressed and loud. | 2008-07-21T00:38:40Z | Bevin Ginder | Enjoy some Palestinian music from Bethlehem featuring the Oud, the Darbuka and a type of flute.GlobalCAFE is a travel video podcast celebrating people, places, & purpose... join the EPIC! Subscribe to GlobalCAFE for free. | ["Traditional music", "Flamenco", "Music"] | ["low quality", "live performance", "groovy percussive elements", "sitar guitar melody", "sustained strings melody", "flute solo melody", "noisy", "compressed", "loud"] | 4 | hQ5OBio4Cy0 | 4102 | |
ระบำทวารวดี โดย วนศ. สุพรรณบุรี Thai traditional music. Dvaravati ensemble. Dvaravati dance | The low quality recording features a live performance of a traditional song that consists of wooden percussive instruments, steel guitar melody and shimmering bells melody. The recording is in mono and it sounds really noisy, messy and muddy, since the frequencies of the instruments are clashing with each other. | 2015-01-07T10:14:32Z | pantumburi | บรรเลงโดยนักเรียนวิชาเอกเครื่องสาย วิทยาลัยนาฏศิลปสุพรรณบุรี เชิญรับฟัง เพลงระบำทวารวดี เราซ้อมกันเป็นร้อยรอบครับ....คงไม่ดีไปกว่านี้แล้วแหระ.....คือตั้งใจมากๆ แต่ได้แค่นี้จริงๆ....ปล. แนวทางการบรรเลงครั้งนี้ เป็นการรื้อฟื้นแนวการบรรเลงอย่างที่ครูประสิทธิ์ ถาวร บันทึกเสียงไว้ครั้งแรก....ก่อนจะปรับอีกครั้งเป็นเวอร์ที่สองครับ....แต่ส่วนตัวชอบอย่างแรกมากกว่า วันนี้ถึงทำไม่ดีเท่า ก็ขอเอาแค่กลิ่นๆ พอครับ...ตามความสามารถของเด็กๆ | ["Traditional music", "Music", "Vibraphone"] | ["low quality", "live performance", "noisy", "wooden percussive instruments", "steel guitar melody", "shimmering bells melody", "mono", "traditional", "muddy", "messy"] | 4 | wFTlySgdWX4 | 5251 |
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;