Hello William, EPO does use Elasticsearch with the free Espacenet service. https://worldwide.espacenet.com/ , and we appreciate your interest in utilising the PATSTAT database with Elasticsearch. However, PATSTAT is essentially a relational data base and not a search engine like Elasticsearch. It is...

Your query is correct, the best way to check results is to look at one single application (all publications), and see whether the result is the same as what you can see in ESPACENET or the EPO register. (small differences are possible, but it should be sufficient to confirm that all your JOINS in SQ...

No, PATSTAT does not contain the text of the claims; only titles and abstracts. If you want full text (claims, description, search data, etc...) of the patents published by the EPO, you will need to have a closer look at this: https://new.epo.org/en/searching-for-patents/data/bulk-data-sets/text-ana...

The data format (and data base model) has slightly changed between when the original topic was posted and now. This means that the "AND appln_kind = 'A' (to exclude PCT's) is not needed anymore because PCT applications now have "WO" as application authority. So adding that line will n...

Hello Chayenne, difficult to say how long it will take. That depends a lot on your server system and how you have your storage organised. But it can take indeed a bit of time. It is clear that an SSD will be a lot faster then normal "spinning" hard disks. DB systems have always a method of...

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 ...

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....

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...

Yes, preferably to be consistant.

Hello Mengfan,
no, we do not have such information for other patent offices.