video8: releases: 24 rows where audio_format = "Stereo" and country

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

24 rows where audio_format = "Stereo" and country_release = "Japan"

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
1220	St. Elmo's Fire 1040	A-10756	1986	Japan	NTSC	108.0	¥13,800	n/a	Stereo
1470	White Water Summer 1225	A-11058	1988	Japan	NTSC	85.0	¥13,800	n/a	Stereo		barcode sticker affixed to top edge of tape case with new 00HS series catalog no. Tape has original A series catalog number
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
2086	Diane Schuur and The Count Basie Orchestra 1804	VAWJ-8841	1990.05.21	Japan	NTSC	51.0	¥3,800	4-988112-808416 (on sticker on outer shrink)	Stereo
2130	Lionel Richie - The Outrageous Tour Live 1845	VAM-???? (fuzzy in pic)	1987	Japan	NTSC		¥5,000	n/a	Stereo
2224	Rebecca [レベッカ] - Rebecca in Films 1938	48HH-125	1987	Japan	NTSC	20.0	¥4,800	T4998-009-70257-5	Stereo
2241	Shibugakitai [シブがき隊] - 5th Anniversary - Yomiuri Land East Live! 1954	78HH-112	1986.10.22	Japan	NTSC	55.0	¥7,800	n/a	Stereo
2253	Tomoyo Harada - Muscat Lips Tour 1966	68HH-114	1986	Japan	NTSC	40.0	¥6,800		Stereo		Tomoyo Harada - Muscat Lips Tour
2257	Tube [チューブ] - The Island in the Sun 1970	68HH-110	1986	Japan	NTSC	37.0	¥6,800		Stereo
3031	Song Toy Box Vol. 1: Animal Songs Part 1 2717	EN-101	1986.02.12	Japan	NTSC	30.0	¥6,800	n/a	Stereo
3032	Song Toy Box Vol. 2: Friendship Songs Part 1 2718	EN-102	1986.02.12	Japan	NTSC	30.0	¥6,800	n/a	Stereo
3033	Song Toy Box Vol. 3: Children's Songs 2719	EN-103	1986.02.12	Japan	NTSC	30.0	¥6,800	n/a	Stereo
3034	Song Toy Box Vol. 4: Friendship Songs Part 2 2720	EN-104	1986.02.12	Japan	NTSC	30.0	¥6,800	n/a	Stereo
3035	Song Toy Box Vol. 5: Fun Songs 2721	EN-105	1986.02.12	Japan	NTSC	30.0	¥6,800	n/a	Stereo
3036	Song Toy Box Vol. 6: Animal Songs Part 2 2722	EN-106	1986.02.12	Japan	NTSC	30.0	¥6,800	n/a	Stereo
3037	Song Toy Box Vol. 7: Seasonal Songs 2723	EN-107	1986.02.12	Japan	NTSC	30.0	¥6,800	n/a	Stereo
3038	Song Toy Box Vol. 8: Friendship Songs Part 3 2724	EN-108	1986.02.12	Japan	NTSC	30.0	¥6,800	n/a	Stereo
3039	Song Toy Box Vol. 9: Friendship Songs Part 4 2725	EN-109	1986.02.12	Japan	NTSC	30.0	¥6,800	n/a	Stereo
3040	Song Toy Box Vol.10: Songs of the World 2726	EN-110	1986.02.12	Japan	NTSC	30.0	¥6,800	n/a	Stereo

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