Search found 97 matches
- Fri Nov 18, 2016 2:19 pm
- Forum: PATSTAT Product Line
- Topic: NACE Rev. 2 Classification of an Applicant
- Replies: 4
- Views: 3192
Re: NACE Rev. 2 Classification of an Applicant
Find the applicant in a database such as Amadeus or Compustat and derive the NACE code from that database. In case the database does not have a NACE code, it will likely have another kind of code (e.g. SIC or NAICS) after which you will you have to apply a concordance table. The TLS229_APPLN_NACE2 t...
- Wed Nov 16, 2016 8:53 pm
- Forum: PATSTAT Product Line
- Topic: Patents with at least one inventor from Brussels
- Replies: 3
- Views: 3190
Re: Patents with at least one inventor from Brussels
Please have a look at the OECD REGPAT database. Use region code BE10 or BE100 for Brussels.
- Fri Sep 23, 2016 2:41 pm
- Forum: PATSTAT Product Line
- Topic: Patstat and R
- Replies: 1
- Views: 6300
Re: Patstat and R
What operating system are you on? Which tables are you using for your research? What error messages are you getting? Importing PATSTAT into MySQL should be rather easy... There is no official installation script for MySQL, but Gianluca generally posts these on his website http://rawpatentdata.blogsp...
- Fri Sep 23, 2016 2:33 pm
- Forum: PATSTAT Product Line
- Topic: How to retrieve applicant's address
- Replies: 5
- Views: 2981
Re: How to retrieve applicant's address
SELECT tls206_person.person_id, person_address, hrm_l2 FROM tls206_person INNER JOIN tls207_pers_appln ON tls206_person.person_id = tls207_pers_appln.person_id INNER JOIN tls201_appln ON tls207_pers_appln.appln_id = tls201_appln.appln_id WHERE tls207_pers_appln.applt_seq_nr >0 AND tls201_appln.appln...
- Tue Jun 14, 2016 7:32 pm
- Forum: PATSTAT Product Line
- Topic: Help with citations
- Replies: 3
- Views: 8146
Re: Help with citations
Learn something new every day. What Geert means is that there are two kinds of citations. Either a publication is cited and this is captured by cited_pat_publn_id, OR an application is cited -didn't know this was possible, hence the confusion- which is captured by cited_appln_id. In the latter case,...
- Mon May 16, 2016 4:16 pm
- Forum: PATSTAT Product Line
- Topic: self citation need some help
- Replies: 7
- Views: 7789
Re: self citation need some help
I don't have PATSTAT Online, but the query seems ok. You are doing a count for the cited families, which is the right way to do it for forward citations. You are also using a COUNT(DISTINCT which takes care of any double count that will occur because you are joining with TLS201. You can leave out th...
- Fri May 13, 2016 12:18 pm
- Forum: PATSTAT Product Line
- Topic: Problem with CPC
- Replies: 8
- Views: 11413
Re: Problem with CPC
When looking at citations to study influencing technologies, keep in mind that there's a difference in citation behaviour per patent office and that the EPO uses search codes to indicate the relevance of a citation. Plus you will have to correct for the source of origin to avoid double count. I don'...
- Fri May 13, 2016 12:00 pm
- Forum: PATSTAT Product Line
- Topic: triadic patents -query help
- Replies: 7
- Views: 6593
Re: triadic patents -query help
Yes, patents in the same family can have slightly different characteristics. You can take the union of all classes, the intersection, or you can select a particular patent as your single source of truth. For example the priority filing. As you are looking at Triadic Patents, there will always be a f...
- Sun Apr 24, 2016 2:49 pm
- Forum: PATSTAT Product Line
- Topic: Help with CPC
- Replies: 4
- Views: 10746
Re: Help with CPC
If you say CPC IN (A,B,C,D,E) AND IPC IN (A) then the IPC IN (A) part will severely cut down the results. AND does not add things. You'll need OR for that. I wouldn't mix IPC and CPC like this anyway. Also note that the coverage may vary, as CPC is the new classification. I think I saw a graph in on...
- Sun Apr 24, 2016 2:21 pm
- Forum: PATSTAT Product Line
- Topic: Help with citations
- Replies: 3
- Views: 8146
Re: Help with citations
Based on what I could find in the data catalogue at http://documents.epo.org/projects/babylon/eponet.nsf/0/830D207D355F3AF2C1257AA1002D0CFB/$File/patstat_data_catalog_v_5_06.pdf I think there is no variable for backward citations similar to NB_CITING_DOCDB_FAM. However, you can calculate this yourse...