IMDb Data – Now available in Amazon S3

First of all, thanx alot for the http access and the added title.akas.tsv
i was so happy that this new file includes the language of the movie as well now
but either the languages of the movies are wrong in that file, or something is missing

if a movies does not have an akas title, is it by default in english language ?

and why have movies with type = original and isOriginalTitle = 1 no language defined at all ?

thanx in advance for any help
this seems to go into the right direction

This reply was created from a merged topic originally titled need fields added to exported csv file: country, release year not date, cast,-act....

I would like to download special customized fields to my watchlist download or customized list  that include Title, Release Year, Country of origin, type of title (movie, tv, miniseries, etc...), cast + character, director, description.  The watchlist download currently has title, full date, director, type of show, and numerous links & ratings (that I do not want).  WHO CAN HELP ME WITH THIS???  If I need IMDBpro, I will definitely get it.  By the way does Amazon own IMDB?  What about the software programs referenced -- do I need those like open source software like Linx, Apache, GNU and Linux utilities.  I am just sole proprietor helping an inmate with compiling movie data not a major corporation.  PLEASE HELP PLEASE HELP.  YOU CAN REACH ME AT wohlfop@outlook.com, wohlfop@gmail.com, typingandinmate@gmail.com and/or 540 915 0683 

I am working on these files to interface with my personal database.

in ttprincipals.principalCast (and probably the other multivalued fields), I cannot figure out the sorting criteria: it is neither the one displayed on screen, nor the nn9999999 code itself, nor the resulting alphabetical order.

Please, could an IMDB rep clarify this?
Thanks in advance.

This reply was created from a merged topic originally titled IMDb Data Files Available for download.

According to your website:  (http://www.imdb.com/interfaces/) "The dataset files can be accessed and downloaded from https://datasets.imdbws.com/. The data is refreshed daily."   I'm looking at the downloadable file:  name.basics.tsv.gz , according to that file (downloaded 12/30/2017)...Victor Brooks (nm0003499) is not deceased, but if you look up nm0003499 on your website, he died in 1999.   Same for Leslie Adams (nm0011145)...he is alive according to name.basics.tsv.gz, but if you look nm0011145 up on your website he is deceased as of 1993.   Are these dataset files no longer updated?   Thanks

I don't see an equivalent to the ftp interface's business.list.  Will this be coming later to the S3 interface?

For those interested, pick up "ImportNewImdb" on GitHub, it's my code to import the new datasets into a sqlite database, with some post processing to create a kind-of old-style name-movie link.
It's written in ObjC because I am in iOS programming, but it's quite straight forward to follow.
It reads the dataset and generates a 5gb sqlite db in about ten minutes.

In the final db there is a "characters" table searchable by tconst or nconst with data taken both from "principal cast" or "known for", as well as director/writers links taken from "title.crew"
Maybe there will be some intersection in the data (between "known for" and "principals" for example), but it depends on how you will use the data.

To give an idea, with last dataset I have these numbers:

select ttype, count(*) from characters group by ttype

"d" "3,330,550"

"w" "5,172,706"

"k" "14,158,036"

"p" "26,520,981"

where "d" stands for director,  "w" for writers, "k" for "known for", "p" from "principals".

It's not like the data available in old datasets, but it's a start.

Just to give the context, I use this db in my personal iOS app I use since many years to track and vote the movies/series/episodes I watch (I have a bad memory, so I never know if I have already seen a movie or not...) and using a colored icon on filmography/cast I can visually answer questions like "where have I seen this guy, he/she seems familiar to me".

I also used to write some funny queries to answer questions like "who is my favorite actor/actress/director" based on the votes I give, and many other queries like "which is my favorite genre or country of origin", but this will be no more accurate or possible not having a full database, so bad: I will have to rely on my sensations instead that on pure numbers...

I cannot wait to see if I will be eligible to the promised new full exports, even if I think I will not since I am more a data user than a real contributor.

Best regards

I'm now running some final import tests before I release the next version of my application as well.
I'll add a link once the release is available. The old version currently still available will be removed tomorrow as it wouldn't work as required do to some data problems in the old LIST files.

As I wrote earlier, currently the new version of the application will only support importing new TSV data into the database while you get full support for the old LIST files.
This means the GUI will only support looking up the details from the old LIST files plus links between those old data files as the new TSV data format is still of no actual use in it's current state.

Officially supported databases are PostgreSQL, MySQL and MS SQL Server (inofficially more databases are supported but only for testing of my abstraction layer - this includes Oracle, H2, DB2, etc.).
I highly recommend using PostgreSQL (the new v10 or at least some v9.3+) instead of MySQL v5.1.x (including MariaDB - latest releases have not been tested) and also MS SQL Server for actually everything (speed, feature and overall usage).
Importing the data is faster with PostgreSQL 9.x/10 compared to MySQL 5.1.x (InnoDB engine) and if you really want to hurt yourself go for MS SQL Server (slow as hell importing the data).
On the query side this might not make much of a difference as I support full text seach on all of the databases. Still PostgreSQL does offer some extras.

That's it for the moment.

Teaser! ;)
One of these PostgreSQL extras hasn't been activated yet but is basically some AJAX-like direct feedback when you enter your search into an input field where you see suggestions you can directly select (just as you type something on IMDb, Google, etc.). Using the PostgreSQL full text index statistic function (ts_stat()) you can get details about the words stored in the index which makes it easy to add such a function. MySQL has a simmilar function but this is not available via SQL. You actually need to call an executable which makes it unusable inside an application.

@alexdark72 and @J,

Even though it is (still) a little bit over my skills (ask me rather about MS Access, and the management of its 2 GB size limit !), I am amazed and so thankful for what you are developping and sharing with our small community. You are doing an amazing job! Thanks so much again.

I have been working further with title.principals.tsv, I can only acknowledge that what is stated on the http://www.imdb.com/interfaces/ page is true: "Contains the principal cast/crew for titles".
So it does/can display editor, music composer, cinematographer, actors, directors (as a duplicate with title.basics...), and I don't think I spotted any writer (who are in title.basics). But there is absolutely no rule presiding over the actual content.

Hence, absolutely useless.

This reply was created from a merged topic originally titled business.list at S3.

I don't see an equivalent to the ftp interface's business.list at https://datasets.imdbws.com/.  Will this be coming later to the S3 interface?

(I posted this question in the larger S3 thread but it seems to have been lost in the shuffle so I've made this dedicated thread to it.)

Thank you for making the new data formats available to download easily at https://datasets.imdbws.com/. I have reviewed the information currently presented, and while I'm hoping that eventually all of the data will be available again, if it does need to be rolled out slowly here is my request for the most urgent things to be rolled out first:

1. In the title.crew.tsv file, please also include the "attributes". For example for title tt0041700 (Not Wanted (1949)) for the director nm0526946 (Ida Lupino) she has the attribute "uncredited".

2. Company credits. We currently have some basic information for movies and people, but I would also like a database for companies to be added immediately.

Also I just realized now you have to be an IMDBPro member just to view company pages? Why is this? I tried to link to the company page for The Archers (http://www.imdb.com/company/co0103153?ref_=ttco_co_1) for instance and it just sent me a message that I can't view it without being an IMDBPro member. This is a separate but I suppose related issue of making the data unobtainable to people. This is very disappointing.

I have made the switch to the new files. Having the tconst is very useful, and having direct HTTP access rather than using S3 is much simpler. I would like to reiterate my request for the languages and the top 250 movies to be provided. That is all I am missing to make my application as functional as it was before.

I just realize that IMDB has removed some movies from their files and site. I don't know how many but I have Lucky Luke animations and some of them are not listed in title.basics.tsv. I also found out that those animations are marked as suspended in the latest movies.list but in older one (30.12.2016) they are not. Here is one example:

old:     "Lucky Luke" (1984) {Le juge (#2.2)}                    1991
latest: "Lucky Luke" (1984) {Le juge (#2.2)} {{SUSPENDED}}      1991

I am doing some personal SQL database bulk import and queries from the downloaded tsv files, one of which is name.basics.tsv. Given the social interest, is there a gender column available? One of my investigative queries was to look at comparative trends in male and female actor age (I can get age from date-of-birth subtracted from episode year) over a long-running TV series.

This reply was created from a merged topic originally titled No documentation for title.akas.tsv.gz.

In the Interfaces page (https://www.imdb.com/interfaces/?ref_=helpms_ih_gi_siteindex), there is not listing of the fields and descriptions for the title.akas.tsv.gz file.  While the field names in the file are essentially self-evident, it would be helpful to have the documentation available so users can be certain of the data in the file.