musiccaps_details (view)
2 rows where musiccaps_aspects contains "percussion" and musiccaps_names contains "Inside, public space"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- percussion · 2 ✖
- bass 1
- crowd noise 1
- distortion guitars 1
- guitar solo 1
- happy mood 1
- heavy metal 1
- instrumental 1
- live recording 1
- low quality sound 1
- male voice 1
- moderate tempo 1
- no voices 1
- techno song 1
- vocoder 1
musiccaps_names (array) 4 ✖
- Inside, public space · 2 ✖
- Music 2
- Inside, large room or hall 1
- Rock music 1
youtube_published (date) 2 ✖
- 2006-04-22 1
- 2009-08-17 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Iron Maiden - The Clairvoyant | This clip features low quality audio. The song is a heavy metal song where a guitar solo is played on the higher register of the scale. This is accompanied by percussion playing an uptempo beat. The bass plays a heavy riff using open notes and its octave. The distortion guitar plays power chords. There are no voices in this song. This is an instrumental song. This song can be played in a racecar sequence in a movie. | 2006-04-22T14:12:37Z | lammeaap | The Clairvoyant played live at Birmingham during the Seventh Tour of a Seventh Tour. | ["Music", "Rock music", "Inside, large room or hall", "Inside, public space"] | ["low quality sound", "heavy metal", "guitar solo", "no voices", "bass", "percussion", "distortion guitars", "happy mood", "instrumental", "moderate tempo"] | 0 | CdWA-SNcYpM | 1386 | |
Kobe Bryant - Mama, There Goes That Man! HD | This clip features a live recording of low quality. The song is mixed into a video clip. The sound of crowd cheering is heard. The song features a male voice using a vocoder. The song is in the techno genre. The percussion is programmed and plays a techno beat. The bass plays simple root notes of chords. Synth bursts are played at the beginning and at the end of the song. The referee whistle is heard toward the middle of the clip. | 2009-08-17T06:26:55Z | marjizee | Kobe Bryant puttin' on a clinic. | ["Music", "Inside, public space"] | ["live recording", "crowd noise", "techno song", "vocoder", "male voice", "percussion"] | 0 | hFj0KUzofNg | 4088 |
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;