musiccaps_details (view)
1 row where search matches "guitar", musiccaps_aspects contains "e-guitar" and musiccaps_aspects contains "slower tempo" sorted by youtube_channel
This data as json, CSV (advanced)
musiccaps_aspects (array) 7 ✖
- acoustic/digital drums 1
- digital sound effects 1
- e-guitar · 1 ✖
- pop 1
- slower tempo · 1 ✖
- uplifting 1
- wave sounds 1
musiccaps_names (array) 2 ✖
- Music 1
- Pink noise 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel ▼ | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
10 MOST SECRET Places On Earth | Top 5 Countdown | Digital sound effects are rising in a high pitch along with the sound of ocean-waves. Then a song starts containing a digital/acoustic drum playing a simple and clear groove with a shaker sample as hi hat sound and a e-guitar finger picking a melody. This song may be playing as an intro for an informational video. | 2015-03-24T13:12:22Z | Science Day | From the well-known AREA 51 to the most obvious "secrets" here is a video about 10 maybe secret places on Earth. ★Top 5 Website and Social Media: Instagram: https://www.instagram.com/sciencedaychannel/ ★Music provided by Incompetech Link: http://adf.ly/18Uj81 ★Countdown subjects: 10) Club 33. 9) Vatican Secret Archive. 8) Metro 2. 7) The Mormon Church's Secret Vaults. 6) Mount Yamantau. 5) White’s Gentlemen’s Club. 4) Mount Weather Emergency Operations Center. 3) Dugway Proving Ground. 2) RAF Menwith Hill. Royal Air Force Menwith Hill or more simply RAF Menwith Hill 1)Area 51. | ["Music", "Pink noise"] | ["pop", "wave sounds", "digital sound effects", "acoustic/digital drums", "e-guitar", "uplifting", "slower tempo"] | 6 | NqDxpJ2uR_8 | 2369 |
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;