musiccaps_details (view)
2 rows where musiccaps_aspects contains "slow tempo" and "youtube_published" is on date 2009-09-24
This data as json, CSV (advanced)
musiccaps_aspects (array) 13 ✖
- slow tempo · 2 ✖
- backing track 1
- crowd sound 1
- cymbal 1
- e-guitar 1
- male voice 1
- no string instruments 1
- regional mexican 1
- romantic mood 1
- sensual 1
- soul/ballad 1
- trumpets 1
- tuba 1
musiccaps_names (array) 8 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
recuerdos la arrolladora | This Regional Mexican song features a live recording of a male voice singing the main melody. The song starts with the cymbal played once and held so that it does not ring. Then the male voice sings one line with the crowd. The crowd shouts out in joy after a line is sung. The bass is played on a tuba. This is followed by trumpets playing a high pitched melody. This song is at a slow tempo. Apart from the initial cymbal sound, no other percussion is played. This song can be played in a romantic movie. | 2009-09-24T06:59:11Z | Luck Jimenez | ["Swing music", "Music", "Music of Latin America"] | ["regional mexican", "male voice", "crowd sound", "tuba", "trumpets", "cymbal", "slow tempo", "no string instruments", "romantic mood"] | 0 | JbWaSZPOh18 | 2023 | ||
Test : Guitar Kit with Clean sound By LocalHero | Someone is playing a solo on a clean e-guitar along with a backing track that sounds like a slow soulful, sad ballad with strings,bass, acoustic drums and an e-guitar strumming single chords as a rhythmic instrument. This song may be played outside by a busker. | 2009-09-24T11:14:20Z | Korrakote Rodrat | Guitar Kit with Clean sound By LocalHero รั่วอยู่เยอะครับ ไม่ต้องสนใจ ฟังซาวด์ ฟังโทนของกีตาร์ก็พอครับ ฮ่าๆ ^_^" | ["Bass guitar", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["soul/ballad", "backing track", "e-guitar", "slow tempo", "sensual"] | 6 | wKoFJHb2BoI | 5255 |
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;