Query: Netflix series released per year by adlrocha

Loading chart...

1SELECT 
2    release_year,
3    COUNT(CASE WHEN type = 'TV Show' THEN show_id END) AS number_of_series,
4    COUNT(CASE WHEN type = 'Movie' THEN show_id END) AS number_of_movies
5FROM 
6    @kaggle.arnavvvvv_netflix_movies_and_tv_shows.netflix_titles
7GROUP BY 
8    release_year
9ORDER BY 
10    release_year ASC

release_year	number_of_series	number_of_movies
1925	1	0
1942	0	2
1943	0	3
1944	0	3
1945	1	3
1946	1	1
1947	0	1
1954	0	2
1955	0	3
1956	0	2
1958	0	3
1959	0	1
1960	0	4
1961	0	1
1962	0	3
1963	1	1
1964	0	2
1965	0	2
1966	0	1
1967	1	4
1968	0	3
1969	0	2
1970	0	2
1971	0	5
1972	1	4
1973	0	10
1974	1	6
1975	0	7
1976	0	9
1977	1	6
1978	0	7
1979	1	10
1980	0	11
1981	1	12
1982	0	17
1983	0	11
1984	0	12
1985	1	9
1986	2	11
1987	0	8
1988	2	16
1989	1	15
1990	3	19
1991	1	16
1992	3	20
1993	4	24
1994	2	20
1995	2	23
1996	3	21
1997	4	34
1998	4	32
1999	7	32
2000	4	33
2001	5	40
2002	7	44
2003	10	51
2004	9	55
2005	13	67
2006	14	82
2007	14	74
2008	23	113
2009	34	118
2010	40	154
2011	40	145
2012	64	173
2013	63	225
2014	88	264
2015	162	398
2016	244	658
2017	265	767
2018	380	767
2019	397	633
2020	436	517
2021	315	277