video8: releases: 3 rows where audio_format = "Hi-Fi/Digital Stereo Dolby Surround", country_release = "Japan" 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 audio_format = "Hi-Fi/Digital Stereo Dolby Surround", country_release = "Japan" and title_id = 649

descending

id ▼	title_id	catalog_number	release_date	country_release	encoding	runtime_mins	list_price	upc	audio_format	subtitle_language	notes
692	Batman 649	CSWF-8164	1990.06.01	Japan	NTSC	127.0	¥14,000	4-988009-816470 (extrapolated)	Hi-Fi/Digital Stereo Dolby Surround	Japanese	First Japanese release. Cover has only Batman it; Warner black spine release. Has CSWF number but a high price. Usually this means a title came out in 1989, the year CSWF numbering began, and when prices were dropped; apparently there was an initial high price release, followed by a lower price release soon after in the same year, with the same artwork, but new cat#, perhaps due to the title's popularity.
693	Batman 649	SRWF-8883	1991.04.25	Japan	NTSC	127.0	¥4,700	4-988009-888378	Hi-Fi/Digital Stereo Dolby Surround	Japanese	Second Japanese release. Cover has only Batman on it; has a lower price and SRWF series cat# instead of the CRWF series cat# of the first release. Databook shows release date as 1991.04.25, even though 1990 is printed on the insert; likely a late 1990 production, but not out on shelves until April.
694	Batman 649	SRWF-9733	1993	Japan	NTSC	127.0	¥3,800	4-988009-973371	Hi-Fi/Digital Stereo Dolby Surround	Japanese	Third and final Japan release. Cover features both Batman and Joker, but very similar back cover art (placement of D2 logo and some text differs; need a higher resolution image). Likely released after 1992 as it is not in the 1992 Databook. Comparison with similar cat#s indicate a likely 1993 release.

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