<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: USD.org</title>
    <description>The latest articles on DEV Community by USD.org (@usd_org).</description>
    <link>https://dev.to/usd_org</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4216061%2Fb74d4e49-02cf-451c-8fe4-5cbf545b9fb9.png</url>
      <title>DEV Community: USD.org</title>
      <link>https://dev.to/usd_org</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/usd_org"/>
    <language>en</language>
    <item>
      <title>Normalizing U.S. Company Names Before You Match Them</title>
      <dc:creator>USD.org</dc:creator>
      <pubDate>Fri, 13 Nov 2026 06:43:12 +0000</pubDate>
      <link>https://dev.to/usd_org/normalizing-us-company-names-before-you-match-them-3fc5</link>
      <guid>https://dev.to/usd_org/normalizing-us-company-names-before-you-match-them-3fc5</guid>
      <description>&lt;p&gt;Company names from different sources rarely agree character for character. "The Acme Group, L.L.C.", "ACME GROUP LLC" and "Acme Group" could be one entity or three. A normalized name gives you a stable comparison key, as long as you remember what the key discards.&lt;/p&gt;

&lt;h2&gt;
  
  
  What usually needs cleaning
&lt;/h2&gt;

&lt;p&gt;&lt;strong&gt;Case and spacing.&lt;/strong&gt; Pick one case, trim the ends, and collapse repeated spaces.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Punctuation.&lt;/strong&gt; Periods, commas, and quotes are noise. Curly and straight apostrophes should end up identical, or be removed. An ampersand is safest as the word "and."&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Accents.&lt;/strong&gt; "Peña" and "Pena" should compare equal. Unicode normalization followed by an ASCII fold handles the common cases.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Legal endings.&lt;/strong&gt; LLC and L.L.C., Inc. and Incorporated, Corp. and Corporation, Co. and Company, Ltd. and Limited, plus LP, LLP, and PLLC. Map the spellings to one short form and move it out of the name into a field of its own. It tells you the entity type, and "Acme Inc" and "Acme LLC" can be two separate legal entities.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;A leading "The".&lt;/strong&gt; Sources disagree on whether to keep it, so the key should not depend on it.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;Trade names.&lt;/strong&gt; A string like "Acme Group LLC dba Bright Path" holds two names. Split on dba, d/b/a, aka, or fka and keep both parts, labeled. Matching on the trade name alone can attach a record to the wrong legal entity.&lt;/p&gt;

&lt;h2&gt;
  
  
  Same name, different state
&lt;/h2&gt;

&lt;p&gt;Identical names across states are common, because each state checks name availability only against its own registry. A key that ignores the state will merge strangers. Put the state, or the registry the record came from, into the key, and treat a cross-state match as a lead to confirm with other fields.&lt;/p&gt;

&lt;h2&gt;
  
  
  A teaching example
&lt;/h2&gt;

&lt;p&gt;This is a teaching example, not production code. It returns the state, the core name, the entity-type ending, and any trade name found after dba, aka, or fka.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight python"&gt;&lt;code&gt;&lt;span class="k"&gt;import&lt;/span&gt; &lt;span class="n"&gt;re&lt;/span&gt;
&lt;span class="k"&gt;import&lt;/span&gt; &lt;span class="n"&gt;unicodedata&lt;/span&gt;
&lt;span class="no"&gt;ENDINGS&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="s2"&gt;"INCORPORATED"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"INC"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s2"&gt;"CORPORATION"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"CORP"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s2"&gt;"COMPANY"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"CO"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s2"&gt;"LIMITED"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"LTD"&lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt;
&lt;span class="no"&gt;ENDINGS&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;update&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="n"&gt;e&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="n"&gt;e&lt;/span&gt; &lt;span class="k"&gt;for&lt;/span&gt; &lt;span class="n"&gt;e&lt;/span&gt; &lt;span class="k"&gt;in&lt;/span&gt; &lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="s2"&gt;"LLC"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s2"&gt;"INC"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s2"&gt;"CORP"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s2"&gt;"CO"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s2"&gt;"LTD"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s2"&gt;"LP"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s2"&gt;"LLP"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s2"&gt;"PLLC"&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;span class="no"&gt;ALIAS&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;re&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nb"&gt;compile&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;r&lt;/span&gt;&lt;span class="s2"&gt;"\b(?:D[./]?B[./]?A|A[./]?K[./]?A|F[./]?K[./]?A)\b\.?"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;re&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="no"&gt;I&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;

&lt;span class="k"&gt;def&lt;/span&gt; &lt;span class="nf"&gt;words&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;text&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;
    &lt;span class="n"&gt;text&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;unicodedata&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;normalize&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="s2"&gt;"NFKD"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;text&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;encode&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="s2"&gt;"ascii"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s2"&gt;"ignore"&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;decode&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
    &lt;span class="n"&gt;text&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;text&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;upper&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;replace&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="s2"&gt;"&amp;amp;"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s2"&gt;" AND "&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;replace&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="s2"&gt;"."&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s2"&gt;""&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;replace&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="s2"&gt;"'"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s2"&gt;""&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
    &lt;span class="k"&gt;return&lt;/span&gt; &lt;span class="n"&gt;re&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;findall&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;r&lt;/span&gt;&lt;span class="s2"&gt;"[A-Z0-9]+"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;text&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;

&lt;span class="k"&gt;def&lt;/span&gt; &lt;span class="nf"&gt;company_key&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;raw&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;state&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;
    &lt;span class="n"&gt;legal&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="o"&gt;*&lt;/span&gt;&lt;span class="n"&gt;alias&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="no"&gt;ALIAS&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;split&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;raw&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;maxsplit&lt;/span&gt;&lt;span class="o"&gt;=&lt;/span&gt;&lt;span class="mi"&gt;1&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
    &lt;span class="n"&gt;core&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="nf"&gt;words&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;legal&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
    &lt;span class="n"&gt;ending&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="no"&gt;ENDINGS&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;get&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;core&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="o"&gt;-&lt;/span&gt;&lt;span class="mi"&gt;1&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s2"&gt;""&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt; &lt;span class="k"&gt;if&lt;/span&gt; &lt;span class="n"&gt;core&lt;/span&gt; &lt;span class="k"&gt;else&lt;/span&gt; &lt;span class="s2"&gt;""&lt;/span&gt;
    &lt;span class="k"&gt;while&lt;/span&gt; &lt;span class="n"&gt;core&lt;/span&gt; &lt;span class="ow"&gt;and&lt;/span&gt; &lt;span class="n"&gt;core&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="o"&gt;-&lt;/span&gt;&lt;span class="mi"&gt;1&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt; &lt;span class="k"&gt;in&lt;/span&gt; &lt;span class="no"&gt;ENDINGS&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;
        &lt;span class="n"&gt;core&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;pop&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
    &lt;span class="n"&gt;core&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;core&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="mi"&gt;1&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt; &lt;span class="k"&gt;if&lt;/span&gt; &lt;span class="n"&gt;core&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="mi"&gt;1&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt; &lt;span class="o"&gt;==&lt;/span&gt; &lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="s2"&gt;"THE"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt; &lt;span class="k"&gt;else&lt;/span&gt; &lt;span class="n"&gt;core&lt;/span&gt;
    &lt;span class="k"&gt;return&lt;/span&gt; &lt;span class="n"&gt;state&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;upper&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s2"&gt;" "&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;join&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;core&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;ending&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s2"&gt;" "&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;join&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="nf"&gt;words&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="s2"&gt;""&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;join&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;alias&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Two calls show the behavior, including an edge case:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight python"&gt;&lt;code&gt;&lt;span class="nf"&gt;company_key&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="s2"&gt;"The Acme Group, L.L.C. d/b/a Bright Path"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s2"&gt;"tx"&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;span class="c1"&gt;# ('TX', 'ACME GROUP', 'LLC', 'BRIGHT PATH')&lt;/span&gt;
&lt;span class="nf"&gt;company_key&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="s2"&gt;"Peña &amp;amp; Co."&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s2"&gt;"or"&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;span class="c1"&gt;# ('OR', 'PENA AND', 'CO', '')&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;The second result leaves a dangling AND, because "&amp;amp; Co." is really part of how that firm writes its name. Rules like these are blunt, and every ruleset produces cases like this one.&lt;/p&gt;

&lt;p&gt;Order matters as well. Split off the trade name before removing punctuation, or "d/b/a" falls apart into loose letters that look like part of the name.&lt;/p&gt;

&lt;p&gt;To keep the rules honest, build a small table of pairs you know are the same entity and pairs you know are not, and rerun it whenever you change a rule. A fix for one case often breaks another.&lt;/p&gt;

&lt;h2&gt;
  
  
  What the key throws away
&lt;/h2&gt;

&lt;p&gt;Normalization is lossy on purpose. Store the raw name next to the key, keep the ending and the trade name as separate fields, and never treat an equal key as proof of identity. Confirm with something the name cannot fake: a registry ID, a formation date, or a principal address.&lt;/p&gt;

&lt;p&gt;&lt;em&gt;This post was drafted with the help of AI tools.&lt;/em&gt;&lt;/p&gt;

</description>
      <category>python</category>
      <category>data</category>
      <category>beginners</category>
      <category>tutorial</category>
    </item>
    <item>
      <title>Designing a scoring method you can audit: notes from USD.org</title>
      <dc:creator>USD.org</dc:creator>
      <pubDate>Thu, 29 Oct 2026 21:01:57 +0000</pubDate>
      <link>https://dev.to/usd_org/designing-a-scoring-method-you-can-audit-notes-from-us-directory-2h0k</link>
      <guid>https://dev.to/usd_org/designing-a-scoring-method-you-can-audit-notes-from-us-directory-2h0k</guid>
      <description>&lt;p&gt;USD.org Local Business Directory describes local service businesses using public records, and it publishes the method behind every listing. A few design choices make that method something a reader, or a developer, can audit instead of trust blindly.&lt;/p&gt;

&lt;h2&gt;
  
  
  Missing data is not a zero
&lt;/h2&gt;

&lt;p&gt;When a fact cannot be checked, the factor stays unscored and its weight is redistributed to the factors that could be checked. A company is neither punished nor rewarded for a gap in the record. Positive-practice factors with nothing to read get a neutral value capped at 0.5, so silence never looks like excellence.&lt;/p&gt;

&lt;h2&gt;
  
  
  Evidence has a strength
&lt;/h2&gt;

&lt;p&gt;Every fact carries the strength of its origin: 1.0 for an agency record, 0.8 for a file published on the company's site, 0.6 for a precise statement, 0.35 for a loose claim. Values that rest on site statements alone are capped at 0.6.&lt;/p&gt;

&lt;h2&gt;
  
  
  Additive contributions
&lt;/h2&gt;

&lt;p&gt;The score is a weighted average over checked factors, and each factor's contribution is reported separately. Because contributions sum exactly to the score, a reader can see which factor moved it and by how much.&lt;/p&gt;

&lt;h2&gt;
  
  
  Score and confidence are separate numbers
&lt;/h2&gt;

&lt;p&gt;Confidence measures how much of the picture was checked and how strong that evidence is, with a bonus for independent source families. A weak license match lowers confidence without changing the score.&lt;/p&gt;

&lt;h2&gt;
  
  
  Ranks must survive noise
&lt;/h2&gt;

&lt;p&gt;Before a list shows rank numbers, the weights are randomly redrawn 500 times. If the leading places shift too much, the list falls back to tiers without numbers.&lt;/p&gt;

&lt;h2&gt;
  
  
  Versioned and machine-readable
&lt;/h2&gt;

&lt;p&gt;Factors have stable identifiers; a factor whose meaning changes gets a new one. The full method is published as a machine-readable file in a public repository, alongside the human-readable text.&lt;/p&gt;

&lt;p&gt;Read the methodology at &lt;a href="https://usd.org/methodology/" rel="noopener noreferrer"&gt;usd.org&lt;/a&gt;.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://usd.org/" rel="noopener noreferrer"&gt;USD.org&lt;/a&gt;&lt;/p&gt;

</description>
      <category>datascience</category>
      <category>opendata</category>
      <category>transparency</category>
      <category>algorithms</category>
    </item>
  </channel>
</rss>
