musiccaps_details (view)

3 rows where musiccaps_aspects contains "electric guitar", musiccaps_author = 9 and musiccaps_names contains "Tambourine"

✎ View and edit SQL

This data as json, CSV (advanced)

video youtube_link musiccaps_caption youtube_published youtube_channel youtube_description musiccaps_names musiccaps_aspects musiccaps_author youtube_id musiccaps_rowid
Tambourine Dancers, Adonai Choros - GMIM Bukit Zaitun Manado - Indonesia .3GP This piece is a live performance of dancers playing the tambourine over a rock music piece in the background. The background piece has a female vocal and an electric guitar both in the major scale. A loud drum backing can also be heard. 2012-07-09T15:27:25Z Monita Watuseke Adonai Choros Team (tambourine dancers) - Manado, Indonesia festival Rebana dan Banners di Eklesia Taas Manado, Indonesia tahun 2012, dengan Lagu Raja Pemenang - Trueworshiper ["Music", "Tambourine"] ["tambourine", "rock", "electric guitar", "female vocal", "drums", "dance", "live performance"] 9 U6aLiMIlqCc 2888
Tambourine Dance "God is Awesome" (Eksilah Dance Team) This is a gospel piece used as an accompaniment to a tambourine dance. There is a female vocalist singing. There is an electric guitar and a xylophone playing the melody. The tune is not very clear due to the quality of the recording. The atmosphere is religious. Samples could be lifted from this recording to be used in a beat. 2013-07-07T13:03:26Z Eksilah Danceteam Tambourine Dance Presentation by Eksilah Dance Team during the 70th Anniversary Celebration of Chinese Christian Church Hatyai. July 6, 2013 ["Music", "Tambourine", "Salsa music"] ["tambourine dance", "gospel", "electric guitar", "xylophone", "female vocal", "religious", "christian", "church"] 9 tRA-5inwlMI 5036
ADDICTED KRU SOUND on SoulJah Sessions Radio This is an electronic DJ set in the style of Jamaican reggae music. There is a DJ performing over a track that has a groovy beat being played by the electric guitar and the electronic drums. There is a tropical atmosphere. Samples could be lifted from this recording to be used in the beat-making. 2007-09-19T01:45:21Z Steve B SoulJah Sessions Radio CJIQ 88.3 fm 09-15-07 featuring special guest "AKS" ["Music", "Tambourine"] ["electronic", "reggae", "dub", "dj", "turntable", "electric guitar", "electronic drums", "tropical", "danceable", "upbeat"] 9 wXWpkfGfZD8 5272

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;