musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "flute" and musiccaps_aspects contains "pop music" sorted by youtube_description
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 17 ✖
- easygoing 2
- flute · 2 ✖
- pop music · 2 ✖
- acoustic drums 1
- acoustic guitar 1
- amateur recording 1
- bass guitar 1
- calming 1
- catchy 1
- cover 1
- electric guitar 1
- female voice 1
- gentle playing 1
- instrumental 1
- medium tempo 1
- sentimental 1
- shouting-like singing 1
musiccaps_names (array) 5 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
LaLa - Lost Ones ♪ | This is a pop music piece. There is a female vocalist singing in a shout-like style. There is a flute and an electric guitar playing the melody with the bass guitar playing in the background. The rhythm is provided by a medium tempo acoustic drum beat. The tune is catchy. The piece is in the major key and there is an easygoing atmosphere to it. This piece could be used in the soundtrack of a sit-com during the credits section. | 2009-01-11T02:11:54Z | Hysteria | LaLa - Lost Ones DJ Vida V Presents American Mija no copyright to this video | ["Music", "Soul music", "Happy music"] | ["pop music", "female voice", "shouting-like singing", "flute", "electric guitar", "bass guitar", "acoustic drums", "easygoing", "catchy", "sentimental", "medium tempo"] | 9 | svNayU6q3Dg | 4987 | |
Safe and sound - Taylor Swift flute cover | This is an amateur flute cover of a pop music piece. The flute is playing a gentle melody in the major key. There is a backing track that has a mellow acoustic guitar playing. The atmosphere is calming and easygoing. Although the audio quality is not that great, this piece could be sampled for use in beat-making. | 2012-03-24T11:55:13Z | Melissa.Flutes | Sorry I've been gone so long! But I'm back now making more videos so keep the requests coming!! Love you guys!!! Links: Notes: http://www.melissaflutes.com/notes/ Facebook: https://www.facebook.com/Missmelflute Twitter: https://twitter.com/Missmelflute Instagram: http://instagram.com/missmelflute Vlog channel : http://www.youtube.com/user/Missmelflutevlogs Facebook: http://www.facebook.com/Missmelflute Twitter: https://twitter.com/#!/Missmelflute | ["Wind instrument, woodwind instrument", "Flute"] | ["cover", "amateur recording", "pop music", "instrumental", "flute", "gentle playing", "acoustic guitar", "calming", "easygoing"] | 9 | _IP6zlayY7k | 3460 |
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;