Patent Publication Research
Posted: Thu Jun 07, 2018 7:26 am
Hi.
I am performing a research on PATSTAT 2018 Autumn of patent publication, citation of patent publication and replenished patent publication, encompassing the following fields:
- TLS206_PERSON
- PERSON_ID
- PERSON_CTRY_CODE
- PSN_NAME
- PSN_SECTOR
- TLS211_PAT_PUBLN
- APPLN_ID
- PAT_PUBLN_ID
- PUBLN_DATE
- PUBLN_KIND
- TLS212_CITATION
- CITED_APPLN_ID
- CITED_PAT_PUBLN_ID
- CITN_REPLENISHED
- TLS227_PERS_PUBLN
- PERSON_ID
- PAT_PUBLN_ID
- TLS230_APPLN_TECHN_FIELD
- APPLN_ID
- TECHN_FIELD_NR
Where I am counting the amount of published patent, citation of published patent and replenished patent publication by 'company' (PSN Sector) only, by year (Publn_Date) from 1975-01-01 to 2017-12-31 (9999-12-31 has to be out of the sample), and all rows and tables mentioned above.
Published patent, citation of published patent and replenished patent publication field contents must not repeat or be empty (null value or '0').
For organization purpose, it is important to add a row sequential number of the line on the table (row number function) so it will be possible to properly order the information.
Thank you very much for your attention.
Appreciate it.
Flavio Taques.
I am performing a research on PATSTAT 2018 Autumn of patent publication, citation of patent publication and replenished patent publication, encompassing the following fields:
- TLS206_PERSON
- PERSON_ID
- PERSON_CTRY_CODE
- PSN_NAME
- PSN_SECTOR
- TLS211_PAT_PUBLN
- APPLN_ID
- PAT_PUBLN_ID
- PUBLN_DATE
- PUBLN_KIND
- TLS212_CITATION
- CITED_APPLN_ID
- CITED_PAT_PUBLN_ID
- CITN_REPLENISHED
- TLS227_PERS_PUBLN
- PERSON_ID
- PAT_PUBLN_ID
- TLS230_APPLN_TECHN_FIELD
- APPLN_ID
- TECHN_FIELD_NR
Where I am counting the amount of published patent, citation of published patent and replenished patent publication by 'company' (PSN Sector) only, by year (Publn_Date) from 1975-01-01 to 2017-12-31 (9999-12-31 has to be out of the sample), and all rows and tables mentioned above.
Published patent, citation of published patent and replenished patent publication field contents must not repeat or be empty (null value or '0').
For organization purpose, it is important to add a row sequential number of the line on the table (row number function) so it will be possible to properly order the information.
Thank you very much for your attention.
Appreciate it.
Flavio Taques.