musiccaps_details (view)
2 rows where musiccaps_aspects contains "birds chirping", musiccaps_aspects contains "medium tempo" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- birds chirping · 2 ✖
- medium tempo · 2 ✖
- amateur recording 1
- car engine 1
- carousel 1
- carousel music 1
- children’s music 1
- children’s toy music 1
- disco pop 1
- electronic music 1
- engine sound 1
- engine whirring 1
- enthusiastic drumming 1
- female vocalist 1
- home video 1
- hopeful 1
- ice-cream cart 1
- instrumental 1
- low quality audio 1
- mellow 1
- melodic acoustic guitar 1
- merry-go round 1
- multi genre soundscape 1
- outdoors 1
- people’s voices 1
- pleasant 1
- pop 1
- pop rap 1
- reggae 1
- soft 1
- soothing 1
- steel pan 1
- synthesiser arrangements 1
- thudding 1
- xylophone melody 1
musiccaps_names (array) 6 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Marla Brown - Better Days [Official Video 2015] | A female vocalist sings this pleasant pop song. The tempo is medium with a keyboard harmony, melodious acoustic guitar harmony, bright drumming , steel pan and the sound of birds chirping. The song is mellow, soft, pleasant, soothing, hopeful, sentimental, sweet and cheerful.this song is a Reggae Pop. | 2015-04-07T15:16:07Z | Reggaeville | ⏩ SUBSCRIBE http://bit.ly/yt-reggaeville 🔔 GET NOTIFIED about new videos! ✅ Log on https://www.REGGAEVILLE.com 🅵🅱 https://www.fb.com/reggaeville 🅸🅶 https://www.instagram.com/reggaeville 🆃🆃 https://www.tiktok.com/@reggaeville Marla Brown - Better Days [Royal Order Music] SINGLE OUT April 14th 2015 BUY @ https://itunes.apple.com/album/better-days-single/id978513329 Produced by: Royal Order Music and Green Stone Music Video Director and Editor: Dennis Brown/Visually Sound Media Production © #MarlaBrown #Reggaeville #Reggae | ["Bird vocalization, bird call, bird song", "Music", "Reggae", "Chirp, tweet", "Outside, rural or natural"] | ["female vocalist", "medium tempo", "birds chirping", "melodic acoustic guitar", "steel pan", "enthusiastic drumming", "synthesiser arrangements", "soft", "mellow", "pleasant", "hopeful", "pop", "pop rap", "disco pop", "reggae", "multi genre soundscape", "soothing"] | 7 | ZPK1hSPI540 | 3374 | |
1st Ice Cream Truck of the Year | This music is instrumental. The tempo is medium with an electronic xylophone melody. The audio is of inferior quality and it sounds like it is being played outdoors. There are ambient nature sounds like birds chirping, a car engine, a loud thud and people’s voices. | 2011-04-15T01:41:18Z | Elizabeth's Adventures | Here is a video that I took of the first ice cream truck of the year. This truck comes around almost every day in front of our building. The song is the Mr Softee song | ["Ice cream truck, ice cream van", "Music"] | ["instrumental", "medium tempo", "engine sound", "car engine", "people’s voices", "low quality audio", "amateur recording", "home video", "outdoors", "ice-cream cart", "merry-go round", "carousel", "carousel music", "engine whirring", "thudding", "xylophone melody", "birds chirping", "electronic music", "children’s music", "children’s toy music"] | 7 | ZsmxO0wnqdQ | 3423 |
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;