What counts as a visit? A data dictionary for a repair meetup
· Complexity and Society editorial desk · Worked example and worksheet
Three people stop at the intake desk. Two bring two broken items each. The third asks about next month’s opening hours and brings nothing. At the end of the session one volunteer reports three visits and another reports four items. Both counted correctly. A spreadsheet column headed “total” loses the distinction.
1. Give each number a unit and a counting rule
In this fictional meetup, one spreadsheet row covers one session. intake_visits counts stops at the desk, including questions. items_presented counts physical items brought to the desk. A return to the desk counts as another stop under this rule, so visits cannot tell you how many different people attended. The USGS guide to data dictionaries describes recording field names, definitions, formats and permissible values. Put those details beside the data where the next recorder can find them.
Try the rule on the opening example. The item counts are 2 + 2 + 0 = 4. Each of the three stops counts as one visit. If next month’s desk also accepts telephone enquiries, agree whether the desk tally includes a call before combining the months. The meetup boundary map helps identify who can settle that decision.
2. Record zero only when someone could count
A staffed desk with three enquiries and no items has three visits and zero items. An unattended desk with no tally sheet has an unknown number of visits and items. Leave the unobserved number blank and record why. A zero in that row would suggest somebody watched an empty desk.
3. Date any change in what a field includes
Suppose the group decides that from December 1 it wants to count only stops involving a repair item. On the example above, the new measure is two stops. Keep the old definition with its end date and give the narrower field a separate name, such as visits_with_items. Four items, three stops and two stops with items answer three different questions. A chart can show a break where the definition changed.
The example field dictionary records the units, counting rules, missing values, effective dates and responsible role. The dates describe the fictional exercise. For a worked example of what a steady total can conceal, read comparing recurring community observations.