musiccaps_details (view)
2 rows where musiccaps_aspects contains "jingle" and musiccaps_aspects contains "low quality" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- jingle · 2 ✖
- low quality · 2 ✖
- bouncy snare 1
- brass melody 1
- energetic 1
- exciting 1
- folk 1
- fun 1
- groovy bass 1
- groovy piano melody 1
- happy 1
- harmonizing staccato vocals melody 1
- harmonizing vocals 1
- mice sounds effects 1
- mono 1
- punchy kick 1
- snare roll 1
- strings melody 1
- synth keys chords 1
- thin snare 1
- tom roll 1
- wide shimmering shakers 1
musiccaps_names (array) 4 ✖
- Music 2
- Folk music 1
- Mouse 1
- Snicker 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
LAUGHTER DA MASTER SEASON 2 SEMIFINAL EPISODE 18 PART 1 OF 8 | The low quality recording features a jingle that consists of harmonizing vocals talking over snare roll, toms roll, brass melody and groovy bass, after which there is a folk song that starts playing. The folk song contains strings melody, bouncy snare, shimmering hi hats and synth keys chords. It sounds energetic and exciting, and like something you would hear on some TV show. | 2013-01-08T17:16:36Z | LaughterDaMaster2 | ["Folk music", "Music", "Snicker"] | ["harmonizing vocals", "snare roll", "jingle", "tom roll", "brass melody", "groovy bass", "low quality", "mono", "folk", "bouncy snare", "strings melody", "synth keys chords", "energetic", "exciting"] | 4 | bzOeufhFITk | 3670 | ||
Mouse Movie: "Say Cheese!" | The low quality recording features a harmonizing staccato vocals melody sung over groovy piano melody, wide shimmering shakers, punchy kick, thin snare hits and some nice sound effects in the background. It sounds fun and happy - almost like a jingle. | 2015-02-20T13:53:10Z | MyFWC Florida Fish and Wildlife | When our biologists inserted a camera into a gopher tortoise burrow, this is what they saw: a family of Florida mice! Watch as some of them seem to be saying “cheese!” for the camera or posing for a selfie. The mice weren't trespassing. Gopher tortoises have plenty of roommates because they are a keystone species: More than 350 other types of animals share the nicely dug burrows! The burrows have fairly constant temperatures and humidity, plus they provide protection from fire and bad weather. The Florida mouse is found only in peninsular Florida, where it lives in dry, upland habitats. In addition to Florida mice, gopher frogs, snakes, insects and plenty of other animals are also gopher tortoise “roommates.” This video of Florida mice inside a burrow was captured by FWC biologists at Lafayette Forest Wildlife and Environmental Area. Gopher tortoise photos: https://www.flickr.com/photos/myfwcmedia/sets/72157629330347632 Florida mice photos: https://www.flickr.com/photos/myfwcmedia/sets/72157637415171546 The Florida mouse is protected as a State Species of Special Concern by Florida’s Endangered and Threatened Species Rule and is part of our new Imperiled Species Plan: http://myfwc.com/imperiledspecies/ #tortoise #mice #mouse #Florida #FWC #video | ["Music", "Mouse"] | ["low quality", "harmonizing staccato vocals melody", "groovy piano melody", "wide shimmering shakers", "punchy kick", "thin snare", "mice sounds effects", "fun", "happy", "jingle"] | 4 | eYngZ5It0b8 | 3877 |
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;