musiccaps_details (view)
2 rows where musiccaps_aspects contains "glass shattering sounds" and musiccaps_aspects contains "poor audio quality"
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- glass shattering sounds · 2 ✖
- poor audio quality · 2 ✖
- adrenaline rush 1
- advertisement jingle 1
- ambient room noise 1
- animated movie soundtrack 1
- banging 1
- crunching tones 1
- disc scratching tones 1
- distorted guitar lead 1
- dj 1
- groaning sounds 1
- groovy bass line 1
- hard rock music 1
- heavy breathing 1
- high spirited 1
- instrumental music 1
- low muffled screams 1
- male rapper 1
- medium tempo 1
- metal cupboard banging sounds 1
- pain 1
- piano accompaniment 1
- scare as of agony 1
- screaming 1
- screams of agony 1
- string rock drumming 1
- string section harmony 1
- suspense music 1
- transformation 1
- violins playing 1
musiccaps_names (array) 3 ✖
- Music 2
- Boom 1
- Chink, clink 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Get Cut With Glass - Safe Shoulder Workouts #1 | The song is an advertisement jingle. A male singer sings rapping vocals, with a strong drumming rhythm, piano accompaniment, groovy bass line and a distorted guitar playing an aggressive lead. The song is high on adrenaline and energetic. The song is a soundtrack for an ad and is of poor audio quality. | 2012-11-02T15:33:33Z | StrenghtHuman | Adam Kirby treinando com o Trainer Pro Charles Glass para o 2007 Mr. Veneza Beach | ["Music", "Chink, clink"] | ["instrumental music", "hard rock music", "dj", "poor audio quality", "glass shattering sounds", "disc scratching tones", "medium tempo", "string rock drumming", "distorted guitar lead", "piano accompaniment", "groovy bass line", "advertisement jingle", "high spirited", "adrenaline rush", "male rapper"] | 1 | N1Mxns_JJTk | 2318 | |
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;