Estimating US patent "oppositions"
Posted: Thu Jun 21, 2018 7:01 am
Hello!
I have been trying to find out how many "oppositions" a certain company is involved in in the USPTO.
I used PATSTAT online (spring 2018) and used "OPPOS" as lecg_name in tls803_legal_event_code. I understand "OPPOS" contains reexaminations, covered business methods, inter-partes reviews, post-grant reviews, and others. However, I find the numbers to be very underwhelming. For example, I ran the following query for Microsoft and found just 26 patents that were "opposed" and the last being in 2006. Is it possible that Microsoft was not involved in any "opposition" at the USPTO since 2006?
SELECT a.appln_id, a.appln_auth, a.appln_filing_date FROM tls201_appln a
INNER JOIN tls207_pers_appln pa ON pa.appln_id = a.appln_id
INNER JOIN tls206_person p ON p.person_id = pa.person_id
INNER JOIN tls231_inpadoc_legal_event l ON l.appln_id = pa.appln_id
INNER JOIN tls803_legal_event_code e ON e.event_code = l.event_code AND e.event_auth = l.event_auth
WHERE pa.applt_seq_nr > 0
AND (e.lecg_name = 'OPPOS' OR e.event_descr LIKE '%reexamination%')
AND e.event_auth = 'US'
AND p.han_name LIKE 'Microsoft%'
GROUP BY a.appln_id, a.appln_auth, a.appln_filing_date
ORDER BY a.appln_filing_date DESC
In addition, I ran the following query to see all possible USPTO "oppositions" since 2007. Again, I thought the numbers were too few for a patent office like USPTO:
SELECT tls231_inpadoc_legal_event.event_code, tls803_legal_event_code.event_descr,
COUNT(distinct(case when appln_filing_year = 2007 then tls201_appln.appln_id end)) as "2007",
COUNT(distinct(case when appln_filing_year = 2008 then tls201_appln.appln_id end)) as "2008",
COUNT(distinct(case when appln_filing_year = 2009 then tls201_appln.appln_id end)) as "2009",
COUNT(distinct(case when appln_filing_year = 2010 then tls201_appln.appln_id end)) as "2010",
COUNT(distinct(case when appln_filing_year = 2011 then tls201_appln.appln_id end)) as "2011",
COUNT(distinct(case when appln_filing_year = 2012 then tls201_appln.appln_id end)) as "2012",
COUNT(distinct(case when appln_filing_year = 2013 then tls201_appln.appln_id end)) as "2013",
COUNT(distinct(case when appln_filing_year = 2014 then tls201_appln.appln_id end)) as "2014",
COUNT(distinct(case when appln_filing_year = 2015 then tls201_appln.appln_id end)) as "2015",
COUNT(distinct(case when appln_filing_year = 2016 then tls201_appln.appln_id end)) as "2016",
COUNT(distinct(case when appln_filing_year = 2017 then tls201_appln.appln_id end)) as "2017"
FROM tls201_appln join tls231_inpadoc_legal_event on tls201_appln.appln_id = tls231_inpadoc_legal_event.appln_id
join tls803_legal_event_code on tls231_inpadoc_legal_event.event_auth = tls803_legal_event_code.event_auth
and tls231_inpadoc_legal_event.event_code = tls803_legal_event_code.event_code
where appln_auth = 'US'
and tls231_inpadoc_legal_event.event_auth = 'US'
AND (tls803_legal_event_code.lecg_name = 'OPPOS' OR tls803_legal_event_code.event_descr LIKE '%reexamination%')
group by tls231_inpadoc_legal_event.event_code, tls803_legal_event_code.event_descr
order by tls231_inpadoc_legal_event.event_code
I will be grateful if anybody can point out what's going on.
Thanks!
Rahul Kapoor
I have been trying to find out how many "oppositions" a certain company is involved in in the USPTO.
I used PATSTAT online (spring 2018) and used "OPPOS" as lecg_name in tls803_legal_event_code. I understand "OPPOS" contains reexaminations, covered business methods, inter-partes reviews, post-grant reviews, and others. However, I find the numbers to be very underwhelming. For example, I ran the following query for Microsoft and found just 26 patents that were "opposed" and the last being in 2006. Is it possible that Microsoft was not involved in any "opposition" at the USPTO since 2006?
SELECT a.appln_id, a.appln_auth, a.appln_filing_date FROM tls201_appln a
INNER JOIN tls207_pers_appln pa ON pa.appln_id = a.appln_id
INNER JOIN tls206_person p ON p.person_id = pa.person_id
INNER JOIN tls231_inpadoc_legal_event l ON l.appln_id = pa.appln_id
INNER JOIN tls803_legal_event_code e ON e.event_code = l.event_code AND e.event_auth = l.event_auth
WHERE pa.applt_seq_nr > 0
AND (e.lecg_name = 'OPPOS' OR e.event_descr LIKE '%reexamination%')
AND e.event_auth = 'US'
AND p.han_name LIKE 'Microsoft%'
GROUP BY a.appln_id, a.appln_auth, a.appln_filing_date
ORDER BY a.appln_filing_date DESC
In addition, I ran the following query to see all possible USPTO "oppositions" since 2007. Again, I thought the numbers were too few for a patent office like USPTO:
SELECT tls231_inpadoc_legal_event.event_code, tls803_legal_event_code.event_descr,
COUNT(distinct(case when appln_filing_year = 2007 then tls201_appln.appln_id end)) as "2007",
COUNT(distinct(case when appln_filing_year = 2008 then tls201_appln.appln_id end)) as "2008",
COUNT(distinct(case when appln_filing_year = 2009 then tls201_appln.appln_id end)) as "2009",
COUNT(distinct(case when appln_filing_year = 2010 then tls201_appln.appln_id end)) as "2010",
COUNT(distinct(case when appln_filing_year = 2011 then tls201_appln.appln_id end)) as "2011",
COUNT(distinct(case when appln_filing_year = 2012 then tls201_appln.appln_id end)) as "2012",
COUNT(distinct(case when appln_filing_year = 2013 then tls201_appln.appln_id end)) as "2013",
COUNT(distinct(case when appln_filing_year = 2014 then tls201_appln.appln_id end)) as "2014",
COUNT(distinct(case when appln_filing_year = 2015 then tls201_appln.appln_id end)) as "2015",
COUNT(distinct(case when appln_filing_year = 2016 then tls201_appln.appln_id end)) as "2016",
COUNT(distinct(case when appln_filing_year = 2017 then tls201_appln.appln_id end)) as "2017"
FROM tls201_appln join tls231_inpadoc_legal_event on tls201_appln.appln_id = tls231_inpadoc_legal_event.appln_id
join tls803_legal_event_code on tls231_inpadoc_legal_event.event_auth = tls803_legal_event_code.event_auth
and tls231_inpadoc_legal_event.event_code = tls803_legal_event_code.event_code
where appln_auth = 'US'
and tls231_inpadoc_legal_event.event_auth = 'US'
AND (tls803_legal_event_code.lecg_name = 'OPPOS' OR tls803_legal_event_code.event_descr LIKE '%reexamination%')
group by tls231_inpadoc_legal_event.event_code, tls803_legal_event_code.event_descr
order by tls231_inpadoc_legal_event.event_code
I will be grateful if anybody can point out what's going on.
Thanks!
Rahul Kapoor