musiccaps_details (view)
5 rows where musiccaps_aspects contains "cymbals crashing" and musiccaps_aspects contains "groovy bass line"
This data as json, CSV (advanced)
musiccaps_aspects (array) 87 ✖
- cymbals crashing · 5 ✖
- groovy bass line · 5 ✖
- male singer 3
- passionate 3
- bad audio quality 2
- cheerful 2
- emotional 2
- guitar rhythm 2
- inspiring 2
- medium tempo 2
- poor audio quality 2
- steady drumming rhythm 2
- accordion accompaniment 1
- adrenaline rush 1
- amateur music mix 1
- ambient crowd noises 1
- ambient room noises 1
- animated vocals 1
- backup singers 1
- backups singers 1
- busy office ambience 1
- busy work day 1
- cartoon show music theme 1
- children’s education program 1
- children’s favourites 1
- choppy music 1
- choral harmony 1
- crooning 1
- crowds cheering 1
- cumbria rhythm 1
- dance rhythm 1
- day at the office 1
- disco music 1
- disco romance hits 1
- disconcerting music 1
- dj 1
- enthusiastic 1
- excitement 1
- falsetto 1
- female singer 1
- funny 1
- g]adrenaline rush 1
- groovy 1
- groovy bas slime 1
- groovy music 1
- hissing tones 1
- instrumental music 1
- keyboard accompaniment 1
- latin percussions 1
- latin rhythm 1
- lifetime experience 1
- live audience 1
- live performance 1
- love song 1
- marry me 1
- mismatched tempos 1
- motivational 1
- movie soundtrack 1
- office adventure 1
- percussion bells 1
- piano accompaniment 1
- pop song 1
- pop superhit 1
- printer blues 1
- printer sounds 1
- quacking vocals 1
- remix 1
- retro hits 1
- retro pop song 1
- retro pop songs 1
- retro rock hits 1
- rock drumming rhythm 1
- rock music 1
- rock singer 1
- singing long notes 1
- slowing down 1
- smooth jazz music 1
- song retarding 1
- spirited 1
- steady drumming 1
- steady marching rhythm 1
- stylish singing voice 1
- tambourine percussions 1
- together forever 1
- toner sounds 1
- various percussion hits 1
- vocal harmony 1
musiccaps_names (array) 9 ✖
- Music 5
- Duck 1
- Maraca 1
- Printer 1
- Quack 1
- Rock music 1
- Singing 1
- Soul music 1
- Yell 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
🎉Quack, Quack, Quack, Donald Duck🎈 | A male singer sings this cool retro melody with duck quacking sounds. The song is medium tempo with a steady drumming rhythm with various funny percussion hits, accordion accompaniment and a groovy bass line. The song is inspiring and nostalgic. The song has an average audio quality. | 2016-06-09T22:21:22Z | House of Mizfitz | It's Donald Duck's Birthday Today and We Misfits Want To Celebrate and Show How Much We Appreciate and Love Our Misfit Duck, Because Donald Has Been There For Me Even Before Ralphie Reformed, When He Was The Villain Ralphscoe, That's Right Donald was like Ralphie's Mr. Smee, Le'Fou, Fidget, Iago and You Get The Idea Now That They're Both Reform They're Still A Great Duo, Donald is A True Friend and Member of The Misfits and We Want to Wish Him A Happy Birthday Reality Talk: Donald Duck is seriously my first favorite cartoon, hard to believe but I actually do learn a lot from this duck and he always manage to make me smile no matter what when I was a baby and even now, thanks Donald :D | ["Music", "Quack", "Duck"] | ["male singer", "stylish singing voice", "groovy bass line", "quacking vocals", "medium tempo", "cymbals crashing", "percussion bells", "various percussion hits", "funny", "cheerful", "animated vocals", "dance rhythm", "accordion accompaniment", "cartoon show music theme", "inspiring", "motivational", "children’s education program", "movie soundtrack", "retro pop songs", "children’s favourites", "steady marching rhythm"] | 1 | C0sSgrr5xrQ | 1318 | |
Happy Version cumbia - Pharrell Williams (Tato Dj) | A male singer sings this pop melody with back up singers in choral harmony. The song is medium tempo with a superimposed Latin Cumbia rhythm, which creates a discombobulated rhythm structure. The song audio quality is very poor. | 2014-03-14T22:04:39Z | Viktor Radchenko | Tato DJ Twitter: https://twitter.com/Tatoarata Original song by Pharrell Williams | ["Music", "Maraca"] | ["cumbria rhythm", "pop song", "choppy music", "latin rhythm", "disconcerting music", "cheerful", "pop superhit", "emotional", "inspiring", "groovy", "passionate", "male singer", "backups singers", "crooning", "choral harmony", "groovy bas slime", "steady drumming rhythm", "poor audio quality", "remix", "dj", "cymbals crashing", "groovy bass line", "latin percussions", "mismatched tempos", "amateur music mix"] | 1 | C6roSYqchkk | 1331 | |
The New Gladio ID Card Printer | The song is an instrumental. The song is medium tempo with a keyboard accompaniment, groovy bass line and a funky drumming rhythm. There is a lot of office ambient noises, like a printer motor noises, wind noise and other office environmental sounds. The music track acts as a background to the ambient office sound environment. The audio quality is very poor. | 2012-11-26T21:24:12Z | AllianceIDSolutions | The new Gladio ID Card Printer raises the bar for card printers when it comes to speed, reliability and quiet operation. The machine features lighting fast printing and whisper quiet operation and is field upgradeable. The sleek design provides reduced size and weight and outstanding performance, all at a great price. | ["Printer", "Music"] | ["instrumental music", "ambient room noises", "day at the office", "printer blues", "office adventure", "busy work day", "smooth jazz music", "hissing tones", "cymbals crashing", "printer sounds", "toner sounds", "poor audio quality", "medium tempo", "keyboard accompaniment", "steady drumming rhythm", "groovy bass line", "busy office ambience"] | 1 | YFXSbPFaxcA | 3270 | |
PACHUCO ROLAS VOL 1 | A female singer sings this passionate melody with backup singers in vocal harmony. The tempo is medium and gradually slows down towards the end. The drumming rhythm is steady and retards to the end with a percussive bass line and keyboard accompaniment. The song is a retro disco or R&B love song. The song has poor audio quality. | 2009-03-23T07:20:30Z | pachucojae | PACHUCO MEMORIES.... | ["Music", "Soul music"] | ["female singer", "disco music", "song retarding", "bad audio quality", "slowing down", "backup singers", "falsetto", "vocal harmony", "steady drumming", "groovy bass line", "piano accompaniment", "guitar rhythm", "tambourine percussions", "cymbals crashing", "retro pop song", "retro hits", "emotional", "love song", "passionate", "together forever", "disco romance hits", "marry me"] | 1 | iS-iTbHndw8 | 4185 | |
Los Mejores Gritos de Axl Rose/Best Cries Of Axl Rose [El Mejor Grito De La Historia] | A male rock singer sings this climatic solo with a long sustained note. The tempo is medium with strong rock drumming, guitar rhythm; guitar lead and a percussive bass line. The song is hard rock with a lot of spirit and excitement. The audio quality is bad with a lot of ambient crowd noises. | 2013-01-27T02:36:43Z | M. Adonis Ortiz | Like Please: http://www.facebook.com/ILoveGunsNRoses1 Únete/Me Gusta Por Favor: http://www.facebook.com/ILoveGunsNRoses1 Lista de gritos de Axl Rose LIVE. Una maravilla de 4 octavas: Axl Rose. Un bajo-barítono que se empuja hacia la 5ª octava. Algunos dicen que Axl suena como una guitarra, y tiene razón! No es un cantante melódico pero hace el trabajo! 01.El pasaje grave hacia el final de ¨Sweet child o' mine¨, la nota más baja es F#2. 02.La armonía grave en el comienzo de ¨Paradise City¨, también F#2. 03.Un sólido D#2 en ¨You ain´t the first¨. 04.La versión en vivo tiene dos D#2 :s. 05.C#2 desde ¨Shackler´s revenge¨ en Chinese Democracy (Que bueno que Axl Por fin lo terminó). 06.Puede Axl bajar más? El está hablando en la parte inferior de su segunda octava acá y canta un C#2 (una vez más) al final del Rockumental de MTV. 07.Axl se desliza hacia abajo para un C2 tambaleante, pero sostenido, al final de ¨Ain´t going down¨ (demo). 08.Un lindo B1 de ¨Don´t cry¨. 09.El B1 también está en esta conocida canción, ¨November rain¨ (¿Voz de fritura?) 10.Esto también suena como B1, una armonía baja (separada de la voz principal) de ¨There was a time¨. 11.La nota más baja de Axl, A1, de ¨Get in the ring con un A2¨. La armonia tiene una línea en B1, una línea en D2, una en A1 y una línea más en B1, luego las repite. 12.Hora de ir hacia arriba. Un C#5 de ¨Paradise City¨. 13.El final clásico de ¨Sweet Child o' mine¨ donde Axl toca D#5 varias veces :s y también un corto E5. 14.D#5 con trinos de ¨Welcome to the jungle¨. 15.Un D#5 de ¨Anything goes¨. 16.F5 de ¨You could be mine¨. 17.Misma nota, pero en vivo. 18.Cantando hasta F#5! y luego manteniendo esa nota, en ¨There was a time¨. Su nota más alta cantada, esto debe ser duro para él en los conciertos. 19.Gran F#5 de ¨I.R.S¨. 20.Un G5 de una versión en vivo de ¨Welcome to the jungle¨. 21.G5 en ¨Chinese democracy¨. 22.Linda cadenza hasta G#5 de ¨Scraped¨ con una armonía de C#2 abajo. 23.Manteniendo un G#5 junto con Sebastian Bach (que tenía y tiene excelent… | ["Singing", "Music", "Rock music", "Yell"] | ["live performance", "bad audio quality", "singing long notes", "rock singer", "male singer", "crowds cheering", "rock music", "rock drumming rhythm", "cymbals crashing", "live audience", "ambient crowd noises", "groovy bass line", "guitar rhythm", "g]adrenaline rush", "lifetime experience", "groovy music", "excitement", "enthusiastic", "adrenaline rush", "passionate", "spirited", "retro rock hits"] | 1 | pHC25Ia8Dxo | 4694 |
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;