musiccaps_details (view)
2 rows where musiccaps_aspects contains "electronic" and musiccaps_names contains "Sidetone"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- electronic · 2 ✖
- broken 1
- cold 1
- distant 1
- distorted 1
- drum & bass 1
- experimental 1
- harsh 1
- lo-fi 1
- metallic 1
- shrill 1
- shuffle 1
- sound effects 1
- steady tempo 1
- techno 1
- telephone 1
- trashy 1
musiccaps_names (array) 4 ✖
- Music 2
- Sidetone · 2 ✖
- Electronic dance music 1
- Electronic music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Hardstyle Republic Shuffle vs Tecktonik | This is a shuffle music piece. It opens with a dissolving sound effect that signals that a drop is about to start. The dialing sound effects of a buttoned telephone can be heard. It mostly consists of electronic sounds that could be influenced by drum & bass. | 2009-07-12T07:30:41Z | thesounx | Hardstyle Republic Shuffle vs Tecktonik | ["Music", "Sidetone"] | ["shuffle", "drum & bass", "electronic", "sound effects", "telephone"] | 9 | 3Z74i_FWs3o | 482 | |
La Monde (Len Faki) - Peak (Elephant Sequence EP B2) | A trashy, lo-fi sounding experimental techno track with a steady tempo and shrill, metallic sounds. The mood is cold and distant. Everything sounds a little broken. | 2010-05-20T18:34:55Z | TomSawyer1973 | La Monde (Len Faki) - Elephant Sequence EP B2 - Monoid 018 | ["Electronic music", "Music", "Electronic dance music", "Sidetone"] | ["shrill", "metallic", "steady tempo", "experimental", "electronic", "techno", "harsh", "lo-fi", "trashy", "distorted", "cold", "broken", "distant"] | 8 | 5hyRWertUbI | 683 |
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;