THE GEIGER DATABASE
GEIGER QUERY PROCEDURES
Database JGDBFULL Query Set
QUERY PROCEDURES 1 - 49
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 1 - 49
Procedure 1: MMTFJS
The query returns a mailing list of libraries and architectural schools that subscribed to the Journal of the Taliesin Fellows (JTF).
Procedure 2: MMTFREC#
The query returns a mailing list for selected subscribers to the Journal of the Taliesin Fellows (JTF).
Procedure 3: MMTFIDSYMBOLS
The query returns a list of abbreviations and descriptions that categorize the roles of individuals or institutions in connection with the Taliesin Fellowship, the Taliesin Fellows and subscribersto the Journal of the Taliesin Fellows (JTF), and other relationships within the extended Frank Lloyd Wright community.
Procedure 4: MMTF1935
The query returns a list of individuals recorded in the database as being present in the Taliesin Fellowship during 1935.
Procedure 5: MMTF1932
The query returns a list of individuals recorded in the database as being present in the Taliesin Fellowship during 1932.
Procedure 6: MMTF1933
The query returns a list of individuals recorded in the database as being present in the Taliesin Fellowship during 1933.
Procedure 7: MMTF1934
The query returns a list of individuals recorded in the database as being present in the Taliesin Fellowship during 1934.
Procedure 8: MMTF1936
The query returns a list of individuals recorded in the database as being present in the Taliesin Fellowship during 1936.
Procedure 9: MMTF1937
The query returns a list of individuals recorded in the database as being present in the Taliesin Fellowship during 1937.
Procedure 10: MMTF1938
The query returns a list of individuals recorded in the database as being present in the Taliesin Fellowship during 1938.
Procedure 11: MMTF1939
The query returns a list of individuals recorded in the database as being present in the Taliesin Fellowship during 1939.
Procedure 12: MMTF1940
The query returns a list of individuals recorded in the database as being present in the Taliesin Fellowship during 1940.
Procedure 13: MMTF1941
The query returns a list of individuals recorded in the database as being present in the Taliesin Fellowship during 1941.
Procedure 14: MMTF1942
The query returns a list of individuals recorded in the database as being present in the Taliesin Fellowship during 1942.
Procedure 15: MMTF1943
The query returns a list of individuals recorded in the database as being present in the Taliesin Fellowship during 1943.
Procedure 16: MMTF1944
The query returns a list of individuals recorded in the database as being present in the Taliesin Fellowship during 1944.
Procedure 17: MMTF1945
The query returns a list of individuals recorded in the database as being present in the Taliesin Fellowship during 1945.
Procedure 18: MMTF1946
The query returns a list of individuals recorded in the database as being present in the Taliesin Fellowship during 1946.
Procedure 19: MMTF1947
The query returns a list of individuals recorded in the database as being present in the Taliesin Fellowship during 1947.
Procedure 20: MMTF1948
The query returns a list of individuals recorded in the database as being present in the Taliesin Fellowship during 1947.
Procedure 21: MMTF1949
The query returns a list of individuals recorded in the database as being present in the Taliesin Fellowship during 1949.
Procedure 22: MMTF1950
The query returns a list of individuals recorded in the database as being present in the Taliesin Fellowship during 1950.
Procedure 23: MMTF1951
The query returns a list of individuals recorded in the database as being present in the Taliesin Fellowship during 1951.
Procedure 24: MMTF1952
The query returns a list of individuals recorded in the database as being present in the Taliesin Fellowship during 1952.
Procedure 25: MMTF1953
The query returns a list of individuals recorded in the database as being present in the Taliesin Fellowship during 1953.
Procedure 26: MMTF1954
The query returns a list of individuals recorded in the database as being present in the Taliesin Fellowship during 1954.
Procedure 27: MMTF1955
The query returns a list of individuals recorded in the database as being present in the Taliesin Fellowship during 1955.
Procedure 28: MMTF1956
The query returns a list of individuals recorded in the database as being present in the Taliesin Fellowship during 1956.
Procedure 29: MMTF1957
The query returns a list of individuals recorded in the database as being present in the Taliesin Fellowship during 1957.
Procedure 30: MMTF1958
The query returns a list of individuals recorded in the database as being present in the Taliesin Fellowship during 1958.
Procedure 31: MMTF1959
The query returns a list of individuals recorded in the database as being present in the Taliesin Fellowship during 1959.
Procedure 32: MMTFWORK CATEGORY
The query returns a list of building types to categorize Frank Lloyd Wright commissions.
Procedure 33: MFTALINFO NEW REC
The query was designed to transfer data entries from one table to another.
Procedure 34: MMTFIDPRINT
The query returns a list of abbreviations and descriptions that categorize personal names or institutional relationships in connection with the Taliesin Fellowship, the Taliesin Fellows and subscribers to the Journal of the Taliesin Fellows (JTF), and other relationships within the extended Frank Lloyd Wright community.
Procedure 35: MMJGINV
The procedure returns an inventory of personal possessions belonging to John Geiger.
Procedure 36: MMJGBOOKLIBRARY
The query returns an inventory of books, periodicals, and archival materials held by John Geiger in his library.
Procedure 37: MMTF?=?
The query returns a list of subscribers to the Journal of the Taliesin Fellows (JTF).
Procedure 38: MMTFD50
The query returns a list of donor and/or subscriber names to the Taliesin Fellows for the purpose of tracking previous yearly donations to the Taliesin Fellows between $50 and $99.
Procedure 39: MMTFD100
The query returns a list of donor and/or subscriber names to the Taliesin Fellows for the purpose of tracking previous yearly donations to the Taliesin Fellows between $100 and $249.
Procedure 40: MMTFD250
The query returns a list of donor and/or subscriber names to the Taliesin Fellows for the purpose of tracking previous yearly donations to the Taliesin Fellows between $250 and $499.
Procedure 41: MMTFD500
The query returns a list of donor and/or subscriber names to the Taliesin Fellows for the purpose of tracking previous yearly donations to the Taliesin Fellows between$500 and $999.
Procedure 42: MMTFD1000
The query returns a list of donor and/or subscriber names to the Taliesin Fellows for the purpose of tracking previous yearly donations to the Taliesin Fellows greater than $1,000.
Procedure 43: MMTF1970
The query returns a list of individuals present or related to the Taliesin Fellowship during 1970.
Procedure 44: MMTFCategoryList
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.
Procedure 45: MMTFWholesaleOutlets
The query returns a list of wholesale vendors selling the Journal of the Taliesin Fellows (JTF).
Procedure 46: TFRenuList
The query returns a renewal list for subscribers to the Journal of the Taliesin Fellows (JTF).
Procedure 47: JGBookLibrary
The query returns a detailed inventory, including cost and valuation, of books, periodicals, and archival materials held by John Geiger in his library.
Procedure 48: TFMbrListByDate
The query returns a membership list for the Taliesin Fellows.
Procedure 49: TFCurrentCode
The query returns a list of payments from the membership of the Taliesin Fellows.