Provisional IMDb Stats update (@ACT_1) and Birth dates search (@bderoes)

  • 1
  • Praise
  • Updated 1 year ago
Hey, ACT_1:



(Since Col has closed the previous thread because, I guess, it was going off-topic, I'll try to give you a quick update on IMDb numbers; I hope that official Stats page will be rebuilt on the new technology soon)

New tsv files are vastly less informative than former list files, but many basic numbers can be retrieved from them.

From title.basics.tsv and name.basics.tsv (27 Apr 2018):

TOTAL TITLES: 4,963,640 (year range: 1874-2125)

    By type:

          Film: 483,967

          Short film: 618,077

          Video: 198,292

          TV movie: 124,700

          TV short: 8,364

          TV special: 10,729

          Series (parent): 145,688

          Miniseries: 22,295

          Episode: 3,330,222

          Videogame: 21,306


    By genre:
       (tsv file only offers up to 4 genres per title, yet we know that actually over 24,000 titles
        have 5 or more genres attached, so the following numbers are a bit underestimated)

          Action: 212,199
          Adventure: 176,860
          Adult: 145,700
                Oddly, 83 titles (such as Anal Empire 5, Dripping Creampies 4 or
                      White Bitch Sandwich 5) have the Adult genre, but are identified as
                      "non-adult titles" according to the boolean field isAdult ()
          Animation: 260,286
          Biography: 60,760
          Comedy: 1,080,819
          Crime: 226,884
          Documentary: 512,811
          Drama: 1,238,313
          Family: 352,590
          Fantasy: 95,988
          Film-Noir: 768
          Game-Show: 172,956
          History: 67,705
          Horror: 93,272
          Musical: 37,702
          Music: 263,378
          Mystery: 107,142
          News: 348,702
          Reality-TV: 243,568
          Romance: 424,334
          Sci-Fi: 73,394
          Short: 688,266
          Sport: 103,065
          Thriller: 86,944
          Talk-Show: 467,764
          War: 21,575
          Western: 25,180


    By year:
      



TOTAL NAMES: 8,573,409 (total credits unavailable)

    By primary profession:
       (tsv file only offers up to 3 professions per name, so people with 4 o more frequent roles
        may cause the following numbers to be an underestimation too; note that, unlike IMDb
        Stats page, these numbers count people, not credits)

          Actress: 2,077,042
          Actress: 1,229,310
          Animation department: 136,496
          Art department: 306,231
          Art director: 64,068
          Assistant: 2,704
          Assistant director: 172,536
          Camera department: 528,912
          Casting department: 37,737
          Casting director: 21,906
          Cinematographer: 243,471
          Composer: 207,768
          Costume department: 101,607
          Costume designer: 53,725
          Director: 466,941
          Editor: 230,387
          Editorial department: 125,140
          Electrical department: 1
          Executive: 22,653
          Legal: 2,781
          Location management: 51,896
          Make-up department: 151,494
          Manager: 9,373
          Miscellaneous: 952,138
          Music department: 161,633
          Producer: 756,897
          Production department: 2
          Production designer: 57,099
          Production manager: 142,727
          Publicist: 2,868
          Script department: 1
          Set decorator: 38,391
          Sound department: 270,807
          Soundtrack: 120,469
          Special effects: 49,785
          Stunts: 61,885
          Talent agent: 9,651
          Transportation department: 65,516
          Visual effects: 149,720
          Writer: 580,743


    By birth year and death year:
      
      


    By birthday and deathday:
       (in fact, these graphics come from biographies.list [22 Dec 2017] because the tsv file only
        gives birth/death years, not months nor days, but, just for fun after reading this thread, I'd
        like to post it here)
      
      
Photo of ljdoncel

ljdoncel, Champion

  • 833 Posts
  • 1759 Reply Likes

Posted 1 year ago

  • 1
Photo of ljdoncel

ljdoncel, Champion

  • 833 Posts
  • 1759 Reply Likes
@bderoes:
You're absolutely right that, if we rely on Advanced Name Search to find out the earliest-born person on , we'll end up thinking that it's this one (who, piquantly enough, has wrong birth date and place), when we positively know that (using your same example) Homer's birth occurred much earlier...



Moreover, not only BC dates aren't searchable, but neither are any date that doesn't match the YYYY format (e.g. circa dates), as in Larry Abbott (I)'s birth date. When doing an ATS search for people born in 1936 (or within the range 1935-1937), his name isn't one of the results, although the birth info is there in both his name page and update form.



Besides incompleteness, another downside of the tsv files is that their data are "less pure" than list files's; I mean, info provided by list files seemed to come from the very inners of the database, so that every data (either displayed/visible or "hidden" within the update form) was available. In other words, list files were "raw pieces" from the source, so investigating most errors was viable. On the other hand, tsv files are processed fragments that, in many cases, don't allow us to reach the root of the problem. If we look for the birth dates of Homer (I) and Larry Abbott (I) in the tsv archive, they show up as missing values (/N)...



...but if we explore the latter list file, ta-da!...


As of 27 Dec 2017, 16 people have BC birth or death dates listed. Homer (I) is, indeed, the earliest-born person on (c. 850 BC - c. 800 BC), followed by Aesop (I) (c. 620 BC - c. 560 BC), Lao-Tse (604 BC - 531 BC), Confucius (551 BC - 479 BC), Aeschylus (525 BC - 456 BC), Sophocles (496 BC - 406 BC), Euripides (c. 484 BC - 406 BC), Socrates (II) (c. 470 BC - 399 BC), Aristophanes (I) (c. 450 BC - c. 388 BC), Xenophon (430 BC - 354 BC), Plato (I) (427 BC - 347 BC), Titus Maccius Plautus (254 BC - 184 BC), Gaio Giulio Cesare (100 BC - 44 BC), Publius Vergilius Maro (70 BC - 19 BC), Ovid (43 BC - AD 17) and Philo Judaeus (20 BC - AD 50). Neither of them appears on a search filtered by date.

Same happens with another 1,572 people who have circa dates. I'll leave their names here just in case any fellow contributor (we miss you, Lina) would like to research the exact birth or death dates, so these people finally stop being invisible to the search engine.



       ► PDF file (968 KB) here
Photo of bderoes

bderoes, Champion

  • 1451 Posts
  • 2351 Reply Likes
Advanced name search:
Males/Females (Sorted by Birth Date Ascending)
1-50 of 4,982,828 names. | Next »

versus your finding  TOTAL NAMES: 8,573,409 (total credits unavailable)

I can't see how to make ANS find all people.
This is akin to my discovering that we cannot search for titles with fewer than 5 votes (reported). The number of votes field doesn't get populated until 5 are tallied, and a blank field is not interpreted as 0.
Photo of Marco

Marco

  • 1123 Posts
  • 1390 Reply Likes
Same happens with another 1,572 people who have circa dates. I'll leave their names here just in case any fellow contributor (we miss you, Lina) would like to research the exact birth or death dates, so these people finally stop being invisible to the search engine.
As always you've created an extremely useful list ljdoncel! I can't help out here (Lina sure is missed!), but I did notice that both Jim Kid and Jim Kidd (I) have the exact same date of birth and death: https://www.imdb.com/name/nm0452208/ and https://www.imdb.com/name/nm1130112/. Perhaps someone can try to fix this?
Photo of ljdoncel

ljdoncel, Champion

  • 833 Posts
  • 1759 Reply Likes
Jim Kid and Jim Kidd (I) have the exact same date of birth and death
Fantastic catch, Marco! Thank you very much...

And, of course, here's what you're expecting now...

As of 27 Dec 2017, there were 6 trios and 731 couples who share exact same dates of birth and death (I've only checked people with complete records [day, month, year]). A quick look at the list reveals lots of potential duplicates that should be considered for merging.



       ► PDF file (768 KB) here


Photo of ACT_1

ACT_1

  • 3613 Posts
  • 3490 Reply Likes

@ ljdoncel, Champion

From title.basics.tsv and name.basics.tsv (27 Apr 2018):

TOTAL TITLES: 4,963,640 (year range: 1874-2125)

TOTAL NAMES: 8,573,409 (total credits unavailable)

Names do not list 'Non-People' ?

- - -

April 28 2018

Must be a of blank pages or ???

Titles: 8,3450,00
Palavras Cruzadas (TV Series) Episode #1.78
https://www.imdb.com/title/tt8345000/

Names: 9,802,000
Shannon Two Feathers
https://www.imdb.com/name/nm9802000/


oh and
Users: 87,807,000
bimoeko
https://www.imdb.com/user/ur87807000/


(Edited)
Photo of bderoes

bderoes, Champion

  • 1451 Posts
  • 2351 Reply Likes
ACT_1:
Since you are publishing the numbers now, you can be more accurate about describing the numbers. That is my request. 

I didn't follow the press releases in the past. I don't know if their numbers matched their nomenclature. Perhaps they were giving accurate counts of how many titles/names(people)/etc. were active in the database, maybe they weren't. Since they're not publishing such numbers now, there's no point to questioning their use of the terms: they're not using any terminology in the publications they're not producing.
Photo of ACT_1

ACT_1

  • 3613 Posts
  • 3490 Reply Likes

by bderoes, Champion
ACT_1:
Since you are publishing the numbers now

I didn't follow the press releases in the past

- - -

May 1 2018

??
http://web.archive.org/web/*/http://www.imdb.com/
http://web.archive.org/web/*/http://www.imdb.com/stats
http://web.archive.org/web/*/http://www.imdb.com/pressroom/stats/
- - -

I look at Users Names (Numbers) every day
I look at IMDb Stats page every few days (No change since December 11 2017)


There are gaps in the Numbers for Titles added past 24 hours
looking at a few samples...

Credlin (TV Series) Episode #2.66  (2018)
https://www.imdb.com/title/tt8355700/reference

The requested URL was not found on our server
https://www.imdb.com/title/tt8355800/reference

Hunters Lair (TV Series)
He hosed down the hot waitress
https://www.imdb.com/title/tt8355900/reference
- - -

Kent Ripley (II)
https://www.imdb.com/name/nm9808500/
- - -

kelompoksimf
IMDb member since May 1 2018
https://www.imdb.com/user/ur87906000
- - -

In case that Old post is goned:

Col Needham, Official Rep
May 10 2017
The stats are counting the number of live names and titles. 
Sometimes the same data is accepted more than once and needs to be merged to a single page.
Sometimes titles are cancelled and removed from IMDb
(and cause names attached to them to be removed too).
We do no re-use numbers once they have been allocated.


Date                         | Titles         | NAMES      | Users          | Messages      | GetSat Members
Sun Jan 03 2016 | 3,579,619 | 6,954,109 | 64,670,000 | 252,222,500 | 32,575

Sun Jan 01 2017 | 4,055,198 | 7,653,862 | 70,940,000 | 264,684,500 | 44,481
Sun Jan 08 2017 | 4,065,547 | 7,667,743 | 71,170,000 | 264,906,500 | 44,747
Sun Jan 15 2017 | 4,076,782 | 7,681,155 | 71,350,000 | 265,118,500 | 44,978
Sun Jan 22 2017 | 4,082,490 | 7,689,701 | 71,810,000 | 265,333,500 | 45,205
Sun Jan 29 2017 | 4,100,780 | 7,709,516 | 72,150,000 | 265,558,500 | 45,495

Sun Feb 05 2017 | 4,110,913 | 7,721,408 | 72,430,000 | 265,803,500 | 45,847
Sun Feb 12 2017 | 4,121,040 | 7,732,946 | 72,710,000 | 265,991,500 | 46,158
Sun Feb 19 2017 | 4,129,630 | 7,743,564 | 73,060,000 | 266,164,000 | 46,441
The IMDb message boards were disabled on February 20, 2017
Sun Feb 26 2017 | 4,145,013 | 7,759,715 | 73,350,000 | ........... | 46,841

Sun Mar 05 2017 | 4,159,263 | 7,772,451 | 73,600,500 | ........... | 47,139
Sun Mar 12 2017 | 4,172,226 | 7,784,957 | 73,900,000 | ........... | 47,455
Sun Mar 19 2017 | 4,185,052 | 7,799,110 | 74,160,000 | ........... | 47,714
Sun Mar 26 2017 | 4,200,424 | 7,813,791 | 74,390,000 | ........... | 47,980

Sun Apr 02 2017 | 4,213,112 | 7,827,052 | 74,600,000 | ........... | 48,248
Sun Apr 09 2017 | 4,226,627 | 7,839,809 | 74,850,000 | ........... | 48,374
Sun Apr 16 2017 | 4,233,008 | 7,846,229 | 75,130,000 | ........... | 48,374
Sun Apr 23 2017 | 4,251,054 | 7,864,227 | 75,480,000 | ........... | 48,374
Sun Apr 30 2017 | 4,261,878 | 7,877,203 | 75,728,500 | ........... | 48,374

Sun May 07 2017 | 4,271,010 | 7,887,974 | 76,010,000 | ........... | 48,374
Sun May 15 2017 | 4,283,975 | 7,904,697 | 76,290,000 | ........... | 48,374
Sun May 21 2017 | 4,297,305 | 7,917,841 | 76,520,000 | ........... | 48,374
Sun May 28 2017 | 4,310,352 | 7,930,060 | 76,760,000 | ........... | 48,374

Sun Jun 04 2017 | 4,323,707 | 7,943,973 | 77,020,000 | ........... | 48,374
Sun Jun 11 2017 | 4,338,089 | 7,957,304 | 77,260,000 | ........... | 48,374
Sun Jun 18 2017 | 4,353,358 | 7,971,562 | 77,480,000 | ........... | 48,374
Sun Jun 25 2017 | 4,367,621 | 7,984,220 | 77,700,000 | ........... | 50,902

Sun Jul 02 2017 | 4,381,346 | 7,996,684 | 77,950,000 | ........... | 51,208
Sun Jul 09 2017 | 4,395,229 | 8,007,900 | 78,200,000 | ........... | 51,406
Sun Jul 16 2017 | 4,406,541 | 8,021,166 | 78,440,000 | ........... | 51,655
Sun Jul 23 2017 | 4,417,680 | 8,034,668 | 78,690,000 | ........... | 51,918
Sun Jul 30 2017 | 4,431,127 | 8,047,620 | 78,930,000 | ........... | 52,146

Sun Aug 06 2017 | 4,444,213 | 8,060,185 | 79,170,000 | ........... | 52,375
Sun Aug 13 3017 | 4,455,609 | 8,073,995 | 79,400,000 | ........... | 52,607
Sun Aug 20 2017 | 4,466,192 | 8,084,890 | 79,640,000 | ........... | 52,825
Sun Aug 27 2017 | 4,479,777 | 8,099,461 | 79,860,000 | ........... | 53,022

Sun Sep 03 2017 | 4,490,946 | 8,111,945 | 80,080,000 | ........... | 53,234
Sun Sep 10 2017 | 4,503,811 | 8,123,123 | 80,300,000 | ........... | 53,466
Sun Sep 17 2017 | 4,517,776 | 8,136,918 | 80,500,000 | ........... | 53,643
Sun Sep 24 2017 | 4,530,827 | 8,149,562 | 80,720,000 | ........... | 53,874

Sun Oct 01 2017 | 4,548,890 | 8,164,086 | 80,940,000 | ........... | 54,100
Sun Oct 08 2017 | 4,562,876 | 8,177,050 | 81,150,000 | ........... | 54,328
Sun Oct 15 2017 | 4,578,813 | 8,190,476 | 81,380,000 | ........... | 54,520
Sun Oct 22 2017 | 4,589,502 | 8,201,499 | 81,600,000 | ........... | 54,752
Sun Oct 29 2017 | 4,603,463 | 8,217,219 | 81,798,000 | ........... | 54,976

Sun Nov 05 2017 | 4,615,802 | 8,228,844 | 82,058,000 | ........... | 55,200
Sun Nov 12 2017 | 4,630,075 | 8,243,760 | 82,270,000 | ........... | 55,560
Sun Nov 19 2017 | 4,638,804 | 8,256,003 | 82,500,000 | ........... | 55,828
Sun Nov 26 2017 | 4,653,694 | 8,272,215 | 82,720,000 | ........... | 56,060

http://www.imdb.com/stats - Now - http://www.imdb.com/pressroom/stats/ ??

Sun Dec 03 2017 | 4,666,319 | 8,286,059 | 82,940,000 | ........... | 56,300
Sun Dec 10 2017 | 4,734,693 | 8,702,001 | 83,150,000 | ........... | 56,725
Sun Dec 17 2017 | 4,734,693 | 8,702,001 | 83,344,600 | ........... | 57,027
Sun Dec 24 2017 | 4,734,693 | 8,702,001 | 83,600,000 | ........... | 57,452
Sun Dec 31 2017 | 4,734,693 | 8,702,001 | 83,883,666 | ........... | 57,754


(Edited)
Photo of ACT_1

ACT_1

  • 3613 Posts
  • 3490 Reply Likes

Not done with EDITS but now it has a LIKE and I can not continue

LIKER needs to wait a while - and Thanks for the LIKES

Photo of bderoes

bderoes, Champion

  • 1451 Posts
  • 2351 Reply Likes
ACT_1:
Don't know why you're recapping all the weekly stats for 2017. IMDb should have tools that can count the actual number of each type. If they ever

I have 2 points (requests):

1) When you publish such numbers now, you are just taking the highest ID# that you find, and calling it the number of things that exist. Just call that the highest ID# consumed, and that will be accurate.

2) Thank you for revising your heading to call the highest name id# "Names" instead of "People". After all, they're coded nm### for a reason. No need to continue IMDb's nomenclature while they're not publishing. If they ever restart, maybe they'll follow your lead and use the more accurate label.

So, combining both my requests, to head your numbers, I'd suggest (revising my earlier suggestion):

Highest ID#s:
Date                         | Titles         | Names      | Users           | GetSat Members
Photo of ACT_1

ACT_1

  • 3613 Posts
  • 3490 Reply Likes

May 1 2018

My Stats count may not be the Highest Number for the Date
Have to do that at Midnight (England time?)
I may round off the Numbers this year
Each day  there are about 30,000 New Users (Titles and Names ?? I do not look at that)
Users Used to have the actual Reg Date on the Profile page but now do not

- - -

I have asked several times to add
"Page Started ___"
"Page Updated ___"
to top of Titles and Names pages
This could be helpful information
as Old Movies and TV shows (episodes) are added years after released

Added today
Omnibus (TV Series)
The Big Wheel - The Burlesque Entertainment of Yesterday  (1957)
https://www.imdb.com/title/tt8348000/

Emergency: Sydney (TV Series)
Deadly Dose  (2019)
https://www.imdb.com/title/tt8351000/
- - -

Ask the Boss :
about recapping all the weekly stats for 2017 & 2018

https://www.imdb.com/pressroom/stats/
Movie 467,523
TV Movie 120,905
Do WE add those to get a total or is TV Movie part of Movie count ?

Credits
Actor 20,267,616
Actress 12,485,267
Producer 7,811,179
Director 3,081,117
How many Actor and Actress ... NAMES ?

Reviews 3,536,271

There are other changes could be made on this page
This is a computer generated report and the Staff people (with names) do not look at it ?

and then there is more Stats
https://contribute.imdb.com/czone/hall_of_fame
Contributor Hall of Fame - We appreciate all our Contributors...

Only count Top Plot Summary Writers and Top Mini-Bio Writers ?

Do not count the Titles or Names added ?

Do not count Top Reviewers or Rats ?? (may not be considered a Contribution)
These are samples and may not be the Top

MartinHafer
IMDb member since June 2003
https://www.imdb.com/user/ur2467618/
https://www.imdb.com/user/ur2467618/reviews - 21,819 Reviews
https://www.imdb.com/user/ur2467618/ratings - 21,554 titles

cutegirlbutts
IMDb member since November 2012
http://www.imdb.com/user/ur37715747
http://www.imdb.com/user/ur37715747/ratings - 27,242 titles

Visitors read these and want to watch or not

- - -

https://contribute.imdb.com/czone/top_msg
Every year, we send a message to our top contributors

Jump to messages for: 2017 | 2016 | 2015 | 2014 | 2013 | 2012 | 2011 | 2010 | 2009 | 2008 | 2007 | 2006 | 2005 | 2004 | 2003 | 2002 | 2001 | 2000 | 1999 | 1998 | 1997 | 1996 | 1995

Message for 2017
The Numbers
IMDb now includes:
•Over 4.8 million titles with over 650,000 added in 2017
•Nearly 8.8 million names with over 700,000 added in 2017
•Over 93 million filmography credits with over 12 million added in 2017
•Over 6.8 million images, 3.4 million videos and 3.5 million customer reviews

ACT_1 Note:
650,000 Titles / 365 days = 1,780 per day  74 per hour
700,000 Names / 365 days = 1,917 per day  80 per hour
12,000,000 Credits / 365 = 32,876 per day 1,369 per hour

Message for 2016
The Numbers
The headlines from the 2016 numbers are:
*IMDb covers over 4 million titles with over 475,000 added in 2016
*IMDb covers over 7.5 million names with over 700,000 added in 2016
*IMDb includes over 81 million filmography credits with nearly 10 million added in 2016

- - -

Since IMDb does not like to use Dates anywhere
I have to guess about daily activites


(Edited)
Photo of ACT_1

ACT_1

  • 3613 Posts
  • 3490 Reply Likes

https://getsatisfaction.com/imdb/topics/-imdb-database-statistics
[ IMDb Database Statistics ]
Posted May 10 2017
by ACT_1


Photo of Col Needham

Col Needham, Official Rep

  • 6834 Posts
  • 4816 Reply Likes
New tsv files are vastly less informative than former list files, but many basic numbers can be retrieved from them.
We saw your comment last week and you should have received an email offering full access to the data set (much more than available previously).  Did you receive the message?
Photo of ljdoncel

ljdoncel, Champion

  • 833 Posts
  • 1759 Reply Likes
Ooops, sorry, Col, I hadn't read the mail... I'm checking it right now. Thank you!