musiccaps_details (view)
3 rows where musiccaps_aspects contains "mellow" and musiccaps_aspects contains "sustained strings melody"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- low quality 3
- mellow · 3 ✖
- soft 3
- sustained strings melody · 3 ✖
- sad 2
- shimmering bells 2
- arpeggiated acoustic guitar melody 1
- emotional 1
- groovy bass 1
- mellow piano melody 1
- mellow woodwind melody 1
- muffled female soft vocal 1
- passionate male vocal 1
- reverberant flat male vocal 1
- shimmering hi hats 1
- walking on concrete sound 1
- wide arpeggiated piano melody 1
musiccaps_names (array) 6 ✖
- Music 3
- Tender music 2
- Humming 1
- New-age music 1
- Sad music 1
- Speech 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Fawn Rescue | The low quality recording features a wide arpeggiated piano melody, sustained strings melody, mellow woodwind melody and shimmering bells over which the passionate male vocalist is singing at the very end of the loop. There is also the sound of walking on concrete. It sounds mellow, soft and sad. There is also the sound of walking on concrete. | 2011-06-21T06:56:26Z | Darren Jesse | Fawn rescued from pool on its last breath and reunited with its mother. Song: "Abba Father" by Christ Our Life - www.christourlife.ca. Song: "I Will Never Leave You" by Jay Stocker - www.scripture-lullabies.com | ["Music", "Sad music"] | ["walking on concrete sound", "low quality", "wide arpeggiated piano melody", "sustained strings melody", "mellow woodwind melody", "shimmering bells", "mellow", "soft", "passionate male vocal", "sad"] | 4 | 6CaZAITdAsk | 735 | |
TF2 Song: "Spy Sapping My Sandwich" | The low quality recording features a reverberant flat male vocal singing over sustained strings melody, mellow piano melody, shimmering bells melody, shimmering hi hats and groovy bass. It sounds emotional, mellow and soft. | 2008-02-05T17:17:14Z | creamfortress | Team Fortress 2 Song: Spy Sapping My Sandwich. (TF2) Produced by the Dead Workers Party as part of Control Point, a TF2 Podcast. http://deadworkers.com/tf2/ --- For music downloads. Please visit: http://deadworkers.com/community/viewtopic.php?f=4&t=409 thanks | ["Music", "Speech", "Tender music"] | ["low quality", "reverberant flat male vocal", "sustained strings melody", "mellow piano melody", "shimmering bells", "shimmering hi hats", "groovy bass", "emotional", "mellow", "soft"] | 4 | 9ohu45KlgYA | 1044 | |
Creepy Music Joker | The low quality recording features a muffled female soft vocal singing over sustained strings melody and arpeggiated acoustic guitar melody. It sounds mellow, soft and sad - even though the quality is bad. | 2009-06-13T06:28:50Z | b3your0wnp3t | To all the Jokers...not all of them are Heath Ledger... | ["Humming", "New-age music", "Music", "Tender music"] | ["low quality", "muffled female soft vocal", "sustained strings melody", "arpeggiated acoustic guitar melody", "mellow", "soft", "sad"] | 4 | rez5KDmIZoc | 4890 |
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;