musiccaps_details (view)
2 rows where musiccaps_aspects contains "amateur recording" and "youtube_published" is on date 2007-10-17
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- amateur recording · 2 ✖
- instrumental 2
- catchy riff 1
- clicking sound 1
- cozy 1
- digital drum beat 1
- dj 1
- dj mixer 1
- electric guitar riff 1
- fast tempo 1
- home recording 1
- irish flute 1
- irish folk music 1
- keyboard harmony 1
- muddled music 1
- no singer 1
- playful 1
- scratching 1
- sharp sound 1
- single instrument 1
- static 1
- vinyl records 1
musiccaps_names (array) 5 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Dj Bicchio "Scratching with Duca" | This music is an instrumental with a groovy rhythm. The audio is of inferior quality making the sound muddled and difficult to comprehend. There is a steady rhythm in the background with the sound of a turn table, scratching , a catchy riff on the electric guitar and some sound caused by disturbance in electrical energy. | 2007-10-17T21:52:00Z | sistahduka | Dj Bicchio "Scratching with Duca" | ["Scratching (performance technique)", "Music", "Scratch"] | ["instrumental", "fast tempo", "keyboard harmony", "digital drum beat", "scratching", "catchy riff", "electric guitar riff", "muddled music", "home recording", "amateur recording", "sharp sound", "vinyl records", "scratching", "dj", "dj mixer", "clicking sound", "static"] | 7 | 5tt_GKV13G0 | 704 | |
Low Tin Whistle Morrison's Jig irish flute music | This is an amateur recording of an Irish folk music piece. It is an instrumental piece. There is an Irish flute playing a playful melody in a home setting. The atmosphere is cozy. This piece could be used in the soundtrack of an arcade adventure video game during the parts where the protagonist is traversing through forested areas. | 2007-10-17T13:57:59Z | spennamac | Morrisons Jig played on an Overton low whistle in D low whistle | ["Wind instrument, woodwind instrument", "Flute"] | ["amateur recording", "irish folk music", "no singer", "instrumental", "single instrument", "irish flute", "playful", "cozy"] | 9 | YjTz5y8DnWo | 3307 |
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;