musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "male voice" and musiccaps_names contains "Swing music" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- male voice · 2 ✖
- accordion 1
- acoustic drums 1
- bass guitar 1
- country genre 1
- drums 1
- electric guitar 1
- fast tempo 1
- female backing vocals 1
- good mood 1
- higher register yodeling 1
- slide technique 1
- string instrument 1
- strings 1
- upright/e-bass 1
- yodel/folkmusic 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Тирольские напевы / JODELN / Йодль | An accordion is playing short notes on the offbeat along with soft snare hits being played with brushes. A bass is playing straight, changing the note on every beat. Another accordion is answering the yodeling male voice with a short melody. The male voice is loud, clear and sings a melody in the higher register. A guitar-like instrument is strumming chords in the higher register. The instruments are panned to the left and right side of the speakers. This song may be playing at a concert in the countryside. | 2013-04-27T14:32:58Z | Prometheus | ["Swing music", "Yodeling", "Music"] | ["yodel/folkmusic", "accordion", "acoustic drums", "upright/e-bass", "string instrument", "male voice", "higher register yodeling", "fast tempo", "good mood"] | 6 | IyJ3a5uuCOs | 1956 | ||
Say it Again - Don Williams | The country music features a male voice singing while being backed by female vocals. The drums play a simple and repeating rhythm and together with the bass guitar drive the pulse of the music. An electric guitar plays short repeating musical phrases that incorporate the slide technique. In the background a group of strings fills the harmony and also provides a melody in the higher register. | 2009-12-26T16:37:25Z | WhatchaNeed23 | Say it Again Don Williams Harmony 1976 ABC Records | ["Swing music", "Music"] | ["male voice", "female backing vocals", "electric guitar", "drums", "bass guitar", "strings", "slide technique", "country genre"] | 2 | VJ-dpTx_3Cg | 2989 |
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;