musiccaps_details (view)
1 row where musiccaps_aspects contains "electric guitar", musiccaps_aspects contains "keyboard", musiccaps_aspects contains "r&b" and musiccaps_names contains "Disco"
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
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;