musiccaps_details (view)
3 rows where search matches "guitar" and "youtube_published" is on date 2013-10-18 sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- acoustic guitar 1
- ambient 1
- arpeggiated electric guitar melody 1
- atmospheric synthesiser 1
- calming atmosphere 1
- dark 1
- depressed 1
- digital drums 1
- easygoing 1
- emotional 1
- flat male vocal 1
- girl voices 1
- gloomy 1
- grim 1
- groovy bass guitar 1
- instrumental 1
- intense 1
- intense electric guitar 1
- low quality 1
- paper wrapper 1
- rock 1
- sad 1
- shimmering hi hats 1
- slow tempo 1
- snappy rimshot 1
- soft kick 1
- sombre 1
- sound of metal clanging 1
- sustained electric guitar melody 1
- vocal harmony 1
musiccaps_names (array) 7 ✖
- Music 3
- /t/dd00004 1
- Bass guitar 1
- Country 1
- Harmonic 1
- Sad music 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
DEF LEPPARD - "Goodbye" (Official Music Video) | The low quality recording features a rock song that consists of flat male vocal singing over sustained and arpeggiated electric guitar melodies, followed by snappy rimshots, soft kick, shimmering hi hats and groovy bass guitar. It sounds emotional and easygoing. | 2013-10-18T15:47:22Z | DEF LEPPARD | Get tickets to Def Leppard's 2020 Stadium Tour with Mötley Crüe and special guests Poison & Joan Jett here: https://defleppard.com Subscribe to our channel for new videos: http://bit.ly/LeppardYT Def Leppard’s Full Catalog Now Available to Stream & Download Worldwide: https://UMe.lnk.to/DefLeppardDigital ___________ LISTEN TO DEF LEPPARD: Apple/iTunes: https://DefLeppard.lnk.to/itunesapple Spotify: https://ume.lnk.to/DefLeppardDigital/spotify Amazon: https://ume.lnk.to/DefLeppardDigital/Amazon Deezer: https://ume.lnk.to/DefLeppardDigital/Deezer Pandora: https://ume.lnk.to/DefLeppardDigital/pandora FOLLOW DEF LEPPARD: Website: http://www.DefLeppard.com/ YouTube: https://www.youtube.com/defleppard Instagram: http://instagram.com/DefLeppard Facebook: https://www.facebook.com/DefLeppard Twitter: https://twitter.com/DefLeppard Publisher: http://www.PrimaryWave.com | ["Music", "Sad music"] | ["low quality", "rock", "flat male vocal", "groovy bass guitar", "sustained electric guitar melody", "arpeggiated electric guitar melody", "snappy rimshot", "soft kick", "shimmering hi hats", "easygoing", "emotional"] | 4 | -M-6VinyMiY | 37 | |
The Stellas with Lennon and Maisy - Believe | The music features a few girl voices singing a melody in harmony. An acoustic guitar accompanies the singers with strummed chords. The overall atmosphere is calming and moving at the same time. | 2013-10-18T07:20:24Z | TheMJ1025 | The Stellas are joined by daughters Lennon and Maisy from ABC's Nashville at 3rd & Lindsley 10/16/13 | ["Singing", "Country", "Music", "/t/dd00004"] | ["girl voices", "vocal harmony", "acoustic guitar", "calming atmosphere"] | 2 | 9zW-E0XdWdw | 1053 | |
BIPOLAR || SHORT FILM | This music is a grim instrumental. The tempo is slow with a sombre electric guitar melody with atmospheric synthesiser and mood digital drums. The music is serious, intense, melancholy, pensive, cheerless, sinister and dark. | 2013-10-18T06:04:44Z | reduxproductions | WATCH IN HD A short film about a particular man's life. Sometimes our repetitive daily functions block our way of perceiving the world through a much more versatile point of view thus leaving us unaware of our nearest surroundings and our unwilling interactions with others in general. Thank you for watching. If you liked it - feel free to show some love. A film by Janis Jurgelis and Joshua Behrens. Music can be found here _ https://www.facebook.com/pages/TTOO/185504748288143 https://www.facebook.com/OfficialLeet Equipment used _ Canon 60D using Magic Lantern Canon 50mm f/1,4 Canon 18-55mm f/3,5-5,6 Kit Lens Flycam DSLR Nano | ["Bass guitar", "Music", "Harmonic"] | ["instrumental", "slow tempo", "intense electric guitar", "atmospheric synthesiser", "digital drums", "ambient", "dark", "sombre", "grim", "intense", "depressed", "sad", "sound of metal clanging", "paper wrapper", "gloomy"] | 7 | negr4U79PUE | 4567 |
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;