musiccaps_details (view)
2 rows where musiccaps_aspects contains "background-noises" and musiccaps_aspects contains "female voice"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- background-noises · 2 ✖
- female voice · 2 ✖
- amateur recording 1
- banjo 1
- changing songs 1
- comedic sound effects 1
- dog barking 1
- drums 1
- e-bass 1
- electronic drums 1
- experimental 1
- funky 1
- glass shattering 1
- male voice shouting 1
- medium to uptempo 1
- pop/country 1
- uptempo 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 |
---|---|---|---|---|---|---|---|---|---|---|
Uncle Grandpa - Funny Face (Preview) Clip 1 | This piece of audio contains a modern pop song with drums, effects panned to left and right, a female voice singing with delay before changing into a totally different song that sounds more like a fast paced country song with a synthesizer- melody; acoustic drums and a banjo playing a fast melody along. This recording is also full of voice samples, a tiger or lion roaring, a telephone ringing. According to all these sounds and fast paced changes, it can be assumed that this recording is best played at a comedic television show for kids. | 2014-04-14T04:21:14Z | Cartoon Network Asia | When Uncle Grandpa accidentally unleashes a floating Funny Face that's so funny you laugh yourself to insanity, the guys realize that only Gus' seriousness can save them, but will he help them after they've hurt his feelings? Watch more of Uncle Grandpa on Cartoon Network! Watch more Uncle Grandpa videos: http://www.cartoonnetworkasia.com/video/uncle-grandpa Check out our Cartoon Network Facebook pages: http://www.facebook.com/asia.cartoonnetwork http://www.facebook.com/CartoonNetworkPhilippines | ["Music", "Telephone bell ringing", "Roaring cats (lions, tigers)", "Inside, large room or hall"] | ["pop/country", "changing songs", "electronic drums", "banjo", "female voice", "comedic sound effects", "background-noises", "uptempo"] | 6 | e57SBRbMXbI | 3842 | |
Sound Asleep | An e-bass is playing a funky bassline with a drumbeat that sounds like the high frequencies have been filtered out. You can hear a lot of background noises that do not belong to the recording. Such as a dog barking, glass shattering, a male voice shouting and a female voice singing. All these sounds are using a reverb. This song may be playing as part of a movie scene. | 2007-10-18T10:44:06Z | selfademus | by Cathy Slim | ["Music", "Scratch", "Scrape"] | ["funky", "experimental", "e-bass", "background-noises", "glass shattering", "male voice shouting", "female voice", "drums", "dog barking", "amateur recording", "medium to uptempo"] | 6 | jbe3VM-5xdc | 4264 |
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;