...
New
...
data
...
sources
...
are
...
available
...
for
...
the
...
web
...
sites
...
to
...
display
...
information
...
managed
...
in
...
the
...
CineFiles
...
CollectionSpace
...
system.
...
Their
...
design
...
is
...
based
...
on
...
the
...
requirements
...
for
...
the
...
...
...
,
...
but
...
they
...
have
...
been
...
refactored
...
extensively.
...
These
...
data
...
sources
...
are
...
described
...
below.
...
A
...
separate
...
document
...
will
...
describe
...
how
...
these
...
data
...
sources
...
are
...
refreshed
...
(TBD).
...
| Table of Contents |
|---|
...
|
...
|
doclist_view
...
doclist_view
...
is
...
a
...
table
...
despite
...
the
...
name.
...
The
...
name
...
was
...
retained
...
in
...
order
...
to
...
simplify
...
refactoring
...
the
...
IST
...
developed
...
CineFiles
...
web
...
site.
...
This
...
is
...
the
...
primary
...
source
...
for
...
searching
...
documents
...
(keyword
...
search
...
and
...
field-based
...
search).
...
Schema
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
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) |
...
filmlist_view
...
filmlist_view
...
is
...
a
...
table
...
despite
...
the
...
name.
...
The
...
name
...
was
...
retained
...
in
...
order
...
to
...
simplify
...
refactoring
...
the
...
IST
...
developed
...
CineFiles
...
web
...
site.
...
This
...
is
...
the
...
primary
...
source
...
for
...
searching
...
films
...
(keyword
...
search
...
and
...
field-based
...
search).
...
Schema
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. |
Notes
Example rows
pfafilm10 | |person12| | 22 | Yukinojo henge (An actor's revenge) | Japan | 1963 | Kon Ichikawa | Japanese | Daiei Motion Picture Co. Ltd. | Actors -- Japan -- Drama|Kabuki -- Drama|Revenge -- Drama|Melodrama | Melodrama | Yukinojo henge|An actor's revenge|Yukinojo Hengei|The Revenge of Yukinojo|The Avenging ghost of Yukinojo|Yukinojo Henge (1963 : Kon Ichikawa)|An Actor's revenge (1963 : Kon Ichikawa) |
pfafilm100 | |person391| | 1 | World gone wild | (null) | (null) | Lee H. Katzin | English | (null) | (null) | Drama | World gone wild |
pfafilm1000 | |person8886|person8498| | 3 | Ama | Ghana|Great Britain | 1991 | Kwesi Owusu|Kwate Nee-Owoo | English | Channel Four Films|Efire Tete Films | Cultural conflict -- Great Britain -- Drama|Ghanaians -- Great Britain -- London -- Drama|Africans -- Great Britain -- London -- Drama|Girls -- Great Britain -- London -- Drama|Ghana -- Religion -- Drama | Drama | Ama |
pfafilm10018 | |person383| | 17 | Insignificance | Great Britain | 1985 | Nicolas Roeg | English | Recorded Picture Company|Zenith Entertainment Ltd. | Einstein, Albert, 1879-1955 -- Drama|Monroe, Marilyn, 1926-1962 -- Drama|DiMaggio, Joe, 1914-1999 -- Drama|McCarthy, Joseph, 1908-1957 -- Drama|Johnson, Terry, 1949- Insignificance -- Film and video adaptations | Adaptation|Comedy|Drama|Feature | Insignificance |
pfafilm1002 | |person3849| | 1 | Ambar (Amber) | Mexico | 1994 | Luis Estrada | Spanish | Imcine|Bandidos Films | Adventure and adventurers -- Drama|Amber -- Drama | Drama | Ambar|Amber |
pfafilm31474 | |person4489| | 4 | Shift | United States | 1972 | Ernie Gehr | English | (null) | City traffic | Experimental|Short|Bay Area avant-garde | Shift |
pfafilm31474 | |person4489| | 4 | Shift | United States | 1973 | Ernie Gehr | English | (null) | City traffic | Experimental|Short|Bay Area avant-garde | Shift |
pfafilm31474 | |person4489| | 4 | Shift | United States | 1974 | Ernie Gehr | English | (null) | City traffic | Experimental|Short|Bay Area avant-garde | Shift |