musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "haunting" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- haunting · 2 ✖
- alternative/indie 1
- creepy 1
- echoing plucked strings melody 1
- electric guitar licks 1
- energetic 1
- energetic crash cymbal 1
- groovy bass 1
- halloween 1
- low quality 1
- piano chords 1
- punchy kick 1
- smooth bass guitar 1
- suspenseful 1
- synth keys chords 1
musiccaps_names (array) 5 ✖
- Music 2
- Soul music 2
- Background music 1
- Rhythm and blues 1
- Ska 1
youtube_description 2 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
José Cid- Mellotron - O Planeta Fantástico | The Alternative/Indie song features layered punchy kicks, energetic crash cymbals, groovy bass and synth key chords, followed by electric guitar licks. It sounds haunting and energetic, almost like a halloween themed song. | 2010-09-24T02:02:36Z | jerudoriginal91 | ["Music", "Rhythm and blues", "Ska", "Soul music"] | ["alternative/indie", "punchy kick", "groovy bass", "synth keys chords", "electric guitar licks", "energetic crash cymbal", "energetic", "haunting", "halloween"] | 4 | 1Xtkou9dtyA | 285 | ||
Coil with Throbbing Gristle - In My Blood | The low quality recording features piano chords, followed by echoing plucked strings melody and smooth bass guitar. It sounds creepy, haunting and suspenseful. | 2015-02-22T03:20:53Z | Virgil Pink | Dutch Suppliments, 2001 | ["Background music", "Music", "Soul music"] | ["low quality", "piano chords", "echoing plucked strings melody", "smooth bass guitar", "creepy", "haunting", "suspenseful"] | 4 | ZkGQhIbEDrs | 3407 |
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;