*** Sorry for the duplicate posts, just realize this is the appropriate thread *** Hello again, I'm sorry to bombard you with a lot of questions but this is the first time I use PATSTAT for research purposes and I'm not quite sure how to go along. I've been trying to figure out how to compute backwa...

*** Sorry for the duplicate posts, just realize this is the appropriate thread *** Hello again, I'm reading the PATSTAT data catalog v.5 06 and I have a question re row data in TLS211_PAT_PUBLN. Do I understand correctly that the data in TLS211 when related to TLS201 provides additional information ...

Hello again, I'm sorry to bombard you with a lot of questions but this is the first time I use PATSTAT for research purposes and I'm not quite sure how to go along. I've been trying to figure out how to compute backwards and forward citations. I understand that on a family level there is NB_CITING_D...

Dear Martin, I have a follow-up question. Why when I use both CPC and IPC codes in the same search using "and" I'm getting fewer results. This is the query: select distinct app.* from TLS201_APPLN app, TLS224_APPLN_CPC cpc, TLS209_APPLN_IPC ipc where 1=1 and app.appln_id=cpc.appln_id and a...

Dear Martin,
Thank you so much for the help!
Best,
Talya

Hello, I've read all the threads on CPC search here. I have constructed the following query (this is just for getting a feeling with how to work with patstat): select tls201_appln.appln_id, appln_auth, appln_nr, appln_kind, appln_filing_date, granted, nb_citing_docdb_fam, cpc_position, cpc_class_sym...

Thanks again Geert for the help!

Hello,
I'm trying to figure out how to use Patstat. Can anyone tell me where can I find the following:
1. Tables and columns descriptions
2. ERD
3. If there are codes used in the database, is there a list of all the codes ?
Thanks in advance!
Talya