video8: releases: 3 rows 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

3 rows where country_release = "Japan", encoding = "NTSC" and title_id = 1172

descending

id ▼	title_id	catalog_number	release_date	country_release	encoding	runtime_mins	list_price	upc	audio_format	notes
1400	The Snowman 1172	50HS-4004F	1986	Japan	NTSC	26.0	¥5,000	n/a	Digital Stereo
1401	The Snowman 1172	CSWW-7094	1989.10.21	Japan	NTSC	26.0	¥3,800	4-988009-709475 (extrapolated)	Hi-Fi/Digital Stereo	Dubbed version? Guessing based on consecutive catalog #s
1402	The Snowman 1172	CSWW-7095	1989.10.21	Japan	NTSC	26.0	¥3,800	4-988009-709574	Hi-Fi/Digital Stereo	Probably the English version based on lack of Japanese on cover and minimal Japanese elsewhere on insert.

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
        );