government
6 government types: 1 a sibling also accepts and reads alike, 2 that decompose into parts.
The 6 government types
Each type's first registry sample, against every sibling's rule
| Type | Sample | Also accepted by |
|---|---|---|
Indian PAN pan_india · VARCHAR | ABCPD1234E | eu_vat |
Australian Business Number abn · VARCHAR | 51 824 753 556 | — |
US Employer Identification Number ein · VARCHAR | 12-3456789 | — |
EU VAT Number eu_vat · VARCHAR | DE123456789 | — |
US Social Security Number ssn · VARCHAR | 078-05-1120 | — |
Vehicle Identification Number vin · VARCHAR | 1HGBH41JXMN109186 | — |
Which government type is it?
2 of 6 government types accept it, and read it alike.
DuckDB cannot run one of these types' rules, so the box cannot say whether it accepts a value.
| Type | Reads it as |
|---|---|
Indian PAN pan_india | ABCPD1234E |
EU VAT Number eu_vat | ABCPD1234E |
Use it
CLI · DuckDB
$ printf '%s\n' 'ABCPD1234E' 'AAACB0000C' > column.txt
$ finetype infer -f column.txt --mode column
SELECT ft_profile(v) FROM (VALUES ('ABCPD1234E'), ('AAACB0000C')) t(v);