Search found 425 matches
- 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 ...
- 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....
- 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...
- Mon Dec 04, 2023 3:24 pm
- Forum: PATSTAT Product Line
- Topic: New release PATSTAT 2023b - small error in tls201_appln creation script
- Replies: 2
- Views: 6466
Re: New release PATSTAT 2023b - small error in tls201_appln creation script
Yes, preferably to be consistant.
- 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.
no, we do not have such information for other patent offices.
- 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...
- 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-...
- 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...
- 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...
- 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...