musiccaps_details (view)
4 rows where musiccaps_aspects contains "fun" and musiccaps_aspects contains "laughing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- fun · 4 ✖
- laughing · 4 ✖
- low quality 4
- noisy 3
- happy 2
- 4 on the floor kick 1
- accordion melody 1
- bouncy snare 1
- car engine sound effects 1
- chaotic 1
- crowd chattering 1
- crowd clapping 1
- electric guitar melody 1
- emotional 1
- emotional female vocal 1
- flat male vocal 1
- groovy bass 1
- guitar melodies 1
- harmonized children vocals 1
- harmonizing male vocals 1
- high pitched tire screech 1
- karaoke 1
- live performance 1
- muffled pop song 1
- people chattering 1
- playback 1
- quiet 1
- rock-ish drums 1
- saxophone solo melody 1
- shimmering open hat 1
- static tv sound effect 1
- thin 1
- tinny glass impacts 1
- trombone melody 1
musiccaps_names (array) 6 ✖
- Music 3
- /t/dd00004 1
- Accordion 1
- Rattle (instrument) 1
- Speech 1
- Vocal music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Geminoid F singing a Japanese song @ Robots in motion @ Cityplaza, Hong Kong 2012.4.1 | The low quality recording features a, what it seems like, karaoke cover of a muffled pop song that consists of some guitar melodies and rock-ish drums, over which an emotional female vocal is singing. There are some laughing and chattering crowd sound effects in the background too. It sounds fun and emotional, but also noisy and kind of chaotic. | 2012-04-01T15:16:35Z | Amanda Lam | 太古城中心全互動機械人大博覽 2012.4.1 Robots in motion @ Cityplaza, Hong Kong 2012.4.1 | ["Music", "/t/dd00004"] | ["low quality", "muffled pop song", "noisy", "laughing", "people chattering", "live performance", "karaoke", "emotional", "fun", "rock-ish drums", "guitar melodies", "emotional female vocal", "chaotic"] | 4 | 16TsDMjHzYU | 238 | |
Denis Novato | The low quality recording features an accordion melody, electric guitar melody and trombone melody, after which there is a crowd clapping, laughing and chattering sounds. There are also tinny glass impacts in the background. It gives off fun and happy vibes. | 2008-07-13T14:34:40Z | buttonbox | Denis plays at Slovenefest XXVII | ["Accordion"] | ["low quality", "accordion melody", "electric guitar melody", "trombone melody", "crowd clapping", "laughing", "crowd chattering", "fun", "happy", "tinny glass impacts"] | 4 | TWnrcjA6VTk | 2842 | |
THE WARP ZONE BLOOPERS 2013 | The low quality recording features harmonizing male vocals singing over a song played on playback, followed by a flat male vocal talking. At the end of the recording, there is a male laughter. It sounds fun and the recording is noisy. | 2014-01-01T18:00:04Z | The Warp Zone | We cap off 2013 with some funny bloopers from this year's videos! SUBSCRIBE! http://bit.ly/Sub2TWZ FB: http://www.fb.com/thewarpzone Edited by Michael Adams Davis Shot by Mike Schmidt Trent Turner Sharif Matar Michael Schroeder Brian Fisher Ryan Tellez - The Warp Zone - Videos 5 Days a Week! http://youtube.com/TheWarpZone Like us on Facebook! http://facebook.com/TheWarpZone Follow us on Twitter! http://twitter.com/WarpZoneTweets Follow us on Instagram! http://instagr.am/WarpZoneGrams | ["Music", "Speech", "Vocal music"] | ["low quality", "noisy", "harmonizing male vocals", "flat male vocal", "laughing", "playback", "fun"] | 4 | hM88FG1_D5Q | 4098 | |
WAKE, RATTLE & ROLL Episode 2 part 1 | The low quality recording features a song that consists of harmonized children vocals singing over bouncy snare, saxophone solo melody, groovy bass, shimmering open hats and "4 on the floor" kick pattern. There are some laughing, high pitched tire screeches and car engine sound effects in the background. The recording is very noisy and the song is quiet and thin, as it lacks bass frequencies, but it still sounds fun and happy - like something you would hear in TV shows for kids. | 2008-10-08T19:05:34Z | Jack Box | A new episode! | ["Music", "Rattle (instrument)"] | ["low quality", "quiet", "noisy", "fun", "happy", "harmonized children vocals", "bouncy snare", "thin", "laughing", "car engine sound effects", "static tv sound effect", "high pitched tire screech", "saxophone solo melody", "groovy bass", "shimmering open hat", "4 on the floor kick"] | 4 | mQM3Fd3eN9E | 4470 |
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;