ljdoncel's profile
Champion

Champion

 • 

1.1K Messages

 • 

51.4K Points

Wednesday, October 14th, 2015 11:27 AM

Statistics and curious facts about acting credits

Hi, everybody:

In order to offer help in a recent thread about some credits' attributes, I had to process the actors & actresses plain text files (as of 2 Oct 2015). Taking advantage of it, I would like to share with you some curious data about acting credits obtained during the analysis (e.g. haven't you ever wonder who is the actor with most credits on IMDB?, or which film has the largest cast list?, or what do Hillary Clinton and Madonna have in common? Interrogante):

A. LONGEST NAMES
(not counting spaces nor roman numerals)
B. MOST PROLIFIC NAMES
(here the word "title" refers to unique shows, i.e. if an actor has played roles in 21 episodes of a series, it counts as "21 credits" but only "1 title")
  • Any type of title: 25,336,119 credits in 1,002,289 titles
          Names with most credits:
                Any credits:
                      Actor: Alex Trebek (7,225 credits in 166 titles).
                            -- [7,183 of them are self appearances in 135 titles].
                            -- [8 of them are uncredited appearances in 7 titles].
                      Actress: Vanna White (6,188 credits in 68 titles).
                            -- [6,175 of them are self appearances in 56 titles].
                            -- [3 of them are uncredited appearances in 3 titles].
                Excluding self credits:
                      Actor: Frank Welker (4,163 credits in 754 titles).
                            -- [105 of them are uncredited appearances in 60 titles].
                      Actress: Helena Isabel (3,931 credits in 81 titles).
                            -- [2 of them are uncredited appearances in 1 title].
          Names with most titles:
                Any titles:
                      Actor: Tom Byron (I) (1,933 titles) [1,933 credits].
                            -- [41 of them contain only self appearances (41 credits)].
                      Actress: Bess Flowers (880 titles) [880 credits].
                Excluding adult genre titles:
                      Actor: Mel Blanc (1,278 titles) [1,975 credits].
                      Actress: Bess Flowers (880 titles) [880 credits].

  • Films: 6,875,305 credits in 653,971 titles
          Names with most credits/titles:
                Actor: Mel Blanc (1,066 titles) [499 uncredited items].
                Actress: Bess Flowers (831 titles) [799 uncredited items].
          Names with most credits/titles excluding uncredited roles:
                Actor: Brahmanandam (986 titles).
                Actress: Helen (I) (488 titles).

  • Made for video (V): 1,062,518 credits in 129,453 titles
          Names with most credits/titles:
                Actor: Mark Wood (IV) (1,728 titles) [10 self / 24 uncredited items].
                Actress: Nina Hartley (571 titles) [39 self / 6 uncredited items].
          Names with most credits/titles excluding adult genre roles:
                Actor: Desmond Elliot (252 titles).
                Actress: Patience Ozokwor (317 titles).

  • Made for TV (TV): 1,349,431 credits in 103,017 titles
          Names with most credits/titles:
                Actor: Bob Hope (I) (302 titles) [285 self / 12 uncredited items].
                Actress: Whoopi Goldberg (225 titles) [197 self / 12 uncredited items].
          Names with most credits/titles excluding self roles:
                Actor: Jerry Lawler (195 titles) [1 uncredited item].
                Actress: Momiji Yamamura (107 titles) [no uncredited items].

  • Series: 15,961,575 credits in 1,758,156 episodes and 109,746 titles
          Names with most credits (series level credits + episode credits):
                Any credits:
                      Actor: Johnny Gilbert (I) (7,192 credits in 45 titles).
                            -- [31 series level credits + 7,161 episode credits in 14 titles].
                            -- [7,104 of them are self appearances in 14 titles].
                            -- [5 of them are uncredited appearances in 4 titles].
                      Actress: Vanna White (6,161 credits in 41 titles).
                            -- [0 series level credits + 6,161 episode credits in 41 titles].
                            -- [6,153 of them are self appearances in 34 titles].
                            -- [2 of them are uncredited appearances in 2 titles].
                Excluding self credits:
                      Actor: Luís Esparteiro (3,805 credits in 47 titles).
                            -- [7 series level credits + 3,798 episode credits in 42 titles].
                            -- [1 of them is an uncredited appearance in 1 title].
                      Actress: Helena Isabel (3,902 credits in 52 titles).
                            -- [16 series level credits + 3,886 episode credits in 38 titles].
                            -- [1 of them is an uncredited appearance in 1 title].
          Names with most titles:
                Any titles:
                      Actor: William Shatner (302 titles within 1,035 credits).
                            -- [20 series level credits + 1,015 episode credits].
                            -- [477 of credits are self appearances in 174 titles].
                            -- [10 of credits are uncredited appearances in 9 titles].
                      Actress: Dolly Parton (274 titles within 987 credits).
                            -- [6 series level credits + 981 episode credits].
                            -- [971 of credits are self appearances in 264 titles].
                            -- [5 of credits are uncredited appearances in 5 titles].
                Excluding self credits:
                      Actor: Frank Welker (294 titles within 3,703 credits).
                            -- [73 series level credits + 3,630 episode credits].
                            -- [1 of credits is an uncredited appearance in 1 title].
                      Actress: Tara Strong (182 titles within 1,945 credits).
                            -- [10 series level credits + 1,965 episode credits].
                            -- [none of the credits is an uncredited appearance].

  • Videogames (VG): 87,290 credits in 6,102 titles
          Names with most credits/titles:
                Actor: Steve Blum (IX) (330 titles).
                Actress: Lani Minella (227 titles).

C. NAMES WITH MOST ATTRIBUTES/SELF CREDITS
  • Names with most attributes:
          (as...):
                Actor: Tozé Martinho (2,075 credits).
                Actress: Grey Griffin (1,940 credits).
          (uncredited):
                Actor: Herman Hack (1,023 credits).
                Actress: Bess Flowers (855 credits).
          (voice):
                Actor: Frank Welker (4,012 credits).
                Actress: Ikue Ohtani (2,169 credits).
          (archive footage):
                Actor: Adolf Hitler (963 credits) Adolf.
                Actress: Hillary Clinton and Madonna (291 credits each).
          (credit only):
                Actor: Matthew Ashford (I) (1,456 credits).
                Actress: Gaby Milder (591 credits).
  • Names with most self credits:
          Actor: Alex Trebek (7,183 credits).
          Actress: Vanna White (6,175 credits).

D. LARGEST CAST LISTS
E. HIGHEST ORDER/POSITION NUMBERS
(this is wrong info that needs to be amended by someone who knows the correct position numbers)
F. MOST CHARACTER ROLES IN A SINGLE CREDIT

(I'll let some rest to the computer now... poor SPSS has been calculating nonstop for hours...) OrdenadorIndy


TL;DR:
IMDB feeds our passion for cinema in many different ways... with numbers too!

Guitarra

Champion

 • 

4.6K Messages

 • 

236.3K Points

9 years ago

The site had a 'prolific' list but it became pretty useless when tv episodes became titles. It, when canned was all tv show names who were in daily shows and maybe some porn stars. People wondering where John Wayne or others might land actually found no real movie stars. I always thought it was interesting and people ask the question "who is..." all the time.

Nice bunch of stats!

http://www.imdb.com/Prolific/actors

8.5K Messages

 • 

176.2K Points

6 years ago


HI!   ljdoncel, Champion
anything New to add ? ?

Now there are ...
http://www.imdb.com/pressroom/stats/
Titles: 5,626,984  |  Names: 9,572,880
.

Champion

 • 

1.1K Messages

 • 

51.4K Points

Hi, ACT_1:

Due to the data contained in the new tsv files, many of the numbers that could be retrieved before, are no longer available. Fortunately, I can recalculate some of them, and even give some new info.

If you wish, I'll wait until the end of the year so I can download data as of 31 Dec 2018, and them give me some days to process them.

Happy holidays!

8.5K Messages

 • 

176.2K Points


and you read this .... add some of Your comments ? ?   I did ;-)

https://getsatisfaction.com/imdb/topics/imdb-data-now-easily-available-to-contributors
IMDb Data – Now easily available to contributors
Today (20 Dec 2018) we are pleased to announce
the IMDb datasets are easier to access
and now directly from imdb.com.  Using the new interface, contributors can bulk-access subsets of IMDb title and name data for personal and non-commercial use. Each dataset file is in a gzipped, tab-separated-values (TSV) format.ll

To access the datasets and for more information you can go here:
https://contribute.imdb.com/czone

by Stewart, Official Rep

.

Champion

 • 

1.1K Messages

 • 

51.4K Points

Hi, ACT_1:
Titles ending with odd numbers are blank
This started years ago ??
Sure. As I pointed to you one year ago, this had been confirmed by former staff member Owen Rees in another thread (knowing you, it's strange that you don't keep track of that info ).

The image below shows you graphically the moment started to use even ttconsts only.

As of 09 Jul 2020, 6,964,909 titles are identified primarily* by 5,806,375 (83.4%) even ttconsts and 1,158,534 (16.6%) odd ttconsts.

*Some "unused" ttconsts actually redirect to a title.

Cheers!

10.7K Messages

 • 

225.4K Points

That participant is better known for tracking IMDb user accounts, but that was mostly back when the IMDb·Com message boards software was still operational.

8.5K Messages

 • 

176.2K Points

  
This may get deleted soon...

1,957,541 Registered Apr 2020

Fri May 01 2020 https://www.imdb.com/user/ur117637010
Sat May 02 2020 https://www.imdb.com/user/ur117696000
Sun May 03 2020 https://www.imdb.com/user/ur117756000 - 60,000
Mon May 04 2020 https://www.imdb.com/user/ur117816000 - 60,000
Tue May 05 2020 https://www.imdb.com/user/ur117870000 - 54,000
Wed May 06 2020 https://www.imdb.com/user/ur117922000 - 52,000
Thu May 07 2020 https://www.imdb.com/user/ur117985000 - 63,000
Fri May 08 2020 https://www.imdb.com/user/ur118000000 <
Fri May 08 2020 https://www.imdb.com/user/ur118046000 - 61,000
Sat May 09 2020 https://www.imdb.com/user/ur118100000 - 54,000
Sun May 10 2020 https://www.imdb.com/user/ur118159000 - 59,000
Mon May 11 2020 https://www.imdb.com/user/ur118214000 - 55,000
Tue May 12 2020 https://www.imdb.com/user/ur118264000 - 50,000
Wed May 13 2020 https://www.imdb.com/user/ur118313000 - 49,000
Thu May 14 2020 https://www.imdb.com/user/ur118360000 - 47,000
Fri May 15 2020 https://www.imdb.com/user/ur118409000 - 49,000
Sat May 16 2020 https://www.imdb.com/user/ur118460000 - 51,000
Sun May 17 2020 https://www.imdb.com/user/ur118511000 - 51,000
Mon May 18 2020 https://www.imdb.com/user/ur118567000 - 56,000
Tue May 19 2020 https://www.imdb.com/user/ur118615000 - 48,000
Wed May 20 2020 https://www.imdb.com/user/ur118661000 - 46,000
Thu May 21 2020 https://www.imdb.com/user/ur118710000 - 49,000
Fri May 22 2020 https://www.imdb.com/user/ur118756000 - 46,000
Sat May 23 2020 https://www.imdb.com/user/ur118801000 - 45,000
Sun May 24 2020 https://www.imdb.com/user/ur118848000 - 47,000
Mon May 25 2020 https://www.imdb.com/user/ur118897000 - 49,000
Tue May 26 2020 https://www.imdb.com/user/ur118946000 - 49,000
Wed May 27 2020 https://www.imdb.com/user/ur118991000 - 45,000
Wed May 27 2020 https://www.imdb.com/user/ur119000000 <
Thu May 28 2020 https://www.imdb.com/user/ur119036000 - 45,000
Fri May 29 2020 https://www.imdb.com/user/ur119078000 - 42,000
Sat May 30 2020 https://www.imdb.com/user/ur119121000 - 43,000
Sun May 31 2020 https://www.imdb.com/user/ur119165000 - 44,000
1,570,924 Registered May 2020

Mon Jun 01 2020 https://www.imdb.com/user/ur119207934
Tue Jun 02 2020 https://www.imdb.com/user/ur119248000
Wed JUn 03 2020 https://www.imdb.com/user/ur119286000 - 38,000
Thu Jun 04 2020 https://www.imdb.com/user/ur119330000 - 44,000
Fri Jun 05 2020 https://www.imdb.com/user/ur119371000 - 41,000
Sat Jun 06 2020 https://www.imdb.com/user/ur119410000 - 39,000
Sun Jun 07 2020 https://www.imdb.com/user/ur119451000 - 41,000
Mon Jun 08 2020 https://www.imdb.com/user/ur119491000 - 40,000
Tue Jun 09 2020 https://www.imdb.com/user/ur119531000 - 40,000
Wed Jun 10 2020 https://www.imdb.com/user/ur119571000 - 40,000
Thu Jun 11 2020 https://www.imdb.com/user/ur119609000 - 38,000
Fri Jun 12 2020 https://www.imdb.com/user/ur119649000 - 40,000
Sat Jun 13 2020 https://www.imdb.com/user/ur119690000 - 41,000
Sun Jun 14 2020 https://www.imdb.com/user/ur119730000 - 40,000
Mon Jun 15 2020 https://www.imdb.com/user/ur119770000 - 40,000
Tue Jun 16 2020 https://www.imdb.com/user/ur119810000 - 40,000 
Wed Jun 17 2020 https://www.imdb.com/user/ur119851000 - 41,000
Thu Jun 18 2020 https://www.imdb.com/user/ur119890000 - 39,000
Fri Jun 19 2020 https://www.imdb.com/user/ur119930000 - 40,000
Sat Jun 20 2020 https://www.imdb.com/user/ur119970000 - 40,000
Sat Jun 20 2020 https://www.imdb.com/user/ur120000000 <
Sun Jun 21 2020 https://www.imdb.com/user/ur120010000 - 40,000
Mon Jun 22 2020 https://www.imdb.com/user/ur120060000 - 50,000
Tue Jun 23 2020 https://www.imdb.com/user/ur120100000 - 40,000
Wed Jun 24 2020 https://www.imdb.com/user/ur120141000 - 41,000
Thu Jun 25 2020 https://www.imdb.com/user/ur120180000 - 39,000
Fri Jun 26 2020 https://www.imdb.com/user/ur120220000 - 40,000
Sat Jun 27 2020 https://www.imdb.com/user/ur120260000 - 40,000
Sun Jun 28 2020 https://www.imdb.com/user/ur120300000 - 40,000
Mon Jun 29 2020 https://www.imdb.com/user/ur120352000 - 52,000
Tue Jun 30 2020 https://www.imdb.com/user/ur120392000 - 40,000
1,223,672 Registered Jun 2020

Wed Jul 01 2020 https://www.imdb.com/user/ur120431607
Thu Jul 02 2020 https://www.imdb.com/user/ur120470000
Fri Jul 03 2020 https://www.imdb.com/user/ur120512000 - 42,000
Sat Jul 04 2020 https://www.imdb.com/user/ur120552000 - 40,000
Sun Jul 05 2020 https://www.imdb.com/user/ur120596000 - 44,000
Mon Jul 06 2020 https://www.imdb.com/user/ur120637000 - 42,000
Tue Jul 07 2020 https://www.imdb.com/user/ur120678000 - 41,000
Wed Jul 08 2020 https://www.imdb.com/user/ur120719000 - 41,000
Thu Jul 09 2020 https://www.imdb.com/user/ur120759000 - 40,000
Fri Jul 10 2020 https://www.imdb.com/user/ur120799000 - 40,000
Sat Jul 11 2020 https://www.imdb.com/user/ur120841000 - 42,000
Sun Jul 12 2020 https://www.imdb.com/user/ur120890000 - 49,000
- - -
  
Wayback IMDb Message Boards
http://web.archive.org/web/20170210140000/http://www.imdb.com/boards/
  
I Need To Know : Boards Closure FAQ
by Col Needham
IMDb Staff Member
Wed Feb 8 2017 00:00:24
Thanks for all the feedback here and on
https://getsatisfaction.com/imdb/topics/imdb-message-boards.
We have gathered our responses in an FAQ at
http://www.imdb.com/help/show_leaf?boardsclosurefaq.
Col
http://web.archive.org/web/20170219202927/http://www.imdb.com/board/bd0000001/thread/265872671
- - -
  
Statistics and curious facts about acting credits
http://web.archive.org/web/*/https://getsatisfaction.com/imdb/topics/statistics-and-curious-facts-ab...
Saved July 9, 2020
.

Champion

 • 

5K Messages

 • 

118.3K Points

4 years ago

Hi, ljdoncel.
Is there an automated way to search for people with 100+ feature film credits that are NOT silent films?
https://www.imdb.com/list/ls021379096/
For instance, William Boyd  doesn't qualify with 141 feature film credits because 56 are silent.
I don't have access to any query software, so I guess I'm asking if it's a query that YOU could do.
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.

Champion

 • 

1.1K Messages

 • 

51.4K Points

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").


So, can we use the datasets?
  • 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... ...  ... ... Done!

Despite the aforementioned faults, I'll post here a small analysis. A few premilinar comments:
  • 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.



Here are the results:

DATASET ANALYZED: TSV FILES
        Files used:
                · name.filmography.tsv@05 Jul 2020
                · title.basics.tsv@07 Jul 2020

         1,221,042 films out of 6,964,909 titles.
                 SILENT ERA (1874-1929): 138,720 titles (11.4%).
                 TRANSITION PERIOD (1930-1938): 27,214 titles (2.2%).
                 SOUND ERA (1939-2115): 1,055,108 titles (86.4%).

         8,627,911 acting credits out of 142,796,275 name filmography credits.
                 65.9% actor (5,683,857 credits) vs 34.1% actress (2,944,054 credits).
                 SILENT ERA (1874-1929): 404,124 credits (4.7%) ~ 34.6% of them for actresses.
                     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.

         Definition of potential candidate (arbitrary):
                  "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.


DATASET ANALYZED: LIST FILES
        Files used:
                · 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

         1,067,875 films out of 4,697,740 titles.
                 SILENT SOUND MIX: 134,918 titles (12.6%).
                 UNAVAILABLE SOUND MIX (blank or unmatched field): 718,159 titles (67.3%).
                 NON-SILENT SOUND MIX: 214,798 titles (20.1%).

         7,532,079 acting credits out of 25,716,233 cast credits.
                 66.2% actor (4,987,518 credits) vs 33.8% actress (2,544,561 credits).
                 SILENT SOUND MIX: 391,726 credits (5.2%) ~ 34.8% of them for actresses.
                     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.

        Definition of potential candidate (arbitrary):
                  "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!

Champion

 • 

5K Messages

 • 

118.3K Points

This is awesome. I'll use the 2nd list.
I'm primarily interested in English-language film careers (although I've already made 2 exceptions for French women, which I may have to retract to make my rules have meaning), so I can see many names that I won't need to research. And your search didn't seem to restrict to feature films, because Mel Blanc doesn't have 100+. But having a base of 3k names to go through is very cool. THANK YOU! 

It would have been really nice to have the nm## name constants for these folks, but this is good.
Now I'll do a little spreadsheet work to whittle things down. Yay.

Champion

 • 

19.4K Messages

 • 

477.1K Points

ljdoncel,

To say that I am impressed would be a vast understatement.

Champion

 • 

1.1K Messages

 • 

51.4K Points

@Dan:
Thank you very much for your really kind words... as always...


@bderoes:
Sorry, I missed the feature part of your question and included short films in the analysis (my fault...). I've updated the numbers below (I've used genres-list@22 Dec 2017 to filter out shorts, btw).

DATASET ANALYZED: TSV FILES

         490,088 feature films / 6,259,872 acting credits (33.3% ).
                 SILENT ERA (1874-1929): 35,014 films / 228,953 credits (34.4% ).
                 TRANSITION PERIOD (1930-1938): 18,313 films / 258,891 credits (27.9% ).
                 SOUND ERA (1939-2115): 436,761 films / 5,772,028 credits (33.5% ).

There are 3,292 NAMES (2,785 / 507 ) who meet this criteria (270 fewer than before).

DATASET ANALYZED: LIST FILES

         360,713 feature films / 5,125,496 acting credits (33.2% ).
                 SILENT SOUND MIX: 18,911 films / 144,215 credits (34.5% ).
                 UNAVAILABLE SOUND MIX: 217,444 films / 2,185,591 credits (36.1% ).
                 NON-SILENT SOUND MIX: 124,358 films / 2,795,690 credits (30.9% ).

There are 2,302 NAMES (2,042 / 260 ) who meet this criteria (822 fewer than before).

Champion

 • 

19.4K Messages

 • 

477.1K Points

ljdoncel and bderoes,

Somewhere in this wealth of interesting data, must be an interesting poll. If someone else or I develop a poll based on this information, I will make certain that you both are properly credited.

Champion

 • 

5K Messages

 • 

118.3K Points

I've completed entering the names culled from ljdoncel's data mining.
I've realized many flaws with the data I've posted with each name; we'll see if I can resist revisiting the entire list.
https://www.imdb.com/list/ls021379096/