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.
ORIGINAL DATAEASE PROCEDURE SCREENS
Query Structure
Report Format
Document: Dataease Procedure Definition Printout (PDF)