Search found 440 matches
- Thu Nov 23, 2023 3:38 pm
- Forum: PATSTAT Product Line
- Topic: Citation
- Replies: 2
- Views: 11990
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: 3
- Views: 20600
Re: Data retrieval of the patent references possible ?.
Or have a look at the "Open Patent Services" (OPS) 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-services-ops-and-bulk-data...
- 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: 6808
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: 14920
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: 5775
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...
- Fri Nov 10, 2023 12:02 pm
- Forum: PATSTAT Product Line
- Topic: New patent insight report on "Offshore wind energy"-using PATSTAT data-.
- Replies: 0
- Views: 9425
New patent insight report on "Offshore wind energy"-using PATSTAT data-.
EPO's patent insight reports focus on future and emerging technologies. They are designed to provide and discover valuable insights into potentially disruptive technologies. The underlying data for these reports is mostly extracted from the PATSTAT data base. Also the methodology is published and yo...
- Thu Oct 12, 2023 2:20 pm
- Forum: PATSTAT Product Line
- Topic: Patents Applications filed for narrow countries - summary per applicant - please HELP
- Replies: 1
- Views: 4441
Re: Patents Applications filed for narrow countries - summary per applicant - please HELP
Hello Marec, PATSTAT is a relational database, so it is not so easy to combine data that comes from many tables from the database in 1 "excel like" data sheet. The reason is that many attributes will have multiple occurrences, 1 application can have multiple publications with different dat...
- Thu Oct 12, 2023 2:12 pm
- Forum: PATSTAT Product Line
- Topic: Codes (e.g. Language Codes, Country Codes, etc.)
- Replies: 1
- Views: 4233
Re: Codes (e.g. Language Codes, Country Codes, etc.)
Hello, in principle, WIPO ST3 codes are used for country --> appln_auth, country code in tls206,... (and organisations: EP, WO, etc..) codes. It does happen however that deviations enter the data, for example 'UK' for Great Britain, or 'JA' for Japan, 'PR' for Puerto Rico, etc.. ST3_list.pdf The ST3...
- Tue Oct 10, 2023 11:18 am
- Forum: PATSTAT Product Line
- Topic: Inquiry regarding Error 1104 and Error code: 8115
- Replies: 2
- Views: 4226
Re: Inquiry regarding Error 1014 and Error code: 8115
Hello Humphery, there are plenty of posts on the topic of forward citations count. See for example: https://forums.epo.org/count-patent-applications-that-are-granted-and-forward-citation-in-specific-year-for-specific-company-12764#p40953 https://forums.epo.org/count-number-of-patent-applications-and...
- Wed Oct 04, 2023 9:57 am
- Forum: PATSTAT Product Line
- Topic: Patent applications by country by year and/or quarter.
- Replies: 3
- Views: 4836
Re: Patent applications by country by year and/or quarter.
Hallo Jens, As far as I am aware, WIPO is indeed using PATSTAT for some of its statistics, but I don't know how they compile their statistics and what method they apply for the data you are comparing with. With other words, in PATSTAT, we can 100% explain an reproduce any data compiled with PATSTAT ...