musiccaps_details (view)
2 rows where musiccaps_aspects contains "home video", musiccaps_aspects contains "instrumental" and musiccaps_aspects contains "white noise"
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- amateur recording 2
- home video · 2 ✖
- instrumental · 2 ✖
- white noise · 2 ✖
- children electronic toys 1
- children’s game music 1
- elctronic music 1
- electronic music 1
- high notes 1
- home recording 1
- medium tempo 1
- monotone 1
- muddled audio 1
- muffled audio 1
- no accompaniment 1
- sharp 1
- slow tempo 1
- static 1
- string instrument 1
- synthesiser arrangements 1
- ukelele 1
- ukelele tuning 1
- video game music 1
- whirring 1
- whooshing sound 1
musiccaps_names (array) 3 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Uke Tuner | This music is instrumental. The tempo is slow with the musician plucking a single string of a ukelele. This audio is of a Ukelele being tuned. | 2012-12-19T20:59:49Z | yourukesage | Click on the | ["Music", "Electronic tuner"] | ["instrumental", "slow tempo", "monotone", "home video", "home recording", "amateur recording", "no accompaniment", "white noise", "static", "string instrument", "ukelele", "ukelele tuning"] | 7 | PqTPbZf44E0 | 2572 | |
1/18 Tampa City of Tampa Florida POLICE Diecast Car with Lights and SIREN | This music is instrumental. The tempo is slow with an electronic keyboard playing a simple, high pitched harmony. There are sounds in the background like whirring, whooshing and clicking. The music is not very clear as the audio clip is muffled, but it sounds like video game music or the music Ina child’s electronic toy. | 2010-10-29T21:53:59Z | 6877mercedes Ebay | City of Tampa Florida POLICE Diecast Car with Lights and SIREN | ["Ice cream truck, ice cream van", "Music"] | ["instrumental", "medium tempo", "high notes", "sharp", "children electronic toys", "electronic music", "whirring", "white noise", "whooshing sound", "video game music", "children’s game music", "elctronic music", "synthesiser arrangements", "muffled audio", "muddled audio", "home video", "amateur recording"] | 7 | uwPeQy7ZtGo | 5143 |
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;