musiccaps_details (view)
3 rows where musiccaps_aspects contains "flat male vocal", musiccaps_aspects contains "punchy snare" and musiccaps_aspects contains "synth lead melody"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- flat male vocal · 3 ✖
- low quality 3
- punchy snare · 3 ✖
- synth lead melody · 3 ✖
- energetic 2
- punchy kick 2
- bells melody 1
- children song 1
- electric guitar melody 1
- electro 1
- energetic crash cymbal 1
- exciting 1
- flat female vocal 1
- fun 1
- groovy bass guitar 1
- groovy piano melody 1
- happy 1
- joyful 1
- mono 1
- noisy 1
- rock 1
- shimmering cymbals 1
- shimmering hi hats 1
- simple bass 1
- simple hi hats 1
- soft kick hits 1
- wide electric guitar chords 1
musiccaps_names (array) 6 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Johny johny yes papa rhymes for children | Nursery Rhymes Song [4k Music Video] | The low quality recording features a children's song that consists of a flat male vocal singing over groovy piano melody, simple bass, simple hi hats, punchy snare, soft kick hits, synth lead melody, electric guitar melody and bells melody. It sounds happy, fun and joyful - like something kids would listen to. | 2016-01-06T09:37:27Z | Nursery Rhymes - Kids Songs | Johny johny yes papa rhymes for children | Nursery Rhymes Song [4k Music Video] Nursery Rhymes Collection: https://goo.gl/vpTh2Q Lullabies for kids https://goo.gl/aQHeAu Karaoke Songs https://goo.gl/NhyJLQ Music For Kids Playlist: https://goo.gl/AMC5J5 Time: 25:31 ►Subscribe: https://goo.gl/ofwLTe Subscribe to Nursery Rhymes TV for more music for children, Copyright © 2015 BH Media Corp | ["Music", "Music for children"] | ["low quality", "children song", "flat male vocal", "groovy piano melody", "simple bass", "simple hi hats", "punchy snare", "soft kick hits", "synth lead melody", "bells melody", "electric guitar melody", "happy", "fun", "joyful"] | 4 | 3EXXs3x4Ius | 449 | |
Jabbawockeez - Run This Town | The low quality recording features an electro song played on a device that produces the mono sound only. The song features a flat male vocal rapping, after which there is a drop that consists of punchy kick and snare hits, shimmering cymbals and synth lead melody. It sounds exciting and energetic, while the recording is noisy and in mono. | 2010-01-15T02:49:51Z | imajhaynation | http://jbwkz.com | ["Singing", "Scratching (performance technique)", "Music"] | ["low quality", "electro", "flat male vocal", "punchy kick", "punchy snare", "shimmering cymbals", "synth lead melody", "energetic", "exciting", "noisy", "mono"] | 4 | AzGtPHlrlzU | 1187 | |
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 |
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;