musiccaps_details (view)
1 row where musiccaps_aspects contains "sound of footsteps", musiccaps_author = 7 and "youtube_published" is on date 2009-07-25
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 |
---|---|---|---|---|---|---|---|---|---|---|
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;