musiccaps_details (view)
2 rows where musiccaps_author = 4 and "youtube_published" is on date 2012-12-27
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- low quality 2
- boomy kick 1
- crowd yelling sound effect 1
- echoing energetic male vocal 1
- energetic 1
- energetic crash cymbals 1
- exciting 1
- groovy bass guitar 1
- intense 1
- live performance 1
- male grunting sound effect 1
- movie 1
- punchy snare 1
- rock 1
- suspenseful 1
- thunderstruck sound effect 1
- wide electric guitar chord progression 1
- wide high pitched synth pad 1
- wide low sustained strings 1
musiccaps_names (array) 5 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Foo Fighters - Rock and Roll - Kennedy Center Honors - Led Zeppelin | The low quality recording features a live performance of a rock song that consists of echoing, energetic male vocals that are singing over wide electric guitar chord progression, energetic crash cymbals, punchy snare, boomy kick and groovy bass guitar. It sounds energetic and exciting. | 2012-12-27T03:55:00Z | saveyouckufer | Foo Fighters - Rock and Roll - Kennedy Center Honors - Led Zeppelin Celebration Day http://amzn.to/TFuvtc | ["Music", "Roll", "Rock and roll"] | ["low quality", "echoing energetic male vocal", "wide electric guitar chord progression", "energetic crash cymbals", "punchy snare", "boomy kick", "groovy bass guitar", "rock", "live performance", "energetic", "exciting"] | 4 | Q8f6y2IcVg0 | 2600 | |
Merlin strikes with Lightning | The low quality recording features a wide high pitched synth pad and wide low, sustained strings chords playing in the background, after which there is a thunderstruck sound effect, followed by male grunting and crowd yelling sound effects. It sounds suspenseful and intense - like a movie scene would. | 2012-12-27T14:52:40Z | HeliasKasti | Merlin - Emrys casts the Spell "Chain Lightning" | ["Music", "Scary music", "Outside, rural or natural"] | ["low quality", "wide high pitched synth pad", "wide low sustained strings", "thunderstruck sound effect", "male grunting sound effect", "crowd yelling sound effect", "suspenseful", "intense", "movie"] | 4 | ZocCGcJcGJE | 3417 |
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;