musiccaps_details (view)
1 row where musiccaps_aspects contains "happy", musiccaps_aspects contains "jingle" and musiccaps_aspects contains "wide shimmering shakers"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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;