musiccaps_details (view)
2 rows where musiccaps_aspects contains "engine sound", musiccaps_aspects contains "instrumental", musiccaps_author = 7 and musiccaps_names contains "Music"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
1st Ice Cream Truck of the Year | This music is instrumental. The tempo is medium with an electronic xylophone melody. The audio is of inferior quality and it sounds like it is being played outdoors. There are ambient nature sounds like birds chirping, a car engine, a loud thud and people’s voices. | 2011-04-15T01:41:18Z | Elizabeth's Adventures | Here is a video that I took of the first ice cream truck of the year. This truck comes around almost every day in front of our building. The song is the Mr Softee song | ["Ice cream truck, ice cream van", "Music"] | ["instrumental", "medium tempo", "engine sound", "car engine", "people’s voices", "low quality audio", "amateur recording", "home video", "outdoors", "ice-cream cart", "merry-go round", "carousel", "carousel music", "engine whirring", "thudding", "xylophone melody", "birds chirping", "electronic music", "children’s music", "children’s toy music"] | 7 | ZsmxO0wnqdQ | 3423 | |
Juki DDL 8700 - with servo motor, silent machine | This clip is an instrumental with dissonant sounds like whirring, an engine starting, door bell or elevator bell , clattering and rustling. This is an amateur home recording. | 2010-01-16T10:21:13Z | www.jomaq.com Máquinas de costura | Juki DDL- 8700 lockstitch machine, equipped with servo motor. Very silent machine and cheap machine. Ideal for home use and small business. | ["Music", "Sewing machine"] | ["instrumental", "whirring sounds", "engine sound", "amateur", "home recording", "dissonant", "door bell ringing", "elevator bell", "rustling", "clattering sound"] | 7 | heZw1TTrtTU | 4123 |
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;