...
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 | text | 7/31/2014: Can be multiple pipe-separated values |
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. |
| updatedat | timestamp | date of last update to document |
Notes
Resolved - one row per document. 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.
...