musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "instrumental", musiccaps_aspects contains "live performance" and musiccaps_aspects contains "vibrant"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- bass guitar 2
- instrumental · 2 ✖
- live performance · 2 ✖
- vibrant · 2 ✖
- arabic 1
- cello 1
- eastern sounding 1
- fiddle 1
- fiddle solo 1
- irish folk music 1
- joyful 1
- ney 1
- no singer 1
- orchestra 1
- oud 1
- percussion 1
- playful 1
- profound 1
- qanun 1
- tapping 1
- upbeat 1
- violin 1
musiccaps_names (array) 8 ✖
- Bluegrass 1
- Country 1
- Drum 1
- Music 1
- Musical instrument 1
- Percussion 1
- Tabla 1
- Violin, fiddle 1
youtube_published (date) 2 ✖
- 2006-11-03 1
- 2014-07-23 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
National Arab Orchestra - Nay & Percussion Solos | This is an Arabic music piece being performed live by an orchestra. There is a new flute playing a solo in the lead. The melodic background consists of the violin, the oud, and the qanun while the cello and the bass guitar are playing in the lower range. The rhythmic background is provided by percussive elements that sound like the doumbek. The atmosphere is vibrant. This piece could be used as an opening theme for a drama movie or a TV series that takes place in the Middle East. | 2014-07-23T04:31:30Z | National Arab Orchestra | National Arab Orchestra May 31, 2014 Music Hall Center for the Performing Arts Directed by: Michael Ibrahim Raqsit Badi'a - Mohamed Abdel Wahab Violin: Adel Eskandar, Emad Ibrahim,Nady Benyamine, Katie Vandusen, Eddie Sleiman, Roberto Riggio, Sachi Yoshimoto, Insia Malik, Qusay Al-Ali, Hasan Minawi, Marandi Hostetter. Qanun: Ali Amr. Oud: Victor Ghannam. Cello, Peter Abadier. Nay Michael Ibrahim, Bass: Margaret Hasspacher. Electric Guitar. Percussion: Gurshuran "Yash" Singh Sandhu, Roger Kashou, Adam Maalouf, Dhafir Tawil, Sam Parsons. The NAO is a 501 c3 nonprofit organization. For more information on how you can help the NAO, contact us at info@michiganaraborchestra.org Educational program made possible by the Knight Foundation | ["Tabla", "Drum", "Percussion"] | ["arabic", "live performance", "orchestra", "instrumental", "ney", "violin", "qanun", "oud", "bass guitar", "cello", "percussion", "vibrant", "profound", "eastern sounding"] | 9 | FdvGsAq99r0 | 1658 | |
Irish Country Fiddle Solo 'FinnMacCool' - "Pinch of Snuff" | This is the live performance of an Irish folk music piece. There is no singer. The fiddle is playing an upbeat solo while the bass guitar is playing a complex bass line using the tapping technique. The atmosphere is joyful. This piece could be used in the soundtrack of a documentary that has scenes of rapid movement. | 2006-11-03T14:50:10Z | Adrian Keating Archive - Sydney Lyric Orchestra | Blistering Violin Solo by Mark Oates "Pinch of Snuff" -performed by the Finn McCool band; Greg O'Brian gtr, David "Mad Dog" Warwick mandolin, Mark Oates Violin, Steve Sampson bass, every Sat arvo in the Mercantile Hotel, the Rocks, Sydney. Take them seriously. I do. 4 Cameras, 6 sound sources. Mashed together on my (Adrian K) computer. Check out the other Video's of Sydneys Live Music Scene with me all over them @ http://www.youtube.com/profile?user=musodata http://members.ozemail.com.au/~classblu/ check out another raging violinist mate of ours, http://www.youtube.com/watch?v=L0-UjUto2_8 iancooper.com Tags: irish country jig reel traditional electric violin bass guitar mandolin | ["Country", "Music", "Musical instrument", "Violin, fiddle", "Bluegrass"] | ["irish folk music", "live performance", "no singer", "instrumental", "bass guitar", "tapping", "fiddle", "fiddle solo", "playful", "vibrant", "joyful", "upbeat"] | 9 | qMd2DTyF9EE | 4781 |
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;