musiccaps_details (view)
3 rows where musiccaps_aspects contains "screaming" and musiccaps_author = 1 sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 48 ✖
- poor audio quality 3
- screaming · 3 ✖
- live performance 2
- male singer 2
- adrenaline rush 1
- ambient room noise 1
- ambient street noise 1
- animated movie soundtrack 1
- arabic folk singer 1
- banging 1
- crowd noise 1
- crunching tones 1
- deteriorated audio quality 1
- energetic 1
- excited vocals 1
- fast metal drumming 1
- folk singer 1
- glass shattering sounds 1
- groaning sounds 1
- groovy bass line 1
- guitar rhythm 1
- hard metal music 1
- head banging 1
- heavy breathing 1
- live audience 1
- live band 1
- low muffled screams 1
- medium tempo 1
- metal band 1
- metal cupboard banging sounds 1
- mosh pit 1
- noisy crowd 1
- pain 1
- percussive bass line 1
- rebellious 1
- retro metal hits 1
- scare as of agony 1
- screaming vocals 1
- screams of agony 1
- spirited 1
- steady drumming rhythm 1
- string section harmony 1
- suspense music 1
- transformation 1
- vintage metal 1
- violin playing solo 1
- violins playing 1
- wedding music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
salam- pentru cristofor la udi | A male singer sings this passionate vocal. The song is medium tempo with a groovy bass line, steady drumming rhythm and a violin playing a solo. The song is a live performance by a folk singer. The song has a bad audio quality issue. | 2008-09-28T14:54:29Z | elicsir0515 | talent:X | ["Jazz", "Music", "Orchestra", "Speech"] | ["male singer", "screaming", "poor audio quality", "wedding music", "live band", "arabic folk singer", "excited vocals", "medium tempo", "groovy bass line", "steady drumming rhythm", "crowd noise", "ambient street noise", "folk singer", "live audience", "live performance", "violin playing solo"] | 1 | bZJoTauRldE | 3634 | |
김경호 shout 초반 샤우팅 연도별 모음 | A male singer sings this screaming metal melody. The song is medium fast tempo with a fast metal drumming rhythm, percussive bass line and guitars playing accompaniment. The song is rebellious and highly spirited. The audio quality is very poor and vintage. | 2016-03-01T09:07:30Z | 갓경호 | 김경호 shout 초반 샤우팅 연도별 모음1998/1999/2000/2001/2002/2003/2004/2005/2009/2010/2011/2014 | ["Music", "Whoop"] | ["hard metal music", "male singer", "screaming vocals", "vintage metal", "metal band", "deteriorated audio quality", "head banging", "mosh pit", "retro metal hits", "screaming", "noisy crowd", "live performance", "fast metal drumming", "guitar rhythm", "percussive bass line", "energetic", "adrenaline rush", "poor audio quality", "spirited", "rebellious"] | 1 | g75kz9ffcg0 | 4007 | |
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 |
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;