Hi, bderoes:
Is there an automated way to search for people with 100+ feature film credits that are NOT silent films?Short (and sad) answer is no... AFAIK, you can't get such a list by using the forms at ATS or ANS. The only way of trying to search for people who meet those requirements is by parsing the datasets in plain text format. Theoretically, silent films should be readily identifiable just by looking at two variables: languages ("None") and sound mix ("Silent").
-
tsv files: Here's the second sad answer: the current text files made public by don't contain any of those two variables to filter out silent films; beyond a mere year range approach (before/after 1927), nothing more can be done.
- list files: Former text files did contain both language and sound-mix info (besides much more different data than tsv files). However -misfortunes come in threes-, they're not (and will no longer be) updated since December 2017. Also, they lack the common and unique keys (ttconsts, nmconsts) to cross-reference their fields and values with those within the tsv files, so we can't "merge" them and take advantage of all the archives at once.
Even if I could get a list of potential candidates, and research the silent films by hand, that would help. Thanks in advance, but feel free to say no.Evaluating choices... ...
- You say you only want films, so I've excluded made-for-video titles (V), made-for-TV titles (TV), series, episodes and videogames.
- You say you only want acting credits, so I've excluded (self), (archive footage) or (credit only) entries. On the other hand, you say nothing about uncredited performances, so I'll aggregate them into the final results.
- You say you only want released titles, so I've excluded around 80,000 films which don't have a year listed yet (????).
- When using the list files, only one of the two helping variables to separate silent films (language, sound-mix) is truly useful in the end, because unfortunately a very few titles from that period have the "None" language listed, as you can see below:Conversely, sound-mix info seems to be well represented for that timeframe, with a high percentage of "Silent" films labeled as such.
· name.filmography.tsv@05 Jul 2020
· title.basics.tsv@07 Jul 2020
TRANSITION PERIOD (1930-1938): 286,141 credits (3.3%) ~ 28.1% for actresses.
SOUND ERA (1939-2115): 7,937,646 credits (92.0%) ~ 34.3% for actresses.
"Person with more than 100 film credits when adding up their 100% sound era
film credits and 75% of transition period film credits"
There are 3,562 NAMES who meet this criteria.
· actors.list@22 Sep 2017
· actresses.list@22 Dec 2017
· movies.list@22 Dec 2017
· sound-mix.list@22 Dec 2017
· language.list@22 Dec 2017
UNAVAILABLE SOUND MIX: 3,908,307 credits (51.9%) ~ 35.6% for actresses.
NON-SILENT SOUND MIX: 3,232,496 credits (42.9%) ~ 31.5% for actresses.
"Person with more than 100 film credits when adding up their 100% non-silent
sound mix film credits and 95% of unavailable sound mix film credits"
There are 3,124 NAMES who meet this criteria.
Hope this is what you needed... Cheers!