THE GEIGER DATABASE
DATA TABLE STRUCTURES
DATABASE JGDBFULL TABLES
TABLE DETAIL: MEET LOCATION
The structure of this table was designed to organize events or meetings held by the Taliesin Fellows.
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 MEET LOCATION contains 35 rows arranged in 25 columns.
Entries record administrative information concerning venues, including program title, location, date, time, coordinator names and contact information, and incidental notes.
The table contains the following (formatting and chronological order original):
| CATEGORY ID | PROGRAM TITLE | DATE | ||
| 26P | JUNE '92 SUNDAY PICNIC AT ERIC & MARY W[right] | 6/7/92 | ||
| 9206 | WRIGHT BIRTHDAY EVENTS 1992, SAT/SUN/MON | 6/6/92 | ||
| 9304 | 1993 WRIGHT WEEKEND APRIL 3, 4, 1993 | 4/4/93 | ||
| 9210 | STEWART HOUSE MEETING | 10/3/92 | ||
| 9109 | OCTOBER MEETING AT JOHN BENTON'S HOUSE | 9/28/91 | ||
| 9106 | JUNE MEETING AT LAUTNER SILVERTOP HOUSE | 6/8/91 | ||
| 9202 | FEBRUARY MEETING AT BOWLER HOUSE (LLOYD WRIGHT) | 2/2/92 | ||
| 9304 | 1993 WRIGHT WEEKEND APRIL 3, 4, 1993 | 4/3/93 | ||
| 9306 | In The Cause of Architecture 1993 | 6/13/93 | ||
| 9312 | General Meeting at John Benton | 12/5/93 | ||
| 9206 | WRIGHT BIRTHDAY EVENTS 1992, SAT/SUN/MON | 6/7/92 | ||
| 9421 | Lovell House Tour, Newport Beach | 2/6/94 | ||
| 9440 | FRANK LLOYD WRIGHT WEEKEND, 1994 | 4/9/94 | ||
| 94A1 | Ablin House meeting | 10/9/94 | ||
| 9541 | Auldbrass Plantation tour | 4/22/95 | ||
| 9561 | In the Cause of Architecture 1995/Lautner Perspective | 6/11/95 | ||
| 9581 | Jim DeLong House Tour | [no date] | ||
| 95C1 | 1995 Meeting at John Benton | [no date] | ||
| 9661 | Lloyd Wright House tour | [no date] | ||
| 96C1 | Annual Meeting at John Benton's | 12/15/96 | ||
| 9961 | Picnic at Eric Wright's | 6/9/99 | ||
| 0061 | Frank Lloyd Wright Weekend | 6/4/00 |
Records from this table are displayed in a subform of Table MMTFMEETING LIST.
The table relies on lookup relationships with columns of Tables MMTFMEETING LIST and MMTFNL. These relationships are commented on the Dataease Form Screen image, below.
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
Document: DataEase table definition printout (PDF)
COLUMN LABELS
Column: [CATEGORY ID] records an abbreviation related to Column [CATEGORY ID] of Table MEET LINE ITEMS (also, alternatively, Tables MMTFCATEGORY and MMTFMEETING LIST).
Column: [ML#] records a number representing a location related to Column [ML#] of Table MMTFMEETING LIST.
Column: [ML#2] records a sequential number as a unique row identifier.
Column: [PROGRAMTITLE] records a program title for a Taliesin Fellows membership event through lookup on row value of Column [DESCRIPTION] in MMTFMEETING LIST.
Column: [EVENT#] records a number or designator for individual events during a program or meeting.
Column: [DESCEVENT1] records a title or description relating to an individual event during a program or meeting.
Column: [DAY] records the day of the week for an individual event during a program or meeting.
Column: [DATE] records the date of an individual event during a program or meeting in month/day/year format.
Column: [TIME] records the time of an individual event during a program or meeting.
Column: [RECORD #] records a row identifier number through lookup on row value of Column [RECORD NUMBER] of Table MMTFNL.
Column: [LAST] records the last name of the host or coordinator for an event or meeting through lookup on row value of Column [LAST] of Table MMTFNL.
Column: [FIRST] records the first name of the host or coordinator for an event or meeting through lookup on row value of Column [FIRST] of Table MMTFNL.
Column: [SPOUSE] records the first name of the spouse of the host or coordinator for an event or meeting through lookup on row value of Column [SPOUSE] of Table MMTFNL.
Column: [COMPANY] records the building name associated with an event or meeting through lookup on row valueof Column [COMPANY] of Table MMTFNL.
Column: [ADDRESS LINE 1] records the street address associated with an event or meeting through lookup on rowvalue of Column [ADDRESS LINE 1] of Table MMTFNL.
Column: [ADDRESS LINE 2] records a secondary location name associated with an event or meeting through lookup on row value of Column [ADDRESS LINE 2] of Table MMTFNL.
Column: [CITY] records the city location for an event or meeting through lookup on row value of Column [CITY] of Table MMTFNL.
Column: [STATE] records the state location for an event or meeting through lookup on row value of Column [STATE] of Table MMTFNL.
Column: [ZIP] records the zip code for the location of an event or meeting through lookup on row value of Column [ZIP] of Table MMTFNL.
Column: [PHONE 1] records a contact telephone number for an event or meeting through lookup on row value of Column [PHONE 1] of Table MMTFNL.
Column: [FAX HOME] is void of entries.
Column: [PHONE 2] records a contact telephone number for an event or meeting through lookup on row value of Column [PHONE 2] of Table MMTFNL.
Column: [FAX OFFICE] is void of entries in all rows.
Column: [BEEPER] is void of entries in all rows.
Column: [NOTE] records a comment concerning an event or meeting.
RELATED QUERY PROCEDURES
This table is not referenced directly in any of the query procedures devised by Geiger.