Missing addresses in patstat ediction oct. 2013

Aside from an already announced by epo lack of data in ipc table (see here) there is another issue, this time involving address data.

The check has been run against EPO data (thanks to Xiaoyan Song from ECOOM for rising the issue)

Select
  patstat.tls207_pers_appln.PERSON_ID,
  patstat.tls207_pers_appln.APPLN_ID,
  patstat.tls207_pers_appln.APPLT_SEQ_NR,
  patstat.tls207_pers_appln.INVT_SEQ_NR,
  patstat.tls211_pat_publn.PUBLN_AUTH,
  patstat.tls206_person.PERSON_NAME,
  patstat.tls206_person.PERSON_ADDRESS,
  patstat.tls206_person.DOC_STD_NAME_ID
From
  patstat.tls206_person Inner Join
  patstat.tls207_pers_appln On patstat.tls207_pers_appln.PERSON_ID =
    patstat.tls206_person.PERSON_ID Inner Join
  patstat.tls211_pat_publn On patstat.tls211_pat_publn.APPLN_ID =
    patstat.tls207_pers_appln.APPLN_ID
Where
  patstat.tls211_pat_publn.PUBLN_AUTH = 'EP' And
  patstat.tls206_person.PERSON_ADDRESS = ""

We find that 292110 application/person have no address vs a total of 16.866.000 (about 2%).

This means many person_ids that in previous edictions had an address now have lost it.

For instance appln_id 57746196 had in oct 2012 applicant 4473356 Canon Kabushiki Kaisha with address 30-2 Shimomaruko 3-chome  Ohta-ku Tokyo.

Now appln_id 57746196 has as applicant person_id 5216598 that is still Canon Kabushiki Kaisha has no address.

In total we have 188107 person_id that suffer from this issue.

Some of them, counting by appln_id, are big players.

person_id	count(appln_id)
263	7208
5355192	1547
5238080	1333
5235181	1014
5217811	612
5818520	459
5213673	386
6156118	344
5262071	288

Person_id 263 (empty name and address) in reality has been also added in many cases where previous versions of patstat reported no applicant / inventor for a given application.