musiccaps_details (view)
1 row where musiccaps_author = 7 and musiccaps_names contains "Thunk" sorted by youtube_id
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 19 ✖
- accident 1
- ambient street sounds 1
- ambulance siren 1
- animated 1
- brakes slamming 1
- car 1
- car crash 1
- crime 1
- criminal 1
- emergency 1
- lego 1
- lego city 1
- police 1
- police officer 1
- police van 1
- police van siren 1
- song the end 1
- sound of footsteps 1
- walking 1
musiccaps_names (array) 3 ✖
- Music 1
- Police car (siren) 1
- Thunk · 1 ✖
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;