musiccaps_details (view)
122 rows where musiccaps_aspects contains "emotional" and musiccaps_aspects contains "noisy"
This data as json, CSV (advanced)
musiccaps_names (array) >30 ✖
- Music 90
- Singing 24
- Musical instrument 20
- Plucked string instrument 15
- Guitar 12
- Acoustic guitar 10
- Bowed string instrument 8
- Classical music 8
- Country 8
- Cello 7
- Keyboard (musical) 7
- Pizzicato 7
- Steel guitar, slide guitar 7
- Vocal music 7
- Choir 6
- Harpsichord 6
- Opera 6
- Strum 6
- Ukulele 6
- A capella 5
- Flamenco 5
- Harp 5
- Middle Eastern music 5
- Song 5
- Wind instrument, woodwind instrument 5
- /t/dd00004 4
- Brass instrument 4
- Carnatic music 4
- Double bass 4
- Folk music 4
- …
musiccaps_aspects (array) >30 ✖
- emotional · 122 ✖
- noisy · 122 ✖
- low quality 121
- passionate 82
- mono 50
- live performance 35
- cover 19
- passionate male vocal 19
- soulful 16
- passionate female vocal 14
- classical 11
- sad 11
- rock 10
- heartfelt 9
- sustained strings melody 9
- acoustic rhythm guitar 8
- punchy kick 8
- traditional 8
- arpeggiated acoustic guitar melody 7
- mellow 7
- shimmering hi hats 7
- flat male vocal 6
- groovy bass 6
- punchy snare 6
- reverberant 6
- fruity male vocal 5
- harpsichord melody 5
- joyful 5
- mellow piano chords 5
- playback 5
- …
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Before They Fade Away - Rebecca Pham (Official Music Video) | The low quality recording features a passionate female vocalist singing over a hollow piano melody. It sounds thin and noisy, and you can really hear the unprofessional recording technique, especially in vocals. | 2012-10-08T03:59:25Z | randomjlt | FREE MP3: http://wfurl.com/f97fd81 I had the honour of working with the talented Rebecca Pham on her first music video (and mine too). Follow me on Twitter: www.twitter.com/randomjlt Written and Performed by Rebecca Pham Directed/filmed/edited by Jay Turchansky With thanks to Harley Kennett and Drew Zielsdorf for their acting help, and to Alvin Yu for his cameo appearance. Mixed by Elisha Pham ===================== Lyrics Do the see the pain in her eyes? Or that she's been down this road so many times? And all she needs is somebody to believe in her But we just pass her by How can we say That we don't know about her pain? Turn your eyes right here Lend that listening ear Before she fades away Do you see the burden he bares? That for him, there is nobody there And all he needs is somebody's one good deed But we act as if we don't even care How can we say That we don't know about his pain? Turn your eyes right here Lend that listening ear Before he fades away How can we say That we don't know of all their pain? Turn your eyes right here Lend that listening ear Before they fade away Turn your eyes right here And lend that listening ear Before they fade away So that we can be their change | ["Music", "Sad music"] | ["low quality", "noisy", "hollow piano melody", "emotional", "sad", "heartfelt", "passionate female vocal", "thin"] | 4 | jjg0TCq3wbY | 4279 | |
Corelli Violin Sonata: Shunske Sato and Richard Egarr | The low quality, mono recording features a classical song performed by sad violin melody and harpsichord. The recording is noisy and it sounds emotional and passionate. | 2011-09-02T19:59:48Z | Academy of Ancient Music | Shunske Sato (violin) and Richard Egarr (harpsichord) perform Corelli's Sonata in D major for violin and harpsichord Op.5 No.1. Richard Egarr, Music Director of the Academy of Ancient Music, first heard Shunske when judging the 2010 Leipzig Bach Competition. Shunske was a major prizewinner. In October 2011 Shunske Sato makes his UK debut performing Paganini with the Academy of Ancient Music in Cambridge and London. Full details at www.aam.co.uk/concerts | ["Harpsichord", "Keyboard (musical)", "Violin, fiddle", "Bowed string instrument"] | ["low quality", "mono", "noisy", "classical", "sad violin melody", "harpsichord melody", "emotional", "passionate"] | 4 | kR2yBlL6nFU | 4316 | |
New York Subway's Danny Small aka Singing Dragon | The low quality recording features a live performance of a soul song and it consists of passionate male vocal singing over playback instrumentals. The instrumental consists of a shimmering tambourine layered with punchy snare hits, soft kick hits, some toms rolls, groovy bass, electric guitar melody and harmonizing male vocals. It sounds emotional, soulful, hopeful and joyful. | 2010-03-07T21:11:15Z | BayardStudios | He calls himself the "Singing Dragon", his name is Mitchell Hughes aka Danny Small of Gheechee Records LLC aka the Singing Dragon and he was performing at the 14th St/6th Ave station. Originally from South Carolina, there is logic to the moniker Singing Dragon, he was born the same year as Bruce Lee in the Chinese calendar year of the Dragon, of Puerto Rican, Dominican, Cuban, Brazilian, Mexican and Guyanese and even Chinese descent. A marvel amongst subway performers, what a wonderful way to end a walkabout. Shot with a Canon 5D Mark II, Canon 16-35mm f/2.8L, recorded with the in-camera mic and moderately mixed in Final Cut Pro 6. | ["Music", "/t/dd00003"] | ["low quality", "live performance", "noisy", "mono", "passionate male vocal", "soul", "playback instrumental", "shimmering tambourine", "punchy snare", "groovy bass", "electric guitar melody", "soft kick hits", "toms roll", "harmonizing male vocals", "emotional", "hopeful", "joyful", "soulful"] | 4 | l1coM570kVw | 4370 | |
vicente de montpellier | The low quality recording features a cover of a regional Mexican song and it consists of a passionate male vocalist singing over acoustic rhythm guitar. There are some crowd chattering and asphalt sounds in the background. The recording is noisy, in mono and it sounds passionate and emotional. | 2009-11-09T14:59:52Z | bentana100 | aqui el vicente de montpelier cantando en su barrio monteberou | ["Acoustic guitar", "Music", "Steel guitar, slide guitar", "Strum", "Plucked string instrument"] | ["low quality", "mono", "regional mexican", "passionate male vocal", "cover", "noisy", "acoustic rhythm guitar", "crowd chattering", "asphalt sounds", "low quality", "emotional", "passionate"] | 4 | lI8aGjIb8Jg | 4389 | |
Las Morenitas - La Despedida (Tonada con arpa) | The low quality recording features a cover of a regional Mexican song and it consists of harmonizing female vocals singing over a mellow harp melody and flamenco acoustic guitar melody. It sounds raw, emotional and passionate. The recording is a bit noisy and there are some car rev noises in the background. | 2013-01-28T22:29:18Z | LasMorenitas Cantoras | Tonada chilena "La despedida" interpretada por Chabelita Fuentes (arpa), Fani Flores (tormento) y Mili Ramirez (guitarra), y que juntas conforman la agrupación de cantoras "Las Morenitas", de San Vicente de Tagua Tagua. Tonada compuesta por Ana Flores Espínola, integrante de Las del Puerto, de la región de Valparaíso. Registro realizado por Diego Barrera el 16 de enero en la comuna en San Vicente de Tagua-Tagua, Región de O'higgins, Chile. Mas información y contactos: Correos: lasmorenitascantoras@gmail.com, dbarrerab@gmail.com Blog: http://lasmorenitascantoras.blogspot.com/ Mas musica en: https://soundcloud.com/las-morenitas-cantoras | ["Harp", "Pizzicato"] | ["low quality", "noisy", "car rev sound", "mellow harp melody", "harmonizing female vocals", "flamenco acoustic guitar melody", "passionate", "raw", "emotional", "cover", "regional mexican"] | 4 | mQ1E8rx2dnI | 4469 | |
Gospel Touch Gospel Choir - Amazing Grace (EXCLUSIVE) - Best Version 2022 | The low quality recording features a gospel song that contains a harmonizing mixed vocals singing. The recording is a bit noisy and it sounds emotional and passionate. | 2014-05-26T20:33:06Z | Gospel Touch | Gospel Touch Gospel Choir - Amazing Grace (EXCLUSIVE) Hire Gospel Touch Choir Recorded by: BBC1 - The One Show - Gospel Touch Version Gospel Touch Choir https://www.gtchoir.com Bookings: admin@gospeltouch.net | +447956005371 This is one of the best version of gospel song. #gospeltouch #amazinggrace #theoneshow | ["Singing", "Humming", "Music", "Choir", "Vocal music", "A capella"] | ["low quality", "noisy", "gospel", "harmonizing mixed vocals", "emotional", "passionate"] | 4 | maeSHVZX8xc | 4481 | |
The Renegades steelband plays Schubert | The low quality recording features a live performance of steel drums. It sounds exotic, passionate and emotional, even though the recording is noisy and has some audio popping sounds. | 2009-01-19T21:04:19Z | seralune | The Renegades steelband Schubert la Folle journée de Nantes en janvier 2008. | ["Music", "Musical instrument", "Percussion", "Steelpan"] | ["low quality", "noisy", "steel drums melody", "exotic", "passionate", "emotional", "audio popping sounds"] | 4 | mwLrABPxvgA | 4502 | |
Enka - itsuki hiroshi | The low quality recording features an Enka song that consists of a steel guitar solo melody, mellow bell chord progression, sustained strings melody and sustained brass melody. The recording is noisy and in mono, and it sounds emotional, heartfelt and passionate. | 2007-08-06T13:45:53Z | Ali mohammed yousof | music video | ["Music", "Ukulele", "Pizzicato"] | ["enka", "low quality", "mono", "steel guitar solo melody", "sustained strings melody", "sustained brass melody", "emotional", "heartfelt", "passionate", "noisy", "mellow bells chord progression"] | 4 | nvvXOfLs-ng | 4595 | |
【みくれれ】風になる~Full version~ | The low quality recording features a childish female vocal singing over acoustic rhythm guitar. It is a bit noisy and in mono, it sounds emotional and like a background song for some video game.. | 2011-02-14T15:10:24Z | Mikulele P | 初音ミクがウクレレでアニソンを弾き語ります。 3年目に突入の第57弾は再び「猫の恩返し」から 主題歌をリメイクしてみました。 この曲はウクレレ弾きのバイブルだけあって みくれれ内での人気も高いのですが、初期作品だけに 調教、伴奏、システムと全ての面で残念な部分も多く 何とかしたいとは思っていました。 コードも微妙に違ってるっぽいし・・・(苦笑) でもまぁ、ただリメイクしてもつまらないので 今回は2周年記念の特別企画として みくれれ初のフルサイズバージョンでお届けします。 ストラムもできるだけ原曲に忠実に再現してみましたが、 さすがにウクレレ一本だといささか単調かも? *Mikulele: "Kazeni Naru" A song from "The Cat Returns" *Chords:http://d.hatena.ne.jp/chiefer/20080427 | ["Music of Asia", "Music", "Ukulele"] | ["childish female vocal", "acoustic rhythm guitar", "noisy", "mono", "low quality", "emotional"] | 4 | p_dE26TA8ig | 4723 | |
Christina Perri - A Thousand Years Cover Lyrics | The low quality recording features a cover of a pop song and it features passionate female vocal singing over acoustic rhythm guitar. There is a quiet playback playing in the background - it sounds like it is coming from headphones. The recording is a bit resonant and noisy, but it sounds emotional and heartfelt regardless. | 2011-10-29T20:13:37Z | mariadescartes | Me singing a cover of Christina Perri's A Thousand Years Breaking Dawn soundtrack. Thanks for listening. Lyrics below. Heartbeats fast Colors and promises How to be brave How can I love when I'm afraid to fall But watching you stand alone All of my doubt suddenly goes away somehow One step closer I have died everyday waiting for you Darling don't be afraid I have loved you For a thousand years I'll love you for a thousand more Time stands still Beauty in all she is I will be brave I will not let anything take away What's standing in front of me Every breath Every hour has come to this One step closer I have died everyday waiting for you Darling don't be afraid I have loved you For a thousand years I'll love you for a thousand more And all along I believed that I would find you Time has brought your heart to me I have loved you for a thousand years I'll love you for a thousand more One step closer One step closer I have died everyday waiting for you Darling don't be afraid I have loved you For a thousand years I'll love you for a thousand more And all along I believed I would find you Time has brought your heart to me I have loved you for a thousand years I'll love you for a thousand more | ["Music", "Synthetic singing"] | ["low quality", "cover", "pop", "passionate female vocal", "acoustic rhythm guitar", "quiet playback", "noisy", "resonant", "emotional", "heartfelt"] | 4 | pqsU95TNNP8 | 4739 | |
Shinedown - Sound of Madness Guitar Cover | The low quality recording features a passionate electric guitar lick played over electric guitar chords. It sounds emotional, soulful and the recording is noisy and in mono. | 2010-11-12T17:07:08Z | UnitedWeTabDailyVid | Sound of Madness cover by Matt Hogan. | ["Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument", "Inside, small room"] | ["low quality", "noisy", "mono", "passionate electric guitar lick", "electric guitar chords", "emotional", "soulful"] | 4 | sGVzzQLcT0U | 4936 | |
Nigerian-American Wedding Gospel Music Recessional | The low quality recording features a gospel song that consists of harmonizing female vocals singing over groovy piano melody and some clapping. There are crowd talking noises in the background, while the recording is in mono and noisy. It sounds emotional, passionate and romantic - like something you would hear at weddings. | 2008-08-20T09:16:25Z | tdavidray | The wedding of the Barrow-Magnus-Lawson ceremony ended with a performance of the gospel song 'Oh Happy Day' by Edwin Hawkins. The pianist/tenor is Timothy Ray. Alto, Jasmine Perkins. Soprano, Marqueline Dejean. Lead, Patrice Parker. The wedding ceremony was held at the Second Free Mission Baptist Church in New Orleans, LA. | ["Music", "Wedding music", "Happy music"] | ["low quality", "mono", "noisy", "crowd talking", "gospel", "clapping", "harmonizing female vocals", "groovy piano melody", "passionate", "emotional", "romantic"] | 4 | sytdnmy0sRs | 4991 | |
Cover acustico Niño Soldado - Ska-P Guitarra y Armónica | The low quality recording features a cover of a song and it consists of harmonica solo melody over arpeggiated acoustic guitar melodies played a bit sloppy. It still sounds passionate and emotional. The recording is in mono and a bit noisy. | 2011-04-17T20:25:54Z | Ataque de Música | Cover acustico Niño Soldado - Ska-P Guitarra y Armónica | ["Harmonica", "Wind instrument, woodwind instrument"] | ["cover", "low quality", "noisy", "mono", "harmonica solo", "arpeggiated acoustic guitars melodies", "sloppy", "passionate", "emotional"] | 4 | t3Y9Za9roJM | 5001 | |
Yodeling Slim Clark - Queen Of The Rockies (c.1951). | The low quality recording features a soft rock song sung by a flat male vocal over mellow, acoustic rhythm guitar chords. It sounds vintage and therefore nostalgic, emotional, sentimental and warm. The recording is a bit noisy and in mono as well. | 2012-10-23T13:12:09Z | mrblindfreddy9999 | Issued on LP Pontiac "Songs Of The Trail" (1952) and EP 108 A Also Recorded 1975 Recorded Circa 1951 New York City - Slim Clark (gt/vcl solo). Producer : Don Gabor. Born Raymond LeRoy Clark in Springfield MASS (1917 - 2000) Slim and Kenny Roberts were at one time jointly members of the Red River Ranges and used to try to out-yodel each other.......Slim won the World Yodeling Championship in 1947 and was inducted into the Yodeler's Hall of Fame, along with Jimmie Rodgers, Elton Britt, and Wilf Carter. He was a member of the Western Music Association's Hall of Fame and the Rhode Island Country Music Hall of Fame and Received The Pioneer Award Downeast CMA. Also 1980 Maine CMA Hall of Fame 1989 Massachusetts CMA Hall of Fame 1996 Walkway of Stars Nashville, TN 2000 Cowboy Hall of Fame (posthumous) | ["Singing", "Country", "Yodeling", "Acoustic guitar", "Music", "Steel guitar, slide guitar"] | ["soft rock", "low quality", "mono", "noisy", "flat male vocal", "mellow acoustic rhythm guitar chords", "vintage", "sentimental", "nostalgic", "emotional", "warm"] | 4 | tcOHcop3sCQ | 5053 | |
Remington Restore [Part 4] Finish | The low quality recording features a high pitched, sped up audio playing in the background, followed by arpeggiated electric guitar melody and smooth bass guitar. Even though the sped up audio sounds weird, the guitar melodies are emotional. | 2012-06-26T17:39:34Z | kg6tgr | This Remington Noiseless Model 7 typewriter numbered H38502 built 1935... is back. It will be placed in my classroom and a million monkeys will bang at the keys and will randomly produce works of Shakespeare. This was a serious time-suck, well over 100 hours total. It is far from perfect, a key sticks now and then. Also, the features that make it noiseless can really make it hard to type. I lowered the rubber bar and the keys fly a bit faster, but I think I am going to avoid 'noiseless', because I noticed it on my other typewriter also. The bell, is beyond me. They were crafty in design, perhaps a bit too crafty. If I change the feet, I'll do a video on it. As of now, they stay. Also, I left the original paint. This typewriter has lived a long life with it, and I hate adding anything that is not needed. The rubber had to go, but the paint stayed. I had to paint a few pieces, as rust had come through. Thanks for watching and please subscribe. | ["Music", "Musical instrument", "Steel guitar, slide guitar"] | ["low quality", "noisy", "high pitched sped up audio", "arpeggiated electric guitar melody", "smooth bass guitar", "emotional", "weird"] | 4 | tvcJENqxr1c | 5077 | |
梁祝 - (The Butterfly Lovers) Erhu Concerto | The low quality recording features a live performance of a classical song that consists of sustained strings and flute melody. There are some chair crackling noises, as well as camera shuttering sounds. It sounds emotional and passionate, and the recording itself is noisy. | 2013-01-20T01:54:21Z | Justin Jia | Violin concerto "Liang Shan Bo and Zhu Ying Tai" (or The Butterfly Lovers in short) is composed by famous Chinese composer He Zhan Hao. Its origin is from a classical, Chinese legend about the lyric tragedy of eternal love between Liang Shan Bo and Zhu Ying Tai. Both transformed to butterflies after their death, flying with one another, forever. This piece has been a symbol of Chinese music in the international scene for fifty years and has been rearranged by composer He to an Gaohu Concerto. The romantic theme is filled with Jiangnan Cultural influences, because the theme came from the Chinese Yue opera. There are three movements in total, and the piece returns to the main melody " Transformation to butterflies" in the coda, pushing the piece to its climax once again. | ["Cello", "String section", "Violin, fiddle", "Bowed string instrument"] | ["low quality", "noisy", "sustained strings melody", "chair crackling sounds", "flute melody", "classical", "live performance", "emotional", "passionate", "camera shuttering sounds"] | 4 | ua0hgl8fi0I | 5127 | |
Learn to sing the U.S. National Anthem (feat. The Cactus Cuties) | The low quality recording features a national anthem sung by harmonizing girls' vocals. It sounds passionate and emotional. The recording is noisy and in mono. | 2008-05-13T21:38:19Z | PhanRegSop | Enable "Annotations" and watch in High Quality! Comments must be approved before posting to ensure family and school viewing preferences. RATED PG. www.TheCactusCuties.com from Lubbock TX, The Cactus Cuties from are (from left to right) Baylee age 14, Blaire 11, Andi 11, and Madeline 9 at the time of this video (May 11, 2008). They performed our nation's Star-Spangled Banner and halftime show medley at the Spurs vs. Hornet's NBA Playoff Game on May 11, 2008. The book inspired by The CC's entitled "Oh Say, Did You Know?" is a story about the Star Spangled Banner through the eyes of The Cuties as told by music mentor Terri Caldwell. You can purchase a copy by visiting their website. With each book comes a 3-song CD inlcuding The Star-Spangled Banner, "Think" by Aretha Franklin and "Children of America" by Terri Caldwell. Look for other songs on iTunes!! www.TheCactusCuties.com | ["Singing", "Choir"] | ["low quality", "noisy", "mono", "harmonizing girls vocals", "national anthem", "passionate", "emotional"] | 4 | v8bBrrXUpdo | 5158 | |
Elvis on Theremin | The low quality recording features a live performance that consists of a theremin solo melody played over arpeggiated piano melody. It sounds sad, emotional and passionate, even though the recording is noisy and in mono. | 2007-08-22T03:47:23Z | MisterScott99 | Scott Marshall performs the Elvis standard on Theremin to his own piano back track from a sequencer. | ["Music", "Musical instrument", "Piano", "Theremin"] | ["low quality", "live performance", "arpeggiated piano melody", "noisy", "mono", "theremin solo melody", "sad", "emotional", "passionate"] | 4 | vZUup6rK728 | 5192 | |
Breathing Underwater - Metric (COVER) | The low quality recording features a sad soft rock song that consists of an acoustic rhythm guitar chord progression over which the reverberant female vocalist sings. The recording is very noisy and it sounds sad and emotional. | 2012-09-02T00:44:27Z | Hustlerae | greg's piano playing made it in the background of this video. thanks gary. http://www.youtube.com/watch?v=m2cDFU_Q5Z8 https://www.facebook.com/pages/Rae-Corcoran/202694913206278 | ["Country", "Acoustic guitar", "Music", "Steel guitar, slide guitar", "Strum", "Plucked string instrument"] | ["noisy", "low quality", "reverberant female vocal", "sad acoustic rhythm guitar chord progression", "soft rock", "sad", "emotional"] | 4 | w-YAUcPl-HU | 5225 | |
Elena Stepanova, Volkhova's lullaby (from "Sadko") 1937 | The low quality recording contains a muffled strings section and a muffled passionate female opera singer, singing over it. The recording is noisy and in mono, and judging by the tone of it, old - which makes it vintage. It sounds emotional, warm and passionate. | 2009-08-01T20:46:21Z | younglemeshevist | Elena Andreyevna Stepanova (1891-1978) , the outstanding Russian soprano, the People's Artist of the USSR, the star of the Bolshoi theater (1912-1924, 1927-1944). Was very successful as Gilda, Violetta, Rosina, the Snowmaid, Volkhova, Shemakhan Tsarina (from the Golden Cockerel). On stage she worked with Sobinov, Chaliapin, Nezhdanova, Lemeshev. | ["Music", "Opera"] | ["low quality", "muffled strings section", "muffled passionate female opera singer", "noisy", "mono", "emotional", "vintage", "warm"] | 4 | xtGmrLOsjHk | 5360 | |
"11 O'Clock Tick Tock" - Belfast , January 1981 | The low quality recording features a live performance of a rock song and it features passionate male vocals, alongside harmonizing male vocals, singing over arpeggiated electric guitar melody, boomy bass guitar, punchy kick and snare hits and shimmering open hats. It sounds noisy and messy, as the frequencies are clashing with each other, but it is still groovy and emotional regardless. | 2006-04-19T19:19:34Z | u2log | The audience reaction is great in this clip. | ["Bass guitar", "Music", "Punk rock", "Rock and roll"] | ["low quality", "rock", "live performance", "arpeggiated electric guitar melody", "passionate male vocal", "harmonizing male vocals", "boomy bass guitar", "shimmering open hats", "punchy kick", "punchy snare", "messy", "noisy", "groovy", "emotional"] | 4 | zWJC_qr2610 | 5486 | |
Red Hot Chili Peppers "Californication" Bass Cover | The low quality recording features a cover of a rock song played on bass guitar over electric guitar arpeggiated melody played on playback in the background. The recording is noisy, in mono, as it was probably recorded on a phone, and it sounds emotional and passionate. | 2010-10-27T15:02:48Z | CrankUpTheAmps | Facebook page! :D http://www.facebook.com/pages/Laura-Andy/300522706667642 If you're looking for a video to help you tab this song, you may want to keep searching! This isn't a perfect cover, but none of my other ones are either, so why break tradition? ;D I originally recorded this cover in September of 2009, 6 months after I started playing bass! Yes, yes, I know...I played the entire guitar solo part all wrong. The fact that the audio gets a bit off probably doesn't help my case, either. : / If this song didn't exist, there's a good chance that I wouldn't be playing bass today. Yes...it's that cool. When I put this video up before, I ended up getting a lot of comments about how my fingers look so stressed...it's true...but I think I've made a lot of improvement in the year that I've been playing since I recorded this! | ["Bass guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Inside, small room"] | ["low quality", "noisy", "mono", "playback", "electric guitar arpeggiated melody", "rock", "bass guitar", "cover", "emotional", "passionate"] | 4 | zYsFbF9emtI | 5492 |
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;