Skip to main content
 
 
 
IN THIS SECTION
3 posts
f.sun
Last seen: 07/18/2022 - 16:41
Joined: 07/07/2022 - 00:02
patent.tsv: difference between `id` and `number` columns

I have loaded the data provided by patent.csv into a database, and it seems that for each row, the id field and number field contain the same string.

I tested this by running the following SQL:

SELECT * FROM patent WHERE id != number;

This returned zero rows.

I'm confused, why are there two columns with the same content?

PVTeam
Role: moderator
Last seen: 03/15/2024 - 15:25
Joined: 10/17/2017 - 10:47
Hello! You are correct,…

Hello! You are correct, these two fields are the same. In our current harmonization effort, these columns will be turned into one column. We are planning to release detailed information about the changes to the bulk downloads later this month. The data downloads themselves will be updated to reflect the information in September. If you would like to get this information and are not already receiving our emails, please consider signing up to get our newsletter (we send something roughly every 2-3 months). 

Thank you,

PVTeam

f.sun
Last seen: 07/18/2022 - 16:41
Joined: 07/07/2022 - 00:02
Thanks!

Thanks!