How do you make a gazetteer for Dedupe when individuals have multiple addresses?

Question

According to the datamade Dedupe documentation, it seems like a gazetteer needs to have clean, distinct individual-level data.

What do you do if the individual has moved, changed jobs, etc a bunch of times? Include multiple observations per individual with the blanks intelligently filled in?

No a gazetteer is data that has already been cleaned and deduped, against which messy data can be linked. — Luke, Jul 09 '15 at 18:02

fgregg · Accepted Answer · 2015-07-09T18:16:51.677

2

If you know that a person has had multiple addresses than I would create a 'gazetteer' like this.

Address                Name      Person_ID
123 Main St.           John Doe  1
100 High St.           John Doe  1
1600 Pennsylvania Ave  John Doe  1

When you are match against this, you will have then have a second resolution step where you merge by Person_ID

edited Jul 09 '15 at 18:16

answered Jul 09 '15 at 18:07

fgregg

3,173
30
37

How do you make a gazetteer for Dedupe when individuals have multiple addresses?

1 Answers1