musiccaps_details (view)
18 rows where musiccaps_aspects contains "emotional", musiccaps_aspects contains "instrumental music" and musiccaps_aspects contains "romantic"
This data as json, CSV (advanced)
musiccaps_names (array) >30 ✖
- Music 10
- Bowed string instrument 3
- Musical instrument 3
- Cello 2
- Double bass 2
- Guitar 2
- Keyboard (musical) 2
- Orchestra 2
- Plucked string instrument 2
- Violin, fiddle 2
- Accordion 1
- Acoustic guitar 1
- Banjo 1
- Bass guitar 1
- Brass instrument 1
- Classical music 1
- Country 1
- Dance music 1
- Distortion 1
- Electric guitar 1
- Electric piano 1
- Electronic organ 1
- Flamenco 1
- Flute 1
- Harp 1
- Harpsichord 1
- Jazz 1
- Mandolin 1
- Opera 1
- Organ 1
- …
musiccaps_aspects (array) >30 ✖
- emotional · 18 ✖
- instrumental music · 18 ✖
- romantic · 18 ✖
- medium tempo 11
- passionate 10
- poor audio quality 7
- western classical music 6
- live performance 5
- bad audio quality 4
- home video 4
- melancholic 4
- soloist 4
- conductor 3
- great composers 3
- groovy 3
- live audience 3
- love song 3
- opera hall 3
- philharmonic orchestra 3
- sentimental 3
- youtube music video 3
- ambient noises 2
- average audio quality 2
- bass guitar 2
- cheerful 2
- composers 2
- entertaining 2
- fingering technique 2
- groovy bass line 2
- groovy music 2
- …
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Tubular Bells (Start of the 2nd part) on Theremin | The song is an instrumental. The song is in slow tempo with a theremin playing a melancholic melody with a guitar accompaniment. The song is emotional and lilting. The audio quality is poor. | 2007-05-29T15:55:35Z | DANI ROTTENBRAIN | Versión thereministica del principio de la segunda parte de tubular bells de Mike Oldfield | ["Music", "Theremin"] | ["theremin", "emotional", "guitar accompaniment", "poor audio quality", "romantic", "love song", "endless love", "forever together", "ambient noises", "youtube music video", "beautiful love", "pure and innocent", "live performance", "live audience", "melancholic music", "instrumental music", "slow tempo", "emotional", "sad"] | 1 | 03frQGyrgQ4 | 114 | |
Dr.House Jazz Music season1 ep.9 "DNR" | The song is an instrumental jazz tune. The tempo is medium with steady drumming with drum brushes and other percussive hits, piano accompaniment, guitar accompaniment, groovy bass line and a muted trumpet playing a cool solo. The song is a jazz improvisation of a romantic melody. | 2010-12-11T17:42:03Z | manonfio | hi here s the jazz song of the oldest episode of house ep9 season 1 "DNR" I DUNNO the album or compositor, simply found it in the web enjoy P.S. if my english is bad sorry about that need study more lol p.s.2.-If someone knows the compositor or album song plz share ur knowledge with the world i want more of this. | ["Jazz", "Music", "Dance music"] | ["jazz music", "instrumental music", "medium tempo", "relaxing playlists", "comfort", "movie soundtrack", "warmth", "drum brushes", "piano accompaniment", "guitar accompaniment", "percussive bass line", "smooth", "jazz hits", "tv show theme", "jazz hits", "lounge jazz hits", "cymbal strikes", "instrumental music", "emotional", "sentimental", "romantic", "passionate", "love song", "muted trumpet solo", "double bass"] | 1 | 1ypKEH2kd7g | 322 | |
PARARCA - OCT - 2013 - ARPA Y VIOLIN (A) | The song is instrumental. The tempo is medium with a harpist playing a bass line accompanying a violist. The song is folk-like with a dance rhythm. The audio quality is poor with ambient crowd noise. | 2013-11-01T18:51:07Z | Johnny Torres | ["Harp", "Violin, fiddle", "Pizzicato", "Bowed string instrument"] | ["harpist", "violinist", "dance music", "groovy bass line", "instrumental music", "couples dan", "family gatherings", "poor audio quality", "romantic", "south american folk music", "folk dance music", "instrumental duo", "people talking", "ambient crowd noises", "medium tempo", "sentimental", "emotional", "cheerful", "positive", "festive spirit", "togetherness", "traditional custom dance"] | 1 | 8DQbnR7hwpc | 904 | ||
J.S.Bach - Cello Suite No.1 - Prelude - Double Bass | The song is an instrumental. The tempo is medium with a cellist playing a JS Bach tune with exemplary skill in a rehearsal session. The song has bad audio quality. The song is a western classical music tune. | 2014-09-03T19:30:44Z | TESEO | J.S.Bach - Suite No.1 for Double Bass BWV 1007 - Prelude - Plays Francesco Tesei - New Fan Page - https://www.facebook.com/Teseoguitar - SUBSCRIBE! http://www.youtube.com/user/teseoguitar?sub_confirmation=1 | ["Cello", "Double bass", "Bowed string instrument"] | ["cello suite", "cello", "cellist", "home video", "emotional", "passionate", "romantic", "nostalgic", "instrumental music", "medium tempo", "bad audio quality", "western classical music", "bach", "practice session", "live recording", "exciting", "low pitched notes", "strings", "soundboard", "fingering technique", "bow", "studio session", "great composers", "soloist"] | 1 | B1ixRtiUJ-U | 1194 | |
Sad Classical Guitar Music - Lost Melody | The song is an instrumental. The song is in medium tempo with a classical guitar playing a lilting melody in accompaniment style. The song is emotional and romantic. The song is a romantic instrumental song. | 2013-10-16T02:38:43Z | Graham Daniel McLaughlin | Instruments used: Acoustic Guitar (Classical), Violin Soundcloud: https://soundcloud.com/graham-daniel-mclaughlin/sad-classical-guitar-music (Free Download) Spotify: https://open.spotify.com/track/5KceXwi3K9TiRaw6JCbB0I Apple Music: https://music.apple.com/us/album/lost-melody/1457733757?i=1457733762 iTunes: https://music.apple.com/us/album/lost-melody/1457733757?i=1457733762&app=itunes Amazon Music: https://music.amazon.com/albums/B07Q2KSY5S?trackAsin=B07Q2KF8RW&ref=dm_sh_b07e-7fb5-dmcp-49ae-e76f6&musicTerritory=US&marketplaceId=ATVPDKIKX0DER Facebook: https://www.facebook.com/DreamsOfGraham Guitar Tabs: https://docs.google.com/document/d/14OOCK3J1SYLxRuwKfnAvQcS70mbRWrJ6eQuIY5Bf20E/edit?usp=sharing ______________________________ Made this song today, just thinking about schooling and all what's expected of people to be part of a society. Sometimes I just can't live up to the robotic terms, and I may end up creating stuff like this. ______________________________ All audio material owned by © Graham Daniel McLaughlin ℗ Graham Daniel McLaughlin Song inspired by this artwork: http://reyed33.deviantart.com/art/1-Lost-Melody-207902132 The artist of the picture used is unknown, I really wish I could give them credit and a thanks. I downloaded it from nik.bot.nu. | ["Music", "Sad music"] | ["spanish guitar", "guitar solo", "soloist", "emotional music", "beautiful landscapes", "twilight", "pleasant", "the good life", "instrumental hits", "celtic music", "classical guitar hits", "harmony", "instrumental music", "fret noises", "emotional", "relaxing", "in love with you", "melancholic", "life is beautiful", "comforting", "romantic", "groovy"] | 1 | KHjEIheD-Cg | 2072 | |
Japanese Classical Music | The song is an instrumental. The song is medium tempo with a flute paging embody, various stringed instruments playing in harmony and no percussion. The song is passionate and emotional. The audio quality is average . | 2008-07-19T05:20:35Z | MichiganWinters | Hello | ["Music", "Classical music"] | ["japanese folk music", "flute playing", "average audio quality", "traditional japanese music", "rich ancestry", "melancholic", "poignant", "stringed instrument harmony", "instrumental music", "melancholic", "no percussions", "medium tempo", "emotional", "romantic", "grief", "hopeful", "myriad of emotions", "tremolo strings"] | 1 | N-dzfI3L5ic | 2315 | |
Frank Heinen auf der Wersi-Orgel in Konzert! | The song is an instrumental. The tempo is medium with a groovy bass line, keyboard accompaniment, percussive bass line , steady drumming drumming and other percussion hits. The song is a pop song cover with a bad audio quality. | 2009-08-26T20:34:40Z | derjaschka | Ausschnitte von diversen Veranstaltungen 2009! https://www.facebook.com/frankheinenwersi | ["Organ", "Electric piano", "Electronic organ", "Keyboard (musical)", "Piano"] | ["church organ playing", "instrumental music", "passionate", "emotional", "romantic", "love song", "greatest love sings", "song cover", "live performance", "ambient noises", "bad audio quality", "medium tempo", "ethereal harmony", "bell tones", "keyboard accompaniment", "groovy bass line", "pop super hits", "retro pop hits", "romantic", "eternal love", "together forever", "never give up"] | 1 | Pgpd1yxLcLI | 2558 | |
Couperin & Clavecin | The song is an instrumental. The song is medium tempo with a harpsichord belting played with no other instrumentation. The music is emotional, passionate and melancholic. The song audio quality is poor. | 2007-10-14T21:47:21Z | profsha | Eric DEM joue Couperin au clavecin à l'église de Cesson-Sévigné. | ["Harpsichord", "Keyboard (musical)"] | ["harpsichord", "harpsichord player", "harpsichordist", "poor audio quality", "instrumental music", "medium tempo", "composers", "conductors", "live music", "live performance", "live audience", "emotional", "spirited", "romantic", "baroque music", "passionate", "western classical music"] | 1 | S38KjqRR418 | 2737 | |
Canon 70D & Instrumental de Arpa (Instrumental Harp) | The song is an instrumental. The song is medium tempo with Latin percussions, guitar strumming rhythm, groovy bass line and keyboard percussions. The song is exciting and groovy. The song has poor audio quality. | 2014-02-25T04:22:49Z | Jimmy Pastrana | Arpa: Natanael Rios Cuatro: Ferney Cotinchara Bajo: Jimmy Pastrana Maracas: Elias Pertuz | ["Music", "Salsa music"] | ["latin dance music", "guitars strumming", "traditional music", "jam session", "emotional", "passionate", "romantic", "harp player", "poor audio quality", "percussive bass line", "steady rhythm", "bass guitar", "slick percussive rhythm", "studio live sessions", "instrumental music", "latin percussions", "shakers percussions", "groovy music", "live performance"] | 1 | aT7LGemDB40 | 3541 | |
Az Baraye Ghame Man-Ahmad Zahir.wmv | The song is an instrumental. The song is medium tempo and has a delightful flute solo with keyboard accompaniment groovy bass line and a groovy drumming rhythm. The song has a poor recording quality. The song's middle eastern folk music vibes. | 2011-01-25T19:32:28Z | afgking16 | Ahmad Zahir Az Baraye Ghame Man | ["Music", "Rattle (instrument)"] | ["poor audio quality", "flute solo", "arabian music influences", "medium tempo", "folk music", "instrumental music", "steady drumming rhythm", "folk music", "strong bass line", "drum rolls", "retro songs", "entertaining", "emotional", "romantic", "passionate", "keyboard accompaniment"] | 1 | eHeUipPZHIc | 3853 | |
SLAP GUITAR • Slapping Solo Guitar Composition • Peter Luha | The song is an instrumental. The song is medium fast tempo with a bass guitar soloist playing a cool accompaniment groove with no other instrumentation. The song is passionate and energetic. The song is a bass guitar demo or a home music video. | 2011-10-26T19:29:21Z | Peter Luha - Guitarist | Enjoy my Solo Slap Guitar composition, played on my custom Framus Tennessee guitar! 😎👍🎸 🔔 If you enjoy - 𝗟𝗜𝗞𝗘, 𝗦𝗛𝗔𝗥𝗘 and 𝗦𝗨𝗕𝗦𝗖𝗥𝗜𝗕𝗘 for more, 𝗖𝗟𝗜𝗖𝗞 𝗧𝗛𝗘 𝗕𝗘𝗟𝗟 to be notified of my new videos! https://youtube.com/peterluha?sub_confirmation=1😉🎸🤘 ▶ 𝗖𝗛𝗘𝗖𝗞 𝗢𝗨𝗧 𝗠𝗬 𝗣𝗟𝗔𝗬𝗟𝗜𝗦𝗧𝗦: 𝐂𝐥𝐚𝐬𝐬𝐢𝐜𝐚𝐥 𝐌𝐮𝐬𝐢𝐜 𝐨𝐧 𝐄𝐥𝐞𝐜𝐭𝐫𝐢𝐜 𝐆𝐮𝐢𝐭𝐚𝐫: https://youtube.com/playlist?list=PL23D875E21629F892 𝐒𝐥𝐚𝐩 & 𝐓𝐚𝐩𝐩𝐢𝐧𝐠: https://youtube.com/playlist?list=PLC535FE0C41C0633B 𝐅𝐫𝐞𝐞 𝐆𝐮𝐢𝐭𝐚𝐫 𝐕𝐢𝐝𝐞𝐨 𝐋𝐞𝐬𝐬𝐨𝐧𝐬: https://youtube.com/playlist?list=PLE8F62A930572D159 𝐆𝐮𝐢𝐭𝐚𝐫 𝐋𝐨𝐨𝐩𝐬: https://youtube.com/playlist?list=PL7538637FA18C7AD1 𝐂𝐨𝐯𝐞𝐫𝐬 𝐨𝐟 𝐏𝐨𝐩𝐮𝐥𝐚𝐫 𝐒𝐨𝐧𝐠𝐬: https://youtube.com/playlist?list=PLTpm4YerEHJ1kh7McsoCiWnh4krzCUzwE 𝐀𝐜𝐨𝐮𝐬𝐭𝐢𝐜 𝐆𝐮𝐢𝐭𝐚𝐫 𝐏𝐥𝐚𝐲𝐢𝐧𝐠: https://youtube.com/playlist?list=PLTpm4YerEHJ0K_jAsR4x3pXa6ekBUPzrM 𝐌𝐮𝐬𝐢𝐜 𝐂𝐨𝐥𝐥𝐚𝐛𝐬: https://youtube.com/playlist?list=PLTpm4YerEHJ35wko5yuBPP1EwdbYsTHO7 𝐆𝐮𝐢𝐭𝐚𝐫 𝐓𝐞𝐬𝐭𝐬, 𝐑𝐞𝐯𝐢𝐞𝐰𝐬: https://youtube.com/playlist?list=PLTpm4YerEHJ3w5p8X47XuCIMsS44gsIx6 =============================== ▶ Download my eBooks/pdf 𝗠𝗢𝗗𝗘𝗥𝗡 𝗚𝗨𝗜𝗧𝗔𝗥 𝗧𝗘𝗖𝗛𝗡𝗜𝗤𝗨𝗘𝗦 𝗜𝗡 𝗣𝗥𝗔𝗖𝗧𝗜𝗖𝗘 (sheet music + TAB), that also contain this exercise: here: https://peterluha.com/product-category/sheet-pdf Each lesson is based on one guitar technique (guitar slap, tapping, arpeggios, sweep picking, legato, alternate picking..). In practicing these types of guitar lessons you can get a better idea how to use various techniques in specific songs. So keep practicing! 😉🎸 =============================== ▶ 𝗖𝗢𝗡𝗧𝗔𝗖𝗧 & 𝗕𝗢𝗢𝗞𝗜𝗡𝗚: https://peterluha.com/contact ▶ 𝗙𝗢𝗟𝗟𝗢𝗪 𝗠𝗘: Peter Luha - Guitarist 𝐖𝐞𝐛: https://peterluha.com 𝐈𝐧𝐬𝐭𝐚𝐠𝐫𝐚𝐦: https://instagram.com/peterluha 𝐅𝐚𝐜𝐞𝐛𝐨𝐨𝐤: https://facebook.com/peterluha.guitart 𝐓𝐰𝐢𝐭𝐭𝐞𝐫: https://twitter.com/peterluha 𝐢𝐓𝐮𝐧𝐞𝐬: https://itunes.apple.com/us/artist/peter-luha/563042778 𝐘𝐨𝐮𝐭𝐮𝐛𝐞: https://youtube.com/peterluha =============================== ▶ Feel free to write me for 𝗢𝗡𝗟𝗜𝗡𝗘 𝗚𝗨𝗜𝗧𝗔𝗥 𝗟𝗘𝗦𝗦𝗢𝗡𝗦: https://peterluha.com/online-guitar-lessons ▶ Check out my website for downloadable eBooks/pdf - 𝗚𝗨𝗜𝗧𝗔𝗥 𝗟𝗘𝗦𝗦𝗢𝗡𝗦 & 𝗦𝗢𝗡𝗚𝗦 with 𝗧𝗔𝗕𝗦: https://peterluha.com/product-category/sh… | ["Bass guitar", "Tapping (guitar technique)", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Distortion"] | ["bass guitar", "slap bass", "energetic", "echoes", "home video", "average audio quality", "passionate", "virtuoso player", "bass guitar technique", "bass guitar demo", "instrumental music", "emotional", "romantic", "groovy", "funk bass line", "guitar accompaniment style", "instrumental music", "syncopation", "enegetic", "medium fast tempo"] | 1 | eM0PkfqGmIE | 3857 | |
Michala Petri : T. Jianping's Fei Ge : DIALOGUE Gala Concert, Shanghai World Expo 2010 -- II | The song is an instrumental. The tempo is medium with a recorder being played with a lot of heart, accompanied by string section harmony. The song is emotional and has a lot of spirit. The song is a western classical music masterpiece. | 2011-01-17T04:18:55Z | OUR Recordings | Michala Petri plays Chinese music by Tang Jianping with The Shanghai Symphony Orchestra (conducted by Maestro Giordano Bellinocampi) at Shanghai World Expo 2010 - Fei Ge (Flying Song), Part II | ["Music", "Musical instrument", "Opera", "Orchestra", "Wind instrument, woodwind instrument", "Flute"] | ["recorder", "recorder player", "alto recorder", "fingering technique", "wind player", "bass recorder", "instrumental music", "string section harmony", "philharmonic orchestra", "western classical music", "music legends", "composers", "conductor", "opera hall", "emotional", "lilting melody", "romantic", "inspiring", "medium tempo", "concerto"] | 1 | fvpDYGzdRmo | 3990 | |
Chris Thile - Bach: Sonata No. 1 in G Minor, BWV 1001 (Complete) | A male ukulele player plays this emotional solo. The song is medium tempo with no other instrumentation than an ukulele playing. The song is emotional and poignant. The song is an instrumental tune. | 2013-10-14T17:44:07Z | ChrisThile | Chris Thile performs Bach's Sonata No. 1 in G Minor, BWV 1001 in full. Also featured on his album Bach: Sonatas and Partitas, Vol. I, available now on CD & vinyl from Nonesuch Records: http://punchbrothers.kungfustore.com/categories/553-bach-sonatas-and-partitas http://www.nonesuch.com/store/chris-thile iTunes: http://www.smarturl.it/thilebachitunes See Chris live on tour this fall: http://punchbrothers.com/thiletour | ["Banjo", "Music", "Mandolin", "Strum"] | ["ukulele", "ukulele player", "medium tempo", "music video", "romantic", "no percussion instruments", "music demo", "moody blues", "melancholic", "western classical music", "instrumental music", "soloist", "poignant", "entertaining", "emotional", "no percussion instruments", "home video"] | 1 | j3lH_Tevw5o | 4231 | |
CCB sax tenor hino 119 | The song is an instrumental. The song is medium tempo with a tenor saxophone playing a lilting melody in legato style. The song has no other instrumentation support. The audio quality is very poor. | 2010-01-07T21:22:33Z | Lucas Cerqueira | CCB sax tenor hino 119 | ["Brass instrument", "Saxophone"] | ["tenor sax", "amateur play", "legato playing", "poor audio quality", "saxophone lessons online", "recital", "vibrato style", "instrumental music", "no other instrumentation", "sax tonguing", "emotional", "romantic", "home video", "bad audio quality", "learner", "youtube music video", "sax cover", "passionate", "spirited", "classical music", "passionate", "no percussions", "medium tempo"] | 1 | m--xEFqqrLc | 4434 | |
Kitty (Pogues Cover) | The song is an instrumental. The song is medium tempo with an accordion playing in an accompaniment style with both medley and harmony and no other instrumentation. The music is romantic and melancholic. The audio quality is poor. | 2007-08-03T07:52:34Z | Hale Bopp | A cover of the song Kitty by the incredible Irish punk band The Pouges on my accordion. (in a different key though) Lyrics: Oh Kitty, My Darling, remember That the doom will be mine if I stay 'Tis far better to part, though it's hard to Than to rot in their prison away 'Tis far better to part, though it's hard to Than to rot in their prison away So softly he kissed her pale lips 'Twas the same story over an o'er Hush Mavourneen, the Police are watching And you know that I must go ashore Hush now Bernie, the Police are watching And you know that I must go ashore Any day I'll be over the mountain There'll be time enough left for to cry So good night and God gaurd you forever And write to me once you get by So good night and God gaurd you forever And write to me once you get by | ["Accordion"] | ["accordion player", "accordion harmony", "youtube music video", "accordion lessons", "high gain music", "bad audio quality", "soloist", "home recording", "slow tempo", "lilting music", "emotional", "cheerful", "melancholic", "groovy", "romantic", "instrumental music", "emotional", "screechy tones"] | 1 | o1E579RL33w | 4603 | |
Gwendolyn Masin plays Bartók 1st Violin Concerto; Budapest Symphony Orchestra MÁV, Teddy Abrams | The song is an instrumental. The tempo is medium with a string section accompanying the first violin playing a melancholic melody. The song is emotional and melancholic. The song is a classic western classical music piece. | 2015-11-09T00:08:13Z | Gwendolyn Masin | Palace of Arts, Bartók Béla National Concert Hall | Budapest, Hungary | Live Film courtesy of Művészetek Palotája Follow Gwendolyn on: Website - https://gwendolynmasin.com/ Facebook - https://www.facebook.com/gwendolynmasin Twitter - https://twitter.com/GwendolynMasin Spotify - https://open.spotify.com/artist/2f2StZG0SU8ud43p3bAUYQ?si=T-Y0nYeCRImUrQSn3CBACw Email - https://gwendolynmasin.com/news/newsletter Store - https://gwendolynmasin.com/shop | ["String section", "Orchestra"] | ["first violin solo", "string section", "opera hall", "great composers", "beautiful music", "legendary violinists", "tense", "eerie", "philharmonic orchestra", "conductor", "cellos", "violas", "violins", "lead melody", "instrumental music", "string orchestra", "western classical music", "vibrato", "violin virtuoso", "greta composers", "melancholic music", "romantic", "emotional", "heartfelt", "the good life", "passionate"] | 1 | q6GBCmLxNIk | 4752 | |
Nancy 🇮🇳 Rumba 🇮🇳 (Juan Serrano) | The song is an instrumental. The tempo is medium with a guitarist playing traditional flamenco style guitar in a rhumba rhythm. The song has a Latin dance groove and sounds delightful. The song has a poor audio quality. | 2015-07-07T18:32:38Z | Aman (Flamenco Guitarist) | Nancy (Rumba Flamenca) composed by Juan Serrano played by me on YAMAHA CG172SF Flamenco guitar. | ["Country", "Flamenco", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["rhumba music", "latin guitar player", "instrumental music", "medium tempo", "emotional", "romantic", "erotic", "madly in love", "couples dancing", "tango", "guitar lead", "guitar strumming", "music lesson ideo", "poor audio quality", "latin dance music", "groovy music", "solo instrumental", "groovy music", "dance rhythm", "flamenco guitar style"] | 1 | w4Z1QuBOMWU | 5236 | |
Kirito - Icaross (Orchestra Version) | The song is an instrumental. The song is slow tempo with a violin and cello playing a duet with no other instrumentation. The song is emotional and extremely heartfelt. The song is a western classical music hit. | 2007-09-07T19:31:10Z | Marcus | live from Kiritos Symphonic Concert | ["Cello", "Double bass", "Violin, fiddle", "Bowed string instrument"] | ["violin solo", "cello solo", "string duet", "heartfelt", "duet", "orchestra", "opera hall", "concert hall", "live audience", "string section", "great composers", "great vibrato", "masterful string technique", "virtuosos in play", "conductor", "live performance", "heart strings", "instrumental music", "philharmonic orchestra", "western classical music", "emotional", "romantic", "passionate", "sentimental"] | 1 | wBe5tW8iJew | 5246 |
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;