musiccaps_details (view)

1 row where musiccaps_aspects contains "emotional" and musiccaps_names contains "Bang"

✎ 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
Harry + Louis || OTRA Tour PART 10 || Larry Stylinson This is the compilation of live performances from a pop music boy band. There are teen male vocalists singing melodically. The melody is being played by an acoustic guitar and a bass guitar while an acoustic drum beat is playing in the rhythmic background. There are sounds of a crowd singing and cheering. The recording quality is poor. 2015-06-17T11:19:42Z TheVickylove90 Watch in HD!! Sometimes I have the doubt that they're not a couple, but then they look at each other, they're not just friend ;) Hope you like the video !! xoxo PART 1 https://www.youtube.com/watch?v=lg1nF... PART 2 https://www.youtube.com/watch?v=JORQM... PART 3 https://www.youtube.com/watch?v=KZLGl... PART 4 https://www.youtube.com/watch?v=1AwHQ... PART 5 https://www.youtube.com/watch?v=knHl-... PART 6 https://www.youtube.com/watch?v=Blu_R... PART 7 https://www.youtube.com/watch?v=Zb8YN... PART 8 https://www.youtube.com/watch?v=zvILN... PART 9 https://www.youtube.com/watch?v=4iio1oYeQI0 PART 11 https://www.youtube.com/watch?v=098Fv2j-c2M PART 12 https://www.youtube.com/watch?v=3VIM2e5TP0A&feature=youtu.be PART 13 https://www.youtube.com/watch?v=uw9fjCNrbx0 PART 14 https://www.youtube.com/watch?v=jTGQAklkr4M Harry Styles + Louis Tomlinson Larry Stylinson One Direction Program Sony Vegas Pro 13 ["Singing", "Music", "Pop music", "Bang"] ["live performance", "pop music", "boy band", "teen male vocal", "melodic singing", "acoustic guitar", "bass guitar", "acoustic drums", "crowd singing", "emotional"] 9 OvjmfGU4y_M 2481

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;