On Mar 10, 2013, at 1:28 PM, Davide Alberani <davide.alber...@gmail.com> wrote:
> Well... it was not thought for this, but can be done. > You can use the imdbpy2sql.py script to put the plain text data files > into a database, and then with a normal query on the 'title' table you > can get the IDs of all the movies produced in a given year. Yeah, between movies.list, release-dates.list, and the canonical title of the movie, one should should have more than enough information to get going, e.g.: sqlite> select year, count( * ) as count from movie group by year order by year; year|count |162179 1880|1 1888|5 1889|2 1890|6 1891|7 1892|9 1893|2 1894|93 1895|121 1896|796 1897|1308 1898|1740 1899|1784 1900|1816 1901|1748 1902|1785 1903|1893 1904|1066 1905|805 1906|1101 1907|1475 1908|2707 1909|3410 1910|4589 1911|5954 1912|7724 1913|8877 1914|8069 1915|7659 1916|5824 1917|4507 1918|3776 1919|3604 1920|3997 1921|3625 1922|3066 1923|2614 1924|2611 1925|2787 1926|2849 1927|2903 1928|2768 1929|2793 1930|2542 1931|2499 1932|2563 1933|2427 1934|2487 1935|2456 1936|2792 1937|2784 1938|2720 1939|2472 1940|2193 1941|2189 1942|2175 1943|1953 1944|1816 1945|1718 1946|1925 1947|2238 1948|2710 1949|3637 1950|4547 1951|5424 1952|6049 1953|6527 1954|6890 1955|7682 1956|8246 1957|9040 1958|9312 1959|9885 1960|10530 1961|10415 1962|9850 1963|10645 1964|10928 1965|12532 1966|13168 1967|13750 1968|13528 1969|13641 1970|14103 1971|13689 1972|12895 1973|13205 1974|12627 1975|13151 1976|13193 1977|13149 1978|13526 1979|14045 1980|13951 1981|13436 1982|13816 1983|14531 1984|15540 1985|17381 1986|18422 1987|19027 1988|18665 1989|19811 1990|21227 1991|21895 1992|22887 1993|25025 1994|28154 1995|34450 1996|34316 1997|36403 1998|43839 1999|47965 2000|50347 2001|55630 2002|59345 2003|64338 2004|80094 2005|91039 2006|103959 2007|115108 2008|118538 2009|125452 2010|137234 2011|153123 2012|151022 2013|30064 2014|2099 2015|271 2016|22 2017|2 2019|2 ------------------------------------------------------------------------------ Symantec Endpoint Protection 12 positioned as A LEADER in The Forrester Wave(TM): Endpoint Security, Q1 2013 and "remains a good choice" in the endpoint security space. For insight on selecting the right partner to tackle endpoint security challenges, access the full report. http://p.sf.net/sfu/symantec-dev2dev _______________________________________________ Imdbpy-help mailing list Imdbpy-help@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/imdbpy-help
