video8: releases: 6 rows where audio_format = "Stereo" and subtitle

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

6 rows where audio_format = "Stereo" and subtitle_language = "Japanese"

descending

id ▼	title_id	catalog_number	release_date	country_release	encoding	runtime_mins	list_price	upc	audio_format	subtitle_language	notes
659	Against All Odds 625	A-10337	1985	Japan	NTSC	121.0	¥13,800	n/a	Stereo	Japanese
766	Close Encounters of the Third Kind Special Edition 704	00HS-90062	1984	Japan	NTSC	132.0	¥13,800	n/a	Stereo	Japanese
878	Fright Night 793	00HS-80055	1986	Japan	NTSC	106.0	¥12,950	n/a	Stereo	Japanese	Earlier release
894	Ghostbusters 806	A-10488	1985	Japan	NTSC	105.0	¥13,800	n/a	Stereo	Japanese	In Sony.1986.8 and Sony.1986.11 (Aug & Nov 1986) fliers, this title is listed with its 00HS- catalog number but original ¥13,800 price. Typically the A- series had the full price, but I had thought the switch to 00HS- numbers happened at the same time as the price drops (with factory sticker added to the outer shrink). This seems to indicate that the catalog number change preceded the price drop, as this is listed as ¥12,950 price soon after.
989	La Bamba 871	A-11285	1988	Japan	NTSC	103.0	¥13,800	n/a	Stereo	Japanese
1471	White Water Summer 1225	00HS-80431 (sticker on spine)	1988.09.21	Japan	NTSC	85.0	¥12,950	4-988009-772899	Stereo	Japanese	barcode sticker affixed to top edge of tape case with new 00HS series catalog no. Tape has original A series catalog number

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