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?