Search found 425 matches

by EPO / PATSTAT Support
Tue Jan 02, 2024 2:02 pm
Forum: PATSTAT Product Line
Topic: I have loading problems for some files for tls203 and tls206 tables.
Replies: 3
Views: 827

Re: I have loading problems for some files for tls203 and tls206 tables.

Hello Bessie, the character code should be compatible with standard UTF8. Then there should be no problems. Latin1 will normally not work for some rows because the names (and then specific text in the [person_name_orig_lg] will contain text in cyrillic, Japanese, Chinese, Korean,... characters. Are ...
by EPO / PATSTAT Support
Tue Jan 02, 2024 12:29 pm
Forum: PATSTAT Product Line
Topic: I work on a project regarding the use of IP as collateral for firms' lending activities
Replies: 1
Views: 518

Re: I work on a project regarding the use of IP as collateral for firms' lending activities

Hello Soperypear, As far as I know, there is not much information available in the INPADOC data with regards to using patents as colatoral, except then for the US patents. There are no specific codes neither; for the US, they are "stored" as a transfer of ownership, which would make sense....
by EPO / PATSTAT Support
Tue Jan 02, 2024 11:21 am
Forum: PATSTAT Product Line
Topic: Forward citations on t+5 and what cites what
Replies: 4
Views: 1463

Re: Forward citations on t+5 and what cites what

Hello Dalila, A couple of small remarks: don't forget that you have add "invt_seq_nr > 0" if you want to only have the GB inventor (and exclude the applicants.) About NUTs codes: they are only available where there are addresses available. That means: mainly EP applications. Have a look at...
by EPO / PATSTAT Support
Tue Nov 28, 2023 12:57 pm
Forum: PATSTAT Product Line
Topic: PUBLN_CLAIMS
Replies: 1
Views: 4062

Re: PUBLN_CLAIMS

Hello Mengfan,
no, we do not have such information for other patent offices.
by EPO / PATSTAT Support
Thu Nov 23, 2023 3:38 pm
Forum: PATSTAT Product Line
Topic: Citation
Replies: 2
Views: 8261

Re: Citation

Anyway difficult to answer as you work with specific user defined tables where only you know the content. But one can easily examine the balance between companies/individuals with the below query. As you can see there are large variations. Typical for the US where the ratio is 50/50 because inventor...
by EPO / PATSTAT Support
Wed Nov 22, 2023 3:09 pm
Forum: PATSTAT Product Line
Topic: Data retrieval of the patent references possible ?.
Replies: 5
Views: 19502

Re: Data retrieval of the patent references possible ?.

Fully agree; for information on the "Open Patent Services" (OPS) have a look here: https://www.epo.org/en/searching-for-patents/data/web-services/ops OPS-FAQ's : https://www.epo.org/en/service-support/faq/searching-patents/open-patent-services OPS-Forum: https://forums.epo.org/open-patent-...
by EPO / PATSTAT Support
Wed Nov 22, 2023 2:19 pm
Forum: PATSTAT Product Line
Topic: New release PATSTAT 2023b - small error in tls201_appln creation script
Replies: 2
Views: 6466

New release PATSTAT 2023b - small error in tls201_appln creation script

It seems that a small error has sneaked into the script to create tls201_appln. The re-introduced attribute [appln_nr_epodoc] was ommitted. Below is a correction. USE [patstat2023b] GO /****** Object: Table [dbo].[tls201_appln] Script Date: 08/03/2022 13:30:00 ******/ SET ANSI_NULLS ON GO SET QUOTED...
by EPO / PATSTAT Support
Mon Nov 20, 2023 11:37 am
Forum: PATSTAT Product Line
Topic: Citation added
Replies: 5
Views: 10138

Re: Citation added

At the EPO, citations can be added throughout the different (possible) stages of the application, granting, appeal or opposition procedure(s). (See attribute citn_origin in tls212 have an overview, and this document for coverage: REFI Statistics July 2023.pdf for PATSTAT coverage.) Because of the da...
by EPO / PATSTAT Support
Mon Nov 20, 2023 10:38 am
Forum: PATSTAT Product Line
Topic: Number of patents and patents applications per company
Replies: 3
Views: 5649

Re: Number of patents and patents applications per company

Hello David, for a correct query, kindly see the answer to Sina's post. Or check: https://forums.epo.org/sql-queries-to-create-simple-applicant-year-based-table-10588 PATSTAT does not have a data item that could help users to identify (not) listed companies. The psn_sector attribute in tls206_person...