musiccaps_details (view)
2 rows where musiccaps_aspects contains "crime"
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- crime · 2 ✖
- accident 1
- ambient street sounds 1
- ambulance siren 1
- animated 1
- brakes slamming 1
- car 1
- car crash 1
- creating tension 1
- criminal 1
- eerie 1
- emergency 1
- instrumental music 1
- keyboard accompaniment 1
- lego 1
- lego city 1
- medium tempo 1
- movie soundtrack 1
- murder mystery 1
- mysterious 1
- no percussions 1
- police 1
- police officer 1
- police van 1
- police van siren 1
- poor audio quality 1
- scary 1
- song the end 1
- sound of footsteps 1
- spirited 1
- string section 1
- suspense 1
- tremolo effect 1
- tv season 1
- tv show theme 1
- vibrato 1
- walking 1
musiccaps_names (array) 4 ✖
- Music 1
- Police car (siren) 1
- Singing bowl 1
- Thunk 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Breaking Bad Season 1 (2008) You're All They Talk About (Extra Soundtrack OST) | The song is an instrumental. The song is medium tempo, with a keyboard accompaniment and string pad section. The song is emotional and passionate. The song is a movie soundtrack with poor audio quality. | 2012-06-09T10:35:15Z | portaps10 | 01 Breaking Bad (Main Title Theme) 02 Negro y Azul - Ballad of Heisenber 03 One By One 04 Walt Bandages His Leg 05 Zungguzungguzungguzeng (Short Version) 06 The Peanut Vendor 07 You're All They Talk About 08 Fallacies 09 Banderilla 10 The Morning After 11 Red Moon 12 The Missing Piece 13 End Credits - Season One | ["Singing bowl"] | ["instrumental music", "keyboard accompaniment", "poor audio quality", "tv show theme", "suspense", "mysterious", "tv season", "crime", "murder mystery", "scary", "eerie", "spirited", "medium tempo", "string section", "vibrato", "tremolo effect", "creating tension", "movie soundtrack", "no percussions"] | 1 | OVNVaXZ9D0E | 2445 | |
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;