musiccaps_details (view)
17 rows where musiccaps_aspects contains "medium tempo" and musiccaps_aspects contains "melodic"
This data as json, CSV (advanced)
musiccaps_aspects (array) 178 ✖
- medium tempo · 17 ✖
- melodic · 17 ✖
- emotional 8
- instrumental 7
- sentimental 6
- steady drumming 6
- ambient 5
- pleasant 5
- soothing 5
- male vocalist 4
- rhythmic acoustic guitar 4
- romantic 4
- youthful 4
- engaging 3
- foreign language 3
- groovy 3
- mellow 3
- passionate 3
- pop 3
- soft pop 3
- soft rock 3
- soul 3
- string instrument 3
- acoustic guitar 2
- amateur recording 2
- atmospheric synthesiser 2
- brass band 2
- calming 2
- cheerful 2
- dulcet 2
- electric guitar 2
- female vocalist 2
- keyboard harmony 2
- male singer 2
- no lyrics 2
- peaceful 2
- pop rock 2
- r&b 2
- slick drumming 2
- smooth 2
- soulful 2
- static 2
- vocal backup 2
- vocalisation 2
- world music 2
- young love 2
- abrupt end 1
- acoustic guita 1
- african 1
- amateur 1
- amplified guitar 1
- atmospheric 1
- bass guitar accompaniment 1
- boomy 1
- bow stringed instrument 1
- boy band 1
- brass 1
- brass instrument 1
- calm 1
- captivating 1
- charming 1
- chimes 1
- chord progression 1
- chords 1
- church organ harmony 1
- classical 1
- complimentary harmony 1
- country music 1
- cymbals 1
- deep 1
- dexterous 1
- digital drums 1
- e-bass 1
- electric guitar lead 1
- electro pop 1
- electronic music 1
- eloquent 1
- emotional punchy bass line 1
- euphonious 1
- female choral backup 1
- female singer 1
- female vocal backup 1
- flute 1
- folk music 1
- folk song 1
- funk rock 1
- funky 1
- funky bass 1
- funky bass line 1
- funky bass lines 1
- funky drumming 1
- groovy bass line 1
- groovy digital rhythm 1
- groovy electric guitar 1
- hand percussion 1
- harmonic 1
- hip-hop 1
- home recording 1
- home video 1
- impactful 1
- insistent 1
- inspirational 1
- intense 1
- intense bass lines 1
- intense electric guitar 1
- k-pop 1
- k-pop hips 1
- keyboard accompaniment 1
- korean song 1
- lingering 1
- lively tempo 1
- loneliness 1
- loud 1
- loud feedback 1
- love song 1
- lush 1
- madal 1
- meditative 1
- melancholic melody 1
- mellifluous 1
- melodic violin harmony 1
- melodious piano accompaniment 1
- minimalist 1
- moving 1
- neo soul 1
- nostalgia 1
- nostalgic 1
- of static 1
- pensive 1
- people talking 1
- perfectly synced 1
- perky 1
- persuasive 1
- piano accompaniment 1
- plucking 1
- poignant 1
- pop hits 1
- psychedelic 1
- recurring 1
- reggae 1
- regional music 1
- regret 1
- repetitive 1
- resounding 1
- romantic piano 1
- sadness 1
- sarangi 1
- sedate 1
- serene 1
- shakers 1
- sharp 1
- sharp piano lead 1
- simple 1
- simple beat 1
- simple groove 1
- simple melody 1
- soft 1
- soft keyboard harmony 1
- soft soothing 1
- sonic power 1
- straight bass lines 1
- straightforward bass lines 1
- subtle bass line 1
- subtle bass lines 1
- syncopated harmony 1
- synth arrangements 1
- synth pop 1
- synthesiser arrangement 1
- synthesiser arrangements 1
- tambourine beats 1
- trance 1
- trip hop 1
- trippy 1
- trumpets 1
- vibrations 1
- violin accompaniment 1
- warm 1
- wedding song 1
musiccaps_names (array) 36 ✖
- Music 14
- Distortion 3
- Electric guitar 3
- Soul music 3
- Acoustic guitar 2
- Effects unit 2
- Independent music 2
- Musical instrument 2
- Plucked string instrument 2
- Reggae 2
- Rhythm and blues 2
- Song 2
- Wedding music 2
- /t/dd00004 1
- /t/dd00032 1
- Ambient music 1
- Bass guitar 1
- Blues 1
- Bowed string instrument 1
- Brass instrument 1
- Chorus effect 1
- Drum and bass 1
- Dubstep 1
- Exciting music 1
- Flamenco 1
- Funk 1
- Guitar 1
- Hip hop music 1
- Music of Africa 1
- Pop music 1
- Sad music 1
- Singing 1
- Strum 1
- Traditional music 1
- Trumpet 1
- Violin, fiddle 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Tedeschi Trucks Band - Midnight in Harlem (Live from Atlanta) | This music is a melodic instrumental. The tempo is medium with a captivating electric guitar lead, rhythmic acoustic guitar, funky bass line, keyboard accompaniment, steady drumming and trumpets. The music is soothing, atmospheric, euphonious, youthful, and soulful. This instrumental is a Soft Rock/Funk pop. | 2011-08-18T07:00:00Z | TedeschiTrucksVEVO | Music video by Tedeschi Trucks Band performing Midnight in Harlem (Live from Atlanta). (C) 2011 Sony Music Entertainment | ["Blues"] | ["instrumental", "medium tempo", "electric guitar lead", "ambient", "steady drumming", "groovy bass line", "trumpets", "melodic", "pleasant", "funky", "groovy", "soft rock", "pop rock", "funk rock", "youthful", "atmospheric", "brass band", "soul", "neo soul", "soothing", "rhythmic acoustic guitar"] | 7 | -wVWjl9Kq6U | 104 | |
BEAST/B2ST - Clenching A Fist Tight | A male vocalist sings this soft Korean Melody. The tempo is medium with a romantic piano accompaniment, steady drumming, simple bass lines, chimes, synthesiser arrangements and male vocal backup. The song is a soft, mellow, romantic, emotional, sentimental, dulcet, melodic love song. This song is a Korean Soft Pop/K-pop song. | 2010-09-17T04:03:08Z | megcapati | BEAST's 3rd Mini Album MASTERMIND. SUPPORT BEAST BUY BUYING THEIR 3RD MINI ALBUM MASTERMIND! :D :D :D ~~ Another awesome ballad. Perfect song to listen to if you want to cry. ~~ CHECK OUT MY OTHER VIDEOS :D Twitter: http://www.twitter.com/meggiewegsss Tumblr: http://www.meggiewegsss.tumblr.com Facebook: http://www.facebook.com/meggiewegsss B2STLYB2UTIES website coming soon~♥ Twitter: http://www.twitter.com/B2STLYB2UTIES Facebook: http://www.facebook.com/pages/B2stlyb2uties/144520828909598 Every 2 weeks is the birth of a new parody made by EMDEE Parodies ^_^v Twitter: http://www.twitter.com/EMDEEparodies YouTube: http://www.youtube.com/user/EMDEEparodies | ["Music", "Pop music", "Soul music"] | ["male vocalist", "medium tempo", "dulcet", "sentimental", "emotional", "love song", "melodic", "world music", "k-pop hips", "youthful", "young love", "soft soothing", "romantic piano", "steady drumming", "straightforward bass lines", "chimes", "atmospheric synthesiser", "boy band", "vocal backup", "ambient", "pop", "soft pop", "romantic", "pleasant", "emotional", "melodic", "foreign language", "korean song", "k-pop"] | 7 | 0F-Z0zF1504 | 138 | |
Brimstone Audio Crossover Distortion (electric bass demo) | Someone is playing a bass melody through a distortion effect. This song may be playing bass at home. | 2013-09-01T07:32:26Z | Brimstone Audio | The Crossover Distortion is a multi-band distortion pedal with a variable crossover, two independent cascaded mosfet overdrive circuits, and a mixer. Low and high frequencies are split by the crossover and sent their own dedicated overdrive circuit. Low and high frequencies do not interfere with each other, and can be dialed in independently. Multi-band distortion is a breakthrough for bass guitar players who want to achieve high levels of gain and distortion, while still retaining a robust low end. All the goodness of bi-amping, built in to a stompbox. The Crossover Distortion retails for $299. To find authorized dealers, please visit www.brimstoneaudio.com Video by David Beers from Brimstone Audio. | ["Bass guitar", "Effects unit", "Music", "Distortion"] | ["amateur recording", "e-bass", "medium tempo", "melodic"] | 6 | 6pHo6fPdPvM | 791 | |
Michael ofori ogyegyentwie ghana gospel music | A male vocalist sings this sweet melody in a foreign language. The tempo is medium with keyboard accompaniment, steady drumming, synthesiser arrangement and acoustic guitar. The song has a simple, easy melody. It is earnest, emotional, calm and soothing. This song is a Regional Pop song. | 2009-04-20T09:40:57Z | gimwhp | Michael Ofori, Ghanaian born live in the United States. Singer of Gospel music. | ["Music of Africa", "Funk", "Music", "Reggae", "Rhythm and blues", "Soul music", "Exciting music"] | ["male singer", "medium tempo", "foreign language", "world music", "keyboard accompaniment", "steady drumming", "straight bass lines", "synth arrangements", "african", "melodic", "calm", "simple groove", "acoustic guitar", "romantic", "emotional", "peaceful", "serene"] | 7 | D3FyfFIKLVc | 1430 | |
{Hetalia} Hetaoni: Never enter the mansion. | A female vocalist sings this melodic Soft Rock. The tempo is medium with intense electric guitar harmony, keyboard accompaniment, synthesiser arrangements, steady drumming and subtle bass. The vocals are soft and melodic . The song is passionate, emotional, euphonious, simple, fresh and pleasant. This song is contemporary soft rock. | 2011-12-11T14:23:00Z | kaida55 | ♥Hetalia MEP video♥ ♥Watch in HD ♥ ---------------------- 100+ fav in less than a week? Thanks from everyone who made a part in this video. And again people, thank you so much! Thanks for the 600+ fav in less than a half year time :D Thanks for 1500+ fav! -------------------------------- Parts: 0:00 -- 0:20 hetaliafan41 0:20 -- 0:40 EndlessxRequiem 0:40 -- 1:00 sxrlove06 1:00 -- 1:20 001Dragonheart 1:20 -- 1:40 Irosama0410 1:40 -- 2:00 rose103097 2:00 -- 2:20 XxSilverCharmxX2 2:20 -- 2:40 TimefulAngel 2:40 -- 3:00 Goldenstar7z 3:00 -- 3:20 kaida55 3:20 -- 3:40 melancholywish 3:40 -- 3:56 animerockz290 HetaOni images, and the latest uploads: http://hetaoni.tumblr.com/ | ["Independent music"] | ["female singer", "medium tempo", "intense electric guitar", "keyboard harmony", "steady drumming", "keyboard harmony", "synthesiser arrangements", "electronic music", "electro pop", "synth pop", "melodic", "youthful", "passionate", "emotional", "pleasant", "pop rock", "soft rock"] | 7 | EHm7vLZewS0 | 1542 | |
Ron Gelinas - Do Not Let It End [ROYALTY FREE MUSIC] | A female vocalist sings this melodic song. The tempo is medium with female vocalisation, female choral backup, groovy bass lines,slick drumming, church organ harmony, and a lively piano accompaniment that comes in at the end of this clip. The song is pleasant, melodic, insistent, repetitive and recurring like a chant or trance. This song is a soul music/ Trip Hop. | 2015-02-10T23:58:59Z | Ron Gelinas Chill Beats | Available to use “Royalty Free” on YouTube or Twitch. Join me for “Chill Soul, R&B, Funk, Jazz and Lo-Fi Beats & Vibes” on Spotify: https://spoti.fi/3fGrS7z OR YouTube Music: https://bit.ly/3gZcJBZ See full catalogue of Ron Gelinas ROYALTY FREE MUSIC on YOUTUBE at: https://goo.gl/PX8Tqc OR on SPOTIFY at: https://goo.gl/6wfhVZ FREE DOWNLOAD: https://soundcloud.com/atmospheric-music-portal/dont-let-it-end-downtempo-trip-hop Please provide following credit in video description: ➞ Artist: Ron Gelinas ➞ Track Title: Don’t Let It End (original mix) ➞ Link to Track: https://youtu.be/UnFEqUWTefM | ["Drum and bass", "Music", "Rhythm and blues", "Song", "Dubstep", "Ambient music", "Hip hop music"] | ["female vocalist", "medium tempo", "vocalisation", "no lyrics", "trip hop", "melodic", "female choral backup", "groovy digital rhythm", "church organ harmony", "funky bass", "melodious piano accompaniment", "repetitive", "insistent", "recurring", "hip-hop", "r&b", "soul", "psychedelic", "trance", "trippy", "mellow", "meditative"] | 7 | UnFEqUWTefM | 2942 | |
Musica Triste in Eb minor Pianoforte - Sad Music LADY OSCAR arr. by Coski | This music is a mellow instrumental. The tempo is medium with a passionate violin harmony and a simple, sharp piano melody with intense bass lines. The overall mood of the music is deep, sad, lonely, melancholic, nostalgic and poignant and yet beautiful and pleasant. | 2011-07-19T12:20:21Z | JC Piano | SHEET MUSIC/SPARTITO: (9,99 euro) INFO: INFOJCPIANO@GMAIL.COM [ITA] Dal celebre cartone di Lady Oscar ecco la musica sul finale triste di questo fantastico Anime. E' una versione arrangiata da me e fedelissima all'originale. La musica si divide in 2 parti. La prima parte solo Pianoforte e Basso ( musica completa ), e la seconda parte che riprende il tema iniziale ma con l'uso di Celesta, Viola, Basso, Chitarra, Violino e Piano. Lo spartito è in vendita sia in PDF che in versione cartacea. Spedisco lo spartito in versione completa. Si tratta di uno sparito rarissimo ( mai commercializzato al pubblico ). Postate pure le vostre critiche/commenti cosicché possa migliorare le mie perfomance. [ENG] From the famous cartoon of Lady Oscar here is the music on the sad ending of this fantastic Anime. It 'a version arranged by me and faithful to the original. The music is divided into 2 parts. The first part only Piano and Bass (full music), and the second part that echoes the opening theme but with the use of Celesta, Viola, Bass, Guitar, Violin and Piano. The score is on sale in both PDF and printed version. I ship the score in the full version. It is a rare disappeared (never marketed to the public). Also posted your criticism / comments so that I can improve my performance. | ["Music", "Sad music"] | ["instrumental", "medium tempo", "intense bass lines", "regret", "deep", "melodic violin harmony", "sharp piano lead", "syncopated harmony", "intense", "pensive", "melodic", "melancholic melody", "nostalgia", "sadness", "loneliness", "poignant"] | 7 | Vx_vqfpRdUU | 3046 | |
Top 15 Acoustic Guitar Players | This music is an acoustic guitar instrumental. The tempo is medium with the guitarist playing a dulcet harmony on an acoustic guitar. The music is calming,soothing, melodic, eloquent, moving and emotional. | 2009-03-21T20:21:51Z | alexguitarmusic | Here is my list of the top 15 acoustic guitar players 15. Petteri Sariola 14. Kotaro Oshio 13. Justin King 12. Erik Mongrain 11. Kaki King 10. Peppino D'Agostino 9. Antoine Dufour 8. Andy Mckee 7. Stephen Bennett 6. Steven King 5. Don Ross 4. Chet Atkins 3. Lenny Breau 2. Tommy Emmanuel 1. Michael Hedges I would be interested to see what other people would consider their top 15 acoustic guitar players... add your list to the comments section, or maybe make a video response! | ["Flamenco", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["instrumental", "medium tempo", "mellifluous", "calming", "soothing", "melodic", "eloquent", "moving", "emotional", "plucking", "dexterous", "mellow", "soothing", "calming"] | 7 | XS-3djsJWTA | 3185 | |
"Be My" Best Wedding Song | A male vocalist sings this smooth Soul melody. The tempo is medium with a mellow piano accompaniment, steady drum machine beats, atmospheric synthesiser and subtle bass with backup vocals. The song is soft, ambient, passionate, emotional, mellifluous ,sentimental and warm. This song is a contemporary R&B/Soul. | 2010-02-21T22:49:47Z | STUDIO8MILE | None | ["Music", "Wedding music"] | ["male vocalist", "medium tempo", "piano accompaniment", "soft", "passionate", "emotional", "sentimental", "warm", "young love", "wedding song", "slick drumming", "atmospheric synthesiser", "digital drums", "funky bass lines", "soul", "r&b", "ambient", "soulful", "melodic", "smooth", "lush", "vocal backup", "resounding"] | 7 | ZUkh168Nyus | 3384 | |
Danelectro FAB Chorus D 5 | This music is an electric guitar instrumental. The tempo is medium with a loud and energetic riff . The audio quality is inferior as it is a Home recording ,which is why the music is boomy and there are sounds of people talking in the background and some static. | 2010-11-01T07:01:01Z | musicnbooksdotcom | ["Effects unit", "Electric guitar", "Acoustic guitar", "Music", "Musical instrument", "Chorus effect", "Strum", "Plucked string instrument", "Distortion"] | ["acoustic guitar", "instrumental", "medium tempo", "static", "abrupt end", "string instrument", "chords", "chord progression", "vibrations", "sonic power", "loud feedback", "boomy", "people talking", "electric guitar", "amplified guitar", "amateur", "melodic", "of static", "loud", "sharp", "amateur recording", "home video"] | 7 | bqvl7IbPteU | 3659 | ||
Dave and John ....pedal steel and telecaster | This music is an electronic guitar instrumental. The tempo is medium with a harmonious electric guitar lead, steady drumming, subtle bass ,tambourine beats and synthesiser arrangement. The music is a pleasant, soothing, unhurried, calm, romantic, sentimental , sedate and lingering Electric Guitar, soft pop instrumental. | 2011-02-03T01:36:36Z | Bob Adams | David Hartley and John Stannard's duet on Chasing Rainbows.. super stuff as ever! At JD's steel meeting in the south of England Jan 2011 | ["Electric guitar", "Music", "Wedding music", "Distortion"] | ["instrumental", "medium tempo", "electric guitar", "lingering", "sedate", "romantic", "sentimental", "soft pop", "soft rock", "subtle bass lines", "steady drumming", "tambourine beats", "melodic", "pleasant", "soothing", "ambient", "romantic", "synthesiser arrangement", "steady drumming", "cymbals", "simple melody", "euphonious", "engaging", "cheerful", "sentimental", "ambient"] | 7 | bt7rDryN7G4 | 3663 | |
Fatoumata Diawara - Mandela - Blackberrys Sharp Nights:Masters of World Music (New Delhi) | This song is a vocalisation by a female singer. The tempo is medium with an upbeat electronic guitar harmony, funky bass guitar, slick drumming and acoustic guitar accompaniment. The music is simple, engaging, pleasant, melodic, engaging and has a perky groove. | 2015-02-27T17:32:18Z | Blackberrys Menswear | Fatoumata Diawara paying tribute to the late great Nelson Mandela with her hit track 'Mandela', at Blackberrys Sharp Nights:Masters of World Music. #MOWM 'The Hendrix of The Sahara' Vieux Farka Toure; performing 'Ai Du' as part of the Blackberrys Sharp Nights: Masters of World Music tour. Live at Tote on The Turf, Mumbai. #MOWM For more, visit: http://facebook.com/BlackberrysMenswear http://twitter.com/BlackberrysMens | ["Electric guitar", "Music", "Song", "/t/dd00032"] | ["female vocalist", "vocalisation", "groovy", "perky", "no lyrics", "medium tempo", "groovy electric guitar", "funky bass line", "rhythmic acoustic guitar", "mellow", "melodic", "engaging", "slick drumming", "pop", "no lyrics", "simple beat", "ambient", "smooth", "acoustic guita"] | 7 | c9tRbWSk7c4 | 3685 | |
52. F.Gossec Gavotte trumpet & violin duet La corda d'oro primo passo out track 金色のコルダ | This song is a simple instrumental. The tempo is medium with a lively tempo and melodic violin accompaniment. The tune is simple,refreshing, emphatic and mellifluous. | 2013-11-20T22:01:55Z | TheBlessingofMusic | Edited from the 26th episode(OVA) of La corda d'oro primo passo anime. The first duet of Kazuki and Kahoko was in front of the bronze statue in the 3rd episode. But this scene of the 26th(OVA) episode is just fit for this out track. Relative my OST contents:http://youtu.be/Dkls9aAh3FE Kazuki Hihara playlist http://www.youtube.com/watch?v=erHadqauC8A&index=15&list=PLOYsUxAW0KI84Uo_NCbo2R2bCC_MpQH-d Kahoko Hino Violin playlist http://www.youtube.com/playlist?list=PLOYsUxAW0KI_LgujbXJPm6kWrsFC_mQPy | ["Brass instrument", "Trumpet", "Violin, fiddle", "Bowed string instrument"] | ["instrumental", "medium tempo", "lively tempo", "brass", "brass instrument", "brass band", "string instrument", "bow stringed instrument", "perfectly synced", "complimentary harmony", "violin accompaniment", "simple", "melodic", "harmonic"] | 7 | erHadqauC8A | 3901 | |
Bob Marley & The Wailers - One Love / People Get Ready | A male vocalist sings this beautiful Reggae song. The tempo is medium with a keyboard harmony, punchy and infectious bass line and funky drumming with harmonic vocal backup. The song talks about world peace, kindness towards humankind and unity. The song is inspirational, passionate, youthful, emotional,persuasive,impactful, melodic , engaging and captivating. | 2015-05-16T05:31:51Z | doogie Five-Four | Track 12 From Bob Marley & The Wailers - The Very Best of Bob Marley & The Wailers (Limited Edition) (2001) | ["Music", "Reggae"] | ["male vocalist", "medium tempo", "keyboard harmony", "emotional", "youthful", "passionate", "emotional punchy bass line", "funky drumming", "female vocal backup", "reggae", "inspirational", "emotional", "sentimental", "persuasive", "impactful", "soothing", "melodic", "engaging", "captivating", "groovy"] | 7 | opu2tXoVNKU | 4658 | |
Baraha Jewellery, Jordan, Hong Kong | This music is instrumental. The tempo is slow with a harmonious melody of string instruments, percussion and wind instruments which sound like the Indian Sarangi, dhol or madal , shakers and a flute. The music is classical, simple, enchanting and melodic. This song is a Folk song Instrumental. | 2012-09-06T16:53:26Z | DigitalEyeHK | Baraha Jewellery, Jordan, Hong Kong. www.barahajewellery.com. FOR MORE VIDEO http://www.jpthk.com | ["Traditional music", "Music"] | ["instrumental", "medium tempo", "flute", "string instrument", "cheerful", "charming", "classical", "melodic", "sarangi", "madal", "folk music", "country music", "regional music", "folk song", "shakers", "hand percussion"] | 7 | otVPTo72q4w | 4662 | |
Arnel Pineda in AMO, 1988, singing "Lights" by Journey | A male vocalist sings this soft melody. The tempo is slow with a mellow keyboard harmony, steady drumming, subtle bass line and acoustic guitar accompaniment. The song is soft, romantic, melodic, emotional , sentimental, melancholic and pleasant. This song is classic Soft Rock. | 2008-03-22T11:10:43Z | ArnelPinedaFan | Audio only. Arnel Pineda with AMO, performing live "Lights" (originally by Journey) in 1998, almost 20 years before he became Journey's lead singer. Photos from Arnel's "journey" accompany the video. NOTE: Sorry I can't approve non-English comments because I don't understand them. | ["Singing", "Music", "Soul music", "/t/dd00004"] | ["male singer", "medium tempo", "soft keyboard harmony", "steady drumming", "subtle bass line", "rhythmic acoustic guitar", "romantic", "pleasant", "soft pop", "pop", "pop hits", "romantic", "sentimental", "emotional", "nostalgic", "melodic"] | 7 | thHSYzhoLo4 | 5057 | |
ones band-kilau ku(local indie band malaysia) | A male vocalist sings this dulcet, soulful song in a foreign language. The tempo is medium with bass guitar lead and acoustic guitar accompaniment. The song is minimalist instruments with vocal emphasis. It is a soft, emotional, sentimental, mellifluous, soulful, soothing, calming, pleasant , warm and tender Pop. | 2010-06-15T15:54:19Z | faqul23 | layan sja... | ["Music", "Independent music"] | ["male vocalist", "medium tempo", "foreign language", "bass guitar accompaniment", "rhythmic acoustic guitar", "home recording", "static", "melodic", "dulcet", "soulful", "emotional", "sentimental", "minimalist", "soothing", "peaceful", "calming"] | 7 | uZesGREO0eI | 5125 |
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;