musiccaps_details (view)

1 row where musiccaps_aspects contains "groovy", musiccaps_aspects contains "keyboard", musiccaps_aspects contains "melodic singing" and musiccaps_aspects contains "pop dance"

✎ 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
Mariah Carey - Fantasy + Lyrics (HD) This is an R&B/pop dance music piece. There is a versatile female vocalist singing melodically. There is a keyboard and an electric guitar playing the melody while there is a groovy bass guitar line in the background. The rhythmic background is provided by an electronic drum beat. The atmosphere is urban and danceable. This piece could be used in the soundtrack of a romantic comedy movie. 2009-05-30T15:48:31Z MIMINHEROFOREVER Oh when you walk by every night Talking sweet and looking fine I get kind of hectic inside Oh baby I'm so into you Darling if you only knew All the things that flow through my mind But it's just a [Chorus:] Sweet sweet fantasy baby When I close my eyes You come and take me On and on and on It's so deep in my daydreams But it's just a sweet sweet fantasy baby Images of rapture Creep into me slowly As you're going to my head And my heart beats faster When you take me over Time and time and time again But it's just a [Chorus] I'm in heaven With my boyfriend My laughing boyfriend There's no beginning and there is no end Feels like I'm dreaming but I'm not sleeping It's just a [Chorus] ["Disco"] ["r&b", "pop dance", "versatile female vocal", "melodic singing", "keyboard", "electric guitar", "bass guitar", "electronic drums", "groovy", "urban", "danceable"] 9 JmbrGzgxrJ4 2032

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;