Comments (4)
The citations on patents.google.com for this document all come from "family" citations (citations to another publication in the same family as US-9824690-B2). US-9824690-B2 itself is not cited by any other patent publication.
The family_id field will let you aggregate all citations to a family with a few JOINs.
See for info on families: https://www.epo.org/searching-for-patents/helpful-resources/first-time-here/patent-families.html
from patents-public-data.
For example the third family citation listed on US-9824690-B2 is US20140074272A1. If you look at the citations of US20140074272A1 it cites US9108450B2 which is a family member of US9824690B2 (see the "Worldwide applications" list of country codes for all of the family members).
SELECT publication_number FROM (
SELECT family_id FROM patents-public-data.patents.publications
WHERE publication_number = "US-9824690-B2"
) pubs
LEFT JOIN patents-public-data.patents.publications
family_pubs ON family_pubs.family_id = pubs.family_id
Row | publication_number | |
---|---|---|
1 | US-9824690-B2 | |
2 | US-9349374-B2 | |
3 | US-9108450-B2 | |
4 | US-2013292881-A1 | |
5 | US-2015348557-A1 | |
6 | US-2013297320-A1 | |
7 | US-9404200-B2 | |
8 | US-2016260432-A1 |
This will select 126 citing publication numbers. On patents.google.com we de-duplicate by the citing publication's family_id when two publications (e.g. the US and EP version) cite the same publication.
SELECT pubs.family_id, family_pubs.publication_number AS family_publication, citations.citing_pub_number FROM (
SELECT family_id FROM patents-public-data.patents.publications
WHERE publication_number = "US-9824690-B2"
) pubs
LEFT JOIN patents-public-data.patents.publications
family_pubs ON family_pubs.family_id = pubs.family_id
LEFT JOIN (
SELECT pubs.publication_number AS citing_pub_number, cite.publication_number AS cited_pub_number
FROM patents-public-data.patents.publications
pubs, UNNEST(citation) AS cite
) AS citations ON family_pubs.publication_number = citations.cited_pub_number
Row | family_id | family_publication | citing_pub_number | |
---|---|---|---|---|
20 | 49511931 | US-2013297320-A1 | US-10803501-B1 | |
21 | 49511931 | US-2013297320-A1 | CN-110570847-A | |
22 | 49511931 | US-2013297320-A1 | CN-108656558-A | |
23 | 49511931 | US-2013297320-A1 | US-11004126-B1 | |
24 | 49511931 | US-2013297320-A1 | CN-107521088-A | |
25 | 49511931 | US-2013297320-A1 | US-10979581-B2 | |
26 | 49511931 | US-2013297320-A1 | US-9349374-B2 | |
27 | 49511931 | US-2013297320-A1 | US-2016176118-A1 | |
28 | 49511931 | US-2013297320-A1 | US-2022124208-A1 | |
29 | 49511931 | US-2013297320-A1 | US-10079016-B2 | |
30 | 49511931 | US-2013297320-A1 | US-2015205544-A1 | |
31 | 49511931 | US-2013297320-A1 | US-10229679-B1 | |
32 | 49511931 | US-2013297320-A1 | US-11176935-B2 | |
33 | 49511931 | US-2013297320-A1 | US-2020133594-A1 | |
34 | 49511931 | US-2013297320-A1 | US-10460342-B1 | |
35 | 49511931 | US-2013297320-A1 | US-10929904-B1 | |
36 | 49511931 | US-2013297320-A1 | US-10545481-B2 | |
37 | 49511931 | US-2013297320-A1 | US-10836110-B2 | |
38 | 49511931 | US-2013297320-A1 | US-2019068809-A1 | |
39 | 49511931 | US-2013297320-A1 | US-2015197064-A1 | |
40 | 49511931 | US-2013297320-A1 | US-11283943-B2 | |
41 | 49511931 | US-2013297320-A1 | US-2018288248-A1 | |
42 | 49511931 | US-2013297320-A1 | US-11392396-B1 | |
43 | 49511931 | US-2013297320-A1 | US-2019156825-A1 | |
44 | 49511931 | US-2013297320-A1 | US-11252286-B2 | |
45 | 49511931 | US-2013297320-A1 | US-2019061262-A1 | |
46 | 49511931 | US-2013297320-A1 | US-2015100149-A1 | |
47 | 49511931 | US-2013297320-A1 | US-11276095-B1 | |
48 | 49511931 | US-2013297320-A1 | US-11072122-B2 | |
49 | 49511931 | US-2013297320-A1 | US-10553210-B2 | |
50 | 49511931 | US-2013297320-A1 | US-10373183-B1 |
from patents-public-data.
@wetherbeei Thank you for your quick answer. I have not known about how these family citations work and still dont fully understand them. Do those family publications actually cite this publication or is this "citation" just generated for this database?
from patents-public-data.
@wetherbeei Thank you very much. I also noticed that I had a bug in my implementation something to do with case sensitivity of strings which reduced the number of results. e.g. "MakerBot" vs "Makerbot"
from patents-public-data.
Related Issues (20)
- BERT for Patents yields 1024 element array, but embedding_v1 is 64 element HOT 5
- ResourceExhaustedError while running Document_representation_from_BERT HOT 2
- Empty Tables in the Dataset
- Linking proteins and humangenes annotation preferred name to identifier HOT 9
- Converting Tensorflow Bert for Patent saved model to keras.
- How to access hidden layers? HOT 3
- How to download HOT 5
- BERT-Base
- context tokens
- Generating new Document Embeddings
- Sklearn 1.1.1 Issue HOT 1
- claim_text_extraction.ipynb df = pd.read_csv('./data/20k_G_and_H_publication_numbers.csv') workaround
- Lots of Patents in the latest patent dataset are missing a description
- Missing embedding HOT 1
- lack of "vocab"
- Description and claims are missing for JP patents data.
- Decreasing number of annotations in google patents research in recent batches
- confidence>1 for annotations in google patent research
- Large decrease in number of OCID annotations HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from patents-public-data.