video8: releases: 1 row where country_release = "Japan", encoding = "NTSC" and title

Data license: CC0 · Data source: github.com/rikker/video8

id: ID
title_id: Title
title_release: Release Title
title_release_lang: Release Title Language
catalog_number: Catalog No.
release_date: Release Date
country_release: Country of Release
encoding: Encoding
runtime_mins: Runtime (mins)
list_price: List Price
upc: UPC
isbn: ISBN
audio_format: Audio Format
audio_language: Audio Language
audio_dubbed: Dubbed
subtitle_language: Subtitles / CC
promo: Promo
notes: Notes

1 row where country_release = "Japan", encoding = "NTSC" and title_id = 1254

descending

id ▼	title_id	title_release	title_release_lang	catalog_number	release_date	country_release	encoding	runtime_mins	list_price	upc	isbn	audio_format	audio_language	audio_dubbed	subtitle_language	promo	notes
1501	Suikoden [Warriors of the Sung Dynasty] 1254			00HF-11	1986.02.01	Japan	NTSC	91.0	¥12,000			Hi-Fi Mono/Digital Stereo			Japanese		Seems to be this film: https://ja.wikipedia.org/wiki/%E6%B0%B4%E6%BB%B8%E4%BC%9D_(1983%E5%B9%B4%E3%81%AE%E6%98%A0%E7%94%BB); https://www.imdb.com/title/tt0202094/

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE releases (
            id INTEGER PRIMARY KEY,
            title_id INTEGER REFERENCES titles(id),
            title_release TEXT,
            title_release_lang TEXT,
            catalog_number TEXT,
            release_date TEXT,
            country_release TEXT,
            encoding TEXT,
            runtime_mins REAL,
            list_price TEXT,
            upc TEXT,
            isbn TEXT,
            audio_format TEXT,
            audio_language TEXT,
            audio_dubbed TEXT,
            subtitle_language TEXT,
            promo TEXT,
            notes TEXT
        );