musiccaps_details (view)
3 rows where musiccaps_aspects contains "children’s song" and musiccaps_aspects contains "energetic"
This data as json, CSV (advanced)
musiccaps_aspects (array) 48 ✖
- children’s song · 3 ✖
- energetic · 3 ✖
- medium tempo 2
- animated 1
- animated singing 1
- animated vocals 1
- backup singers 1
- bouncy 1
- catchy 1
- catchy tune 1
- clapping rhythm 1
- dance club 1
- dance rhythm 1
- dissonant tapping 1
- electro pop 1
- electronic instrumentation 1
- engaging 1
- enthusiastic 1
- fast tempo 1
- female singer 1
- flute harmony 1
- funny song 1
- groovy bass line 1
- inferior audio quality 1
- juvenile lyrics 1
- keybiard accompaniment 1
- keyboard harmony 1
- kids song 1
- male vocalist 1
- mario theme 1
- muffled audio 1
- people dancing 1
- percussion hits 1
- pop dance hits 1
- pop song 1
- recorder 1
- rhythmic chatter 1
- rhythmic speech 1
- sound of clapping 1
- sound of rattle 1
- spirited 1
- steady drumming rhythm 1
- synthesiser 1
- unconventional music 1
- video games 1
- vocal backup 1
- vocal harmony 1
- vocalisation 1
youtube_published (date) 3 ✖
- 2010-04-15 1
- 2012-07-04 1
- 2012-09-21 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
I'm An Indian Too - The 1491s | A female singer sings this catchy tune with backup singers in vocal harmony. The song is medium tempo with a groovy bass line, keyboard accompaniment, steady drumming with a clapping percussion. The song is catchy and has a dance rhythm. The song is a pop dance song. | 2012-09-21T20:22:49Z | the1491s | Support more content, buy a t-shirt! https://squareup.com/market/the-1491s/s-t-shirt | ["Funk", "Music"] | ["female singer", "funny song", "backup singers", "pop dance hits", "dance club", "vocal harmony", "animated singing", "steady drumming rhythm", "keybiard accompaniment", "clapping rhythm", "percussion hits", "catchy tune", "dance rhythm", "people dancing", "energetic", "children’s song", "pop song", "medium tempo", "groovy bass line"] | 1 | 9BHvpWP2V9Y | 981 | |
2003 Fisher-Price® Winnie The Pooh: Turbo Tail Tigger Bouncing Singing Animated | A male vocalist sings this animated song. The tempo is fast with a flute Or recorder and keyboard harmony with the sound of clapping and tapping in the background. The song is animated, spirited, enthusiastic, catchy and upbeat with rhythmic speech and childish lyrics. This is a Children’s Song. | 2012-07-04T23:44:06Z | The Silver V | 2003 Fisher-Price® Winnie The Pooh: Turbo Tail Tigger Bouncing Singing Animated Item for sale on EBAY seller silverv EBAY store The Silver V | ["Music", "Bouncing"] | ["male vocalist", "fast tempo", "rhythmic chatter", "kids song", "dissonant tapping", "bouncy", "recorder", "rhythmic speech", "vocal backup", "flute harmony", "animated", "spirited", "enthusiastic", "energetic", "sound of rattle", "sound of clapping", "children’s song", "juvenile lyrics", "inferior audio quality", "muffled audio"] | 7 | UfZP677y3Dc | 2933 | |
[Soccer] Toaster Cacophony | This song is an instrumental. The tempo is medium with an animated keyboard harmony and vocalisation. The music is heavily synthesised and sounds like a children’s song. This song is an electronic pop/ Children’s song. | 2010-04-15T21:27:12Z | avojaifnot | Final round vs. XXiknarfXXPoop Unfinished. I apologize to my opponent. This was not a good way to end the match. | ["Music", "Cacophony"] | ["mario theme", "animated vocals", "catchy", "engaging", "energetic", "unconventional music", "keyboard harmony", "electro pop", "video games", "children’s song", "vocalisation", "electronic instrumentation", "synthesiser", "medium tempo"] | 7 | pKDnn0CBIe0 | 4700 |
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;