Name: Finnish Films
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Finnish Films

Technical, Historical and Color Data

About this dataset

This dataset provides an in-depth analysis of the technical aspects of Finnish fiction films. Drawing from the comprehensive archives and resources offered by the Elonet database managed by the Finnish National Audiovisual Institute, this dataset offers a vast collection of information about various facets of film production. In particular, you will be able to take advantage of detailed yearly breakdowns for amount produced and for key technical indicators such as aspect ratios and system types. This dataset is an essential resource for those looking to incorporate historical context into their research into Finnish fiction films

More Datasets

For more datasets, click here.

Featured Notebooks

🚨 Your notebook can be here! 🚨!

How to use the dataset

This dataset contains information about Finnish Fiction films. The data is divided into two main parts: technical details for each film, and yearly analysis of those details.

Research Ideas

Understanding the history of Finnish film production: The detailed information provided in this dataset can be used to analyze and track trends in production techniques over time, allowing for a better understanding of the history of Finnish fiction films.

Correlating subtitles to movies: By combining this dataset with other data sources, it could help researchers identify which parts of a movie have subtitles added to them, as well as determine whether certain language versions feature different audio formats than others due to varying countries' film systems at different times.

Analyzing costs associated with producing films: The wide range of technical details included here can be used to estimate the costs associated with producing certain types of films using specific systems and color processes at various times throughout history

Acknowledgements

If you use this dataset in your research, please credit the original authors.
Data Source

License

License: CC0 1.0 Universal (CC0 1.0) - Public Domain Dedication
No Copyright - You can copy, modify, distribute and perform the work, even for commercial purposes, all without asking permission. See Other Information.

Columns

File: films_per_year.csv

Column name	Description
Year	The year the film was released. (Integer)
Amount	The number of films released in the given year. (Integer)

File: yearly_aspect_ratios.csv

Column name	Description
system	The type of film system used to produce the film (e.g., 35mm or 16mm). (String)
year	The year the film was released. (Integer)
amount	The number of films released in the given year. (Integer)

Acknowledgements

If you use this dataset in your research, please credit the original authors.
If you use this dataset in your research, please credit .

Tables

Aspect Ratios

@kaggle.thedevastator_finnish_fiction_film_metadata_analysis_1907_2018.aspect_ratios

3.6 kB
11 rows
4 columns

CREATE TABLE aspect_ratios (
  "kuvasuhde" VARCHAR,
  "lukum_r" BIGINT  -- Lukumäärä,
  "alku" BIGINT,
  "loppu" BIGINT
);

Color Film Laboratories 1956–2000–1

@kaggle.thedevastator_finnish_fiction_film_metadata_analysis_1907_2018.color_film_laboratories_1956_2000_1

8.39 kB
45 rows
10 columns

CREATE TABLE color_film_laboratories_1956_2000_1 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "ulkomaiset_laboratoriot" VARCHAR,
  "suomi_filmi_oy" DOUBLE,
  "kurkvaara_filmi_oy" DOUBLE,
  "syv_puro" DOUBLE,
  "mtv_elokuvalaboratorio" DOUBLE,
  "finn_lab_oy" DOUBLE,
  "oy_yleisradio_ab" DOUBLE,
  "video_ei_lab" DOUBLE  -- Video (ei Lab.),
  "ei_tiedossa" DOUBLE
);

Color Film Material Manufacturers 1956–2000–1

@kaggle.thedevastator_finnish_fiction_film_metadata_analysis_1907_2018.color_film_material_manufacturers_1956_2000_1

5.85 kB
45 rows
7 columns

CREATE TABLE color_film_material_manufacturers_1956_2000_1 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "sovcolor" DOUBLE,
  "kodak" DOUBLE,
  "agfa" DOUBLE,
  "fuji" DOUBLE,
  "v_ri" DOUBLE,
  "yhteens" DOUBLE  -- Yhteensä
);

Films Per Year

@kaggle.thedevastator_finnish_fiction_film_metadata_analysis_1907_2018.films_per_year

2.92 kB
113 rows
2 columns

CREATE TABLE films_per_year (
  "year" BIGINT,
  "amount" BIGINT
);

Foreign Laboratories 1956–2000–1

@kaggle.thedevastator_finnish_fiction_film_metadata_analysis_1907_2018.foreign_laboratories_1956_2000_1

9.15 kB
45 rows
12 columns

CREATE TABLE foreign_laboratories_1956_2000_1 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "ruotsi" DOUBLE,
  "tanska" DOUBLE,
  "neuvostoliitto_ven_j" DOUBLE  -- Neuvostoliitto/Venäjä,
  "yhdysvallat" DOUBLE,
  "iso_britannia" DOUBLE,
  "saksa" DOUBLE,
  "brasilia" DOUBLE,
  "unkari" DOUBLE,
  "viro" DOUBLE,
  "sveitsi" DOUBLE,
  "kanada" DOUBLE
);

From Video Or 16 Mm To 35 Mm Film 1

@kaggle.thedevastator_finnish_fiction_film_metadata_analysis_1907_2018.from_video_or_16_mm_to_35_mm_film_1

3.03 kB
32 rows
3 columns

CREATE TABLE from_video_or_16_mm_to_35_mm_film_1 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "video" DOUBLE,
  "n_16_mm" DOUBLE  -- 16 Mm
);

Lengths And Durations

@kaggle.thedevastator_finnish_fiction_film_metadata_analysis_1907_2018.lengths_and_durations

31.49 kB
1,352 rows
4 columns

CREATE TABLE lengths_and_durations (
  "nimi" VARCHAR,
  "pituus" DOUBLE,
  "kesto" DOUBLE,
  "vuosi" BIGINT
);

Nitrate Acetate 1952–1959–1

@kaggle.thedevastator_finnish_fiction_film_metadata_analysis_1907_2018.nitrate_acetate_1952_1959_1

2.97 kB
8 rows
3 columns

CREATE TABLE nitrate_acetate_1952_1959_1 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "nitraatti" BIGINT,
  "asetaatti" BIGINT
);

Nitrate Acetate Companies 1952–1959–1

@kaggle.thedevastator_finnish_fiction_film_metadata_analysis_1907_2018.nitrate_acetate_companies_1952_1959_1

8.29 kB
179 rows
5 columns

CREATE TABLE nitrate_acetate_companies_1952_1959_1 (
  "vuosi" BIGINT,
  "nimi" VARCHAR,
  "tuotantoyhti" VARCHAR  -- Tuotantoyhtiö,
  "nitraatti" VARCHAR,
  "asetaatti" VARCHAR
);

Sound System Data

@kaggle.thedevastator_finnish_fiction_film_metadata_analysis_1907_2018.sound_system_data

3.62 kB
152 rows
3 columns

CREATE TABLE sound_system_data (
  "system" VARCHAR,
  "year" BIGINT,
  "amount" BIGINT
);

Summary Color

@kaggle.thedevastator_finnish_fiction_film_metadata_analysis_1907_2018.summary_color

2.14 kB
6 rows
2 columns

CREATE TABLE summary_color (
  "v_ri" VARCHAR,
  "m_r" BIGINT  -- Määrä
);

Yearly Aspect Ratios

@kaggle.thedevastator_finnish_fiction_film_metadata_analysis_1907_2018.yearly_aspect_ratios

3.76 kB
215 rows
3 columns

CREATE TABLE yearly_aspect_ratios (
  "system" VARCHAR,
  "year" BIGINT,
  "amount" BIGINT
);

Yearly Color Data

@kaggle.thedevastator_finnish_fiction_film_metadata_analysis_1907_2018.yearly_color_data

3.62 kB
158 rows
3 columns

CREATE TABLE yearly_color_data (
  "color" VARCHAR,
  "year" BIGINT,
  "amount" BIGINT
);