musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "energetic crash cymbal", musiccaps_aspects contains "low quality" and musiccaps_aspects contains "wide electric guitar chords"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 17 ✖
- energetic 2
- energetic crash cymbal · 2 ✖
- low quality · 2 ✖
- punchy kick 2
- rock 2
- wide electric guitar chords · 2 ✖
- distorted bass guitar 1
- electric guitar slide 1
- flat female vocal 1
- flat male vocal 1
- groovy bass guitar 1
- live perforamnce 1
- noisy 1
- punchy snare 1
- reverberant toms 1
- shimmering hi hats 1
- synth lead melody 1
musiccaps_names (array) 5 ✖
- Music 2
- Angry music 1
- Heavy metal 1
- Independent music 1
- Speech 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
I've Got My Glasses On 👓 Wearing Glasses Song for Children 🧐🤓😎 The Wiggles | The low quality recording features a rock song that consists of a flat male vocal and flat female vocal talking, followed by punchy kick and snare hits, shimmering hi hats, energetic crash hits, wide electric guitar chords, groovy bass guitar and synth lead melody. It sounds energetic. | 2013-02-07T23:21:04Z | The Wiggles | Subscribe to our channel for more Wiggly videos: http://ab.co/WigglesYouTube For more Wiggly fun: Website ► http://TheWiggles.com.au Facebook ► http://facebook.com/TheWiggles Twitter ► http://twitter.com/TheWiggles Instagram ► http://instagram.com/TheWiggles Spotify ► https://ab.co/TheWigglesSpotify US & UK Shop ► https://thewigglestore.com/ AUS Shop ► https://thewigglestore.com.au/ #glasses #kidsglasses #thewiggles | ["Music", "Independent music", "Speech"] | ["low quality", "rock", "flat female vocal", "flat male vocal", "energetic crash cymbal", "groovy bass guitar", "wide electric guitar chords", "synth lead melody", "shimmering hi hats", "punchy kick", "punchy snare", "energetic"] | 4 | b-Y-AjW6MJ0 | 3594 | |
KISS - Psycho Circus (Live 1998) | The low quality recording features a live performance of a rock song that features wide electric guitar chords, distorted bass, reverberant toms, punchy kick hits and energetic crash cymbals. There are a few electric guitar slides. The recording is very noisy and it sounds energetic. | 2007-03-22T02:19:12Z | reverendcuntbag | KISS - Psycho Circus Live 1998 on Fox TV Halloween Party | ["Heavy metal", "Music", "Angry music"] | ["low quality", "rock", "wide electric guitar chords", "distorted bass guitar", "reverberant toms", "punchy kick", "energetic crash cymbal", "live perforamnce", "energetic", "noisy", "electric guitar slide"] | 4 | iCHskFoUvbw | 4167 |
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;