musiccaps_details (view)

1 row where musiccaps_aspects contains "female voice", musiccaps_aspects contains "moderate tempo" and musiccaps_aspects contains "rock drums"

✎ 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
Avril Lavigne - Here's to Never Growing Up (Official Lyric Video) This pop rock song features a female voice singing the main melody. The song starts off with the sound of folding paper. Then the voice starts singing. This is accompanied by rock drums playing the kick drum. The snare is struck at every alternate count. The reverb effect is added to the percussion. There are no other instruments in this song. This song has a happy mood. This song can be played in an intro scene of a coming-of-age movie. 2013-04-09T14:15:06Z AvrilLavigneVEVO Download the "Avril Lavigne" album here: http://smarturl.it/avril-lavigne Spotify: http://open.spotify.com/album/512J2VIGOTP50qp5MNEUyG Follow Avril: http://www.avrillavigne.com http://youtube.com/AvrilLavigneVEVO http://twitter.com/AvrilLavigne http://facebook.com/avrillavigne http://instagram.com/avrillavigne ["Music", "Crumpling, crinkling"] ["pop rock", "female voice", "moderate tempo", "rock drums", "sound of folding paper", "no other instruments", "happy mood"] 0 iFSaNmZyPQo 4173

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;