This README provides the attributes and the relations between between tables included in the Switchboard Cellular Part 1 release. The data in these tables is a subset of the data stored in the production Oracle tables; also, data from two production tables (swb_subjects, swb_sid info) has been combined into the table SWB_CALLSUBJECTS. Per the agreement between LDC and the Switchboard Cellular Part 1 participants, personal information has been omitted. Furthermore, the phone numbers have been encoded so as to be somewhat hidden. Some calls made from cellular phones reported incorrect ANI information. The number reported in these cases was the number of the cellular tower. In these cases, the number was encoded according to the following format: dddtwrdddd (d = digit between 0 and 9, twr is a constant string) In all other cases, the phone number was encoded as: ddddddXXX (d = digit between 0 and 9,X = letter between a and z) Participants reported their location at the beginning of each call. This information is recorded in the table SWB_CALLSTATS. Three location options were allowed: 1 = indoors 2 = outdoors 3 = moving vehicle SWB_CALLSUBJECTS: PIN GENDER AGE EDU CALLS MADE CALLS RECVD BIRTH COUNTRY WHERE RAISED SWB_CALLSTATS: CALL ID CALLER PIN CALLEE PIN CALLER GENDER CALLEE GENDER CALLER PHONE ID CALLEE PHONE ID CALLER LOCATION CALLEE LOCATION DATE TOPIC RECORD LENGTH TALK LENGTH CONNECT LENGTH SWB_AUDIT CALL ID PIN CHANNEL ECHO NOISE DISTORTION LOCATION REMARKS VOICE ID SWB_PHONE PHONE ID SERVICE PROVIDER SERVICE TYPE PHONE MANUFACTURER PHONE MODEL PHONE # RELATIONS PIN (SWB_CALLSUBJECTS:PIN SWB_CALLSTATS:CALLER_PIN SWB_CALLSTATS:CALLEE_PIN SWB_AUDIT:PIN) PHONE ID (SWB_PHONE:PHONE ID SWB_CALLSTATS:CALLER PHONE ID SWB_CALLSTATS:CALLEE PHONE ID) CALL ID (SWB_CALLSTATS:CALL ID SWB_AUDIT:CALL ID) GENDER (SWB_CALLSUBJECTS:GENDER SWB_CALLSTATS:CALLER GENDER SWB_CALLSTATS:CALLEE GENDER) Kevin Walker Linguistic Data Consortium June 28, 2000