musiccaps_details (view)
2 rows where musiccaps_aspects contains "repeated theme" and musiccaps_aspects contains "simple tune" sorted by musiccaps_aspects
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- easygoing 2
- repeated theme · 2 ✖
- simple tune · 2 ✖
- acoustic drums 1
- american 1
- bass guitar 1
- blues 1
- dance pop 1
- electric guitar 1
- electronic drums 1
- female vocals 1
- generic 1
- groovy 1
- k-pop 1
- keyboard 1
- korean 1
- live performance 1
- male back vocals 1
- male vocal 1
- melodic singing 1
- rock and roll 1
- upbeat 1
musiccaps_names (array) 4 ✖
- Music 2
- Funk 1
- Music of Asia 1
- Soul music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects ▼ | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
[Comeback Stage] GIRL'S DAY - Ring My Bell, 걸스데이 - 링마벨, Show Music core 20150711 | This is a K-pop music piece being performed live by a girl group. There are female vocals singing melodically. There is a keyboard playing a simple and repeated theme. The rhythmic background consists of a danceable electronic drum beat. The atmosphere is easygoing. This piece could be playing in the background at a clothing store. | 2015-07-11T07:45:45Z | MBCkpop | Music core 20150711 GIRL'S DAY - Ring My Bell, 걸스데이 - 링마벨 ▶Show Music Core Official Facebook Page - https://www.facebook.com/mbcmusiccore | ["Music of Asia", "Music"] | ["k-pop", "dance pop", "korean", "live performance", "female vocals", "melodic singing", "keyboard", "electronic drums", "simple tune", "repeated theme", "generic", "easygoing", "upbeat"] | 9 | CretxKgW4Jk | 1408 | |
MITCH RIDER & the DETROIT WHEELS - BREAKOUT | This is a rock and roll music piece. There is a male vocal singer singing as the lead while other back vocals sing rhythmic back vocals at a higher pitch than the lead. An electric guitar is playing a simple and repeated tune while there is a bass guitar in the background. The acoustic drums are playing a basic 4/4 rock beat with claps simultaneous with the snare hits. There is an easygoing atmosphere in this piece. It could be playing in the background of a rock bar. This piece could also work well in sports venues. | 2011-04-23T15:20:22Z | PaulGTSE | MITCH RIDER & the DETROIT WHEELS with BREAKOUT on the UK PYE DISCO DEMAND LABEL 100mph NORTHERN SOUL | ["Funk", "Music", "Soul music"] | ["rock and roll", "blues", "male vocal", "male back vocals", "electric guitar", "bass guitar", "acoustic drums", "american", "repeated theme", "simple tune", "easygoing", "groovy"] | 9 | GQbUpJFArKI | 1720 |
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;