musiccaps_details (view)

1 row where musiccaps_aspects contains "groovy piano melody", musiccaps_aspects contains "punchy kick", musiccaps_aspects contains "wide shimmering shakers" and musiccaps_names contains "Mouse"

✎ View and edit SQL

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

CSV options: 

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;