musiccaps_details (view)
2 rows where "youtube_published" is on date 2007-12-18
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- aggressive 1
- aggressive male breathing 1
- amateur recording 1
- berimbau instrument 1
- clapping 1
- dj music 1
- foot stomping 1
- fusion music 1
- low quality 1
- low quality audio 1
- moderate tempo 1
- programmed percussion 1
- scratching record 1
- short accordion melody 1
- uncomfortable 1
- weird 1
- weird mouth noises 1
musiccaps_names (array) 4 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Freestyle Scratch Birimbao | This is a low quality audio recording. It starts with a DJ console scratching a record. This is accompanied by programmed percussion playing a repetitive melody. A berimbau plays after the scratching sound and the percussion continues to play the same beat. The berimbau plays the string as well as adds to the beat in the song. This is an instrumental song and there are no voices. This song can be played in a fashion show. | 2007-12-18T12:41:10Z | Clément Zajazza | www.zajazza.com Freestyle Scratch Birimbao at my house in Brazil | ["Scratching (performance technique)", "Music", "Scratch"] | ["amateur recording", "low quality audio", "dj music", "scratching record", "berimbau instrument", "programmed percussion", "moderate tempo", "fusion music"] | 0 | W5t-T1vP2DU | 3065 | |
Weird Al Yankovic - Another One Rides The Bus | The Low quality recording features a widely spread, weird mouth noises, foot stomping in the right channel and aggressive male breathing and claps in the left channel of the stereo image. There is a short accordion melody at the very beginning of the loop. It sounds very weird and aggressive, almost uncomfortable. | 2007-12-18T11:03:59Z | Brian Fountain | Another One Rides The Bus - Weird Al,a little video for fun | ["Burping, eructation", "Music"] | ["short accordion melody", "aggressive male breathing", "clapping", "foot stomping", "weird mouth noises", "weird", "low quality", "aggressive", "uncomfortable"] | 4 | _KYo_89lgf0 | 3464 |
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;