musiccaps_details (view)

1 row where musiccaps_aspects contains "male throaty vocals" and "youtube_published" is on date 2013-01-25

✎ 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
Opening to Finding Nemo 2003 DVD (2 Discs) The low quality, noisy recording features a male throaty vocals singing and some footsteps sound effects. In the background, some dog is barking. The whole sound is panned to the left channel of the stereo image, thus the unbalanced stereo image and it sounds like a sound from TV was recorded. 2013-01-25T01:56:51Z AndyBrinkerhoff92 Hello viewers, and welcome to another LogoFan121092 DVD video; this time, as requested by SterlinTheMovieDude2, the DVD of Pixar's epic journey across the Great Barrier Reef. Enjoy! Opening to Disc One (Widescreen): 1. FBI Warning Screens (Blue Version) 2. DVD Menu 3. THX "Moo Can" logo (1997-) 4. Walt Disney Pictures "Pixar" logo (1995-2007) 5. Pixar Animation Studios logo (1995-) 6. Start of film. Closing to Disc One: 1. End of film 2. Walt Disney Pictures "Pixar" logo (1995-2007) 3. Pixar Animation Studios logo (1995- closing variant) Opening to Disc Two: 1. FBI Warning Screens (Blue Version) 2. "Coming Soon to Theaters" Bumper 3. "The Incredibles" Teaser Trailer 4. "Home on the Range" Trailer 5. "Coming Soon on Video & DVD" Bumper 6. "The Lion King 1-1/2" Trailer 7. "The Santa Clause 2" DVD Trailer 8. DVD Menu 9. THX "Tex" logo (1996-) 10. Walt Disney Pictures "Pixar" logo (1995-2007) 11. Pixar Animation Studios logo (1995-) 12. Start of film Closing to DVD: 1. End of film 2. Walt Disney Pictures "Pixar" logo (1995-2007) 3. Pixar Animation Studios logo (1995- closing variant) I DO NOT OWN "FINDING NEMO", ALL RIGHTS TO THIS FILM AND ALL RELATED TRADEMARKS BELONG TO WALT DISNEY PICTURES AND PIXAR ANIMATION STUDIOS. ["Music", "Synthetic singing"] ["low quality", "mono", "noisy", "dog barking", "male throaty vocals", "unbalanced stereo image"] 4 MJtDDmS6xSY 2255

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;