musiccaps_details (view)
2 rows where musiccaps_aspects contains "groaning sounds" and musiccaps_aspects contains "poor audio quality" sorted by musiccaps_aspects
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- groaning sounds · 2 ✖
- poor audio quality · 2 ✖
- ambient noises 1
- ambient room noise 1
- animated movie soundtrack 1
- banging 1
- breakup song 1
- crunching tones 1
- crying vocals 1
- deteriorated music quality 1
- glass shattering sounds 1
- grief 1
- guitar strumming 1
- heavy breathing 1
- low muffled screams 1
- male singer 1
- medium tempo 1
- melancholic music 1
- metal cupboard banging sounds 1
- movie scene music 1
- movie soundtrack 1
- nostalgic pop song 1
- pain 1
- sadness 1
- scare as of agony 1
- screaming 1
- screams of agony 1
- string section harmony 1
- suspense music 1
- tragedy 1
- transformation 1
- violins playing 1
musiccaps_names (array) 3 ✖
- Music 2
- Boom 1
- Wail, moan 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects ▼ | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
shallow grave final scene - andy williams - happy heart | The song is a movie soundtrack. The song is medium tempo with groaning tones, crying sounds, ambient Street noises, and guitar strumming rhythm. The sound track is played for an emotionally sad scene. The audio quality is overall poor. | 2012-04-14T14:55:12Z | malign | ["Music", "Wail, moan"] | ["male singer", "crying vocals", "groaning sounds", "tragedy", "ambient noises", "deteriorated music quality", "movie soundtrack", "nostalgic pop song", "male singer", "medium tempo", "grief", "sadness", "grief", "poor audio quality", "guitar strumming", "melancholic music", "breakup song", "movie scene music"] | 1 | CQlh4k5pXKA | 1363 |
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;