I suppose the higher level aim is for a set of patents which we will understand to represent distinct inventions, which does not contain duplicate inventions. If the sets of patents connected by priority claims constitutes a family (simple family or DOCDB family?), and each family could represent an...

We aim to get a set of non duplicate granted patents. To do so we use the query: SELECT tls211_pat_publn.publn_nr, tls201_appln.appln_auth, tls211_pat_publn.publn_date, tls201_appln.appln_id FROM tls201_appln INNER JOIN tls211_pat_publn ON tls211_pat_publn.appln_id = tls201_appln.appln_id WHERE tls2...

Using the 2015 Spring Edition, and SQLite for initial querying then Python (pandas) for analysis. We are using patent data to investigate innovation generally. As a preliminary check we plotted the fractional coverage of patents with IPC and CPC classifications by year within the data base. http://i...

Using the 2015 Spring Edition, and SQLite for initial querying then Python (pandas) for analysis. While carrying out some analysis, I noticed an oddity between an application filing date and publication date - a difference of 100 years. I got to the PDF of the patent through Espacenet and indeed the...