patents-public-data.patents.publications table has a column named "application_kind". This is different than the kind_code column which is different codes for each country's patent office. The description simply as below:
High-level kind of the application: A=patent; U=utility; P=provision; W= PCT; F=design; T=translation.
However, when I request the following query:
SELECT application_kind, count(*) FROM `patents-public-data.patents.publications` GROUP BY application_kind ORDER BY count(*) DESC
I get a result that includes many more codes as the sample below:
Is there a source to find out the other types of application kinds?