musiccaps_details (view)
2 rows where musiccaps_aspects contains "home recording" and musiccaps_aspects contains "steady drumming rhythm" sorted by musiccaps_rowid
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- home recording · 2 ✖
- steady drumming rhythm · 2 ✖
- amateur playing 1
- amateur rock band 1
- ambient music 1
- ambient room noises 1
- audio hiss tones 1
- casual rock 1
- chill-out music 1
- classic rock influences 1
- dance music 1
- disc scratching tones 1
- dj 1
- dj face off 1
- dj practising 1
- dj turntable 1
- echo tones 1
- electronic dance music 1
- fast fingers 1
- filler music 1
- freestyle dj 1
- groovy 1
- groovy bass line 1
- guitar lead 1
- instrumental all music 1
- keyboard harmony 1
- medium tempo 1
- modern pop 1
- out of time 1
- poor audio quality 1
- relaxing 1
- slow tempo 1
- tone manipulation 1
- vinyls 1
musiccaps_names (array) 9 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid ▼ |
---|---|---|---|---|---|---|---|---|---|---|
Greatest Sound Man Freestyle Scratch | The song is an instrumental. The tempo is medium with a slick drumming rhythm and a DJ creating cool melodies by scratching and manipulating spinning music discs. The song is energetic and has a dance groove. The song is electronic dance music with poor audio quality and is at home. | 2008-11-29T06:19:22Z | Juan | Some weak on the spot cutting. Nothing fancy, just gettin some footage | ["Scratching (performance technique)", "Music", "Scratch", "Drum machine"] | ["instrumental all music", "dj", "electronic dance music", "home recording", "audio hiss tones", "fast fingers", "freestyle dj", "dj face off", "medium tempo", "steady drumming rhythm", "vinyls", "tone manipulation", "groovy", "disc scratching tones", "dance music", "dj practising", "ambient room noises", "poor audio quality", "dj turntable"] | 1 | KUE_I30--AY | 2087 | |
Relaxation Music Progressive Rock | The song is an instrumental music piece. The song is slow tempo with an electric guitar playing lead with heavy echoes, steady drumming and a keyboard harmony. The song is casual and slightly out of rhythm. The song is an instrumental with a casual listening vibe. | 2011-10-11T06:06:56Z | Gothenburg Music | Relaxation Music Progressive Rock, Rock jam and improvisation | ["Electric guitar", "New-age music", "Music", "Rock music", "Steel guitar, slide guitar", "Distortion"] | ["slow tempo", "guitar lead", "steady drumming rhythm", "filler music", "relaxing", "home recording", "chill-out music", "modern pop", "classic rock influences", "amateur rock band", "ambient music", "groovy bass line", "echo tones", "relaxing", "out of time", "amateur playing", "keyboard harmony", "casual rock"] | 1 | UrgzGbGVV8I | 2948 |
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;