videos
1 row where s_uid = "s_fsc9j"
This data as json, CSV (advanced)
Suggested facets: releaseDate (date), createdAt (date), updatedAt (date)
| uid ▼ | code | titleEn | titleJa | descriptionEn | descriptionJa | jacketFullUrl | jacketThumbUrl | sampleUrl | runtimeMins | releaseDate | s_uid | createdAt | updatedAt |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| v_ggy4w | HOWS-014 | How To School - How To Get Better At Sex After Watching This Textbook AV [Oil Massage Techniques That Will Definitely Make You Come Inside] Riho Shishido | How to学園 観たら【絶対】SEXが上手くなる教科書AV 【絶対中イキさせられるオイルマッサージ術編】 宍戸里帆 | https://pics.dmm.co.jp/digital/video/hows00014/hows00014pl.jpg | https://pics.dmm.co.jp/digital/video/hows00014/hows00014ps.jpg | https://cc3001.dmm.co.jp/pv/NSw8PyU9LkuJvY06UeMV56TRNmY17uVpsz8HOnBIcolx36LwVA0RqgX_Pk8-/hows014mhb.mp4 | 240 | 2025-10-11 | How To Academy s_fsc9j | 2026-08-30 14:12:22 | 2026-08-30 16:26:09 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE videos (
uid TEXT PRIMARY KEY,
code TEXT NOT NULL UNIQUE,
titleEn TEXT,
titleJa TEXT,
-- Some providers publish this as a "comment" rather than a description; it
-- is the same field and lands here either way.
descriptionEn TEXT,
descriptionJa TEXT,
jacketFullUrl TEXT,
jacketThumbUrl TEXT,
sampleUrl TEXT,
runtimeMins INTEGER,
releaseDate TEXT, -- ISO yyyy-mm-dd
s_uid TEXT REFERENCES series(uid) ON DELETE SET NULL,
createdAt TEXT NOT NULL DEFAULT (datetime('now')),
updatedAt TEXT NOT NULL DEFAULT (datetime('now'))
);
CREATE INDEX idx_videos_release ON videos(releaseDate);
CREATE INDEX idx_videos_series ON videos(s_uid);