THE GEIGER DATABASE
GEIGER QUERY PROCEDURES
Database JGDBFULL Query Set
QUERY PROCEDURES 50 - 99
The 133 query procedures derived from Database JGDBFULL are described. Each procedure is presented with a summary of function, note of special relationships, screen capture images showing the original query composition and printout format as they appeared in the DataEase application, and a definition form exported from DataEase (PDF). Some queries can be executed with results presented in a fashion similar to that composed by John Geiger through the version of the database available on the website; alternately, sometimes procedure results may be downloaded as a PDF.
JGDBFULL QUERY PROCEDURES 50 - 99
Procedure 50: TFList1931
The query returns a list of individuals present in the Taliesin Fellowship during 1931.
Procedure 51: TFList1931AppOnly
The query returns a list of individuals present in the Taliesin Fellowship during 1950.
Procedure 52: TFDrawAuthorByLast
The query returns
the authorship of individual drawings for Frank Lloyd Wright commissions, grouping them by principal delineator.
Procedure 53: TFDrawAuthorByClient
The query returns
the authorship of individual drawings for Frank Lloyd Wright commissions, ordered alphabetically by client name.
Procedure 54: TFDrawAuthorByDraft
The query returns
the authorship of individual drawings for Frank Lloyd Wright commissions, grouping them by principal delineator.
Procedure 55: TFMeet900/917
The query returns
name and address information for individuals or companies related to Taliesin Fellows activities in southern California.
Procedure 56: TFCategoryListing
The query returns a list of abbreviation codes and related descriptors for Taliesin Fellows membership, event registrations and donations, as well as subscriptions to the Journal of the Taliesin Fellows (JTF).
Procedure 57: TFEventCal
The query returns a membership list for attendees at Taliesin Fellows whose mailing address is in California.
Procedure 58: ListIcon2
The query a list of images related to Frank Lloyd Wright commissions regarded by John Geiger as iconographic.
Procedure 59: LISTICON
The query does not function. Some similarity is likely to Procedure 58: LISTICON2, above.
Procedure 60: TFMeet????
The query returns
registration information for individuals attending a tour sponsored by the Taliesin Fellows.
Procedure 61: TF$CountPerPeriod
The query returns
payments made to the Taliesin Fellows.
Procedure 62: TFNEWSLETTERMAILLIST
The query returns a mailing list for the Journal of the Taliesin Fellows (JTF).
Procedure 63: TFHonoraryFellows
The query returns a list of individuals who worked in the studio of Frank Lloyd Wright prior to the founding of the Taliesin Fellowship in 1932.
Procedure 64: TFTalieIsnMen (sic)
The query returns a list of male drafters in the Frank Lloyd Wright studio present from 1925 to 1935.
Procedure 65: TFOriginalApprentice
The query returns a list of founding members of the Taliesin Fellowship.
Procedure 66: TFLivingOP
The query returns a list of founding Taliesin Fellowship members still living as of the year 2000.
Procedure 67: TFCompleteApprnList
The query returns a list of individuals recorded as having been Apprentices in the Taliesin Fellowship.
Procedure 68: TFLivingApprnList
The query returns a list of individuals still living who had been members of the Taliesin Fellowship.
Procedure 69: TFEntireTFNamesList
The query returns a list all individuals related to the Taliesin Fellows membership.
Procedure 70: TFRenuList2
The query returns a renewal list for subscribers to the Journal of the Taliesin Fellows (JTF).
Procedure 71: TFSubMainForm
The query returns a list of subscriber and donation information for members of the Taliesin Fellows.
Procedure 72: TFMbrListByDate2
The query returns a membership list for the Taliesin Fellows.
Procedure 73: TFFriedList
The query returns a list of Apprentices in the Taliesin Fellowship during the year 1950.
Procedure 74: TFieid3
The query returns a list of all individuals recorded in the database as belonging to the Taliesin Fellowship, including variations of married name.
Procedure 75: TFFried2
The query returns a list of all individuals recorded as having been present in the Taliesin Fellowship.
Procedure 76: TFFriedMarriedName
The query returns a list of individuals recorded as resident or involved with the Taliesin Fellowship, including progeny of Apprentices, with collations of married names and biographical information if present.
Procedure 77: TFFried4
The query returns a list of all individualsrecorded in the database as belonging to the Taliesin Fellowship, including variations of married name.
Procedure 78: FLLWWorkListByArchv#
The query returns a list of Frank Lloyd Wright Commission Titles ordered by the Frank Lloyd Wright Archives inventory number.
Procedure 79: TFZellListByTFIn
The query returns a list of all individuals recorded as having been present in the Taliesin Fellowship.
Procedure 80: FLLWWorkListByClient
The query returns a list of Frank Lloyd Wright commissions ordered by client name and project title.
Procedure 81: TFBriggs
The query returns a list of the Taliesin Fellows membership and related payments.
Procedure 82: TFBriggs2
The query returns a mailing address list for the Taliesin Fellows.
Procedure 83: TFBogartMailList
The query returns a mailing list for the Taliesin Fellows in California.
Procedure 84: JGApprenticeByName
The query returns a single name with contact information.
Procedure 85: TFLivingMarty
The query returns a list of current and former Taliesin Fellowship members still living as of the year 2001.
Procedure 86: TFFzSd
The query returns a list of current and former Taliesin Fellowship members living in the Phoenix and Scottsdale, Arizona, vicinity as of the year 2001.
Procedure 87: TFGurdjieff
The query returns a list of Taliesin Fellowship members recorded as being involved with the teachings of Georgi Ivanovich Gurdjieff through the influence of Olgivanna Lloyd Wright.
Procedure 88: TFClientList
The query returns a list of Frank Lloyd Wright commissions ordered by client name and project title.
Procedure 89: TFClientListByFile#
The query returns a list of Frank Lloyd Wright commissions recorded in the database without a decorative arts category.
Procedure 90: TFDrawByAuthor
The query returns a list of Frank Lloyd Wright project drawings grouped by the name of the delineator.
Procedure 91: TFList1954AppOnly
The query returns a list of the married names of Taliesin Fellowship members for the year 1954.
Procedure 92: JGJobBySortDate
The query returns a chronologically ordered list of Frank Lloyd Wright client names and project titles.
Procedure 93: JGJobBySortDateGroup
The query returns a list of Frank Lloyd Wright commissions grouped by year with total annual counts of commissions.
Procedure 94: JGJobBySortCottage
The query returns a list of Frank Lloyd Wright residential projects categorized as cottage or cabin.
Procedure 95: JGJobSortPrototype
The query returns a list of Frank Lloyd Wright residential projects deemed by John Geiger to prototypes for later works.
Procedure 96: JGRoofTypeSort
The query returns a list of Frank Lloyd Wright commissions having a triangular hipped roof form.
Procedure 97: JGBookLibNotFllw720+
The query returns a list of books in the Geiger library not related to Frank Lloyd Wright within a range of Dewey Decimal system classifications.
Procedure 98: LGBookLibCode1Code2
The query returns a list of books in the Geiger library with a Dewey Decimal system classification of 720 to 720.99.
Procedure 99: WorkByDate
The query returns a chronolgically ordered list of individuals associated in some capacity with Frank Lloyd Wright buildings or projects from 1901 to 1999.