home / video8

releases

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

4 rows where title_id = 75

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: runtime_mins

country_release 4

  • Finland 1
  • Germany 1
  • UK 1
  • US 1

encoding 2

  • PAL 3
  • NTSC 1

subtitle_language 0

promo 0

audio_language 0

audio_format 0

audio_dubbed 0

id ▼ title_id title_release title_release_lang catalog_number release_date country_release encoding runtime_mins list_price upc isbn audio_format audio_language audio_dubbed subtitle_language promo notes
76 Casablanca 75     ME301264   US NTSC 104.0                  
561 Casablanca 75       1989 Finland PAL 99.0                 Finland Canon Collection
620 Casablanca 75     PGM 99217 1989 Germany PAL 99.0                 Germany Canon Collection
1627 Casablanca 75         UK PAL                    

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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
        );
Powered by Datasette · Queries took 54.475ms · Data license: CC0 · Data source: github.com/rikker/video8