ABCDEFGHIJKL
1
Variables
2
page
Page of directory with this record
3
line_num
Line number for this entry out of all items
4
record_id
Unique identifier from the page and line number
5
checked
Y/N for whether a record has been checked or not.
6
resident_name
Name of residents as listed (often includes a spouse). This may also be the name of a business.
7
display_name
Name of residents as they should be displayed on a map
8
bus_dummy
(1 or 0) 1 if this is a business/organization listing, 0 if it is residential. These include businesses, churches, frats/sororities
9
dependents
Residents under 16 at this address. Will be listed as a single number after the residents' names. May be in the name or address fields, and not included in the initial scan
10
colored
A dummy variable (1 or 0). List as 1 if had the circle c/copyright symbol, which indicates the resident or business was classified as "colored"
11
resident_occ
The occupation as listed in the directory, which is usually abbreviated. Do not give the full name of the occupation if not listed.
12
STDZD.RES_OCC
Standardized version of occupation--referenced from the "occupation" tab
13
resident_bus
The business where the resident works, if listed.
14
STDZD.RES_BUS
Standardized version of the business--referenced from the "business" tab
15
bus_id
Record ID of the business listed for this resident--referenced from the 'business" tab
16
ownhome
A dummy variable (1 or 0). List as 1 if the resident has a circle H. A 9 means that there was no automated match, and so update manually to the correct value.
17
householder
A dummy variable (1 or 0). List as 1 if the resident has a small h ("h"), which refers to the householder/head of family
18
resident
A dummy variable (1 or 0). List as 1 if the resident has an r, which stands for "resides"--boarder or renter or non-householding adult family member (e.g., wife)
19
house_num
The house number--"123" if the address is 123 N. Main Street
20
street
The Street Name--"N Main Street" if the address is 123 N. Main Street. This can also be the city (if the only thing listed) and can also include the apt #
21
full_address
Merged version of house number and street
22
phone
The phone number (if listed). It will look like this: LI 66307
23
notes
Employees when a business is the first listing. Can also indicate if there's a second H before the business
24
group
Group for breaking this spreadsheet into subsheets (no longer used)
25
gcode_status
Original geocode status (Matched, Tied, Unmatched)
26
XX/Longitude
27
YY/Latitude
28
ga
Dummy variable: 1 if in Georgia, 0 if not
29
acc
Dummy variable: 1 if in Athens-Clarke County, 0 if not
30
hisdist_natl
Name of national historic district that includes this location
31
hisdist_local
Name of local historic district that includes this location
32
nhood_assign
Assigned neighborhood for mapping purposes
33
34
Digitizing notes
35
RD 1, 2, 3 refers to rural delivery routs
36
When the address is a building, like 3-b Pre-fab homes, the 3b is the house number and the Pre-fab homes is the street name
37
When there is a Greek organization listed along with a house mother, we list the house mother as the resident and add the frat/sorority name in the notes
38
"Rear" units can be identified in the notes
39
In a house with a married couple, the wife is often listed as a renter and sometimes without dependents listed with the husband
40
If multiple jobs are listed for one entry, duplicate the record so each job has its own line. Note the record as a duplicate in the notes so we can search for it later.
41
If there's a question on a particular record, mark a "?" in the checked column and add more info in the notes
42
Check on homeowners currently on p. 48
43
"Same" = person works where they live
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100