musiccaps_details (view)
2 rows where musiccaps_aspects contains "rap music" and musiccaps_names contains "Hip hop music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- rap music · 2 ✖
- ad-lib 1
- aggressive 1
- amateur audio quality 1
- asian rap hits 1
- asian stringed instruments 1
- backup singers 1
- cool and sophisticated 1
- dance rhythm 1
- electronic drums 1
- emotional 1
- energetic 1
- engaging 1
- groovy 1
- groovy bass line 1
- hip-hop 1
- keybiard harmony 1
- keyboard 1
- keyboard harmony 1
- korean rap 1
- loud 1
- male rap singer 1
- male vocals 1
- medium tempo 1
- passionate 1
- rap artist 1
- rap hits 1
- rapping 1
- skating 1
- steady drumming rhythm 1
- story telling 1
- street smart 1
- urban sounds 1
- vocal harmony 1
- youthful 1
musiccaps_names (array) 4 ✖
- Hip hop music · 2 ✖
- Music 2
- Rapping 2
- Skateboard 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
【MUSIC VIDEO】SENDAI ALL DAY / AROUND THE CLOCK | A male rapper sings this cool melody with a backup singer in vocal harmony. The song is medium tempo with a groovy bass, keyboard playing harmony, stringed Asian instrument and a steady drumming rhythm. The song is story telling and passionate. The song is in poor audio quality and is a rap music video. | 2014-05-30T03:00:01Z | canvassendai | AROUND THE CLOCK × DABDE × CANVAS のコラボ企画! CLOUD NINE RECORDSの若手実力派グループのAROUND THE CLOCK、BEATMAKERにはGAMISMのDABDE。アパレルやVIDEO WORKなど幅広く活動するCANVASが手を組んだ1曲! | ["Music", "Rapping", "Hip hop music"] | ["amateur audio quality", "rap music", "emotional", "korean rap", "youthful", "passionate", "street smart", "dance rhythm", "keyboard harmony", "cool and sophisticated", "male rap singer", "asian stringed instruments", "keybiard harmony", "vocal harmony", "backup singers", "steady drumming rhythm", "groovy bass line", "story telling", "asian rap hits", "engaging", "energetic", "passionate", "rap hits", "rap artist"] | 1 | O5IulN0n6d0 | 2397 | |
Fredrik Andersson | Razors AM | This is a rap music piece played behind a rollerskating video. The sound of the skaters can be heard faintly throughout the recording. There is a male voice rapping at the forefront while other voices can be heard singing melodically in the background and ad-libbing occasionally. There is a mild keyboard playing the tune while a loud electronic drum beat is playing the rhythm. The atmosphere of this piece is groovy and urban. | 2014-08-23T21:55:37Z | Razors Skate Co. | Presenting Razors AM, Fredrik Andersson. The world traveler comes through with this banger filmed throughout the year in Texas (USA), Amsterdam (Netherlands), Calgary (Canada), and Malaga (Spain). Edit: Anthony Medina Film: Anthony Medina, Josh Glowicki, Nils Jansons & Richie Eisler | ["Music", "Skateboard", "Rapping", "Hip hop music"] | ["rap music", "hip-hop", "male vocals", "rapping", "ad-lib", "keyboard", "electronic drums", "aggressive", "loud", "groovy", "urban sounds", "skating", "medium tempo"] | 9 | _43OOP6UEw0 | 3441 |
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;