...
Field | Type | Notes |
doc_id | int8 |
|
doctitle | varchar |
|
doctype | text |
|
pages | int8 |
|
pg_info | varchar |
|
source | text | usually the publisher of the document |
src_id | text | source identifier used behind the scenes |
author | text | Can be multiple pipe-separated values. |
name_id | int4 | always '2' because this short identifier is no longer used. |
doclanguage | text | Can be multiple pipe-separated values. |
pubdate | varchar |
|
code | int4 | Access code for this document: |
cast_cr | bool |
|
tech_cr | bool |
|
bx_info | bool |
|
filmog | bool |
|
dist_co | bool |
|
prod_co | bool |
|
costinfo | bool |
|
illust | bool |
|
biblio | bool |
|
docurl | varchar | URL provided for direct access or further information |
pubdatescalar | timestamp | publication date |
srcurl | varchar |
|
docsubject | text | Subject of document. Can be multiple pipe-separated values. |
docnamesubject | text | Named subjects (person or organization) in document. Can be multiple pipe-separated values. |
Notes
NOTE: This table is supposed to have one row per document. As of 3/19/2014 there are 884 documents with two rows, due to the fact that some sources have more than one srcUrl value. That will be fixed in a future version.
Example rows
2 | The abyss | review | 2 |
| New Yorker, The | organization484 | Terrence Rafferty | 2 | English | 1989 Sep 04 | 0 | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
| 9/3/89 17:00 | (null) | (null) | (null) |
3 | The abyss | review | 2 |
| Film Journal International | organization15066 | Kevin Lally | 2 | English | 1989 Sep | 4 | TRUE | TRUE | FALSE | FALSE | FALSE | TRUE | FALSE | FALSE | FALSE |
| 8/31/89 17:00 | (null) | (null) | (null) |
4 | There is a tide | review | 1 | p. 61 | Village Voice | organization494 | Amy Taubin | 2 | English | 1989 Aug 15 | 4 | FALSE | FALSE | FALSE | FALSE | TRUE | TRUE | TRUE | FALSE | FALSE |
| 8/14/89 17:00 | (null) | (null) | |
12 | The abyss: a foray into deep waters | review | 2 | p. H-15 | New York Times | organization482 | Aljean Harmetz | 2 | English | 1989 Aug 06 | 0 | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | TRUE | FALSE | FALSE |
| 8/5/89 17:00 | (null) | Underwater cinematography | James Cameron|Ed Harris |
13 | Playing with water | review | 1 | p. H-16 | New York Times | organization482 | David A. Kaplan | 2 | English | 1989 Aug 06 | 0 | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE |
| 8/5/89 17:00 | (null) | Special effects | Industrial Light and Magic (Studio) |
...