musiccaps_details (view)
3 rows where musiccaps_aspects contains "animated movie soundtrack" and musiccaps_aspects contains "poor audio quality"
This data as json, CSV (advanced)
musiccaps_aspects (array) 47 ✖
- animated movie soundtrack · 3 ✖
- poor audio quality · 3 ✖
- ambient room noise 1
- animated vocals 1
- annoying vocal sounds 1
- backup singers 1
- banging 1
- battle march 1
- cartoon soundtrack 1
- children’s show 1
- comedy 1
- crunching tones 1
- dance rhythm 1
- discordant vocal tones 1
- electric guitar harmony 1
- emotional 1
- funny tv show 1
- glass shattering sounds 1
- groaning sounds 1
- groovy bass line 1
- heavy breathing 1
- instrumental music 1
- keybiard accompaniment 1
- low muffled screams 1
- male singer 1
- marching drum rhythm 1
- medium fast tempo 1
- medium tempo 1
- metal cupboard banging sounds 1
- multiple overlapping tracks 1
- pain 1
- retro arcade game music 1
- retro pop music 1
- retro pop song 1
- scare as of agony 1
- screaming 1
- screams of agony 1
- serious 1
- slapstick comedy 1
- steady bass line 1
- string section 1
- string section harmony 1
- string synth harmony 1
- suspense music 1
- transformation 1
- victory march 1
- violins playing 1
musiccaps_names (array) 5 ✖
- Music 3
- /t/dd00032 1
- Background music 1
- Boom 1
- Soul music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Squidward does sit-ups while I play unfitting music | A male singer sings this pop melody with animated vocals making annoying sounds. The song is medium tempo with backup vocals singing harmony, keyboard accompaniment, percussive a bass line and strong drumming rhythm. The song is a background track for an animated tv show. The audio quality is very poor. | 2010-08-14T01:46:22Z | TMNT39 | Squidward enjoying his trip to the future with music that makes no sense with it! WOW!! :P | ["Music", "/t/dd00032"] | ["animated vocals", "male singer", "medium fast tempo", "children’s show", "funny tv show", "comedy", "slapstick comedy", "backup singers", "multiple overlapping tracks", "groovy bass line", "discordant vocal tones", "keybiard accompaniment", "dance rhythm", "retro pop song", "animated movie soundtrack", "annoying vocal sounds", "poor audio quality"] | 1 | MSqQKf3O3vY | 2270 | |
Hulk Transformation Test by Alok Joshi | The song is a movie soundtrack. Violins play in a mysterious harmony while ambient room noises are heard. Groaning, screams of agony, shouts, metal cupboards falling, glass shattering and wrecking noses are heard. The track is an animated movie sound track and of poor quality. | 2012-12-24T12:10:24Z | Alok Joshi | Hulk Transformation Test by Alok Joshi (Used Morpheus Rig v1.0 by Josh Burton) (Audio rights belong to their owners) | ["Music", "Boom"] | ["groaning sounds", "screaming", "low muffled screams", "screams of agony", "metal cupboard banging sounds", "transformation", "ambient room noise", "banging", "glass shattering sounds", "crunching tones", "pain", "scare as of agony", "heavy breathing", "animated movie soundtrack", "violins playing", "poor audio quality", "string section harmony", "suspense music"] | 1 | lTOzGIOIfq0 | 4402 | |
Heavy Metal Veteran of the Psychic Wars | The song is an instrumental. The tempo is medium with a steady drum march rhythm, steady bass line, keyboard harmony and a synth string section. The song is Eros’s and emotional. The song has poor audio quality. | 2013-05-13T06:03:31Z | MARIO DANIEL DEMAYO | ["Background music", "Music", "Soul music"] | ["poor audio quality", "battle march", "retro pop music", "retro arcade game music", "string section", "instrumental music", "electric guitar harmony", "string synth harmony", "marching drum rhythm", "victory march", "medium tempo", "emotional", "cartoon soundtrack", "animated movie soundtrack", "serious", "steady bass line"] | 1 | uCCdUB7D10U | 5098 |
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;