musiccaps_details (view)
3 rows where "youtube_published" is on date 2013-07-12 sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- male voice 2
- ambient street noise 1
- army band 1
- band arrangement 1
- bass guitar 1
- distortion guitar 1
- drum beats 1
- drums 1
- flutes playing in unison 1
- heartbeat 1
- instrumental music 1
- knife honing sound effect 1
- live march 1
- male backing vocal 1
- marching band 1
- marching rhythm 1
- medium-fast tempo 1
- moderate tempo 1
- narration 1
- people marching 1
- people talking 1
- percussion beat 1
- percussions sounds 1
- piano 1
- poor audio quality 1
- saxophone 1
- school band 1
- shimmer sound 1
- ska genre 1
- social activism 1
- steady rhythm 1
musiccaps_names (array) 6 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
1 Million Likes!!! | This song starts off with 2 heartbeats. The sound of a knife being honed is played. After this, we hear a short blasting sound. This is followed by a fast paced percussion starting off with a roll and then playing -two strokes on a hi-hat and one stroke on the snare drum. A male voice speaks in a narrative voice with a distortion guitar playing power chords in the background. The rest of the instruments continue playing in the background while the voice is narrating. | 2013-07-12T06:05:38Z | The Red Jumpsuit Apparatus | https://www.facebook.com/redjumpsuitapparatus http://www.fuelonline.co/ WE WANT TO THANK EVERYONE FOR ALL YOUR SUPPORT!!! HERE'S TO A MILLION MORE LIKES!! ~RJA | ["Music", "Punk rock", "Rock music"] | ["percussion beat", "heartbeat", "knife honing sound effect", "distortion guitar", "shimmer sound", "male voice", "narration", "moderate tempo"] | 0 | Ir82jewhXCo | 1948 | |
Ska music band Skalingrad United Skajana | The ska music features a male voice singing and being accompanied by another male backing vocal. The tempo is medium-fast, specific to the ska genre. The drums play a somewhat busy rhythm and the bass guitar plays a simple repeating bass line. In the background a piano accompanies the singer. Towards the end of the music excerpt a saxophone can be heard. | 2013-07-12T17:09:02Z | tunapavel | Skalingrad United - original ska music from The Czech republic. Moreover - www.skajana.cz | ["Music", "Ska"] | ["male voice", "male backing vocal", "piano", "bass guitar", "drums", "ska genre", "medium-fast tempo", "saxophone"] | 2 | WPguqXCBQCI | 3092 | |
Ross Kemp joins Orange Order Feeder Parade. 12 July 2013....5 | The music track is that of a band marching in the streets. The tempo is medium with a Band march, playing percussion in a steady rhythm accompanied by flutes playing in unison. The song has bad audio quality with ambient noises of people talking and other street noises. | 2013-07-12T12:43:57Z | william belfast | Orange Order Feeder Parade www.newsflare.com | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["live march", "marching band", "instrumental music", "flutes playing in unison", "steady rhythm", "drum beats", "marching rhythm", "percussions sounds", "people marching", "social activism", "army band", "school band", "band arrangement", "poor audio quality", "ambient street noise", "people talking"] | 1 | v9TTtjEngjY | 5159 |
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;