Search found 227 matches

by EPO / PATSTAT Support
Thu Sep 03, 2020 11:46 am
Forum: PATSTAT Product Line
Topic: Summer School on Data and Algorithms for Science, Technology & Innovation studies: 16-18 September 2020
Replies: 0
Views: 470

Summer School on Data and Algorithms for Science, Technology & Innovation studies: 16-18 September 2020

To all PATSTAT users, The fifth edition of the “Summer School on Data and Algorithms for Science, Technology & Innovation studies” will as planned take place between 16-18 September at KU Leuven (Belgium). Some of you participated last year, when the event (as well as the PATSTAT user day) took plac...
by EPO / PATSTAT Support
Tue Sep 01, 2020 10:50 am
Forum: PATSTAT Product Line
Topic: Search codes for transnational cooperation patents
Replies: 5
Views: 1538

Re: Search codes for transnational cooperation patents

Hello Faery, in depth citation network analysis, using citation networks requires advanced and sometimes complex data aggregation models. Researchers go through quite some different considerations as to what and how to do "the counts" in function of the research question. For example: limiting to ci...
by EPO / PATSTAT Support
Mon Aug 31, 2020 8:39 am
Forum: PATSTAT Product Line
Topic: PATSTAT Globa--tls207_pers_appln
Replies: 1
Views: 413

Re: PATSTAT Global--tls207_pers_appln

Hello Yekai, you can easily check the number of records for tls201 and tls207 with the following query: select count (appln_id) from tls207_pers_appln; select count (appln_id) from tls201_appln; They give respective 265 and 105 million records. It is however correct that not all applications have ap...
by EPO / PATSTAT Support
Wed Aug 19, 2020 4:01 pm
Forum: PATSTAT Product Line
Topic: Should we set a time window when computing generality or originality index?
Replies: 1
Views: 219

Re: Should we set a time window when computing generality or originality index?

Hello Darwin, your reasoning is correct that the purpose of the time frame is to avoid bias by the publications that have been "longer around". I have seen studies (Harhoff) that use 5 years, we used 3 years in our getting started paper. Getting started with Patstat_20140401.pdf The bigger your time...
by EPO / PATSTAT Support
Mon Aug 17, 2020 4:01 pm
Forum: PATSTAT Product Line
Topic: difference between CITED_PAT_PUBLN_ID and CITED_APPLN_ID
Replies: 2
Views: 501

Re: difference between CITED_PAT_PUBLN_ID and CITED_APPLN_ID

Citations can refer to an application, but mostly (99.5%) they refer to publications . So the cited_appln_id is not an alternative key to get to cited patent publication in the same record. It is simply another citation. For info: most of the references to applications originate from the applicants ...
by EPO / PATSTAT Support
Fri Aug 14, 2020 1:33 pm
Forum: European Patent Register and Register Alert
Topic: Change in URL format?
Replies: 5
Views: 360

Re: Change in URL format?

Dear Cameron, in principle, this URL change should not have happened at all because it broke many links coming from various applications. And when URL's change, we establish URL re-directs to avoid broken links. The problem seems to have originated from a change in the re-direct links and not the ap...
by EPO / PATSTAT Support
Fri Aug 14, 2020 1:18 pm
Forum: European Patent Register and Register Alert
Topic: Change in URL format?
Replies: 5
Views: 360

Re: Change in URL format?

Dear Cameron, thank you for pointing out the broken link(s). Yes we had seen it, and our team is looking into fixing the issue. The link from ESPACENET to Register should be working by now. The right-click link in the Register is not working - because it also used the broken link. Other users or app...
by EPO / PATSTAT Support
Thu Aug 13, 2020 12:24 pm
Forum: PATSTAT Product Line
Topic: Revision and changes on the CPC Y-tags.
Replies: 0
Views: 546

Revision and changes on the CPC Y-tags.

A number of PATSTAT users have observed that a substantial amount of CPC Y-tags are no longer available via the CPC browser in ESPACENET ( https://worldwide.espacenet.com/patent/cpc-browser#!/CPC=Y02T10/144 ), but they still are available in PATSTAT, and even in ESPACENET when you search for them vi...
by EPO / PATSTAT Support
Wed Jul 15, 2020 3:34 pm
Forum: PATSTAT Product Line
Topic: Time window to control forward-citations
Replies: 4
Views: 934

Re: Time window to control forward-citations

Here is your query with a count of the forward citations. SELECT a.appln_id, a.appln_nr_epodoc, a.appln_auth, a.appln_filing_year, a.ipr_type, a.granted, a.docdb_family_id, a.nb_citing_docdb_fam, a.nb_applicants, a.nb_inventors, tls206_person.psn_id, tls206_person.psn_name, count(distinct(e.pat_publ...
by EPO / PATSTAT Support
Tue Jul 14, 2020 1:11 pm
Forum: PATSTAT Product Line
Topic: PATSTAT Online: use of STRING_AGG(...) and aliases problem
Replies: 0
Views: 499

PATSTAT Online: use of STRING_AGG(...) and aliases problem

Many PATSTAT Online users ask how to create "lists" that "group" data which is split over a number of different tables. PATSTAT is a relational data base, and -as you might expect- most of the data is what we call "normalised" in order to reduce data redundancy and improve data integrity. A disadvan...