THE GEIGER DATABASE


GEIGER QUERY PROCEDURES
Database JGDBFULL Query Set

PROCEDURE 114: TFLIVING<60

The query returns a list of mailing addresses for Taliesin Fellowship members resident at Taliesin during the life of Frank Lloyd Wright who were still alive as of November 19, 2002.

Note: The column labels shown within the query structures are historical references only, and do not reflect the definitions used within the version of the database being served through the website.

PROCEDURE NOTES

Procedure TFLIVING<60 calls on Table MMTFNL with extensive filters applied on Column [ID CODE 1] to include a specific category of individuals ("*TF*", for Taliesin Fellowship), and exclude other categories ("*NP*", for non print record; "*DC*", for deceased; "*TFCH*", for Taliesin Fellows chapter members; "*FA*", for Wright family members; "*NX*", for address unknown; "*SP*", for spouse of Taliesin Apprentice or other; "*MU*", for resident summer musicians at Taliesin; "*PG*", for progeny of Taliesin Fellowship members; and "*WS*", for Frank Lloyd Wright Foundation staff). The abbreviations and descriptions for the filter terms can be found in Table MMTFID. A date filter is placed on Column [TF IN] to include only individuals present at Taliesin prior to May 1, 1959. The report format produced a directory of mailing addresses, ordered alphabetically by last name with a total of 241 entries.

Database Search

Search based on this procedure can be executed through the version of the database available on the website. The results are redacted to omit personal contact information.

  • Search Database

ORIGINAL DATAEASE PROCEDURE SCREENS

Query Structure

JGDBFULL Procedure 114 query image

Report Format

JGDBFULL Procedure 114 report image 

Document: Dataease Procedure Definition Printout (PDF)