musiccaps_details (view)

1 row where musiccaps_aspects contains "dance", musiccaps_aspects contains "female voice" and musiccaps_names contains "Synthetic singing"

✎ 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
Front Row for Britney Spears performing BIG FAT BASS on Jimmy Kimmel LIVE! HD This is the live recording of a pop music piece. The track is being performed with playback. There is a female vocal with child-like characteristics. There is a strong electronic drum beat in the rhythmic background. A fuzzy synth bass is playing the melodic part. There are lots of beat repeat effects. The atmosphere is loud and energetic. There are sounds that can be heard coming from the crowd cheering. 2011-03-31T06:43:19Z Rene Carta Steadiest hand yet, you won't get dizzy watching it! =D ["Singing", "Music", "Synthetic singing", "Inside, large room or hall"] ["pop music", "live performance", "female voice", "child-like vocal", "electronic drums", "synthesizer", "strong bass", "loud", "energetic", "dance", "crowd sounds"] 9 TTytcT_1dmY 2838

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;