THE GEIGER DATABASE


GEIGER QUERY PROCEDURES
DATABASE JGDB10 QUERY SET

PROCEDURE 99: TF<06/31/32SORTDATE

The query returns a list of individuals associated with the studio of Frank Lloyd Wright between 1888 and 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<06/31/32SORTDATE calls on Table MMTFNL with a complex filters applied on Columns [ID CODE 1] and [ID CODE 2] ("*TF*", for Taliesin Fellowship; "not = *GD*", for "Gurdjieff People" from Mrs. Wright's group who were not apprentices; and "not = *NP*", for non print records; "*HF*", for Honor[ary] Fellow, employees of FLLW prior to '32 Fellowship; and "*FA*", for Wright family members), with date ranges applied between 1888-1904 and prior to May 31, 1932 on Column [TF IN]. 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, and names, ordered alphabetically, The last generation of the report contained 70 entries. The comment in the Report Format image below should be consulted.

The query structure is similar to PROCEDURE 100: TF<06/31/32TEST in Databasde JGDB10.

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

JGDB10 Procedure 99 query image

Report Format

JGDB10 Procedure 99 report form

Document: Dataease Procedure Definition Printout (PDF)