THE GEIGER DATABASE


DATA TABLE STRUCTURES
DATABASE JGDB10 TABLES

TABLE DETAIL: MMTFNL

The structure of this table was designed to record personal information about individuals and institutions related in various ways to the Frank Lloyd Wright community.

Note: The column labels shown within the table structures are historical references only, and do not reflect the definitions used within the version of the database being served through the website.

TABLE NOTES

Table MMTFNL contains 4,688 rows arranged in 74 columns.

This table evolved from an original use in tracking members of the Taliesin Fellows organization into a comprehensive source of biographical detail concerning the extended Frank Lloyd Wright community. The structure of this table serves to account for individuals as they relate to the communities of the Taliesin Fellowship and the Taliesin Fellows, subscribers to the Journal of the Taliesin Fellows, Frank Lloyd Wright Foundation staff or others relevant because of involvement with Frank Lloyd Wright buildings, conservation organizations, and miscellaneous other relationships. Geiger also implemented a column in this table to account for name changes due to multiple marriage relationships within the Taliesin Fellowship. The bulk of data entry occurred between October 7, 1990, and December 1, 2000.

John Geiger wrote the following description of this table:

"This is a basic name and address file and that includes all people, starting with the Oak Park Studio, who were Apprentices or employees, and anybody who was in residence at Taliesin, including family, apprentices, paid draftsmen, musicians, etc. There are two sets of In and Out dates to help define who was there on any given date. A comments field is provided for minor biographical information, and two six-digit classification fields so that the list can be sorted in any imaginable way. It also includes the address of all Frank Lloyd Wright buildings listed by the original client and the current occupant, where known." (October 28, 2002). See document, below.

Document: Further description by Geiger about his purposes for this table design

This table provides lookup relationships for columns of Tables Building Contractor, Drawings Line Items, Electrical, Landscape Design, Mechanical, Meet Location, Prelim Dwg Coord, and Project Architect.

Database Search

A redacted version of the content of this table that omits personal contact information is accessible through the version of the database available on the website.

ORIGINAL DATAEASE FORM SCREEN

MMTFNL form

Document: DataEase table definition printout (PDF)

COLUMN LABELS

Column: [RECORD NUMBER] records a unique numerical identifier for each row in the table.

Column: [ID CODE 1] records an abbreviation code articulated of Table MMTFID and Table MMTFIDCODES.

Column: [ID CODE 2] records a second abbreviation code articulated of Table MMTFID.

Column: [TF IN] records a date in month/day/year format for the first date of arrival for residency in the Taliesin community.

Column: [TFINN #1] records a single character related to the date found in Column [TF IN] ("0," "1," "a," "b," "c," "d," or "?"). The meaning of this qualifier is not known, beyond the obvious uncertainty of a question mark.

Column: [TF OUT] records a date in month/day/year format for the first date of departure from the Taliesin community.

Column: [TFOUT#1] records a single character related to the date found in Column [TF IN]. See note for Column [TFINN #1]

Column: [TF IN 2:] records a date in month/day/year format for a second date of arrival for residency in the Taliesin community.

Column: [TFINN#2] records a single character related to the date found in Column [TF IN 2:]. See note for Column [TFINN #1], above.

Column: [TF OUT 2] records a date in month/day/year format for the second date of departure from the Taliesin community.

Column: [TFOUT#2] records a single character related to the date found in Column [TF OUT 2]. See note for Column [TFINN #1]above.

Column: [DATE] records the date for record creation in month/day/year format.

Column: [SORTDATE] records a year date in YY format.

Column: [SORTDATE2] records a year date YY format.

Column: [MR/MS] records an honorific title singly or in combination for salutation (e.g., Mr., Mrs., Miss, Ms, Dr., Dean, or Professor).

Column: [FIRST] records a given name or iniitials for an individual.

Column: [LAST] records the last name of an individual.

Column: [JR/MD] records a title for an individual (e.g. "architect," "AIA," "FAIA," "Director," "President," etc.).

Column: [SPOUSE] records the name of a spouse.

Column: [MARRIED NAMES] records a married name, usually identical with Column [LAST], above, but the row entry can also record a series of names for remarried individuals in the Taliesin Fellowship, or alternatively record information about an individual's role (e.g., owner or historic site manager) toward a Frank Lloyd Wright building.

Column: [COCOMMENT] records the project identification number from the Frank Lloyd Wright Archives inventory to indicate a relationship of the individual with a Frank Lloyd Wright building.

Column: [BLDG CLIENT] records the client name or designator for a Frank Lloyd Wright project.

Column: [TITLE] records a professional title for an individual (e.g., "Architectural Librarian," or "Executive Director").

Column: [COMPANY] records a role or place of employment for an individual (e.g., "Department of Art History," "Frank Lloyd Wright Foundation," "Executive Vice President," "Florida Southern College," etc.).

Column: [ADDRESS LINE 1] records an address for an individual.

Column: [ADDRESS LINE 2] records a secondary address line for an individual.

Column: [CITY] records a city location.

Column: [STATE] records a state name.

Column: [ZIP] records a zip code.

Column: [ZIP2] records a secondary zip code.

Column: [NX] records a date in month/day/year format to indicate when the mailing address for an individual was found to be no longer valid ("nixie").

Column: [COUNTRY] records a country if the address is outside of the United States.

Column: [FOREIGN ZIP] records a foreign mailing code.

Column: [LASTUSED] records a date in month/day/year format to indicate the last time the address was used for a mailing.

Column: [PHONE 1] records a telephone number.

Column: [EXTENSION] records the extension for the telephone number in Column [PHONE 1], above.

Column: [FAX] records a fax number.

Column: [HFAX2] records a name to whom faxes should be addressed.

Column: []PHONE 2] records a secondary fax number.

Column: [EXTENSION2] records the extension for the fax number in Column [PHONE 2], above.

Column: [OFAX] records a fax number.

Column: [OFAX2] records a notation concerning the fax number in Column [OFAX], above.

Column: [PAGER] records a pager number.

Column: [CELLULAR] records a cellular telephone number.

Column: [MODEM] records a dialup telephone number for computer connection.

Column: [E-MAILADDRESS] records an email address.

Column: [CHANGE OF ADDRESS] records a date in month/day/year format regarding the most recent change of address for an individual.

Column: [WEB] records a World Wide Web or email address.

Column: [BORN] records the birth date of an individual.

Column: [BORN3] records a single character related to the date found in Column [BORN], above; may be related toinformation found in Columns [COMMENTS] or [LONG:COMMENTS2].

Column: [BORN2] records a location of birth, or a citation for the information concerning the date shown in Column [BORN], above.

Column: [DECEASED] records a date in month/day/year format for the death of an individual.

Column: [DECEASED2] records a single character related to the date found in Column [DECEASED], above; may be related to information found in Columns [COMMENTS] or [LONG:COMMENTS2].

Column: [COMMENTS] records notes about individuals, subscription renewals, address change, payments, citations of publications, or administrative comments by Geiger.

Column: [LONG:COMMENTS2] records notes about individuals, subscription renewals, address change, payments, citation of publications, or administrative comments by Geiger.

Column: [CONAME] records an individual, company, partnership, or business name.

Column: [COCOMPANY] records company, partnership, or business name.

Column: [COADDRESS LINE 1] records an address for a company.

Column: [COADDRESS LINE 2] records a secondary line for the address of the company.

Column: [COCITY] records a city location for the company address.

Column: [COSTATE] records a state location for the company address.

Column: [COZIP] records a zip code for the company address.

Column: [COCOUNTRY] records a country if the address is outside of the United States.

Column: [DATE #1] is void of entries in all rows.

Column: [DATE #2] is void of entries in all rows.

RELATED QUERY PROCEDURES

The data in this table is referenced in 106 unique query procedures devised by Geiger. These queries exhibit a diverse use of biographical information collected about the various Taliesin-related communities. The numerous procedures are presented according to the database version in which they can be found, with duplicate queries as noted. The most complete version of results will always be found in Database JGDB10.