musiccaps_details (view)
5 rows where musiccaps_aspects contains "poor audio quality" and musiccaps_aspects contains "pop song"
This data as json, CSV (advanced)
musiccaps_aspects (array) 83 ✖
- poor audio quality · 5 ✖
- pop song · 5 ✖
- emotional 3
- passionate 3
- female singer 2
- inspiring 2
- medium tempo 2
- piano accompaniment 2
- song introduction 2
- steady drumming rhythm 2
- acoustic song 1
- amateur music mix 1
- ambient crowd noise 1
- ambient noises 1
- ambient room sounds 1
- background music 1
- backups singers 1
- blues music 1
- blues turnaround 1
- booming bass line 1
- breathing sounds 1
- button clicks 1
- chaotic harmony 1
- cheerful 1
- choppy music 1
- choral harmony 1
- classic pop hits 1
- classic pop song 1
- classical music 1
- crooning 1
- cumbria rhythm 1
- cymbals crashing 1
- disconcerting music 1
- dj 1
- dreamscapes 1
- electric guitar tremolo tones 1
- female voice 1
- fret noise 1
- groovy 1
- groovy bas slime 1
- groovy bass line 1
- grunge keyboard tones 1
- guitar notes playing 1
- guitar playing 1
- hissing ambient sound 1
- hissing noises 1
- instrumental 1
- instrumental music 1
- latin percussions 1
- latin rhythm 1
- lilting 1
- lilting vocals 1
- live audience 1
- live performance 1
- love song 1
- madly in love 1
- male singer 1
- melancholic 1
- mismatched tempos 1
- musical instruments 1
- offbeat 1
- pop diva 1
- pop super hits 1
- pop superhit 1
- quirky 1
- remix 1
- romantic 1
- rustling tones 1
- sadness 1
- school recital 1
- singer talking 1
- slow tempo 1
- soul music 1
- soul singer 1
- spirited 1
- tambourine percussions 1
- tooth brush music 1
- traditional percussion rhythm 1
- trudging drum rhythm 1
- vibration magic 1
- vocal recital 1
- weird 1
- whirring sounds 1
musiccaps_names (array) 9 ✖
- Music 5
- Singing 2
- /t/dd00004 1
- Humming 1
- Inside, large room or hall 1
- Maraca 1
- Rustling leaves 1
- Song 1
- Toothbrush 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Adele North American Tour 2008 | A female singer sings this bluesy melody. The song is medium tempo with minimal guitar accompaniment and no other instrumentation. The song's medium tempo is very emotional and passionate. The song is a modern pop hit but with poor audio quality. | 2011-03-17T20:16:50Z | Viswijfable | This shortfilm was on the bonus disc. of 19. Directed by Charlie Robins © | ["Singing", "Music", "/t/dd00004", "Inside, large room or hall"] | ["female singer", "blues music", "live audience", "romantic", "hissing ambient sound", "madly in love", "love song", "passionate", "ambient crowd noise", "guitar playing", "singer talking", "song introduction", "blues turnaround", "fret noise", "pop song", "pop super hits", "pop diva", "poor audio quality", "guitar notes playing", "live performance", "lilting vocals", "soul singer", "soul music"] | 1 | B90BOtSOD2Q | 1210 | |
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 | |
Music Toothbrush | The song is music created by a toothbrush. The tempo is medium and sounds like a female singer singing in high pitch, motor whirring sounds and button clicks. The audio is poor quality in nature. | 2009-03-13T14:03:47Z | dixter | ["Toothbrush", "Music"] | ["button clicks", "whirring sounds", "background music", "poor audio quality", "weird", "musical instruments", "quirky", "offbeat", "ambient room sounds", "poor audio quality", "female voice", "pop song", "tooth brush music", "weird", "offbeat", "vibration magic", "instrumental", "medium tempo"] | 1 | QYxFWV85-pg | 2626 | ||
Madison sings Who Has Seen the Wind | The song is an instrumental. The tempo is medium and has a piano accompaniment. The song has a lot of ambient noises like hissing, breathing and hushed tones. The song is emotional but of poor audio quality. | 2009-04-27T16:51:17Z | lmsouthern | Madison sings her competition solo, Who Has Seen the Wind, at the Choir Concert April 26th. | ["Music", "Rustling leaves"] | ["ambient noises", "piano accompaniment", "emotional", "lilting", "vocal recital", "passionate", "spirited", "classical music", "pop song", "acoustic song", "breathing sounds", "rustling tones", "instrumental music", "hissing noises", "poor audio quality", "school recital", "song introduction", "medium tempo", "classical music"] | 1 | oJyyNWuyig4 | 4616 | |
Transistor OST - In Circles Mashup (Humming & Singing) | A female singer sings this poignant melody. The song is slow tempo with an electric guitar buzzing harmony, piano accompaniment, steady drumming rhythm, keyboard harmony, groovy bass line and Tambour percussions. The song is emotional and melancholic. The song is a poor quality recording of a classic pop song. | 2014-07-04T13:54:06Z | the Dragon Coffee | Lyrics: I hear you buzzing, a fly on the wall In through the window and up through the hall Flying in circles just trying to land I see you hurting I do what I can But I won't save you I won't save you Maybe you're looking for someone to blame Fighting for air while you circle the drain Never be sorry for your little time It's not when you get there, it's always the climb But I won't save you I won't save you I won't save you I won't save you ------------------------------------------------------ THANKS to the Supergiant Games for this AWESOME GAME, and Music! | ["Singing", "Humming", "Music", "Song"] | ["female singer", "grunge keyboard tones", "classic pop hits", "dreamscapes", "tambourine percussions", "steady drumming rhythm", "booming bass line", "traditional percussion rhythm", "chaotic harmony", "poor audio quality", "electric guitar tremolo tones", "piano accompaniment", "pop song", "classic pop song", "inspiring", "emotional", "slow tempo", "trudging drum rhythm", "sadness", "melancholic"] | 1 | z6SNngkMAug | 5457 |
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;