musiccaps_details (view)
2 rows where musiccaps_aspects contains "sound of footsteps" 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 |
---|---|---|---|---|---|---|---|---|---|---|
Ewa Farna - MEGAKONCERT Třinec pozvánka - 11.3.2011 | This clip features a combination of different parts. There are footsteps outdoors, the sound of peeling or squishiness, a muffled voice and rock music at the end. The rock music is hard rock music which features a grungy electric guitar and some simple punchy drumming. | 2011-02-09T21:38:01Z | Michal Raszka | Ewa Farna - MEGAKONCERT Třinec pozvánka - 11.3.2011 http://www.facebook.com/event.php?eid=186912627999570 | ["Music", "Pop music", "Crunch"] | ["sound of footsteps", "sound of pealing", "squishy sound", "hard rock", "electric guitar power chord strumming", "muffled male voice", "desperate male voice"] | 3 | B3WaJ_3M0vw | 1199 | |
new Lego City Police car | This audio is an animated movie clip. There are ambient street sounds like footsteps, car brakes being slammed, car crashing, police van or ambulance siren and a song at the end. | 2009-07-25T20:19:46Z | vdosjcoi | This is a video about my new Lego City police car.... I hope that you find her interesting!! please rate and komment!! by VDOSJCOI | ["Police car (siren)", "Music", "Thunk"] | ["ambient street sounds", "walking", "ambulance siren", "car", "car crash", "accident", "emergency", "accident", "sound of footsteps", "brakes slamming", "song the end", "animated", "lego", "lego city", "police", "police van", "police van siren", "police officer", "crime", "criminal"] | 7 | oZoJ26C6LrU | 4643 |
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;