THE GEIGER DATABASE


GEIGER QUERY PROCEDURES
DATABASE JGDB10 QUERY SET

PROCEDURE 145: TFAPPBVYYEAR

 The query returns a list of individuals recorded in the database as associated with the studio of Frank Lloyd Wright and the Taliesin Fellowship from January 1, 1924 to December 31, 1959.

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 TFAPPBVYYEAR calls on Table MMTFNL with filters applied on Table MMTFNL with filters applied on Columns [TF IN],  [TF OUT], [TF IN 2], and [TF OUT2] to select records with a date range between January 1, 1924 and December 31, 1959, and filters applied on Columns [ID CODE 1] and [ID CODE 2] ("*TF*", for Taliesin Fellowship and exclude other categories ("*ST*", excluding dual values for Taliesin Fellow, Student ["TFST"] and for Taliesin West, Foundation Staff, not apprentices ["WSST"], and "*WK*", whose meaning is undetermined. The abbreviations of most of the filter terms can be found in Table MMTFID. The report format produced a list showing a unique numerical identifier, identification codes, with last and first name, grouped chronolologically by year with subtotal count. The last generation of the report contained 776 entries. The procedure was designed by Geiger to be manually altered according to purpose at hand; directions can be seen in comment on the Report Format image below.

The query structure is similar to PROCEDURE 107: TF32TO59ALL 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 145 query image

Report Format

JGDB10 Procedure 145 report form

Document: Dataease Procedure Definition Printout (PDF)