...
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.
...
Field | Type | Notes |
film_id | varchar |
|
name_id | text | Name identifiers for director. Can be multiple pipe-separated values, but NOTE that these strings have leading and trailing pipes to allow "like" searches to work on these. |
doc_count | int8 | Number of documents associated with this film |
filmtitle | varchar | Primary title |
country | text | Can be multiple pipe-separated values. |
filmyear | int4 | Single 4-digit year. NOTE: Some films have multiple rows in this table because of multiple release years. In order to allow numeric search operations such as between and greater than, these were not generated as pipe-separated values. E.g., see pfafilm31474 below. |
director | text | Can be multiple pipe-separated values. |
filmlanguage | text | Can be multiple pipe-separated values. |
prodco | text | Can be multiple pipe-separated values. |
subject | text | Can be multiple pipe-separated values. |
genre | text | Can be multiple pipe-separated values. |
title | text | Primary and alternate titles. Can be multiple pipe-separated values. |
| prodco_id | text | Added 7/31/14: Can be multiple pipe-separated values. |
| updatedat | timestamp | Date record was last updated |
Notes
NOTE: Some films have multiple rows in this table because of multiple release years. In order to allow numeric search operations such as between and greater than, these were not generated as pipe-separated values. E.g., see pfafilm31474 below.
...