video8: releases: 25 rows where audio_format = "Digital 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

25 rows where audio_format = "Digital Stereo" and subtitle_language = "English (CC)"

descending

id ▼	title_id	catalog_number	release_date	country_release	encoding	runtime_mins	upc	isbn	audio_format	subtitle_language
1	A Chorus Line 1	8mm 2183	1986	US	NTSC	118.0	0-4299-52183-8		Digital Stereo	English (CC)
15	Against All Odds 15		1986	US	NTSC	122.0			Digital Stereo	English (CC)
30	Arachnophobia 30	108008		US	NTSC	110.0			Digital Stereo	English (CC)
46	Beverly Hills Cop 46	8mm 1134	1986	US	NTSC	105.0	n/a		Digital Stereo	English (CC)
50	Big Top Pee-Wee 50	8mm 32076	1988	US	NTSC	86.0	n/a		Digital Stereo	English (CC)
101	Crocodile Dundee 100	8mm 32029	1987	US	NTSC	98.0	n/a		Digital Stereo	English (CC)
102	Crocodile Dundee II 101	8mm 32147	1989	US	NTSC	110.0	n/a		Digital Stereo	English (CC)
147	Fat Man and Little Boy 146	8mm 32252	1990	US	NTSC	127.0	0-9736-32252-87	0-7921-1640-2	Digital Stereo	English (CC)
154	Flashdance 153	8mm 1454	1986	US	NTSC	95.0	n/a		Digital Stereo	English (CC)
180	Gung Ho 179	8mm 1751	1986	US	NTSC	111.0	n/a		Digital Stereo	English (CC)
212	Indiana Jones and the Last Crusade 211	8mm 31859	1989	US	NTSC	126.0	0-7921-1496-5	0-7921-1496-5	Digital Stereo	English (CC)
213	Indiana Jones and the Temple of Doom 212	8mm 1643	1986	US	NTSC	118.0	n/a		Digital Stereo	English (CC)
258	Men of Respect 256	90543	1991	US	NTSC	107.0	0-43396-90543-6	0-8001-0265-7	Digital Stereo	English (CC)
302	Planes, Trains and Automobiles 300	8mm 32036	1988	US	NTSC	93.0	n/a		Digital Stereo	English (CC)
364	Star Trek III: The Search for Spock 362	8mm 1621	1986	US	NTSC	105.0	n/a		Digital Stereo	English (CC)
390	The Accused 388	1760	1989	US	NTSC	110.0	n/a		Digital Stereo	English (CC)
405	The Cotton Club 403	8mm 1714	1985	US	NTSC	128.0	0-4299-51714-8		Digital Stereo	English (CC)
412	The Emerald Forest 410	8mm 2179	1985	US	NTSC	113.0	0-4299-52179-8		Digital Stereo	English (CC)
428	The Graduate 426	8mm 2071	1985	US	NTSC	105.0	0-4299-52071-8		Digital Stereo	English (CC)
445	The Lost Boys 443	11748		US	NTSC		0-85391-17488-4 ?? (fuzzy in pic)		Digital Stereo	English (CC)
447	The Mission 445	11639	1988	US	NTSC	125.0	0-85391-16398-5		Digital Stereo	English (CC)
451	The Net 449	11618	1995	US	NTSC	114.0	0-43396-11618-4	0-8001-8358-4	Digital Stereo	English (CC)
460	The Prince of Tides 458	50948	1992	US	NTSC	132.0	0-43396-50948-1	0-8001-1241-5	Digital Stereo	English (CC)
469	The Sure Thing 467	8mm 2178	1985	US	NTSC	94.0	0-4299-52178-8		Digital Stereo	English (CC)
523	Witness 521	8mm 1736	1986	US	NTSC	112.0	n/a		Digital Stereo	English (CC)

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