Freebase: What data dump file contains the "imdb_id"? Freebase: What data dump file contains the "imdb_id"? database database

Freebase: What data dump file contains the "imdb_id"?


That imdb_id property is backed by a key in the /authority/imdb/title namespace, so you're looking for the line:

/m/015gxt       /type/object/key        /authority/imdb/title   tt0065126

in the file http://download.freebase.com/datadumps/latest/freebase-datadump-quadruples.tsv.bz2

That's a 4 GB file, so be prepared to wait a little while for the download. Note that everything is keyed by MID, so you'll need to figure that out first if you don't have it in your database.

The equivalent query using MQL instead of the data dumps is https://www.googleapis.com/freebase/v1/mqlread?query=%7B%22type%22%3a%22/film/film%22,%22name%22%3a%22True%20Grit%22,%22imdb_id%22%3anull,%22initial_release_date%3E=%22%3a%221969-01%22,%22mid%22:null,%22key%22:[{%22namespace%22:%22/authority/imdb/title%22}],%22limit%22:1%7D&indent=1

EDIT: p.s. I'm pretty sure the files in the Browse directory are going away, so I wouldn't depend on them even if you could find the info there.


The previous answer works fine, it's just that a snappier version of such a query could be:

query = [{          'type': '/film/film',          'name': 'prometheus',          'imdb_id': null,          ...        }];

The rest of the MQL request isn't mentionned as it doesn't differ from the aforementioned. Hope that helps.