Wikidata:Property proposal/FDIC Certificate ID
Jump to navigation
Jump to search
FDIC Certificate ID[edit]
Originally proposed at Wikidata:Property proposal/Organization
| Description | unique number assigned to a depository institution by the Federal Deposit Insurance Corporation |
|---|---|
| Represents | FDIC Certificate ID (Q114820841) |
| Data type | External identifier |
| Domain | bank (Q22687) |
| Allowed values | [0-9]+ |
| Example 1 | Cadence Bank (Q5016370) → 4999 |
| Example 2 | Cadence Bank (Q4854138) → 11813 |
| Example 3 | Superior Bancorp (Q7643493) → 59026 |
| Source | https://www.ffiec.gov/npw/Help/Help |
| Number of IDs in source | 91,393 as of 2022-10-21 |
| Expected completeness | always incomplete (Q21873886) |
| Implied notability | Wikidata property for an identifier that suggests notability (Q62589316) |
| Formatter URL | https://banks.data.fdic.gov/bankfind-suite/bankfind/details/$1 |
| See also | NCUA Charter ID |
| Single-value constraint | yes |
| Distinct-values constraint | yes |
Mục đích[edit]
Linking to the FDIC's BankFind Suite tool makes it easier to verify inception (P571) and other statements on U.S. banks across successive mergers and acquisitions, avoiding confusion when holding companies become involved. Minh Nguyễn 💬 06:32, 23 October 2022 (UTC)
Discussion[edit]
Will you be creating a Mix'n'Match for this when the property is created? Lectrician1 (talk) 19:22, 23 October 2022 (UTC)
- @Lectrician1: How does Mix'n'Match compare to OpenRefine in terms of ensuring correct matches? The FDIC has records on all the banks it has ever regulated, which means there are lots of records with similar names – nearly 3,000 named "First National Bank", for example. Mergers and acquisitions cause names to get... mixed and matched all the time. Thanks to Wikipedia, Wikidata's coverage of U.S. banks is extremely messy, full of anachronisms and conflations (especially with holding companies), but semiautomated matching would make things even harder to untangle. Minh Nguyễn 💬 22:15, 23 October 2022 (UTC)
- Idk. I haven't used OpenRefine. Lectrician1 (talk) 22:47, 23 October 2022 (UTC)
- OpenRefine is great for this Germartin1 (talk) 04:43, 8 November 2022 (UTC)
Support 22:48, 23 October 2022 (UTC)
