THE GEIGER DATABASE


GEIGER QUERY PROCEDURES
DATABASE JGDB10 QUERY SET

PROCEDURE 75: TF<05/31/32NOFAMILY

The query returns a list of individuals recorded in the database as working in the Frank Lloyd Wright studio prior to May 31, 1932.

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 TF<05/31/32NOFAMILY calls on Table MMTFNL with filters applied on Column [ID CODE 1] to include a specific category of individual ("*TF*", for Taliesin Fellowship) and exclude other categories ( "*GD*", for "Gurdjieff People" from Mrs. Wright's group who were not apprentices; and "*NP*", for non print records), and on Column [ID CODE 2] (*HF*", for Taliesin Honorary Fellows; and "*TM*", for Taliesin Men); and Column [TF IN] ("< 05/31/1932") to include individuals present only before May 31, 1932. The abbreviations and descriptions for the filter terms can be found in Table MMTFID. The report format produced a list showing a unique numerical identifier, identification codes, date of arrival, and last and first names ordered alphabetically. The last generation of the report contained 45 entries. The comment on the Report Format image below should be consulted.

The query structure is similar to PROCEDURE 76: TF<05/31/32FORMVIEW in Database JGDB10.

Database Search

Search based on this procedure can be executed through the version of the database available on the website.

  • Search Database

ORIGINAL DATAEASE PROCEDURE SCREENS

Query Structure

JGDB10 Procedure 75 query image

Report Format

JGDB10 Procedure 75 report form

Document: Dataease Procedure Definition Printout (PDF)