musiccaps_details (view)

1 row where musiccaps_aspects contains "low quality", musiccaps_aspects contains "metallic sound effects" and musiccaps_aspects contains "muffled"

✎ 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
Sonic in Jaws [ORIGINAL 2009 VERSION] The low quality recording features water and some metallic sound effects, followed by a dynamic orchestra that consists of a mellow string section, simple plucked harp and mystical woodwinds playing in the background. In the first part of the loop, the sound is completely muffled. It sounds like something you would hear in old movies. 2010-08-01T11:00:00Z Balena Productions The original Sonic in JAWS! It's a bit crude compared to what would succeed it, but it has it's charm! This content is directed to a mature audience that is over 13 years old according to Title 16 C.F.R. § 312.2 of CHILDREN'S ONLINE PRIVACY PROTECTION ACT (USA) This content is NOT intended for children under 13 years old. 🔔 Make sure to subscribe to never miss a new animation! 💙 Join our channel to get access to perks: https://youtube.com/balenaproductions/join 🐦 Follow us on Twitter: https://twitter.com/balenatweet #sonic #sonicthehedgehog #jaws ["Music", "Pour"] ["low quality", "muffled", "dynamic orchestra", "mellow strings section", "simple plucked harp", "mystical woodwinds", "water sound effects", "metallic sound effects"] 4 AgCSBCsHkMk 1152

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;