THE GEIGER DATABASE


GEIGER QUERY PROCEDURES
DATABASE JGDB10 QUERY SET

PROCEDURE 49: TFAPPRENYONLYSHORT

The query returns a list of all Taliesin Fellowship Apprentices recorded in the database, including changes in married name.

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 TFAPPRENYONLYSHORT calls on Table MMTFNL with filters applied on Columns [ID CODE 1] and [ID CODE 2] include a specific category of individuals ("*TF*", for Taliesin Fellowship) and exclude other categories ("*PG*", for progeny of Taliesin Fellowship members; "*FA*", for Wright family members; "*MU*", for resident summer musicians at Taliesin; "*SP*", for spouse of Taliesin Apprentice or other; "*BC" for ; "*AS*", for architectural school ; "*TU*", for Tutor to Brandock Peters; "*HF*", for Honor[ary] Fellow, employees of Frank Lloyd Wright prior to 1932; "*WK*", whose meaning is undetermined; and "*GD*", for "Gurdjieff People" from Mrs. Wright's group who were not apprentices). The abbreviation for most of the filter terms can be found in Table MMTFID. The report format produced a list of names ordered alphabetically showing a unique numerical identifier, identification codes, and names ordered alphabetically. The last generation of the report contained 630 entries. The extensive comments found in the Report Format image below should be consulted.

The query structure is similar to PROCEDURE 112: TFAPPRENYONLYSHORT in Database JGDBFULL, which has fewer filters and returned 1,166 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

JGDB10 Procedure 49 query image

Report Format

JGDB10 Procedure 49 report form

Document: Dataease Procedure Definition Printout (PDF)