THE GEIGER DATABASE
GEIGER QUERY PROCEDURES
DATABASE JGDB10 QUERY SET
PROCEDURE 92: TFRESIDENTSHORTALPHA
The query returns a list of individuals recorded in the database as having been involved with the Frank Lloyd Wright studio and Taliesin Fellowship, including Apprentices, Wright family members, summer musicians, etc., but excluding students of Georgi Ivanovich Gurdjieff.
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 TFRESIDENTSHORTALPHA alls on Table MMTFNL with filters applied on Column [ID CODE 1] to include a specific category of individuals ("*TF*", for Taliesin Fellowship), and exclude other categories ("*GD*", for "Gurdjieff People" from Mrs. Wright's group who were not apprentices'; "*SP*", for spouse of Taliesin Apprentice or other; and "*WS*", for Taliesin West, Foundation Staff, not apprentices). The abbreviations and descriptions for the filter terms can be found in Table MMTFID. There is an additional filter applied on Column [TF IN] ("not = blank") to include only individuals whose date of arrival in the Taliesin Fellowship was recorded in the database. The report format produced a list showing a unique numerical identifier, identification codes, dates in and out at Taliesin, and name, ordered alphabetically. The last generation of the report contained 1,316 entries. The extensive comment on the Report Format image below should be consulted.
The query structure is similar to PROCEDURE 50: TFRESIDENTSHORT in Database JGDB10; and PROCEDURE 74: TFFIED3 in Database JGDBFULL.
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
Report Format
Document: Dataease Procedure Definition Printout (PDF)