musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "bass guitar", musiccaps_names contains "Pop music" and musiccaps_names contains "Progressive rock"
This data as json, CSV (advanced)
musiccaps_aspects (array) 13 ✖
- bass guitar · 2 ✖
- electric guitar 2
- acoustic drums 1
- drums 1
- energetic 1
- female vocal 1
- female voice 1
- melodic singing 1
- normal tempo 1
- rock genre 1
- rock music 1
- sound effects 1
- thai 1
musiccaps_names (array) 6 ✖
- Independent music 2
- Music 2
- Pop music · 2 ✖
- Progressive rock · 2 ✖
- Heavy metal 1
- Tick-tock 1
youtube_published (date) 2 ✖
- 2009-09-03 1
- 2013-11-18 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
7 o'clock Teaser นี่เธอไม่รู้หรือแกล้งไม่รู้ | This is a rock music piece. It starts with a clock. There is a female vocalist singing melodically in the Thai language. The overdriven electric guitar is strumming the chords of the main tune while the bass guitar is supporting it in the background. The acoustic drum is playing a simple but powerful beat. The general atmosphere is energetic. The piece can be used as a soundtrack in a coming-of-age drama taking place in Thailand. | 2009-09-03T06:40:52Z | Chanin Yanyong | The complete teaser of 7 o'clock นี่เธอไม่รู้หรือแกล้งไม่รู้ | ["Heavy metal", "Music", "Independent music", "Pop music", "Tick-tock", "Progressive rock"] | ["rock music", "thai", "female vocal", "melodic singing", "electric guitar", "bass guitar", "acoustic drums", "normal tempo", "sound effects", "energetic"] | 9 | B1beLwV4yzw | 1193 | |
ruido rosa- persona en vivo | The rock music features a female voice singing a melody. The band that accompanies her consists of drums, bass guitar and electric guitar. The drums play a repetitive rhythm, the bass guitar also incorporates slides into its playing and the electric guitar plays a simple melody that's composed of repetitive notes. | 2013-11-18T01:49:39Z | PIC AZO | ["Music", "Independent music", "Pop music", "Progressive rock"] | ["female voice", "bass guitar", "drums", "electric guitar", "rock genre"] | 2 | RIpfb9LSFe8 | 2691 |
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;